{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Question","Try","Bill","Mike","Mike(2)","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,"2013-05-01","2013-05-02","2013-05-03","Total"]
[{"$f":"ROWS($A$1:A2)-ROW($A$1)","v":1},"Arnold","10-15","10-15","0-25","20-55"]
[{"$f":"ROWS($A$1:A3)-ROW($A$1)","v":2},"Cindy","1-25","12-25","0-10","13-60"]
[{"$f":"ROWS($A$1:A4)-ROW($A$1)","v":3},"Bernard","100-5","1-25","100-5","201-35"]
[{"$f":"ROWS($A$1:A5)-ROW($A$1)","v":4},"Oliver","1-10","150-0","15-10","166-20"]
[{"$f":"ROWS($A$1:A6)-ROW($A$1)","v":5},"Paul","10-5","7-5","1-5","18-15"]
[{"$f":"ROWS($A$1:A7)-ROW($A$1)","v":6},"Gary","7-5","1-0","8-0","16-5"]
[]
[null,"Total","129-65","181-70","124-55","434-190",null,"Note:"]
[null,"should be","131-5","183-10","125-25","440-10",null,"1 tray = 30pcs. Of eggs",null,"440 trays = 13,200pcs.",null,"440-10 = 13,210pcs."]
[]
[null,"Unit Price",null,null,null,125]
[]
[null,"Revenue",null,null,null,55041.67]

