{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Simulation","Price Increase","Profit growth","Price discounts","Volume increase","Impact of costs"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":88,"n_cols":9,"rows_kept":88,"merged":[[2,1,2,11],[8,1,15,11],[17,1,17,7],[17,8,17,11],[19,1,22,11],[26,1,27,11],[39,1,48,11],[52,1,65,11],[69,1,74,11],[78,1,83,11],[86,1,86,11],[87,1,87,4],[87,5,87,7]]}
[]
[]
[null,"PROFIT SENSITIVITY TO PRICES AND COSTS VARIANCES"]
[]
[null,"Introduction"]
[]
[null,"Overview"]
[]
[null,"Understanding the sensitivity of profit to variations of prices and costs is essential for any business. The sensitivity is determined by the indicator of profit in % of sales, also called profitability rate, and it can be measured in percentage points.\nThis knowledge of profit can help answering many questions, to name a few:\n→ What is the necessary price increase to guarantee the profit growth by X percentage points? Should this increase be the same for all products of a portfolio?\n→ How will the profit of a product react to variations of costs? If material cost increases by X % for products with different profitability, will the impact on profit be the same?"]
{"$rows_empty":8}
[null,"Read more about indicators of profit and profit sensitivity in our article:",{"$nulls":6},"“How (Not) to Lose a Profit in 10 days”."]
[]
[null,"Here we introduce our profitability calculators and tables which serve to quickly measure the impact of prices and costs variations and make necessary adjustments to secure the desired level of profit.\nWe hope that these tools will help you in searching for profit maximization, planning sales promotions and negotiating selling conditions with your clients."]
[]
[]
[]
[]
[null,"Warning"]
[]
[null,"This Tool has been produced with care and to the best of our ability. However, FPANDA CLUB accepts no responsibility for any problems or incidents arising from its use."]
[]
[]
[null,"Credits"]
[]
[null,"This Tool has been developed by ©FPANDA CLUB, 2022"]
[]
[null,"Guidelines"]
[]
[null,"Sheet \"Simulation\""]
[]
[null,"N1→ Profitability simulation (Impact of Price and Cost Variations)"]
[]
[null,"There are 3 options in this simulation tool:\n1.\nInput your current profitability (gross margin in % of sales), price change in %, cost change in %. And you will get your new profitability in %. You will also see the breakdown of profitability evolution in % points due to price effect and cost effect.\n2.\nInput your current profitability in %, cost change in %, new target profitability in %. And you will get the necessary price change in % to meet these criteria.\n3.\nInput your current profitability in%, price change in %, new target profitability in %. And you will get the required cost change in % to meet these criteria."]
{"$rows_empty":10}
[null,"N2→ Profit amount simulation (Impact of Volume, Price and Cost Variations)"]
[]
[null,"There are 4 options in this simulation tool:\n1.\nInput your current profitability (gross margin in % of sales), volume change in %, price change in %, cost change in %. And you will see how the amount of gross margin changes in %. You will also get your net sales change in %, your new profitability in %, and the breakdown of profitability evolution in % points due to price effect and cost effect.\n2.\nInput your current profitability in %, price change in%, cost change in %, target change in % of gross margin amount. And you will get the necessary volume change in % to meet these criteria.\n3.\nInput your current profitability in %, volume change in %, cost change in %, target change in % of gross margin amount. And you will get the necessary price change in % to meet these criteria.\n4.\nInput your current profitability in %, volume change in %, price change in %, target change in % of gross margin amount. And you will get the required cost change in % to meet these criteria."]
{"$rows_empty":14}
[null,"N3→ Impact of Price Discounts on Profit amount and Profitability"]
[]
[null,"Input your current profitability (gross margin in % of sales) before discount, price discount in % (attention: it should be written 10%, not -10%, for example). You will get your new profitability in % and the volume growth in % which is necessary to compensate the price reduction. This volume growth means that during the period of promo action the amount of your gross margin remains the same as before giving a discount during the same period. \nFurthermore, if your target is to increase the amount of gross margin, then you can input the desired growth in % of your gross margin amount. And you will get the necessary percentage of volume increase to support this profit growth."]
[]
[]
[]
[]
[]
[]
[null,"Sheets \"Price increase\", \"Profit growth\", \"Price discounts\", \"Volume increase\", \"Impact of costs\""]
[]
[null,"Here are the tables following the same rules of calculation as in the sheet \"Simulation\", but you can see multiple values for the chosen indicator.\n\nFeel free to customize parameters for your projects. In the left column you can change the current gross margin in % of sales. In the header of each table you can change the parameters of the corresponding indicator."]
[]
[]
[]
[]
[]
[null,"Contact"]
[]
[null,"If you have any questions or comments, do not hesitate to contact us by email admin@fpandaclub.com"]
[null,"or via our contact form on the website",{"$nulls":3},"www.fpandaclub.com"]

{"sheet":"Simulation","index":1,"n_rows":71,"n_cols":18,"rows_kept":71,"merged":[[2,4,2,13],[3,3,3,5],[3,7,3,9],[3,11,3,13],[4,3,4,5],[4,7,4,9],[4,11,4,13],[6,1,6,2],[8,1,8,2],[10,1,10,2],[12,1,12,2],[22,4,22,17],[23,3,23,5],[23,7,23,9],[23,11,23,13],[23,15,23,17],[24,3,24,5],[24,7,24,9],[24,11,24,13],[24,15,24,17],[26,1,26,2],[28,1,28,2],[30,1,30,2],[32,1,32,2],[34,1,34,2],[36,1,36,2],[38,1,38,2],[49,1,49,2],[51,1,51,2],[53,1,53,2],[55,1,55,2],[59,1,59,2],[61,1,61,2],[63,1,63,2]]}
["N1→","Profitability* simulation (Impact of Price and Cost Variations)"]
[]
[{"$nulls":4},"SIMULATION OF:"]
[{"$nulls":3},1,{"$nulls":3},2,{"$nulls":3},3]
[{"$nulls":3},"New Profitability* in %",{"$nulls":3},"Price change in %",{"$nulls":3},"Cost change in %"]
[{"$nulls":5},"in % points of GM**",{"$nulls":3},"in % points of GM**",{"$nulls":3},"in % points of GM**"]
[null,"Current Profitability* (in %)",null,null,{"v":0.25,"d":"25.0%"},{"$nulls":3},{"v":0.25,"d":"25.0%"},{"$nulls":3},{"v":0.25,"d":"25.0%"}]
[]
[null,"Price change (in %)",null,null,{"v":0.03,"d":"3.0%"},{"$f":"(1-E7)*(1-1/(1+E9))*100","v":{"v":2.1844660194174748,"d":"+2.2 pts"}},null,null,{"$f":"(1+I11)*(1-I7)/(1-I13)-1","v":{"v":0.12500000000000022,"d":"+12.5%"}},{"$f":"(1-I7)*(1-1/(1+I9))*100","v":{"v":8.333333333333345,"d":"+8.3 pts"}},null,null,{"v":-0.1,"d":"-10.0%"},{"$f":"(1-M7)*(1-1/(1+M9))*100","v":{"v":-8.333333333333337,"d":"-8.3 pts"}}]
[]
[null,"Cost change (in %)",null,null,{"v":0.08,"d":"8.0%"},{"$f":"(1-(E7+F9/100))*-E11*100","v":{"v":-5.825242718446602,"d":"-5.8 pts"}},null,null,{"v":0.05,"d":"5.0%"},{"$f":"(1-(I7+J9/100))*-I11*100","v":{"v":-3.3333333333333326,"d":"-3.3 pts"}},null,null,{"$f":"(1+M9)*(1-M13)/(1-M7)-1","v":{"v":-0.039999999999999925,"d":"-4.0%"}},{"$f":"(1-(M7+N9/100))*-M11*100","v":{"v":3.333333333333327,"d":"+3.3 pts"}}]
[]
[null,"NEW Profitability* (in %)",null,null,{"$f":"1-(1-E7)*(1+E11)/(1+E9)","v":{"v":0.21359223300970875,"d":"21.4%"}},{"$f":"SUM(F9:F11)","v":{"v":-3.6407766990291273,"d":"-3.6 pts"}},null,null,{"v":0.3,"d":"30.0%"},{"$f":"SUM(J9:J11)","v":{"v":5.000000000000012,"d":"+5.0 pts"}},null,null,{"v":0.2,"d":"20.0%"},{"$f":"SUM(N9:N11)","v":{"v":-5.000000000000011,"d":"-5.0 pts"}}]
[]
[null,"input"]
[null,"formula"]
[]
[null,"* Profitability = Gross Margin in % of Net Sales"]
[null,"** GM = Gross Margin"]
[]
["N2→","Profit amount simulation (Impact of Volume, Price and Cost Variations)"]
[]
[{"$nulls":4},"SIMULATION OF:"]
[{"$nulls":3},1,{"$nulls":3},2,{"$nulls":3},3,{"$nulls":3},4]
[{"$nulls":3},"New Profitability* in %",{"$nulls":3},"Volume change in %",{"$nulls":3},"Price change in %",{"$nulls":3},"Cost change in %"]
[{"$nulls":5},"in % points of GM**",{"$nulls":3},"in % points of GM**",{"$nulls":3},"in % points of GM**",{"$nulls":3},"in % points of GM**"]
[null,"Current Profitability* (in %)",null,null,{"v":0.3,"d":"30.0%"},{"$nulls":3},{"v":0.3,"d":"30.0%"},{"$nulls":3},{"v":0.3,"d":"30.0%"},{"$nulls":3},{"v":0.3,"d":"30.0%"}]
[]
[null,"Volume change (in %)",null,null,{"v":0.05,"d":"5.0%"},{"$nulls":3},{"$f":"IFERROR((1+I37)*I27/((1+I31)-(1-I27)*(1+I33))-1,0)","v":{"v":0.28571428571428514,"d":"+28.6%"}},{"$nulls":3},{"v":0.05,"d":"5.0%"},{"$nulls":3},{"v":0.4,"d":"40.0%"}]
[]
[null,"Price change (in %)",null,null,{"v":0.05,"d":"5.0%"},{"$f":"(1-E27)*(1-1/(1+E31))*100","v":{"v":3.3333333333333366,"d":"+3.3 pts"}},null,null,{"v":0.05,"d":"5.0%"},{"$f":"(1-I27)*(1-1/(1+I31))*100","v":{"v":3.3333333333333366,"d":"+3.3 pts"}},null,null,{"$f":"IFERROR((1+M37)*M27/(1+M29)+(1+M33)*(1-M27)-1,0)","v":{"v":0.11928571428571422,"d":"+11.9%"}},{"$f":"(1-M27)*(1-1/(1+M31))*100","v":{"v":7.460114869176763,"d":"+7.5 pts"}},null,null,{"v":-0.1,"d":"-10.0%"},{"$f":"(1-Q27)*(1-1/(1+Q31))*100","v":{"v":-7.77777777777778,"d":"-7.8 pts"}}]
[]
[null,"Cost change (in %)",null,null,{"v":0.15,"d":"15.0%"},{"$f":"(1-(E27+F31/100))*-E33*100","v":{"v":-10,"d":"-10.0 pts"}},null,null,{"v":0.15,"d":"15.0%"},{"$f":"(1-(I27+J31/100))*-I33*100","v":{"v":-10,"d":"-10.0 pts"}},null,null,{"v":0.15,"d":"15.0%"},{"$f":"(1-(M27+N31/100))*-M33*100","v":{"v":-9.380982769623484,"d":"-9.4 pts"}},null,null,{"$f":"IFERROR(1/(1-Q27)*(1+Q31-(1+Q37)/(1+Q29))+(1+Q37)/(1+Q29)-1,0)","v":{"v":-0.0357142857142857,"d":"-3.6%"}},{"$f":"(1-(Q27+R31/100))*-Q33*100","v":{"v":2.777777777777777,"d":"+2.8 pts"}}]
[]
[null,"Net Sales change (in %)",null,null,{"$f":"IFERROR((1+E29)*(1+E31)-1,0)","v":{"v":0.10250000000000004,"d":"10.3%"}},{"$nulls":3},{"$f":"IFERROR((1+I29)*(1+I31)-1,0)","v":{"v":0.3499999999999994,"d":"35.0%"}},{"$nulls":3},{"$f":"IFERROR((1+M29)*(1+M31)-1,0)","v":{"v":0.1752499999999999,"d":"17.5%"}},{"$nulls":3},{"$f":"IFERROR((1+Q29)*(1+Q31)-1,0)","v":{"v":0.26,"d":"26.0%"}}]
[]
[null,"Gross Margin amount change (in %)",null,null,{"$f":"IFERROR(((1+E31)-(1-E27)*(1+E33))*(1+E29)/E27-1,0)","v":{"v":-0.14249999999999952,"d":"-14.3%"}},{"$nulls":3},{"v":0.05,"d":"5.0%"},{"$nulls":3},{"v":0.1,"d":"10.0%"},{"$nulls":3},{"v":0.05,"d":"5.0%"}]
[]
[null,"NEW Profitability* (in %)",null,null,{"$f":"1-(1-E27)*(1+E33)/(1+E31)","v":{"v":0.2333333333333334,"d":"23.3%"}},{"$f":"SUM(F31:F33)","v":{"v":-6.666666666666663,"d":"-6.7 pts"}},null,null,{"$f":"1-(1-I27)*(1+I33)/(1+I31)","v":{"v":0.2333333333333334,"d":"23.3%"}},{"$f":"SUM(J31:J33)","v":{"v":-6.666666666666663,"d":"-6.7 pts"}},null,null,{"$f":"1-(1-M27)*(1+M33)/(1+M31)","v":{"v":0.28079132099553283,"d":"28.1%"}},{"$f":"SUM(N31:N33)","v":{"v":-1.920867900446721,"d":"-1.9 pts"}},null,null,{"$f":"1-(1-Q27)*(1+Q33)/(1+Q31)","v":{"v":0.2500000000000001,"d":"25.0%"}},{"$f":"SUM(R31:R33)","v":{"v":-5.0000000000000036,"d":"-5.0 pts"}}]
[]
[null,"input"]
[null,"formula"]
[]
[null,"* Profitability = Gross Margin in % of Net Sales"]
[null,"** GM = Gross Margin"]
[]
["N3→","Price Discounts (Impact on Profit amount and Profitability*)"]
[]
[{"$nulls":5},"in % points of GM**"]
[null,"Current Profitability* (in %)",null,null,{"v":0.4,"d":"40.0%"}]
[]
[null,"Price Discount*** (in %)",null,null,{"v":0.25,"d":"25.0%"}]
[]
[null,"NEW Profitability* (in %)",null,null,{"$f":"IF(E50=\"\",\"\",1-(1-E50)/(1-E52))","v":{"v":0.20000000000000007,"d":"20.0%"}},{"$f":"IF(E50=\"\",\"\",(1-E50)*(1-1/(1-E52))*100)","v":{"v":-19.999999999999996,"d":"-20.0 pts"}}]
[]
[null,"Volume should grow by",null,null,{"$f":"IF(E52<0,\"\",IF(E52>=E50,\"\",1/(1-E52)*E50/E54-1))","v":{"v":1.6666666666666656,"d":"166.7%"}},{"$f":"IF(OR(E50=\"\",E52=\"\"),\"\",IF(E52>=E50,\"Not possible to compensate profit loss. Reduce discount\",IF(E52<0,\"Price discount should be written without '-'\",\"\")))","v":""}]
[null,"to compensate price reduction and not to lose the amount of profit"]
[]
[null,"To increase the amount of gross margin:"]
[null,"by this percentage",null,null,{"v":0.2,"d":"20.0%"}]
[]
[null,"Volume should grow by",null,null,{"$f":"IF(E52>=E50,\"\",(1+E56)*(1+E60)-1)","v":{"v":2.199999999999999,"d":"220.0%"}}]
[]
[null,"Net Sales will increase by",null,null,{"$f":"IF(E52>=E50,\"\",(1+E62)*(1-E52)-1)","v":{"v":1.399999999999999,"d":"140.0%"}}]
[]
[null,"input"]
[null,"formula"]
[]
[null,"* Profitability = Gross Margin in % of Net Sales"]
[null,"** GM = Gross Margin"]
[null,"*** The percentage of price discount should be input without \"-\", e.g. 10%, not -10%"]

