Custom Calculator
Applications

REALTOR SOFTWARE

Examples

realtor software
realtor program
currency exchange calculator
currency exchange converter

The above screen shows the programming for the custom calculator for the Real Estate Example.  Note that there are 9 lines - a1 through a9 are the nine inputs and b1 through b9 are the 9 nine outputs.  The data is input on the left (A1 through a9 - as needed) and the outputs will be on the right.  Similarly, the formulas entered work left to right.  Some comments on the formulas by line:

• line 1 - the "z" in the formula just means to ignore the input for this line.  Since there is no additional formula here in this line beyond the "z" then that will cause a "0" in the output of line 1 (b1)

• line 2 - in this case we ask the person to enter the remaining mortgage.  Since we are going to subtract this number the sales price of the house, what we do is first use an "m" to make the value minus.  Then we add that value to a1 using the "+a1) in the formula.  Since the remaining mortgage is now a minus number, this will have the same effect as subtracting the remaining mortgage from the Sales Price.

• line 3.  Since we allow the user to enter a percentage instead of a decimal, the first thing that we do is to divide the number entered by 100 to get a decimal value.  That is the "/100" portion of the formula.  We then multiply this line by the Sales price of the house, which is the part of the formula "*a1" where the "*" (as well as "x") means multiply, and a1 is the input that now contains the value of the house.

• Lines 4 and 5 - similar to the logic in line 3

• line 6 - for total closing costs, we add the number that the user enters for "$ more closing costs" to the $ closing costs from a % (b5) to the $ Sales Commission (b3) to the $ Buy commission (b4) to arrive at a total, which is output that line at b6

• for line 7, again no input is needed.  So, to be safe we begin that line again with a "z" such that it will ignore any input at a7.  Then we simply take the overall proceeds- which were output on line 2 (b2) and subtract total closing costs from line 6 (b6) to arrive at the customer proceed output in line 7 (b7).

Note that whenever we use a value from another line, we ensure that that line is higher on the screen.  That is because once we enter the data on the left side as needed and click "Calculate All" on the main screen, that the calculations are done top to bottom.  So, the lower calculations can reference ones higher than them - only.

Much power - and remember - this is only one of the 5 calculators included with this software.  The mortgage / load calculator with its amortization schedule should be very handy also in the Real Estate Business.

Readme.txt and help included.

Links:  main convert program page             main page rpsoft 2000 software