{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Budget Worksheet","Strategic Position Request Form","Cost Summary","Sheet3","WC rates","Qry Tables","Sheet1","User Guide"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Budget Worksheet","index":0,"n_rows":230,"n_cols":11,"rows_kept":230,"cut":false,"hidden":false,"merged":[[117,1,118,3],[0,0,0,6],[1,0,1,6],[2,0,2,6],[21,1,21,3],[55,1,55,3],[84,1,84,6],[38,1,38,3],[6,1,6,6],[5,1,5,6],[116,1,116,6],[94,1,94,3],[94,4,96,4],[98,1,98,6],[105,1,105,3],[105,4,107,4],[109,1,109,6],[73,1,73,6],[61,1,61,6],[68,1,68,3],[68,4,70,4],[80,1,80,3],[80,4,82,4]]}
["Town of Marana"]
["Grant Budget Worksheet (Attachment B to Grant Management Manual)"]
[]
[null,null,null,null,null," "]
[null,"Department","SELECT ONE"]
[]
[null,"A.  Personnel Costs"]
[null,"Position Title:",null,"Preliminary Grade No.","<<< SELECT >>>"]
[null,"# of Positions:",1]
["Fund","Object","Description",null,"Request Total",null,null,null,null," "]
[1000,5110,"Salaries & Wages",null,{"$f":"VLOOKUP(E8,$C$201:$D$230,2,FALSE)","v":0}]
[{"$f":"+A11","v":1000},5120,"Overtime",null,0,null,null,null," "]
[{"$f":"+A12","v":1000},5140,"FICA",null,{"$f":"ROUND(IF(SUM(E$11:E$12)=0,0,SUM(E$11:E$12)*FICA),0)","v":0}]
[1000,5145,"SUTA",null,{"$f":"IF(E11=0,\"\",68)","v":""},null," ",null,null,null," "]
[{"$f":"+A13","v":1000},5150,"Worker's Compensation","<<< SELECT ITEM >>>",{"$f":"IF(D15=\"\",\"\",ROUND(IF(SUM(E$11:E12)=0,0,SUM(E$11:E$12)/100*VLOOKUP($D15,D143:F153,3,FALSE)),-1))","v":0}]
[1000,5155,"Health Insurance",null,{"$f":"IF(OR(E11=0,C130=1),0,IF(SUM(E$11:E$12)=0,0,$F$125))","v":0}]
[1000,5160,"Dental Insurance",null,{"$f":"IF(SUM(E16)=0,0,F126)","v":0},null,null,null," "]
[1000,5165,"Life Insurance",null,{"$f":"ROUND(IF(OR(SUM(E$11:E$12)=\"\",E16=0),0,SUM(E$11:E$12)*2/1000*life*12),-1)","v":0}]
[1000,5170,"Disability Insurance",null,{"$f":"ROUND(IF(OR(SUM(E$11:E$12)=0,E16=0),0,SUM(E$11:E$12)*Disability),-1)","v":0}]
[1000,5175,"Retirement","<<< SELECT ITEM >>>",{"$f":"IF(D20=\"\",\"\",ROUND(IF(SUM(E$11:E$12)=0,0,SUM(E$11:E$12)*VLOOKUP(D20,D131:F134,3,FALSE)),0))","v":0},null,null,null,null," "]
[1000]
[null,"Subtotal",null,null,{"$f":"SUM(E11:E21)*C9","v":0}]
[]
[]
[null,"Position Title:",null,"Preliminary Grade No.  ","<<< SELECT >>>"]
[null,"# of Positions:",1]
[null,"Object","Description",null,"Request Total"]
[null,5110,"Salaries & Wages",null,{"$f":"VLOOKUP(E25,$C$201:$D$230,2,FALSE)","v":0}]
[null,5120,"Overtime",null,0]
[null,5140,"FICA",null,{"$f":"ROUND(IF(SUM(E$28:E$29)=0,0,SUM(E$28:E$29)*FICA),0)","v":0}]
[null,5145,"SUTA",null,{"$f":"IF(E28=0,\"\",68)","v":""}]
[null,5150,"Worker's Compensation","<<< SELECT ITEM >>>",{"$f":"IF(D32=\"\",\"\",ROUND(IF(SUM(E$28:E29)=0,0,SUM(E$28:E$29)/100*VLOOKUP($D32,D143:F153,3,FALSE)),-1))","v":0}]
[null,5155,"Health Insurance",null,{"$f":"IF(OR(E28=0,C130=1),0,IF(SUM(E$28:E$29)=0,0,$F$125))","v":0}]
[null,5160,"Dental Insurance",null,{"$f":"IF(SUM(E33)=0,0,F126)","v":0}]
[null,5165,"Life Insurance",null,{"$f":"ROUND(IF(OR(SUM(E$28:E$29)=\"\",E33=0),0,SUM(E$28:E$29)*2/1000*life*12),-1)","v":0}]
[null,5170,"Disability Insurance",null,{"$f":"ROUND(IF(OR(SUM(E$28:E$29)=0,E33=0),0,SUM(E$28:E$29)*Disability),-1)","v":0}]
[null,5175,"Retirement","<<< SELECT ITEM >>>",{"$f":"IF(D37=\"\",\"\",ROUND(IF(SUM(E$28:E$29)=0,0,SUM(E$28:E$29)*VLOOKUP(D37,D131:F134,3,FALSE)),0))","v":0}]
[]
[null,"Subtotal",null,null,{"$f":"SUM(E28:E38)*C26","v":0}]
[]
[]
[null,"Position Title:",null,"Preliminary Grade No.  ","<<< SELECT >>>"]
[null,"# of Positions:",1]
[null,"Object","Description",null,"Request Total"]
[null,5110,"Salaries & Wages",null,{"$f":"VLOOKUP(E42,$C$201:$D$230,2,FALSE)","v":0}]
[null,5120,"Overtime",null,0]
[null,5140,"FICA",null,{"$f":"ROUND(IF(SUM(E$45:E$46)=0,0,SUM(E$45:E$46)*FICA),0)","v":0}]
[null,5145,"SUTA",null,{"$f":"IF(E45=0,\"\",68)","v":""}]
[null,5150,"Worker's Compensation","<<< SELECT ITEM >>>",{"$f":"IF(D49=\"\",\"\",ROUND(IF(SUM(E$45:E46)=0,0,SUM(E$45:E$46)/100*VLOOKUP($D49,D143:F153,3,FALSE)),-1))","v":0}]
[null,5155,"Health Insurance",null,{"$f":"IF(OR(E45=0,C166=1),0,IF(SUM(E$45:E$46)=0,0,$F$125))","v":0}]
[null,5160,"Dental Insurance",null,{"$f":"IF(SUM(E50)=0,0,F126)","v":0}]
[null,5165,"Life Insurance",null,{"$f":"ROUND(IF(OR(SUM(E$45:E$46)=\"\",E50=0),0,SUM(E$45:E$46)*2/1000*life*12),-1)","v":0}]
[null,5170,"Disability Insurance",null,{"$f":"ROUND(IF(OR(SUM(E$45:E$46)=0,E50=0),0,SUM(E$45:E$46)*Disability),-1)","v":0}]
[null,5175,"Retirement","<<< SELECT ITEM >>>",{"$f":"IF(D54=\"\",\"\",ROUND(IF(SUM(E$45:E$46)=0,0,SUM(E$45:E$46)*VLOOKUP(D37,D131:F134,3,FALSE)),0))","v":0}]
[]
[null,"Subtotal",null,null,{"$f":"SUM(E45:E55)*C43","v":0}]
[]
[null,null,null,null,"Total"]
[null,null,null,"Total Projected Costs",{"$f":"E22+E39+E56","v":0}]
[]
[]
[null,"B.  Interns & Non-Benefit Eligible Positions"]
["Fund","Quantity","Position","Rate & hours","Request Total"]
[1000,"EX. - 1","Intern"," at 12/hr @ 20 hours per week ",{"$f":"12*(2080/2)","v":12480}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Total Projected Costs",null,null,{"$f":"SUM(E65:E68)","v":0}]
[]
[]
[]
[]
[null,"C.  Contractors"]
["Fund","Object","Description",null,"Request Total"]
[1000,"EX. - 6510","Contract Labor","Yoga Instructor",7000]
[{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Total Projected Costs",null,null,{"$f":"SUM(E77:E80)","v":0}]
[]
[]
[]
[null,"D.  Operating Supplies, Equipment, Tavel, Training, Etc."]
["Fund","Object","Description",null,"Request Total"]
[1000,"Ex.- 7130","Uniforms","To purchase PPE for employees",2500]
[{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,"Total Projected Costs",null,null,{"$f":"SUM(E88:E94)","v":0}]
[]
[]
[]
[null,"E.  Capital Outlay"]
["Fund","Object","Description",null,"Request Total"]
[1000,"EX. - 8615","Vehicle Purchase","New F250 for Street Maint. Divison",45000]
[{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Total Projected Costs",null,null,{"$f":"SUM(E102:E105)","v":0}]
[]
[]
[]
[null,"F. Indirect Costs"]
[null,null,"Indirect costs allowable?"]
[null,null,"NO"]
["Fund","Object","Description",null,"Indirect Costs Requested"]
[{"$f":"+A40","v":0},null,"Calculated @ 10%",null,{"$f":"IF($C112=\"YES\",(SUM(E59,E95,E69,E81,E106)*0.1), 0)","v":0}]
[]
[]
[null,"TOTAL PROJECTED EXPENDITURES"]
[null,"ESTIMATED TOTAL:",null,null,"TOTAL REQUESTED"]
[null,null,null,null,{"$f":"E59+E69+E81+E95+E106+E114","v":0}]
[]
[]
[]
["Hide Rows 62 through 176"]
[null,null,"Family Ins. Rates"]
[null,null,"Health",null,null,13550]
[null,null,"Dental",null,null,1150]
[]
[]
[null,null,"Part-time"]
[null,null,0]
[null,null,"Retirement Codes","<<< SELECT ITEM >>>",1,0]
[null,null,"PR","Public Safety Retirement System",2,0.3266]
[null,null,"CR","Correctional Officers Retirement System",3,0.11550000000000001]
[null,null,"SR","Arizona State Retirement System",4,0.1148]
[null,null,"SS1","OASDI",null,6.2E-2]
[null,null,"SS2","Medicare",null,1.4500000000000001E-2]
[null,null,"SS3","FICA",null,{"$f":"SUM(F135:F136)","v":7.6499999999999999E-2}]
[null,null,"SD","Disability Insurance",null,2.3999999999999998E-3]
[null,null,null,"Life Insurance",null,0.91]
[]
[]
[null,null,null,null,null,"PERCENTAGES"]
[null,null,"WC","<<< SELECT ITEM >>>",1,0]
[null,null,null,"Street or Road Construction--Paving or Repaving & Drivers",{"$f":"+E143+1","v":2},15.033099999999999]
[null,null,null,"Waterworks Operation & Driver",{"$f":"+E144+1","v":3},5.9077000000000002]
[null,null,null,"Police Officers & Drivers",4,7.4569999999999999]
[null,null,null,"Auto Service or Repair Center & Drivers",5,4.75]
[null,null,null,"Volunteer Police Officers/Firefighters/County",6,1.5152000000000001]
[null,null,null,"Clerical Office Employees NOC/Library/Museum",7,0.40860000000000002]
[null,null,null,"Attorney-All Employees & Clerical, Messengers, Drivers",8,0.37459999999999999]
[null,null,null,"Recreation Centers-All Employees & Clerical",9,2.3323999999999998]
[null,null,null,"Parks NOC All Employees & Drivers",10,5.2778]
[null,null,null,"Municipal, Township, County or State Employee NOC",11,2.9794]
[]
[]
["Personnel Requests",null,null,null,null,"Life","Maint.","Fuel"]
[null,"Auto-Sedan",true,null,27300,5,1200,{"$f":"ROUND(100000/F157/20*2.5,0)","v":2500}]
[null,"Auto-Small Truck",false,null,28500,5,1400,{"$f":"ROUND(100000/F158/18*2.5,-1)","v":2780}]
[null,"Auto-1 Ton Truck",false,null,46500,7,2000,{"$f":"ROUND(120000/F159/12*2.5,-1)","v":3570}]
[null,"Auto-Police Cruiser",false,null,68500,5,3000,{"$f":"ROUND(100000/F160/15*2.5,-1)","v":3330}]
[null,"Office Furniture",false,null,6000]
[null,"Computer",false,null,2500,3]
[null,"Telephone",false]
[null,"PPE & Uniform",false]
[null,null,6440,"Vehicle Maintenance Charges",{"$f":"ROUND(IF(C157=TRUE,G157,IF(C158=TRUE,G158,IF(C159=TRUE,G159,IF(C160=TRUE,G160,0)))),-1)","v":1200}]
[null,null,7155,"Fuel and Oil",{"$f":"ROUND(IF(C157=TRUE,H157,IF(C158=TRUE,H158,IF(C159=TRUE,H159,IF(C160=TRUE,H160,0)))),-1)","v":2500}]
[null,null,7930,"Tech Replacement Charges",{"$f":"ROUND(+E162/3,-1)","v":830}]
[null,null,7920,"Vehicle Replacement Charges",{"$f":"ROUND(IF(C157=TRUE,E157/F157,IF(C158=TRUE,E158/F158,IF(C159=TRUE,E159/F159,IF(C160=TRUE,E160/F160,0)))),-1)","v":5460}]
[null,null,7620,"Furniture and Fixtures",null,5000]
[null,null,7615,"Computer & Phone Equipment",null,2800]
[null,null,8605,"Vehicles",null,{"$f":"ROUND(IF(C157=TRUE,E157,IF(C158=TRUE,E158,IF(C159=TRUE,E159,IF(C160=TRUE,E160,0)))),-1)","v":27300}]
[]
[null,null,7940,"Equipment Replacement Charges"]
[null,null,7335,"Cell Phone Service",null,620]
[null,null,7130,"PPE, Uniform, Boots",null,2150]
[]
[null,null,1200,"TOWN MANAGER"]
[null,null,1300,"TOWN CLERK"]
[null,null,1400,"HUMAN RESOURCES"]
[null,null,1500,"FINANCE"]
[null,null,1600,"LEGAL"]
[null,null,1700,"TECHNOLOGY SERVICES"]
[null,null,1800,"ECONOMIC & TOURISM DEVELOPMENT"]
[null,null,2000,"DEVELOPMENT SERVICES ADMIN"]
[null,null,2100,"COMMUNICATIONS"]
[null,null,2200,"BUILDING SAFETY"]
[null,null,2300,"PLANNING"]
[null,null,2400,"ENGINEERING"]
[null,null,3100,"POLICE"]
[null,null,3200,"MAGISTRATE COURT"]
[null,null,4000,"PUBLIC WORKS ADMIN"]
[null,null,4100,"OPERATIONS & MAINTENANCE"]
[null,null,4200,"ENGINEERING (NOT USED)"]
[null,null,4300,"CIP DIVISION"]
[null,null,5100,"PARKS & RECREATION"]
[null,null,6100,"COMMUNITY DEVELOPMENT"]
[null,null,9000,"WATER DEPARTMENT"]
[null,null,9100,"WASTE WATER"]
[null,null,9200,"AIRPORT OPERATIONS"]
[null,null,"Grade #","Midpoint"]
[null,1,"<<< SELECT >>>",0]
[null,2,105,42960,"NOT USED"]
[null,3,106,46397,"NOT USED"]
[null,4,107,50109,"NOT USED"]
[null,5,108,{"$f":"0.9*55199","v":49679.1}]
[null,6,109,{"$f":"0.9*60168","v":54151.200000000004}]
[null,7,110,{"$f":"0.9*66185","v":59566.5}]
[null,8,111,{"$f":"0.9*73465","v":66118.5}]
[null,9,112,{"$f":"0.9*82281","v":74052.900000000009}]
[null,10,113,{"$f":"0.9*92977","v":83679.3}]
[null,11,114,{"$f":"0.9*105065","v":94558.5}]
[null,12,115,{"$f":"0.9*118723","v":106850.7}]
[null,13,203,26438,"NOT USED"]
[null,14,204,28025,"NOT USED"]
[null,15,205,{"$f":"0.9*30300","v":27270}]
[null,16,206,{"$f":"0.9*32421","v":29178.9}]
[null,17,207,{"$f":"0.9*34690","v":31221}]
[null,18,208,{"$f":"0.9*37119","v":33407.1}]
[null,19,209,{"$f":"0.9*39717","v":35745.300000000003}]
[null,20,210,{"$f":"0.9*42497","v":38247.300000000003}]
[null,21,211,{"$f":"0.9*45472","v":40924.800000000003}]
[null,22,212,{"$f":"0.9*49110","v":44199}]
[null,23,213,{"$f":"0.9*53039","v":47735.1}]
[null,24,214,{"$f":"0.9*57812","v":52030.8}]
[null,25,215,{"$f":"0.9*63593","v":57233.700000000004}]
[null,26,"PO",{"$f":"0.9*57950","v":52155}]
[null,27,"SGT",{"$f":"0.9*77034","v":69330.600000000006}]
[null,28,"LT",{"$f":"0.9*96844","v":87159.6}]
[null,29,"CAPT",{"$f":"0.9*109578","v":98620.2}]
[null,30,"INTERN/MGMT ",{"$f":"13.5*2080/2","v":14040}]

{"sheet":"Strategic Position Request Form","index":1,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,9],[1,0,1,9],[10,3,10,9],[7,5,7,9],[51,0,53,9],[3,1,3,2],[22,0,23,9],[18,0,19,9],[20,0,20,9],[24,0,25,8],[5,2,5,3],[15,0,17,9],[14,0,14,9],[11,0,12,9],[8,0,9,9],[26,9,27,9],[55,0,56,9],[57,0,59,9],[61,0,62,9],[28,1,29,8],[30,1,31,8],[32,1,33,8],[32,9,33,9],[34,9,35,9],[30,9,31,9],[63,0,65,9],[13,4,13,9],[34,1,35,8],[37,0,38,9],[39,0,41,9],[43,0,44,9],[45,0,47,9],[49,0,50,9],[24,9,25,9],[26,0,27,0],[28,0,29,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[26,1,27,8],[28,9,29,9]]}
["Budget Process FY 2015 - 2016"]
["Strategic Position Request Form"]
[]
["Date:"]
[]
["Department:     "]
[]
["Proposed New Position or current Position Title:"]
[]
[]
["Incumbent (if applicable):                                     "]
[]
[]
["Immediate Supervisor (Name/title):"]
[]
["PLEASE EMAIL THIS FORM TO THE HUMAN RESOURCES DEPARTMENT ALONG WITH A JOB EVALUATION MANUAL, A CURRENT AND PROPOSED ORGANIZATION CHART. CONTACT MAYRA MORA WITH ANY QUESTIONS."]
[]
[]
["Justification: State your request to either add a new position or change an existing position. Please provide sufficient detail to describe the key duties that will be performed by this position. What generated the need for these new duties to be assigned to this position (i.e., change in staffing, new program, reorganization)?"]
[]
[]
[]
["Five major essential duties: List the top five major and essential duties that this position will perform and the percentage of time that will be spent on each totaling 100%.  "]
[]
["ESSENTIAL DUTIES (Major and Important Duties)",null,null,null,null,null,null,null,null,"Relative Time spent as %"]
[]
["1.       ","  "]
[]
["2.       "," "]
[]
["3.       "," "]
[]
["4.       "," "]
[]
["5.       "," "]
[]
[]
["Minimum years of experience: List the type of experience that would be required at time of hire for this position."]
[]
[]
[]
[]
[]
["Minimum education: List the type of education and/or certifications that would be required at time of hire for this position."]
[]
[]
[]
[]
[]
["Impact: How will this position change the work of your department? How will your department be impacted if this request is put on hold?"]
[]
[]
[]
[]
[]
["Strategic Plan: Describe how this position aligns with the Strategic Plan. Include the focus area, initiative, goal, or strategy that this position will impact and how."]
[]
[]
[]
[]
[]
["Additional Comments: Please provide any other comments that will help make your request better understood."]

{"sheet":"Cost Summary","index":2,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":true,"merged":[[16,0,16,3]]}
["Line","Department ","Position ","Pay Grade","Source","Ongoing","One-time"," Total Cost ","Status"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
["Grand Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table3[Ongoing])","v":0},{"$f":"SUBTOTAL(109,Table3[One-time])","v":0},{"$f":"SUBTOTAL(109,Table3[[ Total Cost ]])","v":0}]

{"sheet":"Sheet3","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["SELECT ONE"]
["TOWN MANAGER"]
["TOWN CLERK"]
["HUMAN RESOURCES"]
["FINANCE"]
["LEGAL"]
["TECHNOLOGY SERVICES"]
["ECONOMIC & TOURISM DEVELOPMENT"]
["DEVELOPMENT SERVICES ADMIN"]
["RECORDS"]
["BUILDING SAFETY"]
["PLANNING"]
["ENGINEERING"]
["POLICE"]
["MAGISTRATE COURT"]
["PUBLIC WORKS ADMIN"]
["OPERATIONS & MAINTENANCE"]
["CIP DIVISION"]
["PARKS & RECREATION"]
["COMMUNITY DEVELOPMENT"]
["WATER"]
["WATER RECLAMATION"]
["AIRPORT"]
[]
[]
[]
[null,null,null,"INDIRECT COTS"]
[]
[null,null,null,"SELECT ONE"]
[null,null,null,"YES"]
[null,null,null,"NO"]

{"sheet":"WC rates","index":4,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["CLASS DESCRIPTION","2009/2010","2010/2011","2011/2012","2012/2013","2013/2014","2013/2014","2014/2015"]
["Street or Road Construction--Paving or Repaving & Drivers",6.98,8.0299999999999994,8.83,8.83,8.83,8.83,8.83]
["Waterworks Operation & Driver",2.87,3.3,3.47,3.47,3.47,3.47,3.47]
["Police Officers & Drivers",3.53,4.0599999999999996,4.38,4.38,4.38,4.38,4.38]
["Auto Service or Repair Center & Drivers",2.99,2.54,2.79,2.79,2.79,2.79,2.79]
["Volunteer Police Officers/Firefighters/County",0.7,0.81,0.89,0.89,0.89,0.89,0.89]
["Clerical Office Employees NOC/Library/Museum",0.27,0.23,0.24,0.24,0.24,0.24,0.24]
["Attorney-All Employees & Clerical, Messengers, Drivers",0.21,0.18,0.22,0.22,0.22,0.22,0.22]
["Recreation Centers-All Employees & Clerical",1.19,1.37,1.37,1.37,1.37,1.37,1.37]
["Parks NOC All Employees & Drivers",3.56,3.03,3.1,3.1,3.1,3.1,3.1]
["Municipal, Township, County or State Employee NOC",1.45,1.67,1.75,1.75,1.75,1.75,1.75]
["Salespersons, Collectors or Messengers--Outside",0.43]

{"sheet":"Qry Tables","index":5,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["EFFECTIVE DATE","GROUP/BU","GROUP/BU DESC","PAYBAND","GRADE/RANK OR PAYBAND","DESCRIPTION","PAY BASIS","PAY BASIS DESC","PAY FREQUENCY","PAY FREQUENCY DESC","PAY CALC CODE","PAY CALC CODE DESC","STEP/LEVEL","HOURLY RATE","DAILY RATE","PERIOD SALARY","ANNUAL SALARY"]
["2014-06-28","1CLS","CLASSIFIED","Y","105","PAY GRADE 105","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,20.654,165.23220000000001,1652.32,42960.36]
["2014-06-28","1CLS","CLASSIFIED","Y","106","PAY GRADE 106","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,22.306100000000001,178.44900000000001,1784.49,46396.74]
["2014-06-28","1CLS","CLASSIFIED","Y","107","PAY GRADE 107","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,24.090599999999998,192.7251,1927.25,50108.52]
["2014-06-28","1CLS","CLASSIFIED","Y","108","PAY GRADE 108","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,26.017900000000001,208.14279999999999,2081.4299999999998,54117.120000000003]
["2014-06-28","1CLS","CLASSIFIED","Y","109","PAY GRADE 109","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,28.3599,226.8794,2268.79,58988.639999999999]
["2014-06-28","1CLS","CLASSIFIED","Y","110","PAY GRADE 110","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,31.195900000000002,249.56649999999999,2495.67,64887.3]
["2014-06-28","1CLS","CLASSIFIED","Y","111","PAY GRADE 111","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,34.627000000000002,277.0163,2770.16,72024.240000000005]
["2014-06-28","1CLS","CLASSIFIED","Y","112","PAY GRADE 112","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,38.782499999999999,310.26049999999998,3102.6,80667.72]
["2014-06-28","1CLS","CLASSIFIED","Y","113","PAY GRADE 113","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,43.824300000000001,350.59359999999998,3505.94,91154.34]
["2014-06-28","1CLS","CLASSIFIED","Y","114","PAY GRADE 114","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,49.521500000000003,396.17189999999999,3961.72,103004.7]
["2014-06-28","1CLS","CLASSIFIED","Y","115","PAY GRADE 115","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",1,55.959299999999999,447.67410000000001,4476.74,116395.26]
["2014-06-28","1CLS","CLASSIFIED","Y","203","PAY GRADE 203","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,12.710800000000001,101.68600000000001,1016.86,26438.36]
["2014-06-28","1CLS","CLASSIFIED","Y","204","PAY GRADE 204","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,13.4734,107.78700000000001,1077.8699999999999,28024.62]
["2014-06-28","1CLS","CLASSIFIED","Y","205","PAY GRADE 205","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,14.281499999999999,114.252,1142.52,29705.52]
["2014-06-28","1CLS","CLASSIFIED","Y","206","PAY GRADE 206","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,15.2814,122.251,1222.51,31785.26]
["2014-06-28","1CLS","CLASSIFIED","Y","207","PAY GRADE 207","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,16.350999999999999,130.80799999999999,1308.08,34010.080000000002]
["2014-06-28","1CLS","CLASSIFIED","Y","208","PAY GRADE 208","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,17.4956,139.965,1399.65,36390.9]
["2014-06-28","1CLS","CLASSIFIED","Y","209","PAY GRADE 209","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,18.720500000000001,149.76400000000001,1497.64,38938.639999999999]
["2014-06-28","1CLS","CLASSIFIED","Y","210","PAY GRADE 210","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,20.030799999999999,160.24600000000001,1602.46,41663.96]
["2014-06-28","1CLS","CLASSIFIED","Y","211","PAY GRADE 211","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,21.4328,171.46199999999999,1714.62,44580.12]
["2014-06-28","1CLS","CLASSIFIED","Y","212","PAY GRADE 212","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,23.147600000000001,185.18100000000001,1851.81,48147.06]
["2014-06-28","1CLS","CLASSIFIED","Y","213","PAY GRADE 213","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,24.999400000000001,199.995,1999.95,51998.7]
["2014-06-28","1CLS","CLASSIFIED","Y","214","PAY GRADE 214","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,27.249300000000002,217.994,2179.94,56678.44]
["2014-06-28","1CLS","CLASSIFIED","Y","215","PAY GRADE 215","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",1,29.974299999999999,239.79400000000001,2397.94,62346.44]
["2014-06-28","SWRN","SWORN","N","P1","POLICE OFFICER","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",null,27.585699999999999,220.68600000000001,2206.86,57378.36,null,null,""]
["2014-06-28","SWRN","SWORN","N","P3","SERGEANT","H","HOURLY","B","BIWEEKLY","02","HOURLY RT - STANDARD HRS & AMT",null,36.137500000000003,289.10000000000002,2891,75166,null,null,""]
["2014-06-28","SWRN","SWORN","N","P4","LIEUTENANT","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",null,45.161999999999999,361.29579999999999,3612.96,93936.9,null,null,""]
["2014-06-28","SWRN","SWORN","N","P5","CAPTAIN","A","ANNUAL","B","BIWEEKLY","11","ANNUAL SAL - PER SAL & HOURLY RT COMPUTED",null,52.161799999999999,417.29379999999998,4172.9399999999996,108496.38,null,null,""]
[]
[]
[]
["1200","TOWN MANAGER"]
["1300","TOWN CLERK"]
["1400","HUMAN RESOURCES"]
["1500","FINANCE"]
["1600","LEGAL"]
["1700","TECHNOLOGY SERVICES"]
["1800","ECONOMIC & TOURISM DEVELOPMENT"]
["2000","DEVELOPMENT SERVICES ADMIN"]
["2100","DEVELOPMENT RECORDS"]
["2200","BUILDING SAFETY"]
["2300","PLANNING"]
["2400","ENGINEERING"]
["3100","POLICE"]
["3200","MAGISTRATE COURT"]
["4000","PUBLIC SERVICES ADMIN"]
["4100","OPERATIONS & MAINTENANCE"]
["4200","ENGINEERING (NOT USED)"]
["4300","CIP DIVISION"]
["5100","PARKS & RECREATION"]
["6100","COMMUNITY DEVELOPMENT"]
["9000","WATER DEPARTMENT"]
["9100","WASTE WATER"]
["9200","AIRPORT OPERATIONS"]

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

{"sheet":"User Guide","index":7,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Instructions"]
[]
["A. Personnel Costs","Calculate personnel salaries and benefits that are exclusively supported by the grant. Above each block there is a multiplier function to calculate multiple positions at the same pay grade."]
[]
["B. Interns and Non-Benefit Eligible Positions","Calculate intern and non-benefit eligible positions that are exclusively supported by the grant."]
[]
["C. Contractors","Calculate the estimated costs of contracted work. Procurement Code section 3-4-18 outlines the process by which professional contractors are obtained."]
[]
["D. Operating Supplies, Equipment, Travel, Training, etc.","Calculate the estimated costs of items <5000.00"]
[]
["E. Capital Outlay","Calculate the estimated costs of capital outlay >5000.00. Three quotes are required for costs exceeding 2500.00. Three bids are required for costs exceeding 25,000.00."]
[]
["F. Indirect Costs","Mark \"yes\" only if an indirect cost benefit has been negotiated with the funding agency."]