Posts

Showing posts from March, 2023

Things to know before admitting your kids to school

-
Here are few things that you must know or take care of before admitting your kids to school. If you are not taking care of these things, you might be putting you children to wrong school, risking life. Only irresponsible parents do this mistake who all do not love their children or one who are not serious about their children or one who are uneducated. So, let me guide you to few thins that you need to take care of before admitting your children to school. 1. See if school is registered to local registerer (respective government). 2. Check the classroom, bathroom, playground, kitchen, it needs to be clean. 3. Sit in the classroom for 5 to 10 min., see how they lecture children. 4. Check the school fee, other fee, transportation fee, see if you can afford. 5. Check the food they fed to children, how many times, they give food to children. 6. Check the school duration, start and end time, usually for children 4 to 8 hours, see for how long your student can sit in class. 7. Ask for holida...
Read more

How to Find Least Common Factor of Two or More Numbers in Excel

-
Image
The LCM function in Excel is used to find the least common multiple of one or more numbers. It takes two or more integer arguments as input and returns their least common multiple. Syntax: LCM(number1, [number2], ...) Here, number1 is the first number or range of numbers for which you want to find the LCM. [number2] is an optional second number or range of numbers for which you want to find the LCM. ... indicates that you can provide up to 255 additional numbers or ranges of numbers for which you want to find the LCM. For example, to find the LCM of three numbers (10, 12 and 15) stored in D1 to D3, you would use the formula: This would return the result 60, which is the least common multiple of those three numbers. Note that if any of the arguments are non-integer or non-numeric values, the LCM function returns the #VALUE! error. Additionally, if any of the arguments are negative or zero, the LCM function returns the #NUM! error.  
Read more

How to Shut Down a Task or Event using PowerShell

-
Image
In PowerShell, the Stop-Process cmdlet is used to stop one or more running processes on a Windows system. The syntax for the Stop-Process cmdlet is as follows: Stop-Process [-Name] <String[]> [-Force] [-WhatIf] [-Confirm] [-PassThru] [-ErrorAction <ActionPreference>] [-WarningAction <ActionPreference>] [-InformationAction <ActionPreference>] [-ErrorVariable <String>] [-WarningVariable <String>] [-OutVariable <String>] [-OutBuffer <Int32>] Where, -Name : Specifies the name of the process or processes to be stopped. This can be a single process name or an array of process names. -Force : Specifies that the process should be forcibly terminated. This can result in data loss or other issues, so use with caution. -WhatIf : Specifies that the cmdlet should not actually stop any processes, but instead show what would happen if the cmdlet were to run. -Confirm : Prompts the user to confirm before stopping any processes. -PassThru : Specifie...
Read more

How to Calculate Double Factorial of a Number in Excel

-
Image
The FACTDOUBLE function in Excel calculates the double factorial of a given number, which is the product of all the positive integers from 1 up to the given number that have the same parity (odd or even) as the given number. The syntax for the FACTDOUBLE function is as follows: FACTDOUBLE(number) For example, the double factorial of a number stored in D1  is calculated as follows: You can use the FACTDOUBLE function to calculate double factorials for various purposes, such as in probability and statistics problems or in combinatorics.  
Read more

How to Get Active Task List of Your PC using CMD

-
Image
In CMD (Command Prompt), the tasklist command is used to display a list of all currently running processes on a Windows system. The syntax for the tasklist command is as follows: tasklist [/s computer] [/u domain\user [/p password]] [/fo {TABLE|LIST|CSV}] [/nh] [/fi filter] [/m module] Where, /s computer : Specifies the name or IP address of a remote computer on which to display the list of processes. If this parameter is not specified, the list is displayed for the local computer. /u domain\user : Specifies the user name and domain or computer name of an account with administrative privileges on the remote computer. If this parameter is not specified, the command runs using the credentials of the currently logged-in user. /p password : Specifies the password for the account specified by the /u parameter. If this parameter is not specified, the user is prompted to enter the password. /fo : Specifies the output format to use. The default is "TABLE", but other options inclu...
Read more

How to Find Possible Combination of Number with Repetitions of Items in Excel

-
Image
The COMBINA function in Excel returns the number of combinations with repetitions for a given number of items. The syntax of the COMBINA function is as follows: COMBINA(number, number_chosen) Where, ·          number : The total number of items. ·          number_chosen : The number of items to be chosen in each combination. For example, if you want to calculate the number of combinations of 10 balls of 4 colours taken 2 at a time, you would use the following formula: Here, the same coloured balls are taken into account for 2 or 3 times. Note that the COMBINA function is only available in Excel 2016 and later versions.  
Read more

