Importing distribution type from excel

Importing distribution type from excel

Postby momar92 » Fri Mar 10, 2017 3:50 pm

Hi,


I have many distributions for many labels, in which I want to import everything from excel to make my model robust.

Is it possible to import the distribution type directly from excel? I tried editing set distribution parameters on reset through VL; I can change the name and import the numbered parameters, but I can't import the distribution type (i.e. Fixed, Average, Normal,etc.)

I would appreciate it if anybody has a clue.

Thank you! :)

Re: Importing distribution type from excel

Postby OliverPX » Fri Mar 17, 2017 11:46 am

If you set up an IF... ELSE statement that covers all of the distribution types, you should be able to do this.

That is, using the "Set Object Distribution Parameters" command won't let you use a sheet reference for the distribution type. So use the IF...ELSE statements to check the cell for the text and then set the distribution that way. It may be a bit of work to set up initially, but then should be completely dynamic.

Something like:

Code: Select all

IF ssData[1,1] = "Average"
   Set Object Distribution Parameters    Activity 1, Operation Time, Average, ssData[2,1], "","",""
ELSE IF ssData[1,1] = "Normal"
    Set Object Distribution Parameters    Activity 1, Operation Time, Normal, ssData[2,1], ssData[3,1],"",""
 

Malaysian virgin hair body wave 4 bundles deal malaysian body wave 7a unprocessed virgin hair weave 100% human hair exte

Postby papedDut » Sat Mar 25, 2017 11:30 am

Malaysian virgin hair body wave 4 bundles deal malaysian body wave 7a unprocessed virgin hair weave 100% human hair extensions ( 111.72 $)
Image
malaysian virgin hair body wave 4 bundles deal malaysian body wave 7a unprocessed virgin hair weave 100% human hair extensions... Hair Extension Type: Weaving ; Material: Human Hair ; Human Hair Type: Malaysia Hair ; Can Be Permed: Yes ; Chemical Processing: None ; Suitable Dying Colors: All Colors ; Brand Name: BEAU DIVA ; Items per Package: 4 Pieces...
Image


READ MORE
OUKITEL K6000 4G Phablet-139.73 $
Gem black suede slip-on sneaker ( 283.52 $) Pierre Hardy
Kerui wireless home gsm pstn sms voice security alarm system lcd screen burglar alarm system kit pir smoke fire door sensor ( 119.67 $)
New brand men's ski gloves snowboard gloves snowmobile motorcycle riding winter gloves windproof waterproof snow gloves ( 23.00 $)
14 5g 9cm 1pcs lot winter fishing hard bait vib with lead inside ice sea fishing ( 1.43 $)
Zipper fly solid color multi-pockets men's cargo shorts ( 18.77 $)
Running 261 dark gray suede, glitter and metallic leather whigh-tech fabric womens sneaker ( 157.81 $) Hogan Rebel
Sweet heart print scoop neck long sleeve blouse for women ( 10.25 $)
Oslamp hi-lo beam h4 led bulbs for car 6000k 2pcs led car headlight 2wd 4wd auto led head light suv 50wpair fanless cree chips ( 33.65 $)
Handmade Blue Gold Murano Glass Paper Knife ( 74.00 $)
2016 swimwear women sexy micro bikinis set brazilian bikini thong swimsuit plavky maillot de bain femme ( 16.99 $)
tactical Outdoor Self Defence Tactical Pen EDC Multi-Tool Tungsten Steel Glass Breaker Knife Blade LED light defense tool pen ( 11.90 $)
Traditional C Key Hulusi Gourd Cucurbit Flute with Case Chinese Musical Instrument Study-16.17 $
Funny icon pattern printing men's round neck short sleeves t-shirt ( 11.10 $)
Outdoor Waterproof Leg Gaiters for Hunting,Hiking,Walking,Climbing Trekking Snow Gaiters 1Pair ( 9.99 $)


Image


Return to “SIMUL8 Cafe”