Ramballah
Active Member
- Joined
- Sep 25, 2018
- Messages
- 311
- Office Version
- 365
- Platform
- Windows
Hello everyone,
Today I want to make a sheet that contains all the information about coinflips. I am playing a game where coinflipping is a thing and i'm quite addicted to it. Now there is kind of a tactic to get good guesses at it and a big help would be tracking down information. However I dont want to spend hours putting in my information. I kinda want to just type in a short form of information and then excel sorts it out in the correct way.
For example:
<colgroup><col span="3"><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>Now this is a lot of information already so im going to give a quick rundown on what i want:
For everywin i want to add the winstreak record, but if i lose the winstreak gets reset. However i want to also have a highest winstreak cell somewhere. Now a win from someone else also shouldn't be counted because in this case we have the person Shee in there aswell. Also i want if i put Tails in there and i won, it will tell it was tails, but if i lost it would tell it was Heads. Now this information is kind of clusterbombed like this so i will also leave my Excel file in here. I'm not sure how to achieve these results on my alone. I'm not too familiar with VBA aswell.. So i would appreciate it if some of you people have solutions for me, or something to make it easier!
Many thanks!
Yours sincerely,
Ramballah
https://drive.google.com/open?id=1ZvhP2j3eohsrVw9NoNdXgUREl8xdOvUB
The thing is in sheet 2.
Today I want to make a sheet that contains all the information about coinflips. I am playing a game where coinflipping is a thing and i'm quite addicted to it. Now there is kind of a tactic to get good guesses at it and a big help would be tracking down information. However I dont want to spend hours putting in my information. I kinda want to just type in a short form of information and then excel sorts it out in the correct way.
For example:
Number | Winstreak | Amount BET | Whats bet on | Win/Lose | What the coin landed on | Profits | Person | |||
50 t | lose | me | 1 | - | 50 | Tails | Lose | Heads | $ -50 | Me |
5 h | win | shee | 2 | - | 5 | Heads | Win | Heads | - | Shee |
50 t | win | me | 3 | 1 | 50 | Tails | Win | Tails | $ 50 | Me |
50 t | win | me | 4 | 2 | 50 | Tails | Win | Tails | $ 50 | Me |
600 h | win | me | 5 | 3 | 600 | Heads | Win | Heads | $ 600 | Me |
50 t | lose | me | 6 | - | 50 | Tails | Lose | Heads | $ -50 | Me |
250 t | win | me | 7 | 1 | 250 | Tails | Win | Tails | $ 250 | Me |
500 h | lose | me | 8 | - | 500 | Heads | Lose | Tails | $ -500 | Me |
500 h | lose | me | 9 | - | 500 | Heads | Lose | Tails | $ -500 | Me |
1000 h | lose | me | 10 | - | 1000 | Heads | Lose | Tails | $ -1,000 | Me |
1500 h | lose | me | 11 | - | 1500 | Heads | Lose | Tails | $ -1,500 | Me |
319 h | win | me | 12 | 1 | 319 | Heads | Win | Heads | $ 319 | Me |
100 t | win | me | 13 | 2 | 100 | Tails | Win | Tails | $ 100 | Me |
100 t | win | me | 14 | 3 | 100 | Tails | Win | Tails | $ 100 | Me |
200 h | win | me | 15 | 4 | 200 | Heads | Win | Heads | $ 200 | Me |
200 t | win | me | 16 | 5 | 200 | Tails | Win | Tails | $ 200 | Me |
100 h | win | me | 17 | 6 | 100 | Heads | Win | Heads | $ 100 | Me |
73 t | win | me | 18 | 7 | 73 | Tails | Win | Tails | $ 73 | Me |
100 t | win | me | 19 | 8 | 100 | Tails | Win | Tails | $ 100 | Me |
100 h | win | me | 20 | 9 | 100 | Heads | Win | Heads | $ 100 | Me |
100 t | win | me | 21 | 10 | 100 | Tails | Win | Tails | $ 100 | Me |
100 t | lose | me | 22 | - | 100 | Tails | Lose | Heads | $ -100 | Me |
<colgroup><col span="3"><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
For everywin i want to add the winstreak record, but if i lose the winstreak gets reset. However i want to also have a highest winstreak cell somewhere. Now a win from someone else also shouldn't be counted because in this case we have the person Shee in there aswell. Also i want if i put Tails in there and i won, it will tell it was tails, but if i lost it would tell it was Heads. Now this information is kind of clusterbombed like this so i will also leave my Excel file in here. I'm not sure how to achieve these results on my alone. I'm not too familiar with VBA aswell.. So i would appreciate it if some of you people have solutions for me, or something to make it easier!
Many thanks!
Yours sincerely,
Ramballah
https://drive.google.com/open?id=1ZvhP2j3eohsrVw9NoNdXgUREl8xdOvUB
The thing is in sheet 2.