tag:blogger.com,1999:blog-6117740614504745275Fri, 17 Jul 2026 10:37:35 +0000generalreportdashboardexcelanalyticsgooglelogical testcodesdata validationdatesfunnelsvisualisationhttp://logical-test.blogspot.com/noreply@blogger.com (Logical Test)Blogger9125tag:blogger.com,1999:blog-6117740614504745275.post-6601142972630270741Fri, 21 May 2010 19:08:00 +00002010-05-21T12:12:53.135-07:00dashboarddata validationgenerallogical testreport Cell I8 on the Dashboard style report, is a list of all the months, years or date range. To create this list first define all the content that you want within the drop down in a selection of cells. Once you have done this select the cell that you to have the dropdown be contained in and then set the list by… 1. Go to the "Data" tab, and select "Data validation"… 2. Then a pop should appear, http://logical-test.blogspot.com/2010/05/dashboard-style-report-how-to-create.htmlnoreply@blogger.com (Logical Test)294tag:blogger.com,1999:blog-6117740614504745275.post-2804753272941089519Tue, 27 Apr 2010 10:12:00 +00002010-04-27T03:12:35.070-07:00Well it is always going to be our fault so we have to fix it! So if you find that you have errors within you’re excel sheet what should you do… The errors that you may see are: 1.  ##### – this is simply, your column is not wide enough! 2.  #DIV/0! – this is where you are dividing by 0. So you can use a simple iserror Excel 03 or lower or iferror if you have Excel 07 or you can usehttp://logical-test.blogspot.com/2010/04/to-err-is-human.htmlnoreply@blogger.com (Logical Test)0tag:blogger.com,1999:blog-6117740614504745275.post-3587757853949241264Tue, 06 Apr 2010 16:24:00 +00002010-04-06T09:24:34.144-07:00codesdatesexcelgenerallogical testreportIf you use dynamic dates and would like for the dates to not show excessive characters then try the below formula, just replace [start date], and [end date] with the fields that contain the start and end date…..   =IF(AND(DAY([Start date])=DAY([End date]),MONTH([Start date])=MONTH([End date]),YEAR([Start date])=YEAR([End date])),TEXT([Start date],"D Mmmm YYYY"),IF(AND(MONTH([Start date])=http://logical-test.blogspot.com/2010/04/would-you-like-date.htmlnoreply@blogger.com (Logical Test)0tag:blogger.com,1999:blog-6117740614504745275.post-1531888398643314597Tue, 23 Feb 2010 09:54:00 +00002010-02-23T01:54:54.635-08:00analyticsdashboardexcelfunnelsgeneralgooglereportvisualisationHi all, As promised but a little late, a new report. This is my version of the Google Analytics funnel visualization report, this is great for defining a funnel and then looking for those weak pages. As is always the case, if you have any questions or queries then leave a comment and I can get back to you. This report is currently only available from http://www.scribd.com/doc/27322109/http://logical-test.blogspot.com/2010/02/funnel-visualisation-report.htmlnoreply@blogger.com (Logical Test)0tag:blogger.com,1999:blog-6117740614504745275.post-7952887543587180830Wed, 10 Feb 2010 21:06:00 +00002010-02-10T13:09:43.570-08:00dashboardexcelgeneralreportHi all,Just a quick not to let you know that this report is also available for Office 2003, from http://www.scribd.com/doc/26686010/A-dashboard-style-report-version-2-for-Excel-2003Also if you have any ways on improving these report then let me know.Cheers Logical Testhttp://logical-test.blogspot.com/2010/02/dashboard-style-report-for-excel-2003.htmlnoreply@blogger.com (Logical Test)0tag:blogger.com,1999:blog-6117740614504745275.post-6745465280285392104Mon, 08 Feb 2010 17:26:00 +00002010-02-08T09:28:11.214-08:00analyticsexcelgeneralgoogleOk so its been about a week since I uploaded the second version of the Dashboard style report, there are not a huge amount of changes from the first, however in my opinion I feel like I have cleaned up the whole report.The main changes are that the charts are little bit more dynamic for the user, allowing for different data to be displayed and all the data has been moved into its own http://logical-test.blogspot.com/2010/02/just-checking-in.htmlnoreply@blogger.com (Logical Test)2tag:blogger.com,1999:blog-6117740614504745275.post-5218526880357152098Wed, 03 Feb 2010 12:07:00 +00002010-02-04T07:37:26.919-08:00Hi all,Well I've been tinkering with the original report, and its available from:A dashboard style report v2http://office.microsoft.com/en-us/templates/TC300089241033.aspxonly made a few tweaks, I've made all the charts a bit more flexible and cleaned up where all the data is stored.If you want any help then just drop a comment or email me at email.logical.test@gmail.comCheersLogical TestIf you http://logical-test.blogspot.com/2010/02/dashboard-style-report-version-2.htmlnoreply@blogger.com (Logical Test)0tag:blogger.com,1999:blog-6117740614504745275.post-5287648079250275198Tue, 22 Dec 2009 20:23:00 +00002010-02-04T07:37:01.564-08:00dashboardreportI've got my first created report available from: A dashboard style reporthttp://office.microsoft.com/en-us/templates/TC300077811033.aspxHopefully you'll find this report useful I'll be adding additional notes for this report. But if you are having difficulties or need help just drop a comment and I'll try my best to help.Back soon....If you have found this useful why not donate via pay palhttp://logical-test.blogspot.com/2009/12/dashboard-style-report.htmlnoreply@blogger.com (Logical Test)0tag:blogger.com,1999:blog-6117740614504745275.post-677253042244702670Tue, 22 Dec 2009 20:02:00 +00002009-12-22T12:07:23.686-08:00Hi all,This hopefully will be a start to a selection of interesting articles and I will be providing example reports to download and advise on any, and if you ask nicely I might be able to help you on a 1-2-1 basis.Happy browsing.... http://logical-test.blogspot.com/2009/12/start.htmlnoreply@blogger.com (Logical Test)0