https://docs.google.com/spreadsheets/d/1ERAM_Akq3bmFJxBDbhuccoUciwbToVh12Hqep28SWkg/edit?usp=sharing

Update: Version 1.2

• Active Side Missions and Rebel Side Mission selection now gray out when playing a mini campaign.
• Cleaned up some errant conditional formatting
• Added The Boon and Bane cards to the Data sheet so that they can now be selected as earned rewards on the Rebel and Empire sheets.

Update: Version 1.1

• Another column in the Dashboard to input additional Influence gained by the Imperial player.
• Changed Crate column to "Extra Credits x50" and made it 0-14. Also added instructions on the side for this column. Don't want people to go adding in the bonus credits they get at the end of the mission for accomplishing an optional objective because that's already calculated in there.
• A section in the Empire sheet where the Imperial player can track extraneous Influence spent.
• Added slots in the Rebel sheet for more sold items.
• Rebels can now keep track of Bounty tokens on the Rebels sheet. This will also cause their names on the Dashboard to light up in Fuschia.

Original Post 11/17/17

As someone who's stuck with an iphone at the moment, I got jealous of the sweet campaign apps that Android users have access to. After switching from Android to Iphone, I really missed having a mobile app that tracked all my campaign results automatically. I started looking for spreadsheet based trackers for Imperial Assault that could be used on mobile with the Sheets app, but most of the ones I found either weren't automated and were just digital versions of the back of the campaign book, or they were not mobile friendly due to having a ton of sheets to navigate or having very spread out layouts. After using @Thraugs awesome Corellian Conflict Manager, which worked quite well on mobile with the Sheets app, I was inspired to try and do something similar for IA. I took it as a challenge to improve my very basic Excel skills and create something cool for the community. FYI, I'm not a programmer or an excel expert, I had to do a ton of googling to figure all this out and took a ton of initial design inspiration from @Thraug's sheet, as I had spent the summer trying to understand how it worked it to make an early update for the new Armada ships.

So here's what I wanted out of a campaign tracker:

• Easy to use, with as much automation as possible. I want to be able to input results while riding the bus or on my lunch break after the mission without having to pull out any books.
• Mobile friendly. As few sheets as possible, compact layout.
• Device agnostic. PC, Tablet, IOS, Android, whatever. Google sheets is pretty ubiquitous I think.
• Retains usefulness even without updates or corrections. Allow users to fill in the blanks with custom values and correct errors on the fly without having to wait for an update from the developer.
• Make the sheet easy to update for new content.

And here's the features I was able to implement after many weeks of work and tinkering:

• Full implementation of all existing campaigns on a single sheet that morphs depending on the campaign you choose. Includes Heart of the Empire as well as support for my own Edge of Oblivion mini campaign as well as blank campaigns for custom campaigns and custom mini campaigns.
• Only 3-sheets to navigate, a Dashboard with cursory overview of player resources, general campaign info and mission progress tracker, and two sheets that show detailed overviews of the Imperial and Rebel players resources and expenses. Each sheet is also compact and easy to navigate on a mobile device.
• Full automation for tracking resources that accounts for all mission specific rewards, including accounting crates and bonus rewards # of Rebel heroes, as well as deductions for upgrades purchased and upgrades that are discarded or sold. Players don't need to know how much anything costs, it's automatically filled out by the sheet. All costs are visible so users can double-check the math on their own.
• Drop-down menus that self-populate based on selections you make elsewhere on the sheet, such as only choosing Active Side Missions based on the missions in the Side Mission deck and the Agenda cards purchased by the Imperial player, and mission dropdowns pull from only from missions that would be available based on the story being played and the side missions available. Drop-down menus also show grey when they cannot be selected, like when a weapon doesn't have enough mod slots or when a player has no resources. Basically players don't have to know the name of anything from memory.
• Cells that turn black and red when a mistake has been made, for example if a player buys more upgrades than they can pay for or if the Imperial player buys a mission Agenda card without updating the Active Side Missions queue.
• Secret Agendas cause their cell to become hidden with black-text-on-black-background to hide from prying eyes. A user can click on the cell to reveal it of course, just like spoiler text on a forum.
• Color Key and simplified Sheet Tutorial are on the Dashboard but off to the side.

Not everything is completely automatic though:

• Rebel players will need to select their starting weapons, but this is made easy by clicking on the cell and typing the hero's first name, which will show you their starting weapon to select.
• When you sell or discard an upgrade, don't just delete it, make sure you put it in the proper queue so the sheet can continue to track the resources you spent on it initially.
• Players will need to select the next mission, but will still be limited to the possible selections at that point in the campaign, so when going into an Interlude for example, there will only be one mission to choose from, but in Heart of the Empire you will have 3 missions to choose from for a story mission.

