analysis

Hi, I have a list of deliveries on one sheet where one of the columns tells me what restaurant I delivered from. I want that, when I enter a new restaurant (that I have never delivered from before), it automatically adds that restaurant to a colum on another sheet. This sheet is used for per...

I have seen a few posts similar to what I am looking to do, but nothing that seems to hit this question directly. My apologies if I am wrong. This is something I have found a few rough patches for in the past, but am looking to do in one straightforward formula (if possible) since I need to...

Hello there, please I need help as I have a data for a call center answering call survey, that survey set by a customer to get us his satisfaction grade about his waiting on Queue till call center agent answer his call, I have 4 Inputs: Group of Customer Average waiting time for customers on...

On a monthly basis, I run an analysis on a few entities based on certain criteria. To speed up the process, the analysis is driven by formula from the separate analysis tabs. This month I would create a May analysis driven by formulas. Above the May I have the same exact analysis tables for...

I'm starting an analysis of workload based on location and nature of the work done. I have 95 separate locations and 28 types of work. What I've started off doing is just apply <strong>=countif</strong> using the range for each specific location as they appear in the results of a search I've...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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)...

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...

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...

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...