Project: Retirement Calculator in PHP ID: 1210611998

Status:	Closed (Cancelled)
Budget:	$100-300
Created:	5/12/2008 at 13:06 EST
Cancelled:	5/24/2008 at 0:26 EST
Project Creator:	carrierdesign Rating: (1 review)
Description:	NEED BY TUESDAY (5/13) NIGHT (cst time)! (perhaps later if this is impossible) I need an online retirement calculator in PHP. In a nutshell, the calculator will collect data, record it to a MySQL database and make some calculations based on the data. The calculations will actually be MUCH less than typical retirement calcs and there's no need to display any year-by-year spending results or other data (at this time). Generally, the calc should determine the TOTAL amount of money needed to support retirement (+ a fudge of 20%) vs. the total amount anticipated to be available based on applicant's current saving, etc. Once I have those two numbers, I'll set up a score of sorts. Please see my note about adapting an existing open source script below: (http://www.hotscripts.com/Detailed/57263.html) Here's the process: 1. Form Fields: (as found at www.yourcircleofwealth.com/rron (which is roughly how form should appear) First Name ($firstname) Last Name ($lastname) Email Address ($email) Phone Number ($phone) Extension ($extension) *no error checking* Pass Code ($passcode) Resident Zip Code ($zipcode) Current Age Age you wish to retire Life Expectancy Current Income Current Savings Balance Current Annual Savings for Retirement Increase Savings to account for inflation (Y/N) Avg Rate of return UP TO retirement Avg Rate of return DURING retirement Avg Rate of inflation Annual retirement income from other sources What age does this start? Annual yearly increase in % of this income? Amount of expected future retirement assets? When will said assets be received? Do you wish to increase income to account for inflation? (Y/N) 2. Error Checking and Pass Code checking (use PHP error checking or javascript alerts) + All form fields except extension should be checked for existence + Numeric form fields (excluding phone & ext) should be checked as numbers + Pass Code needs to be checked against validity in MySQL DB using the following code: ************CODE STARTS***************** $table_name ="advisor_pass"; mysql_connect(localhost,$username,$password); <AT SIGN>mysql_select_db($database) or die( "Unable to find Retire Wealthy ADVISOR database."); // Check for existance of passcode $count = mysql_num_rows(mysql_query("SELECT * FROM $table_name WHERE passcode = '$passcode'")); if ($count == 1) { $query="SELECT * FROM $table_name WHERE passcode = '$passcode'"; $result = mysql_query($query) or die('Error, query failed'); //get results associated with that Pass Code, assign variables while ($row =mysql_fetch_array($result)){ $advisorID= $row['ID']; $advisorNAME= $row['name'];} } else {ERROR MESSAGE HERE} *************END OF CODE************** 3. Process Data Unfortunately, I don't have the formula. If you examine the form at http://www.yourcircleofwealth.com/rron/ there are detailed explanations of how each number is applied -- however the form does NOT generate detailed results. Also there are dozens of financial calcs on the net. I'm actually somewhat flexible on the fields/formula. A good guide for this is in the FREE script: http://www.hotscripts.com/Detailed/57263.html IF YOU CAN ADAPT THIS SCRIPT ALL THE BETTER. The problem with this script is that it doesn't currently account for current savings and yearly savings. It generates the money needed but doesn't figure out what the applicant is currently savings. We need to figure out if they will meet their goal or will need help. 4. Leave me clean variables so I can record A) the applicant's original form field entries in a MySQL DB, B) the money they will have based on their current savings (one variable) and C) the money they need to have (+ 20%) (one variable). D) I'll write a formula to compare the two and generate a score. *********************************************** Some NOTES: 1. It's quite possible the script will have to be adjusted or slightly altered after completion. Work minor adjustments into your price. Major ones we can negotiate. 2. I'm not supplying the formula but will continue to look. If you find a DIFFERENT but similar formula (asking for different but similar form fields) I will strongly consider it. Time is of the essence. 3. I'm attaching my adaptation of the free script mentioned. This was going to work for me until I realized that it did not account for retirement savings (duh). Also, I don't need the detailed printout at the end, and the whole emphasis on reduced income needed for retirement is not necessary. 4. I'm okay at PHP but I will need some explanations. The important things is that I have easy access to variables for placement into a DB. 5. Links to similar scripts you've done are appreciated. If you've done a Retirement Calc for someone else with different fields, I'm willing to consider it. Additional Info (Added 5/12/2008 at 15:46 EST)... I am likely extending the Tuesday night deadline as it's not reasonable for my budget. I'm able to adapt the sample script for my short term needs (site demonstration) but will need the script as described. Therefore there is no specific deadline at this time and I will consider bids for a longer period. Thanks.
Job Type:	PHP MySQL CSS

Messages Posted: 7

Programmers	Bid	Delivery Within	Time of Bid	Rating
greentech12	$210	3 days	5/14/2008 at 12:21 EST	(44 reviews)
Think Done!!!
netlog	$210	5 days	5/14/2008 at 12:15 EST	(10 reviews)
can do it.
inoday	$250	5 days	5/13/2008 at 16:02 EST	(1 review)
We are medium size company with head counts of 40-45, mainly located in India,Greece,USA. Right now we are providing services in more than 30 countries. As we are growing now and we would like to increase our business relationship boundaries, I would like to give service for your proposal. I will not take much time of yours. In case if you are interested to talk for further, Please feel free to contact us. Thank you and regards,
coderextraordinaire	$285	5 days	5/13/2008 at 10:31 EST	(129 reviews)
pls chk pmb
danhilliard	$300	20 days	5/13/2008 at 19:42 EST	(9 reviews)
I can complete your project for you with no problem. Complete php mySQL, form field error checking. Database structure, secure login, password encryption. All the fearues you are looking for. I can complete the total project. Long term realtionship is idea.
fastprogrammer	$380	7 days	5/13/2008 at 1:15 EST	(45 reviews)
pls check pmb. thx
suryadream	$450	1 day	5/12/2008 at 23:55 EST	(4 reviews)
I have gone through the details as well as have completely understood the scope of the work. I am very much interested and love to work on the project and are ready to get started with the work at the earliest. Kindly have a look into your PMB for more details. Warm Regards $urya
skiv	$500	5 days	5/15/2008 at 3:23 EST	(504 reviews)
Hello! We're ready to get started and help you with your project. Well commented code - guaranteed. Thank you in advance and we look forward to working with you very soon. Best regards, skiv
agentjax	$513	1 day	5/12/2008 at 14:11 EST	(93 reviews)
Please check the PMB.