Закрыт

Easy Excel formula

Job Description:

I need an excel sheet where I can type in twenty names in 20 rows.

In the first column is the sales person name.

in the third column is their sales goal for the month. For example, $31,000.

In the second column is an automatically updating daily goal based on how they did the day before.

For example, if they sell $1,250 on the first day of a 31 day month, their daily goal to sell for the 2nd of the month will be: $31,000 - $1250 = $29750, $29750/30(days left in the month) = $991(amount needed to be sold every day to hit their goal).

Then as their sales come in each day, there's a spot to enter their new sales number for the previous day to update the new daily sales goal number.

Навыки: Excel, Ввод данных, Обработка данных, Visual Basic

О клиенте:
( 0 отзыв(-а, -ов) ) Fountain Hills, United States

ID проекта: #35400906

51 фрилансеров(-а) готовы выполнить эту работу в среднем за $22

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Больше

$70 USD за 2 дней(-я)
(568 отзывов(-а))
8.5
P0L

Hello, I am an Excel expert and I can help you right away. Please send me a message so that we can discuss more.

$30 USD за 1 день
(502 отзывов(-а))
8.0
hdlong66

Hello, I can assist you to write an Excel formula that calculates daily goal based on how they did the day before. I'm ready to start. Please drop a PM if you’re interested. Best regards, Hoang

$30 USD за 3 дней(-я)
(183 отзывов(-а))
7.2
SShtv

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m Больше

$30 USD за 1 день
(126 отзывов(-а))
6.6
AutomationAdept

Hello! I've actually done something similar using Google Sheets to track stats for a client that needed the sheet for a game he played. I should be able to have a sheet up and running for you in no time at all. The fu Больше

$30 USD за 1 день
(50 отзывов(-а))
6.2
hamidr2020

Hello, I am an Excel and VBA/Macro expert. I offer my services to create Excel worksheet / formula that automatically update daily goal based on monthly sales goal and how they did the day before. You can check my re Больше

$20 USD за 1 день
(74 отзывов(-а))
6.0
fanninson45

I can create this Excel formula in no time. Getting this project started is a message away. SIMILAR PROJECTS I COMPLETED • https://www.freelancer.com/projects/microsoft-access/Microsoft-Access-VBA-Application/ • https Больше

$25 USD за 7 дней(-я)
(4 отзывов(-а))
5.5
IgeS

Hi there, I believe what you're looking for is some kind of a running balance formula. Please message me. I'll be standing by to help. -Ige

$15 USD за 1 день
(47 отзывов(-а))
5.4
iamhamzazaki

Hello, I can create excel formula I'm a former CP (competitive programming) competitor, I'm a master at algorithms and could help you solve your problem quickly with clean, optimized and well-commented code.

$20 USD за 1 день
(16 отзывов(-а))
4.3
iqmax99

Hello, I would like to work with you on your project. About Me: Be assured to receive quality work. I have been programming for tens of years. Please check my profile on the site at: https://www.freelancer.com/u/i Больше

$12 USD за 2 дней(-я)
(25 отзывов(-а))
4.1
arunkumar9896

Hello, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Больше

$20 USD за 1 день
(15 отзывов(-а))
3.9
Leozida

Hi There, Hope you are doing well, Interested in your posting as I’m used to performing such projects (See Profile). Already drafted as per your requirement (i.e. when you enter new sales number for the previous, updat Больше

$20 USD за 1 день
(25 отзывов(-а))
3.8
AhDardear

Dear, I have reviewed your Excel Sales Sheets requirements carefully, I believe I am your perfect candidate and it's my pleasure to apply and offer my services. I am a certified data analyst with 10+ years of experie Больше

$20 USD за 7 дней(-я)
(10 отзывов(-а))
3.1
akibul18

Hey there, I am an Excel and VBA expert and have been working on it for more than 5 years. looking forward to getting a message from you, that's why we can proceed further. Thanks

$10 USD за 1 день
(3 отзывов(-а))
2.2
mwikalicarolyne2

Hi there! I have vast experience in Data Entry, Excel, Visual Basic and Data Processing, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a ful Больше

$10 USD за 1 день
(0 отзывов(-а))
2.3
miijaz

Greetings, I understand that you want Easy Excel formulas, so wondering, if you can please share some more details or can you click on chat button to discuss requirements of your project? For now, ignore the bid amoun Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
Luceeanne

I have extensive Excel knowledge and experience, able to provide the finished product to you in 1 working day or under.

$25 USD за 1 день
(0 отзывов(-а))
0.0
deocorpltd

Hi, I am an Excel Expert. I understand how to work with Excel formulas as well as other Excel operations. Chat me up so we can discuss further. Best regards, Emeka

$20 USD за 1 день
(0 отзывов(-а))
0.0
muhammadaliaqeel

I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 years Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
Mdshakaoual

Hell, I've been doing data entry for 4 years. So, you can give me your work. I will do your work. Inshallah 100% benefit.

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0