{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["LSP Staff Data Input","Help","LSP Staff Data Input (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"LSP Staff Data Input","index":0,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,2,0,7]]}
[null,null,"Microsoft may have blocked macros in the file from running as they regard all files from the Internet with macros untrusted by default. You may follow Microsoft's instructions to unblock the macros, or simply copy the contents you input (From Cell A4 to cell in Column H of the last data row) in this worksheet as a single range and paste the contents in the Staff Data input box of LSP Genie. \t\t\t\t\t"]
[]
["Staffer ID (Optional)","Staffer Name \n(Optional)","Hire Year (Fiscal Year End Year)","Fiscal Year (Annualized) Salary","Expected Years of Service (Optional)","Future Salary Growth Rate (Optional)","LSP Benefit Cap (Optional; Statutory $390,000)","Last Full Month Salary Cap (Optional; Stautory $22,500)"]
["A001","Aaron",2016,500000,20,0.05,0,0]
["B002","Betty",2016,500000,9,0.05,0,0]
["C003","Colin",2020,240000,25,0.1,780000,45000]
["D004","Demi",2016,240000,10,0.04,390000,22500]
["E005","Eric",2016,240000,11,0.04,390000,22500]

{"sheet":"Help","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"LSP Staff Data Input (2)","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Staffer ID (Optional)","Staffer Name \n(Optional)","Hire Year (Fiscal Year End Year)","Fiscal Year (Annualized) Salary","Expected Years of Service (Optional)","Future Salary Growth Rate (Optional)","LSP Benefit Cap (Optional; Statutory $390,000)","Last Full Month Salary Cap (Optional; Stautory $22,500)"]
["A","Aaron",2018,120000,8,0.04,390000,22500]
["B","Betty",2019,124800,8,0.04,390000,22500]
["C","Colin",2017,129792,10,0.04,390000,22500]
["D","Demi",2020,134983.67999999999,10,0.04,390000,22500]
["E","Eric",2016,140383.02720000001,10,0.04,390000,22500]
["F","Fiona",2016,145998.34830000001,10,0.04,390000,22500]
["G","Gary",2016,151838.28219999999,10,0.04,390000,22500]
["H","Helen",2024,157911.81349999999,10,0.04,390000,22500]