Find Jobs
Hire Freelancers

Auto convert specific spreadsheet to a table format

R$30-200 BRL

Terminado
Publicado hace casi 8 años

R$30-200 BRL

Pagado a la entrega
There are 7 spreadsheets in MS excel that should be converted to a more organized , single and clean table - in a way more automatically. In some spreadsheets there are more than one sheet, to be converted also. Each sheet is about vessel schedule, containing expected time for arrival, departure, etc. The sheets are separated because are about different transport services. Each service has several vessels attending, each vessel attend several ports. As a result of this combined table, we'll have huge rows. I expect something where user could copy + paste the sheets somewhere and somehow they're converted to a table format. Or even, only if possible, the files are only put together somewhere by the user (in a folder) and somehow an automation join all of them in the default format. See attachments of the 7 spreadsheets today: -example schedule service [login to view URL] -example schedule service [login to view URL] -example schedule service [login to view URL] -example schedule service us [login to view URL] -example schedule service nwc [login to view URL] -example schedule service atlantico [login to view URL] -example schedule service [login to view URL] See attachment of the table how I expect to see it. See attatchment =TABLE format - [login to view URL] Hope the job suceed,
ID del proyecto: 10753995

Información sobre el proyecto

9 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
Please clarify you want to club all 7 sheets into one or wish to produce 7 output sheets as per Table Format (Presently covers USA1 only) . Some observations—SANTOS (S/B) and SANTOS are different (unless we hard code them same). Date formats for ETB and ETS are different in Table Format and USA1. I shall maintain as desired. Where to get STATUS. Service “USA STRING I” as mentioned for Column D to J, but Column L to R is blank. This implies MSC MICHAELA is not part of USA STRING I. You are covering “Port of Loading” but not “Port of Unloading” may be the same not needed by you. Evidently you need macro to do the job. This block has limited space to discuss. Please initiate dialog... I am Mechanical Engineer, proficient in Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form, Google Sheets Proficiency in Office tools, SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Pr
R$200 BRL en 5 días
3,8 (5 comentarios)
3,0
3,0
9 freelancers están ofertando un promedio de R$225 BRL por este trabajo
Avatar del usuario
Hello, Hope you are doing good, I read the job description and checked the spreadsheets. It’s my kind of work. I can complete the project timely and within your budget. I have an advanced knowledge of Internet research, Web Scrapping, Data Mining, MS Excel, Powerpoint and Word. Kindly share the details and I assure you of high-quality work. Looking forward to working with you. Thank You. Chopra C, India.
R$200 BRL en 1 día
4,9 (92 comentarios)
5,4
5,4
Avatar del usuario
----------------------------------------Pro VB Developer! Best Result in Time!-----------------------------------------
R$300 BRL en 1 día
4,8 (15 comentarios)
4,7
4,7
Avatar del usuario
Hi Im an expert in .Net technologies and SQL server I think what u need is a different aproach, since your data has been grown Meyba a Sql Server with an intranet front is a better solution for you regards Carlos
R$333 BRL en 2 días
5,0 (20 comentarios)
4,3
4,3
Avatar del usuario
I have seen all the spreadsheets. I can do all that is required. Using the data in the 7 workbooks, I will create a single spreadsheet as per the sample provided. If this task is of the repetitive nature, then I can create a macro to automate the process
R$150 BRL en 2 días
4,4 (51 comentarios)
5,0
5,0
Avatar del usuario
Hello, I have seen two of your files and I guess I got what do you want to do here. I can do this for you, I'm excel developer and I can organise all this data as you need. I will work carefully and with accuracy for you in this oportunity to get this well done and delivers you a table format you desired with all your ships info like (ETA, ETC, ETB). I'm familiar with this subject since I'm oil scheduler and I works scheduling oilpipes and a SPM. I hope hear from you soon to work together! Regards, Luis Romero
R$170 BRL en 2 días
4,9 (21 comentarios)
3,7
3,7
Avatar del usuario
Hello, I can help you with the template. I will create a macro that with a click of a button, all files in the folder will be opened automatically and data copied into a structured format in one file. If you are interested please open a chat with me. Kind regards, Sorin
R$166 BRL en 1 día
5,0 (3 comentarios)
2,2
2,2

Sobre este cliente

Bandera de BRAZIL
Santos, Brazil
5,0
10
Forma de pago verificada
Miembro desde jun 9, 2016

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.