0

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

null
    • Fred
    • 1 yr ago
    • Reported - view

    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?

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    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

    • Fred
    • 1 yr ago
    • Reported - view

    Can you send me an updated test DB? You are showing a new table that I don't have.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred 

      I send you my DB is my modelling is like the Avances but with the two select statement. I will try by this way but nothing new.

      Thanks

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    I accept all kinds of criticism and improvements to the BD.

    • Fred
    • 1 yr ago
    • Reported - view

    Got the DB.

    Now I'm not sure what you want '%-Plan' in Plan_Real to be equal to.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred No Fred %Plan and %Real generate a Curve Proyect if the Project in going good maybe the both curve are iqual but not is the normal always are delayed and the %Real is less than the %Plan at the finish of the Proyect both are on 100% 

      Remember I change the Fecha Corte every week and give me value for Plan and Real that value I need store in some field and don't change every time now I do it manually in Avances 

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view
    • Fred
    • 1 yr ago
    • Reported - view

    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?

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    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.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    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%

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    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
  • 1 yr agoLast active
  • 12Replies
  • 119Views
  • 2 Following