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 all competitors are put into a tournament bracket randomly for each event. During the tournament I want to allocate points to each round winner of each event then add all these points up for
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.
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: [login to view URL] 2. Kits Report: [login to view 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
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 need to create an AWESOME Sell Sheet that is going to sell our products in a big way! We have a great website already but we are looking to take the items on our site and give to our wholesale customers such as Hotel Owners and AirBNB users. The sell Sheet needs to fit on a 8.5"/11" paper and needs to highlight features of our mattresses in easy
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 [login to view URL] 2 columns. If all goes well there will be lots of work like this in the near future
We 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
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 e...currently entire their requested time off via a google sheet. I am looking to create a script 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: [login to view URL]
I'm looking for a freelancer 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
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
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. 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.
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
Hi, I'm looking for someone with experience in conditional formatting etc within Google Sheets. The project is to format the relevant cells in an existing Google Sheets spreadsheet to reflect the progress of: - The total project - Each phase of the project - The completion of each task The end result to be a Gantt style chart to help us with our
Super easy project. For the 2 sheets labeled "Purchase Letter -Peo" and "Purchase Letter - QC", create a macro on each sheet that prints all the groups individually. Cell A2 needs to change each time. The value in A2 goes: 1, print, 2, print, 3, print....and on until the end of the list. Please ask questions before bidding. Again, this should
Some Stats needs to be udpated in spreadsheet with little research over Google results.
I'm working on arcgis database designing, I prepared the database model in excel sheets I need a tool or script to convert the model into geodatabase without me having to create the feature classes and the attributes one by one
Need VBA code that will search for individual cells of from one sheet to and find the match in a different sheet and copy and paste what you find a separate sheet
Addon required for a Google sheet for saving sms received on a number from a specified number only. Addon should ask for both the numbers when applied to a sheet. The receiving number would be in a phone permanently and receive sms.
Create a webpage that has a table and similar to [login to view URL] and uses Google Sheets as the data source. The data table should be editable as inline and through the "New", "Edit" and "Delete" should be in real time so anytime the data is changed in the table it should be updated in real time in G Sheet
Need formula for google sheets I have a link attach to this. - need to get the sum from T2:T49 for cell O54 but sum need to be filtered by services from column S2:S49. - need to get the sum from T2:T49 for cell O55 but sum need to be filtered by Insurance from column S2:S49. -need to get the sum from T2:T49 for cell O56 but sum need to be filtered
We 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. We need a script to automate the process of posting the tweet to "Tweetdeck" by the Date/Time triggered by updated Row in the Google Sheet.
I have a google sheet on which complex calculations are done to input provided. I want my users to enter inputs through a ...complex calculations are done to input provided. I want my users to enter inputs through a form on webpage and get results after populating that data on google sheets. in real time The web page form has to be very simple one.
...able to create technical sheets on Indesign based on a predefined template we will give. The work is simple. [login to view URL] the company logo (logo provided) 2. Change the product image (picture provided) 3. Change the text (text provided) We will need the final sheet in 3 different formats : (.idml) / (.indd) / (.pdf) There is approximately 50 sheets to be
...same fields on google sheets. The website data changes every day, and I would like it to automatically track and add new entries based on the website data every single day at 12pm. I do not think the website has an API. I hope that whoever can complete this task can integrate the data directly from the website into my google sheets document, so that even