|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
any idea how to add a master dashboard or control panel that is able to tell my formu
any idea how to add a master dashboard or control panel that is able to tell my formulas to only look at at certain date ranges? Thanks |
#2
|
|||
|
|||
Hoo boy...you know how when you start cleaning out the closet and you end up cleaning the garage, the bathroom, and even the refrigerator? That kind of happened here.
I don't know if you'll be able to use any of this, but here it is. I am kind of a stickler for proper design owing to my days doing database development. Setting up a workbook properly can help immensely down the line. Some notes, pointers, etc... * Keep tab names simple. Adding dashes or even spaces can make the equations that refer to the tabs ugly and thus less understandable. Thus I renamed your last two tabs Metrics and Performance without any loss of context in my opinion. * Each large table of data should have its own sheet and the sheet should only have that table. Thus I moved the stats you had from Performance to Dashboard. * Use the Format As Table button on your tables, especially any that have data that will be used in equations elsewhere. Also, use the [Formula]Name Manager to rename the table logically. I did so with the data on the Performance tab and renamed the table Performance. * Keep the table field names (the column headers) simple. Like the Tabs, keep any superfluous characters to a minimum. By doing so, an equation might look for instance like =SUM(Performance[Barclay]) rather than =SUM('Performance-Data'!G:G) with obvious advantages in creating, editing, and debugging the equations. It is even more obvious as equations become more complex. Having done that, I modified all the equations I could on your Tear tab. For instance, rather than tediously adding individual cells, your calculation for 2013 Barclay becomes.... =SUMPRODUCT((Performance[Month]>=J16)*(Performance[Month]<J16+365)*(Performance[Barclay])) Much more could be done but I'm afraid I've done too much for you to digest already. But if you think this is valuable and you would like further assistance in making this a truly robust sheet, I will help you as much as I can. However, we should probably take it offline and work by email. |
#3
|
|||
|
|||
please email me
Last edited by akatz85; 03-27-2014 at 02:01 PM. |
#4
|
|||
|
|||
gebobs i am trying to follow all that you have done, but it seems the leverage and date dont work in the dashboard. when you email me i will send you an updated version. thanks
|
#5
|
|||
|
|||
I didn't see where either of those things were used.
Anyhoo...I sent you a PM with my email. |
#6
|
|||
|
|||
i didnt get your email, can you try again?
|
#7
|
|||
|
|||
Check your PRIVATE MESSAGES on this forum. Top right.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Powerpoint Dashboard | Villanueva | PowerPoint | 0 | 08-26-2013 10:16 PM |
Quite advanced animation idea | tribulations | PowerPoint | 2 | 04-18-2013 08:35 AM |
New Idea for Delivery Receipt | BrazzellMarketing | Outlook | 0 | 01-13-2011 03:44 PM |
get rid of the right ad panel | sandsoppa | Word | 2 | 10-07-2010 05:53 PM |
Review Panel keeps poping up when i open a doc. | techexpressinc | Word | 1 | 09-29-2009 11:36 AM |