{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Quick Start","Instructions","Instructions & Input","Calculations","Dashboard","Dynamic Charts","Forecast 6 months","Forecast 3 months","Drop Down Entry","Dashboard 3 months","Dashboard 6 months"],"not_rendered":{"charts":21,"images":7,"macros":1,"external_links":0,"defined_names":21,"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":"Quick Start","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,2,9,3],[6,6,7,6]]}
[]
[]
[]
[]
[]
[null,null,"Version 2.0",null,null,null,"LEGEND:"]
[null,null,null,null,null,null,"Required Input"]
[]
[null,"Select your airport Hub Size:","Medium"]
[null,"Enter the month and year you would like the forecast to start on (defaults to NEXT month with RESET):",{"$f":"EOMONTH(TODAY(),0)+1","v":"2022-05-01"}]
[null,"Enter the number of active security badges currently issued:",15000]
[null,null,{"$f":"DATE(YEAR(D12),MONTH(D12)-1,DAY(D12))","v":"2021-11-01"},"2021-12-01","2022-01-01","2022-02-01",{"$f":"DATE(YEAR(H12),MONTH(H12)-1,DAY(H12))","v":"2022-03-01"},{"$f":"DATE(YEAR(C10),MONTH(C10)-1,DAY(C10))","v":"2022-04-01"}]
[null,"Enter the number of new security badges issued in the six months prior to the forecast start date:",100,80,60,40,100,100]
[null,null,{"$f":"C12","v":"2021-11-01"},"2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01"]
[null,"Enter the number of security badges renewed in the six months prior to the forecast start date:",150,200,175,80,100,110]
[null,null,{"$f":"DATE(YEAR(C10),MONTH(C10),DAY(C10))","v":"2022-05-01"},{"$f":"DATE(YEAR(C16),MONTH(C16)+1,DAY(C16))","v":"2022-06-01"},{"$f":"DATE(YEAR(D16),MONTH(D16)+1,DAY(D16))","v":"2022-07-01"},{"$f":"DATE(YEAR(E16),MONTH(E16)+1,DAY(E16))","v":"2022-08-01"},{"$f":"DATE(YEAR(F16),MONTH(F16)+1,DAY(F16))","v":"2022-09-01"},{"$f":"DATE(YEAR(G16),MONTH(G16)+1,DAY(G16))","v":"2022-10-01"}]
[null,"*OPTIONAL - enter any large enrollments planned for the six months after the forecast start date:",0,0,0,0,0,0]
[null,null,{"$f":"C12","v":"2021-11-01"},{"$f":"D12","v":"2021-12-01"},"2022-01-01","2022-02-01","2022-03-01","2022-04-01"]
[null,"Enter the number of terminated/expired badges for the last six months prior to forecast start date:",50,40,30,20,45,50]
[null,"Enter the number of Managers and/or Supervisors currently working in the Credentialing Office:",2]
[null,"Enter the number of Administrative Staff currently working in the Credentialing Office:",2]
[null,"Enter the number of Badge Processing Staff currently working in the Credentialing Office:",5]

