{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["formulaire vierge","code_textes","Code1","Dialog1","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"code_textes","index":1,"reason":"part_missing"},{"sheet":"Code1","index":2,"reason":"part_missing"},{"sheet":"Dialog1","index":3,"reason":"not_a_worksheet"}],"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":"formulaire vierge","index":0,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,9,48,19],[0,18,0,19],[46,11,46,12],[46,16,46,18],[46,14,46,15],[46,9,46,10]]}
["VERBAL DE BÂTIMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2016",null,"Acte N°:",null,0]
[]
["Décompte de l'honoraire TH33",null,null,"Commune:","___________________________",null,null,"Parc. n°:","_________","Plan N°:","_________","TVA:",null,null,"________",null,"Mut. N°:",null,null,0]
[null,null,null,null,null,null,null,"Parc. n°:","_________",null,"_________","Fi (indice):",null,null,"________"]
["Géomètre:",null,"_______________________","Bâtiment(s)/Adresse",null,"N°:","__________","Rue:","_______________________",null,null,"Bases de prix 1992"]
["Mandat lever du:",null,"_______________________",null,null,"N°:","__________","Rue:","_______________________",null,null,"Pente en %:",null,null,"________","    ZA     =",{"$f":"IF(V6<>1,V6,\"_______\")","v":"_______"},null,null,null,null,{"$f":"IF(O6>9999999,1,O6/100+1)","v":1},"Paramètre auxiliaire pour ZA"]
["Signé, le:",null,"_______________________","Propriétaire:",null,"_______________",null,null,"Cat mensuration:","________________",null,null,null,null,null,"    ZB/C   =","_______",null,"ZiT =",{"$f":"IF(V7<>1,V7,\"________\")","v":"_______"},null,{"$f":"IF(AND(Q6<1,Q7>9999999),1,IF(Q6<1,Q7,IF(Q7>99999991,Q6,IF(Q7=0,Q6,IF(Q6=\"_______\",Q7,Q6+Q7-1)))))","v":"_______"},"Paramètre auxiliaire pour ZiT"]
[]
[]
[null,null,null,null,null,"TERRAIN",null,null,null,null,null,"BUREAU",null,null,null,"Montant",null,null,"Montant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"de mise à jour",null,null,"de mise à jour"]
["Positions",null,null,"Élém.","Nbre",null,null,"MCA","MFA","MFN","NP","CN","MCA","MO93","Montant","du film original",null,null,""]
[null,null,null,null,"unité","Prix","Montant",null,null,"(SG)","num.part.","compl.num.","avec PFP",null,null,"(->dépositaire)",null,null,"",null," "]
["Mandat (par parcelle)",null,null,"MAN","","---",null,200,200,200,210,250,250,350,{"$f":"E$14:E$35 * H$14:H$35","v":{"$error":"#VALUE!"}},10,0,null,30,0,null,{"$f":"IF(OR(E14=\"\",E14=\"0\"),0,1)","v":0},"Paramètre auxiliaire pour mandat mise à jour"]
["PFP Recherche",null,null,"PF",0,20,{"$f":"E15*F15","v":0},null,null,null,null,null,null,"---",0,null,0,null,null,{"$f":"E$15:E$35 * S$15:S$35","v":0}]
["PFP Recherché par des moyens auxiliaires",null,null,"PF",0,40,0,null,null,null,null,null,null,"---",0,null,0,null,null,0]
["PFP Rétablissement à l'instrument",null,null,"PF",0,79,0,null,null,null,null,null,null,"---",0,null,0,null,null,0]
["PFP Rétablissement avec repères excentriques",null,null,"PF",0,63,0,null,null,null,null,null,null,"---",0,null,0,null,null,0]
["PFP nouveau, av. alt, y.c.stat.",null,null,"PF",0,143,0,null,120,"136.-(127.-)","120.-(111.-)",98,98,98,0,8,0,null,16,0]
["PFP nouv. (aux., non conserv.), y. c. station",null,null,"PF",0,80,0,null,60,60,51,51,51,51,0,null,0,null,null,0]
["PFP nouveau repérage (voir 3)",null,null,"PF",{"$f":"IF(G46>0,1,0)","v":0},{"$f":"G46","v":0},0,null,null,null,null,null,null,"---",0,null,0,null,null,0]
["PFP supprimé",null,null,"PF",0,null," ",null,15,"28.-(24.-)","30.-(26.-)",26,22,26,0,4,0,null,9,0]
["Mise en station",null,null,"ST",0,60,{"$f":"E23*F23","v":0},null,null,null,null,null,null,"---",0,null,0,null,null,0]
["Abriss, ou rattachements GPS (sauf PFP nouv.)",null,null,"PF",0,null,null,null,null,27,18,18,18,18,0,null,0,null,null,0]
["PL Recherché",null,null,"PL",0,12,{"$f":"E25*F25","v":0},null,null,null,null,null,null,"---",0,null,0,null,null,0]
["PL Recherché par des moyens auxiliaires",null,null,"PL",0,24,{"$f":"E26*F26","v":0},null,null,null,null,null,null,"---",0,null,0,null,null,0]
["Pt sit + bat levé / adresses (circ 2012/5)",null,null,"PS",0,7,{"$f":"E27*F27","v":0},11,12,"15.-(13.-)","17.-(15.-)",12,15,12,0,2,0,null,4,0]
["Ajustage",null,null,"PLAN",0,null," ",20,null,null,null,null,20,"---",0,null,0,null,null,0]
["Pt situation + bâtiment supprimé",null,null,"PS/ligne",0,null," ",4,4,"13.-(10.-)","13.-(10.-)",7,4,12,0,3,0,null,6,0]
["Calcul surf. nature",null,null,"SURF",0,null," ",17,17,44,44,42,17,"---",0,null,0,null,null,0]
["Définition des CS sur éléments existants",null,null,"PT",0,null,null,null,null,null,null,6,null,null,0,null,0,null,null,0]
["Servitude / mention",null,null,"S/M",0,null,null,8,8,8,8,8,8,null,0,null,0,null,null,0]
["Articles réunis ou supplémentaires",null,null,"Art",0,null," ",36,36,36,36,36,36,8,0,null,0,null,null,0]
["Forfait pour signature (art réunis)",null,null,"Sign",0,null," ",70,70,70,70,70,70,36,0,null,0,null,null,0]
["Déplacement (exceptionnel)",null,null,"Km",0,null,null,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,70,0,null,0,null,null,0]
[null,null,null,null,"Total terrain:",null,{"$f":"SUM(G14:G35)","v":0},null,null,null,null,"Total bureau:",null,null,{"$f":"SUM(O14:O35)","v":{"$error":"#VALUE!"}},"Brut:",{"$f":"SUM(Q14:Q35)","v":0},null,"Brut:",{"$f":"SUM(T14:T35)","v":0}]
[null,null,null,null,0,"  x Zi",{"$f":"IF(V7<>1,IF(V7=\"_______\",G36,ROUND(2*G36*ZiT,1)/2))","v":0},null,null,null,null,"Total terrain:",null,null,{"$f":"G37","v":0},"Réduit",{"$f":"IF(OR(AND(Q27=0,Q29=0),Fi=\"________\"),0,IF(Q36>((Fi/1.1)*(300/1.1)),ROUND(2*((Q36-300/1.1*(Fi/1.1))/2+300/1.1*(Fi/1.1)),1)/2,0))","v":0},null,"Réduit",{"$f":"IF(OR(AND(T27=0,T29=0),Fi=\"________\"),0,IF(T36>((Fi/1.1)*(300/1.1)),ROUND(2*((T36-300/1.1*(Fi/1.1))/2+300/1.1*(Fi/1.1)),1)/2,0))","v":0}]
[null,null,null,null,"Total terrain:",null,null,null,null,null,null,"Total",null,null,{"$f":"ROUND(2*(O36+O37),1)/2","v":{"$error":"#VALUE!"}}]
[3,"TRAVAUX MATERIALISATION",null,"Élém.","Prix","Prix","Montant",null,null,null,null,"Total x Fi",null,null,{"$f":"IF(Fi=\"________\",0,ROUND(2*(Fi*O38),1)/2)","v":0},"x Fi",{"$f":"IF(Fi=\"________\",0,IF(OR(Q36<Q37,Q37=0),ROUND(2*Fi*Q36,1)/2,ROUND(2*Fi*Q37,1)/2))","v":0},null,"x Fi",{"$f":"IF(Fi=\"________\",0,IF(OR(T36<T37,T37=0),ROUND(2*Fi*T36,1)/2,ROUND(2*Fi*T37,1)/2))","v":0}]
[3.1,"Types standards",null,null,"unité",null,null,null,null,null,null,null,null,null,0,"TVA:",{"$f":"IF(TVA=\"________\",0,ROUND(2*TVA*Q39,1)/2)","v":0},null,"TVA:",{"$f":"IF(TVA=\"________\",0,ROUND(2*TVA*T39,1)/2)","v":0}]
[".11","Pose nouvelle borne",null,"PCE",0,84,{"$f":"E41*F41","v":0},null,null,null,null,"Total matériel",null,null,{"$f":"G50","v":0},"Total:  ",{"$f":"IF(OR(TVA=\"________\",TVA=\"\",TVA=0),0,ROUND(2*(1+TVA)*Q39,1)/2)","v":0},null,"Total:  ",{"$f":"IF(OR(TVA=\"________\",TVA=\"\",TVA=0),0,ROUND(2*(1+TVA)*T39,1)/2)","v":0}]
[".12","Redressement + calage borne",null,"PCE",0,40,{"$f":"E42*F42","v":0},null,null,null,null,"Total du mandat",null,null,{"$f":"SUM(O39:O41)","v":0}]
[".15","Percement trou + peint. s/borne",null,"PCE",0,12,{"$f":"E43*F43","v":0},null,null,null,null,"TVA:",null,null,{"$f":"IF(TVA=\"________\",0,ROUND(2*(TVA*(O39+O40+O41)),1)/2)","v":0}]
[".16","Pose cheville avec tampon",null,"PCE",0,19,{"$f":"E44*F44","v":0},null,null,null,null,"TOTAL AVEC TVA",null,null,{"$f":"IF(OR(TVA=\"________\",TVA=\"\",TVA=0),0,O43+O42)","v":0}]
[".17","Scellement cheville avec ciment",null,"PCE",0,32,{"$f":"E45*F45","v":0}]
[null,null,null,null,0,"Total",{"$f":"SUM(G41:G45)","v":0}]
[3.3,"Matériel",null,null,0,null,null,null,null,"Vérifié et validé le:",null,"##.##.####",null,null,"par:",null,"$User"]
[3.1,"PFP3 - borne ronde D=14 cm",null,"PCE",0,28,{"$f":"E48*F48","v":0}]
[3.2,"Cheville D=4 cm",null,"PCE",0,5,{"$f":"E49*F49","v":0},null,null,"Visa du Service du cadastre et de la géomatique"]
[null,null,null,null,0,"Total",{"$f":"SUM(G47:G49)","v":0}]
[null,null,null,null,0,null,null,null," "]

{"sheet":"Feuil1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}