Excel Formula, I need help :(

[RealMoneyIssues]

Sounds like a pretty interesting spreadsheet...

 

[JTH]

Sounds like a pretty interesting spreadsheet...

Thanks everyone if you knew how much time I spend in excel, then you know how much this means to me, I now get to spend the weekend working on new spreadsheets, more work upfront, but a lot less work down the road, and it should run much cleaner.

 

[jpcavin]

Thanks everyone if you knew how much time I spend in excel, then you know how much this means to me, I now get to spend the weekend working on new spreadsheets, more work upfront, but a lot less work down the road, and it should run much cleaner.

Will you be sharing the results of your project? I think it's safe to assume we're all intrigued.

 

[Cactus]

Thanks everyone if you knew how much time I spend in excel, then you know how much this means to me, I now get to spend the weekend working on new spreadsheets, more work upfront, but a lot less work down the road, and it should run much cleaner.

So were you able to make your spreadsheet less resource intensive? Is it still taking 42M?

 

[JTH]

Will you be sharing the results of your project? I think it's safe to assume we're all intrigued.

Have you been reading my blogs? Short answer is yes I have been, but I don't always post everything, there is just too much, I try to just post what is relavent and can be applied within the TSP world. For me, it is really just another form of charting, but it's better. Formulas don't guess they have no grey, it's either yes or no, where charting is full of grey

So were you able to make your spreadsheet less resource intensive? Is it still taking 42M?

I won't know until I re-merge & rebuild all the files, I had to seperate them last week because they were using too much resources. It will be better because it is taking the most direct path to the answer, it's also using less columns, less is more

 

[jpcavin]

Have you been reading my blogs? Short answer is yes I have been, but I don't always post everything, there is just too much, I try to just post what is relavent and can be applied within the TSP world. For me, it is really just another form of charting, but it's better. Formulas don't guess they have no grey, it's either yes or no, where charting is full of grey

I ALWAYS read your blogs. It just got the impression that you were working a some new theory and that intrigued me.

 

[JTH]

I ALWAYS read your blogs. It just got the impression that you were working a some new theory and that intrigued me.

No, nothing new, but I've been spending way too much time rebuiding broken files, time better left to other things

 

[ILoveTDs]

JTH

I don't know if this is true or not, but I was once told by an Excel consultant that when you save in Excel it doesn't just save the new information, it completly resaves the whole Excel spreadsheet. As a result, the more often you save an Excel spreadsheet the quicker the file will grow and eventually start to slow down and break. This is in addition to new data in the Excel spreadsheet.

Based on the discussion I had with this individual, I now use the Save As function insteads of Save when I notice my files starting to slow down and rename them something similar. I then close down Excel delete the old file and then rename the new file to the old files name.

Just a thought and as I said upfront, not sure if true or not but I do it.

 

[JTH]

Thanks, I do belive this is true, when I save the file, it shouldn't take 1 minute to dave something when you haven't made any changes.

 

[Intrepid_Timer]

Don't know if this will help anyone, but just saw it:

11 Advanced Excel Tricks - Business Insider

 

[RealMoneyIssues]

JTH

I don't know if this is true or not, but I was once told by an Excel consultant that when you save in Excel it doesn't just save the new information, it completly resaves the whole Excel spreadsheet. As a result, the more often you save an Excel spreadsheet the quicker the file will grow and eventually start to slow down and break. This is in addition to new data in the Excel spreadsheet.

Based on the discussion I had with this individual, I now use the Save As function insteads of Save when I notice my files starting to slow down and rename them something similar. I then close down Excel delete the old file and then rename the new file to the old files name.

Just a thought and as I said upfront, not sure if true or not but I do it.

I think you are talking about Access... that is a huge issue with Access any why you need to repair and compress frequently...

I don't know of this being an issue in Excel and I am in Excel daily (365 days a year, and I am not kidding)...

I will take a look at it...

 

[k0nkuzh0n]

Thanks, I do belive this is true, when I save the file, it shouldn't take 1 minute to dave something when you haven't made any changes.

IDK if you are aware but there is a way to stop Excel from auto-calculating every time you change a cell. If you have issues where every time you hit enter or click on a cell the spreadsheet tries to update (can be intense if there are a lot of formulas dependent on other formulas) it might be a very good idea to change it to manual calculate.

 

[PessOptimist]

Thanks for this thread. The formulas here tickled some long dead brain cells about some future projects.

Long dead brain cell memories - anyone remember using Lotus 123 and having to buy a math co-processor for the ol 8086 computer? Remember having to check all the math if using a Lotus spread sheet in a report due to rounding errors?

Off memory lane and back to the scheduled progamming.

Thanks again

PO

 

[RealMoneyIssues]

Thanks for this thread. The formulas here tickled some long dead brain cells about some future projects.

Long dead brain cell memories - anyone remember using Lotus 123 and having to buy a math co-processor for the ol 8086 computer? Remember having to check all the math if using a Lotus spread sheet in a report due to rounding errors?

Off memory lane and back to the scheduled progamming.

Thanks again

PO

Yes, sadly... I do remember having to hunt for math co-processors when we started using Lotus... They weren't cheap either...

Dang, we are old

 

[ILoveTDs]

Hehehe .... Lotus 123

 

[nnuut]

Hehehe .... Lotus 123

That's where I got my start, add Enable to that list.

 

[RealMoneyIssues]

Harvard Graphics anyone?

 

[Frixxxx]

Harvard Graphics anyone?

With Wordstar!

 

[JTH]

How quickly this thread digresses when you folks try to play the "I'm more old school than you" game

Quick update:

Yes I've tried all the tips/tricks, the only one that has made a difference is when you archive previous formulas by pasting them as text.

I've upgraded from Excel 2010 32Bit to Excel 2013 64Bit, I'm not big fan of upgrades, we'll see how well it works out.

 

[PessOptimist]

How quickly this thread digresses when you folks try to play the "I'm more old school than you" game

Quick update:

Yes I've tried all the tips/tricks, the only one that has made a difference is when you archive previous formulas by pasting them as text.

I've upgraded from Excel 2010 32Bit to Excel 2013 64Bit, I'm not big fan of upgrades, we'll see how well it works out.

We didn't even get in to DBaseII or the stuff we used to run on Z-Dos on the Z-100s or the 8 inch floppies or...

You paste previous formulas in a cell formatted as text? Do they still work? Does that keep excel from "fixing" them?

I'm in agreement on upgrades. Not that I don't think newer versions aren't needed, just that "backward compatibility" often is not. Every time the good folks at IT push an upgrade to office, we spend hours trying to get even relatively simple spreadsheets to behave. The Access stuff, I won't even go there.

Good luck and keep us posted.

PO