Data entry and database
Budget: $15 – $25 USD
We have a project for a non-profit organization (NGO) with the following scope of work and has to be completed within 3 days max:
1- We have four different sections along with organization card file
2- each section has several numbers of end users
3- each end user has her/his own database where it can be accessed by the end user except the admin or who has such a privilege via admin
4- Each section has its own database which contains all the end users database files in one tab and the same for the rest of the sections
5- the four sections database files will be consolidated in one master database file in which contains the whole database files for four sections in one tab.
6- we have three sections have similar data entry format except one one section
7- We need to run the database files on a daily basis
8- Files hosting: it will be under a dropbox folder
9- under dropbox folder: each section has its own folder including its end users database files so, eventually will have four folders under dropbox.
10- I have used few macros via internet and can be found in macros
11- There is a slowness in some files
12- I got an issue in ordering the serial number where it happened while trying to delete one row and when I added another row with a new task via data entry form.
13- We needed to enable the end user to search via task name for retrieving the task info or any other easy option. As well as,
14- if the end user chooses to delete the task then the whole task info shall be shown on the data entry form then the end user will make sure that he/she chooses the right task to delete or to modify.
15- few constraints shall be applied:
- All dates have to be in dd-mmm-yy format
- All the dates entry shall not be a weekend and/or public holidays (there is a list of public holidays in the form tab and the weekend will Friday and Saturday)
- baseline finish date shouldn't be less than the baseline start date and the same for the actual finish date
- there is one section "Establishment" will have an SLA based on the main task selected (i.e. NGO establishment study and support request)
Note: the equation is available in the establishment file in cell (XDP4) )
16- We need to improve the look and feel for the whole data entry tab.
17- the whole data will be linked to PI for dashboard purposes.
18- We need to avoid file slowness in the long term usage so we will make sure that the files will not be corrupted when the excel files reach more than 7 Mb.
19- We need to create an admin screen to enable end-user privileges in terms of who is allowed to delete any task.
20- to avoid human errors, the end user name will be read via application. user name
21- In case of a potential change in column headers or updating any equation or changing/deleting any data entry filed then we need a one source for populating these changes for the whole end users per section
22- if the above requirements can be designed differently than the existing solution so, feel free to recommend it
23- the existing organization names shall be shown as a drop down list for all end users
Please note that I have attached a sample file with dummy data for the "Establishment Section '' and data mapping file so, if you're interested then appreciate your feedback on the price and time required.
For communication purposes, I have webex, MS team, zoom and hangouts apps.
1- We have four different sections along with organization card file
2- each section has several numbers of end users
3- each end user has her/his own database where it can be accessed by the end user except the admin or who has such a privilege via admin
4- Each section has its own database which contains all the end users database files in one tab and the same for the rest of the sections
5- the four sections database files will be consolidated in one master database file in which contains the whole database files for four sections in one tab.
6- we have three sections have similar data entry format except one one section
7- We need to run the database files on a daily basis
8- Files hosting: it will be under a dropbox folder
9- under dropbox folder: each section has its own folder including its end users database files so, eventually will have four folders under dropbox.
10- I have used few macros via internet and can be found in macros
11- There is a slowness in some files
12- I got an issue in ordering the serial number where it happened while trying to delete one row and when I added another row with a new task via data entry form.
13- We needed to enable the end user to search via task name for retrieving the task info or any other easy option. As well as,
14- if the end user chooses to delete the task then the whole task info shall be shown on the data entry form then the end user will make sure that he/she chooses the right task to delete or to modify.
15- few constraints shall be applied:
- All dates have to be in dd-mmm-yy format
- All the dates entry shall not be a weekend and/or public holidays (there is a list of public holidays in the form tab and the weekend will Friday and Saturday)
- baseline finish date shouldn't be less than the baseline start date and the same for the actual finish date
- there is one section "Establishment" will have an SLA based on the main task selected (i.e. NGO establishment study and support request)
Note: the equation is available in the establishment file in cell (XDP4) )
16- We need to improve the look and feel for the whole data entry tab.
17- the whole data will be linked to PI for dashboard purposes.
18- We need to avoid file slowness in the long term usage so we will make sure that the files will not be corrupted when the excel files reach more than 7 Mb.
19- We need to create an admin screen to enable end-user privileges in terms of who is allowed to delete any task.
20- to avoid human errors, the end user name will be read via application. user name
21- In case of a potential change in column headers or updating any equation or changing/deleting any data entry filed then we need a one source for populating these changes for the whole end users per section
22- if the above requirements can be designed differently than the existing solution so, feel free to recommend it
23- the existing organization names shall be shown as a drop down list for all end users
Please note that I have attached a sample file with dummy data for the "Establishment Section '' and data mapping file so, if you're interested then appreciate your feedback on the price and time required.
For communication purposes, I have webex, MS team, zoom and hangouts apps.