Find Jobs
Hire Freelancers

Operational Data Analysis in Excel

$30-250 AUD

완료함
게시됨 5개월 전

$30-250 AUD

제출할때 지불됩니다
Changes to existing spreadsheet for Market Data analysis. More work available. Full brief as attached. Hourly High Lows: Calculated from the ‘NY Open’ price utilising the times set out in the ‘Trading Hours’ sheet ie. 8-9am etc… Negative numbers should be rounded to zero or blank. Conditional formatting should be applied if number is above or below the ‘Upper or Lower Bracket’. Daylight Savings Offset: Tines are set out in the sheet ‘Trading_Hours’, I need a way for the ‘Data’ sheet to automatically adjust times to allow for day light saving times in various time zones. As the data contracts span multiple time zone adjustments ie. FDXM Dec 23 contract runs 15/9 – 15/12 and has a time change for Europe on 29/10 and another for NY on 12/11. This mainly impacts the ‘NY Filtering: The ‘Main’ sheet is used for filtering the ‘Data’ sheet. I need a way to input variables for various columns to filter. The filtered output can be placed into the main sheet or simply filtered on the data sheet.
프로젝트 ID: 37573973

프로젝트 정보

35 제안서
원격근무 프로젝트
활동 중 5개월 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi there! I've been working with Excel and Power BI for a long time. For the past ten years, I've been at a Financial Institution, creating complicated reports in Excel. I think my experience aligns well with what you need. Additionally, I have other methods to handle this kind of data, and I can talk about them when we discuss further.
$140 AUD 7일에
5.0 (2 건의 리뷰)
2.9
2.9
사용자 아바타
$0 AUD 2일에
5.0 (645 건의 리뷰)
8.6
8.6
35 이 프로젝트에 프리랜서들의 평균 입찰은 $141 AUD입니다.
사용자 아바타
Hi, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
$40 AUD 1일에
4.8 (245 건의 리뷰)
7.3
7.3
사용자 아바타
Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.
$175 AUD 3일에
4.9 (133 건의 리뷰)
6.7
6.7
사용자 아바타
Hi There, Ready right now I'm ready to Changes to existing spreadsheet for Market Data analysis. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/excel/business-profit-loss-reporting-excel/reviews https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer
$80 AUD 1일에
4.8 (164 건의 리뷰)
6.3
6.3
사용자 아바타
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
$100 AUD 1일에
5.0 (52 건의 리뷰)
5.8
5.8
사용자 아바타
Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$180 AUD 2일에
4.8 (148 건의 리뷰)
5.8
5.8
사용자 아바타
Hello, I am an experienced spreadsheet analyst and am eager to assist with the requested changes to your existing market data analysis spreadsheet. After reviewing the detailed brief attached, I am confident in my ability to implement the necessary modifications efficiently. Specifically, I will calculate hourly high-lows, incorporate daylight savings offsets based on the provided trading hours, and enable dynamic filtering options for enhanced analysis. My proficiency in spreadsheet manipulation, attention to detail, and commitment to delivering high-quality work make me an ideal candidate for this task. I look forward to discussing any additional details and requirements to ensure the successful completion of this project, with the possibility of undertaking further work as needed. Regards, Zafar
$30 AUD 1일에
4.9 (75 건의 리뷰)
5.2
5.2
사용자 아바타
I understand you are looking for someone to help you with an existing spreadsheet for market data analysis and changes to the spreadsheet required. With my skills in data processing, Excel and other relevant technologies such as Python, R, SQL and SAS, I can provide the necessary solutions to enhance your data analysis capabilities and build customized solutions precisely tailored to your needs. I have extensive experience in data visualization tools such as Tableau and Power BI which can be used to create stunning visuals from your data. Plus, my skillset includes data cleaning and preprocessing tools such as Pandas and NumPy which can be used to make sure your data is error-free before plotting it on the canvas. Finally, I am well-versed in machine learning frameworks such as Scikit-learn which can be used for data analysis and statistics as well as for data extraction and web scraping. This will allow me to automatically adjust times for your data so that it takes into account day light saving times in various time zones without any manual intervention required from you.
$140 AUD 7일에
5.0 (2 건의 리뷰)
3.1
3.1
사용자 아바타
I understand that you are looking for someone to help you analyze the market data in Excel and make necessary changes to existing spreadsheet. I am qualified for python, web scraping, bot development and machine learning. I have experience at data science and machine learning. Additionally, i have my own website where you can find some of my projects. I would be delighted to work on this project with you. I have the skills necessary to carry out your needs in an efficient and timely manner. My expertise includes data processing, Excel which will be necessary for making the necessary changes to your existing spreadsheet. Also, as part of the project i would like to include filtering functionality so that the filtered output can be placed into the main sheet or simply filtered on the data sheet as needed. I look forward to hearing from you soon! Please feel free to contact me if you have any questions or would like additional information about me or my skillset.
$150 AUD 7일에
5.0 (1 건의 리뷰)
3.0
3.0
사용자 아바타
G'day Solution: I am experienced in data analysis and Excel, and I am confident that I can provide an effective solution for this project. I can make changes to the existing spreadsheet, including adding new fields and formulas that would allow for market data analysis. Additionally, I would be able to calculate hourly high and low pricing, based on the ‘ny open’ price and the set times in the ‘trading hours’ sheet. I can ensure that any negative numbers are rounded to zero or excluded from the analysis. Furthermore, I am available to provide ongoing hourly work for this project, should that be necessary. I look forward to discussing the details of this project further. Best regards, Giáp Văn Hưng
$126 AUD 7일에
4.4 (2 건의 리뷰)
1.7
1.7
사용자 아바타
As a highly skilled Excel VBA/Macro developer, I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my best. My clients have never been frustrated with my work and I hope to make you one of them. Please confirm that I am one of the best fits for you and drop me a message for further discussion. Thanks and Best Regards.
$250 AUD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello, my name is Ricky Chen and I am a dedicated and results-driven professional with 4 years of experience in the field of sales and marketing. I have a strong background in data processing and excel at designing comprehensive marketing campaigns that effectively communicate the value proposition of products or services. I have the necessary expertise to help you with your project of operational data analysis in Excel. Specifically, I understand how changes to existing spreadsheets can sometimes be necessary for Market Data analysis, especially when working across multiple time zones with large contracts spanning across weekdays. I am confident that my skillset of data processing, end-to-end sales cycle management, data analysis & analytics as well as digital marketing will be a great asset to your team for this project. Please let me know if you would like me to discuss further or answer any additional questions you may have!
$140 AUD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hi there! My name is Ramachandran and I am a Full-Stack web developer with over 10 years of experience. I specialize in creating dynamic and interactive websites and web applications. From designing captivating user interfaces to implementing robust back-end functionalities, I'm confident that I have the necessary skills to help you with your project. I understand that you are looking for someone to analyze changes to an existing spreadsheet for Market Data analysis. More work available. With my experience in Excel and other related tools such as SQL, I am able to provide the necessary tools needed to undertake this project effectively. I would be delighted to discuss this project further with you and look forward to embarking on this exciting journey together!
$140 AUD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I will do my best to get all the requirements done within 7 days. I am new to freelancer so I am willing to offer my service for less than others.
$80 AUD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hola soy nuevo en la plataforma, sin embargo puedo ayudarte ya que cuento con amplios conocimientos de Excel avanzado y análisis de datos
$140 AUD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Dear client. I understand you are looking for someone to help you with your project of Operational Data Analysis in Excel. With my experience in Data Processing and Excel, I am confident that I can provide the best solution for your needs. As part of the project, I would like to install conditional formatting on any number above or below a certain threshold so that it can be easily viewed. Additionally, I can utilize time zone changes to adjust the times on the data sheet so that it can accommodate for day light saving times in various time zones. This will ensure accurate and timely analysis of market data no matter where you are located. If you choose me for this project, you can rest assured that you will get top quality service at all times.
$111 AUD 2일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Boasting over a decade of hands-on experience, I am adept in Microsoft Office tools, guaranteeing streamlined workflows, optimal presentations, and enhanced organizational efficiency.
$100 AUD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hi, I have been working in field of data processing for last 2 years and i also have experience in data mining and data analysis and spreadsheet. I am excited to working with you and i guess i will be one of the best candidate for this job.
$50 AUD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Skills data operator data processing network marketing digital marketing Facebook marketing YouTube video editor photo lab a mod App java script SEO
$140 AUD 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hi, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
$140 AUD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Having with 9 years of experience i will be proved best candidate for your organisation to complete your task with accuracy and fast delivery. Thanks
$59 AUD 3일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (AUSTRALIA)
Australia
0.0
0
결제 수단 확인
5월 28, 2015부터 회원입니다

고객 확인

이 거래선이 등록한 다른 일자리

Zencart export Customers to .csv
$10-30 AUD
감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.