{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Summary tab","DataPivot","Master Data Entry Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Instructions","index":0,"n_rows":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Instruction for Completing Span of Control Report"]
["OMB is requesting each county department to participate in a Span of Control calculation effort.  Span of control measures the number of individuals a supervisor oversees.  This project is intended to provide departments county-wide with a tool to enable them to consistently calculate and report on span of control.  The data developed can then be used by the departments and OMB in budget development and decision making. "]
[]
["Span of control varies widely depending on several factors.  We know that there will be situations that call for supervisory loads outside a general range of 3 or less to 10 or more direct reports per supervisor.  Therefore, included in this template is the ability for departments to provide information on factors or mitigating circumstances that affect what an appropriate span of control exists for a given supervisor. "]
[]
["Span of Control will need to be calculated for each supervisor in the department.   For smaller departments, a single Excel file with a tab for each manager will be sufficient.  For larger, more complex departments, it is recommended that the department create an Excel file for each division; within each division’s Excel file, each supervisor will have their own tab.  Spreadsheets may be filled out by department, division,  or program managers or human resources staff, as appropriate."]
[]
["For these calculations, departments must count the number of “direct reports” a supervisor has (both filled and vacant).  A direct report is: a) for full time employee, a position for whom a supervisor completes an evaluation and b) for part-time employee, a position for whom the supervisor completes an evaluation OR, if no evaluation is done, a position for whom the supervisor directs and oversees day-to-day assignments."]
[]
["The person completing this template should read through all instructions and the entire 'Master Data Entry Template' categories, types of staff positions and questions before completing the entire workbook.  Do not enter information on the Master Data Entry Template.  Calculate the totals for each type of position and enter the total into the tab named for each individual supervisor.\n\nStart data entry by making a copy of the 'Master Data Entry Template' worksheet.  A new supervisor worksheet can be created by right clicking on the 'Master Data Entry Template' worksheet, choose 'Move or Copy', select '(move to end)' and check 'Create a copy' and press 'OK'.  The new worksheet can be renamed with the supervisor's name.   There should be one worksheet for each supervisor.  Tabs should also be created for vacant supervisor positions -- each Vacant Supervisor should be named Vacant 1, Vacant 2, Vacant 3, etc.  Add the appropriate title for the vacant supervisor position.  Continue making a copy of the master worksheet and entering data for each supervisor and supervisor vacancy until complete.   "]
[]
["Supervisor Definition: The person who completes a performance evaluation and/or directs and oversees day-to-day work assignments of a subordinate.  A direct report is: a) for full time employee, a position for whom a supervisor completes an evaluation and b) for part-time employee, a position for whom the supervisor completes an evaluation OR, if no evaluation is done, a position for whom the supervisor directs and oversees day-to-day assignments."]
[]
["There are two sections on the supervisor tab that will need to be filled in by the department:"]
["Section 1:  Individual Span of Control Calculation"]
["Section 2:  Additional Information"]
[]
["Individual Tab , Section 1:  Individual Span of Control  Calculation "]
["Create a tab for each supervisor in the department.  Rename the tab with the “Last Name, First Initial” of the supervisor.   For large departments, it may be best to use one file for each division within the department.  In that case, a tab for each supervisor will still be needed. Vacant supervisor positions should be named Vacant 1, Vacant 2, Vacant 3, etc. "]
[]
["For each supervisor:"]
["Enter supervisor title in cell D1 (including for vacant postions)"]
["Enter supervisor name in cell D2"]
[]
["For each type of direct report (i.e., Full-Time Regular, Part-Time Regular, etc.) calculate the number of FTEs who report to the supervisor and enter the figure in the appropriate cell in Column D."]
[]
["The Total Number of FTE Equivalents Supervised will automatically calculate in cell D14."]
[]
["Individual Tab, Section 2:  Additional Information"]
["Not all types of staff are counted in the Span of Control calculation in Section 1.  However, for the purposes of understanding a manager’s total responsibilities, we are collecting information on additional individuals who may report to the manager but who are not included in the span of control calculation."]
[]
["For each type of direct report not counted above (Temporary, Contract Direct Reports, Interns and Seasonal Employees) calculate the number of FTEs that report to the supervisor and enter the total in the appropriate cell.  "]
[]
["In the next set of questions, we are collecting data on mitigating factors that may affect the appropriateness of a supervisor’s span of control.  Choose an answer from the drop down box for each type of mitigating factor. "]
[]
["Summary Tab:"]
["The summary tab will automatically show the name, title, span of control, and answers to mitigating factors for each supervisor for which data has been entered in real-time.  The department should not  make any entries or changes to this tab.\n\nThe macro button in the top right corner of the 'Summary Tab' page needs to be selected only when worksheets are added or deleted to refresh page data e.g. add new supervisor data or remove blank lines. "]

{"sheet":"Summary tab","index":1,"n_rows":103,"n_cols":11,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,6,1,10]]}
[null,"This tab provides a summary of each supervisor and the total number of direct reports.  It also identifies outliers where a supervisors has 3 or less or 10 or more FTE direct reports."]
[null,null,null,null,null,null,"Mitigating Factors"]
["Supervisor No.","Supervisor Title","Name","Total Number of FTEs Supervised","Outlier:  Span of Control of <=3 or >=10","Additional FTEs Supervised Periodically","Manager Responsibilities","Level of Risk","Proximity of Direct Reports","Complex or Routine Tasks","Availability of Technology"]
[1,{"$f":"IFERROR(DataPivot!B1,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C1,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D1,\"-\")","v":"-"},{"$f":"IF(D4=\"-\",\"-\", IF(AND(D4>3,D4<10),\"-\",\"Outlier\"))","v":"-"},{"$f":"IFERROR(DataPivot!E1,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F1,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G1,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H1,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I1,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J1,\"-\")","v":"-"}]
[2,{"$f":"IFERROR(DataPivot!B2,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C2,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D2,\"-\")","v":"-"},{"$f":"IF(D5=\"-\",\"-\", IF(AND(D5>3,D5<10),\"-\",\"Outlier\"))","v":"-"},{"$f":"IFERROR(DataPivot!E2,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F2,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G2,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H2,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I2,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J2,\"-\")","v":"-"}]
[3,{"$f":"IFERROR(DataPivot!B3,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C3,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D3,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E3,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F3,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G3,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H3,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I3,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J3,\"-\")","v":"-"}]
[4,{"$f":"IFERROR(DataPivot!B4,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C4,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D4,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E4,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F4,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G4,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H4,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I4,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J4,\"-\")","v":"-"}]
[5,{"$f":"IFERROR(DataPivot!B5,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C5,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D5,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E5,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F5,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G5,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H5,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I5,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J5,\"-\")","v":"-"}]
[6,{"$f":"IFERROR(DataPivot!B6,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C6,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D6,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E6,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F6,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G6,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H6,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I6,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J6,\"-\")","v":"-"}]
[7,{"$f":"IFERROR(DataPivot!B7,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C7,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D7,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E7,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F7,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G7,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H7,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I7,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J7,\"-\")","v":"-"}]
[8,{"$f":"IFERROR(DataPivot!B8,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C8,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D8,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E8,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F8,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G8,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H8,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I8,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J8,\"-\")","v":"-"}]
[9,{"$f":"IFERROR(DataPivot!B9,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C9,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D9,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E9,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F9,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G9,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H9,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I9,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J9,\"-\")","v":"-"}]
[10,{"$f":"IFERROR(DataPivot!B10,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C10,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D10,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E10,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F10,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G10,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H10,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I10,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J10,\"-\")","v":"-"}]
[11,{"$f":"IFERROR(DataPivot!B11,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C11,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D11,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E11,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F11,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G11,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H11,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I11,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J11,\"-\")","v":"-"}]
[12,{"$f":"IFERROR(DataPivot!B12,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C12,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D12,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E12,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F12,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G12,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H12,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I12,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J12,\"-\")","v":"-"}]
[13,{"$f":"IFERROR(DataPivot!B13,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C13,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D13,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E13,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F13,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G13,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H13,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I13,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J13,\"-\")","v":"-"}]
[14,{"$f":"IFERROR(DataPivot!B14,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C14,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D14,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E14,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F14,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G14,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H14,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I14,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J14,\"-\")","v":"-"}]
[15,{"$f":"IFERROR(DataPivot!B15,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C15,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D15,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E15,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F15,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G15,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H15,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I15,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J15,\"-\")","v":"-"}]
[16,{"$f":"IFERROR(DataPivot!B16,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C16,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D16,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E16,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F16,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G16,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H16,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I16,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J16,\"-\")","v":"-"}]
[17,{"$f":"IFERROR(DataPivot!B17,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C17,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D17,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E17,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F17,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G17,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H17,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I17,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J17,\"-\")","v":"-"}]
[18,{"$f":"IFERROR(DataPivot!B18,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C18,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D18,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E18,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F18,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G18,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H18,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I18,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J18,\"-\")","v":"-"}]
[19,{"$f":"IFERROR(DataPivot!B19,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C19,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D19,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E19,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F19,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G19,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H19,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I19,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J19,\"-\")","v":"-"}]
[20,{"$f":"IFERROR(DataPivot!B20,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C20,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D20,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E20,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F20,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G20,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H20,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I20,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J20,\"-\")","v":"-"}]
[21,{"$f":"IFERROR(DataPivot!B21,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C21,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D21,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E21,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F21,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G21,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H21,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I21,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J21,\"-\")","v":"-"}]
[22,{"$f":"IFERROR(DataPivot!B22,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C22,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D22,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E22,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F22,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G22,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H22,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I22,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J22,\"-\")","v":"-"}]
[23,{"$f":"IFERROR(DataPivot!B23,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C23,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D23,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E23,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F23,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G23,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H23,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I23,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J23,\"-\")","v":"-"}]
[24,{"$f":"IFERROR(DataPivot!B24,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C24,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D24,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E24,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F24,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G24,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H24,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I24,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J24,\"-\")","v":"-"}]
[25,{"$f":"IFERROR(DataPivot!B25,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C25,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D25,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E25,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F25,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G25,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H25,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I25,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J25,\"-\")","v":"-"}]
[26,{"$f":"IFERROR(DataPivot!B26,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C26,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D26,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E26,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F26,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G26,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H26,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I26,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J26,\"-\")","v":"-"}]
[27,{"$f":"IFERROR(DataPivot!B27,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C27,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D27,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E27,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F27,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G27,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H27,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I27,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J27,\"-\")","v":"-"}]
[28,{"$f":"IFERROR(DataPivot!B28,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C28,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D28,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E28,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F28,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G28,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H28,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I28,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J28,\"-\")","v":"-"}]
[29,{"$f":"IFERROR(DataPivot!B29,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C29,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D29,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E29,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F29,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G29,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H29,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I29,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J29,\"-\")","v":"-"}]
[30,{"$f":"IFERROR(DataPivot!B30,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C30,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D30,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E30,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F30,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G30,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H30,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I30,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J30,\"-\")","v":"-"}]
[31,{"$f":"IFERROR(DataPivot!B31,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C31,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D31,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E31,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F31,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G31,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H31,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I31,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J31,\"-\")","v":"-"}]
[32,{"$f":"IFERROR(DataPivot!B32,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C32,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D32,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E32,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F32,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G32,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H32,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I32,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J32,\"-\")","v":"-"}]
[33,{"$f":"IFERROR(DataPivot!B33,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C33,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D33,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E33,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F33,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G33,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H33,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I33,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J33,\"-\")","v":"-"}]
[34,{"$f":"IFERROR(DataPivot!B34,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C34,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D34,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E34,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F34,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G34,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H34,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I34,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J34,\"-\")","v":"-"}]
[35,{"$f":"IFERROR(DataPivot!B35,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C35,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D35,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E35,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F35,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G35,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H35,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I35,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J35,\"-\")","v":"-"}]
[36,{"$f":"IFERROR(DataPivot!B36,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C36,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D36,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E36,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F36,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G36,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H36,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I36,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J36,\"-\")","v":"-"}]
[37,{"$f":"IFERROR(DataPivot!B37,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C37,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D37,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E37,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F37,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G37,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H37,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I37,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J37,\"-\")","v":"-"}]
[38,{"$f":"IFERROR(DataPivot!B38,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C38,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D38,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E38,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F38,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G38,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H38,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I38,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J38,\"-\")","v":"-"}]
[39,{"$f":"IFERROR(DataPivot!B39,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C39,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D39,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E39,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F39,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G39,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H39,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I39,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J39,\"-\")","v":"-"}]
[40,{"$f":"IFERROR(DataPivot!B40,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C40,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D40,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E40,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F40,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G40,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H40,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I40,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J40,\"-\")","v":"-"}]
[41,{"$f":"IFERROR(DataPivot!B41,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C41,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D41,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E41,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F41,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G41,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H41,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I41,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J41,\"-\")","v":"-"}]
[42,{"$f":"IFERROR(DataPivot!B42,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C42,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D42,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E42,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F42,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G42,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H42,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I42,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J42,\"-\")","v":"-"}]
[43,{"$f":"IFERROR(DataPivot!B43,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C43,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D43,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E43,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F43,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G43,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H43,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I43,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J43,\"-\")","v":"-"}]
[44,{"$f":"IFERROR(DataPivot!B44,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C44,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D44,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E44,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F44,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G44,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H44,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I44,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J44,\"-\")","v":"-"}]
[45,{"$f":"IFERROR(DataPivot!B45,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C45,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D45,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E45,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F45,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G45,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H45,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I45,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J45,\"-\")","v":"-"}]
[46,{"$f":"IFERROR(DataPivot!B46,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C46,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D46,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E46,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F46,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G46,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H46,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I46,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J46,\"-\")","v":"-"}]
[47,{"$f":"IFERROR(DataPivot!B47,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C47,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D47,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E47,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F47,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G47,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H47,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I47,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J47,\"-\")","v":"-"}]
[48,{"$f":"IFERROR(DataPivot!B48,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C48,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D48,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E48,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F48,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G48,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H48,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I48,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J48,\"-\")","v":"-"}]
[49,{"$f":"IFERROR(DataPivot!B49,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C49,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D49,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E49,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F49,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G49,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H49,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I49,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J49,\"-\")","v":"-"}]
[50,{"$f":"IFERROR(DataPivot!B50,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C50,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D50,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E50,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F50,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G50,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H50,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I50,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J50,\"-\")","v":"-"}]
[51,{"$f":"IFERROR(DataPivot!B51,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C51,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D51,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E51,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F51,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G51,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H51,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I51,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J51,\"-\")","v":"-"}]
[52,{"$f":"IFERROR(DataPivot!B52,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C52,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D52,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E52,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F52,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G52,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H52,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I52,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J52,\"-\")","v":"-"}]
[53,{"$f":"IFERROR(DataPivot!B53,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C53,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D53,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E53,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F53,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G53,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H53,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I53,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J53,\"-\")","v":"-"}]
[54,{"$f":"IFERROR(DataPivot!B54,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C54,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D54,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E54,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F54,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G54,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H54,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I54,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J54,\"-\")","v":"-"}]
[55,{"$f":"IFERROR(DataPivot!B55,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C55,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D55,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E55,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F55,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G55,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H55,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I55,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J55,\"-\")","v":"-"}]
[56,{"$f":"IFERROR(DataPivot!B56,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C56,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D56,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E56,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F56,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G56,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H56,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I56,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J56,\"-\")","v":"-"}]
[57,{"$f":"IFERROR(DataPivot!B57,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C57,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D57,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E57,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F57,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G57,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H57,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I57,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J57,\"-\")","v":"-"}]
[58,{"$f":"IFERROR(DataPivot!B58,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C58,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D58,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E58,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F58,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G58,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H58,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I58,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J58,\"-\")","v":"-"}]
[59,{"$f":"IFERROR(DataPivot!B59,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C59,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D59,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E59,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F59,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G59,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H59,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I59,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J59,\"-\")","v":"-"}]
[60,{"$f":"IFERROR(DataPivot!B60,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C60,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D60,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E60,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F60,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G60,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H60,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I60,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J60,\"-\")","v":"-"}]
[61,{"$f":"IFERROR(DataPivot!B61,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C61,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D61,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E61,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F61,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G61,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H61,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I61,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J61,\"-\")","v":"-"}]
[62,{"$f":"IFERROR(DataPivot!B62,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C62,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D62,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E62,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F62,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G62,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H62,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I62,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J62,\"-\")","v":"-"}]
[63,{"$f":"IFERROR(DataPivot!B63,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C63,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D63,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E63,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F63,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G63,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H63,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I63,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J63,\"-\")","v":"-"}]
[64,{"$f":"IFERROR(DataPivot!B64,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C64,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D64,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E64,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F64,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G64,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H64,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I64,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J64,\"-\")","v":"-"}]
[65,{"$f":"IFERROR(DataPivot!B65,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C65,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D65,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E65,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F65,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G65,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H65,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I65,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J65,\"-\")","v":"-"}]
[66,{"$f":"IFERROR(DataPivot!B66,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C66,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D66,\"-\")","v":"-"},{"$f":"IF(D69=\"-\",\"-\", IF(AND(D69>3,D69<10),\"-\",\"Outlier\"))","v":"-"},{"$f":"IFERROR(DataPivot!E66,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F66,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G66,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H66,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I66,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J66,\"-\")","v":"-"}]
[67,{"$f":"IFERROR(DataPivot!B67,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C67,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D67,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E67,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F67,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G67,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H67,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I67,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J67,\"-\")","v":"-"}]
[68,{"$f":"IFERROR(DataPivot!B68,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C68,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D68,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E68,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F68,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G68,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H68,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I68,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J68,\"-\")","v":"-"}]
[69,{"$f":"IFERROR(DataPivot!B69,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C69,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D69,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E69,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F69,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G69,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H69,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I69,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J69,\"-\")","v":"-"}]
[70,{"$f":"IFERROR(DataPivot!B70,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C70,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D70,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E70,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F70,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G70,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H70,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I70,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J70,\"-\")","v":"-"}]
[71,{"$f":"IFERROR(DataPivot!B71,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C71,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D71,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E71,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F71,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G71,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H71,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I71,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J71,\"-\")","v":"-"}]
[72,{"$f":"IFERROR(DataPivot!B72,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C72,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D72,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E72,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F72,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G72,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H72,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I72,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J72,\"-\")","v":"-"}]
[73,{"$f":"IFERROR(DataPivot!B73,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C73,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D73,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E73,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F73,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G73,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H73,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I73,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J73,\"-\")","v":"-"}]
[74,{"$f":"IFERROR(DataPivot!B74,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C74,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D74,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E74,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F74,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G74,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H74,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I74,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J74,\"-\")","v":"-"}]
[75,{"$f":"IFERROR(DataPivot!B75,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C75,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D75,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E75,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F75,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G75,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H75,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I75,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J75,\"-\")","v":"-"}]
[76,{"$f":"IFERROR(DataPivot!B76,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C76,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D76,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E76,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F76,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G76,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H76,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I76,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J76,\"-\")","v":"-"}]
[77,{"$f":"IFERROR(DataPivot!B77,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C77,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D77,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E77,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F77,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G77,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H77,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I77,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J77,\"-\")","v":"-"}]
[78,{"$f":"IFERROR(DataPivot!B78,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C78,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D78,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E78,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F78,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G78,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H78,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I78,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J78,\"-\")","v":"-"}]
[79,{"$f":"IFERROR(DataPivot!B79,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C79,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D79,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E79,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F79,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G79,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H79,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I79,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J79,\"-\")","v":"-"}]
[80,{"$f":"IFERROR(DataPivot!B80,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C80,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D80,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E80,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F80,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G80,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H80,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I80,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J80,\"-\")","v":"-"}]
[81,{"$f":"IFERROR(DataPivot!B81,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C81,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D81,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E81,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F81,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G81,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H81,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I81,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J81,\"-\")","v":"-"}]
[82,{"$f":"IFERROR(DataPivot!B82,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C82,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D82,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E82,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F82,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G82,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H82,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I82,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J82,\"-\")","v":"-"}]
[83,{"$f":"IFERROR(DataPivot!B83,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C83,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D83,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E83,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F83,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G83,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H83,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I83,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J83,\"-\")","v":"-"}]
[84,{"$f":"IFERROR(DataPivot!B84,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C84,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D84,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E84,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F84,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G84,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H84,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I84,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J84,\"-\")","v":"-"}]
[85,{"$f":"IFERROR(DataPivot!B85,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C85,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D85,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E85,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F85,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G85,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H85,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I85,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J85,\"-\")","v":"-"}]
[86,{"$f":"IFERROR(DataPivot!B86,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C86,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D86,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E86,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F86,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G86,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H86,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I86,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J86,\"-\")","v":"-"}]
[87,{"$f":"IFERROR(DataPivot!B87,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C87,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D87,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E87,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F87,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G87,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H87,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I87,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J87,\"-\")","v":"-"}]
[88,{"$f":"IFERROR(DataPivot!B88,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C88,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D88,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E88,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F88,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G88,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H88,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I88,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J88,\"-\")","v":"-"}]
[89,{"$f":"IFERROR(DataPivot!B89,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C89,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D89,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E89,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F89,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G89,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H89,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I89,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J89,\"-\")","v":"-"}]
[90,{"$f":"IFERROR(DataPivot!B90,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C90,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D90,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E90,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F90,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G90,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H90,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I90,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J90,\"-\")","v":"-"}]
[91,{"$f":"IFERROR(DataPivot!B91,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C91,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D91,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E91,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F91,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G91,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H91,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I91,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J91,\"-\")","v":"-"}]
[92,{"$f":"IFERROR(DataPivot!B92,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C92,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D92,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E92,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F92,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G92,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H92,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I92,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J92,\"-\")","v":"-"}]
[93,{"$f":"IFERROR(DataPivot!B93,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C93,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D93,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E93,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F93,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G93,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H93,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I93,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J93,\"-\")","v":"-"}]
[94,{"$f":"IFERROR(DataPivot!B94,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C94,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D94,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E94,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F94,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G94,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H94,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I94,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J94,\"-\")","v":"-"}]
[95,{"$f":"IFERROR(DataPivot!B95,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C95,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D95,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E95,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F95,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G95,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H95,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I95,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J95,\"-\")","v":"-"}]
[96,{"$f":"IFERROR(DataPivot!B96,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C96,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D96,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E96,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F96,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G96,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H96,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I96,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J96,\"-\")","v":"-"}]
[97,{"$f":"IFERROR(DataPivot!B97,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C97,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D97,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E97,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F97,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G97,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H97,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I97,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J97,\"-\")","v":"-"}]
[98,{"$f":"IFERROR(DataPivot!B98,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C98,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D98,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E98,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F98,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G98,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H98,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I98,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J98,\"-\")","v":"-"}]
[99,{"$f":"IFERROR(DataPivot!B99,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C99,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D99,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E99,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F99,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G99,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H99,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I99,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J99,\"-\")","v":"-"}]
[100,{"$f":"IFERROR(DataPivot!B100,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!C100,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!D100,\"-\")","v":"-"},"-",{"$f":"IFERROR(DataPivot!E100,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!F100,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!G100,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!H100,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!I100,\"-\")","v":"-"},{"$f":"IFERROR(DataPivot!J100,\"-\")","v":"-"}]

