Find Jobs
Hire Freelancers

Do some Excel Work

$30-250 AUD

已完成
已发布大约 9 年前

$30-250 AUD

货到付款
Excel document 1. (pricing S100 items...) Apply a set formula to a string of data to calculate an output cost using a formula that I will provide. Excel Document 2 (private pricing...). Match a unique identifier (PBS code) in excel document 1 with the same unique identifier (PBS code) in a Excel document 2 to allow the output cost from Excel Document 1 to match up with the correct line in Excel document 2 and be recorded in Column H. 3. Want to run this as a test and double check the data and then will need to be rerun in early April with updated base prices.
项目 ID: 7367112

关于此项目

49提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hey, I reviewed both the files and I think the application of formula and comparison with the file 2 can be best done through a macro. We may create this system in such a way that it will allow you to specify the paths of the two files and on click of a button it will give you the desired results. When the data is refreshed in April, you will simply have to change the names of the files (not in the code but simply in a cell I tell you) and run the code again by clicking the button. So, instead of being an effort to be carried out on each data refresh, it will simply be running the process every time. Do let me know if this sounds interesting and we may discuss the details and next steps. Look forward to hear from you. Thanks and Regards, Shikha (Automyze Consulting)
$94 AUD 在4天之内
4.8 (147条评论)
6.5
6.5
49威客以平均价$100 AUD来参与此工作竞价
用户头像
A proposal has not yet been provided
$110 AUD 在1天之内
4.9 (257条评论)
7.7
7.7
用户头像
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$60 AUD 在6天之内
4.9 (212条评论)
7.3
7.3
用户头像
Hi Sir. I have understood your project requirement. Please discuss and provide the required formula so I may begin. Regards. Usman
$160 AUD 在2天之内
5.0 (67条评论)
6.7
6.7
用户头像
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$55 AUD 在1天之内
4.9 (229条评论)
6.9
6.9
用户头像
I'm a computer science professional with a PhD degree and extensive experience in Excel, among other things. Please have a look at a large Excel project I did recently: https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/ Please make sure to check my COMPLETE profile (my experience and reviews for All Skills) here at freelancer.com. It would be my pleasure to do your project.
$40 AUD 在1天之内
4.8 (192条评论)
7.1
7.1
用户头像
Hi there, The task is clear and can be resolved within a couple of hours. I would be happy to help you on the project. Best regards, Eugene PS. If you wish I can write a macro for you that would do the whole routine for you as a little extra for picking me up.
$30 AUD 在0天之内
5.0 (255条评论)
6.5
6.5
用户头像
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 AUD 在7天之内
4.9 (175条评论)
6.4
6.4
用户头像
Hello, I'm an expert in Excel and data processing with excellent feedback and completion rate. I'm very interested in your project. The price and time 100 AUD and 2 days. Best regards, svteam.
$100 AUD 在2天之内
5.0 (59条评论)
6.1
6.1
用户头像
A proposal has not yet been provided
$100 AUD 在3天之内
4.7 (115条评论)
5.5
5.5
用户头像
!!Hello Sir/Madam, Ready to start. I have completed 300 project and I read your description carefully and understand all your requirements. I have 6 years experience in this field. I have good team SEO, Web Design, Photo Shop, Image Editing, Data Entry, Excel, Web Scraping, Web Search, PDF to excel, PDF to Word, Image to text I’m astute, creative, and pay attention to detail. Feel free to contact me before you decide. Thank you for your consideration, Shareef
$100 AUD 在3天之内
4.7 (110条评论)
5.5
5.5
用户头像
Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel(dashboard, pivot tables, charts, conditions, conditional formatting, statistical, financial, mathematical, string, time, date,..functions), creating pretty charts and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, data analysis, mathematics, accounting, business analysis, cost calculating, project scheduling and project management and finance that helps in this project.
$99 AUD 在5天之内
4.8 (75条评论)
5.4
5.4
用户头像
I am a professional Data Analyst with over a decade of experience, I have reviewed the attached files and can have this done fore you within 24 hours. I look forward to working with you!
$50 AUD 在1天之内
5.0 (36条评论)
4.4
4.4
用户头像
Hello Sir, I guarantee you 100% satisfaction. Would you like to discuss with me.....we negotiate about price and time.....My expertise lies in quality service and delivery on Time. Kindly if you want high quality work then as soon as possible contacts me. Thank u!
$83 AUD 在3天之内
4.9 (31条评论)
4.5
4.5
用户头像
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can do the required calculation once you supply the logic for the formula and match up the PBS code to fetch the output price from document 1 to document 2. Just a quick question - are you looking at a macro code or just the formulas ? Please message me so that we can discuss and proceed further. Thanks ! Regards Dan
$100 AUD 在1天之内
5.0 (11条评论)
4.6
4.6
用户头像
Hello, I work a lot with advanced formulas and VBA in the reporting environment for my regular job @Oracle as global reporting analyst so anything you throw at me, if described correctly should be no problem to fix. Please let me know if you think you need me and we'll take it from there. my Skype: vasilicutza Thanks!
$100 AUD 在3天之内
5.0 (11条评论)
3.9
3.9
用户头像
1 Apply formula in document 1 2 Apply formula in document 2 to get records into column H Feel free to contact me anytime.
$30 AUD 在1天之内
4.9 (11条评论)
3.7
3.7
用户头像
A proposal has not yet been provided
$30 AUD 在1天之内
5.0 (1条评论)
1.6
1.6
用户头像
I can do this excel work easily. I also have 10 years experience with excel and VBA
$80 AUD 在1天之内
5.0 (1条评论)
1.2
1.2
用户头像
Mechanical Engineer with Techno-commercial background and sourcing experience of over 10 years. Have experience of preparing programmed excel sheets for costing estimation for Automotive components & tooling.
$155 AUD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$77 AUD 在1天之内
5.0 (1条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
Thursday Island, Australia
5.0
11
付款方式已验证
会员自3月 25, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。