{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["pdg","Devis","suivi ss tt p direct","suivi co traitant","be sit","attest p direct","remise m propre","rev prix","avance forfaitaire","sit 1 04 18"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":6,"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":"pdg","index":0,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,3,0,5],[31,0,31,3],[31,5,31,8],[1,0,1,8],[3,0,3,8],[17,0,17,3],[17,5,17,8],[23,0,23,8]]}
[null,null,null,"18 - xx"]
["nom de l'affaire"]
[]
["lot + intitulé du lot"]
[]
["Maitre d'Ouvrage / Titulaire :",null,null,null,null,"Maître d'Œuvre :"]
[]
[]
[]
[]
["Tel : "]
["Fax : "]
["E-mail : ","/",null,null,null,"Port : "]
[null,null,null,null,null,"E-mail :"]
[]
[]
[]
["SARL AV.CO.BOIS"]
["Montant total du marché de base H.T. :   ",null,null,{"$f":"+Devis!H31","v":0},null,"reste à facturer au 1/1/14 :",null,{"$f":"+D19","v":0}]
[null,null,null,{"$f":"+A9","v":0}]
["Caution Bancaire n°  :"]
[]
[]
["Procédure de facturation"]
[]
[null,"Situation à envoyer en xx exemplaires avant le xx à xx"]
[null,"et copie mail à xxx  (OPC) xxx  pour validation avancement "]
[]
[]
[]
[]
["FACTURATION AV.CO.BOIS"]
[]
[null,"HT","TTC","CUMUL HT"]
["Sit 1   le",null,{"$f":"B35*1.196","v":0},{"$f":"B35","v":0}]
["prorata"]
[]
["Sit 2 le ",null,{"$f":"B38*1.196","v":0},{"$f":"B35+B38","v":0}]
["prorata"]
[]
["Sit 3 le ",null,{"$f":"B41*1.196","v":0},{"$f":"D38+B41","v":0}]
["prorata"]
[]
["Sit 4",null,{"$f":"B44*1.196","v":0}]
["prorata"]
[]
["Sit 5",null,{"$f":"B47*1.196","v":0}]
["prorata"]
[]
["Sit 6",null,{"$f":"B50*1.196","v":0}]
["prorata"]
[]
["Total avancement des travaux HT ",null,null,{"$f":"D35+B38+B41+B44+B47+B50","v":0}]
["% Cumul avancement des travaux",null,null,{"$f":"D53/D19","v":{"$error":"#DIV/0!"}}]

{"sheet":"Devis","index":1,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,1,10,2],[16,6,16,7],[22,2,22,3],[18,1,18,5],[19,1,19,5],[21,2,21,3]]}
[null,null,null,null,"4252 route de Baziège 31670 LABEGE",null,null,null,"Le :","2018-04-09"]
[null,null,null,null,"Tél : 05 32 09 13 96 - Fax : 05 32 09 13 98 "]
[null,null,null,null,"Email : contact@avcobois.com"]
[null,null,null,null,"AVIVA n°76818699 - 32 rue du Fg Bonnefoy 31500 TOULOUSE"]
[null,null,null,null,"Certificat QUALIBAT RGE n°116040"]
[]
[]
[]
[]
[null,"Devis n° 2018XXX",null,null,null,{"$f":"+pdg!A7","v":0}]
[null,null,null,null,null,{"$f":"+pdg!A8","v":0}]
[null,null,null,null,null,{"$f":"+pdg!A9","v":0}]
[]
[null,null,null,null,null,{"$f":"\"A Labège, le \"& DAY(J1) & \"/\"& MONTH(J1) & \"/\" & YEAR(J1)","v":"A Labège, le 9/4/2018"}]
[]
[null,"Lieu d'exécution de l'intervention :"]
[null,"XXX",null,null,null,null,{"$f":"\"Devis valable jusqu'au \"& DAY(J1+30) & \"/\"& MONTH(J1+30) & \"/\" & YEAR(J1+30)","v":"Devis valable jusqu'au 9/5/2018"}]
[null,"XXX",null,null,null,null,"Préparé par : Mélanie CARMONA"]
[null,"Nature des travaux",null,null,null,null,"REPRÉSENTANT","CONDITIONS"]
[null,{"$f":"pdg!A2","v":"nom de l'affaire"},null,null,null,null,"Didier MARFAING","A réception\n30% acompte à la commande"]
[]
[null,"Poste","DESCRIPTION",null,"Unit","Qté","Prix unit.","Prix total en €"]
[null,null,"FOURNITURE ET POSE",null,null,null,null,{"$f":"F23*G23","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,{"$f":"pdg!A4","v":"lot + intitulé du lot"},null,null,null,null,{"$f":"F25*G25","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,"TOTAL GÉNÉRAL H.T.",null,{"$f":"SUM(H23:H30)","v":0}]
[null,null,null,null,null,"T.V.A.",0.2,{"$f":"H31*G32","v":0}]
[null,null,null,null,null,"TOTAL GÉNÉRAL T.T.C.",null,{"$f":"H31+H32","v":0}]
[]
[null,"Conditions de Règlement : "]
[null,null,"A réception",null,null,null,null,"Mr MARFAING Didier"]
[null,null,"30% acompte à la commande",null,null,null,null,"Gérant"]

{"sheet":"suivi ss tt p direct","index":2,"n_rows":101,"n_cols":12,"rows_kept":101,"cut":false,"hidden":false,"merged":[[29,0,31,0],[5,6,5,7],[7,0,9,0],[15,6,15,7],[17,0,19,0],[21,6,21,7],[23,0,25,0],[27,6,27,7],[1,0,1,11],[2,0,2,11],[3,0,3,11],[7,9,7,11],[8,9,9,9]]}
[]
[{"$f":"CONCATENATE(\"MARCHE : \",pdg!D1)","v":"MARCHE : 18 - xx"}]
[{"$f":"+pdg!A2","v":"nom de l'affaire"}]
[{"$f":"+pdg!A4","v":"lot + intitulé du lot"}]
[]
[null,"TVA 20%",null,null,"1,5% Prorata","5% RG","CB / GAPD",null,"RESTE 100% TTC"]
[null,null,"HT","TTC",null,null,"TTC","n°"]
["AV.CO.BOIS\nMARCHE","MARCHE DE BASE : ",{"$f":"+Devis!H31","v":0},{"$f":"+Devis!H33","v":0},0,{"$f":"+D8*0.05","v":0},null,null,{"$f":"+D8-#REF!","v":{"$error":"#REF!"}},"AV.CO.BOIS S/T  DEDUITS"]
[null,"AVENANT :",null,null,{"$f":"+C9*0.05","v":0},{"$f":"+D9*0.05","v":0},null,null,{"$f":"+D9-#REF!","v":{"$error":"#REF!"}},"MARCHE DE \nBASE : ","HT","TTC"]
[null,"MARCHE FINAL :",{"$f":"C8+C9","v":0},{"$f":"D8+D9","v":0},0,{"$f":"+D10*0.05","v":0},null,null,{"$f":"+D10-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+C10-C20-C26-C32","v":0},{"$f":"+D10-D20-D26-D32","v":0}]
[]
[]
["SOUS TRAITANT EN PAIEMENT DIRECT PAR LA MOA"]
[]
["SOUS TRAITANT DE 1ER RANG :"]
[null,null,null,null,"1,5% Prorata","5% RG","CB / GAPD",null,"RESTE 100% TTC"]
[null,null,"HT","TTC",null,null,"TTC","n°"]
[null,"MARCHE DE BASE : ",null,{"$f":"C18*1.2","v":0},{"$f":"+D18*0.015","v":0},{"$f":"+D18*0.05","v":0},null,null,{"$f":"+D18-E18-F18","v":0}]
[null,null,null,{"$f":"C19*1.196","v":0},{"$f":"+D19*0.015","v":0},{"$f":"+D19*0.05","v":0},null,null,{"$f":"+D19-E19-F19","v":0}]
[null,"MARCHE FINAL :",{"$f":"C18","v":0},{"$f":"C20*1.2","v":0},{"$f":"+D20*0.015","v":0},{"$f":"+D20*0.05","v":0},null,null,{"$f":"+D20-E20-F20","v":0}]
[]
[null,null,null,null,"1,5% Prorata","5% RG","CB / GAPD",null,"RESTE 100% TTC"]
[null,null,"HT","TTC",null,null,"TTC","n°"]
[null,"MARCHE DE BASE : ",null,{"$f":"C24","v":0},{"$f":"+D24*0.015","v":0},{"$f":"+D24*0.05","v":0},null,null,{"$f":"+D24-E24-F24","v":0}]
[null,"Avenant :",null,null,{"$f":"+D25*0.015","v":0},{"$f":"+D25*0.05","v":0},null,null,{"$f":"+D25-E25-F25","v":0}]
[null,"MARCHE FINAL :",{"$f":"C24+C25","v":0},{"$f":"C26","v":0},{"$f":"+D26*0.015","v":0},{"$f":"+D26*0.05","v":0},null,null,{"$f":"+D26-E26-F26","v":0}]
[]
[null,null,null,null,"1,5% Prorata","5% RG","CB / GAPD",null,"RESTE 100% TTC"]
[null,null,"HT","TTC",null,null,"TTC","n°"]
[null,"MARCHE DE BASE : ",null,{"$f":"C30","v":0},{"$f":"+D30*0.015","v":0},{"$f":"+D30*0.05","v":0},null,null,{"$f":"+D30-E30-F30","v":0}]
[null,null,null,{"$f":"C31*1.196","v":0},{"$f":"+D31*0.015","v":0},{"$f":"+D31*0.05","v":0},null,null,{"$f":"+D31-E31-F31","v":0}]
[null,"MARCHE FINAL :",{"$f":"C30","v":0},{"$f":"C32","v":0},{"$f":"+D32*0.015","v":0},{"$f":"+D32*0.05","v":0},null,null,{"$f":"+D32-E32-F32","v":0}]
[]
[]
[null,{"$f":"+A3","v":"nom de l'affaire"}]
[null,{"$f":"+A4","v":"lot + intitulé du lot"}]
[null,"FACTURATION"]
[]
[null,null,"TOTAL FACTURE","% avancement","SIT 1","SIT 2  95%","SIT 3","SIT 4","SIT 5","SIT 6","SIT 7"]
[]
[null,null,null,null,"HT","HT","HT","HT","HT","HT","HT"]
["MARCHE AV.CO.BOIS","HT",{"$f":"SUM(E42:K42)","v":0},{"$f":"C42/C10","v":{"$error":"#DIV/0!"}}]
[null,"TTC",{"$f":"SUM(E43:K43)","v":0},{"$f":"C43/D10","v":{"$error":"#DIV/0!"}}]
[{"$f":"+A18","v":0},"HT",{"$f":"SUM(E44:K44)","v":0},{"$f":"C44/C20","v":{"$error":"#DIV/0!"}}]
[null,"TTC",{"$f":"SUM(E45:K45)","v":0},{"$f":"C45/D20","v":{"$error":"#DIV/0!"}}]
[{"$f":"+A24","v":0},"HT",0,{"$f":"C46/C26","v":{"$error":"#DIV/0!"}}]
[null,"TTC",0,{"$f":"C47/D26","v":{"$error":"#DIV/0!"}}]
[{"$f":"+A30","v":0},"HT",0,{"$f":"C48/C32","v":{"$error":"#DIV/0!"}}]
[null,"TTC",0,{"$f":"C49/D32","v":{"$error":"#DIV/0!"}}]
["RESTE A PERCEVOIR","HT",0,{"$f":"C50/K10","v":{"$error":"#DIV/0!"}},{"$f":"E42-E44-E46-E48","v":0},0,0,0,0,0,0]
["POUR AV.CO.BOIS","TTC",0,{"$f":"C51/L10","v":{"$error":"#DIV/0!"}},{"$f":"E43-E45-E49-E47","v":0},0,0,0,0,0,0]
[]
[null,"EXTRAIT DE LA COMPTABILITE",null,null,"SIT 1","SIT 2  ","SIT 3","SIT 4","SIT 5","SIT 6","SIT 7"]
[null,"MARCHE AV.CO.BOIS","date de reglement"]
[null,null,"reglement TTC",{"$f":"SUM(E55:K55)","v":0}]
[]
[]
[]
[null,null,"RESTE A FACTURER ","RESTE A ENCAISSER"]
[null,null,null,"TTC"]
["MARCHE AV.CO.BOIS","HT",{"$f":"C10-C42","v":0}]
[null,"TTC",{"$f":"+D10-C43","v":0},{"$f":"+I10-C43","v":{"$error":"#REF!"}}]
[{"$f":"+A18","v":0},"HT",{"$f":"+C20-C44","v":0}]
[null,"TTC",{"$f":"+D20-C45","v":0},{"$f":"+I20-C45","v":0},null," "]
[{"$f":"+A24","v":0},"HT",{"$f":"+C26-C46","v":0}]
[null,"TTC",{"$f":"+D26-C47","v":0},{"$f":"+I26-C47","v":0}]
[{"$f":"+A30","v":0},"HT",{"$f":"+C32-C48","v":0}]
[null,"TTC",{"$f":"+D32-C49","v":0},{"$f":"+I32-C49","v":0}]
["RESTE A FACTURER",null,{"$f":"C61-C63-C65-C67","v":0}]
["POUR AV.CO.BOIS",null,{"$f":"C62-C64-C66-C68","v":0}]
[]
[]
[]
["AUTRES FACTURATIONS - AVCOBOIS VERS UN AUTRES CLIENT MAIS POUR LE MEME CHANTIER"]
[null,null,"TOTAL FACTURE","% avancement","Autre facturation 1","Autre facturation 2","Autre facturation 3","Autre facturation 4","Autre facturation 5"]
[null,null,null,null,"Date","Date","Date","Date","Date"]
["Nom du client","HT",{"$f":"SUM(E77:K77)","v":{"$error":"#REF!"}},{"$f":"C77/C44","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"TTC",{"$f":"SUM(E78:K78)","v":{"$error":"#REF!"}},{"$f":"C78/D44","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+A52","v":0},"HT",{"$f":"SUM(E79:K79)","v":0},{"$f":"C79/C54","v":{"$error":"#VALUE!"}}]
[null,"TTC",{"$f":"SUM(E80:K80)","v":0},{"$f":"C80/D54","v":{"$error":"#DIV/0!"}}]
[{"$f":"+A58","v":0},"HT",0,{"$f":"C81/C60","v":{"$error":"#DIV/0!"}}]
[null,"TTC",0,{"$f":"C82/D60","v":{"$error":"#VALUE!"}}]
[{"$f":"+A64","v":0},"HT",0,{"$f":"C83/C66","v":{"$error":"#DIV/0!"}}]
[null,"TTC",0,{"$f":"C84/D66","v":{"$error":"#DIV/0!"}}]
["RESTE A PERCEVOIR","HT",{"$error":"#REF!"},{"$f":"C85/K44","v":{"$error":"#REF!"}},{"$f":"E77-E79-E81-E83","v":{"$error":"#REF!"}},0,0,0,0,0,0]
["POUR AV.CO.BOIS","TTC",{"$error":"#REF!"},{"$f":"C86/L44","v":{"$error":"#REF!"}},{"$f":"E78-E80-E84-E82","v":{"$error":"#REF!"}},0,0,0,0,0,0]
[]
[null,"EXTRAIT DE LA COMPTABILITE",null,null,"SIT 1","SIT 2  ","SIT 3","SIT 4","SIT 5","SIT 6","SIT 7"]
[null,"MARCHE AV.CO.BOIS","date de reglement"]
[null,null,"reglement TTC",{"$f":"SUM(E90:K90)","v":0}]
[]
[]
[]
["SUIVI DES TRAVAUX SUPPLEMENTAIRES FAITS - VALIDES - REALISES"]
[null,null,null,"envoyé le","validé le","facturé le","HT","TTC"]
[null,"TS 1","Devis n°xx","destinataire ts",null,null,0,0]
[null,"description ts1","date  du devis ts","date envoie au dest",null,"2018-03-20"]
[null,"TS 2","Devis n°xx","destinataire ts"]
[null,"description ts2","date  du devis ts","date envoie au dest"]
[null,"TS 3","Devis n°xx","destinataire ts"]
[null,"description ts3","date  du devis ts","date envoie au dest",null,"2018-03-26"]

{"sheet":"suivi co traitant","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[10,0,12,0],[1,0,1,5],[2,0,2,5],[3,0,3,5],[5,6,5,7],[7,0,9,0]]}
[]
[{"$f":"CONCATENATE(\"MARCHE : \",pdg!D1)","v":"MARCHE : 18 - xx"}]
[{"$f":"+pdg!A2","v":"nom de l'affaire"}]
[{"$f":"+pdg!A4","v":"lot + intitulé du lot"}]
[]
[null,"TVA 20%",null,null,"1,5% Prorata","5% RG","CB / GAPD",null,"RESTE 100% TTC"]
[null,null,"HT","TTC",null,null,"TTC","n°"]
["ATE \nMARCHE","MARCHE DE BASE : ",null,{"$f":"+C8*1.2","v":0},0,{"$f":"+D8*0.05","v":0},null,null,{"$f":"+D8-E8-F8","v":0}]
[null,"AVENANT :",null,null,{"$f":"+C9*0.05","v":0},0,null,null,0]
[null,"MARCHE FINAL :",{"$f":"C8+C9","v":0},{"$f":"D8+D9","v":0},{"$f":"+C10*0.015","v":0},0,null,null,0]
["ABADIE \nMARCHE","MARCHE DE BASE : ",82540,{"$f":"+C11*1.2","v":99048},1,4952.4000000000005,null,null,94094.6]
[null,"AVENANT :",null,null,{"$f":"+C12*0.05","v":0},0,null,null,0]
[null,"MARCHE FINAL :",{"$f":"C11+C12","v":82540},{"$f":"D11+D12","v":99048},{"$f":"+C13*0.015","v":1238.0999999999999},4952.4000000000005,null,null,92857.5]
[]
[null,{"$f":"+A3","v":"nom de l'affaire"}]
[null,{"$f":"+A4","v":"lot + intitulé du lot"}]
[null,"FACTURATION"]
[]
[null,null,"TOTAL FACTURE","% avancement","SIT 1","SIT 2  95%","SIT 3","SIT 4","SIT 5","SIT 6","SIT 7"]
[]
[null,null,null,null,"HT","HT","HT","HT","HT","HT","HT"]
[{"$f":"+A8","v":"ATE \nMARCHE"},"HT",{"$f":"SUM(E22:K22)","v":{"$error":"#REF!"}},{"$f":"C22/C10","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"TTC",{"$f":"SUM(E23:K23)","v":{"$error":"#REF!"}},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+A11","v":"ABADIE \nMARCHE"},"HT",{"$f":"SUM(E24:K24)","v":0},{"$f":"C24/C13","v":0}]
[null,"TTC",{"$f":"SUM(E25:K25)","v":0}]
[]
[]
[null,{"$f":"+K10-#REF!","v":{"$error":"#REF!"}}]
[null,null,"RESTE A FACTURER ","RESTE A ENCAISSER"]
[null,null,null,"TTC"]
[{"$f":"+A22","v":"ATE \nMARCHE"},"HT",{"$f":"C10-C22","v":{"$error":"#REF!"}}]
[null,"TTC",{"$f":"+D10-C23","v":{"$error":"#REF!"}},{"$f":"+I10-C23","v":{"$error":"#REF!"}}]
[{"$f":"+A24","v":"ABADIE \nMARCHE"},"HT",{"$f":"C13-C24","v":82540}]
[null,"TTC",{"$f":"+D13-C25","v":99048},{"$f":"+I13-C25","v":92857.5},null," "]

{"sheet":"be sit","index":4,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"+pdg!A7","v":0}]
[null,null,null,null,{"$f":"+pdg!A8","v":0}]
[null,null,null,null,{"$f":"+pdg!A9","v":0}]
[]
[]
[null,null,null,null,"Labège, le XX/XX/2018",null,null,null,"Lettre Recommandée / Accusé Reception"]
[]
[]
[]
[null,"Objet :",{"$f":"+pdg!A2","v":"nom de l'affaire"}]
[null,null,{"$f":"+pdg!A4","v":"lot + intitulé du lot"}]
[null,null,"Decompte de travaux n° x - mois 2018"]
[]
[]
[]
[null,"Madame, Monsieur,"]
[]
[]
[null,"Veuillez trouver ci-joint en 3 exemplaires : "]
[]
[null,"-",{"$f":"CONCATENATE(\"Notre  \",+C17,\".\")","v":"Notre  Decompte de travaux n° x - mois 2018."}]
[]
[]
[null,"Après vérification, nous vous remercions de transmettre notre demande de paiement au maître de l’ouvrage "]
[null,"afin que nous soyons payés dans le délai prévu par notre marché soit à ",null,30," jours date d’émission de la "]
[null,"facture. "]
[null,"afin que nous soyons payés dans le délai prévu par notre marché."]
[]
[null,"Merci de bien vouloir nous notifier l'état d’acompte dressé par vos soins sous 7 jours, comme le prévoit "]
[null,"l'article 13.2.2 du CCAG Travaux."]
[]
[null,"Nous vous en souhaitons bonne réception et vous prions d'agréer, Madame, Monsieur, nos salutations  "]
[null,"distinguées."]
[]
[]
[]
[null,null,null,null,"Le service administrative"]
[null,null,null,null,"Mme MOURET Muriel"]
[null,"Transmis par email :"]
[null,"MOE :"]
[null,"OPC :"]

{"sheet":"attest p direct","index":5,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,6,38,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ATTESTATION  DE  REGLEMENT DU SOUS – TRAITANT"]
[null,null,null,null,"PAIEMENT DIRECT"]
[]
[]
[]
[]
[]
[null,"MARCHE : ",{"$f":"+pdg!A2","v":"nom de l'affaire"}]
[]
[]
[]
[null,"Je soussigné, Monsieur MARFAING Didier, Gérant,"]
[null,"Agissant pour le compte de  la société  ",null,null,"AV.CO.BOIS"]
[null,null,null,null,"4252 Route de Baziège, 31670 LABEGE"]
[]
[]
[null,"AUTORISE, ",{"$f":"+pdg!A7","v":0}]
[]
[null,"à régler sur notre projet de décompte n° 1 du 20/08/2014 d’un montant de ",null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"TTC"]
[]
[null,"LA SOMME DE     ",null,{"$f":"+'suivi ss tt p direct'!E44","v":0},"H.T.  à notre Sous-traitant : Sté TALL FUSTA"]
[]
[]
[]
[]
[null,null,null,null,null,"Fait à Toulouse, le ","2014-08-20"]

{"sheet":"remise m propre","index":6,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Monsieur / Madame/ Mademoiselle ………..………… reconnait avoir reçu le .........………., "]
[]
[null,"de la société AV.CO.BOIS pour le chantier ",null,null,null,null,{"$f":"+pdg!A2","v":"nom de l'affaire"}]
[]
[null,"      - la situation de travaux du mois de Juillet 2014"]
[null,"      - la situation de travaux du mois d'aout 2014"]
[]
[]
[null,"remise en main propre contre cette présente décharge."]
[]
[]
[null,"Fait à TOULOUSE",null,null,null,null,"Signature ………………………..."]
[]
[null,"Le 04 aout 2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Monsieur / Madame/ Mademoiselle ………..………… reconnait avoir reçu le .........………., "]
[]
[null,{"$f":"+B8","v":"de la société AV.CO.BOIS pour le chantier "},null,null,null,null,{"$f":"+G8","v":"nom de l'affaire"}]
[]
[null,{"$f":"+B10","v":"      - la situation de travaux du mois de Juillet 2014"}]
[null,{"$f":"+B11","v":"      - la situation de travaux du mois d'aout 2014"}]
[]
[]
[null,"remise en main propre contre cette présente décharge."]
[]
[]
[null,"Fait à TOULOUSE",null,null,null,null,"Signature ………………………..."]
[]
[null,{"$f":"+B19","v":"Le 04 aout 2014"}]

{"sheet":"rev prix","index":7,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,4,19,5],[19,9,19,10],[26,12,26,14],[18,4,18,8],[18,9,18,13]]}
[]
[]
[null,null,null,{"$f":"+pdg!A2","v":"nom de l'affaire"}]
[]
[null,null,null,{"$f":"+pdg!A4","v":"lot + intitulé du lot"}]
[]
[]
[]
[null,null,"TABLEAU DE REVISION DE PRIX",null,null,null,null,null,null,"BT 01 : tous corps d'état"]
[]
[null,"lo : index du mois d'établissement des prix"]
[null,"ln : valeur de l'index du mois de réalisation des prestations"]
[null,"C : coefficient retenu pour les calculs, arrondu au millième supérieur"]
[null,"C=0,15+0,85 x (ln/lo)",null,null,"C=partiefixe+(1-partiefixe)*(ln/lo)"]
[]
[null,"Suivant article 4.1 de l'AR, valeur de lo arrété en juin 2015 :",null,null,null,null,104.6]
[null,"Les révisions s’appliquent dès que les index sont connus. Il ne pourra pas être réalisé de révision provisoire."]
[]
[null,null,null,null,"PROVISOIRE",null,null,null,null,"DEFINITIF"]
[null,"Date acompte","Num acompte","montant HT","ln provisoire\ndate            valeur",null,"valeur C prov H.T.","rév de prix prov H.T.","rév de prix prov T.T.C.","ln définitif\ndate          valeur",null,"valeur C définitif","rév de prix déf H.T.","rév de prix déf T.T.C.","rév de prix régul H.T.","rév de prix cumul H.T.","rév de prix cumul T.T.C.","c provi","C provi\narrondi au millième","c def","valeur C définitif\narrondi au millième"]
[null,null,"sit 1",null,null,null,{"$f":"+S21","v":0.15},{"$f":"D21*G21-D21-0.01","v":-0.01},{"$f":"+H21*1.2","v":-1.2E-2},null,null,{"$f":"+U21","v":0.15},{"$f":"+D21*L21-D21","v":0},{"$f":"+M21*1.2","v":0},null,{"$f":"+M21","v":0},{"$f":"+N21","v":0},{"$f":"0.15+0.85*(F21/$G$16)","v":0.15},{"$f":"MROUND(R21,0.001)","v":0.15},{"$f":"0.15+0.85*(K21/$G$16)","v":0.15},{"$f":"MROUND(T21,0.001)","v":0.15}]
[null,null,"sit 2",null,null,null,{"$f":"+S22","v":0.15},{"$f":"D22*G22-D22","v":0},{"$f":"+H22*1.2","v":0},null,null,null,null,{"$f":"+M22*1.2","v":0},null,{"$f":"+H22+P21","v":0},{"$f":"+P22*1.2","v":0},{"$f":"0.15+0.85*(F22/$G$16)","v":0.15},{"$f":"MROUND(R22,0.001)","v":0.15},{"$f":"0.15+0.85*(K22/$G$16)","v":0.15},{"$f":"MROUND(T22,0.001)","v":0.15}]
[null,null,"sit 3",null,null,null,{"$f":"+S23","v":0.15},{"$f":"D23*G23-D23","v":0},0,null,null,null,null,0,null,{"$f":"+H23+P22","v":0},{"$f":"+P23*1.2","v":0},0.15,0.15,0.15,0.15]
[null,null,"sit 4",null,null,null,{"$f":"+S24","v":0.15},{"$f":"D24*G24-D24","v":0},0,null,null,null,null,0,null,0,{"$f":"+P24*1.2","v":0},0.15,0.15,0.15,0.15]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Labège, le","2015-09-17"]

{"sheet":"avance forfaitaire","index":8,"n_rows":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[[66,1,66,4],[66,5,66,6],[1,1,1,8],[19,1,19,8],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[44,1,44,8],[62,1,62,8],[65,1,65,4],[65,5,65,6],[70,1,70,4],[70,5,70,6],[71,1,71,4],[71,5,71,6],[67,1,67,4],[67,5,67,6],[68,1,68,4],[68,5,68,6],[69,1,69,4],[69,5,69,6]]}
[]
[null,"FICHE DE PAIEMENT DE L'AVANCE FORFAITAIRE"]
[]
[]
[null,"Opération n° "]
[]
[null,"Lycée"]
[]
[]
[null,"Marché de travaux n°"]
[null,"pour :",null,{"$f":"+pdg!A7","v":0}]
[]
[]
[null,"Lot n°",{"$f":"+pdg!A4","v":"lot + intitulé du lot"}]
[]
[]
[null,"Nom de l'entreprise concernée :",null,null,"SARL AV.CO.BOIS"]
[]
[null,"FICHE JOINTE A L'ACOMPTE N°"]
[null,"DETERMINATION DU MONTANT DE L'AVANCE A PAYER"]
[]
[]
[null,null,null,null,null,"f/ Versement initial \n\nsur acompte n° …","g/ Réajustement suite à acceptation du sous-traitant : ………………………..."]
[null,"A/ DELAI GLOBAL D'EXECUTION DES TRAVAUX EN MOIS (si > 12 mois)",null,null,null,16]
[null,"B/ MONTANT DES PRESTATIONS A EXECUTER € TTC (montant initial du marché € TTC)",null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"C/ MONTANT DES PRESTATIONS A EXECUTER DANS LES DOUZE PREMIERS MOIS DE L'ANNE € TTC (si A > 12 mois, C = B x (12/A)",null,null,null,{"$f":"IF(F24>12,F25*(12/F24),F25)","v":{"$error":"#REF!"}}]
[null,"D/ MONTANT DE L'AVANCE A VERSER € TTC (C x 0,2)",null,null,null,{"$f":"+F26*0.2","v":{"$error":"#REF!"}}]
[null,"E/ MONTANT A REMBOURSER EN CAS DE SOUS-TRAITANCE (Df - Dg)  "]
[]
[]
[]
[null,null,null,null,null,"Fait à Labège,","le 28/03/2017"]
[]
[null,null,null,null,null,"Signature de l'entrepreneur"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CODE 2006 - Actyptrxtf SLP MIDI PYRENEES CONSTRUCTION.xlsx",null,null,null,null,"2010-03-16"]
[]
[null,"FICHE DE REMBOURSEMENT DE L'AVANCE FORFAITAIRE"]
[]
[]
[null,"Opération n° ",{"$f":"+C5","v":0}]
[]
[null,"Lycée"]
[]
[]
[null,"Marché de travaux n°",null,{"$f":"+D10","v":0}]
[null,"pour :",null,{"$f":"+D11","v":0}]
[]
[]
[null,"Lot n°",{"$f":"+C14","v":"lot + intitulé du lot"}]
[]
[]
[null,"Nom de l'entreprise concernée :",null,null,"SARL AV.CO.BOIS"]
[]
[null,"FICHE JOINTE A L'ACOMPTE N°",null,null,{"$f":"+E19","v":0}]
[null,"DETERMINATION DU MONTANT DE L'AVANCE A REMBOURSER"]
[]
[]
[null,"M/ MONTANT INITIAL DU MARCHE € TTC",null,null,null,{"$f":"+F25","v":{"$error":"#REF!"}}]
[null,"X/ MONTANT DES PRESTATIONS A REALISEES € TTC ",null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"a/ POURCENTAGE DE REALISATION DES TRAVAUX (X/M) x 100 (*)\n* si a < 40% il n'y a pas lieu au remboursement de l'AF\n* si a > 40 % il y a lieu au remboursement de l'AF",null,null,null,{"$f":"+F67/F66*100","v":{"$error":"#REF!"}}]
[null,"A/ MONTANT DE L'AVANCE FORFAITAIRE VERSEE € TTC",null,null,null,{"$f":"+F27","v":{"$error":"#REF!"}}]
[null,"R/ MONTANT TOTAL DE L'AVANCE FORFAITAIRE A REMBOURSER A x (a-40) / 40",null,null,null,{"$f":"+IF(F68<40,0,F69*(F68-40)/40)","v":{"$error":"#REF!"}}]
[null,"W/ REMBOURSEMENTS ANTERIEURS DÉJÀ EFFECTUES (Acomptes n° ……………………………)"]
[null,"Z/ REMBOURSEMENTS A EFFECTUER SUR PRESENT ACOMPTE (R - W)",null,null,null,{"$f":"+F70-F71","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,"Fait à Labège,","le 28/03/2017"]
[]
[null,null,null,null,null,"Signature de l'entrepreneur"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CODE 2006 - Actyptrxtf SLP MIDI PYRENEES CONSTRUCTION.xlsx",null,null,null,null,"2010-03-16"]

{"sheet":"sit 1 04 18","index":9,"n_rows":87,"n_cols":26,"rows_kept":87,"cut":false,"hidden":false,"merged":[[85,17,85,18],[23,2,23,3],[23,16,23,17],[25,2,25,3],[25,16,25,17],[26,2,26,3],[26,16,26,17],[80,17,80,18],[81,17,81,18],[82,17,82,18],[83,17,83,18],[84,17,84,18],[19,24,19,25],[20,1,20,8],[20,10,20,11],[20,15,20,22],[20,24,20,25],[22,2,22,3],[22,16,22,17],[9,1,11,3],[9,15,11,17],[12,1,14,3],[12,15,14,17],[19,1,19,8],[19,10,19,11],[19,15,19,22]]}
[null,null,null,null,"4252 route de Baziège 31670 LABEGE",null,null,null,null,null,null,null,null,null,null,null,null,null,"4252 route de Baziège 31670 LABEGE"]
[null,null,null,null,"Tél : 05 32 09 13 96 - Fax : 05 32 09 13 98 ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tél : 05 32 09 13 96 - Fax : 05 32 09 13 98 "]
[null,null,null,null,"Email : contact@avcobois.com",null,null,null,null,null,null,null,null,null,null,null,null,null,"Email : contact@avcobois.com"]
[null,null,null,null,"AVIVA n°76818699 - 32 rue du Fg Bonnefoy 31500 TOULOUSE",null,null,null,null,null,null,null,null,null,null,null,null,null,"AVIVA n°76818699 - 32 rue du Fg Bonnefoy 31500 TOULOUSE"]
[null,null,null,null,"Certificat QUALIBAT RGE n°116040",null,null,null,null,null,null,null,null,null,null,null,null,null,"Certificat QUALIBAT RGE n°116040"]
[]
[]
[]
[]
[null,"Décompte n° 1 a faire",null,null,null,null,null,null,{"$f":"+pdg!A8","v":0},null,null,null,null,null,null,"Décompte n° 1 à faire",null,null,null,null,null,null,{"$f":"I10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+pdg!A9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+pdg!A10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I12","v":0}]
[null,"Facture n° 2018 xxxxA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Facture n° 2018 xxxxB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I15","v":"A Labège, le"}]
[null,null,null,null,null,null,null,null,"A Labège, le"]
[]
[null,{"$f":"Devis!B10","v":"Devis n° 2018XXX"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nos ref :",{"$f":"L18","v":"Nos ref : 18 - xx"}]
[null,"Lieu d'exécution de l'intervention :",null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nos ref : \",pdg!D1)","v":"Nos ref : 18 - xx"},null,null,null,"Lieu d'exécution de l'intervention :",null,null,null,null,null,null,null,null,"N° DEVIS :",{"$f":"C16","v":"00:00:00"}]
[null,{"$f":"CONCATENATE(Devis!B17,\" - \",Devis!B18)","v":"XXX - XXX"},null,null,null,null,null,null,null,null,null,{"$f":"+B10","v":"Décompte n° 1 a faire"},null,null,null,"=B19",null,null,null,null,null,null,null,null,null,{"$f":"+P10","v":"Décompte n° 1 à faire"}]
[null,"Nom de l'affaire",null,null,null,null,null,null,null,"REPRÉSENTANT","CONDITIONS",null,null,null,null,"Nom de l'affaire",null,null,null,null,null,null,null,"REPRÉSENTANT","CONDITIONS"]
[null,{"$f":"+pdg!A2","v":"nom de l'affaire"},null,null,null,null,null,null,null,"M. MARFAING","60 jours date de facture",null,null,null,null,{"$f":"B21","v":"nom de l'affaire"},null,null,null,null,null,null,null,"M. MARFAING","60 jours date de facture"]
[]
[null,"Poste","DESCRIPTION",null,"Unit","Qté Bât","Qté villas","Qté totale","Prix unit","Prix total en €","%  Avct","Prix total en €",null,null,null,"Poste","DESCRIPTION",null,"Unit","Qté Bât","Qté villas","Qté totale","Prix unit","Prix total en €","%  Avct","Prix total en €"]
[null,null,"FOURNITURE ET POSE  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"FOURNITURE ET POSE  "]
[]
[null,null,{"$f":"+pdg!A4","v":"lot + intitulé du lot"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C26","v":"lot + intitulé du lot"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X28*Y28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X41*Y41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X42*Y42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z28:Z58)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X67*Y67","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z60:Z69)","v":0}]
[null,null,null,null,null,null,null,null,"Marché Total H.T.",{"$f":"J70+J59","v":0},{"$f":"+L71/J71","v":{"$error":"#DIV/0!"}},{"$f":"L70+L59","v":0},null,null,null,null,null,null,null,null,null,null,"Marché Total H.T.",{"$f":"X70+X59","v":0},{"$f":"+Z71/X71","v":{"$error":"#DIV/0!"}},{"$f":"Z70+Z59","v":0}]
[null,"Avancement :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Avancement :"]
[null,null,{"$f":"+L71/J71","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"TOTAL GENERAL H.T. :",null,null,{"$f":"+L71","v":0},null,null,null,null,{"$f":"+Z71/X71","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"TOTAL GENERAL H.T. :",null,null,{"$f":"+Z71","v":0}]
[null,null,null,null,null,null,null,null,"a laisser absolument même si 1ere facture : meme affichage du début a la fin"]
[null,null,null,null,null,null,null,null,"Déduction des acomptes précédents :",null,null,{"$f":"-D86","v":0},null,null,null,null,null,null,null,null,null,null,"Déduction des acomptes précédents :",null,null,{"$f":"-R86","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL FINAL H.T. :",null,null,{"$f":"L75+L73","v":0},null,null,null,null,null,null,null,null,null,null,"TOTAL FINAL H.T. :",null,null,{"$f":"Z75+Z73","v":0}]
[null,null,"a laisser absolument même si 1ere facture : tableau vide pas grave"]
[null,"Récapitulatif des acomptes précédents :",null,null,null,null,null,null,"T.V.A : ",0.2,null,{"$f":"L77*J79","v":0},null,null,null,"Récapitulatif des acomptes précédents :",null,null,null,null,null,null,"T.V.A : ",0.2,null,{"$f":"Z77*X79","v":0}]
[]
[null,null,"Date","HT",null,null,null,null,"TOTAL GENERAL A PAYER :",null,null,{"$f":"L77+L79","v":0},null,null,null,null,"Date","HT",null,null,null,null,"TOTAL GENERAL A PAYER :",null,null,{"$f":"Z77+Z79","v":0}]
[null,"Sit 1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sit 1"]
[null,"Sit 2",null,null,null,null,null,null,"Révision de prix",null,null,null,null,null,null,"Sit 2",null,null,null,null,null,null,"Révision de prix"]
[null,"Sit 3",null,null,null,null,null,null,"Compte prorata / CIE :",null,1.4999999999999999E-2,null,null,null,null,"Sit 3",null,null,null,null,null,null,"Compte prorata / CIE :",null,1.4999999999999999E-2]
[null,"Sit 4",null,null,null,null,null,null,"Retenue de Garantie :",null,0.05,{"$f":"-L81*K85","v":0},null,null,null,"Sit 4",null,null,null,null,null,null,"Retenue de Garantie :",null,0.05,{"$f":"-Z81*Y85","v":0}]
[null,null,"TOTAL",{"$f":"D85","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(R82:S85)","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL FINAL A PAYER :",null,null,{"$f":"L81+L85+L84+L83","v":0},null,null,null,null,null,null,null,null,null,null,"TOTAL FINAL A PAYER :",null,null,{"$f":"Z81+Z85+Z84+Z83","v":0}]