any excell experts out there

[sagefr0g]

got a question regarding excell.
basically what i trying to figure out how to do is compile data after excell has been made to perform a calculation.

like for example (and this is probably not a very good example)
below is two images of this excell shuffler i fooled around making.
it shows graphically what the card make up looks like and it also calculates the true count at various depths in the pack.
so i got it running on a macro where you just hit a key and it'll shuffle, give a new graphic representation and calculate the true counts.

well the thing is i'd like to be able to compile those true counts for the various shuffles in a data list automatically.
to where i'd end up with in the example below a table showing the true count vs pack depth for shuffle 1 and shuffle 2, ect. ect.

so that's the question, how does one compile data in excell under those circumstances like where your running a macro sort of thing. or maybe the question is can it be done?

[Canceler]

Originally Posted by sagefr0g

or maybe the question is can it be done?

Excel can do anything!

Would you like to attach a copy of your workbook showing what you HAVE and exactly what you WANT?

Is it simply that you want your results for each shoe entered into a table like the following? (Example using the info from your images.)

[sagefr0g]

Originally Posted by Canceler

Excel can do anything!

Would you like to attach a copy of your workbook showing what you HAVE and exactly what you WANT?

Is it simply that you want your results for each shoe entered into a table like the following? (Example using the info from your images.)

yes that's what i would like to be able to do, essentially collect a lot of data of various shuffles.
i'd like to learn how to do that because i'd like to be able to make other spread sheets than just this one so that i can collect data.

so ok, i've attached the spread sheet.
just enable macros
then press ctrl-a and the thing will shuffle.
i appreciate your looking it over.

edit: oh yeah, the calculated tc's by deck depth are to the far right in the sheet.

[aslan]

I used to be into Excel, Sage, but since I retired I've let all that sort of drift away. Canceler is right--you can do anything in Excel, especially with it's VB capability. I have seen applications in Excel that you would swear could not be an excel application. If you can imagine it, you can do it.

[sagefr0g]

Originally Posted by aslan

I used to be into Excel, Sage, but since I retired I've let all that sort of drift away. Canceler is right--you can do anything in Excel, especially with it's VB capability. I have seen applications in Excel that you would swear could not be an excel application. If you can imagine it, you can do it.

right aslan, that's what i figured. i've never tryed VB, just generic basic and a bit of c programing stuff. i think Canceler is going to look at it for me.

[Canceler]

Okay, Mr. fr0g, try this. Do Ctrl + A as many times as you like. The results will be stored on the new sheet called Results List.

Now don't be shy. If this is not exactly what you had in mind, tell me what needs to be changed. Let me know if you have any questions.

[sagefr0g]

Originally Posted by Canceler

Okay, Mr. fr0g, try this. Do Ctrl + A as many times as you like. The results will be stored on the new sheet called Results List.

Now don't be shy. If this is not exactly what you had in mind, tell me what needs to be changed. Let me know if you have any questions.

that's exactly what i had in mind.
so i guess i can try and look at your code and see can i figure out what you did.
if not, then yup i'll have questions.
thank you very much!

[sagefr0g]

one reason i was interested in getting data like this together is to get an idea for stuff like when wonging out is a good idea and for points at which one might as well stop counting when in play all mode. info like i was asking about in this link:
http://www.blackjackinfo.com/bb/showthread.php?t=14307

then lol, i think there are some other areas of interest this sort of thing might shed some light on. just what that is i'm not sure cause i'm either to sleepy to remember right now or maybe it's not a fully formed question in my mind. thank you again, Canceler.

[Canceler]

Originally Posted by sagefr0g

thank you very much!

You're welcome! Glad to help out. And I don't mind a little chance to show off every once in a while.

[sagefr0g]

Originally Posted by Canceler

You're welcome! Glad to help out. And I don't mind a little chance to show off every once in a while.

really you should show off, lol, i mean heck i remember that blackjack game you created when we was doing weekend warriors, that thing was way kewl!

so but, i know i need to tweak the heck out of that shuffler far as rounding, truncating or flooring tc's and what ever. and i know the rng is not supposed to be sufficient for this sort of stuff and all. just having fun messing with it and seeing if questions that come to mind can have some light shed on them. i mean truth be known, i don't really understand the concept of what some ideal random shuffle is and how that stacks up against real casino shuffles.

just i'm curious did you use a similar method to shuffle for your blackjack game or some other way?