Use this one

    =SUMPRODUCT(A1:A3,B1:B3)

**SUMPRODUCT formula – syntax and usage**

Excel SUMPRODUCT formula - tutorialThe sum-product formula syntax is very simple. It takes 1 or more arrays of numbers and gets the sum of products of corresponding numbers.

    The syntax is =SUMPRODUCT (list 1, list 2 ...)
![enter image description here][1]


  [1]: http://i.stack.imgur.com/eFR5s.png

I have a simple handler in my controller which returns a message

    @RequestMapping(value = &quot;/message&quot;)
    @ResponseBody
    public Message get() {
        return new Message(penguinCounter.incrementAndGet() + &quot; penguin!&quot;);
    }

At the same time I can use something like this

    @RequestMapping(value = &quot;/message&quot;)
    ResponseEntity&lt;Message&gt; get() {
        Message message = new Message(penguinCounter.incrementAndGet() + &quot; penguin!&quot;);
        return new ResponseEntity&lt;Message&gt;(message, HttpStatus.OK);
    }

What is the difference betweet this two approaches? Let&#39;s not take into account HttpStatus :)





What is the difference between ResponseEntity&lt;T&gt; and @ResponseBody?

Is there a query I can run to show currently assigned privileges on a particular schema?

i.e. privileges that were assigned like so:

    GRANT USAGE ON SCHEMA dbo TO MyUser

I have tried

    SELECT *
    FROM information_schema.usage_privileges;

but this only returns grants to the built-in PUBLIC role. Instead, I want to see which users have been granted privileges on the various schema.

Note: I&#39;m actually using Amazon Redshift rather than pure PostgreSQL, although I will accept a pure PostgreSQL answer if this is not possible in Amazon Redshift. (Though I suspect it is)

postgresql - view schema privileges

I am trying to find a proper way to calculate the scalar product of two ranges. For instance, the product of `A1:A3` and `B1:B3` would be `A1*B1 + A2*B2 + A3*B3`. Is there a good way to do this? Hardcoding this calculation is quite a tedious thing to do with large ranges.

Excel: Scalar product of two ranges

<p>I am trying to find a proper way to calculate the scalar product of two ranges. For instance, the product of <code>A1:A3</code> and <code>B1:B3</code> would be <code>A1*B1 + A2*B2 + A3*B3</code>. Is there a good way to do this? Hardcoding this calculation is quite a tedious thing to do with large ranges.</p>


I would like to type the mathematical forumla in VBA code which many lines. I would like to split it into many lines. How do I do it?

For example:

    U_matrix(i, j, n + 1) = k * b_xyt(xi, yi, tn) / (4 * hx * hy) * U_matrix(i + 1, j + 1, n) + (k * (a_xyt(xi, yi, tn) / hx ^ 2 + d_xyt(xi, yi, tn) / (2 * hx)))

is very long. would like to split it.

Tried this:

    U_matrix(i, j, n + 1) = k * b_xyt(xi, yi, tn) / (4 * hx * hy) * U_matrix(i + 1, j + 1, n) 
    _+ (k * (a_xyt(xi, yi, tn) / hx ^ 2 + d_xyt(xi, yi, tn) / (2 * hx)))

But not working.. Need some guidance on this..



How to continue the code on the next line in VBA

This is what i am trying to do.

1.Create excel file(.xlsx) c://test/files/work1_4.13.14.xlsx with name + value(date) 

example: work1_4.13.14.xlsx

2.Set headers to the file example: [Name] [Age] [City]. 

3.I have 3 List&lt;string&gt; with names,ages,city that i need to fill into excel sheet.

This is my goal

    Name   Age  City
    Ben    20   xyz
    Jack   25   xyz
    Mike   45   zyx


Any ideas?




How to write some data to excel file(.xlsx)

Is there a way to write VBA Code in Visual Studio. If not is there any other alternatives?

Is it possible to write Excel VBA Code in Visual Studio

Not really a question, but posting this for comments because I don&#39;t recall seeing this approach before.  I was responding to a comment on a previous answer, and tried something I&#39;d not attempted before: the result was interesting so I though I&#39;d post it as a stand-alone question, along with my own answer.

