I have a cyclic data sheet from where I need to get only the peak value in each cycle. Here's a sample of the data.
I have filtered only the positive part here. Same needs to be done for the negative cycles. Any help on the matter is highly apppreciated.
Heya, im barely great at Excel, and im struggling to develop a formula.
I have one sheet that has a Numeric result in ONE cell - S2
The number is ANY value, with ANY decimal point value
I need to put a formula in another cell that defines a grade 1-5 based on its value S2's value.
*Each Peak /...
I am trying to combine 2 formula but have difficulty as i do not understand excel that well, these are the 2 formula below
1st =IF(IFERROR(VLOOKUP(TEXT(B3,"dd/mm/yyyy"),Holidays!A:A,1,0),0)=TEXT(B3,"dd/mm/yyyy"),"off Peak"
Need two options for this guys. If Pivot how can I configure the sheet raw to populate on sheet Dashboard percentage base on the TRUE and FALSE details from SHEET Raw
Second approach if pivot will be hard formula I can use on Sheet DB to give me percentage;)
I am trying to complete a formula for the following
I want to check that if the value in NMI MIRN State says VIC OR NSW OR QLD then the value in Annual Peak KWh needs to be greater than 100000 or IF NMI MIRN State says NSW or SA then the value in Annual Peak KWh needs to be greater...
Hi there i have multiple tables all in the below format only much more data about 2000 rows and 200 columns. Column A describes the day for which each following month (column) was priced.
I currently have all the data for the peak table and off peak table. I am looking to create the query to...
Ok, so I've gotten a lot of use from this forum and now I have a question I haven't been able to find an answer to, I'm totally shocked by that fact...I'll probably learn I wasn't using the right search terms lol. Lots of detail here, possibly too much but hopefully better than not-enough :rofl...
I have a data showing 4 variables that i would like to plot on a single graph.
Time: X axis (in 5 second intervals)
Temperature: Y axis.
I would like to plot
The first 3 data sets look like this.
I am struggling with this which should be seemingly simple.
How can I assign a random binary value to a percentage of identified cells?
I have a column that indicates which cells I want this binary value to be associated with. My problem is when trying to chose both a percentage and...
Hi, there. I'm trying (unsuccessfully) to figure out how to calculate column L. Is there a way to identify the low value in each sequence of K "days under" data in something like the L column faked below? The formulas I returned don't seem to be checking the whole sequence, or identify the...
I have a mechanical schedule spreadsheet where i calculate all buildings energy consumption. I have to calculate Peak / Off Peak and Shoulder consumption. I am hoping someone can assist with the required easy calculation. I have bee given the sheet from a previous employee with calcs...
I am struggling with a formula - I know what I want to do, but I can't seem to wrap my head around how the formula is setup. I have daily data per each year per column (365 rows per column). I have used the following formula to generate a "4-day peak demand"...
I'm trying to show historical drawn down (not only the max draw down but each time there is a draw down) of return series, and for each of the drawn down to capture # of periods from Peak to Trough and # or periods to recovery.
Draw Down is defined as % decline from previous peak. in the...
I am looking to analyse equity drawdown of a portfolio. A drawdown is the loss from a peak to a trough of a portfolio, before a new peak is attained.
I would like a formula which returns me the current drawdown percentage since the latest peak, and so far I have managed the following...
I'm coming across a problem for a greater issue and was hoping someone could help with the first step. I'm trying to put together a staffing and sizing chart (the big problem, that I may ask for help with at a later date) but have a question for the staffing component.
Hi, first time user, therefore apologies if i am re-posting that which has been posted before.
I have the net cumulative total return daily series for the FTSE 100 and i am trying to write a formula that will calculate the peaks and troughs from start date to latest date.
So my dates are in...
I have a data set which is a recording of vertical ground reaction force during multiple hops. 30s long trial, 1000 Hz = 30,000 samples.
For each wave, I need to identify:
cell reference where value increases above a set threshold (e.g. >0.05 - marking the onset of the wave)
peak value of...
this is my first post and i am still a novice to excels wonderful capabilities.. so please bear with me and keep in mind that i am trying to learn it :smile:
i have a massive list (a lot of colums and rows over 90000 )- with a colum for a timestamp and a colum with values for this...