The extension should have the capability to perform a simple math function and operations like percent calculation and adding of the results to the base of the calculation showing both value for the %.
Example: If there is a value of 1,000 in a field and the administrator inputs 25 in the % field, the table should do the calculation and shows 1,250 in the "results" field automatically.
- it should have the capacity to show the total of every column reflecting the changes.
- it should include fields to type down names, addresses, phone numbers, email addresses for every field.
- there would be several people accessing the site, and it's the idea every one has access to his/her page with information about each one. But only the administrator would have access to a general page where the total of transactions would be shown.
- When the administrator inputs the changes on the main area, those changes should be done, automatically, in every one's table in every one's page.
So far, though, there would be the following columns in the main area, let's call it Administrator Area.
a-Name, Phone, email address
b- Amount received (principal)
d -Amount plus interest
When the administrator inputs on the field "interest' (%) a figure, the table should be able to make the calculation of the principal plus the % and shows the total on " Amount plus %".
When the administrator registers a withdraw, the total must show the new total and the next % imputed by the administrator and result on Total
Deposit $100 Balance $100 Interest 20 % $20.00 Total $120.00
Withdraw -$ 50 Balance $ 70 Interest 25% $17.50 Total $87.50
No D/W Balance $87.50 Interest 21% $18.35 Total $105.85
Deposit $200 Balance $305.85 Interest 23% $70.34 Total $376.20
and so on.
This is the table in the Administrator area where the figures for every one are inputed and would be the individual table in everybody's page automatically once done in this Administrator Area. This way the administrator doesn't need to type down twice the data.
The admin would be possible to work with all the names at the same time.