ࡱ> ZrtcY  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqstuvwxyz{|}~Root Entry Ftϴϝд[1Workbook_VBA_PROJECT_CUR"@дϝдVBA0дʝд 0@`\p Ba=  ThisWorkbookޯ=,KGf08@"1Arial1Arial1Arial1Arial1Arial1xArial1 Arial1hArial1hArial1Arial1 Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1dArial1Arial1 Arial1Arial1Arial1Arial1Arial1QTahoma1QTahoma1$Arial1 Arial1Arial1 Arial1Arial1Arial1QTahoma1 Arial1 Arial1 Arial1|Arial1|Arial1 Arial1Arial1Arial1Arial1 Arial1 Arial1Arial1Arial1Tahoma"$"#,##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\);_(* "-"??_);_(@_)0.0 0.000 "$"#,##0.00 .0"C" 0.0000 #\+###.00#\+##0.00_);\(#,##0.00\) 0.0% 0.00000 #,##0.000m/d/yy\ h:mm\ AM/PM 0.000000 #\+### #\+## 00000 #\+00.00 #\+00 #\+000.00 #\+0000.00 #,##0.0!"$"#,##0.00;[Red]"$"#,##0.00 mm/dd/yym/d #\+000\  0.0000000000                + ) , *        "            " " " "     "       " " " " "  " " "  "  " " " @   #  !    "     !    " "@ @  "@ @  " "@ @  " " " " " " "   " " "  a" a" " #        " !   ! " #    " " " "   "    `  "`   H  a H  H    " "@ @ + "@ @ + " " " "+  + "@ @ + "@ @ + "!@ @ + "@ @ + "!@ @ + "!@ @ + "!@ @ + "!!@ @ + "@ @+ "@ @+ "!@ @+ "@ @+ "@ @+ "!@ @+ "@ @ + "@ @ + "!@ @ + "@ @ + "!@ @ + "!@ @ + "!@ @ + "!!@ @ + "@ @ "@ @  "@  "@ " @ "@  "  "@  " " "  "    1" " "  "@ @ + "@ @ + "@ @ + "@ @ + "@ @ + "!@ @ + "@ @ + "!@ @ + "!@ @ + "!@ @ + "!@ @ + "!!@ @ +     " "@@ "  @ " "   " "+ "+ " + "@@+ "@+ "  @+ "@+ " + "@ + "  + "  + "@ @ +  "      "  "  "  "   "+ "+ "+ "+ "@@+ "@+ "  @+ "@+ " + " + " +  @ @ + "@ @ + "!@ @ + "!@ @ + "@ @ + "@ @ +  @ @ +  !@ @ +  !@ @ +  !@ @ +  !!@ @ +     "@+ " @+ "@@+ a"@+ "@+ " + "@+ a"+ " @ + " + " + " @ + a" + " + " + "@+   "  "   "  "   " " " "`  "`   `  "@ @ "@   L  H   @ @ + " + " + "@ @ + "@ @ + "!@ @ + "@ @ +  @ @ + "!@ @ + "!!@ @ + " "+ + "+ "+ "+ "+ "+  "+ "@ @ + "@ @ + "+ "+ "+ "@+ " "`  "  @@ "@  @  @   @  @   $"    " "     "  @   "  "@ @  " " @  ! "`@   `  "`  c"  c" "@ "@   "`@  "`   c"`  "@  c"  `@   @ "   !@  "@  " @    "    @    "  " "+ "   @        "  " " !"  "  &"   "     `  " @  "@ @ + "+   &"  " " " )" &"@ *" *" *  *" *"@ @ + "@ @ + *  *"@ )"  *"@ @  *! "@ ! "  "   *"@@ *"@ * @ *  @ *  * @     *  "@ "   "   *"@ @ + *" @  *"@ @ + *"`@  * `  *"`  *"`  *"`  * `  *  *" *c" *" * c" *" *"`  *"`  * c"`  *" *"@ @ + *"@ @ + *" @  *"  *"  *c"  *"  * c"  *  *" *" *" * c" *" " "      " "    *  "   +" " "  "@ @ + " " "@ @ + * " "@ @ +       " *"@ @ +   *"@ @        "!@ @ + *" "!!@ @ + *" *"@ + *"@ + *" -" " *"@ @  *"       " "   "  " "    #  ! ,      !    " "  c" " " c" "  "  " " #      !   " #   "  "   " @      .  '')  ') "')  "')  ')  ) ")  ")  ")   ')  ) " )  " )  ')  )  ) "') ") " )  ") ""+     " "  "  "     @  @   !" " " #     " ") " ) ." "  @ " " "`    "+ .  "@ @ + !      X   @+  0@  0  0 !"  @@+  @+ "+ "  "+  " "@@  " @   " " + "  "  "  "  /" /"  !@ @  !  "@  "  "  "@ " "  " + "@ + "@ " %" %"  &" # # "`  " `  " "  "+ "@@  " @  "`  " `  "  "@@  " @   " 0"@ 0"  @  " #  @@+  @+   @+  0@    0 " "@ "@ + '"@ '" '"  "@ " "  $"@ $" $"  !+ *"@@  *" @  *"@@  *" @  *"@@ *" @ *"  "  " *"@  *"  " *" *" *" *"  &" " *" *"`  *"`  " *"@ "  "X (X    `n Version Iz Version IISplit Production.z INSTRUCTIONS>INSTRUCTIONS OLD,0 Begin_Station__Lane_LT;0 Begin_Station__Lane_RT;BLA< BLB:copy_data_page2( Date_Mix_Cored;DMC<ELA: ELB<. End_Station__Lane_LT;. End_Station__Lane_RT;* Lane_Width_Paved;&LotDetermination:LWP</ Minimum_Lots_Required;MLR< mndot_rounding_1mndot_rounding_3paste_data_page2  ;o   =2   ;/  ;6 - Required_Lot_Length;RLL:SLA< SLB<1 Stations_Paved__Lane_RT;0 Stations_Paved_Lane_LT;. Total_Stations_Paved;* Total_Tons_Paved;TSP<TTP<`i 8e&1! 3  @@   REVISEDS.P.S.A.PPAVEDCORED TON TYPE ENGLISHC.P. REQ'D DENSITY=LV MIN. AIR VOIDS = LOTS REQUIRED = BID PRICE= DESIGN AIR VOIDS = MIX TYPE MV SAMPLE NUMBERSPNWTONS REPRESENTEDSPWEBULK %AIR VOIDTONSPAY INCENTIVELOTCORE # BULK SP.G SpG. USEDDENSITYUSED REPRESENT.FACTOR DISINCENTIVECOMPINCENTIVE THIS SHEETDISINCENTIVE THIS SHEETINCENTIVE / DISINCENTIVE TOTAL =CHK'D BYDATE :MIX DESIGNATION : PLANT # :NOTES%DENS.RED. (3) upper 4" (4) lower 4"(5)hvMV LV >4" REDUCED up 4" red.MIN.VOID REQ. DENS.DEN.COL.INCENT* VOID LIMITQ/CSAMPLE #TONS PAVED (metric) =SAMPLESTON # LOTS tested = TONS REP. TONS PER LOT=NONWEAR AIR VOIDSLVRNWWEARMVRSPNWRSPWERINCENT.INCENT* - 1 = N0, 2 = YES1VOID LIMIT - 3 = 3.5%MIN, 2 = 3%MIN, 1 = 2.5%MIN. PRICE ADJ.in/disenglishmetricTonsLotsAIR DRY (or dry wt.)PAN WT.DRY WT.SSD WT.4IMPROVEMENTS TO THE INCENTIVE / DISINCENTIVE PROGRAM6WORKBOOK (OR FILE) CAN CONTAIN SEVERAL DAYS OF PAVING.2THIS PROGRAM HAS BEEN MODIFIED TO ALLOW WORKSHEETS0TO BE COPIED WITHIN THE WORKBOOK, THEREFORE ONE METHOD 13CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE6THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,3THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THE 5HOLD THE CTRL (CONTROL) DOWN AND THEN LEFT CLICK AND DOWN AND DRAG TO THE RIGHT. METHOD 24THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN :RIGHT CLICK, CLICK ON THE COPY/MOVE BUTTON, CLICK OR CHECK+THE CREATE A COPY BOX AND THEN CLICK ON OK.(RENAME A WORKSHEET5CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE9RIGHT CLICK, CLICK ON THE RENAME BUTTON, THEN TYPE IN THEENEW WORKSHEET NAME, ( some typing characters may not be allowed in a >name due to their formula type functions). THEN PRESS ENTER.%MOVING A WORKSHEET WITHIN A WORKBOOK.7LEFT CLICK AND HOLD DOWN, WITH THE BOTTON DOWN YOU CAN 5MOVE THE CURSOR TO THE RIGHT OR LEFT TO POSITION THE !WORKSHEET TO THE NEEDED POSITION. METHOD 3 CLICK ON THE BUTTON TO THE RIGHT3THE DATA FOR DAY #1 SHOULD BE ENTERED ON THE SHEET5LABELED "day (1)". FOR DAYS THAT FOLLOW, MAKE A COPY:OF THIS SHEET BY USING ONE OF THE FOLLOWING THREE METHODS.OR SAMPLE TON #INDIVIDUAL VOIDSLOT 1LOT 2LOT 3LOT 4LOT 5LOT 6SAMPLE TONsampleston typeINCENT/DISINC RATIO=LOT #MAX TONS DATA BY :CORE THICKNESSCORE/PANIMM WT.% WATERABSORBEDMETRIClbs.per square yd in.= Average Density =Revision HistoryURevision for 8/8/2002 - this is the first published version to have the dual formats,/with and without the lab worksheet incorporatedNThis version also has added a flag for the incentive/disincentive to warn when!a bid price has not been includedzzzzhRevision for 8/27/02 - fixed the buttons for the copying macros fixed the date fields to be shink to fitSRevision for 11/13/02 - this version includes the manual overide for the number of Klots. Leave "0" in the overide cell to accept the standard number of lots.URevision for 11/14/02 - this version includes a facility for cutting and pasting dataSinto future revisions of this spread sheet. This facility is made possible by the Ifollowing macros and buttons: "copy_data", "paste_data", "buttons_off", 5"buttons_on", "copy_data_page2", "paste_data_page2", >button_3, button_4, button_26, button_27, button_53, button_54+and the addition of another sheet: "Sheet1"OThe addition of these items to an old spread sheet should give it the facility Lto paste data into a version of this spread sheet. The formatting from the Nrespective sheets ("combined" and "incentive") should be pasted into the sheetS"Sheet1". The formatting for "incentive" should be copied from "A1:m53" and pastedRto "Sheet1" starting at cell "a1". The formatting for "combined" should be copied7from "a1:r45" and pasted to "Sheet1" starting at "aa1". SEE SPEC. SP WEAR,SHLD MV LVSPSHLD3SPSHLD4SPSHLD3RSPSHLD4RMAT THICKNESS =OVERRIDE # LOTS = LOCATIONGmb / DENSITY TONS CONTRACTORHWYDATE: CHECKED BY:Average Density =MDR.# : NET Total = Ave.Gmm.= MIX TYPE = NET =MARSHALL DESIGNGYRATORY DESIGN.DENSITY INCENTIVE / DISINCENTIVE WORKSHEET ,"/DENSITY INCENTIVE / DISINCENTIVE WORKSHEET -(ABTONS - 1ST SECTIONSAMPLE TON # 1ST SECT.C4Compare the A and B values, insert the lessor value.D`The number of tons that represent the first section. Insert this value in the total tons paved.SAMPLE TON # 2nd SECT. C minus ADAILY TOTAL TONS PAVED =AREA "A" - TONS PAVED =AREA "B" - TONS PAVED =AREA "A"TOTAL TONS PAVED =NUMBER OF LOTS - MANUAL =AREA "B"5COMPLETE TEST DATA TAKEN FROM THE TEST SUMMARY SHEETSjSplit Production - The following worksheet can be used when a day's production needs to be split due to rdifferent density requirements or similar situations. Area "A" is defined as the first area paved from the start nrequired for each area may be manually entered on each worksheet. The intent is to not have more lots tested ' # OF LOTS REQ'D FOR DAILY TOTAL =mof that day's production and Area "B" is the remaining tonnage for that day's production. The number of lots8than the required amount for the total day's production.Notesmax density tons total tons tons per lot tons/sq ydAdjusted Price per ton8Would you like to calculate and use the weighted average>of the production air voids, rather than using the individual <air voids? The incentive/disincentive calculated using this>option is to be used for information only. The specification Acalls for using the individual air voids and the weighted average2method should NOT be used to calculate the actual 4incentive/disincentive to be paid to the contractor.<I would like to use the weighted average of the air voids - yesnoair void weighted average = Sq Yd REPRESENTSq YdsTRevision for 7/21/03 - this revision only effects the spread sheet if you are using Othe weighted average of airvoids option. Calculations of the weighted average Sairvoids is causing error when blanks are used in the calculation. Zeros are goingSto be used as place holders, instead of "" blanks. This will make the calculationsQwork. A conditional format will make the zeros look invisible. See the formulas?in cells D10:L11 for version I and cells D15:l16 for version IIQRevision for 9/4/03 - this revision reformated the "notes" fields. I merged the Kcells and set the format to "word wrap", and set the alignment to top/left.QRevision for 4/15/04 - this version has been changed to used the weighted average@percent air voids at production, versus the individual air voidsaverage mx spgIND. MAX SP.G.MOVNG AVG SP.G.is average availablenumber of max'slook up the avgaverageamaxQRevision for 9/24/04 - this version is the first version to calculate the averagePmaximum specific gravitity for the day. It also checks to see if there are moreOthan 2 max's for the day, and if there aren't, then it uses the moving average of the max MVNG AVG MX SP.G.Gmm.=ORevision for 7/21/05 - this version changes the dates to reflect specification @year 2005. There are no functional changes to the spread sheet.QRevision for 8/11/05 - unprotected the workbook, multiple copies of the worksheetcan be made in one spread sheet1Revision for 31JUL2006 - updated the year to 2006SPEC. YEAR "2006" N +OROP8[PP=QdQQ$ORvR(SOTV/WX X 6Y] Y# \8 L^si__>`e`ac:dkfTg{ij l2 0@ 0StvVgb  dMbP?_*+%0&?'{Gz?(333333?)(\?M\\MRL2KSPRINT\PAVE-ENG?d,,Letter.HP LaserJet 4000 Series PCL 62:xe.@?v(ł!~ uy ,(.OiBEml o-?=O l@E*;XhDB8i0t(ˈ ZԜܪwZ;.-@ ~hEDBăF> ?>SL 6mTQ Ϫ;#u|Gw^Ci^K  (D DDB    n( dL OLLLLLLLLLLdBM  7D "#DDD"BW 8 AD  ,DD  $P' $ "BK ,@P)5D   #D D d"B? )D  @$P*@B@- yJxcD  ND  1D   BID $$ ?? $P-""BK.A3T +D D?B > (D DDB  *  M  7D "#DDD"BW < AD  ,DD  $Q' $ "B 7 f!D   $Q*BU- yJ|cD  ND  1D   BID $$ ?? $Q-""BK94$#D COMPB >(D DDB  @ M P'7D "#DDD"B  0 D  DD D D B$DD D D B$D D DD B$COMP. CORE USEDGD D DD B$COMP. CORE USED  """"B  -7 C!D   $R*B -  yJcD  ND  1D   BID $$ ?? $R-""BK 12?a)D %BBQ` ;D &= AVERAGE CORE THICKNESS@B K  5D   #D D "B? *X )D  = Ave.Gmb.B7 C!D   $S*B 3 yHcD  ND  1D   BID $$ ?? $S-""BI;.%D  DBA+D D?B = 'D DDB  <  M  7D "#DDD"BW ( AD  ,DD  $T' $ "BK ,30T)5D   #D D d"B7 !D   $T*B@- yJcD  ND  1D   BID $$ ?? $T-""BK.A3  +D D?B =l 'D DDB  @  M p 7D "#DDD"BW , AD  ,DD  $U' $ "B 7 !D   $U*B- yJcD  ND  1D   BID $$ ?? $U-""BK:4d $D  COMPB  =T''D DDB   P M TU'7D "#DDD"B  0X D  DD D D B$DD D D B$D D DD B$COMP. CORE USEDGD D DD B$COMP. CORE USED  """"B  7 !D   $V*B - yJ cD  ND  1D   BID $$ ?? $V-""BK 12?a\)D %BBQ``;D &= AVERAGE CORE THICKNESS@B K ! 5D   #D D "B? *( )D  = Ave.Gmb.B7 t!D   $W*BUx| 3! yH(cD  ND  1D   BID $$ ?? $W-""BI;."%D  DBAH+D D?B =X 'D DDB  |  M \ 7D "#DDD"BW  AD  ,DD   $X' $ "BK , X)5D   #D! D d"B7 `!D   $X*B@dh-t>. yJ,cD  ND  1D   BID $$ ?? $X-""BK.A3L +D D?B =, 'D DDB    M 0! 7D "#DDD"BW  AD  ,DD   $Y' $ "B 7 L!D   $Y*BUPT- yJ0 cD  ND  1D   BID $$ ?? $Y-""BKD>@lrFpH8Q=jjO]mWw&_w& ,@!,@ ",@#,@$,@%,@ &,@',@(,@),@ *+ ,-./ 02,@ 12,` 22,`32,`42,`52,`62,`72,`82,` 92,` :2,` ;2,`<2,` =2,`>2 ?2 : 4"$D  COMPB   = D'D D D B    M X'7D  "#D D D "B  0! D   D D D D B$D D D D B$D D D D B$COMP. CORE USEDGD D D D B$COMP. CORE USED  """"B  57 @ !D   $Z*B D  H  - y J4!cD  ND  1D   BID $$ ?? $Z-""B K !12?!a!)D % BBQ!`;D! &= AVERAGE CORE THICKNESS@B! K! ) 5D   #D D "B?! *h )D  = Ave.Gmb.B7! 4!!D   $[*B!8!!< !3% y!H8"cD  ND!  1D   BID $$ ?? $[-""B!I !-1;".&%D  DBA"#+D" D"?B" ="" 'D" D"D"B "" %#  M" " 7D" "#D"D"D""BW" $ AD"  ,D"D$  $\' $" "BK" ,\)5D"   #D% D d"B7"  "!D"   $\*B"@$""("-3  y"J#cD  ND"  1D   BID $$ ?? $\-""B"K "11#.A#3\'+D" D"?B# =## 'D" D#D#B ## E$  M# % 7D" "#D#D#D#"BW# % AD#  ,D#D$  $]' $# "B# 7# C #!D#   $]*B#U##"#-3" y#J$cD  ND#  1D   BID $$ ?? $]-""B#K #11:$4&$D"  COMPB $ =$L 'D" D$D$B $$ b$ M$ f]'7D$ "#D$D$D$"B$ 0% D$  D$D" D$ D" B$D$D# D$ D# B$yD$ D" D$D" B$ COMP.GD$ D# D$D# B$COMP. CORE USED  """"B $ 7$ C$!D#   $^*B$$$# $-3# y$J%cD  ND$  1D   BID $$ ?? $^-""B$K $11 %12?%a:%)D" %"$BBQ%`!;D% &= AVERAGE CORE THICKNESS@B% K%  5D"   #D" D# "B?% *" )D"  = Ave.Gmb.B7% C%!D#   $_*B%%%$ %33l) y%H&cD  ND%  1D   BID $$ ?? $_-""B%I %11;&.'%D  D"BA&'+D& D&?B& =&& 'D& D&D&B && '  M& & 7D& "#D&D&D&"BW& ' AD&  ,D&D(  $`' $& "BK& ,3`)5D&   #D) D d"B7& &!D&   $`*B&@&&#&-3$ y&J'cD  ND&  1D   BID $$ ?? $`-""B&K &11'.A'3`'+D& D&?B' ='' 'D& D'D'B '' (  M' ) 7D& "#D'D'D'"BW' & AD&  ,D'D(  $a' $' "B' 7' C'!D'   $a*B'''&'-3& y'J(cD  ND'  1D   BID $$ ?? $a-""B'K '11:(4$c1$D&  COMPB ( =(H( 'D& D(D(B (( ( M( a'7D( "#D(D(D("B ( 0) D(  D(D& D( D& B$D(D' D( D' B$D( D& D(D& B$COMP. CORE USEDGD( D' D(D' B$COMP. CORE USED  """"B ( 7( C(!D'   $b*B(((' (-3' y(J`%cD  ND(  1D   BID $$ ?? $b-""B(K (11 )6?)a:))D& %&(BBQ)` %;D) &= AVERAGE CORE THICKNESS@B) K) *5D&   #D& D' "B?) *& )D&  = Ave.Gmb.B7) C)!D'   $c*B)))( )3p y)Hb$cD  ND)  1D   BID $$ ?? $c-""B)I )11*OD< *= *=@@ *A*AB*8+,$ $ $ $! $% $) Bfffff&O@ *<$ * => * <%* =>99 *9& *:; **+7 +B* +B?? +=+=%+81%(D*? +:'+ 3D%+ 4 + ;'+ 3w%D& + 499 +QH+1}w&2D   BID $$ ??%(pB+2 ++,7 ,,,999999999999 Q,5< ;D: no $Weighted Average Air VoidsBWeighted Average Air Voids,5556 ,,-79'(((((((" - ( - 00 -)-00= --.79#$$$$$$$% . + . 00 ..00>.6/?@@@@@@@@@@@@@@@@@A/.03333330&0000000,.1i//3333331&BBiijii,2 2*23333332&BBBBBkB, 3*33&BBBBBkB, 4*4PP4------4&BBBBBkB, 5*55)--5&BBBBBkB, 6$67 6 66)-6&BBBBBkB, 7$7 7 77&BBBBBkB, 8*8;;8&BBkBBkB,9 9*9\@\@\@p@p@p@49FFFFFFFFFFFCCCCCDCFFFFF1 :: : :  :-:@ :. :/ :0~ :@4:FFFFFFFFFFFCCCCCDCFFFFF1; ; ;1 ;2 ; ;3; ;4 ;F ;5 ;6 ;7 ; 8 ;!9&;"FFFF???????FFFFF1< < <<  #D D D D D D D D D D D D D D D D D D D D D D D D D D D B <  < < << < $<@W@@@?!&<"FFFFFFFFFFFFFFFF1 =f1= 0~ =U@ = = = = = == =D$=@V@@@?!="FF+ =,?<=-?=.?@@A0D=/~ =0E=1<L*DI&~ >@ > > > > > >> >$>@W@@@@!>"FF+ >,??>-?>.??x&D >/I>0A@F(3DF' D=.?DF'D B9>1CM*#DI'  $I& $I'B~ ?@ ? ? ? ? ? ?? ?G$?@V@@@@!?"FF+ ?,?A?-??.C@@ D ?/I?0A@F)3DF( D=.?DF(D Bd?1<N*NDI( DI' B$ $I&*DI(  $I' $I("BDB0l_4c4m YtpDJJ^TjjjTF@2 A2 B2 C2 D2 E2 F2 G2  H2 I2 J2 K2  L2M2 N2O2 P2Q2 R2S2 T2U2V2W2 X2Y2Z2 [2 \2]2^2_2 @ @<@?@@@@@@ @"@ ~ @ @ @ @ @ @ @ @@ @$@@@W@@@?! @"B~ @#?@$FF-@.F @F#D@/I@0A@I(3DF) D=.?DF)D B9@1<Q*#DI)  $I( $I)B A A8A8)AB#D B0AA#D D B6A$CA #D D D B<AbX9A&#D D D D BBAQA,#D D D D D BHAʡEA2#D D D D D D BNA  +A8#D D D D D D D BTA bX9A >#D D D D D D D D BZA -A D#D D D D D D D D D  B~ A@ A A A A A AA AH$A@W@@??! A"?E~ A#?A$)7A*t!D  $BA+9A,A@_(#D  $  $A*BA-FA.V@G,D A/IA0A@F-3DF* D=.?DF*D B9A1HF,#DI*  $I) $I*B BB6BB D   BBBB*BB  L  BBBBBBBBBBBB BB B BB B BB CB~ BU@ B B B B B BB B$B@@W@@@?! B"F~ B#@B$FFFFFFFFFFFF/IB0A@C03DF+ D=.?DF+D B9B1HI,#DI+  $I* $I+B CC$CE%BB d~ C@ C C C C C CC C$C@W@@??!"C"FFFFFFF/IC0A@a.3DF, D=.?DF,D B9C1H #DI,  $I+ $I,B D~ D!@ D D D D D DD D$D @W@@@@!"D"FFEEAF/ID0A@F.3DF- D=.?DF-D B9D1HR*#DI-  $I, $I-B E.E$*CIDC%@A Be~ E&@ E E E E E EE E$E @V@@@@! E"F9+E#?@^(D %<G!Bf E$: E%=;<E&>?>@>@>@>@>@@> @"@.E/FIE0A@F03DF. D=.?DF.D B9E1HS*#DI.  $I- $I.B~ F+@ F F F F F FF F$F @W@@@@! F"F+F#?@& D %<G!Bf F$= F%=>F&>F&FI&.$LF'>>0F&F(>?0F&F)>@0F&F*>=.F&F+>I*F&F,>I+F&F->D0F&F.>E0F&F/F)F0A@O*@D=.?F1H<G?@@@@@@ @"@ ~ GV@ G G G G G GG GI$G @V@@@@! G"FJ+G#?@_,D %<G!BfG$ G%=@G&>G-F&G'>G(F&G(>G&F&G)>G.F&G*>F&F&G+>G*F&G,>G+F&G->G)F&G.> F& G/FAA1H,D HHHHH LHHHHKHHHHHHHH HHH H HH H H~ H5@ H H H H H H HFE HKHFFFF?$ H%=H&>J1F&H'>H&F&H(>H'F&H)>H(F&H*>H)F&H+>H*F&H,>H+F&H->H,F&H.>H-F& H/FAA1III*II L  BIIIIIIIIIIIIII II I II I II JI~ I:@ I I I I I I IFE ILIFFFFF$ I%=CI&@=1F&I'@?1F&I(@I'F&I)@@1F&I*@A1F&I+@B1F&I,@C1F&I-@D1F&I.@E1F& I/FAA1$JH%II d~ J?@ J J J J J JJF J.JFFFFFF?EEFFA0J1G@@K1D=..K* DJ%GH Be~ KD@ K K K K K KKF KK??FF K!FK"FFAAA' K(?M K)? K*? K+? K,?! K-CN K.FFF0K1E@@D=.L V@> L L L L LLFF ~ L!?gL"M"QDL*@ DL(DL+.DL, DL(DL+ "BgL#M#QDM*@ DM(DM+.DM, DM(DM+ "BgL$M$QDN*@ DN(DN+.DN, DN(DN+ "BgL%M%QDO*@ DO(DO+.DO, DO(DO+ "B)L& O,DF# DL)%=BfDF# DL)%=BfDF# DL)%=BfDF# DL)%=BfbDF# DL)%=Bf4DF# DL)%=Bf"""""B`L'v/ JD D Q? D D Q? B% $  $ BL(  c(L(<Lc((2L SEE SPEC. 0LDA,BL)333L&D L*  L*eLc**[L FD: no #L?%=F01Bf $< "BL+p= ?@DrL, c-\DL& SEE SPEC.  SEE SPEC.5DG# DL& B$ $L&"BL- DL, SEE SPEC.  SEE SPEC.]DE#  $N"?DE#  $M"!DE#  $L""""BL.  L"L.\Lc..RLD@. L SEE SPEC.L A&B$B$ low voids ,B L/FF0L1Ep= ?@I&DL+MN@> M M M M MMFFF!aM"N"KDL* DL(DL+.DL, DL(DL+ "BaM#N#KDM* DM(DM+.DM, DM(DM+ "BaM$N$KDN* DN(DN+.DN, DN(DN+ "BaM%N%KDO* DO(DO+.DO, DO(DO+ "BM&`M'K JD D Q? D D Q? B% $  $ BM(  L(L(M)M*D L*M+DrM, L,\DL& SEE SPEC.  SEE SPEC.5DG# DL& B$ $L&"BM-U )DM, SEE SPEC.  SEE SPEC.]DE#  $N#?DE#  $M#!DE#  $L#"""BM.  \%L. M/FF0#M1Ep= ?@>1 %LM++NS@> N N N N NNF NO~ N@N N N !gN"L-QDL* @ DL(DL+.DL, DL(DL+ "BgN#M-QDM* @ DM(DM+.DM, DM(DM+ "BgN$N-QDN* @ DN(DN+.DN, DN(DN+ "BgN%O-QDO* @ DO(DO+.DO, DO(DO+ "B N&'N(  M(L(N)N*4 L*N+ O1DrN, M,\DL& SEE SPEC.  SEE SPEC.5DG# DL& B$ $L&"BN- L#DN, SEE SPEC.  SEE SPEC.]DE#  $N$?DE#  $M$!DE#  $L$"""BN.  M.L. N/FF0#N1Ep= ?@F' %LN++OX@> O O O O OOF O4P~ O?O+OF@wD %NOBfO 'O(  N(L(O)O*$ L*O+ DrO, N,\DL& SEE SPEC.  SEE SPEC.5DG# DL& B$ $L&"BO- L$DO, SEE SPEC.  SEE SPEC.]DE#  $N%?DE#  $M%!DE#  $L%"""BO.  N.L. O/FF0#O1Ep= ?@F* %LO++SP]@> P P P P PPFFF ~ P!@gP"Q"QDP*@ DP(DP+.DP, DP(DP+ "BgP#*Q#QDQ*@ DQ(DQ+.DQ, DQ(DQ+ "BgP$*Q$QDR*@ DR(DR+.DR, DR(DR+ "BgP%*Q%QDS*@ DS(DS+.DS, DS(DS+ "B)P&*S,DF# DP)%=BfDF# DP)%=BfDF# DP)%=BfDF# DP)%=BfbDF# DP)%=Bf4DF# DP)%=Bf"""""B`P'=ףpL'JD D Q? D D Q? B% $  $ BP(*O(L(P)DP&D P* {L*P+p= ?@P1DrP,* \DP& SEE SPEC.  SEE SPEC.5DG# DP& B$ $P&"BP-*L%DP, SEE SPEC.  SEE SPEC.]DE#  $R"?DE#  $Q"!DE#  $P""""BP. O.L. P/FF0#P1Ep= ?@P* %LP++S$Q@V@.>>> Q~ Q>QFFF!aQ"R"KDP* DP(DP+.DP, DP(DP+ "BaQ#*R#KDQ* DQ(DQ+.DQ, DQ(DQ+ "BaQ$*R$KDR* DR(DR+.DR, DR(DR+ "BaQ%*R%KDS* DS(DS+.DS, DS(DS+ "BQ&`Q'nJD D Q? D D Q? B% $  $ BQ(*P(L(Q)Q*L*Q+Q1DrQ,*P,\DP& SEE SPEC.  SEE SPEC.5DG# DP& B$ $P&"BQ-*P"DQ, SEE SPEC.  SEE SPEC.]DE#  $R#?DE#  $Q#!DE#  $P#"""BQ.*P.L. Q/FF0#Q1Ep= ?@I) %LQ++S$Rg@.>>> R~ R>RF RQ RR R R!gR"P-QDP* @ DP(DP+.DP, DP(DP+ "BgR#*Q-QDQ* @ DQ(DQ+.DQ, DQ(DQ+ "BgR$*R-QDR* @ DR(DR+.DR, DR(DR+ "BgR%*S-QDS* @ DS(DS+.DS, DS(DS+ "B R&'R(*Q(L(R)R*L*R+R1DrR,*Q,\DP& SEE SPEC.  SEE SPEC.5DG# DP& B$ $P&"BR-*P#DR, SEE SPEC.  SEE SPEC.]DE#  $R$?DE#  $Q$!DE#  $P$"""BR.*Q.L. R/FF0#R1Ep= ?@I- %LR++S$Sl@.>.> S~ S>SFS$@$@S 'S(*R(L(S)S*iL*S+S1DrS,*R,\DP& SEE SPEC.  SEE SPEC.5DG# DP& B$ $P&"BS-*P$DS, SEE SPEC.  SEE SPEC.]DE#  $R%?DE#  $Q%!DE#  $P%"""BS.*R.L. S/FF0#S1Ep= ?@I. %LS++S$Tq@.>.> T~ T>TFT????T ~ T!@gT"U"QDT*@ DT(DT+.DT, DT(DT+ "BgT#* U#QDU*@ DU(DU+.DU, DU(DU+ "BgT$* U$QDV*@ DV(DV+.DV, DV(DV+ "BgT%*U%QDW*@ DW(DW+.DW, DW(DW+ "B)T&*GzW,DF# DT)%=BfDF# DT)%=BfDF# DT)%=BfDF# DT)%=BfbDF# DT)%=Bf4DF# DT)%=Bf"""""B`T'ZdJD D Q? D D Q? B% $  $ BT(*S(L(T)34T&D T* {L*T+p= ?@T1DrT,*Gz \DT& SEE SPEC.  SEE SPEC.5DG# DT& B$ $T&"BT-*P%DT, SEE SPEC.  SEE SPEC.]DE#  $V"?DE#  $U"!DE#  $T""""BT. S.L. T/FF0#T1E{Go@T* %LT++S$Uv@.>"> U~ U>UFU@@Ȃ@@ U !aU"V"KDT* DT(DT+.DT, DT(DT+ "BaU#* V#KDU* DU(DU+.DU, DU(DU+ "BaU$* V$KDV* DV(DV+.DV, DV(DV+ "BaU%*V%KDW* DW(DW+.DW, DW(DW+ "BU&`U'&1 JD D Q? D D Q? B% $  $ BU(*T(L(U)U* L*U+U*DrU,*GzT,\DT& SEE SPEC.  SEE SPEC.5DG# DT& B$ $T&"BU-* T"DU, SEE SPEC.  SEE SPEC.]DE#  $V#?DE#  $U#!DE#  $T#"""BU.*GzT.L. U/FF0#U1E{Go@U. %LU++S$V`V@".". V~ V.VFVx@@H@@ V !gV"T-QDT* @ DT(DT+.DT, DT(DT+ "BgV#* U-QDU* @ DU(DU+.DU, DU(DU+ "BgV$*V-QDV* @ DV(DV+.DV, DV(DV+ "BgV%*W-QDW* @ DW(DW+.DW, DW(DW+ "B V&'V(*U(L(V)V*L*V+V*DrV,*GzU,\DT& SEE SPEC.  SEE SPEC.5DG# DT& B$ $T&"BV-*T#DV, SEE SPEC.  SEE SPEC.]DE#  $V$?DE#  $U$!DE#  $T$"""BV.*GzU1L. V/FF0#V1E{Go@V. %LV++S$W@".". W~ W.WFW@@@@W 'W(*V(L(W)W*0i L*W+U,W*DrW,*GzV,\DT& SEE SPEC.  SEE SPEC.5DG# DT& B$ $T&"BW-*T$DW, SEE SPEC.  SEE SPEC.]DE#  $V%?DE#  $U%!DE#  $T%"""BW.*GzV1L. W/FF0#W1E{Go@W. %LW++S$X@".. X~ X.XFX@@"@@X ~ X!@gX"Y"QDX*@ DX(DX+.DX, DX(DX+ "BgX#*qGY#QDY*@ DY(DY+.DY, DY(DY+ "BgX$* Y$QDZ*@ DZ(DZ+.DZ, DZ(DZ+ "BgX%*Y%QD[*@ D[(D[+.D[, D[(D[+ "B)X&*Gz[,DF# DX)%=BfDF# DX)%=BfDF# DX)%=BfDF# DX)%=BfbDF# DX)%=Bf4DF# DX)%=Bf"""""B`X'ffffY'JD D Q? D D Q? B% $  $ BX(*W(L(X)$X&D X* { L*X+p= ?@X1D rX,*Gz \DX& SEE SPEC.  SEE SPEC.5DG# DX& B$ $X&"BX-*T%DX, SEE SPEC.  SEE SPEC.]DE#  $Z"?DE#  $Y"!DE#  $X""""BX. W1L. X/FF0#X1Ep= ?@X* %LX++S$Y@".. Y~ Y.YFY±@@@@ Y !aY"Z"KDX* DX(DX+.DX, DX(DX+ "BaY#*qGZ#KDY* DY(DY+.DY, DY(DY+ "BaY$* Z$KDZ* DZ(DZ+.DZ, DZ(DZ+ "BaY%*Z%KD[* D[(D[+.D[, D[(D[+ "BY&`Y'V- JD D Q? D D Q? B% $  $ BY(*X(L(Y)Y* L*Y+UY*D rY,*GzX,\DX& SEE SPEC.  SEE SPEC.5DG# DX& B$ $X&"BY-*qGX"DY, SEE SPEC.  SEE SPEC.]DE#  $Z#?DE#  $Y#!DE#  $X#"""BY.*GzX.L. Y/FF0#Y1Ep= ?@Y. %LY++S$Z@".. Z~ Z.ZFZ@@@@ Z !gZ"X-QDX* @ DX(DX+.DX, DX(DX+ "BgZ#*qGY-QDY* @ DY(DY+.DY, DY(DY+ "BgZ$* Z-QDZ* @ DZ(DZ+.DZ, DZ(DZ+ "BgZ%*[-QD[* @ D[(D[+.D[, D[(D[+ "B Z&'Z(*(L(Z)Z* L*Z+Z*D rZ,*GzY,\DX& SEE SPEC.  SEE SPEC.5DG# DX& B$ $X&"BZ-* X#DZ, SEE SPEC.  SEE SPEC.]DE#  $Z$?DE#  $Y$!DE#  $X$"""BZ.*GzY1L. Z/FF0#Z1Ep= ?@Z. %LZ++S0[V@"">" [FFF'[(*Y(L([)[*di!L*[+`[*D r[,*GzZ,\DX& SEE SPEC.  SEE SPEC.5DG# DX& B$ $X&"B[-*X$D[, SEE SPEC.  SEE SPEC.]DE#  $Z%?DE#  $Y%!DE#  $X%"""B[.*GzZ1L. [/FF0#[1Ep= ?@[. %L[++S0\@"">"\F ~ \!@g\"]"QD\*@ D\(D\+.D\, D\(D\+ "Bg\#*]#QD]*@ D](D]+.D], D](D]+ "Bg\$*)k]$QD^*@ D^(D^+.D^, D^(D^+ "Bg\%*)k]%QD_*@ D_(D_+.D_, D_(D_+ "B)\&3*333G#DF# D\)%=BfDF# D\)%=BfDF# D\)%=BfDF# D\)%=BfbDF# D\)%=Bf4DF# D\)%=Bf"""""B`\'ffff$ JD" D$ Q? D" D$ Q? B% $$  $" B\(*[(L(\)\&D" \* {!L*\+p= ?@\1D!r\,3*333 \D\& SEE SPEC.  SEE SPEC.5DG# D\& B$ $\&"B\-*X%D\, SEE SPEC.  SEE SPEC.]DE#  $^"?DE#  $]"!DE#  $\""""B\.3333 [1L. \/FF0#\1Effff懣@\* %L\++S0]@"">"]F!a]"^"KD\* D\(D\+.D\, D\(D\+ "Ba]#*^#KD]* D](D]+.D], D](D]+ "Ba]$*)k^$KD^* D^(D^+.D^, D^(D^+ "Ba]%*)k^%KD_* D_(D_+.D_, D_(D_+ "B]&`]'\(# JD# D$ Q? D# D$ Q? B% $$  $# B](*\(L(])]*C!L*]+U]*D!r],3*333\,\D\& SEE SPEC.  SEE SPEC.5DG# D\& B$ $\&"B]-*\"D], SEE SPEC.  SEE SPEC.]DE#  $^#?DE#  $]#!DE#  $\#"""B].3*333\.L. ]/FF0#]1Effff懣@]. %L]++S0^@"">"^F!g^"\-QD\* @ D\(D\+.D\, D\(D\+ "Bg^#*]-QD]* @ D](D]+.D], D](D]+ "Bg^$*)k^-QD^* @ D^(D^+.D^, D^(D^+ "Bg^%*)k_-QD_* @ D_(D_+.D_, D_(D_+ "B ^&'^(*](L(^)^*C!L*^+^*D!r^,3*333],\D\& SEE SPEC.  SEE SPEC.5DG# D\& B$ $\&"B^-*)k\#D^, SEE SPEC.  SEE SPEC.]DE#  $^$?DE#  $]$!DE#  $\$"""B^.3*333]1L. ^/FF0#^1Effff懣@^. %L^++S0_@"">" _F'_(*E#L(_)_*Ci"L*_+_*D!r_,3*333^,\D\& SEE SPEC.  SEE SPEC.5DG# D\& B$ $\&"B_-*)k\$D_, SEE SPEC.  SEE SPEC.]DE#  $^%?DE#  $]%!DE#  $\%"""B_.3*333^1L. _/FF0#_1Effff懣@_. %L_++SD#pl`f^eE1-YOYO'y`2a2b2c2 d2e2f2 g2hh2i2j2k2l2m2n2o2p2q2 r2s2t2u2v2 w2x2y2z2{2 |2}2~220`V@.`F ~ `!@g`"b"QD`*@ D`(D`+.D`, D`(D`+ "Bg`#*b#QDa*@ Da(Da+.Da, Da(Da+ "Bg`$*a$QDb*@ Db(Db+.Db, Db(Db+ "Bg`%*b%QDc*@ Dc(Dc+.Dc, Dc(Dc+ "B)`&3* c,DF# D`)%=BfDF# D`)%=BfDF# D`)%=BfDF# D`)%=BfbDF# D`)%=Bf4DF# D`)%=Bf"""""B``'l( JD& D( Q? D& D( Q? B% $(  $& B`(* Z(L(`)3 `&D& `* {"L*`+p= ?@`1D"r`,* " \D`& SEE SPEC.  SEE SPEC.5DG# D`& B$ $`&"B`-* A,D`, SEE SPEC.  SEE SPEC.]DE#  $b"?DE#  $a"!DE#  $`""""B`.  _1L. `/FF0#`1EzGo@`* %L`++S0a@.aF!aa"a#KD`* D`(D`+.D`, D`(D`+ "Baa#*`$KDa* Da(Da+.Da, Da(Da+ "Baa$*KDb* Db(Db+.Db, Db(Db+ "Baa%*KDc* Dc(Dc+.Dc, Dc(Dc+ "Ba&`a'$JD' D( Q? D' D( Q? B% $(  $' Ba(* `(L(a)a*C|"L*a+xa*D"ra,* `,\D`& SEE SPEC.  SEE SPEC.5DG# D`& B$ $`&"Ba-* `-Da, SEE SPEC.  SEE SPEC.]DE#  $b#?DE#  $a#!DE#  $`#"""Ba.* `.L. a/FF0#a1EzGo@B0 %La++S0b@.bF!gb"`#QD`* @ D`(D`+.D`, D`(D`+ "Bgb#*?.QDa* @ Da(Da+.Da, Da(Da+ "Bgb$*`"QDb* @ Db(Db+.Db, Db(Db+ "Bgb%*a%QDc* @ Dc(Dc+.Dc, Dc(Dc+ "B b&'b(* a(L(b)b*C`"L*b+\b*D"rb,* a,\D`& SEE SPEC.  SEE SPEC.5DG# D`& B$ $`&"Bb-* a-Db, SEE SPEC.  SEE SPEC.]DE#  $b$?DE#  $a$!DE#  $`$"""Bb.* a1L. b/FF0#b1EzGo@b. %Lb++S0c@. cF'c(* b(L(c)c*CHL*c+Dc*D"rc,* b,\D`& SEE SPEC.  SEE SPEC.5DG# D`& B$ $`&"Bc-* b-Dc, SEE SPEC.  SEE SPEC.]DE#  $b%?DE#  $a%!DE#  $`%"""Bc.* b1L. c/FF0#c1EzGo@c. %Lc++S0d@.4dFFFHHHHFFFFFFFFFF10eV@"4eF?AFFFFFFHHHHFFFFFFFFFF10f@"4fF?AFFFFFFHHHHFFFFFFFFFF10g@"gF g} gw gx gy g z g!{ g"|g#F g$ g%HFFFFFFFFFF10h@"hF h~hF# h$ h%CFFFFFFFFFF10i@"iF ii@@jD i@@n D ip@j D i @@j D i!@j! D i"p@j" D i#F i$ i%FFFFFFFFFFF10jV@jF!j  D D 9jqk#DjDi  $j BHjgUTk2DjDi DjDi B$ $j BHjgfk2DjDi DjDi B$ $j Bj g4k j <jq 2LDi LDi B$ , Bj!ghk!j!<jq!!2LDi! LDi B$ , Bj"rk"j"<jq""2LDi" LDi! B$ , Bj#Fnj$!@XDO D%SZBf1DO D%SZBf"B j%FFFFFFFFFFF10k@kF!k%k DD 9kql#DkDi  $k BkgXlk<kq 2LDi LDi B$ , Bkglk<kq2LDi LDi B$ , Bk g8l j k!gll!j!k"rl"j"k#F k$ k%!k&FFFFFFFFFFF10l@lF!ll DD 9lqm#DlDi  $l Blg\mklgmkl g<m j l!gpm!j!l"rm"j"l#F l$D l%!l&FFFFFFFFFFF10m@mF!mm DD 9mqi#DmDi  $m Bmg`nkmgnkm gn j m!gn!j!m"rn"j"m#F m$ m%!m&FFFFFFFFFFF10n@nF!n%n DD ng@okngdokngokn go j n!go!j!n"ro"j"n#F n$G n%!n&FFFFFFFFFFF10oW@oF!o%o D D ogXpkogTpkogpko gp j o!gp!j!o"rp"j"o#F o$ o%!o&FFFFFFFFFFF10p@pF!pp D D pgpqkpgqkpgqkp gq j p!gq!j!p"rq"j"p#F p$H p%!p&FFFFFFFFFFF10q@qF!qq D D Hqsv2D Di D Di B$ $  Bqtskqtskq ts j q!ts!j!q"us"j"q#F q$ q%!q&FFFFFFFFFFF10r@ rF~ rn?%ro\(@@vDv{Gz?%roGz@@vDv{Gz?%r oףp= p@v Dv{Gz?%r!oףp= @@v!Dv {Gz?%r"pQ@v"Dv!{Gz?r#F r$ r%!r&FFFFFFFFFFF10s @ sF%sqzsss" -Bsgussguss gu ss!gu!ss"ru"ss#F s$ s%!s&FFFFFFFFFFF10t W@ tF%tqytVtt"LLL LL B$ ,$LL LL B$ ,LL LL B$ ,LL LL B$ ,LL LL B$ ,hLL LL B$ ,9LL LL B$ , """"""Btgxttgxtt gx tt!gx!tt"rx"tt#F t$ t%!t&"FFFFFFFFFFF10u@@ uF%uqsuuu" -Bugtuugtuu gt uu!gt!uu"rt"uu#F u$ u%!u&"FFFFFFFFFFF10v@@ vF%vv@@uvvv" -Bvw@@zvvwp@zvv w@@z vv!w@z!vv"xp@z"vv#F v$I v%!v&FFFFFFFFFFF10w @@ wF%wn{Gz?|www"Lwo\(@@|wwoGz@@|ww oףp= p@| ww!oףp= @@|!ww"pQ@|"ww#F~ w$?w%  %w%+w%%!L  , Bw&%G  &w&+w&&!L  , Bw'FFFFFFFFFFF10x%@@ xF%xq}x-xx"#L  , ,Bxgyxxgyxx gy xx!gy!xx"ry"x x#F$x%U y%w%x&% y&w&x'FFFFFFFFFFF10y@W@@ yF%yq~y-yy"#L  , ,Byg}yyg}yy g} yy!g}!yy"r}"y y#F$y% z%w%y&%( z&w&y'FFFFFFFFFFF10z/@@@@ zF%zq@@{z/zz"%LL  , ,Bzg@@~zzgp@~zz g@@~ zz!g@~!zz"rp@~"z z#F$z% {%w%z&% {&w&z'FFFFFFFFFFF10{4@@@@ {F,{y{-{{"#LL  , B{z{{z{{ zU| {{!zUD!{{"{"{{#F~ {$@{%|%w%{&%x|&w&{'FFFFFFFFFFF10|9@@@@ |F,|n{Gz?|||"L|o\(@@||oGz@@|| oףp= p@ ||!oףp= @@!||"pQ@"| |#F$|%}%w%|&%,}&w&|'FFFFFFFFFFF10}>@@@@ }F}q}-}"#L  , ,B}gr}}gr}} gr }}!gr!}}"rr"} }#F$}%~%w%}&%0~&w&}'FFFFFFFFFFF10~`W@@@@ ~F~q@@}~g@@}~gp@}~ g@@ }~!g@!}~"rp@"} ~#F$~%%w%~&%+4&w&~'FFFFFFFFFFF10H@@@@ Fq@@}g@@}gp@} g@@ }!g@!}"rp@"}#F~ $@%%w%&%8&w&'FFFFFFFFFFF1D>:ly'lllVeeee___{h2 22222 22222 2 22222 2 2222 22222222220M@@@@ Fv}w}w} wU }!wUH!}"x"} #F$%%w%&%b\&w&'FFFFFFFFFFF10R@@@@ Fn{Gz?"Lo\(@@oGz@@ oףp= p@ !oףp= @@!"pQ@" #F$%%w%&%`&w&'FFFFFFFFFFF10W@@@@ Fq@@-"#L  , ,Bg@@gp@ g@@ !g@!"rp@" #F$%%w%&%d&w&'FFFFFFFFFFF10W@@@@ Fq@@g@@gp@ g@@ !g@!"rp@"#F~ $@%%w%&%h&w&'FFFFFFFFFFF10a@@@@@ Fq@@g@@gp@ g@@ !g@!"rp@" #F$%ĸ%w%&%l&w&'FFFFFFFFFFF10f@@@@@ Fvww wU !wUL!"x" #F$%%w%&%p&w&'FFFFFFFFFFF10k@@@@@ Fn{Gz?" Lo\(@@oGz@@ oףp= p@ !oףp= @@!"pQ@" #F$%%w%&%t&w&'FFFFFFFFFFF1W@*@@@@ Fq@@g@@gp@ g@@ !g@!"rp@"#F~ $@%%w%&%x&w&'FFFFFFFFFFF1W@*@@@@ Fq@@/"%LL  , ,Bg@@gp@ g@@ !g@!"rp@" #F$%%w%&%|&w&'FFFFFFFFFFF1_ffffW@*@@@@ FqggU g !gP!"r" #F$%=%w%&%&w&'FFFFFFFFFFF1̬W@*@@@@ Fsttt  tU !tU!"ud" #F$%%w%&%&w&'FFFFFFFFFFF1,3333W@*@@@@FlmmmmmF#~ $@%%w%&%k&w&'FFFFFFFFFFF1W@*@@@@ Fn{Gz?j"Lo\(@@oGz@@ oףp= p@ !oףp= @@!"pQ@" #F$%%w%&%&w&'FFFFFFFFFFF1W@*@@@@ Fq@@/"%LL  , ,Bg@@wgp@w g@@w !g@w!"rp@w" #F$%(w%&%x%w&'FFFFFFFFFFF1_ffffW@*@@@@ Fq/"%LL  , ,Bgg gU !gUT!"r"$#FFFFFFFFFFFF1W@*@@@@ FqK"AL ,LL  , ,"BggU g !g!"rπ"$#FFFFFFFFFFFF1,3333W@*@@@@ FsxI"?L *LL  ,"Bss$ sU !sU!"sh" #F$#%+ %w%%Sy#&+ %w&&3'FFFFFFFFFFF1W@*@@@@4FFFFFFFFFFFFF1W@*@@@@ F|p= ?@L+" LL}p= ?@P+}p= ?@T+ }p= ?@X+!}p= ?@\+"~p= ?@`+$#FFFFFFFFFFFF1_ffffW@*@@@@ F[M+ED 0DD DD"BhQ+1"'L LLBhU+ hUY+!hU]+"ta+$#FFFFFFFFFFFFFFF1W@*@@@@ F[N+ED 0DD DD"BhR+hV+ h Z+!h^+"b+$#FFFFFFFFFFFFFFF1%3333W@*@@@@ F=O+'D DDBS+U(W+ [+!_+"lc+$#FFFFFFFFFFFFFFF1W@*@@@@4FFFFFFFFFFFFFFFF1W@*@@@@4F%%%%%%FFFFFFFFFFFFFFF1XffffX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1 X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1%3333X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1Xffff&X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1,X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1%33333X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1DG&lh{rhh{~ttcxIpRxxxxxxxxx22222222222222 229X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1?X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1XffffFX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1LX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1%3333SX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1YX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1_X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1QfffffX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1lX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1 ~ @<FFFFFFFFFFFFFFFFFFFFFFF1 ~ @<FFFFFFFFFFFFFFFFFFFFFFF1 ~ @<FFFFFFFFFFFFFFFFFFFFFFF1&IJ~ @&~ @************#****#++++++++++*))K . *))///L)) 1///////*))/)/)) 1**M//)) 1***//)) 1*))///L)) 1*))/)/)) 1*MM//K)) 1*)*//)) 1*))///L)) 1*))/)/)) 1*MM//)) 1*)*//)) 1*))///L)) 1*))/)/)) 1*MM//K)) 1D lxxxxxxxxx\\\JJ.................X*)/)) 1*))///L)) 1*))/)/)) 1*MM//)) 1*)*//)) 1*))///L)) 1*))/)/)) 1*MM//)) 1*)*//))) 1*))///L)) 1*))/)/)) 1*MM//)) 1**#/#/N)O**#P***Q6777**RRRRST*RRRRSTU**)**U*V*VWW)*UU##)*/XX*##)U#)U#YY**)##-#**ZJ **ZJ )))))))*IJ///////*IJ*D@l...............................************#****#++++++++++*))K . *))///L)) 1///////*))/)/)) 1**M//)) 1***//)) 1*))///L)) 1*))/)/)) 1*MM//K)) 1*)*//)) 1*))///L)) 1*))/)/)) 1*MM//)) 1*)*//)) 1*))///L))--1*))/)/)) 1*MM//K)) 1*)/)) 1*h..................R <: (  <~ < <1 XPP?  [ p ]4@1  UQojy-IVo L<MTON TYPE, ENGLISH OR METRIC, USED TO DETERMINE THE NUMBER OF LOTS REQUIRED. <K L~~ < <H1 XPP?  [ s]4@H1T  0(Bıh} < The average (Gmm) Maximum specific gravity value used to calculate the percentage density for the lot shall be the average value obtained from the maximum gravity results from production tests taken during that days paving. If only one or two maximum specific gravity values were obtained that day, then the moving average value (at that test point) shall be used. If three or more maximum specific gravity values are obtained that day, then the average of those tests alone shall be used as indicated above.<e  ~~ < <1 XPP?  5]4@1D  -עMm1TS5 D<E MIX TYPES LV = LOW VOLUME, 92% REQ'D DENSITY, 3% AIR VOIDS LV-R = LOW VOLUME"REDUCED"DENSITY TO 91%, 3% AIR VOIDS MV = MEDIUM VOLUME,92% REQ'D DENSITY, 3.5% AIR VOIDS MV-R = MEDIUM VOLUME"REDUCED"DENSITY TO 91%, 3.5% AIR VOIDS SPWE = SUPERPAVE WEAR, 92% REQ'D DENSITY, 4% AIR VOIDS SPWE-R = WEAR"REDUCED"DENSITY TO 91%, 4% AIR VOIDS SPNW = SUPERPAVE NONWEAR, 93% REQ'D DENSITY, 3% AIR VOIDS SPNW-R = NONWEAR DENSITY"REDUCED" TO 92%, 3% AIR VOIDS SPSHLD-3 = SUPERPAVE SHOULDERS @ 3% VOID, 93% DENSITY SPSHLDR-3 = SUPERPAVE SHOULDERS @ 3% VOIDS, REDUCED TO 92% DENSITY. SPSHLD-4 = SUPERPAVE SHOULDERS @ 4% VOIDS, 92% DENSITY SPSHLDR-4 = SUPERPAVE SHOULDERS @ 4% VOIDS, REDUCED TO 91% DENSITY.<`hm o+B7!ZX"]:,! P -4D#7L!}#?w#:$#? ZD~~  < <1 XPP?  PC &]4 @1  kϹ.5uE瞍ť <IF THE COMPANION CORE DEVIATES BEYOND THE ALLOWABLE TOLERANCE OF .030, THE COMPANION CORE WILL BE USED IN PLACE OF THE CONTRACTORS CORE. YOU MUST ENTER THE COMPANION CORE #. <O ~~  < <t1 XPP?  JC &]4 @t1 A|O6  <% Density is calculated using the average bulk SpG divided by the Max SpG. The correct Max SpG is critical in calculating incentive/disincentives.<  ~~  < <؃1 XPP? [C ]4 @؃1 ܚAI*r T<UIndividual air voids taken from the table above, review entrys and delete old data. <S T `~~ < <      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsuvwxyz{|}~<1 XPP? C<&]4@<1 R,D(- <Pay Factor is determined by comparing the % density and air void used to the required density and minimum air void listed above. Review the mix type entry above. < @~~ < <1 XPP? rC:f]4@1 FgtAP.,aif 0(<1ENTER BEGINNING LOT # FOR THAT DAYS PRODUCTION. <(.0~~ < <1 XPP? r]4@1 žx~\Cum <COMPANION CORE # <o ~~ < <h1 XPP? (+]4@h1T m$OYL '<(SEE PROPOSAL FOR MIX DESIGNATION TYPE. <& '~~ < <̅1 XPP? ' & ]4@̅1D Jئ[@o9# 4<5# OF LOTS REQUIRED IS BASED ON THE MAX DENSITY TONS.<F4~~ < <01 XPP?  l3]4@01 {X$.wIµJKI~ o<pThe average of the two bulk Specific Gravities, this is used with the Max Density to calculated the % density. <cn o `H~~ $< <1 XPP? @2]4$@1 D]iM]V" .</Insert sample number from test summary sheet. <- .Vlb~~ %< <1 XPP? @ Z]4%@1 )? ?Edx U<VThe tons produced from the start of the days production to when the sample is taken. <T U~~ &< <\1 XPP? @ ]4&@\1 Q8QaL/Ո1_$ [<\MAX DENSITY TONS IS CALCULATED BY A RATIO BETWEEN THE TONS PAVED AND THE MAX DENSITY TONS. <>Z [~~ 1< <1 XPP?  ]41@1 $.~!H2? 5<6THIS PROGRAM HAS BEEN DEVELOPED FOR THE RECORD KEEPING OF BITUMINOUS DENSITYS. THIS WORKSHEET COVERS THE INCENTIVE AND DISINCENTIVES IN REGARDS TO SPEC 2350 AND 2360. DATA ENTRY IS ALLOWED ONLY IN THE HIGHLITED BOXES. REMEMBER TO DELETE ANY NON CURRENT DATA. DOLLAR TOTALS ARE DEPENDANT ON GOOD DATA ENTRYS. <4 5YSH~~ 3< <$1 XPP?  Z5]43@$1 q1#z@F66] <LEAVE THIS FIELD BLANK. IF YOU HAVE A DIFFERENT AMOUNT OF LOTS THAN THE PROGRAM ALLOWS FOR, INSERT THAT NUMBER IN THIS FIELD.<#xx 5< 61CC@ 2&3 ],5@1Tn`19 $(<)Copy Data From This File to Another File<(xx 6< 61CC@ 2 3],6@1n419 $)<*Paste Data to This File from Another File<)~~ :< <1 XPP? Z ]4:@1 d N{ty J(<KSQUARE YARD INCH PROJECTS ONLY. Insert the required mat thickness, (ie, 1,1.5, 2, 2.5, etc) Be sure the bid price reflects the square yard inch bid price. Delete any number to convert the worksheet to a tonnage worksheet. Incentive/Disincentives are based on the average core density for that day's production and the bid price.<(#Jt~~ >< <\1 XPP?  Z: &]4>@\1$ 9Fj@N  6<7Taken from the project proposal, review for accuracy. </5 6~~ ?< <1 XPP? Z ]4?@1 PUWnaGS e<fTotal tons or sq yds delivered to the project for that days production, excluding any waste mixture. <0d e~~ @< <$1 XPP? Z ]4@@$1d \ pnE1ȸϣp W<XThe total tons or sq yds that are included in the incentive/disincentive calculations. <V W~~ A< <1 XPP? Z M]4A@1T i>rfYHB̀ i <jA ratio between the total tons and the max density (incentive) tons. This is needed for the calculations.< D E#ih0~~ D< <1 XPP?  6]4D@1 qBNP  `<aINDIVIDUAL AIR VOIDS IS TAKEN FROM THE SUMMARY SHEET, REVIEW TOLERANCE AND RETEST REQUIREMENTS. <h_ `1Default:Default$Default?Default%Default >Default@Default Default ADefault &Default RONALD G BUMANNA 3Boer1Dan  DDefaultn MISa Defaultn MISa Defaultn DefaultnDefaultnMISaMISa Defaultn+MISa>@dd2F   11 --..++-- .. ++ ++ ,,-.    ''&&!! %%$$##""** ++ ))((   AA**** ++******++7( ( 8 ?   LL?   LL?   LL""""?""   LL&&&&?&&   LL;$  qD    ?     D/  %kv$$ /  %gi$$/  -?@ /  %67::  Sheet1 0@ X6h ;hgg>QLTa]eqnv )  dMbP?_*+%3&'()M\\MRL2KSPRINT\PAVE-ENG?d,,Letter.HP LaserJet 4000 Series PCL 627xe.@?v(ł!~ uy ,}4!tɢ6v^Kx;LK#1$'R1M\\ G_  ap3}$%y+z @؄Tqp;pL`PVf\;u&n7 Uʹ-A ~iEDBƒ$ ϢoO.0 vCSr6h:w5xASMvG/6Y_C^+ <F` D)w."%tC_(܆#JQiM4XcC;\xYC@dr9& $+2Q8FpN9Zj"W,,clU} } } } I }  $ } I } } } } } } I} m} I} } } } } 0} } }  } } I} } !!} ""$} ##$ } $$$} %%} &&} ''m} (( } ))} **I } ++m} ,, } --I } ..} //I} 00m } 11} 23$ } 4$ Column R,64,@,J@, ,K@,h@,,@,x@,,@,,@ ,,@ ,,@ ,@ ,,& ,,@,,@,,@$,@$,@$,@$@$@$@ $,@$,0$,0$,@ $,@$,@$,@$,@ $,@$,@ ~  @0  " h,iiiiiiiiiiiij      b"ccccccccccccd    0".      0f"    ++ ,,))))))L   00~ 00 $$$$$$$$$$$$$+ * *kk ! !  + * c'D%r}$%BfGYRATORY DESIGN **MUXX0000 $$$$$$$$$$$$$+.BBDDDDDMU  0000 $$$$$$$$$$$$$+ B B~ SA@ B BCMC  7D "Square Yard Inch ProjectBCCCCMU  0000 $$$$$$$$$$$$$+ BB IYB CD TOTAL TONS PAVED =TOTAL AREA PAVED =BTOTAL TONS PAVED =B~ C@@    E F M#/D TOTAL TONS PAVEDB GMU  0000 $$$$$$$$$$$$$+  B B:  *M $DH  $J $PB[ B ED MAX. DENSITY TONS =MAX. DENSITY AREA =BMAX. DENSITY TONS = B~ C@@ (   ?wD  ]DV D%ZaBf1DV D%ZaBf"" $ B  ~ @ MU   0000 $$$$$$$$$$$$$+  = =   B B! &? D De   OD ! TONS PER LOT =  SQ YARDS PER LOT =B TONS PER LOT = ! &@@f1 D D  MU   0000 $$$$$$$$$$$$$+ L < 6D ! Max Density Tons = B > @  (D D D B    0000  " - .         '  T (  Mu N          : @@ $D  $ $ B  0000  -.Y%CD  .D   $ $ @"B%U KL 6L D LLL"B%%%%  %  % = %C'D  D D B    0000 RS'-1 'L LD B''''' ' '  '    ?@@V)D  $ D D B   -- "#=$D V'DwDw  Dw B MvNRRRRRRRRR    -- "# 77   -- "# 77   -- "#  B B%@- D? B B+ @G.D%CN Bf  B B+ V@H.D%CN Bf   F@@p0D  DD DD B               B  B   6    *    +  +  !  O"  OP FA@0D  $DDD B  - ~ ?%?D?  W T'AD ,DD  $S' $"BK, S)5D  #DD d"B7P !D  $S*Bׄ  +-!L  ,=#Ba fH  KD 6D DDD "B - $ ,- "L   ,=$B \ J  FD 1D  BID $$ ?? $S-"B  J  f %333333?D?  W AD ,DD  $T' $"B7!D  $T*B   fL S1 U- KD 6L LDD "B -|    \ Jp  FD 1D  BID $$ ?? $T-"B  J 50H*D  B - #   0 -D  DD DD B$DD DD B$DD DD B$COMP. CORE USEDGDD DD B$COMP. CORE USED  """"B 7!D  $U*B  fT T1  -x    \ Jt  FD 1D  BID $$ ?? $U-"B  J -) 622?a )D %BBK 5D  #DD"B?*X O.)D  = Ave.Gmb.B = Ave.Gmb.7!D  $V*B  fp U1  3    \ Hx  FD 1D  BID $$ ?? $V-"B  HP -2; %D  DBA+D D?B  W AD ,DD  $W' $"BK,f W)5D  #DD d"B? )D @$W*@B״   t V1  -3    y J  cD  ND 1D  BID $$ ?? $W-""B  J f2 A3+D D?B  W= AD ,DD  $X' $"B7@ !D  $X*BQ   f W1  -3   y J̰  cD  ND 1D  BID $$ ?? $X-""B  J f29J8 #D COMPB   0 D  DD DD B$DD DD B$DD DD B$COMP. CORE USEDGDD DD B$COMP. CORE USED  """"B -7 !D  $Y*B   f   -    y J  cD  ND 1D  BID $$ ?? $Y-""B  J - 622?a !)D %BBK 5D  #DD"B?*d )D  = Ave.Gmb.B7 !D  $Z*B   f {  3 !   y H  cD  ND 1D  BID $$ ?? $Z-""B  HP -1; "%D  DBA+D D?B  W AD ,DD   $[' $"BK, [)5D  #D!D d"B7 !D  $[*B   f q  -    y JE  cD  ND 1D  BID $$ ?? $[-""B  J -1 A3"+D D?B  W !AD ,DD   $\' $"B7$ !D  $\*B3(   f,   -0    y J4  cD  ND 1D  BID $$ ?? $\-""B  J f1DH.lr>dJh}z`.4|nnOXm&( ,@!,@ ",@#,@$,@%,@ &,@',@(,@),@ *,@+,@,,@-,@ ./ 0-1-x2-hG3-hG4-hG5-hG6-x 7-@ 8-` 9-`:-`;-`<-`=-;`>- ?-w   : J $D  COMPB    0D D   D D D D B$D D D D B$D D D D B$COMP. CORE USEDGD D D D B$COMP. CORE USED  """"B  7 H  !D  $]*B L   fP   -T    y JX ! cD  ND  1D  BID $$ ?? $]-""B J -1 !622?!a\ %)D % BB!K!` 5D  #DD"B?!* )D  = Ave.Gmb.B7!| !!D  $^*B! ! ! f   ! 3 %   y! H " cD  ND! 1D  BID $$ ?? $^-""B ! HP !f1";" &%D  DBA"#+D" D"?B " W"~ #AD" ,D"D$  $_' $""BK",3 _)5D"  #D%D d"B7" "!D"  $_*B"ל " " f ! " - R1  y" JE # cD  ND" 1D  BID $$ ?? $_-""B " J "-1 #A#3&+D" D"?B # W#Z %AD# ,D#D$  $`' $#"B#7# #!D#  $`*B# # # f " # -    y# J $ cD  ND# 1D  BID $$ ?? $`-""B # J #-1$:$JP  $D"  COMPB $  $0  D$  D$D" D$D" B$D$D# D$D# B$D$D" D$D" B$COMP. CORE USEDGD$D# D$D# B$COMP. CORE USED  """"B $57$ $!D#  $a*B$ $ $ f # $ - #   y$ J % cD  ND$ 1D  BID $$ ?? $a-""B $ J $f1 %622?%a ))D" %"$BB%K%l "5D"  #D"D#"B?%*| !)D"  = Ave.Gmb.B7% %!D#  $b*B% % % f $ % 3 )   y% H & cD  ND% 1D  BID $$ ?? $b-""B % HP %-1&;& *%D  D"BA&'+D& D&?B & W& 'AD& ,D&D(  $c' $&"BK&, c)5D&  #D)D d"B7&$ &!D&  $c*B&( & & f, % & -0 $   y& JE4 ' cD  ND& 1D  BID $$ ?? $c-""B & J &11 'A'3*+D& D&?B ' W'Z8 )AD' ,D'D(  $d' $'"B'7'< '!D'  $d*B'@ ' ' fD & ' -H &   y' JL ( cD  ND' 1D  BID $$ ?? $d-""B ' J '11(:(J $$D&  COMPB ( (0\ $D(  D(D& D(D& B$D(D' D(D' B$yD(D& D(D& B$ COMP.GD(D' D(D' B$COMP. CORE USED  """"B (7(` (!D'  $e*B(d ( ( fh ' ( -l '   y( Jp ) cD  ND( 1D  BID $$ ?? $e-""B ( J (11 )622?)at -)D& %&(BB)K)x &5D&  #D&D'"B?)* %)D&  = Ave.Gmb.B7)Ӕ )!D'  $f*B) ) ) f ( ) 3 -   y) H * cD  ND) 1D  BID $$ ?? $f-""B ) HP )11*;* 3%D  D&BA*++D* D*?B * W*~ +AD* ,D*D,  $g' $*"BK*, g)5D*  #D-D d"B7* *!D*  $g*B*״ * * f ) * -׼ (   y* J + cD  ND* 1D  BID $$ ?? $g-""B * J *11 +A+3 +D* D*?B + W+l -AD* ,D+D,  $h' $+"B+7+ +!D+  $h*B+ + + f * + - *   y+ J , cD  ND+ 1D  BID $$ ?? $h-""B + J +11,:,J ($D*  COMPB ,  ,0 (D,  D,D* D,D* B$D,D+ D,D+ B$D,D* D,D* B$COMP. CORE USEDGD,D+ D,D+ B$COMP. CORE USED  """"B ,7, ,!D+  $i*B, , , f + , - +   y, J / cD  ND, 1D  BID $$ ?? $i-""B , J ,11 -6?-a W')D* %*,BB-K- *5D*  #D*D+"B?-*8))D*  = Ave.Gmb.B7- -!D+  $j*B-$ - - f( , - 3, Q1  y- H0 F.cD  ND- 1D  BID $$ ?? $j-""B - HP -11.7 .= .=@@ .=.=?? . e&. ffg ../7 /= /=aa /B*/B?? / <H/ 1j12D  BID $$ ??%, pB/ 12 //07 0=0=B0_"~J0,$$$!$%$)$-B333333O@0_ 0=0=%0`voD0? 0`8 Q0 U4 ;DA no $Weighted Average Air VoidsBWeighted Average Air Voids0 UUV 00,1799999999999TTT 112E 2,*2YZZZZZZZZZ[NWW 22H3E3P&DC*3\]]]]]]]]]^N 33H.4E\]]]]]]]]]^N 44H65EF#$$$$$$$$$%eVIIIII5H66?@@@@@@@@@@@@OW6.73333337&0000000,.8i///3333338&BBiijii, 99 93333339&BBBBBkB, :: ::&BBBBBkB, ;.;P;------;&BBBBBkB, <.<<)--<&BBBBBkB, =.=777=)-=&BBBBBkB, >.> >>&BBBBBkB, ?.?:; ??&BBkBBkB,D+l((((iH^pJDDJJ``nnnf@2  A2  B2 C2  D2 E2 F2 G2 H2 I2 J2 K2 L2 M2 N2  O2 P2 Q2 R2  S2T2 U2V2 W2X2 Y2Z2 [2\2]2^2 _2@ @*@\@\@\@p@p@p@4@FFFFFFFFFFFCCCCCDCFFFFF1 AA A A  A-A@ A. A/ A0~ A@4AFFFFFFFFFFFCCCCCDCFFFFF1B B B1 B2 B B3B B4 BF B5 B6 B7 B 8 B!9&B"FFFF???????FFFFF1C C CC #DDDDDDDDDDDDD D D D D D DDDDDDD D D BC C C CC C $C@W@@@?!&C"FFFFFFFFFFFFFFFF1~ DU@ D D D D D DD DD$D@V@@@?!D"FF+ D,?<D-?D.?@@M0DD/~ D0ED1<P'DP& E E<E?@@@@@@ @"@ ~ E@ E E E E E EE E$E@W@@@@!E"FF+ E,??E-?E.??&D E/IE0A@M(3DM' DD.?DM'D B9E1Cp#DP'  $P& $P'B F F8F8)F3333G #DB0F3333F#DDB6F7AF #DDDB<Fv/F&#DDDDBBF(F,#DDDDDBHF?^IF2#DDDDDDBNF 7AF8#DDDDDDD BTF v/F >#DDDDDDD D BZF `F D#DDDDDDD D D  B~ F@ F F F F F FF FG$F@V@@@@!F"FF+ F,?AF-?F.C@@q$DF/IF0A@M)3DM( DD.?DM(D BdF1<\*NDP( DP' B$ $P&*DP(  $P' $P("B GG6GH D  B6GG D  BGGG*GG  L  BGGGGGGGGGG GGG G GG G G~ G @ G G G G G GG G$G@@W@@@?! G"B~ G#?G$FF-G.F @\,DG/IG0A@U*3DM) DD.?DM)D B9G1<`*#DP)  $P( $P)B HH$HN%GG d~ H@ H H H H H HH HH$H@W@@??! H"?E~ H#?H$)7H*l  !D  $BH+9H,A@\(#D  $ $H*BH-FH.V@N,D H/IH0A@M-3DM* DD.?DM*D B9H1Ha*#DP*  $P) $P*B I~ IU@ I I I I I II I$I@@W@@@?! I"F~ I#@I$FFFFFFFFFFFF/II0A@P*3DM+ DD.?DM+D B9I1Hd*#DP+  $P* $P+B J.J3*3330 DH%EF Be~ J@ J J J J J JJ J$J@W@@??!"J"FFFFFFF/IJ0A@P+3DM, DD.?DM,D B9J1He*#DP,  $P+ $P,B~ K!@ K K K K K KK K$K @W@@@@!"K"FFEEAF/IK0A@M.3DM- DD.?DM-D B9K1Hh*#DP-  $P, $P-B<L?@@@@@@ @"@ ~ L&@ L L L L L LL L$L @V@@@@! L"F9+L#?@]#D%CN!Bf L$: L%=;<L&>?>@>@>@>@>@@> @"@.L/FIL0A@D.3DM. DD.?DM.D B9L1Hi*#DP.  $P- $P.BMJDMMMMM LMMMMMMMMMMMMM MMM M MM M M~ M+@ M M M M M MM M$M @W@@@@! M"F+M#?@D%CN!Bf M$= M%=>M&>,M&MP&.$LM'>E0M&M(>F0M&M)>G0M&M*>H0M&M+>I0M&M,>J0M&M->K0M&M.>L0M&M/F)M0A@W*@DD.?M1HNNN*NN L  BNNNNNNNNNNNNNN NN N NN N NN ON~ NV@ N N N N N NN NI$N @V@@@@! N"FJ+N#?@],D%CN!BfN$ N%=@N&>N-M&N'>N(M&N(>N&M&N)>N.M&N*>M&M&N+>N*M&N,>N+M&N->N)M&N.> M& N/FAA1$OP%NN d~ O5@ O O O O O O OFE OKOFFFF?$ O%=O&>N'M&O'>O&M&O(>O'M&O)>O(M&O*>O)M&O+>O*M&O,>O+M&O->O,M&O.>O-M& O/FAA1.P* DO%LM Be~ P:@ P P P P P P PFE PLPFFFFF$ P%=CP&@D1M&P'@E1M&P(@F1M&P)@G1M&P*@H1M&P+@I1M&P,@J1M&P-@K1M&P.@L1M& P/FAA1~ Q?@ Q Q Q Q Q QQF Q.QFFFFFF?EEFFA0Q1G@@" DD.~ RD@ R R R R R RRF RR??FF R!FR"FFAAA' R(?M R)? R*? R+? R,?! R-CN R.FFF0R1E@@E.DD.S V@> S S S S SSFF ~ S!?gS"S-QDS*@ DS(DS+.DS, DS(DS+ "BgS#*T-QDT*@ DT(DT+.DT, DT(DT+ "BgS$*U-QDU*@ DU(DU+.DU, DU(DU+ "BgS%*V-QDV*@ DV(DV+.DV, DV(DV+ "B)S&*U,DM# DS)%DBfDM# DS)%DBfDM# DS)%DBfDM# DS)%DBfbDM# DS)%DBf4DM# DS)%DBf"""""B`S'JDDQ? DDQ? B% $ $BS(*T"S(<Sj((2L SEE SPEC. 0LDH,BS) S&DqS*[DS+ FDA no #DS1?%DM01Bf $C"BS+p= ?@DrS,*S.\DS& SEE SPEC.  SEE SPEC.5DN# DS& B$ $S&"BS-**DS, SEE SPEC.  SEE SPEC.]DL#  $U"?DL#  $T"!DL#  $S""""BS. S(S.\Sj..RLDG. L SEE SPEC.L A&B$B$ low voids ,B S/FF0S1Ep= ?@S*DS+TN@> T T T T TTFFF!aT"U"KDS* DS(DS+.DS, DS(DS+ "BaT#*U#KDT* DT(DT+.DT, DT(DT+ "BaT$*U$KDU* DU(DU+.DU, DU(DU+ "BaT%*U%KDV* DV(DV+.DV, DV(DV+ "BT&`T'JDDQ? DDQ? B% $ $BT(*T#S(T)T*T*eTj**[L FDA no #L?%DM01Bf $C"BT+ DrT,*T.\DS& SEE SPEC.  SEE SPEC.5DN# DS& B$ $S&"BT-*S,DT, SEE SPEC.  SEE SPEC.]DL#  $U#?DL#  $T#!DL#  $S#"""BT.*T(S. T/FF0#T1Ep= ?@T* %ST++US@> U U U U UUF UO~ U@U U U !gU"S"QDS* @ DS(DS+.DS, DS(DS+ "BgU#*S#QDT* @ DT(DT+.DT, DT(DT+ "BgU$*S$QDU* @ DU(DU+.DU, DU(DU+ "BgU%*S%QDV* @ DV(DV+.DV, DV(DV+ "B U&'U(*T$S(U)U*T*U+DrU,*T,\DS& SEE SPEC.  SEE SPEC.5DN# DS& B$ $S&"BU-*0DU, SEE SPEC.  SEE SPEC.]DL#  $U$?DL#  $T$!DL#  $S$"""BU.*U(S. U/FF0#U1Ep= ?@M' %SU++VX@> V V V V VVF V4P~ V?V+VF@ D %UVBfV 'V(*T%S(V)V*T*V+~DrV,*V.\DS& SEE SPEC.  SEE SPEC.5DN# DS& B$ $S&"BV-*U.DV, SEE SPEC.  SEE SPEC.]DL#  $U%?DL#  $T%!DL#  $S%"""BV.*V(S. V/FF0#V1Ep= ?@V* %SV++SW]@> W W W W WWFFF ~ W!@gW"W-QDW*@ DW(DW+.DW, DW(DW+ "BgW#*lX-QDX*@ DX(DX+.DX, DX(DX+ "BgW$*Y-QDY*@ DY(DY+.DY, DY(DY+ "BgW%*Z-QDZ*@ DZ(DZ+.DZ, DZ(DZ+ "B)W&3* Z,DM# DW)%DBfDM# DW)%DBfDM# DW)%DBfDM# DW)%DBfbDM# DW)%DBf4DM# DW)%DBf"""""B`W'X'JDDQ? DDQ? B% $ $BW(* X"S(W)f W&DW* T*W+p= ?@X1DrW,3* W.\DW& SEE SPEC.  SEE SPEC.5DN# DW& B$ $W&"BW-* V,DW, SEE SPEC.  SEE SPEC.]DL#  $Y"?DL#  $X"!DL#  $W""""BW.3  W(S. W/FF0#W1Ep= ?@M* %SW++S$X@V@.>>> X~ X>XFFF!aX"Y"KDW* DW(DW+.DW, DW(DW+ "BaX#*lY#KDX* DX(DX+.DX, DX(DX+ "BaX$*Y$KDY* DY(DY+.DY, DY(DY+ "BaX%*Y%KDZ* DZ(DZ+.DZ, DZ(DZ+ "BX&`X'['JDDQ? DDQ? B% $ $BX(* X#S(X)X*< T*X+tzDrX,3* X.\DW& SEE SPEC.  SEE SPEC.5DN# DW& B$ $W&"BX-* W,DX, SEE SPEC.  SEE SPEC.]DL#  $Y#?DL#  $X#!DL#  $W#"""BX.3* X(S. X/FF0#X1Ep= ?@X* %SX++S$Yg@.>>> Y~ Y>YF YQ YR Y Y!gY"W"QDW* @ DW(DW+.DW, DW(DW+ "BgY#*lW#QDX* @ DX(DX+.DX, DX(DX+ "BgY$*W$QDY* @ DY(DY+.DY, DY(DY+ "BgY%*W%QDZ* @ DZ(DZ+.DZ, DZ(DZ+ "B Y&'Y(*X$S(Y)Y*T*Y+Y*DrY,3*Y.\DW& SEE SPEC.  SEE SPEC.5DN# DW& B$ $W&"BY-*X,DY, SEE SPEC.  SEE SPEC.]DL#  $Y$?DL#  $X$!DL#  $W$"""BY.3*Y(S. Y/FF0#Y1Ep= ?@Y, %SY++S$Zl@.>.> Z~ Z>ZFZ$@$@Z 'Z(*X%S(Z)Z*XT*Z+\Z*DrZ,3*Z.\DW& SEE SPEC.  SEE SPEC.5DN# DW& B$ $W&"BZ-*S'DZ, SEE SPEC.  SEE SPEC.]DL#  $Y%?DL#  $X%!DL#  $W%"""BZ.3*Z(S. Z/FF0#Z1Ep= ?@ %SZ++S$[q@.>.> [~ [>[F[????[ ~ [!@g["[-QD[*@ D[(D[+.D[, D[(D[+ "Bg[#*\-QD\*@ D\(D\+.D\, D\(D\+ "Bg[$*]-QD]*@ D](D]+.D], D](D]+ "Bg[%*^-QD^*@ D^(D^+.D^, D^(D^+ "B)[&*GzN#DM# D[)%DBfDM# D[)%DBfDM# D[)%DBfDM# D[)%DBfbDM# D[)%DBf4DM# D[)%DBf"""""B`['\'JDD Q? DD Q? B% $  $B[(*\"S([)[&D[* T*[+p= ?@[1Dr[,*Gz[.\D[& SEE SPEC.  SEE SPEC.5DN# D[& B$ $[&"B[-*Z1D[, SEE SPEC.  SEE SPEC.]DL#  $]"?DL#  $\"!DL#  $[""""B[.Gz [(S. [/FF0#[1E{Go@[* %S[++S$\v@.>"> \~ \>\F\@@Ȃ@@ \ !a\"]"KD[* D[(D[+.D[, D[(D[+ "Ba\#*L#KD\* D\(D\+.D\, D\(D\+ "Ba\$*]$KD]* D](D]+.D], D](D]+ "Ba\%*]%KD^* D^(D^+.D^, D^(D^+ "B\&`\'_'JDD Q? DD Q? B% $  $B\(*\#S(\)\*f T*\+ \1Dr\,*Gz\.\D[& SEE SPEC.  SEE SPEC.5DN# D[& B$ $[&"B\-*[,D\, SEE SPEC.  SEE SPEC.]DL#  $]#?DL#  $\#!DL#  $[#"""B\.*GzH,S. \/FF0#\1E{Go@P( %S\++S$]`V@".". ]~ ].]F]x@@H@@ ] !g]"["QD[* @ D[(D[+.D[, D[(D[+ "Bg]#*[#QD\* @ D\(D\+.D\, D\(D\+ "Bg]$*[$QD]* @ D](D]+.D], D](D]+ "Bg]%*[%QD^* @ D^(D^+.D^, D^(D^+ "B ]&'](*\$S(])]*x T*]+t ]1Dr],*Gz\D[& SEE SPEC.  SEE SPEC.5DN# D[& B$ $[&"B]-*Y1D], SEE SPEC.  SEE SPEC.]DL#  $]$?DL#  $\$!DL#  $[$"""B].*Gz](S. ]/FF0#]1E{Go@]* %S]++S$^@".". ^~ ^.^F^@@@@^ '^(*\%S(^)^*p T*^+^*Dr^,*Gz^.\D[& SEE SPEC.  SEE SPEC.5DN# D[& B$ $[&"B^-*].D^, SEE SPEC.  SEE SPEC.]DL#  $]%?DL#  $\%!DL#  $[%"""B^.*Gz^(S. ^/FF0#^1E{Go@^, %S^++S$_@".. _~ _._F_@@"@@_ ~ _!@g_"_-QD_*@ D_(D_+.D_, D_(D_+ "Bg_#*`-QD`*@ D`(D`+.D`, D`(D`+ "Bg_$*a-QDa*@ Da(Da+.Da, Da(Da+ "Bg_%*b-QDb*@ Db(Db+.Db, Db(Db+ "B)_&*Gzb,DM# D_)%DBfDM# D_)%DBfDM# D_)%DBfDM# D_)%DBfbDM# D_)%DBf4DM# D_)%DBf"""""B`_'`'JD"D$Q? D"D$Q? B% $$ $"B_(*`"S(_)3_&D"_* T*_+p= ?@_1D r_,*Gz_.\D_& SEE SPEC.  SEE SPEC.5DN# D_& B$ $_&"B_-*^1D_, SEE SPEC.  SEE SPEC.]DL#  $a"?DL#  $`"!DL#  $_""""B_.Gz _(S. _/FF0#_1Ep= ?@_* %S_++SD^l.Q"SxRc31-YOY`2a2 b2 c2d2e2f2 g2h2i2j2 k2l2m2 n2ho2p2q2r2s2t2u2v2w2x2 y2z2{2|2}2 ~22$`@".. `~ `.`F`±@@@@ ` !a`"a"KD_* D_(D_+.D_, D_(D_+ "Ba`#*a#KD`* D`(D`+.D`, D`(D`+ "Ba`$*a$KDa* Da(Da+.Da, Da(Da+ "Ba`%*a%KDb* Db(Db+.Db, Db(Db+ "B`&``'d'JD#D$Q? D#D$Q? B% $$ $#B`(*`#S(`)`*  T*`+ `1D r`,*Gz`.\D_& SEE SPEC.  SEE SPEC.5DN# D_& B$ $_&"B`-*_,D`, SEE SPEC.  SEE SPEC.]DL#  $a#?DL#  $`#!DL#  $_#"""B`.*Gz`(S. `/FF0#`1Ep= ?@P) %S`++S$a@".. a~ a.aFa@@@@ a !ga"_"QD_* @ D_(D_+.D_, D_(D_+ "Bga#*_#QD`* @ D`(D`+.D`, D`(D`+ "Bga$*_$QDa* @ Da(Da+.Da, Da(Da+ "Bga%*_%QDb* @ Db(Db+.Db, Db(Db+ "B a&'a(*`$S(a)a*  T*a+ a1D ra,*Gza.\D_& SEE SPEC.  SEE SPEC.5DN# D_& B$ $_&"Ba-*`,Da, SEE SPEC.  SEE SPEC.]DL#  $a$?DL#  $`$!DL#  $_$"""Ba.*Gza(S. a/FF0#a1Ep= ?@M+ %Sa++S0bV@"">" bFFF'b(*`%S(b)b*p!T*b+b1D rb,*Gzb.\D_& SEE SPEC.  SEE SPEC.5DN# D_& B$ $_&"Bb-*a,Db, SEE SPEC.  SEE SPEC.]DL#  $a%?DL#  $`%!DL#  $_%"""Bb.*Gzb(S. b/FF0#b1Ep= ?@b* %Sb++S0c@"">"cF ~ c!@gc"c-QDc*@ Dc(Dc+.Dc, Dc(Dc+ "Bgc#*d-QDd*@ Dd(Dd+.Dd, Dd(Dd+ "Bgc$*e-QDe*@ De(De+.De, De(De+ "Bgc%*.f-QDf*@ Df(Df+.Df, Df(Df+ "B)c&*Gzf,DM# Dc)%DBfDM# Dc)%DBfDM# Dc)%DBfDM# Dc)%DBfbDM# Dc)%DBf4DM# Dc)%DBf"""""B`c'g'JD&D(Q? D&D(Q? B% $( $&Bc(*d"S(c)c&D&c* !T*c+p= ?@c1D!rc,*Gzc.\Dc& SEE SPEC.  SEE SPEC.5DN# Dc& B$ $c&"Bc-*"Dc, SEE SPEC.  SEE SPEC.]DL#  $e"?DL#  $d"!DL#  $c""""Bc.Gz c(S. c/FF0#c1Effff懣@c* %Sc++S0d@"">"dF!ad"e"KDc* Dc(Dc+.Dc, Dc(Dc+ "Bad#*e#KDd* Dd(Dd+.Dd, Dd(Dd+ "Bad$*e$KDe* De(De+.De, De(De+ "Bad%*.e%KDf* Df(Df+.Df, Df(Df+ "Bd&`d'h'JD'D(Q? D'D(Q? B% $( $'Bd(*d#S(d)d*X!T*d+d1D!rd,*Gzd.\Dc& SEE SPEC.  SEE SPEC.5DN# Dc& B$ $c&"Bd-*c,Dd, SEE SPEC.  SEE SPEC.]DL#  $e#?DL#  $d#!DL#  $c#"""Bd.*Gzd(S. d/FF0#d1Effff懣@M, %Sd++S0e@"">"eF!ge"c"QDc* @ Dc(Dc+.Dc, Dc(Dc+ "Bge#*c#QDd* @ Dd(Dd+.Dd, Dd(Dd+ "Bge$*c$QDe* @ De(De+.De, De(De+ "Bge%*.c%QDf* @ Df(Df+.Df, Df(Df+ "B e&'e(*d$S(e)e* !T*e+e1D!re,*Gze.\Dc& SEE SPEC.  SEE SPEC.5DN# Dc& B$ $c&"Be-*d,De, SEE SPEC.  SEE SPEC.]DL#  $e$?DL#  $d$!DL#  $c$"""Be.*Gze(S. e/FF0#e1Effff懣@P, %Se++S0f@"">" fF'f(*d%S(f)f*p"T*f+f*D!rf,*Gzf.\Dc& SEE SPEC.  SEE SPEC.5DN# Dc& B$ $c&"Bf-*e,Df, SEE SPEC.  SEE SPEC.]DL#  $e%?DL#  $d%!DL#  $c%"""Bf.*Gzf(S. f/FF0#f1Effff懣@ %Sf++S0gV@.gF ~ g!@gg"g-QDg*@ Dg(Dg+.Dg, Dg(Dg+ "Bgg#*h-QDh*@ Dh(Dh+.Dh, Dh(Dh+ "Bgg$*@i-QDi*@ Di(Di+.Di, Di(Di+ "Bgg%* j-QDj*@ Dj(Dj+.Dj, Dj(Dj+ "B)g&*p= j,DM# Dg)%DBfDM# Dg)%DBfDM# Dg)%DBfDM# Dg)%DBfbDM# Dg)%DBf4DM# Dg)%DBf"""""B`g',JD*D,Q? D*D,Q? B% $, $*Bg(*h"S(g)g&D*g* "T*g+p= ?@g1D"rg,*p= g.\Dg& SEE SPEC.  SEE SPEC.5DN# Dg& B$ $g&"Bg-*&Dg, SEE SPEC.  SEE SPEC.]DL#  $i"?DL#  $h"!DL#  $g""""Bg.p= g(S. g/FF0#g1EzGo@g* %Sg++S0h@.hF!ah"i"KDg* Dg(Dg+.Dg, Dg(Dg+ "Bah#*i#KDh* Dh(Dh+.Dh, Dh(Dh+ "Bah$*@i$KDi* Di(Di+.Di, Di(Di+ "Bah%* i%KDj* Dj(Dj+.Dj, Dj(Dj+ "Bh&`h'JD+D,Q? D+D,Q? B% $, $+Bh(*h#S(h)h*"T*h+h1D"rh,*p= h.\Dg& SEE SPEC.  SEE SPEC.5DN# Dg& B$ $g&"Bh-*g,Dh, SEE SPEC.  SEE SPEC.]DL#  $i#?DL#  $h#!DL#  $g#"""Bh.*p= h(S. h/FF0#h1EzGo@P- %Sh++S0i@.iF!gi"g"QDg* @ Dg(Dg+.Dg, Dg(Dg+ "Bgi#*g#QDh* @ Dh(Dh+.Dh, Dh(Dh+ "Bgi$*@g$QDi* @ Di(Di+.Di, Di(Di+ "Bgi%* g%QDj* @ Dj(Dj+.Dj, Dj(Dj+ "B i&'i(*h$S(i)i*"T*i+i1D"ri,*p= i.\Dg& SEE SPEC.  SEE SPEC.5DN# Dg& B$ $g&"Bi-*@h,Di, SEE SPEC.  SEE SPEC.]DL#  $i$?DL#  $h$!DL#  $g$"""Bi.*p= i(S. i/FF0#i1EzGo@P. %Si++S0j@. jF'j(*h%S(j)j*T*j+j*D"rj,*p= j.\Dg& SEE SPEC.  SEE SPEC.5DN# Dg& B$ $g&"Bj-*i,Dj, SEE SPEC.  SEE SPEC.]DL#  $i%?DL#  $h%!DL#  $g%"""Bj.*p= j(S. j/FF0#j1EzGo@ %Sj++S0k@.4kFFFHHHHFFFFFFFFFF10lV@"4lF?AFFFFFFHHHHFFFFFFFFFF10m@"4mF?AFFFFFFHHHHFFFFFFFFFF10n@"nF n} nw nx ny n z n!{ n"|n#F n$ n%HFFFFFFFFFF10o@"oF o~oF# o$ o%CFFFFFFFFFF10p@"pF pp@@qDp@@p Dpp@q Dp @@q Dp!@q! Dp"p@q" Dp#F p$ p%FFFFFFFFFFF10qV@qF!q DD 9qqr#DqDp  $q Bqg qq<qx2LDp LDp B$ , Bqgfrq<qx2LDp LDp B$ , Bq gr q <qx 2LDp LDp B$ , Bq!gr!q!<qx!!2LDp! LDp B$ , Bq"rr"q"<qx""2LDp" LDp! B$ , Bq#Fnq$!@ XDV D %ZaBf1DV D %ZaBf"B q%FFFFFFFFFFF10r@rF!r%r D D 9rqs#DrDp  $r Brg sqrg sqr g(s q r!g,s!q!r"r0s"q"r#F r$ r%!r&FFFFFFFFFFF10s@sF!ss D D 9sqt#DsDp  $s Bsgf4tqsgT tqs gf<t q s!g@t!q!s"rDt"q"s#F s$D s%!s&FFFFFFFFFFF10t@tF!tt D D 9tqu#DtDp  $t BtgHuqtgLuqt g u q t!gfTu!q!t"rfXu"q"t#F t$ t%!t&FFFFFFFFFFF10u@uF!u%u D D Hug\v2DuDp DuDp B$ $u Bug`vqugdvqu g v q u!glv!q!u"rpv"q"u#F u$G u%!u&FFFFFFFFFFF10vW@vF!v%v D D Hvgtw2DvDp DvDp B$ $v Bvg3xwqvg|wqv g w q v!gw!q!v"r3w"q"v#F v$ v%!v&FFFFFFFFFFF10w@wF!ww D D Hwgx2DwDp DwDp B$ $w Bwg̐xqwgxqw gx q w!gx!q!w"rx"q"w#F w$H w%!w&FFFFFFFFFFF10x@xF!xx D D Hxs}2DDp DDp B$ $ Bxt}qxtzqx tz q x!tz!q!x"uz"q"x#F x$ x%!x&FFFFFFFFFFF10y@ yF~ yn?%yo\(@@rD}{Gz?%yoGz@@}D}{Gz?%y oףp= p@} D}{Gz?%y!oףp= @@}!D} {Gz?%y"pQ@}"D}!{Gz?y#F y$ y%!y&FFFFFFFFFFF10z @ zF%zq|zzz" -Bzgzzg|zz g| zz!g|!zz"r|"zz#F z$ z%!z&FFFFFFFFFFF10{ W@ {F%{q{V{{"LLL LL B$ ,$LL LL B$ ,LL LL B$ ,LL LL B$ ,LL LL B$ ,hLL LL B$ ,9LL LL B$ , """"""B{g{{g{{ g {{!g!{{"r"{{#F {$ {%!{&"FFFFFFFFFFF10|@@ |F%|q{|||" -B|gz||g{|| g{ ||!g{!||"r{"||#F |$ |%!|&"FFFFFFFFFFF10}@@ }F%}v@@y}}}" -B}w@@|}}wp@}} w@@ }}!w@!}}"xp@"}}#F }$I }%!}&FFFFFFFFFFF10~ @@ ~F%~n{Gz?~~~"L~o\(@@~~oGz@@~~ oףp= p@ ~~!oףp= @@!~~"pQ@"~~#F~ ~$?~% %~%+~%%!L  , B~&%t &~&+~&&!L  , B~'FFFFFFFFFFF10%@@ F%q-" #L  , ,Bgg g !g!"r" #F$%%~%&%V&~&'FFFFFFFFFFF1DIlO'y'y'lllVe___222 22222 22222 22222 2 22222 2 2222 2220@W@@ F%qgg g !g!"r" #F$%%~%&%f&~&'FFFFFFFFFFF10/@@@@ F%q@@/"%LL  , ,Bg@@gp@ g@@ !g@!"rp@" #F$% %~%&%&~&'FFFFFFFFFFF104@@@@ F,yx-"#LL  , BzzX  z  !z!"{"#F~ $@%E %~%&% &~&'FFFFFFFFFFF109@@@@ F,n{Gz?"Lo\(@@oGz@@ oףp= p@ !oףp= @@!"pQ@" #F$%%~%&%&~&'FFFFFFFFFFF10>@@@@ Fq-"#L  , ,Bggy gy !gy!"ry" #F$%%~%&%&~&'FFFFFFFFFFF10`W@@@@ Fq@@g@@gp@ g@@ !g@!"rp@" #F$%%~%&%+ &~&'FFFFFFFFFFF10H@@@@ Fq@@g@@gp@ g@@ !g@!"rp@"#F~ $@%E%~%&%&~&'FFFFFFFFFFF10M@@@@ Fv|ww  w  !w !"x(" #F$%,%~%&%b0&~&'FFFFFFFFFFF10R@@@@ Fn{Gz?"Lo\(@@oGz@@ oףp= p@ !oףp= @@!"pQ@" #F$%4%~%&%8&~&'FFFFFFFFFFF10W@@@@ Fq@@-"#L  , ,Bg@@gp@ g@@ !g@!"rp@" #F$%<%~%&%@&~&'FFFFFFFFFFF10W@@@@ Fq@@g@@gp@ g@@ !g@!"rp@"#F~ $@%D%~%&%EH&~&'FFFFFFFFFFF10a@@@@@ Fq@@g@@gp@ g@@ !g@!"rp@" #F$%L%~%&%P&~&'FFFFFFFFFFF10f@@@@@ FvwTw  w  !w$!"xd" #F$%h%~%&%l&~&'FFFFFFFFFFF10k@@@@@ Fn{Gz?" Lo\(@@oGz@@ oףp= p@ !oףp= @@!"pQ@" #F$%p%~%&%t&~&'FFFFFFFFFFF1W@*@@@@ Fq@@g@@gp@ g@@ !g@!"rp@"#F~ $@%%~%&%E&~&'FFFFFFFFFFF1W@*@@@@ Fq@@/"%LL  , ,Bg@@gp@ g@@ !g@!"rp@" #F$%%~%&%&~&'FFFFFFFFFFF1_ffffW@*@@@@ Fqghg  g  !g!"r" #F$%%~%&%&~&'FFFFFFFFFFF1̬W@*@@@@ Fstth  t< !t$!"u" #F$%%~%&%&~&'FFFFFFFFFFF1,3333W@*@@@@FlmmmmmF#~ $@%%~%&%&~&'FFFFFFFFFFF1W@*@@@@ Fn{Gz?"Lo\(@@oGz@@ oףp= p@ !oףp= @@!"pQ@" #F$%%~%&%&~&'FFFFFFFFFFF1W@*@@@@ Fq@@~/"%LL  , ,Bg@@gp@~ g@@~ !g@~!"rp@~" #F$%~%~%&% ~&~&'FFFFFFFFFFF1_ffffW@*@@@@ Fq/"%LL  , ,Bglg  g  !g!"r("$#FFFFFFFFFFFF1W@*@@@@ FqK"AL ,LL  , ,"Bg4gl  g  !g\!"rD"$#FFFFFFFFFFFF1,3333W@*@@@@ FsI"?L *LL  ,"BsPsT s@ !s\!"s`" #F$#%, %~%%Sy#&% %~&&3'FFFFFFFFFFF1W@*@@@@4FFFFFFFFFFFFF1W@*@@@@ F|p= ?@S+" LL}p= ?@W+}p= ?@[+ }p= ?@_+!}p= ?@c+"~p= ?@g+$#FFFFFFFFFFFF1_ffffW@*@@@@ F[ T+ED 0DD DD"BhpX+1"'L LLBh \+ h `+!hd+"h+$#FFFFFFFFFFFFFFF1W@*@@@@ F[U+ED 0DD DD"BhY+hp ]+ h a+!h`e+"i+$#FFFFFFFFFFFFFFF1%3333W@*@@@@ F=V+'D DDBZ+^+ |b+!f+"j+$#FFFFFFFFFFFFFFF1W@*@@@@4FFFFFFFFFFFFFFFF1W@*@@@@4F%%%%%%FFFFFFFFFFFFFFF1XffffX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1D-lh{hrh{rhh{~ttcxIpRxx222222222222222222222 22222222222 X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1%3333X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1Xffff&X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1,X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1%33333X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF19X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1?X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1XffffFX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1LX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1%3333SX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1YX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1_X@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1QfffffX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1lX@*@@@@4FFFFFFFFFFFFFFFFFFFFFFF1 ~ @<FFFFFFFFFFFFFFFFFFFFFFF1 ~ @<FFFFFFFFFFFFFFFFFFFFFFF1 ~ @<FFFFFFFFFFFFFFFFFFFFFFF1&IJJ~ @&~ @***********##****#+++++++++*))K . *))////L)) 1///////*))//)/)) 1**M///)) 1***///)) 1*))////L)) 1*))//)/)) 1*MM///K)) 1*)*///)) 1D lxxxxxxxxxxxxxxxx\\\JJ..........X*))////L)) 1*))//)/)) 1*MM///)) 1*)*///)) 1*))////L)) 1*))//)/)) 1*MM///K)) 1*)/)) 1*))////L)) 1*))//)/)) 1*MM///)) 1*)*///)) 1*))////L)) 1*))//)/)) 1*MM///)) 1*)*///))) 1*))////L)) 1*))//)/)) 1*MM///)) 1**#//#/N)O**#P***Q6777**RRRRST*RRRRRSTU*)**UU*V*VW)*UU##)*/X*##))U#)U#YD@l...............................**)##-#**ZJJ **ZJJ )))))))*IJJ//////*IJJ************##****#+++++++++*))K . *))////L)) 1///////*))//)/)) 1**M///)) 1***///)) 1*))////L)) 1*))//)/)) 1*MM///K)) 1*)*///)) 1*))////L)) 1*))//)/)) 1*MM///)) 1*)*///)) 1*))////L))-1*))//)/)) 1*MM///K)) 1*)/)) 1*))////L)) 1*))//)/)) 1*MM///)) 1*)*///)) 1*))////L)) 1*))//)/)) 1D@l...............................  X  h *MM///)) 1*)*///))) 1*))////L)) 1*))//)/)) 1*MM///)) 1**#/)O**#P* * 56777* * 8988:;* RRRRRSTU*)*XUUZ[Z[W)*XU##)*/X*##))U#)U#Y**))##-#**ZJJ )**ZJJ )))))))*IJJ///////*IJJ**********************#****#++++++++*))K .......*)) ///L) 1111111*)) /)/) 1111111**M //) 1111111*** //) 1111111*)) ///L) 1111111D@l............................... !"#$%&'()*+,-./0123456789:;<=>?* )) /)/ 1111111*!MM //K) 1111111*")* //) 1111111*#)) ///L) 1111111*$)) /)/) 1111111*%MM //) 1111111*&)* //) 1111111*')) ///L) 1111111*()) /)/) 1111111*)MM //K) 1111111**) /) 1111111*+)) ///L) 1111111*,)) /)/) 1111111*-MM //) 1111111*.)* //) 1111111*/)) ///L) 1111111*0)) /)/) 1111111*1MM //) 1111111*2)* //)) 1111111*3)) ///L) 1111111*4)) /)/) 1111111*5MM //) 1111111*6*7***8#/#/N))\\\\\\\*9*:#P*;*<*=*>*?D@l...............................@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_*@*A*B*C*D*E*F*G*H*I*J*K*L*M*N*O*P*Q*R*S*T*U*V*W*X*Y*Z*[*\*]*^*_D@l...............................`abcdefghijklmnoXpqhrstuvwxyz{|}~*`*a*b*c*d*e*f*g*h*i*j*k*l*m*n*o56777*p*q8988:;*rRRRRRSTU*)*sXUUZ[Z[W)*tXU##)*/X*u##))U#)U#Y*v*))##-#*w*xZJJ )*y*ZJJ )))))))*zIJJ///////*{IJJ*|*}****************~****#****#++++++++*))K .......D@l...............................*)) ///L) 1111111*)) /)/) 1111111**M //) 1111111*** //) 1111111*)) ///L) 1111111*)) /)/ 1111111*MM //K) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //K) 1111111*) /) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //)) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*****#/#/N))\\\\\\\**#PD@l...............................Xh***56777**8988:;*RRRRRSTU*)*XUUZ[Z[W)*XU##)*/X*##))U#)U#Y**))##-#**ZJJ )**ZJJ )))))))*IJJ///////*IJJ**********************#****#++++++++*))K .......*)) ///L) 1111111*)) /)/) 1111111**M //) 1111111*** //) 1111111*)) ///L) 1111111*)) /)/ 1111111*MM //K) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //) 1111111*)) ///L) 1111111D@l...............................Xh*)) /)/) 1111111*MM //K) 1111111*) /) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //)) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*****#/#/N))\\\\\\\****56777**8988:;*RRRRRSTU*)*XUUZ[Z[W)*XU##)*/X*##))U#)U#Y**))##-#**ZJJ )**ZJJ )))))))*IJJ///////D@l...............................*IJJ**********************#****#++++++++*))K .......*)) ///L) 1111111*)) /)/) 1111111**M //) 1111111*** //) 1111111*)) ///L) 1111111*)) /)/ 1111111*MM //K) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //K) 1111111*) /) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111*)* //)) 1111111*)) ///L) 1111111*)) /)/) 1111111*MM //) 1111111D@l...............................Xh     *****#/#/N))\\\\\\\*PPPPPP**56777**8988:;*RRRRRSTU*)* XUUZ[Z[W)* XU##)*/X* ##))U#)U#Y* *))##-#]* *ZJJ )**ZJJ )))))))*IJJ///////*IJJ**********************#****#++++++++*))K .......*)) ///L) 1111111*)) /)/) 1111111**^ //) 1111111*** //) 1111111*)) ///L) 1111111*)) /)/ 1111111*M^ //K) 1111111*)* //) 1111111*)) ///L) 1111111*)) /)/) 1111111D@l............................... !"#$%&'()*+,-./012345* MM //) 1111111*!)* //) 1111111*")) ///L) 1111111*#)) /)/) 1111111*$MM //K) 1111111*%) /) 1111111*&)) ///L) 1111111*')) /)/) 1111111*(MM //) 1111111*))* //) 1111111**)) ///L) 1111111*+)) /)/) 1111111*,MM //) 1111111*-)* //)) 1111111*.)) ///L) 1111111*/)) /)/) 1111111*0MM //) 1111111*1*2***3#/#/N)R3333333*4_PPPPP*50.....................R 0: (  ~  <@1 XPP?  fn ]4@@1d YjyA"OQHjY L<MTON TYPE, ENGLISH OR METRIC, USED TO DETERMINE THE NUMBER OF LOTS REQUIRED. <K L~~  <H1 XPP?  f]4@H1 zC!& < The average (Gmm) Maximum specific gravity value used to calculate the percentage density for the lot shall be the average value obtained from the maximum gravity results from production tests taken during that days paving. If only one or two maximum specific gravity values were obtained that day, then the moving average value (at that test point) shall be used. If three or more maximum specific gravity values are obtained that day, then the average of those tests alone shall be used as indicated above.<e  ~~  <1 XPP? f ]4@1 KpnwLLRMOC D<E MIX TYPES LV = LOW VOLUME, 92% REQ'D DENSITY, 3% AIR VOIDS LV-R = LOW VOLUME"REDUCED"DENSITY TO 91%, 3% AIR VOIDS MV = MEDIUM VOLUME,92% REQ'D DENSITY, 3.5% AIR VOIDS MV-R = MEDIUM VOLUME"REDUCED"DENSITY TO 91%, 3.5% AIR VOIDS SPWE = SUPERPAVE WEAR, 92% REQ'D DENSITY, 4% AIR VOIDS SPWE-R = WEAR"REDUCED"DENSITY TO 91%, 4% AIR VOIDS SPNW = SUPERPAVE NONWEAR, 93% REQ'D DENSITY, 3% AIR VOIDS SPNW-R = NONWEAR DENSITY"REDUCED" TO 92%, 3% AIR VOIDS SPSHLD-3 = SUPERPAVE SHOULDERS @ 3% VOID, 93% DENSITY SPSHLDR-3 = SUPERPAVE SHOULDERS @ 3% VOIDS, REDUCED TO 92% DENSITY. SPSHLD-4 = SUPERPAVE SHOULDERS @ 4% VOIDS, 92% DENSITY SPSHLDR-4 = SUPERPAVE SHOULDERS @ 4% VOIDS, REDUCED TO 91% DENSITY.<`hm o+B7!ZX"]:,! P -4D#7L!}#?w#:$#? ZD~~  <1 XPP? f ~]4@1 %nDbG݅H> <IF THE COMPANION CORE DEVIATES BEYOND THE ALLOWABLE TOLERANCE OF .030, THE COMPANION CORE WILL BE USED IN PLACE OF THE CONTRACTORS CORE. YOU MUST ENTER THE COMPANION CORE #. <O ~~  <`1 XPP? ' _]4@`1 d~rBE(1  <% Density is calculated using the average bulk SpG divided by the Max SpG. The correct Max SpG is critical in calculating incentive/disincentives.<  ~~  <Ĺ1 XPP?  _]4@Ĺ14  `8rJae. T<UIndividual air voids taken from the table above, review entrys and delete old data. <S T `~~  <(1 XPP?   j]4@(1$! Ԑ8mI}P <Pay Factor is determined by comparing the % density and air void used to the required density and minimum air void listed above. Review the mix type entry above. < @~~  <1 XPP? @]4 @1t! ݃ A1d 0(<1ENTER BEGINNING LOT # FOR THAT DAYS PRODUCTION. <(.0~~  <1 XPP? Cf]4 @1d" *߉Dkvf <COMPANION CORE # <o ~~  <T1 XPP? -@ 0^]4 @T1" <% s:C `$ '<(SEE PROPOSAL FOR MIX DESIGNATION TYPE. <& '~~  <1 XPP?  ]4 @1# 5ɮrN ]Bz 4<5# OF LOTS REQUIRED IS BASED ON THE MAX DENSITY TONS.<F4~~  <1 XPP?  ]4 @1# j{AaY o<pThe average of the two bulk Specific Gravities, this is used with the Max Density to calculated the % density. <cn o `H~~  <1 XPP?  b 3]4@1$ )OG fy .</Insert sample number from test summary sheet. <- .Vlb~~  <1 XPP?  @]4@14% ,Y>Cӑ i, U<VThe tons produced from the start of the days production to when the sample is taken. <T U~~  <H1 XPP?  ]4@H1$& G @'Y? [<\MAX DENSITY TONS IS CALCULATED BY A RATIO BETWEEN THE TONS PAVED AND THE MAX DENSITY TONS. <>Z [~~  <1 XPP?  ]4@1t& o ;Dɬ\pW< 5<6THIS PROGRAM HAS BEEN DEVELOPED FOR THE RECORD KEEPING OF BITUMINOUS DENSITYS. THIS WORKSHEET COVERS THE INCENTIVE AND DISINCENTIVES IN REGARDS TO SPEC 2350 AND 2360. DATA ENTRY IS ALLOWED ONLY IN THE HIGHLITED BOXES. REMEMBER TO DELETE ANY NON CURRENT DATA. DOLLAR TOTALS ARE DEPENDANT ON GOOD DATA ENTRYS. <4 5YSH~~  <1 XPP?  0@ Z]4@1d' :⪒uN0| <LEAVE THIS FIELD BLANK. IF YOU HAVE A DIFFERENT AMOUNT OF LOTS THAN THE PROGRAM ALLOWS FOR, INSERT THAT NUMBER IN THIS FIELD.<#xx  61CC@ 2 3 ],@1'L19 $(<)Copy Data From This File to Another File<(xx  61CC@ 23],@1(,19 $)<*Paste Data to This File from Another File<)~~  <п1 XPP? f ]4@п1( .@[V^ J(<KSQUARE YARD INCH PROJECTS ONLY. Insert the required mat thickness, (ie, 1,1.5, 2, 2.5, etc) Be sure the bid price reflects the square yard inch bid price. Delete any number to convert the worksheet to a tonnage worksheet. Incentive/Disincentives are based on the average core density for that day's production and the bid price.<(#Jt~~  < 1 XPP? fn 3]4@ 1) m`dG j8J 6<7Taken from the project proposal, review for accuracy. </5 6~~  <1 XPP? f Z]4@1t* e*B%+0t e<fTotal tons or sq yds delivered to the project for that days production, excluding any waste mixture. <0d e~~  <1 XPP?  fx f]4@1* d?OT ^# W<XThe total tons or sq yds that are included in the incentive/disincentive calculations. <V W~~  <L1 XPP?  f ]4@L1+ ">F#Ȧej i <jA ratio between the total tons and the max density (incentive) tons. This is needed for the calculations.< D E#ih0~~  <1 XPP?  ]4@1, ^Q:?B$.oU& `<aINDIVIDUAL AIR VOIDS IS TAKEN FROM THE SUMMARY SHEET, REVIEW TOLERANCE AND RETEST REQUIREMENTS. <h_ `DefaultDefaultDefaultDefaultDefaultBoer1Dan RONALD G BUMANNA DefaultG  DefaultG MISa DefaultG DefaultG DefaultGDefaultGDefaultGMISaDefaultGDefaultG DefaultG MISa MISa DefaultG/ MISa>@ddZK  ....  ......    //000000////25      $$ ## 00    88 22"" )) (( '' && //11-- ,, ++ 00 // !!  %%      FF  ** 7  ;$  ...qD? ... LL? ... LL""""?"" ... LL&&&&?&& ... LL****?** ... LL  ?  ... D/  %r}$$/  %np$$/  -GH /  %>?AA  Sheet6 0@ X>[&.5>7FM/U\dkor  dMbP?_*+%M\\MRL2KS      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWX\]^`abefghijklmnopqrstuvwxyz{|}~PRINT\BUSINESSdXXLetter.HP LaserJet 8150 PCL 62xeP;KQsG> ݈FFsWT,BI EQDeKShcoXh:]|'~)sfs8e@KH߾@dcI!?(H% c6>'i5 1 ݄vpk)H?=: I"m E'6_dZd iqdw6t=^@- $ paC#j 6Vp>!y=#I;䙴 d:h3:hkKX#lZb|o x+@/Jk$dh<=rl~uc}\~YŹh8JG)7]\P﨑x<L4 ci ["\XX??cU} } $}  } I }  }  }  } } }  } $ >JJJJJJJ@ w@ w@ , J@ JJJJJ,o!JJJJJJJJoJ,JJ.oklZmmmmmmmmmnopppoo jf g(jXXXXXXXXXhqiiiq jf j(jjjjjjjjjjriiiiiq jf g"XXXiii  q jf g"XXXXXXXXcii$@q sb g"[[[s[[s[ssMU??o(sbrr[ssXsXXsMUȂ@@ostv Xs~ `p@   rrr + X@XD% Bf MUH@@ovtv Xv~ `̠@XXXvMU@@ vtuuv X v! X@- DD XXXvMU "@@  vf s jjjjjwjjcU @@ $ jtvvvvvxxxxxxY q vb l m< _r@_r@_r@_s@_s@_ s@y0s@y@s@yPs@     sb nu o< _P@_|@_@_@_@_B@_ױ@ye@y @  o os b lmd̠@% Dd̠@%d̠@%d̠@%d̠@% d̠@%  d̠@%  d̠@%  d̠@%  oos b no<zP@z|@z@@z@@z@@z@@z@@z@@z@@  oos b no<zzzy@z@z@zD@z@z*@zx@  oo sb nvo<{w@{ w@{y@{ w@{@{@{@{{@{@  o*s|}}~*sbss[[[[[[[rr oos b&[[[s[[[[[rr~ @ oos b e$[~~~ @ oos b e$[[~~~ @ oo[ b [$][~~~ @ \\0[b[][\\\0[|~~}\\\ sb uv<r@r@r@s@s@ s@0s@@s@Ps@   sb nuo;P@ %D D  $  $B|@/ %LL  , ,B̠@ ̠@ ̠@  ̠@  ̠@  ̠@  ̠@ ooo0sb[[ooo sb rr  }}̠@ D   ~  _@ ooo0sb]~~ooooo sb lm7r@ !D   $ Br@+ !L  ,B`dh l p  t  x  oooooDml2HH^bbLv^8v.<^jjj44z44 J!J",!#$J%J&J'J(J)J*J+J,-J./J0J1J2!3,4,5,6789x:h;h<h=h>x?@ sb nu o P@! K  ALD *LL  ,"B |@!  |!  !  !  !   !   !   !   ooooo !sb !nv!o7!ffffff@ !D   $B! @ !+!! !L  ,B!f!!!!!! !!  !!  !!  !! ooooo0"s|~~ooooo0#sb[[~~ooooo $sb $l$m<$r@r@r@s@s@ s@0s@@s@Ps@ $ ooooo %sb %nu%o?% )D D D DB%(%3%% )LL LLB%@o@%%@)%%8@)%% @)%% @) %% @) %% L@) %% ooooo &sb &nv&o&ffffff@D& @*&&& L&ffffff@*&& @*&&@*&& @*&& @* && @* && @* && ooooo0'sb[[~~ooooo (sb (l(m(r@& D((r@(D%D%  $$D%D%  $$D%D%  $$D% D%  $$ D% D%  $$ jD% D%  $$ JD% D%  $$ *D% D%  $$  """""""B(s@((((  L(s@((( s@( (( 0s@( (( @s@( (( Ps@ (( `s@) (( ooooo )sb )nu)o~ )+)@o@0D(%$& Be+)@0D(%$& Be)8@0))) L- Be)@0 )) @0 )) @0 )) L@( )) L@0 )) ooooo *sb *pv*q+* @1D(%$& Be+*ffffff@1D(%$& Be+* @1D(%$& Be*@1*** L- Be*@1** @1 ** @1 ** @1 ** @&** ooooo0+o|~~ooooo0,ob[[ooooo -ob -r -r -}-}-@* D - - - ~ - _@- ooooo0.obssooooo /ob /l/m/r@ /+// !L  ,B/r@///s@///s@/// s@/// 0s@/// @s@/ // Ps@/ // / // ooooo 0ob 0nu0o0(D)90@o@&#D)D)  $)B0@&0-00 #LL  ,B08@&00@& 00 @& 00 @& 00 L@& 090 1 #D) D)  $) B0 ooooooo 1ob 1nv1o1 @/ 1+11 !L  ,B1ffffff@011 @011@)11@11 @11 @ 11 @ 11  11 ooooooo02o{{ooooooo03o\aozzoooooooo04o\oooozzoooooooo05o\xxxxxxxx||||ooooooo06o\xxxxxxxx\zzzooooooo07o\xxyyxxyyooooooooooo08o^o\^^oo09sssssssssswww0:ssssssssssss0;0<ssssssssss0=VV0>WW&?ttDl44j4p4444444444444444@@A@B@C@D@E;@FhGh@ @A AB  BC CD D EF FG, &,,$,     Td$,$$                                Dl$$$$$$$$$$$$$$$$$$$$$$$$$$$,$,$XX                                D0l,$,$$$$$,,$$$$,$$,$$$$$$$$$$$$$     XXhh                                  D8l$$$$$$$$$$$$$,$,$,$,,$$$$$,$$$$ !"#$%&'()*+,-./0123456789:;<=>?  !" " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < => >? ?Dl$$,$$$$$$$$$$$$$$$$$$$$$$$$$$$,@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @A AB BC CD DE EF FG GH HI IJ JK KL LM MN NO OP PQ QR RS ST TU UV VW WX XY YZ Z[ [\ \] ]^ ^_ _Dl$,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,`abcdefghijklmnopqrstuvXwXxhyhz{|}~` `a ab bc cd de ef fg gh hi ij jk kl lm mn no op pq qr rs st tu uv v wx xy y z { | } ~ Dl,,,,,,,,,,,,,,,,,,,,,,,$,,$$$$$                                Dl$$$$,$$,$$$$$$$$$$$$$$$$$$$$$$$XXhh                                DXl$$$,,$,,,,$,,$$$$$,$$$$,$$,$$$$XXhh                                D8l$$$$$$$$$$$$$$$$$$$$$$,,$,,,$,,                                Dl$$$$,$$$$,$$,$$$$$$$$$$$$$$$$$$    X Xhh                                    D@l$$$$$$$$,,$$,$,,$$$$$,$$$$,$$,$ !"#$%&'()*+,-./0123456789:;<=  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 89 9: : ; <=@D$$$$$$$$$$$$$$$$$$$$$$$$$,,$$0 (  ~  <<1 XPP?   f]4@<1. R4F6 C b<cEnter the total tons placed in area "A", the Max Density tons will be addressed on each worksheet.<*b!~~  <D1 XPP?   ]4@D1/ !.(@TVo̎T c<dEnter the total tons placed in area "B", the Max Density tons will be addressed on each worksheet. <)b c~~  <1 XPP? 7"]4 @10 %SϘpH\( <Insert the following data into the density incentive/disincentive worksheet. The worksheet will determine the tons represented from the sample ton numbers. Disregard a sample ton # 0, needed for programming. < Default Default Default>@dd@           --'' ##  22 33 44 55 66 55555555 66666666 77777777 9999 :::: << ?? $$%% !!//0011&&))**((--7 Sheet4 0@  i r|  dMbP?_*+%,+3M\\mrl2ksprint\PAVE-ENG?d,,Letter.HP LaserJet 4000 Series PCL 627xe.@?v(ł!~ uy ,}4!tɢ6v^Kx;LK#1$'R1M\\ G_  ap3}$%y+z @؄Tqp;pL`PVf\;u&n7 Uʹ-A ~iEDBƒ$ ϢoO.0 vCSr6h:w5xASMvG/6Y_C^+ <F` D)w."%tC_(܆#JQiM4XcC;\xYC@dr9& $+2Q8FpN9Zj"\,,??clU} b}  b} $ bi  , , , h , , , , , , , , , , , , , , , , , , , , , , , , , , , ,dddddddddd dddddddddd dddddddddd X dddddddddd d dZdddddddd d d[dddddddd d dYdddddddd dddddddddd  d dq dddddddd  d dr dddddddd  d ds dddddddd  dddddddddd  d d\ dddddddd d dpdddddddd dddddddddd dd dtddddddd dddddddddd d dbdddddddd d d]dddddddd d d^dddddddd d d_dddddddd d d`dddddddd d dadddddddd dddddddddd  c dd dtddddddd  cdddddddddd d dodddddddd d d]dddddddd d d^dddddddd d dcdddddddd d dddddddddd Dl*222222224222222(>2222 ;! ," ,# ,$ ,% ,& ,' ,( ,) ,* ,+ ,, ,- ,. ,/ ,0 ,1 ,2 ,5 ,7 ,8 ,9 ,: ,; ,< ,= ,> , d de dddddddd !dddddddddd "dddddddddd #d #df#dddddddd $d $dg$dddddddd %d %d^%dddddddd &d &dc&dddddddd 'd 'dh'dddddddd (d (di(dddddddd )d )dj)dddddddd *dddddddddd +dddddddddd ,d ,dk,dddddddd -d -dg-dddddddd .d .d^.dddddddd /d /dc/dddddddd 0d 0dl0dddddddd 1d 1dm1dddddddd 2d 2dn2dddddddd 5b 7 8 9b :b ;b << = > <J222222222222222(@,A,C,D,E,F,G,H,I,J,K,L,M,N,P,Q,R,S,T,U,W,X,Z,[,],^,_, @b Ab Cb Db Eb Fb Gb Hb Ib Jb Kb Lb Mb Nb Pb Qb Rb Sb Tb Ub Wb Xb Zb [b ]b ^b _b:`,b,c,e,f,h, `b b! c! eb fb hbdPH@T0(  T>K@ddjjj <> 7 Sheet2 0@ *  dMbP?_*+%,M\\mrl2ksprint\PAVE-ENG?d,,Letter.HP LaserJet 4000 Series PCL 627xe.@?v(ł!~ uy ,}4!tɢ6v^Kx;LK#1$'R1M\\ G_  ap3}$%y+z @؄Tqp;pL`PVf\;u&n7 Uʹ-A ~iEDBƒ$ ϢoO.0 vCSr6h:w5xASMvG/6Y_C^+ <F` D)w."%tC_(܆#JQiM4XcC;\xYC@dr9& $+2Q8FpN9Zj"d,,??cPU} b} $ b*  , , , h , , , , , , , , , , , , , , , , , , , ; , , , , , , , ,dddddddddd dddddddddd dddddddddd X dddddddddd d dZdddddddd d d[dddddddd d dYdddddddd dddddddddd  dddddddddd  d d\ dddddddd  d d] dddddddd  d d^ dddddddd  d d_ dddddddd d d`dddddddd d dadddddddd dddddddddd  cdddddddddd d dbdddddddd d d]dddddddd d d^dddddddd d dcdddddddd d dddddddddd d dedddddddd dddddddddd dddddddddd d dfdddddddd d dgdddddddd d d^dddddddd d dcdddddddd d dhdddddddd d didddddddd Dl*222222222(22222222222 ,! ," ,# ,$ ,% ,& ,' ,( ,) , d dj dddddddd !dddddddddd "dddddddddd #d #dk#dddddddd $d $dg$dddddddd %d %d^%dddddddd &d &dc&dddddddd 'd 'dl'dddddddd (d (dm(dddddddd )d )dn)dddddddd 2222222PHPX0( 3f3f3 X>@d   7 Sheet3 Sheet6ThisWorkbook Module1 dئSheet1  !"#$%&'()*+,-./123456789:;<=>?ABCDEFGHIJKLMNOQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~+8#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 78#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 by Dan Boernerday (1)$B@H$ day (1)$B@soPxStep #1 - Copy Data to "Sheet1"Sheet1$($ incentive$B@Hd5:d6$&B@H (B@Sheet1$B@Hd5$&B@H *B@,Selection.Paste incentive$B@Hg5:g6$&B@H (B@Sheet1$B@Hg5$&B@H *B@,Selection.Paste incentive$B@Hi5$&B@H (B@Sheet1$B@Hi5$&B@H *B@,Selection.Paste incentive$B@Hi6$&B@H (B@Sheet1$B@Hi6$&B@H *B@,Selection.Paste incentive$B@Hk6$&B@H (B@Sheet1$B@Hk6$&B@H *B@,Selection.Paste incentive$B@Hh8:h9$&B@H (B@Sheet1$B@Hh8$&B@H *B@,Selection.Paste incentive$B@Hk9:k11$&B@H (B@Sheet1$B@Hk9$&B@H *B@,Selection.Paste incentive$B@Hd13:l14$&B@H (B@Sheet1$B@Hd13$&B@H *B@,Selection.Paste incentive$B@Hd17:l17$&B@H (B@Sheet1$B@Hd17$&B@H *B@,Selection.Paste incentive$B@Hd17:l17$&B@H (B@Sheet1$B@Hd17$&B@H *B@,Selection.Paste incentive$B@Hb21$&B@H (B@_ۖ8IxME x@p %Macro recorded 7/13/01 by Dan Boerner 14 " .! 08 4x  61 8@"   ,( X `h&"    &   @ X hp      8 P ` x     (0P h x     (0H ` p       8@` x     ( 8@X p      0 HPp       8 HPh         8  P ` x         ( 0 H P p           8 H P h            8  P ` x         ( 0 H P p          8 HPh        8 P ` x     ( 0 HPp       8 HPh      0 @ X`     0 H X`x     ( @ P h (p      0 8@"H P X ` &h          (0H ` p x     *   0 @Hh      0 @ X`x     ( @ PXx     ( @ P hp      8 P `h     8 P ` x     (0H ` px      (H ` p      0 @ X`x       ( 0 H  ` p x        !  !(!H! `! p! ! ! !!! ! !!" 0" @" X"`"x" " """ " " # # (#0#H# `# p#x## # # ### $  $($H$ `$ p$ $ $ $$$ $ $$% 0% @% X%`%x% % %%% % % & & (&0&H& `& p&x&& & & &&& '  '('H' `' p' ''' ' ''' (  ( 8(@(X( p( ((( ( ( (() ) 0)8)X) p) ) ))) ) ))* * 0* H* P* X*`* x* * **"* * *.*.*,+,@+ p+ ,x+ + + + +,", ,  ,.(,.X,,,,, ,,", - - - &- @-H- `-h-- - --- - - . ..0. H. X.`.x. . . ... . // / 8/ H/ `/h// / /// / / 00(0 @0 P0X0p0 0 0 000 0 011 01 @1 X1`1x1 1 111 1 1 2 2 2 (202H2 `2 p2x22 2 2 222 3 3 383 P3 `3 x333 3 333 3 4  4 (4 @4H4`4 x4 444 4 4 445 5 0585P5 h5 x5 5 555 5 556 6 (6 @6 H6 `6h66 6 666 6 6 77(7 @7 P7X7p7 7 7 7 777 7 88 8 88 H8 `8 h8 888 8 888 9 9 (909H9 `9 p9x99 9 9 9 999 :  :(:@: X: h: : : ::: : ::; ; 0; H;P;h; ; ;;; ; ; ; ;<< 0< @<H<`< x< < < < <<< < ==(= @= P= h=p== = === = = > > >8> P> `>h>> > > > > > > >>? (? 8?@?X? p? ? ??? ? ??@ @ (@ @@H@`@ x@ @@@ @ @ @@A A 0A8APA hA xA A (A A AAA BB (B 0B8B PB XB`B"hB pB xB B &B B B B B C C  C(C @C HCPChC C C C C C C (C D D DD0D HD XD`DxD D D D DDD D EE(E @E PE hEpEE E EEE E E FF0F HF XF`FxF F F FFF F GG G 8G HG `GhGG G GGG G G HH(H @H PHXHpH H H H H H HHH I  I(I@I XI hI III I III J J 0J8JPJ pJ JJJ J J J J KK K 8K HKPKhK K K KKK K KLL 0L @L XL `LhLL L LLL L L M M 0M8MPM hM xMMM M M MMM N (N0NHN `N pN N NNN N NNO O (O @O HO `OhOO O OOO O O PP(P HP XP`PxP P P P PPP Q QQ0Q HQ XQ pQ xQ QQQ Q QQQ R  R 8R@RXR xR RRR R R R RRS 0S @SHS`S xS S S S SSS S TT(T @T PT hTpTT T TTT T U U  U(U@U `U pUxUU U U U U U U VV V @V PVXVpV V V VVV V WW W 8W HW `WhWW W WWW W W XX0X PX `XhXX X X X X X XX X Y YY  Y copy_sheet Macro& Macro recorded 7/13/01Sheet1$B@Hb21$&B@H *B@,Selection.Paste LOT NUMBER 1 incentive$B@Hc23$&B@H (B@Sheet1$B@Hc23$&B@H *B@,Selection.Paste incentive$B@Hd21:d23$&B@H (B@Sheet1$B@Hd21$&B@H *B@,Selection.Paste LOT NUMBER 2 incentive$B@Hc27$&B@H (B@Sheet1$B@Hc27$&B@H *B@,Selection.Paste incentive$B@Hd25:d27$&B@H (B@Sheet1$B@Hd25$&B@H *B@,Selection.Paste LOT NUMBER 3 incentive$B@Hc31$&B@H (B@Sheet1$B@Hc31$&B@H *B@,Selection.Paste incentive$B@Hd29:d31$&B@H (B@Sheet1$B@Hd29$&B@H *B@,Selection.Paste LOT NUMBER 4 incentive$B@Hc35$&B@H (B@Sheet1$B@Hc35$&B@H *B@,Selection.Paste incentive$B@Hd33:d35$&B@H (B@Sheet1$B@Hd33$&B@H *B@,Selection.Paste LOT NUMBER 5 incentive$B@Hc39$&B@H (B@Sheet1$B@Hc39$&B@H *B@,Selection.Paste incentive$B@Hd37:d39$&B@H (B@Sheet1$B@Hd37$&B@H *B@,Selection.Paste LOT NUMBER 6 incentive$B@Hc43$&B@H (B@Sheet1$B@Hc43$&B@H *B@,Selection.Paste incentive$B@Hd41:d43$&B@H (B@Sheet1$B@Hd41$&B@H *B@,Selection.Paste incentive$B@He48:e49$&B@H (B@Sheet1$B@He48$&B@H *B@,Selection.Paste incentive$B@Hh48:h49$&B@H (B@Sheet1$B@Hh48$&B@H *B@,Selection.Paste incentive$B@Hk48:k49$&B@H (B@Sheet1$B@Hk48$&B@H *B@,Selection.Paste incentive$B@Hc51:c52$&B@H (B@Sheet1$B@Hc51$&B@H *B@,Selection.Paste!STEP #2 - Copy Data from "Sheet1"Sheet1$B@Ha1:m53$&B@H (B@ incentive$B@HSheet1$($o  STEP #1 - Paste Data to "sheet1"Sheets("Sheet1").SelectRange("a1:m53").SelectSelection.CopySheet1$($Sheet1$B@Ha1$&B@H *B@,ActiveSheet.PasteSelection.Paste#Step #2 - Paste Data to "incentive"Sheet1$B@Hd5:d6$&B@H (B@ incentive$B@Hd5$&B@H *B@,Selection.PasteSheet1$B@Hg5:g6$&B@H (B@ incentive$B@Hg5$&B@H *B@,Selection.PasteSheet1$B@Hi5$&B@H (B@ incentive$B@Hi5$&B@H *B@,Selection.PasteSheet1$B@Hi6$&B@H (B@ incentive$B@Hi6$&B@H *B@,Selection.PasteSheet1$B@Hk6$&B@H (B@ incentive$B@Hk6$&B@H *B@,Selection.PasteSheet1$B@Hh8:h9$&B@H (B@ incentive$B@Hh8$&B@H *B@,Selection.PasteSheet1$B@Hk9:k11$&B@H (B@ incentive$B@Hk9$&B@H *B@,Selection.PasteSheet1$B@Hd13:l14$&B@H (B@ incentive$B@Hd13$&B@H *B@,Selection.PasteSheet1$B@Hd17:l17$&B@H (B@ incentive$B@Hd17$&B@H *B@,Selection.PasteSheet1$B@Hd17:l17$&B@H (B@ incentive$B@Hd17$&B@H *B@,Selection.PasteSheet1$B@Hb21$&B@H (B@ incentive$B@Hb21$&B@H *B@,Selection.Paste LOT NUMBER 1Sheet1$B@Hc23$&B@H (B@ incentive$B@Hc23$&B@H *B@,Selection.PasteSheet1$B@Hd21:d23$&B@H (B@ incentive$B@Hd21$&B@H *B@,Selection.Paste LOT NUMBER 2Sheet1$B@Hc27$&B@H (B@ incentive$B@Hc27$&B@H *B@,Selection.PasteSheet1$B@Hd25:d27$&B@H (B@ incentive$B@Hd25$&B@H *B@,Selection.Paste LOT NUMBER 3Sheet1$B@Hc31$&B@H (B@ incentive$B@Hc31$&B@H *B@,Selection.PasteSheet1$B@Hd29:d31$&B@H (B@ incentive$B@Hd29$&B@H *B@,Selection.Paste LOT NUMBER 4Sheet1$B@Hc35$&B@H (B@ incentive$B@Hc35$&B@H *B@,Selection.PasteSheet1$B@Hd33:d35$&B@H (B@ incentive$B@Hd33$&B@H *B@,Selection.Paste LOT NUMBER 5Sheet1$B@Hc39$&B@H (B@ incentive$B@Hc39$&B@H *B@,Selection.PasteSheet1$B@Hd37:d39$&B@H (B@ incentive$B@Hd37$&B@H *B@,Selection.Paste LOT NUMBER 6Sheet1$B@Hc43$&B@H (B@ incentive$B@Hc43$&B@H *B@,Selection.PasteSheet1$B@Hd41:d43$&B@H (B@ incentive$B@Hd41$&B@H *B@,Selection.PasteSheet1$B@He48:e49$&B@H (B@ incentive$B@He48$&B@H *B@,Selection.PasteSheet1$B@Hh48:h49$&B@H (B@ incentive$B@Hh48$&B@H *B@,Selection.PasteSheet1$B@Hk48:k49$&B@H (B@ incentive$B@Hk48$&B@H *B@,Selection.PasteSheet1$B@Hc51:c52$&B@H (B@ incentive$B@Hc51$&B@H *B@,Selection.PasteSheet1$($oh Button 26 incentive$%2($ Button 27 incentive$%2($ Button 53combined$%2($ Button 54combined$%2($%ActiveSheet.Shapes("Button 3").SelectWith Selection.Locked = False.LockedText = FalseEnd Witho8 Button 26 incentive$%2($ Button 27 incentive$%2($ Button 53combined$%2($ Button 54combined$%2($oxStep #1 - Copy Data to "Sheet1"Sheet1$($combined$B@Hd5$&B@H (B@Sheet1$B@Had5$&B@H *B@,Selection.Pastecombined$B@Hd6$&B@H (B@Sheet1$B@Had6$&B@H *B@,Selection.Pastecombined$B@Hg5$&B@H (B@Sheet1$B@Hag5$&B@H *B@,Selection.Pastecombined$B@Hj5$&B@H (B@Sheet1$B@Haj5$&B@H *B@,Selection.Pastecombined$B@Hd8:l9$&B@H (B@Sheet1$B@Had8$&B@H *B@,Selection.Pastecombined$B@Hn6:n12$&B@H (B@Sheet1$B@Han6$&B@H *B@,Selection.Pastecombined$B@Hq6$&B@H (B@Sheet1$B@Haq6$&B@H *B@,Selection.Paste LOT NUMBER 1combined$B@Hb18$&B@H (B@Sheet1$B@Hab18$&B@H *B@,Selection.Pastecombined$B@Hc16:f18$&B@H (B@Sheet1$B@Hac16$&B@H *B@,Selection.Pastecombined$B@Hh16:i18$&B@H (B@Sheet1$B@Hah16$&B@H *B@,Selection.Paste LOT NUMBER 2combined$B@Hb22$&B@H (B@Sheet1$B@Hab22$&B@H *B@,Selection.Pastecombined$B@Hc20:f22$&B@H (B@Sheet1$B@Hac20$&B@H *B@,Selection.Pastecombined$B@Hh20:i22$&B@H (B@Sheet1$B@Hah20$&B@H *B@,Selection.Paste LOT NUMBER 3combined$B@Hb26$&B@H (B@Sheet1$B@Hab26$&B@H *B@,Selection.Pastecombined$B@Hc24:f26$&B@H (B@Sheet1$B@Hac24$&B@H *B@,Selection.Pastecombined$B@Hh24:i26$&B@H (B@Sheet1$B@Hah24$&B@H *B@,Selection.Paste LOT NUMBER 4combined$B@Hb30$&B@H (B@Sheet1$B@Hab30$&B@H *B@,Selection.Pastecombined$B@Hc28:f30$&B@H (B@Sheet1$B@Hac28$&B@H *B@,Selection.Pastecombined$B@Hh28:i30$&B@H (B@Sheet1$B@Hah28$&B@H *B@,Selection.Paste LOT NUMBER 5combined$B@Hb34$&B@H (B@Sheet1$B@Hab34$&B@H *B@,Selection.Pastecombined$B@Hc32:f34$&B@H (B@Sheet1$B@Hac32$&B@H *B@,Selection.Pastecombined$B@Hh32:i34$&B@H (B@Sheet1$B@Hah32$&B@H *B@,Selection.Paste LOT NUMBER 6combined$B@Hb38$&B@H (B@Sheet1$B@Hab38$&B@H *B@,Selection.Pastecombined$B@Hc36:f38$&B@H (B@Sheet1$B@Hac36$&B@H *B@,Selection.Pastecombined$B@Hh36:i38$&B@H (B@Sheet1$B@Hah36$&B@H *B@,Selection.Paste END OF LOTScombined$B@Hd40:d41$&B@H (B@Sheet1$B@Had40$&B@H *B@,Selection.Pastecombined$B@Hc43:c44$&B@H (B@Sheet1$B@Hac43$&B@H *B@,Selection.Pastecombined$B@Hm43:m44$&B@H (B@Sheet1$B@Ham43$&B@H *B@,Selection.Pastecombined$B@Hp43:p44$&B@H (B@Sheet1$B@Hap43$&B@H *B@,Selection.Paste!STEP #2 - Copy Data from "Sheet1"Sheet1$B@Haa1:ar45$&B@H (B@combined$B@HSheet1$($o= STEP #1 - Paste Data to "sheet1"Sheets("Sheet1").SelectRange("a1:m53").SelectSelection.CopySheet1$($Sheet1$B@Haa1$&B@H *B@,ActiveSheet.PasteSelection.Paste"STEP #2 - Paste Data to "combined"Sheet1$B@Had5$&B@H (B@combined$B@Hd5$&B@H *B@,Selection.PasteSheet1$B@Had6$&B@H (B@combined$B@Hd6$&B@H *B@,Selection.PasteSheet1$B@Hag5$&B@H (B@combined$B@Hg5$&B@H *B@,Selection.PasteSheet1$B@Haj5$&B@H (B@combined$B@Hj5$&B@H *B@,Selection.PasteSheet1$B@Had8:al9$&B@H (B@combined$B@Hd8$&B@H *B@,Selection.PasteSheet1$B@Han6:an12$&B@H (B@combined$B@Hn6$&B@H *B@,Selection.PasteSheet1$B@Haq6$&B@H (B@combined$B@Hq6$&B@H *B@,Selection.Paste LOT NUMBER 1Sheet1$B@Hab18$&B@H (B@combined$B@Hb18$&B@H *B@,Selection.PasteSheet1$B@H ac16:af18$&B@H (B@combined$B@Hc16$&B@H *B@,Selection.PasteSheet1$B@H ah16:ai18$&B@H (B@combined$B@Hh16$&B@H *B@,Selection.Paste LOT NUMBER 2Sheet1$B@Hab22$&B@H (B@combined$B@Hb22$&B@H *B@,Selection.PasteSheet1$B@H ac20:af22$&B@H (B@combined$B@Hc20$&B@H *B@,Selection.PasteSheet1$B@H ah20:ai22$&B@H (B@combined$B@Hh20$&B@H *B@,Selection.Paste LOT NUMBER 3Sheet1$B@Hab26$&B@H (B@combined$B@Hb26$&B@H *B@,Selection.PasteSheet1$B@H ac24:af26$&B@H (B@combined$B@Hc24$&B@H *B@,Selection.PasteSheet1$B@H ah24:ai26$&B@H (B@combined$B@Hh24$&B@H *B@,Selection.Paste LOT NUMBER 4Sheet1$B@Hab30$&B@H (B@combined$B@Hb30$&B@H *B@,Selection.PasteSheet1$B@H ac28:af30$&B@H (B@combined$B@Hc28$&B@H *B@,Selection.PasteSheet1$B@H ah28:ai30$&B@H (B@combined$B@Hh28$&B@H *B@,Selection.Paste LOT NUMBER 5Sheet1$B@Hab34$&B@H (B@combined$B@Hb34$&B@H *B@,Selection.PasteSheet1$B@H ac32:af34$&B@H (B@combined$B@Hc32$&B@H *B@,Selection.PasteSheet1$B@H ah32:ai34$&B@H (B@combined$B@Hh32$&B@H *B@,Selection.Paste LOT NUMBER 6Sheet1$B@Hab38$&B@H (B@combined$B@Hb38$&B@H *B@,Selection.PasteSheet1$B@H ac36:af38$&B@H (B@combined$B@Hc36$&B@H *B@,Selection.PasteSheet1$B@H ah36:ai38$&B@H (B@combined$B@Hh36$&B@H *B@,Selection.Paste END OF LOTSSheet1$B@H ad40:ad41$&B@H (B@combined$B@Hd40$&B@H *B@,Selection.PasteSheet1$B@H ac43:ac44$&B@H (B@combined$B@Hc43$&B@H *B@,Selection.PasteSheet1$B@H am43:am44$&B@H (B@combined$B@Hm43$&B@H *B@,Selection.PasteSheet1$B@H ap43:ap44$&B@H (B@combined$B@Hp43$&B@H *B@,Selection.PasteSheet1$($o&&Attribute VB_Name = "Module1" Sub copy_sheet_backup() <.Descriptionacro recorded 7/13/01 by Dan Boe0rnernUPr@ocDataaInvoke_Funca \n14!A' ' My  Sys("day (1)").Select C Before:=2End dbV7'Step #1 - "r to "#) ).VisiblTrue$incentiveZRangeg5:d6 5@jn.JB1Ac .Past?"E@?S&g5d:g&g5&QMiOLL Dsi_KLke~tkULh8:h9HD_9~F?_L!j_ k9:k1mnki&&dd13:l ?'?'h77 ''_|d1ρӿNC#b2/'A?`[  '0' LOT NUMBER 1kkkc23_onEo   wkvd21:d ! y 2)%Gc2?) /"d20 d #)s)33_4_4 c )29:d )x%L2e9>4 P?>d33 I(L?>5?_4_43 c3}h7 IJHHR64g c ?>{?>1>4g ?>>>ct Range("d41") .SeleActiveSheet.Paste D 'lionD  Bs("incende480:e490CopyYGO D@uHhNhN"NkNkN"Nc51:c52pvp''STEP #2 - Data from " '_a1:m|530Visible =` FalsB#E@nd Sub$uHb pA_d-()*616C6 to "s1" %'N6HTru 8 w b!teph8/t/&+/&sk9:k1'o&w_x k oߋ ? 413:l14 d1 f _d17 7 pH _  ?MSb2/'q+vqM;q' LOT NUMBER 1b -c2 a?@ _d21:d 2@O 2"c239 d20 02,7ܘ{)3"c3I==_;_d29:d eZ4))z)3 M ' She ets("p1").Select Range("d33:d35`ion.Copy incen0tive(AcJs.PasteFW LOT NUMBER 5c39i3!Vg7N(d37643RRĥ41:dq'"d4 'C'e48:e4zpzݡh@'h'"agzkkÖ8c51:c52( ??qVisible = pFals{@E@nd Subub buttons_off()% 1J)hape B" 26` ?n 2!7com`binedA!K5w4`@! '{S %= @'With F;  a'.Lockedg--Text'0 1n11Tru@>11"O& 5s])cP_data_page2'Step #1 - D` to B,E59??}Aad d '$& 673 ?{?{"aP=OK'END OF{S*"d40:d4?BO "aP{O O t?o\43:c4>/x43 $ m m r"aP p p ?8P 'STEP@ #2 -  Data froEnd Sub]ub p !_d _pagpe2()% A 1 to "s1"  U1:m5)HF$O ).G TrunJa9(O ô` v3@%R ::d>Xٿ d gR]] | g/  x //! | j   x    hC0d8:al9D@6 ݲs("combined").Select Range("d8ActiveSheet.Paste 'ion" B1an6:an122FCopyWEn6AFq*K K'z LOT NUMBER 1b1 ѲWG?Rac1yfO'yNah'iW'''z2z2bze=20:af@c20) `gcyh!~i?=?/=3#=`ab2_et)K=Aac24=)=hiah!i(=4?=4==3i_?}bJ==A8{ ta8{߄Tc~2;=\h2 i  2pb%=5O"ab3%fՙ+ c32 GȣpG]ah i)))p   6b33?3@߸p "ac3q((~#p i k222 3'END OFSo4o4d40d4)p|oNac43:@_>_)`OHEHp _)m m4 H3p Xap p r/)/)$)p  !)oG&Visible = Fals}End Sub +8#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 Sheet2 0Sheet3@Module2PModule3 ]'+8#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +8#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 s 8וxME Bx@p%Macro recorded 7/23/01 by Dan Boerner 14 J%Macro recorded 7/23/01 by Dan Boerner&B@ 14 Xh0`%Macro recorded 7/23/01 by Dan Boerner INST 14 ZPhI"   ,( X `h  @Xx && "( 0 8 ,P    & @X"` h p ,    &@Xx"   ,    0@(` Macro2 Macro$&& Macro recorded 7/23/01 by Dan Boernerday (1)$B@H *B@D day (1)$B@HB2$&B@Hday (1)$B@HAV9$&B@H "Shday (1)$B@HAT22$&B@H INSTRUCTIONS$B@HL23$&B@H INSTRUCTIONS$B@HSheeL20$&B@Hd5$ FB@Dday (1)$B@H$ day (1)$B@H$day (1)$B@H$ day (1)$B@ox Macro3 Macrod33& Macro recorded 7/23/01 by Dan Boernerion.day (1)$B@H *B@D ince FB@DB@Hday (1)$B@H$ day (1)$B@eeday (1)$B@HNPR *B@LTV FB@Lo Macro4 Macrod37:& Macro recorded 7/23/01 by Dan BoernerSheecombined$B@H FB@D *B@Dction.combined$B@H$ combined$B@$combined$B@HNPR *B@LTV FB@Lohh Macro4 Macro& Macro recorded 7/23/01 by Dan Boernere$ incentive$B@H(B@ FB@D *B@D$ incentive$B@H$  incentive$B@ incentive$B@HB@HNPR *B@LHTV FB@LouAttribute VB_Name = "Module2" Sub copy_sheet_02()  h.Descriptionacro recorded 7/23/01 by Dan BoernerfQProcData]Invok@e_Func] \n14=' ' Mj2z(  Sqs("day (1)").Sel ect Active.Un0prot Range("B2 (AV92T27INSTRUCT0IONS -D*L2630MWorkbookNHMove Before:=1oAhO oOCEXnd O3W3Bj3_letM8>??_@">>>Sub 5? number_to_be_rounded = 4 ` n  b b '`d ` n  'h h 't tnumber_to_be_rounded = 1 | b b b '`dXnumber_to_be_rounded = 2 | b b'`kkk `'^i Macro1 Macro$ Macro recorded 3/5/2003 by Boer1Dan]]](]@]X]p]]]]]]]'b b 'd b 'f `'| ` b'` ` ` 'n n5? ` n  b'`number_to_be_rounded = 3d8 n55? number_to_be_rounded = 4 ` n  b b '`d ` n  'h h 't tnumber_to_be_rounded = 1 | b b b '`d(number_to_be_rounded = 2 | b b'`kkk `'~i0 Macro1 Macro$ Macro recorded 3/5/2003 by Boer1Dan]]]]]]] ]8]P]h]]]'b b 'd b 'f `'| ` b'` ` ` 'n n5? ` n  b'`number_to_be_rounded = 3d n55? number_to_be_rounded = 4 ` n  b b '`d ` n  'h h 't tnumber_to_be_rounded = 1 | b b b '`dnumber_to_be_rounded = 2 | b b'`kkk `'ip Macro1 Macro$ Macro recorded 3/5/2003 by Boer1Dan](]@]X]p]]]]]]]]0]H'b b 'd b 'f `'| ` b'` ` ` 'n n5? ` n  b'`number_to_be_rounded = 3d n55? number_to_be_rounded = 4 ` n  b b '`d` ` n  'h h 't tnumber_to_be_rounded = 1 | b b b '`dnumber_to_be_rounded = 2 | b b'`kxkpkh `'i@8سAttribute VB_Name = "Module3" Function mndot_rounding_3(number_ to_be.ed As Doub@le) ' Macro1  record^3/5/2003 by Boer1Dan& Dim posi{cInteger &onight"two_r"digit4q |'8-xMEh ^@ 3i``b$`d`f`hMacr`jy Da`l 14`n`p`r`t`v`x`z ~0 3i``b`d`f`h`j`l`n`p`r`t`v`x`z p 3i``b`d`f`h`j`l`n`p`r`t`v`x`z  3i``b`d`f`h`j`l`n`p`r`t`v`x`zB    *( X`hpx    08P p  6(8 @:` &     (B 0 8 @ *X   (08P `h   68@Xh p: &  (0 8@ H PXB ` h p *   (08H X`h    60hp :  &( P  X ` h p x   B    *         ( 0 8 @ H P X ` h x           ( @ 6`      : 0 8 &X            Macro1 Macro$ Macro recorded 3/5/2003 by Boer1Dan 7/23/]`]x]]]]]]] ]8]P]h]'b b 'd b 'f `'| ` b'` ` ` 'n n5? ` n  b'`number_to_be_rounded = 3dh n5寗0/remainDftest_if_0evenGis2_hodʊtrate_J*as_sngSB(of_decimal~n`= 3 GS=qz+ 1 Go 2!hold7= sD4ʪ Q@* (10 ^)@D x - eRIf-< 0.49 TheM R.= -) / ' `<aElse . >501u4 A!!Lt!) +%&:)eO$䊠!S 10$ '= Aj)m:gQU8|U9AhI}t>99{}9!5 ,?  ? _{ End If$5u_͂_U`edZ{/%2/!//ro///c&/_^/%6 J/t#cz/on_h _gw@ /o /^g//r$/n!= p5/)/s/)!+P,//$ <dT66/ yg/AA // Y S3/4o h /?3/{K!/d)T ?j>/k /;B/od5//--0Z(/A)/< z Q number_to_be_rounded = Int(hold_| * (10 ^ position `)) /@ End8 If #' @ mndoti0ng_2 +9Func  "1(! As Double)' Mac8ro1  recor3/5/2003 by Boer1DanDim1@eger oBnighttwo_rdigitς WDKremaina"LL3test_if_eveFn#is_4o$ddtrwateEm T*as_str*SB(of_decim501iu>4 !!Lt!) +ฝ:)eO$?䊠̠SMopd 10$ '= Aj)m:gQU8|UTM&9 Ã/erJJOn< Ye? _͂_UZ/-0ϯ///ro///r/l pˋ?6M/u#c /ѩ/g/'w@ /o /g//r$6 /'OpR/s/d+ ;P,//t dT B/ yg/A@RI::/?v Sq= /4o h /?3/((!Sp\/T ?j>/k /;B/Њp/  /number_to_be_rounded = Int(hold_ * (10 ^ position )) /@ +>H Else!'26̀BEnd8 If ' @ mndoti0ng_0_ Func Sheet4 _VBA_PROJECT:dirPROJECTwm8/#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2F-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.3#0#C:\Program Files\Microsoft Office\Office\EXCEL9.OLB#Micros0* pHd VBAProject4@j = r 9@ J< rstdole>stdole f%\*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\SYSTEM\Sc2.tlb#OLE Automation^DOffi cDO>fijcDD2DF8D04C-5BFA-101@B-BDE5DAjAB42Dgram Files\MicrosPoft 6\MSO9.DLL#  9.0 Ob LibraryC 8Sheet6GShE^e62UHB1k1B,"B+BBThisWorkbookG@T@isWqrkboZ 2 $=$ $@ Module1GhduB1A2OOBI!EBB^G^GM^1Q^K9F2Mz2Iz22 3 j3 3 3 "K 48A8y 8ו8 q-T-tG4m+4i+4m+4p+%0d/iGV8 SheeThisWorkbookThisWorkbookModule1Module1Sheet1Sheet1Sheet2Sheet2Sheet3Sheet3Module2Module2Sheet6Sheet6Sheet4Sheet4Module3Module3e1I0 Sheet1ID="{1F75FABE-6F2B-11D5-8554-0010A4C41388}" Document=ThisWorkboPROJECTSummaryInformation(DocumentSummaryInformation8@CompObjfok/&H00000000 Module=Module1 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Module=Module2 Document=Sheet6/&H00000000 Document=Sheet4/&H00000000 Module=Module3 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="F6F44997499F69A369A369A369A3" DPB="1A18A5F3C8F4C8F4C8" GC="3E3C81DF8127A428A4285B" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Module1=88, 88, 609, 451, Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C Module2=110, 110, 631, 473, Sheet5=0, 0, 0, 0, C Sheet6=0, 0, 0, 0, C Sheet4=0, 0, 0, 0, C Module3=132, 132, 465, 578, OfficeuSheet6 _Evaluate TOh+'0HP`l Default faMicrosoft Excel@e@Z>O@ȝд+Wcopy_data_page2pasteam  *\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.3#0#C:\Program Files\Microsoft Office\Office\EXCEL9.OLB#Microsoft Excel 9.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\Stdole2.tlb#OLE Automation *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.1#0#C:\Program Files\Microsoft Office\Office\MSO9.DLL#Microsoft Office 9.0 Object Library   9@8 Sheet60@463f2acc Sheet61ThisWorkbook0A463f2accThisWorkbook=Module10B463f2accModule1I0 Sheet10C463f2acc; Sheet1H1 Sheet20D463f2acc= Sheet2`1 Sheet30E463f2acc? Sheet3x1Module20F463f2acc@Module2וy Module30G463f2acc\Module3-- Sheet40H463f2acc Sheet4/%0xH`G]@K?*D1A eJ-r.S"U/yCQf~zD[>t#2}I*~pѵGKp'#,7OE"sIǜk A%cdJw E1!\ BC.Excel+VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuSheet6 _Evaluate ThisWorkbook|Module1bcopy_sheet_backupGSheets CopyƿBefore copy_dataOVisibleRange  SelectionZ ActiveSheet%NPaste paste_data-: buttons_offShapes< buttons_on+Wcopy_data_page2paste_data_page2Sheet1Sheet2Sheet3Module2c copy_sheet_02 Unprotect?ActiveWorkbookMove>y copy_sheet_03ProtectfDrawingObjectsߺContents= Scenariosk StructuredzWindowsd copy_sheet copy_sheet_04Module3dmndot_rounding_3bnumber_to_be_rounded<position_to_be_rounded#~position_one_right~position_two_right86digit_to_rounddigit_one_right digit_two_rightnumber_remaining_to_rightposition_test_if_evendigit_test_if_even is_it_odd>truncate_numbernumber_as_stringsposition_of_decimal& hold_numberMmndot_rounding_2bmndot_rounding_1bmndot_rounding_0bSheet4=?A ;  ]՜.+,0 PXd lt| U  Version I Version IISplit Production INSTRUCTIONSINSTRUCTIONS OLD  Worksheets FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q