Month: August 2024
Changing border colors for Map Chart made from categories
Hello,
I currently have an excel sheet that contains countries and their associated categories. Example:
Countries:CategoriesUnited StatesCategory 1RussiaCategory 2ChinaCategory 3
When I insert a Map from this data, the countries that I list get colored according to the category and receive a transparent border (hard to tell since the background is white but when copied into PowerPoint the borders appear transparent). When I change the border color for the series under ‘Format’ and ‘Series’ and ‘Border’, ‘Solid Line’, it changes the border color for all countries for which no data is provided, but leaves the transparent borders untouched. How can I change the border color of all my countries which have category data? I am able to manually change each border color individually, but I want a way to change all the borders at once and without using vba.
Also, I am using Excel 365 for Mac—there seem to be some differences in application type.
Thanks!
Hello,I currently have an excel sheet that contains countries and their associated categories. Example:Countries:CategoriesUnited StatesCategory 1RussiaCategory 2ChinaCategory 3When I insert a Map from this data, the countries that I list get colored according to the category and receive a transparent border (hard to tell since the background is white but when copied into PowerPoint the borders appear transparent). When I change the border color for the series under ‘Format’ and ‘Series’ and ‘Border’, ‘Solid Line’, it changes the border color for all countries for which no data is provided, but leaves the transparent borders untouched. How can I change the border color of all my countries which have category data? I am able to manually change each border color individually, but I want a way to change all the borders at once and without using vba.Also, I am using Excel 365 for Mac—there seem to be some differences in application type.Thanks! Read More
hellooooooooooooo
Hello, I’m having a problem that I can’t solve, yesterday my stock input and output system that I made worked well but the input and output columns collapsed and I don’t understand why, I always advance and save, it’s like having a check point, maybe when I go back to a previous save point I get the same error.
Hello, I’m having a problem that I can’t solve, yesterday my stock input and output system that I made worked well but the input and output columns collapsed and I don’t understand why, I always advance and save, it’s like having a check point, maybe when I go back to a previous save point I get the same error. Read More
locking and sorting rows
Is there a way to lock the data of two rows to be able to sort the rows locked together? I am needing to be able to sort by the totals showing at the end of the 1st of the two rows.
example below:
20.5212020.5082.00890.00169.992020.51719.1776.673.3279.99 21.2521.7521.521.5086.002.5688.56178.5620.5202120.5082.00890.00 17.25121715.4261.67869.67162.3321.2521.252121.1784.67892.67 21.521.7521.521.5886.337.4493.77185.77320.521.52121.0084.00892.00
Is there a way to lock the data of two rows to be able to sort the rows locked together? I am needing to be able to sort by the totals showing at the end of the 1st of the two rows.example below:20.5212020.5082.00890.00169.992020.51719.1776.673.3279.99 21.2521.7521.521.5086.002.5688.56178.5620.5202120.5082.00890.00 17.25121715.4261.67869.67162.3321.2521.252121.1784.67892.67 21.521.7521.521.5886.337.4493.77185.77320.521.52121.0084.00892.00 Read More
Learn how to use PivotTables using Copilot in Excel
Greetings, we continue our series of posts this week that show how you can get help from copilot with the chat helper. Today we will show how you can use it to learn how to use PivotTables. We’ll show this by asking Copilot in Excel the following question:
Can you tell me the basics for creating a PivotTable?
Based on the question, Copilot in Excel returns a step-by-step guide for how to create a PivotTable in Excel:
Picture of Copilot in Excel pane showing the above prompt with a step-by-step guide for creating a PivotTable.
“Certainly! Here’s a step-by-step guide to creating a PivotTable in Excel:
Select Your Data: Click on any cell within the range of data you want to use for your PivotTable. Make sure your data has column headings and no blank rows or columns.
Insert PivotTable: Go to the Ribbon, click on the “Insert” tab, and then click on “PivotTable”. Excel will automatically select the data for the PivotTable or you can select the range manually.
Choose Where to Place the PivotTable: In the dialog box that appears, you can choose to place the PivotTable in a new worksheet or in an existing worksheet. Select your preference and click “OK”.
Arrange Fields: Drag and drop the fields from your data (listed in the PivotTable Field List) into one of the four areas:
Filters: To apply filters that affect the entire PivotTable.
Columns: To show data horizontally across the top of the PivotTable.
Rows: To display data vertically on the side of the PivotTable.
Values: To aggregate data (sum, count, average, etc.) in the body of the PivotTable.
Customize Your PivotTable: You can further customize your PivotTable by sorting, filtering, and formatting the data. You can also change the summary function and refresh the data if the source data changes.
Refresh PivotTable: If the source data changes, you can update the PivotTable by right-clicking anywhere in the PivotTable and selecting “Refresh”.
Remember to check that your data is well-organized, with no empty rows or columns, and that each column has a unique header. This will ensure that your PivotTable works correctly.”
The response is a good overview. If you want to go a bit deeper and get more detail, you could use the following prompt:
Can you give me a more detailed example?
Copilot in Excel returns more information, using a sales data set as an example and shows how a PivotTable may layout the data:
Picture of Copilot in Excel pane showing the above prompt with a detailed example for creating a PivotTable.
“Certainly! Let’s say you have a sales dataset with the following columns: Date, Product, Region, Salesperson, and Sales. Here’s how you would create a PivotTable to analyze total sales by product and region:
Select Your Data: Click on any cell within your dataset. Ensure that each column has a unique header and there are no blank rows or columns in your range.
Insert PivotTable: Go to the “Insert” tab on the Ribbon and click on “PivotTable”. Excel will select the data for the PivotTable or you can adjust the range if needed.
Choose PivotTable Location: In the Create PivotTable dialog box, choose to place the PivotTable in a new worksheet or an existing worksheet. Click “OK”.
Arrange Fields: In the PivotTable Field List, drag and drop the Product field to the Rows area, the Region field to the Columns area, and the Sales field to the Values area. This will create a matrix with products listed down the rows, regions across the columns, and the sum of sales in the body of the PivotTable.
Customize Your PivotTable: You can sort the products or regions, apply filters, or change the summary function from sum to count, average, etc., by using the dropdown menus in the PivotTable.
Refresh PivotTable: If your source data changes, right-click anywhere in the PivotTable and select “Refresh” to update the data.
Here’s an example of what the PivotTable could look like:
| Region 1 | Region 2 | Region 3 | Grand Total
—————————————————–
Product A | $5,000 | $7,000 | $4,000 | $16,000
Product B | $3,000 | $8,000 | $2,000 | $13,000
Product C | $6,000 | $2,000 | $3,000 | $11,000
—————————————————–
Grand Total | $14,000 | $17,000 | $9,000 | $40,000
This PivotTable shows the total sales for each product in each region, as well as the grand totals for each product and each region.”
Over the coming weeks I will be sharing 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.
Greetings, we continue our series of posts this week that show how you can get help from copilot with the chat helper. Today we will show how you can use it to learn how to use PivotTables. We’ll show this by asking Copilot in Excel the following question:
Can you tell me the basics for creating a PivotTable?
Based on the question, Copilot in Excel returns a step-by-step guide for how to create a PivotTable in Excel:
Picture of Copilot in Excel pane showing the above prompt with a step-by-step guide for creating a PivotTable.
“Certainly! Here’s a step-by-step guide to creating a PivotTable in Excel:
Select Your Data: Click on any cell within the range of data you want to use for your PivotTable. Make sure your data has column headings and no blank rows or columns.
Insert PivotTable: Go to the Ribbon, click on the “Insert” tab, and then click on “PivotTable”. Excel will automatically select the data for the PivotTable or you can select the range manually.
Choose Where to Place the PivotTable: In the dialog box that appears, you can choose to place the PivotTable in a new worksheet or in an existing worksheet. Select your preference and click “OK”.
Arrange Fields: Drag and drop the fields from your data (listed in the PivotTable Field List) into one of the four areas:
Filters: To apply filters that affect the entire PivotTable.
Columns: To show data horizontally across the top of the PivotTable.
Rows: To display data vertically on the side of the PivotTable.
Values: To aggregate data (sum, count, average, etc.) in the body of the PivotTable.
Customize Your PivotTable: You can further customize your PivotTable by sorting, filtering, and formatting the data. You can also change the summary function and refresh the data if the source data changes.
Refresh PivotTable: If the source data changes, you can update the PivotTable by right-clicking anywhere in the PivotTable and selecting “Refresh”.
Remember to check that your data is well-organized, with no empty rows or columns, and that each column has a unique header. This will ensure that your PivotTable works correctly.”
The response is a good overview. If you want to go a bit deeper and get more detail, you could use the following prompt:
Can you give me a more detailed example?
Copilot in Excel returns more information, using a sales data set as an example and shows how a PivotTable may layout the data:
Picture of Copilot in Excel pane showing the above prompt with a detailed example for creating a PivotTable.
“Certainly! Let’s say you have a sales dataset with the following columns: Date, Product, Region, Salesperson, and Sales. Here’s how you would create a PivotTable to analyze total sales by product and region:
Select Your Data: Click on any cell within your dataset. Ensure that each column has a unique header and there are no blank rows or columns in your range.
Insert PivotTable: Go to the “Insert” tab on the Ribbon and click on “PivotTable”. Excel will select the data for the PivotTable or you can adjust the range if needed.
Choose PivotTable Location: In the Create PivotTable dialog box, choose to place the PivotTable in a new worksheet or an existing worksheet. Click “OK”.
Arrange Fields: In the PivotTable Field List, drag and drop the Product field to the Rows area, the Region field to the Columns area, and the Sales field to the Values area. This will create a matrix with products listed down the rows, regions across the columns, and the sum of sales in the body of the PivotTable.
Customize Your PivotTable: You can sort the products or regions, apply filters, or change the summary function from sum to count, average, etc., by using the dropdown menus in the PivotTable.
Refresh PivotTable: If your source data changes, right-click anywhere in the PivotTable and select “Refresh” to update the data.
Here’s an example of what the PivotTable could look like:
| Region 1 | Region 2 | Region 3 | Grand Total
—————————————————–
Product A | $5,000 | $7,000 | $4,000 | $16,000
Product B | $3,000 | $8,000 | $2,000 | $13,000
Product C | $6,000 | $2,000 | $3,000 | $11,000
—————————————————–
Grand Total | $14,000 | $17,000 | $9,000 | $40,000
This PivotTable shows the total sales for each product in each region, as well as the grand totals for each product and each region.”
Over the coming weeks I will be sharing 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
Announcement: System.Data.SqlClient package is now deprecated
We announced Microsoft.Data.SqlClient in the first half of 2019 and shipped the first stable package later that year. That release coincided with .NET Core 3.0. We’ve been developing Microsoft.Data.SqlClient in the dotnet/SqlClient repo since that time, over the last five years. It’s now time to start the deprecation process for the System.Data.SqlClient package. We plan to take a staged process to deprecation, with the intent to align support changes and associated code transition activities between these libraries to natural migration points between .NET major versions.
All System.Data.SqlClient users are encouraged to transition to Microsoft.Data.SqlClient. We offer improvements and significantly higher support via the Microsoft.Data.SqlClient package.
Plan
We intend to deprecate the System.Data.SqlClient package in stages.
Before .NET 9 GA:
Publish a new 5.0.0 package, including the following changes.
Remove support for .NET 7 and earlier and .NET Framework 4.6.1 and earlier.
Publish assets for the following target frameworks: .NET 8, .NET Framework 4.6.2, .NET Standard 2.0.
Add Obsolete attributes to .NET 8 and .NET Standard 2.0 assets. This will generate new warnings for .NET 8+ and .NET Standard users.
Continue to offer security servicing, for .NET 8, and .NET Framework 4.6.2+ application users.
After .NET 9 GA:
No change
We will not support this package for .NET 9+ application users.
After .NET 8 EOL:
Remove support for .NET 8 users (the .NET 8 library will be removed).
Maintain support for .NET Framework 4.6.2+ users.
Security servicing will be provided via .NET Framework, not the package, at that point.
We do not expect to update the package again after this point.
We will not mark the package as deprecated since it will only support .NET Framework users with an implementation provided by .NET Framework.
We will remove support in the package for unsupported .NET and .NET Framework versions at various stages of this deprecation plan. Users affected by those changes are encouraged to move to a supported .NET or .NET Framework version and to adopt the Microsoft.Data.SqlClient package.
We decided to remove support for .NET 6 since it will go EOL shortly after this new package is released, even though .NET 6 will still be supported at the time. Publishing a .NET 8 library significantly simplifies the plan, both in terms of what we will deliver and what we need to explain.
For .NET dates, see .NET Releases. .NET 9 will GA in November of this year. .NET 8 will go EOL in November, 2026.
The current package version of System.Data.SqlClient is 4.8.6, at the time of writing. These changes will be made with a 5.0.0 version and later.
Note: This deprecation doesn’t apply to the System.Data.SqlClient namespace in .NET Framework.
Microsoft.Data.SqlClient
Daily downloads of Microsoft.Data.SqlClient on nuget.org are nearing 50% higher than System.Data.SqlClient. We expect the gap in usage between the two libraries will continue to increase. Microsoft.Data.SqlClient is the best library we offer to access SQL Server.
We are committed to providing high-quality, performance-driven, and secure data access technologies. We strongly encourage users to transition to Microsoft.Data.SqlClient. It is actively maintained and supports the latest SQL Server features.
How to migrate?
Add the NuGet package to your project, then update your references and using statements. Our porting cheat sheet provides a step-by-step set of changes you may need to make.
Update your project references: Replace references to System.Data.SqlClient with Microsoft.Data.SqlClient.
Modify your using statements: Update your using statements in your code files from System.Data.SqlClient to Microsoft.Data.SqlClient.
Test your application: Thoroughly test your application to ensure that it works as expected after the migration.
We also plan to support semi-automatic migration via .NET Upgrade Assistant.
Support & Feedback: If you have any questions or need assistance with the migration, please reach out through our official support channels or join the discussion on our GitHub repository.
Resources
Frequently Asked Questions – dotnet/SqlClient Wiki – GitHub
Introduction to Microsoft.Data.SqlClient namespace
SQL Server and ADO.NET (Microsoft.Data.SqlClient)
Microsoft.Data.SqlClient API Browser
Microsoft Tech Community – Latest Blogs –Read More
MVP’s Favorite Content: M365 MVP Week #2
In this blog series dedicated to Microsoft’s technical articles, we’ll highlight our MVPs’ favorite article along with their personal insights.
Kevin McDonnell, M365 MVP, United Kingdom
Copilot Learning Hub | Microsoft Learn
“One of the challenges of Copilot is to realise that there is more than just one. Dona Sarkar has pulled together a huge range of guests to help explain so many of the different areas in the Copilot Learning Hub, with experts across Microsoft and the community for all things Copilot”
Kevin TRELOHAN, M365 MVP, France
Copilot for Microsoft 365 – Service Descriptions | Microsoft Learn
“If you want to learn how copilot for Microsoft 365 works it’s real good page to Pin in your bookmark because you’ve here all links and information to have an overview in each App like Word, Excel, etc…”
*Relevant Event: August 29 – [GAIC-fr] Copilot M365 pour les débutants | LinkedIn
Masayuki Mokudai (もくだいさん), M365 MVP, Japan
“Microsoft Learn offers a wealth of content on Power Automate, but some features are not available to Power Automate Basic users with only a Microsoft 365 license. Therefore, we have created training content that compiles only the necessary information for Microsoft 365 users.”
(In Japanese: Microsoft LearnにはPower Automate に関する豊富なコンテンツがありますが、Microsoft 365ライセンスのみを持つPower Automate Basicユーザーには利用できない機能も含まれています。そこで、Microsoft 365ユーザー向けに必要な情報だけをまとめたトレーニングコンテンツを作成しました。)
*Relevant Blog: Microsoft Learn: ラーニングモジュールで学ぶ365ユーザー向けキャンバスアプリ＆フロー開発 – もくだいさんのOffice365至高のレシピ (mokudai.jp)
Laurent Carlier, M365 MVP, France
Summary of governance, lifecycle, and compliance capabilities for Loop experiences | Microsoft Learn
“Microsoft Loop is undoubtedly one of the tools I’m pushing for internally, but also with my customers, to streamline collaboration and be more active in the project phases. Since its arrival in the Microsoft 365 ecosystem, Loop has come a long way in terms of security, compliance, features, etc. These topics regularly come up in discussions with my customers, which is why I regularly refer to this documentation to understand everything before deploying the Loop application.”
*Relevant Blog: INFOGRAPHICS & ARTICLES | Teams2simple
Microsoft Tech Community – Latest Blogs –Read More
Why do I receive “(MLM) Not master server, checkout attempt of ‘MATLAB’ from user@host refused” in the license manager log file?
Clients are reporting they receive License Manager Error -18 when they try to start MATLAB, and I am seeing errors in the log file. Why do I receive "(MLM) Not master server, checkout attempt of ‘MATLAB’ from user@host refused" in the license manager log file?Clients are reporting they receive License Manager Error -18 when they try to start MATLAB, and I am seeing errors in the log file. Why do I receive "(MLM) Not master server, checkout attempt of ‘MATLAB’ from user@host refused" in the license manager log file? Clients are reporting they receive License Manager Error -18 when they try to start MATLAB, and I am seeing errors in the log file. Why do I receive "(MLM) Not master server, checkout attempt of ‘MATLAB’ from user@host refused" in the license manager log file? MATLAB Answers — New Questions
How to plot the input which is R for LQR?
I am getting 2 outputs my system is inverted pendulum with 4 states.
How can I get the input plot the value of R as well?
further I am gettign only two states the cart position and teh angle of the penduum. How I can plot the other two states velocity and angular velocity in teh same plot where I am getting the position and the pendulum angle?I am getting 2 outputs my system is inverted pendulum with 4 states.
How can I get the input plot the value of R as well?
further I am gettign only two states the cart position and teh angle of the penduum. How I can plot the other two states velocity and angular velocity in teh same plot where I am getting the position and the pendulum angle? I am getting 2 outputs my system is inverted pendulum with 4 states.
How can I get the input plot the value of R as well?
further I am gettign only two states the cart position and teh angle of the penduum. How I can plot the other two states velocity and angular velocity in teh same plot where I am getting the position and the pendulum angle? lqr, inverted pendulum, plotting, subplot MATLAB Answers — New Questions
MS Project Export as CSV not generating non english language data
i have been following below link to save MS Project file as CSV
https://support.microsoft.com/en-us/office/export-or-import-data-to-another-file-format-6e6e581f-a580-4f04-aa87-9b6552143d9c#:~:text=Choose%20File%20%3E%20Save%20As.%20Choose%20Browse.%20In,a%20name%20for%20the%20exported%20file.%20Choose%20Save
using Existing Task Export Map to save as CSV
Issue i am facing is after generating CSV, non English data is getting corrupted, showing as “????????” in the CSV
CSV File generated is getting saved as ANSI encoding, there is no way to change it to UTF 8 in Export Wizard
these are all steps can be done Mannully on MS Project
i also have MSPPlugin written in DotNet which does same exact steps programmatically
have used below APIs to perform the same
https://learn.microsoft.com/en-us/office/vba/api/project.application.mapedit
https://learn.microsoft.com/en-us/office/vba/api/project.application.filesaveas
getting same output as shown in screenshot
Note: I have MS Project Standard 2019 installed on windows
i have been following below link to save MS Project file as CSVhttps://support.microsoft.com/en-us/office/export-or-import-data-to-another-file-format-6e6e581f-a580-4f04-aa87-9b6552143d9c#:~:text=Choose%20File%20%3E%20Save%20As.%20Choose%20Browse.%20In,a%20name%20for%20the%20exported%20file.%20Choose%20Saveusing Existing Task Export Map to save as CSV Issue i am facing is after generating CSV, non English data is getting corrupted, showing as “????????” in the CSV CSV File generated is getting saved as ANSI encoding, there is no way to change it to UTF 8 in Export Wizardthese are all steps can be done Mannully on MS Projecti also have MSPPlugin written in DotNet which does same exact steps programmaticallyhave used below APIs to perform the samehttps://learn.microsoft.com/en-us/office/vba/api/project.application.mapedithttps://learn.microsoft.com/en-us/office/vba/api/project.application.filesaveas getting same output as shown in screenshotNote: I have MS Project Standard 2019 installed on windows Read More
Calendar synchronisation issue between google calendar and outlook desktop mac
Hello Any new entry in my Google calendar doens’t update my mac outlook, where the opposite works
can anybody help ?
Hello Any new entry in my Google calendar doens’t update my mac outlook, where the opposite works can anybody help ? Read More
How to apply NonNegativity constraint in ODE solver when defining ode as a structure
I am trying to perform a local sensitivity analysis on the parameters of my model using odeSensitivity. Taking help from this page https://in.mathworks.com/help/matlab/ref/odesensitivity.html. but the problem is that when I used to code the ode simply I put nonnegativity under options, but now i am not able to do that. I tried taking F.NonNegative=ones(1,n_parameters) but that doesnt seem to work.I am trying to perform a local sensitivity analysis on the parameters of my model using odeSensitivity. Taking help from this page https://in.mathworks.com/help/matlab/ref/odesensitivity.html. but the problem is that when I used to code the ode simply I put nonnegativity under options, but now i am not able to do that. I tried taking F.NonNegative=ones(1,n_parameters) but that doesnt seem to work. I am trying to perform a local sensitivity analysis on the parameters of my model using odeSensitivity. Taking help from this page https://in.mathworks.com/help/matlab/ref/odesensitivity.html. but the problem is that when I used to code the ode simply I put nonnegativity under options, but now i am not able to do that. I tried taking F.NonNegative=ones(1,n_parameters) but that doesnt seem to work. ode, structures MATLAB Answers — New Questions
Matlab onramp course blank screen
I’m trying to do my Matlab onramp course but when i try enter commands the screen is completely blank, and i can’t do anything.I’m trying to do my Matlab onramp course but when i try enter commands the screen is completely blank, and i can’t do anything. I’m trying to do my Matlab onramp course but when i try enter commands the screen is completely blank, and i can’t do anything. matlab, onramp, commands MATLAB Answers — New Questions
Plot contours from counts of a scatter plot
Hi everyone, I’m fairly new to Matlab and i’m not sure how to obtain what i what i want.
I made this graphics where i’m trying to match some datas with my simulation. The prolem is that i’m simulating thtat same amounts of point as the ones in the data set (about 100) but has some statistic problems. So i wanted to simulate more points (about 1000) to use contour lines to show where i have different density of simulated points. This is where i ran into trubles.
I looked into the contour(Z) function, but i’m not sure how to make the Z matrix. I have two vectors, x and y, with the coordinates of my simulated point (and anoters set of twwo vectors for the datas).
I was thinking about using something lixe this to:
Z = histcounts2(x, y, ‘BinWidth’, [n, n], ‘XBinLimits’, [x1 x2], ‘YBinLimits’, [y1 y2])
But I’m not sure wich BinWidht to use to obtain what I want, or even if ot’s the best way to go about it.
Any pointers would be really appreciated,
Thakns to allHi everyone, I’m fairly new to Matlab and i’m not sure how to obtain what i what i want.
I made this graphics where i’m trying to match some datas with my simulation. The prolem is that i’m simulating thtat same amounts of point as the ones in the data set (about 100) but has some statistic problems. So i wanted to simulate more points (about 1000) to use contour lines to show where i have different density of simulated points. This is where i ran into trubles.
I looked into the contour(Z) function, but i’m not sure how to make the Z matrix. I have two vectors, x and y, with the coordinates of my simulated point (and anoters set of twwo vectors for the datas).
I was thinking about using something lixe this to:
Z = histcounts2(x, y, ‘BinWidth’, [n, n], ‘XBinLimits’, [x1 x2], ‘YBinLimits’, [y1 y2])
But I’m not sure wich BinWidht to use to obtain what I want, or even if ot’s the best way to go about it.
Any pointers would be really appreciated,
Thakns to all Hi everyone, I’m fairly new to Matlab and i’m not sure how to obtain what i what i want.
I made this graphics where i’m trying to match some datas with my simulation. The prolem is that i’m simulating thtat same amounts of point as the ones in the data set (about 100) but has some statistic problems. So i wanted to simulate more points (about 1000) to use contour lines to show where i have different density of simulated points. This is where i ran into trubles.
I looked into the contour(Z) function, but i’m not sure how to make the Z matrix. I have two vectors, x and y, with the coordinates of my simulated point (and anoters set of twwo vectors for the datas).
I was thinking about using something lixe this to:
Z = histcounts2(x, y, ‘BinWidth’, [n, n], ‘XBinLimits’, [x1 x2], ‘YBinLimits’, [y1 y2])
But I’m not sure wich BinWidht to use to obtain what I want, or even if ot’s the best way to go about it.
Any pointers would be really appreciated,
Thakns to all ‘countours’ ‘contour plot’ ‘histcounts’ ‘counts’ MATLAB Answers — New Questions
Amplitude White noise in Simulink Matlab
I want to add colored noise to the step signal when I use White noise inside Simulink it has 1/-1 amplitude I want to reduce this amplitude like pink noise which has 0.05/-0.05 amplitude
white noise
pink noiseI want to add colored noise to the step signal when I use White noise inside Simulink it has 1/-1 amplitude I want to reduce this amplitude like pink noise which has 0.05/-0.05 amplitude
white noise
pink noise I want to add colored noise to the step signal when I use White noise inside Simulink it has 1/-1 amplitude I want to reduce this amplitude like pink noise which has 0.05/-0.05 amplitude
white noise
pink noise noise, pinknoise, whitenoise MATLAB Answers — New Questions
How to Activate Workplace Benefits Program (formerly Home Use)
We are recipients of a Microsoft 365 grant for nonprofits.
According to this web page, we should also have access to the Workplace Benefits Program, which gives our employees the option to subscribe to a personal version of Microsoft 365 at a 30% discount. I used to work for a different non-profit that received the Microsoft 365 grant for non-profits and I obtained my discounted Microsoft 365 subscription through the program.
When my organization’s employees at this non-profit (where I work now) try to obtain the benefit, they get an email (shown below) stating that Microsoft cannot offer the workplace benefits discount to my organization’s employees. It directs the employees to contact their HR or IT Admin (I’m the IT Admin, but I don’t know what’s wrong).
Has this happened to anyone else? Does anyone know who I can contact at Microsoft to try to get this straightened out?
Thanks,
Scott
We are recipients of a Microsoft 365 grant for nonprofits. According to this web page, we should also have access to the Workplace Benefits Program, which gives our employees the option to subscribe to a personal version of Microsoft 365 at a 30% discount. I used to work for a different non-profit that received the Microsoft 365 grant for non-profits and I obtained my discounted Microsoft 365 subscription through the program. When my organization’s employees at this non-profit (where I work now) try to obtain the benefit, they get an email (shown below) stating that Microsoft cannot offer the workplace benefits discount to my organization’s employees. It directs the employees to contact their HR or IT Admin (I’m the IT Admin, but I don’t know what’s wrong).Has this happened to anyone else? Does anyone know who I can contact at Microsoft to try to get this straightened out? Thanks,Scott Read More
How do I prevent the Docusign Sender (docusign account) from getting signing request?
Hello All,
I have a Power Automate flow that should be doing the following:
-When signature is required for document, the flow should connect to Docusign and send sign request to the “Department approver” (Note there is a department list where each department is having a department approver).
-So when uploaded document’s department is “Legal” (For example), the approver specified for this department will be getting docusign email to sign document
-Once signed, signed document will be published in library
I have got the above flow working. But the problem is this:
-The connection to docusign is in name of User A, and the person who should Sign the document should only be the department approver (say user B).
-but when I test the flow, Docusign is sending 2 emails (to both user A who is the docusign account login user, and also the user B who is the department approver). User A should not be getting the signing request. Only the department approver (Recipient) should be signing the document
Can you help me understand how and where I can tweak either the template in docusign, or power automate, to not have the sender sign the document (and only have the recipient , who in this case is approver, receive the signing request?)
Here is the template I have created in Docusign (by signing as user A). Here the name and email I had given, is the user that I am logged in to docusign with.
The person who should be signing the document is the department approver (thats specified in the “department approvers” column in the below list)
This is the section of the flow that asks if esign is required, and if so, creates envelope with recipients
Below is a more drill down view of the above flow steps, where I declare variable to capture department approver (from the department list I screenshotted above), then I create envelope using the template I created in docusign. Then I set a variable to capture envelope ID . Then I update the properties of the uploaded document, where I am setting status to “pending signature” and the envelope id column to the envelope id variable
Then there is another flow that looks for changes in an envelope status, gets document from the envelope and then publishes document to library with signed status
Now when I execute these flows,they work. But Docusign sends signing request to both the sender(user A who is the docusign account user) and also the department approver (which I declared in variable in flow). Only the dept approver should get the email, and not the sender.
Please advice what changes should I make?
Hello All, I have a Power Automate flow that should be doing the following:-When signature is required for document, the flow should connect to Docusign and send sign request to the “Department approver” (Note there is a department list where each department is having a department approver).-So when uploaded document’s department is “Legal” (For example), the approver specified for this department will be getting docusign email to sign document-Once signed, signed document will be published in libraryI have got the above flow working. But the problem is this: -The connection to docusign is in name of User A, and the person who should Sign the document should only be the department approver (say user B).-but when I test the flow, Docusign is sending 2 emails (to both user A who is the docusign account login user, and also the user B who is the department approver). User A should not be getting the signing request. Only the department approver (Recipient) should be signing the document Can you help me understand how and where I can tweak either the template in docusign, or power automate, to not have the sender sign the document (and only have the recipient , who in this case is approver, receive the signing request?) Here is the template I have created in Docusign (by signing as user A). Here the name and email I had given, is the user that I am logged in to docusign with. The person who should be signing the document is the department approver (thats specified in the “department approvers” column in the below list)This is the section of the flow that asks if esign is required, and if so, creates envelope with recipientsBelow is a more drill down view of the above flow steps, where I declare variable to capture department approver (from the department list I screenshotted above), then I create envelope using the template I created in docusign. Then I set a variable to capture envelope ID . Then I update the properties of the uploaded document, where I am setting status to “pending signature” and the envelope id column to the envelope id variable Then there is another flow that looks for changes in an envelope status, gets document from the envelope and then publishes document to library with signed status Now when I execute these flows,they work. But Docusign sends signing request to both the sender(user A who is the docusign account user) and also the department approver (which I declared in variable in flow). Only the dept approver should get the email, and not the sender.Please advice what changes should I make? Read More
Data not showing in the column
Hello! On my SharePoint list, the data is not showing for few columns. When I click on each item, I can
see that data was entered but I just don’t know why it’s not showing up.
Hello! On my SharePoint list, the data is not showing for few columns. When I click on each item, I cansee that data was entered but I just don’t know why it’s not showing up. Read More
Adding a , after a group of text
Good morning, I was looking to add a ,(coma) and a space after every 4 characters.
For example,
qwerasdfzxcv ——> qwer, asdf, zxcv
Ive been able to just add 1 , after qwer, but no multple using
=replace(a1,5,0,”, “)
im sure I can probably tie in the same formula Mutiple times but have no clue how
Good morning, I was looking to add a ,(coma) and a space after every 4 characters.For example,qwerasdfzxcv ——> qwer, asdf, zxcv Ive been able to just add 1 , after qwer, but no multple using =replace(a1,5,0,”, “) im sure I can probably tie in the same formula Mutiple times but have no clue how Read More
Super master
name”:”آدرس ایمیل به دلایل حفظ حریم خصوصی حذف شد”,”globalState”:”{“storage”:{“workbench.panel.markers.hidden”:”[{\”id “:”workbench.panel.markers.view\”,\”isHidden\”:false}]”,”workbench.panel.output.hidden”:”[{ \”id”:”workbench.panel.output\”,”isHidden\”:false}]”,”terminal.hidden”:” [{\”id\”:\”terminal\”,”isHidden\”:false}]””workbench.scm.views.state.hidden “:”[{\”id\”:”workbench.scm.\”,\” isHidden\ “:true}،{\”id \”:\”workbench.. scm\”,\”isHidden\”:false},{\”id\”:”workbench.scm.sync \”,”isHidden\”:false}]”,”workbench.view.search.state.hidden”:”[{\”id”:\”:\”workbench.view.search\”,”isHidden\”:false}]”,”workbench.explorer.views.state.hidden”:”[{\” id\”:”طرح کلی\”,”isHidden\”:false},{\”id\”:”زمان خط\”, \”isHidden\”:false},{\”id\”:\” workbench.explorer.openEditorsView\”,\”isHidden\” :true} ,{\\”id\”:\”workbench.explorer.emptyView\”,”isHidden\”:false}]”,”workbench.activity.pinnedViewlets2 “:”[{\”id\”:”workbench.view.explorer\”,\”pinned\”:true,\”visible\” “:true,\”order\”:0},{\”id\”:”workbench.view.search\”,”پین شده\” “:true,”visible\”:true,\”order”:1},{\”id\”:”workbench.view.scm \”,”پین شده\”:true,\” visible\”:true,\”order\”:2},{\”id\” “:”workbench.view.debug\ “,\”پین شده\”:true,\”visible\”:true,\”order\”: 3},{\\”id\”:”workbench.view.extensions\”,”pinned\”:true,\”visible\”: true، \”order\”:4},{\”id”:”workbench.view.remote\”,\”pinned\”: true، \”visible\”:true, \”order”:4},{\”id\”:”workbench.view.extension.test \”,\”پین شده”:true,\”visible\”:false,\”order\”:6},{\\ “id\” “:”workbench.view.extension.references-view\”,”pinned”:true,\” visible\”:false,\”order” \”:7}،{\”id\”:”workbench.. panel.chatSidebar\”,”pinned\”:true,\”visible” \”:false,\”order\”:100},{\”id”:”userDataProfiles\”,”پین شده”:true},{\”visible\”:true},{\”id\”:” workbench.view.editSessions\”,”پین شده\”:true, \”visible\”:false},{\”id\”:” workbench.view.sync\”,”pinned\ “:true,\”visible\”:false}]”,”اخیرا باز شده”:”{\”ورودی ها\”:[{“فضای کاری\”:{\\ “id\”:\”-2ad0bbb\”,”configPath\ “:\”tmp:/default.code-workspace\”}}]}”,”workbench.view.debug.state.hidden”:”[{\”id \”:”workbench.debug.welcome\”,”isHidden\”:false},{\”id\”:\”workbench.debug. variablesView\”,”isHidden\”:false},{\”id\”:”workbench.debug.watchExpressionsView\”,”isHidden” \”:false},{\ “id\”:”workbench.. debug.callStackView\”,”isHidden\”:false},{\” id\”:\\” میز کار. debug.loadedScriptsView\”,”isHidden\”:false}،{\”id\”:\”میز کار. debug.breakPointsView\”,”isHidden\”:false}]”,”workbench.telemetryOptOutShown”:”true”,”workbench.statusbar.hidden”:” [\”status.workspaceTrust.-2ad0bbb\”]”,”workbench.view.remote.state.hidden”:”[{\”id\”:\ “remoteHub.views.workspaceRepositories\”,” isHidden\”:false},{\”id\”:”remoteTargets\”,\”isHidden \”:false}]”” workbench.panel.pinnedPanels”:”[{\”id\”:\”workbench.panel.markers\”, \”name\”:\”مشکلات\”,”پین شده\”:true،\”سفارش\”:0، \”قابل مشاهده\ “:true}،{\”id\”:”workbench.panel.output\”,”name\”:”خروجی\”:true,\”سفارش”:true,”سفارش”:1, \”visible\”:true},{\”id\”: \”workbench.panel.repl\”,\\”name\”:”Debug Console\”,”pinned\”:true,\” order\”:2,”visible\”:false},{\”id\”:”workbench.panel.testResults\”,” name\”:\”نتایج تست”,”پین شده\”:true,\” ترتیب\”:3, “visible\” :false},{\”id\”:”terminal\”,”name\”:”Terminal\”,”پین شد \”:true،\”order”:3، \”visible\”:true}،{\”id\”:\” refactorPreview\ “”name\”:”Refactor Preview\”,”pinned\”:true,\”visible\ “:false}] “,”workbench.welcomePage.walkthroughMtadata”:”[[\”ms-vscode.remote-repositories#remoteRepositoriesWalkthrough\”,{“firstSeen\”:1695519464371,\”stepIDs\”:[ \”editCommitRepo\”,”createGitHubPullRequest\”,”continueOn\”,”openRepo\”,”RemoteIndicator\”] ,”manaullyOpened\”:false}]]”,”themeUpdatedNotificationShown “:”true”,”colorThemeData”:”{“id”: \”vs-dark vscode-theme-defaults-themes-dark_ modern-json\”,\\”label”:”Dark Modern\”,\”settingsId\” “:\”پیش فرض Dark Modern\”,”themeTokenColors\”:[{\\”settings”:{\”پیش زمینه\”:\”#D4D4D4\”}، \”scope\”:[\”meta.embedded\”,\”source.groovy.embedded\”, “string meta.image.inline.markdown\”,”variable.legacy.builtin.python\”]}،{\”settings\”:{\”fontStyle” \”: “مورب\”}، \”محدوده\”:”تأکید\”}،{\”تنظیمات\”:{\ “fontStyle\”:\”bold\”}، \” scope\”:\”stron
name”:”آدرس ایمیل به دلایل حفظ حریم خصوصی حذف شد”,”globalState”:”{“storage”:{“workbench.panel.markers.hidden”:”[{\”id “:”workbench.panel.markers.view\”,\”isHidden\”:false}]”,”workbench.panel.output.hidden”:”[{ \”id”:”workbench.panel.output\”,”isHidden\”:false}]”,”terminal.hidden”:” [{\”id\”:\”terminal\”,”isHidden\”:false}]””workbench.scm.views.state.hidden “:”[{\”id\”:”workbench.scm.\”,\” isHidden\ “:true}،{\”id \”:\”workbench.. scm\”,\”isHidden\”:false},{\”id\”:”workbench.scm.sync \”,”isHidden\”:false}]”,”workbench.view.search.state.hidden”:”[{\”id”:\”:\”workbench.view.search\”,”isHidden\”:false}]”,”workbench.explorer.views.state.hidden”:”[{\” id\”:”طرح کلی\”,”isHidden\”:false},{\”id\”:”زمان خط\”, \”isHidden\”:false},{\”id\”:\” workbench.explorer.openEditorsView\”,\”isHidden\” :true} ,{\\”id\”:\”workbench.explorer.emptyView\”,”isHidden\”:false}]”,”workbench.activity.pinnedViewlets2 “:”[{\”id\”:”workbench.view.explorer\”,\”pinned\”:true,\”visible\” “:true,\”order\”:0},{\”id\”:”workbench.view.search\”,”پین شده\” “:true,”visible\”:true,\”order”:1},{\”id\”:”workbench.view.scm \”,”پین شده\”:true,\” visible\”:true,\”order\”:2},{\”id\” “:”workbench.view.debug\ “,\”پین شده\”:true,\”visible\”:true,\”order\”: 3},{\\”id\”:”workbench.view.extensions\”,”pinned\”:true,\”visible\”: true، \”order\”:4},{\”id”:”workbench.view.remote\”,\”pinned\”: true، \”visible\”:true, \”order”:4},{\”id\”:”workbench.view.extension.test \”,\”پین شده”:true,\”visible\”:false,\”order\”:6},{\\ “id\” “:”workbench.view.extension.references-view\”,”pinned”:true,\” visible\”:false,\”order” \”:7}،{\”id\”:”workbench.. panel.chatSidebar\”,”pinned\”:true,\”visible” \”:false,\”order\”:100},{\”id”:”userDataProfiles\”,”پین شده”:true},{\”visible\”:true},{\”id\”:” workbench.view.editSessions\”,”پین شده\”:true, \”visible\”:false},{\”id\”:” workbench.view.sync\”,”pinned\ “:true,\”visible\”:false}]”,”اخیرا باز شده”:”{\”ورودی ها\”:[{“فضای کاری\”:{\\ “id\”:\”-2ad0bbb\”,”configPath\ “:\”tmp:/default.code-workspace\”}}]}”,”workbench.view.debug.state.hidden”:”[{\”id \”:”workbench.debug.welcome\”,”isHidden\”:false},{\”id\”:\”workbench.debug. variablesView\”,”isHidden\”:false},{\”id\”:”workbench.debug.watchExpressionsView\”,”isHidden” \”:false},{\ “id\”:”workbench.. debug.callStackView\”,”isHidden\”:false},{\” id\”:\\” میز کار. debug.loadedScriptsView\”,”isHidden\”:false}،{\”id\”:\”میز کار. debug.breakPointsView\”,”isHidden\”:false}]”,”workbench.telemetryOptOutShown”:”true”,”workbench.statusbar.hidden”:” [\”status.workspaceTrust.-2ad0bbb\”]”,”workbench.view.remote.state.hidden”:”[{\”id\”:\ “remoteHub.views.workspaceRepositories\”,” isHidden\”:false},{\”id\”:”remoteTargets\”,\”isHidden \”:false}]”” workbench.panel.pinnedPanels”:”[{\”id\”:\”workbench.panel.markers\”, \”name\”:\”مشکلات\”,”پین شده\”:true،\”سفارش\”:0، \”قابل مشاهده\ “:true}،{\”id\”:”workbench.panel.output\”,”name\”:”خروجی\”:true,\”سفارش”:true,”سفارش”:1, \”visible\”:true},{\”id\”: \”workbench.panel.repl\”,\\”name\”:”Debug Console\”,”pinned\”:true,\” order\”:2,”visible\”:false},{\”id\”:”workbench.panel.testResults\”,” name\”:\”نتایج تست”,”پین شده\”:true,\” ترتیب\”:3, “visible\” :false},{\”id\”:”terminal\”,”name\”:”Terminal\”,”پین شد \”:true،\”order”:3، \”visible\”:true}،{\”id\”:\” refactorPreview\ “”name\”:”Refactor Preview\”,”pinned\”:true,\”visible\ “:false}] “,”workbench.welcomePage.walkthroughMtadata”:”[[\”ms-vscode.remote-repositories#remoteRepositoriesWalkthrough\”,{“firstSeen\”:1695519464371,\”stepIDs\”:[ \”editCommitRepo\”,”createGitHubPullRequest\”,”continueOn\”,”openRepo\”,”RemoteIndicator\”] ,”manaullyOpened\”:false}]]”,”themeUpdatedNotificationShown “:”true”,”colorThemeData”:”{“id”: \”vs-dark vscode-theme-defaults-themes-dark_ modern-json\”,\\”label”:”Dark Modern\”,\”settingsId\” “:\”پیش فرض Dark Modern\”,”themeTokenColors\”:[{\\”settings”:{\”پیش زمینه\”:\”#D4D4D4\”}، \”scope\”:[\”meta.embedded\”,\”source.groovy.embedded\”, “string meta.image.inline.markdown\”,”variable.legacy.builtin.python\”]}،{\”settings\”:{\”fontStyle” \”: “مورب\”}، \”محدوده\”:”تأکید\”}،{\”تنظیمات\”:{\ “fontStyle\”:\”bold\”}، \” scope\”:\”stron Read More
How and where to download the new Windows 11 24H2 ISO
I installed the Windows 11 ISO from the Insider channel about a month ago in the preview version. I know a new preview version has been released, but the link where I downloaded the previous one doesn’t show it. Where can I download the new Windows 11 24H2 preview ISO? I am part of the Insider program.
I installed the Windows 11 ISO from the Insider channel about a month ago in the preview version. I know a new preview version has been released, but the link where I downloaded the previous one doesn’t show it. Where can I download the new Windows 11 24H2 preview ISO? I am part of the Insider program. Read More
