ࡱ> B evSRzCompObj;MaVBFrame?UserForm3InputDataRng,xSPKkmKkmf+edded Object9q    VERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} UserForm4TimeStampCols Caption = " Time Stamp Definition" ClientHeight = 2385 ClientLeft = 45 ClientTop = 330 ClientWidth = 3885 StartUpPosition = 1 'CenterOwner TypeInfoVer = 10 End (H  @ }/R KQDBTahoma8KEFҋB `E \prfedie Ba=&% #$" ThisWorkbook=J< @"1Arial1Arial1Arial1Arial1Arial1 Arial1$Arial1Arial1Arial1Arial1Arial10Arial1 Arial1Arial1Arial1 Arial1 Arial1 Arial1QTahoma1QTahoma1QTahoma"$"#,##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.0 0.0000000 0.000000 0.00000 0.0000 0.000 mm/dd/yy;@ #,##0.0 mmm\ dd[$-F400]hh:mm:ss\ AM/PM m/d/yy;@% [$-F800]dddd\,\ mmmm\ dd\,\ yyyy 0.0% h\ AM/PM #,##0.00000#,##0.00000000"PODID No."\ General![$-409]m/d/yy\ h:mm\ AM/PM;@ #,##0\ "kWh" #,##0\ "kW"#,##0\ "kWh On-Peak"$[$-409]dddd\,\ mmmm\ dd\,\ yyyy[$-409]h:mm:ss\ AM/PM #,##0.000 #,##0.0000 #,##0.000000 #,##0.0000000#,##0.000000000#,##0.0000000000#,##0.00000000000#,##0.000000000000[$-409]h:mm\ AM/PM;@$[$-409]mm/dd/yy\ _h:mm\ AM/PM;@$[$-409]mm/dd/yy\ hh:mm\ AM/PM;@4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_) m/d/yyyy;@% "$"#,##0.0_);[Red]\("$"#,##0.0\) 0.00000000 0.000% mmm\-yyyy mmm\ yyyy                + ) , *    !       (             8   (  0   (   8   H  "X   H  "X   H  "X  "  #        D #  @           (   (   (  !X  8_{3ffff}̙̙3f3}ff3f3f73U33333\`6System DiagramԳMetrics MetricsPerSF Bldg1 Subsystems ComponentsuComponentsNormalizeHComponents_kWCalcComponents_tonsWCalc MenuSheet  HolidayList vcLists   BldgArea ComponentEquipID6ListAnnualWeekScheds#"N' ListDayScheds; F'ListDaySchedules: ; B"N' ListNormalize; :ListStartDates:C"N/ ListStartDays#"N( ListStartTimes; ' ListStopTimes; & ListWeekdays;( ListWeekScheds;G'ListWeekSchedules:;1B"NzcMeasures:C;B@:C;B@"NB"N+ MeasuresNormalize;   MonthArray` Ld ?January@February@March@April@May@June@July @August"@ September$@October&@November(@DecemberMonthDaysArray` b January?@February<@March?@April>@May?@June>@July?@August?@ September>@October?@November>@December?@ MonthNumArray{"January",1;"February",2;"March",3;"April",4;"May",5;"June",6;"July",7;"August",8;"September",9;"October",10;"November",11;"December",12}  Months;  MonthsArray` ȁ JanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberOctoberNovemberDecember-numAnnualScheds;b! ;,@ 'Subsystems:;B"N( TableDayScheds;' WeekdayArray2;" `, /_2zy21H`!zy21Hob^^xڕLVe?oRL T,(2KBi WMsmljXl%DШ-iB·s/fɳ}ϯｎh @Z(p}[l wdoW2Ҭc; 0& 8߆\x`E?+ipE~\1H٤`V#^,j]34zFḐr&dd>{xìu4-lα [H#pX7.d7T4',f?-tF]%ź^/$f?)T$J_sTrLsrhgFۿi5[L5pU*ʔ$WHRŻtAۛLUj&Qwؙ r;%f(SPt ~W_]P:f?-Əmڣ.k)55ޢݚ~esX<ƲQoHJ8sU/ЭE\\Q*gs^|7zG;MXSZ)o~ ͮa/ll3lv;USjzd]o\GEla,e7Ʋ䘒9ԝI y$p7bia2x=}E¼xJ5<ו+bBSxZxLUYf֟ʴ =`&锞*gZ#*Am]@;Ti#zO'Tmo/YhG!ZM|3T겼xZ*0gR7Le /e1_GjW t;U:k Ѧ(96v/qKoi:UHm\=bRjVa"o"x &|LK@=C"x &|L a! xڭVkQ6IX~X m)~!T)mBJJ{ࡹo=xУ')"R :v&tvgvΛ] \ˈ1_i972y|D$ Hy}FW kNĭ뷯)l}!L1slcGM3ZBu1B^X,E~`$53 -[OrTX߰Tb[Mby^R[zCy*7b,U"BGDGJawlj5D]R"ՊHc]Wl@*uJW+5D.TxA DDLg0i2LAsR$)H7eHS,"ǻoebjǠ?&8=X㾷_xyhEFKb.[gLbSƐZ5AGZw3XyH2*b>Zm>ZS#5ђ`$V6c5&X_Iwb5ĹƜۛ!LfoO.bJ7( M<]H]W\kltw{˾LN3 A@@+ |K( ComponentChillerkWTowerBoiler SubCategory Heating Plant Cooling PlantCHW DistributionHW DistributionAHUPump_CW Pump_HW_Pri Pump_CHW_Sec Pump_HW_Sec Fan_Supply Fan_Return Coil_Cooling Coil_Heating Tower FanTempOa Chlr_AmpsChlr_kW Chlr_%SpdChlr_HzChlr_ChW_TempInChlr_ChW_TempOutChlr_CW_TempInChlr_CW_TempOutTwr_AmpsTwr_kW Twr_Fan_Amps Twr_Fan_kW Twr_Fan_%Spd Twr_Fan_Hz AHU_TempOa AHU_TempRa AHU_TempMa AHU_TempSa AHU_TempSaSpAHU_Fan_S_Amps AHU_Fan_S_kWAHU_Fan_S_%Spd AHU_Fan_S_HzAHU_Fan_R_Amps AHU_Fan_R_kWAHU_Fan_R_%Spd AHU_Fan_R_HzAHU_CC_A_TempInAHU_CC_A_TempOutAHU_CC_W_TempInAHU_CC_W_TempOutAHU_Vlv_CC_%opAHU_HeC_A_TempInAHU_HeC_A_TempOutAHU_HeC_W_TempInAHU_HeC_W_TempOutAHU_Vlv_HeC_%opAHU_Dmpr_OA_%opAHU_Dmpr_RA_%opChlr_ChW_TempSpChlr_CW_TempSpPmp_ChW_Evap_PresInPmp_ChW_Evap_PresOutPmp_HoW_Pri_PresInPmp_HoW_Pri_PresOut ChW_dPres ChW_dPresSp HoW_dPres HoW_dPresSpPmp_HoW_Sec_PresInPmp_HoW_Sec_PresOutAHU_DuctStcPresAHU_DuctStcPresSp ChW_TempIn ChW_TempOut Blr_TempIn Blr_TempOut Blr_TempSp,Input fixed flows as well as fixed V and Ph..Should data be kept separate from output file?cCan we have them enter the list of equipment first, and use that to filter the options for mapping?AGive list of points up front, perhaps by type of chart(s) desired<Add separate type of weather data for bldg vs. NWS or other.YUse full point names (non-shorthand, but only maybe user's names) in metrics and charts.AGive users options to have a different name than EMS or tool namePmp_ChW_Evap_gpm AHU_Fan_S_cfm AHU_Fan_R_cfm AHU_HeC_W_gpm Pmp-CondW_gpmComponent ShorthandOrder 1Pmp_ChW_Evap_AmpsPmp_HoW_Pri_AmpsPmp_HoW_Sec_AmpsPmp-CondW_AmpsPmp_ChW_Evap_kWPmp_HoW_Pri_kWPmp_HoW_Sec_kW Pmp-CondW_kWPmp-CondW_PresInPmp-CondW_PresOutPmp_HoW_Pri_gpmPmp_HoW_Sec_gpm AHU_CC_W_gpmPmp_ChW_Sec_%SpdPmp_ChW_Sec_HzPmp_HoW_Sec_%SpdPmp_HoW_Sec_HzCountthermsthkWh therms/hrth/hrBlr_th Blr_th/hr Bldg CategoryMeterNaGasElecBldg_OaBuildingTotalBldgTotElecMtrNaGasMtrkBtu ElecMtr_kW ElecMtr_kWh NaGasMtr_thNaGasMtr_th/hr Chilled Water Pump_CHW_Evap Twr_TempIn Twr_TempOutPmp_ChW_Sec_AmpsPmp_ChW_Sec_kWPmp_ChW_Sec_PresInPmp_ChW_Sec_PresOutPmp_ChW_Sec_gpmDampersMeters Meter_Elec Meter_NaGas SubsystemsLevelCaptionPosition/MacroDividerFaceID SelectDataMonths MonthDaysDays WeekdayNumWeekdaySchedule Times Day SchedulesOccStartOccStopWeek SchedulesMonTueWedThuFriSatSunHolYear Schedules Starting Date Ending Date Week Schedule Starting Day Ending DayJanuary DaySchedule1 Quarter A DaySchedule2 DaySchedule3 DaySchedule4February Quarter BMarch Quarter CApril Quarter DMay DaySchedule5June DaySchedule6July DaySchedule7August DaySchedule8 September DaySchedule9October DaySchedule10NovemberDecembernumber of schedsWeek SchDay Sch Day ScheduleOcc?Occ2 OccupancyCreateSchedules DefinePointsDateLegal HolidaysTextDateYear New Years DayMartin Luther King DayPresidents Day Good FridayEaster Memorial DayIndependence Day Labor Day ThanksgivingFriday after Thanksgiving Christmas Eve Christmas New Years Eve NormalizeSFIntegrateOverTime BldgSF1000BldgSF PerSFmetricsNormalize_kWperTonNormalize_gpmPerTonNormalize_CFMperSF AddBinTempsCreatePrePostDates Chlr_StatusPmp_ChW_Evap_Status Twr_StatusTwr_Fan_Status Tower_Fan Chilled_Water Hot_Water Boiler_Status AHU_Status Fan_S_Status Fan_R_StatusPmp_HoW_Sec_Status Pump_HoW_SecPmp_HoW_Pri_Status Pump_HoW_PriPmp_ChW_Sec_StatusPmp_CondW_StatusAHU_Dmpr_ExA_%opCreateScatterChartByOccCreateScatterChartByDateRngCreateLPbyDaytypeCreateLPbyMonthYrCreateLPbyDateRngCreateLPbyYearCreateCalendarLPGeneralMetricsAll YearChart3dColoredDaytypes ContourChartE&CAM CreateLPbyDayLoad Profile by Day&type &Select Data&Definition of Points+Input Dates for Comparison of &Pre and Post"Create &Bin Data from Temperatures%Multiple Points &Watts per SF Metrics&General Metrics&Load Profile ChartsLoad Profile by &Month-Year&Load Profile by Date Range (&Pre/Post)Load Profile by &YearLoad Profile by &DayCreate &3d Load Profile%Create Energy Colors (&surface chart)Load Profile &CalendarScatter Chart by &Occupancy'Scatter Chart by Date Range (&Pre/Post)&Create &SchedulesCreate Per Sq. Foot &MetricsCreate &Other MetricsSca&tter Charts &Utilities(Convert Table format to ECAM List formatCombineTableIntoList &About ECAM AboutECAM*! 9"f"#5}##i$$+%"&O&(!)N)(*Ut**-+Z + ,: n, , -? |- - ..[ . . o/ /"~00$102]234cc  B  dMbP?_*+%M \\Peci-NAS1\7th Floor-Sharp AR-2  odXXLetterSHARP AR-P450 PCL6LPT1: <$  ''''d2dPUsername unknownJobname unknowno"CX??UHH(  B  H?D@>?"0?@NNN?N < ]`p'rjB  0D@>]``'xpB  6D@> Z]`P'rjB  0D@>]`'rjB @ 0D@>`--]`'rjB  0D@>Z]`8'rjB  0D@> ]`'rjB @ 0D@>`  ]`x'tl   c $A@>"` ` ] `'rjB   0D@>  i] `'rjB   0D@>  ] `H'tl   c $A@>"`@ 0] `'tl   c $A@>"`   @] `x'ff2  c $ A@p]`' <P< Fff  c $ A@ -P<]`' $< Mix< 0 GH@   Ap i ]&`'ff  c $ A@]`X' $<HX<rnff  c $ A@ P]`h' $<HX<rnff  c $4 A@ 0 x]`4H' $<HX<rnff2  c $ A@ Z ]`\' <P< Fff  c $ԟ A@ `i x]`ԟ<' $<Boiler< 7[ff2  c $e A@P -]`e' $<C<#a0ff2  c $ a A@`]` a|' <V< F  0\a A@"`]`\a(' $<Chiller< <_|  0a A@"` ]`aX' $ <Cooling Tower<  {ff2  c $a A@  `]`aH' <P< Ftl  c $A@>"` @  `]`('ff  c $t` A@ P ]`t`' $<HX<rnldB  s *D@>   ]`'rjB  0D@> %]`0'  6_ @1"`@%,]`_' $<Room<H"aldB   s *D@> ] `'rjB ! 0D@>00%]!`p'rjB " 0D@>00%]"``'rjB # 0D@>%]#`'H@ $  A ` <  i]&$`'rjB % 0D@> ]%`'n^ }iw &# P] &`'jbB ' s *D@jJ}iw]'`L'jbB ( s *D@jJiw](`'jbB ) s *D@jJiw])`X'jbB * s *D@jJiw]*`@'jbB + s *D@jJiw]+`'jbB , s *D@jJiw],`'td }iw -3 Z@  -] -`'jbB . s *D@jJ}iw].`'jbB / s *D@jJiw]/`'jbB 0 s *D@jJiw]0`'jbB 1 s *D@jJiw]1`'jbB 2 s *D@jJiw]2`\'jbB 3 s *D@jJiw]3`D'H@ 4  A p ]&4`'n^ }iw 5# P] 5`p'jbB 6 s *D@jJ}iw]6`'jbB 7 s *D@jJiw]7`'jbB 8 s *D@jJiw]8` 'jbB 9 s *D@jJiw]9`'jbB : s *D@jJiw]:`|'jbB ; s *D@jJiw];`d'n^ }iw <# ] <`'jbB = s *D@jJ}iw]=`'jbB > s *D@jJiw]>`d'jbB ? s *D@jJiw]?`'jbB @ s *D@jJiw]@`'jbB A s *D@jJiw]A`4'jbB B s *D@jJiw]B`'H@ C  A Z!]&C`'H@ D  Ap Z!]&D`H'H@ E  A Zp!]&E`'ff F c $ A@ "x #]F`' $<HX< rjB G 0D@> x "]G`rjB H@ 0D@> `##]H`rjB I 0D@> ""]I` <B J H?D@>?"0?@NNN?N `x `#]J`<td }iw K3 x] K`<jbB L s *D@jJ}iw]L`<jbB M s *D@jJiw]M`D<jbB N s *D@jJiw]N`<jbB O s *D@jJiw]O`<jbB P s *D@jJiw]P`<jbB Q s *D@jJiw]Q`< R 0$ A@"` Z ]R`$p<  <Pri. CHW pump<a X < S 0t A@"` i  ]S`t< <AHU Supply Fan<~@`H< T 0ĥ A@"`-K]T`ĥ < <Return Air Damper<v < U 0 A@"` Z ]U` <  <Sec. CHW pump<g X < V 0d A@"`  `]V`d0 < <AHU Cooling Coil<m0 < W 0 A@"` <Z]W`P < <Outside Air Damper<| < X 0 A@"`P ]X`p< <Return Air Fan<\ < Y 0T A@"`  p]Y`T < <AHU Heating Coil<m0 < Z 0 A@"`0<P!i]Z`P< <VAV box with reheat<0 < [ 0 A@"`x!][`@< <Fan-powered VAV box<0 < \ 0D A@"`PK]\`D0< <Condenser water pump<X < ] 0 A@"`@ i ]]` < <Water<&Bo< ^ 0 A@"`]^`< <Air<Bo< _ 04 A@  !"#$%&'(*+,-./02356789:;<=>?@ABCDEFGHIJKLMNOPQRSTUWXYZ[\]^_`abcdeghijklmnopqrstuwxyz{|}~@2iw  ]o`0%<rjB p 0D@> `  p ]p`%<ff2 q c $ A@  `]q`&< <P< F<rjB r@ 0D@>  P]r`'<rjB s 0D@> p ]s`0(<rjB t 0D@> `Z `]t`(<ff u c $L A@ P Z]u`Lp)< $<T<<ff v c $ A@ 0 x  ]v`P*< $<T<<ff w c $ A@ ` Z ]w`0+< 4<gpm<<ff x c $< A@  P ]x`<,< 4<gpm<<ff y c $ A@`K]y`,< 4<p<<ff z c $ܰ A@PK]z`ܰ-< 4<p<<ff { c $, A@`K]{`,.< 4<p<<ff | c $| A@PK]|`|/< 4<p<<ff } c $̱ A@p K]}`̱p0< 4<p<<ff ~ c $ A@ ` K]~`P1< 4<p<<ff  c $l A@ p K]`l02< 4<p<<ff  c $ A@ ` K]`3< 4<p<<tHd I 3  x 0] `3<rj2  c $A jJ"`I]`4<jbB  s *D jJ]`5<ff  c $\ A@`  ]`\5< $<T<<ff  c $ A@ Z ]`5< $<T<<ff  c $ A@ Z ]`6< $<T<<ff  c $L A@@ -]`L7< $<T<<ff  c $ A@ K P]`8< $<T<<ff  c $ A@  P]`9< $<T<<ff  c $< A@p#%]`<:< $<T<<ff  c $ A@ P  <]`;< $<T<<ff  c $ܵ A@  0]`ܵ<< $<T<<ff  c $, A@  p]`,=< 4<p<<ff  c $| A@ P ]`|>< 4<p<<ff  c $̶ A@@]`̶h@< 4<p<<ff  c $ A@ p 0]`HA< <?Not shown: "P across CHW piping<<ff  c $l A@Pi]`l(B< $<N< <ff  c $ A@  @ ]`C< $<N< <ff  c $  A@ p <]` C< $<N< <ff  c $\ A@ 0 ]`\D< $<N< <ff  c $ A@  ]`E< $<N< <ff  c $ A@i]`F< 4<x<<ll  s *L A@i]`LhG<  < x=position<< <ff  c $ A@ip]`PH< 4<x<<ff  c $ A@<P x]`0I< 4<x<<ff  c $< A@P]`<J< 4<x<<ff  c $ A@  ]`J< $<N< <ff  c $ܺ A@ @< x]`ܺK< 4<p<<ff  c $, A@  ]`,L< 4<p<<tHd I 3 "#-] `M<rj2  c $A jJ"`I]`$N<jbB  s *D jJ]`N<ff  c $̻ A@@!-"i]`̻(O< 4<x<<x  s >A ?@OKButton1P&<P(]` P1 6$?Forms.CommandButton.1D> @)))7 Sheet19    dMbP?_*+%"??1U>@7 Sheet2    dMbP?_*+%"??1U>@7 Sheet3  >g  dMbP?_*+%M\\Peci-NAS1\7th Floor-Minolta CC{dXXLetter$\I \Fiery X3e 22C-KM PCL v2.0   0T dd dd dd dd "dXX??U}  } m} } }  Order 1              O#"@ %(B#@ % B P Q R T S U  o r  n \ v   [  q p  s      { | }&@AD_D@ BldgTot_kW&XA D_D@ BldgTot_th& pA D_D @ BldgTot_th/hr& AD_D @ BldgTot_kBtu  z#@ % B~ ? y w ~&AD_D@ ElecMtr_kW&AD_D@ ElecMtr_kWh  #@dn- % B~ @ x w  &A D_D@ NaGasMtr_th& AD_D @NaGasMtr_th/hr   \4C  >@7 Sheet6  S  dMbP?_*+%M\\Peci-NAS1\7th Floor-Minolta CC{dXXLetterh$\I \Fiery X3e 22C-KM PCL v2.0   0T dd dd dd dd "dXX??U} m} m } m} m } m} $} m         "   !    #       #    #    #     #  xbbbDDDPH  0(   >@7 Sheet16    dMbP?_*+%"??U} I } I} I} I} m } $} }  } } } } m } } } } $} $}                            ]   ` t ^  J    D  _  H ( , 2 7 :    a   d u b  K    E  c  I ) - 3 8 ;  >  ! e L @  B  j  l  # * . 4 9   ?  " f M A  C  k  m  $ + / i Y  V   Z N g    F  % W X 0 5         G  &   1 6 <    h  '         =    88PH0 0(  > @  7 Sheet15    dMbP?_*+%M \\Peci-NAS1\7th Floor-Sharp AR-2  odXXLetterSHARP AR-P450 PCL6LPT1: <$  ''''d2dPUsername unknownJobname unknowno"dX??U} } } I} } I                         .W  .V    .a . . a . Z t.  . i u ..  .d .g ... d .b .h.... b .....  .c..... c .) . .... ) .- . .... - . .... . .... . .............&@TTBBF:<.888*@$(  $l $ s * +@N< ]`Z <This worksheet could be used to make multiple lists of points to use for groups of metrics. Similarly, a worksheet could be used to make multiple lists of points to use for groups of charts.<D>@7 Sheet17  |  dMbP?_*+%"?? mU} $ } $}  } } } m} m}  m                ]   ` ^  _ (  ,  a   d b  c )  - (>@7 Sheet18    dMbP?_*+%"?? mU} } I} $}  } $} $} $         V Z g J  h 2 7 K 3 8 i Y v<pp*>@+++7 Sheet20    dMbP?_*+%MB \\Peci-NAS1\7th Floor-Sharp AR>d  odXLetterSHARP AR-P450 PCL6LPT1:@ @ ( ''''d2dPo"d??U} } /} } m} I      $ $ % $ $~ &? & ~ '$@ &&~ (@ ( )(~ (@ ~ (@ ( )(~ (p{@ ~ (@ ( *(~ @@~ (@ ( *(~  @~ (@ (#*(~ (@ ($ )%~ (@ ~ (@ ( )(~ (B@ ~ (@ (  * ( ~ (@ 9 * ~ @~ (@ (! *(~ (@ 9 * (~ 0@~ (@ ( * (~ (@ 9 *~ `z@~ (@ 9 *~ `z@~ (@ 9 *~ `z@~ (@ 9 *~ `z@~ (@ 9 * ~ `z@~ (@ 9 * ~ `z@~ (@ 9 * ~ `z@~ (@ 9 *~ `z@~ (@ ("*(~ @ 9 *~ z@~ @ 9 *~ z@~ @ (& *'~ @8TF8PPBB<FP<B,B2888888882BBP(  x   6`LXPP? .x]4 @`L[ '!x@W- @ -<.1 for Menu 2 for MenuItem 3 for SubMenu Item <-xx   6LXPP? Nx]4 @Lh^ Ra&AHwcm5X 0<1Menu Caption. Use & for an underlined character <0~~  <(M XPP? 2@]4@(M0` +L}l@ >_ J<KIf Level 1, the menu position. If Level 2 or 3, the macro to execute. <iI Jxx  6MXPP? x]4@M0a [pBynX @<ATRUE if you want a divider before the Menu Item or SubMenu Item <K@xx  6MXPP? x]4@Ma IsFːMX [<\Code number for the image to be displayed next to the Menu Item or SubMenu Item (Optional) <[@A John Walkenbach  John Walkenbach John Walkenbach John Walkenbach John Walkenbach >@7 MenuSheetggD  $ `1DyXb  dMbP?_*+%"?? dU} } I Order          ~ 5@ 6B  Lmm/ddA001/01@@  LAE@  LBF~ 5@ 7B01/17@@@~ 5 @ 7(B02/21@@@~ 5@ 74B04/21@@@~ 5@ 7@B04/23@@?~ 5`@ 7LB05/29@@@~ 5@ 7XB07/04@@@~ 5@ 7dB09/04@@@ ~ 5@ 7 pB 11/23 @@  @ ~ 5@ 7 |B 11/24 @@  @ ~ 5@ 7 B 12/24 @@  ? ~ 5@ 7 B 12/25 @@  @ ~ 5`@ 8 B 12/31 @@  ?~ 5@ 6B01/01D@@~ 5@@ 7B01/15D@@~ 5 @ 7B02/19D@@~ 5@@ 7B04/13D@@~ 5@ 7B04/15D@?~ 5@ 7B05/28D@@~ 5@ 7B07/04D@@~ 5 "@ 7C09/03D@@~ 5 ,@ 7 C11/22D@@~ 5@,@ 7C11/23D@@~ 5 0@ 7$C12/24D@@~ 5@0@ 70C12/25D@@~ 51@ 8?~ 5`C@ 7 C 05/27 H@  @!~ !5 H@ !7!C!!!@ Lmm/ddA007/04!H@!!!@ LAE!@"!!@ LBF~ "5O@ "7"C"!09/02"H@"!"@#!~ #5Z@ #7#C#!11/28#H@#!#@$!~ $5Z@ $7$C$!11/29$H@$!$@%!~ %5]@ %7%C%!12/24%H@%!%@&!~ &5]@ &7&C&!12/25&H@&!&@'!~ '5^@ '8'C'!12/31'H@'!'@(!~ (5^@ (6(C(!01/01(L@(!(@)!~ )5 a@ )7)C)!01/20)L@)!)@*!~ *5d@ *7*C*!02/17*L@*!*@+!~ +5 l@ +7+D+!04/18+L@+!+@,!~ ,5`l@ ,7,D,!04/20,L@,!,?-!~ -5p@ -7- D-!05/26-L@-!-@.!~ .5u@ .7.,D.!07/04.L@.!.@/!~ /5 }@ /7/8D/!09/01/L@/!/@0!~ 05@ 070DD0!11/270L@0!0@1!~ 15 @ 171PD1!11/281L@1!1@2!~ 25`@ 272\D2!12/242L@2!2@3!~ 35@ 373hD3!12/253L@3!3@4!~ 45@@ 484tD4!12/314L@4!4@5!~ 55`@ 565D5!01/015P@5!5@6!~ 65@ 676D6!01/196P@6!6@7!~ 75 @ 777D7!02/167P@7!7@8!~ 85@ 878D8!04/098P@8!8@9!~ 95@ 979D9!04/119P@9!9?:!~ :5@@ :7:D:!05/31:P@:!:@;!~ ;5@ ;7;D;!07/04;P@;!;?<!~ <5@ <7<D<!09/06<P@<!<@=!~ =5@ =7=D=!11/25=P@=!=@>!~ >5@ >7>D>!11/26>P@>!>@?!~ ?5 @ ?7?D?!12/24?P@?!?@@!Dkl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_~ @5@@ @7@E@!12/25@P@@!@@A!~ A5@ A8AEAAA` Lmm/ddA012/31AP@AAA` LAEA@BAA` LBF~ B5 @ B6BEBA01/01BT@BAB@CA~ C5 @ C7C(ECA01/17CT@CAC@DA~ D5@ D7D4EDA02/21DT@DAD@EA~ E5@ E7E@EEA03/25ET@EAE@FA~ F5@ F7FLEFA03/27FT@FAF?GA~ G5@ G7GXEGA05/30GT@GAG@HA~ H5 @ H7HdEHA07/04HT@HAH@IA~ I5@ I7IpEIA09/05IT@IAI@JA~ J5@ J7J|EJA11/24JT@JAJ@KA~ K5 @ K7KEKA11/25KT@KAK@LA~ L5@ L7LELA12/24LT@LAL@MA~ M5@ M7MEMA12/25MT@MAM?NA~ N5@ N8NENA12/31NT@NAN@OA~ O5@ O6OEOA01/01OX@OAO?PA~ P5@ P7PEPA01/16PX@PAP@QA~ Q5@ Q7QEQA02/20QX@QAQ@RA~ R5@ R7RERA04/14RX@RAR@SA~ S5@ S7SESA04/16SX@SAS?TA~ T5@@ T7TETA05/29TX@TAT@UA~ U5@ U7UFUA07/04UX@UAU@VA~ V5@ V7V FVA09/04VX@VAV@WA~ W5@ W7WFWA11/23WX@WAW@XA~ X5@ X7X$FXA11/24XX@XAX@YA~ Y5`@ Y7Y0FYA12/24YX@YAY?ZA~ Z5@ Z7Z@ d7dFda11/22d\@dad@ea~ e5 >@ e7eFea11/23e\@eae@fa~ f5B@ f7fFfa12/24f\@faf@ga~ g5 B@ g7gFga12/25g\@gag@ha~ h5B@ h8hFha12/31h\@hah@ia~ i5C@ i6iFia01/01i`@iai@ja~ j5E@ j7jFja01/21j`@jaj@ka~ k5I@ k7kGka02/18k`@kak@la~ l5M@ l7lGla03/21l`@lal@ma~ m5@M@ m7m Gma03/23m`@mam?na~ n5@U@ n7n,Gna05/26n`@nan@oa~ o5 Z@ o7o8Goa07/04o`@oao@pa~ p5a@ p7pDGpa09/01p`@pap@qa~ q5`l@ q7qPGqa11/27q`@qaq@ra~ r5l@ r7r\Gra11/28r`@rar@sa~ s5o@ s7shGsa12/24s`@sas@ta~ t5o@ t7ttGta12/25t`@tat@ua~ u5p@ u8uGua12/31u`@uau@va~ v5p@ v6vGva01/01vd@vav@wa~ w5s@ w7wGwa01/19wd@waw@xa~ x5v@ x7xGxa02/16xd@xax@ya~ y5 }@ y7yGya04/10yd@yay@za~ z5`}@ z7zGza04/12zd@zaz?{a~ {5@ {7{G{a05/25{d@{a{@|a~ |5@ |7|G|a07/04|d@|a|@}a~ }5@ }7}G}a09/07}d@}a}@~a~ ~5@ ~7~G~a11/26~d@~a~@a~ 5@ 7Ga11/27d@a@aDkl~ 5`@ 7Ha12/24d@a@a~ 5@ 7HLmm/ddA012/25d@LAE@ LBF~ 5@@ 8H12/31d@@~ 5`@ 6(H01/01h@@~ 5@ 74H01/18h@@~ 5@ 7@H02/15h@@~ 5@ 7LH04/02h@@~ 5@ 7XH04/04h@?~ 5 @ 7dH05/31h@@~ 5`@ 7pH07/04h@?~ 5`@ 7|H09/06h@@~ 5`@ 7H11/25h@@~ 5@ 7H11/26h@@~ 5@ 7H12/24h@@~ 5 @ 7H12/25h@@~ 5@ 8H12/31h@@(-$ ,  ->l@74;0@ laD laC B$ Sheet8  2nݕ  dMbP?_*+%M \\Peci-NAS1\7th Floor-Sharp AR-2  odXXLetterSHARP AR-P450 PCL6LPT1: <$  ''''d2dPUsername unknownJobname unknowno"dX??U} }  } I}  } m } }  I } } } } I} } $ } I}  } m} m} m } I 2"""""""""" " " " " """  +                         ! ?@?? H  L h:mm AM/PMA0 12:00 AM~  ,  ~  , ,OO?,          ?-@-@@ .?( LALAEAA.v@~  j@! C <@@@ P 12:30 AM ,UUUUUU?  ~  , ,OO?,         ~ @ --.. ?@@@ P 1:00 AM ,ZUUUUU?  ~  , ,OO?,         ~ @ --.. >@@@ P 1:30 AM~  ,@  ~  , ,OO?,         ~ @ --.. ?@@@  Q 2:00 AM ,SUUUUU?  ~  , ,OO?,         ~ @ --.. >@@@ Q 2:30 AM ,?  ~  , ,OO?, ?@@@ ,Q 3:00 AM~  ,?  ~  , ,OO?,. ?@ @@"@ LQ  4:00 AM ,aUUUUU? ~ , ,OO? , .  ?@$@ \Q  4:30 AM~ ,2@ ~ , ,OO? ,  >@&@ lQ  5:00 AM ,? -  ?@(@ |Q  5:30 AM ,JUUUUU? -~ *@ Q 6:00 AM~ ,? -~ ,@Q 6:30 AM ,UUUUUU?-~ .@Q 7:00 AM ,?-~ 0@Q 7:30 AM~  ,@?@~ 1@Q 8:00 AM ,OUUUUU?-~ 2@Q 8:30 AM ,?          ~ 3@Q 9:00 AM~  ,?/UUUUs@#0? %B?0?!)D:D"NB@(Q!%DB Quarter A0@ LBF=R!'%D%B@DB DaySchedule31,R)g ]%%L$D"NB@B%B@LBFB DaySchedule38,!"% @ @D% B@B8,OO?!"% @ @D% B@B`46!JDDAD DDAD B$ OccUnoccBOccHR!DDA@% @ @%%DB%B@DBFB% B@B@ DDA@% @ @%%DB%B@DBFB% B@B@ B$@OccUnoccBOcc1PR) LLA- @@L% B@B LLA- @@L% B@B B$ OccUnoccBOcc~ 4@XR 9:30 AM ,UUUUUU?/YKA@0=0?!'D$D"NB@(hR!%DB Quarter A0@=|R!'%D%B@DB DaySchedule21R) DaySchedule28,!"% @ @D% B@B8,OO?!"% @ @D% B@B`R!JDDAD DDAD B$ OccUnoccBOccR!DDA@% @ @%%DB%B@DBFB% B@B@ DDA@% @ @%%DB%B@DBFB% B@B@ B$@OccUnoccBOcc1R)Occ~ 5@R 10:00 AM ,?/@ 000@1R) DaySchedule3 ,,1R)Occ~ 6@S 10:30 AM~  ,E@/$6<9 @ 000@1S) DaySchedule2 ,,14S)Occ~ 7@@T 2:30 PM ,SUUUUU? 2/`X8@0@1T) DaySchedule31T)Occ~ ?@T 3:00 PM~  ,?/#cm@0@1T) DaySchedule31U) OccD%lzmmSWWIM !"#$%&'()*+,-./01  U! 3:30 PM ,? 3!0U!!!1L h:mm AM/PMA0 4:00 PM! ,XUUUUU?0!.f@"DADAEAA"@U#! 4:30 PM~ " ,0Q@"3#PU$! 5:00 PM# ,?#3$`U%! 5:30 PM$ ,SUUUUU?$3%pU&! 6:00 PM~ % ,?%3&U'! 6:30 PM& ,?&3'U(! 7:00 PM' ,XUUUUU?'3(U)! 7:30 PM~ ( ,PT@(3)U*! 8:00 PM) ,?)3*U+! 8:30 PM* ,SUUUUU?*3+U,! 9:00 PM~ + ,?+3,U-! 9:30 PM, ,?,3-U.! 10:00 PM- ,XUUUUU?-3.V/! 10:30 PM~ . ,pW@.3/V0! 11:00 PM/ ,?/30,V1! 11:30 PM0 ,SUUUUU?031@V-! 11:59 PM1 ,OO?1 413(TIEIIEIIEIIEIJFJJ 1 1T` <(   ~  <{XPP? x]4@{e _w!XJryp <Bill Koran: Day of Year<7 D ~~  <{XPP?!x]4@{f jQ%XEVj <Bill Koran: Day of Year<7 D  Bill Koran Bill Koran>@' '' 7 Sheet1 VBAP?9mdmThisWorkbook* __SRP_2)__SRP_371PSLSS6" <<<N0{00020819-0000-0000-C000-000000000046} @`@|kT  ` Xi Show%@ %8 %`@@\TI!$*\Rffff*1e492ed4a7$*\Rffff*1f492ed4a74 " ( $0 ,X $ $ 6  "8` "  hpx" Dim frmSplash As FSplashScreen 'show the form modelessly% Set frmSplash = New FSplashScreenx frmSplash.Show vbModelessCo 'process the startup coders0 Application.Wait Now + TimeValue("00:00:6 ")A Unload frmSplash Set frmSplash = Nothingo@A oxͱAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 P Sub _Open() ' Dim frmS1sh As FScreen 'show the form model esslySet#= New$75.S(vbMÄ$3proc,5startup cApplication.W ait N%+ TimeValu@e("00:6 "@88Call ieMenu  "Unload-3othing EndSEVBeGeCls(CancelTBoolean5I$DOtD$rU   9 #4a  ` ` IW<   $ 0 @  44PrU @$`T(A`X #n("H#xMESheet34JSheet20 VSheet16 fSheet19vPSLSS<(< ,<0<<N0{00020820-0000-0000-C000-000000000046} $@)&`og % *% .%%I!"  8@(X P .  (H X]h] ptMetricsSF$2.*@ . *!4 &%6!8MonthYr &!8mmm yyyy >!@%d &%6!8 .%:(<d( &!8 &%6!8 .%:(<k . >!B DG >B@FjoAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_Change(ByVal Target As R ) Dim WS  pPivotT7 S#=5s("ptMecsSF".On Erro@r ResuN(ext F EaHch 1In@.M2sNIf-.Offset(0@, -1).3uAa"MonthYr" Then pt.PageFields(C?).Curre,ntA @m_Application.HFuncBT@4%, "mpmm yEA#EBA'2G*End IfAYU`GoTo 0U5Calcu'8?xlManu@W  '#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0I!xAttribute VB_Name = "Sheet20" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2'I#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0I!xAttribute VB_Name = "Sheet16" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2-cx)OKButton1, 163, 1, MSForms, CommandButtonME(SLSSsN0{00020820-0000-0000-C000-000000000046} N@ T% %*C@xl@I!*\R8002*#5d" & 0@ "H Ppx Worksheets("Dummy").Activate PB@Ro8@ XSystem Diagram$2(VozAttribute VB_Name = "Sheet19" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2ControlOKButton1, 163, MSForms, CommandP:> Sub _Click( ) ' Workss("Dummy").Activ User01DefineEquip.Show End. É5)_Dea%8&System Diagram!VisiCcxlVeryHidden'#xME (SLSS<N0{00020Sheet8Sheet6 MenuSheetSheet15820-0000-0000-C000-000000000046}@(%H@0I!xAttribute VB_Name = "She@et8" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2'#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0I!xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ce#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0I! xAttribute VB_Name = "MenuSheet" " Bas0{00020820v-C$0046} |GlobalSpacAFalse dCreatablPredeclaIdTru B@ExposeTemplateD0eriv$Bus`tomizD2  'Z#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0I!xAttribute VB_Name = "Sheet15" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2'#xME (Sheet18 Sheet2HSheet17Sheet15SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0I!xAttribute VB_Name = "Sheet18" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2("#xMEPSLSS<(< ,<0<<N0{00020820-0000-0000-C000-000000000046} $@)&` % *% .%%I!"  8@(X P .  (H X]h] ptMetrics$2.*@ . *!4 &%6!8MonthYr &!8mmm yyyy >!@%d &%6!8 .%:(<d( &!8 &%6!8 .%:(<k . >!B DG >B@FjoAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_Change(ByVal Target As R ) Dim WS  pPivotT7 S#=5s("ptDMecs"-On Error ResuNex tF EachR 0In?.1sMIf-.Offset(0,      !"#%&'()*+,-./0123456789:;<=>?@ACDFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsuvwxyz{|}~ P-1).@3u`"MonthYr"` Then pt.PageFi`elds(>).Current A l_Application.HFuncBT@4%, "mmm yEA#E’A'2G*End IfAYU`GoTo 0U5Calcu8 ?xlManuA@W @A '/E#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0I!xAttribute VB_Name = "Sheet17" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2''#xME (SLSS<N0{00020820-0000-0000-C000-00000