And finally, I should mention that the sheet naturally has a lot of calculations going on behind the scenes to make all this work, so there is a potential for a slow down. I tried to keep the engine that powers the sheet somewhat organized, but as I was learning a lot of this stuff as I went, some of the backstage stuff got a little messy. I might come back and try to make those a little bit more organized, but for now everything seems to be working. Be warned, while you can update the sheet's engine on your own by going into the two hidden sheets, Data and Calculated Data, changing things in there without knowing what your doing will probably lead to cascading failure through the rest of the sheet.

So there it is, my ambitious little pet project. It ended up being way more work than I had expected, but also a ton of fun to learn and then write each function and then see it finally work the way I wanted it to. I'd really like to know what people think and get feedback, especially from people using mobile devices how the sheet works for them with the Google Sheets app, but also people using it on desktop. I am concerned it may be prone to crashing, but it's been okay on my phone so far. And of course if there's any upgrades missing or calculation errors, please let me know. I was pretty exhaustive in making sure I got all of the rewards and bonus rewards right for each individual mission, but there is a ton of content in the game and there was plenty that I missed on my first few builds.

Oh yeah, here's the link: https://docs.google.com/spreadsheets/d/1M3vNoZDMwAJIrr3ON_iF_wkC8bbDR6TJKrQNlVOMiBU/edit?usp=sharing

The link is view only, you'll have to save a copy to your Google drive by clicking File -> Make a Copy before you can use it. Also do not change anything in the sheet that isn't shaded Green, or else things will probably get screwed up.

This is beautiful. Thank you so much! The amount of work put in certainly shows - I’m excited to try it out during my group’s next campaign!

TV Boy this is great! Well done! I've been working on something similar myself but it's a bit more in depth so I can see how it would take more effort than you initially thought.

Thanks for sharing this with us!

Impressive. Obi-Wan has taught you well.

However..... when you choose a crate value by accident, how do you revert to "0"?

16 minutes ago, Tzarph said:

Impressive. Obi-Wan has taught you well.

However..... when you choose a crate value by accident, how do you revert to "0"?

You can just select the cell and hit the delete button, or the "clear" option on mobile. That's a good question though, I will add to a list of updates to allow players to select 0 from the dropdown list.

Beautiful!

Thank you so much!

Very awesome, I'm amazed with the work that went into it!

Couple comments

Instead of crates, would it not be better to simply type a number in, as there are additional items that provide cash, eg pit droid, valuable goods, etc. Also a value for extra influence for Jabba.

Also it doesn't seem to support when an agenda card costs influence to play it?

there will likely need to be way more space for some stuff, eg sold items.

and what about tracking bounty tokens?

36 minutes ago, neosmagus said:

Very awesome, I'm amazed with the work that went into it!

Couple comments

Instead of crates, would it not be better to simply type a number in, as there are additional items that provide cash, eg pit droid, valuable goods, etc. Also a value for extra influence for Jabba.

Also it doesn't seem to support when an agenda card costs influence to play it?

there will likely need to be way more space for some stuff, eg sold items.

and what about tracking bounty tokens?

These are great points and suggestions, thank you for the feedback. I will incorporate these into an update very soon.

I was looking to how your version compares to my own Campaign Log I created, feel free to play with it as you wish I locked all the cells that are important (I think) or I'll just roll back to a previous version.

Generous Donations Mission rewards spoiler below

The credit/IP rewards with variable rewards such as the mission Generous Donations does not calculate for the rewards variable based on tokens redeemed by either side Empire or Rebel.

There is a item in the supply card deck called valuable goods which can be discarded at the end of the mission for an additional 100 credits. The dashboard doesn't seem to allow to modify the crates to account for the additional credits earned from this scenario.

*edit* I guess you could just add two additional crates at the end to make up for the extra 100 credits you would earn from the valuable goods card

Just a few things I saw at first. I know how exactly how much time it takes to make things, a lot of trial on error on my part.

16 hours ago, layinglow said:

I was looking to how your version compares to my own Campaign Log I created, feel free to play with it as you wish I locked all the cells that are important (I think) or I'll just roll back to a previous version.

Generous Donations Mission rewards spoiler below

The credit/IP rewards with variable rewards such as the mission Generous Donations does not calculate for the rewards variable based on tokens redeemed by either side Empire or Rebel.

There is a item in the supply card deck called valuable goods which can be discarded at the end of the mission for an additional 100 credits. The dashboard doesn't seem to allow to modify the crates to account for the additional credits earned from this scenario.

*edit* I guess you could just add two additional crates at the end to make up for the extra 100 credits you would earn from the valuable goods card

Just a few things I saw at first. I know how exactly how much time it takes to make things, a lot of trial on error on my part.

