03-30-2016, 04:12 AM
Regarding Huge Loots TCoin, you missed cell N402.
=Round(C391*(1+N401)*$D$55*$D$56)
-> =Round(C391*(1+M401)*$D$55*$D$56)
Ah Google Sheets Merge columns do sound like a hassle. But, keeping track of a lot of variables could be annoying too, and maybe harder to debug?
Well, I'm level 40 and after the 20% event bonus my coin value is perfect.
@quixorbl If it's a level issue then you're suggesting it's a problem with Gold Rate, D49.
Does this look right?
=((Main!H6+'Ascension & Challenge'!E14+Main!L3+Main!L23+Main!D22+D44+D45)+IF(Main!C4>200,((Main!C4-200)*0.03),0)+IF(Main!C4>200,0.25,0))*(1+Main!D14)
Also is there a difference when you reset ascension points or fight different monsters?
=Round(C391*(1+N401)*$D$55*$D$56)
-> =Round(C391*(1+M401)*$D$55*$D$56)
Ah Google Sheets Merge columns do sound like a hassle. But, keeping track of a lot of variables could be annoying too, and maybe harder to debug?
Well, I'm level 40 and after the 20% event bonus my coin value is perfect.
@quixorbl If it's a level issue then you're suggesting it's a problem with Gold Rate, D49.
Does this look right?
=((Main!H6+'Ascension & Challenge'!E14+Main!L3+Main!L23+Main!D22+D44+D45)+IF(Main!C4>200,((Main!C4-200)*0.03),0)+IF(Main!C4>200,0.25,0))*(1+Main!D14)
Also is there a difference when you reset ascension points or fight different monsters?
A leader of Fire Clan