![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Excel, I beat you pantless!
Jan. 4th, 2008 08:28 pm Er... sort of what I mean. :-)
Meaning, and I *know* this is piddly to those Excel experts amongst my flist, but I *finally* learned how to make a subtraction formula, and place it in the correct cell, in order to get the result I wanted!
What I did was translate a Food Diary book (Calorie King's) into my PDA Pocket Excel. It mimics the paper Diary's pages *exactly (down to the line count) BUT I added in sum columns for the calory counts and for the Exercise column, too. And from there I added a Net Calorie cell which subtracted the total exercise negative calories from the food calories, to get my total result! Whee!
I'm going to make enough copies of that spreadsheet to take me through to the end of March. Is there an upper limit to how many pages of worksheets there can be?
Oh, and I *also* killed some time while the kids were playing in an indoor playground with a bounce house in it (yay!) by creating an Excel Month Calender. Oh, sure sure, the PDA has a calender for appointments and stuff like that, but I needed an undated calender to create a Food Planner/Scheduler. I'm sure there's a lot I can do with it, like hyper link from the cell to the recipe list I need...I just don't know how to do that.
And now I should get writing on my new project, The Sandbox...or maybe In The Box, whatever. I'm spinning the characters out of the air right now, trying to figure out who the kids are, and what it is they find, and if it's SF or F or what!
Oh, and Tiv? My trigger finger is sooo itchy. It's still hovering over that buy button on Amazon. The Asus is even on the Buy List, just waiting, waiting, waiting... ::::finger twitches::::
Meaning, and I *know* this is piddly to those Excel experts amongst my flist, but I *finally* learned how to make a subtraction formula, and place it in the correct cell, in order to get the result I wanted!
What I did was translate a Food Diary book (Calorie King's) into my PDA Pocket Excel. It mimics the paper Diary's pages *exactly (down to the line count) BUT I added in sum columns for the calory counts and for the Exercise column, too. And from there I added a Net Calorie cell which subtracted the total exercise negative calories from the food calories, to get my total result! Whee!
I'm going to make enough copies of that spreadsheet to take me through to the end of March. Is there an upper limit to how many pages of worksheets there can be?
Oh, and I *also* killed some time while the kids were playing in an indoor playground with a bounce house in it (yay!) by creating an Excel Month Calender. Oh, sure sure, the PDA has a calender for appointments and stuff like that, but I needed an undated calender to create a Food Planner/Scheduler. I'm sure there's a lot I can do with it, like hyper link from the cell to the recipe list I need...I just don't know how to do that.
And now I should get writing on my new project, The Sandbox...or maybe In The Box, whatever. I'm spinning the characters out of the air right now, trying to figure out who the kids are, and what it is they find, and if it's SF or F or what!
Oh, and Tiv? My trigger finger is sooo itchy. It's still hovering over that buy button on Amazon. The Asus is even on the Buy List, just waiting, waiting, waiting... ::::finger twitches::::
