How To Analyze Trends From Google Spreadsheet Inputs

Jan 15, 2013

I am using google spreadsheet to gather survey data:

The spreadsheet looks like this:

[Code] ....

Is there any way to compile the information and create a line graph to display the trend of A and B over time?

View 4 Replies


Downloading CSV File From Google Trends

Jan 17, 2014

I am writing a VBA for downloading a csv file from google trend.

In the first worksheet ,enter the search keyword in the excel file and the click a button to download the csv file and place it in another worksheet in the same excel file.

I have had some experience with downloading the stock stat. csv file from yahoo but then I realize this time is really a different story.In the google trend case, I cannot find a real URL of the csv file.

I strongly believe the solution is on [URL] .....

I have tested the code in #1 .It runs but cannot return a proper csv file just like Lloyd said. I do not understand what Kyle said. What do title and id refer to ?

Besides,I do not understand and cannot run the code in #6.

What is the input and output of this code?

When I run this, I face a Run- time error '-2147024891(80070005)'.

View 2 Replies View Related

How To Compile Data From A Google Spreadsheet

Jan 15, 2013

OK, I have a spreadsheet that looks like this:

File is in .csv format

HTML Code: 


Any way to compile data into a table that looks like this:

HTML Code: 


View 3 Replies View Related

VBA - Retrieving Data From Google Spreadsheet

Nov 8, 2013

I have a googlespreadsheet with 4 columns. date, id, name, positive/negative.

What I would like to be able to do is to call a procedure from an excel document to copy/retrieve all of the information between specified dates on the google spreadsheet and place into another worksheet in the excel document.

The spreadsheet is hosted in my googledrive and is confidential (i.e. I cannot publish it), so I am assuming I will need to add password credentials into the code, which will be an added complication.

View 1 Replies View Related

Create Basic Leaderboard In Excel / Google Spreadsheet

Jan 3, 2014

I would simply like to know how to create a basic ranked leaderboard through EXCEL or Google Spreadsheet, which i will later on implement on a community forum. I would like 2 entries for the leaderboard column titles, being:

Column B: POINTS

Then under A i will be typing all players manually, and similarly for B with points.

View 3 Replies View Related

VBA Macro To Take List Of Multiple Inputs / Apply To Another Spreadsheet And Return

Sep 22, 2013

I want to create a macro to take multiple inputs from sheet 2, apply them simultaneously to the inputs on sheet 1, take sheet 1's output and list next to the inputs on sheet 2. I want to apply this to a spreadsheet with complicated calculations. Example spreadsheet attached. Related Macros I have will do a similar thing but only take one input at a time. Code as follows.

Sub x()
Dim r As Range
With Sheet2
For Each r In .Range("A2", .Range("A2").End(xlDown))
Sheet1.Range("A2") = r
r.Offset(, 2).Resize(, 3).Value = Sheet1.Range("C2:E2").Value
Next r
End With
End Sub

View 5 Replies View Related

Analyze And Make Pattern From CSV File

Apr 5, 2013

I need to perform data mining from a CSV file,and use correlation function to analyse and generate a pattern from the provide data (CSV) for a particular set of error for a given time sample.

Find the CSV file which contains the data which needs to be analysed and generate a pattern.


View 4 Replies View Related

Excel - Duplicate Cell Search And Further Analyze Data Using VBA

Jul 1, 2014

I have an excel sheet with data from Column 'A' to 'S'.

I want to identify duplicate entries in Column 'J' and from those identified columns I want to further search Column 'K', highlight the matching text and then fill text in Column 'L' should have the missing data after matching the 'A' and 'K' cells.excel_duplicate_entries.png

View 9 Replies View Related

Excel 2007 :: Import Data From TXT File And Analyze?

Dec 23, 2011

I'm using excel 2007 and I'm trying to import data from a .txt file into excel and analyze the data. One of the columns in the .txt file contains descriptions for each row and its in multiple rows. Is there a way to import the .txt file so that it will show a description for each row in one cell?

I imported the data into excel but the issue is the description.

View 3 Replies View Related

Analyze Specific Data Based On Separate Criteria

Apr 22, 2013

I have a huge list of survey responses which asks people to identify their location and then rate how important 6 facilities in their area is (rating 1 - 4, 4 being most important). So the table has cells are similar to this, except that there are about 5000 responses with about 2500 different locations identified



I have been able to analyse the average results for the whole dataset by using the following formulas:

=COUNTIF(A2:C4,"camden") Count number of occurrences a location is listed
=ROUND(AVERAGE(D2:D4),2) Average response for medical centres
=COUNTIF(D2:D4,1) Counts number of times '1' comes up, would repeat '2', '3', and '4' to create a pie graph

