Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore

You will get a macro spreadsheet that filters data based on your data/specified inputs

Kenneth C.
Kenneth C.
5.0
Preview imagePreview image

Let a pro handle the details

Buy Data Entry & Cleaning services from Kenneth, priced and ready to go.

You will get a macro spreadsheet that filters data based on your data/specified inputs

Kenneth C.
Kenneth C.
5.0

Select service tier

Analysis of 5 sets of data

I will run the analysis on 5 sets of data, max 10,000 rows and 100 columns

  • Delivery Time 1 day
  • Number of Revisions 5
1 day delivery — Oct 11, 2024
Revisions may occur after this date.
Loading
Upwork Payment Protection
Fund the project upfront. Kenneth gets paid once you are satisfied with the work.
Preview imagePreview image

Let a pro handle the details

Buy Data Entry & Cleaning services from Kenneth, priced and ready to go.

Project details

This Excel sheet has a macro that will calculate the sum and average of data, depending on how many different objects/items/units have data assigned to them. For example, if there are 10 units to be analyzed and there are 10 different columns of data, this spreadsheet can quickly provide the sum and average of all units for any given column. This will count as one run.

If you would like the document, I can provide it and walk you through how to use it. It only takes a few minutes to do so
Data Tool
Microsoft Excel
What's included
Service Tiers Starter
$20
Standard
$50
Advanced
$300
Delivery Time 1 day 1 day 1 day
Number of Revisions
5Unlimited0
5.0
1 review
100% Complete
(1)
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
Rating breakdown
Availability
5.0
Deadlines
5.0
Skills
5.0
Quality
5.0
Cooperation
5.0
Communication
5.0

TB

Tyler B.
5.00
Jan 8, 2023
Microsoft Exel Help Kenneth was an excellent asset to my project. Communication was prompt, clear, and precise. He was able to meet and exceed my expectations. My Excel Spreadsheet was better than what I asked for. I will be staying in touch and utilize his skills for future needs.
Kenneth C.

About Kenneth

Kenneth C.
Petroleum Engineer
5.0  (1 review)
Dallas, United States - 10:55 pm local time
I am a Petroleum Engineer looking to do freelance work in Microsoft Excel, VBA, and Python. I have extensive work with using advanced functions like VLOOKUP, INDEX, MATCH, etc. I have also created a few spreadsheets that utilized macros to analyze data by sorting, filtering, and applying statistical functions.

I have some Python experience using the Pandas, Selenium, Requests libraries. I have also used some other functions to do some statistical analysis (i.e. RegEx, lambda functions, etc.)

I am in the Central Time Zone but am able to work earlier/later as needed.

Steps for completing your project

After purchasing the project, send requirements so Kenneth can start the project.

Delivery time starts when Kenneth receives requirements from you.

Kenneth works on your project following the steps below.

Revisions may occur after the delivery date.

Receive and analyze data

Data will need to be formatted with a Header row

Send analytics/Excel sheet back

All analytics will be sent back in an Excel document if applicable. Excel sheet with the macro will be sent if you want the source document

Review the work, release payment, and leave feedback to Kenneth.