PDA

View Full Version : Need professional help in Excel on the betting tracker spreadsheet



noporschenolife
3rd January 2022, 12:47 AM
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/betting_tracker_v2_21_advanced_xlsx).
https://ibb.co/Z6q2rPH
https://ibb.co/pdttj70
https://ibb.co/kcGB8jW