{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Home","Min Max","Waterfall 2007+","In-cell Charts"],"not_rendered":{"charts":11,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":150,"n_cols":19,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Other Resources",null,null,null,"Tutorials"]
[null,null,null,null,null,null,null,null,"Blog",null,null,null,"Excel Functions",null,null,"https://www.myonlinetraininghub.com/excel-functions"]
[null,null,null,null,null,null,null,null,"Free Training",null,null,null,"Charting Blog Posts",null,null,"http://www.myonlinetraininghub.com/category/excel-charts"]
[null,null,null,null,null,null,null,null,"Forum",null,null,null,"Excel Dashboard Blog Posts",null,null,"http://www.myonlinetraininghub.com/category/excel-dashboard"]
[]
[null,"Click this blue button to run the macro",null,null,null,null,null,null,"Our Courses",null,null,null,"Webinars"]
[null,null,null,null,null,null,null,null,"Excel Dashboards",null,null,null,"Excel Dashboards & Power BI",null,null,"http://www.myonlinetraininghub.com/excel-webinars"]
[null,null,null,null,null,null,null,null,"Power Query"]
[null,null,null,null,null,null,null,null,"Power Pivot"]
[null,null,null,null,null,null,null,null,"Pivot Tables"]
[null,null,null,null,null,null,null,null,"Excel Expert"]
[null,null,null,null,null,null,null,null,"Excel for Decision Making"]
[null,null,null,null,null,null,null,null,"Excel for Finance"]
[null,null,null,null,null,null,null,null,"Excel for Customer Service Professionals"]
[null,null,null,null,null,null,null,null,"Excel Analysis ToolPak"]
[]
[]
["Converging Stacked Bar Chart"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Question","Strongly Agree","Agree","Neutral","Disagree","Strongly Disagree"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q17",-0.25,-0.51,-0.17,0.01,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q16",-0.13,-0.57999999999999996,-0.16,0.04,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q15",-0.22,-0.52,-0.16,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q14",-0.22,-0.44,-0.2,0.04,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q13",-0.24,-0.49,-0.18,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q12",-0.22,-0.41,-0.22,0.04,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q11",-7.0000000000000007E-2,-0.2,-0.51,0.09,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q10",-0.19,-0.38,-0.22,0.08,0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q9",-0.08,-0.43,-0.31,0.04,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q8",-7.0000000000000007E-2,-0.53,-0.24,0.05,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q7",-0.06,-0.59,-0.17,0.08,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6",-0.12,-0.56999999999999995,-0.19,0.02,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q5",-7.0000000000000007E-2,-0.43,-0.33,0.02,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4",-0.09,-0.54,-0.2,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",-0.08,-0.41,-0.31,0.03,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2",-0.04,-0.44,-0.36,0.03,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",-0.15,-0.52,-0.14000000000000001,0.04,0.05]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Waterfall Chart - Excel 2007+"]
[]
[]
["Chart Data","P&L Values","Totals","Before","After"]
["Sales",1200000,{"$f":"B59","v":1200000}]
["Consulting",60000,null,{"$f":"SUM($B$5:B59)","v":1200000},{"$f":"SUM($B$5:B60)","v":1260000}]
["Total Sales",{"$f":"SUM(B59:B60)","v":1260000},{"$f":"B61","v":1260000}]
["Materials",{"$f":"-B59*0.2","v":-240000},null,{"$f":"SUM($B$7:B61)","v":2520000},{"$f":"SUM($B$7:B62)","v":2280000}]
["Direct Labour",-125000,null,{"$f":"SUM($B$7:B62)","v":2280000},{"$f":"SUM($B$7:B63)","v":2155000}]
["Freight",-13500,null,{"$f":"SUM($B$7:B63)","v":2155000},{"$f":"SUM($B$7:B64)","v":2141500}]
["Gross Profit",{"$f":"SUM(B61:B64)","v":881500},{"$f":"+B65","v":881500}]
["Legal & Accounting",-25000,null,{"$f":"SUM($B$11:B65)","v":3023000},{"$f":"SUM($B$11:B66)","v":2998000}]
["Wages",-240000,null,{"$f":"SUM($B$11:B66)","v":2998000},{"$f":"SUM($B$11:B67)","v":2758000}]
["Interest",-15000,null,{"$f":"SUM($B$11:B67)","v":2758000},{"$f":"SUM($B$11:B68)","v":2743000}]
["Repairs",-31000,null,{"$f":"SUM($B$11:B68)","v":2743000},{"$f":"SUM($B$11:B69)","v":2712000}]
["Telephone",-16000,null,{"$f":"SUM($B$11:B69)","v":2712000},{"$f":"SUM($B$11:B70)","v":2696000}]
["Utilities",-18000,null,{"$f":"SUM($B$11:B70)","v":2696000},{"$f":"SUM($B$11:B71)","v":2678000}]
["Vehicles",-42000,null,{"$f":"SUM($B$11:B71)","v":2678000},{"$f":"SUM($B$11:B72)","v":2636000}]
["Net Profit/(Loss)",{"$f":"SUM(B65:B72)","v":494500},{"$f":"B73","v":494500}]
[]
[]
[]
[]
[]
[]
[]
[]
["Excel Chart Label Min/Max"]
[]
["Line Charts"]
[]
["Year","Month","Sales","Max","Min"]
[2017,"J",72,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"F",61,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"M",92,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"A",88,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"M",80,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"J",97,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":97},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"J",89,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"A",90,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"S",95,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"O",87,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"N",65,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"D",56,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[2018,"J",71,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"F",78,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"M",52,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"A",64,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"M",58,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"J",74,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"J",82,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"A",50,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":50}]
[null,"S",73,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"O",87,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"N",56,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"D",52,{"$f":"IF(Table14[[#This Row],[Sales]]=MAX(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table14[[#This Row],[Sales]]=MIN(Table14[Sales]),Table14[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Column Charts"]
[]
["Year","Month","Sales","Max","Min"]
[2017,"J",72,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"F",61,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"M",92,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"A",88,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"M",80,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"J",97,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":97},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"J",89,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"A",90,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"S",95,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"O",87,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"N",65,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"D",56,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[2018,"J",71,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"F",78,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"M",52,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"A",64,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"M",58,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"J",74,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"J",82,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"A",50,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":50}]
[null,"S",73,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"O",87,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"N",56,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]
[null,"D",52,{"$f":"IF(Table135[[#This Row],[Sales]]=MAX(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table135[[#This Row],[Sales]]=MIN(Table135[Sales]),Table135[[#This Row],[Sales]],0)","v":0}]

