Glad it worked out. btw, I see that having "project total effort"
and "min time" both present in the project item can be confusing.
I think that the reason for this would be that for some people,
the project item itself represents effort: cleaning up, finalizing
the paperwork, reviewing the result for process improvement, etc.
In these cases the "min time" for the project item would represent
the cost of this final effort, while "project total effort" would
be the sum of the cost of every task in the project, including the
project item itself.
If you want to use this, I think you should request a change to
MLO to add "project total effort" to the list of fields that can
be selected to appear as a column in a view.
What a bizarre idea Dwight. Clunky as all get out, but it does
roll up numbers up the tree. It took me a bit to realize that I
had to enter the hours into a very bottom level item, not in a
sub-project in order for the number to not get deleted. And,
that I needed to look in the "Project" Properties tab in order
to see the rolled up value, but it does work. I've never used
this field before. A might too granular for my stuff.
I turned on the Time required Max column in my view. Makes the
numbers 'pop' in the list and a bit easier to find once entered.
It is a little disconcerting to see that sewing up a mainsail
cover is going to take "300 hours", when I'm using it to mean
$300. <grin>
I can set up a flat view filter that shows any item with Max
Time >= 1 to see which items all have a number in them to
clean them out or edit them, so that's good. That info is pretty
hidden and I'm not sure I want to have that field showing all
the time.
I really wish that the Max Time field for a project would show
the sum for the values below it. Seems a bit odd to have that
field blank for a project when there are values below it. But, I
do understand that putting a result there (in a project line)
beside data (bottom level line) could be confusing.
Thanks for your 'unorthodox'
thinking. I appreciate it.
Marvin
-------- Forwarded Message
--------
Try this:
Create a project for each boat. For every task associated
with each boat, assign a dollar value and place it in min time
and max time in the "effort" section of task details. If you
cannot precisely identify the cost, get a range of estimates
and place the lowest estimate in min time and the highest
estimate in max time. Now, go to the project item for each
boat and look in the project section for time required for the
project, min and max. This will be the total of the effort
fields of all of the subtasks for that boat. The field is
designed for minutes, it will work best if you record your
costs as hours, for example, if it's $5,000 you would record
5000h.
Biggest drawback, I don't know any way to make MLO show to
project total effort in a view. But asking MLO to make the
field selectable for display seems easier to implement than a
whole new field.
If you try this, please write back and tell whether it worked
for you.
-Dwight
On 1/23/2019 1:55 PM, Marvin Hamm
wrote:
I
really long for a column that we can put a number value in,
that would sum if certain defined conditions are met via a
filter. I'm not exactly how to implement where the sum value
would show up. Maybe an option as part of a right click menu?
Not sure where it would sit.
My situation - I have a boat that I want to do a number of
upgrades on, but I have a limited budget. If I could give $
values to the different projects, I could then turn on/off
choices (Flag/text field...?) to see what that would do to the
$ total. As it is, I now have to create a duplicate list in a
different place to do that kind of estimating. This seems like
unnecessary work. Particularly since it wouldn't be linked,
just a one time export, which is out of date/sync as soon as
the MLO is changed.
I'm already moving to keeping more of my note information
outside of MLO and in Evernote instead, only because of the
ability to add formatting and pictures. Now I need to do this
estimating outside of MLO. Feels like while I have the core
task listed in MLO, I keep finding reasons to do
duplicate/other things with the same list of information
outside of it.
Marvin
You received this message because you are subscribed to the Google
Groups "MLO-beta" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/mlo-beta/7bcc2388-f23b-72ac-7406-bdecd951d11e%40gmail.com.
For more options, visit https://groups.google.com/d/optout.
