Excel workbook development

  • Posted
  • Proposals 1
  • Remote
  • #3857
  • Expired
Mark F. has already sent a proposal.
  • 4

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.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board

    There are no clarification messages.