02-19-2017, 11:33 PM
Upgraded to v3.6f - my pet orb tier 4 is working well, but expeditions sheet is not working now, but that may be problem with importing or I don't know.
Anyway I have found one fromula that is a bit off, it isn't that important, but I am getting annoyed of it. In pet sheet:
Pet 1 promoted(days) there should be formula =iferror(if(NY17=15,"", IF(AM10="Pet #2",CEILING(OH17/(NX27*NX28)),CEILING(OH17/((NX27*NX28)+AM15)))),"")
Pet 2 promoted(days): =iferror(if(NY18=15,"", IF(AM10="Pet #1",CEILING(OH18/(NX27*NX28)),CEILING(OH18/((NX27*NX28)+AM15)))),"")
NX27 represents training value
NX28 - number of trainings a day
currently there is instead of NX27 cell NX28 and instead of N28 cell NX29
Anyway I have found one fromula that is a bit off, it isn't that important, but I am getting annoyed of it. In pet sheet:
Pet 1 promoted(days) there should be formula =iferror(if(NY17=15,"", IF(AM10="Pet #2",CEILING(OH17/(NX27*NX28)),CEILING(OH17/((NX27*NX28)+AM15)))),"")
Pet 2 promoted(days): =iferror(if(NY18=15,"", IF(AM10="Pet #1",CEILING(OH18/(NX27*NX28)),CEILING(OH18/((NX27*NX28)+AM15)))),"")
NX27 represents training value
NX28 - number of trainings a day
currently there is instead of NX27 cell NX28 and instead of N28 cell NX29