{"text_format":"2","workbook":"xls","n_sheets":11,"sheets":["Form 1 entire project","Form 1 year 1","Form 1 year 2","Form 1 year 3","Form 1 year 4","Form 1 year 5","Form 1 year 6","Form 2 SS","Form 2 JLF","Form 2 RA","Printing"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":58,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Form 1 entire project","index":0,"n_rows":94,"n_cols":4,"rows_kept":94,"cut":false,"hidden":false,"merged":[[9,0,9,3],[10,0,10,3],[22,0,22,3],[24,0,24,3],[25,0,25,3],[43,0,43,3],[44,0,44,3],[48,0,48,3],[49,0,49,3],[63,0,63,3],[64,0,64,3],[67,0,67,3],[68,0,68,3],[72,0,72,3],[73,0,73,3],[81,1,82,1],[81,2,82,2],[81,3,82,3],[88,0,88,3],[89,0,89,3],[83,1,84,1],[83,2,84,2],[83,3,84,3],[87,0,87,3]],"flags":["formulas_cached_only"]}
[null,"Final Proposal Budget Form "]
[null,"Summary for Entire Project"]
["Project Title:  Monitoring and Modeling of Pavement Response and Performance"]
["Task C4"]
["Research Organization: ORITE, Ohio University       Principal Investigators: S. Sargand, J. L. Figueroa"]
[]
["Project Duration: 72 months"]
[]
[null,"ODOT Share","Organizational Cost Sharing","TOTAL"]
["SALARIES & WAGES"]
["Specify number of hours to be work and hourly rate for each individual below.  Salaries & Wages may be shown as a percentage of a total salary.  In this case, the percentage of the salary to be paid and the total salary for each individual must be listed.  The same unit, hours or percent, must be used for all personnel in all sections of the final proposal budget form."]
["Co-PI – S. Sargand"]
[]
["approximately 3.01% Time AY",29578.346662934164,0,29578.346662934164]
["(initial AY salary = $151,776)*"]
["Co-PI – J.L. Figueroa"]
[]
["approximately 3.31% Time AY",21276.852826878203,0,21276.852826878203]
["(initial AY salary = $100,000)*"]
["Graduate Student"]
["0.25 students (initial FY salary $18,000)*",29107.84447935,0,29107.84447935]
["SUB-TOTAL SALARY & WAGES",79963.04396916236,0,79963.04396916236]
["*Salaries are figured with a 3% increase each year."]
[]
["FRINGE BENEFITS"]
["Provide an explanation of what is included and how the figure was derived for each personnel category."]
["Co-PI – S. Sargand"]
["STRS = Salary x $.14",4140.968532810783,0,4140.968532810783]
["Workers Comp = Salary x $.007052",208.5865006670117,0,208.5865006670117]
["Medicare = Salary x $.0145",428.8860266125454,0,428.8860266125454]
["Group Insurance = $8448 x 3.01% AY ",1527.1384615384618,0,1527.1384615384618]
["Co-PI – J. L. Figueroa"]
["STRS = Salary x $.14",2978.7593957629488,0,2978.7593957629488]
["Workers Comp = Salary x $.007052",150.0443661351451,0,150.0443661351451]
["Medicare = Salary x $.0145",308.51436598973396,0,308.51436598973396]
["Group Insurance = $8448 x 3.31% AY ",1667.9384615384618,0,1667.9384615384618]
["Graduate Students"]
["Workers Comp = Salary x $.007052",205.26851926837622,0,205.26851926837622]
["Medicare = Salary x $.0145",422.06374495057497,0,422.06374495057497]
["SUB-TOTAL FRINGE BENEFITS",12038.168375274046,0,12038.168375274046]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",92001.21234443641,0,92001.21234443641]
[]
["SUBCONTRACTOR"]
["A copy of the subcontractor’s budget must be attached.  Reimbursement to Contractor for Subcontractor performance is subject to state accounting guidelines as is the Contractor."]
["SUB-TOTAL SUBCONTRACTOR"]
[null,0,0,0]
[]
["TRAVEL"]
["Must be in accordance with current state guidelines.  Available upon request."]
["In-State Travel "]
["Travel to below project sites for data collection, monitoring, and etc."]
[null,0,0,0]
[]
[null,0,0,0]
[null,0,0,0]
["Individuals traveling will include all personnel involved in proposed research project."]
["Out-of-State Travel"]
["(Prior approval required)"]
["Provide destination, purpose, total mileage, total # of days, total # of meals, total # of trips, names of individual(s) traveling.",0,0,0]
[]
["SUB-TOTAL TRAVEL",0,0,0]
[]
["SUPPLIES"]
["Provide details if over 5% of total budget."]
["SUB-TOTAL SUPPLIES",0,0,0]
[]
["EQUIPMENT"]
["At least 2 quotes for each piece of equipment must be attached.  (See equipment policy for details and exceptions.)"]
["List all items separately.  Time at which the  purchase shall be made must be stated (e.g.: at project initiation, within first five months, etc.)"]
["SUB-TOTAL EQUIPMENT",0,0,0]
[]
["PRINTING"]
["Provide a breakdown of charges including, charge per page, # of pages, total # of copies, binding charges, etc.)"]
["Quarterly Reports"]
["Technical Notes",0,0,0]
["Draft Final Report",35.980000000000004,0,35.980000000000004]
["Executive Summary ",0,0,0]
["Final Report ",308.40000000000003,0,308.40000000000003]
["SUB-TOTAL PRINTING",344.38000000000005,0,344.38000000000005]
[]
["IN-DIRECT COSTS",27987.065389206826,0,27987.065389206826]
["Limited to 35% of Salaries & Wages for Universities"]
["FEES",0,0,0]
["For Commercial Organizations Only.  Negotiated amount based on % of direct costs (excluding sub-contractor and equipment)"]
["SUB-TOTAL INDIRECT COSTS AND FEES",27987.065389206826,0,27987.065389206826]
[]
["OTHER EXPENSES"]
["Any project expense which does not fall into another category"]
["Provide detailed explanation of the expense and applicable breakdown of costs."]
["List individually by category"]
["SUB-TOTAL OTHER EXPENSES",0,0,0]
[]
["TOTAL PROJECT COST",120332.65773364324,0,120332.65773364324]

{"sheet":"Form 1 year 1","index":1,"n_rows":95,"n_cols":4,"rows_kept":95,"cut":false,"hidden":false,"merged":[[89,0,89,3],[90,0,90,3],[84,1,85,1],[84,2,85,2],[84,3,85,3],[88,0,88,3],[68,0,68,3],[73,0,73,3],[74,0,74,3],[82,1,83,1],[82,2,83,2],[82,3,83,3],[49,0,49,3],[63,0,63,3],[64,0,64,3],[67,0,67,3],[25,0,25,3],[43,0,43,3],[44,0,44,3],[48,0,48,3],[9,0,9,3],[10,0,10,3],[22,0,22,3],[24,0,24,3]],"flags":["formulas_cached_only"]}
[null,"Final Proposal Budget Form "]
[null,"Summary for Year 1"]
["Project Title:  Monitoring and Modeling of Pavement Response and Performance"]
["Task C4"]
["Research Organization: ORITE, Ohio University       Principal Investigators: S. Sargand, J. L. Figueroa"]
[]
["Project Duration: 72 months"]
[]
[null,"ODOT Share","Organizational Cost Sharing","TOTAL"]
["SALARIES & WAGES"]
["Specify number of hours to be work and hourly rate for each individual below.  Salaries & Wages may be shown as a percentage of a total salary.  In this case, the percentage of the salary to be paid and the total salary for each individual must be listed.  The same unit, hours or percent, must be used for all personnel in all sections of the final proposal budget form."]
["Co-PI – S. Sargand"]
[]
["3.01% Time AY",4572.738461538462,null,4572.738461538462]
["AY salary = $151,776"]
["Co-PI – J.L. Figueroa"]
[]
["3.33% Time AY",3333.3333333333335,null,3333.3333333333335]
["AY salary = $100,000"]
["Graduate Student"]
["0.25 students (FY salary $18,000)",4500,null,4500]
["SUB-TOTAL SALARY & WAGES",12406.071794871796,0,12406.071794871796]
["*Salaries are figured with a 3% increase each year."]
[]
["FRINGE BENEFITS"]
["Provide an explanation of what is included and how the figure was derived for each personnel category."]
["Co-PI – S. Sargand"]
["STRS = Salary x $.14",640.1833846153847,null,640.1833846153847]
["Workers Comp = Salary x $.007052",32.24695163076923,null,32.24695163076923]
["Medicare = Salary x $.0145",66.3047076923077,null,66.3047076923077]
["Group Insurance = $8448 x 3.01% AY ",254.52307692307693,null,254.52307692307693]
["Co-PI – J. L. Figueroa"]
["STRS = Salary x $.14",466.66666666666674,null,466.66666666666674]
["Workers Comp = Salary x $.007052",23.506666666666668,null,23.506666666666668]
["Medicare = Salary x $.0145",48.333333333333336,null,48.333333333333336]
["Group Insurance = $8448 x 3.33% AY ",281.6,null,281.6]
["Graduate Students"]
["Workers Comp = Salary x $.007052",31.734,null,31.734]
["Medicare = Salary x $.0145",65.25,null,65.25]
["SUB-TOTAL FRINGE BENEFITS",1910.3487875282053,0,1910.3487875282053]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",14316.420582400002,0,14316.420582400002]
[]
["SUBCONTRACTOR"]
["A copy of the subcontractor’s budget must be attached.  Reimbursement to Contractor for Subcontractor performance is subject to state accounting guidelines as is the Contractor."]
["SUB-TOTAL SUBCONTRACTOR"]
[null,null,null,0]
[]
["TRAVEL"]
["Must be in accordance with current state guidelines.  Available upon request."]
["In-State Travel "]
["Travel to below project sites for data collection, monitoring, and etc."]
[null,null,null,0]
[]
[null,null,null,0]
[null,null,null,0]
["Individuals traveling will include all personnel involved in proposed research project."]
["Out-of-State Travel"]
["(Prior approval required)"]
["Provide destination, purpose, total mileage, total # of days, total # of meals, total # of trips, names of individual(s) traveling.",null,null,0]
[]
["SUB-TOTAL TRAVEL",0,0,0]
[]
["SUPPLIES"]
["Provide details if over 5% of total budget."]
["SUB-TOTAL SUPPLIES",0,null,0]
[]
["EQUIPMENT"]
["At least 2 quotes for each piece of equipment must be attached.  (See equipment policy for details and exceptions.)"]
["List all items separately.  Time at which the  purchase shall be made must be stated (e.g.: at project initiation, within first five months, etc.)"]
[]
["SUB-TOTAL EQUIPMENT",0,null,0]
[]
["PRINTING"]
["Provide a breakdown of charges including, charge per page, # of pages, total # of copies, binding charges, etc.)"]
["Quarterly Reports"]
["Technical Notes",null,null,0]
["Draft Final Report",null,null,0]
["Executive Summary ",null,null,0]
["Final Report ",null,null,0]
["SUB-TOTAL PRINTING",0,0,0]
[]
["IN-DIRECT COSTS",4342.125128205128,0,4342.125128205128]
["Limited to 35% of Salaries & Wages for Universities"]
["FEES",0,0,0]
["For Commercial Organizations Only.  Negotiated amount based on % of direct costs (excluding sub-contractor and equipment)"]
["SUB-TOTAL INDIRECT COSTS AND FEES",4342.125128205128,0,4342.125128205128]
[]
["OTHER EXPENSES"]
["Any project expense which does not fall into another category"]
["Provide detailed explanation of the expense and applicable breakdown of costs."]
["List individually by category"]
["SUB-TOTAL OTHER EXPENSES",0,0,0]
[]
["TOTAL PROJECT COST",18658.54571060513,0,18658.54571060513]

{"sheet":"Form 1 year 2","index":2,"n_rows":94,"n_cols":4,"rows_kept":94,"cut":false,"hidden":false,"merged":[[88,0,88,3],[89,0,89,3],[83,1,84,1],[83,2,84,2],[83,3,84,3],[87,0,87,3],[68,0,68,3],[72,0,72,3],[73,0,73,3],[81,1,82,1],[81,2,82,2],[81,3,82,3],[49,0,49,3],[63,0,63,3],[64,0,64,3],[67,0,67,3],[25,0,25,3],[43,0,43,3],[44,0,44,3],[48,0,48,3],[9,0,9,3],[10,0,10,3],[22,0,22,3],[24,0,24,3]],"flags":["formulas_cached_only"]}
[null,"Final Proposal Budget Form "]
[null,"Summary for Year 2"]
["Project Title:  Monitoring and Modeling of Pavement Response and Performance"]
["Task C4"]
["Research Organization: ORITE, Ohio University       Principal Investigators: S. Sargand, J. L. Figueroa"]
[]
["Project Duration: 72 months"]
[]
[null,"ODOT Share","Organizational Cost Sharing","TOTAL"]
["SALARIES & WAGES"]
["Specify number of hours to be work and hourly rate for each individual below.  Salaries & Wages may be shown as a percentage of a total salary.  In this case, the percentage of the salary to be paid and the total salary for each individual must be listed.  The same unit, hours or percent, must be used for all personnel in all sections of the final proposal budget form."]
["Co-PI – S. Sargand"]
[]
["3.01% Time AY",4709.920615384615,null,4709.920615384615]
["AY salary = $156,329.28"]
["Co-PI – J.L. Figueroa"]
[]
["3.33% Time AY",3433.3333333333335,null,3433.3333333333335]
["AY salary = $103,000"]
["Graduate Student"]
["0.25 students (FY salary $18,540)",4635,null,4635]
["SUB-TOTAL SALARY & WAGES",12778.25394871795,0,12778.25394871795]
["*Salaries are figured with a 3% increase each year."]
[]
["FRINGE BENEFITS"]
["Provide an explanation of what is included and how the figure was derived for each personnel category."]
["Co-PI – S. Sargand"]
["STRS = Salary x $.14",659.3888861538462,null,659.3888861538462]
["Workers Comp = Salary x $.007052",33.21436017969231,null,33.21436017969231]
["Medicare = Salary x $.0145",68.29384892307692,null,68.29384892307692]
["Group Insurance = $8448 x 3.01% AY ",254.52307692307693,null,254.52307692307693]
["Co-PI – J. L. Figueroa"]
["STRS = Salary x $.14",480.66666666666674,null,480.66666666666674]
["Workers Comp = Salary x $.007052",24.21186666666667,null,24.21186666666667]
["Medicare = Salary x $.0145",49.78333333333334,null,49.78333333333334]
["Group Insurance = $8448 x 3.33% AY ",281.6,null,281.6]
["Graduate Students"]
["Workers Comp = Salary x $.007052",32.68602,null,32.68602]
["Medicare = Salary x $.0145",67.20750000000001,null,67.20750000000001]
["SUB-TOTAL FRINGE BENEFITS",1951.5755588463594,0,1951.5755588463594]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",14729.82950756431,0,14729.82950756431]
[]
["SUBCONTRACTOR"]
["A copy of the subcontractor’s budget must be attached.  Reimbursement to Contractor for Subcontractor performance is subject to state accounting guidelines as is the Contractor."]
["SUB-TOTAL SUBCONTRACTOR"]
[null,null,null,0]
[]
["TRAVEL"]
["Must be in accordance with current state guidelines.  Available upon request."]
["In-State Travel "]
["Travel to below project sites for data collection, monitoring, and etc."]
[null,null,null,0]
[]
[null,null,null,0]
[null,null,null,0]
["Individuals traveling will include all personnel involved in proposed research project."]
["Out-of-State Travel"]
["(Prior approval required)"]
["Provide destination, purpose, total mileage, total # of days, total # of meals, total # of trips, names of individual(s) traveling.",null,null,0]
[]
["SUB-TOTAL TRAVEL",0,0,0]
[]
["SUPPLIES"]
["Provide details if over 5% of total budget."]
["SUB-TOTAL SUPPLIES",null,null,0]
[]
["EQUIPMENT"]
["At least 2 quotes for each piece of equipment must be attached.  (See equipment policy for details and exceptions.)"]
["List all items separately.  Time at which the  purchase shall be made must be stated (e.g.: at project initiation, within first five months, etc.)"]
["SUB-TOTAL EQUIPMENT",null,null,0]
[]
["PRINTING"]
["Provide a breakdown of charges including, charge per page, # of pages, total # of copies, binding charges, etc.)"]
["Quarterly Reports"]
["Technical Notes",null,null,0]
["Draft Final Report",null,null,0]
["Executive Summary ",null,null,0]
["Final Report ",null,null,0]
["SUB-TOTAL PRINTING",0,0,0]
[]
["IN-DIRECT COSTS",4472.388882051282,0,4472.388882051282]
["Limited to 35% of Salaries & Wages for Universities"]
["FEES",0,0,0]
["For Commercial Organizations Only.  Negotiated amount based on % of direct costs (excluding sub-contractor and equipment)"]
["SUB-TOTAL INDIRECT COSTS AND FEES",4472.388882051282,0,4472.388882051282]
[]
["OTHER EXPENSES"]
["Any project expense which does not fall into another category"]
["Provide detailed explanation of the expense and applicable breakdown of costs."]
["List individually by category"]
["SUB-TOTAL OTHER EXPENSES",0,0,0]
[]
["TOTAL PROJECT COST",19202.21838961559,0,19202.21838961559]

{"sheet":"Form 1 year 3","index":3,"n_rows":94,"n_cols":4,"rows_kept":94,"cut":false,"hidden":false,"merged":[[88,0,88,3],[89,0,89,3],[83,1,84,1],[83,2,84,2],[83,3,84,3],[87,0,87,3],[68,0,68,3],[72,0,72,3],[73,0,73,3],[81,1,82,1],[81,2,82,2],[81,3,82,3],[49,0,49,3],[63,0,63,3],[64,0,64,3],[67,0,67,3],[25,0,25,3],[43,0,43,3],[44,0,44,3],[48,0,48,3],[9,0,9,3],[10,0,10,3],[22,0,22,3],[24,0,24,3]],"flags":["formulas_cached_only"]}
[null,"Final Proposal Budget Form "]
[null,"Summary for Year 3"]
["Project Title:  Monitoring and Modeling of Pavement Response and Performance"]
["Task C4"]
["Research Organization: ORITE, Ohio University       Principal Investigators: S. Sargand, J. L. Figueroa"]
[]
["Project Duration: 72 months"]
[]
[null,"ODOT Share","Organizational Cost Sharing","TOTAL"]
["SALARIES & WAGES"]
["Specify number of hours to be work and hourly rate for each individual below.  Salaries & Wages may be shown as a percentage of a total salary.  In this case, the percentage of the salary to be paid and the total salary for each individual must be listed.  The same unit, hours or percent, must be used for all personnel in all sections of the final proposal budget form."]
["Co-PI – S. Sargand"]
[]
["3.01% Time AY",4851.218233846153,null,4851.218233846153]
["AY salary = $161,019.16"]
["Co-PI – J.L. Figueroa"]
[]
["3.27% Time AY",3468.326923076923,null,3468.326923076923]
["AY salary = $106,090"]
["Graduate Student"]
["0.25 students (FY salary $19,096.20)",4774.05,null,4774.05]
["SUB-TOTAL SALARY & WAGES",13093.595156923075,0,13093.595156923075]
["*Salaries are figured with a 3% increase each year."]
[]
["FRINGE BENEFITS"]
["Provide an explanation of what is included and how the figure was derived for each personnel category."]
["Co-PI – S. Sargand"]
["STRS = Salary x $.14",679.1705527384615,null,679.1705527384615]
["Workers Comp = Salary x $.007052",34.21079098508307,null,34.21079098508307]
["Medicare = Salary x $.0145",70.34266439076923,null,70.34266439076923]
["Group Insurance = $8448 x 3.01% AY ",254.52307692307693,null,254.52307692307693]
["Co-PI – J. L. Figueroa"]
["STRS = Salary x $.14",485.56576923076926,null,485.56576923076926]
["Workers Comp = Salary x $.007052",24.45864146153846,null,24.45864146153846]
["Medicare = Salary x $.0145",50.29074038461538,null,50.29074038461538]
["Group Insurance = $8448 x 3.27% AY ",276.1846153846154,null,276.1846153846154]
["Graduate Students"]
["Workers Comp = Salary x $.007052",33.6666006,null,33.6666006]
["Medicare = Salary x $.0145",69.223725,null,69.223725]
["SUB-TOTAL FRINGE BENEFITS",1977.6371770989294,0,1977.6371770989294]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",15071.232334022005,0,15071.232334022005]
[]
["SUBCONTRACTOR"]
["A copy of the subcontractor’s budget must be attached.  Reimbursement to Contractor for Subcontractor performance is subject to state accounting guidelines as is the Contractor."]
["SUB-TOTAL SUBCONTRACTOR"]
[null,null,null,0]
[]
["TRAVEL"]
["Must be in accordance with current state guidelines.  Available upon request."]
["In-State Travel "]
["Travel to below project sites for data collection, monitoring, and etc."]
[null,null,null,0]
[]
[null,null,null,0]
[null,null,null,0]
["Individuals traveling will include all personnel involved in proposed research project."]
["Out-of-State Travel"]
["(Prior approval required)"]
["Provide destination, purpose, total mileage, total # of days, total # of meals, total # of trips, names of individual(s) traveling.",null,null,0]
[]
["SUB-TOTAL TRAVEL",0,0,0]
[]
["SUPPLIES"]
["Provide details if over 5% of total budget."]
["SUB-TOTAL SUPPLIES",null,null,0]
[]
["EQUIPMENT"]
["At least 2 quotes for each piece of equipment must be attached.  (See equipment policy for details and exceptions.)"]
["List all items separately.  Time at which the  purchase shall be made must be stated (e.g.: at project initiation, within first five months, etc.)"]
["SUB-TOTAL EQUIPMENT",null,null,0]
[]
["PRINTING"]
["Provide a breakdown of charges including, charge per page, # of pages, total # of copies, binding charges, etc.)"]
["Quarterly Reports"]
["Technical Notes",null,null,0]
["Draft Final Report",null,null,0]
["Executive Summary ",null,null,0]
["Final Report ",null,null,0]
["SUB-TOTAL PRINTING",0,0,0]
[]
["IN-DIRECT COSTS",4582.758304923076,0,4582.758304923076]
["Limited to 35% of Salaries & Wages for Universities"]
["FEES",0,0,0]
["For Commercial Organizations Only.  Negotiated amount based on % of direct costs (excluding sub-contractor and equipment)"]
["SUB-TOTAL INDIRECT COSTS AND FEES",4582.758304923076,0,4582.758304923076]
[]
["OTHER EXPENSES"]
["Any project expense which does not fall into another category"]
["Provide detailed explanation of the expense and applicable breakdown of costs."]
["List individually by category"]
["SUB-TOTAL OTHER EXPENSES",0,0,0]
[]
["TOTAL PROJECT COST",19653.99063894508,0,19653.99063894508]

{"sheet":"Form 1 year 4","index":4,"n_rows":94,"n_cols":4,"rows_kept":94,"cut":false,"hidden":false,"merged":[[88,0,88,3],[89,0,89,3],[83,1,84,1],[83,2,84,2],[83,3,84,3],[87,0,87,3],[68,0,68,3],[72,0,72,3],[73,0,73,3],[81,1,82,1],[81,2,82,2],[81,3,82,3],[49,0,49,3],[63,0,63,3],[64,0,64,3],[67,0,67,3],[25,0,25,3],[43,0,43,3],[44,0,44,3],[48,0,48,3],[9,0,9,3],[10,0,10,3],[22,0,22,3],[24,0,24,3]],"flags":["formulas_cached_only"]}
[null,"Final Proposal Budget Form "]
[null,"Summary for Year 4"]
["Project Title:  Monitoring and Modeling of Pavement Response and Performance"]
["Task C4"]
["Research Organization: ORITE, Ohio University       Principal Investigators: S. Sargand, J. L. Figueroa"]
[]
["Project Duration: 72 months"]
[]
[null,"ODOT Share","Organizational Cost Sharing","TOTAL"]
["SALARIES & WAGES"]
["Specify number of hours to be work and hourly rate for each individual below.  Salaries & Wages may be shown as a percentage of a total salary.  In this case, the percentage of the salary to be paid and the total salary for each individual must be listed.  The same unit, hours or percent, must be used for all personnel in all sections of the final proposal budget form."]
["Co-PI – S. Sargand"]
[]
["3.01% Time AY",4996.754780861539,null,4996.754780861539]
["AY salary = $165,849.73"]
["Co-PI – J.L. Figueroa"]
[]
["3.27% Time AY",3572.3767307692306,null,3572.3767307692306]
["AY salary = $109,272.70"]
["Graduate Student"]
["0.25 students (FY salary $19,669.09)",4917.2715,null,4917.2715]
["SUB-TOTAL SALARY & WAGES",13486.40301163077,0,13486.40301163077]
["*Salaries are figured with a 3% increase each year."]
[]
["FRINGE BENEFITS"]
["Provide an explanation of what is included and how the figure was derived for each personnel category."]
["Co-PI – S. Sargand"]
["STRS = Salary x $.14",699.5456693206155,null,699.5456693206155]
["Workers Comp = Salary x $.007052",35.237114714635574,null,35.237114714635574]
["Medicare = Salary x $.0145",72.45294432249231,null,72.45294432249231]
["Group Insurance = $8448 x 3.01% AY ",254.52307692307693,null,254.52307692307693]
["Co-PI – J. L. Figueroa"]
["STRS = Salary x $.14",500.13274230769235,null,500.13274230769235]
["Workers Comp = Salary x $.007052",25.192400705384614,null,25.192400705384614]
["Medicare = Salary x $.0145",51.799462596153845,null,51.799462596153845]
["Group Insurance = $8448 x 3.27% AY ",276.1846153846154,null,276.1846153846154]
["Graduate Students"]
["Workers Comp = Salary x $.007052",34.676598618,null,34.676598618]
["Medicare = Salary x $.0145",71.30043675,null,71.30043675]
["SUB-TOTAL FRINGE BENEFITS",2021.0450616426667,0,2021.0450616426667]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",15507.448073273436,0,15507.448073273436]
[]
["SUBCONTRACTOR"]
["A copy of the subcontractor’s budget must be attached.  Reimbursement to Contractor for Subcontractor performance is subject to state accounting guidelines as is the Contractor."]
["SUB-TOTAL SUBCONTRACTOR"]
[null,null,null,0]
[]
["TRAVEL"]
["Must be in accordance with current state guidelines.  Available upon request."]
["In-State Travel "]
["Travel to below project sites for data collection, monitoring, and etc."]
[null,null,null,0]
[]
[null,null,null,0]
[null,null,null,0]
["Individuals traveling will include all personnel involved in proposed research project."]
["Out-of-State Travel"]
["(Prior approval required)"]
["Provide destination, purpose, total mileage, total # of days, total # of meals, total # of trips, names of individual(s) traveling.",null,null,0]
[]
["SUB-TOTAL TRAVEL",0,0,0]
[]
["SUPPLIES"]
["Provide details if over 5% of total budget."]
["SUB-TOTAL SUPPLIES",null,null,0]
[]
["EQUIPMENT"]
["At least 2 quotes for each piece of equipment must be attached.  (See equipment policy for details and exceptions.)"]
["List all items separately.  Time at which the  purchase shall be made must be stated (e.g.: at project initiation, within first five months, etc.)"]
["SUB-TOTAL EQUIPMENT",null,null,0]
[]
["PRINTING"]
["Provide a breakdown of charges including, charge per page, # of pages, total # of copies, binding charges, etc.)"]
["Quarterly Reports"]
["Technical Notes",null,null,0]
["Draft Final Report",null,null,0]
["Executive Summary ",null,null,0]
["Final Report ",null,null,0]
["SUB-TOTAL PRINTING",0,0,0]
[]
["IN-DIRECT COSTS",4720.241054070769,0,4720.241054070769]
["Limited to 35% of Salaries & Wages for Universities"]
["FEES",0,0,0]
["For Commercial Organizations Only.  Negotiated amount based on % of direct costs (excluding sub-contractor and equipment)"]
["SUB-TOTAL INDIRECT COSTS AND FEES",4720.241054070769,0,4720.241054070769]
[]
["OTHER EXPENSES"]
["Any project expense which does not fall into another category"]
["Provide detailed explanation of the expense and applicable breakdown of costs."]
["List individually by category"]
["SUB-TOTAL OTHER EXPENSES",0,0,0]
[]
["TOTAL PROJECT COST",20227.689127344205,0,20227.689127344205]

{"sheet":"Form 1 year 5","index":5,"n_rows":94,"n_cols":4,"rows_kept":94,"cut":false,"hidden":false,"merged":[[88,0,88,3],[89,0,89,3],[83,1,84,1],[83,2,84,2],[83,3,84,3],[87,0,87,3],[68,0,68,3],[72,0,72,3],[73,0,73,3],[81,1,82,1],[81,2,82,2],[81,3,82,3],[49,0,49,3],[63,0,63,3],[64,0,64,3],[67,0,67,3],[25,0,25,3],[43,0,43,3],[44,0,44,3],[48,0,48,3],[9,0,9,3],[10,0,10,3],[22,0,22,3],[24,0,24,3]],"flags":["formulas_cached_only"]}
[null,"Final Proposal Budget Form "]
[null,"Summary for Year 5"]
["Project Title:  Monitoring and Modeling of Pavement Response and Performance"]
["Task C4"]
["Research Organization: ORITE, Ohio University       Principal Investigators: S. Sargand, J. L. Figueroa"]
[]
["Project Duration: 72 months"]
[]
[null,"ODOT Share","Organizational Cost Sharing","TOTAL"]
["SALARIES & WAGES"]
["Specify number of hours to be work and hourly rate for each individual below.  Salaries & Wages may be shown as a percentage of a total salary.  In this case, the percentage of the salary to be paid and the total salary for each individual must be listed.  The same unit, hours or percent, must be used for all personnel in all sections of the final proposal budget form."]
["Co-PI – S. Sargand"]
[]
["3.01% Time AY",5146.657424287385,null,5146.657424287385]
["AY salary = $170,825.23"]
["Co-PI – J.L. Figueroa"]
[]
["3.27% Time AY",3679.548032692307,null,3679.548032692307]
["AY salary = $112,550.88"]
["Graduate Student"]
["0.25 students (FY salary $20,259.16)",5064.789645,null,5064.789645]
["SUB-TOTAL SALARY & WAGES",13890.995101979694,0,13890.995101979694]
["*Salaries are figured with a 3% increase each year."]
[]
["FRINGE BENEFITS"]
["Provide an explanation of what is included and how the figure was derived for each personnel category."]
["Co-PI – S. Sargand"]
["STRS = Salary x $.14",720.532039400234,null,720.532039400234]
["Workers Comp = Salary x $.007052",36.29422815607464,null,36.29422815607464]
["Medicare = Salary x $.0145",74.62653265216709,null,74.62653265216709]
["Group Insurance = $8448 x 3.01% AY ",254.52307692307693,null,254.52307692307693]
["Co-PI – J. L. Figueroa"]
["STRS = Salary x $.14",515.136724576923,null,515.136724576923]
["Workers Comp = Salary x $.007052",25.94817272654615,null,25.94817272654615]
["Medicare = Salary x $.0145",53.353446474038456,null,53.353446474038456]
["Group Insurance = $8448 x 3.27% AY ",276.1846153846154,null,276.1846153846154]
["Graduate Students"]
["Workers Comp = Salary x $.007052",35.71689657654,null,35.71689657654]
["Medicare = Salary x $.0145",73.4394498525,null,73.4394498525]
["SUB-TOTAL FRINGE BENEFITS",2065.7551827227157,0,2065.7551827227157]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",15956.75028470241,0,15956.75028470241]
[]
["SUBCONTRACTOR"]
["A copy of the subcontractor’s budget must be attached.  Reimbursement to Contractor for Subcontractor performance is subject to state accounting guidelines as is the Contractor."]
["SUB-TOTAL SUBCONTRACTOR"]
[null,null,null,0]
[]
["TRAVEL"]
["Must be in accordance with current state guidelines.  Available upon request."]
["In-State Travel "]
["Travel to below project sites for data collection, monitoring, and etc."]
[null,null,null,0]
[]
[null,null,null,0]
[null,null,null,0]
["Individuals traveling will include all personnel involved in proposed research project."]
["Out-of-State Travel"]
["(Prior approval required)"]
["Provide destination, purpose, total mileage, total # of days, total # of meals, total # of trips, names of individual(s) traveling.",null,null,0]
[]
["SUB-TOTAL TRAVEL",0,0,0]
[]
["SUPPLIES"]
["Provide details if over 5% of total budget."]
["SUB-TOTAL SUPPLIES",null,null,0]
[]
["EQUIPMENT"]
["At least 2 quotes for each piece of equipment must be attached.  (See equipment policy for details and exceptions.)"]
["List all items separately.  Time at which the  purchase shall be made must be stated (e.g.: at project initiation, within first five months, etc.)"]
["SUB-TOTAL EQUIPMENT",null,null,0]
[]
["PRINTING"]
["Provide a breakdown of charges including, charge per page, # of pages, total # of copies, binding charges, etc.)"]
["Quarterly Reports"]
["Technical Notes",null,null,0]
["Draft Final Report",null,null,0]
["Executive Summary ",null,null,0]
["Final Report ",null,null,0]
["SUB-TOTAL PRINTING",0,0,0]
[]
["IN-DIRECT COSTS",4861.848285692892,0,4861.848285692892]
["Limited to 35% of Salaries & Wages for Universities"]
["FEES",0,0,0]
["For Commercial Organizations Only.  Negotiated amount based on % of direct costs (excluding sub-contractor and equipment)"]
["SUB-TOTAL INDIRECT COSTS AND FEES",4861.848285692892,0,4861.848285692892]
[]
["OTHER EXPENSES"]
["Any project expense which does not fall into another category"]
["Provide detailed explanation of the expense and applicable breakdown of costs."]
["List individually by category"]
["SUB-TOTAL OTHER EXPENSES",0,0,0]
[]
["TOTAL PROJECT COST",20818.5985703953,0,20818.5985703953]

{"sheet":"Form 1 year 6","index":6,"n_rows":94,"n_cols":4,"rows_kept":94,"cut":false,"hidden":false,"merged":[[88,0,88,3],[89,0,89,3],[83,1,84,1],[83,2,84,2],[83,3,84,3],[87,0,87,3],[68,0,68,3],[72,0,72,3],[73,0,73,3],[81,1,82,1],[81,2,82,2],[81,3,82,3],[49,0,49,3],[63,0,63,3],[64,0,64,3],[67,0,67,3],[25,0,25,3],[43,0,43,3],[44,0,44,3],[48,0,48,3],[9,0,9,3],[10,0,10,3],[22,0,22,3],[24,0,24,3]],"flags":["formulas_cached_only"]}
[null,"Final Proposal Budget Form "]
[null,"Summary for Year 6"]
["Project Title:  Monitoring and Modeling of Pavement Response and Performance"]
["Task C4"]
["Research Organization: ORITE, Ohio University       Principal Investigators: S. Sargand, J. L. Figueroa"]
[]
["Project Duration: 72 months"]
[]
[null,"ODOT Share","Organizational Cost Sharing","TOTAL"]
["SALARIES & WAGES"]
["Specify number of hours to be work and hourly rate for each individual below.  Salaries & Wages may be shown as a percentage of a total salary.  In this case, the percentage of the salary to be paid and the total salary for each individual must be listed.  The same unit, hours or percent, must be used for all personnel in all sections of the final proposal budget form."]
["Co-PI – S. Sargand"]
[]
["3.01% Time AY",5301.057147016006,null,5301.057147016006]
["AY salary = $175,949.98"]
["Co-PI – J.L. Figueroa"]
[]
["3.27% Time AY",3789.9344736730764,null,3789.9344736730764]
["AY salary = $115,927.41"]
["Graduate Student"]
["0.25 students (FY salary $20,866.93)",5216.7333343499995,null,5216.7333343499995]
["SUB-TOTAL SALARY & WAGES",14307.72495503908,0,14307.72495503908]
["*Salaries are figured with a 3% increase each year."]
[]
["FRINGE BENEFITS"]
["Provide an explanation of what is included and how the figure was derived for each personnel category."]
["Co-PI – S. Sargand"]
["STRS = Salary x $.14",742.1480005822409,null,742.1480005822409]
["Workers Comp = Salary x $.007052",37.383055000756876,null,37.383055000756876]
["Medicare = Salary x $.0145",76.86532863173208,null,76.86532863173208]
["Group Insurance = $8448 x 3.01% AY ",254.52307692307693,null,254.52307692307693]
["Co-PI – J. L. Figueroa"]
["STRS = Salary x $.14",530.5908263142308,null,530.5908263142308]
["Workers Comp = Salary x $.007052",26.726617908342536,null,26.726617908342536]
["Medicare = Salary x $.0145",54.95404986825961,null,54.95404986825961]
["Group Insurance = $8448 x 3.27% AY ",276.1846153846154,null,276.1846153846154]
["Graduate Students"]
["Workers Comp = Salary x $.007052",36.7884034738362,null,36.7884034738362]
["Medicare = Salary x $.0145",75.642633348075,null,75.642633348075]
["SUB-TOTAL FRINGE BENEFITS",2111.8066074351664,0,2111.8066074351664]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",16419.531562474247,0,16419.531562474247]
[]
["SUBCONTRACTOR"]
["A copy of the subcontractor’s budget must be attached.  Reimbursement to Contractor for Subcontractor performance is subject to state accounting guidelines as is the Contractor."]
["SUB-TOTAL SUBCONTRACTOR"]
[null,null,null,0]
[]
["TRAVEL"]
["Must be in accordance with current state guidelines.  Available upon request."]
["In-State Travel "]
["Travel to below project sites for data collection, monitoring, and etc."]
[null,null,null,0]
[]
[null,null,null,0]
[null,null,null,0]
["Individuals traveling will include all personnel involved in proposed research project."]
["Out-of-State Travel"]
["(Prior approval required)"]
["Provide destination, purpose, total mileage, total # of days, total # of meals, total # of trips, names of individual(s) traveling.",null,null,0]
[]
["SUB-TOTAL TRAVEL",0,0,0]
[]
["SUPPLIES"]
["Provide details if over 5% of total budget."]
["SUB-TOTAL SUPPLIES",null,null,0]
[]
["EQUIPMENT"]
["At least 2 quotes for each piece of equipment must be attached.  (See equipment policy for details and exceptions.)"]
["List all items separately.  Time at which the  purchase shall be made must be stated (e.g.: at project initiation, within first five months, etc.)"]
["SUB-TOTAL EQUIPMENT",null,null,0]
[]
["PRINTING"]
["Provide a breakdown of charges including, charge per page, # of pages, total # of copies, binding charges, etc.)"]
["Quarterly Reports"]
["Technical Notes",null,null,0]
["Draft Guidelines",35.980000000000004,null,35.980000000000004]
["Executive Summary ",null,null,0]
["Final Guidelines",308.40000000000003,null,308.40000000000003]
["SUB-TOTAL PRINTING",344.38000000000005,0,344.38000000000005]
[]
["IN-DIRECT COSTS",5007.703734263678,0,5007.703734263678]
["Limited to 35% of Salaries & Wages for Universities"]
["FEES",0,0,0]
["For Commercial Organizations Only.  Negotiated amount based on % of direct costs (excluding sub-contractor and equipment)"]
["SUB-TOTAL INDIRECT COSTS AND FEES",5007.703734263678,0,5007.703734263678]
[]
["OTHER EXPENSES"]
["Any project expense which does not fall into another category"]
["Provide detailed explanation of the expense and applicable breakdown of costs."]
["List individually by category"]
["SUB-TOTAL OTHER EXPENSES",0,0,0]
[]
["TOTAL PROJECT COST",21771.615296737924,0,21771.615296737924]

{"sheet":"Form 2 SS","index":7,"n_rows":170,"n_cols":22,"rows_kept":170,"cut":false,"hidden":false,"merged":[[166,0,166,14],[167,0,167,14],[168,0,168,14],[169,0,169,14],[145,0,145,14],[146,0,146,14],[148,0,148,14],[149,1,149,12],[137,0,137,14],[138,0,138,14],[139,0,139,14],[140,0,140,14],[116,0,116,14],[117,0,117,14],[119,0,119,14],[120,1,120,12],[108,0,108,14],[109,0,109,14],[110,0,110,14],[111,0,111,14],[87,0,87,14],[88,0,88,14],[90,0,90,14],[91,1,91,12],[79,0,79,14],[80,0,80,14],[81,0,81,14],[82,0,82,14],[58,0,58,14],[59,0,59,14],[61,0,61,14],[62,1,62,12],[50,0,50,14],[51,0,51,14],[52,0,52,14],[53,0,53,14],[29,0,29,14],[30,0,30,14],[32,0,32,14],[33,1,33,12],[21,0,21,14],[22,0,22,14],[23,0,23,14],[24,0,24,14],[0,0,0,14],[1,0,1,14],[3,0,3,14],[4,1,4,12]],"flags":["formulas_cached_only"]}
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM",{"$nulls":16},"Shad Sargand"]
["Task C4",{"$nulls":15},"Year","Salary",151776]
["For Co-Principal Investigator (S. Sargand) – Year 1",{"$nulls":15},1,"Hours/year",1560,9,173.33333333333334,"hours/month"]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary","Hourly rate",97.29230769230769,16864,"Monthly rate"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,151776,null,78]
[1,{"$nulls":12},0,0,0,"summer","Monthly hours",6.5,843.2,"5% of monthly rate"]
[2,{"$nulls":12},0,0,0,50592]
[3,{"$nulls":12},0,0,0,null,null,8448,"Health Insurance annual cost"]
[4,5,5,5,5,5,5,5,6,6,null,null,null,47,4572.738461538462,993.2581208615386,null,null,5.415384615384616,"Health Insurance hourly"]
[5,{"$nulls":12},0,0,0,null,null,0.055660974067046176,"Health insurance percentage"]
[6,{"$nulls":12},0,0,0,null,null,0.14,"STRS"]
[7,{"$nulls":12},0,0,0,null,null,0.007052,"Workers Comp"]
[8,{"$nulls":12},0,0,0,null,null,0.0145,"Medicare"]
[{"$nulls":15},0,null,null,0.2172129740670462,"Benefit rate"]
["Monthly hours",5,5,5,5,5,5,5,6,6,0,0,0,47,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",486.46153846153845,486.46153846153845,486.46153846153845,486.46153846153845,486.46153846153845,486.46153846153845,486.46153846153845,583.7538461538461,583.7538461538461,0,0,0,4572.738461538462,4572.738461538462,993.2581208615386,254.52307692307693,640.1833846153847,32.24695163076923,66.3047076923077]
[{"$nulls":16},254.52307692307693,"AY only"]
["Quarterly Reports",null,null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.03012820512820513,"% time"]
["Draft Final Report"]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding.",{"$nulls":14},0]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (S. Sargand) – Year 2",{"$nulls":15},2]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,13,14,15,16,17,18,19,20,21,22,23,24,null,null,null,156329.28]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,52109.76]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,5,5,5,5,6,6,null,null,null,47,4709.920615384615,1023.0558644873847]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,5,5,5,5,6,6,0,0,0,47,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",501.05538461538464,501.05538461538464,501.05538461538464,501.05538461538464,501.05538461538464,501.05538461538464,501.05538461538464,601.2664615384615,601.2664615384615,0,0,0,4709.920615384615,4709.920615384615,1023.0558644873847,254.52307692307693,659.3888861538462,33.21436017969231,68.29384892307692]
[{"$nulls":16},254.52307692307693,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.03012820512820513,"% time"]
["Draft Final Report",{"$nulls":14},47]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (S. Sargand) – Year 3",{"$nulls":15},3]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,25,26,27,28,29,30,31,32,33,34,35,36,null,null,null,161019.15840000001]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,53673.052800000005]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,5,5,5,5,6,6,null,null,null,47,4851.218233846153,1053.7475404220063]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,5,5,5,5,6,6,0,0,0,47,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",516.0870461538461,516.0870461538461,516.0870461538461,516.0870461538461,516.0870461538461,516.0870461538461,516.0870461538461,619.3044553846153,619.3044553846153,0,0,0,4851.218233846153,4851.218233846153,1053.7475404220063,254.52307692307693,679.1705527384615,34.21079098508307,70.34266439076923]
[{"$nulls":16},254.52307692307693,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.03012820512820513,"% time"]
["Draft Final Report",{"$nulls":14},47]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (S. Sargand) – Year 4",{"$nulls":15},4]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,37,38,39,40,41,42,43,44,45,46,47,48,null,null,null,165849.73315200003]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,55283.24438400001]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,5,5,5,5,6,6,null,null,null,47,4996.754780861539,1085.3599666346665]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,5,5,5,5,6,6,0,0,0,47,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",531.5696575384616,531.5696575384616,531.5696575384616,531.5696575384616,531.5696575384616,531.5696575384616,531.5696575384616,637.8835890461538,637.8835890461538,0,0,0,4996.754780861539,4996.754780861539,1085.3599666346665,254.52307692307693,699.5456693206155,35.237114714635574,72.45294432249231]
[{"$nulls":16},254.52307692307693,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.03012820512820513,"% time"]
["Draft Final Report",{"$nulls":14},47]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (S. Sargand) – Year 5",{"$nulls":15},5]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,49,50,51,52,53,54,55,56,57,58,59,60,null,null,null,170825.22514656003]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,56941.74171552001]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,5,5,5,5,6,6,null,null,null,47,5146.657424287385,1117.9207656337067]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,5,5,5,5,6,6,0,0,0,47,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",547.5167472646153,547.5167472646153,547.5167472646153,547.5167472646153,547.5167472646153,547.5167472646153,547.5167472646153,657.0200967175383,657.0200967175383,0,0,0,5146.657424287385,5146.657424287385,1117.9207656337067,254.52307692307693,720.532039400234,36.29422815607464,74.62653265216709]
[{"$nulls":16},254.52307692307693,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.03012820512820513,"% time"]
["Draft Final Report",{"$nulls":14},47]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (S. Sargand) – Year 6",{"$nulls":15},6]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,61,62,63,64,65,66,67,68,69,70,71,72,null,null,null,175949.98190095683]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,58649.99396698561]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,5,5,5,5,6,6,null,null,null,47,5301.057147016006,1151.4583886027176]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,5,5,5,5,6,6,0,0,0,47,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",563.9422496825538,563.9422496825538,563.9422496825538,563.9422496825538,563.9422496825538,563.9422496825538,563.9422496825538,676.7306996190645,676.7306996190645,0,0,0,5301.057147016006,5301.057147016006,1151.4583886027176,254.52307692307693,742.1480005822409,37.383055000756876,76.86532863173208]
[{"$nulls":16},254.52307692307693,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.03012820512820513,"% time"]
["Draft Final Report",{"$nulls":14},47]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]

