Web migratuion task to creat a web page to replace Excel sheet.
- or -
Post a project like this1981
£154(approx. $192)
- Posted:
- Proposals: 13
- Remote
- #2177164
- Awarded
Product Manager with extensive web , seo and mobile development experience.
Islamabad
PPH #1 Service Provider in Development & IT : Wordpress|Magento|React Native|Mobile App Development|Angular|Node.js
Mohali
Top rated PHP Web Development | WordPress | Magento | Drupal | OpenCart | PrestaShop | Joomla
Leicester
AI & Data Science Engineer | Nodejs | Ruby On Rails | AWS | GCP | Python | React | Angular |
Auckland
WordPress, shopify, WIX, Laravel, php,Flutter, react js, Java, magento, software development, App designing, graphic designing, logo designing
Islamabad
1444178360112834225640972604882903410507541088681195110520940402175080
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.
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
-
There are no clarification messages.
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