{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

HW Lecture 04

# HW Lecture 04 - EGR 1705 Section 006 Lecture#4 HW Steven...

This preview shows pages 1–2. Sign up to view the full content.

EGR 1705 - Section 006 Steven Lovaglio Lecture #4 HW 2/4/08 Homework #3-Lecture 4 1.0 INTRODUCTION The purpose of this homework is to practice using formulas in Excel, and to practice making a correct engineering graph on Excel. 2.0 PROBLEM DESCRIPTION Create a table that displays the number of rotations per mile for rims with diameters of 14” ≤ 20". Given: A car's tires have a 4.5" sidewall mounted on a 17" rim. Car travels in a straight line. Find: The number of tire revolutions (REV) per mile. Create a table of revolutions , for rim diameters 14" ≤ ≤ 20". Calculations: 1 mile = 63360 inches 3.0 SOURCE CODE LISTING Excel: Formulas to Calculate Revolutions Per Mile 1 2 3 4 5 6 7 8 A B C D E F Sidewall Diameter of Rim Diameter of Tire Circumference of Tire Inches in a Mile Revolutions/Mile 4.5 14 =(2*A2+B2) =PI()*(C2) 63360 =(E2/D2) 4.5 15 =(2*A3+B3) =PI()*(C3) 63360 =(E3/D3) 4.5 16 =(2*A4+B4) =PI()*(C4) 63360 =(E4/D4) 4.5 17 =(2*A5+B5) =PI()*(C5) 63360 =(E5/D5)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

HW Lecture 04 - EGR 1705 Section 006 Lecture#4 HW Steven...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online