{"text_format":"2","workbook":"xls","n_sheets":12,"sheets":["Form 1 entire project","Form 1 year 1","Form 1 year 2","Form 1 year 3","Form 2 SS","Form 2 TM","Form 2 IK","Form 2 RA","Form 2 MK","Travel","Sensors","Printing"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":60,"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":112,"n_cols":4,"rows_kept":112,"cut":false,"hidden":false,"merged":[[9,0,9,3],[10,0,10,3],[27,0,27,3],[29,0,29,3],[30,0,30,3],[58,0,58,3],[59,0,59,3],[63,0,63,3],[64,0,64,3],[78,0,78,3],[79,0,79,3],[82,0,82,3],[83,0,83,3],[87,0,87,3],[88,0,88,3],[96,1,97,1],[96,2,97,2],[96,3,97,3],[103,0,103,3],[104,0,104,3],[98,1,99,1],[98,2,99,2],[98,3,99,3],[102,0,102,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 A8"]
["Research Organization: ORITE, Ohio University       Principal Investigator: S. Sargand"]
[]
["Project Duration: 36 months (part A)"]
[]
[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."]
["PI – S. Sargand"]
[]
["approximately 10% Time AY",46912.44383999999,0,46912.44383999999]
["(initial AY salary = $151,776)*"]
["Associate Professor – T. Masada"]
["approximately 6.92% Time AY",10401.954230769232,0,10401.954230769232]
["(initial AY salary = $74,015)*"]
["Research Engineer – I. Khoury"]
["approximately 13% Time FY",30356.797440000002,0,30356.797440000002]
["(initial FY salary = $66,016)*"]
["Graduate Student"]
["0.78 students average (initial FY salary 18,000)*",43114.92576923077,0,43114.92576923077]
["Research Technician – M. Krumlauf"]
["approximately 10% Time FY",12411.426930000001,0,12411.426930000001]
["(initial FY salary = $40,754)*"]
["SUB-TOTAL SALARY & WAGES",143197.54821,0,143197.54821]
["*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."]
["PI – S. Sargand"]
["STRS = Salary x $.14",6567.7421376,0,6567.7421376]
["Workers Comp = Salary x $.007052",330.82655395968,0,330.82655395968]
["Medicare = Salary x $.0145",680.23043568,0,680.23043568]
["Group Insurance = $8448 x 10% AY ",2534.4,0,2534.4]
["Associate Professor – T. Masada"]
["STRS = Salary x $.14",1456.2735923076925,0,1456.2735923076925]
["Workers Comp = Salary x $.007052",73.35458123538461,0,73.35458123538461]
["Medicare = Salary x $.0145",150.82833634615386,0,150.82833634615386]
["Group Insurance = $8448 x 6.92% AY ",1169.723076923077,0,1169.723076923077]
["Research Engineer – I. Khoury"]
["PERS = Salary x $.1331",4040.489739264,0,4040.489739264]
["Workers Comp = Salary x $.007052",214.07613554688,0,214.07613554688]
["Medicare = Salary x $.0145",440.17356287999996,0,440.17356287999996]
["Group Insurance = $8448 x 51.79% FY ",3801.6000000000004,0,3801.6000000000004]
["Research Technician – M. Krumlauf"]
["PERS = Salary x $.1331",1651.960924383,0,1651.960924383]
["Workers Comp = Salary x $.007052",87.52538271036,0,87.52538271036]
["Medicare = Salary x $.0145",179.965690485,0,179.965690485]
["Group Insurance = $8448 x 12.86% FY",2534.4,0,2534.4]
["Graduate Students"]
["Workers Comp = Salary x $.007052",304.0464565246154,0,304.0464565246154]
["Medicare = Salary x $.0145",625.1664236538461,0,625.1664236538461]
["SUB-TOTAL FRINGE BENEFITS",26842.78302949969,0,26842.78302949969]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",170040.3312394997,0,170040.3312394997]
[]
["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."]
["250 miles RT x 94 trips x  $.30/mile x 2 vehicles (70 trips) or 1 vehicle (24 trips)",12300,0,12300]
[]
["$30/day meals x 10 overnight trips x 3 people ",1800,0,1800]
["$75/night hotel x 10 overnight trips x 3 people ",2250,0,2250]
["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",16350,0,16350]
[]
["SUPPLIES"]
["Provide details if over 5% of total budget."]
["SUB-TOTAL SUPPLIES",51891.979999999996,0,51891.979999999996]
[]
["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",52835,0,52835]
[]
["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",0,0,0]
["Executive Summary ",0,0,0]
["Final Report ",0,0,0]
["SUB-TOTAL PRINTING",0,0,0]
[]
["IN-DIRECT COSTS",50119.1418735,0,50119.1418735]
["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",50119.1418735,0,50119.1418735]
[]
["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",341236.45311299973,0,341236.45311299973]
[]
["cost before adding subtask A8b",331516.0194615757]
["cost of A8b",9720.433651424013]

{"sheet":"Form 1 year 1","index":1,"n_rows":110,"n_cols":6,"rows_kept":110,"cut":false,"hidden":false,"merged":[[104,0,104,3],[105,0,105,3],[99,1,100,1],[99,2,100,2],[99,3,100,3],[103,0,103,3],[83,0,83,3],[88,0,88,3],[89,0,89,3],[97,1,98,1],[97,2,98,2],[97,3,98,3],[64,0,64,3],[78,0,78,3],[79,0,79,3],[82,0,82,3],[30,0,30,3],[58,0,58,3],[59,0,59,3],[63,0,63,3],[9,0,9,3],[10,0,10,3],[27,0,27,3],[29,0,29,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 A8"]
["Research Organization: ORITE, Ohio University       Principal Investigator: S. Sargand"]
[]
["Project Duration: 36 months (part A)"]
[]
[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."]
["PI – S. Sargand"]
[]
[" 10% Time AY",15177.599999999999,null,15177.599999999999]
["AY salary = $151,776"]
["Associate Professor – T. Masada"]
["approximately 6.92% Time AY",5124.115384615385,null,5124.115384615385]
["AY salary = $74,015"]
["Research Engineer – I. Khoury"]
["22.5% Time FY",14853.6,null,14853.6]
["FY salary = $66,016"]
["Graduate Student"]
["1 student  (FY salary $18,000)",18000,null,18000]
["Research Technician – M. Krumlauf"]
["20% Time FY",8150.8,null,8150.8]
["FY salary = $40,754"]
["SUB-TOTAL SALARY & WAGES",61306.11538461538,0,61306.11538461538]
["*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",2124.864,null,2124.864]
["Workers Comp = Salary x $.007052",107.0324352,null,107.0324352]
["Medicare = Salary x $.0145",220.0752,null,220.0752]
["Group Insurance = $8448 x 10% AY ",844.8000000000001,null,844.8000000000001]
["Associate Professor – T. Masada"]
["STRS = Salary x $.14",717.3761538461539,null,717.3761538461539]
["Workers Comp = Salary x $.007052",36.135261692307694,null,36.135261692307694]
["Medicare = Salary x $.0145",74.29967307692309,null,74.29967307692309]
["Group Insurance = $8448 x 6.92% AY ",584.8615384615385,null,584.8615384615385]
["Research Engineer – I. Khoury"]
["PERS = Salary x $.1331",1977.01416,null,1977.01416]
["Workers Comp = Salary x $.007052",104.7475872,null,104.7475872]
["Medicare = Salary x $.0145",215.37720000000002,null,215.37720000000002]
["Group Insurance = $8448 x 22.5% FY ",1900.8,null,1900.8]
["Research Technician – M. Krumlauf"]
["PERS = Salary x $.1331",1084.87148,null,1084.87148]
["Workers Comp = Salary x $.007052",57.4794416,null,57.4794416]
["Medicare = Salary x $.0145",118.18660000000001,null,118.18660000000001]
["Group Insurance = $8448 x 20% FY",1689.6,null,1689.6]
["Graduate Students"]
["Workers Comp = Salary x $.007052",126.936,null,126.936]
["Medicare = Salary x $.0145",261,null,261]
["SUB-TOTAL FRINGE BENEFITS",12245.456731076923,0,12245.456731076923]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",73551.57211569231,0,73551.57211569231]
[]
["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."]
["250 miles RT x 70 trips x $.30/mile x 2 vehicles (Task 8)",10500,null,10500]
[]
["$30/day meals x 10 overnight trips x 2 days per trip x 3 people ",1800,null,1800]
["$75/night hotel x 10 overnight trips x 3 people ",2250,null,2250]
["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",14550,0,14550]
[]
["SUPPLIES"]
["For details see list of sensors for instrumenting 5 sections of pavement"]
["SUB-TOTAL SUPPLIES",51891.979999999996,null,51891.979999999996,61269.9,9377.920000000006]
[]
["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.)"]
["Sensors to instrument 5 sections of pavement (see list of sensors for details) to be purchased at beginning of project",52835]
["SUB-TOTAL EQUIPMENT",52835,null,52835,63695,10860]
[]
["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",21457.140384615384,0,21457.140384615384]
["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",21457.140384615384,0,21457.140384615384]
[]
["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",214285.6925003077,0,214285.6925003077]

{"sheet":"Form 1 year 2","index":2,"n_rows":109,"n_cols":4,"rows_kept":109,"cut":false,"hidden":false,"merged":[[103,0,103,3],[104,0,104,3],[98,1,99,1],[98,2,99,2],[98,3,99,3],[102,0,102,3],[83,0,83,3],[87,0,87,3],[88,0,88,3],[96,1,97,1],[96,2,97,2],[96,3,97,3],[64,0,64,3],[78,0,78,3],[79,0,79,3],[82,0,82,3],[30,0,30,3],[58,0,58,3],[59,0,59,3],[63,0,63,3],[9,0,9,3],[10,0,10,3],[27,0,27,3],[29,0,29,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 A8"]
["Research Organization: ORITE, Ohio University       Principal Investigator: S. Sargand"]
[]
["Project Duration: 36 months (part A)"]
[]
[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."]
["PI – S. Sargand"]
[]
[" 10% Time AY",15632.927999999998,null,15632.927999999998]
["AY salary = $156,329.28"]
["Associate Professor – T. Masada"]
["approximately 6.92% Time AY",5277.838846153846,null,5277.838846153846]
["AY salary = $76,235.45"]
["Research Engineer – I. Khoury"]
["12.5% Time FY",8499.56,null,8499.56]
["FY salary = $67,996.48"]
["Graduate Student"]
["66.73% of one student (FY salary 18,540)",12371.884615384615,null,12371.884615384615]
["Research Technician – M. Krumlauf"]
["5% Time FY",2098.831,null,2098.831]
["FY salary = $41,976.62"]
["SUB-TOTAL SALARY & WAGES",43881.04246153846,0,43881.04246153846]
["*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",2188.60992,null,2188.60992]
["Workers Comp = Salary x $.007052",110.243408256,null,110.243408256]
["Medicare = Salary x $.0145",226.67745599999998,null,226.67745599999998]
["Group Insurance = $8448 x 10% AY ",844.8000000000001,null,844.8000000000001]
["Associate Professor – T. Masada"]
["STRS = Salary x $.14",738.8974384615385,null,738.8974384615385]
["Workers Comp = Salary x $.007052",37.21931954307692,null,37.21931954307692]
["Medicare = Salary x $.0145",76.52866326923078,null,76.52866326923078]
["Group Insurance = $8448 x 6.92% AY ",584.8615384615385,null,584.8615384615385]
["Research Engineer – I. Khoury"]
["PERS = Salary x $.1331",1131.291436,null,1131.291436]
["Workers Comp = Salary x $.007052",59.93889712,null,59.93889712]
["Medicare = Salary x $.0145",123.24361999999999,null,123.24361999999999]
["Group Insurance = $8448 x 12.5% FY ",1056,null,1056]
["Research Technician – M. Krumlauf"]
["PERS = Salary x $.1331",279.3544061,null,279.3544061]
["Workers Comp = Salary x $.007052",14.800956212000001,null,14.800956212000001]
["Medicare = Salary x $.0145",30.433049500000003,null,30.433049500000003]
["Group Insurance = $8448 x 5% FY",422.4,null,422.4]
["Graduate Students"]
["Workers Comp = Salary x $.007052",87.24653030769231,null,87.24653030769231]
["Medicare = Salary x $.0145",179.39232692307692,null,179.39232692307692]
["SUB-TOTAL FRINGE BENEFITS",8191.9389661541545,0,8191.9389661541545]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",52072.98142769262,0,52072.98142769262]
[]
["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."]
[" 250 miles RT x 12 trips x $.30/mile x 1 vehicle (Task 8)",900,null,900]
[]
[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",900,0,900]
[]
["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",15358.36486153846,0,15358.36486153846]
["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",15358.36486153846,0,15358.36486153846]
[]
["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",68331.34628923108,0,68331.34628923108]

{"sheet":"Form 1 year 3","index":3,"n_rows":109,"n_cols":7,"rows_kept":109,"cut":false,"hidden":false,"merged":[[103,0,103,3],[104,0,104,3],[98,1,99,1],[98,2,99,2],[98,3,99,3],[102,0,102,3],[83,0,83,3],[87,0,87,3],[88,0,88,3],[96,1,97,1],[96,2,97,2],[96,3,97,3],[64,0,64,3],[78,0,78,3],[79,0,79,3],[82,0,82,3],[30,0,30,3],[58,0,58,3],[59,0,59,3],[63,0,63,3],[9,0,9,3],[10,0,10,3],[27,0,27,3],[29,0,29,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 A8"]
["Research Organization: ORITE, Ohio University       Principal Investigator: S. Sargand"]
[]
["Project Duration: 36 months (part A)"]
[]
[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."]
["PI – S. Sargand"]
[]
[" 10% Time AY",16101.915839999998,null,16101.915839999998]
["AY salary = $161,019.16"]
["Associate Professor – T. Masada"]
["approximately 0% Time AY",0,null,0]
["AY salary = $78,522.51"]
["Research Engineer – I. Khoury"]
["10% Time FY",7003.63744,null,7003.63744]
["FY salary = $70,036.37"]
["Graduate Student"]
["66.73% of one student (FY salary 19,096.20)",12743.041153846152,null,12743.041153846152,null,19096.2,12794.454000000002]
["Research Technician – M. Krumlauf"]
["5% Time FY",2161.7959299999998,null,2161.7959299999998]
["FY salary = $43,235.92"]
["SUB-TOTAL SALARY & WAGES",38010.390363846156,0,38010.390363846156]
["*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",2254.2682176,null,2254.2682176]
["Workers Comp = Salary x $.007052",113.55071050367998,null,113.55071050367998]
["Medicare = Salary x $.0145",233.47777967999997,null,233.47777967999997]
["Group Insurance = $8448 x 10% AY ",844.8000000000001,null,844.8000000000001]
["Associate Professor – T. Masada"]
["STRS = Salary x $.14",0,null,0]
["Workers Comp = Salary x $.007052",0,null,0]
["Medicare = Salary x $.0145",0,null,0]
["Group Insurance = $8448 x 0% AY ",0,null,0]
["Research Engineer – I. Khoury"]
["PERS = Salary x $.1331",932.184143264,null,932.184143264]
["Workers Comp = Salary x $.007052",49.389651226880005,null,49.389651226880005]
["Medicare = Salary x $.0145",101.55274288000001,null,101.55274288000001]
["Group Insurance = $8448 x 10% FY ",844.8,null,844.8]
["Research Technician – M. Krumlauf"]
["PERS = Salary x $.1331",287.73503828299994,null,287.73503828299994]
["Workers Comp = Salary x $.007052",15.244984898359998,null,15.244984898359998]
["Medicare = Salary x $.0145",31.346040985,null,31.346040985]
["Group Insurance = $8448 x 5% FY",422.4,null,422.4]
["Graduate Students"]
["Workers Comp = Salary x $.007052",89.86392621692306,null,89.86392621692306]
["Medicare = Salary x $.0145",184.7740967307692,null,184.7740967307692]
["SUB-TOTAL FRINGE BENEFITS",6405.387332268611,0,6405.387332268611]
[]
["SUB-TOTAL SALARY & WAGES AND FRINGE BENEFITS",44415.77769611477,0,44415.77769611477]
[]
["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."]
[" 250 miles RT x 12 trips x $.30/mile x 1 vehicle (Task 8)",900,null,900]
[]
[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",900,0,900]
[]
["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",0,null,0]
["Executive Summary ",0,null,0]
["Final Report ",0,null,0]
["SUB-TOTAL PRINTING",0,0,0]
[]
["IN-DIRECT COSTS",13303.636627346154,0,13303.636627346154]
["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",13303.636627346154,0,13303.636627346154]
[]
["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",58619.41432346092,0,58619.41432346092]

{"sheet":"Form 2 SS","index":4,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[[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 A8",{"$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,{"$nulls":12},0,0,0,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,17,17,17,17,17,17,18,18,18,null,null,null,156,15177.599999999999,3296.7716352,null,null,0.0145,"Medicare"]
[{"$nulls":15},0,null,null,0.2172129740670462,"Benefit rate"]
["Monthly hours",17,17,17,17,17,17,18,18,18,0,0,0,156,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",1653.9692307692308,1653.9692307692308,1653.9692307692308,1653.9692307692308,1653.9692307692308,1653.9692307692308,1751.2615384615383,1751.2615384615383,1751.2615384615383,0,0,0,15177.599999999999,15177.599999999999,3296.7716352,844.8000000000001,2124.864,107.0324352,220.0752]
[{"$nulls":16},844.8000000000001,"AY only"]
["Quarterly Reports",null,null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.1,"% 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 A8",{"$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,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,17,17,17,17,17,17,18,18,18,null,null,null,156,15632.927999999998,3395.6747842560003]
[{"$nulls":15},0]
["Monthly hours",17,17,17,17,17,17,18,18,18,0,0,0,156,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",1703.5883076923078,1703.5883076923078,1703.5883076923078,1703.5883076923078,1703.5883076923078,1703.5883076923078,1803.7993846153845,1803.7993846153845,1803.7993846153845,0,0,0,15632.927999999998,15632.927999999998,3395.6747842560003,844.8000000000001,2188.60992,110.243408256,226.67745599999998]
[{"$nulls":16},844.8000000000001,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.1,"% time"]
["Draft Final Report",{"$nulls":14},156]
[" 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 A8",{"$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,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,17,17,17,17,17,17,18,18,18,null,null,null,156,16101.915839999998,3497.54502778368]
[{"$nulls":15},0]
["Monthly hours",17,17,17,17,17,17,18,18,18,0,0,0,156,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",1754.695956923077,1754.695956923077,1754.695956923077,1754.695956923077,1754.695956923077,1754.695956923077,1857.9133661538458,1857.9133661538458,1857.9133661538458,0,0,0,16101.915839999998,16101.915839999998,3497.54502778368,844.8000000000001,2254.2682176,113.55071050367998,233.47777967999997]
[{"$nulls":16},844.8000000000001,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.1,"% time"]
["Draft Final Report",{"$nulls":7},"X",{"$nulls":6},156]
[" Final Report",{"$nulls":11},"X"]
["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 TM","index":5,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[3,0,3,14],[4,1,4,12],[21,0,21,14],[22,0,22,14],[23,0,23,14],[24,0,24,14],[29,0,29,14],[30,0,30,14],[32,0,32,14],[33,1,33,12],[50,0,50,14],[51,0,51,14],[52,0,52,14],[53,0,53,14],[58,0,58,14],[59,0,59,14],[61,0,61,14],[62,1,62,12],[79,0,79,14],[80,0,80,14],[81,0,81,14],[82,0,82,14]],"flags":["formulas_cached_only"]}
["Monitoring and Modeling of Pavement Response and Performance"]
["WORK TIME COST SCHEDULE FOR FINAL PROPOSAL BUDGET FORM",{"$nulls":16},"Teruhisa Masada"]
["Task A8",{"$nulls":15},"Year","Salary",74015]
["For Associate Professor (T. Masada) – 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",47.44551282051282,8223.888888888889,"Monthly rate"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,74015,null,78]
[1,{"$nulls":12},0,0,0,"summer","Monthly hours",6.5,411.19444444444446,"5% of monthly rate"]
[2,{"$nulls":12},0,0,0,24671.666666666668]
[3,{"$nulls":12},0,0,0,null,null,8448,"Health Insurance annual cost"]
[4,{"$nulls":12},0,0,0,null,null,5.415384615384616,"Health Insurance hourly"]
[5,{"$nulls":12},0,0,0,null,null,0.11413902587313383,"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,12,12,12,12,12,12,12,12,12,null,null,null,108,5124.115384615385,1412.6726270769234,null,null,0.0145,"Medicare"]
[{"$nulls":15},0,null,null,0.2756910258731339,"Benefit rate"]
["Monthly hours",12,12,12,12,12,12,12,12,12,0,0,0,108,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",569.3461538461538,569.3461538461538,569.3461538461538,569.3461538461538,569.3461538461538,569.3461538461538,569.3461538461538,569.3461538461538,569.3461538461538,0,0,0,5124.115384615385,5124.115384615385,1412.6726270769234,584.8615384615385,717.3761538461539,36.135261692307694,74.29967307692309]
[{"$nulls":16},584.8615384615385,"AY only"]
["Quarterly Reports",null,null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.06923076923076923,"% 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 wor"]
["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 A8",{"$nulls":15},"Year"]
["For Associate Professor (T. Masada) – 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,76235.45]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,25411.816666666666]
[3,{"$nulls":12},0,0,0]
[4,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,12,12,12,12,12,12,12,12,12,null,null,null,108,5277.838846153846,1455.052805889231]
[{"$nulls":15},0]
["Monthly hours",12,12,12,12,12,12,12,12,12,0,0,0,108,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",586.4265384615385,586.4265384615385,586.4265384615385,586.4265384615385,586.4265384615385,586.4265384615385,586.4265384615385,586.4265384615385,586.4265384615385,0,0,0,5277.838846153846,5277.838846153846,1455.052805889231,584.8615384615385,738.8974384615385,37.21931954307692,76.52866326923078]
[{"$nulls":16},584.8615384615385,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.06923076923076923,"% time"]
["Draft Final Report",{"$nulls":14},108]
[" 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 wor"]
["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 A8",{"$nulls":15},"Year"]
["For Associate Professor (T. Masada) – 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,78522.5135]
[1,{"$nulls":12},0,0,0,"summer"]
[2,{"$nulls":12},0,0,0,26174.171166666667]
[3,{"$nulls":12},0,0,0]
[4,{"$nulls":12},0,0,0]
[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",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,"Health Insurance","STRS","Workers Comp","Medicare"]
["Monthly labor costs",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":16},0,"AY only"]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0,"% time"]
["Draft Final Report",{"$nulls":7},"X",{"$nulls":6},0]
[" Final Report",{"$nulls":11},"X"]
["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 wor"]
["Salaries may differ slightly from budget sheet due to rounding."]
["Salaries are figured with a 3% increase each year."]

{"sheet":"Form 2 IK","index":6,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[[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},"Issam Khoury"]
["Task A8",{"$nulls":15},"Year","Salary",66016]
["For Research Engineer (I. Khoury) – Year 1",{"$nulls":15},1,"Hours/year",2080,12,null,"hours/month"]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","FY salary","Hourly rate",31.73846153846154,5501.333333333333,"Monthly rate"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,66016,null,832]
[1,{"$nulls":12},0,0,0,null,"Monthly hours",69.33333333333333,2200.5333333333333,"40% of monthly rate"]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0,null,null,8448,"Health Insurance annual cost"]
[4,{"$nulls":12},0,0,0,null,null,4.061538461538461,"Health Insurance hourly"]
[5,{"$nulls":12},0,0,0,null,null,0.1279689772176442,"Health insurance percentage"]
[6,{"$nulls":12},0,0,0,null,null,0.1331,"PERS"]
[7,{"$nulls":12},0,0,0,null,null,0.007052,"Workers Comp"]
[8,39,39,39,39,39,39,39,39,39,39,39,39,468,14853.6,4197.9389472,null,null,0.0145,"Medicare"]
[{"$nulls":15},0,null,null,0.28262097721764423,"Benefit rate"]
["Monthly hours",39,39,39,39,39,39,39,39,39,39,39,39,468,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",1237.8,1237.8,1237.8,1237.8,1237.8,1237.8,1237.8,1237.8,1237.8,1237.8,1237.8,1237.8,14853.6,14853.6,4197.9389472,1900.8,1977.01416,104.7475872,215.37720000000002]
[]
["Quarterly Reports",null,null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.225,"% time"]
["Draft Final Report"]
[" Final Report",{"$nulls":17},4940.52,3026.1279678151413]
["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.",{"$nulls":18},95.34576728452942,"hours"]
["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},117]
["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 A8",{"$nulls":15},"Year"]
["For Research Engineer (I. Khoury) – 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,67996.48]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,22,22,22,22,21,21,21,21,22,22,22,22,260,8499.56,2402.15395312]
[{"$nulls":15},0]
["Monthly hours",22,22,22,22,21,21,21,21,22,22,22,22,260,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",719.1935384615385,719.1935384615385,719.1935384615385,719.1935384615385,686.5029230769231,686.5029230769231,686.5029230769231,686.5029230769231,719.1935384615385,719.1935384615385,719.1935384615385,719.1935384615385,8499.56,8499.56,2402.15395312,1056,1131.291436,59.93889712,123.24361999999999]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.125,"% 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 A8",{"$nulls":15},"Year"]
["For Research Engineer (I. Khoury) – 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,70036.3744]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,17,17,17,17,17,17,17,17,18,18,18,18,208,7003.63744,1979.3748573708804]
[{"$nulls":15},0]
["Monthly hours",17,17,17,17,17,17,17,17,18,18,18,18,208,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",572.4126753846153,572.4126753846153,572.4126753846153,572.4126753846153,572.4126753846153,572.4126753846153,572.4126753846153,572.4126753846153,606.0840092307693,606.0840092307693,606.0840092307693,606.0840092307693,7003.63744,7003.63744,1979.3748573708804,844.8,932.184143264,49.389651226880005,101.55274288000001]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.1,"% time"]
["Draft Final Report",{"$nulls":7},"X",{"$nulls":6},154]
[" Final Report",{"$nulls":11},"X"]
["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 RA","index":7,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[[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 A8",{"$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,{"$nulls":12},0,0,0,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,86,86,86,86,87,87,87,87,87,87,87,87,1040,18000,387.93600000000004,null,null,0.0145,"Medicare"]
[{"$nulls":15},0,null,null,0.021552,"Benefit rate"]
["Monthly hours",86,86,86,86,87,87,87,87,87,87,87,87,1040,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",1488.4615384615383,1488.4615384615383,1488.4615384615383,1488.4615384615383,1505.7692307692307,1505.7692307692307,1505.7692307692307,1505.7692307692307,1505.7692307692307,1505.7692307692307,1505.7692307692307,1505.7692307692307,18000,18000,387.93600000000004,0,0,126.936,261]
[]
["Quarterly Reports",null,null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},1,"% 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},261]
["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 A8",{"$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,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,58,58,58,58,58,58,58,58,58,58,57,57,694,12371.884615384615,266.63885723076925]
[{"$nulls":15},0]
["Monthly hours",58,58,58,58,58,58,58,58,58,58,57,57,694,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",1033.9615384615383,1033.9615384615383,1033.9615384615383,1033.9615384615383,1033.9615384615383,1033.9615384615383,1033.9615384615383,1033.9615384615383,1033.9615384615383,1033.9615384615383,1016.1346153846154,1016.1346153846154,12371.884615384615,12371.884615384615,266.63885723076925,0,0,87.24653030769231,179.39232692307692]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.6673076923076923,"% time"]
["Draft Final Report",{"$nulls":14},522]
[" 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 A8",{"$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,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,58,58,58,58,58,58,58,58,58,58,57,57,694,12743.041153846152,274.6380229476923]
[{"$nulls":15},0]
["Monthly hours",58,58,58,58,58,58,58,58,58,58,57,57,694,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",1064.9803846153845,1064.9803846153845,1064.9803846153845,1064.9803846153845,1064.9803846153845,1064.9803846153845,1064.9803846153845,1064.9803846153845,1064.9803846153845,1064.9803846153845,1046.6186538461536,1046.6186538461536,12743.041153846152,12743.041153846152,274.6380229476923,0,0,89.86392621692306,184.7740967307692]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.6673076923076923,"% time"]
["Draft Final Report",{"$nulls":7},"X",{"$nulls":6},522]
[" Final Report",{"$nulls":11},"X"]
["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 MK","index":8,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[[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},"Mike Krumlauf"]
["Task A8",{"$nulls":15},"Year","Salary",40754]
["For Technician (M. Krumlauf) – Year 1",{"$nulls":15},1,"Hours/year",2080,12,null,"hours/month"]
["TASKS","MONTH",{"$nulls":11},"TOTAL TASK HOURS","TOTAL LABOR COSTS","Benefits","FY salary","Hourly rate",19.59326923076923,3396.1666666666665,"Monthly rate"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,40754,null,832]
[1,{"$nulls":12},0,0,0,null,"Monthly hours",69.33333333333333,1358.4666666666667,"40% of monthly rate"]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0,null,null,8448,"Health Insurance annual cost"]
[4,{"$nulls":12},0,0,0,null,null,4.061538461538461,"Health Insurance hourly"]
[5,{"$nulls":12},0,0,0,null,null,0.20729253570201697,"Health insurance percentage"]
[6,{"$nulls":12},0,0,0,null,null,0.1331,"PERS"]
[7,{"$nulls":12},0,0,0,null,null,0.007052,"Workers Comp"]
[8,34,34,34,34,35,35,35,35,35,35,35,35,416,8150.8,2950.1375216,null,null,0.0145,"Medicare"]
[{"$nulls":15},0,null,null,0.361944535702017,"Benefit rate"]
["Monthly hours",34,34,34,34,35,35,35,35,35,35,35,35,416,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",666.1711538461539,666.1711538461539,666.1711538461539,666.1711538461539,685.7644230769231,685.7644230769231,685.7644230769231,685.7644230769231,685.7644230769231,685.7644230769231,685.7644230769231,685.7644230769231,8150.8,8150.8,2950.1375216,1689.6,1084.87148,57.4794416,118.18660000000001]
[]
["Quarterly Reports",null,null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.2,"% 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},105]
["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 A8",{"$nulls":15},"Year"]
["For Technician (M. Krumlauf) – 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,41976.62]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,8,8,8,8,9,9,9,9,9,9,9,9,104,2098.831,759.6604118120001]
[{"$nulls":15},0]
["Monthly hours",8,8,8,8,9,9,9,9,9,9,9,9,104,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",161.44853846153848,161.44853846153848,161.44853846153848,161.44853846153848,181.62960576923078,181.62960576923078,181.62960576923078,181.62960576923078,181.62960576923078,181.62960576923078,181.62960576923078,181.62960576923078,2098.831,2098.831,759.6604118120001,422.4,279.3544061,14.800956212000001,30.433049500000003]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.05,"% time"]
["Draft Final Report",{"$nulls":14},77]
[" 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 A8",{"$nulls":15},"Year"]
["For Technician (M. Krumlauf) – 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,43235.918600000005]
[1,{"$nulls":12},0,0,0]
[2,{"$nulls":12},0,0,0]
[3,{"$nulls":12},0,0,0]
[4,{"$nulls":12},0,0,0]
[5,{"$nulls":12},0,0,0]
[6,{"$nulls":12},0,0,0]
[7,{"$nulls":12},0,0,0]
[8,8,8,8,8,9,9,9,9,9,9,9,9,104,2161.7959299999998,782.4502241663599]
[{"$nulls":15},0]
["Monthly hours",8,8,8,8,9,9,9,9,9,9,9,9,104,null,0,"Health Insurance","PERS","Workers Comp","Medicare"]
["Monthly labor costs",166.2919946153846,166.2919946153846,166.2919946153846,166.2919946153846,187.0784939423077,187.0784939423077,187.0784939423077,187.0784939423077,187.0784939423077,187.0784939423077,187.0784939423077,187.0784939423077,2161.7959299999998,2161.7959299999998,782.4502241663599,422.4,287.73503828299994,15.244984898359998,31.346040985]
[]
["Quarterly Reports","X",null,null,"X",null,null,"X",null,null,"X",{"$nulls":4},0.05,"% time"]
["Draft Final Report",{"$nulls":7},"X",{"$nulls":6},77]
[" Final Report",{"$nulls":11},"X"]
["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":"Travel","index":9,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":23}
["A8"]
[]
["Travel"]
[null,"Number ","mileage","overnight  ",null,null,"three people"]
["Year","of trips","cost","stays","hotels","meals","cost","total"]
[1,70,10500,10,2250,1800,4050,14550]
[2,12,900,0,0,0,0,900]
[3,12,900,0,0,0,0,900]
["total",null,12300,null,null,null,4050,16350]
[]
["mileage","mileage rate","mileage cost"]
[250,0.3,75]
[]
["Hotel"]
[75,"per day"]
[]
["Meals"]
[30,"per day"]
[]
["Overnight stays include hotel and two days meals"]
[135,"total per person"]

{"sheet":"Sensors","index":10,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Task A8"]
["Budget for OHIO SHRP Test Road November 2005"]
["List of Sensors"]
["Typical Section"]
["Item","Quantity","Price per each","Total","Subtask","Category"]
["LVDT",14,626,8764,"A8a","equipment"]
["Vishay MM EGP -5-120",6,45,270,"A8a","supplies"]
["Thermocouple",10,90,900,"A8a","supplies"]
["KM100BT",10,285,2850,"A8a","supplies"]
["Geokon Pressure Cells",2,630,1260,"A8a","equipment"]
["Wires for Geokon Pressure Cell (feet)",150,0.93,139.5,"A8a","supplies"]
["LVDT Boxes/Hardware",14,178.57142857142858,2500,"A8a","supplies"]
["Extension Wires (feet)",3000,0.75,2250,"A8a","supplies",8909.5]
["Supplies",1,1000,1000,"A8a","supplies",10024]
["TDR Probes",10,182.1,1821,"A8b","supplies"]
["CR10 datalogger for TDR probes",1,1200,1200,"A8b","equipment"]
["Power supply for TDR probe datalogger",1,233.28,233.28,"A8b","supplies"]
["Weather-resistant enclosure",1,187.2,187.2,"A8b","supplies"]
["Shipping+ insurance for TDR probes",1,103,103,"A8b","supplies",3544.48]
["Temperature probe",1,1515,1515,"A8b","equipment"]
[]
["TOTAL",null,null,19933.5]
["No. sections",null,null,5]
["Grand total",null,null,99667.5,"does not include environmental sensors (A8b)"]
[]
["Supplies for pavement sections",null,null,49547.5]
["Supplies for environmental sensors",null,null,2344.48]
["Total supplies",null,null,51891.979999999996,"includes environmental (A8b)"]
[]
["Equipment for pavement sections",null,null,50120]
["Equipment for environmental sensors",null,null,2715]
["Total equipment",null,null,52835,"includes environmental (A8b)"]
[]
["Environmental sensors:"]
["total",null,null,5059.48,"A8b"]
[]
[]
["Note:  All prices are based current quotes of limited duration.  Prices may change at time of actual installation"]

{"sheet":"Printing","index":11,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Task A8"]
["Printing costs summary"]
[null,"pages","Cost per page","print total","Cover","Bind","Total cost per copy","Number of copies","Total cost","Year","Note"]
["Draft report",200,0.07,14.000000000000002,0.4,2.99,17.39,0,0,3,"Combined with report for Tasks A1-7"]
["Final report",200,0.038,7.6,0.4,2.99,10.99,0,0,3,"Combined with report for Tasks A1-7"]
["Executive summary",4,0.08,0.32,null,null,0.32,0,0,3,"Combined with executive summary for Tasks A1-7"]
["Total printing cost entire project",{"$nulls":7},0]
[]
[]
[]
[{"$nulls":5},3.99,"spiral"]