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

{"sheet":"Factura de IVA","index":0,"n_rows":48,"n_cols":10,"rows_kept":48,"merged":[[0,6,0,8],[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],[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],[32,0,33,0]]}
[{"$nulls":6},"Factura de IVA"]
["Nome da Empresa"]
[]
["N.º da Factura",null,"Data da Factura:",{"$f":"TODAY()","v":"2012-07-16"}]
[]
["Cliente:",null,"Empresa:"]
["Nome",null,"Nome"]
["Endereço",null,"Endereço"]
["Localidade, Código Postal",null,"Localidade, Código Postal"]
["Correio electrónico",null,"Correio electrónico"]
["N.º de Telefone",null,"N.º de Telefone"]
["N.º de Contribuinte",null,"N.º de Contribuinte"]
[]
["Data","Descrição",null,null,"Qtd.","% IVA","Preço em Euros","Total em Euros","IVA","Total Líq. em Euros"]
[]
["2004-06-10","Caixa de bebidas gaseificadas",null,null,10,{"v":100,"d":"100.0"},{"v":110,"d":"€ 110.00"},{"$f":"IF(G16*E16=0,\"\",G16*E16)","v":{"v":1100,"d":"€ 1,100.00"}},{"$f":"IF(ISERROR(H16-J16),\"\",(H16-J16))","v":{"v":550,"d":"€ 550.00"}},{"$f":"IF(H16=\"\",\"\",H16/(1+(F16/100)))","v":{"v":550,"d":"€ 550.00"}}]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[{"$nulls":7},"","",""]
[]
[{"$nulls":6},"Total",{"$f":"SUM(H16:H28)","v":{"v":1100,"d":"€ 1,100.00"}}]
[{"$nulls":6},"Montante de IVA",{"$f":"SUM(I16:I28)","v":{"v":550,"d":"€ 550.00"}}]
[{"$nulls":6},"Pagamento"]
["Análise do IVA:",{"$nulls":5},"Saldo em Dívida",{"$f":"H30-H32","v":{"v":1100,"d":"€ 1,100.00"}}]
[]
["% IVA","Total Líq. em Euros","IVA em Euros"]
[{"$f":"MIN($F$16:$F$28)","v":{"v":100,"d":"100.0"}},{"$f":"SUMIF($F$16:$F$28,$A36,$J$16:$J$28)","v":{"v":550,"d":"€ 550.00"}},{"$f":"SUMIF($F$16:$F$28,$A36,$I$16:$I$28)","v":{"v":550,"d":"€ 550.00"}}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A36),$F$16:$F$28,FALSE))=A$36:$A36,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A36),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"$f":"IF(A37=\"\",\"\",SUMIF($F$16:$F$28,$A37,$J$16:$J$28))","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF(A37=\"\",\"\",SUMIF($F$16:$F$28,$A37,$I$16:$I$28))","v":{"v":0,"d":"€ 0.00"}}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A37),$F$16:$F$28,FALSE))=A$36:$A37,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A37),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A38),$F$16:$F$28,FALSE))=A$36:$A38,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A38),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A39),$F$16:$F$28,FALSE))=A$36:$A39,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A39),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A40),$F$16:$F$28,FALSE))=A$36:$A40,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A40),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A41),$F$16:$F$28,FALSE))=A$36:$A41,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A41),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A42),$F$16:$F$28,FALSE))=A$36:$A42,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A42),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A43),$F$16:$F$28,FALSE))=A$36:$A43,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A43),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A44),$F$16:$F$28,FALSE))=A$36:$A44,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A44),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A45),$F$16:$F$28,FALSE))=A$36:$A45,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A45),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A46),$F$16:$F$28,FALSE))=A$36:$A46,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A46),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[{"$f":"IF(MIN(IF($F$16:$F$28>MAX(A$36:$A47),$F$16:$F$28,FALSE))=A$36:$A47,\"\",MIN(IF($F$16:$F$28>MAX(A$36:$A47),$F$16:$F$28,FALSE)))","v":{"v":0,"d":"0.0"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]