{"sheet":"Form 2 JLF","index":8,"n_rows":171,"n_cols":22,"rows_kept":171,"cut":false,"hidden":false,"merged":[[62,1,62,12],[166,0,166,14],[167,0,167,14],[168,0,168,14],[137,0,137,14],[138,0,138,14],[139,0,139,14],[140,0,140,14],[116,0,116,14],[117,0,117,14],[169,0,169,14],[145,0,145,14],[146,0,146,14],[148,0,148,14],[149,1,149,12],[119,0,119,14],[120,1,120,12],[108,0,108,14],[109,0,109,14],[110,0,110,14],[111,0,111,14],[87,0,87,14],[88,0,88,14],[90,0,90,14],[91,1,91,12],[61,0,61,14],[29,0,29,14],[30,0,30,14],[58,0,58,14],[59,0,59,14],[32,0,32,14],[50,0,50,14],[51,0,51,14],[52,0,52,14],[53,0,53,14],[79,0,79,14],[80,0,80,14],[81,0,81,14],[82,0,82,14],[4,1,4,12],[33,1,33,12],[0,0,0,14],[1,0,1,14],[3,0,3,14],[21,0,21,14],[22,0,22,14],[23,0,23,14],[24,0,24,14]],"flags":["formulas_cached_only"]}
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM",{"$nulls":16},"J. Ludwig Figueroa"]
["Task C4",{"$nulls":15},"Year","Salary",100000]
["For Co-Principal Investigator (J.L. Figueroa) – Year 1",{"$nulls":15},1,"Hours/year",1560,9,173.33333333333334,"hours/month"]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary","Hourly rate",64.1025641025641,11111.111111111111,"Monthly rate"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,100000,null,78]
[1,{"$nulls":12},0,0,0,"summer","Monthly hours",6.5,555.5555555555555,"5% of monthly rate"]
[2,{"$nulls":12},0,0,0,33333.333333333336]
[3,{"$nulls":12},0,0,0,null,null,8448,"Health Insurance annual cost"]
[4,5,5,6,6,6,6,6,6,6,null,null,null,52,3333.3333333333335,820.1066666666668,null,null,5.415384615384616,"Health Insurance hourly"]
[5,{"$nulls":12},0,0,0,null,null,0.08448,"Health insurance percentage"]
[6,{"$nulls":12},0,0,0,null,null,0.14,"STRS"]
[7,{"$nulls":12},0,0,0,null,null,0.007052,"Workers Comp"]
[8,{"$nulls":12},0,0,0,null,null,0.0145,"Medicare"]
[{"$nulls":15},0,null,null,0.24603200000000003,"Benefit rate"]
["Monthly hours",5,5,6,6,6,6,6,6,6,0,0,0,52,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",320.5128205128205,320.5128205128205,384.61538461538464,384.61538461538464,384.61538461538464,384.61538461538464,384.61538461538464,384.61538461538464,384.61538461538464,0,0,0,3333.3333333333335,3333.3333333333335,820.1066666666668,281.6,466.66666666666674,23.506666666666668,48.333333333333336]
[{"$nulls":16},281.6,"AY only"]
["Quarterly Reports",null,null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.03333333333333333,"% time"]
["Draft Final Report"]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding.",{"$nulls":14},0,0]
["Salaries are figured with a 3% increase each year."]
[{"$nulls":15},51.333333333333336,0.03290598290598291]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (J.L. Figueroa) – Year 2",{"$nulls":15},2]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,13,14,15,16,17,18,19,20,21,22,23,24,null,null,null,103000]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,34333.333333333336]
[3,{"$nulls":12},0,0,0]
[4,5,5,6,6,6,6,6,6,6,null,null,null,52,3433.3333333333335,844.7098666666668]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,6,6,6,6,6,6,6,0,0,0,52,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",330.12820512820514,330.12820512820514,396.1538461538462,396.1538461538462,396.1538461538462,396.1538461538462,396.1538461538462,396.1538461538462,396.1538461538462,0,0,0,3433.3333333333335,3433.3333333333335,844.7098666666668,281.6,480.66666666666674,24.21186666666667,49.78333333333334]
[{"$nulls":16},281.6,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.03333333333333333,"% time"]
["Draft Final Report",{"$nulls":14},52]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (J.L. Figueroa) – Year 3",{"$nulls":15},3]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,25,26,27,28,29,30,31,32,33,34,35,36,null,null,null,106090]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,35363.333333333336]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,6,6,6,6,6,6,null,null,null,51,3468.326923076923,853.3194095384616]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,6,6,6,6,6,6,0,0,0,51,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",340.03205128205127,340.03205128205127,340.03205128205127,408.03846153846155,408.03846153846155,408.03846153846155,408.03846153846155,408.03846153846155,408.03846153846155,0,0,0,3468.326923076923,3468.326923076923,853.3194095384616,276.1846153846154,485.56576923076926,24.45864146153846,50.29074038461538]
[{"$nulls":16},276.1846153846154,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.032692307692307694,"% time"]
["Draft Final Report",{"$nulls":14},51]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (J.L. Figueroa) – Year 4",{"$nulls":15},4]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,37,38,39,40,41,42,43,44,45,46,47,48,null,null,null,109272.7]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,36424.23333333333]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,6,6,6,6,6,6,null,null,null,51,3572.3767307692306,878.9189918246154]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,6,6,6,6,6,6,0,0,0,51,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",350.2330128205128,350.2330128205128,350.2330128205128,420.2796153846154,420.2796153846154,420.2796153846154,420.2796153846154,420.2796153846154,420.2796153846154,0,0,0,3572.3767307692306,3572.3767307692306,878.9189918246154,276.1846153846154,500.13274230769235,25.192400705384614,51.799462596153845]
[{"$nulls":16},276.1846153846154,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.032692307692307694,"% time"]
["Draft Final Report",{"$nulls":14},51]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (J.L. Figueroa) – Year 5",{"$nulls":15},5]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,49,50,51,52,53,54,55,56,57,58,59,60,null,null,null,112550.881]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,37516.96033333333]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,6,6,6,6,6,6,null,null,null,51,3679.548032692307,905.2865615793538]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,6,6,6,6,6,6,0,0,0,51,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",360.7400032051282,360.7400032051282,360.7400032051282,432.8880038461538,432.8880038461538,432.8880038461538,432.8880038461538,432.8880038461538,432.8880038461538,0,0,0,3679.548032692307,3679.548032692307,905.2865615793538,276.1846153846154,515.136724576923,25.94817272654615,53.353446474038456]
[{"$nulls":16},276.1846153846154,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.032692307692307694,"% time"]
["Draft Final Report",{"$nulls":14},51]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Co-Principal Investigator (J.L. Figueroa) – Year 6",{"$nulls":15},6]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","AY salary"]
[null,61,62,63,64,65,66,67,68,69,70,71,72,null,null,null,115927.40742999999]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,38642.46914333333]
[3,{"$nulls":12},0,0,0]
[4,5,5,5,6,6,6,6,6,6,null,null,null,51,3789.9344736730764,932.4451584267345]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",5,5,5,6,6,6,6,6,6,0,0,0,51,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",371.562203301282,371.562203301282,371.562203301282,445.8746439615384,445.8746439615384,445.8746439615384,445.8746439615384,445.8746439615384,445.8746439615384,0,0,0,3789.9344736730764,3789.9344736730764,932.4451584267345,276.1846153846154,530.5908263142308,26.726617908342536,54.95404986825961]
[{"$nulls":16},276.1846153846154,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.032692307692307694,"% time"]
["Draft Final Report",{"$nulls":14},51]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[{"$nulls":15},308,0.03290598290598291,"Average percentage AY"]

