{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Informations","Investissements","Calculs","Enrolement","Paramètres"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Informations","index":0,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[59,1,59,3],[57,1,57,3],[63,1,63,2],[65,1,65,2],[63,3,63,5],[65,3,65,4],[60,1,60,3],[61,1,61,2],[61,3,61,5],[59,4,59,5],[68,0,68,9],[69,0,69,9],[1,0,1,9],[2,2,2,8],[6,2,6,3],[8,2,8,8],[10,3,10,4],[34,7,34,8],[32,2,32,8],[34,2,34,4],[30,2,30,4],[30,6,30,8],[25,2,25,6],[28,1,28,8],[12,1,12,8],[6,7,6,8],[4,2,4,6],[20,2,20,4],[14,2,14,4],[14,6,14,8],[18,2,18,8],[20,7,20,8],[22,2,23,8],[36,2,37,8],[39,2,39,6],[52,1,52,3],[53,1,53,3],[47,4,47,5],[55,1,55,3],[43,6,43,9],[43,1,43,3],[45,1,45,3],[47,1,47,3],[51,1,51,3],[55,6,55,8],[55,4,55,5]]}
[]
["Fiche d'information dispositif PEEP - 2023"]
[null,"Entreprise:"]
[]
[null,"Statut Juridique :"]
[]
[null,"SIRET :",null,null,null,null,"Code NAF :"]
[]
[null,"Titre du projet:"]
[]
[null,"Date début travaux:",null,"Date fin travaux:   "]
[]
[null,"       Responsable légal (signant la convention)"]
[]
[null,"Nom:",null,null,null,"Prénom:"]
[]
[null,"Civilité :"]
[]
[null,"Fonction :"]
[]
[null,"Mél :",null,null,null,null,"Téléphone :"]
[]
[null,"Adresse:"]
[]
[]
[null,"Ville:",null,null,null,null,null,"CP:"]
[]
[]
[null,"    Responsable du projet et adresse du site concerné"]
[]
[null,"Nom:",null,null,null,"Prénom:"]
[]
[null,"Fonction :"]
[]
[null,"Mél :",null,null,null,null,"Téléphone :"]
[]
[null,"Adresse:"]
[]
[]
[null,"Ville:",null,null,null,null,null,"CP:"]
[]
[]
[]
[null,"Votre site est il déjà certifié ISO 50 001 ?",null,null,null,null,"              (fournir le certificat)"]
[]
[null,"Etes vous en cours de certification ISO 50 001 ?"]
[]
[null,"Si oui, précisez la date de certification programmée:"]
[]
[]
[]
[null,"Avez-vous déjà nommé un Référent énergie ?"]
[]
[null,"A-t-il déjà effectué la formation PROREFEI* ?"]
[]
[null,"Si oui, précisez la date de la cession:",null,null,null,null,"  (fournir le certificat de formation)"]
[]
[null,"Si non, avez-vous prévu une formation PROREFEI* ?"]
[]
[null,"Si oui, précisez la date de la cession à venir:"]
[]
[null,"Nom éventuel du Référent énergie:"]
[]
[null,"Adresse Email:"]
[]
[null,"Téléphone :","03 03 03 03 03"]
[]
[]
["*: Le Programme PROREFEI vise à former les salariés en charge de la gestion de l’énergie dans l’industrie et le tertiaire complexe. Informations:"]
["https://www.prorefei.org/le-programme-prorefei"]

