You're a godsend! On Wed, Jul 20, 2011 at 12:57 AM, Anish Shrivastava <anish....@gmail.com> wrote: > 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 >
-- ---------------------------------------------------------------------------------- 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
