В роботі

Data Analysis Prototype in Excel - repost

Is someone free to spend a couple of hours to create an Excel spreadsheet or similar with control sheet to run extract of data held in .CSV file.

File format is described in Table A.

Control sheet will allow entry of search criteria described in Table B.

Control sheet will include a 'Run Query' button that will create extract of data and a summary of extract to new worksheets based on the criteria entered on the control sheet/interface.

Two new worksheets will be created as result of 'Run Query' button being actioned.

1) Detail – in same format as Table A but with addition of fields described in Table C. Data will be ordered by Date and Time, (columns BG and B).

2) Summary of Data File in format Table D.

Process can be re-run by adding new control sheet/interface data and actioning 'Run Query' button again – NB existing data should be deleted first.

See attached for full spec including table formats plus example of input file.

Навички: Excel

Показати більше: date analysis excel, prototype date, formats in excel, excel for data analysis, data analysis with excel, data analysis for excel, data and analysis, excel data analysis, data analysis, Data analysis in excel , data analysis excel, d prototype, csv data analysis, create an excel, c data, analysis excel, analysis data excel, analysis excel spreadsheet, analysis sheet excel, data entry analysis excel, excel input interface, date input control, excel data entry interface, create prototype, excel query csv file

Про роботодавця:
( 142 відгуки(-ів) ) DHAKA, Bangladesh

ID проекту: #4519631

Доручено:

nirajkg96

Dear Client, i am expert in Excel. I can do this work. Please contact me for batter work performance.

$5 USD / год.
(0 відгуків(-и))
0.0

5 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $5/год.

vickkey7

I am ready to start this project... thanks

$5 USD / год.
(9 відгуків(-и))
3.4
chathu19895

Hi Let me introduce me as a hard working data entry professional willing to go that extra mile to achieve the targets set forth. I have excellent English skills and proficiency in data entry, web designing,customer s Більше

$5 USD / год.
(0 відгуків(-и))
0.0
saviralc

ready to work :)

$5 USD / год.
(0 відгуків(-и))
0.0
rinozasalman

Hi sir/madam. i am a student and is interested in doing your job as part time. I am fast in typing and good with my English. I have really good experience in Microsoft word, excel and power point. Moreover I am very st Більше

$5 USD / год.
(0 відгуків(-и))
0.0