{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["DEVISA","FACTUREA","CLIENTS","SuiviDevis","SuiviFactures","DEVISB","FACTUREB","BASE_Données"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DEVISA","index":0,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":false,"merged":[[67,0,67,2],[0,4,0,6],[7,5,7,6],[12,5,12,6],[16,5,16,6],[19,0,19,1],[54,2,54,7],[55,0,55,3],[56,0,56,3],[62,6,62,7],[64,3,64,4],[66,0,66,1]]}
[]
[null,null,null,null,"DEVIS N°",null,2019,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TVA"]
[null,null,null,null,null,null,null,null,null,null,null,"Pce.",0]
[null,null,null,null,null,null,null,null,null,null,null,"ml.",5.5E-2]
["Date du devis:","2019-04-12",null,null,null,"Destinataire :",null,null,null,null,null,"m².",0.1]
["Référence du devis:",null,null,null,null,null,null,null,null,null,null,"U",0.2]
["Numéro de client:",null,null,null,null,null,null,null,null,null,null,"Hre"]
["Date de validité du devis:","2019-05-12",null,null,null,null,null,null,null,null,null,"L"]
["Modalité de paiement:","Virement fin de mois",null,null,null,null,null,null,null,null,null,"Ens"]
["Émis par:",null,null,null,null,"Adresse chantier:"]
["Contact client:"]
["Tél:"]
["Mail:"]
["Durée estimée de la prestation:",null,null,null,null,null,null,null,null,null,null,"Virement fin de mois"]
[null,null,null,null,null,null,null,null,null,null,null,"Fin de travaux"]
["Nous vous prions de bien vouloir trouver ci-joint notre meilleur proposition pour les travaux suivants."]
["Description",null,"Quantités",null,null,null,null,"TOTAL TTC"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(F21),\"\",IF(E21*F21*C21>0,E21*F21*C21,0))","v":""},{"$f":"IF(SUM(C21*E21,G21)>0,SUM(C21*E21,G21),\"\")","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(SUM(C22*E22,G22)>0,SUM(C22*E22,G22),\"\")","v":""}]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[]
[null,null,null,null,null,"Total HT",null,{"$f":"IF(SUM(H21:H54)=0,\"\",SUM(H21:H54)-SUM(G21:G54))","v":""}]
["       Signature du client (précédée de la mention « Bon pour accord »",null,null,null,null,"TVA",null,{"$f":"IF(H56=\"\",\"\",SUM(G21:G54))","v":""}]
[null,null,null,null,null,"SS Total TTC",null,{"$f":"IF(SUM(H21:H54)-0=0,\"\",SUM(H21:H54))","v":""}]
[null,null,null,null,null,"Versement d'un acompte :",null,{"$f":"IF((H56)=\"\",\"\",(H58*G59))","v":""}]
[null,null,null,null,null,"Total TTC",null,{"$f":"H58-H59","v":{"$error":"#VALUE!"}}]
[]
[]
["Entreprise:",null,"Contact:",null,null,null,"Détails bancaires:"]
[]
[]
[]
[]
[]
[""]

{"sheet":"FACTUREA","index":1,"n_rows":63,"n_cols":19,"rows_kept":63,"cut":false,"hidden":false,"merged":[[64,3,64,4],[66,0,66,1],[67,0,67,2],[7,5,7,6],[10,2,10,3],[12,5,12,6],[16,5,16,6],[54,2,54,7],[62,6,62,7]]}
[]
[null,null,null,null,"FACTURE N°",null,2019,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TVA"]
[null,null,null,null,null,null,null,null,null,null,null,"Pce.",0]
[null,null,null,null,null,null,null,null,null,null,null,"ml.",5.5E-2]
["Date de Facture:","2019-05-12",null,null,null,"Destinataire :",null,null,null,null,null,"m².",0.1]
["Référence du devis:",null,null,null,null,null,null,null,null,null,null,"U",0.2]
["Numéro de client:",null,null,null,null,null,null,null,null,null,null,"Hre"]
[null,null,null,null,null,null,null,null,null,null,null,"L"]
["Modalité de paiement:","Virement fin de mois",null,null,null,null,null,null,null,null,null,"Ens"]
["Émis par:",null,null,null,null,"Adresse chantier:"]
["Contact client:"]
["Tél:"]
["Mail:"]
["Date de la prestation:",null,null,null,null,null,null,null,null,null,null,"Virement fin de mois"]
[null,null,null,null,null,null,null,null,null,null,null,"Fin de travaux"]
["Merci d'avoir choisi cette entreprise pour nos services. Service Après Vente : Garantie 1 an."]
["Description",null,"Quantités",null,null,null,null,"TOTAL TTC"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(F21),\"\",IF(E21*F21*C21>0,E21*F21*C21,0))","v":""},{"$f":"IF(SUM(C21*E21,G21)>0,SUM(C21*E21,G21),\"\")","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(SUM(C22*E22,G22)>0,SUM(C22*E22,G22),\"\")","v":""}]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[]
[null,null,null,null,null,"Total HT",null,{"$f":"IF(SUM(H21:H54)=0,\"\",SUM(H21:H54)-SUM(G21:G54))","v":""}]
[null,null,null,null,null,"TVA",null,{"$f":"IF(H56=\"\",\"\",SUM(G21:G54))","v":""}]
[null,null,null,null,null,"Total TTC",null,{"$f":"IF(SUM(H21:H54)-0=0,\"\",SUM(H21:H54))","v":""}]
[null,null,null,null,null,"Versement d'un acompte :",null,{"$f":"IF((H56)=\"\",\"\",(H58*G59))","v":""}]
[null,null,null,null,null,"Net à payer :",null,{"$f":"H58-H59","v":{"$error":"#VALUE!"}}]
[]
[]
["Entreprise:",null,"Contact:",null,null,null,"Détails bancaires"]

{"sheet":"CLIENTS","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["N°client","Societe/Nom","Adresse","Ville","TELEPHONE ","EMAIL"]
[112,"A",0,"Z",25468745,"A@Agmail.com"]
[113,"B",1,"Y",25468745,"A@Agmail.com"]
[114,"C",2,"X",25468745,"A@Agmail.com"]
[115,"D",3,"W",25468745,"A@Agmail.com"]
[116,"E",4,"V",25468745,"A@Agmail.com"]
[117,"F",5,"U",25468745,"A@Agmail.com"]
[118,"G",6,"T",25468745,"A@Agmail.com"]
[119,"H",7,"S",25468745,"A@Agmail.com"]
[120,"I",8,"R",25468745,"A@Agmail.com"]
[121,"J",9,"Q",25468745,"A@Agmail.com"]
[122,"K",10,"P",25468745,"A@Agmail.com"]
[123,"L",11,"O",25468745,"A@Agmail.com"]

{"sheet":"SuiviDevis","index":3,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["N° du DEVIS","Nom du client","N°client","Date du DEVIS","Validité du DEVIS","Accompte","Total","Reste à PAYER"]
[15,1,112,"2019-03-21","2019-04-20",0,730,730]
[15,2,112,"2019-03-21","2019-04-20",0,803,803]
[14,3,113,"2019-03-21","2019-04-20",537.94000000000005,1344.84,0]
[14,4,113,"2019-03-21","2019-04-20",1698.31,4245.78,2547.4699999999998]
[19,5,113,"2019-04-01","2019-05-01",340.62600000000003,1135.4000000000001,794.77777999900002]
[19,6,113,"2019-04-08","2019-08-05",783.65099999999995,2612.17,1828.5190000000002]
[16,7,114,"2019-04-01","2019-05-01",728.04000000000008,2426.8000000000002,1698.76]
[17,8,114,"2019-04-01","2019-05-01",743.47399499999995,2478.2399999999998,1734.77]
[18,9,115,"2019-04-01","2019-05-01",4916.1817200000005,16387.27,11471.09]
[20,10,115,"2019-04-02","2019-04-05",4030.3098000000005,13434.37,9404.0562000000009]
[21,11,116,"2019-04-06","2019-05-06",8762.0300000000007,25034.38,16272.35]
[22,12,117,"2019-04-06","2019-06-05",779.98580000000004,3899.93,3119.9432000000002]
[22,13,117,"2019-04-08","2019-08-05",1669.0690500000001,5563.56,3894.4944500000001]
[23,14,113,"2019-04-11","2019-05-11",492.09269999999998,1640.31,1148.2163]
[24,15,112,"2019-04-11","2019-05-11",0,577.5,577.5]
[25,16,118,"2019-04-12","2019-05-12",4074.3714,13581.24,9506.8666000000012]
[25,17,118,"2019-04-12","2019-12-05",3612.3714000000009,12041.24,8428.8666000000012]
[26,18,112,"2019-04-12","2019-12-05",0,484,484]
[27,19,119,"2019-04-12","2019-12-05",1669.0690500000001,5563.56,3894.4944500000001]
[28,20,112,"2019-04-15","15/05/2019",0,2354,2354]
[29,21,113,"2019-04-15","15/05/2019",0,142.71,142.708]
[30,22,120,"2019-04-15","15/05/2019",0,308,308]
[31,23,121,"2019-04-19","19/05/2019",0,88,88]
[32,24,122,"2019-04-19","19/05/2019",1637.2501199999999,5457.5,3820.2502800000002]
[32,25,122,"2019-04-19","19/05/2019",1488.4091999999998,4961.3599999999997,3472.9547999999995]
[33,26,123,"2019-04-19","19/05/2019",0,3201,3201]
[34,27,122,"2019-04-19","19/05/2019",0,1820.5,1820.5]
[34,28,122,"2019-04-19","19/05/2019",0,1655,1655]
[35,29,112,"2019-04-19","19/05/2019",0,7208.48,7208.4760000000006]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"somcond(F2:F48)","v":24469.7572},{"$f":"somcond(G2:G48)","v":92799.9},{"$f":"somcond(H2:H48)","v":68330.141399999993}]

{"sheet":"SuiviFactures","index":4,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["N° Facture","N° Devis","Date Facture","Nom du client","N°client","Date de la prestation:","Échéance du paiement","Accompte","Total","Reste à Payer","Acompte Versé","Total payé","Date de paiement","A Solder",null,"Solde"]
[1,15,"2019-03-12",1,112,"2019-03-12","Virement fin de mois",0,803,803,0,0,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":803},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":803}]
[2,24,"2019-04-11",2,112,"2019-04-11","Fin de travaux",0,577.5,577.5,0,577.5,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":0},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":0}]
[3,31,"2019-04-19",3,121,"2019-05-19","Virement fin de mois",0,88,88,0,88,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":0},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":0}]
[4,14,null,4,113,"2019-04-01","Fin de travaux",1698.31,4245.78,2547.4699999999998,1700,2545.7800000000002,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":0},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":-4.5474735088646412E-13}]
[5,19,null,5,113,"2019-04-08","Fin de travaux",783.65099999999995,2612.17,1828.52,0,2612.17,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":0},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":0}]
[6,23,null,6,113,"2019-04-10","Fin de travaux",492.09269999999998,1640.31,1148.22,500,1140.31,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":0},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":0}]
[7,26,"2019-04-26",7,112,"00:00:00","Virement fin de mois",0,484,484,0,484,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":0},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":0}]
[8,27,"2019-05-12",8,119,"00:00:00","Virement fin de mois",1669.0690500000001,5563.56,3894.49,1669.07,3894.49,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":0},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":9.0949470177292824E-13}]
[9,35,null,9,112,"00:00:00","Virement fin de mois",0,7208.48,7208.48,0,0,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":7208.48},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":7208.48}]
[10,32,"2019-05-12",10,122,"00:00:00","Virement fin de mois",1488.4091999999998,4961.3599999999997,3472.95,1488.41,3472.95,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":0},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":0}]
[11,25,null,11,118,"00:00:00","Virement fin de mois",4074.3714000000009,13581.24,9506.8700000000008,0,0,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":13581.24},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":13581.24}]
[12,31,"2019-04-12",12,121,"00:00:00","Virement fin de mois",0,88,88,0,0,null,{"$f":"Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]","v":88},null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":88}]
[13,34,"2019-05-12",13,122,"00:00:00","Virement fin de mois",496.5,1655,1158.5,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":1655}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]]=\"\",\"\",Tableau2[[#This Row],[Total]]-Tableau2[[#This Row],[Acompte Versé]]-Tableau2[[#This Row],[Total payé]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,{"$f":"somcond(I2:I35)","v":43508.4},32806,5357.48,14815.2,null,{"$f":"somcond(N2:N35)","v":21680.720000000001},null,{"$f":"somcond(P2:P35)","v":23335.72}]
[null,null,null,null,null,null,null,null,"Total","Reste à Payer","Acompte Versé","Total payé",null,"Solde",null,"Solde"]

{"sheet":"DEVISB","index":5,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,2,1,3],[15,0,15,8],[20,0,20,2],[16,0,16,2],[30,0,30,2],[12,0,13,8],[17,0,17,2],[19,0,19,2],[14,0,14,2],[21,0,21,4],[18,0,18,2],[22,0,22,8],[32,0,32,2],[27,0,27,2],[25,0,25,2],[23,0,23,2],[38,0,38,2],[36,0,36,2],[31,0,31,2],[33,0,33,2],[35,0,35,2],[37,0,37,2],[34,0,34,2],[29,0,29,8],[24,0,24,2],[26,0,26,2],[28,0,28,2],[47,0,47,2],[49,0,49,2],[60,0,60,8],[39,0,39,2],[50,0,50,2],[48,0,48,2],[54,0,54,2],[40,0,40,4],[45,0,45,8],[46,0,46,2],[51,1,51,8]]}
[]
[null,null,"DEVIS N° ",null,null,{"$f":"TODAY()","v":"2019-05-17"},null,"N° Client :",null,null,null,"unité","TVA"]
[null,null,null,null,null,null,null,null,null,null,null,"Pce.",0]
["Date du devis:",{"$f":"F2","v":"2019-05-17"},"Destinataire :",null,null,null,null,null,null,null,null,"ml.",5.5E-2]
["Numéro de client:",null,null,null,null,null,null,null,null,null,null,"m².",0.1]
["Date de validité du devis:",{"$f":"B4+30","v":"2019-06-16"},null,null,null,null,null,null,null,null,null,"U",0.2]
["Modalité de paiement:",{"$f":"IF(OR(COUNTIF(C5,\"*MR*\")=1,COUNTIF(C5,\"*MME*\")=1),\"Fin de travaux\",\"Virement fin de mois\")","v":"Virement fin de mois"},null,null,null,null,null,null,null,null,null,"Hre"]
["Émis par:",null,"Adresse chantier:",null,null,null,null,null,null,null,null,"L"]
["Contact client:",null,null,null,null,null,null,null,null,null,null,"Ens"]
["Tél:"]
["Mail:",null,null,null,null,null,null,null,null,null,null,"Virement fin de mois"]
["Durée estimée de la prestation:",null,null,null,null,null,null,null,null,null,null,"Fin de travaux"]
[]
[]
["DESCRIPTIF",null,null,"unité","Qté","Prix unitaire",null,"Tva","Montant "]
["1/ Travaux préparatoires"]
["Installation de chantier et balisage des zones d'intervention.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G17),\"\",IF(E17*F17*G17>0,E17*F17*G17,0))","v":""},{"$f":"IF(SUM(E17*F17,H17)>0,SUM(E17*F17,H17),\"\")","v":""}]
["Mise en place d'un échafaudage de pieds devant les 2 façades sous les gouttières pendantes, compris échelles d'accès, planchers de travail, plinthes et garde corps réglementaires. ",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G18),\"\",IF(E18*F18*G18>0,E18*F18*G18,0))","v":""},{"$f":"IF(SUM(E18*F18,H18)>0,SUM(E18*F18,H18),\"\")","v":""}]
["Mise en place des moyens de levage, poulie ou treuil, depuis les échafaudages en place.  ",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G19),\"\",IF(E19*F19*G19>0,E19*F19*G19,0))","v":""},{"$f":"IF(SUM(E19*F19,H19)>0,SUM(E19*F19,H19),\"\")","v":""}]
["Nettoyages périodiques du chantier et évacuations des gravois à la décharge, y compris les gravois générés par la démolition des souches de cheminés.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G20),\"\",IF(E20*F20*G20>0,E20*F20*G20,0))","v":""},{"$f":"IF(SUM(E20*F20,H20)>0,SUM(E20*F20,H20),\"\")","v":""}]
["Bâchage quotidien en fin de journée pendant la durée des travaux.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G21),\"\",IF(E21*F21*G21>0,E21*F21*G21,0))","v":""},{"$f":"IF(SUM(E21*F21,H21)>0,SUM(E21*F21,H21),\"\")","v":""}]
[null,null,null,null,null,null,"ss total :",{"$f":"SUM(H17:H21)","v":0},{"$f":"SUM(I17:I21)","v":0}]
["2/ Réfection de la couverture en tuile"]
["Dépose de la couverture tuile, des accessoires en zinc et arrachage des liteaux.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G24),\"\",IF(E24*F24*G24>0,E24*F24*G24,0))","v":""},{"$f":"IF(SUM(E24*F24,H24)>0,SUM(E24*F24,H24),\"\")","v":""}]
["Mise en place d'un écran sous toiture sous la couverture tuile, découpe et adaptation aux niveaux des lucarnes, vélux et cheminée. ",null,null,null,null,null,null,"",""]
["Remplacement des descentes pluviales en zinc naturel de 0,65mm d'épaisseur, de diamètre 80mm, compris coudes, fixations et raccordement en pied de chute.",null,null,null,null,null,null,"",""]
["Gouttière pendante en zinc naturel de 25 de développé avec façonnage de moignon et raccordement sur descente pluviale.",null,null,null,null,null,null,"",""]
["Façon et pose d'une bande d'égout en zinc naturel de 0,65 mm d'ép. avec larmier. ",null,null,null,null,null,null,"",""]
["Remplacement des chevrons abimés par chevron de section 6x8 en sapin de pays traité, comprenant coupe, assemblage et fixations. ",null,null,null,null,null,null,"",""]
["NOTA : Notre devis prévoit de remplacer 20% des chevrons de cette toiture. Si lors de la dépose nous constatons une vétusté plus importante des chevrons, un devis complémentaire vous sera alors proposé."]
["Couverture en tuile mécanique type PV13 Huguenot vieilli masse posées sur liteaux sapins de section 27x40 neufs. Compris les tuiles des dessus des lucarnes.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G31),\"\",IF(E31*F31*G31>0,E31*F31*G31,0))","v":""},{"$f":"IF(SUM(E31*F31,H31)>0,SUM(E31*F31,H31),\"\")","v":""}]
["Façon des noues en zinc au dessus des lucarnes comprenant coupe des tuiles, soudure et toutes sujétions de raccordement.",null,null,null,null,null,null,"",""]
["Habillage des joués de lucarne en zinc naturel de 0,65mmd'ép. bande à rabattre, et joint élastomère de finitions.   ",null,null,null,null,null,null,"",""]
["Plus value pour dépose de châssis Velux et fermeture du chevêtre existant par la nouvelle couverture en tuile.",null,null,null,null,null,null,"",""]
["Dépose et repose après coup de châssis Velux conservé.  ",null,null,null,null,null,null,"",""]
["Derrière de cheminée en zinc naturel de 0,65mm d'ép.  ",null,null,null,null,null,null,"",""]
["Bande de filet de plomb de 1,5mm d'ép. contre cheminée et bande porte solin en zinc avec rebouchage mortier.",null,null,null,null,null,null,"",""]
["Tuile de ventilation type PV13. (chatière de ventilation)",null,null,null,null,null,null,"",""]
["Rive extérieur en tuile débordante comprenant bande de rive en zinc avec ourlet rechassé. ",null,null,null,null,null,null,"",""]
["Faitage en tuile demi-ronde, comprenant closoir ventilé et tasseau de faitage neuf. ",null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"ss total :",{"$f":"SUM(H24:H40)","v":0},{"$f":"SUM(I24:I40)","v":0}]
[]
[]
[]
[]
["3/ Réfection corps des cheminées"]
["Casse et démolition de corps de cheminée au dessus de la toiture, au préalable protections complémentaires par bâche polyane et filet grande maille. Mise en sac des gravois.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G47),\"\",IF(E47*F47*G47>0,E47*F47*G47,0))","v":""},{"$f":"IF(SUM(E47*F47,H47)>0,SUM(E47*F47,H47),\"\")","v":""}]
["Réfection du corps de souche de cheminée, comprenant piochage, ragréage sur maille métallique et enduits de finition.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G48),\"\",IF(E48*F48*G48>0,E48*F48*G48,0))","v":""},{"$f":"IF(SUM(E48*F48,H48)>0,SUM(E48*F48,H48),\"\")","v":""}]
["Réfection de couronnement de cheminée, brossage et application d'une résine de protection. ",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G49),\"\",IF(E49*F49*G49>0,E49*F49*G49,0))","v":""},{"$f":"IF(SUM(E49*F49,H49)>0,SUM(E49*F49,H49),\"\")","v":""}]
["Remplacement de mitrons en terre cuite et scellement sur couronnement.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G50),\"\",IF(E50*F50*G50>0,E50*F50*G50,0))","v":""},{"$f":"IF(SUM(E50*F50,H50)>0,SUM(E50*F50,H50),\"\")","v":""}]
["Fourniture et pose de chapeau galvanisé sur mitron.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G51),\"\",IF(E51*F51*G51>0,E51*F51*G51,0))","v":""},{"$f":"IF(SUM(E51*F51,H51)>0,SUM(E51*F51,H51),\"\")","v":""}]
[]
[null,null,null,null,null,null,"ss total :",{"$f":"SUM(H47:H51)","v":0},{"$f":"SUM(I47:I51)","v":0}]
[null,null,null,null,"  "]
["  Signature du client (précédée de la mention « Bon pour accord »)",null,null,null,null,null,"Montant TOTAL HT:",null,{"$f":"SUM(I22,I41,I53)-SUM(H22,H41,H53)","v":0}]
[null,null,null,null,null,null,"TVA :",null,{"$f":"SUM(H22,H41,H53)","v":0}]
[null,null,null,null,null,null,"Montant TOTAL TTC :",null,{"$f":"SUM(I55:I56)","v":0}]
[null,null,null,null,null,null,"Acompte :",0.3,{"$f":"I57*H58","v":0}]
[null,null,null,null,null,null,"SOLDE :",null,{"$f":"I57-I58","v":0}]
[]
["NOTA : Malgré les précautions d'usage, nous ne pouvons être tenu responsables d'éventuel dégât aux plafonds du dernier étage. La nature même de nos travaux, fixation des liteaux et des chevrons généreront des vibrations et sont inhérents aux travaux.   "]

