Excel Sheet Setup (Advance)

**JeffreyWeir** · 2013-07-04, 02:41 AM

valid point. Your call. There would only be there additional columns, and maybe users would only fill them in if dates differed from forecast? The beauty of having it in seperate columns is that it makes it easier to filter on say the color red and/or pivot the data so you can only look at things that are say past forecast date, while still being able to see what the original date actually was.

Whereas if they are on seperate rows, as soon as you filter on 'past forecast date' then you filter out what the actual forecast date was in the first place. Might not be an issue to you.

Thoughts?

**han77729** · 2013-07-04, 02:43 AM

Makes sense. This will become useful when filtering and mining for specific data. Let's proceed with the additional columns and make them separate.

Thank you,

Han

Originally Posted by JeffreyWeir

valid point. Your call. There would only be there additional columns, and maybe users would only fill them in if dates differed from forecast? The beauty of having it in seperate columns is that it makes it easier to filter on say the color red and/or pivot the data so you can only look at things that are say past forecast date, while still being able to see what the original date actually was.

Whereas if they are on seperate rows, as soon as you filter on 'past forecast date' then you filter out what the actual forecast date was in the first place. Might not be an issue to you.

Thoughts?

**JeffreyWeir** · 2013-07-04, 02:59 AM

You could always put the extra 'Actuals' columns side by side, and group them so that a user can expand/contract them if they are/are not relevant.

**JeffreyWeir** · 2013-07-04, 03:10 AM

Is it only the dates that will change, or financial figure too? i.e. you just need to track date slippage, not financial slippage?

**han77729** · 2013-07-04, 03:26 AM

Once the entry has been entered (entire row) both financial and dates can change.

Originally Posted by JeffreyWeir

Is it only the dates that will change, or financial figure too? i.e. you just need to track date slippage, not financial slippage?

**JeffreyWeir** · 2013-07-04, 03:38 AM

Ahhh. Two rows it is, then.

**han77729** · 2013-07-09, 05:02 PM

Solid plan. Please let me know how I can be of support.

Thanks Jeff,

Han

Originally Posted by JeffreyWeir

Ahhh. Two rows it is, then.

**JeffreyWeir** · 2013-07-09, 10:51 PM

Sorry Han, this slipped off my radar. Thanks for your prompt. Will take a look today.

**JeffreyWeir** · 2013-07-10, 03:48 AM

Hi again, Han. I take it that when the data is amalgamated, you still want to be able to see what tab each bit of data was pulled from? Also, to match up the forecast and actuals for each item, you really need a unique ID that they both share.

I'll put something together that addresses both of these, and also fix the tabs so that they are the same size and don't move around when you make changes to the worksheet.