{"sheet":"Min Max","index":1,"n_rows":64,"n_cols":5,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Excel Chart Label Min/Max"]
[]
["Line Charts"]
[]
["Year","Month","Sales","Max","Min"]
[2017,"J",72,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"F",61,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"M",92,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"A",88,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"M",80,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"J",97,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":97},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"J",89,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"A",90,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"S",95,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"O",87,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"N",65,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"D",56,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[2018,"J",71,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"F",78,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"M",52,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"A",64,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"M",58,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"J",74,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"J",82,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"A",50,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":50}]
[null,"S",73,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"O",87,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"N",56,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[null,"D",52,{"$f":"IF(Table1[[#This Row],[Sales]]=MAX(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(Table1[[#This Row],[Sales]]=MIN(Table1[Sales]),Table1[[#This Row],[Sales]],NA())","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
["Column Charts"]
[]
["Year","Month","Sales","Max","Min"]
[2017,"J",72,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"F",61,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"M",92,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"A",88,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"M",80,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"J",97,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":97},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"J",89,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"A",90,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"S",95,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"O",87,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"N",65,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"D",56,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[2018,"J",71,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"F",78,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"M",52,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"A",64,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"M",58,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"J",74,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"J",82,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"A",50,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":50}]
[null,"S",73,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"O",87,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"N",56,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]
[null,"D",52,{"$f":"IF(Table13[[#This Row],[Sales]]=MAX(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0},{"$f":"IF(Table13[[#This Row],[Sales]]=MIN(Table13[Sales]),Table13[[#This Row],[Sales]],0)","v":0}]

{"sheet":"Waterfall 2007+","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Waterfall Chart - Excel 2007+"]
[]
[]
["Chart Data","P&L Values","Totals","Before","After"]
["Sales",1200000,{"$f":"B5","v":1200000}]
["Consulting",60000,null,{"$f":"SUM($B$5:B5)","v":1200000},{"$f":"SUM($B$5:B6)","v":1260000}]
["Total Sales",{"$f":"SUM(B5:B6)","v":1260000},{"$f":"B7","v":1260000}]
["Materials",{"$f":"-B5*0.2","v":-240000},null,{"$f":"SUM($B$7:B7)","v":1260000},{"$f":"SUM($B$7:B8)","v":1020000}]
["Direct Labour",-125000,null,{"$f":"SUM($B$7:B8)","v":1020000},{"$f":"SUM($B$7:B9)","v":895000}]
["Freight",-13500,null,{"$f":"SUM($B$7:B9)","v":895000},{"$f":"SUM($B$7:B10)","v":881500}]
["Gross Profit",{"$f":"SUM(B7:B10)","v":881500},{"$f":"+B11","v":881500}]
["Legal & Accounting",-25000,null,{"$f":"SUM($B$11:B11)","v":881500},{"$f":"SUM($B$11:B12)","v":856500}]
["Wages",-240000,null,{"$f":"SUM($B$11:B12)","v":856500},{"$f":"SUM($B$11:B13)","v":616500}]
["Interest",-15000,null,{"$f":"SUM($B$11:B13)","v":616500},{"$f":"SUM($B$11:B14)","v":601500}]
["Repairs",-31000,null,{"$f":"SUM($B$11:B14)","v":601500},{"$f":"SUM($B$11:B15)","v":570500}]
["Telephone",-16000,null,{"$f":"SUM($B$11:B15)","v":570500},{"$f":"SUM($B$11:B16)","v":554500}]
["Utilities",-18000,null,{"$f":"SUM($B$11:B16)","v":554500},{"$f":"SUM($B$11:B17)","v":536500}]
["Vehicles",-42000,null,{"$f":"SUM($B$11:B17)","v":536500},{"$f":"SUM($B$11:B18)","v":494500}]
["Net Profit/(Loss)",{"$f":"SUM(B11:B18)","v":494500},{"$f":"B19","v":494500}]

{"sheet":"In-cell Charts","index":3,"n_rows":128,"n_cols":31,"rows_kept":128,"cut":false,"hidden":false,"merged":[[32,2,32,3],[32,10,32,11]]}
["Excel Charts for Survey Results"]
[]
[null,"Stacked Bar Charts - Not Good!"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: these charts omit the N/A responses and so the percentages will not add up to 100% for each question."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Question","Strongly Agree","Agree","Neutral","Disagree","Strongly Disagree","N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q17",0.25,0.51,0.17,0.01,0.02,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q16",0.13,0.57999999999999996,0.16,0.04,0.04,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q15",0.22,0.52,0.16,0.02,0.03,0.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q14",0.22,0.44,0.2,0.04,0.01,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q13",0.24,0.49,0.18,0.02,0.03,0.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q12",0.22,0.41,0.22,0.04,0.03,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q11",7.0000000000000007E-2,0.2,0.51,0.09,7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q10",0.19,0.38,0.22,0.08,0.06,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q9",0.08,0.43,0.31,0.04,0.03,0.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q8",7.0000000000000007E-2,0.53,0.24,0.05,0.04,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q7",0.06,0.59,0.17,0.08,0.03,0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6",0.12,0.56999999999999995,0.19,0.02,0.02,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q5",7.0000000000000007E-2,0.43,0.33,0.02,0.02,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4",0.09,0.54,0.2,0.02,0.03,0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",0.08,0.41,0.31,0.03,0.04,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2",0.04,0.44,0.36,0.03,0.03,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",0.15,0.52,0.14000000000000001,0.04,0.05,0.04]
[]
[]
[]
[]
[null,"In-cell Charts or Conditional Formatting Data Bars"]
[]
[null,"Question","Strongly Agree",null,"Agree",null,"Neutral",null,"Disagree",null,"Strongly Disagree",null,"N/A"]
[null,"Q1",0.15,{"$f":"REPT(\"|\",C34*100)","v":"|||||||||||||||"},0.52,{"$f":"REPT(\"|\",E34*100)","v":"||||||||||||||||||||||||||||||||||||||||||||||||||||"},0.14000000000000001,{"$f":"REPT(\"|\",G34*100)","v":"||||||||||||||"},0.04,{"$f":"REPT(\"|\",I34*100)","v":"||||"},0.05,{"$f":"REPT(\"|\",K34*100)","v":"|||||"},0.1,{"$f":"REPT(\"|\",M34*100)","v":"||||||||||"}]
[null,"Q2",0.04,"||||",0.44,"||||||||||||||||||||||||||||||||||||||||||||",0.36,"||||||||||||||||||||||||||||||||||||",0.03,"|||",0.03,"|||",0.1,"||||||||||"]
[null,"Q3",0.08,"||||||||",0.41,"|||||||||||||||||||||||||||||||||||||||||",0.31,"|||||||||||||||||||||||||||||||",0.03,"|||",0.04,"||||",0.13,"|||||||||||||"]
[null,"Q4",0.09,"|||||||||",0.54,"||||||||||||||||||||||||||||||||||||||||||||||||||||||",0.2,"||||||||||||||||||||",0.02,"||",0.03,"|||",0.12,"||||||||||||"]
[null,"Q5",7.0000000000000007E-2,"|||||||",0.43,"|||||||||||||||||||||||||||||||||||||||||||",0.33,"|||||||||||||||||||||||||||||||||",0.02,"||",0.02,"||",0.13,"|||||||||||||"]
[null,"Q6",0.12,"||||||||||||",0.56999999999999995,"||||||||||||||||||||||||||||||||||||||||||||||||||||||||",0.19,"|||||||||||||||||||",0.02,"||",0.02,"||",0.08,"||||||||"]
[null,"Q7",0.06,"||||||",0.59,"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||",0.17,"|||||||||||||||||",0.08,"||||||||",0.03,"|||",7.0000000000000007E-2,"|||||||"]
[null,"Q8",7.0000000000000007E-2,"|||||||",0.53,"|||||||||||||||||||||||||||||||||||||||||||||||||||||",0.24,"||||||||||||||||||||||||",0.05,"|||||",0.04,"||||",7.0000000000000007E-2,"|||||||"]
[null,"Q9",0.08,"||||||||",0.43,"|||||||||||||||||||||||||||||||||||||||||||",0.31,"|||||||||||||||||||||||||||||||",0.04,"||||",0.03,"|||",0.11,"|||||||||||"]
[null,"Q10",0.19,"|||||||||||||||||||",0.38,"||||||||||||||||||||||||||||||||||||||",0.22,"||||||||||||||||||||||",0.08,"||||||||",0.06,"||||||",7.0000000000000007E-2,"|||||||"]
[null,"Q11",7.0000000000000007E-2,"|||||||",0.2,"||||||||||||||||||||",0.51,"|||||||||||||||||||||||||||||||||||||||||||||||||||",0.09,"|||||||||",7.0000000000000007E-2,"|||||||",0.06,"||||||"]
[null,"Q12",0.22,"||||||||||||||||||||||",0.41,"|||||||||||||||||||||||||||||||||||||||||",0.22,"||||||||||||||||||||||",0.04,"||||",0.03,"|||",0.08,"||||||||"]
[null,"Q13",0.24,"||||||||||||||||||||||||",0.49,"|||||||||||||||||||||||||||||||||||||||||||||||||",0.18,"||||||||||||||||||",0.02,"||",0.03,"|||",0.04,"||||"]
[null,"Q14",0.22,"||||||||||||||||||||||",0.44,"||||||||||||||||||||||||||||||||||||||||||||",0.2,"||||||||||||||||||||",0.04,"||||",0.01,"|",0.09,"|||||||||"]
[null,"Q15",0.22,"||||||||||||||||||||||",0.52,"||||||||||||||||||||||||||||||||||||||||||||||||||||",0.16,"||||||||||||||||",0.02,"||",0.03,"|||",0.05,"|||||"]
[null,"Q16",0.13,"|||||||||||||",0.57999999999999996,"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||",0.16,"||||||||||||||||",0.04,"||||",0.04,"||||",0.05,"|||||"]
[null,"Q17",0.25,"|||||||||||||||||||||||||",0.51,"|||||||||||||||||||||||||||||||||||||||||||||||||||",0.17,"|||||||||||||||||",0.01,"|",0.02,"||",0.04,"||||"]
[]
[null,"Converging Stacked Bar Chart"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Question","Strongly Agree","Agree","Neutral","Disagree","Strongly Disagree"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q17",-0.25,-0.51,-0.17,0.01,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q16",-0.13,-0.57999999999999996,-0.16,0.04,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q15",-0.22,-0.52,-0.16,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q14",-0.22,-0.44,-0.2,0.04,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q13",-0.24,-0.49,-0.18,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q12",-0.22,-0.41,-0.22,0.04,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q11",-7.0000000000000007E-2,-0.2,-0.51,0.09,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q10",-0.19,-0.38,-0.22,0.08,0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q9",-0.08,-0.43,-0.31,0.04,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q8",-7.0000000000000007E-2,-0.53,-0.24,0.05,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q7",-0.06,-0.59,-0.17,0.08,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6",-0.12,-0.56999999999999995,-0.19,0.02,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q5",-7.0000000000000007E-2,-0.43,-0.33,0.02,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4",-0.09,-0.54,-0.2,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",-0.08,-0.41,-0.31,0.03,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2",-0.04,-0.44,-0.36,0.03,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",-0.15,-0.52,-0.14000000000000001,0.04,0.05]
[]
[]
[]
[]
[]
[]
[null,"Sorted Converging Stacked Bar Chart"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Question","Strongly Agree","Agree","Neutral","Disagree","Strongly Disagree"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q14",-0.22,-0.44,-0.2,0.04,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q17",-0.25,-0.51,-0.17,0.01,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6",-0.12,-0.56999999999999995,-0.19,0.02,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q5",-7.0000000000000007E-2,-0.43,-0.33,0.02,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q15",-0.22,-0.52,-0.16,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q13",-0.24,-0.49,-0.18,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q12",-0.22,-0.41,-0.22,0.04,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q9",-0.08,-0.43,-0.31,0.04,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q7",-0.06,-0.59,-0.17,0.08,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4",-0.09,-0.54,-0.2,0.02,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2",-0.04,-0.44,-0.36,0.03,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q16",-0.13,-0.57999999999999996,-0.16,0.04,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q8",-7.0000000000000007E-2,-0.53,-0.24,0.05,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",-0.08,-0.41,-0.31,0.03,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",-0.15,-0.52,-0.14000000000000001,0.04,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q10",-0.19,-0.38,-0.22,0.08,0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q11",-7.0000000000000007E-2,-0.2,-0.51,0.09,7.0000000000000007E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Custom Sorted Converging Stacked Bar Chart"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(W110=3,6,W110)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q. Number","Strongly Agree","Agree","Neutral","Disagree","Strongly Disagree",null,"Rank",null,null,"Question","Strongly Agree","Agree","Neutral","Disagree","Strongly Disagree"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($Y$112:$Y$128,MATCH($Z112,$W$112:$W$128,0))","v":"Q1"},{"$f":"-INDEX(AA$112:AA$128,MATCH($Z112,$W$112:$W$128,0))","v":-0.249889},{"$f":"-INDEX(AB$112:AB$128,MATCH($Z112,$W$112:$W$128,0))","v":-0.50988900000000004},{"$f":"-INDEX(AC$112:AC$128,MATCH($Z112,$W$112:$W$128,0))","v":-0.16988900000000001},{"$f":"INDEX(AD$112:AD$128,MATCH($Z112,$W$112:$W$128,0))","v":1.0111E-2},2.0111E-2,null,{"$f":"RANK(CHOOSE($X$110,Z112,AA112,AB112,AC112,AD112,AE112),OFFSET($Y$112,,$X$110,17,1),CHOOSE($W$110,1,0,0))","v":1},null,"Q1",1,0.249889,0.50988900000000004,0.16988900000000001,1.0111E-2,2.0111E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($Y$112:$Y$128,MATCH($Z113,$W$112:$W$128,0))","v":"Q2"},{"$f":"-INDEX(AA$112:AA$128,MATCH($Z113,$W$112:$W$128,0))","v":-0.12987899999999999},-0.57987899999999992,-0.15987899999999999,4.0121000000000004E-2,4.0121000000000004E-2,null,{"$f":"RANK(CHOOSE($X$110,Z113,AA113,AB113,AC113,AD113,AE113),OFFSET($Y$112,,$X$110,17,1),CHOOSE($W$110,1,0,0))","v":2},null,"Q2",2,0.12987899999999999,0.57987899999999992,0.15987899999999999,4.0121000000000004E-2,4.0121000000000004E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",-0.219886,-0.51988600000000007,-0.159886,2.0114E-2,3.0113999999999998E-2,null,3,null,"Q3",3,0.219886,0.51988600000000007,0.159886,2.0114E-2,3.0113999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4",-0.21989,-0.43989,-0.19989000000000001,4.011E-2,1.0110000000000001E-2,null,4,null,"Q4",4,0.21989,0.43989,0.19989000000000001,4.011E-2,1.0110000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q5",-0.23988499999999999,-0.48988500000000001,-0.17988499999999999,2.0115000000000001E-2,3.0114999999999999E-2,null,5,null,"Q5",5,0.23988499999999999,0.48988500000000001,0.17988499999999999,2.0115000000000001E-2,3.0114999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6",-0.219884,-0.40988399999999997,-0.219884,4.0115999999999999E-2,3.0116E-2,null,6,null,"Q6",6,0.219884,0.40988399999999997,0.219884,4.0115999999999999E-2,3.0116E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q7",-6.9874000000000006E-2,-0.19987400000000002,-0.50987400000000005,9.0125999999999998E-2,7.0126000000000008E-2,null,7,null,"Q7",7,6.9874000000000006E-2,0.19987400000000002,0.50987400000000005,9.0125999999999998E-2,7.0126000000000008E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q8",-0.18987500000000002,-0.37987500000000002,-0.21987500000000001,8.0125000000000002E-2,6.0124999999999998E-2,null,8,null,"Q8",8,0.18987500000000002,0.37987500000000002,0.21987500000000001,8.0125000000000002E-2,6.0124999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q9",-7.9882999999999996E-2,-0.42988300000000002,-0.30988300000000002,4.0117E-2,3.0116999999999998E-2,null,9,null,"Q9",9,7.9882999999999996E-2,0.42988300000000002,0.30988300000000002,4.0117E-2,3.0116999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q10",-6.987800000000001E-2,-0.52987800000000007,-0.23987799999999998,5.0122E-2,4.0121999999999998E-2,null,10,null,"Q10",10,6.987800000000001E-2,0.52987800000000007,0.23987799999999998,5.0122E-2,4.0121999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q11",-5.9881999999999998E-2,-0.58988200000000002,-0.16988200000000001,8.0117999999999995E-2,3.0117999999999999E-2,null,11,null,"Q11",11,5.9881999999999998E-2,0.58988200000000002,0.16988200000000001,8.0117999999999995E-2,3.0117999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q12",-0.11988799999999999,-0.56988799999999995,-0.189888,2.0112000000000001E-2,2.0112000000000001E-2,null,12,null,"Q12",12,0.11988799999999999,0.56988799999999995,0.189888,2.0112000000000001E-2,2.0112000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q13",-6.9887000000000005E-2,-0.42988700000000002,-0.32988700000000004,2.0112999999999999E-2,2.0112999999999999E-2,null,13,null,"Q13",13,6.9887000000000005E-2,0.42988700000000002,0.32988700000000004,2.0112999999999999E-2,2.0112999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q14",-8.9881000000000003E-2,-0.53988100000000006,-0.199881,2.0119000000000001E-2,3.0119E-2,null,14,null,"Q14",14,8.9881000000000003E-2,0.53988100000000006,0.199881,2.0119000000000001E-2,3.0119E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q15",-7.9877000000000004E-2,-0.40987699999999999,-0.30987700000000001,3.0123E-2,4.0122999999999999E-2,null,15,null,"Q15",15,7.9877000000000004E-2,0.40987699999999999,0.30987700000000001,3.0123E-2,4.0122999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q16",-3.9879999999999999E-2,-0.43987999999999999,-0.35987999999999998,3.0119999999999997E-2,3.0119999999999997E-2,null,16,null,"Q16",16,3.9879999999999999E-2,0.43987999999999999,0.35987999999999998,3.0119999999999997E-2,3.0119999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q17",-0.14987599999999998,-0.519876,-0.139876,4.0124E-2,5.0124000000000002E-2,null,17,null,"Q17",17,0.14987599999999998,0.519876,0.139876,4.0124E-2,5.0124000000000002E-2]