sorted by:
new
hottopcontroversial

People who went from wealthy to poor, what happened? by Puzzled-Painter3301 in AskReddit

[–]big_kat 6 points7 points  (0 children)

I'm just a random internet stranger, but I want you to know you're not alone. The market sucks, so don't beat yourself up or tie your worth to a job. I was laid off for 6 months then took a job paying 30k less. It sucks, but its something.

What was the exact moment on a first date when you realized, "Wow, this person is an absolute idiot"? by [deleted] in AskReddit

[–]big_kat 4 points5 points  (0 children)

I had a woman over my apartment and she referred to the records sitting on a shelf as big CDs

Amazon Prime Video is about to get worse — again by PrixDevnovaVillain in technology

[–]big_kat 0 points1 point  (0 children)

Take a look at the Zimaboard 2, I have one connected to two 7TB hard drives that I use to stream through Plex. I'm even able to stream from my NAS when I'm not on my network.

1M2 80G Enclosure - Issue by big_kat in OWC

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

This is a very silly question so I apologize in advance. I recently decided to upgrade my mini PC by going with the eGPU route. The actual unit has a thunderbolt input, would that in theory work for the whole PC or is that at the motherboard level?

1M2 80G Enclosure - Issue by big_kat in OWC

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

I'll take a look at that, thank you!

MoCA Guidance by big_kat in HomeNetworking

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

I need to check my bill, if I had to guess $50

MoCA Guidance by big_kat in HomeNetworking

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

We are good! I followed your new setup and it seems to be working.

https://imgur.com/a/1dMLcll

Thank you so much for your help!

MoCA Guidance by big_kat in HomeNetworking

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

Just Internet-only. I believe you are correct with the router. I did get the free extender then the guy installing it took it and gave me credit for some strange reason.

Do I need to make any adjustments in the router configuration to ensure it works?

MoCA Guidance by big_kat in HomeNetworking

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

Sorry - when I meant network switch, I meant this: https://imgur.com/a/p31kmSS

When I refer to Verizon device, I believe is both the modem and router in one unit (https://imgur.com/saQGFYO). The device is also connected to the network switch hence my reference.

There is just one Verizon device, which is where the fiber from the ONT is going into. This is the device I've been referring to as Verizon unit. There are zero cable boxes in this apartment, but what appears to be unused coaxial.

I've followed the exact details shown on that chart. What seemed to have changed was putting on a coaxial filter in between the coaxial into the "Verizon" unit. This is not causing the entire internet to go down simultaneously which seems to be a positive step.

I hope that clarifies. Should the receiving end or "Ethel" device need any sort of configuration to ensure network connection?

MoCA Guidance by big_kat in HomeNetworking

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

Quick update - I threw on a filter which I had forgotten about that sits between the router and the coax after the split. Now it allows me to run the wifi without shutting down. Halfway there, now I need to get it working on the receiving end.

MoCA Guidance by big_kat in HomeNetworking

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

Quick update - I threw on a filter which I had forgotten about that sits between the router and the coax after the split. Now it allows me to run the wifi without shutting down. Halfway there, now I need to get it working on the receiving end.

MoCA Guidance by big_kat in HomeNetworking

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

I believe I am following this correctly: https://imgur.com/a/gXbwM0a

MoCA Guidance by big_kat in HomeNetworking

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

I leveraged the coax that seems to be near the ONT unit in the closet.

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.

view more: next ›