using importXML Xpath query, in Google Spreadsheet
html,xpath,spreadsheet
I'm using Xpath in Google docs to get the text inside <div>. I want to save the text inside <div id="job_description"> in one cell of Google doc spreadsheet, but it shows each <div> in separate cell. <div id="job_description"> <div> <strong> Basic Purpose: </strong> <br></br> </div> <div> Work closely with developers,...
google-apps-script,spreadsheet
I have a sheet which I need to copy to hundreds of spreadsheets in a given folder in Google Drive. I am just beginning with script and I do not know how to proceed because the script below just gives me an error. Thanks. function myFunction() { var source =...
join,google-spreadsheet,spreadsheet
I have found many useful answers before, but this is my first question on this forum. Feel free to give me feedback about my question as well as an answer. Below is a link to a Google Spreadsheet in which students signed up for workshops for our career fair. I'm...
excel,google-spreadsheet,excel-formula,formula,spreadsheet
How do I write an excel formula, which randomly picks 2 dates in each week over a 2 year period, where: The 2 dates per week are not the same as each other So this should not happen: 05/02/2015 05/02/2015 The first date in any given week is always before...
google-spreadsheet,spreadsheet,pivot-table
I am trying to build graphic indicators from a (potentially) large set of data using google-spreadsheet. So far, I've used a pivot table to extract the information from the raw data, and I want to build intermediate tables to calculate the different values I need for my indicators. So far,...
function,google-spreadsheet,spreadsheet,google-spreadsheet-api,sheet
I'm trying to make a budget sheet for a trip. I got 2 spreadsheets. 1 contains the steps of the trip. The other contains a dashboard with the sum for each of these 5 groups of steps : "food", "activities", "shopping", "hotels" and "vehicle". My first sheet is like that...
excel,excel-vba,excel-formula,spreadsheet,multiple-columns
I want to compare "Sheet 2" "Column A" (which contains the name of 300 people) with "Sheet 1" "Column A" (which contains the name of 28 people). Now I want write down a formula on "Sheet 2" "Column B" to see whether those 28 people (Sheet 1, Column A) do...
html,css,character,spreadsheet
Backstory So I am doing a webchat as a side-project, and one of the issues I am encountering is making the UX of copying and pasting messages friendly. Right now all of the elements are organized within their own tags, spaced out and separated with CSS rules, in a way...
google-apps-script,append,spreadsheet,value
I've got a Google Spreadsheet which looks like this: ID | winkelName | 26/05/2015 | 1 | Foo | | 2 | Bar | | 3 | Foo2 | | 4 | Bar2 | | I'm trying to read and write an array of objects with the following structure: history[i].storeName...
vb.net,devexpress,spreadsheet
DevExpress website is unable to tell me. How can I influence the line color, thickness, etc. of created graphs? Dim chart As Chart = myworb.Worksheets(1).Charts.Add(Charts.ChartType.ScatterLine) chart.TopLeftCell = myworb.Worksheets(1).Cells("A83") chart.BottomRightCell = myworb.Worksheets(1).Cells("F112") chart.PlotArea.Fill.SetNoFill() chart.Series.Add(myworb.Worksheets(1)("A1:A71"), myworb.Worksheets(1)("B1:B71")) chart.Series.Add(myworb.Worksheets(1)("D1:D81"), myworb.Worksheets(1)("E1:E81"))...
excel,function,math,excel-formula,spreadsheet
I am trying to do the following: "Put a formula in D13 that will either Add Number 1, Number 2 and Number 3 or multiply them depending on what you put in D12. You should put in some sort of error message too if the user puts in something incorrect."...
regex,excel,excel-2010,spreadsheet
I have the following link in excel: http://en.wikipedia.org/wiki/Melon_Bicycles I would like to retrieve the link as: http://en.wikipedia.org In google doc I used: =REGEXEXTRACT(A1; "https?:\/\/(.[^\/]+)"), whereas A1 is the cell with the unformated link. Any recommendation how to implement that in excel 2010?...
function,google-apps-script,google-spreadsheet,spreadsheet
I'd like to implement a script to implement range protections on the different tabs of the spreadsheet when someone create a new spreadsheet by copying my template. The issue I encounter is when the script run through the protection implementation. My code seems to be fine as per the debug...
ruby,excel,spreadsheet
I'm trying to take an excel file and put it into Postgres. I can access the file and read rows from it. require 'spreadsheet' Spreadsheet.client_encoding = 'UTF-8' book = Spreadsheet.open 'C:\test\RubyTestFile.xls' sheet1 = book.worksheet 0 $test_array = [] sheet1.each do |row| $test_array += row end print $test_array My problem is...
excel,spreadsheet
I have a regional store manager that needs help in Excel. We will be comparing regional ranks within the national ranks. There are two sheets in the workbook. Sheet 1 columns A-C: RANK | National Store IDs | SALES (largest to smallest) Sheet 2 columns A-E: Regional Store IDs |...
google-spreadsheet,range,spreadsheet
I'm trying to compute the average of values in a range, but not including the lowest value. What I'd like to do is something like: =AVERAGE(SUBRANGE(SORT(A1:A10,1,FALSE), 1, 9)) Essentially, this would sort descending, then take the subrange consisting of all but the last element in the now-sorted range, and average...
analytics,spreadsheet,google-analytics-api,dashboard
Im working on a custom google spreadsheet analytics dashboard. Here's the situation, I'm trying to get specific info: Sessions, users, pageviews pageviews/sessions, avg session duration, bouncerate and % new sessions. The thing is I almost have all the right information except for AVG Session duration and Pageviews/sessions. Here's a screenshot...
excel,spreadsheet,autofill
I made a sample records of students showing if they're able to graduate based on the exam taken on Sheet 1, I just put 1 to mean that they passed that exam and blank if they not. To be under For Consideration you need to pass the Prelim and Midterm...
excel,excel-vba,excel-formula,excel-2010,spreadsheet
I have the following table: I would like to calculate the interest rate that I would get for all combinations in this table. The formula I use is for example: =$C$2 + $C$2*B3 Please note, that this is just an example. My real table is much larger and doing it...
google-spreadsheet,spreadsheet,google-spreadsheet-api
Using Google Spreadsheets, I need to enter data structured like the example below. There will be multiple "quadrants" Each "quadrant" can contain one or many "days", Each "day" can contain one or many "times". This data will ultimately be imported in some backend db (e.g. Access DB, SQL, MySQL)....
google-apps-script,google-spreadsheet,spreadsheet
How can I get keyboard events in Google Spreadsheets? I want to use this events in my script to format non-adjacent cells.
excel,google-spreadsheet,excel-formula,spreadsheet,openoffice-calc
I'd like to calculate the sum of multiple values for a range of overlapping dates. It should return the sum for a specific year and split the values that fall into more than one year proportionally. Example: ╔══════════╦════════════╦════════════╗ ║ Value ║ From ║ To ║ ╠══════════╬════════════╬════════════╣ ║ 100,00 € ║...
python,arrays,for-loop,spreadsheet,xlwt
For every 4 values in this array, I want it to write to a new row in the spreadsheet while disregarding the first column. This is because I'm going to be putting different values from a separate array there. For example, I have five columns: A B C D E...
python,spreadsheet,gspread
I have a data list (extracted from CSV) and I'm trying to use Python / GSpread to update a range of cells on a Google Doc. Here is my code sample: import gspread def write_spreadsheet(spreadsheet_name, sheet_id, data, start_row): gc = gspread.login('
[email protected]', 'password') wks = gc.open(spreadsheet_name).get_worksheet(sheet_index) start_letter = 'A' end_letter =...
google-apps-script,spreadsheet
Okay, first of all, what I'm trying to do is updating Google sheet and calendar simultaneously. So, let say if there's an update to your spreadsheet there will also be an update to the calendar. However, here's all the things that I failed to do. If there's changes in the...
google-spreadsheet,spreadsheet
So I am working on the same spreadsheet I have been working on for a bit now and it mostly works aside from one small quirk. If any of the queries in an array formula do not have actual data to query in the range they are hitting they return...
excel,excel-formula,spreadsheet,sumifs
I want to sum up all values that go for a certain country. I tried: =SUMIF(B2:B7;D2=$A$2:$A$7) However, I get 0 back as seen in the picture below. Any recommendations what I am doing wrong?...
java,hashtable,spreadsheet
Can we link another hash table for each key, in a hash table? My target is to have a very fast 2-d data structure to store cells in a spreadsheet. I'll store "all columns within a row" in a hash table. Then do this to all 'r' number of rows....
excel,powerpoint,spreadsheet
I use PowerPoint as a graphics template to type up football player names and there squad numbers. It can be a long procedure and so far following YouTube tutorials i have managed to create a form in Excel which can update the text boxes in PowerPoint at the click of...
forms,url,unique,spreadsheet
I want to send my clients in my database an e-mail with a request to fill in a Google form to research their needs for our service in the future. Every client has an unique ID already (for example EX0258, EA1405, EZ2815). I need a way how I can add...
ruby,excel,postgresql,gem,spreadsheet
I have a method that runs through an excel spreadsheet and puts those values into an array then into PostgreSQL. Everything runs fine but the cell values that hold dates are being returned as doubles. How can I get the date values? Also what if I don't know when a...