{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Facture TTC","Calculs","Données"],"not_rendered":{"images":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Facture TTC","index":0,"n_rows":58,"n_cols":9,"rows_kept":58,"merged":[[0,0,0,6],[6,0,6,5],[13,2,13,3],[14,6,14,7],[38,3,38,4],[40,3,40,4],[41,3,41,5],[42,3,42,4],[43,3,43,4]]}
["Pharmacie du Marché"]
["Place du Marché - 37000 TOURS"]
["Tél 02-12-34-56-78 Fax 02-23-45-67-89"]
["pharmacie-marché@orange.fr"]
["SELARL au capital de 8000"]
["Agrément SS 372001234               RCS Tours 12345612345622"]
["TVA FR 8412342345000022          LCL Tours 30002 02345 0000023456B 28"]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"FACTURE\"","v":"FACTURE"},{"$f":"RIGHT(YEAR($G$15),2)&MONTH($G$15)&DAY($G$15)&\"/\"&LEFT($F$44,2)","v":"0010/0"}]
[{"$nulls":5},"Tours, le"]
[]
[]
["CIP","Désignation","TVA/Tx","PUTTC","Q","Ligne TTC","TVA 1","TVA 2","TVA 3"]
[null,null," "," "," ",{"$f":"IF(ISNUMBER(E19),D19*E19,0)","v":0},{"$f":"IF($C19=$B$41,$F19*(1-1/(1+$C19)),0)","v":0},{"$f":"IF($C19=$B$42,$F19*(1-1/(1+$C19)),0)","v":0},{"$f":"IF($C19=$B$43,$F19*(1-1/(1+$C19)),0)","v":0}]
[{"$nulls":5},{"$f":"D20*E20","v":0},{"$f":"IF($C20=$B$41,$F20*(1-1/(1+$C20)),0)","v":0},{"$f":"IF($C20=$B$42,$F20*(1-1/(1+$C20)),0)","v":0},{"$f":"IF($C20=$B$43,$F20*(1-1/(1+$C20)),0)","v":0}]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[{"$nulls":5},0,0,0,0]
[]
[]
[]
[{"$nulls":3},"BRUT TTC",null,{"$f":"SUM(F19:F35)","v":0}]
["CODE","TAUX TVA",null,{"$f":"IF(E40>0,\"REMISE %\",\"\")","v":"REMISE %"}," ",{"$f":"IF(ISNUMBER(E40),-F39*E40/100,0)","v":0}]
[1,{"v":0.021,"d":"2.10%"},null,"NET HT",null,{"$f":"F44-F43","v":0}]
[2,{"v":0.1,"d":"10.00%"},null,"VENTILATION TVA",null,null,{"$f":"IF(ISNUMBER($E$40),SUM(G$19:G$35)*(100-$E$40)/100,SUM(G$19:G$35))","v":0},{"$f":"IF(ISNUMBER($E$40),SUM(H$19:H$35)*(100-$E$40)/100,SUM(H$19:H$35))","v":0},{"$f":"IF(ISNUMBER($E$40),SUM(I$19:I$35)*(100-$E$40)/100,SUM(I$19:I$35))","v":0}]
[3,{"v":0.2,"d":"20.00%"},null,"TOTAL TVA",null,{"$f":"SUM(G42:I42)","v":0}]
[{"$nulls":3},"NET TTC",null,{"$f":"F39+F40","v":0}]
[{"$nulls":5},{"$f":"F44*Données!E102","v":0}]
[]
[null,{"$f":"IF(H14=\"F\",\"Facture arrêtée à la somme de:\",IF(H14=\"D\",\"Devis arrêté à la somme de:\",\"\"))","v":""}]
[null,{"$f":"\"Facture arrêtée à la somme de:\"","v":"Facture arrêtée à la somme de:"},{"$f":"Calculs!C9","v":" euro"}]
[]
[]
[null,{"$f":"\"En votre aimable règlement\"","v":"En votre aimable règlement"}]
[]
[]
[]
[]
[]
["Membre d'une A.G.A. - Les chèques sont acceptés"]
["Les factures sont payables à 30 jours sans escompte en cas de paiement anticipé "]

