Any chance to think about it? Sent from my iPhone
On Jul 20, 2011, at 1:06 AM, Adam Hamilton <adamchamil...@gmail.com> wrote: > 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
