Tuesday, March 30, 2010

Another tentative candidate for the Excel Gurus Gone Wild: Do the Impossible with Microsoft Excel book: Convert a two-dimensional table/matrix into a column or row vector and vice versa :)


In spreadsheet modeling one often has to convert a two-dimensional table into a row or column vector and vice versa. This Excel file does just that by using the following formulas: =INDEX($C$17:$N$28;IF(MOD(P3;12)=0;12;MOD(P3;12));IF(P3/12=INT(P3/12);P3/12;INT(P3/12)+1)) and =INDEX($R$3:$R$146;MATCH($B31&"-"&C$30;$Q$3:$Q$146;0)).

The former formula is actually an involved version of =INDEX($C$17:$N$28;MOD(P3;12);INT(P3/12)+1) that fixes the last row problem.

This is, for instance, a problem that is tackled in Solver network optimization models, when a two dimensional cost/distance matrix is converted into a flow balance constraint form.

59 comments:

Anonymous said...

I was suggested this website by my cousin.
I'm not sure whether this post is written by him as no one else know such detailed about my difficulty. You're
amazing! Thanks!

My website - Marvel Heroes Gameplay

Anonymous said...

Hey there! This is kind of off topic but I need some advice from an
established blog. Is it very hard to set up your own blog?
I'm not very techincal but I can figure things out pretty quick. I'm thinking about creating my own but I'm not sure where to start. Do you have any tips or suggestions? Many thanks

My web page Bukkit Tutorial Series

Anonymous said...

I believe that is one of the most important info for me.

And i'm satisfied studying your article. However want to observation on few normal things, The site taste is great, the articles is truly nice : D. Excellent task, cheers

Visit my web page; feed the Beast collab

Anonymous said...

Tremendous issues here. I'm very glad to look your post. Thank you a lot and I am looking forward to touch you. Will you please drop me a mail?

Feel free to surf to my site: RPG game

Anonymous said...

It's an amazing post for all the web viewers; they will get advantage from it I am sure.

Also visit my blog KestalKayden

Anonymous said...

Wow that was strange. I just wrote an incredibly long comment but after
I clicked submit my comment didn't appear. Grrrr... well I'm not writing all that over again.
Anyways, just wanted to say excellent blog!

Also visit my homepage Minecraft Wireless Redstone Mod

Anonymous said...

Yes! Finally something about Mindcrack.

Anonymous said...

Hi there! Do you use Twitter? I'd like to follow you if that would be ok. I'm definitely enjoying your blog and look forward to new posts.


Look at my site - Superhero Game

Anonymous said...

This is very interesting, You are a very professional
blogger. I have joined your feed and sit up
for searching for extra of your excellent post. Also, I have
shared your site in my social networks

my blog: Youtube Keywords

Anonymous said...

Fantastic blog! Do you have any recommendations for aspiring writers?
I'm planning to start my own site soon but I'm a little lost
on everything. Would you advise starting with a free
platform like Wordpress or go for a paid option? There
are so many choices out there that I'm totally confused .. Any suggestions? Appreciate it!

My blog - Path of Exile Wraeclast

Anonymous said...

Everything is very open with a precise clarification of the issues.
It was really informative. Your website is very useful.
Thanks for sharing!

My web page ... Dota 2 First Impressions

Anonymous said...

I really like what you guys tend to be up too. This kind of clever work and reporting!
Keep up the good works guys I've you guys to my own blogroll.

Here is my homepage Game Dev Story

Anonymous said...

Nice post. I learn something totally new and challenging on blogs
I stumbleupon on a daily basis. It's always interesting to read through content from other authors and use something from their websites.


Look into my weblog ... cutting through the myths about knives ()

Anonymous said...

Traditionally the cake is cut equally so that everyone present will receive a
share and even those who are not present for reasons beyond their control are not
forgotten and special portions are cut and kept for sailors, soldiers
and anyone else who is unable to attend. Yesterday (7),
the reporter in the zone of a large supermarket to see a lot of "Gift Box" couplets, which are printed on "auspicious" and
other words. It can be used to totally decorate
a room or just as an influence on a room.

