Need Excel Help-Advanced

Rubberboots · Rubberbootsian Age: 43 Joined: 25 May 2006 Posts: 185

Nanner :

You mean excel isn't just for making grocery lists on?

It does other things, but nothing so well as that! Smile

chocoholic1415 · Posted: Wed Aug 09, 2006 2:10 pm Post subject: View Single Post

Rubberboots :

Nanner :

You mean excel isn't just for making grocery lists on?

It does other things, but nothing so well as that! Smile

Actually, it's also quite handy for keeping track of your friends lists as well as other tt info Smile

Maybe on my days off between jobs (I turned in my notice here last week - woot), I'll actually finish up that tt database I started. Then again, maybe I'll just play . . .

Lady Melody Petalface · Posted: Wed Aug 09, 2006 4:05 pm Post subject: View Single Post

Nanner :

You mean excel isn't just for making grocery lists on?

Oh my! Oh Kevin Did you see this? Nanner needs to know just what Excel is used for. How long is that list of yours now, it is in Excel of course. My Excel geek organizes our lives in Excel right down to the formulas he has for freezer cooking. We enter the recipes we want to do that weekend and Excell tells us what we need to buy. We have TT spreadsheets around here and just about every vacation packing list on Excel. But you would think that he could help me get my inviocing system done on Excel as my experience on that program is too many versions old and at least 13 years gone.

Nanner :

BTW what language are you all speaking? It isn't english!!!!!!!!!!

Techno geek knows no language barriers. Just listen to someone of another language talk about computers. You hear a bunch of stuff you don't understand then you hear Excel, then you hear some more mumbo jumbo and then Microsoft followed by more stuff and then a few programming languages thrown in. It is really interesting.

Audrey(wandering away from the techie forum and hitting my head again.... what am I thinking hanging out here?)

Granny MoMo · Posted: Wed Aug 09, 2006 4:52 pm Post subject: View Single Post

Audrey, do I need to take you to the ice cream (okay, no doughnuts) store with Nanner? Loopy, you can come too!

LadyZ · Posted: Wed Aug 09, 2006 4:58 pm Post subject: View Single Post

Lady Melody Petalface :

Nanner :

You mean excel isn't just for making grocery lists on?

Oh my! Oh Kevin Did you see this? Nanner needs to know just what Excel is used for. How long is that list of yours now, it is in Excel of course. My Excel geek organizes our lives in Excel right down to the formulas he has for freezer cooking. We enter the recipes we want to do that weekend and Excell tells us what we need to buy. We have TT spreadsheets around here and just about every vacation packing list on Excel. But you would think that he could help me get my inviocing system done on Excel as my experience on that program is too many versions old and at least 13 years gone.

I think I got lost looking for a different thread....but while I'm here, could your Excel geeky thingie tell ME what to buy?? Very Happy

Granny MoMo · Posted: Wed Aug 09, 2006 4:59 pm Post subject: View Single Post

You just need to buy food, and lots of it! Sheesh, you do have a zoo to feed! Razz

Freddy Whatzit · Posted: Wed Aug 09, 2006 5:00 pm Post subject: View Single Post

Lady Melody Petalface :

Oh my! Oh Kevin Did you see this?

LOLOL!! Yeah Audrey, I did, but it's your post that really got me laughing.

Lady Melody Petalface :

Nanner needs to know just what Excel is used for. How long is that list of yours now, it is in Excel of course. My Excel geek organizes our lives in Excel right down to the formulas he has for freezer cooking. We enter the recipes we want to do that weekend and Excell tells us what we need to buy.

Um, doesn't everybody do this?

Actually, that's the simple one. No VBA at all, just formulas. The complicated one is the one that plans our meals 2-3 months in advance, allowing for left-overs from the bigger Sunday dinners and special requests for birthdays and such. That one does use VBA. Scared yet?

Lady Melody Petalface :

We have TT spreadsheets around here and just about every vacation packing list on Excel.

Oh come now, I'm not that silly. Those lists are all in Notepad files. (Of course, with a master list of lists, to ensure I didn't forget any list category.)

TT of course does benefit from spreadsheets. Made one to track gag inventory when I planned how to do a double short fac without going back to the gag shop in between. There's also one for fishing, and one that shows what streets are better for finding which types of cogs. Probably a few others that I don't remember off the top of my head. But they're all simple, with no code behind them at all.

Lady Melody Petalface :

But you would think that he could help me get my inviocing system done on Excel as my experience on that program is too many versions old and at least 13 years gone.

Now that we have a newer version of Excel that might be doable. Last time this came up the only version we had still used macros, not VBA. Write me some specs and I'll get right on it. bteasing3

Kevin

