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 A: PLAYERS
Column B: POINTS

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

View 3 Replies


ADVERTISEMENT

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: 

Timestamp,Choice,
1/10/2013,B,
1/15/2013,A,
1/15/2013,A,
1/16/2013,B,
1/17/2013,A,
1/19/2013,A,
1/26/2013,A,

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

HTML Code: 

Timestamp,A,B,
1/10/2013,0,1,
1/15/2013,2,0,
1/16/2013,0,1,
1/17/2013,1,0,
1/19/2013,1,0,
1/26/2013,1,0,

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

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 View Related

Put Together A Basic Spreadsheet To Track

Sep 15, 2008

I'm trying to put together a basic spreadsheet to track offensive plays for high school football. I'd like a formula that will change the LOS (Line of Scrimmage) to reflect the yards gained on the previous play. The problem is that you'd probably need negative numbers up to 49, and then back down to 0.

View 10 Replies View Related

Basic Dart Scoring Spreadsheet

Jan 15, 2010

I'm creating a basic Dart scoring spreadsheet, and its been going absolutely fantastic, but then I was asked to create the Sets and Legs, thats when I got stuck.

I'm looking for a formula (or anything) that will add a Set when the Legs reach the number 3, and then again but make it 2 if that player gets another 3 legs. If you know darts you will understand what I mean.

View 9 Replies View Related

Create Excel Spreadsheet For Investments?

Jun 17, 2012

I have a small loan business funded by multiple investors. A spreadsheet that could calculate each investors monthly share of cash flow. Can a party familiar with Excel create this custom sheet with my input. How would your charges be determined.

View 2 Replies View Related

Setup A Basic Stock Control Spreadsheet

Feb 22, 2009

I've set-up a basic stock control spreadsheet. Part of this requires updating prices of products. My approach was to use 3 columns A,B & C. C would show the current unit price of a product. Where there is a change in price this would be entered in A which would then result in a new average unit price to be calculated automatically in C. When ever this change occurs i need the then 'old' price which was in C to be shown in B aswell.

I've tried using various averaging formulaes but i'm thinking they were probably to basic or just plain wrong

View 9 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

Create A Basic Stock Quote Reader?

Jul 12, 2012

I am trying to create a basic stock quote reader.

I recorded what happens when I use the "from web" tool from the data tab. I then tried to modify it by allowing me to manually (with the inbox) put in the ticker that I want. When I run it, it does nothing. When I manually put in the ticker symbol for the company, it works.

For instance, I I were to replace

"URL;http://ca.finance.yahoo.com/q?s=" & TICKER & "&ql=1", Destination:=Range("$A$1"))
with
"URL;http://ca.finance.yahoo.com/q?s=ATVI&ql=1", Destination:=Range("$A$1"))

It would then work, but I would have to manually change it every time.

