Great worksheet! I am using it. Just to let you know, Mon Mothma is not adding her 30 points to the fleet when you select her.

2 hours ago, kzilla said:

Great worksheet! I am using it. Just to let you know, Mon Mothma is not adding her 30 points to the fleet when you select her.

I see where the problem is and will fix it when I get home tonight.

A bug in GoogleSheets doesn't always adjust all cell references when you add/remove a row. This bug is driving me crazy. Updates to static data (including any new upgrades added to Armada) require that I manually check and update any calculations not automatically adjusted for a row/col add/delete. I'm currently maintaining 4 spreadsheets (the 6 and 8 player templates and 2 CC campaigns that are live) and missed the check for the Commander formula. Grrrr. Sorry.

Thank you.

31 minutes ago, Thraug said:

I see where the problem is and will fix it when I get home tonight.

A bug in GoogleSheets doesn't always adjust all cell references when you add/remove a row. This bug is driving me crazy. Updates to static data (including any new upgrades added to Armada) require that I manually check and update any calculations not automatically adjusted for a row/col add/delete. I'm currently maintaining 4 spreadsheets (the 6 and 8 player templates and 2 CC campaigns that are live) and missed the check for the Commander formula. Grrrr. Sorry.

Thank you.

No problem man, you have done the Emperor's work here. I quick and easy fixed it on my own. Keep it up!

I don't know if I should continue posting these, but I found some more issues, assuming they are not unique to my copy of the document.

1) It appears that Bright Hope is the only title available for the Rebel Transports in the 6 player version, though both are there in the 8 player version.
2) Whenever I click the arrow to select a title, the first time I select it, it says '#N/A'. This sometimes lasts for several clicks to the button, sometimes it works on the second go, but always the first try doesn't work. I checked, and it does not seem like this is due to the ship still registering, since I waited for the points total to change and the page to register other input.
3) As a very insignificant oddity, when you click on the text occupying the cell in row 9, column C, which contains the slot for the ship's title, it turns a different color. This only happens on this cell, as far as I can see.

3 hours ago, NobodyInParticular said:

I don't know if I should continue posting these, but I found some more issues, assuming they are not unique to my copy of the document.

1) It appears that Bright Hope is the only title available for the Rebel Transports in the 6 player version, though both are there in the 8 player version.
2) Whenever I click the arrow to select a title, the first time I select it, it says '#N/A'. This sometimes lasts for several clicks to the button, sometimes it works on the second go, but always the first try doesn't work. I checked, and it does not seem like this is due to the ship still registering, since I waited for the points total to change and the page to register other input.
3) As a very insignificant oddity, when you click on the text occupying the cell in row 9, column C, which contains the slot for the ship's title, it turns a different color. This only happens on this cell, as far as I can see.

Please keep them coming, you are a great Q&A resource, something I'm obviously lacking.

Numbers 1 and 3 have been fixed in version 3.3.
There isn't anything I can do fix #2. I'm at the mercy of their event updates and it simply won't refresh the items in the list until after you drop it down once and see that '#N/A'. It works for me the second time, after waiting a little bit after changing the ship type.

Technically, I'm using dynamic Data Validation lists, since every ship has a different title set, and the data to populate the title lists is on a hidden sheet of calculated data. When the ship type is changed the list of title selection has to be altered and this change must not be firing a update event for the title cells until it's used. I may be able to force a cell update via JavaScript but I'll save that for a rainy day, ... maybe!

If you don't want to re-enter all your campaign progress you can follow these instructions to update your spreadsheet:

1. In the top menu, go to: "Tools" -> "Script editor"
2. In the script, find the function "calculateCampaignPoints" and replace it with this updated version:

function calculateCampaignPoints(battleData, playerNamesOnMyteam)
{
  var location = battleData[0][0];
  var assaulter = battleData[0][1];
  var defender = battleData[0][2];
  var objective = battleData[0][3];
  var winner = battleData[0][4];

  // if we lost battle
  if(getIndexInColRangeForVal(playerNamesOnMyteam, winner) == -1)
  {
    // CP is always 0 for the loser
    return 0;
  }

  // if objective is a Special Assault
  if(objective.search("\\[Special Assault\\]") != -1)
  {
    // CP is always 0 for a Special Assault objective
    return 0;
  }

  // minimum 1 CP for winning an objective that is: not a Special Assault, not a Base Defense, or as the defender of a Base Defnese objective
  var cp = 1;

  // if objective is a base defense and Assaulter is on my team
  if( (objective.search("\\[Base Defense\\]") != -1) &&
     (getIndexInColRangeForVal(playerNamesOnMyteam, assaulter) != -1) )
  {
    var sheetSystemsTracking = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetNameSystemTracking);
    var locationData = sheetSystemsTracking.getRange("A3:C27").getValues();
    locationIndex = getIndexInColRangeForVal(locationData, location);
      
    // Add VBV value for battle location
    cp += locationData[locationIndex][2];
  }
 
  // 1 CP for winning an objective that is: not a Special Assault, not a Base Defense, or as the defender of a Base Defnese objective
  return cp;
}

