Get week number of month from Date

People struggle a lot when it needs to get a week from a date, here below is a simple example to get the week number of the month from a Date.

function getWeekOfMonth(date) { let adjustedDate = date.getDate()+date.getDay(); let prefixes = ['1', '2', '3', '4', '5','6']; return (parseInt(prefixes[0 | adjustedDate / 7])+1); }

Responsive and Animated Pie Charts with HTML and CSS

Responsive and Animated Pie Charts

/////////////////// // HTML ////////////////// body { font-family: "Open Sans", Arial; background: #EEE; text-align: center; } body * { font-weight: 300; margin: 0; padding: 0; } @-webkit-keyframes bake-pie { from { transform: rotate(0deg) translate3d(0, 0, 0); } } @keyframes bake-pie { from { transform: rotate(0deg) translate3d(0, 0, 0); } } .pie-chart { font-family: "Open Sans", Arial; } .pie-chart--wrapper { width: 400px; margin: 30px auto; text-align: center; } .pie-chart__pie, .pie-chart__legend { display: inline-block; vertical-align: top; } .pie-chart__pie { position: relative; height: 200px; width: 200px; margin: 10px auto 35px; } .pie-chart__pie::before { content: ""; display: block; position: absolute; z-index: 1; width: 100px; height: 100px; background: #EEE; border-radius: 50%; top: 50px; left: 50px; } .pie-chart__pie::after { content: ""; display: block; width: 120px; height: 2px; background: rgba(0, 0, 0, 0.1); border-radius: 50%; box-shadow: 0 0 3px 4px rgba(0, 0, 0, 0.1); margin: 220px auto; } .slice { position: absolute; width: 200px; height: 200px; clip: rect(0px, 200px, 200px, 100px); -webkit-animation: bake-pie 1s; animation: bake-pie 1s; } .slice span { display: block; position: absolute; top: 0; left: 0; background-color: black; width: 200px; height: 200px; border-radius: 50%; clip: rect(0px, 200px, 200px, 100px); } .pie-chart__legend { display: block; list-style-type: none; padding: 0; margin: 0 auto; background: #FFF; padding: 0.75em 0.75em 0.05em; font-size: 13px; box-shadow: 1px 1px 0 #DDD, 2px 2px 0 #BBB; text-align: left; width: 65%; } .pie-chart__legend li { height: 1.25em; margin-bottom: 0.7em; padding-left: 0.5em; border-left: 1.25em solid black; } .pie-chart__legend em { font-style: normal; } .pie-chart__legend span { float: right; } .pie-charts { display: flex; flex-direction: row; } @media (max-width: 500px) { .pie-charts { flex-direction: column; } } /////////////// // HTML /////////////// <div class="wrapper"> <h1>Answered Questions</h1> <div class="pie-charts"> <div class="pieID--micro-skills pie-chart--wrapper"> <h2>Micro-Skills</h2> <div class="pie-chart"> <div class="pie-chart__pie"></div> <ul class="pie-chart__legend"> <li><em>Additive</em><span>642</span></li> <li><em>Multiplicative</em><span>358</span></li> </ul> </div> </div> <div class="pieID--categories pie-chart--wrapper"> <h2>Categories</h2> <div class="pie-chart"> <div class="pie-chart__pie"></div> <ul class="pie-chart__legend"> <li><em>Horizontal</em><span>768</span></li> <li><em>Vertical</em><span>232</span></li> </ul> </div> </div> <div class="pieID--operations pie-chart--wrapper"> <h2>Operations</h2> <div class="pie-chart"> <div class="pie-chart__pie"></div> <ul class="pie-chart__legend"> <li><em>Addition</em><span>486</span></li> <li><em>Subtraction</em><span>156</span></li> <li><em>Multiplication</em><span>215</span></li> <li><em>Division</em><span>143</span></li> </ul> </div> </div> </div> </div> ///////////////// //JQuery ///////////////// function sliceSize(dataNum, dataTotal) { return (dataNum / dataTotal) * 360; } function addSlice(id, sliceSize, pieElement, offset, sliceID, color) { $(pieElement).append("<div class='slice "+ sliceID + "'><span></span></div>"); var offset = offset - 1; var sizeRotation = -179 + sliceSize; $(id + " ." + sliceID).css({ "transform": "rotate(" + offset + "deg) translate3d(0,0,0)" }); $(id + " ." + sliceID + " span").css({ "transform" : "rotate(" + sizeRotation + "deg) translate3d(0,0,0)", "background-color": color }); } function iterateSlices(id, sliceSize, pieElement, offset, dataCount, sliceCount, color) { var maxSize = 179, sliceID = "s" + dataCount + "-" + sliceCount; if( sliceSize <= maxSize ) { addSlice(id, sliceSize, pieElement, offset, sliceID, color); } else { addSlice(id, maxSize, pieElement, offset, sliceID, color); iterateSlices(id, sliceSize-maxSize, pieElement, offset+maxSize, dataCount, sliceCount+1, color); } } function createPie(id) { var listData = [], listTotal = 0, offset = 0, i = 0, pieElement = id + " .pie-chart__pie" dataElement = id + " .pie-chart__legend" color = [ "cornflowerblue", "olivedrab", "orange", "tomato", "crimson", "purple", "turquoise", "forestgreen", "navy" ]; color = shuffle( color ); $(dataElement+" span").each(function() { listData.push(Number($(this).html())); }); for(i = 0; i < listData.length; i++) { listTotal += listData[i]; } for(i=0; i < listData.length; i++) { var size = sliceSize(listData[i], listTotal); iterateSlices(id, size, pieElement, offset, i, 0, color[i]); $(dataElement + " li:nth-child(" + (i + 1) + ")").css("border-color", color[i]); offset += size; } } function shuffle(a) { var j, x, i; for (i = a.length; i; i--) { j = Math.floor(Math.random() * i); x = a[i - 1]; a[i - 1] = a[j]; a[j] = x; } return a; } function createPieCharts() { createPie('.pieID--micro-skills' ); createPie('.pieID--categories' ); createPie('.pieID--operations' ); } createPieCharts();

