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

{"sheet":"VAT Invoice","index":0,"n_rows":49,"n_cols":12,"rows_kept":49,"merged":[[0,7,0,9],[1,0,1,3],[5,0,5,1],[5,2,5,3],[6,0,6,1],[6,2,6,3],[7,0,7,1],[7,2,7,3],[8,0,8,1],[8,2,8,3],[9,0,9,1],[9,2,9,3],[10,0,10,1],[10,2,10,3],[11,0,11,1],[11,2,11,3],[13,0,14,0],[13,1,14,2],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[33,0,34,0]]}
[{"$nulls":7},"VAT Invoice"]
["Company Name"]
[]
["Invoice No.",null,"Invoice Date:",{"$f":"TODAY()","v":"2012-07-17"}]
[]
["Customer:",null,"Company:"]
["Name",null,"Name"]
["Street Address",null,"Street Address"]
["City, ST  ZIP Code",null,"City, ST  ZIP Code"]
["E-mail",null,"E-mail"]
["Phone No.",null,"Phone No."]
["VAT No.",null,"VAT No."]
[]
["Date","Description",null,null,"Qty","VAT %","Price w/out VAT","Price Euro","Total w/out VAT","Total Euro","VAT","Net Euro"]
[]
["2004-06-10","Case of soda",null,null,10,{"v":10,"d":"10.0"},{"v":100,"d":"€ 100.00"},{"$f":"IF(G16*E16=0,\"\",G16+(G16*F16)/100)","v":{"v":110,"d":"€ 110.00"}},{"$f":"IF(G16*E16=0,\"\",G16*E16)","v":{"v":1000,"d":"€ 1,000.00"}},{"$f":"IF(E16*G16=0,\"\",H16*E16)","v":{"v":1100,"d":"€ 1,100.00"}},{"$f":"IF(J16=\"\",\"\",E16*(G16*F16)/100)","v":{"v":100,"d":"€ 100.00"}},{"$f":"IF(ISERROR(J16-K16),\"\",(J16-K16))","v":{"v":1000,"d":"€ 1,000.00"}}]
[{"$nulls":7},{"$f":"IF(G17*E17=0,\"\",G17+(G17*F17)/100)","v":""},{"$f":"IF(G17*E17=0,\"\",G17*E17)","v":""},"","",{"$f":"IF(ISERROR(J17-K17),\"\",(J17-K17))","v":""}]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[{"$nulls":7},"","","","",""]
[]
[{"$nulls":7},"Total",{"$f":"SUM(I16:I28)","v":{"v":1000,"d":"€ 1,000.00"}}]
[{"$nulls":7},"VAT Amount",{"$f":"SUM(K16:K28)","v":{"v":100,"d":"€ 100.00"}}]
[{"$nulls":7},"Total with VAT",{"$f":"SUM(I30:I31)","v":{"v":1100,"d":"€ 1,100.00"}}]
[{"$nulls":7},"Payment"]
["VAT Analysis:",{"$nulls":6},"Balance Due",{"$f":"I32-I33","v":{"v":1100,"d":"€ 1,100.00"}}]
[]
["VAT %","NET Euro","VAT Euro"]
[{"$f":"MIN($F$16:$F$28)","v":{"v":10,"d":"10.00"}},{"$f":"SUMIF($F$16:$F$28,$A37,$L$16:$L$28)","v":{"v":1000,"d":"€ 1,000.00"}},{"$f":"SUMIF($F$16:$F$28,$A37,$K$16:$K$28)","v":{"v":100,"d":"€ 100.00"}}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A37),$F$16:$F$28,FALSE))=A$37:$A37,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A37),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(A38=\"\",\"\",SUMIF($F$16:$F$28,$A38,$L$16:$L$28))","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF(A38=\"\",\"\",SUMIF($F$16:$F$28,$A38,$K$16:$K$28))","v":{"v":0,"d":"€ 0.00"}}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A38),$F$16:$F$28,FALSE))=A$37:$A38,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A38),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A39),$F$16:$F$28,FALSE))=A$37:$A39,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A39),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A40),$F$16:$F$28,FALSE))=A$37:$A40,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A40),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A41),$F$16:$F$28,FALSE))=A$37:$A41,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A41),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A42),$F$16:$F$28,FALSE))=A$37:$A42,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A42),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A43),$F$16:$F$28,FALSE))=A$37:$A43,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A43),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A44),$F$16:$F$28,FALSE))=A$37:$A44,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A44),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A45),$F$16:$F$28,FALSE))=A$37:$A45,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A45),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A46),$F$16:$F$28,FALSE))=A$37:$A46,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A46),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A47),$F$16:$F$28,FALSE))=A$37:$A47,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A47),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$37:$A48),$F$16:$F$28,FALSE))=A$37:$A48,\"\",MIN(IF($F$16:$F$28>MAX(A$37:$A48),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]