ࡱ> p  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoqrstuvwxyz{|}~Root Entry F iI;QWorkbook!_VBA_PROJECT_CUR"9I; iI;VBACI;P8I;  ɀ`\pMohamed Ali Noun Ba=  ThisWorkbook=>C&8c@"15Arial15Arial15Arial15Arial15Arial1 5Arial15Arial1.5Times New Roman1.5Times New Roman1.5Times New Roman1.5Times New Roman1.5Times New Roman1.5Times New Roman1.5Times New Roman1.5Times New Roman15Arial1.5Times New Roman1. 5Times New Roman1. 5Times New Roman1. 5Times New Roman1.5Times New Roman1. 5Times New Roman1. 5Times New Roman1.5Times New Roman1.5Times New Roman1.5Times New Roman1.5Times New Roman1.5Times New Roman1.!5Times New Roman1. 5Times New Roman1.5Times New Roman15Tahoma1h85Cambria1,85Calibri185Calibri185Calibri15Calibri15Calibri1<5Calibri1>5Calibri1?5Calibri145Calibri145Calibri1 5Calibri1 5Calibri15Arial15Calibri15Calibri1 5Calibri15Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) "$"#,##0.00$[$-409]dddd\,\ mmmm\ dd\,\ yyyy m/d/yy;@                2  2  2  2  2  2  2  2  2  2  2  2  1  1  1  1  1  1  1  1  1  1  1  1  &  *   , ff + ) , * /  %  " P # P $  $  (   + ` '  .    )   ! 0 a> -  @   H  H  X   X   x X  H  !X !P  `  @  H   X   H    "X  #x  x  !x x x x X x  X   (@ @ (!@ @  @  (!@    @  (! @  *@  *@ @   " 1# ("@ @  ("@ @  (!"@ @   ( *@  )@  *@ @  @ @   )  *  (  @@   @    @     ,      +@ @  )@@  + )   @ (@  @ @ (@ @  )x  @ @   +( """@ @ "@ "@ @ " *""@ @ (!@ @ (!!@ @  +!@ @   #x@  #x  x@@  x@@  x@ x@  x@   !@ @ "!@ @ (!@ @ "@ "@ @  @ @  !@ @   @   @    @ @   @  !@   @    @   @ @   @ @   @   , @   , @ @   ,   ,"   , @  !@  @  @   L  #X , @   @ -   - ,"@+ ,  @+ ,  @ + ,"@ +  )x @   )x@    x x@   !x@   !x @  x@@ x@ !x@  !x @  x  x@   x @    x@    x @  x@@  "X !@ ! @ !@ @   "X "X " " "@@ "@ " @ X @@ @  @ @    @      !x@ @   "X "X "@@   @   @ "x@ @   "@ @   "X 1#@@ 1#@ ( (  ( (  (@ ( @ ! @  !  !   @ @  @    @  # (@ ( *"@@  *"@  *" @  (@@ (@ " "  " ! *@@  * @   )  !@ "  @@    @  1# # "   !"@@ !"@ ! " @ +"@@ (0 " @ !@@   ! @  @@    @  )@@ ) @ )@@ )@ ) @ +@@ +@ +  @ + @ + + )@@ )  @ ) @ ) #"@@ # " @ !"@@ !"@ ! " @ !"@@ !"@ ! " @ )!@@ )!@ )! @ *@   )@  @@  @   @    @-    @-  -   - @@ -   @ - @@ ,   @ ,  @@-  @- "@@  "@  " @  !@  !  "@  "  ,"@  ,"   "   "  "@@  "@   #@@   #@   #  @   @,    @,  @@,  @,  @ @   * @   * @   *! @   *@@  *@  * @  *@  *  *   * @   *   *   ,(@ @   ,(!@ @   (@ @   (!@ @  !@@ !@ #@ !@@ -  ! @ -  @@  @    @   @         @ ,   ,   ,    , !@@ ,  ! @ ,  @@ ,    @ , ("@ "@@ - "  @ -  "@@ -  "  @ -  ,*@@  ,*  @  ,* @   ,*   *@@   *@   *  @   *@@  !@@  ! @   "   " @  "@ *@ @ *@  * @  *@@ *@ *  @ *!@@ *!@ * ! @ *"@@ *"@ * " @ *@@ *@ *  @  20% - Accent1 20% - Accent2 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 60% - Accent3 60% - Accent4 60% - Accent5! 60% - Accent6 "Accent1 #Accent2 $Accent3 %Accent4 &Accent5 'Accent6(Bad) Calculation* Check Cell+,-./Explanatory Text0  1Good2 Heading 13 Heading 24 Heading 35 Heading 46 7Input8 Linked Cell 9Neutral :Note ;Output< =Title >Total? Warning Text`dmNotes and Instructionsь Cover Page Contacts ListUtility InventoryUtility Data OriginsConflict Matrix\J Cost EstimatetAdditional Comments&!  ; !  ;   ;  ;  ;  ;"jb(3 A@@   ORGANIZATIONCONTACT CONTACT INFORMATIONsmithb@azdot.gov EXHIBIT AUtility and Agency Contact ListFACILITY OWNERU-00.00PLAN SHEET NO. DescriptionConstruction CostUnitEstimated Quantity Unit PriceLFEAConstruction Cost Total:Utility Relocation Cost Total: EXHIBIT CUtility Conflict Matrix EXHIBIT BExisting Utilities Inventory EXHIBIT D Cost EstimateNEED ROW (Y/N)PRIOR RIGHTS (Y/N)5BETTERMENTS REQUESTED TO BE INCLUDED IN STATE PROJECTADOT Contractor to RelocateUtility to RelocateCurrently in Mitigation$*M/R indicates Mitigation/Relocation*M / R**REMARKS / FINAL DISPOSITION REASON FOR CONFLICT Contact NamePrimaryFax(602) 712-1111(602) 712-0000 Company / AgencyType, Size SpecificationsDescription OR "No Conflict"M or R Bid Item No.MAINLINEUTILITY REPORTDateFederal Aid Project No. $Arizona Department of TransportationPhoenix, AZ 85007 Submitted To: Prepared By:Protect in Place Bid Item 1 COST SUMMARYComments from facility ownerRelocate OR Protect in Place Agreement No. 0000-00-XXXXGeneral Notes and Instructionsa)b)c)%Select a Row containing a blank entryTo add an entry:?To remove an entry, delete the entire Row containing that entry Copy that row*Insert the Row copy after the selected RowSR 000 / 00+00 to 00+00 Rt/Lt Street Name(602) 712-2222CellPage ReferenceOriginal EntryAdditional CommentsColumnRow Cover PageCPhoenix, AZ 85007 Contacts ListUtility InventoryConflict MatrixE6Enter new information regarding "Original Entry" here.D Entry No. - Project Name:  / NY, N or leave blankProject Vicinity Map, including Project Limits, Township and Range, North Arrow, TRACS No., and Project Name all per ADOT Drafting Guideline II, III or IV Yes or No*SUE QUALITY LEVEL* If Potholing is required, mark the entry with "PH." For example, a facility designated at SUE Quality Level "D" that requires potholing will be marked "D - PH"Utility Data OriginsVIf information is unavailable for any entry at any given Stage, leave that entry blankProject Vicinity MapMAILING ADDRESS!OBSERVED ROADWAY/ PROJECT STATION'OBSERVED ROADWAY/ PROJECT STATION RANGE(OBSERVED ROADWAY/ CONFLICT STATION RANGE,OBSERVED ROADWAY/ PRIOR RIGHTS STATION RANGE.For more information regarding what should be included in this report, refer to the Utility Report Guidelines, Stage Submittal Checklist, Utility Coordination Guide, and Dictionary of Standardized Work Tasks (available through the ADOT website at ).FACILITY TYPE / SIZECONFLICT PLAN SHEET NO.ORGANIZATION NAMEH** Under REMARKS / FINAL DISPOSITION, include comments regarding facilities that are to be Protected in Place, who does design and/or relocation work, who pays for design and/or relocation work, if work must be done during the Construction Phase, and any other comments that may clarify details about the corresponding conflict.Vertical Location PerformedLocating AgencyDate of Location`To Print the entire workbook, go to the Print menu. Under "Print What," select "Entire Workbook"PQ Tips for the Use of TemplateEnter information under "Additional Comments" on the "Utility Data Origins & Comments" sheet to add any necessary details for a given entry. Enter "See Additional Comment No. #" in the pertinent entry. WItems marked in BOLD, BLACK TEXT will stay as written for all Utility Report submittals! Items marked in UNDERLINED, BLACK TEXT will update automatically as other portions of the report are updated by the user. ENSURE THAT THESE PORTIONS ARE ACCURATE UPON UTILITY REPORT SUBMITTAL.& PItems marked in RED TEXT will require update by the user as the project develops 1.A)1.B)1.C)1.D)1.E)2.A)2.B)2.C)2.D)1.F)Designation performed in accordance with CI/ASCE Standard 38-02 publication "Standard Guideline for the Collection and Depiction of Existing Subsurface Utility Data?""Street Name, Room/Suite, Mail DropCityStateZip CodeSee additional commentsSUE QUALITY LEVELIMost accurate source(s) of information documenting location of facilities"RELOCATION PLANS APPROVED BY ADOT?As noted in the Utility Report Guidelines, attach the following as appendices to the end of this report: Comments & Correspondence, Meeting Minutes, Pothole Request & Completed Pothole Data and Utility Removal and Relocation Plan Sheets1.G)<Macros have been added to this template to simplify its use.$PROTECT IN PLACE OR RELOCATE d)205 S. 17th Ave. MD 618ECommentsA, B, C, D or PHe) Utility and Railroad EngineeringSR 000 Freeway Name MP 00.00 to MP 00.00STAGE _ (000%) Plans XX-XXX-0(000)X"Consultant Firm Name or "In-House"!Street Address (Omit if In-House)'City, State Zip Code (Omit if In-House)'Utility Data Search conducted at Stage:Contact Development Reference:ITo add a row in the Utility Inventory, press Ctrl+Shift+A from any sheet.-9 To add a row in the Utility Data Origins, press Ctrl+Shift+B from any sheet. This row will not be linked to take any information from any other sheet in this workbook.0< To add a row in the Conflict Matrix, press Ctrl+Shift+C from any sheet. This row will not be linked to take any information from any other sheet in this workbook.+7 To add a new row in the Utilty Inventory, Utility Data Origins and Conflict Matrix sheets, and link all three rows together, go to any sheet and press Ctrl+Shift+D. `To add a new company to the Cost Estimate, go to the Cost Estimate sheet and press Ctrl+Shift+E.S_ U-00.02TRACS No. 0000 XX 000 X0000 00X  # New CompanyEngineering and Administration: Designer Name2.E)lAnywhere that a * symbol is present, there will be a note specific to that item at the bottom of that sheet. ADOT Estimated Cost (Payable) ADOT Estimated Cost (Receivable)Payable Receivable(Overall Utility Cost to be Paid by ADOT:Payable or Recievable?Bid Item Description ADOT U&RR Contingency (Payable ONLY):NA(Receivable ONLY):8 889|:;;B<I<=>#>?MAT mDt oGvGHJIKP#M*[ObpPwcc||2}-}= yyyy_)}A}2 yyyy_)[$ -}A}3 yyyy_)?[$ -}A}4 yyyy_)23[$ -}-}5 yyyy_)}A}1 ayyyy_)[$ -}A}( yyyy_)[$ -}A}9 eyyyy_)[$ -}}7 ??vyyyy_)̙[$ -##0.  }}; ???yyyy_)[$ -???##0.??? ??? ???}}) }yyyy_)[$ -##0.  }A}8 }yyyy_)[$ -}}* yyyy_)[$ -???##0.??? ??? ???}-}? yyyy_)}x}:yyyy_)[$???## ??? ???}-}/ yyyy_)}U}> yyyy_)[$## }A}" yyyy_)[$}A} yyyy_)ef[$}A} yyyy_)L[$}A} yyyy_)23[$}A}# yyyy_)[$}A} yyyy_)ef[$}A} yyyy_)L[$}A} yyyy_)23[$}A}$ yyyy_)[$}A} yyyy_)ef[$}A} yyyy_)L[$}A} yyyy_)23[$}A}% yyyy_)[$}A} yyyy_)ef[$}A} yyyy_)L[$}A} yyyy_)23[$}A}& yyyy_)[$}A} yyyy_)ef[$}A} yyyy_)L[$}A}  yyyy_)23[$}A}' yyyy_) [$}A} yyyy_)ef [$}A} yyyy_)L [$}A}! yyyy_)23 [$M 20% - Accent1 ef %M" 20% - Accent2 ef %M& 20% - Accent3 ef %M* 20% - Accent4 ef %M. 20% - Accent5 ef %M2 20% - Accent6  ef %M 40% - Accent1 L %M# 40% - Accent2 L渷 %M' 40% - Accent3 L %M+ 40% - Accent4 L %M/ 40% - Accent5 L %M3 40% - Accent6  Lմ %M 60% - Accent1 23 %M$ 60% - Accent2 23ږ %M( 60% - Accent3 23כ %M, 60% - Accent4 23 %M0 60% - Accent5 23 %M4 60% - Accent6  23 %AAccent1 O %A!Accent2 PM %A%Accent3 Y %A)Accent4 d %A-Accent5 K %A1Accent6  F %9Bad  % Calculation  }%  Check Cell  %????????? ??? Comma( Comma [0]&Currency. Currency [0]G5Explanatory Text %: Followed Hyperlink;Good  a%G Heading 1 I}%OG Heading 2 I}%?G Heading 3 I}%239 Heading 4 I}%( HyperlinkuInput ̙ ??v% K Linked Cell }%ANeutral  e%"Normalb Note  wOutput  ???%????????? ???$Percent1Title I}%MTotal %OO? Warning Text %XTableStyleMedium2PivotStyleLight16B  ɀ 14~Z.  dMbP?_*+%M\\e980prte\ENG316 - TOSHIBA e-  odXX0CourierArial 0X oCOPIES@PJL JOB NAME="!JOBNAME" @PJL SET GUISTARTJOB=1 @PJL EOJ eeee hxTOSHIBA e-STUDIO4520CSeriesPCL6MckinleyX?ʡE??ʡE?XX X 18050,E2111111111111111111111C,1003,D211,2124,E0,C"dXX??cU} Z} mO}  $ O} O} $ O1     @                      @     @  r VTTTTTTTTTT w t x u   y v z @  < ?  Q= B   > C  { A  q     <   Q=  Q  Q>  Q  Q  S    US ; WPPPPPPPPP | i } b ~     s   Dl, 88 88@@@888@@ @ @ @ ,&888 8 @! " # $ % & ' ( ) * + , - . / 0  X !RRRRRRRRRRR "RRRRRRRRRRR #RRRRRRRRRRR $RRRRRRRRRRR %RRRRRRRRRRR &YAAAAAAAAAA 'YAAAAAAAAAA (YAAAAAAAAAA )YAAAAAAAAAA *YAAAAAAAAAA +YAAAAAAAAAA ,YAAAAAAAAAA -YAAAAAAAAAA .YAAAAAAAAAA /YAAAAAAAAAA 0YAAAAAAAA 0 ~ 0 !@&@ >@$                         7 Sheet1ggD&B  ɀ 0]  dMbP?_*+%M\\e980prte\ENG316 - TOSHIBA e-  odXX0CourierArial 0X oCOPIES@PJL JOB NAME="!JOBNAME" @PJL SET GUISTARTJOB=1 @PJL EOJ eeee hxTOSHIBA e-STUDIO4520CSeriesPCL6MckinleyX?ʡE??ʡE?XX X 18050,E2111111111111111111111C,1003,D211,2124,E0,C"dXX??cU} N} N} N} K} K} K} $ K0   X  ; ; ; ; ; D   W  ( BD -BD BD BD  BCAAAAAA /  " @@@@@@D  .B D DDDDDDDDD@@@@@@@@@@@@@@@@@@@@@@ DE \>@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@DDE@@D4 lH~THTHTHTHtHTH^HHHHHHHHHHHHHHHH !"#$;L%;L&';(;);*;+,-./D DE@@D!DF@@D"DD@@ #DD #c>#@@D$CCCCCCCBCGGGGGGGGGGGGGGGGGGGGGG %CC %2"%GG %3 %D&DAHHHHHHHIIIII@@@@@@@@@@@@@@@JJ 'DA '0"'@@ ' ' (DA ("(@@ ( ( )DA )")@@ ) ) *DA *1"*@@ * *+M+MMMMMMM,MMMMMMMMM-MMMMMMMMM.MMMMMMMMM/MMMMMMMMM$,HHH^HtHtttt"PH 0(   >@((($      **##"%%%%''(())**'' ))((  7 Sheet2ggD&  ɀ 2V  dMbP?_*+%M\\e980prte\ENG316 - TOSHIBA e-  odXX0CourierArial 0X oCOPIES@PJL JOB NAME="!JOBNAME" @PJL SET GUISTARTJOB=1 @PJL EOJ eeee hxTOSHIBA e-STUDIO4520CSeriesPCL6MckinleyX?ʡE??ʡE?XX X 18050,E2111111111111111111111C,1003,D211,2124,E0,C"dXX??cU} mi} i} m i} i} i} i} $ c2 @    @    @ @ @ @ @  !r  ["TRACS No. 0000 XX 000 X0000 00X Xe\r 8sZ SR 000 dYlr Z MP 00.00 to MP 00.00  f g   hd l [" & # \ ] % $ ^ ] F G ^ _   ` l [" &  #  \ ] %  $  ^ ] F  G  ^ _   ` l [" & # \ ] % $ ^ ] F G ^ _   ` l [" & # \ ] % $ ^ ] F G ^ _   ` l [" & # \ ] % $ ^ ] F G ^ _   ` l [" & # \ ] % $ ^ ] F G ^ _   ` l [" & # \ ] % $ ^D l$$aHZLL:ZLL:ZLL:ZLL:ZLL:ZLL:Z ! "@#$% &@'() *@+,- .@/01 ] F  G  ^ !_ ! ! !` "l "[" "&" "#" "\ #] #%# #$# #^ $] $F$ $G$ $^ %_ % % %` &l &[" &&& &#& &\ '] '%' '$' '^ (] (F( (G( (^ )_ ) ) )` *l *[" *&* *#* *\ +] +%+ +$+ +^ ,] ,F, ,G, ,^ -_ - - -` .l .[" .&. .#. .\ /] /%/ /$/ /^ 0] 0F0 0G0 0^ 1_ 1 1 1`(TL:ZLL:ZLL:ZLL:ZLL  >@A @ $ _    //''((**      00//++,,..$$!!""##$$""##..!&&%% 11&&--00++,,"%&)*-.1''((**))7 Sheet3ggN&  ɀ p  dMbP?_*+%M\\e980prte\ENG316 - TOSHIBA e-  odXXp950CourierArial 0X oCOPIES@PJL JOB NAME="!JOBNAME" @PJL SET GUISTARTJOB=1 @PJL EOJ eeee hxTOSHIBA e-STUDIO4520CSeriesPCL6MckinleyX?ʡE??ʡE?XX X 18050,E2111111111111111111111C,1003,D211,2124,E0,C"dXX??cU} c} m c}  c} $ c}  c} Ic} Ic} $c} c} Ic} c} mc} c} $ ctt         G       @     ! r  ["TRACS No. 0000 XX 000 X0000 00X              X      r sZ SR 000  dY r Z MP 00.00 to MP 00.00     j  e  !             b b( b' bD ) * [   b[  b[  b b b( b' bD ) * [   b[  b[  b4 b b( b' bD ) * [   b[  b[  b b b( b' bD )  *  [  b[ b[ b b b( b' bD )  *  [  b[ b[ b   m    "v00m$00$    (  R  C ]F! p d ZR  C ]F! p d ZR  C ]F!L p d ZR  C ]F! p d ZR  C ]F!L p d ZR  C ]F! p d ZR  C  ]F!Lp d ZR  C   ]F!p d ZR   C   ]F !Lp d ZR   C   ]F !p d >@<dA @$                  7 Sheet4gg^&  ɀ    dMbP?_*+%M\\e980prte\ENG316 - TOSHIBA e-  odXX0CourierArial 0X oCOPIES@PJL JOB NAME="!JOBNAME" @PJL SET GUISTARTJOB=1 @PJL EOJ eeee hxTOSHIBA e-STUDIO4520CSeriesPCL6MckinleyX?ʡE??ʡE?XX X 18050,E2111111111111111111111C,1003,D211,2124,E0,C"dXX??U} I y} y} y} Iy} $y}  y}  y} m y} $y} $ y     X@  F@ F@ F@ F@  F@        @     a   ]zz |r ZCompany / Agencya8r Z SR 000 / 00+00 to 00+00 Rt/Lt   {   zz |tr ZCompany / Agencyar Z SR 000 / 00+00 to 00+00 Rt/Lt   {   zz |r ZCompany / Agencyar Z SR 000 / 00+00 to 00+00 Rt/Lt   {   zz |4r Z Company / AgencyaXr Z  SR 000 / 00+00 to 00+00 Rt/Lt 1 23    zz |r Z Company / Agencyar Z  SR 000 / 00+00 to 00+00 Rt/Lt 1 23    zz )n* ^zz )o * .r sZ'%"Consultant Firm Name or "In-House" //////0zz )p * +. ,,,,,,-}}        ! %^ &zz  "######$'(zz  ~~~~~~~~zz ~~~~~~~~zz "*BB~BD""0 ~ ~ z  S>@$           7 Sheet7gg&  ɀ 9(:@  dMbP?_*+%M\\e980prte\ENG316 - TOSHIBA e-  odXX0CourierArial 0X oCOPIES@PJL JOB NAME="!JOBNAME" @PJL SET GUISTARTJOB=1 @PJL EOJ eeee hxTOSHIBA e-STUDIO4520CSeriesPCL6MckinleyX?ʡE??ʡE?XX X 18050,E2111111111111111111111C,1003,D211,2124,E0,C"dXX??cU} o} $ q} m q} m q} Ii} i} Ii} $i} i} i} m i} i} i} Iq} $ ctt 9jjjj j j j j jjjjjjjjjjjjjjjjjjj     ! <r  ["TRACS No. 0000 XX 000 X0000 00X                X      |r  Z SR 000  dY r sZ MP 00.00 to MP 00.00  "99999999999999 k j  f _  g  6h 78  !    amr ZType, Size Specificationsm,r ZCompany / Agencymar Z SR 000 / 00+00 to 00+00 Rt/Ltk0Lr Z A, B, C, D or PH D D 4  mpr  ZDescription OR "No Conflict"  a8  n[ lr  Z Currently in Mitigation amr ZType, Size Specificationsm, r ZCompany / Agencyma4 r Z SR 000 / 00+00 to 00+00 Rt/Ltk0p r Z A, B, C, D or PH D D 4  m r  ZDescription OR "No Conflict"  a8  n[ l r  Z Protect in Place am r ZType, Size Specificationsm,( r ZCompany / AgencymaL r Z SR 000 / 00+00 to 00+00 Rt/Ltk0 r Z A, B, C, D or PH D D 4  m r ZDescription OR "No Conflict"  a8  n[ l r Z ADOT Contractor to Relocate a m r Z Type, Size Specifications m,T r Z Company / Agency max r Z  SR 000 / 00+00 to 00+00 Rt/Lt k0 r Z A, B, C, D or PH D  D 4  m r Z Description OR "No Conflict" a8 n[ l r  Z Utility to Relocate a m< r  Z Type, Size Specifications m,p r Z Company / Agency ma r Z  SR 000 / 00+00 to 00+00 Rt/Lt k0 r Z A, B, C, D or PH D  D 4  m r Z Description OR "No Conflict" a8 n[ l0 r Z Currently in Mitigation 5` 5555555555555 m  "  " "oppppppppppppq "oppppppppppppq "oppppppppppppq "oppppppppppppq "oppppppppppppq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq "oqqqqqqqqqqqqq Dl22o&22&& &&&&&&&&&&&&&& j!j"j#j$j%j&j'j(j)j*j+j,j-j.j/j0j1j2j3j4j5j6j7j8j" oqqqqqqqqqqqqq "!oqqqqqqqqqqqqq ""oqqqqqqqqqqqqq "#oqqqqqqqqqqqqq "$oqqqqqqqqqqqqq "%oqqqqqqqqqqqqq "&oqqqqqqqqqqqqq "'oqqqqqqqqqqqqq "(oqqqqqqqqqqqqq ")oqqqqqqqqqqqqq "*oqqqqqqqqqqqqq "+oqqqqqqqqqqqqq ",oqqqqqqqqqqqqq "-oqqqqqqqqqqqqq ".oqqqqqqqqqqqqq "/oqqqqqqqqqqqqq "0oqqqqqqqqqqqqq "1oqqqqqqqqqqqqq "2oqqqqqqqqqqqqq "3oqqqqqqqqqqqqq "4oqqqqqqqqqqqqq "5oqqqqqqqqqqqqq "6oqqqqqqqqqqqqq "7oqqqqqqqqqqqqq "8oqqqqqqqqqqqqq 6&&&&&&&&&&&&&&&&&&&&&&&&T q q q  S  e    &0 (  R  C ]F!p d ZR  C ]F!p d ZR  C ]F!pp d ZR  C ]F!p d ZR  C ]F!pp d ZR  C ]F!p d ZR  C  ]F!pp d ZR  C   ]F!p d ZR   C   ]F !pp d ZR   C   ]F !p d ZR   C  ]F !pp d >@A @$               7 Sheet5gg^&  ɀ  [p  dMbP?_*+%M\\E980PRTE\ENG316 - TOSHIBA e-  odXX0CourierArial 0X oCOPIES@PJL JOB NAME="!JOBNAME" @PJL SET GUISTARTJOB=1 @PJL EOJ eeee hxTOSHIBA e-STUDIO4520CSeriesPCL6Mckinleyrc001X?ʡE??ʡE?XX X 18050,E2111111111111111111111C,1003,D211,2124,E0, E"dXX??U} i}  c} c} m c} c} c} Ic} c}  w} mw} Ic} m} I} $ c        @ @                   @      @      ! ` r  ["TRACS No. 0000 XX 000 X0000 00X              X   e r Z SR 000 dY r  Z MP 00.00 to MP 00.00x  9 Y+ \ ]]^XX    Z_``a g g e       [bccdhhf rs i,jjjttt :  O PPPuvvMMMN  D EEF  P K :D  Receivable  @D D @B LM K 7D Payable  @D D @B L  D EEF  P K :D  Receivable  @D D @B LM K 7D Payable  @D D @B L  D EEF  P K :D  Receivable  @D D @B LM K 7D Payable  @D D @B L  D EEF  P K :D  Receivable  @D D @B LM K 7D Payable  @D D @B L   D EEF  P K :D Receivable  @DD@B LM K 7DPayable  @DD@B Ltt # %   #  %   G:H IJJJuvvMMMN   D EEF .@$@P Kb@ :D Receivable  @DD@B LM K 7DPayable  @DD@B L   D EEF &@$@P K :D Receivable  @DD@B LM K[@ 7DPayable  @DD@B L  D EEF $@$@P KY@ :D Receivable  @DD@B LM KY@ 7DPayable  @DD@B L   D EEF  P K :D Receivable  @DD@B LM K 7DPayable  @DD@B L   D EEF  P K :D Receivable  @DD@B LM K7DPayable  @DD@B Ltt # @o@ %  # @j@ %  6     z { QRRRRRRRS# }@o@ % @ @ ~# @@j@ % @ @ A~ B$@CCCC : ::;! >9@ D D ?  @ A <<<=>?@A ~ V.@WWWW T TTU  > ?! @?@ D D A tuuuu vvvw>?@A nooooooop$ >0q@ $ $ B ?$ @0n@ $ $ B A qrrrrrrrslmxy kkkkkkkkk! |@@s D D   ||| Dl00m$^p$:DvDvX$F$0 | s   @>@A @$ jM                                        7 Sheet6ggN&  ɀ  AՉ  dMbP?_*+%M\\e980prte\ENG316 - TOSHIBA e-  odXX0CourierArial 0X oCOPIES@PJL JOB NAME="!JOBNAME" @PJL SET GUISTARTJOB=1 @PJL EOJ eeee hxTOSHIBA e-STUDIO4520CSeriesPCL6MckinleyX?ʡE??ʡE?XX X 18050,E2111111111111111111111C,1003,D211,2124,E0,C"dXX??U} I}  } $ } } I  y y         y y y y y J V H K L I  ~ ? M N~ E@ O T ~ @ P S~ @ E T ~ @ Q U~  @ D T ~ @ R Z~ @ 7 T ~ @  N~ &@ 5 T     ,(dddddd>@b     7 Sheet8gg_^& Module1 R4ThisWorkbook__SRP_20__SRP_3B  !"#$%&'()+,-./0123456789;<=>?@ABCDEFGHIKLMNOPQRSTUVWXY[\]^_`abcdefghiklmnopqrstuvwxy{|}~ing "Ctrl" and pressing "a" Keyboard Shortcut: Ctrl+Shift+AUtility Inventory$B@H7:7$B@H B@ $" B@ A7$&B@H ((*U-00.00 ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqB7$&B@HType, Size Specifications ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqC7$&B@HCompany / Agency ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9Jq(D7$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9BO(DGxME @kAdds one (1) row to the TOP of the Utility Inventory sheet. This may also be done by pressing Ctrl+Shift+AA 14 LhjAdds one (1) row to the TOP of the Conflict Matrix sheet. This may also be done by pressing Ctrl+Shift+b.HC 14xpMRJ"  ( |8  & " 0@X p" (0&H"p "@h*" H`px(" 8HPX`hpx" (08@HPX p" ( @"` "0Xp" 0 @ H P X ` h p x    "  0 z h &p         ( "@ h            & " @ X h p x         "  ( 8 @ H P X ` h p x  * "   (08@HPX`x" (0*H"x*("X("0Xp("0HX`hpx "(08@HPX`hp" (0H`p    " A_Utility_Inventory_ADD_ROW Macrov Adds one (1) row to the TOP of the Utility Inventory sheet. This may also be done by hold9D H9F9JqHE7:F7$&B@HDescription OR "No Conflict" ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqpG7:H7$&B@HM or R ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqI7:J7$&B@HY, N or leave blank ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqK7$&B@HY, N or leave blank ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqL7$&B@HxY, N or leave blank ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9Jq8M7$&B@H- ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqxA8$&B@HoX) C_Conflict_Matrix_ADD_ROW_no_links Macrot Adds one (1) row to the TOP of the Conflict Matrix sheet. This may also be done by holding "Ctrl" and pressing "b" Keyboard Shortcut: Ctrl+Shift+CConflict Matrix$B@H7:7$B@H B@ $" B@ A7$&B@H ((*U-00.00 ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9Jq(B7$&B@HType, Size Specifications ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F P9JqPC7$&B@HCompany / Agency ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F P9JqD7$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F P9JqE7$&B@HA, B, C, D, PH ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqF7:G7$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqH7:J7$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqK7$&B@HDescription OR "No Conflict" ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F P9Jq8L7$&B@HRelocate OR Protect in Place ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9Jq` M7$&B@HY, N or leave blank ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9Jq N7$&B@H- ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F9Jq A7:N7$&B@HN7$&B@R !6(J H !6(FF8:G8$&B@H T(V T(V T(V T(Vo  Attribute VB_Name = "Module1" Sub A_Utility_Inventory_ADD_ROW(), P.DescriptionAdds one (1) row to the TOP of  w w sheet. This may also be dIby pressing Ctrl+Shift+A&ProcDa taX;oke_FuncX\n1B4%' ' `Macroqh(oldq"q" Hand{"aPKeyboard ShortcutF:O STs("[").@Select Row@ 7:7u.Copy Insert b:=xlDownange("AApplica.CutF{eActiveCell.FormulaR1C1iU-00.00@A7With  Characters(Start:=1, Length:=7)n;A.Times New RomanFontStylReg"rhSiz8- Skethrough,5up(RbOut0line$Qhad= UnderxlNkhColorIx`3EPk-R:B:V6T ype, %Specif?s(8825888.88(18888 sC8oCompany / Ag0ency7/p167777_pAٟ7GsC{_p= _p_pAD77SR 000q00+pxRt/LtWTi8~9ԅTTa9T= TT4.SsJSuTo8g.TUT sTT`8E7:F/p#pOR ""No Conf`ut""q28qq#sqOUlsZpt9.or1G7:HM or R__]T/8/8¥sOOyO O /8 OO O@I7:JOOCY, Nqleave blank1_T///////io@_T777///p/`$K/_p_p?_p_p5_pT .Subscript = False .OutlineFontShadowlUnderp6xlSty leNon CoPlorI/x+3zEnd With Range("L7").SelectActiveCell.FormulaR1C1E"Y, N or leave blank"3U 8Characters(Start:=1, Lengthi9),n7Name0Times New Roman.t(RegKrSiz!8HStrikethroughSupPוoMo-Kkks?k?k ?k?nre:A8mqL  C_Conflict_MaVx_ADD_R@OW_no_@~ks() At@butes.VB_DeCionAfAdds (1) r@to the TOPX ofB  sheet. This may o be dby pressing Ctrl+Shift+}.}_}Vr._WSBlYxlAutq tic9C_SCompany / Agency.6QP}8/@/{)Iq("DS R 000p00+pzRt/Lt__]2@9999@s1__ __ 99LE__SA, B, C, D, PHoo949999oooo9_Vj=9oh~N"J4F7:G?9?9With ActiveCell.Characters(Start:=1, Length:=29).F@ont .Name = "Times New Roman"CDbStylNR@egular >Siz82Strikethrough^False upcriptbsOut0line9hadow Undefr xlkNonMColor*Ix3ZEn@d WithRange("H7:J7").SelecForBmR1C1$"SR 000 /%+toRt/Lt1?sz/?sL?ssKgrDeCion OR ""No Conflict""r8r .rrsvrrrSingl6sxlAut@hticxtL:tRelocatea:Prot`z in Place:::S:o:M99Y, N or leave blank7717777r}.YrOcUsr .r v rN6r-1TBR@.Tup^.T1S A7:rrR#pҥO! ,_ /&F8:GF8 Win.@Scroll(umn2S /!t/__Q.Sub <jxDM#<h@C|eKvFmb@Bi?a%xmb@Bi?a%h@C|eKvME(SLSS6"N0{00020819-0000-0000-C000-000000000046}(%H` %X %`h8@TT0MR$*\Rffff*0D531ad4a54xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2rU pAi#4a`rU @nD#xME (Sheet1Sheet2 *Sheet3:Sheet4 JSLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2D#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2DȨ#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2D##xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2D¨#xME (Sheet5ZSheet6 jSheet7zModule2SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2D#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2D#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et7" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2$+DƗxMExpMRx"Attribute VB_Name = "Module2" $+DmxModule3Module4jSheet8Module5MExpMRx"Attribute VB_Name = "Module3" 4:B4$&B@H+S  r9p v9t9x9z9|9~9 99q4:4$B@H $" B@ A6:J6$&B@H B@ T(V T(VA4$&B@H B@A4:B4$&B@H ((*  v9p v9t9x9z9|9~9 99q5:5$B@HC5$&B@R4:4$!B@C4:J4$&B@H !6(J H !6(FI4$&B@H !6(JJ4$&B@H T(V T(VC4$&B@HCompany / Agency ,(.24 ,%0!6Times New Roman9Regular98 9:9<9>9@9B9D H9F9JqD4:E4$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular98 9:9<9>9@9B9D      !"#$%&'()*+,-./01234678:?;<=>tASCDEFGHIJKLMNOPQR@TUVWXYZ[\]^_`abcdefghijklmoqrs}vwxyz{|n~ H9F9JqF4:H4$&B@HIMost accurate source(s) of information documenting location of facilities ,(.2I4 ,%0!6Times New Roman9Regular98 9:9<9>9@9B9D H9F9JqJ4$&B@HA, B, C, D or PH ,(.24 ,%0!6Times New Roman9Regular98 9:9<9>9@9B9D H9F9Jq8J5$&B@H TB@A4:B5$&B@HA5$&B@R  r9p v9t9x9z9|9~9 9q  r9p v9t9x9z9|9~9 9q8  9p v9t9x9z9|9~9 9q   %(   %(  % 9 9 P9Jq  % 9 9 P9JqH  %;PDy2xME n@fAdds one (1) row to the top of the Utility Data Origins sheet, which is NOT linked to any other sheet.ift+AB 14 Adds one (1) row to the Utility Inventory, Utility Data Origins and Conflict Matrix sheets, and links all three new entries together.D 14XMR"  $ ,8 h &p $ (08Ph      (08@HPXp  (8P"p* "Px^"`"0Xp(08@HPX`hpx0H`hpx    ( @ X ` h p x    "  (  &  "     8  P ` "x             &( "P x             " H ` p x         * "(@PX`hpx("(08@HPX`hp" (08 P"p "@h "8P`hpx" (08@HPX`h$0H ` p    (08Ph  0"Px*"0Xp^"@h"8P`hpx (08@HPX`hpx(@HPX`x 8@HPXp&& *8"h ( 8X p "(08@HPX`hp&"     ( 0 8 @ H ` "         !!!!*0!"`!!!!!!!!!!!!!""0"X"p"""""""""""*""#8#P#`#h#p#x#######*#"#$0$@$H$P$X$`$h$p$x$$$($"$$%% %(%0%8%@%H%P%X%`%(x%"%%%%%&&&& &(&0&8& P&"p&&&&&&&&&&&'' '"0'X'p'''''''''''''(( 0( @( P( `(p($(($(($)0).H)x).))()* * (* 8*H*(`******* + B_ADD_ROW_DATA_ORIGINS Macro& Macro recorded 09/18/2012 by Employee Keyboard Shortcut: Ctrl+Shift+BolUtility Data Origins$B@H KA 9 9 P9Jq  % 9 9 P9Jq   %(  % 9 9 P9Jq4:4$B@H<@ (A4:B4$&B@Ho8! D_ADD_AND_LINK_INV_ORI_CON Macro This macro will add a new row to to Utility Inventory, Utility Data Origins, and Conflict Matrix sheets, and link all three new rows together. Keyboard Shortcut: Ctrl+Shift+DUtility Inventory$B@H7:7$B@H B@ $" B@ A7$&B@H ((*U-00.00 ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqB7$&B@HType, Size Specifications ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqC7$&B@HCompany / Agency ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqHD7$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqhE7:F7$&B@HDescription OR "No Conflict" ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqG7:H7$&B@HM or R ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqI7:J7$&B@HY, N or leave blank ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqK7$&B@HY, N or leave blank ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9Jq(L7$&B@HY, N or leave blank ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqX M7$&B@H- ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9Jq A8$&B@HUtility Data Origins$B@HA4:B4$&B@H  r9p v9t9x9z9|9~9 99q 4:4$B@H $" B@ A6:J6$&B@H B@ T(V T(VA4$&B@H B@A4:B4$&B@H ((*  v9p v9t9x9z9|9~9 99q 5:5$B@HC5$&B@R4:4$!B@C4:J4$&B@H !6(J H !6(FI4$&B@H !6(JJ4$&B@H T(V T(VC4$&B@HCompany / Agency ,(.24 ,%0!6Times New Roman9Regular98 9:9<9>9@9B9D H9F9Jq D4:E4$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular98 9:9<9>9@9B9D H9F9Jq8F4:H4$&B@HIMost accurate source(s) of information documenting location of facilities ,(.2I4 ,%0!6Times New Roman9Regular98 9:9<9>9@9B9D H9F9Jq(J4$&B@HA, B, C, D or PH ,(.24 ,%0!6Times New Roman9Regular98 9:9<9>9@9B9D H9F9JqXJ5$&B@H TB@A4:B5$&B@HA5$&B@R  r9p v9t9x9z9|9~9 9q  r9p v9t9x9z9|9~9 9qX  9p v9t9x9z9|9~9 9q   %(   %(  % 9 9 P9Jq  % 9 9 P9Jqh  % 9 9 P9Jq0  % 9 9 P9Jq   %(  % 9 9 P9Jq4:4$B@H<@ (A4:B4$&B@HC4$&B@H='Utility Inventory'!R[3]C ,(.D4:E4$&B@H='Utility Inventory'!R[3]C ,(.A4:B4$&B@HContact Development Reference: ,(.24 ,%0!6Times New Roman9Bold98 9:9<9>9@9B9D H9F P9JqC4:E4$&B@H N !6(F !6(JConflict Matrix$B@H7:7$B@H B@ $" B@ A7$&B@H ((*U-00.00 ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqB7$&B@HType, Size Specifications ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F P9JqC7$&B@HCompany / Agency ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F P9JqD7$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F P9JqE7$&B@HA, B, C, D, PH ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9Jq8F7:G7$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqXH7:J7$&B@HSR 000 / 00+00 to 00+00 Rt/Lt ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqxK7$&B@HDescription OR "No Conflict" ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F P9JqL7$&B@HRelocate OR Protect in Place ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqM7$&B@HY, N or leave blank ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D H9F9JqN7$&B@H- ,(.24 ,%0!6Times New Roman9Regular989:9<9>9@9B9D N9F9Jq8A7:N7$&B@HN7$&B@R !6(J H !6(FF8:G8$&B@H T(V T(V T(V T(VB7$&B@H='Utility Inventory'!RC ,(.C7$&B@H='Utility Inventory'!RC ,(.D7$&B@H='Utility Inventory'!RC ,(.E7$&B@H!='Utility Data Origins'!R[-3]C[5] ,(.K7$&B@H"='Utility Inventory'!RC[-6]:RC[-5] ,(.K7$&B@H='Utility Inventory'!RC[-6] ,(.K8$&B@H T(V T(V T(VN7$&B@H='Utility Inventory'!RC[-1] ,(. N7,K7,B7:E7$&B@HE7$&B@R !6(J N !6(FB7$&B@HoεAttribute VB_Name = "Module4" Sub B_ADD_ROW_DATA_ORIGIN`S() F.DescriptionAdds one (1) row to thep of Utility Data Origins sheet, which is NOT linkedAany oFr'.!Proc2SInvok@e_FuncSB\n1' ' Macro recordH09/18/2012 by EmployeeKeyboard Shortcut: Ctrl+Shift+B Sxs("").Select Range("A4:B4 With .HorizontalAlignment=xlGeneralH Vertic% C er Wr apTexATru@;p aD0 Ind0FalsI Level@I Shra~ToFi ReadingO@brxlC@9%MergeCel ls+End #KC Row@_4:MTS.InsFqn:=xlDownd6:J6 d!Copy ActiveWindPow.Sl-lum21FLC.PastYAppl >6.Cut !-?K,K.FKGKCK 6!NKKK#3K5:542C b6aF5HQEntireS.AutA`?C4:JVF@.Colorkx]_3RBU`rr!>xlStyleN`JI d4DNCUate aC  ~.FormulaR1C1 "CompA/ AgencyaEB\Characters(Start:=1, L ength@6)- nD.Time ew Roman B-*(RegrSi*z01[S kethroughq USup@bpOutaA .ShaJ."#"' 1SpD4:EqR "SR 000 /P+p000Rt/Lt29đ a= 6Yr.reᢉF4:H8_E1st accurP source(s)infP?Z_'A˟ .= Ɵ˟ˠe>Ui<+53`alAlignment = xlC@er .WrapTex!tTruedOriationt02AddInd8.Fals j0 Level jShrinkToFil 7ReadingOrder8ontvEnd` With  Selec.Horiz7 RightVe0rtic .#Ǎ.Bos(xlDiagonalDown).LineStylbeYNonoYUp KcEdge`Left)H^ Cjinuous WeAk'MediumColorxAutom@cY%Top%o%@iKBot@4w&ThinK ~%h8C&.&J#RInsidexS#u_.6TRows("4:4").- Ha28.5Range("A4:BI_Sub D_AD`ND_LINK_INV_ORI _CON(`Attribute.VB_Desc(ripd"s  (1) row to the Utility Invory,FData @gins a`~flict Ma`x sheet4s,blĠll ree new s@ ge` r." ONProca`oke_Func`"D\n14@ 0' ' croaSiz82Strikethrough^False upcriptbsOut0line9hadow Undefr xlkNonMColor*Ix3ZEn@d WithRange("G7:H7").SelecForBmR1C1$"M or R%M6A.S?mn {?m.&mI7:J!'mY, Nmleave blan2kqp19p _8n_8in _8 nK7n7773rL77?7777ooo7s hooooMwLo-R_]1ROOntOwO.OOrKOmL.69Sn.R"ORO6A8Sheets("Utility Data Origins4WA4:B4"81Ïion.HorizontalAlignme2+xlGeneralVertiJc}CerhW@rapTexTru@ at.08Add,2`:Level\ShrinkToFi .ReadingOr8xlCPp hMetrgs o2w4:.Ins Shif xlDow06:J6 CopyC Winp@.Scrol@ lhumn 2/-1#V $.PastO#Appl.Cut Mod8Ÿ%q%%ap#%= o.% .%%WF%U%i,%%%%("5:5|mCq2a(EntireRow0.Aut!0C4:J+7b/ G)1?Nc"(#H#`#p#### # # # $ $ $ 0$ @$ P$ `$p$ $ $ $ $ $ $ $ $ %%(% E_ADD_ENTRY_COST_ESTIMATE Macro& Macro recorded 11/15/2012 by Employee (   %(   %(   %(   %(   %(A16:J16$&B@HJ16$&B@R   %(   %(   %(   %(   %(  % 9 9 P9Jq(   %(A15:J15$&B@HJ15$&B@R   %(   %(  % 9 9 P9Jqx  % 9 9 P9Jq@  % 9 9 P9Jq  % 9 9 P9Jq  % 9 9 P9JqL16$&B@H   %(   %(   %(   %(   %(   %(   %(   %(   %(   %(  % 9 9 P9JqX   %(   %(   %(   %(   %(  % 9 9 P9Jq   %(   %(  % 9 9 P9Jq@L15$&B@H   %(   %(  % 9 9 P9Jq  % 9 9 P9Jq  % 9 9 P9JqP  % 9 9 P9JqJ10:K10$&B@H  v9p 9t9x9z9|9~9 99q B@J11:K11$&B@H  v9p 9t9x9z9|9~9 99q( B@J12:K12$&B@H  v9p 9t9x9z9|9~9 99q B@J13:K13$&B@H  v9p 9t9x9z9|9~9 99q( B@J14:K14$&B@H  v9p 9t9x9z9|9~9 99q B@J15:K15$&B@H  v9p 9t9x9z9|9~9 99q( B@L10:M10$&B@H  v9p 9t9x9z9|9~9 99q B@L11:M11$&B@H  v9p 9t9x9z9|9~9 99q( B@L12:M12$&B@H  v9p 9t9x9z9|9~9 99q B@L13:M13$&B@H  v9p 9t9x9z9|9~9 99q( B@L14:M14$&B@H  v9p 9t9x9z9|9~9 99q B@L15:M15$&B@H  v9p 9t9x9z9|9~9 99q( B@ T(C10:F10$&B@H  v9p 9t9x9z9|9~9 99q B@C11:F11$&B@H  v9p 9t9x9z9|9~9 99q B@C12:F12$&B@H  v9p 9t9x9z9|9~9 99q B@C13:F13$&B@H  v9p 9t9x9z9|9~9 99q B@C14:F14$&B@H  v9p 9t9x9z9|9~9 99q B@C15:F15$&B@H  v9p 9t9x9z9|9~9 99q B@A16:F16$&B@H   %(   %(   %(  % 9 9 P9Jqp   % 9 9 P9Jq8   %(   %(C19:F19$&B@H T( T( T( T( T( T(V T(V T(V T(V T(V T(V T(V T(VG10:M10$&B@H   %(   %(   %(   %(   %(   %(   %(   %(   %(   %(  % 9 9 P9Jq  % 9 9 P9Jq  % 9 9 P9Jqp  % 9 9 P9Jq8   %(J12:K12$&B@H T(V T(V T(G10:M10$&B@H   %(   %(   %(   %(   %(   %(   %(   %(   %(   %(   %(   %(  % 9 9 P9Jqh   %(   %(   %(   %(  % 9 9 P9Jq   %(  % 9 9 P9Jq   %(   %(   %(   %(  % 9 9 P9Jq   %(  % 9 9 P9Jq  % 9 9 P9Jq`   %(K16,M16$&B@HM16$&B@R$ !(J T(V T(VA10:B10$&B@H  v9p 9t9x9z9|9~9 99qx B@ 0000-00-XXXX ,(.A10:B10$&B@H  9p 9t9x9z9|9~9 99qA11$&B@HPayable or Recievable? ,(.10:16$B@HA16$&B@R !69:9<9>9@9B9Dq(B11$&B@H# ,(.C11:F11$&B@HBid Item Description ,(.G11$&B@HLF ,(.G12$&B@HEA ,(.G13$&B@HLF ,(.G14$&B@HEA ,(.G15$&B@HLF ,(.A11$&B@HA11:A15$& l B@A11:A15$&B@HB11$&B@HB11:B15$& l B@B11:B15$&B@HC11:F11$&B@HC11:F15$& l B@C11:F15$&B@HC10:F10$&B@H New Company ,(.C11:F15$&B@H H !6(FA11:G15,A10:B10$&B@HA10$&B@R !6(JH11$&B@H T(VJ11:K11$&B@H,=IF(RC[-9]="Receivable", 0, (RC[-2]*RC[-1])) ,(.J11:K11$&B@HJ11:K15$& l B@J11:K15$&B@HL11:M11$&B@H*=IF(RC[-11]="Payable", 0, (RC[-4]*RC[-3])) ,(.L11:M11$&B@HL11:M15$& l B@L11:M15$&B@HK16$&B@H=SUM(R[-5]C[-1]:R[-1]C) ,(.M16$&B@H=SUM(R[-5]C[-1]:R[-1]C) ,(.I11:M16$&B@HM16$&B@R $#,##0.00 (2_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) ( K16,J11:K15$&B@HJ11$&B@R  !6(F M16,L11:M15$&B@HL15$&B@R  !6(FJ14:K14$&B@H T( T( T( T( T( T( T( T( T( T(J26:K26$&B@H T( T( T( T( T( T( T( T( T(Vo;Attribute VB_Name = "Module10" Sub E_ADD_ENTRY_COST_ESTIMATE()  L.DescriptionAdds one (1) company entry to the TOP of Cost E stimasheet. This may also be dOby pressing Ctrl+Shift+ E.$ProcData[Invoke_FuncA[E\n14$' ' Mac ro recorded 11/15/2012 SEmploy eeKeyboard Shortcut: ` Ss("").Select Rowx10: .Insert6G:=xlDown?C#}5Ra@nge("AEM16LActiv1BeWi@ndow.Svl@lColumA2-1GUBArs(8iagona^).LineStylxlN _Up With EdgeLeThin2ColorIndex:Auto mab"End W Range("L16").DiagonalDown)! None9UpEdgeLeftTo05Bot/6R+~jSHoriz@@bqGGrCA-Q$ D.?n(yu9n55_ ._a 5.«a.=zZ 6   Բ5߲lDrr%D+b$$$ $6z-Q O~wO~0 !5O~F~!O. o o J10:xK10.; XgoAlignmenCCerukAhWrapTexaAFalsD2OLri@on0HAdd] Level\ShrinkToFi .ReadingOѡc hMergeCellsxk(TфJ111 Comb#@..2U琔 sJ122P . .-=P¿--0 d.--$J133P oD 9 IoDoDfD44@`--`oD@oDoD?[geCells = False  End WithhSelection.MergRange("J15:K1p5").Jbv l&.HorizontalAlignmentyHxlCer(V ertic &Bottom&WrappTexDjOriTab04AddInd 5 LevelShrinkToFi6ReadingOrder?hrL;:L10:M10Ɋ?[?[C?[NL11[1?[nt?[?[G-߈͈L12-2- ߈ .߈!.߈߈J4߈߈G߈rL13-3-(----- . &L14-4-#---.rR1.-rr?[1Xr ߈߈ӈLЈM߈7y߈}{?[߈߈߈.߈  U߈߈AveWindow.ScrollRowJ9#CЊFߊ2 /Ã?]= xl3//cC//!1:F1ߊth/// oF//UOOϱQ?]"CЊF1ߊA -- ߊ"--p---CЊF1ߊ"g`e Range("C14:F14").SelectWith @ionL.HorizontalAlignment = x$lCerPVertic LBottom&WrapTexDFals#jOriTat b04AddI[A16[6 [gBozs(xlDiagonalDown).LineStyle1NonYUp EdgeLef6tW K.+To\p)BK,Ci nuousWeighxlThi)zColorfxAutnck[c{Q3$R?3n+Insidew&z9L9LActiveWindow.ScrollhRow+1dd1{#2>w`.umn F3lF ? d$;G10:M10߇߇߇ߎa[ۇ5b!NNQ=z7U77X;;\O`O`xl? 9 cO`wSpg4\P.nt\\ ._p3\\ "xlQ OfhqOfOf3 O Of\Ofo=)o x .?T?om?yxlOlENJ12:K12OlMlp a{n&]p9 Vhȿ Ϛ :w:0V_AH%4_S_SVmKKKVVώ//'3&V?___erɺ__YZ___P_T_AJ. loAoA5]]Jfght).LineStyle = xlNone  Selection.Borders(xlInsideVer tical+DiagonalDo$wn3rUp7With EdgeLeft) ContinuousWeiThin ColorIndexAutomapEnd EHTo5eBot7fAWRAJktSbbZ,Igu! .uu 2%T#Range("K16,M16").EA@vatnInterior.ʋ36CeWindow.Scrollumn@2_1CA10:B1020 Horiz@alAlignmentCerMWrapTexFals$!B Ori o0AddABLevelShrinkToFi ReadingO#MergeCellssC6a.Formul aR1C1"0A-00-X"?3&:32a.RUY qyTrukF1.Payabor Reciev?Eows("3>?A>NF Siza8)trikethrough['RSupcrip?- .Subsr.Outl!.ShaE@NB1tiv b2.#-C11:F!Q= "Bid Item DeS ШGt7LF2! 2;EA34G15oAFE.QFill"X$:=4:A, Type:=xlDefault+p("# k ("'1OO@O_tOA0@0w?I5INew Company;( Z >.Ura?=xl߷&,qF [NL;} "H;;JCK??=IF(RC[-9]=$""\ei\"" , 0, 2]*1]))߯"3 """s"uLM 11l43 Range("L11:M11").SelePct Xion.AutoFill DestinatP:= 5"), Typ e:=xlVDefaul T K16 ActiveCell.FormulaR1C1 = "=SUM(R[-5]@C[-1]: 1]C)"PMMPIR6YateNumberbat`$#,##p0.00Y_($* _); (""-""??@_,J]K1ґ@^.Font.Underline /xlFStyleSingleAccoun@g av,LB%?J@14:K14Window.ScrollRow610.#e12345678?"D_J26:K2w(^$,5^=E9(ColumnN End Sub StartLengthYFontU FontStyleSize Strikethrough" Superscript SubscriptV OutlineFontOShadow UnderlinexlUnderlineStyleNoneNd ColorIndex"C_Conflict_Matrix_ADD_ROW_no_linksxlUnderlineStyleSingledb xlAutomatic@Activate| ActiveWindow+ ScrollColumnLH ThisWorkbook|Sheet1Sheet2Sheet3Sheet4Sheet5Sheet6Sheet7Module2cModule3dModule4eB_ADD_ROW_DATA_ORIGINSSHorizontalAlignmentS@ xlGeneralbVerticalAlignmentʡxlCenterWrapText} Orientationw AddIndent2W IndentLevel ShrinkToFitA ReadingOrder xlContextP MergeCellsک ActiveSheet%NPaste EntireRowAutoFit&  LargeScroll~ToRightdxlRighteBordersC"xlDiagonalDownJ@ LineStylewxlNone xlDiagonalUp xlEdgeLeftL xlContinuous[Weight1xlMedium xlEdgeToph xlEdgeBottomxlThinw xlEdgeRight%vxlInsideVerticalj     !"#$%&'()*+,-./01235678:;<=>?@ACMxlInsideHorizontal RowHeightD_ADD_AND_LINK_INV_ORI_CON+Sheet8Module5fModule6gModule7hModule8iModule9jModule10UE_ADD_ENTRY_COST_ESTIMATE ScrollRow"xlBottom?Mergeq_Interior;xlLeft9AutoFill_ Destinationл xlFillDefault]j NumberFormatR xlUnderlineStyleSingleAccounting|hWorkbookk Y[   egi k m  ]_a c!"#0VModule40<531ad4a5lModule4y2AP Sheet80=531ad4a5 Sheet8=@ %Module50>531ad4a5Module5P 8Module60?531ad4a5Module6MPModule70@531ad4a5Module74hModule80A531ad4a5Module8 0Module90B531ar MR J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE11\MSO.0DLL#M 1@1.0 Ob LibraryKED Module1Gdu1 2 HB1pU(B,BG!B +BqThisWorkbook(G@T@sisW rkbo 2 $$M"B#$SheetBAS@#eutA]G2B#I%Ҧ2GL2]22ay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL#Microsoft Office 11.0 Object Library  MR  DModule101531ad4a5Module1GU(ThisWorkbook0D531ad4a5YThisWorkbookM Sheet103531ad4a5[ Sheet10% Sheet204531ad4a5] Sheet2H% Sheet305531ad4a5_ Sheet3Ȩ`% Sheet406531ad4a5a Sheet4#x% Sheet507531ad4a5c Sheet5¨% Sheet608531ad4a5e Sheet6% Sheet709531ad4a5g Sheet7%Module20:531ad4a5hModule2ƗModule30;531ad4a5jModule3mModule40<531ad4a5lModule4y2AP Sheet80=531ad4a5 Sheet8=@ %Module50>531ad4a5Module5P 8Module60?531ad4a5Module6MPModule70@531ad4a5Module74hModule80A531ad4a5Module8 0Module90B531ad4a5Module9jModule100C531ad4a5Module10 FPH h80x`#tVGDW=K,Y$\EX ?cIּCP D[G!=|-oFFO.#_zWeEDVfīF@Otb'OAD*uYM%ŻMrtZ\UE7`y Fmq~AFEzd)AcVBuA6*J#BȾ&MgFҢVO ' m#J^˪u{Y=H(+ ƱŢONbJ>.1`JВ-: \<]H6&0no,5Excel+VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuModule1b _EvaluateA_Utility_Inventory_ADD_ROWٙSheets RowsU SelectionZCopyƿInsertrShiftxlDown0DRange  Application* CutCopyMode ActiveCell FormulaR1C1S Charactersrg3333TȨ 4 4 4M 4 bJ# 5 5 5 5 6 6 6 6 7 j7 7 7 'T-AT/ͱT-Ɨ+ TUqUmUUU/rAP/y2f|8-:8):8-:8?:":=@5:@ddd_P f2M2W2__M_S2M3W3__4_S M?AWP__ 0_S9?|9$UW9?39$_hj[sS1p0Gz0K92?0dF3 K*yrU~~~~~~l ߳JUEu2(  a  ) A Y q    1Iayiy VBAProjectModule1 ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5Sheet6Sheet7Module2Module3Module4Sheet8Module5Module6Module7Module8Module9Module10F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  Y0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel  @0FC:\WINDOWS\system32\stdole2.tlbstdole aPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLLOffice `Fh@C|eKvFmb@Bi?a%DFWorkbook @rU~}  p__SRP_1PROJECTwmPROJECT SummaryInformation( 4 Module1Module1ThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5Sheet6Sheet6Sheet7Sheet7Module2Module2Module3Module3Module4Module4Sheet8Sheet8Module5Module5Module6Module6Module7Module7Module8Module8Module9Module9Module10Module10ID="{000E1573-6ADF-4225-9014-81196B5D8DEA}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Document=Sheet6/&H00000000 Document=Sheet7/&H00000000 Module=Module2 Module=Module3 Module=Module4 Document=Sheet8/&H00000000 Module=Module5 Module=Module6 Module=Module7 Module=Module8 Module=Module9 Module=Module10 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="292B9ADA9EDA9EDA9EDA9E" DPB="5250E12A0B2B0B2B0B" GC="7B79C805F006F0060F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 22, 634, 387, ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C Sheet4=0, 0, 0, 0, C Sheet5=0, 0, 0, 0, C Sheet6=0, 0, 0, 0, C Sheet7=0, 0, 0, 0, C Module2=44, 44, 656, 409, Module3=66, 66, 878, 678, C Module4=22, 22, 478, 367, Sheet8=0, 0, 0, 0, C Module5=88, 88, 536, 425, Module6=110, 110, 558, 447, C Module7=0, 0, 0, 0, C Module8=110, 110, 558, 447, Module9=132, 132, 580, 469, Module10=22, 22, 602, 119, Z Oh+'0 PXx Utility Report TemplateWindows UserMohamed Ali NounMicrosoft Excel@/@>6b@/I;՜.+,0  PXh px ADOT'  Notes and Instructions Cover PageContacts ListUtility InventoryUtility Data OriginsConflict MatrixCost EstimateAdditional Comments'Conflict Matrix'!Print_Titles'Contacts List'!Print_Titles'Cost EDocumentSummaryInformation89<CompObjBmstimate'!Print_Titles!'Utility Inventory'!Print_Titles  Worksheets Named Ranges F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q