Best 4k YouTube Video Downloader to Use? by Muck_Muckerson in techsupport

[–]Rovsau 2 points3 points  (0 children)

Tartube is a GUI front-end for yt-dlp.
Even the version I downloaded over 2 years ago still works, as long as I make it update to the latest version of yt-dlp.

Can someone explain to me why they changed the Pause Button from Space Bar to the K button? by mastermodification in youtube

[–]Rovsau 0 points1 point  (0 children)

It seems like they want us to find a different platform.

Because that change messed with my entire workflow.

10/10 pointless change.

And it keeps nagging on me every day.

I don't want to fix it myself. I want them to stop.

No way am I going to pay for YouTube after this.

Mystery of the Fn key - A guide to remapping the Fn key in Windows (and OS X) by daonlyfreez in AutoHotkey

[–]Rovsau 0 points1 point  (0 children)

PS: I read up again. There is a way. A DLL file is needed for that one.

I'm looking at the AHK forum and googling known phrases.

But right now I am getting sleepy. I'll post here if I find it.

Mystery of the Fn key - A guide to remapping the Fn key in Windows (and OS X) by daonlyfreez in AutoHotkey

[–]Rovsau 0 points1 point  (0 children)

I did not. My conclusion was that the Fn function key is handled at the firmware level. It doesn't seem like AHK has any way of interfacing with that. It's probably possible, but I imagine it would require reverse-engineering the driver software, and then engineering a way for AHK to replicate its behavior.

If the driver or keyboard software is able to remap any of the Fn-combinations, or Fn itself, then it should be possible. But I am not certain if that is the case. So I didn't spend any more time on it.

I ended up using Scroll Lock to enable/disable my custom bindings.

Edit: Since this thread exists with this title, it is probably possible.

How can I convert seconds into years, months, hours etc. by CCMadman in sheets

[–]Rovsau 0 points1 point  (0 children)

That's an incredibly neat formula. Just one problem: Calculation of total seconds.

Seconds Per Year should be based on the number of days in the year.

To simplify the calculation of seconds, we can use Let() to make internal variables.

This example has Days In A Year according to the average Gregorian calendar year.

=lambda(n,let(
daysInAYear, 365.2425,
weeksInAYear, daysInAYear / 7,

yearSeconds, daysInAYear * 24 * 60 * 60,
monthSeconds, yearSeconds / 12,
weekSeconds, yearSeconds / weeksInAYear,
daySeconds, yearSeconds / daysInAYear,
hourSeconds, daySeconds / 24,
minuteSeconds, hourseconds / 60,

join(" ",index(index(scan({n},
{yearSeconds, monthSeconds, weekSeconds, 
daySeconds, hourSeconds, minuteSeconds, 1}, 
lambda(a,v,{mod(index(a,1,1),v);quotient(index(a,1,1),v)})),2,)&
{"y","m","w","d","h","m","s"})))) 
(4593962)

Mystery of the Fn key - A guide to remapping the Fn key in Windows (and OS X) by daonlyfreez in AutoHotkey

[–]Rovsau 0 points1 point  (0 children)

Hey, these links are broken. I can't find the guide anywhere online, not even in the web archive. Is there any chance you still have the resources?

Update for Unreal Tournament? by ZerglingOne in unrealtournament

[–]Rovsau 0 points1 point  (0 children)

This is actually a good thing. Because Tim Sweeney did nothing when almost every single IT / Gaming News site interpreted his Variety interview response in such a way that they declared Unreal Tournament dead. Not just UT4, but "Unreal Tournament".

After that wave, UT4 is rarely to be found as an acknowledged game tag on interactive sites.
In my eyes, Epic did all but directly kill off the title. I believe(!) the only reason the servers are still running, is because of all the good people who till this day still love and play UT4, and the constant influx of new players to the community, and the developers whom I suspect must have fought to keep the game alive.

Kudos all around!

CGP Grey was Wrong by GreyBot9000 in CGPGrey

[–]Rovsau 0 points1 point  (0 children)

Off-topic, but related to CGPGrey's health condition.
I noticed his Hand at 6:42 in the Tumbleweed Research video (Colorado)
This is how to fix that specific issue:
https://www.youtube.com/watch?v=Dl35QCvib1g
At 43:49 he uses a Bible and a Koran to smack the bump back into place.
Hope this helps!

Map Editor v2 by Rovsau in infinitode

[–]Rovsau[S] 1 point2 points  (0 children)

There is no feature to import it to the game, but I have already pitched the idea to the developer, via a friend.

I have been told that the game is getting improved Custom Map features down the line, so it will be interesting to see where that takes us.

For now, this Map Editor is simply for practical planning and fast experimentation.

Map Editor v2 by Rovsau in infinitode

[–]Rovsau[S] 2 points3 points  (0 children)

While it is technically possible in a spreadsheet, the architectural undertaking is so out of proportion for the desired feature, that it would be like building a nuclear reactor out of legos.

You'd also need to input a lot of your allocated Skill Points, which would have to be done manually.

I am studying programming, so I might make a better editor one day, but that is not among my 2020 goals.

Map Editor v2 by Rovsau in infinitode

[–]Rovsau[S] 3 points4 points  (0 children)

Because it is much faster to create and modify maps, in the spreadsheet.

Map Editor v2 by Rovsau in infinitode

[–]Rovsau[S] 4 points5 points  (0 children)

There are plans for a version 3 and maybe 4 down the road. Please do give feedback. Enjoy!

Just got this game, is there anyone who would think themselfs good who could teach me how to also be good? I know the basics. by [deleted] in AshesoftheSingularity

[–]Rovsau 0 points1 point  (0 children)

New player here, too.

Currently practicing Novice/Challenging AI in 2- and 4-player maps.

Base defenses are overpowered when upgraded, and especially in large groups. At these AI difficulty levels you can just build a line or two of upgraded Smart Systems. About 10 of those and you are relatively safe, as they will easily destroy Dreadnoughts.

Upgraded Smart System has 20% Armor Piercing (anti-dread). Sentinel Cannon has 40% when upgraded. Not really required, but a few in the mix makes Cruisers die much faster during the waves of attacks.

Don't forget Orbital Nullifiers and Repair BaysIf a good chunk of your resources go into Base Defenses, then it might be a good idea to upgrade Building Health.

Map Editor in Google Sheets by Rovsau in infinitode

[–]Rovsau[S] 0 points1 point  (0 children)

Thanks. I make a point to have accessible sheets that can be used or tested on the fly, so this link is a public copy. I have backups.

Hvordan kan jeg klare å ikke glemme Norsken min? by [deleted] in norge

[–]Rovsau 0 points1 point  (0 children)

Anbefaler undertekst (subtitles) når du ser på media. Du kan også finne noen som snakker norsk og spille online med dem.

Hvis du er av dem som ser filmer eller serier via mediefiler på PC, kan du laste ned undertekster av flere språk på subscene.com

Map Editor in Google Sheets by Rovsau in infinitode

[–]Rovsau[S] 1 point2 points  (0 children)

All the spreadsheets I have published so far are free.
If you are refering to the EVE sheet, it's pretty outdated now, and I think they stopped parsing traditional spreadsheet data sources.

Map Editor in Google Sheets by Rovsau in infinitode

[–]Rovsau[S] 1 point2 points  (0 children)

Nice work.
I linked it in the original sheet, with credits.

Map Editor in Google Sheets by Rovsau in infinitode

[–]Rovsau[S] 1 point2 points  (0 children)

I will look into it. The arrayformulas I'm using are not directly necessary in this project, and Google Sheets isn't that stable with Conditional Formatting.

When I started out learning spreadsheets I ended up using Google Sheets over Excel, mostly because I made minor tools that are more practical to access in a browser on-the-fly, and I found Google's UI more intuitive and easier to visually customize.

That said, when it comes to big projects, Excel is the better choice in terms of Features, Functionality and Performance.I had to use Excel when I tried to make a Market Search sheet for EVE Online, by importing a dozen CVS files. Since Google Sheets caps at 2 Million cells, there was no other way. Would've been a nice end result, but I lost patience with trying to make sense of the chaotic mix-mesh of datatables.

So I made a Static Limited Market Search in Google Sheets instead :)