analysis

  1. K

    Creating a Pivot Table from a complex Excel sheet, how do I get this to work?

    Hello! I am attempting to create a Pivot Table from a complex Excel sheet. Below is an example of 1 item I am tracking.... this is 1 of 70, and they usually have 20 or so "Social Insertions". The goal of the Pivot Table/Chart is to have an easy to digest overview of the month and of the...
  2. S

    Phone Call Analysis help

    I'm in the middle of a custody battle with my ex and need expert help. I have an Excel spreadsheet with every phone call to and from my son. The calls can be from the ex to my son while he's with me, from me to my son when he's with my ex, returning missed calls, etc. Each call is logged with...
  3. E

    Automate calculation of percentages based on date range for dashboard

    I am hoping to create a dashboard for use in undertaking spot checks of work undertaken by members of my department. Data will be entered into a spreadsheet in the format of: <tbody> ID Date Status 1 Jan 2015 Green 2 Jan 2015 Green 3 Jan 2015 Green 4 Feb 2015 Amber...
  4. W

    Updating data from new CSV file

    I receive a weekly CSV file with the same number of columns, but differing rows. I want to create some sheets/tables to analyze this data, but how do I reference the CSV file each time? I was thinking of simply pasting the data into a "Data" tab that I reference from other sheets or tables, but...
  5. Z

    Data sorting with multiple subtypes

    Hi all, here's my problem: I am pulling information from a raw data workbook into a statistical analysis workbook. Each data entry is being sorted based on one of many criteria and because the criteria I need to use to separate the entries have multiple subtypes within each type I have run into...
  6. D

    Data analysis automation help

    Hi all, This is my first time using a form for excel help. I have a fairly good grasp on excel but have run into a brick wall with a model I am trying to automate. The model analysis one year of electricity prices. Each day of the year has 48 (half hour) periods with a price. eg. Sheet 1...
  7. F

    Data analysis involving two data sets of co-ordinates

    Hi all, I have a really pressing question. I am currently undergoing my final year research thesis and have carried out a quasi experiment. Now I need to analyse the data but finding it very hard. I have no clue when it comes to excel or data analysis so any advice would be good. I have four...
  8. M

    Cross Correlation analysis with two series of wavelets

    Hey all, This one will be a tough one to explain... I essentially have 3 columns of data and 40000+ rows of it. Column A measures seconds from time 0 to say 10. Column B is a series of values creating on a graph wavelets from a source detected by receiver one and Column C is the same series of...
  9. C

    Scenario Analysis - can excel help?

    Hi Guys, I'm trying to do some scenario analysis in Excel and am currently populating the table manually. Just wondering, is there a way to generate all possible scenarios within excel using a formula? The first few rows of the table look like below, and as its going to take me until 2018 to...
  10. A

    Question about correlation and regression

    Hi guys My question may sound a bit dumb so please excuse me :stickouttounge: In regression in data analysis isn't multiple r the coefficient of correlation? And if so shouldn't the function CORREL yield the same answer if used on the same data sets Because I tried comparing the number of the...
  11. H

    VBA Extracting Certain Things From Textfile Through Userform into Columns A B C

    I have question for you. I am creating an automation tool in excel. I need to copy and paste a Local Unix/Linux text file into a textbox (userform). However, I want to automatically extract data that starts with a certain prefix and skip all the stuff that I can't use (which is stuff that does...
  12. A

    Analysis of adding a extra row to a model with lot of macros.

    I have recently started working on a model built by some one else and I need to add a extra row to model. The Model has lot of macros on every page. So i need to know how adding an extra row is going to affect the macros. I don't know much about macros. 1) Please suggest how to go ahead. 2)...
  13. J

    Forecast Tickets using Budget

    Hello, I have my forecast for each month in 2014 of my budget. I want to forecast how many tickets I will be able to produce with that budget amount. I have the historical data from 2013 to use. I want to forecast how many tickets I will have February 2014 - December 2014. Is there any way to...
  14. M

    Best Free Fraud Analysis Excel Tools

    I would like to know if anyone knows where to find free fraud analysis tools online. Whenever I perform searches, it always seems to be pages of fee-based or shareware tools promotions. I'm looking for tools more interesting than duplicate analysis or simple chart-creation based on a range...
  15. M

    How do I find the frequency of 3 numbers in a 7 column row

    Hello all, I am having some difficulty in trying to get my head around a problem I am having in analyzing data in Excel and was hoping one of you wizards may be able to help me. I have approximately 2000 rows of numerical data in 7 columns. I need to find the most frequent three numbers that...
  16. S

    Excel / VBA Left Function (Fine-tuning)

    I'm trying to extract the first three characters in a cell and have found this which works for numbers and text apart from where the cell begins with a 0 or multiple 0's Sub CompareScheme() Dim SourceRange As Range Dim DestinationRange As Range Dim Z As Integer Set SourceRange =...
  17. L

    MDX Query in Excel from Olap Cube?

    Hello, Not entirely sure if this is possible... I'd like to somehow get a count of how many locations each player has scored 5 or more points in, details below. Basically there is an Olap cube set up which I do not have access to change. As a simplified example the data that I have is set...
  18. G

    How to create an auto ranking table

    Dear Recipients, Please take a look at the below chart. <table border="0" cellpadding="0" cellspacing="0" height="264" width="280"><col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78">...
  19. M

    Discretizing tick prices

    Dear All, I have historical prices of a FTSE 100 index. There are two columns, Times and Price. The time is uneven and is in seconds For instance: Time Price 2011-04-01T07:12:35.412Z 5949.6 2011-04-01T07:12:35.412Z 5949.4 2011-04-01T07:12:35.412Z 5949.4...
  20. C

    Analysing ranked data from questionnaire

    Hi, I joined this forum hoping someone will be able to stop me tearing my hair out! I have just completed vistor surveys of nature reserves and am looking to do some simple analysis of the results using excel, this is fine until i reach a few of our questions. We were asking what improvements...

Some videos you may like

This Week's Hot Topics

Top