Find Jobs
Hire Freelancers

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

$1500-3000 USD

Завершено
Опублікований almost 3 years ago

$1500-3000 USD

Оплачується при отриманні
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
ID проекту: 30546919

Про проект

20 пропозицій(-ї)
Дистанційний проект
Активність 3 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
$0 USD за 15 дні(-в)
4,9 (73 відгуки(-ів))
6,4
6,4
20 фрілансерів(-и) готові виконати цю роботу у середньому за $2 218 USD
Аватарка користувача
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
$1 500 USD за 10 дні(-в)
5,0 (296 відгуки(-ів))
8,3
8,3
Аватарка користувача
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 close look how it works). Please let me know if you are interested in my services. Regards, Alex.
$2 500 USD за 20 дні(-в)
5,0 (45 відгуки(-ів))
7,6
7,6
Аватарка користувача
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 and Leather goods factory product team for integration worker efficiency at Excel format from software data ..we can discuss more on chat ... i am very much interested .. i have 20 years SQL server and excel expert with ERP implementation expert at industry level
$1 500 USD за 7 дні(-в)
4,9 (27 відгуки(-ів))
5,6
5,6
Аватарка користувача
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 many things, i suggest to make you a software from scratch that include all excel functionalities and also new functionalities that you desire, we can include pdf, web format report generation, we can add emailing, or more complexe things, software will be the best choice for this kind of processes as it is flexible, easy to use, more featured and and robust against data corruption. i can show you some of my previous work to have an idea, we can also discuss this project in more details i'm looking forward to work with you, cordially
$2 000 USD за 7 дні(-в)
5,0 (18 відгуки(-ів))
5,3
5,3
Аватарка користувача
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 remarkable opportunities to apply my insightful accreditations joined with my past experiences. I ensure that you can finish your true movement me! I can do: 1. Quantifiable programming/R programming data examination 2. Enlisting for Data Analysis 3. Time Series and Econometric 4. Money related Modeling 5. Review data examination, Analysis driven report forming and presentation 6. Insightful data assessment and report forming. I have dominance on SPSS, STATA, STATISTICA, SAS, Eviews, Minitab, SPSS AMOS, Mathematica and MS Excel having encountered the portrayal of this endeavor. I have the normal aptitude to play out this task satisfactorily inside a sensible course of occasions and besides pass on to you a better than average quality Job. I'll be cheerful in case you can trust in me to assist you with this endeavor. You can enlist me straightforwardly through this connection. Below is my profile, you can check my past works and review. https://www.freelancer.com/u/mzdesmag?w=f
$2 250 USD за 7 дні(-в)
4,7 (18 відгуки(-ів))
5,1
5,1
Аватарка користувача
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 it). Please drop a 'Hi' so that we can discuss about your detailed requirements. Thank you
$1 500 USD за 21 дні(-в)
5,0 (10 відгуки(-ів))
3,6
3,6
Аватарка користувача
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 you give us this project, we can ensure to provide the exact result you expect. Thank you Intelligent Solutions LTD
$2 850 USD за 65 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 ( IF ANY ) , Can you tell me the type of Server you have ? and of course what type of CRON it supports? Once I have these information, I will be able to build more wisely for you. Thanks and Regards
$4 500 USD за 58 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
Spartanburg, United States
0,0
0
Спосіб оплати верифіковано
На сайті з черв. 15, 2021

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.