Закрыт

Over hours Allowed

Job Description:

I want to share with my manager something more professional, while providing him with all the information he needs but in one worksheet. I'd like to keep track of the information daily, total of the weekend ending, and the total for the month. Each manager must input the information daily for each belt which calculates the hours and act volume per belt, each loader should be planned at with a PPH of 180 which you'll see on sheet number 3, which on the daily dashboard or total should automatically calculate from the employee sheet. You'll see on sheet 3 I have it set as purple belt but I need all the belts to have their individual information which you'll find all the belts and employees under the employee sheet. Also I am including an Addaline that I also need, but i am not sure if we can input it in here or if it will be too much. The Addaline is on sheet 5 and 6, I am including another attachment so you can get on idea of what i want on the Addaline that includes the total freq of the overall Volume as you input it daily, it goes updating the total w/e feb 4th, he wants to just look at one sheet and have everything he needs, as the other managers go in daily and put in the information he is requesting. Please keep in mind when inputting the Addaline it must each contain its individual sides, one addaline will have blue brown purple and red, the other wil have green, pink, orange, and tan. The ultimate goal is to see the planned vs the actual, productivity, he wants to hide the LOAD PPH from the other managers but where we can edit it. I included most formulas of more or less what we are looking for. On sheet 4 I inputted a video of more or less what I'd like to show him, but I'd also like to see one a little more simplified if possible. User friendly for all, lock cells the no one can touch except of course myself or the person editing it. Not sure if I explained myself correctly or missing details. Please feel free to reach out! Thank you!

Навыки: Обработка данных, Бизнес-анализ, Управление проектами, Бизнес-планы , Excel Macros

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

ID проекта: #35905595

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

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 Больше

$15 USD / час
(364 отзывов(-а))
8.2
daniyal3214

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto Больше

$15 USD / час
(131 отзывов(-а))
6.7
arslanu2

Hi! We are a professional accounting firm having seven years-long exposure in the accounting field. Our team also includes professionals from high-end qualifications like Chartered Accountancy. We handle clients for a Больше

$15 USD / час
(60 отзывов(-а))
6.2
hamidr2020

Hello, I am an Excel and VBA/Macro expert. My expertise includes Accounting and Analysis. I have checked both Excel files attached and also watched the video. I have also read the requirements thoroughly. It would be g Больше

$11 USD / час
(69 отзывов(-а))
6.0
professorxwriter

Budget is negotiable and I will provide a free sample for you before you hire me as a gesture towards my impeccable expertise and professionalism. Hi, I can do it in the next few hours by working on it right now. Messa Больше

$12 USD / час
(8 отзывов(-а))
4.2
dheerajjshetty19

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Accounting Lets connect in chat so that We discuss fu Больше

$8 USD / час
(13 отзывов(-а))
3.2
freelancerabdu34

Hi there, I'm an experienced Cost & Management Accountant (CMA) and Advanced Level Excel expert and will do it IN THE NEXT FEW HOURS. Can we discuss more details about this project? If you are interested, feel free to Больше

$10 USD / час
(4 отзывов(-а))
1.3
rajuvakil143

"ACCOUNTING/FINANCE/BOOKKEEPING/ "Sir, I am ACCOUNTING, FINANCE, TAX, PAYROLL, BOOKKEEPING, FINANCIAL STATEMENTS Advanced Level Expert. This is my field and I can complete this project.

$12 USD / час
(0 отзывов(-а))
0.0
monurao7677

My work is make me different me from others. Because people work for money but I work for client satisfaction only .

$12 USD / час
(0 отзывов(-а))
0.0
kcjoyferrer7

Hi , I'm KC Joy, and I'd love to do this kind of works. I'm a great fit because I'm self motivated and hard working individual. I believe in customer satisfaction, quality work and i'll complete the given task on time. Больше

$8 USD / час
(0 отзывов(-а))
0.0
kveajedor

Hi I have been creating dashboards for executives in my company and I believe that I can deliver this job that you require. I am offering a low hourly rate since I am just starting freelancing but definitely not an en Больше

$12 USD / час
(0 отзывов(-а))
0.0
muhammadakram676

Hi According to your mission description, I am assured that the phrase can be finished precisely and on time. It is my delight to make you happy. It is my pleasure to bid for your job, and I will supply in the shortest Больше

$10 USD / час
(0 отзывов(-а))
0.0
rudrarishishukla

Hello, though it will be my first project on this site, I have rich experience over 15 years in Excel data entry (Manual),Preparing Excel Dashboard and Reporting tools in Excel. Please award me the project, I’d be plea Больше

$15 USD / час
(0 отзывов(-а))
0.0
shriankpatel

Hi, I am an economics graduate with a deep understanding of statistics principles and methodology. Along with this I am well-versed in Machine Learning algorithms which makes me an ideal partner for your project. Furt Больше

$12.5 USD / час
(0 отзывов(-а))
0.0
nasir01812

I have six years working experience as a global entrepreneur . currently i am working with 25 countries stakeholders . As a Founder of non profit NGO I have sufficient experience in dealing with different project . i Больше

$12 USD / час
(1 отзыв)
0.0
isham688

10 year experience in Mechanical and Electrical Maintenance. 6 months of experience Occupational Health and Safety Technician. Diploma In Mechanical (Marine) Engineering. An exceptional planner who demonstrates incredi Больше

$12 USD / час
(0 отзывов(-а))
0.0
deepakpatel23075

got a job from one of my clients in the past for which I paid $100 and they loved my work i am from indore india

$12 USD / час
(0 отзывов(-а))
0.0
lalitranwa030

I am able to work and I am also good at it and I will give my 100 percent to it and give my full attention to it Thanks

$12 USD / час
(0 отзывов(-а))
0.0
RaineyyyXII

I thrive in a challenging environment and utilize my persistence, eye for the details and resourcefulness to solve problems. I have the ability to acquire and assimilate new information quickly and effectively making m Больше

$12 USD / час
(0 отзывов(-а))
0.0
manahilendless

I am very talented boy and I will complete your work time to time and my accuracy is 80% I will work your last time

$12 USD / час
(0 отзывов(-а))
0.0