{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["START","FTE CALC","STF ALLOC","STF STRTGS","FTE Factors","DOT INPUT","FTE FactorsRV","DOT INPUTRV","FTE Review"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"START","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FTE CALC","index":1,"n_rows":27,"n_cols":27,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,1,3,6],[4,2,4,3],[4,4,4,5],[5,2,5,3],[5,4,5,5],[16,4,17,6],[7,2,7,3],[6,2,6,3],[6,4,6,5],[7,4,7,5],[14,4,15,6]]}
[]
[null,"Project Level FTE Calculator"]
[]
[null,"Project Description"]
[null,"Project Name","Anticipated Start Date",null,"Anticipated Completion Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Project Type","Construction Estimate",null,"Complexity",null,"Use of CEI",null,null,null,null,null,{"$f":"IF($M$6=1, \"FTE Factors\", \"DOT INPUT\")","v":"FTE Factors"}]
[]
[]
[null,"Project Level FTE "," Engineer","Surveyor","Admin Staff","Inspectors","Total Insp. Staff & Eng.",null,null,null,null,null,null,null,"Project Level FTE ","Resident Engineer","Surveyor","Admin Staff","Inspectors","Total Insp. Staff & RE",null,"Project Level FTE ","Resident Engineer","Surveyor","Admin Staff","Inspectors","Total Insp. Staff & RE"]
[null,"Minimum",{"$f":"IF($M$7=\"FTE Factors\", P11,W11)","v":{"$error":"#N/A"}},{"$f":"IF($M$7=\"FTE Factors\", Q11,X11)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"F11+C11","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Minimum",{"$f":"INDEX(('FTE Factors'!$I$7:$K$9,'FTE Factors'!$I$10:$K$12,'FTE Factors'!$I$13:$K$15,'FTE Factors'!$I$16:$K$18,'FTE Factors'!$I$19:$K$21, 'FTE Factors'!$I$22:$K$24), 'FTE Factors'!$W$6, 1,'FTE Factors'!$W$5)*'FTE Factors'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$L$7:$N$9,'FTE Factors'!$L$10:$N$12,'FTE Factors'!$L$13:$N$15,'FTE Factors'!$L$16:$N$18,'FTE Factors'!$L$19:$N$21,'FTE Factors'!$L$22:$N$24), 'FTE Factors'!$W$6, 1,'FTE Factors'!$W$5)*'FTE Factors'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$O$7:$Q$9,'FTE Factors'!$O$10:$Q$12,'FTE Factors'!$O$13:$Q$15,'FTE Factors'!$O$16:$Q$18,'FTE Factors'!$O$19:$Q$21,'FTE Factors'!$O$22:$Q$24), 'FTE Factors'!$W$6, 1,'FTE Factors'!$W$5)*'FTE Factors'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$R$7:$T$9,'FTE Factors'!$R$10:$T$12,'FTE Factors'!$R$13:$T$15,'FTE Factors'!$R$16:$T$18,'FTE Factors'!$R$19:$T$21,'FTE Factors'!$R$22:$T$24), 'FTE Factors'!$W$6, 1,'FTE Factors'!$W$5)*'FTE Factors'!$X$38","v":{"$error":"#N/A"}},{"$f":"S11+P11","v":{"$error":"#N/A"}},null,"Minimum",{"$f":"INDEX(('DOT INPUT'!$I$7:$K$9,'DOT INPUT'!$I$10:$K$12,'DOT INPUT'!$I$13:$K$15,'DOT INPUT'!$I$16:$K$18,'DOT INPUT'!$I$19:$K$21, 'DOT INPUT'!$I$22:$K$24), 'DOT INPUT'!$W$6, 1,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$L$7:$N$9,'DOT INPUT'!$L$10:$N$12,'DOT INPUT'!$L$13:$N$15,'DOT INPUT'!$L$16:$N$18,'DOT INPUT'!$L$19:$N$21,'DOT INPUT'!$L$22:$N$24), 'DOT INPUT'!$W$6, 1,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$O$7:$Q$9,'DOT INPUT'!$O$10:$Q$12,'DOT INPUT'!$O$13:$Q$15,'DOT INPUT'!$O$16:$Q$18,'DOT INPUT'!$O$19:$Q$21,'DOT INPUT'!$O$22:$Q$24), 'DOT INPUT'!$W$6, 1,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$R$7:$T$9,'DOT INPUT'!$R$10:$T$12,'DOT INPUT'!$R$13:$T$15,'DOT INPUT'!$R$16:$T$18,'DOT INPUT'!$R$19:$T$21,'DOT INPUT'!$R$22:$T$24), 'DOT INPUT'!$W$6, 1,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$38","v":{"$error":"#N/A"}},{"$f":"Z11+W11","v":{"$error":"#N/A"}}]
[null,"Average",{"$f":"IF($M$7=\"FTE Factors\", P12,W12)","v":{"$error":"#N/A"}},{"$f":"IF($M$7=\"FTE Factors\", Q12,X12)","v":{"$error":"#N/A"}},{"$f":"IF($M$7=\"FTE Factors\", R12,Y12)","v":{"$error":"#N/A"}},{"$f":"IF($M$7=\"FTE Factors\", S12,Z12)","v":{"$error":"#N/A"}},{"$f":"F12+C12","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Average",{"$f":"INDEX(('FTE Factors'!$I$7:$K$9,'FTE Factors'!$I$10:$K$12,'FTE Factors'!$I$13:$K$15,'FTE Factors'!$I$16:$K$18,'FTE Factors'!$I$19:$K$21, 'FTE Factors'!$I$22:$K$24), 'FTE Factors'!$W$6, 2,'FTE Factors'!$W$5)*'FTE Factors'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$L$7:$N$9,'FTE Factors'!$L$10:$N$12,'FTE Factors'!$L$13:$N$15,'FTE Factors'!$L$16:$N$18,'FTE Factors'!$L$19:$N$21,'FTE Factors'!$L$22:$N$24), 'FTE Factors'!$W$6, 2,'FTE Factors'!$W$5)*'FTE Factors'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$O$7:$Q$9,'FTE Factors'!$O$10:$Q$12,'FTE Factors'!$O$13:$Q$15,'FTE Factors'!$O$16:$Q$18,'FTE Factors'!$O$19:$Q$21,'FTE Factors'!$O$22:$Q$24), 'FTE Factors'!$W$6, 2,'FTE Factors'!$W$5)*'FTE Factors'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$R$7:$T$9,'FTE Factors'!$R$10:$T$12,'FTE Factors'!$R$13:$T$15,'FTE Factors'!$R$16:$T$18,'FTE Factors'!$R$19:$T$21,'FTE Factors'!$R$22:$T$24), 'FTE Factors'!$W$6, 2,'FTE Factors'!$W$5)*'FTE Factors'!$X$38","v":{"$error":"#N/A"}},{"$f":"S12+P12","v":{"$error":"#N/A"}},null,"Average",{"$f":"INDEX(('DOT INPUT'!$I$7:$K$9,'DOT INPUT'!$I$10:$K$12,'DOT INPUT'!$I$13:$K$15,'DOT INPUT'!$I$16:$K$18,'DOT INPUT'!$I$19:$K$21, 'DOT INPUT'!$I$22:$K$24), 'DOT INPUT'!$W$6, 2,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$L$7:$N$9,'DOT INPUT'!$L$10:$N$12,'DOT INPUT'!$L$13:$N$15,'DOT INPUT'!$L$16:$N$18,'DOT INPUT'!$L$19:$N$21,'DOT INPUT'!$L$22:$N$24), 'DOT INPUT'!$W$6, 2,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$O$7:$Q$9,'DOT INPUT'!$O$10:$Q$12,'DOT INPUT'!$O$13:$Q$15,'DOT INPUT'!$O$16:$Q$18,'DOT INPUT'!$O$19:$Q$21,'DOT INPUT'!$O$22:$Q$24), 'DOT INPUT'!$W$6, 2,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$R$7:$T$9,'DOT INPUT'!$R$10:$T$12,'DOT INPUT'!$R$13:$T$15,'DOT INPUT'!$R$16:$T$18,'DOT INPUT'!$R$19:$T$21,'DOT INPUT'!$R$22:$T$24), 'DOT INPUT'!$W$6, 2,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$38","v":{"$error":"#N/A"}},{"$f":"Z12+W12","v":{"$error":"#N/A"}}]
[null,"Maximum",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"F13+C13","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Maximum",{"$f":"INDEX(('FTE Factors'!$I$7:$K$9,'FTE Factors'!$I$10:$K$12,'FTE Factors'!$I$13:$K$15,'FTE Factors'!$I$16:$K$18,'FTE Factors'!$I$19:$K$21, 'FTE Factors'!$I$22:$K$24), 'FTE Factors'!$W$6, 3,'FTE Factors'!$W$5)*'FTE Factors'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$L$7:$N$9,'FTE Factors'!$L$10:$N$12,'FTE Factors'!$L$13:$N$15,'FTE Factors'!$L$16:$N$18,'FTE Factors'!$L$19:$N$21,'FTE Factors'!$L$22:$N$24), 'FTE Factors'!$W$6, 3,'FTE Factors'!$W$5)*'FTE Factors'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$O$7:$Q$9,'FTE Factors'!$O$10:$Q$12,'FTE Factors'!$O$13:$Q$15,'FTE Factors'!$O$16:$Q$18,'FTE Factors'!$O$19:$Q$21,'FTE Factors'!$O$22:$Q$24), 'FTE Factors'!$W$6, 3,'FTE Factors'!$W$5)*'FTE Factors'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE Factors'!$R$7:$T$9,'FTE Factors'!$R$10:$T$12,'FTE Factors'!$R$13:$T$15,'FTE Factors'!$R$16:$T$18,'FTE Factors'!$R$19:$T$21,'FTE Factors'!$R$22:$T$24), 'FTE Factors'!$W$6, 3,'FTE Factors'!$W$5)*'FTE Factors'!$X$38","v":{"$error":"#N/A"}},{"$f":"S13+P13","v":{"$error":"#N/A"}},null,"Maximum",{"$f":"INDEX(('DOT INPUT'!$I$7:$K$9,'DOT INPUT'!$I$10:$K$12,'DOT INPUT'!$I$13:$K$15,'DOT INPUT'!$I$16:$K$18,'DOT INPUT'!$I$19:$K$21, 'DOT INPUT'!$I$22:$K$24), 'DOT INPUT'!$W$6, 3,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$L$7:$N$9,'DOT INPUT'!$L$10:$N$12,'DOT INPUT'!$L$13:$N$15,'DOT INPUT'!$L$16:$N$18,'DOT INPUT'!$L$19:$N$21,'DOT INPUT'!$L$22:$N$24), 'DOT INPUT'!$W$6, 3,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$O$7:$Q$9,'DOT INPUT'!$O$10:$Q$12,'DOT INPUT'!$O$13:$Q$15,'DOT INPUT'!$O$16:$Q$18,'DOT INPUT'!$O$19:$Q$21,'DOT INPUT'!$O$22:$Q$24), 'DOT INPUT'!$W$6, 3,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUT'!$R$7:$T$9,'DOT INPUT'!$R$10:$T$12,'DOT INPUT'!$R$13:$T$15,'DOT INPUT'!$R$16:$T$18,'DOT INPUT'!$R$19:$T$21,'DOT INPUT'!$R$22:$T$24), 'DOT INPUT'!$W$6, 3,'DOT INPUT'!$W$5)*'DOT INPUT'!$X$38","v":{"$error":"#N/A"}},{"$f":"Z13+W13","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"Which dataset would you like to use for estimating staffing needs for this project?"]
[]
[]
[null,"Average FTE Requirement by Position and Project Type"]
[]
[null,"Project Type","Project Count ","Engineer","Surveyor","Sr. Inspector","Inter. Inspector","Jr. Inspector","Admin","Total Insp. Staff & Eng"]
[null,"Road - New Construction / Expansion",19,1.27,0.71,1.69,1.95,0.63,1.1599999999999999,{"$f":"SUM(D21,F21,G21,H21)","v":5.54}]
[null,"Road - Rehabilitation / Resurfacing",69,0.94,0.2,0.9,1.01,0.71,0.69,{"$f":"SUM(D22,F22,G22,H22)","v":3.5599999999999996}]
[null,"Bridge - New & Replacement",12,1.08,0.42,1.17,0.92,0.5,0.75,{"$f":"SUM(D23,F23,G23,H23)","v":3.67}]
[null,"Bridge - Rehabilitation",24,0.85,0.42,0.81,0.92,0.23,0.56999999999999995,2.81]
[null,"Other Projects",47,0.82,0.26,0.68,0.66,0.32,0.65,2.48]
[null,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",3,1,1.33,0.67,1.67,0.33,1.67,{"$f":"SUM(D26,F26,G26,H26)","v":3.67}]
[null,"All",{"$f":"SUM(C21:C26)","v":174},{"$f":"SUMPRODUCT($C$21:$C$26,D21:D26)/$C$27","v":0.94189655172413789},0.3368965517241379,0.92908045977011489,1.0108620689655172,0.50867816091954021,0.7350000000000001,3.3905172413793108]

{"sheet":"STF ALLOC","index":2,"n_rows":107,"n_cols":77,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["Program Level Staff Allocation",null,"","","","","","","","","","","",""]
["Program of Projects ",null,"","","","","Crew Available","","","","","","",{"$f":"$A$11+5","v":5},null,null,"Staff Allocation"]
[null,null,"","","","","Crew FTE Available",3,"Project # to Review","",1,"","Row",{"$f":"$K$3+5","v":6}]
[null,null,"","","","","","","","","","","","",null,null,"Eng FTE Req",{"$f":"SUM(R13,R19,R25,R31,R37,R43,R49,R55,R61,R67,R73,R79,R85,R91,R97,R103)","v":0},{"$f":"SUM(S13,S19,S25,S31,S37,S43,S49,S55,S61,S67,S73,S79,S85,S91,S97,S103)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Prioritization","Project Name","Project Type","Engineer FTE","Inspector FTE","FTE Required1","Start","Completion","","Project #","Estimate","Complexity","CEI",null,null,"Insp FTE Req",{"$f":"SUM(R14,R20,R26,R32,R38,R44,R50,R56,R62,R68,R74,R80,R86,R92,R98,R104)","v":0},{"$f":"SUM(S14,S20,S26,S32,S38,S44,S50,S56,S62,S68,S74,S80,S86,S92,S98,S104)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"FTE Required",{"$f":"SUM(R4:R5)","v":0},{"$f":"SUM(S4:S5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,"FTE Available",{"$f":"$H$3","v":3},{"$f":"$H$3","v":3},{"$f":"$H$3","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,"FTE Needs",{"$f":"IF(R6-R7<0,0,R6-R7)","v":0},{"$f":"IF(S6-S7<0,0,S6-S7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,"Year",{"$f":"MIN((IF($H$6:$H$103<>0,YEAR($H$6:$H$103))))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"R9+1","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD9+1","v":2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP9+1","v":3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BB9+1","v":4}]
["Project # to Clear",null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,"Month",1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,"Priority"]
[null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,1,{"$f":"IF(ISNA(VLOOKUP(P12,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P12,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P12,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P12,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q16,IF(DATE($R$9,R$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q16,IF(DATE($R$9,S$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q16,IF(DATE($AD$9,AD$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q16,IF(DATE($AD$9,AE$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q16,IF(DATE($AP$9,AP$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q16,IF(DATE($AP$9,AQ$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q16,IF(DATE($BB$9,BB$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q16,IF(DATE($BB$9,BC$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q16,IF(DATE($BN$9,BN$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q16,IF(DATE($BN$9,BO$10,1)<=$Q17,$Q13,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P12,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P12,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q16,IF(DATE($R$9,R$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q16,IF(DATE($R$9,S$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q16,IF(DATE($AD$9,AD$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q16,IF(DATE($AD$9,AE$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q16,IF(DATE($AP$9,AP$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q16,IF(DATE($AP$9,AQ$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q16,IF(DATE($BB$9,BB$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q16,IF(DATE($BB$9,BC$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q16,IF(DATE($BN$9,BN$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q16,IF(DATE($BN$9,BO$10,1)<=$Q17,$Q14,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P12,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P12,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q16,IF(DATE($R$9,R$10,1)<=$Q17,$Q15,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q16,IF(DATE($AD$9,AD$10,1)<=$Q17,$Q15,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q16,IF(DATE($AP$9,AP$10,1)<=$Q17,$Q15,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q16,IF(DATE($BB$9,BB$10,1)<=$Q17,$Q15,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q16,IF(DATE($BN$9,BN$10,1)<=$Q17,$Q15,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P12,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P12,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P12,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P12,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,2,{"$f":"IF(ISNA(VLOOKUP(P18,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P18,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P18,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P18,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q22,IF(DATE($R$9,R$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q22,IF(DATE($R$9,S$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q22,IF(DATE($AD$9,AD$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q22,IF(DATE($AD$9,AE$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q22,IF(DATE($AP$9,AP$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q22,IF(DATE($AP$9,AQ$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q22,IF(DATE($BB$9,BB$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q22,IF(DATE($BB$9,BC$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q22,IF(DATE($BN$9,BN$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q22,IF(DATE($BN$9,BO$10,1)<=$Q23,$Q19,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P18,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P18,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q22,IF(DATE($R$9,R$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q22,IF(DATE($R$9,S$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q22,IF(DATE($AD$9,AD$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q22,IF(DATE($AD$9,AE$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q22,IF(DATE($AP$9,AP$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q22,IF(DATE($AP$9,AQ$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q22,IF(DATE($BB$9,BB$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q22,IF(DATE($BB$9,BC$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q22,IF(DATE($BN$9,BN$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q22,IF(DATE($BN$9,BO$10,1)<=$Q23,$Q20,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P18,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P18,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q22,IF(DATE($R$9,R$10,1)<=$Q23,$Q21,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q22,IF(DATE($AD$9,AD$10,1)<=$Q23,$Q21,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q22,IF(DATE($AP$9,AP$10,1)<=$Q23,$Q21,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q22,IF(DATE($BB$9,BB$10,1)<=$Q23,$Q21,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q22,IF(DATE($BN$9,BN$10,1)<=$Q23,$Q21,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,17,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P18,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P18,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,18,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P18,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P18,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,19,null,null,null,null,3,{"$f":"IF(ISNA(VLOOKUP(P24,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P24,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,20,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P24,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P24,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q28,IF(DATE($R$9,R$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q28,IF(DATE($R$9,S$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q28,IF(DATE($AD$9,AD$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q28,IF(DATE($AD$9,AE$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q28,IF(DATE($AP$9,AP$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q28,IF(DATE($AP$9,AQ$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q28,IF(DATE($BB$9,BB$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q28,IF(DATE($BB$9,BC$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q28,IF(DATE($BN$9,BN$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q28,IF(DATE($BN$9,BO$10,1)<=$Q29,$Q25,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,21,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P24,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P24,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q28,IF(DATE($R$9,R$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q28,IF(DATE($R$9,S$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q28,IF(DATE($AD$9,AD$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q28,IF(DATE($AD$9,AE$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q28,IF(DATE($AP$9,AP$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q28,IF(DATE($AP$9,AQ$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q28,IF(DATE($BB$9,BB$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q28,IF(DATE($BB$9,BC$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q28,IF(DATE($BN$9,BN$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q28,IF(DATE($BN$9,BO$10,1)<=$Q29,$Q26,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,22,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P24,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P24,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q28,IF(DATE($R$9,R$10,1)<=$Q29,$Q27,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q28,IF(DATE($AD$9,AD$10,1)<=$Q29,$Q27,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q28,IF(DATE($AP$9,AP$10,1)<=$Q29,$Q27,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q28,IF(DATE($BB$9,BB$10,1)<=$Q29,$Q27,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q28,IF(DATE($BN$9,BN$10,1)<=$Q29,$Q27,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,23,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P24,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P24,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,24,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P24,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P24,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,25,null,null,null,null,4,{"$f":"IF(ISNA(VLOOKUP(P30,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P30,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,26,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P30,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P30,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q34,IF(DATE($R$9,R$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q34,IF(DATE($R$9,S$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q34,IF(DATE($AD$9,AD$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q34,IF(DATE($AD$9,AE$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q34,IF(DATE($AP$9,AP$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q34,IF(DATE($AP$9,AQ$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q34,IF(DATE($BB$9,BB$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q34,IF(DATE($BB$9,BC$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q34,IF(DATE($BN$9,BN$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q34,IF(DATE($BN$9,BO$10,1)<=$Q35,$Q31,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,27,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P30,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P30,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q34,IF(DATE($R$9,R$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q34,IF(DATE($R$9,S$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q34,IF(DATE($AD$9,AD$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q34,IF(DATE($AD$9,AE$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q34,IF(DATE($AP$9,AP$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q34,IF(DATE($AP$9,AQ$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q34,IF(DATE($BB$9,BB$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q34,IF(DATE($BB$9,BC$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q34,IF(DATE($BN$9,BN$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q34,IF(DATE($BN$9,BO$10,1)<=$Q35,$Q32,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,28,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P30,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P30,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q34,IF(DATE($R$9,R$10,1)<=$Q35,$Q33,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q34,IF(DATE($AD$9,AD$10,1)<=$Q35,$Q33,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q34,IF(DATE($AP$9,AP$10,1)<=$Q35,$Q33,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q34,IF(DATE($BB$9,BB$10,1)<=$Q35,$Q33,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q34,IF(DATE($BN$9,BN$10,1)<=$Q35,$Q33,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,29,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P30,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P30,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,30,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P30,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P30,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,31,null,null,null,null,5,{"$f":"IF(ISNA(VLOOKUP(P36,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P36,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,32,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P36,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P36,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q40,IF(DATE($R$9,R$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q40,IF(DATE($R$9,S$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q40,IF(DATE($AD$9,AD$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q40,IF(DATE($AD$9,AE$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q40,IF(DATE($AP$9,AP$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q40,IF(DATE($AP$9,AQ$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q40,IF(DATE($BB$9,BB$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q40,IF(DATE($BB$9,BC$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q40,IF(DATE($BN$9,BN$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q40,IF(DATE($BN$9,BO$10,1)<=$Q41,$Q37,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,33,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P36,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P36,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q40,IF(DATE($R$9,R$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q40,IF(DATE($R$9,S$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q40,IF(DATE($AD$9,AD$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q40,IF(DATE($AD$9,AE$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q40,IF(DATE($AP$9,AP$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q40,IF(DATE($AP$9,AQ$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q40,IF(DATE($BB$9,BB$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q40,IF(DATE($BB$9,BC$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q40,IF(DATE($BN$9,BN$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q40,IF(DATE($BN$9,BO$10,1)<=$Q41,$Q38,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,34,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P36,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P36,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q40,IF(DATE($R$9,R$10,1)<=$Q41,$Q39,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q40,IF(DATE($AD$9,AD$10,1)<=$Q41,$Q39,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q40,IF(DATE($AP$9,AP$10,1)<=$Q41,$Q39,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q40,IF(DATE($BB$9,BB$10,1)<=$Q41,$Q39,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q40,IF(DATE($BN$9,BN$10,1)<=$Q41,$Q39,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,35,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P36,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P36,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,36,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P36,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P36,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,37,null,null,null,null,6,{"$f":"IF(ISNA(VLOOKUP(P42,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P42,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,38,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P42,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P42,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q46,IF(DATE($R$9,R$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q46,IF(DATE($R$9,S$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q46,IF(DATE($AD$9,AD$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q46,IF(DATE($AD$9,AE$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q46,IF(DATE($AP$9,AP$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q46,IF(DATE($AP$9,AQ$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q46,IF(DATE($BB$9,BB$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q46,IF(DATE($BB$9,BC$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q46,IF(DATE($BN$9,BN$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q46,IF(DATE($BN$9,BO$10,1)<=$Q47,$Q43,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,39,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P42,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P42,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q46,IF(DATE($R$9,R$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q46,IF(DATE($R$9,S$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q46,IF(DATE($AD$9,AD$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q46,IF(DATE($AD$9,AE$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q46,IF(DATE($AP$9,AP$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q46,IF(DATE($AP$9,AQ$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q46,IF(DATE($BB$9,BB$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q46,IF(DATE($BB$9,BC$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q46,IF(DATE($BN$9,BN$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q46,IF(DATE($BN$9,BO$10,1)<=$Q47,$Q44,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,40,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P42,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P42,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q46,IF(DATE($R$9,R$10,1)<=$Q47,$Q45,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q46,IF(DATE($AD$9,AD$10,1)<=$Q47,$Q45,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q46,IF(DATE($AP$9,AP$10,1)<=$Q47,$Q45,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q46,IF(DATE($BB$9,BB$10,1)<=$Q47,$Q45,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q46,IF(DATE($BN$9,BN$10,1)<=$Q47,$Q45,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,41,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P42,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P42,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,42,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P42,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P42,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,43,null,null,null,null,7,{"$f":"IF(ISNA(VLOOKUP(P48,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P48,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,44,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P48,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P48,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q52,IF(DATE($R$9,R$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q52,IF(DATE($R$9,S$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q52,IF(DATE($AD$9,AD$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q52,IF(DATE($AD$9,AE$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q52,IF(DATE($AP$9,AP$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q52,IF(DATE($AP$9,AQ$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q52,IF(DATE($BB$9,BB$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q52,IF(DATE($BB$9,BC$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q52,IF(DATE($BN$9,BN$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q52,IF(DATE($BN$9,BO$10,1)<=$Q53,$Q49,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,45,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P48,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P48,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q52,IF(DATE($R$9,R$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q52,IF(DATE($R$9,S$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q52,IF(DATE($AD$9,AD$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q52,IF(DATE($AD$9,AE$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q52,IF(DATE($AP$9,AP$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q52,IF(DATE($AP$9,AQ$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q52,IF(DATE($BB$9,BB$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q52,IF(DATE($BB$9,BC$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q52,IF(DATE($BN$9,BN$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q52,IF(DATE($BN$9,BO$10,1)<=$Q53,$Q50,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,46,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P48,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P48,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q52,IF(DATE($R$9,R$10,1)<=$Q53,$Q51,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q52,IF(DATE($AD$9,AD$10,1)<=$Q53,$Q51,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q52,IF(DATE($AP$9,AP$10,1)<=$Q53,$Q51,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q52,IF(DATE($BB$9,BB$10,1)<=$Q53,$Q51,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q52,IF(DATE($BN$9,BN$10,1)<=$Q53,$Q51,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,47,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P48,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P48,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,48,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P48,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P48,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,49,null,null,null,null,8,{"$f":"IF(ISNA(VLOOKUP(P54,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P54,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P54,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P54,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q58,IF(DATE($R$9,R$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q58,IF(DATE($R$9,S$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q58,IF(DATE($AD$9,AD$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q58,IF(DATE($AD$9,AE$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q58,IF(DATE($AP$9,AP$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q58,IF(DATE($AP$9,AQ$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q58,IF(DATE($BB$9,BB$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q58,IF(DATE($BB$9,BC$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q58,IF(DATE($BN$9,BN$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q58,IF(DATE($BN$9,BO$10,1)<=$Q59,$Q55,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,51,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P54,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P54,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q58,IF(DATE($R$9,R$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q58,IF(DATE($R$9,S$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q58,IF(DATE($AD$9,AD$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q58,IF(DATE($AD$9,AE$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q58,IF(DATE($AP$9,AP$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q58,IF(DATE($AP$9,AQ$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q58,IF(DATE($BB$9,BB$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q58,IF(DATE($BB$9,BC$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q58,IF(DATE($BN$9,BN$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q58,IF(DATE($BN$9,BO$10,1)<=$Q59,$Q56,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,52,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P54,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P54,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q58,IF(DATE($R$9,R$10,1)<=$Q59,$Q57,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q58,IF(DATE($AD$9,AD$10,1)<=$Q59,$Q57,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q58,IF(DATE($AP$9,AP$10,1)<=$Q59,$Q57,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q58,IF(DATE($BB$9,BB$10,1)<=$Q59,$Q57,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q58,IF(DATE($BN$9,BN$10,1)<=$Q59,$Q57,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,53,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P54,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P54,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,54,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P54,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P54,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,55,null,null,null,null,9,{"$f":"IF(ISNA(VLOOKUP(P60,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P60,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,56,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P60,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P60,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q64,IF(DATE($R$9,R$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q64,IF(DATE($R$9,S$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q64,IF(DATE($AD$9,AD$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q64,IF(DATE($AD$9,AE$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q64,IF(DATE($AP$9,AP$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q64,IF(DATE($AP$9,AQ$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q64,IF(DATE($BB$9,BB$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q64,IF(DATE($BB$9,BC$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q64,IF(DATE($BN$9,BN$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q64,IF(DATE($BN$9,BO$10,1)<=$Q65,$Q61,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,57,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P60,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P60,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q64,IF(DATE($R$9,R$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q64,IF(DATE($R$9,S$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q64,IF(DATE($AD$9,AD$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q64,IF(DATE($AD$9,AE$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q64,IF(DATE($AP$9,AP$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q64,IF(DATE($AP$9,AQ$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q64,IF(DATE($BB$9,BB$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q64,IF(DATE($BB$9,BC$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q64,IF(DATE($BN$9,BN$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q64,IF(DATE($BN$9,BO$10,1)<=$Q65,$Q62,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,58,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P60,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P60,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q64,IF(DATE($R$9,R$10,1)<=$Q65,$Q63,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q64,IF(DATE($AD$9,AD$10,1)<=$Q65,$Q63,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q64,IF(DATE($AP$9,AP$10,1)<=$Q65,$Q63,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q64,IF(DATE($BB$9,BB$10,1)<=$Q65,$Q63,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q64,IF(DATE($BN$9,BN$10,1)<=$Q65,$Q63,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,59,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P60,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P60,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,60,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P60,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P60,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,61,null,null,null,null,10,{"$f":"IF(ISNA(VLOOKUP(P66,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P66,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,62,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P66,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P66,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q70,IF(DATE($R$9,R$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q70,IF(DATE($R$9,S$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q70,IF(DATE($AD$9,AD$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q70,IF(DATE($AD$9,AE$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q70,IF(DATE($AP$9,AP$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q70,IF(DATE($AP$9,AQ$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q70,IF(DATE($BB$9,BB$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q70,IF(DATE($BB$9,BC$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q70,IF(DATE($BN$9,BN$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q70,IF(DATE($BN$9,BO$10,1)<=$Q71,$Q67,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,63,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P66,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P66,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q70,IF(DATE($R$9,R$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q70,IF(DATE($R$9,S$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q70,IF(DATE($AD$9,AD$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q70,IF(DATE($AD$9,AE$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q70,IF(DATE($AP$9,AP$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q70,IF(DATE($AP$9,AQ$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q70,IF(DATE($BB$9,BB$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q70,IF(DATE($BB$9,BC$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q70,IF(DATE($BN$9,BN$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q70,IF(DATE($BN$9,BO$10,1)<=$Q71,$Q68,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,64,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P66,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P66,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q70,IF(DATE($R$9,R$10,1)<=$Q71,$Q69,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q70,IF(DATE($AD$9,AD$10,1)<=$Q71,$Q69,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q70,IF(DATE($AP$9,AP$10,1)<=$Q71,$Q69,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q70,IF(DATE($BB$9,BB$10,1)<=$Q71,$Q69,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q70,IF(DATE($BN$9,BN$10,1)<=$Q71,$Q69,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,65,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P66,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P66,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,66,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P66,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P66,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,67,null,null,null,null,11,{"$f":"IF(ISNA(VLOOKUP(P72,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P72,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,68,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P72,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P72,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q76,IF(DATE($R$9,R$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q76,IF(DATE($R$9,S$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q76,IF(DATE($AD$9,AD$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q76,IF(DATE($AD$9,AE$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q76,IF(DATE($AP$9,AP$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q76,IF(DATE($AP$9,AQ$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q76,IF(DATE($BB$9,BB$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q76,IF(DATE($BB$9,BC$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q76,IF(DATE($BN$9,BN$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q76,IF(DATE($BN$9,BO$10,1)<=$Q77,$Q73,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,69,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P72,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P72,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q76,IF(DATE($R$9,R$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q76,IF(DATE($R$9,S$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q76,IF(DATE($AD$9,AD$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q76,IF(DATE($AD$9,AE$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q76,IF(DATE($AP$9,AP$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q76,IF(DATE($AP$9,AQ$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q76,IF(DATE($BB$9,BB$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q76,IF(DATE($BB$9,BC$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q76,IF(DATE($BN$9,BN$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q76,IF(DATE($BN$9,BO$10,1)<=$Q77,$Q74,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,70,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P72,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P72,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q76,IF(DATE($R$9,R$10,1)<=$Q77,$Q75,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q76,IF(DATE($AD$9,AD$10,1)<=$Q77,$Q75,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q76,IF(DATE($AP$9,AP$10,1)<=$Q77,$Q75,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q76,IF(DATE($BB$9,BB$10,1)<=$Q77,$Q75,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q76,IF(DATE($BN$9,BN$10,1)<=$Q77,$Q75,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,71,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P72,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P72,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,72,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P72,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P72,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,73,null,null,null,null,12,{"$f":"IF(ISNA(VLOOKUP(P78,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P78,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,74,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P78,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P78,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q82,IF(DATE($R$9,R$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q82,IF(DATE($R$9,S$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q82,IF(DATE($AD$9,AD$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q82,IF(DATE($AD$9,AE$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q82,IF(DATE($AP$9,AP$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q82,IF(DATE($AP$9,AQ$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q82,IF(DATE($BB$9,BB$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q82,IF(DATE($BB$9,BC$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q82,IF(DATE($BN$9,BN$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q82,IF(DATE($BN$9,BO$10,1)<=$Q83,$Q79,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,75,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P78,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P78,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q82,IF(DATE($R$9,R$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q82,IF(DATE($R$9,S$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q82,IF(DATE($AD$9,AD$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q82,IF(DATE($AD$9,AE$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q82,IF(DATE($AP$9,AP$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q82,IF(DATE($AP$9,AQ$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q82,IF(DATE($BB$9,BB$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q82,IF(DATE($BB$9,BC$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q82,IF(DATE($BN$9,BN$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q82,IF(DATE($BN$9,BO$10,1)<=$Q83,$Q80,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,76,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P78,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P78,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q82,IF(DATE($R$9,R$10,1)<=$Q83,$Q81,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q82,IF(DATE($AD$9,AD$10,1)<=$Q83,$Q81,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q82,IF(DATE($AP$9,AP$10,1)<=$Q83,$Q81,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q82,IF(DATE($BB$9,BB$10,1)<=$Q83,$Q81,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q82,IF(DATE($BN$9,BN$10,1)<=$Q83,$Q81,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,77,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P78,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P78,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,78,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P78,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P78,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,79,null,null,null,null,13,{"$f":"IF(ISNA(VLOOKUP(P84,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P84,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,80,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P84,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P84,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q88,IF(DATE($R$9,R$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q88,IF(DATE($R$9,S$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q88,IF(DATE($AD$9,AD$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q88,IF(DATE($AD$9,AE$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q88,IF(DATE($AP$9,AP$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q88,IF(DATE($AP$9,AQ$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q88,IF(DATE($BB$9,BB$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q88,IF(DATE($BB$9,BC$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q88,IF(DATE($BN$9,BN$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q88,IF(DATE($BN$9,BO$10,1)<=$Q89,$Q85,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,81,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P84,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P84,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q88,IF(DATE($R$9,R$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q88,IF(DATE($R$9,S$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q88,IF(DATE($AD$9,AD$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q88,IF(DATE($AD$9,AE$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q88,IF(DATE($AP$9,AP$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q88,IF(DATE($AP$9,AQ$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q88,IF(DATE($BB$9,BB$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q88,IF(DATE($BB$9,BC$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q88,IF(DATE($BN$9,BN$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q88,IF(DATE($BN$9,BO$10,1)<=$Q89,$Q86,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,82,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P84,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P84,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q88,IF(DATE($R$9,R$10,1)<=$Q89,$Q87,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q88,IF(DATE($AD$9,AD$10,1)<=$Q89,$Q87,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q88,IF(DATE($AP$9,AP$10,1)<=$Q89,$Q87,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q88,IF(DATE($BB$9,BB$10,1)<=$Q89,$Q87,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q88,IF(DATE($BN$9,BN$10,1)<=$Q89,$Q87,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,83,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P84,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P84,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,84,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P84,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P84,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,85,null,null,null,null,14,{"$f":"IF(ISNA(VLOOKUP(P90,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P90,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,86,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P90,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P90,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q94,IF(DATE($R$9,R$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q94,IF(DATE($R$9,S$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q94,IF(DATE($AD$9,AD$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q94,IF(DATE($AD$9,AE$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q94,IF(DATE($AP$9,AP$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q94,IF(DATE($AP$9,AQ$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q94,IF(DATE($BB$9,BB$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q94,IF(DATE($BB$9,BC$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q94,IF(DATE($BN$9,BN$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q94,IF(DATE($BN$9,BO$10,1)<=$Q95,$Q91,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,87,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P90,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P90,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q94,IF(DATE($R$9,R$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q94,IF(DATE($R$9,S$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q94,IF(DATE($AD$9,AD$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q94,IF(DATE($AD$9,AE$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q94,IF(DATE($AP$9,AP$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q94,IF(DATE($AP$9,AQ$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q94,IF(DATE($BB$9,BB$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q94,IF(DATE($BB$9,BC$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q94,IF(DATE($BN$9,BN$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q94,IF(DATE($BN$9,BO$10,1)<=$Q95,$Q92,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,88,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P90,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P90,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q94,IF(DATE($R$9,R$10,1)<=$Q95,$Q93,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q94,IF(DATE($AD$9,AD$10,1)<=$Q95,$Q93,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q94,IF(DATE($AP$9,AP$10,1)<=$Q95,$Q93,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q94,IF(DATE($BB$9,BB$10,1)<=$Q95,$Q93,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q94,IF(DATE($BN$9,BN$10,1)<=$Q95,$Q93,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,89,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P90,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P90,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,90,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P90,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P90,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,91,null,null,null,null,15,{"$f":"IF(ISNA(VLOOKUP(P96,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P96,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,92,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P96,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P96,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q100,IF(DATE($R$9,R$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q100,IF(DATE($R$9,S$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q100,IF(DATE($AD$9,AD$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q100,IF(DATE($AD$9,AE$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q100,IF(DATE($AP$9,AP$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q100,IF(DATE($AP$9,AQ$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q100,IF(DATE($BB$9,BB$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q100,IF(DATE($BB$9,BC$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q100,IF(DATE($BN$9,BN$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q100,IF(DATE($BN$9,BO$10,1)<=$Q101,$Q97,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,93,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P96,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P96,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q100,IF(DATE($R$9,R$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q100,IF(DATE($R$9,S$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q100,IF(DATE($AD$9,AD$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q100,IF(DATE($AD$9,AE$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q100,IF(DATE($AP$9,AP$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q100,IF(DATE($AP$9,AQ$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q100,IF(DATE($BB$9,BB$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q100,IF(DATE($BB$9,BC$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q100,IF(DATE($BN$9,BN$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q100,IF(DATE($BN$9,BO$10,1)<=$Q101,$Q98,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,94,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P96,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P96,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q100,IF(DATE($R$9,R$10,1)<=$Q101,$Q99,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q100,IF(DATE($AD$9,AD$10,1)<=$Q101,$Q99,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q100,IF(DATE($AP$9,AP$10,1)<=$Q101,$Q99,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q100,IF(DATE($BB$9,BB$10,1)<=$Q101,$Q99,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q100,IF(DATE($BN$9,BN$10,1)<=$Q101,$Q99,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,95,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P96,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P96,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,96,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P96,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P96,$B$6:$I$103,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,97,null,null,null,null,16,{"$f":"IF(ISNA(VLOOKUP(P102,$B$6:$I$103,2,FALSE)),\"\",VLOOKUP(P102,$B$6:$I$103,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,98,null,null,null,null,"Eng Needs",{"$f":"IF(ISNA(VLOOKUP(P102,$B$6:$I$103,4,FALSE)),\"\",VLOOKUP(P102,$B$6:$I$103,4,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q106,IF(DATE($R$9,R$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q106,IF(DATE($R$9,S$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q106,IF(DATE($AD$9,AD$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q106,IF(DATE($AD$9,AE$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q106,IF(DATE($AP$9,AP$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q106,IF(DATE($AP$9,AQ$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q106,IF(DATE($BB$9,BB$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q106,IF(DATE($BB$9,BC$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q106,IF(DATE($BN$9,BN$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q106,IF(DATE($BN$9,BO$10,1)<=$Q107,$Q103,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insp Needs",{"$f":"IF(ISNA(VLOOKUP(P102,$B$6:$I$103,5,FALSE)),\"\",VLOOKUP(P102,$B$6:$I$103,5,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q106,IF(DATE($R$9,R$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},{"$f":"IF(DATE($R$9,S$10,1)>=$Q106,IF(DATE($R$9,S$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q106,IF(DATE($AD$9,AD$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},{"$f":"IF(DATE($AD$9,AE$10,1)>=$Q106,IF(DATE($AD$9,AE$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q106,IF(DATE($AP$9,AP$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},{"$f":"IF(DATE($AP$9,AQ$10,1)>=$Q106,IF(DATE($AP$9,AQ$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q106,IF(DATE($BB$9,BB$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},{"$f":"IF(DATE($BB$9,BC$10,1)>=$Q106,IF(DATE($BB$9,BC$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},"","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q106,IF(DATE($BN$9,BN$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},{"$f":"IF(DATE($BN$9,BO$10,1)>=$Q106,IF(DATE($BN$9,BO$10,1)<=$Q107,$Q104,\"\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FTE Needs",{"$f":"IF(ISNA(VLOOKUP(P102,$B$6:$I$103,6,FALSE)),\"\",VLOOKUP(P102,$B$6:$I$103,6,FALSE))","v":""},{"$f":"IF(DATE($R$9,R$10,1)>=$Q106,IF(DATE($R$9,R$10,1)<=$Q107,$Q105,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AD$9,AD$10,1)>=$Q106,IF(DATE($AD$9,AD$10,1)<=$Q107,$Q105,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($AP$9,AP$10,1)>=$Q106,IF(DATE($AP$9,AP$10,1)<=$Q107,$Q105,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BB$9,BB$10,1)>=$Q106,IF(DATE($BB$9,BB$10,1)<=$Q107,$Q105,\"\"),\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(DATE($BN$9,BN$10,1)>=$Q106,IF(DATE($BN$9,BN$10,1)<=$Q107,$Q105,\"\"),\"\")","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",{"$f":"IF(ISNA(VLOOKUP(P102,$B$6:$I$103,7,FALSE)),\"\",VLOOKUP(P102,$B$6:$I$103,7,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete",{"$f":"IF(ISNA(VLOOKUP(P102,$B$6:$I$103,8,FALSE)),\"\",VLOOKUP(P102,$B$6:$I$103,8,FALSE))","v":""}]

{"sheet":"STF STRTGS","index":3,"n_rows":80,"n_cols":51,"rows_kept":80,"cut":false,"hidden":false,"merged":[[2,35,3,35],[1,9,1,10],[21,9,21,10],[2,13,3,13],[2,15,3,15],[2,17,3,17],[2,19,3,19],[2,23,3,23],[2,25,3,25],[2,27,3,27],[2,29,3,29],[2,31,3,31],[2,33,3,33],[2,21,3,21],[1,13,1,35],[22,37,23,37],[41,9,41,10],[21,13,21,37],[22,13,23,13],[22,15,23,15],[22,17,23,17],[22,19,23,19],[22,21,23,21],[22,23,23,23],[22,25,23,25],[22,27,23,27],[41,13,41,49],[42,25,43,25],[22,29,23,29],[22,31,23,31],[22,33,23,33],[22,35,23,35],[42,13,43,13],[42,15,43,15],[42,17,43,17],[42,19,43,19],[42,23,43,23],[42,21,43,21],[42,49,43,49],[42,27,43,27],[42,29,43,29],[42,31,43,31],[42,33,43,33],[42,35,43,35],[42,37,43,37],[42,39,43,39],[42,41,43,41],[42,43,43,43],[42,45,43,45],[42,47,43,47],[63,9,63,10],[63,13,63,27],[64,13,65,13],[64,15,65,15],[64,17,65,17],[64,19,65,19],[64,21,65,21],[64,23,65,23],[64,25,65,25],[64,27,65,27]]}
[]
[null,"Your maximum staffing deficit is:",{"$f":"MAX('STF ALLOC'!R8:BY8)","v":0},null,null,null,null,null,"Potential Tool Applicability","Construction Administration (A)",null,null,"Construction Staff Function","Construction Administration (A)"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,O5:O18)/SUM($D$5:$D$18)","v":0},"A-1","Accelerated Construction Methods",null,"                             Strategy (Tool)","A-1",null,"A-2",null,"A-2-1",null,"A-2-2",null,"A-2-3",null,"A-3",null,"A-3-1",null,"A-3-2",null,"A-3-3",null,"A-3-4",null,"A-4",null,"A-5"]
[null,"Work Type Survey ","Applicable?",null,"Risk Level",null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,Q5:Q18)/SUM($D$5:$D$18)","v":0},"A-2/I-2","Contract Requirements",null,"Work Type"]
[null,"Pavement Surface","Yes",{"$f":"IF(C5=\"Yes\", 1,0)","v":1},null,{"$f":"IF(E5=\"High\",3,IF(E5=\"Medium\",2,IF(E5=\"Low\",1,0)))","v":0},{"$f":"D5*F5","v":0},null,{"$f":"SUMPRODUCT($G$5:$G$18,S5:S18)/SUM($D$5:$D$18)","v":0},"A-2-1/I-2-1","     Operations & Maintenance (by Contractor)",null,"Pavement Surface","★",{"$f":"IF(N5=\"★\",2,IF(N5=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P5=\"★\",2,IF(P5=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R5=\"★\",2,IF(R5=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T5=\"★\",2,IF(T5=\"☆\",1,0))","v":1},"☆",{"$f":"IF(V5=\"★\",2,IF(V5=\"☆\",1,0))","v":1},"☆",{"$f":"IF(X5=\"★\",2,IF(X5=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z5=\"★\",2,IF(Z5=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB5=\"★\",2,IF(AB5=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD5=\"★\",2,IF(AD5=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AF5=\"★\",2,IF(AF5=\"☆\",1,0))","v":1},"★",{"$f":"IF(AH5=\"★\",2,IF(AH5=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ5=\"★\",2,IF(AJ5=\"☆\",1,0))","v":2}]
[null,"Superstructure",null,{"$f":"IF(C6=\"Yes\", 1,0)","v":0},null,{"$f":"IF(E6=\"High\",3,IF(E6=\"Medium\",2,IF(E6=\"Low\",1,0)))","v":0},{"$f":"D6*F6","v":0},null,{"$f":"SUMPRODUCT($G$5:$G$18,U5:U18)/SUM($D$5:$D$18)","v":0},"A-2-2/I-2-2","     Warranty",null,"Superstructure","★",{"$f":"IF(N6=\"★\",2,IF(N6=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(R6=\"★\",2,IF(R6=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T6=\"★\",2,IF(T6=\"☆\",1,0))","v":1},"☆",{"$f":"IF(V6=\"★\",2,IF(V6=\"☆\",1,0))","v":1},"☆",{"$f":"IF(X6=\"★\",2,IF(X6=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z6=\"★\",2,IF(Z6=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB6=\"★\",2,IF(AB6=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD6=\"★\",2,IF(AD6=\"☆\",1,0))","v":1},"★",{"$f":"IF(AF6=\"★\",2,IF(AF6=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH6=\"★\",2,IF(AH6=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AJ6=\"★\",2,IF(AJ6=\"☆\",1,0))","v":1}]
[null,"Excavation / Embankment",null,0,null,0,0,null,{"$f":"SUMPRODUCT($G$5:$G$18,W5:W18)/SUM($D$5:$D$18)","v":0},"A-2-3/I-2-3","     Performance Based Specifications",null,"Excavation / Embankment","★",2,"☆",1,null,{"$f":"IF(R7=\"★\",2,IF(R7=\"☆\",1,0))","v":0},null,{"$f":"IF(T7=\"★\",2,IF(T7=\"☆\",1,0))","v":0},"☆",1,"☆",{"$f":"IF(X7=\"★\",2,IF(X7=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z7=\"★\",2,IF(Z7=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB7=\"★\",2,IF(AB7=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD7=\"★\",2,IF(AD7=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AF7=\"★\",2,IF(AF7=\"☆\",1,0))","v":1},"★",{"$f":"IF(AH7=\"★\",2,IF(AH7=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AJ7=\"★\",2,IF(AJ7=\"☆\",1,0))","v":1}]
[null,"Pipe / Drainage",null,0,null,0,0,null,{"$f":"SUMPRODUCT($G$5:$G$18,Y5:Y18)/SUM($D$5:$D$18)","v":0},"A-3","Electronic Business Processes",null,"Pipe / Drainage","☆",1,"★",2,"★",{"$f":"IF(R8=\"★\",2,IF(R8=\"☆\",1,0))","v":2},"★",{"$f":"IF(T8=\"★\",2,IF(T8=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X8=\"★\",2,IF(X8=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z8=\"★\",2,IF(Z8=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB8=\"★\",2,IF(AB8=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD8=\"★\",2,IF(AD8=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AF8=\"★\",2,IF(AF8=\"☆\",1,0))","v":1},"★",{"$f":"IF(AH8=\"★\",2,IF(AH8=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AJ8=\"★\",2,IF(AJ8=\"☆\",1,0))","v":1}]
[null,"Roadway Base",null,0,null,0,0,null,{"$f":"SUMPRODUCT($G$5:$G$18,AA5:AA18)/SUM($D$5:$D$18)","v":0},"A-3-1","     Change Orders",null,"Roadway Base","★",2,"★",2,"★",{"$f":"IF(R9=\"★\",2,IF(R9=\"☆\",1,0))","v":2},"★",{"$f":"IF(T9=\"★\",2,IF(T9=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X9=\"★\",2,IF(X9=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z9=\"★\",2,IF(Z9=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB9=\"★\",2,IF(AB9=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD9=\"★\",2,IF(AD9=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AF9=\"★\",2,IF(AF9=\"☆\",1,0))","v":1},"★",{"$f":"IF(AH9=\"★\",2,IF(AH9=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AJ9=\"★\",2,IF(AJ9=\"☆\",1,0))","v":1}]
[null,"Pavement Base",null,0,null,0,0,null,{"$f":"SUMPRODUCT($G$5:$G$18,AC5:AC18)/SUM($D$5:$D$18)","v":0},"A-3-2","     Document Storage/Management/Work Flow",null,"Pavement Base","★",2,"★",2,"★",{"$f":"IF(R10=\"★\",2,IF(R10=\"☆\",1,0))","v":2},"★",{"$f":"IF(T10=\"★\",2,IF(T10=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X10=\"★\",2,IF(X10=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z10=\"★\",2,IF(Z10=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB10=\"★\",2,IF(AB10=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD10=\"★\",2,IF(AD10=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AF10=\"★\",2,IF(AF10=\"☆\",1,0))","v":1},"★",{"$f":"IF(AH10=\"★\",2,IF(AH10=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AJ10=\"★\",2,IF(AJ10=\"☆\",1,0))","v":1}]
[null,"Substructure",null,0,null,0,0,null,{"$f":"SUMPRODUCT($G$5:$G$18,AE5:AE18)/SUM($D$5:$D$18)","v":0},"A-3-3","     e-Signature",null,"Substructure","★",2,"☆",1,"☆",{"$f":"IF(R11=\"★\",2,IF(R11=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T11=\"★\",2,IF(T11=\"☆\",1,0))","v":1},"☆",1,"☆",{"$f":"IF(X11=\"★\",2,IF(X11=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z11=\"★\",2,IF(Z11=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB11=\"★\",2,IF(AB11=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD11=\"★\",2,IF(AD11=\"☆\",1,0))","v":1},"★",{"$f":"IF(AF11=\"★\",2,IF(AF11=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH11=\"★\",2,IF(AH11=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AJ11=\"★\",2,IF(AJ11=\"☆\",1,0))","v":1}]
[null,"Temporary Traffic Control",null,0,null,0,0,null,{"$f":"SUMPRODUCT($G$5:$G$18,AG5:AG18)/SUM($D$5:$D$18)","v":0},"A-3-4","     Electronic RFI",null,"Temporary Traffic Control","☆",1,null,0,null,{"$f":"IF(R12=\"★\",2,IF(R12=\"☆\",1,0))","v":0},null,{"$f":"IF(T12=\"★\",2,IF(T12=\"☆\",1,0))","v":0},"☆",1,"☆",{"$f":"IF(X12=\"★\",2,IF(X12=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z12=\"★\",2,IF(Z12=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB12=\"★\",2,IF(AB12=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD12=\"★\",2,IF(AD12=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AF12=\"★\",2,IF(AF12=\"☆\",1,0))","v":1},"★",{"$f":"IF(AH12=\"★\",2,IF(AH12=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ12=\"★\",2,IF(AJ12=\"☆\",1,0))","v":2}]
[null,"Structural Foundation",null,0,null,0,0,null,{"$f":"SUMPRODUCT($G$5:$G$18,AI5:AI18)/SUM($D$5:$D$18)","v":0},"A-4/E-4/I-4","Electronic Field Books",null,"Structural Foundation","★",2,"☆",1,"☆",{"$f":"IF(R13=\"★\",2,IF(R13=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T13=\"★\",2,IF(T13=\"☆\",1,0))","v":1},"☆",1,"☆",{"$f":"IF(X13=\"★\",2,IF(X13=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z13=\"★\",2,IF(Z13=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB13=\"★\",2,IF(AB13=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD13=\"★\",2,IF(AD13=\"☆\",1,0))","v":1},"★",{"$f":"IF(AF13=\"★\",2,IF(AF13=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH13=\"★\",2,IF(AH13=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AJ13=\"★\",2,IF(AJ13=\"☆\",1,0))","v":1}]
[null,"Strips / Signs / Signals",null,0,null,0,0,null,{"$f":"SUMPRODUCT($G$5:$G$18,AK5:AK18)/SUM($D$5:$D$18)","v":0},"A-5","Geographic Information Systems (GIS)",null,"Strips / Signs / Signals","☆",1,null,0,null,{"$f":"IF(R14=\"★\",2,IF(R14=\"☆\",1,0))","v":0},null,{"$f":"IF(T14=\"★\",2,IF(T14=\"☆\",1,0))","v":0},"☆",1,"☆",{"$f":"IF(X14=\"★\",2,IF(X14=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z14=\"★\",2,IF(Z14=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB14=\"★\",2,IF(AB14=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD14=\"★\",2,IF(AD14=\"☆\",1,0))","v":1},"★",{"$f":"IF(AF14=\"★\",2,IF(AF14=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH14=\"★\",2,IF(AH14=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ14=\"★\",2,IF(AJ14=\"☆\",1,0))","v":2}]
[null,"Roadside",null,0,null,0,0,null,null,null,null,null,"Roadside",null,0,null,0,null,{"$f":"IF(R15=\"★\",2,IF(R15=\"☆\",1,0))","v":0},null,{"$f":"IF(T15=\"★\",2,IF(T15=\"☆\",1,0))","v":0},"☆",1,"☆",{"$f":"IF(X15=\"★\",2,IF(X15=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z15=\"★\",2,IF(Z15=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB15=\"★\",2,IF(AB15=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD15=\"★\",2,IF(AD15=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AF15=\"★\",2,IF(AF15=\"☆\",1,0))","v":1},"★",{"$f":"IF(AH15=\"★\",2,IF(AH15=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ15=\"★\",2,IF(AJ15=\"☆\",1,0))","v":2}]
[null,"Utilities (In contract relocations)",null,0,null,0,0,null,null,null,null,null,"Utilities (In contract relocations)","☆",1,"★",2,"★",{"$f":"IF(R16=\"★\",2,IF(R16=\"☆\",1,0))","v":2},"★",{"$f":"IF(T16=\"★\",2,IF(T16=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X16=\"★\",2,IF(X16=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z16=\"★\",2,IF(Z16=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB16=\"★\",2,IF(AB16=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD16=\"★\",2,IF(AD16=\"☆\",1,0))","v":1},"★",{"$f":"IF(AF16=\"★\",2,IF(AF16=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH16=\"★\",2,IF(AH16=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ16=\"★\",2,IF(AJ16=\"☆\",1,0))","v":2}]
[null,"Roadway Lighting",null,0,null,0,0,null,null,null,null,null,"Roadway Lighting","☆",1,"★",2,"★",{"$f":"IF(R17=\"★\",2,IF(R17=\"☆\",1,0))","v":2},"★",{"$f":"IF(T17=\"★\",2,IF(T17=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X17=\"★\",2,IF(X17=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z17=\"★\",2,IF(Z17=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB17=\"★\",2,IF(AB17=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD17=\"★\",2,IF(AD17=\"☆\",1,0))","v":1},"★",{"$f":"IF(AF17=\"★\",2,IF(AF17=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH17=\"★\",2,IF(AH17=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ17=\"★\",2,IF(AJ17=\"☆\",1,0))","v":2}]
[null,"Intelligent Transportation Systems",null,0,null,0,0,null,null,null,null,null,"Intelligent Transportation Systems",null,0,"☆",1,"☆",{"$f":"IF(R18=\"★\",2,IF(R18=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T18=\"★\",2,IF(T18=\"☆\",1,0))","v":1},"☆",1,"☆",{"$f":"IF(X18=\"★\",2,IF(X18=\"☆\",1,0))","v":1},"☆",{"$f":"IF(Z18=\"★\",2,IF(Z18=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AB18=\"★\",2,IF(AB18=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AD18=\"★\",2,IF(AD18=\"☆\",1,0))","v":1},"★",{"$f":"IF(AF18=\"★\",2,IF(AF18=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH18=\"★\",2,IF(AH18=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AJ18=\"★\",2,IF(AJ18=\"☆\",1,0))","v":1}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Potential Tool Applicability","Construction Engineering (E)",null,null,"Construction Staff Function","Construction Engineering (E)"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,O25:O38)/SUM($D$5:$D$18)","v":0},"E-1","3D Engineered Models for Construction",null,"                             Strategy (Tool)","E-1",null,"E-2",null,"E-3",null,"E-4",null,"E-5",null,"E-6",null,"E-7",null,"E-8",null,"E-8-1",null,"E-8-2",null,"E-8-3",null,"E-9",null,"E-10"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,Q25:Q38)/SUM($D$5:$D$18)","v":0},"E-2","Automated Machine Guidance",null,"Work Type"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,S25:S38)/SUM($D$5:$D$18)","v":0},"E-3","Digital Terrain Models (DTMs)",null,"Pavement Surface","★",{"$f":"IF(N25=\"★\",2,IF(N25=\"☆\",1,0))","v":2},"★",{"$f":"IF(P25=\"★\",2,IF(P25=\"☆\",1,0))","v":2},"★",{"$f":"IF(R25=\"★\",2,IF(R25=\"☆\",1,0))","v":2},"★",{"$f":"IF(T25=\"★\",2,IF(T25=\"☆\",1,0))","v":2},"★",{"$f":"IF(V25=\"★\",2,IF(V25=\"☆\",1,0))","v":2},"★",{"$f":"IF(X25=\"★\",2,IF(X25=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z25=\"★\",2,IF(Z25=\"☆\",1,0))","v":2},"★",{"$f":"IF(AB25=\"★\",2,IF(AB25=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD25=\"★\",2,IF(AD25=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF25=\"★\",2,IF(AF25=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH25=\"★\",2,IF(AH25=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ25=\"★\",2,IF(AJ25=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL25=\"★\",2,IF(AL25=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,U25:U38)/SUM($D$5:$D$18)","v":0},"A-4/E-4/I-4","Electronic Field Books",null,"Superstructure","☆",{"$f":"IF(N26=\"★\",2,IF(N26=\"☆\",1,0))","v":1},"☆",{"$f":"IF(P26=\"★\",2,IF(P26=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R26=\"★\",2,IF(R26=\"☆\",1,0))","v":1},"★",{"$f":"IF(T26=\"★\",2,IF(T26=\"☆\",1,0))","v":2},"★",{"$f":"IF(V26=\"★\",2,IF(V26=\"☆\",1,0))","v":2},"★",{"$f":"IF(X26=\"★\",2,IF(X26=\"☆\",1,0))","v":2},null,{"$f":"IF(Z26=\"★\",2,IF(Z26=\"☆\",1,0))","v":0},"★",{"$f":"IF(AB26=\"★\",2,IF(AB26=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD26=\"★\",2,IF(AD26=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF26=\"★\",2,IF(AF26=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH26=\"★\",2,IF(AH26=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ26=\"★\",2,IF(AJ26=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL26=\"★\",2,IF(AL26=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,W25:W38)/SUM($D$5:$D$18)","v":0},"E-5/I-5","Ground Penetrating Radar (GPR)",null,"Excavation / Embankment","★",{"$f":"IF(N27=\"★\",2,IF(N27=\"☆\",1,0))","v":2},"★",{"$f":"IF(P27=\"★\",2,IF(P27=\"☆\",1,0))","v":2},"★",{"$f":"IF(R27=\"★\",2,IF(R27=\"☆\",1,0))","v":2},"★",{"$f":"IF(T27=\"★\",2,IF(T27=\"☆\",1,0))","v":2},"☆",{"$f":"IF(V27=\"★\",2,IF(V27=\"☆\",1,0))","v":1},"★",{"$f":"IF(X27=\"★\",2,IF(X27=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z27=\"★\",2,IF(Z27=\"☆\",1,0))","v":2},"★",{"$f":"IF(AB27=\"★\",2,IF(AB27=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD27=\"★\",2,IF(AD27=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF27=\"★\",2,IF(AF27=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH27=\"★\",2,IF(AH27=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ27=\"★\",2,IF(AJ27=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL27=\"★\",2,IF(AL27=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,Y25:Y38)/SUM($D$5:$D$18)","v":0},"E-6/I-6","Global Navigation Satellite Systems (GNSS)",null,"Pipe / Drainage","★",{"$f":"IF(N28=\"★\",2,IF(N28=\"☆\",1,0))","v":2},"★",{"$f":"IF(P28=\"★\",2,IF(P28=\"☆\",1,0))","v":2},"★",{"$f":"IF(R28=\"★\",2,IF(R28=\"☆\",1,0))","v":2},"★",{"$f":"IF(T28=\"★\",2,IF(T28=\"☆\",1,0))","v":2},"☆",{"$f":"IF(V28=\"★\",2,IF(V28=\"☆\",1,0))","v":1},"★",{"$f":"IF(X28=\"★\",2,IF(X28=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z28=\"★\",2,IF(Z28=\"☆\",1,0))","v":2},"★",{"$f":"IF(AB28=\"★\",2,IF(AB28=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD28=\"★\",2,IF(AD28=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF28=\"★\",2,IF(AF28=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH28=\"★\",2,IF(AH28=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ28=\"★\",2,IF(AJ28=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL28=\"★\",2,IF(AL28=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AA25:AA38)/SUM($D$5:$D$18)","v":0},"E-7","Light Detection and Ranging (LiDAR)",null,"Roadway Base","★",{"$f":"IF(N29=\"★\",2,IF(N29=\"☆\",1,0))","v":2},"★",{"$f":"IF(P29=\"★\",2,IF(P29=\"☆\",1,0))","v":2},"★",{"$f":"IF(R29=\"★\",2,IF(R29=\"☆\",1,0))","v":2},"★",{"$f":"IF(T29=\"★\",2,IF(T29=\"☆\",1,0))","v":2},"☆",{"$f":"IF(V29=\"★\",2,IF(V29=\"☆\",1,0))","v":1},"★",{"$f":"IF(X29=\"★\",2,IF(X29=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z29=\"★\",2,IF(Z29=\"☆\",1,0))","v":2},"★",{"$f":"IF(AB29=\"★\",2,IF(AB29=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD29=\"★\",2,IF(AD29=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF29=\"★\",2,IF(AF29=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH29=\"★\",2,IF(AH29=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ29=\"★\",2,IF(AJ29=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL29=\"★\",2,IF(AL29=\"☆\",1,0))","v":2}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AC25:AC38)/SUM($D$5:$D$18)","v":0},"E-8/HR-3","Resource Allocation/Leveling--",null,"Pavement Base","★",{"$f":"IF(N30=\"★\",2,IF(N30=\"☆\",1,0))","v":2},"★",{"$f":"IF(P30=\"★\",2,IF(P30=\"☆\",1,0))","v":2},"★",{"$f":"IF(R30=\"★\",2,IF(R30=\"☆\",1,0))","v":2},"★",{"$f":"IF(T30=\"★\",2,IF(T30=\"☆\",1,0))","v":2},"☆",{"$f":"IF(V30=\"★\",2,IF(V30=\"☆\",1,0))","v":1},"★",{"$f":"IF(X30=\"★\",2,IF(X30=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z30=\"★\",2,IF(Z30=\"☆\",1,0))","v":2},"★",{"$f":"IF(AB30=\"★\",2,IF(AB30=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD30=\"★\",2,IF(AD30=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF30=\"★\",2,IF(AF30=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH30=\"★\",2,IF(AH30=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ30=\"★\",2,IF(AJ30=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL30=\"★\",2,IF(AL30=\"☆\",1,0))","v":2}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AE25:AE38)/SUM($D$5:$D$18)","v":0},"E-8-1/HR-3-1","     District & Project Level",null,"Substructure","☆",{"$f":"IF(N31=\"★\",2,IF(N31=\"☆\",1,0))","v":1},"☆",{"$f":"IF(P31=\"★\",2,IF(P31=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R31=\"★\",2,IF(R31=\"☆\",1,0))","v":1},"★",{"$f":"IF(T31=\"★\",2,IF(T31=\"☆\",1,0))","v":2},null,{"$f":"IF(V31=\"★\",2,IF(V31=\"☆\",1,0))","v":0},"★",{"$f":"IF(X31=\"★\",2,IF(X31=\"☆\",1,0))","v":2},null,{"$f":"IF(Z31=\"★\",2,IF(Z31=\"☆\",1,0))","v":0},"★",{"$f":"IF(AB31=\"★\",2,IF(AB31=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD31=\"★\",2,IF(AD31=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF31=\"★\",2,IF(AF31=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH31=\"★\",2,IF(AH31=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ31=\"★\",2,IF(AJ31=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL31=\"★\",2,IF(AL31=\"☆\",1,0))","v":2}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AG25:AG38)/SUM($D$5:$D$18)","v":0},"E-8-2/HR-3-2","     Project Phasing",null,"Temporary Traffic Control","☆",{"$f":"IF(N32=\"★\",2,IF(N32=\"☆\",1,0))","v":1},"☆",{"$f":"IF(P32=\"★\",2,IF(P32=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R32=\"★\",2,IF(R32=\"☆\",1,0))","v":1},"★",{"$f":"IF(T32=\"★\",2,IF(T32=\"☆\",1,0))","v":2},null,{"$f":"IF(V32=\"★\",2,IF(V32=\"☆\",1,0))","v":0},"★",{"$f":"IF(X32=\"★\",2,IF(X32=\"☆\",1,0))","v":2},"☆",{"$f":"IF(Z32=\"★\",2,IF(Z32=\"☆\",1,0))","v":1},"★",{"$f":"IF(AB32=\"★\",2,IF(AB32=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD32=\"★\",2,IF(AD32=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF32=\"★\",2,IF(AF32=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH32=\"★\",2,IF(AH32=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ32=\"★\",2,IF(AJ32=\"☆\",1,0))","v":2},null,{"$f":"IF(AL32=\"★\",2,IF(AL32=\"☆\",1,0))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AI25:AI38)/SUM($D$5:$D$18)","v":0},"E-8-3/HR-3-3","     Shifting Letting Dates",null,"Structural Foundation","☆",{"$f":"IF(N33=\"★\",2,IF(N33=\"☆\",1,0))","v":1},"☆",{"$f":"IF(P33=\"★\",2,IF(P33=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R33=\"★\",2,IF(R33=\"☆\",1,0))","v":1},"★",{"$f":"IF(T33=\"★\",2,IF(T33=\"☆\",1,0))","v":2},"☆",{"$f":"IF(V33=\"★\",2,IF(V33=\"☆\",1,0))","v":1},"★",{"$f":"IF(X33=\"★\",2,IF(X33=\"☆\",1,0))","v":2},null,{"$f":"IF(Z33=\"★\",2,IF(Z33=\"☆\",1,0))","v":0},"★",{"$f":"IF(AB33=\"★\",2,IF(AB33=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD33=\"★\",2,IF(AD33=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF33=\"★\",2,IF(AF33=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH33=\"★\",2,IF(AH33=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ33=\"★\",2,IF(AJ33=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL33=\"★\",2,IF(AL33=\"☆\",1,0))","v":2}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AK25:AK38)/SUM($D$5:$D$18)","v":0},"E-9/I-14","Robotic Total Stations",null,"Strips / Signs / Signals","☆",{"$f":"IF(N34=\"★\",2,IF(N34=\"☆\",1,0))","v":1},null,{"$f":"IF(P34=\"★\",2,IF(P34=\"☆\",1,0))","v":0},"☆",{"$f":"IF(R34=\"★\",2,IF(R34=\"☆\",1,0))","v":1},"★",{"$f":"IF(T34=\"★\",2,IF(T34=\"☆\",1,0))","v":2},null,{"$f":"IF(V34=\"★\",2,IF(V34=\"☆\",1,0))","v":0},"★",{"$f":"IF(X34=\"★\",2,IF(X34=\"☆\",1,0))","v":2},"☆",{"$f":"IF(Z34=\"★\",2,IF(Z34=\"☆\",1,0))","v":1},"★",{"$f":"IF(AB34=\"★\",2,IF(AB34=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD34=\"★\",2,IF(AD34=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF34=\"★\",2,IF(AF34=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH34=\"★\",2,IF(AH34=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ34=\"★\",2,IF(AJ34=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL34=\"★\",2,IF(AL34=\"☆\",1,0))","v":2}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AM25:AM38)/SUM($D$5:$D$18)","v":0},"E-10/I-15","Project Inspection Test Plan",null,"Roadside","★",{"$f":"IF(N35=\"★\",2,IF(N35=\"☆\",1,0))","v":2},"★",{"$f":"IF(P35=\"★\",2,IF(P35=\"☆\",1,0))","v":2},"★",{"$f":"IF(R35=\"★\",2,IF(R35=\"☆\",1,0))","v":2},"★",{"$f":"IF(T35=\"★\",2,IF(T35=\"☆\",1,0))","v":2},null,{"$f":"IF(V35=\"★\",2,IF(V35=\"☆\",1,0))","v":0},"★",{"$f":"IF(X35=\"★\",2,IF(X35=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z35=\"★\",2,IF(Z35=\"☆\",1,0))","v":2},"★",{"$f":"IF(AB35=\"★\",2,IF(AB35=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD35=\"★\",2,IF(AD35=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF35=\"★\",2,IF(AF35=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH35=\"★\",2,IF(AH35=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ35=\"★\",2,IF(AJ35=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL35=\"★\",2,IF(AL35=\"☆\",1,0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Utilities (In contract relocations)","★",{"$f":"IF(N36=\"★\",2,IF(N36=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P36=\"★\",2,IF(P36=\"☆\",1,0))","v":1},"★",{"$f":"IF(R36=\"★\",2,IF(R36=\"☆\",1,0))","v":2},"★",{"$f":"IF(T36=\"★\",2,IF(T36=\"☆\",1,0))","v":2},"☆",{"$f":"IF(V36=\"★\",2,IF(V36=\"☆\",1,0))","v":1},"★",{"$f":"IF(X36=\"★\",2,IF(X36=\"☆\",1,0))","v":2},null,{"$f":"IF(Z36=\"★\",2,IF(Z36=\"☆\",1,0))","v":0},"★",{"$f":"IF(AB36=\"★\",2,IF(AB36=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD36=\"★\",2,IF(AD36=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF36=\"★\",2,IF(AF36=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH36=\"★\",2,IF(AH36=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ36=\"★\",2,IF(AJ36=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL36=\"★\",2,IF(AL36=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Lighting","☆",{"$f":"IF(N37=\"★\",2,IF(N37=\"☆\",1,0))","v":1},null,{"$f":"IF(P37=\"★\",2,IF(P37=\"☆\",1,0))","v":0},"☆",{"$f":"IF(R37=\"★\",2,IF(R37=\"☆\",1,0))","v":1},"★",{"$f":"IF(T37=\"★\",2,IF(T37=\"☆\",1,0))","v":2},null,{"$f":"IF(V37=\"★\",2,IF(V37=\"☆\",1,0))","v":0},"★",{"$f":"IF(X37=\"★\",2,IF(X37=\"☆\",1,0))","v":2},null,{"$f":"IF(Z37=\"★\",2,IF(Z37=\"☆\",1,0))","v":0},"★",{"$f":"IF(AB37=\"★\",2,IF(AB37=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD37=\"★\",2,IF(AD37=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF37=\"★\",2,IF(AF37=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH37=\"★\",2,IF(AH37=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ37=\"★\",2,IF(AJ37=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL37=\"★\",2,IF(AL37=\"☆\",1,0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Intelligent Transportation Systems","☆",{"$f":"IF(N38=\"★\",2,IF(N38=\"☆\",1,0))","v":1},null,{"$f":"IF(P38=\"★\",2,IF(P38=\"☆\",1,0))","v":0},"☆",{"$f":"IF(R38=\"★\",2,IF(R38=\"☆\",1,0))","v":1},"★",{"$f":"IF(T38=\"★\",2,IF(T38=\"☆\",1,0))","v":2},null,{"$f":"IF(V38=\"★\",2,IF(V38=\"☆\",1,0))","v":0},"★",{"$f":"IF(X38=\"★\",2,IF(X38=\"☆\",1,0))","v":2},null,{"$f":"IF(Z38=\"★\",2,IF(Z38=\"☆\",1,0))","v":0},"★",{"$f":"IF(AB38=\"★\",2,IF(AB38=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD38=\"★\",2,IF(AD38=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF38=\"★\",2,IF(AF38=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH38=\"★\",2,IF(AH38=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ38=\"★\",2,IF(AJ38=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL38=\"★\",2,IF(AL38=\"☆\",1,0))","v":1}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Potential Tool Applicability","Construction Inspection (I)",null,null,"Construction Staff Function","Construction Inspection (I)"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,O45:O58)/SUM($D$5:$D$18)","v":0},"I-1","Concrete Maturity Meters",null,"                             Strategy (Tool)","I-1",null,"I-2",null,"I-2-1",null,"I-2-2",null,"I-2-3",null,"I-3",null,"I-4",null,"I-5",null,"I-6",null,"I-7",null,"I-8",null,"I-9",null,"I-10",null,"I-11",null,"I-12",null,"I-13",null,"I-14",null,"I-15",null,"I-16"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,Q45:Q58)/SUM($D$5:$D$18)","v":0},"A-2/I-2","Contract Requirements",null,"Work Type"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,S45:S58)/SUM($D$5:$D$18)","v":0},"A-2-1/I-2-1","     Operations & Maintenance (by Contractor)",null,"Pavement Surface","☆",{"$f":"IF(N45=\"★\",2,IF(N45=\"☆\",1,0))","v":1},"☆",{"$f":"IF(P45=\"★\",2,IF(P45=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R45=\"★\",2,IF(R45=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T45=\"★\",2,IF(T45=\"☆\",1,0))","v":1},"☆",{"$f":"IF(V45=\"★\",2,IF(V45=\"☆\",1,0))","v":1},"☆",{"$f":"IF(X45=\"★\",2,IF(X45=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z45=\"★\",2,IF(Z45=\"☆\",1,0))","v":2},"★",{"$f":"IF(AB45=\"★\",2,IF(AB45=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD45=\"★\",2,IF(AD45=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF45=\"★\",2,IF(AF45=\"☆\",1,0))","v":2},null,{"$f":"IF(AH45=\"★\",2,IF(AH45=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ45=\"★\",2,IF(AJ45=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL45=\"★\",2,IF(AL45=\"☆\",1,0))","v":2},"★",{"$f":"IF(AN45=\"★\",2,IF(AN45=\"☆\",1,0))","v":2},"★",{"$f":"IF(AP45=\"★\",2,IF(AP45=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AR45=\"★\",2,IF(AR45=\"☆\",1,0))","v":1},"★",{"$f":"IF(AT45=\"★\",2,IF(AT45=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AV45=\"★\",2,IF(AV45=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AX45=\"★\",2,IF(AX45=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,U45:U58)/SUM($D$5:$D$18)","v":0},"A-2-2/I-2-2","     Warranty",null,"Superstructure","★",{"$f":"IF(N46=\"★\",2,IF(N46=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P46=\"★\",2,IF(P46=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R46=\"★\",2,IF(R46=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T46=\"★\",2,IF(T46=\"☆\",1,0))","v":1},"☆",{"$f":"IF(V46=\"★\",2,IF(V46=\"☆\",1,0))","v":1},"☆",{"$f":"IF(X46=\"★\",2,IF(X46=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z46=\"★\",2,IF(Z46=\"☆\",1,0))","v":2},"★",{"$f":"IF(AB46=\"★\",2,IF(AB46=\"☆\",1,0))","v":2},"★",{"$f":"IF(AD46=\"★\",2,IF(AD46=\"☆\",1,0))","v":2},null,{"$f":"IF(AF46=\"★\",2,IF(AF46=\"☆\",1,0))","v":0},null,{"$f":"IF(AH46=\"★\",2,IF(AH46=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ46=\"★\",2,IF(AJ46=\"☆\",1,0))","v":2},null,{"$f":"IF(AL46=\"★\",2,IF(AL46=\"☆\",1,0))","v":0},null,{"$f":"IF(AN46=\"★\",2,IF(AN46=\"☆\",1,0))","v":0},null,{"$f":"IF(AP46=\"★\",2,IF(AP46=\"☆\",1,0))","v":0},"☆",{"$f":"IF(AR46=\"★\",2,IF(AR46=\"☆\",1,0))","v":1},"★",{"$f":"IF(AT46=\"★\",2,IF(AT46=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AV46=\"★\",2,IF(AV46=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AX46=\"★\",2,IF(AX46=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,W45:W58)/SUM($D$5:$D$18)","v":0},"A-2-3/I-2-3","     Performance Based Specifications",null,"Excavation / Embankment",null,{"$f":"IF(N47=\"★\",2,IF(N47=\"☆\",1,0))","v":0},"☆",{"$f":"IF(P47=\"★\",2,IF(P47=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R47=\"★\",2,IF(R47=\"☆\",1,0))","v":1},null,{"$f":"IF(T47=\"★\",2,IF(T47=\"☆\",1,0))","v":0},"☆",1,"☆",{"$f":"IF(X47=\"★\",2,IF(X47=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z47=\"★\",2,IF(Z47=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB47=\"★\",2,IF(AB47=\"☆\",1,0))","v":1},"★",{"$f":"IF(AD47=\"★\",2,IF(AD47=\"☆\",1,0))","v":2},null,{"$f":"IF(AF47=\"★\",2,IF(AF47=\"☆\",1,0))","v":0},"★",{"$f":"IF(AH47=\"★\",2,IF(AH47=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ47=\"★\",2,IF(AJ47=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL47=\"★\",2,IF(AL47=\"☆\",1,0))","v":2},"★",{"$f":"IF(AN47=\"★\",2,IF(AN47=\"☆\",1,0))","v":2},"★",{"$f":"IF(AP47=\"★\",2,IF(AP47=\"☆\",1,0))","v":2},"★",{"$f":"IF(AR47=\"★\",2,IF(AR47=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT47=\"★\",2,IF(AT47=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AV47=\"★\",2,IF(AV47=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AX47=\"★\",2,IF(AX47=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,Y45:Y58)/SUM($D$5:$D$18)","v":0},"I-3","e-Inspection",null,"Pipe / Drainage",null,{"$f":"IF(N48=\"★\",2,IF(N48=\"☆\",1,0))","v":0},"★",{"$f":"IF(P48=\"★\",2,IF(P48=\"☆\",1,0))","v":2},"★",{"$f":"IF(R48=\"★\",2,IF(R48=\"☆\",1,0))","v":2},"★",{"$f":"IF(T48=\"★\",2,IF(T48=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X48=\"★\",2,IF(X48=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z48=\"★\",2,IF(Z48=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB48=\"★\",2,IF(AB48=\"☆\",1,0))","v":1},"★",{"$f":"IF(AD48=\"★\",2,IF(AD48=\"☆\",1,0))","v":2},null,{"$f":"IF(AF48=\"★\",2,IF(AF48=\"☆\",1,0))","v":0},null,{"$f":"IF(AH48=\"★\",2,IF(AH48=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ48=\"★\",2,IF(AJ48=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL48=\"★\",2,IF(AL48=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AN48=\"★\",2,IF(AN48=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AP48=\"★\",2,IF(AP48=\"☆\",1,0))","v":1},"★",{"$f":"IF(AR48=\"★\",2,IF(AR48=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT48=\"★\",2,IF(AT48=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AV48=\"★\",2,IF(AV48=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AX48=\"★\",2,IF(AX48=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AA45:AA58)/SUM($D$5:$D$18)","v":0},"A-4/E-4/I-4","Electronic Field Books",null,"Roadway Base",null,{"$f":"IF(N49=\"★\",2,IF(N49=\"☆\",1,0))","v":0},"★",{"$f":"IF(P49=\"★\",2,IF(P49=\"☆\",1,0))","v":2},"★",{"$f":"IF(R49=\"★\",2,IF(R49=\"☆\",1,0))","v":2},"★",{"$f":"IF(T49=\"★\",2,IF(T49=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X49=\"★\",2,IF(X49=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z49=\"★\",2,IF(Z49=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB49=\"★\",2,IF(AB49=\"☆\",1,0))","v":1},"★",{"$f":"IF(AD49=\"★\",2,IF(AD49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF49=\"★\",2,IF(AF49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AH49=\"★\",2,IF(AH49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AJ49=\"★\",2,IF(AJ49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL49=\"★\",2,IF(AL49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AN49=\"★\",2,IF(AN49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AP49=\"★\",2,IF(AP49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AR49=\"★\",2,IF(AR49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT49=\"★\",2,IF(AT49=\"☆\",1,0))","v":2},"★",{"$f":"IF(AV49=\"★\",2,IF(AV49=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AX49=\"★\",2,IF(AX49=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AC45:AC58)/SUM($D$5:$D$18)","v":0},"E-5/I-5","Ground Penetrating Radar (GPR)",null,"Pavement Base",null,{"$f":"IF(N50=\"★\",2,IF(N50=\"☆\",1,0))","v":0},"★",{"$f":"IF(P50=\"★\",2,IF(P50=\"☆\",1,0))","v":2},"★",{"$f":"IF(R50=\"★\",2,IF(R50=\"☆\",1,0))","v":2},"★",{"$f":"IF(T50=\"★\",2,IF(T50=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X50=\"★\",2,IF(X50=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z50=\"★\",2,IF(Z50=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB50=\"★\",2,IF(AB50=\"☆\",1,0))","v":1},"★",{"$f":"IF(AD50=\"★\",2,IF(AD50=\"☆\",1,0))","v":2},"★",{"$f":"IF(AF50=\"★\",2,IF(AF50=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AH50=\"★\",2,IF(AH50=\"☆\",1,0))","v":1},"★",{"$f":"IF(AJ50=\"★\",2,IF(AJ50=\"☆\",1,0))","v":2},"★",{"$f":"IF(AL50=\"★\",2,IF(AL50=\"☆\",1,0))","v":2},"★",{"$f":"IF(AN50=\"★\",2,IF(AN50=\"☆\",1,0))","v":2},"★",{"$f":"IF(AP50=\"★\",2,IF(AP50=\"☆\",1,0))","v":2},"★",{"$f":"IF(AR50=\"★\",2,IF(AR50=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT50=\"★\",2,IF(AT50=\"☆\",1,0))","v":2},"★",{"$f":"IF(AV50=\"★\",2,IF(AV50=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AX50=\"★\",2,IF(AX50=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AE45:AE58)/SUM($D$5:$D$18)","v":0},"E-6/I-6","Global Navigation Satellite Systems (GNSS)",null,"Substructure","★",{"$f":"IF(N51=\"★\",2,IF(N51=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P51=\"★\",2,IF(P51=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R51=\"★\",2,IF(R51=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T51=\"★\",2,IF(T51=\"☆\",1,0))","v":1},"☆",1,"☆",{"$f":"IF(X51=\"★\",2,IF(X51=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z51=\"★\",2,IF(Z51=\"☆\",1,0))","v":2},null,{"$f":"IF(AB51=\"★\",2,IF(AB51=\"☆\",1,0))","v":0},"★",{"$f":"IF(AD51=\"★\",2,IF(AD51=\"☆\",1,0))","v":2},null,{"$f":"IF(AF51=\"★\",2,IF(AF51=\"☆\",1,0))","v":0},null,{"$f":"IF(AH51=\"★\",2,IF(AH51=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ51=\"★\",2,IF(AJ51=\"☆\",1,0))","v":2},null,{"$f":"IF(AL51=\"★\",2,IF(AL51=\"☆\",1,0))","v":0},null,{"$f":"IF(AN51=\"★\",2,IF(AN51=\"☆\",1,0))","v":0},null,{"$f":"IF(AP51=\"★\",2,IF(AP51=\"☆\",1,0))","v":0},"☆",{"$f":"IF(AR51=\"★\",2,IF(AR51=\"☆\",1,0))","v":1},"★",{"$f":"IF(AT51=\"★\",2,IF(AT51=\"☆\",1,0))","v":2},"★",{"$f":"IF(AV51=\"★\",2,IF(AV51=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AX51=\"★\",2,IF(AX51=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AG45:AG58)/SUM($D$5:$D$18)","v":0},"I-7","Infrared Temp. Systems (Pave-IR)",null,"Temporary Traffic Control",null,{"$f":"IF(N52=\"★\",2,IF(N52=\"☆\",1,0))","v":0},null,{"$f":"IF(P52=\"★\",2,IF(P52=\"☆\",1,0))","v":0},null,{"$f":"IF(R52=\"★\",2,IF(R52=\"☆\",1,0))","v":0},null,{"$f":"IF(T52=\"★\",2,IF(T52=\"☆\",1,0))","v":0},"☆",1,"☆",{"$f":"IF(X52=\"★\",2,IF(X52=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z52=\"★\",2,IF(Z52=\"☆\",1,0))","v":2},null,{"$f":"IF(AB52=\"★\",2,IF(AB52=\"☆\",1,0))","v":0},"★",{"$f":"IF(AD52=\"★\",2,IF(AD52=\"☆\",1,0))","v":2},null,{"$f":"IF(AF52=\"★\",2,IF(AF52=\"☆\",1,0))","v":0},null,{"$f":"IF(AH52=\"★\",2,IF(AH52=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ52=\"★\",2,IF(AJ52=\"☆\",1,0))","v":2},null,{"$f":"IF(AL52=\"★\",2,IF(AL52=\"☆\",1,0))","v":0},"★",{"$f":"IF(AN52=\"★\",2,IF(AN52=\"☆\",1,0))","v":2},"★",{"$f":"IF(AP52=\"★\",2,IF(AP52=\"☆\",1,0))","v":2},null,{"$f":"IF(AR52=\"★\",2,IF(AR52=\"☆\",1,0))","v":0},"★",{"$f":"IF(AT52=\"★\",2,IF(AT52=\"☆\",1,0))","v":2},null,{"$f":"IF(AV52=\"★\",2,IF(AV52=\"☆\",1,0))","v":0},"★",{"$f":"IF(AX52=\"★\",2,IF(AX52=\"☆\",1,0))","v":2}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AI45:AI58)/SUM($D$5:$D$18)","v":0},"I-8","Intelligent Compaction",null,"Structural Foundation","★",{"$f":"IF(N53=\"★\",2,IF(N53=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P53=\"★\",2,IF(P53=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R53=\"★\",2,IF(R53=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T53=\"★\",2,IF(T53=\"☆\",1,0))","v":1},"☆",1,"☆",{"$f":"IF(X53=\"★\",2,IF(X53=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z53=\"★\",2,IF(Z53=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB53=\"★\",2,IF(AB53=\"☆\",1,0))","v":1},"★",{"$f":"IF(AD53=\"★\",2,IF(AD53=\"☆\",1,0))","v":2},null,{"$f":"IF(AF53=\"★\",2,IF(AF53=\"☆\",1,0))","v":0},null,{"$f":"IF(AH53=\"★\",2,IF(AH53=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ53=\"★\",2,IF(AJ53=\"☆\",1,0))","v":2},null,{"$f":"IF(AL53=\"★\",2,IF(AL53=\"☆\",1,0))","v":0},null,{"$f":"IF(AN53=\"★\",2,IF(AN53=\"☆\",1,0))","v":0},null,{"$f":"IF(AP53=\"★\",2,IF(AP53=\"☆\",1,0))","v":0},"☆",{"$f":"IF(AR53=\"★\",2,IF(AR53=\"☆\",1,0))","v":1},"★",{"$f":"IF(AT53=\"★\",2,IF(AT53=\"☆\",1,0))","v":2},"★",{"$f":"IF(AV53=\"★\",2,IF(AV53=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AX53=\"★\",2,IF(AX53=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AK45:AK58)/SUM($D$5:$D$18)","v":0},"I-9","QC/QA/IA (Contract Based/Agency Based)",null,"Strips / Signs / Signals",null,{"$f":"IF(N54=\"★\",2,IF(N54=\"☆\",1,0))","v":0},null,{"$f":"IF(P54=\"★\",2,IF(P54=\"☆\",1,0))","v":0},null,{"$f":"IF(R54=\"★\",2,IF(R54=\"☆\",1,0))","v":0},null,{"$f":"IF(T54=\"★\",2,IF(T54=\"☆\",1,0))","v":0},"☆",1,"☆",{"$f":"IF(X54=\"★\",2,IF(X54=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z54=\"★\",2,IF(Z54=\"☆\",1,0))","v":2},null,{"$f":"IF(AB54=\"★\",2,IF(AB54=\"☆\",1,0))","v":0},"★",{"$f":"IF(AD54=\"★\",2,IF(AD54=\"☆\",1,0))","v":2},null,{"$f":"IF(AF54=\"★\",2,IF(AF54=\"☆\",1,0))","v":0},null,{"$f":"IF(AH54=\"★\",2,IF(AH54=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ54=\"★\",2,IF(AJ54=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL54=\"★\",2,IF(AL54=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AN54=\"★\",2,IF(AN54=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AP54=\"★\",2,IF(AP54=\"☆\",1,0))","v":1},"★",{"$f":"IF(AR54=\"★\",2,IF(AR54=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT54=\"★\",2,IF(AT54=\"☆\",1,0))","v":2},"★",{"$f":"IF(AV54=\"★\",2,IF(AV54=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AX54=\"★\",2,IF(AX54=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AM45:AM58)/SUM($D$5:$D$18)","v":0},"I-10","Remote Equipment Monitoring",null,"Roadside",null,{"$f":"IF(N55=\"★\",2,IF(N55=\"☆\",1,0))","v":0},null,{"$f":"IF(P55=\"★\",2,IF(P55=\"☆\",1,0))","v":0},null,{"$f":"IF(R55=\"★\",2,IF(R55=\"☆\",1,0))","v":0},null,{"$f":"IF(T55=\"★\",2,IF(T55=\"☆\",1,0))","v":0},"☆",1,"☆",{"$f":"IF(X55=\"★\",2,IF(X55=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z55=\"★\",2,IF(Z55=\"☆\",1,0))","v":2},null,{"$f":"IF(AB55=\"★\",2,IF(AB55=\"☆\",1,0))","v":0},"★",{"$f":"IF(AD55=\"★\",2,IF(AD55=\"☆\",1,0))","v":2},null,{"$f":"IF(AF55=\"★\",2,IF(AF55=\"☆\",1,0))","v":0},"☆",{"$f":"IF(AH55=\"★\",2,IF(AH55=\"☆\",1,0))","v":1},"★",{"$f":"IF(AJ55=\"★\",2,IF(AJ55=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL55=\"★\",2,IF(AL55=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AN55=\"★\",2,IF(AN55=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AP55=\"★\",2,IF(AP55=\"☆\",1,0))","v":1},"★",{"$f":"IF(AR55=\"★\",2,IF(AR55=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT55=\"★\",2,IF(AT55=\"☆\",1,0))","v":2},"★",{"$f":"IF(AV55=\"★\",2,IF(AV55=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AX55=\"★\",2,IF(AX55=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AO45:AO58)/SUM($D$5:$D$18)","v":0},"I-11","Mobile Road Quality Monitoring Devices",null,"Utilities (In contract relocations)",null,{"$f":"IF(N56=\"★\",2,IF(N56=\"☆\",1,0))","v":0},"★",{"$f":"IF(P56=\"★\",2,IF(P56=\"☆\",1,0))","v":2},"★",{"$f":"IF(R56=\"★\",2,IF(R56=\"☆\",1,0))","v":2},"★",{"$f":"IF(T56=\"★\",2,IF(T56=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X56=\"★\",2,IF(X56=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z56=\"★\",2,IF(Z56=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB56=\"★\",2,IF(AB56=\"☆\",1,0))","v":1},"★",{"$f":"IF(AD56=\"★\",2,IF(AD56=\"☆\",1,0))","v":2},null,{"$f":"IF(AF56=\"★\",2,IF(AF56=\"☆\",1,0))","v":0},null,{"$f":"IF(AH56=\"★\",2,IF(AH56=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ56=\"★\",2,IF(AJ56=\"☆\",1,0))","v":2},null,{"$f":"IF(AL56=\"★\",2,IF(AL56=\"☆\",1,0))","v":0},null,{"$f":"IF(AN56=\"★\",2,IF(AN56=\"☆\",1,0))","v":0},null,{"$f":"IF(AP56=\"★\",2,IF(AP56=\"☆\",1,0))","v":0},"★",{"$f":"IF(AR56=\"★\",2,IF(AR56=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT56=\"★\",2,IF(AT56=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AV56=\"★\",2,IF(AV56=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AX56=\"★\",2,IF(AX56=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AQ45:AQ58)/SUM($D$5:$D$18)","v":0},"I-12","Remote Video Monitoring",null,"Roadway Lighting",null,{"$f":"IF(N57=\"★\",2,IF(N57=\"☆\",1,0))","v":0},"★",{"$f":"IF(P57=\"★\",2,IF(P57=\"☆\",1,0))","v":2},"★",{"$f":"IF(R57=\"★\",2,IF(R57=\"☆\",1,0))","v":2},"★",{"$f":"IF(T57=\"★\",2,IF(T57=\"☆\",1,0))","v":2},"☆",1,"☆",{"$f":"IF(X57=\"★\",2,IF(X57=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z57=\"★\",2,IF(Z57=\"☆\",1,0))","v":2},null,{"$f":"IF(AB57=\"★\",2,IF(AB57=\"☆\",1,0))","v":0},"★",{"$f":"IF(AD57=\"★\",2,IF(AD57=\"☆\",1,0))","v":2},null,{"$f":"IF(AF57=\"★\",2,IF(AF57=\"☆\",1,0))","v":0},null,{"$f":"IF(AH57=\"★\",2,IF(AH57=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ57=\"★\",2,IF(AJ57=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL57=\"★\",2,IF(AL57=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AN57=\"★\",2,IF(AN57=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AP57=\"★\",2,IF(AP57=\"☆\",1,0))","v":1},"★",{"$f":"IF(AR57=\"★\",2,IF(AR57=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT57=\"★\",2,IF(AT57=\"☆\",1,0))","v":2},"★",{"$f":"IF(AV57=\"★\",2,IF(AV57=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AX57=\"★\",2,IF(AX57=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AS45:AS58)/SUM($D$5:$D$18)","v":0},"I-13","Risk Based Inspection",null,"Intelligent Transportation Systems",null,{"$f":"IF(N58=\"★\",2,IF(N58=\"☆\",1,0))","v":0},"☆",{"$f":"IF(P58=\"★\",2,IF(P58=\"☆\",1,0))","v":1},"☆",{"$f":"IF(R58=\"★\",2,IF(R58=\"☆\",1,0))","v":1},"☆",{"$f":"IF(T58=\"★\",2,IF(T58=\"☆\",1,0))","v":1},"☆",1,"☆",{"$f":"IF(X58=\"★\",2,IF(X58=\"☆\",1,0))","v":1},"★",{"$f":"IF(Z58=\"★\",2,IF(Z58=\"☆\",1,0))","v":2},null,{"$f":"IF(AB58=\"★\",2,IF(AB58=\"☆\",1,0))","v":0},"★",{"$f":"IF(AD58=\"★\",2,IF(AD58=\"☆\",1,0))","v":2},null,{"$f":"IF(AF58=\"★\",2,IF(AF58=\"☆\",1,0))","v":0},null,{"$f":"IF(AH58=\"★\",2,IF(AH58=\"☆\",1,0))","v":0},"★",{"$f":"IF(AJ58=\"★\",2,IF(AJ58=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AL58=\"★\",2,IF(AL58=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AN58=\"★\",2,IF(AN58=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AP58=\"★\",2,IF(AP58=\"☆\",1,0))","v":1},"★",{"$f":"IF(AR58=\"★\",2,IF(AR58=\"☆\",1,0))","v":2},"★",{"$f":"IF(AT58=\"★\",2,IF(AT58=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AV58=\"★\",2,IF(AV58=\"☆\",1,0))","v":1},"☆",{"$f":"IF(AX58=\"★\",2,IF(AX58=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AU45:AU58)/SUM($D$5:$D$18)","v":0},"E-9/I-14","Robotic Total Stations"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AW45:AW58)/SUM($D$5:$D$18)","v":0},"E-10/I-15","Project Inspection Test Plan"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AY45:AY58)/SUM($D$5:$D$18)","v":0},"I-16","Unmanned Aerial Systems (UAS)"]
[]
[]
[null,null,null,null,null,null,null,null,"Potential Tool Applicability","Staff Resource Management & Public Relations ®",null,null,"Construction Staff Function","Staff Resource Management & Public Relations (R)"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,O67:O80)/SUM($D$5:$D$18)","v":0},"R-1","CEI Consultants",null,"                             Strategy (Tool)","R-1",null,"R-2",null,"R-3",null,"R-3-1",null,"R-3-2",null,"R-3-3",null,"R-4",null,"R-5"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,Q67:Q80)/SUM($D$5:$D$18)","v":0},"R-2","Educational/Community Outreach",null,"Work Type"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,S67:S80)/SUM($D$5:$D$18)","v":0},"E-8/R-3","Resource Allocation/Leveling",null,"Pavement Surface","★",{"$f":"IF(N67=\"★\",2,IF(N67=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P67=\"★\",2,IF(P67=\"☆\",1,0))","v":1},"★",{"$f":"IF(R67=\"★\",2,IF(R67=\"☆\",1,0))","v":2},"★",{"$f":"IF(T67=\"★\",2,IF(T67=\"☆\",1,0))","v":2},"★",{"$f":"IF(V67=\"★\",2,IF(V67=\"☆\",1,0))","v":2},"★",{"$f":"IF(X67=\"★\",2,IF(X67=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z67=\"★\",2,IF(Z67=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB67=\"★\",2,IF(AB67=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,U67:U80)/SUM($D$5:$D$18)","v":0},"E-8-1/R-3-1","     District & Project Level",null,"Superstructure","★",{"$f":"IF(N68=\"★\",2,IF(N68=\"☆\",1,0))","v":2},null,{"$f":"IF(P68=\"★\",2,IF(P68=\"☆\",1,0))","v":0},"★",{"$f":"IF(R68=\"★\",2,IF(R68=\"☆\",1,0))","v":2},"★",{"$f":"IF(T68=\"★\",2,IF(T68=\"☆\",1,0))","v":2},"★",{"$f":"IF(V68=\"★\",2,IF(V68=\"☆\",1,0))","v":2},"★",{"$f":"IF(X68=\"★\",2,IF(X68=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z68=\"★\",2,IF(Z68=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB68=\"★\",2,IF(AB68=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,W67:W80)/SUM($D$5:$D$18)","v":0},"E-8-2/R-3-2","     Project Phasing",null,"Excavation / Embankment","★",{"$f":"IF(N69=\"★\",2,IF(N69=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P69=\"★\",2,IF(P69=\"☆\",1,0))","v":1},"★",{"$f":"IF(R69=\"★\",2,IF(R69=\"☆\",1,0))","v":2},"★",{"$f":"IF(T69=\"★\",2,IF(T69=\"☆\",1,0))","v":2},"★",{"$f":"IF(V69=\"★\",2,IF(V69=\"☆\",1,0))","v":2},"★",{"$f":"IF(X69=\"★\",2,IF(X69=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z69=\"★\",2,IF(Z69=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB69=\"★\",2,IF(AB69=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,Y67:Y80)/SUM($D$5:$D$18)","v":0},"E-8-3/R-3-3","     Shifting Letting Dates",null,"Pipe / Drainage","★",{"$f":"IF(N70=\"★\",2,IF(N70=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P70=\"★\",2,IF(P70=\"☆\",1,0))","v":1},"★",{"$f":"IF(R70=\"★\",2,IF(R70=\"☆\",1,0))","v":2},"★",{"$f":"IF(T70=\"★\",2,IF(T70=\"☆\",1,0))","v":2},"★",{"$f":"IF(V70=\"★\",2,IF(V70=\"☆\",1,0))","v":2},"★",{"$f":"IF(X70=\"★\",2,IF(X70=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z70=\"★\",2,IF(Z70=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB70=\"★\",2,IF(AB70=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AA67:AA80)/SUM($D$5:$D$18)","v":0},"R-4","Shifts & Overtime (Work Schedules)",null,"Roadway Base","★",{"$f":"IF(N71=\"★\",2,IF(N71=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P71=\"★\",2,IF(P71=\"☆\",1,0))","v":1},"★",{"$f":"IF(R71=\"★\",2,IF(R71=\"☆\",1,0))","v":2},"★",{"$f":"IF(T71=\"★\",2,IF(T71=\"☆\",1,0))","v":2},"★",{"$f":"IF(V71=\"★\",2,IF(V71=\"☆\",1,0))","v":2},"★",{"$f":"IF(X71=\"★\",2,IF(X71=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z71=\"★\",2,IF(Z71=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB71=\"★\",2,IF(AB71=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$18,AC67:AC80)/SUM($D$5:$D$18)","v":0},"R-5","Recruitment,Training & Retention Program",null,"Pavement Base","★",{"$f":"IF(N72=\"★\",2,IF(N72=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P72=\"★\",2,IF(P72=\"☆\",1,0))","v":1},"★",{"$f":"IF(R72=\"★\",2,IF(R72=\"☆\",1,0))","v":2},"★",{"$f":"IF(T72=\"★\",2,IF(T72=\"☆\",1,0))","v":2},"★",{"$f":"IF(V72=\"★\",2,IF(V72=\"☆\",1,0))","v":2},"★",{"$f":"IF(X72=\"★\",2,IF(X72=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z72=\"★\",2,IF(Z72=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB72=\"★\",2,IF(AB72=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Substructure","★",{"$f":"IF(N73=\"★\",2,IF(N73=\"☆\",1,0))","v":2},null,{"$f":"IF(P73=\"★\",2,IF(P73=\"☆\",1,0))","v":0},"★",{"$f":"IF(R73=\"★\",2,IF(R73=\"☆\",1,0))","v":2},"★",{"$f":"IF(T73=\"★\",2,IF(T73=\"☆\",1,0))","v":2},"★",{"$f":"IF(V73=\"★\",2,IF(V73=\"☆\",1,0))","v":2},"★",{"$f":"IF(X73=\"★\",2,IF(X73=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z73=\"★\",2,IF(Z73=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB73=\"★\",2,IF(AB73=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Traffic Control","★",{"$f":"IF(N74=\"★\",2,IF(N74=\"☆\",1,0))","v":2},"★",{"$f":"IF(P74=\"★\",2,IF(P74=\"☆\",1,0))","v":2},"★",{"$f":"IF(R74=\"★\",2,IF(R74=\"☆\",1,0))","v":2},"★",{"$f":"IF(T74=\"★\",2,IF(T74=\"☆\",1,0))","v":2},"★",{"$f":"IF(V74=\"★\",2,IF(V74=\"☆\",1,0))","v":2},"★",{"$f":"IF(X74=\"★\",2,IF(X74=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z74=\"★\",2,IF(Z74=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB74=\"★\",2,IF(AB74=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Structural Foundation","★",{"$f":"IF(N75=\"★\",2,IF(N75=\"☆\",1,0))","v":2},null,{"$f":"IF(P75=\"★\",2,IF(P75=\"☆\",1,0))","v":0},"★",{"$f":"IF(R75=\"★\",2,IF(R75=\"☆\",1,0))","v":2},"★",{"$f":"IF(T75=\"★\",2,IF(T75=\"☆\",1,0))","v":2},"★",{"$f":"IF(V75=\"★\",2,IF(V75=\"☆\",1,0))","v":2},"★",{"$f":"IF(X75=\"★\",2,IF(X75=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z75=\"★\",2,IF(Z75=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB75=\"★\",2,IF(AB75=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Strips / Signs / Signals","★",{"$f":"IF(N76=\"★\",2,IF(N76=\"☆\",1,0))","v":2},"★",{"$f":"IF(P76=\"★\",2,IF(P76=\"☆\",1,0))","v":2},"★",{"$f":"IF(R76=\"★\",2,IF(R76=\"☆\",1,0))","v":2},"★",{"$f":"IF(T76=\"★\",2,IF(T76=\"☆\",1,0))","v":2},"★",{"$f":"IF(V76=\"★\",2,IF(V76=\"☆\",1,0))","v":2},"★",{"$f":"IF(X76=\"★\",2,IF(X76=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z76=\"★\",2,IF(Z76=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB76=\"★\",2,IF(AB76=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Roadside","★",{"$f":"IF(N77=\"★\",2,IF(N77=\"☆\",1,0))","v":2},"★",{"$f":"IF(P77=\"★\",2,IF(P77=\"☆\",1,0))","v":2},"★",{"$f":"IF(R77=\"★\",2,IF(R77=\"☆\",1,0))","v":2},"★",{"$f":"IF(T77=\"★\",2,IF(T77=\"☆\",1,0))","v":2},"★",{"$f":"IF(V77=\"★\",2,IF(V77=\"☆\",1,0))","v":2},"★",{"$f":"IF(X77=\"★\",2,IF(X77=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z77=\"★\",2,IF(Z77=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB77=\"★\",2,IF(AB77=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Utilities (In contract relocations)","★",{"$f":"IF(N78=\"★\",2,IF(N78=\"☆\",1,0))","v":2},"★",{"$f":"IF(P78=\"★\",2,IF(P78=\"☆\",1,0))","v":2},"★",{"$f":"IF(R78=\"★\",2,IF(R78=\"☆\",1,0))","v":2},"★",{"$f":"IF(T78=\"★\",2,IF(T78=\"☆\",1,0))","v":2},"★",{"$f":"IF(V78=\"★\",2,IF(V78=\"☆\",1,0))","v":2},"★",{"$f":"IF(X78=\"★\",2,IF(X78=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z78=\"★\",2,IF(Z78=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB78=\"★\",2,IF(AB78=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Lighting","★",{"$f":"IF(N79=\"★\",2,IF(N79=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P79=\"★\",2,IF(P79=\"☆\",1,0))","v":1},"★",{"$f":"IF(R79=\"★\",2,IF(R79=\"☆\",1,0))","v":2},"★",{"$f":"IF(T79=\"★\",2,IF(T79=\"☆\",1,0))","v":2},"★",{"$f":"IF(V79=\"★\",2,IF(V79=\"☆\",1,0))","v":2},"★",{"$f":"IF(X79=\"★\",2,IF(X79=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z79=\"★\",2,IF(Z79=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB79=\"★\",2,IF(AB79=\"☆\",1,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Intelligent Transportation Systems","★",{"$f":"IF(N80=\"★\",2,IF(N80=\"☆\",1,0))","v":2},"☆",{"$f":"IF(P80=\"★\",2,IF(P80=\"☆\",1,0))","v":1},"★",{"$f":"IF(R80=\"★\",2,IF(R80=\"☆\",1,0))","v":2},"★",{"$f":"IF(T80=\"★\",2,IF(T80=\"☆\",1,0))","v":2},"★",{"$f":"IF(V80=\"★\",2,IF(V80=\"☆\",1,0))","v":2},"★",{"$f":"IF(X80=\"★\",2,IF(X80=\"☆\",1,0))","v":2},"★",{"$f":"IF(Z80=\"★\",2,IF(Z80=\"☆\",1,0))","v":2},"☆",{"$f":"IF(AB80=\"★\",2,IF(AB80=\"☆\",1,0))","v":1}]

{"sheet":"FTE Factors","index":4,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":true,"merged":[[26,6,26,14],[3,2,3,19],[4,2,5,2],[4,6,5,6],[4,8,4,10],[4,11,4,13],[4,14,4,16],[4,17,4,19],[21,2,23,2],[6,2,8,2],[9,2,11,2],[12,2,14,2],[15,2,17,2],[18,2,20,2],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[36,6,36,10]]}
[]
[]
[]
[null,null,"FTE by Project Type and Position",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index Factor"]
[null,null,"Project Type",null,null,null,"Cost Range"," ","Resident Engineer",null,null,"Surveyor",null,null,"Admin Staff",null,null,"Inspectors",null,null,null,"Area",{"$f":"VLOOKUP('FTE CALC'!$B$8,'FTE Factors'!$C$7:$D$24,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"N","Low 95%","Mean","High 95%","Low 95%","Mean","High 95%","Low 95%","Mean","High 95%","Low 95%","Mean","High 95%",null,"Row",{"$f":"IF('FTE CALC'!$C$8<'FTE Factors'!$W$10,'FTE Factors'!$X$10,IF('FTE CALC'!$C$8<'FTE Factors'!$W$11,'FTE Factors'!$X$11,'FTE Factors'!$X$12))","v":{"$error":"#N/A"}}]
[null,null,"Road - New Construction / Expansion",1,1,5000000,"$0-$5,000,000",11,0,0.96,2,0,0.03,0.25,0,0.55000000000000004,3,1,1.72,3]
[null,null,null,null,2,25000000,"$5,000,000 - $25,000,000",11,1,1.2,2,0,0.75,2,0,1.18,2,2,3.9,6]
[null,null,null,null,3,25000000,"$25,000,000 and up",8,0,1.4,2,0,1.2,4,1,2,4,4,8,20,null,"Index Cost Factors"]
[null,null,"Road - Rehabilitation / Resurfacing",2,1,1000000,"$0-$1,000,000",45,0,0.79,1,0,0.17,1,0,0.53,2,0.1,1.5670731707000001,3,null,"Low",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,2,FALSE)","v":{"$error":"#N/A"}},1]
[null,null,null,null,2,5000000,"$1,000,000 - $5,000,000",44,0,0.86,1,0,0.16,1,0,0.75,2.95,1,2.7250000000000001,5,null,"Mid",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,3,FALSE)","v":{"$error":"#N/A"}},2]
[null,null,null,null,3,5000000,"$5,000,000 and up",25,0.25,1.25,4.25,0,0.42,2.75,0,0.94,5.25,1.25,4.8333333332999997,15,null,"High",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,4,FALSE)","v":{"$error":"#N/A"}},3]
[null,null,"Bridge - New & Replacement",3,1,1000000,"$0-$1,000,000",6,0,0.8,1,0,0.2,1,0,1,2,1,1.6,3]
[null,null,null,null,2,10000000,"$1,000,000 - $10,000,000",15,0,0.97,2,0,0.42,2,0,0.67,2,0.7,2.5299999999999998,7]
[null,null,null,null,3,10000000,"$10,000,000 and up",8,1,1.38,2,0,0.63,3,0,1.1299999999999999,2,1,9.125,21]
[null,null,"Bridge - Rehabilitation",4,1,1000000,"$0-$1,000,000",15,0,0.92,1,0,0,0,0,0.52,2.5,1,1.2884615385,2,null,null,null,"Low","Mid","High"]
[null,null,null,null,2,5000000,"$1,000,000 - $5,000,000",11,0,0.71,1,0,0.17,4,0,0.66666999999999998,1,1,2,5,null,null,1,{"$f":"F7","v":5000000},{"$f":"F8","v":25000000},{"$f":"F9","v":25000000}]
[null,null,null,null,3,5000000,"$5,000,000 and up",6,0.25,1.04,2,0,0.41,1,0,0.73076923076919997,2,2.25,4.375,7,null,null,2,{"$f":"F10","v":1000000},{"$f":"F11","v":5000000},{"$f":"F12","v":5000000}]
[null,null,"Other Projects",5,1,500000,"< $500,000",37,0,0.82,1.35,0,0.22,1.35,0,0.68,3,1,1.40625,2.35,null,null,3,{"$f":"F13","v":1000000},{"$f":"F14","v":10000000},{"$f":"F15","v":10000000}]
[null,null,null,null,2,1000000,"$500,000 - $1,000,000",20,0,0.85,1.95,0,0.16,1.95,0,0.63,1.95,0.05,1.5725,3.95,null,null,4,{"$f":"F16","v":1000000},{"$f":"F17","v":5000000},{"$f":"F18","v":5000000}]
[null,null,null,null,3,1000000,"$1,000,000 and up",32,0,0.94,2,0,0.49,2.9,0,0.73,3,0,2.0750000000000002,4.45,null,null,5,{"$f":"F19","v":500000},{"$f":"F20","v":1000000},{"$f":"F21","v":1000000}]
[null,null,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",6,1,0,null,3,null,1,null,null,1.33,null,null,1.67,null,null,2.67,null,null,null,6,{"$f":"F22","v":0},{"$f":"F23","v":0},{"$f":"F24","v":0}]
[null,null,null,null,1,0,null,3,null,1,null,null,1.33,null,null,1.67,null,null,2.67]
[null,null,null,null,1,0,null,3,null,1,null,null,1.33,null,null,1.67,null,null,2.67]
[]
[]
[null,null,null,null,null,null,"Adjustment Factors for Using CEI Consultants"]
[null,null,null,null,null,null,null,"RE",null,"Surveyor",null,"Admin",null,"Inspectors"]
[null,null,null,null,null,null,null,"ST Only","w/Cons","ST Only","w/Cons","ST Only","w/Cons","ST Only","w/Cons",null,null,"CEI","Factor Used"]
[null,null,null,null,null,1,"Road - New Construction / Expansion",0.89678423236513027,1.0750660128253597,1.1435185185186372,0.89562289562307806,0.75568181818182167,1.1776859504131736,0.67857142857141517,1.2337662337661923,null,"RE",{"$f":"IF('FTE CALC'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE CALC'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,3+R30,FALSE))","v":1}]
[null,null,null,null,null,2,"Road - Rehabilitation / Resurfacing",0.97785276073617977,1.0582822085889392,1.1828571428573624,0.5187969924816106,0.83260960334032175,1.4405010438413872,0.78530386740331526,1.564989822622842,null,"SRV",{"$f":"IF('FTE CALC'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE CALC'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,5+R31,FALSE))","v":1}]
[null,null,null,null,null,3,"Bridge - New & Replacement",0.92307692307686617,1.0549450549450428,0.47999999999996162,1.3714285714282903,1.3333333333333333,0.76190476190466672,0.8516129032258174,1.1059907834101692,null,"ADM",{"$f":"IF('FTE CALC'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE CALC'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,7+R32,FALSE))","v":1}]
[null,null,null,null,null,4,"Bridge - Rehabilitation",0.83210483210485187,1.1007371007370184,0.29042904290419164,1.4257425742571999,0.91484184914843303,1.0510948905110102,1.0780141843971207,0.95319148936168663,null,"INS",{"$f":"IF('FTE CALC'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE CALC'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,9+R33,FALSE))","v":1}]
[null,null,null,null,null,5,"Other Projects",0.90428090428086871,1.1292207792207969,1.162901490702152,0.78008298755188021,1.001210360687611,0.99836601307194761,1.047129391602484,0.93637532133680046,null,null,null,null,null,null,null,"Combined Factor"]
[null,null,null,null,null,6,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,"RE",{"$f":"S30*S38","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRV",{"$f":"S31*S39","v":1}]
[null,null,null,null,null,null,"Adjustment Factors for Project Complexity",null,null,null,null,null,null,null,null,null,null,"Complexity Factor",null,null,null,null,"ADM",1]
[null,null,null,null,null,null,null,"RE","Surveyor","Admin","Inspectors",null,null,null,null,null,"RE",{"$f":"VLOOKUP('FTE CALC'!$E$8,'FTE Factors'!$G$39:$K$41,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$38,1)","v":1},null,null,null,"INS",1]
[null,null,null,null,null,null,"Non-Complex",0.92553191489361708,0.54545454545454553,0.89473684210526305,0.77480916030534375,null,null,null,null,null,"SRV",{"$f":"VLOOKUP('FTE CALC'!$E$8,'FTE Factors'!$G$39:$K$41,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$39,1)","v":1}]
[null,null,null,null,null,null,"Moderate",0.97872340425531912,1.3636363636363638,0.97368421052631582,0.93511450381679406,null,null,null,null,null,"ADM",{"$f":"VLOOKUP('FTE CALC'!$E$8,'FTE Factors'!$G$39:$K$41,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$40,1)","v":1}]
[null,null,null,null,null,null,"Complex",1.3936170212765959,2.6363636363636362,1.5394736842105261,2.2938931297709928,null,null,null,null,null,"INS",{"$f":"VLOOKUP('FTE CALC'!$E$8,'FTE Factors'!$G$39:$K$41,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$41,1)","v":1}]

{"sheet":"DOT INPUT","index":5,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,2,3,19],[4,2,5,2],[4,6,5,6],[4,8,4,10],[4,11,4,13],[4,14,4,16],[4,17,4,19],[36,6,36,10],[6,2,8,2],[9,2,11,2],[12,2,14,2],[15,2,17,2],[18,2,20,2],[21,2,23,2],[26,6,26,14],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14]]}
[]
[]
[]
[null,null,"FTE by Project Type and Position",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index Factor"]
[null,null,"Project Type",null,null,null,"Cost Range"," "," Engineer",null,null,"Surveyor",null,null,"Admin Staff",null,null,"Inspectors",null,null,null,"Area",{"$f":"VLOOKUP('FTE CALC'!$B$8,'DOT INPUT'!$C$7:$D$24,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"N","Low","Avg","High","Low","Avg","High","Low","Avg","High","Low","Avg","High",null,"Row",{"$f":"IF('FTE CALC'!$C$8<'DOT INPUT'!$W$10,'DOT INPUT'!$X$10,IF('FTE CALC'!$C$8<'DOT INPUT'!$W$11,'DOT INPUT'!$X$11,'DOT INPUT'!$X$12))","v":{"$error":"#N/A"}}]
[null,null,"Road - New Construction / Expansion",1,1,5000000,"$0-$5,000,000",11]
[null,null,null,null,2,25000000,"$5,000,000 - $25,000,000",11]
[null,null,null,null,3,25000000,"$25,000,000 and up",8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index Cost Factors"]
[null,null,"Road - Rehabilitation / Resurfacing",2,1,1000000,"$0-$1,000,000",45,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,2,FALSE)","v":{"$error":"#N/A"}},1]
[null,null,null,null,2,5000000,"$1,000,000 - $5,000,000",44,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mid",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,3,FALSE)","v":{"$error":"#N/A"}},2]
[null,null,null,null,3,5000000,"$5,000,000 and up",25,null,null,null,null,null,null,null,null,null,null,null,null,null,"High",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,4,FALSE)","v":{"$error":"#N/A"}},3]
[null,null,"Bridge - New & Replacement",3,1,1000000,"$0-$1,000,000",6]
[null,null,null,null,2,10000000,"$1,000,000 - $10,000,000",15]
[null,null,null,null,3,10000000,"$10,000,000 and up",8]
[null,null,"Bridge - Rehabilitation",4,1,1000000,"$0-$1,000,000",15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low","Mid","High"]
[null,null,null,null,2,5000000,"$1,000,000 - $5,000,000",11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"F7","v":5000000},{"$f":"F8","v":25000000},{"$f":"F9","v":25000000}]
[null,null,null,null,3,5000000,"$5,000,000 and up",6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"F10","v":1000000},{"$f":"F11","v":5000000},{"$f":"F12","v":5000000}]
[null,null,"Other Projects",5,1,500000,"< $500,000",37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"F13","v":1000000},{"$f":"F14","v":10000000},{"$f":"F15","v":10000000}]
[null,null,null,null,2,1000000,"$500,000 - $1,000,000",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"F16","v":1000000},{"$f":"F17","v":5000000},{"$f":"F18","v":5000000}]
[null,null,null,null,3,1000000,"$1,000,000 and up",32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"F19","v":500000},{"$f":"F20","v":1000000},{"$f":"F21","v":1000000}]
[null,null,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",6,1,0,"< $500,000",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"F22","v":0},{"$f":"F23","v":0},{"$f":"F24","v":0}]
[null,null,null,null,1,0,"$500,000 - $1,000,000",3]
[null,null,null,null,1,0,"$1,000,000 and up",3]
[]
[]
[null,null,null,null,null,null,"Adjustment Factors for Using CEI Consultants"]
[null,null,null,null,null,null,null,"Engineer",null,"Surveyor",null,"Admin",null,"Inspectors"]
[null,null,null,null,null,null,null,"ST Only","w/Cons","ST Only","w/Cons","ST Only","w/Cons","ST Only","w/Cons",null,null,"CEI","Factor Used"]
[null,null,null,null,null,1,"Road - New Construction / Expansion",0.89678423236513027,1.0750660128253597,1.1435185185186372,0.89562289562307806,0.75568181818182167,1.1776859504131736,0.67857142857141517,1.2337662337661923,null,"RE",{"$f":"IF('FTE CALC'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE CALC'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,3+R30,FALSE))","v":1}]
[null,null,null,null,null,2,"Road - Rehabilitation / Resurfacing",0.97785276073617977,1.0582822085889392,1.1828571428573624,0.5187969924816106,0.83260960334032175,1.4405010438413872,0.78530386740331526,1.564989822622842,null,"SRV",{"$f":"IF('FTE CALC'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE CALC'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,5+R31,FALSE))","v":1}]
[null,null,null,null,null,3,"Bridge - New & Replacement",0.92307692307686617,1.0549450549450428,0.47999999999996162,1.3714285714282903,1.3333333333333333,0.76190476190466672,0.8516129032258174,1.1059907834101692,null,"ADM",{"$f":"IF('FTE CALC'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE CALC'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,7+R32,FALSE))","v":1}]
[null,null,null,null,null,4,"Bridge - Rehabilitation",0.83210483210485187,1.1007371007370184,0.29042904290419164,1.4257425742571999,0.91484184914843303,1.0510948905110102,1.0780141843971207,0.95319148936168663,null,"INS",{"$f":"IF('FTE CALC'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE CALC'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,9+R33,FALSE))","v":1}]
[null,null,null,null,null,5,"Other Projects",0.90428090428086871,1.1292207792207969,1.162901490702152,0.78008298755188021,1.001210360687611,0.99836601307194761,1.047129391602484,0.93637532133680046,null,null,null,null,null,null,null,"Combined Factor"]
[null,null,null,null,null,6,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,"RE",{"$f":"S30*S38","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRV",{"$f":"S31*S39","v":1}]
[null,null,null,null,null,null,"Adjustment Factors for Project Complexity",null,null,null,null,null,null,null,null,null,null,"Complexity Factor",null,null,null,null,"ADM",1]
[null,null,null,null,null,null,null,"Eng.","Surveyor","Admin","Inspectors",null,null,null,null,null,"RE",{"$f":"VLOOKUP('FTE CALC'!$E$8,'DOT INPUT'!$G$39:$K$41,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$38,1)","v":1},null,null,null,"INS",1]
[null,null,null,null,null,null,"Non-Complex",0.92553191489361708,0.54545454545454553,0.89473684210526305,0.77480916030534375,null,null,null,null,null,"SRV",{"$f":"VLOOKUP('FTE CALC'!$E$8,'DOT INPUT'!$G$39:$K$41,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$39,1)","v":1}]
[null,null,null,null,null,null,"Moderate",0.97872340425531912,1.3636363636363638,0.97368421052631582,0.93511450381679406,null,null,null,null,null,"ADM",{"$f":"VLOOKUP('FTE CALC'!$E$8,'DOT INPUT'!$G$39:$K$41,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$40,1)","v":1}]
[null,null,null,null,null,null,"Complex",1.3936170212765959,2.6363636363636362,1.5394736842105261,2.2938931297709928,null,null,null,null,null,"INS",{"$f":"VLOOKUP('FTE CALC'!$E$8,'DOT INPUT'!$G$39:$K$41,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$41,1)","v":1}]

{"sheet":"FTE FactorsRV","index":6,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":true,"merged":[[3,2,3,19],[4,2,5,2],[4,6,5,6],[4,8,4,10],[4,11,4,13],[4,14,4,16],[4,17,4,19],[36,6,36,10],[6,2,8,2],[9,2,11,2],[12,2,14,2],[15,2,17,2],[18,2,20,2],[21,2,23,2],[26,6,26,14],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14]]}
[]
[]
[]
[null,null,"FTE by Project Type and Position",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index Factor"]
[null,null,"Project Type",null,null,null,"Cost Range"," ","Resident Engineer",null,null,"Surveyor",null,null,"Admin Staff",null,null,"Inspectors",null,null,null,"Area",{"$f":"VLOOKUP('FTE Review'!$B$8,'FTE FactorsRV'!$C$7:$D$24,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"N","Low 95%","Mean","High 95%","Low 95%","Mean","High 95%","Low 95%","Mean","High 95%","Low 95%","Mean","High 95%",null,"Row",{"$f":"IF('FTE Review'!$C$8<'FTE FactorsRV'!$W$10,'FTE FactorsRV'!$X$10,IF('FTE Review'!$C$8<'FTE FactorsRV'!$W$11,'FTE FactorsRV'!$X$11,'FTE FactorsRV'!$X$12))","v":{"$error":"#N/A"}}]
[null,null,"Road - New Construction / Expansion",1,1,5000000,"$0-$5,000,000",11,0,0.96,2,0,0.03,0.25,0,0.55000000000000004,3,1,1.72,3]
[null,null,null,null,2,25000000,"$5,000,000 - $25,000,000",11,1,1.2,2,0,0.75,2,0,1.18,2,2,3.9,6]
[null,null,null,null,3,25000000,"$25,000,000 and up",8,0,1.4,2,0,1.2,4,1,2,4,4,8,20,null,"Index Cost Factors"]
[null,null,"Road - Rehabilitation / Resurfacing",2,1,1000000,"$0-$1,000,000",45,0,0.79,1,0,0.17,1,0,0.53,2,0.1,1.5670731707000001,3,null,"Low",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,2,FALSE)","v":{"$error":"#N/A"}},1]
[null,null,null,null,2,5000000,"$1,000,000 - $5,000,000",44,0,0.86,1,0,0.16,1,0,0.75,2.95,1,2.7250000000000001,5,null,"Mid",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,3,FALSE)","v":{"$error":"#N/A"}},2]
[null,null,null,null,3,5000000,"$5,000,000 and up",25,0.25,1.25,4.25,0,0.42,2.75,0,0.94,5.25,1.25,4.8333333332999997,15,null,"High",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,4,FALSE)","v":{"$error":"#N/A"}},3]
[null,null,"Bridge - New & Replacement",3,1,1000000,"$0-$1,000,000",6,0,0.8,1,0,0.2,1,0,1,2,1,1.6,3]
[null,null,null,null,2,10000000,"$1,000,000 - $10,000,000",15,0,0.97,2,0,0.42,2,0,0.67,2,0.7,2.5299999999999998,7]
[null,null,null,null,3,10000000,"$10,000,000 and up",8,1,1.38,2,0,0.63,3,0,1.1299999999999999,2,1,9.125,21]
[null,null,"Bridge - Rehabilitation",4,1,1000000,"$0-$1,000,000",15,0,0.92,1,0,0,0,0,0.52,2.5,1,1.2884615385,2,null,null,null,"Low","Mid","High"]
[null,null,null,null,2,5000000,"$1,000,000 - $5,000,000",11,0,0.71,1,0,0.17,4,0,0.66666999999999998,1,1,2,5,null,null,1,{"$f":"F7","v":5000000},{"$f":"F8","v":25000000},{"$f":"F9","v":25000000}]
[null,null,null,null,3,5000000,"$5,000,000 and up",6,0.25,1.04,2,0,0.41,1,0,0.73076923076919997,2,2.25,4.375,7,null,null,2,{"$f":"F10","v":1000000},{"$f":"F11","v":5000000},{"$f":"F12","v":5000000}]
[null,null,"Other Projects",5,1,500000,"< $500,000",37,0,0.82,1.35,0,0.22,1.35,0,0.68,3,1,1.40625,2.35,null,null,3,{"$f":"F13","v":1000000},{"$f":"F14","v":10000000},{"$f":"F15","v":10000000}]
[null,null,null,null,2,1000000,"$500,000 - $1,000,000",20,0,0.85,1.95,0,0.16,1.95,0,0.63,1.95,0.05,1.5725,3.95,null,null,4,{"$f":"F16","v":1000000},{"$f":"F17","v":5000000},{"$f":"F18","v":5000000}]
[null,null,null,null,3,1000000,"$1,000,000 and up",32,0,0.94,2,0,0.49,2.9,0,0.73,3,0,2.0750000000000002,4.45,null,null,5,{"$f":"F19","v":500000},{"$f":"F20","v":1000000},{"$f":"F21","v":1000000}]
[null,null,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",6,1,0,null,3,null,1,null,null,1.33,null,null,1.67,null,null,2.67,null,null,null,6,{"$f":"F22","v":0},{"$f":"F23","v":0},{"$f":"F24","v":0}]
[null,null,null,null,1,0,null,3,null,1,null,null,1.33,null,null,1.67,null,null,2.67]
[null,null,null,null,1,0,null,3,null,1,null,null,1.33,null,null,1.67,null,null,2.67]
[]
[]
[null,null,null,null,null,null,"Adjustment Factors for Using CEI Consultants"]
[null,null,null,null,null,null,null,"RE",null,"Surveyor",null,"Admin",null,"Inspectors"]
[null,null,null,null,null,null,null,"ST Only","w/Cons","ST Only","w/Cons","ST Only","w/Cons","ST Only","w/Cons",null,null,"CEI","Factor Used"]
[null,null,null,null,null,1,"Road - New Construction / Expansion",0.89678423236513027,1.0750660128253597,1.1435185185186372,0.89562289562307806,0.75568181818182167,1.1776859504131736,0.67857142857141517,1.2337662337661923,null,"RE",{"$f":"IF('FTE Review'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE Review'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,3+R30,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,2,"Road - Rehabilitation / Resurfacing",0.97785276073617977,1.0582822085889392,1.1828571428573624,0.5187969924816106,0.83260960334032175,1.4405010438413872,0.78530386740331526,1.564989822622842,null,"SRV",{"$f":"IF('FTE Review'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE Review'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,5+R31,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,3,"Bridge - New & Replacement",0.92307692307686617,1.0549450549450428,0.47999999999996162,1.3714285714282903,1.3333333333333333,0.76190476190466672,0.8516129032258174,1.1059907834101692,null,"ADM",{"$f":"IF('FTE Review'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE Review'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,7+R32,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,4,"Bridge - Rehabilitation",0.83210483210485187,1.1007371007370184,0.29042904290419164,1.4257425742571999,0.91484184914843303,1.0510948905110102,1.0780141843971207,0.95319148936168663,null,"INS",{"$f":"IF('FTE Review'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE Review'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,9+R33,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,5,"Other Projects",0.90428090428086871,1.1292207792207969,1.162901490702152,0.78008298755188021,1.001210360687611,0.99836601307194761,1.047129391602484,0.93637532133680046,null,null,null,null,null,null,null,"Combined Factor"]
[null,null,null,null,null,6,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,"RE",{"$f":"S30*S38","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRV",{"$f":"S31*S39","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Adjustment Factors for Project Complexity",null,null,null,null,null,null,null,null,null,null,"Complexity Factor",null,null,null,null,"ADM",{"$error":"#N/A"}]
[null,null,null,null,null,null,null,"RE","Surveyor","Admin","Inspectors",null,null,null,null,null,"RE",{"$f":"VLOOKUP('FTE Review'!$E$8,'FTE FactorsRV'!$G$39:$K$41,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$38,1)","v":1},null,null,null,"INS",{"$error":"#N/A"}]
[null,null,null,null,null,null,"Non-Complex",0.92553191489361708,0.54545454545454553,0.89473684210526305,0.77480916030534375,null,null,null,null,null,"SRV",{"$f":"VLOOKUP('FTE Review'!$E$8,'FTE FactorsRV'!$G$39:$K$41,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$39,1)","v":1}]
[null,null,null,null,null,null,"Moderate",0.97872340425531912,1.3636363636363638,0.97368421052631582,0.93511450381679406,null,null,null,null,null,"ADM",{"$f":"VLOOKUP('FTE Review'!$E$8,'FTE FactorsRV'!$G$39:$K$41,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$40,1)","v":1}]
[null,null,null,null,null,null,"Complex",1.3936170212765959,2.6363636363636362,1.5394736842105261,2.2938931297709928,null,null,null,null,null,"INS",{"$f":"VLOOKUP('FTE Review'!$E$8,'FTE FactorsRV'!$G$39:$K$41,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$41,1)","v":1}]

{"sheet":"DOT INPUTRV","index":7,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":true,"merged":[[3,2,3,19],[4,2,5,2],[4,6,5,6],[4,8,4,10],[4,11,4,13],[4,14,4,16],[4,17,4,19],[36,6,36,10],[6,2,8,2],[9,2,11,2],[12,2,14,2],[15,2,17,2],[18,2,20,2],[21,2,23,2],[26,6,26,14],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14]]}
[]
[]
[]
[null,null,"FTE by Project Type and Position",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index Factor"]
[null,null,"Project Type",null,null,null,"Cost Range"," "," Engineer",null,null,"Surveyor",null,null,"Admin Staff",null,null,"Inspectors",null,null,null,"Area",{"$f":"VLOOKUP('FTE Review'!$B$8,'DOT INPUTRV'!$C$7:$D$24,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"N","Low","Avg","High","Low","Avg","High","Low","Avg","High","Low","Avg","High",null,"Row",{"$f":"IF('FTE Review'!$C$8<'DOT INPUTRV'!$W$10,'DOT INPUTRV'!$X$10,IF('FTE Review'!$C$8<'DOT INPUTRV'!$W$11,'DOT INPUTRV'!$X$11,'DOT INPUTRV'!$X$12))","v":{"$error":"#N/A"}}]
[null,null,"Road - New Construction / Expansion",1,1,5000000,"$0-$5,000,000",11,{"$f":"'DOT INPUT'!I7","v":0},{"$f":"'DOT INPUT'!J7","v":0},{"$f":"'DOT INPUT'!K7","v":0},{"$f":"'DOT INPUT'!L7","v":0},{"$f":"'DOT INPUT'!M7","v":0},{"$f":"'DOT INPUT'!N7","v":0},{"$f":"'DOT INPUT'!O7","v":0},{"$f":"'DOT INPUT'!P7","v":0},{"$f":"'DOT INPUT'!Q7","v":0},{"$f":"'DOT INPUT'!R7","v":0},{"$f":"'DOT INPUT'!S7","v":0},{"$f":"'DOT INPUT'!T7","v":0}]
[null,null,null,null,2,25000000,"$5,000,000 - $25,000,000",11,{"$f":"'DOT INPUT'!I8","v":0},{"$f":"'DOT INPUT'!J8","v":0},{"$f":"'DOT INPUT'!K8","v":0},{"$f":"'DOT INPUT'!L8","v":0},{"$f":"'DOT INPUT'!M8","v":0},{"$f":"'DOT INPUT'!N8","v":0},{"$f":"'DOT INPUT'!O8","v":0},{"$f":"'DOT INPUT'!P8","v":0},{"$f":"'DOT INPUT'!Q8","v":0},{"$f":"'DOT INPUT'!R8","v":0},{"$f":"'DOT INPUT'!S8","v":0},{"$f":"'DOT INPUT'!T8","v":0}]
[null,null,null,null,3,25000000,"$25,000,000 and up",8,{"$f":"'DOT INPUT'!I9","v":0},{"$f":"'DOT INPUT'!J9","v":0},{"$f":"'DOT INPUT'!K9","v":0},{"$f":"'DOT INPUT'!L9","v":0},{"$f":"'DOT INPUT'!M9","v":0},{"$f":"'DOT INPUT'!N9","v":0},{"$f":"'DOT INPUT'!O9","v":0},{"$f":"'DOT INPUT'!P9","v":0},{"$f":"'DOT INPUT'!Q9","v":0},{"$f":"'DOT INPUT'!R9","v":0},{"$f":"'DOT INPUT'!S9","v":0},{"$f":"'DOT INPUT'!T9","v":0},null,"Index Cost Factors"]
[null,null,"Road - Rehabilitation / Resurfacing",2,1,1000000,"$0-$1,000,000",45,{"$f":"'DOT INPUT'!I10","v":0},{"$f":"'DOT INPUT'!J10","v":0},{"$f":"'DOT INPUT'!K10","v":0},{"$f":"'DOT INPUT'!L10","v":0},{"$f":"'DOT INPUT'!M10","v":0},{"$f":"'DOT INPUT'!N10","v":0},{"$f":"'DOT INPUT'!O10","v":0},{"$f":"'DOT INPUT'!P10","v":0},{"$f":"'DOT INPUT'!Q10","v":0},{"$f":"'DOT INPUT'!R10","v":0},{"$f":"'DOT INPUT'!S10","v":0},{"$f":"'DOT INPUT'!T10","v":0},null,"Low",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,2,FALSE)","v":{"$error":"#N/A"}},1]
[null,null,null,null,2,5000000,"$1,000,000 - $5,000,000",44,{"$f":"'DOT INPUT'!I11","v":0},{"$f":"'DOT INPUT'!J11","v":0},{"$f":"'DOT INPUT'!K11","v":0},{"$f":"'DOT INPUT'!L11","v":0},{"$f":"'DOT INPUT'!M11","v":0},{"$f":"'DOT INPUT'!N11","v":0},{"$f":"'DOT INPUT'!O11","v":0},{"$f":"'DOT INPUT'!P11","v":0},{"$f":"'DOT INPUT'!Q11","v":0},{"$f":"'DOT INPUT'!R11","v":0},{"$f":"'DOT INPUT'!S11","v":0},{"$f":"'DOT INPUT'!T11","v":0},null,"Mid",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,3,FALSE)","v":{"$error":"#N/A"}},2]
[null,null,null,null,3,5000000,"$5,000,000 and up",25,{"$f":"'DOT INPUT'!I12","v":0},{"$f":"'DOT INPUT'!J12","v":0},{"$f":"'DOT INPUT'!K12","v":0},{"$f":"'DOT INPUT'!L12","v":0},{"$f":"'DOT INPUT'!M12","v":0},{"$f":"'DOT INPUT'!N12","v":0},{"$f":"'DOT INPUT'!O12","v":0},{"$f":"'DOT INPUT'!P12","v":0},{"$f":"'DOT INPUT'!Q12","v":0},{"$f":"'DOT INPUT'!R12","v":0},{"$f":"'DOT INPUT'!S12","v":0},{"$f":"'DOT INPUT'!T12","v":0},null,"High",{"$f":"VLOOKUP($W$5,$W$17:$Z$22,4,FALSE)","v":{"$error":"#N/A"}},3]
[null,null,"Bridge - New & Replacement",3,1,1000000,"$0-$1,000,000",6,{"$f":"'DOT INPUT'!I13","v":0},{"$f":"'DOT INPUT'!J13","v":0},{"$f":"'DOT INPUT'!K13","v":0},{"$f":"'DOT INPUT'!L13","v":0},{"$f":"'DOT INPUT'!M13","v":0},{"$f":"'DOT INPUT'!N13","v":0},{"$f":"'DOT INPUT'!O13","v":0},{"$f":"'DOT INPUT'!P13","v":0},{"$f":"'DOT INPUT'!Q13","v":0},{"$f":"'DOT INPUT'!R13","v":0},{"$f":"'DOT INPUT'!S13","v":0},{"$f":"'DOT INPUT'!T13","v":0}]
[null,null,null,null,2,10000000,"$1,000,000 - $10,000,000",15,{"$f":"'DOT INPUT'!I14","v":0},{"$f":"'DOT INPUT'!J14","v":0},{"$f":"'DOT INPUT'!K14","v":0},{"$f":"'DOT INPUT'!L14","v":0},{"$f":"'DOT INPUT'!M14","v":0},{"$f":"'DOT INPUT'!N14","v":0},{"$f":"'DOT INPUT'!O14","v":0},{"$f":"'DOT INPUT'!P14","v":0},{"$f":"'DOT INPUT'!Q14","v":0},{"$f":"'DOT INPUT'!R14","v":0},{"$f":"'DOT INPUT'!S14","v":0},{"$f":"'DOT INPUT'!T14","v":0}]
[null,null,null,null,3,10000000,"$10,000,000 and up",8,{"$f":"'DOT INPUT'!I15","v":0},{"$f":"'DOT INPUT'!J15","v":0},{"$f":"'DOT INPUT'!K15","v":0},{"$f":"'DOT INPUT'!L15","v":0},{"$f":"'DOT INPUT'!M15","v":0},{"$f":"'DOT INPUT'!N15","v":0},{"$f":"'DOT INPUT'!O15","v":0},{"$f":"'DOT INPUT'!P15","v":0},{"$f":"'DOT INPUT'!Q15","v":0},{"$f":"'DOT INPUT'!R15","v":0},{"$f":"'DOT INPUT'!S15","v":0},{"$f":"'DOT INPUT'!T15","v":0}]
[null,null,"Bridge - Rehabilitation",4,1,1000000,"$0-$1,000,000",15,{"$f":"'DOT INPUT'!I16","v":0},{"$f":"'DOT INPUT'!J16","v":0},{"$f":"'DOT INPUT'!K16","v":0},{"$f":"'DOT INPUT'!L16","v":0},{"$f":"'DOT INPUT'!M16","v":0},{"$f":"'DOT INPUT'!N16","v":0},{"$f":"'DOT INPUT'!O16","v":0},{"$f":"'DOT INPUT'!P16","v":0},{"$f":"'DOT INPUT'!Q16","v":0},{"$f":"'DOT INPUT'!R16","v":0},{"$f":"'DOT INPUT'!S16","v":0},{"$f":"'DOT INPUT'!T16","v":0},null,null,null,"Low","Mid","High"]
[null,null,null,null,2,5000000,"$1,000,000 - $5,000,000",11,{"$f":"'DOT INPUT'!I17","v":0},{"$f":"'DOT INPUT'!J17","v":0},{"$f":"'DOT INPUT'!K17","v":0},{"$f":"'DOT INPUT'!L17","v":0},{"$f":"'DOT INPUT'!M17","v":0},{"$f":"'DOT INPUT'!N17","v":0},{"$f":"'DOT INPUT'!O17","v":0},{"$f":"'DOT INPUT'!P17","v":0},{"$f":"'DOT INPUT'!Q17","v":0},{"$f":"'DOT INPUT'!R17","v":0},{"$f":"'DOT INPUT'!S17","v":0},{"$f":"'DOT INPUT'!T17","v":0},null,null,1,{"$f":"F7","v":5000000},{"$f":"F8","v":25000000},{"$f":"F9","v":25000000}]
[null,null,null,null,3,5000000,"$5,000,000 and up",6,{"$f":"'DOT INPUT'!I18","v":0},{"$f":"'DOT INPUT'!J18","v":0},{"$f":"'DOT INPUT'!K18","v":0},{"$f":"'DOT INPUT'!L18","v":0},{"$f":"'DOT INPUT'!M18","v":0},{"$f":"'DOT INPUT'!N18","v":0},{"$f":"'DOT INPUT'!O18","v":0},{"$f":"'DOT INPUT'!P18","v":0},{"$f":"'DOT INPUT'!Q18","v":0},{"$f":"'DOT INPUT'!R18","v":0},{"$f":"'DOT INPUT'!S18","v":0},{"$f":"'DOT INPUT'!T18","v":0},null,null,2,{"$f":"F10","v":1000000},{"$f":"F11","v":5000000},{"$f":"F12","v":5000000}]
[null,null,"Other Projects",5,1,500000,"< $500,000",37,{"$f":"'DOT INPUT'!I19","v":0},{"$f":"'DOT INPUT'!J19","v":0},{"$f":"'DOT INPUT'!K19","v":0},{"$f":"'DOT INPUT'!L19","v":0},{"$f":"'DOT INPUT'!M19","v":0},{"$f":"'DOT INPUT'!N19","v":0},{"$f":"'DOT INPUT'!O19","v":0},{"$f":"'DOT INPUT'!P19","v":0},{"$f":"'DOT INPUT'!Q19","v":0},{"$f":"'DOT INPUT'!R19","v":0},{"$f":"'DOT INPUT'!S19","v":0},{"$f":"'DOT INPUT'!T19","v":0},null,null,3,{"$f":"F13","v":1000000},{"$f":"F14","v":10000000},{"$f":"F15","v":10000000}]
[null,null,null,null,2,1000000,"$500,000 - $1,000,000",20,{"$f":"'DOT INPUT'!I20","v":0},{"$f":"'DOT INPUT'!J20","v":0},{"$f":"'DOT INPUT'!K20","v":0},{"$f":"'DOT INPUT'!L20","v":0},{"$f":"'DOT INPUT'!M20","v":0},{"$f":"'DOT INPUT'!N20","v":0},{"$f":"'DOT INPUT'!O20","v":0},{"$f":"'DOT INPUT'!P20","v":0},{"$f":"'DOT INPUT'!Q20","v":0},{"$f":"'DOT INPUT'!R20","v":0},{"$f":"'DOT INPUT'!S20","v":0},{"$f":"'DOT INPUT'!T20","v":0},null,null,4,{"$f":"F16","v":1000000},{"$f":"F17","v":5000000},{"$f":"F18","v":5000000}]
[null,null,null,null,3,1000000,"$1,000,000 and up",32,{"$f":"'DOT INPUT'!I21","v":0},{"$f":"'DOT INPUT'!J21","v":0},{"$f":"'DOT INPUT'!K21","v":0},{"$f":"'DOT INPUT'!L21","v":0},{"$f":"'DOT INPUT'!M21","v":0},{"$f":"'DOT INPUT'!N21","v":0},{"$f":"'DOT INPUT'!O21","v":0},{"$f":"'DOT INPUT'!P21","v":0},{"$f":"'DOT INPUT'!Q21","v":0},{"$f":"'DOT INPUT'!R21","v":0},{"$f":"'DOT INPUT'!S21","v":0},{"$f":"'DOT INPUT'!T21","v":0},null,null,5,{"$f":"F19","v":500000},{"$f":"F20","v":1000000},{"$f":"F21","v":1000000}]
[null,null,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",6,1,0,"< $500,000",3,{"$f":"'DOT INPUT'!I22","v":0},{"$f":"'DOT INPUT'!J22","v":0},{"$f":"'DOT INPUT'!K22","v":0},{"$f":"'DOT INPUT'!L22","v":0},{"$f":"'DOT INPUT'!M22","v":0},{"$f":"'DOT INPUT'!N22","v":0},{"$f":"'DOT INPUT'!O22","v":0},{"$f":"'DOT INPUT'!P22","v":0},{"$f":"'DOT INPUT'!Q22","v":0},{"$f":"'DOT INPUT'!R22","v":0},{"$f":"'DOT INPUT'!S22","v":0},{"$f":"'DOT INPUT'!T22","v":0},null,null,6,{"$f":"F22","v":0},{"$f":"F23","v":0},{"$f":"F24","v":0}]
[null,null,null,null,1,0,"$500,000 - $1,000,000",3,{"$f":"'DOT INPUT'!I23","v":0},{"$f":"'DOT INPUT'!J23","v":0},{"$f":"'DOT INPUT'!K23","v":0},{"$f":"'DOT INPUT'!L23","v":0},{"$f":"'DOT INPUT'!M23","v":0},{"$f":"'DOT INPUT'!N23","v":0},{"$f":"'DOT INPUT'!O23","v":0},{"$f":"'DOT INPUT'!P23","v":0},{"$f":"'DOT INPUT'!Q23","v":0},{"$f":"'DOT INPUT'!R23","v":0},{"$f":"'DOT INPUT'!S23","v":0},{"$f":"'DOT INPUT'!T23","v":0}]
[null,null,null,null,1,0,"$1,000,000 and up",3,{"$f":"'DOT INPUT'!I24","v":0},{"$f":"'DOT INPUT'!J24","v":0},{"$f":"'DOT INPUT'!K24","v":0},{"$f":"'DOT INPUT'!L24","v":0},{"$f":"'DOT INPUT'!M24","v":0},{"$f":"'DOT INPUT'!N24","v":0},{"$f":"'DOT INPUT'!O24","v":0},{"$f":"'DOT INPUT'!P24","v":0},{"$f":"'DOT INPUT'!Q24","v":0},{"$f":"'DOT INPUT'!R24","v":0},{"$f":"'DOT INPUT'!S24","v":0},{"$f":"'DOT INPUT'!T24","v":0}]
[]
[]
[null,null,null,null,null,null,"Adjustment Factors for Using CEI Consultants"]
[null,null,null,null,null,null,null,"Engineer",null,"Surveyor",null,"Admin",null,"Inspectors"]
[null,null,null,null,null,null,null,"ST Only","w/Cons","ST Only","w/Cons","ST Only","w/Cons","ST Only","w/Cons",null,null,"CEI","Factor Used"]
[null,null,null,null,null,1,"Road - New Construction / Expansion",{"$f":"'DOT INPUT'!H30","v":0.89678423236513027},{"$f":"'DOT INPUT'!I30","v":1.0750660128253597},{"$f":"'DOT INPUT'!J30","v":1.1435185185186372},{"$f":"'DOT INPUT'!K30","v":0.89562289562307806},{"$f":"'DOT INPUT'!L30","v":0.75568181818182167},{"$f":"'DOT INPUT'!M30","v":1.1776859504131736},{"$f":"'DOT INPUT'!N30","v":0.67857142857141517},{"$f":"'DOT INPUT'!O30","v":1.2337662337661923},null,"RE",{"$f":"IF('FTE Review'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE Review'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,3+R30,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,2,"Road - Rehabilitation / Resurfacing",{"$f":"'DOT INPUT'!H31","v":0.97785276073617977},{"$f":"'DOT INPUT'!I31","v":1.0582822085889392},{"$f":"'DOT INPUT'!J31","v":1.1828571428573624},{"$f":"'DOT INPUT'!K31","v":0.5187969924816106},{"$f":"'DOT INPUT'!L31","v":0.83260960334032175},{"$f":"'DOT INPUT'!M31","v":1.4405010438413872},{"$f":"'DOT INPUT'!N31","v":0.78530386740331526},{"$f":"'DOT INPUT'!O31","v":1.564989822622842},null,"SRV",{"$f":"IF('FTE Review'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE Review'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,5+R31,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,3,"Bridge - New & Replacement",{"$f":"'DOT INPUT'!H32","v":0.92307692307686617},{"$f":"'DOT INPUT'!I32","v":1.0549450549450428},{"$f":"'DOT INPUT'!J32","v":0.47999999999996162},{"$f":"'DOT INPUT'!K32","v":1.3714285714282903},{"$f":"'DOT INPUT'!L32","v":1.3333333333333333},{"$f":"'DOT INPUT'!M32","v":0.76190476190466672},{"$f":"'DOT INPUT'!N32","v":0.8516129032258174},{"$f":"'DOT INPUT'!O32","v":1.1059907834101692},null,"ADM",{"$f":"IF('FTE Review'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE Review'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,7+R32,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,4,"Bridge - Rehabilitation",{"$f":"'DOT INPUT'!H33","v":0.83210483210485187},{"$f":"'DOT INPUT'!I33","v":1.1007371007370184},{"$f":"'DOT INPUT'!J33","v":0.29042904290419164},{"$f":"'DOT INPUT'!K33","v":1.4257425742571999},{"$f":"'DOT INPUT'!L33","v":0.91484184914843303},{"$f":"'DOT INPUT'!M33","v":1.0510948905110102},{"$f":"'DOT INPUT'!N33","v":1.0780141843971207},{"$f":"'DOT INPUT'!O33","v":0.95319148936168663},null,"INS",{"$f":"IF('FTE Review'!$G$8=\"Yes\", 1,0)","v":0},{"$f":"IF('FTE Review'!$G$8=\"\",1,VLOOKUP($W$5,$F$30:$O$35,9+R33,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,5,"Other Projects",{"$f":"'DOT INPUT'!H34","v":0.90428090428086871},{"$f":"'DOT INPUT'!I34","v":1.1292207792207969},{"$f":"'DOT INPUT'!J34","v":1.162901490702152},{"$f":"'DOT INPUT'!K34","v":0.78008298755188021},{"$f":"'DOT INPUT'!L34","v":1.001210360687611},{"$f":"'DOT INPUT'!M34","v":0.99836601307194761},{"$f":"'DOT INPUT'!N34","v":1.047129391602484},{"$f":"'DOT INPUT'!O34","v":0.93637532133680046},null,null,null,null,null,null,null,"Combined Factor"]
[null,null,null,null,null,6,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",{"$f":"'DOT INPUT'!H35","v":1},{"$f":"'DOT INPUT'!I35","v":1},{"$f":"'DOT INPUT'!J35","v":1},{"$f":"'DOT INPUT'!K35","v":1},{"$f":"'DOT INPUT'!L35","v":1},{"$f":"'DOT INPUT'!M35","v":1},{"$f":"'DOT INPUT'!N35","v":1},{"$f":"'DOT INPUT'!O35","v":1},null,null,null,null,null,null,null,"RE",{"$f":"S30*S38","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRV",{"$f":"S31*S39","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Adjustment Factors for Project Complexity",null,null,null,null,null,null,null,null,null,null,"Complexity Factor",null,null,null,null,"ADM",{"$error":"#N/A"}]
[null,null,null,null,null,null,null,"Eng.","Surveyor","Admin","Inspectors",null,null,null,null,null,"RE",{"$f":"VLOOKUP('FTE Review'!$E$8,'DOT INPUTRV'!$G$39:$K$41,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$38,1)","v":1},null,null,null,"INS",{"$error":"#N/A"}]
[null,null,null,null,null,null,"Non-Complex",{"$f":"'DOT INPUT'!H39","v":0.92553191489361708},{"$f":"'DOT INPUT'!I39","v":0.54545454545454553},{"$f":"'DOT INPUT'!J39","v":0.89473684210526305},{"$f":"'DOT INPUT'!K39","v":0.77480916030534375},null,null,null,null,null,"SRV",{"$f":"VLOOKUP('FTE Review'!$E$8,'DOT INPUTRV'!$G$39:$K$41,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$39,1)","v":1}]
[null,null,null,null,null,null,"Moderate",{"$f":"'DOT INPUT'!H40","v":0.97872340425531912},{"$f":"'DOT INPUT'!I40","v":1.3636363636363638},{"$f":"'DOT INPUT'!J40","v":0.97368421052631582},{"$f":"'DOT INPUT'!K40","v":0.93511450381679406},null,null,null,null,null,"ADM",{"$f":"VLOOKUP('FTE Review'!$E$8,'DOT INPUTRV'!$G$39:$K$41,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$40,1)","v":1}]
[null,null,null,null,null,null,"Complex",{"$f":"'DOT INPUT'!H41","v":1.3936170212765959},{"$f":"'DOT INPUT'!I41","v":2.6363636363636362},{"$f":"'DOT INPUT'!J41","v":1.5394736842105261},{"$f":"'DOT INPUT'!K41","v":2.2938931297709928},null,null,null,null,null,"INS",{"$f":"VLOOKUP('FTE Review'!$E$8,'DOT INPUTRV'!$G$39:$K$41,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR($R$41,1)","v":1}]

{"sheet":"FTE Review","index":8,"n_rows":27,"n_cols":27,"rows_kept":27,"cut":false,"hidden":true,"merged":[[7,2,7,3],[7,4,7,5],[14,4,15,6],[16,4,17,6],[3,1,3,6],[4,2,4,3],[4,4,4,5],[5,2,5,3],[5,4,5,5],[6,2,6,3],[6,4,6,5]]}
[]
[null,"Project Level FTE Review "]
[]
[null,"Project Description"]
[null,"Project Name","Anticipated Start Date",null,"Anticipated Completion Date"]
[null,{"$f":"INDIRECT(\"'STF ALLOC'!C\"&'STF ALLOC'!$N$3)","v":0},{"$f":"INDIRECT(\"'STF ALLOC'!H\"&'STF ALLOC'!$N$3)","v":"00:00:00"},null,{"$f":"INDIRECT(\"'STF ALLOC'!I\"&'STF ALLOC'!$N$3)","v":"00:00:00"},null,null,null,null,null,null,null,1]
[null,"Project Type","Construction Estimate",null,"Complexity",null,"Use of CEI",null,null,null,null,null,{"$f":"IF($M$6=1, \"FTE Factors\", \"DOT INPUT\")","v":"FTE Factors"}]
[null,{"$f":"INDIRECT(\"'STF ALLOC'!D\"&'STF ALLOC'!$N$3)","v":0},{"$f":"INDIRECT(\"'STF ALLOC'!L\"&'STF ALLOC'!$N$3)","v":0},null,{"$f":"INDIRECT(\"'STF ALLOC'!M\"&'STF ALLOC'!$N$3)","v":0},null,{"$f":"INDIRECT(\"'STF ALLOC'!N\"&'STF ALLOC'!$N$3)","v":0}]
[]
[null,"Project Level FTE ","Resident Engineer","Surveyor","Admin Staff","Inspectors","Total Insp. Staff & RE",null,null,null,null,null,null,null,"Project Level FTE ","Resident Engineer","Surveyor","Admin Staff","Inspectors","Total Insp. Staff & RE",null,"Project Level FTE ","Resident Engineer","Surveyor","Admin Staff","Inspectors","Total Insp. Staff & RE"]
[null,"Minimum",{"$f":"IF($M$7=\"FTE Factors\", P11,W11)","v":{"$error":"#N/A"}},{"$f":"IF($M$7=\"FTE Factors\", Q11,X11)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"F11+C11","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Minimum",{"$f":"INDEX(('FTE FactorsRV'!$I$7:$K$9,'FTE FactorsRV'!$I$10:$K$12,'FTE FactorsRV'!$I$13:$K$15,'FTE FactorsRV'!$I$16:$K$18,'FTE FactorsRV'!$I$19:$K$21, 'FTE FactorsRV'!$I$22:$K$24), 'FTE FactorsRV'!$W$6, 1,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$L$7:$N$9,'FTE FactorsRV'!$L$10:$N$12,'FTE FactorsRV'!$L$13:$N$15,'FTE FactorsRV'!$L$16:$N$18,'FTE FactorsRV'!$L$19:$N$21,'FTE FactorsRV'!$L$22:$N$24), 'FTE FactorsRV'!$W$6, 1,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$O$7:$Q$9,'FTE FactorsRV'!$O$10:$Q$12,'FTE FactorsRV'!$O$13:$Q$15,'FTE FactorsRV'!$O$16:$Q$18,'FTE FactorsRV'!$O$19:$Q$21,'FTE FactorsRV'!$O$22:$Q$24), 'FTE FactorsRV'!$W$6, 1,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$R$7:$T$9,'FTE FactorsRV'!$R$10:$T$12,'FTE FactorsRV'!$R$13:$T$15,'FTE FactorsRV'!$R$16:$T$18,'FTE FactorsRV'!$R$19:$T$21,'FTE FactorsRV'!$R$22:$T$24), 'FTE FactorsRV'!$W$6, 1,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$38","v":{"$error":"#N/A"}},{"$f":"S11+P11","v":{"$error":"#N/A"}},null,"Minimum",{"$f":"INDEX(('DOT INPUTRV'!$I$7:$K$9,'DOT INPUTRV'!$I$10:$K$12,'DOT INPUTRV'!$I$13:$K$15,'DOT INPUTRV'!$I$16:$K$18,'DOT INPUTRV'!$I$19:$K$21, 'DOT INPUTRV'!$I$22:$K$24), 'DOT INPUTRV'!$W$6, 1,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$L$7:$N$9,'DOT INPUTRV'!$L$10:$N$12,'DOT INPUTRV'!$L$13:$N$15,'DOT INPUTRV'!$L$16:$N$18,'DOT INPUTRV'!$L$19:$N$21,'DOT INPUTRV'!$L$22:$N$24), 'DOT INPUTRV'!$W$6, 1,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$O$7:$Q$9,'DOT INPUTRV'!$O$10:$Q$12,'DOT INPUTRV'!$O$13:$Q$15,'DOT INPUTRV'!$O$16:$Q$18,'DOT INPUTRV'!$O$19:$Q$21,'DOT INPUTRV'!$O$22:$Q$24), 'DOT INPUTRV'!$W$6, 1,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$R$7:$T$9,'DOT INPUTRV'!$R$10:$T$12,'DOT INPUTRV'!$R$13:$T$15,'DOT INPUTRV'!$R$16:$T$18,'DOT INPUTRV'!$R$19:$T$21,'DOT INPUTRV'!$R$22:$T$24), 'DOT INPUTRV'!$W$6, 1,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$38","v":{"$error":"#N/A"}},{"$f":"Z11+W11","v":{"$error":"#N/A"}}]
[null,"Average",{"$f":"IF($M$7=\"FTE Factors\", P12,W12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"F12+C12","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Average",{"$f":"INDEX(('FTE FactorsRV'!$I$7:$K$9,'FTE FactorsRV'!$I$10:$K$12,'FTE FactorsRV'!$I$13:$K$15,'FTE FactorsRV'!$I$16:$K$18,'FTE FactorsRV'!$I$19:$K$21, 'FTE FactorsRV'!$I$22:$K$24), 'FTE FactorsRV'!$W$6, 2,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$L$7:$N$9,'FTE FactorsRV'!$L$10:$N$12,'FTE FactorsRV'!$L$13:$N$15,'FTE FactorsRV'!$L$16:$N$18,'FTE FactorsRV'!$L$19:$N$21,'FTE FactorsRV'!$L$22:$N$24), 'FTE FactorsRV'!$W$6, 2,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$O$7:$Q$9,'FTE FactorsRV'!$O$10:$Q$12,'FTE FactorsRV'!$O$13:$Q$15,'FTE FactorsRV'!$O$16:$Q$18,'FTE FactorsRV'!$O$19:$Q$21,'FTE FactorsRV'!$O$22:$Q$24), 'FTE FactorsRV'!$W$6, 2,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$R$7:$T$9,'FTE FactorsRV'!$R$10:$T$12,'FTE FactorsRV'!$R$13:$T$15,'FTE FactorsRV'!$R$16:$T$18,'FTE FactorsRV'!$R$19:$T$21,'FTE FactorsRV'!$R$22:$T$24), 'FTE FactorsRV'!$W$6, 2,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$38","v":{"$error":"#N/A"}},{"$f":"S12+P12","v":{"$error":"#N/A"}},null,"Average",{"$f":"INDEX(('DOT INPUTRV'!$I$7:$K$9,'DOT INPUTRV'!$I$10:$K$12,'DOT INPUTRV'!$I$13:$K$15,'DOT INPUTRV'!$I$16:$K$18,'DOT INPUTRV'!$I$19:$K$21, 'DOT INPUTRV'!$I$22:$K$24), 'DOT INPUTRV'!$W$6, 2,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$L$7:$N$9,'DOT INPUTRV'!$L$10:$N$12,'DOT INPUTRV'!$L$13:$N$15,'DOT INPUTRV'!$L$16:$N$18,'DOT INPUTRV'!$L$19:$N$21,'DOT INPUTRV'!$L$22:$N$24), 'DOT INPUTRV'!$W$6, 2,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$O$7:$Q$9,'DOT INPUTRV'!$O$10:$Q$12,'DOT INPUTRV'!$O$13:$Q$15,'DOT INPUTRV'!$O$16:$Q$18,'DOT INPUTRV'!$O$19:$Q$21,'DOT INPUTRV'!$O$22:$Q$24), 'DOT INPUTRV'!$W$6, 2,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$R$7:$T$9,'DOT INPUTRV'!$R$10:$T$12,'DOT INPUTRV'!$R$13:$T$15,'DOT INPUTRV'!$R$16:$T$18,'DOT INPUTRV'!$R$19:$T$21,'DOT INPUTRV'!$R$22:$T$24), 'DOT INPUTRV'!$W$6, 2,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$38","v":{"$error":"#N/A"}},{"$f":"Z12+W12","v":{"$error":"#N/A"}}]
[null,"Maximum",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"F13+C13","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Maximum",{"$f":"INDEX(('FTE FactorsRV'!$I$7:$K$9,'FTE FactorsRV'!$I$10:$K$12,'FTE FactorsRV'!$I$13:$K$15,'FTE FactorsRV'!$I$16:$K$18,'FTE FactorsRV'!$I$19:$K$21, 'FTE FactorsRV'!$I$22:$K$24), 'FTE FactorsRV'!$W$6, 3,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$L$7:$N$9,'FTE FactorsRV'!$L$10:$N$12,'FTE FactorsRV'!$L$13:$N$15,'FTE FactorsRV'!$L$16:$N$18,'FTE FactorsRV'!$L$19:$N$21,'FTE FactorsRV'!$L$22:$N$24), 'FTE FactorsRV'!$W$6, 3,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$O$7:$Q$9,'FTE FactorsRV'!$O$10:$Q$12,'FTE FactorsRV'!$O$13:$Q$15,'FTE FactorsRV'!$O$16:$Q$18,'FTE FactorsRV'!$O$19:$Q$21,'FTE FactorsRV'!$O$22:$Q$24), 'FTE FactorsRV'!$W$6, 3,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('FTE FactorsRV'!$R$7:$T$9,'FTE FactorsRV'!$R$10:$T$12,'FTE FactorsRV'!$R$13:$T$15,'FTE FactorsRV'!$R$16:$T$18,'FTE FactorsRV'!$R$19:$T$21,'FTE FactorsRV'!$R$22:$T$24), 'FTE FactorsRV'!$W$6, 3,'FTE FactorsRV'!$W$5)*'FTE FactorsRV'!$X$38","v":{"$error":"#N/A"}},{"$f":"S13+P13","v":{"$error":"#N/A"}},null,"Maximum",{"$f":"INDEX(('DOT INPUTRV'!$I$7:$K$9,'DOT INPUTRV'!$I$10:$K$12,'DOT INPUTRV'!$I$13:$K$15,'DOT INPUTRV'!$I$16:$K$18,'DOT INPUTRV'!$I$19:$K$21, 'DOT INPUTRV'!$I$22:$K$24), 'DOT INPUTRV'!$W$6, 3,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$35","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$L$7:$N$9,'DOT INPUTRV'!$L$10:$N$12,'DOT INPUTRV'!$L$13:$N$15,'DOT INPUTRV'!$L$16:$N$18,'DOT INPUTRV'!$L$19:$N$21,'DOT INPUTRV'!$L$22:$N$24), 'DOT INPUTRV'!$W$6, 3,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$36","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$O$7:$Q$9,'DOT INPUTRV'!$O$10:$Q$12,'DOT INPUTRV'!$O$13:$Q$15,'DOT INPUTRV'!$O$16:$Q$18,'DOT INPUTRV'!$O$19:$Q$21,'DOT INPUTRV'!$O$22:$Q$24), 'DOT INPUTRV'!$W$6, 3,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$37","v":{"$error":"#N/A"}},{"$f":"INDEX(('DOT INPUTRV'!$R$7:$T$9,'DOT INPUTRV'!$R$10:$T$12,'DOT INPUTRV'!$R$13:$T$15,'DOT INPUTRV'!$R$16:$T$18,'DOT INPUTRV'!$R$19:$T$21,'DOT INPUTRV'!$R$22:$T$24), 'DOT INPUTRV'!$W$6, 3,'DOT INPUTRV'!$W$5)*'DOT INPUTRV'!$X$38","v":{"$error":"#N/A"}},{"$f":"Z13+W13","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"Which dataset would you like to use for estimating staffing needs for this project?"]
[]
[]
[null,"Avegerage FTE Requirement by Position and Project Type"]
[]
[null,"Project Type","Project Count ","Engineer","Surveyor","Sr. Inspector","Inter. Inspector","Jr. Inspector","Admin","Total Insp. Staff & Eng"]
[null,"Road - New Construction / Expansion",19,1.27,0.71,1.69,1.95,0.63,1.1599999999999999,{"$f":"SUM(D21,F21,G21,H21)","v":5.54}]
[null,"Road - Rehabilitation / Resurfacing",69,0.94,0.2,0.9,1.01,0.71,0.69,{"$f":"SUM(D22,F22,G22,H22)","v":3.5599999999999996}]
[null,"Bridge - New & Replacement",12,1.08,0.42,1.17,0.92,0.5,0.75,{"$f":"SUM(D23,F23,G23,H23)","v":3.67}]
[null,"Bridge - Rehabilitation",24,0.85,0.42,0.81,0.92,0.23,0.56999999999999995,2.81]
[null,"Other Projects",47,0.82,0.26,0.68,0.66,0.32,0.65,2.48]
[null,"Special Structures (Rest Areas, Weigh Stations, Toll Stations, etc.)",3,1,1.33,0.67,1.67,0.33,1.67,{"$f":"SUM(D26,F26,G26,H26)","v":3.67}]
[null,"All",{"$f":"SUM(C21:C26)","v":174},{"$f":"SUMPRODUCT($C$21:$C$26,D21:D26)/$C$27","v":0.94189655172413789},0.3368965517241379,0.92908045977011489,1.0108620689655172,0.50867816091954021,0.7350000000000001,3.3905172413793108]