Web migratuion task to creat a web page to replace Excel sheet.
- or -
Post a project like this1875
£500(approx. $628)
- Posted:
- Proposals: 8
- Remote
- #2315763
- OPPORTUNITY
- Awarded
Website Designer and Developer in PHP,Wordpress,Freekore Framework,Codingnigter,CSS,Jquery and Javascript
Chandigarh
AI & Data Science Engineer | Nodejs | Ruby On Rails | AWS | GCP | Python | React | Angular |
Auckland
2316133467392108868117506951914115194901021817362550635
Description
Experience Level: Expert
Some outlines for Web migration task
Main target: Move existing medium complexity Excel workbook to turn it to web-based application/system/database.
The existing workbook has numerous input fields:
1. Free text fields. They can be filled manually or via access to Trello cards (simply pulling the values to fill in the fields from the specified card).
2. Predetermined drop-down boxes.
The calculated fields are:
1. Pure mathematics, formulas, nested IFs, etc.
2. Lookup fields – linked to the data tables inside the workbook, VLOOKUP mostly, based on simple to moderate complexity rules
3. Web query fields to get the data from www.zoopla.co.uk, www.gov.uk, www.epcregister.com
The outputs are:
1. Calculated result based on the input fields
2. Various comments, recommendations, and warnings depending on the rules applied to the results.
Desired workflow:
The application must be multiuser, providing a secure login.
The two-level access – admin – full strength and regular user – access to front end and editing /reading certain databases.
Ability to organize / edit / enhance data in lookup tables (databases).
Ability to enter desired inputs, and get the calculated / web-requested fields filled in the same manner as Excel workbook does.
Save the result and all inputs as a separate record in a “Results” database.
Desired outputs:
Based on the selected record in “results” database, create Word or PDF file as per pre-determined template with the specific data.
Attach these files to input Trello card, or enhance Trello card with certain data. (optional)
Please find a PDF sample of the existing Excel sheet.
Main target: Move existing medium complexity Excel workbook to turn it to web-based application/system/database.
The existing workbook has numerous input fields:
1. Free text fields. They can be filled manually or via access to Trello cards (simply pulling the values to fill in the fields from the specified card).
2. Predetermined drop-down boxes.
The calculated fields are:
1. Pure mathematics, formulas, nested IFs, etc.
2. Lookup fields – linked to the data tables inside the workbook, VLOOKUP mostly, based on simple to moderate complexity rules
3. Web query fields to get the data from www.zoopla.co.uk, www.gov.uk, www.epcregister.com
The outputs are:
1. Calculated result based on the input fields
2. Various comments, recommendations, and warnings depending on the rules applied to the results.
Desired workflow:
The application must be multiuser, providing a secure login.
The two-level access – admin – full strength and regular user – access to front end and editing /reading certain databases.
Ability to organize / edit / enhance data in lookup tables (databases).
Ability to enter desired inputs, and get the calculated / web-requested fields filled in the same manner as Excel workbook does.
Save the result and all inputs as a separate record in a “Results” database.
Desired outputs:
Based on the selected record in “results” database, create Word or PDF file as per pre-determined template with the specific data.
Attach these files to input Trello card, or enhance Trello card with certain data. (optional)
Please find a PDF sample of the existing Excel sheet.
Dror A.
100% (83)Projects Completed
46
Freelancers worked with
40
Projects awarded
63%
Last project
8 Sep 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
pls share sample file of pdf.
774152
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies