Point Excel at the folder your weekly files land in, and the master report rebuilds itself on open

Get Data, From Folder How-To Geek's Tony Phillips names each week's file to a pattern, drops it in one folder beside a master workbook, then uses Data, Get Data, From File, From Folder and Transform Data to open Power Query, filters the Name column with Text Filters, Does Not Begin With so the master stays out of its own query, hits Combine Files in the Content column header, picks the worksheet name and clicks Close and Load; from then on a new week needs only Refresh All on the Data tab, or nothing at all once Refresh data when opening the file is ticked in the query's Properties, and his stated conditions are Power Query plus identical worksheet names, column headings and structure in every file.

powercfg, then a browser MakeUseOf's Isaac Akinleye opens PowerShell or Command Prompt as an administrator, runs powercfg /batteryreport with an output path of C:\battery-report.html, and opens that file in a browser, where the installed battery section put his design capacity at 41,051 mWh against a 26,445 mWh full charge, a 64.4% retention, next to sections for installed batteries, recent usage, usage history, capacity history and the life estimates; he is straight about what it cannot do, since the report will not predict when a battery stops working or explain why the energy went, the cycle count comes back blank on some laptops, the history only reaches back to the last Windows install, and the capacity figures fluctuate enough that the trend matters more than any single row.

Seven codes, one generator MakeUseOf's Oluwademilade Afolabi builds codes at QRCode Monkey for guest Wi-Fi access, a vCard contact card, a calendar event a phone can import, a Google Maps pin, a label that links a storage box to its inventory list, a pre-filled email draft and plain text, noting that Pixel, Galaxy and iPhone settings can generate the Wi-Fi code natively; his cautions are to test a calendar code on both Android and iPhone before printing a batch, to keep vCard details lean so the pattern does not grow too dense, to keep genuinely sensitive material such as a password or an API key out of a code, to remember that whoever scans a link still needs permission to open it, and to verify an unfamiliar code before scanning it, because a code hides its contents from human eyes.