Posted on Leave a comment

Excel Tips

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 websitego to top

combine text number format

  • 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

https://www.contextures.com/xlCombine01.html

Posted on Leave a comment

Setup media server in Windows 10 – Better Host Review

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.

windows media player stream setting to allow other devices play media

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.

One Comment

How do you include files from a remote nas in Win 10 libraries?
Win 10 does not allow remote files to be added to libraries. Is there a work-around?
This short-coming is a real problem in Win 10.

Source: Setup media server in Windows 10 – Better Host Review

Posted on Leave a comment

How to change the priority order of network adapters on Windows 10 | Windows Central

How to change the priority order of network adapters on Windows 10

If you use multiple network adapters on your Windows 10 PC, in this guide, we’ll show you the steps to prioritize each one in two different ways.

MAURO HUCULAK

On Windows 10, if you have a device with more than one network adapter (such as Ethernet and Wi-Fi), each interface receives a priority value automatically based on its network metric, which defines the primary connection that your device will use to send and receive networking traffic.

Although, for the most part, Windows 10 does a pretty good job selecting an optimal connection to access the network, sometimes you may need to configure the order of the network adapters manually. For example, if you want to use a Wi-Fi over an Ethernet interface when both adapters are connected to the network.

You could disable those adapters you don’t use, but it may not be the best solution as you may need them as backups. Instead, a more straightforward solution is to adjust the interface metric to specify in which order your device should use each network adapter, which you can do using Control Panel and PowerShell.

 

In this Windows 10 guide, we’ll walk you through the steps to change the network adapter priorities to stay connected using your prefered adapter when using multiple interfaces.

How to change network adapter priorities using Control Panel

If you want to change the order in which Windows 10 uses network adapters, do the following:

  1. Open Settings.
  2. Click on Network & Internet.
  3. Click on Status.
  4. Click the Change Adapter options item.

  5. Right-click the network adapter you want to prioritize, and select Properties.

  6. Select the Internet Protocol Version 4 (TCP/IPv4) item.
  7. Click the Properties button.

  8. In the “General” tab, click the Advanced button.

  9. Clear the Automatic metric option.
  10. In the “Interface metric” field assign a priority value for the adapter.

    Quick Tip: The lower the metric number means higher priority, and a higher number indicates lower priority.

  11. Click the OK button.
  12. Click the OK button again.
  13. Click the Close button.

Once you’ve completed the steps, Windows 10 will prioritize the network traffic depending on your configuration.

The only caveat using the Control Panel experience is that depending on your network setup, you may need to adjust the metric for the Internet Protocol Version 6 (TCP/IPv6) as well, if that’s the protocol you’re using. (Usually, you will be using the TCP/IPv4 protocol.)

At any time, you can revert the changes using the same instructions, but on step No. 9, make sure to check the Automatic metric option.

How to change network adapter priorities using PowerShell

Alternatively, you can change network adapters priorities on a device with multiple interfaces using PowerShell with these steps:

  1. Open Start.
  2. Search for Windows PowerShell, right-click the top result a select Run as administrator.
  3. Type the following command to identify the current interface metric and interface index number and press Enter:

    Get-NetIPInterface

  4. Type the following command to change the priority order of the network adapter and press Enter:

    Set-NetIPInterface -InterfaceIndex 21 -InterfaceMetric 10

    In the command, make sure to change the -InterfaceIndex value to reflect the network adapter you want to prioritize and change the -InterfaceMetric value to assign a priority. Also, remember that a lower metric number means higher priority, and a higher metric number means lower priority.

  5. Type the following command to see the new metric applied to the network adapter and press Enter:

    Get-NetIPInterface

After completing the steps, Windows 10 will prioritize the network traffic depending on your configuration when multiple network adapters are connected to the network.

At any time, you can go back to the previous behavior allowing Windows 10 to decide the network adapter priority using these steps:

  1. Open Start.
  2. Search for Windows PowerShell, right-click the top result a select Run as administrator.
  3. Type the following command to identify the current interface metric and interface index number and press Enter:

    Set-NetIPInterface -InterfaceIndex 21 -AutomaticMetric enabled

    In the command, make sure to change the -InterfaceIndex value with the correct number of the network adapter you want to apply an automatic metric.

More Windows 10 resources

For more hel

Source: How to change the priority order of network adapters on Windows 10 | Windows Central

Posted on Leave a comment

Install and Use nmon Tool To Monitor Linux Systems Performance – nixCraft

Source: Install and Use nmon Tool To Monitor Linux Systems Performance – nixCraft

 

Sample outputs:

Command to analyze Linux server performance - cpu / memory / network / disk and much more
Fig.01: nmon startup screen

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:

nmon Command Examples
Fig.02: nmon command in action

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:
# nmon

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
OR
# 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,

  1. -f : Start data collect mode and output in spreadsheet format.
  2. -s 2 : Wait between 2 seconds refreshing the screen.
  3. -c30 : Total number of refreshes (30).
  4. -t : Spreadsheet includes top processes.
  5. -d disks : to increase the number of disks [default 256]
  6. -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:

Posted on Leave a comment

Epson WF3640/CUPS Problems – Raspberry Pi Forums

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
or

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.

Source: Epson WF3640/CUPS Problems – Raspberry Pi Forums

Posted on Leave a comment

Delay or schedule sending email messages – Outlook

Delay or schedule sending email messages

Outlook for Office 365, Outlook 2019, Outlook 2016, Outlook 2013, Outlook 2010
Other versions 
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

  1. While composing a message, select the More options arrow from the Tags group in the Ribbon.
    Select More Options to set a delivery delay.
  2. Under Delivery options, select the Do not deliver before check box, and then click the delivery date and time you want.
    Set a date and time to deliver your message.
  3. Click Close.
  4. 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:

  1. Switch to the Outbox folder.
  2. Open the delayed message.
  3. Select the More options arrow from the Tags group in the Ribbon.

    Select More Options to set a delivery delay.

  4. Under Delivery options, clear the Do not deliver before check box.
  5. Click Close and send.

Note: This feature works only when Outlook is in online mode.

Top of Page

Delay the delivery of all messages

You can delay the delivery of all messages by up to two hours by creating a rule.

  1. Click File.
  2. Click Manage Rules & Alerts.
  3. Click New Rule.
  4. 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.
  5. 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.

  6. In the Step 1: Select action(s) list, select the defer delivery by a number of minutes check box.
  7. 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.

  8. Click OK, and then click Next.
  9. Select the check boxes for any exceptions that you want.
  10. Click Next.
  11. In the Step 1: Specify a name for this rule box, type a name for the rule.
  12. Select the Turn on this rule check box.
  13. Click Finish.

After you click Send, each message remains in the Outbox folder for the time that you specified.

Top of Page

Compose a message now, but schedule it to be sent later.

Source: Delay or schedule sending email messages – Outlook

Posted on Leave a comment

Arch Linux – Cannot start CUPS service with systemd

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.

Create /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

Source: Arch Linux – Cannot start CUPS service with systemd