Design Table for WBS
Hi One consultan, I have a Database with some tables, ones of them are correspond with the structure of the project WBS Work Breakdown Structure I have four level.
Level 1 Project, Level 2 Area, Level 3 Subarea, and Level 4 Subtistem in each box Level are asociated documents by disciplines.
Now I Link Each level to documents 1 to Many Level 1 to Documents, Level 2 to Documents etc.
I don't sure if is the best options I trie too related Level 1, to Level 2 to Level 3 and Level 4 but these option is complicated.
Some Alternative help
I send image example
-
You can see 3 curve the planned curve, the earned value and the Actual Hours.
The 3 hours are different.
-
Rafael Sanchis said:
Horas Ganadas Real are the Earned value it reflects the amount of hours that has actually been accomplished to data date.I read this as Horas Ganadas Real should be a formula field that sums up the Horas Consumidas for each documentos/disciplinas/ or actividades. Currently you are using the same horas humbre to figure out Plan and Real Horas Ganadas. To me, hitos only make sense at the planning level. Once you need actual horas then you have to track horas spent in another field (or table).
Take a look at the attached DB. I've made a few modifications:
1) at the Documentos Hito tab
2) FechaCorte table
-
Now that I've had a chance to play around more, I've modified:
Avances
Disciplinas
Documentos
FechaCorte
Take a look to see what you can do when you have a horasconsumidas table tracking horas. You can see the charts change in Tablero Avances when you add horas in Documentos.
FechaCorte, I've changed into a dashboard. I've added the ability to see horas consumidas real by Hito selected.
-
Fred Hi Fed
OK in first picture, in these view I linked the Responsable with Documents now I know who charges hous to a Documents, works perfect now I have the Horas Actuales (Actual Hours) for each document spended by responsable
In the second view I have my 3 kind of hours totally different hours
The Plan Hours (Plan Original)
The Earned Hours (Ganadas) I need to place the date to win the Milestone and earned the hours different to Actual Hours
The Horas Actuales ( Actual Hours) A Responsable spend on the document)
-
-
I send you my last modify
-
Another diferent help. These WBS havec3 level
Level 2 and level 3 don't working
But level 4 and 4 working good you can review the Formula on level 3 if you can
Thanks
-
Rafael Sanchis You had too many "a" and "b" in your code. Try deleting the contraints and just use the selection of the fields in the left side of the window. So for Level 3 you would select a (Documents) > Level 2 and b (Level-3) > Main Category. Do the same for Level 4, of course changing the actual field names.
-
-
I can't do it with the formula -
What are the formulas you are using?
-
(select Documents) > a.a.'Level-2' and a.a.'Level-2' > a.a.'Level-3'
I use this, but imposible.
Sorry Fred I don't to waste your time.
-
Hi Rafael -
You are not wasting my time. Try this in Level 3:
a.'Level-2' = b.mainCategoryAnd this in Level 4:
a.'Level-3' = b.'Level-3'Like I said earlier, you have too many "a"s and "b"s. In addition there is no name "Level-2" in Level-3 table it is called 'mainCategory'.
-
Yeah work great for these work Breakdown Structrue that is more complicated.
