70 likes | 196 Views
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”
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.