{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sales receipt"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Sales receipt","index":0,"n_rows":51,"n_cols":7,"rows_kept":51,"merged":[[1,2,1,6],[4,1,4,3],[8,2,8,3],[8,4,8,5],[9,2,9,3],[9,4,9,5],[10,2,10,3],[10,4,10,5],[11,2,11,3],[11,4,11,5],[12,2,12,3],[12,4,12,5],[14,1,14,2],[14,4,14,6],[15,1,15,2],[15,4,15,6],[48,1,48,6],[49,1,49,6],[50,1,50,6],[51,1,51,6],[52,1,52,6],[53,1,53,6],[54,1,54,6]]}
[]
[null,null,"Sales receipt"]
[]
[]
[null,"[Your company name]",{"$nulls":3},"Date:",{"$f":"TODAY()","v":"2019-03-29"}]
[null," [Your company slogan here]",{"$nulls":3},"Invoice no.:","[100]"]
[]
[]
[null,"Sold to:","[Name]"]
[null,null,"[Company name]"]
[null,null,"[Street address]"]
[null,null,"[Town/City, County Postcode]"]
[null,null,"[Phone number]"]
[]
[null,"Payment method",null,"Cheque no.","Job"]
[]
[]
[null,"Qty","Item no.","Description","Unit price","Discount","Line total"]
[null,2,null,null,{"v":5,"d":"£5.00"},{"v":5,"d":"£5.00"},{"$f":"IF(SUM(B19)>0,SUM((B19*E19)-F19),\"\")","v":{"v":5,"d":"£5.00"}}]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[]
[{"$nulls":5},"Total discount",{"$f":"IF(SUM(Table5[[#All],[Discount]])>0,SUM(F19:Table5[[#All],[Discount]]),\"\")","v":{"v":5,"d":"£5.00"}}]
[{"$nulls":5},"Subtotal",{"$f":"IF(SUM(Table5[[#All],[Line total]])>0,SUM(Table5[[#All],[Line total]]),\"\")","v":{"v":5,"d":"£5.00"}}]
[{"$nulls":5},"VAT",{"v":0.02,"d":"2%"}]
[{"$nulls":5},"Total",{"$f":"IF(SUM(G44)>0,SUM((G44*G45)+G44),\"\")","v":{"v":5.1,"d":"£5.10"}}]
[]
[]
[null,"Thank you for your business."]
[null,"[Street address], [Town/City, County Postcode]  [Phone number]  [Fax]  [Email address]"]
[{"$nulls":5},{"$f":"IF(SUM(F46)>0,SUM((F46*F48)+F46),\"\")","v":""}]