{"sheet":"Instructions","index":1,"n_rows":66,"n_cols":25,"rows_kept":66,"cut":false,"hidden":false,"merged":[[46,8,46,9],[43,8,43,9],[65,3,68,11]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"'Quick Start'!C6","v":"Version 2.0"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Last 6 Months"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecast next 6 months"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"This Staff Forecasting Tool was developed by The JW Group, Inc. under the Safe Skies PARAS 0036 Airport Credentialing Toolkit contract. The tool is intended to supply general information only, not specific professional or personal advice, and is not intended to be used as a substitute for any kind of professional advice. Use this tool either in whole or in part as a basis and guide for staff forecasting. "]

{"sheet":"Instructions & Input","index":2,"n_rows":48,"n_cols":23,"rows_kept":48,"cut":false,"hidden":true,"merged":[[49,3,49,4],[52,3,52,4],[7,11,8,11],[12,4,12,5],[13,3,13,4],[14,3,14,9],[14,10,14,15]]}
["{Not for Public View}"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ENTER AIRPORT HUB SIZE",null,null,null," "]
[null,null,null,"Select from drop-down menu",{"$f":"'Quick Start'!C9","v":"Medium"},null,null," "," "]
[null,null,null,"ENTER MONTH AND YEAR TO START FORECAST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Month and  Year (MMM-YYYY Format)",{"$f":"'Quick Start'!C10","v":"2022-05-01"},null,null," "]
[null,null,null," "]
[null,null,null,"ENTER 6 MONTHS OF HISTORICAL DATA:",null,null,null,null,null,null,"Forecast",null,null,null,null,null," "," "]
[null,null,null," ",{"$f":"DATE(YEAR(F16),MONTH(F16)-1,DAY(F16))","v":"2021-11-01"},"2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01",{"$f":"E13","v":"2022-05-01"},{"$f":"DATE(YEAR(K16),MONTH(K16)+1,DAY(K16))","v":"2022-06-01"},"2022-07-01","2022-08-01","2022-09-01","2022-10-01"]
[null,null,null,"Supervisor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Last 6 Months"]
[null,null,null,"Admin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecast next 6 months"]
[null,null,null,"Applications/Renewal Staff"]
[null,null,null,"Training Staff"]
[null,null,null,"Reporting"]
[null,null,null,"Total FTE"]
[null,null,null,"+/-"]
[null,null,null,"Variable Constraints"]
[null,null,null,"New Contract/Vendor (#EMPL)",null,null,null,null,null,null,null,null,null,50,50,50]
[null,null,null,"Seasonality (+/- # EMP)",null,null,null,null,null,null,400,300,100,0,0,0]
[]
[]
[null,null,null,"HISTORICAL DATA - INPUTS"]
[null,null,null,"Total # Badges",{"$f":"F30-F31+F33","v":14805},14845,14875,14895,{"$f":"J30-J31+J33","v":14950},{"$f":"'Quick Start'!C11","v":15000},{"$f":"'Dynamic Charts'!C25","v":15017.289836619739},{"$f":"'Dynamic Charts'!C26","v":15061.003498883925},{"$f":"'Dynamic Charts'!C27","v":15104.717161148112},{"$f":"'Dynamic Charts'!C28","v":15148.430823412298},{"$f":"'Dynamic Charts'!C29","v":15192.144485676485},{"$f":"'Dynamic Charts'!C30","v":15235.858147940671},null," ",null,null,null,null," "]
[null,null,null,"Total #  New Applicants",{"$f":"'Quick Start'!C13","v":100},{"$f":"'Quick Start'!D13","v":80},{"$f":"'Quick Start'!E13","v":60},{"$f":"'Quick Start'!F13","v":40},{"$f":"'Quick Start'!G13","v":100},{"$f":"'Quick Start'!H13","v":100}]
[null,null,null,"Total # Renewals",{"$f":"'Quick Start'!C15","v":150},{"$f":"'Quick Start'!D15","v":200},{"$f":"'Quick Start'!E15","v":175},{"$f":"'Quick Start'!F15","v":80},{"$f":"'Quick Start'!G15","v":100},{"$f":"'Quick Start'!H15","v":110}]
[null,null,null,"Total # Terminated/Expired Badges",{"$f":"'Quick Start'!C19","v":50},{"$f":"'Quick Start'!D19","v":40},{"$f":"'Quick Start'!E19","v":30},{"$f":"'Quick Start'!F19","v":20},{"$f":"'Quick Start'!G19","v":45},{"$f":"'Quick Start'!H19","v":50}]
[null,null,null,"Cumlative Badges",{"$f":"E30-E31+E33","v":14755},14805,14845,14875,14895,{"$f":"J30","v":15000}]
[null,null,null,"Actual Staff on Hand",null,null,null,null,null,{"$f":"E48","v":9}]
[null,null,null,"Forecasted Staff",null,null,null,null,null,null,{"$f":"'Dynamic Charts'!E69","v":9.1},{"$f":"'Dynamic Charts'!E70","v":9.1},{"$f":"'Dynamic Charts'!E71","v":9.1},{"$f":"'Dynamic Charts'!E72","v":9.1999999999999993},{"$f":"'Dynamic Charts'!E73","v":9.1999999999999993},{"$f":"'Dynamic Charts'!E74","v":9.1999999999999993}]
[null,null,null,"#Badges Processed per Month",{"$f":"SUM(E31:E32)","v":250},{"$f":"SUM(F31:F32)","v":280},235,120,200,210,null,null," "," "," "," "]
[null,null,null,"Enter   Temporary or  Unplanned Badge Demand within Next 6 Months:"]
[null,null,null,null,{"$f":"DATE(YEAR(K16),MONTH(K16),DAY(K16))","v":"2022-05-01"},{"$f":"DATE(YEAR(L16),MONTH(L16),DAY(L16))","v":"2022-06-01"},"2022-07-01","2022-08-01","2022-09-01","2022-10-01"]
[null,null,null,"Total Monthly Unplanned New Badge Demand*",{"$f":"'Quick Start'!C17","v":0},{"$f":"'Quick Start'!D17","v":0},{"$f":"'Quick Start'!E17","v":0},{"$f":"'Quick Start'!F17","v":0},0,0]
[null,null,null,"* such as new tenants, capital projects,etc."]
[]
[null,null,null,"EXISTING POSITIONS TODAY (INPUT)"]
[null,null,null,"CURRENT STAFFING (Provide Input)","QTY"]
[null,null,null,"Manager/Supervisor",{"$f":"'Quick Start'!C20","v":2}]
[null,null,null,"Admin",{"$f":"'Quick Start'!C21","v":2}]
[null,null,null,"Badge Processing Staff",{"$f":"'Quick Start'!C22","v":5}]
[null,null,null,"TOTAL CURRENT STAFFING",{"$f":"SUM(E45:E47)","v":9}]

{"sheet":"Calculations","index":3,"n_rows":128,"n_cols":26,"rows_kept":128,"cut":false,"hidden":false,"merged":[[114,6,114,8],[99,6,99,8],[17,13,17,18],[48,6,48,7],[14,7,14,8],[52,6,52,7],[15,7,15,8],[17,6,17,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!H8","v":"Version 2.0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"ENTER AIRPORT HUB SIZE",null,null,null," "]
[null,null,null,"LEGEND:",null,null,"Select from drop-down menu","Large",null,null," "," "]
[null,null,null,null,null,null,"ENTER MONTH AND YEAR TO START FORECAST & SELECT FORECAST PERIOD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Auto generated",null,"Month and  Year (MMM-YYYY Format)",{"$f":"'Instructions & Input'!E13","v":"2022-05-01"}]
[null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,"PRIOR 6 MONTH OF HISTORICAL DATA PROVIDED ",null,null,null,null,null,null,"Forecast",null,null,null,null,null," "," "]
[null,null,null,null,null,null," ",{"$f":"DATE(YEAR(I19),MONTH(I19)-1,DAY(I19))","v":"2021-11-01"},"2021-12-01","2022-01-01","2022-02-01","2022-03-01",{"$f":"DATE(YEAR(N19),MONTH(N19)-1,DAY(N19))","v":"2022-04-01"},{"$f":"H15","v":"2022-05-01"},{"$f":"DATE(YEAR(N19),MONTH(N19)+1,DAY(N19))","v":"2022-06-01"},"2022-07-01","2022-08-01","2022-09-01","2022-10-01"]
[null,null,null,null,null,null,"Supervisor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Last 6 Months"]
[null,null,null,null,null,null,"Admin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecast next 6 months"]
[null,null,null,null,null,null,"Applications/Renewal Staff"]
[null,null,null,null,null,null,"Training Staff"]
[null,null,null,null,null,null,"Reporting"]
[null,null,null,null,null,null,"Total FTE"]
[null,null,null,null,null,null,"+/-"]
[null,null,null,null,null,null,"Variable Constraints"]
[null,null,null,null,null,null,"New Contract/Vendor (#EMPL)",null,null,null,null,null,null,null,null,null,50,50,50]
[null,null,null,null,null,null,"Seasonality (+/- # EMP)",null,null,null,null,null,null,400,300,100,0,0,0]
[]
[]
[null,null,null,null,null,null,"Historical Metrics Data"]
[null,null,null,null,null,null,"Total # Badges (Reduced to include # Terminated/Expired badges)",{"$f":"'Instructions & Input'!E34","v":14755},{"$f":"'Instructions & Input'!F34","v":14805},{"$f":"'Instructions & Input'!G34","v":14845},{"$f":"'Instructions & Input'!H34","v":14875},{"$f":"'Instructions & Input'!I34","v":14895},{"$f":"'Instructions & Input'!J34","v":15000},{"$f":"'Dynamic Charts'!C25","v":15017.289836619739},{"$f":"'Dynamic Charts'!C26","v":15061.003498883925},{"$f":"'Dynamic Charts'!C27","v":15104.717161148112},{"$f":"'Dynamic Charts'!C28","v":15148.430823412298},{"$f":"'Dynamic Charts'!C29","v":15192.144485676485},{"$f":"'Dynamic Charts'!C30","v":15235.858147940671},null," ",null,null,null,null," "]
[null,null,null,null,null,null,"Total #  New Applicants",{"$f":"'Instructions & Input'!E31","v":100},{"$f":"'Instructions & Input'!F31","v":80},{"$f":"'Instructions & Input'!G31","v":60},{"$f":"'Instructions & Input'!H31","v":40},{"$f":"'Instructions & Input'!I31","v":100},{"$f":"'Instructions & Input'!J31","v":100}]
[null,null,null,null,null,null,"Total # Renewals",{"$f":"'Instructions & Input'!E32","v":150},{"$f":"'Instructions & Input'!F32","v":200},{"$f":"'Instructions & Input'!G32","v":175},{"$f":"'Instructions & Input'!H32","v":80},{"$f":"'Instructions & Input'!I32","v":100},{"$f":"'Instructions & Input'!J32","v":110}]
[null,null,null,null,null,null,"Cumlative Badges",{"$f":"H33","v":14755},{"$f":"I33","v":14805},{"$f":"J33","v":14845},{"$f":"K33","v":14875},14895,{"$f":"M33","v":15000}]
[null,null,null,null,null,null,"Optional: Short-Term Badge Enrollment Demand",null,null,null,null,null," ",{"$f":"'Quick Start'!C17","v":0},{"$f":"'Quick Start'!D17","v":0},{"$f":"'Quick Start'!E17","v":0},{"$f":"'Quick Start'!F17","v":0},{"$f":"'Quick Start'!G17","v":0},{"$f":"'Quick Start'!H17","v":0}]
[null,null,null,null,null,null,"Actual Staff on Hand",null,null,null,null,null,{"$f":"H47","v":9}]
[null,null,null,null,null,null,"Forecasted Staff",null,null,null,null,null,null,{"$f":"'Dynamic Charts'!E69","v":9.1},{"$f":"'Dynamic Charts'!E70","v":9.1},{"$f":"'Dynamic Charts'!E71","v":9.1},{"$f":"'Dynamic Charts'!E72","v":9.1999999999999993},{"$f":"'Dynamic Charts'!E73","v":9.1999999999999993},{"$f":"'Dynamic Charts'!E74","v":9.1999999999999993}]
[null,null,null,null,null,null,"# Badges Processed per Month",{"$f":"SUM(H34:H35)","v":250},{"$f":"SUM(I34:I35)","v":280},235,120,200,210,null,null," "," "," "," "]
[]
[null,null,null,null,null,null,"EXISTING POSITIONS TODAY (INPUT)"]
[null,null,null,null,null,null,"Positions Filled (Provided Input)","QTY"]
[null,null,null,null,null,null,"Supervisor (Overhead)",{"$f":"'Instructions & Input'!E45","v":2}]
[null,null,null,null,null,null,"Admin(Overhead)",{"$f":"'Instructions & Input'!E46","v":2}]
[null,null,null,null,null,null,"Badge Processing Staff",{"$f":"'Instructions & Input'!E47","v":5}]
[null,null,null,null,null,null,"TOTAL FTE",{"$f":"SUM(H44:H46)","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","# Badges","Staffing"]
[null,null,null,null,null,null,"Historical Last 6 month average (Automatic)",null,null,null,null,null,null,{"$f":"'Dynamic Charts'!A63","v":"2021-11-01"},{"$f":"'Dynamic Charts'!B63","v":14755},{"$f":"'Dynamic Charts'!E63:E74","v":9}]
[null,null,null,null,null," ","Monthly # New Applicants + # Renewals",{"$f":"ROUND(AVERAGE(H40:M40),0)","v":216},null,null,null,null,null,{"$f":"'Dynamic Charts'!A64","v":"2021-12-01"},{"$f":"'Dynamic Charts'!B64","v":14805},9]
[null,null,null,null,null,null,"Monthly Demand per Badge Population %",{"$f":"H50/AVERAGE(H33:M33)","v":1.4533221194280908E-2},null,null,null,null,null,{"$f":"'Dynamic Charts'!A65","v":"2022-01-01"},{"$f":"'Dynamic Charts'!B65","v":14845},9]
[null,null,null,null,null," ","Monthly # Badges Processed Per Employee",{"$f":"ROUND(H50/H47,0)","v":24},null,null,null,null,null,{"$f":"'Dynamic Charts'!A66","v":"2022-02-01"},{"$f":"'Dynamic Charts'!B66","v":14875},9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dynamic Charts'!A67","v":"2022-03-01"},{"$f":"'Dynamic Charts'!B67","v":14895},9]
[null,null,null,null,null," ","Monthly # Badges Processed Per Employee",{"$f":"_xlfn.IFS('Instructions & Input'!E11=\"Large\", 175,'Instructions & Input'!E11=\"Medium\",87,'Instructions & Input'!E11=\"Small\",76)","v":87},null,null,null,null,null,{"$f":"'Dynamic Charts'!A68","v":"2022-04-01"},{"$f":"'Dynamic Charts'!B68","v":15000},9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dynamic Charts'!A69","v":"2022-05-01"},{"$f":"'Dynamic Charts'!B69","v":15017.289836619739},9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dynamic Charts'!A70","v":"2022-06-01"},{"$f":"'Dynamic Charts'!B70","v":15061.003498883925},9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dynamic Charts'!A71","v":"2022-07-01"},{"$f":"'Dynamic Charts'!B71","v":15104.717161148112},9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dynamic Charts'!A72","v":"2022-08-01"},{"$f":"'Dynamic Charts'!B72","v":15148.430823412298},9.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dynamic Charts'!A73","v":"2022-09-01"},{"$f":"'Dynamic Charts'!B73","v":15192.144485676485},9.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dynamic Charts'!A74","v":"2022-10-01"},{"$f":"'Dynamic Charts'!B74","v":15235.858147940671},9.1999999999999993]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"FORMATTED INPUT DATA SET FOR FORECAST (Automatic)"]
[null,null,null,null,null,null,"DATE","# Badges","# Forecast Badges"]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A35","v":"2021-11-01"},{"$f":"H36","v":14755}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A36","v":"2021-12-01"},{"$f":"I36","v":14805}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A37","v":"2022-01-01"},{"$f":"J36","v":14845}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A38","v":"2022-02-01"},{"$f":"K36","v":14875}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A39","v":"2022-03-01"},{"$f":"L36","v":14895}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A40","v":"2022-04-01"},{"$f":"M36","v":15000},{"$f":"H107","v":15000}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A41","v":"2022-05-01"}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A42","v":"2022-06-01"}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A43","v":"2022-07-01"}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A44","v":"2022-08-01"}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A45","v":"2022-09-01"}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A46","v":"2022-10-01"}]
[]
[null,null,null,null,null,null,"GENERATED MONTHLY STAFF FORECAST"]
[null,null,null,null,null,null,"DATE",{"$f":"'Forecast 6 months'!B34","v":"# Badges"},{"$f":"'Forecast 6 months'!C34","v":"#Staff"}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A35","v":"2021-11-01"},{"$f":"'Forecast 6 months'!B35","v":14755},{"$f":"'Forecast 6 months'!C35","v":9}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A36","v":"2021-12-01"},{"$f":"'Forecast 6 months'!B36","v":14805},{"$f":"'Forecast 6 months'!C36","v":9}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A37","v":"2022-01-01"},{"$f":"'Forecast 6 months'!B37","v":14845},{"$f":"'Forecast 6 months'!C37","v":9}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A38","v":"2022-02-01"},{"$f":"'Forecast 6 months'!B38","v":14875},{"$f":"'Forecast 6 months'!C38","v":9}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A39","v":"2022-03-01"},{"$f":"'Forecast 6 months'!B39","v":14895},{"$f":"'Forecast 6 months'!C39","v":9}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A40","v":"2022-04-01"},{"$f":"'Forecast 6 months'!B40","v":15000},{"$f":"'Forecast 6 months'!C40","v":9}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A41","v":"2022-05-01"},{"$f":"'Forecast 6 months'!B41","v":15017.289836619739},{"$f":"'Forecast 6 months'!C41","v":0}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A42","v":"2022-06-01"},{"$f":"'Forecast 6 months'!B42","v":15061.003498883925},{"$f":"'Forecast 6 months'!C42","v":0}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A43","v":"2022-07-01"},{"$f":"'Forecast 6 months'!B43","v":15104.717161148112},{"$f":"'Forecast 6 months'!C43","v":0}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A44","v":"2022-08-01"},{"$f":"'Forecast 6 months'!B44","v":15148.430823412298},{"$f":"'Forecast 6 months'!C44","v":0}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A45","v":"2022-09-01"},{"$f":"'Forecast 6 months'!B45","v":15192.144485676485},{"$f":"'Forecast 6 months'!C45","v":0}]
[null,null,null,null,null,null,{"$f":"'Forecast 6 months'!A46","v":"2022-10-01"},{"$f":"'Forecast 6 months'!B46","v":15235.858147940671},{"$f":"'Forecast 6 months'!C46","v":0}]

