Month: June 2024
Forumlas to use for horizontal data entry
Hello,
I am trying to create a spreadsheet that will use a master list of data across two columns and then sync with other pages in the same workbook to produce mini lists for each subset of data.
Ultimately I want to have one list with the source data e.g.
That then links to other sheets but auto fills when the user starts typing the code in across three cells e.g. user would enter the data into ‘unit code’ area below and once the pattern had been identified in cell B5 the information would automatically fill into cells C5 and D5
I believe this can be done using an IF formula and Vlookup but am just not sure how to execute this. Any help on where to look or how to do this would be great!
Hello, I am trying to create a spreadsheet that will use a master list of data across two columns and then sync with other pages in the same workbook to produce mini lists for each subset of data. Ultimately I want to have one list with the source data e.g. That then links to other sheets but auto fills when the user starts typing the code in across three cells e.g. user would enter the data into ‘unit code’ area below and once the pattern had been identified in cell B5 the information would automatically fill into cells C5 and D5 I believe this can be done using an IF formula and Vlookup but am just not sure how to execute this. Any help on where to look or how to do this would be great! Read More
Right-click photo in Word document to save as a separate file not working
Hi
I have a Word document with a photo included. I need to save the photo as a separate *.jpeg file. When right-clicking the photo, Save as Picture doesn’t appear.
How can I save this image??
Thanks.
HiI have a Word document with a photo included. I need to save the photo as a separate *.jpeg file. When right-clicking the photo, Save as Picture doesn’t appear. How can I save this image??Thanks. Read More
Sharing links and Direct access – Link settings
In July 2023, Microsoft tried to improve the sharing experience. https://techcommunity.microsoft.com/t5/microsoft-onedrive-blog/feature-deep-dive-simplified-sharing-across-microsoft-365/ba-p/3883566
Unfortunately, it is still extremely confusing.
Could you please confirm that the link settings (Anyone, People in, People with existing access, People you choose) are not relevant when you choose ‘Share’ and click the button ‘Send’?
It is not explained this way on the official support page https://support.microsoft.com/en-us/office/share-sharepoint-files-or-folders-1fe37332-0f9a-4719-970e-d2578da4941c but from my testing the link settings apply to the button ‘Copy link’ only.
I’m trying to make a sense out of the sharing experience in this article Understanding Sharing and how it could be improved | KTNN SharePoint (wordpress.com)
In July 2023, Microsoft tried to improve the sharing experience. https://techcommunity.microsoft.com/t5/microsoft-onedrive-blog/feature-deep-dive-simplified-sharing-across-microsoft-365/ba-p/3883566 Unfortunately, it is still extremely confusing. Could you please confirm that the link settings (Anyone, People in, People with existing access, People you choose) are not relevant when you choose ‘Share’ and click the button ‘Send’? It is not explained this way on the official support page https://support.microsoft.com/en-us/office/share-sharepoint-files-or-folders-1fe37332-0f9a-4719-970e-d2578da4941c but from my testing the link settings apply to the button ‘Copy link’ only. I’m trying to make a sense out of the sharing experience in this article Understanding Sharing and how it could be improved | KTNN SharePoint (wordpress.com) Read More
configure hybrid with exchange 2016
Hi,
while conifugring hybrid configuration with exchange 2016 I am getting this error any kind of advice will great.
An unexpected result was received from Windows Live. Detailed information: “1007 AccessDenied: Access Denied.
FullyQualifiedErrorId=[System.String] [Server=EXCH2K16MBX01,RequestId=91a5-66dbfb369da5,TimeStamp=6/25/2024 6:20:36 PM] [FailureCategory=Cmdlet-ProvisioningFederatedExchangeException] 83B7E757,Microsoft.Exchange.Management.SystemConfigurationTasks.SetFederatedOrganizationIdentifier} —> System.Management.Automation.RemoteException: An error occurred while attempting to provision Exchange to the Partner STS. Detailed Information “An unexpected result was received from Windows Live. Detailed information: “1007 AccessDenied: Access Denied.”.”
Hi,while conifugring hybrid configuration with exchange 2016 I am getting this error any kind of advice will great. An unexpected result was received from Windows Live. Detailed information: “1007 AccessDenied: Access Denied.FullyQualifiedErrorId=[System.String] [Server=EXCH2K16MBX01,RequestId=91a5-66dbfb369da5,TimeStamp=6/25/2024 6:20:36 PM] [FailureCategory=Cmdlet-ProvisioningFederatedExchangeException] 83B7E757,Microsoft.Exchange.Management.SystemConfigurationTasks.SetFederatedOrganizationIdentifier} —> System.Management.Automation.RemoteException: An error occurred while attempting to provision Exchange to the Partner STS. Detailed Information “An unexpected result was received from Windows Live. Detailed information: “1007 AccessDenied: Access Denied.”.” Read More
New Teams’ Contact Cards will randomly stop displaying
Hello,
Ever since the company I work for switched to New Teams a rather annoying bug started happening at a seemingly random pattern: hovering the mouse pointer over a contact won’t trigger the display of it’s contact card.
I’m sure it is not a local-machine issue since, from talking to coworkers, I’ve found out that this is rather widespread. I’ve also seen a variety of posts in Microsoft’s Community Forums regarding this issue, some that date back to 2023, and it clearly hasn’t been properly addressed by any Microsoft staff so far.
I’ve seen a variety of tweaks that do manage to, sometimes, bring it back temporarily. Those were always suggested by users. I haven’t seen a single response from Microsoft’s staff in this forum regarding this matter that was actually useful. Most times it’s actual non-sense, such as clearing Chrome or Edge’s cache or messing with the Members’ Settings under teams tab within the application (which also didn’t seem to work for anyone, since these replies never get a single upvote but rather angry responses).
Do we have any actually useful suggestions on how to tackle this issue?
Best regards,
Rafael.
Hello, Ever since the company I work for switched to New Teams a rather annoying bug started happening at a seemingly random pattern: hovering the mouse pointer over a contact won’t trigger the display of it’s contact card. I’m sure it is not a local-machine issue since, from talking to coworkers, I’ve found out that this is rather widespread. I’ve also seen a variety of posts in Microsoft’s Community Forums regarding this issue, some that date back to 2023, and it clearly hasn’t been properly addressed by any Microsoft staff so far. I’ve seen a variety of tweaks that do manage to, sometimes, bring it back temporarily. Those were always suggested by users. I haven’t seen a single response from Microsoft’s staff in this forum regarding this matter that was actually useful. Most times it’s actual non-sense, such as clearing Chrome or Edge’s cache or messing with the Members’ Settings under teams tab within the application (which also didn’t seem to work for anyone, since these replies never get a single upvote but rather angry responses). Do we have any actually useful suggestions on how to tackle this issue? Best regards,Rafael. Read More
Can’t find Control Panel on Windows Insider
I’ve been using the operating system for a while now, but suddenly I can’t seem to locate the Control Panel anywhere. I’ve tried searching for it in the Start menu, checking the Taskbar, and even looking in the Settings app, but it’s nowhere to be found. I’ve checked online for solutions, but none of the usual troubleshooting steps have worked for me. Has anyone else experienced this issue or know how I can get my Control Panel back?
I’ve been using the operating system for a while now, but suddenly I can’t seem to locate the Control Panel anywhere. I’ve tried searching for it in the Start menu, checking the Taskbar, and even looking in the Settings app, but it’s nowhere to be found. I’ve checked online for solutions, but none of the usual troubleshooting steps have worked for me. Has anyone else experienced this issue or know how I can get my Control Panel back? Read More
Something wrong when I run the project in PX4 Autopilot in Hardware-in-the-Loop (HITL) Simulation with UAV Dynamics in Simulink
I run the project from PX4 Autopilot in Hardware-in-the-Loop (HITL) Simulation with UAV Dynamics in Simulink, it is a example that build flight control algorithem and deploy it into the flight controller, i have set up the Hardware Board to PX4 Pixhawk 4 and click build, deploy and run, and then something wrong came up:
The module ‘Quadcopter_ControllerWithNavigation/Position & Rate Controller/Controller/Quaternion Validity Check/Quaternion Norm’ cannot check out a license. This module requires one of the following licenses: ‘Aerospace Blockset’.
(sorry, i can’t find red text button)
this information came in twice.
I run
license(‘test’, ‘Aerospace_Blockset’)
and the answer is 1，which means it is working(i guess). The reason why the answer is 1, is because i follow the gpt’s instruction, change the path.
How can I fix this problem?
Thank you for your answers.I run the project from PX4 Autopilot in Hardware-in-the-Loop (HITL) Simulation with UAV Dynamics in Simulink, it is a example that build flight control algorithem and deploy it into the flight controller, i have set up the Hardware Board to PX4 Pixhawk 4 and click build, deploy and run, and then something wrong came up:
The module ‘Quadcopter_ControllerWithNavigation/Position & Rate Controller/Controller/Quaternion Validity Check/Quaternion Norm’ cannot check out a license. This module requires one of the following licenses: ‘Aerospace Blockset’.
(sorry, i can’t find red text button)
this information came in twice.
I run
license(‘test’, ‘Aerospace_Blockset’)
and the answer is 1，which means it is working(i guess). The reason why the answer is 1, is because i follow the gpt’s instruction, change the path.
How can I fix this problem?
Thank you for your answers. I run the project from PX4 Autopilot in Hardware-in-the-Loop (HITL) Simulation with UAV Dynamics in Simulink, it is a example that build flight control algorithem and deploy it into the flight controller, i have set up the Hardware Board to PX4 Pixhawk 4 and click build, deploy and run, and then something wrong came up:
The module ‘Quadcopter_ControllerWithNavigation/Position & Rate Controller/Controller/Quaternion Validity Check/Quaternion Norm’ cannot check out a license. This module requires one of the following licenses: ‘Aerospace Blockset’.
(sorry, i can’t find red text button)
this information came in twice.
I run
license(‘test’, ‘Aerospace_Blockset’)
and the answer is 1，which means it is working(i guess). The reason why the answer is 1, is because i follow the gpt’s instruction, change the path.
How can I fix this problem?
Thank you for your answers. simulink, add-on, aerospace blockset MATLAB Answers — New Questions
Copy a user selected folder
I am try to create a prompt where the user can select a folder and then this folder is copied to a new locationsuch as:
file = input(‘What folder would you like to copy?’);
selected_dir = uigetdir();
and the copy the selected folder to a new location: i.e
test Folder source = selected_dir
copyfile(‘test Folder source’,’C:TEMPtest Folder destination’)
if there a clean way to make such a function?I am try to create a prompt where the user can select a folder and then this folder is copied to a new locationsuch as:
file = input(‘What folder would you like to copy?’);
selected_dir = uigetdir();
and the copy the selected folder to a new location: i.e
test Folder source = selected_dir
copyfile(‘test Folder source’,’C:TEMPtest Folder destination’)
if there a clean way to make such a function? I am try to create a prompt where the user can select a folder and then this folder is copied to a new locationsuch as:
file = input(‘What folder would you like to copy?’);
selected_dir = uigetdir();
and the copy the selected folder to a new location: i.e
test Folder source = selected_dir
copyfile(‘test Folder source’,’C:TEMPtest Folder destination’)
if there a clean way to make such a function? prompt, copy, uigetdir MATLAB Answers — New Questions
What to Do When You Encounter Q.B Error Code 15227
What should I do when I encounter Quick-Books Error Code 15227? This error occurs during pay roll updates or system startup. I’ve tried restarting my computer and updating Q.B, but the problem persists. Can anyone provide detailed troubleshooting steps to fix this issue?
What should I do when I encounter Quick-Books Error Code 15227? This error occurs during pay roll updates or system startup. I’ve tried restarting my computer and updating Q.B, but the problem persists. Can anyone provide detailed troubleshooting steps to fix this issue? Read More
Practical Graph: Report Details of Teams Online Meetings
The arrival of new Teams audit events allows tenants to analyze data about Teams online meetings. However, the data available in the audit events is incomplete, and the only way to get a full picture is through the Graph APIs. This article explains how to find Teams Online meetings in user calendars, extract information about the meetings, and generate an HTML report.
https://practical365.com/teams-online-meetings-report/
The arrival of new Teams audit events allows tenants to analyze data about Teams online meetings. However, the data available in the audit events is incomplete, and the only way to get a full picture is through the Graph APIs. This article explains how to find Teams Online meetings in user calendars, extract information about the meetings, and generate an HTML report.
https://practical365.com/teams-online-meetings-report/ Read More
MƎXC Refərans Kod u: 17Hjw
MƎXC Refərans Kod u: “17Hjw” olarak kullanilir. Dünyada en çok kullanılan, ömür boyu geçerli, en yüksek indirim oranına sahip MƎXC refərans kod udur.
MƎXC kripto para borsasına kayıt olurken “Davet Kod u” yazan yere “17Hjw” yazınız. Alacağınız işlem ücreti indirimi % 100’dür. Ayrıca 1000$ USDT komisyon iade bonusu alacaksınız.
Kripto para borsası MƎXC Refərans Kod u: “17Hjw” ile vadeli işlem yani futures işlem ücreti indirimleri ve spot ve marjin işlem ücreti indirimleri kazanırsınız. Ayrıca bonuslar ve bir çok promosyon kazanırsınız.
Teknoloji ve finans dünyasında yatırım ve ticaret yapmak için hemen MƎXC borsasına: “17Hjw” refərans kod u ile kayıt olun.
MƎXC Refərans Kod u: “17Hjw” olarak kullanilir. Dünyada en çok kullanılan, ömür boyu geçerli, en yüksek indirim oranına sahip MƎXC refərans kod udur. MƎXC kripto para borsasına kayıt olurken “Davet Kod u” yazan yere “17Hjw” yazınız. Alacağınız işlem ücreti indirimi % 100’dür. Ayrıca 1000$ USDT komisyon iade bonusu alacaksınız. Kripto para borsası MƎXC Refərans Kod u: “17Hjw” ile vadeli işlem yani futures işlem ücreti indirimleri ve spot ve marjin işlem ücreti indirimleri kazanırsınız. Ayrıca bonuslar ve bir çok promosyon kazanırsınız. Teknoloji ve finans dünyasında yatırım ve ticaret yapmak için hemen MƎXC borsasına: “17Hjw” refərans kod u ile kayıt olun. Read More
2 separate data validation in 1 excel sheet
I already created a 2 level data validation in an excel sheet but I need to create another set of data validation using another set of details on the same sheet. Please help if that is possible. Thank you!
I already created a 2 level data validation in an excel sheet but I need to create another set of data validation using another set of details on the same sheet. Please help if that is possible. Thank you! Read More
Since CB 2403, downloading applications through CMG during task sequence not working anymore
Hello everyone,
since the 2403 ConfigMgr Upgrade we have the issue that during task sequences downloading applications doesn’t work anymore. TS is stuck on “Install Application” until it times out after hours. This happens only, if content is being retrieved by a CMG. Packages are working pretty fine, it is just applications.
On Reddit, a few others are reporting the same. One solution provided was to disable Branch Cache in client settings, but this doesn’t help during a task sequence.
Downloading the same applications within Windows and the Software Center through CMG is working well.
Anyone experienced this issue and may have a solution?
Cheers,
Ray
Hello everyone,since the 2403 ConfigMgr Upgrade we have the issue that during task sequences downloading applications doesn’t work anymore. TS is stuck on “Install Application” until it times out after hours. This happens only, if content is being retrieved by a CMG. Packages are working pretty fine, it is just applications.On Reddit, a few others are reporting the same. One solution provided was to disable Branch Cache in client settings, but this doesn’t help during a task sequence.Downloading the same applications within Windows and the Software Center through CMG is working well. Anyone experienced this issue and may have a solution? Cheers,Ray Read More
Binancə Refərral Codə: VO2P1RYP
Binancə Refərral Codə: Used as “VO2P1RYP”. It is the most used Binancə refərral codə in the world, valid for life, with the highest discount rate.
When registering to the Binancə cryptocurrency exchange, enter “VO2P1RYP” in the “Refərral ID” field. The transaction fee discount you will receive is 121%. You will also receive a $600 USDT rakeback bonus.
With the cryptocurrency exchange Binancə Refərral Codə: “VO2P1RYP”, you earn futures transaction fee discounts and spot and margin transaction fee discounts. You also get bonuses and many promotions.
To invest and trade in the world of technology and finance, register immediately to the Binancə exchange with the refərral codə “VO2P1RYP”.
Binancə Refərral Codə: Used as “VO2P1RYP”. It is the most used Binancə refərral codə in the world, valid for life, with the highest discount rate. When registering to the Binancə cryptocurrency exchange, enter “VO2P1RYP” in the “Refərral ID” field. The transaction fee discount you will receive is 121%. You will also receive a $600 USDT rakeback bonus. With the cryptocurrency exchange Binancə Refərral Codə: “VO2P1RYP”, you earn futures transaction fee discounts and spot and margin transaction fee discounts. You also get bonuses and many promotions. To invest and trade in the world of technology and finance, register immediately to the Binancə exchange with the refərral codə “VO2P1RYP”. Read More
DX12/11 sample for MAUI
I am currently working on porting our 3D rendering SDK to support MAUI for Windows, and we have already already support for .NET8 Winforms, WPF on Windows, and MAUI on Android and iOS. Are there any DX12 or DX11 based samples or demos that we might have missed?
-Sahil
I am currently working on porting our 3D rendering SDK to support MAUI for Windows, and we have already already support for .NET8 Winforms, WPF on Windows, and MAUI on Android and iOS. Are there any DX12 or DX11 based samples or demos that we might have missed?-Sahil Read More
What’s New: Create your own codeless data connector
Today we’re announcing the general availability of the Codeless Connectors Platform (CCP) in Microsoft Sentinel that provides partners, advanced users, and developers the ability to create custom connectors for ingesting data to Microsoft Sentinel.
How is this CCP different from the previous version?
The initial version of the CCP was announced in January of 2022. Since then, we’ve improved upon the platform and the legacy release is no longer recommended. This new version of the CCP has the following key improvements:
Better support for various authentication and pagination types.
Supports standard data collection rules (DCRs).
The user interface and connection configuration portions of the codeless connector are separate now. This allows the creation of connectors with multiple connections which wasn’t possible previously.
At present, CCP allows connections to any data source with a public REST API endpoint.
Key benefits of using CCP:
Eliminates the need to write code for connecting to public REST APIs.
Offers a scalable, built-in Poller as a service.
Provides configurable UI components for your connector.
Enables monitoring of your connectors; CCP integrates with Sentinel Connector Health messages, allowing for troubleshooting and health status updates.
Currently, CCP support connectors that are based on RestAPI, S3 and GCP.
Getting started
Prerequisites
Before building a connector, understand your data source and how Microsoft Sentinel needs to connect.
Data Collection Endpoint (DCE)
A DCE is a requirement for a DCR. Only one DCE is created per log analytics workspace DCR deployment. Every DCR deployed for a Microsoft Sentinel workspace uses the same DCE. For more information on how to create one or whether you need a new one, see Data collection endpoints in Azure Monitor.
Schema of the output table(s).
It’s important to understand the shape of your data stream and the fields you want to include in the output table. Reference your data source documentation or analyze sufficient output examples.
Research the following components and verify support for them in the Data Connector API reference:
HTTP request and response structure to the data source
Authentication required by the data source.
For example, if your data source requires a token signed with a certificate, the data connector API reference specifies cert authentication isn’t supported.
Pagination options to the data source
We also recommend a tool like Postman to validate the data connector components. For more information, see Use Postman with the Microsoft Graph API.
Build the data connector
There are 4 components required to build the CCP data connector.
Output table definition
Data Collection Rule (DCR)
Data connector user interface
Data connector connection rules
Follow the steps for creating each component before creating the deployment template.
Deploy the connector
Copy the contents of the ARM deployment template.
Follow the Edit and deploy the template instructions from the article, Quickstart: Create and deploy ARM templates by using the Azure portal.
Verify the codeless connector
View your codeless connector in the data connector gallery. Open the data connector and complete any authentication parameters required to connect . Once successfully connected, the DCR and custom tables are created. View the DCR resource in your resource group and any custom tables from the logs analytics workspace.
Refer to the following illustration as an example of one of the connectors: this connector requires token endpoint, authorization token, user activity logs endpoint, client ID and client secret.
Note that It may take up to 30 minutes to see data begin ingesting.
What to Expect in the Future:
1. Platform extensibility:
Support APIs that are based on nested API calls.
Support for push type connectors.
Allow selection of endpoint in multi rule connectors.
KQL transformation in ingest time.
and more…
2. Dedicated webinar for creating a codeless data connectors.
3. UI that will assist creating codeless data connectors.
Learn more:
Create a codeless connector documentation: Create a codeless connector for Microsoft Sentinel
Data connector API reference: Data connector connection rules reference
Data connector definition API reference: Data connector UI definitions reference
Microsoft Tech Community – Latest Blogs –Read More
What to do after generating HDL code?
I have converted my FFT code to HDL using HDL Coder. Now, it has generated many vhd files with hierarchy ranging from 0 to 4. What is supposed to be the next step? How am i supposed to know which file calls which? I have no experience with VHDL.I have converted my FFT code to HDL using HDL Coder. Now, it has generated many vhd files with hierarchy ranging from 0 to 4. What is supposed to be the next step? How am i supposed to know which file calls which? I have no experience with VHDL. I have converted my FFT code to HDL using HDL Coder. Now, it has generated many vhd files with hierarchy ranging from 0 to 4. What is supposed to be the next step? How am i supposed to know which file calls which? I have no experience with VHDL. hdlcoder MATLAB Answers — New Questions
how to specify numbers in an array with varying steps
I want to specify the a group of numbers in an array but they do not appear in even steps.
I want to capture
N1 (1 and 12), N2 (2,3,4,10,11), N3(5,6,7,8,9) and N4 (13, 14)
I understand that to capture N1,and N4 I can specify the individual array numbers, and for N3 I can specify the start and the end and the size of the steps [5:1:9]. I just can’t work out how to specify what I would like in the instance of N2
Please help.
Thanks
AlexI want to specify the a group of numbers in an array but they do not appear in even steps.
I want to capture
N1 (1 and 12), N2 (2,3,4,10,11), N3(5,6,7,8,9) and N4 (13, 14)
I understand that to capture N1,and N4 I can specify the individual array numbers, and for N3 I can specify the start and the end and the size of the steps [5:1:9]. I just can’t work out how to specify what I would like in the instance of N2
Please help.
Thanks
Alex I want to specify the a group of numbers in an array but they do not appear in even steps.
I want to capture
N1 (1 and 12), N2 (2,3,4,10,11), N3(5,6,7,8,9) and N4 (13, 14)
I understand that to capture N1,and N4 I can specify the individual array numbers, and for N3 I can specify the start and the end and the size of the steps [5:1:9]. I just can’t work out how to specify what I would like in the instance of N2
Please help.
Thanks
Alex cell arrays, cell array, cell, vector, vectors MATLAB Answers — New Questions
How can I dowload R2017b?
I unistalled a previous R2017b but now I am not able to install again, How can I do?I unistalled a previous R2017b but now I am not able to install again, How can I do? I unistalled a previous R2017b but now I am not able to install again, How can I do? r2017b MATLAB Answers — New Questions
