{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Macro for Waterfall Chart","Notes on Waterfall Data","Chart3","Simple Examples","Waterfall Chart1","Waterfall Chartdata1"],"not_rendered":{"charts":9,"images":11,"macros":1,"external_links":0,"defined_names":32,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart3","index":2,"reason":"not_a_worksheet"},{"sheet":"Waterfall Chart1","index":4,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Macro for Waterfall Chart","index":0,"n_rows":168,"n_cols":58,"rows_kept":168,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132.23076923076923]
[null,null,null,null,"Shade Area in Box"]
[null,null,null,null,"and then press macro",null,null,null,null,null,null,null,null,"Example with Spinner "]
[]
[null,null,null,null,"Input Base and Incremental Values",null,null,null,null,null,null,null,null,"Base Case",450,null,"Base IRR",{"$f":"T5/100","v":0.24},null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"First Factor",-100,null,"Decrease for Sales",-1.4999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Second Factor",270,null,"Decrease for Timing",-0.02]
[null,null,null,null,"Last Year",1300,null,null,null,null,null,null,null,"Third Factor",20,null,"Decrease for Expense",-1.2E-2]
[null,null,null,null,"Base Revenue",50,null,null,null,null,null,null,null,"Subtotal",null,null,"Sub-total"]
[null,null,null,null,"Other Revenue",-20,null,null,null,null,null,null,null,"Fourth Factor",130,null,"Increase for Interest Rate",0.1]
[null,null,null,null,"Subtotal",null,null,null,null,null,null,null,null,"Fifth Factor",-450,null,"Increase for Mitigation",0.12]
[null,null,null,null,"Expense Cut",250,null,null,null,null,null,null,null,"Last Value",null,null,"Final IRR"]
[null,null,null,null,"Interest",100]
[null,null,null,null,"Other Income",-200,null,null,null,null,null,null,null,"Example with Negative: This is a big problem"]
[null,null,null,null,"Taxes",80]
[null,null,null,null,"Adjustment",1E-4,null,null,null,null,null,null,null,"Base Value",70,null,120]
[null,null,null,null,"End Point",null,null,null,null,null,null,null,null,"Decrease",-30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase",10]
[null,null,null,null,"All the code is in a macro called SELECT_RANGE",null,null,null,null,null,null,null,null,"Neg with Small Space",-45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change to Negative",-35]
[null,null,null,null,"Give Suggestions or Comments",null,null,null,null,null,null,null,null,"Final Value Negative"]
[null,null,null,null,"edwardbodmer@gmail.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Example with Zero"]
[]
[null,null,null,null,"Simplest Case - No Macro Needed",null,null,null,null,null,null,null,null,"Income 2014",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Increase",20]
[null,null,null,null,"Base Case",500,null,null,null,null,null,null,null,"Exp Decline",0]
[null,null,null,null,"Item 1",100,null,null,null,null,null,null,null,"Subtotal"]
[null,null,null,null,"Item 2",50,null,null,null,null,null,null,null,"Financing Cost",-10]
[null,null,null,null,"Item 3",30,null,null,null,null,null,null,null,"Income 2015"]
[null,null,null,null,"Item 4",70]
[null,null,null,null,"Final",null,null,null,null,null,null,null,null,"Decline to Below Zero"]
[]
[null,null,null,null,"Simple Case - All Negative",null,null,null,null,null,null,null,null,"Income 2014",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Decrease",-55]
[null,null,null,null,"Base Case",500,null,null,null,null,null,null,null,"Expense Increase",-72]
[null,null,null,null,"Increment 1",-100,null,null,null,null,null,null,null,"Income 2015"]
[null,null,null,null,"Increment 2",-50]
[null,null,null,null,"Increment 3",-30]
[null,null,null,null,"Increment 4",-70,null,null,null,null,null,null,null,"Extra Declince"]
[null,null,null,null,"Final"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Income 2014",100]
[null,null,null,null,"Case with Subtotals and Negative",null,null,null,null,null,null,null,null,"Sales Decrease",-55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expense Increase",-72]
[null,null,null,null,"Current Scenario",54404.019093385934,null,null,null,null,null,null,null,"Further Bad",-25]
[null,null,null,null,"Production",-9283.7093326934701,null,null,null,null,null,null,null,"Very Very Bad",-32]
[null,null,null,null,"Regulating",-862.77219204371795,null,null,null,null,null,null,null,"Income 2015"]
[null,null,null,null,"Merchant Prices",-6773.0918595786425]
[null,null,null,null,"Firming Cost",-3136.0327176909705]
[null,null,null,null,"Turbine Maintenance",2604.6543811865122,null,null,null,null,null,null,null,"Income",100]
[null,null,null,null,"Sub-total",null,null,null,null,null,null,null,null,"Rev 1",20]
[null,null,null,null,"Managed Services",2338.4139235946059,null,null,null,null,null,null,null,"Rev 2",18]
[null,null,null,null,"Administratve Fee",1355.170076015318,null,null,null,null,null,null,null,"Rev 3",15]
[null,null,null,null,"Insturance",1306.724583861178,null,null,null,null,null,null,null,"Rev 4",12]
[null,null,null,null,"Desk Cost",240.59569975744671,null,null,null,null,null,null,null,"Rev 5",10]
[null,null,null,null,"Total Wind Transmission",2214.3036637520272,null,null,null,null,null,null,null,"Rev 6",8]
[null,null,null,null,"Subtotal",null,null,null,null,null,null,null,null,"Rev 7",6]
[null,null,null,null,"Firming and Balancing",1737.8533012860644,null,null,null,null,null,null,null,"Exp 1",-4]
[null,null,null,null,"PTC Correction",-165.2179263580183,null,null,null,null,null,null,null,"Exp 2",-7]
[null,null,null,null,"Inflation",3534.532728416365,null,null,null,null,null,null,null,"Exp 3",-9]
[null,null,null,null,"Base Case",null,null,null,null,null,null,null,null,"Exp 4",-10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exp 5",-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exp 6",-13]
[null,null,null,null,"Starting EBITDA",300,null,null,null,null,null,null,null,"Exp 7",-16]
[null,null,null,null,"Increment 1",50,null,null,null,null,null,null,null,"Final"]
[null,null,null,null,"Increment 2",-30]
[null,null,null,null,"Increment 3",-15,null,null,null,null,null,null,null,"Downside Analysis with Negative"]
[null,null,null,null,"Sub-total"]
[null,null,null,null,"Increment 5",140,null,null,null,null,null,null,null,"Base Case",0.05]
[null,null,null,null,"Increment 6",-260,null,null,null,null,null,null,null,"Cost Overrun Risk",-1.432988194289142E-2]
[null,null,null,null,"Final EBITDA",null,null,null,null,null,null,null,null,"Availability Risk",-1.0316923830798852E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract vs Actual Heat Rate",-1.6266409383592584E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Higher Variable O&M",-7.3628783091245209E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Higher Fixed O&M",-1.4303854791796633E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Downside Analysis with Negative"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Case",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Overrun Risk",-1.432988194289142E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Availability Risk",-1.0316923830798852E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract vs Actual Heat Rate",-1.6266409383592584E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Higher Variable O&M",-7.3628783091245209E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Higher Fixed O&M",-1.4303854791796633E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Bad Stuff",-0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case"]
[]
[]
[null,null,null,null,"Downside Analysis with Negative",null,null,null,null,null,null,null,null,"Downside Analysis with Negative"]
[]
[null,null,null,null,"Base Case",1.2,null,null,null,null,null,null,null,"Base Case",0.05]
[null,null,null,null,"Cost Overrun Risk",-0.1,null,null,null,null,null,null,null,"Cost Overrun Risk",-1.432988194289142E-2]
[null,null,null,null,"Availability Risk",-0.2,null,null,null,null,null,null,null,"Availability Risk",0.02]
[null,null,null,null,"Contract vs Actual Heat Rate",0.18,null,null,null,null,null,null,null,"Contract vs Actual Heat Rate",-0.04]
[null,null,null,null,"Higher Variable O&M",-0.3,null,null,null,null,null,null,null,"Higher Variable O&M",-3.2000000000000001E-2]
[null,null,null,null,"Higher Fixed O&M",0.12,null,null,null,null,null,null,null,"Higher Fixed O&M",-1.4303854791796633E-2]
[null,null,null,null,"Other Bad Stuff",0.14000000000000001,null,null,null,null,null,null,null,"Other Bad Stuff",-0.03]
[null,null,null,null,"Worst Case",null,null,null,null,null,null,null,null,"Worst Case"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative Test"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Base",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Incease",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Decrease 1",-35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Decrease 2",-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Final"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change Sign and Increase without Sign Change"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Starting Point",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal Decrease",-15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Decrease",-55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase After Change",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Second Increase",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Final"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change Sign and Increase with Second Sign Change"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Starting Point",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal Decrease",-15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Decrease",-55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase After Change",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Second Increase",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Final"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ultimate"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Starting Point",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal Increase",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal Decrease",-15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Zero Test",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Decrease",-55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase After Decrease",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost 3 ",-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost 4 ",-35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Final Point"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative Start - Declining"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Base",-10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Incease",-14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Decrease 1",-35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Decrease 2",-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Final"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative Start - Increasing"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Base",-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Incease",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Decrease 1",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Decrease 2",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Final"]

{"sheet":"Notes on Waterfall Data","index":1,"n_rows":143,"n_cols":82,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
["Income 2014 \r 100.00",100,null,null,6.666666666666667,100,null,null,null,null,null,null,100,{"$f":"M1","v":100},null,{"$f":"N1","v":100},{"$f":"ABS(O1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"BA1+BB1","v":2600},{"$f":"BB1-BC1","v":1300},{"$f":"BB1","v":1300},null,true,true,{"$f":"waterfall_graph_data1","v":"Last Year"},1300,{"$f":"BA1","v":1300},null,{"$f":"CHOOSE(AS1,AV1,AU1,AT1)","v":1300},{"$f":"IF(BB1>=0,ABS(BC1),-ABS(BC1))","v":0},null,{"$f":"BD1","v":1300},{"$f":"IF(BC1>=0,0,BF1)","v":0},{"$f":"IF(BC1<0,0,BF1)","v":0},{"$f":"BA1","v":1300},null,null,null,null,null,null,{"$f":"AZ1","v":"Last Year"}," \n",{"$f":"BB1","v":1300},{"$f":"BQ1&BR1&TEXT(BS1,\"*,#,##0.00;(*,(#,##0.00);(* ??_);_(@_)\")","v":"Last Year \n1,300.00"},{"$f":"BG1","v":1300},0,{"$f":"BE1","v":0},{"$f":"BI1","v":0},{"$f":"BB1","v":1300}]
["Sales Increase \r 70.00",63.333333333333336,6.666666666666667,30,null,100,70,null,null,null,null,null,-30,{"$f":"IF(M2<>0,N1+M2,N1)","v":70},{"$f":"N2-N1","v":-30},{"$f":"IF(O2>=0,N2-O2,N1+O2)","v":70},30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1400,1300,1350,null,false,true,"Base Revenue",50,{"$f":"IF(AY2,BB1+BA2,BB1)","v":1350},{"$f":"BB2-BB1","v":50},1350,50,null,1350,0,0,{"$f":"IF(BC2<>0,BC2,BB2)","v":50},null,null,null,null,null,null,"Base Revenue"," \n",{"$f":"BB2","v":1350},{"$f":"BQ2&BR2&TEXT(BS2,\"*,#,##0.00;(*,(#,##0.00);(* ??_);_(@_)\")","v":"Base Revenue \n1,350.00"},1350,0,50,0,{"$f":"BB1","v":1300},{"$f":"BB2","v":1350}]
["Exp Decline \r 40.00",33.333333333333336,6.666666666666667,30,null,null,70,40,null,null,null,null,-30,{"$f":"IF(M3<>0,N2+M3,N2)","v":40},{"$f":"N3-N2","v":-30},{"$f":"IF(O3>=0,N3-O3,N2+O3)","v":40},30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1310,1350,1330,null,false,true,"Other Revenue",-20,{"$f":"IF(AY3,BB2+BA3,BB2)","v":1330},{"$f":"BB3-BB2","v":-20},1330,20,null,1330,0,0,{"$f":"IF(BC3<>0,BC3,BB3)","v":-20},null,null,null,null,null,null,"Other Revenue"," \n",{"$f":"BB3","v":1330},{"$f":"BQ3&BR3&TEXT(BS3,\"*,#,##0.00;(*,(#,##0.00);(* ??_);_(@_)\")","v":"Other Revenue \n1,330.00"},1330,0,20,0,null,{"$f":"BB2","v":1350},{"$f":"BB3","v":1330}]
["Other \r 40.00",40,null,0,6.666666666666667,null,null,40,40,null,null,null,-40,{"$f":"IF(M4<>0,N3+M4,N3)","v":0},{"$f":"N4-N3","v":-40},{"$f":"IF(O4>=0,N4-O4,N3+O4)","v":0},40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1330,1330,1330,null,false,true,"Subtotal",0,{"$f":"IF(AY4,BB3+BA4,BB3)","v":1330},{"$f":"BB4-BB3","v":0},1330,0,null,1330,0,0,{"$f":"IF(BC4<>0,BC4,BB4)","v":1330},null,null,null,null,null,null,"Subtotal"," \n",9.9999999999999995E-7,{"$f":"BQ4&BR4&TEXT(BS4,\"*,#,##0.00;(*,(#,##0.00);(* ??_);_(@_)\")","v":"Subtotal \n0.00"},1330,0,0,0,null,null,{"$f":"BB3","v":1330},{"$f":"BB4","v":1330}]
["Financing Cost \r -20.00",-26.666666666666668,6.666666666666667,60,null,null,null,null,40,-20,null,null,-20,{"$f":"IF(M5<>0,N4+M5,N4)","v":-20},{"$f":"N5-N4","v":-20},{"$f":"IF(O5>=0,N5-O5,N4+O5)","v":-20},20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1830,1330,1580,null,false,true,"Expense Cut",250,{"$f":"IF(AY5,BB4+BA5,BB4)","v":1580},{"$f":"BB5-BB4","v":250},1330,250,null,1330,0,0,{"$f":"IF(BC5<>0,BC5,BB5)","v":250},null,null,null,null,null,null,"Expense Cut"," \n",{"$f":"BB5","v":1580},{"$f":"BQ5&BR5&TEXT(BS5,\"*,#,##0.00;(*,#,##0.00);(* ??_);_(@_)\")","v":"Expense Cut \n1,580.00"},1330,{"$f":"BH5","v":0},250,0,null,null,null,{"$f":"BB4","v":1330},{"$f":"BB5","v":1580}]
["Income 2015 \r -20.00",-20,null,0,6.666666666666667,null,null,null,null,-20,-20,null,0,{"$f":"IF(M6<>0,N5+M6,N5)","v":-20},{"$f":"N6-N5","v":0},{"$f":"IF(O6>=0,N6-O6,N5+O6)","v":-20},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1680,1580,1580,null,false,false,"Interest",100,{"$f":"IF(AY6,BB5+BA6,BB5)","v":1580},{"$f":"BB6-BB5","v":0},1580,0,null,1580,0,0,{"$f":"IF(BC6<>0,BC6,BB6)","v":1580},null,null,null,null,null,null,"Interest"," \n",{"$f":"BB6","v":1580},{"$f":"BQ6&BR6&TEXT(BS6,\"*,#,##0.00;(*,#,##0.00);(* ??_);_(@_)\")","v":"Interest \n1,580.00"},1580,{"$f":"BH6","v":0},0,0,null,null,null,null,{"$f":"BB5","v":1580}]
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":54},{"$f":"COLUMN()","v":55},{"$f":"COLUMN()","v":56},{"$f":"COLUMN()","v":57},{"$f":"COLUMN()","v":58},{"$f":"COLUMN()","v":59},{"$f":"COLUMN()","v":60},{"$f":"COLUMN()","v":61},{"$f":"COLUMN()","v":62},{"$f":"COLUMN()","v":63},{"$f":"COLUMN()","v":64},{"$f":"COLUMN()","v":65},{"$f":"COLUMN()","v":66},{"$f":"COLUMN()","v":67},{"$f":"COLUMN()","v":68},{"$f":"COLUMN()","v":69},{"$f":"COLUMN()","v":70},{"$f":"COLUMN()","v":71},{"$f":"COLUMN()","v":72},{"$f":"COLUMN()","v":73},{"$f":"COLUMN()","v":74},{"$f":"COLUMN()","v":75},{"$f":"COLUMN()","v":76},{"$f":"COLUMN()","v":77},{"$f":"COLUMN()","v":78},{"$f":"COLUMN()","v":79},{"$f":"COLUMN()","v":80},{"$f":"COLUMN()","v":81},{"$f":"COLUMN()","v":82}]
[" Fixed Graph: Graph Titles ",null,null," Fixed Graph: Increment (absolute Value) ",null," Fixed Graph: Connectors ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accumulation",null,null,null,null,null," CALCULATION: BASE VALUE: If not zero accumulate; if zero Last Value, CHANGE TO TRUE/FALSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASIS FOR X-AXIS",null,"BASIS FOR X-AXIS"," GRAPH: This is the x-axis title Link to the Title "]
[null," Fixed Graph: Base of Stacked Bar",null,null," Fixed Graph: Space for Increment ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Difference",null,null,null,null,null,null," CALCULATION: ACCUMULATED VALUE:  Formula is accumulation ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Adjusted Base of Stack from calculation  THIS IS SERIES 1"]
[null,null," Fixed Graph: Space for Negative Label (Not Graphed ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Difference",null,null,null,null,null,null,null,null," CALCULATION: INCREMENT: Formula is difference between accumulated value ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Space for Value in Negative Case  "]
[" TO MAKE GRAPH BY YOURSELF ",null,null,null,null,null,null,null,null,null,null,"   Chart Title",{"$f":"AZ1","v":"Last Year"},{"$f":"TEXT(BB1,\"*,#,##0.00;(*,(#,##0.00);(* ??_);_(@_)\")","v":"1,300.00"},"Bulid-up Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choose",null,null,null,null,null,null,"NEED TO CHANGE THIS -------->",null,null,null," CALCULATION: BASE OF STACK BAR WITHOUT ADJUSTMENT:  Base of Stacked Bar: Formula depends on the increment.  If positive then ACC - Incr if negative Last ACC + Incr ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Absolute Value of Increment  "]
["    1. PRESS ALT F1 on the yellow AREA  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compute Switch for normal/subtotal",null,null,null,null,null,null,null,null," CALCULATION: ABS VALUE OF INCREMENT: This is enough to make graph without fancy stuff ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," GRAPH: Space for Value in Positive Case  "]
["    2. CHANGE TO STACKED BAR  AND SWITCH AROUND ROW AND COLUMN  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," INPUT: LABEL SPACE: This is enough to make graph without fancy stuff "]
["    3. SELECT DATA SERIES AND NO FILL EVERYTHING EXCEPT INCREMENTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: ADJUSTED BASE VALUE: This is base of the stacked bar minus the label space if the increment is negative "]
["    4. SELECT DATA PONTS FOR BASE BAR AND FILL STARTING, ENDING AND SUBTOTALS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Make minimum scale low",null,null,null,null,null,null,null,null,null,null,null," CALCULATION: NEGATIVE SPACE: This is the label space if the increment is negative "]
["   5. CHANGE THE SERIES CHART TYPE OF THE CONNECTOR LINES -- SERIES 5 FORWARD ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base is blue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CALCULATION: POSITIVE SPACE: This is label space if the increment is positive "]
[]
["THERE IS A CALCULATION SECTION AND A GRAPH SECTION ON THE RIGHT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Increment is green",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fix Title: If zero then make .0000001"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE DATA FROM RANGE NAME THAT CAN CHANGE"]
["There are always the same number of series"]
["Leave Series",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Set the current workbook",null,null,null,null,null,null,"Fix Formatting on the x-axis titles"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis"]
["Demonstrate with Macro"]
[null,null,null,null,null,null,19]
["Try to add spinners and range names"]
["Delete range names",null,null,null,null,null,{"$f":"LOG(G25)/LOG(10)","v":1.2787536009528289}]
[]
[null,null,null,null,null,null,{"$f":"ROUNDUP(G25,-1)","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed with removed paranthesis around"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Videos","Video"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overview of Program","https://www.youtube.com/watch?v=0Abx6Ji90cc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart from New Sheet: Formatting Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart from New Sheet: Getting One Chart Correct"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart from New Sheet: Creating Multiple Charts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart from New Sheet: Changing Chart Data wiith Spinner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments on Adjusting Charts"]

{"sheet":"Simple Examples","index":3,"n_rows":72,"n_cols":8,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
["Easiest Case -- Positive -- Base is Just the Sum of the Increments"]
[null,null,"Base","Sum + Incr",null,null,"Sum"]
[null,"Base",{"$f":"C8","v":25},{"$f":"D8","v":25},{"$f":"D9","v":40},{"$f":"D10","v":50},{"$f":"D11","v":65},"Use Cum"]
[null,"Increment",0,{"$f":"C9","v":15},{"$f":"C10","v":10},{"$f":"C11","v":15},{"$f":"C12","v":0}]
[]
[null,null,"Input","Accum"]
[null,"base",25,{"$f":"C8","v":25}]
[null,"Decrease",15,{"$f":"D8+C9","v":40}]
[null,"Decrease",10,{"$f":"D9+C10","v":50}]
[null,"Decrease",15,65]
[null,null,null,65]
[]
["Negative Case -- Base is Accumulation and Make Absolute Value"]
[null,null,"Base","Abs and Subtract",null,null,"End is last"]
[null,"Base",{"$f":"C20","v":100},{"$f":"D21","v":80},{"$f":"D22","v":65},{"$f":"D23","v":55},{"$f":"D24","v":55},"Use Cum"]
[null,"Increment",0,{"$f":"-C21","v":20},{"$f":"-C22","v":15},{"$f":"-C23","v":10},{"$f":"C25","v":0},"Abs Value"]
[]
[]
[null,"base",100,{"$f":"C20","v":100}]
[null,"Incease",-20,{"$f":"D20+C21","v":80}]
[null,"Decrease",-15,{"$f":"D21+C22","v":65}]
[null,"Decrease",-10,55]
[null,null,null,55]
[]
[]
["One Change in Sign Case Positive to Negative -- Much More Difficult"]
[null,null,null,null,"Need to Fill both"]
[null,"Deminstrates problem when the accumulated amount changes sign"]
[]
[null,"Series 1",{"$f":"D36","v":10},{"$f":"D36","v":10},{"$f":"D37","v":25},{"$f":"D38","v":-10},{"$f":"SUM(F31:F32)","v":-30}]
[null,"Series 2",0,{"$f":"C37","v":15},{"$f":"D38","v":-10},-20,0]
[]
[null,"Difference",null,{"$f":"D31-D32","v":-5},{"$f":"E31-E32","v":35},null,{"$f":"G31-G32","v":-30}]
[null,null,null,null,"Chg Sign"]
[null,"base",10,{"$f":"C36","v":10}]
[null,"Incease",15,{"$f":"D36+C37","v":25}]
[null,"Decrease",-35,{"$f":"D37+C38","v":-10}]
[null,"Decrease",-20,-30]
[]
[]
["One Change in Sign and Continued Negative"]
[null,null,null,null,"Leave",null,"Opposite"]
[null,null,null,null,"Change","Last","of Sum"]
[]
[null,"Series 1",{"$f":"C51","v":10},{"$f":"SUM(C46:C47)","v":10},{"$f":"SUM(D46:D47)","v":25},{"$f":"D53","v":-10},{"$f":"SUM(F46:F47)","v":-30},{"$f":"SUM(G46:G47)","v":-60}]
[null,"Series 2",0,{"$f":"C52","v":15},{"$f":"D53","v":-10},{"$f":"C54","v":-20},{"$f":"C55","v":-30},0]
[]
[null,"Difference",null,{"$f":"D46-D47","v":-5},{"$f":"E46-E47","v":35},null,null,{"$f":"H46-H47","v":-60}]
[]
[null,"base",10,{"$f":"C51","v":10}]
[null,"Incease",15,{"$f":"D51+C52","v":25},null,"If prior is negative"]
[null,"Decrease",-35,{"$f":"D52+C53","v":-10},null,"Then make increment w/o abs"]
[null,"Decrease",-20,-30]
[null,"Decrease",-30,-60]
[null,null,null,-60]
[]
[]
[null,null,null,null,"Leave",null,"Opposite"]
[null,null,null,null,"Change","Last","of Sum"]
[]
[null,"Series 1",{"$f":"C67","v":10},{"$f":"SUM(C62:C63)","v":10},{"$f":"SUM(D62:D63)","v":25},{"$f":"E63","v":-60},{"$f":"D71","v":20},{"$f":"SUM(G62:G63)","v":30}]
[null,"Series 2",0,{"$f":"C68","v":15},{"$f":"C69-E62","v":-60},{"$f":"D70+D69","v":35},{"$f":"C71","v":10},0]
[]
[null,"Difference",null,{"$f":"D62-D63","v":-5},{"$f":"E62-E63","v":85},null,null,{"$f":"H62-H63","v":30}]
[null,null,null,"Accum"]
[null,"base",10,{"$f":"C67","v":10}]
[null,"Incease",15,{"$f":"D67+C67","v":20},null,"If prior is negative"]
[null,"Decrease",-35,{"$f":"D68+C68","v":35},null,"Then make increment w/o abs"]
[null,"Increase",20,0]
[null,"Decrease",10,20]
[null,null,null,30]

{"sheet":"Waterfall Chartdata1","index":5,"n_rows":18,"n_cols":100,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U1,BF1,BF1,BF1,0,0,0,0,-BF1)","v":433.33333333333337},{"$f":"CHOOSE(U1,0,BA1,Q1,-BA1,-BA1,0,BA1,-BA1)","v":0},{"$f":"IF(AX1,BA1+R1,0)","v":0},null,{"$f":"CHOOSE(U1,AV1,AV1-BA1,AV1-BA1,AV1,AV1-BF1,AV1,R1-T1,AV1)","v":1300},{"$f":"CHOOSE(U1,0,0,0,AV1-BF1,BF1,-BF1,-BF1,0)","v":0},{"$f":"AE1*1+AD1*2+AC1*3+AB1*4+AA1*5+Z1*6+Y1*7+X1*8","v":1},{"$f":"SUMPRODUCT(X1:AE1*1)","v":1},null,{"$f":"AND(AV1<0,BA1>0)","v":false},{"$f":"AND(BA1<0,AU1<0,NOT(AY1))","v":false},{"$f":"AH1","v":false},{"$f":"AND(AF1,NOT(AX1),NOT(AB1),NOT(AD1),AU1>0)","v":false},{"$f":"AND(NOT(AX1),AJ1<0,AF1,NOT(Y1),AG1)","v":false},{"$f":"AND(AX1,BA1<0)","v":false},{"$f":"AND(AF1,BA1>0,AV1>0)","v":false},{"$f":"AND(AY1,AV1>0)","v":true},{"$f":"NOT(AY1)","v":false},{"$f":"BA1<0","v":false},{"$f":"AND(AV1<0,AY1)","v":false},null,{"$f":"AV1-BF1","v":866.66666666666663},null,null,null,null,null,null,null,null,null,null,{"$f":"BA1","v":1300},{"$f":"BA1","v":1300},{"$f":"IF(AV1>0,1,0)","v":1},false,true,{"$f":"waterfall_graph_data1","v":"Last Year"},1300,{"$f":"AU1","v":1300},null,null,null,433.33333333333337,null,null,null,{"$f":"IF(AY1,BB1,BA1)","v":1300},null,null,null,null,null,null,{"$f":"AZ1","v":"Last Year"}," \n",{"$f":"BB1","v":1300},{"$f":"BQ1&BR1","v":"Last Year \n"},{"$f":"S1","v":1300},{"$f":"T1","v":0},{"$f":"P1","v":0},{"$f":"O1","v":433.33333333333337},{"$f":"BB1","v":1300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U2,BF2,BF2,BF2,0,0,0,0,-BF2)","v":433.33333333333337},{"$f":"CHOOSE(U2,0,BA2,Q2,-BA2,-BA2,0,BA2,-BA2)","v":50},{"$f":"IF(AX2,BA2+R2,0)","v":0},{"$f":"AV1","v":1300},{"$f":"CHOOSE(U2,AV2,AV2-BA2,AV2-BA2,AV2,AV2-BF2,AV2,R2-T2,AV2)","v":1300},{"$f":"CHOOSE(U2,0,0,0,AV2-BF2,BF2,-BF2,-BF2,0)","v":0},{"$f":"AE2*1+AD2*2+AC2*3+AB2*4+AA2*5+Z2*6+Y2*7+X2*8","v":2},{"$f":"SUMPRODUCT(X2:AE2*1)","v":1},null,{"$f":"AND(AV2<0,BA2>0)","v":false},{"$f":"AND(BA2<0,AU2<0,NOT(AY2))","v":false},{"$f":"AH2","v":false},{"$f":"AND(AF2,NOT(AX2),NOT(AB2),NOT(AD2),AU2>0)","v":false},{"$f":"AND(NOT(AX2),AJ2<0,AF2,NOT(Y2),AG2)","v":false},{"$f":"AND(AX2,BA2<0)","v":false},{"$f":"AND(AF2,BA2>0,AV2>0)","v":true},{"$f":"AND(AY2,AV2>0)","v":false},{"$f":"NOT(AY2)","v":true},{"$f":"BA2<0","v":false},{"$f":"AND(AV2<0,AY2)","v":false},null,{"$f":"AV2-BF2","v":916.66666666666663},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX2,AV1,AV2)","v":1350},{"$f":"AV1+BA2","v":1350},{"$f":"IF(AV2>0,1,0)","v":1},{"$f":"AV2*AV1<0","v":false},false,"Base Revenue",50,{"$f":"AU2","v":1350},null,null,null,{"$f":"BF1","v":433.33333333333337},null,null,null,{"$f":"IF(AY2,BB2,BA2)","v":50},null,null,null,null,null,null,{"$f":"AZ2","v":"Base Revenue"}," \n",{"$f":"BB2","v":1350},{"$f":"BQ2&BR2","v":"Base Revenue \n"},{"$f":"S2","v":1300},{"$f":"T2","v":0},{"$f":"P2","v":50},{"$f":"O2","v":433.33333333333337},{"$f":"BB1","v":1300},{"$f":"BB2","v":1350}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U3,BF3,BF3,BF3,0,0,0,0,-BF3)","v":0},{"$f":"CHOOSE(U3,0,BA3,Q3,-BA3,-BA3,0,BA3,-BA3)","v":20},{"$f":"IF(AX3,BA3+R3,0)","v":0},{"$f":"AV2","v":1350},{"$f":"CHOOSE(U3,AV3,AV3-BA3,AV3-BA3,AV3,AV3-BF3,AV3,R3-T3,AV3)","v":896.66666666666663},{"$f":"CHOOSE(U3,0,0,0,AV3-BF3,BF3,-BF3,-BF3,0)","v":433.33333333333337},{"$f":"AE3*1+AD3*2+AC3*3+AB3*4+AA3*5+Z3*6+Y3*7+X3*8","v":5},{"$f":"SUMPRODUCT(X3:AE3*1)","v":1},null,{"$f":"AND(AV3<0,BA3>0)","v":false},{"$f":"AND(BA3<0,AU3<0,NOT(AY3))","v":false},{"$f":"AH3","v":false},{"$f":"AND(AF3,NOT(AX3),NOT(AB3),NOT(AD3),AU3>0)","v":true},{"$f":"AND(NOT(AX3),AJ3<0,AF3,NOT(Y3),AG3)","v":false},{"$f":"AND(AX3,BA3<0)","v":false},{"$f":"AND(AF3,BA3>0,AV3>0)","v":false},{"$f":"AND(AY3,AV3>0)","v":false},{"$f":"NOT(AY3)","v":true},{"$f":"BA3<0","v":true},{"$f":"AND(AV3<0,AY3)","v":false},null,{"$f":"AV3-BF3","v":896.66666666666663},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX3,AV2,AV3)","v":1330},{"$f":"AV2+BA3","v":1330},{"$f":"IF(AV3>0,1,0)","v":1},{"$f":"AV3*AV2<0","v":false},false,"Other Revenue",-20,{"$f":"AU3","v":1330},null,null,null,{"$f":"BF2","v":433.33333333333337},null,null,null,{"$f":"IF(AY3,BB3,BA3)","v":-20},null,null,null,null,null,null,{"$f":"AZ3","v":"Other Revenue"}," \n",{"$f":"BB3","v":1330},{"$f":"BQ3&BR3","v":"Other Revenue \n"},{"$f":"S3","v":896.66666666666663},{"$f":"T3","v":433.33333333333337},{"$f":"P3","v":20},{"$f":"O3","v":0},null,{"$f":"BB2","v":1350},{"$f":"BB3","v":1330}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U4,BF4,BF4,BF4,0,0,0,0,-BF4)","v":433.33333333333337},{"$f":"CHOOSE(U4,0,BA4,Q4,-BA4,-BA4,0,BA4,-BA4)","v":0},{"$f":"IF(AX4,BA4+R4,0)","v":0},{"$f":"AV3","v":1330},{"$f":"CHOOSE(U4,AV4,AV4-BA4,AV4-BA4,AV4,AV4-BF4,AV4,R4-T4,AV4)","v":1330},{"$f":"CHOOSE(U4,0,0,0,AV4-BF4,BF4,-BF4,-BF4,0)","v":0},{"$f":"AE4*1+AD4*2+AC4*3+AB4*4+AA4*5+Z4*6+Y4*7+X4*8","v":1},{"$f":"SUMPRODUCT(X4:AE4*1)","v":1},null,{"$f":"AND(AV4<0,BA4>0)","v":false},{"$f":"AND(BA4<0,AU4<0,NOT(AY4))","v":false},{"$f":"AH4","v":false},{"$f":"AND(AF4,NOT(AX4),NOT(AB4),NOT(AD4),AU4>0)","v":false},{"$f":"AND(NOT(AX4),AJ4<0,AF4,NOT(Y4),AG4)","v":false},{"$f":"AND(AX4,BA4<0)","v":false},{"$f":"AND(AF4,BA4>0,AV4>0)","v":false},{"$f":"AND(AY4,AV4>0)","v":true},{"$f":"NOT(AY4)","v":false},{"$f":"BA4<0","v":false},{"$f":"AND(AV4<0,AY4)","v":false},null,{"$f":"AV4-BF4","v":896.66666666666663},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX4,AV3,AV4)","v":1330},{"$f":"AV3+BA4","v":1330},{"$f":"IF(AV4>0,1,0)","v":1},{"$f":"AV4*AV3<0","v":false},true,"Subtotal",0,{"$f":"AU4","v":1330},null,null,null,{"$f":"BF3","v":433.33333333333337},null,null,null,{"$f":"IF(AY4,BB4,BA4)","v":1330},null,null,null,null,null,null,{"$f":"AZ4","v":"Subtotal"}," \n",{"$f":"BB4","v":1330},{"$f":"BQ4&BR4","v":"Subtotal \n"},{"$f":"S4","v":1330},{"$f":"T4","v":0},{"$f":"P4","v":0},{"$f":"O4","v":433.33333333333337},null,null,{"$f":"BB3","v":1330},{"$f":"BB4","v":1330}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U5,BF5,BF5,BF5,0,0,0,0,-BF5)","v":433.33333333333337},{"$f":"CHOOSE(U5,0,BA5,Q5,-BA5,-BA5,0,BA5,-BA5)","v":250},{"$f":"IF(AX5,BA5+R5,0)","v":0},{"$f":"AV4","v":1330},{"$f":"CHOOSE(U5,AV5,AV5-BA5,AV5-BA5,AV5,AV5-BF5,AV5,R5-T5,AV5)","v":1330},{"$f":"CHOOSE(U5,0,0,0,AV5-BF5,BF5,-BF5,-BF5,0)","v":0},{"$f":"AE5*1+AD5*2+AC5*3+AB5*4+AA5*5+Z5*6+Y5*7+X5*8","v":2},{"$f":"SUMPRODUCT(X5:AE5*1)","v":1},null,{"$f":"AND(AV5<0,BA5>0)","v":false},{"$f":"AND(BA5<0,AU5<0,NOT(AY5))","v":false},{"$f":"AH5","v":false},{"$f":"AND(AF5,NOT(AX5),NOT(AB5),NOT(AD5),AU5>0)","v":false},{"$f":"AND(NOT(AX5),AJ5<0,AF5,NOT(Y5),AG5)","v":false},{"$f":"AND(AX5,BA5<0)","v":false},{"$f":"AND(AF5,BA5>0,AV5>0)","v":true},{"$f":"AND(AY5,AV5>0)","v":false},{"$f":"NOT(AY5)","v":true},{"$f":"BA5<0","v":false},{"$f":"AND(AV5<0,AY5)","v":false},null,{"$f":"AV5-BF5","v":1146.6666666666665},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX5,AV4,AV5)","v":1580},{"$f":"AV4+BA5","v":1580},{"$f":"IF(AV5>0,1,0)","v":1},{"$f":"AV5*AV4<0","v":false},false,"Expense Cut",250,{"$f":"AU5","v":1580},null,null,null,{"$f":"BF4","v":433.33333333333337},null,null,null,{"$f":"IF(AY5,BB5,BA5)","v":250},null,null,null,null,null,null,{"$f":"AZ5","v":"Expense Cut"}," \n",{"$f":"BB5","v":1580},{"$f":"BQ5&BR5","v":"Expense Cut \n"},{"$f":"S5","v":1330},{"$f":"T5","v":0},{"$f":"P5","v":250},{"$f":"O5","v":433.33333333333337},null,null,null,{"$f":"BB4","v":1330},{"$f":"BB5","v":1580}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U6,BF6,BF6,BF6,0,0,0,0,-BF6)","v":433.33333333333337},{"$f":"CHOOSE(U6,0,BA6,Q6,-BA6,-BA6,0,BA6,-BA6)","v":100},{"$f":"IF(AX6,BA6+R6,0)","v":0},{"$f":"AV5","v":1580},{"$f":"CHOOSE(U6,AV6,AV6-BA6,AV6-BA6,AV6,AV6-BF6,AV6,R6-T6,AV6)","v":1580},{"$f":"CHOOSE(U6,0,0,0,AV6-BF6,BF6,-BF6,-BF6,0)","v":0},{"$f":"AE6*1+AD6*2+AC6*3+AB6*4+AA6*5+Z6*6+Y6*7+X6*8","v":2},{"$f":"SUMPRODUCT(X6:AE6*1)","v":1},null,{"$f":"AND(AV6<0,BA6>0)","v":false},{"$f":"AND(BA6<0,AU6<0,NOT(AY6))","v":false},{"$f":"AH6","v":false},{"$f":"AND(AF6,NOT(AX6),NOT(AB6),NOT(AD6),AU6>0)","v":false},{"$f":"AND(NOT(AX6),AJ6<0,AF6,NOT(Y6),AG6)","v":false},{"$f":"AND(AX6,BA6<0)","v":false},{"$f":"AND(AF6,BA6>0,AV6>0)","v":true},{"$f":"AND(AY6,AV6>0)","v":false},{"$f":"NOT(AY6)","v":true},{"$f":"BA6<0","v":false},{"$f":"AND(AV6<0,AY6)","v":false},null,{"$f":"AV6-BF6","v":1246.6666666666665},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX6,AV5,AV6)","v":1680},{"$f":"AV5+BA6","v":1680},{"$f":"IF(AV6>0,1,0)","v":1},{"$f":"AV6*AV5<0","v":false},false,"Interest",100,{"$f":"AU6","v":1680},null,null,null,{"$f":"BF5","v":433.33333333333337},null,null,null,{"$f":"IF(AY6,BB6,BA6)","v":100},null,null,null,null,null,null,{"$f":"AZ6","v":"Interest"}," \n",{"$f":"BB6","v":1680},{"$f":"BQ6&BR6","v":"Interest \n"},{"$f":"S6","v":1580},{"$f":"T6","v":0},{"$f":"P6","v":100},{"$f":"O6","v":433.33333333333337},null,null,null,null,{"$f":"BB5","v":1580},{"$f":"BB6","v":1680}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U7,BF7,BF7,BF7,0,0,0,0,-BF7)","v":0},{"$f":"CHOOSE(U7,0,BA7,Q7,-BA7,-BA7,0,BA7,-BA7)","v":200},{"$f":"IF(AX7,BA7+R7,0)","v":0},{"$f":"AV6","v":1680},{"$f":"CHOOSE(U7,AV7,AV7-BA7,AV7-BA7,AV7,AV7-BF7,AV7,R7-T7,AV7)","v":1046.6666666666665},{"$f":"CHOOSE(U7,0,0,0,AV7-BF7,BF7,-BF7,-BF7,0)","v":433.33333333333337},{"$f":"AE7*1+AD7*2+AC7*3+AB7*4+AA7*5+Z7*6+Y7*7+X7*8","v":5},{"$f":"SUMPRODUCT(X7:AE7*1)","v":1},null,{"$f":"AND(AV7<0,BA7>0)","v":false},{"$f":"AND(BA7<0,AU7<0,NOT(AY7))","v":false},{"$f":"AH7","v":false},{"$f":"AND(AF7,NOT(AX7),NOT(AB7),NOT(AD7),AU7>0)","v":true},{"$f":"AND(NOT(AX7),AJ7<0,AF7,NOT(Y7),AG7)","v":false},{"$f":"AND(AX7,BA7<0)","v":false},{"$f":"AND(AF7,BA7>0,AV7>0)","v":false},{"$f":"AND(AY7,AV7>0)","v":false},{"$f":"NOT(AY7)","v":true},{"$f":"BA7<0","v":true},{"$f":"AND(AV7<0,AY7)","v":false},null,{"$f":"AV7-BF7","v":1046.6666666666665},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX7,AV6,AV7)","v":1480},{"$f":"AV6+BA7","v":1480},{"$f":"IF(AV7>0,1,0)","v":1},{"$f":"AV7*AV6<0","v":false},false,"Other Income",-200,{"$f":"AU7","v":1480},null,null,null,{"$f":"BF6","v":433.33333333333337},null,null,null,{"$f":"IF(AY7,BB7,BA7)","v":-200},null,null,null,null,null,null,{"$f":"AZ7","v":"Other Income"}," \n",{"$f":"BB7","v":1480},{"$f":"BQ7&BR7","v":"Other Income \n"},{"$f":"S7","v":1046.6666666666665},{"$f":"T7","v":433.33333333333337},{"$f":"P7","v":200},{"$f":"O7","v":0},null,null,null,null,null,{"$f":"BB6","v":1680},{"$f":"BB7","v":1480}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U8,BF8,BF8,BF8,0,0,0,0,-BF8)","v":433.33333333333337},{"$f":"CHOOSE(U8,0,BA8,Q8,-BA8,-BA8,0,BA8,-BA8)","v":80},{"$f":"IF(AX8,BA8+R8,0)","v":0},{"$f":"AV7","v":1480},{"$f":"CHOOSE(U8,AV8,AV8-BA8,AV8-BA8,AV8,AV8-BF8,AV8,R8-T8,AV8)","v":1480},{"$f":"CHOOSE(U8,0,0,0,AV8-BF8,BF8,-BF8,-BF8,0)","v":0},{"$f":"AE8*1+AD8*2+AC8*3+AB8*4+AA8*5+Z8*6+Y8*7+X8*8","v":2},{"$f":"SUMPRODUCT(X8:AE8*1)","v":1},null,{"$f":"AND(AV8<0,BA8>0)","v":false},{"$f":"AND(BA8<0,AU8<0,NOT(AY8))","v":false},{"$f":"AH8","v":false},{"$f":"AND(AF8,NOT(AX8),NOT(AB8),NOT(AD8),AU8>0)","v":false},{"$f":"AND(NOT(AX8),AJ8<0,AF8,NOT(Y8),AG8)","v":false},{"$f":"AND(AX8,BA8<0)","v":false},{"$f":"AND(AF8,BA8>0,AV8>0)","v":true},{"$f":"AND(AY8,AV8>0)","v":false},{"$f":"NOT(AY8)","v":true},{"$f":"BA8<0","v":false},{"$f":"AND(AV8<0,AY8)","v":false},null,{"$f":"AV8-BF8","v":1126.6666666666665},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX8,AV7,AV8)","v":1560},{"$f":"AV7+BA8","v":1560},{"$f":"IF(AV8>0,1,0)","v":1},{"$f":"AV8*AV7<0","v":false},false,"Taxes",80,{"$f":"AU8","v":1560},null,null,null,{"$f":"BF7","v":433.33333333333337},null,null,null,{"$f":"IF(AY8,BB8,BA8)","v":80},null,null,null,null,null,null,{"$f":"AZ8","v":"Taxes"}," \n",{"$f":"BB8","v":1560},{"$f":"BQ8&BR8","v":"Taxes \n"},{"$f":"S8","v":1480},{"$f":"T8","v":0},{"$f":"P8","v":80},{"$f":"O8","v":433.33333333333337},null,null,null,null,null,null,{"$f":"BB7","v":1480},{"$f":"BB8","v":1560}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U9,BF9,BF9,BF9,0,0,0,0,-BF9)","v":433.33333333333337},{"$f":"CHOOSE(U9,0,BA9,Q9,-BA9,-BA9,0,BA9,-BA9)","v":1E-4},{"$f":"IF(AX9,BA9+R9,0)","v":0},{"$f":"AV8","v":1560},{"$f":"CHOOSE(U9,AV9,AV9-BA9,AV9-BA9,AV9,AV9-BF9,AV9,R9-T9,AV9)","v":1560},{"$f":"CHOOSE(U9,0,0,0,AV9-BF9,BF9,-BF9,-BF9,0)","v":0},{"$f":"AE9*1+AD9*2+AC9*3+AB9*4+AA9*5+Z9*6+Y9*7+X9*8","v":2},{"$f":"SUMPRODUCT(X9:AE9*1)","v":1},null,{"$f":"AND(AV9<0,BA9>0)","v":false},{"$f":"AND(BA9<0,AU9<0,NOT(AY9))","v":false},{"$f":"AH9","v":false},{"$f":"AND(AF9,NOT(AX9),NOT(AB9),NOT(AD9),AU9>0)","v":false},{"$f":"AND(NOT(AX9),AJ9<0,AF9,NOT(Y9),AG9)","v":false},{"$f":"AND(AX9,BA9<0)","v":false},{"$f":"AND(AF9,BA9>0,AV9>0)","v":true},{"$f":"AND(AY9,AV9>0)","v":false},{"$f":"NOT(AY9)","v":true},{"$f":"BA9<0","v":false},{"$f":"AND(AV9<0,AY9)","v":false},null,{"$f":"AV9-BF9","v":1126.6667666666667},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX9,AV8,AV9)","v":1560.0001},{"$f":"AV8+BA9","v":1560.0001},{"$f":"IF(AV9>0,1,0)","v":1},{"$f":"AV9*AV8<0","v":false},false,"Adjustment",1E-4,{"$f":"AU9","v":1560.0001},null,null,null,{"$f":"BF8","v":433.33333333333337},null,null,null,{"$f":"IF(AY9,BB9,BA9)","v":1E-4},null,null,null,null,null,null,{"$f":"AZ9","v":"Adjustment"}," \n",{"$f":"BB9","v":1560.0001},{"$f":"BQ9&BR9","v":"Adjustment \n"},{"$f":"S9","v":1560},{"$f":"T9","v":0},{"$f":"P9","v":1E-4},{"$f":"O9","v":433.33333333333337},null,null,null,null,null,null,null,{"$f":"BB8","v":1560},{"$f":"BB9","v":1560.0001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(U10,BF10,BF10,BF10,0,0,0,0,-BF10)","v":433.33333333333337},{"$f":"CHOOSE(U10,0,BA10,Q10,-BA10,-BA10,0,BA10,-BA10)","v":0},{"$f":"IF(AX10,BA10+R10,0)","v":0},{"$f":"AV9","v":1560.0001},{"$f":"CHOOSE(U10,AV10,AV10-BA10,AV10-BA10,AV10,AV10-BF10,AV10,R10-T10,AV10)","v":1560.0001},{"$f":"CHOOSE(U10,0,0,0,AV10-BF10,BF10,-BF10,-BF10,0)","v":0},{"$f":"AE10*1+AD10*2+AC10*3+AB10*4+AA10*5+Z10*6+Y10*7+X10*8","v":1},{"$f":"SUMPRODUCT(X10:AE10*1)","v":1},null,{"$f":"AND(AV10<0,BA10>0)","v":false},{"$f":"AND(BA10<0,AU10<0,NOT(AY10))","v":false},{"$f":"AH10","v":false},{"$f":"AND(AF10,NOT(AX10),NOT(AB10),NOT(AD10),AU10>0)","v":false},{"$f":"AND(NOT(AX10),AJ10<0,AF10,NOT(Y10),AG10)","v":false},{"$f":"AND(AX10,BA10<0)","v":false},{"$f":"AND(AF10,BA10>0,AV10>0)","v":false},{"$f":"AND(AY10,AV10>0)","v":true},{"$f":"NOT(AY10)","v":false},{"$f":"BA10<0","v":false},{"$f":"AND(AV10<0,AY10)","v":false},null,{"$f":"AV10-BF10","v":1126.6667666666667},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AX10,AV9,AV10)","v":1560.0001},{"$f":"AV9+BA10","v":1560.0001},{"$f":"IF(AV10>0,1,0)","v":1},{"$f":"AV10*AV9<0","v":false},true,"End Point",0,{"$f":"AU10","v":1560.0001},null,null,null,{"$f":"BF9","v":433.33333333333337},null,null,null,{"$f":"IF(AY10,BB10,BA10)","v":1560.0001},null,null,null,null,null,null,{"$f":"AZ10","v":"End Point"}," \n",{"$f":"BB10","v":1560.0001},{"$f":"BQ10&BR10","v":"End Point \n"},{"$f":"S10","v":1560.0001},{"$f":"T10","v":0},{"$f":"P10","v":0},{"$f":"O10","v":433.33333333333337},null,null,null,null,null,null,null,null,{"$f":"BB9","v":1560.0001}]
[null,{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41},{"$f":"COLUMN()","v":42},{"$f":"COLUMN()","v":43},{"$f":"COLUMN()","v":44},{"$f":"COLUMN()","v":45},{"$f":"COLUMN()","v":46},{"$f":"COLUMN()","v":47},{"$f":"COLUMN()","v":48},{"$f":"COLUMN()","v":49},{"$f":"COLUMN()","v":50},{"$f":"COLUMN()","v":51},{"$f":"COLUMN()","v":52},{"$f":"COLUMN()","v":53},{"$f":"COLUMN()","v":54},{"$f":"COLUMN()","v":55},{"$f":"COLUMN()","v":56},{"$f":"COLUMN()","v":57},{"$f":"COLUMN()","v":58},{"$f":"COLUMN()","v":59},{"$f":"COLUMN()","v":60},{"$f":"COLUMN()","v":61},{"$f":"COLUMN()","v":62},{"$f":"COLUMN()","v":63},{"$f":"COLUMN()","v":64},{"$f":"COLUMN()","v":65},{"$f":"COLUMN()","v":66},{"$f":"COLUMN()","v":67},{"$f":"COLUMN()","v":68},{"$f":"COLUMN()","v":69},{"$f":"COLUMN()","v":70},{"$f":"COLUMN()","v":71},{"$f":"COLUMN()","v":72},{"$f":"COLUMN()","v":73},{"$f":"COLUMN()","v":74},{"$f":"COLUMN()","v":75},{"$f":"COLUMN()","v":76},{"$f":"COLUMN()","v":77},{"$f":"COLUMN()","v":78},{"$f":"COLUMN()","v":79},{"$f":"COLUMN()","v":80},{"$f":"COLUMN()","v":81},{"$f":"COLUMN()","v":82},{"$f":"COLUMN()","v":83},{"$f":"COLUMN()","v":84},{"$f":"COLUMN()","v":85},{"$f":"COLUMN()","v":86},{"$f":"COLUMN()","v":87},{"$f":"COLUMN()","v":88},{"$f":"COLUMN()","v":89},{"$f":"COLUMN()","v":90},{"$f":"COLUMN()","v":91},{"$f":"COLUMN()","v":92},{"$f":"COLUMN()","v":93},{"$f":"COLUMN()","v":94},{"$f":"COLUMN()","v":95},{"$f":"COLUMN()","v":96},{"$f":"COLUMN()","v":97},{"$f":"COLUMN()","v":98},{"$f":"COLUMN()","v":99},{"$f":"COLUMN()","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final ","Final ","Change ","Prior "," Final "," Final ","Code ","Sumproduct ",null,"Negative "," Negative "," Negative "," Negative "," Not "," Chg "," Pos "," Pos "," Not "," Neg "," Neg ",null," Label ",null,null,null,null,null,null,null,null,null,null," Cum "," Raw ",null," Chg "," Tot or "," Read "," Read "," Conect ",null,null,null," Label ",null,null,null," Label ",null,null,null,null,null,null,null,null,null," X "," Base "," Label "," Incr- "," Label "," Con- "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Positive ","Increment ","Sign ","Cumulative "," Base "," Neg  ","Number ","Test ",null,"Base "," Cumulative"," Cumulative "," Increment "," Enough "," Sign "," Incr "," Cum "," Tot or "," Incr "," Label ",null," Space ",null,null,null,null,null,null,null,null,null,null," Adj "," Cum ",null," Sign "," Sub "," Label "," Data "," Adj ",null,null,null," Input ",null,null,null," to Show ",null,null,null,null,null,null,null,null,null," Axis "," Bar "," Minus "," ment "," Plus "," nector "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Label "," ","Adjustment "," "," Bar "," Label "," "," ",null,"Pos Incr "," and Incr"," Switch "," Switch "," Space "," Negative "," Switch "," Switch "," Subtotal "," Switch "," Switch ",null," Avail "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Space ",null,null,null,null," Space ",null,null,null,"Cde 8"," Cde 7"," Cde 6 "," Cde 5 "," Cde 4 "," Cde 3 "," Cde 2 "," Cde 1 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Chart Title"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 - Cum "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2 - Cum - Incr "]