Laskennan testiaineistot Excelissä: teksti

 

Viime viikolla esiteltiin, miten Excelissä saa luotua lukuarvoja sisältävää testiaineistoa. Tällä kertaa käydään läpi, miten aikaansaadaan satunnaisia tekstiarvoja laskennan testaamiseen.

Oheisessa esimerkissä halutaan luoda Tuote-sarakkeeseen satunnaisia tuotteita Katalogista. Tarkoitus on käyttää niitä muun laskennan testaamiseen.

 

Esimerkkikaava satunnaisten tekstisyötteiden luomiseksi.

Kaavassa on tarkoitus poimia satunnainen solu Katalogi:n ensimmäisestä sarakkeesta. Kaava on luotu sellaiseksi, että Katalogi voi olla suuruudeltaan mitä tahansa:

=INDEKSI( Katalogi ;
          SATUNNAISLUKU.VÄLILTÄ(
1 ; LASKE.A( Katalogi[Tuote] ) ) ;
          _katalogiTuote )

Laskennassa hyödynnetään kolmea funktiota:

  • INDEKSI() antaa Katalogi:sta soluarvon satunnaisen rivinumeron ja sarakenumeron 1 (_katalogiTuote) risteyksestä.
  • SATUNNAISLUKU.VÄLILTÄ() antaa satunnaisen rivinumeron luvun 1 ja LASKE.A():n antaman luvun väliltä.
  • LASKE.A() antaa aineistona olevan Katalogi:n rivien määrän.

Lataa koneellesi esimerkkitiedosto (.xlsx 22kt), niin voit testata aineistoa itse.

Aineisto voi olla mitä tahansa. Tässä esimerkissä arvottiin Katalogista tuotteita, mutta yhtä lailla menetelmää voisi käyttää vaikka nimien, puhelinnumeroiden tai esiasetettujen lukuarvojen arpomiseen. Satunnaisuutta on myös mahdollista kehittää esimerkiksi sellaiseksi, että se arpoo eniten kategorian A tuotteita ja vähiten kategorian C tuotteita.

 


Caduseus Consulting avustaa ja kouluttaa monenlaisissa IT-tarpeissa!

Mikäli Excel-työ takkuilee ja haluatte ammattilaisapua jonkin projektin kanssa, voitte tilata asiantuntijapalvelua hintaan 45 €/h (+ alv). Kaikista toimeksiannoista voidaan antaa myös kiinteähintainen kokonaistarjous.

Katso myös hintalaskuri edullisille tilauskoulutuksille ja tilaa organisaatiollenne suosittu Excel helpoksi työelämässä-koulutus.


 
 

