Find Jobs
Hire Freelancers

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

$1500-3000 USD

Opravljeno
Objavljeno pred skoraj 3 leti

$1500-3000 USD

Plačilo ob dostavi
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 projekta: 30546919

Več o projektu

20 ponudb
Projekt na daljavo
Aktivno pred 3 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
$0 USD v 15 dneh
4,9 (73 ocen)
6,4
6,4
20 freelancerjev je oddalo ponudbo s povprečno vrednostjo $2.218 USD za to delo
Avatar uporabnika
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 v 10 dneh
5,0 (296 ocen)
8,3
8,3
Avatar uporabnika
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 v 20 dneh
5,0 (45 ocen)
7,6
7,6
Avatar uporabnika
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 v 7 dneh
4,9 (27 ocen)
5,6
5,6
Avatar uporabnika
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 v 7 dneh
5,0 (18 ocen)
5,3
5,3
Avatar uporabnika
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 v 7 dneh
4,7 (18 ocen)
5,1
5,1
Avatar uporabnika
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 v 21 dneh
5,0 (10 ocen)
3,6
3,6
Avatar uporabnika
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 v 65 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 58 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
Spartanburg, United States
0,0
0
Plačilna metoda je verificirana
Član(ica) od jun. 15, 2021

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.