Find Jobs
Hire Freelancers

Looking for an EXCEL wizard

$30-250 NZD

Zaprt
Objavljeno pred skoraj 4 leti

$30-250 NZD

Plačilo ob dostavi
I need someone to help me figure out complicated stuff in EXCEL i need to populate a column with a sealing date Take this scenario for example, there is a road section that is 744 meters long, the road is split into 5 different chunks because there is 5 intersections, so the road is recorded as 0 - 182, the next length of road is 182 - 397, then 397 - 557, then 557 - 668 then 668-744 for example, there is a separate table i have that tells me when the road was last sealed, but the sealing records show for example that they sealed 0-744 in 2014, and sealed 0-668 in 2019 I dont know how to add a sealing date to my road record when there is no unique IDs to work from. see attached spreadsheet that contains the surface data and the working out columns
ID projekta: 25742968

Več o projektu

31 ponudb
Projekt na daljavo
Aktivno pred 4 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
31 freelancerjev je oddalo ponudbo s povprečno vrednostjo $77 NZD za to delo
Avatar uporabnika
Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 NZD v 1 dnevu
4,9 (412 ocen)
7,6
7,6
Avatar uporabnika
Hello Sir Im excel VBA macro and formula Expert :) i can do make macro for your scenario for split road to different area/range please ping me now for discuss more and im able to start working right now after all clear THank you Galih
$140 NZD v 1 dnevu
4,9 (408 ocen)
7,3
7,3
Avatar uporabnika
Hi, how are you?, my name is Cristian and i am Excel/VBA expert. Excel wizard here! You can see my previous work and the comments that employers have left me in the following link: https://www.freelancer.com/u/elqueabandona Contact me to discuss the details. Cheers
$100 NZD v 1 dnevu
5,0 (280 ocen)
7,1
7,1
Avatar uporabnika
Hi, u need formula under Surfacing Date column ?
$100 NZD v 1 dnevu
4,9 (259 ocen)
6,9
6,9
Avatar uporabnika
Hey there! Your project jumped out at me, and I would love to help you out with it. I specialize in Excel and Workbook creation. I'm a detail-oriented person who delivers given projects on deadlines. I read through the entire project and understood it. I am able to fix your Excel task according to your requirements. I'm capable of handling your project and will provide a 100% accurate outcome. This is an ideal project for my capabilities. I'm looking forward to work with you. Check my reviews to get an idea about my work. I'm online at the moment, feel free to initiate a chat; we can discuss further regarding your project. Hope to hear from you. Best Regards, Ravindu :)
$100 NZD v 1 dnevu
5,0 (61 ocen)
6,1
6,1
Avatar uporabnika
NOTE : I HAVE EXPERTISE IN EXCEL MACROS AND VBA With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed few projects which involved Programming, scripting, & excel. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$80 NZD v 2 dneh
4,9 (54 ocen)
5,8
5,8
Avatar uporabnika
$69 Only ----- Dear sir, I have read your project details and reviewed the attachment carefully. I can make the advance formula by maintaining 100% accuracy of your data absolutely as you want ------- Excel VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting ------ I can start right now, please message me to discuss more. Regards Anowar
$69 NZD v 1 dnevu
5,0 (137 ocen)
5,6
5,6
Avatar uporabnika
Hi there, Do you need a formula that will put years to column D ("Surfacing Date") of Working Out Sheet from the dates in Column N ("Surface Date") of Surface Data Sheet? This can be done using Excel built-in formulas. please see the below sample result of the formulas: ABBOT ST/ 0-182 / No Records ABBOT ST/ 182-397/ 1984 ABBOT ST/ 397-557/ 1973 ABBOT ST/ 557-668/ 2019 ABBOT ST/ 668-744/ 2014 Please message me if this is any of what you need. I'll be standing by to help. -Reggie
$45 NZD v 1 dnevu
5,0 (25 ocen)
4,9
4,9
Avatar uporabnika
hello sir, I have the wide experience as I worked at Advice Interactive Group in Quality Assurance for Directories submissions for about three years. What I can do for you: -Data administrative assistant. -Excel (creating formulas, financial reports, and management reports). I also would like to discuss further details over chat before you award the project You must see my portfolio now before you hire me. But I will not finish your work until you are completely Satisfied with your project.
$140 NZD v 4 dneh
4,8 (37 ocen)
4,8
4,8
Avatar uporabnika
Hi there, I have read your scope and the worksheet. I have the formula you can apply in the "Surface Date" column that will get the correct dates from "Surface data" sheet. I can deliver as soon as you need it. Regards Reuben
$50 NZD v 1 dnevu
5,0 (18 ocen)
4,8
4,8
Avatar uporabnika
Hi, I'm an expert in Excel. If you don't have an ID you have to identify sections with a combination between name of the road and numbers. I think it could be done with formulas only.
$30 NZD v 3 dneh
5,0 (6 ocen)
3,4
3,4
Avatar uporabnika
Only 70$ in 1 days-Lowest bid with a high potential solution-Payment after 100% Work satisfaction I have gone through your current requirements & attached & would be happy to offer you with the required solutions. I am a Certified in Excel, Google Spreadsheet, Data analytics. I am also an expert in building MIS as well as Professional Visual Dashboard I have attached my portfolio to know of the work done by me on excel/Google Spreadsheet.I have delivered so many sustainable & reliable dashboard in the organization with a turnover of over 100 billion dollars. Portfolio:https://www.freelancer.com/u/DHAVALPATEL008?page=portfolio&w=f&ngsw-bypass= With over 10 years of experience and has made more than 500 MIS/Dashboards in the various organizations and startups in the field of Chemical, IT, Pharma, Civil, FMCG I have Designed Template/MIS/Dashboard in the following field 1. Human Resouces(HR) 1.1 Time management 1.2 Payroll management 1.3 Employee Register 1.4 Recruitment 2. Finance/Costing/Accounting 2.1 Balance sheet 2.2 Audit management 2.3 Profit & Loss Tracking 2.4 Investment vs return 3. Project 3.1 Project Planning & Tracking 3.2 Project Performace & Finance planning 3.3 Workflow management 3.4 Civil Contractor Work & Costing 4. Maintenance 4.1 Asset management 4.2 Daily Job management 4.3 Maintenance Planning & Execution 5. Procurement/Sales/Marketing 5.1 Material/Service Purchase requisition 5.2 Vendor Management 5.3 Stock management
$70 NZD v 1 dnevu
4,9 (2 ocen)
3,4
3,4
Avatar uporabnika
Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Office -Python -PowerPointMacros -Automatioin -Automation tools -VBA -Excel and VBA automation - etc. A professional having more than 7 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level. I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project. I only accept the projects which I am sure can be done within the stipulated time frame and budget.. I always deliver 100% Satisfaction to the client. Hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat. Thanks Regards ATEMENU.D
$30 NZD v 1 dnevu
4,9 (6 ocen)
3,1
3,1
Avatar uporabnika
I have been working with excel for more than 20 years, and have been using CBA for at least 10. I enjoy Excel challenges, and this project looks interesting. I think we can work out some formulas to get you what you want, but if we need to add extra intelligence with a few macros, I can get you setup with some robust scripts. Thanks for your consideration, Sean J
$31 NZD v 3 dneh
5,0 (2 ocen)
2,0
2,0
Avatar uporabnika
Dear Hiring Manager I am ready to start right now. I checked your both sheet (working out and surface data) need to more discus for populate a column with a sealing date, I am expert excel formula, please see my recent successfully completed project. I am confident that I can deliver this project to your satisfaction. Please contact me via chat, I would be happy to answer any questions you might have. Thanks Anowar
$30 NZD v 1 dnevu
5,0 (6 ocen)
1,6
1,6
Avatar uporabnika
Hi, I have PhD in mechanical engineering from Tohoku University of Japan. I have published 20 Journal papers and 16 international conference papers. I have read your Requirement. My expertise match this job. Please send me a message so that we can discuss more. Thank you Best regards
$140 NZD v 7 dneh
5,0 (1 ocena)
1,6
1,6
Avatar uporabnika
Hi there, I am an expert in excel and macros. I have gone through the project description and can help you on this project.
$30 NZD v 2 dneh
5,0 (1 ocena)
1,3
1,3
Avatar uporabnika
I have enough experience for this assignment and prepared to take it up. I have reliable internet access and deliver projects in time.
$30 NZD v 7 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
-I am efficient in Microsoft Word, Excel, and Powerpoint. I am a hard worker, type quickly, and can ensure your data is entered accurately.I am ready to start now
$30 NZD v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
$$$$$$
$156 NZD v 3 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava NEW ZEALAND
wanganui, New Zealand
5,0
50
Plačilna metoda je verificirana
Član(ica) od jun. 23, 2013

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.