Jump to content
Tvboy

Automated Campaign Tracker v2.0 (Tyrants of Lothal Added)

Recommended Posts

getting some strange anomolies with side missions lately. the top right of box has a red triangle like there is an error or something? any ideas? i tried playing around and resetting the side mission deck in the sheet but it didn't alleviate the issue...

Share this post


Link to post
Share on other sites
20 hours ago, Viperho said:

getting some strange anomolies with side missions lately. the top right of box has a red triangle like there is an error or something? any ideas? i tried playing around and resetting the side mission deck in the sheet but it didn't alleviate the issue...

Old side missions that have been played will start getting errors once you remove that side mission from the active side missions box at the top of the dashboard. This does not effect anything else in the sheet so you can just ignore it, it's normal. 

Share this post


Link to post
Share on other sites
On 8/27/2018 at 5:59 AM, Tvboy said:

 

Hi

The sold items section doesn't seem to work correctly, removing the item from the hero and adding it to Sold would both refund the full value and add an extra half value.  Also some of the cells didn't calculate anything.  And the unequiped field is only one item.

I also noticed that the extra expenses field didn't seem to add/remove anything from the available credits?

Otherwise, this is a fantastic spreadsheet and a massive help to our campaigns, thank you!

Share this post


Link to post
Share on other sites
On 2/3/2020 at 2:18 PM, neosmagus said:

 

Hi

The sold items section doesn't seem to work correctly, removing the item from the hero and adding it to Sold would both refund the full value and add an extra half value. 

I see this issue too, unless I'm using the sheet wrong. I assume that after I sell an item, it should only be listed under Sold Items and not appear elsewhere on the sheet. But if I do this, the refund is added to my credits but the original amount is no longer debited.

Share this post


Link to post
Share on other sites

Also, looks like there's something off with the Spread Barrel item. If I add it to a hero, I'm debited 300. But if I move it to unequipped, I'm only debited 30. And if I put it under Sold Items, I'm refunded 15.

Share this post


Link to post
Share on other sites
Posted (edited)

I found the issue with the sold item calculation. On the Calculated Data sheet, cell B32 should be:

=sum(A20:D29,B30:D31,A33:D34)

Right now it's =sum(A20:D29,B30:D31,B33:D34) which means it's not counting the cost of the top row of sold items.

And the Spread Barrel cost can be fixed on the Data sheet, if you set cell AK101 to 300 instead of 30.

Edited by ArtemisKnab

Share this post


Link to post
Share on other sites
14 hours ago, ArtemisKnab said:

I found the issue with the sold item calculation. On the Calculated Data sheet, cell B32 should be:

=sum(A20:D29,B30:D31,A33:D34)

Right now it's =sum(A20:D29,B30:D31,B33:D34) which means it's not counting the cost of the top row of sold items.

And the Spread Barrel cost can be fixed on the Data sheet, if you set cell AK101 to 300 instead of 30.

Great finds, I've implemented your fixes in the sheet linked in the OP.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...