Google Sheets Expert for Data Automation

€30-250 EUR

Terminado

Publicado

hace 3 meses

€30-250 EUR

Pagado a la entrega

I'm in need of a Google Sheets / excel professional who has a deep understanding and hands-on experience with data automation, analysis and visualization who can help us to import an excel/CSV file into an online spreadsheet program. The excel list is generated out of our ERP system (Example ERP generated list 7-2-2024) and contains projects per supplier. All projects need to be imported in an weekly planning list for a supplier. I have added an example sheet how this should look “Weekly planner TOS 2024”. The weekly planning will have a column for each week, the part quantity should be filled in the weekly column. So for example project #70230076 has 10.000 parts for delivery 03-01-2024, the quantity of 10.000 pcs should be filled in the column for week 1. This way we can easily check what needs to be ready in which week. All imported projects should have a status column with “in production” or “in transit”. This status should be changeable in the online list by the supplier and should not be overwritten when a new excel list is being imported. A project starts with “in production” the supplier will change this too in transit when they booked a container or shipped it by air. Before changing this status the supplier should be able to make a new sheet at the bottom of the list first with the specific container or airfreight shipment (so that we can see which parts are shipped in which container/which airfreight).The sheet name should show in scroll down box in the status column and when chosen the information (description, PO# etc) of that line should be copied to the new sheet. when projects are delivered to us we will remove them out of our ERP system. When we export a new excel list out of the ERP system and uploaded it into the online spreadsheet the project should be removed too. Please let us know if the above is possible.

ID del proyecto: 37754825

Información sobre el proyecto

49 propuestas

Proyecto remoto

Activo hace 2 meses

¿Buscas ganar dinero?

Dirección de email

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:

@AccountantArman

"""""""""""""""""""ADVANCE EXCEL & GOOGLE SHEET EXPERT/GOOGLE SHEET AUTOMATION"""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "

€140 EUR en 1 día

4,9

(287 comentarios)

7,4

49 freelancers están ofertando un promedio de €128 EUR por este trabajo

@rahul62544

Hi there, I'm thrilled to connect with you! Your project sounds exciting, and I'm eager to lend my expertise to make it a success. Let's start by discussing the specifics via chat and get the ball rolling on our collaboration. Thanks,

€220 EUR en 1 día

5,0

(958 comentarios)

8,7

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

€180 EUR en 5 días

4,9

(577 comentarios)

8,5

@livegoodlife

Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bot or cloud flair protection. Please message me to discuss more regarding this project. Best Regards

€150 EUR en 4 días

4,9

(351 comentarios)

8,0

@daniyal3214

Hello, yes. This is possible in Google Sheets and Excel. I can perfectly assist you with that. I am an experienced Excel and Google Sheets expert holding years of experience. I will be happy to discuss in detail.

€40 EUR en 1 día

4,8

(246 comentarios)

7,3

@nimiwebjuggler

Hi, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 years of in the Freelancing field. With my skills and expertise, I can guarantee 100% success rate in your project. I have a deep understanding of the requirements of this project and I'm confident that I can provide you with the best results. Additionally, I provide regular updates during the project so that you don't have to worry about anything. Please feel free to contact me if you have any questions or would like to discuss this opportunity further. All the best, Muhammad Ali

€140 EUR en 1 día

5,0

(168 comentarios)

6,8

@rahulg5466

-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL/GSHEETS⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul

€120 EUR en 2 días

5,0

(70 comentarios)

5,6

@zafarfarooq612

Hello, As a seasoned Google Sheets/Excel professional with comprehensive expertise in data automation, analysis, and visualization, I am well-equipped to assist you in seamlessly importing your ERP-generated excel/CSV files into an online spreadsheet program. I understand the importance of accurately transferring project data into your weekly planning list for suppliers, ensuring each project is assigned to the appropriate week based on delivery dates and part quantities. Additionally, I can implement a dynamic status column that allows suppliers to update project statuses without overwriting data upon import. By enabling suppliers to create new sheets for container/airfreight shipments and linking relevant information to the status column, I can streamline your workflow and enhance collaboration. Rest assured, I am committed to delivering a solution that meets your specific requirements and ensures efficient management of project data. Regards, Zafar