Pretty much all variable bonus credits that can be earned in the game can be accounted for by changing the number of crates earned in a mission.

At this point I don't think there is any way for the Rebels to earn credits other than multiples of 50 besides selling items and the bonus credits from JR and HotE, and those are accounted for.

I do need to add a way to allow for the Imperial player to earn extra Influnce through abilities like Jabba the Hutt and certain agenda cards.

I like this- simple and elegant. A lot of campaign trackers try to account for more than they need to, and it gets sloppy. This trims the fat pretty well.

Thanks for everyone who gave feedback, here is the updated sheet v1.1, which includes:

• Another column in the Dashboard to input additional Influence gained by the Imperial player.
• Changed Crate column to "Extra Credits x50" and made it 0-14. Also added instructions on the side for this column. Don't want people to go adding in the bonus credits they get at the end of the mission for accomplishing an optional objective because that's already calculated in there.
• A section in the Empire sheet where the Imperial player can track extraneous Influence spent.
• Added slots in the Rebel sheet for more sold items.
• Rebels can now keep track of Bounty tokens on the Rebels sheet. This will also cause their names on the Dashboard to light up in Fuschia.

https://docs.google.com/spreadsheets/d/1oEY6xrJczZI1udzN3PVU3dke0WDXJdMV7qRQY_hReiI/edit?usp=sharing

9 hours ago, Tvboy said:

Thanks for everyone who gave feedback, here is the updated sheet v1.1, which includes:

• Another column in the Dashboard to input additional Influence gained by the Imperial player.
• Changed Crate column to "Extra Credits x50" and made it 0-14. Also added instructions on the side for this column. Don't want people to go adding in the bonus credits they get at the end of the mission for accomplishing an optional objective because that's already calculated in there.
• A section in the Empire sheet where the Imperial player can track extraneous Influence spent.
• Added slots in the Rebel sheet for more sold items.
• Rebels can now keep track of Bounty tokens on the Rebels sheet. This will also cause their names on the Dashboard to light up in Fuschia.

https://docs.google.com/spreadsheets/d/1oEY6xrJczZI1udzN3PVU3dke0WDXJdMV7qRQY_hReiI/edit?usp=sharing

And because of this, you've now surpassed the app in usability

Has anyone started using this in an actual campaign? I'm curious to hear how it's working for people. My next campaign doesn't start until January so I won't have any of my own testers until then.

On 2017/12/07 at 6:23 PM, Tvboy said:

Has anyone started using this in an actual campaign? I'm curious to hear how it's working for people. My next campaign doesn't start until January so I won't have any of my own testers until then.

I have, Jabba's Realm, playing against Hutt Mercenaries. 2 missions in, so not really enough to properly test it, but I'm pretty impressed with it.

My opinion of the app has gone down a lot lately, it hasn't even been updated to support Heart of the Empire yet, can't track bounty tokens, and has a host of other little oversights that just got to the point of being completely unusable.

Your version came at just the right time.

On ‎9‎/‎12‎/‎2017 at 8:53 AM, neosmagus said:

I have, Jabba's Realm, playing against Hutt Mercenaries. 2 missions in, so not really enough to properly test it, but I'm pretty impressed with it.

My opinion of the app has gone down a lot lately, it hasn't even been updated to support Heart of the Empire yet, can't track bounty tokens, and has a host of other little oversights that just got to the point of being completely unusable.

Your version came at just the right time.

The app does away with the Imperial Class Deck entirely. So it doesn't have to track bounty tokens.

2 hours ago, Majushi said:

The app does away with the Imperial Class Deck entirely. So it doesn't have to track bounty tokens.

I'm not referring to the Legends of the Alliance app, but rather the third party campaign tracker app for the standard campaigns I've been using for about the last three years. It was pretty good initially, but slow updates and failure to account for all the mechanics has made it unusable since Jabba's Realm.

44 minutes ago, neosmagus said:

I'm not referring to the Legends of the Alliance app, but rather the third party campaign tracker app for the standard campaigns I've been using for about the last three years. It was pretty good initially, but slow updates and failure to account for all the mechanics has made it unusable since Jabba's Realm.

My apologies. I completely misunderstood what you were talking about. Totally my fault.

For Jabba's Realm on the mission Hostile Negotiations there is an error in the formula that causes some fields to become #N/A

See image below

On 12/15/2017 at 4:28 PM, layinglow said:

For Jabba's Realm on the mission Hostile Negotiations there is an error in the formula that causes some fields to become #N/A

See image below

Thank you, I will take a look tomorrow and give you an update.

Update: Okay, looks like there was a typo in Data sheet, cell K102. You can edit it yourself by clicking the horizontal lines button next to the sheet tabs. I will have to go through every mission to make sure there's no more typos and then release version 1.4.