{"sheet":"FACTUREB","index":6,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[17,0,17,2],[1,2,1,3],[12,0,13,8],[14,0,14,2],[15,0,15,8],[16,0,16,2],[29,0,29,8],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,4],[22,0,22,8],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[45,0,45,8],[30,0,30,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,4],[60,0,60,8],[46,0,46,2],[47,0,47,2],[48,0,48,2],[49,0,49,2],[50,0,50,2],[54,0,54,2],[51,1,51,8]]}
[]
[null,null,"FACTURE N°",null,"14",{"$f":"TODAY()","v":"2019-05-17"},null,"N° Client :",null,null,null,"unité","TVA"]
[null,null,null,null,null,null,null,null,null,null,null,"Pce.",0]
["Date du devis:",{"$f":"F2","v":"2019-05-17"},"Destinataire :",null,null,null,null,null,null,null,null,"ml.",5.5E-2]
["Référence du devis:",null,null,null,null,null,null,null,null,null,null,"m².",0.1]
["Date de validité du devis:",{"$f":"B4+30","v":"2019-06-16"},null,null,null,null,null,null,null,null,null,"U",0.2]
["Modalité de paiement:",{"$f":"IF(OR(COUNTIF(C5,\"*MR*\")=1,COUNTIF(C5,\"*MME*\")=1),\"Fin de travaux\",\"Virement fin de mois\")","v":"Virement fin de mois"},null,null,null,null,null,null,null,null,null,"Hre"]
["Émis par:",null,"Adresse chantier:",null,null,null,null,null,null,null,null,"L"]
["Contact client:",null,null,null,null,null,null,null,null,null,null,"Ens"]
["Tél:"]
["Mail:",null,null,null,null,null,null,null,null,null,null,"Virement fin de mois"]
["Durée estimée de la prestation:",null,null,null,null,null,null,null,null,null,null,"Fin de travaux"]
[]
[]
["DESCRIPTIF",null,null,"unité","Qté","Prix unitaire",null,"Tva","Montant "]
["1/ Travaux préparatoires"]
["Installation de chantier et balisage des zones d'intervention.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G17),\"\",IF(E17*F17*G17>0,E17*F17*G17,0))","v":""},{"$f":"IF(SUM(E17*F17,H17)>0,SUM(E17*F17,H17),\"\")","v":""}]
["Mise en place d'un échafaudage de pieds devant les 2 façades sous les gouttières pendantes, compris échelles d'accès, planchers de travail, plinthes et garde corps réglementaires. ",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G18),\"\",IF(E18*F18*G18>0,E18*F18*G18,0))","v":""},{"$f":"IF(SUM(E18*F18,H18)>0,SUM(E18*F18,H18),\"\")","v":""}]
["Mise en place des moyens de levage, poulie ou treuil, depuis les échafaudages en place.  ",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G19),\"\",IF(E19*F19*G19>0,E19*F19*G19,0))","v":""},{"$f":"IF(SUM(E19*F19,H19)>0,SUM(E19*F19,H19),\"\")","v":""}]
["Nettoyages périodiques du chantier et évacuations des gravois à la décharge, y compris les gravois générés par la démolition des souches de cheminés.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G20),\"\",IF(E20*F20*G20>0,E20*F20*G20,0))","v":""},{"$f":"IF(SUM(E20*F20,H20)>0,SUM(E20*F20,H20),\"\")","v":""}]
["Bâchage quotidien en fin de journée pendant la durée des travaux.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G21),\"\",IF(E21*F21*G21>0,E21*F21*G21,0))","v":""},{"$f":"IF(SUM(E21*F21,H21)>0,SUM(E21*F21,H21),\"\")","v":""}]
[null,null,null,null,null,null,"ss total :",{"$f":"SUM(H17:H21)","v":0},{"$f":"SUM(I17:I21)","v":0}]
["2/ Réfection de la couverture en tuile"]
["Dépose de la couverture tuile, des accessoires en zinc et arrachage des liteaux.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G24),\"\",IF(E24*F24*G24>0,E24*F24*G24,0))","v":""},{"$f":"IF(SUM(E24*F24,H24)>0,SUM(E24*F24,H24),\"\")","v":""}]
["Mise en place d'un écran sous toiture sous la couverture tuile, découpe et adaptation aux niveaux des lucarnes, vélux et cheminée. ",null,null,null,null,null,null,"",""]
["Remplacement des descentes pluviales en zinc naturel de 0,65mm d'épaisseur, de diamètre 80mm, compris coudes, fixations et raccordement en pied de chute.",null,null,null,null,null,null,"",""]
["Gouttière pendante en zinc naturel de 25 de développé avec façonnage de moignon et raccordement sur descente pluviale.",null,null,null,null,null,null,"",""]
["Façon et pose d'une bande d'égout en zinc naturel de 0,65 mm d'ép. avec larmier. ",null,null,null,null,null,null,"",""]
["Remplacement des chevrons abimés par chevron de section 6x8 en sapin de pays traité, comprenant coupe, assemblage et fixations. ",null,null,null,null,null,null,"",""]
["NOTA : Notre devis prévoit de remplacer 20% des chevrons de cette toiture. Si lors de la dépose nous constatons une vétusté plus importante des chevrons, un devis complémentaire vous sera alors proposé."]
["Couverture en tuile mécanique type PV13 Huguenot vieilli masse posées sur liteaux sapins de section 27x40 neufs. Compris les tuiles des dessus des lucarnes.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G31),\"\",IF(E31*F31*G31>0,E31*F31*G31,0))","v":""},{"$f":"IF(SUM(E31*F31,H31)>0,SUM(E31*F31,H31),\"\")","v":""}]
["Façon des noues en zinc au dessus des lucarnes comprenant coupe des tuiles, soudure et toutes sujétions de raccordement.",null,null,null,null,null,null,"",""]
["Habillage des joués de lucarne en zinc naturel de 0,65mmd'ép. bande à rabattre, et joint élastomère de finitions.   ",null,null,null,null,null,null,"",""]
["Plus value pour dépose de châssis Velux et fermeture du chevêtre existant par la nouvelle couverture en tuile.",null,null,null,null,null,null,"",""]
["Dépose et repose après coup de châssis Velux conservé.  ",null,null,null,null,null,null,"",""]
["Derrière de cheminée en zinc naturel de 0,65mm d'ép.  ",null,null,null,null,null,null,"",""]
["Bande de filet de plomb de 1,5mm d'ép. contre cheminée et bande porte solin en zinc avec rebouchage mortier.",null,null,null,null,null,null,"",""]
["Tuile de ventilation type PV13. (chatière de ventilation)",null,null,null,null,null,null,"",""]
["Rive extérieur en tuile débordante comprenant bande de rive en zinc avec ourlet rechassé. ",null,null,null,null,null,null,"",""]
["Faitage en tuile demi-ronde, comprenant closoir ventilé et tasseau de faitage neuf. ",null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"ss total :",{"$f":"SUM(H24:H40)","v":0},{"$f":"SUM(I24:I40)","v":0}]
[]
[]
[]
[]
["3/ Réfection corps des cheminées"]
["Casse et démolition de corps de cheminée au dessus de la toiture, au préalable protections complémentaires par bâche polyane et filet grande maille. Mise en sac des gravois.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G47),\"\",IF(E47*F47*G47>0,E47*F47*G47,0))","v":""},{"$f":"IF(SUM(E47*F47,H47)>0,SUM(E47*F47,H47),\"\")","v":""}]
["Réfection du corps de souche de cheminée, comprenant piochage, ragréage sur maille métallique et enduits de finition.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G48),\"\",IF(E48*F48*G48>0,E48*F48*G48,0))","v":""},{"$f":"IF(SUM(E48*F48,H48)>0,SUM(E48*F48,H48),\"\")","v":""}]
["Réfection de couronnement de cheminée, brossage et application d'une résine de protection. ",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G49),\"\",IF(E49*F49*G49>0,E49*F49*G49,0))","v":""},{"$f":"IF(SUM(E49*F49,H49)>0,SUM(E49*F49,H49),\"\")","v":""}]
["Remplacement de mitrons en terre cuite et scellement sur couronnement.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G50),\"\",IF(E50*F50*G50>0,E50*F50*G50,0))","v":""},{"$f":"IF(SUM(E50*F50,H50)>0,SUM(E50*F50,H50),\"\")","v":""}]
["Fourniture et pose de chapeau galvanisé sur mitron.",null,null,null,null,null,null,{"$f":"IF(ISBLANK(G51),\"\",IF(E51*F51*G51>0,E51*F51*G51,0))","v":""},{"$f":"IF(SUM(E51*F51,H51)>0,SUM(E51*F51,H51),\"\")","v":""}]
[]
[null,null,null,null,null,null,"ss total :",{"$f":"SUM(H47:H51)","v":0},{"$f":"SUM(I47:I51)","v":0}]
[null,null,null,null,"  "]
["  Signature du client (précédée de la mention « Bon pour accord »)",null,null,null,null,null,"Montant TOTAL HT:",null,{"$f":"SUM(I22,I41,I53)-SUM(H22,H41,H53)","v":0}]
[null,null,null,null,null,null,"TVA :",null,{"$f":"SUM(H22,H41,H53)","v":0}]
[null,null,null,null,null,null,"Montant TOTAL TTC :",null,{"$f":"SUM(I55:I56)","v":0}]
[null,null,null,null,null,null,"Acompte :",0.3,{"$f":"I57*H58","v":0}]
[null,null,null,null,null,null,"SOLDE :",null,{"$f":"I57-I58","v":0}]
[]
["NOTA : Malgré les précautions d'usage, nous ne pouvons être tenu responsables d'éventuel dégât aux plafonds du dernier étage. La nature même de nos travaux, fixation des liteaux et des chevrons généreront des vibrations et sont inhérents aux travaux.   "]