€100 EUR en 1 día

5,0

(76 comentarios)

5,3

@vishal54sharma

Hey , after reading your entire requirement. I believe this can be done using appscript with google sheet. Since you want an online sheet then gsheet will be best suited for that purpose Lets connect in chat and discuss Thanks Vishal

€90 EUR en 3 días

5,0

(86 comentarios)

5,2

@Jatin77777

Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports have dynamic views and functionality to present the data Like: checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts, heat maps, Gantt chat, etc.). Successfully delivered Dashboard, Scorecard, Heatmap & Ad-hoc requests to my clients. I can help you here; I went through the mentioned details and found that I can give you support to complete your task. Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender Kumar Reporting & Data Analytics EXCEL | VBA | POWER BI | SQL | OCR | Gsheet

€240 EUR en 7 días

5,0

(28 comentarios)

4,8

@IMBASANTAKUMAR

As a seasoned and results-driven Google Sheets expert with over a decade of experience at global tech giants like IBM, Accenture, Amazon, and Google, I am adept at leveraging the full power of spreadsheets for data management and automation. I have a remarkable track record of using Excel to handle complex data-related tasks such as importing/exporting ERP-generated lists and designing dynamic, user-friendly interfaces for managing vast data sets. Furthermore, I have proven expertise in Python and VBA/Macro scripting which will come in handy if we require any customizations or advanced functionalities throughout the project. Additionally, my mastery in Power Query will help us extract, transform, and load your diverse range of ERP datasets with precision and accuracy. Combining this with my notable skill set in finance, operations and work flow management will ensure we not only meet all your requirements for the project but also enhance its efficiency. My dedication to delivering effective solutions makes me the ideal match for your data automation, analysis, and visualization needs in Google Sheets. I'm excited to bring my talent on board to empower you towards streamlined workflows and actionable insights from your supply chain's numbers.

€40 EUR en 1 día

4,9

(70 comentarios)

4,5

@GdevDataSceince

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project not only means benefiting from my extensive skills in Excel and data analysis but also entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev

€140 EUR en 7 días

5,0

(9 comentarios)

4,2

@penslingers06

Google Sheets Expert for Data Automation . Being MBA and having a professional experience of 7 years in different types of writing services, I can better assist you with my budget friendly, plagiarism free, well researched, premium quality writing services, meeting even very strict deadlines. Inbox me so that I can show you my sample work for further assistance and guidance. Here is the link of my portfolio. https://www.freelancer.com/u/penslingers06

€30 EUR en 1 día

4,9

(6 comentarios)

4,1

@OmidAA

I can do it in less than 24 hours without error, is acceptable?

€30 EUR en 1 día

4,9

(6 comentarios)

2,8

@b0b90

As a seasoned software engineer with extensive experience in Python, including working with libraries like Keras and Tensorflow for data processing, I have complete confidence in my ability to tackle your project effectively and efficiently. Your requirement of importing and analyzing an ERP-generated list into Google Sheets with complex data manipulations aligns perfectly with my capabilities and technical knowledge. With profound expertise in Google Sheets and Excel, I'm adept at automating processes, extracting valuable insights, and visualizing data neatly, just as you require. Not only can I help you accurately import your projects into the weekly planning list, but I can also create a sophisticated system that allows suppliers to update project statuses without being overwritten. My command over REST APIs will enable me to build a dynamic solution where suppliers can create specific sheets for containers or airfreight shipments. This featureful process will reflect each project's information onto the chosen sheet in an intuitive scroll-down box, ensuring complete transparency about what parts are shipped where.

€140 EUR en 7 días

5,0

