interval

Hello! I want to calculate the following for each row: How many connected cells at the end of the row contain a character such as 'x', where cells separated by 'interval-1' empty cells are still considered in one chain and are counted. A chain of 'x' cells is only broken by 'interval' amount of...

Hi, I am hoping someone out there will be able to point me in the right direction as I have been searching for ages and can not seem to get anything to work that is not really long winded. A B C D E <tbody>...

I have some data I have inherited from several years back and no-one who was around back then is still around to ask. Year Question # Lower 95% confidence interval Scored percentage Upper 95% confidence interval No of responses for this question and trust 2014...

Hello everyone! First of all I have to say is a great forum! found really interesting stuff that helped me with my VBA skills. Secondly, I was wondering if someone could help me with a simple macro that I couldn't find online and is driving me crazy. What I have is a table with different...

I'm not even sure this is possible, but is there a formula that will calculate maintenance hours/miles/days in one column? I know that I can put in a simple C2+30 to get the 30 day date due and D3+100 to get the next 100 hour mileage due. But is there a way that I can tell excel to determine...

Hello all! I am far from an excel expert so I really need your help if possible. For work, I am trying to create a spreadsheet that's simple for our mechs to use. I'm lost as to if or how I can get the hours/date next due to auto calculate based on the PM interval type they choose from the drop...

Hello all, I have a huge csv file with a few hundred thousand rows. I would like to perform statistical calculations on it and also obtain the first row value, for each time interval. Example for every 300seconds, I would like to calculate the variance of the total number of rows within the...

Hi guys, I am looking for ideas from the wealth of knowledge within the forum - I will try to explain as best I can but I apologise in advance if I haven't explained it well. So, I have a worksheet with three columns (there can be more if needed) the first column shows the time period...

Hello this is a general question, not looking for code. If I have two computers in different location and not on a network, with the same application, both computers are able to edit data. what I like to do on a regular interval send data via email and each computer would have the others...

Hello, First post/long time lurker! I want to visualise the amount of time a telephone Agent has been logged in, per 15 minute interval. The below example shows the time an Agent has been on the phone, went to a break and then returned on the phone. I've got about 95% of the way there with...

Hi Guys , I have a table with three columns First contain date .. it take a form like (1/31/2018) Second contain time .. it take a form like (0:00:00) Third contain a variable speed that recorded for a mobile body Now , I kindly ask your help to find a way for extracting the maximum &...

Hi, I have a large set of data (50k+ rows) which contains staffed hours at 30 minute intervals for 3 different locations. What I am wanting to achieve is a total number of staffed hours for each 30 minute interval. (combining the 3 sites) So far I have tried SUMIFS (=sumifs(Staffed Hours, Time...

Hi, Can someone help me in getting a Macro Code for Data to be copied from one file to another on regular intervals Setup: 1. I have a file which has a data connection, set up to refresh every 5 minutes 2. The final data is displayed in the form of a Pivot Requirement: 1. Would want the...

I do a lot of forecasting and am tired of having to repeatedly write a formula from scratch to test whether or not my forecasts fall within the prediction interval. To be clear what I mean, is that I may predict a value of 1,000 with an 80% chance it will be within 900 and 1100. I need to test...

A1:A5 = No. of Veh., Speed, Circuit in Miles, Interval (min or sec), M/P Hour. The variables in B1:B5. So a typical "what-if" would be something like the Interval must be 1 minute, the Circuit Miles is 120... what would be the other values to meet the 1 min/120 miles set requirements. Other...

Hello learned folk. I have been given large files with a consistent format for the date/time of an observation as follows: " 08.03.2008, 23:00:00.000". There are thousands of date/times in a single column and what I want to do is calculate the time interval between successive observations. As it...

Hi, All. I have a spreadsheet that I would like to revise, but I can't figure out how to edit the formula. Can anyone help? Here is the formula: =IF($T$15>1.5,(IF([@Principal]<5999,FLOOR([@[Lending Wallet]],10), IF(AND([@Principal]>5999.5,[@Principal]<119999.5,[@[Lending Wallet]=]=>1010),1010...

Hi all, I am having problems sorting out a formula that can include all of my criteria. I need to find the average (column C- RR Interval) only if there is more then 2 values recorded in the past 7 days (Column B) for a participant (Column A- Name). Example is below: <tbody> Name Date RR...

Hello all, Is there a way to make a workbook require or remind a user to save at a set interval, say, every ten minutes? Didn't see it in options... Thanks!

HI all, I'm having an issue returning multiple results for a vlookup I'm using to tell me all instances that have occurred for a certain time period. What I have is a certain point in time in one sheet that I need to know all the downtime events that were occurring at that point in time. My...