Saturday, April 13, 2013

Review: SimCity rebuilds the sandbox game

AppId is over the quota
AppId is over the quota

Building a city is hard work. Armchair urban planners have known this for nigh on three decades, ever since 1989’s SimCity introduced us to a game world of zoning regulations and budget balancing. ­­

It’s been a long time, but SimCity has been reborn. Powering the experience is developer Maxis’ GlassBox engine, which attempts to dynamically simulate conditions in a city. You can track individual citizens as they shuffle about your city, filling residential areas as they move in and causing traffic jams as they attempt to commute to work. While much of the gameplay has been simplified (no more laying down power lines and water pipes), new complexity has been introduced through a focus on multiplayer cooperation and specialized cities.

The end result is a visually striking homage to a classic series that takes city building in bold new directions, but troubling business decisions and technical snafus ultimately hamper the game’s ability to eclipse its predecessors. Is the new SimCity worth your hard-earned simoleons? Let’s find out.

Cities in the new SimCity are decidedly smaller than previous entries in the series; the sprawling metropolises of yore have necessarily given way to a focus on careful planning and design, largely because of the GlassBox engine's hefty computational requirements. The new SimCity keeps the familiar Residential, Commercial, and Industrial zone trinity, but the classic approach of plopping down low-, medium- and high-density zones to balance your city’s development has given way to a more organic approach: buildings start small, and only grow when they have enough money, happy residents, and space. Roads are the lynchpin to a thriving city: power and water flows along your roadways, which are themselves available in low, medium, and high capacities, ultimately determining how large your zones can be.

Subtle guidelines like this edge-of-zone marker give you information about your city without being obtrusive.

The game’s simple, fluid tools belie an astonishing level of depth: you can lay down roads in traditional (boring) grids, or give the new curved roads a try and paint asphalt down at your leisure. These tools are crucial if you want to make the most out of your space, as building too tightly will result in zones that don’t have enough room to grow. As you lay down roads, helpful guidelines give visual cues as to how much space a particular zone will need to fully expand.

SimCity has always been a data-driven experience, but the bevy of graphs have largely been replaced with colorful bars that give you a quick idea of where problems lie.

I’ve always been a rather reactive city-planner, and that causes me problems in this game. Citizens want more places to shop? Toss down a few commercial zones. Low-income citizens need a place to work? Pile a few more factories into my pollution-riddled industrial quarter, home to hastily erected garbage dumps and sewage treatment plants. The resulting urban sprawl works about as well as Los Angeles does: skyscrapers grow and the wealth pours in, but traffic is a mess and I always find myself scrambling to address the congestion my lack of foresight has created.

Green is good: happy neighborhoods become dense, valuable real estate, and you can track your citizens' satisfaction with real-time color-coded maps.

Fortunately, no city is an island (even when they’re on an island). The focus on multiplayer plays a central role here, and it’s difficult for a single city survive on its own—if you’d like to see any variation, that is.

Here's an example of what I mean: Let’s say we’d like to create an industrial powerhouse. Factories need employees, so we’ll need plenty of residential zones with low-income citizens looking for a humble nine-to-five gig. But our factories will also need places to sell their wares—that means exporting goods to the new trade depots and ensuring there are plenty of commercial zones available. Factories also cause quite a bit of ground and air pollution that drives down land values (and make your citizens unhealthy), keeping wealthier business and residents at bay. We’ll mitigate that by ensuring there are plenty of schools and libraries to educate our populace: educated citizens can become skilled managers, resulting in high-tech factories that emit less pollution.

We’re almost done. Factories are fire hazards, so we’ll need comprehensive fire coverage. And we can’t all be mid-level managers, so we’ll need a stable supply of low-income residents. Even with high levels of education, low-income areas generate crime, which means having comprehensive police coverage.

Fossil fuel factories are fire traps, so make sure to keep your fire stations close.

All of these buildings require power, water, and—most importantly—lots of space, if they’re going to grow. A thriving city also needs a sensible road layout: larger roads are more expensive, but can ease congestion in larger cities—our police and fire departments can’t do their jobs if they’re stuck in traffic.

