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
