{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":[" 1. Calcul des dépenses sup.","2. calcul des coûtes imputables","Bases (ne pas modifier)"],"read":"whole","date_system":"1900"}

{"sheet":" 1. Calcul des dépenses sup.","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[1,1,1,2],[1,3,1,6],[2,0,3,0],[2,1,2,5],[2,6,3,6],[2,7,3,7]]}
["Canton","CS No.",null,"Commune"]
[]
["No.","Charge occasionnée par la mesure (art. 24 al. 2 annexe 3 OAS)",{"$nulls":4},"Points","Remarques"]
[null,"Déclivité du terrain (moyenne)","Sous-sol","Distance du metériel de construction","Remise en état / complément apporté à un drainage","Remise en état d'ouvrages d'art (ponts, murs, talus)"]
[{"$nulls":6},{"$f":"IF(ISBLANK(B5),\"\",VLOOKUP(B5,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C5,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D5,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E5,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F5,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C6,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D6,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E6,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F6,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B7),\"\",VLOOKUP(B7,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C7,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D7,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E7,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F7,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B8),\"\",VLOOKUP(B8,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C8,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D8,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E8,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F8,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B9),\"\",VLOOKUP(B9,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C9,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D9,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E9,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F9,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B10),\"\",VLOOKUP(B10,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C10,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D10,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E10,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F10,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B11),\"\",VLOOKUP(B11,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C11,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D11,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E11,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F11,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B12),\"\",VLOOKUP(B12,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C12,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D12,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E12,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F12,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B13),\"\",VLOOKUP(B13,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C13,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D13,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E13,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F13,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B14),\"\",VLOOKUP(B14,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C14,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D14,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E14,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F14,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B15),\"\",VLOOKUP(B15,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C15,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D15,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E15,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F15,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B16),\"\",VLOOKUP(B16,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C16,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D16,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E16,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F16,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B17),\"\",VLOOKUP(B17,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C17,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D17,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E17,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F17,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B18),\"\",VLOOKUP(B18,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C18,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D18,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E18,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F18,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B19),\"\",VLOOKUP(B19,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C19,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D19,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E19,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F19,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B20),\"\",VLOOKUP(B20,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C20,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D20,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E20,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F20,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B21),\"\",VLOOKUP(B21,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C21,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D21,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E21,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F21,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B22),\"\",VLOOKUP(B22,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C22,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D22,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E22,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F22,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B23),\"\",VLOOKUP(B23,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C23,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D23,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E23,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F23,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B24),\"\",VLOOKUP(B24,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C24,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D24,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E24,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F24,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B25),\"\",VLOOKUP(B25,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C25,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D25,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E25,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F25,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B26),\"\",VLOOKUP(B26,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C26,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D26,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E26,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F26,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B27),\"\",VLOOKUP(B27,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C27,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D27,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E27,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F27,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B28),\"\",VLOOKUP(B28,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C28,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D28,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E28,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F28,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B29),\"\",VLOOKUP(B29,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C29,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D29,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E29,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F29,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B30),\"\",VLOOKUP(B30,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C30,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D30,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E30,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F30,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]
[{"$nulls":6},{"$f":"IF(ISBLANK(B31),\"\",VLOOKUP(B31,'Bases (ne pas modifier)'!$A$6:$B$8,2,0)+VLOOKUP(C31,'Bases (ne pas modifier)'!$A$11:$B$13,2,0)+VLOOKUP(D31,'Bases (ne pas modifier)'!$A$15:$B$16,2,0)+VLOOKUP(E31,'Bases (ne pas modifier)'!$A$18:$B$19:'Bases (ne pas modifier)'!$B$20,2,0)+VLOOKUP(F31,'Bases (ne pas modifier)'!$A$18:$B$19,2,0))","v":""}]

{"sheet":"2. calcul des coûtes imputables","index":1,"n_rows":34,"n_cols":13,"rows_kept":34,"merged":[[1,2,1,5],[1,6,3,6],[1,7,1,9],[1,10,3,10],[1,11,3,11],[1,12,3,12],[2,0,4,0],[2,1,4,1],[2,2,3,3],[2,4,3,5],[32,0,33,0],[33,2,33,4],[33,7,33,9],[33,11,33,12]]}
["Canton","CS No.","Commune"]
[{"$f":"' 1. Calcul des dépenses sup.'!A2","v":0},{"$f":"' 1. Calcul des dépenses sup.'!B2","v":0},{"$f":"' 1. Calcul des dépenses sup.'!D2","v":0},{"$nulls":3},"Coûts max. imputables Total","Zone de contribution",null,null,"Contrôle de la longueur totale","Taux de contribution moyen","contribution maximum"]
["No.","Points","Calcul des coûts imputables pour les routes en gravier",null,"Calcul des coûts imputables pour les routes en dur",null,null,1,2,3]
[{"$nulls":7},{"v":0.27,"d":"27%"},{"v":0.3,"d":"30%"},{"v":0.33,"d":"33%"}]
[null,null,"m","Coûtes imp./m","m","Coûtes imp./m","Fr.","m","m","m","m","%","Fr."]
[{"$f":"' 1. Calcul des dépenses sup.'!A5","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G5=\"\",0,' 1. Calcul des dépenses sup.'!G5)","v":0},null,{"$f":"IF(ISBLANK(C6),0,(IF(B6>4,50,IF(B6>1,40,25))))","v":0},null,{"$f":"IF(ISBLANK(E6),0,(IF(B6>4,60,IF(B6>1,50,40))))","v":0},{"$f":"C6*D6+E6*F6","v":0},{"$nulls":3},{"$f":"IF(A6=0,\" \",IF(-C6-E6+H6+I6+J6=0,\"OK\",SUM(-C6-E6+H6+I6+J6)))","v":" "},{"$f":"IF(H6+I6+J6=0,\"\",(H6*$H$4+I6*$I$4+J6*$J$4)/(H6+I6+J6))","v":""},{"$f":"IF(G6=0,\"\",L6*G6)","v":""}]
[{"$f":"' 1. Calcul des dépenses sup.'!A6","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G6=\"\",0,' 1. Calcul des dépenses sup.'!G6)","v":0},null,{"$f":"IF(ISBLANK(C7),0,(IF(B7>4,50,IF(B7>1,40,25))))","v":0},null,{"$f":"IF(ISBLANK(E7),0,(IF(B7>4,60,IF(B7>1,50,40))))","v":0},{"$f":"C7*D7+E7*F7","v":0},{"$nulls":3}," ",{"$f":"IF(H7+I7+J7=0,\"\",(H7*$H$4+I7*$I$4+J7*$J$4)/(H7+I7+J7))","v":""},{"$f":"IF(G7=0,\"\",L7*G7)","v":""}]
[{"$f":"' 1. Calcul des dépenses sup.'!A7","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G7=\"\",0,' 1. Calcul des dépenses sup.'!G7)","v":0},null,0,null,0,0,{"$nulls":3}," ",{"$f":"IF(H8+I8+J8=0,\"\",(H8*$H$4+I8*$I$4+J8*$J$4)/(H8+I8+J8))","v":""},""]
[{"$f":"' 1. Calcul des dépenses sup.'!A8","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G8=\"\",0,' 1. Calcul des dépenses sup.'!G8)","v":0},null,0,null,0,0,{"$nulls":3}," ",{"$f":"IF(H9+I9+J9=0,\"\",(H9*$H$4+I9*$I$4+J9*$J$4)/(H9+I9+J9))","v":""},""]
[{"$f":"' 1. Calcul des dépenses sup.'!A9","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G9=\"\",0,' 1. Calcul des dépenses sup.'!G9)","v":0},null,0,null,0,0,{"$nulls":3}," ",{"$f":"IF(H10+I10+J10=0,\"\",(H10*$H$4+I10*$I$4+J10*$J$4)/(H10+I10+J10))","v":""},""]
[{"$f":"' 1. Calcul des dépenses sup.'!A10","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G10=\"\",0,' 1. Calcul des dépenses sup.'!G10)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A11","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G11=\"\",0,' 1. Calcul des dépenses sup.'!G11)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A12","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G12=\"\",0,' 1. Calcul des dépenses sup.'!G12)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A13","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G13=\"\",0,' 1. Calcul des dépenses sup.'!G13)","v":0},null,0,null,0,0,{"$nulls":3}," ",{"$f":"IF(H14+I14+J14=0,\"\",(H14*$H$4+I14*$I$4+J14*$J$4)/(H14+I14+J14))","v":""},""]
[{"$f":"' 1. Calcul des dépenses sup.'!A14","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G14=\"\",0,' 1. Calcul des dépenses sup.'!G14)","v":0},null,0,null,0,0,{"$nulls":3}," ",{"$f":"IF(H15+I15+J15=0,\"\",(H15*$H$4+I15*$I$4+J15*$J$4)/(H15+I15+J15))","v":""},""]
[{"$f":"' 1. Calcul des dépenses sup.'!A15","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G15=\"\",0,' 1. Calcul des dépenses sup.'!G15)","v":0},null,0,null,0,{"$f":"C16*D16+E16*F16","v":0},{"$nulls":3}," ",{"$f":"IF(H16+I16+J16=0,\"\",(H16*$H$4+I16*$I$4+J16*$J$4)/(H16+I16+J16))","v":""},""]
[{"$f":"' 1. Calcul des dépenses sup.'!A16","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G16=\"\",0,' 1. Calcul des dépenses sup.'!G16)","v":0},null,0,null,0,0,{"$nulls":3}," ",{"$f":"IF(H17+I17+J17=0,\"\",(H17*$H$4+I17*$I$4+J17*$J$4)/(H17+I17+J17))","v":""},""]
[{"$f":"' 1. Calcul des dépenses sup.'!A17","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G17=\"\",0,' 1. Calcul des dépenses sup.'!G17)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A18","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G18=\"\",0,' 1. Calcul des dépenses sup.'!G18)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A19","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G19=\"\",0,' 1. Calcul des dépenses sup.'!G19)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A20","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G20=\"\",0,' 1. Calcul des dépenses sup.'!G20)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A21","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G21=\"\",0,' 1. Calcul des dépenses sup.'!G21)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A22","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G22=\"\",0,' 1. Calcul des dépenses sup.'!G22)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A23","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G23=\"\",0,' 1. Calcul des dépenses sup.'!G23)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A24","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G24=\"\",0,' 1. Calcul des dépenses sup.'!G24)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A25","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G25=\"\",0,' 1. Calcul des dépenses sup.'!G25)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A26","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G26=\"\",0,' 1. Calcul des dépenses sup.'!G26)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A27","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G27=\"\",0,' 1. Calcul des dépenses sup.'!G27)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A28","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G28=\"\",0,' 1. Calcul des dépenses sup.'!G28)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A29","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G29=\"\",0,' 1. Calcul des dépenses sup.'!G29)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A30","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G30=\"\",0,' 1. Calcul des dépenses sup.'!G30)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
[{"$f":"' 1. Calcul des dépenses sup.'!A31","v":0},{"$f":"IF(' 1. Calcul des dépenses sup.'!G31=\"\",0,' 1. Calcul des dépenses sup.'!G31)","v":0},null,0,null,0,0,{"$nulls":3}," ","",""]
["Tot.",null,{"$f":"SUM(C6:C32)","v":0},null,{"$f":"SUM(E6:E32)","v":0},null,{"$f":"SUM(G6:G32)","v":0},{"$f":"SUM(H6:H32)","v":0},{"$f":"SUM(I6:I32)","v":0},{"$f":"SUM(J6:J32)","v":0},null,null,{"$f":"SUM(M6:M32)","v":0}]
[null,null,{"$f":"SUM(C33:E33)","v":0},{"$nulls":4},{"$f":"SUM(H33:J33)","v":0}]

{"sheet":"Bases (ne pas modifier)","index":2,"n_rows":26,"n_cols":4,"rows_kept":26}
["Grundlagen für Berechnung PWI gemäss Art. 24 Abs. 2 und Anhang 3 SVV"]
[]
[]
[]
[]
["<20%",0]
["20-40%",1]
[">40%",2]
[]
[]
["bon",0]
["humide",1]
["détrempé/instable",2]
[]
["< 10 km",0]
["≥ 10 km",1]
[]
["oui",1]
["non",0]
[null,"max 7"]
[]
[null,"gravelé","en dur","CHF/km"]
["Niveau 1","0-1","-",25000]
["Niveau 2","2-4","0-1",40000]
["Niveau 3","5-7","2-4",50000]
["Niveau 4","-","5-7",60000]