In Progress

Simple Excel (Power Query or LOOKUP)

1) From SR60KData:

[Production_Well_Data] tab

- Pull Column A & B, and have them fixed on a new spreadsheet.

- Compare the data in Column F, G, J & M from between yesterday's data and the day before yesterday. With an arrow showing (up, down or steady) status next to the cell if the change in value is more than 10

2) Another tab in the new spreadsheet to compare the above data in weekly average

3) Another tab to plot the values from Column F, G, J & M over time, since the beginning.

So one tab to compare yesterday and the day before that. And another tab to compare this week with the week before it. And the last one to plot the lifecycle.

Skills: Excel, Data Processing, Visual Basic, Data Entry

See more: excel power query, power query excel 2016, excel sort numbers 1 10 2, power query lookup value in same table, power query match function, vlookup approximate match formula in power query, excel power query lookups, lookupvalue power query, power query merge, index match in power query, power query vlookup same table, how to use power query in excel 2016, excel power query tutorial, excel power query macro, power query excel 2016 tutorial, excel power query advanced editor, excel power query mac, power query combine multiple excel files, power query excel.workbook( content ), excel.workbook power query

About the Employer:
( 3 reviews ) Ardiya, Kuwait

Project ID: #27549561

Awarded to:

ssas05

Hi Dear, I have read your job description properly. I have 5 years working with the word, excel, data entry, web research& I have a lot of experience. I can confirm that I will be able to complete this task with the h More

$10 USD in 1 day
(0 Reviews)
0.0

18 freelancers are bidding on average $20 for this job

(280 Reviews)
7.3
SidhuDN

Hello Sir I read your job carefully and I can do this job professionally. I can follow instructions really well. I have a lot of experience in Data Entry, Web Scraping, Internet Research. If you want, you can test all More

$30 USD in 1 day
(25 Reviews)
5.4
Jatin77777

Hello, I have gone through with contents and attached files to understand the requirements. This is pretty straightforward task and I am interested to do this work and break your huddle. Please allow me to do this job. More

$20 USD in 1 day
(8 Reviews)
3.9
TYPEJ

Our team comprises of reliable consultants and Web Researchers. We have been involved for many years in web Content development, specialized in web scraping and task automation. We are perfect at Web Scraping, data ex More

$80 USD in 1 day
(2 Reviews)
1.0
lismreuben

As an experienced developer I wish to take on your project. With 10 years of experience I feel confident that I will deliver. Let's talk some more. Cheers!

$30 USD in 5 days
(1 Review)
1.2
emimran1

Hello sir, hope you are doing great, I had read the description you provided about the project, I have the skills required for this job and I can do your work very effectively in very less time possible. hope to be awa More

$10 USD in 1 day
(2 Reviews)
0.3
bks2211

I am very interested in your project and has rich experience in data entry jobs,data validation, data scrubbing,excel, reporting [login to view URL] requirement matches with my skill set. I ensure you that i will complete work on More

$20 USD in 2 days
(0 Reviews)
0.0
Gunpat

I am new freelancer trying to establish myself. I am skilled at excel and can help you within the timeframe requested.

$20 USD in 2 days
(0 Reviews)
0.0
amita1621

I have been working in an Insurance company . I am a data analyst where i use Excel, SQL and Qlikview to clean and prepared YoY(Year on Year) analysis , WoW(Week on Week) analysis using Graphs and Pivot both in Excel More

$10 USD in 1 day
(0 Reviews)
0.0
sapnasjain29

I am a highly efficient professional just entered into Freelancing, however, I have a deep experience in Data Entry in professional world. I am good for the job offering the lowest bid with maximum quality and lowest t More

$10 USD in 1 day
(0 Reviews)
0.0
arvind07bh

Good morning sir.I will do your job responsibly. Because I respect this work very much.I will get the job done very fast.

$20 USD in 7 days
(0 Reviews)
0.0
MUNEER0439

I am an expert and well trained human in data entry .I have a good hand on MS Office, Data Entry, Excel, Web Search . I will turn out to be best choice of yours. I hope for your positive reply .

$10 USD in 1 day
(0 Reviews)
0.0
shariqhamid638

Hi, We read and understand all your requirements(Simple Excel (Power Query or LOOKUP) ) and will provide you Power Query or LOOKUP I am a graphic designer and have 3 years of experience. I'll provide you quality work More

$20 USD in 2 days
(0 Reviews)
0.0
atikshahriar22

Hello there, I'm interested in your project. I have read the project details very carefully and I am very sure that I am able to complete the work successfully within given time limit with best possible accuracy. I More

$10 USD in 3 days
(0 Reviews)
0.0
mumtahenamim

Dear Hiring Manager, I have read your project description and interested to work for the project. I am proficient at excel. I have 5 years of practical experience at working with excel. My current role requires me to c More

$10 USD in 1 day
(0 Reviews)
0.0
khanbijoymbk2020

Expert on Advance Excel ✅ Hi there! I’m bijoy, my computer experience is 13 year's more. I’m expert on Data Entry, VBA, Macro, Data Validation, Conditional Formatting, Forecast, Pivot Table, Graph and Chart, Dashboard, More

$15 USD in 1 day
(1 Review)
0.0
muqaddastariq

Respected Client, I am proficient in excel. I have gone through the description of project and attached file, and I understand that you need a comparison of different columns (for yesterday and day before and then for More

$15 USD in 7 days
(0 Reviews)
0.0