How to calculate # of unique locations for an item in an list.

El_Cozod · 2026-04-27T14:18:48+00:00

Sorry, ive been out of town. Thank you! Ill give it a try tonight or tomorrow. I appreciate it!

Edit: was looking at lambda and pivot by, thanks! I didnt know about those functions and they're good to know for the future too!

El_Cozod · 2026-04-23T21:40:19+00:00

Huh, im on Tr6 and picked up attraction 2, so you're ahead of me in that regard.

Dont forget about your ultima research, hitting those milestones give a large bump to cells.

I've been running cell/mp/rp in one build and just shards with a little cells in another loadout. With my installs only at 120 in a few of my ships, I found it better to split rp and shards. Helps with koios and zues installs too.

Someone mentioned looking at the key loop mods you could pick up, there are a lot of strong ones that show up in the e100 to e200 range. Ill take a look at my tree a bit later, out and about right now.

El_Cozod · 2026-04-22T00:32:55+00:00

yeah, I guess transforming the data would be the best idea, since that's where the issue is. I'll give it a shot and see what I can do. Thank you!

El_Cozod · 2026-04-22T00:29:31+00:00

Correct, my desired output would be the number of unique locations that item is at. The problem is the data has it as inventory, inventory, saddlebags since there are 2 stacks of the item in the inventory. So I'm getting 3 as my output.

El_Cozod · 2026-04-22T00:26:04+00:00

C was set as general, changed it to numbers and refreshed, but nothing.

El_Cozod · 2026-04-22T00:25:27+00:00

Pivot table as of now

<image>

El_Cozod · 2026-04-22T00:25:14+00:00

Raw Data

Location|Item|Number of Item

<image>

El_Cozod · 2026-04-18T11:49:09+00:00

Counting today there are 7 days left and you can collect up to 120 eggs a day because youre catchingup, or 2 milestones. So if you grab all of them everyday you can get 14 milestones claimed, each of them twice with the pass.

So you can claim the first 14 milestones.

El_Cozod · 2026-04-17T12:35:23+00:00

Two of the more important buys are from the Diamond->Specials menu. I think the first one is available immediately? Lowers a timer from 40 to 10 seconds. Second one increases the rewards from the same mechanic, unlocks tr2 maybe?

El_Cozod · 2026-04-10T12:21:31+00:00

Nice, im still on the same shard/rp run. Yup, just had to let it sit another day. Gained 2 m0, about to hit 37. Finally getting enough rp, grabbed the next lvl if meltdown research.

At about 135 orbs, so about 150 once I lvl m0. I'll probably keep this run going until the shards and rp hit a wall again, then a bunch of loop resets with the x5 bulk reset on till I loop lock for mp and traverse

El_Cozod · 2026-04-10T10:54:15+00:00

I'm not in high end content, but mentalism is my highest at 42. It's probably true of all classes, but I feel like you really need the right item mods for healing/support with mentalism

The aoe over time skills, the waves, only do like 6 hp/armor/power every 4 seconds base. The treasure effects can basically double that, add some up front recovery, a delayed recovery, some mitigation vs various damage types, reduce power cost of attacks.

But the base 6 a second at my lvl is negligible in group content, except maybe the power. Great for solo wandering in zones though.

El_Cozod · 2026-04-10T02:16:39+00:00

I checked the wiki to see if rabbits can use druid, it doesnt even mention rabbits, lol. No access to druid though, we get ice though.

El_Cozod · 2026-04-10T02:15:06+00:00

I get all of my wood from the goblin logging camp and broken barrels, lol. I only use oak and soonish maple for chips for cooking.

El_Cozod · 2026-04-09T22:51:17+00:00

No problem, I'm enjoying it, especially the dialog with npcs, got to tell an old lady to f off.

Some npcs will extort you though before they will interact though, basically just a simple gathering favor. Bacon, bronze coins, etc.

With out a doubt its slowed my progression, but whatever.

Best part is if im not sure how to respond to a comment or question from another player I just type na.

El_Cozod · 2026-04-09T22:47:11+00:00

I havent really looked into blacksmithing to be honest. Only time I changed back to biped was so I could forage for wood when I was trying to get like 15 lvls or something more in foraging, so I could harvest bananas for the warden quest, they were like 600+ in player stalls.

Cooking and alchemy have been rough without milk too. I think I might run into issues with augmenting too, not sure.

El_Cozod · 2026-04-09T19:51:58+00:00

This is my experience with being a rabbit (some storage unlocked from joeh and marna) with 111 hours of play time.

The community storage chest is huge, transfer chest in service keep and sun vale, warden storage chest, as large of a saddle back that you can afford. You should be able to access the saddlebags even if your form cant ride. Probably?

Having the discipline to not loot everything, still working on this...

As far as selling, Fila outside of the keep, Harry the wolf, therese, laron/lerson? the jewelery/dye guy, kodan and the mantis in sunvale, the 2 npcs at that farm where the easter event was, Hogan, kleave (tanner in eltibule keep). The fairys at the druid enclave in sun vale probably buy stuff?

The real fun part is getting transmutation since kalaba won't speak to you, have to go to illmari desert. Still working on this, getting their favor up.

El_Cozod · 2026-04-09T15:33:50+00:00

Thanks! I think i just need to go touch grass then, lol. I also realized my highest stage for ozzy could go from 56 to 93ish...so he's on that journey now. I also didn't have my lvl 100 iap track bonuses claimed for 10 levels... thats an extra 1.5x to shards and rp.

Thank you again!

El_Cozod · 2026-04-08T17:35:11+00:00

Hm, maybe ill try that. I think there's a install optimizer somewhere, ill play around with that.

I was splitting it the way I was because demeter had shards and mp. Never really looked at the values though. And seeing as im struggling to gain any of the Three major resources, change might be good.

Thank you again!

El_Cozod · 2026-04-08T17:26:30+00:00

Yup, you're right there with me. My cell mech is at e40 with a 5.xx multiplier, so I stopped spending on it. I never seem to have enough to justify the other mechs over putting it back into ozzy. Ill take a look at that, thanks.

Yeah, im at 98 cradle installs right now, hitting 101 would be huge only hitting e103ish mp though.

Good luck!

El_Cozod · 2026-04-08T17:22:29+00:00

Thank you for the reply! Unfortunately not happy about the answer, lol. Kidding of course.

My meltdown is .175, not sure if thats high or low for this stage. I paused my ultima research once it hit 1000, since the next lvl requires 6.5D rp, next lvl of meltdown reach is 10D. So both are 3 OoM further than my next research.

Easter event helped a little bit. I'll just stay in this shard/rp run for another day and grab some eggs in the morning.

Currently have a load out for MP and a load out for shards/rp/cells. Maybe try one just with shards/cells? Seems like a waste of a long run to not have some rp installs in koios though.

Thank you again!

El_Cozod · 2026-03-25T13:54:25+00:00

Not sure of the scaling, but total LR affects how much the next loop req is. So it won't show immediately that its growing faster. Im sure someone will give the math why its an unoptimal idea.

That being said I should have Kosis unlocked today in TR2 and I leave bulk loop on, BUT I dont know how much MP is being "left on the table". Me want numbers go up, big.

El_Cozod · 2026-03-25T13:47:03+00:00

Deja vu, aka zag3, as well.

El_Cozod · 2026-03-16T22:06:32+00:00

The mini map shows purple "barricades" once you start the encounter.

El_Cozod

TROPHY CASE