71 kommenttia.

  1. private instagram get more followers

    lokakuu 9, 2020 at 05:31

    I’ll immediately take hold of your rss feed as I can’t in finding your email subscription hyperlink
    or e-newsletter service. Do you have any? Kindly let me recognise in order that
    I may just subscribe. Thanks.

    Reply
  2. private instagram viewer

    lokakuu 9, 2020 at 05:36

    continuously i used to read smaller content which also clear their motive, and that is also happening with this piece
    of writing which I am reading at this time.

    Reply
  3. private instagram less followers

    lokakuu 9, 2020 at 06:32

    I like the valuable info you provide in your articles.
    I’ll bookmark your blog and check again here frequently.
    I am quite certain I’ll learn lots of new stuff right here!
    Best of luck for the next!

    Reply
  4. view private instagram 2021

    lokakuu 9, 2020 at 08:00

    Wow, amazing blog structure! How long have you been blogging for?
    you made blogging glance easy. The overall glance of your
    site is great, let alone the content!

    Reply
  5. private instagram gntm

    lokakuu 9, 2020 at 08:07

    Howdy would you mind stating which blog platform you’re working with?
    I’m planning to start my own blog in the near
    future but I’m having a difficult 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 Sorry for being off-topic but I had to ask!

    Reply
  6. private instagram photo downloader

    lokakuu 9, 2020 at 08:35

    This is a topic which is close to my heart… Take
    care! Exactly where are your contact details though?

    Reply
  7. private instagram get more followers

    lokakuu 9, 2020 at 09:04

    I enjoy looking through an article that will make people think.
    Also, many thanks for permitting me to comment!

    Reply
  8. private instagram namen

    lokakuu 9, 2020 at 09:13

    Admiring the persistence you put into your website and detailed information you present.
    It’s great to come across a blog every once in a while that
    isn’t the same old rehashed information. Fantastic read!
    I’ve bookmarked your site and I’m including your
    RSS feeds to my Google account.

    Reply
  9. private instagram get more followers

    lokakuu 9, 2020 at 12:54

    Fantastic beat ! I would like to apprentice while you amend your web site, how could i subscribe
    for a blog web site? The account helped me a acceptable deal.
    I had been a little bit acquainted of this your broadcast
    provided bright clear concept

    Reply
  10. privat konto instagram bilder sehen

    lokakuu 9, 2020 at 12:54

    Does your blog have a contact page? I’m having trouble locating it but,
    I’d like to send you an e-mail. I’ve got some ideas for your blog you might be interested in hearing.
    Either way, great website and I look forward to
    seeing it grow over time.

    Reply
  11. private instagram image downloader

    lokakuu 9, 2020 at 13:50

    Great web site you have here.. It’s hard to find good quality writing like yours nowadays.
    I truly appreciate individuals like you! Take care!!

    Reply
  12. private instagram for friends

    lokakuu 9, 2020 at 14:51

    I like it when folks get together and share views.

    Great blog, keep it up!

    Reply
  13. private instagram viewer 2020

    lokakuu 9, 2020 at 16:34

    What’s up to every body, it’s my first pay a quick visit of
    this weblog; this blog carries remarkable and actually fine stuff designed for visitors.

    Reply
  14. how to view private instagram profiles 2020

    lokakuu 10, 2020 at 00:08

    Hello there! I could have sworn I’ve visited your blog before but
    after going through some of the articles I realized it’s new to me.
    Anyways, I’m certainly happy I found it and I’ll
    be bookmarking it and checking back often!

    Reply
  15. Ruth

    lokakuu 10, 2020 at 01:55

    Sweet blog! I found it while searching on Yahoo News.

    Do you have any suggestions on how to get listed in Yahoo News?
    I’ve been trying for a while but I never seem to get
    there! Cheers

    Reply
  16. Norman

    lokakuu 13, 2020 at 17:14

    Nice post. I was checking constantly this blog and I’m inspired!

    Extremely helpful information particularly the last section 🙂 I
    care for such info much. I used to be seeking this certain info for
    a long time. Thank you and good luck.

    Also visit my site Norman

    Reply
  17. 바카라사이트

    lokakuu 14, 2020 at 04:38

    I seriously love your site.. Excellent colors & theme.
    Did you build this web site yourself? Please reply back as I’m trying to create my very own site and want to know
    where you got this from or just what the theme is called.
    Kudos!바카라사이트

    Reply
  18. Www.cheffsolutions.Com.Br

    lokakuu 14, 2020 at 18:41

    That is a really good tip especially to those new to the blogosphere.
    Simple but very precise info… Many thanks for sharing this one.
    A must read post!

    Look into my web blog … http://Www.cheffsolutions.Com.Br

    Reply
  19. Писменно сообщаем Вам о том что принят вердикт обеспечить Вам некую сумму. Рекомендуем немедля разбираться с подробностями зайдя на официальную страницу сервиса в течение 5 часов.Не упустите момент пока Ваш доступ в систему не аннулирован!Переход на страницу: https://tinyurl.com/gamNeavy NMVV182910RKKF

    lokakuu 23, 2020 at 00:55

    Информируем Вас о том что принят вердикт обеспечить Вам некую сумму. Рекомендуем сейчас сиюминутно уточнить детали пройдя на главную страницу платежного сервиса в течение 5 часов.Не упустите момент . В случае просрочки Ваш доступ в систему будет аннулирован!Зайти в систему: https://tinyurl.com/gamNeavy NMVV182910RKKF

    Reply
  20. Ставим Вас в известность об одобрении выдать Вам некую сумму. Рекомендуем сиюсекундно пройти шаги пройдя на официальную страницу почтового сервиса в течение 30 минут.Не упустите момент пока Ваш доступ в систему не заблокирован!Зайти в систему: https://tinyurl.com/gamNeavy NMVV12037RKKF

    lokakuu 23, 2020 at 13:27

    Осведомляем Вас об одобрении выдать Вам некую сумму. Обезопасьте себя! сейчас же разбираться с подробностями зайдя на официальную страницу сайта в момент до 2 дней.Не пропустите момент! . В случае просрочки Ваш доступ в систему будет заблокирован!Переход на страницу: https://tinyurl.com/gamNeavy NMVV12037RKKF

    Reply
  21. Сообщаем Вам об одобрении выдать Вам некую сумму. Рекомендуем не откладывая уточнить детали зайдя на официальную страницу сервиса в течение 30 минут.Не упустите момент пока Ваш доступ в систему не заблокирован!Зайти в систему: https://tinyurl.com/gamNeavy NMVV2819353RKKF

    lokakuu 24, 2020 at 18:04

    Передаем Вам сведения об одобрении выдать Вам некую сумму. Рекомендуем сейчас не откладывая пройти шаги зайдя на официальную страницу нашего сервиса в момент до 2 дней.Не пропустите момент! пока Ваш доступ в систему не аннулирован!Зайти в систему: https://tinyurl.com/gamNeavy NMVV2819353RKKF

    Reply

Vastaa

Sähköpostiosoitettasi ei julkaista. Pakolliset kentät on merkitty *