How to Export Running Process Details in Excel File using PowerShell

-
Image
In PowerShell, the Export-CSV command is used to export the output of a command or script to a CSV file. The CSV file format is a commonly used format for storing tabular data, which can then be opened in spreadsheet applications like Microsoft Excel or Google Sheets. The syntax for the Export-CSV command is as follows: Export-Csv [-Path] <String> [-Delimiter <Char>] [-Encoding <String>] [-NoTypeInformation] [-Force] [-Append] [-InputObject <PSObject[]>] [<CommonParameters>] Where:   -Path : Specifies the path and file name of the CSV file to be created. This can be a local file path or a UNC path to a shared folder. -Delimiter : Specifies the character to use as the delimiter between fields in the CSV file. The default is a comma (,), but other options include semicolon (;), tab (\t), or any other single character. -Encoding : Specifies the character encoding to be used for the CSV file. The default is ASCII, but other options include Unicode, UTF...
Read more

How to Find Possible Combination of Number of Items in Excel

-
Image
The COMBIN function in Excel is used to calculate the number of combinations for a given number of items. It returns the number of combinations for a given number of objects and the number of objects to be chosen at a time. The syntax for the COMBIN function is as follows: COMBIN(number, number_chosen) Where: ·          number : the total number of objects to choose from ·          number_chosen : the number of objects to choose For example, if you want to calculate the number of combinations of 10 objects taken 2 at a time, you would use the following formula: Note that the order of the objects does not matter in a combination, and that repetitions are not allowed. If repetitions are allowed, you should use the COMBINATIONS function instead.
Read more

How to Generate a HTML Report of Events from PowerShell

-
Image
The ConvertTo-HTML command in PowerShell is used to convert PowerShell objects into HTML format for displaying the output in a web page or HTML file. The ConvertTo-HTML command generates an HTML table that contains the properties and values of the objects being converted. The syntax for the ConvertTo-HTML command is as follows: ConvertTo-Html [[-Property] <Object[]>] [-As <String>] [-Body <String>] [-CSSUri <String>] [-Fragment] [-Head <String>] [-PostContent <String>] [-PreContent <String>] [-Title <String>] [-UseDefaultCSS] [<CommonParameters>] Where: -Property : Specifies the object properties to be included in the HTML table. -As : Specifies the format of the output, which can be "Fragment" or "Page". -Body : Specifies the HTML content to be inserted into the body section of the HTML document. -CSSUri : Specifies the URL of the CSS file to be used for styling the HTML t...
Read more

How to Find Largest Common Factor between Some Numbers in Excel

-
Image
The GCD (Greatest Common Divisor) function in Excel calculates the largest common factor between two or more numbers. The syntax for the GCD function is: GCD(number1, [number2], ...) Where number1 , number2 , etc. are the values for which you want to find the GCD. For example, to find the largest common factor of some numbers stored in D column, you would use the GCD formula: Note that the GCD function can accept up to 255 arguments and evaluates empty cells as zero. Furthermore, GCD works with integers; decimal values are removed before calculation. If arguments contain a non-numeric value. GCD returns the #VALUE! error.  
Read more

How to Fetch Event Log of Your Computer using PowerShell

-
Image
The "Get-EventLog" command is a built-in cmdlet in Windows PowerShell that retrieves events and event logs from the local computer or a remote computer. The syntax of the "Get-EventLog" command is: Get-EventLog [-LogName] <string> [-After <datetime>] [-Before <datetime>] [-InstanceId <int[]>] [-EntryType {Error | Information | FailureAudit | SuccessAudit | Warning}] [-Source <string[]>] [-Message <string>] [-Newest <int>] [-ComputerName <string[]>] [<CommonParameters>] Where: -LogName specifies the name of the event log to retrieve events from (e.g. "Application", "System", "Security", etc.). -After and -Before specify the range of dates to retrieve events for. -InstanceId specifies the event ID(s) to retrieve. -EntryType specifies the type of event to retrieve (e.g. Error, Information, Warning, etc.).   -Source specifies the event source(s) to retrieve. -Message specifies ...
Read more

How to Do Aggregate Calculations in Excel