{"sheet":"BASE_Données","index":7,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["Michou"]
["Main d'œuvre ","Hre",85]
[]
["Main d'œuvre 1","Hre",70]
["Main d'œuvre 2","Hre",65]
["Main d'œuvre 3","Hre"]
[]
["Evacuation Gravats","U",150]
["Déplacement","U",80]
[]
[]
["Protection antirouille des poutres IPN","ml.",6.73]
["Piochage et réfection des solins garnissage étanche réalisé en mortier plâtre/ciment","ml.",72.45,null,null,null,"Déplacement",null,null,"Pce."]
["Pose de Bande d’étanchéité en bitume Veral SBS ","ml.",59.85,null,null,null,"Nettoyage chantier ",null,null,"ml."]
["Couvre joint tasseau QUARTZ 0,65 x 120 x 2000 mm","ml.",13.96,null,null,null,"Évacuation des gravats",null,null,"m²."]
["Installation de chantier et balisage des zones d'intervention.","Ens",448.5,null,null,null,null,null,null,"U"]
["Mise en place des moyens de levage, poulie ou treuil, depuis les échafaudages en place.  ","Ens",147.5,null,null,null,null,null,null,"Hre"]
["Mise en place d'un échafaudage de pieds devant les 2 façades sous les gouttières pendantes, compris échelles d'accès, planchers de travail, plinthes et garde corps réglementaires. ","ml.",146,null,null,null,null,null,null,"L"]
["Dépose de la couverture tuile, des acccessoires en zinc et arrachage des litteaux.","m².",10.43,null,null,null,null,null,null,"Ens"]
["Mise en place d'un écran sous toiture sous la couverture tuile, découpe et adaptation aux niveaux des lucarnes, vélux et cheminée. ","m².",9.4499999999999993]
["Remplacement des descentes pluviales en zinc naturel de 0,65mm d'épaisseur, de diamètre 80mm, compris coudes, fixations et raccordement en pied de chute.","U",240.6]
["Gouttière pendante en zinc naturel de 25 de développé avec façonnage de moignon et raccordement sur descente pluviale.","ml.",55.05]
["Façon et pose d'une bande d'egout en zinc naturel de 0,65 mm d'ép. avec larmier. ","ml.",58.95]
["Remplacement des chevrons abimés par chevron de section 6x8 en sapin de pays traité, comprenant coupe, assemblage et fixations. ","m².",42.9]
["Couverture en tuile mécanique type PV13 Huguenot vieilli masse posées sur liteaux sapins de section 27x40 neufs. Compris les tuiles des dessus des lucarnes.","m².",68.05]
["Façon des noues en zinc au dessus des lucarnes comprenant coupe des tuiles, soudure et toutes sujétions de raccordement.","U",162.5]
["Habillage des joués de lucarne en zinc naturel de 0,65mmd'ép. bande à rabattre, et joint élastomère de finitions.   ","U",145.62]
["Plus value pour dépose de chassis Velux et fermeture du chevêtre existant par la nouvelle couverture en tuile.","U",56.48]
["Dépose et repose après coup de chassis Velux conservé.  ","U",94.95]
["Derrière de cheminée en zinc naturel de 0,65mm d'ép.  ","U",99.6]
["Bande de filet de plomb de 1,5mm d'ép contre cheminée et bande porte solin en zinc avec rebouchage mortier.","ml.",69.150000000000006]
["Tuile de ventilation type PV13. (chatière de ventilation)","U",40.200000000000003]
["Rive extérieur en tuile débordante comprenant bande de rive en zinc avec ourlet rechassé. ","ml.",45.05]
["Faitage en tuile demi-ronde, comprenant closoir ventilé et tasseau de faitage neuf. ","ml.",67.760000000000005]
["Casse et démolition de corps de cheminée au dessus de la toiture, au préalable protections complémentaires par bâche polyane et filet grande maille. Mise en sac des gravois.","U",388.5]
["Réfection du corps de souche de cheminée, comprenant piochage, réagréage sur maille métallique et enduits de finition.","U",1115.23]
["Réfection de couronnement de cheminée, brossage et application d'une résine de protection. ","U",355.6]
["Remplacement de mitrons en terre cuite et scellement sur couronnement.","U",92.96]
["Fourniture et pose de chapeau galvanisé sur mitron.","U",44.09]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NOTA : Notre devis prévoit de remplacer 20% des chevrons de cette toiture. Si lors de la dépose nous constatons une vétustée plus importante des chevrons, un devis complèmentaire vous sera alors proposé."]
[]
["NOTA : Malgrè les précautions d'usage, nous ne pouvons être tenu responsables d'éventuel dégat aux plafonds du dernier étage. La nature même de nos travaux, fixation des liteaux et des chevrons généreront des vibrations et sont inhérents aux travaux.   "]