{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Inputs","BenefitDetails","CostDetails","Results","Settings","$Vars","$Lists"],"not_rendered":{"charts":5,"macros":1,"defined_names":262},"read":"whole","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":98,"n_cols":14,"rows_kept":98,"merged":[[4,3,4,11],[5,3,5,11],[6,3,6,11],[6,13,6,17],[9,2,11,3],[9,4,9,11],[10,4,10,11],[11,4,11,11],[13,3,13,11],[23,3,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[24,7,24,8],[29,3,29,7],[30,3,30,7],[31,3,31,7],[32,3,32,7],[33,3,33,7],[34,3,34,7],[35,3,35,7],[36,3,36,7],[37,3,37,7],[40,3,40,7],[41,3,41,7],[42,3,42,7],[43,3,43,7],[46,3,46,7],[47,3,47,7],[48,3,48,7],[49,3,49,7],[50,3,50,7],[54,3,54,7],[55,3,55,7],[56,3,56,7],[57,3,57,7],[58,3,58,7],[61,3,61,7],[62,3,62,7],[63,3,63,7],[64,3,64,7],[71,3,71,8],[74,3,74,8],[75,3,75,8],[76,3,76,8],[86,3,86,8],[96,3,96,4],[97,3,97,14]]}
[]
[]
[]
[]
[{"$nulls":3},{"$f":"_xlfn.CONCAT(\"By answering the questions below, you will receive free access to a high-level estimate of the Total Economic Impact of \",varVendorProductName,\" (registration is required).\")","v":"By answering the questions below, you will receive free access to a high-level estimate of the Total Economic Impact of Salesforce Commerce Cloud Direct To Consumer (registration is required)."}]
[]
[{"$nulls":3},{"$f":"CONCATENATE(\"This interactive model is based upon Forrester's Total Economic Impact framework and investigates hypothetical benefits to pursuing two new use cases: first party data and breakout brands. Working with \",varVendorName,\" Forrester identified and created a framework to quantify key upside benefits of investing in Commerce Cloud, including:\")","v":"This interactive model is based upon Forrester's Total Economic Impact framework and investigates hypothetical benefits to pursuing two new use cases: first party data and breakout brands. Working with Salesforce Forrester identified and created a framework to quantify key upside benefits of investing in Commerce Cloud, including:"},{"$nulls":9},"Note: To convert currency, you must enable the macro in this workbook. The macro's only functionality is to convert USD to the currency you select in the drop down below. "]
[]
[]
[null,null,"High-level Benefit Categories",null,{"$f":"BenefitDetails!E11","v":"First party data: incremental operating profit in D2C channel"}]
[{"$nulls":4},{"$f":"BenefitDetails!E12","v":"First party data: incremental operating profit in B2B channel"}]
[{"$nulls":4},{"$f":"BenefitDetails!E13","v":"Breakout brand: incremental conversions"}]
[]
[{"$nulls":3},"To use, move sliders or enter values to receive a <span class=\"span-bold span-italics\">high-level estimate</span> of the economic impact based on your specific business environment. Default input values represent data from the case study."]
[]
[null,null,"NPV:",null,null,"ROI:"]
[]
[]
[null,null,"div container-fluid_"]
[null,null,"div row_",null,{"$f":"\"<- REMOVE class 'row-align-items-center' or 'align-items-center' for green box to align to the top instead of middle\"","v":"<- REMOVE class 'row-align-items-center' or 'align-items-center' for green box to align to the top instead of middle"}]
[null,null,"div col slider-sidebar_"]
[]
[]
[{"$nulls":3},"Please select currency:",{"$nulls":3},"US Dollar"]
[{"$nulls":7},{"$f":"CONCATENATE(\"Exchange rate: \",TEXT(varExchangeRate,\"0.0000\"))","v":"Exchange rate: 1.0000"}]
[]
[{"$nulls":3},"Benefit Inputs"]
[{"$nulls":3},"First party data: incremental operating profit in D2C channel"]
[{"$nulls":9},{"$f":"\"Min Displayed\"","v":"Min Displayed"},{"$f":"\"Max Displayed\"","v":"Max Displayed"},"Initial Value","Input"]
[{"$nulls":3},"Monthly site visitors in D2C channel",{"$nulls":5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L30","v":0},0,{"$f":"L30","v":0}]
[{"$nulls":3},"Average order value in D2C channel",{"$nulls":7},{"$f":"0*varExchangeRate","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":3},"Conversion rate for D2C channel today",{"$nulls":7},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[{"$nulls":3},"Anticipated percentage point increase in conversion rate with first party data",{"$nulls":7},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[{"$nulls":3},"Percent of site visitors that can be targeted for cross-sell / upsell",{"$nulls":7},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[{"$nulls":3},"Expected percent increase in average order value with first party data",{"$nulls":7},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[{"$nulls":3},"Ratio of returning site visitors to all visitors",{"$nulls":7},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[{"$nulls":3},"Expected percent increase in ratio with first party data",{"$nulls":7},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[{"$nulls":3},"Average D2C operating margin",{"$nulls":5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L38","v":0},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[{"$nulls":3},"First party data: incremental operating profit in B2B channel"]
[{"$nulls":9},{"$f":"\"Min Displayed\"","v":"Min Displayed"},{"$f":"\"Max Displayed\"","v":"Max Displayed"},{"$f":"L29","v":"Initial Value"},"Input"]
[{"$nulls":3},"Number of buyers purchasing through B2B Commerce channel, annual",{"$nulls":7},0,{"$f":"L41","v":0}]
[{"$nulls":3},"Average annual revenue per buyer",{"$nulls":7},{"$f":"0*varExchangeRate","v":{"v":0,"d":"$0"}},{"$f":"L42","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Annual revenue uplift with increased conversion, cross-sell / upsell, and retention of end consumer",{"$nulls":7},{"v":0,"d":"0%"},{"$f":"L43","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Average B2B operating margin",{"$nulls":7},{"v":0,"d":"0%"},{"$f":"L44","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Breakout brand: incremental conversions for breakout brand"]
[{"$nulls":9},{"$f":"\"Min Displayed\"","v":"Min Displayed"},{"$f":"\"Max Displayed\"","v":"Max Displayed"},{"$f":"L29","v":"Initial Value"},"Input"]
[{"$nulls":3},"Target monthly leads for breakout brand",{"$nulls":5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L47","v":{"v":0,"d":"$0"}},0,{"$f":"L47","v":0}]
[{"$nulls":3},"Average conversion rate for breakout brands prior to Salesforce",{"$nulls":7},{"v":0,"d":"0%"},{"$f":"L48","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Increase in conversion rate percentage point with Salesforce",{"$nulls":7},{"v":0,"d":"0%"},{"$f":"L49","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"AOV for breakout brands",{"$nulls":5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L50","v":0},{"$f":"0*varExchangeRate","v":{"v":0,"d":"$0"}},{"$f":"L50","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Average operating margin for breakout brands (cross-channel mix)",{"$nulls":5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L51","v":{"v":0,"d":"$0"}},{"v":0,"d":"0%"},{"$f":"L51","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Cost Inputs"]
[{"$nulls":3},"First party data analysis cost"]
[{"$nulls":9},{"$f":"\"Min Displayed\"","v":"Min Displayed"},{"$f":"\"Max Displayed\"","v":"Max Displayed"},{"$f":"L29","v":"Initial Value"},"Input"]
[{"$nulls":3},"Number of FTEs to collect and analyze first party data",{"$nulls":7},0,{"$f":"L55","v":0}]
[{"$nulls":3},"Months spent on data analysis",{"$nulls":7},0,{"$f":"L56","v":0}]
[{"$nulls":3},"Annual hours to communiate and implement recommendations in D2C channel",{"$nulls":7},0,{"$f":"L57","v":0}]
[{"$nulls":3},"Annual hours to communiate and implement recommendations in B2B channel",{"$nulls":7},0,{"$f":"L58","v":0}]
[{"$nulls":3},"Average annual fully-burdened compensation fo analysis and implementation team",{"$nulls":7},{"$f":"0*varExchangeRate","v":{"v":0,"d":"$0"}},{"$f":"L59","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Breakout brand: test cost"]
[{"$nulls":9},{"$f":"\"Min Displayed\"","v":"Min Displayed"},{"$f":"\"Max Displayed\"","v":"Max Displayed"},{"$f":"L54","v":"Initial Value"},"Input"]
[{"$nulls":3},"Number of months to test launch breakout brand with small audience in D2C channel",{"$nulls":7},0,{"$f":"L62","v":0}]
[{"$nulls":3},"Average cost per month to test",{"$nulls":7},{"$f":"0*varExchangeRate","v":{"v":0,"d":"$0"}},{"$f":"L63","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Number of hours spent on data analysis and profile development",{"$nulls":7},0,{"$f":"L64","v":0}]
[{"$nulls":3},"Average hourly fully-burdened compensation for analysis team",{"$nulls":7},{"$f":"0*varExchangeRate","v":{"v":0,"d":"$0"}},{"$f":"L65","v":{"v":0,"d":"$0"}}]
[null,null,"div end col slider-sidebar_"]
[null,null,"div col_"]
[null,null,"div totalNPVArea_"]
[]
[{"$nulls":5},{"$f":"Results!$M$50","v":{"v":0,"d":"$0"}},{"$f":"_xlfn.CONCAT(varCurrencySymbol,\"<span class='blur-text'>\",TEXT(ABS(F70),\"#,000\"),\"</span>\")","v":"$<span class='blur-text'>000</span>"}]
[{"$nulls":5},{"$f":"F70","v":{"v":0,"d":"$0"}},{"$f":"_xlfn.CONCAT(varCurrencySymbol,\"<span class='blur-text'>\",TEXT(ABS(F71)/(IF(F71>=1000000,1000000,100000)),\"0.000\"),IF(F71>=1000000,\"M\",\"K\"),\"</span>\")","v":"$<span class='blur-text'>0.000K</span>"}]
[{"$nulls":3},{"$f":"_xlfn.CONCAT(\"Your estimated \",LOWER(varNumberPeriodsWord),\"-year net present value (NPV)\")","v":"Your estimated three-year net present value (NPV)"}]
[{"$nulls":5},{"$f":"Results!$M$51","v":"----"},{"$f":"_xlfn.CONCAT(\"<span class='blur-text'>\",TEXT(F73*100,\"0\"),\"</span>%\")","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":3},{"$f":"_xlfn.CONCAT(\"Your estimated \",LOWER(varNumberPeriodsWord),\"-year return on investment (ROI)\")","v":"Your estimated three-year return on investment (ROI)"}]
[{"$nulls":3},"Download <span style='font-weight:bold'>your custom business case (PDF)</span> to see all calculations, tables, charts, and ROI!"]
[{"$nulls":3},{"$f":"'$Vars'!C55","v":"Cookie acceptance is required to register"}]
[]
[]
[]
[null,null,"div end totalNPVArea_"]
[]
[]
[]
[null,null,"div end col_"]
[null,null,"div end row_"]
[{"$nulls":3},{"$f":"tCookieAcceptance","v":"Cookie acceptance is required to register"}]
[]
[]
[]
[]
[null,null,"div end container-fluid_"]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"varCookieSettingsFooter","v":"Cookie settings"}]
[{"$nulls":3},{"$f":"varCopyrightFooter","v":"© 2021, Forrester Research, Inc. All rights reserved. This work is commissioned by Salesforce and delivered by Forrester Consulting."}]

{"sheet":"BenefitDetails","index":1,"n_rows":98,"n_cols":15,"rows_kept":98,"merged":[[8,3,8,12],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[33,3,33,12],[34,3,34,12],[35,3,35,5],[35,6,35,8],[36,3,36,8],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[59,3,59,12],[60,3,60,12],[61,3,61,12],[62,3,62,8],[63,4,63,5],[64,4,64,5],[65,4,65,5],[66,4,66,5],[67,4,67,5],[68,4,68,5],[69,4,69,5],[70,4,70,5],[71,4,71,5],[72,4,72,5],[73,4,73,5],[77,3,77,12],[78,3,78,12],[79,3,79,8],[80,4,80,5],[81,4,81,5],[82,4,82,5],[83,4,83,5],[84,4,84,5],[85,4,85,5],[86,4,86,5],[87,4,87,5],[88,4,88,5],[89,4,89,5],[90,4,90,5],[91,4,91,5],[96,3,96,4],[97,3,97,12]]}
{"$rows_empty":8}
[{"$nulls":3},{"$f":"tTotalBenefit_t","v":"Total Benefit"}]
[{"$nulls":3},{"$f":"varRef","v":"Ref."},{"$f":"IF(\"Benefit\"=\"Benefit\",tBenefit,\"Benefit\")","v":"Benefit"},null,null,{"$f":"varp0","v":"Initial"},{"$f":"varp1","v":"Year 1"},{"$f":"varp2","v":"Year 2"},{"$f":"varp3","v":"Year 3"},{"$f":"varTotal","v":"Total"},{"$f":"varPresentValue","v":"Present Value"}]
[{"$nulls":3},{"$f":"$D$53","v":"Atr"},{"$f":"$D$35","v":"First party data: incremental operating profit in D2C channel"},null,null,{"$f":"$H$53","v":{"v":0,"d":"$0"}},{"$f":"$I$53","v":{"v":0,"d":"$0"}},{"$f":"$J$53","v":{"v":0,"d":"$0"}},{"$f":"$K$53","v":{"v":0,"d":"$0"}},{"$f":"$L$53","v":{"v":0,"d":"$0"}},{"$f":"$M$53","v":{"v":0,"d":"$0"}},{"$f":"IF($M$14<>0,$M$11/$M$14,\"----\")","v":"----"}]
[{"$nulls":3},{"$f":"$D$71","v":"Btr"},{"$f":"$D$61","v":"First party data: incremental operating profit in B2B channel"},null,null,{"$f":"$H$71","v":{"v":0,"d":"$0"}},{"$f":"$I$71","v":{"v":0,"d":"$0"}},{"$f":"$J$71","v":{"v":0,"d":"$0"}},{"$f":"$K$71","v":{"v":0,"d":"$0"}},{"$f":"$L$71","v":{"v":0,"d":"$0"}},{"$f":"$M$71","v":{"v":0,"d":"$0"}},{"$f":"IF($M$14<>0,$M$12/$M$14,\"----\")","v":"----"}]
[{"$nulls":3},{"$f":"$D$89","v":"Ctr"},{"$f":"$D$79","v":"Breakout brand: incremental conversions"},null,null,{"$f":"$H$89","v":{"v":0,"d":"$0"}},{"$f":"$I$89","v":{"v":0,"d":"$0"}},{"$f":"$J$89","v":{"v":0,"d":"$0"}},{"$f":"$K$89","v":{"v":0,"d":"$0"}},{"$f":"$L$89","v":{"v":0,"d":"$0"}},{"$f":"$M$89","v":{"v":0,"d":"$0"}},{"$f":"IF($M$14<>0,$M$13/$M$14,\"----\")","v":"----"}]
[{"$nulls":4},{"$f":"tTotalbenefitsriskadjusted_t","v":"Total benefits (risk-adjusted)"},null,null,{"$f":"SUM($H$11:$H$13)","v":{"v":0,"d":"$0"}},{"$f":"SUM($I$11:$I$13)","v":{"v":0,"d":"$0"}},{"$f":"SUM($J$11:$J$13)","v":{"v":0,"d":"$0"}},{"$f":"SUM($K$11:$K$13)","v":{"v":0,"d":"$0"}},{"$f":"SUM($L$11:$L$13)","v":{"v":0,"d":"$0"}},{"$f":"SUM($M$11:$M$13)","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},{"$f":"tTotalBenefits1_t","v":"Total Benefits"},{"$f":"D15","v":"Total Benefits"},{"$f":"_xlfn.CONCAT(tXPeriodLower_t,\" \",LOWER(tBenefit),\" PV\")","v":"three-year benefit PV"},{"$f":"_xlfn.CONCAT(tXPeriod1_t,\" \",tRiskAdjusted_t,\" \",tBenefits)","v":"Three-year Risk-Adjusted Benefits"},{"$nulls":5},{"$f":"M14","v":0}]
[{"$nulls":3},{"$f":"D15","v":"Total Benefits"},null,{"$f":"_xlfn.CONCAT(tXPeriodLower_t,\" \",tTotalbenefitsPV1_t)","v":"three-year total benefits PV"}]
{"$rows_empty":18}
[{"$nulls":3},{"$f":"E51","v":"First party data: incremental operating profit in D2C channel"}]
[{"$nulls":3},"AOV went from $400 to $1000; ",null,null,"number of orders increased 10%-15%",null,null,"net new  Customers 5%"]
[{"$nulls":3},{"$f":"tShowHideCalculationDetails","v":"Click to show/hide calculation details"}]
[{"$nulls":3},{"$f":"varRef","v":"Ref."},{"$f":"varMetric","v":"Metric"},null,{"$f":"varCalculation","v":"Calculation"},{"$f":"varp0","v":"Initial"},{"$f":"varp1","v":"Year 1"},{"$f":"varp2","v":"Year 2"},{"$f":"varp3","v":"Year 3"},{"$f":"varTotal","v":"Total"},{"$f":"varPresentValue","v":"Present Value"}]
[{"$nulls":3},"A1","Monthly site visitors",null,"Input",null,{"$f":"SiteVisitors","v":0},{"$f":"I39","v":0},{"$f":"I39","v":0}]
[{"$nulls":3},"A2","Average order value",null,"Input",null,{"$f":"AOV","v":{"v":0,"d":"$0"}},{"$f":"I40","v":{"v":0,"d":"$0"}},{"$f":"I40","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"A3","Prior conversion rate",null,"Input",null,{"$f":"D2CConv","v":{"v":0,"d":"0%"}},{"$f":"I41","v":{"v":0,"d":"0%"}},{"$f":"I41","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"A4","Increase in conversion rate",null,"Input",null,{"$f":"ConvRateInc","v":{"v":0,"d":"0%"}},{"$f":"I42","v":{"v":0,"d":"0%"}},{"$f":"I42","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"A5","Subtotal: Incremental revenue from increased conversion",null,"A1*A2*A4*12",null,{"$f":"I39*I40*I42*12","v":{"v":0,"d":"$0"}},{"$f":"J39*J40*J42*12","v":{"v":0,"d":"$0"}},{"$f":"K39*K40*K42*12","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"A6","Increase in average order value from improved cross-sell / upsell",null,"Input",null,{"$f":"AOVIncrease","v":{"v":0,"d":"0%"}},{"$f":"I44","v":{"v":0,"d":"0%"}},{"$f":"I44","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"A7","Percent of site visitors where cross-sell / upsell is possible",null,"Input",null,{"$f":"TargetVisitors","v":{"v":0,"d":"0%"}},{"$f":"I45","v":{"v":0,"d":"0%"}},{"$f":"I45","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"A8","Subtotal: Incremental revenue from increased cross-sell / upsell",null,"(A1*A7)*(A2*(1+A6))*(A3+A4)*12",null,{"$f":"(I39*I45)*(I40*(1+I44))*(I41+I42)*12","v":{"v":0,"d":"$0"}},{"$f":"(J39*J45)*(J40*(1+J44))*(J41+J42)*12","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":3},"A9","Ratio of returning visitors to all visitors",null,"Input",null,{"$f":"ReturnVisitors","v":{"v":0,"d":"0%"}},{"$f":"I47","v":{"v":0,"d":"0%"}},{"$f":"I47","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"A10","Increase in return visitor ratio",null,"Input",null,{"$f":"IncReturns","v":{"v":0,"d":"0%"}},{"$f":"I48","v":{"v":0,"d":"0%"}},{"$f":"I48","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"A11","Subtotal: Incremental revenue from increased retention",null,"A1*A10*A2*(A3+A4)*12",null,{"$f":"I39*I48*I40*(I41+I42)*12","v":{"v":0,"d":"$0"}},{"$f":"J39*J48*J40*(J41+J42)*12","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":3},"A12","D2C operating profit margin ",null,"Input",null,{"$f":"OperatingMargin","v":{"v":0,"d":"0%"}},{"$f":"I50","v":{"v":0,"d":"0%"}},{"$f":"I50","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"At","First party data: incremental operating profit in D2C channel",null,{"$f":"_xlfn.CONCAT(\"(\",D43,\"+\",D46,\"+\",D49,\")\",\"*\",D50)","v":"(A5+A8+A11)*A12"},{"v":0,"d":"$0"},{"$f":"(I43+I46+I49)*I50","v":{"v":0,"d":"$0"}},{"$f":"(J43+J46+J49)*J50","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"SUM(H51:K51)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H51+NPV(varDiscountRate,I51:K51),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tRiskadjustment","v":"Risk adjustment"},null,{"v":0.1,"d":"↓10%"}]
[{"$nulls":3},"Atr",{"$f":"CONCATENATE(E51,\" \",triskadjustedParens)","v":"First party data: incremental operating profit in D2C channel (risk-adjusted)"},null,null,{"$f":"H51*(1-$G52)","v":{"v":0,"d":"$0"}},{"$f":"IF(varNumberPeriods>=(COLUMN()-8),I51*(1-$G52),0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(H53:K53)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H53+NPV(varDiscountRate,I53:K53),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Atr",{"$f":"tXPeriodtotal_t","v":"Three-year total"},null,{"$f":"$L$53","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Atr",{"$f":"tXPeriodpresentvalue_t","v":"Three-year present value"},null,{"$f":"$M$53","v":{"v":0,"d":"$0"}}]
[{"$nulls":12},{"$f":"$M$53","v":0}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"E69","v":"First party data: incremental operating profit in B2B channel"}]
[]
[{"$nulls":3},{"$f":"tShowHideCalculationDetails","v":"Click to show/hide calculation details"}]
[{"$nulls":3},{"$f":"varRef","v":"Ref."},{"$f":"varMetric","v":"Metric"},null,{"$f":"varCalculation","v":"Calculation"},{"$f":"varp0","v":"Initial"},{"$f":"varp1","v":"Year 1"},{"$f":"varp2","v":"Year 2"},{"$f":"varp3","v":"Year 3"},{"$f":"varTotal","v":"Total"},{"$f":"varPresentValue","v":"Present Value"}]
[{"$nulls":3},"B1","Total number of B2B buyers",null,"Input",null,{"$f":"B2BBuyers","v":0},{"$f":"I65","v":0},{"$f":"I65","v":0}]
[{"$nulls":3},"B2","Average revenue per buyer",null,"Input",null,{"$f":"B2BRev","v":{"v":0,"d":"$0"}},{"$f":"I66","v":{"v":0,"d":"$0"}},{"$f":"I66","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"B3","Estimated increase in revenue from first party data",null,"Input",null,{"$f":"B2BIncrease","v":{"v":0,"d":"0%"}},{"$f":"I67","v":{"v":0,"d":"0%"}},{"$f":"I67","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"B4","B2B operating profit margin",null,"Input",null,{"$f":"B2BMargin","v":{"v":0,"d":"$0"}},{"$f":"I68","v":{"v":0,"d":"$0"}},{"$f":"I68","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Bt","First party data: incremental operating profit in B2B channel",null,{"$f":"CONCATENATE(D65,\"* \",D66,\"*\",D67,\"*\",D68)","v":"B1* B2*B3*B4"},{"v":0,"d":"$0"},{"$f":"I65*I66*I67*I68","v":{"v":0,"d":"$0"}},{"$f":"J65*J66*J67*J68","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"SUM(H69:K69)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H69+NPV(varDiscountRate,I69:K69),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tRiskadjustment","v":"Risk adjustment"},null,{"v":0.1,"d":"↓10%"}]
[{"$nulls":3},"Btr",{"$f":"CONCATENATE(E69,\" \",triskadjustedParens)","v":"First party data: incremental operating profit in B2B channel (risk-adjusted)"},null,null,{"$f":"H69*(1-$G70)","v":{"v":0,"d":"$0"}},{"$f":"IF(varNumberPeriods>=(COLUMN()-8),I69*(1-$G70),0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(H71:K71)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H71+NPV(varDiscountRate,I71:K71),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Btr",{"$f":"tXPeriodtotal_t","v":"Three-year total"},null,{"$f":"$L$71","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Btr",{"$f":"tXPeriodpresentvalue_t","v":"Three-year present value"},null,{"$f":"$M$71","v":{"v":0,"d":"$0"}},{"$nulls":7},{"$f":"1527006-G73","v":{"v":1527006,"d":"$1,527,006"}}]
[{"$nulls":12},{"$f":"$M$71","v":0}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"E87","v":"Breakout brand: incremental conversions"}]
[{"$nulls":3},{"$f":"tShowHideCalculationDetails","v":"Click to show/hide calculation details"}]
[{"$nulls":3},{"$f":"varRef","v":"Ref."},{"$f":"varMetric","v":"Metric"},null,{"$f":"varCalculation","v":"Calculation"},{"$f":"varp0","v":"Initial"},{"$f":"varp1","v":"Year 1"},{"$f":"varp2","v":"Year 2"},{"$f":"varp3","v":"Year 3"},{"$f":"varTotal","v":"Total"},{"$f":"varPresentValue","v":"Present Value"}]
[{"$nulls":3},"C1","Target monthly leads",null,"Input",null,{"$f":"Leads","v":0},{"$f":"I82","v":0},0]
[{"$nulls":3},"C2","Average conversion rate for breakout brands, prior to Salesforce",null,"Input",null,{"$f":"BreakoutConv","v":{"v":0,"d":"0%"}},{"$f":"I83","v":{"v":0,"d":"0%"}},{"$f":"I83","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"C3","Increase in conversion rate with Salesforce",null,"Input",null,{"$f":"BreakoutInc","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[{"$nulls":3},"C4","Average order value",null,"Input",null,{"$f":"BBAOV","v":{"v":0,"d":"$0"}},{"$f":"I85","v":{"v":0,"d":"$0"}},{"$f":"I85","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"C5","Operating profit margin for breakout brands (cross-channel)",null,"Input",null,{"$f":"BBMargin","v":{"v":0,"d":"0%"}},{"$f":"I86","v":{"v":0,"d":"0%"}},{"$f":"I86","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Ct","Breakout brand: incremental conversions",null,{"$f":"CONCATENATE(D82,\"*\",12,\"*\",D84,\"*\",D85,\"*\",D86)","v":"C1*12*C3*C4*C5"},{"v":0,"d":"$0"},{"$f":"I82*12*I84*I85*I86","v":{"v":0,"d":"$0"}},{"$f":"J82*12*J84*J85*J86","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"SUM(H87:K87)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H87+NPV(varDiscountRate,I87:K87),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tRiskadjustment","v":"Risk adjustment"},null,{"v":0.15,"d":"↓15%"}]
[{"$nulls":3},"Ctr",{"$f":"CONCATENATE(E87,\" \",triskadjustedParens)","v":"Breakout brand: incremental conversions (risk-adjusted)"},null,null,{"$f":"H87*(1-$G88)","v":{"v":0,"d":"$0"}},{"$f":"IF(varNumberPeriods>=(COLUMN()-8),I87*(1-$G88),0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(H89:K89)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H89+NPV(varDiscountRate,I89:K89),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Ctr",{"$f":"tXPeriodtotal_t","v":"Three-year total"},null,{"$f":"$L$89","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Ctr",{"$f":"tXPeriodpresentvalue_t","v":"Three-year present value"},null,{"$f":"$M$89","v":{"v":0,"d":"$0"}}]
[{"$nulls":12},{"$f":"$M$89","v":0}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"varCookieSettingsFooter","v":"Cookie settings"}]
[{"$nulls":3},{"$f":"varCopyrightFooter","v":"© 2021, Forrester Research, Inc. All rights reserved. This work is commissioned by Salesforce and delivered by Forrester Consulting."}]

{"sheet":"CostDetails","index":2,"n_rows":72,"n_cols":14,"rows_kept":72,"merged":[[8,3,8,12],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[32,3,32,12],[33,3,33,12],[34,3,34,12],[35,3,35,8],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[51,3,51,12],[52,3,52,12],[53,3,53,12],[54,3,54,8],[55,4,55,5],[56,4,56,5],[57,4,57,5],[58,4,58,5],[59,4,59,5],[60,4,60,5],[60,15,61,18],[61,4,61,5],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[70,3,70,4],[71,3,71,12]]}
{"$rows_empty":8}
[{"$nulls":3},{"$f":"tTotalCost_t","v":"Total Cost"}]
[{"$nulls":3},{"$f":"varRef","v":"Ref."},{"$f":"IF(\"Cost\"=\"Cost\",tCost,\"Cost\")","v":"Cost"},null,null,{"$f":"varp0","v":"Initial"},{"$f":"varp1","v":"Year 1"},{"$f":"varp2","v":"Year 2"},{"$f":"varp3","v":"Year 3"},{"$f":"varTotal","v":"Total"},{"$f":"varPresentValue","v":"Present Value"}]
[{"$nulls":3},{"$f":"$D$45","v":"Dtr"},{"$f":"$D$34","v":"First party data: analysis cost"},null,null,{"$f":"$H$45","v":{"v":0,"d":"$0"}},{"$f":"$I$45","v":{"v":0,"d":"$0"}},{"$f":"$J$45","v":{"v":0,"d":"$0"}},{"$f":"$K$45","v":{"v":0,"d":"$0"}},{"$f":"$L$45","v":{"v":0,"d":"$0"}},{"$f":"$M$45","v":{"v":0,"d":"$0"}},{"$f":"IF($M$13<>0,$M$11/$M$13,\"----\")","v":"----"}]
[{"$nulls":3},{"$f":"$D$63","v":"Etr"},{"$f":"$D$53","v":"Breakout brand: test cost"},null,null,{"$f":"$H$63","v":{"v":0,"d":"$0"}},{"$f":"$I$63","v":{"v":0,"d":"$0"}},{"$f":"$J$63","v":{"v":0,"d":"$0"}},{"$f":"$K$63","v":{"v":0,"d":"$0"}},{"$f":"$L$63","v":{"v":0,"d":"$0"}},{"$f":"$M$63","v":{"v":0,"d":"$0"}},{"$f":"IF($M$13<>0,$M$12/$M$13,\"----\")","v":"----"}]
[{"$nulls":4},{"$f":"tTotalcostsriskadjusted_t","v":"Total costs (risk-adjusted)"},null,null,{"$f":"SUM($H$11:$H$12)","v":{"v":0,"d":"$0"}},{"$f":"SUM($I$11:$I$12)","v":{"v":0,"d":"$0"}},{"$f":"SUM($J$11:$J$12)","v":{"v":0,"d":"$0"}},{"$f":"SUM($K$11:$K$12)","v":{"v":0,"d":"$0"}},{"$f":"SUM($L$11:$L$12)","v":{"v":0,"d":"$0"}},{"$f":"SUM($M$11:$M$12)","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},{"$f":"tTotalCosts1_t","v":"Total Costs"},{"$f":"D14","v":"Total Costs"},{"$f":"_xlfn.CONCAT(tXPeriodLower_t,\" \",LOWER(tCost),\" PV\")","v":"three-year cost PV"},{"$f":"_xlfn.CONCAT(tXPeriod1_t,\" \",tRiskAdjusted_t,\" \",tCosts)","v":"Three-year Risk-Adjusted Costs"},{"$nulls":5},{"$f":"M13","v":0}]
[{"$nulls":3},{"$f":"D14","v":"Total Costs"},null,{"$f":"_xlfn.CONCAT(tXPeriodLower_t,\" \",tTotalcostsPV1_t)","v":"three-year total costs PV"}]
{"$rows_empty":18}
[{"$nulls":3},{"$f":"E43","v":"First party data: analysis cost"}]
[]
[{"$nulls":3},{"$f":"tShowHideCalculationDetails","v":"Click to show/hide calculation details"}]
[{"$nulls":3},{"$f":"varRef","v":"Ref."},{"$f":"varMetric","v":"Metric"},null,{"$f":"varCalculation","v":"Calculation"},{"$f":"varp0","v":"Initial"},{"$f":"varp1","v":"Year 1"},{"$f":"varp2","v":"Year 2"},{"$f":"varp3","v":"Year 3"},{"$f":"varTotal","v":"Total"},{"$f":"varPresentValue","v":"Present Value"}]
[{"$nulls":3},"D1","Number of FTEs to collect and analyze first party data",null,"Input",{"$f":"FTEAnalysis","v":0}]
[{"$nulls":3},"D2","Months spent on data analysis",null,"Input",{"$f":"AnalysisMonths","v":0}]
[{"$nulls":3},"D3","Hours to communicate / implement recommendations in D2C channel",null,"Input",{"$f":"D2CHours","v":0}]
[{"$nulls":3},"D4","Hours to communicate / implement recommendations in B2B channel",null,"Input",{"$f":"B2BHours","v":0}]
[{"$nulls":3},"D5","Average fully-burdened compensation",null,"Input",{"$f":"FPDComp","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Dt","First party data: analysis cost",null,"(D1*D2*(D5/12))+((D3+D4)*(D5/2080))",{"$f":"(H38*H39*(H42/12))+((H40+H41)*(H42/2080))","v":{"v":0,"d":"$0"}},{"$f":"I41*I42","v":{"v":0,"d":"$0"}},{"$f":"J41*J42","v":{"v":0,"d":"$0"}},{"$f":"K41*K42","v":{"v":0,"d":"$0"}},{"$f":"SUM(H43:K43)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H43+NPV(varDiscountRate,I43:K43),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tRiskadjustment","v":"Risk adjustment"},null,{"v":0.05,"d":"↑5%"}]
[{"$nulls":3},"Dtr",{"$f":"CONCATENATE(E43,\" \",triskadjustedParens)","v":"First party data: analysis cost (risk-adjusted)"},null,null,{"$f":"H43*(1+$G44)","v":{"v":0,"d":"$0"}},{"$f":"IF(varNumberPeriods>=(COLUMN()-8),I43*(1+$G44),0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(H45:K45)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H45+NPV(varDiscountRate,I45:K45),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Dtr",{"$f":"tXPeriodtotal_t","v":"Three-year total"},null,{"$f":"$L$45","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Dtr",{"$f":"tXPeriodpresentvalue_t","v":"Three-year present value"},null,{"$f":"$M$45","v":{"v":0,"d":"$0"}}]
[{"$nulls":12},{"$f":"$M$45","v":0}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"E61","v":"Breakout brand: test cost"}]
[]
[{"$nulls":3},{"$f":"tShowHideCalculationDetails","v":"Click to show/hide calculation details"}]
[{"$nulls":3},{"$f":"varRef","v":"Ref."},{"$f":"varMetric","v":"Metric"},null,{"$f":"varCalculation","v":"Calculation"},{"$f":"varp0","v":"Initial"},{"$f":"varp1","v":"Year 1"},{"$f":"varp2","v":"Year 2"},{"$f":"varp3","v":"Year 3"},{"$f":"varTotal","v":"Total"},{"$f":"varPresentValue","v":"Present Value"}]
[{"$nulls":3},"E1","Number of months to test breakout brand",null,"Input",{"$f":"TestMonths","v":0}]
[{"$nulls":3},"E2","Average cost per month to test",null,"Input",{"$f":"TestCost","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"E3","Number of hours spent on data analysis and profile development",null,"Input",{"$f":"HoursDev","v":0}]
[{"$nulls":3},"E4","Hourly fully-burdened compensation of breakout brand team",null,"Input",{"$f":"AnalysisComp","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Et","Breakout brand: test cost",null,{"$f":"CONCATENATE(\"(\",D57,\"*\",D58,\")\",\"+\",\"(\",D59,\"*\",D60,\")\")","v":"(E1*E2)+(E3*E4)"},{"$f":"(H57*H58)+(H59*H60)","v":{"v":0,"d":"$0"}},{"$f":"(I57*I58)+(I59*I60)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(H61:K61)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H61+NPV(varDiscountRate,I61:K61),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tRiskadjustment","v":"Risk adjustment"},null,{"v":0.05,"d":"↑5%"}]
[{"$nulls":3},"Etr",{"$f":"CONCATENATE(E61,\" \",triskadjustedParens)","v":"Breakout brand: test cost (risk-adjusted)"},null,null,{"$f":"H61*(1+$G62)","v":{"v":0,"d":"$0"}},{"$f":"IF(varNumberPeriods>=(COLUMN()-8),I61*(1+$G62),0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(H63:K63)","v":{"v":0,"d":"$0"}},{"$f":"ROUND(H63+NPV(varDiscountRate,I63:K63),0)","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Etr",{"$f":"tXPeriodtotal_t","v":"Three-year total"},null,{"$f":"$L$63","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Etr",{"$f":"tXPeriodpresentvalue_t","v":"Three-year present value"},null,{"$f":"$M$63","v":{"v":0,"d":"$0"}}]
[{"$nulls":12},{"$f":"$M$63","v":0}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"varCookieSettingsFooter","v":"Cookie settings"}]
[{"$nulls":3},{"$f":"varCopyrightFooter","v":"© 2021, Forrester Research, Inc. All rights reserved. This work is commissioned by Salesforce and delivered by Forrester Consulting."}]

{"sheet":"Results","index":3,"n_rows":69,"n_cols":14,"rows_kept":69,"merged":[[12,4,12,8],[45,4,45,12],[67,3,67,4],[68,3,68,12]]}
[]
[]
[null," "]
[]
[{"$nulls":4},"Registration required"]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(\"To contact or learn more about \",varProductName,\", visit \",HYPERLINK(\"https://www.salesforce.com/resources/articles/direct-to-consumer/\",\"abc.com\"))","v":"To contact or learn more about Commerce Cloud Direct To Consumer, visit abc.com"}]
[]
[]
[]
[{"$nulls":4},"Financial Summary (risk-adjusted estimates)"]
[{"$nulls":4},{"$f":"varROI","v":"ROI"},{"$f":"CONCATENATE(varPaybackperiod,\" (\",varPaybackPeriodDisplay,\")\")","v":"Payback period (months)"},{"$f":"tTotalbenefits_PV_t","v":"Total benefits (PV)"},{"$f":"tTotalcosts_PV_t","v":"Total costs (PV)"},{"$f":"tNetpresentvalue_t","v":"Net present value"}]
[{"$nulls":4},{"$f":"$M$51","v":"----"},{"$f":"$M$52","v":"0"},{"$f":"$M$49","v":{"v":0,"d":"$0"}},{"$f":"$M$48","v":{"v":0,"d":"$0"}},{"$f":"$M$50","v":{"v":0,"d":"$0"}}]
{"$rows_empty":30}
[{"$nulls":4},{"$f":"tCashFlowAnalysisriskadjusted_t","v":"Cash flow analysis (risk-adjusted estimates)"}]
[{"$nulls":7},{"$f":"varp0","v":"Initial"},{"$f":"varp1","v":"Year 1"},{"$f":"varp2","v":"Year 2"},{"$f":"varp3","v":"Year 3"},{"$f":"varTotal","v":"Total"},{"$f":"varPresentValue","v":"Present Value"}]
[{"$nulls":4},{"$f":"tTotalcosts_t","v":"Total costs"},null,null,{"$f":"CostDetails!$H$13*-1","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$I$13*-1","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$J$13*-1","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$K$13*-1","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$L$13*-1","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$M$13*-1","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tTotalbenefits_t","v":"Total benefits"},null,null,{"$f":"BenefitDetails!$H$14","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$I$14","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$J$14","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$K$14","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$L$14","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$14","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tNetbenefits_t","v":"Net benefits"},null,null,{"$f":"H48+H49","v":{"v":0,"d":"$0"}},{"$f":"I48+I49","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"M48+M49","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"varROI","v":"ROI"},{"$nulls":7},{"$f":"IF(M48=0,\"----\",M50/ABS(M48))","v":"----"}]
[{"$nulls":4},{"$f":"CONCATENATE(varPaybackperiod,\" (\", varPaybackPeriodDisplay,\")\")","v":"Payback period (months)"},{"$nulls":7},{"$f":"M61","v":"0"}]
[{"$nulls":4},{"$f":"E52","v":"Payback period (months)"},{"$nulls":7},{"$f":"CONCATENATE(varPaybackperiod,\":\",CHAR(10),IF(AND(LEFT(M52,1)<>\">\",LEFT(M52,1)<>\"<\"),ROUND(M52,0),M52),\" \",varPaybackPeriodDisplay)","v":"Payback period:\n0 months"}]
[{"$nulls":6},{"$f":"tBenefits","v":"Benefits"},{"$f":"H49","v":0},{"$f":"I49","v":0},0,0]
[{"$nulls":6},{"$f":"tCosts","v":"Costs"},{"$f":"H48*-1","v":0},{"$f":"I48*-1","v":0},0,0]
[{"$nulls":4},{"$f":"tCumulativetotalcosts_t","v":"Cumulative total costs"},null,{"$f":"E48","v":"Total costs"},{"$f":"SUM($H48:H48)*-1","v":{"v":0,"d":"$0"}},{"$f":"SUM($H48:I48)*-1","v":{"v":0,"d":"$0"}},{"$f":"SUM($H48:J48)*-1","v":{"v":0,"d":"$0"}},{"$f":"SUM($H48:K48)*-1","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tCumulativetotalbenefits_t","v":"Cumulative total benefits"},null,{"$f":"E49","v":"Total benefits"},{"$f":"SUM($H49:H49)","v":{"v":0,"d":"$0"}},{"$f":"SUM($H49:I49)","v":{"v":0,"d":"$0"}},{"$f":"SUM($H49:J49)","v":{"v":0,"d":"$0"}},{"$f":"SUM($H49:K49)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tCumulativenetbenefits_t","v":"Cumulative net benefits"},null,null,{"$f":"SUM($H50:H50)","v":{"v":0,"d":"$0"}},{"$f":"SUM($H50:I50)","v":{"v":0,"d":"$0"}},{"$f":"SUM($H50:J50)","v":{"v":0,"d":"$0"}},{"$f":"SUM($H50:K50)","v":{"v":0,"d":"$0"}},null,{"$f":"MIN(H58:K58)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"tCumulativetotalbenefitsPV_t","v":"Cumulative total benefits PV"},null,{"$f":"tTotalbenefitsPV_t","v":"Total benefits PV"},{"$f":"$H49","v":0},{"$f":"$H49+NPV(varDiscountRate,$I49:I49)","v":0},{"$f":"$H49+NPV(varDiscountRate,$I49:J49)","v":0},{"$f":"$H49+NPV(varDiscountRate,$I49:K49)","v":0}]
[{"$nulls":4},{"$f":"tCumulativetotalcostsPV_t","v":"Cumulative total costs PV"},null,{"$f":"tTotalcostsPV_t","v":"Total costs PV"},{"$f":"$H48*-1","v":0},{"$f":"($H48+NPV(varDiscountRate,$I48:I48))*-1","v":0},{"$f":"($H48+NPV(varDiscountRate,$I48:J48))*-1","v":0},{"$f":"($H48+NPV(varDiscountRate,$I48:K48))*-1","v":0}]
[{"$nulls":4},{"$f":"tPaybackperiodinterimcalculations_t","v":"Payback period (interim calculations)"},{"$nulls":3},{"$f":"IF(AND(I58>=0,H58<0,MIN(J58:$L58)>=0),((COLUMN()-COLUMN($I61))+ABS(H58)/I50)*varPaybackPeriodMultiplier,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AND(J58>=0,I58<0,MIN(K58:$L58)>=0),((COLUMN()-COLUMN($I61))+ABS(I58)/J50)*varPaybackPeriodMultiplier,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AND(K58>=0,J58<0,MIN(L58:$L58)>=0),((COLUMN()-COLUMN($I61))+ABS(J58)/K50)*varPaybackPeriodMultiplier,0)","v":{"v":0,"d":"0.0"}},{"$f":"MAX(I61:K61)","v":{"v":0,"d":"0.0"}},{"$f":"IF(M58>=0,\"0\",IF(L61>0,IF(L61<3,\"<3\",IF(L61<6,\"<6\",ROUNDUP(L61,0))),\">\"&(varNumberPeriods*varPaybackPeriodMultiplier)))","v":"0"},{"$f":"\"filler\"","v":"filler"}]
[{"$nulls":4},{"$f":"CONCATENATE(tXPeriod1_t,\" \",H62)","v":"Three-year Risk-Adjusted Financial Summary"},null,null,{"$f":"tRiskadjustedFinancialSummary_t","v":"Risk-Adjusted Financial Summary"}]
[]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"varCookieSettingsFooter","v":"Cookie settings"}]
[{"$nulls":3},{"$f":"varCopyrightFooter","v":"© 2021, Forrester Research, Inc. All rights reserved. This work is commissioned by Salesforce and delivered by Forrester Consulting."}]

{"sheet":"Settings","index":4,"n_rows":55,"n_cols":13,"rows_kept":55,"hidden":true,"merged":[[5,2,5,10],[8,3,8,6],[8,7,8,8],[8,9,8,11],[10,3,10,4],[46,2,46,10],[48,3,48,9],[53,3,53,4],[54,3,54,12]]}
[]
[]
[]
[]
[]
[null,null,"Currency"]
[]
[]
[{"$nulls":3},{"$f":"_xlfn.CONCAT(Inputs!J25,\" \",Inputs!H24)","v":" US Dollar"},{"$nulls":3},{"$f":"LOOKUP(varCurrency,varCurrencies,varExchangeRates)","v":{"v":1,"d":"1.0000"}}]
[]
[{"$nulls":3},"Currencies",null,null,{"$f":"\"Currency Symbol\"","v":"Currency Symbol"},{"$f":"\"Example\"","v":"Example"},"Exchange Rate",{"$f":"\"Currency Codes\"","v":"Currency Codes"},"Currencies Values\n(must match Mainstay 'CurrencyOptions')","Example M/K"]
[{"$nulls":3},"Australian Dollar",null,null,"$",{"v":1,"d":"$1"},1.3784,"AUD","Australia Dollar",null,true]
[{"$nulls":3},"Brazil Real",null,null,"R$",{"v":1,"d":"R$ 1"},5.3359,"BRL","Brazil Real",null,true]
[{"$nulls":3},"British Pound",null,null,"£",{"v":1,"d":"£1"},0.7262,"GBP","UK Pound",null,true]
[{"$nulls":3},"Brunei Dollar",null,null,"B$",{"v":1,"d":"$1"},1.3509,"BND","Brunei Darussalam Dollar",null,true]
[{"$nulls":3},"Canadian Dollar",null,null,"$",{"v":1,"d":"$1"},1.2625,"CAD","Canada Dollar",null,true]
[{"$nulls":3},"Chinese Yuan Renminbi",null,null,"¥",{"v":1,"d":"¥1"},6.4851,"CNY","China Yuan Renminbi",null,true]
[{"$nulls":3},"Czech Koruna",null,null,"Kč",{"v":1,"d":"1 Kč"},21.7097,"CZK","Czech Republic Koruna",null,false]
[{"$nulls":3},"Danish Krone",null,null,"Kr.",{"v":1,"d":"kr. 1"},6.3732,"DKK","Denmark Krone",null,true]
[{"$nulls":3},"Euro",null,null,"€",{"v":1,"d":"€1"},0.8552,"EUR","Euro",null,true]
[{"$nulls":3},"Hong Kong Dollar",null,null,"HK$",{"v":1,"d":"HK$1"},{"v":7.847,"d":"7.8470"},"HKD","Hong Kong Dollar",null,true]
[{"$nulls":3},"Icelandic Krona",null,null,"kr.",{"v":1,"d":"1 kr."},{"v":106.85,"d":"106.8500"},"ISK","Iceland Krona",null,false]
[{"$nulls":3},"Indian Rupee",null,null,"₹",{"v":1,"d":"₹ 1"},74.2796,"INR","India Rupee",null,true]
[{"$nulls":3},"Japanese Yen",null,null,"¥",{"v":1,"d":"¥1"},109.8521,"JPY","Japan Yen",null,true]
[{"$nulls":3},"Korean Won",null,null,"₩",{"v":1,"d":"₩1"},1169.5662,"KRW","Korea (South) Won",null,true]
[{"$nulls":3},"Malaysian Ringgit",null,null,"RM",{"v":1,"d":"RM1"},4.0489,"MYR","Malaysia Ringgit",null,true]
[{"$nulls":3},"Mexican Peso",null,null,"$",{"v":1,"d":"$1"},19.2068,"MXN","Mexico Peso",null,true]
[{"$nulls":3},"New Zealand Dollar",null,null,"$",{"v":1,"d":"$1"},1.4724,"NZD","New Zealand Dollar",null,true]
[{"$nulls":3},"Norwegian Krone",null,null,"kr",{"v":1,"d":"kr 1"},8.0575,"NOK","Norway Krone",null,true]
[{"$nulls":3},"Qatari Rial",null,null,"QAR",{"v":1,"d":"QAR 1"},3.6411,"QAR","Qatar Rial",null,true]
[{"$nulls":3},"Russian Ruble",null,null,"₽",{"v":1,"d":"1 ₽"},73.6797,"RUB","Russia Ruble",null,false]
[{"$nulls":3},"Saudi Arabian Riyal",null,null,"SAR",{"v":1,"d":"SAR 1"},3.7503,"SAR","Saudi Arabia Riyal",null,true]
[{"$nulls":3},"Singapore Dollar",null,null,"$",{"v":1,"d":"$1"},{"v":1.365,"d":"1.3650"},"SGD","Singapore Dollar",null,true]
[{"$nulls":3},"South African Rand",null,null,"R",{"v":1,"d":"R 1"},13.5357,"ZAR","South Africa Rand",null,true]
[{"$nulls":3},"Swedish Krona",null,null,"kr",{"v":1,"d":"1 kr"},8.7702,"SEK","Sweden Kronor",null,false]
[{"$nulls":3},"Swiss Franc",null,null,"fr.",{"v":1,"d":"fr. 1"},0.9934,"CHF","Switzerland Franc",null,true]
[{"$nulls":3},"Taiwan New Dollar",null,null,"$",{"v":1,"d":"$1"},{"v":30.525,"d":"30.5250"},"TWD","Taiwan New Dollar",null,true]
[{"$nulls":3},"Thai Baht",null,null,"฿",{"v":1,"d":"฿1"},{"v":33.18,"d":"33.1800"},"THB","Thailand Baht",null,true]
[{"$nulls":3},"Turkish Lira",null,null,"₺",{"v":1,"d":"1 ₺"},4.5922,"TRY","Turkey Lira",null,false]
[{"$nulls":3},"Ukrainian Hryvnia",null,null,"₴",{"v":1,"d":"1₴"},{"v":26.342,"d":"26.3420"},"UAH","Ukraine Hryvnia",null,false]
[{"$nulls":3},"US Dollar",null,null,"$",{"v":1,"d":"$1"},{"v":1,"d":"1.0000"},"USD","US Dollar",100,true]
[{"$nulls":6},{"$f":"LOOKUP(varCurrency,varCurrencies,varCurrencySymbols)","v":"$"},{"$nulls":5},{"$f":"LOOKUP(varCurrency,varCurrencies,M12:M41)","v":true}]
[]
[]
[]
[]
[null,null,"Discount Rate"]
[]
[{"$nulls":3},"Financial discount rate.",{"$nulls":6},{"$f":"L49","v":{"v":0.1,"d":"10%"}},{"v":0.1,"d":"10%"}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"varCookieSettingsFooter","v":"Cookie settings"}]
[{"$nulls":3},{"$f":"varCopyrightFooter","v":"© 2021, Forrester Research, Inc. All rights reserved. This work is commissioned by Salesforce and delivered by Forrester Consulting."}]

{"sheet":"$Vars","index":5,"n_rows":193,"n_cols":13,"rows_kept":193,"hidden":true,"merged":[[23,2,23,3],[31,2,31,3],[59,2,59,7],[60,2,60,7],[101,3,101,5]]}
["<data><sheetData sheetTitle=\"Variables\" usableSheet=\"False\" Model_Study=\"Hide\" Model_Tool=\"Show\" Finalize_Tool_Excel=\"Hide\" Finalize_Tool_Web=\"Hide\" navTabCreate=\"False\" navTitle=\"Variables\"/><tableData tag=\"Sdata\" tableName=\"Sheet data\" templateSheet=\"$Templates\"/><rowData tag=\"+\" displayLevel=\"-1\"><CA><ca name=\"sheetStart\" colBegin=\"B\"/><ca name=\"sectionFirst\" colBegin=\"B\"/><ca name=\"h2\" colBegin=\"C\" formula=\"{^navTitle^}\"/></CA></rowData></data>",null,"Variables"]
["<data><rowData tag=\"-\" displayLevel=\"-1\"><CA><ca name=\"sectionEnd\" colBegin=\"B\"/></CA></rowData></data>"]
[]
["<data><model/></data>",null,"Model parameters_","<data><model version=\"20201003\" markedFinal=\"True\" errorHandling=\"True\" fixes=\"|CFTableXtra||sheetIcons||sheetData||classesOmit||sectionFirst||sheetStartEnd||socialDisplaySelectors||TotalPeriod||CurrencyValues||chartsFile||templateDoc||colspan|\"/><tool enableMacros=\"True\" unprotect=\"False\" insertHeader=\"False\" createReset=\"False\" outputFormulas=\"False\"/><web enableMacros=\"False\" unprotect=\"False\"/><webApp layout=\"NAVTOP\" Mainstay=\"False\" minimize=\"False\" favicon=\"False\" faviconURL=\"http://www.[vendor].com/favicon.ico\" webProductDir=\"C:\\Users\\nforbush\\Documents\\TEI Web Product\\web\\\" bootstrap=\"4\" htmlfile=\"index.html\" dateTime=\"3/22/2020 9:07:27 AM\" projectDir=\"C:\\Users\\nforbush\\Documents\\TEI Practice\\Master Model\\web\\\" workbookName=\"TEI Master Sheet v20200320Web.xlsx\" header=\"Vendor2\" ForresterAnalytics=\"False\" version=\"20200322090727\" workbookNameShort=\"TEI Master Sheet v20200320Web\" includeSocial=\"False\" includeImgBanner=\"False\" NAVStyling=\"plain\" NAVHidden=\"False\" layoutWidth=\"default\" backgroundColor=\"default\" headerBackgroundColor=\"white\" NAVBackgroundColor=\"default\" scrollyWide=\"True\" saveOnUpdate=\"False\" includeNavSubmenus=\"False\" numberContentSheets=\"9\" slider=\"true\" chart=\"true\" hasRowTags=\"true\" translationsJS=\"False\" logoFile=\"img/logo.png\" initials=\"NF\" templateFile=\"index.html\" includeSocial2=\"False\"/></data>"]
[null,null,"Copyright_",{"$f":"tCopyright_t","v":"© 2021, Forrester Research, Inc. All rights reserved."}]
[null,null,"Copyright footer_",{"$f":"CONCATENATE(varCopyright,tCommissionedBy_t)","v":"© 2021, Forrester Research, Inc. All rights reserved. This work is commissioned by Salesforce and delivered by Forrester Consulting."}]
[null,null,"Max Periods_",3]
[null,null,"Periods_",{"$f":"varPeriodMonths_t","v":"months"},{"$f":"varPeriodQuarters_t","v":"quarters"},{"$f":"varPeriodYears_t","v":"years"},{"$f":"varPeriodMonth_t","v":"Month"},{"$f":"varPeriodQuarter_t","v":"Quarter"},{"$f":"varPeriodYear_t","v":"Year"}]
[{"$nulls":3},{"$f":"varRef_t","v":"Ref."},{"$f":"varMetric_t","v":"Metric"},{"$f":"varCalculation_t","v":"Calculation"},{"$f":"varTotal_t","v":"Total"},{"$f":"varPresentValue_t","v":"Present Value"},{"$f":"varPaybackperiod_t","v":"Payback period"},{"$f":"varCumulative_t","v":"Cumulative"}]
[{"$nulls":3},{"$f":"varROI_t","v":"ROI"},"PROI"]
[null,null,"Length of analysis_",3,"<-changing via Workbook->Years/Periods_",null,{"$f":"\"varVariableLow\"","v":"varVariableLow"},{"$f":"\"varVariableMid\"","v":"varVariableMid"},{"$f":"\"varVariableHi\"","v":"varVariableHi"}]
[null,null,"Period_",{"$f":"varPeriodYear","v":"Year"},"<-change via Workbook->Years/Periods_",null,"Low","Mid","High"]
[null,null,"Payback period display_",{"$f":"varPeriodMonths","v":"months"},"<-change via Workbook->Years/Periods_"]
[null,null,"Discount rate per period_",{"$f":"IF(varPeriod=E19,varDiscountRate,IF(varPeriod=K19,varDiscountRate/4,IF(varPeriod=J19,varDiscountRate/12,varDiscountRate)))","v":{"v":0.1,"d":"10%"}}]
[]
[null,null,{"$f":"varp0_t","v":"Initial"},{"$f":"varp1_t","v":"Year 1"},{"$f":"varp2_t","v":"Year 2"},{"$f":"varp3_t","v":"Year 3"},{"$f":"varp4_t","v":"Year 4"},{"$f":"varp5_t","v":"Year 5"},{"$f":"varp6_t","v":"Year 6"},{"$f":"varp7_t","v":"Year 7"},{"$f":"varp8_t","v":"Year 8"},{"$f":"varp9_t","v":"Year 9"},{"$f":"varp10_t","v":"Year 10"}]
[{"$nulls":3},{"$f":"varp11_t","v":"Year 11"},{"$f":"varp12_t","v":"Year 12"},{"$f":"varp13_t","v":"Year 13"},{"$f":"varp14_t","v":"Year 14"},{"$f":"varp15_t","v":"Year 15"},{"$f":"varp16_t","v":"Year 16"},{"$f":"varp17_t","v":"Year 17"},{"$f":"varp18_t","v":"Year 18"},{"$f":"varp19_t","v":"Year 19"},{"$f":"varp20_t","v":"Year 20"}]
[]
[null,null,"Payback Period Multiplier (Calculated Value)_",{"$f":"MAX(E22:M22)","v":{"v":12,"d":"12.000"}},{"$f":"varPeriodYear","v":"Year"},{"$f":"varPeriodYear","v":"Year"},{"$f":"varPeriodYear","v":"Year"},{"$f":"varPeriodMonth","v":"Month"},{"$f":"varPeriodMonth","v":"Month"},{"$f":"varPeriodMonth","v":"Month"},{"$f":"varPeriodQuarter","v":"Quarter"},{"$f":"varPeriodQuarter","v":"Quarter"},{"$f":"varPeriodQuarter","v":"Quarter"}]
[{"$nulls":4},{"$f":"varPeriodYears","v":"years"},{"$f":"varPeriodMonths","v":"months"},{"$f":"varPeriodQuarters","v":"quarters"},{"$f":"varPeriodYears","v":"years"},{"$f":"varPeriodMonths","v":"months"},{"$f":"varPeriodQuarters","v":"quarters"},{"$f":"varPeriodYears","v":"years"},{"$f":"varPeriodMonths","v":"months"},{"$f":"varPeriodQuarters","v":"quarters"}]
[{"$nulls":4},{"v":1,"d":"1.000"},{"v":12,"d":"12.000"},{"v":4,"d":"4.000"},{"$f":"1/12","v":{"v":0.08333333333333333,"d":"0.083"}},{"v":1,"d":"1.000"},{"v":0.25,"d":"0.250"},{"v":0.25,"d":"0.250"},{"$f":"1/3","v":{"v":0.3333333333333333,"d":"0.333"}},{"v":1,"d":"1.000"}]
[{"$nulls":4},{"$f":"IF(AND(varPeriod=E19,varPaybackPeriodDisplay=E20),E21,0)","v":{"v":0,"d":"0.000"}},{"v":12,"d":"12.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,null,"_Project Variables_"]
[null,null,"Company name_","Salesforce"]
[null,null,"Product name_","Commerce Cloud Direct To Consumer"]
[null,null,"Company and product name_","Salesforce Commerce Cloud Direct To Consumer"]
[null,null,"Tool title_",{"$f":"CONCATENATE(varVendorProductName,\" Estimator\")","v":"Salesforce Commerce Cloud Direct To Consumer Estimator"}]
[null,null,"Initial release date (Month Year)_","November 2020"]
[null,null,"Number of interviewed customers_","four"]
[null,null,"Commissioned by_",{"$f":"CONCATENATE(\"Commissioned by \",varVendorName)","v":"Commissioned by Salesforce"}]
[null,null,"_Web Data_"]
[null,null,"Tool title web_","Acme SolutionABC Estimator",null,"<- title in <header>_"]
[null,null,"Tool title web1_",{"$f":"varToolTitleWeb","v":"Acme SolutionABC Estimator"},null,"<- the <title>_"]
[null,null,"Header image href (web)_",{"$f":"CONCATENATE(\"https://www.\", LOWER(varVendorName),\".com\")","v":"https://www.salesforce.com"},null,"<- replace with '#' (no quotes) to disable logo hyperlink_"]
[null,null,"Header info (web)_",{"$f":"CONCATENATE(\"This tool is commissioned by \",varVendorName,\" and delivered by Forrester Consulting. See Methodology section for Disclaimers and Disclosures.\")","v":"This tool is commissioned by Salesforce and delivered by Forrester Consulting. See Methodology section for Disclaimers and Disclosures."},null,"<- the hover over in the header_"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\"div.header-banner h3:first\"/></CA></rowData></data>",null,null,{"$f":"CONCATENATE(\"A Forrester Total Economic Impact&trade; Tool Commissioned By \",varVendorName)","v":"A Forrester Total Economic Impact&trade; Tool Commissioned By Salesforce"},null,"<- title in <header> with image background_"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\"div.header-banner h1\"/></CA></rowData></data>",null,null,{"$f":"_xlfn.CONCAT(\"The Total Economic Impact&trade; of \",varVendorProductName)","v":"The Total Economic Impact&trade; of Salesforce Commerce Cloud Direct To Consumer"}]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\"div.header-banner-text h2\"/></CA></rowData></data>",null,null,{"$f":"_xlfn.CONCAT(\"An Interactive Tool to Estimate the Cost Savings and Business Benefits Enabled by \",varVendorProductName)","v":"An Interactive Tool to Estimate the Cost Savings and Business Benefits Enabled by Salesforce Commerce Cloud Direct To Consumer"}]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\"div.header-banner-text h3:last\"/></CA></rowData></data>",null,null,{"$f":"_xlfn.CONCAT(\"Based Upon A Forrester Consulting Study, <a href='\",varToolTitleHref,\"' target='_blank'>The Total Economic Impact&trade; of Acme SolutionABC</a>\")","v":"Based Upon A Forrester Consulting Study, <a href='https://www.salesforce.com' target='_blank'>The Total Economic Impact&trade; of Acme SolutionABC</a>"}]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\".microToolSocialMediaIcons{data-sharetitle}\"/></CA></rowData></data>",null,"social media data-sharetitle_",{"$f":"_xlfn.CONCAT(\"The Total Economic Impact of \",varVendorProductName)","v":"The Total Economic Impact of Salesforce Commerce Cloud Direct To Consumer"}]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\".microToolSocialMediaIcons{data-sharedesc}\"/></CA></rowData></data>",null,"social media data-sharedesc_",{"$f":"D39","v":"An Interactive Tool to Estimate the Cost Savings and Business Benefits Enabled by Salesforce Commerce Cloud Direct To Consumer"}]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\".microToolSocialMediaIcons{data-facebookimg}\"/><ca name=\"p\" colBegin=\"E\" displaySelectors=\".microToolSocialMediaIcons{data-twitterimg}\"/><ca name=\"p\" colBegin=\"F\" displaySelectors=\".microToolSocialMediaIcons{data-linkedinimg}\"/></CA></rowData></data>",null,"social media data-facebookimg, data-twitterimg, data-linkedinimg_","img/forrester-tei-hero.jpg",{"$f":"D43","v":"img/forrester-tei-hero.jpg"},{"$f":"E43","v":"img/forrester-tei-hero.jpg"}]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\".microToolSocialMediaIcons{data-emailsubject},a.mailtoIcon{data-emailsubject}\"/></CA></rowData></data>",null,"social media data-emailsubject_",{"$f":"D42","v":"An Interactive Tool to Estimate the Cost Savings and Business Benefits Enabled by Salesforce Commerce Cloud Direct To Consumer"}]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\".microToolSocialMediaIcons{data-emailbody},a.mailtoIcon{data-emailbody}\"/></CA></rowData></data>",null,"social media data-emailbody_",{"$f":"CONCATENATE(\"Check out: \",D41)","v":"Check out: The Total Economic Impact of Salesforce Commerce Cloud Direct To Consumer"}]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\".microToolSocialMediaIcons{data-sharehashtags}\"/><ca name=\"p\" colBegin=\"E\" displaySelectors=\".microToolSocialMediaIcons{data-author}\"/></CA></rowData></data>",null,"social media data-sharehashtags, data-author_","Forrester","Forrester"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" displaySelectors=\".microToolSocialMediaIcons{data-downloadfile}\"/></CA></rowData></data>",null,"social media data-downloadfile_","docs/download.pdf",null,"<-- not used_"]
[]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"input\" colBegin=\"D\" attributes=\"data-role='sheetsVisited'\"/></CA></rowData></data>",null,"sheetsVisited_"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"input\" colBegin=\"D\" attributes=\"data-role='inputsChanged'\"/></CA></rowData></data>",null,"inputsChanged_"]
[{"$nulls":3},"registrationReturnStandardEnabled_","registrationReturnStandardSheetRegister_","registrationReturnStandardSheetGoto_","registrationReturnStandardSheetUnhide_"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"D\" onEvent=\"function:registrationReturnStandard();\"/></CA></rowData></data>",null,"registrationReturnStandard_",true]
[null,null,"useNumberFormatBrowser_",false]
[null,null,"useNumberFormatLanguage_",true]
[null,null,"Cookie acceptance is required to register"]
[null,null,"Cookie settings"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"C\" class=\"microToolCookieConsentAcceptBtnCaption\"/></CA></rowData></data>",null,"Accept cookies"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"C\" class=\"microToolCookieConsentDeclineBtnCaption\"/></CA></rowData></data>",null,"Decline cookies"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"C\" class=\"microToolCookieConsentCloseBtnCaption\"/></CA></rowData></data>",null,"Close"]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"C\" class=\"microToolCookieConsentBannerText\"/></CA></rowData></data>",null,"This website uses <a class=\"microToolCookieConsentFullBtn\">cookies</a> to deliver functionality and enhance your experience. Please accept the use of cookies or <a class=\"microToolCookieConsentFullBtn\">review your cookie settings</a> now."]
["<data><rowData tag=\"X\" displayLevel=\"1\"><CA><ca name=\"p\" colBegin=\"C\" class=\"microToolCookieConsentFullPageText\"/></CA></rowData></data>",null,"A cookie is a small text file that a website saves on your computer or mobile device when you visit the site. It enables the website to remember your actions (data inputs, website navigation), so you don’t have to re-enter data when you come back to the site or browse from one page to another.\n\nBehavioral information collected by our web analytics vendor is used to analyze data pertaining to visitor trends, plan website enhancements, and measure overall website effectiveness. We may also use cookies or web beacons to help us offer you products, programs, or services that may be of interest to you and to deliver relevant advertising. We may use third-party advertising companies to help tailor website content to users or to serve ads on our behalf. These companies may also employ cookies and web beacons to measure advertising effectiveness.\n\nPlease accept cookies and the collection of behavioral information to receive full functionality and enhance your experience. If you decline cookies, some features of the website may not function normally.\n\nPlease see our <a href=\"https://www.forrester.com/marketing/policies/privacy-policy.html\" target=\"_blank\">Privacy Policy</a> for more information."]
[null,null,"Click to show/hide calculation details"]
[{"$nulls":3},{"$f":"LOOKUP(varNumberPeriods,C64:C83,D64:D83)","v":"Three"},"zh-cn","en-us"]
[null,null,1,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,E64:F64)","v":"One"},"一","One"]
[null,null,2,"Two","二","Two"]
[null,null,3,"Three","三","Three"]
[null,null,4,"Four","四","Four"]
[null,null,5,"Five","五","Five"]
[null,null,6,"Six","六","Six"]
[null,null,7,"Seven","七","Seven"]
[null,null,8,"Eight","八","Eight"]
[null,null,9,"Nine","九","Nine"]
[null,null,10,"Ten","十","Ten"]
[null,null,11,"Eleven","十一","Eleven"]
[null,null,12,"Twelve","十二","Twelve"]
[null,null,13,"Thirteen","十三","Thirteen"]
[null,null,14,"Fourteen","十四","Fourteen"]
[null,null,15,"Fifteen","十五","Fifteen"]
[null,null,16,"Sixteen","十六","Sixteen"]
[null,null,17,"Seventeen","十七","Seventeen"]
[null,null,18,"Eighteen","十八","Eighteen"]
[null,null,19,"Nineteen","十九","Nineteen"]
[null,null,20,"Twenty","二十","Twenty"]
[]
[null,null,{"$f":"tBenefit_t","v":"Benefit"}]
[null,null,{"$f":"tBenefits_t","v":"Benefits"}]
[null,null,{"$f":"tCost_t","v":"Cost"}]
[null,null,{"$f":"tCosts_t","v":"Costs"}]
[null,null,{"$f":"tBenefitsByCategory_t","v":"Benefits by Category"}]
[null,null,{"$f":"tCostsByCategory_t","v":"Costs by Category"}]
[null,null,{"$f":"tRiskadjustment_t","v":"Risk adjustment"}]
[null,null,{"$f":"triskadjustedParens_t","v":"(risk-adjusted)"}]
[null,null,{"$f":"tCashflows_t","v":"Cash flows"}]
[null,null,{"$f":"tCashflows1_t","v":"Cash\nflows"}]
[null,null,{"$f":"tFinancialAnalysisriskadjusted_t","v":"Financial Analysis (risk-adjusted)"}]
[null,null,{"$f":"tFinancialSummary_t","v":"Financial Summary"}]
[null,null,{"$f":"tFinancialSummaryXPeriods_t","v":"Financial Summary (Three-Year)"}]
[null,null,"Three-Year"]
[null,null,"Download full results"]
[null,null,"Download personalized analysis (PDF)"]
[null,null,"Required field"]
[null,null,"varLanguagesIgnoreNamedCells_","modelParameters,varCopyright,varCurrencies,varCurrencyCodes,varCurrencySymbols,varCurrencyValues,countryCodeList,tcookieText,languagesList,languagesCodes,exchangeRateDate,languagesListTemplate,masterModelTextChinese,registrationReturnStandardSheetRegister,registrationReturnStandardSheetGoto,registrationReturnStandardSheetUnhide,languagesFont"]
[null,null,{"$f":"\"Chinese for Template\"","v":"Chinese for Template"}]
[null,null,{"$f":"\"Select template language\"","v":"Select template language"},"English (US)"]
[{"$nulls":3},"Chinese"]
[{"$nulls":3},"English (US)"]
[]
[{"$nulls":3},{"$f":"\"zh-cn\"","v":"zh-cn"},{"$f":"\"en-us\"","v":"en-us"}]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D109:E109)","v":"Initial"},"初始值","Initial"]
[null,null,"Year 1","第一年",{"$f":"CONCATENATE(varPeriod,\" 1\")","v":"Year 1"}]
[null,null,"Year 2","第二年",{"$f":"CONCATENATE(varPeriod,\" 2\")","v":"Year 2"}]
[null,null,"Year 3","第三年",{"$f":"CONCATENATE(varPeriod,\" 3\")","v":"Year 3"}]
[null,null,"Year 4","第四年",{"$f":"CONCATENATE(varPeriod,\" 4\")","v":"Year 4"}]
[null,null,"Year 5","第五年",{"$f":"CONCATENATE(varPeriod,\" 5\")","v":"Year 5"}]
[null,null,"Year 6","第六年",{"$f":"CONCATENATE(varPeriod,\" 6\")","v":"Year 6"}]
[null,null,"Year 7","第七年",{"$f":"CONCATENATE(varPeriod,\" 7\")","v":"Year 7"}]
[null,null,"Year 8","第八年",{"$f":"CONCATENATE(varPeriod,\" 8\")","v":"Year 8"}]
[null,null,"Year 9","第九年",{"$f":"CONCATENATE(varPeriod,\" 9\")","v":"Year 9"}]
[null,null,"Year 10","第十年",{"$f":"CONCATENATE(varPeriod,\" 10\")","v":"Year 10"}]
[null,null,"Year 11","第十一年",{"$f":"CONCATENATE(varPeriod,\" 11\")","v":"Year 11"}]
[null,null,"Year 12","第十二年",{"$f":"CONCATENATE(varPeriod,\" 12\")","v":"Year 12"}]
[null,null,"Year 13","第十三年",{"$f":"CONCATENATE(varPeriod,\" 13\")","v":"Year 13"}]
[null,null,"Year 14","第十四年",{"$f":"CONCATENATE(varPeriod,\" 14\")","v":"Year 14"}]
[null,null,"Year 15","第十五年",{"$f":"CONCATENATE(varPeriod,\" 15\")","v":"Year 15"}]
[null,null,"Year 16","第十六年",{"$f":"CONCATENATE(varPeriod,\" 16\")","v":"Year 16"}]
[null,null,"Year 17","第十七年",{"$f":"CONCATENATE(varPeriod,\" 17\")","v":"Year 17"}]
[null,null,"Year 18","第十八年",{"$f":"CONCATENATE(varPeriod,\" 18\")","v":"Year 18"}]
[null,null,"Year 19","第十九年",{"$f":"CONCATENATE(varPeriod,\" 19\")","v":"Year 19"}]
[null,null,"Year 20","第二十年",{"$f":"CONCATENATE(varPeriod,\" 20\")","v":"Year 20"}]
[null,null,"Ref.","参考值","Ref."]
[null,null,"Metric","指标","Metric"]
[null,null,"Calculation","计算过程","Calculation"]
[null,null,"Total","总计","Total"]
[null,null,"Present Value","现值","Present Value"]
[null,null,"Payback period","投资回收期","Payback period"]
[null,null,"Cumulative","累计","Cumulative"]
[null,null,"ROI","ROI","ROI"]
[null,null,"months","月","months"]
[null,null,"quarters","季度","quarters"]
[null,null,"years","年","years"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D141:E141)","v":"Month"},"月","Month"]
[null,null,"Quarter","季度","Quarter"]
[null,null,"Year","年","Year"]
[null,null,"Benefit","收益","Benefit"]
[null,null,"Benefits","收益","Benefits"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D146:E146)","v":"Total Benefit"},"总收益","Total Benefit"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D147:E147)","v":"Total benefits (risk-adjusted)"},"总收益（经风险调整）","Total benefits (risk-adjusted)"]
[null,null,"Cost","成本","Cost"]
[null,null,"Costs","成本","Costs"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D150:E150)","v":"Total Cost"},"总成本","Total Cost"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D151:E151)","v":"Total costs (risk-adjusted)"},"总成本（经风险调整）","Total costs (risk-adjusted)"]
[null,null,"Benefits by Category","分项收益","Benefits by Category"]
[null,null,"Costs by Category","分项成本","Costs by Category"]
[null,null,"Risk adjustment","风险调整","Risk adjustment"]
[null,null,"(risk-adjusted)","（经风险调整）","(risk-adjusted)"]
[null,null,"Cash flows","现金流","Cash flows"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D157:E157)","v":"Cash\nflows"},"现金\n流","Cash\nflows"]
[null,null,"Financial Analysis (risk-adjusted)","财务分析（经风险调整）","Financial Analysis (risk-adjusted)"]
[null,null,"Cash flow analysis (risk-adjusted estimates)","现金流分析（经风险调整估算）","Cash flow analysis (risk-adjusted estimates)"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D160:E160)","v":"Total costs"},"总成本","Total costs"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D161:E161)","v":"Total Costs"},"总成本","Total Costs"]
[null,null,"Total benefits","总收益","Total benefits"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D163:E163)","v":"Total Benefits"},"总收益","Total Benefits"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D164:E164)","v":"Net benefits"},"净收益","Net benefits"]
[null,null,"Cumulative total costs","累计总成本","Cumulative total costs"]
[null,null,"Cumulative total benefits","累计总收益","Cumulative total benefits"]
[null,null,"Cumulative net benefits","累计净收益","Cumulative net benefits"]
[null,null,"Cumulative total benefits PV","累计总收益现值","Cumulative total benefits PV"]
[null,null,"Cumulative total costs PV","累计总成本现值","Cumulative total costs PV"]
[null,null,"Payback period (interim calculations)","投资回收期","Payback period (interim calculations)"]
[null,null,"Total benefits PV","总收益现值","Total benefits PV"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D172:E172)","v":"total benefits PV"},"总收益现值","total benefits PV"]
[null,null,"Total costs PV","总成本现值","Total costs PV"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D174:E174)","v":"total costs PV"},"总成本现值","total costs PV"]
[null,null,"Risk-Adjusted Financial Summary","经风险调整后的财务总结","Risk-Adjusted Financial Summary"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D176:E176)","v":"Financial Summary"},"财务总计","Financial Summary"]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D177:E177)","v":"Financial Summary (Three-Year)"},{"$f":"_xlfn.CONCAT(D176,\"（\",tXPeriod_t,\"）\")","v":"财务总计（Three-Year）"},{"$f":"_xlfn.CONCAT(E176,\" (\",tXPeriod_t,\")\")","v":"Financial Summary (Three-Year)"}]
[null,null,"Financial Summary (risk-adjusted estimates)","财务总计","Financial Summary (risk-adjusted estimates)"]
[null,null,"Total benefits (PV)","总收益（现值）","Total benefits (PV)"]
[null,null,"Total costs (PV)","总成本（现值）","Total costs (PV)"]
[null,null,"Net present value","净现值","Net present value"]
[null,null,"Three-Year",{"$f":"_xlfn.CONCAT(varNumberPeriodsWord,\"-\",varPeriod)","v":"Three-Year"},{"$f":"_xlfn.CONCAT(varNumberPeriodsWord,\"-\",varPeriod)","v":"Three-Year"}]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D183:E183)","v":"three-year"},{"$f":"LOWER(_xlfn.CONCAT(varNumberPeriodsWord,\"-\",varPeriod))","v":"three-year"},{"$f":"LOWER(_xlfn.CONCAT(varNumberPeriodsWord,\"-\",varPeriod))","v":"three-year"}]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D184:E184)","v":"Three-year"},{"$f":"_xlfn.CONCAT(varNumberPeriodsWord,\"-\",LOWER(varPeriod))","v":"Three-year"},{"$f":"_xlfn.CONCAT(varNumberPeriodsWord,\"-\",LOWER(varPeriod))","v":"Three-year"}]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D185:E185)","v":"Three-year total"},"TO BE TRANSLATED",{"$f":"_xlfn.CONCAT(varNumberPeriodsWord,\"-\",LOWER(varPeriod),\" total\")","v":"Three-year total"}]
[null,null,"Three-year present value","TO BE TRANSLATED",{"$f":"_xlfn.CONCAT(varNumberPeriodsWord,\"-\",LOWER(varPeriod),\" present value\")","v":"Three-year present value"}]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D187:E187)","v":"Risk-Adjusted"},"经风险调整","Risk-Adjusted"]
[null,null,"© 2021, Forrester Research, Inc. All rights reserved.","© 2021, Forrester Research, Inc. 保留所有权利。","© 2021, Forrester Research, Inc. All rights reserved."]
[null,null,{"$f":"LOOKUP(varLanguageTemplate,languagesListTemplate,D189:E189)","v":" This work is commissioned by Salesforce and delivered by Forrester Consulting."},{"$f":"_xlfn.CONCAT(\"本研究由\",varVendorName,\"委托Forrester Consulting撰写。\")","v":"本研究由Salesforce委托Forrester Consulting撰写。"},{"$f":"_xlfn.CONCAT(\" This work is commissioned by \", varVendorName, \" and delivered by Forrester Consulting.\")","v":" This work is commissioned by Salesforce and delivered by Forrester Consulting."}]
[]
[]
["<data><tableData tag=\"SdataEnd\" tableName=\"footer\"/><rowData tag=\"+\" displayLevel=\"-1\"></rowData></data>"]
["<data><rowData tag=\"-\" displayLevel=\"-1\"><CA><ca name=\"sheetEnd\" colBegin=\"B\"/></CA></rowData></data>"]

{"sheet":"$Lists","index":6,"n_rows":69,"n_cols":6,"rows_kept":69,"hidden":true}
["Currency Range Start","Currency Range End","Reset Cell","Reset Type","Reset Value","Reset toValue"]
[{"$f":"Inputs!$L$31","v":{"v":0,"d":"$0"}},{"$f":"Inputs!$M$31","v":{"v":0,"d":"$0"}},{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}},"resetFormula",{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}},false]
[{"$f":"Inputs!$L$42","v":{"v":0,"d":"$0"}},{"$f":"Inputs!$M$42","v":{"v":0,"d":"$0"}},{"$f":"Inputs!$H$24","v":"US Dollar"},"resetValue","US Dollar",true]
[{"$f":"Inputs!$K$47","v":{"v":0,"d":"$0"}},null,{"$f":"Settings!#REF!","v":{"$error":"#REF!"}},"resetValue",{"v":0.8,"d":"0.8000"},false]
[{"$f":"Inputs!$L$50","v":{"v":0,"d":"$0"}},{"$f":"Inputs!$M$50","v":{"v":0,"d":"$0"}},{"$f":"Settings!#REF!","v":{"$error":"#REF!"}},"resetValue",{"v":0.65,"d":"0.6500"}]
[{"$f":"Inputs!$K$51","v":{"v":0,"d":"$0"}},null,{"$f":"Settings!$K$49","v":{"v":0.1,"d":"10%"}},"resetFormula",{"$f":"Settings!L49","v":{"v":0.1,"d":"10%"}}]
[{"$f":"Inputs!$L$59","v":{"v":0,"d":"$0"}},{"$f":"Inputs!$M$59","v":{"v":0,"d":"$0"}}]
[{"$f":"Inputs!$L$63","v":{"v":0,"d":"$0"}},{"$f":"Inputs!$M$63","v":{"v":0,"d":"$0"}}]
[{"$f":"Inputs!$L$65","v":{"v":0,"d":"$0"}},{"$f":"Inputs!$M$65","v":{"v":0,"d":"$0"}}]
[{"$f":"Inputs!$F$70","v":{"v":0,"d":"$0"}}]
[{"$f":"Inputs!$F$71","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$11","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$11","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$12","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$12","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$13","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$13","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$14","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$14","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$M$15","v":0}]
[{"$f":"BenefitDetails!$I$40","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$K$40","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$I$43","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$K$43","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$I$46","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$K$46","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$I$49","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$K$49","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$51","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$51","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$53","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$53","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$G$54","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$G$55","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$M$56","v":0}]
[{"$f":"BenefitDetails!$I$66","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$K$66","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$I$68","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$K$68","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$69","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$69","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$71","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$71","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$G$72","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$G$73","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$O$73","v":{"v":1527006,"d":"$1,527,006"}}]
[{"$f":"BenefitDetails!$M$74","v":0}]
[{"$f":"BenefitDetails!$I$85","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$K$85","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$87","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$87","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$H$89","v":{"v":0,"d":"$0"}},{"$f":"BenefitDetails!$M$89","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$G$90","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$G$91","v":{"v":0,"d":"$0"}}]
[{"$f":"BenefitDetails!$M$92","v":0}]
[{"$f":"CostDetails!$H$11","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$M$11","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$H$12","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$M$12","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$H$13","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$M$13","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$M$14","v":0}]
[{"$f":"CostDetails!$H$42","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$H$43","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$M$43","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$H$45","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$M$45","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$G$46","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$G$47","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$M$48","v":0}]
[{"$f":"CostDetails!$H$58","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$H$60","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$H$61","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$M$61","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$H$63","v":{"v":0,"d":"$0"}},{"$f":"CostDetails!$M$63","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$G$64","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$G$65","v":{"v":0,"d":"$0"}}]
[{"$f":"CostDetails!$M$66","v":0}]
[{"$f":"Results!$G$15","v":{"v":0,"d":"$0"}},{"$f":"Results!$I$15","v":{"v":0,"d":"$0"}}]
[{"$f":"Results!$H$48","v":{"v":0,"d":"$0"}},{"$f":"Results!$M$48","v":{"v":0,"d":"$0"}}]
[{"$f":"Results!$H$49","v":{"v":0,"d":"$0"}},{"$f":"Results!$M$49","v":{"v":0,"d":"$0"}}]
[{"$f":"Results!$H$50","v":{"v":0,"d":"$0"}},{"$f":"Results!$M$50","v":{"v":0,"d":"$0"}}]
[{"$f":"Results!$H$54","v":0},{"$f":"Results!$K$54","v":0}]
[{"$f":"Results!$H$55","v":0},{"$f":"Results!$K$55","v":0}]
[{"$f":"Results!$H$56","v":{"v":0,"d":"$0"}},{"$f":"Results!$K$56","v":{"v":0,"d":"$0"}}]
[{"$f":"Results!$H$57","v":{"v":0,"d":"$0"}},{"$f":"Results!$K$57","v":{"v":0,"d":"$0"}}]
[{"$f":"Results!$H$58","v":{"v":0,"d":"$0"}},{"$f":"Results!$K$58","v":{"v":0,"d":"$0"}}]
[{"$f":"Results!$M$58","v":{"v":0,"d":"$0"}}]
[{"$f":"Results!$H$59","v":0},{"$f":"Results!$K$59","v":0}]
[{"$f":"Results!$H$60","v":0},{"$f":"Results!$K$60","v":0}]
[{"$f":"Settings!$L$41","v":100}]