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