{"sheet":"DataPivot","index":2,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["abc",{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$1\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$2\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$8\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$11\")+INDIRECT(\"'\"&$A1&\"'!$D$12\")+INDIRECT(\"'\"&$A1&\"'!$D$13\")+INDIRECT(\"'\"&$A1&\"'!$D$14\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$16\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$17\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$18\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$19\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A1&\"'!$D$20\")","v":{"$error":"#REF!"}}]
["S.2",{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$1\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$2\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$8\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$11\")+INDIRECT(\"'\"&$A2&\"'!$D$12\")+INDIRECT(\"'\"&$A2&\"'!$D$13\")+INDIRECT(\"'\"&$A2&\"'!$D$14\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$16\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$17\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$18\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$19\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A2&\"'!$D$20\")","v":{"$error":"#REF!"}}]
["S.3",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.4",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.5",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.6",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.7",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.8",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.9",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.10",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.11",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.12",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.13",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.14",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.15",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.16",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.17",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.18",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.19",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.20",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.21",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.22",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.23",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.24",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.25",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.26",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.27",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.28",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.29",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.30",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.31",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.32",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.33",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.34",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.35",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.36",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.37",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.38",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.39",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.40",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.41",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.42",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.43",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.44",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.45",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.46",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.47",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.48",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.49",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.50",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.51",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.52",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.53",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.54",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.55",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.56",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.57",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.58",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.59",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.60",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.61",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.62",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.63",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.64",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.65",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.66",{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$1\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$2\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$8\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$11\")+INDIRECT(\"'\"&$A66&\"'!$D$12\")+INDIRECT(\"'\"&$A66&\"'!$D$13\")+INDIRECT(\"'\"&$A66&\"'!$D$14\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$16\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$17\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$18\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$19\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'\"&$A66&\"'!$D$20\")","v":{"$error":"#REF!"}}]
["S.67",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.68",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.69",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.70",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.71",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.72",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.73",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.74",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.75",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.76",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.77",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.78",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.79",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.80",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.81",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.82",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.83",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.84",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.85",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.86",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.87",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.88",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.89",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.90",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.91",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.92",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.93",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.94",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.95",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.96",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.97",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.98",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.99",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["S.100",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Master Data Entry Template","index":3,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,3],[8,0,8,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[15,1,15,2]]}
[" Supervisor Title:"]
["Supervisor Name - First & Last: ",null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Master Data Entry Template"}]
["Section 1:  Individual Span on Control Calculation"]
["Below, tally the number of FTEs who are direct reports to this supervisor.  Include all staff for whom the supervisor completes a performance evaluation and / or directs and oversees day-to-day work assignments.  For this calculation, each staff in an organization should have only one person to whom they directly report.  Hours worked by part time staff are summed and used to calculate a full time equivalent (FTE)."]
["Type of Staff Supervised","Definition","FTE Calculation Methodology","Number of FTE Supervised"]
["Regular Full Time Direct Reports","Include all regular full-time direct reports, including support staff.   This includes budgeted positions both filled and vacant, for whom the supervisor completes an evaluation.  Full-time staff work 2,080 hours per year.  Do not include part-time staff, temporary and seasonal employees, contractors, interns.    ","Each Full Time Direct Report = 1.0 FTE"]
["Regular Part Time Direct Reports","Include all regular part- time direct reports, including support staff -- both filled and vacant, for whom the supervisor a) completes and evaluation or. b) if no evaluation is done, a position for whom the supervisor directs and oversees day-to-day assignments.  This includes all budgeted part-time positions, at the time the report is completed, regardless of the number of hours worked. Do not include temporary and seasonal employees, contractors, interns.  ","Each Part-Time Direct Report = 1.0 FTE"]
["Total Number of FTE Equivalents Supervised",null,null,{"$f":"SUM(D6:D7)","v":0}]
["Section 2:  Additional Information"]
["Additional Staff Supervised Periodically","Definition","FTE Calculation Methodology","Number of FTE Supervised"]
["Temporary Direct Reports","Temporary direct reports are NOT included in the calculation for direct reports in Section 1.  They should, however, be counted here to inform decisions about an optimal span of contol for this supervisor.   Include all temporary employees supervised.  Do not include contractors, interns, seasonal.  For example, temporary employees hired directly for either full-time or part-time work through a time-limited grant program.  ","Calculate the number or fraction of FTE represented by the total number of hours worked by all temporary workers supervised.  Divide the total number of hours worked by all temporary employees during the fiscal year by 2,080 (or the number of hours worked by a regular FTE in that classification)."]
["Contract Workers Direct Reports","Contract Workers Direct Reports are NOT included in the calculation for direct reports in Section 1.  They should, however, be counted here to inform decisions about an optimal span of contol for this supervisor. Include contractor workers hired through personnel service contracts and whose day-to-day work is supervised by the manager or supervisor.  For example, workers hired through a personnel services contract such as administrative support.  Persons working for the county through a vendor contract that specifies services to be delivered are NOT counted. ","Calculate the number or fraction of FTE represented by the total number of hours worked by all contract workers supervised.  Divide the total number of hours worked by all contract employees during the fiscal year by 2,080 (or the number of hours worked by a regular FTE in that classification)."]
["Interns","Interns are NOT included in the calculation for direct reports in Section 1.  They should, however be counted here to inform decisions about an optimal span of control for this supervisor.  Interns typically work part-time and are associated with an education or job training program.","Calculate the number or fraction of FTE represented by the total number of hours worked by all interns supervised.  Divide the total number of hours worked by all interns during the fiscal year by 2,080 (or the number of hours worked by a regular FTE in that classification)."]
["Seasonal","Seasonal workers are NOT included in the calculation for direct reports in Section 1.  They should, however be counted here to inform decisions about an optimal span of control for this supervisor.  Seasonal workers are those employed for less than 4 months for activities associated with a season such as holidays or summer.","Calculate the number or fraction of FTE represented by the total number of hours worked by all seasonal workers supervised.  Divide the total number of hours worked by all seasonal employees during the fiscal year by 2,080 (or the number of hours worked by a regular FTE in that classification)."]
["Mitigating Factors","Definition"]
["Supervisor Responsibilities","Does the supervisor perform work similar to that of his/her direct reports?  For example, a case work supervisor who also provides direct service to clients."]
["Level of Risk","What is the level of risk to employee or the public in performing duties?  For example, is the work hazardous?  Is there a chance of loss or injury to employee or public?"]
["Proximity of Direct Reports ","Are direct reports in same office as supervisor or in satellite offices or field?"]
["Complex or Routine Tasks ","Are the tasks performed by the direct reports complex and variable, or standardized and routine?"]
["Availability of Technology","Do direct reports, not in the physical office with the supervisor, have mobile technology options available to communicate with supervisor and/or file reports? If all direct reports work in the same office, select N/A."]