Find Jobs
Hire Freelancers

Google Spreadsheet Scripting

€8-30 EUR

Terminado
Publicado hace más de 7 años

€8-30 EUR

Pagado a la entrega
please try only if you know how to do scripts in google spreadsheets. Excel is not possible Have a look here: [login to view URL] I need an improvement of my Google spreadsheet which automaticly updates my datas by click ------- what does my Script is doing now?? It changes Sheet 1 collumn B-M from Sheet 3 (CSV-Daten) by clicking "SKU" in the navigation which starts a Javasctipt in Google Spreadsheets 1. Sheet 3 (CSD-Daten) you see in collumn A the Name of the product OR the Sizes we have for the Product. you see in collumn B the SKU for the product which is very important you see in collumn D the number of products we have for the size in Collumn A this sheet is updated daily, so tomorrow, there might be more products or less and the same product might be in another row 2. Sheet 2 you see in A:B 1:10 size mapping 001_32 / 2XS in Sheet3 is 2XS in Sheet1 3. Sheet 1 This is the important sheet that is updated automaticly if i Update Sheet3 and click "SKU" in the navigation I include SKUs in Collumn A The Sheet is now uptading automaticly for my given SKUs the next collumms in B: The name of the SKU from Sheet3 Collumn A in C: The number for Size XS for the SKU from Sheet3 Collumn D in D: The number for Size S for the SKU from Sheet3 Collumn D and so on it changes, too the colors (0 = red, >1 green) ..... Often, SKUs don't have all Sizes, then it types in the Sizes in Sheet1 "no" and changes color to yellow Often, SKUs don't have any Sizes, then it types in the sizes in Sheet 1 "no" and changes color to yellow For me, only the SKUs are interesting, which have the numbers, i asked for. Important: i include the SKUs in Sheet1 Collumn A and i'll include more of these SKU and maybe delete some of them, so i need to have the chance of Sheet1 Collumn A ------------------ What do i need. 1. exact the same for collumn "N" - which icludes the new Size "one size" 2. exact the same for collumns "AC" - "BO" which includes new sizes here you can use the same code for the new sizes 3. Collumn "O": Here i need a sum of all products in Stock for these SKU Please use the same colors (no = yellow, 0 = red, >1 = green
ID del proyecto: 11528102

Información sobre el proyecto

5 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
Hi Zoe yes will write that code. What must be in column AQ or you use it just as a separator? Regards, Viktor
€35 EUR en 1 día
4,7 (19 comentarios)
4,5
4,5
5 freelancers están ofertando un promedio de €38 EUR por este trabajo
Avatar del usuario
Hi, I have more than 5 years experience working on website and application development. I have been working on component and plugin development for Joomla and other CMS. I can work on this and can deliver it with quality. Looking forward to your reply.
€24 EUR en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am well-versed with Javascript and Google App Script and wont take more than a few hours, say 3-4 for me to finish it.
€24 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have worked on algorithms (Perl, Java, PHP, JS) which processes CSV and other file formats, scrubs it, co-relate rows across CSV files and generate a new output file. One of my most credible project which heavily used JS+Perl is a Dashboard which describes tax collection across the nation, with drill-down, aggregation, achievement calculation, sorting, and access control for tax officers hierarchy. This project was developed 10 years back when Jquery/Angular were not a norm, and it is still used every day, and has a track record of ZERO bugs so far. Assumption: You will provide (i) existing Google Apps Script and (ii) Sample data files as representative cases before project starts as part of acceptance testing. I have studied the attached spreadsheet and clearly understood algorithm you have described. Schedule: D1: Put existing script under version control, setup a working environment and test that existing script works. D1: Study current algorithm. Aim to fit new code within current algorithm, use similar variable/function naming convention, indentation style, etc. D1: Write a pseudocode for updating additional columns within Sheet A based on data provided in Sheet 2 and CSV-Daten. D1/D2: Implement pseudocode, test it with samples provided by you. D3: Submit final code and patch as part of UAT. D3: Fix bugs or assist in case of any issue while executing this application. Feel free to contact me for any further clarifications, over Email/Skype/WApp.
€55 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de GERMANY
Kreuzberg, Germany
5,0
15
Forma de pago verificada
Miembro desde mar 19, 2006

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.