The prudent industrial city planner needs to cram plenty of city services (don’t forget public transportation for your low-income citizens!) into the same space as residential neighborhoods, commercial plazas, and industrial corridors. Add a few power plants and water towers to keep everything humming along, and our city will quickly be packed to the gills. And all of this only accounts for the bare essentials. There’s gold in them thar hills: we can strip mine parts of your city for resources like coal and oil, and use them to fuel power plants, trade on the global market for cash, or refine into advanced materials for use at advanced factories. Wealth is at our fingertips, but only if we can find enough space to fit everything in.

EA’s SimCity present a “convenient” solution: team up with someone else. Every region offers a number of cities to build in, and cities in a region form a cohesive unit. It’s still called SimCity, but SimOrganism is closer to the mark: each city serves as a kind of organ, and successful cities (and thus, regions) will share resources intelligently.

SimCity makes it easy to keep tabs on where your citizens are going and how they're getting there.

Sim citizens commute freely, looking for work, an education, or the occasional tourist trap in any other city in their regions. Our industrial city can attempt to cram as many residential zones as their polluted haven can reasonably support or simply offer ample public transportation by rail or municipal bus for a neighboring city’s cash-starved denizens.  That neighbor can take care of educating their citizenry (and ours), and offer plenty of commercial venues for our factories to ship their wares. Their police departments can volunteer officers to patrol our streets, and while we’ll want to keep our own fire department to keep things in check, it can never hurt to have a few ambulances sent our way to deal with sick Sims. We get the services we need without sacrificing space, and they get a decent chunk of change — sharing resources isn’t free, of course.

I love this new approach. SimCity has always been something of a sandbox, and while our digital playgrounds have gotten a bit smaller this time around the ability to create specialized cities and tag-team with friends and strangers adds a refreshing new level of complexity to a classic experience. And there’s always the option to keep things private, keeping an entire region to yourself and designing a region as you see fit.

But all of this is only neat if you can actually play the game.  I’ve done my fair share of griping about the woeful state of SimCity’s launch, and while things have admittedly improved over the last week, being able to access the game “pretty often” just isn’t good enough.

Lengthy server queues have kept many players from enjoying the new SimCity, which cannot be played offline.

Progress is saved on EA’s servers, so if your particular server is down you’ll lose access to the cities you’re working on—this includes losing progress if a server goes down in the middle of a game. The lack of save games makes sense from EA’s perspective: city and region progress is tracked on leaderboards, so you wouldn’t want folks cheating their way to the top. But it also means being unable to unleash disasters on your city for the occasional experiment (or giggles) or even sample different road layouts without spending loads of cash, much less unleash a disaster on your city just for the hell of it.

And now we’re back to that multiplayer-first focus, which will be the hardest hurdle for fans of the older games in the series to get over. The relatively small city sizes means you’ll need to design a city that thrives with a particular focus, and then building complementary cities alongside it. If you’re playing by yourself and have settled into a comfortable, profitable rhythm, things will get repetitive—fast. Playing with others naturally throws new wrenches into the works, as you attempt to goad others into accommodating your master plan or deal with mayors who aren’t very organized (like me).

The SimCity experience is also ultimately tied to EA’s whims. I’m not talking about the all-but guaranteed torrent of downloadable content we can expect to arrive in the coming months. No, it's all about the online-only experience: even once the troubled launch is behind us, the future of SimCity lies in however long EA is willing to support it. At some point in the future, SimCity will inevitably be shut down—and your cities and regions will disappear alongside it. While this is simply a fact of life in the brave new world of cloud gaming, SimCity has always been the sort of gift that keeps on giving—there are still legions of fans playing SimCity 3, SimCity 4 and even SimCity 2000.

SimCity has its share of problems, but it still scratches that itch to build bustling and bucolic little cities.

Is SimCity worth your time? It depends. I’m having a blast: the last week has not been without its share of woes, and the focus on playing with others coupled with server issues necessarily limits the thrill of carving a thriving metropolis out of digital soil. But there’s potential for a singular experience here, once you’ve found a solid circle of friends or strangers to work with. But it's out of reach until the server situation is sorted, and after a few necessary bug fixes. And it's gone once EA decides to kill the servers.

Bottom line: EA and Maxis haven’t rested on their laurels here. Their risky experiment in bringing a classic franchise into the future is bold, and fun. But if you can’t stomach the crippled single-player experience, and don’t want to leave so much of your entertainment power in a company’s hands, you’ll want to steer clear—or at least wait until it’s on sale. But don’t let the rough launch turn you off—there’s a lot to love in this game, and it’s worth taking for a spin.


View the original article here

Friday, April 12, 2013

Review: ModernMix runs modern UI apps in windows

AppId is over the quota
AppId is over the quota

Windows 8 is transforming into the desktop OS users thought it would be when they first heard about it, but it's not Microsoft doing the work: It's Stardock. The company's Start8 start menu replacement is best-of-breed, and they've hit the nail on the head again with ModernMix, a $5 program (with 30-day free trial) that lets you open Windows 8 modern UI apps as windows on the classic desktop.

If you didn't know better, you'd think these Windows 8 modern UI apps were designed to run in windows.

ModernMix is super-easy to use. Head to the Modern UI, open a modern UI app, press the F10 key, and the app moves to a window on the classic desktop. You can also choose to make this the standard behavior for programs launched from the Modern UI so you don't even have the press the key.

Right-click the icon in the upper left-hand corner, and along with the usual move, size, close, etc. options you'll find the option to create a shortcut to the app on the classic desktop. When you subsequently launch the program using this icon, it behaves as a classic windowed application. When you access the same app from within the modern UI, it behaves as it normally would. Best of both worlds.

However, you can change this behavior as well, having the icons launch the program full-screen. There's also an overlay menu in the top right corner of windowed Modern UI apps that lets you full-screen or window the application.

ModernMix lets you choose between windowed, maximized, and fullscreen modes.

There's really nothing more to ModernMix, but it reduces the number of times you have to traverse the two halves of Windows 8 (modern and classic), which is well worth the $5. Being able to run SkyDrive, Maps, Camera, and especially Solitaire in a window on the classic desktop is addictive (as well as more efficient) for desktop users. Now if Stardock would just figure out a way to use the modern UI as the actual desktop, we'd have something to celebrate.

Note: The Download button on the Product Information page will download the software to your system.

Jon L. Jacobi

Jon L. Jacobi has worked with computers since you flipped switches and punched cards to program them. He studied music at Julliard, and now he power mods his car for kicks.
More by Jon L. Jacobi


View the original article here

Get organized quickly: saved by project Pro for Office 365

Save As in Project ProSuppose it is 14:00 on Friday afternoon to a planning meeting for big spring marketing blitz left on which your company, Coho Winery, its hopes on international expansion rests. Just a moment before, the team was scrolling my fist on the table haphazardly by a long task list table when your boss suggested and explained that a first class project management solution would have until Monday morning.

Yikes! This is a large task.

Since this project is so important, it is important that the solution sturdy and safe, at the same time gain as much efficiency as possible, so that the team can more work done and you get not buried the pursuit of everything. But at the same time, a huge budget for this is cost and time is critical.

With Microsoft Project Pro for Office 365 , choose communication combined with SharePoint online and Lync Onlinesubscription, so that teams can easily in real time of the Coho and cooperation to joint team sites. With subscriptions, pay as you never go, worried about the establishment of IT systems and can stream to make the rich project desktop client to your work quickly and easily.

A quick visit to the project site confirms your intuition that per project for Office 365 for Coho is the right solution. Click the link to login and a few moments later the account is set and ready to go.

You breathe out "Wow", "That was easy!"

Soon you will find out, that the rest of the process for project management the Coho are up and running is as easy as it was to subscribe to the service. There to configure easy steps of your organization.

Import options for users with a mass spreadsheet upload, it really starts to look like you could get out of the Office before 17:00.

A convenient table template shows you where you fill in the blanks for your team.

... ...und download they have in SharePoint created accounts automatically.

A quick check confirmed that each team member have imported correctly.

Breeze through the next steps in about two minutes, simply noting the passwords for each account generated and selection of the appropriate licenses and permissions for each person. Now it's time to painstakingly put together, hammered the project plan in the meeting that only a half-hour before left.

As a rock star project manager, you know that the first step is to stream an installation of the project desktop client. This is easy with Pro project for Office 365-just click on the Download link from your Office-365-admin page and fly these bits to see!

Seconds after you click on the Internet Explorer download prompt run, is the project desktop client on your PC streaming and already can you really earn your salary. But wait! You're pleasantly surprised to see that... integrates great templates directly on the home screen, and there is even one for a marketing plan campaign!

