{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["MONTANT AUTO","MONTANT AUTO (2)"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"MONTANT AUTO","index":0,"n_rows":43,"n_cols":22,"rows_kept":43,"merged":[[33,9,33,11],[33,14,33,15],[35,5,35,11],[35,14,35,15],[36,5,36,10],[36,14,36,15],[37,5,37,10],[37,14,37,15],[38,5,38,10],[38,14,38,15],[39,5,39,10],[39,14,39,15],[40,5,40,10],[41,5,41,10],[41,14,42,15],[41,16,42,17],[42,5,42,10]]}
["jour du mois","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","Nbre véhicules total","Montant redevance",{"$nulls":3},"Barnum","Camion ou remorque grpe electro","Neutralisation"]
[1,{"$nulls":10},{"$f":"SUM(B2:K2)","v":0},{"$f":"IF(L2>80,2000,IF(L2>60,1500,IF(L2>40,1000,IF(L2>20,500,IF(L2>12,240,IF(L2>7,180,IF(L2>0,80,0)))))))","v":{"v":0,"d":"0 €"}},null,null,1]
[2,{"$nulls":10},0,{"$f":"IF(L3>80,2000,IF(L3>60,1500,IF(L3>40,1000,IF(L3>20,500,IF(L3>12,240,IF(L3>7,180,IF(L3>0,80,0)))))))","v":{"v":0,"d":"0 €"}},null,null,{"$f":"P2+1","v":2}]
[3,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,{"$f":"P3+1","v":3}]
[4,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,4]
[5,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,5]
[6,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,6]
[7,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,7]
[8,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,8]
[9,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,9]
[10,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,10]
[11,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,11]
[12,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,12]
[13,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,13]
[14,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,14]
[15,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,15]
[16,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,16]
[17,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,17]
[18,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,18]
[19,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,19]
[20,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,20]
[21,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,21]
[22,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,22]
[23,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,23]
[24,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,24]
[25,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,25]
[26,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,26,{"$nulls":5},{"$f":"SUM(S17:S19)","v":0}]
[27,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,27]
[28,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,28]
[29,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,29]
[30,{"$nulls":10},0,{"v":0,"d":"0 €"},null," ",30]
[31,{"$nulls":10},0,{"v":0,"d":"0 €"},null,null,31]
[]
["numéro DT",{"$nulls":8},"Total stationnement",null,null,{"$f":"M32+M31+M30+M29+M28+M27+M26+M25+M24+M23++M22+M21+M20+M19+M18+M17+M16+M15+M14+M13+M12+M11+M10+M9+M8+M7+M6+M5+M4+M3+M2","v":0},null,"Total",null,{"$f":"SUM(Q2:Q33)*120","v":{"v":0,"d":"0 €"}},{"$f":"SUM(R2:R33)*120","v":{"v":0,"d":"0 €"}},{"$f":"SUM(S2:S33)*500","v":{"v":0,"d":"0 €"}}]
[]
[{"$nulls":5},"Forfait",{"$nulls":6},"nbre",null,"Ann tech 1"]
[{"$nulls":5},"Redevance journalière pour 1 à 7 véhicule(s) à",{"$nulls":5},{"v":80,"d":"80 €"},{"$f":"COUNTIFS($M$2:$M$32,L37)","v":0},null,"Ann tech 2"]
[{"$nulls":5},"Redevance journalière pour 8 à 12 véhicules à",{"$nulls":5},{"v":180,"d":"180 €"},{"$f":"COUNTIFS($M$2:$M$32,L38)","v":0},null,"Ann tech 3"]
[{"$nulls":5},"Redevance journalière pour 13 à 20 véhicules à",{"$nulls":5},{"v":240,"d":"240 €"},{"$f":"COUNTIFS($M$2:$M$32,L39)","v":0},null,"Ann tech 4"]
[{"$nulls":5},"Redevance journalière pour 21 à 40 véhicules à",{"$nulls":5},{"v":500,"d":"500 €"},0,null,"Total Ann tech",null,{"$f":"SUM(Q36:Q39)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"Redevance journalière pour 41 à 60 véhicules à",{"$nulls":5},{"v":1000,"d":"1,000 €"},0]
[{"$nulls":5},"Redevance journalière pour 61 à 80 véhicules à",{"$nulls":5},{"v":1500,"d":"1,500 €"},0,null,"Total général",null,{"$f":"M34+Q34+R34+S34+Q40","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"Redevance journalière pour + de 80 véhicules à",{"$nulls":5},{"v":2000,"d":"2,000 €"},0]

{"sheet":"MONTANT AUTO (2)","index":1,"n_rows":41,"n_cols":17,"rows_kept":41,"merged":[[33,9,33,11],[33,14,33,15],[35,5,35,11],[35,14,35,15],[36,5,36,10],[36,14,36,15],[37,5,37,10],[37,14,37,15],[38,5,38,10],[38,14,38,15],[39,5,39,10],[39,14,39,15],[40,5,40,10],[40,14,40,15]]}
["jour du mois","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","ligne autori-sation","Nbre véhicules total","Montant redevance",{"$nulls":3},"Barnum"]
[1,{"$nulls":10},{"$f":"SUM(B2:K2)","v":0},{"$f":"IF(L2>40,\"700\",IF(L2>20,\"400\",IF(L2>12,\"200\",IF(L2>7,\"150\",IF(L2>0,\"70\",\"0\")))))","v":"0"},null,null,1]
[2,{"$nulls":10},0,{"$f":"IF(L3>40,\"700\",IF(L3>20,\"400\",IF(L3>12,\"200\",IF(L3>7,\"150\",IF(L3>0,\"70\",\"0\")))))","v":"0"},null,null,{"$f":"P2+1","v":2}]
[3,{"$nulls":10},0,{"$f":"IF(L4>40,\"700\",IF(L4>20,\"400\",IF(L4>12,\"200\",IF(L4>7,\"150\",IF(L4>0,\"70\",\"0\")))))","v":"0"},null,null,{"$f":"P3+1","v":3}]
[4,{"$nulls":10},0,"0",null,null,4]
[5,{"$nulls":10},0,"0",null,null,5]
[6,{"$nulls":10},0,"0",null,null,6]
[7,{"$nulls":10},0,"0",null,null,7]
[8,{"$nulls":10},0,"0",null,null,8]
[9,{"$nulls":10},0,"0",null,null,9]
[10,{"$nulls":10},0,"0",null,null,10]
[11,{"$nulls":10},0,"0",null,null,11]
[12,{"$nulls":10},0,"0",null,null,12]
[13,{"$nulls":10},0,"0",null,null,13]
[14,{"$nulls":10},0,"0",null,null,14]
[15,{"$nulls":10},0,"0",null,null,15]
[16,{"$nulls":10},0,"0",null,null,16]
[17,{"$nulls":10},0,"0",null,null,17]
[18,{"$nulls":10},0,"0",null,null,18]
[19,{"$nulls":10},0,"0",null,null,19]
[20,{"$nulls":10},0,"0",null,null,20]
[21,{"$nulls":10},0,"0",null,null,21]
[22,{"$nulls":10},0,{"$f":"IF(L23>40,\"700\",IF(L23>20,\"400\",IF(L23>12,\"200\",IF(L23>7,\"150\",IF(L23>0,\"70\",\"0\")))))","v":"0"},null,null,22]
[23,{"$nulls":10},0,"0",null,null,23]
[24,{"$nulls":10},0,"0",null,null,24]
[25,{"$nulls":10},0,"0",null,null,25]
[26,{"$nulls":10},0,"0",null,null,26]
[27,{"$nulls":10},0,"0",null,null,27]
[28,{"$nulls":10},0,"0",null,null,28]
[29,{"$nulls":10},0,"0",null,null,29]
[30,{"$nulls":10},0,"0",null," ",30]
[31,{"$nulls":10},0,"0",null,null,31]
[]
[{"$nulls":9},"Total stationnement",null,null,{"$f":"M32+M31+M30+M29+M28+M27+M26+M25+M24+M23++M22+M21+M20+M19+M18+M17+M16+M15+M14+M13+M12+M11+M10+M9+M8+M7+M6+M5+M4+M3+M2","v":{"v":0,"d":"0.00"}},null,"Total barnum",null,{"$f":"SUM(Q2:Q33)*100","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":5},"Forfait",{"$nulls":6},"nbre",null,"Total ",null,{"$f":"M34+Q34","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"Redevance journalière pour 1 à 7 véhicules à",{"$nulls":5},{"v":70,"d":"70 €"},{"$f":"COUNTIFS($M$2:$M$32,L37)","v":0},null,"Ann tech 1"]
[{"$nulls":5},"Redevance journalière pour 8 à 12 véhicules à",{"$nulls":5},{"v":150,"d":"150 €"},{"$f":"COUNTIFS($M$2:$M$32,L38)","v":0},null,"Ann tech 2"]
[{"$nulls":5},"Redevance journalière pour 13 à 20 véhicules à",{"$nulls":5},{"v":200,"d":"200 €"},{"$f":"COUNTIFS($M$2:$M$32,L39)","v":0},null,"Ann tech 3"]
[{"$nulls":5},"Redevance journalière pour 21 à 40 véhicules à",{"$nulls":5},{"v":400,"d":"400 €"},0,null,"Ann tech 4"]
[{"$nulls":5},"Redevance journalière pour + de 40 véhicules à",{"$nulls":5},{"v":700,"d":"700 €"},0,null,"Total général",null,{"$f":"Q36+Q37+Q38+Q39+Q40","v":{"v":0,"d":"0.00 €"}}]