Table Lookup: Look Up The Average Temperature Of A Piece Of Equipment

Dec 2, 2008

I have a table with average temperatures(120,125,130...220) on the vertical axis and equipment sizes across the horizontal access (size 1,2,3...11). At the intersections is the amount of heat given off the equipment. This table is used as a reference for another sheet in the same workbook.

Basically what the sheet is for is to look up the average temperature of a piece of equipment (given the size and exact heat given off). In order to do this, I need to interpolate using the 2 closest energy values and their associated temperatures. There's a better explanation in the file and it makes for sense when you're looking at it. Attached is the table.

View 3 Replies


ADVERTISEMENT

Create History Movement Of Equipment From Separate Table Or Within Table

Dec 17, 2012

I have a table with list of equipments and asset number assigned as primary key, I wanted to have a history movement of these equipments but my idea is somehow not logical and very primitive to update every time 2 excel sheets:

ie:

asset no
description
received by
day

[Code].....

View 2 Replies View Related

Graph Temperature Readings?

Jul 30, 2014

I'm trying to graph my temperature readings.I put my readings in 1 page in order for me not to use many pages when Im printing.

Is there a way that if I graph my temperatures it will give me a continuous graph?

View 2 Replies View Related

Minimum Temperature Between Two Dates

Jun 13, 2007

I'd like to try and use an array formula to return the minimum temperature between two dates. Say Column A holds a list of dates. Column B holds the temperatures for each of those dates in column A. Lets say that I want to return the minimum temperature between 10th Jan 2007 and 12th Jan 2007 with the daily temperatures being 9,10 and 11 respectively. I used the following array formula to return the maximum temperature between two dates and it succesfully returned 11: {=MAX( (A1:A10>=DATEVALUE("10/01/2007")) * (A1:A10<=DATEVALUE("12/01/2007")) * (B1:B10) )}

However when I try and use the MIN forumla the answer I get was 0 when it should have returned 9: {=MIN( (A1:A10>=DATEVALUE("10/01/2007")) * (A1:A10<=DATEVALUE("12/01/2007")) * (B1:B10) )}

View 3 Replies View Related

Lookup Table (adjust Which Column The Lookup Function Refers To)

Jun 12, 2009

I am trying to perform a lookup (vlookup) function in a cell in excel and wish to have the range as a variable, so that I can adjust which column the lookup function refers to.

View 4 Replies View Related

Can A Piece Of Code Copy Itself

Feb 22, 2010

I have a spreadsheet. it's not a big spreadsheet, it's not a complicated spreadsheet.

It links to another which is stuffed full of pivot tables and offset/match/index's.

For whatever reason the simple summary sheet regularly corrupts itself, i.e. when you close it Excel crashes (using 2003 on XP), it recovers but links are corrupted and when you open the last saved original that's corrupted too (it says data corruption has happened).

So I've added a piece of code which can recreate the corrupted spreadsheet from the corrupted version (it changes each month so a standard template won't work).

I'd like to not install an add-in on peoples PCs with the recovery code, but I can only do that if I can replicate the VBA in the new file.

can a piece of code copy a module of VBA from one workbook to another?

View 9 Replies View Related

Count One Piece Of Data But Only If A Second Criteria Is Met?

Feb 1, 2014

I'm looking for a formula that shows one piece of data but only if another criteria is met. Eg Column A1:A:100 show a piece of paperwork has been issued and column E1:E100 show the area that it's been issued to (North, South, East, Central)

I have a blank work sheet showing various % of things being late as a whole but also want to break this down into the four areas.

View 5 Replies View Related

Assigning A Number To A Particular Piece Of Data?

Dec 11, 2008

How do I go about assigning a number to a particular piece of data? To give a simple example of what I'm trying to do, and what I envision, I'll pretend I'm building a sandwich.

1=white
2=wheat
3=ham
4=turkey
5=roast beef
6=lettuce
7=tomato
8=mayo
9=mustard
10=cheese

