Return to my Topic
Fred
RoSoft_Steven Rooryck
To Return the topic since it point that I need to have my DB at last 90% . Excuse the insistence but is very important and I can't resolve this.
I'm sending these images to see how I solve this. I mentioned these project have 8 weeks develop, and each week on Friday I made a cutoff change de FechaCorte, to update the progress of the project.
The Problem is that every I change the FechaCorte the values change on all the weeks I need to keep the values in each weeks.
I'm doing these small tablets and with that Formula take the value for Avance Plan and Avance Real
last((select DOCUMENTOS where Id = 890).'Avance Plan')
last((select DOCUMENTOS where Id = 891).'Avance Real')
I hope it is understood.
Thanks Again for your patience.
12 replies
-
I like that you now track the weeks in a separate table. I think that is a good idea.
I'm not sure what you are doing with the select statements. Why are you specifying a specific record?
-
I'm not sure what you are doing with the select statements. Why are you specifying a specific record? An attempt to see if something could be done but it did not work
I'm running out of options
-
Can you send me an updated test DB? You are showing a new table that I don't have.
-
I accept all kinds of criticism and improvements to the BD.
-
Got the DB.
Now I'm not sure what you want '%-Plan' in Plan_Real to be equal to.
-
-
Maybe I'm not following correctly, but it seems like for the %_Plan field in the Avances table should be your master number for your DB. This will force a big rethink of the design of your DB.
For example at the beginning of a project you project that by certain dates you will have completed x% of the project. On 10-Mar, you plan your project to be 0.5% done. On 7-Apr, 44.75%, etc. So you only need to input this data once.
Everything else flows from this table.
Instead of FechaCorte modifying Avances, it should be FechaCorte looking to Avances for the data. You put in a date for FechaCorte and it looks at Avances to see where you should be in the project.
For example on the Plan_Real table if you change the formula for %-Plan to:
let t := this; last(((select AVANCES)['FechaCorte de la Semana' <= t.'Fecha del Corte'] order by 'FechaCorte de la Semana').'%_Plan')Does this make sense?
-
Yes I thinks not understand the process maybe I don't explain correctly.
Each document have Ganado Plan and Ganado Real if I have 500 documents the sum of the hours of each document Horas Ganadas Plan and Horas Ganadas Real give me the total for the total Project.
Example 500 Document all document have 10 hours 5000 hours
When I cut off on X week The Plan said me that the project should have earned Horas Ganadas Plan 2500 the 50% but the project is delayed only earned Horas Ganado REAL 2000 hours 40% the delayed is 10% 500 hours.
But I need the following document by document The Ganado Plan and Ganado Real have the most importan Formula in the Database.
That metodology is the most standard for Project Control Progress for financial and hours.
Place € instead on Hours and have the Finalcial project for X CutOff date The Project should have billed 100.000 € but have delayed and only earned 90.000 € have €10.000 not invoice.
-
Fred
That is the Curve of the Project in Excel, Now I follow the Project in Excel with the same metodology. You see the project is delayed the project should finish but only is on 63.00%
-
When I change the FechaCorte the system calculate all document with the changes doing in each of the FechasR1 to FechasR5.
The Plan Progress dates FechaP1 to FechaP5 are places in the beginning the project and don't changes I only update the FechaR1 to FechaR5
Content aside
- Status Answered
- 2 yrs agoLast active
- 12Replies
- 119Views
-
2
Following