1 / 46

Asphalt Plant Worksheet

Asphalt Plant Worksheet. The New & Improved. APW Worksheet & Database. To obtain a blank excel and/or access file of the APW, you can download them from our website at: http://www.dot.state.fl.us/statematerialsoffice/pavement/asphalt/fieldoperations/worksheets/worksheetshome.shtm

owena
Download Presentation

Asphalt Plant Worksheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Asphalt Plant Worksheet The New & Improved

  2. APW Worksheet & Database • To obtain a blank excel and/or access file of the APW, you can download them from our website at: http://www.dot.state.fl.us/statematerialsoffice/pavement/asphalt/fieldoperations/worksheets/worksheetshome.shtm • The APW.xlsm (excel file) and APW.mdb (access file) need to be saved with the same name and in the same location on your computer.

  3. Project Information Sample Header Information

  4. Single Sample Login Information (Header) & Menu Options No More LIMS Spec “200207” and Spec Authority “Std Spec 334”

  5. Project ID & Pay Item

  6. Plant

  7. Mix Design No.

  8. Main Menu Options Upload / Save / Load / PDF / Mix Summary Report / Clear

  9. OLD NEW

  10. Upload to LIMS

  11. Upload to LIMS – Test Validation

  12. Save Samples

  13. Load Samples

  14. Load Sample Header

  15. PDF

  16. Mix Summary Report

  17. Mix Design Summary Report

  18. Clear Menu Clears only the worksheet data, leaves header information. Clears all worksheets and all data. Clears all worksheets, all data, refresh lists, and saves the excel file.

  19. Other Menu Options Help / Configuration / Sample Numbers / Comparison Reporting

  20. Help & Configuration Buttons

  21. Sample Numbers • At least one sample needs to be loaded into the worksheet before using the ‘Sample Numbers’ function • ‘Sample Numbers’ is a function for QC, PC, and IV sample levels only

  22. Comparison Reporting • Prior to click on the Comparison Reporting button, you need to have run the Mix Summary Report for a specific project number.

  23. Any Questions on the Header?

  24. Data Entry Changes Test Data and Sample Levels

  25. QC Samples

  26. Comments & CPF Summary Limit Comments to 60 characters. You can enter your LIMS ID number here when you receive the message from LIMS and it will save with your sample.

  27. Roadway Gmb & Volumetrics

  28. Full Sample Upload • If all data – plant and roadway cores – upload complete sample into LIMS.

  29. Separate Core Data Upload • Option to upload Roadway core data after your plant data.

  30. Separate Core Data Upload

  31. Separate Core Data Upload

  32. Separate Core Data Upload

  33. Separate Core Data Upload The good kind of error?!

  34. V Samples

  35. V Samples – No Resolution

  36. V Sample with Resolution

  37. Lot Info & Random Numbers Limit Comments to 60 Characters

  38. CPF Worksheet BEFORE AFTER Limit Comments to 60 Characters

  39. Auto-Fill CPF Worksheet

  40. IV Samples

  41. IV Report

  42. IV Comparisons

  43. Importing PC Split Sample Data

  44. Contact Jenni Philpott Jenni.Philpott@dot.state.fl.us (352) 955-1838 Victor Marik (PM) Victor.Marik@dot.state.fl.us (352) 955-2932 Tanya Nash Tanya.Nash@dot.state.fl.us (352) 955-2903

More Related