Find Jobs
Hire Freelancers

Summary and Totals (Geographic Breakdown)

$10-30 CAD

Closed
Posted about 5 years ago

$10-30 CAD

Paid on delivery
I have an excel sheet with rate code, state and membership type. I would like to see the top 25 rate codes and their geographic breakdown per state in a separate tab and a geographic breakdown per state for membership in a separate tab. I'd like 3 tabs as listed below. 1st one is data (which will be manually updated with new information as days go by) 2nd is the results for the top 25 rate codes and their geographic breakdown 3rd is the results for geographic breakdown per membership. Here is a rough example of what I am looking for.
Project ID: 18885104

About the project

23 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
23 freelancers are bidding on average $27 CAD for this job
User Avatar
Greetings! I understand the requirements and come up with required macros to automatically update the 2 report tabs based on data in "Data Entry" tab. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the files - I would update as required. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$30 CAD in 1 day
5.0 (220 reviews)
7.0
7.0
User Avatar
I can sho top 25 rate codes and their geographic breakdown per state in a separate tab and a geographic breakdown per state for membership in a separate tab
$50 CAD in 1 day
5.0 (96 reviews)
6.6
6.6
User Avatar
I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel.
$25 CAD in 1 day
4.8 (133 reviews)
6.8
6.8
User Avatar
Hello there, I am an Excel VBA expert wiith 4 year+ experience in coding. I can start the work right now if you agree. Please contact me soon. Thank you.
$20 CAD in 10 days
5.0 (235 reviews)
6.6
6.6
User Avatar
Hi, I can create the 2 sheets that you described using pivot tables. The advantage of using them is that when you update the data source the 2 sheets data will be automatically updated with one click, is error proof and is faster compared with formulas/VBA. Best regards, Florin Enache
$30 CAD in 1 day
5.0 (23 reviews)
5.7
5.7
User Avatar
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$25 CAD in 1 day
4.8 (38 reviews)
5.3
5.3
User Avatar
I am experience SPSS, Minitab. Stata, Excel. Presentation, Power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. You may go through Finance Trading Statistical Analysis, Academic Research Paper and Water Bottle Market Survey file (https://www.freelancer.com/u/EngrShahidul.html), for my relevant skill please. Let me know your data and objective of study (requirement of analysis), so that I can think of job.
$30 CAD in 1 day
4.9 (66 reviews)
5.3
5.3
User Avatar
Hello, I'm interested in your project on excel tables. Please send me a message and let's discuss your project in details. Thanks.
$30 CAD in 1 day
5.0 (38 reviews)
5.3
5.3
User Avatar
Hello, i am interested in this project , can begin now waiting your answer on chat Regards
$24 CAD in 0 day
5.0 (68 reviews)
4.8
4.8
User Avatar
My prorposal I have read your project description "Summary and totals" and I am confident that i can do this. I am 100% sure that I can meet your expectation. Also, I will priotize deadline and review work for as much as possible if need be. I will be more than happy if you can please consider me for this work of yours and I will try my best so as not to disappoint you Thanks
$10 CAD in 1 day
5.0 (1 review)
2.3
2.3
User Avatar
hello sir, I had read your job description I am interested in your work... I have a lot of one year experienced. I would like to apply for this hourly job. Please accept this letter as the application for this position. You can contact me Thanks a lot.
$25 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hola Soy nuevo en Freelancer, y necesito mi primer proyecto. Soy muy responsable y además manejo perfecto Excel. Puse 5 días, no porque no lo pueda hacer antes, sino, porque quiero hacerlo perfecto. Relevant Skills and Experience Además de ser operador, manejo muy bien en Excel. (Llegue a manejar una flota de Camiones, con 10 pestaña distintas para cada camión)
$30 CAD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
En attente de votre réponse Cordialement
$55 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a financial advisor currently working with one of the biggest 4 financial service companies in world. Holding a dimploma in international financial reporting and ACCA. Professional user of excel Relevant Skills and Experience I am a financial advisor currently working with one of the biggest 4 financial service companies in world. Holding a dimploma in international financial reporting and ACCA. Professional user of excel
$15 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
HI, I had been working in Finance department for 4 years in different areas like Accounts, Taxation and MIS. So I am intensively working on excel and while preparing MIS , i'll work on similar type of works.
$31 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
• A competent professional with 6 years of experience in the field of MIS Reporting, Transaction processing, Reconciliation and Process Management across the tenure • Strong knowledge in MS Office Relevant Skills and Experience VBA Scripting and advanced excel
$25 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can provide you the required project in 1day with 100% accuracy. request you to contact me for further discussion regards
$20 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I suggest a pivot table solution. This will give the fastest update of the 3 output tables, though the output will be slightly different from the given example, but the output contains all the requested information and also be easily readable. Pivottables also can be nicely and easily formatted if this is also a requirement. There is one more point which needs to be mentioned: if the same total value repeats at the 25th place, the table will show all the ratecodes with the same total value. As per original requirement you asked for top 25, but it might display more. It is the same as in a sports, if 5 people gets the same time in running, all 5 will be on the 1st place. If the output needs to be the exact format as in the example, vba is needed for the 2nd tab, which takes more work, and my current bid does not cover. Best regards, jmpcoder
$25 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi, please send me the details we can get this done ASAP. thanks Sarath
$10 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i have the file prepared. i am new here and not sure how to send it over. If you like the file i can take anything you offer.
$25 CAD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Calgary, Canada
0.0
0
Member since Mar 6, 2019

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.