Handy Excel-based Scenario analyzer (using data from ROAR)

Handy Excel-based Scenario analyzer (using data from ROAR) 2.2

No permission to download
Game Name
Hello all,

Ever wanted to see at the same time both ROAR balance and rating for each scenario?

Just wanted to share a spreadsheet that I created for myself and have been using for a while. It displays scenarios by publication and, using data from ROAR, shows both rating and balance along with basic info such as which nationalities are involved and how long the scenario will take in hours to play (estimated) and other details (e.g. OBA, Night, Bocage...). See screen shot below.

Also included are tabs that can track your played games as well as a list that one can create easily that shows your "want to play" list.

Let me know if you like it and if you have any ideas to improve. Enjoy.

NOTE: The new version can be easily downloaded by clicking on the orange button at right. (No longer does it direct you to an external site for download. I have been able to reduce the size of the Excel file to fit within GameSquad's size limit. Primarily, I was able to do this be removing all the ROAR data. So, to start, you will have to follow the instructions on Sheet 1 to download this data from ROAR. Should only take you a minute.


For those who have their personal game history already loaded in ROAR, and wish to download this data into this worksheet, here are detailed instructions on how to do so:
  1. Open the “At-A-Glance” worksheet.
  2. In the Worksheet, create a new empty tab by clicking on the + sign on the bottom row.
  3. Log in to ROAR and go to your Personal History page. Select Edit>Select All, then Edit>Copy.
  4. Go to the new empty Excel sheet that you just created and click in cell A1. Paste the copied data here (CNTRL V).
  5. Select all of the played scenario IDs in Column D. Copy (CNTRL C).
  6. Go the tab entitled, “My Played Scenarios”
  7. Click cell E2. Paste (CNTRL V). Note that the scenario titles (if found in ROAR), will automatically be listed in Column C).
  8. Repeat steps 5-7 for the dates, side and opponents.
  9. Once all this is completed, you can delete the new tab. To do this, right click on "Sheet1" tab at the bottom, then select "Delete". Save the worksheet.
  10. Note: You will need to manually enter the result (column K) for each played game. If you copy and paste this column, the win-loss total generator will not function. Also, if you want to enter your opponent’s side and Publication, you will need to enter this data manually as well.
Reactions: xyz and Misterhawk
First release
Last update
5.00 star(s) 3 ratings

More resources from KenH

Latest updates

  1. Latest version. Minor upgrade from 2.0b. Don't use 2.1. It had a bug in it.

    Repeat: Don't use version 2.1. The ratings column didn't work in that version.
  2. New version - corrects a problem

    ASLers, If the version that you have is no longer working with ROAR and cut-and-pasting data...
  3. How to add new scenarios to the list within the Excel workbook

    For those of you who wish to add more/new scenarios to the workbook, there are two ways to do...

Latest reviews

Awesome resource - it provides a very quick way to determine which scenario would be a great one to play. The classic red, yellow, green rating / balance scale is super intuitive.

Thanks for the great contribution.
You are welcome, Jim. Thanks for the feedback and 5 stars!! I put some sweat into that spreadsheet and love to see it put to good use by others. Ken
Very useful spreadsheet. Avoids selecting scenario's you've played before. Thanks a lot for making this.
You are welcome, Hennie. Thank you for the feedback! If any suggestions for improvement, please let me know.
This absolutely ROCKS .. thanks so much for working on this!! Certainly gonna make it much easier to pick out my next scenarios. Plus the "Wish to Play" and "Played" tabs are terrific!
Glad you liked it, HK! And thank you for the 5 stars!!!

So, you've had this sheet for a few months now. Are you still utilizing it? If so, any suggestions for improvement? Or, any specific scenario packs that you'd like to see added (I can't add them all...).