Development Progress
Rewrite checklist: MS Access → Next.js + Python + PostgreSQL. AI assessment of MBS2018.accdb, kept in lib/progress-data.ts.
Effort · manual (written by hand) · 8 h = 1 MD
Total2,237 h279.6 MD
Consumed19.2 h2.4 MD · 0.86%
Remaining2,217.8 h277.2 MD
Tasks done0of 245 · 3 N/A
Done 0 h · 0 tasksIn progress 0 h · 0 tasksMockup 48 h · 2 tasksNot yet 2,189 h · 243 tasks
Consumed counts Done 100%, In progress 50%, Mockup 40% (screen exists, not wired to an API), Not yet 0%. Manual = rough (±50%) engineer hours writing everything by hand, including self-testing.
| Code | Type | Module | Task | Access source | Hours | Status |
|---|---|---|---|---|---|---|
| UI | Shell | frmMain · basMenuSystem | 24 | Mockup | ||
| UI | Shell | frmMain | 16 | Not yet | ||
| UI | Shell | frmAbout | 2 | Not yet | ||
| UI | Shell | frmSplashScreen | – | N/A | ||
| UI | Projects | frmProjectOpen | 10 | Not yet | ||
| UI | Projects | frmProjectNew | 8 | Not yet | ||
| UI | Projects | frmProjectCopy | 10 | Not yet | ||
| UI | Projects | frmProjectPassword · frmProjectPasswordEntry | 8 | Not yet | ||
| UI | Projects | frmProjectRepOpen | 8 | Not yet | ||
| UI | Projects | frmProjectRepNew | 8 | Not yet | ||
| UI | Projects | frmProjectRepCopy · frmProjectRepCopyStatus | 12 | Not yet | ||
| UI | Projects | frmProjectRepCalendar_Create | 12 | Not yet | ||
| UI | Projects | frmProjectRepCalendar_Modify (+_d, _d2) | 24 | Not yet | ||
| UI | Base data | frmBaseData_Constants | 6 | Not yet | ||
| UI | Base data | frmBaseData_Rosters | 8 | Not yet | ||
| UI | General data | frmGenData_Countries · frmCountries_Add | 8 | Not yet | ||
| UI | General data | frmGenData_Equip · _EquipSubCost · _EquipSubSpare · frmEquipmentModelList | 20 | Not yet | ||
| UI | General data | frmGenData_Infras | 8 | Not yet | ||
| UI | General data | frmGenData_ProjectCatSub1 · Sub2 | 10 | Not yet | ||
| UI | Resources | frmResource_Fleet · FleetCostComponent · FleetSparePart · FleetResource · FleetServicer · FleetOperator | 24 | Mockup | ||
| UI | Resources | frmResource_FleetResource Sched | 16 | Not yet | ||
| UI | Resources | frmResource_EmpTypeSub1 · Sub2 | 10 | Not yet | ||
| UI | Resources | frmResource_MatServ | 8 | Not yet | ||
| UI | Resources | frmResource_Infras · frmResource_InfrasSub | 14 | Not yet | ||
| UI | Equipment | frmInputEquip · frmInputEquip_SubRoster | 10 | Not yet | ||
| UI | Equipment | frmInputEquip · frmInputEquip_SubOH | 14 | Not yet | ||
| UI | Equipment | frmInputEquip · frmInputEquip_SubPA | 10 | Not yet | ||
| UI | Financial data | frmInputFD_CostIndex | 10 | Not yet | ||
| UI | Financial data | frmInputFD_ExchRate | 10 | Not yet | ||
| UI | Financial data | frmInputFD_LeviesSub1 · Sub2 | 12 | Not yet | ||
| UI | Financial data | frmInputFD_CostSpread_Equip | 14 | Not yet | ||
| UI | Financial data | frmInputFD_CostSpread_Infras · Infras2 | 16 | Not yet | ||
| UI | Financial data | frmInputFD_IndexAlloc | 10 | Not yet | ||
| UI | Functions | frmInputFunc_SubGen | 10 | Not yet | ||
| UI | Functions | frmInputFunc_SubMatServ | 12 | Not yet | ||
| UI | Functions | frmInputFunc_SubPers | 12 | Not yet | ||
| UI | Production | frmInputProd_Prod | 12 | Not yet | ||
| UI | Production | frmInputProd_ProdFactor | 8 | Not yet | ||
| UI | Functions | frmFunctionBuilder | 24 | Not yet | ||
| UI | Cost centre | frmCostCentre | 24 | Not yet | ||
| UI | Cost centre | frmCostCentre_AddEdit | 8 | Not yet | ||
| UI | Cost centre | frmCostCentreSubFleet · frmCostCentrePop | 12 | Not yet | ||
| UI | Cost centre | frmCostCentreSubEmployeeType · PopEmployee | 10 | Not yet | ||
| UI | Cost centre | frmCostCentreSubInfrastructure · PopInfrastructure | 10 | Not yet | ||
| UI | Cost centre | frmCostCentreSubResource · PopResource | 10 | Not yet | ||
| UI | Cost centre | frmInfrastructureCheckList | 6 | Not yet | ||
| UI | Analysis | frmAn_Launcher | 10 | Not yet | ||
| UI | Analysis | frmAn_Options | 6 | Not yet | ||
| UI | Analysis | frmAn_Status | 10 | Not yet | ||
| UI | Output | frmRunReport · frmRunReportSub | 16 | Not yet | ||
| UI | Output | frmRunReport_Export | 8 | Not yet | ||
| UI | System | frmSysDataMaintenance | 8 | Not yet | ||
| UI | System | frmxxxCreateField | – | N/A | ||
| UI | Auth | - (new in web) | 12 | Not yet | ||
| UI | Auth | - (new in web) | 8 | Not yet | ||
| UI | Administrator | - (new in web) | 16 | Not yet | ||
| UI | Administrator | - (new in web) | 20 | Not yet | ||
| UI | Administrator | - (new in web) | 12 | Not yet | ||
| UI | Administrator | - (new in web) | 12 | Not yet | ||
| UI | Administrator | - (new in web) | 8 | Not yet | ||
| UI | Report | - (new in web) | 40 | Not yet | ||
| UI | Shell | ~139 combo boxes in 54 forms; add-new handlers (NotInList) in frmProjectNew (3) and one other form | 8 | Not yet | ||
| Report | Data listing | rptComm Basic Schedule | 10 | Not yet | ||
| Report | Data listing | rptComm Capital Cost Spread - Equipment | 5 | Not yet | ||
| Report | Data listing | rptComm Capital Cost Spread - Infrastructure | 5 | Not yet | ||
| Report | Data listing | rptComm Constants | 3 | Not yet | ||
| Report | Data listing | rptComm Cost Centre · Sub Employee/Equipment/Infrastructure/... | 12 | Not yet | ||
| Report | Data listing | rptComm Countries And Currencies | 3 | Not yet | ||
| Report | Data listing | rptComm Employee Types | 3 | Not yet | ||
| Report | Data listing | rptComm Equipment · Sub Cost/Operator/Resource/Servicer/Spares | 10 | Not yet | ||
| Report | Data listing | rptComm Equipment OH | 4 | Not yet | ||
| Report | Data listing | rptComm Equipment Rosters | 4 | Not yet | ||
| Report | Data listing | rptComm General Function | 4 | Not yet | ||
| Report | Data listing | rptComm Generic Equipment · Sub Cost/Spares | 6 | Not yet | ||
| Report | Data listing | rptComm Index and Contingency Alloc | 4 | Not yet | ||
| Report | Data listing | rptComm Infrastructure · Sub Cost | 5 | Not yet | ||
| Report | Data listing | rptComm Infrastructure CheckList | 3 | Not yet | ||
| Report | Data listing | rptComm Levies | 3 | Not yet | ||
| Report | Data listing | rptComm Materials And Services | 4 | Not yet | ||
| Report | Data listing | rptComm MatServ Function by Cost Centre | 6 | Not yet | ||
| Report | Data listing | rptComm MatServ Function by CostCentre Infrastructure | 6 | Not yet | ||
| Report | Data listing | rptComm Personnel Function by Cost Centre | 6 | Not yet | ||
| Report | Data listing | rptComm Personnel Function by Cost Centre Infrastructure | 6 | Not yet | ||
| Report | Data listing | rptComm Project Categories | 3 | Not yet | ||
| Report | Data listing | rptComm Rosters | 3 | Not yet | ||
| Report | Cost & schedule | rptCost Employee Schedule (A4 / Letter / Legal) | 14 | Not yet | ||
| Report | Cost & schedule | rptCost Employee Schedule Summary (A4 / Letter / Legal) | 10 | Not yet | ||
| Report | Cost & schedule | rptCost Equipment Schedule (A4 / Letter / Legal) | 14 | Not yet | ||
| Report | Cost & schedule | rptCost Equipment Schedule Summary (A4 / Letter / Legal) | 10 | Not yet | ||
| Report | Cost & schedule | rptCost Infrastructure (A4 / Letter / Legal) | 14 | Not yet | ||
| Report | Cost & schedule | rptCost Infrastructure Summary (A4 / Letter / Legal) | 10 | Not yet | ||
| Report | Cost & schedule | rptCost MatServ Schedule (A4 / Letter / Legal) | 16 | Not yet | ||
| Report | Cost & schedule | rptCost MatServ Schedule Summary (A4 / Letter / Legal) | 10 | Not yet | ||
| Report | Cost & schedule | rptCost Total (A4 / Letter / Legal) | 14 | Not yet | ||
| Report | Cost & schedule | rptEmployee Schedule (A4 / Letter / Legal) | 12 | Not yet | ||
| Report | Cost & schedule | rptEmployee Schedule Summary (A4 / Letter / Legal) | 10 | Not yet | ||
| Report | Cost & schedule | rptEquipment Schedule (A4 / Letter / Legal) | 12 | Not yet | ||
| Report | Cost & schedule | rptEquipment Schedule Summary (A4 / Letter / Legal) | 10 | Not yet | ||
| Report | Cost & schedule | rptGeneral Function (A4 / Letter / Legal) | 8 | Not yet | ||
| Report | Cost & schedule | rptMatServ Schedule (A4 / Letter / Legal) | 14 | Not yet | ||
| Report | Cost & schedule | rptMatServ Schedule Summary (A4 / Letter / Legal) | 10 | Not yet | ||
| Report | Excel export | qryExport Capital Cost | 6 | Not yet | ||
| Report | Excel export | qryExport MatServ (Non Equip) by CC | 3 | Not yet | ||
| Report | Excel export | qryExport MatServ (Non Equip) Cost by CC | 3 | Not yet | ||
| Report | Excel export | qryExport MatServ All by CC | 3 | Not yet | ||
| Report | Excel export | qryExport MatServ All Cost by CC | 3 | Not yet | ||
| Report | Excel export | qryExport MatServ Summary | 3 | Not yet | ||
| Report | Excel export | qryExport MatServ Summary Cost | 3 | Not yet | ||
| Report | Excel export | qryExport Operating Cost | 3 | Not yet | ||
| Report | Excel export | qryExport Project Cost | 3 | Not yet | ||
| Report | Cost & schedule | 48 duplicated reports | – | N/A | ||
| API | Auth | frmProjectPasswordEntry · basLicense | 12 | Not yet | ||
| API | Project | frmProject* · qryCpy * | 16 | Not yet | ||
| API | Project | frmProjectRep* | 16 | Not yet | ||
| API | Project | frmProjectRepCalendar_* · basFunction Calendar | 12 | Not yet | ||
| API | Base data | tblPR Constant | 4 | Not yet | ||
| API | Base data | tblPR Roster | 6 | Not yet | ||
| API | General data | tbl Country | 6 | Not yet | ||
| API | General data | tbl EquipmentModel* | 12 | Not yet | ||
| API | General data | tbl Infrastructure | 6 | Not yet | ||
| API | General data | tbl ProjectCategory* | 8 | Not yet | ||
| API | Resources | tblPR Fleet | 10 | Not yet | ||
| API | Resources | tblPR Fleet* children | 14 | Not yet | ||
| API | Resources | tblPR FleetResource Scheduled | 8 | Not yet | ||
| API | Resources | Copy to Generic button | 6 | Not yet | ||
| API | Resources | tblPR EmployeeType* | 8 | Not yet | ||
| API | Resources | tblPR Resource | 6 | Not yet | ||
| API | Resources | tblPR Infrastructure* | 10 | Not yet | ||
| API | Input | frmInputEquip* | 12 | Not yet | ||
| API | Input | tblPR CostIndex | 8 | Not yet | ||
| API | Input | tblPRIS ExchRate | 8 | Not yet | ||
| API | Input | tblPR Levy* | 8 | Not yet | ||
| API | Input | tblPR CostCentreFleetCostSpread · tblPRIS ...CostSpread | 10 | Not yet | ||
| API | Input | frmInputFD_IndexAlloc | 6 | Not yet | ||
| API | Input | tblPR GeneralFunction | 12 | Not yet | ||
| API | Input | tblPR Product · ProductionFactor | 10 | Not yet | ||
| API | Input | frmFunctionBuilder · tblSysFunction | 12 | Not yet | ||
| API | Cost centre | tblPR CostCentre | 14 | Not yet | ||
| API | Cost centre | tblPR CostCentre* children | 14 | Not yet | ||
| API | Cost centre | frmInfrastructureCheckList | 4 | Not yet | ||
| API | Analysis | frmAn_Launcher | 16 | Not yet | ||
| API | Analysis | frmAn_Status | 10 | Not yet | ||
| API | Analysis | frmAn_Options | 4 | Not yet | ||
| API | Output | tblSysReport | 8 | Not yet | ||
| API | Output | frmRunReport | 24 | Not yet | ||
| API | Output | frmRunReport_Export · basFunction Excel | 12 | Not yet | ||
| API | System | various combo boxes | 6 | Not yet | ||
| API | System | frmSysDataMaintenance | 8 | Not yet | ||
| API | System | basFunction Attachment · Files | 8 | Not yet | ||
| API | Administrator | - (new in web) | 12 | Not yet | ||
| API | Administrator | - (new in web) | 12 | Not yet | ||
| API | Administrator | - (new in web) | 8 | Not yet | ||
| API | Administrator | - (new in web) | 8 | Not yet | ||
| API | Administrator | - (new in web) | 4 | Not yet | ||
| API | Administrator | - (new in web) | 12 | Not yet | ||
| Logic | Analysis engine | basAnalysis (3,846 lines) | 40 | Not yet | ||
| Logic | Analysis engine | qryAn Add New Period | 8 | Not yet | ||
| Logic | Analysis engine | qryAn Cost Index * | 12 | Not yet | ||
| Logic | Analysis engine | qryExchange Rate Schedule | 8 | Not yet | ||
| Logic | Analysis engine | qryAn CD Process Owned Already | 12 | Not yet | ||
| Logic | Analysis engine | qryAn CD Process Available New * (11 queries) | 40 | Not yet | ||
| Logic | Analysis engine | qryAn CD Process Available Used | 12 | Not yet | ||
| Logic | Analysis engine | qryAn CD SharedEquip * | 24 | Not yet | ||
| Logic | Analysis engine | qryAnUpd Equipment Utilisation · NumUnitsOperating | 16 | Not yet | ||
| Logic | Analysis engine | qryAnApp EmpReqd * (11 queries) | 40 | Not yet | ||
| Logic | Analysis engine | qryAnUpd Employee * | 24 | Not yet | ||
| Logic | Analysis engine | qryAn Cost Resource * · qryAnApp Calc CCFleetResourceConsumption | 24 | Not yet | ||
| Logic | Analysis engine | qryAn Cost Process Equipment * | 24 | Not yet | ||
| Logic | Analysis engine | qryAn Cost Process Equipment Replacement · Disposal | 24 | Not yet | ||
| Logic | Analysis engine | qryAn Cost Process Infrastructure * | 20 | Not yet | ||
| Logic | Analysis engine | tblPR Levy* | 12 | Not yet | ||
| Logic | Support | basFunction Builder and Equations (425 lines) | 32 | Not yet | ||
| Logic | Support | basFunction Project (910 lines) · qryCpy * | 32 | Not yet | ||
| Logic | Support | basFunction Calendar | 16 | Not yet | ||
| Logic | Support | basCostCentre Tree · List | 8 | Not yet | ||
| Logic | Support | basFunction Excel · Printing and Report · basReports | 16 | Not yet | ||
| Logic | Support | basLicense · basGeneral | 8 | Not yet | ||
| Logic | Support | sample project in MBS2018.accdb | 40 | Not yet | ||
| Logic | Security | - (new in web) | 24 | Not yet | ||
| Logic | Security | - (new in web) | 16 | Not yet | ||
| Logic | Security | - (new in web) | 16 | Not yet | ||
| DB | Setup | — | 16 | Not yet | ||
| DB | Setup | MBS2018_data.accdb | 32 | Not yet | ||
| DB | Master data | tbl Country | 1.5 | Not yet | ||
| DB | Master data | tbl EquipmentModel | 3 | Not yet | ||
| DB | Master data | tbl EquipmentModelCostComponent | 2 | Not yet | ||
| DB | Master data | tbl EquipmentModelSparePart | 2 | Not yet | ||
| DB | Master data | tbl Infrastructure | 1.5 | Not yet | ||
| DB | Master data | tbl ProjectCategory | 1.5 | Not yet | ||
| DB | Master data | tbl ProjectCategorySub | 1.5 | Not yet | ||
| DB | Master data | tbl RelPeriod | 1.5 | Not yet | ||
| DB | Project | tblP Project | 2 | Not yet | ||
| DB | Representation input | tblPR Constant | 1.5 | Not yet | ||
| DB | Representation input | tblPR CostCentre | 2 | Not yet | ||
| DB | Representation input | tblPR CostCentreEmployeeType | 1.5 | Not yet | ||
| DB | Representation input | tblPR CostCentreFleet | 1.5 | Not yet | ||
| DB | Representation input | tblPR CostCentreFleetCostSpread | 1.5 | Not yet | ||
| DB | Representation input | tblPR CostCentreInfrastructure | 1.5 | Not yet | ||
| DB | Representation input | tblPR CostCentreInfrastructureEmployee | 1.5 | Not yet | ||
| DB | Representation input | tblPR CostCentreInfrastructureResource | 1.5 | Not yet | ||
| DB | Representation input | tblPR CostCentreResource | 1.5 | Not yet | ||
| DB | Representation input | tblPR CostIndex | 1.5 | Not yet | ||
| DB | Representation input | tblPR EmployeeType | 1.5 | Not yet | ||
| DB | Representation input | tblPR EmployeeTypeRostered | 2 | Not yet | ||
| DB | Representation input | tblPR Fleet | 4 | Not yet | ||
| DB | Representation input | tblPR FleetCostComponent | 2 | Not yet | ||
| DB | Representation input | tblPR FleetOperator | 1.5 | Not yet | ||
| DB | Representation input | tblPR FleetResource | 1.5 | Not yet | ||
| DB | Representation input | tblPR FleetResource Scheduled | 1.5 | Not yet | ||
| DB | Representation input | tblPR FleetServicer | 1.5 | Not yet | ||
| DB | Representation input | tblPR FleetSparePart | 2 | Not yet | ||
| DB | Representation input | tblPR GeneralFunction | 1.5 | Not yet | ||
| DB | Representation input | tblPR Infrastructure | 2 | Not yet | ||
| DB | Representation input | tblPR InfrastructureCostComponent | 2 | Not yet | ||
| DB | Representation input | tblPR Levy | 1.5 | Not yet | ||
| DB | Representation input | tblPR LevyCategory | 1.5 | Not yet | ||
| DB | Representation input | tblPR Period | 2 | Not yet | ||
| DB | Representation input | tblPR Product | 1.5 | Not yet | ||
| DB | Representation input | tblPR ProductionFactor | 1.5 | Not yet | ||
| DB | Representation input | tblPR ProjectRepresentation | 11 | Not yet | ||
| DB | Representation input | tblPR Resource | 2 | Not yet | ||
| DB | Representation input | tblPR Roster | 2 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CommPacket | 2 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CommPacketPeriod | 1.5 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CostCentreEmployeeType | 2 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CostCentreFleet | 5.5 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CostCentreInfrastructureCostSpread | 2 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CostCentreInfrastructureEmployee | 2 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CostCentreInfrastructureResource | 2.5 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CostCentreResource | 2 | Not yet | ||
| DB | Analysis snapshot | tblPRIS CostIndexValue | 1.5 | Not yet | ||
| DB | Analysis snapshot | tblPRIS ExchRate | 1.5 | Not yet | ||
| DB | Analysis snapshot | tblPRIS GeneralFunction | 1.5 | Not yet | ||
| DB | Analysis snapshot | tblPRIS Product | 1.5 | Not yet | ||
| DB | Analysis snapshot | tblPRIS ProductionFactor | 1.5 | Not yet | ||
| DB | Analysis output | tblPROS CostCentreFleetResource | 2 | Not yet | ||
| DB | Analysis output | tblPRS EmployeeType | 3 | Not yet | ||
| DB | System | tblSysFunction (27 rows) | 2 | Not yet | ||
| DB | System | tblSysReport (81 rows) | 3 | Not yet | ||
| DB | Staging | tmpIn_PRIS * (14 tables) | 8 | Not yet | ||
| DB | Staging | tmpRpt * (8) · tmpGroup (1) | 4 | Not yet | ||
| DB | Administrator | - (new in web) | 3 | Not yet | ||
| DB | Administrator | - (new in web) | 1.5 | Not yet | ||
| DB | Administrator | - (new in web) | 3 | Not yet | ||
| DB | Administrator | - (new in web) | 1 | Not yet | ||
| DB | Administrator | - (new in web) | 2 | Not yet | ||
| DB | Administrator | - (new in web) | 4 | Not yet | ||
| DB | Administrator | - (new in web) | 1.5 | Not yet |
Showing 248 of 248 tasks · 2,237 h (279.6 MD)