{"sheet":"Calculs","index":1,"n_rows":9,"n_cols":7,"rows_kept":9}
[]
["FACTURE TTC"]
[{"$f":"'Facture TTC'!F44","v":{"v":0,"d":"0.00"}},{"$f":"INT($A3/1000)","v":0},{"$f":"IF(B3<1,\"\",IF(B3=1,\"\",IF(B3=80,LEFT(VLOOKUP(B3,Données,2,2),12),VLOOKUP(B3,Données,2,2))))","v":""},{"$f":"IF($B$3=1,VLOOKUP($B$3,Données,3,2),VLOOKUP($B$3,Données,2,2))","v":0},{"$f":"IF($B$3=0,VLOOKUP($B$3,Données,4,2),VLOOKUP(1,Données,4,2))","v":" "},{"$f":"D3&\" \"&E3","v":"0  "},{"$f":"IF($B$6>=1,\"et\",\"\")","v":""}]
[{"$f":"A3-(B3*1000)","v":{"v":0,"d":"0.00"}},{"$f":"INT($A4/100)","v":0},{"$f":"IF(B4<1,\"\",IF(B4=1,\"\",VLOOKUP(B4,Données,2,2)))","v":""},{"$f":"IF(B4=1,VLOOKUP(B4,Données,3,2),VLOOKUP(B4,Données,2,2))","v":0},{"$f":"IF($B$4=0,VLOOKUP($B$4,Données,4,2),VLOOKUP(100,Données,2,2))","v":" "},{"$f":"D4&\" \"&E4","v":"0  "},{"$f":"IF($B$6=1,\"centime\",IF($B$6>1,\"centimes\",\"\"))","v":""}]
[{"$f":"A4-(B4*100)","v":{"v":0,"d":"0.00"}},{"$f":"INT($A5)","v":0},{"$f":"IF(B5<1,\"\",IF(B5=80,LEFT(VLOOKUP(B5,Données,2,2),12),VLOOKUP(B5,Données,2,2)))","v":""},{"$f":"IF(B5=1,VLOOKUP(B5,Données,3,2),VLOOKUP(B5,Données,2,2))","v":0},{"$f":"IF($B$5=0,VLOOKUP($B$5,Données,4,2),IF(AND($B$5=80,$B$6=0),VLOOKUP($B$5,Données,3,2),VLOOKUP($B$5,Données,2,2)))","v":" "},{"$f":"E5","v":" "},{"$f":"IF(A3>=2,\"euros\",\"euro\")","v":"euro"}]
[{"$f":"(A5-B5)*100","v":{"v":0,"d":"0.00"}},{"$f":"A6","v":0},{"$f":"IF(B6<1,\"\",VLOOKUP(B6,Données,2,2))","v":""},{"$f":"IF(B6=1,VLOOKUP(B6,Données,3,2),VLOOKUP(B6,Données,2,2))","v":0},{"$f":"IF($B$6=0,VLOOKUP($B$6,Données,4,2),IF($B$6=80,VLOOKUP($B$6,Données,3,2),VLOOKUP($B$6,Données,2,2)))","v":" "},{"$f":"E6","v":" "},{"$f":"IF($A$5>1,\"s\",\"\")","v":""}]
[]
[]
[null,null,{"$f":"IF($B$3=0,\"\",$F$3)&IF($B$4>0,\" \"&$F$4,\"\")&IF($B$5>0,\" \"&$F$5,\"\")&\" \"&$G$5&IF($A$6>0,\" \"&$G$3&\" \"&$F$6&\" \"&$G$4,\"\")","v":" euro"}]

