Help with Excel spreadsheet - Formulas/Macros

$30-250 AUD

Completed

Posted

over 5 years ago

$30-250 AUD

Paid on delivery

Project Brief – Excel Budget & Reconciliation Assistance with formulas/macros - maybe VBA but not sure. Please note: project needs to be finished by 07/12/2018 - Create drop down categories under the main worksheets (Core, Capacity & Capital) so when an invoice is entered against that support category, the running total is correct as per the dashboard. - Put bar graphs on the NDIS Dashboard to calculate the ‘burn rate’ of funds over the course of 12 months for each category of Core, Capacity & Capital (using the support amount to the expenditure) - Automate the cell highlight once the Support Amount (dashboard) is within $500 of the Remaining Balance - Bringing across (populating) the support balances in dashboard to the forecast tab under ‘Support Income’ - Forecast tab: Enter a formula that allows the user to calculate over the cost of a week/month/year etc. - Protect cells that have formulas in them; other areas to be edited as per participants plans/budget - Hyperlink on worksheets Forecast, Core Supports, Capacity Building & Capital Supports to click back to Dashboard worksheet

Data Processing

Excel

Visual Basic

Visual Basic for Apps

Project ID: 18289576

About the project

7 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@informatikz

Hi, hope you are well. We are in Brisbane. Your requirement can be done through excel formulas (Sumif, Vlookup, Index Match) Please refer the comments we have received from our previous client (who is from Sydney) regarding an excel based employee timesheet which captures the time span to calculate pay rates. A little bit about our selves..., We are two management accountants (CPA, ACMA, CGMA), full time employed in Australia. Our service priorities are; 1. Complete information security - We value your information as you do. 2. Highest Quality - Professional service is guaranteed. 3. 100% Accuracy - We apply only if we are capable to do it. 4. On time delivery - We value your time. 5. Flexibility - We are open for modifications, changes and improvements. We are new to this website, therefore we provide services for a competitive price as we need your feedback and reviews to grow our business. Please refer our LinkedIn profiles for more information. Ranga - [login to view URL] Sachith - [login to view URL] We are looking forward to hearing from you. Yours faithfully, Sachith J. informatikz Team

$100 AUD in 2 days

4.1

(2 reviews)

1.7

7 freelancers are bidding on average $96 AUD for this job

@kevivu

I am from NYC, NY, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Expert in PYTHON,.NET, VB, VBA, MYSQL, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Large scale application development, Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, etc., Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Looking forward to hear from you soon. Have a great day. Thank you.

$66 AUD in 2 days

4.8

(74 reviews)

5.9

@c4cuteconain

I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.

$100 AUD in 3 days

4.8

(39 reviews)

5.1

@dataexplorer

"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as keep you returning consistently. It is because of the importance behind this field that I am confident & serious when taking these types of projects. Let me introduce with professionalism and skill that exists to supply the best. Regards"

$150 AUD in 3 days

4.9

(17 reviews)

3.9

@Mokshith30

Hi I am Mokshith Expertised in Web Scraping & VBA Macros.. i can do any excel automation tasks, bulk email handling using outlook,File Conversion i can "SCRAPE" any website either static or dynamic also.. & in addition to VBA i can do Python programming, Google Apps Script coding, Wordpress Developement, HTML, VB.Net, PHP, Javascript & css, Ecommerce Wordpress Sites Developement. I will do this task in a Day Only.. Thankyou~

$50 AUD in 1 day

4.9

(10 reviews)

3.0

@nvchien94

I am an Excel expert. and I can help you to solve your task. I am so free right now so I can complete it soon. Contact me and I will discuss further. Thanks

$49 AUD in 2 days