For detail, please check the sample sheet at [url removed, login to view] The data (starting point) has Date, Amount, Owners, Collaborators. Owners and Collaborators are name of the person and both Owners and Collaborators can be several person. The final goal is to create a pivot table with month-year and person. I believe this job is quite easy for the person who know calculation on spreads...
I import a report from our GP system to excel. I then format the sheet as desired. Currently I do this every day and format the new reports from scratch. I want to be able to import or merge the formatted sheet or import the new data into my formatted sheet so I adheres to the format of the formatted sheet without creating any duplicate data.
We require a person to copy approximately 2100 tables in a website to excel spreadsheets. We estimate about 12 hours* of work to do this manually. Freelancers are free to use automated techniques to perform the task. The work is to be completed within 1 week after which we will assess the work through a random sampling. If any discrepancy is found, the freelancer needs to review the entire set of ...
Our current script needs to be corrected real quick. Most of the code has been written and need a quick fix. Overview: We have a script that will connect to Twitter API (authentication provided by client) but need corrections, and retrieve tweets for a user via URL defined in spreadsheet. Scope: - Create a trigger with a button, menu item or cell change that will execute the remote API call to...
... as in this sample: [url removed, login to view] I would like a custom sidebar to add to this and similar sheets, with two core functions: 1) I enter a part number into a text field, and a newvalue into another text field, and push enter. The sidebar populates the left
...2 (RR 18th) Sample 1 and sample 2 will always be in the same format. Currently i have shown only two sheets. in real life I will have multiple number of sample sheets. also the number of columns filled in the sample sheet will vary. Sample sheets are locked with password 'lb' Save sample sheet in a folder and master sheet in a different location
Need a macro or similar solution for google sheets which convert a short list of summed up products into a long list of single products. See example in link below. It need to work seamless so we just insert the data we need converted and then activate the macro to get the list we need. [url removed, login to view]
Using web scraping, data mining, and genre-based research, as well as lists of Hype Machine indexed blogs; we need to construct a list of the contact information of writers & contributors for music & visual arts blogs related to our niche. We need names of blogs that have proximity to similar audiences. We'd like to use this list to secure blog coverage for content releases. Blog cove...
...containing word BASE - it is typically preceded by mostly 3 lines of data, sometimes it may be more lines of data, but typically not more than 6. As You look through the excel sheets You will see patterns of data clustering. There are 2 spreadsheets attached - one represents basic data and the other has added columns with calculations that I need.
$20 FIX PRICE for less than an hrs work. ...data set and SUM all the values that are labeled as sales income. In this example the formula should produce a result of 4756.29 I am using Google Sheets, so this must work on that. I must be able to add more categories and columns easily, and have the formula still work Any questions.. ask! Thanks
...[url removed, login to view] You'll click each of the performers listed on that page to open the information page. Into a Google sheets or Excel or other spreadsheet, you'll enter the artist's name and location. You'll also add the listed genres, reference points, and similar artists. One item per column. Attached is an example entry. This is a very
We have a custom made code in Google sheets, however it takes longer than the maximum allowed Google sheets run time. We need it to work in under 5 minutes run time.
...excel spreadsheet. Explanatory notes are as follows: General notes - All sheets- must automatically update on spreadsheet opening - The stock names in column A in all sheets (aside from overview and commodities) must automatically be in alphabetical order. Ie even if I add a new stock name to anywhere in column A, column A and the associated rows
...that wants to transition to 3D instead of doing photography. So, we need to create many 3D models of furniture pieces. Sofas, chairs, etc.. We can provide the product spec sheets and a snapshot of the product. 3D models should be realistic, so natural imperfections and organic shapes are preferred. In terms of volume, we are looking at 600 to
I require an API to be built between Dear Systems and Google Sheets. I will only need to get information from Dear. There will be no pasting of data back into Dear. At this stage the I only need to sales data, for example quote dates and amounts. Please send me a quote and outline how you will achieve the integration and how I can use it.
I want to connect a google sheet with Oxford Dictionaries API. The API is well documented but nothing for google sheets (script) and I'm not up to speed with writing my own scripts in google. Our students enter words into the google sheet and definitions etc. are returned via the API.