Timeline for Work Completion
-
I am building a system in asp.net C# with an Sql Server DB. I have split the work into separate tasks. I have put a timeline of around 41 days. The requirements are as below. Can anyone say how long it would take and if my timeline is too long? 1. Requirements Gathering and Associated Documentation - Requirements Specification/Functional Specification and Agreement with Stakeholder(s)/Users - 4 days 2 Create DB and Tables and 4 tables - 4 days 3 Create Login Form - 2 days 4 Create Menu - 2 days 5 Create Initial Input Form - containing all the fields that need to be recorded inititally and the 2 calculated fields - 5 days 6 Create “Update Single File” form - Allow user to update this file and write it back to the table in the DB - 3 days 7 Create “Update Multiple Files” form - Display multiple files maybe based criteria selected from dropdown and allow user to possibly do a bulk update of the records - 4 days 8 Create “Add Staff” form and have it writing to the Staff table - 2 days 9 Create “LogOut” form - 1 day 10 Create “Reports”. This would involve creating reports that would have the Grouping of the data in the various different scenarios e.g. Total for Invoice, Total for Trans Number. A report for Audit trail may be needed also. These reports may need to be created in SSRS reporting. - 5 days 11 Audit Trail - Create a record in the audit table each time a record has been updated. Maybe display this audit trail in the “Update Single File” form - 3 days 12 Create Stored Procedures in DB to carry out the above functions - 3 days 13 Carry out functional reviews with Stakeholder(s)/Users - 1 day 14 Carry out Unit testing - 1 day 15 UAT with Stakeholder(s)/Users and Sign Off of System - 1 day
-
I am building a system in asp.net C# with an Sql Server DB. I have split the work into separate tasks. I have put a timeline of around 41 days. The requirements are as below. Can anyone say how long it would take and if my timeline is too long? 1. Requirements Gathering and Associated Documentation - Requirements Specification/Functional Specification and Agreement with Stakeholder(s)/Users - 4 days 2 Create DB and Tables and 4 tables - 4 days 3 Create Login Form - 2 days 4 Create Menu - 2 days 5 Create Initial Input Form - containing all the fields that need to be recorded inititally and the 2 calculated fields - 5 days 6 Create “Update Single File” form - Allow user to update this file and write it back to the table in the DB - 3 days 7 Create “Update Multiple Files” form - Display multiple files maybe based criteria selected from dropdown and allow user to possibly do a bulk update of the records - 4 days 8 Create “Add Staff” form and have it writing to the Staff table - 2 days 9 Create “LogOut” form - 1 day 10 Create “Reports”. This would involve creating reports that would have the Grouping of the data in the various different scenarios e.g. Total for Invoice, Total for Trans Number. A report for Audit trail may be needed also. These reports may need to be created in SSRS reporting. - 5 days 11 Audit Trail - Create a record in the audit table each time a record has been updated. Maybe display this audit trail in the “Update Single File” form - 3 days 12 Create Stored Procedures in DB to carry out the above functions - 3 days 13 Carry out functional reviews with Stakeholder(s)/Users - 1 day 14 Carry out Unit testing - 1 day 15 UAT with Stakeholder(s)/Users and Sign Off of System - 1 day
That really is like asking "how long is a piece of string?" :-D Only you will know if you can actually achieve this timeline. Some observations from my own experiences though Step 1 - if you get "awkward" stakeholders this step could well take longer than 4 days (actual time spent or elapsed!) Step 2 - seems a little long as you appear to already have an idea of the tables required - if you're including all of the admin hoops to jump through with DBA's or other control mechanisms I would make it clear in the estimate Step 14 - seems a bit light, but some of the builds do seem a bit long. Step 15 - see my earlier comments about stakeholders! I've never run UAT in less than 3 days (and even that was a struggle) If this timeline is going out to the stakeholders double everything and make it clear whether or not this is a "working days elapsed" timeline or a "working hours spent" Under promise and over deliver ;)