Closed

Build Table/Database with mathematical functions

This project received 2 bids from talented freelancers with an average bid price of $45 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
2
Project Description

Design a table or a database:

1- Begin operation
2- Accept input of a real, positive number, D1
3- Register time of D1 receipt, T1
4- Assign D1 a unique record identifier, ID1
5- Compare D1 to a preset constant, A
6- Register the numeric difference between A and D1 (positive or negative), Call it C1
7- Create a record (row) for ID1, T1, D1, and C1, call this record n=1
8- Accept input of another real, positive number, D2
9- Register time of D2 receipt, T2
10- Assign a unique record identifier, ID2
11- Compare D2 to a preset constant, A
12- Register the numeric difference between A and D2 (positive or negative), Call it C2
13- Create a record (row) for ID2, T2, D3, and C3, call this record n=2
14- Create a field (column) for rank, R.
15- Sort table by Descending value of D’s,
16- In the rank field, R, number each row starting with 1, so that row1, R1, has the largest D value, row 2, R2, has the secong highest D value, and so on.
17- Create a field (column) for the cumulative sum of C’s (∑Cn , where n= 1 to n)
18- Accept next input, D3 and repeat above steps until:
19- Stop accepting input when
a. preset time, T, expires, or
b. when n› N (N preset constant integer) for all records where ∑Cn-1 ›Cn
20- Close operation.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online