{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Horizontal Raincloud - 1 Cloud","Horizontal Raincloud - 3 Clouds","Error Checks"],"not_rendered":{"charts":11,"images":1,"macros":1,"external_links":0,"defined_names":78,"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 Horizontal RainCloud Chart - Complete.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Sam Ngo"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Example of a Horizontal 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":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP Horizontal 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,"Horizontal Raincloud - 1 Cloud"]
[null,null,null,null,null,"Horizontal Raincloud - 3 Clouds"]
[null,null,null,null,null,"Error Checks"]

{"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 Horizontal 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":"2023-10-26"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2023-10-26"},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 Horizontal 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 Horizontal 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":"Horizontal Raincloud - 1 Cloud","index":4,"n_rows":69,"n_cols":12,"rows_kept":69,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[{"$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":"Horizontal Raincloud - 1 Cloud"}]
[{"$f":"Model_Name","v":"SP Horizontal RainCloud Chart - Complete.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,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 Sorted","Cloud 1: 1st position","Cloud 1: X-position",null,"Location",1.5]
[null,null,null,27,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":1},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G9+J$10)","v":1.5},null,"Length",-0.5]
[null,null,null,18,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":8},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G10+J$10)","v":1.5}]
[null,null,null,95,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":8},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G11+J$10)","v":1},null,"Percentile","Percentile: Cloud 1"]
[null,null,null,90,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":9},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G12+J$10)","v":1.5},null,0,{"$f":"PERCENTILE('Horizontal Raincloud - 1 Cloud'!$D$10:$D$69,$I13)","v":1}]
[null,null,null,53,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":10},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G13+J$10)","v":1.5},null,0.1,{"$f":"PERCENTILE('Horizontal Raincloud - 1 Cloud'!$D$10:$D$69,$I14)","v":11.9}]
[null,null,null,17,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":11},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G14+J$10)","v":1.5},null,0.25,{"$f":"PERCENTILE('Horizontal Raincloud - 1 Cloud'!$D$10:$D$69,$I15)","v":20.5}]
[null,null,null,92,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":12},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G15+J$10)","v":1.5},null,0.5,{"$f":"PERCENTILE('Horizontal Raincloud - 1 Cloud'!$D$10:$D$69,$I16)","v":43.5}]
[null,null,null,93,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":12},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G16+J$10)","v":1},null,0.75,{"$f":"PERCENTILE('Horizontal Raincloud - 1 Cloud'!$D$10:$D$69,$I17)","v":64.75}]
[null,null,null,18,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":12},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":3},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G17+J$10)","v":0.5},null,0.9,{"$f":"PERCENTILE('Horizontal Raincloud - 1 Cloud'!$D$10:$D$69,$I18)","v":90}]
[null,null,null,15,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":13},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G18+J$10)","v":1.5},null,1,{"$f":"PERCENTILE('Horizontal Raincloud - 1 Cloud'!$D$10:$D$69,$I19)","v":99}]
[null,null,null,31,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":15},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G19+J$10)","v":1.5}]
[null,null,null,9,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":17},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G20+J$10)","v":1.5},null,"Stacked Bar",null,null,"Stacked: Cloud 1"]
[null,null,null,27,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":18},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G21+J$10)","v":1.5},null,"Base 25th",null,null,{"$f":"J15","v":20.5}]
[null,null,null,29,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":18},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G22+J$10)","v":1},null,"Bottom 25-50",null,null,{"$f":"J16-J15","v":23}]
[null,null,null,70,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":19},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G23+J$10)","v":1.5},null,"Top 50-75",null,null,{"$f":"J17-J16","v":21.25}]
[null,null,null,12,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":21},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G24+J$10)","v":1.5}]
[null,null,null,43,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":27},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G25+J$10)","v":1.5},null,"x","y"]
[null,null,null,39,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":27},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G26+J$10)","v":1},null,{"$f":"J16","v":43.5},2.5]
[null,null,null,53,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":28},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G27+J$10)","v":1.5}]
[null,null,null,68,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":28},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G28+J$10)","v":1},null,"Error Bar Length"]
[null,null,null,60,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":29},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G29+J$10)","v":1.5},null,"Positive",{"$f":"-J16+J18","v":46.5}]
[null,null,null,8,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":29},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G30+J$10)","v":1},null,"Negative",{"$f":"J16-J14","v":31.6}]
[null,null,null,8,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":31},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G31+J$10)","v":1.5}]
[null,null,null,31,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":31},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G32+J$10)","v":1}]
[null,null,null,19,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":31},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":3},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G33+J$10)","v":0.5}]
[null,null,null,56,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":33},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G34+J$10)","v":1.5}]
[null,null,null,67,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":34},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G35+J$10)","v":1.5}]
[null,null,null,90,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":38},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G36+J$10)","v":1.5}]
[null,null,null,28,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":39},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G37+J$10)","v":1.5}]
[null,null,null,11,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":43},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G38+J$10)","v":1.5}]
[null,null,null,62,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":44},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G39+J$10)","v":1.5}]
[null,null,null,50,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":48},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G40+J$10)","v":1.5}]
[null,null,null,48,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":48},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G41+J$10)","v":1}]
[null,null,null,21,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":50},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G42+J$10)","v":1.5}]
[null,null,null,51,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":51},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G43+J$10)","v":1.5}]
[null,null,null,33,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":52},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G44+J$10)","v":1.5}]
[null,null,null,13,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":53},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G45+J$10)","v":1.5}]
[null,null,null,63,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":53},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G46+J$10)","v":1}]
[null,null,null,73,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":56},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G47+J$10)","v":1.5}]
[null,null,null,99,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":56},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G48+J$10)","v":1}]
[null,null,null,38,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":60},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G49+J$10)","v":1.5}]
[null,null,null,67,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":60},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G50+J$10)","v":1}]
[null,null,null,1,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":62},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G51+J$10)","v":1.5}]
[null,null,null,68,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":63},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G52+J$10)","v":1.5}]
[null,null,null,12,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":64},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G53+J$10)","v":1.5}]
[null,null,null,10,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":67},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G54+J$10)","v":1.5}]
[null,null,null,92,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":67},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G55+J$10)","v":1}]
[null,null,null,68,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":68},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G56+J$10)","v":1.5}]
[null,null,null,29,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":68},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G57+J$10)","v":1}]
[null,null,null,31,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":68},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":3},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G58+J$10)","v":0.5}]
[null,null,null,34,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":70},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G59+J$10)","v":1.5}]
[null,null,null,12,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":73},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G60+J$10)","v":1.5}]
[null,null,null,78,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":78},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G61+J$10)","v":1.5}]
[null,null,null,28,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":90},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G62+J$10)","v":1.5}]
[null,null,null,64,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":90},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G63+J$10)","v":1}]
[null,null,null,60,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":92},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G64+J$10)","v":1.5}]
[null,null,null,56,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":92},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":2},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G65+J$10)","v":1}]
[null,null,null,52,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":93},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G66+J$10)","v":1.5}]
[null,null,null,48,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":95},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G67+J$10)","v":1.5}]
[null,null,null,44,{"$f":"SMALL(Cloud[Cloud 1],COUNTA(Cloud[[#Headers],[Cloud 1]]:Cloud[[#This Row],[Cloud 1]])-1)","v":99},{"$f":"COUNTIF(Cloud[[#Headers],[Cloud 1 Sorted]]:Cloud[[#This Row],[Cloud 1 Sorted]],Cloud[[#This Row],[Cloud 1 Sorted]])","v":1},{"$f":"IF(Cloud[[#This Row],[Cloud 1: 1st position]]=1,J$9,G68+J$10)","v":1.5}]

