Concluído

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

Habilidades: Excel, Visual Basic, Processamento de dados, Arquitetura de software, Processamento de Dados

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) Spartanburg, United States

ID do Projeto: #30546919

Concedido a:

(73 Comentários)
6.4

20 freelancers estão ofertando em média $2218 nesse trabalho

asin1987

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 in 10 dias
(296 Comentários)
8.3
(499 Comentários)
8.4
P0L

(490 Comentários)
8.0
proffesor1

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 Mais

$2500 USD in 20 dias
(45 Comentários)
7.6
(343 Comentários)
7.2
(315 Comentários)
7.4
(289 Comentários)
7.0
(69 Comentários)
7.0
(126 Comentários)
6.0
kingqueen369

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 Mais

$1500 USD in 2 dias
(72 Comentários)
5.6
tutulsoft

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 Mais

$1500 USD in 7 dias
(27 Comentários)
5.6
youssefEngineer

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 Mais

$2000 USD in 7 dias
(18 Comentários)
5.3
mzdesmag

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 Mais

$2250 USD in 7 dias
(18 Comentários)
5.1
DemoNGUYEN

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 Mais

$1500 USD in 21 dias
(10 Comentários)
3.6
(1 Comentário)
4.0
calgarysolutions

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 Mais

$2250 USD in 6 dias
(0 Comentários)
0.0
intells

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 Mais

$2850 USD in 65 dias
(0 Comentários)
0.0
bmainak11

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 ( Mais

$4500 USD in 58 dias
(0 Comentários)
0.0
kaniskasen

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 Mais

$3000 USD in 15 dias
(0 Comentários)
0.0