{"sheet":"Try","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,"2013-05-01","2013-05-02","2013-05-03","Total"]
[{"$f":"ROWS($A$1:A2)-ROW($A$1)","v":1},"Arnold","10-15","10-15","0-25","20-55"]
[{"$f":"ROWS($A$1:A3)-ROW($A$1)","v":2},"Cindy","1-25","12-25","0-10","13-60"]
[{"$f":"ROWS($A$1:A4)-ROW($A$1)","v":3},"Bernard","100-5","1-25","100-5","201-35"]
[{"$f":"ROWS($A$1:A5)-ROW($A$1)","v":4},"Oliver","1-10","150-0","15-10","166-20"]
[{"$f":"ROWS($A$1:A6)-ROW($A$1)","v":5},"Paul","10-5","7-5","1-5","18-15"]
[{"$f":"ROWS($A$1:A7)-ROW($A$1)","v":6},"Gary","7-5","1-0","8-0","16-5"]
[]
[null,"Total","129-65","181-70","124-55","434-190",null,"Note:"]
[null,"should be","131-5","183-10","125-25","440-10",null,"1 tray = 30pcs. Of eggs",null,"440 trays = 13,200pcs.",null,"440-10 = 13,210pcs."]
[]
[null,"Unit Price",null,null,null,125]
[]
[null,"Revenue",null,null,null,55041.67]

{"sheet":"Bill","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,"2013-05-01","2013-05-02","2013-05-03","Total"]
[{"$f":"ROWS($A$1:A2)-ROW($A$1)","v":1},"Arnold","10-15","10-15","0-25",{"$f":"sumeggs(C2:E2)","v":"21-25"}]
[{"$f":"ROWS($A$1:A3)-ROW($A$1)","v":2},"Cindy","1-25","12-25","0-10",{"$f":"sumeggs(C3:E3)","v":"15-0"}]
[{"$f":"ROWS($A$1:A4)-ROW($A$1)","v":3},"Bernard","100-5","1-25","100-5","202-5"]
[{"$f":"ROWS($A$1:A5)-ROW($A$1)","v":4},"Oliver","1-10","150-0","15-10","166-20"]
[{"$f":"ROWS($A$1:A6)-ROW($A$1)","v":5},"Paul","10-5","7-5","1-5","18-15"]
[{"$f":"ROWS($A$1:A7)-ROW($A$1)","v":6},"Gary","7-5","1-0","8-0","16-5"]
[]
[null,"Total",{"$f":"sumeggs(C2:C7)","v":"131-5"},{"$f":"sumeggs(D2:D7)","v":"183-10"},"125-25","440-10"]
[null,"should be","131-5","183-10","125-25","440-10"]

{"sheet":"Mike","index":3,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,"2013-05-01","2013-05-02","2013-05-03","Total"]
[{"$f":"ROWS($A$1:A2)-ROW($A$1)","v":1},"Arnold","10-15","10-15","0-25",{"$f":"SUMPRODUCT(LEFT(C2:E2,SEARCH(\"-\",C2:E2)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(C2:E2,1,SEARCH(\"-\",C2:E2),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(C2:E2,1,SEARCH(\"-\",C2:E2),\"\")+0),30)","v":"21-25"}]
[{"$f":"ROWS($A$1:A3)-ROW($A$1)","v":2},"Cindy","1-25","12-25","0-10",{"$f":"SUMPRODUCT(LEFT(C3:E3,SEARCH(\"-\",C3:E3)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(C3:E3,1,SEARCH(\"-\",C3:E3),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(C3:E3,1,SEARCH(\"-\",C3:E3),\"\")+0),30)","v":"15-0"}]
[{"$f":"ROWS($A$1:A4)-ROW($A$1)","v":3},"Bernard","100-5","1-25","100-5","202-5"]
[{"$f":"ROWS($A$1:A5)-ROW($A$1)","v":4},"Oliver","1-10","150-0","15-10","166-20"]
[{"$f":"ROWS($A$1:A6)-ROW($A$1)","v":5},"Paul","10-5","7-5","1-5","18-15"]
[{"$f":"ROWS($A$1:A7)-ROW($A$1)","v":6},"Gary","7-5","1-0","8-0","16-5"]
[]
[null,"Total trays",{"$f":"SUMPRODUCT(LEFT(C2:C7,SEARCH(\"-\",C2:C7)-1)+0)","v":129},{"$f":"SUMPRODUCT(LEFT(D2:D7,SEARCH(\"-\",D2:D7)-1)+0)","v":181},124,438,null,"Note:"]
[null,"Total eggs after dash",{"$f":"SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0)","v":65},{"$f":"SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0)","v":70},55,70,null,"1 tray = 30pcs. Of eggs",null,"440 trays = 13,200pcs.",null,"440-10 = 13,210pcs."]
[null,"Trays from after dash",{"$f":"QUOTIENT(SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0),30)","v":2},{"$f":"QUOTIENT(SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0),30)","v":2},1,2]
[null,"Eggs left over after dash",{"$f":"MOD(SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0),30)","v":5},{"$f":"MOD(SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0),30)","v":10},25,10]
[null,"Result",{"$f":"SUMPRODUCT(LEFT(C2:C7,SEARCH(\"-\",C2:C7)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0),30)","v":"131-5"},{"$f":"SUMPRODUCT(LEFT(D2:D7,SEARCH(\"-\",D2:D7)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0),30)","v":"183-10"},"125-25","440-10"]
[]
[null,"should be","131-5","183-10","125-25","440-10"]
[]
[null,"Unit Price",null,null,null,125]
[]
[null,"Revenue",null,null,null,55041.67]

{"sheet":"Mike(2)","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,"2013-05-01","2013-05-02","2013-05-03","Total"]
[{"$f":"ROWS($A$1:A2)-ROW($A$1)","v":1},"Arnold","10-15","10-15","0-25",{"$f":"SUMPRODUCT(LEFT(C2:E2,SEARCH(\"-\",C2:E2)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(C2:E2,1,SEARCH(\"-\",C2:E2),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(C2:E2,1,SEARCH(\"-\",C2:E2),\"\")+0),30)","v":"21-25"}]
[{"$f":"ROWS($A$1:A3)-ROW($A$1)","v":2},"Cindy","1-25","12-25","0-10",{"$f":"SUMPRODUCT(LEFT(C3:E3,SEARCH(\"-\",C3:E3)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(C3:E3,1,SEARCH(\"-\",C3:E3),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(C3:E3,1,SEARCH(\"-\",C3:E3),\"\")+0),30)","v":"15-0"}]
[{"$f":"ROWS($A$1:A4)-ROW($A$1)","v":3},"Bernard","100-5","1-25","100-5","202-5"]
[{"$f":"ROWS($A$1:A5)-ROW($A$1)","v":4},"Oliver","1-10","150-0","15-10","166-20"]
[{"$f":"ROWS($A$1:A6)-ROW($A$1)","v":5},"Paul","10-5","7-5","1-5","18-15"]
[{"$f":"ROWS($A$1:A7)-ROW($A$1)","v":6},"Gary","7-5","1-0","8-0","16-5"]
[]
[null,"Total",{"$f":"SUMPRODUCT(LEFT(C2:C7,SEARCH(\"-\",C2:C7)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0),30)","v":"131-5"},{"$f":"SUMPRODUCT(LEFT(D2:D7,SEARCH(\"-\",D2:D7)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0),30)","v":"183-10"},"125-25","440-10",null,"Note:"]
[null,"should be","131-5","183-10","125-25","440-10",null,"1 tray = 30pcs. Of eggs",null,"440 trays = 13,200pcs.",null,"440-10 = 13,210pcs."]
[]
[null,"Unit Price",null,null,null,125]
[]
[null,"Revenue",null,null,null,55041.67]

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

{"sheet":"Sheet3","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,"2013-05-01","2013-05-02","2013-05-03","Total"]
[{"$f":"ROWS($A$1:A2)-ROW($A$1)","v":1},"Arnold","10-15","10-15","0-25","20-55"]
[{"$f":"ROWS($A$1:A3)-ROW($A$1)","v":2},"Cindy","1-25","12-25","0-10","13-60"]
[{"$f":"ROWS($A$1:A4)-ROW($A$1)","v":3},"Bernard","100-5","1-25","100-5","201-35"]
[{"$f":"ROWS($A$1:A5)-ROW($A$1)","v":4},"Oliver","1-10","150-0","15-10","166-20"]
[{"$f":"ROWS($A$1:A6)-ROW($A$1)","v":5},"Paul","10-5","7-5","1-5","18-15"]
[{"$f":"ROWS($A$1:A7)-ROW($A$1)","v":6},"Gary","7-5","1-0","8-0","16-5"]
[]
[null,"Total","129-65","181-70","124-55","434-190",null,"Note:"]
[null,"should be","131-5","183-10","125-25","440-10",null,"1 tray = 30pcs. Of eggs",null,"440 trays = 13,200pcs.",null,"440-10 = 13,210pcs."]
[null,null,{"$f":"SUMPRODUCT(LEFT(C2:C7,SEARCH(\"-\",C2:C7)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(C2:C7,1,SEARCH(\"-\",C2:C7),\"\")+0),30)","v":"131-5"},{"$f":"SUMPRODUCT(LEFT(D2:D7,SEARCH(\"-\",D2:D7)-1)+0)+QUOTIENT(SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0),30)&\"-\"&MOD(SUMPRODUCT(REPLACE(D2:D7,1,SEARCH(\"-\",D2:D7),\"\")+0),30)","v":"183-10"},"125-25","440-10"]
[null,"Unit Price",null,null,null,125]
[]
[null,"Revenue",null,null,null,55041.67]