Subject: RE: NFC - test and toolbox
From: "Parrish, Daniel" <[email-masked]>
To: "Johnson, Matt" <[email-masked]>
Date: Wed, 27 Apr 2016 12:54:46 -0700

Thank you!! Looks great. I’ll let you know if anything comes up as an issue, but this is a massive help.

From: Johnson, Matt
Sent: Wednesday, April 27, 2016 3:31 PM
To: Parrish, Daniel
Subject: RE: NFC - test and toolbox

Hey Daniel,
  We should be good!

To review, here's how it works:
Every night, it will:

1)      Grab the data from the MASTER sheet

2)      Grab the combines from the Combine sheet

3)      Calculate 2016 contribution totals on NGP

4)      Load the data to the nfc_fi_nfc-load tab

5)      Copy the data over the MASTER sheet for most columns (but not the convention column).
It will do this between 1-2am, but it takes about 5 minutes.

It may sound weird, but since when we load the data from NGP, it overwrites formulas, it's really annoying. If you need another formula like this, let me know!

All the committee tabs pull from the master sheet, so we should be good.

Anyways, hope this helps!

-Matt

From: Parrish, Daniel
Sent: Wednesday, April 27, 2016 10:11 AM
To: Johnson, Matt
Subject: RE: NFC - test and toolbox

Hi Matt, I can’t get a room at 11:30, but Jordan’s out today – do you mind just coming up here and we can use his office?
Thanks!

From: Johnson, Matt
Sent: Wednesday, April 27, 2016 8:30 AM
To: Parrish, Daniel
Subject: Re: NFC - test and toolbox

Appreciated!
On Apr 27, 2016 8:23 AM, "Parrish, Daniel" <[email-masked]<mailto:[email-masked]>> wrote:
No problem! 11:30 sounds good. See you then!

On Apr 27, 2016, at 8:22 AM, Johnson, Matt <[email-masked]<mailto:[email-masked]>> wrote:

Hey, my doctors appointment is running late. I might make 10:30, but I'm not sure.  Could we do 11:30?
On Apr 26, 2016 5:50 PM, "Johnson, Matt" <[email-masked]<mailto:[email-masked]>> wrote:

Let's do it!

-Matt

From: Parrish, Daniel
Sent: Tuesday, April 26, 2016 5:25 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC - test and toolbox

How is 10:30 in the bridge?

From: Johnson, Matt
Sent: Tuesday, April 26, 2016 5:21 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC - test and toolbox

Yup! I'm free any time except 12-12:30!

From: Parrish, Daniel
Sent: Tuesday, April 26, 2016 5:03 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC - test and toolbox

Looks great, thank you! I’ve been out the past few days, but I’ll be back tomorrow. Can we talk through the google sheet then?

From: Johnson, Matt
Sent: Tuesday, April 26, 2016 2:32 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC - test and toolbox

Hey Tema,

  The Joint Fundraising report should be better. Shomik was able to fix it.

The google sheet: I have an idea about, but not sure how it will all work together.

-Matt

From: Johnson, Matt
Sent: Tuesday, April 26, 2016 10:14 AM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC - test and toolbox

Hey,

  I'm alive! I promise! I've been in and out for the last three weeks (three straight weekends of travel), but I'm back and not traveling soon.

I had Shomik look into the report; I should have an answer soon.

As for the google sheet, I'll take a look. That sounds really frustrating. I'm not sure the best way for a fix, but I'll figure something out.

I'll take a look today, and have an update later today.

-Matt

From: Parrish, Daniel
Sent: Thursday, April 21, 2016 11:26 AM
To: Johnson, Matt
Subject: NFC - test and toolbox

Hi Matt!

I have two quick questions for you. The NFC sheet stopped overwriting the Package column for a few days, which was great, but now it’s back to overwriting it. Is it possible to leave it alone so we don’t have to update the formulas each day?

And I was looking at the latest transfer in toolbox, but it only shows one person’s contribution from HVF instead of the $2.3 million on April 1st and $305,000 on April 11th. Will that update soon? I’m hoping to get things set for regular reports for the department.

Thanks!

–––––––––––––

Daniel Parrish

Democratic National Committee

Finance | Director of Data & Strategic Initiatives

Phone: (202) 479-5141 | Mobile: (717) 283-7521

430 South Capitol Street, SE | Washington, DC 20003