HW Lecture 04

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

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

View Full Document Right Arrow Icon
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)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 04/06/2008.

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 Right Arrow Icon
Ask a homework question - tutors are online