Credits Tracker and Completion Planner Spreadsheet

Link to the blank spreadsheet template. [docs.google.com]

Copy this spreadsheet to your Google Drive:
https://steamuserimages-a.akamaihd.net/ugc/2912473876163685/E637BACC42750C8574BF59FE5E993F5AE5802510/?imw=256&&ima=fit&impolicy=Letterbox&imcolor=%23000000&letterbox=false

Name it whatever makes sense for you and put it in any folder you'd like. Create "Make a copy"
https://steamuserimages-a.akamaihd.net/ugc/2912473876172286/6C963FAB58DE6ACE03D28C91CBB7317C3B2FC7CB/?imw=256&&ima=fit&impolicy=Letterbox&imcolor=%23000000&letterbox=false

The spreadsheet should open up in a new tab. If it does not, you may need to find it in your personal Google Drive.

There are 5 pages on this overall spreadsheet. I'll go through each of them here.

The only entry needed here is: "Unlocked?" and "Champion?" columns. It is important to note, that every model in multiple categories is repeated for each category. (e.g. "Remington Derringer" is a Pistol and a Pocket Gun, so it appears twice - once for each category). So you'll have to change some entries in 2-5 places. This helped with calculating individual achievements. No entry here is required. Everything here is pulled from the Entry page. This is just to help visualize your overall progress and help with some of the calculations. The only entry needed here is:

1. Daily Streak Start - enter the first day you've started completing daily challenges. If you don't remember, you may need to do some math. If you took a break, the math gets a little complicated.
   
2. Daily Complete Today? - depending on your time zone or when you normally do the daily, it makes sense to leave this on "Yes" or "No" so the calculations add or subtract one day from your completion.
   
3. Spec Ops Complete? - this'll add 20 credits to the calculation if changed to "Yes". The requirements for the Spec Ops can be found in game in the top-left corner.
   
4. Manual Offset - It is possible to unlock and champion models by other means (e.g. Promo Codes, Seasonal Gifts, In-Game Purchases, etc). You can manually add (or subtract) more credits to the final calculation here.
   
5. Last Update for Achievements - not every model within a category is required and I have some speculation that it is tied to a date. You can change that here to adjust the calculations or set more reachable goals.
   
6. Achievement? Scroll down, in Cells G46 to G71 as of time of writing - This is a list of check boxes to mark which achievements you've gotten or not. This does not effect any of the calculations, but makes it easier to filter and see which models you should go for next on the Entry page.

No entry here is required. Everything here is pulled from the Entry and Progress page.

The first table shows how many dollars/credits each credit pack cost. It also calculates how many credits you need for various checkpoints and tells you how many dollars/credits you're getting for the actual number of credits you still need. Note: This is for my currency and country. You may need to change it to reflect local prices.

The second table was just a personal curiosity of mine. What is the range of part count for each difficulty tier? How much overlap is there from one difficult tier to the next? What is the average and median part counts for each difficulty tier?

No entry here is required. Everything here is pulled from the Entry and Progress page. Similar to the first table from the Fun Stats page, this shows how many dollars/credit each pack costs to help determine if a certain pack is worth it. Note: This is for my currency and country. You may need to change it to reflect local prices.