|
Feb 2019
10:40am, 20 Feb 2019
800 posts
|
um
I spent many hours/days/months with Visio & process flows .. after realizing the best way was to get one I liked, then use that as the start for all others. Only disprupted eevery year or two by company branding changes (colour palettes, fonts, rounded or square corners etc)
Project was particularly painful - seemed designed for people who preferred to spend their time administering planning and re-planning vs doing. And anything more than the current and next quarter was conjecture anyway.
I found no-one (other than me) was particularly bothered by that level of detail on a project - what was most needed was a Powerpoint Gantt, with about 10 -12 high level phases/deliverables per slide.
|
|
Feb 2019
11:07am, 20 Feb 2019
110,882 posts
|
GregP
Top post Um.
|
|
Feb 2019
2:07pm, 20 Feb 2019
8,408 posts
|
Markymarkmark
I must admit - I quite like Visio. It's how my mind works!
I *still* think it's rather cool even after using it for years that the flow follows even when you move the various process steps around. 
Project is exactly what you described Um! Many of my "delivery" colleagues are really good at using it for those purposes....
|
|
Feb 2019
2:45pm, 20 Feb 2019
11,814 posts
|
Rosehip
That was good enough Ed manually setting it up and colouring in cells gave the desired effect without anything complicated or automatic- I was thinking of dependecies and resources and all the complications I used to deal with - this just needed to be a glorified calendar - thank you
|
|
Feb 2019
4:37pm, 20 Feb 2019
34,437 posts
|
Diogenes
The idea that Visio might automatically do what one wants rather than the exact opposite is mind-boggling.
|
|
Feb 2019
5:43pm, 20 Feb 2019
110,885 posts
|
GregP
Well it might, and then crash? If Visio worked in anything like a logical fashion I’d love it. But it doesn’t and I don’t.
|
|
Feb 2019
7:51pm, 20 Feb 2019
41,030 posts
|
GlennR
All PM tools are just ways of weighing the pig (thanks Greppers). Not one has ever helped a project succeed.
|
|
Feb 2019
11:50am, 21 Feb 2019
110,892 posts
|
GregP
<vent>
The default text alignment for the Secondary Vertical Axis is stupid. Admittedly this is nothing compared to the 'secondary axis bug for clustered columns' bug but I'm kind of used to that now.
</vent>
|
|
Feb 2019
7:20pm, 25 Feb 2019
3,857 posts
|
Curly45
Excel wizzes. I have two PowerPivot tables that pull pricing from various places and put them in rows, such as:
product, price in place A, price in place B
product 2, price in place A, price in place B
And so on for 1000s of products
I have a week date filter on both. The idea being that I want to compare this week with last and dynamically (i.e. when the filters change) show if the price this week is down or up from last week.
I am using a helper code that is unique and have the following tables in my database that is powering the pivots:
Date table - date code, week, month, year, date in a friendly format
Code match table - main code to helper code + product name + brand
Place A code table - Place A code, helper code
Place A price table - date code, place A code, price
Relationships are all one to many.
I think I need to have an IF statement as a product may not appear if not sold in the current week you are looking, calculation does not need to be done in the pivot table as I am using a front end to present the data in a nice format. I am not so good at formulas so any help welcome
|
|
Feb 2019
2:46pm, 27 Feb 2019
18,140 posts
|
flanker
But many PM tools have helped a project fail, as valuable PM time has been wasted in producing project plans that conform to this month's whims of the PMO.
In any sizeable project detailed planning (or more accurately, forecasting) much more than a quarter out is pointless.
|
