Gali

Hey folks I could use a bit of help with a special project I've been tasked with. I'm decent with Excel but not good enough to write up a dev code to automate a process. I could macro it, but then I'd have to import it every time the report is run (weekly). I wrote a code that takes data from a large spreadsheet, copies it, and adds it to a new worksheet within the workbook. Here's my problem - I'm now having to remove columns within those copied rows. How would I manage this? I'm thinking I can add this code to the existing which processes the copy + open new sheet+paste. So basically I need to figure out how to copy multiple spread out columns in a worksheet and delete them in one swoop. I apologize if this may be a trivial answer / solution for some of y'all ... been a while since I've had to work this kind of stuff in spreadsheets. Thanks in advance! ~Gali

Hey folks! Been a while since I've needed some guidance on tech, so I came to the best of the best (that's y'all). I'm in the preliminary stages of building a home server and I want to dig ideas for an aesthetic. I'd like a wide variety of different designs, so go ahead and flood this post with anything and everything. Mini ITX or Micro ATX will "probably" be the board of choice, but that's up in the air. Could be 1U or bigger ... no dimensions are off-limits. Let's see what y'all got! Thank you in advance to everyone who contributes. You're all breathtaking. ~ J

Thank you for the resources Andy. I'll find out soon enough how the Organization implements SQL - whether Web-based or otherwise.

Honestly Madknight, it depends what the organization I'm to be a part of uses. Still an unknown for me, so I'm getting versed as fast as possible in a broad range. I've worked with SQL in the past (A long time ago - 7 years I think or something like that), so the basic commands and scripts are pretty easy to refresh. It's the differences in the languages for Database building that I'm concerned with picking up. I know that's really vague, but this early I'm just now picking up from a ball I dropped. Thanks for the resource. Cheers.

Hey script junkies! I'm just getting started with learning some SQL and looking for a way to test what I've learned already. Are there any easy-to-access mediums to accomplish this? I don't do it for my job so I won't need a professional engine or subscription-based software of any kind. Any input would help. Thanks y'all! ~ Gali

Been a while so I had to look up "ONT". Once I came across "NID" I knew what you were talking about. That would save me a bit of cash if they do install that to the house. I'm looking into it - hopefully they do. My house is small enough that a single AP is fine. If I expand then I may need more than one. As for cabling, I'm on cable right now, forgot to add that into the original post. Thanks Donut.

That's a good questions Speedbird. I'm not sure how they run their fiber - whether it's to the house or from the street. I'll look into it. Why wouldn't a modem/router combo be good. Are they not as efficient as separate units because they're doing both tasks?

Alright dudes and dudettes, so here's the deal. One of my next projects is to run Cat6a lines throughout my house. I'm still working with my ISPs provided modem, which will be switched out soon pending my choice in Modem/router combo. I'm throwing in a network switch beyond that to support all the hard lines going to guest rooms and the such. My question is, being that eventually I'll have fiber run in my neighborhood (possibly soon), I need a modem that will push 'dat Gb', so I've been looking at a couple different models of Netgear's Nighthawk series. Without pulling the trigger on any particular one, I wanted to ask you Networking bubbas what might be my best option. Budget is maxing at $300, which I'm guessing based on what I've been researching can nab just about anything. As well, from Linus' recent video on the ASUS XG-U2008 mini-switch, I'm looking into picking one of those up, or something with similar capabilities so I don't have to worry about future expansion. Thanks everyone, ~ Gali

Photo and Video pros! I'm looking into installing outdoor motion security cameras onto my property. I've looked into a couple different brands - namely Nest (Since I already have a Nest home system) and Lorex. If anyone has experience with owning, configuring, or applying this tech I'd appreciate your input. Thanks! ~Gali

Thanks for the info Flamie. I need to check into their progress around Charlotte and the Southern states. The rumor mill was screaming that they halted progress due to extreme cost and I was like ... yea ... sure. Like Google has a problem paying out to have Fiber lines put in. But, I'm always open to the idea of difficulties in business management, so they may have hit a snag with city planning and zoning rights, etc.

Hey Programmers! Initially I had thought the question posed to me was in reference to networking - something I'm way more knowledgeable about than application programming and what not - but after a discussion with that forum, I'm raising it here. I was asked about Coupling, specifically referencing data sharing and basic apps like chat, email, and SharePoints. The inquirer wanted more information about it, and I'd like to understand the basic premise(s), so if anyone is up-to-snuff ... bring it on y'all. Thanks folks! ~ Gali

That's one of the concepts I dug up. I wonder if he's talking about data coupling ... creating an argument to pass data back and forth. I'll go pester the programmers. Check with OP too to get more specifics. Thanks Lurick - much appreciated.

"What's "coup"ing?" It was my assumption that he meant Coupling, It's in reference to data sharing and basic apps (chat, email, SharePoints). I'm with you and never heard of it before. I thumbed through a few of my IT books and couldn't find anything about it. Am I missing something here??

Hey Networking bubbas, Got a question from a friend yesterday in reference to "network coupling". I'm not entirely familiar with the protocol - Only took A+ and Security+ myself - and the only information I could dig up from the net was Dynamic Synchronization. Search result-wise there's a ton of data to sift through from basic electronic coupling to bioengineering and medical-based coupling ... it's a lot. Was hoping someone could point me in a more precise direction. Thanks! ~ Gali

That's quite the tin-foil idea. Entertaining the idea that it IS 'inside', if it ever came out that the company did this as a PR stunt, that would look extremely poor on the company. I doubt they would risk such self-defamation. The tech field has high stakes, and a lot of these companies, including Razer, are interested in the long run. To sabotage their own company for such a short-lived limelight is quite a ridiculous idea. Anything is possible, though, so we'll have to see.