{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Timing","Vertical Raincloud - 1 Cloud","Vertical Raincloud - 3 Clouds","Error Checks","Change Log"],"not_rendered":{"charts":11,"images":1,"macros":1,"external_links":0,"defined_names":83,"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":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"SumProduct Pty Limited"}]
[null,null,{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Sam Ngo"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Vertical Raincloud Chart"]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"Sam.Ngo@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,{"$f":"Overall_Error_Check","v":0}]
[]
[]
[null,1,"Table of Contents"]
[]
[null,null,null,null,null,"Cover"]
[null,null,null,null,null,"Style Guide"]
[null,null,null,null,null,"Model Parameters"]
[null,null,null,null,null,"Timing"]
[null,null,null,null,null,"Vertical Raincloud - 1 Cloud"]
[null,null,null,null,null,"Vertical Raincloud - 3 Clouds"]
[null,null,null,null,null,"Error Checks"]
[null,null,null,null,null,"Change Log"]

{"sheet":"Style Guide","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[16,2,16,6],[2,0,2,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Style Guide"}]
[{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Formatting of Headers / Dividers"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Sheet Title",null,null,null,null,null,{"$f":"C10","v":"Sheet Title"},null,"Sheet Title"]
[null,null,"Model Name",null,null,null,null,null,{"$f":"C11","v":"Model Name"},null,"Model Name"]
[]
[null,null,"Header 1",null,null,null,null,null,{"$f":"C13","v":"Header 1"},null,"Header 1"]
[null,null,"Header 2",null,null,null,null,null,{"$f":"C14","v":"Header 2"},null,"Header 2"]
[null,null,"Header 3",null,null,null,null,null,{"$f":"C15","v":"Header 3"},null,"Header 3"]
[null,null,"Header 4",null,null,null,null,null,{"$f":"C16","v":"Header 4"},null,"Header 4"]
[]
[null,null,"Notes",null,null,null,null,null,{"$f":"C18","v":"Notes"},null,"Notes"]
[]
[null,null,"Table Heading",null,null,null,null,null,{"$f":"C20","v":"Table Heading"},null,"Table Heading"]
[]
[]
[null,{"$f":"MAX($B$5:$B22)+1","v":2},"Individual Cell Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Assumption",null,null,null,null,null,"Assumption",null,{"$f":"C27","v":"Assumption"}]
[]
[null,null,"Constraint",null,null,null,null,null,{"$f":"C29","v":"Constraint"},null,{"$f":"C29","v":"Constraint"}]
[]
[null,null,"Empty",null,null,null,null,null,null,null,{"$f":"C31","v":"Empty"}]
[]
[null,null,"Error Check",null,null,null,null,null,0,null,{"$f":"C33","v":"Error Check"}]
[]
[null,null,"Hyperlink",null,null,null,null,null,"Hyperlink",null,{"$f":"C35","v":"Hyperlink"}]
[]
[null,null,"Internal Reference",null,null,null,null,null,{"$f":"'Error Checks'!E12","v":"Example"},null,{"$f":"C37","v":"Internal Reference"}]
[]
[null,null,"Line Calculation",null,null,null,null,null,77,null,"Line Calc"]
[]
[null,null,"Line Total",null,null,null,null,null,{"$f":"I39","v":77},null,{"$f":"C41","v":"Line Total"}]
[]
[null,null,"Parameter",null,null,null,null,null,365,null,{"$f":"C43","v":"Parameter"}]
[]
[null,null,"Range Name Description",null,null,null,null,null,"Not_Named",null,{"$f":"C45","v":"Range Name Description"}]
[]
[null,null,"Row Reference",null,null,null,null,null,{"$f":"ROW(C47)","v":47},null,"Row Ref"]
[]
[null,null,"Row Summary",null,null,null,null,null,{"$f":"I41","v":77},null,{"$f":"C49","v":"Row Summary"}]
[]
[null,null,"Units",null,null,null,null,null,"A$",null,{"$f":"C51","v":"Units"}]
[]
[null,null,"WIP",null,null,null,null,null,null,null,{"$f":"C53","v":"WIP"}]
[]
[]
[null,{"$f":"MAX($B$5:$B55)+1","v":3},"Numerical Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Comma",null,null,null,null,null,123456.789,null,{"$f":"C60","v":"Comma"}]
[]
[null,null,"Comma [0]",null,null,null,null,null,-123456.789,null,"Comma [0]"]
[]
[null,null,"Currency",null,null,null,null,null,123456.789,null,"Currency"]
[]
[null,null,"Currency [0]",null,null,null,null,null,123456.789,null,"Currency [0]"]
[]
[null,null,"Date",null,null,null,null,null,{"$f":"TODAY()","v":"2024-01-09"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2024-01-09"},null,{"$f":"C70","v":"Date Heading"}]
[]
[null,null,"Numbers 0",null,null,null,null,null,-123456.789,null,{"$f":"C72","v":"Numbers 0"}]
[]
[null,null,"Percent",null,null,null,null,null,0.5,null,{"$f":"C74","v":"Percent"}]

{"sheet":"Model Parameters","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4],[10,6,10,13],[11,6,11,13]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Model Parameters"}]
[{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"General"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[null,null,null,null,"Model Name",null,{"$f":"IF(ISERROR(OR(FIND(\"[\",CELL(\"filename\",A1)),FIND(\"]\",CELL(\"filename\",A1)))),\"\",MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1))","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct Pty Limited"]
[]
[]
[null,{"$f":"MAX($B$5:$B14)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365]
[null,null,null,null,"Months in Month",null,1]
[null,null,null,null,"Months in Quarter",null,3]
[null,null,null,null,"Months in Half Yr",null,6]
[null,null,null,null,"Months in Year",null,12]
[null,null,null,null,"Quarters in Year",null,4]
[]
[null,null,null,null,"Rounding Accuracy",null,5]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98]
[null,null,null,null,"Very Small Number",null,1E-8]
[]
[null,null,null,null,"Thousand",null,1000]

{"sheet":"Timing","index":4,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Timing"}]
[{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J$7","v":"2024-03-31"},{"$f":"K$7","v":"2024-06-30"},{"$f":"L$7","v":"2024-09-30"},{"$f":"M$7","v":"2024-12-31"},{"$f":"N$7","v":"2025-03-31"}]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2024-01-09"},{"$f":"IF(K$9=1,Model_Start_Date,J$7+1)","v":"2024-04-01"},{"$f":"IF(L$9=1,Model_Start_Date,K$7+1)","v":"2024-07-01"},{"$f":"IF(M$9=1,Model_Start_Date,L$7+1)","v":"2024-10-01"},{"$f":"IF(N$9=1,Model_Start_Date,M$7+1)","v":"2025-01-01"}]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"EOMONTH(J$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(J$6),Periodicity))","v":"2024-03-31"},{"$f":"EOMONTH(K$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(K$6),Periodicity))","v":"2024-06-30"},{"$f":"EOMONTH(L$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(L$6),Periodicity))","v":"2024-09-30"},{"$f":"EOMONTH(M$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(M$6),Periodicity))","v":"2024-12-31"},{"$f":"EOMONTH(N$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(N$6),Periodicity))","v":"2025-03-31"}]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":83},{"$f":"K7-K6+1","v":91},92,92,90]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"N(I$9)+1","v":1},{"$f":"N(J$9)+1","v":2},3,4,5]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Timing Assumptions"]
[]
[null,null,"Data (do not change once modelling has commenced)"]
[]
[null,null,null,"Model Start Date",null,null,null,{"$f":"TODAY()","v":"2024-01-09"}]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,3]
[]
[null,null,null,"Example Reporting Month",null,null,null,12,{"$f":"\"e.g. \"&TEXT(DATE(YEAR(Model_Start_Date)+IF(Example_Reporting_Month<MONTH(Model_Start_Date),1,0),Example_Reporting_Month+1,1)-1,\"dd-Mmm-yy\")","v":"e.g. 31-Dec-24"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":3}]

{"sheet":"Vertical Raincloud - 1 Cloud","index":5,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Vertical Raincloud - 1 Cloud"}]
[{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Vertical Raincloud Chart"]
[]
[]
[null,null,null,"Cloud 1","Cloud 1: 1st position","Cloud 1: X-position","Cloud 1: Distribution",null,"Location",1.5]
[null,null,null,27,{"$f":"COUNTIF(D$10:D10,D10)","v":1},{"$f":"IF(E10=1,J$9,F9+J$10)","v":1.5},{"$f":"Cloud[[#This Row],[Cloud 1]]","v":27},null,"Length",0.1]
[null,null,null,18,{"$f":"COUNTIF(D$10:D11,D11)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":18}]
[null,null,null,95,{"$f":"COUNTIF(D$10:D12,D12)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":95},null,"Percentile","Percentile: Cloud 1"]
[null,null,null,90,{"$f":"COUNTIF(D$10:D13,D13)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":90},null,0,{"$f":"PERCENTILE(Cloud[Cloud 1],$I13)","v":1}]
[null,null,null,53,{"$f":"COUNTIF(D$10:D14,D14)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":53},null,0.1,{"$f":"PERCENTILE(Cloud[Cloud 1],$I14)","v":11.9}]
[null,null,null,17,{"$f":"COUNTIF(D$10:D15,D15)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":17},null,0.25,{"$f":"PERCENTILE(Cloud[Cloud 1],$I15)","v":20.5}]
[null,null,null,92,{"$f":"COUNTIF(D$10:D16,D16)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":92},null,0.5,{"$f":"PERCENTILE(Cloud[Cloud 1],$I16)","v":43.5}]
[null,null,null,93,{"$f":"COUNTIF(D$10:D17,D17)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":93},null,0.75,{"$f":"PERCENTILE(Cloud[Cloud 1],$I17)","v":64.75}]
[null,null,null,18,{"$f":"COUNTIF(D$10:D18,D18)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":18},null,0.9,{"$f":"PERCENTILE(Cloud[Cloud 1],$I18)","v":90}]
[null,null,null,15,{"$f":"COUNTIF(D$10:D19,D19)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":15},null,1,{"$f":"PERCENTILE(Cloud[Cloud 1],$I19)","v":99}]
[null,null,null,31,{"$f":"COUNTIF(D$10:D20,D20)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":31}]
[null,null,null,9,{"$f":"COUNTIF(D$10:D21,D21)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":9},null,"Stacked Column","Stacked: Cloud 1"]
[null,null,null,27,{"$f":"COUNTIF(D$10:D22,D22)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":27},null,"Base 25th",{"$f":"J15","v":20.5}]
[null,null,null,29,{"$f":"COUNTIF(D$10:D23,D23)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":29},null,"Bottom 25-50",{"$f":"J16-J15","v":23}]
[null,null,null,70,{"$f":"COUNTIF(D$10:D24,D24)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":70},null,"Top 50-75",{"$f":"J17-J16","v":21.25}]
[null,null,null,12,{"$f":"COUNTIF(D$10:D25,D25)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":12}]
[null,null,null,43,{"$f":"COUNTIF(D$10:D26,D26)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":43},null,"x",1]
[null,null,null,39,{"$f":"COUNTIF(D$10:D27,D27)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":39},null,"y",{"$f":"J16","v":43.5}]
[null,null,null,53,{"$f":"COUNTIF(D$10:D28,D28)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":53}]
[null,null,null,68,{"$f":"COUNTIF(D$10:D29,D29)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":68},null,"Error Bar Length"]
[null,null,null,60,{"$f":"COUNTIF(D$10:D30,D30)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":60},null,"Positive",{"$f":"-J16+J18","v":46.5}]
[null,null,null,8,{"$f":"COUNTIF(D$10:D31,D31)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":8},null,"Negative",{"$f":"J16-J14","v":31.6}]
[null,null,null,8,{"$f":"COUNTIF(D$10:D32,D32)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":8}]
[null,null,null,31,{"$f":"COUNTIF(D$10:D33,D33)","v":2},1.7000000000000002,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":31}]
[null,null,null,19,{"$f":"COUNTIF(D$10:D34,D34)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":19}]
[null,null,null,56,{"$f":"COUNTIF(D$10:D35,D35)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":56}]
[null,null,null,67,{"$f":"COUNTIF(D$10:D36,D36)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":67}]
[null,null,null,90,{"$f":"COUNTIF(D$10:D37,D37)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":90}]
[null,null,null,28,{"$f":"COUNTIF(D$10:D38,D38)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":28}]
[null,null,null,11,{"$f":"COUNTIF(D$10:D39,D39)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":11}]
[null,null,null,62,{"$f":"COUNTIF(D$10:D40,D40)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":62}]
[null,null,null,50,{"$f":"COUNTIF(D$10:D41,D41)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":50}]
[null,null,null,48,{"$f":"COUNTIF(D$10:D42,D42)","v":1},{"$f":"IF(E42=1,J$9,F41+J$10)","v":1.5},{"$f":"Cloud[[#This Row],[Cloud 1]]","v":48}]
[null,null,null,21,{"$f":"COUNTIF(D$10:D43,D43)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":21}]
[null,null,null,51,{"$f":"COUNTIF(D$10:D44,D44)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":51}]
[null,null,null,33,{"$f":"COUNTIF(D$10:D45,D45)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":33}]
[null,null,null,13,{"$f":"COUNTIF(D$10:D46,D46)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":13}]
[null,null,null,63,{"$f":"COUNTIF(D$10:D47,D47)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":63}]
[null,null,null,73,{"$f":"COUNTIF(D$10:D48,D48)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":73}]
[null,null,null,99,{"$f":"COUNTIF(D$10:D49,D49)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":99}]
[null,null,null,38,{"$f":"COUNTIF(D$10:D50,D50)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":38}]
[null,null,null,67,{"$f":"COUNTIF(D$10:D51,D51)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":67}]
[null,null,null,1,{"$f":"COUNTIF(D$10:D52,D52)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":1}]
[null,null,null,68,{"$f":"COUNTIF(D$10:D53,D53)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":68}]
[null,null,null,12,{"$f":"COUNTIF(D$10:D54,D54)","v":2},1.7000000000000002,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":12}]
[null,null,null,10,{"$f":"COUNTIF(D$10:D55,D55)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":10}]
[null,null,null,92,{"$f":"COUNTIF(D$10:D56,D56)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":92}]
[null,null,null,68,{"$f":"COUNTIF(D$10:D57,D57)","v":3},1.7000000000000002,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":68}]
[null,null,null,29,{"$f":"COUNTIF(D$10:D58,D58)","v":2},1.8000000000000003,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":29}]
[null,null,null,31,{"$f":"COUNTIF(D$10:D59,D59)","v":3},1.9000000000000004,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":31}]
[null,null,null,34,{"$f":"COUNTIF(D$10:D60,D60)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":34}]
[null,null,null,12,{"$f":"COUNTIF(D$10:D61,D61)","v":3},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":12}]
[null,null,null,78,{"$f":"COUNTIF(D$10:D62,D62)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":78}]
[null,null,null,28,{"$f":"COUNTIF(D$10:D63,D63)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":28}]
[null,null,null,64,{"$f":"COUNTIF(D$10:D64,D64)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":64}]
[null,null,null,60,{"$f":"COUNTIF(D$10:D69,D65)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":60}]
[null,null,null,56,{"$f":"COUNTIF(D$10:D66,D66)","v":2},1.7000000000000002,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":56}]
[null,null,null,52,{"$f":"COUNTIF(D$10:D67,D67)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":52}]
[null,null,null,48,{"$f":"COUNTIF(D$10:D68,D68)","v":2},1.6,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":48}]
[null,null,null,44,{"$f":"COUNTIF(D$10:D69,D69)","v":1},1.5,{"$f":"Cloud[[#This Row],[Cloud 1]]","v":44}]

{"sheet":"Vertical Raincloud - 3 Clouds","index":6,"n_rows":69,"n_cols":20,"rows_kept":69,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Vertical Raincloud - 3 Clouds"}]
[{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Vertical Raincloud Chart"]
[]
[]
[null,null,null,"Cloud 1","Cloud 2","Cloud 3","Cloud 1: 1st position","Cloud 2: 1st position","Cloud 3: 1st position","Cloud 1: X-position","Cloud 2: X-position","Cloud 3: X-position","Cloud 1: Distribution","Cloud 2: Distribution","Cloud 3: Distribution",null,"Location",1.5,2.5,3.5]
[null,null,null,12,181,204,{"$f":"COUNTIF(D$10:D10,D10)","v":1},{"$f":"COUNTIF(E$10:E10,E10)","v":1},{"$f":"COUNTIF(F$10:F10,F10)","v":1},{"$f":"IF(G10=1,R$9,J9+R$10)","v":1.5},{"$f":"IF(H10=1,S$9,K9+S$10)","v":2.5},{"$f":"IF(I10=1,T$9,L9+T$10)","v":3.5},{"$f":"Clouds[[#This Row],[Cloud 1]]","v":12},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":181},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":204},null,"Length",0.1,0.1,0.1]
[null,null,null,99,149,206,{"$f":"COUNTIF(D$10:D11,D11)","v":1},{"$f":"COUNTIF(E$10:E11,E11)","v":1},{"$f":"COUNTIF(F$10:F11,F11)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":99},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":149},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":206}]
[null,null,null,52,164,206,{"$f":"COUNTIF(D$10:D12,D12)","v":1},{"$f":"COUNTIF(E$10:E12,E12)","v":1},{"$f":"COUNTIF(F$10:F12,F12)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":52},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":164},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":206},null,"Percentile","Percentile: Cloud 1","Percentile: Cloud 2","Percentile: Cloud 3"]
[null,null,null,28,182,206,{"$f":"COUNTIF(D$10:D13,D13)","v":1},{"$f":"COUNTIF(E$10:E13,E13)","v":1},{"$f":"COUNTIF(F$10:F13,F13)","v":3},1.5,2.5,3.7,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":28},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":182},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":206},null,0,{"$f":"PERCENTILE(Clouds[Cloud 1],$Q13)","v":1},{"$f":"PERCENTILE(Clouds[Cloud 2],$Q13)","v":102},{"$f":"PERCENTILE(Clouds[Cloud 3],$Q13)","v":204}]
[null,null,null,38,127,208,{"$f":"COUNTIF(D$10:D14,D14)","v":1},{"$f":"COUNTIF(E$10:E14,E14)","v":1},{"$f":"COUNTIF(F$10:F14,F14)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":38},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":127},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":208},null,0.1,{"$f":"PERCENTILE(Clouds[Cloud 1],$Q14)","v":11.9},{"$f":"PERCENTILE(Clouds[Cloud 2],$Q14)","v":112.8},{"$f":"PERCENTILE(Clouds[Cloud 3],$Q14)","v":210.8}]
[null,null,null,50,118,209,{"$f":"COUNTIF(D$10:D15,D15)","v":1},{"$f":"COUNTIF(E$10:E15,E15)","v":1},{"$f":"COUNTIF(F$10:F15,F15)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":50},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":118},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":209},null,0.25,{"$f":"PERCENTILE(Clouds[Cloud 1],$Q15)","v":20.5},{"$f":"PERCENTILE(Clouds[Cloud 2],$Q15)","v":123.75},{"$f":"PERCENTILE(Clouds[Cloud 3],$Q15)","v":223}]
[null,null,null,67,147,211,{"$f":"COUNTIF(D$10:D16,D16)","v":1},{"$f":"COUNTIF(E$10:E16,E16)","v":1},{"$f":"COUNTIF(F$10:F16,F16)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":67},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":147},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":211},null,0.5,{"$f":"PERCENTILE(Clouds[Cloud 1],$Q16)","v":43.5},{"$f":"PERCENTILE(Clouds[Cloud 2],$Q16)","v":155},{"$f":"PERCENTILE(Clouds[Cloud 3],$Q16)","v":250}]
[null,null,null,48,197,211,{"$f":"COUNTIF(D$10:D17,D17)","v":1},{"$f":"COUNTIF(E$10:E17,E17)","v":1},{"$f":"COUNTIF(F$10:F17,F17)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":48},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":197},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":211},null,0.75,{"$f":"PERCENTILE(Clouds[Cloud 1],$Q17)","v":64.75},{"$f":"PERCENTILE(Clouds[Cloud 2],$Q17)","v":182},{"$f":"PERCENTILE(Clouds[Cloud 3],$Q17)","v":272.5}]
[null,null,null,33,160,213,{"$f":"COUNTIF(D$10:D18,D18)","v":1},{"$f":"COUNTIF(E$10:E18,E18)","v":1},{"$f":"COUNTIF(F$10:F18,F18)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":33},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":160},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":213},null,0.9,{"$f":"PERCENTILE(Clouds[Cloud 1],$Q18)","v":90},{"$f":"PERCENTILE(Clouds[Cloud 2],$Q18)","v":191.1},{"$f":"PERCENTILE(Clouds[Cloud 3],$Q18)","v":290.2}]
[null,null,null,29,107,216,{"$f":"COUNTIF(D$10:D19,D19)","v":1},{"$f":"COUNTIF(E$10:E19,E19)","v":1},{"$f":"COUNTIF(F$10:F19,F19)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":29},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":107},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":216},null,1,{"$f":"PERCENTILE(Clouds[Cloud 1],$Q19)","v":99},{"$f":"PERCENTILE(Clouds[Cloud 2],$Q19)","v":200},{"$f":"PERCENTILE(Clouds[Cloud 3],$Q19)","v":298}]
[null,null,null,34,167,216,{"$f":"COUNTIF(D$10:D20,D20)","v":1},{"$f":"COUNTIF(E$10:E20,E20)","v":1},{"$f":"COUNTIF(F$10:F20,F20)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":34},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":167},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":216}]
[null,null,null,68,153,217,{"$f":"COUNTIF(D$10:D21,D21)","v":1},{"$f":"COUNTIF(E$10:E21,E21)","v":1},{"$f":"COUNTIF(F$10:F21,F21)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":68},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":153},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":217},null,"Stacked Column","Stacked: Cloud 1","Stacked: Cloud 2","Stacked: Cloud 3"]
[null,null,null,62,184,217,{"$f":"COUNTIF(D$10:D22,D22)","v":1},{"$f":"COUNTIF(E$10:E22,E22)","v":1},{"$f":"COUNTIF(F$10:F22,F22)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":62},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":184},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":217},null,"Base 25th",{"$f":"R15","v":20.5},{"$f":"S15","v":123.75},223]
[null,null,null,64,196,218,{"$f":"COUNTIF(D$10:D23,D23)","v":1},{"$f":"COUNTIF(E$10:E23,E23)","v":1},{"$f":"COUNTIF(F$10:F23,F23)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":64},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":196},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":218},null,"Bottom 25-50",{"$f":"R16-R15","v":23},{"$f":"S16-S15","v":31.25},27]
[null,null,null,92,102,223,{"$f":"COUNTIF(D$10:D24,D24)","v":1},{"$f":"COUNTIF(E$10:E24,E24)","v":1},{"$f":"COUNTIF(F$10:F24,F24)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":92},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":102},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":223},null,"Top 50-75",{"$f":"R17-R16","v":21.25},{"$f":"S17-S16","v":27},22.5]
[null,null,null,8,118,223,{"$f":"COUNTIF(D$10:D25,D25)","v":1},{"$f":"COUNTIF(E$10:E25,E25)","v":2},{"$f":"COUNTIF(F$10:F25,F25)","v":2},1.5,2.6,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":8},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":118},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":223}]
[null,null,null,60,191,224,{"$f":"COUNTIF(D$10:D26,D26)","v":1},{"$f":"COUNTIF(E$10:E26,E26)","v":1},{"$f":"COUNTIF(F$10:F26,F26)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":60},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":191},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":224},null,"x",1,2,3]
[null,null,null,12,144,225,{"$f":"COUNTIF(D$10:D27,D27)","v":2},{"$f":"COUNTIF(E$10:E27,E27)","v":1},{"$f":"COUNTIF(F$10:F27,F27)","v":1},1.6,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":12},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":144},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":225},null,"y",{"$f":"R16","v":43.5},{"$f":"S16","v":155},250]
[null,null,null,48,174,225,{"$f":"COUNTIF(D$10:D28,D28)","v":2},{"$f":"COUNTIF(E$10:E28,E28)","v":1},{"$f":"COUNTIF(F$10:F28,F28)","v":2},1.7000000000000002,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":48},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":174},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":225}]
[null,null,null,31,111,226,{"$f":"COUNTIF(D$10:D29,D29)","v":1},{"$f":"COUNTIF(E$10:E29,E29)","v":1},{"$f":"COUNTIF(F$10:F29,F29)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":31},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":111},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":226},null,"Error Bar Length"]
[null,null,null,18,175,226,{"$f":"COUNTIF(D$10:D30,D30)","v":1},{"$f":"COUNTIF(E$10:E30,E30)","v":1},{"$f":"COUNTIF(F$10:F30,F30)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":18},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":175},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":226},null,"Positive",{"$f":"-R16+R18","v":46.5},{"$f":"-S16+S18","v":36.099999999999994},40.199999999999989]
[null,null,null,56,116,229,{"$f":"COUNTIF(D$10:D31,D31)","v":1},{"$f":"COUNTIF(E$10:E31,E31)","v":1},{"$f":"COUNTIF(F$10:F31,F31)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":56},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":116},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":229},null,"Negative",{"$f":"R16-R14","v":31.6},{"$f":"S16-S14","v":42.2},39.199999999999989]
[null,null,null,90,143,230,{"$f":"COUNTIF(D$10:D32,D32)","v":1},{"$f":"COUNTIF(E$10:E32,E32)","v":1},{"$f":"COUNTIF(F$10:F32,F32)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":90},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":143},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":230}]
[null,null,null,10,116,237,{"$f":"COUNTIF(D$10:D33,D33)","v":1},{"$f":"COUNTIF(E$10:E33,E33)","v":2},{"$f":"COUNTIF(F$10:F33,F33)","v":1},1.5,2.6,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":10},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":116},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":237}]
[null,null,null,9,168,240,{"$f":"COUNTIF(D$10:D34,D34)","v":1},{"$f":"COUNTIF(E$10:E34,E34)","v":1},{"$f":"COUNTIF(F$10:F34,F34)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":9},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":168},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":240}]
[null,null,null,92,196,240,{"$f":"COUNTIF(D$10:D35,D35)","v":2},{"$f":"COUNTIF(E$10:E35,E35)","v":2},{"$f":"COUNTIF(F$10:F35,F35)","v":2},1.6,2.6,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":92},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":196},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":240}]
[null,null,null,31,105,241,{"$f":"COUNTIF(D$10:D36,D36)","v":2},{"$f":"COUNTIF(E$10:E36,E36)","v":1},{"$f":"COUNTIF(F$10:F36,F36)","v":1},1.7000000000000002,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":31},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":105},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":241}]
[null,null,null,13,124,242,{"$f":"COUNTIF(D$10:D37,D37)","v":1},{"$f":"COUNTIF(E$10:E37,E37)","v":1},{"$f":"COUNTIF(F$10:F37,F37)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":13},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":124},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":242}]
[null,null,null,93,150,248,{"$f":"COUNTIF(D$10:D38,D38)","v":1},{"$f":"COUNTIF(E$10:E38,E38)","v":1},{"$f":"COUNTIF(F$10:F38,F38)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":93},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":150},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":248}]
[null,null,null,95,182,250,{"$f":"COUNTIF(D$10:D39,D39)","v":1},{"$f":"COUNTIF(E$10:E39,E39)","v":2},{"$f":"COUNTIF(F$10:F39,F39)","v":1},1.5,2.6,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":95},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":182},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":250}]
[null,null,null,11,186,250,{"$f":"COUNTIF(D$10:D40,D40)","v":1},{"$f":"COUNTIF(E$10:E40,E40)","v":1},{"$f":"COUNTIF(F$10:F40,F40)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":11},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":186},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":250}]
[null,null,null,27,182,251,{"$f":"COUNTIF(D$10:D41,D41)","v":1},{"$f":"COUNTIF(E$10:E41,E41)","v":3},{"$f":"COUNTIF(F$10:F41,F41)","v":1},1.5,2.6,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":27},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":182},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":251}]
[null,null,null,31,149,252,{"$f":"COUNTIF(D$10:D42,D42)","v":3},{"$f":"COUNTIF(E$10:E42,E42)","v":2},{"$f":"COUNTIF(F$10:F42,F42)","v":1},{"$f":"IF(G42=1,R$9,J41+R$10)","v":1.6},{"$f":"IF(H42=1,S$9,K41+S$10)","v":2.7},{"$f":"IF(I42=1,T$9,L41+T$10)","v":3.5},{"$f":"Clouds[[#This Row],[Cloud 1]]","v":31},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":149},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":252}]
[null,null,null,67,198,252,{"$f":"COUNTIF(D$10:D43,D43)","v":2},{"$f":"COUNTIF(E$10:E43,E43)","v":1},{"$f":"COUNTIF(F$10:F43,F43)","v":2},1.7000000000000002,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":67},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":198},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":252}]
[null,null,null,68,138,253,{"$f":"COUNTIF(D$10:D44,D44)","v":2},{"$f":"COUNTIF(E$10:E44,E44)","v":1},{"$f":"COUNTIF(F$10:F44,F44)","v":1},1.8000000000000003,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":68},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":138},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":253}]
[null,null,null,19,160,253,{"$f":"COUNTIF(D$10:D45,D45)","v":1},{"$f":"COUNTIF(E$10:E45,E45)","v":2},{"$f":"COUNTIF(F$10:F45,F45)","v":2},1.5,2.6,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":19},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":160},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":253}]
[null,null,null,28,191,254,{"$f":"COUNTIF(D$10:D46,D46)","v":2},{"$f":"COUNTIF(E$10:E46,E46)","v":2},{"$f":"COUNTIF(F$10:F46,F46)","v":1},1.6,2.7,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":28},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":191},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":254}]
[null,null,null,29,117,257,{"$f":"COUNTIF(D$10:D47,D47)","v":2},{"$f":"COUNTIF(E$10:E47,E47)","v":1},{"$f":"COUNTIF(F$10:F47,F47)","v":1},1.7000000000000002,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":29},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":117},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":257}]
[null,null,null,17,123,257,{"$f":"COUNTIF(D$10:D48,D48)","v":1},{"$f":"COUNTIF(E$10:E48,E48)","v":1},{"$f":"COUNTIF(F$10:F48,F48)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":17},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":123},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":257}]
[null,null,null,18,172,259,{"$f":"COUNTIF(D$10:D49,D49)","v":2},{"$f":"COUNTIF(E$10:E49,E49)","v":1},{"$f":"COUNTIF(F$10:F49,F49)","v":1},1.6,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":18},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":172},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":259}]
[null,null,null,44,128,262,{"$f":"COUNTIF(D$10:D50,D50)","v":1},{"$f":"COUNTIF(E$10:E50,E50)","v":1},{"$f":"COUNTIF(F$10:F50,F50)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":44},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":128},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":262}]
[null,null,null,60,191,262,{"$f":"COUNTIF(D$10:D55,D51)","v":2},{"$f":"COUNTIF(E$10:E51,E51)","v":3},{"$f":"COUNTIF(F$10:F51,F51)","v":2},1.6,2.6,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":60},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":191},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":262}]
[null,null,null,43,125,265,{"$f":"COUNTIF(D$10:D52,D52)","v":1},{"$f":"COUNTIF(E$10:E52,E52)","v":1},{"$f":"COUNTIF(F$10:F52,F52)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":43},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":125},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":265}]
[null,null,null,68,126,265,{"$f":"COUNTIF(D$10:D53,D53)","v":3},{"$f":"COUNTIF(E$10:E53,E53)","v":1},{"$f":"COUNTIF(F$10:F53,F53)","v":2},1.6,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":68},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":126},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":265}]
[null,null,null,39,121,272,{"$f":"COUNTIF(D$10:D54,D54)","v":1},{"$f":"COUNTIF(E$10:E54,E54)","v":1},{"$f":"COUNTIF(F$10:F54,F54)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":39},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":121},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":272}]
[null,null,null,15,156,274,{"$f":"COUNTIF(D$10:D55,D55)","v":1},{"$f":"COUNTIF(E$10:E55,E55)","v":1},{"$f":"COUNTIF(F$10:F55,F55)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":15},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":156},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":274}]
[null,null,null,21,192,280,{"$f":"COUNTIF(D$10:D56,D56)","v":1},{"$f":"COUNTIF(E$10:E56,E56)","v":1},{"$f":"COUNTIF(F$10:F56,F56)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":21},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":192},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":280}]
[null,null,null,8,105,283,{"$f":"COUNTIF(D$10:D57,D57)","v":2},{"$f":"COUNTIF(E$10:E57,E57)","v":2},{"$f":"COUNTIF(F$10:F57,F57)","v":1},1.6,2.6,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":8},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":105},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":283}]
[null,null,null,53,200,283,{"$f":"COUNTIF(D$10:D58,D58)","v":1},{"$f":"COUNTIF(E$10:E58,E58)","v":1},{"$f":"COUNTIF(F$10:F58,F58)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":53},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":200},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":283}]
[null,null,null,1,179,285,{"$f":"COUNTIF(D$10:D59,D59)","v":1},{"$f":"COUNTIF(E$10:E59,E59)","v":1},{"$f":"COUNTIF(F$10:F59,F59)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":1},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":179},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":285}]
[null,null,null,63,113,290,{"$f":"COUNTIF(D$10:D60,D60)","v":1},{"$f":"COUNTIF(E$10:E60,E60)","v":1},{"$f":"COUNTIF(F$10:F60,F60)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":63},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":113},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":290}]
[null,null,null,73,146,290,{"$f":"COUNTIF(D$10:D61,D61)","v":1},{"$f":"COUNTIF(E$10:E61,E61)","v":1},{"$f":"COUNTIF(F$10:F61,F61)","v":2},1.5,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":73},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":146},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":290}]
[null,null,null,78,173,290,{"$f":"COUNTIF(D$10:D62,D62)","v":1},{"$f":"COUNTIF(E$10:E62,E62)","v":1},{"$f":"COUNTIF(F$10:F62,F62)","v":3},1.5,2.5,3.7,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":78},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":173},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":290}]
[null,null,null,90,189,290,{"$f":"COUNTIF(D$10:D63,D63)","v":2},{"$f":"COUNTIF(E$10:E63,E63)","v":1},{"$f":"COUNTIF(F$10:F63,F63)","v":4},1.6,2.5,3.8000000000000003,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":90},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":189},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":290}]
[null,null,null,51,154,292,{"$f":"COUNTIF(D$10:D64,D64)","v":1},{"$f":"COUNTIF(E$10:E64,E64)","v":1},{"$f":"COUNTIF(F$10:F64,F64)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":51},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":154},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":292}]
[null,null,null,27,177,293,{"$f":"COUNTIF(D$10:D65,D65)","v":2},{"$f":"COUNTIF(E$10:E65,E65)","v":1},{"$f":"COUNTIF(F$10:F65,F65)","v":1},1.6,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":27},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":177},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":293}]
[null,null,null,56,106,295,{"$f":"COUNTIF(D$10:D66,D66)","v":2},{"$f":"COUNTIF(E$10:E66,E66)","v":1},{"$f":"COUNTIF(F$10:F66,F66)","v":1},1.7000000000000002,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":56},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":106},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":295}]
[null,null,null,12,190,295,{"$f":"COUNTIF(D$10:D67,D67)","v":3},{"$f":"COUNTIF(E$10:E67,E67)","v":1},{"$f":"COUNTIF(F$10:F67,F67)","v":2},1.8000000000000003,2.5,3.6,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":12},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":190},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":295}]
[null,null,null,53,191,297,{"$f":"COUNTIF(D$10:D68,D68)","v":2},{"$f":"COUNTIF(E$10:E68,E68)","v":4},{"$f":"COUNTIF(F$10:F68,F68)","v":1},1.9000000000000004,2.6,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":53},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":191},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":297}]
[null,null,null,70,119,298,{"$f":"COUNTIF(D$10:D69,D69)","v":1},{"$f":"COUNTIF(E$10:E69,E69)","v":1},{"$f":"COUNTIF(F$10:F69,F69)","v":1},1.5,2.5,3.5,{"$f":"Clouds[[#This Row],[Cloud 1]]","v":70},{"$f":"Clouds[[#This Row],[Cloud 2]]","v":119},{"$f":"Clouds[[#This Row],[Cloud 3]]","v":298}]

{"sheet":"Error Checks","index":7,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Error Checks"}]
[{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Error Checks"]
[]
[null,null,"Summary of Errors"]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"Example"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]

{"sheet":"Change Log","index":8,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Change Log"}]
[{"$f":"Model_Name","v":"SP Vertical RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Change Log"}]
[]
[null,null,"Summary"]
[]
[null,null,null,null,null,"Date","Model Version ","Details of change","Worksheet Reference","Row, column, cell reference","Author"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","I changed it","Change Log","F11","LB"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","So did I.","Timing","A4","LB"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","And me.","Navigator","B9","Dave"]