Basically how my spreadsheet works is it takes the dailies a movie has already made (so 15 days in this case), then extrapolates using the daily drops from the future days onward (so from day 16 onward in this case) of the movies on the left side to get a guesstimate domestic total. Then I use the current dom/int split to guess the WW total. It's not perfect, but just fun to throw in some comp links into my spreadsheet and it does it all. The graphic is the part that takes a while to make lol.

Here's a pic of a part of my spreadsheet

Big mistake I just realized on this graphic, but does not effect the projected numbers, but MI has made $126M after 15 days not $82M. I believe that $82M was a carry-over from a graphic I duplicated as this basis for this graphic. Apologies.

The projected numbers are still correct as the spreadsheet does all the numbers itself. The graphic is where human error comes in lol.