u/Tanzanite50

This is the completed sheet before attempting to sort. There are three tables here. Left most is the main one and the one I want to sort (sort by Profit Margin/column K). It references the middle table (column N) and the right most table (column V) for calculating information in the I column which is used to calculate Column K. Middle doesn't reference anything else. Right references middle sometime to calculate the value in column V.

This is the custom sort I am trying to do. (Column A-K by the value of column K from largest to smallest)

This is what happens after that sort is applied. The =fomulas that reference other parts of the sheet break, but only some of them?????

I thought the easiest way to show you what's up is to show you pictures. The captions include the details of what's going on.

I just got acess to the skull cavern but my leather boots and fogotten hat I got from drops instantly broke :( do i really need to get the leather for a full set then upgrade using the smithing table??? that seems very costly

Is there a way to end the area or exclude text from the "compacting" effect of a heading?

For example, I want the area indicated in red in the image below to not be compacted when the Memories and Remembered Lore heading is closed.

https://preview.redd.it/5hj2juymkuhh1.png?width=910&format=png&auto=webp&s=0105fb72ddb110c9b4db93cedd40ea58dc14874c

What is says on the tin. I disabled it and now can't figure out how to get it back.

I keep seeing these all appearing all over the place but everything I try to do just breaks it.

What's everyone's best tips for someone knew to this mod pack? Anyone have something you wish you we're told when you started?

Feel free to post literally any tips or advice regrading Sunlit Society or Sunlit Cobblemon, but particularly earlier game ones. I think a post with a bunch of miscellaneous tips from across the community would be neat! I'm pretty new and am interested in the advice of my fore fathers!

(BTW, anyone have any tips regarding starting various progression trees? Quiet a few don't seem to have much in the questbook, especially regarding getting started. Maybe that's due to my lack of Stardew Valley experience. EG: Fishing, enchanting, armor)

https://preview.redd.it/tv8aecxblffh1.png?width=805&format=png&auto=webp&s=04d9ddeecf2512621382cbf440dc078886bbe450

I'm trying to use Excel to make a class schedule for this upcoming fall semester. Please note, I want to be able to print it out and put it on my wall when I'm done.

The issue I'm having is that some of my classes start/stop times don't neatly fit within the 15min time increments I'm using. For example, roughly in the area highlighted, I have a class from 10:30 to 11:20. I want to know if there is anyway to effect the size of these boxes so the bottom of the last one is slightly higher to illustrate the 11:20 end time without effecting any other boxes or overall scale.

I don't really want to decrease the increments because that would increase the length of the schedule significantly and might prevent it fitting on a piece of paper when I print it.

19F, ~160lbs, 5’9
ADHD, recent EMG/NCS results in p4
Meds: topical Nervive (chronic pain), Vyvanse (recent addition, adhd), ibuprofen as needed (when on period)

Ive been using a topical pain reliever for a couple months called Nervive. It’s Lidocaine HCl 4% and Menthol 1%. It’s the only medication I’ve found so far that helps my issues with chronic pain in my hands and elbows. I’ve probably been applying it more frequently than the directions say on some days :/. This past week it seems like it’s doing little to nothing? Could I have built up resistance? Or maybe my condition has just worsened and it’s not enough anymore? I also just started taking Vyvanse for ADHD around the same time the cream seemed to drop off. Could that be a factor?

Also, one post someone made on a different subreddit I just found while researching this and what other over the counter treatments/meds to try said that lidocaine resistance and ADHD is linked? Specifically, in the only “lasts a few minutes” way. Which uh, yeah the biggest problem I’ve been having with this Nervive cream is that, while it kicks in very quick, it only last, like, 30 minutes at best. (Hence the applying more the the max 3 time per 24 hours the directions say) I kinda assumed that was a downside of it being topical as this is my first experience with topical medication. Is that not normal? Does it suggest I’ve always been kinda resistant?

Also also, any recommendations on over the counter treatments/meds for bilateral chronic pain in hands and elbows? I’m still looking for the cause with my doc but it’s going slow (it been 3 years :/). I know it depends on the source so I’ll put a bit of info below.

I recently had a EMG/NCS because our current theory is it’s neurological (tracks with how Ibuprofen, Tylenol, and Naproxen seem to have no effect) and because of recent reoccurring numbness/rediced sensation in my neck, shoulders, and (a bit in my) pinkys and ring fingers (bilateral again). But the EMG/NCS came back normal besides “electrophysiological evidence of mild left ulnar neuropathy across the elbow”. Which doesn’t seem to track with the whole bilateral thing >:(. My follow up with my doc isn’t until nearly a month so I would appreciate if anyone could help give me an idea if this means the problem is something else of if maybe it’s somehow causing everything and treating this will finally be the thing that fixes/improves this.

Hi! So I recently started a Sunlit Cobblemon world and I'm having a lot of trouble with how many things require earth crystals and really not finding many. It seems maybe the best place to get them is the Skull Cavern but that's lock behind a pretty high coin cost but to increase the money I get from my crops I need earth crystals to make the tools to craft higher profit food/tap more trees. You can see the loop here.

I even used two of the few crystals I had to make a mystery mine because I thought that it had a chance of getting me more crystals but that is apparently only if you feed it rare mutated berries (cobblemon) and I don't have those yet (I did get started on that, I think? I just planted all my cobblemon berry varities in a big patch. I think that's how it works? I did get one mutation out of it so far. Does anyone know how to check if it's rare? and do the cobblemon berries need watered?)

There's apparently a skill perk in the mining tree that makes ores sometime drop earth crystals but it's 4 skill point out from where I am and GOD is my mining exp going slow. Apparently, mining exp levels much faster in the Skull Cavern? But again, CAN'T GET THERE FOR A LONG WHILE >:(

It seems like for Sunlit Cobblemon, I may be able to get it from using a certain pokemon in a ranching station but I need straw to craft that and I can seem to find a way to get that. Recipe book says it's a "plant drop" from grass but I've broken so much grass and it has literately never dropped ANYTHING. Or a knife on some Rice Panicle on a cutting board (more crystals needed yay) but I've never found seeds for that in the wild or for sale so far :(.

If it's at all important, I've settled in a cherry biome, it's currently early summer day 10, I currently have 24 tomatos, a lot of wheat, 24 oats, 24 corn, 24 blueberries, 24 bell peppers, and a bit of sugarcane growing. I have three alpine trees tapped (can u use more than one tap on a single tree?) for pine tar and some bee hives. I technically have the villager for animal husbandry unlocked but I don't think I have the coin to do that yet (also is there a guidebook for that or smth? Or a easy way to start getting armor before u raise cows?)

Thank you, sorry this is so long. TLDR how do i get more earth crystalssssss there are so few in these cavesssss

I've been trying to beat the Knight in Chapter 3 legit for days now and I just can't keep doing this. Physically, I have issue with chronic hand pain that make this stuff harder (there's a reason I very rarely play games that require fast finger movements) and, honestly, I just really want a chance to see the rest of the game but I don't want to have to come back and replay the whole thing later once getting all the crystals inevitably has some sort of importance.

Unless you have some full proof strategy, I really just want to know if downloading Cheat Engine like some other posts have recommended is going to mess up my game at all. I've never done something like this before and I think some games have anti-cheat detection stuff right? Can I still undo/uninstall after I beat the knight?

Please I just wanna enjoy the rest of the game TT^TT

I recently dusted off my old Amazon Fire HD 8 for an international trip. I figured out how to download EPUB files to the kindle app on it and realized how much more I liked it than reading on off my phone browser. (Only downside is the added barrier to commenting :( )

Unfortunately, my Fire decided it had reached the end of its long life and has gone off to tablet heaven. I want to get a new device so I can continue reading like this, particularly while traveling. The one thing that keeps me from getting a standard ereader is that I also want the capability to stream videos (Netflix, prime video, crunchyroll) with decent quality.

Does anyone have device recommendations? Im trying to keep things around a max of about $200.

Also, would it be anymore difficult to download fics on a different device? I only just learned to how to and have been downloading on my phone then sharing to the kindle app to get it on my Fire Tablets kindle app. And does anyone know good ways to sort/organize such? Finally, would the layout of EPUB files change at all depending on the device?

Thank you!!

My very old HD 8 just died on me and I’m trying to figure out which to purchase.

I use it primarily as an ereader and for streaming video, particularly while traveling.

Basically, what I’m trying to figure out is if the better responsiveness and screen quality is worth the sacrifice of the bulkier size of the 10. Is the difference noticeable?

Hey! So I’m in Japan on a trip right now and my old Amazon Fire tablet has crapped out on me. Does anyone know if there’s anywhere in Japan I could get a new one? Specifically, an Amazon Fire HD 10 and preferably a physical/in-store location as I don’t want to rely on shipping arriving before I leave the country. I’m currently in Kyoto but will also be in Neko and near Tokyo.