Data entry and Database using Excel
Budget: €250 – €750 EUR
Data entry and Database using Excel
Hi,
We have a project for a non-profit organization (NGO) with the following scope of work and has to be completed within 2 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 and for read only
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 and database formats except one section. This section is the strategic performance section where it have different data entry and database structures so, it needs a separate database. Moreover, Organization card shall read from two different bases (two sections database files) also it will be connected to PI dashboard.
7- We need to run the database files on a daily basis where it will be connected to PI dashboard.
8- Files hosting: it will be under a drop box folder and using MS SQL server.
9- under drop box folder: each section has its own folder including its end users database files so, eventually will have four folders under drop box. the fifth folder for the Organization card where it has no data entry tab and just reading from two different bases.
10- I have used few macros via internet and can be found in macros
11- 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.
12- We needed to enable the end user to search and retrieve task information for modification purpose and/or read purposes.
13- We need to create an admin screen to enable end-user privileges in terms of who is allowed to delete, Modify, etc. along with security settings and assigning responsibilities to the end user. All the sections heads will have the option to delete the tasks along with the admin and we need to enable the admin to run the
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- We need to avoid file slowness in the long term usage.
18- to avoid human errors, the end user name will be read via application. user name
19- 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
20- if the above requirements can be designed differently than the existing solution so, feel free to recommend it.
Regards,
Data Entry, Database Development, Database Programming, Excel, Microsoft Access
30USD - 250USD
Hi,
We have a project for a non-profit organization (NGO) with the following scope of work and has to be completed within 2 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 and for read only
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 and database formats except one section. This section is the strategic performance section where it have different data entry and database structures so, it needs a separate database. Moreover, Organization card shall read from two different bases (two sections database files) also it will be connected to PI dashboard.
7- We need to run the database files on a daily basis where it will be connected to PI dashboard.
8- Files hosting: it will be under a drop box folder and using MS SQL server.
9- under drop box folder: each section has its own folder including its end users database files so, eventually will have four folders under drop box. the fifth folder for the Organization card where it has no data entry tab and just reading from two different bases.
10- I have used few macros via internet and can be found in macros
11- 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.
12- We needed to enable the end user to search and retrieve task information for modification purpose and/or read purposes.
13- We need to create an admin screen to enable end-user privileges in terms of who is allowed to delete, Modify, etc. along with security settings and assigning responsibilities to the end user. All the sections heads will have the option to delete the tasks along with the admin and we need to enable the admin to run the
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- We need to avoid file slowness in the long term usage.
18- to avoid human errors, the end user name will be read via application. user name
19- 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
20- if the above requirements can be designed differently than the existing solution so, feel free to recommend it.
Regards,
Data Entry, Database Development, Database Programming, Excel, Microsoft Access
30USD - 250USD