Quests & Challenges

@mysteriously @dark78660 @Sellenair @Swageus @Leeviathans @astereia @Rokkan @hollypox @pulchritudinous @nevvermore @Tarany @Osskiar @Dekomaru @TortoiseLynx @mothscale @miles3140 @Catoblepon

Well, a new festival comes with a new day-one spreadsheet fix! I shared the personal sheet with an unfinished version of the badge builder, so if you'd like to use that to track your badges and generate BBcode, you'll need to move your points over to the updated spreadsheet. If you don't use the badge builder, feel free to ignore this message!

Personal sheet link

[size=1]@mysteriously @dark78660 @Sellenair @Swageus @Leeviathans @astereia @Rokkan @hollypox @pulchritudinous @Nevvermore @Tarany @Osskiar @Dekomaru @TortoiseLynx @mothscale @miles3140 @Catoblepon @nebulaxie @bugcrimes @Beatoriche @chunsah @dads[/size] Sorry for the double ping, but I have one more fix! If you're using the badge builder, you'll need to copy this formula into cell J14 for your battlestones to be counted correctly. [code]=IF(SUM(COUNTUNIQUE(Loot!$S$3:$S$30), COUNTIF(Loot!M7:Q18,">0"))>=H14, "[img]"&HLOOKUP(concatenate($D$2, " 2021"), badges!$C$1:$Z$11, 11, false)&"[/img]", "")[/code] If you make a new copy of the personal sheet after seeing this message, no need to change J14 -- the fix is already applied.

hi, i dont know if this is me recording wrong or what but i've somehow managed to get negative points? i might be recording things in the wrong cells but im not sure how to fix it.

edit: never mind, i think i figured it out!

@hollypox No worries, that's something we have to update on our end! Thanks for the reminder!

Here's to another fantastic year to the PSH crew ! Thank you as always for providing a fun little competition for us and best of luck to all the participants :> Fingera crossed that Icepop blesses everyone's drops [emoji=gaoler happy size=1][emoji=music notes size=1]

[size=1]@mysteriously @dark78660 @Sellenair @Swageus @Leeviathans @astereia @Rokkan @hollypox @pulchritudinous @Nevvermore @Tarany @Osskiar @Dekomaru @TortoiseLynx @mothscale @miles3140 @Catoblepon @nebulaxie @bugcrimes @Galactina @Beatoriche @chunsah @dads @angemagica @Sunsire @TheAwesoMew @blazebrem @ghostingskies @Talise @divitineo @Pensacola @Sinnouk @DaDragon @StarNovas @Cerberus38 @seen @Gourami @Wizardry @pangolinparade @apsidee @catalyticgenesis @ClearBright @Tenrecidae @NotarySojac[/size] Its still the first day so of course more bug fixes! This is for the Badge Builder again but for the unique familiars! So if you are using it you will need to make this change.[br][br] [code]=IF(COUNTUNIQUE(Loot!Y3:Y94)>=H13, "[img]"&HLOOKUP(concatenate($D$2, " 2021"), badges!$C$1:$Z$11, 10, false)&"[/img]", "")[/code] Just copy this new formula into J13, and of course any new sheets made after this post don't need to do this as it will have this fix already applied!

Oh, I almost missed it! Could I be added to the general pinglist for any PSHs? :)

@Bakenekodesu
We have a self add/remove pinglist here!

@mothscale
You are correct, I will adjust the fix and main sheet, thank you for catching this!