{"sheet":"Dashboard","index":4,"n_rows":128,"n_cols":24,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculations!K3","v":"Version 2.0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Dynamic Charts'!Q151","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Dynamic Charts","index":5,"n_rows":1206,"n_cols":22,"rows_kept":1206,"cut":false,"hidden":true,"merged":[[11,3,11,4],[60,0,60,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DO NOT EDIT - AUTOMATED FORECASTING CHART DATA"]
["Baseline Months to Forecast"]
[6]
[]
["TOTAL NEW BADGES FORECAST CALCULATION:"]
[]
["Timeline","Actual","Forecast","Minimum","Maximum Requirement"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"Calculations!H33","v":14755}]
[{"$f":"DATE(YEAR(A19),MONTH(A19)+1,DAY(A19))","v":"2021-12-01"},{"$f":"Calculations!I33","v":14805}]
[{"$f":"DATE(YEAR(A20),MONTH(A20)+1,DAY(A20))","v":"2022-01-01"},{"$f":"Calculations!J33","v":14845}]
["2022-02-01",{"$f":"Calculations!K33","v":14875}]
["2022-03-01",{"$f":"Calculations!L33","v":14895}]
["2022-04-01",{"$f":"Calculations!M33","v":15000},{"$f":"Table13[[#This Row],[Actual]]","v":15000},{"$f":"Table13[[#This Row],[Actual]]","v":15000},{"$f":"Table13[[#This Row],[Actual]]","v":15000}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A25,$B$19:$B$24,$A$19:$A$24,1,1)+'Instructions & Input'!E40","v":15017.289836619739},{"$f":"'Forecast 6 months'!D24","v":14980.702586126359},{"$f":"'Forecast 6 months'!E24","v":15053.877087113118}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A26,$B$19:$B$24,$A$19:$A$24,1,1)+'Instructions & Input'!F40","v":15061.003498883925},{"$f":"'Forecast 6 months'!D25","v":15024.416083748289},{"$f":"'Forecast 6 months'!E25","v":15097.590914019562}]
["2022-07-01",null,{"$f":"_xlfn.FORECAST.ETS(A27,$B$19:$B$24,$A$19:$A$24,1,1)+'Instructions & Input'!G40","v":15104.717161148112},{"$f":"'Forecast 6 months'!D26","v":15068.129453316958},{"$f":"'Forecast 6 months'!E26","v":15141.304868979265}]
["2022-08-01",null,{"$f":"_xlfn.FORECAST.ETS(A28,$B$19:$B$24,$A$19:$A$24,1,1)+'Instructions & Input'!H40","v":15148.430823412298},{"$f":"'Forecast 6 months'!D27","v":15111.842658249088},{"$f":"'Forecast 6 months'!E27","v":15185.018988575508}]
["2022-09-01",null,{"$f":"_xlfn.FORECAST.ETS(A29,$B$19:$B$24,$A$19:$A$24,1,1)+'Instructions & Input'!I40","v":15192.144485676485},{"$f":"'Forecast 6 months'!D28","v":15155.555661965156},{"$f":"'Forecast 6 months'!E28","v":15228.733309387813}]
["2022-10-01",null,{"$f":"_xlfn.FORECAST.ETS(A30,$B$19:$B$24,$A$19:$A$24,1,1)+'Instructions & Input'!J40","v":15235.858147940671},{"$f":"'Forecast 6 months'!D29","v":15199.268427891227},{"$f":"'Forecast 6 months'!E29","v":15272.447867990115}]
[]
[]
[null,null,null,null,null,"Timeline","Actual","Forecast","Minimum Forecast","Maximum Forecast"]
[null,null,null,null,null,{"$f":"A19","v":"2021-11-01"},{"$f":"B19","v":14755}]
[null,null,null,null,null,{"$f":"A20","v":"2021-12-01"},{"$f":"B20","v":14805}]
[null,null,null,null,null,"2022-01-01",14845]
[null,null,null,null,null,"2022-02-01",14875]
[null,null,null,null,null,"2022-03-01",14895]
[null,null,null,null,null,"2022-04-01",15000,{"$f":"B24","v":15000},{"$f":"B24","v":15000},{"$f":"B24","v":15000}]
[null,null,null,null,null,"2022-05-01",null,{"$f":"C25","v":15017.289836619739},14980.702586126359,15053.877087113118]
[null,null,null,null,null,"2022-06-01",null,15061.003498883925,15024.416083748289,15097.590914019562]
[null,null,null,null,null,"2022-07-01",null,15104.717161148112,15068.129453316958,15141.304868979265]
[null,null,null,null,null,{"$f":"IF($A$14=6,A28,NA())","v":"2022-08-01"},null,{"$f":"IF($V$51=2,C28,NA())","v":15148.430823412298},{"$f":"IF($V$51=2,D28,NA())","v":15111.842658249088},{"$f":"IF($V$51=2,E28,NA())","v":15185.018988575508}]
[null,null,null,null,null,{"$f":"IF($A$14=6,A29,NA())","v":"2022-09-01"},null,{"$f":"IF($V$51=2,C29,NA())","v":15192.144485676485},{"$f":"IF($V$51=2,D29,NA())","v":15155.555661965156},{"$f":"IF($V$51=2,E29,NA())","v":15228.733309387813}]
[null,null,null,null,null,{"$f":"IF($A$14=6,A30,NA())","v":"2022-10-01"},null,15235.858147940671,15199.268427891227,15272.447867990115]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
["STAFF FORECAST CALCULATION:"]
[]
[null,null,null,null,"Based on Historical  Inputs Provided "]
["# of Badges Processed/Staff Member:",null,null,null,{"$f":"Calculations!H52","v":24}]
["DATE","# Badges","#Staff","Capacity","Staff"]
[{"$f":"A19","v":"2021-11-01"},{"$f":"B19","v":14755},{"$f":"Calculations!$H$47","v":9},{"$f":"C63*$E$61","v":216},{"$f":"C63","v":9}]
[{"$f":"DATE(YEAR(A63),MONTH(A63)+1,DAY(A63))","v":"2021-12-01"},{"$f":"B20","v":14805},{"$f":"Calculations!$H$47","v":9},{"$f":"C64*$E$61","v":216},{"$f":"C64","v":9}," "]
[{"$f":"DATE(YEAR(A64),MONTH(A64)+1,DAY(A64))","v":"2022-01-01"},{"$f":"B21","v":14845},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-02-01",{"$f":"B22","v":14875},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-03-01",{"$f":"B23","v":14895},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-04-01",{"$f":"B24","v":15000},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-05-01",{"$f":"C25","v":15017.289836619739},null,{"$f":"'Forecast 6 months'!$D$41","v":218.24959493422125},{"$f":"'Forecast 6 months'!E41","v":9.1}]
["2022-06-01",15061.003498883925,null,{"$f":"'Forecast 6 months'!D42","v":218.88489525711879},{"$f":"'Forecast 6 months'!E42","v":9.1}]
["2022-07-01",15104.717161148112,null,{"$f":"'Forecast 6 months'!D43","v":219.52019558001629},{"$f":"'Forecast 6 months'!E43","v":9.1}]
["2022-08-01",15148.430823412298,null,{"$f":"'Forecast 6 months'!D44","v":220.1554959029138},{"$f":"'Forecast 6 months'!E44","v":9.1999999999999993}]
["2022-09-01",15192.144485676485,null,{"$f":"'Forecast 6 months'!D45","v":220.79079622581131},{"$f":"'Forecast 6 months'!E45","v":9.1999999999999993}]
["2022-10-01",15235.858147940671,null,{"$f":"'Forecast 6 months'!D46","v":221.42609654870881},{"$f":"'Forecast 6 months'!E46","v":9.1999999999999993}]
[" "," "]
[null,"  ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NEW APPLICANTS",null,null,null," "]
["Timeline","Actual","Forecast","Lower Confidence Bound","Upper Confidence Bound"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"Calculations!H34","v":100}]
[{"$f":"DATE(YEAR(A92),MONTH(A92)+1,DAY(A92))","v":"2021-12-01"},{"$f":"Calculations!I34","v":80}]
[{"$f":"DATE(YEAR(A93),MONTH(A93)+1,DAY(A93))","v":"2022-01-01"},{"$f":"Calculations!J34","v":60}]
["2022-02-01",{"$f":"Calculations!K34","v":40}]
["2022-03-01",{"$f":"Calculations!L34","v":100}]
["2022-04-01",{"$f":"Calculations!M34","v":100},{"$f":"Table154[[#This Row],[Actual]]","v":100},{"$f":"Table154[[#This Row],[Actual]]","v":100},{"$f":"Table154[[#This Row],[Actual]]","v":100}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A98,$B$92:$B$97,$A$92:$A$97,1,1)","v":103.39017185553384},{"$f":"C98-_xlfn.FORECAST.ETS.CONFINT(A98,$B$19:$B$24,$A$19:$A$24,0.95,1,1)","v":66.802921362153597},{"$f":"C98+_xlfn.FORECAST.ETS.CONFINT(A98,$B$19:$B$24,$A$19:$A$24,0.95,1,1)","v":139.97742234891408}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A99,$B$92:$B$97,$A$92:$A$97,1,1)","v":106.96204155458854},70.374626418951522,143.54945669022555]
["2022-07-01",null,110.53391125364328,73.946203422490214,147.12161908479635]
["2022-08-01",null,114.10578095269797,77.517615789488616,150.69394611590732]
["2022-09-01",null,117.67765065175273,81.088826940424724,154.26647436308073]
["2022-10-01",null,121.24952035080742,84.659800301363575,157.83924040025124]
[]
["RENEWALS"]
["Timeline","Actual","Forecast","Lower Confidence Bound","Upper Confidence Bound"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"Calculations!H35","v":150}]
[{"$f":"DATE(YEAR(A107),MONTH(A107)+1,DAY(A107))","v":"2021-12-01"},{"$f":"Calculations!I35","v":200}]
[{"$f":"DATE(YEAR(A108),MONTH(A108)+1,DAY(A108))","v":"2022-01-01"},{"$f":"Calculations!J35","v":175}]
["2022-02-01",{"$f":"Calculations!K35","v":80}]
["2022-03-01",{"$f":"Calculations!L35","v":100}]
["2022-04-01",{"$f":"Calculations!M35","v":110},{"$f":"Table1567[[#This Row],[Actual]]","v":110},{"$f":"Table1567[[#This Row],[Actual]]","v":110},{"$f":"Table1567[[#This Row],[Actual]]","v":110}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A113,$B$107:$B$112,$A$107:$A$112,1,1)","v":61.80201466955603},{"$f":"C113-_xlfn.FORECAST.ETS.CONFINT(A113,$B$19:$B$24,$A$19:$A$24,0.95,1,1)","v":25.214764176175784},{"$f":"C113+_xlfn.FORECAST.ETS.CONFINT(A113,$B$19:$B$24,$A$19:$A$24,0.95,1,1)","v":98.389265162936283}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A114,$B$107:$B$112,$A$107:$A$112,1,1)","v":41.892444783307425},5.3050296476704091,78.479859918944442]
["2022-07-01",null,21.982874897058821,-14.60483293409424,58.570582728211882]
["2022-08-01",null,2.0733050108102176,-34.514860152399137,38.66147017401957]
["2022-09-01",null,-17.836264875438388,-54.425088586766392,18.752558835889616]
["2022-10-01",null,-37.745834761686993,-74.335554811130834,-1.1561147122431521]
[]
[null,null,null,null,null,2]
[null,null,null,null,null,"DATE","# Badges","#Staff","Capacity","Staff"]
[null,null,null,null,null,{"$f":"A63","v":"2021-11-01"},{"$f":"B63","v":14755},{"$f":"Calculations!$H$47","v":9},{"$f":"H122*$E$61","v":216},{"$f":"H122","v":9}]
[null,null,null,null,null,{"$f":"DATE(YEAR(F122),MONTH(F122)+1,DAY(F122))","v":"2021-12-01"},{"$f":"B64","v":14805},{"$f":"Calculations!$H$47","v":9},{"$f":"H123*$E$61","v":216},{"$f":"H123","v":9}]
[null,null,null,null,null,{"$f":"DATE(YEAR(F123),MONTH(F123)+1,DAY(F123))","v":"2022-01-01"},14845,{"$f":"Calculations!$H$47","v":9},216,9]
[null,null,null,null,null,"2022-02-01",14875,{"$f":"Calculations!$H$47","v":9},216,9]
[null,null,null,null,null,"2022-03-01",14895,{"$f":"Calculations!$H$47","v":9},216,9]
[null,null,null,null,1,"2022-04-01",15000,{"$f":"Calculations!$H$47","v":9},216,9]
[null,null,null,null,null,"2022-05-01",15017.289836619739," ",{"$f":"'Forecast 6 months'!$D$41","v":218.24959493422125},{"$f":"'Forecast 6 months'!E41","v":9.1}]
[null,null,null,null,null,"2022-06-01",15061.003498883925," ",{"$f":"'Forecast 6 months'!$D$42","v":218.88489525711879},{"$f":"'Forecast 6 months'!E42","v":9.1}]
[null,null,null,null,null,"2022-07-01",15104.717161148112," ",{"$f":"'Forecast 6 months'!$D$43","v":219.52019558001629},{"$f":"'Forecast 6 months'!E43","v":9.1}]
[null,null,null,null,null,{"$f":"IF($F$120=2,A72,NA())","v":"2022-08-01"},15148.430823412298," ",{"$f":"IF($F$120=2,'Forecast 6 months'!D44, NA())","v":220.1554959029138},{"$f":"IF($F$120=2,'Forecast 6 months'!E44, NA())","v":9.1999999999999993}]
[null,null,null,null,null,{"$f":"IF($F$120=2,A73,NA())","v":"2022-09-01"},15192.144485676485," ",{"$f":"IF($F$120=2,'Forecast 6 months'!D45, NA())","v":220.79079622581131},{"$f":"IF($F$120=2,'Forecast 6 months'!E45, NA())","v":9.1999999999999993}]
[null,null,null,null,null,"2022-10-01",15235.858147940671," ",{"$f":"IF($F$120=2,'Forecast 6 months'!D46, NA())","v":221.42609654870881},{"$f":"IF($F$120=2,'Forecast 6 months'!E46, NA())","v":9.1999999999999993}]
[]
[]
[1]
[{"$f":"CHOOSE(A136,\"Forecast\", \"Minimum\", \"Maximum\")","v":"Forecast"}]
["formatted for dynamic chart"]
["Timeline","Actual","Forecast","Minimum","Maximum",null,null,"Timeline","Forecast","Minimum Forecast","Maximum Forecast",null,"Timeline","Forecast","Minimum Forecast","Maximum Forecast"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"B19","v":14755},{"$f":"Table138[[#This Row],[Actual]]","v":14755},{"$f":"Table138[[#This Row],[Forecast]]","v":14755},{"$f":"Table138[[#This Row],[Minimum]]","v":14755},"Date",null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2021-11-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Forecast]],NA())","v":14755},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2021-11-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Forecast]],NA())","v":14755},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
[{"$f":"DATE(YEAR(A140),MONTH(A140)+1,DAY(A140))","v":"2021-12-01"},{"$f":"B20","v":14805},{"$f":"Table138[[#This Row],[Actual]]","v":14805},{"$f":"Table138[[#This Row],[Forecast]]","v":14805},{"$f":"Table138[[#This Row],[Minimum]]","v":14805},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2021-12-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":14805},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2021-12-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":14805},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
[{"$f":"DATE(YEAR(A141),MONTH(A141)+1,DAY(A141))","v":"2022-01-01"},14845,{"$f":"Table138[[#This Row],[Actual]]","v":14845},{"$f":"Table138[[#This Row],[Forecast]]","v":14845},{"$f":"Table138[[#This Row],[Minimum]]","v":14845},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-01-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":14845},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-01-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":14845},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-02-01",14875,{"$f":"Table138[[#This Row],[Actual]]","v":14875},{"$f":"Table138[[#This Row],[Forecast]]","v":14875},{"$f":"Table138[[#This Row],[Minimum]]","v":14875},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-02-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":14875},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-02-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":14875},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-03-01",14895,{"$f":"Table138[[#This Row],[Actual]]","v":14895},{"$f":"Table138[[#This Row],[Forecast]]","v":14895},{"$f":"Table138[[#This Row],[Minimum]]","v":14895},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-03-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":14895},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-03-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":14895},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-04-01",15000,{"$f":"Table138[[#This Row],[Actual]]","v":15000},{"$f":"Table138[[#This Row],[Actual]]","v":15000},{"$f":"Table138[[#This Row],[Actual]]","v":15000},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-04-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15000},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-04-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15000},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-05-01",{"$f":"C25","v":15017.289836619739},{"$f":"_xlfn.FORECAST.ETS(A146,$B$19:$B$24,$A$19:$A$24,1,1)+Calculations!H58","v":15017.289836619739},{"$f":"'Forecast 6 months'!D24","v":14980.702586126359},{"$f":"'Forecast 6 months'!E24","v":15053.877087113118},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-05-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15017.289836619739},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-05-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15017.289836619739},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-06-01",15061.003498883925,{"$f":"_xlfn.FORECAST.ETS(A147,$B$19:$B$24,$A$19:$A$24,1,1)+Calculations!I58","v":15061.003498883925},{"$f":"'Forecast 6 months'!D25","v":15024.416083748289},{"$f":"'Forecast 6 months'!E25","v":15097.590914019562},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-06-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15061.003498883925},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-06-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15061.003498883925},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-07-01",15104.717161148112,{"$f":"_xlfn.FORECAST.ETS(A148,$B$19:$B$24,$A$19:$A$24,1,1)+Calculations!J58","v":15104.717161148112},{"$f":"'Forecast 6 months'!D26","v":15068.129453316958},{"$f":"'Forecast 6 months'!E26","v":15141.304868979265},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-07-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15104.717161148112},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-07-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15104.717161148112},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-08-01",15148.430823412298,{"$f":"_xlfn.FORECAST.ETS(A149,$B$19:$B$24,$A$19:$A$24,1,1)+Calculations!K58","v":15148.430823412298},{"$f":"'Forecast 6 months'!D27","v":15111.842658249088},{"$f":"'Forecast 6 months'!E27","v":15185.018988575508},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-08-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15148.430823412298},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"IF($Q$151=2,Table138[[#This Row],[Timeline]],NA())","v":"2022-08-01"},{"$f":"IF(AND($A$136=1,$Q$151=2),Table138[[#This Row],[Actual]],NA())","v":15148.430823412298},{"$f":"IF(AND($A$136=2,$Q$151=2),Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($A$136=3,$Q$151=2),Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-09-01",15192.144485676485,{"$f":"_xlfn.FORECAST.ETS(A150,$B$19:$B$24,$A$19:$A$24,1,1)+Calculations!L58","v":15192.144485676485},{"$f":"'Forecast 6 months'!D28","v":15155.555661965156},{"$f":"'Forecast 6 months'!E28","v":15228.733309387813},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-09-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15192.144485676485},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"IF($Q$151=2,Table138[[#This Row],[Timeline]],NA())","v":"2022-09-01"},{"$f":"IF(AND($A$136=1,$Q$151=2),Table138[[#This Row],[Actual]],NA())","v":15192.144485676485},{"$f":"IF(AND($A$136=2,$Q$151=2),Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($A$136=3,$Q$151=2),Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}}]
["2022-10-01",15235.858147940671,{"$f":"_xlfn.FORECAST.ETS(A151,$B$19:$B$24,$A$19:$A$24,1,1)+Calculations!M58","v":15235.858147940671},{"$f":"'Forecast 6 months'!D29","v":15199.268427891227},{"$f":"'Forecast 6 months'!E29","v":15272.447867990115},null,null,{"$f":"Table138[[#This Row],[Timeline]]","v":"2022-10-01"},{"$f":"IF($A$136=1,Table138[[#This Row],[Actual]],NA())","v":15235.858147940671},{"$f":"IF($A$136=2,Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF($A$136=3,Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},null,{"$f":"IF($Q$151=2,Table138[[#This Row],[Timeline]],NA())","v":"2022-10-01"},{"$f":"IF(AND($A$136=1,$Q$151=2),Table138[[#This Row],[Actual]],NA())","v":15235.858147940671},{"$f":"IF(AND($A$136=2,$Q$151=2),Table138[[#This Row],[Minimum]],NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND($A$136=3,$Q$151=2),Table138[[#This Row],[Maximum]],NA())","v":{"$error":"#N/A"}},2]
[]
[]
[null,"Dynamic Chart - Badge Forecast"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,0]

{"sheet":"Forecast 6 months","index":6,"n_rows":88,"n_cols":6,"rows_kept":88,"cut":false,"hidden":true,"merged":[[32,0,32,3],[11,3,11,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DO NOT EDIT - AUTOMATED FORECASTING CHART DATA"]
[]
[]
[]
["TOTAL NEW BADGES:"]
["Timeline","Actual","Forecast","Minimum","Maximum Requirement"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"'Instructions & Input'!E34","v":14755}]
[{"$f":"DATE(YEAR(A18),MONTH(A18)+1,DAY(A18))","v":"2021-12-01"},{"$f":"'Instructions & Input'!F34","v":14805}]
[{"$f":"DATE(YEAR(A19),MONTH(A19)+1,DAY(A19))","v":"2022-01-01"},{"$f":"'Instructions & Input'!G34","v":14845}]
["2022-02-01",{"$f":"'Instructions & Input'!H34","v":14875}]
["2022-03-01",{"$f":"Calculations!H106","v":14895}]
["2022-04-01",{"$f":"'Instructions & Input'!J34","v":15000},{"$f":"Table1[[#This Row],[Actual]]","v":15000},{"$f":"Table1[[#This Row],[Actual]]","v":15000},{"$f":"Table1[[#This Row],[Actual]]","v":15000}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A24,$B$18:$B$23,$A$18:$A$23,1,1)","v":15017.289836619739},{"$f":"C24-_xlfn.FORECAST.ETS.CONFINT(A24,$B$18:$B$23,$A$18:$A$23,0.95,1,1)-'Instructions & Input'!E40","v":14980.702586126359},{"$f":"C24+_xlfn.FORECAST.ETS.CONFINT(A24,$B$18:$B$23,$A$18:$A$23,0.95,1,1)+'Instructions & Input'!E40","v":15053.877087113118}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A25,$B$18:$B$23,$A$18:$A$23,1,1)+'Instructions & Input'!F40","v":15061.003498883925},{"$f":"C25-_xlfn.FORECAST.ETS.CONFINT(A25,$B$18:$B$23,$A$18:$A$23,0.95,1,1)-'Instructions & Input'!F40","v":15024.416083748289},{"$f":"C25+_xlfn.FORECAST.ETS.CONFINT(A25,$B$18:$B$23,$A$18:$A$23,0.95,1,1)+'Instructions & Input'!F40","v":15097.590914019562}]
["2022-07-01",null,{"$f":"_xlfn.FORECAST.ETS(A26,$B$18:$B$23,$A$18:$A$23,1,1)+'Instructions & Input'!G40","v":15104.717161148112},{"$f":"C26-_xlfn.FORECAST.ETS.CONFINT(A26,$B$18:$B$23,$A$18:$A$23,0.95,1,1)-'Instructions & Input'!G40","v":15068.129453316958},{"$f":"C26+_xlfn.FORECAST.ETS.CONFINT(A26,$B$18:$B$23,$A$18:$A$23,0.95,1,1)+'Instructions & Input'!G40","v":15141.304868979265}]
["2022-08-01",null,{"$f":"_xlfn.FORECAST.ETS(A27,$B$18:$B$23,$A$18:$A$23,1,1)+'Instructions & Input'!H40","v":15148.430823412298},{"$f":"C27-_xlfn.FORECAST.ETS.CONFINT(A27,$B$18:$B$23,$A$18:$A$23,0.95,1,1)-'Instructions & Input'!H40","v":15111.842658249088},{"$f":"C27+_xlfn.FORECAST.ETS.CONFINT(A27,$B$18:$B$23,$A$18:$A$23,0.95,1,1)+'Instructions & Input'!H40","v":15185.018988575508}]
["2022-09-01",null,{"$f":"_xlfn.FORECAST.ETS(A28,$B$18:$B$23,$A$18:$A$23,1,1)+'Instructions & Input'!I40","v":15192.144485676485},{"$f":"C28-_xlfn.FORECAST.ETS.CONFINT(A28,$B$18:$B$23,$A$18:$A$23,0.95,1,1)-'Instructions & Input'!I40","v":15155.555661965156},{"$f":"C28+_xlfn.FORECAST.ETS.CONFINT(A28,$B$18:$B$23,$A$18:$A$23,0.95,1,1)+'Instructions & Input'!I40","v":15228.733309387813}]
["2022-10-01",null,{"$f":"_xlfn.FORECAST.ETS(A29,$B$18:$B$23,$A$18:$A$23,1,1)+'Instructions & Input'!J40","v":15235.858147940671},{"$f":"C29-_xlfn.FORECAST.ETS.CONFINT(A29,$B$18:$B$23,$A$18:$A$23,0.95,1,1)-'Instructions & Input'!J40","v":15199.268427891227},{"$f":"C29+_xlfn.FORECAST.ETS.CONFINT(A29,$B$18:$B$23,$A$18:$A$23,0.95,1,1)+'Instructions & Input'!J40","v":15272.447867990115}]
[]
[]
[null,null,null,null,"Based on Historical  Inputs Provided "]
["# of Badges Processed/Staff Member:",null,null,null,{"$f":"Calculations!H52","v":24}]
["DATE","# Badges","#Staff","Current Capacity","Forecast Staff"]
[{"$f":"A18","v":"2021-11-01"},{"$f":"B18","v":14755},{"$f":"Calculations!$H$47","v":9},{"$f":"$E$33*C35","v":216},{"$f":"D35/$E$33","v":9}]
[{"$f":"DATE(YEAR(A35),MONTH(A35)+1,DAY(A35))","v":"2021-12-01"},{"$f":"B19","v":14805},{"$f":"Calculations!$H$47","v":9},{"$f":"$E$33*C36","v":216},{"$f":"D36/$E$33","v":9}," "]
[{"$f":"DATE(YEAR(A36),MONTH(A36)+1,DAY(A36))","v":"2022-01-01"},{"$f":"B20","v":14845},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-02-01",{"$f":"B21","v":14875},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-03-01",{"$f":"B22","v":14895},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-04-01",{"$f":"B23","v":15000},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-05-01",{"$f":"C24","v":15017.289836619739},null,{"$f":"B41*Calculations!$H$51","v":218.24959493422125},{"$f":"ROUND(D41/$E$33,1)","v":9.1}]
["2022-06-01",15061.003498883925,null,{"$f":"B42*Calculations!$H$51","v":218.88489525711879},{"$f":"ROUND(D42/$E$33,1)","v":9.1}]
["2022-07-01",{"$f":"C26","v":15104.717161148112},null,{"$f":"B43*Calculations!$H$51","v":219.52019558001629},9.1]
["2022-08-01",15148.430823412298,null,{"$f":"B44*Calculations!$H$51","v":220.1554959029138},9.1999999999999993]
["2022-09-01",15192.144485676485,null,{"$f":"B45*Calculations!$H$51","v":220.79079622581131},9.1999999999999993]
["2022-10-01",15235.858147940671,null,{"$f":"B46*Calculations!$H$51","v":221.42609654870881},9.1999999999999993]
[" "," ",null,null," "]
[null,null,null," "]
[null,null," "," "]
[null,null," "," "]
[null,null," "," "]
[null,null," "," "]
[null,null,null,null," "]
[null,null,null," "]
[null,null," "," "]
[null,null," "," "]
[null,null," "," "]
[null,null," "," "]
[]
["NEW APPLICANTS",null,null,null," "]
["Timeline","Actual","Forecast","Lower Confidence Bound","Upper Confidence Bound"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"Calculations!H34","v":100}]
[{"$f":"DATE(YEAR(A62),MONTH(A62)+1,DAY(A62))","v":"2021-12-01"},{"$f":"Calculations!I34","v":80}]
[{"$f":"DATE(YEAR(A63),MONTH(A63)+1,DAY(A63))","v":"2022-01-01"},{"$f":"Calculations!J34","v":60}]
["2022-02-01",{"$f":"Calculations!K34","v":40}]
["2022-03-01",{"$f":"Calculations!L34","v":100}]
["2022-04-01",{"$f":"Calculations!M34","v":100},{"$f":"Table15[[#This Row],[Actual]]","v":100},{"$f":"Table15[[#This Row],[Actual]]","v":100},{"$f":"Table15[[#This Row],[Actual]]","v":100}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A68,$B$62:$B$67,$A$62:$A$67,1,1)","v":103.39017185553384},{"$f":"C68-_xlfn.FORECAST.ETS.CONFINT(A68,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":66.802921362153597},{"$f":"C68+_xlfn.FORECAST.ETS.CONFINT(A68,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":139.97742234891408}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A69,$B$62:$B$67,$A$62:$A$67,1,1)","v":106.96204155458854},70.374626418951522,143.54945669022555]
["2022-07-01",null,110.53391125364328,73.946203422490214,147.12161908479635]
["2022-08-01",null,114.10578095269797,77.517615789488616,150.69394611590732]
["2022-09-01",null,117.67765065175273,81.088826940424724,154.26647436308073]
["2022-10-01",null,121.24952035080742,84.659800301363575,157.83924040025124]
[]
["RENEWALS"]
["Timeline","Actual","Forecast","Lower Confidence Bound","Upper Confidence Bound"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"Calculations!H35","v":150}]
[{"$f":"DATE(YEAR(A77),MONTH(A77)+1,DAY(A77))","v":"2021-12-01"},{"$f":"Calculations!I35","v":200}]
[{"$f":"DATE(YEAR(A78),MONTH(A78)+1,DAY(A78))","v":"2022-01-01"},{"$f":"Calculations!J35","v":175}]
["2022-02-01",{"$f":"Calculations!K35","v":80}]
["2022-03-01",{"$f":"Calculations!L35","v":100}]
["2022-04-01",{"$f":"Calculations!M35","v":110},{"$f":"Table156[[#This Row],[Actual]]","v":110},{"$f":"Table156[[#This Row],[Actual]]","v":110},{"$f":"Table156[[#This Row],[Actual]]","v":110}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A83,$B$77:$B$82,$A$77:$A$82,1,1)","v":61.80201466955603},{"$f":"C83-_xlfn.FORECAST.ETS.CONFINT(A83,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":25.214764176175784},{"$f":"C83+_xlfn.FORECAST.ETS.CONFINT(A83,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":98.389265162936283}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A84,$B$77:$B$82,$A$77:$A$82,1,1)","v":41.892444783307425},5.3050296476704091,78.479859918944442]
["2022-07-01",null,21.982874897058821,-14.60483293409424,58.570582728211882]
["2022-08-01",null,2.0733050108102176,-34.514860152399137,38.66147017401957]
["2022-09-01",null,-17.836264875438388,-54.425088586766392,18.752558835889616]
["2022-10-01",null,-37.745834761686993,-74.335554811130834,-1.1561147122431521]

{"sheet":"Forecast 3 months","index":7,"n_rows":82,"n_cols":21,"rows_kept":82,"cut":false,"hidden":true,"merged":[[11,3,11,4],[29,0,29,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT USED BUT KEEP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DO NOT EDIT - AUTOMATED FORECASTING CHART DATA"]
[]
[]
[]
["TOTAL NEW BADGES:"]
["Timeline","Actual","Forecast","Minimum","Maximum Requirement"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"'Instructions & Input'!E34","v":14755}]
[{"$f":"DATE(YEAR(A18),MONTH(A18)+1,DAY(A18))","v":"2021-12-01"},{"$f":"'Instructions & Input'!F34","v":14805}]
[{"$f":"DATE(YEAR(A19),MONTH(A19)+1,DAY(A19))","v":"2022-01-01"},{"$f":"'Instructions & Input'!G34","v":14845}]
["2022-02-01",{"$f":"'Instructions & Input'!H34","v":14875}]
["2022-03-01",{"$f":"Calculations!H106","v":14895}]
["2022-04-01",{"$f":"'Instructions & Input'!J34","v":15000},{"$f":"Table19[[#This Row],[Actual]]","v":15000},{"$f":"Table19[[#This Row],[Actual]]","v":15000},{"$f":"Table19[[#This Row],[Actual]]","v":15000}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A24,$B$18:$B$23,$A$18:$A$23,1,1)","v":15017.289836619739},{"$f":"C24-_xlfn.FORECAST.ETS.CONFINT(A24,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":14980.702586126359},{"$f":"C24+_xlfn.FORECAST.ETS.CONFINT(A24,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":15053.877087113118}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A25,$B$18:$B$23,$A$18:$A$23,1,1)","v":15061.003498883925},15024.416083748289,15097.590914019562]
["2022-07-01",null,15104.717161148112,15068.129453316958,15141.304868979265]
[]
[]
[null,null,null,null,"Based on Historical  Inputs Provided "]
["# of Badges Processed/Staff Member:",null,null,null,{"$f":"Calculations!H52","v":24}]
["DATE","# Badges","#Staff","Current Capacity","Forecast Staff"]
[{"$f":"A18","v":"2021-11-01"},{"$f":"B18","v":14755},{"$f":"Calculations!$H$47","v":9},{"$f":"$E$30*C32","v":216},{"$f":"D32/$E$30","v":9}]
[{"$f":"DATE(YEAR(A32),MONTH(A32)+1,DAY(A32))","v":"2021-12-01"},{"$f":"B19","v":14805},{"$f":"Calculations!$H$47","v":9},{"$f":"$E$30*C33","v":216},{"$f":"D33/$E$30","v":9}," "]
[{"$f":"DATE(YEAR(A33),MONTH(A33)+1,DAY(A33))","v":"2022-01-01"},{"$f":"B20","v":14845},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-02-01",{"$f":"B21","v":14875},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-03-01",{"$f":"B22","v":14895},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-04-01",{"$f":"B23","v":15000},{"$f":"Calculations!$H$47","v":9},216,9]
["2022-05-01",{"$f":"C24","v":15017.289836619739}," ",{"$f":"B38/12","v":1251.4408197183116},{"$f":"D38/$E$30","v":52.143367488262982}]
["2022-06-01",{"$f":"C25","v":15061.003498883925}," ",{"$f":"B39/12","v":1255.0836249069937},{"$f":"D39/$E$30","v":52.295151037791406}]
["2022-07-01",{"$f":"C26","v":15104.717161148112}," ",1258.7264300956761,52.446934587319838]
[" "," ",null,null,"Option 1 (DEFAULT)"]
[null,null,null,"Assumes using largest month in forecast"]
[null,null,{"$f":"MAX(B38:B40)","v":15104.717161148112},"Max number of Badges in Forecast"]
[null,null,{"$f":"(C43-B32)","v":349.7171611481117},"Growth of Monthly Badges"]
[null,null,{"$f":"ROUND(C44/E30,0)","v":15},"Increase of staff required"]
[null,null,{"$f":"C32+C45","v":24},"Total staff required"]
[null,null,null,null,"Option 2 ( Ideal for when there are negative fluctuations during the 6 month forecast)"]
[null,null,null,"Assumes using average month in forecast"]
[null,null,{"$f":"ROUND(AVERAGE(B38:B40),0)","v":15061},"Average number of badges"]
[null,null,{"$f":"C49-B32","v":306},"Growth of Month Badges"]
[null,null,{"$f":"ROUND(C50/E30,0)","v":13},"Increase of staff required"]
[null,null,{"$f":"C32+C51","v":22},"Total staff required"]
[]
["NEW APPLICANTS",null,null,null," "]
["Timeline","Actual","Forecast","Lower Confidence Bound","Upper Confidence Bound"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"Calculations!H34","v":100}]
[{"$f":"DATE(YEAR(A56),MONTH(A56)+1,DAY(A56))","v":"2021-12-01"},{"$f":"Calculations!I34","v":80}]
[{"$f":"DATE(YEAR(A57),MONTH(A57)+1,DAY(A57))","v":"2022-01-01"},{"$f":"Calculations!J34","v":60}]
["2022-02-01",{"$f":"Calculations!K34","v":40}]
["2022-03-01",{"$f":"Calculations!L34","v":100}]
["2022-04-01",{"$f":"Calculations!M34","v":100},{"$f":"Table1510[[#This Row],[Actual]]","v":100},{"$f":"Table1510[[#This Row],[Actual]]","v":100},{"$f":"Table1510[[#This Row],[Actual]]","v":100}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A62,$B$56:$B$61,$A$56:$A$61,1,1)","v":103.39017185553384},{"$f":"C62-_xlfn.FORECAST.ETS.CONFINT(A62,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":66.802921362153597},{"$f":"C62+_xlfn.FORECAST.ETS.CONFINT(A62,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":139.97742234891408}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A63,$B$56:$B$61,$A$56:$A$61,1,1)","v":106.96204155458854},70.374626418951522,143.54945669022555]
["2022-07-01",null,110.53391125364328,73.946203422490214,147.12161908479635]
["2022-08-01",null,114.10578095269797,77.517615789488616,150.69394611590732]
["2022-09-01",null,117.67765065175273,81.088826940424724,154.26647436308073]
["2022-10-01",null,121.24952035080742,84.659800301363575,157.83924040025124]
[]
["RENEWALS"]
["Timeline","Actual","Forecast","Lower Confidence Bound","Upper Confidence Bound"]
[{"$f":"Calculations!H19","v":"2021-11-01"},{"$f":"Calculations!H35","v":150}]
[{"$f":"DATE(YEAR(A71),MONTH(A71)+1,DAY(A71))","v":"2021-12-01"},{"$f":"Calculations!I35","v":200}]
[{"$f":"DATE(YEAR(A72),MONTH(A72)+1,DAY(A72))","v":"2022-01-01"},{"$f":"Calculations!J35","v":175}]
["2022-02-01",{"$f":"Calculations!K35","v":80}]
["2022-03-01",{"$f":"Calculations!L35","v":100}]
["2022-04-01",{"$f":"Calculations!M35","v":110},{"$f":"Table15611[[#This Row],[Actual]]","v":110},{"$f":"Table15611[[#This Row],[Actual]]","v":110},{"$f":"Table15611[[#This Row],[Actual]]","v":110}]
["2022-05-01",null,{"$f":"_xlfn.FORECAST.ETS(A77,$B$71:$B$76,$A$71:$A$76,1,1)","v":61.80201466955603},{"$f":"C77-_xlfn.FORECAST.ETS.CONFINT(A77,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":25.214764176175784},{"$f":"C77+_xlfn.FORECAST.ETS.CONFINT(A77,$B$18:$B$23,$A$18:$A$23,0.95,1,1)","v":98.389265162936283}]
["2022-06-01",null,{"$f":"_xlfn.FORECAST.ETS(A78,$B$71:$B$76,$A$71:$A$76,1,1)","v":41.892444783307425},5.3050296476704091,78.479859918944442]
["2022-07-01",null,21.982874897058821,-14.60483293409424,58.570582728211882]
["2022-08-01",null,2.0733050108102176,-34.514860152399137,38.66147017401957]
["2022-09-01",null,-17.836264875438388,-54.425088586766392,18.752558835889616]
["2022-10-01",null,-37.745834761686993,-74.335554811130834,-1.1561147122431521]

{"sheet":"Drop Down Entry","index":8,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Large"]
[null,"Medium"]
[null,"Small"]
[]
[null," "]
[null," "]

{"sheet":"Dashboard 3 months","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Dashboard 6 months","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}