{"sheet":"Investissements","index":1,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[[15,1,15,16],[38,6,38,7],[39,6,39,7],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[47,6,47,7],[48,6,48,7],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[21,0,21,16],[17,0,17,16],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[24,4,24,6],[25,4,25,6],[25,1,25,2],[1,0,1,16],[36,0,36,16],[18,1,18,8],[1,150,1,159],[1,160,1,169],[1,170,1,179],[1,180,1,189],[1,190,1,199],[1,20,1,29],[1,30,1,39],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[1,40,1,49],[1,50,1,59],[1,60,1,69],[1,70,1,79],[1,80,1,89],[1,90,1,99],[1,100,1,109],[1,110,1,119],[1,120,1,129],[1,130,1,139],[1,140,1,149],[1,350,1,359],[1,360,1,369],[1,370,1,379],[1,380,1,389],[1,390,1,399],[1,300,1,309],[1,310,1,319],[1,320,1,329],[1,330,1,339],[1,340,1,349],[1,250,1,259],[1,260,1,269],[1,270,1,279],[1,280,1,289],[1,290,1,299],[1,200,1,209],[1,210,1,219],[1,220,1,229],[1,230,1,239],[1,240,1,249],[1,550,1,559],[1,560,1,569],[1,570,1,579],[1,580,1,589],[1,590,1,599],[1,500,1,509],[1,510,1,519],[1,520,1,529],[1,530,1,539],[1,540,1,549],[1,450,1,459],[1,460,1,469],[1,470,1,479],[1,480,1,489],[1,490,1,499],[1,400,1,409],[1,410,1,419],[1,420,1,429],[1,430,1,439],[1,440,1,449],[1,750,1,759],[1,760,1,769],[1,770,1,779],[1,780,1,789],[1,790,1,799],[1,700,1,709],[1,710,1,719],[1,720,1,729],[1,730,1,739],[1,740,1,749],[1,650,1,659],[1,660,1,669],[1,670,1,679],[1,680,1,689],[1,690,1,699],[1,600,1,609],[1,610,1,619],[1,620,1,629],[1,630,1,639],[1,640,1,649],[1,950,1,959],[1,960,1,969],[1,970,1,979],[1,980,1,989],[1,990,1,999],[1,900,1,909],[1,910,1,919],[1,920,1,929],[1,930,1,939],[1,940,1,949],[1,850,1,859],[1,860,1,869],[1,870,1,879],[1,880,1,889],[1,890,1,899],[1,800,1,809],[1,810,1,819],[1,820,1,829],[1,830,1,839],[1,840,1,849],[1,1150,1,1159],[1,1160,1,1169],[1,1170,1,1179],[1,1180,1,1189],[1,1190,1,1199],[1,1100,1,1109],[1,1110,1,1119],[1,1120,1,1129],[1,1130,1,1139],[1,1140,1,1149],[1,1050,1,1059],[1,1060,1,1069],[1,1070,1,1079],[1,1080,1,1089],[1,1090,1,1099],[1,1000,1,1009],[1,1010,1,1019],[1,1020,1,1029],[1,1030,1,1039],[1,1040,1,1049],[1,1350,1,1359],[1,1360,1,1369],[1,1370,1,1379],[1,1380,1,1389],[1,1390,1,1399],[1,1300,1,1309],[1,1310,1,1319],[1,1320,1,1329],[1,1330,1,1339],[1,1340,1,1349],[1,1250,1,1259],[1,1260,1,1269],[1,1270,1,1279],[1,1280,1,1289],[1,1290,1,1299],[1,1200,1,1209],[1,1210,1,1219],[1,1220,1,1229],[1,1230,1,1239],[1,1240,1,1249],[1,1550,1,1559],[1,1560,1,1569],[1,1570,1,1579],[1,1580,1,1589],[1,1590,1,1599],[1,1500,1,1509],[1,1510,1,1519],[1,1520,1,1529],[1,1530,1,1539],[1,1540,1,1549],[1,1450,1,1459],[1,1460,1,1469],[1,1470,1,1479],[1,1480,1,1489],[1,1490,1,1499],[1,1400,1,1409],[1,1410,1,1419],[1,1420,1,1429],[1,1430,1,1439],[1,1440,1,1449],[1,1750,1,1759],[1,1760,1,1769],[1,1770,1,1779],[1,1780,1,1789],[1,1790,1,1799],[1,1700,1,1709],[1,1710,1,1719],[1,1720,1,1729],[1,1730,1,1739],[1,1740,1,1749],[1,1650,1,1659],[1,1660,1,1669],[1,1670,1,1679],[1,1680,1,1689],[1,1690,1,1699],[1,1600,1,1609],[1,1610,1,1619],[1,1620,1,1629],[1,1630,1,1639],[1,1640,1,1649],[1,1950,1,1959],[1,1960,1,1969],[1,1970,1,1979],[1,1980,1,1989],[1,1990,1,1999],[1,1900,1,1909],[1,1910,1,1919],[1,1920,1,1929],[1,1930,1,1939],[1,1940,1,1949],[1,1850,1,1859],[1,1860,1,1869],[1,1870,1,1879],[1,1880,1,1889],[1,1890,1,1899],[1,1800,1,1809],[1,1810,1,1819],[1,1820,1,1829],[1,1830,1,1839],[1,1840,1,1849],[1,2150,1,2159],[1,2160,1,2169],[1,2170,1,2179],[1,2180,1,2189],[1,2190,1,2199],[1,2100,1,2109],[1,2110,1,2119],[1,2120,1,2129],[1,2130,1,2139],[1,2140,1,2149],[1,2050,1,2059],[1,2060,1,2069],[1,2070,1,2079],[1,2080,1,2089],[1,2090,1,2099],[1,2000,1,2009],[1,2010,1,2019],[1,2020,1,2029],[1,2030,1,2039],[1,2040,1,2049],[1,2350,1,2359],[1,2360,1,2369],[1,2370,1,2379],[1,2380,1,2389],[1,2390,1,2399],[1,2300,1,2309],[1,2310,1,2319],[1,2320,1,2329],[1,2330,1,2339],[1,2340,1,2349],[1,2250,1,2259],[1,2260,1,2269],[1,2270,1,2279],[1,2280,1,2289],[1,2290,1,2299],[1,2200,1,2209],[1,2210,1,2219],[1,2220,1,2229],[1,2230,1,2239],[1,2240,1,2249],[1,2550,1,2559],[1,2560,1,2569],[1,2570,1,2579],[1,2580,1,2589],[1,2590,1,2599],[1,2500,1,2509],[1,2510,1,2519],[1,2520,1,2529],[1,2530,1,2539],[1,2540,1,2549],[1,2450,1,2459],[1,2460,1,2469],[1,2470,1,2479],[1,2480,1,2489],[1,2490,1,2499],[1,2400,1,2409],[1,2410,1,2419],[1,2420,1,2429],[1,2430,1,2439],[1,2440,1,2449],[1,2750,1,2759],[1,2760,1,2769],[1,2770,1,2779],[1,2780,1,2789],[1,2790,1,2799],[1,2700,1,2709],[1,2710,1,2719],[1,2720,1,2729],[1,2730,1,2739],[1,2740,1,2749],[1,2650,1,2659],[1,2660,1,2669],[1,2670,1,2679],[1,2680,1,2689],[1,2690,1,2699],[1,2600,1,2609],[1,2610,1,2619],[1,2620,1,2629],[1,2630,1,2639],[1,2640,1,2649],[1,2950,1,2959],[1,2960,1,2969],[1,2970,1,2979],[1,2980,1,2989],[1,2990,1,2999],[1,2900,1,2909],[1,2910,1,2919],[1,2920,1,2929],[1,2930,1,2939],[1,2940,1,2949],[1,2850,1,2859],[1,2860,1,2869],[1,2870,1,2879],[1,2880,1,2889],[1,2890,1,2899],[1,2800,1,2809],[1,2810,1,2819],[1,2820,1,2829],[1,2830,1,2839],[1,2840,1,2849],[1,3150,1,3159],[1,3160,1,3169],[1,3170,1,3179],[1,3180,1,3189],[1,3190,1,3199],[1,3100,1,3109],[1,3110,1,3119],[1,3120,1,3129],[1,3130,1,3139],[1,3140,1,3149],[1,3050,1,3059],[1,3060,1,3069],[1,3070,1,3079],[1,3080,1,3089],[1,3090,1,3099],[1,3000,1,3009],[1,3010,1,3019],[1,3020,1,3029],[1,3030,1,3039],[1,3040,1,3049],[1,3350,1,3359],[1,3360,1,3369],[1,3370,1,3379],[1,3380,1,3389],[1,3390,1,3399],[1,3300,1,3309],[1,3310,1,3319],[1,3320,1,3329],[1,3330,1,3339],[1,3340,1,3349],[1,3250,1,3259],[1,3260,1,3269],[1,3270,1,3279],[1,3280,1,3289],[1,3290,1,3299],[1,3200,1,3209],[1,3210,1,3219],[1,3220,1,3229],[1,3230,1,3239],[1,3240,1,3249],[1,3550,1,3559],[1,3560,1,3569],[1,3570,1,3579],[1,3580,1,3589],[1,3590,1,3599],[1,3500,1,3509],[1,3510,1,3519],[1,3520,1,3529],[1,3530,1,3539],[1,3540,1,3549],[1,3450,1,3459],[1,3460,1,3469],[1,3470,1,3479],[1,3480,1,3489],[1,3490,1,3499],[1,3400,1,3409],[1,3410,1,3419],[1,3420,1,3429],[1,3430,1,3439],[1,3440,1,3449],[1,3750,1,3759],[1,3760,1,3769],[1,3770,1,3779],[1,3780,1,3789],[1,3790,1,3799],[1,3700,1,3709],[1,3710,1,3719],[1,3720,1,3729],[1,3730,1,3739],[1,3740,1,3749],[1,3650,1,3659],[1,3660,1,3669],[1,3670,1,3679],[1,3680,1,3689],[1,3690,1,3699],[1,3600,1,3609],[1,3610,1,3619],[1,3620,1,3629],[1,3630,1,3639],[1,3640,1,3649],[1,3950,1,3959],[1,3960,1,3969],[1,3970,1,3979],[1,3980,1,3989],[1,3990,1,3999],[1,3900,1,3909],[1,3910,1,3919],[1,3920,1,3929],[1,3930,1,3939],[1,3940,1,3949],[1,3850,1,3859],[1,3860,1,3869],[1,3870,1,3879],[1,3880,1,3889],[1,3890,1,3899],[1,3800,1,3809],[1,3810,1,3819],[1,3820,1,3829],[1,3830,1,3839],[1,3840,1,3849],[1,4150,1,4159],[1,4160,1,4169],[1,4170,1,4179],[1,4180,1,4189],[1,4190,1,4199],[1,4100,1,4109],[1,4110,1,4119],[1,4120,1,4129],[1,4130,1,4139],[1,4140,1,4149],[1,4050,1,4059],[1,4060,1,4069],[1,4070,1,4079],[1,4080,1,4089],[1,4090,1,4099],[1,4000,1,4009],[1,4010,1,4019],[1,4020,1,4029],[1,4030,1,4039],[1,4040,1,4049],[1,4350,1,4359],[1,4360,1,4369],[1,4370,1,4379],[1,4380,1,4389],[1,4390,1,4399],[1,4300,1,4309],[1,4310,1,4319],[1,4320,1,4329],[1,4330,1,4339],[1,4340,1,4349],[1,4250,1,4259],[1,4260,1,4269],[1,4270,1,4279],[1,4280,1,4289],[1,4290,1,4299],[1,4200,1,4209],[1,4210,1,4219],[1,4220,1,4229],[1,4230,1,4239],[1,4240,1,4249],[1,4550,1,4559],[1,4560,1,4569],[1,4570,1,4579],[1,4580,1,4589],[1,4590,1,4599],[1,4500,1,4509],[1,4510,1,4519],[1,4520,1,4529],[1,4530,1,4539],[1,4540,1,4549],[1,4450,1,4459],[1,4460,1,4469],[1,4470,1,4479],[1,4480,1,4489],[1,4490,1,4499],[1,4400,1,4409],[1,4410,1,4419],[1,4420,1,4429],[1,4430,1,4439],[1,4440,1,4449],[1,4750,1,4759],[1,4760,1,4769],[1,4770,1,4779],[1,4780,1,4789],[1,4790,1,4799],[1,4700,1,4709],[1,4710,1,4719],[1,4720,1,4729],[1,4730,1,4739],[1,4740,1,4749],[1,4650,1,4659],[1,4660,1,4669],[1,4670,1,4679],[1,4680,1,4689],[1,4690,1,4699],[1,4600,1,4609],[1,4610,1,4619],[1,4620,1,4629],[1,4630,1,4639],[1,4640,1,4649],[1,4950,1,4959],[1,4960,1,4969],[1,4970,1,4979],[1,4980,1,4989],[1,4990,1,4999],[1,4900,1,4909],[1,4910,1,4919],[1,4920,1,4929],[1,4930,1,4939],[1,4940,1,4949],[1,4850,1,4859],[1,4860,1,4869],[1,4870,1,4879],[1,4880,1,4889],[1,4890,1,4899],[1,4800,1,4809],[1,4810,1,4819],[1,4820,1,4829],[1,4830,1,4839],[1,4840,1,4849],[1,5150,1,5159],[1,5160,1,5169],[1,5170,1,5179],[1,5180,1,5189],[1,5190,1,5199],[1,5100,1,5109],[1,5110,1,5119],[1,5120,1,5129],[1,5130,1,5139],[1,5140,1,5149],[1,5050,1,5059],[1,5060,1,5069],[1,5070,1,5079],[1,5080,1,5089],[1,5090,1,5099],[1,5000,1,5009],[1,5010,1,5019],[1,5020,1,5029],[1,5030,1,5039],[1,5040,1,5049],[1,5350,1,5359],[1,5360,1,5369],[1,5370,1,5379],[1,5380,1,5389],[1,5390,1,5399],[1,5300,1,5309],[1,5310,1,5319],[1,5320,1,5329],[1,5330,1,5339],[1,5340,1,5349],[1,5250,1,5259],[1,5260,1,5269],[1,5270,1,5279],[1,5280,1,5289],[1,5290,1,5299],[1,5200,1,5209],[1,5210,1,5219],[1,5220,1,5229],[1,5230,1,5239],[1,5240,1,5249],[1,5550,1,5559],[1,5560,1,5569],[1,5570,1,5579],[1,5580,1,5589],[1,5590,1,5599],[1,5500,1,5509],[1,5510,1,5519],[1,5520,1,5529],[1,5530,1,5539],[1,5540,1,5549],[1,5450,1,5459],[1,5460,1,5469],[1,5470,1,5479],[1,5480,1,5489],[1,5490,1,5499],[1,5400,1,5409],[1,5410,1,5419],[1,5420,1,5429],[1,5430,1,5439],[1,5440,1,5449],[1,5750,1,5759],[1,5760,1,5769],[1,5770,1,5779],[1,5780,1,5789],[1,5790,1,5799],[1,5700,1,5709],[1,5710,1,5719],[1,5720,1,5729],[1,5730,1,5739],[1,5740,1,5749],[1,5650,1,5659],[1,5660,1,5669],[1,5670,1,5679],[1,5680,1,5689],[1,5690,1,5699],[1,5600,1,5609],[1,5610,1,5619],[1,5620,1,5629],[1,5630,1,5639],[1,5640,1,5649],[1,5950,1,5959],[1,5960,1,5969],[1,5970,1,5979],[1,5980,1,5989],[1,5990,1,5999],[1,5900,1,5909],[1,5910,1,5919],[1,5920,1,5929],[1,5930,1,5939],[1,5940,1,5949],[1,5850,1,5859],[1,5860,1,5869],[1,5870,1,5879],[1,5880,1,5889],[1,5890,1,5899],[1,5800,1,5809],[1,5810,1,5819],[1,5820,1,5829],[1,5830,1,5839],[1,5840,1,5849],[1,6150,1,6159],[1,6160,1,6169],[1,6170,1,6179],[1,6180,1,6189],[1,6190,1,6199],[1,6100,1,6109],[1,6110,1,6119],[1,6120,1,6129],[1,6130,1,6139],[1,6140,1,6149],[1,6050,1,6059],[1,6060,1,6069],[1,6070,1,6079],[1,6080,1,6089],[1,6090,1,6099],[1,6000,1,6009],[1,6010,1,6019],[1,6020,1,6029],[1,6030,1,6039],[1,6040,1,6049],[1,6350,1,6359],[1,6360,1,6369],[1,6370,1,6379],[1,6380,1,6389],[1,6390,1,6399],[1,6300,1,6309],[1,6310,1,6319],[1,6320,1,6329],[1,6330,1,6339],[1,6340,1,6349],[1,6250,1,6259],[1,6260,1,6269],[1,6270,1,6279],[1,6280,1,6289],[1,6290,1,6299],[1,6200,1,6209],[1,6210,1,6219],[1,6220,1,6229],[1,6230,1,6239],[1,6240,1,6249],[1,6550,1,6559],[1,6560,1,6569],[1,6570,1,6579],[1,6580,1,6589],[1,6590,1,6599],[1,6500,1,6509],[1,6510,1,6519],[1,6520,1,6529],[1,6530,1,6539],[1,6540,1,6549],[1,6450,1,6459],[1,6460,1,6469],[1,6470,1,6479],[1,6480,1,6489],[1,6490,1,6499],[1,6400,1,6409],[1,6410,1,6419],[1,6420,1,6429],[1,6430,1,6439],[1,6440,1,6449],[1,6750,1,6759],[1,6760,1,6769],[1,6770,1,6779],[1,6780,1,6789],[1,6790,1,6799],[1,6700,1,6709],[1,6710,1,6719],[1,6720,1,6729],[1,6730,1,6739],[1,6740,1,6749],[1,6650,1,6659],[1,6660,1,6669],[1,6670,1,6679],[1,6680,1,6689],[1,6690,1,6699],[1,6600,1,6609],[1,6610,1,6619],[1,6620,1,6629],[1,6630,1,6639],[1,6640,1,6649],[1,6950,1,6959],[1,6960,1,6969],[1,6970,1,6979],[1,6980,1,6989],[1,6990,1,6999],[1,6900,1,6909],[1,6910,1,6919],[1,6920,1,6929],[1,6930,1,6939],[1,6940,1,6949],[1,6850,1,6859],[1,6860,1,6869],[1,6870,1,6879],[1,6880,1,6889],[1,6890,1,6899],[1,6800,1,6809],[1,6810,1,6819],[1,6820,1,6829],[1,6830,1,6839],[1,6840,1,6849],[1,7150,1,7159],[1,7160,1,7169],[1,7170,1,7179],[1,7180,1,7189],[1,7190,1,7199],[1,7100,1,7109],[1,7110,1,7119],[1,7120,1,7129],[1,7130,1,7139],[1,7140,1,7149],[1,7050,1,7059],[1,7060,1,7069],[1,7070,1,7079],[1,7080,1,7089],[1,7090,1,7099],[1,7000,1,7009],[1,7010,1,7019],[1,7020,1,7029],[1,7030,1,7039],[1,7040,1,7049],[1,7350,1,7359],[1,7360,1,7369],[1,7370,1,7379],[1,7380,1,7389],[1,7390,1,7399],[1,7300,1,7309],[1,7310,1,7319],[1,7320,1,7329],[1,7330,1,7339],[1,7340,1,7349],[1,7250,1,7259],[1,7260,1,7269],[1,7270,1,7279],[1,7280,1,7289],[1,7290,1,7299],[1,7200,1,7209],[1,7210,1,7219],[1,7220,1,7229],[1,7230,1,7239],[1,7240,1,7249],[1,7550,1,7559],[1,7560,1,7569],[1,7570,1,7579],[1,7580,1,7589],[1,7590,1,7599],[1,7500,1,7509],[1,7510,1,7519],[1,7520,1,7529],[1,7530,1,7539],[1,7540,1,7549],[1,7450,1,7459],[1,7460,1,7469],[1,7470,1,7479],[1,7480,1,7489],[1,7490,1,7499],[1,7400,1,7409],[1,7410,1,7419],[1,7420,1,7429],[1,7430,1,7439],[1,7440,1,7449],[1,7750,1,7759],[1,7760,1,7769],[1,7770,1,7779],[1,7780,1,7789],[1,7790,1,7799],[1,7700,1,7709],[1,7710,1,7719],[1,7720,1,7729],[1,7730,1,7739],[1,7740,1,7749],[1,7650,1,7659],[1,7660,1,7669],[1,7670,1,7679],[1,7680,1,7689],[1,7690,1,7699],[1,7600,1,7609],[1,7610,1,7619],[1,7620,1,7629],[1,7630,1,7639],[1,7640,1,7649],[1,7950,1,7959],[1,7960,1,7969],[1,7970,1,7979],[1,7980,1,7989],[1,7990,1,7999],[1,7900,1,7909],[1,7910,1,7919],[1,7920,1,7929],[1,7930,1,7939],[1,7940,1,7949],[1,7850,1,7859],[1,7860,1,7869],[1,7870,1,7879],[1,7880,1,7889],[1,7890,1,7899],[1,7800,1,7809],[1,7810,1,7819],[1,7820,1,7829],[1,7830,1,7839],[1,7840,1,7849],[1,8150,1,8159],[1,8160,1,8169],[1,8170,1,8179],[1,8180,1,8189],[1,8190,1,8199],[1,8100,1,8109],[1,8110,1,8119],[1,8120,1,8129],[1,8130,1,8139],[1,8140,1,8149],[1,8050,1,8059],[1,8060,1,8069],[1,8070,1,8079],[1,8080,1,8089],[1,8090,1,8099],[1,8000,1,8009],[1,8010,1,8019],[1,8020,1,8029],[1,8030,1,8039],[1,8040,1,8049],[1,8350,1,8359],[1,8360,1,8369],[1,8370,1,8379],[1,8380,1,8389],[1,8390,1,8399],[1,8300,1,8309],[1,8310,1,8319],[1,8320,1,8329],[1,8330,1,8339],[1,8340,1,8349],[1,8250,1,8259],[1,8260,1,8269],[1,8270,1,8279],[1,8280,1,8289],[1,8290,1,8299],[1,8200,1,8209],[1,8210,1,8219],[1,8220,1,8229],[1,8230,1,8239],[1,8240,1,8249],[1,8550,1,8559],[1,8560,1,8569],[1,8570,1,8579],[1,8580,1,8589],[1,8590,1,8599],[1,8500,1,8509],[1,8510,1,8519],[1,8520,1,8529],[1,8530,1,8539],[1,8540,1,8549],[1,8450,1,8459],[1,8460,1,8469],[1,8470,1,8479],[1,8480,1,8489],[1,8490,1,8499],[1,8400,1,8409],[1,8410,1,8419],[1,8420,1,8429],[1,8430,1,8439],[1,8440,1,8449],[1,8750,1,8759],[1,8760,1,8769],[1,8770,1,8779],[1,8780,1,8789],[1,8790,1,8799],[1,8700,1,8709],[1,8710,1,8719],[1,8720,1,8729],[1,8730,1,8739],[1,8740,1,8749],[1,8650,1,8659],[1,8660,1,8669],[1,8670,1,8679],[1,8680,1,8689],[1,8690,1,8699],[1,8600,1,8609],[1,8610,1,8619],[1,8620,1,8629],[1,8630,1,8639],[1,8640,1,8649],[1,8950,1,8959],[1,8960,1,8969],[1,8970,1,8979],[1,8980,1,8989],[1,8990,1,8999],[1,8900,1,8909],[1,8910,1,8919],[1,8920,1,8929],[1,8930,1,8939],[1,8940,1,8949],[1,8850,1,8859],[1,8860,1,8869],[1,8870,1,8879],[1,8880,1,8889],[1,8890,1,8899],[1,8800,1,8809],[1,8810,1,8819],[1,8820,1,8829],[1,8830,1,8839],[1,8840,1,8849],[1,9150,1,9159],[1,9160,1,9169],[1,9170,1,9179],[1,9180,1,9189],[1,9190,1,9199],[1,9100,1,9109],[1,9110,1,9119],[1,9120,1,9129],[1,9130,1,9139],[1,9140,1,9149],[1,9050,1,9059],[1,9060,1,9069],[1,9070,1,9079],[1,9080,1,9089],[1,9090,1,9099],[1,9000,1,9009],[1,9010,1,9019],[1,9020,1,9029],[1,9030,1,9039],[1,9040,1,9049],[1,9350,1,9359],[1,9360,1,9369],[1,9370,1,9379],[1,9380,1,9389],[1,9390,1,9399],[1,9300,1,9309],[1,9310,1,9319],[1,9320,1,9329],[1,9330,1,9339],[1,9340,1,9349],[1,9250,1,9259],[1,9260,1,9269],[1,9270,1,9279],[1,9280,1,9289],[1,9290,1,9299],[1,9200,1,9209],[1,9210,1,9219],[1,9220,1,9229],[1,9230,1,9239],[1,9240,1,9249],[1,9550,1,9559],[1,9560,1,9569],[1,9570,1,9579],[1,9580,1,9589],[1,9590,1,9599],[1,9500,1,9509],[1,9510,1,9519],[1,9520,1,9529],[1,9530,1,9539],[1,9540,1,9549],[1,9450,1,9459],[1,9460,1,9469],[1,9470,1,9479],[1,9480,1,9489],[1,9490,1,9499],[1,9400,1,9409]],"merged_total":6699,"flags":["merged_cut"]}
["Dispositif PEEP: partie calcul"]
["Données de consommation énergétique du site"]
[null,"JOINDRE les documents techniques(1) (relevé de consommation d’énergie facturée)  attestant de la consommation d’énergie annuelle pour chaque type d’énergie. "]
[null,"Année de référence:  "]
[]
[null,"Type d'énergie",null,null,null,"Consommation d’énergie site actuelle (MWh/an)",null,"Référence doc. Technique (1)",null,"Diminution prévisionnelle énergie site  (MWh/an)",null,"Coût\n(€/MWh)"]
[null,"Electricité"]
[null,"Gaz"]
[null,"Produits pétroliers"]
[null,"Combustibles minéraux solides (charbon, coke)"]
[null,"Vapeur achetée"]
[null,"Hydrogène"]
[null,"Autre"]
[null,null,"si autre préciser:"]
[]
[null,"Attention: toutes les données doivent être renseignées à iso-production par rapport à l'année de référence"]
[]
["Certificats d'Economie d'Energie (CEEE)"]
[null,"Veuillez indiquer la valorisation de vos CEE éventuels auprès d'un obligé. Pour plus d'informations, se référer à la fiche Climaxion: ",null,null,null,null,null,null,null,"https://www.climaxion.fr/docutheque/certificats-deconomie-denergie-cee-destination-entreprises"]
[null,"Valorisation des CEE: ",null," (€/MWh cumac)"]
[]
["Investissements et choix de la solution de référence (montants en € HT)"]
[null,"JOINDRE les devis(2) de l’installation des équipements sollicités, ainsi que les devis(3) des équipements de référence correspondants lorsque nécessaires\nSont éligibles uniquement les coûts supplémentaires des travaux réalisés hors obligations réglementaires et nécessaires pour parvenir à un niveau d’efficacité énergétique supérieur. Pour chaque équipement sollicité en vue principalement du remplacement de l’existant, indiquer lorsque c’est pertinent, un équivalent dit de référence à savoir un équipement standard moins performant énergétiquement mais moins onéreux. Dans les cas de : récupération/valorisation de chaleur fatale, isolation, il n’est pas pertinent d’indiquer un équipement dit de référence."]
["N°","Nature de l'investissement",null,"Montant investissement\n(€ HT)","Explication sur l'investissement (pourquoi)",null,null,"Usage",null,"Valorisation des CEE (€)","Ref. Devis (2)","Montant solution de référence\n(€ HT)","Explication sur le choix de la solution de référence (éventuelle)",null,null,"Ref. Devis (3)","Base éligible\n(€ HT)"]
[1,null,null,null,null,null,null,null,null,{"$f":"IF(D25<>\"\",IF($C$20=\"\",0,$C$20*P40),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(D25<>\"\",D25-L25-J25,\"\")","v":""}]
[2,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[3,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[4,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Total:",{"$f":"SUM(D25:D34)","v":0},null,null,null,null,null,{"$f":"SUM(J25:J34)","v":0},null,{"$f":"SUM(L25:L34)","v":0},null,null,null,null,{"$f":"SUM(Q25:Q34)","v":0}]
[]
["Calcul des consommations avant (mesure ou calcul) et après investissement (estimation)"]
[null,"JOINDRE les documents techniques(4) attestant de la diminution prévisionnelle de consommation d’énergie générée par les équipements sollicités, ex : audit énergétique, diagnostic équipementier…\nLa diminution de consommation d’énergie prévisionnelle est estimée à iso-production ou à usage équivalent. Elle est exprimée en MWh/an.\n"]
["N°","Nature de l'investissement",null,"Consommation annuelle initiale (MWh/an)","Préciser le mode de calcul",null,"Energie utilisée initialement",null,"Consommation annuelle après investissement\n(MWh/an)","Expliquer le mode de calcul de cette consommation annuelle après investissement (joindre les documents techniques(4) si nécessaire)",null,null,"Energie utilisée pour cet investissement",null,"Gain de consommation (MWh/an)","Montant des CEE valorisés (MWh cumac)","Tonnes CO2 non émises\n(t/an)"]
[{"$f":"IF(A25<>\"\",A25,\"\")","v":1},"",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D40<>\"\",D40-I40,\"\")","v":""},null,{"$f":"IF(O40<>\"\",VLOOKUP(M40,Paramètres!$B$5:$D$17,3,FALSE)*O40,\"\")","v":""}]
[2,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O41<>\"\",VLOOKUP(M41,Paramètres!$B$5:$D$17,3,FALSE)*O41,\"\")","v":""}]
[3,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O42<>\"\",VLOOKUP(M42,Paramètres!$B$5:$D$17,3,FALSE)*O42,\"\")","v":""}]
[4,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O43<>\"\",VLOOKUP(M43,Paramètres!$B$5:$D$17,3,FALSE)*O43,\"\")","v":""}]
[5,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O44<>\"\",VLOOKUP(M44,Paramètres!$B$5:$D$17,3,FALSE)*O44,\"\")","v":""}]
[6,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O45<>\"\",VLOOKUP(M45,Paramètres!$B$5:$D$17,3,FALSE)*O45,\"\")","v":""}]
[7,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O46<>\"\",VLOOKUP(M46,Paramètres!$B$5:$D$17,3,FALSE)*O46,\"\")","v":""}]
[8,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O47<>\"\",VLOOKUP(M47,Paramètres!$B$5:$D$17,3,FALSE)*O47,\"\")","v":""}]
[9,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O48<>\"\",VLOOKUP(M48,Paramètres!$B$5:$D$17,3,FALSE)*O48,\"\")","v":""}]
[10,"",null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(O49<>\"\",VLOOKUP(M49,Paramètres!$B$5:$D$17,3,FALSE)*O49,\"\")","v":""}]
[null,null,"Total:",{"$f":"SUM(D40:D49)","v":0},null,null,null,null,{"$f":"SUM(I40:I49)","v":0},null,null,null,null,null,{"$f":"SUM(O40:O49)","v":0},{"$f":"SUM(P40:P49)","v":0},{"$f":"SUM(Q40:Q49)","v":0}]

