Apps for Samsung Android phone to enter Data and plot trendline graph, Re-post 28th March '13 by xumingle

Earn $6 SGD by getting xumingle to upgrade to the Design Studio The Design Studio is a feature that helps xumingle easily review your designs and provide feedback. You will earn $6 SGD if the employer upgrades their project to a Design Studio! Learn more Bid on This Project Apps for Samsung Android phone to enter Data and plot trendline graph, Re-post 28th March '13 OPEN Bids 2 Avg Bid (SGD) $643 Project Budget (SGD) $250 - $750 Freelancers must sign a Non-Disclosure Agreement before placing a bid on this project. You have agreed to and signed the Non-Disclosure Agreement. Project Description:
Android App for Data Entry and Trendlines Graph Output.

Project Introduction:
Screen Page 1 - Data Entry Page (DEP)

Illustration:
The picture of above is what it looks likhone for Data Entry into Column A.
It is use on Polaris Office of the phone.
The keypad is standard keypad of Samsung.
Should be a customised number pad for Data Entry as illustrated in the picture below.

On the left picture is Data Entry Page (DEP).
It comprises of Spreadsheet and Number Pad Section.Spreadsheet Section is a layout of with all the Columns as in the Spreadsheet Roulette2202Fri#1.xlsx.
Number Keypad Section is a Number Pad (NOT the Standard Samsung Keypad with alphabets).
The Number Pad is fixed at the Lower Section as the "spreadsheet" scrolls up when more rows of data are entered.
Top of Page, is the Bar menu with 4 buttons, for navigation to the 3 Trendlines Graph plotted and "Save" button.
When "Save", a dialogue box should be available for target Folder selection.
"Save" function should be available for Data and Trendlines Graph.
When Apps is Open, there should be choice to Retrive data or New for new entry.

Spreadsheet Section:
Column A is for Data Entry. It allows up to 300 - 500 lines of entries.
Numbers are of Roulette game which range from 0-36.
Column A is "Freeze" on the left side of screen.
Top Row of Column description should "stay" as the spreadsheet is touch and move by the 4-directional movements. (Like the same of Spreasheet)
Upon enter of a number, hit "return", the cursor should go to the next line for another entry.
As the Row of data entry increase, the spreadsheet should scroll up automatically.

In the Spreadsheet Section, it comprises of 3 Section lengthwise:
- Red/Black Section,
-Even/Odd Section
-Big/Small Section
The Apps should only display these 3 sections.
Formulas working on the right should not be displayed.

Each Section has 9 Columns - Red, Black, 1xSwitch, 2xSwitch, 3xSwitch, BBL, FTL, All Red, All Black.
The Column is abbreviated with 3 alphabets so the Column Fit shall be tight and neat.
(For Even/Odd Section- it is All Even & All Odd)
(For Big/Small Section - it is All Big/ All Small).
Sections and Columns should have colour theme for easy viewing.
When a number is enter in Column A, all the values in all columns are updated by the formula that were already embedded in Roulette2202Fri#1 spreadsheet.

Formula in Spreadsheet that requires corrections as below:
There are error in formula for the 3 Sections of "All" (Abk,Ard,Aev,Aod,Abg,Asl).
There are error in Section Even/Odd, Column 1xS.
There are error in Section Big/Small, Column 1xS
See attached files for reference.

Trendlines Graph:

To view Trendlines Graph, tap menu button on the top of DEP to navigate.These graphs should be plotted from the values generated in the various columns update after the numbers are entered in Column A.
The graph should "grow" and "moves", slides into the left side as more and more data are entered.
There are 3 buttons for the respective Trendlines Graph at the top of DEP.
Graph should be dark background to highlight trendlines clearly.
Trendlines should be smoothed and not jagged.
Both DEP and Trendlines Graph screen should be "Screen Rotation" active that can be viewed vertically or horizontally.

Attach files of spreadsheets are for reference only.
Formula Amendment Required here.
There is an error in the Column for the "All".

Skills required:
Android, Data Entry, Mobile Phone Additional Files: Data.png Project