Summarise Data Dump with Power Query or VBA

$30-250 AUD

Completed

Posted

almost 3 years ago

$30-250 AUD

Paid on delivery

I need to automatically pull data from a generic spreadsheet and summarise it into another. The client use a vulcan dump to generate a charge plan. Dump size will change depending on the plan, however the columns remain relatively the same. I need something to pull the data and summarise it into a table. The table must sum the "Charged" length by the "Explosive" Density, Hole Diameter "Comment" and by Direction. The direction of the hole is determined by the "Bit" values in the Collar Column. If the "Bit" Value is between 0 and 180, the direction is "UP". If the "Bit" Value is between 180.1 and 359.9, the "Bit" value is "DOWN". Note that the hole numbers in the ring won't necessarily match the number of holes being charged. For example, there's a 750mm diameter hole in R09 (Hole 2, Row 210) that doesn't get charged (Row 225 & Row 226). I don't mind whether it's VB or Power Query that can go through the data and summarise it. The final outcome needs to summarise the data by Diameter, Explosive, Up and Direction

Excel

Data Processing

Visual Basic

Project ID: 31131316

About the project

25 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@cgullapalli

$0 AUD in 4 days

5.0

(1232 reviews)

8.5

25 freelancers are bidding on average $136 AUD for this job

@daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot Tables and Excel based formulas. Lets discuss your project in detail and how I am highly suitable for this.

$75 AUD in 1 day

4.8

(223 reviews)

7.3

@ntkhong

⭐⭐⭐⭐⭐ Data Processing Expert ⭐⭐⭐⭐⭐ Dear sir! I am very familiar with algorithm & data processing using VB/python language. I've checked just your attached project and I am very interested in your project. When do you need the project finished by? Hope to meet and have a talk about your project detail. Sincere Regards

$100 AUD in 1 day

4.7

(6 reviews)

3.7

@ginushaji3

I can do it using python. Contact me for further deliberations................................ Regards Ginu

$140 AUD in 7 days

4.9

(14 reviews)

3.8

@arunodaya123

HI, Hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects, I has done tons of projects using VBA and RPA(UiPath), Power Queries and other technologies. I understand your requirement and I can give my full effort to deliver this project in on time with 100% quality and accuracy. I am waiting for your kind response.

$60 AUD in 1 day

5.0

(7 reviews)

2.8

@Blackeagle8

Hi, Greetings! ✅Checked your project details: Pull Data from one excel spreadsheet and summarise into another spreadsheet ✅Completed Time: 48 hours or your required deadline. Kindly, I work on many projects like your request, I can send you many samples of my work in Excel charts, Formulas, Pivot tables, and VBA codes. Please let me have a chance to show you my experiences. ✅My Portfolio Items:https://www.freelancer.com/u/Blackeagle8 Thank you Hazzaa

$75 AUD in 2 days

5.0

(7 reviews)

2.1

@elmorabitnahid

Hello there, i'm able to handle thos work perfectly and faster, i guarantee your satisfacation and the high quality work. Contact me to get started.

$140 AUD in 1 day

0.0

(0 reviews)

0.0

@vitore

Hi, there. I've read your post that you need Summarise Data Dump. I promise that I will provide the best result in a short time as a senior developer. Let's discuss via chat. Thanks.

$150 AUD in 2 days

0.0

(0 reviews)

0.0

@hatou1227

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have a tons of experience in Excel, Excel VBA, Visual Basic, Data Processing. Your satisfaction with the project is my top priority! If you give me a chance to work with you, I will do my best to reach your requirements. I'm waiting for your kind response. Please send message over chat. Let's go. I will do my best for you. Best Regards. ==

$50 AUD in 1 day

1.0

(1 review)

1.0

@lucasgm13

Hi, my name and Lucas, and I can help with your project. the work will be delivered within the stipulated period. I have a wide knowledge with the use of excel as I have already taken several courses and I can easily help you. For example, the formula for analyzing a column and another, a number and another, is called PROC. With her doing your task will be much more peaceful.

$160 AUD in 7 days

0.0

(0 reviews)

0.0

@mdhossainrasel11

Hello, I'm eagerly interested to do this project. If you give me a chance I will ensure you to do this project better. I will try to do this project properly your guideline.

$140 AUD in 7 days

0.0

(0 reviews)

0.0

@atteeek

Hey, I hope you are doing well. I can assist you with your excel task, as I have advance Excel skills and I've been providing my services in this field for the last 5 years. I've extensive knowledge of Data Filters, Data Sorting, Pivot Tables, SUMIF/SUMIFS, COUNTIF/COUNTIFS, Excel, Shortcut Keys, Charts, and Cell Formatting. Please have a look at my portfolio, that’ll help you trust in my offered services. I have been associated with the writing industry for 5 years now, I am new to the platform and am looking to establish myself here as well. I hope we will work together, Best Regards, Ateeq

$50 AUD in 2 days