I need a date formula in Oracle SQL or T-SQL that will return a date of the previous week (eg Last Monday's date). I have reports with parameters that are run each week usually with parameter dates mon-friday or sunday-saturday of the previous week. I'd like to not have to type in the dates when i run the reports each week. The data ...
I need to achieve the following when opening an HTML in Excel (Response.contentType="application/vnd.ms-excel") : force Excel to consider content of td cells as numbers make the above so that any subsequent user-entered formulas work on these cells (when the spreadsheet is opened) So far I was successful with adding style="vnd.ms-exc...
Even something very rudimentary is fine. Like entering and evaluating something like x+1, where x is a variable I get to specify. I was thinking of writing my own using Strings for each formula, regex for parsing them, etc., but let's assume my goal is to be as lazy as I can possibly get away with, and that if there's another option (e...
I'm looking to allow the user to export an reporting service report to Excel. The question I have is how do I specify a formula within Reporting Service which is then present as an Excel column calcualtion on the exported file? Currently all I can seem to export is end results of the Reporting Services report but I have a need for the u...
I made a custom list, it is actually a form fill out for an absence request workflow. Before publishing it I found a flaw. The first textbox is a Person or Group textbox, this helps out to retrieve the Active Directory username, but the flaw is that I can type whatever username I want, Example: "User X is logged on, but if he types User...
I need a way to look at one type of event as a basis, and then graph how several other events interact with the base event. Example: data set of events has occurred for a group of locations (1000+ locations): event 1 occurs ~every 4 weeks over course of 6 months event 2 occurs ~2 weeks over course of 6 months event 3 occurs randomly, no...
I have a command line utility that generates one simple crystal report. I recently updated the project from .NET 1.1 to .NET 3.5 using the Visual Studio 2008 migrator and am now getting an error that I had never received before. The problem is in the work_order formula which is as follows: stringVar nvl_ship_wrk_id := "0"; stringVar n...
This is an Excel formula with nested IF statements: =IF((B2="East"),4,IF((B2="West"),3,IF((B2="North"),2,IF((B2="South"),1,"")))) To essentially accomplish this: If cell B2 = "East" return "4" ElseIf cell B2 = "West" return "3" ElseIf cell B2 = "North" return "2" ElseIf cell B2 = "South" return "1" Else return "" ...
I am using MS Excel on a Mac. I have a formula. Guests!A1 & " " & Guests!B1 & I WANNA PUT NEWLINE HERE Guests!C1 ... How do you do this???? Thx! ...
can we execute a formula without moving cursor from the cell? After giving data in to Input cell either we press enter or we move from that cell and then any formula related to that gets executed. Is there any way that while entering input itself we can see the result in output in excel?Please help me in finding this option. ...
I've wrote a parser in PHP that converts a string representation of an equation to RPN based on feedback from an earlier question. Whilst testing it I found two different equations that parse to the same thing in RPN. Because they end up as the same thing in RPN when you solve them you get the same answer. 3 + 4 * 8 / (1 -5) 3 + 4 * 8 ...
I am using Excel to create some formuals to calculate a total dollar ammount (profit). At the moment there will be multiple rows that will calculate profit based on the amount of profit from the number above it. So say that Day 1 there is $1000 and that make 5% profit. Day 2 there is $1005 and that make 3% profit, Day 3 etc. Compoundin...
I need a formula to extract the last two words in a cell using openoffice. For example a cell contains the words: "enjoy the rest of your day" I would like to extract "your day" using a formula. I know how to extract the last word: =RIGHT(A1;LEN(A1)-FIND("*";SUBSTITUTE(A1;" ";"*";LEN(A1)-LEN(SUBSTITUTE(A1;" ";""))))) which results in ...
I've a report which shows five different activity codes. I'd like to sum all like codes and place a total for each of the 5 activity codes in a group footer. I have it working for one activity code, but would like to write a formula which will look for all five and total each. This is what I have: (if {@activitycode_id}= "Not Ready...
I've been looking all over, but I can't find anything free that will let me simply display math formulas on a window. I found one for Visual C++.net, but no APIs. Are there any out there? ...
Hi, I am needing to calculate the number of years between two fields; Field A Start Date (dd/mm/yyyy) Field B End Date (dd/mm/yyyy) Field C Calc formula display difference between Field A and B in years and months i.e 5.2 Thanks all. ...
I have a library that generates Word documents using the OpenXML SDK, one of the functionalities of the library is the generation of tables with formulas on the last row (such as SUM(ABOVE)). Word has these functions built-in, but when generating the document I have to assume that Word isn't installed on the machine. The problem is tha...
I load an xls file in Matlab, and I need not only the numeric values but the formulas also. Do you have any idea? ...
I need something to embed in my C/C++ program to interpret formulas of the like x*log(x) or sin(x). I would like something small and simple, otherwise I can just embed Python, or Ch, or Scheme, or you name it. But all I need is simple formulas. I have searched the web without luck. Although I don't require it, performance (e.g., the use ...
e.g. (N.B. All the following actions reference the same cell) A cell contains a formula to populate the 'default' value of that cell. The user overwrites the default value. The user decides to delete the value that they have entered. The original formula is automatically reinstated to provide the 'default' value again. Is this possi...