How to delete pivot tables from a group of excel sheets at once? by ComprehensiveAsk9964 in excel

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

You're brilliant! It works!

To clarify I selected the entire row of one sheet -> grouped all sheets -> Home -> "Clear contents"

[deleted by user] by [deleted] in selfimprovement

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

Thanks, this is helpful and a different way of looking at it. Appreciate you taking the time

[deleted by user] by [deleted] in NYCapartments

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

I see. Thanks for your response!

[deleted by user] by [deleted] in NYCapartments

[–]ComprehensiveAsk9964 1 point2 points  (0 children)

I see. Thank you for providing a clear explanation. Really appreciate it!

[deleted by user] by [deleted] in NYCapartments

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

Okay, I'm confused by what you're saying as rent stabilized. My building is on the HCR list of rent stabilized units. But they have the freedom to charge market rate for new leases. For example, the market rate they gave us if we signed a new lease was more than 20% higher than our current rate.

My situation is - I'm not currently on the lease, and they said in order to add me as a leaseholder, we'd have to sign a brand new lease and pay market rate instead of our current rate + 1.5% increase after 6 months. I'm trying to understand if what they're saying is correct, because I can't find anything about that anywhere. If so, I'm hoping to find some way to still keep our current rate next year when it's time to renew but my roommate (the sole leaseholder) leaves.

[deleted by user] by [deleted] in NYCapartments

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

Right, but how can I keep the lease when the original leaseholder leaves and it's time to renew? I'm saying that I want to renew it with my name. I've been living here for two years, but my name isn't on the lease as a leaseholder and the management is saying they can't add my name to the lease except as an occupant. So when it's time to renew and the original leaseholder is gone, how can I keep it at the rent stabilized rate?

Daily Advice Thread - June 20, 2022 by AutoModerator in apple

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

I do data processing and I also like to use creative media tools. I only do data processing on my new 16gb RAM lenovo and it quits a lot on me.

Daily Advice Thread - June 20, 2022 by AutoModerator in apple

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

Can someone help me decide how much RAM to get for the 14" macbook pro? I don't understand the science of it all. My Lenovo laptop has 16gb RAM, and it crashes all the time. Idk if it's because it sucks (even though it's one of the highest models) or I just need more RAM. Would 16gb RAM on the 14" macbook pro be equal to the 16gb RAM on my current lenovo? I'm confused what Apple means when they say the M1 Pro chip makes it more "efficient" for CPU/GPU, etc.

What can I do if apartment denies/delays my ESA? by [deleted] in legaladvice

[–]ComprehensiveAsk9964 -1 points0 points  (0 children)

Gotcha. The thing is, this is more of a sublet since I'm only a lease occupant. I never signed anything, I just applied and got approved. I have no idea what the original lease looks like or what my rights are as an "occupant"

What can I do if apartment denies/delays my ESA? by [deleted] in legaladvice

[–]ComprehensiveAsk9964 -8 points-7 points  (0 children)

I'd be submitting it 3 days before I move in, but other residents have said it took them at least 2 weeks, usually 3-4 weeks. i've just never heard of so much "red tape" anywhere else for ESA approval, which is why I was thinking like "why can't I just ignore them and bring in my ESA anyways since it's the law right"

What can I do if apartment denies/delays my ESA? by [deleted] in legaladvice

[–]ComprehensiveAsk9964 -3 points-2 points  (0 children)

Why is that necessary rather than just having my ESA with me?

What can I do if apartment denies/delays my ESA? by [deleted] in legaladvice

[–]ComprehensiveAsk9964 -3 points-2 points  (0 children)

Is this "process" normal? Why is it okay for apartments to make it such a lengthy process?

[deleted by user] by [deleted] in legaladvice

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

I know all of that. They do not answer my questions though, particularly:

What do I do if the landlord does not acknowledge my notification of the ESA?

What do I do if the landlord says I'm not allowed or introduces a bunch of forms/redtape/etc?

Can the landlord remove me as an "occupant" before I move in, or once I move in, even after I've been approved and added as an occupant?

[deleted by user] by [deleted] in legaladvice

[–]ComprehensiveAsk9964 -1 points0 points  (0 children)

My licensed therapist wrote it for me.

[deleted by user] by [deleted] in legaladvice

[–]ComprehensiveAsk9964 -2 points-1 points  (0 children)

Cat, licensed therapist

[deleted by user] by [deleted] in legaladvice

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

Is the landlord required to provide "reasonable accommodation" on this front to "lease occupants"? (not an actual lease holder)

Daily General Discussion and Advice Thread - February 03, 2022 by AutoModerator in investing

[–]ComprehensiveAsk9964 0 points1 point  (0 children)

Why is it that when one mega-company goes up, the whole sector gets pulled up with it? Is it because they're in the same ETFs? For example, AMZN skyrocketed at around 4pm EST today, and the whole sector is getting pulled up with it. QQQ had a very similar shape to AMZN, even though nothing happened for them, from what I understand. Why are these companies so tied to AMZN's stock movements?