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
Project Budget
$30 - $250 USD
Total Bids
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.

Skills Required

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