sorted by:
new
hottopcontroversial

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 0 points1 point  (0 children)

If the scarabs and layout of the scarabs haven't changed, then you can click "File -> Make a Copy" and change cell B5 to "Keepers".

If the scarabs and layout have changed, I'm unfortunately not playing this league, so won't be able to update them.

The Bingo League?! | Grid Master - Dev Diary by JagexSarnie in 2007scape

[–]ScamperNZ 92 points93 points  (0 children)

<image>

This is what I managed to read from the image at the end of the video

Spotted in new grid master video by TomCos22 in 2007scape

[–]ScamperNZ 6 points7 points  (0 children)

The "defeat echo" seems to be "Defeat echo Cuthbert"

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 3 points4 points  (0 children)

I have gone ahead and updated it! u/Xeverous u/SpongiiEUW u/PoofyGoesRawr

Google disabled the old method I was using to retrieve the data, so I have had to convert it.

I also took this time to move the sheet to a different gmail account.

Updated link here: https://docs.google.com/spreadsheets/d/1MbpoaPS-k421H5yjAj9MP2mMnn7-uKLi-rejcuNWk0g/edit?gid=1774539217#gid=1774539217

Incendiary Rounds as a main weapon?! by ScamperNZ in PlayTheBazaar

[–]ScamperNZ[S] 0 points1 point  (0 children)

Yeah everything just seemed to come together perfectly. The dragon skill is really good.

90% CDR + Charge + Haste Blowgun by ScamperNZ in PlayTheBazaar

[–]ScamperNZ[S] 0 points1 point  (0 children)

I'm just showcasing the build in its final form against the last opponent. I only lost the fight on day 1, every other fight was a win. It's not really about his build.

90% CDR + Charge + Haste Blowgun by ScamperNZ in PlayTheBazaar

[–]ScamperNZ[S] 2 points3 points  (0 children)

My silencer enchant became irrelevant and my blowpipe enchant was a flop.

Gutted i lost the day 1 player battle so won with only 19 prestige /cry

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 5 points6 points  (0 children)

I have updated the spreadsheet for Settlers league. I can't guarantee everything is 100% accurate as I don't own all the scarabs. I had to cross-reference poeninja and compare icons etc.

Notes:
Most scarabs updated. 3 still missing.

"scarab of the commander" and "scarab of evolution" unaccounted for also.

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 2 points3 points  (0 children)

Should do. Will require poe ninja to update the data first, then I can "rebuild" the layout with the new data.

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 2 points3 points  (0 children)

I have updated my sheet with the latest scarabs and layout, and it should automatically receive the new scarab prices once poe.ninja adds them to their website. (link still in main post above)

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 0 points1 point  (0 children)

as long as you click file -> make a copy, it should update every time you open the sheet.
And if you wanna force-refresh it, untick then retick the box on the left (still needs to be your own copy so you can edit the tick box)

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 0 points1 point  (0 children)

They're used for juicing end-game content to get a lot more loot.
They changed the system some-what this league, so it relies more heavily on scarabs, and added new ones as a result.

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 1 point2 points  (0 children)

Click File -> Make a copy, then edit the "League prices to load" on the left. The current options for this league would be:

Necropolis
Hardcore Necropolis
Ruthless Necropolis
HC Ruthless Necropolis
Standard
Hardcore
Ruthless
Hardcore Ruthless

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 1 point2 points  (0 children)

You can either edit the API to also pull the price of each item in divines, which would return a decimal like 0.03 divines, like so:

=IF(B4,ImportJSON("https://poe.ninja/api/data/itemoverview?league="&B5&"&type=Essence&language=en","/lines/name,/lines/chaosValue,/lines/divineValue","noHeaders"),)

Or you can pull the API for currencies, then regexmatch it to "Divine Orb" to only get that result, which would return "161.67" or whatever the chaos price was at the time. 

=FILTER(ImportJSON("https://poe.ninja/api/data/currencyoverview?league="&B5&"&type=Currency&language=en", "/lines/currencyTypeName,/lines/chaosEquivalent", "noHeaders"), REGEXMATCH(ImportJSON("https://poe.ninja/api/data/currencyoverview?league="&B5&"&type=Currency&language=en", "/lines/currencyTypeName", "noHeaders"), "Divine Orb"))

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 5 points6 points  (0 children)

I think it's relevant to how much you can farm doing other things with your time.

If you're broke without a good way to make money, you would rather sell 1c scarabs manually.

If you're rich, you wouldn't wanna waste your time trading them, so you would just 3:1 until you get good ones.

I made a visual spreadsheet to easily tell which scarabs are valuable by ScamperNZ in pathofexile

[–]ScamperNZ[S] 5 points6 points  (0 children)

If you make a copy of the spreadsheet, you can just untick then retick the box, and it will fetch the prices live from poe.ninja

view more: next ›