Month: September 2024
Exam Voucher – Changes ?
@DanDonohue Can you tell me if there are any news on the Exam Voucher pricing ? Was something published already ? In the Community Call you mentioned Sep 9th …
@DanDonohue Can you tell me if there are any news on the Exam Voucher pricing ? Was something published already ? In the Community Call you mentioned Sep 9th … Read More
Forms to Excel with Power Automate
Hello! I have a group of students who have to take three different exams in order to use school resources. Students who pass each of the tests fill out a form ( Form A, Form B and Form C) after each one of them, acknowledging they’ve completed the specific course. I have an Excel Sheet automatically generated from the responses gathered in Form A (email, name, acknowledgement acceptance) and would like to add two more columns to display their responses to the acceptance question in Form B & C so I can see in a singular table which of the three resources they are authorized for. As you can see in the image below, I have been able to get as far as creating a new column to gather Form B responses (Power Automate>When a response is submitted>Get response details>Get User profile>Add row into a table) but I cannot get them on the same line as the responses by the same user in Form A.
Could anyone give me any pointers as to how I can get this fixed? Thank you so much!!
Hello! I have a group of students who have to take three different exams in order to use school resources. Students who pass each of the tests fill out a form ( Form A, Form B and Form C) after each one of them, acknowledging they’ve completed the specific course. I have an Excel Sheet automatically generated from the responses gathered in Form A (email, name, acknowledgement acceptance) and would like to add two more columns to display their responses to the acceptance question in Form B & C so I can see in a singular table which of the three resources they are authorized for. As you can see in the image below, I have been able to get as far as creating a new column to gather Form B responses (Power Automate>When a response is submitted>Get response details>Get User profile>Add row into a table) but I cannot get them on the same line as the responses by the same user in Form A.Could anyone give me any pointers as to how I can get this fixed? Thank you so much!! Read More
Teams login faild
Hello,
When I log in on my Macbook Air Sonoma, I get the error message: Something didn’t work 1001,
If I log in with another account it works.
I uninstalled and reinstalled Teams from Microsoft Homepage,
delet:
~/Library/Application Support/Microsoft/Teams
~/Library/Caches/com.microsoft.teams
~/Library/Group Containers/UBF8T346G9.com.microsoft.teams
~Library/Containers/Microsoft Teams2
didn’t help, the account will not be removed from teams and i cant login
are there somewhere hidden cache files from Teams on Mac ?
what else can I try?
Hello, When I log in on my Macbook Air Sonoma, I get the error message: Something didn’t work 1001,If I log in with another account it works.I uninstalled and reinstalled Teams from Microsoft Homepage,delet:~/Library/Application Support/Microsoft/Teams~/Library/Caches/com.microsoft.teams~/Library/Group Containers/UBF8T346G9.com.microsoft.teams~Library/Containers/Microsoft Teams2didn’t help, the account will not be removed from teams and i cant loginare there somewhere hidden cache files from Teams on Mac ?what else can I try? Read More
Deploy agent on Azure Virtual Machine Scale Sets
Hi,
I am looking for information if Defender for Endpoint is support to be installed on Azure Virtual Machine Scale Sets?
I have not been able to find any information either way. However, the fact that my Defender for Servers plan has not installed it on them, make me suspect they are not supported.
Can anyone please confirm? a official link would be preferred to suspicions.
Hi, I am looking for information if Defender for Endpoint is support to be installed on Azure Virtual Machine Scale Sets?I have not been able to find any information either way. However, the fact that my Defender for Servers plan has not installed it on them, make me suspect they are not supported. Can anyone please confirm? a official link would be preferred to suspicions. Read More
Temporary error 403 on images
I’ve been having the following problem for some time now. Some images are repeatedly not displayed on the website (error 403). These are also linked as an image. If I click on the link, they appear without any problems. When I refresh the page with cache turned off, different images are affected. Does anyone have an idea?
for instance www.salzlandkreis.de/bildungkultur/ringheiligtum-poemmelte/impressionen
I’ve been having the following problem for some time now. Some images are repeatedly not displayed on the website (error 403). These are also linked as an image. If I click on the link, they appear without any problems. When I refresh the page with cache turned off, different images are affected. Does anyone have an idea? for instance www.salzlandkreis.de/bildungkultur/ringheiligtum-poemmelte/impressionen Read More
Searching with Loop components – What is the plan?
Q1: OneNote has a capable search that includes OCR and handwriting, but the search capabilities with Loop are limited, especially when using components throughout the 365 ecosystems. What are the blockers and what is the intent for search within Loop and components?
Q1: OneNote has a capable search that includes OCR and handwriting, but the search capabilities with Loop are limited, especially when using components throughout the 365 ecosystems. What are the blockers and what is the intent for search within Loop and components? Read More
Getting insights for book sales using Copilot
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will once again use this table of book sales, using Copilot to find more insights.
I ask Copilot:
Which category has the best user ratings
I would also like to know which author is best, so I ask Copilot:
Which author has the highest average user rating?
After getting that response, I would like to know more than just the top author, so I ask:
Show me the top 5 authors by user rating
With that response, I can insert the Summary into a new sheet or copy the textual summary to add to a document or presentation.
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will once again use this table of book sales, using Copilot to find more insights.
Table of book sales with columns for Book Id, Release date, Author, Category, Publishing Branch, User Rating and Sales
I ask Copilot:
Which category has the best user ratings
Copilot in Excel pane showing above prompt and response, The category with the best user ratings is Children Books with an average user rating of 3.861.
I would also like to know which author is best, so I ask Copilot:
Which author has the highest average user rating?
Copilot in Excel pane showing the above prompt and the response, The author with the highest average user rating is Kenneth Liew with an average user rating of 4.533.
After getting that response, I would like to know more than just the top author, so I ask:
Show me the top 5 authors by user rating
Copilot in Excel pane with the above prompt and the response: The top 5 authors by average user rating are Kenneth Liew (4.53), Tania Agius (4.5), Bernadette Leblanc (4.4), Andrew Fenec (4.35), and Belinda Kaur (4.33)
With that response, I can insert the Summary into a new sheet or copy the textual summary to add to a document or presentation.
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks. Read More
Embracing the Future: AWS Customers Leverage Fargate for ECS and EKS Deployments
As organizations advance in their cloud native journey, the adoption of AWS Fargate for ECS (Elastic Container Service) and EKS (Elastic Kubernetes Service) increases. Many customers begin their cloud journey with Amazon ECS, with around 65% of new AWS container customers opting for ECS. This popularity is driven by Fargate’s serverless compute engine, which allows containers to run without managing the underlying infrastructure. Using Amazon ECS or Amazon EKS with AWS Fargate offers several advantages, making it a compelling choice for deploying and managing containerized applications. Here’s why organizations prefer ECS or EKS with Fargate:
As organizations advance in their cloud native journey, the adoption of AWS Fargate for ECS (Elastic Container Service) and EKS (Elastic Kubernetes Service) increases. Many customers begin their cloud journey with Amazon ECS, with around 65% of new AWS container customers opting for ECS. This popularity is driven by Fargate’s serverless compute engine, which allows containers to run without managing the underlying infrastructure. Using Amazon ECS or Amazon EKS with AWS Fargate offers several advantages, making it a compelling choice for deploying and managing containerized applications. Here’s why organizations prefer ECS or EKS with Fargate: Read More
Robot arms 3RRR Kinematics and forward kinematics
Hey i need a help or some file with Kinematics and forward kinematics for
manipulator arm i mean 3RRR
i will really happy when someone can help me
wait for answerHey i need a help or some file with Kinematics and forward kinematics for
manipulator arm i mean 3RRR
i will really happy when someone can help me
wait for answer Hey i need a help or some file with Kinematics and forward kinematics for
manipulator arm i mean 3RRR
i will really happy when someone can help me
wait for answer rrr, kinematics, 3rrr, forward kinematics, rrr kinematics matlab MATLAB Answers — New Questions
acousticLoudness() function incorrect?
I decided to verify acousticLoudness function using ISO532-1 test method using ISO provided test signals and compare to stated sone levels.
According to ISO532-1 test signal wav data should be calibrated: " For the calibration of the WAVE files, 0 dB (relative to full scale) shall correspond to a sound pressure level of 100 dB." The calibration factor works out to be =2. This could be immediately verified by comparing test frequency amplitude after calibration with file name e.g. "Test signal 6 (tone 250 Hz 30 dB – 80 dB).wav". The max amplitude is 0.2 Pa (80dB).
I used these function parameters to calculate loudness of time varying noise signals:
LoudnessISO532=acousticLoudness(signal,48000,’SoundField’,’free’,’TimeVarying’,true);
acousticLoudness() produces loudness nearly twice the value of the ISO calculation. I discovered, however, that if I do not calibrate the wav file, function produces correct results.
Thus, it seems to me, to obtain correct results, calibrated SPL (Pa) signal should be reduced by half.
Did anybody try to verify the function using ISO532-1 test wav files? Did you calibrate them?
Thanks!I decided to verify acousticLoudness function using ISO532-1 test method using ISO provided test signals and compare to stated sone levels.
According to ISO532-1 test signal wav data should be calibrated: " For the calibration of the WAVE files, 0 dB (relative to full scale) shall correspond to a sound pressure level of 100 dB." The calibration factor works out to be =2. This could be immediately verified by comparing test frequency amplitude after calibration with file name e.g. "Test signal 6 (tone 250 Hz 30 dB – 80 dB).wav". The max amplitude is 0.2 Pa (80dB).
I used these function parameters to calculate loudness of time varying noise signals:
LoudnessISO532=acousticLoudness(signal,48000,’SoundField’,’free’,’TimeVarying’,true);
acousticLoudness() produces loudness nearly twice the value of the ISO calculation. I discovered, however, that if I do not calibrate the wav file, function produces correct results.
Thus, it seems to me, to obtain correct results, calibrated SPL (Pa) signal should be reduced by half.
Did anybody try to verify the function using ISO532-1 test wav files? Did you calibrate them?
Thanks! I decided to verify acousticLoudness function using ISO532-1 test method using ISO provided test signals and compare to stated sone levels.
According to ISO532-1 test signal wav data should be calibrated: " For the calibration of the WAVE files, 0 dB (relative to full scale) shall correspond to a sound pressure level of 100 dB." The calibration factor works out to be =2. This could be immediately verified by comparing test frequency amplitude after calibration with file name e.g. "Test signal 6 (tone 250 Hz 30 dB – 80 dB).wav". The max amplitude is 0.2 Pa (80dB).
I used these function parameters to calculate loudness of time varying noise signals:
LoudnessISO532=acousticLoudness(signal,48000,’SoundField’,’free’,’TimeVarying’,true);
acousticLoudness() produces loudness nearly twice the value of the ISO calculation. I discovered, however, that if I do not calibrate the wav file, function produces correct results.
Thus, it seems to me, to obtain correct results, calibrated SPL (Pa) signal should be reduced by half.
Did anybody try to verify the function using ISO532-1 test wav files? Did you calibrate them?
Thanks! acousticloudness MATLAB Answers — New Questions
Data table and what if is not appearing for my online Excel version?
Hi I am unable to find the option to create a data table and also for goal seek for the online version of excel? I subscribed to Microsoft 365?
Hi I am unable to find the option to create a data table and also for goal seek for the online version of excel? I subscribed to Microsoft 365? Read More
Facing issue while adding app to intunes portal using Microsoft Graph API
My application is used to automate the process of adding win32 apps to intunes portal for different tenant.
Created a blazor application with .Net 6 and imported Microsoft Graph package. While adding the app metadata to the created object of Win32LobApp inbuilt class of Microsoft Graph package, there are mandatory parameters that is required to add the app to the intunes portal. Some of the mandatory fields are not matching with the parameters that are available in intunes portal.
Below are the mandatory fields that are there in the portal for creating Win32 app in intunes portal.
NameDescriptionPublisherInstall commandUninstall commandOperating system architectureMinimum operating systemRules format – Manually Configure Detection RuleRule typePathFile or folderDetection method
Could you suggest how all these parameters can be integrated to intues using Graph API from my .Net application.
My application is used to automate the process of adding win32 apps to intunes portal for different tenant. Created a blazor application with .Net 6 and imported Microsoft Graph package. While adding the app metadata to the created object of Win32LobApp inbuilt class of Microsoft Graph package, there are mandatory parameters that is required to add the app to the intunes portal. Some of the mandatory fields are not matching with the parameters that are available in intunes portal. Below are the mandatory fields that are there in the portal for creating Win32 app in intunes portal.NameDescriptionPublisherInstall commandUninstall commandOperating system architectureMinimum operating systemRules format – Manually Configure Detection RuleRule typePathFile or folderDetection method Could you suggest how all these parameters can be integrated to intues using Graph API from my .Net application. Read More
Communication problem between two Windows Server servers on port 38008
Good afternoon everyone,
I have been trying to solve a communication problem between two servers for 2 weeks. I need from virtual server A (Azure VM) to query server B (Azure VM) via POSTMAN.
Both servers are communicating with each other on standard ports.
I have made an Inbound and Outbound exception in Windows Firewall and in Network Security Groups in Azure. I am still getting errors related to timeout and no communication when I test it with telnet or Azure VM with Connection Troubleshooting.
When I try to run a GET in POSTMAN, I end up with a failure to communicate error.
Any ideas on how to fix this?
I can put you more details – let me know what you need. Thank you
Good afternoon everyone, I have been trying to solve a communication problem between two servers for 2 weeks. I need from virtual server A (Azure VM) to query server B (Azure VM) via POSTMAN. Both servers are communicating with each other on standard ports.I have made an Inbound and Outbound exception in Windows Firewall and in Network Security Groups in Azure. I am still getting errors related to timeout and no communication when I test it with telnet or Azure VM with Connection Troubleshooting. When I try to run a GET in POSTMAN, I end up with a failure to communicate error. Any ideas on how to fix this? I can put you more details – let me know what you need. Thank you Read More
Modify playlist view to add additional field?
I want to use the stream playlist view to curate a community training video series that we have been hosting for our new PMO. We have monthly training calls that we record, but we also want to make the link to the PPT slides visible within a playlist format. I was hoping there might be a way to modify the view of a playlist in a similar fashion to editing other MS List views but I can’t seem to figure it out.
Ideally wanted to be able to show a button in the sidebar thing. See my janky mockup image for what I’m describing
pink button to open link to a file
I want to use the stream playlist view to curate a community training video series that we have been hosting for our new PMO. We have monthly training calls that we record, but we also want to make the link to the PPT slides visible within a playlist format. I was hoping there might be a way to modify the view of a playlist in a similar fashion to editing other MS List views but I can’t seem to figure it out. Ideally wanted to be able to show a button in the sidebar thing. See my janky mockup image for what I’m describing pink button to open link to a file Read More
Implement functionality that allows users to enter the total monetary value of the project.
Como faço para obter uma métrica com valores em grau de dificuldade do projeto e o valor em dinheiro.
– Implement functionality that allows users to enter the total monetary value of the project.
– Create separate fields to add costs associated with each stage of the project.
– Develop an evaluation system to determine the degree of difficulty of each project and stage, with the option to record these metrics.
– Enable integrated visualization of the budget, stages and difficulties to facilitate project management and planning.
Como faço para obter uma métrica com valores em grau de dificuldade do projeto e o valor em dinheiro.- Implement functionality that allows users to enter the total monetary value of the project.- Create separate fields to add costs associated with each stage of the project.- Develop an evaluation system to determine the degree of difficulty of each project and stage, with the option to record these metrics.- Enable integrated visualization of the budget, stages and difficulties to facilitate project management and planning. Read More
Improving Project Management: A Proposal for Integrated Metrics
Improving Project Management: A Proposal for Integrated Metrics
In the dynamic world of project management, the ability to assess progress and challenges quantitatively is essential. An innovative suggestion for Microsoft would be to develop an integrated tool that not only allows the inclusion of the total monetary value of the project, but also offers a detailed breakdown of costs by stage, along with an assessment of the degree of difficulty associated with each of these stages.
Imagine an intuitive interface where managers can enter the financial value of the project and then detail the estimated costs for each step. In addition, they could assign a degree of difficulty, perhaps on a scale of 1 to 10, to each stage of the project. This difficulty metric would help identify potential bottlenecks and allocate resources more efficiently.
This proposal would not only make it easier to visualize the project’s financial outlook but also promote.
Improving Project Management: A Proposal for Integrated MetricsIn the dynamic world of project management, the ability to assess progress and challenges quantitatively is essential. An innovative suggestion for Microsoft would be to develop an integrated tool that not only allows the inclusion of the total monetary value of the project, but also offers a detailed breakdown of costs by stage, along with an assessment of the degree of difficulty associated with each of these stages.Imagine an intuitive interface where managers can enter the financial value of the project and then detail the estimated costs for each step. In addition, they could assign a degree of difficulty, perhaps on a scale of 1 to 10, to each stage of the project. This difficulty metric would help identify potential bottlenecks and allocate resources more efficiently.This proposal would not only make it easier to visualize the project’s financial outlook but also promote. Read More
Maximizing Azure Resource Insights: Introducing the Azure Inventory Gateway
Introduction
Azure Resource Graph (ARG) is an efficient tool for querying Azure resources, but it doesn’t always provide the full scope of information you need about them, especially when it comes to in-depth details.
This is where Resource Inventory Gateway comes into play. ARG’s limitations – such as not retrieving all attributes or configurations for a resource – force users to make additional API calls to Azure Resource Manager (ARM). Instead of manually querying multiple resources, this gateway automates and consolidates those calls, returning a complete data set.
TLDR; GitHub Repository
Why we build the Azure Inventory Gateway?
ARG (Azure Resource Graph) missing attributes:
Azure Resource Graph is a powerful service that allows you to explore and query your Azure resources across multiple subscriptions quickly and efficiently, providing detailed insights without needing individual API calls but it is not includes all ARM attributes.
Azure Resource Manager (ARM) Rest API capability
ARM is designed to handle queries for a single resource at a time.
To retrieve data from multiple resources, whether across a single subscription or multiple subscriptions, you need to execute multiple API calls.
The Azure Inventory Gateway simplify the achievement of this capability.
What is Azure Inventory Gateway?
Azure Inventory Gateway is a .NET-based gateway that simplifies the management and aggregation of REST API calls.
This solution provides an endpoint where you can send an API call along with variables. It processes the request and returns a unified response by aggregating the results from the APIs calls.
Currently it is including 2 interface gateways:
ARM Gateway – Interact with Azure Resource Manager (ARM) REST API.
Cost Gateway – Interact with Azure Cost Management REST API.
Azure Workbook
Workbooks provide a flexible canvas for data analysis and the creation of rich visual reports within the Azure portal. They allow you to tap into multiple data sources from across Azure and combine them into unified interactive experiences.
You can use the Azure inventory Gateway in Azure workbooks.
To make a call to the Azure Inventory Gateway, you need to use the custom endpoint data source and provide the appropriate API call along with the necessary variables.
You can find all details here.
Examples
Azure OpenAI Model Deployments
List all deployment models across all my Azure OpenAI resources
This provides a centralized view of your deployment models across subscriptions and resources.
If you need to locate where a specific model is deployed, you can now easily search across all your instances.
Azure OpenAI Models
List all supported models across all my Azure OpenAI resources
This provides a centralized view of your supported models, versions, lifecycle (Generally Available, Preview), creation date, etc. across subscriptions and resources.
If you need to locate where a specific model or version is supported, you can now easily search across all your instances.
Conclusion
Azure Inventory Gateway provides a streamlined approach to accessing complete resource data, eliminating the need for multiple ARM queries and delivering unified results. This tool saves time, automates the complexity of resource management, and expands the capabilities of Azure Resource Graph.
To get started, check out the GitHub repository, and integrate it into your resource management workflows today. For any queries or to contribute, feel free to connect via the repo or submit feedback!
Microsoft Tech Community – Latest Blogs –Read More
Is it possible to remove 2-3 endmember spectral lines from a spectral plot, and how?
I plotted a spectral plot of 9 endmembers, from this I need to remove spectral lines 2, 4 and 5 or select other lines.
.I plotted a spectral plot of 9 endmembers, from this I need to remove spectral lines 2, 4 and 5 or select other lines.
. I plotted a spectral plot of 9 endmembers, from this I need to remove spectral lines 2, 4 and 5 or select other lines.
. hyperspectral image processing MATLAB Answers — New Questions
Write script matlab for solving the convection-diffusion equation of a compound in a 3D annular reactor (diffusion in two directions with convection)
hello,
I would like help to write a matlab for solving the convection-diffusion equation of a compound in a 3D annular reactor (diffusion in two directions r and teta with convective transport in the main direction, see figure below) with a reaction on the surface of inner cylinder. The elements of the problem are as follows:
a 3D model is proposed. This model is based on a convection / radial diffusion principle in the annular space of the reactor. The mass balance in the gas phase can be written (eq. (1)):
(1)
0 < z < L
Inlet concentration : C0=4.5 10-5 mol.m-3
Where r is radial coordinate (m), z is axial coordinate, u is flow velocity (m s-1) and C, is the concentration of NCl3 (mol m-3).
The model takes the velocity profile developed in the annular space into account, as expressed by the following relationship:
(2)
With
(3)
z=1m
Um=0.5m s-1
ri=0.04m, the internal radius
re=0.05m, the external radius of reactor (m).
Boundary conditions are:
at the inner surface of the external cylinder, r=re:
(4)
at the catalyst surface, r=ri,
(5)
Where rp is the photocatalytic rate (mol m-2 s-1).
(6)
I=9.8 W m-2, n =1, kp = 2.6×10-6 mol s-1 W-1and Kp = 3x103m3 mol-1.
and for and
Thank you very much for your helphello,
I would like help to write a matlab for solving the convection-diffusion equation of a compound in a 3D annular reactor (diffusion in two directions r and teta with convective transport in the main direction, see figure below) with a reaction on the surface of inner cylinder. The elements of the problem are as follows:
a 3D model is proposed. This model is based on a convection / radial diffusion principle in the annular space of the reactor. The mass balance in the gas phase can be written (eq. (1)):
(1)
0 < z < L
Inlet concentration : C0=4.5 10-5 mol.m-3
Where r is radial coordinate (m), z is axial coordinate, u is flow velocity (m s-1) and C, is the concentration of NCl3 (mol m-3).
The model takes the velocity profile developed in the annular space into account, as expressed by the following relationship:
(2)
With
(3)
z=1m
Um=0.5m s-1
ri=0.04m, the internal radius
re=0.05m, the external radius of reactor (m).
Boundary conditions are:
at the inner surface of the external cylinder, r=re:
(4)
at the catalyst surface, r=ri,
(5)
Where rp is the photocatalytic rate (mol m-2 s-1).
(6)
I=9.8 W m-2, n =1, kp = 2.6×10-6 mol s-1 W-1and Kp = 3x103m3 mol-1.
and for and
Thank you very much for your help hello,
I would like help to write a matlab for solving the convection-diffusion equation of a compound in a 3D annular reactor (diffusion in two directions r and teta with convective transport in the main direction, see figure below) with a reaction on the surface of inner cylinder. The elements of the problem are as follows:
a 3D model is proposed. This model is based on a convection / radial diffusion principle in the annular space of the reactor. The mass balance in the gas phase can be written (eq. (1)):
(1)
0 < z < L
Inlet concentration : C0=4.5 10-5 mol.m-3
Where r is radial coordinate (m), z is axial coordinate, u is flow velocity (m s-1) and C, is the concentration of NCl3 (mol m-3).
The model takes the velocity profile developed in the annular space into account, as expressed by the following relationship:
(2)
With
(3)
z=1m
Um=0.5m s-1
ri=0.04m, the internal radius
re=0.05m, the external radius of reactor (m).
Boundary conditions are:
at the inner surface of the external cylinder, r=re:
(4)
at the catalyst surface, r=ri,
(5)
Where rp is the photocatalytic rate (mol m-2 s-1).
(6)
I=9.8 W m-2, n =1, kp = 2.6×10-6 mol s-1 W-1and Kp = 3x103m3 mol-1.
and for and
Thank you very much for your help convection_diffusin model, annular reactor 3d MATLAB Answers — New Questions