LadyZ · Posted: Wed Aug 09, 2006 5:04 pm Post subject: View Single Post

You didn't answer MY question. Can your inner geek help ME? Razz

Freddy Whatzit · Posted: Wed Aug 09, 2006 5:26 pm Post subject: View Single Post

LadyZ :

You didn't answer MY question. Can your inner geek help ME? Razz

Sorry, the kind of help you need can't be geek-sourced.

(But if you're still talking about food, just buy pizza.)

Kevin

LadyZ · Posted: Wed Aug 09, 2006 5:46 pm Post subject: View Single Post

Ahhhh, Kevin. My kids are now your biggest fans. Cool

Granny MoMo · Posted: Wed Aug 09, 2006 10:59 pm Post subject: View Single Post

Freddy Whatzit :

LadyZ :

You didn't answer MY question. Can your inner geek help ME? Razz

Sorry, the kind of help you need can't be geek-sourced.

(But if you're still talking about food, just buy pizza.)

Kevin

The type of help she needs isn't available, period! Shocked

JAJA!

Geez, Kevin aka Freddy W aka Freedy... Audrey, hon, wow! LOL! It's a wonder you haven't yanked your hair out due to his spreadsheets and master lists and lists for lists...

Lady Melody Petalface · Posted: Thu Aug 10, 2006 12:10 am Post subject: View Single Post

Granny MoMo :

Geez, Kevin aka Freddy W aka Freedy... Audrey, hon, THAT "OTHER" GAME! LOL! It's a wonder you haven't yanked your hair out due to his spreadsheets and master lists and lists for lists...

LOL like Kevin has always said he puts the Anal into Analyst. It is a good thing he is so good at lists and order because I am terribly disorganized and try to buck routine at every turn. So how we stay together is amazing lol.

Audrey

Nanner · Posted: Thu Aug 10, 2006 2:00 am Post subject: View Single Post

Freddy Whatzit :

Lady Melody Petalface :

Oh my! Oh Kevin Did you see this?

LOLOL!! Yeah Audrey, I did, but it's your post that really got me laughing.

Lady Melody Petalface :

Nanner needs to know just what Excel is used for. How long is that list of yours now, it is in Excel of course. My Excel geek organizes our lives in Excel right down to the formulas he has for freezer cooking. We enter the recipes we want to do that weekend and Excell tells us what we need to buy.

Um, doesn't everybody do this?

My excel tells me what to buy but it's manually put in my my little fingers! Ahhh what's a formula for freezer cooking????? Your excel knows what staples you have in the house???????????

Actually, that's the simple one. No VBA at all, just formulas. The complicated one is the one that plans our meals 2-3 months in advance, allowing for left-overs from the bigger Sunday dinners and special requests for birthdays and such. That one does use VBA. Scared yet?

What if I have a Taco Bell urge that week? Will the excel program explode?

Lady Melody Petalface :

We have TT spreadsheets around here and just about every vacation packing list on Excel.

Oh come now, I'm not that silly. Those lists are all in Notepad files. (Of course, with a master list of lists, to ensure I didn't forget any list category.)

Although I don't have a master list I keep my packing list on Word myself....... Very Happy

TT of course does benefit from spreadsheets. Made one to track gag inventory when I planned how to do a double short fac without going back to the gag shop in between. There's also one for fishing, and one that shows what streets are better for finding which types of cogs. Probably a few others that I don't remember off the top of my head. But they're all simple, with no code behind them at all.

Another use for Word. You just copy/paste what you find here or on TTC and put it into Word. Hit print and tada! All done for you Razz

I do however....or did....have my friends list and all that other good stuff like fish needed and where on excel. That was many changes ago so need to redo.

Kevin

So yes. Guess I do use it for more than grocery lists....although it is quite handy for that! Also I did know much more about it but it left my brain when I quit working. Now my brain has filled up with more useful things like theme songs to Nick/Nogin and Disney shows.

Granny MoMo · Posted: Thu Aug 10, 2006 8:58 am Post subject: View Single Post

Lady Melody Petalface :

Granny MoMo :

Geez, Kevin aka Freddy W aka Freedy... Audrey, hon, THAT "OTHER" GAME! LOL! It's a wonder you haven't yanked your hair out due to his spreadsheets and master lists and lists for lists...

LOL like Kevin has always said he puts the Anal into Analyst. It is a good thing he is so good at lists and order because I am terribly disorganized and try to buck routine at every turn. So how we stay together is amazing lol.

Audrey

ROFL! I was going to call him the "A" word... you two complement each other very well! Smile

Nanner, I'm with you! Knowing the words to Dora the Explorer and Spongebob outrank the intricacies of Excel! I had thought I was rather adept at using the program. *THUNK* What an eye-opener this thread was!! Now I feel like I should be wearing a dunce cap instead!! Laughing

Freddy Whatzit · Posted: Thu Aug 10, 2006 11:38 am Post subject: View Single Post

Nanner :

Ahhh what's a formula for freezer cooking?????

Yikes! Okay, short answer...
We'll pick some meal we like and pre-prep several, usually 4-5, at once, throw 'em in the freezer, then dinners during hectic days are easy and don't have to be expensive, low nutrition, overly processed, quickie meals. My spreadsheet has a row for each type of meal we commonly prepare this way, and a column for each ingredient. There's also a column where I enter the number of each meal I plan to cook at the time. Each cell has a formula that calculates how much of each ingredient I need for each recipe (and boy, metric sure makes that easy - so much easier to add mL than tsp, tbsp, and fractions of cups). Then there's a row of totals that tells me everything I need for all the cooking I'm planning.

Nanner :

Your excel knows what staples you have in the house???????????

Um, no, I need to know that myself. Excel tells me what I need to have, then I decide what I need to buy. Then I write my shopping list on a piece of arboreal-sourced cellulose-fibre-based information storage medium with a serial output pigment dispensing stylus.

Nanner :

Freddy Whatzit :

The complicated one is the one that plans our meals 2-3 months in advance

What if I have a Taco Bell urge that week? Will the excel program explode?

Nope. It's coded to advise, not restrict. Wanna pick me up a couple tacos while you're there?

Granny MoMo :

Knowing the words to Dora the Explorer and Spongebob outrank the intricacies of Excel!

Swiper, no swiping! ... Oh man!
Thanks Ang, now I've got a singing map in my head.

Granny MoMo :

Now I feel like I should be wearing a dunce cap instead!!

Hey! I bet Excel has a function to make one for you!

Kevin

Dizzy T · Posted: Thu Aug 10, 2006 11:53 am Post subject: View Single Post

Personally, this thread is getting me hot. I live in Excel.

Granny MoMo · Posted: Thu Aug 10, 2006 12:08 pm Post subject: View Single Post

Freddy Whatzit :

Granny MoMo :

Knowing the words to Dora the Explorer and Spongebob outrank the intricacies of Excel!

Swiper, no swiping! ... Oh man!
Thanks Ang, now I've got a singing map in my head.

Granny MoMo :

Now I feel like I should be wearing a dunce cap instead!!

Hey! I bet Excel has a function to make one for you!

Kevin

JAJAJAJA!!!! I should KNOW not to read the boards while working/drinking, and I just haven't learned my lesson! I just spewed coffee and had to put a doctor on hold because I couldn't stop laughing!!

"I'm the map, I'm the map, I'm the map, I'm the map... I'm the MAP!"

Kevin aka Freddy W aka Freedy, you search out that dunce cap function and get back to me, hmmkay?

As for your meal planning and freezer/ingredients list, I'd love to see that (being sincere here) or see some examples.

chocoholic1415 · Posted: Thu Aug 10, 2006 12:32 pm Post subject: View Single Post

Freddy Whatzit :

Then I write my shopping list on a piece of arboreal-sourced cellulose-fibre-based information storage medium with a serial output pigment dispensing stylus.

ROFLMAO, I love the way you make common items sound so mystical. Personally, I use a palm to keep my grocery list as it never fails that any piece of arboreal-sourced cellulose-fibre-based information storage medium I write on with either a serial output pigment dispensing stylus or a fiber-based cylindrical carbon dispenser will disappear in the vortex of my purse.

There are several very nice cooking software packages available. You enter your recipes in the software. It will then generate nutritional information, grocery lists, etc. I don't remember the name of the one I have (shows how much I use it LOL). Being raised properly Jewish, I usually just make reservations Laughing

. When I don't have the time or energy for that, I have the pizza delivery on speed-dial.

PS - you should really consider putting that into a database Kev.

PPS - geeks that our family is . . . since we run tt in windows mode, hubby created a little form with a button that he keeps open when he plays. It toggles between green with the label "Invasion" and red with the label "No Invasion". I'm going to kick it up a little notch to have it track invasion times . . .

Granny MoMo · Posted: Thu Aug 10, 2006 1:06 pm Post subject: View Single Post

You have a vortex for your purse, too?

Now I don't want a cooking software package! I'm NOT Betty Crocker! JAJA!

I think I'd rather stick with my clown pen! HeeHee!

Loopy · Posted: Thu Aug 10, 2006 1:21 pm Post subject: View Single Post

Dizzy T :

Personally, this thread is getting me hot. I live in Excel.

ROFL! Excel would not be on my top 10 list of things that make me hot!