Update on the fooling around with the excel

in #busy5 years ago

Good morning all!

I did publish a post in which I was talking about my betting spread sheet creation in excel.

Well things are improving in a rapid pace. Did finish the year overview yesterday evening and only have to complete the global overview.
Also did find a solution for the "jjjj" and "yyyy" problem, which was easier than I thought. I could just use the formula YEAR. Which is automatically converted in the year. By using this I am avoiding the previous problem!

Month

Knipsel.PNG

Things which are changed:

  • the layout has been changed but not yet satisfied with it! Still it suits my needs at the moment.
  • the dates are automatically filled based on the year and month
  • the betting types are automatically filled based on another tab, so if one has other betting types, he just will need to add it to the tab. The same is done for the bookmakers. Due to this I do need to change the layout some more because the size of these tables aren't fixed.
  • depending on the local date the weekdays are printed out in English or Dutch.

Year

Knipsel.PNG

This one is brand new.
We have the month which are automatically printed based on the local date. Depending on the local setting it is Dutch or English, just like the weekdays.
The bar charts have multiple colors, red for a negative profit and green for a positive profit.

Also here the lay-out still have to changed to make it more user friendly. Now the size of the bookie and betting types charts and tables are fixed. This have to be changed to the user whishes in the setting tab!

Overall

Knipsel.PNG
This only a draft with the overview tables. Most of them are already created with the variable table sizes in mind based on the setting tab.
Graphs still need to be added.
The years are added based in the first year which is recorded and then added to the overall overview!

The idea behind the excel

Well the idea is to quickly give an overview of the current betting status and to find leaks. It does already show me that the bets which are published do have a higher chance of being won!

Still to do

  • Automatic generation for the SBC league
  • Changes in tables sizes based on the user settings
  • Changes in the bets tab to make them more user friendly

I was thinking about adding all previous betting records I still have, but this appears to be too cumbersome, so I will not devote time to this yet. These are more than 1000 bets.

I am enjoying myself during the evenings with this work. If you do have any tips, please feel free to give them!

Cheers,
Peter


Sports Bettors On Steemit Unite and Join the SBC !


@steemitbloggers

Sort:  

That's awesome man! I'd love to get good at excel, but just haven't found the time yet. One of these days!

Excel basic is pretty easy, but you can make it as complex as you want!

Yea for sure. I can do most all of the basic stuff, but would love to get into the more complicated. If only there was more time in the day 😂

There is a certain skill in turning data into information. I would find a way to incorporate the 1000 older bet data in a manor that is not time intensive, and is weighted a little less as you have probably evolved your game.

love the stats game and it would work way better than betting with your heart only or on your home team.

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.646 which ranks you at #5309 across all Steem accounts.
Your rank has dropped 1 places in the last three days (old rank 5308).

In our last Algorithmic Curation Round, consisting of 471 contributions, your post is ranked at #172.

Evaluation of your UA score:
  • You're on the right track, try to gather more followers.
  • The readers like your work!
  • Try to improve on your user engagement! The more interesting interaction in the comments of your post, the better!

Feel free to join our @steem-ua Discord server

I wonder what profit/loss did you make in total on these 1,000 bets?

Coin Marketplace

STEEM 0.36
TRX 0.12
JST 0.040
BTC 70846.59
ETH 3567.69
USDT 1.00
SBD 4.79