{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Question","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Question","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["FN","LN","No","Item","X",null,null,null,"FN","LN"]
["Ken","Owiti",1,"SuctionChamber Plate Fixture",{"$f":"SUM(E1,AND(A2=$B$12,B2=$B$13))","v":0},null,null,null,"Ken","Owiti"]
["Ken","Owiti",2,"FootValve Fixture",{"$f":"SUM(E2,AND(A3=$B$12,B3=$B$13))","v":0},null,null,null,"Paul","Mbugua"]
["Paul","Mbugua",3,"Suction-FootValve Fixture",1,null,null,null,"Phil","Jones"]
["Paul","Mbugua",4,"ValvePlate-Frustrum Fixture",2]
["Ken","Owiti",5,"ValveBox Fixture",2]
["Ken","Owiti",6,"ValveBox Batch 1",2]
["Ken","Jones",4,"Wyte",2]
["Phil","Mbugua",1,"Pipe",2]
["Ken","Jones",9,"Valve",2]
[]
["FN","Paul"]
["LN","Mbugua"]
[]
["Count",{"$f":"MAX(E2:E10)","v":2}]
[]
["FN","LN","No","Item","X"]
[{"$f":"IF(ROWS(A$18:A18)>$B$15,\"\",INDEX(A$2:A$10,MATCH(ROWS(A$18:A18),$E$2:$E$10,0)))","v":"Paul"},{"$f":"IF(ROWS(B$18:B18)>$B$15,\"\",INDEX(B$2:B$10,MATCH(ROWS(B$18:B18),$E$2:$E$10,0)))","v":"Mbugua"},{"$f":"IF(ROWS(C$18:C18)>$B$15,\"\",INDEX(C$2:C$10,MATCH(ROWS(C$18:C18),$E$2:$E$10,0)))","v":3},{"$f":"IF(ROWS(D$18:D18)>$B$15,\"\",INDEX(D$2:D$10,MATCH(ROWS(D$18:D18),$E$2:$E$10,0)))","v":"Suction-FootValve Fixture"},{"$f":"IF(ROWS(E$18:E18)>$B$15,\"\",INDEX(E$2:E$10,MATCH(ROWS(E$18:E18),$E$2:$E$10,0)))","v":1}]
[{"$f":"IF(ROWS(A$18:A19)>$B$15,\"\",INDEX(A$2:A$10,MATCH(ROWS(A$18:A19),$E$2:$E$10,0)))","v":"Paul"},{"$f":"IF(ROWS(B$18:B19)>$B$15,\"\",INDEX(B$2:B$10,MATCH(ROWS(B$18:B19),$E$2:$E$10,0)))","v":"Mbugua"},{"$f":"IF(ROWS(C$18:C19)>$B$15,\"\",INDEX(C$2:C$10,MATCH(ROWS(C$18:C19),$E$2:$E$10,0)))","v":4},{"$f":"IF(ROWS(D$18:D19)>$B$15,\"\",INDEX(D$2:D$10,MATCH(ROWS(D$18:D19),$E$2:$E$10,0)))","v":"ValvePlate-Frustrum Fixture"},{"$f":"IF(ROWS(E$18:E19)>$B$15,\"\",INDEX(E$2:E$10,MATCH(ROWS(E$18:E19),$E$2:$E$10,0)))","v":2}]
[{"$f":"IF(ROWS(A$18:A20)>$B$15,\"\",INDEX(A$2:A$10,MATCH(ROWS(A$18:A20),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(B$18:B20)>$B$15,\"\",INDEX(B$2:B$10,MATCH(ROWS(B$18:B20),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(C$18:C20)>$B$15,\"\",INDEX(C$2:C$10,MATCH(ROWS(C$18:C20),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(D$18:D20)>$B$15,\"\",INDEX(D$2:D$10,MATCH(ROWS(D$18:D20),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(E$18:E20)>$B$15,\"\",INDEX(E$2:E$10,MATCH(ROWS(E$18:E20),$E$2:$E$10,0)))","v":""}]
[{"$f":"IF(ROWS(A$18:A21)>$B$15,\"\",INDEX(A$2:A$10,MATCH(ROWS(A$18:A21),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(B$18:B21)>$B$15,\"\",INDEX(B$2:B$10,MATCH(ROWS(B$18:B21),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(C$18:C21)>$B$15,\"\",INDEX(C$2:C$10,MATCH(ROWS(C$18:C21),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(D$18:D21)>$B$15,\"\",INDEX(D$2:D$10,MATCH(ROWS(D$18:D21),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(E$18:E21)>$B$15,\"\",INDEX(E$2:E$10,MATCH(ROWS(E$18:E21),$E$2:$E$10,0)))","v":""}]
[{"$f":"IF(ROWS(A$18:A22)>$B$15,\"\",INDEX(A$2:A$10,MATCH(ROWS(A$18:A22),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(B$18:B22)>$B$15,\"\",INDEX(B$2:B$10,MATCH(ROWS(B$18:B22),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(C$18:C22)>$B$15,\"\",INDEX(C$2:C$10,MATCH(ROWS(C$18:C22),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(D$18:D22)>$B$15,\"\",INDEX(D$2:D$10,MATCH(ROWS(D$18:D22),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(E$18:E22)>$B$15,\"\",INDEX(E$2:E$10,MATCH(ROWS(E$18:E22),$E$2:$E$10,0)))","v":""}]
[{"$f":"IF(ROWS(A$18:A23)>$B$15,\"\",INDEX(A$2:A$10,MATCH(ROWS(A$18:A23),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(B$18:B23)>$B$15,\"\",INDEX(B$2:B$10,MATCH(ROWS(B$18:B23),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(C$18:C23)>$B$15,\"\",INDEX(C$2:C$10,MATCH(ROWS(C$18:C23),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(D$18:D23)>$B$15,\"\",INDEX(D$2:D$10,MATCH(ROWS(D$18:D23),$E$2:$E$10,0)))","v":""},{"$f":"IF(ROWS(E$18:E23)>$B$15,\"\",INDEX(E$2:E$10,MATCH(ROWS(E$18:E23),$E$2:$E$10,0)))","v":""}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}