{"sheet":"Price Increase","index":2,"n_rows":38,"n_cols":26,"rows_kept":38,"merged":[[3,1,4,1],[22,1,23,1]]}
[null,"Impact of Price Increase on \"Profit in % of Sales\""]
[null,"New profit (in % of sales) after increasing prices:"]
[]
[null,"Profit (in % of sales) before change",null,"Price increase in %"]
[{"$nulls":3},{"v":0.01,"d":"1%"},null,{"v":0.02,"d":"2%"},null,{"v":0.03,"d":"3%"},null,{"v":0.04,"d":"4%"},null,{"v":0.05,"d":"5%"},null,{"v":0.1,"d":"10%"},null,{"v":0.15,"d":"15%"},null,{"v":0.2,"d":"20%"},null,{"v":0.25,"d":"25%"},null,{"v":0.3,"d":"30%"},null,{"v":0.4,"d":"40%"},null,{"v":0.5,"d":"50%"}]
[null,{"v":0.05,"d":"5%"},null,{"$f":"(1-$B6)*(1-1/(1+D$5))+$B6","v":{"v":0.05940594059405942,"d":"5.9%"}},null,{"$f":"(1-$B6)*(1-1/(1+F$5))+$B6","v":{"v":0.06862745098039219,"d":"6.9%"}},null,{"$f":"(1-$B6)*(1-1/(1+H$5))+$B6","v":{"v":0.07766990291262135,"d":"7.8%"}},null,{"$f":"(1-$B6)*(1-1/(1+J$5))+$B6","v":{"v":0.08653846153846162,"d":"8.7%"}},null,{"$f":"(1-$B6)*(1-1/(1+L$5))+$B6","v":{"v":0.09523809523809529,"d":"9.5%"}},null,{"$f":"(1-$B6)*(1-1/(1+N$5))+$B6","v":{"v":0.1363636363636364,"d":"13.6%"}},null,{"$f":"(1-$B6)*(1-1/(1+P$5))+$B6","v":{"v":0.17391304347826078,"d":"17.4%"}},null,{"$f":"(1-$B6)*(1-1/(1+R$5))+$B6","v":{"v":0.20833333333333331,"d":"20.8%"}},null,{"$f":"(1-$B6)*(1-1/(1+T$5))+$B6","v":{"v":0.23999999999999994,"d":"24.0%"}},null,{"$f":"(1-$B6)*(1-1/(1+V$5))+$B6","v":{"v":0.2692307692307693,"d":"26.9%"}},null,{"$f":"(1-$B6)*(1-1/(1+X$5))+$B6","v":{"v":0.3214285714285714,"d":"32.1%"}},null,{"$f":"(1-$B6)*(1-1/(1+Z$5))+$B6","v":{"v":0.3666666666666667,"d":"36.7%"}}]
[null,{"v":0.1,"d":"10%"},null,{"v":0.10891089108910892,"d":"10.9%"},null,{"v":0.11764705882352945,"d":"11.8%"},null,{"v":0.1262135922330097,"d":"12.6%"},null,{"v":0.1346153846153847,"d":"13.5%"},null,{"v":0.1428571428571429,"d":"14.3%"},null,{"v":0.18181818181818185,"d":"18.2%"},null,{"v":0.217391304347826,"d":"21.7%"},null,{"v":0.24999999999999997,"d":"25.0%"},null,{"v":0.27999999999999997,"d":"28.0%"},null,{"v":0.30769230769230776,"d":"30.8%"},null,{"v":0.3571428571428571,"d":"35.7%"},null,{"v":0.4,"d":"40.0%"}]
[null,{"v":0.15,"d":"15%"},null,{"v":0.15841584158415842,"d":"15.8%"},null,{"v":0.16666666666666669,"d":"16.7%"},null,{"v":0.17475728155339804,"d":"17.5%"},null,{"v":0.18269230769230776,"d":"18.3%"},null,{"v":0.19047619047619052,"d":"19.0%"},null,{"v":0.2272727272727273,"d":"22.7%"},null,{"v":0.26086956521739124,"d":"26.1%"},null,{"v":0.29166666666666663,"d":"29.2%"},null,{"v":0.31999999999999995,"d":"32.0%"},null,{"v":0.3461538461538462,"d":"34.6%"},null,{"v":0.3928571428571428,"d":"39.3%"},null,{"v":0.43333333333333335,"d":"43.3%"}]
[null,{"v":0.2,"d":"20%"},null,{"v":0.20792079207920794,"d":"20.8%"},null,{"v":0.21568627450980396,"d":"21.6%"},null,{"v":0.22330097087378642,"d":"22.3%"},null,{"v":0.23076923076923084,"d":"23.1%"},null,{"v":0.23809523809523814,"d":"23.8%"},null,{"v":0.27272727272727276,"d":"27.3%"},null,{"v":0.3043478260869565,"d":"30.4%"},null,{"v":0.3333333333333333,"d":"33.3%"},null,{"v":0.36,"d":"36.0%"},null,{"v":0.3846153846153847,"d":"38.5%"},null,{"v":0.4285714285714286,"d":"42.9%"},null,{"v":0.46666666666666673,"d":"46.7%"}]
[null,{"v":0.25,"d":"25%"},null,{"v":0.25742574257425743,"d":"25.7%"},null,{"v":0.26470588235294124,"d":"26.5%"},null,{"v":0.27184466019417475,"d":"27.2%"},null,{"v":0.2788461538461539,"d":"27.9%"},null,{"v":0.28571428571428575,"d":"28.6%"},null,{"v":0.31818181818181823,"d":"31.8%"},null,{"v":0.3478260869565217,"d":"34.8%"},null,{"v":0.375,"d":"37.5%"},null,{"v":0.39999999999999997,"d":"40.0%"},null,{"v":0.42307692307692313,"d":"42.3%"},null,{"v":0.4642857142857143,"d":"46.4%"},null,{"v":0.5,"d":"50.0%"}]
[null,{"v":0.3,"d":"30%"},null,{"v":0.3069306930693069,"d":"30.7%"},null,{"v":0.3137254901960784,"d":"31.4%"},null,{"v":0.3203883495145631,"d":"32.0%"},null,{"v":0.326923076923077,"d":"32.7%"},null,{"v":0.33333333333333337,"d":"33.3%"},null,{"v":0.36363636363636365,"d":"36.4%"},null,{"v":0.39130434782608686,"d":"39.1%"},null,{"v":0.41666666666666663,"d":"41.7%"},null,{"v":0.43999999999999995,"d":"44.0%"},null,{"v":0.46153846153846156,"d":"46.2%"},null,{"v":0.5,"d":"50.0%"},null,{"v":0.5333333333333333,"d":"53.3%"}]
[null,{"v":0.35,"d":"35%"},null,{"v":0.3564356435643564,"d":"35.6%"},null,{"v":0.3627450980392157,"d":"36.3%"},null,{"v":0.3689320388349514,"d":"36.9%"},null,{"v":0.37500000000000006,"d":"37.5%"},null,{"v":0.380952380952381,"d":"38.1%"},null,{"v":0.40909090909090906,"d":"40.9%"},null,{"v":0.4347826086956521,"d":"43.5%"},null,{"v":0.45833333333333326,"d":"45.8%"},null,{"v":0.48,"d":"48.0%"},null,{"v":0.5,"d":"50.0%"},null,{"v":0.5357142857142857,"d":"53.6%"},null,{"v":0.5666666666666667,"d":"56.7%"}]
[null,{"v":0.4,"d":"40%"},null,{"v":0.40594059405940597,"d":"40.6%"},null,{"v":0.411764705882353,"d":"41.2%"},null,{"v":0.41747572815533984,"d":"41.7%"},null,{"v":0.42307692307692313,"d":"42.3%"},null,{"v":0.4285714285714286,"d":"42.9%"},null,{"v":0.4545454545454546,"d":"45.5%"},null,{"v":0.47826086956521735,"d":"47.8%"},null,{"v":0.5,"d":"50.0%"},null,{"v":0.52,"d":"52.0%"},null,{"v":0.5384615384615385,"d":"53.8%"},null,{"v":0.5714285714285714,"d":"57.1%"},null,{"v":0.6000000000000001,"d":"60.0%"}]
[null,{"v":0.45,"d":"45%"},null,{"v":0.45544554455445546,"d":"45.5%"},null,{"v":0.4607843137254902,"d":"46.1%"},null,{"v":0.46601941747572817,"d":"46.6%"},null,{"v":0.4711538461538462,"d":"47.1%"},null,{"v":0.4761904761904762,"d":"47.6%"},null,{"v":0.5,"d":"50.0%"},null,{"v":0.5217391304347826,"d":"52.2%"},null,{"v":0.5416666666666666,"d":"54.2%"},null,{"v":0.56,"d":"56.0%"},null,{"v":0.576923076923077,"d":"57.7%"},null,{"v":0.6071428571428572,"d":"60.7%"},null,{"v":0.6333333333333334,"d":"63.3%"}]
[null,{"v":0.5,"d":"50%"},null,{"v":0.504950495049505,"d":"50.5%"},null,{"v":0.5098039215686274,"d":"51.0%"},null,{"v":0.5145631067961165,"d":"51.5%"},null,{"v":0.5192307692307693,"d":"51.9%"},null,{"v":0.5238095238095238,"d":"52.4%"},null,{"v":0.5454545454545454,"d":"54.5%"},null,{"v":0.5652173913043478,"d":"56.5%"},null,{"v":0.5833333333333333,"d":"58.3%"},null,{"v":0.6,"d":"60.0%"},null,{"v":0.6153846153846154,"d":"61.5%"},null,{"v":0.6428571428571428,"d":"64.3%"},null,{"v":0.6666666666666667,"d":"66.7%"}]
[null,{"v":0.6,"d":"60%"},null,{"v":0.6039603960396039,"d":"60.4%"},null,{"v":0.6078431372549019,"d":"60.8%"},null,{"v":0.6116504854368932,"d":"61.2%"},null,{"v":0.6153846153846154,"d":"61.5%"},null,{"v":0.6190476190476191,"d":"61.9%"},null,{"v":0.6363636363636364,"d":"63.6%"},null,{"v":0.6521739130434782,"d":"65.2%"},null,{"v":0.6666666666666666,"d":"66.7%"},null,{"v":0.6799999999999999,"d":"68.0%"},null,{"v":0.6923076923076923,"d":"69.2%"},null,{"v":0.7142857142857143,"d":"71.4%"},null,{"v":0.7333333333333334,"d":"73.3%"}]
[null,{"v":0.7,"d":"70%"},null,{"v":0.7029702970297029,"d":"70.3%"},null,{"v":0.7058823529411764,"d":"70.6%"},null,{"v":0.7087378640776698,"d":"70.9%"},null,{"v":0.7115384615384616,"d":"71.2%"},null,{"v":0.7142857142857143,"d":"71.4%"},null,{"v":0.7272727272727273,"d":"72.7%"},null,{"v":0.7391304347826086,"d":"73.9%"},null,{"v":0.75,"d":"75.0%"},null,{"v":0.76,"d":"76.0%"},null,{"v":0.7692307692307692,"d":"76.9%"},null,{"v":0.7857142857142857,"d":"78.6%"},null,{"v":0.7999999999999999,"d":"80.0%"}]
[null,{"v":0.8,"d":"80%"},null,{"v":0.801980198019802,"d":"80.2%"},null,{"v":0.803921568627451,"d":"80.4%"},null,{"v":0.8058252427184467,"d":"80.6%"},null,{"v":0.8076923076923077,"d":"80.8%"},null,{"v":0.8095238095238095,"d":"81.0%"},null,{"v":0.8181818181818182,"d":"81.8%"},null,{"v":0.8260869565217391,"d":"82.6%"},null,{"v":0.8333333333333334,"d":"83.3%"},null,{"v":0.8400000000000001,"d":"84.0%"},null,{"v":0.8461538461538463,"d":"84.6%"},null,{"v":0.8571428571428572,"d":"85.7%"},null,{"v":0.8666666666666667,"d":"86.7%"}]
[null,{"v":0.9,"d":"90%"},null,{"v":0.900990099009901,"d":"90.1%"},null,{"v":0.9019607843137255,"d":"90.2%"},null,{"v":0.9029126213592233,"d":"90.3%"},null,{"v":0.9038461538461539,"d":"90.4%"},null,{"v":0.9047619047619048,"d":"90.5%"},null,{"v":0.9090909090909091,"d":"90.9%"},null,{"v":0.9130434782608696,"d":"91.3%"},null,{"v":0.9166666666666666,"d":"91.7%"},null,{"v":0.92,"d":"92.0%"},null,{"v":0.9230769230769231,"d":"92.3%"},null,{"v":0.9285714285714286,"d":"92.9%"},null,{"v":0.9333333333333333,"d":"93.3%"}]
[]
[null,"Evolution of profit in % of sales (in percentage points):"]
[]
[null,"Profit (in % of sales) before change",null,"Price increase in %"]
[{"$nulls":3},{"v":0.01,"d":"1%"},null,{"v":0.02,"d":"2%"},null,{"v":0.03,"d":"3%"},null,{"v":0.04,"d":"4%"},null,{"v":0.05,"d":"5%"},null,{"v":0.1,"d":"10%"},null,{"v":0.15,"d":"15%"},null,{"v":0.2,"d":"20%"},null,{"v":0.25,"d":"25%"},null,{"v":0.3,"d":"30%"},null,{"v":0.4,"d":"40%"},null,{"v":0.5,"d":"50%"}]
[null,{"v":0.05,"d":"5%"},null,{"$f":"(1-$B25)*(1-1/(1+D$24))*100","v":{"v":0.9405940594059414,"d":"+1 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+F$24))*100","v":{"v":1.8627450980392195,"d":"+2 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+H$24))*100","v":{"v":2.7669902912621347,"d":"+3 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+J$24))*100","v":{"v":3.6538461538461617,"d":"+4 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+L$24))*100","v":{"v":4.523809523809528,"d":"+5 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+N$24))*100","v":{"v":8.636363636363638,"d":"+9 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+P$24))*100","v":{"v":12.391304347826077,"d":"+12 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+R$24))*100","v":{"v":15.83333333333333,"d":"+16 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+T$24))*100","v":{"v":18.999999999999993,"d":"+19 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+V$24))*100","v":{"v":21.923076923076927,"d":"+22 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+X$24))*100","v":{"v":27.142857142857142,"d":"+27 pts"}},null,{"$f":"(1-$B25)*(1-1/(1+Z$24))*100","v":{"v":31.66666666666667,"d":"+32 pts"}}]
[null,{"v":0.1,"d":"10%"},null,{"v":0.8910891089108919,"d":"+1 pts"},null,{"v":1.764705882352945,"d":"+2 pts"},null,{"v":2.6213592233009697,"d":"+3 pts"},null,{"v":3.4615384615384692,"d":"+3 pts"},null,{"v":4.285714285714291,"d":"+4 pts"},null,{"v":8.181818181818185,"d":"+8 pts"},null,{"v":11.7391304347826,"d":"+12 pts"},null,{"v":14.999999999999996,"d":"+15 pts"},null,{"v":17.999999999999996,"d":"+18 pts"},null,{"v":20.769230769230777,"d":"+21 pts"},null,{"v":25.71428571428571,"d":"+26 pts"},null,{"v":30.000000000000004,"d":"+30 pts"}]
[null,{"v":0.15,"d":"15%"},null,{"v":0.8415841584158423,"d":"+1 pts"},null,{"v":1.66666666666667,"d":"+2 pts"},null,{"v":2.4757281553398047,"d":"+2 pts"},null,{"v":3.2692307692307763,"d":"+3 pts"},null,{"v":4.047619047619052,"d":"+4 pts"},null,{"v":7.72727272727273,"d":"+8 pts"},null,{"v":11.086956521739124,"d":"+11 pts"},null,{"v":14.166666666666664,"d":"+14 pts"},null,{"v":16.999999999999996,"d":"+17 pts"},null,{"v":19.61538461538462,"d":"+20 pts"},null,{"v":24.28571428571428,"d":"+24 pts"},null,{"v":28.33333333333334,"d":"+28 pts"}]
[null,{"v":0.2,"d":"20%"},null,{"v":0.7920792079207928,"d":"+1 pts"},null,{"v":1.5686274509803957,"d":"+2 pts"},null,{"v":2.3300970873786397,"d":"+2 pts"},null,{"v":3.076923076923084,"d":"+3 pts"},null,{"v":3.809523809523814,"d":"+4 pts"},null,{"v":7.272727272727275,"d":"+7 pts"},null,{"v":10.434782608695645,"d":"+10 pts"},null,{"v":13.33333333333333,"d":"+13 pts"},null,{"v":15.999999999999998,"d":"+16 pts"},null,{"v":18.461538461538467,"d":"+18 pts"},null,{"v":22.857142857142858,"d":"+23 pts"},null,{"v":26.66666666666667,"d":"+27 pts"}]
[null,{"v":0.25,"d":"25%"},null,{"v":0.7425742574257432,"d":"+1 pts"},null,{"v":1.4705882352941209,"d":"+1 pts"},null,{"v":2.1844660194174748,"d":"+2 pts"},null,{"v":2.8846153846153912,"d":"+3 pts"},null,{"v":3.5714285714285756,"d":"+4 pts"},null,{"v":6.81818181818182,"d":"+7 pts"},null,{"v":9.782608695652167,"d":"+10 pts"},null,{"v":12.499999999999996,"d":"+13 pts"},null,{"v":14.999999999999996,"d":"+15 pts"},null,{"v":17.307692307692314,"d":"+17 pts"},null,{"v":21.428571428571427,"d":"+21 pts"},null,{"v":25,"d":"+25 pts"}]
[null,{"v":0.3,"d":"30%"},null,{"v":0.6930693069306936,"d":"+1 pts"},null,{"v":1.3725490196078458,"d":"+1 pts"},null,{"v":2.0388349514563098,"d":"+2 pts"},null,{"v":2.692307692307698,"d":"+3 pts"},null,{"v":3.3333333333333366,"d":"+3 pts"},null,{"v":6.363636363636366,"d":"+6 pts"},null,{"v":9.130434782608688,"d":"+9 pts"},null,{"v":11.666666666666663,"d":"+12 pts"},null,{"v":13.999999999999996,"d":"+14 pts"},null,{"v":16.153846153846157,"d":"+16 pts"},null,{"v":20,"d":"+20 pts"},null,{"v":23.333333333333332,"d":"+23 pts"}]
[null,{"v":0.35,"d":"35%"},null,{"v":0.6435643564356441,"d":"+1 pts"},null,{"v":1.2745098039215714,"d":"+1 pts"},null,{"v":1.893203883495145,"d":"+2 pts"},null,{"v":2.5000000000000058,"d":"+3 pts"},null,{"v":3.095238095238099,"d":"+3 pts"},null,{"v":5.909090909090911,"d":"+6 pts"},null,{"v":8.478260869565212,"d":"+8 pts"},null,{"v":10.83333333333333,"d":"+11 pts"},null,{"v":12.999999999999998,"d":"+13 pts"},null,{"v":15.000000000000005,"d":"+15 pts"},null,{"v":18.571428571428573,"d":"+19 pts"},null,{"v":21.66666666666667,"d":"+22 pts"}]
[null,{"v":0.4,"d":"40%"},null,{"v":0.5940594059405946,"d":"+1 pts"},null,{"v":1.1764705882352966,"d":"+1 pts"},null,{"v":1.7475728155339796,"d":"+2 pts"},null,{"v":2.307692307692313,"d":"+2 pts"},null,{"v":2.8571428571428603,"d":"+3 pts"},null,{"v":5.454545454545457,"d":"+5 pts"},null,{"v":7.826086956521734,"d":"+8 pts"},null,{"v":9.999999999999998,"d":"+10 pts"},null,{"v":11.999999999999996,"d":"+12 pts"},null,{"v":13.84615384615385,"d":"+14 pts"},null,{"v":17.14285714285714,"d":"+17 pts"},null,{"v":20,"d":"+20 pts"}]
[null,{"v":0.45,"d":"45%"},null,{"v":0.5445544554455451,"d":"+1 pts"},null,{"v":1.078431372549022,"d":"+1 pts"},null,{"v":1.6019417475728148,"d":"+2 pts"},null,{"v":2.1153846153846203,"d":"+2 pts"},null,{"v":2.619047619047622,"d":"+3 pts"},null,{"v":5.000000000000003,"d":"+5 pts"},null,{"v":7.173913043478257,"d":"+7 pts"},null,{"v":9.166666666666666,"d":"+9 pts"},null,{"v":10.999999999999998,"d":"+11 pts"},null,{"v":12.692307692307697,"d":"+13 pts"},null,{"v":15.714285714285714,"d":"+16 pts"},null,{"v":18.33333333333334,"d":"+18 pts"}]
[null,{"v":0.5,"d":"50%"},null,{"v":0.4950495049504955,"d":"+0 pts"},null,{"v":0.9803921568627472,"d":"+1 pts"},null,{"v":1.4563106796116498,"d":"+1 pts"},null,{"v":1.9230769230769273,"d":"+2 pts"},null,{"v":2.3809523809523836,"d":"+2 pts"},null,{"v":4.545454545454547,"d":"+5 pts"},null,{"v":6.521739130434778,"d":"+7 pts"},null,{"v":8.333333333333332,"d":"+8 pts"},null,{"v":9.999999999999998,"d":"+10 pts"},null,{"v":11.538461538461542,"d":"+12 pts"},null,{"v":14.285714285714285,"d":"+14 pts"},null,{"v":16.666666666666668,"d":"+17 pts"}]
[null,{"v":0.6,"d":"60%"},null,{"v":0.3960396039603964,"d":"+0 pts"},null,{"v":0.7843137254901978,"d":"+1 pts"},null,{"v":1.1650485436893199,"d":"+1 pts"},null,{"v":1.538461538461542,"d":"+2 pts"},null,{"v":1.904761904761907,"d":"+2 pts"},null,{"v":3.6363636363636376,"d":"+4 pts"},null,{"v":5.217391304347823,"d":"+5 pts"},null,{"v":6.666666666666665,"d":"+7 pts"},null,{"v":7.999999999999999,"d":"+8 pts"},null,{"v":9.230769230769234,"d":"+9 pts"},null,{"v":11.428571428571429,"d":"+11 pts"},null,{"v":13.333333333333336,"d":"+13 pts"}]
[null,{"v":0.7,"d":"70%"},null,{"v":0.29702970297029735,"d":"+0 pts"},null,{"v":0.5882352941176483,"d":"+1 pts"},null,{"v":0.87378640776699,"d":"+1 pts"},null,{"v":1.1538461538461564,"d":"+1 pts"},null,{"v":1.4285714285714304,"d":"+1 pts"},null,{"v":2.7272727272727284,"d":"+3 pts"},null,{"v":3.913043478260868,"d":"+4 pts"},null,{"v":5,"d":"+5 pts"},null,{"v":6,"d":"+6 pts"},null,{"v":6.923076923076926,"d":"+7 pts"},null,{"v":8.571428571428573,"d":"+9 pts"},null,{"v":10.000000000000002,"d":"+10 pts"}]
[null,{"v":0.8,"d":"80%"},null,{"v":0.19801980198019814,"d":"+0 pts"},null,{"v":0.3921568627450988,"d":"+0 pts"},null,{"v":0.5825242718446598,"d":"+1 pts"},null,{"v":0.7692307692307707,"d":"+1 pts"},null,{"v":0.9523809523809532,"d":"+1 pts"},null,{"v":1.8181818181818183,"d":"+2 pts"},null,{"v":2.608695652173911,"d":"+3 pts"},null,{"v":3.3333333333333317,"d":"+3 pts"},null,{"v":3.9999999999999982,"d":"+4 pts"},null,{"v":4.615384615384616,"d":"+5 pts"},null,{"v":5.714285714285713,"d":"+6 pts"},null,{"v":6.666666666666667,"d":"+7 pts"}]
[null,{"v":0.9,"d":"90%"},null,{"v":0.09900990099009907,"d":"+0 pts"},null,{"v":0.1960784313725494,"d":"+0 pts"},null,{"v":0.2912621359223299,"d":"+0 pts"},null,{"v":0.38461538461538536,"d":"+0 pts"},null,{"v":0.4761904761904766,"d":"+0 pts"},null,{"v":0.9090909090909092,"d":"+1 pts"},null,{"v":1.3043478260869554,"d":"+1 pts"},null,{"v":1.6666666666666659,"d":"+2 pts"},null,{"v":1.9999999999999991,"d":"+2 pts"},null,{"v":2.307692307692308,"d":"+2 pts"},null,{"v":2.8571428571428563,"d":"+3 pts"},null,{"v":3.3333333333333335,"d":"+3 pts"}]

{"sheet":"Profit growth","index":3,"n_rows":19,"n_cols":14,"rows_kept":19,"merged":[[3,1,4,1],[20,1,22,13]]}
[null,"Price Increase Needed to Grow the Amount of Profit by X%"]
[null,"Price increase in %"]
[]
[null,"Profit (in % of sales) before change","X: % of profit growth"]
[null,null,{"v":0.05,"d":"5%"},{"v":0.1,"d":"10%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.25,"d":"25%"},{"v":0.3,"d":"30%"},{"v":0.4,"d":"40%"},{"v":0.5,"d":"50%"},{"v":0.6,"d":"60%"},{"v":0.8,"d":"80%"},{"v":1,"d":"100%"},{"v":2,"d":"200%"}]
[null,{"v":0.05,"d":"5%"},{"$f":"$B6*C$5","v":{"v":2.5000000000000005E-3,"d":"0%"}},{"$f":"$B6*D$5","v":{"v":5.000000000000001E-3,"d":"1%"}},{"v":0.0075,"d":"1%"},{"v":0.010000000000000002,"d":"1%"},{"v":0.0125,"d":"1%"},{"v":0.015,"d":"2%"},{"v":0.020000000000000004,"d":"2%"},{"v":0.025,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.04000000000000001,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.1,"d":"10%"}]
[null,{"v":0.1,"d":"10%"},{"$f":"$B7*C$5","v":{"v":5.000000000000001E-3,"d":"1%"}},{"v":0.010000000000000002,"d":"1%"},{"v":0.015,"d":"2%"},{"v":0.020000000000000004,"d":"2%"},{"v":0.025,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.04000000000000001,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.08000000000000002,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"}]
[null,{"v":0.15,"d":"15%"},{"$f":"$B8*C$5","v":{"v":0.0075,"d":"1%"}},{"v":0.015,"d":"2%"},{"v":0.0225,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.0375,"d":"4%"},{"v":0.045,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.075,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.3,"d":"30%"}]
[null,{"v":0.2,"d":"20%"},{"v":0.010000000000000002,"d":"1%"},{"v":0.020000000000000004,"d":"2%"},{"v":0.03,"d":"3%"},{"$f":"$B9*F$5","v":{"v":0.04000000000000001,"d":"4%"}},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.08000000000000002,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.12,"d":"12%"},{"v":0.16000000000000003,"d":"16%"},{"v":0.2,"d":"20%"},{"v":0.4,"d":"40%"}]
[null,{"v":0.25,"d":"25%"},{"v":0.0125,"d":"1%"},{"v":0.025,"d":"3%"},{"v":0.0375,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.0625,"d":"6%"},{"v":0.075,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.125,"d":"13%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"}]
[null,{"v":0.3,"d":"30%"},{"v":0.015,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.045,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.075,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.18,"d":"18%"},{"v":0.24,"d":"24%"},{"v":0.3,"d":"30%"},{"v":0.6,"d":"60%"}]
[null,{"v":0.35,"d":"35%"},{"v":0.017499999999999998,"d":"2%"},{"v":0.034999999999999996,"d":"4%"},{"v":0.0525,"d":"5%"},{"v":0.06999999999999999,"d":"7%"},{"v":0.0875,"d":"9%"},{"v":0.105,"d":"11%"},{"v":0.13999999999999999,"d":"14%"},{"v":0.175,"d":"18%"},{"v":0.21,"d":"21%"},{"v":0.27999999999999997,"d":"28%"},{"v":0.35,"d":"35%"},{"v":0.7,"d":"70%"}]
[null,{"v":0.4,"d":"40%"},{"v":0.020000000000000004,"d":"2%"},{"v":0.04000000000000001,"d":"4%"},{"v":0.06,"d":"6%"},{"v":0.08000000000000002,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.12,"d":"12%"},{"v":0.16000000000000003,"d":"16%"},{"v":0.2,"d":"20%"},{"v":0.24,"d":"24%"},{"v":0.32000000000000006,"d":"32%"},{"v":0.4,"d":"40%"},{"v":0.8,"d":"80%"}]
[null,{"v":0.45,"d":"45%"},{"v":0.022500000000000003,"d":"2%"},{"v":0.045000000000000005,"d":"5%"},{"v":0.0675,"d":"7%"},{"v":0.09000000000000001,"d":"9%"},{"v":0.1125,"d":"11%"},{"v":0.135,"d":"14%"},{"v":0.18000000000000002,"d":"18%"},{"v":0.225,"d":"23%"},{"v":0.27,"d":"27%"},{"v":0.36000000000000004,"d":"36%"},{"v":0.45,"d":"45%"},{"v":0.9,"d":"90%"}]
[null,{"v":0.5,"d":"50%"},{"v":0.025,"d":"3%"},{"v":0.05,"d":"5%"},{"v":0.075,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.125,"d":"13%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.25,"d":"25%"},{"v":0.3,"d":"30%"},{"v":0.4,"d":"40%"},{"v":0.5,"d":"50%"},{"v":1,"d":"100%"}]
[null,{"v":0.6,"d":"60%"},{"v":0.03,"d":"3%"},{"v":0.06,"d":"6%"},{"v":0.09,"d":"9%"},{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.18,"d":"18%"},{"v":0.24,"d":"24%"},{"v":0.3,"d":"30%"},{"v":0.36,"d":"36%"},{"v":0.48,"d":"48%"},{"v":0.6,"d":"60%"},{"v":1.2,"d":"120%"}]
[null,{"v":0.7,"d":"70%"},{"v":0.034999999999999996,"d":"4%"},{"v":0.06999999999999999,"d":"7%"},{"v":0.105,"d":"11%"},{"v":0.13999999999999999,"d":"14%"},{"v":0.175,"d":"18%"},{"v":0.21,"d":"21%"},{"v":0.27999999999999997,"d":"28%"},{"v":0.35,"d":"35%"},{"v":0.42,"d":"42%"},{"v":0.5599999999999999,"d":"56%"},{"v":0.7,"d":"70%"},{"v":1.4,"d":"140%"}]
[null,{"v":0.8,"d":"80%"},{"v":0.04000000000000001,"d":"4%"},{"v":0.08000000000000002,"d":"8%"},{"v":0.12,"d":"12%"},{"v":0.16000000000000003,"d":"16%"},{"v":0.2,"d":"20%"},{"v":0.24,"d":"24%"},{"v":0.32000000000000006,"d":"32%"},{"v":0.4,"d":"40%"},{"v":0.48,"d":"48%"},{"v":0.6400000000000001,"d":"64%"},{"v":0.8,"d":"80%"},{"v":1.6,"d":"160%"}]
[null,{"v":0.9,"d":"90%"},{"v":0.045000000000000005,"d":"5%"},{"v":0.09000000000000001,"d":"9%"},{"v":0.135,"d":"14%"},{"v":0.18000000000000002,"d":"18%"},{"v":0.225,"d":"23%"},{"v":0.27,"d":"27%"},{"v":0.36000000000000004,"d":"36%"},{"v":0.45,"d":"45%"},{"v":0.54,"d":"54%"},{"v":0.7200000000000001,"d":"72%"},{"v":0.9,"d":"90%"},{"v":1.8,"d":"180%"}]

{"sheet":"Price discounts","index":4,"n_rows":38,"n_cols":40,"rows_kept":38,"merged":[[3,1,4,3],[5,4,5,5],[5,7,5,8],[5,10,5,11],[5,13,5,14],[5,16,5,17],[5,19,5,20],[5,22,5,23],[5,25,5,26],[5,28,5,29],[5,31,5,32],[5,34,5,35],[5,37,5,38],[6,4,6,5],[6,7,6,8],[6,10,6,11],[6,13,6,14],[6,16,6,17],[6,19,6,20],[6,22,6,23],[6,25,6,26],[6,28,6,29],[6,31,6,32],[6,34,6,35],[6,37,6,38],[7,4,7,5],[7,7,7,8],[7,10,7,11],[7,13,7,14],[7,16,7,17],[7,19,7,20],[7,22,7,23],[7,25,7,26],[7,28,7,29],[7,31,7,32],[7,34,7,35],[7,37,7,38],[8,4,8,5],[8,7,8,8],[8,10,8,11],[8,13,8,14],[8,16,8,17],[8,19,8,20],[8,22,8,23],[8,25,8,26],[8,28,8,29],[8,31,8,32],[8,34,8,35],[8,37,8,38],[9,4,9,5],[9,7,9,8],[9,10,9,11],[9,13,9,14],[9,16,9,17],[9,19,9,20],[9,22,9,23],[9,25,9,26],[9,28,9,29],[9,31,9,32],[9,34,9,35],[9,37,9,38],[10,4,10,5],[10,7,10,8],[10,10,10,11],[10,13,10,14],[10,16,10,17],[10,19,10,20],[10,22,10,23],[10,25,10,26],[10,28,10,29],[10,31,10,32],[10,34,10,35],[10,37,10,38],[11,4,11,5],[11,7,11,8],[11,10,11,11],[11,13,11,14],[11,16,11,17],[11,19,11,20],[11,22,11,23],[11,25,11,26],[11,28,11,29],[11,31,11,32],[11,34,11,35],[11,37,11,38],[12,4,12,5],[12,7,12,8],[12,10,12,11],[12,13,12,14],[12,16,12,17],[12,19,12,20],[12,22,12,23],[12,25,12,26],[12,28,12,29],[12,31,12,32],[12,34,12,35],[12,37,12,38],[13,4,13,5],[13,7,13,8],[13,10,13,11],[13,13,13,14],[13,16,13,17],[13,19,13,20],[13,22,13,23],[13,25,13,26],[13,28,13,29],[13,31,13,32],[13,34,13,35],[13,37,13,38],[14,4,14,5],[14,7,14,8],[14,10,14,11],[14,13,14,14],[14,16,14,17],[14,19,14,20],[14,22,14,23],[14,25,14,26],[14,28,14,29],[14,31,14,32],[14,34,14,35],[14,37,14,38],[15,4,15,5],[15,7,15,8],[15,10,15,11],[15,13,15,14],[15,16,15,17],[15,19,15,20],[15,22,15,23],[15,25,15,26],[15,28,15,29],[15,31,15,32],[15,34,15,35],[15,37,15,38],[16,4,16,5],[16,7,16,8],[16,10,16,11],[16,13,16,14],[16,16,16,17],[16,19,16,20],[16,22,16,23],[16,25,16,26],[16,28,16,29],[16,31,16,32],[16,34,16,35],[16,37,16,38],[17,4,17,5],[17,7,17,8],[17,10,17,11],[17,13,17,14],[17,16,17,17],[17,19,17,20],[17,22,17,23],[17,25,17,26],[17,28,17,29],[17,31,17,32],[17,34,17,35],[17,37,17,38],[18,4,18,5],[18,7,18,8],[18,10,18,11],[18,13,18,14],[18,16,18,17],[18,19,18,20],[18,22,18,23],[18,25,18,26],[18,28,18,29],[18,31,18,32],[18,34,18,35],[18,37,18,38],[22,1,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[23,14,23,15],[23,17,23,18],[23,20,23,21],[23,23,23,24],[23,26,23,27],[23,29,23,30],[23,32,23,33],[23,35,23,36],[23,38,23,39],[24,1,24,3],[24,5,24,6],[24,8,24,9],[24,11,24,12],[24,14,24,15],[24,17,24,18],[24,20,24,21],[24,23,24,24],[24,26,24,27],[24,29,24,30],[24,32,24,33],[24,35,24,36],[24,38,24,39],[25,1,25,3],[25,5,25,6],[25,8,25,9],[25,11,25,12],[25,14,25,15],[25,17,25,18],[25,20,25,21],[25,23,25,24],[25,26,25,27],[25,29,25,30],[25,32,25,33],[25,35,25,36],[25,38,25,39],[26,1,26,3],[26,5,26,6],[26,8,26,9],[26,11,26,12],[26,14,26,15],[26,17,26,18],[26,20,26,21],[26,23,26,24],[26,26,26,27],[26,29,26,30],[26,32,26,33],[26,35,26,36],[26,38,26,39],[27,1,27,3],[27,5,27,6],[27,8,27,9],[27,11,27,12],[27,14,27,15],[27,17,27,18],[27,20,27,21],[27,23,27,24],[27,26,27,27],[27,29,27,30],[27,32,27,33],[27,35,27,36],[27,38,27,39],[28,1,28,3],[28,5,28,6],[28,8,28,9],[28,11,28,12],[28,14,28,15],[28,17,28,18],[28,20,28,21],[28,23,28,24],[28,26,28,27],[28,29,28,30],[28,32,28,33],[28,35,28,36],[28,38,28,39],[29,1,29,3],[29,5,29,6],[29,8,29,9],[29,11,29,12],[29,14,29,15],[29,17,29,18],[29,20,29,21],[29,23,29,24],[29,26,29,27],[29,29,29,30],[29,32,29,33],[29,35,29,36],[29,38,29,39],[30,1,30,3],[30,5,30,6],[30,8,30,9],[30,11,30,12],[30,14,30,15],[30,17,30,18],[30,20,30,21],[30,23,30,24],[30,26,30,27],[30,29,30,30],[30,32,30,33],[30,35,30,36],[30,38,30,39],[31,1,31,3],[31,5,31,6],[31,8,31,9],[31,11,31,12],[31,14,31,15],[31,17,31,18],[31,20,31,21],[31,23,31,24],[31,26,31,27],[31,29,31,30],[31,32,31,33],[31,35,31,36],[31,38,31,39],[32,1,32,3],[32,5,32,6],[32,8,32,9],[32,11,32,12],[32,14,32,15],[32,17,32,18],[32,20,32,21],[32,23,32,24],[32,26,32,27],[32,29,32,30],[32,32,32,33],[32,35,32,36],[32,38,32,39],[33,1,33,3],[33,5,33,6],[33,8,33,9],[33,11,33,12],[33,14,33,15],[33,17,33,18],[33,20,33,21],[33,23,33,24],[33,26,33,27],[33,29,33,30],[33,32,33,33],[33,35,33,36],[33,38,33,39],[34,1,34,3],[34,5,34,6],[34,8,34,9],[34,11,34,12],[34,14,34,15],[34,17,34,18],[34,20,34,21],[34,23,34,24],[34,26,34,27],[34,29,34,30],[34,32,34,33],[34,35,34,36],[34,38,34,39],[35,1,35,3],[35,5,35,6],[35,8,35,9],[35,11,35,12],[35,14,35,15],[35,17,35,18],[35,20,35,21],[35,23,35,24],[35,26,35,27],[35,29,35,30],[35,32,35,33],[35,35,35,36],[35,38,35,39],[36,1,36,3],[36,5,36,6],[36,8,36,9],[36,11,36,12],[36,14,36,15],[36,17,36,18],[36,20,36,21],[36,23,36,24],[36,26,36,27],[36,29,36,30],[36,32,36,33],[36,35,36,36],[36,38,36,39],[37,1,37,3],[37,5,37,6],[37,8,37,9],[37,11,37,12],[37,14,37,15],[37,17,37,18],[37,20,37,21],[37,23,37,24],[37,26,37,27],[37,29,37,30],[37,32,37,33],[37,35,37,36],[37,38,37,39]]}
[null,"Impact of Price Discounts on \"Profit in % of Sales\""]
[null,"New profit (in % of sales) after giving a discount"]
[]
[null,"Profit (in % of sales) before discount",{"$nulls":3},"Price discount (price reduction in %)"]
[{"$nulls":5},{"v":-0.01,"d":"-1%"},null,null,{"v":-0.02,"d":"-2%"},null,null,{"v":-0.03,"d":"-3%"},null,null,{"v":-0.04,"d":"-4%"},null,null,{"v":-0.05,"d":"-5%"},null,null,{"v":-0.1,"d":"-10%"},null,null,{"v":-0.15,"d":"-15%"},null,null,{"v":-0.2,"d":"-20%"},null,null,{"v":-0.25,"d":"-25%"},null,null,{"v":-0.3,"d":"-30%"},null,null,{"v":-0.4,"d":"-40%"},null,null,{"v":-0.5,"d":"-50%"}]
[null,{"v":0.05,"d":"5%"},{"$f":"B6","v":0.05},null,{"$f":"(1-$B6)*(1-1/(1+F$5))+$B6","v":{"v":0.040404040404040345,"d":"4.0%"}},null,{"$f":"E6","v":0.040404040404040345},{"$f":"(1-$B6)*(1-1/(1+I$5))+$B6","v":{"v":0.030612244897959166,"d":"3.1%"}},null,{"$f":"H6","v":0.030612244897959166},{"$f":"(1-$B6)*(1-1/(1+L$5))+$B6","v":{"v":0.020618556701030827,"d":"2.1%"}},null,{"$f":"K6","v":0.020618556701030827},{"$f":"(1-$B6)*(1-1/(1+O$5))+$B6","v":{"v":0.010416666666666602,"d":"1.0%"}},null,{"$f":"N6","v":0.010416666666666602},{"$f":"(1-$B6)*(1-1/(1+R$5))+$B6","v":{"v":6.245004513516506e-17,"d":"0.0%"}},null,{"$f":"Q6","v":6.245004513516506e-17},{"$f":"(1-$B6)*(1-1/(1+U$5))+$B6","v":{"v":-0.055555555555555594,"d":"-5.6%"}},null,{"$f":"T6","v":-0.055555555555555594},{"$f":"(1-$B6)*(1-1/(1+X$5))+$B6","v":{"v":-0.11764705882352945,"d":"-11.8%"}},null,{"$f":"W6","v":-0.11764705882352945},{"$f":"(1-$B6)*(1-1/(1+AA$5))+$B6","v":{"v":-0.1875,"d":"-18.8%"}},null,{"$f":"Z6","v":-0.1875},{"$f":"(1-$B6)*(1-1/(1+AD$5))+$B6","v":{"v":-0.2666666666666666,"d":"-26.7%"}},null,{"$f":"AC6","v":-0.2666666666666666},{"$f":"(1-$B6)*(1-1/(1+AG$5))+$B6","v":{"v":-0.35714285714285715,"d":"-35.7%"}},null,{"$f":"AF6","v":-0.35714285714285715},{"$f":"(1-$B6)*(1-1/(1+AJ$5))+$B6","v":{"v":-0.5833333333333334,"d":"-58.3%"}},null,{"$f":"AI6","v":-0.5833333333333334},{"$f":"(1-$B6)*(1-1/(1+AM$5))+$B6","v":{"v":-0.8999999999999999,"d":"-90.0%"}},null,{"$f":"AL6","v":-0.8999999999999999}]
[null,{"v":0.1,"d":"10%"},0.1,null,{"$f":"(1-$B7)*(1-1/(1+F$5))+$B7","v":{"v":0.09090909090909086,"d":"9.1%"}},null,0.09090909090909086,{"v":0.08163265306122447,"d":"8.2%"},null,0.08163265306122447,{"v":0.07216494845360816,"d":"7.2%"},null,0.07216494845360816,{"v":0.06249999999999994,"d":"6.2%"},null,0.06249999999999994,{"v":0.05263157894736848,"d":"5.3%"},null,0.05263157894736848,{"v":0,"d":"0.0%"},null,0,{"v":-0.05882352941176475,"d":"-5.9%"},null,-0.05882352941176475,{"v":-0.125,"d":"-12.5%"},null,-0.125,{"v":-0.19999999999999993,"d":"-20.0%"},null,-0.19999999999999993,{"v":-0.2857142857142857,"d":"-28.6%"},null,-0.2857142857142857,{"v":-0.5000000000000001,"d":"-50.0%"},null,-0.5000000000000001,{"v":-0.8,"d":"-80.0%"},null,-0.8]
[null,{"v":0.15,"d":"15%"},0.15,null,{"v":0.14141414141414135,"d":"14.1%"},null,0.14141414141414135,{"v":0.13265306122448978,"d":"13.3%"},null,0.13265306122448978,{"v":0.12371134020618546,"d":"12.4%"},null,0.12371134020618546,{"v":0.11458333333333326,"d":"11.5%"},null,0.11458333333333326,{"v":0.10526315789473689,"d":"10.5%"},null,0.10526315789473689,{"v":0.05555555555555551,"d":"5.6%"},null,0.05555555555555551,{"v":0,"d":"0.0%"},null,0,{"v":-0.0625,"d":"-6.3%"},null,-0.0625,{"v":-0.13333333333333328,"d":"-13.3%"},null,-0.13333333333333328,{"v":-0.21428571428571433,"d":"-21.4%"},null,-0.21428571428571433,{"v":-0.41666666666666674,"d":"-41.7%"},null,-0.41666666666666674,{"v":-0.7,"d":"-70.0%"},null,-0.7]
[null,{"v":0.2,"d":"20%"},0.2,null,{"v":0.19191919191919188,"d":"19.2%"},null,0.19191919191919188,{"v":0.18367346938775508,"d":"18.4%"},null,0.18367346938775508,{"v":0.17525773195876282,"d":"17.5%"},null,0.17525773195876282,{"v":0.16666666666666663,"d":"16.7%"},null,0.16666666666666663,{"v":0.1578947368421053,"d":"15.8%"},null,0.1578947368421053,{"v":0.11111111111111108,"d":"11.1%"},null,0.11111111111111108,{"v":0.05882352941176469,"d":"5.9%"},null,0.05882352941176469,{"v":0,"d":"0.0%"},null,0,{"v":-0.0666666666666666,"d":"-6.7%"},null,-0.0666666666666666,{"v":-0.1428571428571429,"d":"-14.3%"},null,-0.1428571428571429,{"v":-0.3333333333333334,"d":"-33.3%"},null,-0.3333333333333334,{"v":-0.6000000000000001,"d":"-60.0%"},null,-0.6000000000000001]
[null,{"v":0.25,"d":"25%"},0.25,null,{"v":0.24242424242424238,"d":"24.2%"},null,0.24242424242424238,{"v":0.2346938775510204,"d":"23.5%"},null,0.2346938775510204,{"v":0.22680412371134012,"d":"22.7%"},null,0.22680412371134012,{"v":0.21874999999999994,"d":"21.9%"},null,0.21874999999999994,{"v":0.21052631578947373,"d":"21.1%"},null,0.21052631578947373,{"v":0.16666666666666663,"d":"16.7%"},null,0.16666666666666663,{"v":0.11764705882352938,"d":"11.8%"},null,0.11764705882352938,{"v":0.0625,"d":"6.3%"},null,0.0625,{"v":0,"d":"0.0%"},null,0,{"v":-0.07142857142857145,"d":"-7.1%"},null,-0.07142857142857145,{"v":-0.25,"d":"-25.0%"},null,-0.25,{"v":-0.5,"d":"-50.0%"},null,-0.5]
[null,{"v":0.3,"d":"30%"},0.3,null,{"v":0.2929292929292929,"d":"29.3%"},null,0.2929292929292929,{"v":0.2857142857142857,"d":"28.6%"},null,0.2857142857142857,{"v":0.2783505154639174,"d":"27.8%"},null,0.2783505154639174,{"v":0.27083333333333326,"d":"27.1%"},null,0.27083333333333326,{"v":0.26315789473684215,"d":"26.3%"},null,0.26315789473684215,{"v":0.22222222222222218,"d":"22.2%"},null,0.22222222222222218,{"v":0.1764705882352941,"d":"17.6%"},null,0.1764705882352941,{"v":0.125,"d":"12.5%"},null,0.125,{"v":0.06666666666666674,"d":"6.7%"},null,0.06666666666666674,{"v":0,"d":"0.0%"},null,0,{"v":-0.16666666666666669,"d":"-16.7%"},null,-0.16666666666666669,{"v":-0.39999999999999997,"d":"-40.0%"},null,-0.39999999999999997]
[null,{"v":0.35,"d":"35%"},0.35,null,{"v":0.34343434343434337,"d":"34.3%"},null,0.34343434343434337,{"v":0.336734693877551,"d":"33.7%"},null,0.336734693877551,{"v":0.32989690721649473,"d":"33.0%"},null,0.32989690721649473,{"v":0.3229166666666666,"d":"32.3%"},null,0.3229166666666666,{"v":0.31578947368421056,"d":"31.6%"},null,0.31578947368421056,{"v":0.27777777777777773,"d":"27.8%"},null,0.27777777777777773,{"v":0.23529411764705876,"d":"23.5%"},null,0.23529411764705876,{"v":0.18749999999999997,"d":"18.8%"},null,0.18749999999999997,{"v":0.13333333333333336,"d":"13.3%"},null,0.13333333333333336,{"v":0.0714285714285714,"d":"7.1%"},null,0.0714285714285714,{"v":-0.08333333333333343,"d":"-8.3%"},null,-0.08333333333333343,{"v":-0.30000000000000004,"d":"-30.0%"},null,-0.30000000000000004]
[null,{"v":0.4,"d":"40%"},0.4,null,{"v":0.3939393939393939,"d":"39.4%"},null,0.3939393939393939,{"v":0.3877551020408163,"d":"38.8%"},null,0.3877551020408163,{"v":0.38144329896907214,"d":"38.1%"},null,0.38144329896907214,{"v":0.375,"d":"37.5%"},null,0.375,{"v":0.368421052631579,"d":"36.8%"},null,0.368421052631579,{"v":0.3333333333333333,"d":"33.3%"},null,0.3333333333333333,{"v":0.29411764705882354,"d":"29.4%"},null,0.29411764705882354,{"v":0.25,"d":"25.0%"},null,0.25,{"v":0.20000000000000007,"d":"20.0%"},null,0.20000000000000007,{"v":0.14285714285714285,"d":"14.3%"},null,0.14285714285714285,{"v":0,"d":"0.0%"},null,0,{"v":-0.19999999999999996,"d":"-20.0%"},null,-0.19999999999999996]
[null,{"v":0.45,"d":"45%"},0.45,null,{"v":0.4444444444444444,"d":"44.4%"},null,0.4444444444444444,{"v":0.4387755102040816,"d":"43.9%"},null,0.4387755102040816,{"v":0.43298969072164945,"d":"43.3%"},null,0.43298969072164945,{"v":0.4270833333333333,"d":"42.7%"},null,0.4270833333333333,{"v":0.4210526315789474,"d":"42.1%"},null,0.4210526315789474,{"v":0.38888888888888884,"d":"38.9%"},null,0.38888888888888884,{"v":0.3529411764705882,"d":"35.3%"},null,0.3529411764705882,{"v":0.3125,"d":"31.3%"},null,0.3125,{"v":0.2666666666666667,"d":"26.7%"},null,0.2666666666666667,{"v":0.21428571428571427,"d":"21.4%"},null,0.21428571428571427,{"v":0.08333333333333326,"d":"8.3%"},null,0.08333333333333326,{"v":-0.10000000000000003,"d":"-10.0%"},null,-0.10000000000000003]
[null,{"v":0.5,"d":"50%"},0.5,null,{"v":0.4949494949494949,"d":"49.5%"},null,0.4949494949494949,{"v":0.4897959183673469,"d":"49.0%"},null,0.4897959183673469,{"v":0.48453608247422675,"d":"48.5%"},null,0.48453608247422675,{"v":0.47916666666666663,"d":"47.9%"},null,0.47916666666666663,{"v":0.4736842105263158,"d":"47.4%"},null,0.4736842105263158,{"v":0.4444444444444444,"d":"44.4%"},null,0.4444444444444444,{"v":0.4117647058823529,"d":"41.2%"},null,0.4117647058823529,{"v":0.375,"d":"37.5%"},null,0.375,{"v":0.33333333333333337,"d":"33.3%"},null,0.33333333333333337,{"v":0.2857142857142857,"d":"28.6%"},null,0.2857142857142857,{"v":0.16666666666666663,"d":"16.7%"},null,0.16666666666666663,{"v":0,"d":"0.0%"},null,0]
[null,{"v":0.6,"d":"60%"},0.6,null,{"v":0.5959595959595959,"d":"59.6%"},null,0.5959595959595959,{"v":0.5918367346938775,"d":"59.2%"},null,0.5918367346938775,{"v":0.5876288659793814,"d":"58.8%"},null,0.5876288659793814,{"v":0.5833333333333333,"d":"58.3%"},null,0.5833333333333333,{"v":0.5789473684210527,"d":"57.9%"},null,0.5789473684210527,{"v":0.5555555555555555,"d":"55.6%"},null,0.5555555555555555,{"v":0.5294117647058824,"d":"52.9%"},null,0.5294117647058824,{"v":0.5,"d":"50.0%"},null,0.5,{"v":0.4666666666666667,"d":"46.7%"},null,0.4666666666666667,{"v":0.4285714285714285,"d":"42.9%"},null,0.4285714285714285,{"v":0.33333333333333326,"d":"33.3%"},null,0.33333333333333326,{"v":0.19999999999999996,"d":"20.0%"},null,0.19999999999999996]
[null,{"v":0.7,"d":"70%"},0.7,null,{"v":0.6969696969696969,"d":"69.7%"},null,0.6969696969696969,{"v":0.6938775510204082,"d":"69.4%"},null,0.6938775510204082,{"v":0.690721649484536,"d":"69.1%"},null,0.690721649484536,{"v":0.6874999999999999,"d":"68.8%"},null,0.6874999999999999,{"v":0.6842105263157895,"d":"68.4%"},null,0.6842105263157895,{"v":0.6666666666666666,"d":"66.7%"},null,0.6666666666666666,{"v":0.6470588235294117,"d":"64.7%"},null,0.6470588235294117,{"v":0.625,"d":"62.5%"},null,0.625,{"v":0.6,"d":"60.0%"},null,0.6,{"v":0.5714285714285714,"d":"57.1%"},null,0.5714285714285714,{"v":0.4999999999999999,"d":"50.0%"},null,0.4999999999999999,{"v":0.3999999999999999,"d":"40.0%"},null,0.3999999999999999]
[null,{"v":0.8,"d":"80%"},0.8,null,{"v":0.797979797979798,"d":"79.8%"},null,0.797979797979798,{"v":0.7959183673469388,"d":"79.6%"},null,0.7959183673469388,{"v":0.7938144329896908,"d":"79.4%"},null,0.7938144329896908,{"v":0.7916666666666667,"d":"79.2%"},null,0.7916666666666667,{"v":0.7894736842105263,"d":"78.9%"},null,0.7894736842105263,{"v":0.7777777777777778,"d":"77.8%"},null,0.7777777777777778,{"v":0.7647058823529412,"d":"76.5%"},null,0.7647058823529412,{"v":0.75,"d":"75.0%"},null,0.75,{"v":0.7333333333333334,"d":"73.3%"},null,0.7333333333333334,{"v":0.7142857142857143,"d":"71.4%"},null,0.7142857142857143,{"v":0.6666666666666667,"d":"66.7%"},null,0.6666666666666667,{"v":0.6000000000000001,"d":"60.0%"},null,0.6000000000000001]
[null,{"v":0.9,"d":"90%"},0.9,null,{"v":0.898989898989899,"d":"89.9%"},null,{"$f":"+E19","v":0.898989898989899},{"v":0.8979591836734694,"d":"89.8%"},null,{"$f":"+H19","v":0.8979591836734694},{"v":0.8969072164948454,"d":"89.7%"},null,{"$f":"+K19","v":0.8969072164948454},{"v":0.8958333333333334,"d":"89.6%"},null,{"$f":"+N19","v":0.8958333333333334},{"v":0.8947368421052632,"d":"89.5%"},null,{"$f":"+Q19","v":0.8947368421052632},{"v":0.888888888888889,"d":"88.9%"},null,{"$f":"+T19","v":0.888888888888889},{"v":0.8823529411764706,"d":"88.2%"},null,{"$f":"+W19","v":0.8823529411764706},{"v":0.875,"d":"87.5%"},null,{"$f":"+Z19","v":0.875},{"v":0.8666666666666667,"d":"86.7%"},null,{"$f":"+AC19","v":0.8666666666666667},{"v":0.8571428571428572,"d":"85.7%"},null,{"$f":"+AF19","v":0.8571428571428572},{"v":0.8333333333333334,"d":"83.3%"},null,{"$f":"+AI19","v":0.8333333333333334},{"v":0.8,"d":"80.0%"},null,{"$f":"+AL19","v":0.8}]
[]
[null,"Evolution of profit in % of sales (in percentage points)"]
[]
[null,"Profit (in % of sales) before discount",{"$nulls":3},"Price discount (price reduction in %)"]
[{"$nulls":5},{"v":-0.01,"d":"-1%"},null,null,{"v":-0.02,"d":"-2%"},null,null,{"v":-0.03,"d":"-3%"},null,null,{"v":-0.04,"d":"-4%"},null,null,{"v":-0.05,"d":"-5%"},null,null,{"v":-0.1,"d":"-10%"},null,null,{"v":-0.15,"d":"-15%"},null,null,{"v":-0.2,"d":"-20%"},null,null,{"v":-0.25,"d":"-25%"},null,null,{"v":-0.3,"d":"-30%"},null,null,{"v":-0.4,"d":"-40%"},null,null,{"v":-0.5,"d":"-50%"}]
[null,{"v":0.05,"d":"5%"},{"$nulls":3},{"$f":"(1-$B25)*(1-1/(1+F$24))*100","v":{"v":-0.9595959595959658,"d":"-1 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+I$24))*100","v":{"v":-1.9387755102040838,"d":"-2 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+L$24))*100","v":{"v":-2.9381443298969177,"d":"-3 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+O$24))*100","v":{"v":-3.95833333333334,"d":"-4 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+R$24))*100","v":{"v":-4.999999999999994,"d":"-5 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+U$24))*100","v":{"v":-10.555555555555559,"d":"-11 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+X$24))*100","v":{"v":-16.764705882352946,"d":"-17 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+AA$24))*100","v":{"v":-23.75,"d":"-24 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+AD$24))*100","v":{"v":-31.66666666666666,"d":"-32 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+AG$24))*100","v":{"v":-40.714285714285715,"d":"-41 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+AJ$24))*100","v":{"v":-63.33333333333334,"d":"-63 pts"}},null,null,{"$f":"(1-$B25)*(1-1/(1+AM$24))*100","v":{"v":-95,"d":"-95 pts"}}]
[null,{"v":0.1,"d":"10%"},{"$nulls":3},{"v":-0.909090909090915,"d":"-1 pts"},null,null,{"v":-1.8367346938775533,"d":"-2 pts"},null,null,{"v":-2.7835051546391854,"d":"-3 pts"},null,null,{"v":-3.7500000000000067,"d":"-4 pts"},null,null,{"v":-4.736842105263152,"d":"-5 pts"},null,null,{"v":-10.000000000000005,"d":"-10 pts"},null,null,{"v":-15.882352941176475,"d":"-16 pts"},null,null,{"v":-22.5,"d":"-23 pts"},null,null,{"v":-29.999999999999993,"d":"-30 pts"},null,null,{"v":-38.57142857142858,"d":"-39 pts"},null,null,{"v":-60.00000000000001,"d":"-60 pts"},null,null,{"v":-90,"d":"-90 pts"}]
[null,{"v":0.15,"d":"15%"},{"$nulls":3},{"$f":"(1-$B27)*(1-1/(1+F$24))*100","v":{"v":-0.8585858585858641,"d":"-1 pts"}},null,null,{"v":-1.7346938775510221,"d":"-2 pts"},null,null,{"v":-2.6288659793814526,"d":"-3 pts"},null,null,{"v":-3.5416666666666727,"d":"-4 pts"},null,null,{"v":-4.473684210526311,"d":"-4 pts"},null,null,{"v":-9.444444444444448,"d":"-9 pts"},null,null,{"v":-15.000000000000002,"d":"-15 pts"},null,null,{"v":-21.25,"d":"-21 pts"},null,null,{"v":-28.33333333333333,"d":"-28 pts"},null,null,{"v":-36.42857142857143,"d":"-36 pts"},null,null,{"v":-56.66666666666668,"d":"-57 pts"},null,null,{"v":-85,"d":"-85 pts"}]
[null,{"v":0.2,"d":"20%"},{"$nulls":3},{"v":-0.8080808080808133,"d":"-1 pts"},null,null,{"v":-1.6326530612244916,"d":"-2 pts"},null,null,{"v":-2.4742268041237208,"d":"-2 pts"},null,null,{"v":-3.3333333333333397,"d":"-3 pts"},null,null,{"v":-4.210526315789469,"d":"-4 pts"},null,null,{"v":-8.888888888888893,"d":"-9 pts"},null,null,{"v":-14.117647058823533,"d":"-14 pts"},null,null,{"v":-20,"d":"-20 pts"},null,null,{"v":-26.66666666666666,"d":"-27 pts"},null,null,{"v":-34.28571428571429,"d":"-34 pts"},null,null,{"v":-53.33333333333334,"d":"-53 pts"},null,null,{"v":-80,"d":"-80 pts"}]
[null,{"v":0.25,"d":"25%"},{"$nulls":3},{"v":-0.7575757575757625,"d":"-1 pts"},null,null,{"v":-1.5306122448979609,"d":"-2 pts"},null,null,{"v":-2.319587628865988,"d":"-2 pts"},null,null,{"v":-3.1250000000000053,"d":"-3 pts"},null,null,{"v":-3.9473684210526274,"d":"-4 pts"},null,null,{"v":-8.333333333333337,"d":"-8 pts"},null,null,{"v":-13.235294117647062,"d":"-13 pts"},null,null,{"v":-18.75,"d":"-19 pts"},null,null,{"v":-24.999999999999993,"d":"-25 pts"},null,null,{"v":-32.142857142857146,"d":"-32 pts"},null,null,{"v":-50,"d":"-50 pts"},null,null,{"v":-75,"d":"-75 pts"}]
[null,{"v":0.3,"d":"30%"},{"$nulls":3},{"v":-0.7070707070707115,"d":"-1 pts"},null,null,{"v":-1.4285714285714302,"d":"-1 pts"},null,null,{"v":-2.164948453608255,"d":"-2 pts"},null,null,{"v":-2.9166666666666714,"d":"-3 pts"},null,null,{"v":-3.684210526315785,"d":"-4 pts"},null,null,{"v":-7.77777777777778,"d":"-8 pts"},null,null,{"v":-12.35294117647059,"d":"-12 pts"},null,null,{"v":-17.5,"d":"-18 pts"},null,null,{"v":-23.333333333333325,"d":"-23 pts"},null,null,{"v":-30,"d":"-30 pts"},null,null,{"v":-46.666666666666664,"d":"-47 pts"},null,null,{"v":-70,"d":"-70 pts"}]
[null,{"v":0.35,"d":"35%"},{"$nulls":3},{"v":-0.6565656565656608,"d":"-1 pts"},null,null,{"v":-1.3265306122448994,"d":"-1 pts"},null,null,{"v":-2.010309278350523,"d":"-2 pts"},null,null,{"v":-2.7083333333333384,"d":"-3 pts"},null,null,{"v":-3.4210526315789433,"d":"-3 pts"},null,null,{"v":-7.222222222222226,"d":"-7 pts"},null,null,{"v":-11.47058823529412,"d":"-11 pts"},null,null,{"v":-16.25,"d":"-16 pts"},null,null,{"v":-21.66666666666666,"d":"-22 pts"},null,null,{"v":-27.857142857142858,"d":"-28 pts"},null,null,{"v":-43.33333333333334,"d":"-43 pts"},null,null,{"v":-65,"d":"-65 pts"}]
[null,{"v":0.4,"d":"40%"},{"$nulls":3},{"v":-0.60606060606061,"d":"-1 pts"},null,null,{"v":-1.2244897959183687,"d":"-1 pts"},null,null,{"v":-1.85567010309279,"d":"-2 pts"},null,null,{"v":-2.5000000000000044,"d":"-3 pts"},null,null,{"v":-3.1578947368421018,"d":"-3 pts"},null,null,{"v":-6.66666666666667,"d":"-7 pts"},null,null,{"v":-10.58823529411765,"d":"-11 pts"},null,null,{"v":-15,"d":"-15 pts"},null,null,{"v":-19.999999999999996,"d":"-20 pts"},null,null,{"v":-25.71428571428572,"d":"-26 pts"},null,null,{"v":-40,"d":"-40 pts"},null,null,{"v":-60,"d":"-60 pts"}]
[null,{"v":0.45,"d":"45%"},{"$nulls":3},{"v":-0.5555555555555592,"d":"-1 pts"},null,null,{"v":-1.122448979591838,"d":"-1 pts"},null,null,{"v":-1.701030927835058,"d":"-2 pts"},null,null,{"v":-2.291666666666671,"d":"-2 pts"},null,null,{"v":-2.89473684210526,"d":"-3 pts"},null,null,{"v":-6.111111111111114,"d":"-6 pts"},null,null,{"v":-9.70588235294118,"d":"-10 pts"},null,null,{"v":-13.750000000000002,"d":"-14 pts"},null,null,{"v":-18.333333333333332,"d":"-18 pts"},null,null,{"v":-23.571428571428573,"d":"-24 pts"},null,null,{"v":-36.66666666666668,"d":"-37 pts"},null,null,{"v":-55.00000000000001,"d":"-55 pts"}]
[null,{"v":0.5,"d":"50%"},{"$nulls":3},{"v":-0.5050505050505083,"d":"-1 pts"},null,null,{"v":-1.0204081632653073,"d":"-1 pts"},null,null,{"v":-1.5463917525773252,"d":"-2 pts"},null,null,{"v":-2.083333333333337,"d":"-2 pts"},null,null,{"v":-2.631578947368418,"d":"-3 pts"},null,null,{"v":-5.555555555555558,"d":"-6 pts"},null,null,{"v":-8.823529411764708,"d":"-9 pts"},null,null,{"v":-12.5,"d":"-13 pts"},null,null,{"v":-16.666666666666664,"d":"-17 pts"},null,null,{"v":-21.42857142857143,"d":"-21 pts"},null,null,{"v":-33.333333333333336,"d":"-33 pts"},null,null,{"v":-50,"d":"-50 pts"}]
[null,{"v":0.6,"d":"60%"},{"$nulls":3},{"v":-0.40404040404040664,"d":"-0 pts"},null,null,{"v":-0.8163265306122458,"d":"-1 pts"},null,null,{"v":-1.2371134020618604,"d":"-1 pts"},null,null,{"v":-1.6666666666666698,"d":"-2 pts"},null,null,{"v":-2.1052631578947345,"d":"-2 pts"},null,null,{"v":-4.444444444444446,"d":"-4 pts"},null,null,{"v":-7.058823529411766,"d":"-7 pts"},null,null,{"v":-10,"d":"-10 pts"},null,null,{"v":-13.33333333333333,"d":"-13 pts"},null,null,{"v":-17.142857142857146,"d":"-17 pts"},null,null,{"v":-26.66666666666667,"d":"-27 pts"},null,null,{"v":-40,"d":"-40 pts"}]
[null,{"v":0.7,"d":"70%"},{"$nulls":3},{"v":-0.30303030303030504,"d":"-0 pts"},null,null,{"v":-0.6122448979591845,"d":"-1 pts"},null,null,{"v":-0.9278350515463952,"d":"-1 pts"},null,null,{"v":-1.2500000000000022,"d":"-1 pts"},null,null,{"v":-1.5789473684210509,"d":"-2 pts"},null,null,{"v":-3.3333333333333353,"d":"-3 pts"},null,null,{"v":-5.294117647058825,"d":"-5 pts"},null,null,{"v":-7.500000000000001,"d":"-8 pts"},null,null,{"v":-10,"d":"-10 pts"},null,null,{"v":-12.85714285714286,"d":"-13 pts"},null,null,{"v":-20.000000000000004,"d":"-20 pts"},null,null,{"v":-30.000000000000004,"d":"-30 pts"}]
[null,{"v":0.8,"d":"80%"},{"$nulls":3},{"v":-0.20202020202020327,"d":"-0 pts"},null,null,{"v":-0.40816326530612285,"d":"-0 pts"},null,null,{"v":-0.61855670103093,"d":"-1 pts"},null,null,{"v":-0.8333333333333347,"d":"-1 pts"},null,null,{"v":-1.052631578947367,"d":"-1 pts"},null,null,{"v":-2.2222222222222228,"d":"-2 pts"},null,null,{"v":-3.5294117647058822,"d":"-4 pts"},null,null,{"v":-4.999999999999999,"d":"-5 pts"},null,null,{"v":-6.666666666666663,"d":"-7 pts"},null,null,{"v":-8.57142857142857,"d":"-9 pts"},null,null,{"v":-13.333333333333334,"d":"-13 pts"},null,null,{"v":-19.999999999999996,"d":"-20 pts"}]
[null,{"v":0.9,"d":"90%"},{"$nulls":3},{"v":-0.10101010101010163,"d":"-0 pts"},null,null,{"v":-0.20408163265306142,"d":"-0 pts"},null,null,{"v":-0.309278350515465,"d":"-0 pts"},null,null,{"v":-0.41666666666666735,"d":"-0 pts"},null,null,{"v":-0.5263157894736835,"d":"-1 pts"},null,null,{"v":-1.1111111111111114,"d":"-1 pts"},null,null,{"v":-1.7647058823529411,"d":"-2 pts"},null,null,{"v":-2.4999999999999996,"d":"-3 pts"},null,null,{"v":-3.3333333333333317,"d":"-3 pts"},null,null,{"v":-4.285714285714285,"d":"-4 pts"},null,null,{"v":-6.666666666666667,"d":"-7 pts"},null,null,{"v":-9.999999999999998,"d":"-10 pts"}]

{"sheet":"Volume increase","index":5,"n_rows":19,"n_cols":14,"rows_kept":19,"merged":[[3,1,4,1],[20,1,22,13]]}
[null,"Compensation of Price Discounts by Volume Increase"]
[null,"Volume increase in % - necessary to maintain the same amount of profit after giving a discount"]
[]
[null,"Profit (in % of sales) before change","Price discount (price reduction in %)"]
[null,null,{"v":-0.01,"d":"-1%"},{"v":-0.02,"d":"-2%"},{"v":-0.03,"d":"-3%"},{"v":-0.04,"d":"-4%"},{"v":-0.05,"d":"-5%"},{"v":-0.1,"d":"-10%"},{"v":-0.15,"d":"-15%"},{"v":-0.2,"d":"-20%"},{"v":-0.25,"d":"-25%"},{"v":-0.3,"d":"-30%"},{"v":-0.4,"d":"-40%"},{"v":-0.5,"d":"-50%"}]
[null,{"v":0.05,"d":"5%"},{"$f":"IF((1-$B6)*(1-1/(1+C$5))+$B6<0.001,\"-\",$B6/((1-$B6)*(1-1/(1+C$5))+$B6)/(1+C$5)-1)","v":{"v":0.2500000000000018,"d":"25%"}},{"$f":"IF((1-$B6)*(1-1/(1+D$5))+$B6<0.001,\"-\",$B6/((1-$B6)*(1-1/(1+D$5))+$B6)/(1+D$5)-1)","v":{"v":0.6666666666666679,"d":"67%"}},{"v":1.5000000000000124,"d":"150%"},{"v":4.000000000000031,"d":"400%"},"-","-","-","-","-","-","-","-"]
[null,{"v":0.1,"d":"10%"},{"v":0.11111111111111183,"d":"11%"},{"v":0.25000000000000044,"d":"25%"},{"v":0.4285714285714304,"d":"43%"},{"v":0.6666666666666685,"d":"67%"},{"v":0.999999999999998,"d":"100%"},"-","-","-","-","-","-","-"]
[null,{"v":0.15,"d":"15%"},{"v":0.07142857142857184,"d":"7%"},{"v":0.15384615384615397,"d":"15%"},{"v":0.2500000000000011,"d":"25%"},{"v":0.36363636363636465,"d":"36%"},{"v":0.49999999999999933,"d":"50%"},{"v":2.000000000000002,"d":"200%"},"-","-","-","-","-","-"]
[null,{"v":0.2,"d":"20%"},{"v":0.05263157894736881,"d":"5%"},{"v":0.11111111111111116,"d":"11%"},{"v":0.17647058823529482,"d":"18%"},{"v":0.25000000000000044,"d":"25%"},{"v":0.33333333333333304,"d":"33%"},{"v":1.0000000000000009,"d":"100%"},{"v":3.0000000000000018,"d":"300%"},"-","-","-","-","-"]
[null,{"v":0.25,"d":"25%"},{"v":0.04166666666666696,"d":"4%"},{"v":0.0869565217391306,"d":"9%"},{"v":0.1363636363636369,"d":"14%"},{"v":0.1904761904761909,"d":"19%"},{"v":0.24999999999999978,"d":"25%"},{"v":0.6666666666666672,"d":"67%"},{"v":1.5000000000000004,"d":"150%"},{"v":4,"d":"400%"},"-","-","-","-"]
[null,{"v":0.3,"d":"30%"},{"v":0.034482758620689724,"d":"3%"},{"v":0.0714285714285714,"d":"7%"},{"v":0.1111111111111116,"d":"11%"},{"v":0.1538461538461542,"d":"15%"},{"v":0.19999999999999973,"d":"20%"},{"v":0.5,"d":"50%"},{"v":1.0000000000000004,"d":"100%"},{"v":1.9999999999999996,"d":"200%"},{"v":4.999999999999994,"d":"500%"},"-","-","-"]
[null,{"v":0.35,"d":"35%"},{"v":0.02941176470588247,"d":"3%"},{"v":0.06060606060606055,"d":"6%"},{"v":0.09375000000000044,"d":"9%"},{"v":0.12903225806451646,"d":"13%"},{"v":0.16666666666666652,"d":"17%"},{"v":0.3999999999999999,"d":"40%"},{"v":0.7500000000000004,"d":"75%"},{"v":1.3333333333333335,"d":"133%"},{"v":2.4999999999999987,"d":"250%"},{"v":6.0000000000000036,"d":"600%"},"-","-"]
[null,{"v":0.4,"d":"40%"},{"v":0.025641025641025772,"d":"3%"},{"v":0.052631578947368585,"d":"5%"},{"v":0.08108108108108136,"d":"8%"},{"v":0.11111111111111116,"d":"11%"},{"v":0.1428571428571428,"d":"14%"},{"v":0.3333333333333335,"d":"33%"},{"v":0.6000000000000001,"d":"60%"},{"v":1,"d":"100%"},{"v":1.666666666666666,"d":"167%"},{"v":3.000000000000001,"d":"300%"},"-","-"]
[null,{"v":0.45,"d":"45%"},{"v":0.02272727272727293,"d":"2%"},{"v":0.04651162790697683,"d":"5%"},{"v":0.07142857142857162,"d":"7%"},{"v":0.09756097560975618,"d":"10%"},{"v":0.125,"d":"13%"},{"v":0.2857142857142858,"d":"29%"},{"v":0.5000000000000002,"d":"50%"},{"v":0.7999999999999998,"d":"80%"},{"v":1.2499999999999996,"d":"125%"},{"v":2.0000000000000004,"d":"200%"},{"v":8.000000000000009,"d":"800%"},"-"]
[null,{"v":0.5,"d":"50%"},{"v":0.020408163265306145,"d":"2%"},{"v":0.04166666666666652,"d":"4%"},{"v":0.06382978723404276,"d":"6%"},{"v":0.08695652173913038,"d":"9%"},{"v":0.11111111111111116,"d":"11%"},{"v":0.25,"d":"25%"},{"v":0.4285714285714288,"d":"43%"},{"v":0.6666666666666665,"d":"67%"},{"v":0.9999999999999998,"d":"100%"},{"v":1.5,"d":"150%"},{"v":4.000000000000002,"d":"400%"},"-"]
[null,{"v":0.6,"d":"60%"},{"v":0.016949152542373058,"d":"2%"},{"v":0.034482758620689724,"d":"3%"},{"v":0.052631578947368585,"d":"5%"},{"v":0.07142857142857162,"d":"7%"},{"v":0.09090909090909105,"d":"9%"},{"v":0.19999999999999996,"d":"20%"},{"v":0.33333333333333326,"d":"33%"},{"v":0.4999999999999998,"d":"50%"},{"v":0.7142857142857142,"d":"71%"},{"v":1.0000000000000004,"d":"100%"},{"v":2.0000000000000004,"d":"200%"},{"v":5.000000000000001,"d":"500%"}]
[null,{"v":0.7,"d":"70%"},{"v":0.01449275362318847,"d":"1%"},{"v":0.02941176470588225,"d":"3%"},{"v":0.044776119402985204,"d":"4%"},{"v":0.060606060606060774,"d":"6%"},{"v":0.07692307692307687,"d":"8%"},{"v":0.16666666666666674,"d":"17%"},{"v":0.2727272727272727,"d":"27%"},{"v":0.3999999999999997,"d":"40%"},{"v":0.5555555555555556,"d":"56%"},{"v":0.7500000000000002,"d":"75%"},{"v":1.3333333333333335,"d":"133%"},{"v":2.5000000000000004,"d":"250%"}]
[null,{"v":0.8,"d":"80%"},{"v":0.012658227848101333,"d":"1%"},{"v":0.02564102564102555,"d":"3%"},{"v":0.03896103896103886,"d":"4%"},{"v":0.052631578947368585,"d":"5%"},{"v":0.06666666666666687,"d":"7%"},{"v":0.14285714285714302,"d":"14%"},{"v":0.23076923076923084,"d":"23%"},{"v":0.33333333333333326,"d":"33%"},{"v":0.45454545454545436,"d":"45%"},{"v":0.6000000000000003,"d":"60%"},{"v":1,"d":"100%"},{"v":1.6666666666666665,"d":"167%"}]
[null,{"v":0.9,"d":"90%"},{"v":0.011235955056179803,"d":"1%"},{"v":0.022727272727272707,"d":"2%"},{"v":0.0344827586206895,"d":"3%"},{"v":0.046511627906976605,"d":"5%"},{"v":0.05882352941176472,"d":"6%"},{"v":0.125,"d":"13%"},{"v":0.19999999999999996,"d":"20%"},{"v":0.2857142857142858,"d":"29%"},{"v":0.3846153846153848,"d":"38%"},{"v":0.5000000000000002,"d":"50%"},{"v":0.8000000000000003,"d":"80%"},{"v":1.25,"d":"125%"}]

{"sheet":"Impact of costs","index":6,"n_rows":38,"n_cols":19,"rows_kept":38,"merged":[[3,1,4,1],[22,1,23,1]]}
[null,"Impact of Cost Variations on \"Profit in % of Sales\""]
[null,"New profit (in % of sales) after cost change"]
[]
[null,"Profit (in % of sales) before change","Cost increase in %",{"$nulls":8},"Cost decrease in %"]
[null,null,{"v":0.2,"d":"20%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.04,"d":"4%"},{"v":0.03,"d":"3%"},{"v":0.02,"d":"2%"},{"v":0.01,"d":"1%"},{"v":0,"d":"0%"},{"v":-0.01,"d":"-1%"},{"v":-0.02,"d":"-2%"},{"v":-0.03,"d":"-3%"},{"v":-0.04,"d":"-4%"},{"v":-0.05,"d":"-5%"},{"v":-0.1,"d":"-10%"},{"v":-0.15,"d":"-15%"},{"v":-0.2,"d":"-20%"}]
[null,{"v":0.05,"d":"5%"},{"$f":"$B6+C25/100","v":{"v":-0.14,"d":"-14.0%"}},{"$f":"$B6+D25/100","v":{"v":-0.09249999999999999,"d":"-9.3%"}},{"v":-0.045,"d":"-4.5%"},{"v":2.5000000000000022E-3,"d":"0.3%"},{"v":0.012000000000000004,"d":"1.2%"},{"v":0.021500000000000005,"d":"2.2%"},{"v":0.031000000000000003,"d":"3.1%"},{"v":0.0405,"d":"4.1%"},null,{"$f":"$B6+L25/100","v":{"v":0.059500000000000004,"d":"6.0%"}},{"v":0.069,"d":"6.9%"},{"v":0.0785,"d":"7.9%"},{"v":0.088,"d":"8.8%"},{"v":0.0975,"d":"9.8%"},{"v":0.14500000000000002,"d":"14.5%"},{"v":0.1925,"d":"19.3%"},{"v":0.24,"d":"24.0%"}]
[null,{"v":0.1,"d":"10%"},{"v":-0.08000000000000004,"d":"-8.0%"},{"v":-0.035,"d":"-3.5%"},{"v":0.009999999999999981,"d":"1.0%"},{"v":0.05499999999999999,"d":"5.5%"},{"v":0.064,"d":"6.4%"},{"v":0.07300000000000001,"d":"7.3%"},{"v":0.082,"d":"8.2%"},{"v":0.091,"d":"9.1%"},null,{"v":0.10900000000000001,"d":"10.9%"},{"v":0.11800000000000001,"d":"11.8%"},{"v":0.127,"d":"12.7%"},{"v":0.136,"d":"13.6%"},{"v":0.14500000000000002,"d":"14.5%"},{"v":0.19000000000000003,"d":"19.0%"},{"v":0.23500000000000001,"d":"23.5%"},{"v":0.28,"d":"28.0%"}]
[null,{"v":0.15,"d":"15%"},{"v":-0.020000000000000018,"d":"-2.0%"},{"v":0.022499999999999992,"d":"2.3%"},{"v":0.06499999999999999,"d":"6.5%"},{"v":0.10749999999999998,"d":"10.8%"},{"v":0.11599999999999999,"d":"11.6%"},{"v":0.1245,"d":"12.5%"},{"v":0.133,"d":"13.3%"},{"v":0.1415,"d":"14.2%"},null,{"v":0.1585,"d":"15.9%"},{"v":0.16699999999999998,"d":"16.7%"},{"v":0.1755,"d":"17.6%"},{"v":0.184,"d":"18.4%"},{"v":0.1925,"d":"19.3%"},{"v":0.235,"d":"23.5%"},{"v":0.27749999999999997,"d":"27.8%"},{"v":0.32,"d":"32.0%"}]
[null,{"v":0.2,"d":"20%"},{"v":0.03999999999999998,"d":"4.0%"},{"v":0.08000000000000002,"d":"8.0%"},{"v":0.12,"d":"12.0%"},{"v":0.16,"d":"16.0%"},{"v":0.168,"d":"16.8%"},{"v":0.17600000000000002,"d":"17.6%"},{"v":0.184,"d":"18.4%"},{"v":0.192,"d":"19.2%"},null,{"v":0.20800000000000002,"d":"20.8%"},{"v":0.21600000000000003,"d":"21.6%"},{"v":0.224,"d":"22.4%"},{"v":0.232,"d":"23.2%"},{"v":0.24000000000000002,"d":"24.0%"},{"v":0.28,"d":"28.0%"},{"v":0.32,"d":"32.0%"},{"v":0.36000000000000004,"d":"36.0%"}]
[null,{"v":0.25,"d":"25%"},{"v":0.09999999999999998,"d":"10.0%"},{"v":0.1375,"d":"13.8%"},{"v":0.175,"d":"17.5%"},{"v":0.2125,"d":"21.3%"},{"v":0.22,"d":"22.0%"},{"v":0.2275,"d":"22.8%"},{"v":0.235,"d":"23.5%"},{"v":0.2425,"d":"24.3%"},null,{"v":0.2575,"d":"25.8%"},{"v":0.265,"d":"26.5%"},{"v":0.2725,"d":"27.3%"},{"v":0.28,"d":"28.0%"},{"v":0.2875,"d":"28.8%"},{"v":0.325,"d":"32.5%"},{"v":0.3625,"d":"36.3%"},{"v":0.4,"d":"40.0%"}]
[null,{"v":0.3,"d":"30%"},{"v":0.16,"d":"16.0%"},{"v":0.195,"d":"19.5%"},{"v":0.22999999999999998,"d":"23.0%"},{"v":0.265,"d":"26.5%"},{"v":0.272,"d":"27.2%"},{"v":0.27899999999999997,"d":"27.9%"},{"v":0.286,"d":"28.6%"},{"v":0.293,"d":"29.3%"},null,{"v":0.307,"d":"30.7%"},{"v":0.314,"d":"31.4%"},{"v":0.321,"d":"32.1%"},{"v":0.32799999999999996,"d":"32.8%"},{"v":0.33499999999999996,"d":"33.5%"},{"v":0.37,"d":"37.0%"},{"v":0.40499999999999997,"d":"40.5%"},{"v":0.43999999999999995,"d":"44.0%"}]
[null,{"v":0.35,"d":"35%"},{"v":0.21999999999999997,"d":"22.0%"},{"v":0.25249999999999995,"d":"25.3%"},{"v":0.285,"d":"28.5%"},{"v":0.3175,"d":"31.8%"},{"v":0.32399999999999995,"d":"32.4%"},{"v":0.33049999999999996,"d":"33.1%"},{"v":0.33699999999999997,"d":"33.7%"},{"v":0.34349999999999997,"d":"34.4%"},null,{"v":0.3565,"d":"35.7%"},{"v":0.363,"d":"36.3%"},{"v":0.3695,"d":"37.0%"},{"v":0.376,"d":"37.6%"},{"v":0.38249999999999995,"d":"38.3%"},{"v":0.415,"d":"41.5%"},{"v":0.4475,"d":"44.8%"},{"v":0.48,"d":"48.0%"}]
[null,{"v":0.4,"d":"40%"},{"v":0.28,"d":"28.0%"},{"v":0.31000000000000005,"d":"31.0%"},{"v":0.34,"d":"34.0%"},{"v":0.37,"d":"37.0%"},{"v":0.376,"d":"37.6%"},{"v":0.382,"d":"38.2%"},{"v":0.388,"d":"38.8%"},{"v":0.394,"d":"39.4%"},null,{"v":0.406,"d":"40.6%"},{"v":0.41200000000000003,"d":"41.2%"},{"v":0.41800000000000004,"d":"41.8%"},{"v":0.42400000000000004,"d":"42.4%"},{"v":0.43000000000000005,"d":"43.0%"},{"v":0.46,"d":"46.0%"},{"v":0.49,"d":"49.0%"},{"v":0.52,"d":"52.0%"}]
[null,{"v":0.45,"d":"45%"},{"v":0.33999999999999997,"d":"34.0%"},{"v":0.3675,"d":"36.8%"},{"v":0.395,"d":"39.5%"},{"v":0.4225,"d":"42.3%"},{"v":0.428,"d":"42.8%"},{"v":0.4335,"d":"43.4%"},{"v":0.439,"d":"43.9%"},{"v":0.4445,"d":"44.5%"},null,{"v":0.4555,"d":"45.6%"},{"v":0.461,"d":"46.1%"},{"v":0.4665,"d":"46.7%"},{"v":0.47200000000000003,"d":"47.2%"},{"v":0.47750000000000004,"d":"47.8%"},{"v":0.505,"d":"50.5%"},{"v":0.5325,"d":"53.3%"},{"v":0.56,"d":"56.0%"}]
[null,{"v":0.5,"d":"50%"},{"v":0.4,"d":"40.0%"},{"v":0.425,"d":"42.5%"},{"v":0.45,"d":"45.0%"},{"v":0.475,"d":"47.5%"},{"v":0.48,"d":"48.0%"},{"v":0.485,"d":"48.5%"},{"v":0.49,"d":"49.0%"},{"v":0.495,"d":"49.5%"},null,{"v":0.505,"d":"50.5%"},{"v":0.51,"d":"51.0%"},{"v":0.515,"d":"51.5%"},{"v":0.52,"d":"52.0%"},{"v":0.525,"d":"52.5%"},{"v":0.55,"d":"55.0%"},{"v":0.575,"d":"57.5%"},{"v":0.6,"d":"60.0%"}]
[null,{"v":0.6,"d":"60%"},{"v":0.52,"d":"52.0%"},{"v":0.54,"d":"54.0%"},{"v":0.5599999999999999,"d":"56.0%"},{"v":0.58,"d":"58.0%"},{"v":0.584,"d":"58.4%"},{"v":0.588,"d":"58.8%"},{"v":0.592,"d":"59.2%"},{"v":0.596,"d":"59.6%"},null,{"v":0.604,"d":"60.4%"},{"v":0.608,"d":"60.8%"},{"v":0.612,"d":"61.2%"},{"v":0.616,"d":"61.6%"},{"v":0.62,"d":"62.0%"},{"v":0.64,"d":"64.0%"},{"v":0.6599999999999999,"d":"66.0%"},{"v":0.6799999999999999,"d":"68.0%"}]
[null,{"v":0.7,"d":"70%"},{"v":0.6399999999999999,"d":"64.0%"},{"v":0.6549999999999999,"d":"65.5%"},{"v":0.6699999999999999,"d":"67.0%"},{"v":0.6849999999999999,"d":"68.5%"},{"v":0.688,"d":"68.8%"},{"v":0.691,"d":"69.1%"},{"v":0.694,"d":"69.4%"},{"v":0.697,"d":"69.7%"},null,{"v":0.703,"d":"70.3%"},{"v":0.706,"d":"70.6%"},{"v":0.709,"d":"70.9%"},{"v":0.712,"d":"71.2%"},{"v":0.715,"d":"71.5%"},{"v":0.73,"d":"73.0%"},{"v":0.745,"d":"74.5%"},{"v":0.76,"d":"76.0%"}]
[null,{"v":0.8,"d":"80%"},{"v":0.76,"d":"76.0%"},{"v":0.77,"d":"77.0%"},{"v":0.78,"d":"78.0%"},{"v":0.79,"d":"79.0%"},{"v":0.792,"d":"79.2%"},{"v":0.794,"d":"79.4%"},{"v":0.796,"d":"79.6%"},{"v":0.798,"d":"79.8%"},null,{"v":0.802,"d":"80.2%"},{"v":0.804,"d":"80.4%"},{"v":0.806,"d":"80.6%"},{"v":0.808,"d":"80.8%"},{"v":0.81,"d":"81.0%"},{"v":0.8200000000000001,"d":"82.0%"},{"v":0.8300000000000001,"d":"83.0%"},{"v":0.8400000000000001,"d":"84.0%"}]
[null,{"v":0.9,"d":"90%"},{"v":0.88,"d":"88.0%"},{"v":0.885,"d":"88.5%"},{"v":0.89,"d":"89.0%"},{"v":0.895,"d":"89.5%"},{"v":0.896,"d":"89.6%"},{"v":0.897,"d":"89.7%"},{"v":0.898,"d":"89.8%"},{"v":0.899,"d":"89.9%"},null,{"v":0.901,"d":"90.1%"},{"v":0.902,"d":"90.2%"},{"v":0.903,"d":"90.3%"},{"v":0.904,"d":"90.4%"},{"v":0.905,"d":"90.5%"},{"v":0.91,"d":"91.0%"},{"v":0.915,"d":"91.5%"},{"v":0.92,"d":"92.0%"}]
[]
[null,"Evolution of profit in % of sales (in percentage points)"]
[]
[null,"Profit (in % of sales) before change","Cost increase in %",{"$nulls":8},"Cost decrease in %"]
[null,null,{"v":0.2,"d":"20%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.04,"d":"4%"},{"v":0.03,"d":"3%"},{"v":0.02,"d":"2%"},{"v":0.01,"d":"1%"},{"v":0,"d":"0%"},{"v":-0.01,"d":"-1%"},{"v":-0.02,"d":"-2%"},{"v":-0.03,"d":"-3%"},{"v":-0.04,"d":"-4%"},{"v":-0.05,"d":"-5%"},{"v":-0.1,"d":"-10%"},{"v":-0.15,"d":"-15%"},{"v":-0.2,"d":"-20%"}]
[null,{"v":0.05,"d":"5%"},{"$f":"(1-$B25)*-C$24*100","v":{"v":-19,"d":"-19 pts"}},{"v":-14.249999999999998,"d":"-14 pts"},{"v":-9.5,"d":"-10 pts"},{"v":-4.75,"d":"-5 pts"},{"v":-3.8,"d":"-4 pts"},{"v":-2.8499999999999996,"d":"-3 pts"},{"v":-1.9,"d":"-2 pts"},{"v":-0.95,"d":"-1 pts"},null,{"$f":"(1-$B25)*-L$24*100","v":{"v":0.95,"d":"+1 pts"}},{"v":1.9,"d":"+2 pts"},{"v":2.8499999999999996,"d":"+3 pts"},{"v":3.8,"d":"+4 pts"},{"v":4.75,"d":"+5 pts"},{"v":9.5,"d":"+10 pts"},{"v":14.249999999999998,"d":"+14 pts"},{"v":19,"d":"+19 pts"}]
[null,{"v":0.1,"d":"10%"},{"v":-18.000000000000004,"d":"-18 pts"},{"v":-13.5,"d":"-14 pts"},{"v":-9.000000000000002,"d":"-9 pts"},{"v":-4.500000000000001,"d":"-5 pts"},{"v":-3.6000000000000005,"d":"-4 pts"},{"v":-2.7,"d":"-3 pts"},{"v":-1.8000000000000003,"d":"-2 pts"},{"v":-0.9000000000000001,"d":"-1 pts"},null,{"v":0.9000000000000001,"d":"+1 pts"},{"v":1.8000000000000003,"d":"+2 pts"},{"v":2.7,"d":"+3 pts"},{"v":3.6000000000000005,"d":"+4 pts"},{"v":4.500000000000001,"d":"+5 pts"},{"v":9.000000000000002,"d":"+9 pts"},{"v":13.5,"d":"+14 pts"},{"v":18.000000000000004,"d":"+18 pts"}]
[null,{"v":0.15,"d":"15%"},{"$f":"(1-$B27)*-C$24*100","v":{"v":-17,"d":"-17 pts"}},{"v":-12.75,"d":"-13 pts"},{"v":-8.5,"d":"-9 pts"},{"v":-4.25,"d":"-4 pts"},{"v":-3.4000000000000004,"d":"-3 pts"},{"v":-2.55,"d":"-3 pts"},{"v":-1.7000000000000002,"d":"-2 pts"},{"v":-0.8500000000000001,"d":"-1 pts"},null,{"v":0.8500000000000001,"d":"+1 pts"},{"v":1.7000000000000002,"d":"+2 pts"},{"v":2.55,"d":"+3 pts"},{"v":3.4000000000000004,"d":"+3 pts"},{"v":4.25,"d":"+4 pts"},{"v":8.5,"d":"+9 pts"},{"v":12.75,"d":"+13 pts"},{"v":17,"d":"+17 pts"}]
[null,{"v":0.2,"d":"20%"},{"v":-16.000000000000004,"d":"-16 pts"},{"v":-12,"d":"-12 pts"},{"v":-8.000000000000002,"d":"-8 pts"},{"v":-4.000000000000001,"d":"-4 pts"},{"v":-3.2,"d":"-3 pts"},{"v":-2.4,"d":"-2 pts"},{"v":-1.6,"d":"-2 pts"},{"v":-0.8,"d":"-1 pts"},null,{"v":0.8,"d":"+1 pts"},{"v":1.6,"d":"+2 pts"},{"v":2.4,"d":"+2 pts"},{"v":3.2,"d":"+3 pts"},{"v":4.000000000000001,"d":"+4 pts"},{"v":8.000000000000002,"d":"+8 pts"},{"v":12,"d":"+12 pts"},{"v":16.000000000000004,"d":"+16 pts"}]
[null,{"v":0.25,"d":"25%"},{"v":-15.000000000000002,"d":"-15 pts"},{"v":-11.249999999999998,"d":"-11 pts"},{"v":-7.500000000000001,"d":"-8 pts"},{"v":-3.7500000000000004,"d":"-4 pts"},{"v":-3,"d":"-3 pts"},{"v":-2.25,"d":"-2 pts"},{"v":-1.5,"d":"-2 pts"},{"v":-0.75,"d":"-1 pts"},null,{"v":0.75,"d":"+1 pts"},{"v":1.5,"d":"+2 pts"},{"v":2.25,"d":"+2 pts"},{"v":3,"d":"+3 pts"},{"v":3.7500000000000004,"d":"+4 pts"},{"v":7.500000000000001,"d":"+8 pts"},{"v":11.249999999999998,"d":"+11 pts"},{"v":15.000000000000002,"d":"+15 pts"}]
[null,{"v":0.3,"d":"30%"},{"v":-13.999999999999998,"d":"-14 pts"},{"v":-10.5,"d":"-11 pts"},{"v":-6.999999999999999,"d":"-7 pts"},{"v":-3.4999999999999996,"d":"-4 pts"},{"v":-2.8,"d":"-3 pts"},{"v":-2.0999999999999996,"d":"-2 pts"},{"v":-1.4,"d":"-1 pts"},{"v":-0.7,"d":"-1 pts"},null,{"v":0.7,"d":"+1 pts"},{"v":1.4,"d":"+1 pts"},{"v":2.0999999999999996,"d":"+2 pts"},{"v":2.8,"d":"+3 pts"},{"v":3.4999999999999996,"d":"+4 pts"},{"v":6.999999999999999,"d":"+7 pts"},{"v":10.5,"d":"+11 pts"},{"v":13.999999999999998,"d":"+14 pts"}]
[null,{"v":0.35,"d":"35%"},{"v":-13,"d":"-13 pts"},{"v":-9.75,"d":"-10 pts"},{"v":-6.5,"d":"-7 pts"},{"v":-3.25,"d":"-3 pts"},{"v":-2.6,"d":"-3 pts"},{"v":-1.95,"d":"-2 pts"},{"v":-1.3,"d":"-1 pts"},{"v":-0.65,"d":"-1 pts"},null,{"v":0.65,"d":"+1 pts"},{"v":1.3,"d":"+1 pts"},{"v":1.95,"d":"+2 pts"},{"v":2.6,"d":"+3 pts"},{"v":3.25,"d":"+3 pts"},{"v":6.5,"d":"+7 pts"},{"v":9.75,"d":"+10 pts"},{"v":13,"d":"+13 pts"}]
[null,{"v":0.4,"d":"40%"},{"v":-12,"d":"-12 pts"},{"v":-9,"d":"-9 pts"},{"v":-6,"d":"-6 pts"},{"v":-3,"d":"-3 pts"},{"v":-2.4,"d":"-2 pts"},{"v":-1.7999999999999998,"d":"-2 pts"},{"v":-1.2,"d":"-1 pts"},{"v":-0.6,"d":"-1 pts"},null,{"v":0.6,"d":"+1 pts"},{"v":1.2,"d":"+1 pts"},{"v":1.7999999999999998,"d":"+2 pts"},{"v":2.4,"d":"+2 pts"},{"v":3,"d":"+3 pts"},{"v":6,"d":"+6 pts"},{"v":9,"d":"+9 pts"},{"v":12,"d":"+12 pts"}]
[null,{"v":0.45,"d":"45%"},{"v":-11.000000000000002,"d":"-11 pts"},{"v":-8.25,"d":"-8 pts"},{"v":-5.500000000000001,"d":"-6 pts"},{"v":-2.7500000000000004,"d":"-3 pts"},{"v":-2.2,"d":"-2 pts"},{"v":-1.6500000000000001,"d":"-2 pts"},{"v":-1.1,"d":"-1 pts"},{"v":-0.55,"d":"-1 pts"},null,{"v":0.55,"d":"+1 pts"},{"v":1.1,"d":"+1 pts"},{"v":1.6500000000000001,"d":"+2 pts"},{"v":2.2,"d":"+2 pts"},{"v":2.7500000000000004,"d":"+3 pts"},{"v":5.500000000000001,"d":"+6 pts"},{"v":8.25,"d":"+8 pts"},{"v":11.000000000000002,"d":"+11 pts"}]
[null,{"v":0.5,"d":"50%"},{"v":-10,"d":"-10 pts"},{"v":-7.5,"d":"-8 pts"},{"v":-5,"d":"-5 pts"},{"v":-2.5,"d":"-3 pts"},{"v":-2,"d":"-2 pts"},{"v":-1.5,"d":"-2 pts"},{"v":-1,"d":"-1 pts"},{"v":-0.5,"d":"-1 pts"},null,{"v":0.5,"d":"+1 pts"},{"v":1,"d":"+1 pts"},{"v":1.5,"d":"+2 pts"},{"v":2,"d":"+2 pts"},{"v":2.5,"d":"+3 pts"},{"v":5,"d":"+5 pts"},{"v":7.5,"d":"+8 pts"},{"v":10,"d":"+10 pts"}]
[null,{"v":0.6,"d":"60%"},{"v":-8.000000000000002,"d":"-8 pts"},{"v":-6,"d":"-6 pts"},{"v":-4.000000000000001,"d":"-4 pts"},{"v":-2.0000000000000004,"d":"-2 pts"},{"v":-1.6,"d":"-2 pts"},{"v":-1.2,"d":"-1 pts"},{"v":-0.8,"d":"-1 pts"},{"v":-0.4,"d":"-0 pts"},null,{"v":0.4,"d":"+0 pts"},{"v":0.8,"d":"+1 pts"},{"v":1.2,"d":"+1 pts"},{"v":1.6,"d":"+2 pts"},{"v":2.0000000000000004,"d":"+2 pts"},{"v":4.000000000000001,"d":"+4 pts"},{"v":6,"d":"+6 pts"},{"v":8.000000000000002,"d":"+8 pts"}]
[null,{"v":0.7,"d":"70%"},{"v":-6.000000000000001,"d":"-6 pts"},{"v":-4.500000000000001,"d":"-5 pts"},{"v":-3.0000000000000004,"d":"-3 pts"},{"v":-1.5000000000000002,"d":"-2 pts"},{"v":-1.2000000000000002,"d":"-1 pts"},{"v":-0.9000000000000001,"d":"-1 pts"},{"v":-0.6000000000000001,"d":"-1 pts"},{"v":-0.30000000000000004,"d":"-0 pts"},null,{"v":0.30000000000000004,"d":"+0 pts"},{"v":0.6000000000000001,"d":"+1 pts"},{"v":0.9000000000000001,"d":"+1 pts"},{"v":1.2000000000000002,"d":"+1 pts"},{"v":1.5000000000000002,"d":"+2 pts"},{"v":3.0000000000000004,"d":"+3 pts"},{"v":4.500000000000001,"d":"+5 pts"},{"v":6.000000000000001,"d":"+6 pts"}]
[null,{"v":0.8,"d":"80%"},{"v":-3.9999999999999996,"d":"-4 pts"},{"v":-2.999999999999999,"d":"-3 pts"},{"v":-1.9999999999999998,"d":"-2 pts"},{"v":-0.9999999999999999,"d":"-1 pts"},{"v":-0.7999999999999998,"d":"-1 pts"},{"v":-0.5999999999999999,"d":"-1 pts"},{"v":-0.3999999999999999,"d":"-0 pts"},{"v":-0.19999999999999996,"d":"-0 pts"},null,{"v":0.19999999999999996,"d":"+0 pts"},{"v":0.3999999999999999,"d":"+0 pts"},{"v":0.5999999999999999,"d":"+1 pts"},{"v":0.7999999999999998,"d":"+1 pts"},{"v":0.9999999999999999,"d":"+1 pts"},{"v":1.9999999999999998,"d":"+2 pts"},{"v":2.999999999999999,"d":"+3 pts"},{"v":3.9999999999999996,"d":"+4 pts"}]
[null,{"v":0.9,"d":"90%"},{"v":-1.9999999999999998,"d":"-2 pts"},{"v":-1.4999999999999996,"d":"-2 pts"},{"v":-0.9999999999999999,"d":"-1 pts"},{"v":-0.49999999999999994,"d":"-1 pts"},{"v":-0.3999999999999999,"d":"-0 pts"},{"v":-0.29999999999999993,"d":"-0 pts"},{"v":-0.19999999999999996,"d":"-0 pts"},{"v":-0.09999999999999998,"d":"-0 pts"},null,{"v":0.09999999999999998,"d":"+0 pts"},{"v":0.19999999999999996,"d":"+0 pts"},{"v":0.29999999999999993,"d":"+0 pts"},{"v":0.3999999999999999,"d":"+0 pts"},{"v":0.49999999999999994,"d":"+1 pts"},{"v":0.9999999999999999,"d":"+1 pts"},{"v":1.4999999999999996,"d":"+2 pts"},{"v":1.9999999999999998,"d":"+2 pts"}]