calc

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

Trying to calculate the percentage of projects meeting the target for each year. Here's what I came up with. Maybe there is a better way to do this, but I need it to work dynamically with changing data. What I have so far doesn't seem to return anything, just a null value... 'P-Std Calc...

All, I have a sum if function =SUM(IF(ISNUMBER('Line 4'!$D$4:$D$44903),IF(INT('Line 4'!$D$4:$D$44903)=INT('Line 4 calc Sheet'!B3),'Line 4'!$K$4:$K$44703<"95")))/60 So the first part is looking up a date and comparing the date. The part not working is 'Line 4'!$K$4:$K$44703<"95")))/60 Ever time...

All, I have this and get #value =SUMPRODUCT(--(INT('Line 3 data copy'!$D$4:$D$44739)=INT('Line 3 calc Sheet'!B3)),('Line 3 data copy'!E4:E44739<220)+('Line 3 data copy'!F4:F44739<220)+('Line 3 data copy'!G4:G44739<220)) D4 is a date 8/11/17 13:25 B3 is a date 8/11/17 E F and G are all data...

I've tried searching, and did find several threads about calculating time, but I didn't see anything that really connected with what I'm trying to do. So I have a table with an "entry date/time" and "exit date/time" (see example). The time columns are formatted [$-F40]h:mm AM/PM. What I'd like...

Hi All I am trying to create a Excel sheet for a Wage Calculator in Sterling £. This would include my Monthly wage and also working from that what my hourly wage would be. It needs to take in to account overtime worked and different rates and also work out the Total wage after tax. Can...

Morning All I've looked through mr excel and various forums and can find various code relating to progress bars on vba forms but not what I need the workbook to do. I have a large workbook which takes around 3 mins to auto calculate as a drop down box with date rolls all the figures along by a...

I have <50 sets of grouped rows in a spreadsheet (3 sub-levels of grouping at most) and for some reason it takes much longer to expand collapse one particular group vs. the others. The only thing I can tell that is different is that these rows contain 2 named ranges (both just 1 cell constants...

Hi all, I'm just beginning to verse myself with arrays and writing my own functions and was hoping someone could walk me through the following function. Not so much the formula for stdDev, but sytax such as mean(k,Arr)....what is that doing. I'm still a bit uncomfortable with arrays...

like when i create a csv contact file it wont upload to my email says please specify a valid file i tired aol mail yahoo mail hotmail gmail mail.com doesn't work says the same thing am i doing something wrong? also tried it with open office cal

I am a systems analyst and one of my users has a random problem with spreadsheets where she enters a formula and it does not calculate. She is using Excel 2003. Here are the things I have already checked out: Autocalculate IS turned on The numbers ARE really numbers and not text Editing...

Ugh, I rely on the bit of code below all the time to find the last cell but the problem is, my company has some people using Excel & some using OpenOffice Calc. 1 Dim LastRow As Long, i As Long 2 LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row 3 For...

I have a fairly large excel workbook (9420 KB), and it has just recently decided to no longer calculate. When I update numbers that I know will affect multiple worksheets, nothing happens. Yes, I have automatic calculation on. Even when I hit F9, nothing happens. The only way to get the...