(11 comentarios)

2,8

@IcsfIT789

Hi there, I am pleased to present your Database Programming project. I have extensive experience in Python, Visual Studio, Data Processing, Data Visualization, Google Spreadsheets, Excel VB Capabilities, Database Administration, and Data Cleansing. Additionally, I provide services 24 hours without any limitations, and deliveries are assumed to be on time. Furthermore, rapid action on services is my motto, which shows my commitment to customer satisfaction. https://www.freelancer.com/u/IcsfIT789 Let's discuss this further via chat, and I'll start your project right now. Thanks IcsfIT

€50 EUR en 2 días

5,0

(2 comentarios)

2,5

@cansudinler17

As a versatile freelancer with a knack for meticulous data management, I believe I am well-suited to support your project. I bring with me both academic grounding - majoring in Philosophy - and professional experience in data entry, a skill that is crucial to your requirements. Drawing from my exposure to various organizations, I have developed an aptitude for time management. This means you can trust that I'll make the most of the 'weekly planner' format you've designed, ensuring smooth importing of data into Google Sheets, while preserving status updates made by suppliers. With my vigilant attention to detail, all the project-specific information will be accurately transferred onto new sheets as per the container or airfreight shipments. Additionally, my translation background hones my ability to analyze the intricacies of given information. Thus, I can assure data integrity in sync with ERP generated lists. Lastly, I understand the value of a clean and streamlined interface; hence, as projects are delivered and removed from the ERP system, expect it to seamlessly update on your spreadsheet. I guarantee you swift turnaround times without compromising quality and accuracy in handling your weekly planning list,. With my unique blend of skills and experiences I'm excited to tackle this project and help you optimize your supply chain!

€40 EUR en 3 días

5,0

(4 comentarios)

2,1

@chintanshah97

Dear Hiring Manager, I read your instructions and I think above requirements is possible. Hi, My name is Chintan Shah and I am working in inventory management for more than 6 years. I can provide unlimited revisions and can start this work immediately. Can you please initiate chat to discuss the same. Regards, Chintan Shah

€30 EUR en 1 día

5,0

(2 comentarios)

2,0

@Bhawnaduklan

Hi, In your job posting you are looking for a person who knew every basics of data entry work specially MS excel and web scraping. I have gone through the project details carefully and would like to tell you that I have all the required skills (vlookup, hlookup, pivot table, macro etc.) that you posted in the description. I would like to offer myself as a candidate for the job. I look forward to hearing from you soon so we can get started on this exciting project! Thanks Bhawan Duklan

€120 EUR en 1 día

5,0

(3 comentarios)

2,0

@syedalihassansh4

Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the work. Will wait for your kind response ? Thank You. Regards, SYEDA NIMRA

€30 EUR en 1 día

5,0

(6 comentarios)

1,6

@abdelrahmansoubh

Hi there! I'm Abdelrahman, a top-rated data expert specializing in Microsoft Excel and Google Sheets with over 5 years of professional experience. After looking at the detailed project description, I'm confident that I can deliver the exact solution you're looking for. My expertise in automating and visualizing data paired with my strong understanding phase are key components needed for the project you've outlined. I understand that precise and efficient importing is essential for your weekly planning process, and that's where my skills truly shine. My deep mastery of complex formulas, data manipulation, and pivot tables would enable me to not only import but also organize the projects per supplier into a clean and accurate format as required in your "Weekly planner TOS 2024" example. Lastly, as an added guarantee of quality workmanship on time management & affordability: 1) Let’s talk about pricing: My competitive rate is open to negotiation; 2) Regarding timing: Tell me about any specific deadlines and I’ll make sure to meet them responsibly; 3) Complexity isn’t an issue: If we need to take up additional work or make unexpected customizations to full-project completion – I am ready for it! Let’s make this spreadsheet system not just functional but one that enhances your supply chain performance. Reach out now so we can discuss details better!

€100 EUR en 3 días