Our greatest fears about the Biden administration came to fruition this week. President Puddingbrain announced he’s sending people door-to-door to make sure you’ve made the private medical decision he wants you to make. You know the one. Rhymes with Maxine. It’s a personal decision that his administration claims is the government’s absolute business to know. But at least, in this case, Biden isn’t threatening you with nukes and fighter jets. Yet.
The question remains what to do when the government comes to your door demanding to know private medical information. You may believe, as shocking as this may sound to CNN, that it’s none of the government’s business. JP Spears provides a tutorial on how to handle the situation.
When the Biden Administration Knocks On Your Door…
Of course, no one is advocating violence. That shouldn’t need to be said when the word "comedy" is clearly at the top of this page in blue letters. But, you know.
The media has already been dispatched to clean up Biden’s door-to-door mess. Editors are looking for new and exciting ways to work the words "Republicans" and "seize" into headlines. Brian Stelter is watching Fox News so he has something to talk about on CNN. Lather, rinse, and whatever the third thing is.
Americans still have an issue with a president who claims we yield our rights to him sending anyone door-to-door for any reason. Sears presents a satirical look because laughing is somewhat better than thinking about how bad things really are.
This year Musk made good on his promise, selling all of his homes. And after Mashable reported that he’s now living in "a prefabricated house near a SpaceX launch site in Texas," made by a company called Boxabl, I checked out their site—and accidentally stumbled across a tour of the actual house Musk is now living in.
For background, Boxabl makes $50,000 pre-fab houses–"Casitas"–that are shipped flatpack and unfolded on site. You can see how this works in the video below, which was shot in Texas in December. The company man giving the tour never says Musk’s name, but wordlessly reveals who the "VIP" is by tour’s end:
Netflix, as part of its lengthy celebration of all things Witcher-y in today’s “Witcher Con”, has just dropped the first proper trailer for The Witcher season 2, after previously dropping tiny snippets last month.
In season two, on the hunt for the missing mage Yennefer of Vengerberg (Anya Chalotra), Geralt (Henry Cavill) takes Ciri (Freya Allan) to the ancestral home of the Witcher’s school of the Wolf: Kaer Morhen, the same hallowed institute where Geralt once learned, under the guidance of his mentor Vesemir (played by Kim Bodnia this season, and the subject of his own spinoff anime film next month), the ways of monster hunting. But as the world goes to hell all around them across the continent, the various human kingdoms, the elves, and the monsters themselves at each others throats, Geralt quickly discovers that the most dangerous threat of all for Ciri may be the powerful magic that runs deep inside her—magic that only someone as talented as Yennefer could help Ciri temper.
Perhaps some coins will be tossed along the way, as we know at least that Joey Batey’s one-hit-wonder of a Bard, Jaskier, is along for the ride alongside plenty of new cast members this season, including Simon Callow, Adjoa Andoh, Graham McTavish, Cassie Clare, Chris Fulton, and more. We’ll know doubt come to learn much more of Geralt and Ciri’s adventures ahead of The Witcher’s returns to Netflix on December 17.
Stoopid Buddy Stoodios did a great stop-motion video for Snake Eyes.Screenshot: YouTube
Opening later this month, Snake Eyes: G.I. Joe Origins is a brand-new reboot of the famous franchise. So Channing Tatum’s Duke? Dwayne Johnson’s Roadblock? Those guys and everyone around them are gone. Now we’re restarting with Snake Eyes, one of the more popular characters, who also doesn’t usually speak.
That’ll change in this film, though, because Snake Eyes is played by Crazy Rich Asians star Henry Golding. And Golding lends his voice to this super cute, clever new video created by Paramount and Stoopid Buddy Stoodios. It uses G.I. Joe toys to explain who is actually in Snake Eyes, who isn’t, and why this movie exists at all.
The video is obviously messing around but it is accurate. Well-known G.I. Joe characters like Storm Shadow, Baroness, and Scarlet are in the film while the other toys in the video—including Duke, Gung Ho, Lady Jaye and Roadblock—are not. But their inclusion makes it fairly obvious those are characters could appear in sequels, if this movie is a success. Which is certainly not a guarantee.
When the first Snake Eyes trailer was released, we were lucky enough to talk to Golding about the role and he explained that follow-ups to Snake Eyes are already being considered. “I know for a fact that they’re already in the works,” he said. “Speaking to Lorenzo [DiBonaventura], our producer, they’re already thinking, because we can take this anywhere—but depending on how Snake Eyes does in telling specific stories will tell us where we want to take and how to expand the universe. Because if we jump into just a huge G.I. Joe universe and introduce 12 characters, people are going to be like, ‘Oh well yeah. Okay, that guy’s cool. That guy does this thing.’ But they don’t know anything about them. So to be able to build the characters from day one, I think, is the real gift.”
That gift is coming sooner than you might have realized, since Snake Eyes: G.I. Joe Origins opens in theaters July 23. Here’s a new featurette too.
J.R.R. Tolkien Returns With Army Of The Dead To Destroy Everyone Trying To Make ‘Lord Of The Rings’ Woke
WORLD—Terrified progressive scholars, movie executives, journalists, and bloggers ran screaming Thursday as they were confronted by an apparition of J.R.R. Tolkien leading the Dead Men of Dunharrow to destroy anyone who tried to make his work “woke.”
“I summon you — fulfill your oath!” the late Tolkien cried after venturing under the mountain to find the undead army. Tolkien raised Anduril aloft, and the army submitted to the professor, allowing him to lead them into battle against everyone trying to deconstruct his book and make it woke.
From writers pushing “queer readings” of his epic, heavily Catholic, and decidedly traditionalist and non-woke magnum opus to movie studio executives looking for ways to put nudity into their film and show adaptations, thousands fell in battle against the army. Those running the Tolkien Society’s latest woke conference heard a low rumbling and looked into the distance, terrified, to see the professor leading the army against them. “Onward!” a laughing Tolkien cried as the people trying to ruin the greatest book ever written scattered before the awful and terrible sight.
“I release you from your duty,” Tolkien said, causing the army to disappear, before going off to see if he could get any decent tobacco before returning to the afterlife.
Writers and programmers often need to compare different versions of the same code or text to keep track of changes. However, figuring out the changes is not a simple task. As a document gets longer, you’re more likely to make errors in comparison.
A file comparison tool helps you compare and merge differences between two (or more) versions of the same file. There are different types of utilities, each tailored for specific types of file formats.
We’ll look at some best file comparison and difference (diff) tools for macOS.
1. Meld
Meld is a simple, cross-platform diff and merge tool. The user interface is intuitive and neatly packs all its functions into a handy menu. It has many customizable settings to make file comparison quick and easy.
On first launch, the app gives you an option to choose a comparison module. To start a comparison, click the File module and select your files from Finder.
Meld will display them side-by-side. Any differences between them appear highlighted to make individual changes easier to see.
On either side of the panels, you’ll see two vertical bars with colored blocks. They give you a bird’s-eye view of all changes, such as inserted, deleted, changed, or in conflict. Click the arrows in a segment to copy or merge a block of one file with another.
Meld’s Unique Features:
Three-way comparison of files. The changes update in real-time, no matter how big the file gets.
Integrates with source control systems, such as Git, Bazaar, Mercurial, and SVN to perform version control tasks. The built-in version filter helps you compare any changes to the local vs repository file.
The text editor supports line numbers, whitespace, syntax highlighting, and text wrapping for a user-friendly experience.
With text filters, you can ignore text that matches a particular pattern or even use regular expressions to create complex filters. To try them, go to Preferences and turn on Text Filters.
Helix P4V is a cross-platform, enterprise version control software used to compare and merge source files, web pages, manuals, OS code, and more. P4V is the client for the Helix core server that hosts all your data and resides in a depot. You open the files and edit them in your workspace.
When done, submit the modified file back to the shared repository or depot, where it keeps track of all the file revisions. P4V integrates with the P4 diff and merge tool. The purple icon and its color scheme highlight the input file, while the green icon and its color scheme highlight the output file.
P4Merge displays files side-by-side, with the center as a base file. This allows you to compare two files with a base file to find differences and select the text you want in the merged file. To navigate, click the Previous or Next buttons.
Helix P4’s Unique Features:
Works with image formats including PNG, GIF, JPG, and others. It highlights identical areas in gray and differences in yellow in both images. You can also compare file resolution, depth, and size.
The integration with P4V can reveal the entire file revision history, plus what changed during a particular time frame. This is useful for resolving bugs.
Visualize the differences and resolve conflicts that result from parallel or concurrent development via color-coding, syntax highlighting, line numbers, and patches.
Supports syntax highlighting for source code while comparing or merging files. Click the Show Syntax Highlighting button to toggle the feature.
View image revisions sequentially in time-lapse view. In here, you can see an image file’s history, like who made changes and when.
Beyond Compare is a comprehensive utility to compare and merge various file types and folders. The app tries to maintain a balance between features and performance with an easy-to-use interface and colorful buttons. On first launch, choose the comparison module for Text, RTF, Hex, MP3, Tables, and more.
Every comparison task begins with a Session. You can customize and save any session as Workspace. Simply load the workspace, and Beyond Compare will also load all your sessions with the same configuration and tabs.
The app will display your files side-by-side. It uses red text for highlighting important differences and blue for insignificant changes. You can adjust these colors to suit your preferences.
The overview thumbnail on the left pane displays a visual map of colors. To navigate, use the Next and Previous buttons to step through all your differences. Then, use the arrow buttons to merge your files. Click the Save button located at the right of the window to save your file.
Beyond Compare’s Unique Features:
The Session settings that control these comparisons are called Rules. They put you in control of how each session works and helps you discover significant differences.
The Table Compare session compares text files with tabular data. You can sort and align the data on key fields and compare them cell-by-cell.
Built-in scripting processing feature to automate routine tasks. For more details, visit the scripting section of the Help page.
Integration with popular tools like SQL Examiner, Dreamweaver, EditPlus, Total Commander, and Version Control System.
Compare files in remote storage through Dropbox, Google Drive, Amazon S3, and OneDrive.
Download:Beyond Compare ($30 Standard | $60 Pro | Free trial available)
4. DeltaWalker
DeltaWalker is a cross-platform visual diff and merge tool. The interface is intuitive, with just a few menu buttons. It relies more on visual parameters to help you find differences. Out of the box, it supports Office files, Java archives, ZIP, XML, PDF, and more. Speaking of which, we’ve covered how to compare two Excel files using other methods.
Click the Browse button in the entry field to bring up a File Open dialog box. On the other side, you can either open a local or remote file via SFTP, HTTPS, WebDAV, Dropbox, or Google Drive.
The app uses colors to denote the changes in blocks as inserted, deleted, changed, and in conflict. You’ll see connecting lines that joins together related blocks to simplify the results.
The vertical color strip on the right panel shows a summary with a scaled-down visual map of all differences. Click the arrow button (which appears when you hover your mouse) to merge your files.
DeltaWalker’s Unique Features:
One-click integration with Git, Bazaar, Mercurial, and SVN. Go to Preferences > SCM Integration and toggle the SCM of your choice. Here’s a guide on how to install Git on Mac.
Find and Replace feature helps you find specific characters and use regular expressions for advanced cases. Or use shortcuts to access them without opening the Find and Replace window.
Linked undo and redo feature keeps track of changes across editors. When you undo, the changes happen in reverse order, spanning across multiple editors.
Export the file comparison report as HTML and Patch. The latter contains the differences between one or more pairs of different files, which is helpful for app developers.
Download:DeltaWalker ($40 Standard | $60 Pro | Free trial available)
5. Araxis Merge
Araxis Merge is a complex diff and merge tool. It works with many file formats, including Office files, PDF, XML, HTML, Binary, and source code files. This makes the app suitable for various creative professionals and use cases.
Click the Browse button to open your file. Araxis Merge uses text extraction filters and formatting tools to help you see changes more clearly. Go to Preferences > File Comparisons > File Types to configure the filters for various kinds of files.
Thin overview strips next to the scroll bar show the position of changes. The status bar shows you a summary of changes that are inserted, removed, changed, and deleted. The built-in plugin system gives you access to files located in Git, SVN, and Perforce Depot.
There are two layout options: vertical and horizontal. They both work with two- and three-way file comparison modes. Use the Previous or Next buttons (or shortcuts) to navigate through the file. Additionally, click the small merging button on each block to copy, replace, or merge files.
Araxis Merge’s Unique Features:
Drag and drop blocks of text in either panel to edit files. Araxis Merge analyzes the changes in the background and saves them. At any time, you can undo the result.
Compare folders with two- or three-way file comparison. This layout splits the display with folders on top and its related files at the bottom.
Create markers to indicate the lines you’ve modified. Add a bookmark to remind yourself or place a comment to note important information.
The synchronization link feature can help you identify points of similarity between files to simplify the comparison results. This works best with complex files.
Export the file comparison report as HTML, XML, and Unix Diff. This feature is helpful for future audits, storage, and sharing.
Download:Araxis Merge ($129 Standard | $269 Pro | Free trial available)
Use Notepad++ to Compare Files
There are many reasons to use a file comparison tool. A software developer might need syntax highlighting and export features. A writer may prefer a more visual diff tool to compare text. The apps discussed here cover every use case. Give them a proper trial to see which one fits your needs.
If you’re using the excellent text editor Notepad++, then you can compare files easily with a plugin. It’s feature-rich and fits both casual users and programmers.
Microsoft Excel formulas can do almost anything. In this article, you’ll learn how powerful Microsoft Excel formulas and conditional formatting can be, with three useful examples.
Much of the Excel power lies behind the Excel formulas and rules that help you manipulate data and information automatically, regardless of what data you insert into the spreadsheet.
Let’s dig into how you can use formulas and other tools to better use Microsoft Excel.
Conditional Formatting With Excel Formulas
One of the tools that people don’t use often enough is Conditional Formatting. With the use of Excel formulas, rules, or just a few really simple settings, you can transform a spreadsheet into an automated dashboard.
To get to Conditional Formatting, you just click on the Home tab and click on the Conditional Formatting toolbar icon.
Under Conditional Formatting, there are a lot of options. Most of these are beyond the scope of this particular article, but the majority of them are about highlighting, coloring, or shading cells based on the data within that cell.
This is probably the most common use of conditional formatting—things like turning a cell red using less-than or greater-than formulas. Learn more about how to use IF statements in Excel.
One of the lesser-used conditional formatting tools is the Icon Sets option, which offers a great set of icons you can use to turn an Excel data cell into a dashboard display icon.
When you click on Manage Rules, it’ll take you to the Conditional Formatting Rules Manager.
Depending on the data you selected before choosing the icon set, you’ll see the cell indicated in the Manager window with the icon set you just chose.
When you click on Edit Rule, you’ll see the dialog where the magic happens.
This is where you can create the logical formula and equations that will display the dashboard icon you want.
This example dashboard will show time spent on different tasks versus budgeted time. If you go over half the budget, a yellow light will display. If you’re completely over budget, it’ll go red.
As you can see, this dashboard shows that time budgeting isn’t successful.
Almost half of the time is spent way over the budgeted amounts.
Time to refocus and better manage your time!
1. Using the VLookup Function
If you’d like to use more advanced Microsoft Excel functions, then here are a couple for you to try.
You’re probably familiar with the VLookup function, which lets you search through a list for a particular item in one column, and return the data from a different column in the same row as that item.
Unfortunately, the function requires that the item you’re searching for in the list is in the left column, and the data that you’re looking for is on the right, but what if they’re switched?
In the example below, what if I want to find the Task that I performed on 6/25/2018 from the following data?
In this case, you’re searching through values on the right, and you want to return the corresponding value on the left.
If you read Microsoft Excel pro-user forums, you’ll find many people saying this isn’t possible with VLookup. You have to use a combination of Index and Match functions to do this. That’s not entirely true.
You can get VLookup to work this way by nesting a CHOOSE function into it. In this case, the Excel formula would look like this:
Here’s one more crazy Excel formula for you! There may be cases where you either import data into Microsoft Excel from an outside source consisting of a string of delimited data.
Once you bring in the data, you want to parse that data out into the individual components. Here’s an example of name, address, and phone number information delimited by the ";" character.
Here’s how you can parse this information using an Excel formula (see if you can mentally follow along with this insanity):
For the first field, to extract the leftmost item (the person’s name), you would simply use a LEFT function in the formula.
"=LEFT(A2,FIND(";",A2,1)-1)"
Here’s how this logic works:
Searches the text string from A2
Finds the ";" delimiter symbol
Subtracts one for the proper location of the end of that string section
Grabs the leftmost text to that point
In this case, the leftmost text is "Ryan". Mission accomplished.
3. Nested Formula in Excel
But what about the other sections?
There may be easier ways to do this, but since we want to try and create the craziest Nested Excel formula possible (that actually works), we’re going to use a unique approach.
To extract the parts on the right, you need to nest multiple RIGHT functions to grab the section of text up until that first ";" symbol, and perform the LEFT function on it again. Here’s what that looks like for extracting the street number part of the address.
It looks crazy, but it’s not hard to piece together. All I did is took this function:
RIGHT(A2,LEN(A2)-FIND(";",A2))
And inserted it into every place in the LEFT function above where there’s an "A2".
This correctly extracts the second section of the string.
Each subsequent section of the string needs another nest created. Now all you need to do is take the "RIGHT" equation that you created in the last section, and paste it into a new RIGHT formula with the previous RIGHT formula pasted into it where you see "A2". Here’s what that looks like.
That formula correctly extracts "Portland, ME 04076" out of the original string.
To extract the next section, repeat the above process all over again.
Your Excel formulas can get really loopy, but all you’re doing is cutting and pasting long formulas into themselves, making long nests that still work.
Yes, this meets the requirement for "crazy". But let’s be honest, there is a much simpler way to accomplish the same thing with one function.
Just select the column with the delimited data, and then under the Data menu item, select Text to Columns.
This will bring up a window where you can split the string by any delimiter you want. Simply input ‘;‘ and you’ll see that the preview of your selected data changes accordingly.
In a couple of clicks, you can do the same thing as that crazy formula above… but where’s the fun in that?
Getting Crazy With Microsoft Excel Formulas
So there you have it. The above formulas prove just how over-the-top a person can get when creating Microsoft Excel formulas to accomplish certain tasks.
Sometimes those Excel formulas aren’t actually the easiest (or best) way to accomplish things. Most programmers will tell you to keep it simple, and that’s as true with Excel formulas as it is with anything else.
I hate them so much that when my husband suggests having dinner outside or playing a lawn game, I immediately start to wonder about the swarms of mosquitoes that will attack me.
How about a card game inside instead?
But ever since we started using Thermacell devices, I have happily said yes to the outdoors more often.
