{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Staffing Assumptions","Staffing Summary","Timing","Error Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":36,"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 Pro-Rating Over Time Example.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Example of how to pro-rate costs (e.g. salaries) across time periods."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP Pro-Rating Over Time Example.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,"Staffing Assumptions"]
[null,null,null,null,null,"Staffing Summary"]
[null,null,null,null,null,"Timing"]
[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 Pro-Rating Over Time Example.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":"Unused"},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":"2019-11-22"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2019-11-22"},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":42,"n_cols":9,"rows_kept":42,"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 Pro-Rating Over Time Example.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 Pro-Rating Over Time Example.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]
[]
[]
[null,{"$f":"MAX($B$5:$B33)+1","v":3},"Yes No"]
[]
[null,null,"Lookup"]
[]
[null,null,null,{"$f":"C36&\" \"&C34","v":"Lookup Yes No"}]
[]
[null,null,null,null,null,{"$f":"\"LU_\"&SUBSTITUTE(C34,\" \",\"_\")","v":"LU_Yes_No"}]
[null,null,null,null,null,"Yes",null,null,"LU_Yes_No"]
[null,null,null,null,null,"No"]

{"sheet":"Staffing Assumptions","index":4,"n_rows":39,"n_cols":17,"rows_kept":39,"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":"Staffing Assumptions"}]
[{"$f":"Model_Name","v":"SP Pro-Rating Over Time Example.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 Assumptions"]
[]
[null,null,"Hours in Working Week"]
[]
[null,null,null,"Constant"]
[]
[null,null,null,null,null,{"$f":"C8","v":"Hours in Working Week"},null,"Hrs",40,null,"Hours_in_Working_Week"]
[]
[]
[null,null,"Probation Duration"]
[]
[null,null,null,"Constant",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,{"$f":"C15","v":"Probation Duration"},null,"Days",90,null,"Probation_Duration"]
[]
[]
[null,{"$f":"MAX($B$5:$B21)+1","v":2},"Employee Details"]
[]
[null,null,"Assumptions"]
[]
[null,null,null,"Data"]
[]
[null,null,null,null,null,"First Name","Last Name","Weekly Hrs","FTE Rate","Initial Salary (OTE)","Annual Increase","Start Date","Probation?","Probation Date","End Date","Extended Date","Max Date"]
[null,null,null,null,null,"Sally","Army",{"$f":"IF(RAND()<0.4,RANDBETWEEN(1,Hours_in_Working_Week),Hours_in_Working_Week)","v":40},{"$f":"IF(Hours_in_Working_Week,MIN(H29/Hours_in_Working_Week,1),)","v":1},{"$f":"RANDBETWEEN(20000,60000)","v":56472},{"$f":"RAND()/30","v":3.0937187527005305E-2},{"$f":"Model_Start_Date-(2*Days_in_Year)+RANDBETWEEN(1,7*Days_in_Year)","v":"2022-12-06"},"Yes",{"$f":"IF(M29=Yes,L29+Probation_Duration,\"\")","v":"2023-03-06"},{"$f":"IF(RAND()<0.1,N29,IF(RAND()<0.5,\"\",MAX(L29,N29)+RANDBETWEEN(1,12*Days_in_Year)-1))","v":"2024-11-22"},{"$f":"IF(O29=\"\",\"\",IF(RAND()<0.5,\"\",O29+RANDBETWEEN(1,10*Days_in_Year)))","v":"2025-01-30"},{"$f":"IF(MAX(N29:P29)>=L29,MAX(N29:P29),\"N/A\")","v":"2025-01-30"}]
[null,null,null,null,null,"Whitney","Bay",40,1,{"$f":"RANDBETWEEN(20000,60000)","v":33723},{"$f":"RAND()/30","v":1.8889412614370896E-2},"2020-09-27",null,"","","",{"$f":"IF(MAX(N30:P30)>=L30,MAX(N30:P30),\"N/A\")","v":"N/A"}]
[null,null,null,null,null,"Wendy","Boatcomesin",40,1,23265,2.8753096326274492E-2,"2020-09-04","Yes","2020-12-03","2029-01-03","2033-01-27","2033-01-27"]
[null,null,null,null,null,"Brianna","Cracker",40,1,21391,2.0390658033434318E-3,"2021-10-11",null,"","2027-12-31","2034-05-17","2034-05-17"]
[null,null,null,null,null,"Mae","June",40,1,57155,5.0244771748174247E-3,"2023-06-09",null,"","","","N/A"]
[null,null,null,null,null,"Jerry","Kann",40,1,57977,2.8850353192281235E-2,"2022-11-27","Yes","2023-02-25","","","2023-02-25"]
[null,null,null,null,null,"Bob","Katt",40,1,54590,3.1175556179279151E-2,"2023-08-25","Yes","2023-11-23","2028-04-29","2031-02-11","2031-02-11"]
[null,null,null,null,null,"Ray","O'Lyte",40,1,48518,5.1430833125731745E-3,"2020-11-13","Yes","2021-02-11","2027-02-04","","2027-02-04"]
[null,null,null,null,null,"Lou","Seat",40,1,52561,1.0951899738888392E-2,"2023-07-12","Yes","2023-10-10","","","2023-10-10"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(Q37),\"\")","v":"=IF(MAX(N37:P37)>=L37,MAX(N37:P37),\"N/A\")"}]

{"sheet":"Staffing Summary","index":5,"n_rows":100,"n_cols":28,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,8,0,9],[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":"Staffing Summary"}]
[{"$f":"Model_Name","v":"SP Pro-Rating Over Time Example.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2019-12-31"},{"$f":"Timing!K5","v":"2020-12-31"},{"$f":"Timing!L5","v":"2021-12-31"},{"$f":"Timing!M5","v":"2022-12-31"},{"$f":"Timing!N5","v":"2023-12-31"},{"$f":"Timing!O5","v":"2024-12-31"},{"$f":"Timing!P5","v":"2025-12-31"},{"$f":"Timing!Q5","v":"2026-12-31"},{"$f":"Timing!R5","v":"2027-12-31"},{"$f":"Timing!S5","v":"2028-12-31"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2019-01-01"},{"$f":"Timing!K6","v":"2020-01-01"},{"$f":"Timing!L6","v":"2021-01-01"},{"$f":"Timing!M6","v":"2022-01-01"},{"$f":"Timing!N6","v":"2023-01-01"},{"$f":"Timing!O6","v":"2024-01-01"},{"$f":"Timing!P6","v":"2025-01-01"},{"$f":"Timing!Q6","v":"2026-01-01"},{"$f":"Timing!R6","v":"2027-01-01"},{"$f":"Timing!S6","v":"2028-01-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2019-12-31"},{"$f":"Timing!K7","v":"2020-12-31"},{"$f":"Timing!L7","v":"2021-12-31"},{"$f":"Timing!M7","v":"2022-12-31"},{"$f":"Timing!N7","v":"2023-12-31"},{"$f":"Timing!O7","v":"2024-12-31"},{"$f":"Timing!P7","v":"2025-12-31"},{"$f":"Timing!Q7","v":"2026-12-31"},{"$f":"Timing!R7","v":"2027-12-31"},{"$f":"Timing!S7","v":"2028-12-31"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":365},{"$f":"Timing!K8","v":366},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":365},{"$f":"Timing!N8","v":365},{"$f":"Timing!O8","v":366},{"$f":"Timing!P8","v":365},{"$f":"Timing!Q8","v":365},{"$f":"Timing!R8","v":365},{"$f":"Timing!S8","v":366}]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":4},{"$f":"Timing!N9","v":5},{"$f":"Timing!O9","v":6},{"$f":"Timing!P9","v":7},{"$f":"Timing!Q9","v":8},{"$f":"Timing!R9","v":9},{"$f":"Timing!S9","v":10}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Proportion of Period Staff are Available"]
[]
[null,null,"Summary"]
[]
[null,null,null,"By Staff Member"]
[]
[null,null,null,null,"Name",{"$f":"'Staffing Assumptions'!L28","v":"Start Date"},{"$f":"'Staffing Assumptions'!O28","v":"End Date"},{"$f":"'Staffing Assumptions'!I28","v":"FTE Rate"}]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F29&\" \"&'Staffing Assumptions'!G29","v":"Sally Army"},{"$f":"'Staffing Assumptions'!L29","v":"2022-12-06"},{"$f":"'Staffing Assumptions'!Q29","v":"2025-01-30"},{"$f":"'Staffing Assumptions'!I29","v":1},null,{"$f":"MAX(MIN(J$7,$G18)-MAX(J$6,$F18)+1,0)*$H18/J$8","v":0},{"$f":"MAX(MIN(K$7,$G18)-MAX(K$6,$F18)+1,0)*$H18/K$8","v":0},0,7.1232876712328766E-2,1,1,8.2191780821917804E-2,0,0,0,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J18),\"\")","v":"=MAX(MIN(J$7,$G18)-MAX(J$6,$F18)+1,0)*$H18/J$8"}]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F30&\" \"&'Staffing Assumptions'!G30","v":"Whitney Bay"},{"$f":"'Staffing Assumptions'!L30","v":"2020-09-27"},{"$f":"'Staffing Assumptions'!Q30","v":"N/A"},{"$f":"'Staffing Assumptions'!I30","v":1},null,{"$f":"MAX(MIN(J$7,$G19)-MAX(J$6,$F19)+1,0)*$H19/J$8","v":0},0.26229508196721313,1,1,1,1,1,1,1,1,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J19),\"\")","v":"=MAX(MIN(J$7,$G19)-MAX(J$6,$F19)+1,0)*$H19/J$8"}]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F31&\" \"&'Staffing Assumptions'!G31","v":"Wendy Boatcomesin"},{"$f":"'Staffing Assumptions'!L31","v":"2020-09-04"},{"$f":"'Staffing Assumptions'!Q31","v":"2033-01-27"},{"$f":"'Staffing Assumptions'!I31","v":1},null,0,0.3251366120218579,1,1,1,1,1,1,1,1,null,"=MAX(MIN(J$7,$G20)-MAX(J$6,$F20)+1,0)*$H20/J$8"]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F32&\" \"&'Staffing Assumptions'!G32","v":"Brianna Cracker"},{"$f":"'Staffing Assumptions'!L32","v":"2021-10-11"},{"$f":"'Staffing Assumptions'!Q32","v":"2034-05-17"},{"$f":"'Staffing Assumptions'!I32","v":1},null,0,0,0.22465753424657534,1,1,1,1,1,1,1,null,"=MAX(MIN(J$7,$G21)-MAX(J$6,$F21)+1,0)*$H21/J$8"]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F33&\" \"&'Staffing Assumptions'!G33","v":"Mae June"},{"$f":"'Staffing Assumptions'!L33","v":"2023-06-09"},{"$f":"'Staffing Assumptions'!Q33","v":"N/A"},{"$f":"'Staffing Assumptions'!I33","v":1},null,0,0,0,0,0.56438356164383563,1,1,1,1,1,null,"=MAX(MIN(J$7,$G22)-MAX(J$6,$F22)+1,0)*$H22/J$8"]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F34&\" \"&'Staffing Assumptions'!G34","v":"Jerry Kann"},{"$f":"'Staffing Assumptions'!L34","v":"2022-11-27"},{"$f":"'Staffing Assumptions'!Q34","v":"2023-02-25"},{"$f":"'Staffing Assumptions'!I34","v":1},null,0,0,0,9.5890410958904104E-2,0.15342465753424658,0,0,0,0,0,null,"=MAX(MIN(J$7,$G23)-MAX(J$6,$F23)+1,0)*$H23/J$8"]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F35&\" \"&'Staffing Assumptions'!G35","v":"Bob Katt"},{"$f":"'Staffing Assumptions'!L35","v":"2023-08-25"},{"$f":"'Staffing Assumptions'!Q35","v":"2031-02-11"},{"$f":"'Staffing Assumptions'!I35","v":1},null,0,0,0,0,0.35342465753424657,1,1,1,1,1,null,"=MAX(MIN(J$7,$G24)-MAX(J$6,$F24)+1,0)*$H24/J$8"]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F36&\" \"&'Staffing Assumptions'!G36","v":"Ray O'Lyte"},{"$f":"'Staffing Assumptions'!L36","v":"2020-11-13"},{"$f":"'Staffing Assumptions'!Q36","v":"2027-02-04"},{"$f":"'Staffing Assumptions'!I36","v":1},null,0,0.13387978142076504,1,1,1,1,1,1,9.5890410958904104E-2,0,null,"=MAX(MIN(J$7,$G25)-MAX(J$6,$F25)+1,0)*$H25/J$8"]
[null,null,null,null,{"$f":"'Staffing Assumptions'!F37&\" \"&'Staffing Assumptions'!G37","v":"Lou Seat"},{"$f":"'Staffing Assumptions'!L37","v":"2023-07-12"},{"$f":"'Staffing Assumptions'!Q37","v":"2023-10-10"},{"$f":"'Staffing Assumptions'!I37","v":1},null,0,0,0,0,0.24931506849315069,0,0,0,0,0,null,"=MAX(MIN(J$7,$G26)-MAX(J$6,$F26)+1,0)*$H26/J$8"]
[]
[null,null,null,null,"FTEs",null,null,null,null,{"$f":"SUM(J18:J26)","v":0},{"$f":"SUM(K18:K26)","v":0.72131147540983609},3.2246575342465755,4.1671232876712327,6.3205479452054805,7,6.0821917808219172,6,5.095890410958904,5,null,"=SUM(J18:J26)"]
[]
[]
[null,{"$f":"MAX($B$10:$B30)+1","v":2},"Year Analysis"]
[]
[null,null,"Summary"]
[]
[null,null,null,"Year Counters (to Flag Salary Increases)"]
[]
[null,null,null,null,{"$f":"E17","v":"Name"}]
[null,null,null,null,{"$f":"E18","v":"Sally Army"},null,null,null,null,{"$f":"IF(AND(I18=0,J18<>0),1,IF(J18<>0,I38+(COUNTIF($I38:I38,I38)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J18=0,K18<>0),1,IF(K18<>0,J38+(COUNTIF($I38:J38,J38)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(K18=0,L18<>0),1,IF(L18<>0,K38+(COUNTIF($I38:K38,K38)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(L18=0,M18<>0),1,IF(M18<>0,L38+(COUNTIF($I38:L38,L38)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(M18=0,N18<>0),1,IF(N18<>0,M38+(COUNTIF($I38:M38,M38)=(Months_in_Year/Periodicity))*1,))","v":2},{"$f":"IF(AND(N18=0,O18<>0),1,IF(O18<>0,N38+(COUNTIF($I38:N38,N38)=(Months_in_Year/Periodicity))*1,))","v":3},{"$f":"IF(AND(O18=0,P18<>0),1,IF(P18<>0,O38+(COUNTIF($I38:O38,O38)=(Months_in_Year/Periodicity))*1,))","v":4},{"$f":"IF(AND(P18=0,Q18<>0),1,IF(Q18<>0,P38+(COUNTIF($I38:P38,P38)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(Q18=0,R18<>0),1,IF(R18<>0,Q38+(COUNTIF($I38:Q38,Q38)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(R18=0,S18<>0),1,IF(S18<>0,R38+(COUNTIF($I38:R38,R38)=(Months_in_Year/Periodicity))*1,))","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J38),\"\")","v":"=@IF(AND(I18=0,J18<>0),1,IF(J18<>0,I38+(COUNTIF($I38:I38,I38)=(Months_in_Year/Periodicity))*1,))"}]
[null,null,null,null,{"$f":"E19","v":"Whitney Bay"},null,null,null,null,{"$f":"IF(AND(I19=0,J19<>0),1,IF(J19<>0,I39+(COUNTIF($I39:I39,I39)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J19=0,K19<>0),1,IF(K19<>0,J39+(COUNTIF($I39:J39,J39)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(K19=0,L19<>0),1,IF(L19<>0,K39+(COUNTIF($I39:K39,K39)=(Months_in_Year/Periodicity))*1,))","v":2},{"$f":"IF(AND(L19=0,M19<>0),1,IF(M19<>0,L39+(COUNTIF($I39:L39,L39)=(Months_in_Year/Periodicity))*1,))","v":3},{"$f":"IF(AND(M19=0,N19<>0),1,IF(N19<>0,M39+(COUNTIF($I39:M39,M39)=(Months_in_Year/Periodicity))*1,))","v":4},{"$f":"IF(AND(N19=0,O19<>0),1,IF(O19<>0,N39+(COUNTIF($I39:N39,N39)=(Months_in_Year/Periodicity))*1,))","v":5},{"$f":"IF(AND(O19=0,P19<>0),1,IF(P19<>0,O39+(COUNTIF($I39:O39,O39)=(Months_in_Year/Periodicity))*1,))","v":6},{"$f":"IF(AND(P19=0,Q19<>0),1,IF(Q19<>0,P39+(COUNTIF($I39:P39,P39)=(Months_in_Year/Periodicity))*1,))","v":7},{"$f":"IF(AND(Q19=0,R19<>0),1,IF(R19<>0,Q39+(COUNTIF($I39:Q39,Q39)=(Months_in_Year/Periodicity))*1,))","v":8},{"$f":"IF(AND(R19=0,S19<>0),1,IF(S19<>0,R39+(COUNTIF($I39:R39,R39)=(Months_in_Year/Periodicity))*1,))","v":9},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J39),\"\")","v":"=@IF(AND(I19=0,J19<>0),1,IF(J19<>0,I39+(COUNTIF($I39:I39,I39)=(Months_in_Year/Periodicity))*1,))"}]
[null,null,null,null,"Wendy Boatcomesin",null,null,null,null,{"$f":"IF(AND(I20=0,J20<>0),1,IF(J20<>0,I40+(COUNTIF($I40:I40,I40)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J20=0,K20<>0),1,IF(K20<>0,J40+(COUNTIF($I40:J40,J40)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(K20=0,L20<>0),1,IF(L20<>0,K40+(COUNTIF($I40:K40,K40)=(Months_in_Year/Periodicity))*1,))","v":2},{"$f":"IF(AND(L20=0,M20<>0),1,IF(M20<>0,L40+(COUNTIF($I40:L40,L40)=(Months_in_Year/Periodicity))*1,))","v":3},{"$f":"IF(AND(M20=0,N20<>0),1,IF(N20<>0,M40+(COUNTIF($I40:M40,M40)=(Months_in_Year/Periodicity))*1,))","v":4},{"$f":"IF(AND(N20=0,O20<>0),1,IF(O20<>0,N40+(COUNTIF($I40:N40,N40)=(Months_in_Year/Periodicity))*1,))","v":5},{"$f":"IF(AND(O20=0,P20<>0),1,IF(P20<>0,O40+(COUNTIF($I40:O40,O40)=(Months_in_Year/Periodicity))*1,))","v":6},{"$f":"IF(AND(P20=0,Q20<>0),1,IF(Q20<>0,P40+(COUNTIF($I40:P40,P40)=(Months_in_Year/Periodicity))*1,))","v":7},{"$f":"IF(AND(Q20=0,R20<>0),1,IF(R20<>0,Q40+(COUNTIF($I40:Q40,Q40)=(Months_in_Year/Periodicity))*1,))","v":8},{"$f":"IF(AND(R20=0,S20<>0),1,IF(S20<>0,R40+(COUNTIF($I40:R40,R40)=(Months_in_Year/Periodicity))*1,))","v":9},null,"=@IF(AND(I20=0,J20<>0),1,IF(J20<>0,I40+(COUNTIF($I40:I40,I40)=(Months_in_Year/Periodicity))*1,))"]
[null,null,null,null,"Brianna Cracker",null,null,null,null,{"$f":"IF(AND(I21=0,J21<>0),1,IF(J21<>0,I41+(COUNTIF($I41:I41,I41)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J21=0,K21<>0),1,IF(K21<>0,J41+(COUNTIF($I41:J41,J41)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(K21=0,L21<>0),1,IF(L21<>0,K41+(COUNTIF($I41:K41,K41)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(L21=0,M21<>0),1,IF(M21<>0,L41+(COUNTIF($I41:L41,L41)=(Months_in_Year/Periodicity))*1,))","v":2},{"$f":"IF(AND(M21=0,N21<>0),1,IF(N21<>0,M41+(COUNTIF($I41:M41,M41)=(Months_in_Year/Periodicity))*1,))","v":3},{"$f":"IF(AND(N21=0,O21<>0),1,IF(O21<>0,N41+(COUNTIF($I41:N41,N41)=(Months_in_Year/Periodicity))*1,))","v":4},{"$f":"IF(AND(O21=0,P21<>0),1,IF(P21<>0,O41+(COUNTIF($I41:O41,O41)=(Months_in_Year/Periodicity))*1,))","v":5},{"$f":"IF(AND(P21=0,Q21<>0),1,IF(Q21<>0,P41+(COUNTIF($I41:P41,P41)=(Months_in_Year/Periodicity))*1,))","v":6},{"$f":"IF(AND(Q21=0,R21<>0),1,IF(R21<>0,Q41+(COUNTIF($I41:Q41,Q41)=(Months_in_Year/Periodicity))*1,))","v":7},{"$f":"IF(AND(R21=0,S21<>0),1,IF(S21<>0,R41+(COUNTIF($I41:R41,R41)=(Months_in_Year/Periodicity))*1,))","v":8},null,"=@IF(AND(I21=0,J21<>0),1,IF(J21<>0,I41+(COUNTIF($I41:I41,I41)=(Months_in_Year/Periodicity))*1,))"]
[null,null,null,null,"Mae June",null,null,null,null,{"$f":"IF(AND(I22=0,J22<>0),1,IF(J22<>0,I42+(COUNTIF($I42:I42,I42)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J22=0,K22<>0),1,IF(K22<>0,J42+(COUNTIF($I42:J42,J42)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(K22=0,L22<>0),1,IF(L22<>0,K42+(COUNTIF($I42:K42,K42)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(L22=0,M22<>0),1,IF(M22<>0,L42+(COUNTIF($I42:L42,L42)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(M22=0,N22<>0),1,IF(N22<>0,M42+(COUNTIF($I42:M42,M42)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(N22=0,O22<>0),1,IF(O22<>0,N42+(COUNTIF($I42:N42,N42)=(Months_in_Year/Periodicity))*1,))","v":2},{"$f":"IF(AND(O22=0,P22<>0),1,IF(P22<>0,O42+(COUNTIF($I42:O42,O42)=(Months_in_Year/Periodicity))*1,))","v":3},{"$f":"IF(AND(P22=0,Q22<>0),1,IF(Q22<>0,P42+(COUNTIF($I42:P42,P42)=(Months_in_Year/Periodicity))*1,))","v":4},{"$f":"IF(AND(Q22=0,R22<>0),1,IF(R22<>0,Q42+(COUNTIF($I42:Q42,Q42)=(Months_in_Year/Periodicity))*1,))","v":5},{"$f":"IF(AND(R22=0,S22<>0),1,IF(S22<>0,R42+(COUNTIF($I42:R42,R42)=(Months_in_Year/Periodicity))*1,))","v":6},null,"=@IF(AND(I22=0,J22<>0),1,IF(J22<>0,I42+(COUNTIF($I42:I42,I42)=(Months_in_Year/Periodicity))*1,))"]
[null,null,null,null,"Jerry Kann",null,null,null,null,{"$f":"IF(AND(I23=0,J23<>0),1,IF(J23<>0,I43+(COUNTIF($I43:I43,I43)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J23=0,K23<>0),1,IF(K23<>0,J43+(COUNTIF($I43:J43,J43)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(K23=0,L23<>0),1,IF(L23<>0,K43+(COUNTIF($I43:K43,K43)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(L23=0,M23<>0),1,IF(M23<>0,L43+(COUNTIF($I43:L43,L43)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(M23=0,N23<>0),1,IF(N23<>0,M43+(COUNTIF($I43:M43,M43)=(Months_in_Year/Periodicity))*1,))","v":2},{"$f":"IF(AND(N23=0,O23<>0),1,IF(O23<>0,N43+(COUNTIF($I43:N43,N43)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(O23=0,P23<>0),1,IF(P23<>0,O43+(COUNTIF($I43:O43,O43)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(P23=0,Q23<>0),1,IF(Q23<>0,P43+(COUNTIF($I43:P43,P43)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(Q23=0,R23<>0),1,IF(R23<>0,Q43+(COUNTIF($I43:Q43,Q43)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(R23=0,S23<>0),1,IF(S23<>0,R43+(COUNTIF($I43:R43,R43)=(Months_in_Year/Periodicity))*1,))","v":0},null,"=@IF(AND(I23=0,J23<>0),1,IF(J23<>0,I43+(COUNTIF($I43:I43,I43)=(Months_in_Year/Periodicity))*1,))"]
[null,null,null,null,"Bob Katt",null,null,null,null,{"$f":"IF(AND(I24=0,J24<>0),1,IF(J24<>0,I44+(COUNTIF($I44:I44,I44)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J24=0,K24<>0),1,IF(K24<>0,J44+(COUNTIF($I44:J44,J44)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(K24=0,L24<>0),1,IF(L24<>0,K44+(COUNTIF($I44:K44,K44)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(L24=0,M24<>0),1,IF(M24<>0,L44+(COUNTIF($I44:L44,L44)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(M24=0,N24<>0),1,IF(N24<>0,M44+(COUNTIF($I44:M44,M44)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(N24=0,O24<>0),1,IF(O24<>0,N44+(COUNTIF($I44:N44,N44)=(Months_in_Year/Periodicity))*1,))","v":2},{"$f":"IF(AND(O24=0,P24<>0),1,IF(P24<>0,O44+(COUNTIF($I44:O44,O44)=(Months_in_Year/Periodicity))*1,))","v":3},{"$f":"IF(AND(P24=0,Q24<>0),1,IF(Q24<>0,P44+(COUNTIF($I44:P44,P44)=(Months_in_Year/Periodicity))*1,))","v":4},{"$f":"IF(AND(Q24=0,R24<>0),1,IF(R24<>0,Q44+(COUNTIF($I44:Q44,Q44)=(Months_in_Year/Periodicity))*1,))","v":5},{"$f":"IF(AND(R24=0,S24<>0),1,IF(S24<>0,R44+(COUNTIF($I44:R44,R44)=(Months_in_Year/Periodicity))*1,))","v":6},null,"=@IF(AND(I24=0,J24<>0),1,IF(J24<>0,I44+(COUNTIF($I44:I44,I44)=(Months_in_Year/Periodicity))*1,))"]
[null,null,null,null,"Ray O'Lyte",null,null,null,null,{"$f":"IF(AND(I25=0,J25<>0),1,IF(J25<>0,I45+(COUNTIF($I45:I45,I45)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J25=0,K25<>0),1,IF(K25<>0,J45+(COUNTIF($I45:J45,J45)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(K25=0,L25<>0),1,IF(L25<>0,K45+(COUNTIF($I45:K45,K45)=(Months_in_Year/Periodicity))*1,))","v":2},{"$f":"IF(AND(L25=0,M25<>0),1,IF(M25<>0,L45+(COUNTIF($I45:L45,L45)=(Months_in_Year/Periodicity))*1,))","v":3},{"$f":"IF(AND(M25=0,N25<>0),1,IF(N25<>0,M45+(COUNTIF($I45:M45,M45)=(Months_in_Year/Periodicity))*1,))","v":4},{"$f":"IF(AND(N25=0,O25<>0),1,IF(O25<>0,N45+(COUNTIF($I45:N45,N45)=(Months_in_Year/Periodicity))*1,))","v":5},{"$f":"IF(AND(O25=0,P25<>0),1,IF(P25<>0,O45+(COUNTIF($I45:O45,O45)=(Months_in_Year/Periodicity))*1,))","v":6},{"$f":"IF(AND(P25=0,Q25<>0),1,IF(Q25<>0,P45+(COUNTIF($I45:P45,P45)=(Months_in_Year/Periodicity))*1,))","v":7},{"$f":"IF(AND(Q25=0,R25<>0),1,IF(R25<>0,Q45+(COUNTIF($I45:Q45,Q45)=(Months_in_Year/Periodicity))*1,))","v":8},{"$f":"IF(AND(R25=0,S25<>0),1,IF(S25<>0,R45+(COUNTIF($I45:R45,R45)=(Months_in_Year/Periodicity))*1,))","v":0},null,"=@IF(AND(I25=0,J25<>0),1,IF(J25<>0,I45+(COUNTIF($I45:I45,I45)=(Months_in_Year/Periodicity))*1,))"]
[null,null,null,null,"Lou Seat",null,null,null,null,{"$f":"IF(AND(I26=0,J26<>0),1,IF(J26<>0,I46+(COUNTIF($I46:I46,I46)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(J26=0,K26<>0),1,IF(K26<>0,J46+(COUNTIF($I46:J46,J46)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(K26=0,L26<>0),1,IF(L26<>0,K46+(COUNTIF($I46:K46,K46)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(L26=0,M26<>0),1,IF(M26<>0,L46+(COUNTIF($I46:L46,L46)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(M26=0,N26<>0),1,IF(N26<>0,M46+(COUNTIF($I46:M46,M46)=(Months_in_Year/Periodicity))*1,))","v":1},{"$f":"IF(AND(N26=0,O26<>0),1,IF(O26<>0,N46+(COUNTIF($I46:N46,N46)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(O26=0,P26<>0),1,IF(P26<>0,O46+(COUNTIF($I46:O46,O46)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(P26=0,Q26<>0),1,IF(Q26<>0,P46+(COUNTIF($I46:P46,P46)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(Q26=0,R26<>0),1,IF(R26<>0,Q46+(COUNTIF($I46:Q46,Q46)=(Months_in_Year/Periodicity))*1,))","v":0},{"$f":"IF(AND(R26=0,S26<>0),1,IF(S26<>0,R46+(COUNTIF($I46:R46,R46)=(Months_in_Year/Periodicity))*1,))","v":0},null,"=@IF(AND(I26=0,J26<>0),1,IF(J26<>0,I46+(COUNTIF($I46:I46,I46)=(Months_in_Year/Periodicity))*1,))"]
[]
[]
[null,{"$f":"MAX($B$10:$B48)+1","v":3},"OTE Salary Analysis"]
[]
[null,null,"Summary"]
[]
[null,null,null,"OTE Annual Salary By Staff Member"]
[]
[null,null,null,null,{"$f":"E17","v":"Name"},{"$f":"'Staffing Assumptions'!J28","v":"Initial Salary (OTE)"},{"$f":"'Staffing Assumptions'!K28","v":"Annual Increase"}]
[null,null,null,null,{"$f":"E18","v":"Sally Army"},{"$f":"'Staffing Assumptions'!J29","v":56472},{"$f":"'Staffing Assumptions'!K29","v":3.0937187527005305E-2},null,null,{"$f":"IF(AND(I38=0,J38=1),$F56,I56*(J38<>0)*(1+($G56*(I38<>J38))))","v":0},{"$f":"IF(AND(J38=0,K38=1),$F56,J56*(K38<>0)*(1+($G56*(J38<>K38))))","v":0},0,56472,58219.084854025037,60020.219599804637,61877.076388975831,0,0,0,null,"=IF(AND(I38=0,J38=1),$F56,I56*(J38<>0)*(1+($G56*(I38<>J38))))"]
[null,null,null,null,{"$f":"E19","v":"Whitney Bay"},{"$f":"'Staffing Assumptions'!J30","v":33723},{"$f":"'Staffing Assumptions'!K30","v":1.8889412614370896E-2},null,null,{"$f":"IF(AND(I39=0,J39=1),$F57,I57*(J39<>0)*(1+($G57*(I39<>J39))))","v":0},33723,34360.007661594427,35009.048023747229,35670.348377104114,36344.140305697583,37030.659768046491,37730.147179787506,38442.847497867449,39169.010306326003,null,"=IF(AND(I39=0,J39=1),$F57,I57*(J39<>0)*(1+($G57*(I39<>J39))))"]
[null,null,null,null,"Wendy Boatcomesin",{"$f":"'Staffing Assumptions'!J31","v":23265},{"$f":"'Staffing Assumptions'!K31","v":2.8753096326274492E-2},null,null,0,23265,23933.940786030777,24622.115690918872,25330.077755136539,26058.395920782004,26807.65548880045,27578.45858935151,28371.424665701306,29187.190972027856,null,"=IF(AND(I40=0,J40=1),$F58,I58*(J40<>0)*(1+($G58*(I40<>J40))))"]
[null,null,null,null,"Brianna Cracker",{"$f":"'Staffing Assumptions'!J32","v":21391},{"$f":"'Staffing Assumptions'!K32","v":2.0390658033434318E-3},null,null,0,0,21391,21434.617656599319,21478.324252470629,21522.119968966963,21566.004987811135,21609.979491096514,21654.04366128776,21698.197681221594,null,"=IF(AND(I41=0,J41=1),$F59,I59*(J41<>0)*(1+($G59*(I41<>J41))))"]
[null,null,null,null,"Mae June",{"$f":"'Staffing Assumptions'!J33","v":57155},{"$f":"'Staffing Assumptions'!K33","v":5.0244771748174247E-3},null,null,0,0,0,0,57155,57442.173992926684,57730.790885026028,58020.857926111996,58312.382402425064,58605.371636815267,null,"=IF(AND(I42=0,J42=1),$F60,I60*(J42<>0)*(1+($G60*(I42<>J42))))"]
[null,null,null,null,"Jerry Kann",{"$f":"'Staffing Assumptions'!J34","v":57977},{"$f":"'Staffing Assumptions'!K34","v":2.8850353192281235E-2},null,null,0,0,0,57977,59649.656927028889,0,0,0,0,0,null,"=IF(AND(I43=0,J43=1),$F61,I61*(J43<>0)*(1+($G61*(I43<>J43))))"]
[null,null,null,null,"Bob Katt",{"$f":"'Staffing Assumptions'!J35","v":54590},{"$f":"'Staffing Assumptions'!K35","v":3.1175556179279151E-2},null,null,0,0,0,0,54590,56291.873611826857,58046.804080049253,59856.445481674447,61722.503460480351,63646.736834638315,null,"=IF(AND(I44=0,J44=1),$F62,I62*(J44<>0)*(1+($G62*(I44<>J44))))"]
[null,null,null,null,"Ray O'Lyte",{"$f":"'Staffing Assumptions'!J36","v":48518},{"$f":"'Staffing Assumptions'!K36","v":5.1430833125731745E-3},null,null,0,48518,48767.532116159426,49018.347596781423,49270.453042316338,49523.855087161195,49778.560399834263,50034.575683150564,50291.907674398259,0,null,"=IF(AND(I45=0,J45=1),$F63,I63*(J45<>0)*(1+($G63*(I45<>J45))))"]
[null,null,null,null,"Lou Seat",{"$f":"'Staffing Assumptions'!J37","v":52561},{"$f":"'Staffing Assumptions'!K37","v":1.0951899738888392E-2},null,null,0,0,0,0,52561,0,0,0,0,0,null,"=IF(AND(I46=0,J46=1),$F64,I64*(J46<>0)*(1+($G64*(I46<>J46))))"]
[]
[]
[null,null,null,"OTE Salary for Period By Staff Member"]
[]
[null,null,null,null,{"$f":"E17","v":"Name"}]
[null,null,null,null,{"$f":"E18","v":"Sally Army"},null,null,null,null,{"$f":"J56*MIN(J$8/Days_in_Year,1)","v":0},0,0,56472,58219.084854025037,60020.219599804637,61877.076388975831,0,0,0,null,"=J56*MIN(J$8/Days_in_Year,1)"]
[null,null,null,null,{"$f":"E19","v":"Whitney Bay"},null,null,null,null,{"$f":"J57*MIN(J$8/Days_in_Year,1)","v":0},33723,34360.007661594427,35009.048023747229,35670.348377104114,36344.140305697583,37030.659768046491,37730.147179787506,38442.847497867449,39169.010306326003,null,"=J57*MIN(J$8/Days_in_Year,1)"]
[null,null,null,null,"Wendy Boatcomesin",null,null,null,null,{"$f":"J58*MIN(J$8/Days_in_Year,1)","v":0},23265,23933.940786030777,24622.115690918872,25330.077755136539,26058.395920782004,26807.65548880045,27578.45858935151,28371.424665701306,29187.190972027856,null,"=J58*MIN(J$8/Days_in_Year,1)"]
[null,null,null,null,"Brianna Cracker",null,null,null,null,{"$f":"J59*MIN(J$8/Days_in_Year,1)","v":0},0,21391,21434.617656599319,21478.324252470629,21522.119968966963,21566.004987811135,21609.979491096514,21654.04366128776,21698.197681221594,null,"=J59*MIN(J$8/Days_in_Year,1)"]
[null,null,null,null,"Mae June",null,null,null,null,{"$f":"J60*MIN(J$8/Days_in_Year,1)","v":0},0,0,0,57155,57442.173992926684,57730.790885026028,58020.857926111996,58312.382402425064,58605.371636815267,null,"=J60*MIN(J$8/Days_in_Year,1)"]
[null,null,null,null,"Jerry Kann",null,null,null,null,{"$f":"J61*MIN(J$8/Days_in_Year,1)","v":0},0,0,57977,59649.656927028889,0,0,0,0,0,null,"=J61*MIN(J$8/Days_in_Year,1)"]
[null,null,null,null,"Bob Katt",null,null,null,null,{"$f":"J62*MIN(J$8/Days_in_Year,1)","v":0},0,0,0,54590,56291.873611826857,58046.804080049253,59856.445481674447,61722.503460480351,63646.736834638315,null,"=J62*MIN(J$8/Days_in_Year,1)"]
[null,null,null,null,"Ray O'Lyte",null,null,null,null,{"$f":"J63*MIN(J$8/Days_in_Year,1)","v":0},48518,48767.532116159426,49018.347596781423,49270.453042316338,49523.855087161195,49778.560399834263,50034.575683150564,50291.907674398259,0,null,"=J63*MIN(J$8/Days_in_Year,1)"]
[null,null,null,null,"Lou Seat",null,null,null,null,{"$f":"J64*MIN(J$8/Days_in_Year,1)","v":0},0,0,0,52561,0,0,0,0,0,null,"=J64*MIN(J$8/Days_in_Year,1)"]
[]
[]
[null,{"$f":"MAX($B$10:$B80)+1","v":4},"Actual Salary Analysis"]
[]
[null,null,"Summary"]
[]
[null,null,null,"Actual Periodic Salary By Staff Member"]
[]
[null,null,null,null,{"$f":"E17","v":"Name"}]
[null,null,null,null,{"$f":"E18","v":"Sally Army"},null,null,null,null,{"$f":"J70*J18","v":0},{"$f":"K70*K18","v":0},0,4022.66301369863,58219.084854025037,60020.219599804637,5085.7871004637664,0,0,0,null,"=J70*J18"]
[null,null,null,null,{"$f":"E19","v":"Whitney Bay"},null,null,null,null,{"$f":"J71*J19","v":0},8845.377049180328,34360.007661594427,35009.048023747229,35670.348377104114,36344.140305697583,37030.659768046491,37730.147179787506,38442.847497867449,39169.010306326003,null,"=J71*J19"]
[null,null,null,null,"Wendy Boatcomesin",null,null,null,null,0,7564.3032786885242,23933.940786030777,24622.115690918872,25330.077755136539,26058.395920782004,26807.65548880045,27578.45858935151,28371.424665701306,29187.190972027856,null,"=J72*J20"]
[null,null,null,null,"Brianna Cracker",null,null,null,null,0,0,4805.6493150684928,21434.617656599319,21478.324252470629,21522.119968966963,21566.004987811135,21609.979491096514,21654.04366128776,21698.197681221594,null,"=J73*J21"]
[null,null,null,null,"Mae June",null,null,null,null,0,0,0,0,32257.342465753427,57442.173992926684,57730.790885026028,58020.857926111996,58312.382402425064,58605.371636815267,null,"=J74*J22"]
[null,null,null,null,"Jerry Kann",null,null,null,null,0,0,0,5559.4383561643835,9151.7281860647072,0,0,0,0,0,null,"=J75*J23"]
[null,null,null,null,"Bob Katt",null,null,null,null,0,0,0,0,19293.452054794521,56291.873611826857,58046.804080049253,59856.445481674447,61722.503460480351,63646.736834638315,null,"=J76*J24"]
[null,null,null,null,"Ray O'Lyte",null,null,null,null,0,6495.579234972678,48767.532116159426,49018.347596781423,49270.453042316338,49523.855087161195,49778.560399834263,50034.575683150564,4822.5116948053119,0,null,"=J77*J25"]
[null,null,null,null,"Lou Seat",null,null,null,null,0,0,0,0,13104.249315068493,0,0,0,0,0,null,"=J78*J26"]
[]
[null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(J88:J96)","v":0},{"$f":"SUM(K88:K96)","v":22905.259562841529},111867.12987885313,139666.23033790986,263775.06030273385,307202.77848716592,256046.26271003138,254830.46435117253,213325.71338256725,212306.50743102902,null,"=SUM(J88:J96)"]
[]
[null,null,null,null,"Average Salary per FTE",null,null,null,null,{"$f":"IF(J28,J98/J28,)","v":0},{"$f":"IF(K28,K98/K28,)","v":31755.018939393936},34691.166020205092,33516.222270438593,41732.941920458536,43886.111212452277,42097.696346469129,42471.744058528755,41862.303970234971,42461.301486205804,0,{"$error":"#VALUE!"},0,0,0,0,0,0,0]

{"sheet":"Timing","index":6,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,8,0,9],[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 Pro-Rating Over Time Example.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":"2019-12-31"},{"$f":"K$7","v":"2020-12-31"},{"$f":"L$7","v":"2021-12-31"},{"$f":"M$7","v":"2022-12-31"},{"$f":"N$7","v":"2023-12-31"},{"$f":"O$7","v":"2024-12-31"},"2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2019-01-01"},"2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-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":"2019-12-31"},"2020-12-31","2021-12-31","2022-12-31","2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":365},{"$f":"K7-K6+1","v":366},365,365,365,{"$f":"O7-O6+1","v":366},365,365,365,366]
[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,{"$f":"N(N$9)+1","v":6},{"$f":"N(O$9)+1","v":7},{"$f":"N(P$9)+1","v":8},{"$f":"N(Q$9)+1","v":9},{"$f":"N(R$9)+1","v":10}]
[]
[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":"DATE(YEAR(TODAY()),1,1)","v":"2019-01-01"}]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,12]
[]
[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-19"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":12}]
[]
[null,null,null,"Months per Year",null,null,null,12]

{"sheet":"Error Checks","index":7,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,8,0,9],[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 Pro-Rating Over Time Example.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,"Unused"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]