So, someone could come along and build their sandwich, ham/turkey/tomato/mayo on white bread. Excel would then recognize that 1+3+4+7+8=23
23=The American (the name of the sandwich, which I've already assigned a variable to)

I'm using the sandwich model because its a lot simpler than what I'm attempting to do.

View 10 Replies View Related

Passing A Variable Into A Different Piece Of Code

Mar 6, 2009

I have a spreadsheet that has several buttons on that run code using the cells around the code for parts of the data. eg

ColumnA1 ColumnB1 ColumnC1 Button1
ColumnA2 ColumnB2 ColumnC2 Button2

I want the buttons to run a seperate piece of code to start, but then all buttons run a similar piece of code at the end. I am hoping to be able to pass a variable from the first piece of code each button runs into the section of code that all share (which I have done as a seperate macro)

View 9 Replies View Related

Extrapolation Calculator - Increase Cylinder Filling Temperature

Jun 10, 2014

I have attached the table with the values and have a red font for problem area.

I need to increase the cylinder filling temperature from 40deg.Celsius to 50deg.Celsius if possible.

O2 Cylinder filling.xls

View 5 Replies View Related

Inaccurate Array Formula: Temperature And Dew Point From Cells

Dec 11, 2009

I have an Excel document which receives data dump from a weather website cells B1:I20. I need the temperature and dew point from cells B3:I3, however the data is returned in a "Temperature / Dew Point" format. To use the data, I separate the Temp and DP into their own cells B22:I23 by:

View 2 Replies View Related

Lookup Function To Lookup For Data In Another Table

Jul 29, 2008

I am trying to use lookup function to lookup for data in another table (we call it table A). Unfortunately, whenever the code is not in the table A, Excel will return the data from the previous row.... is there any possible way to prevent this... in another word, if the code does not exist in the table A, I want Excel to return 0 or some other figures.

View 9 Replies View Related

Find Number Of Rows Between First Piece Of Data And The Last?

Jan 27, 2012

I have a spreadsheet like the one below. The data is just a bunch of 1s but they are in specific cells:

A1
A2
A3
A4 1
A5 1
A6
A7
A8 1
A9
A10

I need to calculate the number of rows between the first piece of data and the last. In the above example the answer would be A8-A4 = 4 Rows.

I am thinking I need an array that searches for the first data point, then returns the cell ID, does the same for the last data point then subtracts the higher cell id from the lower.

View 3 Replies View Related

If Function To Skip Large Piece Of Macro

Jul 23, 2013

I need to add something to my macro to delete a sheet if it doesn't have more than 40 rows of data. If it has more than that, it needs to do a whole bunch of stuff to it. I've already got the whole bunch of stuff written, I'm just not sure how to do the if function. I took a stab at it, but it wants the count to be an object. I am not very good at writing code.

Code:

Dim count As Integer
Set count = "COUNT('33M & 33RUL'!A:A)"
If waffle Is "

View 1 Replies View Related

Calculate Temperature Values Directly For 10th Iteration Without Solving Each?

Nov 13, 2013

I had 4 initial temperature values and after some time i got new temperature values. Now for calculating 2nd iteration i need to use new calculated values and for third iteration values from 2nd iteration is to be used and so on.

How to calculate temperature values directly for 10th iteration without solving each iteration?

View 2 Replies View Related

Excel VBA - Check Cells For Specific PIECE Of Formula

Jul 28, 2014

VBA to loop through all the cells, or an active selection, and if it finds a cell with a formula that starts with "=VLOOKUP" or "GETPIVOTDATA", then copy and paste values for those cells. If it comes across a cell that starts with "=SUM" then it leaves it as is. I've been looking for way to insert a wildcard to make this work, but can't seem to find anything.

View 2 Replies View Related

Lookup And Average Hours

Jan 12, 2009

For my business, I am tracking how many sales I am doing per hour. That one was easy. NOW I need to track the average number of customers that I have for each day of the week, Sunday-Saturday. I need for one page to look at another page and, every time the word 'Sunday' is there, take that row of hourly jobs and average them with every other 'Sunday' and give me the total average number of customers on each Sunday, Monday, etc.

Attached is my worksheet for review. If you look at the 'Tracking' and 'Balances' tabs, you'll get the idea......

View 6 Replies View Related

Lookup/Sumif/Average

Jun 12, 2009

I have data columns A-C

example:

Material Year/MonthHeight in cm
1000000006200902114.00
1000000006200902120.00
1000000006200902110.00
1000000007200903107.00
1000000008200901115.00
1000000008200901111.00
1000000008200903117.00

and over about 1000 rows.
On sheet 2, i have list of material numbers (about 60 in total)
what i need is a formula that will lookup each material number in the long list
and give me the average height for a particular month.

i.e. in example material 1000000006 average for period 200902
= (114+120+110)/3 =114.67
so i'd end up with on sheet 2 columns A-F
with headings below with relevant formula for each month.
Material-Jan-Feb-Mar-Apr_may

View 9 Replies View Related

Calculate Hours For Various Equipment

Jan 3, 2007

I've got a spreadsheet that lists multiple pieces of equipment and when it was worked on or down. It has the following columns:

Date
Jeep #
Start Time
Stop Time
Total Repair Time
Other Downtime (which is most often blank, as below)

7/18/06.......35.....1:00 PM.....2:00 PM.......1:00
7/20/06.......33.....1:00 PM.....2:00 PM.......1:00
7/28/06.......35.....9:00 AM....11:00 AM......2:00
10/18/06.....50.....6:30 AM.....7:00 AM.......0:30
10/18/06.....33.....9:00 AM.....11:00 AM.....2:00

(I hope the ... is okay, couldn't figure out how to make the columns line up.)

I can use Sheet Two for the next part, but I don't know how to to get a total time per month for each seperate jeep. Most of the time, there will only be one record per month per jeep, like the second line above. But lines one and three are for the same jeep, and so I need the formula to add column E up only for those two lines.

View 15 Replies View Related

How To Track Installation Of Equipment

Feb 7, 2012

I am trying to track installation of equipment in excel, I know what I want done, but not how to do it. I have 8 columns, and I want a yes in each column to equal 12.5% and a column to show progress at the end, I also want to show total progress for installation of all equipment at the bottom of the page

View 4 Replies View Related

Average Multiple Results For The Lookup

Dec 11, 2008

I have a lookup that needs to average multiple results for the lookup... columns
Q to W

Looks like it is only returning the first found value.

View 3 Replies View Related

Lookup Up Entire Table Not Just Column In Table Like Vlookup Does

Jun 5, 2014

I'm trying to see if you can look up multi columns for a number and when it finds it return back to one column and return that data?

I am trying to sort out territories for a state I work on; the territories are divided up by zip codes.

i.e.
A B C D

territory 1 12345 54321 11222
territory 2 22222 33333
territory 3 44444 55555

and what I want is to say put a formula in cell B3 on Sheet 1 pointing to cell C3 that has zip code 33333. I want it to then take that and look in Sheet 2 and search A1:D3 and when it finds 33333, return "territory 2" back to cell B3 on Sheet 1.

View 3 Replies View Related

AC Equipment Selector Using Index And Match

Apr 16, 2014

I have a list of equipment and want to select from three criteria to obtain the result; indoor1, Type and Power (all drop down) I have used index and match to get results in various cells but can't get a correct result for Outdoor and Indoor2, Indoor3, and Indoor4 (all coloured red).

Spreadsheet attached.

View 14 Replies View Related

Calculating Next Due Date For Rental Equipment?

Feb 15, 2014

I have a contract start date. The payment is due every seven days. I have entered the start date. i need the "next due date" to automatically calculate in the "due date column". here is my problem if a customer has a due date say on 2/15/2014 his next due date should be 2/22/2014. regardless if he pays on the 14th or 21st. i need this date to change each time a payment is made.

View 7 Replies View Related

How To Generate Sheets On A Status Of Equipment

Mar 30, 2014

I have difficulty to generate sheets on the Status of Equipment from the master sheet. I need to manage the maintenance and diagnostics of a plant, and I have a whole list of equipment, thus when any of those goes faulty, I want to enter the word "Fault" in Column G, Then It must automatically generate the Template for that tag, and name the sheet same as the Tag.

I have added an Attachment : Template for MnD_ExpertQ.xlsx‎

View 3 Replies View Related

Lookup Value In Range Then Average Offset From That Cell

Mar 10, 2014

I have 2 columns of data (col A is time, col B is a value), in a range A4:B1000 (can be less, but the biggest the range will get is to B1000). Example:

A / B
4 10:37:55 / 91
5 10:37:56 / 92
6 10:37:57 / 93
7 10:37:58 / 100
8 10:37:59 / 105
9 10:38:00 / 110
10 10:38:01 / 111
11 10:38:02 / 115
12 10:38:03 / 120

Im looking for a way in VBA to look for a time entered in cell C1 (example 10:38:00), find that in column A, then return the average of values in column B that are offset 271 - 300 rows. This is entered in D1. So in my example, 10:38:00 is in cell A9, return the average of B280:B310.

View 3 Replies View Related

Lookup A List Of Values & Average Results

Jan 25, 2007

I have a simple one today but on a time crunch so I don't have time to go through the book.

I am trying to hlookup a list of values from a table and average the results. The values are setup horizontally.

View 9 Replies View Related

Lookup 2 Different Criteria Then Average Between A Date Range

Jan 6, 2009

For those of you that love difficult ones, here's one..

I have a sheet that has a column of names.. Across the top row I have dates.. let's say from the 1st through the 31st.... in the body of the report i have different sales numbers and what I am trying to is the following...

1/1 1/2 1/3 1/4 1/5
Johnny 3 4 2 2 1
Becca 3 4 1 1 1

So let's say in this instance, mind you my real report is about 342 rows of names and stats.. Is look for Johnny between 1/3 and 1/4 and average those numbers between those 2 dates...

I've tried everything from sumproduct to vlookups and can't seem to get it right...

View 9 Replies View Related

Lookup Table That Will Lookup The Tuition

May 1, 2007

I need to place a lookup table in a work book and I'm not sure how to do it.Below is what I specifically need in my workbook.

c. The workbook will need a lookup table that will lookup the tuition, clothing
and entertainment figures depending on the selection of college, and will
ensure that only the colleges on the list are selectable. That is, the
worksheet will not allow the user to enter another college not in the list.

The lookup list must be on a worksheet by itself at the end of the workbook.

View 13 Replies View Related

Table Lookup (search On A 2 Dimensional Table)

Aug 4, 2009

I am attempting to do a search on a 2 dimensional table, based on Product Code/Month. Is there a function, addin or a macro that will allow me to do this? All I can come up with is a messy combination of VLOOKUP/HLOOKUP/COLUMN.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved