toiota

Gir bort ett Steam-spill: Pumped BMX Pro (2019) Tags: Bikes, BMX, Sports Pumped BMX Pro.txt

Gir bort ett Steam-spill: Ironcast (2015) Tags: Strategy, Match 3, Indie, Steampunk, RPG, Mechs, Puzzle, Roguelite, Perma Death, Singleplayer, Roguelike, Casual, Turn-Based Ironcast.txt

Gir bort ett Steam-spill: Degrees of Separation (2019) Tags: Local Co-Op, Puzzle Platformer, 2D Platformer, Story Rich, Co-op, Puzzle, Online Co-Op, Side Scroller, Platformer, Difficult, Atmospheric, Romance, Colorful, Hand-drawn, 2D, Relaxing, Action-Adventure, Magic, Music, Family Friendly Degrees of Separation.txt

Gir bort ett Steam-spill: The Forgotten City (2021) Tags: Adventure, Time Travel, Mystery, Exploration, Choices Matter, Investigation, Indie, Story Rich, RPG, First-Person, Walking Simulator, Multiple Endings, Atmospheric, Great Soundtrack, Philosophical, Remake, Fantasy, Open World, Rome, Silent Protagonist The Forgotten City.txt

Gir bort ett Steam-spill: Blue Fire (2021) Tags: Cute, Metroidvania, 3D Platformer, Adventure, Exploration, Platformer, Fantasy, Singleplayer, Stylized, Action-Adventure, Action, Indie, 3D, Third Person, Atmospheric, Hack and Slash, Surreal, Souls-like, Precision Platformer, Controller Blue Fire.txt

Gir bort ett Steam-spill: Pumped BMX Pro (2019) Tags: Bikes, BMX, Sports Pumped BMX Pro.txt

Gir bort 1 Steam-spill: Necrosmith (2022) Tags: Zombies, Action Roguelike, Tower Defense, Bullet Hell, Roguelite, Strategy, Top-Down, Roguelike, 2D, Pixel Graphics, Simulation, Dark Fantasy, Vampire, Magic, Old School, Combat, Werewolves, Singleplayer, Exploration, Supernatural. Necrosmith.txt

NB! Alle kodene er nå brukt. Jeg gir bort enda noen Steam-spill, og med det avsluttes årets "vårrengjøring" :-) Syberia (2002) TAGS: Adventure, Point & Click, Puzzle, Female Protagonist, Casual, Steampunk, Atmospheric, Story Rich, Mystery, Classic, Singleplayer, Escape Room, Beautiful, Great Soundtrack, Third Person, Sci-fi, Hidden Object, Nostalgia, 2.5 Edna & Harvey: The Breakout - Anniversary Edition (2008/2019) TAGS: Adventure, Indie, Point & Click, Comedy, Puzzle, Dark Humor, Female Protagonist Silence (2016) TAGS: Adventure, Point & Click, Story Rich, Great Soundtrack, Indie, Singleplayer, Puzzle, Female Protagonist, Exploration, Casual, 2D, Retro, Short, Cult Classic, Classic Ken Follett's The Pillars of the Earth (2017) TAGS: Choices Matter, Adventure, Visual Novel, Story Rich, Point & Click, Medieval, Indie, Casual, Interactive Fiction, Based On A Novel, Atmospheric, Singleplayer, Historical, Great Soundtrack, Violent, Female Protagonist, Hand-drawn, Choose Your Own Adventure, RPG, 2D White Day: A Labyrinth Named School (2017) TAGS: Horror, Adventure, Action, Indie, Survival Horror, First-Person, Puzzle, Psychological Horror, Singleplayer, Atmospheric, Nudity, Anime, Dating Sim, Sexual Content, Multiple Endings, Female Protagonist, Mature, Remake, Multiplayer Strategic Command: World War I (2019) TAGS: Strategy, World War I, Wargame, Military, Turn-Based Strategy Catizens - Game & Soundtrack Bundle (2022) TAGS: Early Access, Colony Sim, City Builder, Building, Sandbox, Strategy, Survival, Simulation, Crafting, Farming Sim, Management, Base Building, Character Customization, Life Sim, Cats, Cute, 3D, Family Friendly, Fishing, Agriculture Catizens - Game & Soundtrack Bundle.txt Edna & Harvey - The Breakout - Anniversary Edition.txt Ken Follett's The Pillars of the Earth.txt Silence.txt Strategic Command - World War I.txt Syberia.txt White Day - A Labyrinth Named School.txt

NB! Alle kodene er nå brukt. Gir bort 4 nye Steam-spill: DOOM 64 (1997/2020) TAGS: Action, FPS, Classic, 1990's, Retro, Gore, Shooter, First-Person, Violent, Cult Classic, Singleplayer, Horror, Fast-Paced, Demons, Sci-fi, Boomer Shooter, Atmospheric, Pixel Graphics, Great Soundtrack, Old School Hue (2016) TAGS: Indie, Puzzle, Adventure, Platformer, Puzzle Platformer, Great Soundtrack, Colorful, 2D, Narration, Singleplayer, Side Scroller, Metroidvania, Casual, Story Rich, 2D Platformer The Sexy Brutale (2017) TAGS: Puzzle, Adventure, Mystery, Indie, Time Manipulation, Detective, Time Travel, Great Soundtrack, Story Rich, Singleplayer, Sexual Content, Stealth, Atmospheric, Point & Click, Mature, Dark, Isometric, NSFW Lacuna – A Sci-Fi Noir Adventure (2021) TAGS: Detective, Pixel Graphics, Noir, Interactive Fiction, Multiple Endings, Cyberpunk, Crime, Conversation, Sci-fi, Choices Matter, Narration, Text-Based, Adventure, 2D, Thriller, Linear, Drama, Futuristic, Investigation, Story Rich DOOM 64.txt Hue.txt Lacuna – A Sci-Fi Noir Adventure.txt The Sexy Brutale.txt

NB! KODENE ER NÅ BRUKT! Gir bort 3 Leisure Suit Larry spill (Steam): Leisure Suit Larry - Magna Cum Laude Uncut and Uncensored (2017) Tags: Sexual Content, Nudity, Adventure, Mature, Comedy, Singleplayer, Point & Click, NSFW, Funny Leisure Suit Larry - Wet Dreams Don't Dry (2018) Tags: Adventure, Comedy, Point & Click, Sexual Content, Puzzle, Retro, 2D, Cartoony, Story Rich, Singleplayer, Sequel, LGBTQ+, Nudity, Colorful, Mature, Casual, Indie, NSFW, Classic, Great Soundtrack Leisure Suit Larry - Wet Dreams Dry Twice (2020) Tags: Point & Click, Adventure, Sexual Content, Comedy, Puzzle, 2D, Nudity, Retro, Story Rich, Cartoon, Cartoony, LGBTQ+, Romance, Atmospheric, Singleplayer, Mature, Linear, Casual, Funny, Old School Leisure Suit Larry - Magna Cum Laude Uncut and Uncensored (2017).txt Leisure Suit Larry - Wet Dreams Don't Dry (2018).txt Leisure Suit Larry - Wet Dreams Dry Twice (2020).txt

Gir bort følgende Steam spill: GRIP: Combat Racing Tags: Racing, Action, Indie, Automobile Sim, Futuristic, Combat Racing, Multiplayer, Fast-Paced, Split Screen, Local Multiplayer, Driving, Great Soundtrack, Arcade, Sci-fi, Vehicular Combat, Singleplayer, VR, Shooter, Combat, Classic Edit: Koden er brukt.

"Mystery Egg Bundle" som jeg kjøpte på FANATICAL, innholdt spill jeg hadde fra før av. Jeg gir derfor bort kodene til to Steam-spill: Train Valley 2 TAGS: Open World, Resource Management, Puzzle, Minimalist, Stylized, Family Friendly, Adventure, Time Management, Atmospheric, Tactical, Difficult, City Builder, Sandbox, Third Person, Strategy, Simulation, Casual, Indie, Cute, Management Edit: Train Valley 2 koden er brukt! Alwa's Legacy TAGS: Metroidvania, 2D Platformer, Puzzle Platformer, Exploration, Platformer, Pixel Graphics, Action-Adventure, Female Protagonist, Indie, Retro, 2D, Fantasy, Cute, Magic, Adventure, Action, Singleplayer, Colorful, Soundtrack, Old School Edit: Alwa's Lewgacy koden er brukt! God påske!

Jeg fikk ikke til søk på to søkekriterier, så istedenfor slo jeg sammen kolonnene "Valuta" og "Dato" til en hjelpekolonne "Valua-Dato". Så her er et løsningsforslag med en ekstra hjelpekolonne i ordre- og oppslagstabellen, samt bruk av VLOOKUP-funksjonen. Programvare: Calc, LibreOffice_24.2.1_Win_x86-64.msi Inndata: kolonnenavn med grønn bakgrunnsfarge. Utdata: kolonnenavn med gulorange bakgrunnsfarge. Formler i ordretabellen: D4 =CONCAT(A4; " "; B4) E4 =VLOOKUP($D4;$I$4:$L$100;4;1) F4 =ROUND(C4/E4;2) Formler i oppslagstabellen: I4 =CONCAT(J4;" ";K4) Kommentar til D4 og I4: Ved å slå sammen valuta og dato behøver man bare et søkekriterie. Tallverdien for dato er antall dager siden dag 0 (= 30. des. 1899, default). Kommentar til kolonne "I": NB! Kolonne "I", Valuta-Dato", i oppslagstabellen må være stigende sortert når man bruker "approximate match", dvs. siste parameter i VLOOKUP lik 1. ordreverdi.ods

Her er ei alternativ løsning ved hjelp av oppslagstabell og VLOOKUP()-funksjonen. Programvare: Calc, LibreOffice_24.2.1_Win_x86-64.msi Bruk: Skriv inn ID-verdier i pakkelistetabellen. Resten av cellene fylles ut automatisk, og totalvekten beregnes. Vekt-kolonna i oppslagstabellen er bare "tulletall" mellom 0 og 1. Formler i pakkelistetabellen: D1 =SUM(D4:D100) B4:B100 =IF($A4="";"";VLOOKUP($A4;$G$4:$J$100;2;0)) C4:C100 =IF($A4="";"";VLOOKUP($A4;$G$4:$J$100;3;0)) D4:D100 =IF($A4="";"";VLOOKUP($A4;$G$4:$J$100;4;0)) IF(...) benyttes for erstatte #N/A med tomme strenger "" der ID-kolonna mangler verdier. VLOOKUP, Type=0, betyr eksakt søk. Med andre ord, kun ID-verdier i oppslagstabellen er gyldige. Ved ugyldige verdier spytter formlene ut #N/A. pakkeliste_v2.ods

Nytt løsningsforslag, som også denne gang ikke er i Excel, men det nærmer seg ... :-) - Programvare: Calc, LibreOffice_24.2.1_Win_x86-64.msi - LibreOffice Extension: Decroise v.1.8.5 (fra 2009/2010 !!!) Lastet den ned fra LibreOffice Calc: Tools > Extensions... > lenken "Get more extensions online..." > Søk: decroise Resultattabellen mangler kolonneoverskrifter, så de må legges inn manuelt (gulorange bakgrunnfarge) Kolonne "Verdi" i resultattabellen kan nå filtreres, eller du kan laste resultattabellen inn i en database, og jobbe videre med den der. Den følgende skjermdumpen viser at "decroise" også håndterer doble rad- og kolonnenavn.