formula

Sharepoint calculated field's formula for created by

i have a sharepoint list with 2 users for examole (user A and user B) i need a calculated field in the list items such that if user "A" created the item the field vaule will be "X" and if user "B" created the item fields value would be "Y" but i couldnt use [created by] in the furmiula of the calculated field !! why is that ?!! ...

Circle coordinates to array in Javascript

What's the best way to add the coordinates of a circle to an array in JavaScript? So far I've only been able to do a half circle, but I need a formula that returns the whole circle to two different arrays: xValues and yValues. (I'm trying to get the coordinates so I can animate an object along a path.) Here's what I have so far: circle...

Making Excel functions affect 'other' cells

Let's say that I create a Sub (not a function) whose mission in life is to take the active cell (i.e. Selection) and set an adjacent cell to some value. This works fine. When you try to convert that Sub to a Function and try to evaluate it from from spreadsheet (i.e. setting it's formula to "=MyFunction()") Excel will bark at the fact...

Strings containing double quotes in Excel

How can I construct the following string in an Excel formula: Maurice "The Rocket" Richard If I'm using single quotes, it's trivial = "Maurice 'The Rocket' Richard" but what about double quotes? Thanks ...

How do you do calculations in Access?

In Microsoft Access I have a table called Time Sheet and in this I have Time sheet no. , waiter no. , date and hours worked. I have 10 waiters. I have another table called Service Charge Distribution. In this table I have Service Charge No. , waiter no. , week no. and distribution amount. There is a Bill table where the Service charg...

Excel Conditional Formatting Self Reference

I'm trying to do some conditional formatting in Excel 2003, what I want to do is have a cell go red if the next cell is "Yes" and go bold if it, itself, contains "Yes". So if both cells are "Yes" the current cell will be red and bold. I want to do this for a group of cells so I haven't used a direct reference to the cell, but I have come...

Help with a simple formula for a novice

I am very new to Excel and need some help. all I need to do is to use an ID in the following hyperlink: http://www.wotnots.co.uk/property/images/property2402_image1.jpg The ID here is 2402. I want to change it to the ID number which is in the first column and is different on every row. I want to have the ID number to be the same as the n...

Table Lookup in Excel

I am very familiar with vlookup and hlookup functions in Excel. However, I am looking for a method of doing both. Take this example: A B C 1 Resources 2 Task Mgr Sr. Mgr 3 ----------------------------- 4 Task 1 30% 70% 5 Task 2 40% 60% ...

Retrieving Values From Excel Merged Columns

I'm doing a hlookup against a value that spans multiple columns. My data is similar to this: A B C D --------------------------- 1| Col1 Col2 2| x y z w 3| 4| In rows 3 and 4 (A3, B3, C3, D3, etc.), I'd like to put formulas that will do an hlookup somewhere else in the workb...

How to programmatically set every other column in a worksheet in Interop

Using Excel Interop (.NET) how can we set programmatically two different Excel formulas for every other column. For instance, Range r = _sheet.get_Range(_sheet.Cells[1, 1], _sheet.Cells[I, J]) r.Formula = "=something1" will do it for every cell. But within J columns every other column has to have formula "=something2". The size ...

Minimum & Maximum Values in Crystal Reports 2008 Column

Say I have this column returned in a command for Crystal: deposit_no 123 130 125 124 126 127 128 129 and I need to have this in the report title: Includes deposits between 123 - 130 I've tried a running formula for minimum and maximum and they aren't returning the correct values no matter how I manipulate them. I've tried evalu...

What non-programming-specific formulas and laws do you use the most?

What non-programming-specific formulas do you use the most whilst working as a programmer? I'm thinking of non-trivial formulas/theorems from the field of mathematics, logic or science that you constantly put in to practice. The type of formulas they would make you rote learn at uni and that appear in bold in textbooks, rather than leng...

Mathematical formula for calculating call duration.

Hello, I was working for a telecom company some years ago and I had to generate a formula which calculates duration of a call according to the following algorithm: t1 is the first period t2 is the recurring period RCT is the actual call time (in seconds) CD is the effective call duration (for billing purposes) if RCT is less than ...

LaTeX equivalent to Google Chart API

I'm currently looking at different solutions getting 2 dimensional mathematical formulas into webpages. I think that the wikipedia solution (generating png images from LaTeX sourcecode) is good enough until we get support for MathML in webbrowsers. I suddenly realized that it might be possible to create a Google Charts API equivalent fo...

Best way to calculate the result of a formula?

I currently have an application which can contain 100s of user defined formulae. Currently, I use reverse polish notation to perform the calculations (pushing values and variables on to a stack, then popping them off the stack and evaluating). What would be the best way to start parallelizing this process? Should I be looking at a functi...

Lens correction projection

What is the simplest way to un-warp a photo made using fisheye or wide-angle lens? I'm looking a pixel projection formula that has few parameters. Camera and lens parameters will not be known, so user has to change the parameters visually. Thanks ...

Generate Images for formulas in Java

Hi I'd like to generate an image file showing some mathematical expression, taking a String like "(x+a)^n=∑_(k=0)^n" as input and getting a more (human) readable image file as output. AFAIK stuff like that is used in Wikipedia for example. Are there maybe any java libraries that do that? Or maybe I use the wrong approach. What would yo...

Is there a TeX API for C++?

Hi Guys, I want to preview TeX formulas in my User Interface. After a long time searching, it seems to me that there is no other possibility than write the formula into a .tex file call tex with system() and write a dvi file call e.g. dvipng with system() and write a png file load this file into the GUI clean up(erase all these files)...

How to fill-up cells within a Excel worksheet from a VBA function?

Hello, I simply want to fill-up cells in my spreadsheet from a VBA function. By example, I would like to type =FillHere() in a cell, and in result I will have a few cells filled-up with some data. I tried with such a function: Function FillHere() Dim rngCaller As Range Set rngCaller = Application.Caller rngCaller.Cells(1, 1) = "...

Any solution to the Today Calculated Column problem is SharePoint?

I would like to be able to use today's date in a calculated column in a SharePoint list to, for example, determine whether a task is overdue. There is a well-documented trick that involves creating a dummy column named "Today," using it in a formula, and then deleting it, thereby "tricking" SharePoint into using the Today function. The...