Solicito ayuda para diseñar un curso de Excel / Google Sheets de nivel intermedio / básico. Se requiere la creación de ejercicios prácticos y una presentación en Powerpoint para poder dar el curso. de mayo de Fecha límite: Jueves
Necesito un experto en excel para realizar un reporte avanzado utilizando funciones y sumas de drop down list o columnas con checbox para habilitar montos y tipos de cambio.
Quisiera integrar las hojas de cálculo de google sheets con python (utilizo spyder de anaconda) he tratado sola pero no he logrado encontrar la solución. Mi objetivo es que se sincronice con las hojas de cálculo y pueda utilizarla para previamente hacer modelos predictivos en python, lo único que me hace falta es cargar la hoja y reconocerla como "dataset&qu...
Hola tengo una hoja de google sheets donde voy dando de alta datos de personas, estos datos se ocupan para registrarlos en webinars Necesito un script de google que me permita registrar a las personas en el webinar usando una API. El código a implementar es muy sencillo. Adjunto el texto de la API, en las páginas 7, 8 y 9 encontrarás un ejemplo y
Hola tengo una hoja de google sheets donde voy dando de alta datos de personas, estos datos se ocupan para registrarlos en webinars Necesito un script de google que me permita registrar a las personas en el webinar usando una API. [iniciar sesión para ver URL] Freelancer que hable español, en el futuro seguiremos
Download the excel files from this links below, and merge them into one file in chronological order. Each link has a set of data, and each seat of data should go on a different tab. Each file is one day of data. The files go from January to August 2017, months are divided by folder. Links: 1.- [iniciar sesión para ver URL]
El proyecto ya está iniciado, pero necesitamos una reformulación de algunos apartados para seguir creciendo
Tengo una app creada en este sitio web [iniciar sesión para ver URL] esta funciona correctamente pero quiero optimizarla creando con hojas de excel los datos de los clientes, necesito que alguien que sepa de estos temas me ayude a organizarla.
Necesitamos asistente / administrador de sitio web. Funciones: ========= - Data Entry: Cargará información de proveedores y tarifas de servicios en bases de datos, ya sea a través de la interfaz de nuestro sitio, Google Sheets, o PHP My Admin. - Proceso de documentación: revisará los documentos enviados por los nuevos proveedores, y los...
...tener una opción para mostrar ALTA: Espacio para añadir a un nuevo alumno como alta. HOJA DE CÁLCULO Todos estos datos se tienen que utilizar para: 1-Crear una hoja excel que muestre los datos recogidos a lo largo del año de la misma. 2-Enviar un correo automáticamente a una dirección indicada cuando: Haya un ALTA Haya una BA...
I am looking for some one good at data entry/excel and email handling. you will be mostly dealing with emails a lot so good communication skills are required, but there will be some data entry as well. you will be tracking multiple tasks via excel sheets. good speed and accuracy is required. this is a long term job. looking to hire someone asap
I have a Google Form that automatically submits tournament entrants to a Sheet. I want to create a Sports Tournament with about 10-12 different events where al...would also like to know if its possible to connect this to the website so that the results can be uploaded live to the site. Doesn't specifically have to be a Google Sheet, Excel is fine.
Need a Google sheets app script and macros which does the following. - Runs every 15 mins - Fetches the data from a website and populates the sheet with that data - And Applies conditional formatting on the newly added data.
I have a working file with excel for Drop down menus, I want to be able to use this file with google sheets, its seems google sheets does not work with dependant drop menus. So i need the attached file to be modified to work with google sheets.
...other markets e.g. the US market to find ideas and profitable products and doing research into its potential and opportunity within the Australian market Researching and data entry for a supplier list, Product details Listing products and fill filling orders on multiple channel particularly on eBay. About you Honest, Result driven, attention to detail
I have the scanned copies of 500-1000 survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer
I have about 150 addresses in a google sheet. They are now in a single cell. I would like them changed so they follow the format: Name (Column A), Address 1 (Column B), Address 2 (Column C), City (Column D), State (Column E), Zip code (Column F). I will provide the link to google sheet for this work. Also, there are 10 addresses that I would like you to find the zip code for. I would like to sta...
Hi, We need to create a code within Google Sheets that will pull data from SKUVAULT API: 1. Products Report: [iniciar sesión para ver URL] 2. Kits Report: [iniciar sesión para ver URL] And will save each report to a specific sheet. 3. I want this to code to be scheduled to run every day. For more info about
I have the scanned copies of 1000-1333 survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer
I need you to develop some software for me. I would like this software to be developed for Windows using SQL.
1) Windows 10 pro, Excel 2016 2) User should be able to identify target folder for process to run on all excel sheets in the folder as a batch. 3) Source data is Excel sheet (no more than 4 columns, and max. 100 rows) 4) Output is csv (12 columns, and no more than 100 rows) 5) Some columns in source will be split into many columns in output
Summarize data from excel file into a summary report (template provided). Can either be done by script, formula or manual entry. Summary reports can be either on a single sheet or an individual sheets for each header. Summary report(s) to be filterable on dates.
I have the scanned copies of survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer name
I have a list of 1000 products on a website, I need the following to be extracted from URLs I provide: 1) Serving size [g] 2) Calories [kcal] 3) Carbohydrates [g] 4) Protein [g] 5) Fat [g] 6) Saturated Fat [g] 7) Fiber [g] 8) Sodium [mg] Please only apply if you can finish this for less than $25 and in 2 days
Looking for someone to enter approx. 220 0 k pdf pages and form fillings worksemailadresses from PDF to Excel. I attached an example of the pdf data. Please look at it before making a bid. Only the email address [iniciar sesión para ver URL] 2 columns. If all goes well there will be lots of work like this in the near future
have to fill data entry excel sheets
...have a Google Form that posts automatically to Google Sheets. There are 10 columns labeled "announcements" where twitter messages will land along with requested Date/Time to post to Twitter. We need a script to automate the process of: 1. Querying Google Sheets for new entries 2. When a new entry is found & we have marked a particular column with
I need a house drafted in Revit 2018. I will need 6 sheets created with dimensions, basic annotations, and some schedules. This is a 2000 SF rancher with nothing too complicated to deal with. The main challenge is that we are working off of old paper plans that I have taken pictures of. As such I will need an extra set of revisions. That said,
I am looking to randomize the scheduling for my employees. I currently entire their requested time off via a google sheet. I am looking to create a script that will a...that will allow me to randomly assign them positions for the day based on who is present, and who recently had a day off. The script should be contained fully within google sheets.
...to write a complex formula that will look up barcodes and return the results accordingly. I am VERY experience in Google Sheets formula's myself, do not apply for this job if you don't have a complex understanding of Google Sheets Formulas. Watch the video of what I want: [iniciar sesión para ver URL]
I have a spreadsheet that has needs to be sorted into multiple sheets. I don't think it's extremely complicated, but more than I can do. There are only 3 columns. I need to pull info from the first column - but not based on the entire col A info - not day, date - just the name of the city.
...who is expert with Google Sheets, Excel or SharePoint for automated extraction of data from websites. I'll provide a list of URL's for data extraction and the freelancer will need to design and create a product for scheduled automated extraction and filing. In summary, I'm creating a database to capture open source data that will automatically...
I have data of attendees/employees in a facility and I want to use this data to create two reports, one report to view the vacancies, the second will be used to calculate Payroll for the employees the reports must be dynamic, showing the last vacancies and Payroll data once updated by any team member I think we may need Google Script for the project
...papers, old book, hand written, research .. etc into MS Word soft copy, both offline and online , we can handle - Data entry into Excel sheets, Ms words, software programs, HTML programs, data collection from receipts, papers, manual data entry etc - Office Assistants, virtual secretary, etc - Transcribing ( converting, video , audio, mp3, etc g...
i have two sheets in excel,i want combine rows in one sheet if match with particular column value in excel
I have 2 google documents that contains a list of names that I need transferred into a Google Sheet. The documents contain names, file numbers, and a short description. They are not in a table, so I cannot just cut and paste the documents into the Google Sheet. The Google Sheet will be used to maintain a client contact list. There are around 5,000 entries to be transferred over. IT IS VERY IMPOR...
I create new project workbooks based on predefined templates from many existing workbooks...create new project workbooks based on predefined templates from many existing workbooks. What I would like is a new project workbook with drop down menus that lets me choose sheets from different workbooks and copies all selections to the new project workbook.
Consolidate data from 91 Excel worksheets to a single sheet for bulk upload. The first sheet in the attached file is the bulk upload file; the first data set has been imported as an example.
Hi everybody, This is task for someone with google app script knowledge + advanced google sheets knowledge I am trying to create a Stock Portfolio Spreadsheet that can automatically search my Gmail inbox for (specifically titled emails, that have specifically titled) CSV attachments, and then import them onto a secondary Sheet of the aforementioned