I noticed that from the matches where we have more than 6 salvage, the cards we can transmute from does not scale? I figured that if your salvage is 9 cards, you may transmute from 9 cards.
It looks like the code is pulling off of the wrong cells. This should be fixed now.
# Transmute (B21) still shows (6 - G12) > 0 inside the formula: 6 minus the number of salvaged cards. This part likely needs to be (C12 - G12) > 0
Otherwise you are not allowed to transmute if you salvage 6 cards.
Number of transmutable cards does display correctly when salvaging less than 6 cards.
I see what you are saying now, I caught the mixup in part of the code, and missed it in another.
originally was this: =If((6-G12)>0,IF(J$11>ROW(B22)-21,6-G12,""),"")
I changed it to this: =If((6-G12)>0,IF(J$11>ROW(B22)-21,C12-G12,""),"")
but should be this: =If((C12-G12)>0,IF(J$11>ROW(B22)-21,C12-G12,""),"")
Should be fixed now, but if this still isn't working right please let me know and I'll try again.
@WMs - Team Earth's vault is experiencing a similar issue. Please Help!
I double checked and this should be fixed on all 12 team vaults.
16 hours left and my vault still show incorrect number of dust for transmutation
All teams should have the proper dust amounts in relation to this wars market costs.
we are having incorrect number of players again, halp
I am not seeing the error on this end, even after trying to play with the player position cells. Remember to have your player positions selected from the dropdown options in cells B35 to B43. If you have a full team of 4 players selected, and the error is still popping up I will look into it. Currently I am unable to reproduce the error, sorry.