Tracking sheet.. I see.. I will have a look and try my best to give one dummy dashboard by tomorrow.
On Wed, Jul 20, 2011 at 1:16 PM, Adam Hamilton <adamchamil...@gmail.com>wrote: > However, I get your point, the data is not raw if I am adding a sum of > spend based on resource allocation and budgetary spend. > > The 'time tracking' sheet is supposed to be the 'raw' data, but since > it has been altered, I guess I have none.. > > On Wed, Jul 20, 2011 at 12:44 AM, Adam Hamilton <adamchamil...@gmail.com> > wrote: > > The 'time tracking' sheet is where all of the data are pulled to > > populate the erroneous amount of fluff that you see in my xls > > > > On Wed, Jul 20, 2011 at 12:35 AM, Anish Shrivastava <anish....@gmail.com> > wrote: > >> Hi Adam, > >> > >> Great thing. > >> I would request you again to send me only those sheets which you think > are > >> raw data. > >> > >> Your workbook contains many sheets (includin pivot sheets) which makes > me > >> unsure that which sheet should I consider as a raw data sheet for > dashboard. > >> > >> As you said, your management wants to select a resourse from a list of > >> resources in order to see their expenses and other details then I assume > >> there must be a raw data sheet in database format (simply rows and > columns). > >> > >> to protect the confidentiality, you can change the values on your > originial > >> sheet. Replace it with some example values. Change the names, mail > address > >> and amount. > >> thanks, > >> Anish > >> On Wed, Jul 20, 2011 at 12:49 PM, Adam Hamilton < > adamchamil...@gmail.com> > >> wrote: > >>> > >>> Thanks so much. A dummy dashboard would be great. Once I can grasp > >>> the concept, I know it shouldn't be any problem expanding on it at a > >>> later time. My idea is for executive mgmt to be able to select a > >>> resource and see everything pertaining to thier spend and billable > >>> rates…….. > >>> > >>> To answer your question, I was using charts to show my directors my > >>> bucket spend. I will be able to omit everything if I can find a way > >>> to extract everything from the raw data, instead of hundreds of > >>> vlookups in hidden tabls…..all of the other bucket breakdowns once I > >>> can get this to make sense from the raw data. > >>> > >>> Attached is a monthly spend ticket as submitted per executive review. > >>> > >>> On Tue, Jul 19, 2011 at 11:44 PM, Anish Shrivastava < > anish....@gmail.com> > >>> wrote: > >>> > Hi Adam, > >>> > > >>> > Looking at your workbook, it seems that it's a complete dashboard > >>> > project to > >>> > be completed and in these cases Sample data wouldn't do the perfect > job > >>> > (However we can create one dummy dashboard). > >>> > > >>> > I understand that you want it to be interactive to the user creating > >>> > homepage and navigation with charts and other analysis. > >>> > > >>> > I have one question for you, why are you using images(charts) on the > >>> > sheet. > >>> > where as you can do it with excel charts itself. > >>> > > >>> > Your project is a big one and if we have to do it, it might take some > >>> > time > >>> > to go through all the sheets and understand the data structure to > create > >>> > an > >>> > interactive data base. > >>> > > >>> > You will have to have patience for it. I understand that because of > data > >>> > confidentiality you cant share the complete data but in order to > >>> > complete > >>> > this dashboard or for giving a dashboard skeleton, we would expect > one > >>> > cleansed workbook only with the necessary sheets. > >>> > > >>> > Hope you understood what I am trying to say. > >>> > > >>> > Thanks, > >>> > Anish > >>> > > >>> > > >>> > On Wed, Jul 20, 2011 at 12:04 PM, Adam Hamilton > >>> > <adamchamil...@gmail.com> > >>> > wrote: > >>> >> > >>> >> Hi, Guys, > >>> >> > >>> >> Thanks. You're recieving this error b/c I ommitted the resources > >>> >> names for confidentiality. I'm looking for a macro, or complex > >>> >> formulae that will allow the dashboard to be both interactive to the > >>> >> user, as well as auto populate data, charts, stats, etc. > >>> >> > >>> >> On Tue, Jul 19, 2011 at 6:10 AM, Adam Hamilton > >>> >> <adamchamil...@gmail.com> > >>> >> wrote: > >>> >> > Hi, guys, > >>> >> > > >>> >> > So, I’ve created this complex budget workbook for the department I > >>> >> > manage. Everything is automated, however, now that I want to > create > >>> >> > a > >>> >> > dashboard with the data, all of my syntax are failing!!! > >>> >> > > >>> >> > I’ve spent endless hours on this, can someone PLEASE guide me in > the > >>> >> > right direction? As you can see from the sample db, the data I > want > >>> >> > to capture are all available in the Raw Data file. But after > weeks > >>> >> > of > >>> >> > trying, I haven’t a clue, and am hard coding everything. > >>> >> > > >>> >> > PLEASE HELP > >>> >> > > >>> >> > > >>> >> > -- > >>> >> > > >>> >> > > >>> >> > > ---------------------------------------------------------------------------------- > >>> >> > Some important links for excel users: > >>> >> > 1. Follow us on TWITTER for tips tricks and links : > >>> >> > http://twitter.com/exceldailytip > >>> >> > 2. Join our LinkedIN group @ > >>> >> > http://www.linkedin.com/groups?gid=1871310 > >>> >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com > >>> >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >>> >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >>> >> > > >>> >> > To post to this group, send email to > excel-macros@googlegroups.com > >>> >> > > >>> >> > <><><><><><><><><><><><><><><><><><><><><><> > >>> >> > Like our page on facebook , Just follow below link > >>> >> > http://www.facebook.com/discussexcel > >>> >> > > >>> >> > >>> >> -- > >>> >> > >>> >> > >>> >> > ---------------------------------------------------------------------------------- > >>> >> Some important links for excel users: > >>> >> 1. Follow us on TWITTER for tips tricks and links : > >>> >> http://twitter.com/exceldailytip > >>> >> 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > >>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >>> >> > >>> >> To post to this group, send email to excel-macros@googlegroups.com > >>> >> > >>> >> <><><><><><><><><><><><><><><><><><><><><><> > >>> >> Like our page on facebook , Just follow below link > >>> >> http://www.facebook.com/discussexcel > >>> > > >>> > -- > >>> > > >>> > > ---------------------------------------------------------------------------------- > >>> > Some important links for excel users: > >>> > 1. Follow us on TWITTER for tips tricks and links : > >>> > http://twitter.com/exceldailytip > >>> > 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > >>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com > >>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >>> > > >>> > To post to this group, send email to excel-macros@googlegroups.com > >>> > > >>> > <><><><><><><><><><><><><><><><><><><><><><> > >>> > Like our page on facebook , Just follow below link > >>> > http://www.facebook.com/discussexcel > >>> > > >>> > >>> -- > >>> > >>> > ---------------------------------------------------------------------------------- > >>> Some important links for excel users: > >>> 1. Follow us on TWITTER for tips tricks and links : > >>> http://twitter.com/exceldailytip > >>> 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >>> > >>> To post to this group, send email to excel-macros@googlegroups.com > >>> > >>> <><><><><><><><><><><><><><><><><><><><><><> > >>> Like our page on facebook , Just follow below link > >>> http://www.facebook.com/discussexcel > >> > >> -- > >> > ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >> > >> To post to this group, send email to excel-macros@googlegroups.com > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > >> > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
