Month: October 2024
Get ready for the 2025 Microsoft Imagine Cup: Let the innovation begin!
Turn your innovative idea into reality with the Microsoft Imagine Cup
Are you a student with an original idea that could possibly change the world? The 2025 Microsoft Imagine Cup is your opportunity to develop your idea, showcase your solution, and shine on a global stage.
Register now for the 2025 Imagine Cup!
The Imagine Cup is the premier global technology competition for student founders leveraging AI to push the boundaries of innovation. Unlock your startup’s potential with the Imagine Cup and turn your innovative idea into a market-ready startup.
Benefits of participating in Imagine Cup
Access to AI technology with Microsoft for Startups Founders Hub: All competitors will gain free access to industry-leading AI services, Azure credits with fewer restrictions, and essential tools to accelerate your growth and scale quickly through Founders Hub. Build with AI that meets your unique needs using Azure AI Studio. With models like OpenAI GPT-4o, Microsoft Research Phi-3, and Meta’s Llama 3.1, you’ll have the resources to develop scalable and impactful AI solutions.
Expert technical advice and founder guidance: Throughout the competition, you’ll receive support to grow your idea into a viable solution, making Imagine Cup a crucial step in your ongoing journey. Receive personalized one-on-one coaching from Microsoft experts to refine your pitch. Within Microsoft for Startups Founders Hub, you can gain access to the Expert Network to seek advice and feedback on immediate business challenges, and Azure Pairing sessions to get advice from Azure engineers on the latest in AI, optimizing infrastructure, reducing costs, and more.
Global recognition and networking with industry leaders: Connect with a global network of fellow founders and industry leaders. Increase your international visibility as you progress further through the competition with featured content about your startup on Microsoft social channels. Select finalists may also have the opportunity to attend Microsoft Build in person, where they will present, gain exposure, and make essential connections
The winning team will receive USD100,000* and an exclusive mentoring session with Microsoft Chairman and CEO, Satya Nadella! The two runner-up teams will each receive USD25,000.
Optional idea submissions for early feedback are due October 31, 2024 and MVP submissions are due January 22, 2025. Get started today and register for 2025 Imagine Cup to start building the future.
What’s next?
Register for 2025 Imagine Cup! You can manage your team and personal profile on your account page.
Sign up for Microsoft for Startups Founders Hub to gain access to industry-leading AI services, credits, and essential tools. Sign up with the same email address and select Imagine Cup as your Microsoft partner.
To apply for Microsoft for Startups Founders Hub, your startup must meet all program eligibility requirements. View more information on eligibility requirements for applying to Founders Hub.
Submit a Lean Canvas to the optional idea round by October 31, 2024 for a chance to gather early feedback from industry experts prior to building your minimum viable product (MVP). An MVP is required for general submission on January 22, 2025. Additional information on the competition structure is listed below.
Need some inspiration?
Join the Student Innovator Series through Microsoft Reactor for an Imagine Cup kickoff and deep dive sessions on Azure AI and Microsoft for Startups Founders Hub to learn how to build your MVP.
To kick off the 2025 Imagine Cup competition, join one of two live events on October 1st at 9:00 am PT (UTC -7) or 5:00 pm PT (UTC -7). Unable to join the kickoffs live? Not to worry – click the links to watch on demand and check out the rest of the Student Innovator Series to help you on your competition journey.
Check out these other upcoming sessions you don’t want to miss to learn how to build an AI-driven solution:
Azure OpenAI and Azure AI Search (Python)
GitHub Copilot Adventures
Serverless AI Chat with RAG using LangChain.js
Microsoft for Startups Founders Hub Welcome Day
* Multiple times and dates available, check the full list of events and register for free at https://aka.ms/StudentInnovatorSeries
Watch a recap of the exciting final round from last year’s competition. Ideas from past Imagine Cup competitions have inspired countless new innovations! Driven from personal experience and a mission to improve the lives of the visually impaired, last year’s World Champion FROM YOUR EYES developed a mobile application and API, which offers real-time visual explanations to users with a vision disability.
Competition Structure and Helpful Resources
Optional: Idea Submission / submit by October 31, 2024
You’ve registered for the Imagine Cup and applied to Microsoft for Startups Founders Hub. Now, submit a completed Lean Canvas to the optional Idea Submission round and receive early support, expert feedback, and valuable resources to build a uniquely positioned idea to submit for the minimal viable product round Lean Canvas is a one-page business model that helps quickly and effectively communicate business ideas and strategies. Don’t miss this opportunity—submit by October 31!
Helpful resources for getting started:
What is Lean Canvas? | Miro
Lean Canvas vs Business Model Canvas | Miro
Overview of Lean Canvas
MVP Submission / submit by January 22, 2025
Submit your MVP including a pitch deck and a recorded video of your pitch and demo to showcase its functionality and impact. Ensure this version is demo ready for judges and includes sufficient features and functionality to satisfy early adopters.
Helpful resources for getting started:
How to pitch your company – Training | Microsoft Learn
How to Build a Demo Video from Microsoft for Startups
Rapid Prototyping from Microsoft for Startups
Semifinals / March 2025
Gain access to additional benefits to accelerate your growth, including mentorship, global recognition, and expert guidance within Microsoft for Startups Founders Hub. In this round, you will participate in a deep dive technical review with Microsoft experts, work on your pitch and strategy with mentors and experts, and pitch live to a virtual panel of judges.
World Championship / May 2025
The World Championship is the culmination of the competition, where teams continue to hone their pitch with additional mentoring. This round may take place virtually or in person, with the top three teams presenting live to a panel of judges who are experts in their respective field. Teams are competing for the ultimate prize of USD100,000 and a mentorship session with Microsoft Chairman and CEO, Satya Nadella! Step into the spotlight and demonstrate how AI can drive innovation and positive change.
Review the Imagine Cup Official Rules and Regulations to understand what is required for each competition round.
Dream it. Build it. Live it.
The competition is just getting started, so stay tuned and follow us on X, Instagram, LinkedIn, and Facebook for exciting announcements and the latest updates.
Remember, MVP submissions are due January 22, 2025 so get started today and register for 2025 Imagine Cup to start building the future.
Register for the 2025 Imagine Cup
Happy Innovating!
The Imagine Cup team
*Open only to enrolled high-school or college/university students 18+. For additional eligibility criteria, round start/end dates, and detailed instructions on how to participate, see the Imagine Cup Official Rules and Regulations.
Microsoft Tech Community – Latest Blogs –Read More
Is it possible to simulate UE mobility using latitude and longitude coordinates?
I’m studing the example "CreateConfigureAndSimulate5GNRNodesExample.mlx".
In this example you can add mobility to a UE using the method:
addMobility(ue,BoundaryShape="rectangle")
But, if I have coordinates from my cenario and UE by along the time (a list of diferent lon,lat coods from user monitoring, for example) it is possible to simulate the mobility using this data?I’m studing the example "CreateConfigureAndSimulate5GNRNodesExample.mlx".
In this example you can add mobility to a UE using the method:
addMobility(ue,BoundaryShape="rectangle")
But, if I have coordinates from my cenario and UE by along the time (a list of diferent lon,lat coods from user monitoring, for example) it is possible to simulate the mobility using this data? I’m studing the example "CreateConfigureAndSimulate5GNRNodesExample.mlx".
In this example you can add mobility to a UE using the method:
addMobility(ue,BoundaryShape="rectangle")
But, if I have coordinates from my cenario and UE by along the time (a list of diferent lon,lat coods from user monitoring, for example) it is possible to simulate the mobility using this data? ue, mobility, 5g MATLAB Answers — New Questions
Two codes for the same dataset have different root mean square error values
Hello, i am working on wknn for localization, the first code requires input of the rss values and the error is less than 5m but the second code has a training and a test set and the error is above 500m, i cannot figure why this is happening. I have attached the code and the dataset. Thank you.Hello, i am working on wknn for localization, the first code requires input of the rss values and the error is less than 5m but the second code has a training and a test set and the error is above 500m, i cannot figure why this is happening. I have attached the code and the dataset. Thank you. Hello, i am working on wknn for localization, the first code requires input of the rss values and the error is less than 5m but the second code has a training and a test set and the error is above 500m, i cannot figure why this is happening. I have attached the code and the dataset. Thank you. wknn localization MATLAB Answers — New Questions
Microsoft Loop: A New Frontier for Agile Teams
Microsoft Loop is a cutting-edge collaboration tool designed to enhance teamwork by providing a dynamic, flexible workspace for agile projects. As businesses shift toward remote and hybrid work, the need for adaptive, real-time collaboration becomes more critical. Loop addresses these needs by combining aspects of Microsoft 365 with modern workflows, allowing teams to work seamlessly across various platforms.
Microsoft Loop is a cutting-edge collaboration tool designed to enhance teamwork by providing a dynamic, flexible workspace for agile projects. As businesses shift toward remote and hybrid work, the need for adaptive, real-time collaboration becomes more critical. Loop addresses these needs by combining aspects of Microsoft 365 with modern workflows, allowing teams to work seamlessly across various platforms.
Read the full blog Read More
Shared mailbox activity report
I’m trying to generate a report showing email activity for each mailbox in our tenant, to see how many items were sent or received in the past 180 days. The plan is to aggregate this data to find out which locations are the most/least active in using email.
Although the M365 reports can do this, it only includes user mailboxes so I’m missing out a big chunk of information from shared mailboxes, which is skewing the data since a lot of users would use these instead of their own mailbox.
Is there any way to get this data? It only seems possible to get mailbox size or folder statistics which is only a point in time figure.
I’m trying to generate a report showing email activity for each mailbox in our tenant, to see how many items were sent or received in the past 180 days. The plan is to aggregate this data to find out which locations are the most/least active in using email. Although the M365 reports can do this, it only includes user mailboxes so I’m missing out a big chunk of information from shared mailboxes, which is skewing the data since a lot of users would use these instead of their own mailbox. Is there any way to get this data? It only seems possible to get mailbox size or folder statistics which is only a point in time figure. Read More
Update issue (KB5043145)
Good morning.
We recently had users reporting that the Details Panel disappeared in the latest Windows update (KB5043145). I uninstalled the last update and it actually worked again.
The panel I’m referring to is in the attached image.
I tried looking for options via Regedit to reactivate it, but without success.
Good morning.We recently had users reporting that the Details Panel disappeared in the latest Windows update (KB5043145). I uninstalled the last update and it actually worked again.The panel I’m referring to is in the attached image.I tried looking for options via Regedit to reactivate it, but without success. Read More
Microsoft Defender for Office 365 Implementation
Hello. I would like to discuss and get few information as mentioned below,
1) Which plan of Defender for Office 365 is included in Microsoft 365 Business Basics?
2) Can I buy only Microsoft Defender for Office 365 licenses? Which plan will be included in that license?
3) If only Defender for Office 365 license is bought then will this license only provide protection to the user that has the license assigned or the whole organization?
4) Are there any steps that I can follow to configure/ implement Microsoft Defender for Office 365?
5) What are the features of Microsoft Defender for Office 365 (plan 1 and Plan 2)?
Thank you for your attention.
Hello. I would like to discuss and get few information as mentioned below, 1) Which plan of Defender for Office 365 is included in Microsoft 365 Business Basics?2) Can I buy only Microsoft Defender for Office 365 licenses? Which plan will be included in that license?3) If only Defender for Office 365 license is bought then will this license only provide protection to the user that has the license assigned or the whole organization?4) Are there any steps that I can follow to configure/ implement Microsoft Defender for Office 365?5) What are the features of Microsoft Defender for Office 365 (plan 1 and Plan 2)? Thank you for your attention. Read More
I am trying to write a script to convert a test case from baseline to Real- Time using test manager. However I am unable to do it programmatically. Is there any way to do it ?
I am trying to write a script to run a series of test cases and would like to open Test Manager as little as possible. I have found that you can programmatically create a test case and specify the type as either ‘baseline’,’equivalence’, or ‘simulation’. However, I have not been able to find a type to create a test case for real-time simulation without having to open Test Manager.I am trying to write a script to run a series of test cases and would like to open Test Manager as little as possible. I have found that you can programmatically create a test case and specify the type as either ‘baseline’,’equivalence’, or ‘simulation’. However, I have not been able to find a type to create a test case for real-time simulation without having to open Test Manager. I am trying to write a script to run a series of test cases and would like to open Test Manager as little as possible. I have found that you can programmatically create a test case and specify the type as either ‘baseline’,’equivalence’, or ‘simulation’. However, I have not been able to find a type to create a test case for real-time simulation without having to open Test Manager. simulink test, real time test, test manager, test case MATLAB Answers — New Questions
IP Address in Hardware Implementation (External Mode in Configuration Parameters) is not used for code generation
Hello community,
we developed our own toolchain for an Intel Cyclone V FPGA (MitySOM-5CSX) using this tutorial (https://de.mathworks.com/help/ecoder/target-sdk.html), to generate code from Simulink models using the Embedded Coder Support Package for ARM Cortex-A Processors. In the 5th step of this tutorial (Activate the Application Deployment Feature) the IP address of the target board is specified, which then also appears correct under Configuration Parameters -> Hardware Implementation -> External Mode.
Now, if you want to change this IP address at this point (Configuration Parameters -> Hardware Implementation -> External Mode), the embedded coder will not use this new IP address, but only the one that was specified when the target was created. That means, no matter which IP address the user later sets under Configuration Parameters -> Hardware Implementation -> External Mode, only the one specified when creating the target will be used for code generation, which is unsuitable.
Is this a bug or a feature? Where can the user later set the IP address of his target board, which then will be used by the embedded coder?
Thank you guys and with best wishes,
Lars LindnerHello community,
we developed our own toolchain for an Intel Cyclone V FPGA (MitySOM-5CSX) using this tutorial (https://de.mathworks.com/help/ecoder/target-sdk.html), to generate code from Simulink models using the Embedded Coder Support Package for ARM Cortex-A Processors. In the 5th step of this tutorial (Activate the Application Deployment Feature) the IP address of the target board is specified, which then also appears correct under Configuration Parameters -> Hardware Implementation -> External Mode.
Now, if you want to change this IP address at this point (Configuration Parameters -> Hardware Implementation -> External Mode), the embedded coder will not use this new IP address, but only the one that was specified when the target was created. That means, no matter which IP address the user later sets under Configuration Parameters -> Hardware Implementation -> External Mode, only the one specified when creating the target will be used for code generation, which is unsuitable.
Is this a bug or a feature? Where can the user later set the IP address of his target board, which then will be used by the embedded coder?
Thank you guys and with best wishes,
Lars Lindner Hello community,
we developed our own toolchain for an Intel Cyclone V FPGA (MitySOM-5CSX) using this tutorial (https://de.mathworks.com/help/ecoder/target-sdk.html), to generate code from Simulink models using the Embedded Coder Support Package for ARM Cortex-A Processors. In the 5th step of this tutorial (Activate the Application Deployment Feature) the IP address of the target board is specified, which then also appears correct under Configuration Parameters -> Hardware Implementation -> External Mode.
Now, if you want to change this IP address at this point (Configuration Parameters -> Hardware Implementation -> External Mode), the embedded coder will not use this new IP address, but only the one that was specified when the target was created. That means, no matter which IP address the user later sets under Configuration Parameters -> Hardware Implementation -> External Mode, only the one specified when creating the target will be used for code generation, which is unsuitable.
Is this a bug or a feature? Where can the user later set the IP address of his target board, which then will be used by the embedded coder?
Thank you guys and with best wishes,
Lars Lindner embedded coder, code gerneration, external mode, ip adress, arm cortex-a processors MATLAB Answers — New Questions
How do I segment cracks in a noisy image?
I have pictures of cracks in soil taken in an outdoor experiment which I am looking to quanitfy. My ultimate goal is to segment the cracks from the intact soil peds to calculate width and then skeletonise to get length, intersection angles etc. As the photos are taken outdoors when i try to segment the cracks from the intact soil peds there is a lot of noise due to the uneven lighting conditions and highly pitted surface caused by rain action. Can anyone help with problem and suggest how to best formulate a code to address a high degree of hetereogenity between images?I have pictures of cracks in soil taken in an outdoor experiment which I am looking to quanitfy. My ultimate goal is to segment the cracks from the intact soil peds to calculate width and then skeletonise to get length, intersection angles etc. As the photos are taken outdoors when i try to segment the cracks from the intact soil peds there is a lot of noise due to the uneven lighting conditions and highly pitted surface caused by rain action. Can anyone help with problem and suggest how to best formulate a code to address a high degree of hetereogenity between images? I have pictures of cracks in soil taken in an outdoor experiment which I am looking to quanitfy. My ultimate goal is to segment the cracks from the intact soil peds to calculate width and then skeletonise to get length, intersection angles etc. As the photos are taken outdoors when i try to segment the cracks from the intact soil peds there is a lot of noise due to the uneven lighting conditions and highly pitted surface caused by rain action. Can anyone help with problem and suggest how to best formulate a code to address a high degree of hetereogenity between images? cracks, image segmentation, image processing, uneven lighting MATLAB Answers — New Questions
How to split of into train and test with labels data??
Hello Sir,
I have dataset of images and its labels , i want to split it into train_data, train_labels and test_data, test_labels with separated folders??Hello Sir,
I have dataset of images and its labels , i want to split it into train_data, train_labels and test_data, test_labels with separated folders?? Hello Sir,
I have dataset of images and its labels , i want to split it into train_data, train_labels and test_data, test_labels with separated folders?? srivardhan gadila MATLAB Answers — New Questions
Need to rectify error in my matlab code given below
syms t
mu=2500*(10^-4); %cm^2*V^-1 * s^-1
R = 0.318;
eta=377;% ohm
N=3.681; %refindex
Pavg=7;%W
Za=50;%ohm
g=100*(10^-6);%m
pi=3.14;
alpha= 8.5*(10^4); %m^-1
taul= 35*(10^-15); %s
tauc= 10*(10^-12); %s
W=100*(10^-6); %m
L=300*(10^-6); % m
Tlt=325*(10^-6); % m
V=25; %V
E=V./g;
vopt=375*(10^12); %Hz
e=1.602*(10^-19);
h=6.626*(10^-34);
I=0.90*(10^8);% i
t=linspace(-0.5*(10^-12),3.0*(10^-12),100);
n(t)=I.*exp(-2).*((1-R)./(sqrt(2.*pi).*h.*vopt)).*taul.*exp((-taul.^2)./(8.*tauc.^2)).*exp(-t./tauc).*(erf(sqrt(2).*t./taul – (sqrt(2).*taul)./(4.*tauc))+1);
tc = 10.*(10.^-12);
n0=10.^18
dt=80.*(10^-12);
G=n0.*exp((-t.*t)/(dt.*dt))
ode = diff(n,t) == (-n./tc) + G;
cond = n(0) == n0;
nSol(t)=dsolve(ode,cond);
It shows difference order N must be a positive integer. Error in third last line. How to solve this error?syms t
mu=2500*(10^-4); %cm^2*V^-1 * s^-1
R = 0.318;
eta=377;% ohm
N=3.681; %refindex
Pavg=7;%W
Za=50;%ohm
g=100*(10^-6);%m
pi=3.14;
alpha= 8.5*(10^4); %m^-1
taul= 35*(10^-15); %s
tauc= 10*(10^-12); %s
W=100*(10^-6); %m
L=300*(10^-6); % m
Tlt=325*(10^-6); % m
V=25; %V
E=V./g;
vopt=375*(10^12); %Hz
e=1.602*(10^-19);
h=6.626*(10^-34);
I=0.90*(10^8);% i
t=linspace(-0.5*(10^-12),3.0*(10^-12),100);
n(t)=I.*exp(-2).*((1-R)./(sqrt(2.*pi).*h.*vopt)).*taul.*exp((-taul.^2)./(8.*tauc.^2)).*exp(-t./tauc).*(erf(sqrt(2).*t./taul – (sqrt(2).*taul)./(4.*tauc))+1);
tc = 10.*(10.^-12);
n0=10.^18
dt=80.*(10^-12);
G=n0.*exp((-t.*t)/(dt.*dt))
ode = diff(n,t) == (-n./tc) + G;
cond = n(0) == n0;
nSol(t)=dsolve(ode,cond);
It shows difference order N must be a positive integer. Error in third last line. How to solve this error? syms t
mu=2500*(10^-4); %cm^2*V^-1 * s^-1
R = 0.318;
eta=377;% ohm
N=3.681; %refindex
Pavg=7;%W
Za=50;%ohm
g=100*(10^-6);%m
pi=3.14;
alpha= 8.5*(10^4); %m^-1
taul= 35*(10^-15); %s
tauc= 10*(10^-12); %s
W=100*(10^-6); %m
L=300*(10^-6); % m
Tlt=325*(10^-6); % m
V=25; %V
E=V./g;
vopt=375*(10^12); %Hz
e=1.602*(10^-19);
h=6.626*(10^-34);
I=0.90*(10^8);% i
t=linspace(-0.5*(10^-12),3.0*(10^-12),100);
n(t)=I.*exp(-2).*((1-R)./(sqrt(2.*pi).*h.*vopt)).*taul.*exp((-taul.^2)./(8.*tauc.^2)).*exp(-t./tauc).*(erf(sqrt(2).*t./taul – (sqrt(2).*taul)./(4.*tauc))+1);
tc = 10.*(10.^-12);
n0=10.^18
dt=80.*(10^-12);
G=n0.*exp((-t.*t)/(dt.*dt))
ode = diff(n,t) == (-n./tc) + G;
cond = n(0) == n0;
nSol(t)=dsolve(ode,cond);
It shows difference order N must be a positive integer. Error in third last line. How to solve this error? ode MATLAB Answers — New Questions
KB5043168 Cumulative update crashed explorer.
Help! My PC just ran a Cumulative Update for Windows 11 Insider Preview (10.0.26120.1912) (KB5043168), and now the Explorer function is broken. I cant access explorer, open folders, rename them, etc.
I can’t find a way to revert the update using the regular “uninstall update”. Using Safe mode won’t allow access to W11 update apparently.
What do I do now?!
Help! My PC just ran a Cumulative Update for Windows 11 Insider Preview (10.0.26120.1912) (KB5043168), and now the Explorer function is broken. I cant access explorer, open folders, rename them, etc.I can’t find a way to revert the update using the regular “uninstall update”. Using Safe mode won’t allow access to W11 update apparently. What do I do now?! Read More
Formula Help
Hi, I hope this is a thing and someone knows the way.
Is is possible, using the info in the Green sections, to have the Blue section automatically fill in the total based on values added manually in the Orange section? Spider for example: 2=8, 6=18, 1=1 and the check marks combined = 6, then add it all up and put the final value in the Blue section. Thanks 🙂
Hi, I hope this is a thing and someone knows the way.Is is possible, using the info in the Green sections, to have the Blue section automatically fill in the total based on values added manually in the Orange section? Spider for example: 2=8, 6=18, 1=1 and the check marks combined = 6, then add it all up and put the final value in the Blue section. Thanks 🙂 Read More
Before linking you must first complete at least one exam or certification
Dear Microsoft
Microsoft partners gains awesome insights from learners skilling progress AND certifications under Insights in Partner Center!
Hence we guide our learners when “creating” their personal Microsoft Learn accounts to associate to the partnership – already when creating the Learn account.
Both to do the association to get the ESI-discount (now that association is also needed to have users showing up in ESI-insights unfortunately, as this change interferes with other processes to cross-check ESI users with actually associated accounts to the partnership) as well as associating to our partnership (already when creating the account, for FUTURE tracking in MAICPP programs!)
Why have you now made also this dramatically change for your partners, that interferes with our smoothly working processes?
I assume you didn´t even check with the partner community before making this change!
“Before linking your Microsoft Learn profile to your Partner Center account, you must first complete at least one exam or certification in your Microsoft Learn profile.”
This and other recent changes really complex an already complex management of the partnership and fulfilment/maintenence of MAICPP!
Gabriel Yttermalm
Alliance Manager Microsoft for Digital Services Europe
(business line of Orange Business)
Dear MicrosoftMicrosoft partners gains awesome insights from learners skilling progress AND certifications under Insights in Partner Center!Hence we guide our learners when “creating” their personal Microsoft Learn accounts to associate to the partnership – already when creating the Learn account.Both to do the association to get the ESI-discount (now that association is also needed to have users showing up in ESI-insights unfortunately, as this change interferes with other processes to cross-check ESI users with actually associated accounts to the partnership) as well as associating to our partnership (already when creating the account, for FUTURE tracking in MAICPP programs!)Why have you now made also this dramatically change for your partners, that interferes with our smoothly working processes?I assume you didn´t even check with the partner community before making this change!”Before linking your Microsoft Learn profile to your Partner Center account, you must first complete at least one exam or certification in your Microsoft Learn profile.”This and other recent changes really complex an already complex management of the partnership and fulfilment/maintenence of MAICPP!Gabriel YttermalmAlliance Manager Microsoft for Digital Services Europe(business line of Orange Business) Read More
How do I change a table with 2 columns where I have repeating values in both columns into a matrix?
Hopefully I will be able to explain my problem correctly.
I have a table with two columns in it. Column A has students in it, column B has the subject that each student is taking. Both column A and column B have repeating values, but together they are unique. For example
NameSubjectJimmyMathsJimmyBiologyJimmyChemistryMaximeMathsMaximeComputer ScienceMaximeHistory
What I need to do is turn this into a matrix (is that the correct term?) which looks like this
NameSubject ASubject BSubject CJimmyMathsBiologyChemistryMaximeMathsComputer ScienceHistory
Can this be done?
Hopefully I will be able to explain my problem correctly. I have a table with two columns in it. Column A has students in it, column B has the subject that each student is taking. Both column A and column B have repeating values, but together they are unique. For example NameSubjectJimmyMathsJimmyBiologyJimmyChemistryMaximeMathsMaximeComputer ScienceMaximeHistory What I need to do is turn this into a matrix (is that the correct term?) which looks like this NameSubject ASubject BSubject CJimmyMathsBiologyChemistryMaximeMathsComputer ScienceHistory Can this be done? Read More
Outlook ICS description being overridden
Hi there,
I’m sending emails with ICS attachments. And facing problems like: Outlook does replace my DESCRIPTION/X-ALT-DESC by the email content automaticaly. So Outlook does create Calendar event automaticaly based on .ICS attachment BUT REPLACE/OVERRIDE the DESCRIPTION.
Expected behaviour: Show original DESCRIPTION/X-ALT-DESC from .ICS attachment. When automatic Calendar event created.
Current behaviour: Override .ICS DESCRIPTION/X-ALT-DESC by shortened unformatted email body.
Questions:
1 – Is there a way to do what is expected by adding some X-MICROSOFT** flags to the .ICS?
2 – Is there a way to do what is expected by Outlook/Calendar client config?
Note:
I’ve already tried to specify X-ALT-DESC instead/together with DESCRIPTIONICS file is valid and being consumed well by othe Calendar client (google e.t.c). No overrides.
Hi there,I’m sending emails with ICS attachments. And facing problems like: Outlook does replace my DESCRIPTION/X-ALT-DESC by the email content automaticaly. So Outlook does create Calendar event automaticaly based on .ICS attachment BUT REPLACE/OVERRIDE the DESCRIPTION.Expected behaviour: Show original DESCRIPTION/X-ALT-DESC from .ICS attachment. When automatic Calendar event created.Current behaviour: Override .ICS DESCRIPTION/X-ALT-DESC by shortened unformatted email body.Questions:1 – Is there a way to do what is expected by adding some X-MICROSOFT** flags to the .ICS?2 – Is there a way to do what is expected by Outlook/Calendar client config?Note: I’ve already tried to specify X-ALT-DESC instead/together with DESCRIPTIONICS file is valid and being consumed well by othe Calendar client (google e.t.c). No overrides. Read More
Not able to drag the color-coded border to change cell in formula
Hello,
Normally when I want to change a cell reference to another cell reference I double-click the cell containing the formula and drag the color-coded border to the new cell. I am no longer able to do that in excel and need to type in the name of the new cell in the formula. Really annoying. Any hints to how I can reactivate the
Hello, Normally when I want to change a cell reference to another cell reference I double-click the cell containing the formula and drag the color-coded border to the new cell. I am no longer able to do that in excel and need to type in the name of the new cell in the formula. Really annoying. Any hints to how I can reactivate the Read More
JSON date and time column
Hey guys
I’ve been using a JSON from GitHub for a simple date and time column.
it’s been working perfectly and showing all the correct dates, but recently it’s started to display the wrong dates.
can anybody tell me how I can fix this? So in my SharePoint list the end user enters the date 12/10/2024 but it will display as 13/10/2024
here’s the JSON:
{ “$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json“, “elmType”: “div”, “style”: { “flex-direction”: “column”, “width”: “50px”, “margin”: “5px”, “display”: “=if(@currentField,’flex’,’none’)” }, “children”: [ { “elmType”: “div”, “txtContent”: “=getYear(@currentField)”, “style”: { “margin”: “2px” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-fontWeight-bold” } }, { “elmType”: “div”, “forEach”: “weekday in split(‘0,1,2,3,4,5,6′,’,’)”, “style”: { “white-space”: “nowrap” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-fontWeight-bold” }, “children”: [ { “elmType”: “div”, “txtContent”: “=if([$weekday]==’0′,’Saturday’,if([$weekday]==’1′,’Sunday’,if([$weekday]==’2′,’Monday’,if([$weekday]==’3′,’Tuesday’,if([$weekday]==’4′,’Wednesday’,if([$weekday]==’5′,’Thursday’,if([$weekday]==’6′,’Friday’,”))))))”, “style”: { “margin-bottom”: “2px”, “display”: “=if((getMonth(@currentField)+1)>2,if(((getDate(@currentField)+floor(26*(getMonth(@currentField)+1+1)/10)+Number(substring(toString(getYear(@currentField)),2,4))+floor(Number(substring(toString(getYear(@currentField)),2,4))/4)+floor(Number(substring(toString(getYear(@currentField)),0,2))/4)-2*Number(substring(toString(getYear(@currentField)),0,2)))%7)==Number([$weekday]),”,’none’),if(((getDate(@currentField)+floor(26*(getMonth(@currentField)+1+12+1)/10)+Number(substring(toString(getYear(@currentField)-1),2,4))+floor(Number(substring(toString(getYear(@currentField)-1),2,4))/4)+floor(Number(substring(toString(getYear(@currentField)-1),0,2))/4)-2*Number(substring(toString(getYear(@currentField)-1),0,2)))%7)==Number([$weekday]),”,’none’)” } } ] }, { “elmType”: “div”, “txtContent”: “=if(getMonth(@currentField)==0,’Jan’,if(getMonth(@currentField)==1,’Feb’,if(getMonth(@currentField)==2,’Mar’,if(getMonth(@currentField)==3,’Apr’,if(getMonth(@currentField)==4,’May’,if(getMonth(@currentField)==5,’Jun’,if(getMonth(@currentField)==6,’Jul’,if(getMonth(@currentField)==7,’Aug’,if(getMonth(@currentField)==8,’Sep’,if(getMonth(@currentField)==9,’Oct’,if(getMonth(@currentField)==10,’Nov’,if(getMonth(@currentField)==11,’Dec’,”))))))))))))”, “style”: { “display”: “flex”, “justify-content”: “center”, “align-items”: “center”, “width”: “100%”, “height”: “20px”, “border”: “1px solid”, “margin-bottom”: “-1px” }, “attributes”: { “class”: “ms-bgColor-themePrimary ms-fontColor-white ms-borderColor-themePrimary ms-fontWeight-bold” } }, { “elmType”: “div”, “txtContent”: “=getDate(@currentField)”, “style”: { “display”: “flex”, “justify-content”: “center”, “align-items”: “center”, “width”: “48px”, “border”: “1px solid”, “height”: “30px” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-borderColor-themePrimary ms-fontWeight-bold ms-fontSize-20” } } ] }
Hey guys I’ve been using a JSON from GitHub for a simple date and time column. it’s been working perfectly and showing all the correct dates, but recently it’s started to display the wrong dates. can anybody tell me how I can fix this? So in my SharePoint list the end user enters the date 12/10/2024 but it will display as 13/10/2024 here’s the JSON: { “$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”, “elmType”: “div”, “style”: { “flex-direction”: “column”, “width”: “50px”, “margin”: “5px”, “display”: “=if(@currentField,’flex’,’none’)” }, “children”: [ { “elmType”: “div”, “txtContent”: “=getYear(@currentField)”, “style”: { “margin”: “2px” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-fontWeight-bold” } }, { “elmType”: “div”, “forEach”: “weekday in split(‘0,1,2,3,4,5,6′,’,’)”, “style”: { “white-space”: “nowrap” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-fontWeight-bold” }, “children”: [ { “elmType”: “div”, “txtContent”: “=if([$weekday]==’0′,’Saturday’,if([$weekday]==’1′,’Sunday’,if([$weekday]==’2′,’Monday’,if([$weekday]==’3′,’Tuesday’,if([$weekday]==’4′,’Wednesday’,if([$weekday]==’5′,’Thursday’,if([$weekday]==’6′,’Friday’,”))))))”, “style”: { “margin-bottom”: “2px”, “display”: “=if((getMonth(@currentField)+1)>2,if(((getDate(@currentField)+floor(26*(getMonth(@currentField)+1+1)/10)+Number(substring(toString(getYear(@currentField)),2,4))+floor(Number(substring(toString(getYear(@currentField)),2,4))/4)+floor(Number(substring(toString(getYear(@currentField)),0,2))/4)-2*Number(substring(toString(getYear(@currentField)),0,2)))%7)==Number([$weekday]),”,’none’),if(((getDate(@currentField)+floor(26*(getMonth(@currentField)+1+12+1)/10)+Number(substring(toString(getYear(@currentField)-1),2,4))+floor(Number(substring(toString(getYear(@currentField)-1),2,4))/4)+floor(Number(substring(toString(getYear(@currentField)-1),0,2))/4)-2*Number(substring(toString(getYear(@currentField)-1),0,2)))%7)==Number([$weekday]),”,’none’)” } } ] }, { “elmType”: “div”, “txtContent”: “=if(getMonth(@currentField)==0,’Jan’,if(getMonth(@currentField)==1,’Feb’,if(getMonth(@currentField)==2,’Mar’,if(getMonth(@currentField)==3,’Apr’,if(getMonth(@currentField)==4,’May’,if(getMonth(@currentField)==5,’Jun’,if(getMonth(@currentField)==6,’Jul’,if(getMonth(@currentField)==7,’Aug’,if(getMonth(@currentField)==8,’Sep’,if(getMonth(@currentField)==9,’Oct’,if(getMonth(@currentField)==10,’Nov’,if(getMonth(@currentField)==11,’Dec’,”))))))))))))”, “style”: { “display”: “flex”, “justify-content”: “center”, “align-items”: “center”, “width”: “100%”, “height”: “20px”, “border”: “1px solid”, “margin-bottom”: “-1px” }, “attributes”: { “class”: “ms-bgColor-themePrimary ms-fontColor-white ms-borderColor-themePrimary ms-fontWeight-bold” } }, { “elmType”: “div”, “txtContent”: “=getDate(@currentField)”, “style”: { “display”: “flex”, “justify-content”: “center”, “align-items”: “center”, “width”: “48px”, “border”: “1px solid”, “height”: “30px” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-borderColor-themePrimary ms-fontWeight-bold ms-fontSize-20” } } ] } Read More
Is there any way to read ambient light values from android or iPhone to matlab?
Unfortunately Android and iPhone support package does’t do this and I need to read the lux values from Ambient light sensor to Matlab in realtime.Unfortunately Android and iPhone support package does’t do this and I need to read the lux values from Ambient light sensor to Matlab in realtime. Unfortunately Android and iPhone support package does’t do this and I need to read the lux values from Ambient light sensor to Matlab in realtime. android, sensor, iphone, light sensor, ios MATLAB Answers — New Questions