{"sheet":"Horizontal Raincloud - 3 Clouds","index":5,"n_rows":69,"n_cols":22,"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":"Horizontal Raincloud - 3 Clouds"}]
[{"$f":"Model_Name","v":"SP Horizontal 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 Sorted","Cloud 2 Sorted","Cloud 3 Sorted","Cloud 1: 1st position","Cloud 2: 1st position","Cloud 3: 1st position","Cloud 1: X-position","Cloud 2: X-position","Cloud 3: X-position",null,"Location",2,3,4]
[null,null,null,12,181,204,{"$f":"_xlfn._xlws.SORT(Clouds[Cloud 1])","v":1},{"$f":"_xlfn._xlws.SORT(Clouds[Cloud 2])","v":102},{"$f":"_xlfn._xlws.SORT(Clouds[Cloud 3])","v":204},{"$f":"COUNTIF(G$10:G10,G10)","v":1},{"$f":"COUNTIF(H$10:H10,H10)","v":1},{"$f":"COUNTIF(I$10:I10,I10)","v":1},{"$f":"IF(J10=1,R$9,M9+R$10)","v":2},{"$f":"IF(K10=1,S$9,N9+S$10)","v":3},{"$f":"IF(L10=1,T$9,O9+T$10)","v":4},null,"Length",-0.5,-0.5,-0.5]
[null,null,null,99,149,206,8,105,206,{"$f":"COUNTIF(G$10:G11,G11)","v":1},{"$f":"COUNTIF(H$10:H11,H11)","v":1},{"$f":"COUNTIF(I$10:I11,I11)","v":1},2,3,4]
[null,null,null,52,164,206,8,105,206,{"$f":"COUNTIF(G$10:G12,G12)","v":2},{"$f":"COUNTIF(H$10:H12,H12)","v":2},{"$f":"COUNTIF(I$10:I12,I12)","v":2},1.5,2.5,3.5,null,"Percentile","Percentile: Cloud 1","Percentile: Cloud 2","Percentile: Cloud 3"]
[null,null,null,28,182,206,9,106,206,{"$f":"COUNTIF(G$10:G13,G13)","v":1},{"$f":"COUNTIF(H$10:H13,H13)","v":1},{"$f":"COUNTIF(I$10:I13,I13)","v":3},2,3,3,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,10,107,208,{"$f":"COUNTIF(G$10:G14,G14)","v":1},{"$f":"COUNTIF(H$10:H14,H14)","v":1},{"$f":"COUNTIF(I$10:I14,I14)","v":1},2,3,4,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,11,111,209,{"$f":"COUNTIF(G$10:G15,G15)","v":1},{"$f":"COUNTIF(H$10:H15,H15)","v":1},{"$f":"COUNTIF(I$10:I15,I15)","v":1},2,3,4,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,12,113,211,{"$f":"COUNTIF(G$10:G16,G16)","v":1},{"$f":"COUNTIF(H$10:H16,H16)","v":1},{"$f":"COUNTIF(I$10:I16,I16)","v":1},2,3,4,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,12,116,211,{"$f":"COUNTIF(G$10:G17,G17)","v":2},{"$f":"COUNTIF(H$10:H17,H17)","v":1},{"$f":"COUNTIF(I$10:I17,I17)","v":2},1.5,3,3.5,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,12,116,213,{"$f":"COUNTIF(G$10:G18,G18)","v":3},{"$f":"COUNTIF(H$10:H18,H18)","v":2},{"$f":"COUNTIF(I$10:I18,I18)","v":1},1,2.5,4,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,13,117,216,{"$f":"COUNTIF(G$10:G19,G19)","v":1},{"$f":"COUNTIF(H$10:H19,H19)","v":1},{"$f":"COUNTIF(I$10:I19,I19)","v":1},2,3,4,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,15,118,216,{"$f":"COUNTIF(G$10:G20,G20)","v":1},{"$f":"COUNTIF(H$10:H20,H20)","v":1},{"$f":"COUNTIF(I$10:I20,I20)","v":2},2,3,3.5]
[null,null,null,68,153,217,17,118,217,{"$f":"COUNTIF(G$10:G21,G21)","v":1},{"$f":"COUNTIF(H$10:H21,H21)","v":2},{"$f":"COUNTIF(I$10:I21,I21)","v":1},2,2.5,4,null,"Stacked Bar",null,null,"Stacked: Cloud 1","Stacked: Cloud 2","Stacked: Cloud 3"]
[null,null,null,62,184,217,18,119,217,{"$f":"COUNTIF(G$10:G22,G22)","v":1},{"$f":"COUNTIF(H$10:H22,H22)","v":1},{"$f":"COUNTIF(I$10:I22,I22)","v":2},2,3,3.5,null,"Base 25th",null,null,{"$f":"R15","v":20.5},{"$f":"S15","v":123.75},{"$f":"T15","v":223}]
[null,null,null,64,196,218,18,121,218,{"$f":"COUNTIF(G$10:G23,G23)","v":2},{"$f":"COUNTIF(H$10:H23,H23)","v":1},{"$f":"COUNTIF(I$10:I23,I23)","v":1},1.5,3,4,null,"Bottom 25-50",null,null,{"$f":"R16-R15","v":23},31.25,27]
[null,null,null,92,102,223,19,123,223,{"$f":"COUNTIF(G$10:G24,G24)","v":1},{"$f":"COUNTIF(H$10:H24,H24)","v":1},{"$f":"COUNTIF(I$10:I24,I24)","v":1},2,3,4,null,"Top 50-75",null,null,21.25,27,22.5]
[null,null,null,8,118,223,21,124,223,{"$f":"COUNTIF(G$10:G25,G25)","v":1},{"$f":"COUNTIF(H$10:H25,H25)","v":1},{"$f":"COUNTIF(I$10:I25,I25)","v":2},2,3,3.5]
[null,null,null,60,191,224,27,125,224,{"$f":"COUNTIF(G$10:G26,G26)","v":1},{"$f":"COUNTIF(H$10:H26,H26)","v":1},{"$f":"COUNTIF(I$10:I26,I26)","v":1},2,3,4,null,"x","y"]
[null,null,null,12,144,225,27,126,225,{"$f":"COUNTIF(G$10:G27,G27)","v":2},{"$f":"COUNTIF(H$10:H27,H27)","v":1},{"$f":"COUNTIF(I$10:I27,I27)","v":1},1.5,3,4,null,{"$f":"R16","v":43.5},2.5]
[null,null,null,48,174,225,28,127,225,{"$f":"COUNTIF(G$10:G28,G28)","v":1},{"$f":"COUNTIF(H$10:H28,H28)","v":1},{"$f":"COUNTIF(I$10:I28,I28)","v":2},2,3,3.5,null,{"$f":"S16","v":155},3.5]
[null,null,null,31,111,226,28,128,226,{"$f":"COUNTIF(G$10:G29,G29)","v":2},{"$f":"COUNTIF(H$10:H29,H29)","v":1},{"$f":"COUNTIF(I$10:I29,I29)","v":1},1.5,3,4,null,{"$f":"T16","v":250},4.5]
[null,null,null,18,175,226,29,138,226,{"$f":"COUNTIF(G$10:G30,G30)","v":1},{"$f":"COUNTIF(H$10:H30,H30)","v":1},{"$f":"COUNTIF(I$10:I30,I30)","v":2},2,3,3.5]
[null,null,null,56,116,229,29,143,229,{"$f":"COUNTIF(G$10:G31,G31)","v":2},{"$f":"COUNTIF(H$10:H31,H31)","v":1},{"$f":"COUNTIF(I$10:I31,I31)","v":1},1.5,3,4,null,"Error Bar Length"]
[null,null,null,90,143,230,31,144,230,{"$f":"COUNTIF(G$10:G32,G32)","v":1},{"$f":"COUNTIF(H$10:H32,H32)","v":1},{"$f":"COUNTIF(I$10:I32,I32)","v":1},2,3,4,null,"Positive",{"$f":"-R16+R18","v":46.5},{"$f":"-S16+S18","v":36.099999999999994},{"$f":"-T16+T18","v":40.199999999999989}]
[null,null,null,10,116,237,31,146,237,{"$f":"COUNTIF(G$10:G33,G33)","v":2},{"$f":"COUNTIF(H$10:H33,H33)","v":1},{"$f":"COUNTIF(I$10:I33,I33)","v":1},1.5,3,4,null,"Negative",{"$f":"R16-R14","v":31.6},{"$f":"S16-S14","v":42.2},{"$f":"T16-T14","v":39.199999999999989}]
[null,null,null,9,168,240,31,147,240,{"$f":"COUNTIF(G$10:G34,G34)","v":3},{"$f":"COUNTIF(H$10:H34,H34)","v":1},{"$f":"COUNTIF(I$10:I34,I34)","v":1},1,3,4]
[null,null,null,92,196,240,33,149,240,{"$f":"COUNTIF(G$10:G35,G35)","v":1},{"$f":"COUNTIF(H$10:H35,H35)","v":1},{"$f":"COUNTIF(I$10:I35,I35)","v":2},2,3,3.5]
[null,null,null,31,105,241,34,149,241,{"$f":"COUNTIF(G$10:G36,G36)","v":1},{"$f":"COUNTIF(H$10:H36,H36)","v":2},{"$f":"COUNTIF(I$10:I36,I36)","v":1},2,2.5,4]
[null,null,null,13,124,242,38,150,242,{"$f":"COUNTIF(G$10:G37,G37)","v":1},{"$f":"COUNTIF(H$10:H37,H37)","v":1},{"$f":"COUNTIF(I$10:I37,I37)","v":1},2,3,4]
[null,null,null,93,150,248,39,153,248,{"$f":"COUNTIF(G$10:G38,G38)","v":1},{"$f":"COUNTIF(H$10:H38,H38)","v":1},{"$f":"COUNTIF(I$10:I38,I38)","v":1},2,3,4]
[null,null,null,95,182,250,43,154,250,{"$f":"COUNTIF(G$10:G39,G39)","v":1},{"$f":"COUNTIF(H$10:H39,H39)","v":1},{"$f":"COUNTIF(I$10:I39,I39)","v":1},2,3,4]
[null,null,null,11,186,250,44,156,250,{"$f":"COUNTIF(G$10:G40,G40)","v":1},{"$f":"COUNTIF(H$10:H40,H40)","v":1},{"$f":"COUNTIF(I$10:I40,I40)","v":2},2,3,3.5]
[null,null,null,27,182,251,48,160,251,{"$f":"COUNTIF(G$10:G41,G41)","v":1},{"$f":"COUNTIF(H$10:H41,H41)","v":1},{"$f":"COUNTIF(I$10:I41,I41)","v":1},2,3,4]
[null,null,null,31,149,252,48,160,252,{"$f":"COUNTIF(G$10:G42,G42)","v":2},{"$f":"COUNTIF(H$10:H42,H42)","v":2},{"$f":"COUNTIF(I$10:I42,I42)","v":1},{"$f":"IF(J42=1,R$9,M41+R$10)","v":1.5},{"$f":"IF(K42=1,S$9,N41+S$10)","v":2.5},{"$f":"IF(L42=1,T$9,O41+T$10)","v":4}]
[null,null,null,67,198,252,50,164,252,{"$f":"COUNTIF(G$10:G43,G43)","v":1},{"$f":"COUNTIF(H$10:H43,H43)","v":1},{"$f":"COUNTIF(I$10:I43,I43)","v":2},2,3,3.5]
[null,null,null,68,138,253,51,167,253,{"$f":"COUNTIF(G$10:G44,G44)","v":1},{"$f":"COUNTIF(H$10:H44,H44)","v":1},{"$f":"COUNTIF(I$10:I44,I44)","v":1},2,3,4]
[null,null,null,19,160,253,52,168,253,{"$f":"COUNTIF(G$10:G45,G45)","v":1},{"$f":"COUNTIF(H$10:H45,H45)","v":1},{"$f":"COUNTIF(I$10:I45,I45)","v":2},2,3,3.5]
[null,null,null,28,191,254,53,172,254,{"$f":"COUNTIF(G$10:G46,G46)","v":1},{"$f":"COUNTIF(H$10:H46,H46)","v":1},{"$f":"COUNTIF(I$10:I46,I46)","v":1},2,3,4]
[null,null,null,29,117,257,53,173,257,{"$f":"COUNTIF(G$10:G47,G47)","v":2},{"$f":"COUNTIF(H$10:H47,H47)","v":1},{"$f":"COUNTIF(I$10:I47,I47)","v":1},1.5,3,4]
[null,null,null,17,123,257,56,174,257,{"$f":"COUNTIF(G$10:G48,G48)","v":1},{"$f":"COUNTIF(H$10:H48,H48)","v":1},{"$f":"COUNTIF(I$10:I48,I48)","v":2},2,3,3.5]
[null,null,null,18,172,259,56,175,259,{"$f":"COUNTIF(G$10:G49,G49)","v":2},{"$f":"COUNTIF(H$10:H49,H49)","v":1},{"$f":"COUNTIF(I$10:I49,I49)","v":1},1.5,3,4]
[null,null,null,44,128,262,60,177,262,{"$f":"COUNTIF(G$10:G50,G50)","v":1},{"$f":"COUNTIF(H$10:H50,H50)","v":1},{"$f":"COUNTIF(I$10:I50,I50)","v":1},2,3,4]
[null,null,null,60,191,262,60,179,262,{"$f":"COUNTIF(G$10:G51,G51)","v":2},{"$f":"COUNTIF(H$10:H51,H51)","v":1},{"$f":"COUNTIF(I$10:I51,I51)","v":2},1.5,3,3.5]
[null,null,null,43,125,265,62,181,265,{"$f":"COUNTIF(G$10:G52,G52)","v":1},{"$f":"COUNTIF(H$10:H52,H52)","v":1},{"$f":"COUNTIF(I$10:I52,I52)","v":1},2,3,4]
[null,null,null,68,126,265,63,182,265,{"$f":"COUNTIF(G$10:G53,G53)","v":1},{"$f":"COUNTIF(H$10:H53,H53)","v":1},{"$f":"COUNTIF(I$10:I53,I53)","v":2},2,3,3.5]
[null,null,null,39,121,272,64,182,272,{"$f":"COUNTIF(G$10:G54,G54)","v":1},{"$f":"COUNTIF(H$10:H54,H54)","v":2},{"$f":"COUNTIF(I$10:I54,I54)","v":1},2,2.5,4]
[null,null,null,15,156,274,67,182,274,{"$f":"COUNTIF(G$10:G55,G55)","v":1},{"$f":"COUNTIF(H$10:H55,H55)","v":3},{"$f":"COUNTIF(I$10:I55,I55)","v":1},2,2,4]
[null,null,null,21,192,280,67,184,280,{"$f":"COUNTIF(G$10:G56,G56)","v":2},{"$f":"COUNTIF(H$10:H56,H56)","v":1},{"$f":"COUNTIF(I$10:I56,I56)","v":1},1.5,3,4]
[null,null,null,8,105,283,68,186,283,{"$f":"COUNTIF(G$10:G57,G57)","v":1},{"$f":"COUNTIF(H$10:H57,H57)","v":1},{"$f":"COUNTIF(I$10:I57,I57)","v":1},2,3,4]
[null,null,null,53,200,283,68,189,283,{"$f":"COUNTIF(G$10:G58,G58)","v":2},{"$f":"COUNTIF(H$10:H58,H58)","v":1},{"$f":"COUNTIF(I$10:I58,I58)","v":2},1.5,3,3.5]
[null,null,null,1,179,285,68,190,285,{"$f":"COUNTIF(G$10:G59,G59)","v":3},{"$f":"COUNTIF(H$10:H59,H59)","v":1},{"$f":"COUNTIF(I$10:I59,I59)","v":1},1,3,4]
[null,null,null,63,113,290,70,191,290,{"$f":"COUNTIF(G$10:G60,G60)","v":1},{"$f":"COUNTIF(H$10:H60,H60)","v":1},{"$f":"COUNTIF(I$10:I60,I60)","v":1},2,3,4]
[null,null,null,73,146,290,73,191,290,{"$f":"COUNTIF(G$10:G61,G61)","v":1},{"$f":"COUNTIF(H$10:H61,H61)","v":2},{"$f":"COUNTIF(I$10:I61,I61)","v":2},2,2.5,3.5]
[null,null,null,78,173,290,78,191,290,{"$f":"COUNTIF(G$10:G62,G62)","v":1},{"$f":"COUNTIF(H$10:H62,H62)","v":3},{"$f":"COUNTIF(I$10:I62,I62)","v":3},2,2,3]
[null,null,null,90,189,290,90,191,290,{"$f":"COUNTIF(G$10:G63,G63)","v":1},{"$f":"COUNTIF(H$10:H63,H63)","v":4},{"$f":"COUNTIF(I$10:I63,I63)","v":4},2,1.5,2.5]
[null,null,null,51,154,292,90,192,292,{"$f":"COUNTIF(G$10:G64,G64)","v":2},{"$f":"COUNTIF(H$10:H64,H64)","v":1},{"$f":"COUNTIF(I$10:I64,I64)","v":1},1.5,3,4]
[null,null,null,27,177,293,92,196,293,{"$f":"COUNTIF(G$10:G65,G65)","v":1},{"$f":"COUNTIF(H$10:H65,H65)","v":1},{"$f":"COUNTIF(I$10:I65,I65)","v":1},2,3,4]
[null,null,null,56,106,295,92,196,295,{"$f":"COUNTIF(G$10:G66,G66)","v":2},{"$f":"COUNTIF(H$10:H66,H66)","v":2},{"$f":"COUNTIF(I$10:I66,I66)","v":1},1.5,2.5,4]
[null,null,null,12,190,295,93,197,295,{"$f":"COUNTIF(G$10:G67,G67)","v":1},{"$f":"COUNTIF(H$10:H67,H67)","v":1},{"$f":"COUNTIF(I$10:I67,I67)","v":2},2,3,3.5]
[null,null,null,53,191,297,95,198,297,{"$f":"COUNTIF(G$10:G68,G68)","v":1},{"$f":"COUNTIF(H$10:H68,H68)","v":1},{"$f":"COUNTIF(I$10:I68,I68)","v":1},2,3,4]
[null,null,null,70,119,298,99,200,298,{"$f":"COUNTIF(G$10:G69,G69)","v":1},{"$f":"COUNTIF(H$10:H69,H69)","v":1},{"$f":"COUNTIF(I$10:I69,I69)","v":1},2,3,4]

{"sheet":"Error Checks","index":6,"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 Horizontal 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}]