-
Image
The AGGREGATE function in Excel allows you to perform a variety of aggregate calculations (e.g. SUM, AVERAGE, MAX, MIN, COUNT) on a range of cells, while ignoring any errors or hidden cells. This function is particularly useful when working with large data sets that may contain errors or blank cells. The syntax for the AGGREGATE function is: AGGREGATE(function_num, options, array, [k]) Where: function_num is the number that specifies which aggregate function to use (e.g. 1 for AVERAGE, 2 for COUNT, 3 for MAX, etc.) options is a number that specifies which values to ignore in the calculation (e.g. 2 to ignore any error values, 3 to ignore any hidden cells, 4 to ignore both errors and hidden cells) array is the range of cells or array constant to perform the calculation on k is an optional argument that specifies which value to return when function_num is set to 5 (which calculates the k-th largest value in the range). If k is omitted, the function returns the largest value. F...
Read more

How to Know about Windows PowerShell

-
Image
The "Get-Help" command is a built-in cmdlet in Windows PowerShell that provides information about PowerShell commands, concepts, and modules. The syntax of the "Get-Help" command is: Get-Help <command-name> Where <command-name> is the name of the command you want to get help for. For example, to get help for the "Get-Process" command, you would enter: Get-Help Get-Process By default, the "Get-Help" command displays the basic syntax, a brief description, and the list of available parameters for the specified command. It also includes examples of how to use the command and links to related topics. You can also use the "-Detailed" and "-Full" parameters to get more detailed information about the command, including examples, input and output types, and other relevant details. For example, to get detailed help for the "Get-Process" command, you would enter: Get-Help Get-Process -Detailed To ...
Read more

How to Find the Factorial of a Number in Excel

-
Image
The FACT function is an Excel math and trigonometry function that returns the factorial of a given number. The factorial of a number is the product of all the positive integers from 1 to that number. Syntax: FACT(number) Where number is the positive integer for which you want to find the factorial. Suppose you want to find the factorial of numbers stored in C column. You can use the FACT function in Excel as follows: Note that, any number cannot be negative or FACT function will return the #NUM error.
Read more

How to Find Computer Name using CMD

-
Image
In CMD (Command Prompt), the hostname command is used to display the name of the computer or device on which the command prompt is running. The syntax for the hostname command is as follows: hostname When you run the hostname command in CMD, it will simply display the name of the computer or device on which the command prompt is running. For example, if you want to find your computer name, you can easily type the command like this: This command is useful when you need to identify the name of the computer in a network or when troubleshooting network connectivity issues. Additionally, the hostname can be used in batch scripts or other command-line utilities to dynamically reference the name of the computer in commands and paths.  
Read more

How to Calculate Periodic Payment for a Loan in Excel

-
Image
The PMT function in Excel is used to calculate the payment amount for a loan or an investment. It takes into account the interest rate, number of payments, and the present value or future value of the loan or investment. The syntax for the PMT function is as follows: PMT(rate, nper, pv, [fv], [type]) Where: rate is the interest rate per period.   nper is the total number of payment periods in the investment or loan. pv is the present value, or the amount that a series of future payments is worth now. fv is the future value, or a cash balance you want to attain after the last payment is made. If this argument is omitted, it is assumed to be 0. type specifies when payments are due. If this argument is omitted, it is assumed to be 0 (payments are due at the end of the period). If type is 1, payments are due at the beginning of the period. For example, to calculate the monthly payment for a $10,000 loan with an annual interest rate of 5%, to be paid off in 5 years, with payments ...
Read more

How to Check Internet Connectivity using CMD

-
Image
In CMD (Command Prompt), the ping command is used to test the internet connectivity or short distance connectivity between two devices on a network. The ping command sends a small packet of data to a destination IP address and waits for a response. The response time and success or failure of the ping can help diagnose network connectivity issues. The syntax for the ping command is as follows: ping [-t] [-a] [-n count] [-l size] [-f] [-i TTL] [-v TOS] [-r count] [-s count] [-w timeout] target_name Where: -t : Sends a continuous ping until stopped by pressing Ctrl+C. -a : Resolves IP addresses to host names. -n count : Specifies the number of ping packets to send. -l size : Specifies the size of the ping packet in bytes. -f : Sets the "Do not fragment" flag in the ping packet. -i TTL : Sets the Time-to-Live (TTL) value in the ping packet. -v TOS : Sets the Type-of-Service (TOS) value in the ping packet. -r count : Re...
Read more