Find Jobs
Hire Freelancers

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

£250-750 GBP

Đã đóng
Đã đăng vào khoảng 6 năm trước

£250-750 GBP

Thanh toán khi bàn giao
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.
Mã dự án: 16567713

Về dự án

21 đề xuất
Dự án từ xa
Hoạt động 6 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
21 freelancer chào giá trung bình £497 GBP cho công việc này
Avatar người dùng
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 trong 10 ngày
4,9 (17 nhận xét)
5,2
5,2
Avatar người dùng
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 trong 10 ngày
5,0 (19 nhận xét)
5,3
5,3
Avatar người dùng
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 trong 6 ngày
5,0 (14 nhận xét)
4,9
4,9
Avatar người dùng
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 trong 5 ngày
4,7 (36 nhận xét)
5,3
5,3
Avatar người dùng
Excel VBA Expert. Developed 100+ macros since last two years. Expert in data handling and business model making.
£555 GBP trong 5 ngày
4,9 (8 nhận xét)
4,2
4,2
Avatar người dùng
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 trong 10 ngày
5,0 (2 nhận xét)
3,6
3,6
Avatar người dùng
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 trong 10 ngày
4,9 (12 nhận xét)
3,8
3,8
Avatar người dùng
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 trong 10 ngày
5,0 (5 nhận xét)
3,5
3,5
Avatar người dùng
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 trong 10 ngày
5,0 (2 nhận xét)
3,6
3,6
Avatar người dùng
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 trong 5 ngày
5,0 (2 nhận xét)
1,9
1,9
Avatar người dùng
A proposal has not yet been provided
£255 GBP trong 5 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 5 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
- 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 trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED KINGDOM
United Kingdom
0,0
0
Phương thức thanh toán đã xác thực
Thành viên từ thg 3 26, 2018

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.