{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":51,"n_cols":10,"rows_kept":51,"merged":[[10,5,10,6]]}
[]
[null,"PRA vide à compléter"]
[]
[null,"Caractéristiques"]
[null,"      Poids brut",null,"kg",null,{"$f":"F6+F7+F8","v":{"v":0,"d":"0.00"}},"kg brut",null,1]
[null,"      Tare ",null,"  x",5,{"$f":"C6*E6","v":{"v":0,"d":"0.00"}},"kg",null,0.5]
[null,"      Surtare ",null,"  x",10,{"$f":"C7*E7","v":{"v":0,"d":"0.00"}},"kg",null,0.5]
[null,"      Poids net","densité",{"v":0.8,"d":"0.80"},null,{"$f":"F9*D8","v":{"v":0,"d":"0.00"}},"kg net",null,2]
[null,"      Capacité net ",null,"  x  ",120,{"$f":"C9*E9","v":{"v":0,"d":"0.00"}},"litres",null,1,{"$f":"SUM(I5:I9)","v":5}]
[]
[null,null,"quantité","tarif","unité","montant"]
[]
[null,"Achat ",{"$f":"F8","v":{"v":0,"d":"0.00"}},null,"cru",{"$f":"C13*D13","v":{"v":0,"d":"0.00"}},null,null,2]
[null,"                      remise",{"$f":"F13","v":{"v":0,"d":"0.00"}},null,null,{"$f":"C14*D14","v":{"v":0,"d":"0.00"}},null,null,1]
[null,"                      PAN",null,null,"cru",{"$f":"F13-F14","v":{"v":0,"d":"0.00"}}]
[null,null,"change",null,"frs",null,{"$f":"F15/100*D16","v":{"v":0,"d":"0.00"}},null,1,{"$f":"SUM(I13:I16)","v":4}]
[]
[null,"Transport"]
[null,"          Chargement","f.o.b",{"$nulls":5},1]
[null,"          Bateau",{"$f":"F5/1000","v":{"v":0,"d":"0.00"}},null,"cru",{"$f":"D20*C20","v":{"v":0,"d":"0.00"}},{"$f":"F20/100*D16","v":{"v":0,"d":"0.00"}},null,1]
[null,"          Train",null,null,"€",{"v":1040,"d":"1,040.00"},{"$f":"F21*D21","v":{"v":0,"d":"0.00"}},null,1]
[null,"          Laus -> dépôt",{"$f":"F5/100","v":{"v":0,"d":"0.00"}},null,"frs",null,{"$f":"D22*C22","v":{"v":0,"d":"0.00"}},null,1,{"$f":"SUM(I19:I22)","v":4}]
[{"$nulls":6},{"$f":"SUM(G20:G22)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Assurance"]
[null,"             Prime brute",{"$f":"G16*1.3","v":{"v":0,"d":"0.00"}},0.025,"frs",{"$f":"C26*D26","v":{"v":0,"d":"0.00"}},null,null,2]
[null,"             Remise",{"$f":"F26","v":{"v":0,"d":"0.00"}},{"v":0.1,"d":"0.10"},null,{"$f":"C27*D27","v":{"v":0,"d":"0.00"}},null,null,1]
[null,"             Prime net",{"$nulls":3},{"$f":"F26-F27","v":{"v":0,"d":"0.00"}}]
[null,"             Timbre fédéral",{"$f":"F28","v":{"v":0,"d":"0.00"}},0.01,null,{"$f":"(INT(C29*D29*10)+1)/10","v":{"v":0.1,"d":"0.10"}},{"$f":"F28+F29","v":{"v":0.1,"d":"0.10"}},null,2,{"$f":"SUM(I26:I29)","v":5}]
[]
[null,"Douane"]
[null,"             Taxe",{"$f":"F5/100","v":{"v":0,"d":"0.00"}},{"v":12,"d":"12.00"},null,{"$f":"D32*C32","v":{"v":0,"d":"0.00"}},null,null,1]
[null,"             Statistiques",{"$f":"F32","v":{"v":0,"d":"0.00"}},0.03,null,{"$f":"(INT(D33*C33*10)+1)/10","v":{"v":0.1,"d":"0.10"}},{"$f":"SUM(F32:F33)","v":{"v":0.1,"d":"0.10"}},null,2,{"$f":"SUM(I32:I33)","v":3}]
[]
[null,"Divers",{"$f":"G16","v":{"v":0,"d":"0.00"}},{"$f":"1/200","v":0.005},null,null,{"$f":"C35*D35","v":{"v":0,"d":"0.00"}},null,1,{"$f":"I35","v":1}]
[]
[]
[null,"                      PRA",{"$nulls":4},{"$f":"SUM(G23:G35)+G16","v":{"v":0.2,"d":"0.20"}}]
[]
[null,null,"PRA","tot. l"]
[null," PRA d'un litre de cire",{"$f":"G38","v":{"v":0.2,"d":"0.20"}},{"v":42000,"d":"42,000.00"},"frs",null,{"$f":"C41/D41","v":{"v":4.7619047619047624E-6,"d":"0.0000"}},null,1]
[null,null,"fr/val","PAN"]
[null," Frais/valeur pour 100 PAN",{"$f":"G29+G35","v":{"v":0.1,"d":"0.10"}},{"$f":"G16","v":{"v":0,"d":"0.00"}},"frs","%",{"$f":"C43/D43*100","v":{"$error":"#DIV/0!"}},null,1]
[null,null,"fr/pds","Pds N"]
[null," Frais/poids pour 100 kg net",{"$f":"G23+G33","v":{"v":0.1,"d":"0.10"}},{"$f":"F8","v":{"v":0,"d":"0.00"}},"kg",null,{"$f":"C45/D45*100","v":{"$error":"#DIV/0!"}},null,1]
[null,"  Poids net",{"v":20,"d":"20.00"},null,"t."]
[null,"  PAN",{"v":20000,"d":"20,000.00"},{"v":19,"d":"19.00"},"cru",{"$f":"D47*C47","v":{"v":380000,"d":"380,000.00"}}]
[{"$nulls":3},{"v":3.7,"d":"3.70"},"frs",null,{"$f":"F47/100*D16","v":{"v":0,"d":"0.00"}},null,1]
[null,"  Frais s/poids",{"$f":"C47/100","v":{"v":200,"d":"200.00"}},{"$f":"G45","v":{"$error":"#DIV/0!"}},"frs",null,{"$f":"D49*C49","v":{"$error":"#DIV/0!"}},null,1]
[null,"  Frais s/valeur",{"$f":"G48/100","v":{"v":0,"d":"0.00"}},{"$f":"G43","v":{"$error":"#DIV/0!"}},"frs",null,{"$f":"D50*C50","v":{"$error":"#DIV/0!"}},null,1,{"$f":"SUM(I41:I50)","v":6}]
[null," Prix de revient d'achat   ",null,null,"frs",null,{"$f":"SUM(G48:G50)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(J9:J50)","v":28}]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}