Month: September 2024
Blocking personal email access in Outlook (Windows)
Hey all,
Hoping someone is able to assist with this one.
We’re trying to block users from adding their own personal, or any other email accounts to Outlook. I’ve gone through the web and it doesn’t seem like I can find a definitive answer anywhere, have also gone through Microsoft support who pointed me towards a Device Config Policy, but unfortunately this only allows you to set one allowed domain, which for a company with around 20 unfortunately doesn’t accommodate our needs.
Any help or advice on this matter is much appreciated.
Thanks,
Kiefer-joe
Hey all, Hoping someone is able to assist with this one. We’re trying to block users from adding their own personal, or any other email accounts to Outlook. I’ve gone through the web and it doesn’t seem like I can find a definitive answer anywhere, have also gone through Microsoft support who pointed me towards a Device Config Policy, but unfortunately this only allows you to set one allowed domain, which for a company with around 20 unfortunately doesn’t accommodate our needs. Any help or advice on this matter is much appreciated. Thanks,Kiefer-joe Read More
NPC Unexpectedly Logs In Autonomously
Greetings all,
Upon logging in, I typically expect my PC to boot to the login screen where I authenticate, and subsequently, the desktop is displayed.
Yet, occasionally and unexpectedly, the system automatically logs in without requiring my input.
This behavior confounds me entirely.
Would anyone be able to provide assistance as I prefer to log in manually?
Greetings all, Upon logging in, I typically expect my PC to boot to the login screen where I authenticate, and subsequently, the desktop is displayed. Yet, occasionally and unexpectedly, the system automatically logs in without requiring my input. This behavior confounds me entirely. Would anyone be able to provide assistance as I prefer to log in manually? Read More
OneDrive: Addressing the Elephant in the Room
Searching through tutorials for “OneDrive,” the abundance of information on the topic is endless. Yet, finding a comprehensive guide that truly addresses OneDrive as a persistent issue remains a challenge.
We aim to develop a definitive approach to either streamline OneDrive into a user-friendly tool that enhances the user experience or eliminate it entirely. While some individuals may tolerate or even appreciate OneDrive, the general sentiment within the Windows community appears to lean towards a strong aversion to this tool. Let’s avoid turning this discussion into a debate for or against OneDrive.
At this site, I manage various computers including Windows 10, Windows 11, and Linux (Mint). Five of the Windows machines have Office 365 installed. Removing OneDrive from these systems proved to be an arduous battle, requiring extensive effort and time. Although I thought I had successfully removed it, traces of OneDrive persist on a few computers, and there are indications that Microsoft might attempt to reinstall it through regular Windows Updates, a mandatory process for users. Dealing with OneDrive was so challenging that the exact steps taken to eradicate it during my hours-long interactions with Microsoft Tech Support and extensive research are now a distant memory.
Nevertheless, acknowledging the importance and utility of cloud storage in securely maintaining, sharing, and preserving digital content, I strive to empower users – including myself – to harness this technology effectively.
1) Deactivating OneDrive’s intrusive features is a priority. OneDrive currently exerts control over directories like Documents, Downloads, Desktop, Pictures, and Videos, dictating the fate of content within these spaces without explicit user consent. I advocate for a user-centric approach where individuals have the autonomy to structure their files and directories according to their preferences. Users should be empowered to choose which content is stored in the cloud and retain control over its location and disposition, both in the cloud and locally. Given that OneDrive typically manages directories where files are automatically directed, establishing a mechanism for content to bypass these spaces or move to user-designated locations promptly is crucial.
Our objective is to either a) relocate content claimed by OneDrive to user-controlled directories continuously or b) restrict OneDrive’s access to directories that it perceives as its domain.
2) Alternatively, simplifying the process of completely eliminating OneDrive from a system remains a viable option. Many users, myself included, initially perceived OneDrive as a tool to introduce the benefits of cloud storage in a user-friendly manner. However, for this concept to succeed, user control over the cloud is essential. If OneDrive cannot function as a platform where users retain full authority over their files, including placement, synchronization, modification, and deletion, then removing it entirely -along with the cloud services it offers – is a reasonable request. Let’s explore straightforward methods to permanently halt OneDrive’s activities or uninstall it from our Windows systems to avoid recurring installations without consent.
Searching through tutorials for “OneDrive,” the abundance of information on the topic is endless. Yet, finding a comprehensive guide that truly addresses OneDrive as a persistent issue remains a challenge. We aim to develop a definitive approach to either streamline OneDrive into a user-friendly tool that enhances the user experience or eliminate it entirely. While some individuals may tolerate or even appreciate OneDrive, the general sentiment within the Windows community appears to lean towards a strong aversion to this tool. Let’s avoid turning this discussion into a debate for or against OneDrive. At this site, I manage various computers including Windows 10, Windows 11, and Linux (Mint). Five of the Windows machines have Office 365 installed. Removing OneDrive from these systems proved to be an arduous battle, requiring extensive effort and time. Although I thought I had successfully removed it, traces of OneDrive persist on a few computers, and there are indications that Microsoft might attempt to reinstall it through regular Windows Updates, a mandatory process for users. Dealing with OneDrive was so challenging that the exact steps taken to eradicate it during my hours-long interactions with Microsoft Tech Support and extensive research are now a distant memory. Nevertheless, acknowledging the importance and utility of cloud storage in securely maintaining, sharing, and preserving digital content, I strive to empower users – including myself – to harness this technology effectively. 1) Deactivating OneDrive’s intrusive features is a priority. OneDrive currently exerts control over directories like Documents, Downloads, Desktop, Pictures, and Videos, dictating the fate of content within these spaces without explicit user consent. I advocate for a user-centric approach where individuals have the autonomy to structure their files and directories according to their preferences. Users should be empowered to choose which content is stored in the cloud and retain control over its location and disposition, both in the cloud and locally. Given that OneDrive typically manages directories where files are automatically directed, establishing a mechanism for content to bypass these spaces or move to user-designated locations promptly is crucial. Our objective is to either a) relocate content claimed by OneDrive to user-controlled directories continuously or b) restrict OneDrive’s access to directories that it perceives as its domain. 2) Alternatively, simplifying the process of completely eliminating OneDrive from a system remains a viable option. Many users, myself included, initially perceived OneDrive as a tool to introduce the benefits of cloud storage in a user-friendly manner. However, for this concept to succeed, user control over the cloud is essential. If OneDrive cannot function as a platform where users retain full authority over their files, including placement, synchronization, modification, and deletion, then removing it entirely -along with the cloud services it offers – is a reasonable request. Let’s explore straightforward methods to permanently halt OneDrive’s activities or uninstall it from our Windows systems to avoid recurring installations without consent. Read More
Stop automatic hyperlinks for email addresses in Excel
I want Excel to stop automatically creating hyperlinks for email addresses. What I have tried so far is to select Options > Proofing > Change how excel corrects and formats text as you type
Unfortunately, the “AutoCorrect Options…” button is grayed out. I am the admin, so it’s not a lack of account access. There must be something I can do to un-gray this option.
I want Excel to stop automatically creating hyperlinks for email addresses. What I have tried so far is to select Options > Proofing > Change how excel corrects and formats text as you typeUnfortunately, the “AutoCorrect Options…” button is grayed out. I am the admin, so it’s not a lack of account access. There must be something I can do to un-gray this option. Read More
Wi-Fi publish via work profile on personal devices
Hi, all
Is it possible to add options to add Wi-Fi profiles in Intune on personal Android devices as on work devices. At the moment, adding Wi-Fi to a personal device looks like this
Hi, allIs it possible to add options to add Wi-Fi profiles in Intune on personal Android devices as on work devices. At the moment, adding Wi-Fi to a personal device looks like this Read More
Discovered duplicate file, renamed it, but old name still lingers
I discovered that I had 2 files with the same name in a folder. They were both called Index. They are both HTML file types. Different dates, different sizes. I renamed one of them “HelloWorld”. When I look in File Explorer, HelloWorld is now listed. But when I startup my HTML editor, HTML-kit, when I go to File Open, it still lists 2 Index.html files. I suspect that HTML-Kit is the culprit, version 292 is 20 years old, but my first question, is how did I get 2 files with the same name in one folder. The prntscrn below shows File Explorer with the HelloWorld file, but HTML-Kit is still showing 2 index files. Any thoughts?
I discovered that I had 2 files with the same name in a folder. They were both called Index. They are both HTML file types. Different dates, different sizes. I renamed one of them “HelloWorld”. When I look in File Explorer, HelloWorld is now listed. But when I startup my HTML editor, HTML-kit, when I go to File Open, it still lists 2 Index.html files. I suspect that HTML-Kit is the culprit, version 292 is 20 years old, but my first question, is how did I get 2 files with the same name in one folder. The prntscrn below shows File Explorer with the HelloWorld file, but HTML-Kit is still showing 2 index files. Any thoughts? Read More
Transforming Public Sector with AI: South Korea’s Story
Generative AI is reshaping industries across the globe, from automating tasks to driving creative innovation. In the public sector, governments are beginning to realize the immense potential of AI to enhance public services and streamline administrative processes. But how do you get started? In South Korea, a group of passionate Microsoft MVPs and RDs are leading the charge, helping citizens and public officials adopt and integrate AI technologies. Here’s how they’re making it happen.
1. The $120 Million Deal: How AI is Shaping Korea’s Telecom Future
A significant milestone in the AI journey was reached with the efforts of Hoon Dong Kim, an MVP and RD who serves as the AI team lead at Korea Telecom (KT). Kim played a pivotal role in setting the stage for the creation of Sovereign AI, which is a $120 million deal between KT and Microsoft. This ambitious project aims to drive AI transformation on a national scale, positioning KT at the forefront of AI innovation in South Korea.
Hoon Dong Kim said, “Korea Telecom’s partnership with Microsoft demonstrates how large enterprises can harness AI to revolutionize entire industries. This deal isn’t just about technology—it’s about reshaping how businesses and governments operate through AI-driven transformation. As an AI MVP for the past nine years, I am honored to be part of such an important milestone, and I would like to express my gratitude to the MVP program and Microsoft for their tremendous support in helping this project move forward smoothly.”
2. From Startups to Government: How Copilot is Revolutionizing Citizen Services in Seoul
Recently, Microsoft Community Program Manager (CPM), Soyoung Lee, teamed up with JaeSeok Lee, InHee Lee, and Seok Heo, MVPs with expertise in Business Applications and Power Platform, to conduct a series of AI training sessions. These sessions focused on introducing Microsoft Copilot and ChatGPT to two distinct groups—entrepreneurs and local government officials in Seoul.
The first session, held at the Seoul AI Hub, targeted citizens interested in how AI could support entrepreneurship. Through a mix of hands-on experience with Power Apps Copilot and discussions on ChatGPT, attendees learned how to create apps, automate processes, and manage data through simple commands. The manager of Seoul AI Hub, Jina Lee expressed her satisfaction and said, “The citizen’s feedback was overwhelmingly positive, with many participants expressing excitement about using AI tools to support their startups.”
The second session shifted focus to members of the Seoul Metropolitan Council, where MVPs faced a different challenge. Most council members were unfamiliar with AI tools like ChatGPT and Copilot. However, after a demonstration of how Power Automate could streamline administrative tasks, along with a fun, interactive session using DALL-E for image generation, their interest soared. A real-time demonstration of how Copilot could manage council data and answer questions in real time proved to be a highlight.
JaeSeok Lee shared his learning and said, “The hands-on approach allowed participants to see the real-world benefits of AI in action, moving beyond theoretical discussions. Whether they were startup founders or public officials, attendees quickly recognized that automation via AI could save time and boost productivity.”
3. Hacking for Public Good: How AI is Streamlining Government Operations
(YoungWook Kim talks about AI at National Assembly of South Korea in front of Brad Smith, Microsoft Vice Chair and President and the member of the Assembly)
At the KDI School of Public Policy, YoungWook Kim, EunJung Park, and DoKyun Kim—all MVPs specializing in AI platforms—hosted a groundbreaking event titled ‘Hack for Public Good in Korea’. The workshop focused on showing public officials how AI, particularly Microsoft 365 Copilot, can drastically improve efficiency in government operations.
The session also included a Hackathon that brought forward brilliant ideas for public services. One standout idea was a ChatBot AI designed to filter and rephrase citizen complaints that contained inappropriate language, creating more productive communication. Another was an AI tool that assists with drafting legal complaints, which resonated deeply with public officials.
YoungWook Kim shared his experience and said, “From chatbots to automated document creation, the potential for AI to improve government-citizen interactions was clear. The Hackathon allowed public officials to think creatively about how they could use AI to address common challenges in governance.”
4. Building the Next Generation of AI Innovators: Empowering Students and Local Governments
TaeYoung Kim and Hyeshik Yoon, both MVPs and RDs, have been instrumental in spreading AI literacy to both local governments and the next generation of innovators.
In Daejeon, TaeYoung Kim created an Azure-based ChatBot AI for the city and led an initiative that introduced chatbot-building skills to over 1,075 students across 35 schools. He also implemented Azure Search to construct a large-scale vector store, demonstrating how AI can handle massive datasets.
Hyeshik Yoon, meanwhile, organized AI hackathons for students from six universities in Yongin city together with JinKwon Jeon and Bora Lee. These events helped students not only understand AI but also create real-world applications using Microsoft AI tools.
TaeYoung Kim shared his thoughts and said, “Fostering an early understanding of AI will help build a workforce prepared for the demands of an AI-driven world. Both local governments and students are now equipped with the skills to create their own AI tools, which will lead to more innovation in public services.”
Generative AI is Not the Future—It’s the Present
These case studies from South Korea showcase how public institutions, enterprises, and the education sector are already harnessing the power of Generative AI to drive change. Thanks to the efforts of MVPs and RDs, the once theoretical concept of AI is now becoming a practical tool for solving real-world challenges.
From automating mundane tasks to empowering future innovators, the global potential for AI is immense. As demand for AI-driven automation and applications grows worldwide, the efforts of these trailblazers provide a clear roadmap for how public and private sectors can embrace Generative AI and make a meaningful impact.
Microsoft Tech Community – Latest Blogs –Read More
What’s new in FLW shared devices
Discover the Latest Enhancements in Shared Device Mode (SDM)
We are excited to announce a series of new features in Shared Device Mode that will significantly enhance the experience for frontline workers. These updates are designed to streamline access to Teams on a shared device and provide better access to essential tools.
Teams FRE is suppressed for devices in shared device mode
One of the most significant changes is that we no longer show the Teams First Run Experience (FRE) on Android and iOS when the device is in Shared Device Mode. This update will reduce the number of clicks frontline workers need to take to get started in Teams. Thus, allowing FLWs to focus on getting work done. To take advantage of this update your Teams version to 2024152402 on Android and 2024121301 on iOS.
SDM support for M365 on Android and Outlook on Android are now GA
We have enabled more Microsoft apps on SDM. The unified M365 app on Android and Outlook app on Android are generally available! For details on more SDM supported apps please refer to the links below:
Android apps: Shared device mode for Android devices – Microsoft identity platform | Microsoft Learn
iOS apps: Shared device mode for iOS devices | Microsoft Learn
Refreshed Shared Device Documentation
We have refreshed our shared device documentation to provide clearer, more comprehensive guidance. This update ensures that all users, whether new or experienced, have access to the latest information and best practices for using Shared Device Mode effectively.
Overview of device management for frontline workers – Microsoft 365 for frontline workers | Microsoft Learn
Manage shared devices for frontline workers – Microsoft 365 for frontline workers | Microsoft Learn
Shared device mode for Android devices – Microsoft identity platform | Microsoft Learn
Shared device mode for iOS devices | Microsoft Learn
Next steps
These updates are part of our ongoing commitment to empower frontline workers with the best tools and experiences. We look forward to seeing how these enhancements will make a difference in your daily operations.
Stay tuned for more updates and enhancements as we continue to improve FLW shared devices.
Microsoft Tech Community – Latest Blogs –Read More
The Marketplace Partner Digest | September 2024
Welcome to the inaugural Partner Release Notes from the Microsoft commercial marketplace! The marketplace is central to how we keep you ahead, helping you reach more customers, simplify sales, and unlock growth. Dive into the latest product insights designed to keep you up to date with everything happening in the marketplace.
In this September issue, we’re bringing you a roundup of news from the past few months.
_______________________________________________________________________________________________________________________________________________
🚀 Noteworthy Highlights
Professional Services Now Available through Private Offers
Partners in Canada, the United Kingdom, and the United States can now sell professional services through private offers in the marketplace, providing you with more ways to monetize and serve customers.
The value for you and your customers:
Simplify sales by managing software and service sales together – enjoy a single payout for both software and services.
Customers can purchase complete solutions all on a single invoice, streamlining their procurement process.
Resources:
Read the blog: More ways to sell through the marketplace with professional services.
Short on time? Watch this demo on unlocking growth by selling professional services.
Ready to get started? Check out the technical documentation.
Multiparty Private Offers Have Expanded to the UK and Canada
Multiparty private offers (MPO) are now available in the United Kingdom and Canada, in addition to the United States.
The value for you and your customers:
Land bigger deals leveraging customers’ pre-committed cloud budget.
For customers with an Azure consumption commitment, sales count towards their consumption commitment when purchasing Azure IP co-sell eligible offers.
Resources:
Read the blog: Activating the ecosystem: marketplace multiparty private offers expand to new regions
Short on time? Watch this video on how Microsoft is investing to help you sell custom solutions through the marketplace with MPO.
Check out the technical documentation
Dynamics 365 Business Central Now Available through CSPs
ISVs can now transact Dynamics 365 Business Central apps through Cloud Solution Providers (CSP). This unlocks global sales opportunities through our CSP network, while allowing CSPs to expand their portfolios with D365 Business Central apps.
Interested in creating a D365 Business Central offer? Get started now.
Updated Policies for SaaS Offer Landing Pages
We have implemented new policy updates for SaaS offer landing pages in the marketplace to enhance customer experience and security. Learn more.
New Azure Platform Validation Policy
Starting July 8, 2024, partners listing SaaS offers on the Microsoft commercial marketplace must complete a new “Supplemental Content” page in Partner Center to streamline the publishing process.
To find out more about this requirement, check out the technical documentation and Azure platform policy for SaaS offers.
Self-Service for Tax Forms Available in Partner Center
Marketplace partners and ISV publishers can now directly access and download year-end tax forms through the Partner Center UI. Learn more.
New Filter for Teams Copilot-Enabled Apps on AppSource
AppSource now includes a filter for Teams Copilot-enabled apps, enhancing visibility for ISVs and simplifying the discovery of AI-powered solutions. Check it out on AppSource.
Partner Resources
Discover exclusive resources aimed at helping you get the most out of the marketplace!
Partner Roadmap Preview: Get a preview of what’s ahead. Watch the 20-minute roadmap presentation now! *Link requires partner sign-in.
Check out the latest marketplace blog on AI! As organizations embrace AI transformation, they are searching for next-generation applications that deliver real business value. Discover innovative AI solutions with the Microsoft commercial marketplace.
Upcoming Mastering the Marketplace webinars: Check out on-demand content available to help you develop transactable offers for the Microsoft commercial marketplace. All session times are listed in PDT.
September 26th, 9:30 am: Developing your container offer
October 3rd, 9:00 am: Creating your first offer in Partner Center
October 8th, 9:00 am: Creating plans and pricing for your offer
October 9th, 9:00 am: Developing your SaaS offer
Recent & Upcoming Events
Microsoft Ignite 2024: Join us at Microsoft Ignite happening in Chicago, IL from November 19-21, 2024, to learn what’s new in the marketplace, how to capture the marketplace and AI opportunity, and how you can scale your business through the marketplace. More details are coming soon. Register for Microsoft Ignite today!
UK Marketplace Summit: The UK Marketplace Summit is happening this week in London for UK-based partners. Microsoft marketplace executives, partner experts and industry leaders will deliver five sessions on how partners can create and scale their marketplace strategy. Sessions are being recorded and will be available on-demand. Stay tuned for access to this content and more in the October Partner Release Notes!
Share Your Feedback!
We truly appreciate your feedback and want to ensure these Partner Release Notes deliver the information you need to succeed in the marketplace. If you have any feedback or suggestions on how we can continue to improve the content to best support you, we’d love to hear from you in the comments below!
Thank you!
Microsoft Tech Community – Latest Blogs –Read More
Enabling and Using Copilot Agents in SharePoint – HLS Copilot Snacks
With Agent Builder in SharePoint building Copilot Agents to query your data in SharePoint is a simple point and click process. This enables business users to easily empower their audiences to glean useful information from their SharePoint repositories. Additionally, business users can customize their Copilot Agent easily to provide canned queries that provide users valuable starter prompts. Business users can even easily add additional repositories to provide further value across disparate sources of information. Lastly, resulting Copilot Agents can be readily shared via a simple hyperlink that can be embedded in SharePoint pages, used in Teams, etc.
In this HLS Copilot Snack, I walk you through the setup of a Copilot Agent using Agent Builder in SharePoint, customizing of the agent, and sharing of the agent.
Resources:
Copilot Agents in Sharepoint
Check out the blog post “Microsoft 365 Copilot Wave 2: Pages, Python in Excel, and agents”
Microsoft 365 Copilot – Microsoft Adoption
Thanks for visiting – Michael Gannotti LinkedIn
Microsoft Tech Community – Latest Blogs –Read More
MATLAB Coder: How do I setup the environment variables on ARM targets to point to the ARM Compute Library?
I see a few deep learning networks supported for code generation using MATLAB Coder:
Deep Learning Networks and Layers Supported for C++ Code Generation
And I’ve seen the question here about building the ARM Compute Library:
MATLAB Coder: How do I build the ARM Compute Library for Deep Learning C++ code generation and deployment?
The next question I have is, how do I set the environment variables on ARM targets to point to the ARM Compute Library?I see a few deep learning networks supported for code generation using MATLAB Coder:
Deep Learning Networks and Layers Supported for C++ Code Generation
And I’ve seen the question here about building the ARM Compute Library:
MATLAB Coder: How do I build the ARM Compute Library for Deep Learning C++ code generation and deployment?
The next question I have is, how do I set the environment variables on ARM targets to point to the ARM Compute Library? I see a few deep learning networks supported for code generation using MATLAB Coder:
Deep Learning Networks and Layers Supported for C++ Code Generation
And I’ve seen the question here about building the ARM Compute Library:
MATLAB Coder: How do I build the ARM Compute Library for Deep Learning C++ code generation and deployment?
The next question I have is, how do I set the environment variables on ARM targets to point to the ARM Compute Library? neural network, deep learning, code generation, coder-tips, arm, arm cortex-a, arm compute library MATLAB Answers — New Questions
recover color on image
i am converted rgb color image to im2bw format and gray scale image.
after i am extracted the boundary then i want to stored the the colored image.
please tell how to manage the color then recover or apply color for gray scale image and im2bw imagei am converted rgb color image to im2bw format and gray scale image.
after i am extracted the boundary then i want to stored the the colored image.
please tell how to manage the color then recover or apply color for gray scale image and im2bw image i am converted rgb color image to im2bw format and gray scale image.
after i am extracted the boundary then i want to stored the the colored image.
please tell how to manage the color then recover or apply color for gray scale image and im2bw image image processing, digital image processing, image, image segmentation, image analysis MATLAB Answers — New Questions
Is giving a space after comma in functions the convention?
I more often see
y = pdf(‘t’, x, df);
than
y = pdf(‘t’,x,df);
That is, people often give a space after comma when writing the input arguments in a function. But then when indexing from an array like
array[1,2]
they do not do this. I also see this happening in books. So is this indeed a convention? If not, what is the comvention? Or are both just a matter of preference. But I doubt that preference is the case because I consistently see the above happening.I more often see
y = pdf(‘t’, x, df);
than
y = pdf(‘t’,x,df);
That is, people often give a space after comma when writing the input arguments in a function. But then when indexing from an array like
array[1,2]
they do not do this. I also see this happening in books. So is this indeed a convention? If not, what is the comvention? Or are both just a matter of preference. But I doubt that preference is the case because I consistently see the above happening. I more often see
y = pdf(‘t’, x, df);
than
y = pdf(‘t’,x,df);
That is, people often give a space after comma when writing the input arguments in a function. But then when indexing from an array like
array[1,2]
they do not do this. I also see this happening in books. So is this indeed a convention? If not, what is the comvention? Or are both just a matter of preference. But I doubt that preference is the case because I consistently see the above happening. syntax MATLAB Answers — New Questions
How does MATLAB generate the probability density function?
I am using the pdf function (https://nl.mathworks.com/help/stats/prob.normaldistribution.pdf.html) to just visuilize the pdf of the t statistic for teaching purposes. I am wondering how MATLAB generates this continous distrubtion. That is, this is the limiting distrbituion, so MATLAB should be taking many many random draws from the t distrubtion so that the frequency distribtuon converges to the pdf as the limiting distribtuon and looks all smooth, i.e. it does not look at all like a frequency distribution. But then how come that this happens so fast that I get the pdf immedaitly when I call the pdf function? Or is this not how MATLAB generates the pdf?I am using the pdf function (https://nl.mathworks.com/help/stats/prob.normaldistribution.pdf.html) to just visuilize the pdf of the t statistic for teaching purposes. I am wondering how MATLAB generates this continous distrubtion. That is, this is the limiting distrbituion, so MATLAB should be taking many many random draws from the t distrubtion so that the frequency distribtuon converges to the pdf as the limiting distribtuon and looks all smooth, i.e. it does not look at all like a frequency distribution. But then how come that this happens so fast that I get the pdf immedaitly when I call the pdf function? Or is this not how MATLAB generates the pdf? I am using the pdf function (https://nl.mathworks.com/help/stats/prob.normaldistribution.pdf.html) to just visuilize the pdf of the t statistic for teaching purposes. I am wondering how MATLAB generates this continous distrubtion. That is, this is the limiting distrbituion, so MATLAB should be taking many many random draws from the t distrubtion so that the frequency distribtuon converges to the pdf as the limiting distribtuon and looks all smooth, i.e. it does not look at all like a frequency distribution. But then how come that this happens so fast that I get the pdf immedaitly when I call the pdf function? Or is this not how MATLAB generates the pdf? pdf, function MATLAB Answers — New Questions
Home decor platform development
My customer is developing a home decor platform where users can upload images of their rooms, apply different decor items like furniture or wall colors, and visualize how they would look. The platform relies on AI tools and APIs for object recognition and placement but is facing issues with accurately identifying the floor and objects.
The AI is currently rejecting the floor or placing items incorrectly. They are also working on improving search results based on uploaded images, which show similar but not exact matches, leading to inconsistencies in user experience. They are facing challenges in achieving accuracy and reducing processing time.
My customer is developing a home decor platform where users can upload images of their rooms, apply different decor items like furniture or wall colors, and visualize how they would look. The platform relies on AI tools and APIs for object recognition and placement but is facing issues with accurately identifying the floor and objects.
The AI is currently rejecting the floor or placing items incorrectly. They are also working on improving search results based on uploaded images, which show similar but not exact matches, leading to inconsistencies in user experience. They are facing challenges in achieving accuracy and reducing processing time. Read More
Keeping Leading 0 in Cell Data not just Cell Display
I need the data in a cell to keep the leading 0 without adding an ‘ to the cell data. I am uploading to a program that pulls the actual cell data, and the lack of the leading 0 or the addition of the ‘ both cause upload errors.
All the fixes I can find either only change the Cell Display while keeping the shortened number in the Cell Data (Special Formatting as Zip Code, or Custom Formatting as a N digit number large enough to show the leading 0 in Cell Display), or add an apostrophe to the Cell Data (formatting as text, or unchecking “Remove leading zeros and convert to a number” via Files> Excel Options> Data> Automatic Data Conversion).
I need the data in a cell to keep the leading 0 without adding an ‘ to the cell data. I am uploading to a program that pulls the actual cell data, and the lack of the leading 0 or the addition of the ‘ both cause upload errors. All the fixes I can find either only change the Cell Display while keeping the shortened number in the Cell Data (Special Formatting as Zip Code, or Custom Formatting as a N digit number large enough to show the leading 0 in Cell Display), or add an apostrophe to the Cell Data (formatting as text, or unchecking “Remove leading zeros and convert to a number” via Files> Excel Options> Data> Automatic Data Conversion). Read More
Getting help from Copilot in Excel creating a formula to calculate distinct values
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. This week I have a table of event locations, and I’d like to figure out a formula to count up the distinct locations.
Table of event locations with columns for Date and Location
I would like to find out how many locations are listed, so I ask Copilot:
How many distinct locations are there?
Copilot in Excel pane with the above prompt and the response below
I analyzed data in B2:C156, and here’s what I found:
Distinct Count of Location
50
Copilot said:
There are 50 distinct locations.
Copilot returns an answer of 50, but I would like to have a formula that updates as the list changes. A coworker suggested the formula below, but I don’t understand it. I ask copilot:
A coworker gave me this formula to calculate the distinct locations, can you tell me how it works: =SUM(–(FREQUENCY(MATCH(C:C, C:C, 0), MATCH(C:C, C:C, 0)) > 0))
Copilot in Excel pane with the above prompt and the response below
This formula calculates the number of distinct locations in column C. Here’s how it works:
MATCH(C:C, C:C, 0): This part of the formula creates an array of the positions of each value in column C. The 0 indicates an exact match.
FREQUENCY(MATCH(C:C, C:C, 0), MATCH(C:C, C:C, 0)): The FREQUENCY function is used to count the number of times each value appears in the array created by the MATCH function. It returns an array where each element represents the frequency of the corresponding value.
FREQUENCY(…) > 0: This part of the formula creates a boolean array where each element is TRUE if the corresponding frequency is greater than 0, and FALSE otherwise.
–(FREQUENCY(…) > 0): The double unary operator (–) converts the boolean array into an array of 1s and 0s, where TRUE becomes 1 and FALSE becomes 0.
SUM(…): Finally, the SUM function adds up the array of 1s and 0s, giving the total count of distinct locations.
I understand the formula, but it seems overly complicated. I’d like to see if Copilot can do better. I ask:
Can you simplify the formula?
Copilot in Excel pane with the above prompt and the response below
Yes, I can simplify the formula. Here is a more straightforward way to count distinct locations using the UNIQUE and COUNTA functions:
=COUNTA(UNIQUE(Table19[Location]))
That is much simpler! I copy the formula from the copilot pane and copy into my workbook. Now when I make changes to the table, the unique location count updates automatically.
2 cells with the values “Unique Locations” and the value “50” returned from the formula that was entered, next to the event location table.
Here are some additional examples from the last six weeks if you missed them:
Copilot in Excel examples for the week of August 12th
Copilot in Excel examples for the week of August 19th
Copilot in Excel examples for the week of August 26th
Copilot in Excel examples for the week of September 3rd
Copilot in Excel examples for the week of September 9th
Copilot in Excel examples for the week of September 16th
Stay tuned,
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. This week I have a table of event locations, and I’d like to figure out a formula to count up the distinct locations.
Table of event locations with columns for Date and Location
I would like to find out how many locations are listed, so I ask Copilot:
How many distinct locations are there?
Copilot in Excel pane with the above prompt and the response below
I analyzed data in B2:C156, and here’s what I found:
Distinct Count of Location
50
Copilot said:
There are 50 distinct locations.
Copilot returns an answer of 50, but I would like to have a formula that updates as the list changes. A coworker suggested the formula below, but I don’t understand it. I ask copilot:
A coworker gave me this formula to calculate the distinct locations, can you tell me how it works: =SUM(–(FREQUENCY(MATCH(C:C, C:C, 0), MATCH(C:C, C:C, 0)) > 0))
Copilot in Excel pane with the above prompt and the response below
This formula calculates the number of distinct locations in column C. Here’s how it works:
MATCH(C:C, C:C, 0): This part of the formula creates an array of the positions of each value in column C. The 0 indicates an exact match.
FREQUENCY(MATCH(C:C, C:C, 0), MATCH(C:C, C:C, 0)): The FREQUENCY function is used to count the number of times each value appears in the array created by the MATCH function. It returns an array where each element represents the frequency of the corresponding value.
FREQUENCY(…) > 0: This part of the formula creates a boolean array where each element is TRUE if the corresponding frequency is greater than 0, and FALSE otherwise.
–(FREQUENCY(…) > 0): The double unary operator (–) converts the boolean array into an array of 1s and 0s, where TRUE becomes 1 and FALSE becomes 0.
SUM(…): Finally, the SUM function adds up the array of 1s and 0s, giving the total count of distinct locations.
I understand the formula, but it seems overly complicated. I’d like to see if Copilot can do better. I ask:
Can you simplify the formula?
Copilot in Excel pane with the above prompt and the response below
Yes, I can simplify the formula. Here is a more straightforward way to count distinct locations using the UNIQUE and COUNTA functions:
=COUNTA(UNIQUE(Table19[Location]))
That is much simpler! I copy the formula from the copilot pane and copy into my workbook. Now when I make changes to the table, the unique location count updates automatically.
2 cells with the values “Unique Locations” and the value “50” returned from the formula that was entered, next to the event location table.
Here are some additional examples from the last six weeks if you missed them:
Copilot in Excel examples for the week of August 12th
Copilot in Excel examples for the week of August 19th
Copilot in Excel examples for the week of August 26th
Copilot in Excel examples for the week of September 3rd
Copilot in Excel examples for the week of September 9th
Copilot in Excel examples for the week of September 16th
Stay tuned,
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
branching based on multi select check box
Want to create a form where there is a list of items, and when you click on each one you’ll get another question rating the service.
IE
[] exterior wash
[] tire wash
[] interior detail
each time you check off a box, you’ll get a follow up question to rate 1-5.
can we do that?
Want to create a form where there is a list of items, and when you click on each one you’ll get another question rating the service. IE[] exterior wash[] tire wash[] interior detail each time you check off a box, you’ll get a follow up question to rate 1-5.can we do that? Read More
Skype phone numbers we are using for US, AU are not working at all, we need help please
We have already paid for yearly renting of the Skype phone numbers we are using for US, AU and these are not working because are not getting redirected after the right settings in place, also the voicemails are not working at all, no settings working at all and after paying there is no one to talk to and report the issue, no email of support, no department of support to send ticket, no phone number, absolutely nothing to provide you support as client for something that you paid and is not working!!!
I have tried to adjust the settings based on the forms from the Skype app for windows also from the Skype app for web and I tried both the redirect also the voicemail and none of them working to be setup. So disappointed and we already paid for 1 year in advance for both of them.
We need help!
We have already paid for yearly renting of the Skype phone numbers we are using for US, AU and these are not working because are not getting redirected after the right settings in place, also the voicemails are not working at all, no settings working at all and after paying there is no one to talk to and report the issue, no email of support, no department of support to send ticket, no phone number, absolutely nothing to provide you support as client for something that you paid and is not working!!! I have tried to adjust the settings based on the forms from the Skype app for windows also from the Skype app for web and I tried both the redirect also the voicemail and none of them working to be setup. So disappointed and we already paid for 1 year in advance for both of them. We need help! Read More
