Month: September 2024
Announcing API Management and API Center Community Live Stream on Thursday, September 26
We’re thrilled to announce a community stand-up – a live-stream event for users of Azure API Management and API Center, hosted on YouTube. Join us for an engaging session where we’ll delve into the latest industry trends, product updates, and best practices.
Event Details
Date: Thursday, 26 September 2024
Time: 8 AM PST / 11 AM EST
Format: Live stream on YouTube
What to Expect
Insights into the API industry: Our product team will share their perspectives on the criticality of API security and securing APIs with an in-depth defense using Microsoft Defender for APIs.
Azure API Management and API Center updates: Discover the latest features in our services, including workspaces, tiers v2, and more. Learn how these advancements can benefit your organization and enhance your API management practices.
Interactive Q&A session: Do you have a burning question about our products or are you looking to provide feedback? This is your chance! Join our live Q&A session to get answers directly from our team.
Networking opportunities: Connect with fellow API management practitioners in the chat, exchange ideas, and learn from each other’s experiences.
How to Join
Simply tune into our live stream in the Microsoft Azure Developers channel on YouTube at the scheduled date and time. You can select the “Notify me” button to receive a reminder before the event starts.
Don’t miss out on this exciting opportunity to engage with our product team and fellow API Management and API Center users. Mark your calendars and we’ll see you there!
Microsoft Tech Community – Latest Blogs –Read More
Learn how Copilot agents enhance collaboration within your team on Microsoft Teams
Microsoft brings you the goodness of Copilot across apps that you use with Teams. Several of the apps available to you are meant to enhance your productivity. Some of these are now Copilot enabled. What does that mean? They can be used with Microsoft 365 Copilot chat. You can easily invoke these apps on the Copilot chat, use it seamlessly across M365 products and enhance your productivity. This integration of Copilot with some of these apps is going to make searching, querying, and getting prompt support on next steps super intuitive. These will be available to all our users with Copilot license, starting from mid-September. More details are shared below in the form of examples in the subsequent sections.
Benefits of using Copilot agents
Using Copilot agents can significantly enhance your overall Teams experience. They help automate routine tasks, improve efficiency, and foster a more collaborative environment. Best practices include regular updates, leveraging analytics for insights, and encouraging user feedback to refine functionalities. To further enhance your Teams experience, we’ve curated a selection of innovative Copilot agents that address various business needs. These agents re designed to streamline processes, foster collaboration, and provide valuable insights, helping your organization run more smoothly and efficiently. Below, we introduce four transformative Copilot agents that can elevate your team’s productivity and engagement.
Identifying Copilot agents in Teams Store
To maximize the capabilities of Teams, it is essential to incorporate the right Copilot agents tailored to your business needs. Teams Store is the gateway to accessing these powerful tools. Here’s how you can identify and select the most beneficial Copilot agents:
Teams Store navigation:
Open your Teams application and navigate to the App Store by clicking on the “Apps” icon located on the left sidebar. This will take you to the main interface where you can browse through a wide range of applications, including the Copilot agents. Every Copilot agent contains a Copilot logo, making it easy to spot them among other apps in the app store. This logo serves as a visual indicator that the agent is powered by Copilot’s advanced capabilities.
Copilot agents category:
From the app store landing page, you can go directly to the Copilot agents page from the left tray. This dedicated page provides a curated list of all available Copilot agents. Here, you can explore detailed descriptions, and installation instructions to find the right tools for your organization.
Installation and permissions
Once you have identified a suitable Copilot agent, select ‘Add’ on its description page to start the installation. In case the app is unavailable to you, it might show ‘Request’. Trigger the flow and request your admin to enable the app. Your admin can review the permissions requested by the agent, as this will outline the data it will access and the functionalities it will integrate within your Teams environment.
Enabling and using Copilot agents
1. Enable Copilot agents via Plugins [refer image below]
After you have installed, some of the Copilot agent might not be auto-enabled for usage. You may have to go to the Microsoft 365 Copilot chat and enable them through a toggle. You can find this on the bottom right of the Copilot chat. The chat is present on the top of all your chats page on Teams. Once you open the plugin page on this chat from the bottom right as show in the image below – you will see a curated list of plugins. To enable or disable an agent, click on the toggle button next to the respective plugin. You can acquire more plugins through the side panel.
2. From the Right menu on Copilot chat
Not all apps can be enabled through command invocation and Copilot agents chat. You can find these distinct types of agents in the right menu on the Copilot chat. You can access the right menu on the Copilot chat to find available agents directly from the menu. This method offers a centralized location to manage all your Copilot agents, allowing for streamlined configuration and oversight.
3. Invoking by command
After installing and enabling the , you can use it with a command. Users who like command-line interactions can activate Copilot agents by typing ‘@’ and the agent name on the Copilot chat. This approach is particularly helpful for experienced users who know the specific tools they require.
4. From the agent’s chat
Open the chat area within Teams and navigate to the installed Copilot agent tab. Simply click on the desired agent to enable it. This method provides a quick and efficient way to activate necessary tools without leaving the chat interface, ensuring seamless integration into your daily workflow. Refer the image below to know about this.
5. From the command-line on the
Some Copilot agents can be invoked from the command-line on the Copilot chat. After accessing the Copilot chat, type ‘@’ followed by the agent name in the input field. Once the agent is activated, you can then type in specific prompts to trigger the desired actions.
Four Copliot agents and practical case studies
To further illustrate the ability and versatility of Copilot agents, let’s delve into four prominent apps: Microsoft Meetup, Proximity Matrix, Viva Goals, and Mural. Each of these agents offers unique functionalities that can be enhanced through targeted prompts. Below, we examine individual case studies demonstrating how these prompts can be effectively utilized.
Microsoft Meetup
Overview: Microsoft Meetup is designed to simplify the process of organizing and managing meetings, ensuring seamless coordination among team members.
Case Study: Knowing guests for the today
Jane, a project manager, uses Microsoft Meetup to keep track of her guests for the day. She has previously invited and scheduled several meetings with different stakeholders using the agent. To see who all the guests for the day are, she types ‘@Microsoft Meetup’ into the Copilot chat, which activates the agent and shows the view prompts option. She clicks on ‘View prompts’ to see the sample prompts. She then clicks on ‘List my guests for the day,’ which triggers the agent to display a list of all the guests she has invited, along with their names, roles, and meeting times.
Matrix
Overview: Priority Matrix is a smart tool for managing high-impact work, improving team productivity and focus. Track personal tasks, balance workloads, and align team goals easily.
Case Study: Managing personal and team tasks
John, a team leader, seeks better management of personal and team tasks. On the chat page of Priority Matrix in Teams, he activates the agent, views the prompts, and clicks ‘Open PM’ to see the integrated projects in his workflow. He can use the 1-on-1 view to access Outlook emails, calendar events, OneDrive files, and Planner tasks all together.
Viva Goals
Overview: Viva Goals is a powerful tool for setting, tracking, and achieving organizational goals, aligning team efforts with strategic objectives.
Case Study: Seeing snapshot of goals
Sarah, who leads the marketing team, used Viva Goals to set ambitious quarterly objectives. She wanted to track the progress and alignment of her goals with the company’s vision. She goes to the chat page of the Viva Goals agent and selects the option ‘Show me snapshot of my goals.’ The agent shows a dashboard with the status, completion rate, and impact of her goals, and feedback from her team members.
Creately
Overview: Creately Teams is a collaborative diagramming tool that allows teams to create and share diagrams, flowcharts, and mind maps with ease.
Case Study: Checking project management templates
David, a product manager, needs to set up a project timeline using the available templates for a new feature launch. He selects ‘Show Project Management Templates’ from the given options. The agent provides numerous templates, shapes, and icons, allowing him to create a concise and professional timeline. Additionally, he can invite his team members to collaborate and give feedback on the diagram, ensuring everyone stays aligned.
These case studies highlight how Copilot agents can be harnessed to streamline tasks and enhance productivity through targeted prompts.
Microsoft Tech Community – Latest Blogs –Read More
.NET on Azure Functions – September 2024 roadmap update
Our last roadmap update was in March 2024, in which we outlined the plans for the in-process model for .NET 8. That has since been released, and in this post, we’ll cover what you can expect throughout the rest of 2024.
.NET 8 option for the in-process model
Since our last post, we have released support for .NET 8 on the in-process model! Apps already using .NET 6 on the in-process model can move to .NET 8 by following the steps in the updating to target .NET 8 on the in-process model guidance.
Please keep in mind that support ends for the in-process model on November 10, 2026, and you’ll want to begin planning your migration to the isolated worker model in advance of that date.
.NET 9 (Preview)
The isolated worker model now supports .NET 9 as a Preview on Linux, starting with .NET 9 Preview 7. Windows support is forthcoming. Please see Preview .NET versions for up-to-date information about OS and version support. As with all .NET major versions, we will aim to have general availability (GA) support aligned with the .NET GA release.
As part of targeting .NET 9, your project will need to use new V2 versions of the core worker dependencies, discussed in the next section.
V2 packages for the isolated worker model
We’re introducing a set of V2 packages that adjusts the framework targets and the major versions of transitive package dependencies. For example, the 2.0.0-preview1 Worker package now targets .NET 8, .NET 9, and .NET Standard 2.0.
These changes bring in new .NET APIs, such as those needed to support integration with .NET Aspire. Like many in the community, we’re very excited about .NET Aspire, and we’re working toward a preview of support for Azure Functions projects in Aspire orchestrations.
We plan to move the 2.x versions to GA alongside the .NET 9 release. There will be a few iterations of these packages while the V2 versions remain in preview. These will add new features, and there will be a few minor breaking changes for bug fixes. However, the primary intent of the V2 packages is to address dependencies and .NET API support, so these other changes will be limited in scope.
Reminders about version support
Per the .NET Official Support Policy, .NET 6 will reach end of support on November 12, 2024. You should update any applications targeting those versions to .NET 8 (or .NET 9, when generally available) prior to the end of support.
If you choose to exercise in-process model option for .NET 8 for any of your applications, it’s still a great idea to begin planning your migration to the isolated worker model in advance of support ending for the in-process model on November 10, 2026.
Since the last roadmap update, support for .NET 7 has ended. If you have any resources still targeting that version, you should update them as soon as you can.
Closing thoughts
The updates covered in this post will take us through the end of 2024. We have additional enhancements planned for the isolated worker model, and we’ll look forward to sharing those in our next roadmap update!
If you encounter any issues with the previews or with any migrations, please engage the team on GitHub. As always, we thank the community for sharing your experiences and helping us make .NET on Azure Functions ever better.
– The Azure Functions team
Microsoft Tech Community – Latest Blogs –Read More
Generating links to maps using Copilot in Excel
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.
I have a table that I downloaded showing meteorite landings, including latitude and longitude.
I would like to make it easy to see where the locations are on a map so I ask Copilot:
Create a column with a hyperlink to bing maps with the latitude and longitude
Looking at B2:L500, here’s 1 formula column to review and insert in Column M:
Creates a clickable link to Bing Maps for each meteorite landing site by combining the latitude and longitude coordinates.
=HYPERLINK(“https://www.bing.com/maps?q=“&[@latitude]&”,”&[@longitude],”Bing Maps”)
I click on the button to insert the formula column and my table is updated to include a column with hyperlinks for each of the locations.
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.
I have a table that I downloaded showing meteorite landings, including latitude and longitude.
Table of Meteorite Landings including columns, Name, Meteorite ID, Recclass, Mass, Fall, Year, Latitude, Longitude.
I would like to make it easy to see where the locations are on a map so I ask Copilot:
Create a column with a hyperlink to bing maps with the latitude and longitude
Copilot in Excel Pane with the above prompt
Looking at B2:L500, here’s 1 formula column to review and insert in Column M:
Creates a clickable link to Bing Maps for each meteorite landing site by combining the latitude and longitude coordinates.
=HYPERLINK(“https://www.bing.com/maps?q=”&[@latitude]&”,”&[@longitude],”Bing Maps”)
I click on the button to insert the formula column and my table is updated to include a column with hyperlinks for each of the locations.
Table of Meteorite Landings including columns, Name, Meteorite ID, Recclass, Mass, Fall, Year, Latitude, Longitude, and new inserted formula column with Bing Maps links.
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
Line cut at preview in Excel
Hy everybody!
I hope you’re fine !
I have a little problem with the preview of my Excel Sheet…
When I go to the overview tab, the last lign of my cell is cut in two horizontally…
In my Excel sheet :
In the preview tab :
I know that I have to stretch the height of the cell to fix it, but it’s an invoice template and I can’t stretch the height of the cells in all my invoices…
Thanks for your help !
Have a nice day !
Hy everybody! I hope you’re fine ! I have a little problem with the preview of my Excel Sheet… When I go to the overview tab, the last lign of my cell is cut in two horizontally… In my Excel sheet : In the preview tab :I know that I have to stretch the height of the cell to fix it, but it’s an invoice template and I can’t stretch the height of the cells in all my invoices… Thanks for your help ! Have a nice day ! Read More
My shared Bookings page no longer shows services, staff, or calendar entries
In the last day or two, my shared Bookings page, if accessed from my Bookings account page, does not display any of the customizations, staff, services, or calendar appointments.
If I login to Bookings, the shared page still appears, but it’s reset to default somehow.
BUT, if I click on the customer-facing link, it still brings up the correct page with the services listed, the correct calendar, and the ability to book.
No idea what’s going on, but I rely on that for scheduling appointments, so I need to figure it out quickly. Help?
In the last day or two, my shared Bookings page, if accessed from my Bookings account page, does not display any of the customizations, staff, services, or calendar appointments. If I login to Bookings, the shared page still appears, but it’s reset to default somehow. BUT, if I click on the customer-facing link, it still brings up the correct page with the services listed, the correct calendar, and the ability to book. No idea what’s going on, but I rely on that for scheduling appointments, so I need to figure it out quickly. Help? Read More
Cloud only Entra ID Domain Services and Seamless SSO from Entra ID Joined machines
Hello
I am currently implementing Entra ID Domain Services with one customer (he has no on-premises active directory). We now face the issue that an Entra ID joined client is not able to access ressources on machines that are joined to Entra ID Domain Services without entering his username and password.
The authentication fails with incorrect username and password (event id 200) message and the Security-Kerberos eventlog reports that it was not able to contact a domain controller for the AzureAd Domain (so he is not using the Domain name of the target domain).
However has someone already tried this and is there something I am overlooking or is that something that simply can not work.
Thank you very much in advance for any ideas.
Hello I am currently implementing Entra ID Domain Services with one customer (he has no on-premises active directory). We now face the issue that an Entra ID joined client is not able to access ressources on machines that are joined to Entra ID Domain Services without entering his username and password. The authentication fails with incorrect username and password (event id 200) message and the Security-Kerberos eventlog reports that it was not able to contact a domain controller for the AzureAd Domain (so he is not using the Domain name of the target domain). However has someone already tried this and is there something I am overlooking or is that something that simply can not work. Thank you very much in advance for any ideas. Read More
formulas and functions
hello y’all, I would like to know how to do this calculation(in excel for Mac) -> 80+(60*1.05)
hello y’all, I would like to know how to do this calculation(in excel for Mac) -> 80+(60*1.05) Read More
Aug 2024 Recap: Azure PostgreSQL Flexible Server
Hello Azure Community,
This August, our Azure Database for PostgreSQL Flexible Server received some great updates that make it even better and simpler to use. We’ve introduced new security features, enhanced monitoring capabilities, and made improvements to how you can set up and manage your databases. Here’s a quick look at what’s new this month:
Feature Highlights
Reserved pricing availability for Intel & AMD V5 SKUs
Support latest Postgres minor versions
Support for postgres_protobuf Extension
Support for postgresql_anonymizer (anon) Extension
Ansible module update
DNS Record Updates with Private Endpoint Changes
Support for TimescaleDB extension in migration service
Support for migration into Flexible server’s Burstable SKU
LangChain Docs Enhancements
Reserved Pricing Availability for Intel & AMD V5 SKUs
We’re pleased to announce that reservations for V5 SKUs (Intel & AMD) are now available on Azure Database for PostgreSQL Flexible Server. By reserving compute resources in advance, you can enjoy significant savings over pay-as-you-go pricing options. Commit to either a one-year or three-year plan to receive up to 65% off on compute costs. Check the Reservation pane on the Azure portal to see how much you could save based on different pricing tiers and regions. Reserved instances help you predict and manage your budget more effectively.
For more details, please refer to the Reserved Pricing documentation for Azure Database for PostgreSQL Flexible Server.
Support latest Postgres minor versions
Azure Database for PostgreSQL Flexible Server now supports newer minor versions: 16.4, 15.8, 14.13, 13.16, and 12.20. These updates, performed automatically during scheduled maintenance, ensure that your database runs on the most secure and efficient version available. This round of updates includes critical security patches and over 55 bug fixes.
For additional information, check out the PostgreSQL community announcement about the new minor versions.
Support for postgres_protobuf extension
The latest version (0.3.1) of the `postgres_protobuf` extension is now available. This extension is designed to convert protobuf columns to and from JSON, enhancing the flexibility of data usage within your databases. It’s an open-source tool that broadens your database’s capabilities.
Learn more about this and other extensions on the Extensions documentation page.
Support for postgresql_anonymizer (anon) extension
The `postgresql_anonymizer` extension, also known as the anon extension, is now available in version 1.3.2. This tool helps mask or anonymize sensitive data directly within your database, providing an extra layer of data protection.
To explore this extension further, visit the PostgreSQL Anonymizer documentation.
Ansible Module Update
The Ansible Galaxy azure_rm_postgresqlflexiblerserver module is now updated to support deploying PostgreSQL major versions up to 16. This expansion from previously supported versions up to 13 allows more flexibility in managing your database environments using automation tools.
For more information, please visit the Ansible azure.azcollection module documentation.
DNS Record Updates with Private Endpoint Changes
Whenever a private endpoint configuration is updated on Azure Database for PostgreSQL Flexible Server, the DNS records are now automatically adjusted to reflect these changes. This ensures that your connectivity settings are always synchronized with your network configurations.
For detailed information, refer to the Flexible Server with Private Link documentation.
Support for TimescaleDB extension in migration service
The PostgreSQL migration service now supports the migration of databases using the TimescaleDB extension without needing to convert time series tables to regular tables. This update facilitates the direct migration of specialized time series data.
For a detailed guide on this feature, please check out the migration service tutorials.
Support for migration into Flexible Server’s Burstable SKU
You can now directly migrate your workloads into the Flexible Server’s Burstable SKU, currently in preview in West Europe and soon to be available globally. This feature is ideal for workloads that require flexible performance scaling.
Learn more about this capability in the Burstable SKU documentation.
LangChain Docs Enhancement
Building GenAI apps with Azure Database for Postgres and LangChain has never been easier! We’ve updated the LangChain docs to include how users can use Azure Database for PostgreSQL as a vector store for their GenAI application.
Learn more about this here: Microsoft | LangChain Also take a look at a previous blog about LangChain support for a full end-to-end example.
Conclusion
In closing, the updates this month make Azure Database for PostgreSQL Flexible Server better and more user-friendly. Try out these new features to improve how you manage and secure your databases. We value your feedback and are always looking to make our services better. Keep an eye out for more updates!
Microsoft Tech Community – Latest Blogs –Read More
SQL Server on Azure VM: Automated Patching Retirement and Replacement with Azure Update Manager
The automated patching feature for SQL Server on Azure VM will be retired on September 17th, 2027.
While Automated Patching is being retired, we’re excited to replace it with Azure Update Manager. Azure Update Manager is an enterprise class powerful tool that provides:
Centralize Update Management: Azure Update Manager provides a unified dashboard where you can view and manage updates across your entire environment, including virtual machines, on-premises servers, and even hybrid scenarios.
Customize Schedules: With Azure Update Manager, you can create custom update schedules based on your organization’s needs. Whether you prefer weekly, monthly, or specific date-based updates, Azure Update Manager has you covered.
Patch Compliance Reports: Azure Update Manager generates detailed reports on patch compliance, helping you stay informed about the status of updates across your infrastructure.
Next Steps:
Prepare for the transition: We recommend familiarizing yourself with Azure Update Manager by exploring our documentation
Use Azure Update Manager: For new deployments, instead of automated patching, start using Azure Update Manager
Start your migration: If you’re currently using Automated Patching, start your migration to Azure Update Manager as soon as possible to continue receiving future updates to the patching feature for your SQL Server on Azure VM. You must migrate before September 17th, 2027, to avoid service disruptions.
Help and support
Please visit the product documentation for the latest resources. If you have questions, get answers from community experts in Microsoft Q&A. If you have a support plan and you encounter any problem during your migration, please create a support request
For Issue type, select Technical.
For Subscription, select your subscription.
For Service, select My services, then select “SQL Server in VM – Windows”.
Select the Azure resource that you are creating a support request for.
For Summary, type a description of your issue.
For Problem type, select “SQL Licensing, Installation and Patching”.
For Problem subtype, select “Failed to install SQL, CU, Service Pack or Patch”.
Learn more about service retirements that may impact your resources in the Azure Retirement Workbook. Please note that retirements may not be visible in the workbook for up to two weeks after being announced.
Microsoft Tech Community – Latest Blogs –Read More
Not able to see where the index is going past 5
load(‘Motor_Data.mat’);
fprintf(‘Available motors:n’);
for i = 1:length(Names)
fprintf(‘%d: %sn’, i, Names(i));
end
motor_index = input(‘Select a motor by entering its number: ‘);
mass = input(‘Enter the mass to be lifted (in kg): ‘);
height = input(‘Enter the height to lift the mass (in meters): ‘);
%Says this is where it errors
motor_name = Names(motor_index);
power = Specs(1, motor_index);
efficiency = Specs(2, motor_index);
% Calculate output power
efficiency_decimal = efficiency / 100;
output_power = efficiency_decimal * power;
g = 9.81;
energy_required = mass * g * height;
time = energy_required / output_power;
fprintf(‘Motor: %sn’, motor_name);
fprintf(‘Load lifted: %.2f kgn’, mass);
fprintf(‘Height lifted: %.2f metersn’, height);
fprintf(‘Time to lift the load: %.2f secondsn’, time);
%Task 2
mass = input(‘Enter the mass to be lifted by all motors (in kg): ‘);
height = input(‘Enter the height to lift the mass by all motors (in meters): ‘);
% Initialize results matrix
num_motors = length(Names);
results = zeros(5, num_motors);
% Calculate time for each motor
g = 9.81; % Gravity constant
for i = 1:num_motors
power = Specs(1, i); % Power in watts
efficiency = Specs(2, i); % Efficiency in percentage
efficiency_decimal = efficiency / 100;
output_power = efficiency_decimal * power;
% Energy required to lift mass
energy_required = mass * g * height;
% Time to lift
time = energy_required / output_power;
% Store results: power, efficiency, mass, height, time
results(:, i) = [power; efficiency; mass; height; time];
end
% Export results to CSV file
csvwrite(‘Task2_Results.csv’, results);
% Display the matrix to verify
disp(‘Results matrix:’);
disp(results);
%Task 3
output_powers = Specs(1, 🙂 .* (Specs(2, 🙂 / 100); % Output power for each motor
times = results(5, :); % Time from the results matrix
scatter(output_powers, times, ‘filled’);
xlabel(‘Output Power (W)’);
ylabel(‘Time to Lift Load (s)’);
title(‘Motor Output Power vs. Time to Lift Load’);
grid on;load(‘Motor_Data.mat’);
fprintf(‘Available motors:n’);
for i = 1:length(Names)
fprintf(‘%d: %sn’, i, Names(i));
end
motor_index = input(‘Select a motor by entering its number: ‘);
mass = input(‘Enter the mass to be lifted (in kg): ‘);
height = input(‘Enter the height to lift the mass (in meters): ‘);
%Says this is where it errors
motor_name = Names(motor_index);
power = Specs(1, motor_index);
efficiency = Specs(2, motor_index);
% Calculate output power
efficiency_decimal = efficiency / 100;
output_power = efficiency_decimal * power;
g = 9.81;
energy_required = mass * g * height;
time = energy_required / output_power;
fprintf(‘Motor: %sn’, motor_name);
fprintf(‘Load lifted: %.2f kgn’, mass);
fprintf(‘Height lifted: %.2f metersn’, height);
fprintf(‘Time to lift the load: %.2f secondsn’, time);
%Task 2
mass = input(‘Enter the mass to be lifted by all motors (in kg): ‘);
height = input(‘Enter the height to lift the mass by all motors (in meters): ‘);
% Initialize results matrix
num_motors = length(Names);
results = zeros(5, num_motors);
% Calculate time for each motor
g = 9.81; % Gravity constant
for i = 1:num_motors
power = Specs(1, i); % Power in watts
efficiency = Specs(2, i); % Efficiency in percentage
efficiency_decimal = efficiency / 100;
output_power = efficiency_decimal * power;
% Energy required to lift mass
energy_required = mass * g * height;
% Time to lift
time = energy_required / output_power;
% Store results: power, efficiency, mass, height, time
results(:, i) = [power; efficiency; mass; height; time];
end
% Export results to CSV file
csvwrite(‘Task2_Results.csv’, results);
% Display the matrix to verify
disp(‘Results matrix:’);
disp(results);
%Task 3
output_powers = Specs(1, 🙂 .* (Specs(2, 🙂 / 100); % Output power for each motor
times = results(5, :); % Time from the results matrix
scatter(output_powers, times, ‘filled’);
xlabel(‘Output Power (W)’);
ylabel(‘Time to Lift Load (s)’);
title(‘Motor Output Power vs. Time to Lift Load’);
grid on; load(‘Motor_Data.mat’);
fprintf(‘Available motors:n’);
for i = 1:length(Names)
fprintf(‘%d: %sn’, i, Names(i));
end
motor_index = input(‘Select a motor by entering its number: ‘);
mass = input(‘Enter the mass to be lifted (in kg): ‘);
height = input(‘Enter the height to lift the mass (in meters): ‘);
%Says this is where it errors
motor_name = Names(motor_index);
power = Specs(1, motor_index);
efficiency = Specs(2, motor_index);
% Calculate output power
efficiency_decimal = efficiency / 100;
output_power = efficiency_decimal * power;
g = 9.81;
energy_required = mass * g * height;
time = energy_required / output_power;
fprintf(‘Motor: %sn’, motor_name);
fprintf(‘Load lifted: %.2f kgn’, mass);
fprintf(‘Height lifted: %.2f metersn’, height);
fprintf(‘Time to lift the load: %.2f secondsn’, time);
%Task 2
mass = input(‘Enter the mass to be lifted by all motors (in kg): ‘);
height = input(‘Enter the height to lift the mass by all motors (in meters): ‘);
% Initialize results matrix
num_motors = length(Names);
results = zeros(5, num_motors);
% Calculate time for each motor
g = 9.81; % Gravity constant
for i = 1:num_motors
power = Specs(1, i); % Power in watts
efficiency = Specs(2, i); % Efficiency in percentage
efficiency_decimal = efficiency / 100;
output_power = efficiency_decimal * power;
% Energy required to lift mass
energy_required = mass * g * height;
% Time to lift
time = energy_required / output_power;
% Store results: power, efficiency, mass, height, time
results(:, i) = [power; efficiency; mass; height; time];
end
% Export results to CSV file
csvwrite(‘Task2_Results.csv’, results);
% Display the matrix to verify
disp(‘Results matrix:’);
disp(results);
%Task 3
output_powers = Specs(1, 🙂 .* (Specs(2, 🙂 / 100); % Output power for each motor
times = results(5, :); % Time from the results matrix
scatter(output_powers, times, ‘filled’);
xlabel(‘Output Power (W)’);
ylabel(‘Time to Lift Load (s)’);
title(‘Motor Output Power vs. Time to Lift Load’);
grid on; matlab MATLAB Answers — New Questions
Limit the number of PST file histories
Hello,
On my collaborators’ personal OneDrive folders, I archive emails in an ‘Outlook archive’ folder in a PST format file.
For some users, this file is over 100GB in size.
Automatically creating a history for this type of file means that the OneDrive limit is quickly reached.
How can I avoid creating a history for certain types of PST file?
Or do you have another solution for me?
Thank you for your help,
G
Hello,On my collaborators’ personal OneDrive folders, I archive emails in an ‘Outlook archive’ folder in a PST format file.For some users, this file is over 100GB in size.Automatically creating a history for this type of file means that the OneDrive limit is quickly reached.How can I avoid creating a history for certain types of PST file?Or do you have another solution for me?Thank you for your help,G Read More
Microsoft Authenticator on iPhone – ability to backup to locations other than iCloud
Our company has policy settings in place which restricts the ability of our iPhone/iPad fleet to backup content to iCloud. Unfortunately this also prevents the backup of Microsoft Authenticator configurations. It would be great if Microsoft Authenticator was able to backup its config to an alternative cloud storage location such as OneDrive.
Our company has policy settings in place which restricts the ability of our iPhone/iPad fleet to backup content to iCloud. Unfortunately this also prevents the backup of Microsoft Authenticator configurations. It would be great if Microsoft Authenticator was able to backup its config to an alternative cloud storage location such as OneDrive. Read More
Searching in SharePoint not returning results
We have been running into an issue where documents are not appearing in searches, even when the document definitely exists. The ‘Allow items from this document library to appear in search results?’ is set to Yes, and the search visibility setting is set to ‘Always index all Web Parts on this site’, however we’re still running into the issue where the search doesn’t work.
For example, searching for the keyword “evaluation” in this document library yields no results.
We’ve tried using more appropriate syntax, but still no luck. Does anyone know what settings might be affecting these results?
Thanks!
We have been running into an issue where documents are not appearing in searches, even when the document definitely exists. The ‘Allow items from this document library to appear in search results?’ is set to Yes, and the search visibility setting is set to ‘Always index all Web Parts on this site’, however we’re still running into the issue where the search doesn’t work. For example, searching for the keyword “evaluation” in this document library yields no results. We’ve tried using more appropriate syntax, but still no luck. Does anyone know what settings might be affecting these results? Thanks! Read More
Sharepoint File inserted in Outlook
Hello,
I use Outlook application.
I want to insert files from Sharepoint sites.
Drag & Drop doesn’t work. The reverse Outlook to Sharepoint works.
How can I get Sharepoint to Outlook Drag & Drop to work?
Or how can I access the most frequently used files?
Thanks for your help,
Gaetan
NB. I can’t update the SITES or Sharepoint list on these Outlook menus.
Insert file” menu
Hello,I use Outlook application.I want to insert files from Sharepoint sites.Drag & Drop doesn’t work. The reverse Outlook to Sharepoint works.How can I get Sharepoint to Outlook Drag & Drop to work?Or how can I access the most frequently used files? Thanks for your help,GaetanNB. I can’t update the SITES or Sharepoint list on these Outlook menus.Insert file” menu Read More
How to select the “type” of an OKR?
In the documentation for Viva Goals it says that you can choose the “Type” of an OKR, i.e. Organizational, Team or Individual.
There is even a screenshot showing this option in the UI here: https://learn.microsoft.com/en-gb/training/modules/viva-goals-create-track-close-okrs/how-to-enter-okrs
However, when I enter an OKR, I do not get this option:
I am a global admin and have just set Viva Goals up.
I have enabled the “default organisation” and do not have any teams.
Any ideas?
Thanks,
Frans
In the documentation for Viva Goals it says that you can choose the “Type” of an OKR, i.e. Organizational, Team or Individual.There is even a screenshot showing this option in the UI here: https://learn.microsoft.com/en-gb/training/modules/viva-goals-create-track-close-okrs/how-to-enter-okrs However, when I enter an OKR, I do not get this option:I am a global admin and have just set Viva Goals up.I have enabled the “default organisation” and do not have any teams. Any ideas? Thanks,Frans Read More
I am unable to update to the latest Windows Cumulative Update KB5043080
I have been trying to get this update for the past two weeks. Every time I attempt to update it gives me this error message:
I am part of the Windows Insider Program, and am currently and always have been in the “Release Preview”
channel.
I am unsure on how to proceed. I did manage to contact Microsoft Support and get someone to look at my situation on Live Chat, but once they realized I was in the program, the referred me to this forum.
I am unsure if this could be a consequence of not being able to download this update, but when I try to run certain games from Steam, they don’t launch. I have my Nvidia drivers all up to date so that couldn’t be the issue.
I have been trying to get this update for the past two weeks. Every time I attempt to update it gives me this error message:I am part of the Windows Insider Program, and am currently and always have been in the “Release Preview”channel.I am unsure on how to proceed. I did manage to contact Microsoft Support and get someone to look at my situation on Live Chat, but once they realized I was in the program, the referred me to this forum. I am unsure if this could be a consequence of not being able to download this update, but when I try to run certain games from Steam, they don’t launch. I have my Nvidia drivers all up to date so that couldn’t be the issue. Read More
SQL Server audit logs incorrect info on column object_name
Hi, during an audit check on database events, i have noticed that sometimes on DDL events, when temp tables are mentioned, sql server 2017 logs incorrect information on columns schema_name and object_name and the statement column proves this:
Moreover, on the two columns the info for the object on which the DDL was applied, is taken randomly, it may show the first table, or the second, making this difficult to prove the actions in case of audits:
Sadly, i haven’t found this reported anywhere..
Hi, during an audit check on database events, i have noticed that sometimes on DDL events, when temp tables are mentioned, sql server 2017 logs incorrect information on columns schema_name and object_name and the statement column proves this: Moreover, on the two columns the info for the object on which the DDL was applied, is taken randomly, it may show the first table, or the second, making this difficult to prove the actions in case of audits:Sadly, i haven’t found this reported anywhere.. Read More
Conditional Formatting Based on Date & Status
Hello!
I need some help getting my conditional formatting to function properly. I would like the cells in the “Due Date” column to highlight red if the date is less than today AND the “Status” column does not read “Done”. Problem is, I can’t even get the conditional formatting to work correctly on just the date portion of things, much less the status qualifier. I’ve tried both ‘=$D2<NOW()’ as well as ‘=$D2<TODAY()’ and the results are nonsensical. Thanks in advance for the help!
Hello! I need some help getting my conditional formatting to function properly. I would like the cells in the “Due Date” column to highlight red if the date is less than today AND the “Status” column does not read “Done”. Problem is, I can’t even get the conditional formatting to work correctly on just the date portion of things, much less the status qualifier. I’ve tried both ‘=$D2<NOW()’ as well as ‘=$D2<TODAY()’ and the results are nonsensical. Thanks in advance for the help! Read More
Sharepoint Open in Application
I’m using a sharepoint drive set with no replication possible using OneDrive (due to volume of data).
I can open individual Word or Excel files in local application : click right then “Open in apps”.
It’s necessary for us to have same functionnality for non Microsoft files, as PDF, or other).
Right now I cannot use the “open in apps” only open in browser.
Thanks for your time to fix this issue.
I’m using a sharepoint drive set with no replication possible using OneDrive (due to volume of data).I can open individual Word or Excel files in local application : click right then “Open in apps”.It’s necessary for us to have same functionnality for non Microsoft files, as PDF, or other).Right now I cannot use the “open in apps” only open in browser.Thanks for your time to fix this issue. Read More