{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BD","renouvel életro details"],"not_rendered":{"macros":1,"external_links":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"BD","index":0,"n_rows":134,"n_cols":23,"rows_kept":134}
["Renouvellement élecro. PROGRAMME",{"$nulls":3},"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre",null,"mois en cours",null,"Valeur 2014",null,"Objectif","manque"]
[null,"S Ville 1",{"$nulls":17},{"$f":"SUM(E2:P2)","v":0},null,40]
[null,null,"Mensuel",null,0,0,1,0,1,2,0,0,0,{"$nulls":4},{"$f":"12-COUNTBLANK(E3:P3)","v":9},null,{"$f":"SUM(E3:P3)","v":4},null,{"$f":"IF(OR(V2=\"\",V2=0),\"\",IF(T3>V2,1,T3/V2))","v":{"v":0.1,"d":"10%"}},{"$f":"IF(V3=\"\",\"\",1-V3)","v":{"v":0.9,"d":"90%"}}]
[null,null,"Cumul",null,{"$f":"IF(E3=\"\",\"\",D4+E3)","v":0},0,1,1,2,4,4,4,4,"","",""]
[null,"S Ville 2",{"$nulls":17},{"$f":"SUM(E5:P5)","v":0},null,50]
[null,null,"Mensuel",null,0,1,0,0,1,1,13,0,1,0,8,8,null,{"$f":"12-COUNTBLANK(E6:P6)","v":12},null,{"$f":"SUM(E6:P6)","v":33},null,{"$f":"IF(OR(V5=\"\",V5=0),\"\",IF(T6>V5,1,T6/V5))","v":{"v":0.66,"d":"66%"}},{"$f":"IF(V6=\"\",\"\",1-V6)","v":{"v":0.33999999999999997,"d":"34%"}}]
[null,null,"Cumul",null,{"$f":"IF(E6=\"\",\"\",D7+E6)","v":0},1,1,1,2,3,16,16,17,17,25,33]
[null,"S Ville 3",{"$nulls":17},{"$f":"SUM(E8:P8)","v":0}]
[null,null,"Mensuel",null,1,0,0,0,2,0,1,0,4,8,1,null,null,{"$f":"12-COUNTBLANK(E9:P9)","v":11},null,{"$f":"SUM(E9:P9)","v":17},null,{"$f":"IF(OR(V8=\"\",V8=0),\"\",IF(T9>V8,1,T9/V8))","v":""},{"$f":"IF(V9=\"\",\"\",1-V9)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E9=\"\",\"\",D10+E9)","v":1},1,1,1,3,3,4,4,8,16,17,""]
[null,"S Ville 4",{"$nulls":17},{"$f":"SUM(E11:P11)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E12:P12)","v":0},null,{"$f":"SUM(E12:P12)","v":0},null,{"$f":"IF(OR(V11=\"\",V11=0),\"\",IF(T12>V11,1,T12/V11))","v":""},{"$f":"IF(V12=\"\",\"\",1-V12)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E12=\"\",\"\",D13+E12)","v":""},"",{"$f":"IF(G12=\"\",\"\",F13+G12)","v":""},{"$f":"IF(H12=\"\",\"\",G13+H12)","v":""},"","","","","","","",""]
[null,"S Ville 5",{"$nulls":17},{"$f":"SUM(E14:P14)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E15:P15)","v":0},null,{"$f":"SUM(E15:P15)","v":0},null,{"$f":"IF(OR(V14=\"\",V14=0),\"\",IF(T15>V14,1,T15/V14))","v":""},{"$f":"IF(V15=\"\",\"\",1-V15)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E15=\"\",\"\",D16+E15)","v":""},"","","","","","","","","","",""]
[null,"S Ville 6",{"$nulls":17},{"$f":"SUM(E17:P17)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E18:P18)","v":0},null,{"$f":"SUM(E18:P18)","v":0},null,{"$f":"IF(OR(V17=\"\",V17=0),\"\",IF(T18>V17,1,T18/V17))","v":""},{"$f":"IF(V18=\"\",\"\",1-V18)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E18=\"\",\"\",D19+E18)","v":""},"","","","","","","","","","",""]
[null,"S Ville 7",{"$nulls":17},{"$f":"SUM(E20:P20)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E21:P21)","v":0},null,{"$f":"SUM(E21:P21)","v":0},null,{"$f":"IF(OR(V20=\"\",V20=0),\"\",IF(T21>V20,1,T21/V20))","v":""},{"$f":"IF(V21=\"\",\"\",1-V21)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E21=\"\",\"\",D22+E21)","v":""},"","","","","","","","","","",""]
[null,"S Ville 8",{"$nulls":17},{"$f":"SUM(E23:P23)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E24:P24)","v":0},null,{"$f":"SUM(E24:P24)","v":0},null,{"$f":"IF(OR(V23=\"\",V23=0),\"\",IF(T24>V23,1,T24/V23))","v":""},{"$f":"IF(V24=\"\",\"\",1-V24)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E24=\"\",\"\",D25+E24)","v":""},"","","","","","","","","","",""]
[null,"S Ville 9",{"$nulls":17},{"$f":"SUM(E26:P26)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E27:P27)","v":0},null,{"$f":"SUM(E27:P27)","v":0},null,{"$f":"IF(OR(V26=\"\",V26=0),\"\",IF(T27>V26,1,T27/V26))","v":""},{"$f":"IF(V27=\"\",\"\",1-V27)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E27=\"\",\"\",D28+E27)","v":""},"","","","","","","","","","",""]
[null,"S Ville 10",{"$nulls":17},{"$f":"SUM(E29:P29)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E30:P30)","v":0},null,{"$f":"SUM(E30:P30)","v":0},null,{"$f":"IF(OR(V29=\"\",V29=0),\"\",IF(T30>V29,1,T30/V29))","v":""},{"$f":"IF(V30=\"\",\"\",1-V30)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E30=\"\",\"\",D31+E30)","v":""},"","","","","","","","","","",""]
[null,"S Ville 11",{"$nulls":17},{"$f":"SUM(E32:P32)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E33:P33)","v":0},null,{"$f":"SUM(E33:P33)","v":0},null,{"$f":"IF(OR(V32=\"\",V32=0),\"\",IF(T33>V32,1,T33/V32))","v":""},{"$f":"IF(V33=\"\",\"\",1-V33)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E33=\"\",\"\",D34+E33)","v":""},"","","","","","","","","","",""]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E35:P35)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E36:P36)","v":0},null,{"$f":"SUM(E36:P36)","v":0},null,{"$f":"IF(OR(V35=\"\",V35=0),\"\",IF(T36>V35,1,T36/V35))","v":""},{"$f":"IF(V36=\"\",\"\",1-V36)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E36=\"\",\"\",D37+E36)","v":""},"","","","","","","","","","",""]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E38:P38)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E39:P39)","v":0},null,{"$f":"SUM(E39:P39)","v":0},null,{"$f":"IF(OR(V38=\"\",V38=0),\"\",IF(T39>V38,1,T39/V38))","v":""},{"$f":"IF(V39=\"\",\"\",1-V39)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E39=\"\",\"\",D40+E39)","v":""},"","","","","","","","","","",""]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E41:P41)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E42:P42)","v":0},null,{"$f":"SUM(E42:P42)","v":0},null,{"$f":"IF(OR(V41=\"\",V41=0),\"\",IF(T42>V41,1,T42/V41))","v":""},{"$f":"IF(V42=\"\",\"\",1-V42)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E42=\"\",\"\",D43+E42)","v":""},"","","","","","","","","","",""]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E44:P44)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E45:P45)","v":0},null,{"$f":"SUM(E45:P45)","v":0},null,{"$f":"IF(OR(V44=\"\",V44=0),\"\",IF(T45>V44,1,T45/V44))","v":""},{"$f":"IF(V45=\"\",\"\",1-V45)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E45=\"\",\"\",D46+E45)","v":""},"","","","","","","","","","",""]
[null,"S Ville 16",{"$nulls":17},{"$f":"SUM(E47:P47)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E48:P48)","v":0},null,{"$f":"SUM(E48:P48)","v":0},null,{"$f":"IF(OR(V47=\"\",V47=0),\"\",IF(T48>V47,1,T48/V47))","v":""},{"$f":"IF(V48=\"\",\"\",1-V48)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E48=\"\",\"\",D49+E48)","v":""},"","","","","","","","","","",""]
[null,"S Ville 17",{"$nulls":17},{"$f":"SUM(E50:P50)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E51:P51)","v":0},null,{"$f":"SUM(E51:P51)","v":0},null,{"$f":"IF(OR(V50=\"\",V50=0),\"\",IF(T51>V50,1,T51/V50))","v":""},{"$f":"IF(V51=\"\",\"\",1-V51)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E51=\"\",\"\",D52+E51)","v":""},"","","","","","","","","","",""]
[null,"S Ville 18",{"$nulls":17},{"$f":"SUM(E53:P53)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E54:P54)","v":0},null,{"$f":"SUM(E54:P54)","v":0},null,{"$f":"IF(OR(V53=\"\",V53=0),\"\",IF(T54>V53,1,T54/V53))","v":""},{"$f":"IF(V54=\"\",\"\",1-V54)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E54=\"\",\"\",D55+E54)","v":""},"","","","","","","","","","",""]
[null,"S Ville 19",{"$nulls":17},{"$f":"SUM(E56:P56)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E57:P57)","v":0},null,{"$f":"SUM(E57:P57)","v":0},null,{"$f":"IF(OR(V56=\"\",V56=0),\"\",IF(T57>V56,1,T57/V56))","v":""},{"$f":"IF(V57=\"\",\"\",1-V57)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E57=\"\",\"\",D58+E57)","v":""},"","","","","","","","","","",""]
[null,"S Ville 20",{"$nulls":17},{"$f":"SUM(E59:P59)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E60:P60)","v":0},null,{"$f":"SUM(E60:P60)","v":0},null,{"$f":"IF(OR(V59=\"\",V59=0),\"\",IF(T60>V59,1,T60/V59))","v":""},{"$f":"IF(V60=\"\",\"\",1-V60)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E60=\"\",\"\",D61+E60)","v":""},"","","","","","","","","","",""]
[null,"S Ville 21",{"$nulls":17},{"$f":"SUM(E62:P62)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E63:P63)","v":0},null,{"$f":"SUM(E63:P63)","v":0},null,{"$f":"IF(OR(V62=\"\",V62=0),\"\",IF(T63>V62,1,T63/V62))","v":""},{"$f":"IF(V63=\"\",\"\",1-V63)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E63=\"\",\"\",D64+E63)","v":""},"","","","","","","","","","",""]
[null,"S Ville 22",{"$nulls":17},{"$f":"SUM(E65:P65)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E66:P66)","v":0},null,{"$f":"SUM(E66:P66)","v":0},null,{"$f":"IF(OR(V65=\"\",V65=0),\"\",IF(T66>V65,1,T66/V65))","v":""},{"$f":"IF(V66=\"\",\"\",1-V66)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E66=\"\",\"\",D67+E66)","v":""},"","","","","","","","","","",""]
["Renouvellement pompe",{"$nulls":3},"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre",null,"mois en cours",null,"Valeur 2014",null,"Objectif","manque"]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E69:P69)","v":0},null,40]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E70:P70)","v":0},null,{"$f":"SUM(E70:P70)","v":0},null,{"$f":"IF(OR(V69=\"\",V69=0),\"\",IF(T70>V69,1,T70/V69))","v":{"v":0,"d":"0%"}},{"$f":"IF(V70=\"\",\"\",1-V70)","v":{"v":1,"d":"100%"}}]
[null,null,"Cumul",null,{"$f":"IF(E70=\"\",\"\",D71+E70)","v":""},{"$f":"IF(F70=\"\",\"\",E71+F70)","v":""},{"$f":"IF(G70=\"\",\"\",F71+G70)","v":""},{"$f":"IF(H70=\"\",\"\",G71+H70)","v":""},{"$f":"IF(I70=\"\",\"\",H71+I70)","v":""},{"$f":"IF(J70=\"\",\"\",I71+J70)","v":""},{"$f":"IF(K70=\"\",\"\",J71+K70)","v":""},{"$f":"IF(L70=\"\",\"\",K71+L70)","v":""},{"$f":"IF(M70=\"\",\"\",L71+M70)","v":""},{"$f":"IF(N70=\"\",\"\",M71+N70)","v":""},{"$f":"IF(O70=\"\",\"\",N71+O70)","v":""},{"$f":"IF(P70=\"\",\"\",O71+P70)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E72:P72)","v":0},null,50]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E73:P73)","v":0},null,{"$f":"SUM(E73:P73)","v":0},null,{"$f":"IF(OR(V72=\"\",V72=0),\"\",IF(T73>V72,1,T73/V72))","v":{"v":0,"d":"0%"}},{"$f":"IF(V73=\"\",\"\",1-V73)","v":{"v":1,"d":"100%"}}]
[null,null,"Cumul",null,{"$f":"IF(E73=\"\",\"\",D74+E73)","v":""},{"$f":"IF(F73=\"\",\"\",E74+F73)","v":""},{"$f":"IF(G73=\"\",\"\",F74+G73)","v":""},{"$f":"IF(H73=\"\",\"\",G74+H73)","v":""},{"$f":"IF(I73=\"\",\"\",H74+I73)","v":""},{"$f":"IF(J73=\"\",\"\",I74+J73)","v":""},{"$f":"IF(K73=\"\",\"\",J74+K73)","v":""},{"$f":"IF(L73=\"\",\"\",K74+L73)","v":""},{"$f":"IF(M73=\"\",\"\",L74+M73)","v":""},{"$f":"IF(N73=\"\",\"\",M74+N73)","v":""},{"$f":"IF(O73=\"\",\"\",N74+O73)","v":""},{"$f":"IF(P73=\"\",\"\",O74+P73)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E75:P75)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E76:P76)","v":0},null,{"$f":"SUM(E76:P76)","v":0},null,{"$f":"IF(OR(V75=\"\",V75=0),\"\",IF(T76>V75,1,T76/V75))","v":""},{"$f":"IF(V76=\"\",\"\",1-V76)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E76=\"\",\"\",D77+E76)","v":""},{"$f":"IF(F76=\"\",\"\",E77+F76)","v":""},{"$f":"IF(G76=\"\",\"\",F77+G76)","v":""},{"$f":"IF(H76=\"\",\"\",G77+H76)","v":""},{"$f":"IF(I76=\"\",\"\",H77+I76)","v":""},{"$f":"IF(J76=\"\",\"\",I77+J76)","v":""},{"$f":"IF(K76=\"\",\"\",J77+K76)","v":""},{"$f":"IF(L76=\"\",\"\",K77+L76)","v":""},{"$f":"IF(M76=\"\",\"\",L77+M76)","v":""},{"$f":"IF(N76=\"\",\"\",M77+N76)","v":""},{"$f":"IF(O76=\"\",\"\",N77+O76)","v":""},{"$f":"IF(P76=\"\",\"\",O77+P76)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E78:P78)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E79:P79)","v":0},null,{"$f":"SUM(E79:P79)","v":0},null,{"$f":"IF(OR(V78=\"\",V78=0),\"\",IF(T79>V78,1,T79/V78))","v":""},{"$f":"IF(V79=\"\",\"\",1-V79)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E79=\"\",\"\",D80+E79)","v":""},{"$f":"IF(F79=\"\",\"\",E80+F79)","v":""},{"$f":"IF(G79=\"\",\"\",F80+G79)","v":""},{"$f":"IF(H79=\"\",\"\",G80+H79)","v":""},{"$f":"IF(I79=\"\",\"\",H80+I79)","v":""},{"$f":"IF(J79=\"\",\"\",I80+J79)","v":""},{"$f":"IF(K79=\"\",\"\",J80+K79)","v":""},{"$f":"IF(L79=\"\",\"\",K80+L79)","v":""},{"$f":"IF(M79=\"\",\"\",L80+M79)","v":""},{"$f":"IF(N79=\"\",\"\",M80+N79)","v":""},{"$f":"IF(O79=\"\",\"\",N80+O79)","v":""},{"$f":"IF(P79=\"\",\"\",O80+P79)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E81:P81)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E82:P82)","v":0},null,{"$f":"SUM(E82:P82)","v":0},null,{"$f":"IF(OR(V81=\"\",V81=0),\"\",IF(T82>V81,1,T82/V81))","v":""},{"$f":"IF(V82=\"\",\"\",1-V82)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E82=\"\",\"\",D83+E82)","v":""},{"$f":"IF(F82=\"\",\"\",E83+F82)","v":""},{"$f":"IF(G82=\"\",\"\",F83+G82)","v":""},{"$f":"IF(H82=\"\",\"\",G83+H82)","v":""},{"$f":"IF(I82=\"\",\"\",H83+I82)","v":""},{"$f":"IF(J82=\"\",\"\",I83+J82)","v":""},{"$f":"IF(K82=\"\",\"\",J83+K82)","v":""},{"$f":"IF(L82=\"\",\"\",K83+L82)","v":""},{"$f":"IF(M82=\"\",\"\",L83+M82)","v":""},{"$f":"IF(N82=\"\",\"\",M83+N82)","v":""},{"$f":"IF(O82=\"\",\"\",N83+O82)","v":""},{"$f":"IF(P82=\"\",\"\",O83+P82)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E84:P84)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E85:P85)","v":0},null,{"$f":"SUM(E85:P85)","v":0},null,{"$f":"IF(OR(V84=\"\",V84=0),\"\",IF(T85>V84,1,T85/V84))","v":""},{"$f":"IF(V85=\"\",\"\",1-V85)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E85=\"\",\"\",D86+E85)","v":""},{"$f":"IF(F85=\"\",\"\",E86+F85)","v":""},{"$f":"IF(G85=\"\",\"\",F86+G85)","v":""},{"$f":"IF(H85=\"\",\"\",G86+H85)","v":""},{"$f":"IF(I85=\"\",\"\",H86+I85)","v":""},{"$f":"IF(J85=\"\",\"\",I86+J85)","v":""},{"$f":"IF(K85=\"\",\"\",J86+K85)","v":""},{"$f":"IF(L85=\"\",\"\",K86+L85)","v":""},{"$f":"IF(M85=\"\",\"\",L86+M85)","v":""},{"$f":"IF(N85=\"\",\"\",M86+N85)","v":""},{"$f":"IF(O85=\"\",\"\",N86+O85)","v":""},{"$f":"IF(P85=\"\",\"\",O86+P85)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E87:P87)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E88:P88)","v":0},null,{"$f":"SUM(E88:P88)","v":0},null,{"$f":"IF(OR(V87=\"\",V87=0),\"\",IF(T88>V87,1,T88/V87))","v":""},{"$f":"IF(V88=\"\",\"\",1-V88)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E88=\"\",\"\",D89+E88)","v":""},{"$f":"IF(F88=\"\",\"\",E89+F88)","v":""},{"$f":"IF(G88=\"\",\"\",F89+G88)","v":""},{"$f":"IF(H88=\"\",\"\",G89+H88)","v":""},{"$f":"IF(I88=\"\",\"\",H89+I88)","v":""},{"$f":"IF(J88=\"\",\"\",I89+J88)","v":""},{"$f":"IF(K88=\"\",\"\",J89+K88)","v":""},{"$f":"IF(L88=\"\",\"\",K89+L88)","v":""},{"$f":"IF(M88=\"\",\"\",L89+M88)","v":""},{"$f":"IF(N88=\"\",\"\",M89+N88)","v":""},{"$f":"IF(O88=\"\",\"\",N89+O88)","v":""},{"$f":"IF(P88=\"\",\"\",O89+P88)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E90:P90)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E91:P91)","v":0},null,{"$f":"SUM(E91:P91)","v":0},null,{"$f":"IF(OR(V90=\"\",V90=0),\"\",IF(T91>V90,1,T91/V90))","v":""},{"$f":"IF(V91=\"\",\"\",1-V91)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E91=\"\",\"\",D92+E91)","v":""},{"$f":"IF(F91=\"\",\"\",E92+F91)","v":""},{"$f":"IF(G91=\"\",\"\",F92+G91)","v":""},{"$f":"IF(H91=\"\",\"\",G92+H91)","v":""},{"$f":"IF(I91=\"\",\"\",H92+I91)","v":""},{"$f":"IF(J91=\"\",\"\",I92+J91)","v":""},{"$f":"IF(K91=\"\",\"\",J92+K91)","v":""},{"$f":"IF(L91=\"\",\"\",K92+L91)","v":""},{"$f":"IF(M91=\"\",\"\",L92+M91)","v":""},{"$f":"IF(N91=\"\",\"\",M92+N91)","v":""},{"$f":"IF(O91=\"\",\"\",N92+O91)","v":""},{"$f":"IF(P91=\"\",\"\",O92+P91)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E93:P93)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E94:P94)","v":0},null,{"$f":"SUM(E94:P94)","v":0},null,{"$f":"IF(OR(V93=\"\",V93=0),\"\",IF(T94>V93,1,T94/V93))","v":""},{"$f":"IF(V94=\"\",\"\",1-V94)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E94=\"\",\"\",D95+E94)","v":""},{"$f":"IF(F94=\"\",\"\",E95+F94)","v":""},{"$f":"IF(G94=\"\",\"\",F95+G94)","v":""},{"$f":"IF(H94=\"\",\"\",G95+H94)","v":""},{"$f":"IF(I94=\"\",\"\",H95+I94)","v":""},{"$f":"IF(J94=\"\",\"\",I95+J94)","v":""},{"$f":"IF(K94=\"\",\"\",J95+K94)","v":""},{"$f":"IF(L94=\"\",\"\",K95+L94)","v":""},{"$f":"IF(M94=\"\",\"\",L95+M94)","v":""},{"$f":"IF(N94=\"\",\"\",M95+N94)","v":""},{"$f":"IF(O94=\"\",\"\",N95+O94)","v":""},{"$f":"IF(P94=\"\",\"\",O95+P94)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E96:P96)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E97:P97)","v":0},null,{"$f":"SUM(E97:P97)","v":0},null,{"$f":"IF(OR(V96=\"\",V96=0),\"\",IF(T97>V96,1,T97/V96))","v":""},{"$f":"IF(V97=\"\",\"\",1-V97)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E97=\"\",\"\",D98+E97)","v":""},{"$f":"IF(F97=\"\",\"\",E98+F97)","v":""},{"$f":"IF(G97=\"\",\"\",F98+G97)","v":""},{"$f":"IF(H97=\"\",\"\",G98+H97)","v":""},{"$f":"IF(I97=\"\",\"\",H98+I97)","v":""},{"$f":"IF(J97=\"\",\"\",I98+J97)","v":""},{"$f":"IF(K97=\"\",\"\",J98+K97)","v":""},{"$f":"IF(L97=\"\",\"\",K98+L97)","v":""},{"$f":"IF(M97=\"\",\"\",L98+M97)","v":""},{"$f":"IF(N97=\"\",\"\",M98+N97)","v":""},{"$f":"IF(O97=\"\",\"\",N98+O97)","v":""},{"$f":"IF(P97=\"\",\"\",O98+P97)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E99:P99)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E100:P100)","v":0},null,{"$f":"SUM(E100:P100)","v":0},null,{"$f":"IF(OR(V99=\"\",V99=0),\"\",IF(T100>V99,1,T100/V99))","v":""},{"$f":"IF(V100=\"\",\"\",1-V100)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E100=\"\",\"\",D101+E100)","v":""},{"$f":"IF(F100=\"\",\"\",E101+F100)","v":""},{"$f":"IF(G100=\"\",\"\",F101+G100)","v":""},{"$f":"IF(H100=\"\",\"\",G101+H100)","v":""},{"$f":"IF(I100=\"\",\"\",H101+I100)","v":""},{"$f":"IF(J100=\"\",\"\",I101+J100)","v":""},{"$f":"IF(K100=\"\",\"\",J101+K100)","v":""},{"$f":"IF(L100=\"\",\"\",K101+L100)","v":""},{"$f":"IF(M100=\"\",\"\",L101+M100)","v":""},{"$f":"IF(N100=\"\",\"\",M101+N100)","v":""},{"$f":"IF(O100=\"\",\"\",N101+O100)","v":""},{"$f":"IF(P100=\"\",\"\",O101+P100)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E102:P102)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E103:P103)","v":0},null,{"$f":"SUM(E103:P103)","v":0},null,{"$f":"IF(OR(V102=\"\",V102=0),\"\",IF(T103>V102,1,T103/V102))","v":""},{"$f":"IF(V103=\"\",\"\",1-V103)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E103=\"\",\"\",D104+E103)","v":""},{"$f":"IF(F103=\"\",\"\",E104+F103)","v":""},{"$f":"IF(G103=\"\",\"\",F104+G103)","v":""},{"$f":"IF(H103=\"\",\"\",G104+H103)","v":""},{"$f":"IF(I103=\"\",\"\",H104+I103)","v":""},{"$f":"IF(J103=\"\",\"\",I104+J103)","v":""},{"$f":"IF(K103=\"\",\"\",J104+K103)","v":""},{"$f":"IF(L103=\"\",\"\",K104+L103)","v":""},{"$f":"IF(M103=\"\",\"\",L104+M103)","v":""},{"$f":"IF(N103=\"\",\"\",M104+N103)","v":""},{"$f":"IF(O103=\"\",\"\",N104+O103)","v":""},{"$f":"IF(P103=\"\",\"\",O104+P103)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E105:P105)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E106:P106)","v":0},null,{"$f":"SUM(E106:P106)","v":0},null,{"$f":"IF(OR(V105=\"\",V105=0),\"\",IF(T106>V105,1,T106/V105))","v":""},{"$f":"IF(V106=\"\",\"\",1-V106)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E106=\"\",\"\",D107+E106)","v":""},{"$f":"IF(F106=\"\",\"\",E107+F106)","v":""},{"$f":"IF(G106=\"\",\"\",F107+G106)","v":""},{"$f":"IF(H106=\"\",\"\",G107+H106)","v":""},{"$f":"IF(I106=\"\",\"\",H107+I106)","v":""},{"$f":"IF(J106=\"\",\"\",I107+J106)","v":""},{"$f":"IF(K106=\"\",\"\",J107+K106)","v":""},{"$f":"IF(L106=\"\",\"\",K107+L106)","v":""},{"$f":"IF(M106=\"\",\"\",L107+M106)","v":""},{"$f":"IF(N106=\"\",\"\",M107+N106)","v":""},{"$f":"IF(O106=\"\",\"\",N107+O106)","v":""},{"$f":"IF(P106=\"\",\"\",O107+P106)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E108:P108)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E109:P109)","v":0},null,{"$f":"SUM(E109:P109)","v":0},null,{"$f":"IF(OR(V108=\"\",V108=0),\"\",IF(T109>V108,1,T109/V108))","v":""},{"$f":"IF(V109=\"\",\"\",1-V109)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E109=\"\",\"\",D110+E109)","v":""},{"$f":"IF(F109=\"\",\"\",E110+F109)","v":""},{"$f":"IF(G109=\"\",\"\",F110+G109)","v":""},{"$f":"IF(H109=\"\",\"\",G110+H109)","v":""},{"$f":"IF(I109=\"\",\"\",H110+I109)","v":""},{"$f":"IF(J109=\"\",\"\",I110+J109)","v":""},{"$f":"IF(K109=\"\",\"\",J110+K109)","v":""},{"$f":"IF(L109=\"\",\"\",K110+L109)","v":""},{"$f":"IF(M109=\"\",\"\",L110+M109)","v":""},{"$f":"IF(N109=\"\",\"\",M110+N109)","v":""},{"$f":"IF(O109=\"\",\"\",N110+O109)","v":""},{"$f":"IF(P109=\"\",\"\",O110+P109)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E111:P111)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E112:P112)","v":0},null,{"$f":"SUM(E112:P112)","v":0},null,{"$f":"IF(OR(V111=\"\",V111=0),\"\",IF(T112>V111,1,T112/V111))","v":""},{"$f":"IF(V112=\"\",\"\",1-V112)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E112=\"\",\"\",D113+E112)","v":""},{"$f":"IF(F112=\"\",\"\",E113+F112)","v":""},{"$f":"IF(G112=\"\",\"\",F113+G112)","v":""},{"$f":"IF(H112=\"\",\"\",G113+H112)","v":""},{"$f":"IF(I112=\"\",\"\",H113+I112)","v":""},{"$f":"IF(J112=\"\",\"\",I113+J112)","v":""},{"$f":"IF(K112=\"\",\"\",J113+K112)","v":""},{"$f":"IF(L112=\"\",\"\",K113+L112)","v":""},{"$f":"IF(M112=\"\",\"\",L113+M112)","v":""},{"$f":"IF(N112=\"\",\"\",M113+N112)","v":""},{"$f":"IF(O112=\"\",\"\",N113+O112)","v":""},{"$f":"IF(P112=\"\",\"\",O113+P112)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E114:P114)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E115:P115)","v":0},null,{"$f":"SUM(E115:P115)","v":0},null,{"$f":"IF(OR(V114=\"\",V114=0),\"\",IF(T115>V114,1,T115/V114))","v":""},{"$f":"IF(V115=\"\",\"\",1-V115)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E115=\"\",\"\",D116+E115)","v":""},{"$f":"IF(F115=\"\",\"\",E116+F115)","v":""},{"$f":"IF(G115=\"\",\"\",F116+G115)","v":""},{"$f":"IF(H115=\"\",\"\",G116+H115)","v":""},{"$f":"IF(I115=\"\",\"\",H116+I115)","v":""},{"$f":"IF(J115=\"\",\"\",I116+J115)","v":""},{"$f":"IF(K115=\"\",\"\",J116+K115)","v":""},{"$f":"IF(L115=\"\",\"\",K116+L115)","v":""},{"$f":"IF(M115=\"\",\"\",L116+M115)","v":""},{"$f":"IF(N115=\"\",\"\",M116+N115)","v":""},{"$f":"IF(O115=\"\",\"\",N116+O115)","v":""},{"$f":"IF(P115=\"\",\"\",O116+P115)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E117:P117)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E118:P118)","v":0},null,{"$f":"SUM(E118:P118)","v":0},null,{"$f":"IF(OR(V117=\"\",V117=0),\"\",IF(T118>V117,1,T118/V117))","v":""},{"$f":"IF(V118=\"\",\"\",1-V118)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E118=\"\",\"\",D119+E118)","v":""},{"$f":"IF(F118=\"\",\"\",E119+F118)","v":""},{"$f":"IF(G118=\"\",\"\",F119+G118)","v":""},{"$f":"IF(H118=\"\",\"\",G119+H118)","v":""},{"$f":"IF(I118=\"\",\"\",H119+I118)","v":""},{"$f":"IF(J118=\"\",\"\",I119+J118)","v":""},{"$f":"IF(K118=\"\",\"\",J119+K118)","v":""},{"$f":"IF(L118=\"\",\"\",K119+L118)","v":""},{"$f":"IF(M118=\"\",\"\",L119+M118)","v":""},{"$f":"IF(N118=\"\",\"\",M119+N118)","v":""},{"$f":"IF(O118=\"\",\"\",N119+O118)","v":""},{"$f":"IF(P118=\"\",\"\",O119+P118)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E120:P120)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E121:P121)","v":0},null,{"$f":"SUM(E121:P121)","v":0},null,{"$f":"IF(OR(V120=\"\",V120=0),\"\",IF(T121>V120,1,T121/V120))","v":""},{"$f":"IF(V121=\"\",\"\",1-V121)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E121=\"\",\"\",D122+E121)","v":""},{"$f":"IF(F121=\"\",\"\",E122+F121)","v":""},{"$f":"IF(G121=\"\",\"\",F122+G121)","v":""},{"$f":"IF(H121=\"\",\"\",G122+H121)","v":""},{"$f":"IF(I121=\"\",\"\",H122+I121)","v":""},{"$f":"IF(J121=\"\",\"\",I122+J121)","v":""},{"$f":"IF(K121=\"\",\"\",J122+K121)","v":""},{"$f":"IF(L121=\"\",\"\",K122+L121)","v":""},{"$f":"IF(M121=\"\",\"\",L122+M121)","v":""},{"$f":"IF(N121=\"\",\"\",M122+N121)","v":""},{"$f":"IF(O121=\"\",\"\",N122+O121)","v":""},{"$f":"IF(P121=\"\",\"\",O122+P121)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E123:P123)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E124:P124)","v":0},null,{"$f":"SUM(E124:P124)","v":0},null,{"$f":"IF(OR(V123=\"\",V123=0),\"\",IF(T124>V123,1,T124/V123))","v":""},{"$f":"IF(V124=\"\",\"\",1-V124)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E124=\"\",\"\",D125+E124)","v":""},{"$f":"IF(F124=\"\",\"\",E125+F124)","v":""},{"$f":"IF(G124=\"\",\"\",F125+G124)","v":""},{"$f":"IF(H124=\"\",\"\",G125+H124)","v":""},{"$f":"IF(I124=\"\",\"\",H125+I124)","v":""},{"$f":"IF(J124=\"\",\"\",I125+J124)","v":""},{"$f":"IF(K124=\"\",\"\",J125+K124)","v":""},{"$f":"IF(L124=\"\",\"\",K125+L124)","v":""},{"$f":"IF(M124=\"\",\"\",L125+M124)","v":""},{"$f":"IF(N124=\"\",\"\",M125+N124)","v":""},{"$f":"IF(O124=\"\",\"\",N125+O124)","v":""},{"$f":"IF(P124=\"\",\"\",O125+P124)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E126:P126)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E127:P127)","v":0},null,{"$f":"SUM(E127:P127)","v":0},null,{"$f":"IF(OR(V126=\"\",V126=0),\"\",IF(T127>V126,1,T127/V126))","v":""},{"$f":"IF(V127=\"\",\"\",1-V127)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E127=\"\",\"\",D128+E127)","v":""},{"$f":"IF(F127=\"\",\"\",E128+F127)","v":""},{"$f":"IF(G127=\"\",\"\",F128+G127)","v":""},{"$f":"IF(H127=\"\",\"\",G128+H127)","v":""},{"$f":"IF(I127=\"\",\"\",H128+I127)","v":""},{"$f":"IF(J127=\"\",\"\",I128+J127)","v":""},{"$f":"IF(K127=\"\",\"\",J128+K127)","v":""},{"$f":"IF(L127=\"\",\"\",K128+L127)","v":""},{"$f":"IF(M127=\"\",\"\",L128+M127)","v":""},{"$f":"IF(N127=\"\",\"\",M128+N127)","v":""},{"$f":"IF(O127=\"\",\"\",N128+O127)","v":""},{"$f":"IF(P127=\"\",\"\",O128+P127)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E129:P129)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E130:P130)","v":0},null,{"$f":"SUM(E130:P130)","v":0},null,{"$f":"IF(OR(V129=\"\",V129=0),\"\",IF(T130>V129,1,T130/V129))","v":""},{"$f":"IF(V130=\"\",\"\",1-V130)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E130=\"\",\"\",D131+E130)","v":""},{"$f":"IF(F130=\"\",\"\",E131+F130)","v":""},{"$f":"IF(G130=\"\",\"\",F131+G130)","v":""},{"$f":"IF(H130=\"\",\"\",G131+H130)","v":""},{"$f":"IF(I130=\"\",\"\",H131+I130)","v":""},{"$f":"IF(J130=\"\",\"\",I131+J130)","v":""},{"$f":"IF(K130=\"\",\"\",J131+K130)","v":""},{"$f":"IF(L130=\"\",\"\",K131+L130)","v":""},{"$f":"IF(M130=\"\",\"\",L131+M130)","v":""},{"$f":"IF(N130=\"\",\"\",M131+N130)","v":""},{"$f":"IF(O130=\"\",\"\",N131+O130)","v":""},{"$f":"IF(P130=\"\",\"\",O131+P130)","v":""}]
[null,"S Ville",{"$nulls":17},{"$f":"SUM(E132:P132)","v":0}]
[null,null,"Mensuel",{"$nulls":14},{"$f":"12-COUNTBLANK(E133:P133)","v":0},null,{"$f":"SUM(E133:P133)","v":0},null,{"$f":"IF(OR(V132=\"\",V132=0),\"\",IF(T133>V132,1,T133/V132))","v":""},{"$f":"IF(V133=\"\",\"\",1-V133)","v":""}]
[null,null,"Cumul",null,{"$f":"IF(E133=\"\",\"\",D134+E133)","v":""},{"$f":"IF(F133=\"\",\"\",E134+F133)","v":""},{"$f":"IF(G133=\"\",\"\",F134+G133)","v":""},{"$f":"IF(H133=\"\",\"\",G134+H133)","v":""},{"$f":"IF(I133=\"\",\"\",H134+I133)","v":""},{"$f":"IF(J133=\"\",\"\",I134+J133)","v":""},{"$f":"IF(K133=\"\",\"\",J134+K133)","v":""},{"$f":"IF(L133=\"\",\"\",K134+L133)","v":""},{"$f":"IF(M133=\"\",\"\",L134+M133)","v":""},{"$f":"IF(N133=\"\",\"\",M134+N133)","v":""},{"$f":"IF(O133=\"\",\"\",N134+O133)","v":""},{"$f":"IF(P133=\"\",\"\",O134+P133)","v":""}]

