Challenge for Excel Gurus - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 07-26-2004, 01:53 PM   #1 (permalink)
True Techie
 
Join Date: Feb 2004
Posts: 195
Default Challenge for Excel Gurus

It's been awhile since I've used Excel, so I'm a bit rusty, but what I want to do is this:
1. Generate a Mileage Log.
2. Have it so I don't have to keep over it at all times. Rather, just input my beginning mileage and have it auto-calculate (using AutoSum?) to the end of the month, without me having to check my odometer every day.
3. There are esentially 4 or 5 places I travel, generally less than 6 miles roundtrip (across town). Can I assign values to these particular places? Probably not, since this is Excel, not Access.
*Note: It will not matter whether I input "imaginary" numbers to begin with.

Should I elaborate more? Or is this enough to at least work with?
__________________

__________________
*\'Failure\' is not a four-letter word.
star_topology is offline  
Old 07-26-2004, 05:05 PM   #2 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default Re: Challenge for Excel Gurus

Quote:
Originally posted by star_topology
2. Have it so I don't have to keep over it at all times. Rather, just input my beginning mileage and have it auto-calculate (using AutoSum?) to the end of the month, without me having to check my odometer every day.
3. There are esentially 4 or 5 places I travel, generally less than 6 miles roundtrip (across town). Can I assign values to these particular places? Probably not, since this is Excel, not Access.
For #2, could you give me an example including theorical input/output?

#3: You could have reserved cells containing the data you want to use. When you want to use them, just input the cell address.
__________________

office politics is offline  
Old 07-27-2004, 01:16 AM   #3 (permalink)
Monster Techie
 
Join Date: Jul 2004
Location: Manchester, UK
Posts: 1,909
Default

elaborate a little more, telling exactly what you want.

like, my milage is 1234, the ending is 2345 etc.
__________________
Intel Core2Quad 2.66Ghz 12MB L2-Cache
4096MB DDR Kingston Hyper-X
GigaByte GA-P35-DS3R
XFX 9600GT AlphaDog
Seagate 2 X 320GB SATA2
LG L246WH Flatron 24"
Sony DVD-RW
Blind_Arrow is offline  
Old 07-27-2004, 10:34 AM   #4 (permalink)
True Techie
 
Join Date: Feb 2004
Posts: 195
Default

What both of you are saying is what I want. But for further elaboration, I attached a screen cap of a mileage log that I just made up, no formulae as of yet.
__________________
*\'Failure\' is not a four-letter word.
star_topology is offline  
Old 07-27-2004, 12:05 PM   #5 (permalink)
Newb Techie
 
Join Date: Feb 2004
Posts: 13
Send a message via AIM to Raghu Boddu
Default

Hi,

The following template may help you:

http://office.microsoft.com/template...ravel&Scope=TC

For your ease, I have created a tiny URL also:

http://tinyclick.com/?qqzeca
Raghu Boddu is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 10:31 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.