I'm just putting together a simple spreadsheet that calculates tax owed based on a few different bands. I have an 'Invoiced Amount' cell that takes up the yearly invoicing and then applies a tax rate to it based on the following conditions: If 'Invoi
I have two different Excel spreadsheets. They have almost the same data, but it has been updated so some entries are not there anymore or some items have been added. I feel that this shouldn't be too difficult, but I cannot figure it out. I have atta
How can I write a modulus that will select the following iterations in sequence? 1, 4, 5, 8, 9, 12, 13 etc (+3+1r) I'm working within a loop and counting posts (iterations). So for example, I could catch every third post (1, 4, 7, 10) by:- if ($i % 3
there is a vector (called f) f 3 4 8 it indicates which columns from a dataframe (y) should be included in a model. The column names of these columns are FER7, TOJ9, GHY11. Can somebody tell me how I could achieve that response~factor(FER7)+factor(TO
I am running a binary logistic regression in SPSS, to test the effect of e.g. TV advertisements on the probability of a consumer to buy a product. My problem is that with the formula of binary logistic regression: P=1/(1+e^(-(a+b*Adv)) ) the maximum
I am using the following Index match code with row function to avoid returning duplicates in my results. The formula currently search's my column B on my sheet 'Look Up Supplier Sheet' where it compares the value entered in cell D11 on sheet 1 and pr
I have a table with the following structure: Item Code item Description Minimum Quantity Maximum Quantity Reorder Quantity Current Stock in Location Current Stock in Main Location Replenishment Quantity I would like to calculate the replenishment qua
I have a string like this: 100 Stupid Street ; Government Tower 7; Chicago Palm, MA 92111 I want to return all the characters to the left of the last semicolon. So, To the left of the last semicolon would be: 100 Stupid Street ; Government Tower 7 Th
I'm trying to run a regression including the square of the independent variable. Other transformations seem to work, but the square isn't recognized. eg lm(y ~ x + x^2 + sin(x), data=as.data.frame(cbind(x=rnorm(10), y=rnorm(10)))) Call: lm(formula =
i'm using Spreadsheetlight for creating excel document. I need to use a formula on a specific cell, but it's not working. The code: report.SetCellValue(string.Format("{0}{1}", Report.CELL_MAP.ACTIVITY_CRU_COL, row), string.Format("=IF({0}{1}=0; 0; RO
My rng1 only contains non-empty cells to the last cell in column A. I want to count cells greater than the value in B1 in rng1. However, this formula didn't work and showed error was due to empty cells. Sub CountRng1() Dim rng1 As Range Set rng1 = Ra
I'm trying to make a formatting rule in Business Intelligence/Web Intelligence that changes background color of all duplicates based on one field (address id). The best I've got so far is this: =Previous([Address Id])=[Address Id] But that code only
I have an attendance spreadsheet with values "OFF", "VAC", "HOL" and "SCK". I am trying to identify abuse of the SICK day policy where employees use their SICK days to extend their weekends, vacation or holidays. I would like to count the number of t
I'm trying to figure out how to countif a range = one of multiple values using LibreOffice / OpenOffice Calc. So it would be where it counted if the value = one in a range of values (E.g B1:B20 contains all the values that would be acceptable for it
I want to Copy the Field value from one Form to other Form by @formula, How can it do it. Main Form name is "A", second Form name is "B", Form "A" Field include[ID/Name/AEmail],Form "B"Field include[ID/DateTime/Record/BEamil] When create a new record
I am trying to implement a mathematical formula in Python and I am quite the beginner at this so please work with me. I have two 3-column tab-separated files: For example: inputA: abandonment-n about-bring-v 32.5890 abandonment-n about-complaint-n 5.
Hello Programming World, I am using the Google Maps API v3 and I have a map overlay that I need specific coordinates from. In the image, I've managed to convert the two pixel coordinate sets from the top left and bottom right into latitude and longit
I have setup a pivot table to display some data. In a separate sheet, I would like to show all of the rows in that table based on the value of a cell within the table row. I would like to do this using formulas, but really have no idea how to go abou
How would I copy Excel rows to a new worksheet if a date time cell falls between 0000 & 0600 ? For example, for 10,000+ rows of data, in Column J, there's a date/time stamp "1/15/2013 0245". How do I create a formula which looks at the last 4 dig
I understand that in a formula like y ~ x I am looking at "y" as a function of "x". In maths this would be something like f(x) = x. In R, functions like xtabs can take formula objects without a left side, e.g. xtabs( ~ x). From my understanding of fo