Month: August 2024
Register now! CSP Copilot and Microsoft 365 Activation Event
Reinvent your Cloud Solution Provider program (CSP) growth in the AI era with Copilot and Microsoft 365!
DETAILS
SAVE YOUR SEAT
Register today by selecting your preferred date and time zone below to reserve your spot and to get notified when session content is available on demand.
August 27th
September 5th
TOPIC DETAILS
Discover:
New promotional offers across Copilot for Microsoft 365, Microsoft 365 E SKUs, and Dynamics 365 Business Central
How CSP partners like you can accelerate growth with Copilot and Microsoft 365
PRESENTED BY
Giovanni Mezgec, VP of Modern Work and Business Applications Field & Partner Marketing
David Smith, VP of Worldwide Channel Sales
Reinvent your Cloud Solution Provider program (CSP) growth in the AI era with Copilot and Microsoft 365!
DETAILS
SAVE YOUR SEAT
Register today by selecting your preferred date and time zone below to reserve your spot and to get notified when session content is available on demand.
August 27th
AM option
PM option
September 5th
AM option
PM option
TOPIC DETAILS
Discover:
New promotional offers across Copilot for Microsoft 365, Microsoft 365 E SKUs, and Dynamics 365 Business Central
How CSP partners like you can accelerate growth with Copilot and Microsoft 365
PRESENTED BY
Giovanni Mezgec, VP of Modern Work and Business Applications Field & Partner Marketing
David Smith, VP of Worldwide Channel Sales Read More
ADX Web updates – July 2024
Introducing ad-hoc visual Data Exploration feature
Our new “Data Exploration” feature allows you to dive deeper into the data on any dashboard, extending your exploration beyond the displayed tiles to uncover new insights. This user-friendly, form-like interface lets you add filters, create aggregations, and switch visualization types without writing queries. Now, you can explore data ad-hoc, leveraging existing tiles to start your journey and expand your data view.
Read more:
Announcement: Ad-Hoc Visual Data Exploration Feature – Microsoft Community Hub
Documentation: Explore data in dashboard tiles (preview) – Azure Data Explorer | Microsoft Learn
Dashboards real time refresh rate
We are excited to announce an enhancement to our dashboard auto refresh feature, now supporting continuous and 10 seconds refresh rates, in addition to the existing options.
This upgrade, addressing a popular customer request, allows both editors and viewers to set near real-time and real-time data updates, ensuring your dashboards display the most current information with minimal delay. Experience faster data refresh and make more timely decisions with our improved dashboard capabilities.
As the dashboard author you can enable the Auto refresh setting and set a minimum time interval, to prevent users from setting an auto refresh interval smaller than the provided value.
Note that the Continuous option should be used with caution. The data is refreshed every second or after the previous refresh completes if it takes more than 1 second.
Resize dashboard tiles using keyboard only
We are excited to introduce a new accessibility feature that allows users to resize dashboard tiles using only the keyboard.
By pressing the Tab key, you can focus on a tile, and then use the arrow keys to move it.
To resize, hold the Shift key and use the arrow keys: right to increase width, left to decrease width, down to increase height, and up to decrease height.
This functionality mirrors the ease of moving and resizing with a mouse, enhancing the accessibility and usability of ADX web UI.
Azure Data Explorer Web UI team is looking forward for your feedback in KustoWebExpFeedback@service.microsoft.com
You’re also welcome to add more ideas and vote for them here – https://aka.ms/adx.ideas
Read more:
ADX Web May updates – ADX Web updates – May 2024 – Microsoft Community Hub
Microsoft Tech Community – Latest Blogs –Read More
Introducing Drag and Drop to Reorder Items in Microsoft Lists
You asked, and we listened! We’re excited to announce the arrival of a long-awaited feature in Microsoft Lists: drag and drop to reorder List items! This new feature will allow you to effortlessly rearrange your list items, making organization more efficient for all your busy lists.
Drag and Drop Items with Ease
You will now be able to drag and drop seamlessly with this new feature for Microsoft Lists! You can easily start using this option on any new or existing list to arrange your items.
You can also drag and drop multiple items at once to reorder them, giving you more ways to organize and stay on top of your work.
Cursor selecting multiple items in a Microsoft List and dragging them to reorder
Your custom ordering is saved across the entire list, and you can switch into custom order mode any time you’d like by changing the sort to Custom order.
Custom order
Work in different views
The drag and drop feature in Microsoft Lists is incredibly versatile, supporting reordering across various views including board view and gallery view. Whether you’re grouping or filtering items, you can easily reorder them to suit your needs.
Board View
Cursor dragging items between different boards in the Board View in Microsoft Lists
Gallery View
Cursor selecting and dragging items to reorder them in Gallery View in Microsoft Lists
Move up and move down
For our keyboard users and screen reader users, there is a move up/move down functionality we have implemented. Navigate to More Actions > More and you will find the option to Move down or Move up your List item.
This feature streamlines how you manage your lists, providing a more personalized and efficient way to keep your data organized.
Try it out today and experience a smoother workflow with Microsoft Lists!
Resources
Microsoft Tech Community – Latest Blogs –Read More
Recovering and Validating Data After Unexpected SQL Server Failovers
In SQL Server environments, including on-premises, Azure SQL Database, or SQL Managed Instance, unexpected failovers can sometimes leave Availability Group roles out of sync. When this happens, the new primary replica might take over while the original primary faces issues, leading to possible data discrepancies if transactions were in progress or uncommitted. To recover or validate any data loss, it’s essential to resync or validate the new primary with the old primary as soon as it’s back online. This ensures any lost transactions are reconciled. If critical data was missed during the failover, it must be recovered and merged to maintain database consistency. This blog outlines the steps to recover or validate any data loss using SQL Server Database Compare Utility.
To simulate this situation with the SQL Server Box product, two SQL Server VMs were set up on the same subnet, Always-On HA was turned on for both instances, a simplified WideWorldImportersDW (WWIDW) database was restored and set to full recovery mode. After creating the certificates and logins/users required for Availability Groups (AGs) without domains, an asynchronous commit AG was created (it needed to be asynchronous, since we cannot simulate transaction loss with a synchronous AG).
Using a transaction simulator, many transactions per second were performed into the primary database.
During this activity, the primary instance was stopped, which created a group of committed transactions that had not been replicated to the secondary. The goal of this post is to recover those missing transactions.
After stopping sql1, you need to open the dashboard on sql2, because SSMS can no longer connect to sql1 to update the status:
Opening the Failover wizard – you see a warning about data loss:
The wizard really wants to make sure you know there may be data loss:
Click through to get the results:
The dashboard for sql2 has the current cluster status:
To capture the state of the new primary, immediately create a database snapshot, ideally before opening it up to new application connections:
(In this case we were using sql1 in the transaction simulator and not the sqlistener, so no transactions will be written to sql2).
Restart the sql1 instance. On refresh, you will see that the old primary now has a state of Not Synchronizing / In Recovery.
Create a database snapshot on the old primary (sql1) before making the old primary the secondary (otherwise, when the old primary synchronizes as a secondary, the missing transactions are lost🙁
At this point you can Resume Data Movement to make the old primary a secondary.
It takes a minute for the old primary to roll back lost transactions and resynchronize with the new primary and the old primary should now be a synchronizing secondary;
We can now use the SQL Server Database Compare (SSDBC) application to check if we lost any transactions between the snapshot on the new primary (sql2 – the source) and the snapshot on the old primary (sql1 – the target). Refer to the SSDBC documentation for how to set it up.
In this case we have 313 hash differences (updates) and 423 missing (inserts) rows – note that we have no deletes that were not replicated because of timing of the simulated transaction cascading deletes (deletes stop if we exceed the configured percentage until the inserts/updates catch up):
Looking at the SSDBC folder in My Documents – we can see a SQL script file for each table in the database, with numbers in front to indicate the order you should run them in (based on foreign key references). If the database has DRI configured, you may need to combine scripts if the referenced table has an identity column and if you have the identity value capture option turned on. In the same folder are log files which contain more details about the comparison.
Opening one of the files, you can see update and insert statements. The update statements are written to try to be as safe as possible by checking (with additional conditions in the where clause) that the column value hasn’t been subsequently changed on the new primary.
After running all the change scripts on WWIDW on sql2 and then re-running SSDBC on WWIDW on sql2 (not the snapshot) and the sql1 snapshot – we see that the databases are now the same (note that this will only work on a static new primary);
Note that we could also use the tablediff utility or SSDT to generate a differences script.
The SSDBC download package contains a PowerShell script to make running the comparison operations across many servers/databases easier by making it Excel workbook driven. You can list your source and target servers and databases in the provided Servers.xlsx workbook and run the BulkDatabaseRecovery.ps1 script.
Feedback and suggestions
If you have feedback or suggestions for improving this team asset, please contact the Azure Databases SQL Customer Success Engineering Team. Thank you for your support!
Microsoft Tech Community – Latest Blogs –Read More
Why do I get the error: “Error in ros.internal.utilities.checkAndGetCompatibleCompilersLocation (line 73)”?
Hi,
I’m trying to implement some ROS2 custom messages into Matlab and I’ve not found a solution yet.
I downloaded the following repo: https://github.com/ros2/common_interfaces.git
In order to recreate the errors:
download the repo (I choose to clone it in the home);
open Matlab and move to this folder;
give the following command in the command window
ros2genmsg(".")
After this, I get these errors:
>> ros2genmsg(".")
Identifying message files in folder ‘/home/alberto/common_interfaces’..Validating message files in folder ‘/home/alberto/common_interfaces’..Done.
Done.
[0/11] Generating MATLAB interfaces for custom message packages… 0%Error using ()
Key not found.
Error in ros.internal.utilities.checkAndGetCompatibleCompilersLocation (line 73)
matlabInCompatibleCompilerVer = supportedCompilerVersions(matlabLIBSTDCXXVersionNum+1);
Error in ros.internal.ROSProjectBuilder (line 453)
[h.GccLocation, h.GppLocation] = ros.internal.utilities.checkAndGetCompatibleCompilersLocation();
Error in ros.ros2.internal.ColconBuilder (line 26)
h@ros.internal.ROSProjectBuilder(varargin{:});
Error in ros2genmsg (line 278)
builder = ros.ros2.internal.ColconBuilder(genDir, pkgInfos{iPkg}, UseNinja=useNinja, SuppressOutput=suppressOutput);
I tried to recompile ROS packages and even to change compilers’ version, but I can’t find a way out.
I’m working on Ubuntu 22.04, the Matlab version that I’m using is:
MATLAB Version: 23.2.0.2599560 (R2023b) Update 8
Operating System: Linux 6.5.0-45-generic #45~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Mon Jul 15 16:40:02 UTC 2 x86_64
Java Version: Java 1.8.0_202-b08 with Oracle Corporation Java HotSpot(TM) 64-Bit Server VM mixed mode
Following, I’m reporting versions of gcc, g++, Python, cmake and ROS:
gcc (Ubuntu 10.5.0-1ubuntu1~22.04) 10.5.0
g++ (Ubuntu 10.5.0-1ubuntu1~22.04) 10.5.0
Python 3.10.12
cmake 3.22.1
ROS2 humble
Thanks for the help.Hi,
I’m trying to implement some ROS2 custom messages into Matlab and I’ve not found a solution yet.
I downloaded the following repo: https://github.com/ros2/common_interfaces.git
In order to recreate the errors:
download the repo (I choose to clone it in the home);
open Matlab and move to this folder;
give the following command in the command window
ros2genmsg(".")
After this, I get these errors:
>> ros2genmsg(".")
Identifying message files in folder ‘/home/alberto/common_interfaces’..Validating message files in folder ‘/home/alberto/common_interfaces’..Done.
Done.
[0/11] Generating MATLAB interfaces for custom message packages… 0%Error using ()
Key not found.
Error in ros.internal.utilities.checkAndGetCompatibleCompilersLocation (line 73)
matlabInCompatibleCompilerVer = supportedCompilerVersions(matlabLIBSTDCXXVersionNum+1);
Error in ros.internal.ROSProjectBuilder (line 453)
[h.GccLocation, h.GppLocation] = ros.internal.utilities.checkAndGetCompatibleCompilersLocation();
Error in ros.ros2.internal.ColconBuilder (line 26)
h@ros.internal.ROSProjectBuilder(varargin{:});
Error in ros2genmsg (line 278)
builder = ros.ros2.internal.ColconBuilder(genDir, pkgInfos{iPkg}, UseNinja=useNinja, SuppressOutput=suppressOutput);
I tried to recompile ROS packages and even to change compilers’ version, but I can’t find a way out.
I’m working on Ubuntu 22.04, the Matlab version that I’m using is:
MATLAB Version: 23.2.0.2599560 (R2023b) Update 8
Operating System: Linux 6.5.0-45-generic #45~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Mon Jul 15 16:40:02 UTC 2 x86_64
Java Version: Java 1.8.0_202-b08 with Oracle Corporation Java HotSpot(TM) 64-Bit Server VM mixed mode
Following, I’m reporting versions of gcc, g++, Python, cmake and ROS:
gcc (Ubuntu 10.5.0-1ubuntu1~22.04) 10.5.0
g++ (Ubuntu 10.5.0-1ubuntu1~22.04) 10.5.0
Python 3.10.12
cmake 3.22.1
ROS2 humble
Thanks for the help. Hi,
I’m trying to implement some ROS2 custom messages into Matlab and I’ve not found a solution yet.
I downloaded the following repo: https://github.com/ros2/common_interfaces.git
In order to recreate the errors:
download the repo (I choose to clone it in the home);
open Matlab and move to this folder;
give the following command in the command window
ros2genmsg(".")
After this, I get these errors:
>> ros2genmsg(".")
Identifying message files in folder ‘/home/alberto/common_interfaces’..Validating message files in folder ‘/home/alberto/common_interfaces’..Done.
Done.
[0/11] Generating MATLAB interfaces for custom message packages… 0%Error using ()
Key not found.
Error in ros.internal.utilities.checkAndGetCompatibleCompilersLocation (line 73)
matlabInCompatibleCompilerVer = supportedCompilerVersions(matlabLIBSTDCXXVersionNum+1);
Error in ros.internal.ROSProjectBuilder (line 453)
[h.GccLocation, h.GppLocation] = ros.internal.utilities.checkAndGetCompatibleCompilersLocation();
Error in ros.ros2.internal.ColconBuilder (line 26)
h@ros.internal.ROSProjectBuilder(varargin{:});
Error in ros2genmsg (line 278)
builder = ros.ros2.internal.ColconBuilder(genDir, pkgInfos{iPkg}, UseNinja=useNinja, SuppressOutput=suppressOutput);
I tried to recompile ROS packages and even to change compilers’ version, but I can’t find a way out.
I’m working on Ubuntu 22.04, the Matlab version that I’m using is:
MATLAB Version: 23.2.0.2599560 (R2023b) Update 8
Operating System: Linux 6.5.0-45-generic #45~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Mon Jul 15 16:40:02 UTC 2 x86_64
Java Version: Java 1.8.0_202-b08 with Oracle Corporation Java HotSpot(TM) 64-Bit Server VM mixed mode
Following, I’m reporting versions of gcc, g++, Python, cmake and ROS:
gcc (Ubuntu 10.5.0-1ubuntu1~22.04) 10.5.0
g++ (Ubuntu 10.5.0-1ubuntu1~22.04) 10.5.0
Python 3.10.12
cmake 3.22.1
ROS2 humble
Thanks for the help. ros2, matlab, custom messages, ros2genmsg, ubuntu2204 MATLAB Answers — New Questions
Conversion to double from cell is not possible
I’m working with a script that simulates a communication channel, and am running into a "Conversion to doube from cell is not possible". The line throing an error works normally in a script, however when I put it inside a custom defined function within my script I get an error.
R is a 1339×17 double
D is a 16384×1 double
N, Npst, and Npre are constants of 1352, 13, and 2, respectively.
How could I cast the cell into a double without having an error being thrown?
Thanks!I’m working with a script that simulates a communication channel, and am running into a "Conversion to doube from cell is not possible". The line throing an error works normally in a script, however when I put it inside a custom defined function within my script I get an error.
R is a 1339×17 double
D is a 16384×1 double
N, Npst, and Npre are constants of 1352, 13, and 2, respectively.
How could I cast the cell into a double without having an error being thrown?
Thanks! I’m working with a script that simulates a communication channel, and am running into a "Conversion to doube from cell is not possible". The line throing an error works normally in a script, however when I put it inside a custom defined function within my script I get an error.
R is a 1339×17 double
D is a 16384×1 double
N, Npst, and Npre are constants of 1352, 13, and 2, respectively.
How could I cast the cell into a double without having an error being thrown?
Thanks! matlab, cell, double, conversion error MATLAB Answers — New Questions
Mesh for Teams license for government
I work for the government. Looking in our Microsoft 365 admin center, I see we own:
Microsoft 365 G3 GCC Microsoft 365 G3 GCC
Microsoft 365 G5 Compliance GCC Microsoft 365 G5 Compliance GCC
Microsoft 365 G5 Security GCC Microsoft 365 G5 Security GCC
Microsoft Teams Premium for GCC Introductory Pricing Microsoft Teams Premium for GCC Introductory Pricing
Microsoft Teams Rooms Pro for GCC Microsoft Teams Rooms Pro for GCC
Do we have license for Mesh for Teams? I ask because per aka.ms/meshprep, there is mention of Premium license in a tenant for “Commercial”.
I work for the government. Looking in our Microsoft 365 admin center, I see we own:Microsoft 365 G3 GCC Microsoft 365 G3 GCCMicrosoft 365 G5 Compliance GCC Microsoft 365 G5 Compliance GCCMicrosoft 365 G5 Security GCC Microsoft 365 G5 Security GCCMicrosoft Teams Premium for GCC Introductory Pricing Microsoft Teams Premium for GCC Introductory PricingMicrosoft Teams Rooms Pro for GCC Microsoft Teams Rooms Pro for GCC Do we have license for Mesh for Teams? I ask because per aka.ms/meshprep, there is mention of Premium license in a tenant for “Commercial”. Read More
Hybrid TaskBar
Personally, I think it’d be nice to have a windows 11 setting that has the apps and search bar in the middle and the windows bar in the bottom left, due to the fact it’s been there for about 30 years, so it’s a hard habit to break for those who were there from the start.
Personally, I think it’d be nice to have a windows 11 setting that has the apps and search bar in the middle and the windows bar in the bottom left, due to the fact it’s been there for about 30 years, so it’s a hard habit to break for those who were there from the start. Read More
“Ugh-oh, there was a problem while creating your booking page” – all users unable to create bookings
All of our users are unable to create shared bookings pages. We have tried via Teams and signed in to Office.com, trying on multiple web browsers. All users have the Microsoft Bookings app assignment granted in 365 Admin Center. I have also turned off Bookings using Powershell, and turned it back on with no success.
Is Bookings as a service working for others? Some users are also reporting that personal bookings calendars have disappeared.
Error attached here:
All of our users are unable to create shared bookings pages. We have tried via Teams and signed in to Office.com, trying on multiple web browsers. All users have the Microsoft Bookings app assignment granted in 365 Admin Center. I have also turned off Bookings using Powershell, and turned it back on with no success. Is Bookings as a service working for others? Some users are also reporting that personal bookings calendars have disappeared. Error attached here: Read More
Pop up reminder based when specific wording is present (VBA or Macro?)
I am trying to create a pop up message/reminder/alert when certain projects read “Overdue” in certain cells.
Is there a simple formula or code that can notify when a cell reads Overdue?
Once I enter dates for my many projects, there are formulas for each project that show when the due date is and whether the project is currently “Not due or Overdue” based on those dates/data.
I am looking to have a pop up reminder or Macro of some sort that I can quickly check if any dates are “Overdue”.
Any and all help is much appreciated !
I am trying to create a pop up message/reminder/alert when certain projects read “Overdue” in certain cells. Is there a simple formula or code that can notify when a cell reads Overdue? Once I enter dates for my many projects, there are formulas for each project that show when the due date is and whether the project is currently “Not due or Overdue” based on those dates/data. I am looking to have a pop up reminder or Macro of some sort that I can quickly check if any dates are “Overdue”. Any and all help is much appreciated ! Read More
Finding mode of each row in an array of Strings
Currently I have an array with 3 columns and a lot of rows (about 50,000). Each value is a string I essentially want to compare the 3 values in a row and find the most common.
Say my input table looked like the following
Apple Bannana Apple
Cherry Cherry Apple
Mango Mango Mango
My outputs would be
Apple
Cherry
Mango
Please let me know if there is any advice, I have tried mode but it does not work for strings.Currently I have an array with 3 columns and a lot of rows (about 50,000). Each value is a string I essentially want to compare the 3 values in a row and find the most common.
Say my input table looked like the following
Apple Bannana Apple
Cherry Cherry Apple
Mango Mango Mango
My outputs would be
Apple
Cherry
Mango
Please let me know if there is any advice, I have tried mode but it does not work for strings. Currently I have an array with 3 columns and a lot of rows (about 50,000). Each value is a string I essentially want to compare the 3 values in a row and find the most common.
Say my input table looked like the following
Apple Bannana Apple
Cherry Cherry Apple
Mango Mango Mango
My outputs would be
Apple
Cherry
Mango
Please let me know if there is any advice, I have tried mode but it does not work for strings. table, matrices MATLAB Answers — New Questions
How to give range of cells different variable names?
Hello!
I am collecting data from a range of cells from an .xlsx file using the readmatrix function as so:
Datafiles(j).data = readmatrix(Data,’Sheet’,’Report’,’Range’,’M18:N18′,’FileType’,’spreadsheet’);
Then I populate that data into a new excel file like so:
CurrentData = {Datafiles.data}’;
TABLE_Pass = table(CurrentData);
TABLE = vertcat(TABLE_Pass);
Now, my problem is, it spits out the data in 2 columns labeled "CurrentData_1" "CurrentData_2" and I want to specify the name of the second column.
When I create a second variable name, it gives me 4 columns with the information doubled.
Any tips on how to give the data 2 separate variable names?Hello!
I am collecting data from a range of cells from an .xlsx file using the readmatrix function as so:
Datafiles(j).data = readmatrix(Data,’Sheet’,’Report’,’Range’,’M18:N18′,’FileType’,’spreadsheet’);
Then I populate that data into a new excel file like so:
CurrentData = {Datafiles.data}’;
TABLE_Pass = table(CurrentData);
TABLE = vertcat(TABLE_Pass);
Now, my problem is, it spits out the data in 2 columns labeled "CurrentData_1" "CurrentData_2" and I want to specify the name of the second column.
When I create a second variable name, it gives me 4 columns with the information doubled.
Any tips on how to give the data 2 separate variable names? Hello!
I am collecting data from a range of cells from an .xlsx file using the readmatrix function as so:
Datafiles(j).data = readmatrix(Data,’Sheet’,’Report’,’Range’,’M18:N18′,’FileType’,’spreadsheet’);
Then I populate that data into a new excel file like so:
CurrentData = {Datafiles.data}’;
TABLE_Pass = table(CurrentData);
TABLE = vertcat(TABLE_Pass);
Now, my problem is, it spits out the data in 2 columns labeled "CurrentData_1" "CurrentData_2" and I want to specify the name of the second column.
When I create a second variable name, it gives me 4 columns with the information doubled.
Any tips on how to give the data 2 separate variable names? importing excel data MATLAB Answers — New Questions
colorbar graph exceeding matrix values
So I’m plotting a 4D matrix, called Ft, that ranges from 0-1, but when I graph it and add a colorbar, it’s showing 0-2 for physical states 4-15, and (-1)-1for physical state 1-3
physical states 1-3 are 0 for every timestep in the matrix Ft, so that first graph makes sense. Why does the colorbar range change for the other graphs?
Here’s the code for the graphs. Let me know if more code is needed to create the actual Ft matrix. [[ my entire code would be needed in order to create this matrix ]]
%the setup of Ft is Ft(state,est of patch1,est of patch2,timestep)
B = permute(Ft,[2 3 1 4]);
for state= 1:15
figure(state)
sgtitle([‘physical state = ‘ num2str(state)])
time = 1;
subplot(4,5,time)
imagesc(B(:,:,state,time))
title([‘timestep : ‘ num2str(time)])
xlabel(‘est. of patch 2 quality’);
ylabel(‘est. of patch 1 quality’);
set(gca,’ydir’,’normal’)
for time = 2:19
subplot(4,5,time)
imagesc(B(:,:,state,time))
title(num2str(time))
set(gca,’ydir’,’normal’)
for time = 20
subplot(4,5,time)
imagesc(B(:,:,state,time))
title(num2str(time))
set(gca,’ydir’,’normal’)
colormap hot
colorbar
hold on
end
end
endSo I’m plotting a 4D matrix, called Ft, that ranges from 0-1, but when I graph it and add a colorbar, it’s showing 0-2 for physical states 4-15, and (-1)-1for physical state 1-3
physical states 1-3 are 0 for every timestep in the matrix Ft, so that first graph makes sense. Why does the colorbar range change for the other graphs?
Here’s the code for the graphs. Let me know if more code is needed to create the actual Ft matrix. [[ my entire code would be needed in order to create this matrix ]]
%the setup of Ft is Ft(state,est of patch1,est of patch2,timestep)
B = permute(Ft,[2 3 1 4]);
for state= 1:15
figure(state)
sgtitle([‘physical state = ‘ num2str(state)])
time = 1;
subplot(4,5,time)
imagesc(B(:,:,state,time))
title([‘timestep : ‘ num2str(time)])
xlabel(‘est. of patch 2 quality’);
ylabel(‘est. of patch 1 quality’);
set(gca,’ydir’,’normal’)
for time = 2:19
subplot(4,5,time)
imagesc(B(:,:,state,time))
title(num2str(time))
set(gca,’ydir’,’normal’)
for time = 20
subplot(4,5,time)
imagesc(B(:,:,state,time))
title(num2str(time))
set(gca,’ydir’,’normal’)
colormap hot
colorbar
hold on
end
end
end So I’m plotting a 4D matrix, called Ft, that ranges from 0-1, but when I graph it and add a colorbar, it’s showing 0-2 for physical states 4-15, and (-1)-1for physical state 1-3
physical states 1-3 are 0 for every timestep in the matrix Ft, so that first graph makes sense. Why does the colorbar range change for the other graphs?
Here’s the code for the graphs. Let me know if more code is needed to create the actual Ft matrix. [[ my entire code would be needed in order to create this matrix ]]
%the setup of Ft is Ft(state,est of patch1,est of patch2,timestep)
B = permute(Ft,[2 3 1 4]);
for state= 1:15
figure(state)
sgtitle([‘physical state = ‘ num2str(state)])
time = 1;
subplot(4,5,time)
imagesc(B(:,:,state,time))
title([‘timestep : ‘ num2str(time)])
xlabel(‘est. of patch 2 quality’);
ylabel(‘est. of patch 1 quality’);
set(gca,’ydir’,’normal’)
for time = 2:19
subplot(4,5,time)
imagesc(B(:,:,state,time))
title(num2str(time))
set(gca,’ydir’,’normal’)
for time = 20
subplot(4,5,time)
imagesc(B(:,:,state,time))
title(num2str(time))
set(gca,’ydir’,’normal’)
colormap hot
colorbar
hold on
end
end
end graph, colorbar MATLAB Answers — New Questions
code of load flow equation four buses
clc
clear all
cg =[0.86 0 0 0.6];
Pg = [0 0 0 318];
Pd = [50 170 200 80];
Qd = [30.9 105.35 123.94 49.58];
Y = [9.934-1i*44.925, -3.815+1i*19.078, -5.169+1i*25.847, 0
-3.815+1i*19.078, 8.984 – 1i*44.925, 0, -5.169+1i*25.847
-5.169+1i*25.847, 0, 8.192 – 1i*40.965, -3.023 + 1i*15.118
0, -5.169+1i*25.847, -3.023 + 1i*15.118, 8.192 – 1i*40.965];
Pg=sdpvar(1,4);
Qg = sdpvar(1,4);
objective= sum(cg.*Qg)
Qgmin=[-100 0 0 -100];
Qgmax =[100 0 0 100];
Pgmin =[0 0 0 0];
Pgmax =[318 0 0 318];
vang = sdpvar(1,4);
vmag = sdpvar(1,4);
vmin =0.9;
vmax =1.1
Constraints = [];
[Costraints,Pg(1,1)-Pd(1,1)==vmag(1,1)*[vmag(1,1)*Ymag(1,1)*cos(Yang(1,1))+…
vmag(1,2)*Ymag(2,1)*cos(Yang(2,1) + vang(1,1) – vang(1,2))+…
vmag(1,3)*Ymag(3,1)*cos(Yang(3,1) + vang(1,1) – vang(1,3))+…
vmag(1,4)*Ymag(4,1)*cos(Yang(4,1) + vang(1,1) – vang(4))];
[Costraints,Qg(1,1)-Qd(1,1)==(-vmag)(1,1)*[vmag(1,1)*Ymag(1,1)*sin(Yang(1,1))+…
vmag(1,2)*Ymag(2,1)*sin(Yang(2,1) + vang(1,1) – vang(1,2))+…
vmag(1,3)*Ymag(3,1)*sin(Yang(3,1) + vang(1,1) – vang(1,3))+…
vmag(1,4)*Ymag(4,1)*sin(Yang(4,1) + vang(1,1) – vang(4))];
% Constraints = [Constraints,sum(Pg)==sum(Pd)];
% Constraints=[Constraints,Pg(i)-Pd(i)=P(i)]
% Constraints=[Constraints,Qg(i)-Qd(i)=Q(i)]
Constraints = [Constraints,0<=Pg<=318];
Constraints = [Constraints,-100<=Qg<=100];
Constraints = [Constraints, vmin <= vmag];
Constraints = [Constraints, vmag <= vmax];
options = sdpsettings(‘solver’,’gurobi’);
sol = optimize(Constraints,objective,options);
value(objective)
reactive_power=value(Qg)
active_power=value(Pg)
voltage_mag=value(vmag)
voltage_ang=value(vang)clc
clear all
cg =[0.86 0 0 0.6];
Pg = [0 0 0 318];
Pd = [50 170 200 80];
Qd = [30.9 105.35 123.94 49.58];
Y = [9.934-1i*44.925, -3.815+1i*19.078, -5.169+1i*25.847, 0
-3.815+1i*19.078, 8.984 – 1i*44.925, 0, -5.169+1i*25.847
-5.169+1i*25.847, 0, 8.192 – 1i*40.965, -3.023 + 1i*15.118
0, -5.169+1i*25.847, -3.023 + 1i*15.118, 8.192 – 1i*40.965];
Pg=sdpvar(1,4);
Qg = sdpvar(1,4);
objective= sum(cg.*Qg)
Qgmin=[-100 0 0 -100];
Qgmax =[100 0 0 100];
Pgmin =[0 0 0 0];
Pgmax =[318 0 0 318];
vang = sdpvar(1,4);
vmag = sdpvar(1,4);
vmin =0.9;
vmax =1.1
Constraints = [];
[Costraints,Pg(1,1)-Pd(1,1)==vmag(1,1)*[vmag(1,1)*Ymag(1,1)*cos(Yang(1,1))+…
vmag(1,2)*Ymag(2,1)*cos(Yang(2,1) + vang(1,1) – vang(1,2))+…
vmag(1,3)*Ymag(3,1)*cos(Yang(3,1) + vang(1,1) – vang(1,3))+…
vmag(1,4)*Ymag(4,1)*cos(Yang(4,1) + vang(1,1) – vang(4))];
[Costraints,Qg(1,1)-Qd(1,1)==(-vmag)(1,1)*[vmag(1,1)*Ymag(1,1)*sin(Yang(1,1))+…
vmag(1,2)*Ymag(2,1)*sin(Yang(2,1) + vang(1,1) – vang(1,2))+…
vmag(1,3)*Ymag(3,1)*sin(Yang(3,1) + vang(1,1) – vang(1,3))+…
vmag(1,4)*Ymag(4,1)*sin(Yang(4,1) + vang(1,1) – vang(4))];
% Constraints = [Constraints,sum(Pg)==sum(Pd)];
% Constraints=[Constraints,Pg(i)-Pd(i)=P(i)]
% Constraints=[Constraints,Qg(i)-Qd(i)=Q(i)]
Constraints = [Constraints,0<=Pg<=318];
Constraints = [Constraints,-100<=Qg<=100];
Constraints = [Constraints, vmin <= vmag];
Constraints = [Constraints, vmag <= vmax];
options = sdpsettings(‘solver’,’gurobi’);
sol = optimize(Constraints,objective,options);
value(objective)
reactive_power=value(Qg)
active_power=value(Pg)
voltage_mag=value(vmag)
voltage_ang=value(vang) clc
clear all
cg =[0.86 0 0 0.6];
Pg = [0 0 0 318];
Pd = [50 170 200 80];
Qd = [30.9 105.35 123.94 49.58];
Y = [9.934-1i*44.925, -3.815+1i*19.078, -5.169+1i*25.847, 0
-3.815+1i*19.078, 8.984 – 1i*44.925, 0, -5.169+1i*25.847
-5.169+1i*25.847, 0, 8.192 – 1i*40.965, -3.023 + 1i*15.118
0, -5.169+1i*25.847, -3.023 + 1i*15.118, 8.192 – 1i*40.965];
Pg=sdpvar(1,4);
Qg = sdpvar(1,4);
objective= sum(cg.*Qg)
Qgmin=[-100 0 0 -100];
Qgmax =[100 0 0 100];
Pgmin =[0 0 0 0];
Pgmax =[318 0 0 318];
vang = sdpvar(1,4);
vmag = sdpvar(1,4);
vmin =0.9;
vmax =1.1
Constraints = [];
[Costraints,Pg(1,1)-Pd(1,1)==vmag(1,1)*[vmag(1,1)*Ymag(1,1)*cos(Yang(1,1))+…
vmag(1,2)*Ymag(2,1)*cos(Yang(2,1) + vang(1,1) – vang(1,2))+…
vmag(1,3)*Ymag(3,1)*cos(Yang(3,1) + vang(1,1) – vang(1,3))+…
vmag(1,4)*Ymag(4,1)*cos(Yang(4,1) + vang(1,1) – vang(4))];
[Costraints,Qg(1,1)-Qd(1,1)==(-vmag)(1,1)*[vmag(1,1)*Ymag(1,1)*sin(Yang(1,1))+…
vmag(1,2)*Ymag(2,1)*sin(Yang(2,1) + vang(1,1) – vang(1,2))+…
vmag(1,3)*Ymag(3,1)*sin(Yang(3,1) + vang(1,1) – vang(1,3))+…
vmag(1,4)*Ymag(4,1)*sin(Yang(4,1) + vang(1,1) – vang(4))];
% Constraints = [Constraints,sum(Pg)==sum(Pd)];
% Constraints=[Constraints,Pg(i)-Pd(i)=P(i)]
% Constraints=[Constraints,Qg(i)-Qd(i)=Q(i)]
Constraints = [Constraints,0<=Pg<=318];
Constraints = [Constraints,-100<=Qg<=100];
Constraints = [Constraints, vmin <= vmag];
Constraints = [Constraints, vmag <= vmax];
options = sdpsettings(‘solver’,’gurobi’);
sol = optimize(Constraints,objective,options);
value(objective)
reactive_power=value(Qg)
active_power=value(Pg)
voltage_mag=value(vmag)
voltage_ang=value(vang) optimization cost of reactive power MATLAB Answers — New Questions
Powershell Profiles
Hi! I would like to create profiles for powershell that on launch run commands like ssh to autoconnect to server. I tried making powershell profiles in window but besides of just existing it hasn’t changed anything. When using command New-Item -Path $profile.CurrentUserCurrentHost -ItemType File -Force
It is making profile used by whole powershell. How can i change that so profile for ex. HPServer launches different commands and RPIServer other?
Hi! I would like to create profiles for powershell that on launch run commands like ssh to autoconnect to server. I tried making powershell profiles in window but besides of just existing it hasn’t changed anything. When using command New-Item -Path $profile.CurrentUserCurrentHost -ItemType File -ForceIt is making profile used by whole powershell. How can i change that so profile for ex. HPServer launches different commands and RPIServer other? Read More
Vinesh Phogaat hi hai kya be kar rahe
Ted and I will be in touch with you and your family members
Ted and I will be in touch with you and your family members Read More
Working with a list, but I keep getting errors when updating
Hello!
I’m getting this message in Hebrew (translated to English here):
“The source of the list must be a delimited list or a reference to a single line.”.
“על מקור הרשימה להיות רשימה מופרדת או הפניה לשורה יחידה”
And all I need to do is to update this list, which exists on another page.
I updated it with one value, but the list itself wasn’t updated (I tried to recreate it also, but it didn’t let me, with the same error as above).
I need help about how to update it! And/or how to use as new list in the main sheet.
Please answer,
Thanks for the helpers!
Hello!I’m getting this message in Hebrew (translated to English here):”The source of the list must be a delimited list or a reference to a single line.”.”על מקור הרשימה להיות רשימה מופרדת או הפניה לשורה יחידה”And all I need to do is to update this list, which exists on another page.I updated it with one value, but the list itself wasn’t updated (I tried to recreate it also, but it didn’t let me, with the same error as above).I need help about how to update it! And/or how to use as new list in the main sheet. Please answer,Thanks for the helpers! Read More
Excel Copilot examples for the week of August 12th
The Excel team is happy to share some examples of how Excel Copilot can help you. Here’s what you can look forward to this week:
Monday 12-Aug – Using Excel Copilot to split columns
Tuesday, 13-Aug – Adding email addresses using Excel Copilot (coming soon)
Wednesday, 14-Aug – Working with date columns using Excel Copilot (coming soon)
Thursday, 15-Aug – Converting text to numbers with Excel Copilot (coming soon)
Friday. 16-Aug – Using Excel Copilot to show additional units of measure (coming soon)
Stay tuned,
Microsoft Excel Team
The Excel team is happy to share some examples of how Excel Copilot can help you. Here’s what you can look forward to this week:
Monday 12-Aug – Using Excel Copilot to split columns
Tuesday, 13-Aug – Adding email addresses using Excel Copilot (coming soon)
Wednesday, 14-Aug – Working with date columns using Excel Copilot (coming soon)
Thursday, 15-Aug – Converting text to numbers with Excel Copilot (coming soon)
Friday. 16-Aug – Using Excel Copilot to show additional units of measure (coming soon)
Stay tuned,
Microsoft Excel Team Read More
What’s New in Microsoft EDU webinar – August 2024
Here is our August 2024 webinar agenda:
Copilot for M365 announcements for educators and students
Teams for EDU updates – AI for educators feature rollout and more
Learning Accelerators updates
Reading Coach and Reflect
Clipchamp for EDU rollout
AMA – Ask Microsoft EDU Anything (Q&A)
How to sign up
OPTION 1: August 21st, Wednesday @ 8:00am Pacific Time Register here
OPTION 2: August 21st, Wednesday @ 4:00pm Pacific Time Register here
This is what the webinar portal will look like when you register:
Microsoft Tech Community – Latest Blogs –Read More
