Spreadsheet: 79223d1279525733-how-to-draw-a-graph-using-given-values-and-determinating-the-source-of-formulas-datas
Sheet: REVISED DATA LAYOUT

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HI | LOW | [NAME] HI | SPEC LOW |  | Plot high [NAME] Head [NAME] | Plot low [NAME] Head [NAME] | Plot high head height | Plot low [NAME] | Plot high bolt head dia | Plot low bolt head dia | UPPER LIMIT | LOWER LIMIT
1 | 2010-05-17 00:00:00 | R4,2x45 | Diameter of bolt's head | 11.73 | 11.7 | 11.73 | 11.71 | 11.75 | 11.67 | 11.73 | 11.72 | 11.69 | 11.7 | 11.75 | 11.73 | 11.67 | 11.74 | 11.69 | 11.69 | 11.72 | 11.77 |  |  | 12 | 10 |  |  |  |  |  |  |  | 0.75 | 0.25
1 | 2010-05-17 00:00:00 | R4,2x45 | Head's height | 2.97 | 2.94 | 2.92 | 2.91 | 2.97 | 2.95 | 2.92 | 2.89 | 2.94 | 2.95 | 2.97 | 2.92 | 2.94 | 2.95 | 2.94 | 2.96 | 2.94 | 2.97 |  |  | 4 | 2 |  |  |  |  |  |  |  | 0.75 | 0.25
1 | 2010-05-17 00:00:00 | R4,2x45 | Diameter of rod | 3.34 | 3.34 | 3.35 | 3.35 | 3.34 | 3.34 | 3.35 | 3.34 | 3.35 | 3.36 | 3.35 | 3.36 | 3.34 | 3.35 | 3.35 | 3.34 | 3.35 | 3.34 |  |  | 3.5 | 3.25 |  |  |  |  |  |  |  | 0.75 | 0.25
2 | 2010-05-17 00:00:00 | R4,2x45 | Diameter of bolt's head | 11.73 | 10.44 | 11.78 | 10.49 | 11.75 | 11.8 | 10.4 | 11.78 | 11.75 | 10.53 | 11.79 | 11.8 | 11.76 | 10.45 | 10.56 |  |  |  |  |  | 12 | 10 |  |  |  |  |  |  |  | 0.75 | 0.25
2 | 2010-05-17 00:00:00 | R4,2x46 | Head's height | 4.16 | 3.06 | 4.13 | 3.05 | 3.07 | 3.97 | 2.99 | 2.88 | 3.87 | 3.17 | 3.25 | 3.08 | 4.17 | 4.06 | 4.12 |  |  |  |  |  | 4 | 2 |  |  |  |  |  |  |  | 0.75 | 0.25
2 | 2010-05-17 00:00:00 | R4,2x47 | Diameter of rod | 3.34 | 3.35 | 3.35 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 |  |  |  |  |  | 3.5 | 3.25 |  |  |  |  |  |  |  | 0.75 | 0.25
3 | 2010-05-17 00:00:00 | ZAK5,0x12,9 | Diameter of bolt's head | 7.9 | 7.9 | 7.92 | 7.91 | 7.9 | 7.9 | 7.91 | 7.9 | 7.89 | 7.88 | 7.91 | 7.93 | 7.92 | 7.91 | 7.92 |  |  |  |  |  | 8 | 7.75 |  |  |  |  |  |  |  | 0.75 | 0.25
3 | 2010-05-17 00:00:00 | ZAK5,0x12,9 | Head's height | 1.44 | 1.44 | 1.46 | 1.46 | 1.47 | 1.48 | 1.46 | 1.47 | 1.48 | 1.49 | 1.48 | 1.47 | 1.48 | 1.48 | 1.49 |  |  |  |  |  | 1.5 | 1.4 |  |  |  |  |  |  |  | 0.75 | 0.25
3 | 2010-05-17 00:00:00 | ZAK5,0x12,9 | Diameter of rod | 4.9 | 4.92 | 4.91 | 4.9 | 4.91 | 4.85 | 4.9 | 4.89 | 4.89 | 4.87 | 4.89 | 4.91 | 4.85 | 4.89 | 4.86 |  |  |  |  |  | 5 | 4.75 |  |  |  |  |  |  |  | 0.75 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.25