m-h-c-t / mh-hunt-helper

Tool to help collect data, estimate attraction, catch, and drop rates for a popular game.
https://www.mhct.win
MIT License
7 stars 14 forks source link

Tagging Event items/aura items #178

Open AlexClaxton opened 2 years ago

AlexClaxton commented 2 years ago

Here is a bit of code I made to identify some of the junk items that come from events/auras/etc that clog up any item tracking: if RIGHT([Item],4) = " Egg" or LEFT([Item],7)="Festive" or CONTAINS([Item],"Snowball") or RIGHT([Item],4) = "Clue" or RIGHT([Item],4) = "Hint" or LEFT([Item],6)="Chrome" or LEFT([Item],6)="Cursed" or CONTAINS([Item],"Gift") or CONTAINS([Item],"Warden Stone") or CONTAINS([Item],"Marshmallow") or CONTAINS([Item],"Dumpling Cheese") or CONTAINS([Item],"Ghastly Galleon") or CONTAINS([Item],"Prize Key") or CONTAINS([Item],"Spooky") or CONTAINS([Item],"Party") or CONTAINS([Item],"Wealth") or CONTAINS([Item],"Cupcake") or LEFT([Item],2)="20" or LEFT([Item],7)="Rift 20" THEN "Exclude" ELSE "Include" END

I believe Aard had some use for this so I'm putting it here.