OPTIMAL PROPHECY LENS CALCULATOR - CHEATSHEET - CIRCLE OF FORTUNE | Last Epoch 1.0

[@FrozenSentinel]

TLDR / How to: Before starting go to File -> Make a Copy On the 'Lens Calculator' sheet: Check the boxes for Prophecy Rewards you want. Enter the configuration for your CoF Rank and targeted Region. Enter the Lenses you want to check. On the 'Prophecy Events' sheet check the boxes for Prophecy Events you want. Compare the 'Expected Rerolls' and 'Favor Cost Per Item' based on your lenses - lower numbers are better! The sheet has data validation to make sure your lens selection is valid. There is a "blocker" combination preview on the 'Lens Calculator' sheet that will tell you the blocker lens effectiveness based on your selection. Usually blocker lenses are NOT optimal, but in some niche scenarios they may be, if you see anything above +100% 'Difference Per Lens' it is worth trying in the lens selection. PLEASE LEAVE YOUR SUGGESTIONS / FEEDBACK! Let me know of any bugs so I can address them!

[@dodang_9147]

dunno. i copied it and it looks like a lot of stuff has errors such as total available events and all of the monolith blocker stuff has !Ref errors. seems like you need copy all other excel spreadsheet alongside it to use the tool. It could be neat tool.

[@FrozenSentinel]

@@dodang_9147 Hmm... I just made a copy and that copy works for me, you do need to copy the whole book though, it references prophecy events

[@kamm3021]

Oh man the mount of effort and energy put into this 😨 Thanks for doing this to the community

[@danielblackford5989]

Always going to comment in support of good work that is shared with the community, thanks so much

[@Paragonofcynicism]

Thanks for the hours of work you put in

[@karxx000]

Godlike When you run out of things to optimize, health effectiveness seems like a good one. Either way youre doing gods work ty

[@slavisamacanovic155]

It would be real shame not to code this into one of well known tools and attribute this author. This is brilliant.

[@FrozenSentinel]

:D

[@Garloth400]

Dang it! I knew I was wasting the lens slot blocking arena trying to get more monos! Thanks for the awesome work!

[@anthonyswarringin4123]

U deserve all the likes and comments. Great work.

[@AleryZz]

Pure insanity

[@TheStrugglefish]

Leaving a comment and a like, not sure if I'll use the tool, but your videos are very informative, and I appreciate the dedication and hard work!

[@randomnamex7974]

Wow great job. This must have taken a ton of effort but it is appreciated! 😀

[@ItzFozy]

THIS IS ACTUALLY NUTS

[@Uli_Krosse]

You are nuts, dude. I say that with the utmost respect. That whole thing took a lot of time and dedication. Thank you for this one. Maybe I'll try to hammer this into a webapp some time just as practice.

[@FrozenSentinel]

I might be able to help a bit if you need, I am a Web Dev

[@leoj2456]

Your work is amazing, man. Congratulations

[@FrozenSentinel]

Thank you!!

[@martym5039]

Brilliant work! Your spreadsheet is on a whole other level!

[@RyouuGyn]

Great work as always! Have my upvote!

[@malapias]

Great job as always.

[@Chuckthulu]

Excellent work.

[@XViper123]

Not all heroes wear capes. :)

[@FrozenSentinel]

[@XViper123]

@@FrozenSentinel Any time!

[@David-hw9si]

appreciate your work here. Would be nice if they can make the grind a tad better at least for CoF players that don't plan on playing the gold buying game.

[@MaKo-mj6wy]

Thanks dude, next one is on me

[@FrozenSentinel]

Thank you so much! :) Be sure to stay tuned for more stuff like this with the start of cycle 2

[@blazedehart2748]

Wow. This is WILD.

[@fabiencoze1189]

Excellent ! Thanks for the huge work 😊

[@adiozerg117]

You could not of posted this at a better time, no work for me tomorrow and I can’t wait to play around with this while I farm!

[@FrozenSentinel]

Let's gooo! Please be sure to leave any suggestions! I'll take to make more improvements when I get time, and hopefully automate it so you don't need to "guess" what the best lens combo is

[@xlorida]

could not have*

[@adiozerg117]

@@FrozenSentinelwow what a beast of a file lol. I used it and liked how it also reiterates what you state in your videos.

[@daimpi]

Very cool thanks a lot 😊

[@petergerkens6045]

Close to CHEATING!!!! Hahahah KIDDING I love this and helps me get closer to what I really want,ty! :D

[@darthsmitev6035]

Dude u r amazing woha... w8 hold up tho... How r u so smart >.>

[@joshuaarce3098]

My body is ready

[@FrozenSentinel]

SAME!

[@VioneRa]

Hi, FrozenSentinel, thanks for great content, it helps alot! Could you make a comparison video of the trade guild and the CoF using a specific example of getting the desired item? For example, I play CoF in Legacy and my friend plays Trade, and he gets items far faster than I do. Simply LP1 Unstable Core could take me days and days to farm by prophecies, while my friend can just go to market and buy 3 of them for the amount of money corresponding to a couple of hours of playing. CoF should be inferior, I agree, but the developers need to find out how much it is right now))

[@FrozenSentinel]

It's hard for me to comment much on MG since I've only played CoF, I think Perry the Pig and Dr3ad have had some pretty good talks on this as they both split focus from the start.

[@seanstrickland6501]

GG Mate.

[@RhebelGaming]

Cool!

[@Jaguar2kicks]

I now believe you just really love to use Excel but using Last Epoch as an excuse to make a data base… shame on you…. lol just kidding.. Awesome job on this man. You’re the best next along with Curse.

[@FrozenSentinel]

Haha, the funny thing is that Excel actually has a competitive scene, it's pretty cool

[@cH1n0eL]

Freaking Einstein over here.

[@Kidam101]

@xarrio twin ?

[@FrozenSentinel]

Haha heard that one before :D

[@TheBazzterd]

LE not being a PoE like game is what most players wanted.. and here we are turning it back into a PoE... I mean good for the people who wants to use it, but ill skip and just keep the normal gaming experience :) (dont get me wrong, impressive work u did but FOR ME when ur gonna use spreadsheets for a game, ur not treating it as game anymore)

[@FrozenSentinel]

This IS part of the game for me, I just love numbers, data, etc. The tools are there if you want them, but if not that's totally fine too! Everyone can play the game exactly the way they enjoy

[@PassTheJohns]

Just because you want to mindlessly play it, doesn’t mean that all of us want to. Some of us want to put thought behind things and understand mechanics that the game is built upon 😂

[@darthsmitev6035]

@@FrozenSentinel Yeep and u r not only allowed to mindlessly play the game on one front but also enjoy it to the fullest as you r doing Senti its a win win and I see no problem! ;]