About

This website is used to mine box office movie data for use in the Fantasy Movie League game. The site will also use a bin-packing algorithm (Microsoft.SolverFoundation.Services) to efficiently create your movie lineup based on the rules of the Fantasy Movie League. Since I have NO idea how to pick movies I figured I would rely on the "experts" and aggregate their data so I can make my own guess on the weekend box office predictions. I'll update this site and these comments when I can. If the site is DOWN, I'll know soon enough (so you don't have to call me). ;) I built this site for my friends and I at NCM when we found out about FML (YEAH, gotta love that abbreviation). We didn't know that NCM was going to buy Fantasy Movie League. As developers we are LAZY, but we'll BUILD things in our spare time so we have MORE of it!

Summary / Home Page

I wish I had the time to make this site pretty like Pete's site, but I keep thinking up functionality and implementing it.

HELP - Where to start?

  1. I typically start with the weights (under the baby blue import field) where I can enter my values. These weights are "trust" values. "How much do I trust certain sources?" These weights are all relative. If you trust Box Office Report 6 times more than Box Office Prophet then put a 6 for BO Report's weight and a 1 for BO Prophet's weight. If you don't trust Box Office Mojo at all, then enter a 0 for that weight and BO Mojo's data will be ignored. When you land on the page all of these weights are set to by default. You can also click on the Moovee Picker banner in the upper left of the page.
  2. The source of the weights are clickable. If the source is green, then the code has found values for it otherwise the source is blue and the values have not been found or the source is old and not during the game week.
  3. Enter a weight below the expert's name and press TAB or leave the field. Changing this weight will trigger a recalculate of the page and the box office. At the moment the URL will not change so you will not be able to share your page until you click the green button "Calculate Picks". This creates a weighted average of ALL the columns and fills in the numbers on the movie posters. Those are YOUR numbers.
  4. If you choose to edit the numbers, the weights above will all go to 0 because you have now created custom values.
  5. You can copy the URL for future reference if you want to edit your numbers later, but you don't have to. At the moment the URL will not change so you will not be able to share your page until you click the green button "Calculate Picks".
  6. SHARE your picks on Twitter using the handy share buttons (with bonus or without). You will see a preview of your tweet and you will be able to edit it before you post.
  • The weights that I currently use as a baseline and then maybe adjust from there. My Default Weights

API / Request Parameters

If you keep your numbers in a spreadsheet you can link directly to the index page and feed it your numbers. There are 15 "bo" and 7 "wl" parameters separated by commas (standard request stuff). You can get a sense of this request if you click the "Apply Weights" button. Maybe you keep your numbers in a spreadsheet, then you can use the HYPERLINK() and CONCATENATE() functions to build the URL for this site so it can help with your picks. That's what Liem does. He copies the aggregated data from the index page and then does his own thing with the data. NOW he can link back to this site for his picks.

Here's a full blown blog post about how to use the Excel functions and "link" to this site.
Word Press BLOG Post

This site's code lives on GitHub. So <meta/> You can look at the history of how all of the code came together. It started out with a few tests and spreadsheets and GREW from there.

Thanks!

Thank you to Pete Johnson who is (was?) the Fantasy Movie League "Nerd Guru". I LOVED his site, because once I have my dollar amounts I can PLAY with the numbers with his cool sliders... What else do Math Majors do? Still unsure if his "solver" code was client side or server side. If it was client side then that code was impressively fast.

Another thank you to the support of the Fantasy Movie League family