Custom automated Excel (VBA, macros) + MySQL or Google Sheets/Apps template
- or -
Post a project like this2605
$$$
- Posted:
- Proposals: 8
- Remote
- #1467379
- Awarded
PPH #1 Service Provider in Development & IT : Wordpress|Magento|React Native|Mobile App Development|Angular|Node.js
Mohali
✪Software Developer ✪Web Developer (Java,Python, Android, jee, JSP, JSF, Java Fx,Vue, Blue J, Nuxt) ✪ Processing ✪ Elastic Search ✪ Database
Saitama
96345112834234152212441651542598154263515452481563213
Description
Experience Level: Expert
Estimated project duration: less than 1 week
General information for the business: We are looking to build a custom job costing and resourcing solution using either a) excel and MySQL or Google Sheets
Database management system (DBMS): MySQL
Description of requirements/functionality: I would like to build a template for costing jobs based on time/resources inputs.
The templates would be used by different team members for different projects.
The templates must be kept 'up to date' with key resource information (people, rates, master list of clients and projects) and in turn each template must feed into a master database which enables a view of all committed resources.
Must also be able to export the database to a specific format for ease of input into a separate project management platform.
Attached is a detailed scope and schematic, we have also produced a working prototype of the core excel template sheet which can be supplied to suitable interested parties.
Specific technologies required: Excel, VBA, MySQL, Google Sheets
Extra notes: Scope document attached. Prototype Excel sheet available on request.
Database management system (DBMS): MySQL
Description of requirements/functionality: I would like to build a template for costing jobs based on time/resources inputs.
The templates would be used by different team members for different projects.
The templates must be kept 'up to date' with key resource information (people, rates, master list of clients and projects) and in turn each template must feed into a master database which enables a view of all committed resources.
Must also be able to export the database to a specific format for ease of input into a separate project management platform.
Attached is a detailed scope and schematic, we have also produced a working prototype of the core excel template sheet which can be supplied to suitable interested parties.
Specific technologies required: Excel, VBA, MySQL, Google Sheets
Extra notes: Scope document attached. Prototype Excel sheet available on request.
Tom J.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
13%
Last project
25 Jan 2016
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