web interface
$500-5000 USD
Paid on delivery
I need to develop a website containing an online interface into which I will upload data from an Excel spreadsheet. Based upon pre-selected criteria, formulas in the interface will present the user with customized? documents that can be printed in batches directly from the site.
## Deliverables
The interface will have to be very interactive. Based upon the information supplied from the database, users will see letters that are "due" to be sent and will select them from a list, then be able to print from a side menu. They should also be able to sort the list of data (as seen in the example below).
Following is an example of two datasets from an interface. The red data would be drawn from the database, the black would be standard in the interface and interactive with the user. The circles next to "letters" would be? checked to select to print.?
company? ? ? ? abr? ? ? number? ? ? price? ? ? state? ? ? agent? ? ? ? trusted
AT&T? ? ? ? ? ? ? ? ? ? ? T? ? ? ? ? ? ? 1234? ? ? ? ? ? ? ? $5? ? ? ? ? ? ? NY? ? ? ? ? ? ? Smith? ? ? ? ? ? Y
? ? ? ? archive actions
**[expands]**
? ? ? ? ? ? ? ? ? ? ? ? ISSUED
: 4/7/04 TYPE: simple Due: 11/1/07 Expected amt: $28,456
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? RECEIVED? ____Y______ DATE: 11/1/07 [checking received will auto-fill date and cross off all unchecked letters
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o letter 1- 5/1/07 [checking one circle will set the document for printing]
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o <strike>letter 2</strike> ______
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o <strike>letter 3</strike>_____
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o <strike>letter 4</strike>_____
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o <strike>letter 5</strike>_____
* current actions [expands]
Metlife? ? ? ? ? ? ? MET? ? ? ? ? 5678? ? ? ? ? $6? ? ? ? ? PA? ? ? ? ? Jones? ? ? ? ? N
archive actions [expands]
current actions [expands]
ISSUED: 1/5/05 TYPE: complex DUE: 11/1/07 Expected amt: 3400 shares
RECEIVED? __________ DATE: __________
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o letter 1- 5/1/07
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o letter 2 -11/2/07
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o letter 3 - 1/2/08
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o letter 4
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? o letter 5
The site will ultimately (in a different phase of the project) allow subscription users? and will contain the appropriate amount of security to secure the data. So it must be able to add-on those additions.
Project ID: #3858718