3 Fat Chicks on a Diet Weight Loss Community

3 Fat Chicks on a Diet Weight Loss Community (https://www.3fatchicks.com/forum/)
-   LA Weight Loss (https://www.3fatchicks.com/forum/la-weight-loss-171/)
-   -   Tracking Spreadsheet (https://www.3fatchicks.com/forum/la-weight-loss/102037-tracking-spreadsheet.html)

YodaGirl 01-14-2007 07:41 AM

I'm thinking it depends on what you decide to do for a living, or where you find yourself. I currently work in a mid-to-large size company, and I know in our finance area it's absolutely vital (if Excel were ripped off of all the computers, I think they'd have a meltdown...seriously!). I use it quite a bit in account management, and I know that many other areas use it more for tracking and reports, but it's not as important...they could do the same in Word, but it's not as easy to manipulate.

All of our admins are expected to have basic to intermediate knowledge because they help on many reports and projects. It never hurts on a resume, either (I used to recruit for many companies).

I can see where other careers may never use it though.

Quote:

Originally Posted by Nikaia (Post 1530646)
Ahem...I'd like to point out that I have never gotten *into* Excel and it has yet to hamper me. I figure out other ways to do things. Are you sure Excel is that vital?

This is a discussion I've had a few times...I have yet to have anybody who's really convinced me that Excel is *necessary* in life. It might be useful for some things - witness this creative application of it - but necessary?

*gets off soapbox* ;)


nelie 01-14-2007 08:29 AM

Yodagirl,

I work for a large size company myself and I have found myself using excel multiple times and was grateful to have it available. Without it, I'm sure similar activities could be done but they would take weeks (maybe months) of work to accomplish what it can do in minutes/hours. Even if I had to write a computer program/script to do what it does it would generally take me longer to do it myself.

Sometimes I have taken data and wrote a specific program for it mostly for other reasons but excel is really good at what it does. I think the business world would be lost without it.

Mami 01-14-2007 09:47 AM

Anyone have a spreadsheet which tracks daily calories eaten and daily calories burned through basal metabolism and exercise? I was hoping excel can add each day's deficit or excess calories until it reaches 3500 (for those who don't know: a deficit of 3500 equals one pound lost) and then starts over adding again until it reaches the next 3500. I was going to ask a lady in my office to create this so I can see when I should be losing a "real" pound (as opposed to water weight and other fluctuations). I like to compete with myself and I can see myself trying to get those deficit numbers added up as quickly as possible to make 3500.

Nikaia 01-14-2007 12:51 PM

I guess it does depend on profession. I'm working on my BA in linguistics, so Excel isn't something I've ever really needed. My mom's an office manager, though, and she loves the blasted program. ;)

LaBonita 01-14-2007 10:23 PM

Mami -

I used this as my guide: http://www.hussmanfitness.com/html/TSCalDeficits.htm, but instead of using a 3X5 notecard, I use Excel. Read the part under "Caloric Deficits". I write in each day of the week with all the columns that he mentions (burned, intake, deficit, cumulative) and put the formulas in the cells, all using my BMR as a guide. Then at the end of the week I can see my deficit. PM me if you have any questions! :)

YodaGirl 01-15-2007 07:20 PM

Okay, due to demand, I updated the sheet to make it easy to customize, and also put it on a website for easy downloading. I'm including the link here, but if it gets removed due to moderation, please PM me and I'll be happy to share. The Excel spreadsheet link is at the bottom of the page under "attachments".

http://yodagirl.wetpaint.com/

justjodi 01-15-2007 07:49 PM

thank you so much yoda great program

PamelaStepp 01-29-2012 08:00 AM

Hi Everyone. Could someone please send me a copy of that Weightloss/BMI tracking spreadsheet that I saw Yodagirl referring to? I use one I made but it is boring. Thank you!:carrot:

bizlawchik 01-29-2012 09:43 AM

Hi Pamela - I doubt you will get a reply since she hasn't posted since 2007. But if you read the thread she gives a link to the document. Hope it's what you're looking for.

lemmasgirl 02-29-2012 06:29 PM

Quote:

Originally Posted by YodaGirl (Post 1530342)
I don't know if anyone else is as anal as I am, but I created an Excel spreadsheet that tracks my weight each week (on Saturday), the amount lost each week, a running tally of my total amount lost, goals, BMI changes, body fat % changes (they have on of the little hand-held body fat calculator things at the gym I attend), and measurement changes. I'm weighing each week (well, recording each week -- have to admit I'm jumping on the scale a lot in between) and everything else monthly. I'm hoping that seeing it on the screen / on paper will help me to be more committed to watching the numbers drop...and more even-headed during those times when they don't.

I also have little "conditional formatting" things in there to do fun stuff when I reach good points, like changing the text color to green when my BMI reaches normal range, and turning the cell bright yellow when I hit at or below goal. :)

If anyone wants a copy, let me know. If there's enough of a demand, I'll probably stick it online somewhere -- otherwise I can email.

I would like a copy of this. You can email me at (dawna at gmail dot com)

jalmgiven 09-06-2012 03:24 PM

thanks

melfitstar 01-02-2013 07:21 AM

Well heck, I want one too. I'm not allowed private messages yet though, did you end up posting it online? Thanks!

**duh, just found your link, thanks again!

jdaleck1 02-15-2018 09:55 AM

Hi, does anyone still happen to have this spreadsheet template! Definitely sounds amazing and well done for the meticulous effort put in to create it!

KimiBlossom 03-13-2018 04:19 PM

Hi is anyone still doing this? is anyone here?


All times are GMT -4. The time now is 07:54 PM.


Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.