This is Robert's Typepad Profile.
Join Typepad and start following Robert's activity
Join Now!
Already a member? Sign In
Robert
Munich, Germany
Interests: new media, optimization, strategy, forecasting, business intelligence, project management, financial planning, business plans, telecommunications, revenue management, business performance management, simulation, pricing, intelligent data analysis, business cases, revenue assurance, cable operator, operations research
Recent Activity
Bertram, I just tried your YML file and it works fine for me, so all I can provide are 2 hints: 1. Make sure your Tableau version and your TabGeoHack version fit. If you are using Tableau 8.2, you need TabGeoHack 2.0, if you are using Tableau 8.1 or an earlier version, you need TabGeohack 1. Richard provides the different links on his VizTalk thread. 2. I assume you tried several times, so it may be a good idea to start from scratch, i.e. remove the existing Custom Geocoding in Tableau, delete all folders in C:\TabGeoHack\Taiwan (Custom Geocoding Files, Feature Files, Local Data Copy, etc.) and try again I am sorry, but since I can't reproduce the problem, this is all I can offer.
1 reply
Image
Invitation to register for ModelOff’s Financial Modeling World Championships 2014 Continue reading
Posted 2 days ago at Clearly and Simply
Image
La Gazzetta dello Sport, the famous Italian sports newspaper uses Tableau Software to visualize 20 years of Italy’s Serie A Continue reading
Posted 4 days ago at Clearly and Simply
Henry, yes, please send it by email and I will have a look.
1 reply
Marc, you cannot add a text to the freeform shapes used in the maps. Texts in shapes are only possible in standard Excel shapes like rectangles, circles etc. The only way to add text to the map would be to insert additional textboxes, assign the name of the region and the data value to the text of the textbox and position the textbox in the middle of the shape. The code to add a textbox would be something like this: Dim shpText as Shape Set shpText = ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 10, 10, 10, 10) The code to change the text would be: shpText.TextFrame.Characters.Text = "Alabama" The position of the box could be changed with the properties .Left and .Top Having said that, I would strongly recommend against your idea. Adding textboxes to all shapes will definitely clutter the display and cause more confusion than insight. I would rather work with a data table or a bar chart next to the map or provide tooltips.
1 reply
Mitchel, as I wrote above, I assume there is a way, but I do not know it off the top of my head. I am sorry, I have to refer you to Google and the Excel/PowerPoint/VBA forums.
1 reply
Roberto, thank you so much for your comments. Very nice. I especially like the one with the Google logo. Thanks again for this fabulous idea!
Toggle Commented Aug 25, 2014 on Motion Chart Excel Template at Clearly and Simply
1 reply
Image
A generic template to create Motion Charts in Microsoft Excel and 2 examples to animate La Linea episodes in Excel Continue reading
Posted Aug 23, 2014 at Clearly and Simply
Mitchel, the PowerPoint constant for slide layout with an object is 16. However, the Placeholder property in PowerPoint has no Paste or PasteSpecial method. If you want to insert a picture into a placeholder, you have to specify a link to a picture. I.e. you can't directly insert the content of the clipboard. You could save the picture temporarily somewhere, insert the file into the placeholder and then delete the picture afterwards. With regards to the HTML export: the PasteSpecial parameter would be 8. I tried, but this does not work: I get an error message saying "Invalid request: The specified data type is unavailable". I assume there is a way to export from Excel to HTML in PowerPoint, but apparently not with the PasteSpecial method.
1 reply
Henry, no need to compile anything in VBA. Just go to the cell with the Completion Rate, press F2 to edit the cell and press Enter to force Excel to recalculate the function. This should solve the issue.
1 reply
Henry, this is an Excel issue. Have a look at my answer to Suzanne's comment above (September 11, 2013). The comment describes how to change the Conditional Formatting. If you just want to get rid of it, you can simply delete the CF and it should work right away.
1 reply
Henry, Question 1: Open the Name Manager (Formula Tab | Name Manager), select myChecklist, change the cell range in the "Refers To" input box, click Close and confirm with Yes. Question 2: This is possible, but it would require some considerable changes in the code, since we would have to distinguish between 3 hierarchy levels instead of only 2. Not impossible, of course, but some VBA coding work necessary. I will put this on my list of ideas and maybe I will publish an update some later day including the various suggestions posted in the comment section already. No promise, though.
1 reply
Aiswarya, you are absolutely right: the technique does not work anymore with Office 2013. The root cause: Microsoft disabled scriptable ActiveX controls like the Webbrowser in Office 2013. This has nothing to do with Tableau. It is a Microsoft issue. None of the workbooks I published here with scriptable ActiveX controls (like the Webbrowser or the Slider) work anymore in Office 2013. I can't tell for sure regarding LiveWeb, but I guess LiveWeb is using the Webbrowser, too. As far as I know, the only option of using scriptable ActiveX elements in Office 2013 is to embed them in a VBA userform. I am sorry, I do not see another solution.
1 reply
Rachel, I do not have a Mac and Office for Mac available, so I can't tell you whether this technique works at all on a Mac. I do not see why it shouldn't, but I can't test and tell for sure. I am sorry.
1 reply
Image
A sneak preview of my entries for Tableau’s “Viz as Art” Contest Continue reading
Posted Aug 13, 2014 at Clearly and Simply
Gilbert, the function should be very straight forward to use. First copy the function of my previous comment into the module. Then wrap up the code which adds an Outlook task into an IF clause calling the function, like this: For Each myTask In ActiveSelection.tasks If TaskExists(myTask) = False Then [… the existing code …] End If Next myTask
1 reply
Gilbert, the following function checks if the task already exists and returns true, if it does and false otherwise, i.e. you should only add the task if this function returns false. Function TaskExists (myTask As Task) As Boolean Dim objOLApp As Object Dim objTasks As Object Dim objTask As Object Dim blnExists As Boolean Set objOLApp = GetObject(, "Outlook.Application") Set objTasks = objOLApp.GetNamespace("MAPI").GetDefaultFolder(13).Items blnExists = False For Each objTask In objTasks If objTask.Subject = myTask.Name & " (Project Task)" Then blnExists = True Exit For End If Next TaskExists = blnExists End Function
1 reply
Gilbert, as you said, this code is working, but it just adds a lot of information to the body of the task. It is not handling the requirements you made in your previous comments. If you want to follow my recommendation and create 2 tasks in outlook to get 2 reminders for start and finish date, you have to duplicate the code to add 2 tasks to Outlook. Set start and end date of the Outlook task to the Project task's start date for the first one and to the finish date for the second one. Furthermore, you set the reminder time to myTask.Start – 2 for the first one and to reminder time to my-Task.Finish – 2 for the second one.
1 reply
Gilbert, yes this is possible. You should first make sure the task in Outlook gets a unique name, e.g. a combination of project filename, WBS and the name of the task. You can then loop through all tasks in Outlook to check if the task already exists in Outlook and add it only if it doesn't. A For Each loop, an IF clause and a Boolean variable should do the trick.
1 reply
Gilbert, yes, but the weekly reminder would be just one of the issues. Let me try to clarify with two examples: Example 1: Let's say you have a Project task starting on Monday 08/11/2014 and a duration of 5 days, i.e. the task ends Friday 08/15/2014. If you set the recurrence to weekly, you will never get a reminder for the finish date. Example 2: Now let's say you have the same start date, but this time the task has a duration of 8 working days. You will get a reminder at the start, another one a week later (Monday 08/18/2914), but no reminder at the finish date (Wednesday 08/20/2014). The only way to get around the described issues in the examples would be setting the recurrence to daily, not weekly. However, in my humble opinion, receiving a reminder every day would be more annoying than helpful, especially for tasks with a long duration. Furthermore: I do not see the advantage of your approach compared to my suggestion of simply creating 2 tasks in Outlook.
1 reply
Gilbert, I do not think you will be able to get what you want with a recurring Outlook task. If the duration of the Project task is less than a week, Outlook will not remind you at the finish date. If the duration of the Project task is 2 weeks or longer, it will remind you every week, not only at the start and finish date. I would still recommend to split each Project task into two Outlook tasks, one for the start date and one for the end date (see my previous comment).
1 reply
Gilbert, sorry, I misunderstood what you meant by recurring. You can set the reminder time of a task using the properties .ReminderSet and .ReminderTime, but I do not think it is possible to set two reminders for one Outlook task, i.e. one for the start date and one for the finish date. I do not see a way how to do this in Outlook manually either: you can only set one reminder, i.e. each Outlook task has maximum one reminder. The only way I see to get what you want is to create two Outlook tasks for each Project task: one for the start date and one for the finish date. You could then set the reminders for those two tasks referring to the start and finish date of the Project task.
1 reply
aalok, I can reproduce this. I double checked and the two workbooks I described at the end of the post (displaying files in a folder and displaying PDF documents) do not work anymore. Not at all, I mean not even in Tableau Desktop, let alone on the server. The workbooks linking to a webpage are still working like a charm. I have no clue why. I assume Tableau changed something in the recent versions which affected this functionality of the webpage object. I can't tell you what happened. I am sorry. Maybe you want to search on the Tableau Forums or contact Tableau's support team to get an answer.
1 reply
Gilbert, if you insert a recurring task in Project, a parent task is created with children tasks for each occurrence. Just like any other task, the recurring task has a start and finish date. With the task property .Recurring you can check whether a task is a recurring task or not. If it is, .OutlineChildren.Count gives you the number of children tasks, i.e. how often the task has to be repeated. With this information, you should be able to create a recurring task in Outlook using Outlook's RecurringPattern object and its properties.
1 reply
Gilbert, as far as I know, there is no such thing as a Project task without a start and end date. It is possible to insert a task into Project without specifying start date, end date and duration. You can identify those tasks by the question mark in the task mode column, indicating that Project needs more information. However, even if you do not specify this information, the tasks have a start and an end date: the Project's start date. I would assume the past date you are talking about isn't arbitrary, it rather is the overall start date of your project. If you want to set the dates in Outlook to "None" for the tasks which need more information, you could use the task properties .IsStartValid and .isFinishValid. You can wrap up the code which sets the start and due date in Outlook into an IF-clause like this: If myTask.IsStartValid Then .StartDate = myTask.Start End If If myTask.IsFinishValid Then .DueDate = myTask.Finish End If
1 reply