How To Predict Next Appearing Sign
Jul 11, 2014
I have my results in cells B2:B55 consisting of three signs which are 1, X and 2.
AB1DateResult218-08-131325-08-132401-09-13X508-09-132615-09-132718-09-132822-09-13X925-09-1311029-09-1321102-
10-13X1206-10-1311313-10-1321420-10-1321523-10-1321627-10-1321730-10-13X1803-11-1311906-11-1312010-
11-1312117-11-13X2224-11-1312327-11-1312401-12-1312508-12-13X2611-12-1322715-12-1312818-12-1312922-
12-1323005-01-14X3112-01-14X3219-01-1423326-01-1423402-02-14X3509-02-1413616-02-1413719-02-1423823-
02-14X3926-02-1424002-03-14X4109-03-1414216-03-1414323-03-1414426-03-1414530-03-14X4606-04-1414713-
04-1424820-04-14X4927-04-1425004-05-1425111-05-14X5218-05-1425325-05-1415401-06-1415508-06-1415611-07-14?Sheet1
Is there any way the next falling sign can be predicted in cell B56? And if so, what would be the measures to guess the next sign?
View 7 Replies
ADVERTISEMENT
Dec 8, 2009
I'm trying to solve a strange problem in a piece of code.
I have a variable that is define as Double called STD. When i try to insert that variable in a formula the decimal sign (for me a comma "," because I'm Portuguese) gets converted to ";" (which is for me the separation sign for the expressions in excel formulas. ex: AND(A1>0;B1>0)=TRUE). The code is:
View 4 Replies
View Related
Sep 29, 2006
My boss uses the + symbol and the = symbol in his formulas eg "=+E3*E4" What is the advantage or difference in this as to just using "=E3*E4"
View 3 Replies
View Related
Jan 10, 2008
In a formula, what effect does putting a plus sign after an equals sign? e.g.
=+((1+B8)^12)-1. I orginally assumed that it made sure that result the would always be positive but I was wrong.
View 2 Replies
View Related
Sep 1, 2007
I have 3 columns of random numbers... it the first 2 columns the numbers range from 01 to 19... and in the 3rd column they range from 01 to 15
The total number of numbers in each column is 30... and i want to know is there a way to pridict the 31st set of numbers?
View 8 Replies
View Related
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
Dec 28, 2011
I have 11 months of sales commission data, and need to estimate the value for December. However, the catch is, for the first 7 months, the values are significantly higher than the most recent 4 months. I'm currently using the TREND function to guesstimate the December value, but with the wide fluctuation between the 2 time periods, I'm thinking the result of the TREND value may be way off.
Is there a way to 'weight' the data to reflect the higher values earlier in the year, with the much lower values later in the year?
View 5 Replies
View Related
Jan 17, 2014
So I have some stats I have been tracking for NHL hockey games. I want to find a formula that is predictive of future outcomes, based on whether or not a team has a statistical advantage. Obviously, there are so many other factors, and there is no golden formula to accurately predict the winner of ever game. I want to find maybe a 70% success rate here. I want to be able to plug in all of the stats, and essentially have it tell me who statistically should win the game.
I have 11 independent variables (Stat A, B, C, D, E, etc.). I have a running total of how often the winning team had the stat advantage for each of these, and I think that should factor into the formula. My dependent variable is whether the team wins or not. how to do that with multiple independent variables.
View 3 Replies
View Related
Apr 29, 2008
I want the user to press a button on the spreadsheet and this should then result in a popup box appearing on the screen asking the user one question ie "what is the current rate"
The user will then enter for example 20%. I then want to transfer this number to cell A1 on sheet 1.
View 9 Replies
View Related
Dec 7, 2009
i had a situation where i import data from web.The sheet contains date & other columns.Whenever,i copy the data and paste it in my worksheet Using Paste Special >> Values i get some numbers instead of Dates.How would i correct the numbers to date format with out loosing the original date format(DD-MM-YYYY). Also the dates are aligned irregularly when i paste them to column.
View 3 Replies
View Related
Dec 10, 2008
I have a workbook with several drop-down lists. The names for the lists are on a seperate sheet in the same workbook. I have used data-validation and allow list in all the cells with drop-downs. I have used =NAME in the source. I opened the workbook this afternoon for the first time in a couple of days and I am no longer able to select from a dropdown. I can type in the cells, but if I type something not included in the list, I get the "The value you have entered is not valid" error. So I feel like the validation is working on the cells, I'm just not able to select from a drop-down list. "In-Cell dropdown" is selected.
View 9 Replies
View Related
Apr 16, 2012
I have a work sheet with multiple columns and rows. In one column there is unique number which is appearing in multiple rows but it is appearing in different rows more than once like this:
ColumnB
KA0012
KA0012
KA0013
KA0013
KA0013
Now i want to calculate this e.g KA0012 appearing twice as one number similarly KA0013 appearing thrice as one number how can i do it?
View 2 Replies
View Related
Apr 13, 2007
I am joining two columns of data. first col. has size in fraction format: 7 3/8
second column has text string:
HABITAT CINCY POD HAT ERA BLK/RD
Concatenate= HABITAT CINCY POD HAT ERA BLK/RD 7.375
Changing fraction to decimal, needs to remain fraction.
I have played w/ the formatting to make Number w/ zero decimal places and then selected Fraction, but no luck there.
View 9 Replies
View Related
Jan 9, 2008
Something seems to have happened to my Excel. When I make changes and close the workbook or application, the pop-up box asking "Do you want to save the changes you made to [Book1]?" no longer shows up.
So far I've tried running a macro with Application.DisplayAlerts = True, but that only seems to work while the macro is running.
View 9 Replies
View Related
Jan 18, 2010
I am trying to open a workbook, testt.xls, through visual basic. Below is the code I am using, but when I execute the code, no workbook appears. Excel itself does not even appear. What am I doing wrong?
Workbooks.Open FileName:= _
"C:Documents and SettingsRaMy DocumentsPortfolio Documents estt.xls"
View 9 Replies
View Related
Feb 20, 2007
I have a timesheet from which i need to calculate the number of hours put in by employees on a weekly basis.The timesheet can vary with months and number of employees can also change.
Part of code is below:
Dim i As Integer
Dim j As Integer
Dim c2 As Range
Dim startday As Integer
Dim tempnd As Double
Dim tempdys As Double
Dim weekndsum As Double
Dim weekdysum As Double
Dim store_date As Date
m = 12
store_date = thisDate
For i = 20 To 400 Step 5 "value hardcoded
In this i have hardcoded the value,I need it search auto and run till the last used cell.It should replace the number 400 {in my code above}with the last row used.
View 3 Replies
View Related
Apr 23, 2014
I created an addin with CUSTOM tab (used custom UI editor) to manipulate the ribbon xml.It works fine at home computer and @ work I distributed and install in user> addin directory and activated using excel options> addin>
But the ribbon I created does not appearing (tried on couple of computers) no luck
View 9 Replies
View Related
Jun 3, 2014
I would like to parse the below :
Say this appears in A column , I want to parse all the characters appearing after the numbers (i.e., 8.625% /5.875%/6.125% ) in B column - Any excel formula ??
Alere Inc. 8.625% October 1, 2018
Delphi Corporation 5.875% May 15, 2019
Delphi Corporation 6.125% May 15, 2021
So B should column like below
8.625% October 1, 2018
5.875% May 15, 2019
6.125% May 15, 2021
View 3 Replies
View Related
Feb 21, 2014
I have the following code:
[Code] ........
HierLastRow shows as 165 in Locals which is correct. When I look at HierUID in Locals the Range is B2:B2 and not B2:B165. How can I make the Range set correctly?
View 2 Replies
View Related
Mar 24, 2014
Basically upon opening my workbook, I have some code that runs to loop through all the sheets and make certain sheets visible based upon which password the user enters. However, I also have some code upon activation of some of these sheets to have a msgbox pop up explaining what the sheet is about. I obviously dont want these to appear when the initial loops is going through activating the sheets one by one - I only want these msgboxes to appear when the user subsequently opens one of these sheets.
View 4 Replies
View Related
May 17, 2013
I have an excel table as below from where I am generating a pivot table:
Region
Project Name
Is this a new Project?
CE
AA
Yes
CE
BB
No
[Code] .......
The pivot looks like this:
I just need to show the records which are "New Projects" (for which "Is this a New Project?" is "Yes"). Hence I am filtering the pivot for "Yes" records only.
All regions are not appearing in the pivot. I also need to show other regions which are missing (viz,ESE & WE) with 0 values.
View 4 Replies
View Related
Jul 26, 2008
I know the code is long, and bad, but I'm including it anyway in the hopes that it will give some clue. The activeworkbook.refreshall refers to a bunch of queries on other tabs of the workbook using VisualFoxPro ODBC if that matters...
View 9 Replies
View Related
Dec 10, 2009
to create a macro that counts a number of values for a couple of types. The list looks like this;
29 bananas
13 apples
18 bananas
14 pears
7 pears
etc.
So i want to create a loop the goes through the list and adds up all bananas, apples and pears. How do I do that in the best way?
View 9 Replies
View Related
May 31, 2006
i have been having this problem with my version of excel at work and it is driving me crazy. First of all this is excel 2000. For a while now I have been unable to use the control toolbox - when I click it - nothing happens. In the meantime I havent been doing anthing really serious so I used the forms toolbar. I have tried using the control toolbox in word - and it works - just in case someone had been messing around and uninstalling things. Is there anyway that I have hidden it somewhere?
View 6 Replies
View Related
Oct 7, 2006
I must highlight cells that appear more than once.
What I mean is that if an item in a cell appears more than once I highlight it in blue, if the same happens twice I highlight that cell red etc and so one. does anyone know how to do this in excel.
View 9 Replies
View Related
Dec 15, 2006
is there any way to hide the comment box associated with with red triangle in the cell.when mouse is on the cell having comment (red triangle) the yellow colour box should not appear.
View 8 Replies
View Related
Mar 28, 2007
I am having a major issue with one of the functions of excel I never knew existed: the data form. Somebody created the spreadsheet I am using before me so I am editing what someone else has already done. They have a spreadsheet set up that holds multiple records about company information (a database you could call it). A data form has also been set up which works nicely to edit records. The issue I am having is that I was asked to insert one column to the database, which I did. Now I cannot figure out how to add this last column to the data form. I tried reselecting all cells, trying to recreate the dataform, but nothing works!
View 3 Replies
View Related
Mar 5, 2008
I have not asked for this Dialog Box, but it appears when I open the workbook.
I must have done some strange things - hope someone can give me a hint.
I have attaced a picture of the Dialog Box.
View 9 Replies
View Related
Aug 8, 2009
Suppose a name is typed in a cell as the First name in the front and the Last name following it e.g. Jupiter Jones.
Can it be reversed in the same cell so that it appears as Jones Jupiter i.e. with the last name in the front and the first name following it.
View 5 Replies
View Related
Dec 7, 2012
I have uploaded a sample sheet to illustrate what I am looking to do.
I want to pull out all instances where the four sheets of a 'book' are the same and appear in the same order. (column b is not really important) I have thousands of 'books' in the sheet so doing the task manually is not really an option.
View 2 Replies
View Related