You start the template, some of the tasks of the team adapt agreed project plan and fill in resource allocations.

It takes half an hour or so from your tradecraft apply, until a good on the v1 project plan feeling and decide, it is synchronized with the SharePoint team Web site. This is as simple as pressing the button Save and paste in the Web address in your browser.

The project integration with Office 365 account service keeps safe from any unauthorized release on your site - your website and protects against accidentally synchronizing with the wrong site!

You hit update on the Coho Winery SharePoint team site to see your work on the life in the cloud, and can't help but smile, as the page loaded is a robust cloud-based project plan ready for wide cooperation, work Division and access from virtually anywhere. Nice.

The clock is ticking on your Office wall, 17:00, as a triumphant send met on an email that your boss kümmern-not insured - you have everything under control.


View the original article here

Review: Automatically resize images on the fly with Robosizer

AppId is over the quota
AppId is over the quota

If you are in the habit of sending images by email, you will know what an absolute pain in the neck it is to go through the tedious process of resizing them to send. It takes up precious timethat  could be better spent using, looking at cute cat pictures on Reddit. You know, more important stuff.

Robosizer is a free software app that sits in your Windows tray, and detects when you are sending an image via one of its supported email programs. When it does it will automatically resize the image for you (leaving the original image intact), according to the pre-set sizes that you specified in the settings beforehand. Robosizer really is a “set-and-forget-it” type of program. Pretty soon, you’ll forget that it is even there (if you switch the notification balloons off).

When Robosizer detects that an image is being sent, it will resize it to the specifications you set, and you will receive a notification bubble telling you it is being done


Installation is a breeze, with no devious toolbars or other nasty software trying to sneak in. When the installation has been completed, however, you will be invited to enter a serial code. It looks as if Robosizer used to be a paid app, but it’s now free. So look in your installation folder, and you will see a text file with a free activation code. Just enter that and you’ll be good to go. The developer has assured me that this minor nuisance will be removed soon.

When you start it up, you will see a little robot face sitting in your Windows tray. Right-click that and choose the settings. It’s here that you need to set up your “profiles” – in other words, the settings for each program. A wide range are covered, (including Firefox, Gmail and Skype) so you are sure to find a few things there that you already use. At the time of writing, Internet Explorer 10 on Windows 8 is not supported, but the developer is working on fixing that.

Robosizer works with a wide range of popular services such as Gmail, Facebook, Chrome, Firefox, Opera, Outlook and many others..


To set up your profile, drop the menu down and choose one. If your program is not there (and Robosizer supports it), click “new”, type the name of the program, and a new profile will be set up for you. You will then see boxes for the “max image width” and “max image height”. You can enter either one or both, in pixels. You can also specify whether or not the height or width should be “enforced”. By that, it means that when resizing, do you want it to specifically focus on the width, the height, or neither? Then specify which file types will be resized (there’s a startling lack of support for GIF images). Rinse and repeat for other profiles. When they have all been completed, click “close” for Robosizer to go back to snoozing in the Windows tray, waiting for an image.

When it spots an image being attached to an email, Robosizer will spring into action, resizing the image and inserting it into your email message. You will get a notification balloon telling you it’s currently going on  and your original image stays in its original location with its size untouched. The resized version sits in Robosizer’s cache folder (the location of which you will find in the “program settings” tab of the Robosizer app). Bear in mind though that these resized images are deleted when you “exit the program or restart the computer”. So if you want to keep copies, do it right away.

I test a lot of stuff out for PC World and I mostly delete it all afterwards when the review is done. But Robosizer is staying put on my computer as it is extremely useful. No longer will I gnash my teeth in frustration when I realize that the enormous David Hasselhoff picture I want to send to someone is needs to be resized. Robosizer, my new friend, will take care of that for me. Thanks Robosizer. You’re my pal. But you won’t be my  BFF until you get along with GIF images.

Note: The Download button on the Product Information page takes you to the vendor's site, where you can download the latest version of the software.

Mark O'Neill

Expatriate Scotsman now living in Wurzburg, Germany, freelance writer, frustrated future bestselling author, obsessed bibliophile. Other interests include trying to understand The Architect in the Matrix movies, decrypting codes and ciphers, and trying to persuade my landlord and my wife to let me have a Highland Cow for a pet.
More by Mark O'Neill


View the original article here

Review: Catalog your DVD & Blu-ray movie collection with My Movies

AppId is over the quota
AppId is over the quota

Many of us have accrued a massive collection of DVDs and Blu-ray discs, but not everyone has gone to the trouble of cataloging what they have. But keeping a precise inventory has its advantages, and that is where the free and very capable My Movies more than ably fills the need.

First of all, if you only have a small collection, seeing what you have is easy enough. But if you have a huge collection of hundreds or even thousands of disks, it's very easy to lose the overview of your collection. You may start accidently buying duplicate disks.

Another thought: If you have a disaster such as a burglary, fire, or flood, you can lose your beloved collection.  Home insurance requires exact property lists if you want to make a claim. Again, a few disks makes this an easy task, but if you have hundreds, that's another kettle of fish.

You can add movies by inserting the disk into the hard drive, manual input, or by scanning the barcode in front of the webcam.

Even your own generosity can do you in. If you are in the habit of loaning disks to friends and colleagues, it can become easy to lose track of who has what, and for how long. Keeping a record will help you to recover disks from forgetful friends.

My Movies runs on multiple platforms and allows you to input the details of each DVD and Blu-ray that you own into the software. Entering a title can be done in a variety of ways: manual input; holding the barcode up to the webcam; and my personal favorite, entering the disk into the hard drive to watch as the software automatically detects it and enters the movie details for you.

Once you insert the title, My Movies will upload all of the relevant information for you, including the cover (if it chooses the wrong one, you can change it), plot, actors, production crew and information about the disk itself. You can also specify whether or not you are keeping it, selling it, trading it, or even if it is just on your wishlist.

Once you have updated the desktop software, you can connect to the My Movies server, and instantly update your own dedicated webpage showing your collection.

When the desktop software has all of your disks listed, you can then upload everything to your own free dedicated webspace on the My Movies server. I did this myself so you could look. The speed upon which everything is uploaded depends on how much you are sending over, but on the whole, it's quite a fast process.

What is stunning about My Movies is the breadth of systems that it is available for. There is a Windows 7 (Premium, Professional, and Ultimate) Media Center add-on that allows you to "play your titles, browse cast, play trailers and much more by using a remote control within your living room or home theatre". You can also run My Movies on Mac OS X (free for up to 50 titles or $15 for the unlimited Pro version), Windows Home Server, and iOS and Android (as similarly limited free apps and $5 for iPhone, $7 for iPad, $6 for Android from Google Play, and $4.50 from Amazon).

The only downside to the My Movies desktop software is that you can't rate your movies after you've watched them.  But this minor quibble aside, this is one fantastic piece of software for anyone serious about cataloguing their media collection.

Note: The Download button on the Product Information page takes you to the vendor's site, where you can download the latest version of the software.

Mark O'Neill

Expatriate Scotsman now living in Wurzburg, Germany, freelance writer, frustrated future bestselling author, obsessed bibliophile. Other interests include trying to understand The Architect in the Matrix movies, decrypting codes and ciphers, and trying to persuade my landlord and my wife to let me have a Highland Cow for a pet.
More by Mark O'Neill


View the original article here

Review: PowerDVD 13 Ultra media player is loaded with under-the-hood improvements

AppId is over the quota
AppId is over the quota

The PowerDVD Ultra series have been the most powerful, feature-laden DVD, Blu-ray, and media players available at retail. On the other hand, each version has also been somewhat slow to launch and sluggish to respond. Version 13 starts up more quickly and is better all around, although it's not a startling upgrade if you already have version 12. That said, there are more than a few new features here, including a user interface that Windows 8 aficionados will find appealing.

Before getting into the new stuff, a quick but impressive list of what PowerDVD Ultra already supports: Playback of DVDs and 2D and 3D Blu-ray movies with resolution enhancement; cataloging and playback of large collections of photos, music files, and videos; a 10-foot interface for use with a remote; and playback of media streamed via DLNA media servers (e.g., other PCs and NAS boxes).

PowerDVD 13 Ultra ($100) now supports every major video technology, including 2K/4K resolution, AVCHD 2.0 and 3D, and it comes with free players and remote-control apps for iOS and Android devices, plus PowerDVD Mobile for Windows tablets (both Windows 8 and RT). The Android and iOS apps are also free with the $80 Pro version, but you’ll need to pay $20 for PowerDVD Mobile. The Pro version drops support for 3D, 7.1-channel surround sound, and DLNA. You’ll need to pay for all three apps if you buy the $60 Deluxe version, which subtracts both Blu-ray and 3D support. Upgrades from previous versions of PowerDVD start at $45.

The last two versions of PowerDVD had the program morphing into a jack-of-all-trades media player, and version 13 continues that trend—albeit mildly. There’s a new a movie library with art for video files (not just movies), though as with many players, it's rather hit or miss on whether the art is correct. If the file name is explicit enough, it does okay. PowerDVD is also ready for Ultra Violet, the online movie storage/delivery service, and it already supports video streaming from most social networks (Facebook, YouTube, etc.)

PowerDVD 13 Ultra now provides its TrueTheater enhancements for 1920-by-1080p video. TrueTheater bypasses GPU hardware acceleration, though, so the hardware requirements are extreme. Even on a Core i7 965 test bed, enhanced video wouldn't play smoothly beyond about 25 Mbps. That’s fine for smaller downloaded files, but not for most Blu-ray movies. If you have the horsepower, TrueTheater really makes video look better. The ability to disable BD-live to speed movie start times is another significant improvement.

Cyberlink added support for two lossless audio codecs that will endear it to hard-core music fans everywhere: FLAC and APE. There's also a software EQ with common settings, and you can use Dolby to produce more spacious sound, but there’s no support for bass enhancement such as Windows Media Player's SRS TruBass. A new mini-player keeps the program out of the way when playing music.

With PowerDVD, CyberLink aspires to deliver the ultimate all-in-one solution for multimedia on the desktop. Version 13 is closer to that ideal, but still lacks a few features, including live TV support. It remains the best available video and movie playback application for state-of-the-art technologies (there are no free Blu-ray 3D alternatives). Only Corel's $50 WinDVD 11 comes close.

Jon L. Jacobi

Jon L. Jacobi has worked with computers since you flipped switches and punched cards to program them. He studied music at Julliard, and now he power mods his car for kicks.
More by Jon L. Jacobi


View the original article here

Webinar: Working with Office on Windows 8

AppId is over the quota
AppId is over the quota

clip_image001

The webinar is over. The video will be posted shortly or go to http://aka.ms/offweb for more information on how to join the series live every Tuesday. 

If you are working with Windows 8--or your business will be using Windows 8 soon--check out this week's webinar. We will go over shortcuts and quick navigation for keyboard and mouse, plus answer your questions.

What you will learn at Tuesday's webinar

Using a mouse and keyboard with Windows 8The Start ScreenKeyboard shortcutsIf you have a touch device

References for this webinar

--Doug Thomas


View the original article here

Mark using conditional formatting for dates in Excel

This tutorial about using conditional formatting, to dates highlight of MVP Frédéric Le Guen, pulse for help with the translation from French into English associated with special recognition and thanks to Ken to us.

Date functions in Excel make it is possible, date calculations, such as addition or subtraction, which carry automatic or semi-automatic worksheets. The NOW function, the values based on the current date and time is calculated, is a good example of this.

This functionality make a step further if you mix date functions with conditional formatting, you can create tables automatically displayed the date alerts if a period close to is or distinguishes between types of days, such as weekends and weekdays.

Find conditional formatting for dates, go to

Home > conditional formatting > highlight cell rules > a date come forward.

You can select the following date options, from yesterday to next month:

These 10 date options generate rules based on the current date. When you create rules for other data like (such as greater than a month from the current date), you can create your own new rule.

Below you will find step-by-step instructions for a few of my favorite formats for dates.

When designing an automated calendar you need even colour not weekends. With the conditional formatting tool you can automatically change the colors of the weekends by the format are based on the WEEKDAY function.  Suppose you the date table-have a calendar without conditional formatting:

To change the color of the weekends, open the menu conditional formatting > revision

Select the menu in the next dialog box, the use a formula to determine which cell format.

In the text box values format, this formula is true, enter the following formula day of the week to determine whether the cell is a Saturday (6) or Sunday (7):

=WEEKDAY(B$5,2) > 5

Parameter 2 = means Saturday 6 and Sunday 7 =. This parameter is very useful to test for a weekend.

Note: In this case, you must lock the reference of the line, so the conditional formatting to the other cells in the table properly.

Then fit the format of your state by clicking on the format button and select a fill color (orange in this example).

To do this, click OK, and then open conditional formatting > manage rules

Choose to see this worksheet worksheet rules rather than the default selection. Change in the is valid forarea that corresponds to the first selection when creating rules to expand the entire column.

Now, you see a different color for the weekends. Note: This example displays the results in the Excel Web app.

Enrich to the previous workbook could identify even holidays colours. To do this, you need a column with the holiday, the highlight you want in your workbook (but not necessarily in a sheet of paper). In our example we have U.S. holidays in column AH (in reference to the year in the cell B2).

The menu again conditional formatting > new rule. In this case, we use the COUNTIF formula to calculate the number of holidays in the current month is greater than 1.

 =COUNTIF($AH$4:$AH$16,B$5) > 1

Then choose in the dialog box to manage rules, area B4: AF11. If you want to emphasize the holiday over the weekend, at the top of the list to move the holiday rule.

In the Excel Web app below shows the result in this example. Change the value of the month and year to see, such as the calendar has a different format.

For the case that we want to again change the color of the cells, which is based on our approach on a date, we will work to make for us by using conditional formatting.

We will show in the following example:

Yellow dates between 1 and 2 Monthsorange data between 2 and 3 Monthspurple dates more than 3 months

We create three rules then conditional formatting formula DATEDIF . Each of the three cases the following formulas:

=DATEDIF($B2,$E$2,"m") > 0

=DATEDIF($B2,$E$2,"m") > 1

=DATEDIF($B2,$E$2,"m") > 2

In the Excel Web app, try below are some dates to experiment, to change the result.

Rather than a different color for each period within our time frame set selected, work we with color scales possibility is that our cells color.

First, go in a new column (column E), calculated the difference in the number of days formula and the parameters "yd" in a year again with the DATEDIF.

=DATEDIF($D2,today(),"YD")

Then select "the" conditional formatting > new option format all cells according to their value depending on and select the following options:

Scale = 3 ColorsMinimum = 0 RedMidpoint = 10 YellowMaximum = 30 white

The result is a gradient color gamut with shades of white to red to yellow.  The more closer to 0, red, that it will have closer closer knows more of 10 more yellow and on 30.  In the Excel Web app, try below are some dates to experiment, to change the result.

--Frédéric Le Guen


View the original article here

Review: SyncUp synchronized data, if you are not logged in or

Sync programs are a dime a dozen. But tightly written, easy-to-use and sync programs like SyncUp aren't nearly feature-complete @ Max SyncUp walks the fine line between makes and user friendliness is very good and successful, mainly because it sets options within easy reach, but keep it simple and used as little jargon as possible.

Clean, simple, straightforward. You cannot claim the display option, the options in Max SyncUp or array of them.

SyncUp ($25, 30-day trial) has almost every feature you could ask: backup, file filter, scheduling, and plan both two-way and one-way synchronization, as well as support for domain users, email notifications, FTP servers, networks, and granular. A potential weakness, however, is the lack of online destinations. Google drive is supported, but otherwise nothing. If more than the 5 GB secure the Google drive should be enabled to say Amazon S3, you must look elsewhere.

While SyncUp include as such is not supported, it will hold several older versions of your files. It also synchronized with pure file copy, ZIP archives, or archive to the own proprietary encrypted. The program creates its own service as well as allows scheduled tasks run it, whether you or are not logged in. Nice.

@Max SyncUp supports Google's online storage and FTP servers, but not Amazon S3.

@Max SyncUp is well executed. If you use S3 or other non-Google-online backup or store service, not for you, but otherwise it should be on your shortlist of pay-sync programs, if giveaways such as FreeFileSync do not.

Note: The download button on the product information page will download the software on your system.

Jon L. Jacobi

Jon L. Jacobi has worked with computers, since flipped switches and punch cards to their programming. He studied music Julliard and now he makes his car for kicks mods.
More by Jon L. Jacobi


View the original article here