log book / data base???

[JamesB]

Im am getting back into riding my bike and years ago I built an Excel spread sheet where I could enter in info for that days info. miles rode, time and what my weight was. I pre-populated the days of they year and seperated them by weeks.

this worked ok, but I would have to manually change certain formulas every time i worked in the sheet to make it display the info I wanted.

I also has a few charts built in so I could see it in a graph.

this was pretty basic stuff, but now I looking to do something that does not involve me changing several formulas each time i enter in data.

I was thinking about doing something web based so I can enter in data into my log from anywhere.

my web hosting is on Unix servers with MySQL and PHP support

James

[kenw]

Can't help with the web based but I can help with the formulas stuff if you decide you want to keep it in excel.

Also, have you considered just keeping the file on a thumbdrive? it is what I do for several files of that sort (car mileage, investment tracking, etc, all XLS files).

[babybluetx23]

You can also convert the Excel Spreadsheet to Web Based through the File menu. When you do a save as, you can save it as a webpage. Im not sure if you can input info Via the web though. Its something I would have to play with. If I can find ya a DBA or at the VERY least an access pro Ill let ya know. Other then that Im out.

[all_purple2me]

What formulas are you having to change each time?? I'm pretty good with Excel & not too bad with Access.....let me know if you still need any help

[JamesB]

I have tried other excel docs as web pages and they looked just like an excel spread sheet, but on line. I can try it, but not sure if you can save data to it.

let me break out my columns and data a little and explain it some, I'm pretty good with excel but this formula has me stumped.


column a is the date field ( I pre-populated this field no worries here)

column b is the "miles rode field" (no problem here)

column c is time of ride (no problems here)

column d is the weight field. not a problem with this field, but this is one of the main columns I'm having the problem with.

up top on row 1 I have a cell that calculates my weight loss based on my most recent "weight" entry this is the formula I have to change all the time.

the first row of hard data contains my starting weight, the next row will be another day and new info, so if I ride that day I enter data in that day, then I have to change the formula to subtract my start weight from todays weight.

I'm not sure if some function (like "if") can be used in this formula to take into account the most recently entered data

James

[all_purple2me]

this could possibly be fixed. Can you send it to me & let me take a look at it??

[JamesB]

Originally Posted by all_purple2me

this could possibly be fixed. Can you send it to me & let me take a look at it??

when I get home tonight I will send it you. cany ou send me a PM with your email address

James