Đã Đóng

EXCEL REPORT - Need assistance with algorithms

Hi, I am currently working on a spreadsheet that calculates report figures including weekly and yearly totals of referrals coming in to the business.

I have used a template from the excel suggestions however the calculations in the graph section are not how I want them to be. I want the graph to show each column as a separate calculation. e.g. the weekly leads to be calculated in purple. the total leads to be highlighted in another colour and so on with the other columns. The algorithms are currently adding up everything as an average of ALL columns combined (even though they are colour coordinated).

I also want the percentage to be related to the 'total leads' only.

Also, can you correct the 'weekly leads' to add on top of the total leads. as every week the figures will change, it would work better if the 'total leads' is automatically calculating the full figure of leads added.

Kĩ năng: Excel, Xử lí dữ liệu, Statistics, Thuật toán, Nhập liệu

Xem nhiều hơn: mysql excel report, league soccer system excel report, generating excel report aspnet, excel report aspnet, generating excel report net, creative excel report samles, financial excel report garments bangladesh, convert excel report vb6, crm custom excel report, making excel report php, excel report mysql data using php, excel report script multi linked webpage, create dynamic excel report visual basic, need assistance oscommerce, excel report ppc performance, export excel report features

Về Bên Thuê:
( 0 nhận xét ) Fairfield West, Australia

ID dự án: #21768645

15 freelancer đang chào giá trung bình $27 cho công việc này

aimefx

Hi, I am an expert in Excel, Access VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time Thêm

$30 AUD trong 7 ngày
(78 Nhận xét)
5.9
daniyal3214

I can definitely help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro.

$20 AUD trong 1 ngày
(54 Nhận xét)
5.5
michael767

Hi I am also from Sydney and work on these types of spreadsheets all the time. If you have a look at my profile you will see that I have successfully completed projects similar to the one that you are currently working Thêm

$30 AUD trong 2 ngày
(6 Nhận xét)
4.0
samobot

I saw your spreadsheet and its pretty simple from my view. Kindly chat with me for more inputs required for me to make it possible as per your desire and few suggestions from my side. "I have 10+ years of experience w Thêm

$10 AUD trong 2 ngày
(6 Nhận xét)
2.8
Saimi786

Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully and I am very interested in your project. I am sure that I can finish this project Thêm

$29 AUD trong 7 ngày
(2 Nhận xét)
1.8
maurineted5

Hello I am an experienced Academic Research paper and Business report/plan writer. My expertise includes: Project Management, Python, R-Programming and Matlab Coding. Education: I have done Masters in Business marke Thêm

$55 AUD trong 1 ngày
(1 Nhận xét)
1.0
Banze

Dear Sir, I understand your project description. I think you want a person for your project who expert in Data Colletion I think there is no detailed discussion of the work here. So, we can discuss more work? Firs Thêm

$20 AUD trong 7 ngày
(0 Nhận xét)
0.0
peternjoroge37

I am a Professional Accountant and a writer with 6 years of experience in both. Among the areas I am more and comfortable in includes copywriting, technical writing, excel sheets, marketing, Law, Accounting, Architectu Thêm

$10 AUD trong 1 ngày
(1 Nhận xét)
0.0
amitav5panda

I have Excellent communication skills to connect effectively with customers and co-workers Possess a positive attitude and ethics which support our values and culture. Also I am expert in MS-Office and other tools like Thêm

$20 AUD trong 7 ngày
(0 Nhận xét)
0.0
writingstudio22

Hey How are you ? I can deliver you quality work as per your instructions. I ll never let down to my clients. Thanks

$100 AUD trong 2 ngày
(0 Nhận xét)
0.0
ashsingh1094

Hi, Please accept this application as formal proposal do the job for you and become your long term partner for all similar jobs as well. We always provide 100 % quality results. I have never let anyone down. You can s Thêm

$10 AUD trong 7 ngày
(0 Nhận xét)
0.0
SOUKAINAOHNIFER7

bonsoir mr je suis interesse pour ce travaille dans une durée du 5 jours avec magnifique presentation

$20 AUD trong 5 ngày
(0 Nhận xét)
0.0
DeltaIntelitech

Dear Client, I hope you are doing well! I understand you need an excel based template that can show sales person wise total incoming referrals. My name is Ajay and I am good at creating similar templates using excel a Thêm

$22 AUD trong 7 ngày
(0 Nhận xét)
0.0
WillianComenalli

Dear, I would like to express my interest and the opportunity to apply my expertise in the industry. When reviewing the job description, I was thrilled to discover how well my experience aligns with your needs and requ Thêm

$20 AUD trong 7 ngày
(0 Nhận xét)
0.0
nurulsyahera79

Hello Sir, I am writing in response to your advertisement. After carefully reviewing the skill requirements of the job description, I feel that I am a suitable match for the job. I’ve held several data entry positions Thêm

$10 AUD trong 7 ngày
(0 Nhận xét)
0.0