# PHP Expert Needed for Formula Improvement on our Dashboard

We have a dashboard that pulls magento sales into a leaderboard that shows sales for the previous day, current week, quarterly, monthly and yearly. One of the features is a section called PACING. This section shows, based on previous sales, what they are on pace to sell for the week, month, quarter, and year. Here is the issue:

The week runs Monday through Sunday. Sales are very high Monday through Friday but drop substantially on Saturday and Sunday. Sales are about 25% of the volume on saturdays and sundays compared to mon through friday. So if we have sales of \$20k total on Mon - Tues, a simple equation of (\$20k / 2) x 7 will not work. The pacing will be too high because Saturday and Sunday will have the mentioned decline. My next solution was taking 76% of daily sales. But this formula fails as well:

((total sales / # of days sold) x .768) x 7

that works earlier in the week, but as the week gets later, the formula fails because pacing actually falls BEHIND the total sales. In that scenario, imagine we have sold \$60k through Saturday:

((60,000 / 6) x .768) x 7 = 53,760

See above? the pace is actually LOWER than the actual sales total.

The easiest way to do this would be simply take the daily average of the week and anticipate Saturday and Sunday will be 25% of the average. But the current coder has not made formulas set up to recognize the difference between monday - friday and sat / sun. He just uses one generic day in formula.

I am looking for someone that can help us creating pacing formulas that will recognize in our admin when we set a date range, how many days are mon - friday week days and how many weekends sat / sun are in the date range and build a formula like:

(take total sold / total amount of days sold) x total amount of days in period but then be able to know how many WEEKENDS are in the future of time range and count those with anticipated 25% of daily average sold.

see screenshot of calendar / date scraper we use.

Evner: PHP, Magento, MySQL, JavaScript, HTML

Om arbejdsgiveren:
( 1 bedømmelse ) Wesley Chapel, United States

Projekt ID: #28197364

## 26 freelancere byder i gennemsnit \$184 timen for dette job

(496 bedømmelser)
8.4
(640 bedømmelser)
8.0
(434 bedømmelser)
7.8
techwelfare

PHP EXPERTS! We are working on php since last 11 years. We could do it. Could we discuss in details over chat now? Best Regards Simla

\$200 USD in 12 dage
(205 bedømmelser)
7.3
zyeloncomputech

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can do your Formula Improvement on your Dashboard form your magento store - creating pacing formulas that will re Flere

\$250 USD in 7 dage
(227 bedømmelser)
7.1
(63 bedømmelser)
6.5
crystalhitesh

Dear Client, It's great to speak with you about your new project..!! With more than 7 years of experience in all framework of PHP(Laravel/Yii/Codeignitor/Zend) Here, I mentioned last performed work by me, please rev Flere

\$200 USD in 4 dage
(147 bedømmelser)
6.6
sapnathakur14

Hello, Warm Greetings!!     I read your job description completely and I found my skills relevant to your project. I am a professional web developer with 5 years of programming experience for a multitude of different t Flere

\$200 USD in 3 dage
(12 bedømmelser)
6.4
zamsol

Hi, We work in a LAMP stack environment and have full stack developers here with us, please have a look of references. PHP Programming: - Custom programming - Framework o Larval o CodeIgnitor o Zend Framework o Cake Flere

\$220 USD in 7 dage
(23 bedømmelser)
6.2
inviSystems

Dear Client, I have been providing my services and support as a Magento developer since 2013. I have designed and developed around 50+ high profile E-Commerce websites in Magento. I have understood the project detai Flere

\$250 USD in 7 dage
(25 bedømmelser)
5.5
devbaloni1983

Hi, Hope you are doing great, I have 15 years’ experience in development! .I am ready to build a website for your business. Allow us to work for you, We can give you best possible work in minimum time. Kindly ping me Flere

\$140 USD in 7 dage
(37 bedømmelser)
5.2
Devrits

Hi, I've been developing web applications for more than 5 years, starting back in 2013 with custom PHP/MySQL, no framework project, switching my focus onto ZF1 in 2013-2014 and now focusing on microframeworks like sil Flere

\$250 USD in 4 dage
(23 bedømmelser)
5.5
overtservices

Hello, I have gone through your requirements carefully but I have to discuss some point with you. I have check your attachment also. After that I can improve the formula on dashboard as you want. I have 9+ years of e Flere

\$150 USD in 3 dage
(54 bedømmelser)
5.6
grabovikmaran

Hello, I read your description in detail. I have experiences at web security and can help you. I am very excited on your project, and I am ready to start work immediately. I have skills: php and python I am very experi Flere

\$140 USD in 7 dage
(40 bedømmelser)
5.5
BryarGH

Hello dear; PHP Expert, Formula, I can make it for you my dear; Let us discuss more about it :) So I have read your detail but still have a few questions I hope you explain to me.. I'm serious and I can do it for yo Flere

\$120 USD in 2 dage
(31 bedømmelser)
5.1
umer6316326

Hi there, Its a pleasure talking to you! I would like to work on this project as i got interested and think myseld much suitable to work on it as am a senior Laravel developer having expertise in Laravel and its mi Flere

\$155 USD in 7 dage
(16 bedømmelser)
5.3
alexeydanilovfr5

Hello. Dear. Hope you are doing great. And Thank you for your kind job description. Reading your job description, I am feeling I am the most suitable developer to take this job on. Now I am understand what the issue i Flere

\$150 USD på 1 dag
(9 bedømmelser)
4.2
kalininexp

Dear shane I am laravel expert over 3+ experience. So, I'm confident about your project and I will deliver the Quality results Quickly. Currently, My timezone is very flexible for you. Feel free to discuss more detail Flere

\$250 USD in 7 dage
(3 bedømmelser)
3.8
service199026

Hello! sir I read carefully your offer. I know you need fix a dashboard that pulls magento sales into a leaderboard that shows sales for the previous day, current week, quarterly, monthly and yearly. Your algorithm is Flere

\$140 USD in 7 dage
(1 bedømmelse)
2.5
rachelfan9

Hello, I am good web developer. I have much experiences with PHP. So, I can do your project. Please contact me and discuss more. Thank you.

\$250 USD in 7 dage
(2 bedømmelser)
2.2