Em Andamento

Excel data sheet Analysis

Project task is produce VBA code in Excel (Excel 2003 /XP environment) to analyse data from workbook held in same directory (workbook is dynamic - extra rows of data frequently appended - columns stay same).

For each classification of a filter criteria in a column(as that shown using standard autofilter drop down selection for a column - filter criteria dynamic and to be extracted from source file) a new worksheet is to be created in the code source workbook (not the source data file). This worksheet will provide the analysis of data from source file.

The analysis will take the form of:

2 charts :( 1 clustered column for number of entries per week (period = time of 1st entry to time of last entry - to be shown in wk numbers) and 1 line-column on 2 axes for pareto of given criteria against accumulative %,

2 tables , 1 table with 5 results showing number of entries meeting fixed criteria (entry = "major" "minor" , over 1 month old etc). 1 table identifying who raised issues and number of issues raised per person (names to be extracted from data file)

The last part of the analysis would be to list all data entries that meet certain criteria..list all entries that meet condition ABC, then underneath allentries that meet DEF, the underneath all entries that meet TUV, then finally underneath all entries that meet XYZ conditions.

VBA provided should be appropriately annotated with descriptions of routines to enable future support and editing to take place, and to reflect good coding practices.

Habilidades: Excel, Visual Basic

Veja mais: abc analysis data sheet, analysis sheet excel, worksheet data entry form vba code, excel data entry worksheet form, data entry worksheet, data entry form excel 2003, data entry analysis, data analysis with excel, abc data entry, 1st source, abc analysis data entry sheet, new excel, excel vba drop down list, data and analysis, ABC, wk, visual basic form excel, vba excel, vba code excel, VBA and excel, time sheet, line sheet, identifying, excel vba data entry form, excel table

Acerca do Empregador:
( 2 comentários ) Southampton, United Kingdom

ID do Projeto: #577966

Concedido a:


I would like to work on the project.I have good command on MS Office packages especially Ms Excel

$40 USD em 2 dias
(1 Comentário)

16 freelancers are bidding on average $116 for this job


I can give you the demo VBA code once you give me the excel

$80 USD in 2 dias
(30 Comentários)

Please check PMB.

$100 USD in 5 dias
(39 Comentários)

Kindly check PMB for details.

$400 USD in 7 dias
(19 Comentários)

Hello Ready to start right now. Please see your PMB for details. Thanks

$35 USD in 2 dias
(15 Comentários)

Hi, I have attached an analysis sample on PM. Regards Zoltan

$50 USD in 3 dias
(3 Comentários)


$225 USD in 5 dias
(0 Comentários)

Hi, Please see PMB, Looking forward to work with you

$150 USD in 5 dias
(0 Comentários)

Hello. I'm ready to take it. Please chek PMB. Thank you.

$150 USD in 12 dias
(0 Comentários)

ready to do and waiting for your reply

$140 USD in 30 dias
(0 Comentários)

I am new to FnidaFreelancer but NOT new to Excel Power VBA programming which I have been doing for almost 10 years. I do this sort of programming at my `day job` all the time. I have this week (Dec 28-Jan 1) off wor Mais

$150 USD in 2 dias
(0 Comentários)

I will do my best.

$45 USD in 2 dias
(0 Comentários)

hi first of all i want to sample after that i have agree to do your work thanks anilkumar

$60 USD in 30 dias
(0 Comentários)

Hi I am a vba expert.

$100 USD em 1 dia
(0 Comentários)

Hi sir, I have well versed experience of designing chart and graphs using excel data sheet. I am able to do this project.

$30 USD in 3 dias
(0 Comentários)

Let me know if you want me to write the macro.. i can do very quickly..

$100 USD em 1 dia
(0 Comentários)