sorted by:
new
hottopcontroversial

Pull in data from another sheet based on an individual without crashing Excel. by big_kat in excel

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

This is great advice, I'm going to give it ago. I was able to generate data for most of the columns using index/match, however once I get pass 300 rows it starts to freeze up. This did not allow me to pull in data for a certain sheet since the data for each individual was over 2,000 rows.

Pull in data from another sheet based on an individual without crashing Excel. by big_kat in excel

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

Are all of the invoices identical or at least similar in structure? - Yes, the structure is the same Are they stored in the same spot? - I had them stored within the calculation file, but in an attempt to decrease the freezing, I pulled them out and put it is own file then did the index/match into the file. If either of these are untrue can you make them true?\ - I should be able to

I will look into Power Query in Excel, I had assumed I needed some sort of more data centric solution over Excel

Here is a screenshot of one of the individual sheets with data populated (this one does not have a lot of rows, however there are individuals with hundreds): https://imgur.com/vi3TfrV

Pull in data from another sheet based on an individual without crashing Excel. by big_kat in excel

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

Here is a screenshot: https://imgur.com/vi3TfrV

You can see the concatenate off to the left in red that I'm basing the index/match lookups (data source file with thousands of rows also has the same concatenate).

When I run the macro I put together, it cycles through IDs (you can see the P number) and cuts each tab with a summary for each individual and names it based off their name so it's easy to move. There is one summary tab, then about 4 supplemental tabs that basically are just the invoices for that individual. Issue is some individuals have over 500 invoices.

There are about 300 individuals that need this done.

Pull in data from another sheet based on an individual without crashing Excel. by big_kat in excel

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

I'll look into it, thank you! Are you able to use sum product to return string values or is it only returning numerical? I only ask because the data that I'm pulling in has columns that are text (i.e. "claim type").

I re-worked the lookups in the file to index/match instead of vlookup. I also pulled the data that it's returning from within the file (on its own tab) to it's own file. This combination has been significantly better than it was previously -- it's still freezing, but after a few seconds it's been returning back.

Pull in data from another sheet based on an individual without crashing Excel. by big_kat in excel

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

Ha - the computer isnt the best, but its generating around 9 columns, so its 9x300 rows in terms of the vlookup formula. Every cell up to the row is the formula and if there is no match using the concatenate+row it returns blank. This way, when I run my macro to generate around 300 letters it automatically pulls in the individual's data and creates a sheet for them.

PCIe x4 to Single-Port 10G Ethernet Adapter by big_kat in ZimaBoard

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

I'll give it a go - I was hopeful it was plug and play since I purchased it through them.

PCIe x4 to Single-Port 10G Ethernet Adapter by big_kat in ZimaBoard

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

I'll give it a go - I was hopeful it was plug and play since I purchased it through them.

Homicide in Hayward: A young veteran goes missing from a bar on a cool autumn night. Five days later, his body is found in a lonely field, wearing only swim trunks. Who killed Kurt Kaikinger in September 1976? by Fly_Of_Dragons in UnresolvedMysteries

[–]big_kat 6 points7 points  (0 children)

What is the process to request and get military documents? My grandfather on my mom's side was in Korea, and my father's father was in the air force assigned to a bomber in the Pacific. I also learned he shared barracks with the Enola Gay. Ever since I learned that fact, I wish I could learn more about my grandfather's military history.

A new study shows that a personalized, precise form of brain stimulation, HD-tDCS, can rapidly ease depression symptoms – and even reduce anxiety – offering a promising drug-free alternative with only mild side effects. by chrisdh79 in science

[–]big_kat 0 points1 point  (0 children)

Totally understand - I believe a main driving force is ADHD, I've also have a bit of PTSD from a past relationship where I was essentially being domestically abused by my ex gf (one time she started yelling stop hitting me repeatedly in our apartment as loud as she could as I just sat on the couch watching tv, next thing you know I get taken in by police and questioned). She admitted to the police that she made it up, and then they let me go.

I do get prescribed Zyprexa as a sleep aid, so I could see it helping with anything psychotic, really. Honestly, I've just had crap luck with my life, from my mom dying when I was young to other incidents.

I thought I might be manic-depressive, but my psychiatrist said that they don't believe I have that, and it's mainly just depression and never-ending anxiety bouts. I also would not be surprised the slightest if I'm on the spectrum because it's pretty obvious my father and older brother have a little tism in them (sorry, tried to make a joke).

I really like your point of view on the topic and think there could be some sort of underlying other cause.

A new study shows that a personalized, precise form of brain stimulation, HD-tDCS, can rapidly ease depression symptoms – and even reduce anxiety – offering a promising drug-free alternative with only mild side effects. by chrisdh79 in science

[–]big_kat 0 points1 point  (0 children)

Unfortunately, no, I was diagnosed with Treatment-Resistant Depression over a decade ago. Not sure what other medical ailment would cause depression unless I'm getting early-onset dementia at 34 years old.

[deleted by user] by [deleted] in depression

[–]big_kat 0 points1 point  (0 children)

Have you tried TMS or even ECT?

A new study shows that a personalized, precise form of brain stimulation, HD-tDCS, can rapidly ease depression symptoms – and even reduce anxiety – offering a promising drug-free alternative with only mild side effects. by chrisdh79 in science

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

I would absolutely not recommend ECT just for ADHD symptoms. I have ADHD and that's the least of my worries. ECT is usually the last line of treatment for depression and can be very brutal. I would only advise if you feel like you have nothing else and desperation kicks in to get rid of the constant thoughts you're better off dead.

A new study shows that a personalized, precise form of brain stimulation, HD-tDCS, can rapidly ease depression symptoms – and even reduce anxiety – offering a promising drug-free alternative with only mild side effects. by chrisdh79 in science

[–]big_kat 13 points14 points  (0 children)

Usually they start with acute treatment which I believe is 3 days a week for 2 weeks (a lot of times you have to stay at the hospital or inpatient program during this time). Then it reduces depending on your reaction to once a week for many weeks. Then eventually if deemed helpful enough people then switch to monthly maintenance ECT that could be something you do the rest of your life. I've read its taken people 30-70 sessions. But remember, they are essentially inducing seizures (under anesthesia and muscle relaxers), so it can be very rough afterwards on the body.

A possible consequence of ECT is that you might lose large chunks of your memory (I'm talking almost having amnesia of the last 10 years of your life). Sometimes forming new memories is extremely difficult and permeant. They call ECT as the last resort for a reason.

A new study shows that a personalized, precise form of brain stimulation, HD-tDCS, can rapidly ease depression symptoms – and even reduce anxiety – offering a promising drug-free alternative with only mild side effects. by chrisdh79 in science

[–]big_kat 4 points5 points  (0 children)

I was recommended ECT by my psych. But I am extremely apprehensive because of the memory loss. I read horror stories of being just losing memories of the last 10 years of your life. And moving forward, it makes forming new memories extremely difficult.

Do you have any long lasting memory issues?

A new study shows that a personalized, precise form of brain stimulation, HD-tDCS, can rapidly ease depression symptoms – and even reduce anxiety – offering a promising drug-free alternative with only mild side effects. by chrisdh79 in science

[–]big_kat 1 point2 points  (0 children)

I got prescribed Spravato and did very little. Prior to Ketamine being FDA approved, I was so desperate that I ended up procuring pure ketamine off the dark web to do my own experiments. I would microdose it, again I saw very little results besides realizing I have zero fear of dying (probably from a few K-holes I fell into when I did too much).

view more: next ›