Grid INPUT The “Grid INPUT” tab is intended for advanced users that wish to analyze a specific portion of a vehicle (e.g. a specific axle on a vehicle) or a custom vehicle type with a footprint (or ground contact area) which cannot be analyzed using one of the specific vehicle type tabs. The input field descriptions for this tab are listed below. Appendix A provides further instructions for using the “Grid INPUT” tab. Vehicle Information – In Cell E4 enter pertinent information about the vehicle (brand, model, year, etc.). Vehicle Type – In Cell E5 enter pertinent information about the vehicle type (Wheel, Track, 3-Axle, etc.). Measurement Point X-coordinate – In Cell F11 enter the X-coordinate of the location where the program will calculate the pressure exerted on the surface of the pipe due to the vehicle load. Measurement Point Y-coordinate – In Cell F12 enter the Y-coordinate of the location where the program will calculate the pressure exerted on the surface of the pipe due to the vehicle load. Load (column of values) – In Column I, starting at Cell I12 enter the user defined array of point loads representing the custom vehicle foot print. X & Y (column of values) – In Column J and K, starting at Cell J12 and K12 enter the user defined array of X-Y-coordinates corresponding to the array of point loads listed in Column I, which represent the location of each point load in the custom vehicle foot print. After all input fields on the “General INPUT” tab and desired vehicle type tab have been populated, click the corresponding vehicle type “CALCULATE:” button to run the analysis. Each vehicle type tab includes a “CALCULATE:” button that runs the program analysis for that specific vehicle type. Appendix B gives a complete list of all the worksheet tabs and corresponding functions (or buttons) that reside on each tab. NOTE: An error check is performed prior to the program initiating subroutines. If there is an issue with how an input has been entered, an error message will pop up alerting the user as to which input cell is causing the issue. – Once the program has finished running, it will automatically bring up the “Results” tab, which will display an overview of the user inputs along with the results of the analysis calculated by the program.
Grid INPUT The “Grid INPUT” tab is intended for advanced users that wish to analyze a specific portion of a vehicle (e.g. a specific axle on a vehicle) or a custom vehicle type with a footprint (or ground contact area) which cannot be analyzed using one of the specific vehicle type tabs. The input field descriptions for this tab are listed below. Appendix A provides further instructions for using the “Grid INPUT” tab. Vehicle Information – In Cell E4 enter pertinent information about the vehicle (brand, model, year, etc.). Vehicle Type – In Cell E5 enter pertinent information about the vehicle type (Wheel, Track, 3-Axle, etc.). Measurement Point X-coordinate – In Cell F11 enter the X-coordinate of the location where the program will calculate the pressure exerted on the surface of the pipe due to the vehicle load. Measurement Point Y-coordinate – In Cell F12 enter the Y-coordinate of the location where the program will calculate the pressure exerted on the surface of the pipe due to the vehicle load. Load (column of values) – In Column I, starting at Cell I12 enter the user defined array of point loads representing the custom vehicle foot print. X & Y (column of values) – In Column J and K, starting at Cell J12 and K12 enter the user defined array of X-Y-coordinates corresponding to the array of point loads listed in Column I, which represent the location of each point load in the custom vehicle foot print. After all input fields on the “General INPUT” tab and desired vehicle type tab have been populated, click the corresponding vehicle type “CALCULATE:” button to run the analysis. Each vehicle type tab includes a “CALCULATE:” button that runs the program analysis for that specific vehicle type. Appendix B gives a complete list of all the worksheet tabs and corresponding functions (or buttons) that reside on each tab. NOTE: An error check is performed prior to the program initiating subroutines. If there is an issue with how an input has been entered, an error message will pop up alerting the user as to which input cell is causing the issue. – Once the program has finished running, it will automatically bring up the “Results” tab, which will display an overview of the user inputs along with the results of the analysis calculated by the program.
0387-1301-FINAL-CEPA-Surface-Loading-Calculator-User-Manual.docx