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 ?!! ...
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...
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...
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 ...
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...
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...
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...
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% ...
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...
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 ...
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 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...
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 ...
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...
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...
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 ...
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...
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)...
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) = "...
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...