{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calcs","Calc","Dates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Calcs","index":0,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
["2017-06-09","2017-06-22",0.96153846153846156,3.8461538461538464E-2,null,null,1,null,{"$f":"+C2/100","v":9.6153846153846159E-3},{"$f":"+D2/100","v":3.8461538461538462E-4}]
["2017-06-23","2017-07-06",0.92307692307692302,7.6923076923076927E-2,null,null,{"$f":"+G2+1","v":2},null,{"$f":"+C3/100","v":9.2307692307692299E-3},7.6923076923076923E-4]
["2017-07-07","2017-07-20",0.88461538461538469,0.11538461538461538,null,null,{"$f":"+G3+1","v":3},null,8.8461538461538473E-3,1.1538461538461537E-3]
["2017-07-21","2017-08-03",0.84615384615384615,0.15384615384615385,null,null,4,null,8.4615384615384613E-3,1.5384615384615385E-3]
["2017-08-04","2017-08-17",0.80769230769230771,0.19230769230769235,null,null,5,null,8.076923076923077E-3,1.9230769230769234E-3]
["2017-08-18","2017-08-31",0.76923076923076916,0.23076923076923075,null,null,6,null,7.6923076923076919E-3,2.3076923076923075E-3]
["2017-09-01","2017-09-14",0.73076923076923084,0.26923076923076922,null,null,7,null,7.3076923076923084E-3,2.6923076923076922E-3]
["2017-09-15","2017-09-28",0.69230769230769229,0.30769230769230771,null,null,8,null,6.9230769230769233E-3,3.0769230769230769E-3]
["2017-09-29","2017-10-12",0.65384615384615385,0.34615384615384615,null,null,9,null,6.5384615384615381E-3,3.4615384615384616E-3]
["2017-10-13","2017-10-26",0.61538461538461531,0.38461538461538469,null,null,10,null,6.153846153846153E-3,3.8461538461538468E-3]
["2017-10-27","2017-11-09",0.57692307692307698,0.42307692307692307,null,null,11,null,5.7692307692307696E-3,4.2307692307692307E-3,null,null,null,null,null,{"$f":"11*5","v":55}]
["2017-11-10","2017-11-23",0.53846153846153844,0.46153846153846151,null,null,12,null,5.3846153846153844E-3,4.6153846153846149E-3]
["2017-11-24","2017-12-07",0.5,0.5,null,null,13,null,5.0000000000000001E-3,5.0000000000000001E-3]
["2017-12-08","2017-12-21",0.46153846153846151,0.53846153846153844,null,null,14,null,4.6153846153846149E-3,5.3846153846153844E-3]
["2017-12-22","2018-01-04",0.42307692307692313,0.57692307692307687,null,null,15,null,4.2307692307692315E-3,5.7692307692307687E-3]
["2018-01-05","2018-01-18",0.38461538461538458,0.61538461538461542,null,null,16,null,3.8461538461538459E-3,6.1538461538461538E-3]
["2018-01-19","2018-02-01",0.34615384615384615,0.65384615384615385,null,null,17,null,3.4615384615384616E-3,6.5384615384615381E-3]
["2018-02-02","2018-02-15",0.30769230769230771,0.69230769230769229,null,null,18,null,3.0769230769230769E-3,6.9230769230769233E-3]
["2018-02-16","2018-03-01",0.26923076923076933,0.73076923076923062,null,null,19,null,2.6923076923076935E-3,7.3076923076923058E-3]
["2018-03-02","2018-03-15",0.23076923076923067,0.76923076923076938,null,null,20,null,2.3076923076923066E-3,7.6923076923076936E-3]
["2018-03-16","2018-03-29",0.19230769230769226,0.80769230769230771,null,null,21,null,1.9230769230769225E-3,8.076923076923077E-3]
["2018-03-30","2018-04-12",0.15384615384615385,0.84615384615384615,null,null,22,null,1.5384615384615385E-3,8.4615384615384613E-3]
["2018-04-13","2018-04-26",0.11538461538461547,0.88461538461538458,null,null,23,null,1.1538461538461548E-3,8.8461538461538456E-3]
["2018-04-27","2018-05-10",7.6923076923076927E-2,0.92307692307692302,null,null,{"$f":"+G24+1","v":24},null,7.6923076923076923E-4,9.2307692307692299E-3]
["2018-05-11","2018-05-24",3.8461538461538394E-2,0.96153846153846156,null,null,25,null,3.8461538461538396E-4,9.6153846153846159E-3]
[43245,43258,0,1,null,null,null,null,0,0.01]

{"sheet":"Calc","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5],[4,1,4,2]]}
["FY18 Salary Prorate Calculator"]
[]
["To be used to calculate pro rated salary for a new (TBA Position) or an existing position being vacated"]
[]
[null,"Enter the Employee's Annual Salary:\n(in whole numbers)"]
[]
[null,null,"Use dropdown to select Date",null,"Prorated Salary - Enter into Budget Construction"]
[]
[null,"NEW POSITION - Start Date",null,null,{"$f":"IF(C9,VLOOKUP(C9,Calcs!A2:C26,3,0)*E5,0)","v":0}]
[]
[null,"VACATED POSITON - End Date",null,null,{"$f":"IF(C11,VLOOKUP(C11,Calcs!B2:D26,3,FALSE)*E5,0)","v":0}]
[]
[]
["Office of Budget and Planning"]

{"sheet":"Dates","index":2,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["If New Hire - Select Start Date","If Employee is Leaving - Select Last Day"]
["2017-06-09","2017-06-22"]
["2017-06-23","2017-07-06"]
["2017-07-07","2017-07-20"]
["2017-07-21","2017-08-03"]
["2017-08-04","2017-08-17"]
["2017-08-18","2017-08-31"]
["2017-09-01","2017-09-14"]
["2017-09-15","2017-09-28"]
["2017-09-29","2017-10-12"]
["2017-10-13","2017-10-26"]
["2017-10-27","2017-11-09"]
["2017-11-10","2017-11-23"]
["2017-11-24","2017-12-07"]
["2017-12-08","2017-12-21"]
["2017-12-22","2018-01-04"]
["2018-01-05","2018-01-18"]
["2018-01-19","2018-02-01"]
["2018-02-02","2018-02-15"]
["2018-02-16","2018-03-01"]
["2018-03-02","2018-03-15"]
["2018-03-16","2018-03-29"]
["2018-03-30","2018-04-12"]
["2018-04-13","2018-04-26"]
["2018-04-27","2018-05-10"]
["2018-05-11","2018-05-24"]
["2018-05-25","2018-06-07"]