Feel free to visit my web page ... holiday decoration storage

Anonymous said...

I tend not to drop a lot of remarks, but i did some searching and wound up here "Another tentative candidate for the Excel Gurus Gone Wild: Do the Impossible with Microsoft Excel book: Convert a two-dimensional table/matrix into a column or row vector and vice versa :)".

And I do have a few questions for you if it's allright.

Could it be only me or does it appear like a few of the remarks come across like written by brain dead people?
:-P And, if you are writing on additional online social sites,
I'd like to follow anything fresh you have to post.
Could you list of every one of your communal sites like your linkedin profile, Facebook page or twitter feed?


My site; free overstock coupons 2014

Anonymous said...

Hello Dear, are you in fact visiting this web
page on a regular basis, if so then you will definitely take good experience.



Visit my weblog ... soldier of fortune 2 aimbot ()

Anonymous said...

Good answer back in return of this query with genuine arguments and describing everything about that.


My page ... Best humidifier 2014 ()

Anonymous said...

Pretty nice post. I just stumbled upon your
weblog and wished to say that I have truly loved surfing around your blog posts.

After all I'll be subscribing for your feed and I hope you write once more soon!


Also visit my weblog - top eleven hack

Anonymous said...

quick weight loss tricks

Here is my page - myfloristburke.com

Anonymous said...

Thank you for the auspicious writeup. It in fact was a amusement account it.
Look advanced to more added agreeable from you!
By the way, how could we communicate?

My blog post: clash of clans hack no survey mac ()

Anonymous said...

Sweet blog! I found it while searching on Yahoo News.
Do you have any tips on how to get listed in Yahoo News?
I've been trying for a while but I never seem to get there!

Thanks

my web site :: Cheap Nike Shox For Men

Anonymous said...

Terrific article! This is the type of information that are supposed to be shared around
the net. Disgrace on Google for no longer positioning this
submit higher! Come on over and seek advice from my website
. Thank you =)

Also visit my website; Kosmetik Online Shop - Tagesdeals

Anonymous said...

We have keyword research, informative material and linking your webpage with famous web pages.
Using hp refurbished desktop computers pay per click advertising and search engine optimization.
Google, one of the more technical terms and tactics used in SEO to rank higher in search results.
Just having a website build for once is not enough.



Look into my page ... what is a sound bar

Anonymous said...

Why uwers still make use of to read newws papers when in this technological globe the whole
thing is available on web?

Stop by my web-site :: leagueoflegendslolhacks.blogspot.com; ,

Anonymous said...

Thank you a bunch for sharing this with all folks you actually know what you're speaking about!
Bookmarked. Please also discuss with my site =). We could have a link alternate arrangement
between us

Also visit my blog post - drug testing

Anonymous said...

What's up еveryone, іt's my fiгst visit ɑt
tɦіs web page, and post is truly fruitful for me, kеep up posting sսch content.


my site :: Proactol Plus review

Anonymous said...

Then Kamui and Hanbei add one last colorful ally, Fudo (Hideki Ito),
and the die is set. This is based on their relatively great weapons or
power. If you can, try to spend resources as you acquire them unless you are saving for
something expensive.

Take a look at my weblog - how to get free gems in clash of clans

Anonymous said...

I'm not sure where you are getting your information, but good topic.
I needs to spend some time learning much more or understanding more.

Thanks for wonderful info I was looking for this info for
my mission.

My website: digital camera advice

Anonymous said...

I'm curious tо fіnd ouut ԝhat blog platform youu ɑre using?
I'm hɑving som minor securify problms աith my latedt website ɑnd I would
like tо find somethіng more secure. Dο yoս have any solutions?


Аlso visit mү blog post: sportsbet

Anonymous said...

What i do not realize is in truth how you are no longer
actually much more neatly-preferred than you may be right now.
You're very intelligent. You recognize thus significantly
in relation to this topic, produced me for my part imagine it from a lot of varied angles.
Its like men and women aren't fascinated except it is one thing to accomplish with Lady gaga!
Your own stuffs great. At all times take care of it up!


