Soluții pentru problemele tale IT
Ce este Superagent?
Superagent este o extensie pentru browser care acceptă automat cookie-urile conform preferințelor tale, astfel încât nu mai trebuie să dai click pe “Accept all”, “Reject all” sau “Configure” de fiecare dată când intri pe un site.
Daca mouse-ul, tastatura sau majoritatea tipurilor de periferice cu butoane incep sa prezinte disfunctionalitati (precum dublu click la o singura apasare), putem utiliza aplicatii precum autohotkey pentru a inlatura defectiunile partial sau complet.
[mai mult...]Daca avem nevoie de setarea unei rezolutii cu anumiti parametri (sau frecvente foarte specifice) si vrem sa ne asiguram ca acestea sunt aplicate, nu ne putem baza intotdeauna pe valorile raportate de windows sau de driverul video. De asemenea, acestea de obicei nu furnizeaza detalii precise despre parametrii rezolutiei actuale.
[mai mult...]An emulator is a piece of software that replicates a different piece of hardware or another piece of software. They’re especially common when it comes to gaming because you can use emulators to mimic older games consoles—like a Game Boy or even a Nintendo DS—on newer hardware.
For example, this is exactly how the Nintendo Switch Online service lets you play classic games from the NES, N64, and other consoles on a Nintendo Switch, by emulating those consoles. It’s also how you can play classic games like Pokémon, The Legend of Zelda, or Super Mario Bros on your smartphone.
Despite the fact that Nintendo has pressured some emulators, like Yuzu, into closure, it’s perfectly legal to download, install, and use emulators. When emulator developers get in trouble, it’s typically down to how they marketed their emulator or because they used directly copied the code of the original hardware instead of recreating it.
One downside to running emulators on smartphones, though, is that you’ll need to use touchscreen controls to play games. This isn’t too much of an issue with turn-based titles like Pokémon, where timing isn’t important. But you still might prefer to get a smartphone controller like the Backbone One or other smartphone controllers for a more tactile and comfortable experience.
There are tons of emulators available for Android devices, but my recommendation if you want to play classic titles is to download One Emulator from the Google Play Store. This lets you emulate Game Boy, Game Boy Advance, and Nintendo DS titles for free, which will cover you for all the best 2D and semi-3D Pokémon games from Red & Blue up to Black & White 2.
If you want more emulation options—and a better app experience—go with RetroArch instead. The only catch here is that you can’t always download it from the Play Store, depending on your Android version, so you may need to manually install the app from the RetroArch website instead.
Apple finally allowed emulators on the iPhone App Store in 2024 and there are now several options to choose from. However, if your aim is to play Pokémon or other classic Nintendo consoles, I recommend Delta.
Delta is a clean, polished, and simple-to-use emulator that focuses on Nintendo consoles, combining emulators for NES, SNES, N64, Game Boy, Game Boy Advance, and Nintendo DS into one sleek package. It’s got everything you need to replay all the best Pokémon titles from Red & Blue up to Black & White 2.
If you want an emulator with even more options, then definitely check out RetroArch instead. This still includes all the Nintendo consoles listed above, but combines them with a range of other platforms from Atari to Commodore to PlayStation and more.
Emulators cover the hardware we’re aiming to replicate, like the Game Boy or Nintendo DS handheld consoles, but we still need some Pokémon games to run in those emulators. That’s where ROMs come in: these are digital game files with the code from the original cartridge or disc in them.
The issue with ROMs is that they aren’t always legal in the way that emulators are. It’s definitely illegal to download or distribute ROMs for games you don’t own. However, creating or downloading ROMs for games you already own falls into a gray area, as some claim it may be protected by fair use as a form of archival. Nevertheless, Nintendo takes a firm stance against even these use cases of ROMs.
With all that said, you’ll need to get your hands on some ROM files for whatever Pokémon games you already own that you want to play in your smartphone emulator.
Once you’ve gotten hold of some ROMs, add them to the file manager on your iPhone or Android. I create a dedicated ROMs folder and put all the files in here.
Finally, open the settings for your emulator of choice and look for an option to select a ROMs folder. Pick the folder with all your ROM files in it and hey presto, you should see all your games in the emulator library ready to boot up at your pleasure.
If you’ve played the classic Pokémon games a million times already, the novelty of playing them on your phone could wear off pretty quickly. Well, now that you’re emulating these games you can keep them fresh by downloading hacked ROMs to try out instead. There are all kinds of different Pokémon ROM hacks to experiment with, offering all new story lines, villain arcs, and quality of life improvements. If you really want to be the very best, you need to make sure you play ’em all.
[mai mult...]If you already know how to use the GROUPBY function, learning to use the PIVOTBY function will be straightforward. The difference is that where GROUPBY only groups variables into rows, PIVOTBY has an additional argument that lets you also group certain variables into columns.
The PIVOTBY function lets you input a total of 11 arguments. Although this sounds daunting, the benefit of having so many arguments is that you can tailor the result to align with what you want the data to show.
However, only the first four fields are required.
Required Fields
The required PIVOTBY fields are where you tell Excel which variables you want to be displayed in rows, which variables you want to be displayed in columns, where to find the values, and how you want to aggregate your data:
=PIVOTBY(a,b,c,d)
where
Although arguments a and b are required for PIVOTBY to produce the type of result it was created to produce, you can omit them to group data in rows or columns only.
To do this, in cell F1, type
=PIVOTBY(Sports_Viewers[Sport],Sports_Viewers[Year],Sports_Viewers[Viewers],SUM)
where
Instead of typing the table and column names in your formula (also known as structured references) manually, if you select the cells in the table using your mouse, Excel will input these for you.
Everything you need to know about Excel’s engine room.
To make the data even clearer, I have used conditional formatting to color any rows in the result where column F is not blank, column G is blank, and column F doesn’t contain the words “Grand Total.” Applying direct formatting to spilled arrays is not advised, as the formatting is attached to the cells, rather than the data. This means that if the data changes, the formatting won’t change with it.
Notice how sorting by total viewing figures places not only the sports in order according to their overall totals, but also the regional subcategories according to their subtotals.
Use the PERCENTOF Function to Simplify Percentage Calculations in Excel
Handle percentages like a pro!
Select extra rows beneath the result in case more data is added to the original table in the future.
Before we look at some examples of the AGGREGATE function in use, let’s see how it works. The AGGREGATE function has two syntaxes—one for references and one for arrays—though you don’t need to get yourself tied up in knots over which one you’re using, as Excel selects the relevant one depending on the arguments you input. You can see both syntaxes in use when I show you some examples soon.
The Reference Form Syntax
The syntax for the reference form of the AGGREGATE function is:
=AGGREGATE(a,b,c,d)
where
The Array Form Syntax
On the other hand, if you’re working with arrays, the syntax is:
=AGGREGATE(a,b,c,d)
where
Functions and Exclusions (Arguments a and b)
When entering arguments a and b in either syntax form above, you’ll have various options to choose from.
This table lists the numbers you can input to exclude certain values when creating your AGGREGATE formula (argument b):
| Number | What Is Ignored |
|---|---|
| 0 | Nested SUBTOTAL and AGGREGATE functions |
| 1 | Hidden rows, and nested SUBTOTAL and AGGREGATE functions |
| 2 | Errors, and nested SUBTOTAL and AGGREGATE functions |
| 3 | Hidden rows, error values, and nested SUBTOTAL and AGGREGATE functions |
| 4 | Nothing |
| 5 | Hidden rows only |
| 6 | Errors only |
| 7 | Hidden rows and errors |
Now, let’s look at some examples of how you can use the AGGREGATE function in real-world scenarios.
Example 1: Using AGGREGATE to ignore errors
This Excel spreadsheet contains a list of soccer players, the number of games they’ve played, the number of goals they’ve scored, and their game-per-goal ratios. Your aim is to work out the average game-per-goal ratio for all the players combined.
If you were to use the AVERAGE function alone by typing:
=AVERAGE(Player_Goals[Games per goal])
Instead, using the AGGREGATE function gives you the option to ignore these errors and return the average for the remaining data. To do this, in cell C2, you need to type:
=AGGREGATE(1,6,Player_Goals[Games per goal])
where
An alternative way to achieve the same outcome would be to use the IFERROR function in column D to replace any errors with a blank value.
Using the same spreadsheet, your next target is to calculate the total number of goals the team has scored.
Specifically, you want to display two totals. The first is the overall total when you combine the goals scored by all players, but the second is the total of only the players showing in the table after you apply filters.
To calculate the overall total, in cell C1, type:
=SUM(Player_Goals[Goals scored])
Now, even after you apply a filter to one of the columns, such as displaying only the players who have played 15 games or more, the SUM formula you just applied still includes the rows that are filtered out.
In cell C2, type:
=AGGREGATE(9,5,Player_Goals[Goals scored])
where
Now, notice that the result of this formula differs from the result of the SUM formula you used in cell C1, because it considers only the rows on display.
Example 3: Using AGGREGATE to Ignore Hidden Rows (Array)
Next, let’s say you wanted to list the two highest goal tallies for players who have played 20 games or fewer.
You could apply the filter first and then generate your formula, but for the purposes of this demonstration, let’s create the formula first.
In cell C1, type:
=AGGREGATE(14,5,Player_Goals[Goals scored],{1;2})
where
When you press Enter, notice that the result is a spilled array covering cells C1 and C2 because you told Excel to return the top two values.
Now, filter the Games Played column to include only those players who have played 20 games or fewer, and see that the result of the AGGREGATE formula you entered earlier changes to ignore the hidden rows.
[mai mult...]