Hi there, I'm wanting to SUM a number of rows in Excel, based on a value. In the picture below, you can see the table. I want to put a value in F1, containing the sum of the values for Jan -> (month # specified in C2) where the Status is the value in C1. If you do =SUMIF(B5:B11,"open",INDIRECT(CONCATENATE("C5:",ADDRESS(11,2+C2)))) ...
I have a particular application that needs to calculate something very specific, and while I excel at logic, math has always been my weak spot. Given a number, say -20, it needs to apply a calculation of a 100 base (that is, the base is 100, not 0. not to be confused with base 100 which would be something else totally). In other words...
Hey. I have a problem I'm trying to solve in Python and I can't think of a clever implementation. The input is a string of letters. Some of them represent variables, others represent operators, and I want to iterate over a large amount of values for the variables (different configurations). I think an equivalent question would be that y...
I want to know the depth of field of a photo, preferably in cm or m. I know that we can know the camera setting by reading the EXIF tags, but is there a tag directly telling us the depth of field? Or how can we calculate it from some EXIF tags? Examples would be appreciated. Thanks! ...
Hello Everyone, I have a module that creates a Visio file (VDX) outside Visio. According to the SDK this refers to 'untrusted' XML. I've created my xml file by copied the Masters from my stencil and then refer to them using an XML sparse file. In my sparse xml I override the shape's location and size this way: <Shape ID="154" Master="...
Does anyone know of any formula for converting a light frequency to an RGB value? ...
My inner loop contains a calculation that profiling shows to be problematic. The idea is to take a greyscale pixel x (0 <= x <= 1), and "increase its contrast". My requirements are fairly loose, just the following: for x < .5, 0 <= f(x) < x for x > .5, x < f(x) <= 1 f(0) = 0 f(x) = 1 - f(1 - x), i.e. it should be "symmetric" Preferabl...
As simple as it sounds, I just want to know how to calculate the PageViews of a site using Alexa stats. Alexa gives PageViews per-million and reach % of total Internet users, etc. I only want a formula using Alexa data to calculate it. I know, Alexa data is not exact but my problem will be solved by that. Thanks in advance. ...
Hi developers, I like to update an existing iPhone application which is using AudioQueue for playing audio files. The levels (peakPowerForChannel, averagePowerForChannel) were linear form 0.0f to 1.0f. Now I like to use the simpler class AVAudioPlayer which works fine, the only issue is that the levels which are now in decibel, not li...
Is there a common formula that could provide a unique value for a 512 character file path, assuming one 32 bit byte per character, and possibly limiting the characters used in the names? I know that if you just used uppercase letters alone the combination would be grossly more than a 32-bit int, but what about using an identity field wi...
I've been doing some accounting reports and have been summing up my different currencies using a formula IE CanadianCommissionFormula if {myData;1.CurrencyType} = "CDN" then {myData;1.Commission} else 0 CanadianCommissionSum SUM({@CanadianCommissionFormula}) Then I'd just display the CanadianCommissionSum at the bottom ...
Hi folks, Is there any way to identify a formula of excel cell contains defined names by using VSTO? Or is there any way to replace the defined Excel.Name in formula of a Excel cell when the name of Excel.Name is changed by using VSTO? thanks, Yst ...
I'm writing a shopping cart in PHP, and part of its function is to calculate shipping for a given set of products. For users with Javascript enabled, I want to provide the smoothest experience possible by having an accurate shipping calculation done on the client side so that changes in the cart do not require page reloads or AJAX calls....
Guys, Is there a simple way to determine how many milliseconds I need to "Sleep" for in order to "emulate" a 2 mhz speed. In other words, I want to execute an instruction, call System.Threading.Thread.Sleep() function for an X amount of milliseconds in order to emulate 2 mhz. This doesn't need to be exact to the millisecond, but is ther...
In the hibernate mapping file I use property formula to get any value. <property name="price" type="double" formula="(select SUM(amount) ...) /> But it allows to get only 1 row. How can I get lisf of rows? I understand that "property" is not suitable, but it's impossible to add formula to set or list. Of course I just want to get va...
I need to create a provider Name group which is based on any or all of three fields that contain service provider codes. Each Service Provider Code links to its own SP_Program_Location table to optain that providers Provider ID which is then linked to a provider table to obtain the Providers Name. If no providers have been assigned for...
I have a color A that I'd like to transform into color C, by using color B. So I'd like to know the blending formula F in GDI+, where F = F(A, B) = C. A is the "bottom color" and B is an overlay color above A, which together with A yields C. Cheers, // Magnus ...
Hi, I have created a graph in extJS and was wondering if people know of a general formula to calculate the major and minor units of the X-Axis. I know Extjs should do it automatically, but its not working and want to do it manually any way as I am already setting the maximum and minimum values. Thanks for any help : ) Some code I ha...
When i map columns from the inspected table, i do this: <property name="InstanceName" type="MyNameUserType, MyApp.MyNamespace"> <column name="Name"/> <column name="Name2"/> </property> How can I make property mapping initialize a UserType with data retrieved by the formula's sql query? <property name="InstanceName" type="MyName...
The problem is to derive a formula for determining number of digits a given decimal number could have in a given base. For example: The decimal number 100006 can be represented by 17,11,9,8,7,6,8 digits in bases 2,3,4,5,6,7,8 respectively. Well the formula I derived so far is like this : (log10(num) /log10(base)) + 1. in C/C++ I use...