layinglow
-
Content Count
9 -
Joined
-
Last visited
Posts posted by layinglow
-
-
Hello fellow campaigners,
I decided to go back through my IA Campaign Log created through Google Sheets. I created a post some time back
I went back through it and decided to break up the one campaign log into four separate sheets, one for the Imperial player, rebel players, the campaign itself, and a database to hold all the data points needed to manage all the formulas. This is still a work in progress (WIP) and some functions are being adapted to the new layout.
I am looking for feedback regard the content/format/layout and any other input you would prefer to see.
I am debating on either putting the rebel players item and upgrades onto the rebel section but show it on the main campaign log since it's a rebel function but I thought it might be redundant. to have to go across so many sheets to accomplish the campaign steps.
Here are the links to each sheet:
The current working one sheet campaign log
I want to thank you for taking your time to look and any feedback you can share.
TheSharkJuggler reacted to this -
The validation error you are seeing is "normal" since the J7 cell is used to reference the available side missions and since it was resolved and per rules removed from the available side missions.
Since J7 cell is no longer "Scouring the Homestead" it was prior referencing to the C12 cell is displaying an error because it is no longer part of the formula function.
I hope that makes sense.
If you really wanted to you could make a complete separate google sheet that ties to the original with only the private information the Empire player is to be able see and reference those cells in that sheet to the original Empire sheet so the Rebels can see the public information they should have access to but that would take much more work to update the formulas to reference a complete other sheet.
-
Not to nit-pick, however, you wanted the feedback but for being "Fully Automated" there is a bit of manual adjustments by players to make your Campaign Log functional.
The log has sections specifically set out for extra credits, extra expenses and additional influence spent. If the log was fully automated wouldn't the log take into account the factors that would lead to these adjustments?
The Empire player also has two means to actually gain additional IP based on gaining access to Jabba and the Agenda Card Pulling the Strings. So in order to make the the IP calculator function correctly you have to give a negative value to the additional influence spent section to gain the additional IP. (edit in, actually there is a column for extra influence on the dashboard but isn't intuitive)
The majority of the campaign story missions are set in win or lose scenarios that direct the flow of the story mission progression, e.g. the Core campaign when Empire wins you get the Under Siege mission and when the Rebels win you get A New Threat. If I were to select on Aftermath the Rebels win shouldn't the next story mission "automatically" set to what the mission would be without input from the player?
The Rebel Heroes rewards earned through side missions are not eligible to be sold for credits but you have set a value of 50 credits for selling them. The recent FAQ Page 11 states you can sell XP items for 50 credits but doesn't state mission rewards are eligible.
If you are playing a small box expansion (mini campaign) and you don't bring along that boxes specific Rebel Heroes and you complete their associated mission you don't gain the reward for the missing Hero rather you gain additional credits. The campaign log still states you gain the missing Hero reward though.
You could delete the the extraneous cells from the displayed sheets
The fonts on all the sheets are not identical it swaps between Calibri and Arial.
I might be able to bring out a few more details but I didn't go super in depth through all of it.
-
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
-
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.
-
On 9/22/2017 at 8:45 AM, BlodVargarna said:Hey thanks! I decided to search google docs and found this awesome resource
Hey there,
Thanks for using my Google Sheets product. I am glad people come across it. I don't visit these forums often enough.
subtrendy2 and Uninvited Guest reacted to this -
Thanks!
This is great work.
Can you please also add Return to Hoth Campaign?
All the campaigns have been imported into the google sheet, you just have to select you have the appropriate expansion and it will let you select that campaign from the drop down menu on the campaign creator sheet.
-
I have created a dynamic campaign log for Imperial Assault I thought I'd share with the community here.
I created this to help minimize the upkeep/bookkeeping necessary to track the campaign progress.
The link is to the live version please feel free to save it yourself and use it for your own campaigns.
https://docs.google.com/spreadsheets/d/1eii5P8a14AQKpsppl_5U653l3rwe0_nC3NzEa5tcnTE/edit?usp=sharing
Feedback would be appreciated.
Google Sheets Campaign Log revised
in Imperial Assault Campaign
Posted
Hey there Campaigners,
I have made the last update to my campaign log that handles all the calculations for your campaign with as minimal inputs from the players.
I have made some major changes from my prior version where I had tabs for each player count and decided to consolidate them into just 2 tabs one for full campaigns and one for mini campaigns.
I would like to hear some feedback if there are any changes you would suggest or any errors I have not been able to spot....it is a rather daunting task to review all scenarios.
Thank you,