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. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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 • 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.
Project Information Sample Header Information
Single Sample Login Information (Header) & Menu Options No More LIMS Spec “200207” and Spec Authority “Std Spec 334”
Main Menu Options Upload / Save / Load / PDF / Mix Summary Report / Clear
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.
Other Menu Options Help / Configuration / Sample Numbers / Comparison Reporting
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
Comparison Reporting • Prior to click on the Comparison Reporting button, you need to have run the Mix Summary Report for a specific project number.
Data Entry Changes Test Data and Sample Levels
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.
Full Sample Upload • If all data – plant and roadway cores – upload complete sample into LIMS.
Separate Core Data Upload • Option to upload Roadway core data after your plant data.
Separate Core Data Upload The good kind of error?!
Lot Info & Random Numbers Limit Comments to 60 Characters
CPF Worksheet BEFORE AFTER Limit Comments to 60 Characters
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