TOPIC | [ShaDom][Open] Pillow Machine + Gacha
and part two~
@BrutusCourt
[img]https://i.postimg.cc/pPcgkzys/Pillow-Poison-Buttercup.png[/img][img]https://i.postimg.cc/2rDmBQBv/Pillow-Boa-Buttercup.png[/img][img]https://i.postimg.cc/KxJVvB7m/Pillow-Slime-Shadow.png[/img][img]https://i.postimg.cc/gcg12W4r/Pillow-Slime-Midnight.png[/img]
@Jeevas
[img]https://i.postimg.cc/knkLPCQ8/Pillow-Poison-Magenta.png[/img][img]https://i.postimg.cc/vQcddXpR/Pillow-Cherub-Grapefruit.png[/img][img]https://i.postimg.cc/GLGVcfKf/Pillow-Skink-Avocado.png[/img][img]https://i.postimg.cc/mT9Q6GgK/Pillow-Fade-Turquoise-Maize.png[/img][img]https://i.postimg.cc/9Wjy6N40/Pillow-Slime-Carmine-Maize.png[/img][img]https://i.postimg.cc/pVv7yB1L/Pillow-Skink-Caramel.png[/img][img]https://i.postimg.cc/w6tnrMmg/Pillow-Poison-Clay.png[/img][img]https://i.postimg.cc/HHG1fwzK/Pillow-Jaguar-Orca.png[/img]
Sleepless pillow time! >:u (part one)
@Golden
[img]https://i.postimg.cc/GL5RqP3F/Pillow-Flaunt-Ruby.png[/img][img]https://i.postimg.cc/qvmNYvNN/Pillow-Iridescent-Antique.png[/img][img]https://i.postimg.cc/PH3dXHbC/Pillow-Metallic-Spearmint.png[/img][img]https://i.postimg.cc/w9HC54cK/Pillow-Spool-White.png[/img][img]https://i.postimg.cc/DZhV6KvV/Pillow-Piebald-Ruby.png[/img][img]https://i.postimg.cc/zJdYGwgs/Pillow-Skink-Watermelon.png[/img][img]https://i.postimg.cc/KF1x4WQJ/Pillow-Savannah-Copper.png[/img][img]https://i.postimg.cc/dszXh5tx/Pillow-Lionfish-Cinnamon.png[/img][img]https://i.postimg.cc/197bQmxP/Pillow-Lionfish-Stone.png[/img][img]https://i.postimg.cc/Zb92YGZN/Pillow-Lionfish-White.png[/img][img]https://i.postimg.cc/XnbbHYWz/Pillow-Skink-Mauve.png[/img]
@Jeevas
[img]https://i.postimg.cc/c0YWB8p3/Pillow-Skink-Aqua.png[/img][img]https://i.postimg.cc/bz5hTCPx/Pillow-Lionfish-Fuchsia.png[/img][img]https://i.postimg.cc/NBrsCnH5/Pillow-Jaguar-Sunset.png[/img][img]https://i.postimg.cc/D7r2nb5h/Pillow-Piebald-Rust.png[/img][img]https://i.postimg.cc/BS6sT73Z/Pillow-Poison-Terracotta.png[/img][img]https://i.postimg.cc/x93SWVTT/Pillow-Skink-Lead.png[/img][img]https://i.postimg.cc/90H2gyGK/Pillow-Starmap-Cyan.png[/img][img]https://i.postimg.cc/CFx9XZQm/Pillow-Python-Dirt.png[/img][img]https://i.postimg.cc/r8gMtXvY/Pillow-Poison-Carrot.png[/img][img]https://i.postimg.cc/dqJJ1tSy/Pillow-Poison-Honey.png[/img][img]https://i.postimg.cc/ydCN6FQs/Pillow-Petals-Terracotta.png[/img]
Sleepless pillow time! >:u (part two)
@ZimeBelle
[img]https://i.postimg.cc/2kVRbqdV/Pillow-Stitched-Sand.png[/img][img]https://i.postimg.cc/hDD5SvZp/Pillow-Slime-Radioactive.png[/img][img]https://i.postimg.cc/7q8xFN3X/Pillow-Piebald-Blush.png[/img][img]https://i.postimg.cc/QCQyMNZZ/Pillow-Starmap-Caribbean.png[/img][img]https://i.postimg.cc/HT2f60Br/Pillow-Crystal-Flint.png[/img]
@kilorechoy
[img]https://i.postimg.cc/38VMgK99/Pillow-Tide-Aqua.png[/img][img]https://i.postimg.cc/sVfRzHvP/Pillow-Skink-Terracotta.png[/img]
Thanks everyone for ordering :D
Got some Sweepstakes for ya :D
@Jeevas
[img]https://i.postimg.cc/y7DcQggX/Pillow-194-23-166-140-106-86.png[/img][img]https://i.postimg.cc/s3bStj5F/Pillow-195-15-164-159-109-49-22-7.png[/img][img]https://i.postimg.cc/zzrhGxd0/Pillow-196-19-63-124-73-27.png[/img][img]https://i.postimg.cc/9WTT26BD/Pillow-197-29-19-3-53-9.png[/img][img]https://i.postimg.cc/FFFJj7XS/Pillow-198-46-111-69-124-106.png[/img][img]https://i.postimg.cc/YrzWGQZk/Pillow-199-30-44-85-112.png[/img][img]https://i.postimg.cc/WjSZs60w/Pillow-200-39-73-163-110-76-146.png[/img][img]https://i.postimg.cc/DF7sVY4z/Pillow-201-45-170-162-130.png[/img][img]https://i.postimg.cc/WT3kzFnL/Pillow-202-4-45-76-90-112-159-164.png[/img][img]https://i.postimg.cc/SkvzMSTX/Pillow-203-3-99-9-110-79-6.png[/img]
@sockmonkeygerald
[img]https://i.postimg.cc/5fQQ5hTs/Pillow-204-14-47-78-144.png[/img][img]https://i.postimg.cc/csqgFDN0/Pillow-205-49-157-156-8-9-61-127.png[/img][img]https://i.postimg.cc/dq87p8qd/Pillow-206-25-158-65-41-112.png[/img][img]https://i.postimg.cc/1msgQftd/Pillow-207-30-168-65-177.png[/img][img]https://i.postimg.cc/fzCVTDSR/Pillow-208-45-172-29-71.png[/img][img]https://i.postimg.cc/FFK7Y80g/Pillow-209-38-144-3-37.png[/img][img]https://i.postimg.cc/hg4JZzNz/Pillow-210-40-122-169-171-98-37.png[/img][img]https://i.postimg.cc/Qs6F2Nr6/Pillow-211-38-90-103-130.png[/img][img]https://i.postimg.cc/CSzRSyhw/Pillow-212-9-156-89-20.png[/img][img]https://i.postimg.cc/VmpdN7vn/Pillow-213-31-26-87-21-142.png[/img]
The rest will follow tomorrow :>
@Pinguin Awesome! Got some neat ancient genes in there!
@sockmonkeygerald Interested in comparing pillows?
@sockmonkeygerald Interested in comparing pillows?
@Pinguin Awesome! Got some neat ancient genes in there!
@sockmonkeygerald Interested in comparing pillows?
@sockmonkeygerald Interested in comparing pillows?
Hello everyone and sorry to ping you all :u
This note concerns those who use the pillow pile spreadsheet, specifically the Sleepy Sweepstakes part which contained an error. I can't tell who uses it so I simply pinged everyone who ordered a pillow so far to catch everyone who uses this part or might use it in the future :>
The last color of a gene with 7 colors in total was not displayed properly or rather at all. There are several ways to fix that issue depending on how comfortable you are around editing spreadsheets.
Alternatively you can ask me to fix it.
Sent a PM to me with a link to your spreadsheet and set the edit rights to everyone with a link. If it's still locked I'll request access.
[i]For non-coders - Replace the SSS tab[/i]
[LIST]
[*]Go to the template [url=https://docs.google.com/spreadsheets/d/1D_whh8ywMtQEIAbvOOvGnzHIiC51cPsh6s5wZg5o7gQ/edit#gid=1657856300]sheet here[/url] and right click on the SSS tab in the bottom row.
[*]Select "Copy to >" (the exact wording may differ since my system is in German) and hit "Existing sheet"
[*]Select your own pillow pile sheet.
[*]Copy over the entries you made in the old SSS tab to the newly copied over SSS tab. Make sure to only copy over the entries you made in column C to E which are lavender colored.
[*]After you're done you may delete the old SSS tab and rename the copied SSS to whatever you wish.
[/LIST]
[i]Coding peeps - add the missing stuff and fix code[/i]
[LIST]
[*]Add a new column AB after AA
[*]Edit the code in column O starting from row 4 to the bottom.
[*]Example code for O4:
[/LIST]
[code]=IF(OR(AB4="", AB4="X"), "", INDEX(REF!$B$2:$B, MATCH(AB4, REF!$A$2:$A, 0)))[/code]
[center]You can check whether it's working by using this example pillow.
It should show all rainbow colors in order
Red Orange Yellow Green Blue Indigo Violet
[img]https://i.postimg.cc/54gDPkTr/Pillow-0-35-160-120-105-87-50-45-38.png[/img]
The pillow will also be used as example entry from now on.[/center]
[size=1]@kirathekat, @shapelights, @Medievalredragon, @urbancountry26, @sockmonkeygerald, @Sushispider1212, @Tesnivy, @Golden, @SimplySpoiled, @JGW, @Jeevas, @BestNyx, @, @Gormanghaste, @Crystalitar, @Ajgreelyfan3, @therefore70, @magiritsa, @xxHenry1025xx, @PossiblyThembo, @midigod, @slytherhex, @chorderaos, @Kayuri, @chuchus900, @stanza, @KelpTheShark, @Anjoulas, @Sidegrinder, @sockmonkeygerald, @polkdotastronaut, @StarNinja, @Zillua, @Juxta13, @Tesnivy, @Aristata, @BestNyx, @Ebrietas, @HoodieCat, @Curoi, @Deladria, @Fenixinka, @Necoryn, @MissTracy, @AlphaSnowdust, @shapelights, @Medievalredragon, @Vivavolt, @urbancountry26, @starfye, @BrutusCourt, @reefsharkqueen, @Piko, @CallumsCove, @DriftingDreams, @FallingUpstairs, @Zebrask, @Golden, @Luaii, @Oakensleaf, @ScripturamRuby, @SimplySpoiled, @JGW, @MerlinMausi, @Sushispider1212, @Jeevas, @polkydots, @Stanzascale, @Hollowcene, @PolarBear, @AuroraTrueBlue, @kwozmotis, @Virga77, @SatyrGatyr, @CoralWyvern, @Rifter, @ZimeBelle, @kilorechoy
[/size]
Hello everyone and sorry to ping you all :u
This note concerns those who use the pillow pile spreadsheet, specifically the Sleepy Sweepstakes part which contained an error. I can't tell who uses it so I simply pinged everyone who ordered a pillow so far to catch everyone who uses this part or might use it in the future :>
The last color of a gene with 7 colors in total was not displayed properly or rather at all. There are several ways to fix that issue depending on how comfortable you are around editing spreadsheets.
Alternatively you can ask me to fix it.
Sent a PM to me with a link to your spreadsheet and set the edit rights to everyone with a link. If it's still locked I'll request access.
For non-coders - Replace the SSS tab
Coding peeps - add the missing stuff and fix code
@kirathekat, @shapelights, @Medievalredragon, @urbancountry26, @sockmonkeygerald, @Sushispider1212, @Tesnivy, @Golden, @SimplySpoiled, @JGW, @Jeevas, @BestNyx, @, @Gormanghaste, @Crystalitar, @Ajgreelyfan3, @therefore70, @magiritsa, @xxHenry1025xx, @PossiblyThembo, @midigod, @slytherhex, @chorderaos, @Kayuri, @chuchus900, @stanza, @KelpTheShark, @Anjoulas, @Sidegrinder, @sockmonkeygerald, @polkdotastronaut, @StarNinja, @Zillua, @Juxta13, @Tesnivy, @Aristata, @BestNyx, @Ebrietas, @HoodieCat, @Curoi, @Deladria, @Fenixinka, @Necoryn, @MissTracy, @AlphaSnowdust, @shapelights, @Medievalredragon, @Vivavolt, @urbancountry26, @starfye, @BrutusCourt, @reefsharkqueen, @Piko, @CallumsCove, @DriftingDreams, @FallingUpstairs, @Zebrask, @Golden, @Luaii, @Oakensleaf, @ScripturamRuby, @SimplySpoiled, @JGW, @MerlinMausi, @Sushispider1212, @Jeevas, @polkydots, @Stanzascale, @Hollowcene, @PolarBear, @AuroraTrueBlue, @kwozmotis, @Virga77, @SatyrGatyr, @CoralWyvern, @Rifter, @ZimeBelle, @kilorechoy
This note concerns those who use the pillow pile spreadsheet, specifically the Sleepy Sweepstakes part which contained an error. I can't tell who uses it so I simply pinged everyone who ordered a pillow so far to catch everyone who uses this part or might use it in the future :>
The last color of a gene with 7 colors in total was not displayed properly or rather at all. There are several ways to fix that issue depending on how comfortable you are around editing spreadsheets.
Alternatively you can ask me to fix it.
Sent a PM to me with a link to your spreadsheet and set the edit rights to everyone with a link. If it's still locked I'll request access.
For non-coders - Replace the SSS tab
- Go to the template sheet here and right click on the SSS tab in the bottom row.
- Select "Copy to >" (the exact wording may differ since my system is in German) and hit "Existing sheet"
- Select your own pillow pile sheet.
- Copy over the entries you made in the old SSS tab to the newly copied over SSS tab. Make sure to only copy over the entries you made in column C to E which are lavender colored.
- After you're done you may delete the old SSS tab and rename the copied SSS to whatever you wish.
Coding peeps - add the missing stuff and fix code
- Add a new column AB after AA
- Edit the code in column O starting from row 4 to the bottom.
- Example code for O4:
Code:
=IF(OR(AB4="", AB4="X"), "", INDEX(REF!$B$2:$B, MATCH(AB4, REF!$A$2:$A, 0)))
You can check whether it's working by using this example pillow.
It should show all rainbow colors in order
Red Orange Yellow Green Blue Indigo Violet
The pillow will also be used as example entry from now on.
It should show all rainbow colors in order
Red Orange Yellow Green Blue Indigo Violet
The pillow will also be used as example entry from now on.
@kirathekat, @shapelights, @Medievalredragon, @urbancountry26, @sockmonkeygerald, @Sushispider1212, @Tesnivy, @Golden, @SimplySpoiled, @JGW, @Jeevas, @BestNyx, @, @Gormanghaste, @Crystalitar, @Ajgreelyfan3, @therefore70, @magiritsa, @xxHenry1025xx, @PossiblyThembo, @midigod, @slytherhex, @chorderaos, @Kayuri, @chuchus900, @stanza, @KelpTheShark, @Anjoulas, @Sidegrinder, @sockmonkeygerald, @polkdotastronaut, @StarNinja, @Zillua, @Juxta13, @Tesnivy, @Aristata, @BestNyx, @Ebrietas, @HoodieCat, @Curoi, @Deladria, @Fenixinka, @Necoryn, @MissTracy, @AlphaSnowdust, @shapelights, @Medievalredragon, @Vivavolt, @urbancountry26, @starfye, @BrutusCourt, @reefsharkqueen, @Piko, @CallumsCove, @DriftingDreams, @FallingUpstairs, @Zebrask, @Golden, @Luaii, @Oakensleaf, @ScripturamRuby, @SimplySpoiled, @JGW, @MerlinMausi, @Sushispider1212, @Jeevas, @polkydots, @Stanzascale, @Hollowcene, @PolarBear, @AuroraTrueBlue, @kwozmotis, @Virga77, @SatyrGatyr, @CoralWyvern, @Rifter, @ZimeBelle, @kilorechoy
And the last few pillows for this round.
Thanks everyone for ordering :)
@Deladria
[img]https://i.postimg.cc/7hq8DJ93/Pillow-Ragged-Obsidian.png[/img][img]https://i.postimg.cc/mBVYBmXT/Pillow-Flaunt-Chartreuse.png[/img][img]https://i.postimg.cc/c0dRppcD/Pillow-Flaunt-Olive.png[/img][img]https://i.postimg.cc/t9MFVYGf/Pillow-Metallic-Platinum.png[/img][img]https://i.postimg.cc/Yk6NyrQG/Pillow-Crystal-Shadow.png[/img]
@sockmonkeygerald sorry to ping you three times in such a short time now :'D
[img]https://i.postimg.cc/8T5h5L9M/Pillow-Harlequin-Charcoal.png[/img][img]https://i.postimg.cc/F9wbw1Pc/Pillow-Candy-Algae.png[/img][img]https://i.postimg.cc/tqPdbyfc/Pillow-Candy-Ginger.png[/img][img]https://i.postimg.cc/3rTXJVQx/Pillow-Cinder-Spruce.png[/img][img]https://i.postimg.cc/DFkdgJ43/Pillow-Cinder-Soil.png[/img][img]https://i.postimg.cc/DvVsBHZP/Pillow-Spool-Thistle.png[/img][img]https://i.postimg.cc/FrjSqpk5/Pillow-Twinkle-Umber.png[/img][img]https://i.postimg.cc/b8PFx33z/Pillow-Twinkle-Rose.png[/img][img]https://i.postimg.cc/MWnbs1Yq/Pillow-Boa-Smoke.png[/img][img]https://i.postimg.cc/gYL8ymY0/Pillow-Octopus-Murk.png[/img]
And the last few pillows for this round.
Thanks everyone for ordering :)
@Deladria
@sockmonkeygerald sorry to ping you three times in such a short time now :'D
Thanks everyone for ordering :)
@Deladria
@sockmonkeygerald sorry to ping you three times in such a short time now :'D