{"sheet":"renouvel életro details","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"merged":[[0,0,3,1],[0,2,3,11],[0,12,3,14],[4,0,163,0],[4,2,4,5],[4,6,4,11],[5,2,5,5],[5,6,5,11],[6,2,6,5],[6,6,6,11],[7,2,7,5],[7,6,7,11],[8,2,8,5],[8,6,8,11],[9,2,9,5],[9,6,9,11],[10,2,10,5],[10,6,10,11],[11,2,11,5],[11,6,11,11],[12,2,12,5],[12,6,12,11],[13,2,13,5],[13,6,13,11],[14,2,14,5],[14,6,14,11],[15,2,15,5],[15,6,15,11],[16,2,16,5],[16,6,16,11],[17,2,17,5],[17,6,17,11],[18,2,18,5],[18,6,18,11],[19,2,19,5],[19,6,19,11],[20,2,20,5],[20,6,20,11],[21,2,21,5],[21,6,21,11],[22,2,22,5],[22,6,22,11],[23,2,23,5],[23,6,23,11],[24,2,24,5],[24,6,24,11],[25,2,25,5],[25,6,25,11],[26,2,26,5],[26,6,26,11],[27,2,27,5],[27,6,27,11],[28,2,28,5],[28,6,28,11],[29,2,29,5],[29,6,29,11]]}
[null,null,"Renouvellement élecro. PROGRAMME (en montant) "]
[]
[]
[]
["Détails","Date :","Lieu :",{"$nulls":3},"Type :"]
[]
[null,"2015-01-21","Lieu :",{"$nulls":3},"changement rotor"]
[null,"2015-03-03","buelas",{"$nulls":3},"changement pompe"]