Lukket

VBA Programmer / Data Visualization

We would like to search for a VBA programmer to help us create macros that automate changing formats of our regression outputs / other data to the table formats we want, to perform data visualization, and potentially to help us to create macro to review our regression outputs from a very large amount of regression outputs.

Responsibilities

1. Using macro to extract data from excel or R data files(across large amount of files from many folders) to change the formats(fonts, highlights, number format and etc…) to the desired table formats in different folders(example in…)

2. Data visualization for large amount of raw data, statistical data(including regression outputs) in a creative, demonstrative manner, interesting manner

3. Using macro to extract data from excel to generalize or to compare regression outputs results

Qualifications

1. VBA: At least 4 years of experience implementing programming using VBA, in working with large amount of data, databases, data visualization(also important). (experience with statistical analysis is a plus)

2. Statistics: basic understanding of multivariate linear regression, and understand what regression outputs mean(such as coefficient, tstat) and know basic summary statistics such as percentile, mean, median.

3. Fluent English communications skills in oral and writing

4. R programming experience is a plus

5. Candidate must be able to generate results quickly with sufficient availability to spend time on this project as soon as hired (have at least 25 hours of available time in the next 7 days), because the deadline is for our project is less than 10 days, Weekly availability to be at least 20 hours

VBA Test: There is a test to determine your qualifications for the position with the test instructions and excel files in the zip file from the dropbox link below. I will be testing the macro you created from the raw excel file by using other raw excel files with some differences in the the names and # of hypothesis variables and control variables to determine if the macro you have created with the test works.

[url removed, login to view]

Please answer the following questions along with your application to the position

How many years have you used VBA and how often using VBA during those years?

Could you describe your VBA usage? Please include a more detailed description for the working with data formatting, data visualization, statistics

Could you describe the extent of your statistics knowledge and experience?

What is your weekly available hours and can you start immediately with at least 20 hours in the 5 days after starting?

Can you send me your CV?

Evner: Excel

Se mere: software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, select data excel vba form access, software write protection, read data webpage vba, extract data web vba, free software write book, creating xml file data excel vba, collect data url vba, software write book, as400 data excel vba, extract data email vba, extracting data html vba, adding data table vba access, create data report vba sql, extracting data outlook vba, data encoding vba excel

Om arbejdsgiveren:
( 0 bedømmelser ) New York, Hong Kong

Projekt ID: #13620599

18 freelancere byder i gennemsnit $12/time for dette job

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.

$15 USD / time
(186 bedømmelser)
7.1
SBITServices

Hello EMPIRICUS,I have read your project description clearly and I understood your requirement. i have 5 years experience in VBA and agree that can complete task with high quality and [login to view URL] our reviews to Flere

$8 USD / time
(177 bedømmelser)
6.8
zebracaro

i can do it for you quickly and exactly

$16 USD / time
(74 bedømmelser)
5.7
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Flere

$16 USD / time
(57 bedømmelser)
5.7
axiomswb

We have expertise in Excel [login to view URL] main motto is to provide client satisfaction for long term relationship.

$8 USD / time
(29 bedømmelser)
5.4
satishtl

Done with P1_Model4_output which I could share with you. - Have extensive experience in VBA programming. - Done reports, stock data analysis, formatting of the status reports, consolidation of stocks and colour cod Flere

$15 USD / time
(37 bedømmelser)
5.2
$15 USD / time
(10 bedømmelser)
4.8
zu02

Hi there, I’m a ms Access/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Ex Flere

$12 USD / time
(14 bedømmelser)
5.0
$15 USD / time
(21 bedømmelser)
4.5
fb57e1f6608abfb

I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interacti Flere

$12 USD / time
(7 bedømmelser)
3.5
benefitworks

Hi Mr. Employer, I have completed your VBA Test and its ready to be dispatched to you. On click of a button, select a raw data file and everything else is done automatically as per your requirements in seconds. ht Flere

$14 USD / time
(6 bedømmelser)
3.1
furqanahmed55

Hello, I graduated from Boston University USA, which is among top 50 Universities of the world. After my education, I worked in the field on different positions. I have a lot of experience of VBA programming a Flere

$8 USD / time
(3 bedømmelser)
3.5
akh58e429612d690

because i m always work with my full concentration . do you know the bad thing about me ? absuletly no ok the bad thing about is that i always become late but the reason of become late is i never finish my work until Flere

$12 USD / time
(0 bedømmelser)
0.0
rohitnag92

Respected Recruiter, I am writing in response to the above mentioned job requirement. I have read your job details and I can assure you that I can complete the work before the mentioned time Please find below the bri Flere

$8 USD / time
(0 bedømmelser)
0.0
damwlod

I have a large knowledge in excel and VBA. Also I work in insurance company where analyst a lot of data and creating vba tools for example: generator of input files in txt, csv formats to our system. Feel free to ask Flere

$11 USD / time
(0 bedømmelser)
0.0
Manishjain2112

I will use my Expertise to complete this task before time . This is my first project as a freelancer So looking for a good opportunity .

$12 USD / time
(0 bedømmelser)
0.0
$12 USD / time
(0 bedømmelser)
0.0
$8 USD / time
(0 bedømmelser)
0.0