Excel workbook development
- or -
Post a project like this$$
- Posted:
- Proposals: 0
- Remote
- #3857
- Expired
Description
Experience Level: Intermediate
We have developed a multiple sheet excel workbook (60 sheets, 20 macros) that we use to record, organise and value a large number of financial derivatives against a real-time price input.
Each sheet contains a number of calculations and there are several cross-sheet references and calculations. Real-time market data is fed into the workbook via a DDE link from another application and this updates all the figures and calculations in real time accross the workbook.
There are two elements to this project:
Firstly, this workbook in its present form has become rather large and uses a lot of the computer's resources to run. Whilst none of the worksheets or macros are expendable, the workbook could possibly benefit from more efficient sheet and macro code so that it runs more efficiently.
Secondly, we need to develop a method whereby this single workbook can be opened, viewed, modified and saved by a number of users on different workstations accross a network. We currently have 4 employees using the system, each on their own workstation, and each employee must input the relevant data onto their own system. In other words, we want to share the workbook accross the network so that changes made on one workstation are reflected on all other workstations in real-time.
If you feel you are able to help in either of these regards then I would invite you to call me (01702 608 514) to obtain further details about the project.
Remuneration is negotiable upon proposal and will be very well priced for a suitable solution to our problem.
Each sheet contains a number of calculations and there are several cross-sheet references and calculations. Real-time market data is fed into the workbook via a DDE link from another application and this updates all the figures and calculations in real time accross the workbook.
There are two elements to this project:
Firstly, this workbook in its present form has become rather large and uses a lot of the computer's resources to run. Whilst none of the worksheets or macros are expendable, the workbook could possibly benefit from more efficient sheet and macro code so that it runs more efficiently.
Secondly, we need to develop a method whereby this single workbook can be opened, viewed, modified and saved by a number of users on different workstations accross a network. We currently have 4 employees using the system, each on their own workstation, and each employee must input the relevant data onto their own system. In other words, we want to share the workbook accross the network so that changes made on one workstation are reflected on all other workstations in real-time.
If you feel you are able to help in either of these regards then I would invite you to call me (01702 608 514) to obtain further details about the project.
Remuneration is negotiable upon proposal and will be very well priced for a suitable solution to our problem.
David S.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
8 May 2024
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