calculations

Hi! I am stuck and needs some help/feedback. I am working on a turnaround time frame calculator to include weekends. I worked through some other threads to see if I could do it and I am having a disconnect. I started with this, and added in the following formula...

I'm learning about solar PV following this paper ((PDF) Building-integrated photovoltaic and thermal applications in a subtropical hotel building) and trying to translate the equations for "Electrical performance of PV module" into Excel. I've inserted the constants into cells and tried to...

I am new to pivot tables, and not versed in SQL, looking for a straight forward method, preferably in a pivot table. I have data that shows different numbers for the same rooms in a specific building. I need to know the total (sum) of the maximum number of students in a particular room. See the...

I have no idea where to start - i have searched the board and thought i may have found a pseudo solution but to no avail. This info may or may not be pertinent but I have 15 sheets - "Sheet1" I have set the Last Row as: Sub filtertests() Dim LastRow As Long 'Find the last row...

Hi guys, I forgot in the process to add data from power query to the data model, now when I have a lot of formulas referring to this table, I cannot change it as it throws error on all those formulas. Is there way to pause the evaluation? I remember I saw it somewhere but I don't know where...

I've looked around and could not come up with a good idea of how to accomplish what I would like to happen. Basically, I have about half a dozen different simple calculations that need to be done in the same cell, and what the calculations are depend on certain partial text that needs to be...

HI, I am a trader who wants to do some backtesting with excel. It went fine until yesterday. I discovered that my workbook won't finish its calculations, each time I press f9, shift+f9, ctrl+shift+f9 or change calculations mode from manual to automatic and vice versa it starts to calculate...

Morning! An easy one this morning (based on how clever everyone round here appears to be).... I have a spread sheet with various calculations in it. What I would like is for a cell to simply blank that cell if another cell on that row has a specific value in it. Example. The Column with the...

I have a savings account where interest is calculated daily and paid on the 3rd of each month. Most months the account is not touched but sometimes I might pay an amount in or take some out. Have created a spreadsheet with columns for amounts in/out, daily balance, number of days between...

I am an intermediate/advanced user of Excel but have never tried to learn VBA. All the work I do is very calculation and chart heavy, working with time-series and statistics etc. A typical worksheet might include several columns of price data, from which there are several other columns of...

HI Can you set excel up so that I can do manual calculations on one workbook only? I know how to do it on formulas tab but it sets all my excel workbooks for manual calculation and need one specific book only to have it. Any Ideas?

Assume that my workbook has 2 sheets, "A" and "B". Data will be uploaded in "A" and all the calculations and result finding will be done in "B". So for 1 upload in "A", 1 row in "B" will be utilized. During the next upload, the user will delete the data from "A" first and then upload new data. I...

The formula below is being used in a table to see which cells in the range have a particular conditional formatting color. When I enter the formula in the first row and excel auto-fills the other rows, the formula works. If I turn on automatic calculations, it gives #Value !. If manual formulas...

Hello I am using Microsoft Excel 2013. I am working on an estimating bill of quantities for Civil Engineering. In the Excel sheet 1 is the summary sheet 2 is the Office over heads and other costs sheet 3 is earth works sheet 4 concrete. In sheet 5 I want to build up the rates to use in each of...

Hi all, Fairly new to this. I've got a sheet where calculations are done, and a table where the results of those calculations are copied. A simple example would be that I have 5 trucks that work everyday for a week. Using the calulations sheet, I would enter the truck ID number in a cell, and...

Hi All, I need a bit of help with a calculating spreadsheet. I can seem to get the formula to work in cell AD9 because it is using the result of another formula in its calculations. I have posted a link to the document below. Can someone help me please? Chris :confused...

Hello, I have many measures (f.e. GDP:=sum([total rev])...) and I want these measures to have assign a characteristic (f.e. CF, or PL, or BS). Is there a way to map a measure to a characteristic in a data model? Thank you in advance

Hi everyone, I have a massive spreadsheet that auto-validates data from around 20 columns, utilising around 20 columns with advanced formulas, and about 20 named ranges. What I'm wanting to do is streamline the processing of these as much as possible. Most are 1-4 columns per "category". I was...

How do i post an xls file? thanks

Hello all This is a bit of a strange request I update a report with an add on tool in Excel called "XRL" When the report is updated "XRL" has switched the calculations function off. I thought of trying a worksheet event change to switch the calculations back on but this is not working unless...