Spreadsheet

I felt like putting an example of the spreadsheet that I use that Canceler helped me with. It is a large spreadsheet, but I like the small utilities that I was able to implement. Notice that because of the size of the spreadsheet, I had to delete a lot of the hidden data columns. To bring them back, highlight cells Z9-DH9 and pull the data down do the final inputted as shown in the picture (Note: picture shows from Z10-DH10. Start 1 cell higher than the last black box).

The main feature that I wanted was the ability to have the graph be able to change based on the time frame that I input in B48 and C48 in the data page. The same idea was used in the casino page for the casinos I played at.

Some of the data (like standard deviation and CE) was dummied up for the forum because I finished the sheet after inputting the games and didn't keep track of the SD.

PS: I hope I didn't leave any sensitive info in some random cells

Found a bug. Change H35 in the data page to
=(B38-B35-Blackjack.CJ1+Blackjack.CJ5)/($Blackjack.BX1^0.5)

well it's very cool from the brief look i had of it.

i don't understand what you mean to "highlight cells Z9-DH9 and pull the data down do the final inputted as shown in the picture (Note: picture shows from Z10-DH10. Start 1 cell higher than the last black box)."

and i tried to copy and past =(B38-B35-Blackjack.CJ1+Blackjack.CJ5)/($Blackjack.BX1^0.5)
in H35 but excel comes back and claims an error.

oh well it's late, and i'll look it all over later.

Highlight the cells Z9-DH9. It should look like its highlighting the 2 cells like in the picture. Then drag that little black box in the bottom right corner of the highlighted cells and drag it down to where its even with the last entry.

Not sure why it doesnt work. I use OpenOffice instead of Excel, so maybe the format of the equation is different. Its not that big a deal anyway if you just wanna see how the sheet works.

i still haven't tried this again, i'll get back to ya.

ok, on this, that functionality you want to replace, errhh i guess that's referring to the blackjack tab, right?
doesn't that B35-Blackjack.CJ1+Blackjack.CJ5)/($Blackjack.BX1^0.5)
need to have an explanation point (!) in it to do that, or something like that?

Or maybe an exclamation point or two.
And I'm not crazy about that dollar sign, either.