Redmi 9 Prime is set to go on sale in India today. The device was launched during the big Amazon Prime Day sale, but now it is available to buy from Mi.com and Amazon India both. The sale will begin at 12pm (noon) and will go on till the stocks last. Key features of the Redmi 9 Prime include a large 5,020mAh battery with 18W fast charge support. The phone is equipped with a MediaTek Helio G80 SoC and offers a quad-camera setup at the back.
Redmi 9 Prime price in India, sale offers
The sale of the Redmi 9 Prime, as mentioned, will begin at 12pm (noon) on Amazon.in and Mi.com both. The device will be available in four colour options – Matte Black, Mint Green, Sunrise Flare, and Space Blue. The Redmi 9 Prime is priced in India starting at Rs. 9,999 for the 4GB RAM + 64GB storage option and Rs. 11,999 for the 4GB RAM + 128GB storage option.
Sale offers for the Redmi 9 Prime from Amazon.in include no-cost EMI options and 5 percent instant discount on HSBC cashback card.
Redmi 9 Prime specifications
The dual-SIM Redmi 9 Prime runs on Android 10 with MIUI 11 on top and features a 6.53-inch full-HD+ IPS display. It is powered by the octa-core MediaTek Helio G80 SoC, paired with 4GB DDR4x RAM. Xiaomi has provided up to 128GB of onboard storage on the Redmi 9 Prime that is expandable via microSD card (up to 512GB).
Redmi 9 Prime has a quad rear camera setup that includes a 13-megapixel primary image sensor, an 8-megapixel secondary ultra-wide-angle lens, a 5-megapixel macro shooter, and a 2-megapixel depth sensor. For selfies, there is an 8-megapixel camera sensor at the front.
The Redmi 9 Prime packs a 5,020mAh battery that supports 18W fast charging. Connectivity options include 4G VoLTE, Wi-Fi 802.11ac, Bluetooth 5.0, GPS/ A-GPS, IR blaster, and a USB Type-C port. The phone also has the rear-mounted fingerprint sensor.
Samsung Brings Its Flagship Camera Innovation to Galaxy A Series – Galaxy A71 & A51, to Make Your Social Profile Lit
Our social media profiles are reflection of our true personalities. Needless to say, we make that extra effort to make them look and feel special. What helps us in the process is a powerful smartphone that can not only capture stunning photos and videos, but also help us quickly process and share them across to our friends and family members.
Samsung’s phones are known for their excellent smartphone cameras. Over the years, the company has been shipping highly innovative and impressive cameras on its flagship smartphones. Samsung is now bringing its innovative flagship camera experiences to its Galaxy A series phones, the Samsung Galaxy A51 and Galaxy A71. These new flagship-level features can help you spice up your social media profiles by capturing and sharing stunning photographs and videos.
Let’s take a look at some of the most impressive new camera features in Samsung’s Galaxy A71 and Galaxy A51 smartphones at can help you take your social media posts to the next level:
Single Take Makes Your Special Moments Extra Ordinary
Everything you do is worth sharing on your social media profiles and messaging platforms. Your social profiles help you stay connected to your loved ones by helping you share your most memorable moments. Single Take is a new feature on Galaxy A71 and Galaxy A51 smartphones, which was earlier available only on Samsung’s flagship Galaxy S20 series.
Single Take lets you indulge in your special moments, while still capturing the best parts of it. Imagine being at a birthday celebration of a loved one, and wondering about which camera mode to select. Single Take can help you enjoy the moment while still being able to capture all the important details in the form of 10 photos and videos based on the moment and lighting condition.
All you have to do is pick Single Take mode, and capture a moment for a few seconds. Your Galaxy A71 or Galaxy A51 phone will be able to deliver stunning photos and videos that ensure you don’t miss out on anything important, and still end up with a bunch of great photos and videos to share on your social media profile.
Night Hyperlapse to Impress Everyone on Your Feed
Out at a party? The new Night Hyperlapse mode can help you capture stunning night-time videos to impress your social media friends and family. The mode helps you capture long-exposure style videos and light trails that are nothing but pieces of pure bliss when you share them on your social media profiles. Your friends and family will nudge you, asking you how you captured these. Night Hyperlapse mode is now available on Samsung Galaxy A71 and Galaxy A51 phones.
Custom Filters to Add that Special Touch to Your Photos
While social media is fun, it’s also filled with a lot of noise. You’re not going to make it if you don’t look different and extra special. Well, Samsung has you covered here as well. The new Custom Filters feature in the Samsung Galaxy A71 and Galaxy A51 can help you create stunning and highly personalized photos using custom-set filters.
All you have to do is create a custom filter using any of your existing photos. Custom Filters uses on-device AI to capture the rich colours and vibes of your existing photos. You can then use these filters and apply them on new photos you capture on the Galaxy A71 or Galaxy A51 to create personalized photos. Once you share these on your social media profiles, they’ll look stunning and extraordinary, unlike anyone else’s photos.
Smart Selfie Angle to Make You and Your Friends Looks Great
Selfies are quite an essential part of social media. While everyone is shooting and sharing selfies, not all of them are going to look as good as yours, thanks to this highly innovative camera feature on the Galaxy A71 and Galaxy A51.
The new Smart Selfie Angle mode on the Samsung Galaxy A71 and Galaxy A51 help you capture great selfies with your friends. Every time you use the front camera to capture a selfie with your friends, the camera can automatically switch to a wide-angle mode. The mode is built to capture great details when more than one person is involved in a selfie. This means your selfies with your friends are going to look fabulous when you share them on your social media profiles.
AI Gallery Zoom Adds That Magical Touch to Existing Photos
AI Gallery Zoom is a great feature that can help you improve existing photos on your phone. For example, if you get one of your photos from a friend, on a messaging platform, it could turn out to be slightly blurred due to compression systems.
This feature ensures those unclear photos look more clear in your Gallery. It can make images look sharper and visually appealing, so you can easily share them on your social media profiles. The feature uses an on-device AI-powered mechanism so your personal data doesn’t leave your phone ever. The feature is also useful if you’re migrating from an older, less powerful smartphone, and are importing photos from it.
Switch Camera While Recording Is Perfect for Vlogging
While most smartphones feature front and rear cameras, they rarely let you capture a single video using both the cameras. Well, Samsung’s Galaxy A71 and Galaxy A51 phones can now let you record videos using both the cameras without stopping recording. It’s an amazing feature that’s perfect while you’re sharing live videos or simply making a quick vlog for your social media profiles.
Quick Videos Ensure You Don’t Miss Anything
Consider this, you come across a really special moment, and by the time you fire up the Camera app on your phone and start recording the video, it’s gone. Samsung Galaxy A71 and Galaxy A51 now come with a new feature called Quick Videos that takes care of this problem.
You can now quickly capture a video by long-pressing the shutter button. This way, you can easily record a great video and share it on your social media profile. Quick Videos feature is ideal while you’re at home or on a vacation, and you simply want to capture a quick moment and share it with everyone.
Samsung Galaxy A71 and Galaxy A51 Are Perfect for Social Influencers
What’s stopping you from becoming the next big thing on a major social media platform? It could be your existing smartphone. Switch to the new and powerful Samsung Galaxy A71 or Galaxy A51 and feel the difference today. The smartphones now come with Samsung’s highly innovative and powerful flagship-grade smartphone features that can make your social media posts pop, turning you into a celebrity amongst your fans and followers.
Click here to buy now and for more specified details of the latest Samsung Galaxy A51
Click here to buy now and for more specified details of the latest Samsung Galaxy A71
Affiliate links may be automatically generated – see our ethics statement for details.
How to copy expressions without changing cell references in Excel
Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don’t want to change the cell references.
Microsoft Excel has a helpful behavior in regard to copying expressions. After entering a row or column of expressions, you can copy them, and Excel will update the cell references according. Otherwise, you’d have to enter all expressions manually and that would be tedious and open to error. However, it’s not uncommon to run up against a situation when you won’t want to update the references. There’s no easy built-in way to do this. In this article, I’ll show you two quick workarounds for copying expressions without updating the cell references.
When you copy an expression by using the fill handle, Excel updates relative cell references. For instance, if you copy the simple expression =B3/C3 one cell to the right, Excel will adjust the column reference and enter the expression =C3/D3. If the column reference is absolute ($), Excel will change nothing, and copy =$B3/$C3. However, if you copy the expression down one row, Excel will update the row reference because it isn’t absolute: =$B4/$C4. The same behavior is in play whether you use Ctrl+C to copy the expression or move it. This behavior makes it difficult—impossible—to copy an expression when you don’t want to update the cell references unless all of those references are absolute: =$B$3/$C$3.
If you have only a few expressions to copy, retaining the original references, you can use the formula bar in edit mode. It’s quick, easy and gets the job done. We can illustrate this using the simple data set shown in Figure A as follows:
Go to the formula bar and highlight the entire expression.
Select the destination cell, F3, and press Ctrl+V.
As you can see in the data set to the right in Figure A, both expressions reference the same cells, B3 and C3. If you’re working in the browser, you’ll need to erase the ‘ character in the destination cell before it will evaluate the expression.
This method is quick and easy but works with one or a few expressions. If you have a lot of expressions, this method will take a long time. Now, let’s look at a second method that takes a bit more work but works with lots of expressions simultaneously.
The hard way handles many expressions in Excel
If you want to make the same change to several instances of the same content, what tool do you usually use? Replace—that’s right! That’s the tool we’re going to use to copy many expressions without changing the cell references at the same time:
First, we’ll add a special character to the beginning of selected expressions using = as the Find string and # as the replace string Excel will treat the expressions as text
Then, we’ll copy the expressions to the new destination.
Finally, we’ll replace the special character we used in step 1 with the = character.
Now, let’s run through a quick example using the expressions in column D:
Press Ctrl+h or choose Replace from the Find & Select dropdown in the Editing group (on the Home tab)
Enter = in the Find what control.
Enter # in the Replace with control (Figure B). You don’t have to use #; you can use most any other character but use one that’s not in use or you might get unexpected results. That’s why I chose #. If # is in use, come up with another character or even a string of characters, such as AAA or ZZZ.
Click Replace All.
Click OK to confirm and Close.
As you can see in Figure C, Excel treats all of the selected expressions as text.
Using your favorite copy and paste method, copy the contents of D3:D8 to F3:F8. Now, it’s time to replace the # character with the = character. To do so, repeat the above instructions, but in step 3, enter # and in step 4, enter =, reversing the original search strings. When you’re done, you will have matching expressions in columns D and F (Figure D). You can select both sets by creating a non-contiguous selection or you can run the Replace task twice.
Microsoft Weekly Newsletter
Be your company’s Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets. Delivered Mondays and Wednesdays
A Human-Computer Duet System for Music Performance
Despite the popularity of virtual musicians, most of them cannot play together with human musicians following their tempo or create their own behaviors without the aid of human characters. The authors of a recent paper created a virtual violinist having these characteristics.
It can track music and adapt to the human pianist’s tempo varying with time and with performance, making the two voices harmonized. The virtual musician’s body movements are generated directly from the music. The motion generator is trained on a music video dataset of violin performance and a pose sequence synchronized with live performance is generated.
These features mean that the human musician can practice, rehearse, and perform music with the virtual musician like with a real human, by following the music content. The proposed system has successfully performed in a ticket-selling concert, where a movement from Beethoven’s Spring Sonata was played.
Virtual musicians have become a remarkable phenomenon in the contemporary multimedia arts. However, most of the virtual musicians nowadays have not been endowed with abilities to create their own behaviors, or to perform music with human musicians. In this paper, we firstly create a virtual violinist, who can collaborate with a human pianist to perform chamber music automatically without any intervention. The system incorporates the techniques from various fields, including real-time music tracking, pose estimation, and body movement generation. In our system, the virtual musician’s behavior is generated based on the given music audio alone, and such a system results in a low-cost, efficient and scalable way to produce human and virtual musicians’ co-performance. The proposed system has been validated in public concerts. Objective quality assessment approaches and possible ways to systematically improve the system are also discussed.