Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Australia Sports Betting Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Betfair
Results 1 to 1 of 1
  1. #1
    New Member
    Join Date
    Jan 2022
    Location
    Belarus
    Posts
    1

    Post Need professional help in Excel on the betting tracker spreadsheet

    Hello, my name is Dima(Dzmitry), I am from Belarus. Recently I started making a table in Excel for calculating rates and statistics for my needs, but decided to find a ready-made solution and change it for myself. So I got acquainted with your interesting table betting tracker v2.21 $. I added a couple of items in the Performance Summary sheet: 1) Percent of Bank (2-5%) and 2) Calculation of the bet amount based on the desired profit, and also added 3) statistics for the bank amount and ROI amount by day / week / months / years / total (I also want to add my own schedule for them when I solve the current problem). Since I opened Excel only 5 times in my life (I am not good at it, and made all the innovations using the Internet), I ran into a problem in calculating the amount of Bank and ROI, I don’t know how to find a beautiful and elegant solution in the form of the required formula or any other changes in the table. The bottom line is, when I put one bet, everything counts correctly, but when I put Multi Bet 2,3,4, then an empty row appears in the column and my formula does not count the previous row and gives an error. How to make the column continue to count the sum if the cell at the top is empty, so that the formula takes the last value and sums it up, or just inserts it. If there is a person who is very well versed in this program, then he will be interested in solving this problem, since due to my capabilities, knowledge, subtleties and flexibility of this program, I am weak, so I am writing here. I would be glad for any help! (a table with my changes is attached to the post https://anonfiles.com/l7o6E94ax2/bet..._advanced_xlsx).
    https://ibb.co/Z6q2rPH
    https://ibb.co/pdttj70
    https://ibb.co/kcGB8jW
    Last edited by noporschenolife; 3rd January 2022 at 01:17 AM. Reason: не вся информация

 

 

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •