Trending December 2023 # Slashgear Week In Review # Suggested January 2024 # Top 17 Popular

You are reading the article Slashgear Week In Review updated in December 2023 on the website We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested January 2024 Slashgear Week In Review

SlashGear Week in Review – Week 15 2010

Hello gang, and welcome to this week’s edition of the Week in Review. Tons of stuff happened last week, the iPad, and the new iPhone OS were some of the top news items for the week. Analysts claimed that 74% of iPad buyers were Mac owners and 66% had iPhones. I am not surprised by that at all.

Early in the week we reviewed the Hercules eCAFE EC-1000W netbook. In the end, the netbook looks different from the masses, but the price for performance is too high. The Lenovo C200 AIO with Ion 2 was unveiled this week along with the new IdeaPad S10-3s. The AIO has an 18.5-inch screen and includes a DVD drive and lots more.

ATI whipped out its FirePro V8800 graphics card mid-week. It is claimed to be the most powerful professional video card ever. OCZ introduced the new Z-Drive series SSDs this week that plugs into PCI-E slots. The PCI-E connectivity it said to remove throughput bottlenecks the SATA 3Gbps port has.

Onkyo debuted a new netbook this week called the MX1007A4 with a processor that is slow — the Atom Z515. However, the power-sipping rig promises 14.4 hours of battery life. The ugly and expensive Prive phone turned up mid-week. It’s a late 80’s style brick phone covered in real gold and diamonds costing as much as a house.

Amazon listed an intriguing 3D TV that needs no glasses to view and has a built-in Blu-ray player this week. The catch was there are no pics and the StreamTV maker is not a company we have heard of. The cool looking Archos 7 tablet cleared the FCC this week. That should me we see the thing on the market soon to fight the iPad.

The checks resulting from the settlement over the class action suit for iPod nano first gen owners. The checks were for $37.50.

Dish unveiled the coolest DVR in its line called the VIP 922. The DVR has Slingbox tech inside and has a 1TB HDD. That long awaited Eee Keyboard got its own video promo late in the week. We still don’t know when the thing will hit store shelves.

An Apple patent turned up this week outlining NFC transaction tech for the iPhone. The patent shows how the iPhone could be used to pay for things like a credit card. Super Talent unveiled a new line of dirt cheap SSDs this week that don’t offer tons of performance, but only cost $65. Capacities range from 8GB to 64GB.

Creative launched new ZEN PMPs this week including the X-Fi Style, Style 100, and Style 300 PMPs. The line is very colorful and the X-Fi version has a 2.4-inch TFT screen. The big news of the week was the iPhone 4.0 OS event. You can glean most of the details of the new OS by checking out our iPhone OS 4.0 wrap up. Thanks for reading!

You're reading Slashgear Week In Review

Slashgear Cyber Monday Round Up

SlashGear Cyber Monday Round Up

We may receive a commission on purchases made from links.

Black Friday may traditionally be the big shopping blow-out after Thanksgiving, but Cyber Monday is the battery-powered upstart that wants to sate our electronics needs. After the cut, SlashGear’s Cyber Monday shopping guide, including Apple accessory discounts, cut-price MacBook, MacBook Pro and iMac deals, cheap HDTVs and more!

Apple’s main discounts from Friday have expired, but the company is offering savings on various accessories and peripherals in its US store today. That includes $20 off Beats by Dr. Dre Solo HD headphones and $30 off an M-Audio GarageBand keyboard. If you actually want Apple hardware you’ll need to head to resellers; MacConnection is offering up to $240 off MacBook Pro notebooks and up to $180 off the iMac.

Amazon is more ambitious, with Cyber Monday deals across most of its store categories. The Roku XD is 15-percent off, and there’s 35-percent off Sanyo’s VPC-GH4 1080p camcorder. If you’re after a standalone GPS unit then there are plenty to choose from, including 70-percent off Garmin’s nuvi 265, bringing it under $100. Amazon will also have various deals going live through the day, including a sub-$300 third-gen iPod touch.

Best Buy also has some serious discounts, with $400 off a 60-inch Mitsubishi 1080p DLP HDTV bringing it under $600. If you’d rather a massive LCD, there’s Sharp’s 60-inch AQUOS LC60E78UN with $400 off, bringing it to $1,299.99. Meanwhile there’s a half-price $99.99 Kodak ESP 7250 wireless all-in-one printer.Walmart is running a whole Cyber Week special, with a $69 14-megapixel Kodak EasyShare C183 on offer, together with iPod nano bundles from $138 (Apple charge $149 for the nano alone). If you’d rather go with Microsoft, Walmart is offering a 32GB Zune HD with the Premium Car Pack thrown in for $188.Newegg’s Cyber Monday deals have been running as part of their Black Friday promotions, but there’s still $170 off a CyberpowerPC Gamer Xtreme 1077 Core i5 desktop. Oh, and T-Mobile will still give you a free second HTC HD7 if you buy one from them.

There are plenty of deals if you’re looking for a new case for your iPod, iPhone or other PMP/smartphone. XGear are offering 60-percent off iPhone 4, 3GS and 3G cases, along with iPod touch 4G cases, with coupon code CM2910.

If it’s laptops or desktops you’re after, Dealzon have scouted out a solid selection:

14.5″ HP Envy 14 Beats Core i7 for $1,049.99. [$150 off Black Friday]

14.1″ Lenovo ThinkPad T410 Core i7 for $970.50. [$129 off Black Friday].

12.1″ Lenovo ThinkPad X201 Core i7 Laptop for $1,031.80. [$144 off Black Friday].

Dell Zino HD Mini Desktop w/ Blu-ray for $299.99. [$70 off Black Friday].

13.1″ Sony Z Series Core i5, 256GB SSD for $1,899.99. [$350 off last week].

10″ ASUS Eee PC 1001PX-EU17-BK Netbook for $199.99 at Newegg. [$42 off next lowest].

We’ll be keeping the shopping guide updated throughout the day as new deals pop up, so let us know if you’ve seen anything unmissable! Happy shopping…

How To Group By Week In Pivot Table?

A pivot table is an essential tool present in MS Excel that rapidly analyzes and summarizes large voluminous of data in a table format. Grouping data by week usually means that the provided data is categorized by using week. This article covers three examples, first two examples are using the same strategy with a day or period difference of a week. But, in the last example, use a helper column to perform the same task, this helper column can be manipulated with the help of provided column.

Example 1: To group the week in the pivot table by using 7 day or single period week Step 1

To understand the process of grouping provided a date by a week, using the 7-day concept. Consider below given pivot table −

Step 2 Step 3

This will open the “Grouping” dialog box. This dialog box contains many fields. Under the “Auto” category user can set the starting date under the “Starting at” input label, and secondly under the end date user can set the end data under the “Ending at” option. Under the “by” option list user can set the option according to the requirement.

Step 4 Step 5

This will display the given data as a 1-week range. Consider the results provided in the below snapshot −

Example 2: To group the week in pivot table by using the 4-period week concept Step 1 Step 2

Select the “Group” option. As shown below −

Step 3

This will open the “Grouping” dialog box, and then select the Starting at, and Ending at date accordingly. In the by section select “Days”. Set the Number of days as “28”, and press “OK”.

Step 4

The above step will provide a consolidated data of 4 weeks.

Example 3: To group the week in the pivot table by using the helper column Step 1 Step 2

Go to the E3 cell, and type the formula

“=YEAR(C3)&" "&TEXT(WEEKNUM(C3,2),"00")” and press “Enter” key. Explanation

YEAR(C3) returns the year value of the date in cell C3.

“&” is used for concatenation.

“-” is a string literal that will be included in the concatenated text.

TEXT(WEEKNUM(C3,2),”00″) returns the week number of the date in cell C3, with the second argument specifying that the week starts on Monday. The “00” format code ensures that the week number is displayed with two digits.

Put all these together with the “&” concatenation operator. Getting a text string that represents the year and week number of the date in cell C3 in the format of “YYYY-WW”, where YYYY is the four-digit year value and WW is the two-digit week number.

Step 3

The results are displayed below −

Step 4 Step 5

After that go to the “Insert” tab, and then select the option “Tables” option, select the option “Pivot Table”, then select “From Table/Range”.

Step 6 Step 7

To display the required pivot table on the new worksheet. Select the below-specified values, “date, sales, and week” entries. After that in the rows, section add the week and date. In the values section, add “Sum of sales”, and other required parameters as specified below −

Step 8

Consider the final obtained pivot table structure −


This article briefs users on three ways to group the week’s data by using the pivot table in Excel. Two examples allow the user to group the data, while the third example allows the user to use the helper method to process the same data.

The Week In Drones: Laser Warfare, Paper Planes, And More

Sheboygan County from the air

Here’s a roundup of the week’s top drone news: highlights from the military, commercial, non-profit, and recreational applications of unmanned aircraft.

Police Drones Prepare For The Cup

In preparation for the World Cup in Rio de Janeiro, Brazilian police used a drone to hunt a notorious gang kingpin. The drone used was an Israeli-made Heron, and key to finding the kingpin was an onboard infrared camera. According to Brazilian officials, the drone allowed for a safer capture than would otherwise have been possible in the hostile favelas, which Brazilian police attempted to pacify before the eyes of the world turned to Rio.

Heron Drone

Critiquing the Law

Writing in MIT newspaper The Tech, law professor Henry H. Perritt Jr. and helicopter pilot Eliot O. Sprague argue that the Federal Aviation Administration is going about regulating drones in the wrong way. Perritt and Sprague says that this is most clear in the agency’s treatment of small drones, the kind hobbyists and consumers can buy for a few hundred or thousand dollars. They write:

The crux of their argument is this: Rather than making anyone who buys a small drone comply with elaborate and complicated regulations, the compliance should instead be built in at the point of manufacture.

Lasers To Fight Drones

In the future, the United States might send military forces against a foe that uses flying robots. In this hypothetical future war, what’s the best way to shoot down enemy drones? Lasers, of course! Freaking. Lasers. The project, known as Ground Based Air Defense (GBAD) comes from the Office of Naval Research, and it’s been in the works for quite some time. The reason for using lasers is mundane: Lasers are cheaper than other ways to shoot things out of the sky, so they’re a perfect fit for the relatively inexpensive drones they’ll be fighting. On Wednesday, the Navy announced it had finished awarding contracts to develop this laser, which puts us one step closer to a war where Marines use lasers against chúng tôi future, man.

Concept Art For Anti-Drone Laser

This is also the cover of a prog album.

Assisting Firefighters

A volunteer firefighter team in Sheboygan, Wis., formed a volunteer drone squad. The “Sheboygan County Autonomous Search & Rescue Team” got its start after a firefighter acquired a cheap commercial quadcopter that can be piloted by smartphone. The drone carries a camera underneath, and with a flight time of about 20 minutes, it can give rescue workers an overhead view of a situation before they have to go in. Thermal imaging here is especially helpful, as infrared cameras see where the fire is before human eyes can.

Turn A Paper Airplane Into A Drone

With an app, a signal receiver and motor, and a piece of paper, it’s possible for anyone to make a simple drone in seconds. Thanks to a kit made by PowerUp3.0, the drone steers with a rudder behind the propeller. It’s one of the purest “just a toy” drones out there, and it looks like an utter delight to fly. Watch one get made and flown below:

This Week In Games: Civilization Reproduced In Excel, Control Teases An Alan Wake Expansion

I finished Control two weeks ago and now all I can think about is more Control. Good news on that front, as Remedy announced two expansions this week—including one themed around Alan Wake? It certainly looks that way.

This is gaming news for September 9 to 13.

Free frights

For the first time ever, Epic’s free game of the week is one I haven’t played. Conarium, released in 2023, is “a chilling Lovecraftian game” and the screenshots look neat, though it holds a middling score on Steam. Still, it’s free right? Nothing to lose by picking it up.

And stay tuned next week for what I assume is Arkham Asylum or one of its sequels. Epic’s teaser only says “???” at the moment, though the accompanying picture of Batman is clue enough.

On a more limited timescale, Humble is giving away copies of Endless Space and its expansion until around mid-day Saturday. It’s nowhere near as good as its sequel, but if you’re looking for a bit of space-based 4X action I’d still recommend grabbing the collection.


Oh and hey, speaking of Endless Space 2, there’s a new expansion. Dubbed Awakening, it adds a new Nakalim faction. The Nakalim are a crumbling empire, and thus begin the game with a significant head start on the tech tree—but they’re terrible at new research, and must hunt down “Relics” throughout the galaxy to stimulate new discoveries. Nifty in theory, though Steam reviews seem torn.

Project REsistance


Then there’s Shenmue III, which is somehow only a few months off from release. This three-minute trailer out of TGS shows off the world one sweeping shot at a time, and…well, some of it looks nice. I particularly like the nighttime shots, though I remain skeptical of this whole endeavor. We’ll find out November 19 whether or not it’s been worth the wait, I guess.

Shocking SHODAN

Control, continued

Watching credits roll on Control, all I could think was “I hope there’s more, and soon.” Lucky for me, there is. Remedy put out a road map this week announcing a few forthcoming updates. By the end of this year we’ll have a Photo Mode and “Expeditions,” a free update that adds a new area and some buddy-cop shenanigans with Security Chief Arish.


Watch The Witcher

A quick note here, but Netflix tweeted-and-deleted a post this week saying that its adaptation of The Witcher is arriving in 90-ish days, putting it around mid-December. I know you’re all feverishly anticipating Henry Cavill’s hot wig action. (Via PC Gamer / Redanian Intelligence)

Surge protection

I never finished The Surge but the videos for its upcoming sequel are making me want to revisit it. I mean, sci-fi Dark Souls sounds pretty great—though I remember the original being pretty janky, in the usual “It’s almost-but-not-quite a Souls game” way. There’s about a week and a half until The Surge 2 hits though, so you’d better hurry if you want to get caught up.

Night at the museum

Bossa’s mostly known for making goofy games like Surgeon Simulator and I Am Bread, but upcoming thriller The Bradwell Conspiracy looks anything but. Apparently there’s some sort of mystery in and around and perhaps under…Stonehenge? No idea what the hell it could be, but I’m a sucker for these sorts of first-person exploration games.

Dauntless 1.0 Redux

End of the world (as we know it)

The battle royale trend has hit some unlikely targets in the last year or two, but Civilization VI has to rank up near the top. This week Firaxis debuted a new (and free) Civilization VI mode, “Red Death,” which brings the ol’ shrinking-circle-of-death to turn-based strategy. No, really. Everyone gets a civilian and a handful of military units, and the last one alive wins. Apparently it started as an April Fools joke and now it’s an actual mode, which seems to be happening a lot these days.

Early Civilization

Kentucky Fried Gamers

Apps Of The Week: Disneyland, Pac

It is the weekend again. But, not everyone will have the joy of sitting on the porch with friends, cracking a cold one and a joke as the hours slowly tick by. Some of us will be pulling weeds in the hot sun, or driving hundreds of miles to visit family, or even working.

No matter what you are doing this weekend, try to make time for relaxing. If you are looking for some new apps and games, check out our list below. You might find just what you need to make your weekend perfect.

If you are the type of gamer that, somewhere in your past (or possibly present), sat around a table with a group of friends and played such games as Dungeons and Dragons, this is the kind of game you will enjoy. It harkens back to a real tabletop experience, complete with character sheets, maps, and more. There is even a simulated set of gamer’s dice for you to roll. As you explore a handcrafted dungeon, you will find loot cards that can give you special items, stronger armor, and even better weapons. Using your newly collected swag, you will be ready to fight off the strange beings you will encounter when entering an unknown room. This game is available for $3.99.

I’ve been waiting a long time for this app to return to the App Store. There has been an official Disney World app for a while now, but the West Coast theme park hasn’t had one in years. With this official app, users can log into their Disney account to scan tickets or annual passes, check park hours and ride closures, and check current wait times for rides throughout the park. You can also find out where your favorite characters will be set up for meeting, search the map for restaurants, and even find out where the closest bathroom is. This app is available for free.

Just when you thought you knew everything about the pellet-munching half circle, a new game comes out that throws it all out of whack. In this endless arcade maze, players control Pac-Man as he chomps though neon mazes that twist and turn. In addition to being chased by ghosts, you are followed by the ever-present, infamous 256 Glitch as it tries to tear your coding apart. There are also special power ups (beyond the power pellets that let you eat ghosts) like bombs, lasers, and stealth mode. While the basic rules of Pac-Man still apply, this is one arcade classic that will really push your limits. This game is available for free.

Maybe you are the type of person that just can’t stand classic games like Pac-Man getting a lot of changes. Instead of trying to convince yourself that the game is terrible, even though you haven’t played it, try a whole new game that has a pellet-munching traveler that eats his way through mazes. In this game, players are constantly being chased by a red foe. However, the only way to get him off your back is to switch the bridge at just the right moment, so he is stuck on the other side of the maze. Hopefully, it will be a side you’ve already gobbled all of the pellets on. This game is available for free.

LinkedIn Lookup

Having hundreds of work related contacts for LinkedIn doesn’t really do you any good if it takes forever to find them. With this new contacts app from the official business-networking site, you can get the information you need about the people that will be in your next meeting. You can also look up contacts by skill, title, and more. Of course, the app makes it possible for you to call, text, or email your contacts with one tap. This app is available for free.

Spiral Ride

If you loved Impossible Road and just can’t get enough of the bang-your-head-against-a-wall action, then you might want to take a moment to absorb this game. You don’t tilt to stay on track. However, you must tap the screen whenever the arrows approach in order to switch lanes and avoid being thrown off into the abyss. Along the way, you will collect cubes that add to your score. Don’t be mistaken. It is not going to be easy. You’ve been warned. This game is available for free.

More apps you should check out These apps have been updated

Update the detailed information about Slashgear Week In Review on the website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!