Find Jobs
Hire Freelancers

Excel Macros - Create a monthly report and payment application using info on SharePoint and Primavera.

£250-750 GBP

已关闭
已发布大约 6 年前

£250-750 GBP

货到付款
Looking for some coding / excel support to assist with a routine monthly report for projects which we run. The output will be a excel template . macro that pull the info together and automatically works out key project management measures (SPI/CPI) and also fills in a standard monthly payment application form. The system will allow a data inputter to do this in the future. The business has a time booking system which uses SharePoint and wanting to combine these hours booked info along with an agreed rates to create a monthly payment application (may need to link the persons name (SharePoint) to a role to determine the applicable rates). Standard template is available. Also along side this looking to use a cost forecast which is taken from the Primavera planning tool (can be downloaded to excel) to begin to create ACWP Vs BCWP & BCWS so figures such as SPI and CPI can be worked out. The ideal solution will be to take the 2 excel sheets from the different areas and have a macro button that pulls the info across and the key pieces of info are worked out, providing a application for payment certificate and secondly the monthly progress report matrices.
项目 ID: 16567713

关于此项目

21提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
21威客以平均价£497 GBP来参与此工作竞价
用户头像
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
£500 GBP 在10天之内
4.9 (17条评论)
5.2
5.2
用户头像
Hi there..... Warm Greetings We came along with your request for Excel Macros and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Coding, Excel Macros We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
£500 GBP 在10天之内
5.0 (19条评论)
5.3
5.3
用户头像
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. I am also a certified PMP and have the understanding of the ACWP Vs BCWP & BCWS, SPI and CPI. Willing to take up your project. Thank you, Regards.
£600 GBP 在6天之内
5.0 (14条评论)
4.9
4.9
用户头像
I am an Excel macro expert. I have a lot of experience in creating automation tools. Feel free to contact me so we can discuss the details of this project.
£500 GBP 在5天之内
4.7 (36条评论)
5.3
5.3
用户头像
Excel VBA Expert. Developed 100+ macros since last two years. Expert in data handling and business model making.
£555 GBP 在5天之内
4.9 (8条评论)
4.2
4.2
用户头像
Hi, I have read very carefully your project details about creating an Excel Macros for monthly report and payment application. I am absolutely sure that I can complete this project professionally. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I will complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! Hope to hear from you soon
£555 GBP 在10天之内
5.0 (2条评论)
3.6
3.6
用户头像
Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
£500 GBP 在10天之内
4.9 (12条评论)
3.8
3.8
用户头像
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
£600 GBP 在10天之内
5.0 (5条评论)
3.5
3.5
用户头像
Dear Employer, I am an Excel/VBA/Macro expert with 10 years of experience and have delivered several projects. Please give me this opportunity to write this macro for you. Job will be done with Excellence. Thanks and Regards, Ash
£444 GBP 在10天之内
5.0 (2条评论)
3.6
3.6
用户头像
HI I am an expert in excel and have worked in creation of various complex macros and dashboards. I have worked in analytics for the past 3+ years and have created many dashboards using various tools. Thanks Regards vaidy
£388 GBP 在5天之内
5.0 (2条评论)
1.9
1.9
用户头像
A proposal has not yet been provided
£255 GBP 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have studied all the about your job posting on data entry project just moments ago. i promise you that i will be able to submit your task before your timetable with quality work. Relevant Skills and Experience I am fully expert in web research, extracting email, data mining, Google, Bing, yahoo, MS office(full version), Google Document, Google spreadsheet, Analytics,and all king of other related program.
£250 GBP 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
- Have expertise in Excel advanced programming and features. - Can get the KPIs from the sharepoint sheet, and also have the tracked hours calculate the payments per the rate card. - Similarly the cost forecast based no the Primavera can be plugged in to get the different stats like ACWP Vs BCWP, BCWS etc. - Have done similar project reporting from Shareporint data, providing a Weekly Report of all different projects, key tasks and their status (RGB). (Freelancer project). - Project costing based on hours ticked by employees in consolidation with the Ratecards can be calulcated. - Will provide buttons to make it easy to access the functionality and get the reports. - Based on the Payment applicaton, template the file columns could be arranged so that the data can be uploaded from the Excel file for payments. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Pl. review my portfolio on recent projects.
£400 GBP 在7天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
United Kingdom
0.0
0
付款方式已验证
会员自3月 26, 2018起

客户认证

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