{"sheet":"Données","index":2,"n_rows":102,"n_cols":5,"rows_kept":102}
[]
[null,0,null," "," "]
[null,1,"un"," ","mille"]
[null,2,"deux"]
[null,3,"trois"]
[null,4,"quatre"]
[null,5,"cinq"]
[null,6,"six"]
[null,7,"sept"]
[null,8,"huit"]
[null,9,"neuf"]
[null,10,"dix"]
[null,11,"onze"]
[null,12,"douze"]
[null,13,"treize"]
[null,14,"quatorze"]
[null,15,"quinze"]
[null,16,"seize"]
[null,17,"dix-sept"]
[null,18,"dix-huit"]
[null,19,"dix-neuf"]
[null,20,"vingt","vingts"]
[null,21,"vingt et un"]
[null,22,"vingt-deux"]
[null,23,"vingt-trois"]
[null,24,"vingt-quatre"]
[null,25,"vingt-cinq"]
[null,26,"vingt-six"]
[null,27,"vingt-sept"]
[null,28,"vingt-huit"]
[null,29,"vingt-neuf"]
[null,30,"trente"]
[null,31,"trente et un"]
[null,32,"trente-deux"]
[null,33,"trente-trois"]
[null,34,"trente-quatre"]
[null,35,"trente-cinq"]
[null,36,"trente-six"]
[null,37,"tente-sept"]
[null,38,"trente-huit"]
[null,39,"trente-neuf"]
[null,40,"quarante"]
[null,41,"quarante et un"]
[null,42,"quarante-deux "]
[null,43,"quarante-trois"]
[null,44,"quarante-quatre"]
[null,45,"quarante-cinq"]
[null,46,"quarante-six"]
[null,47,"quarante-sept"]
[null,48,"quarante-huit"]
[null,49,"quarante-neuf"]
[null,50,"cinquante "]
[null,51,"cinquante et un"]
[null,52,"cinquante-deux"]
[null,53,"cinquante-trois"]
[null,54,"cinquante-quatre"]
[null,55,"cinquante-cinq"]
[null,56,"cinquante-six"]
[null,57,"cinquante-sept"]
[null,58,"cinquante-huit"]
[null,59,"cinquante-neuf"]
[null,60,"soixante"]
[null,61,"soixante et un"]
[null,62,"soixante-deux"]
[null,63,"soixante-trois"]
[null,64,"soixante-quatre"]
[null,65,"soixante-cinq"]
[null,66,"soixante-six"]
[null,67,"soixante-sept"]
[null,68,"soixante-huit"]
[null,69,"soixante-neuf"]
[null,70,"soixante-dix"]
[null,71,"soixante et onze"]
[null,72,"soixante-douze"]
[null,73,"soixante-treize"]
[null,74,"soixante-quatorze"]
[null,75,"soixante-quinze"]
[null,76,"soixante-seize"]
[null,77,"soixante-dix-sept"]
[null,78,"soixante-dix-huit"]
[null,79,"soixante-dix-neuf"]
[null,80,"quatre-vingt","quatre-vingts"]
[null,81,"quatre-vingt-un"]
[null,82,"quatre-vingt-deux"]
[null,83,"quatre-vingt-trois"]
[null,84,"quatre-vingt-quatre"]
[null,85,"quatre-vingt-cinq"]
[null,86,"quatre-vingt-six"]
[null,87,"quatre-vingt-sept"]
[null,88,"quatre-vingt-huit"]
[null,89,"quatre-vingt-neuf"]
[null,90,"quatre-vingt-dix"]
[null,91,"quatre-vingt-onze"]
[null,92,"quatre-vingt-douze"]
[null,93,"quatre-vingt-treize"]
[null,94,"quatre-vingt-quatorze"]
[null,95,"quatre-vingt-quinze","francs","euros"]
[null,96,"quatre-vingt-seize","centime","eurocents"]
[null,97,"quatre-vingt-dix-sept","et"]
[null,98,"quatre-vingt-dix-huit","s"]
[null,99,"quatre-vingt-dix-neuf","mille",0.15245]
[null,100,"cent","cents",6.55957]