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:

  1. Anonymous1:15 PM

    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

    ReplyDelete
  2. Anonymous1:37 PM

    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

    ReplyDelete
  3. Anonymous4:00 PM

    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

    ReplyDelete
  4. Anonymous9:24 PM

    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

    ReplyDelete
  5. Anonymous11:06 PM

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

    Also visit my blog KestalKayden

    ReplyDelete
  6. Anonymous11:56 PM

    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

    ReplyDelete
  7. Anonymous3:24 AM

    Yes! Finally something about Mindcrack.

    ReplyDelete
  8. Anonymous11:34 AM

    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

    ReplyDelete
  9. Anonymous2:04 PM

    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

    ReplyDelete
  10. Anonymous3:13 PM

    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

    ReplyDelete
  11. Anonymous6:21 PM

    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

    ReplyDelete
  12. Anonymous9:01 AM

    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

    ReplyDelete
  13. Anonymous3:24 PM

    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 ()

    ReplyDelete
  14. Anonymous1:05 AM

    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

    ReplyDelete
  15. Anonymous9:35 PM

    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

    ReplyDelete
  16. Anonymous5:11 AM

    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 ()

    ReplyDelete
  17. Anonymous2:36 PM

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


    My page ... Best humidifier 2014 ()

    ReplyDelete
  18. Anonymous6:06 PM

    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

    ReplyDelete
  19. Anonymous11:43 PM

    quick weight loss tricks

    Here is my page - myfloristburke.com

    ReplyDelete
  20. Anonymous5:45 PM

    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 ()

    ReplyDelete
  21. Anonymous7:26 PM

    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

    ReplyDelete
  22. Anonymous4:48 PM

    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

    ReplyDelete
  23. Anonymous2:19 PM

    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

    ReplyDelete
  24. Anonymous8:12 PM

    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; ,

    ReplyDelete
  25. Anonymous5:36 PM

    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

    ReplyDelete
  26. Anonymous2:47 PM

    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

    ReplyDelete
  27. Anonymous9:42 AM

    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

    ReplyDelete
  28. Anonymous10:42 PM

    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

    ReplyDelete
  29. Anonymous12:52 AM

    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

    ReplyDelete
  30. Anonymous8:36 AM

    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

    ReplyDelete
  31. Anonymous3:40 AM

    Great article.

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

    ReplyDelete
  32. Anonymous5:34 AM

    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

    ReplyDelete
  33. Anonymous4:11 PM

    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

    ReplyDelete
  34. Anonymous9:28 AM

    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)

    ReplyDelete
  35. Anonymous3:08 PM

    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 []

    ReplyDelete
  36. Anonymous8:27 PM

    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

    ReplyDelete
  37. Anonymous2:08 AM

    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

    ReplyDelete
  38. Anonymous2:09 AM

    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

    ReplyDelete
  39. Anonymous3:50 AM

    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)

    ReplyDelete
  40. Anonymous3:50 AM

    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

    ReplyDelete
  41. Anonymous3:53 AM

    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

    ReplyDelete
  42. Anonymous3:53 AM

    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

    ReplyDelete
  43. Anonymous3:54 AM

    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

    ReplyDelete
  44. Anonymous3:57 AM

    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

    ReplyDelete
  45. Anonymous3:57 AM

    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

    ReplyDelete
  46. Anonymous3:58 AM

    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

    ReplyDelete
  47. Anonymous1:23 AM

    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

    ReplyDelete
  48. Anonymous4:12 PM

    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

    ReplyDelete
  49. Anonymous6:54 AM

    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

    ReplyDelete
  50. Anonymous9:53 AM

    very much respect, you trtuly delivered a suprrb article.



    Also visit my blog; sexercise book

    ReplyDelete
  51. Anonymous1:01 PM

    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

    ReplyDelete
  52. Anonymous9:30 PM

    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 - เบอร์สวย

    ReplyDelete
  53. Anonymous1:19 PM

    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 ()

    ReplyDelete
  54. Anonymous2:40 PM

    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

    ReplyDelete
  55. Anonymous8:14 PM

    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

    ReplyDelete
  56. Anonymous3:50 AM

    Уօ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, ,

    ReplyDelete
  57. Anonymous10:22 PM

    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/,

    ReplyDelete
  58. Anonymous12:25 PM

    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 ()

    ReplyDelete
  59. Anonymous5:47 PM

    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 ()

    ReplyDelete