But what I would really like to do it be able to count each response for each question by location (for example "Camden"). I've tried both of these but they don't seem to be working.


View 6 Replies View Related

Formula To Predict Trends / Outcomes?

May 2, 2014

I used three different dates. In which the outcomes were available. The first three sheets.

Is there a possiblity to use excel to calculate a future outcome of the next month(Sheet 4). The figures are in a way linear, because the previous months are in it.

So it's possible for the future outcome to go up or stay the same. It can't be less then previous months.

See attachments.

It's about a holiday (combinations) of arrangements. So it'll be influenced by the date (because of holliday plannings), finance etc etc. But the last factors/variables we will use and test in SPSS and other programs.

The question is more: Is there a program/formula in excel which will predict the outcome in the last sheet with maybe a factor of outliners (this coincendence of a better salary in some parts/or the date that people will book a holiday). And how the formula would be formulated in the last sheet?

View 2 Replies View Related

Finding Trends In Multiple Rows

Nov 21, 2008

I have revenue sheet that spans 12 months kind of looks like this:

0 | 240 | 261 | 0 |317 | 0 |0 | 0 | 0 | 0 | 0 | 155

So that is 1 row, my problem is I have about 8 thousand of these, and what I'm looking for is trends in lapsed accounts (accounts with no spend, the "0's"). As you can see I have 6 zero's in a row, which means this customer was lapsed for 6 months.

I want to run something that will find the average of zero's in a row for all 8,000 rows. For example one customer has 6 zero's in a row the other one has 3 zero's in a row so the average would be 4.5. I only care about zero's in a row.

View 3 Replies View Related

Using Line Graphs To Show Trends

Oct 19, 2009

I am trying to show some trends, from data taken on a monthly basis. The attached spreadsheet is an example of what I have:

The first two columns show data for Month1. The next two columns show data for the last 2 months (Month1&2). I was thinking of using a line graph, and showing Month1 and Month1&2 on the X axis. At time Month1, I'd have 4 different data points, for hw, sw, fpga and chip. At time Month1&2, I'd show the cumulative data for those same 4 categories. Over a period of time, we could see whether one area or another (hw, sw) keeps getting worse. How can I do this via pivot table?

View 3 Replies View Related

Macro For Picking Out Trends In Data

Dec 21, 2011

I am trying to write a macro that will automate the process of selecting rows from a data sheet. I want the rows to be selected based on the values in two columns. I want to find and select the row at the beginning and end of positions in a column where the values are equal. For a quick example, if my data looks like this below, I'd want to select the entire row for rows 2,3, and 6... I also need the row just before the value in both columns are equal.

row column11 column12
1 0 1
2 0 1
3 1 1
4 1 1
5 1 1
6 1 1
7 0 1
8 0 1

I have written this macro and it is not working... are there any obvious problems with this? This is new to me and I'm not exactly sure that I've used the correct commands. It also seems like LastRow is referencing 0 and not 12965 or whatever the last row of filled data is for the sheet.

Sub Deltadata()
Dim RowNum As Long, LastRow As Long
LastRow = Range("A" & Rows.Count).End(xlUp).Row
'Finds last filled row (should be 12965)

For RowNum = 3 To LastRow Step 1

[Code] ........

View 4 Replies View Related

Traffic Lights - Increasing / Decreasing Trends?

Aug 7, 2014

I need to conditionally format a cell to:

-return red/yellow/green when the value is below/above or within range of targets but dependent on an increasing or decreasing trend.

If the trend is decreasing and the value is above the target is should return red.

If the trend is increasing and the value is above the target is should return green.

For all there is a Threshold.

For example:

Value Target Trend TrafficLight
(A) 79% 90% Increasing RED
(B) 69% 70%-90% Withing Range Yellow
(C) 85% 90% Decreasing Green


for example (A) - Red: <80%, Yellow: 80%-90%, Green: >90%
for example (B) - Red: 60-90%, Yellow: 50-60%;90-95%, Green: <50%;>90%
for example (C) - Red: >80%, Yellow: 80-90%, Green: <90%

View 1 Replies View Related

Show Trends To Forecast Annual Inventory

Nov 29, 2007

I have 200 items that have 22 months of usage information each and need to:

1. In one column, show trend (up or down) based on the 22 months' activity for each item.

2. In another column, show/ forecast how much inventory will be needed for the next 12 months.

View 9 Replies View Related

Correlation Trends: Calculate The Trend Of Correlations Over A 4 Year Period

May 4, 2007

Column A is the COB Date Column B through N are various stock data. I would like to calculate the trend of correlations over a 4 year period. I can't seem to figure out how to manipulate the data analysis tool pak to do this.

