Not the most productive day in my life! (Fooling around with excel)
Well the tittle says it all. Not really a productive day at work, due to a lack of motivation. Luckily this doesn't happen a lot.
In stead I am fooling around with excel again. Fooling around with excel is more of a hobby for me, but you need to have a goal. Sometime ago, I did created an excel for my Crypto Portfolio. All the graphs and figure used when posting about the crypto journey are from there!
SBC
There are lot of excel available to track your sports bets but while most of them are usefull, they are not mine. So it was time to create a new one. I have tried many times before, and finalized some but there weren't what I was looking for.
So, today a new attempt has been started.
At the moment I am 3 tabs for.
Tab 1: The bets
In this tab all the bets are placed. Some field are automatically calculated, others are input.
Depending on the result of the bet, the automatic formatting kicks in.
Still not happy with this one. I do like to track my bets life. And for Single bets this isn't a problem, but for the Parlay, Acca's or Lucky 15, it is.
This will become more clear when I will discuss the second tab. The problem I was having was that this originally was formatted as a table, which did make the excel pretty big. In this attempt I left out the auto table of Excel and it is just a spreadsheet, which make the excel smaller and a lot faster!
Tab 2: Templates
Of course, different betting types require different input and different calculations.
That why on this tab all the betting types are listed which I do play. Each has it own calculations and if I do place a bet, the appropriate betting type is copy to the Bet tab.
No color here, because that would ruin the conditional formatting when copied to the betting tab.
As you can see a lucky 15 takes a lot of row due to it various possible outcomes and calculations.
Before today each time I did copy the bets in the betting tab and when the bets were won or lost. I would copy past the header row of a bet and remove the details.
The idea behind it was to make the excel file smaller in size. But the size was so big due to the table use in Excel.
Monthly report
I am not a graphical designer, which is pretty proven by this tab. I do try to use some different colors and try to find a decent place of the different type of overviews and charts. But that isn't always easy!
But I do like the result more or less.
The monthly reports is created to give a quick overview of the selected month.
If I do change the month, all fields are recalculated and the days of the month are generated again.
The goal is too quickly spot some leaks. Which bets are working and which aren't.
Still have some place left in the upper right corned. There will be the highlights of the month.
Best day, worst day and so on!
Still to do
- Besides the monthly overview I also want to create a tab with a yearly overview and an overall overview.
- At the moment when I am changing laptop, the one is in English while the other is in Dutch. So this gives some problems with the weekdays and the conversion of the date into a year. In one formula it is "yyyy" while it should be 'jjjj' in the other! Will have to automated this.
- At the moment it is focused on the betting type and don't have information about the competition in it yet. Probably I will add that next week. Should not be too much work. Just adding a column to the template and bet tab. Probably it is better to do this quick task today, before too many bets are entered and I will have to dig up some old records to fill in the competition!
- Automatic generating the Steem tables from the bets placed for the SBC league.
Now that it is from me today.
Will post my bets, later today or tomorrow.
Yesterday was a good day with a small profit due to a missed live bet!
Good luck,
Peter
Sports Bettors On Steemit Unite and Join the SBC !
@steemitbloggers
Pretty good so far!
Without seeing the file it is difficult to know if I can give any advice. But let me try a simple question. Did you try the function "right" to automatically grab the year from the date column?
Yep, tried it.
The date in the bet tab is manually entered. The format is choosen by the field properties date.
Than this is split up in to 3 fields. For the year (out the top of my head) is tekst(cell;”jjjj”). But this fails when I do open it on the home laptop which is an American version.
Here it does expect “yyyy”.
Did try a lot already. Guess I will have to use my old VBA skills 😔
I think the function =rechts(A5;4) could do the job. Did you try that one?
Nice work so far !
Interesting how we can quickly start a simple spreadsheet and how it quickly expands to a full blown model with reports. Sometimes it is fun but after a while it becomes a burden (in my experience)!
It indeed does.
You are right, those bettors/gamblers should just bet money and accept that they mostly lose money in the long term. They don't need any model to tell them that 😜
😂😂😂
Upvoted.
I wish to see that same comment below my posts more often!
Btw I also prefer that you buy another 100k Steem before you upvote my shit 😋😜
No problem. I will exclude your account so you don't get any upvote.
I just informed your boss about your inactivity of today 😜
Which one 😂
Good question!
My wife always complains about my inactivity.
😂😆
She's of course talking about me not doing anything in our house 😀
Hi @fullcoverbetting!
Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 3.655 which ranks you at #5228 across all Steem accounts.
Your rank has dropped 83 places in the last three days (old rank 5145).
In our last Algorithmic Curation Round, consisting of 207 contributions, your post is ranked at #62.
Evaluation of your UA score:
Feel free to join our @steem-ua Discord server