Page 3 of 4 FirstFirst 1234 LastLast
Results 25 to 36 of 46

Thread: Excel Formula, I need help :(

  1. #25

    Join Date
    Jul 2007
    Location
    Europe
    Posts
    8,430
    Blog Entries
    297

    Default Re: Excel Formula, I need help :(

    Quote Originally Posted by jpcavin View Post
    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

    Quote Originally Posted by Cactus View Post
    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
    Retired, 55G/15C/15S/15I (Paper Trading)_ BLOG: Stats for March, Stats for Q1, 2024 Stats

  2.  
  3. #26

    Join Date
    Aug 2008
    Location
    Pensacola, FL
    Posts
    6,312

    Default Re: Excel Formula, I need help :(

    Quote Originally Posted by JTH View Post
    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.

  4.  
  5. #27

    Join Date
    Jul 2007
    Location
    Europe
    Posts
    8,430
    Blog Entries
    297

    Default Re: Excel Formula, I need help :(

    Quote Originally Posted by jpcavin View Post
    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
    Retired, 55G/15C/15S/15I (Paper Trading)_ BLOG: Stats for March, Stats for Q1, 2024 Stats


  6.  
  7. #28

    Default Re: Excel Formula, I need help :(

    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.
    100% G Fund COB 13 March 2020

  8.  
  9. #29

    Join Date
    Jul 2007
    Location
    Europe
    Posts
    8,430
    Blog Entries
    297

    Default Re: Excel Formula, I need help :(

    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.
    Retired, 55G/15C/15S/15I (Paper Trading)_ BLOG: Stats for March, Stats for Q1, 2024 Stats

  10.  
  11. #30

    Join Date
    Aug 2007
    Posts
    12,621
    Blog Entries
    143

    Default Re: Excel Formula, I need help :(

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

    11 Advanced Excel Tricks - Business Insider

  12.  
  13. #31

    Join Date
    Feb 2011
    Location
    Washington
    Posts
    9,583

    Default Re: Excel Formula, I need help :(

    Quote Originally Posted by ILoveTDs View Post
    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...
    Rules:
    - Trade what you see, not what you believe
    - Don't put stuff in your signature that a Mod doesn't like

    "Government exists to protect all people’s rights, not some people’s feelings." - A. Barton Hinkle

    Great Tools:
    http://www.CreditKarma.com
    http://www.Mint.com
    http://www.SaveUp.com/r/nmJ

  14.  
  15. #32

    Default Re: Excel Formula, I need help :(

    Quote Originally Posted by JTH View Post
    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.

  16.  
  17. #33

    Join Date
    Oct 2008
    Location
    Stinking desert valley of bad air quality, AZ
    Posts
    2,993

    Default Re: Excel Formula, I need help :(

    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

  18.  
  19. #34

    Join Date
    Feb 2011
    Location
    Washington
    Posts
    9,583

    Default Re: Excel Formula, I need help :(

    Quote Originally Posted by PessOptimist View Post
    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
    Rules:
    - Trade what you see, not what you believe
    - Don't put stuff in your signature that a Mod doesn't like

    "Government exists to protect all people’s rights, not some people’s feelings." - A. Barton Hinkle

    Great Tools:
    http://www.CreditKarma.com
    http://www.Mint.com
    http://www.SaveUp.com/r/nmJ

  20.  
  21. #35

    Default Re: Excel Formula, I need help :(

    Hehehe .... Lotus 123
    100% G Fund COB 13 March 2020

  22.  
  23. #36

    Join Date
    Jun 2004
    Location
    Boiled Peanut, Georgia, USA
    Posts
    76,396

    Default Re: Excel Formula, I need help :(

    Quote Originally Posted by ILoveTDs View Post
    Hehehe .... Lotus 123
    That's where I got my start, add Enable to that list.




  24.  
Page 3 of 4 FirstFirst 1234 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
S&P500 (C Fund) (delayed)
Excel Formula, I need help :(
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Excel Formula, I need help :(
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Excel Formula, I need help :(
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Excel Formula, I need help :(
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes