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.


 
 

68 kommenttia.

  1. Kassandra

    lokakuu 4, 2020 at 08:05

    I loved as much as you will receive carried out right here.
    The sketch is attractive, your authored material stylish.
    nonetheless, you command get got an shakiness over that
    you wish be delivering the following. unwell unquestionably come more formerly again since exactly
    the same nearly very often inside case you shield this increase.

    Reply
  2. instagram story viewer private account

    lokakuu 5, 2020 at 19:02

    You need to take part in a contest for one of the most useful blogs
    online. I’m going to highly recommend this blog!

    Reply
  3. ig private unlock

    lokakuu 5, 2020 at 20:39

    Hi there to every single one, it’s truly a good for me to pay
    a visit this web page, it contains precious Information.

    Reply
  4. instagram private account viewer

    lokakuu 5, 2020 at 22:10

    At this time it looks like WordPress is the top blogging platform
    out there right now. (from what I’ve read) Is that what you’re using on your blog?

    Reply
  5. instagram private viewer

    lokakuu 5, 2020 at 22:32

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

    Reply
  6. Alma

    lokakuu 5, 2020 at 23:48

    Nice post. I learn something new and challenging on blogs I stumbleupon on a daily
    basis. It’s always exciting to read content from other writers and use a
    little something from other web sites.

    Reply
  7. private instagram viewer

    lokakuu 6, 2020 at 08:33

    If you wish for to get a great deal from this post then you have to apply these strategies to your won website.

    Reply
  8. instagram private account viewer

    lokakuu 6, 2020 at 09:12

    We are a gaggle of volunteers and opening a new scheme in our community.
    Your site provided us with useful information to work
    on. You have done a formidable job and our whole group
    will likely be thankful to you.

    Reply
  9. private instagram viewer

    lokakuu 6, 2020 at 09:28

    Greetings from Ohio! I’m bored at work so I decided to check out your site on my iphone during lunch break.
    I enjoy the knowledge you provide here and can’t
    wait to take a look when I get home. I’m amazed at how fast your blog loaded on my
    mobile .. I’m not even using WIFI, just 3G ..
    Anyways, good site!

    Reply
  10. privateinstaviewer

    lokakuu 6, 2020 at 09:31

    I like the valuable info you provide in your articles.
    I’ll bookmark your weblog and check again here regularly.
    I am quite sure I’ll learn many new stuff right here! Best of
    luck for the next!

    Reply
  11. private instagram viewer free

    lokakuu 6, 2020 at 11:14

    I’m not sure where you are getting your info, but great topic.
    I needs to spend some time learning much more or understanding more.
    Thanks for excellent information I was looking for this info for my
    mission.

    Reply
  12. how to view private instagram profiles 2020

    lokakuu 6, 2020 at 11:21

    I think this is one of the most significant info for me.

    And i am glad reading your article. But wanna remark on few general things,
    The site style is great, the articles is really nice
    : D. Good job, cheers

    Reply
  13. private profile viewer

    lokakuu 6, 2020 at 11:43

    Hello! Would you mind if I share your blog with my myspace group?

    There’s a lot of people that I think would really enjoy your content.
    Please let me know. Thanks

    Reply
  14. instagram private profile viewer

    lokakuu 6, 2020 at 12:18

    Wow! In the end I got a weblog from where I know how to in fact obtain helpful facts concerning my study and knowledge.

    Reply
  15. instaviewy

    lokakuu 6, 2020 at 21:34

    I am actually glad to read this webpage posts which consists of
    plenty of valuable information, thanks for providing
    these kinds of data.

    Reply
  16. viewprivateprofiles

    lokakuu 6, 2020 at 22:17

    Fantastic goods from you, man. I’ve understand your stuff previous to and you are just too
    magnificent. I really like what you have acquired here, really like what you’re saying and the way in which you say it.
    You make it entertaining and you still take care of to keep it wise.
    I can not wait to read far more from you.

    This is really a wonderful web site.

    Reply
  17. private instagram viewer

    lokakuu 6, 2020 at 23:22

    Hello! I realize this is somewhat off-topic however
    I needed to ask. Does operating a well-established
    blog like yours require a large amount of work? I’m brand new to running a blog but I do write in my diary everyday.
    I’d like to start a blog so I will be able to share my personal experience and views online.
    Please let me know if you have any kind of suggestions or tips for new aspiring bloggers.
    Appreciate it!

    Reply
  18. ig private unlock

    lokakuu 7, 2020 at 00:27

    You should take part in a contest for one of the greatest blogs on the
    net. I most certainly will recommend this blog!

    Reply
  19. private insta viewer

    lokakuu 7, 2020 at 02:48

    Howdy, i read your blog occasionally and i own a similar one and i was just curious if you get a
    lot of spam comments? If so how do you prevent it, any plugin or anything you can advise?
    I get so much lately it’s driving me mad so any help is very much appreciated.

    Reply
  20. private instagram viewer

    lokakuu 7, 2020 at 02:58

    Hi! This post couldn’t be written any better! Reading through this post reminds me of my old
    room mate! He always kept chatting about this.
    I will forward this page to him. Fairly certain he will have a good read.
    Thanks for sharing!

    Reply
  21. private profile viewer

    lokakuu 7, 2020 at 05:34

    I was wondering if you ever thought of changing the page
    layout of your website? Its very well written; I love what youve
    got to say. But maybe you could a little more in the way
    of content so people could connect with it better.
    Youve got an awful lot of text for only having one or two images.

    Maybe you could space it out better?

    Reply
  22. private instagram viewer

    lokakuu 7, 2020 at 06:00

    Peculiar article, totally what I was looking for.

    Reply
  23. private instaviewer

    lokakuu 7, 2020 at 06:43

    Hi just wanted to give you a brief heads up and let you know
    a few of the pictures aren’t loading properly. I’m not sure why but
    I think its a linking issue. I’ve tried it in two different browsers and both show the same
    results.

    Reply
  24. instagram private account viewer

    lokakuu 7, 2020 at 07:30

    Hey there! Do you know if they make any plugins to
    protect against hackers? I’m kinda paranoid about losing everything
    I’ve worked hard on. Any recommendations?

    Reply
  25. watchinsta

    lokakuu 7, 2020 at 08:13

    An intriguing discussion is worth comment. I think that you should write
    more about this subject, it might not be a taboo matter but typically people do not discuss these issues.

    To the next! Best wishes!!

    Reply
  26. ig private unlock

    lokakuu 7, 2020 at 09:04

    I really like your blog.. very nice colors & theme.

    Did you design this website yourself or did you hire someone
    to do it for you? Plz respond as I’m looking to construct my own blog and would like to find out where u got this from.

    thank you

    Reply
  27. instagram story viewer private account

    lokakuu 7, 2020 at 09:11

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

    Reply
  28. instagram story viewer private account

    lokakuu 7, 2020 at 10:11

    I’m not sure exactly why but this website is loading extremely slow for me.
    Is anyone else having this issue or is it a issue on my
    end? I’ll check back later on and see if the problem still exists.

    Reply
  29. private instagram story viewer

    lokakuu 7, 2020 at 10:32

    Hi there, I enjoy reading through your article
    post. I like to write a little comment to support you.

    Reply
  30. private instagram viewer

    lokakuu 7, 2020 at 14:24

    Usually I do not read article on blogs, but I would like
    to say that this write-up very pressured me to check out and do so!

    Your writing style has been surprised me. Thanks, quite great post.

    Reply
  31. instagram private profile viewer

    lokakuu 7, 2020 at 17:51

    Hello, i feel that i saw you visited my website thus i got here
    to go back the choose?.I am attempting to find issues to enhance my site!I suppose its ok to
    use a few of your ideas!!

    Reply
  32. private insta viewer

    lokakuu 7, 2020 at 20:39

    I am really enjoying the theme/design of your blog.

    Do you ever run into any internet browser compatibility issues?
    A small number of my blog audience have complained about my website not
    operating correctly in Explorer but looks great in Opera.
    Do you have any solutions to help fix this problem?

    Reply
  33. private profile viewer

    lokakuu 7, 2020 at 21:05

    What’s up it’s me, I am also visiting this
    website regularly, this website is genuinely good and the users are truly sharing good
    thoughts.

    Reply
  34. insta private viewer

    lokakuu 7, 2020 at 22:14

    Thanks for ones marvelous posting! I genuinely enjoyed reading it, you are a great author.I will ensure that I bookmark
    your blog and may come back down the road. I want to encourage that you continue your great posts, have a nice weekend!

    Reply
  35. private insta viewer

    lokakuu 7, 2020 at 22:24

    Great blog here! Also your website loads up very fast!
    What web host are you using? Can I get your affiliate link to your host?
    I wish my web site loaded up as quickly as yours lol

    Reply
  36. instagram private account viewer

    lokakuu 7, 2020 at 23:46

    Hi I am so excited I found your weblog, I really found you by accident, while
    I was browsing on Yahoo for something else, Anyways I am here
    now and would just like to say kudos for a marvelous post and a all round enjoyable blog (I also love the theme/design), I don’t
    have time to read through it all at the minute but I have saved it
    and also included your RSS feeds, so when I have
    time I will be back to read more, Please do keep up the great b.

    Reply
  37. instagram private account viewer

    lokakuu 8, 2020 at 00:23

    Thank you for every other informative web site.

    The place else could I am getting that kind of information written in such
    an ideal way? I have a undertaking that I’m just now operating on, and I have
    been at the glance out for such info.

    Reply
  38. instagram private profile viewer

    lokakuu 8, 2020 at 01:37

    Every weekend i used to go to see this site, as i want enjoyment, since this this site conations genuinely fastidious funny information too.

    Reply
  39. private instagram viewer

    lokakuu 8, 2020 at 02:30

    Howdy! I know this is somewhat off-topic but I had to ask.
    Does operating a well-established blog such as yours take a massive amount
    work? I’m brand new to blogging however I do write in my journal daily.
    I’d like to start a blog so I can share my personal experience and views online.
    Please let me know if you have any kind of recommendations or tips
    for new aspiring bloggers. Appreciate it!

    Reply
  40. private instagram viewer free

    lokakuu 8, 2020 at 03:47

    I feel this is one of the such a lot significant
    information for me. And i am glad studying your article.
    However want to remark on some basic things, The site taste is ideal, the articles is in point of fact excellent :
    D. Good process, cheers

    Reply
  41. private insta viewer

    lokakuu 8, 2020 at 04:03

    Hey there! I understand this is sort of off-topic but I needed to ask.
    Does managing a well-established blog such as
    yours require a large amount of work? I’m completely
    new to writing a blog but I do write in my diary
    every day. I’d like to start a blog so I can share my personal experience and feelings online.

    Please let me know if you have any recommendations or tips for new aspiring
    blog owners. Thankyou!

    Reply
  42. private insta viewer

    lokakuu 8, 2020 at 04:14

    This is my first time visit at here and i am truly pleassant to read all at alone place.

    Reply
  43. private instagram viewer

    lokakuu 8, 2020 at 05:51

    We’re a group of volunteers and opening a new scheme in our community.
    Your website provided us with valuable information to work on. You have done an impressive job and our entire community will be thankful to you.

    Reply
  44. private insta

    lokakuu 8, 2020 at 10:15

    Keep on working, great job!

    Reply
  45. instaviewy

    lokakuu 8, 2020 at 10:51

    It’s difficult to find knowledgeable people for this topic, but you sound like you know what you’re talking
    about! Thanks

    Reply
  46. Nadine

    lokakuu 8, 2020 at 11:23

    Whats up this is kinda of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually
    code with HTML. I’m starting a blog soon but have no coding skills
    so I wanted to get advice from someone with experience. Any help would
    be greatly appreciated!

    Reply
  47. Adriene

    lokakuu 8, 2020 at 17:26

    This site was… how do you say it? Relevant!! Finally I have found something that helped me.
    Cheers!

    Reply
  48. instagram private profile viewer 2020

    lokakuu 9, 2020 at 04:00

    I visited various sites but the audio feature for audio songs
    present at this website is truly wonderful.

    Reply
  49. instagram private kullanıcı adları

    lokakuu 9, 2020 at 04:06

    I know this if off topic but I’m looking into starting my own blog and was wondering what all
    is required to get setup? I’m assuming having a blog like yours would cost a pretty
    penny? I’m not very internet savvy so I’m not 100% positive.
    Any tips or advice would be greatly appreciated. Appreciate it

    Reply
  50. private instagram mp4

    lokakuu 9, 2020 at 05:17

    I really like what you guys are up too. This sort of
    clever work and coverage! Keep up the great works guys I’ve added you guys to my own blogroll.

    Reply

Vastaa

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