Thanks to Temani Afif, code on CodePen.

OutPut

Micro-Skills

• Additive642
• Multiplicative358

Categories

• Horizontal768
• Vertical232

Operations

• Addition486
• Subtraction156
• Multiplication215
• Division143

Excel - Add and Remove Line Breaks in a Cell

Many time we struggle for the line break in a multiple excel cells. This article have some useful tricks that will help you to achive this easily.

1) Manully add line break in a cell using "Alt + Enter".
- Edit the cell with F2 or while typing in a cell when you press "Alt + Enter" it will create new line in a cell.
- To remove a line break, edit the cell with F2, go to the start of line break and press "Backspace" and enter.

2) Line break using formula:
- You can use line break character in CHAR(10) function. Here 10 is the line break character.
- example: CONCATENATE("Rakesh" , CHAR(10) , "Patel"), if you can't see the line break when you  press ENTER, then apply WRAP TEXT to the cell.

3) Replace "," or any other character with New Line:
- Press CTRL + H, this will open "Find and Replace" window. Under "Find what" you can put your text that you want to search. and under "Replace with" press CTRL + J (you won't able to see anything) just click on "Replace" or "Replace ALL". This will will add line break wherever it finds your text.
- The same way you can replace Line break with any of your text.

If "CTRL + J" does not work for you then you can also try Alt + type 0010. 

Delete Files and Subfolders from SharePoint Library using PowerShell

Make life easy with PowerShell, following script will help you to delete all files and subfolders in One Go.

#Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser #Install-Module SharePointPnPPowerShellOnline #Config Variables $SiteURL = "https://mydomain.sharepoint.com/site" $ListName ="my_DocLib" $FolderServerRelativeURL = "/site/my_DocLib" Try { #Connect to PnP Online Connect-PnPOnline -Url $SiteURL -UseWebLogin #Get All Items from Folder in Batch $ListItems = Get-PnPListItem -List $ListName -FolderServerRelativeUrl $FolderServerRelativeURL -PageSize 2000 | Sort-Object ID -Descending #Powershell to delete all files from folder ForEach ($Item in $ListItems) { Remove-PnPListItem -List $ListName -Identity $Item.Id -Recycle -Force Write-host "Removed File:"$Item.FieldValues.FileRef } } Catch { write-host "Error: $($_.Exception.Message)" -foregroundcolor Red }

number to word in Microsoft Word using formula

 

Press Ctrl + F9 to write mathematical equations and you get { }.

write the formula as: { =123456\*cardtext } and press Alt + F9

Output:

one hundred twenty-three thousand four hundred fifty-six

Use of Equations in Microsoft word.

Many of us don't know that we can do calculations and put equations in Microsoft Word. Below is the way you can put equations in any version of Microsoft Word.

Note:   If an "error" message comes, right-click it and select the toggle field code and make the correction.

Javascript Tips and Best Practices

1. Check property exists in an object

const emp = { empno : 1, name : 'rakesh', salary : 50000 }; const keySalaryExist = 'salary' in emp; console.log (keySalaryExist); // true const keyGenderExist = 'gender' in emp; console.log (keyGenderExist); // false

The in operator returns the boolean value true/false.
The in operator returns true if a property exists in the object or its prototype chain.

2. String to a number using the plus (+) operator

const num = '101'; console.log(+num); // 101 as string console.log(typeof +code) // 101 as number

The unary plus operator (+) is the fastest and preferred way of converting something into a number.

3. Mask numbers using slice and padStart

const adharNumber = '1234567890123456'; const last4Number = adharNumber.slice(-4); const maskadharNumber = last4Number.padStart(adharNumber.length,'*'); console.log(maskadharNumber); // output : ************3456

The slice() method returns selected elements in an array, as a new array. Negative numbers select from the end of the array.
The padStart() method pads the current string with another string until the resulting string reaches the given length. The padding is applied from the start of the current string.

4. Swap two variables

let num1 = 10; let num2 = 20; [num1,num2] = [num2, num1]; console.log(num1); // 20; console.log(num2); // 10;

Use destructuring assignment approach because it is short and expressive. Swapping is performed in just one line statement. It works with any data type like numbers, strings, booleans, or objects.

5. Check every element of the array using Array.every

const employees = [ {empno:1, name:'Suresh',designation:'Mgr',salary:8000}, {empno:2, name:'Suresh',designation:'Sales',salary:6000}, {empno:3, name:'Suresh',designation:'Mgr',salary:7000} ] const isAllMgr = employees.every((m) => m.designation === 'Mgr'); const salGt5K = employees.every((m) => m.salary > 5000); console.log(isAllMgr); // false; console.log(salGt5K); // true;

The Array every() method checks whether all the array elements pass the test implemented by the provided function.
It returns true if the function returns true for all elements.
It returns false if the function returns false for one element. When every() finds a false result, it will stop the loop and continue no more which improves the performance. The every() method does not change the original array.

6. Use of nullish coalescing operator with numbers

I have use lot of time || operator for the logical disjunction, but it ends when value is 0 in the variable. So found better way to handle this. let num1 = 0; let num2; const defaultNum1 = num1 || 1; const defaultNum2 = num2 || 2; console.log(defaultNum1); // 1; // as value is 0, it return 1 console.log(defaultNum2); // 2; // insted of using || let use ?? const defaultNum1 = num1 ?? 1; const defaultNum2 = num2 ?? 2; console.log(defaultNum1); // 0; console.log(defaultNum2); // 2;

A Nullish value is a value that is either null or undefined.
The Nullish Coalescing Operator (??) is a logical operator that accepts two values and returns the second value if the first one is null or undefined and otherwise returns the first value.

7. Filter Array with only values

Many times we have an issue with array to have empty values and need to handle we write extra code. To avoid it just you have to use filter(). let arr1 = [7,null,10,false,11] let arrval1 = arr1.filter(Boolean) console.log(arrval1) let arr2 = ['rakesh',null,,0,100,'patel'] let arrval2 = arr2.filter(Boolean) console.log(arrval2)

Pass the Boolean to Array.filter as the first argument.