{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["8417","8241","8249","ORDER IN HAND","Sheet8"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"8417","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,3,9,4]]}
["ORDER NO","SL NO","ITEM CODE","PRODUCT","QTY","AMOUNT","AMOUNT"]
["8417 2012",1,12149443122,"PRECIPATH U PLUS",12,441,{"$f":"E2*F2","v":5292}]
["8417 2012",2,11489232216,"CHOLESTEROL",86,123,{"$f":"E3*F3","v":10578}]
["8417 2012",3,3607399190,"BICARBONATE",21,12,252]
["8417 2012",4,11821792216,"LIPASE",5,956,4780]
["8417 2012",5,12149435122,"PRECINORM U PLUS",36,27,972]
["8417 2012",6,12172933122,"ALKALINE PHOSPHATASE",12,63,756]
["8417 2012",7,12172623122,"CFAS LIPIDS",14,971,13594]
["8417 2012",8,4528417190,"CFAS HBA1C",200,227,45400]
[null,null,null,"TOTAL ",null,null,{"$f":"SUM(G2:G9)","v":81624}]

{"sheet":"8241","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,3,13,4]]}
["ORDER NO","SL NO","ITEM CODE","PRODUCT","QTY","AMOUNT","AMOUNT"]
["8241 2012",1,20766682322,"AMMONIA",12,441,{"$f":"E2*F2","v":5292}]
["8241 2012",2,4851013190,"INSTC",86,123,{"$f":"E3*F3","v":10578}]
["8241 2012",3,4399803190,"HDL C",21,12,252]
["8241 2012",4,4404483190,"GLUCOSE",5,956,4780]
["8241 2012",5,3140622122,"BILT 2",2,1076,2152]
["8241 2012",6,5336163190,"A1C2",9,120,1080]
["8241 2012",7,3289923190,"BICARBONATE",17,970,16490]
["8241 2012",8,4880994190,"SCCS",200,98,19600]
["8241 2012",9,4460715190,"UREA L",36,27,972]
["8241 2012",10,12172933122,"ALKALINE PHOSPHATASE",12,63,756]
["8241 2012",11,12172623122,"CFAS LIPIDS",14,971,13594]
["8241 2012",12,4528417190,"CFAS HBA1C",200,227,45400]
[null,null,null,"TOTAL ",null,null,{"$f":"SUM(G2:G13)","v":120946}]

{"sheet":"8249","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,3,13,4]]}
["ORDER NO","SL NO","ITEM CODE","PRODUCT","QTY","AMOUNT","AMOUNT"]
["8249 2012",1,12149435122,"PRECINORM U PLUS",10,144,{"$f":"E2*F2","v":1440}]
["8249 2012",2,3121313122,"PRECINORM PUC",5,23,{"$f":"E3*F3","v":115}]
["8249 2012",3,3121291122,"PRECIPATH PUC",97,12,1164]
["8249 2012",4,3121313122,"PRECINORM PUC",25,956,23900]
["8249 2012",5,4745736190,"VITAMIN B12",10,1076,10760]
["8249 2012",6,11877984216,"NH3",12,120,1440]
["8249 2012",7,4528328190,"HEMOLYZING REAGENT",31,970,30070]
["8249 2012",8,20753009190,"AMMONIA ABNORMAL",74,98,7252]
["8249 2012",9,11731459122,"TSH",25,27,675]
["8249 2012",10,11488449122,"PRECIPATH HBA1C",12,63,756]
["8249 2012",11,11731661122,"FT4 CALSET",25,971,24275]
["8249 2012",12,4572459190,"VITAMIN B12 CALSET",200,227,45400]
[null,null,null,"TOTAL ",null,null,{"$f":"SUM(G2:G13)","v":147247}]

{"sheet":"ORDER IN HAND","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["ORDER NO","ORDER DATE","AMOUNT","AMOUNT QRS","DUE DATE"]
["8417 2012","2012-01-09",81624,{"$f":"C2*3.6502","v":297943.92479999998},{"$f":"B2+30","v":"2012-02-08"}]
["8241 2012","2012-01-27",120946,{"$f":"C3*3.6502","v":441477.08919999999},{"$f":"B3+30","v":"2012-02-26"}]
["8249 2012","2012-02-12",147247,{"$f":"C4*3.6502","v":537480.99939999997},{"$f":"B4+30","v":"2012-03-13"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D2:D15)","v":1276902.0134000001}]

{"sheet":"Sheet8","index":4,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[13,0,13,1],[13,3,13,5],[14,0,14,1],[14,3,14,5],[0,1,0,6],[2,0,2,2],[3,0,4,2],[7,1,7,2],[8,1,8,2],[12,0,12,6]]}
[null,"Invoice"]
[]
["[Your Company Name]",null,null,null,null,"Date:",{"$f":"TODAY()","v":"2012-03-08"}]
[" [Your Company Slogan Here]",null,null,null,null,"Invoice #:"]
[null,null,null,null,null,"Order No"]
[]
[]
["To:","[Name]"]
[null,"[Company Name]"]
[null,"[Street Address]"]
[null,"[City, ST  ZIP Code]"]
[null,"[Phone]"]
[]
["Salesperson",null,"Job","Payment Terms",null,null,"Due Date"]
[null,null,null,"Due upon receipt"]
[]
["Item Code","Description",null,null,"Qty","Unit Price"," Total QAR"]
[null,null,null,null,null,null,{"$f":"IF(SUM(E18)>0,SUM(E18*F18),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E19)>0,SUM(E19*F19),\"\")","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,{"$f":"IF(A22=\"\",\"\", VLOOKUP(A22,$J$66:$K$292,2,FALSE))","v":""},{"$f":"IF(B22=\"\",\"\",VLOOKUP(B22,$K$66:$L$292,2,FALSE))","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP(C22,$L$66:$N$292,3,FALSE))","v":""},null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,{"$f":"IF(A31=\"\",\"\", VLOOKUP(A31,$J$66:$K$292,2,FALSE))","v":""},"","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,"","","",null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(C38,$L$66:$N$292,3,FALSE))","v":""},null,null,""]
[null,null,null,null,null,"Subtotal",{"$f":"SUM(G18:G38)","v":0}]
[null,null,null,null,null,"Discount"]
[{"$f":"SpellCurr(G41)","v":{"$error":"#NAME?"}},null,null,null,null,"Total",{"$f":"IF(SUM(G39)>0,SUM((G39-G40)),\"\")","v":""}]