Version 3.5 has been released. Changes:

• Campaign Points for the winning Assaulter of an attack on a Rebel outpost were not being given the extra Victory Point Value of the Location. To accommodate this condition there is now a "OUTPOST DEFENSE?" drop-down menu on the "Team Status" Battle History tracker. Set this to "Yes" if the battle was defending a Rebel Outpost.
• The 8-player version is no more. I do not have the time to maintain both a 6 and 8 player version.

Link:

• Template: Corellian Conflict Manager 3.5

Really great stuff, my group loves using this.

Question: where do we add the extra credits gained from a special assault?

6 hours ago, Tvboy said:

Really great stuff, my group loves using this.

Question: where do we add the extra credits gained from a special assault?

In each players ledger at the bottom of the fleet sheet. Its not auto calculated, and has to be added to whatever income you enter for a player's resources for that turn.

Hate to break it to you, but I seem to have found another issue: CR90Bs aren't given the Ion Cannon slot. . .

23 hours ago, NobodyInParticular said:

Hate to break it to you, but I seem to have found another issue: CR90Bs aren't given the Ion Cannon slot. . .

I don't think it matters. It's just grey formatting. you can still use the dropdown.

Aslo: hi @Thraug . I just wanted to send my huge appreciation for the effort that you've put into this. It's an incredible labour of love and almost indispensable. Thank you!

Just now, ManInTheBox said:

I don't think it matters. It's just grey formatting. you can still use the dropdown.

Aslo: hi @Thraug . I just wanted to send my huge appreciation for the effort that you've put into this. It's an incredible labour of love and almost indispensable. Thank you!

Thraug fixed that particular issue such that anything entered in a grey slot automatically gets rejected. I was (perhaps unfortunately) the one who pointed out that grey slots were editable and he removed the feature. I got around it by adding the cost of what I wanted to the fleet point total directly, but still, that's a bit inconvenient. Now I don't know if Thraug will continue updating this, but just in case he is still willing to do so, I'm putting it out there.

And I'll echo what you said and give Thraug what would have been a resounding round of applause had he been able to hear it.

28 minutes ago, NobodyInParticular said:

Thraug fixed that particular issue such that anything entered in a grey slot automatically gets rejected. I was (perhaps unfortunately) the one who pointed out that grey slots were editable and he removed the feature. I got around it by adding the cost of what I wanted to the fleet point total directly, but still, that's a bit inconvenient. Now I don't know if Thraug will continue updating this, but just in case he is still willing to do so, I'm putting it out there.

And I'll echo what you said and give Thraug what would have been a resounding round of applause had he been able to hear it.

Ah, I see. A victim of his own great design!

12 minutes ago, ManInTheBox said:

Ah, I see. A victim of his own great design!

Yep. . .

I'll address the issue soon, but I'm on work travel atm.

To fix the CR90 issue go to data tab edit C 121 and change to

CR90|ISD|Interdictor|MC80|Raider\s+2|Victory\s+2

Where should the resource points for doing a special assault be put in the spreadsheet?

1 hour ago, l0ner said:

Where should the resource points for doing a special assault be put in the spreadsheet?

Add the calculated amount to the current turns row, in the column shown below, for each player sheet for each player on the winning team:

Column:

Managment Phase > Resource Points > Gained

44 minutes ago, Thraug said:

Add the calculated amount to the current turns row, in the column shown below, for each player sheet for each player on the winning team:

Column:

Managment Phase > Resource Points > Gained

Erm. . . what?

Also, do the resource points add up over turns? Or must we manually keep track of how much we spend?

Thread necro. Any chance to update with wave 6 or a way to update it myself? I figured out how to add things but can't figure out how to update the formulas.

Ill update within the next week. Ill post here when done. Im dreading trying to get multi upgrade slot cards to work (boarding troops, etc).

I'm working on the upgrade but won't have time to finish it until this weekend. Due the square peg in a round hole implementation I had use to get everything working, and countless bugs in their tool, it's becoming extremely difficult (and lots of frustration) to maintain so this will be the last release. I'll post here when it's done.

39 minutes ago, Thraug said:

I'm working on the upgrade but won't have time to finish it until this weekend. Due the square peg in a round hole implementation I had use to get everything working, and countless bugs in their tool, it's becoming extremely difficult (and lots of frustration) to maintain so this will be the last release. I'll post here when it's done.

Thank you for your work!