Đang Thực Hiện

Excel Expert to Verify and Possibly Rewrite Program For Calculating and Tracking Efficiencies

We built a prototype program in Excel to calculate and track the efficiencies of knitters in our company in order to keep standards across the factory floor. It tracks 4 different types of downtime that knitters must enter into computers during their daily tasks. We use a program that tracks downtime and standard time each downtime is supposed to take. The program sorts the dumped data (from an SQL server) into time and which zone of the factory floor they are working in. The manager makes sure that the people are assigned to the correct positions. The program pulls the data from the data page based on name of employee (from an updatable drop-down menu) and sorts it into the appropriate sheet in the workbook. The program checks the times of the entries, compares them with other entries to determine if there is any downtime overlap with other machines and calculates that time out. It also checks the time of the activity against standard times that are adjustable from the settings page. It adds up any remaining time over the standard and from what is left after removing duplicate entries and provides a downtime. It then calculates the lost yardage based on machine speed and stitching pattern. It determines if the start of the downtime happens during a break and filters that into another category and doesn’t count it toward their efficiency. Anyone else that records these downtimes in this area gets segregated into a category by themselves. The program consolidates the information and creates a percentage of efficiency (100% means that each task is using only the standard time required for the tasks, no more, no less). All of the information, is shown on a dashboard display and individual reports are generated for each knitter based on their daily performance. The individual reports include a chart that give the percentage of activity that the knitter performed these activities (instead of other operators such as technicians)

The program is struggling in a couple of areas and require assistance.

1. Tracking multiple machines being down and only penalizing the knitter for one at a time has been a challenge. We probably need help rewriting this part of the system as it has gotten complicated and needs a sorting element that is beyond our skill to correctly complete.

2. The program was written by an amateur in excel. Therefore, much of the program is clunky and needs consolidation and a more efficient layout with the same function.

3. The program needs to be able to add downtimes to the program without much difficulty.

4. Report page that tells us average times and variance for different downtimes for only the knitters.

Things we would like to keep:

1. Adjustability of knitters and their work areas.

2. Adjustability of downtime standard times

3. Easy usability. We would not like to do more than dump the data and click a button to have all of the information updated.

4. Collective Dashboard screen

5. Individual Reports per Knitter

Kĩ năng: Excel, Visual Basic, Xử lí dữ liệu, Kiến trúc phần mềm, Nhập liệu

Xem nhiều hơn: excel expert for some urgent work, excel expert services for hire, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, need an excel expert to organize some data for me i need t, job description for excel expert consultant, looking for excel expert in gastonia, excel expert for employee budget, excel expert for hire, excel expert for hire in delhi, excel expert for hire las vegas, excel expert for hire melbourne, excel expert for hire sheffield, excel expert for part time hire in gurgaon, free excel program for windows 7, freelance work for ms excel expert, hire excel expert for 2 hours, how to find a job for excel expert, i need an excel expert to come and fix up our spreadsheets for a few days johannesburg, job for excel expert, c program for scientific calculator using built-in functions

Về Bên Thuê:
( 0 nhận xét ) Spartanburg, United States

ID dự án: #30546919

Được trao cho:

(73 Đánh Giá)

20 freelancer chào giá trung bình$2218 cho công việc này


Dear Employer, I completely understand your VBA based requirement. Will do all the points that you need to install. Kindly check my previous reviews for your kind consideration!! Thanks, Ashish

$1500 USD trong 10 ngày
(295 Nhận xét)
(493 Nhận xét)

(489 Nhận xét)

Hi, I know excel well and have experience in data aggregation, consolidation, modelling and visualization. I could help you with improvement of the current model (ore maybe re0done it- it will be clear after more clos Thêm

$2500 USD trong 20 ngày
(45 Nhận xét)
(336 Nhận xét)
(314 Nhận xét)
(281 Nhận xét)
(69 Nhận xét)
(124 Nhận xét)

Hi, Greetings! ✅checked your project details :Excel Expert to Verify and Possibly Rewrite Program For Calculating and Tracking Efficiencies Attachments Current Settings [login to view URL] Current Dashboard [login to view URL] Current Thêm

$1500 USD trong 2 ngày
(71 Nhận xét)

I read your work scenario thoroughly.. Does the Excel linkup with SQL server to get data ? i checked your 3 image also to understand it ..and seems that it is closer to my expertise as i worked at Sweat Shirt factory a Thêm

$1500 USD trong 7 ngày
(27 Nhận xét)

Hello sir, i'm python expert & Desktop Developer, i worked with many companies to change their excel dashboard into full and standalone softwares with higher capabilities and functionalities, excel is restricted in man Thêm

$2000 USD trong 7 ngày
(18 Nhận xét)

Hi, I’m an experienced analyst information researcher, and science scholastic author. I have complete some Ph.D. level postulation activities, including progressed factual examination of information. Scanning for remar Thêm

$2250 USD trong 7 ngày
(17 Nhận xét)

Hello, I would interested in this project. May I have a quick look on the current program? Which could help us to have a precise estimation for this project. (I will sign NDA -Non-Disclosure Agreements- if you need i Thêm

$1500 USD trong 21 ngày
(10 Nhận xét)
(1 Nhận xét)

Hello, I have just checked all of your requirements that you want the website for your business. I'm highly interested to work on your project as I'm having experience of 8+ years and If you need it urgently feel free Thêm

$2250 USD trong 6 ngày
(0 Nhận xét)

We have read all the requirements, and We can complete your work on time and within the budget mentioned above. We have certified and experienced engineers working in diverse sets of IT field for a long time now. If yo Thêm

$2850 USD trong 65 ngày
(0 Nhận xét)

From what I have read , there are a few more things that needs answering so that I can understand your deployment. So let me elaborate on that . Can you please tell me what type of API you will be using for Data set ( Thêm

$4500 USD trong 58 ngày
(0 Nhận xét)

Hi, I am kaniska, an experienced Technical Solution Architect and a seasoned full-stack developer/programmer. I have more than 17 years of experience in IT system solution development & support on Microsoft .NET techn Thêm

$3000 USD trong 15 ngày
(0 Nhận xét)