Johnny I was gonna send you my pick but your inbox is full
Announcement
Collapse
No announcement yet.
Announcement
Collapse
No announcement yet.
*** VD 13 Commentary Thread ***
Collapse
X
-
Originally posted by Ken View PostJohnny I was gonna send you my pick but your inbox is fullIf DMT didn't exist we would have to invent it. There has to be a weirdest thing. Once we have the concept weird, there has to be a weirdest thing. And DMT is simply it.
- Terence McKenna
Bullshit is everywhere. - George Carlin (& Jon Stewart)
How old would you be if you didn't know how old you are? - Satchel Paige
Comment
-
Originally posted by TS Garp View PostI have a busy day and will be out with a client from 11:00 -- 4:30 west coast. If anyone has an updated sheet, can you send it to me and I'll try to see if I can send a pick ahead?"Jesus said to them, 'Truly I tell you, the tax collectors and the prostitutes are going into the kingdom of God ahead of you.'"
Comment
-
Originally posted by Controller Jacobs View PostNot sure if this is still the case, but there had been formatting inconsistencies between the original player stats and the appended 2018 seasons. That can spike file size by moving formatting from the column level to the cell level. If formats are re-applied per column to the by sheet, that may help.
If this is still an issue for people, we can try to figure it out. Right now, I'm operating under the assumption that downloading it from my Google Drive (the first link in the Spreadsheet thread) bypasses the Dropbox problem."Jesus said to them, 'Truly I tell you, the tax collectors and the prostitutes are going into the kingdom of God ahead of you.'"
Comment
-
Originally posted by Kevin Seitzer View PostI think I fixed that formatting issue when I updated the stats, but I'm sure there are others. I know for example, that the conditional formatting on the ROUNDS worksheet is a nightmare. I'm guessing some of the other new worksheets, like the hit_comb and pit_comb that Johnny added, might have added a lot of size, too?
If this is still an issue for people, we can try to figure it out. Right now, I'm operating under the assumption that downloading it from my Google Drive (the first link in the Spreadsheet thread) bypasses the Dropbox problem.
The only conditional formatting on the hit_comb and pit_comb sheets is the A column. I "rasterized" all the rest of the data, so there are no formulas. The extra columns I have on these pages, on my personal Spreadsheet, adds 2MB to the file size!
I deleted the conditional formatting I added to the Rounds page, and it made no difference the file size.
Comment
-
I'll try again. When I downloaded it to my hard drive it wasn't functional, so I have to download to my dropbox and apparently it's a 5 MB limit for Excel online. Just tried again and no dice.If DMT didn't exist we would have to invent it. There has to be a weirdest thing. Once we have the concept weird, there has to be a weirdest thing. And DMT is simply it.
- Terence McKenna
Bullshit is everywhere. - George Carlin (& Jon Stewart)
How old would you be if you didn't know how old you are? - Satchel Paige
Comment
-
This is what I get when I run some VBA code that I found from a Google search on how to find the size of Excel worksheets:
Code:Worksheet Name Size ROUNDS 1594804 Sheet1 8117 Snapshot 645366 hit_comb 965052 pit_comb 998721 stand 24932 dash 31840 CP 18447 BYP 16743 CH 15973 BYH 16321 let 25387 dec 19923 pick 466259 pos 38462 era 12952 help 10267 hit_car 487482 hit_seas 838599 pit_car 419598 pit_seas 919814 CJ 1506173 DMT 1507376 Johnny 1507055 Frae 1507157 Bene 1506974 Ken 1507056 TSG 1507068 Heye 1506763 Revo 1506869 Feral 1506665 KS 1507223 Hacko 1507287 mjl 1507171 blank1 1504897 blank2 1503304
"Jesus said to them, 'Truly I tell you, the tax collectors and the prostitutes are going into the kingdom of God ahead of you.'"
Comment
-
Originally posted by Kevin Seitzer View PostThis is what I get when I run some VBA code that I found from a Google search on how to find the size of Excel worksheets:
Code:Worksheet Name Size ROUNDS 1594804 Sheet1 8117 Snapshot 645366 hit_comb 965052 pit_comb 998721 stand 24932 dash 31840 CP 18447 BYP 16743 CH 15973 BYH 16321 let 25387 dec 19923 pick 466259 pos 38462 era 12952 help 10267 hit_car 487482 hit_seas 838599 pit_car 419598 pit_seas 919814 CJ 1506173 DMT 1507376 Johnny 1507055 Frae 1507157 Bene 1506974 Ken 1507056 TSG 1507068 Heye 1506763 Revo 1506869 Feral 1506665 KS 1507223 Hacko 1507287 mjl 1507171 blank1 1504897 blank2 1503304
I'll delete all that KO nonsense from the team pages (which, in fairness is not that much data) ... I just left it as a reminder of how I did it ... and from the pick page also. That might do it (not that we should have to ... a 5MB limit in 2019 is absurd) - reduced file size by 0.152
Got it down to 5.02 MB
Arrgh ... now 5.01 MB - troll!Last edited by johnnya24; 01-22-2019, 02:31 PM.
Comment
-
Originally posted by johnnya24 View Post4.77MB ... found a bunch of old stuff hidden in the Snapshot page.
Success! :insertemoteforshallowvictory:If DMT didn't exist we would have to invent it. There has to be a weirdest thing. Once we have the concept weird, there has to be a weirdest thing. And DMT is simply it.
- Terence McKenna
Bullshit is everywhere. - George Carlin (& Jon Stewart)
How old would you be if you didn't know how old you are? - Satchel Paige
Comment
-
Somehow I lost almost an entire point with these fixes, grrrrIf DMT didn't exist we would have to invent it. There has to be a weirdest thing. Once we have the concept weird, there has to be a weirdest thing. And DMT is simply it.
- Terence McKenna
Bullshit is everywhere. - George Carlin (& Jon Stewart)
How old would you be if you didn't know how old you are? - Satchel Paige
Comment
-
Originally posted by DMT View PostSomehow I lost almost an entire point with these fixes, grrrr
Note there are still fixes to be added to the SS in regard to the minor stat updates. This looks like being an ongoing thing.
Comment
Comment