Find Jobs
Hire Freelancers

Create an excel macro to calculate revenue per patient over 30, 60, 90days and all time

$30-250 CAD

Completed
Posted over 5 years ago

$30-250 CAD

Paid on delivery
See spreadsheet for more information. the input data could have an indeterminate number of rows. sort by patient, then income category, then date, then item. if a patient does not have a row with 'Initial Visit - Full Time Student' or 'Initial visit - adult' or 'Initial Visit - Pediatric' or 'IV Therapy Initial Consult'associated with their name, delete all rows with their name. for each patient, under each separate income category, add the collected amount (for product, subtract the HST from the collected amount) for 30 days from the date of the initial visit (see date in column B), 60 days from the initial visit, 90 days from the initial visit and all time. average the 30, 60, 90 day and all time totals across all patients and income categories that have been in for an initial appointment. multiply the averages by 0.3 for treatment income, 0.2 for product income, 0.2 for IV income, 0.1 for lab income, 1 for point of sale income and mark these cells "NCMC take on 30 days", "NCMC take on 60 days" etc. do the same process but split it out indivually per staff member.
Project ID: 18344111

About the project

30 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

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:
User Avatar
I am proficient with Microsoft excel and macro/VBA development, I can write the macro to generate the report based on calculation depicted in your description. If you are interested feel free to message me, I am available to start your project immediately. Looking forward to chat further and work on your project.
$100 CAD in 3 days
5.0 (173 reviews)
7.6
7.6
30 freelancers are bidding on average $154 CAD for this job
User Avatar
Please review my profile as I have relevant skills and experience required for this project. Kindly send me a message to discuss further information. Thanks, Asad khan
$111 CAD in 3 days
5.0 (800 reviews)
8.4
8.4
User Avatar
Dear Employer, I completely understand your requirement. I will write a macro that will first discard the client if there is no row for that with values mentioned in the job Then it will calculate the 30, 60 and 90 days summision values for those clients and will multiple with multiplying factors. You might also think why to choose me for more cost then anyone nearly half of me, the quality is always little costly then cheap work. They have not earned more in total doing more number of projects than me. I only do quality jobs and charges fair for it :) Let me know!! Thanks and Regards, Ash
$222 CAD in 5 days
5.0 (294 reviews)
8.4
8.4
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. According to your brief, you want to have your records found in Input sheet manipulated (sorted, deleted, etc.) and transferred to Output sheet while this process has to be replicated for every employee. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed 269 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $200 and can deliver within a week (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$200 CAD in 7 days
5.0 (585 reviews)
8.6
8.6
User Avatar
Hello, Hope you are doing well. I can help with you in your project Create an excel macro to calculate revenue per patient over 30, 60, 90days and all time. I can assure you the quality job. I have good experience in Data Processing, Excel, Microsoft Office, Visual Basic. We have worked on several similar projects before! We have worked on 425+ Projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. Thanks,
$220 CAD in 3 days
4.9 (578 reviews)
8.5
8.5
User Avatar
Hello Sir Im excel VBa macro and formula Expert :) i can make calculator for calculate revenue per patient over 30,60,90 days and all the time please ping me and im free to discuss now Thank you Galih
$100 CAD in 3 days
4.9 (430 reviews)
7.6
7.6
User Avatar
Hi there,I am Miljan,Excel macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$180 CAD in 3 days
4.9 (177 reviews)
7.9
7.9
User Avatar
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, they speak for themselves. Best regards
$150 CAD in 5 days
5.0 (337 reviews)
7.5
7.5
User Avatar
I can create for you a KPI Analysis Module in Excel to calculate sales performance based on chosen parameters. The performance reports show results per period, person, working group and company levels. during the process, Excel validates the information, creates a structured database and pivot tables which enables to develop templates reports independently. About me: I am a financial expert and a guru in Excel/VBA/Macro. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I develop financial modules and financial projections including business valuation & terminal valuation methodology & ratios (INPV, IRR, DSCR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.) Furthermore, I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.
$250 CAD in 3 days
4.9 (96 reviews)
7.5
7.5
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.
$200 CAD in 3 days
5.0 (187 reviews)
7.0
7.0
User Avatar
Hello? How are you? I have good experiences in "Create an excel macro to calculate revenue per patient over 30, 60, 90days and all time" as you can see my profile for these (Data Processing, Excel, Microsoft Office, Visual Basic). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$155 CAD in 3 days
4.8 (98 reviews)
6.7
6.7
User Avatar
Hello, sir. I can start to work in your project immediately. Please contact me, So we can discuss more over chat.
$200 CAD in 3 days
4.9 (100 reviews)
6.5
6.5
User Avatar
Hi I am a very experienced statistician, data scientist and excel programmer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$300 CAD in 3 days
4.7 (90 reviews)
6.9
6.9
User Avatar
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project I've downloaded and Check the file, I think I need a little tour thru the sheets. I can speak English and Spanish. My time zone is GMT-6 (one hour before eastern)
$90 CAD in 3 days
5.0 (62 reviews)
6.5
6.5
User Avatar
Hello, I am Excel and VBA expert. I can start now adnd finish at one day. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
$100 CAD in 1 day
5.0 (98 reviews)
6.2
6.2
User Avatar
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully and checked attached file. I will create vba program to accomplish you requirements fully automated. It will populate data from starting row to indeterminate number of rows. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$120 CAD in 3 days
4.8 (140 reviews)
6.2
6.2
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary (e.g. multipliers by income category). In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I am a full-time freelancer, I can start working on the project immediately. If you open a chat I can send you a working mockup. Regards
$88 CAD in 2 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi; I can develop a macro to create the report you have specified. As for my background, I am professional VBA coder and Excel modeler with over twenty years experience. Please click on Portfolio link to see samples of my work. Your questions are welcomed. Regards Zenon
$100 CAD in 2 days
4.9 (35 reviews)
5.7
5.7
User Avatar
I have a, If you offer this work I can assure that you will hire me again for your next work. Also based on your requirement we can customize as many times until you are satisfied.
$80 CAD in 2 days
5.0 (6 reviews)
2.9
2.9
User Avatar
Hello, I have experience developing similar macros for businesses and would love to help you out with this. I have built programs for online sellers that analyze the products they sell to help them manage their inventory. I can show you example work if needed. Please message me back so we can discuss in more detail.
$111 CAD in 3 days
5.0 (1 review)
2.8
2.8
User Avatar
I have recently performed work related to this project and I look forward to be working with you soon.
$250 CAD in 3 days
5.0 (1 review)
2.0
2.0

About the client

Flag of CANADA
Guelph, Canada
5.0
17
Payment method verified
Member since Dec 14, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.