{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Consultant Rate Form","Example-NewContract","Example-Conversion","Example-2ndCRF"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Consultant Rate Form","index":0,"n_rows":65,"n_cols":19,"rows_kept":65,"cut":false,"hidden":false,"merged":[[39,5,39,6],[40,5,40,6],[31,11,31,13],[36,11,36,13],[34,9,34,10],[34,11,34,13],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[44,2,44,3],[37,5,37,6],[3,2,3,10],[4,2,4,10],[7,2,8,3],[9,2,9,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[18,5,18,6],[19,5,19,6],[20,5,20,6],[38,9,38,10],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[34,2,34,3],[0,12,0,14],[1,12,1,14],[2,12,3,14],[34,5,34,6],[35,5,35,6],[36,5,36,6],[38,5,38,6],[9,5,9,6],[31,5,31,6],[7,14,8,14],[7,9,8,10],[9,9,9,10],[6,8,6,13],[6,4,6,7],[27,9,27,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[7,11,8,13],[9,11,9,13],[7,4,8,4],[29,2,29,3],[29,11,29,13],[30,2,30,3],[30,11,30,13],[33,2,33,3],[35,2,35,3],[32,2,32,3],[32,5,32,6],[32,9,32,10],[32,11,32,13],[35,9,35,10],[33,5,33,6],[33,9,33,10],[29,5,29,6],[29,9,29,10],[30,5,30,6],[31,9,31,10],[0,2,0,3],[27,2,27,3],[27,5,27,6],[7,0,7,1],[7,5,8,6],[35,11,35,13],[7,8,8,8],[11,2,11,3],[11,5,11,6],[11,9,11,10],[11,11,11,13],[10,2,10,3],[10,5,10,6],[10,9,10,10],[10,11,10,13],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[25,2,25,3],[26,2,26,3],[31,2,31,3],[7,7,8,7],[43,9,43,10],[44,9,44,10],[46,11,46,13],[48,2,48,3],[48,5,48,6],[48,9,48,10],[48,11,48,13],[27,11,27,13],[37,9,37,10],[44,11,44,13],[42,2,42,3],[12,11,12,13],[12,9,12,10],[12,2,12,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[30,9,30,10],[36,2,36,3],[28,11,28,13],[13,2,13,3],[46,9,46,10],[50,9,50,10],[55,3,55,5],[47,11,47,13],[50,2,50,3],[61,0,61,14],[54,0,54,1],[54,3,54,5],[54,7,54,8],[50,11,50,13],[47,2,47,3],[47,5,47,6],[47,9,47,10],[59,10,59,13],[55,0,55,1],[55,7,55,8],[54,10,54,13],[46,5,46,6],[50,5,50,6],[25,5,25,6],[26,5,26,6],[28,2,28,3],[28,5,28,6],[49,2,49,3],[55,10,55,13],[49,5,49,6],[49,9,49,10],[49,11,49,13],[46,2,46,3],[43,5,43,6],[20,2,20,3],[13,9,13,10],[14,9,14,10],[13,11,13,13],[14,11,14,13],[15,11,15,13],[16,11,16,13],[17,11,17,13],[18,11,18,13],[19,11,19,13],[20,11,20,13],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[45,2,45,3],[45,5,45,6],[44,5,44,6],[43,2,43,3],[43,11,43,13],[41,9,41,10],[41,11,41,13],[42,5,42,6],[42,9,42,10],[42,11,42,13],[41,5,41,6],[21,11,21,13],[22,11,22,13],[23,11,23,13],[24,11,24,13],[25,11,25,13],[26,11,26,13],[40,9,40,10],[45,9,45,10],[45,11,45,13],[28,9,28,10],[33,11,33,13],[36,9,36,10],[37,11,37,13],[38,11,38,13],[39,9,39,10],[39,11,39,13],[40,11,40,13],[63,0,63,3],[63,5,63,8],[64,0,64,3],[64,5,64,8],[64,10,64,13],[59,0,59,3],[59,5,59,8],[58,5,58,8],[58,0,58,3]]}
["Contract Number:",null,null,null,null,null,null,null,null,null,null,"Effective Date:",null,null,null,null,"Y"]
["Type Of Contract (check box)",null,"DSE       CM ",null,null,null,null,null,null,null,null,"Year of PSB:",null,null,null,null,"N",null,"Annual Increase"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Enter year Professional Services Bulletin was advertised)",null,null,null,null,null,"Deceased"]
["Prime Consultant Company Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name Change"]
["Sub-Consultant Company Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Employee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Promotion - Title Change"]
[null,null,null,null,"These columns to be completed on all CRFs",null,null,null,"These columns to be completed starting with second CRF for contract",null,null,null,null,null,null,null,null,null,"Raise"]
["Employee Name \n(Alphabetically by Last Name)",null,"Consultant \nClassification/Title",null,"Original Hourly Rate at NTP or Promotion","Maximum Hourly Rate for Person/Title\n (calculated at 125% of original unless rate cap triggered based on PSB year)",null,"Previous/Current Hourly Rate \n(from CRF immediately preceding this one)","Updated Hourly Rate\n (updated rate paid to employee after increase or capped rate)","Percent Increase* ",null,"Reason for Change*\n(select from drop-down menu or type your own)",null,null,"Eligible for Premium Overtime?\n(Y/N)",null,null,null,"Remove Employee"]
["Last","First",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terminated"]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E10*1.25,IF(M$2<2018,IF(E10*1.25>70,70,E10*1.25)))","v":0},null,null,null,{"$f":"IF(H10<1,\"\", IF((I10-H10)/H10>0,(I10-H10)/H10,\"\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E11*1.25,IF(M$2<2018,IF(E11*1.25>70,70,E11*1.25)))","v":0},null,null,null,{"$f":"IF(H11<1,\"\", IF((I11-H11)/H11>0,(I11-H11)/H11,\"\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E12*1.25,IF(M$2<2018,IF(E12*1.25>70,70,E12*1.25)))","v":0},null,null,null,{"$f":"IF(H12<1,\"\", IF((I12-H12)/H12>0,(I12-H12)/H12,\"\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E13*1.25,IF(M$2<2018,IF(E13*1.25>70,70,E13*1.25)))","v":0},null,null,null,{"$f":"IF(H13<1,\"\", IF((I13-H13)/H13>0,(I13-H13)/H13,\"\"))","v":""}]
[null,null,null,null,null,0,null,null,null,{"$f":"IF(H14<1,\"\", IF((I14-H14)/H14>0,(I14-H14)/H14,\"\"))","v":""}]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E28*1.25,IF(M$2<2018,IF(E28*1.25>70,70,E28*1.25)))","v":0},null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E32*1.25,IF(M$2<2018,IF(E32*1.25>70,70,E32*1.25)))","v":0},null,null,null,""]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E33*1.25,IF(M$2<2018,IF(E33*1.25>70,70,E33*1.25)))","v":0},null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E37*1.25,IF(M$2<2018,IF(E37*1.25>70,70,E37*1.25)))","v":0},null,null,null,""]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E38*1.25,IF(M$2<2018,IF(E38*1.25>70,70,E38*1.25)))","v":0},null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E48*1.25,IF(M$2<2018,IF(E48*1.25>70,70,E48*1.25)))","v":0},null,null,null,""]
[null,null,null,null,null,0,null,null,null,{"$f":"IF(H49<1,\"\", IF((I49-H49)/H49>0,(I49-H49)/H49,\"\"))","v":""}]
[null,null,null,null,null,0,null,null,null,{"$f":"IF(H50<1,\"\", IF((I50-H50)/H50>0,(I50-H50)/H50,\"\"))","v":""}]
[null,null,null,null,null,0]
[]
["Consultant Certification:"]
["I certify, to the best of my knowledge, under penalty of perjury, that the hourly payroll rates identified above are a true and accurate reflection of actual hourly rates paid to personnel."]
[]
["Authorized Agent Signature",null,null,"Authorized Agent Printed Name",null,null,null,"Email Address",null,null,"Phone Number w/extension"]
[]
["Tollway Approval:"]
[]
["Tollway PM Signature",null,null,null,null,"Tollway PM Printed Name",null,null,null,null,"Date"]
[]
["*Increases 7% or greater per year, increases above Maximum Hourly Rate, or a promotion to new title all require a letter of explanation to the Deputy Chief."]
[]
[]
["Deputy Chief Signature",null,null,null,null,"Deputy Chief Printed Name",null,null,null,null,"Date"]

