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

Se mere: php expert needed, joomla expert needed, php scripts needed, php web scraping expert needed, php expert needed search engine, expert php programmer needed, wordpress jquery php integration expert needed, php ajax expert needed, php expert needed build job posting website, php ajax mysql google maps expert needed, joomla php expert needed, designer php expert needed, php sql expert needed, expert php developer needed, photoshop php codeigniter website builder expert needed, expert in core php & html needed - long term, expert in core php html needed long term, expert php help needed to fix and create

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)
(640 bedømmelser)
(434 bedømmelser)

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)

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)
(63 bedømmelser)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)