Android App for Data Entry and Trendlines Graph Output.
Screen Page 1 - Data Entry Page (DEP)
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 [url removed, login to view] 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.
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,
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.
To view Trendlines Graph, tap menu button on the top of DEP to [url removed, login to view] 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".