{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Recap","Cap Devel CBE Summary","Cap Devel CBE Details","DFCM Fee Schedule","HPBS Consultants","Contingency","Location Factors","County Seat Distances","UofU PDC Fee Schedule","Drop Downs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"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":"Recap","index":0,"n_rows":114,"n_cols":12,"rows_kept":114,"cut":false,"hidden":false,"merged":[[0,5,0,7],[0,0,0,4],[80,16360,80,16367],[80,16368,80,16375],[80,16376,80,16383],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,6,43,7],[80,16320,80,16327],[80,16328,80,16335],[80,16336,80,16343],[80,16344,80,16351],[80,16352,80,16359],[80,16280,80,16287],[80,16288,80,16295],[80,16296,80,16303],[80,16304,80,16311],[80,16312,80,16319],[80,16240,80,16247],[80,16248,80,16255],[80,16256,80,16263],[80,16264,80,16271],[80,16272,80,16279],[80,16200,80,16207],[80,16208,80,16215],[80,16216,80,16223],[80,16224,80,16231],[80,16232,80,16239],[80,16160,80,16167],[80,16168,80,16175],[80,16176,80,16183],[80,16184,80,16191],[80,16192,80,16199],[80,16120,80,16127],[80,16128,80,16135],[80,16136,80,16143],[80,16144,80,16151],[80,16152,80,16159],[80,16080,80,16087],[80,16088,80,16095],[80,16096,80,16103],[80,16104,80,16111],[80,16112,80,16119],[80,16040,80,16047],[80,16048,80,16055],[80,16056,80,16063],[80,16064,80,16071],[80,16072,80,16079],[80,16000,80,16007],[80,16008,80,16015],[80,16016,80,16023],[80,16024,80,16031],[80,16032,80,16039],[80,15960,80,15967],[80,15968,80,15975],[80,15976,80,15983],[80,15984,80,15991],[80,15992,80,15999],[80,15920,80,15927],[80,15928,80,15935],[80,15936,80,15943],[80,15944,80,15951],[80,15952,80,15959],[80,15880,80,15887],[80,15888,80,15895],[80,15896,80,15903],[80,15904,80,15911],[80,15912,80,15919],[80,15840,80,15847],[80,15848,80,15855],[80,15856,80,15863],[80,15864,80,15871],[80,15872,80,15879],[80,15800,80,15807],[80,15808,80,15815],[80,15816,80,15823],[80,15824,80,15831],[80,15832,80,15839],[80,15760,80,15767],[80,15768,80,15775],[80,15776,80,15783],[80,15784,80,15791],[80,15792,80,15799],[80,15720,80,15727],[80,15728,80,15735],[80,15736,80,15743],[80,15744,80,15751],[80,15752,80,15759],[80,15680,80,15687],[80,15688,80,15695],[80,15696,80,15703],[80,15704,80,15711],[80,15712,80,15719],[80,15640,80,15647],[80,15648,80,15655],[80,15656,80,15663],[80,15664,80,15671],[80,15672,80,15679],[80,15600,80,15607],[80,15608,80,15615],[80,15616,80,15623],[80,15624,80,15631],[80,15632,80,15639],[80,15560,80,15567],[80,15568,80,15575],[80,15576,80,15583],[80,15584,80,15591],[80,15592,80,15599],[80,15520,80,15527],[80,15528,80,15535],[80,15536,80,15543],[80,15544,80,15551],[80,15552,80,15559],[80,15480,80,15487],[80,15488,80,15495],[80,15496,80,15503],[80,15504,80,15511],[80,15512,80,15519],[80,15440,80,15447],[80,15448,80,15455],[80,15456,80,15463],[80,15464,80,15471],[80,15472,80,15479],[80,15400,80,15407],[80,15408,80,15415],[80,15416,80,15423],[80,15424,80,15431],[80,15432,80,15439],[80,15360,80,15367],[80,15368,80,15375],[80,15376,80,15383],[80,15384,80,15391],[80,15392,80,15399],[80,15320,80,15327],[80,15328,80,15335],[80,15336,80,15343],[80,15344,80,15351],[80,15352,80,15359],[80,15280,80,15287],[80,15288,80,15295],[80,15296,80,15303],[80,15304,80,15311],[80,15312,80,15319],[80,15240,80,15247],[80,15248,80,15255],[80,15256,80,15263],[80,15264,80,15271],[80,15272,80,15279],[80,15200,80,15207],[80,15208,80,15215],[80,15216,80,15223],[80,15224,80,15231],[80,15232,80,15239],[80,15160,80,15167],[80,15168,80,15175],[80,15176,80,15183],[80,15184,80,15191],[80,15192,80,15199],[80,15120,80,15127],[80,15128,80,15135],[80,15136,80,15143],[80,15144,80,15151],[80,15152,80,15159],[80,15080,80,15087],[80,15088,80,15095],[80,15096,80,15103],[80,15104,80,15111],[80,15112,80,15119],[80,15040,80,15047],[80,15048,80,15055],[80,15056,80,15063],[80,15064,80,15071],[80,15072,80,15079],[80,15000,80,15007],[80,15008,80,15015],[80,15016,80,15023],[80,15024,80,15031],[80,15032,80,15039],[80,14960,80,14967],[80,14968,80,14975],[80,14976,80,14983],[80,14984,80,14991],[80,14992,80,14999],[80,14920,80,14927],[80,14928,80,14935],[80,14936,80,14943],[80,14944,80,14951],[80,14952,80,14959],[80,14880,80,14887],[80,14888,80,14895],[80,14896,80,14903],[80,14904,80,14911],[80,14912,80,14919],[80,14840,80,14847],[80,14848,80,14855],[80,14856,80,14863],[80,14864,80,14871],[80,14872,80,14879],[80,14800,80,14807],[80,14808,80,14815],[80,14816,80,14823],[80,14824,80,14831],[80,14832,80,14839],[80,14760,80,14767],[80,14768,80,14775],[80,14776,80,14783],[80,14784,80,14791],[80,14792,80,14799],[80,14720,80,14727],[80,14728,80,14735],[80,14736,80,14743],[80,14744,80,14751],[80,14752,80,14759],[80,14680,80,14687],[80,14688,80,14695],[80,14696,80,14703],[80,14704,80,14711],[80,14712,80,14719],[80,14640,80,14647],[80,14648,80,14655],[80,14656,80,14663],[80,14664,80,14671],[80,14672,80,14679],[80,14600,80,14607],[80,14608,80,14615],[80,14616,80,14623],[80,14624,80,14631],[80,14632,80,14639],[80,14560,80,14567],[80,14568,80,14575],[80,14576,80,14583],[80,14584,80,14591],[80,14592,80,14599],[80,14520,80,14527],[80,14528,80,14535],[80,14536,80,14543],[80,14544,80,14551],[80,14552,80,14559],[80,14480,80,14487],[80,14488,80,14495],[80,14496,80,14503],[80,14504,80,14511],[80,14512,80,14519],[80,14440,80,14447],[80,14448,80,14455],[80,14456,80,14463],[80,14464,80,14471],[80,14472,80,14479],[80,14400,80,14407],[80,14408,80,14415],[80,14416,80,14423],[80,14424,80,14431],[80,14432,80,14439],[80,14360,80,14367],[80,14368,80,14375],[80,14376,80,14383],[80,14384,80,14391],[80,14392,80,14399],[80,14320,80,14327],[80,14328,80,14335],[80,14336,80,14343],[80,14344,80,14351],[80,14352,80,14359],[80,14280,80,14287],[80,14288,80,14295],[80,14296,80,14303],[80,14304,80,14311],[80,14312,80,14319],[80,14240,80,14247],[80,14248,80,14255],[80,14256,80,14263],[80,14264,80,14271],[80,14272,80,14279],[80,14200,80,14207],[80,14208,80,14215],[80,14216,80,14223],[80,14224,80,14231],[80,14232,80,14239],[80,14160,80,14167],[80,14168,80,14175],[80,14176,80,14183],[80,14184,80,14191],[80,14192,80,14199],[80,14120,80,14127],[80,14128,80,14135],[80,14136,80,14143],[80,14144,80,14151],[80,14152,80,14159],[80,14080,80,14087],[80,14088,80,14095],[80,14096,80,14103],[80,14104,80,14111],[80,14112,80,14119],[80,14040,80,14047],[80,14048,80,14055],[80,14056,80,14063],[80,14064,80,14071],[80,14072,80,14079],[80,14000,80,14007],[80,14008,80,14015],[80,14016,80,14023],[80,14024,80,14031],[80,14032,80,14039],[80,13960,80,13967],[80,13968,80,13975],[80,13976,80,13983],[80,13984,80,13991],[80,13992,80,13999],[80,13920,80,13927],[80,13928,80,13935],[80,13936,80,13943],[80,13944,80,13951],[80,13952,80,13959],[80,13880,80,13887],[80,13888,80,13895],[80,13896,80,13903],[80,13904,80,13911],[80,13912,80,13919],[80,13840,80,13847],[80,13848,80,13855],[80,13856,80,13863],[80,13864,80,13871],[80,13872,80,13879],[80,13800,80,13807],[80,13808,80,13815],[80,13816,80,13823],[80,13824,80,13831],[80,13832,80,13839],[80,13760,80,13767],[80,13768,80,13775],[80,13776,80,13783],[80,13784,80,13791],[80,13792,80,13799],[80,13720,80,13727],[80,13728,80,13735],[80,13736,80,13743],[80,13744,80,13751],[80,13752,80,13759],[80,13680,80,13687],[80,13688,80,13695],[80,13696,80,13703],[80,13704,80,13711],[80,13712,80,13719],[80,13640,80,13647],[80,13648,80,13655],[80,13656,80,13663],[80,13664,80,13671],[80,13672,80,13679],[80,13600,80,13607],[80,13608,80,13615],[80,13616,80,13623],[80,13624,80,13631],[80,13632,80,13639],[80,13560,80,13567],[80,13568,80,13575],[80,13576,80,13583],[80,13584,80,13591],[80,13592,80,13599],[80,13520,80,13527],[80,13528,80,13535],[80,13536,80,13543],[80,13544,80,13551],[80,13552,80,13559],[80,13480,80,13487],[80,13488,80,13495],[80,13496,80,13503],[80,13504,80,13511],[80,13512,80,13519],[80,13440,80,13447],[80,13448,80,13455],[80,13456,80,13463],[80,13464,80,13471],[80,13472,80,13479],[80,13400,80,13407],[80,13408,80,13415],[80,13416,80,13423],[80,13424,80,13431],[80,13432,80,13439],[80,13360,80,13367],[80,13368,80,13375],[80,13376,80,13383],[80,13384,80,13391],[80,13392,80,13399],[80,13320,80,13327],[80,13328,80,13335],[80,13336,80,13343],[80,13344,80,13351],[80,13352,80,13359],[80,13280,80,13287],[80,13288,80,13295],[80,13296,80,13303],[80,13304,80,13311],[80,13312,80,13319],[80,13240,80,13247],[80,13248,80,13255],[80,13256,80,13263],[80,13264,80,13271],[80,13272,80,13279],[80,13200,80,13207],[80,13208,80,13215],[80,13216,80,13223],[80,13224,80,13231],[80,13232,80,13239],[80,13160,80,13167],[80,13168,80,13175],[80,13176,80,13183],[80,13184,80,13191],[80,13192,80,13199],[80,13120,80,13127],[80,13128,80,13135],[80,13136,80,13143],[80,13144,80,13151],[80,13152,80,13159],[80,13080,80,13087],[80,13088,80,13095],[80,13096,80,13103],[80,13104,80,13111],[80,13112,80,13119],[80,13040,80,13047],[80,13048,80,13055],[80,13056,80,13063],[80,13064,80,13071],[80,13072,80,13079],[80,13000,80,13007],[80,13008,80,13015],[80,13016,80,13023],[80,13024,80,13031],[80,13032,80,13039],[80,12960,80,12967],[80,12968,80,12975],[80,12976,80,12983],[80,12984,80,12991],[80,12992,80,12999],[80,12920,80,12927],[80,12928,80,12935],[80,12936,80,12943],[80,12944,80,12951],[80,12952,80,12959],[80,12880,80,12887],[80,12888,80,12895],[80,12896,80,12903],[80,12904,80,12911],[80,12912,80,12919],[80,12840,80,12847],[80,12848,80,12855],[80,12856,80,12863],[80,12864,80,12871],[80,12872,80,12879],[80,12800,80,12807],[80,12808,80,12815],[80,12816,80,12823],[80,12824,80,12831],[80,12832,80,12839],[80,12760,80,12767],[80,12768,80,12775],[80,12776,80,12783],[80,12784,80,12791],[80,12792,80,12799],[80,12720,80,12727],[80,12728,80,12735],[80,12736,80,12743],[80,12744,80,12751],[80,12752,80,12759],[80,12680,80,12687],[80,12688,80,12695],[80,12696,80,12703],[80,12704,80,12711],[80,12712,80,12719],[80,12640,80,12647],[80,12648,80,12655],[80,12656,80,12663],[80,12664,80,12671],[80,12672,80,12679],[80,12600,80,12607],[80,12608,80,12615],[80,12616,80,12623],[80,12624,80,12631],[80,12632,80,12639],[80,12560,80,12567],[80,12568,80,12575],[80,12576,80,12583],[80,12584,80,12591],[80,12592,80,12599],[80,12520,80,12527],[80,12528,80,12535],[80,12536,80,12543],[80,12544,80,12551],[80,12552,80,12559],[80,12480,80,12487],[80,12488,80,12495],[80,12496,80,12503],[80,12504,80,12511],[80,12512,80,12519],[80,12440,80,12447],[80,12448,80,12455],[80,12456,80,12463],[80,12464,80,12471],[80,12472,80,12479],[80,12400,80,12407],[80,12408,80,12415],[80,12416,80,12423],[80,12424,80,12431],[80,12432,80,12439],[80,12360,80,12367],[80,12368,80,12375],[80,12376,80,12383],[80,12384,80,12391],[80,12392,80,12399],[80,12320,80,12327],[80,12328,80,12335],[80,12336,80,12343],[80,12344,80,12351],[80,12352,80,12359],[80,12280,80,12287],[80,12288,80,12295],[80,12296,80,12303],[80,12304,80,12311],[80,12312,80,12319],[80,12240,80,12247],[80,12248,80,12255],[80,12256,80,12263],[80,12264,80,12271],[80,12272,80,12279],[80,12200,80,12207],[80,12208,80,12215],[80,12216,80,12223],[80,12224,80,12231],[80,12232,80,12239],[80,12160,80,12167],[80,12168,80,12175],[80,12176,80,12183],[80,12184,80,12191],[80,12192,80,12199],[80,12120,80,12127],[80,12128,80,12135],[80,12136,80,12143],[80,12144,80,12151],[80,12152,80,12159],[80,12080,80,12087],[80,12088,80,12095],[80,12096,80,12103],[80,12104,80,12111],[80,12112,80,12119],[80,12040,80,12047],[80,12048,80,12055],[80,12056,80,12063],[80,12064,80,12071],[80,12072,80,12079],[80,12000,80,12007],[80,12008,80,12015],[80,12016,80,12023],[80,12024,80,12031],[80,12032,80,12039],[80,11960,80,11967],[80,11968,80,11975],[80,11976,80,11983],[80,11984,80,11991],[80,11992,80,11999],[80,11920,80,11927],[80,11928,80,11935],[80,11936,80,11943],[80,11944,80,11951],[80,11952,80,11959],[80,11880,80,11887],[80,11888,80,11895],[80,11896,80,11903],[80,11904,80,11911],[80,11912,80,11919],[80,11840,80,11847],[80,11848,80,11855],[80,11856,80,11863],[80,11864,80,11871],[80,11872,80,11879],[80,11800,80,11807],[80,11808,80,11815],[80,11816,80,11823],[80,11824,80,11831],[80,11832,80,11839],[80,11760,80,11767],[80,11768,80,11775],[80,11776,80,11783],[80,11784,80,11791],[80,11792,80,11799],[80,11720,80,11727],[80,11728,80,11735],[80,11736,80,11743],[80,11744,80,11751],[80,11752,80,11759],[80,11680,80,11687],[80,11688,80,11695],[80,11696,80,11703],[80,11704,80,11711],[80,11712,80,11719],[80,11640,80,11647],[80,11648,80,11655],[80,11656,80,11663],[80,11664,80,11671],[80,11672,80,11679],[80,11600,80,11607],[80,11608,80,11615],[80,11616,80,11623],[80,11624,80,11631],[80,11632,80,11639],[80,11560,80,11567],[80,11568,80,11575],[80,11576,80,11583],[80,11584,80,11591],[80,11592,80,11599],[80,11520,80,11527],[80,11528,80,11535],[80,11536,80,11543],[80,11544,80,11551],[80,11552,80,11559],[80,11480,80,11487],[80,11488,80,11495],[80,11496,80,11503],[80,11504,80,11511],[80,11512,80,11519],[80,11440,80,11447],[80,11448,80,11455],[80,11456,80,11463],[80,11464,80,11471],[80,11472,80,11479],[80,11400,80,11407],[80,11408,80,11415],[80,11416,80,11423],[80,11424,80,11431],[80,11432,80,11439],[80,11360,80,11367],[80,11368,80,11375],[80,11376,80,11383],[80,11384,80,11391],[80,11392,80,11399],[80,11320,80,11327],[80,11328,80,11335],[80,11336,80,11343],[80,11344,80,11351],[80,11352,80,11359],[80,11280,80,11287],[80,11288,80,11295],[80,11296,80,11303],[80,11304,80,11311],[80,11312,80,11319],[80,11240,80,11247],[80,11248,80,11255],[80,11256,80,11263],[80,11264,80,11271],[80,11272,80,11279],[80,11200,80,11207],[80,11208,80,11215],[80,11216,80,11223],[80,11224,80,11231],[80,11232,80,11239],[80,11160,80,11167],[80,11168,80,11175],[80,11176,80,11183],[80,11184,80,11191],[80,11192,80,11199],[80,11120,80,11127],[80,11128,80,11135],[80,11136,80,11143],[80,11144,80,11151],[80,11152,80,11159],[80,11080,80,11087],[80,11088,80,11095],[80,11096,80,11103],[80,11104,80,11111],[80,11112,80,11119],[80,11040,80,11047],[80,11048,80,11055],[80,11056,80,11063],[80,11064,80,11071],[80,11072,80,11079],[80,11000,80,11007],[80,11008,80,11015],[80,11016,80,11023],[80,11024,80,11031],[80,11032,80,11039],[80,10960,80,10967],[80,10968,80,10975],[80,10976,80,10983],[80,10984,80,10991],[80,10992,80,10999],[80,10920,80,10927],[80,10928,80,10935],[80,10936,80,10943],[80,10944,80,10951],[80,10952,80,10959],[80,10880,80,10887],[80,10888,80,10895],[80,10896,80,10903],[80,10904,80,10911],[80,10912,80,10919],[80,10840,80,10847],[80,10848,80,10855],[80,10856,80,10863],[80,10864,80,10871],[80,10872,80,10879],[80,10800,80,10807],[80,10808,80,10815],[80,10816,80,10823],[80,10824,80,10831],[80,10832,80,10839],[80,10760,80,10767],[80,10768,80,10775],[80,10776,80,10783],[80,10784,80,10791],[80,10792,80,10799],[80,10720,80,10727],[80,10728,80,10735],[80,10736,80,10743],[80,10744,80,10751],[80,10752,80,10759],[80,10680,80,10687],[80,10688,80,10695],[80,10696,80,10703],[80,10704,80,10711],[80,10712,80,10719],[80,10640,80,10647],[80,10648,80,10655],[80,10656,80,10663],[80,10664,80,10671],[80,10672,80,10679],[80,10600,80,10607],[80,10608,80,10615],[80,10616,80,10623],[80,10624,80,10631],[80,10632,80,10639],[80,10560,80,10567],[80,10568,80,10575],[80,10576,80,10583],[80,10584,80,10591],[80,10592,80,10599],[80,10520,80,10527],[80,10528,80,10535],[80,10536,80,10543],[80,10544,80,10551],[80,10552,80,10559],[80,10480,80,10487],[80,10488,80,10495],[80,10496,80,10503],[80,10504,80,10511],[80,10512,80,10519],[80,10440,80,10447],[80,10448,80,10455],[80,10456,80,10463],[80,10464,80,10471],[80,10472,80,10479],[80,10400,80,10407],[80,10408,80,10415],[80,10416,80,10423],[80,10424,80,10431],[80,10432,80,10439],[80,10360,80,10367],[80,10368,80,10375],[80,10376,80,10383],[80,10384,80,10391],[80,10392,80,10399],[80,10320,80,10327],[80,10328,80,10335],[80,10336,80,10343],[80,10344,80,10351],[80,10352,80,10359],[80,10280,80,10287],[80,10288,80,10295],[80,10296,80,10303],[80,10304,80,10311],[80,10312,80,10319],[80,10240,80,10247],[80,10248,80,10255],[80,10256,80,10263],[80,10264,80,10271],[80,10272,80,10279],[80,10200,80,10207],[80,10208,80,10215],[80,10216,80,10223],[80,10224,80,10231],[80,10232,80,10239],[80,10160,80,10167],[80,10168,80,10175],[80,10176,80,10183],[80,10184,80,10191],[80,10192,80,10199],[80,10120,80,10127],[80,10128,80,10135],[80,10136,80,10143],[80,10144,80,10151],[80,10152,80,10159],[80,10080,80,10087],[80,10088,80,10095],[80,10096,80,10103],[80,10104,80,10111],[80,10112,80,10119],[80,10040,80,10047],[80,10048,80,10055],[80,10056,80,10063],[80,10064,80,10071],[80,10072,80,10079],[80,10000,80,10007],[80,10008,80,10015],[80,10016,80,10023],[80,10024,80,10031],[80,10032,80,10039],[80,9960,80,9967],[80,9968,80,9975],[80,9976,80,9983],[80,9984,80,9991],[80,9992,80,9999],[80,9920,80,9927],[80,9928,80,9935],[80,9936,80,9943],[80,9944,80,9951],[80,9952,80,9959],[80,9880,80,9887],[80,9888,80,9895],[80,9896,80,9903],[80,9904,80,9911],[80,9912,80,9919],[80,9840,80,9847],[80,9848,80,9855],[80,9856,80,9863],[80,9864,80,9871],[80,9872,80,9879],[80,9800,80,9807],[80,9808,80,9815],[80,9816,80,9823],[80,9824,80,9831],[80,9832,80,9839],[80,9760,80,9767],[80,9768,80,9775],[80,9776,80,9783],[80,9784,80,9791],[80,9792,80,9799],[80,9720,80,9727],[80,9728,80,9735],[80,9736,80,9743],[80,9744,80,9751],[80,9752,80,9759],[80,9680,80,9687],[80,9688,80,9695],[80,9696,80,9703],[80,9704,80,9711],[80,9712,80,9719],[80,9640,80,9647],[80,9648,80,9655],[80,9656,80,9663],[80,9664,80,9671],[80,9672,80,9679],[80,9600,80,9607],[80,9608,80,9615],[80,9616,80,9623],[80,9624,80,9631],[80,9632,80,9639],[80,9560,80,9567],[80,9568,80,9575],[80,9576,80,9583],[80,9584,80,9591],[80,9592,80,9599],[80,9520,80,9527],[80,9528,80,9535],[80,9536,80,9543],[80,9544,80,9551],[80,9552,80,9559],[80,9480,80,9487],[80,9488,80,9495],[80,9496,80,9503],[80,9504,80,9511],[80,9512,80,9519],[80,9440,80,9447],[80,9448,80,9455],[80,9456,80,9463],[80,9464,80,9471],[80,9472,80,9479],[80,9400,80,9407],[80,9408,80,9415],[80,9416,80,9423],[80,9424,80,9431],[80,9432,80,9439],[80,9360,80,9367],[80,9368,80,9375],[80,9376,80,9383],[80,9384,80,9391],[80,9392,80,9399],[80,9320,80,9327],[80,9328,80,9335],[80,9336,80,9343],[80,9344,80,9351],[80,9352,80,9359],[80,9280,80,9287],[80,9288,80,9295],[80,9296,80,9303],[80,9304,80,9311],[80,9312,80,9319],[80,9240,80,9247],[80,9248,80,9255],[80,9256,80,9263],[80,9264,80,9271],[80,9272,80,9279],[80,9200,80,9207],[80,9208,80,9215],[80,9216,80,9223],[80,9224,80,9231],[80,9232,80,9239],[80,9160,80,9167],[80,9168,80,9175],[80,9176,80,9183],[80,9184,80,9191],[80,9192,80,9199],[80,9120,80,9127],[80,9128,80,9135],[80,9136,80,9143],[80,9144,80,9151],[80,9152,80,9159],[80,9080,80,9087],[80,9088,80,9095],[80,9096,80,9103],[80,9104,80,9111],[80,9112,80,9119],[80,9040,80,9047],[80,9048,80,9055],[80,9056,80,9063],[80,9064,80,9071],[80,9072,80,9079],[80,9000,80,9007],[80,9008,80,9015],[80,9016,80,9023],[80,9024,80,9031],[80,9032,80,9039],[80,8960,80,8967],[80,8968,80,8975],[80,8976,80,8983],[80,8984,80,8991],[80,8992,80,8999],[80,8920,80,8927],[80,8928,80,8935],[80,8936,80,8943],[80,8944,80,8951],[80,8952,80,8959],[80,8880,80,8887],[80,8888,80,8895],[80,8896,80,8903],[80,8904,80,8911],[80,8912,80,8919],[80,8840,80,8847],[80,8848,80,8855],[80,8856,80,8863],[80,8864,80,8871],[80,8872,80,8879],[80,8800,80,8807],[80,8808,80,8815],[80,8816,80,8823],[80,8824,80,8831],[80,8832,80,8839],[80,8760,80,8767],[80,8768,80,8775],[80,8776,80,8783],[80,8784,80,8791],[80,8792,80,8799],[80,8720,80,8727],[80,8728,80,8735],[80,8736,80,8743],[80,8744,80,8751],[80,8752,80,8759],[80,8680,80,8687],[80,8688,80,8695],[80,8696,80,8703],[80,8704,80,8711],[80,8712,80,8719],[80,8640,80,8647],[80,8648,80,8655],[80,8656,80,8663],[80,8664,80,8671],[80,8672,80,8679],[80,8600,80,8607],[80,8608,80,8615],[80,8616,80,8623],[80,8624,80,8631],[80,8632,80,8639],[80,8560,80,8567],[80,8568,80,8575],[80,8576,80,8583],[80,8584,80,8591],[80,8592,80,8599],[80,8520,80,8527],[80,8528,80,8535],[80,8536,80,8543],[80,8544,80,8551],[80,8552,80,8559],[80,8480,80,8487],[80,8488,80,8495]],"merged_total":2137,"flags":["merged_cut"]}
[{"$f":"IF('Cap Devel CBE Details'!B1 =\"Enter Project Name\",\"Enter Project Name On Details Page\",'Cap Devel CBE Details'!B1)","v":"Enter Project Name On Details Page"},null,null,null,null,{"$f":"IF('Cap Devel CBE Details'!B3 = \"Choose Agency / Institution\", \"Enter Agency Name on Details Page\", 'Cap Devel CBE Details'!B3)","v":"Select Agency / Institution"}]
["Building Costs",null,null,null,null,{"$f":"G2/'Cap Devel CBE Details'!C25","v":{"$error":"#REF!"}},{"$f":"G3+G7+G12+G20+G27+G30","v":{"$error":"#REF!"}}]
[null,"New Building Costs",null,null,null,{"$f":"G3/'Cap Devel CBE Details'!C16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G4:G6)","v":0}]
[null,null,"New facility costs",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$16","v":0}]
[null,null,"Additional construction costs details",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$33*$D$98","v":0}]
[null,null,"High performance building costs",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$44*Recap!D99","v":0}]
[null,"Renovated Building Costs",null,null,null,{"$f":"IF(G7>0.01,(G7/'Cap Devel CBE Details'!C23),0)","v":0},{"$f":"(SUM(G8:G11))","v":0}]
[null,null,"Renovated construction costs",null,null,null,{"$f":"'Cap Devel CBE Details'!F23","v":0},null,null,null,null," "]
[null,null,"Additional construction costs details",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$33*$E$98","v":0},null,null,null,null," "]
[null,null,"High performance building costs",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$44*Recap!E99","v":0}]
[null,null,"Hazardous material Cost detail - Remodel",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$68*E100","v":0}]
[null,"Building Escalation Costs",null,null,null,{"$f":"G12/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G13:G19)","v":0}]
[null,null,"New facility escalation/location factor",null,null,null,{"$f":"'Cap Devel CBE Details'!$G$16-'Cap Devel CBE Details'!$F$16","v":0}]
[null,null,"New - Additional construction costs details - escalation & location factors",null,null,null,{"$f":"('Cap Devel CBE Details'!$G$33-'Cap Devel CBE Details'!$F$33)*Recap!$D$98","v":0}]
[null,null,"New - High performance building - escalation & location factors",null,null,null,{"$f":"('Cap Devel CBE Details'!$G$44-'Cap Devel CBE Details'!$F$44)*Recap!D99","v":0}]
[null,null,"Renovated construction escalation/location factor",null,null,null,{"$f":"'Cap Devel CBE Details'!G23-'Cap Devel CBE Details'!F23","v":0}]
[null,null,"Renovated - Additional construction costs details - escalation & location factors",null,null,null,{"$f":"('Cap Devel CBE Details'!$G$33-'Cap Devel CBE Details'!$F$33)*Recap!$E$98","v":0}]
[null,null,"Renovated - High performance building - escalation & location factors",null,null,null,{"$f":"('Cap Devel CBE Details'!$G$44-'Cap Devel CBE Details'!$F$44)*Recap!E99","v":0}]
[null,null,"Renovated - Hazardous Material - escalation & location faction",null,null,null,{"$f":"('Cap Devel CBE Details'!$G$68-'Cap Devel CBE Details'!$F$68)*Recap!E100","v":0}]
[null,"Building Contingency/Insurance",null,null,null,{"$f":"G20/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G21:G26)","v":0}]
[null,null,"New Const Contingency",null,null,null,{"$f":"'Cap Devel CBE Summary'!C24*D112","v":0}]
[null,null,"New Const Builders Risk",null,null,null,{"$f":"'Cap Devel CBE Summary'!C26*D113","v":0}]
[null,null,"New Const Legal",null,null,null,{"$f":"'Cap Devel CBE Summary'!C27*D114","v":0}]
[null,null,"Renovated Building Contingency",null,null,null,{"$f":"'Cap Devel CBE Summary'!C24*E112","v":0}]
[null,null,"Renovated Building Builders Risk",null,null,null,{"$f":"'Cap Devel CBE Summary'!C26*E113","v":0}]
[null,null,"Renovated Building Legal",null,null,null,{"$f":"'Cap Devel CBE Summary'!C27*E114","v":0}]
[null,"Building FF&E",null,null,null,{"$f":"G27/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G28:G29)","v":0}]
[null,null,"New Const - Furnishings & equipment",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$109*D103","v":0}]
[null,null,"Renovation - Furnishings & equipment",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$109*E103","v":0}]
[null,"Building Soft Costs",null,null,null,{"$f":"G30/'Cap Devel CBE Details'!C25","v":{"$error":"#REF!"}},{"$f":"SUM(G31:H47)","v":{"$error":"#REF!"}}]
[null,null,"Utility impact and connection fees",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$120","v":0}]
[null,null,"New Const - IT",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$129*Recap!D104","v":0}]
[null,null,"New Const - Utah Art",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$132*Recap!D105","v":0}]
[null,null,"New Const - Testing & Inspections",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$143*Recap!D106","v":0}]
[null,null,"New Const - Moving & Occupancy Costs",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$149*Recap!D107","v":0}]
[null,null,"New Const - DFCM Management",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$157*Recap!D108","v":0}]
[null,null,"New Const - User Fees",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$164*Recap!D109","v":0}]
[null,null,"New Const - High Performance - Commissioning/Envelope/Design",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$174*Recap!D110","v":{"$error":"#REF!"}}]
[null,null,"New Const - Other Costs",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$183*Recap!D111","v":0}]
[null,null,"Renovation - IT",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$129*Recap!E104","v":0}]
[null,null,"Renovation - Utah Art",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$132*Recap!E105","v":0}]
[null,null,"Renovation - Testing & Inspections",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$143*Recap!E106","v":0}]
[null,null,"Renovation - Moving & Occupancy Costs",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$149*Recap!E107","v":0}]
[null,null,"Renovation - DFCM Management",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$157*Recap!E108","v":0}]
[null,null,"Renovation - User Fees",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$164*Recap!E109","v":0}]
[null,null,"Renovation - High Performance - Commissioning/Envelope/Design",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$174*Recap!E110","v":{"$error":"#REF!"}}]
[null,null,"Renovation - Other Costs",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$183*Recap!E111","v":0}]
[]
["Site Costs",null,null,null,null,{"$f":"G49/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"G50+G54+G58+G62","v":0}]
[null,"Site Infrastructure Costs",null,null,null,{"$f":"G50/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G51:H53)","v":0}]
[null,null,"Site infrastructure costs",null,null,null,{"$f":"'Cap Devel CBE Details'!F41","v":0}]
[null,null,"Additional construction costs details",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$33*$F$98","v":0}]
[null,null,"Hazardous Materials & Demo",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$68*F100","v":0}]
[null,"Site Infrastructure & Impact connect fees Escalation Costs",null,null,null,{"$f":"G54/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G55:H57)","v":0}]
[null,null,"Site infrastructure costs - escalation & location factor",null,null,null,{"$f":"('Cap Devel CBE Details'!G41-'Cap Devel CBE Details'!F41)","v":0}]
[null,null,"Site - Additional construction costs details - escalation & location factors",null,null,null,{"$f":"('Cap Devel CBE Details'!$G$33-'Cap Devel CBE Details'!$F$33)*Recap!$F$98","v":0}]
[null,null,"Hazardous Material & Demo - escalation & location faction ",null,null,null,{"$f":"('Cap Devel CBE Details'!$G$68-'Cap Devel CBE Details'!$F$68)*Recap!F100","v":0}]
[null,"Site Infrastructure Contingency/Insurance",null,null,null,{"$f":"G58/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G59:G61)","v":0}]
[null,null,"Contingency",null,null,null,{"$f":"'Cap Devel CBE Summary'!C24*F112","v":0}]
[null,null,"Builders Risk",null,null,null,{"$f":"'Cap Devel CBE Summary'!C26*F113","v":0}]
[null,null,"Legal",null,null,null,{"$f":"'Cap Devel CBE Summary'!C27*F114","v":0}]
[null,"Site Infrastructure Soft Costs",null,null,null,{"$f":"G62/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G63:G67)","v":0}]
[null,null,"Testing & Inspections",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$143*Recap!F106","v":0}]
[null,null,"DFCM Management",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$157*Recap!F108","v":0}]
[null,null,"User Fees",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$164*Recap!F109","v":0}]
[null,null,"Other Costs",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$183*Recap!F111","v":0}]
[]
["Pre-Construction Costs",null,null,null,null,{"$f":"G68/'Cap Devel CBE Details'!C25","v":{"$error":"#REF!"}},{"$f":"G69+G73","v":{"$error":"#REF!"}}]
[null,"Programming/Pre-Design",null,null,null,{"$f":"G69/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G70:G72)","v":0}]
[null,null,"Pre-Design/Planning Costs - New Const",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$80*D101","v":0}]
[null,null,"Pre-Design/Planning Costs - Remodel",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$80*E101","v":0}]
[null,null,"Pre-Design/Planning Costs - Site",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$80*F101","v":0}]
[null,"Design",null,null,null,{"$f":"G73/'Cap Devel CBE Details'!C25","v":{"$error":"#REF!"}},{"$f":"SUM(G74:G76)","v":{"$error":"#REF!"}}]
[null,null,"Design - New Const",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$87*D102","v":{"$error":"#REF!"}}]
[null,null,"Design - Remodel",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$87*E102","v":{"$error":"#REF!"}}]
[null,null,"Design - Site",null,null,null,{"$f":"'Cap Devel CBE Details'!$F$87*F102","v":{"$error":"#REF!"}}]
[]
["Property Acquisition",null,null,null,null,{"$f":"G78/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"G79","v":0}]
[null,"Property Acquisition Costs",null,null,null,{"$f":"G79/'Cap Devel CBE Details'!C25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G80:G80)","v":0}]
[null,null,"Land Purchase/Acquisition Costs",null,null,null,{"$f":"'Cap Devel CBE Details'!F93","v":0}]
[]
["Project Total",null,null,null,null,{"$f":"G82/'Cap Devel CBE Details'!C25","v":{"$error":"#REF!"}},{"$f":"G2+G49+G68+G78","v":{"$error":"#REF!"}}]
[]
[null,"Less Other Funding",null,null,null,null,{"$f":"'Cap Devel CBE Details'!F209+'Cap Devel CBE Details'!F203","v":0}]
[]
["Request for State Funding",null,null,null,null,{"$f":"G86/'Cap Devel CBE Details'!C25","v":{"$error":"#REF!"}},{"$f":"G82-G84","v":{"$error":"#REF!"}}]
[]
[{"$f":"'Cap Devel CBE Details'!A212","v":"OFFICIAL UTAH DFCM CBE FORM V2.09 Last Revision: 2-14-2023"}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"G86='Cap Devel CBE Summary'!C40","v":{"$error":"#REF!"}},null,"Recap Total = Summary Total"]
[]
[null,null,null,"New Facility Cost","Remodel Facility Cost","Site Cost","PROPERTY ACQUISITION COST"]
["Self Calculating - Input Only Required To Change Ratios",null,null,{"$f":"'Cap Devel CBE Details'!F16","v":0},{"$f":"'Cap Devel CBE Details'!F23","v":0},{"$f":"'Cap Devel CBE Details'!F41","v":0},{"$f":"'Cap Devel CBE Details'!F93","v":0},"Must = 100%"]
["Ratios To Apply Costs To Multiple Categories",null,null,"New","Remodel","Site","Land","Total"]
["Additional Construction costs details",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",{"$f":"SUM(D98:G98)","v":0}]
["High performance building",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96))","v":0},"Not Used","Not Used",{"$f":"SUM(D99:G99)","v":0}]
["Hazardous Material",null,null,"Not Used",{"$f":"IF($E$96=0,0,$E$96/($E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($E$96+$F$96))","v":0},"Not Used",{"$f":"SUM(D100:G100)","v":0}]
["Pre-Design/Planning",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",{"$f":"SUM(D101:G101)","v":0}]
["Design",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",0]
["Furnishings & Equipment",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96))","v":0},"Not Used","Not Used",0]
["Information Technology",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96))","v":0},"Not Used","Not Used",0]
["Utah Art",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96))","v":0},"Not Used","Not Used",0]
["Testing & Inspections",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",0]
["Moving & Occupancy Costs",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96))","v":0},"Not Used","Not Used",0]
["DFCM Management",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",0]
["User Fees",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",0]
["Commissioning",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96))","v":0},"Not Used","Not Used",0]
["Other Costs",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",0]
["Contingency",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",{"$f":"SUM(D112:G112)","v":0}]
["Builders Risk",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",{"$f":"SUM(D113:G113)","v":0}]
["Legal Services",null,null,{"$f":"IF($D$96=0,0,$D$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($E$96=0,0,$E$96/($D$96+$E$96+$F$96))","v":0},{"$f":"IF($F$96=0,0,$F$96/($D$96+$E$96+$F$96))","v":0},"Not Used",0]

{"sheet":"Cap Devel CBE Summary","index":1,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[40,0,40,2],[34,5,34,6],[35,0,35,1],[33,5,33,6],[27,0,27,1],[28,0,28,1],[31,5,31,6],[32,5,32,6],[29,0,29,1],[30,0,30,1],[32,0,32,2],[34,0,34,2],[38,0,38,2],[37,3,37,6],[39,0,39,1],[36,0,36,2],[38,3,38,6],[20,0,20,1],[15,0,15,1],[22,0,22,1],[17,0,17,1],[21,0,21,1],[16,0,16,1],[19,0,19,1],[0,1,0,6],[24,0,24,1],[13,3,13,6],[6,3,6,6],[26,0,26,1],[25,0,25,1],[18,0,18,1],[14,0,14,1]]}
["Project Name:",{"$f":"'Cap Devel CBE Details'!B1","v":"Enter Project Name"}]
["Project Type:",{"$f":"'Cap Devel CBE Details'!B2","v":"Select Project Type"}]
["Agency/Institution:",{"$f":"'Cap Devel CBE Details'!B3:G3","v":"Select Agency / Institution"},null,null,null,null,"Print Date"]
["Project Manager:",{"$f":"'Cap Devel CBE Details'!B4:G4","v":"Enter DFCM Project Manager"},null,null,null,null,{"$f":"TODAY()","v":45513}]
["Delivery Method:",{"$f":"'Cap Devel CBE Details'!B5:G5","v":"Select Delivery Method"},null,"Project  Location:",{"$f":"IF('Cap Devel CBE Details'!F1=\"Select County\",\"Select County On Details Page\",'Cap Devel CBE Details'!F1)","v":"Select County On Details Page"}]
[null,null,"Cost"]
["Cost Summary","$/SF","$ Amount","Notes",null,null,null,null,null,null,null,null,"Development - Design Build"]
["Facility Cost",{"$f":"C8/TGSF","v":{"$error":"#DIV/0!"}},{"$f":"'Cap Devel CBE Details'!G25","v":0},null,null,null,null,null,null,null,null,null,"Development - Design Bid Build"]
["Additional Construction Cost",{"$f":"C9/TGSF","v":{"$error":"#DIV/0!"}},{"$f":"'Cap Devel CBE Details'!G33","v":0},null,null,null,null,null,null,null,null,null,"MOU Development"]
["Site Cost",{"$f":"C10/TGSF","v":{"$error":"#DIV/0!"}},{"$f":"'Cap Devel CBE Details'!G41","v":0}]
["High Performance Building",{"$f":"C11/TGSF","v":{"$error":"#DIV/0!"}},{"$f":"'Cap Devel CBE Details'!G44","v":0}]
["Total Construction Cost",{"$f":"C12/TGSF","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C8:C11)","v":0}]
[]
["Soft Costs:","$/SF","$ Amount","Notes"]
["Hazardous Materials",null,{"$f":"'Cap Devel CBE Details'!G68","v":0}]
["Pre-Design/Planning",null,{"$f":"'Cap Devel CBE Details'!F80","v":0}]
["Design",null,{"$f":"'Cap Devel CBE Details'!F87","v":{"$error":"#REF!"}}]
["Property Acquisition",null,{"$f":"'Cap Devel CBE Details'!F93","v":0}]
["Furnishings & Equipment",null,{"$f":"'Cap Devel CBE Details'!F109","v":0}]
["Utility Fee Cost",null,{"$f":"'Cap Devel CBE Details'!F120","v":0},null,null,null,null,null,null,null,null,null,"Development - CMGC"]
["Information Technology:",null,{"$f":"'Cap Devel CBE Details'!F129","v":0}]
["Utah Art (1% of Construction Budget)",null,{"$f":"'Cap Devel CBE Details'!F132","v":0}]
["Testing & Inspection",null,{"$f":"'Cap Devel CBE Details'!F143","v":0}]
["Contingency",{"$f":"Contingency!B5","v":{"$error":"#DIV/0!"}},{"$f":"Contingency!D5","v":0},{"$f":"Contingency!C3/Contingency!C5","v":{"$error":"#DIV/0!"}},{"$f":"IF(Contingency!C3=0,\"@ 0%\",Contingency!B3)","v":"@ 0%"},{"$f":"Contingency!C4/Contingency!C5","v":{"$error":"#DIV/0!"}},{"$f":"IF(Contingency!C4=0,\"@ 0%\",Contingency!B4)","v":"@ 0%"}]
["Moving/Occupancy",null,{"$f":"'Cap Devel CBE Details'!F149","v":0}]
["Builder's Risk Insurance (0.15% of Construction Budget)",null,{"$f":"C12*0.0015","v":0}]
["Legal Services (0.05% of Construction Budget)",null,{"$f":"C12*0.0005","v":0}]
["DFCM Management",null,{"$f":"'Cap Devel CBE Details'!F157","v":0}]
["User Fees",null,{"$f":"'Cap Devel CBE Details'!F164","v":0}]
["Commissioning",null,{"$f":"'Cap Devel CBE Details'!F174","v":{"$error":"#REF!"}}]
["Other Costs",null,{"$f":"'Cap Devel CBE Details'!F183","v":0}]
["Total Soft Costs",{"$f":"C32/TGSF","v":{"$error":"#REF!"}},{"$f":"SUM(C15:C31)","v":{"$error":"#REF!"}}]
[]
["Total Project Cost",{"$f":"C34/TGSF","v":{"$error":"#REF!"}},{"$f":"C12+C32","v":{"$error":"#REF!"}}]
[]
["Previous State Funding",null,{"$f":"'Cap Devel CBE Details'!F203","v":0},{"$f":"IF(C36>0,'Cap Devel CBE Details'!A201,\"\")","v":""}]
[null,null,null,{"$f":"IF(C36>0,'Cap Devel CBE Details'!B201,\"\")","v":""}]
["Other Funding Sources (Identify in note)",null,{"$f":"'Cap Devel CBE Details'!F209","v":0},{"$f":"IF(C38>0,'Cap Devel CBE Details'!A206,\"\")","v":""}]
[null,null,null,{"$f":"IF(C38>0,'Cap Devel CBE Details'!B206,\"\")","v":""}]
["REQUEST FOR STATE FUNDING",null,{"$f":"+C34-C36-C38","v":{"$error":"#REF!"}}]
[]
["Project Information"]
[null,null,null,null,null,{"$f":"'Cap Devel CBE Details'!B53","v":"Base $/SF Cost Date - (Date Escalation Begins):"},{"$f":"'Cap Devel CBE Details'!C53","v":"1900-01-01"}]
[null,null,null,null,null,{"$f":"'Cap Devel CBE Details'!B54","v":"Estimated Final Bid Date (Date Escalation Ends):"},{"$f":"'Cap Devel CBE Details'!C54","v":"1900-01-01"}]
[null,null,null,null,null,{"$f":"'Cap Devel CBE Details'!B55","v":"Estimated Substantial Completion Date:"},{"$f":"'Cap Devel CBE Details'!C55","v":"1900-01-01"}]
[{"$f":"'Cap Devel CBE Details'!A212","v":"OFFICIAL UTAH DFCM CBE FORM V2.09 Last Revision: 2-14-2023"},null,null,null,null,"Date Last Modified",{"$f":"LastModified()","v":"2023-12-18T14:59:15"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2024-08-09T08:30:37.660"}]

{"sheet":"Cap Devel CBE Details","index":2,"n_rows":212,"n_cols":39,"rows_kept":212,"cut":false,"hidden":false,"merged":[[211,1,211,5],[0,7,0,9],[47,10,47,11],[160,3,160,4],[43,2,43,3],[43,0,43,1],[131,0,131,1],[151,0,151,1],[51,4,51,5],[50,4,50,6],[50,1,50,2],[152,1,152,3],[151,2,151,3],[131,2,131,3],[2,3,4,6],[0,1,0,2],[196,0,196,5],[1,1,1,2],[159,3,159,4],[3,1,3,2],[4,1,4,2],[1,5,1,6],[1,3,1,4],[2,1,2,2]]}
["Project Name:","Enter Project Name",null,"Project Location:",null,"Select County",{"$f":"TODAY()","v":"2024-08-09"},"IMPORTANT INSTRUCTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<----  Project Name Field is right here. Did you want to add it somewhere else too."]
["Project Type:","Select Project Type",null,"Additional Project Info:",null,null,null,"Start With A New Blank CBE Form For Every New Project. No Exceptions!"]
["Agency/Institution:","Select Agency / Institution",null,null,null,null,null,"Do Not Reuse An Existing CBE From a Previous Project. No Exceptions!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"John - we need to add a project name field, and we are missing some of the State agencies in the drop down menu."]
["Project Manager:","Enter DFCM Project Manager",null,null,null,null,null,"All Previous CBE Forms Will Not Be Accepted. No Exceptions!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is there a list I can use or are you just noticing some specific ones that I missed. I only used ones that had been used in the state cost database."]
["Delivery Method:","Select Delivery Method",null,null,null,null,null,"Form Created and Maintained by John Shampton, CPE DFCM Cost Estimator 801-921-2170 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Under delivery method, we may want to change it to just MOU and add AMA."]
[null,null,null,null,null,null,null,"Any Errors, Problems, Questions - Please Contact John Shampton",null,null,null,"jshampton@utah.gov",null,null,null,null,null,null,null,null,null,null,null,"Added MOU and AMA for Development and Improvement"]
[null,null,null,null,null,null,null,"Drop Down Lists: If any items need to be added to the list, modified or deleted, Please Contact John Shampton"]
["Facility Cost","Explanation","GSF",null,"$/SF","Cost","Escalated Cost","Estimate vs Actual Comparison",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mou ama"]
["     New Facility Cost Details:",null,null,null,null,null,null,"Actual","Difference","Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"development\\"]
["Enter New Construction Details",null,0,"SF",0,{"$f":"C10*E10","v":0},{"$f":"(F10*(1+$C$57))+(F10*$E$58)","v":0},0,{"$f":"G10-H10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Improvement"]
[null,null,0,"SF",0,{"$f":"C11*E11","v":0},0,0,{"$f":"G11-H11","v":0}]
[null,null,0,"SF",0,0,0,0,0]
[null,null,0,"SF",0,{"$f":"C13*E13","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Will it break the form if the PM adds more fields/rows here?"]
[null,null,0,"SF",0,{"$f":"C14*E14","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As long as they are entering new rows in the middle and not at the top or bottom, the calculation will still function properly."]
[null,null,0,"SF",0,0,0,0,0]
["   Subtotal - New Facility Costs",null,{"$f":"SUM(C10:C15)","v":0},"SF",null,{"$f":"SUM(F10:F15)","v":0},{"$f":"SUM(G10:G15)","v":0},{"$f":"SUM(H10:H15)","v":0},{"$f":"G16-H16","v":0}]
[]
["     Remodel Facility Cost Details:","Explanation","GSF",null,"$/SF","Cost","Escalated Cost","Actual","Difference","Notes:"]
["Enter Facility Remodel Details",null,0,"SF",0,{"$f":"C19*E19","v":0},{"$f":"(F19*(1+$C$57))+(F19*$E$58)","v":0},0,{"$f":"G19-H19","v":0}]
[null,null,0,"SF",0,{"$f":"C20*E20","v":0},{"$f":"(F20*(1+$C$57))+(F20*$E$58)","v":0},0,{"$f":"G20-H20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Same questions"]
[null,null,0,"SF",0,0,{"$f":"(F21*(1+$C$57))+(F21*$E$58)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As long as they are entering new rows in the middle and not at the top or bottom, the calculation will still function properly."]
[null,null,0,"SF",0,0,{"$f":"(F22*(1+$C$57))+(F22*$E$58)","v":0},0,0]
["   Subtotal - Remodel Facility Costs",null,{"$f":"SUM(C19:C22)","v":0},"SF",null,{"$f":"SUM(F19:F22)","v":0},{"$f":"SUM(G19:G22)","v":0},{"$f":"SUM(H19:H22)","v":0},{"$f":"G23-H23","v":0}]
[null,null,null,null,null,null,null,"Actual","Difference","Notes:"]
["Total Facility Costs",null,{"$f":"C16+C23","v":0},"TGSF",null,{"$f":"F16+F23","v":0},{"$f":"G16+G23","v":0},{"$f":"H16+H23","v":0},{"$f":"G25-H25","v":0}]
[null,null,"Total GSF",null,null,"Facility Cost","Escalated Cost"]
[]
["Additional Construction Cost Details:","Explanation","Units",null,"Unit Cost/Rate","Cost","Escalated Cost","Actual","Difference","Notes:"]
["Enter Additional Construction Cost Description",null,0,"Unit",0,{"$f":"C29*E29","v":0},{"$f":"(F29*(1+$C$57))+(F29*$E$58)","v":0},0,{"$f":"G29-H29","v":0}]
[" ",null,0,"Unit",0,{"$f":"C30*E30","v":0},{"$f":"(F30*(1+$C$57))+(F30*$E$58)","v":0},0,{"$f":"G30-H30","v":0}]
[null,null,0,"Unit",0,{"$f":"C31*E31","v":0},{"$f":"(F31*(1+$C$57))+(F31*$E$58)","v":0},0,0]
[null,null,0,"Unit",0,{"$f":"C32*E32","v":0},{"$f":"(F32*(1+$C$57))+(F32*$E$58)","v":0},0,0]
["     Total Additional Construction Costs",null,null,null,null,{"$f":"SUM(F29:F32)","v":0},{"$f":"SUM(G29:G32)","v":0},{"$f":"SUM(H29:H32)","v":0},{"$f":"G33-H33","v":0}]
[]
["Site Cost Details:","Explanation","Units",null,"Unit Cost/Rate","Cost","Escalated Cost","Actual","Difference","Notes:"]
["Enter Site Cost Details",null,0,"Unit",0,{"$f":"C36*E36","v":0},{"$f":"(F36*(1+$C$57))+(F36*$E$58)","v":0},0,{"$f":"G36-H36","v":0}]
[" ",null,0,"Unit",0,0,{"$f":"(F37*(1+$C$57))+(F37*$E$58)","v":0},0,{"$f":"G37-H37","v":0}]
[null,null,0,"Unit",0,0,{"$f":"(F38*(1+$C$57))+(F38*$E$58)","v":0},0,0]
[null,null,0,"Unit",0,0,{"$f":"(F39*(1+$C$57))+(F39*$E$58)","v":0},0,0]
[null,null,0,"Unit",0,0,{"$f":"(F40*(1+$C$57))+(F40*$E$58)","v":0},0,{"$f":"G40-H40","v":0}]
["     Total Site Costs",null,null,null,null,{"$f":"SUM(F36:F40)","v":0},{"$f":"SUM(G36:G40)","v":0},{"$f":"SUM(H36:H40)","v":0},{"$f":"G41-H41","v":0}]
[]
["High Performance Building Cost Details:","Explanation","Units",null,"Unit Cost","Cost","Escalated Cost","Actual","Difference","Notes:"]
[" Is This Building High Performance? Select YES OR NO ►",null,"Choose One",null,null,{"$f":"IF(E44>0,E44,IF(C44=\"YES\",(F25+F120+F33+F41)*D45,0))","v":0},{"$f":"(F44*(1+$C$57))+(F44*$E$58)","v":0},0,{"$f":"G44-H44","v":0}]
[null,null,"To supersede the 1.5% auto-calculation, change the percentage or enter a fixed amount alternate cost above arrows:",1.4999999999999999E-2,"▲   ▲   ▲"]
[]
[null,null,null,null,null,"Cost","Escalated Cost","Actual","Difference","Notes:"]
["Total Construction Costs",null,null,null,null,{"$f":"F25+F33+F41+F44","v":0},{"$f":"G25+G120+G33+G41+G44","v":0},{"$f":"H16+H23+H33+H41+H44","v":0},{"$f":"G48-H48","v":0}]
[null,null,null,null,null,"Cost of Escalation on Total Construction Cost",{"$f":"(TCC-F48)+(G68-F68)","v":0}]
[null,null,"`"]
["Other Project Information:","Update Dates If Any Changes Are Made To The CBE ",null,null,"Enter Escalation % For Years In Blue (0% If White)",null,null,null,null,null,null,null,null,null,"Begin Escalation",null,null,null,null,"Escalation Calculation"]
[null,null,null,null,"Base Cost Per Square Foot Already Escalated",null,"% of Year Included","Effective Rate",null,null,null,null,null,null,"Start Day (#)",null,null,null,null,"% of Year","Effective Rate"]
[null,"Base $/SF Cost Date - (Date Escalation Begins):","1900-01-01",null,0.14000000000000001,{"$f":"C53","v":"1900-01-01"},{"$f":"T53","v":0.99726027397260275},{"$f":"U53-1","v":0.13961643835616444},null,null,null,null,null,null,{"$f":"C53-DATE(YEAR(C53),1,0)","v":1},null,{"$f":"G58","v":0},"Year",1,{"$f":"O57","v":0.99726027397260275},{"$f":"((T53*E53)+1)","v":1.1396164383561644}]
[null,"Estimated Final Bid Date (Date Escalation Ends):","1900-01-01",null,0.12,{"$f":"IF(T54>0,(F53+366),\"\")","v":""},{"$f":"T54","v":-0.99726027397260275},-0.11967123287671233,null,null,null,null,null,null,"Days in First Year",null,{"$f":"Q53-T53","v":-0.99726027397260275},"Year",2,{"$f":"IF(Q54>1,1,Q54)","v":-0.99726027397260275},{"$f":"((T54*E54)+1)","v":0.88032876712328767},null,null,"The language in red on this line may read better if we list it as \"Latest revision to the CBE\"",null,null,null,null,null,null,null,"Changed to Date of Latest Revision to the CBE"]
[null,"Estimated Substantial Completion Date:","1900-01-01",null,0.08,{"$f":"IF(T55>0,(F54+366),\"\")","v":""},0,0,null,null,null,null,null,null,{"$f":"365-O53","v":364},null,{"$f":"Q54-T54","v":0},"Year",3,{"$f":"IF(Q55>1,1,Q55)","v":0},{"$f":"((T55*E55)+1)","v":1},null,null,"Estimated bid date",null,null,null,null,null,null,null,"Changed to Estimated Bid Date"]
[null,"Date of Last Modifications to the CBE:",{"$f":"LastModified()","v":"2023-12-18T14:59:15"},null,0.05,{"$f":"IF(T56>0,(F55+366),\"\")","v":""},0,0,null,null,null,null,null,null,"% of First Year",null,{"$f":"Q55-T55","v":0},"Year",4,{"$f":"IF(Q56>1,1,Q56)","v":0},{"$f":"((T56*E56)+1)","v":1},null,null,"Estimated Substantial Completion",null,null,null,null,null,null,null,"Changed to Estimated Substantial Completion Date"]
["Building Location Cost Increase Factor Included:",{"$f":"IF($F$1=\"Select County\",\"Select County At Top of page\",$F$1)","v":"Select County At Top of page"},{"$f":"'Location Factors'!C5","v":0},null,0.05,{"$f":"IF(T57>0,(F56+366),\"\")","v":""},0,0,null,null,null,null,null,null,{"$f":"O55/365","v":0.99726027397260275},null,{"$f":"Q56-T56","v":0},"Year",5,{"$f":"IF(Q57>1,1,Q57)","v":0},{"$f":"((T57*E57)+1)","v":1}]
[null,null,"Compounded Escalation Factor Included:",null,{"$f":"T58-1","v":3.2371341715144997E-3},{"$f":"IF(G58>0,E58/G58,0)","v":0},{"$f":"(C54-C53)/365","v":0},3.2371341715144997E-3,null,null,null,null,null,null,"Total Days",null,null,null,null,{"$f":"((T53*E53)+1)*((T54*E54)+1)*((T55*E55)+1)*((T56*E56)+1)*((T57*E57)+1)","v":1.0032371341715145},{"$f":"U53*U54*U55*U56*U57","v":1.0032371341715145},null,null,"What does the info in the C62 cell note?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C54-C53","v":0},null,null,null,null,"Compounded","Check",null,null,"Corrected This is the cost increase for locations that are difficult or long distance, It is the same as it was included in past CBEs. It was normally hand entered in. Now it is using the County to calculate, but can be hand modified."]
["Hazardous Materials Cost Details:","Explanation","Units",null,"Unit Cost/Rate","Cost","Escalated Cost","Actual","Difference","Notes:","Hazardous Materials Costing Help",null,null,null,"Total Years"]
["Pre-Construction Survey","Improve $2.5-$5K, Dev $10-$25K, $2.50-$3.5/SF",1,"Unit",0,{"$f":"C61*E61","v":0},{"$f":"(F61*(1+$C$57))+(F61*$E$58)","v":0},0,{"$f":"G61-H61","v":0},null,"Most buildings older than 1979 will have a lot of remediation, ",null,null,null,{"$f":"Q53","v":0},null,null,null,null,null,null,null,null,"How does the Hazardous Materials units reflective of the escalated construction cost?"]
["Plan and Monitoring","$900-$1500 Per Day, More Depending on Distance",0,"EA",0,{"$f":"C62*E62","v":0},{"$f":"(F62*(1+$C$57))+(F62*$E$58)","v":0},0,{"$f":"G62-H62","v":0},null,"Most Buildings from 1980 on will have much less remediation due to EPA regulations that took place at the time.",null,null,null,null,null,null,null,null,null,null,null,null,"Hazardous  materials is calculated by the square footage of any remodel costs"]
["Abatement/Removal - Improvement Projects","Avg 2-6 Weeks (5 Day) Ranging From $5K-$150K",0,"EA",0,{"$f":"C63*E63","v":0},{"$f":"(F63*(1+$C$57))+(F63*$E$58)","v":0},0,0,null,"The number of weeks of abatement depends entirely on the findings in the initial survey."]
["Abatement/Removal - Development Projects","Avg 7-16 Weeks (5 Day) Ranging From $150K-$1M",0,"EA",0,{"$f":"C64*E64","v":0},{"$f":"(F64*(1+$C$57))+(F64*$E$58)","v":0},0,0,null,"Abatement activities on most IMPROVEMENT PROJECTS generally run from $5k-$150k based on the quantities found on the initial survey.  "]
["Enter Hazardous Materials Cost Details",null,0,"Unit",0,{"$f":"C65*E65","v":0},{"$f":"(F65*(1+$C$57))+(F65*$E$58)","v":0},0,0,null,"Abatement activities on most DEVELOPMENT PROJECTS generally run from $150k- $1M on based on the quantities found on the initial survey.  ",null,null,null,null,null,null,null,null,null,null,null,null,"SF of remodel cost",null,"Jon Vance ask "]
[null,null,0,"Unit",0,{"$f":"C66*E66","v":0},{"$f":"(F66*(1+$C$57))+(F66*$E$58)","v":0},0,{"$f":"G66-H66","v":0},null,"For more information or questions, contact Jon Vance at:",null,null,null,null,null,null,null,null,null,null,null,null,"SF of remodel cost",null,"Jon Vance ask ",null,null,null,null,null,null,null,null,null,null,null,"801-686-4422","jvance@utah.gov"]
["Building Location HazMat Cost Increase Factor:",{"$f":"IF($F$1=\"Select County\",\"Select County At Top of page\",$F$1)","v":"Select County At Top of page"},{"$f":"TCC","v":0},"TCC",{"$f":"'Location Factors'!C6","v":0},{"$f":"IF(SUM(F61:F66)>0,(C67*E67),0)","v":0},{"$f":"(F67*(1+$C$57))+(F67*$E$58)","v":0},0,{"$f":"G67-H67","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Still have not heard back from Jon Vance"]
["     Total Hazardous Material Costs",null,null,null,null,{"$f":"SUM(F61:F67)","v":0},{"$f":"SUM(G61:G67)","v":0},{"$f":"SUM(H61:H67)","v":0},{"$f":"G68-H68","v":0}]
[]
["Pre-Design/Planning Cost Details:","Explanation","Units",null,"Unit Cost/Rate","Cost","Units","Actual","Difference","Notes:"]
["Feasibility Study / Planning Fund Reimbursement","Enter Planning Fund Reimbursement Details",0,"EA",0,{"$f":"C71*E71","v":0},{"$f":"'Drop Downs'!K2","v":"TCC = Total Const Cost"},0,{"$f":"F71-H71","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Historically, we have not calculated the design or programming fees off of the construction costs that include the utility connections / impact fees"]
["Programming","Enter Programing Details",{"$f":"TCC","v":0},"TCC",0,{"$f":"C72*E72","v":0},{"$f":"'Drop Downs'!K3","v":"EA = Each"},0,{"$f":"F72-H72","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Changed calculation to only use the Total Facility cost, site cost, and HPB costs, not including utilities"]
["Environmental Assessment","Enter Environmental Assessment Details",{"$f":"TCC","v":0},"TCC",0,0,{"$f":"'Drop Downs'!K4","v":"SF = Square Feet"},0,{"$f":"F73-H73","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I'm not sure what the appropriate amount is here, but I know its no where near 1% - Maybe Taylor and Clint would have a better understanding"]
["Geotechnical Investigation/Surveys","Enter Number of Borings ($3,000 - $5,000 Ea.)",0,"EA",4000,0,{"$f":"'Drop Downs'!K5","v":"LF = Lineal Feet"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total minus utility costs"]
["Geotechnical Ground Motion Study","Enter Geotech Details",0,"EA",0,{"$f":"C75*E75","v":0},{"$f":"'Drop Downs'!K6","v":"CF = Cubic Feet"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geotech should be based off of borings and site requirements - not a percentage of the construction budget."]
["Site Survey","Enter Site Survey Details",0,"Unit",0,{"$f":"C76*E76","v":0},{"$f":"'Drop Downs'!K7","v":"CY = Cubic Yards"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Changed to a per boring calculation with a default cost of $4K"]
["Marketing / Reimbursable",null,0,"Unit",0,{"$f":"C77*E77","v":0},{"$f":"'Drop Downs'!K8","v":"Fx = Formula"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I'm not sure a location factor would be relevant outside of travel fees - we may want to discuss this with PMs."]
[null,null,null,null,null,null,null,0,0]
["Pre-Design Building Location Cost Increase Factor:",{"$f":"IF($F$1=\"Select County\",\"Select County At Top of page\",$F$1)","v":"Select County At Top of page"},{"$f":"TCC","v":0},"TCC",{"$f":"'Location Factors'!C7","v":0},{"$f":"IF(SUM(F71:F78)>0,(C79*E79),0)","v":0},null,0,{"$f":"F79-H79","v":0},null,"             ",null,null,null,null,null,null,null,null,null,null,null,null,"I agree, I added this because many PMs forgot to add travel fees and we had to add them after during review. Just trying to catch the stuff that gets forgotten"]
["     Total Pre-Design/Planning Costs",null,null,null,null,{"$f":"SUM(F71:F79)","v":0},null,{"$f":"SUM(H71:H79)","v":0},{"$f":"F80-H80","v":0}]
[]
["Design Cost Details:","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["A/E Design Fees","A&E Design Fees From A&E Calculator",1,"EA",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C83*E83","v":{"$error":"#REF!"}},null,0,{"$f":"F83-H83","v":{"$error":"#REF!"}}]
["Enter Design Fee Details",null,0,"EA",0,{"$f":"C84*E84","v":0},null,0,{"$f":"F84-H84","v":0}]
[null," ",0,"Unit",0,0,null,0,0]
[null,null,0,"Unit",0,{"$f":"C86*E86","v":0},null,0,{"$f":"F86-H86","v":0}]
["     Total Design Costs",null,null,null,null,{"$f":"SUM(F83:F86)","v":{"$error":"#REF!"}},null,{"$f":"SUM(H83:H86)","v":0},{"$f":"F87-H87","v":{"$error":"#REF!"}}]
[]
["Property Acquisition Cost Details:","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["Enter Property Acquisition Details",null,0,"Unit",0,{"$f":"C90*E90","v":0},null,0,{"$f":"F90-H90","v":0}]
[null,null,0,"Unit",0,{"$f":"C91*E91","v":0},null,0,{"$f":"F91-H91","v":0}]
[null,null,0,"Unit",0,{"$f":"C92*E92","v":0},null,0,0]
["     Total Property Acquisition Costs",null,null,null,null,{"$f":"SUM(F90:F92)","v":0},null,{"$f":"SUM(H90:H92)","v":0},{"$f":"F94-H93","v":0}]
[]
["Furnishings & Equipment Costs Details:","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["Furnishings Details",null,0,"Unit",0,{"$f":"C96*E96","v":0},null,0,{"$f":"F96-H96","v":0}]
["Furnishings","(3-4% of Total Construction Cost)",{"$f":"TCC","v":0},"TCC",0.04,{"$f":"C97*E97","v":0},null,0,0]
["Enter Furnishing Details",null,0,"Unit",0,{"$f":"C98*E98","v":0},null,0,0]
[null,null,0,"Unit",0,{"$f":"C99*E99","v":0},null,0,0]
["   Total Furnishings Costs",null,null,null,null,{"$f":"SUM(F96:F99)","v":0},null,{"$f":"SUM(H96:H99)","v":0},0]
["Equipment Detail:",null,0,"Unit",0,{"$f":"C101*E101","v":0},null,0,0]
["Specialized Equipment","(3-4% of Total Construction Cost)",{"$f":"TCC","v":0},"TCC",0.04,0,null,0,0]
[null,null,0,"Unit",0,{"$f":"C103*E103","v":0},null,0,0]
["Enter Equipment Details",null,0,"Unit",0,0,null,0,0]
["   Total Equipment Costs",null,null,null,null,{"$f":"SUM(F101:F104)","v":0},null,{"$f":"SUM(H101:H104)","v":0},0]
["FF&E Design Costs","(5% Of The Sum Of Furnishings And Equipment Totals)",{"$f":"F100+F105","v":0},"Fx",0.05,{"$f":"C106*E106","v":0},null,0,0]
["Enter FF&E Details",null,0,"Unit",0,{"$f":"C107*E107","v":0},null,0,0]
[null,null,0,"Unit",0,{"$f":"C108*E108","v":0},null,0,0]
["     Total Furnishings & Equipment Costs",null,null,null,null,{"$f":"F100+F105+F106+F107+F108","v":0},null,{"$f":"SUM(H105:H108)+H100","v":0},0]
[]
["Utility Cost Details:","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["Water Utility Fee",null,0,"EA",0,{"$f":"C112*E112","v":0},null,0,{"$f":"F112-H112","v":0}]
["Sewer Utility Fee",null,0,"EA",0,0,null,0,0]
["Electricity Utility Fee",null,0,"EA",0,0,null,0,0]
["Storm Sewer Utility Fee",null,0,"EA",0,0,null,0,0]
["Gas Connection Fees",null,0,"EA",0,0,null,0,0]
["Connection Fees",null,0,"Unit",0,0,null,0,0]
["Enter Utility Details",null,0,"Unit",0,{"$f":"C118*E118","v":0},null,0,0]
[null,null,0,"Unit",0,0,null,0,0]
["     Total Utility Costs",null,null,null,null,{"$f":"SUM(F112:F119)","v":0},null,{"$f":"SUM(H112:H119)","v":0},0]
[]
["Information Technology Costs Details:","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:",null,"DTS Contact"]
["IT Equipment ","($3-5/Sq. Ft or 2% of Total Construction Cost)",{"$f":"TCC","v":0},"TCC",0.02,{"$f":"C123*E123","v":0},{"$f":"F123/$C$25","v":{"$error":"#DIV/0!"}},0,{"$f":"F123-H123","v":0},null,null,"Greg Jackson",null,null,null,null,null,null,null,null,null,null,null,"This may be easier to identify as a per square foot cost"]
["AV Equipment Excluding Conduit","($15/SF or 1% of Total Construction Cost)",{"$f":"TCC","v":0},"TCC",0.01,0,{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These ones that are a per sq. ft cost versus a percentage, have you done the math to compare the difference?"]
["DAS Emergency Responder System","($2-3/Sq. Ft or 0.3% of Total Construction Cost)",{"$f":"TCC","v":0},"TCC",3.0000000000000001E-3,0,{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Added a $/SF on the side for comparison. Trying to keep all of the calculations we can using the same units"]
["DAS Cell Phone Repeater","($2-3/Sq. Ft or 0.3% of Total Construction Cost)",{"$f":"TCC","v":0},"TCC",3.0000000000000001E-3,0,{"$error":"#DIV/0!"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do we want to change the $/SF number or the % to make them match up better?"]
["Enter IT Details",null,0,"Unit",0,{"$f":"C127*E127","v":0},{"$error":"#DIV/0!"},0,0]
[null,null,0,"Unit",0,0,{"$error":"#DIV/0!"},0,0]
["     Total Information Technology Costs",null,null,null,null,{"$f":"SUM(F123:F128)","v":0},null,{"$f":"SUM(H123:H128)","v":0},0]
[]
["Utah Art Cost Details","Explanation","Units",null,"Manual Override","Cost",null,"Actual","Difference","Notes:"]
[" Is Utah Art Required? Select YES OR NO ►",null,"Choose One",null,0,{"$f":"IF(E132>0,E132,IF(C132<>\"YES\",0,IF(C132=\"YES\",IF(G48*0.01>200000,200000,G48*D133))))","v":0},null,{"$f":"SUM(H126:H131)","v":0},{"$f":"F132-H132","v":0}]
[null,null,"To supersede 1.0% auto-calculation change the percentage or enter Manual Override Amount above arrows:",0.01,"▲   ▲   ▲"]
[]
["Testing & Inspection Costs Details:","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["Building Code Inspection",null,{"$f":"TCC","v":0},"TCC",6.0000000000000001E-3,{"$f":"C136*E136","v":0},null,0,{"$f":"F136-H136","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"There is a cost for the FM review that we need to capture."]
["Material Testing"," ",{"$f":"TCC","v":0},"TCC",2E-3,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I just need to know what we want to carry for a hard number or a percentage."]
["Special Inspections"," ",{"$f":"TCC","v":0},"TCC",4.0000000000000001E-3,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sent Tom an email 5-16-22 asking for input"]
["Fire Marshal Review - General Review, Fire Suppression Review, and Fire Alarm Review ",null,{"$f":"TGSF","v":0},"SF",6.6000000000000003E-2,{"$f":"C139*E139","v":0},null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tom's response was \"They are charging 2.2 cents per square foot for general review, Fire Suppression review and Fire alarm review respectively. This equates to most projects to a 6.6 cent per square foot fee for their review.\""]
["Enter Testing and Inspection Details",null,0,"Unit",0,{"$f":"C140*E140","v":0},null,0,0]
[null,null,0,"Unit",0,{"$f":"C141*E141","v":0},null,0,0]
["Building Location Inspection Cost Increase Factor:",{"$f":"IF($F$1=\"Select County\",\"Select County At Top of page\",$F$1)","v":"Select County At Top of page"},{"$f":"TCC","v":0},"TCC",{"$f":"'Location Factors'!C9","v":0},{"$f":"IF(SUM(F136:F141)>0,(C142*E142),0)","v":0},null,0,0]
["     Total Testing & Inspection Costs",null,null,null,null,{"$f":"SUM(F136:F142)","v":0},null,{"$f":"SUM(H136:H142)","v":0},0]
[]
["Moving & Occupancy Costs Details:","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["Enter Moving & Occupancy Details","(Moving & Occupancy Costs 0.2% - 0.5%)",{"$f":"TCC","v":0},"TCC",2E-3,{"$f":"C146*E146","v":0},null,0,{"$f":"F146-H146","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Should this be 2% or 0.2%???"]
[null,null,0,"Unit",0,{"$f":"C147*E147","v":0},null,0,{"$f":"F147-H147","v":0}]
[null,null,0,"Unit",0,{"$f":"C148*E148","v":0},null,0,{"$f":"F148-H148","v":0}]
["     Total Moving & Occupancy Costs",null,null,null,null,{"$f":"SUM(F146:F148)","v":0},null,{"$f":"SUM(H146:H148)","v":0},{"$f":"F149-H149","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Travel Hotel $ + $50/Day for Meals and Taxes",null,null,null,null,null,null,null,null,null,null,null,null,"I would prefer this to be a unit cost amount and not a percentage"]
["DFCM Management Cost Details:","Explanation","Units",null,"Unit Cost","Cost","Units","Actual","Difference","Notes:","PM Travel - Project Duration ",null,null,null,null,null,null,null,null,null,null,null,null,"Or if we had a calculation that went off of the project duration that could calculate one trip every two weeks that the PM would estimate the per trip cost?"]
["Is Project 100% State Funded? Yes, No, Partially ►",null,"Choose One",null,null,null,{"$f":"G71","v":"TCC = Total Const Cost"},{"$f":"SUM(H146:H151)","v":0},{"$f":"F152-H152","v":0},null,"Bid Date to Estimated Completion Date",null,null,null,null,null,null,null,null,null,null,null,null,"Changed to total Duration from bid to estimated project completion, then calculated how many 2 week periods there are and used that to calculate trips, base on hotel cost +$50 for meals and taxes"]
[null,{"$f":"IF(C152=\"Partially\",\"If Partial, Enter Portion That Is State Agency Funded above arrows:\",\" \")","v":" "},null,null,{"$f":"IF(C152=\"Partially\",\"▲   ▲   ▲\",\"\")","v":""},null,"EA = Each",0,0,null,{"$f":"ROUNDUP(C55-C54,2)","v":0},"Days"]
["Enter DFCM Management Details","DFCM Management Fee",{"$f":"IF(C152=\"NO\",'DFCM Fee Schedule'!C4,IF(C152=\"Partially\",'DFCM Fee Schedule'!C20,0))","v":0},"Per DFCM Fee Schedule",null,{"$f":"IF(C152=\"No\",'DFCM Fee Schedule'!B4,IF(C152=\"Yes\",0,IF(C152=\"Partially\",'DFCM Fee Schedule'!B20,0)))","v":0},"SF = Square Feet",0,0,null,{"$f":"ROUNDUP(K153/365,2)","v":0},"Years"]
[null,null,0,"Unit",0,{"$f":"C155*E155","v":0},"LF = Lineal Feet",0,0,null,{"$f":"ROUNDUP(K154*12,2)","v":0},"Months"]
[{"$f":"K157","v":0},{"$f":"IF($F$1=\"Select County\",\"Select County At Top of page\",$F$1)","v":"Select County At Top of page"},1,"EA",{"$f":"'Location Factors'!C10","v":0},{"$f":"IF(SUM(F154:F155)>0,(A156*C156*E156),0)","v":0},"CF = Cubic Feet",0,0,null,{"$f":"ROUNDUP(K154*52,2)","v":0},"Weeks"]
["     Total DFCM Management Costs",null,null,null,null,{"$f":"SUM(F152:F156)","v":0},"CY = Cubic Yards",{"$f":"SUM(H152:H156)","v":0},0,null,{"$f":"ROUNDUP(K154*26,0)","v":0},"2 Weeks (Travel to Jobsite every 2 weeks, rounded up)"]
[null,null,null,null,null,null,"Fx = Formula"]
["User Fee Cost Details:","Explanation","Units",null,"Unit Cost","Cost",null,"Actual","Difference","Notes:"]
[{"$f":"IF($B$3=\"University Of Utah (UofU)\",\"PDC Management Fee (UofU Only)\",\"\")","v":""},{"$f":"IF($B$3=\"University Of Utah (UofU)\",\"Is This A Project Or A Study? ►\",\"\")","v":""},"Choose One",{"$f":"IF($B$3=\"University Of Utah (UofU)\",\"Non State Funded Amount\",\"\")","v":""},null,{"$f":"IF($B$3=\"University Of Utah (UofU)\",F209,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The UofU PDC Fee Schedule doesn't seem to calculating correctly."]
[{"$f":"IF($B$3=\"University Of Utah (UofU)\",\"Adjustment For Non State Funded Portion Of Project\",\"\")","v":""},{"$f":"IF($B$3=\"University Of Utah (UofU)\",\"Ensure Non-State Funding Is Entered Below\",\"\")","v":""},null,{"$f":"IF($B$3=\"University Of Utah (UofU)\",\"PDC Management Fee\",\"\")","v":""},null,{"$f":"IF($B$3=\"University Of Utah (UofU)\",'UofU PDC Fee Schedule'!$B$7,0)","v":0},null,0,{"$f":"F161-H161","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UofU fees only calculate if UofU is selected as the agency"]
["Enter User Fee Details",null,0,"Unit",0,{"$f":"C162*E162","v":0},null,0,{"$f":"F162-H162","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I have it taking the Non State funded amount to the PDC table and calculating the about from it. Is that how you understand it should work?"]
[null,null,0,"Unit",0,{"$f":"C163*E163","v":0},null,0,{"$f":"F163-H163","v":0}]
["     Total User Fee Costs",null,null,null,null,{"$f":"SUM(F161:F163)","v":0},null,{"$f":"SUM(H161:H163)","v":0},{"$f":"F164-H164","v":0},null,{"$f":"K79","v":"             "}]
[]
["HPBS Commissioning Cost Details:","Explanation","Units",null,"Unit Cost","Cost"]
["High Performance Building Standard","HPBS Consultant Fees",null,null,"Building Complexity Is Type:",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Actual","Difference","Notes:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C168*E168=10000,10000,IF(C168*E168=15000,15000,C168*E168))","v":{"$error":"#REF!"}}]
["Energy Study                                                 EnE Fee",{"$f":"IF($F$167=\"A\",'HPBS Consultants'!B6,IF($F$167=\"B\",'HPBS Consultants'!C6,IF($F$167=\"C\",'HPBS Consultants'!D6,IF($F$167=\"D\",'HPBS Consultants'!E6,IF($F$167=\"E\",'HPBS Consultants'!F6,0)))))","v":{"$error":"#REF!"}},{"$f":"TCC","v":0},"TCC",{"$f":"IF($F$167=\"A\",\"$10,000\",IF($F$167=\"B\",\"$15,000\",IF($F$167=\"C\",'HPBS Consultants'!D2,IF($F$167=\"D\",'HPBS Consultants'!E2,IF($F$167=\"E\",'HPBS Consultants'!F2,0)))))","v":{"$error":"#REF!"}},{"$f":"IF(E168=\"$10,000\",10000,IF(E168=\"$15,000\",15000,IF(C168*E168<15000,15000,C168*E168)))","v":{"$error":"#REF!"}},null,{"$f":"SUM(H162:H167)","v":0},{"$f":"F168-H168","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"We need a way to add budget to the energy study for those Universities that require LEED."]
["Exterior Envelope                                   BECxA Fee",{"$f":"IF($F$167=\"A\",'HPBS Consultants'!B7,IF($F$167=\"B\",'HPBS Consultants'!C7,IF($F$167=\"C\",'HPBS Consultants'!D7,IF($F$167=\"D\",'HPBS Consultants'!E7,IF($F$167=\"E\",'HPBS Consultants'!F7,0)))))","v":{"$error":"#REF!"}},{"$f":"TCC","v":0},"TCC",{"$f":"IF($F$167=\"A\",\"$20,000\",IF($F$167=\"B\",'HPBS Consultants'!C3,IF($F$167=\"C\",'HPBS Consultants'!D3,IF($F$167=\"D\",'HPBS Consultants'!E3,IF($F$167=\"E\",'HPBS Consultants'!F3,0)))))","v":{"$error":"#REF!"}},{"$f":"IF(E169=\"$20,000\",20000,IF(C169*E169>20000,C169*E169,20000))","v":{"$error":"#REF!"}},null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What fee, or percentage or cost do you want to carry for Lead?"]
["Enhanced Commissioning                              CxA Fee",{"$f":"IF($F$167=\"A\",'HPBS Consultants'!B8,IF($F$167=\"B\",'HPBS Consultants'!C8,IF($F$167=\"C\",'HPBS Consultants'!D8,IF($F$167=\"D\",'HPBS Consultants'!E8,IF($F$167=\"E\",'HPBS Consultants'!F8,0)))))","v":{"$error":"#REF!"}},{"$f":"TCC","v":0},"TCC",{"$f":"IF($F$167=\"A\",'HPBS Consultants'!B4,IF($F$167=\"B\",'HPBS Consultants'!C4,IF($F$167=\"C\",'HPBS Consultants'!D4,IF($F$167=\"D\",'HPBS Consultants'!E4,IF($F$167=\"E\",'HPBS Consultants'!F4,0)))))","v":{"$error":"#REF!"}},{"$f":"C170*E170","v":{"$error":"#REF!"}},null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Added Line for Leed, using percentages I found online, do you want to change?"]
["Energy Study For LEED Projects   ","Choose LEED Level",{"$f":"TCC","v":0},"TCC",{"$f":"IF(B171=\"Choose LEED Level\",'Drop Downs'!H2,IF(B171=\"LEED Certified – 0-2.5%\",'Drop Downs'!H3,IF(B171=\"LEED Silver – 0-3.3%\",'Drop Downs'!H4,IF(B171=\"LEED Gold – 0.3-5.0%\",'Drop Downs'!H5,IF(B171=\"LEED Platinum – 4.5-8.5%\",'Drop Downs'!H6,\"0%\")))))","v":0},{"$f":"C171*E171","v":0},null,0,0]
["Enter HPBS Details",null,0,"Unit",0,{"$f":"C172*E172","v":0},null,0,0]
["Consultant Building Location Cost Increase Factor:",{"$f":"IF($F$1=\"Select County\",\"Select County At Top of page\",$F$1)","v":"Select County At Top of page"},{"$f":"TCC","v":0},"TCC",{"$f":"'Location Factors'!C11","v":0},{"$f":"IF(SUM(F168:F172)>0,(C173*E173),0)","v":{"$error":"#REF!"}},null,0,{"$error":"#REF!"}]
["     Total HPBS Commissioning Costs",null,null,null,null,{"$f":"SUM(F168:F173)","v":{"$error":"#REF!"}},null,{"$f":"SUM(H168:H173)","v":0},{"$error":"#REF!"}]
[]
["Other Costs:","Explanation","Units",null,"Unit Cost","Cost",null,"Actual","Difference","Notes:"]
["Keying","0.15%-0.3%",{"$f":"TCC","v":0},"TCC",3.0000000000000001E-3,{"$f":"C177*E177","v":0},null,{"$f":"SUM(H171:H176)","v":0},{"$f":"F177-H177","v":0}]
["Building Signage",5.0000000000000001E-3,{"$f":"TCC","v":0},"TCC",5.0000000000000001E-3,0,null,0,0]
["Interior Signage","0.3% - 0.5%",{"$f":"TCC","v":0},"TCC",5.0000000000000001E-3,0,null,0,0]
["Branding",2E-3,{"$f":"TCC","v":0},"TCC",2E-3,0,null,0,0]
["Enter Other Cost Details",null,0,"TCC",0,0,null,0,0]
[null,null,0,"Unit",0,0,null,0,0]
["     Total Other Costs",null,null,null,null,{"$f":"SUM(F177:F182)","v":0},null,{"$f":"SUM(H177:H182)","v":0},0]
[]
["Contingency","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["Contingency",{"$f":"'Cap Devel CBE Summary'!B24","v":{"$error":"#DIV/0!"}},1,"EA",{"$f":"'Cap Devel CBE Summary'!C24","v":0},{"$f":"C186*E186","v":0},null,0,{"$f":"F186-H186","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Should this be 2% or 0.2%???"]
["     Total Contingency Cost",null,null,null,null,{"$f":"SUM(F186:F186)","v":0},null,{"$f":"SUM(H186:H186)","v":0},{"$f":"F187-H187","v":0}]
[]
["Builder's Risk Insurance","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["Builder's Risk Insurance","0.15% of Construction Budget",1,"EA",{"$f":"'Cap Devel CBE Summary'!C26","v":0},{"$f":"C190*E190","v":0},null,0,{"$f":"F190-H190","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Should this be 2% or 0.2%???"]
["     Total Builder's Risk Insurance Costs",null,null,null,null,{"$f":"SUM(F190:F190)","v":0},null,{"$f":"SUM(H190:H190)","v":0},{"$f":"F191-H191","v":0}]
[]
["Legal Services ","Explanation","Units",null,"Unit Cost/Rate","Cost",null,"Actual","Difference","Notes:"]
["Legal Services ","0.05% of Construction Budget",1,"EA",{"$f":"'Cap Devel CBE Summary'!C27","v":0},{"$f":"C194*E194","v":0},null,0,{"$f":"F194-H194","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Should this be 2% or 0.2%???"]
["     Total Legal Services Cost",null,null,null,null,{"$f":"SUM(F194:F194)","v":0},null,{"$f":"SUM(H194:H194)","v":0},{"$f":"F195-H195","v":0}]
[null,null,null,null,null,null,null,"Actual","Difference"]
["   Total Construction Costs & Soft Costs Before Deducting Previous State Funding and Non State Funding Sources",null,null,null,null,null,{"$f":"G48+G68+F80+F87+F93+F109+F120+F129+F132++F143+F149+F157+F164+F174+F183+F187+F191+F195-F203-F209","v":{"$error":"#REF!"}},{"$f":"H15+H35+H53+H67+H73+H98+H109+H127+H130+H141+H147+H155+H162+H172+H183+H187+H191+H195","v":{"$error":"#VALUE!"}},{"$f":"I48+I68+I80+I87+I93+I109+I120+I129+I132++I143+I149+I157+I164+I174+I183+I187+I191+I195","v":{"$error":"#REF!"}}]
[]
["Previous State Funding:","Explanation","Units",null,"Unit Cost","Cost",null,"Actual","Difference","Notes:"]
["Only show state appropriated funding & include costs covered by that funding in appropriate category above.",null,null,"EA",0,{"$f":"C200*E200","v":0},null,0,{"$f":"F200-H200","v":0}]
["Enter Previous State Funding Here","Enter Previous State Funding Details Here",0,"EA",0,{"$f":"C201*E201","v":0},null,0,{"$f":"F201-H201","v":0}]
[null,null,0,"Unit",0,{"$f":"C202*E202","v":0},null,0,{"$f":"F202-H202","v":0}]
["   Total Previous State Funding",null,null,null,null,{"$f":"SUM(F200:F202)","v":0},null,{"$f":"SUM(H200:H202)","v":0},{"$f":"F203-H203","v":0}]
[]
["Other Funding Sources:","(List Each Source And Give Details Of Each Source):","Units",null,"Unit Cost","Cost",null,"Actual","Difference","Notes:"]
["Enter Non State Funded Agency Source Here","Enter Non State Funded Agency Details Here",1,"EA",0,{"$f":"C206*E206","v":0},null,0,{"$f":"F206-H206","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How is this calculating at $8,000,000 if we already identified the State funding portion?  It may be easier to"]
[null," ",0,"Unit",0,{"$f":"C207*E207","v":0},null,0,{"$f":"F207-H207","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"calculate the Agency funding being provided and then have the form auto calculate the required amount remaining to"]
[null," ",0,"Unit",0,{"$f":"C208*E208","v":0},null,0,{"$f":"F208-H208","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"be State funding.  Does that make sense?"]
["   Total Other Funding",null,null,null,null,{"$f":"SUM(F206:F208)","v":0},null,{"$f":"SUM(H207)","v":0},{"$f":"F209-H209","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sorry, the $8,000,000 was a not a formula, it was hand typed in from a previous revision"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Don't we already get the total less agency funding on the summary page?"]
[null,null,null,null,null,null,null,"Actual","Difference","Notes:"]
["OFFICIAL UTAH DFCM CBE FORM V2.09 Last Revision: 2-14-2023","   Total Construction Costs & Soft Costs Less Previous State Funding And Non State Funding",null,null,null,null,{"$f":"TCC+G68+F80+F87+F93+F109+F120+F129+F132+F143+F149+F157+F164+F174+F183+F187+F191+F195-F203-F209","v":{"$error":"#REF!"}},{"$f":"H197-H203-H209","v":{"$error":"#VALUE!"}},{"$f":"I197-I203-I209","v":{"$error":"#REF!"}}]

{"sheet":"DFCM Fee Schedule","index":3,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":true,"merged":[[16,0,16,2]]}
["Non-State/Agency Funded DFCM Management Fee ",null,null,"DFCM’s Approved FY2023 Rates "]
["100% Non-State/Agency Funded DFCM Management Fee "]
["Escalated Total Construction Cost:",{"$f":"'Cap Devel CBE Details'!G48","v":0}]
["Total DFCM Management Fee:",{"$f":"(SUM(G6:G11))","v":0},{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Lower Limit of Range","Upper Limit of Range","Fee","Fixed Base $ Amount",null,"% Add ","DFCM Fee"]
[1,99999,"4% ($3,999 max)",0,"+",0.04,{"$f":"IF(OR($B$3<B6,$B$3=B6),$B$3*F6,0)","v":0}]
[100000,499999,"$4,000 + 1.8% over $100,000 ($11,200 max)",4000,"+",1.7999999999999999E-2,{"$f":"IF(AND($B$3>B6,OR($B$3<B7,$B$3=B7)),D7+(($B$3-A7)*F7),0)","v":0}]
[500000,2499999,"$11,200 + 0.9% over $500,000 ($29,200 max)",11200,"+",8.9999999999999993E-3,{"$f":"IF(AND($B$3>B7,OR($B$3<B8,$B$3=B8)),D8+(($B$3-A8)*F8),0)","v":0}]
[2500000,9999999,"$29,200 + 0.6% over $2,500,000 ($74,200 max)",29200,"+",6.0000000000000001E-3,{"$f":"IF(AND($B$3>B8,OR($B$3<B9,$B$3=B9)),D9+(($B$3-A9)*F9),0)","v":0}]
[10000000,49999999,"$74,200 + 0.18% over $10,000,000 ($146,200 max)",74200,"+",1.8E-3,{"$f":"IF(AND($B$3>B9,OR($B$3<B10,$B$3=B10)),D10+(($B$3-A10)*F10),0)","v":0}]
[50000000,"+ Up","$146,200 + 0.12% over $50,000,000 ($206,200 max at $100M)",146200,"+",1.1999999999999999E-3,{"$f":"IF($B$3>B10,D11+(($B$3-A11)*F11),0)","v":0}]
["Actual Costs are based on the Construction Contract, once established."]
[]
[]
[]
[]
[]
["Partial Non-State/Agency Funded DFCM Management Fee "]
["State Agency Funded Portion",{"$f":"'Cap Devel CBE Details'!E152","v":0}]
["Total DFCM Management Fee:",{"$f":"SUM(G22:G27)","v":0},{"$f":"B20/B19","v":{"$error":"#DIV/0!"}}]
["Lower Limit of Range","Upper Limit of Range","Fee","Fixed Base $ Amount",null,"% Add ","DFCM Fee"]
[1,99999,{"$f":"C6","v":"4% ($3,999 max)"},{"$f":"D6","v":0},"+",{"$f":"F6","v":0.04},{"$f":"IF(OR($B$19<B22,$B$19=B22),$B$19*F22,0)","v":0}]
[100000,499999,{"$f":"C7","v":"$4,000 + 1.8% over $100,000 ($11,200 max)"},4000,"+",{"$f":"F7","v":1.7999999999999999E-2},{"$f":"IF(AND($B$19>B22,OR($B$19<B23,$B$19=B23)),D23+(($B$19-A23)*F23),0)","v":0}]
[500000,2499999,"$11,200 + 0.9% over $500,000 ($29,200 max)",11200,"+",8.9999999999999993E-3,{"$f":"IF(AND($B$19>B23,OR($B$19<B24,$B$19=B24)),D24+(($B$19-A24)*F24),0)","v":0}]
[2500000,9999999,"$29,200 + 0.6% over $2,500,000 ($74,200 max)",29200,"+",6.0000000000000001E-3,{"$f":"IF(AND($B$19>B24,OR($B$19<B25,$B$19=B25)),D25+(($B$19-A25)*F25),0)","v":0}]
[10000000,49999999,"$74,200 + 0.18% over $10,000,000 ($146,200 max)",74200,"+",1.8E-3,{"$f":"IF(AND($B$19>B25,OR($B$19<B26,$B$19=B26)),D26+(($B$19-A26)*F26),0)","v":0}]
[50000000,"+ Up",{"$f":"C11","v":"$146,200 + 0.12% over $50,000,000 ($206,200 max at $100M)"},{"$f":"D11","v":146200},"+",1.1999999999999999E-3,{"$f":"IF($B$19>B26,D27+(($B$19-A27)*F27),0)","v":0}]
["Actual Costs are based on the Construction Contract, once established."]

{"sheet":"HPBS Consultants","index":4,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["HPBS Consultants","Schedule A","Schedule B","Schedule C","Schedule D","Schedule E"]
["EnE fee",10000,15000,1E-3,1.5E-3,2.2000000000000001E-3]
["BECxA fee",20000,1.5E-3,2E-3,2E-3,2.5000000000000001E-3]
["CxA fee",5.0000000000000001E-3,7.4999999999999997E-3,0.01,1.2500000000000001E-2,1.4999999999999999E-2]
[]
["EnE fee","$5,000 - $10,000 Quantitative Only","$8,000 - $15,000 Qualitative Only","The Greater of 0.05% - 0.1% or $15,000","The Greater of 0.1% - 0.15% or $15,000","The Greater of 0.15% - 0.22% or $15,000"]
["BECxA fee","$10,000 - $20,000","The Greater of 0.1% - 0.15% or $20,000","The Greater of 0.15% - 0.2% or $20,000","The Greater of 0.15%-0.2% or $20,000","The Greater of 0.2% - 0.25% or $20,000",null,null,"Changes from Fee Schedule as per Matt Boyer 7-27-2022"]
["CxA fee","0.3% - 0.5%","0.5% - 0.75%","0.75% - 1%","1% - 1.25%","1% - 1.5%"]

{"sheet":"Contingency","index":5,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[null,null,"Contingency Calculator"]
["Contingency","%","Construction Cost","Contingency",null,null,"Const Value","New","Remodel"]
["New",{"$f":"VLOOKUP(C3,G3:I43,2)","v":6.5000000000000002E-2},{"$f":"IF('Cap Devel CBE Details'!G16=0,0,IF('Cap Devel CBE Details'!G23=0,'Cap Devel CBE Details'!G48,'Cap Devel CBE Details'!G48-'Cap Devel CBE Details'!G23))","v":0},{"$f":"B3*C3","v":0},null,1,0,6.5000000000000002E-2,9.5000000000000001E-2]
["Remodel",{"$f":"VLOOKUP(C4,G3:I43,3)","v":9.5000000000000001E-2},{"$f":"IF('Cap Devel CBE Details'!G16=0,'Cap Devel CBE Details'!G48,'Cap Devel CBE Details'!G23)","v":0},{"$f":"B4*C4","v":0},null,2,250001,6.4000000000000001E-2,{"$f":"+I3-0.0025","v":9.2499999999999999E-2}]
["Total",{"$f":"D5/C5","v":{"$error":"#DIV/0!"}},{"$f":"(SUM(C3:C4))","v":0},{"$f":"(SUM(D3:D4))","v":0},null,3,500001,6.3E-2,{"$f":"+I4-0.0025","v":0.09}]
[null,null,null,null,null,4,750001,6.2E-2,{"$f":"+I5-0.0025","v":8.7499999999999994E-2}]
[null,null,null,null,null,5,1000001,6.0999999999999999E-2,{"$f":"+I6-0.0025","v":8.4999999999999992E-2}]
[null,null,null,null,null,6,1250001,0.06,8.4000000000000005E-2]
[null,null,null,null,null,7,1500001,5.9499999999999997E-2,8.3000000000000004E-2]
[null,null,null,null,null,8,1750001,5.8999999999999997E-2,8.2000000000000003E-2]
[null,null,null,null,null,9,2000001,5.8500000000000003E-2,8.1000000000000003E-2]
[null,null,null,null,null,10,2250001,5.8000000000000003E-2,0.08]
[null,null,null,null,null,11,2500001,5.7500000000000002E-2,7.9000000000000001E-2]
[null,null,null,null,null,12,2750001,5.7000000000000002E-2,7.8E-2]
[null,null,null,null,null,13,3000001,5.6500000000000002E-2,7.6999999999999999E-2]
[null,null,null,null,null,14,3250001,5.6000000000000001E-2,7.5999999999999998E-2]
[null,null,null,null,null,15,3500001,5.5500000000000001E-2,7.4999999999999997E-2]
[null,null,null,null,null,16,3750001,5.5E-2,7.3999999999999996E-2]
[null,null,null,null,null,17,4000001,5.45E-2,7.2999999999999995E-2]
[null,null,null,null,null,18,4250001,5.3999999999999999E-2,7.1999999999999995E-2]
[null,null,null,null,null,19,4500001,5.3499999999999999E-2,7.0999999999999994E-2]
[null,null,null,null,null,20,4750001,5.2999999999999999E-2,7.0000000000000007E-2]
[null,null,null,null,null,21,5000001,5.2499999999999998E-2,6.9500000000000006E-2]
[null,null,null,null,null,22,5250001,5.1999999999999998E-2,6.9000000000000006E-2]
[null,null,null,null,null,23,5500001,5.1499999999999997E-2,6.8500000000000005E-2]
[null,null,null,null,null,24,5750001,5.0999999999999997E-2,6.8000000000000005E-2]
[null,null,null,null,null,25,6000001,5.0500000000000003E-2,6.7500000000000004E-2]
[null,null,null,null,null,26,6250001,0.05,6.7000000000000004E-2]
[null,null,null,null,null,27,6500001,4.9500000000000002E-2,6.6500000000000004E-2]
[null,null,null,null,null,28,6750001,4.9000000000000002E-2,6.6000000000000003E-2]
[null,null,null,null,null,29,7000001,4.8500000000000001E-2,6.5500000000000003E-2]
[null,null,null,null,null,30,7250001,4.8000000000000001E-2,6.5000000000000002E-2]
[null,null,null,null,null,31,7500001,4.7500000000000001E-2,6.4500000000000002E-2]
[null,null,null,null,null,32,7750001,4.7E-2,6.4000000000000001E-2]
[null,null,null,null,null,33,8000001,4.65E-2,6.3500000000000001E-2]
[null,null,null,null,null,34,8250001,4.5999999999999999E-2,6.3E-2]
[null,null,null,null,null,35,8500001,4.5999999999999999E-2,6.25E-2]
[null,null,null,null,null,36,8750001,4.5499999999999999E-2,6.2E-2]
[null,null,null,null,null,37,9000001,4.5499999999999999E-2,6.1499999999999999E-2]
[null,null,null,null,null,38,9250001,4.5499999999999999E-2,6.0999999999999999E-2]
[null,null,null,null,null,39,9500001,4.4999999999999998E-2,6.0499999999999998E-2]
[null,null,null,null,null,40,9750001,4.4999999999999998E-2,0.06]
[null,null,null,null,null,41,10000001,4.4999999999999998E-2,0.06]

{"sheet":"Location Factors","index":6,"n_rows":80,"n_cols":27,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Choose County","Building Location Cost  Increase","HazMat Building Location Cost Increase","Pre-Design Location Cost Increase ","A/E Design Location Cost Increase","Inspection Location Cost Increase ","DFCM PM Travel Cost Increase","Consultant Location Cost Increase",null,null,"Select County","Building Location Cost  Increase Factor","HazMat Building Location Cost Increase Factor","Pre-Design Location Cost Increase Factor","A/E Design Location Cost Increase Factor","Inspection Location Cost Increase Factor","DFCM PM Travel Hotel & Food Per Diem Rates","Consultant Location Cost Increase Factor",null,null,null,null,"Inspection Location Cost Increase Factor"]
["Const Cost:",{"$f":"'Cap Devel CBE Details'!G48","v":0},null,null,"Beaver County",{"$f":"$B$2*P2","v":0},{"$f":"$B$2*Q2","v":0},{"$f":"$B$2*R2","v":0},{"$f":"$B$2*S2","v":0},{"$f":"$B$2*T2","v":0},{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U2","v":0},{"$f":"$B$2*V2","v":0},null,null,"Beaver County",3.7500000000000006E-2,7.0000000000000007E-5,7.0000000000000007E-5,1E-4,1E-4,{"$f":"P37","v":125},1E-4,null,null,null,1.5000000000000001E-2,2.5000000000000001E-2]
["GSF:",{"$f":"'Cap Devel CBE Details'!C25","v":0},null,null,"Box Elder County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U3","v":0},0,null,null,"Box Elder County",1.2499999999999997E-2,2.0000000000000002E-5,2.0000000000000002E-5,3.0000000000000001E-5,3.0000000000000001E-5,{"$f":"P38","v":140},3.0000000000000001E-5,null,null,null,0,1.4999999999999999E-2]
["County:",{"$f":"'Cap Devel CBE Details'!F1","v":"Select County"},"Factor",null,"Cache County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U4","v":0},0,null,null,"Cache County",2.5000000000000001E-3,3.0000000000000001E-5,3.0000000000000001E-5,5.0000000000000002E-5,5.0000000000000002E-5,{"$f":"P39","v":140},5.0000000000000002E-5,null,null,null,0,0.01]
["Building Location Cost  Increase Factor:",null,{"$f":"VLOOKUP($B$4,$O$2:$V$31,2)","v":0},{"$f":"$B$2*C5","v":0},"Carbon County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U5","v":0},0,null,null,"Carbon County",1.2499999999999997E-2,4.0000000000000003E-5,4.0000000000000003E-5,6.0000000000000002E-5,6.0000000000000002E-5,{"$f":"P40","v":125},6.0000000000000002E-5,null,null,null,4.9999999999999992E-3,1.4999999999999999E-2]
["HazMat Building Location Cost Increase Factor:",null,{"$f":"VLOOKUP($B$4,$O$2:$V$31,3)","v":0},{"$f":"$B$2*C6","v":0},"Daggett County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U6","v":0},0,null,null,"Daggett County",4.9999999999999989E-2,6.0000000000000002E-5,6.0000000000000002E-5,9.0000000000000006E-5,9.0000000000000006E-5,125,9.0000000000000006E-5,null,null,null,0,0]
["Pre-Design Location Cost Increase Factor:",null,{"$f":"VLOOKUP($B$4,$O$2:$V$31,4)","v":0},0,"Davis County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U7","v":0},0,null,null,"Davis County",0,1.0000000000000001E-5,1.0000000000000001E-5,1.0000000000000001E-5,1.0000000000000001E-5,150,1.0000000000000001E-5,null,null,null,1.9999999999999997E-2,0.03]
["A/E Design Location Cost Increase Factor:",null,{"$f":"VLOOKUP($B$4,$O$2:$V$31,5)","v":0},0,"Duchesne County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U8","v":0},0,null,null,"Duchesne County",2.5000000000000001E-2,4.0000000000000003E-5,4.0000000000000003E-5,6.0000000000000002E-5,6.0000000000000002E-5,140,6.0000000000000002E-5,null,null,null,0,1.4999999999999999E-2]
["Inspection Location Cost Increase Factor:",null,{"$f":"VLOOKUP($B$4,$O$2:$V$31,6)","v":0},0,"Emery County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U9","v":0},0,null,null,"Emery County",3.7500000000000006E-2,5.0000000000000002E-5,5.0000000000000002E-5,7.9999999999999993E-5,7.9999999999999993E-5,160,7.9999999999999993E-5,null,null,null,0.01,0.02]
["DFCM PM Travel Cost Increase Factor:",null,{"$f":"VLOOKUP($B$4,$O$2:$V$31,7)","v":0},"Per Night","Garfield County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U10","v":0},0,null,null,"Garfield County",2.5000000000000001E-2,9.0000000000000006E-5,9.0000000000000006E-5,1.3000000000000002E-4,1.3000000000000002E-4,140,1.3000000000000002E-4,null,null,null,1.5000000000000001E-2,2.5000000000000001E-2]
["Consultant Location Cost Increase Factor:",null,{"$f":"VLOOKUP($B$4,$O$2:$V$31,8)","v":0},0,"Grand County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U11","v":0},0,null,null,"Grand County",4.9999999999999989E-2,8.0000000000000007E-5,8.0000000000000007E-5,1.2E-4,1.2E-4,160,1.2E-4,null,null,null,0.01,0.02]
[null,null,null,null,"Iron County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U12","v":0},0,null,null,"Iron County",2.5000000000000001E-2,8.0000000000000007E-5,8.0000000000000007E-5,1.2E-4,1.2E-4,130,1.2E-4,null,null,null,1.9999999999999997E-2,0.03]
[null,null,null,null,"Juab County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U13","v":0},0,null,null,"Juab County",1.2499999999999997E-2,3.0000000000000001E-5,3.0000000000000001E-5,5.0000000000000002E-5,5.0000000000000002E-5,125,5.0000000000000002E-5,null,null,null,2.5000000000000005E-3,1.2500000000000001E-2]
[null,null,null,null,"Kane County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U14","v":0},0,null,null,"Kane County",4.9999999999999989E-2,1.1E-4,1.1E-4,1.6000000000000001E-4,1.6000000000000001E-4,140,1.6000000000000001E-4,null,null,null,4.9999999999999992E-3,1.4999999999999999E-2]
[null,null,null,null,"Millard County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U15","v":0},0,null,null,"Millard County",1.2499999999999997E-2,5.0000000000000002E-5,5.0000000000000002E-5,7.9999999999999993E-5,7.9999999999999993E-5,130,7.9999999999999993E-5,null,null,null,1.9999999999999997E-2,0.03]
[null,null,null,null,"Morgan County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U16","v":0},0,null,null,"Morgan County",7.4999999999999997E-3,2.0000000000000002E-5,2.0000000000000002E-5,3.0000000000000004E-5,3.0000000000000004E-5,125,3.0000000000000004E-5,null,null,null,4.9999999999999992E-3,1.4999999999999999E-2]
[null,null,null,null,"Piute County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U17","v":0},0,null,null,"Piute County",2.5000000000000001E-2,6.9999999999999994E-5,6.9999999999999994E-5,1.1E-4,1.1E-4,125,1.1E-4,null,null,null,0,1.2500000000000001E-2]
[null,null,null,null,"Rich County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U18","v":0},0,null,null,"Rich County",1.2499999999999997E-2,4.0000000000000003E-5,4.0000000000000003E-5,6.0000000000000002E-5,6.0000000000000002E-5,130,6.0000000000000002E-5,null,null,null,0.01,0.02]
[null,null,null,null,"Salt Lake County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U19","v":0},0,null,null,"Salt Lake County",0,0,0,0,0,150,0,null,null,null,4.9999999999999992E-3,1.4999999999999999E-2]
[null,null,null,null,"San Juan County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U20","v":0},0,null,null,"San Juan County",4.9999999999999989E-2,1E-4,1E-4,1.4999999999999999E-4,1.4999999999999999E-4,150,1.4999999999999999E-4,null,null,null,0,0]
[null,null,null,null,"Sanpete County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U21","v":0},0,null,null,"Sanpete County",1.2499999999999997E-2,5.0000000000000002E-5,5.0000000000000002E-5,7.0000000000000007E-5,7.0000000000000007E-5,{"$f":"P56","v":130},7.0000000000000007E-5,null,null,null,1.9999999999999997E-2,0.03]
[null,null,null,null,"Select County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U22","v":0},0,null,null,"Select County",0,0,0,0,0,0,0,null,null,null,4.9999999999999992E-3,1.4999999999999999E-2]
[null,null,null,null,"Sevier County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U23","v":0},0,null,null,"Sevier County",1.2499999999999997E-2,6.0000000000000002E-5,6.0000000000000002E-5,9.0000000000000006E-5,9.0000000000000006E-5,{"$f":"P58","v":125},9.0000000000000006E-5,null,null,null,4.9999999999999992E-3,1.4999999999999999E-2]
[null,null,null,null,"Summit County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U24","v":0},0,null,null,"Summit County",1.2499999999999997E-2,2.0000000000000002E-5,2.0000000000000002E-5,3.0000000000000004E-5,3.0000000000000004E-5,{"$f":"P59","v":160},3.0000000000000004E-5,null,null,null,0,1.4999999999999999E-2]
[null,null,null,null,"Tooele County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U25","v":0},0,null,null,"Tooele County",1.2499999999999997E-2,2.0000000000000002E-5,2.0000000000000002E-5,2.0000000000000002E-5,2.0000000000000002E-5,150,2.0000000000000002E-5,null,null,null,4.9999999999999992E-3,1.4999999999999999E-2]
[null,null,null,null,"Uintah County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U26","v":0},0,null,null,"Uintah County",2.5000000000000001E-2,6.0000000000000002E-5,6.0000000000000002E-5,9.0000000000000006E-5,9.0000000000000006E-5,145,9.0000000000000006E-5,null,null,null,0.01,0.02]
[null,null,null,null,"Utah County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U27","v":0},0,null,null,"Utah County",0,2.0000000000000002E-5,2.0000000000000002E-5,3.0000000000000004E-5,3.0000000000000004E-5,135,3.0000000000000004E-5,null,null,null,0,0.01]
[null,null,null,null,"Wasatch County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U28","v":0},0,null,null,"Wasatch County",1.2499999999999997E-2,2.0000000000000002E-5,2.0000000000000002E-5,3.0000000000000004E-5,3.0000000000000004E-5,160,3.0000000000000004E-5,null,null,null,0,1.4999999999999999E-2]
[null,null,null,null,"Washington County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U29","v":0},0,null,null,"Washington County",7.4999999999999997E-3,1.1E-4,1.1E-4,1.5999999999999999E-4,1.5999999999999999E-4,135,1.5999999999999999E-4,null,null,null,2.5000000000000005E-3,1.2500000000000001E-2]
[null,null,null,null,"Wayne County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U30","v":0},0,null,null,"Wayne County",3.7500000000000006E-2,7.0000000000000007E-5,7.0000000000000007E-5,1E-4,1E-4,145,1E-4,null,null,null,1.5000000000000001E-2,2.5000000000000001E-2]
[null,null,null,null,"Weber County",0,0,0,0,0,{"$f":"'Cap Devel CBE Details'!$A$156*'Cap Devel CBE Details'!$C$156*U31","v":0},0,null,null,"Weber County",0,2.0000000000000002E-5,2.0000000000000002E-5,2.0000000000000002E-5,2.0000000000000002E-5,145,2.0000000000000002E-5,null,null,null,0,0.01]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK Per Thomas Peterson 9-29-2021"]
[null,null,null,null,null,null,null,null,"Lodging Per Diem Rates","Unless listed below, the lodging per diem rate for a Utah city is $75.00 (plus tax). ","$50 added for Meals and Taxes",null,null,null,"Select County","DFCM PM Travel Hotel & Food Per Diem Rates",null,null,null,"Inspection Location Cost Increase Factor","Less 1.2%"]
[null,null,null,null,null,null,null,null,"All Other UT Cities $75.00 (plus tax)",75,{"$f":"J37+50","v":125},"All Other Cities",null,null,"Beaver County",{"$f":"K37","v":125},null,null,null,2.5000000000000001E-2,{"$f":"T37-1.2%","v":1.3000000000000001E-2}]
[null,null,null,null,null,null,null,null,"Tremonton$90.00 (plus tax)",90,140,"Box Elder County",null,null,"Box Elder County",{"$f":"K38","v":140},null,null,null,0.01,0]
[null,null,null,null,null,null,null,null,"Brigham City$80.00 (plus tax)",80,130,"Box Elder County",null,null,"Cache County",{"$f":"K40","v":140},null,null,null,0.01,0]
[null,null,null,null,null,null,null,null,"Logan$90.00 (plus tax)",90,140,"Cache County",null,null,"Carbon County",{"$f":"K37","v":125},null,null,null,1.4999999999999999E-2,{"$f":"T40-1.2%","v":2.9999999999999992E-3}]
[null,null,null,null,null,null,null,null,"Centerville$100.00 (plus tax)",100,150,"Davis County",null,null,"Daggett County",{"$f":"K37","v":125},null,null,null,0.03,1.7999999999999999E-2]
[null,null,null,null,null,null,null,null,"Farmington$90.00 (plus tax)",90,140,"Davis County",null,null,"Davis County",{"$f":"K41","v":150},null,null,null,0.01,0]
[null,null,null,null,null,null,null,null,"Layton$90.00 (plus tax)",90,140,"Davis County",null,null,"Duchesne County",{"$f":"K44","v":140},null,null,null,0.02,8.0000000000000002E-3]
[null,null,null,null,null,null,null,null,"Duchesne$90.00 (plus tax)",90,140,"Duchesne County",null,null,"Emery County",{"$f":"K46","v":160},null,null,null,2.5000000000000001E-2,1.3000000000000001E-2]
[null,null,null,null,null,null,null,null,"Roosevelt$90.00 (plus tax)",90,140,"Duchesne County",null,null,"Garfield County",{"$f":"K48","v":140},null,null,null,0.02,8.0000000000000002E-3]
[null,null,null,null,null,null,null,null,"Green River$110.00 (plus tax)",110,160,"Emery County",null,null,"Grand County",{"$f":"K49","v":160},null,null,null,0.03,1.7999999999999999E-2]
[null,null,null,null,null,null,null,null,"Tropic$95.00 (plus tax)",95,145,"Garfield County",null,null,"Iron County",{"$f":"K50","v":130},null,null,null,1.2500000000000001E-2,5.0000000000000044E-4]
[null,null,null,null,null,null,null,null,"Bryce Canyon City$90.00(plus tax)",90,140,"Garfield County",null,null,"Juab County",{"$f":"K37","v":125},null,null,null,1.4999999999999999E-2,2.9999999999999992E-3]
[null,null,null,null,null,null,null,null,"Moab$110.00 (plus tax)",110,160,"Grand County",null,null,"Kane County",{"$f":"K51","v":140},null,null,null,0.03,1.7999999999999999E-2]
[null,null,null,null,null,null,null,null,"Cedar City$80.00 (plus tax)",80,130,"Iron County",null,null,"Millard County",{"$f":"K52","v":130},null,null,null,1.4999999999999999E-2,2.9999999999999992E-3]
[null,null,null,null,null,null,null,null,"Kanab$90.00 (plus tax)",90,140,"Kane County",null,null,"Morgan County",{"$f":"K37","v":125},null,null,null,0.01,0]
[null,null,null,null,null,null,null,null,"Fillmore$80.00 (plus tax)",80,130,"Millard County",null,null,"Piute County",{"$f":"K37","v":125},null,null,null,0.02,8.0000000000000002E-3]
[null,null,null,null,null,null,null,null,"Garden City$80.00 (plus tax)",80,130,"Rich County",null,null,"Rich County",{"$f":"K53","v":130},null,null,null,1.4999999999999999E-2,2.9999999999999992E-3]
[null,null,null,null,null,null,null,null,"Draper$100.00 (plus tax)",100,150,"Salt Lake County",null,null,"Salt Lake County",{"$f":"K55","v":150},null,null,null,0,0]
[null,null,null,null,null,null,null,null,"SLC Area$100.00 (plus tax)",100,150,"Salt Lake County",null,null,"San Juan County",{"$f":"K56","v":150},null,null,null,0.03,1.7999999999999999E-2]
[null,null,null,null,null,null,null,null,"Bluff$100.00 (plus tax)",100,150,"San Juan County",null,null,"Sanpete County",{"$f":"K61","v":130},null,null,null,1.4999999999999999E-2,2.9999999999999992E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select County",0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"Mexican Hat$90.00 (plus tax)",90,140,"San Juan County",null,null,"Sevier County",{"$f":"K37","v":125},null,null,null,1.4999999999999999E-2,2.9999999999999992E-3]
[null,null,null,null,null,null,null,null,"Blanding$85.00 (plus tax)",85,135,"San Juan County",null,null,"Summit County",{"$f":"K62","v":160},null,null,null,0.01,0]
[null,null,null,null,null,null,null,null,"Monticello$80.00 (plus tax)",80,130,"San Juan County",null,null,"Tooele County",{"$f":"K63","v":150},null,null,null,1.4999999999999999E-2,2.9999999999999992E-3]
[null,null,null,null,null,null,null,null,"Ephraim$80.00 (plus tax)",80,130,"Sanpete County",null,null,"Uintah County",{"$f":"K64","v":145},null,null,null,0.02,8.0000000000000002E-3]
[null,null,null,null,null,null,null,null,"Park City$110.00 (plus tax)",110,160,"Summit County",null,null,"Utah County",{"$f":"K66","v":135},null,null,null,0.01,0]
[null,null,null,null,null,null,null,null,"Tooele$100.00 (plus tax)",100,150,"Tooele County",null,null,"Wasatch County",{"$f":"K71","v":160},null,null,null,0.01,0]
[null,null,null,null,null,null,null,null,"Vernal$95.00 (plus tax)",95,145,"Uintah County",null,null,"Washington County",{"$f":"K73","v":135},null,null,null,1.2500000000000001E-2,5.0000000000000044E-4]
[null,null,null,null,null,null,null,null,"Ballard$90.00 (plus tax)",90,140,"Uintah County",null,null,"Wayne County",{"$f":"K78","v":145},null,null,null,2.5000000000000001E-2,1.3000000000000001E-2]
[null,null,null,null,null,null,null,null,"American Fork$85.00 (plus tax)",85,135,"Utah County",null,null,"Weber County",{"$f":"K80","v":145},null,null,null,0.01,0]
[null,null,null,null,null,null,null,null,"Lehi$85.00 (plus tax)",85,135,"Utah County",null,null,null,null,null,null,null,"OK Per Thomas Peterson 9-29-2021"]
[null,null,null,null,null,null,null,null,"Orem$85.00 (plus tax)",85,135,"Utah County"]
[null,null,null,null,null,null,null,null,"Provo$85.00 (plus tax)",85,135,"Utah County"]
[null,null,null,null,null,null,null,null,"Springville$85.00 (plus tax)",85,135,"Utah County"]
[null,null,null,null,null,null,null,null,"Midway$110.00 (plus tax)",110,160,"Wasatch County"]
[null,null,null,null,null,null,null,null,"Heber$85.00 (plus tax)",85,135,"Wasatch County"]
[null,null,null,null,null,null,null,null,"Hurricane$85.00 (plus tax)",85,135,"Washington County"]
[null,null,null,null,null,null,null,null,"La Verkin$85.00 (plus tax)",85,135,"Washington County"]
[null,null,null,null,null,null,null,null,"Springdale$85.00 (plus tax)",85,135,"Washington County"]
[null,null,null,null,null,null,null,null,"St George$85.00 (plus tax)",85,135,"Washington County"]
[null,null,null,null,null,null,null,null,"Washington$85.00 (plus tax)",85,135,"Washington County"]
[null,null,null,null,null,null,null,null,"Torrey$95.00 (plus tax)",95,145,"Wayne County"]
[null,null,null,null,null,null,null,null,"Hanksville$85.00 (plus tax)",85,135,"Wayne County"]
[null,null,null,null,null,null,null,null,"Ogden$95.00 (plus tax)",95,145,"Weber County"]

{"sheet":"County Seat Distances","index":7,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[1,"Beaver County","Beaver",6629,"Distance from Salt Lake City, Utah to Beaver",198.8,{"$f":"F1/1000000","v":1.9880000000000001E-4},{"$f":"ROUNDUP(G1,5)","v":2.0000000000000001E-4}]
[2,"Box Elder County","Brigham City",49975,"Distance from Salt Lake City, Utah to Brigham City",59.3,{"$f":"F2/1000000","v":5.9299999999999998E-5},{"$f":"ROUNDUP(G2,5)","v":6.0000000000000002E-5}]
[3,"Cache County","Logan",112656,"Distance from Salt Lake City, Utah to Logan",82.3,8.2299999999999995E-5,9.0000000000000006E-5]
[4,"Carbon County","Price",21403,"Distance from Salt Lake City, Utah to Price",118.9,1.189E-4,1.2E-4]
[5,"Daggett County","Manila",1059,"Distance from Salt Lake City, Utah to Manila",169.3,1.6930000000000002E-4,1.7000000000000001E-4]
[6,"Davis County","Farmington",306479,"Distance from Salt Lake City, Utah to Farmington",16.899999999999999,1.6899999999999997E-5,2.0000000000000002E-5]
[7,"Duchesne County","Duchesne",18607,"Distance from Salt Lake City, Utah to Duchesne",114.7,1.147E-4,1.2E-4]
[8,"Emery County","Castle Dale",10976,"Distance from Salt Lake City, Utah to Castle Dale",149.19999999999999,1.4919999999999999E-4,1.4999999999999999E-4]
[9,"Garfield County","Panguitch",5172,"Distance from Salt Lake City, Utah to Panguitch",245.1,2.4509999999999999E-4,2.5000000000000001E-4]
[10,"Grand County","Moab",9225,"Distance from Salt Lake City, Utah to Moab",233.8,2.3380000000000002E-4,2.4000000000000001E-4]
[11,"Iron County","Parowan",46163,"Distance from Salt Lake City, Utah to Parowan",232.5,2.3250000000000001E-4,2.4000000000000001E-4]
[12,"Juab County","Nephi",10246,"Distance from Salt Lake City, Utah to Nephi",83.6,8.3599999999999999E-5,9.0000000000000006E-5]
[13,"Kane County","Kanab",7125,"Distance from Salt Lake City, Utah to Kanab",312.2,3.122E-4,3.2000000000000003E-4]
[14,"Millard County","Fillmore",12503,"Distance from Salt Lake City, Utah to Fillmore",145.1,1.451E-4,1.4999999999999999E-4]
[15,"Morgan County","Morgan",9469,"Distance from Salt Lake City, Utah to Morgan",46.8,4.6799999999999999E-5,5.0000000000000002E-5]
[16,"Piute County","Junction",1556,"Distance from Salt Lake City, Utah to Junction",205.4,2.0540000000000001E-4,2.1000000000000001E-4]
[17,"Rich County","Randolph",2264,"Distance from Salt Lake City, Utah to Randolph",116.9,1.1690000000000001E-4,1.2E-4]
[18,"Salt Lake County","Salt Lake City",1029665,"Distance from Salt Lake City, Utah to Salt Lake City",0,0,0]
[19,"San Juan County","Monticello",14746,"Distance from Salt Lake City, Utah to Monticello",287.7,2.877E-4,2.9E-4]
[20,"Sanpete County","Manti",27882,"Distance from Salt Lake City, Utah to Manti",124.3,1.2429999999999999E-4,1.3000000000000002E-4]
[21,"Sevier County","Richfield",20802,"Distance from Salt Lake City, Utah to Richfield",162,1.6200000000000001E-4,1.7000000000000001E-4]
[22,"Summit County","Coalville",36324,"Distance from Salt Lake City, Utah to Coalville",44.8,4.4799999999999998E-5,5.0000000000000002E-5]
[23,"Tooele County","Tooele",58218,"Distance from Salt Lake City, Utah to Tooele",35.4,3.54E-5,4.0000000000000003E-5]
[24,"Uintah County","Vernal",32588,"Distance from Salt Lake City, Utah to Vernal",172.7,1.727E-4,1.8000000000000001E-4]
[25,"Utah County","Provo",516564,"Distance from Salt Lake City, Utah to Provo",45.3,4.5299999999999997E-5,5.0000000000000002E-5]
[26,"Wasatch County","Heber City",23530,"Distance from Salt Lake City, Utah to Heber City",45.2,4.5200000000000001E-5,5.0000000000000002E-5]
[27,"Washington County","St. George",138115,"Distance from Salt Lake City, Utah to St. George",301.89999999999998,3.0189999999999997E-4,3.1E-4]
[28,"Wayne County","Loa",2589,"Distance from Salt Lake City, Utah to Loa",196.7,1.9669999999999998E-4,2.0000000000000001E-4]
[29,"Weber County","Ogden",231236,"Distance from Salt Lake City, Utah to Ogden",38.200000000000003,3.82E-5,4.0000000000000003E-5]

{"sheet":"UofU PDC Fee Schedule","index":8,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
["Planning Design & Construction"]
["PDC Management Fee"]
["Effective July 1, 2019"]
[]
["Total Project Cost*:",{"$f":"'Cap Devel CBE Summary'!C12+SUM('Cap Devel CBE Summary'!C15:C28)+SUM('Cap Devel CBE Summary'!C30:C31)","v":{"$error":"#REF!"}},"*Calculated before User Fee."]
["Project / Study**:",{"$f":"'Cap Devel CBE Details'!C160","v":"Choose One"},"** Studies incur a 5% fee."]
["Fee:",{"$f":"IF(OR(B5=\"\",B6=\"Choose One\"),\"\",ROUND(IF(B6=\"Study\",B5*0.05,SUM(H11:H19)),0))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Project","Study","Non-State"]
[null,null,null,null,null,{"$f":"B5","v":{"$error":"#REF!"}},{"$f":"B5","v":{"$error":"#REF!"}},{"$f":"'Cap Devel CBE Details'!F209","v":0}]
["Lower Limit of Range","Upper Limit of Range","Fee"]
[1,100000,0.05,null,0.05,{"$f":"IF(OR(F$9<$B11,F$9=$B11),F$9*$E11,0)","v":{"$error":"#REF!"}},{"$f":"B5*0.05","v":{"$error":"#REF!"}},{"$f":"IF(OR(H$9<$B11,H$9=$B11),H$9*$E11,0)","v":0}]
[100001,250000,"$5,000 + 5% over $100,000",5000,0.05,{"$f":"IF(AND(F$9>$B11,OR(F$9<$B12,F$9=$B12)),$D12+((F$9-$B11)*$E12),0)","v":{"$error":"#REF!"}},null,{"$f":"IF(AND(H$9>$B11,OR(H$9<$B12,H$9=$B12)),$D12+((H$9-$B11)*$E12),0)","v":0}]
[250001,500000,"$12,500 + 4.5% over $250,000",12500,4.4999999999999998E-2,{"$error":"#REF!"},null,0]
[500001,2500000,"$23,750 + 4% over $500,000",23750,0.04,{"$error":"#REF!"},null,0]
[2500001,10000000,"$103,750 + 3% over $2,500,000",103750,0.03,{"$error":"#REF!"},null,0]
[10000001,15000000,"$328,750 + 2% over $10,000,000",328750,0.02,{"$error":"#REF!"},null,0]
[15000001,50000000,"$428,750 + 1% over $15,000,000",428750,0.01,{"$error":"#REF!"},null,0]
[50000001,100000000,"$778,750 + .1% over $50,000,000",778750,1E-3,{"$error":"#REF!"},null,0]
["$100,000,001",999999999999999,"$828,750 + .1% over $100,000,000",828750,1E-3,{"$error":"#REF!"},null,0]
[]
[null,null,null,null,null,{"$f":"SUM(F11:F19)","v":{"$error":"#REF!"}},{"$f":"SUM(G11:G19)","v":{"$error":"#REF!"}},{"$f":"SUM(H11:H19)","v":0}]

{"sheet":"Drop Downs","index":9,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Yes or No","Is Project State Funded?","Project Complexity","Select Agency / Institution","Select Project or Study:","Select Delivery Method","Leed Certification Levels","Leed Cost %","PM Travel Days/Trip","Unit",null,"Select Project Type"]
["Choose One","Choose One","A","Bridgerland Technical College (BTECH)","Choose One","CMGC - Development","Select LEED Level",0,0,"TCC","TCC = Total Const Cost","Applied Technology","Applied Technology"]
["YES","YES","B","Capitol Preservation Board","Project","Design Bid Build - Development","LEED Certified – 0-2.5%",2.5000000000000001E-2,1,"EA","EA = Each","ASRS Warehouse","ASRS Warehouse"]
["NO","NO","C","County","Study","Design Build - Development","LEED Silver – 0-3.3%",3.3000000000000002E-2,2,"SF","SF = Square Feet","Campground","Campground"]
["Included","Partially","D","Courts",null,"MOU - Development","LEED Gold – 0.3-5.0%",0.05,3,"LF","LF = Lineal Feet","Campus Auxiliary Building","Campus Auxiliary Building"]
[null,null,"E","Davis Technical College (DATC)",null,"MOU - Improvement","LEED Platinum – 4.5-8.5%",8.5000000000000006E-2,4,"CF","CF = Cubic Feet","Classroom","Classroom"]
[null,null,null,"Department Of Agriculture And Food (UDAF)",null,null,null,null,5,"CY","CY = Cubic Yards","Complex Classroom","Complex Classroom"]
[null,null,null,"Department Of Alcoholic Beverage Services (DABS)",null,null,null,null,6,"Fx","Fx = Formula","Continuing Education / Community Services","Continuing Education / Community Services"]
[null,null,null,"Department of Cultural and Community Engagement (DCCE)",null,null,null,null,7,null,null,"Court Building","Court Building"]
[null,null,null,"Department Of Public Safety (DPS)",null,null,null,null,8,null,null,"Demolition","Demolition"]
[null,null,null,"Department Of Transportation (UDOT)",null,null,null,null,9,null,null,"DMV","DMV"]
[null,null,null,"Department Of Veterans Affairs (DVA)",null,null,null,null,10,null,null,"Electrical Upgrades","Electrical Upgrades"]
[null,null,null,"Department Of Workforce Services (DWS)",null,null,null,null,11,null,null,"Equestrian Event Center","Equestrian Event Center"]
[null,null,null,"DGO - Department of Facilities Construction and Maintenance (DFCM)",null,null,null,null,12,null,null,"Fairpark Facilities","Fairpark Facilities"]
[null,null,null,"DGO - Deptpartment Of Government Operations (DGO)",null,null,null,null,13,null,null,"Fire Dispatch","Fire Dispatch"]
[null,null,null,"DGO - Division of Fleet Operations",null,null,null,null,14,null,null,"Fisheries","Fisheries"]
[null,null,null,"DGO - Division of Human Resource Management (DHRM)",null,null,null,null,null,null,null,"Fitness","Fitness"]
[null,null,null,"DGO - Division of Purchasing and General Services - Surplus",null,null,null,null,null,null,null,"Ice Rink","Ice Rink"]
[null,null,null,"DGO - Divisions of Technology Services (DTS)",null,null,null,null,null,null,null,"Liquor Store","Liquor Store"]
[null,null,null,"DGO - Other",null,null,null,null,null,null,null,"Long Term Care / Nursing Home","Long Term Care / Nursing Home"]
[null,null,null,"DHHS - Department Of Health And Human Services (DHHS)",null,null,null,null,null,null,null,"Medical","Medical"]
[null,null,null,"DHHS - Division Of Juvenile Justice Services (DJJS)",null,null,null,null,null,null,null,"Mechanical Upgrades","Mechanical Upgrades"]
[null,null,null,"DHHS - Utah State Developmental Center (USDC",null,null,null,null,null,null,null,"Museum","Museum"]
[null,null,null,"DHHS - Utah State Hospital (USH)",null,null,null,null,null,null,null,"National Guard Armory","National Guard Armory"]
[null,null,null,"Dixie Technical College (DATC)",null,null,null,null,null,null,null,"National Guard Readiness Center","National Guard Readiness Center"]
[null,null,null,"DNR - Department Of Natural Resources",null,null,null,null,null,null,null,"Office","Office"]
[null,null,null,"DNR - Division of State Parks (DSP)",null,null,null,null,null,null,null,"Office Remodel","Office Remodel"]
[null,null,null,"DNR - Division Of Wildlife Resources (DWR)",null,null,null,null,null,null,null,"Parking Structure","Parking Structure"]
[null,null,null,"DOC - Adult Probation & Parole",null,null,null,null,null,null,null,"Paving","Paving"]
[null,null,null,"DOC - Central Utah Correctional Facility",null,null,null,null,null,null,null,"Performing Arts","Performing Arts"]
[null,null,null,"DOC - Department Of Corrections",null,null,null,null,null,null,null,"Public Safety Building","Public Safety Building"]
[null,null,null,"DOC - Utah State Prison",null,null,null,null,null,null,null,"Reroofing","Reroofing"]
[null,null,null,"Mountainlands Applied Technical College (MATC)",null,null,null,null,null,null,null,"Research Lab","Research Lab"]
[null,null,null,"National Guard",null,null,null,null,null,null,null,"Site","Site"]
[null,null,null,"Ogden/Weber Technical College (OTECH)",null,null,null,null,null,null,null,"Specialty School","Specialty School"]
[null,null,null,"Salt Lake Community College (SLCC)",null,null,null,null,null,null,null,"Stadium","Stadium"]
[null,null,null,"School For The Deaf And Blind (USDB)",null,null,null,null,null,null,null,"Student Commons","Student Commons"]
[null,null,null,"Snow College",null,null,null,null,null,null,null,"Student Housing","Student Housing"]
[null,null,null,"Southern Utah University (SUU)",null,null,null,null,null,null,null,"Student Life Health & Wellness","Student Life Health & Wellness"]
[null,null,null,"Southwest Technical College (STECH)",null,null,null,null,null,null,null,"UDOT Maintenance Facility","UDOT Maintenance Facility"]
[null,null,null,"State Archives",null,null,null,null,null,null,null,"UDOT Salt Shed","UDOT Salt Shed"]
[null,null,null,"State Fairpark",null,null,null,null,null,null,null,"Other – Please Describe in \"Additional Project Info:\"","Other – Please Describe in \"Additional Project Info:\""]
[null,null,null,"State Tax Commission"]
[null,null,null,"Tooele Technical College (TATC)"]
[null,null,null,"Uintah Basin Technical College (UBTECH)"]
[null,null,null,"United States District Court - District Of Utah"]
[null,null,null,"University Of Utah (UofU)"]
[null,null,null,"Utah Board Of Education"]
[null,null,null,"Utah College Of Applied Technology (UCAT)"]
[null,null,null,"Utah State University (USU)"]
[null,null,null,"Utah Tech University (UTU)"]
[null,null,null,"Utah Valley University (UVU)"]
[null,null,null,"Weber State University (WSU)"]
[null,null,null,"Other *Please Specify"]