{"sheet":"Example-NewContract","index":1,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,2,4,10],[0,2,0,3],[0,12,0,14],[1,12,1,14],[2,12,3,14],[3,2,3,10],[7,0,7,1],[7,2,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[10,2,10,3],[10,5,10,6],[10,9,10,10],[10,11,10,13],[6,4,6,7],[6,8,6,13],[7,8,8,8],[7,9,8,10],[7,11,8,13],[7,14,8,14],[9,2,9,3],[9,5,9,6],[9,9,9,10],[9,11,9,13],[11,2,11,3],[11,5,11,6],[11,9,11,10],[11,11,11,13],[12,2,12,3],[12,5,12,6],[12,9,12,10],[12,11,12,13],[15,2,15,3],[15,5,15,6],[15,9,15,10],[15,11,15,13],[13,2,13,3],[13,5,13,6],[13,9,13,10],[13,11,13,13],[14,2,14,3],[14,5,14,6],[14,9,14,10],[14,11,14,13],[22,0,22,1],[22,3,22,5],[22,7,22,8],[22,10,22,13],[16,2,16,3],[16,5,16,6],[16,9,16,10],[16,11,16,13],[17,0,17,14],[21,0,21,1],[21,3,21,5],[21,7,21,8],[21,10,21,13],[25,0,25,3],[25,5,25,8],[26,0,26,3],[26,5,26,8],[26,10,26,13],[28,0,28,14],[30,0,30,3],[30,5,30,8],[31,0,31,3],[31,5,31,8],[31,10,31,13]]}
["Contract Number:",null,"RR-19-1234",null,null,null,null,null,null,null,null,"Effective Date:","2019-06-28",null,null,null,"Y"]
["Type Of Contract (check box)",null,"DSE       CM ",null,null,null,null,null,null,null,null,"Year of PSB:",2018,null,null,null,"N",null,"Annual Increase"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Enter year Professional Services Bulletin was advertised)",null,null,null,null,null,"Deceased"]
["Prime Consultant Company Name:",null,"ABC Consulting, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name Change"]
["Sub-Consultant Company Name:",null,"XYZ Consulting, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Employee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Promotion - Title Change"]
[null,null,null,null,"These columns to be completed on all CRFs",null,null,null,"These columns to be completed starting with second CRF for contract",null,null,null,null,null,null,null,null,null,"Raise"]
["Employee Name \n(Alphabetically by Last Name)",null,"Consultant Classification/Title",null,"Original Hourly Rate at NTP or Promotion","Maximum Hourly Rate for Person/Title\n (calculated at 125% of original unless rate cap triggered based on PSB year)",null,"Previous/Current Hourly Rate \n(from CRF immediately preceding this one)","Updated Hourly Rate\n (updated rate paid to employee after increase or capped rate)","Percent Increase* ",null,"Reason for Change*\n(select from drop-down menu or type your own)",null,null,"Eligible for Premium Overtime?\n(Y/N)",null,null,null,"Remove Employee"]
["Last","First",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terminated"]
["Beard","Brad","Project Manager",null,70,{"$f":"IF(M$2>2017,E10*1.25,IF(M$2<2018,IF(E10*1.25>70,70,E10*1.25)))","v":87.5},null,70,null,{"$f":"IF(H10<1,\"\", IF((I10-H10)/H10>0,(I10-H10)/H10,\"\"))","v":""},null,null,null,null,"N"]
["Box","Jack","Engineer I",null,26,{"$f":"IF(M$2>2017,E11*1.25,IF(M$2<2018,IF(E11*1.25>70,70,E11*1.25)))","v":32.5},null,26,null,{"$f":"IF(H11<1,\"\", IF((I11-H11)/H11>0,(I11-H11)/H11,\"\"))","v":""},null,null,null,null,"N"]
["Boy","Thomas","Doc Engineer",null,22,27.5,null,22,null,"",null,null,null,null,"Y"]
["Doe","John","Engineer II",null,35,43.75,null,35,null,"",null,null,null,null,"N"]
["Friend","Jane","Admin",null,19,23.75,null,19,null,"",null,null,null,null,"Y"]
["Shoe","James","RE",null,45,56.25,null,45,null,"",null,null,null,null,"N"]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
["All hourly rates must be approved by the Illinois Tollway before payment can be made.  It is understood that an increase to the hourly rates will not result in an increase to the Upper Limit of Compensation."]
[]
["Consultant Certification:"]
["I certify, to the best of my knowledge, under penalty of perjury, that the hourly payroll rates identified above are a true and accurate reflection of actual hourly rates paid to personnel."]
[null,null,null,"Jane Friend",null,null,null,"jfriend@xyzconsulting.com",null,null,"773-588-2300"]
["Authorized Agent Signature",null,null,"Authorized Agent Printed Name",null,null,null,"Email Address",null,null,"Phone Number w/extension"]
[]
["Tollway Approval:"]
[]
["Tollway PM Signature",null,null,null,null,"Tollway PM Printed Name",null,null,null,null,"Date"]
[]
["*Increases 7% or greater per year, increases above Maximum Hourly Rate, or a promotion to new title all require a letter of explanation to the Deputy Chief."]
[]
[]
["Deputy Chief Signature",null,null,null,null,"Deputy Chief Printed Name",null,null,null,null,"Date"]

{"sheet":"Example-Conversion","index":2,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,2,4,10],[0,2,0,3],[0,12,0,14],[1,12,1,14],[2,12,3,14],[3,2,3,10],[7,0,7,1],[7,2,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[10,2,10,3],[10,5,10,6],[10,9,10,10],[10,11,10,13],[6,4,6,7],[6,8,6,13],[7,8,8,8],[7,9,8,10],[7,11,8,13],[7,14,8,14],[9,2,9,3],[9,5,9,6],[9,9,9,10],[9,11,9,13],[11,2,11,3],[11,5,11,6],[11,9,11,10],[11,11,11,13],[12,2,12,3],[12,5,12,6],[12,9,12,10],[12,11,12,13],[17,11,17,13],[13,2,13,3],[13,5,13,6],[13,9,13,10],[13,11,13,13],[15,2,15,3],[15,5,15,6],[15,9,15,10],[15,11,15,13],[14,5,14,6],[14,11,14,13],[14,2,14,3],[23,0,23,1],[23,3,23,5],[23,7,23,8],[23,10,23,13],[16,2,16,3],[18,0,18,14],[22,0,22,1],[22,3,22,5],[22,7,22,8],[22,10,22,13],[16,5,16,6],[16,9,16,10],[16,11,16,13],[17,2,17,3],[17,5,17,6],[17,9,17,10],[32,5,32,8],[32,10,32,13],[26,0,26,3],[26,5,26,8],[27,0,27,3],[27,5,27,8],[27,10,27,13],[29,0,29,14],[31,0,31,3],[31,5,31,8],[32,0,32,3]]}
["Contract Number:",null,"I-14-6789",null,null,null,null,null,null,null,null,"Effective Date:","2019-07-01",null,null,null,"Y"]
["Type Of Contract (check box)",null,"DSE       CM ",null,null,null,null,null,null,null,null,"Year of PSB:",2014,null,null,null,"N",null,"Annual Increase"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Enter year Professional Services Bulletin was advertised)",null,null,null,null,null,"Deceased"]
["Prime Consultant Company Name:",null,"Roadway Designers, LLC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name Change"]
["Sub-Consultant Company Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Employee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Promotion - Title Change"]
[null,null,null,null,"These columns to be completed on all CRFs",null,null,null,"These columns to be completed starting with second CRF for contract",null,null,null,null,null,null,null,null,null,"Raise"]
["Employee Name \n(Alphabetically by Last Name)",null,"Consultant Classification/Title",null,"Original Hourly Rate at NTP or Promotion","Maximum Hourly Rate for Person/Title\n (calculated at 125% of original unless rate cap triggered based on PSB year)",null,"Previous/Current Hourly Rate \n(from CRF immediately preceding this one)","Updated Hourly Rate\n (updated rate paid to employee after increase or capped rate)","Percent Increase* ",null,"Reason for Change*\n(select from drop-down menu or type your own)",null,null,"Eligible for Premium Overtime?\n(Y/N)",null,null,null,"Remove Employee"]
["Last","First",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terminated"]
["Gun","Thomas","Engineer I",null,30,{"$f":"IF(M$2>2017,E10*1.25,IF(M$2<2018,IF(E10*1.25>70,70,E10*1.25)))","v":37.5},null,30,null,{"$f":"IF(H10<1,\"\", IF((I10-H10)/H10>0,(I10-H10)/H10,\"\"))","v":""},null,null,null,null,"Y"]
["Light","Buddy","Admin",null,26,{"$f":"IF(M$2>2017,E11*1.25,IF(M$2<2018,IF(E11*1.25>70,70,E11*1.25)))","v":32.5},null,26,27.2,{"$f":"IF(H11<1,\"\", IF((I11-H11)/H11>0,(I11-H11)/H11,\"\"))","v":4.6153846153846129E-2},null,"Raise",null,null,"Y"]
["Macklin","Burt","Principal",null,70,70,null,70,null,"",null,null,null,null,"N"]
["Thompson","Tom","Sr. Engineering Mgr",null,68,70,null,68,null,"",null,"New Employee",null,null,"N"]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(M$2>2017,E15*1.25,IF(M$2<2018,IF(E15*1.25>70,70,E15*1.25)))","v":0}]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
["All hourly rates must be approved by the Illinois Tollway before payment can be made.  It is understood that an increase to the hourly rates will not result in an increase to the Upper Limit of Compensation."]
[]
["Consultant Certification:"]
["I certify, to the best of my knowledge, under penalty of perjury, that the hourly payroll rates identified above are a true and accurate reflection of actual hourly rates paid to personnel."]
[null,null,null,"Buddy Light",null,null,null,"light.bud@rdllc.com",null,null,"312-222-2222"]
["Authorized Agent Signature",null,null,"Authorized Agent Printed Name",null,null,null,"Email Address",null,null,"Phone Number w/extension"]
[]
["Tollway Approval:"]
[]
["Tollway PM Signature",null,null,null,null,"Tollway PM Printed Name",null,null,null,null,"Date"]
[]
["*Increases 7% or greater per year, increases above Maximum Hourly Rate, or a promotion to new title all require a letter of explanation to the Deputy Chief."]
[]
[]
["Deputy Chief Signature",null,null,null,null,"Deputy Chief Printed Name",null,null,null,null,"Date"]

{"sheet":"Example-2ndCRF","index":3,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,2,4,10],[0,2,0,3],[0,12,0,14],[1,12,1,14],[2,12,3,14],[3,2,3,10],[7,0,7,1],[7,2,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[10,2,10,3],[10,5,10,6],[10,9,10,10],[10,11,10,13],[6,4,6,7],[6,8,6,13],[7,8,8,8],[7,9,8,10],[7,11,8,13],[7,14,8,14],[9,2,9,3],[9,5,9,6],[9,9,9,10],[9,11,9,13],[12,2,12,3],[12,5,12,6],[12,9,12,10],[12,11,12,13],[13,2,13,3],[13,5,13,6],[13,9,13,10],[13,11,13,13],[14,2,14,3],[14,5,14,6],[14,9,14,10],[14,11,14,13],[15,2,15,3],[15,5,15,6],[15,9,15,10],[15,11,15,13],[16,9,16,10],[16,11,16,13],[17,2,17,3],[17,5,17,6],[17,9,17,10],[17,11,17,13],[31,0,31,3],[31,5,31,8],[32,0,32,3],[32,5,32,8],[32,10,32,13],[11,2,11,3],[11,5,11,6],[11,9,11,10],[11,11,11,13],[29,0,29,14],[18,0,18,14],[22,0,22,1],[22,3,22,5],[22,7,22,8],[22,10,22,13],[23,0,23,1],[23,3,23,5],[23,7,23,8],[23,10,23,13],[16,2,16,3],[16,5,16,6],[26,0,26,3],[26,5,26,8],[27,0,27,3],[27,5,27,8],[27,10,27,13]]}
["Contract Number:",null,"RR-19-1234",null,null,null,null,null,null,null,null,"Effective Date:","2019-09-01",null,null,null,"Y"]
["Type Of Contract (check box)",null,"DSE       CM ",null,null,null,null,null,null,null,null,"Year of PSB:",2018,null,null,null,"N",null,"Annual Increase"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Enter year Professional Services Bulletin was advertised)",null,null,null,null,null,"Deceased"]
["Prime Consultant Company Name:",null,"ABC Consulting, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name Change"]
["Sub-Consultant Company Name:",null,"XYZ Consulting, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Employee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Promotion - Title Change"]
[null,null,null,null,"These columns to be completed on all CRFs",null,null,null,"These columns to be completed starting with second CRF for contract",null,null,null,null,null,null,null,null,null,"Raise"]
["Employee Name \n(Alphabetically by Last Name)",null,"Consultant Classification/Title",null,"Original Hourly Rate at NTP or Promotion","Maximum Hourly Rate for Person/Title\n (calculated at 125% of original unless rate cap triggered based on PSB year)",null,"Previous/Current Hourly Rate \n(from CRF immediately preceding this one)","Updated Hourly Rate\n (updated rate paid to employee after increase or capped rate)","Percent Increase* ",null,"Reason for Change*\n(select from drop-down menu or type your own)",null,null,"Eligible for Premium Overtime?\n(Y/N)",null,null,null,"Remove Employee"]
["Last","First",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terminated"]
["Beard","Brad","Project Manager",null,70,{"$f":"IF(M$2>2017,E10*1.25,IF(M$2<2018,IF(E10*1.25>70,70,E10*1.25)))","v":87.5},null,70,null,{"$f":"IF(H10<1,\"\", IF((I10-H10)/H10>0,(I10-H10)/H10,\"\"))","v":""},null,null,null,null,"N"]
["Box","Jack","Engineer I",null,26,{"$f":"IF(M$2>2017,E11*1.25,IF(M$2<2018,IF(E11*1.25>70,70,E11*1.25)))","v":32.5},null,26,28,{"$f":"IF(H11<1,\"\", IF((I11-H11)/H11>0,(I11-H11)/H11,\"\"))","v":7.6923076923076927E-2},null,"Promotion - Title Change",null,null,"N"]
["Box","Jack","Engineer II",null,28,{"$f":"IF(M$2>2017,E12*1.25,IF(M$2<2018,IF(E12*1.25>70,70,E12*1.25)))","v":35},null,28,null,{"$f":"IF(H12<1,\"\", IF((I12-H12)/H12>0,(I12-H12)/H12,\"\"))","v":""},null,"New Title (new range)",null,null,"N"]
["Boy","Thomas","Doc Engineer",null,22,27.5,null,22,null,"",null,null,null,null,"Y"]
["Doe","John","Engineer II",null,35,43.75,null,35,null,"",null,null,null,null,"N"]
["Friend","Jane","Admin",null,19,23.75,null,19,null,"",null,null,null,null,"Y"]
["Shoe","James","RE",null,45,56.25,null,45,null,"",null,null,null,null,"N"]
[null,null,null,null,null,0,null,null,null,""]
[null,null,null,null,null,0,null,null,null,""]
["All hourly rates must be approved by the Illinois Tollway before payment can be made.  It is understood that an increase to the hourly rates will not result in an increase to the Upper Limit of Compensation."]
[]
["Consultant Certification:"]
["I certify, to the best of my knowledge, under penalty of perjury, that the hourly payroll rates identified above are a true and accurate reflection of actual hourly rates paid to personnel."]
[null,null,null,"Jane Friend",null,null,null,"jfriend@xyzconsulting.com",null,null,"773-588-2300"]
["Authorized Agent Signature",null,null,"Authorized Agent Printed Name",null,null,null,"Email Address",null,null,"Phone Number w/extension"]
[]
["Tollway Approval:"]
[]
["Tollway PM Signature",null,null,null,null,"Tollway PM Printed Name",null,null,null,null,"Date"]
[]
["*Increases 7% or greater per year, increases above Maximum Hourly Rate, or a promotion to new title all require a letter of explanation to the Deputy Chief."]
[]
[]
["Deputy Chief Signature",null,null,null,null,"Deputy Chief Printed Name",null,null,null,null,"Date"]