{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["EXPLANATION","Profiled booking","Total prices","Transmission tariffs","Neutrality charge","Booking in Y-Q-M products","Monthly invoice","bladen rechts alleen voor inter","Multipliers and SF","Validation","Optimisation"],"not_rendered":{"charts":7,"images":8,"macros":1,"external_links":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"EXPLANATION","index":0,"n_rows":72,"n_cols":9,"rows_kept":72,"merged":[[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[22,1,24,10],[26,1,29,10],[31,2,33,10],[35,2,37,10],[39,2,41,10],[51,2,53,10],[57,2,58,10],[60,2,61,10],[66,2,67,10],[71,1,73,10]]}
[]
[]
[]
[null,"DISCLAIMER"]
[]
[null,"- GTS only provide's this file as service, no rights whatsoever may be derived from these calculations, shipper' bookings and GTS Invoices are leading."]
[null,"- Tariff used in the calculation are the tariffs for 2027 as established by the Dutch regulator ACM (26 May 2026): "]
[null,null,"Tariff decision 2027 › Gasunie Transport Services"]
[null,"- Multipliers and seasonal factors used as establish by the Duth regulator ACM in the NC TAR decision (25 April 2024):"]
[null,null,"https://www.acm.nl/nl/publicaties/codebesluit-ter-uitvoering-van-nc-tar",{"$nulls":5},"(Dutch)"]
[]
[null,"LEGEND"]
[]
[null,"GREEN",null,null,"Input cells to be filled out by user"]
[null,"BLUE",null,null,"Fixed input data"]
[null,"YELLOW",null,null,"Calculated value "]
[null,"ORANGE",null,null,"Calculated resulting value"]
[null,"BLACK",null,null,"Information sheets (this explanation sheet and sheets with calculation of the total prices)"]
[]
[null,"EXPLANATION CALCULATION TOOL PROFILED BOOKING"]
[]
[null,"Introduction"]
[null,"This tool converts a non-flat (profiled) booking for one year into an optimum combination of yearly, quarterly and monthly capacity products. The tool determines the cheapest combination in line with (a) and (b) of the 'optimisation paragraphs' described in article 2.1.2. of the Transmission Code Gas TSO (quote): "]
[]
[]
[]
[null,"“If a recognised programme-responsible party or connected parties with exit capacity at domestic entry and exit points contract entry or exit capacity at an entry or exit point on the same day in any given combination of quarterly, monthly, and daily capacity products, the network operator of the national gas transmission grid shall, at the request of the recognised programme-responsible party or connected parties with exit capacity, do the following for each tranche of the same quantity of contracted entry or exit capacity: "]
[]
[]
[]
[]
[null,"a.","If the payable price for the combination of contracted quarterly, monthly, and daily capacity products is greater than the price of a yearly capacity product, then the yearly capacity product shall be contracted for the tranche in question, provided the required capacity is available at the relevant entry or exit point; "]
[]
[]
[]
[null,"b.","If the payable price for the combination of contracted monthly and daily capacity products in one gas quarter is greater than the price of the relevant quarterly capacity product, then the relevant quarterly capacity product shall be contracted, provided the required capacity is available at the relevant entry or exit point; or "]
[]
[]
[]
[null,"c.","If the payable price for the combination of contracted daily capacity products in one month is greater than the payable price for the monthly capacity product, then the relevant monthly capacity product shall be contracted, provided the required capacity is available at the relevant entry or exit point.”"]
[]
[]
[]
[null,"The main steps in the optimisation are"]
[]
[null,"*","the profiled capacity of your choosing is divided into capacity tranches of the same quantity;"]
[]
[null,"*","for each tranche the capacity products are determined:"]
[]
[null,null,"-   in case the capacity is the same for all 12 months, a yearly capacity product applies;"]
[]
[null,null,"-   in case the capacity is the same for all 3 consecutive months in a quarter a quarterly capacity product applies. \n     When the by the shipper chosen starting month is not January, April, July or October, \n     the relevant quarter can only be booked per monthly and/or daily product(s);"]
[]
[]
[]
[null,null,"-   in all other case a monthly capacity products applies; "]
[]
[null,"*","if for a tranche the total payable price for the combination of quarterly and/or monthly capacity products is greater than the price of a yearly product, then the yearly capacity product applies instead of the capacity products as determined above; "]
[]
[]
[null,"*","for each month the yearly, quarterly and monthly capacities of all tranches are totalised resulting in an optimised combination of yearly, quarterly and monthly capacity products;"]
[]
[]
[null,"*","for each month the estimated invoice (based on 2027 tariffs) is calculated;"]
[]
[null,"Leading to the following 2 outputs"]
[null,"*","optimised: profiled booking optimised into yearly, quarterly and monthly capacity products including estimated monthly invoice (based on 2027 tariffs); and (for comparison)"]
[]
[null,"*","non-optimised: profiled booking converted into yearly, quarterly and monthly including estimated monthly invoice (based on 2027 tariffs)"]
[]
[null,"Disclaimer"]
[null,"This calculation tool advises shippers the cheapest combination of capacity products, based on the given input. Shippers obviously remain responsible for (timely) contracting the right (combination of) capacity products themselves. No rights or whatsoever can be derived from this calculation tool. "]

{"sheet":"Profiled booking","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[3,1,4,10],[8,4,9,11]]}
[]
[]
[]
[null,"CALCULATION TOOL FOR OPTIMISATION OF PROFILED BOOKINGS \nINTO YEARLY, QUARTERLY AND MONTHLY FIRM CAPACITY PRODUCTS"]
[]
[]
[null,"Postage stamp point","Entry regular",null,"Please fill in the appropriate values in the GREEN fields and click on button below for output"]
[null,"Starting month","January",null,{"$f":"IF(OR($C$8=$B$14,$C$8=$B$15),\"Please be aware that with this starting month it is not possible to contract the quarterly capacity product January-March\",IF(OR($C$8=$B$17,$C$8=$B$18),\"Please be aware that with this starting month it is not possible to contract the quarterly capacity product April-June\",IF(OR($C$8=$B$20,$C$8=$B$21),\"Please be aware that with this starting month it is not possible to contract the quarterly capacity product July-September\",IF(OR($C$8=$B$23,$C$8=$B$24),\"Please be aware that with this starting month it is not possible to contract the quarterly capacity product October-December\",\"\"))))","v":""}]
[null,"February capacity in leap year?","No",null,{"$f":"IF(OR(C13<0,C14<0,C15<0,C16<0,C17<0,C18<0,C19<0,C20<0,C21<0,C22<0,C23<0,C24<0),\"WARNING: calculation is not reliable due to negative value(s) in desired profiled booking, please correct to positive values! \nIn case of no correction, all negative values are automatically converted to zero (0) in the calculation.\",\"\")","v":""}]
[]
[null,"Month","Desired profiled \ncapacity booking"]
[null,null,"kWh/h/y"]
[null,"January",{"v":7000000,"d":"7,000,000"}]
[null,"February",{"v":7000000,"d":"7,000,000"}]
[null,"March",{"v":6000000,"d":"6,000,000"}]
[null,"April",{"v":6000000,"d":"6,000,000"}]
[null,"May",{"v":5000000,"d":"5,000,000"}]
[null,"June",{"v":1000000,"d":"1,000,000"}]
[null,"July",{"v":2000000,"d":"2,000,000"}]
[null,"August",{"v":3000000,"d":"3,000,000"}]
[null,"September",{"v":4000000,"d":"4,000,000"}]
[null,"October",{"v":7000000,"d":"7,000,000"}]
[null,"November",{"v":7000000,"d":"7,000,000"}]
[null,"December",{"v":7000000,"d":"7,000,000"}]

{"sheet":"Total prices","index":2,"n_rows":100,"n_cols":19,"rows_kept":100,"merged":[[7,2,7,6],[7,8,7,12],[7,14,7,18],[12,2,23,2],[12,3,14,3],[12,8,23,8],[12,9,14,9],[12,14,23,14],[12,15,14,15],[15,3,17,3],[15,9,17,9],[15,15,17,15],[18,3,20,3],[18,9,20,9],[18,15,20,15],[21,3,23,3],[21,9,23,9],[21,15,23,15],[25,2,25,6],[25,8,25,12],[30,2,41,2],[30,3,32,3],[30,8,41,8],[30,9,32,9],[33,3,35,3],[33,9,35,9],[36,3,38,3],[36,9,38,9],[39,3,41,3],[39,9,41,9]]}
[]
[]
[]
[null,"TOTAL PRICES 2027 FIRM CAPACITY (which is sum of the all-in transmission tariffs and the neutrality charges)"]
[]
[null,"Tariffs are all rounded to 8 decimals. Within-day prices are rounded up. "]
[]
[null,"Total prices FIRM capacity for interconnection points","ENTRY REGULAR",{"$nulls":5},"ENTRY STORAGE",{"$nulls":5},"ENTRY LNG"]
[null,"Payable total prices FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"January",{"$f":"'Transmission tariffs'!C13+'Neutrality charge'!C13","v":{"v":5.4725366399999995,"d":"5.47253664"}},{"$f":"'Transmission tariffs'!D13+'Neutrality charge'!D13","v":{"v":2.4997497799999997,"d":"2.49974978"}},{"$f":"'Transmission tariffs'!E13+'Neutrality charge'!E13","v":1.19567429},{"$f":"'Transmission tariffs'!F13+'Neutrality charge'!F13","v":0.04652031},{"$f":"'Transmission tariffs'!G13+'Neutrality charge'!G13","v":0.00193835},null,{"$f":"'Transmission tariffs'!I13+'Neutrality charge'!I13","v":{"v":1.3681341699999998,"d":"1.36813417"}},{"$f":"'Transmission tariffs'!J13+'Neutrality charge'!J13","v":{"v":0.6249374499999999,"d":"0.62493745"}},{"$f":"'Transmission tariffs'!K13+'Neutrality charge'!K13","v":0.29891858},{"$f":"'Transmission tariffs'!L13+'Neutrality charge'!L13","v":{"v":0.011630080000000001,"d":"0.01163008"}},{"$f":"'Transmission tariffs'!M13+'Neutrality charge'!M13","v":0.00048459},null,{"$f":"'Transmission tariffs'!O13+'Neutrality charge'!O13","v":{"v":5.4725366399999995,"d":"5.47253664"}},{"$f":"'Transmission tariffs'!P13+'Neutrality charge'!P13","v":{"v":2.4997497799999997,"d":"2.49974978"}},{"$f":"'Transmission tariffs'!Q13+'Neutrality charge'!Q13","v":1.19567429},{"$f":"'Transmission tariffs'!R13+'Neutrality charge'!R13","v":0.04652031},{"$f":"'Transmission tariffs'!S13+'Neutrality charge'!S13","v":0.00193835}]
[null,"February",null,null,{"$f":"'Transmission tariffs'!E14+'Neutrality charge'!E14","v":0.96535546},{"$f":"'Transmission tariffs'!F14+'Neutrality charge'!F14","v":0.04158753},{"$f":"'Transmission tariffs'!G14+'Neutrality charge'!G14","v":{"v":1.73281E-3,"d":"0.00173281"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K14+'Neutrality charge'!K14","v":0.24133887},{"$f":"'Transmission tariffs'!L14+'Neutrality charge'!L14","v":{"v":0.010396879999999999,"d":"0.01039688"}},{"$f":"'Transmission tariffs'!M14+'Neutrality charge'!M14","v":{"v":0.0004332,"d":"0.00043320"}},{"$nulls":3},{"$f":"'Transmission tariffs'!Q14+'Neutrality charge'!Q14","v":0.96535546},{"$f":"'Transmission tariffs'!R14+'Neutrality charge'!R14","v":0.04158753},{"$f":"'Transmission tariffs'!S14+'Neutrality charge'!S14","v":{"v":1.73281E-3,"d":"0.00173281"}}]
[null,"March",null,null,{"$f":"'Transmission tariffs'!E15+'Neutrality charge'!E15","v":0.83592623},{"$f":"'Transmission tariffs'!F15+'Neutrality charge'!F15","v":0.03250911},{"$f":"'Transmission tariffs'!G15+'Neutrality charge'!G15","v":{"v":1.35454E-3,"d":"0.00135454"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K15+'Neutrality charge'!K15","v":{"v":0.20898155000000002,"d":"0.20898155"}},{"$f":"'Transmission tariffs'!L15+'Neutrality charge'!L15","v":{"v":0.008127279999999999,"d":"0.00812728"}},{"$f":"'Transmission tariffs'!M15+'Neutrality charge'!M15","v":0.00033863},{"$nulls":3},{"$f":"'Transmission tariffs'!Q15+'Neutrality charge'!Q15","v":0.83592623},{"$f":"'Transmission tariffs'!R15+'Neutrality charge'!R15","v":0.03250911},{"$f":"'Transmission tariffs'!S15+'Neutrality charge'!S15","v":{"v":1.35454E-3,"d":"0.00135454"}}]
[null,"April",null,{"$f":"'Transmission tariffs'!D16+'Neutrality charge'!D16","v":1.33709813},{"$f":"'Transmission tariffs'!E16+'Neutrality charge'!E16","v":{"v":0.6031785,"d":"0.60317850"}},{"$f":"'Transmission tariffs'!F16+'Neutrality charge'!F16","v":{"v":0.024244079999999998,"d":"0.02424408"}},{"$f":"'Transmission tariffs'!G16+'Neutrality charge'!G16","v":0.00101017},null,null,{"$f":"'Transmission tariffs'!J16+'Neutrality charge'!J16","v":0.33427453},{"$f":"'Transmission tariffs'!K16+'Neutrality charge'!K16","v":0.15079462},{"$f":"'Transmission tariffs'!L16+'Neutrality charge'!L16","v":{"v":0.006061029999999999,"d":"0.00606103"}},{"$f":"'Transmission tariffs'!M16+'Neutrality charge'!M16","v":0.00025255},null,null,{"$f":"'Transmission tariffs'!P16+'Neutrality charge'!P16","v":1.33709813},{"$f":"'Transmission tariffs'!Q16+'Neutrality charge'!Q16","v":{"v":0.6031785,"d":"0.60317850"}},{"$f":"'Transmission tariffs'!R16+'Neutrality charge'!R16","v":{"v":0.024244079999999998,"d":"0.02424408"}},{"$f":"'Transmission tariffs'!S16+'Neutrality charge'!S16","v":0.00101017}]
[null,"May",null,null,{"$f":"'Transmission tariffs'!E17+'Neutrality charge'!E17","v":0.55217145},{"$f":"'Transmission tariffs'!F17+'Neutrality charge'!F17","v":{"v":0.021489079999999997,"d":"0.02148908"}},{"$f":"'Transmission tariffs'!G17+'Neutrality charge'!G17","v":0.00089538},{"$nulls":3},{"$f":"'Transmission tariffs'!K17+'Neutrality charge'!K17","v":{"v":0.13804286999999998,"d":"0.13804287"}},{"$f":"'Transmission tariffs'!L17+'Neutrality charge'!L17","v":{"v":0.005372259999999999,"d":"0.00537226"}},{"$f":"'Transmission tariffs'!M17+'Neutrality charge'!M17","v":{"v":2.2384E-4,"d":"0.00022384"}},{"$nulls":3},{"$f":"'Transmission tariffs'!Q17+'Neutrality charge'!Q17","v":0.55217145},{"$f":"'Transmission tariffs'!R17+'Neutrality charge'!R17","v":{"v":0.021489079999999997,"d":"0.02148908"}},{"$f":"'Transmission tariffs'!S17+'Neutrality charge'!S17","v":0.00089538}]
[null,"June",null,null,{"$f":"'Transmission tariffs'!E18+'Neutrality charge'!E18","v":{"v":0.44867303999999997,"d":"0.44867304"}},{"$f":"'Transmission tariffs'!F18+'Neutrality charge'!F18","v":0.01805187},{"$f":"'Transmission tariffs'!G18+'Neutrality charge'!G18","v":0.00075216},{"$nulls":3},{"$f":"'Transmission tariffs'!K18+'Neutrality charge'!K18","v":{"v":0.11216825999999999,"d":"0.11216826"}},{"$f":"'Transmission tariffs'!L18+'Neutrality charge'!L18","v":0.00451296},{"$f":"'Transmission tariffs'!M18+'Neutrality charge'!M18","v":{"v":1.8804E-4,"d":"0.00018804"}},{"$nulls":3},{"$f":"'Transmission tariffs'!Q18+'Neutrality charge'!Q18","v":{"v":0.44867303999999997,"d":"0.44867304"}},{"$f":"'Transmission tariffs'!R18+'Neutrality charge'!R18","v":0.01805187},{"$f":"'Transmission tariffs'!S18+'Neutrality charge'!S18","v":0.00075216}]
[null,"July",null,{"$f":"'Transmission tariffs'!D19+'Neutrality charge'!D19","v":{"v":1.0845368100000001,"d":"1.08453681"}},{"$f":"'Transmission tariffs'!E19+'Neutrality charge'!E19","v":{"v":0.43783290999999996,"d":"0.43783291"}},{"$f":"'Transmission tariffs'!F19+'Neutrality charge'!F19","v":0.01702858},{"$f":"'Transmission tariffs'!G19+'Neutrality charge'!G19","v":0.00070952},null,null,{"$f":"'Transmission tariffs'!J19+'Neutrality charge'!J19","v":{"v":0.2711342,"d":"0.27113420"}},{"$f":"'Transmission tariffs'!K19+'Neutrality charge'!K19","v":0.10945823},{"$f":"'Transmission tariffs'!L19+'Neutrality charge'!L19","v":{"v":4.2571499999999995E-3,"d":"0.00425715"}},{"$f":"'Transmission tariffs'!M19+'Neutrality charge'!M19","v":0.00017738},null,null,{"$f":"'Transmission tariffs'!P19+'Neutrality charge'!P19","v":{"v":1.0845368100000001,"d":"1.08453681"}},{"$f":"'Transmission tariffs'!Q19+'Neutrality charge'!Q19","v":{"v":0.43783290999999996,"d":"0.43783291"}},{"$f":"'Transmission tariffs'!R19+'Neutrality charge'!R19","v":0.01702858},{"$f":"'Transmission tariffs'!S19+'Neutrality charge'!S19","v":0.00070952}]
[null,"August",null,null,{"$f":"'Transmission tariffs'!E20+'Neutrality charge'!E20","v":0.41622015},{"$f":"'Transmission tariffs'!F20+'Neutrality charge'!F20","v":{"v":0.0162152,"d":"0.01621520"}},{"$f":"'Transmission tariffs'!G20+'Neutrality charge'!G20","v":0.00067564},{"$nulls":3},{"$f":"'Transmission tariffs'!K20+'Neutrality charge'!K20","v":0.10405504},{"$f":"'Transmission tariffs'!L20+'Neutrality charge'!L20","v":{"v":0.0040538,"d":"0.00405380"}},{"$f":"'Transmission tariffs'!M20+'Neutrality charge'!M20","v":0.00016891},{"$nulls":3},{"$f":"'Transmission tariffs'!Q20+'Neutrality charge'!Q20","v":0.41622015},{"$f":"'Transmission tariffs'!R20+'Neutrality charge'!R20","v":{"v":0.0162152,"d":"0.01621520"}},{"$f":"'Transmission tariffs'!S20+'Neutrality charge'!S20","v":0.00067564}]
[null,"September",null,null,{"$f":"'Transmission tariffs'!E21+'Neutrality charge'!E21","v":0.44732365},{"$f":"'Transmission tariffs'!F21+'Neutrality charge'!F21","v":{"v":0.017999400000000002,"d":"0.01799940"}},{"$f":"'Transmission tariffs'!G21+'Neutrality charge'!G21","v":0.00074997},{"$nulls":3},{"$f":"'Transmission tariffs'!K21+'Neutrality charge'!K21","v":0.11183091},{"$f":"'Transmission tariffs'!L21+'Neutrality charge'!L21","v":{"v":4.4998500000000006E-3,"d":"0.00449985"}},{"$f":"'Transmission tariffs'!M21+'Neutrality charge'!M21","v":{"v":1.8749999999999998E-4,"d":"0.00018750"}},{"$nulls":3},{"$f":"'Transmission tariffs'!Q21+'Neutrality charge'!Q21","v":0.44732365},{"$f":"'Transmission tariffs'!R21+'Neutrality charge'!R21","v":{"v":0.017999400000000002,"d":"0.01799940"}},{"$f":"'Transmission tariffs'!S21+'Neutrality charge'!S21","v":0.00074997}]
[null,"October",null,{"$f":"'Transmission tariffs'!D22+'Neutrality charge'!D22","v":1.90526738},{"$f":"'Transmission tariffs'!E22+'Neutrality charge'!E22","v":{"v":0.5305586800000001,"d":"0.53055868"}},{"$f":"'Transmission tariffs'!F22+'Neutrality charge'!F22","v":{"v":0.020649459999999998,"d":"0.02064946"}},{"$f":"'Transmission tariffs'!G22+'Neutrality charge'!G22","v":0.00086039},null,null,{"$f":"'Transmission tariffs'!J22+'Neutrality charge'!J22","v":0.47631685},{"$f":"'Transmission tariffs'!K22+'Neutrality charge'!K22","v":{"v":0.13263967000000002,"d":"0.13263967"}},{"$f":"'Transmission tariffs'!L22+'Neutrality charge'!L22","v":0.00516237},{"$f":"'Transmission tariffs'!M22+'Neutrality charge'!M22","v":{"v":2.1509E-4,"d":"0.00021509"}},null,null,{"$f":"'Transmission tariffs'!P22+'Neutrality charge'!P22","v":1.90526738},{"$f":"'Transmission tariffs'!Q22+'Neutrality charge'!Q22","v":{"v":0.5305586800000001,"d":"0.53055868"}},{"$f":"'Transmission tariffs'!R22+'Neutrality charge'!R22","v":{"v":0.020649459999999998,"d":"0.02064946"}},{"$f":"'Transmission tariffs'!S22+'Neutrality charge'!S22","v":0.00086039}]
[null,"November",null,null,{"$f":"'Transmission tariffs'!E23+'Neutrality charge'!E23","v":{"v":0.7624068199999999,"d":"0.76240682"}},{"$f":"'Transmission tariffs'!F23+'Neutrality charge'!F23","v":0.03064621},{"$f":"'Transmission tariffs'!G23+'Neutrality charge'!G23","v":{"v":1.27692E-3,"d":"0.00127692"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K23+'Neutrality charge'!K23","v":{"v":0.19060170999999998,"d":"0.19060171"}},{"$f":"'Transmission tariffs'!L23+'Neutrality charge'!L23","v":0.00766155},{"$f":"'Transmission tariffs'!M23+'Neutrality charge'!M23","v":0.00031923},{"$nulls":3},{"$f":"'Transmission tariffs'!Q23+'Neutrality charge'!Q23","v":{"v":0.7624068199999999,"d":"0.76240682"}},{"$f":"'Transmission tariffs'!R23+'Neutrality charge'!R23","v":0.03064621},{"$f":"'Transmission tariffs'!S23+'Neutrality charge'!S23","v":{"v":1.27692E-3,"d":"0.00127692"}}]
[null,"December",null,null,{"$f":"'Transmission tariffs'!E24+'Neutrality charge'!E24","v":0.99279312},{"$f":"'Transmission tariffs'!F24+'Neutrality charge'!F24","v":0.03862262},{"$f":"'Transmission tariffs'!G24+'Neutrality charge'!G24","v":{"v":1.6092699999999999E-3,"d":"0.00160927"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K24+'Neutrality charge'!K24","v":0.24819828},{"$f":"'Transmission tariffs'!L24+'Neutrality charge'!L24","v":{"v":9.65565E-3,"d":"0.00965565"}},{"$f":"'Transmission tariffs'!M24+'Neutrality charge'!M24","v":0.00040232},{"$nulls":3},{"$f":"'Transmission tariffs'!Q24+'Neutrality charge'!Q24","v":0.99279312},{"$f":"'Transmission tariffs'!R24+'Neutrality charge'!R24","v":0.03862262},{"$f":"'Transmission tariffs'!S24+'Neutrality charge'!S24","v":{"v":1.6092699999999999E-3,"d":"0.00160927"}}]
[]
[null,"Total prices FIRM capacity for interconnection points","EXIT NON-STORAGE",{"$nulls":5},"EXIT STORAGE"]
[null,"Payable total prices FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"January",{"$f":"'Transmission tariffs'!C31+'Neutrality charge'!C31","v":5.09303642},{"$f":"'Transmission tariffs'!D31+'Neutrality charge'!D31","v":2.32640137},{"$f":"'Transmission tariffs'!E31+'Neutrality charge'!E31","v":1.11275869},{"$f":"'Transmission tariffs'!F31+'Neutrality charge'!F31","v":{"v":0.0432943,"d":"0.04329430"}},{"$f":"'Transmission tariffs'!G31+'Neutrality charge'!G31","v":{"v":1.80393E-3,"d":"0.00180393"}},null,{"$f":"'Transmission tariffs'!I31+'Neutrality charge'!I31","v":{"v":1.2732591100000001,"d":"1.27325911"}},{"$f":"'Transmission tariffs'!J31+'Neutrality charge'!J31","v":0.58160034},{"$f":"'Transmission tariffs'!K31+'Neutrality charge'!K31","v":0.27818967},{"$f":"'Transmission tariffs'!L31+'Neutrality charge'!L31","v":0.01082358},{"$f":"'Transmission tariffs'!M31+'Neutrality charge'!M31","v":{"v":4.5097999999999997E-4,"d":"0.00045098"}}]
[null,"February",null,null,{"$f":"'Transmission tariffs'!E32+'Neutrality charge'!E32","v":0.89841163},{"$f":"'Transmission tariffs'!F32+'Neutrality charge'!F32","v":0.03870358},{"$f":"'Transmission tariffs'!G32+'Neutrality charge'!G32","v":{"v":1.61265E-3,"d":"0.00161265"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K32+'Neutrality charge'!K32","v":{"v":0.22460291000000002,"d":"0.22460291"}},{"$f":"'Transmission tariffs'!L32+'Neutrality charge'!L32","v":{"v":0.0096759,"d":"0.00967590"}},{"$f":"'Transmission tariffs'!M32+'Neutrality charge'!M32","v":{"v":4.0317E-4,"d":"0.00040317"}}]
[null,"March",null,null,{"$f":"'Transmission tariffs'!E33+'Neutrality charge'!E33","v":0.77795783},{"$f":"'Transmission tariffs'!F33+'Neutrality charge'!F33","v":0.03025473},{"$f":"'Transmission tariffs'!G33+'Neutrality charge'!G33","v":0.00126062},{"$nulls":3},{"$f":"'Transmission tariffs'!K33+'Neutrality charge'!K33","v":0.19448945},{"$f":"'Transmission tariffs'!L33+'Neutrality charge'!L33","v":0.00756369},{"$f":"'Transmission tariffs'!M33+'Neutrality charge'!M33","v":0.00031515}]
[null,"April",null,{"$f":"'Transmission tariffs'!D34+'Neutrality charge'!D34","v":{"v":1.2443753100000001,"d":"1.24437531"}},{"$f":"'Transmission tariffs'!E34+'Neutrality charge'!E34","v":0.56135029},{"$f":"'Transmission tariffs'!F34+'Neutrality charge'!F34","v":0.02256285},{"$f":"'Transmission tariffs'!G34+'Neutrality charge'!G34","v":{"v":9.4012000000000013E-4,"d":"0.00094012"}},null,null,{"$f":"'Transmission tariffs'!J34+'Neutrality charge'!J34","v":0.31109383},{"$f":"'Transmission tariffs'!K34+'Neutrality charge'!K34","v":0.14033757},{"$f":"'Transmission tariffs'!L34+'Neutrality charge'!L34","v":0.00564071},{"$f":"'Transmission tariffs'!M34+'Neutrality charge'!M34","v":{"v":2.3503E-4,"d":"0.00023503"}}]
[null,"May",null,null,{"$f":"'Transmission tariffs'!E35+'Neutrality charge'!E35","v":{"v":0.5138804,"d":"0.51388040"}},{"$f":"'Transmission tariffs'!F35+'Neutrality charge'!F35","v":{"v":0.019998890000000002,"d":"0.01999889"}},{"$f":"'Transmission tariffs'!G35+'Neutrality charge'!G35","v":0.00083328},{"$nulls":3},{"$f":"'Transmission tariffs'!K35+'Neutrality charge'!K35","v":{"v":0.1284701,"d":"0.12847010"}},{"$f":"'Transmission tariffs'!L35+'Neutrality charge'!L35","v":{"v":4.99973E-3,"d":"0.00499973"}},{"$f":"'Transmission tariffs'!M35+'Neutrality charge'!M35","v":0.00020832}]
[null,"June",null,null,{"$f":"'Transmission tariffs'!E36+'Neutrality charge'!E36","v":0.41755922},{"$f":"'Transmission tariffs'!F36+'Neutrality charge'!F36","v":{"v":0.016800040000000002,"d":"0.01680004"}},{"$f":"'Transmission tariffs'!G36+'Neutrality charge'!G36","v":{"v":7.000000000000001E-4,"d":"0.00070000"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K36+'Neutrality charge'!K36","v":{"v":0.1043898,"d":"0.10438980"}},{"$f":"'Transmission tariffs'!L36+'Neutrality charge'!L36","v":{"v":4.2000200000000005E-3,"d":"0.00420002"}},{"$f":"'Transmission tariffs'!M36+'Neutrality charge'!M36","v":{"v":1.75E-4,"d":"0.00017500"}}]
[null,"July",null,{"$f":"'Transmission tariffs'!D37+'Neutrality charge'!D37","v":1.00932819},{"$f":"'Transmission tariffs'!E37+'Neutrality charge'!E37","v":0.40747082},{"$f":"'Transmission tariffs'!F37+'Neutrality charge'!F37","v":0.01584772},{"$f":"'Transmission tariffs'!G37+'Neutrality charge'!G37","v":0.00066032},null,null,{"$f":"'Transmission tariffs'!J37+'Neutrality charge'!J37","v":0.25233205},{"$f":"'Transmission tariffs'!K37+'Neutrality charge'!K37","v":0.10186771},{"$f":"'Transmission tariffs'!L37+'Neutrality charge'!L37","v":0.00396193},{"$f":"'Transmission tariffs'!M37+'Neutrality charge'!M37","v":{"v":1.6507999999999998E-4,"d":"0.00016508"}}]
[null,"August",null,null,{"$f":"'Transmission tariffs'!E38+'Neutrality charge'!E38","v":0.38735681},{"$f":"'Transmission tariffs'!F38+'Neutrality charge'!F38","v":0.01509074},{"$f":"'Transmission tariffs'!G38+'Neutrality charge'!G38","v":{"v":6.2878000000000012E-4,"d":"0.00062878"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K38+'Neutrality charge'!K38","v":0.09683921},{"$f":"'Transmission tariffs'!L38+'Neutrality charge'!L38","v":{"v":3.77268E-3,"d":"0.00377268"}},{"$f":"'Transmission tariffs'!M38+'Neutrality charge'!M38","v":{"v":1.5718999999999998E-4,"d":"0.00015719"}}]
[null,"September",null,null,{"$f":"'Transmission tariffs'!E39+'Neutrality charge'!E39","v":{"v":0.4163034,"d":"0.41630340"}},{"$f":"'Transmission tariffs'!F39+'Neutrality charge'!F39","v":0.01675121},{"$f":"'Transmission tariffs'!G39+'Neutrality charge'!G39","v":{"v":6.9796000000000007E-4,"d":"0.00069796"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K39+'Neutrality charge'!K39","v":0.10407585},{"$f":"'Transmission tariffs'!L39+'Neutrality charge'!L39","v":{"v":0.0041878,"d":"0.00418780"}},{"$f":"'Transmission tariffs'!M39+'Neutrality charge'!M39","v":0.00017449}]
[null,"October",null,{"$f":"'Transmission tariffs'!D40+'Neutrality charge'!D40","v":1.77314412},{"$f":"'Transmission tariffs'!E40+'Neutrality charge'!E40","v":0.49376639},{"$f":"'Transmission tariffs'!F40+'Neutrality charge'!F40","v":0.01921749},{"$f":"'Transmission tariffs'!G40+'Neutrality charge'!G40","v":0.00080072},null,null,{"$f":"'Transmission tariffs'!J40+'Neutrality charge'!J40","v":0.44328603},{"$f":"'Transmission tariffs'!K40+'Neutrality charge'!K40","v":{"v":0.1234416,"d":"0.12344160"}},{"$f":"'Transmission tariffs'!L40+'Neutrality charge'!L40","v":0.00480438},{"$f":"'Transmission tariffs'!M40+'Neutrality charge'!M40","v":{"v":2.0018E-4,"d":"0.00020018"}}]
[null,"November",null,null,{"$f":"'Transmission tariffs'!E41+'Neutrality charge'!E41","v":0.70953672},{"$f":"'Transmission tariffs'!F41+'Neutrality charge'!F41","v":{"v":0.028520999999999998,"d":"0.02852100"}},{"$f":"'Transmission tariffs'!G41+'Neutrality charge'!G41","v":0.00118838},{"$nulls":3},{"$f":"'Transmission tariffs'!K41+'Neutrality charge'!K41","v":0.17738418},{"$f":"'Transmission tariffs'!L41+'Neutrality charge'!L41","v":0.00713025},{"$f":"'Transmission tariffs'!M41+'Neutrality charge'!M41","v":{"v":0.0002971,"d":"0.00029710"}}]
[null,"December",null,null,{"$f":"'Transmission tariffs'!E42+'Neutrality charge'!E42","v":{"v":0.9239465800000001,"d":"0.92394658"}},{"$f":"'Transmission tariffs'!F42+'Neutrality charge'!F42","v":0.03594428},{"$f":"'Transmission tariffs'!G42+'Neutrality charge'!G42","v":{"v":1.49767E-3,"d":"0.00149767"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K42+'Neutrality charge'!K42","v":{"v":0.23098665000000002,"d":"0.23098665"}},{"$f":"'Transmission tariffs'!L42+'Neutrality charge'!L42","v":0.00898607},{"$f":"'Transmission tariffs'!M42+'Neutrality charge'!M42","v":0.00037442}]
{"$rows_empty":32}
[null,"Multipliers (M)"]
[]
[null,"Quaterly multiplier"]
[null,"Monthly multiplier"]
[null,"Daily multiplier"]
[null,"Within-day multiplier"]
[]
[null,"Seasonal factors (SF)","WID"]
[]
[null,"SF - Jan",1.877]
[null,"SF - Feb",1.753]
[null,"SF - March",1.269]
[null,"SF - April",0.903]
[null,"SF - May",0.711]
[null,"SF - June",0.631]
[null,"SF - July",0.583]
[null,"SF - August",0.555]
[null,"SF - Sept",0.604]
[null,"SF - Oct",0.784]
[null,"SF - Nov",1.269]
[null,"SF - Dec",1.677]
[]
[null,"SF - Jan - March"]
[null,"SF - April - June"]
[null,"SF - July - Sept"]
[null,"SF - Oct - Dec"]

{"sheet":"Transmission tariffs","index":3,"n_rows":100,"n_cols":19,"rows_kept":100,"merged":[[7,2,7,6],[7,8,7,12],[7,14,7,18],[12,2,23,2],[12,3,14,3],[12,8,23,8],[12,9,14,9],[12,14,23,14],[12,15,14,15],[15,3,17,3],[15,9,17,9],[15,15,17,15],[18,3,20,3],[18,9,20,9],[18,15,20,15],[21,3,23,3],[21,9,23,9],[21,15,23,15],[25,2,25,6],[25,8,25,12],[30,2,41,2],[30,3,32,3],[30,8,41,8],[30,9,32,9],[33,3,35,3],[33,9,35,9],[36,3,38,3],[36,9,38,9],[39,3,41,3],[39,9,41,9]]}
[]
[]
[]
[null,"ALL-IN TRANSMISSION TARIFFS 2027 (as established by the Dutch regulator ACM)"]
[]
[null,"Tariffs are all rounded to 8 decimals. Within-day prices are rounded up. "]
[]
[null,"Reserve prices FIRM capacity for interconnection points","ENTRY REGULAR",{"$nulls":5},"ENTRY STORAGE",{"$nulls":5},"ENTRY LNG"]
[null,"Payable prices FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"Januari",5.48094638,2.50359119,{"v":1.1975117,"d":"1.19751170"},{"v":0.0465918,"d":"0.04659180"},{"v":1.94133E-3,"d":"0.00194133"},null,{"v":1.3702366,"d":"1.37023660"},{"v":0.6258978,"d":"0.62589780"},0.29937793,0.01164795,0.00048534,null,5.48094638,2.50359119,{"v":1.1975117,"d":"1.19751170"},{"v":0.0465918,"d":"0.04659180"},{"v":1.94133E-3,"d":"0.00194133"}]
[null,"Februari",null,null,0.96683894,0.04165144,{"v":1.73548E-3,"d":"0.00173548"},{"$nulls":3},0.24170974,0.01041286,0.00043387,{"$nulls":3},0.96683894,0.04165144,{"v":1.73548E-3,"d":"0.00173548"}]
[null,"Maart",null,null,0.83721081,0.03255907,0.00135663,{"$nulls":3},{"v":0.2093027,"d":"0.20930270"},0.00813977,{"v":3.3915999999999997E-4,"d":"0.00033916"},{"$nulls":3},0.83721081,0.03255907,0.00135663]
[null,"April",null,1.33915287,0.60410541,0.02428134,{"v":1.01173E-3,"d":"0.00101173"},null,null,0.33478822,0.15102635,0.00607034,{"v":2.5294E-4,"d":"0.00025294"},null,null,1.33915287,0.60410541,0.02428134,{"v":1.01173E-3,"d":"0.00101173"}]
[null,"Mei",null,null,0.55301998,{"v":0.0215221,"d":"0.02152210"},0.00089676,{"$nulls":3},{"v":0.138255,"d":"0.13825500"},0.00538052,0.00022419,{"$nulls":3},0.55301998,{"v":0.0215221,"d":"0.02152210"},0.00089676]
[null,"Juni",null,null,0.44936252,0.01807961,0.00075332,{"$nulls":3},0.11234063,{"v":0.0045199,"d":"0.00451990"},0.00018833,{"$nulls":3},0.44936252,0.01807961,0.00075332]
[null,"Juli",null,1.08620344,0.43850574,0.01705475,0.00071062,null,null,0.27155086,0.10962644,0.00426369,{"v":1.7766E-4,"d":"0.00017766"},null,null,1.08620344,0.43850574,0.01705475,0.00071062]
[null,"Augustus",null,null,0.41685976,0.01624012,0.00067668,{"$nulls":3},0.10421494,0.00406003,0.00016917,{"$nulls":3},0.41685976,0.01624012,0.00067668]
[null,"September",null,null,0.44801106,0.01802706,0.00075113,{"$nulls":3},0.11200276,0.00450676,0.00018779,{"$nulls":3},0.44801106,0.01802706,0.00075113]
[null,"Oktober",null,1.90819524,{"v":0.531374,"d":"0.53137400"},0.02068119,{"v":8.6172000000000006E-4,"d":"0.00086172"},null,null,0.47704881,{"v":0.1328435,"d":"0.13284350"},{"v":0.0051703,"d":"0.00517030"},0.00021543,null,null,1.90819524,{"v":0.531374,"d":"0.53137400"},0.02068119,{"v":8.6172000000000006E-4,"d":"0.00086172"}]
[null,"November",null,null,0.76357842,{"v":0.0306933,"d":"0.03069330"},{"v":1.27889E-3,"d":"0.00127889"},{"$nulls":3},0.19089461,{"v":7.67332E-3,"d":"0.00767332"},{"v":3.1973E-4,"d":"0.00031973"},{"$nulls":3},0.76357842,{"v":0.0306933,"d":"0.03069330"},{"v":1.27889E-3,"d":"0.00127889"}]
[null,"December",null,null,0.99431876,0.03868197,0.00161175,{"$nulls":3},0.24857969,0.00967049,0.00040294,{"$nulls":3},0.99431876,0.03868197,0.00161175]
[]
[null,"Reserve prices FIRM capacity for interconnection points","EXIT NON-STORAGE",{"$nulls":5},"EXIT STORAGE"]
[null,"Payable prices FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"Januari",5.10086298,2.32997639,1.11446869,0.04336083,{"v":1.80671E-3,"d":"0.00180671"},null,1.27521575,{"v":0.5824941,"d":"0.58249410"},0.27861717,0.01084021,0.00045168]
[null,"Februari",null,null,0.89979223,0.03876306,{"v":1.61513E-3,"d":"0.00161513"},{"$nulls":3},0.22494806,0.00969077,0.00040379]
[null,"Maart",null,null,0.77915333,0.03030122,{"v":1.26256E-3,"d":"0.00126256"},{"$nulls":3},0.19478833,{"v":7.57531E-3,"d":"0.00757531"},0.00031564]
[null,"April",null,1.24628756,0.56221293,0.02259752,{"v":9.4157000000000008E-4,"d":"0.00094157"},null,null,0.31157189,0.14055323,0.00564938,{"v":2.354E-4,"d":"0.00023540"}]
[null,"Mei",null,null,0.51467009,0.02002962,{"v":8.3457000000000008E-4,"d":"0.00083457"},{"$nulls":3},0.12866752,0.00500741,{"v":2.0865E-4,"d":"0.00020865"}]
[null,"Juni",null,null,0.41820089,0.01682586,{"v":7.0108000000000008E-4,"d":"0.00070108"},{"$nulls":3},0.10455022,0.00420647,0.00017527]
[null,"Juli",null,1.01087924,0.40809699,0.01587207,{"v":6.6134000000000006E-4,"d":"0.00066134"},null,null,0.25271981,0.10202425,0.00396802,{"v":1.6533999999999999E-4,"d":"0.00016534"}]
[null,"Augustus",null,null,0.38795207,0.01511393,{"v":6.297500000000001E-4,"d":"0.00062975"},{"$nulls":3},0.09698802,0.00377848,{"v":1.5743999999999998E-4,"d":"0.00015744"}]
[null,"September",null,null,0.41694314,0.01677695,{"v":6.9904000000000006E-4,"d":"0.00069904"},{"$nulls":3},0.10423579,0.00419424,0.00017476]
[null,"Oktober",null,1.77586894,0.49452517,0.01924702,{"v":8.0196E-4,"d":"0.00080196"},null,null,0.44396724,0.12363129,{"v":4.81176E-3,"d":"0.00481176"},{"v":2.0049E-4,"d":"0.00020049"}]
[null,"November",null,null,0.71062708,0.02856483,0.00119021,{"$nulls":3},0.17765677,0.00714121,0.00029756]
[null,"December",null,null,0.92536642,0.03599952,0.00149998,{"$nulls":3},0.23134161,{"v":8.99988E-3,"d":"0.00899988"},{"v":0.000375,"d":"0.00037500"}]
{"$rows_empty":32}
[null,"Multipliers (M)"]
[]
[null,"Quaterly multiplier"]
[null,"Monthly multiplier"]
[null,"Daily multiplier"]
[null,"Within-day multiplier"]
[]
[null,"Seasonal factors (SF)","WID"]
[]
[null,"SF - Jan",1.877]
[null,"SF - Feb",1.753]
[null,"SF - March",1.269]
[null,"SF - April",0.903]
[null,"SF - May",0.711]
[null,"SF - June",0.631]
[null,"SF - July",0.583]
[null,"SF - August",0.555]
[null,"SF - Sept",0.604]
[null,"SF - Oct",0.784]
[null,"SF - Nov",1.269]
[null,"SF - Dec",1.677]
[]
[null,"SF - Jan - March"]
[null,"SF - April - June"]
[null,"SF - July - Sept"]
[null,"SF - Oct - Dec"]

{"sheet":"Neutrality charge","index":4,"n_rows":100,"n_cols":19,"rows_kept":100,"merged":[[7,2,7,6],[7,8,7,12],[7,14,7,18],[12,2,23,2],[12,3,14,3],[12,8,23,8],[12,9,14,9],[12,14,23,14],[12,15,14,15],[15,3,17,3],[15,9,17,9],[15,15,17,15],[18,3,20,3],[18,9,20,9],[18,15,20,15],[21,3,23,3],[21,9,23,9],[21,15,23,15],[25,2,25,6],[25,8,25,12],[30,2,41,2],[30,3,32,3],[30,8,41,8],[30,9,32,9],[33,3,35,3],[33,9,35,9],[36,3,38,3],[36,9,38,9],[39,3,41,3],[39,9,41,9]]}
[]
[]
[]
[null,"NEUTRALITY CHARGE 2027 (as established by GTS in accordance with calculation methodology as stated in the Transmission Code Gas - TSO)"]
[]
[null,"Charges are all rounded to 8 decimals. Within-day prices are rounded up. "]
[]
[null,"Charge FIRM capacity for interconnection points","ENTRY REGULAR",{"$nulls":5},"ENTRY STORAGE",{"$nulls":5},"ENTRY LNG"]
[null,"Payable charge FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"Januari",-0.00840974,{"v":-3.84141E-3,"d":"-0.00384141"},{"v":-1.83741E-3,"d":"-0.00183741"},{"v":-7.149e-05,"d":"-0.00007149"},{"v":-2.98e-06,"d":"-0.00000298"},null,-0.00210243,-0.00096035,-0.00045935,{"v":-1.787E-5,"d":"-0.00001787"},{"v":-7.5e-07,"d":"-0.00000075"},null,-0.00840974,{"v":-3.84141E-3,"d":"-0.00384141"},{"v":-1.83741E-3,"d":"-0.00183741"},{"v":-7.149e-05,"d":"-0.00007149"},{"v":-2.98e-06,"d":"-0.00000298"}]
[null,"Februari",null,null,-0.00148348,{"v":-6.391e-05,"d":"-0.00006391"},{"v":-2.67e-06,"d":"-0.00000267"},{"$nulls":3},-0.00037087,{"v":-1.598e-05,"d":"-0.00001598"},{"v":-6.7e-07,"d":"-0.00000067"},{"$nulls":3},-0.00148348,{"v":-6.391e-05,"d":"-0.00006391"},{"v":-2.67e-06,"d":"-0.00000267"}]
[null,"Maart",null,null,{"v":-1.28458E-3,"d":"-0.00128458"},{"v":-4.996e-05,"d":"-0.00004996"},{"v":-2.09e-06,"d":"-0.00000209"},{"$nulls":3},-0.00032115,{"v":-1.249e-05,"d":"-0.00001249"},{"v":-5.3e-07,"d":"-0.00000053"},{"$nulls":3},{"v":-1.28458E-3,"d":"-0.00128458"},{"v":-4.996e-05,"d":"-0.00004996"},{"v":-2.09e-06,"d":"-0.00000209"}]
[null,"April",null,-0.00205474,-0.00092691,{"v":-3.726e-05,"d":"-0.00003726"},{"v":-1.5599999999999999E-6,"d":"-0.00000156"},null,null,-0.00051369,-0.00023173,{"v":-9.31e-06,"d":"-0.00000931"},{"v":-3.9e-07,"d":"-0.00000039"},null,null,-0.00205474,-0.00092691,{"v":-3.726e-05,"d":"-0.00003726"},{"v":-1.5599999999999999E-6,"d":"-0.00000156"}]
[null,"Mei",null,null,-0.00084853,{"v":-3.302e-05,"d":"-0.00003302"},{"v":-1.38e-06,"d":"-0.00000138"},{"$nulls":3},-0.00021213,{"v":-8.26e-06,"d":"-0.00000826"},{"v":-3.5e-07,"d":"-0.00000035"},{"$nulls":3},-0.00084853,{"v":-3.302e-05,"d":"-0.00003302"},{"v":-1.38e-06,"d":"-0.00000138"}]
[null,"Juni",null,null,-0.00068948,{"v":-2.774e-05,"d":"-0.00002774"},{"v":-1.16e-06,"d":"-0.00000116"},{"$nulls":3},{"v":-1.7237E-4,"d":"-0.00017237"},{"v":-6.94e-06,"d":"-0.00000694"},{"v":-2.9000000000000003E-7,"d":"-0.00000029"},{"$nulls":3},-0.00068948,{"v":-2.774e-05,"d":"-0.00002774"},{"v":-1.16e-06,"d":"-0.00000116"}]
[null,"Juli",null,-0.00166663,-0.00067283,{"v":-2.617e-05,"d":"-0.00002617"},{"v":-1.0999999999999998E-6,"d":"-0.00000110"},null,null,-0.00041666,-0.00016821,{"v":-6.54e-06,"d":"-0.00000654"},{"v":-2.8e-07,"d":"-0.00000028"},null,null,-0.00166663,-0.00067283,{"v":-2.617e-05,"d":"-0.00002617"},{"v":-1.0999999999999998E-6,"d":"-0.00000110"}]
[null,"Augustus",null,null,-0.00063961,{"v":-2.492e-05,"d":"-0.00002492"},{"v":-1.04E-6,"d":"-0.00000104"},{"$nulls":3},{"v":-0.0001599,"d":"-0.00015990"},{"v":-6.23e-06,"d":"-0.00000623"},{"v":-2.6E-7,"d":"-0.00000026"},{"$nulls":3},-0.00063961,{"v":-2.492e-05,"d":"-0.00002492"},{"v":-1.04E-6,"d":"-0.00000104"}]
[null,"September",null,null,-0.00068741,{"v":-2.766e-05,"d":"-0.00002766"},{"v":-1.16e-06,"d":"-0.00000116"},{"$nulls":3},{"v":-1.7185E-4,"d":"-0.00017185"},{"v":-6.91e-06,"d":"-0.00000691"},{"v":-2.9000000000000003E-7,"d":"-0.00000029"},{"$nulls":3},-0.00068741,{"v":-2.766e-05,"d":"-0.00002766"},{"v":-1.16e-06,"d":"-0.00000116"}]
[null,"Oktober",null,{"v":-2.92786E-3,"d":"-0.00292786"},-0.00081532,{"v":-3.173e-05,"d":"-0.00003173"},{"v":-1.33E-6,"d":"-0.00000133"},null,null,-0.00073196,-0.00020383,{"v":-7.93e-06,"d":"-0.00000793"},{"v":-3.4000000000000003E-7,"d":"-0.00000034"},null,null,{"v":-2.92786E-3,"d":"-0.00292786"},-0.00081532,{"v":-3.173e-05,"d":"-0.00003173"},{"v":-1.33E-6,"d":"-0.00000133"}]
[null,"November",null,null,{"v":-0.0011716,"d":"-0.00117160"},{"v":-4.709e-05,"d":"-0.00004709"},{"v":-1.9699999999999998E-6,"d":"-0.00000197"},{"$nulls":3},{"v":-0.0002929,"d":"-0.00029290"},{"v":-1.177e-05,"d":"-0.00001177"},{"v":-5e-07,"d":"-0.00000050"},{"$nulls":3},{"v":-0.0011716,"d":"-0.00117160"},{"v":-4.709e-05,"d":"-0.00004709"},{"v":-1.9699999999999998E-6,"d":"-0.00000197"}]
[null,"December",null,null,{"v":-1.52564E-3,"d":"-0.00152564"},{"v":-5.935e-05,"d":"-0.00005935"},{"v":-2.48E-6,"d":"-0.00000248"},{"$nulls":3},{"v":-3.8141E-4,"d":"-0.00038141"},{"v":-1.484E-5,"d":"-0.00001484"},{"v":-6.2e-07,"d":"-0.00000062"},{"$nulls":3},{"v":-1.52564E-3,"d":"-0.00152564"},{"v":-5.935e-05,"d":"-0.00005935"},{"v":-2.48E-6,"d":"-0.00000248"}]
[]
[null,"Charge FIRM capacity for interconnection points","EXIT NON-STORAGE",{"$nulls":5},"EXIT STORAGE"]
[null,"Payable charge FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"Januari",-0.00782656,-0.00357502,{"v":-0.00171,"d":"-0.00171000"},{"v":-6.653e-05,"d":"-0.00006653"},{"v":-2.78e-06,"d":"-0.00000278"},null,-0.00195664,-0.00089376,{"v":-0.0004275,"d":"-0.00042750"},{"v":-1.663e-05,"d":"-0.00001663"},{"v":-7e-07,"d":"-0.00000070"}]
[null,"Februari",null,null,{"v":-0.0013806,"d":"-0.00138060"},{"v":-5.948E-5,"d":"-0.00005948"},{"v":-2.48E-6,"d":"-0.00000248"},{"$nulls":3},-0.00034515,{"v":-1.487E-5,"d":"-0.00001487"},{"v":-6.2e-07,"d":"-0.00000062"}]
[null,"Maart",null,null,{"v":-0.0011955,"d":"-0.00119550"},{"v":-4.649e-05,"d":"-0.00004649"},{"v":-1.94e-06,"d":"-0.00000194"},{"$nulls":3},-0.00029888,{"v":-1.162e-05,"d":"-0.00001162"},{"v":-4.9e-07,"d":"-0.00000049"}]
[null,"April",null,-0.00191225,-0.00086264,{"v":-3.467e-05,"d":"-0.00003467"},{"v":-1.4499999999999999E-6,"d":"-0.00000145"},null,null,-0.00047806,-0.00021566,{"v":-8.67E-6,"d":"-0.00000867"},{"v":-3.7E-7,"d":"-0.00000037"}]
[null,"Mei",null,null,-0.00078969,{"v":-3.073e-05,"d":"-0.00003073"},{"v":-1.29e-06,"d":"-0.00000129"},{"$nulls":3},-0.00019742,{"v":-7.68e-06,"d":"-0.00000768"},{"v":-3.3e-07,"d":"-0.00000033"}]
[null,"Juni",null,null,{"v":-6.4167E-4,"d":"-0.00064167"},{"v":-2.582E-5,"d":"-0.00002582"},{"v":-1.0799999999999998E-6,"d":"-0.00000108"},{"$nulls":3},-0.00016042,{"v":-6.45e-06,"d":"-0.00000645"},{"v":-2.7e-07,"d":"-0.00000027"}]
[null,"Juli",null,{"v":-1.55105E-3,"d":"-0.00155105"},{"v":-6.2617E-4,"d":"-0.00062617"},{"v":-2.435e-05,"d":"-0.00002435"},{"v":-1.02E-6,"d":"-0.00000102"},null,null,-0.00038776,-0.00015654,{"v":-6.09e-06,"d":"-0.00000609"},{"v":-2.6E-7,"d":"-0.00000026"}]
[null,"Augustus",null,null,-0.00059526,{"v":-2.319E-5,"d":"-0.00002319"},{"v":-9.6999999999999982E-7,"d":"-0.00000097"},{"$nulls":3},-0.00014881,{"v":-5.8e-06,"d":"-0.00000580"},{"v":-2.5e-07,"d":"-0.00000025"}]
[null,"September",null,null,-0.00063974,{"v":-2.574e-05,"d":"-0.00002574"},{"v":-1.0799999999999998E-6,"d":"-0.00000108"},{"$nulls":3},-0.00015994,{"v":-6.44e-06,"d":"-0.00000644"},{"v":-2.7e-07,"d":"-0.00000027"}]
[null,"Oktober",null,-0.00272482,-0.00075878,{"v":-2.953E-5,"d":"-0.00002953"},{"v":-1.24E-6,"d":"-0.00000124"},null,null,-0.00068121,-0.00018969,{"v":-7.38e-06,"d":"-0.00000738"},{"v":-3.1E-7,"d":"-0.00000031"}]
[null,"November",null,null,-0.00109036,{"v":-4.383e-05,"d":"-0.00004383"},{"v":-1.8299999999999998E-6,"d":"-0.00000183"},{"$nulls":3},-0.00027259,{"v":-1.096E-5,"d":"-0.00001096"},{"v":-4.6e-07,"d":"-0.00000046"}]
[null,"December",null,null,-0.00141984,{"v":-5.524E-5,"d":"-0.00005524"},{"v":-2.31e-06,"d":"-0.00000231"},{"$nulls":3},-0.00035496,{"v":-1.381E-5,"d":"-0.00001381"},{"v":-5.8000000000000006E-7,"d":"-0.00000058"}]
{"$rows_empty":32}
[null,"Multipliers (M)"]
[]
[null,"Quaterly multiplier"]
[null,"Monthly multiplier"]
[null,"Daily multiplier"]
[null,"Within-day multiplier"]
[]
[null,"Seasonal factors (SF)","WID"]
[]
[null,"SF - Jan",1.877]
[null,"SF - Feb",1.753]
[null,"SF - March",1.269]
[null,"SF - April",0.903]
[null,"SF - May",0.711]
[null,"SF - June",0.631]
[null,"SF - July",0.583]
[null,"SF - August",0.555]
[null,"SF - Sept",0.604]
[null,"SF - Oct",0.784]
[null,"SF - Nov",1.269]
[null,"SF - Dec",1.677]
[]
[null,"SF - Jan - March"]
[null,"SF - April - June"]
[null,"SF - July - Sept"]
[null,"SF - Oct - Dec"]

{"sheet":"Booking in Y-Q-M products","index":5,"n_rows":26,"n_cols":16,"rows_kept":26,"merged":[[5,1,5,2],[5,5,5,8],[9,5,9,9],[9,11,9,15]]}
[]
[]
[]
[null,"CONVERTED PROFILED BOOKING INTO YEARLY, QUARTERLY AND MONTHLY CAPACITY PRODUCTS AND optimised CAPACITY PRODUCTS"]
[]
[null,"DESIRED PROFILED CAPACITY BOOKING",{"$nulls":3},"YOUR SAVINGS DUE TO OPTIMISATION",{"$nulls":3},{"$f":"J26-P26","v":{"v":2746726.1400000006,"d":"€ 2,746,726"}}]
[]
[null,"Postage stamp point",{"$f":"'Profiled booking'!C7","v":"Entry regular"}]
[null,"Starting month",{"$f":"'Profiled booking'!C8","v":"January"}]
[null,"February capacity in leap year",{"$f":"'Profiled booking'!C9","v":"No"},null,null,"PROFILED BOOKING CONVERTED INTO Y, Q, M CAPACITY PRODUCTS",{"$nulls":5},"PROFILE BOOKING optimised INTO Y, Q, M CAPACITY PRODUCTS"]
[]
[null,"Month","Desired profiled capacity booking",null,null,"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Total capacity booking","Expected monthly invoice",null,"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Total capacity booking","Expected monthly invoice"]
[null,null,"kWh/h/y",null,null,"kWh/h","kWh/h","kWh/h","kWh/h","EUR",null,"kWh/h","kWh/h","kWh/h","kWh/h","EUR"]
[null,"January",{"$f":"IF('Profiled booking'!C13<0,0,'Profiled booking'!C13)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F11","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!G11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUM(F14:H14)","v":{"v":7000000,"d":"7,000,000"}},{"$f":"Optimisation!H62","v":{"v":5965589.694234398,"d":"€ 5,965,590"}},null,{"$f":"Optimisation!J11","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!L11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUM(L14:N14)","v":{"v":7000000,"d":"7,000,000"}},{"$f":"Optimisation!M62","v":{"v":4380653.12983866,"d":"€ 4,380,653"}}]
[null,"February",{"$f":"IF('Profiled booking'!C14<0,0,'Profiled booking'!C14)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E12","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F12","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!G12","v":{"v":1000000,"d":"1,000,000"}},{"v":7000000,"d":"7,000,000"},{"$f":"Optimisation!H63","v":{"v":5273666.147695585,"d":"€ 5,273,666"}},null,{"$f":"Optimisation!J12","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K12","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!L12","v":{"v":1000000,"d":"1,000,000"}},{"v":7000000,"d":"7,000,000"},{"$f":"Optimisation!M63","v":{"v":3842110.541144597,"d":"€ 3,842,111"}}]
[null,"March",{"$f":"IF('Profiled booking'!C15<0,0,'Profiled booking'!C15)","v":{"v":6000000,"d":"6,000,000"}},null,null,{"$f":"Optimisation!E13","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F13","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!G13","v":0},{"v":6000000,"d":"6,000,000"},{"$f":"Optimisation!H64","v":{"v":4769915.404234398,"d":"€ 4,769,915"}},null,{"$f":"Optimisation!J13","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K13","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!L13","v":0},{"v":6000000,"d":"6,000,000"},{"$f":"Optimisation!M64","v":{"v":3184978.8398386603,"d":"€ 3,184,979"}}]
[null,"April",{"$f":"IF('Profiled booking'!C16<0,0,'Profiled booking'!C16)","v":{"v":6000000,"d":"6,000,000"}},null,null,{"$f":"Optimisation!E14","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F14","v":0},{"$f":"Optimisation!G14","v":{"v":5000000,"d":"5,000,000"}},{"v":6000000,"d":"6,000,000"},{"$f":"Optimisation!H65","v":{"v":3465690.032054794,"d":"€ 3,465,690"}},null,{"$f":"Optimisation!J14","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K14","v":0},{"$f":"Optimisation!L14","v":{"v":1000000,"d":"1,000,000"}},{"v":6000000,"d":"6,000,000"},{"$f":"Optimisation!M65","v":{"v":2852166.1602739724,"d":"€ 2,852,166"}}]
[null,"May",{"$f":"IF('Profiled booking'!C17<0,0,'Profiled booking'!C17)","v":{"v":5000000,"d":"5,000,000"}},null,null,{"$f":"Optimisation!E15","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F15","v":0},{"$f":"Optimisation!G15","v":{"v":4000000,"d":"4,000,000"}},{"v":5000000,"d":"5,000,000"},{"$f":"Optimisation!H66","v":{"v":2673476.5831232877,"d":"€ 2,673,477"}},null,{"$f":"Optimisation!J15","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K15","v":0},{"$f":"Optimisation!L15","v":0},{"v":5000000,"d":"5,000,000"},{"$f":"Optimisation!M66","v":{"v":2323953.9156164383,"d":"€ 2,323,954"}}]
[null,"June",{"$f":"IF('Profiled booking'!C18<0,0,'Profiled booking'!C18)","v":{"v":1000000,"d":"1,000,000"}},null,null,{"$f":"Optimisation!E16","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F16","v":0},{"$f":"Optimisation!G16","v":0},{"v":1000000,"d":"1,000,000"},{"$f":"Optimisation!H67","v":{"v":449797.5320547945,"d":"€ 449,798"}},null,{"$f":"Optimisation!J16","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K16","v":0},{"$f":"Optimisation!L16","v":0},{"v":5000000,"d":"5,000,000"},{"$f":"Optimisation!M67","v":{"v":2248987.6602739724,"d":"€ 2,248,988"}}]
[null,"July",{"$f":"IF('Profiled booking'!C19<0,0,'Profiled booking'!C19)","v":{"v":2000000,"d":"2,000,000"}},null,null,{"$f":"Optimisation!E17","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F17","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!G17","v":0},{"v":2000000,"d":"2,000,000"},{"$f":"Optimisation!H68","v":{"v":830232.5343189398,"d":"€ 830,233"}},null,{"$f":"Optimisation!J17","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K17","v":0},{"$f":"Optimisation!L17","v":0},{"v":5000000,"d":"5,000,000"},{"$f":"Optimisation!M68","v":{"v":2323953.9156164383,"d":"€ 2,323,954"}}]
[null,"August",{"$f":"IF('Profiled booking'!C20<0,0,'Profiled booking'!C20)","v":{"v":3000000,"d":"3,000,000"}},null,null,{"$f":"Optimisation!E18","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F18","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!G18","v":{"v":1000000,"d":"1,000,000"}},{"v":3000000,"d":"3,000,000"},{"$f":"Optimisation!H69","v":{"v":1246452.68431894,"d":"€ 1,246,453"}},null,{"$f":"Optimisation!J18","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K18","v":0},{"$f":"Optimisation!L18","v":0},{"v":5000000,"d":"5,000,000"},{"$f":"Optimisation!M69","v":{"v":2323953.9156164383,"d":"€ 2,323,954"}}]
[null,"September",{"$f":"IF('Profiled booking'!C21<0,0,'Profiled booking'!C21)","v":{"v":4000000,"d":"4,000,000"}},null,null,{"$f":"Optimisation!E19","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F19","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!G19","v":{"v":2000000,"d":"2,000,000"}},{"v":4000000,"d":"4,000,000"},{"$f":"Optimisation!H70","v":{"v":1698098.1396634902,"d":"€ 1,698,098"}},null,{"$f":"Optimisation!J19","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K19","v":0},{"$f":"Optimisation!L19","v":0},{"v":5000000,"d":"5,000,000"},{"$f":"Optimisation!M70","v":{"v":2248987.6602739724,"d":"€ 2,248,988"}}]
[null,"October",{"$f":"IF('Profiled booking'!C22<0,0,'Profiled booking'!C22)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E20","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F20","v":{"v":6000000,"d":"6,000,000"}},{"$f":"Optimisation!G20","v":0},{"v":7000000,"d":"7,000,000"},{"$f":"Optimisation!H71","v":{"v":4316744.399210244,"d":"€ 4,316,744"}},null,{"$f":"Optimisation!J20","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K20","v":{"v":2000000,"d":"2,000,000"}},{"$f":"Optimisation!L20","v":0},{"v":7000000,"d":"7,000,000"},{"$f":"Optimisation!M71","v":{"v":3607938.4543120903,"d":"€ 3,607,938"}}]
[null,"November",{"$f":"IF('Profiled booking'!C23<0,0,'Profiled booking'!C23)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E21","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F21","v":{"v":6000000,"d":"6,000,000"}},{"$f":"Optimisation!G21","v":0},{"v":7000000,"d":"7,000,000"},{"$f":"Optimisation!H72","v":{"v":4177494.579880881,"d":"€ 4,177,495"}},null,{"$f":"Optimisation!J21","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K21","v":{"v":2000000,"d":"2,000,000"}},{"$f":"Optimisation!L21","v":0},{"v":7000000,"d":"7,000,000"},{"$f":"Optimisation!M72","v":{"v":3491553.342882668,"d":"€ 3,491,553"}}]
[null,"December",{"$f":"IF('Profiled booking'!C24<0,0,'Profiled booking'!C24)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E22","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F22","v":{"v":6000000,"d":"6,000,000"}},{"$f":"Optimisation!G22","v":0},{"v":7000000,"d":"7,000,000"},{"$f":"Optimisation!H73","v":{"v":4316744.399210244,"d":"€ 4,316,744"}},null,{"$f":"Optimisation!J22","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K22","v":{"v":2000000,"d":"2,000,000"}},{"$f":"Optimisation!L22","v":0},{"v":7000000,"d":"7,000,000"},{"$f":"Optimisation!M73","v":{"v":3607938.4543120903,"d":"€ 3,607,938"}}]
[{"$nulls":8},{"$f":"SUM(I14:I25)","v":{"v":62000000,"d":"62,000,000"}},{"$f":"SUM(J14:J25)","v":{"v":39183902.129999995,"d":"€ 39,183,902"}},{"$nulls":4},{"$f":"SUM(O14:O25)","v":{"v":72000000,"d":"72,000,000"}},{"$f":"SUM(P14:P25)","v":{"v":36437175.989999995,"d":"€ 36,437,176"}}]

{"sheet":"Monthly invoice","index":6,"n_rows":44,"n_cols":14,"rows_kept":44,"merged":[[5,1,5,2],[5,5,5,7],[9,5,9,8],[9,10,9,13],[27,1,27,3],[27,5,27,8],[27,10,27,13],[29,1,29,3],[30,1,30,3],[31,1,42,1],[31,2,33,2],[31,5,42,5],[31,6,33,6],[31,10,42,10],[31,11,33,11],[34,2,36,2],[34,6,36,6],[34,11,36,11],[37,2,39,2],[37,6,39,6],[37,11,39,11],[40,2,42,2],[40,6,42,6],[40,11,42,11]]}
[]
[]
[]
[null,"CONVERTED PROFILED BOOKING INTO NON-optimised AND optimised CAPACITY PRODUCTS"]
[]
[null,"DESIRED PROFILED CAPACITY BOOKING",{"$nulls":3},"YOUR SAVINGS DUE TO OPTIMISATION",null,null,{"$f":"I44-N44","v":{"v":2746726.1400000006,"d":"€ 2,746,726"}}]
[]
[null,"Postage stamp point",{"$f":"'Profiled booking'!C7","v":"Entry regular"}]
[null,"Starting month",{"$f":"'Profiled booking'!C8","v":"January"}]
[null,"February capacity in leap year",{"$f":"'Profiled booking'!C9","v":"No"},null,null,"PROFILED BOOKING CONVERTED INTO Y, Q, M CAPACITY PRODUCTS",{"$nulls":4},"PROFILE BOOKING optimised INTO Y, Q, M CAPACITY PRODUCTS"]
[]
[null,"Month","Desired profiled capacity booking",null,null,"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Total capacity booking",null,"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Total capacity booking"]
[null,null,"kWh/h/y",null,null,"kWh/h","kWh/h","kWh/h","kWh/h",null,"kWh/h","kWh/h","kWh/h","kWh/h"]
[null,"January",{"$f":"IF('Profiled booking'!C13<0,0,'Profiled booking'!C13)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F11","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!G11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUM(F14:H14)","v":{"v":7000000,"d":"7,000,000"}},null,{"$f":"Optimisation!J11","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!L11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUM(K14:M14)","v":{"v":7000000,"d":"7,000,000"}}]
[null,"February",{"$f":"IF('Profiled booking'!C14<0,0,'Profiled booking'!C14)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E12","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F12","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!G12","v":{"v":1000000,"d":"1,000,000"}},{"v":7000000,"d":"7,000,000"},null,{"$f":"Optimisation!J12","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K12","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!L12","v":{"v":1000000,"d":"1,000,000"}},{"v":7000000,"d":"7,000,000"}]
[null,"March",{"$f":"IF('Profiled booking'!C15<0,0,'Profiled booking'!C15)","v":{"v":6000000,"d":"6,000,000"}},null,null,{"$f":"Optimisation!E13","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F13","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!G13","v":0},{"v":6000000,"d":"6,000,000"},null,{"$f":"Optimisation!J13","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K13","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!L13","v":0},{"v":6000000,"d":"6,000,000"}]
[null,"April",{"$f":"IF('Profiled booking'!C16<0,0,'Profiled booking'!C16)","v":{"v":6000000,"d":"6,000,000"}},null,null,{"$f":"Optimisation!E14","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F14","v":0},{"$f":"Optimisation!G14","v":{"v":5000000,"d":"5,000,000"}},{"v":6000000,"d":"6,000,000"},null,{"$f":"Optimisation!J14","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K14","v":0},{"$f":"Optimisation!L14","v":{"v":1000000,"d":"1,000,000"}},{"v":6000000,"d":"6,000,000"}]
[null,"May",{"$f":"IF('Profiled booking'!C17<0,0,'Profiled booking'!C17)","v":{"v":5000000,"d":"5,000,000"}},null,null,{"$f":"Optimisation!E15","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F15","v":0},{"$f":"Optimisation!G15","v":{"v":4000000,"d":"4,000,000"}},{"v":5000000,"d":"5,000,000"},null,{"$f":"Optimisation!J15","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K15","v":0},{"$f":"Optimisation!L15","v":0},{"v":5000000,"d":"5,000,000"}]
[null,"June",{"$f":"IF('Profiled booking'!C18<0,0,'Profiled booking'!C18)","v":{"v":1000000,"d":"1,000,000"}},null,null,{"$f":"Optimisation!E16","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F16","v":0},{"$f":"Optimisation!G16","v":0},{"v":1000000,"d":"1,000,000"},null,{"$f":"Optimisation!J16","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K16","v":0},{"$f":"Optimisation!L16","v":0},{"v":5000000,"d":"5,000,000"}]
[null,"July",{"$f":"IF('Profiled booking'!C19<0,0,'Profiled booking'!C19)","v":{"v":2000000,"d":"2,000,000"}},null,null,{"$f":"Optimisation!E17","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F17","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!G17","v":0},{"v":2000000,"d":"2,000,000"},null,{"$f":"Optimisation!J17","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K17","v":0},{"$f":"Optimisation!L17","v":0},{"v":5000000,"d":"5,000,000"}]
[null,"August",{"$f":"IF('Profiled booking'!C20<0,0,'Profiled booking'!C20)","v":{"v":3000000,"d":"3,000,000"}},null,null,{"$f":"Optimisation!E18","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F18","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!G18","v":{"v":1000000,"d":"1,000,000"}},{"v":3000000,"d":"3,000,000"},null,{"$f":"Optimisation!J18","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K18","v":0},{"$f":"Optimisation!L18","v":0},{"v":5000000,"d":"5,000,000"}]
[null,"September",{"$f":"IF('Profiled booking'!C21<0,0,'Profiled booking'!C21)","v":{"v":4000000,"d":"4,000,000"}},null,null,{"$f":"Optimisation!E19","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F19","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!G19","v":{"v":2000000,"d":"2,000,000"}},{"v":4000000,"d":"4,000,000"},null,{"$f":"Optimisation!J19","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K19","v":0},{"$f":"Optimisation!L19","v":0},{"v":5000000,"d":"5,000,000"}]
[null,"October",{"$f":"IF('Profiled booking'!C22<0,0,'Profiled booking'!C22)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E20","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F20","v":{"v":6000000,"d":"6,000,000"}},{"$f":"Optimisation!G20","v":0},{"v":7000000,"d":"7,000,000"},null,{"$f":"Optimisation!J20","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K20","v":{"v":2000000,"d":"2,000,000"}},{"$f":"Optimisation!L20","v":0},{"v":7000000,"d":"7,000,000"}]
[null,"November",{"$f":"IF('Profiled booking'!C23<0,0,'Profiled booking'!C23)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E21","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F21","v":{"v":6000000,"d":"6,000,000"}},{"$f":"Optimisation!G21","v":0},{"v":7000000,"d":"7,000,000"},null,{"$f":"Optimisation!J21","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K21","v":{"v":2000000,"d":"2,000,000"}},{"$f":"Optimisation!L21","v":0},{"v":7000000,"d":"7,000,000"}]
[null,"December",{"$f":"IF('Profiled booking'!C24<0,0,'Profiled booking'!C24)","v":{"v":7000000,"d":"7,000,000"}},null,null,{"$f":"Optimisation!E22","v":{"v":1000000,"d":"1,000,000"}},{"$f":"Optimisation!F22","v":{"v":6000000,"d":"6,000,000"}},{"$f":"Optimisation!G22","v":0},{"v":7000000,"d":"7,000,000"},null,{"$f":"Optimisation!J22","v":{"v":5000000,"d":"5,000,000"}},{"$f":"Optimisation!K22","v":{"v":2000000,"d":"2,000,000"}},{"$f":"Optimisation!L22","v":0},{"v":7000000,"d":"7,000,000"}]
[{"$nulls":8},{"$f":"SUM(I14:I25)","v":{"v":62000000,"d":"62,000,000"}},{"$nulls":4},{"$f":"SUM(N14:N25)","v":{"v":72000000,"d":"72,000,000"}}]
[]
[null,"RESERVE PRICES",{"$nulls":3},"EXPECTED INVOICE CONVERTED PROFILE",{"$nulls":4},"EXPECTED INVOICE optimised PROFILE"]
[]
[{"$nulls":5},"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Expected monthly invoice non-optimised",null,"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Expected monthly invoice optimised"]
[{"$nulls":5},"EUR","EUR","EUR","EUR",null,"EUR","EUR","EUR","EUR"]
[null,{"$f":"Optimisation!B79","v":{"v":5.4725366399999995,"d":"€ 5.47253664"}},{"$f":"Optimisation!C79","v":{"v":2.4997497799999997,"d":"€ 2.49974978"}},{"$f":"Optimisation!D79","v":{"v":1.19567429,"d":"€ 1.19567429"}},null,{"$f":"F14*B32","v":{"v":5472536.64,"d":"€ 5,472,537"}},{"$f":"G14*C32","v":{"v":12498748.899999999,"d":"€ 12,498,749"}},{"$f":"H14*D32","v":{"v":1195674.2899999998,"d":"€ 1,195,674"}},{"$f":"Optimisation!H62","v":{"v":5965589.694234398,"d":"5,965,590"}},null,{"$f":"K14*B32","v":{"v":27362683.2,"d":"€ 27,362,683"}},{"$f":"L14*C32","v":{"v":2499749.78,"d":"€ 2,499,750"}},{"$f":"M14*D32","v":{"v":1195674.2899999998,"d":"€ 1,195,674"}},{"$f":"Optimisation!M62","v":{"v":4380653.12983866,"d":"4,380,653"}}]
[{"$nulls":3},{"$f":"Optimisation!D80","v":{"v":0.96535546,"d":"€ 0.96535546"}},{"$nulls":3},{"$f":"H15*D33","v":{"v":965355.4600000001,"d":"€ 965,355"}},{"$f":"Optimisation!H63","v":{"v":5273666.147695585,"d":"5,273,666"}},{"$nulls":3},{"$f":"M15*D33","v":{"v":965355.4600000001,"d":"€ 965,355"}},{"$f":"Optimisation!M63","v":{"v":3842110.541144597,"d":"3,842,111"}}]
[{"$nulls":3},{"$f":"Optimisation!D81","v":{"v":0.83592623,"d":"€ 0.83592623"}},{"$nulls":3},0,{"$f":"Optimisation!H64","v":{"v":4769915.404234398,"d":"4,769,915"}},{"$nulls":3},0,{"$f":"Optimisation!M64","v":{"v":3184978.8398386603,"d":"3,184,979"}}]
[null,null,{"$f":"Optimisation!C82","v":{"v":1.33709813,"d":"€ 1.33709813"}},{"$f":"Optimisation!D82","v":{"v":0.6031785,"d":"€ 0.60317850"}},null,null,{"$f":"G17*C35","v":0},{"v":3015892.4999999995,"d":"€ 3,015,893"},{"$f":"Optimisation!H65","v":{"v":3465690.032054794,"d":"3,465,690"}},null,null,{"$f":"L17*C35","v":0},{"v":603178.5,"d":"€ 603,179"},{"$f":"Optimisation!M65","v":{"v":2852166.1602739724,"d":"2,852,166"}}]
[{"$nulls":3},{"$f":"Optimisation!D83","v":{"v":0.55217145,"d":"€ 0.55217145"}},{"$nulls":3},{"v":2208685.8,"d":"€ 2,208,686"},{"$f":"Optimisation!H66","v":{"v":2673476.5831232877,"d":"2,673,477"}},{"$nulls":3},0,{"$f":"Optimisation!M66","v":{"v":2323953.9156164383,"d":"2,323,954"}}]
[{"$nulls":3},{"$f":"Optimisation!D84","v":{"v":0.44867303999999997,"d":"€ 0.44867304"}},{"$nulls":3},0,{"$f":"Optimisation!H67","v":{"v":449797.5320547945,"d":"449,798"}},{"$nulls":3},0,{"$f":"Optimisation!M67","v":{"v":2248987.6602739724,"d":"2,248,988"}}]
[null,null,{"$f":"Optimisation!C85","v":{"v":1.0845368100000001,"d":"€ 1.08453681"}},{"$f":"Optimisation!D85","v":{"v":0.43783290999999996,"d":"€ 0.43783291"}},null,null,{"$f":"G20*C38","v":{"v":1084536.81,"d":"€ 1,084,537"}},0,{"$f":"Optimisation!H68","v":{"v":830232.5343189398,"d":"830,233"}},null,null,{"$f":"L20*C38","v":0},0,{"$f":"Optimisation!M68","v":{"v":2323953.9156164383,"d":"2,323,954"}}]
[{"$nulls":3},{"$f":"Optimisation!D86","v":{"v":0.41622015,"d":"€ 0.41622015"}},{"$nulls":3},{"v":416220.15,"d":"€ 416,220"},{"$f":"Optimisation!H69","v":{"v":1246452.68431894,"d":"1,246,453"}},{"$nulls":3},0,{"$f":"Optimisation!M69","v":{"v":2323953.9156164383,"d":"2,323,954"}}]
[{"$nulls":3},{"$f":"Optimisation!D87","v":{"v":0.44732365,"d":"€ 0.44732365"}},{"$nulls":3},{"v":894647.3,"d":"€ 894,647"},{"$f":"Optimisation!H70","v":{"v":1698098.1396634902,"d":"1,698,098"}},{"$nulls":3},0,{"$f":"Optimisation!M70","v":{"v":2248987.6602739724,"d":"2,248,988"}}]
[null,null,{"$f":"Optimisation!C88","v":{"v":1.90526738,"d":"€ 1.90526738"}},{"$f":"Optimisation!D88","v":{"v":0.5305586800000001,"d":"€ 0.53055868"}},null,null,{"$f":"G23*C41","v":{"v":11431604.28,"d":"€ 11,431,604"}},0,{"$f":"Optimisation!H71","v":{"v":4316744.399210244,"d":"4,316,744"}},null,null,{"$f":"L23*C41","v":{"v":3810534.76,"d":"€ 3,810,535"}},0,{"$f":"Optimisation!M71","v":{"v":3607938.4543120903,"d":"3,607,938"}}]
[{"$nulls":3},{"$f":"Optimisation!D89","v":{"v":0.7624068199999999,"d":"€ 0.76240682"}},{"$nulls":3},0,{"$f":"Optimisation!H72","v":{"v":4177494.579880881,"d":"4,177,495"}},{"$nulls":3},0,{"$f":"Optimisation!M72","v":{"v":3491553.342882668,"d":"3,491,553"}}]
[{"$nulls":3},{"$f":"Optimisation!D90","v":{"v":0.99279312,"d":"€ 0.99279312"}},{"$nulls":3},0,{"$f":"Optimisation!H73","v":{"v":4316744.399210244,"d":"4,316,744"}},{"$nulls":3},0,{"$f":"Optimisation!M73","v":{"v":3607938.4543120903,"d":"3,607,938"}}]
[{"$nulls":5},{"$f":"SUM(F32:F43)","v":{"v":5472536.64,"d":"€ 5,472,537"}},{"$f":"SUM(G32:G43)","v":{"v":25014889.99,"d":"€ 25,014,890"}},{"$f":"SUM(H32:H43)","v":{"v":8696475.5,"d":"€ 8,696,476"}},{"$f":"SUM(I32:I43)","v":{"v":39183902.129999995,"d":"39,183,902"}},null,{"$f":"SUM(K32:K43)","v":{"v":27362683.2,"d":"€ 27,362,683"}},{"$f":"SUM(L32:L43)","v":{"v":6310284.539999999,"d":"€ 6,310,285"}},{"$f":"SUM(M32:M43)","v":{"v":2764208.25,"d":"€ 2,764,208"}},{"$f":"SUM(N32:N43)","v":{"v":36437175.989999995,"d":"36,437,176"}}]

{"sheet":"bladen rechts alleen voor inter","index":7,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[]
[]
[]
[null,"De tabbladen rechts zijn alleen voor intern gebruik beschikbaar. Voor extern gebruik zullen deze worden verborgen."]

{"sheet":"Multipliers and SF","index":8,"n_rows":31,"n_cols":6,"rows_kept":31,"hidden":true}
[]
[]
[]
[null,"MULTIPLIERS AND SEASONAL FACTORS"]
[]
[null,"Multipliers (M)"]
[]
[null,"Quarterly multiplier","M-Q",1.25]
[null,"Monthly multiplier","M-M",1.5]
[null,"Daily multiplier","M-DA",1.75]
[null,"Within-day multiplier","M-WID",1.75]
[]
[null,"Seasonal factors (SF)",null,"Month","Day","WID"]
[]
[null,"SF - Jan",null,1.715,1.773,1.773]
[null,"SF - Feb",null,1.533,1.585,1.585]
[null,"SF - March",null,1.199,1.239,1.239]
[null,"SF - April",null,0.894,0.924,0.924]
[null,"SF - May",null,0.792,0.819,0.819]
[null,"SF - June",null,0.665,0.688,0.688]
[null,"SF - July",null,0.628,0.649,0.649]
[null,"SF - August",null,0.597,0.618,0.618]
[null,"SF - Sept",null,0.663,0.686,0.686]
[null,"SF - Oct",null,0.761,0.787,0.787]
[null,"SF - Nov",null,{"v":1.13,"d":"1.130"},1.168,1.168]
[null,"SF - Dec",null,1.424,1.472,1.472]
[]
[null,"SF - Jan - March",null,1.482]
[null,"SF - April - June",null,0.784]
[null,"SF - July - Sept",null,0.629]
[null,"SF - Oct - Dec",null,1.105]

{"sheet":"Validation","index":9,"n_rows":15,"n_cols":3,"rows_kept":15,"hidden":true}
[]
[]
[]
[null,"VALIDATION POSTAGE STAMP POINTS"]
[]
[null,null,"Entry regular"]
[null,null,"Entry storage"]
[null,null,"Entry LNG"]
[null,null,"Exit non-storage"]
[null,null,"Exit storage"]
[]
[null,"VALIDATION FEBRUARY IN LEAP YEAR"]
[]
[null,null,"Yes"]
[null,null,"No"]

{"sheet":"Optimisation","index":10,"n_rows":227,"n_cols":30,"rows_kept":227,"hidden":true,"merged":[[6,4,6,7],[6,9,6,12],[43,4,43,7],[43,9,43,12],[47,4,58,4],[47,5,49,5],[47,9,58,9],[47,10,49,10],[50,5,52,5],[50,10,52,10],[53,5,55,5],[53,10,55,10],[56,5,58,5],[56,10,58,10],[61,4,72,4],[61,5,63,5],[61,9,72,9],[61,10,63,10],[64,5,66,5],[64,10,66,10],[67,5,69,5],[67,10,69,10],[70,5,72,5],[70,10,72,10],[70,14,72,14],[77,1,77,3],[78,1,89,1],[78,2,80,2],[81,2,83,2],[84,2,86,2],[87,2,89,2]]}
[]
[]
[]
[]
[null,"PROFILED BOOKING CAPACITY PRODUCTS: NON-OPTIMIZED vs OPTIMIZED"]
[]
[{"$nulls":4},"PROFILE BOOKING WITHOUT optimisation",{"$nulls":4},"PROFILE BOOKING WITH optimisation"]
[]
[null,null,"Profiled capacity booking",null,"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Total capacity booking",null,"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Total capacity booking"]
[null,null,"kWh/h",null,"kWh/h","kWh/h","kWh/h","kWh/h",null,"kWh/h","kWh/h","kWh/h","kWh/h"]
[null,"January",{"$f":"IF('Profiled booking'!C13<0,0,'Profiled booking'!C13)","v":{"v":7000000,"d":"7,000,000"}},null,{"$f":"F130","v":{"v":1000000,"d":"1,000,000"}},{"$f":"G130","v":{"v":5000000,"d":"5,000,000"}},{"v":1000000,"d":"1,000,000"},{"$f":"SUM(E11:G11)","v":{"v":7000000,"d":"7,000,000"}},null,{"$f":"F216","v":{"v":5000000,"d":"5,000,000"}},{"$f":"G216","v":{"v":1000000,"d":"1,000,000"}},{"$f":"H216","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUM(J11:L11)","v":{"v":7000000,"d":"7,000,000"}}]
[null,"February",{"$f":"IF('Profiled booking'!C14<0,0,'Profiled booking'!C14)","v":{"v":7000000,"d":"7,000,000"}},null,{"$f":"F131","v":{"v":1000000,"d":"1,000,000"}},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":7000000,"d":"7,000,000"},null,{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,"March",{"$f":"IF('Profiled booking'!C15<0,0,'Profiled booking'!C15)","v":{"v":6000000,"d":"6,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":5000000,"d":"5,000,000"},0,{"v":6000000,"d":"6,000,000"},null,{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":6000000,"d":"6,000,000"}]
[null,"April",{"$f":"IF('Profiled booking'!C16<0,0,'Profiled booking'!C16)","v":{"v":6000000,"d":"6,000,000"}},null,{"v":1000000,"d":"1,000,000"},0,{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},null,{"v":5000000,"d":"5,000,000"},0,{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"}]
[null,"May",{"$f":"IF('Profiled booking'!C17<0,0,'Profiled booking'!C17)","v":{"v":5000000,"d":"5,000,000"}},null,{"v":1000000,"d":"1,000,000"},0,{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},null,{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[null,"June",{"$f":"IF('Profiled booking'!C18<0,0,'Profiled booking'!C18)","v":{"v":1000000,"d":"1,000,000"}},null,{"v":1000000,"d":"1,000,000"},0,0,{"v":1000000,"d":"1,000,000"},null,{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[null,"July",{"$f":"IF('Profiled booking'!C19<0,0,'Profiled booking'!C19)","v":{"v":2000000,"d":"2,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":2000000,"d":"2,000,000"},null,{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[null,"August",{"$f":"IF('Profiled booking'!C20<0,0,'Profiled booking'!C20)","v":{"v":3000000,"d":"3,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":3000000,"d":"3,000,000"},null,{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[null,"September",{"$f":"IF('Profiled booking'!C21<0,0,'Profiled booking'!C21)","v":{"v":4000000,"d":"4,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":2000000,"d":"2,000,000"},{"v":4000000,"d":"4,000,000"},null,{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[null,"October",{"$f":"IF('Profiled booking'!C22<0,0,'Profiled booking'!C22)","v":{"v":7000000,"d":"7,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},0,{"v":7000000,"d":"7,000,000"},null,{"v":5000000,"d":"5,000,000"},{"v":2000000,"d":"2,000,000"},0,{"v":7000000,"d":"7,000,000"}]
[null,"November",{"$f":"IF('Profiled booking'!C23<0,0,'Profiled booking'!C23)","v":{"v":7000000,"d":"7,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},0,{"v":7000000,"d":"7,000,000"},null,{"v":5000000,"d":"5,000,000"},{"v":2000000,"d":"2,000,000"},0,{"v":7000000,"d":"7,000,000"}]
[null,"December",{"$f":"IF('Profiled booking'!C24<0,0,'Profiled booking'!C24)","v":{"v":7000000,"d":"7,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},0,{"v":7000000,"d":"7,000,000"},null,{"v":5000000,"d":"5,000,000"},{"v":2000000,"d":"2,000,000"},0,{"v":7000000,"d":"7,000,000"}]
[null,"Total",{"$f":"SUM(C11:C22)","v":{"v":62000000,"d":"62,000,000"}},{"$nulls":4},{"$f":"SUM(H11:H22)","v":{"v":62000000,"d":"62,000,000"}},{"$nulls":4},{"$f":"SUM(M11:M22)","v":{"v":72000000,"d":"72,000,000"}}]
{"$rows_empty":18}
[null,"PROFILED BOOKING INVOICE: NON-OPTIMIZED vs OPTIMIZED CAPACITY PRODUCTS"]
[]
[{"$nulls":4},"PROFILE BOOKING WITHOUT optimisation",{"$nulls":4},"PROFILE BOOKING WITH optimisation"]
[]
[{"$nulls":4},"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Total capacity booking",null,"Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Total capacity booking"]
[{"$nulls":4},"kWh/h","kWh/h","kWh/h",null,null,"kWh/h","kWh/h","kWh/h"]
[null,"January",null,null,{"$f":"E11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"F11","v":{"v":5000000,"d":"5,000,000"}},{"$f":"G11","v":{"v":1000000,"d":"1,000,000"}},null,null,{"$f":"J11","v":{"v":5000000,"d":"5,000,000"}},{"$f":"K11","v":{"v":1000000,"d":"1,000,000"}},{"$f":"L11","v":{"v":1000000,"d":"1,000,000"}}]
[null,"February",{"$nulls":4},{"$f":"G12","v":{"v":1000000,"d":"1,000,000"}},{"$nulls":4},{"$f":"L12","v":{"v":1000000,"d":"1,000,000"}}]
[null,"March",{"$nulls":4},0,{"$nulls":4},0]
[null,"April",{"$nulls":3},{"$f":"F14","v":0},{"v":5000000,"d":"5,000,000"},{"$nulls":3},{"$f":"K14","v":0},{"v":1000000,"d":"1,000,000"}]
[null,"May",{"$nulls":4},{"v":4000000,"d":"4,000,000"},{"$nulls":4},0]
[null,"June",{"$nulls":4},0,{"$nulls":4},0]
[null,"July",{"$nulls":3},{"$f":"F17","v":{"v":1000000,"d":"1,000,000"}},0,{"$nulls":3},{"$f":"K17","v":0},0]
[null,"August",{"$nulls":4},{"v":1000000,"d":"1,000,000"},{"$nulls":4},0]
[null,"September",{"$nulls":4},{"v":2000000,"d":"2,000,000"},{"$nulls":4},0]
[null,"October",{"$nulls":3},{"$f":"F20","v":{"v":6000000,"d":"6,000,000"}},0,{"$nulls":3},{"$f":"K20","v":{"v":2000000,"d":"2,000,000"}},0]
[null,"November",{"$nulls":4},0,{"$nulls":4},0]
[null,"December",{"$nulls":4},0,{"$nulls":4},0]
[]
[]
[null,"January",null,null,{"$f":"E48*$B$79","v":{"v":5472536.64,"d":"€ 5,472,537"}},{"$f":"F48*$C$79","v":{"v":12498748.899999999,"d":"€ 12,498,749"}},{"$f":"G48*$D79","v":{"v":1195674.2899999998,"d":"€ 1,195,674"}},{"$f":"G62+$F$62*H79/$L$79+$E$62*H79/$L$90","v":{"v":5965589.694234398,"d":"€ 5,965,590"}},null,{"$f":"J48*$B$79","v":{"v":27362683.2,"d":"€ 27,362,683"}},{"$f":"K48*$C$79","v":{"v":2499749.78,"d":"€ 2,499,750"}},{"$f":"L48*$D79","v":{"v":1195674.2899999998,"d":"€ 1,195,674"}},{"$f":"L62+$K$62*H79/$L$79+$J$62*H79/$L$90","v":{"v":4380653.12983866,"d":"€ 4,380,653"}}]
[null,"February",{"$nulls":4},{"v":965355.4600000001,"d":"€ 965,355"},{"$f":"G63+$F$62*H80/$L$79+$E$62*H80/$L$90","v":{"v":5273666.147695585,"d":"€ 5,273,666"}},{"$nulls":3},{"v":965355.4600000001,"d":"€ 965,355"},{"$f":"L63+$K$62*H80/$L$79+$J$62*H80/$L$90","v":{"v":3842110.541144597,"d":"€ 3,842,111"}}]
[null,"March",{"$nulls":4},0,{"$f":"G64+$F$62*H81/$L$79+$E$62*H81/$L$90","v":{"v":4769915.404234398,"d":"€ 4,769,915"}},{"$nulls":3},0,{"$f":"L64+$K$62*H81/$L$79+$J$62*H81/$L$90","v":{"v":3184978.8398386603,"d":"€ 3,184,979"}}]
[null,"April",{"$nulls":3},{"$f":"F51*$C$82","v":0},{"v":3015892.4999999995,"d":"€ 3,015,893"},{"$f":"G65+$F$65*H82/$L$80+$E$62*H82/$L$90","v":{"v":3465690.032054794,"d":"€ 3,465,690"}},null,null,{"$f":"K51*$C$82","v":0},{"v":603178.5,"d":"€ 603,179"},{"$f":"L65+$K$65*H82/$L$80+$J$62*H82/$L$90","v":{"v":2852166.1602739724,"d":"€ 2,852,166"}}]
[null,"May",{"$nulls":4},{"v":2208685.8,"d":"€ 2,208,686"},{"$f":"G66+$F$65*H83/$L$80+$E$62*H83/$L$90","v":{"v":2673476.5831232877,"d":"€ 2,673,477"}},{"$nulls":3},0,{"$f":"L66+$K$65*H83/$L$80+$J$62*H83/$L$90","v":{"v":2323953.9156164383,"d":"€ 2,323,954"}}]
[null,"June",{"$nulls":4},0,{"$f":"G67+$F$65*H84/$L$80+$E$62*H84/$L$90","v":{"v":449797.5320547945,"d":"€ 449,798"}},{"$nulls":3},0,{"$f":"L67+$K$65*H84/$L$80+$J$62*H84/$L$90","v":{"v":2248987.6602739724,"d":"€ 2,248,988"}}]
[null,"July",{"$nulls":3},{"$f":"F54*$C$85","v":{"v":1084536.81,"d":"€ 1,084,537"}},0,{"$f":"G68+$F$68*H85/$L$81+$E$62*H85/$L$90","v":{"v":830232.5343189398,"d":"€ 830,233"}},null,null,{"$f":"K54*$C$85","v":0},0,{"$f":"L68+$K$68*H85/$L$81+$J$62*H85/$L$90","v":{"v":2323953.9156164383,"d":"€ 2,323,954"}}]
[null,"August",{"$nulls":4},{"v":416220.15,"d":"€ 416,220"},{"$f":"G69+$F$68*H86/$L$81+$E$62*H86/$L$90","v":{"v":1246452.68431894,"d":"€ 1,246,453"}},{"$nulls":3},0,{"$f":"L69+$K$68*H86/$L$81+$J$62*H86/$L$90","v":{"v":2323953.9156164383,"d":"€ 2,323,954"}}]
[null,"September",{"$nulls":4},{"v":894647.3,"d":"€ 894,647"},{"$f":"G70+$F$68*H87/$L$81+$E$62*H87/$L$90","v":{"v":1698098.1396634902,"d":"€ 1,698,098"}},{"$nulls":3},0,{"$f":"L70+$K$68*H87/$L$81+$J$62*H87/$L$90","v":{"v":2248987.6602739724,"d":"€ 2,248,988"}}]
[null,"October",{"$nulls":3},{"$f":"F57*$C$88","v":{"v":11431604.28,"d":"€ 11,431,604"}},0,{"$f":"G71+$F$71*H88/$L$82+$E$62*H88/$L$90","v":{"v":4316744.399210244,"d":"€ 4,316,744"}},null,null,{"$f":"K57*$C$88","v":{"v":3810534.76,"d":"€ 3,810,535"}},0,{"$f":"L71+$K$71*H88/$L$82+$J$62*H88/$L$90","v":{"v":3607938.4543120903,"d":"€ 3,607,938"}},null,"Saving \ndue to \noptimisation"]
[null,"November",{"$nulls":4},0,{"$f":"G72+$F$71*H89/$L$82+$E$62*H89/$L$90","v":{"v":4177494.579880881,"d":"€ 4,177,495"}},{"$nulls":3},0,{"$f":"L72+$K$71*H89/$L$82+$J$62*H89/$L$90","v":{"v":3491553.342882668,"d":"€ 3,491,553"}}]
[null,"December",{"$nulls":4},0,{"$f":"G73+$F$71*H90/$L$82+$E$62*H90/$L$90","v":{"v":4316744.399210244,"d":"€ 4,316,744"}},{"$nulls":3},0,{"$f":"L73+$K$71*H90/$L$82+$J$62*H90/$L$90","v":{"v":3607938.4543120903,"d":"€ 3,607,938"}}]
[null,"Total",null,null,{"$f":"SUM(E62:E73)","v":{"v":5472536.64,"d":"€ 5,472,537"}},{"$f":"SUM(F62:F73)","v":{"v":25014889.99,"d":"€ 25,014,890"}},{"$f":"SUM(G62:G73)","v":{"v":8696475.5,"d":"€ 8,696,476"}},{"$f":"E74+F74+G74","v":{"v":39183902.129999995,"d":"€ 39,183,902"}},null,{"$f":"SUM(J62:J73)","v":{"v":27362683.2,"d":"€ 27,362,683"}},{"$f":"SUM(K62:K73)","v":{"v":6310284.539999999,"d":"€ 6,310,285"}},{"$f":"SUM(L62:L73)","v":{"v":2764208.25,"d":"€ 2,764,208"}},{"$f":"J74+K74+L74","v":{"v":36437175.989999995,"d":"€ 36,437,176"}},null,{"$f":"H74-M74","v":{"v":2746726.1400000006,"d":"€ 2,746,726"}}]
[]
[null,"CALCULATION CALCULATION FACTORS & STARTING MONTH & DAYS IN MONTH, QUARTER AND YEAR (LEAP YEAR OR NOT)"]
[]
[null,"Reserve prices",{"$nulls":3},"Seasonal factors","SF - month","Numbers of days",null,"Seasonal factors","SF - quarter",null,null,"Calculation factors","Monthly","Quarterly","Quarterly \nper month"]
[null,{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!C13,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!I13,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!C31,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!I31,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!O13,0)))))","v":{"v":5.4725366399999995,"d":"€ 5.47253664"}},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!D13,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!J13,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!D31,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!J31,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!P13,0)))))","v":{"v":2.4997497799999997,"d":"€ 2.49974978"}},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E13,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K13,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E31,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K31,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q13,0)))))","v":{"v":1.19567429,"d":"€ 1.19567429"}},null,"January",1.715,31,null,"SF - Jan - March",1.482,{"$f":"SUM(H79:H81)","v":90},null,"January",{"$f":"G79*$K$86*$H79/$L$90","v":{"v":0.21848630136986302,"d":"0.2185"}},{"$f":"$K$79*$K$85*L79/$L$90","v":{"v":0.4567808219178082,"d":"0.4568"}},{"$f":"P79/3","v":{"v":0.15226027397260275,"d":"0.1523"}}]
[{"$nulls":3},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E14,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K14,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E32,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K32,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q14,0)))))","v":{"v":0.96535546,"d":"€ 0.96535546"}},null,"February",1.533,{"$f":"IF('Profiled booking'!$C$9=\"Yes\",29,28)","v":28},null,"SF - April - June",0.784,{"$f":"SUM(H82:H84)","v":91},null,"February",{"$f":"G80*$K$86*$H80/$L$90","v":0.1764},{"$f":"$K$79*$K$85*L79/$L$90","v":{"v":0.4567808219178082,"d":"0.4568"}},{"v":0.15226027397260275,"d":"0.1523"}]
[{"$nulls":3},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E15,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K15,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E33,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K33,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q15,0)))))","v":{"v":0.83592623,"d":"€ 0.83592623"}},null,"March",1.199,31,null,"SF - July - Sept",0.629,{"$f":"SUM(H85:H87)","v":92},null,"March",{"v":0.15274931506849318,"d":"0.1527"},{"$f":"$K$79*$K$85*L79/$L$90","v":{"v":0.4567808219178082,"d":"0.4568"}},{"v":0.15226027397260275,"d":"0.1523"}]
[null,null,{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!D16,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!J16,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!D34,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!J34,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!P16,0)))))","v":{"v":1.33709813,"d":"€ 1.33709813"}},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E16,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K16,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E34,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K34,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q16,0)))))","v":{"v":0.6031785,"d":"€ 0.60317850"}},null,"April",0.894,30,null,"SF - Oct - Dec",1.105,{"$f":"SUM(H88:H90)","v":92},null,"April",{"v":0.11021917808219177,"d":"0.1102"},{"$f":"$K$80*$K$85*L80/$L$90","v":{"v":0.24432876712328766,"d":"0.2443"}},{"v":0.08144292237442922,"d":"0.0814"}]
[{"$nulls":3},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E17,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K17,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E35,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K35,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q17,0)))))","v":{"v":0.55217145,"d":"€ 0.55217145"}},null,"May",0.792,31,{"$nulls":5},"May",{"v":0.10089863013698631,"d":"0.1009"},{"$f":"$K$80*$K$85*L80/$L$90","v":{"v":0.24432876712328766,"d":"0.2443"}},{"v":0.08144292237442922,"d":"0.0814"}]
[{"$nulls":3},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E18,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K18,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E36,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K36,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q18,0)))))","v":{"v":0.44867303999999997,"d":"€ 0.44867304"}},null,"June",0.665,30,null,"Multiplier",{"$nulls":3},"June",{"v":0.08198630136986301,"d":"0.0820"},{"$f":"$K$80*$K$85*L80/$L$90","v":{"v":0.24432876712328766,"d":"0.2443"}},{"v":0.08144292237442922,"d":"0.0814"}]
[null,null,{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!D19,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!J19,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!D37,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!J37,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!P19,0)))))","v":{"v":1.0845368100000001,"d":"€ 1.08453681"}},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E19,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K19,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E37,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K37,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q19,0)))))","v":{"v":0.43783290999999996,"d":"€ 0.43783291"}},null,"July",0.628,31,null,"Quarter",{"$f":"'Multipliers and SF'!D8","v":1.25},null,null,"July",{"v":0.08000547945205479,"d":"0.0800"},{"$f":"$K$81*$K$85*L81/$L$90","v":{"v":0.1981780821917808,"d":"0.1982"}},{"v":0.0660593607305936,"d":"0.0661"}]
[{"$nulls":3},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E20,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K20,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E38,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K38,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q20,0)))))","v":{"v":0.41622015,"d":"€ 0.41622015"}},null,"August",0.597,31,null,"Month",{"$f":"'Multipliers and SF'!D9","v":1.5},null,null,"August",{"v":0.07605616438356165,"d":"0.0761"},{"$f":"$K$81*$K$85*L81/$L$90","v":{"v":0.1981780821917808,"d":"0.1982"}},{"v":0.0660593607305936,"d":"0.0661"}]
[{"$nulls":3},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E21,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K21,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E39,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K39,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q21,0)))))","v":{"v":0.44732365,"d":"€ 0.44732365"}},null,"September",0.663,30,{"$nulls":5},"September",{"v":0.08173972602739726,"d":"0.0817"},{"$f":"$K$81*$K$85*L81/$L$90","v":{"v":0.1981780821917808,"d":"0.1982"}},{"v":0.0660593607305936,"d":"0.0661"}]
[null,null,{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!D22,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!J22,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!D40,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!J40,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!P22,0)))))","v":{"v":1.90526738,"d":"€ 1.90526738"}},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E22,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K22,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E40,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K40,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q22,0)))))","v":{"v":0.5305586800000001,"d":"€ 0.53055868"}},null,"October",0.761,31,{"$nulls":5},"October",{"v":0.09694931506849315,"d":"0.0969"},{"$f":"$K$82*$K$85*L82/$L$90","v":{"v":0.34815068493150686,"d":"0.3482"}},{"v":0.11605022831050228,"d":"0.1161"}]
[{"$nulls":3},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E23,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K23,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E41,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K41,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q23,0)))))","v":{"v":0.7624068199999999,"d":"€ 0.76240682"}},null,"November",{"v":1.13,"d":"1.130"},30,null,"Starting month",null,{"$f":"'Profiled booking'!C8","v":"January"},null,"November",{"v":0.13931506849315067,"d":"0.1393"},{"$f":"$K$82*$K$85*L82/$L$90","v":{"v":0.34815068493150686,"d":"0.3482"}},{"v":0.11605022831050228,"d":"0.1161"}]
[{"$nulls":3},{"$f":"IF('Profiled booking'!$C$7='Total prices'!$C$8,'Total prices'!E24,IF('Profiled booking'!$C$7='Total prices'!$I$8,'Total prices'!K24,IF('Profiled booking'!$C$7='Total prices'!$C$26,'Total prices'!E42,IF('Profiled booking'!$C$7='Total prices'!$I$26,'Total prices'!K42,IF('Profiled booking'!$C$7='Total prices'!$O$8,'Total prices'!Q24,0)))))","v":{"v":0.99279312,"d":"€ 0.99279312"}},null,"December",1.424,31,null,"Days in year",null,{"$f":"SUM(H79:H90)","v":365},null,"December",{"v":0.181413698630137,"d":"0.1814"},{"$f":"$K$82*$K$85*L82/$L$90","v":{"v":0.34815068493150686,"d":"0.3482"}},{"v":0.11605022831050228,"d":"0.1161"}]
[]
[null,"DIVIDING INTO TRANCHES OF THE SAME QUANTIY OF CONTRACTED CAPACITY"]
[]
[null,null,"Sorting","Tranches",null,"Tranche 1","Tranche 2","Tranche 3","Tranche 4","Tranche 5","Tranche 6","Tranche 7","Tranche 8","Tranche 9","Tranche 10","Tranche 11","Tranche 12","Total",null,"Total after \ntranche 2","Total after \ntranche 3","Total after \ntranche 4","Total after \ntranche 5","Total after \ntranche 6","Total after \ntranche 7","Total after \ntranche 8","Total after \ntranche 9","Total after \ntranche 10","Total after \ntranche 11","Total after \ntranche 12"]
[{"$nulls":5},{"$f":"D97","v":{"v":1000000,"d":"1,000,000"}},{"$f":"D98","v":{"v":1000000,"d":"1,000,000"}},{"$f":"D99","v":{"v":1000000,"d":"1,000,000"}},{"$f":"D100","v":{"v":1000000,"d":"1,000,000"}},{"$f":"D101","v":{"v":1000000,"d":"1,000,000"}},{"$f":"D102","v":{"v":1000000,"d":"1,000,000"}},{"$f":"D103","v":0},{"$f":"D104","v":{"v":1000000,"d":"1,000,000"}},{"$f":"D105","v":0},{"$f":"D106","v":0},{"$f":"D107","v":0},{"$f":"D108","v":0}]
[]
[null,1,{"$f":"SMALL($C$11:$C$22,B97)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"C97","v":{"v":1000000,"d":"1,000,000"}},null,{"$f":"$F$95","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF($C11>=T97,G$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF($C11>=U97,H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF($C11>=V97,I$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF($C11>=W97,J$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF($C11>=X97,K$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF($C11>=Y97,L$95,0)","v":0},{"$f":"IF($C11>=Z97,M$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF($C11>=AA97,N$95,0)","v":0},{"$f":"IF($C11>=AB97,O$95,0)","v":0},{"$f":"IF($C11>=AC97,P$95,0)","v":0},{"$f":"IF($C11>=AD97,Q$95,0)","v":0},{"$f":"SUM(F97:Q97)","v":{"v":7000000,"d":"7,000,000"}},null,{"$f":"D97+D98","v":{"v":2000000,"d":"2,000,000"}},{"$f":"T97+D99","v":{"v":3000000,"d":"3,000,000"}},{"$f":"U97+D100","v":{"v":4000000,"d":"4,000,000"}},{"$f":"V97+D101","v":{"v":5000000,"d":"5,000,000"}},{"$f":"W97+D102","v":{"v":6000000,"d":"6,000,000"}},{"$f":"X97+D103","v":{"v":6000000,"d":"6,000,000"}},{"$f":"Y97+D104","v":{"v":7000000,"d":"7,000,000"}},{"$f":"Z97+D105","v":{"v":7000000,"d":"7,000,000"}},{"$f":"AA97+D106","v":{"v":7000000,"d":"7,000,000"}},{"$f":"AB97+D107","v":{"v":7000000,"d":"7,000,000"}},{"$f":"AC97+D108","v":{"v":7000000,"d":"7,000,000"}}]
[null,2,{"$f":"SMALL($C$11:$C$22,B98)","v":{"v":2000000,"d":"2,000,000"}},{"$f":"C98-C97","v":{"v":1000000,"d":"1,000,000"}},null,{"$f":"$F$95","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF($C12>=X98,K$95,0)","v":{"v":1000000,"d":"1,000,000"}},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"$f":"SUM(F98:Q98)","v":{"v":7000000,"d":"7,000,000"}},null,{"$f":"T97","v":{"v":2000000,"d":"2,000,000"}},{"$f":"U97","v":{"v":3000000,"d":"3,000,000"}},{"$f":"V97","v":{"v":4000000,"d":"4,000,000"}},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,3,{"$f":"SMALL($C$11:$C$22,B99)","v":{"v":3000000,"d":"3,000,000"}},{"$f":"C99-C98","v":{"v":1000000,"d":"1,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,{"v":6000000,"d":"6,000,000"},null,{"$f":"T98","v":{"v":2000000,"d":"2,000,000"}},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,4,{"v":4000000,"d":"4,000,000"},{"$f":"C100-C99","v":{"v":1000000,"d":"1,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,{"v":6000000,"d":"6,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,5,{"v":5000000,"d":"5,000,000"},{"$f":"C101-C100","v":{"v":1000000,"d":"1,000,000"}},null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,{"v":5000000,"d":"5,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,6,{"v":6000000,"d":"6,000,000"},{"$f":"C102-C101","v":{"v":1000000,"d":"1,000,000"}},null,{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,0,0,0,0,{"v":1000000,"d":"1,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,7,{"v":6000000,"d":"6,000,000"},{"$f":"C103-C102","v":0},null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF($C17>=U103,H$95,0)","v":0},0,0,0,0,0,0,0,0,0,{"v":2000000,"d":"2,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,8,{"v":7000000,"d":"7,000,000"},{"v":1000000,"d":"1,000,000"},null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,0,0,{"v":3000000,"d":"3,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,9,{"v":7000000,"d":"7,000,000"},0,null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,0,{"v":4000000,"d":"4,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,10,{"v":7000000,"d":"7,000,000"},0,null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"v":7000000,"d":"7,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,11,{"v":7000000,"d":"7,000,000"},0,null,{"v":1000000,"d":"1,000,000"},{"$f":"IF($C21>=T107,G$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"v":7000000,"d":"7,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[null,12,{"v":7000000,"d":"7,000,000"},0,null,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"v":7000000,"d":"7,000,000"},null,{"v":2000000,"d":"2,000,000"},{"v":3000000,"d":"3,000,000"},{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"},{"v":7000000,"d":"7,000,000"}]
[]
[null,"FOR EACH TRANCHE: DETERMINE THE CAPACITY PRODUCTS WITHOUT optimisation"]
[]
[{"$nulls":5},"Tranche 1","Tranche 2","Tranche 3","Tranche 4","Tranche 5","Tranche 6","Tranche 7","Tranche 8","Tranche 9","Tranche 10","Tranche 11","Tranche 12"]
[{"$nulls":4},"January","Y",{"$f":"IF(G97=0,\"\",IF(AND(G$97=G$98,G$98=G$99,$L$89<>$N$80,$L$89<>$N$81),\"Q\",\"M\"))","v":"Q"},{"$f":"IF(H97=0,\"\",IF(AND(H$97=H$98,H$98=H$99,$L$89<>$N$80,$L$89<>$N$81),\"Q\",\"M\"))","v":"Q"},{"$f":"IF(I97=0,\"\",IF(AND(I$97=I$98,I$98=I$99,$L$89<>$N$80,$L$89<>$N$81),\"Q\",\"M\"))","v":"Q"},"Q","Q",{"$f":"IF(L97=0,\"\",IF(AND(L$97=L$98,L$98=L$99,$L$89<>$N$80,$L$89<>$N$81),\"Q\",\"M\"))","v":""},"M","","","",""]
[{"$nulls":4},"February","Y","Q","Q",{"$f":"IF(I98=0,\"\",IF(AND(I$97=I$98,I$98=I$99,$L$89<>$N$80,$L$89<>$N$81),\"Q\",\"M\"))","v":"Q"},"Q","Q","","M","","","",""]
[{"$nulls":4},"March","Y","Q","Q",{"$f":"IF(I99=0,\"\",IF(AND(I$97=I$98,I$98=I$99,$L$89<>$N$80,$L$89<>$N$81),\"Q\",\"M\"))","v":"Q"},"Q","Q","","","",{"$f":"IF(O99=0,\"\",IF(AND(O$97=O$98,O$98=O$99,$L$89<>$N$80,$L$89<>$N$81),\"Q\",\"M\"))","v":""},"",""]
[{"$nulls":4},"April","Y",{"$f":"IF(G100=0,\"\",IF(AND(G$100=G$101,G$101=G$102,$L$89<>$N$83,$L$89<>$N$84),\"Q\",\"M\"))","v":"M"},"M",{"$f":"IF(I100=0,\"\",IF(AND(I$100=I$101,I$101=I$102,$L$89<>$N$83,$L$89<>$N$84),\"Q\",\"M\"))","v":"M"},"M","M","","","","","",""]
[{"$nulls":4},"May ","Y","M","M",{"$f":"IF(I101=0,\"\",IF(AND(I$100=I$101,I$101=I$102,$L$89<>$N$83,$L$89<>$N$84),\"Q\",\"M\"))","v":"M"},"M","",{"$f":"IF(L101=0,\"\",IF(AND(L$100=L$101,L$101=L$102,$L$89<>$N$83,$L$89<>$N$84),\"Q\",\"M\"))","v":""},"","","","",""]
[{"$nulls":4},"June","Y","","",{"$f":"IF(I102=0,\"\",IF(AND(I$100=I$101,I$101=I$102,$L$89<>$N$83,$L$89<>$N$84),\"Q\",\"M\"))","v":""},"","","","","","","",""]
[{"$nulls":4},"July ","Y",{"$f":"IF(G103=0,\"\",IF(AND(G$103=G$104,G$104=G$105,$L$89<>$N$86,$L$89<>$N$87),\"Q\",\"M\"))","v":"Q"},{"$f":"IF(H103=0,\"\",IF(AND(H$103=H$104,H$104=H$105,$L$89<>$N$86,$L$89<>$N$87),\"Q\",\"M\"))","v":""},{"$f":"IF(I103=0,\"\",IF(AND(I$103=I$104,I$104=I$105,$L$89<>$N$86,$L$89<>$N$87),\"Q\",\"M\"))","v":""},"","","","","","","",""]
[{"$nulls":4},"August","Y",{"$f":"IF(G104=0,\"\",IF(AND(G$103=G$104,G$104=G$105,$L$89<>$N$86,$L$89<>$N$87),\"Q\",\"M\"))","v":"Q"},"M",{"$f":"IF(I104=0,\"\",IF(AND(I$103=I$104,I$104=I$105,$L$89<>$N$86,$L$89<>$N$87),\"Q\",\"M\"))","v":""},"","","","","","","",""]
[{"$nulls":4},"September","Y",{"$f":"IF(G105=0,\"\",IF(AND(G$103=G$104,G$104=G$105,$L$89<>$N$86,$L$89<>$N$87),\"Q\",\"M\"))","v":"Q"},"M",{"$f":"IF(I105=0,\"\",IF(AND(I$103=I$104,I$104=I$105,$L$89<>$N$86,$L$89<>$N$87),\"Q\",\"M\"))","v":"M"},"","","","","","","",""]
[{"$nulls":4},"October","Y",{"$f":"IF(G106=0,\"\",IF(AND(G$106=G$107,G$107=G$108,$L$89<>$N$89,$L$89<>$N$90),\"Q\",\"M\"))","v":"Q"},{"$f":"IF(H106=0,\"\",IF(AND(H$106=H$107,H$107=H$108,$L$89<>$N$89,$L$89<>$N$90),\"Q\",\"M\"))","v":"Q"},{"$f":"IF(I106=0,\"\",IF(AND(I$106=I$107,I$107=I$108,$L$89<>$N$89,$L$89<>$N$90),\"Q\",\"M\"))","v":"Q"},"Q","Q","","Q","","","",""]
[{"$nulls":4},"November","Y",{"$f":"IF(G107=0,\"\",IF(AND(G$106=G$107,G$107=G$108,$L$89<>$N$89,$L$89<>$N$90),\"Q\",\"M\"))","v":"Q"},{"$f":"IF(H107=0,\"\",IF(AND(H$106=H$107,H$107=H$108,$L$89<>$N$89,$L$89<>$N$90),\"Q\",\"M\"))","v":"Q"},{"$f":"IF(I107=0,\"\",IF(AND(I$106=I$107,I$107=I$108,$L$89<>$N$89,$L$89<>$N$90),\"Q\",\"M\"))","v":"Q"},"Q","Q",{"$f":"IF(L107=0,\"\",IF(AND(L$106=L$107,L$107=L$108,$L$89<>$N$89,$L$89<>$N$90),\"Q\",\"M\"))","v":""},"Q","","","",""]
[{"$nulls":4},"December ","Y","Q","Q",{"$f":"IF(I108=0,\"\",IF(AND(I$106=I$107,I$107=I$108,$L$89<>$N$89,$L$89<>$N$90),\"Q\",\"M\"))","v":"Q"},"Q","Q","","Q","","","",""]
[]
[null,"FOR EACH MONTH: DETERMINE AMOUNT OF CAPACITY WITHOUT optimisation"]
[]
[{"$nulls":5},"Year","Quarter","Month","Total"]
[{"$nulls":5},"Y","Q","M"]
[{"$nulls":4},"January",{"$f":"SUMIF($F113:$Q113,$F$129,$F97:$Q97)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUMIF($F113:$Q113,$G$129,$F97:$Q97)","v":{"v":5000000,"d":"5,000,000"}},{"$f":"SUMIF($F113:$Q113,$H$129,$F97:$Q97)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUM(F130:H130)","v":{"v":7000000,"d":"7,000,000"}}]
[{"$nulls":4},"February",{"$f":"SUMIF($F114:$Q114,$F$129,$F98:$Q98)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUMIF($F114:$Q114,$G$129,$F98:$Q98)","v":{"v":5000000,"d":"5,000,000"}},{"$f":"SUMIF($F114:$Q114,$H$129,$F98:$Q98)","v":{"v":1000000,"d":"1,000,000"}},{"v":7000000,"d":"7,000,000"}]
[{"$nulls":4},"March",{"v":1000000,"d":"1,000,000"},{"v":5000000,"d":"5,000,000"},{"$f":"SUMIF($F115:$Q115,$H$129,$F99:$Q99)","v":0},{"v":6000000,"d":"6,000,000"}]
[{"$nulls":4},"April",{"v":1000000,"d":"1,000,000"},0,{"v":5000000,"d":"5,000,000"},{"v":6000000,"d":"6,000,000"}]
[{"$nulls":4},"May ",{"v":1000000,"d":"1,000,000"},0,{"v":4000000,"d":"4,000,000"},{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"June",{"v":1000000,"d":"1,000,000"},0,0,{"v":1000000,"d":"1,000,000"}]
[{"$nulls":4},"July ",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":2000000,"d":"2,000,000"}]
[{"$nulls":4},"August",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":3000000,"d":"3,000,000"}]
[{"$nulls":4},"September",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":2000000,"d":"2,000,000"},{"v":4000000,"d":"4,000,000"}]
[{"$nulls":4},"October",{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},0,{"v":7000000,"d":"7,000,000"}]
[{"$nulls":4},"November",{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},0,{"v":7000000,"d":"7,000,000"}]
[{"$nulls":4},"December ",{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},0,{"v":7000000,"d":"7,000,000"}]
[{"$nulls":9},{"$f":"SUM(J130:J141)","v":0}]
[]
[null,"optimisation - FOR EACH TRANCHE: DETERMINE THE CALCULATION FACTORS AND ITS SUM, IF SUM>1 THEN MAXIMISE TO 1 AND DETERMINE NUMBERS OF MONTHS INVOLVED"]
[]
[{"$nulls":5},"Tranche 1","Tranche 2","Tranche 3","Tranche 4","Tranche 5","Tranche 6","Tranche 7","Tranche 8","Tranche 9","Tranche 10","Tranche 11","Tranche 12"]
[{"$nulls":4},"January",{"$f":"IF(F97=0,0,1/12)","v":{"v":0.08333333333333333,"d":"0.0833"}},{"$f":"IF(G97=0,0,IF(AND(G$97=G$98,G$98=G$99,$L$89<>$N$80,$L$89<>$N$81),$Q79,$O79))","v":{"v":0.15226027397260275,"d":"0.1523"}},{"$f":"IF(H97=0,0,IF(AND(H$97=H$98,H$98=H$99,$L$89<>$N$80,$L$89<>$N$81),$Q79,$O79))","v":{"v":0.15226027397260275,"d":"0.1523"}},{"v":0.15226027397260275,"d":"0.1523"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0,"d":"0.0000"},{"v":0.21848630136986302,"d":"0.2185"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"February",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G98=0,0,IF(AND(G$97=G$98,G$98=G$99,$L$89<>$N$80,$L$89<>$N$81),$Q80,$O80))","v":{"v":0.15226027397260275,"d":"0.1523"}},{"$f":"IF(H98=0,0,IF(AND(H$97=H$98,H$98=H$99,$L$89<>$N$80,$L$89<>$N$81),$Q80,$O80))","v":{"v":0.15226027397260275,"d":"0.1523"}},{"v":0.15226027397260275,"d":"0.1523"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0,"d":"0.0000"},0.1764,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"March",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G99=0,0,IF(AND(G$97=G$98,G$98=G$99,$L$89<>$N$80,$L$89<>$N$81),$Q81,$O81))","v":{"v":0.15226027397260275,"d":"0.1523"}},{"v":0.15226027397260275,"d":"0.1523"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"April",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G100=0,0,IF(AND(G$100=G$101,G$101=G$102,$L$89<>$N$83,$L$89<>$N$84),$Q82,$O82))","v":{"v":0.11021917808219177,"d":"0.1102"}},{"v":0.11021917808219177,"d":"0.1102"},{"v":0.11021917808219177,"d":"0.1102"},{"v":0.11021917808219177,"d":"0.1102"},{"v":0.11021917808219177,"d":"0.1102"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"May ",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G101=0,0,IF(AND(G$100=G$101,G$101=G$102,$L$89<>$N$83,$L$89<>$N$84),$Q83,$O83))","v":{"v":0.10089863013698631,"d":"0.1009"}},{"v":0.10089863013698631,"d":"0.1009"},{"v":0.10089863013698631,"d":"0.1009"},{"v":0.10089863013698631,"d":"0.1009"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"June",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G102=0,0,IF(AND(G$100=G$101,G$101=G$102,$L$89<>$N$83,$L$89<>$N$84),$Q84,$O84))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"July ",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G103=0,0,IF(AND(G$103=G$104,G$104=G$105,$L$89<>$N$86,$L$89<>$N$87),$Q85,$O85))","v":{"v":0.0660593607305936,"d":"0.0661"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"August",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G104=0,0,IF(AND(G$103=G$104,G$104=G$105,$L$89<>$N$86,$L$89<>$N$87),$Q86,$O86))","v":{"v":0.0660593607305936,"d":"0.0661"}},{"v":0.07605616438356165,"d":"0.0761"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"September",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G105=0,0,IF(AND(G$103=G$104,G$104=G$105,$L$89<>$N$86,$L$89<>$N$87),$Q87,$O87))","v":{"v":0.0660593607305936,"d":"0.0661"}},{"v":0.08173972602739726,"d":"0.0817"},{"v":0.08173972602739726,"d":"0.0817"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"October",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G106=0,0,IF(AND(G$106=G$107,G$107=G$108,$L$89<>$N$89,$L$89<>$N$90),$Q88,$O88))","v":{"v":0.11605022831050228,"d":"0.1161"}},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"November",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G107=0,0,IF(AND(G$106=G$107,G$107=G$108,$L$89<>$N$89,$L$89<>$N$90),$Q89,$O89))","v":{"v":0.11605022831050228,"d":"0.1161"}},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"December ",{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(G108=0,0,IF(AND(G$106=G$107,G$107=G$108,$L$89<>$N$89,$L$89<>$N$90),$Q90,$O90))","v":{"v":0.11605022831050228,"d":"0.1161"}},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[]
[null,null,"Sum calculation factors",null,null,{"$f":"SUM(F147:F158)","v":{"v":1,"d":"1.00000"}},{"$f":"SUM(G147:G158)","v":{"v":1.214227397260274,"d":"1.21423"}},{"$f":"SUM(H147:H158)","v":{"v":1.173845205479452,"d":"1.17385"}},{"v":1.0977890410958904,"d":"1.09779"},{"v":1.016049315068493,"d":"1.01605"},{"v":0.9151506849315068,"d":"0.91515"},0,{"v":0.7430369863013698,"d":"0.74304"},0,0,0,0]
[null,null,"Maximise at 1 (art. 3.2.2.8)",null,null,{"$f":"MIN(F160,1)","v":{"v":1,"d":"1.00000"}},{"$f":"MIN(G160,1)","v":{"v":1,"d":"1.00000"}},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":1,"d":"1.00000"},{"v":0.9151506849315068,"d":"0.91515"},0,{"v":0.7430369863013698,"d":"0.74304"},0,0,0,0]
[null,null,"Upgrade tranche to yearly product?",null,null,{"$f":"IF(F161=1,\"Y\",\"\")","v":"Y"},{"$f":"IF(G161=1,\"Y\",\"\")","v":"Y"},"Y","Y","Y","","","","","","",""]
[null,null,"Numbers of months involved (art. 3.2.3.8)",null,null,{"$f":"ROUND(IF(F161=1,COUNTIF(F147:F158,\">0\"),0),0)","v":12},{"$f":"ROUND(IF(G161=1,COUNTIF(G147:G158,\">0\"),0),0)","v":11},{"$f":"ROUND(IF(H161=1,COUNTIF(H147:H158,\">0\"),0),0)","v":10},{"$f":"ROUND(IF(I161=1,COUNTIF(I147:I158,\">0\"),0),0)","v":9},{"$f":"ROUND(IF(J161=1,COUNTIF(J147:J158,\">0\"),0),0)","v":8},0,0,0,0,0,0,0]
[]
[null,"optimisation - FOR EACH TRANCHE: DETERMINE THE NEW CALCULATION FACTORS"]
[]
[{"$nulls":5},"Tranche 1","Tranche 2","Tranche 3","Tranche 4","Tranche 5","Tranche 6","Tranche 7","Tranche 8","Tranche 9","Tranche 10","Tranche 11","Tranche 12"]
[{"$nulls":4},"January",{"$f":"IF(F$162=\"Y\",1/12,IF(F147=0,\"\",F147))","v":{"v":0.08333333333333333,"d":"0.0833"}},{"$f":"IF(G$162=\"Y\",1/12,IF(G147=0,0,G147))","v":{"v":0.08333333333333333,"d":"0.0833"}},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0,"d":"0.0000"},{"v":0.21848630136986302,"d":"0.2185"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"February",{"$f":"IF(F$162=\"Y\",1/12,IF(F148=0,0,F148))","v":{"v":0.08333333333333333,"d":"0.0833"}},{"v":0.08333333333333333,"d":"0.0833"},{"$f":"IF(H$162=\"Y\",1/12,IF(H148=0,0,H148))","v":{"v":0.08333333333333333,"d":"0.0833"}},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0,"d":"0.0000"},0.1764,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"March",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.15226027397260275,"d":"0.1523"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"April",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.11021917808219177,"d":"0.1102"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"May ",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"June",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"July ",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"August",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"September",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"October",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"November",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":4},"December ",{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.08333333333333333,"d":"0.0833"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0.11605022831050228,"d":"0.1161"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[]
[null,"optimisation - FOR EACH TRANCHE: DETERMINE THE CAPACITY PRODUCT Y, Q or M"]
[]
[{"$nulls":5},"Tranche 1","Tranche 2","Tranche 3","Tranche 4","Tranche 5","Tranche 6","Tranche 7","Tranche 8","Tranche 9","Tranche 10","Tranche 11","Tranche 12"]
[{"$nulls":4},"January",{"$f":"IF(F168=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$168=F$169,F$169=F$170),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","Q","","M","","","",""]
[{"$nulls":4},"February",{"$f":"IF(F169=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$168=F$169,F$169=F$170),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","Q","","M","","","",""]
[{"$nulls":4},"March",{"$f":"IF(F170=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$168=F$169,F$169=F$170),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","Q","","","","","",""]
[{"$nulls":4},"April",{"$f":"IF(F171=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$171=F$172,F$172=F$173),\"Q\",\"M\")))","v":"Y"},{"$f":"IF(G171=0,\"\",IF(G$162=\"Y\",\"Y\",IF(AND(G$171=G$172,G$172=G$173),\"Q\",\"M\")))","v":"Y"},"Y",{"$f":"IF(I171=0,\"\",IF(I$162=\"Y\",\"Y\",IF(AND(I$171=I$172,I$172=I$173),\"Q\",\"M\")))","v":"Y"},"Y","M","","","","","",""]
[{"$nulls":4},"May ",{"$f":"IF(F172=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$171=F$172,F$172=F$173),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","","","","","","",""]
[{"$nulls":4},"June",{"$f":"IF(F173=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$171=F$172,F$172=F$173),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","","","","","","",""]
[{"$nulls":4},"July ",{"$f":"IF(F174=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$174=F$175,F$175=F$176),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","","","","","","",""]
[{"$nulls":4},"August",{"$f":"IF(F175=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$174=F$175,F$175=F$176),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","","","","","","",""]
[{"$nulls":4},"September",{"$f":"IF(F176=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$174=F$175,F$175=F$176),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","",{"$f":"IF(L176=0,\"\",IF(L$162=\"Y\",\"Y\",IF(AND(L$174=L$175,L$175=L$176),\"Q\",\"M\")))","v":""},"","","","",""]
[{"$nulls":4},"October",{"$f":"IF(F177=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$177=F$178,F$178=F$179),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","Q",{"$f":"IF(L177=0,\"\",IF(L$162=\"Y\",\"Y\",IF(AND(L$177=L$178,L$178=L$179),\"Q\",\"M\")))","v":""},"Q","","","",""]
[{"$nulls":4},"November",{"$f":"IF(F178=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$177=F$178,F$178=F$179),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","Q",{"$f":"IF(L178=0,\"\",IF(L$162=\"Y\",\"Y\",IF(AND(L$177=L$178,L$178=L$179),\"Q\",\"M\")))","v":""},"Q","","","",""]
[{"$nulls":4},"December ",{"$f":"IF(F179=0,\"\",IF(F$162=\"Y\",\"Y\",IF(AND(F$177=F$178,F$178=F$179),\"Q\",\"M\")))","v":"Y"},"Y","Y","Y","Y","Q",{"$f":"IF(L179=0,\"\",IF(L$162=\"Y\",\"Y\",IF(AND(L$177=L$178,L$178=L$179),\"Q\",\"M\")))","v":""},"Q","","","",""]
[]
[null,"optimisation - FOR EACH TRANCHE: DETERMINE AMOUNT OF CAPACITY"]
[{"$nulls":5},"Tranche 1","Tranche 2","Tranche 3","Tranche 4","Tranche 5","Tranche 6","Tranche 7","Tranche 8","Tranche 9","Tranche 10","Tranche 11","Tranche 12","Total"]
[{"$nulls":4},"January",{"$f":"IF(OR(F184=\"Y\",F184=\"Q\",F184=\"M\"),F$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"$f":"SUM(F199:Q199)","v":{"v":7000000,"d":"7,000,000"}}]
[{"$nulls":4},"February",{"$f":"IF(OR(F185=\"Y\",F185=\"Q\",F185=\"M\"),F$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H185=\"Y\",H185=\"Q\",H185=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"$f":"SUM(F200:Q200)","v":{"v":7000000,"d":"7,000,000"}}]
[{"$nulls":4},"March",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H186=\"Y\",H186=\"Q\",H186=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,{"v":6000000,"d":"6,000,000"}]
[{"$nulls":4},"April",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H187=\"Y\",H187=\"Q\",H187=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,{"v":6000000,"d":"6,000,000"}]
[{"$nulls":4},"May ",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H188=\"Y\",H188=\"Q\",H188=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"June",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H189=\"Y\",H189=\"Q\",H189=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"July ",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H190=\"Y\",H190=\"Q\",H190=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"August",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H191=\"Y\",H191=\"Q\",H191=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"September",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H192=\"Y\",H192=\"Q\",H192=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,0,0,0,0,0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"October",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H193=\"Y\",H193=\"Q\",H193=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"v":7000000,"d":"7,000,000"}]
[{"$nulls":4},"November",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H194=\"Y\",H194=\"Q\",H194=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"v":7000000,"d":"7,000,000"}]
[{"$nulls":4},"December ",{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"IF(OR(H195=\"Y\",H195=\"Q\",H195=\"M\"),H$95,0)","v":{"v":1000000,"d":"1,000,000"}},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},0,{"v":1000000,"d":"1,000,000"},0,0,0,0,{"v":7000000,"d":"7,000,000"}]
[]
[null,"optimisation - FOR EACH MONTH: DETERMINE AMOUNT OF CAPACITY"]
[]
[{"$nulls":5},"Year","Quarter","Month","Total"]
[{"$nulls":5},"y","Q","M"]
[{"$nulls":4},"January",{"$f":"SUMIF($F184:$Q184,F$215,$F199:$Q199)","v":{"v":5000000,"d":"5,000,000"}},{"$f":"SUMIF($F184:$Q184,G$215,$F199:$Q199)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUMIF($F184:$Q184,H$215,$F199:$Q199)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUM(F216:H216)","v":{"v":7000000,"d":"7,000,000"}}]
[{"$nulls":4},"February",{"$f":"SUMIF($F185:$Q185,F$215,$F200:$Q200)","v":{"v":5000000,"d":"5,000,000"}},{"$f":"SUMIF($F185:$Q185,G$215,$F200:$Q200)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"SUMIF($F185:$Q185,H$215,$F200:$Q200)","v":{"v":1000000,"d":"1,000,000"}},{"v":7000000,"d":"7,000,000"}]
[{"$nulls":4},"March",{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"$f":"SUMIF($F186:$Q186,H$215,$F201:$Q201)","v":0},{"v":6000000,"d":"6,000,000"}]
[{"$nulls":4},"April",{"v":5000000,"d":"5,000,000"},0,{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"}]
[{"$nulls":4},"May ",{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"June",{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"July ",{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"August",{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"September",{"v":5000000,"d":"5,000,000"},0,0,{"v":5000000,"d":"5,000,000"}]
[{"$nulls":4},"October",{"v":5000000,"d":"5,000,000"},{"v":2000000,"d":"2,000,000"},0,{"v":7000000,"d":"7,000,000"}]
[{"$nulls":4},"November",{"v":5000000,"d":"5,000,000"},{"v":2000000,"d":"2,000,000"},0,{"v":7000000,"d":"7,000,000"}]
[{"$nulls":4},"December ",{"v":5000000,"d":"5,000,000"},{"v":2000000,"d":"2,000,000"},0,{"v":7000000,"d":"7,000,000"}]