Sunday, June 1, 2008

Excel sheet - Data Entry Freelance Job

Here is a project of data entry in excel sheet. delivery in 3 days. Please send the total fees. Objective: 1.Creating/Setting formula to all required fields. 2.Creating combo box ( Scroll) 3.Generating 02 kind of reports one is numeric and the other is graphs. •In case there is source code or worksheet pass word, then you have to advise it to me before release final payment. Introduction: All required action to be done by you has explained by inserted comment on every field of Excel file attached. I have created an Excel file with one field each of 38columns in sheet 0ne and one field each of 37 columns in sheet 03. Sheet 01 contained A to T field of daily data entry for each record starting with date. Sheet 02 contained list of company’s names and company’s number. All company names alphabetical (Tickers) has number also for example: company name is RIBL and the same company’s number is 1010. You will notice that the default direction has set on Right â€" to â€" Left due to that all English text in all fields will be replaced to Arabic language after finished creating the objective therefore Do not escrow the Excel worksheet. The language change will be done by service buyer. To avoid writing name each time and some time with errors I want to be scrolling combo box of name and tickers number, that once I start name with S for example all ticker’s name starting with Saudi Hollandi, Saudi Fransi, Sabic etc, will be listed. And so on with other letters. Also by number if I start with 1 then all 1010, 1020, 1030 etc. Next, once I selected either one by number or by alphabetic, then both fields will paste name & the related number. Box date will appear once the curser reached to date field, infect, I have created already box date but half of the box is hided which need to be fix. In each day I will add/use around 2 to 5 rows with new date and it will continue going on regardless when will stop probably for next several years, therefore please make sure that the setting formulas are valid for all rows in this book/file. From this work sheet I want to generate 03reports, 02 are numeric and the other has Excel chart. In some field I have use Cell instead of field but both are the same meaning. Reports: 1-Transfer selected data from sheet 01 to reports. •Closed record reports: Select date from & to then search all closed record and loaded template report. •What to do tomorrow: Select date of record from 01Feb 2008 to 01Feb 2008 for one day which I have created in sheet 01 or from 01 Feb 2008 to 02 Feb 2008 for more than 01 day and transfer to report template 2- Indexes Charts Reports of (Date) •Transfer selected data of Passed, Remaining & balance fields representing each index individually of 09 Indexes from sheet 03 to sheet 1 and translate the same to Excel graphs with loading to report template. •This job to be done within 3 day. More explanations: 1-Please select Name along with ticker number directly and loaded to the table and create combo scroll box. 2-All text in table, it mean's table heading in sheet one plus three, non numeric fields like F5 for example in sheet one. Consequently all reports which generated from the Arabic text on sheet one will load to Arabic text also. 3-Correction in sheet one, In field B13 click comment, please delete row 8 and put B7 instead /replacement of row 8..