Find Jobs
Hire Freelancers

Write some Software

$250-750 AUD

Terminado
Publicado hace más de 8 años

$250-750 AUD

Pagado a la entrega
Hello, We need an Excel Macro written that reads from a live log file and outputs data to a screen. The screen is to be split into quarters. Bin 1, Bin 2, Bin 3, Bin 4. From these bins, a carton of meat is sent to an x-ray machine and is x-rayed for fat (trim). The box has a barcode that consists of 7 digits. Digit 1 is the bin where the carton came from, digits 2-3 are the target Trim (64, 70, 85, 90, 95, etc), and digits 4-7 are a sequential number or Carton Number. Column C is the Trim reading from the X-Ray. I need the Excel to read the log file as it is updated and output the following: Bin Number (Static in Each Quadrant) Target Trim (Changes during production but not frequently) The last 5 readings of Trim (Last 4 digits of barcode from Colum A + Column C) The running Average (This will need to change if the Target Trim changes - We will need to record all data for a report at the end of each day). I have attached a sample log file and a sample screen.
ID del proyecto: 9359521

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
A proposal has not yet been provided
$300 AUD en 3 días
4,9 (257 comentarios)
7,7
7,7
14 freelancers están ofertando un promedio de $419 AUD por este trabajo
Avatar del usuario
Hi! Do you need the screen to be prepared in excel? .
$526 AUD en 10 días
5,0 (407 comentarios)
7,9
7,9
Avatar del usuario
A proposal has not yet been provided
$600 AUD en 3 días
5,0 (508 comentarios)
8,0
8,0
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$300 AUD en 3 días
5,0 (336 comentarios)
7,5
7,5
Avatar del usuario
Hi Sir, I am ready to take up this project and start working on it right away. Please discuss how would you like the screen to be split up in 4 bins. We can have a user form with 4 boxes and they shall be updated regularly. Thank you. Usman
$700 AUD en 5 días
5,0 (93 comentarios)
7,1
7,1
Avatar del usuario
Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$260 AUD en 8 días
4,9 (204 comentarios)
6,9
6,9
Avatar del usuario
A proposal has not yet been provided
$277 AUD en 10 días
5,0 (126 comentarios)
6,6
6,6
Avatar del usuario
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 AUD en 15 días
4,9 (126 comentarios)
6,4
6,4
Avatar del usuario
Hello there, I reviewed the image file and text file that you shared and can write a macro that will take the data from text file and divide it into bins as required. I am an expert in Excel and have done more than 475 spreadsheet projects here on freelancer with excellent ratings. You may see comments of the clients with whom I have worked and they echo the same sentiment. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you. Thanks and Regards, Rishi
$277 AUD en 10 días
4,9 (100 comentarios)
6,6
6,6
Avatar del usuario
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 55 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$263 AUD en 3 días
4,8 (86 comentarios)
6,1
6,1
Avatar del usuario
Hi, I have read all the description. Although there are some reading mistakes I don't know what is the actual matter...But I can write macros whatever you want...I hope you would consider me for your project...Thanks!
$600 AUD en 12 días
5,0 (3 comentarios)
3,8
3,8
Avatar del usuario
Hi I understand the log file is live. So it is updated regularly depending on how fast the x ray machine works. Excel cannot detect changes in text file, so we must import the log file at interval to check if new data has been logged. We arbitrarily assume every one minute interval. The macro then refreshes each box one by one using new data from top down. We will ignore unreadable barcode rows. The last import of log file is for report purpose. The target trim can be changed by user at anytime, or we can build in admistrative right to restrict this action.
$277 AUD en 10 días
5,0 (7 comentarios)
3,2
3,2
Avatar del usuario
A proposal has not yet been provided
$315 AUD en 10 días
5,0 (2 comentarios)
0,8
0,8
Avatar del usuario
A proposal has not yet been provided
$672 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Brooklyn, Australia
5,0
12
Miembro desde sept 11, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.