70 likes | 211 Views
This guide provides detailed instructions for utilizing the D-15 calculator as outlined by Foutch, Stringham, & Vengu (2011). Open the "EXCEL_D15_Calculator.xls" file and navigate to the "Errors Only" tab. Follow the sorting process for D-15 panels: select data, sort by column A, and use custom lists to input your panels one at a time. After completing your entries, view the D-15 arrangement graphic and the summary table, which includes raw and modeled indices. Ensure no duplicates are present, as the file lacks a check for completeness.
E N D
D-15 Calculator Based on: Foutch, Stringham, & Vengu JMO, 2011
Ground rules 1. Open “EXCEL_D15_Calculator.xls” 2. Work in the “Errors Only” tab
Sorting the D15 panels 2. Select “Data” 1. “Grab” A3:C17
Sorting the panels (cont’d) Choose drop-down menu under “Order” - Ensure the following: -- Sort by: Column A -- Sort On: Values 3. Select “Sort” box
Sorting the panels (cont’d) 5. Choose “Custom List” under Order 6. Enter the panels one at a time…then “Add”…then “OK”
Sorting the panels (cont’d) 7. After entering all panels (there is no “check” for completeness or duplicates in this Excel file)…hit “OK”
Sorting the panels (cont’d) 8. You are done! The first “useful” graphic is the D-15 arrangement. 9. Here’s your summary table. It contains the “raw” and “modeled” indices.