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...
Automated Campaign Tracker v2.0 (Tyrants of Lothal Added)
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.
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!
Looks like there's a typo in MHD-19's class cards. Bacta Radiator is listed twice, the 1XP card should be Bacta Injector.
On 3/28/2020 at 11:05 AM, ArtemisKnab said:Looks like there's a typo in MHD-19's class cards. Bacta Radiator is listed twice, the 1XP card should be Bacta Injector.
Thanks, fixed.
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.
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.
I found the issue with the sold item calculation. On the Calculated Data sheet, cell B32 should be:
=sum(A20:D29,B30:D31, A 33:D34)
Right now it's =sum(A20:D29,B30:D31, B 33: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 ArtemisKnab14 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, A 33:D34)
Right now it's =sum(A20:D29,B30:D31, B 33: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.