View 3 Replies View Related

Excel Sync To Google Doc

Feb 17, 2014

Any way for an excel spreadsheet to automatically feed into or sync to a Google doc.

Unfortunately I have a dashboard which can only use a Google doc spreadsheet, so uploading the excel spreadsheet into Google drive wouldn't work. Nor vice versa as we have a Cube which feeds into Excel.

So the only way around this is for the excel spreadsheet to sync to a Google doc.

View 3 Replies View Related

Using Dates In Google Spreadsheets?

Jan 25, 2014

from what I can see working in Google spread sheets is very similar to excel

I have 3 columns with dates in them, what I want to do is set an alert if any of the dates in the columns are less than 30 days from today. This alert will appear on a different sheet of the same document in a column

I thought the following formula would work =if(B2-today()

View 2 Replies View Related

Automated Google Search

Jan 20, 2010

Is the anyway to have a macro wchich will automaticly open the IE browser when any of this word is clicked and search for this word in Google?

View 9 Replies View Related

Hook Into Google MAPS API

Mar 25, 2006

I have a userform which uses the WebBrowser control. The user enters a city and contry to a text box, which then calls google maps to display that area. I have a combo box on this form which list cities as well as a number. how I can link the city list on the google map to the city I have listed in my combo box and have the number associated to that combo box city appear on the google map?

View 5 Replies View Related

Upload Address Into Google Earth

Jan 11, 2009

I'm trying to accomplish. I have a series of addresses that I would like to import into a google earth type map (or similar mapping type program), which would put a "tack" type icon on the map where the address should be located, etc.

View 7 Replies View Related

Google Paid Search Ranking

May 15, 2009

I have this code which need to capture Rank & URLS of given keywords in Google paid search but now its not capturing any rank & urls, its gives no data found. solve this and modify it in such way that it record the position of the paid advert on the google page, advert title and description and then click on the ad to capture the actual landing page (not the landing page url shown in the paid ad).

View 3 Replies View Related

Reflect Changes Done To One Google Sheet Workbook On Another One

Jun 16, 2014

I have two different Google Sheets Workbooks;

I need that for ie: changes made on C3 of Workbook 1, reflect on E23 of Workbook 2.

View 1 Replies View Related

Formula To Analyze Dates And Graph Dates?

Dec 7, 2013

I want to numerically graph in a 2D stacked column graph the following:

Training Completed on "Time"
Training Completed but "Not on Time"
Training Not Completed

The training Due date was 10/30/2013.


View 6 Replies View Related

SUMIF With Different Date Formats (Google Sheets)

Aug 9, 2014

I have data which is exported from my system which includes the job date and gross profit amount. I want to find the gross profit total for each day based on a matching date. However, the data exported includes the time in the date cell and Google Sheets won't match it. I'd like to avoid using a helper cell if at all possible.

You can see the formula here : [URL] ....

Formula is on the Q column.

View 1 Replies View Related

Google Search Link Of Text In Column?

Sep 19, 2013

I have a long list of Titles in Column A. I want to be able to paste a link into Column B and it automatically searches the text next to it. I would like it to be simple. Something that is the same for every row, so I can bulk copy and paste.

View 13 Replies View Related

Searching Data In Google To See If Linked To Website?

Jul 22, 2014

I'm trying to see if there is a way to speed up the process of doing multiple Google searches to see if I can find a website attached to a text. I have a list of websites, and am trying to update the list to remove dead/inactive sites, and also find the URLs for the live sites.

The list looks like this (sample):
Comstock, Inc.
Contacto Latino
Core States
Crains Chicago
Crains Chicago Business
Crains Detroit
Crains Detroit Business
Crowell Weedon

Thus there's no website attached, and I need to manually find the URL myself. There are over a thousand cells in the list.

How to speed up the process of finding a url for these websites?

View 1 Replies View Related

Import Data From Mappoint And / Or Google Earth

Aug 30, 2010

I'd like to be able to find a location on a map and have this location automatically fed to my spreadsheet. The location info I need is the Latitude/Longitude.

Seems like this would be a piece of cake with Mappoint? Is there an automatic way to do with with Google Earth?

View 1 Replies View Related

Web Query Returned No Data Using Google Finance

Feb 18, 2012

I am trying to import competitor data into excel using google finance, but when I try to run the web query I get the message that "this web query returned no data." I have no problems when using yahoo finance and other websites so I think it has something to do with google, but I don't know what it is. I have been searching for some time now without any luck. My end goal is to make this a dynamic web query and incorporate it into a VBA code, but I need to get the web query to work first. Below is the text of the web query.


View 1 Replies View Related

Copyrights 2005-15, All rights reserved