Combine Text and Formatted Numbers
Here are a few examples of using the TEXT function to format numbers.
NOTE: There are more examples of Custom formats on the Microsoft website
- Format a date as month/day/year:
- =”Payment is due ” & TEXT(A2,”mm/dd/yyyy”)
- Format a number as currency:
- =”Amount due: ” & TEXT(A3,”$#,##0.00″)& ” USD”
- Format a number as a percentage:
- =”Your score is ” & TEXT(A4,”0.00%”)
- Format a number as a fraction:
- =”Hours worked: ” &TEXT(A5,”# ?/?”)
Easy steps – how to combine cells in Excel, with text and number format. Add text to formulas, show formatted numbers. Free Excel file, video, written steps
If you have a large collection of local photos, music and videos, you may want to access these media files on all your devices, such as desktop PC, laptop, streaming boxes, smart TV, smart phones, tablets, etc.
Connecting PC to your TV is dead simple. It’s just an HDMI cable away. All you need is an HDMI cable provided both your PC and TV have the HDMI port, the HDMI-out port on PC and the HDMI-in port on TV. What you need to do is connecting one end of the HDMI cable to the HDMI-out port on your PC and the other end to the HDMI-in port on the TV. On your TV side, choose the input source to the connected HDMI port. An HDMI cable is not expensive. Before you buy one, you need to choose the HDMI version, HDMI 1.4, 2.0 or both supported, and cable length. You may need a VGA cable if your computer or TV is old. If you do not have an applicable cable for wired connection and screencast between PC and TV, you can refer to following wireless video streaming solutions.
If your PC and TV are DLNA-enabled, you can directly play media files from computer on to TV big screen without any cable. See this step-by-step guide to cast photos, music and videos from PC to TV using the system built-in programs in Windows 10. No need any third-party software required.
Today, we will talk about how you can set up DLNA or UPNP media streaming server on Windows 10 computer so you can access media content from any other devices. For example, you can access and play music and movies stored on your PC from your mobile phone without replying on copying these media files from computer to cell phone.
Enabling DLNA Media Server via Windows Media Player in Windows 10
Microsoft Windows Media Player can still be found in Windows 10, although not updated for couple of years. Run Windows Media Player on your PC, select Stream on the toolbar, and choose “Automatically allow devices to play my media“, you will be prompted to select the shared folder, library and device, select and share Photo, Video and/or Music.
In Windows Media Player, select “More streaming options” on its toolbar, where you can choose which PCs and devices are allowed to access the shared content on your computer. If you see some unknown devices, in this device list, click on it to open its properties dialogue, you can then find out its Mac address and IP address. Every device in your local network has its unique Mac and IP addresses. For example, you can follow these steps to find out IP address on Samsung phone, and this guide to find out IP address on Windows 10 computer. IP address is different from Mac address, see this tutorial to find Mac address in Windows 10.
Setup DLNA Media Server from Control Panel in Windows 10
Right click on the Start button at the bottom left corner on your Windows 10 PC, choose Control Panel from the pop-up menu, then search “media” without the quotes at the top right corner of the Control Panel home screen. Click the “Media streaming options” link in the Network and Sharing Center section. Follow on-screen tips to turn on media streaming, name your media library, allow devices to access your shared media, select media type(s) to share and finally finish the setup of media streaming server on Windows 10 computer.
Adding content to media server in Windows 10
When you have turned on media streaming and authorized the devices in Windows Media Player, you need to choose what songs, pictures and movies that can be streamed over the network. By default, all the music that you load in the “My Music”, photos in the “My Pictures”, and movies in the “My Videos” folders gets added to your PC’s media library. If you want to add more media files saved in other locations or folders to share and make them available to any other devices on your network, you do not have to move or copy the actual media files to the current media library folders. You can add new folders to the libraries instead. To do that, run Windows Media Player for Windows 10, then click the Organize button and choose Manage Libraries from the drop-down menu. In the sub-menu, you will find four media types: Music, Videos, Pictures, and Recorded TV. Choose the media type first, then go to add new folders and locations to be monitored for that type of media and add more photos, videos, and/or songs to the media libraries of Windows Media Player and media server on your Windows 10 computer.
nmon keyboard shortcuts
- q – To stop and exit nmon.
- h – To see quick help (hint) screen and press h again to remove the hints.
- Use the following command to turn on or off stats:
- c – See cpu stats.
- m – See memory stats.
- d – See disk stats.
- k – See kernel stats.
- n – See network stats.
- N – See NFS stats.
- j – See file system stats.
- t – See top process.
- V – See virtual memory stats.
- . – See only busy disks/procs.
- v – Verbose mode (display as Ok/warning/danger on screen).
Sample output from my home server:
How do I set default monitoring options for nmon?
To see the memory, network, disk and processor statistics immediately after the nmon command is started, run (or add in your shell startup file):
# export NMON=mndc
Run the nmon command:
Capturing and analyzing data with nmon
You can capture the data to a file for later analysis and graphing. Type the following command:
# nmon -f -s2 -c 30
# nmon -ft -s 30 -c 120
nmon will run as a daemon in the background and you can log out. nmon will complete the data file capture and it will save in a file *.nmon file such as nas02_120806_0202.nmon. Where,
- -f : Start data collect mode and output in spreadsheet format.
- -s 2 : Wait between 2 seconds refreshing the screen.
- -c30 : Total number of refreshes (30).
- -t : Spreadsheet includes top processes.
- -d disks : to increase the number of disks [default 256]
- -x : Capacity planning (15 min for 1 day = -fdt -s 900 -c 96)
You need to download nmonanalyser which is an Excel spreadsheet that takes an output file from nmon and produces some nice graphs to aid in analysis and report writing.
Check out related media
See a quick installation and demo of nmon command:
If you use the highlight comment tool frequently, you can keep this tool “sticky” while in use. Just open the Properties Bar from the toolbar well (or press Control+E on Windows) and then after you select the Highlight tool, you’ll have the option “Keep tool selected”.
This is a little late, but I was able to get my WF-3640 working by compiling the epson drivers from source.
Download src files from http://download.ebz.epson.net/dsc/du/02 … 16bfac03be
Code: Select all
wget https://download3.ebz.epson.net/dsc/f/03/00/06/06/12/5102fbe4d3ad88f52f9648d234fa24a19ba7ccfc/epson-inkjet-printer-escpr-1.6.14.tar.gz sudo apt-get install libcups2-dev libcupsimage2 libcupsimage2-dev gunzip epson-inkjet-printer-escpr-1.6.14.tar.gz tar -xf epson-inkjet-printer-escpr-1.6.14.tar cd epson-inkjet-printer-escpr-1.6.14 sudo ./configure sudo make sudo make install
The colors were coming out faded (draft mode) so I also had to set the printer media-type option to high, to fix this.
Delay or schedule sending email messages
You can delay the delivery of an individual message or you can use rules to delay the delivery of all messages by having them held in the Outbox for a specified time after you click Send.
Delay the delivery of a message
- While composing a message, select the More options arrow from the Tags group in the Ribbon.
- Under Delivery options, select the Do not deliver before check box, and then click the delivery date and time you want.
- Click Close.
- When you’re done composing your email message, select Send.
After you click Send, the message remains in the Outbox folder until the delivery time.
If you decide later that you want to send the message immediately, do the following:
- Switch to the Outbox folder.
- Open the delayed message.
- Select the More options arrow from the Tags group in the Ribbon.
- Under Delivery options, clear the Do not deliver before check box.
- Click Close and send.
Note: This feature works only when Outlook is in online mode.
Delay the delivery of all messages
You can delay the delivery of all messages by up to two hours by creating a rule.
- Click File.
- Click Manage Rules & Alerts.
- Click New Rule.
- In the Step 1: Select a template box, under Start from a Blank Rule, click Apply rule on messages I send, and then click Next.
- In the Step 1: Select condition(s) list, select the check boxes for any options that you want, and then click Next.
If you do not select any check boxes, a confirmation dialog box appears. If you click Yes, the rule that you are creating is applied to all messages that you send.
- In the Step 1: Select action(s) list, select the defer delivery by a number of minutes check box.
- In the Step 2: Edit the rule description (click an underlined value) box, click the underlined phrase a number of and enter the number of minutes for which you want the messages to be held before it is sent.
Delivery can be delayed up to 120 minutes.
- Click OK, and then click Next.
- Select the check boxes for any exceptions that you want.
- Click Next.
- In the Step 1: Specify a name for this rule box, type a name for the rule.
- Select the Turn on this rule check box.
- Click Finish.
After you click Send, each message remains in the Outbox folder for the time that you specified.
Compose a message now, but schedule it to be sent later.
systemctl enable org.cups.cupsd.service
systemctl start cups
If this work, check if
/usr/lib/systemd/system/cups.socket exists. If not, this is the problem.
/etc/systemd/system/cups.socket with the following content.
[Unit] Description=CUPS Printing Service Sockets [Socket] ListenStream=/var/run/cups/cups.sock [Install] WantedBy=sockets.target
Then, install CUPS service.
systemctl enable cups
Sent from my iPhone