Here is my web blog submit free press releases

Anonymous said...

Great article.

Also visit my web-site ... Nike Free Run Neon

Anonymous said...

Thank you for the good writeup. It in fact was a amusement account it.
Look advanced to far added agreeable from you! However, how can we communicate?


Also visit my web site; Cheap Beats By Dre

Anonymous said...

Howdy would you mind stating which blog platform you're using?
I'm planning to start my own blog soon but I'm having a
tough time choosing between BlogEngine/Wordpress/B2evolution and Drupal.

The reason I ask is because your design and style
seems different then most blogs and I'm looking for
something unique. P.S Apologies for being off-topic but I had to ask!


Feel free to visit my site; Christian Louboutin Shoes

Anonymous said...

I every time emailed this blog post page to all my friends, as if like
to read it next my contacts will too.

Check out my webpage; Cheap Christian Louboutin (vincenbtz.soup.io)

Anonymous said...

A Wii Remote alone costs it being, come by $40, as the Wii Play pack simply costs five dollars more at $50.
We were given several hand me from people down meals and household goods that
we hardly know.

Also visit my blog :: gta 5 cheats []

Anonymous said...

My spouse and I stumbled over here different website and thought I might as well check things out.
I like what I see so now i am following you.
Look forward to finding out about your web page again.

Also visit my web-site :: web site

Anonymous said...

I blog quite often and I genuinely appreciate your
information. Your article has truly peaked my interest.
I am going to bookmark your website and keep checking
for new details about once per week. I subscribed to your RSS feed too.


Feel free to surf to my web page: castle Clash cheats

Anonymous said...

If yoou do decide to give cash to beggars, be careful how considerably you gve for panic of currently bring mobbed by beggars.
It has turn out to be a need in firms regardless of whetuer modest or medium sized, enterprise online video conferencing has develop into an business office device.
The initial and most clear problem is compatibility.


Heree iss my web site ... BYOD Explained

Anonymous said...

There's definately a great deal to know about this subject.

I really like all the points you've made.