There have been many questions here on SO (and many other forums) along the lines of &quot;what&#39;s wrong with my user-defined function&quot; where the answer has been &quot;you can&#39;t update a worksheet from a UDF&quot; - this restriction outlined here:

[Description of limitations of custom functions in Excel][1]

There are a few methods which have been described to overcome this e.g. see here (https://sites.google.com/site/e90e50/excel-formula-to-change-the-value-of-another-cell) but I don&#39;t think my exact approach is among them.

See also: [changing cell comments from a UDF][2]


  [1]: http://support.microsoft.com/kb/170787
  [2]: http://spreadsheetpage.com/index.php/oddity/a_user_define_function_cant_change_the_worksheet_oh_yeah/

Using a UDF in Excel to update the worksheet

I have a moderately large xlsx file (around 14 MB) and OpenOffice hangs trying to open it. I was trying to use [openpyxl][1] to read the content, following [this tutorial][2]. The code snippet is as follows:

     from openpyxl import load_workbook
     wb = load_workbook(filename = &#39;large_file.xlsx&#39;, use_iterators = True)
     ws = wb.get_sheet_by_name(name = &#39;big_data&#39;) 

The problem is, I don&#39;t know the sheet name, and Sheet1/Sheet2.. etc. didn&#39;t work (returned NoneType object). I could not find a documentation telling me **How to get the sheet names for an xlsx files using openpyxl**. Can anyone help me?

[1]:https://bitbucket.org/ericgazoni/openpyxl
[2]:http://openpyxl.readthedocs.org/en/latest/optimized.html?highlight=load_workbook#optimized-reader

getting sheet names from openpyxl

I would like to perform arithmetic on one or more dataframes columns using `pd.eval`. Specifically, I would like to port the following code that evaluates a formula:

    x = 5
    df2[&#39;D&#39;] = df1[&#39;A&#39;] + (df1[&#39;B&#39;] * x)

...to code using `pd.eval`. The reason for using `pd.eval` is that I would like to automate many workflows, so creating them dynamically will be useful to me.

My two input DataFrames are:

    import pandas as pd
    import numpy as np

    np.random.seed(0)
    df1 = pd.DataFrame(np.random.choice(10, (5, 4)), columns=list(&#39;ABCD&#39;))
    df2 = pd.DataFrame(np.random.choice(10, (5, 4)), columns=list(&#39;ABCD&#39;))

    df1
       A  B  C  D
    0  5  0  3  3
    1  7  9  3  5
    2  2  4  7  6
    3  8  8  1  6
    4  7  7  8  1

    df2
       A  B  C  D
    0  5  9  8  9
    1  4  3  0  3
    2  5  0  2  3
    3  8  1  3  3
    4  3  7  0  1

I am trying to better understand `pd.eval`&#39;s `engine` and `parser` arguments to determine how best to solve my problem. I have gone through [the documentation][1], but the difference was not made clear to me.

1. What arguments should be used to ensure my code is working at the maximum performance?
2. Is there a way to assign the result of the expression back to `df2`?
3. Also, to make things more complicated, how do I pass `x` as an argument inside the string expression?

  [1]: https://pandas.pydata.org/pandas-docs/version/0.23.4/generated/pandas.eval.html






Dynamically evaluate an expression from a formula in Pandas

Hello so I want to multiply the integers inside a list.

For example;

    l = [1, 2, 3]
    l = [1*2, 2*2, 3*2]

output:

    l = [2, 4, 6]


So I was searching online and most of the answers were regarding multiply all the integers with each other such as:

[1*2*3]


Content Type	Original Author	Original Content on Stackoverflow
Question	Lee White	View Question on Stackoverflow
Solution 1 - Excel	Dmitry Pavliv	View Answer on Stackoverflow
Solution 2 - Excel	user3278923	View Answer on Stackoverflow

Excel: Scalar product of two ranges

Excel Problem Overview

Excel Solutions

Solution 1 - Excel

Solution 2 - Excel

postgresql - view schema privileges

What is the difference between ResponseEntity<T> and @ResponseBody?

Attributions