NDOT Asphalt Calculator User Manual
Contents
1. Pressing Begin Calculator button 3 will begin with data gathering pertaining to your project The first question box will ask whether you need to view the Asphalt Zone Map screen below in order to determine which Asphalt Zone the project is in BG ae Mk L DERARTIMIENT 4 OF TRANSPL lino N LT NE CEDATISION B e Ta magi r BI Do You Need to View Asphe Map before Making Selection A Start Te Cp aeroganiWonk ee laat zaleas Mar IZ raaro Nap IG aK ae occu The default is No so pressing the enter key will allow you to continue If you press Yes you will be taken to the Asphalt Zone Map as shown below MAINTENANCE DISTRICTS and AB Gin SO 10 06am After determining the proper Asphalt Zone either select the OK button or press the enter key on your keyboard and you will return to the Main Screen and the program will continue as seen below Zat 6 KJ G6060ganlwORK FR lata sais Mar is Pri Z Napo IG aK 756 teem This box is where you will enter the Asphalt Zone After entering a number either click on OK or press the enter key on your keyboard If you enter a number which is not an Asphalt zone the program will clear the box and ask for a correct zone number as shown below K 4 Ba DRR ANNL KINAIN IP Ear SR Stort DW LI GWB080pamiWORK BR lata salas Mar ja rE IG aK ao 666 As shown above Z2. enter and the date will be filled out as shown below 65 AspnattericeCatcutatorats Compatibility Made Microsoft Dice PROJECT SPECIFIC INFORMATION SELECT PRODUCT CRS 2nv ANTICIPATED CHARGES UNLOADING REQUIRED Yes No PUMPING REQUIRED Yes No SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA Program Rewsion Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 ANTICIPATED QUANTITY NEEDED __ ES AspnanPriceCaiculatorats Compatibility Mode Microsoft Decet PROJECT SPECIFIC INFORMATION SELECT PRODUCT ANTICIPATED CHARGES UNLOADING REQUIRED Yes No a SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA BENCHMARK PRICES CURRENT PRICE ANTICIPATED DELIVERY DATE S X Program Reasion Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 ANTICIPATED QUANTITY NEEDED gt ESCALATION As of Today s Date sei nor LRS 859028 SOUTH 62167 Enter the approximate number of tons needed In this case 23 tons has been entered to demonstrate the Short Ton calculation shown later IY Asphatterice Calculator LIQUID and EMULSIFIED ASPHALT PRE ORDER INFORMATI
3. addressed during Invoicing OIL PRICING DATA BENCHMARK PRICES CURRENT PRICE ESCALATION As fT Date NORTH The spreader box has disappeared The Continue to Vendor Prices button must be clicked to continue ara 0 VENDOR PRICING SELECTION Disie F1 saptakzone 8 Product __ORS 2nv of Spreaders Needed 2 AstLow Bidder 1st Low Bidder Project cos TS 7 Anticipated Delivery Date Anticipated Quantity 2500 Tons J 1 Company did not meet Minimum Order Requirements Current Price Unload Charge Pump Charge Spread Charge Overnight Charge Short Load Charge Project Cost 20 087 00 Zas DW Cp aiprceoganiworkee G Aschat Caloustor Manu fx reh tecet asp Orig Price Current Price Current Price Unload Charge Pump Charge Spread Charge Overnight Charge Short Load Charge 4th Low Bidder Project Cost 26 5th Low Bidder Project Cost ESP EC parang Using the information provided the Vendor Pricing Selection screen appears A prompt box reminding you to select a bidder shows up and clicking OK or pressing the enter key will remove it from the screen IX Aspnanpricecatcutatoratt Compatibility Made Microsoft Becet APR 0 owe AsphaltZone 5 product asa TJ of Spreaders Needed 2 Anticipated Delivery Date Anticipated Quantity June 2 2012 23 00 Tons 1 Company did not meet Minimum Order Requirements VENDOR PRICING SELE
4. CTION AstLowBidder 1st Low Bidder Project cost HI Pandtowsidder 7 Paas Project Cost 17 431 58 J Spread Charge Overnight Charge Short Load Charge marane PS OY Project Cost 52008700 stat JE LIGWOpamIWORK er J 2 Asphak Calodator Maru lG Microsoft rar ad Asp Spread Charge Overnight Charge Short Load Charge 4th Low Bidder Project Cost 25 Orig Price Current Price Unload Charge Pump Charge Spread Charge Overnight Charge Short Load Charge CamLowblader Te Project Cost Today s Date 571612 Program Renson Date 14 20 Price Revision Date 519 201 GE aR 3 49 mean All the information entered is shown along with the Vendors ranked by project cost The Short Load Charge on the above screen for one 1 ton less than the 24 ton limit is compared with the screen below showing two 2 tons less The spreader charge is dependent on the number of spreaders requested ES Aspnanericecatcutatorats Compatibility Mode Microsort bro ox 1 Company did not meet Minimum Order Requirements Showing two 2 tons less than the 24 ton short load limit GG Aonatoncecatcutatoratt Compatibility Mode Microsont tae x 1 Company did not meet Minimum Order Requirements Clicking the Clear amp Return button will produce a prompt making sure that is what you want to do because it will clear all information and return to the main scree
5. DERARTIMIENT 4 OF TRANSPG lino 4 po AG CRDIMIBION LT Zaut DW Pe FEY aha Caistor Mar ne ma Sre Tela Once returned to the Main screen click the Exit Program button to exit After the program exits click the x in the upper right hand corner to exit Excel Clicking the x will exit from Excel
6. NDOT Asphalt Calculator User Manual The program will open and should encompass the entire screen as viewed below VADA DERARTIMENTIOP TRANSPORTATION c07 VIAINTENANCE DIVISION DB Gin Camera T start IG L j Fo Asphalt Calculator Manu j S Microsoft rar ad asp Pressing View Asphalt Prices button 1 will take you to the Asphalt price Index Screen as shown in 1 below Asphalt prices as determined from Potens for each period listed is shown along with any escalation percentage Pressing the Return to Main button will return you to the present screen Pressing the View Asphalt Zone Map button 2 will take you to the NDOT Asphalt Zone map Screen developed by the Maintenance Division as shown in 2 below Pressing the Return to Main button will return you to the present screen 1 Asphalt Price Index Screen KG apa ny rn eer are nx INIT MAINTENANCE DIVISION ASPHALT PRICE INDEX BEEEEEEBEBEEEoE cin The inda Maprek Pree reo 6 n adeber by MOOT Wartenace aNG Opiate Oso Na PG Going pce TE Fone ares The eo reet cost based the saling pace te Pa Las Vegas area The Navada aat Pace adi be Ng erage c ia baling pace tor each Pacey daring Be oec fad parad CSR TETS R K 06 nzm 2 Asphalt Zone Map Screen IC anse peste m rawan Hane stone tet See eae Sei OBS K 4 K L DERARTIMIENT 4 OF TRANSPG RiTo ie ma 7 PN NG EDITION 2 EIT TT Gran Ler
7. No ANTICIPATED DELIVERY DATE ANTICIPATED QUANTITY NEEDED Enter Approximate Date and Tons of product needed Doesn t need to be exact pei ee T e SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA ESCALATION BENCHMARK PRICES CURRENT PRICE As of Ti Date NORTH 0 00 Clicking in the Select Product box will produce a drop down symbol Clicking the drop down arrow will produce a list of products to choose from as seen below 5 Aspnattpricecatcutatorats Compatibitity Mode Microsoft Lare xX Program Reasion Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 UNLOADING REQUIRED iro ase IPATED DELIVERY DATE ANTICIPATED QUANTITY NEEDED Enter Approximate Date and Tons of product needed Doesn t need to be exact PUMPING REQUIRED Yes isd TONS SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA BENCHMARK PRICES CURRENT PRICE As fT Date NORTH 618 34 Highlight a product and click your mouse button to select 65 AspnattericeCatcutatorats Compatibility Made Microsoft Dice Program Reasion Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 PROJECT SPECIFIC INFORMATION SELECT P
8. ON Program Revision Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 APR 0 DISTRICT 1 ASPHALT ZONE 5 PROJECT SPECIFIC INFORMATION SELECT PRODUCT CRS 2nv ANTICIPATED CHARGES UNLOADING REQUIRED Yes No ANTICIPATED DELIVERY DATE PUMPING REQUIRED Yes No 6 2 2012 TONS SPREADERS REQUIRED Yes No ANTICIPATED QUANTITY NEEDED OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA BENCHMARK PRICES CURRENT PRICE ESCALATION As of Today s Date 581 11 NORTH 618 34 0 00 Kao anal 590 28 SOUTH 621 67 0 00 Es GS GINOO ics an Start I A LI GWBES0pamIWORK ee E Asphat Calculator Manu FT erer read asp The Anticipated Charges section is where these are selected if needed In the screen above the Unloading has been selected to show that when Yes is selected No is removed and visa versa If Spreaders are needed select Yes and a box shown below will appear where the number of spreaders needed can be entered AtohaitPriceCalculatoratt Compatibility Mode Microsoft Excet PROJECT SPECIFIC INFORMATION SELECT PRODUCT ANTICIPATED CHARGES UNLOADING REQUIRED Yes No PUMPING REQUIRED Yes No SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED
9. RODUCT CRS 2nv ANTICIPi La UNLOADING REQUIRED Yes ANTICIPATED DELIVERY DATE ANTICIPATED QUANTITY NEEDED Enter Approximate Date and Tons of product needed Doesn t need to be exact PUMPING REQUIRED Yes sd TONS SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA BENCHMARK PRICES CURRENT PRICE As AT Date worTH 616 34 As seen CRS 2nv has been selected 5 Aspnattpricecatcutatorsts Compatibitity Mode Microsoft are x Program Reasion Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 PROJECT SPECIFIC INFORMATION SELECT PRODUCT RRR ANTICIPATED CHARGES METADO DELIVERY DATE ANTICIPATED QUANTITY NEEDED UNLOADING REQUIRED Yes No imate Date and Tons of product needed Doesn t need to be exact PUMPING REQUIRED Yes TONS SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA BENCHMARK PRICES CURRENT PRICE ESCALATION As cf Today s Date NORTH 500 28 soum Daj QB Gamma R cat e raa ecet asp Click your mouse in the Delivery Date box and type the approximate date product will be needed All that is necessary is for a month and day Either click outside the box or press
10. Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA BENCHMARK PRICES Program Revision Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 ANTICIPATED QUANTITY NEEDED 2m L IR AconaiPricecaicutatorats Compatibility Madel Microsoft Becet x Program Reasion Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 PROJECT SPECIFIC INFORMATION SELECT PRODUCT AN CHARG UNLOADING REQUIRED Yes No ANTICIPATED QUANTITY NEEDED PUMPING REGURED Yes no an rows SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be addressed during Invoicing OIL PRICING DATA BENCHMARK PRICES CURRENT PRICE As fT Date UU 888141 NORTH 618 34 Here two 2 spreaders are entered Click OK or hit enter and the box will disappear 5 Aspnamtpricecatcutatorats Compatibitity Mode Microsoft Lare xX Program Reasion Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 PROJECT SPECIFIC INFORMATION SELECT PRODUCT ANTICIPATED CHARGES UNLOADING REQUIRED Yes No ANTICIPATED DELIVERY DATE ANTICIPATED QUANTITY NEEDED Seas ro SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best guesses to estimate Project Costs actual charges will be
11. n to begin again 55 Aspnamtpricecatcutatorats Compatibitity Mode Microsoft Dicet ox 1 Company did not meet Minimum Order Requirements dolga Maru FX microsoft raad asp Selecting a purple bidder button will select that bidder s information to be sent to the next screen shown below This is the deliver request or Order Form screen showing the bidder selected and all other pertinent information about the project The Clear amp Return button will clear everything and return you to the Main screen so you must click OK if that is truly what you want to do 55 Aspnamtpricecatcutatorats Compatibitity Mode Microsoft Dicet TOR 1 Company did not meet Minimum Order Requirements This screen and the next merely shows that selecting the bidder button below the one desired will transfer their individual information to the Order Form l On the Order form in the Comments box this area can be selected and any information pertinent to the project can be typed cbi Unfortunately at this time the email function does not work A box will appear letting you know that the screen must be printed and scanned or sent in some other manner Clicking either OK or Cancel produces the same result as does pressing your enter key The box disappears and the screen remains To get back to the Main screen click the Clear amp return button A box like before must be okayed f w ow ba L
12. one 9 has been entered which is not a valid Zone number K 4 Ko RRIT MEN pay kal PG Enter a Vakd Asghak Zone between 1 and 6 Zat DB KJ e60ganlwORK ne lata salas Mar ja Rg IG aK ae asan The box has cleared and asks again for a valid Zone number K 4 Ba BIE PARTIMEN Lf cS ee SR Enter a eee 4 E O T EIT oR EY Asbak catat Gg R As shown Zone 5 has been entered w Pi ri y Hr RRR EN TET TRANSPO A TAT 4 T CEDON 9 AD Start J Ca Gieton WORK ER lata zaleas Mar is Pace a IG Gio AO toa The next information is regarding an APR number The default is No so if there is no APR yet just hit the enter key If there is an APR select the Yes button and a box will appear asking for the number to be entered as shown below BG ae Mi Nlng DER AYR NN ney ogi 7 ra ER Tron GAO Ps ter Bet DW L GW6E0panIW00KER EN ahat car Mar Pacrondt cel asp EN If you selected Yes and there is no number that is okay Just enter a zero 0 in the box and click OK or press enter as shown below K 4 A H DRR TEN MLAN Lf cS eee SR Start 9 Cpe veedpent WORK ER laat Cleator Mar IZ skn Og aK SO tom A zero 0 has been entered above LIQUID and EMULSIFIED ASPHALT PRE ORDER INFORMATION APR 0 DISTRICT 1 ASPHALTZONE 5 PROJECT SPECIFIC INFORMATION Program Revision Date 5 14 2012 Price Re
13. vision Date 5 9 2012 Today s Date 5 16 2012 SELECT PRODUCT bagay nani ANTICIPATED CHARGES UNLOADING REQUIRED Yes No ANTICIPATED DELIVERY DATE ANTICIPATED QUANTITY NEEDED Enter Approximate Date and Tons of product needed Doesn t need to be exact PUMPING REQUIRED Yes No TONS SPREADERS REQUIRED Yes No OVERNIGHT REQUIRED Yes No These are best quesses to estimate Project Costs actual charges will be addressed during invoicing OIL PRICING DATA BENCHMARK PRICES CURRENT PRICE ESCALATION As of Today s Date 581 11 NORTH 618 34 0 00 Kao acl 590 28 SOUTH 621 67 0 00 Eee Tat A L E Asphalt Caloustor Maru x Microsoft brcel Asp This is the screen that shows up next As can be seen Asphalt Zone is 5 and it knows that zone 5 is in District 1 the APR number is zero 0 the The Benchmark Price for asphalt is shown for the North and the South regions The Current Asphalt Prices are also shown for the North and the South If escalation is effect after a 10 change the percentage amount of escalation will be displayed under Escalation 33 GINOO tora ES Aspnanpricecatcutatorats Compatibility Medel Microsoft bre ox Program Reasion Date 5 14 2012 Price Revision Date 5 9 2012 Today s Date 5 16 2012 PROJECT SPECIFIC INFORMATION SELECT PRODUCT Fest Prous ANTICIPATED CHARGES UNLOADING REQUIRED Yes
Download Pdf Manuals
Related Search