Hi there, I am just wondering if excel can do matrix symbolic algebra ? and how ?

I have many matrices i need to multiply to each other and they get really2 messy when i did it manually

thank you

I have many matrices i need to multiply to each other and they get really2 messy when i did it manually

thank you

- Using Macros to Calculate Matrix Algebra in Excel..... I'm STUMPED
- Matrix to table in excel 2007
- What does the symbol ^ mean in Excel formulas?
- How do I add a stock symbol smart tag in Excel?
- Include statistics symbols in Excel, e.g. y-hat, bar x, etc.
- How do I use the (=) symbol for cut/pasting in excel?
- How do i write a Algebra formula in excel sheet
- How can i build up a Matrix in EXCEl ?
- Inserting symbols not available in excel
- Smart Tag in Excel does not recognize some stock symbols
- How could insert symbols e.g. micro in chart legend in Excel?
- Truncated font list in Excel's "Insert Symbol" menu selection
- How do you get an "X-bar" symbol in Excel?
- How do I change default symbols in Excel 2007?
- Symbols added to Word's AutoCorrect don't appear in Excel
- Re: How to do matrix operation with complex number elements in Excel
- Inserting symbols not available in excel
- Are there symbols for use in Excel to represent trees and plants?
- Not equal to symbol in excel
- How do I put 'c' in () in excel & not get copyright symbol
- How do i get the prescription symbol in excel?
- How do I input currency symbols in Excel?

Here is a link to a file with my situation:

http://www.savefile.com/files/8301241

I need to find a way to set up a spreadsheet where I can input the variables

G, H, W, J, Q, S and have excel calculate the possible answers that satisfy

all of the equations in column D.

I know to do this on paper you use matrix algebra but I have no clue how to

do this in excel.

Column B is the results I should be getting for each variable in column A

(with the input values in column F) but I can't get it to work in excel.

Column C is a quick attempt I made to use iterate and circular references but

to no avail. If anyone can point me in the right direction I would REALLY

appreciate it. Oh and column A is a list of all variables used in the

equations in column D.

Is it even possible to input values for the variables in column E and have

excel use those to find answers that satisfy all of the equations in column

D??

I have a matrix with 100 customers in rows and manufacturers in about 100 columns and quantities in the middle.

eksample:

man 1 man 2 man 3

customer a qty qty qty

customer b qty qty qty

customer c qty qty qty

I would like to transform this data input into a table with columns: Customer, Manufacturer, Quantity.

Can someone please help me with this in excel 2007?

It used to be a PT solution to this with "multiple ranges" in excel 2003 but

i cant find it in 2007!

thanks in advance!

calculations in Excel. Can anyone help me?

hash (#).

So when I press: 'SHIFT' and '3' I am supposed to get '£' but instead I

get '#'.

Some other keys dont work although most of the other Shift functions do

what their supposed to e.g. I can still do a dollar sign ($), percentage

sign (%) etc. All keys work fine in other apps eg. notepad. Keyboard

setting is still the set to UK format.

Any ideas?

--

paperclip

------------------------------------------------------------------------

paperclip's Profile: http://www.excelforum.com/member.php...o&userid=32219

View this thread: http://www.excelforum.com/showthread...hreadid=522276

So when I press: 'SHIFT' and '3' I am supposed to get '£' but instead I get '#'.

Some other keys dont work although most of the other Shift functions do what their supposed to e.g. I can still do a dollar sign ($), percentage sign (%) etc. All keys work fine in other apps eg. notepad. Keyboard setting is still the set to UK format.

Any ideas?

tags. How do I add these so they are recognized with smart tags in Excel?

Thank you

specialized statistical characters. For example, the sample mean is usually

written as 'x' with a bar over it, or x-bar. The equation to approximate

regression is referred to as y-hat, the letter y with a caret (^) on top.

I believe inclusion of all of the specialized statistical symbols in the

character set would add in the presentation of statistical analysis done in

Excel.

----------------

This post is a suggestion for Microsoft, and Microsoft responds to the

suggestions with the most votes. To vote for this suggestion, click the "I

Agree" button in the message pane. If you do not see the button, follow this

link to open the suggestion in the Microsoft Web-based Newsreader and then

click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

pasting. Are there any links to sites with this information?

when you writing 4th, automitically th wil go in to small word, like that

even the root sq. formula needs to come

can some one give tips on this

thanks in advacne

saravanan

how can i build a Matrix in Excel combining 250 items (ex. airports) with

250 items (ex. airports)?

i schould create a row with the 62500 possible combinations... there must be

a formula to make this autmatically.

ex. ZHR JFK ATL ....

ZHR

JFK

ATL

.....

And then I should get a list in one row :

ZHR-JFK

ZHR-ATL

......

JFL-ZHR

JFK-ATL

.....

ATL-ZHR

ATL-JFK

thank you very much for your help.

regards

Mischa

I want to insert some symbols in excel and I cannot find the correct ones,

these symbols are the washing instruction symbols we have in all our clothing.

I have found some of them in the "TextilePiEF" font in the symbols menu, but

not all of the ones I need. So i wanted to know whether:

1) I could modify some of the symbols in "TextilePiEF" font ? OR

2) Find these washing instruction symbols on the internet ? OR

3) Deisgn my own in PAINT or something and put them in one of the 'insert

symbols' fonts ?

stock symbols be added somewhere in Excel so a smart tag is generated?

character like micro molar, How could we create it, I tried but micro symbole

chane to "m".

Excel's "Insert Symbol" dropdown menu. I do not have this problem using the

same menu selection in Word. I can see the complete list of installed fonts

from the font menu on the Excel tool barand when formating a cell.

I don't have this problem on my laptop.

Both computers use Office XP (Excel 2002) runing under Windows XP Pro (SP2).

Any suggested solutions will be appreciated.

George

Excel. Copying it from Word doesn't appear to work either. DOes anyone know

how to do this?

How do I stop the program from doing this, and to allow me to choose when I

want to insert that or any other symbol instead of the program inserting it

by default?

thought I could access them in Excel but I can't. I tried to add the symbols

to AutoCorrect in Excel by using the character mapy Copy feature. But Excel

won't let me paste the symbol (or type its character code with ALT) into

AutoCorrect.

Any help greatly appreciated, and thanks.

--

Bernard V Liengme

www.stfx.ca/people/bliengme

remove caps from email

"WILSON CHIRAMAL" <WILSON CHIRAMAL@discussions.microsoft.com> wrote in

message news:3AC1035D-8459-4D0D-A125-F78BC143F597@microsoft.com...

> Would like to use Analysis tool pack function , Matrix multiplication with

> elements as complex numbers.

I want to insert some symbols in excel and I cannot find the correct ones,

these symbols are the washing instruction symbols we have in all our clothing.

I have found some of them in the "TextilePiEF" font in the symbols menu, but

not all of the ones I need. So i wanted to know whether:

1) I could modify some of the symbols in "TextilePiEF" font ? OR

2) Find these washing instruction symbols on the internet ? OR

3) Deisgn my own in PAINT or something and put them in one of the 'insert

symbols' fonts ?

symbols to represent different types and sizes of plants. Are they available?

get the letter c in parenthesis?

How do I display two different currency symbols in two different

cells/columns on

the same page in Excel?

peter FREER