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
Savy, the error indicates that the code addresses an object that does not exist. Without seeing the code, I cannot tell what the specific problem is. You can send me your workbook per email (email link at the top of the blog) and I will have a look as soon as I have the chance to.
Toggle Commented 2 days ago on Bring your tasks in a row at Clearly and Simply
1 reply
Savy, the import routine loops through the tasks collection of the project and writes the defined information for each task to the worksheet in Excel. The Project Summary Task, however, is not part of the tasks collection and therefore it is not imported in Excel. To get the Project Summary Task into Excel, you must add a few statements before the For Each loop statement like this: […] varTaskInformations.Offset(1, 1) = varProj.ProjectSummaryTask.Name [… additional statements to get more properties of the Project Summary Task as needed…] varRowCount = 2 For Each varTask In varProj.Tasks [… rest of the code as it is…]
Toggle Commented 3 days ago on Bring your tasks in a row at Clearly and Simply
1 reply
Savy, I do not have a solution to post for download, but here is one possible way how you could approach this challenge: First you need to get to a table in Excel including at least the name, the start date and the end date for all tasks. I do not know how your Excel sheet looks like, but if you have only manually colored cells to indicate start and end of a task, you need to use either formulas (like GET.CELL) or a VBA user defined function to extract start and end date from the colors of the cells and the cell range containing the dates of the time range. After you have the table with task name, start and end, you can either copy and paste the tasks into a Project file or use Project's import function (New | New from Excel workbook) to get the information into a Project file.
Toggle Commented 4 days ago on Bring your tasks in a row at Clearly and Simply
1 reply
Savy, I am sorry, but I do not understand your question. The Excel tool posted above for download imports all tasks from a MS Project file into an Excel sheet and the cells right to the cells with the task information uses conditional formatting to visualize the tasks (start to finish date) in a pseudo Gantt "chart". I do not understand what you mean by "…indicate the start and finish dates for each task…". Isn’t this already done in the tool above?
Toggle Commented Feb 11, 2020 on Bring your tasks in a row at Clearly and Simply
1 reply
Savy, replace the line .Text = intMonthNumber by .Text = MonthName(intMonthNumber, True)
1 reply
Savy, sounds like a corrupted file in your Office installation. Try to repair your Office installation (Control Panel) or – if this does not help – consider a re-installation of Microsoft Project.
1 reply
David, the code cannot detect the count of constant and formula cells, the conditionally formatted cells, the cells with data validation, etc. as long as the worksheets are protected. However, it should show the count of used cells, the count of tables, Pivot tables, charts, lines of VBA code, etc. even if the sheets are protected. Are the sheets protected in your workbook? If so, unprotect them and try again. If this does not solve your problem, you can send me your workbook by email (email-link see the top of the blog) and I will have a look.
1 reply
Ahmed, all checklist versions posted in the comments and in the article with the checklist compilation are more or less slight variations of the code provided in the posted above, i.e. they are all working along the same basic idea and only a few lines of code are changed or new (compared to the original version). If you want to have the functionality of two or more of the different versions in one workbook, you have to identify the differences in the code and combine the codes in one workbook. All workbooks and codes are open, i.e. without password protection.
1 reply
Ahmed, as I wrote in my reply to Nicki, I do not have the time to implement this request. I do not know if Nicki enhanced the VBA code to accomplish this. Even if this is the case, I doubt Nicki will revisit this article and post the solution. I am sorry.
1 reply
CB, it has been removed from the data on purpose. The used algorithm only handles continuous areas ("An algorithm to construct continuous area cartograms" by J. Dougen-ik, N. Chrisman and D. Niemeyer), i.e. it cannot be used to create cartograms of maps with regions consisting of more than one polygon.
Toggle Commented Sep 7, 2019 on Cartograms in Tableau at Clearly and Simply
1 reply
cakesnake, I would create a Calculated Field which extracts the numbers from the strings, e.g.: REGEXP_EXTRACT([Value], '(\d+)') If you then sort the view by this Calculated Field, you should get what you want.
Toggle Commented Sep 2, 2019 on Dynamic Sorting with Tableau at Clearly and Simply
1 reply
TML, many thanks for your comment and your kind words. Much appreciated. Actually, I have noticed this problem, too, but did not mention it in the article. My bad, I am sorry. The alignment of the numbers in the message box is done by inserting tabs (vbTab) in the strings used for the message box. Unfortunately, this does not work properly for all screen resolutions. Truth be told, I have no idea how to fix this issue. All you can do is inserting additional or deleting existing vbTabs in the MsgBox statement at the end of the code by trial and error until the text in the Message Box looks good on your machine. As I said, I do not know how to make this work for all screen resolutions. I am sorry.
1 reply
Tanapan, Jonathan Drummey wrote a fantastic blog post including a solution for your problem: Formatting Time Durations in Tableau
1 reply
Emma, I am sorry, no. The code is open, though, so please feel free to adjust or enhance the features as you like.
1 reply
Wenqia, unfortunately, no. The algorithm implemented in the Cartogram Data Generator Tool posted above only handles continuous areas ("An algorithm to construct continuous area cartograms" by J. Dougenik, N. Chrisman and D. Niemeyer). I.e. the tool cannot be used to create cartograms of maps with regions consisting of more than one polygon. You can either keep only the largest polygon of each region and remove the others or you need to implement another algorithm.
1 reply
Gee, please see paragraph 3 in the section "Step 3: Collect the Polygons" of the article.
1 reply
I can’t reproduce your complaint. The link is valid.
1 reply
Raj, the texts "Hierarchy Level 1" and "Hierarchy Level 2" are the names of the Calculated Fields and I do not know of a way how to directly make names of Calculated Fields dynamic according to a parameter selection. There is a workaround, though, based on additional Calculated Fields, additional worksheets and floating sheets on a dashboard. I think this might be a way to get what you want. Have a look at this Tableau Knowledge Base article: Tableau KB: Creating Dynamic Column Headers
1 reply
Varsha, I am sorry, but I do not understand your question. The blog post describes a technique (working only in Office 2010 and earlier) to embed Tableau workbooks in PowerPoint. There is no "power point generated out of Tableau", so I do not understand what your question is referring to.
1 reply
Christoph, the current coordinates of the mouse (when hovering over the chart) are calculated by the VBA sub myEmbeddedChart_MouseMove in the class module clsChartEvent.
1 reply
Juan, did you also resize the ActiveX label control?
1 reply
Angela, I used the technique with Excel 2010 / Windows 7, Excel 2013 / Windows 7, Excel 2016 / Windows 10 and nowadays with Excel 365 / Windows 10 and never had the problem you described. You can send me your workbook by email and I will check if I can reproduce the error on my machine, if you want.
1 reply
Savy, you have to adjust the range of the name [myProjectInfoRange] in the Name Manager.
Toggle Commented Mar 25, 2019 on Bring your tasks in a row at Clearly and Simply
1 reply
Savy, I can’t reproduce the problem. I just checked and exported a Project task with 10,000 words in the notes (more than 60,000 characters) to Outlook and it was correctly and completely exported. Not truncated, neither at the beginning nor at the end. I have no clue why this does not work for you.
1 reply
Savy, this is possible, too, but it requires quite some additional coding. The code would first run through all selected project tasks and create a unique list of all resources, the tasks have been assigned to. Then it would run through this list of resources and all selected tasks and compile a list of tasks for each resource. Finally, it would run through all resources again and send one Outlook task containing the information of all Project tasks to this resource. Not impossible, but a lot of extra coding necessary. The code is unprotected, so please feel free to adjust it as you like.
1 reply