{"sheet":"Form 2 RA","index":9,"n_rows":170,"n_cols":22,"rows_kept":170,"cut":false,"hidden":false,"merged":[[166,0,166,14],[167,0,167,14],[168,0,168,14],[169,0,169,14],[145,0,145,14],[146,0,146,14],[148,0,148,14],[149,1,149,12],[137,0,137,14],[138,0,138,14],[139,0,139,14],[140,0,140,14],[116,0,116,14],[117,0,117,14],[119,0,119,14],[120,1,120,12],[108,0,108,14],[109,0,109,14],[110,0,110,14],[111,0,111,14],[87,0,87,14],[88,0,88,14],[90,0,90,14],[91,1,91,12],[79,0,79,14],[80,0,80,14],[81,0,81,14],[82,0,82,14],[58,0,58,14],[59,0,59,14],[61,0,61,14],[62,1,62,12],[50,0,50,14],[51,0,51,14],[52,0,52,14],[53,0,53,14],[29,0,29,14],[30,0,30,14],[32,0,32,14],[33,1,33,12],[21,0,21,14],[22,0,22,14],[23,0,23,14],[24,0,24,14],[0,0,0,14],[1,0,1,14],[3,0,3,14],[4,1,4,12]],"flags":["formulas_cached_only"]}
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM",{"$nulls":16},"Graduate Assistant"]
["Task C4",{"$nulls":15},"Year","Salary",18000]
["For Graduate Assistants – Year 1",{"$nulls":15},1,"Hours/year",1040,12,86.66666666666667,"hours/month"]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","FY salary","Hourly rate",17.307692307692307,1500,"Monthly rate"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,18000,null,416]
[1,{"$nulls":12},0,0,0,null,"Monthly hours",34.666666666666664,600,"40% of monthly rate"]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0,null,null,0,"Health Insurance annual cost"]
[4,21,21,21,21,22,22,22,22,22,22,22,22,260,4500,96.98400000000001,null,null,0,"Health Insurance hourly"]
[5,{"$nulls":12},0,0,0,null,null,0,"Health insurance percentage"]
[6,{"$nulls":12},0,0,0,null,null,0,"PERS"]
[7,{"$nulls":12},0,0,0,null,null,0.007052,"Workers Comp"]
[8,{"$nulls":12},0,0,0,null,null,0.0145,"Medicare"]
[{"$nulls":15},0,null,null,0.021552,"Benefit rate"]
["Monthly hours",21,21,21,21,22,22,22,22,22,22,22,22,260,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",363.46153846153845,363.46153846153845,363.46153846153845,363.46153846153845,380.7692307692307,380.7692307692307,380.7692307692307,380.7692307692307,380.7692307692307,380.7692307692307,380.7692307692307,380.7692307692307,4500,4500,96.98400000000001,0,0,31.734,65.25]
[]
["Quarterly Reports",null,null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.25,"% time"]
["Draft Final Report"]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes submimission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submimission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding.",{"$nulls":14},66]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Graduate Assistants – Year 2",{"$nulls":15},2]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","FY salary"]
[null,13,14,15,16,17,18,19,20,21,22,23,24,null,null,null,18540]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,21,21,21,21,22,22,22,22,22,22,22,22,260,4635,99.89352000000001]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",21,21,21,21,22,22,22,22,22,22,22,22,260,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",374.36538461538464,374.36538461538464,374.36538461538464,374.36538461538464,392.1923076923076,392.1923076923076,392.1923076923076,392.1923076923076,392.1923076923076,392.1923076923076,392.1923076923076,392.1923076923076,4635,4635,99.89352000000001,0,0,32.68602,67.20750000000001]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.25,"% time"]
["Draft Final Report",{"$nulls":14},194]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes Submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Graduate Assistants – Year 3",{"$nulls":15},3]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","FY salary"]
[null,25,26,27,28,29,30,31,32,33,34,35,36,null,null,null,19096.2]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,21,21,21,21,22,22,22,22,22,22,22,22,260,4774.05,102.89032560000001]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",21,21,21,21,22,22,22,22,22,22,22,22,260,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",385.5963461538461,385.5963461538461,385.5963461538461,385.5963461538461,403.9580769230769,403.9580769230769,403.9580769230769,403.9580769230769,403.9580769230769,403.9580769230769,403.9580769230769,403.9580769230769,4774.05,4774.05,102.89032560000001,0,0,33.6666006,69.223725]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.25,"% time"]
["Draft Final Report",{"$nulls":14},194]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes Submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Graduate Assistants – Year 4",{"$nulls":15},4]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","FY salary"]
[null,37,38,39,40,41,42,43,44,45,46,47,48,null,null,null,19669.086000000003]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,21,21,21,21,22,22,22,22,22,22,22,22,260,4917.2715,105.977035368]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",21,21,21,21,22,22,22,22,22,22,22,22,260,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",397.1642365384615,397.1642365384615,397.1642365384615,397.1642365384615,416.07681923076916,416.07681923076916,416.07681923076916,416.07681923076916,416.07681923076916,416.07681923076916,416.07681923076916,416.07681923076916,4917.2715,4917.2715,105.977035368,0,0,34.676598618,71.30043675]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.25,"% time"]
["Draft Final Report",{"$nulls":14},194]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes Submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Graduate Assistants – Year 5",{"$nulls":15},5]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","FY salary"]
[null,49,50,51,52,53,54,55,56,57,58,59,60,null,null,null,20259.158580000003]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,21,21,21,21,22,22,22,22,22,22,22,22,260,5064.789645,109.15634642904]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",21,21,21,21,22,22,22,22,22,22,22,22,260,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",409.0791636346153,409.0791636346153,409.0791636346153,409.0791636346153,428.55912380769223,428.55912380769223,428.55912380769223,428.55912380769223,428.55912380769223,428.55912380769223,428.55912380769223,428.55912380769223,5064.789645,5064.789645,109.15634642904,0,0,35.71689657654,73.4394498525]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.25,"% time"]
["Draft Final Report",{"$nulls":14},194]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes Submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]
[]
[]
[]
[]
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM"]
["Task C4",{"$nulls":15},"Year"]
["For Graduate Assistants – Year 6",{"$nulls":15},6]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","FY salary"]
[null,61,62,63,64,65,66,67,68,69,70,71,72,null,null,null,20866.933337400005]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,21,21,21,21,22,22,22,22,22,22,22,22,260,5216.7333343499995,112.43103682191119]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,{"$nulls":12},0,0,0]
[{"$nulls":15},0]
["Monthly hours",21,21,21,21,22,22,22,22,22,22,22,22,260,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",421.35153854365376,421.35153854365376,421.35153854365376,421.35153854365376,441.41589752192294,441.41589752192294,441.41589752192294,441.41589752192294,441.41589752192294,441.41589752192294,441.41589752192294,441.41589752192294,5216.7333343499995,5216.7333343499995,112.43103682191119,0,0,36.7884034738362,75.642633348075]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.25,"% time"]
["Draft Final Report",{"$nulls":14},194]
[" Final Report"]
["Note:  Numbers in cells indicate hours proposed for the specific task.  Example labor cost is computed @ $64.05 per hour.  “X” denotes Submission of report."]
["The same notation used for salaries and wages in the final proposal budget form must be used in this form.  Sample is shown based on an hourly rate.  Submission of quarterly reports shall be done as specified by contract and manual.  Inclusion on this work time cost schedule is merely acknowledgment by the researchers that such documentation is required and will be supplied as instructed."]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]

{"sheet":"Printing","index":10,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Task C4"]
["Printing costs summary"]
[null,"pages","Cost per page","print total","Cover","Bind","Total cost per copy","Number of copies","Total cost","Year","Notes"]
["Draft guidelines",25,0.07,1.7500000000000002,0.4,2.99,5.140000000000001,7,35.980000000000004,6]
["Final guidelines",25,0.07,1.7500000000000002,0.4,2.99,5.140000000000001,60,308.40000000000003,6]
["Total printing cost year 6",{"$nulls":7},35.980000000000004]
["Total printing cost entire project",{"$nulls":7},344.38000000000005]
[]
[]
[]
[{"$nulls":5},3.99,"spiral"]