Also visit my homepage :: descargar libros gratis para kindle (http://crmidol.com/discussion/11699/novedades-sobre-la-descarga-de-libros)

Anonymous said...

Hi there would you mind letting me know which webhost you're working
with? I've loaded your blog in 3 different web browsers and I
must say this blog loads a lot quicker then most. Can you recommend a
good hosting provider at a fair price? Thanks,
I appreciate it!

Also visit my web-site - Cheap Christian Louboutin Shoes

Anonymous said...

Hello, i think that i saw you visited my site thus i came to
“return the favor”.I'm trying to find things to enhance my web site!I suppose its ok to
use a few of your ideas!!

Here is my website - Christian Louboutin Outlet

Anonymous said...

Hi there! This post could not be written much better!
Looking at this article reminds me of my previous roommate!
He constantly kept talking about this. I most certainly will forward this information to him.
Fairly certain he will have a great read. I appreciate you for sharing!


Check out my website - Christian Louboutin Sale

Anonymous said...

Greetings from Los angeles! I'm bored to death at work so I decided to browse your blog on my iphone during lunch break.
I love the info you present here and can't wait
to take a look when I get home. I'm shocked at how quick your blog loaded on my phone ..

I'm not even using WIFI, just 3G .. Anyhow, awesome site!


my page; Christian louboutin discount

Anonymous said...

I'm not sure why but this site is loading incredibly slow for me.

Is anyone else having this problem or is it a problem on my end?
I'll check back later and see if the problem still exists.

Look into my web blog ... gta 5 hack

Anonymous said...

Hello would you mind sharing which blog platform
you're working with? I'm going to start my own blog in the near future but I'm having a
hard time deciding between BlogEngine/Wordpress/B2evolution and Drupal.
The reason I ask is because your layout seems different then most blogs and I'm looking for something
unique. P.S Apologies for getting off-topic
but I had to ask!

Also visit my weblog :: Cheap Christian Louboutin

Anonymous said...

Way cool! Some very valid points! I appreciate you penning this article and the rest of the website is extremely good.


Feel free to visit my site Cheap Christian Louboutin Shoes

Anonymous said...

Chuchotement,heureux arc en ciel comme novice vers le bas appliquer nouveau compte facebook.fr.
race au-delà livres site pour pirater un compte facebook gratuitement.


Check out my web page comment pirater un compte facebook gratuitement

Anonymous said...

Don'capital t receive stuffed ϳust by missing in tɦe beginning finds, mostly considеr transforming f card in this information locating
a card within the stack. Wikipedia, tҺe աorld on line encyclopedia identifies.
basically bby Вen Holroyd іs οne othe compսter software makes uѕe of fischer movess to
automatically solve Free - Cellphone.

mү page free solitaire download

Anonymous said...

I'm gone to say to my little brother, that he should also
pay a quick visit this website on regular basis to
take updated from most up-to-date information.

Here is my web page ... car san diego

Anonymous said...

very much respect, you trtuly delivered a suprrb article.



Also visit my blog; sexercise book

Anonymous said...

Enjoky youг oԝn "Azines" and bare floor tile. Ƭhey arе invaluable fօr utilizing right up ungainly corresxpondence wɦen it comes too couple
of useable terms. Noгmally, this particular tool cɑn be uup to date simply jսst aftеr
looking ɑt the actul veracity in tҺe cutting edge terms.


Herе is my blog post ... download Scrabble

Anonymous said...

I think the admin of this website is genuinely working hard for his
site, because here every data is quality based stuff.


Also visit my web-site - เบอร์สวย

Anonymous said...

However, unlike the places in Co - D4 where you could shoot through one-way walls and
rake in the kills without risk of dying, getting outside of the map in MW2 serves little purpose.

Dennis Rodman,Dominique Wilkins, Karl Malone, Jerry Stockton. The message I received
earlier today is as follows:.

My blog - Sky Force Hack ()

Anonymous said...

Hi, Neat post. There is an issue together with your web site in web explorer, would check this?

IE still is the marketplace leader and a large component of other people
will pass over your fantastic writing because of this problem.



Also visit my site - download company of heroes 2 the western front

Anonymous said...

I have to thank you for the efforts you have put in penning this blog.
I'm hoping to see the same high-grade blog posts by you in the future as well.
In truth, your creative writing abilities has inspired
me to get my own website now ;)

Also visit my web page :: Michael Kors Outlet

Anonymous said...

Уօu can fijd grеɑt digital versions ߋf the video
games аnd in addition mսch morе on line, ߋr try ߋut relaxing and ɑlso coping
your handheld or two, simply employing neɑrly aany stanmdard pack of cards.
Аnd alѕo spider solitaires provide аn urge foг food
Forr that helples аnd the lonesome TҺese people preserve tɦem
from your dangerous strugglle Relaxing tҺem till the time tҺey
obtɑin hunger As wеll as take them սp in many scary attacks
Whispering, "You will end up beside me eternally, sweetie. *Made an appearance about 1300 Listing inside The western world.

my site ... free solitaire download, ,

Anonymous said...

My partner and I absolutely love your blog and find many of your post's to be what precisely I'm looking for.
Would you offer guest writers to write content for yourself?
I wouldn't mind writing a post or elaborating on a number of the subjects you write with regards to here.
Again, awesome website!

My weblog multiplayer games online download; https://www.youtube.com/,

Anonymous said...

You had me in the fіrst line andd I completely enjoyed it towards
the conclusion. An ambitioսs writer like myself wіll seriously value any tricks you might have in helping to
engage tɦe reader likje you did with this specific
write up. Thank yoս!

Here iis my hоmepage: e cig liquid refill pina colada ()

Anonymous said...

The majority of Americans now own smartphones, tablets
PCs, and casino are the source of finding everything.

While on the llama's entrance legs will lead the Dumbledore's Army together with the NBA Jam by EA Sports
game, it is one of the musicians. 95 or $39 dino hunter
deadly shores hack 99 per month.

My website ... Dino hunter deadly shores unlimited gold ()