Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel Quickie...

Old 02 July 2002, 12:01 PM
  #1  
Trotty
Scooby Regular
Thread Starter
 
Trotty's Avatar
 
Join Date: Feb 2002
Posts: 179
Likes: 0
Received 0 Likes on 0 Posts
Smile

As per title really.
I'm setting up a weight loss chart for me old dear (and me ) and want to set the scale on a chart but doesn't want to play.

Scale example:

Maximum = 16
Minimum = 10
Major Unit = 1
Minor = 0.1

How can I set this so it'll accept 12.13 as 12st 13lb for example.

Is this do-able?

Ta in advance

Ian
Old 08 July 2002, 08:01 AM
  #2  
Trotty
Scooby Regular
Thread Starter
 
Trotty's Avatar
 
Join Date: Feb 2002
Posts: 179
Likes: 0
Received 0 Likes on 0 Posts
Unhappy

Nobody?
My problem is, as it stands, if you chart a change from say 14.1 to 13.11 it drops loads due to not understanding the scale.

Any ideas peeps?

Cheers,

Ian
Old 08 July 2002, 09:53 AM
  #3  
mj
Scooby Regular
 
mj's Avatar
 
Join Date: Apr 2002
Location: The poliotical wing of Chip Sengravy.
Posts: 6,129
Likes: 0
Received 0 Likes on 0 Posts
Post

dont know if this is any help, you may find formulas within you can paste into your own spread.

http://www.geocities.com/wendylose/weight-loss.xls

this was found by typing "weight loss.xls" into google.
Old 08 July 2002, 10:31 AM
  #4  
Trotty
Scooby Regular
Thread Starter
 
Trotty's Avatar
 
Join Date: Feb 2002
Posts: 179
Likes: 0
Received 0 Likes on 0 Posts
Post

Thanks mj - I've seen that one before but I really wanted to create one which would use stones/lbs rather than just lbs. Doesn't seem as easy as I thought though...
Old 08 July 2002, 10:38 AM
  #5  
mj
Scooby Regular
 
mj's Avatar
 
Join Date: Apr 2002
Location: The poliotical wing of Chip Sengravy.
Posts: 6,129
Likes: 0
Received 0 Likes on 0 Posts
Post

it may be worth buying some new bathroom scales and using the metric system!
Old 08 July 2002, 11:42 AM
  #6  
Trotty
Scooby Regular
Thread Starter
 
Trotty's Avatar
 
Join Date: Feb 2002
Posts: 179
Likes: 0
Received 0 Likes on 0 Posts
Post

lol, always an option!
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
has-scooby
Subaru Parts
4
06 October 2015 03:47 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM


Thread Tools
Search this Thread
Quick Reply: Excel Quickie...



All times are GMT +1. The time now is 05:01 PM.