{"sheet":"Calculs","index":2,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":true,"merged":[[51,1,51,2],[52,1,52,2],[49,1,49,2],[50,1,50,2],[47,1,47,2],[48,1,48,2],[41,1,41,11],[11,96,11,111],[11,112,11,127],[11,128,11,143],[11,144,11,159],[11,160,11,175],[11,16,11,31],[11,32,11,47],[11,48,11,63],[11,64,11,79],[11,80,11,95],[45,1,45,2],[46,1,46,2],[44,13,44,15],[1,8,1,13],[1,2,1,6],[2,2,2,10],[39,1,39,2],[4,0,4,15],[11,0,11,15],[11,416,11,431],[11,432,11,447],[11,448,11,463],[11,464,11,479],[11,480,11,495],[11,336,11,351],[11,352,11,367],[11,368,11,383],[11,384,11,399],[11,400,11,415],[11,256,11,271],[11,272,11,287],[11,288,11,303],[11,304,11,319],[11,320,11,335],[11,176,11,191],[11,192,11,207],[11,208,11,223],[11,224,11,239],[11,240,11,255],[26,208,26,223],[26,224,26,239],[26,240,26,255],[26,256,26,271],[26,272,26,287],[26,448,26,463],[11,736,11,751],[11,752,11,767],[11,768,11,783],[11,784,11,799],[11,800,11,815],[11,656,11,671],[11,672,11,687],[11,688,11,703],[11,704,11,719],[11,720,11,735],[11,576,11,591],[11,592,11,607],[11,608,11,623],[11,624,11,639],[11,640,11,655],[11,496,11,511],[11,512,11,527],[11,528,11,543],[11,544,11,559],[11,560,11,575],[11,1056,11,1071],[11,1072,11,1087],[11,1088,11,1103],[11,1104,11,1119],[11,1120,11,1135],[11,976,11,991],[11,992,11,1007],[11,1008,11,1023],[11,1024,11,1039],[11,1040,11,1055],[11,896,11,911],[11,912,11,927],[11,928,11,943],[11,944,11,959],[11,960,11,975],[11,816,11,831],[11,832,11,847],[11,848,11,863],[11,864,11,879],[11,880,11,895],[11,1376,11,1391],[11,1392,11,1407],[11,1408,11,1423],[11,1424,11,1439],[11,1440,11,1455],[11,1296,11,1311],[11,1312,11,1327],[11,1328,11,1343],[11,1344,11,1359],[11,1360,11,1375],[11,1216,11,1231],[11,1232,11,1247],[11,1248,11,1263],[11,1264,11,1279],[11,1280,11,1295],[11,1136,11,1151],[11,1152,11,1167],[11,1168,11,1183],[11,1184,11,1199],[11,1200,11,1215],[11,1696,11,1711],[11,1712,11,1727],[11,1728,11,1743],[11,1744,11,1759],[11,1760,11,1775],[11,1616,11,1631],[11,1632,11,1647],[11,1648,11,1663],[11,1664,11,1679],[11,1680,11,1695],[11,1536,11,1551],[11,1552,11,1567],[11,1568,11,1583],[11,1584,11,1599],[11,1600,11,1615],[11,1456,11,1471],[11,1472,11,1487],[11,1488,11,1503],[11,1504,11,1519],[11,1520,11,1535],[11,2016,11,2031],[11,2032,11,2047],[11,2048,11,2063],[11,2064,11,2079],[11,2080,11,2095],[11,1936,11,1951],[11,1952,11,1967],[11,1968,11,1983],[11,1984,11,1999],[11,2000,11,2015],[11,1856,11,1871],[11,1872,11,1887],[11,1888,11,1903],[11,1904,11,1919],[11,1920,11,1935],[11,1776,11,1791],[11,1792,11,1807],[11,1808,11,1823],[11,1824,11,1839],[11,1840,11,1855],[11,2336,11,2351],[11,2352,11,2367],[11,2368,11,2383],[11,2384,11,2399],[11,2400,11,2415],[11,2256,11,2271],[11,2272,11,2287],[11,2288,11,2303],[11,2304,11,2319],[11,2320,11,2335],[11,2176,11,2191],[11,2192,11,2207],[11,2208,11,2223],[11,2224,11,2239],[11,2240,11,2255],[11,2096,11,2111],[11,2112,11,2127],[11,2128,11,2143],[11,2144,11,2159],[11,2160,11,2175],[11,2656,11,2671],[11,2672,11,2687],[11,2688,11,2703],[11,2704,11,2719],[11,2720,11,2735],[11,2576,11,2591],[11,2592,11,2607],[11,2608,11,2623],[11,2624,11,2639],[11,2640,11,2655],[11,2496,11,2511],[11,2512,11,2527],[11,2528,11,2543],[11,2544,11,2559],[11,2560,11,2575],[11,2416,11,2431],[11,2432,11,2447],[11,2448,11,2463],[11,2464,11,2479],[11,2480,11,2495],[11,2976,11,2991],[11,2992,11,3007],[11,3008,11,3023],[11,3024,11,3039],[11,3040,11,3055],[11,2896,11,2911],[11,2912,11,2927],[11,2928,11,2943],[11,2944,11,2959],[11,2960,11,2975],[11,2816,11,2831],[11,2832,11,2847],[11,2848,11,2863],[11,2864,11,2879],[11,2880,11,2895],[11,2736,11,2751],[11,2752,11,2767],[11,2768,11,2783],[11,2784,11,2799],[11,2800,11,2815],[11,3296,11,3311],[11,3312,11,3327],[11,3328,11,3343],[11,3344,11,3359],[11,3360,11,3375],[11,3216,11,3231],[11,3232,11,3247],[11,3248,11,3263],[11,3264,11,3279],[11,3280,11,3295],[11,3136,11,3151],[11,3152,11,3167],[11,3168,11,3183],[11,3184,11,3199],[11,3200,11,3215],[11,3056,11,3071],[11,3072,11,3087],[11,3088,11,3103],[11,3104,11,3119],[11,3120,11,3135],[11,3616,11,3631],[11,3632,11,3647],[11,3648,11,3663],[11,3664,11,3679],[11,3680,11,3695],[11,3536,11,3551],[11,3552,11,3567],[11,3568,11,3583],[11,3584,11,3599],[11,3600,11,3615],[11,3456,11,3471],[11,3472,11,3487],[11,3488,11,3503],[11,3504,11,3519],[11,3520,11,3535],[11,3376,11,3391],[11,3392,11,3407],[11,3408,11,3423],[11,3424,11,3439],[11,3440,11,3455],[11,3936,11,3951],[11,3952,11,3967],[11,3968,11,3983],[11,3984,11,3999],[11,4000,11,4015],[11,3856,11,3871],[11,3872,11,3887],[11,3888,11,3903],[11,3904,11,3919],[11,3920,11,3935],[11,3776,11,3791],[11,3792,11,3807],[11,3808,11,3823],[11,3824,11,3839],[11,3840,11,3855],[11,3696,11,3711],[11,3712,11,3727],[11,3728,11,3743],[11,3744,11,3759],[11,3760,11,3775],[11,4256,11,4271],[11,4272,11,4287],[11,4288,11,4303],[11,4304,11,4319],[11,4320,11,4335],[11,4176,11,4191],[11,4192,11,4207],[11,4208,11,4223],[11,4224,11,4239],[11,4240,11,4255],[11,4096,11,4111],[11,4112,11,4127],[11,4128,11,4143],[11,4144,11,4159],[11,4160,11,4175],[11,4016,11,4031],[11,4032,11,4047],[11,4048,11,4063],[11,4064,11,4079],[11,4080,11,4095],[11,4576,11,4591],[11,4592,11,4607],[11,4608,11,4623],[11,4624,11,4639],[11,4640,11,4655],[11,4496,11,4511],[11,4512,11,4527],[11,4528,11,4543],[11,4544,11,4559],[11,4560,11,4575],[11,4416,11,4431],[11,4432,11,4447],[11,4448,11,4463],[11,4464,11,4479],[11,4480,11,4495],[11,4336,11,4351],[11,4352,11,4367],[11,4368,11,4383],[11,4384,11,4399],[11,4400,11,4415],[11,4896,11,4911],[11,4912,11,4927],[11,4928,11,4943],[11,4944,11,4959],[11,4960,11,4975],[11,4816,11,4831],[11,4832,11,4847],[11,4848,11,4863],[11,4864,11,4879],[11,4880,11,4895],[11,4736,11,4751],[11,4752,11,4767],[11,4768,11,4783],[11,4784,11,4799],[11,4800,11,4815],[11,4656,11,4671],[11,4672,11,4687],[11,4688,11,4703],[11,4704,11,4719],[11,4720,11,4735],[11,5216,11,5231],[11,5232,11,5247],[11,5248,11,5263],[11,5264,11,5279],[11,5280,11,5295],[11,5136,11,5151],[11,5152,11,5167],[11,5168,11,5183],[11,5184,11,5199],[11,5200,11,5215],[11,5056,11,5071],[11,5072,11,5087],[11,5088,11,5103],[11,5104,11,5119],[11,5120,11,5135],[11,4976,11,4991],[11,4992,11,5007],[11,5008,11,5023],[11,5024,11,5039],[11,5040,11,5055],[11,5536,11,5551],[11,5552,11,5567],[11,5568,11,5583],[11,5584,11,5599],[11,5600,11,5615],[11,5456,11,5471],[11,5472,11,5487],[11,5488,11,5503],[11,5504,11,5519],[11,5520,11,5535],[11,5376,11,5391],[11,5392,11,5407],[11,5408,11,5423],[11,5424,11,5439],[11,5440,11,5455],[11,5296,11,5311],[11,5312,11,5327],[11,5328,11,5343],[11,5344,11,5359],[11,5360,11,5375],[11,5856,11,5871],[11,5872,11,5887],[11,5888,11,5903],[11,5904,11,5919],[11,5920,11,5935],[11,5776,11,5791],[11,5792,11,5807],[11,5808,11,5823],[11,5824,11,5839],[11,5840,11,5855],[11,5696,11,5711],[11,5712,11,5727],[11,5728,11,5743],[11,5744,11,5759],[11,5760,11,5775],[11,5616,11,5631],[11,5632,11,5647],[11,5648,11,5663],[11,5664,11,5679],[11,5680,11,5695],[11,6176,11,6191],[11,6192,11,6207],[11,6208,11,6223],[11,6224,11,6239],[11,6240,11,6255],[11,6096,11,6111],[11,6112,11,6127],[11,6128,11,6143],[11,6144,11,6159],[11,6160,11,6175],[11,6016,11,6031],[11,6032,11,6047],[11,6048,11,6063],[11,6064,11,6079],[11,6080,11,6095],[11,5936,11,5951],[11,5952,11,5967],[11,5968,11,5983],[11,5984,11,5999],[11,6000,11,6015],[11,6496,11,6511],[11,6512,11,6527],[11,6528,11,6543],[11,6544,11,6559],[11,6560,11,6575],[11,6416,11,6431],[11,6432,11,6447],[11,6448,11,6463],[11,6464,11,6479],[11,6480,11,6495],[11,6336,11,6351],[11,6352,11,6367],[11,6368,11,6383],[11,6384,11,6399],[11,6400,11,6415],[11,6256,11,6271],[11,6272,11,6287],[11,6288,11,6303],[11,6304,11,6319],[11,6320,11,6335],[11,6816,11,6831],[11,6832,11,6847],[11,6848,11,6863],[11,6864,11,6879],[11,6880,11,6895],[11,6736,11,6751],[11,6752,11,6767],[11,6768,11,6783],[11,6784,11,6799],[11,6800,11,6815],[11,6656,11,6671],[11,6672,11,6687],[11,6688,11,6703],[11,6704,11,6719],[11,6720,11,6735],[11,6576,11,6591],[11,6592,11,6607],[11,6608,11,6623],[11,6624,11,6639],[11,6640,11,6655],[11,7136,11,7151],[11,7152,11,7167],[11,7168,11,7183],[11,7184,11,7199],[11,7200,11,7215],[11,7056,11,7071],[11,7072,11,7087],[11,7088,11,7103],[11,7104,11,7119],[11,7120,11,7135],[11,6976,11,6991],[11,6992,11,7007],[11,7008,11,7023],[11,7024,11,7039],[11,7040,11,7055],[11,6896,11,6911],[11,6912,11,6927],[11,6928,11,6943],[11,6944,11,6959],[11,6960,11,6975],[11,7456,11,7471],[11,7472,11,7487],[11,7488,11,7503],[11,7504,11,7519],[11,7520,11,7535],[11,7376,11,7391],[11,7392,11,7407],[11,7408,11,7423],[11,7424,11,7439],[11,7440,11,7455],[11,7296,11,7311],[11,7312,11,7327],[11,7328,11,7343],[11,7344,11,7359],[11,7360,11,7375],[11,7216,11,7231],[11,7232,11,7247],[11,7248,11,7263],[11,7264,11,7279],[11,7280,11,7295],[11,7776,11,7791],[11,7792,11,7807],[11,7808,11,7823],[11,7824,11,7839],[11,7840,11,7855],[11,7696,11,7711],[11,7712,11,7727],[11,7728,11,7743],[11,7744,11,7759],[11,7760,11,7775],[11,7616,11,7631],[11,7632,11,7647],[11,7648,11,7663],[11,7664,11,7679],[11,7680,11,7695],[11,7536,11,7551],[11,7552,11,7567],[11,7568,11,7583],[11,7584,11,7599],[11,7600,11,7615],[11,8096,11,8111],[11,8112,11,8127],[11,8128,11,8143],[11,8144,11,8159],[11,8160,11,8175],[11,8016,11,8031],[11,8032,11,8047],[11,8048,11,8063],[11,8064,11,8079],[11,8080,11,8095],[11,7936,11,7951],[11,7952,11,7967],[11,7968,11,7983],[11,7984,11,7999],[11,8000,11,8015],[11,7856,11,7871],[11,7872,11,7887],[11,7888,11,7903],[11,7904,11,7919],[11,7920,11,7935],[11,8416,11,8431],[11,8432,11,8447],[11,8448,11,8463],[11,8464,11,8479],[11,8480,11,8495],[11,8336,11,8351],[11,8352,11,8367],[11,8368,11,8383],[11,8384,11,8399],[11,8400,11,8415],[11,8256,11,8271],[11,8272,11,8287],[11,8288,11,8303],[11,8304,11,8319],[11,8320,11,8335],[11,8176,11,8191],[11,8192,11,8207],[11,8208,11,8223],[11,8224,11,8239],[11,8240,11,8255],[11,8736,11,8751],[11,8752,11,8767],[11,8768,11,8783],[11,8784,11,8799],[11,8800,11,8815],[11,8656,11,8671],[11,8672,11,8687],[11,8688,11,8703],[11,8704,11,8719],[11,8720,11,8735],[11,8576,11,8591],[11,8592,11,8607],[11,8608,11,8623],[11,8624,11,8639],[11,8640,11,8655],[11,8496,11,8511],[11,8512,11,8527],[11,8528,11,8543],[11,8544,11,8559],[11,8560,11,8575],[11,9056,11,9071],[11,9072,11,9087],[11,9088,11,9103],[11,9104,11,9119],[11,9120,11,9135],[11,8976,11,8991],[11,8992,11,9007],[11,9008,11,9023],[11,9024,11,9039],[11,9040,11,9055],[11,8896,11,8911],[11,8912,11,8927],[11,8928,11,8943],[11,8944,11,8959],[11,8960,11,8975],[11,8816,11,8831],[11,8832,11,8847],[11,8848,11,8863],[11,8864,11,8879],[11,8880,11,8895],[11,9376,11,9391],[11,9392,11,9407],[11,9408,11,9423],[11,9424,11,9439],[11,9440,11,9455],[11,9296,11,9311],[11,9312,11,9327],[11,9328,11,9343],[11,9344,11,9359],[11,9360,11,9375],[11,9216,11,9231],[11,9232,11,9247],[11,9248,11,9263],[11,9264,11,9279],[11,9280,11,9295],[11,9136,11,9151],[11,9152,11,9167],[11,9168,11,9183],[11,9184,11,9199],[11,9200,11,9215],[11,9696,11,9711],[11,9712,11,9727],[11,9728,11,9743],[11,9744,11,9759],[11,9760,11,9775],[11,9616,11,9631],[11,9632,11,9647],[11,9648,11,9663],[11,9664,11,9679],[11,9680,11,9695],[11,9536,11,9551],[11,9552,11,9567],[11,9568,11,9583],[11,9584,11,9599],[11,9600,11,9615],[11,9456,11,9471],[11,9472,11,9487],[11,9488,11,9503],[11,9504,11,9519],[11,9520,11,9535],[11,10016,11,10031],[11,10032,11,10047],[11,10048,11,10063],[11,10064,11,10079],[11,10080,11,10095],[11,9936,11,9951],[11,9952,11,9967],[11,9968,11,9983],[11,9984,11,9999],[11,10000,11,10015],[11,9856,11,9871],[11,9872,11,9887],[11,9888,11,9903],[11,9904,11,9919],[11,9920,11,9935],[11,9776,11,9791],[11,9792,11,9807],[11,9808,11,9823],[11,9824,11,9839],[11,9840,11,9855],[11,10336,11,10351],[11,10352,11,10367],[11,10368,11,10383],[11,10384,11,10399],[11,10400,11,10415],[11,10256,11,10271],[11,10272,11,10287],[11,10288,11,10303],[11,10304,11,10319],[11,10320,11,10335],[11,10176,11,10191],[11,10192,11,10207],[11,10208,11,10223],[11,10224,11,10239],[11,10240,11,10255],[11,10096,11,10111],[11,10112,11,10127],[11,10128,11,10143],[11,10144,11,10159],[11,10160,11,10175],[11,10656,11,10671],[11,10672,11,10687],[11,10688,11,10703],[11,10704,11,10719],[11,10720,11,10735],[11,10576,11,10591],[11,10592,11,10607],[11,10608,11,10623],[11,10624,11,10639],[11,10640,11,10655],[11,10496,11,10511],[11,10512,11,10527],[11,10528,11,10543],[11,10544,11,10559],[11,10560,11,10575],[11,10416,11,10431],[11,10432,11,10447],[11,10448,11,10463],[11,10464,11,10479],[11,10480,11,10495],[11,10976,11,10991],[11,10992,11,11007],[11,11008,11,11023],[11,11024,11,11039],[11,11040,11,11055],[11,10896,11,10911],[11,10912,11,10927],[11,10928,11,10943],[11,10944,11,10959],[11,10960,11,10975],[11,10816,11,10831],[11,10832,11,10847],[11,10848,11,10863],[11,10864,11,10879],[11,10880,11,10895],[11,10736,11,10751],[11,10752,11,10767],[11,10768,11,10783],[11,10784,11,10799],[11,10800,11,10815],[11,11296,11,11311],[11,11312,11,11327],[11,11328,11,11343],[11,11344,11,11359],[11,11360,11,11375],[11,11216,11,11231],[11,11232,11,11247],[11,11248,11,11263],[11,11264,11,11279],[11,11280,11,11295],[11,11136,11,11151],[11,11152,11,11167],[11,11168,11,11183],[11,11184,11,11199],[11,11200,11,11215],[11,11056,11,11071],[11,11072,11,11087],[11,11088,11,11103],[11,11104,11,11119],[11,11120,11,11135],[11,11616,11,11631],[11,11632,11,11647],[11,11648,11,11663],[11,11664,11,11679],[11,11680,11,11695],[11,11536,11,11551],[11,11552,11,11567],[11,11568,11,11583],[11,11584,11,11599],[11,11600,11,11615],[11,11456,11,11471],[11,11472,11,11487],[11,11488,11,11503],[11,11504,11,11519],[11,11520,11,11535],[11,11376,11,11391],[11,11392,11,11407],[11,11408,11,11423],[11,11424,11,11439],[11,11440,11,11455],[11,11936,11,11951],[11,11952,11,11967],[11,11968,11,11983],[11,11984,11,11999],[11,12000,11,12015],[11,11856,11,11871],[11,11872,11,11887],[11,11888,11,11903],[11,11904,11,11919],[11,11920,11,11935],[11,11776,11,11791],[11,11792,11,11807],[11,11808,11,11823],[11,11824,11,11839],[11,11840,11,11855],[11,11696,11,11711],[11,11712,11,11727],[11,11728,11,11743],[11,11744,11,11759],[11,11760,11,11775],[11,12256,11,12271],[11,12272,11,12287],[11,12288,11,12303],[11,12304,11,12319],[11,12320,11,12335],[11,12176,11,12191],[11,12192,11,12207],[11,12208,11,12223],[11,12224,11,12239],[11,12240,11,12255],[11,12096,11,12111],[11,12112,11,12127],[11,12128,11,12143],[11,12144,11,12159],[11,12160,11,12175],[11,12016,11,12031],[11,12032,11,12047],[11,12048,11,12063],[11,12064,11,12079],[11,12080,11,12095],[11,12576,11,12591],[11,12592,11,12607],[11,12608,11,12623],[11,12624,11,12639],[11,12640,11,12655],[11,12496,11,12511],[11,12512,11,12527],[11,12528,11,12543],[11,12544,11,12559],[11,12560,11,12575],[11,12416,11,12431],[11,12432,11,12447],[11,12448,11,12463],[11,12464,11,12479],[11,12480,11,12495],[11,12336,11,12351],[11,12352,11,12367],[11,12368,11,12383],[11,12384,11,12399],[11,12400,11,12415],[11,12896,11,12911],[11,12912,11,12927],[11,12928,11,12943],[11,12944,11,12959],[11,12960,11,12975],[11,12816,11,12831],[11,12832,11,12847],[11,12848,11,12863],[11,12864,11,12879],[11,12880,11,12895],[11,12736,11,12751],[11,12752,11,12767],[11,12768,11,12783],[11,12784,11,12799],[11,12800,11,12815],[11,12656,11,12671],[11,12672,11,12687],[11,12688,11,12703],[11,12704,11,12719],[11,12720,11,12735],[11,13216,11,13231],[11,13232,11,13247],[11,13248,11,13263],[11,13264,11,13279],[11,13280,11,13295],[11,13136,11,13151],[11,13152,11,13167],[11,13168,11,13183],[11,13184,11,13199],[11,13200,11,13215],[11,13056,11,13071],[11,13072,11,13087],[11,13088,11,13103],[11,13104,11,13119],[11,13120,11,13135],[11,12976,11,12991],[11,12992,11,13007],[11,13008,11,13023],[11,13024,11,13039],[11,13040,11,13055],[11,13536,11,13551],[11,13552,11,13567],[11,13568,11,13583],[11,13584,11,13599],[11,13600,11,13615],[11,13456,11,13471],[11,13472,11,13487],[11,13488,11,13503],[11,13504,11,13519],[11,13520,11,13535],[11,13376,11,13391],[11,13392,11,13407],[11,13408,11,13423],[11,13424,11,13439],[11,13440,11,13455],[11,13296,11,13311],[11,13312,11,13327],[11,13328,11,13343],[11,13344,11,13359],[11,13360,11,13375],[11,13856,11,13871],[11,13872,11,13887],[11,13888,11,13903],[11,13904,11,13919],[11,13920,11,13935],[11,13776,11,13791],[11,13792,11,13807],[11,13808,11,13823],[11,13824,11,13839],[11,13840,11,13855],[11,13696,11,13711],[11,13712,11,13727],[11,13728,11,13743],[11,13744,11,13759],[11,13760,11,13775],[11,13616,11,13631],[11,13632,11,13647],[11,13648,11,13663],[11,13664,11,13679],[11,13680,11,13695],[11,14176,11,14191],[11,14192,11,14207],[11,14208,11,14223],[11,14224,11,14239],[11,14240,11,14255],[11,14096,11,14111],[11,14112,11,14127],[11,14128,11,14143],[11,14144,11,14159],[11,14160,11,14175],[11,14016,11,14031],[11,14032,11,14047],[11,14048,11,14063],[11,14064,11,14079],[11,14080,11,14095],[11,13936,11,13951],[11,13952,11,13967],[11,13968,11,13983],[11,13984,11,13999],[11,14000,11,14015],[11,14496,11,14511],[11,14512,11,14527],[11,14528,11,14543],[11,14544,11,14559],[11,14560,11,14575],[11,14416,11,14431],[11,14432,11,14447],[11,14448,11,14463],[11,14464,11,14479],[11,14480,11,14495],[11,14336,11,14351],[11,14352,11,14367],[11,14368,11,14383],[11,14384,11,14399],[11,14400,11,14415],[11,14256,11,14271],[11,14272,11,14287],[11,14288,11,14303],[11,14304,11,14319],[11,14320,11,14335],[11,14816,11,14831],[11,14832,11,14847],[11,14848,11,14863],[11,14864,11,14879],[11,14880,11,14895],[11,14736,11,14751],[11,14752,11,14767],[11,14768,11,14783],[11,14784,11,14799],[11,14800,11,14815],[11,14656,11,14671],[11,14672,11,14687],[11,14688,11,14703],[11,14704,11,14719],[11,14720,11,14735],[11,14576,11,14591],[11,14592,11,14607],[11,14608,11,14623],[11,14624,11,14639],[11,14640,11,14655],[11,15136,11,15151],[11,15152,11,15167],[11,15168,11,15183],[11,15184,11,15199],[11,15200,11,15215],[11,15056,11,15071],[11,15072,11,15087],[11,15088,11,15103],[11,15104,11,15119],[11,15120,11,15135],[11,14976,11,14991],[11,14992,11,15007],[11,15008,11,15023],[11,15024,11,15039],[11,15040,11,15055],[11,14896,11,14911],[11,14912,11,14927],[11,14928,11,14943],[11,14944,11,14959],[11,14960,11,14975],[11,15456,11,15471],[11,15472,11,15487],[11,15488,11,15503],[11,15504,11,15519],[11,15520,11,15535],[11,15376,11,15391],[11,15392,11,15407],[11,15408,11,15423],[11,15424,11,15439],[11,15440,11,15455],[11,15296,11,15311],[11,15312,11,15327],[11,15328,11,15343],[11,15344,11,15359],[11,15360,11,15375],[11,15216,11,15231],[11,15232,11,15247],[11,15248,11,15263],[11,15264,11,15279],[11,15280,11,15295],[11,15776,11,15791],[11,15792,11,15807],[11,15808,11,15823],[11,15824,11,15839],[11,15840,11,15855],[11,15696,11,15711],[11,15712,11,15727],[11,15728,11,15743]],"merged_total":4111,"flags":["merged_cut"]}
["Feuille de calcul efficacité énergétique (dispositif PEEP 2023)"]
[null,"Entreprise:",{"$f":"Informations!C3","v":0},null,null,null,null,"Ville:",{"$f":"Informations!C40","v":0}]
[null,"Projet:",{"$f":"Informations!C9","v":0},null,null,null,null,null,null,null,null,"CP:",{"$f":"Informations!I40","v":0}]
[]
["Données d'instruction A RENSEIGNER"]
[null,"Instructeur:","Pascal","Année dispositif:",2023,null,"Date passage en CP:","2023-05-26"]
[]
[null,null,"Type entreprise:","Petite entreprise"]
[null,null,"Taux:",0.4,null,null,null,"Soit un taux appliqué de:",{"$f":"D9+D10","v":0.4}]
[null,null,"Valeur du bonus (%):",0]
[]
["Investissements et calcul des consommations"]
[]
["N°","Investissement","Montant investissement (€ HT)","Montant solution de référence\n(€ HT)","Montant CEE\n(€)","Montant éligible avec CEE\n(€ HT)","Consommation annuelle initiale (MWh/an)","Consommation annuelle après investissement (MWh/an)","Gain de consommation toutes énergies (MWh/an)","MWhcumac (CEE)","Type énergie AVANT","Type énergie APRES","Type d'investissement","Cout de l'énergie AVANT (€/MWh)","Cout de l'énergie APRES (€/MWh)","Gain annuel (€/an)","Tonnes CO2 non émises\n(t/an)"]
[{"$f":"Investissements!A25","v":1},{"$f":"IF(Investissements!B25<>\"\",Investissements!B25,\"\")","v":""},{"$f":"IF(Investissements!D25<>\"\",Investissements!D25,\"\")","v":""},{"$f":"IF(Investissements!L25<>\"\",Investissements!L25,\"\")","v":""},{"$f":"IF(Investissements!J25<>\"\",Investissements!J25,\"\")","v":""},{"$f":"IF(C15<>\"\",C15-D15-E15,\"\")","v":""},{"$f":"IF(Investissements!D40<>\"\",Investissements!D40,\"\")","v":""},{"$f":"IF(Investissements!I40<>\"\",Investissements!I40,\"\")","v":""},{"$f":"IF(G15<>\"\",G15-H15,\"\")","v":""},{"$f":"IF(Investissements!P40<>\"\",Investissements!P40,\"\")","v":""},{"$f":"IF(Investissements!G40<>\"\",Investissements!G40,\"\")","v":""},{"$f":"IF(Investissements!M40<>\"\",Investissements!M40,\"\")","v":""},{"$f":"IF(Investissements!H25<>\"\",Investissements!H25,\"\")","v":""},{"$f":"IF(K15<>\"\",VLOOKUP(K15,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L15<>\"\",VLOOKUP(L15,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(I15<>\"\",G15*N15-H15*O15,\"\")","v":""},{"$f":"IF(I15<>\"\",VLOOKUP(K15,Paramètres!$B$5:$D$17,3,FALSE)*G15-VLOOKUP(L15,Paramètres!$B$5:$D$17,3,FALSE)*H15,\"\")","v":""}]
[{"$f":"Investissements!A26","v":2},{"$f":"IF(Investissements!B26<>\"\",Investissements!B26,\"\")","v":""},{"$f":"IF(Investissements!D26<>\"\",Investissements!D26,\"\")","v":""},{"$f":"IF(Investissements!L26<>\"\",Investissements!L26,\"\")","v":""},{"$f":"IF(Investissements!J26<>\"\",Investissements!J26,\"\")","v":""},"",{"$f":"IF(Investissements!D41<>\"\",Investissements!D41,\"\")","v":""},{"$f":"IF(Investissements!I41<>\"\",Investissements!I41,\"\")","v":""},{"$f":"IF(G16<>\"\",G16-H16,\"\")","v":""},{"$f":"IF(Investissements!P41<>\"\",Investissements!P41,\"\")","v":""},{"$f":"IF(Investissements!G41<>\"\",Investissements!G41,\"\")","v":""},{"$f":"IF(Investissements!M41<>\"\",Investissements!M41,\"\")","v":""},{"$f":"IF(Investissements!H26<>\"\",Investissements!H26,\"\")","v":""},{"$f":"IF(K16<>\"\",VLOOKUP(K16,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L16<>\"\",VLOOKUP(L16,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(I16<>\"\",G16*N16-H16*O16,\"\")","v":""},{"$f":"IF(I16<>\"\",VLOOKUP(K16,Paramètres!$B$5:$D$17,3,FALSE)*G16-VLOOKUP(L16,Paramètres!$B$5:$D$17,3,FALSE)*H16,\"\")","v":""}]
[{"$f":"Investissements!A27","v":3},{"$f":"IF(Investissements!B27<>\"\",Investissements!B27,\"\")","v":""},{"$f":"IF(Investissements!D27<>\"\",Investissements!D27,\"\")","v":""},{"$f":"IF(Investissements!L27<>\"\",Investissements!L27,\"\")","v":""},{"$f":"IF(Investissements!J27<>\"\",Investissements!J27,\"\")","v":""},"",{"$f":"IF(Investissements!D42<>\"\",Investissements!D42,\"\")","v":""},{"$f":"IF(Investissements!I42<>\"\",Investissements!I42,\"\")","v":""},"",{"$f":"IF(Investissements!P42<>\"\",Investissements!P42,\"\")","v":""},{"$f":"IF(Investissements!G42<>\"\",Investissements!G42,\"\")","v":""},{"$f":"IF(Investissements!M42<>\"\",Investissements!M42,\"\")","v":""},{"$f":"IF(Investissements!H27<>\"\",Investissements!H27,\"\")","v":""},{"$f":"IF(K17<>\"\",VLOOKUP(K17,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L17<>\"\",VLOOKUP(L17,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},"",{"$f":"IF(I17<>\"\",VLOOKUP(K17,Paramètres!$B$5:$D$17,3,FALSE)*G17-VLOOKUP(L17,Paramètres!$B$5:$D$17,3,FALSE)*H17,\"\")","v":""}]
[{"$f":"Investissements!A28","v":4},{"$f":"IF(Investissements!B28<>\"\",Investissements!B28,\"\")","v":""},{"$f":"IF(Investissements!D28<>\"\",Investissements!D28,\"\")","v":""},{"$f":"IF(Investissements!L28<>\"\",Investissements!L28,\"\")","v":""},{"$f":"IF(Investissements!J28<>\"\",Investissements!J28,\"\")","v":""},"",{"$f":"IF(Investissements!D43<>\"\",Investissements!D43,\"\")","v":""},{"$f":"IF(Investissements!I43<>\"\",Investissements!I43,\"\")","v":""},"",{"$f":"IF(Investissements!P43<>\"\",Investissements!P43,\"\")","v":""},{"$f":"IF(Investissements!G43<>\"\",Investissements!G43,\"\")","v":""},{"$f":"IF(Investissements!M43<>\"\",Investissements!M43,\"\")","v":""},{"$f":"IF(Investissements!H28<>\"\",Investissements!H28,\"\")","v":""},{"$f":"IF(K18<>\"\",VLOOKUP(K18,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L18<>\"\",VLOOKUP(L18,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},"",{"$f":"IF(I18<>\"\",VLOOKUP(K18,Paramètres!$B$5:$D$17,3,FALSE)*G18-VLOOKUP(L18,Paramètres!$B$5:$D$17,3,FALSE)*H18,\"\")","v":""}]
[{"$f":"Investissements!A29","v":5},{"$f":"IF(Investissements!B29<>\"\",Investissements!B29,\"\")","v":""},{"$f":"IF(Investissements!D29<>\"\",Investissements!D29,\"\")","v":""},{"$f":"IF(Investissements!L29<>\"\",Investissements!L29,\"\")","v":""},{"$f":"IF(Investissements!J29<>\"\",Investissements!J29,\"\")","v":""},"",{"$f":"IF(Investissements!D44<>\"\",Investissements!D44,\"\")","v":""},{"$f":"IF(Investissements!I44<>\"\",Investissements!I44,\"\")","v":""},"",{"$f":"IF(Investissements!P44<>\"\",Investissements!P44,\"\")","v":""},{"$f":"IF(Investissements!G44<>\"\",Investissements!G44,\"\")","v":""},{"$f":"IF(Investissements!M44<>\"\",Investissements!M44,\"\")","v":""},{"$f":"IF(Investissements!H29<>\"\",Investissements!H29,\"\")","v":""},{"$f":"IF(K19<>\"\",VLOOKUP(K19,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L19<>\"\",VLOOKUP(L19,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},"",{"$f":"IF(I19<>\"\",VLOOKUP(K19,Paramètres!$B$5:$D$17,3,FALSE)*G19-VLOOKUP(L19,Paramètres!$B$5:$D$17,3,FALSE)*H19,\"\")","v":""}]
[{"$f":"Investissements!A30","v":6},{"$f":"IF(Investissements!B30<>\"\",Investissements!B30,\"\")","v":""},{"$f":"IF(Investissements!D30<>\"\",Investissements!D30,\"\")","v":""},{"$f":"IF(Investissements!L30<>\"\",Investissements!L30,\"\")","v":""},{"$f":"IF(Investissements!J30<>\"\",Investissements!J30,\"\")","v":""},"",{"$f":"IF(Investissements!D45<>\"\",Investissements!D45,\"\")","v":""},{"$f":"IF(Investissements!I45<>\"\",Investissements!I45,\"\")","v":""},"",{"$f":"IF(Investissements!P45<>\"\",Investissements!P45,\"\")","v":""},{"$f":"IF(Investissements!G45<>\"\",Investissements!G45,\"\")","v":""},{"$f":"IF(Investissements!M45<>\"\",Investissements!M45,\"\")","v":""},{"$f":"IF(Investissements!H30<>\"\",Investissements!H30,\"\")","v":""},{"$f":"IF(K20<>\"\",VLOOKUP(K20,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L20<>\"\",VLOOKUP(L20,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},"",{"$f":"IF(I20<>\"\",VLOOKUP(K20,Paramètres!$B$5:$D$17,3,FALSE)*G20-VLOOKUP(L20,Paramètres!$B$5:$D$17,3,FALSE)*H20,\"\")","v":""}]
[{"$f":"Investissements!A31","v":7},{"$f":"IF(Investissements!B31<>\"\",Investissements!B31,\"\")","v":""},{"$f":"IF(Investissements!D31<>\"\",Investissements!D31,\"\")","v":""},{"$f":"IF(Investissements!L31<>\"\",Investissements!L31,\"\")","v":""},{"$f":"IF(Investissements!J31<>\"\",Investissements!J31,\"\")","v":""},"",{"$f":"IF(Investissements!D46<>\"\",Investissements!D46,\"\")","v":""},{"$f":"IF(Investissements!I46<>\"\",Investissements!I46,\"\")","v":""},"",{"$f":"IF(Investissements!P46<>\"\",Investissements!P46,\"\")","v":""},{"$f":"IF(Investissements!G46<>\"\",Investissements!G46,\"\")","v":""},{"$f":"IF(Investissements!M46<>\"\",Investissements!M46,\"\")","v":""},{"$f":"IF(Investissements!H31<>\"\",Investissements!H31,\"\")","v":""},{"$f":"IF(K21<>\"\",VLOOKUP(K21,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L21<>\"\",VLOOKUP(L21,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},"",{"$f":"IF(I21<>\"\",VLOOKUP(K21,Paramètres!$B$5:$D$17,3,FALSE)*G21-VLOOKUP(L21,Paramètres!$B$5:$D$17,3,FALSE)*H21,\"\")","v":""}]
[{"$f":"Investissements!A32","v":8},{"$f":"IF(Investissements!B32<>\"\",Investissements!B32,\"\")","v":""},{"$f":"IF(Investissements!D32<>\"\",Investissements!D32,\"\")","v":""},{"$f":"IF(Investissements!L32<>\"\",Investissements!L32,\"\")","v":""},{"$f":"IF(Investissements!J32<>\"\",Investissements!J32,\"\")","v":""},"",{"$f":"IF(Investissements!D47<>\"\",Investissements!D47,\"\")","v":""},{"$f":"IF(Investissements!I47<>\"\",Investissements!I47,\"\")","v":""},"",{"$f":"IF(Investissements!P47<>\"\",Investissements!P47,\"\")","v":""},{"$f":"IF(Investissements!G47<>\"\",Investissements!G47,\"\")","v":""},{"$f":"IF(Investissements!M47<>\"\",Investissements!M47,\"\")","v":""},{"$f":"IF(Investissements!H32<>\"\",Investissements!H32,\"\")","v":""},{"$f":"IF(K22<>\"\",VLOOKUP(K22,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L22<>\"\",VLOOKUP(L22,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},"",{"$f":"IF(I22<>\"\",VLOOKUP(K22,Paramètres!$B$5:$D$17,3,FALSE)*G22-VLOOKUP(L22,Paramètres!$B$5:$D$17,3,FALSE)*H22,\"\")","v":""}]
[{"$f":"Investissements!A33","v":9},{"$f":"IF(Investissements!B33<>\"\",Investissements!B33,\"\")","v":""},{"$f":"IF(Investissements!D33<>\"\",Investissements!D33,\"\")","v":""},{"$f":"IF(Investissements!L33<>\"\",Investissements!L33,\"\")","v":""},{"$f":"IF(Investissements!J33<>\"\",Investissements!J33,\"\")","v":""},"",{"$f":"IF(Investissements!D48<>\"\",Investissements!D48,\"\")","v":""},{"$f":"IF(Investissements!I48<>\"\",Investissements!I48,\"\")","v":""},"",{"$f":"IF(Investissements!P48<>\"\",Investissements!P48,\"\")","v":""},{"$f":"IF(Investissements!G48<>\"\",Investissements!G48,\"\")","v":""},{"$f":"IF(Investissements!M48<>\"\",Investissements!M48,\"\")","v":""},{"$f":"IF(Investissements!H33<>\"\",Investissements!H33,\"\")","v":""},{"$f":"IF(K23<>\"\",VLOOKUP(K23,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L23<>\"\",VLOOKUP(L23,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},"",{"$f":"IF(I23<>\"\",VLOOKUP(K23,Paramètres!$B$5:$D$17,3,FALSE)*G23-VLOOKUP(L23,Paramètres!$B$5:$D$17,3,FALSE)*H23,\"\")","v":""}]
[{"$f":"Investissements!A34","v":10},{"$f":"IF(Investissements!B34<>\"\",Investissements!B34,\"\")","v":""},{"$f":"IF(Investissements!D34<>\"\",Investissements!D34,\"\")","v":""},{"$f":"IF(Investissements!L34<>\"\",Investissements!L34,\"\")","v":""},{"$f":"IF(Investissements!J34<>\"\",Investissements!J34,\"\")","v":""},"",{"$f":"IF(Investissements!D49<>\"\",Investissements!D49,\"\")","v":""},{"$f":"IF(Investissements!I49<>\"\",Investissements!I49,\"\")","v":""},"",{"$f":"IF(Investissements!P49<>\"\",Investissements!P49,\"\")","v":""},{"$f":"IF(Investissements!G49<>\"\",Investissements!G49,\"\")","v":""},{"$f":"IF(Investissements!M49<>\"\",Investissements!M49,\"\")","v":""},{"$f":"IF(Investissements!H34<>\"\",Investissements!H34,\"\")","v":""},{"$f":"IF(K24<>\"\",VLOOKUP(K24,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},{"$f":"IF(L24<>\"\",VLOOKUP(L24,Paramètres!$B$5:$C$11,2,FALSE),\"\")","v":""},"",{"$f":"IF(I24<>\"\",VLOOKUP(K24,Paramètres!$B$5:$D$17,3,FALSE)*G24-VLOOKUP(L24,Paramètres!$B$5:$D$17,3,FALSE)*H24,\"\")","v":""}]
[null,"Total",{"$f":"SUM(C15:C24)","v":0},0,0,0,0,0,{"$f":"SUM(I15:I24)","v":0},0,null,null,null,null,null,{"$f":"SUM(P15:P24)","v":0},{"$f":"SUM(Q15:Q24)","v":0}]
[]
["Calcul de la subvention"]
[]
["N°","Investissement","Retenu ?","Investissement\n(€ HT)","Investissement de Référence\n(€ HT)","Valeur CEE (€)","CEE retenus ?","Base éligible\n(€ HT)","Taux d’aide maxi\n(%)","Subvention max possible\n(€)","Type énergie AVANT investissement","Gain de consommation sur l'énergie initiale (MWh/an)","Gain annuel (€/an)","Temps de retour sans aide (ans)","Temps de retour avec aide (ans)","Subvention avec plafond\n(€)","INFO: temps de retour EE sur investissement sans aide (ans)"]
[{"$f":"A15","v":1},{"$f":"IF(Investissements!B25<>\"\",Investissements!B25,\"\")","v":""},"Oui",{"$f":"IF(C30=\"Oui\",C15,\"\")","v":""},{"$f":"IF(C30=\"Oui\",D15,\"\")","v":""},{"$f":"IF(C30=\"Oui\",IF(J15<>\"\",Investissements!J25,\"\"),\"\")","v":""},"Oui",{"$f":"IF(C30=\"Oui\",IF(G30=\"OUI\",D30-E30-F30,D30-E30),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C30=\"Oui\",$I$9,\"\")","v":0.4},{"$f":"IF(C30=\"Oui\",H30*I30,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C30=\"OUI\",IF(K15<>\"\",K15,\"\"),\"\")","v":""},{"$f":"IF(C30=\"OUI\",Gain_Energie(K15,L15,G15,H15),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C30=\"Oui\",IF(P15<>\"\",P15,\"\"),\"\")","v":""},{"$f":"IF(C30=\"Oui\",IF(M30<>\"\",H30/M30,\"\"),\"\")","v":""},{"$f":"IF(C30=\"Oui\",IF(M30<>\"\",(H30-J30)/M30,\"\"),\"\")","v":""},{"$f":"IF(J30<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J30),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C30=\"Oui\",IF(M30<>\"\",(D30-F30)/M30,\"\"),\"\")","v":""}]
[2,{"$f":"IF(Investissements!B26<>\"\",Investissements!B26,\"\")","v":""},"Oui",{"$f":"IF(C31=\"Oui\",C16,\"\")","v":""},"",{"$f":"IF(C31=\"Oui\",IF(J16<>\"\",Investissements!J26,\"\"),\"\")","v":""},"Oui",{"$f":"IF(C31=\"Oui\",IF(G31=\"OUI\",D31-E31-F31,D31-E31),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C31=\"Oui\",$I$9,\"\")","v":0.4},{"$f":"IF(C31=\"Oui\",H31*I31,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C31=\"OUI\",IF(K16<>\"\",K16,\"\"),\"\")","v":""},{"$f":"IF(C31=\"OUI\",Gain_Energie(K16,L16,G16,H16),\"\")","v":{"$error":"#VALUE!"}},"",{"$f":"IF(C31=\"Oui\",IF(M31<>\"\",H31/M31,\"\"),\"\")","v":""},{"$f":"IF(C31=\"Oui\",IF(M31<>\"\",(H31-J31)/M31,\"\"),\"\")","v":""},{"$f":"IF(J31<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J31),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C31=\"Oui\",IF(M31<>\"\",(D31-F31)/M31,\"\"),\"\")","v":""}]
[3,{"$f":"IF(Investissements!B27<>\"\",Investissements!B27,\"\")","v":""},"Oui","","",{"$f":"IF(C32=\"Oui\",IF(J17<>\"\",Investissements!J27,\"\"),\"\")","v":""},"Non",{"$error":"#VALUE!"},0.4,{"$error":"#VALUE!"},"",{"$f":"IF(C32=\"OUI\",Gain_Energie(K17,L17,G17,H17),\"\")","v":{"$error":"#VALUE!"}},"","","",{"$f":"IF(J32<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J32),\"\")","v":{"$error":"#VALUE!"}},""]
[4,{"$f":"IF(Investissements!B28<>\"\",Investissements!B28,\"\")","v":""},"Oui","","",{"$f":"IF(C33=\"Oui\",IF(J18<>\"\",Investissements!J28,\"\"),\"\")","v":""},"Oui",{"$error":"#VALUE!"},0.4,{"$error":"#VALUE!"},"",{"$f":"IF(C33=\"OUI\",Gain_Energie(K18,L18,G18,H18),\"\")","v":{"$error":"#VALUE!"}},"","","",{"$f":"IF(J33<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J33),\"\")","v":{"$error":"#VALUE!"}},""]
[5,{"$f":"IF(Investissements!B29<>\"\",Investissements!B29,\"\")","v":""},"Oui","","",{"$f":"IF(C34=\"Oui\",IF(J19<>\"\",Investissements!J29,\"\"),\"\")","v":""},"Non",{"$error":"#VALUE!"},0.4,{"$error":"#VALUE!"},"",{"$f":"IF(C34=\"OUI\",Gain_Energie(K19,L19,G19,H19),\"\")","v":{"$error":"#VALUE!"}},"","","",{"$f":"IF(J34<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J34),\"\")","v":{"$error":"#VALUE!"}},""]
[6,{"$f":"IF(Investissements!B30<>\"\",Investissements!B30,\"\")","v":""},"Oui","","",{"$f":"IF(C35=\"Oui\",IF(J20<>\"\",Investissements!J30,\"\"),\"\")","v":""},"Oui",{"$error":"#VALUE!"},0.4,{"$error":"#VALUE!"},"",{"$f":"IF(C35=\"OUI\",Gain_Energie(K20,L20,G20,H20),\"\")","v":{"$error":"#VALUE!"}},"","","",{"$f":"IF(J35<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J35),\"\")","v":{"$error":"#VALUE!"}},""]
[7,{"$f":"IF(Investissements!B31<>\"\",Investissements!B31,\"\")","v":""},"Oui","","",{"$f":"IF(C36=\"Oui\",IF(J21<>\"\",Investissements!J31,\"\"),\"\")","v":""},"Oui",{"$error":"#VALUE!"},0.4,{"$error":"#VALUE!"},"",{"$f":"IF(C36=\"OUI\",Gain_Energie(K21,L21,G21,H21),\"\")","v":{"$error":"#VALUE!"}},"","","",{"$f":"IF(J36<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J36),\"\")","v":{"$error":"#VALUE!"}},""]
[8,{"$f":"IF(Investissements!B32<>\"\",Investissements!B32,\"\")","v":""},"Non","","",{"$f":"IF(C37=\"Oui\",IF(J22<>\"\",Investissements!J32,\"\"),\"\")","v":""},"Non","","","","",{"$f":"IF(C37=\"OUI\",Gain_Energie(K22,L22,G22,H22),\"\")","v":""},"","","",{"$f":"IF(J37<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J37),\"\")","v":""},""]
[9,{"$f":"IF(Investissements!B33<>\"\",Investissements!B33,\"\")","v":""},"Oui","","",{"$f":"IF(C38=\"Oui\",IF(J23<>\"\",Investissements!J33,\"\"),\"\")","v":""},"Oui",{"$error":"#VALUE!"},0.4,{"$error":"#VALUE!"},"",{"$f":"IF(C38=\"OUI\",Gain_Energie(K23,L23,G23,H23),\"\")","v":{"$error":"#VALUE!"}},"","","",{"$f":"IF(J38<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J38),\"\")","v":{"$error":"#VALUE!"}},""]
[10,{"$f":"IF(Investissements!B34<>\"\",Investissements!B34,\"\")","v":""},"Non","","",{"$f":"IF(C39=\"Oui\",IF(J24<>\"\",Investissements!J34,\"\"),\"\")","v":""},"Non","","","","",{"$f":"IF(C39=\"OUI\",Gain_Energie(K24,L24,G24,H24),\"\")","v":""},"","","",{"$f":"IF(J39<>\"\",Sub_plaf(Paramètres!$B$40,Calculs!J39),\"\")","v":""},""]
[null,"Total éligible",null,{"$f":"SUM(D30:D39)","v":0},{"$f":"SUM(E30:E39)","v":0},{"$f":"SUM(F30:F39)","v":0},null,{"$f":"SUM(H30:H39)","v":{"$error":"#VALUE!"}},{"$f":"$I$9","v":0.4},{"$f":"SUM(J30:J39)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(L30:L39)","v":{"$error":"#VALUE!"}},{"$f":"SUM(M30:M39)","v":0},{"$f":"H40/M40","v":{"$error":"#VALUE!"}},{"$f":"(H40-P40)/M40","v":{"$error":"#VALUE!"}},{"$f":"Sub_plaf(Paramètres!$B$40,Calculs!J40)","v":{"$error":"#VALUE!"}},{"$f":"(D40-F40)/M40","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subvention plafonnée"]
[null,{"$f":"\"L'aide régionale représente \" & I40*100 & \" % de la dépense éligible de \" & H40 & \" €, soit \" & P40 & \" € (subvention plafonnée à \" & Paramètres!$B$40 & \" €)\"","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"% aide réel: ",{"$f":"P40/H40","v":{"$error":"#VALUE!"}}]
[]
["Calcul de l'éligibilité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Calcul que sur les investissements éligibles"]
[null,"Type d'énergie",null,"Consommation d’énergie site\n(MWh/an)","Diminution prévisionnelle énergie site  (MWh/an)","% baisse annoncée","Diminution énergie basée sur les investissements (MWh/an)","% baisse basée sur les investissements","Eligible ?",null,null,null,null,"Consommation d’énergie site\n(MWh/an)","Diminution énergie basée sur les investissements (MWh/an)","% baisse basée sur les investissements"]
[null,"Electricité",null,{"$f":"IF(Investissements!F7<>\"\",Investissements!F7,\"\")","v":""},{"$f":"IF(Investissements!J7<>\"\",Investissements!J7,\"\")","v":""},{"$f":"IF(D47<>\"\",E47/D47,\"\")","v":""},{"$f":"IF(SUMIFS($L$30:$L$39,$K$30:$K$39,B47)<>0,SUMIFS($L$30:$L$39,$K$30:$K$39,B47),\"\")","v":""},{"$f":"IF(G47<>\"\",G47/D47,\"\")","v":""},{"$f":"IF(H47<>\"\",Eligible(Paramètres!$B$36,Calculs!H47),\"\")","v":""},null,null,null,null,{"$f":"IF(I47=\"OUI\",D47,\"\")","v":""},{"$f":"IF(I47=\"OUI\",G47,\"\")","v":""},{"$f":"IF(I47=\"OUI\",O47/N47,\"\")","v":""}]
[null,"Gaz",null,{"$f":"IF(Investissements!F8<>\"\",Investissements!F8,\"\")","v":""},{"$f":"IF(Investissements!J8<>\"\",Investissements!J8,\"\")","v":""},"",{"$f":"IF(SUMIFS($L$30:$L$39,$K$30:$K$39,B48)<>0,SUMIFS($L$30:$L$39,$K$30:$K$39,B48),\"\")","v":""},{"$f":"IF(G48<>\"\",G48/D48,\"\")","v":""},{"$f":"IF(H48<>\"\",Eligible(Paramètres!$B$36,Calculs!H48),\"\")","v":""},null,null,null,null,"","",""]
[null,"Produits pétroliers",null,{"$f":"IF(Investissements!F9<>\"\",Investissements!F9,\"\")","v":""},{"$f":"IF(Investissements!J9<>\"\",Investissements!J9,\"\")","v":""},"","","",{"$f":"IF(H49<>\"\",Eligible(Paramètres!$B$36,Calculs!H49),\"\")","v":""},null,null,null,null,"","",""]
[null,"Combustibles minéraux solides (charbon, coke)",null,{"$f":"IF(Investissements!F10<>\"\",Investissements!F10,\"\")","v":""},{"$f":"IF(Investissements!J10<>\"\",Investissements!J10,\"\")","v":""},"","","",{"$f":"IF(H50<>\"\",Eligible(Paramètres!$B$36,Calculs!H50),\"\")","v":""},null,"Désélectionner les investissements",null,null,"","",""]
[null,"Vapeur achetée",null,{"$f":"IF(Investissements!F11<>\"\",Investissements!F11,\"\")","v":""},{"$f":"IF(Investissements!J11<>\"\",Investissements!J11,\"\")","v":""},"","","",{"$f":"IF(H51<>\"\",Eligible(Paramètres!$B$36,Calculs!H51),\"\")","v":""},null," non éligibles par la suite !",null,null,"","",""]
[null,"Hydrogène",null,{"$f":"IF(Investissements!F12<>\"\",Investissements!F12,\"\")","v":""},{"$f":"IF(Investissements!J12<>\"\",Investissements!J12,\"\")","v":""},"","","",{"$f":"IF(H52<>\"\",Eligible(Paramètres!$B$36,Calculs!H52),\"\")","v":""},null,null,null,null,"","",""]
[null,"Autre",null,{"$f":"IF(Investissements!F13<>\"\",Investissements!F13,\"\")","v":""},{"$f":"IF(Investissements!J13<>\"\",Investissements!J13,\"\")","v":""},"","","",{"$f":"IF(H53<>\"\",Eligible(Paramètres!$B$36,Calculs!H53),\"\")","v":""},null,null,null,null,"","",""]
[null,null,"Total:",{"$f":"SUM(D47:D53)","v":0},{"$f":"SUM(E47:E53)","v":0},{"$f":"E54/D54","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G47:G53)","v":0},{"$f":"G54/D54","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"SUM(N47:N53)","v":0},{"$f":"SUM(O47:O53)","v":0},{"$f":"O54/N54","v":{"$error":"#DIV/0!"}}]

{"sheet":"Enrolement","index":3,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":true,"merged":[[52,0,54,0],[31,0,41,0],[27,0,29,0],[27,1,29,2],[8,0,8,1],[10,0,12,0],[19,0,22,0],[24,0,26,0],[24,1,26,2],[14,0,17,0],[43,0,43,1],[46,0,47,0],[49,0,50,0],[49,1,50,2],[6,0,6,1],[0,0,0,2],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
["Fiche d'enrôlement"]
[]
["Numéro PROGOS"]
["Commission permanente",null,{"$f":"Calculs!H6","v":"2023-05-26"}]
["Instructeur Région",null,{"$f":"Calculs!C6","v":"Pascal"}]
["Département du projet",null,"Meuse"]
["Gestionnaire financier",null,"Sandra Villemin"]
[]
["Soumis à convention",null,"OUI","Obligatoire pour MOA privé si aide > 23 000 €, Pas obligatoire sinon"]
[]
["Bénéficiaire","Bénéficiaire",{"$f":"Informations!C3","v":0}]
[null,"Secteur concurrentiel","OUI"]
[null,"Assujettissement à la TVA","OUI"]
[]
["Responsable","Adresse",{"$f":"Informations!#REF!","v":{"$error":"#REF!"}}]
[null,"Nom du responsable",{"$f":"Informations!C31","v":0}]
[null,"Prénom du Responsable",{"$f":"Informations!G31","v":0}]
[null,"Fonction",{"$f":"Informations!C33","v":0}]
[]
["Projet","Dossier (intitulé précis, puissance, surface, précision catégorie commune)",{"$f":"Informations!C9","v":0}]
[null,"Localisation (code postal)",{"$f":"Informations!#REF!","v":{"$error":"#REF!"}},"A changer si nécessaire"]
[null,"Localisation (commune)",{"$f":"Informations!#REF!","v":{"$error":"#REF!"}},"A changer si nécessaire"]
[null,"Coût réel de l'opération",{"$f":"Calculs!C25","v":0},"A changer si budget initial retravaillé"]
[]
["Résumé du projet : texte repris pour le corps du rapport inscrit en plénière\n(1 500 caractères environ = 1/2 page word)\n"]
[]
[]
["Résumé des gains économiques et environnementaux",{"$f":"\"Gains énergétiques annuels globaux : \" & ROUND(Calculs!L40/1000,1) & \" GWh/an, soit environ \" & INT(Calculs!Q25) & \" t CO2/an évitées\nGains économiques globaux: \" & INT(Calculs!P25) & \" €/an\n\nMontant de l’investissement présenté : \" & ROUND(Calculs!C25,2) & \" € HT\nMontant de l’investissement retenu : \" & ROUND(Calculs!D40,2) & \" € HT\nMontant de l’investissement de Référence : \" & ROUND(Calculs!E40,2) &\" € HT\nMontant des CEE retenus : \" & ROUND(Calculs!F40,2) & \" € HT\nMontant éligible retenu : \" & ROUND(Calculs!H40,2) & \" € HT\nTemps de retour sans/avec aide : \" & ROUND(Calculs!N40,1) & \" ans / \" & ROUND(Calculs!O40,1) & \" ans\n\nTaux maximum d'aide : \" & Calculs!I9*100 & \" % (\"  & Calculs!D8 & IF(Calculs!D10<>0,\" + 10% bonus)\",\")\") & \"\nMontant de l’aide : \" & ROUND(Calculs!P40,2) & \" € (Taux réel: \" & ROUND(Calculs!I40,4)*100 & \" %) \" & IF(Calculs!I40<Calculs!I9,\" plafonnée à \" & Calculs!P40 & \" €\",)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
["Décision Région","Dispositif d'aide Régional","Soutien à la Performance énergétique des entreprises de production"]
[null,"Investissements retenus",{"$f":"Calculs!D40","v":0}]
[null,"Montant solution de Référence",{"$f":"Calculs!E40","v":0}]
[null,"Montant des CEE",{"$f":"Calculs!F40","v":0}]
[null,"Montant subventionnable",{"$f":"Calculs!H40","v":{"$error":"#VALUE!"}}]
[null,"HT ou TTC","HT"]
[null,"Mode de calcul",{"$f":"Calculs!I40","v":0.4}]
[null,"Montant proposé de l'aide",{"$f":"Calculs!P40","v":{"$error":"#VALUE!"}}]
[null,"Modalité de versement","Le versement de la subvention se fera selon les modalités suivantes : 30% d'avance sur demande du bénéficiaire.\n\nLe solde sera versé sur présentation des pièces suivantes : \n- pièce technique : copie des factures\n- pièce financière : état récapitulatif des dépenses HT signé par le représentant légal et par le comptable","Voir tableau dans le 10-Dispositifs/ Cond Versement dispositifs TE"]
[null,"Date d'autorisation de démarrage"]
[null,"Date de fin de validité de l'aide"]
[]
["Investissement / Fonctionnement/ Mixte",null,"Investissement"]
[]
[]
["CPER","Volet du CPER"]
[null,"Mode de gestion"]
[]
["Commentaire"]
[]
[]
["Cofinanceur","Montant subventionnable"]
[null,"HT ou TTC"]
[null,"Montant proposé de l'aide"]

{"sheet":"Paramètres","index":4,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Paramètres de la feuille de calcul efficacité énergétique"]
[]
["Listes des menus déroulants"]
["Taille entreprise","Type énergie","Cout énergie","t CO2 / MWh","Instructeur","Réponse","Gestionnaire finan.","Civilité","Liste Equipements"]
["Petite entreprise",{"$f":"Investissements!B7","v":"Electricité"},{"$f":"Investissements!L7","v":0},0.18,"Pascal","Oui",null,"Monsieur","Comptage"]
["Moyenne entreprise",{"$f":"Investissements!B8","v":"Gaz"},{"$f":"Investissements!L8","v":0},0.222,"Richard","Non",null,"Madame","Chaleur fatale"]
["Grande entreprise",{"$f":"Investissements!B9","v":"Produits pétroliers"},{"$f":"Investissements!L9","v":0},0.46600000000000003,"Lucien",null,null,null,"Calorifugeage"]
[null,{"$f":"Investissements!B10","v":"Combustibles minéraux solides (charbon, coke)"},{"$f":"Investissements!L10","v":0},0.6,null,null,null,null,"Production d'air comprimé"]
[null,{"$f":"Investissements!B11","v":"Vapeur achetée"},{"$f":"Investissements!L11","v":0},0.1,null,null,null,null,"Production de vapeur"]
[null,{"$f":"Investissements!B12","v":"Hydrogène"},{"$f":"Investissements!L12","v":0},0.05,null,null,null,null,"Production d'eau chaude"]
[null,{"$f":"Investissements!B13","v":"Autre"},{"$f":"Investissements!L13","v":0},null,null,null,null,null,"Production de froid"]
[null,null,null,null,null,null,null,null,"Réseau chaud"]
[null,null,null,null,null,null,null,null,"Réseau froid"]
[null,null,null,null,null,null,null,null,"Ventilation"]
[null,null,null,null,null,null,null,null,"Eclairage"]
[null,null,null,null,null,null,null,null,"Alimentation électrique"]
[]
[]
["Paramètres de calcul"]
["Paramètres de calcul","Unités","PE","ME","GE","Commentaires"]
["Intitulé entreprise","-",{"$f":"A5","v":"Petite entreprise"},{"$f":"A6","v":"Moyenne entreprise"},{"$f":"A7","v":"Grande entreprise"}]
["Investissement minimum demandé","€",null,null,25000]
["Temps de retour minimum demandé","années",2,2,2]
["Taux d'aide","%",0.4,0.3,0.2]
["Bonus d'aide","%",0.1,0.1,0.1]
["Plafond de la subvention"]
[]
[]
[]
[]
["Options de calcul"]
[]
["En 2023"]
["Calcul sur 10% minimum d'économie d'énergie SITE par vacteur énergétique"]
[]
["% réduction conso minimale:",0.1]
[]
["Subvention max"]
[]
["Sub max:",200000]