Here is the code
___________________________________________________________
Sub Macro1()
Dim TICKER As String
InputBox ("enter ticker symbol")
Cells.Clear
With ActiveSheet.QueryTables.Add(Connection:= _

[code]...

View 1 Replies View Related

Create Basic UserForm. TextBox, Buttons...

May 25, 2007

I want to do is have a User form that allows a user to add a new column across several sheets (i.e. b2, then c2, then d2) where what the user has selected from 3 defined ranges (in this case commodity, pack_type and pack_spec) is concatenated. see the example attached. So for exmaple, I would like the choice of adding into cell B2 across all sheets (except sheet pack) gold solid 5kg. Then I can add the next into c2. I have tried searching few a few examples of userforms with various problems but I dont know how to code it correctly.

View 4 Replies View Related

Use IF And AND Functions To Create A Basic Input-output System

Nov 18, 2009

I'm trying to use IF and AND functions to create a basic input-output system. The problem I have (more details below) is the 64 limit when the potential inputs could be infinite.

For values entered into a cell between 1 and 10, this should produce an output of 0.00 in another A value higher than 10 should output as 1.00, and from then an extra 1.00 is added for every '10' added. There is no limit on the input ie 1 = 0.00, 11 = 1.00, 29 = 2.00 and so on.

View 2 Replies View Related

Error Formatting When Import Data From Google Into Excel

Feb 16, 2013

I use Google Spreadsheet to feed some data online. Later on I use Excel to import this data that it is hosted at Google to do a better handling (reports, charts, etc). However when I import the data from Google, the contents of 1 row is splitted on 4 in Excel.

Are there any way to keep the same formatting from the original ?

[URL]

View 5 Replies View Related

Google Image Search From Cell Contents Of Excel File?

Apr 5, 2014

i have an excel file with hundreds of rows of product codes which i need to download images for. is there a way this can be done directly from excel? basically if cell A1 has product name and Cell B1 have product code, id like Cell C1 to generate a link that will use the contents of B1 as the basis of my google image search. can this be created using a macro?

View 9 Replies View Related

Macro For Returning URL Of First Search Result On Google From Keyword List In Excel

Apr 3, 2013

So basically I have an Excel sheet which has keywords that need to be entered in Google search. I need the URL of the first page of the search result that appears after that keyword is entered. IS there a macro for the same?

View 3 Replies View Related

Retrieving Names Of Places From Google Maps For Selected Region In Excel Sheet

Nov 2, 2011

Retrieving the names of all places in excel sheet as per Google maps or visible in google maps for a selected District / State / Country.

View 9 Replies View Related

Create An "Insert Row" Button In An Excel Spreadsheet

Jan 15, 2009

Can anyone tell me what the macro code is to do this (at whatever box I have selected at the time)

say my box is selected at E3, then when I click the button, it creates a new row E

likewise for F7, AA1, etc...

View 3 Replies View Related

Difference Between VBA Excel 2003 And Visual Basic 6.0?

May 3, 2012

whats the difference between vba excel 2003 and visual basic 6.0 I don't understand, if it is the same or complete different.

View 3 Replies View Related

Excel 2010 :: VBA Code To Extract HTML Source Code Not Working On Google Sites

Dec 6, 2012

I have previously used the following code to successfully pull out IE webpage source code for string manipulation.

Its a crude example to demonstrate the principle:

Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Public IE As Object
Sub Sample()
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

[Code] ......

However when I substitute in a Google websites address into the IE.Navigate command, the code runs to the "Source_Code = IE.document ...." line then flags up a Microsoft Visual Basic error. "Run-time error '438': Object doesn't support this property or method"

The webpage that I am trying to access is a confidential company site, so you won't be able to access it yourself, but starts with [URL] ......

The one thing that I have noticed about this website is the Privacy Report icon in the lower right status window (Picture of an eye with a restricted symbol in front). I don't know whether this is the cause of my problem, or purely an incidental observation.

Is there something peculiar with Google sites that means that the source code cannot be extracted in general, or is this an issue specific to my site ? Does the Privacy Report icon have any relevance, and if so how do I switch that off ?

Using :
MS Excel 2010
IE Explorer 8.0

View 1 Replies View Related

Visual Basic Code - Open Local PDF At Specific Anchor From Excel?

Aug 8, 2012

I want to create a series of hyperlinks in excel to pdf's stored on a local drive/CD as a kind of database. This much I can do with a nifty bit of code I saw someone put up here as follows;

Sub Run_Local_PDF()
MyPath = "C:Program FilesAdobeReader 9.0ReaderAcroRd32.exe"
myFile = "C:Documents and SettingsmynameDesktoppdffilename.pdf"
Shell MyPath & " " & myFile, vbNormalFocus
End Sub

Which works great and is sitting snug in a module. However, the document I am linking to has various anchors in it which exisit as sectionheaders. One of which is "Contents".

Is there a quick way I can alter my exisitng VB code to open at one of these anchors?

View 2 Replies View Related

Using VBA Code In Visual Basic: Develop A Stand Alone Program In Visual Basic

Jun 3, 2006

I would like to do is develop a stand alone program in Visual Basic ( not in Excel VBA) to update the price file in our Portfolio system automatically using the downloaded Excel format file csv extention file from the BigCharts. But before that, I need to export the *.pri file from our Portfolio system in to Excel which still saves as *.pri extention. Then once it updates, I import the updated *.pri file back in our Portfolio program. I understand that the Excel VBA code can be incorporated in Visual Basic code provided there is an object declaration for Excel file (In this case eventhough the both files are in Excel format, they don't have xls extention). how to use external files and Excel VBA code in Visual Basic?

Below is the code that I currently have in Visual Basic. What I'm trying to accomplish is using the ticker (eg. msft) as a keyword search to look up in the price file. If found , the price of that ticker from the test.csv file will be copied in to the price file which is test.pri. I haven't ran it yet.

Sub UpdatePrice(BigChartPath As String, BigChartName As String, AxysPricePath As String, AxysPriceName As String)
'Below are Excel VBA codes
'Uses the test.csv to look up tickers in test.pri and update the price in it
Dim PriceFile As Workbook, BigChartFile As Workbook
Dim PriceFileSheet As Worksheet, BigChartSheet As Worksheet
Dim MaxRows As Long
Dim PriceFileRow As Long
Dim BigChartRow As Long
Dim BigChartFound As Boolean
Call CheckBookOpen(BigChartPath & BigChartName)
Call CheckBookOpen(AxysPricePath & AxysPriceName)
Set BigChartFile = Workbooks(BigChartName) 'Big Chart website imported CSV file saved as test.csv...............

View 5 Replies View Related

Excel 2010 :: Checking If (Trust Access To Visual Basic Project) Ticked

Sep 17, 2012

I have a macro that seems to work okay for older versions of Excel - I use Office XP (2002) tell me if this will work for newer versions (2007 / 2010)?

KB1017 - Trust access to VBA project

Code:
Function VBATrusted() As Boolean
On Error Resume Next
VBATrusted = (Application.VBE.VBProjects.Count) > 0
Exit Function
End Function
Private Sub Workbook_Open()
If Not VBATrustedAccess() Then

[code]....

I was thinking that i should probably have

VBATrusted = -1

as the third line so that it is negative unless the tick is there. No way of checking older versions right now though.

View 3 Replies View Related

Create A Spreadsheet Where A Certain Value Is Added?

Apr 11, 2014

I need to create a Spreadsheet where a certain Value is added to the from of the data I enter into the cell. For example: All of my MAC Addresses start with 00:80:64. I want to be able to just type in the last three entries into the cell and have Excell automatically add the value 00:80:64 So I want to be able to add a specified value to ebvery entry in a collumn.

View 1 Replies View Related

Vba To Create A New File From Spreadsheet

Mar 27, 2008

I have the following spreadsheet:

A-------------B
File No.-----PRODUCT TYPE
123456-----NDT
123456-----NDT
123456-----NDT
123456---------
123456---------
789110---------
789110---------
789110---------

What I need is if there is an NDT in Column B and 123456 in Column A then I need to eliminate all rows which contain 123456.

End result

A
789110
789110
789110

View 9 Replies View Related

Automatically Create New Row With New Entry From Different Tab / Spreadsheet?

Mar 24, 2014

I've got a master spreadsheet grabbing data from 12-13 different tabs/spreadsheets.

One of those has a table, and I was wondering:

Is it possible for the master spreadsheet to automatically add a new line every time someone adds a new line and creates a new entry in a different spreadsheet?

In other words,

If there is a table in the master spreadsheet, and someone adds a new line, is there a formula which allows the master spreadsheet to add a new line in order to autopopulate?

View 7 Replies View Related

Create A Find Button In The Spreadsheet

Jan 15, 2009

I'd like to create a button that makes the "Find and Replace" popup come up when pressed. How to do this? (Ctrl + F is the shortcut for it)

View 3 Replies View Related

Create A Spreadsheet In Which The Cell Will Tell How Many Hours, More Or Less

Nov 14, 2009

I'm trying to create a spreadsheet in which the cell will tell me how many hours, more or less, i have worked a week.

Below is what I’m trying to create - but I'm having trouble.

- if the total = 35 (in cell A1) then display -2 (in A3),
- if the total = 36 (in cell A1) then display -1 (in A3),
- if the total = 37 (in cell A1) then display 0 (in A3),
- if the total = 38 (in cell A1) then display 1 (in A3),
- if the total = 39 (in cell A1) then display 2 (in A3), etc (and so on)

View 2 Replies View Related

Macro To Create CSV Files From Spreadsheet

Jan 27, 2010

How do I create VBA macro to create CSV files out of Excel spread sheet for each tab? Right now I am manually opening the spreadsheet and saving each tab as CSV file. But it is taking lot of time if we have lot of tabs.

View 14 Replies View Related

How To Create Buttons To Navigate Around A Spreadsheet

Feb 23, 2007

I was wondering how to create buttons such that when the user clicks on the button they are automatically taken to a different part of the workbook.

I'd like to do this because my spreadsheet is now large enough such that navigating just using the sheet tabs at the bottom is not ideal.

I can create a hyperlink, but I think a button just looks nicer.

View 9 Replies View Related

How To Create Multiple Spreadsheets From One Master Spreadsheet

Apr 16, 2014

I am trying to find a code that will allow me to generate multiple sheets depending on what is selected in one specific column. I have found a code that is perfect for this however I can't seem to set the range. For example instead of copying all of column headings I only need to copy up to column AN2.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved