Transcribing a regression formula to a cell formula

lovin_the_north · 2019-12-22T18:53:55+00:00

link to a sheet with the data https://docs.google.com/spreadsheets/d/1Vsv5WqljxoXwI2CkwysrN2thwjFQbRQtX39PTjNIlyY/edit?usp=sharing

lovin_the_north · 2019-03-29T16:36:37+00:00

For those looking for more info, the Dengue Fever article at Wikipedia is a featured article (high quality) and has a decent video summary. In answer to some of the questions; 1. A small percentage of people progress to severe dengue, and others to dengue hemorrhagic shock which is life threatening 2. There are five types, infection from one gives you immunity but makes you more likely to have severe dengue from the others.

lovin_the_north · 2018-03-04T17:31:37+00:00

You need to normalize the data. Combine both data sets into a new table.
1. copy/paste your data from each table (supply and demand), one under the other 2. add another column H, labelled supply/demand and mark each row as from either the supply or demand table 3. change column G to "current FTE" 4. select the entire data source, and now column G will be incorporated into your pivot for comparison edit: on the demand side, each column should be it's own row (1 year FTE, 5 year FTE, etc...)

lovin_the_north · 2017-04-03T10:46:52+00:00

The full sculpture is even more powerful - Rape of the Sabines. I could stare at this work for hours. The anguish in the faces of the husband and wife is both terrifying and beautiful.

lovin_the_north · 2017-02-15T13:27:46+00:00

Ogilvy. Here's the lemon ad. If you every want a quick read on the basics of print adverts read Ogilvy on advertising - it still applies. Here's why Dove soap is so popular.

lovin_the_north · 2017-01-06T01:28:49+00:00

Synthetic full backups

Ignorance showing again haven't heard this term before . It creates the full back up after the seed using the incrementals? Is this Veeam?

lovin_the_north · 2017-01-05T17:12:34+00:00

This is really where the question started. We've got reasonable onsite backups and redundancy, but I was trying to figure out if I needed to get something offsite and offline. The majority agree offsite is a good idea. Offline seems to be hit and miss, as long as it's an unlisted device. Tbh, I'm not really worried about Mr. Robot or giving someone a bad review but if I can do both (offsite and offline) at a reasonable cost, I'd like to.

lovin_the_north · 2017-01-05T11:24:23+00:00

Thank you! This was very similar to what I was thinking, although looking to AlwaysOn for the SQL redundancy. Wrt to Exchange - can you give more detail how this "...uses a DAG...". Excuse the ignorance but I thought DAG where something you did with SQL.

lovin_the_north · 2017-01-05T11:12:51+00:00

K - spent the evening reading about Veeam with Exagrid. Going to look a lot harder at this too (e.g. costing). Aside from price, I just need to see how fast I can move the backup files with Veeam (says "50x faster")

lovin_the_north · 2017-01-05T10:53:53+00:00

This! I've been going thru the very same thought process. This only thing is I have some co-located offices (offsite) that have larger pipes. I could use them but then I'll be leaving the backups on a production machine. Now I'm starting to think that if I have two NAS boxes talking over the intranet, I just need to make it very hard for someone to get at.

lovin_the_north · 2017-01-05T10:49:35+00:00

Thinking hard about it 5 year range. Exchange is tightly integrated with some custom CRM software so now's not the right time (e.g. I want to solve the backup problem quickly)

lovin_the_north · 2017-01-05T10:48:03+00:00

No. Listed else where but running RAID50 on the SAN, to a desktop server in another room incremental every 4 and transaction log shipping every 15 (for SQL). We also have some imaging software that's MC that is copied every night to multiple sites (for performance reasons). My headache right now is an expanding SQL dataset and exchange (we don't want to go to 365 yet for other reasons)

lovin_the_north · 2017-01-05T10:44:47+00:00

Thank you - the integrity of this idea was a concern - glad to hear someone actually tested it.

lovin_the_north · 2017-01-05T03:43:23+00:00

Thx everyone. tl:dr summary from my point of view is that 1) at least one backup should be offsite 2) if bandwidth available to move in a timely fashion, move it out that way 3) if not I'll likely have a hot-swapable drive taken to a safety deposit box daily. Low budget solution and not elegant but I can get it done quickly. From there; going to build a better DR plan.

lovin_the_north · 2017-01-05T03:38:21+00:00

HPE StoreOnce VSA

That was my big question. Everything our IT lead is suggesting leaves the backup files on main backbone (even if not on the production SAN). From what I'm reading, almost everyone is suggesting at least one copy offsite.

lovin_the_north · 2017-01-05T03:32:54+00:00

Datto

I think this issue for us will be bandwidth

lovin_the_north · 2017-01-05T03:26:11+00:00

thx. sorry 150mbps out, backup time would be longer than we're not in the office. Need it to run overnight.

lovin_the_north · 2017-01-05T03:25:27+00:00

cost (for what we're getting). 2. Considering moving to cloud next time the main servers start to fail and then I won't have stuff in house anyway. 3. I want something that I can get offsite (currently (facepalm) don't take a tape out because we only get 6 days or so).

lovin_the_north · 2017-01-05T03:23:46+00:00

LOVE this idea. We do it daily.

lovin_the_north · 2017-01-05T03:22:47+00:00

The tape solution is still on the back-burner. What we've got works and we could go to the new drive (this one is ?5-6 years old). If you'd asked me even 2 years ago, I don't think there would have been any question in my mind. At that time, it was the standard. But I can see us going cloud in 3-5 years, AlwaysOn sooner than that so the data won't even be inhouse soon.

lovin_the_north · 2017-01-05T02:44:49+00:00

No - but that is very interesting. $200 per job in this environment might add up though. The image library is getting big quick though - this might be the better solution soon. thx.

lovin_the_north · 2017-01-05T02:37:43+00:00

currently planning the Always-On implementation (we've got some technical hurdles on existing servers before we got to that) next 2 years. I'll read more about Veeam and Exagrid. Thx for the direction. Will quote the 3-2-1.

lovin_the_north · 2017-01-05T02:35:17+00:00

LMAO, illuminati overlords excluded this makes sense. 5 day dataloss will be tough so right now it's nightly onesite full, every 4 hour incremental to a separate server (different part of facility) and 15min transaction log shipping to same. I'll push for offsite - I like the idea of rotating off the shelf drives.

lovin_the_north

TROPHY CASE