#create excel auto sort

[deramin2]

I'll say this for Daggerheart:

I didn't even make it through character creation before the physicality of the game inspired me to imagine the sort of Character Sheet Contraption that I would truly love playing it with. What would feel like a customizable instrument for playing the game?

I gathered simple materials and spent yesterday taping it all onto a cut of paper grocery bag. Got through several bouts of "This is so stupid; why am I doing this?" Actually finished a physical prototype, which I've never done so fast. Spent hours today gathering even more materials and reworking a particular system. I've done a lot of it through feel, using origami measurement folds for measuring and closing my eyes to feel how it would work during play as much as how it would look. There's sheet holders with various loading configurations, card holders, many abacus-like trackers, and hard surfaces all in a thing I can fold into a binder at the end of the game with very little to set back up or put away. Like a steamer trunk where all your things are tucked into neat little compartments. The mechanical button cockpit of my dreams for flying the game.

Something like this has been lurking in my mind taking root for the quarter century I've been playing TTRPGs, but everything's been so book-and-memory oriented that it never quite fully formed.

Things I've tried before to varying success:

Papers on table with a stack of books.

Lots of tabs in the books.

Storage clipboard.

Advanced Excel auto-leveling character sheets other people designed.

Advanced Excel auto-leveling character sheet I designed.

"Character Manual" where I copy over all relevant rules from every book into a single document and create combined leveling tables and detail every single thing I took when and how I calculated every number and put it in a binder. (This is what the Daggerheart cards effectively construct for you.)

Digital toolset platforms that conceptually do what I want but are confusing and buggy to use in practice.

Back to the Character Manual version 2.0.

Counting tokens.

Rotating dice as counting tokens.

