{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Price List","Sheet2"],"not_rendered":{"charts":0,"images":2,"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":"Price List","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"PRICE LIST"]
["S/No","PRODUCT","PRICE (=N=)"]
[1,"Glucophage",1200.7]
[2,"Glucovance 2.5mg",1350.6]
[3,"Glucovance 5mg",1600.5]
[4,"Tramal 50mg",300.55]
[5,"Tramal 100mg",500.6]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Sheet2","index":1,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,29,2],[29,4,29,5],[11,2,11,5],[21,1,21,3],[23,2,23,5],[24,4,24,5],[24,1,24,3],[13,4,13,5],[28,4,28,5],[28,1,28,2],[12,2,12,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"No:",20140001]
[]
[]
[null,"Name"]
[null,"Address"]
[null,"Phone No:",null,"Date:"]
[]
[]
[]
[null,"QTY","PRODUCT","UNIT PRICE","AMOUNT","AMOUNT PAID"]
[null,null,null,{"$f":"IF(C19=\"Glucophage\",'Price List'!$C$4,IF(C19=\"Glucovance 2.5mg\",'Price List'!$C$5,IF(C19=\"Glucovance 5mg\",'Price List'!$C$6,IF(C19=\"Tramal 50mg\",'Price List'!$C$7,IF(C19=\"Tramal 100mg\",'Price List'!$C$8,0)))))","v":0},{"$f":"IF(B19>50,B19*(98%*D19),(B19*D19))","v":0},0]
[null,null,null,{"$f":"IF(C20=\"Glucophage\",'Price List'!$C$4,IF(C20=\"Glucovance 2.5mg\",'Price List'!$C$5,IF(C20=\"Glucovance 5mg\",'Price List'!$C$6,IF(C20=\"Tramal 50mg\",'Price List'!$C$7,IF(C20=\"Tramal 100mg\",'Price List'!$C$8,0)))))","v":0},{"$f":"IF(B20>50,B20*(98%*D20),(B20*D20))","v":0}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,[AMOUNT])","v":0},{"$f":"SUBTOTAL(109,[AMOUNT PAID])","v":0}]
[null,"2% discount on every purchase above 50 packs"]
[]
[null,"Amount in words",{"$f":"spellnumber(Table1[[#Totals],[AMOUNT]])","v":" "}]
[null,"UNPAID BALANCE:",null,null,{"$f":"Table1[[#Totals],[AMOUNT]]-Table1[[#Totals],[AMOUNT PAID]]","v":0}]
[]
[]
[]
[]
[null,"Customer's Signature",null,null,"Reciever's Signature"]