Consolidating nutrition and price data from multiple sources into one Excel dashboard
I maintain a single Excel workbook that tracks breakfast-menu items calories, macros, allergens, and local prices pulled from several public sources like https://mcd-breakfast-menu.com/. Each source formats its table differently: some list energy in kcal and others in kJ; decimal separators flip between commas and periods; prices appear in four currencies. After each monthly update I hand-copy tables into a Raw sheet and try to normalise them with Power Query and a few LET and LAMBDA functions, but one extra column or unit change breaks my mapping. Has anyone built a durable workflow for problems like this? I am looking for ideas on (1) keeping unit conversions transparent so a non-Excel colleague can audit the maths, (2) alerting me when a source table adds or removes a column so the model does not shift silently, and (3) deciding whether to keep all cleanup in Power Query or move some logic into hidden staging sheets. Any real-world templates or processes would be welcome.
Excel file change date and time
English: I use Excel on my cell phone and recently it stopped updating the file change date. As soon as I make a change to the file it shows the current date and time, which would be the time I last changed the file. But after a few seconds it returns to an old date and time change, how can I solve this? Português: Eu uso o Excel pelo celular e recentemente ele parou de atualizar a data de alteração dos arquivos. Assim que faço a alteração no arquivo ele mostra a data e hora atual, que seria a hora que alterei o arquivo pela última vez. Mas passado alguns segundos ele volta pra uma data e hora de alteração antiga, como posso resolver isso?
Integrate QR or Barcodes into Excel for Ongoing Data Entry into a Single Row?
As we continue to streamline data collection processes, I’m exploring whether it’s possible to use QR codes or barcodes to simplify and automate Excel-based data entry. Specifically, I’m curious if there’s a method that allows multiple scans—each representing a different datapoint—to populate and update a single row over time, rather than creating new rows for each scan. This would be especially useful in scenarios like tracking lab testing, equipment checkouts, or multi-stage workflows where data accumulates progressively. Has anyone implemented a system like this using Exce or any other tools? What hardware or software integrations (e.g., barcode scanners, mobile apps, Excel add-ins) have worked best for you?
With Office 365 Excel Online, Edge iPadoS 17.1.1, how to reference this from other Workbook?
I need help to reference separate Workbook using Office 365 Excel Online on ipadOS 17.1.1. Following steps worked for Windows desktop but not in with Office 365 Excel Online. open two instances of Edge login Office 365 for step 1 Open a workbook A in instance 1 Open a workbook B in instance 2 In cell of Workbook A, type in equal Sign Then click on Workbook B cellVisual and dax level optimization that causes report slowdown
Hi, I have this visual as attached, that has lot of visual level filters applied it has a dax measure called data completeness as below Data Completeness = var _total = COUNT('Calendar'[Date])*COUNT(Points[DBName-Point_Id]) var _result = [Count of Exisitng Days]/_total return _result It references a dax called Count of Exisitng Days as below Count of Exisitng Days = Var dates = SUMMARIZE(Data, Data[DBName-Point_Id], Data[Date]) Var Ext_dates = COUNTROWS(dates) return Ext_dates Now, the problem I have here is the performance of this visual is causing report to slow down. Please let me know how to optimize the dax and further steps to increase the performance PFA file here https://1drv.ms/u/c/cfada767f73d87ed/Efl-4uYzkklNjOb1NakC9cEB7B7xXbhHb-w-K3TpvooIjw?e=zpfwXe Thanks in advance! SergeiBaklan
