Excel Data Gathering and Reporting

Completed Posted Jul 17, 2008 Paid on delivery
Completed Paid on delivery

This is an excel-based VBA project for Excel 2003. The purpose is to automate the data entry and validation of personal financial information into a series of worksheets in an existing Excel template spreadsheet. Once the data has been collected a series of graphs should be updated so a final report can be produced from Excel.

The data to be collected includes a page of basic demographic data (name, address, age, spouse, ...) and then several worksheets for financial data (stock holdings, insurance policies, mutual funds, retirements plans, etc. - each on a separate worksheet with their own fields & requirements).

The process is not very complicated but does require someone with good attention to detail. It is tedius information to capture and must be captured accurately. The VBA application should lauch a "wizard-type" interface that will walk the user through the entry of this information. So, they launch the process to start, enter their demographic data and are then prompted for what types of investments they have (stocks, bonds, mutual funds, ...). Once they pick a type, they should be taken to a screen to enter that type of information. Once they go through all the types, they are finished.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Friday Jul 18, 2008 11:13:36 AM:

Thank you for your interest in this project. I have uploaded a sample spreadsheet with a supporting document attempting to address most of your questions. Please download this file and read through it to be sure the requirements are clear. In addition, I will be available in the chat room for this Bid on Wednesday 7/23 at 11am EST to address any further questions you may have. We are planning on making a decision and awarding the project on Friday, Aug 1. Thanks again for your interest.

* * *This broadcast message was sent to all bidders on Monday Aug 11, 2008 8:34:07 AM:

Due to the number of bids received being higher than expected and an unplanned business trip, I have extended this bid until 8/15. We are reviewing bids this week and hope to contact potential winners within the next day or two. Thank you for your patience.

## Platform

Window XP, Vista

PHP

Project ID: #3062748

About the project

54 proposals Remote project Active Aug 21, 2008

Awarded to:

borolas01

See private message.

$85 USD in 14 days
(47 Reviews)
4.5

54 freelancers are bidding on average $723 for this job

TheoYZ

See private message.

$850 USD in 14 days
(164 Reviews)
7.6
schandraram

See private message.

$935 USD in 14 days
(168 Reviews)
6.9
shikhamehta

See private message.

$680 USD in 14 days
(213 Reviews)
6.8
renardpaul

See private message.

$425 USD in 14 days
(106 Reviews)
6.5
rajamanickam1000

See private message.

$425 USD in 14 days
(79 Reviews)
5.9
jkmcoders

See private message.

$1105 USD in 14 days
(13 Reviews)
5.8
tusharjohri

See private message.

$425.01 USD in 14 days
(83 Reviews)
5.6
aroy1968

See private message.

$850 USD in 14 days
(14 Reviews)
5.3
azrajobs

See private message.

$1275 USD in 14 days
(59 Reviews)
5.3
ricks7

See private message.

$1062.5 USD in 14 days
(94 Reviews)
5.2
vw6947279vw

See private message.

$467.5 USD in 14 days
(20 Reviews)
5.0
pmferreira

See private message.

$765 USD in 14 days
(49 Reviews)
5.0
excelsolution

See private message.

$722.5 USD in 14 days
(64 Reviews)
4.8
adeeylx

See private message.

$1275 USD in 14 days
(12 Reviews)
4.7
techism

See private message.

$425 USD in 14 days
(43 Reviews)
4.6
alexitkin

See private message.

$850 USD in 14 days
(30 Reviews)
4.6
ioanaprof

See private message.

$637.5 USD in 14 days
(27 Reviews)
4.3
abcdefghivw

See private message.

$1020 USD in 14 days
(6 Reviews)
4.3
advbcode

See private message.

$425 USD in 14 days
(16 Reviews)
4.2
ufologo22

See private message.

$425 USD in 14 days
(18 Reviews)
4.2