[I've considered an abacus many times but never actually committed.]

Item and spell cards in the binder.

I've considered an abacus or abacus-like tracker many times but never actually committed. I accidentally taught myself how to count on my fingers similar to an abacus as a kid based on bastardized ASL. It is significantly harder to lose count when physically holding the numbers. Plus being able to count on my fingers up to 110 or 1023 depending on number system used is very handy. Counting to 10 rapidly outgrows its usefulness.

None of them have fully worked because the games themselves have not been designed for them to really work. I've been fighting the system every time. Mostly I've come out of it feeling bad about myself and that I was too incompetent at memorization, record keeping, and character building to play.

But Daggerheart is explicitly made to accommodate poor memories, minimal math, attention/comprehension gaps, rapidly getting assistance with the rules, arranging your own physically engaging space, and creating enough generalized scaffolding to fit the system into your ideas instead of trying to fit your ideas into the system.

Looking forward to trying it out in play with my other neurodivergent and disabled friends to see how it feels in play. But just being able to intuitively imagine and feel out the physical space of play is huge. Analogue interaction that would let me do things with my eyes closed accurately and not lose my place. Even if it ends up not being my preferred system, it's already taught me how I really want to be playing.

I really hope I'll keep pushing myself to complete this contraption and have a working, repeatable pattern. I would love to make + sell something like this, and/or make a pattern and instruction zine to sell.

[aechlys]

One of the most interesting things about looking at Buck-Tick lyrics is not just Atsushi (and Imai)'s evolution as a wordsmith but his evolution with topics, if that's even the right word for it. You literally get to watch him get hit by things we both do and don't know about that happen to him throughout his life, and then how over time he grew to deal with them- or sometimes just accept them as fucked- and what he thought about it. And of course not everything is auto-biographical- we know his love for creating characters to tell meaningful stories about- but you still have the well-known strains of how he deals with significant loss, how he comes to terms eventually with people from his past he can't change, his own fuck-ups, encouragement to fans, examinations of things he encountered either irl or in the news.

And then, whoever came up with the brilliant idea to record so many live performances literally from day one until the very, very end...because not only does he evolve with each layer of new songs but also with each fresh performance of even some of the band's oldest, iconic songs. We get to see for ourselves how his relationship to various subject matter changes from performance to performance, the best ones being with decades between them. Whether it's a raw, excruciating grappling, to a sort of sublime madness of acceptance, to finally elevating himself above the issue entirely-- 太陽に殺された/Murdered by the Sun is such an excellent example of this, and for those just wandering in is a song about questioning celebrity, whether it's worth being a player on the stage when the attention can be excruciating- and with the added subtext that the ones you love may die with you nowhere near them for the sake of success. Atsushi questioned his entire career with this song after his mother died from cancer while the band was on tour- "Murdered by the Sun" perhaps more than just a metaphor for being killed by the spotlight, but him as a son feeling extremely responsible for not being there. If you have the time to take out to watch all three play out, I encourage it:

The most famous, from 1992, where he even added an extra verse at the end that I don't think he ever sang again- an extremely raw and clawing performance where the lighting at the beginning hits his face perfectly to reveal a Noh mask-like countenance to pull us back to this idea of the oldest theatre, and also to the fact that he likely felt like he was currently hiding behind perhaps several masks at the time.

10 years later in 2003, now the lines of the song are drawn out, more floating, his lilting voice older and more seasoned than last time. It's been ten long years that probably shot by in a flash and he's experienced so much with still so much yet ahead of him. The madness of it all is settled in his bones now, you feel, and there is an acceptance about it even though he's learned to shoulder the strain that's still there.

10+ years again to 2015, now the song starts off as if he's telling a story about someone else entirely- he's risen so far above the issue because it is wholeheartedly his life now- but in the second half of the song you sort of see him reawaken and look back down at his past self as he asks his questions "Will I just die? Will I live?"- like looking back into the past and going "Well what will you choose, kid? Because here we are now." And in his final chorus he no longer is left beating himself up telling the sun to just kill him like he did the first time in the added verse- now he's blowing kisses to the sky in each direction as he thinks about those gone on- and this time, this time, at the end he does not die.

Honestly, that someone had the genius idea- even if it was just for marketing and to make money- of recording so so many lives which allows us to literally see it all in action with our own two eyes like the best sort of modern anthropology...I want to hug them. Because such a life...such an artist and their very vivid artistry is preserved forever now in a way that we can look at almost like pages in a book.

There is no conclusion to this post because ultimately there is no conclusion- at least not a satisfying one- to his story. Or perhaps, writing it out and thinking about it now, ironically there is. Atsushi, essentially, died on stage. Weirdly self-fulfilling that the 'sun' of the stage, in a sense, did catch up to him in the end when a song about dealing with problems in the moment was never meant to be a prophecy. And I don't think it was, genuinely. More of a curiosity at best. Something that makes his story all the more interesting, perhaps. And that's precisely why I think there's no ending to be had- every person who sinks their claws in deeply to the material will come away with some treasure that possibly no one has managed to see before. And that, right there, keeps adding pages to the book.

There is no ending because a sudden curtain fall does not constitute an ending, and there is no ending if all of us continue to add pages to his and the band's story. Not even the band is stopping their own page-adding- Imai claiming Atsushi was causing mischief in the studio while recording Subrosa is testament to that.

I don't know. This post started off as just a vehicle for me to rattle off the pressing thoughts I had about artistic and personal evolution and then turned into this whole thing so I don't have much of an ending here myself. Except to perhaps say don't stop listening, don't stop watching, don't stop posting and comparing and questioning and sharing your thoughts about things, because these are all pages to a book about a man whose artistry is very much alive and well- because of us. They say, too, sometimes, that when people are reincarnated they can still remember who they are, or they remember wisps of enough to recognize things from before. I'd like to think, perhaps in a rather fantastical way maybe, that when the wheel turns and he comes back again, that in his travels he may stumble across some old band called Buck-Tick and see not just the mountain of art he and his best friends created but also all of our little foothills piled around it containing our thoughts and translations and praises and grief and happiness all carefully built with love left behind for him and the guys. And that somehow, whether he understands it or not, he can smile at seeing us all again, even if it makes no sense to him at all.

[possessedscholar]

Actually, fuck it.

Metroid Prime 1 Edibility List.

With actual research and considerations*, going in the order the Metroid wiki lists them! One Caveat, if not mentioned to be toxic in any way then I am assuming non-toxicity, UNLESS a similar creature from Earth is poisonous.

Parasite: their size and large numbers would seem to imply they’d have decent meat on them, though their nature as pests may imply they could carry disease. Overall I’d put them in a similar area with rats: Edible with proper cooking and cleaning, but probably less pleasant than most edible creatures.

Auto Turret: Inedible, made of metal and wires. And unlike some Pirate contraptions I see no tortured animals used to make this one either.

Tallon IV Zoomer: The Zoomer itself is likely edible, but the species apparently carries a flesh eating bacteria that makes safely handling the species for consumption difficult. Indirectly inedible, but if raised without contracting the bacteria (or properly cleaned, IRL flesh eating bacteria can be killed with bleach) almost certainly similar to crab meat (with more legs than a crab as a bonus!)

Tallon IV Geemer: in terms of meat quantity, you’d think they’re similar to the Zoomer, but the fact that the spikes retract may imply a difference in muscle structure and/or carapace thickness that could mean less meat for consumption. As for actual edibility, implied to have a similar diet to the Zoomer (mentioned as disease carriers, and irl flesh eating bacteria is usually gotten from improper sewage handling), thus same rating as the Zoomer.

Sap Sac: Mentioned as being very sweet and delectable, and are visibly very large and fleshy, so edible… ON ONE CONDITION: Sap Sacs are explosive, but the logbook mention that only “Brave or ingenious creatures eat it” implies there are ways to consume Sap Sack flesh without being exploded. Based on the Remastered logbook image, it's likely you can eat a certain amount of the outer flesh before hitting the explosive core.

(Sap Sac Image for reference)

Bloodflower: Likely poisonous, at the very least has some manner of organ or gland that creates the projectile toxins that would need to be removed. Petals look unusually fleshy, and the three mouth-nodules could be similar to snakes, but overall edibility seems... unlikely, at best something that would require an intensive process to achieve.

Seedling: These seem to be surprisingly fleshy for plants, and no mention of toxicity or poison is made. Lower body seems similar to a slug or snail, but no slime trail is observes so likely not as similar as visuals may suggest. Combined with plant-based nature, Seedling is possibly edible and fruit or vegetable like, though it is unusually a plant one has to hunt before eating. Spines likely best if removed, but as the spines are not mentioned to be venomous, it's possible they could be a case of "safe to ingest but not desirable"

Tallon IV Scarab: Small-ish explosive bug, likely edible if you could somehow harvest and cook one without it exploding, but this seems so impossible I'm marking it down as inedible.

Beetle: Large arthropod similar to Zoomer/Geemer, but with added benefit of no mention of flesh eating bacteria. Best outcome, similar to crabs but absolutely massive. Worst outcome, tastes terrible like some insects but otherwise not toxic.

Plated Beetle: Like regular Beetle, but even more massive! Exposed abdomen is large, fleshy, and soft, which means it would likely be an excellent protein (assuming it doesn't taste terrible). Meanwhile, insides likely similar to that of non-plated cousins.

Tallon IV War Wasp: The Wasps themselves are likely edible! Bees and similar bugs on earth are actually a delicacy in some regions, especially the larvae, so War Wasps are possibly similar. Adult bees and wasps can be ground up to make a sort of flour, so there's a potential edibility point. Meanwhile, a logbook entry from Hunters indicates the Luminoth harvest War Wasp hives for the royal jelly, and it's possible that War Wasps have honey, like some terrestrial wasps (though as the vast majority of wasp species don't make honey, it is a slim chance.) Overall, War Wasps are likely incredibly edible.

Ram War Wasp: See the basic War Wasp, though notably in their boss fight, Ram War Wasps have an unusual tendency to dip their stingers into the toxic water seemingly as a means of poisoning them. Likely non-toxic themselves, but it could mean wild Ram War Wasps have contaminants in them.

Barbed War Wasps: Again, see the basic War Wasp. Seemingly a point in the favor of the Barbed War Wasp's favor is their absolutely massive abdomen, however the abdomen is likely larger to house the necessary biological mechanisms that allow for the firing and rapid regrowth of their stinger, as well as the production organs for the acidic compound contained in said stingers, which would almost certainly make Barbed War Wasps require more work to prepare for consumption. Still, likely edible if the proper preparations are taken for the abdomen.

Tallon IV War Wasp Hive: Hive itself likely inedible, but contains War Wasp larvae, royal jelly, and possibly honey (See War Wasp).

Eyon: A giant eye. In some Earth cultures, certain animals' eyes are considered a delicacy, and these are massive. Likely edible if they can be killed and have whatever produces the energy beam removed.

Plazmite: Likely similar to the Earthen Firefly, which is toxic due to all the chemicals needed for the bioluminescense. So, we can safely assume the Plazmite is equally inedible.

Shriekbat: Incredibly high internal temperature (121 Centigrade!) with no harm to self likely means even if they probably aren't poisonous, you'd have to wait forever for it to cool enough to safely eat. If we assume they are kept from cooking themselves while alive through either special organs or an incredibly efficient circulatory system, however, possible the meat of a dead Shriekbat cooks itself from leftover heat. Probably edible but impractical to work with. On the plus side, likely hot enough to kill potential parasites and microbes that try to infest them!

Tallon IV Tangle Weed: Simple plant with no mention of toxicity, likely all individual tendrils of a patch are attached to a singular bulb if their Venom Weed cousins are any indication. Probably edible, though if it is a single bulb one may need a shovel to dig it out.

Tallon IV Venom Weed: Similar to Tangle Weed, but contains a potent, seemingly corrosive venom delivered by barbs, presumably similar to how jellyfish deliver their venom. Further, the toxic water of the Chozo Ruins the Venom Weed is found in is implied to be have made the Venom Weed toxic. Likely inedible barring any changes in the future after the toxic water is gone.

Blastcap: Explicitly mentioned poisonous flesh, spores corrosive enough to eat through Samus's armor (seemingly), and also explodes. So goddamn inedible.

Reaper Vine: Appears to be a long, thick, bramble-like vine, but the ability to move itself implies some kind of muscle analogue. Main vine possibly edible but likely unpleasant, eye might be decently edible. Scythe head likely too tough to eat, sharp and hard enough to damage power armor.

Stone Toad: Large amphibian with rock hard skin and seemingly soft insides. Likely edible like some frogs are on Earth, and being a predator that eats smaller prey whole and with no mention of venoms or toxins likely needs no special preparation. Tough skin could help keep moisture in, keeping flesh nice and juicy for consumption throughout cooking. Only downside is figuring out how to kill and butcher one for consumption with rock hard skin in the way. Theoretically perfectly edible, hindered by lack of means to get through skin to prepare for consumption.

Plated Parasite: See standard Parasite entry at the top. Tougher, nigh unbreakable skin means this one is even more unappealing.

Oculus: Based on official art, somewhat turtle-like creature with a single eye on the top of their shell. Likely edible in the same ways turtles are, though legs are more like crab legs. This all said, the electricity generation means there are likely special organs that require special attention and removal to make the creature's meat edible.

Plated Puffer: Coated in metal and filled with toxic gas. Definitely inedible.

Hive Mecha: Robot, inedible. Contains Ram War Wasps however.

Incinerator Drone: Robot, inedible.

Chozo Ghost: Too intangible to eat, most likely.

Grizby: Large arthropod similar to Zoomer and Geemer, mentioned as carrion feeder, may carry bacteria. Otherwise, likely similar level and state of edibility. Tough carapace would help keep meat together while cooking, similar to cooking some shelled animals in their shell.

Burrower: Large arthropod with acidic spit. Likely too acidic to eat safely, though only the projectile spit is mentioned as acidic. At best need to remove saliva glands, maybe avoid the head all together.

Puffer: See Plated Puffer, just minus the metal coating.

Triclops: Large arthropod similar to Beetles. Likely similarly edible.

Magmoor: Large serpents that live in magma, can breathe fire. Definitely incredibly heat resistant, cooking flesh for consumption is likely difficult unless the skin is capable of surprising levels of temperature insulation, and if they can evolve to live in magma there's potential for parasites and diseases to do the same. Still, nothing suggests the meat is toxic, aside from potentially collecting minerals in their body from living in molten rock. Will put the Magmoor down as a solid "Maybe Edible in certain conditions/with certain prep work"

Puddle Spore: Lava Mollusk. Likely impossible to properly cook as even the insides are not hurt by the extreme heat of lava/magma, meat likely similarly builds up minerals from lava over time as suggested with Magmoor. Probably not edible.

----(Text Block Spacer)----

Crystallite: Large arthropod with ice shell. Ice shell unlikely to impart anything unique to Crystallite flavor wise, but likely as edible as any other large Tallon IV arthropod.

Ice Parasite: Likely similar to standard and Plated Parasites.

Ice Shriekbat: Similar to standard Shriekbat, but icy coating may help cool meat faster. Plus, high internal temperature combined with frigid environment could limit successes of diseases and parasites further than even basic Shriekbat (thermal shock.)

Pulse Bombu: Living ball of electricity, almost certainly inedible.

Scatter Bombu: See Pulse Bombu.

Ice Burrower: Similar to Burrower, but with icy outer shell.

Ice Beetle: Like standard Beetle, but with icy coating.

Flickerbat: Smallish flying hunters that eat small insects. Probably edible, though small, fast, and invisible enough that hunting some may be impractical.

Jelzap: Large aquatic apex predator. Likely edible, though if it's anything like sharks (One of Earth's aquatic apex predators), they may have high concentrations of mercury. Naturally composed of two halves connected by electrical impulses, butchering for meat likely somewhat simplified by this.

Baby Sheegoth: Young Sheegoth, still growing. Highly mobile predators, no mention of being poisonous and no venoms used in hunting implies lack of toxicity. Ice shell likely needs removal, small nubs in back that appear to be the beginning of the adult Sheegoth's crystal cluster likely also inedible. As Sheegoths move (and move fast), they likely have incredibly tough meat in their legs.

Adult Sheegoth: Baby Sheegoth but bigger and older. Crystal nubs in back have become absolutely gargantuan with age. Leg meat likely even tougher than that of Baby Sheegoth. Still likely edible though. Should find use for Sheegoth crystals, very pretty and can absorb energy as a defense mechanism.

Sentry Drone: Inedible, Machine. Unfortunate, as they're annoying enough that I wish I could eat one as a power move... Did I type that out loud?

Space Pirate, Tallon IV Deployment: Likely edible, but ethically I have Questions. Yes these guys are assholes but uh... you'd be eating a sapient creature.

Shadow Pirate: See Space Pirate. Cloaking device probably does not give invisibility when eaten.

Flying Pirate: See Space Pirate. Jetpack fuel likely toxic as well.

Aqua Sac: Like the Sap Sac, but instead of exploding this one just breaks into pieces that float away. Probably even more edible than the Sap Sac!

Tallon Crab: Formerly edible, but sadly Phazon mutation/contamination has made them no longer edible. Thanks Space Pirate High Command. >:(

Aqua Reaper: Looks like a giant squid or octopus tentacle. If they are like giant space octopus tentacles then I'd say edible, Space Calamari.

Aqua Drone: See Sentry Drone, but with added sogginess.

Aqua Pirate: See Space Pirate. Could see if special armor is salvageable and sell for credits, then just get a meal delivered by Space GrubHub.

Mega Turret: Bigger than Auto Turret, but likely just as inedible what with being made of metal and wires.

Glider: Large flying mollusk. Described as curiously magnetic, can be affected by Grapple Beam. Fleshy parts of body consist of eyes and a bunch of blue fleshy nodules going by official art. At best unpleasant to eat unless cooked in shell, at worst full of ferrous metals that could make it toxic.

Elemental Troopers: See Space Pirate, and no I'm not describing flavor profiles for each trooper.

Elite Pirate: See Space Pirate AND see Tallon Crab. It has both ethics questions and Phazon contamination! Inedible on like 50 levels! Ok maybe just two. Still.

Phazon Elite: See Elite Pirate. But also, has so much Phazon it likely gives radiation poisoning just by being within 10 inches of the thing without shielding.

----(Text Block Spacer)----

Metroid: Metroids are likely edible if they can be killed without shattering them. Outer membrane likely similar to jellyfish (which can be eaten), and rest of body also seems edible if cooked properly. Bioenergy absorption effects on edibility unknown, pirates describe the energy as not really taking a form they can scan or interact with.

Hunter Metroid: See Metroid, but larger and with tentacle that may serve as another edible part.

Fission Metroid: Inedible, result of heavy Phazon mutation/contamination.

Lumigek: Lives in the rotting remains of a Leviathan/Phazon Meteor. Likely radioactive enough to poison through proximity. Inedible.

Parasite Queen: Phazon contamination/mutation, likely inedible for that alone. Also, acidic saliva production is driven into overdrive by mutation, would require removal even if not rendered inedible by Phazon.

Flaahgra (and Tentacles): Source of poisons in Chozo Ruins waterways, likely full of the same toxins and would at best require intensive cleaning and cooking process to render even remotely consumable. Plus, likely a major Phazon mutant. Almost certainly inedible.

Thaardus: Sapient chunks of Phazon ore. Inedible and tooth shattering. Oh and radioactive also a consideration.

Omega Pirate: Arguably the second-least edible Pirate, behind only the Phazon Elite and likely tied with the Berserker Lord from 3.

Meta Ridley: As kickass as being known as the person to bring down and eat a Space Dragon would be, ethically I have Questions since Ridley is Sapient (Check the Manga that detail's canon!). Plus, likely so full of cybernetics that butchering is difficult. Yes I know the temptation to eat him in revenge for Samus's parents is there, but overall I must say edible chemically speaking, but ethically bad.

Metroid Prime: Metroid Prime is undoubtedly so full of Phazon that I'm pretty sure getting anywhere near it without the Phazon Suit should be fatal. Giant arthropod shape could imply similar meat to beetles, but in the NA GC Version it's full of assimilated technology and even without that it's probably just not feasible due to, again, massive Phazon levels. Core Essence even worse, basically the Bombu but made of Phazon energy. 100% Inedible.

[keyforrestuk]

Create Stunning Artwork from Your Photos with Photoshop Elements

Unleash Your Creativity: Turning Ordinary Photos into Masterpieces

In today’s digital age, capturing memories has become effortless, but transforming those simple snaps into breathtaking artwork requires the right tools and techniques. Adobe Photoshop Elements stands out as a powerful yet user-friendly software that empowers both beginners and seasoned photographers to elevate their images. Whether you're aiming to enhance colors, add artistic effects, or organize your vast photo collection, Photoshop Elements offers a comprehensive suite of features designed to inspire your creativity.

One of the key advantages of Photoshop Elements is its accessibility. Unlike the full version of Photoshop, which can be overwhelming for new users, this software provides intuitive tools that simplify complex editing processes. You don’t need to be a professional to make stunning edits; just a bit of guidance and a creative spark. To get started, consider investing in a genuine license such as the Adobe Photoshop Elements 2023 cheap option, ensuring you have legitimate access to updates and support.

Organizing your photos is the first step toward transforming your collection. Photoshop Elements includes an Organizer that allows you to sort images by date, location, or tags. This feature helps you quickly locate the perfect shot and plan your editing workflow efficiently. Once organized, you can use the powerful editing tools to enhance your images.

Enhancement features include auto-color correction, red-eye removal, and sharpening tools that can dramatically improve the quality of your photos. For a more artistic touch, explore filters and effects such as artistic sketches, watercolor, or vintage looks. These effects can turn a simple portrait or landscape into a piece of art that captures emotion and mood.

Beyond basic edits, Photoshop Elements excels in creative transformations. Use the layering feature to combine multiple images, add text overlays, or apply masks for selective editing. The Guided Edits mode walks you through complex effects step-by-step, making advanced techniques accessible to all users. Want to add a dreamy glow or create a surreal scene? These creative options can be achieved without extensive training.

Another significant benefit is the ability to share your artwork seamlessly. Once your masterpiece is ready, you can export it in high resolution for printing or share it directly on social media platforms. Photoshop Elements also offers templates and print layouts to create photo books, greeting cards, and posters, turning your digital images into tangible keepsakes.

If you’re looking for an alternative to a subscription-based Photoshop, purchasing a perpetual license of Photoshop Elements is a cost-effective solution. It provides all the essential features needed to organize, enhance, and creatively transform your photos without ongoing fees.

In conclusion, transforming your photos from simple snaps to stunning artworks is easier than ever with Photoshop Elements. Its blend of powerful tools and user-friendly interface makes it the perfect choice for photography enthusiasts eager to explore their creative potential. Take the first step today and unlock the artistic possibilities hidden within your photo collection.

[strawberrrystar]

I've been documenting my ao3 history since October 2023. Here's the method to my madness if anyone wants to do anything similar!! (this is all on google sheets, I wouldn't know the code for the excel equivalent)

disclaimer!! this is just a fun thing I like to do in my spare time. it's been perfectly created to best suit my reading style but I thought it'd be fun to share anyway

page 1: log (main)

In my main page, I have a fanfiction log with these as the categories:

and in N,2 I wrote this for ease of data collecting: =ArrayFormula(IF(G2:G<>"", TEXT(G2:G, "MMM YYYY"), ""))

to auto colour code:

click on which collumn you want to colour code by (I clicked C for fandom) --> go to format --> conditional formatting --> set the rule you want

page 2: data

I take all the information from the main page and sort it to make my brain happy ^_^

counting number of fics read per fandom per year: =QUERY(ARRAYFORMULA(FLATTEN(SPLIT(FLATTEN(main!C2:C1000),",;. ",1))),"Select Col1, count(Col1) where Col1 is not null AND Col1 <> '#VALUE!' group by Col1 label Col1 'fandom'")

counting word count per fandom:

make a pivot table with these settings

counting word count per month:

=SUM(main!H76:H121) I go in and change the parameters manually for every cell each month but there's probably an easier way of doing it

counting number of unique fics:

per month: =COUNTUNIQUEIFS(main!$A:$A, main!$N:$N, "Jan 2025")

per year: =COUNTA(UNIQUE(FILTER(main!$A:$A, YEAR(main!$G:$G) = 2025)))

I also have tables tracking my top ships, top tags, and top authors (these are all quite similar:

top ships: =QUERY(ARRAYFORMULA(FLATTEN(SPLIT(FLATTEN(main!D2:D1000),",;. ",1))), "SELECT Col1, COUNT(Col1) WHERE Col1 IS NOT NULL AND Col1 <> '#VALUE!' GROUP BY Col1 ORDER BY COUNT(Col1) DESC LIMIT 10 LABEL Col1 'ship'")

top tags: (I limit to the top 50) =QUERY(ARRAYFORMULA(FILTER(FLATTEN(TRIM(SPLIT(FLATTEN(main!F2:F1000), ","))), FLATTEN(TRIM(SPLIT(FLATTEN(main!F2:F1000), ","))) <> "")), "SELECT Col1, COUNT(Col1) WHERE Col1 IS NOT NULL GROUP BY Col1 ORDER BY COUNT(Col1) DESC LIMIT 50 LABEL Col1 'tag'")

top authors: =QUERY(ARRAYFORMULA(FLATTEN(SPLIT(FLATTEN(main!B2:B1000),",;. ",1))), "SELECT Col1, COUNT(Col1) WHERE Col1 IS NOT NULL AND Col1 <> '#VALUE!' GROUP BY Col1 ORDER BY COUNT(Col1) DESC LIMIT 10 LABEL Col1 'author'")

page 3: charts

using the tables from page 2, I generated these charts to help me visualise the data:

[pickupscrapmetaladelaide]

Top Scrap Metal Buyers in Adelaide: Who Pays the Best Prices?

Scrap metal recycling isn’t just great for the environment — it can also put money in your pocket. Whether you’re a tradesperson with leftover materials, a homeowner clearing out the shed, or a business with regular metal waste, selling scrap metal is a smart way to earn extra income. But not all buyers offer the same value. So, the big question is: who pays the best prices for scrap metal in Adelaide?

Let’s explore what makes a top scrap metal buyer Adelaide, what factors influence pricing, and highlight some of the most reputable names in the industry.

Why Sell Scrap Metal in Adelaide?

Adelaide, as a progressive and eco-conscious city, encourages sustainable waste disposal methods. Selling scrap metal aligns perfectly with this green mission. From copper wiring and aluminum cans to old appliances and construction offcuts, most metals can be sold, recycled, and repurposed.

By selling to a licensed scrap metal buyer, you:

Get paid for what would otherwise be waste

Free up space on your property

Reduce landfill waste

Support the local recycling economy

But who should you sell to?

What to Look for in a Scrap Metal Buyer

Not all scrap yards or dealers are created equal. When choosing where to sell your scrap in Adelaide, consider the following:

Competitive Prices: The best buyers stay current with market metal rates and offer fair value.

Weighing Transparency: Reputable businesses use certified scales and allow you to see the weighing process.

Convenient Location or Pickup Services: Some buyers offer pickup for bulk or commercial loads.

Good Reputation: Positive reviews, referrals, and customer service are key indicators.

Material Specialization: Some buyers specialize in certain metals like copper or brass and may pay more for them.

What Affects Scrap Metal Prices?

Scrap metal prices vary due to several factors:

Metal Type: Non-ferrous metals like copper, brass, and aluminum usually bring higher prices than ferrous metals like steel or iron.

Condition: Clean, sorted, and uncoated metals usually fetch higher prices.

Market Demand: Prices fluctuate with global metal markets.

Quantity: Bulk amounts may qualify for better rates.

Now, let’s explore some of the top scrap metal buyers in Adelaide who are known for fair pricing and excellent service.

1. Adelaide Metal Recycling - One of the most well-known names in the city, Adelaide Metal Recycling offers great rates for both ferrous and non-ferrous metals. They cater to individuals and businesses and are known for fast service and honest weighing.

Key Features:

Competitive rates

Accepts a wide range of metals

Offers vehicle scrapping services

Industrial and commercial pickup available

2. Pooraka Bottle & Can Recycling Centre - While more famous for container returns, Pooraka Recycling also buys various types of scrap metal. Their central northern location makes them popular with locals seeking convenience and good customer service.

Key Features:

Easy access

Accepts copper, brass, aluminum, and more

Friendly staff and fast turnaround

3. Salisbury Auto Parts & Scrap Metal - This buyer specializes in automotive scrap, but they also purchase a variety of other metals. If you’re scrapping an old car, they can handle the paperwork and removal too.

Key Features:

Great for car scrapping

Also buys batteries, radiators, and catalytic converters

Pays cash on the spot

4. Greenway Auto Recycling - Greenway is well-reviewed for paying solid prices for scrap vehicles and parts, and they also purchase general scrap metal. Their commitment to eco-friendly practices appeals to environmentally conscious sellers.

Key Features:

Known for auto scrapping

Environmentally certified recycler

Offers pickup services

5. Southern Recycling Centre - Located in Lonsdale, this recycling yard is ideal for residents in southern Adelaide suburbs. They cater to both one-time sellers and ongoing commercial clients.

Key Features:

Accepts bulk scrap loads

Upfront quotes

Handles industrial cleanouts and demolitions

How to Get the Best Price for Your Scrap

Even with the top buyers, a few tips can help you get the highest possible return:

Sort Your Metals – Separate copper, brass, aluminum, and steel. Mixed loads may be priced lower.

Remove Non-Metal Parts – Clean scrap is worth more. Remove plastic, rubber, or wood if possible.

Call Ahead – Get current rates, as prices change daily.

Ask for a Quote – Some buyers may offer higher rates for large or commercial loads.

Bring ID – South Australian regulations require ID for scrap metal transactions.

Final Thoughts

Whether you have a trailer full of metal offcuts or just a few bits of scrap in the garage, Adelaide offers a range of reputable buyers ready to turn your junk into cash. By choosing a trustworthy scrap metal buyer who pays fair prices and operates transparently, you can make the most of your materials — while helping the environment.

So next time you’re thinking of throwing out that old washing machine, car battery, or pile of copper wires — think again. You might be sitting on a pile of money.

[regalportaltower]

Get Back when driving: Premium Automobile Solution at Our Certified Tesla Accident Facility

In today's fast-paced planet, having a dependable car is vital. For Tesla managers, keeping their electricity automobiles in top-level tesla body shop condition is important certainly not simply for efficiency, but likewise for safety and security. If you find yourself needing fixing companies after a collision or even just finding quality auto service to maintain your Tesla operating smoothly, look no more than our certified Tesla wreck center

Understanding the Value of Quality Vehicle Service

When it concerns auto service for your tesla body shop lower merion pa Tesla, quality ought to certainly never be actually jeopardized. Here's why:

Why Choose a Certified Center?

Choosing a certified center makes sure that your auto gets focused treatment modified for its distinct needs. A professional Tesla wreck facility works with service technicians who are primarily learnt handling Tesla vehicles.

The Dangers of Disregarding Damage

Ignoring even small harm may bring about much bigger concerns in the future. As an example, tiny dents or blemishes can eventually expose important components to corrosion and corrosion.

The Price of Quality Service

While it may seem tempting to opt for less expensive repairs, investing in high-grade service essentially conserves you cash by extending the life of your automobile and protecting against pricey potential repairs.

Get Back on the Road: Top Quality Automobile Company at Our Accredited Tesla Collision Center

At our certified Tesla accident center, our team know the value of coming back when driving safely and securely as well as properly. Our experienced crew is actually devoted to providing top-tier automobile companies that accommodate specifically to the needs of your power vehicle.

Our Commitment to Excellence

We honor ourselves on preserving higher specifications in every components of our company. From first diagnostics to last repairs, our focus gets on supplying excellence every measure of the way.

State-of-the-Art Equipment

To ensure that our experts offer you along with the best possible solution, our team purchase modern equipment made exclusively for mending Teslas. This includes specialized tools as well as technology that enable our team to manage any sort of wreck damage effectively.

Expert Service technicians at Your Service

Our professionals are not only licensed however likewise possess years of expertise working with electrical autos. Their experience allows them to diagnose concerns promptly and perform necessary repairs efficiently.

Customer-Centric Approach

We understand that managing auto fixings can be taxing. That's why we focus on consumer fulfillment through delivering straightforward interaction throughout the repair service process.

Services Offered at Our Certified Tesla Accident Center

We provide a wide range of solutions created to fulfill all your car repair work needs to have:

Collision Fixing Services

Whether it's a small fender-bender or a significant collision, our wreck repair service services restore your motor vehicle's stability both aesthetically and structurally.

Steps Involved in Accident Repair

[fatallyserenebasilisk]

Return when traveling: Quality Vehicle Service at Our Accredited Tesla Accident Center

In today's fast-paced world, possessing a reliable auto is actually vital. For Tesla managers, preserving their electric motor vehicles in top-notch circumstances collision center is actually essential certainly not just for functionality, yet additionally for safety and security. If you discover yourself requiring fixing solutions after a collision or even just finding quality vehicle service to keep your Tesla managing perfectly, look no further than our certified Tesla crash center

Understanding the Importance of High Quality Automobile Service

When it involves automotive service for your Tesla, quality needs to never ever be actually endangered. Right here's why:

Why Pick a Certified Center?

Choosing a professional facility makes certain that your vehicle gets specialized care modified for its distinct needs. A qualified Tesla wreck facility employs service technicians that are specifically proficiented in taking care of Tesla vehicles.

The Dangers of Ignoring Damage

Ignoring even minor damages can bring about greater concerns down the road. For example, little dents or even blemishes may eventually expose critical components to rust as well as corrosion.

The Expense of Quality Service

While it could appear tempting to choose cheaper repair work, purchasing high-grade service inevitably saves you loan through prolonging the life of your car as well as stopping costly potential repairs.

Get Back while driving: Quality Automobile Solution at Our Professional Tesla Collision Center

At our certified Tesla accident center, our company know the usefulness of coming back while driving securely and efficiently. Our knowledgeable team is actually committed to offering top-tier auto services that serve especially to the necessities of your electricity vehicle.

Our Commitment to Excellence

We honor our own selves on sustaining high criteria in all components of our company. Coming from first diagnostics to ultimate repairs, our focus gets on supplying excellence every measure of the way.

State-of-the-Art Equipment

To guarantee that our experts supply you with the greatest possible service, our team invest in advanced equipment created especially for mending Teslas. This consists of focused tools as well as modern technology that allow our company to manage any sort of crash damages effectively.

Expert Technicians at Your Service

Our service technicians are actually certainly not merely qualified yet additionally possess years of expertise partnering with electricity lorries. Their know-how allows all of them to identify problems promptly and conduct important repair work efficiently.

Customer-Centric Approach

We comprehend that managing auto repairs may be taxing. That is actually why our company focus on customer fulfillment by delivering straightforward communication throughout the repair service process.

Services Delivered at Our Professional Tesla Collision Center

We supply a https://lifestyle.poolermagazine.com/story/52708757/news-distribution-burns-collision-center-now-offers-tesla-approved-collision-repair-services-to-montgomery-county-pa-chester-county-pa-and-mercer large range of solutions created to comply with all your vehicle fixing requires:

Collision Repair Services

Whether it's a small fender-bender or a significant accident, our accident fixin

[distantslayerslayer]

Come back when driving: Premium Automobile Solution at Our Licensed Tesla Collision Facility

In today's fast-paced planet, having a trusted auto is crucial. For Tesla managers, maintaining their electricity vehicles in excellent circumstances is necessary certainly not simply for performance, yet likewise for safety and security. If you discover yourself needing repair services after an accident or simply finding top quality automobile company to maintain your Tesla operating effortlessly, look no more than our certified Tesla wreck center

Understanding the Significance of Premium Automotive Service

When it concerns vehicle service for your Tesla, top quality needs to certainly never be weakened. Here's why:

Why Pick a Professional Center?

Choosing a tesla body shop licensed center guarantees that your lorry obtains concentrated treatment tailored for its distinct tesla body shop wrightstown pa requirements. A qualified Tesla wreck center employs service technicians who are actually specifically proficiented in handling Tesla vehicles.

The Dangers of Ignoring Damage

Ignoring even small damage can cause much bigger problems down the road. For example, little nicks or even scratches may inevitably leave open critical components to decay and corrosion.

The Price of Quality Service

While it might seem to be appealing to go for cheaper repair services, buying high-quality service inevitably spares you cash by prolonging the lifestyle of your auto and also preventing pricey potential repairs.

Get Back when traveling: High Quality Automotive Company at Our Licensed Tesla Collision Center

At our certified Tesla accident center, our experts know the relevance of getting back on the road safely and securely as well as efficiently. Our seasoned staff is committed to providing top-tier vehicle companies that serve primarily to the demands of your power vehicle.

Our Dedication to Excellence

We honor ourselves on maintaining higher specifications in all parts of our company. From initial diagnostics to final repair services, our focus gets on providing quality every action of the way.

State-of-the-Art Equipment

To make sure that our team provide you along with the most effective possible service, our team buy cutting edge equipment made exclusively for restoring Teslas. This features focused devices and also modern technology that permit our team to manage any sort of wreck harm effectively.

Expert Technicians at Your Service

Our technicians are actually certainly not just certified yet likewise possess years of expertise collaborating with power autos. Their skills allows all of them to identify problems promptly and also conduct important repair work efficiently.

Customer-Centric Approach

We know that handling automotive repair work may be nerve-racking. That's why our team prioritize customer satisfaction by providing transparent interaction throughout the repair service process.

Services Offered at Our Professional Tesla Wreck Center

We supply a large range of solutions created to fulfill all your automotive repair work needs:

Collision Repair service Services

Whether it is actually a minor fender bender or a major collision, our collision repair service companies repair your auto's integ

[fastrequiemskull]

Come back when driving: High Quality Car Solution at Our Certified Tesla Crash Center

In today's busy world, possessing a dependable vehicle is actually vital. For Tesla proprietors, sustaining their electric vehicles in top-level situation is actually necessary not just for efficiency, yet also for safety. If you locate on your own needing repair service services after an accident or just seeking high quality automobile service to maintain your Tesla running efficiently, look no more than our certified Tesla crash center

Understanding the Usefulness of Premium Auto Service

When it relates to auto service for your Tesla, premium ought to certainly never be actually endangered. Below's why:

Why Select a Licensed Center?

Choosing a certified center ensures that your auto acquires concentrated care modified for its distinct requirements. An accredited Tesla wreck center works with professionals who are actually especially learnt taking care of Tesla vehicles.

The Dangers of Neglecting Damage

Ignoring also minor harm can cause bigger concerns later on. For example, little nicks or even blemishes may inevitably expose essential elements to rust as well as corrosion.

The Cost of Quality Service

While it might appear appealing to go for less expensive fixings, acquiring top quality solution ultimately saves you amount of money through extending the life of your auto and also protecting against expensive potential repairs.

Get Back while driving: Top Quality Car Solution at Our Qualified Tesla Accident Center

At our certified Tesla crash center, our company comprehend the relevance of getting back on the road properly as well as properly. Our seasoned group is dedicated to supplying top-tier car services that provide primarily to the needs of your electric vehicle.

Our Dedication to Excellence

We honor ourselves on sustaining higher criteria in all aspects of our solution. From preliminary diagnostics to final repair work, our emphasis performs providing burns collision center superiority every action of the way.

State-of-the-Art Equipment

To ensure that our team supply you along with the most ideal possible service, our experts purchase cutting edge equipment created specifically for restoring Teslas. This features specialized tools and also modern technology that permit our company to take care of any sort of accident damages effectively.

Expert Technicians at Your Service

Our specialists are not only professional however likewise have years of expertise collaborating with electricity motor vehicles. Their competence enables them to detect problems rapidly and also carry out needed repair work efficiently.

Customer-Centric Approach

We understand that dealing with auto fixings could be difficult. That is actually why our team focus on customer total satisfaction by giving transparent communication throughout the repair process.

Services Supplied at Our Accredited Tesla Crash Center

We deliver a wide variety of solutions developed to comply with all your auto repair requires:

Collision Fixing Services

Whether it's a small minor car accident or even a major incident, our crash repair solutions restore your auto's stability both aesthetically as well as stru

[savvyhrms01]

Reimbursement Software – Account of Expenses Now Clear.

During office work, sometimes coffee with a client, sometimes outstation travel, sometimes a cab or lunch bill – expenses are always incurred. But when it comes to reimbursement, either the bills are lost, or one has to run after the accounts person, fill out forms from above, get approval, and then wait for the money. To get out of this mess, reimbursement software is a great solution.

What does reimbursement software do?

In simple words, this software keeps a digital record of every employee’s expenses. Whatever office-related expenses you have made, upload the bill, write the reason, and submit it. There is no need to send mail for approval; everything happens through the system. The accounts team sees everything clearly, and payment is also processed fast.

Why is it important in today's work culture?

Elimination of manual work Earlier, one had to fill paper forms, take signatures, and attach bills. Now, just take a photo from your mobile, upload it in the app, and the work is done.

Transparency increases With everything being digital, there is no confusion. Who claimed how much, what is pending, what got rejected - everything is clear. No mistake, no problem.

Auto-Check as per Policy Every company has its own reimbursement policy, ​​like a daily food limit is ₹500 or a maximum cab fare is ₹1000. Software auto-checks these things. There is no scope for submitting a wrong claim.

Faster Approvals & Instant Notifications First, send mail, wait for approval, and remind. Now software auto-notifies the manager. Whether it is approval or rejection, the employee gets an instant update of both.

Less tension in the Accounts Team The accounts team gets all claims in one place, sorted, with receipts and comments. The hassle of developing Excel is reduced, and the reimbursement cycle becomes faster.

Real Example – How a company solved this problem

In a marketing firm, the sales team used to travel every week. Every person had 8-10 bills. The accounts team used to take 2-3 weeks to get the claim approved. When they used the reimbursement software system, every claim started getting approved and released within 3 days. Employees are happy, and accounts are stress-free.

Is this useful for small businesses too?

100% brother! Whether you have 10 people or 500 in your office – the process gets streamlined after installing the system. It is even more important for small firms because there both HR and accounts are looked after by the same person.

Conclusion – Digital accounting of every expense

A Reimbursement system not only saves time, it creates a fair and fast system. The employee does not have to worry about handling every small receipt, and the company gets a crystal clear record of every claim. In today's digital work culture, if you want reimbursement to be a smooth process rather than a headache, then this software is a must-have.

[architecturalfirmsauckland]

Architectural Drafting Services and Architect Services: A Comprehensive Guide!

In construction and design, the value of accurate planning and professional supervision cannot be overstated. Whether you build a new building, strengthen an existing structure, or develop a commercial space, having the right commercial sort is essential for the project's success. This is where the Captive writing services, the architecture, and the general architects come into play. Beyond Architects wins the aspects of comprehension, from each set to satisfaction. Their wellness lies in their development's nuances and capacity to handle and resolve their extraordinary necessities and requirements.

Architectural Drafting Services include creating detailed technical designs and directing the construction of a building. These drawings include all plans and heights with transverse cuts and detailed specifications. Standard Industry Writers, such as Auto cad and Sketch Up, are used to create specific representations of a design concept. The technical specifications required for the entrepreneurs' permissions and execution. The recognition that your project is in capable hands provides comfort.

The architectural publisher technicians usually perform the architectural writing. They can work under approved architects, engineering, or independent design companies. Even if you don't hold a license to approve construction documents, his role is essential to translate concepts into the product plans. Even the best idea of a more excellent drawing can collapse during construction without accurate writing. The buildings created by architecture often have the highest market value. Professional service guarantees service with all laws and relevant codes.

Registered Architect Services: Licensed Expertise You Can Trust

Registered architect services guarantee drawings that engineers, entrepreneurs, and local authorities understand exactly how the building must be built, down to the details. A registered architect is a professional who has completed their accredited studies, practical experience, and a valid license. In most regions, only the recorded architects can access he construction plans and take responsibility for safety and design with regulations. Registered architects are authorized to take responsibility for the safety and completion of a project.

Please ensure the design responds to zoning laws, fire codes, ADA demands, and structural safety norms. Coordination, there are engineers, entrepreneurs, interior designers, and consultants. Supervisory visits to the site, reviewing the previewed drawing challenges, and guaranteeing quality control. The legal responsibility is one of the most critical differences between registered architects and other architecture professionals.

Benefits of Professional Architectural Services

They are also tied by an ethics code and professional standards created by the architectural licensing board. Architect services are often used as a term umbrella that includes registration, writing, and other services. These various services range according to the project's purpose and complexity. The architects mix the arts and science to create beautiful and practical spaces. Good planning minimizes construction errors and expensive changes

Architect services can be appropriate according to the customer's complexity and needs. When you start a project, choosing the right architectural support is essential. Writing services can be enough if the project does not require complex structural considerations. The architects' registered services through the best source like Beyond Architects are necessary to guarantee legality, security, and code compliance. The commitment of an architectural firm that offers a complete set of architectural services is ideal.

Conclusion

Architecture is much more than drawing buildings - it is a matter of creating spaces that run our lives and communities. Whether you need a construction draft, writing consultants for the concept, architectural services, or a cruise role, each played a crucial role. The understanding of changes and time to use all types of services is allowing you as an owner, the developer, or investor. With good professionalism on your part, you will become aesthetic but healthy and structural.

[stevediazblog]

How to Learn Alteryx: A Step-by-Step Guide for Beginners

Alteryx is now one of the most-loved platforms for data mixing, advanced analytics and automation. If you're a business analyst or a researcher, data analyst or moving into data analytics, acquiring Alteryx will increase your efficiency and enable you to get important insights from your data quickly.

In this post, we'll go through a straightforward and user-friendly guide to learning Alteryx effectively. From learning the basics of the platform to getting ready for work every step is created to help you gain the skills you need to succeed in real life and gain confidence using the platform.

What is Alteryx?

Alteryx is a robust auto-service analytics system that allows customers to join, clean and transform data from a variety of sources without writing complicated code. It has a drag-and-drop interface that is accessible to all types of users, both technical and non-technical.

Alteryx is a great tool for automating tasks. Alteryx it is possible to make repetitive chores easier, conduct statistical analysis, as well as even integrate with other tools such as Tableau, Power BI, R, and Python.

Why Learn Alteryx?

Here are some compelling motives:

A high demand for roles that involve data.

A user-friendly interface to complicated analytics

Excellent tool to automatize business workflows

Machine learning and advanced analytics integration

Improves the productivity of analysts and data professionals.

Step-by-Step Guide to Learning Alteryx

Step 1: Understand the Alteryx Platform

Start by becoming acquainted using beginning by gaining familiarity with the Alteryx Designer user interface. It is the primary application where the bulk tasks will be performed. Some of the most important elements to look into include:

Canvas: Where workflows are created

Tools palette: categorized operations like Input, Output, Preparation, Join, Parse, etc.

Window for configuration: Can be used to set the parameters for every tool

Results window: Shows output from your workflow

Alteryx offers a 14-day trial of Alteryx Designer. trial version of Alteryx Designer. Start by downloading it and exploring sample data.

Step 2: Use Alteryx Academy

Alteryx Academy provides a no-cost source provided by Alteryx that includes interactive videos, lessons and even challenges. It's beginner-friendly it covers all aspects of fundamentals to advanced processes.

The most important learning pathways comprise:

Beginning with Designer

Core Certification Prep

Weekly Challenges (for practice with hands)

Begin with "Interactive Lessons" as they offer a guided practice on the platform and explanations.

Step 3: Learn the Core Tools

Alteryx Designer is an Alteryx Designer platform has over 200 tools, however novices should concentrate on mastering the basics first. This includes:

Input Data / Output Data

Select

Filter

Join / Union

Sort

Formula

Summarize

Sample

Knowing how these tools operate can help you deal with the majority of common use cases, such as cleaning data, merging databases as well as filtering records and creating summary.

Step 4: Build Real Projects

The theory isn't enough, practice is essential. Do your best to duplicate your daily routines or download open data from websites such as Kaggle as well as Data.gov. Develop end-to-end workflows that incorporate data ingestion, transformation and export.

A few ideas for projects are:

Cleaning and preparing sales data

Data from multiple sources

Making monthly dashboards of business performance

Step 5: Earn Alteryx Certifications

Alteryx provides industry-recognized certificates. Alteryx Designer Core Certification Alteryx Designer Core Certification is an excellent place to begin. It is a way to prove your understanding of the basic instruments and the concepts.

The test is online, free and is open-book. The preparation for this certification enhances your knowledge of the practical applications.

Once you've completed the Core Level, you'll be able to move towards the Advanced and Expert levels.

Step 6: Join the Community

Alteryx Community Alteryx Community is an active online forum that lets users offer tips, ideas workflows, and the best methods. There are many benefits to this forum, including:

Inquiring questions and receiving expert advice

Community challenges can be addressed and solutions

Socializing with professionals and employers

Explore topics of interest and take part in regular discussions and other events.

Step 7: Explore Advanced Features

Once you've mastered the basics, look into further advanced areas, such as:

Predictive analytics using R as well as Python tools

Spatial analytics to analyze location and mapping

Automation with Alteryx Server as well as Scheduler

Making custom workflows and macros

These features provide more effective use cases and job possibilities.

Tips for Success

Try to practice every day even if only for 20-30 minutes

Note down screenshots or processes for future references.

Don't be a slave to memorizing. Focus on understanding the logic behind tool interactions

Make use of your "Search" feature inside Alteryx Designer to find quickly tools

Try working through the Weekly Challenges of Alteryx to improve your problem-solving abilities

Final Thoughts

Learning Alteryx will change how you handle data. Its easy-to-use interface and strong capabilities make it a vital tool for marketers, analysts as well as professionals working with data. If you follow this step-by-step tutorial and remaining constant, you'll develop the practical knowledge that makes you more useful in any role that relies on data.

Start small, continue to practice and don't be afraid look into Alteryx community and the Alteryx Training certification programs to keep yourself focused and keep growing.

[mommymoneymakeover]

Baby Step 0 - Budgeting

The Total Money Makeover insists that each of us have a budget, that we make cuts to it, and stick to it, if we are to be successful in a Total Money Makeover. Strict budgeting frees up cash for all of the Baby Steps, yet budgeting itself is not a Baby Step. At one point in the book, Dave Ramsey refers to budgeting as Baby Step 0. I believe that budgeting is extremely important, as all the Baby Steps are predicated on the success of a shrewd budget. IMO, budgeting should be Baby Step 1, and not relegated to some prerequisite or sidebar.

I looked at my Excel-based budget that existed long before I ever read The Total Money Makeover. I immediately saw places where I could make cuts and I leapt at the opportunity to do so. Gazelle-intensity, right? I found 10 budget line items that I can confidently cut, ranging from subscription and memberships to discretionary expenditures. This gives me an estimated total monthly savings of $715. Wow! An extra $715 laying around? That is money that I can put to use right away to create my first emergency fund in Baby Step 1 and begin to snowball my debt payments in Baby Step 2.

Here are the cuts I'm making:

Mobile Phone Plan: I canceled the data portion of my phone plan. Do I use it? Yes. Do I love it? Yes. Can I live without it? Yes. I spend most of my time at home and at the gym, where reliable WiFi is available. I almost always use data for things like music streaming, maps, and web browsing while I am on-the-go, but I do not need it. I only need talk and text. I will gladly go back to living in 2008. Savings: $45/month!

Auto Insurance: I increased the deductibles on my auto insurance and canceled features such as rental car coverage. In the past, paying a high deductible on a collision or paying out of pocket for a rental while my car is in the shop would have broken my budget. But now, with at least $1,000 in an emergency fund (Baby Step 1), I can cover those costs if needed. I am a very safe driver and have only needed body work and rental car coverage once every few years. I could have saved all that money. Savings: $22/month!

Gym Memberships: Gym is a very big part of my life, and I have spent accordingly. I have no shame in saying that I have memberships to 2 different gyms for strength training. That is not uncommon for a competitive powerlifter like myself, and I use both of those gyms regularly each week. But now is the time to take an honest look at the budget and get out the red pen. I have canceled by membership at a barbell club that is 37 miles from my home (bonus: gas savings). Will I miss training there? Somewhat. Can I live without it? Yes. My second gym membership is more local, and I will keep it but modify it. Currently my membership includes myself and my two young children. Today I am taking my children off the account to reduce the cost. My kids do not use the facility very often, especially in the summer coming up. Savings: $88/month!

Strength Coaching: I mentioned that I am a competitive powerlifter. Nearly all competitors have a coach of some sort. I happen to have the best coach in the business. I intend to keep training under him, but I have some options for costs and service levels. I currently send my coach videos of all my training for his review and comment. We agreed that I will go to a lower level of service at a lower cost, at least for a while, that does not include video reviews. I told my coach about the budget cuts I am making and why and he understood. I'm an experienced lifter and I will do my best with what I have. Savings: $140/month!

Charitable Donations: There are two non-profit organizations that I support with monthly payments. I will get back to them in future months once I have completed by Baby Steps 1 and 2. Savings: $15/month!

Groceries & Household Items: If you asked me to estimate how much I spent in this category in the past few months, I would have guessed around $800/month. Most of that spending would be at BJs Wholesale Club where I buy things like food, laundry detergent, napkins, pet food, and basics like underwear and t-shirts. I also shop at Amazon and it turns out I spend a lot more there than I knew. There are also occasional trips to drug stores but I buy few items there. Well, I just went through my bank statements and saw that I spent an average of $942/month for the past 4 months in these categories. I may not even have captured everything, so the value is potentially higher. I am putting myself on a grocery and household item budget of $600/month moving forward. I will be spending out of an envelope of cash. No more Amazon purchases unless I truly cannot buy the product anywhere else and it is a need, not a want. Savings: $340/month!

Gas: I typically fill up my Jeep Wrangler once per week and it needs 20 gallons at fill up. Sometimes as a single mother I just have to drive and make unplanned trips (sick kid at school--drive an extra 25 miles roundtrip!), but there is some elasticity in my demand for gas. For example, I am no longer going to drive round trip to the gym 37 miles away two times per week. That will save me 148 miles per week! Assume 20 gallons of gas gives me 420 miles, conservatively. That means driving round trip to the far-away gym takes up 1/3 of a tank each week. No more! I am going to creatively limit myself to 15 gallons of gas per week. Savings: $54/month!

Music Streaming Subscription: I have used different music streaming services over the years, and most recently had an all-access subscription to Pandora for $10.99 per month. before Pandora, I used to use Amazon Music Unlimited at a lower cost. I switched to Pandora due to interoperability issues with my Google Nest/Home equipment. I have now reverted back to Amazon Music (the free version included with my annual Prime membership, not the paid Unlimited version). Luckily for me, I discovered that the interoperability issues are now resolved and we can once again use voice commands with Google Nest/Home to stream music all over our house! Savings: $11/month!

There are some other categories that I used to spend money on each month, of which I have already dispensed: getting my nails done, and gaming. I did not count these in this budget cut estimate as I made those changes before I read The Total Money Makeover. More on gaming next time I write. I have to admit that I have an addiction with gaming apps (smartphones, tablets) and I have to come to terms with the costs--financial, mental, and physical.

[atplblog]

Price: [price_with_discount] (as of [price_update_date] - Details) [ad_1] ⚡Master Python Automation Like a Pro – Save time, Eliminate Repetitive Tasks & Supercharge Productivity - (2025 Edition)⚡❌ Tired of wasting time on repetitive tasks? ❌ Struggling to streamline workflows with Python? ❌ Want to automate everything from file management to web scraping and APIs?If yes, then, keep reading. This book is for you.In today’s digital world, automation isn’t a luxury, it’s a necessity. Whether you're a developer, data analyst, or business professional, automating repetitive tasks saves time, reduces errors and boosts productivity. Python’s simplicity and vast libraries make it the perfect tool; but knowing where to start can be overwhelming.This step-by-step crash course takes you from automation fundamentals to real-world applications. You’ll write efficient Python scripts, automate files, emails, databases, and web APIs, and even build web automation bots with Selenium. Through hands-on projects, you’ll apply automation in real-world scenarios, helping you streamline workflows, optimize processes, and master Python automation with confidence. Master Python Automation like a pro With:Python Fundamentals & Setup: Quickly install Python, configure IDEs, and write your first automation script with ease. File & Folder Automation: Say goodbye to digital clutter! Automate file renaming, organization, and sorting. Web Scraping Mastery: Extract real-time data from websites using BeautifulSoup and Selenium. Advanced Web Scraping: Tackle CAPTCHAs, AJAX-heavy websites, and JavaScript-based content like a pro. API Integration & Automation: Automate data retrieval from REST APIs, parse JSON, and interact with online services. Email Automation: Schedule and send emails, handle attachments, and integrate with Gmail or Outlook. Task Scheduling: Automate repetitive tasks with Cron jobs (Linux/macOS) and Task Scheduler (Windows).Data Processing with Pandas: Clean, filter, and analyze large datasets to streamline automation workflows. Excel & Spreadsheet Automation: Generate reports, format data, and create automated templates for efficiency. Building Interactive Dashboards: Use Flask and AJAX to create real-time web apps with dynamic charts. Cloud-Based Automation: Sync data, automate backups, and work with AWS S3 and cloud storage. Real-World Automation Projects: Work on hands-on projects like auto-organizing files, scraping news, and sending automated alerts.and so much, much more.... Whether you're a beginner automating daily tasks, a data analyst optimizing workflows, or a developer scaling systems, this book is your step-by-step guide to Python automation. Imagine saving hours by automating data processing, web scraping, emails, and system tasks with just a few lines of code. You'll build practical scripts, streamline workflows, and master time-saving techniques used by professionals.With clear guidance, expert insights, and best practices, you'll gain the confidence to apply automation immediately in your work or personal projects..Why Wait? Take control of your workflow with Python automation.📈Scroll up,'Click "Buy Now" and start mastering Python automation today!🚀 ASIN ‏ : ‎ B0DR38KB47 Language ‏ : ‎ English File size ‏ : ‎ 2.5 MB Simultaneous device usage ‏ : ‎ Unlimited Text-to-Speech ‏ : ‎ Enabled

Screen Reader ‏ : ‎ Supported Enhanced typesetting ‏ : ‎ Enabled X-Ray ‏ : ‎ Not Enabled Word Wise ‏ : ‎ Not Enabled Print length ‏ : ‎ 362 pages [ad_2]

[distantslayerslayer]

Coming From Paint to Physical Body: Comprehensive Automobile Repair Service Providers for Your Tesla

Introduction

Owning a Tesla is actually not practically having an auto; it's about welcoming a way of life of innovation, durability, and also groundbreaking innovation. Nevertheless, with such state-of-the-art vehicles happens the accountability of keeping their excellent condition. Whether you have actually been involved in a wreck or just need some regular upkeep, knowing the ideal lorry fixing solutions is essential. In this particular extensive quick guide titled From Coating to Body: Comprehensive Motor Vehicle Repair Solutions for Your Tesla, our company'll check out every thing you require to find out about receiving your Tesla restored, coming from coating jobs to bodywork.

Understanding Tesla's Unique Repair Needs What Creates Tesla Different?

Tesla vehicles are engineered in a different way than typical vehicles. Their power design calls for specialized knowledge and devices for repair work. Through knowing these differences, you may create knowledgeable selections concerning where to take your automobile for repairs.

The Relevance of Qualified Automobile Shops

Taking your Tesla to a licensed automotive store makes certain that service technicians are trained primarily in managing power vehicles. This is actually necessary not only for the high quality of company yet additionally for sustaining your warranty.

Types of Repair works for Your Tesla Collision Repair Services Assessing Damages After an Accident

If you've been in an incident, the primary step is actually assessing the harm. This https://remingtonkobb895.trexgame.net/trustworthy-tesla-repair-certified-body-shops-to-restore-your-vehicle-in-pa-and-nj consists of examining both apparent and covert elements like frame placement as well as electrical systems.

Choosing the Right Accident Center

When choosing a collision center, try to find one that focuses on Teslas and also has qualifications from Tesla itself.

Paint Repair Services Why Coating Matters?

A new coating of coating carries out much more than merely strengthen appearances; it guards versus corrosion as well as various other environmental factors.

Different Procedures of Coating Repair Touch-Up Jobs: For slight scratches. Full Resprays: For considerable damage. Clear Bra Installation: Secures versus potato chips and also scratches. The Process of Acquiring Your Tesla Repaired Step 1: Examination and Estimate

Before any sort of work begins, an evaluation will definitely show the extent of damages. Professionals will deliver a comprehensive estimate covering labor, components, and also opportunity required.

Step 2: Permission and Scheduling

Once you permit the estimation, booking the repair service becomes important. Depending on parts accessibility, this might take anywhere coming from days to weeks.

Step 3: Repair Execution

During this period, trained experts will perform the required repair services making use of OEM components and also top quality procedures developed particularly for Teslas.

Choosing A Dependable Wreck Facility in Chamber