Category: News
Unable to access Meeting Recordings
Hi, realising that we missed the deadline to migrate videos from Stream Classic to Stream sharepoint. I see where some videos were selectively migrated however some in a specifiy period has not been, is there any way to still access these recordings to be able to do the migration before the complete shutdown of the platform?
Hi, realising that we missed the deadline to migrate videos from Stream Classic to Stream sharepoint. I see where some videos were selectively migrated however some in a specifiy period has not been, is there any way to still access these recordings to be able to do the migration before the complete shutdown of the platform? Read More
How do I configure MATLAB Parallel Server using a 3rd party scheduler to work within a firewall?
I am installing MATLAB Parallel Server and Parallel Computing Toolbox. I plan to use a 3rd party scheduler instead of MATLAB Job Scheduler. My network has a firewall, and I would like to know which ports need to be opened. I am installing MATLAB Parallel Server and Parallel Computing Toolbox. I plan to use a 3rd party scheduler instead of MATLAB Job Scheduler. My network has a firewall, and I would like to know which ports need to be opened. I am installing MATLAB Parallel Server and Parallel Computing Toolbox. I plan to use a 3rd party scheduler instead of MATLAB Job Scheduler. My network has a firewall, and I would like to know which ports need to be opened. MATLAB Answers — New Questions
Can’t change channel name
Hi. I made a new channel within my organization’s Teams and deleted it because I needed to make it a public channel rather than private. I tried to create it a second time as a public channel, but I got an error. The error seems to specifically be with the name, because I was able to create a public “Test” channel and replicated the error when I deleted that channel and tried to make it again or change the name of “Test1” to just “Test.” I can change it to other things, but not the two names I’ve used and deleted.
I’ve searched SharePoint’s recycle bin and cleared out app data from Teams but am still having the issue. It says “We ran into a problem editing your channel.” Please let me know if I can fix this somehow.
Hi. I made a new channel within my organization’s Teams and deleted it because I needed to make it a public channel rather than private. I tried to create it a second time as a public channel, but I got an error. The error seems to specifically be with the name, because I was able to create a public “Test” channel and replicated the error when I deleted that channel and tried to make it again or change the name of “Test1” to just “Test.” I can change it to other things, but not the two names I’ve used and deleted. I’ve searched SharePoint’s recycle bin and cleared out app data from Teams but am still having the issue. It says “We ran into a problem editing your channel.” Please let me know if I can fix this somehow. Read More
Plot of the Rossler Attractor
I have made an m-file to plot the Rossler Attractor using the equations and a fourth order Runge Kutta methid but the plot lines are very pointed and do not appear smooth, has anyone any suggestions about how i can create a better Attractor? step size, h, used was 0.175. The plot of the Attractor can be found below, thank you.I have made an m-file to plot the Rossler Attractor using the equations and a fourth order Runge Kutta methid but the plot lines are very pointed and do not appear smooth, has anyone any suggestions about how i can create a better Attractor? step size, h, used was 0.175. The plot of the Attractor can be found below, thank you. I have made an m-file to plot the Rossler Attractor using the equations and a fourth order Runge Kutta methid but the plot lines are very pointed and do not appear smooth, has anyone any suggestions about how i can create a better Attractor? step size, h, used was 0.175. The plot of the Attractor can be found below, thank you. rossler equations, rossler attractor, smooth plot line MATLAB Answers — New Questions
Teams Notification when Outlook Email Sent
Hello,
I am looking for a way to send a teams alert to a recipient when that recipient receives an email from a specific sender. Is there any way to do this? I’ve looked at Outlook rules and found nothing but I could’ve missed something.
Thanks
Hello, I am looking for a way to send a teams alert to a recipient when that recipient receives an email from a specific sender. Is there any way to do this? I’ve looked at Outlook rules and found nothing but I could’ve missed something. Thanks Read More
HDL-Coder Delay Balancing in Feedback-Loop workaround
Hi,
I am trying to generate HDL-Code from a Subsystem that looks like this:
Inside Subsystem 2 and 3 there is some combinatorial logic with multipliers, adders etc. that need Delay-Balancing and Pipelining to achieve the desired Clock-Frequency.
Unfortunately hdlcoder refuses to perform delay-balancing and pipelining. It tells me:
"Delay balancing unsuccessful because Delay introduced in feedback loop cannot be path balanced"
"Unable to insert required number of pipeline registers because the Block is in a feedback path"
Is there a way to perform these optimizations in Subsystem 2 and 3 as if there was no Feedback-Loop involved?
Kind regards
NiklasHi,
I am trying to generate HDL-Code from a Subsystem that looks like this:
Inside Subsystem 2 and 3 there is some combinatorial logic with multipliers, adders etc. that need Delay-Balancing and Pipelining to achieve the desired Clock-Frequency.
Unfortunately hdlcoder refuses to perform delay-balancing and pipelining. It tells me:
"Delay balancing unsuccessful because Delay introduced in feedback loop cannot be path balanced"
"Unable to insert required number of pipeline registers because the Block is in a feedback path"
Is there a way to perform these optimizations in Subsystem 2 and 3 as if there was no Feedback-Loop involved?
Kind regards
Niklas Hi,
I am trying to generate HDL-Code from a Subsystem that looks like this:
Inside Subsystem 2 and 3 there is some combinatorial logic with multipliers, adders etc. that need Delay-Balancing and Pipelining to achieve the desired Clock-Frequency.
Unfortunately hdlcoder refuses to perform delay-balancing and pipelining. It tells me:
"Delay balancing unsuccessful because Delay introduced in feedback loop cannot be path balanced"
"Unable to insert required number of pipeline registers because the Block is in a feedback path"
Is there a way to perform these optimizations in Subsystem 2 and 3 as if there was no Feedback-Loop involved?
Kind regards
Niklas hdlcoder, pipelining, feedback, delay balancing MATLAB Answers — New Questions
New Blog | Meet us at Identiverse: May 28-31 in Las Vegas
The annual Identiverse conference is a great opportunity to meet with our community, immerse in the latest challenges and innovations, and hear from leaders in the identity industry. And it’s happening soon! Identiverse 2024 is taking place from May 28 to 31 in Las Vegas, Nevada at ARIA Resort & Casino.
By attending, you’ll be among the first to hear about what’s new with Microsoft Entra, our work in identity standards, and how it will help you navigate the constantly evolving identity and network access threat landscape.
Plus, you can request a 1:1 meeting with a Microsoft identity expert and drop by Booth #2423 in the expo hall to ask questions and see the latest demos of identity solutions and Microsoft Copilot for Security.
Featured Microsoft sessions at Identiverse
We’ve got a powerhouse lineup of topics showcasing our latest innovations to help you get the most from Microsoft Entra.
During our session, Secure access for any trustworthy identity, anywhere, to anything, on Wednesday, May 29 at 2:00 PM, we’ll update you on Microsoft’s progress to enabling the trust fabric, our vision for how organizations can secure every digital interaction from today into the future. Understanding that a Zero Trust approach to identity security is an ongoing journey, we’ll talk about four focus areas to consider and prioritize, including strengthening your identity foundation, securing access for your workforce and external identities, and securing access in multicloud.
Read the full post here: Meet us at Identiverse: May 28-31 in Las Vegas
By Nichole Peterson (SHE/HER)
The annual Identiverse conference is a great opportunity to meet with our community, immerse in the latest challenges and innovations, and hear from leaders in the identity industry. And it’s happening soon! Identiverse 2024 is taking place from May 28 to 31 in Las Vegas, Nevada at ARIA Resort & Casino.
By attending, you’ll be among the first to hear about what’s new with Microsoft Entra, our work in identity standards, and how it will help you navigate the constantly evolving identity and network access threat landscape.
Plus, you can request a 1:1 meeting with a Microsoft identity expert and drop by Booth #2423 in the expo hall to ask questions and see the latest demos of identity solutions and Microsoft Copilot for Security.
Featured Microsoft sessions at Identiverse
We’ve got a powerhouse lineup of topics showcasing our latest innovations to help you get the most from Microsoft Entra.
During our session, Secure access for any trustworthy identity, anywhere, to anything, on Wednesday, May 29 at 2:00 PM, we’ll update you on Microsoft’s progress to enabling the trust fabric, our vision for how organizations can secure every digital interaction from today into the future. Understanding that a Zero Trust approach to identity security is an ongoing journey, we’ll talk about four focus areas to consider and prioritize, including strengthening your identity foundation, securing access for your workforce and external identities, and securing access in multicloud.
Read the full post here: Meet us at Identiverse: May 28-31 in Las Vegas
How do I create lagged data correctly?
I have these codes so far to try to create lags but for some reason my lagged data and normal data shows same thing. What could be the problem?
Cyclicalitydata = readtable("Could be final data set.xlsx");
Countrydata = Cyclicalitydata(strcmp(Cyclicalitydata.Country, ‘Hungary’), :);
% Prepare variables
Fiscalvariable = Countrydata.CAPB1; % Dependent variable, original series
LaggedFiscalvariable = [NaN; Fiscalvariable(1:end-1)]; % Creating one-period lag
Economicactivity = Countrydata.Outputgap; % Independent main variable
Govsize = Countrydata.Govsize; % Control variable 1
Debtp = Countrydata.DebtGDP; % Control variable 2
CPIlevel = Countrydata.CPIlevel; % Additional control variable 3
Years = Countrydata.Year; % Year for plotting and analysis
CPIgrowth = [NaN; CPIlevel(1:end-1)];I have these codes so far to try to create lags but for some reason my lagged data and normal data shows same thing. What could be the problem?
Cyclicalitydata = readtable("Could be final data set.xlsx");
Countrydata = Cyclicalitydata(strcmp(Cyclicalitydata.Country, ‘Hungary’), :);
% Prepare variables
Fiscalvariable = Countrydata.CAPB1; % Dependent variable, original series
LaggedFiscalvariable = [NaN; Fiscalvariable(1:end-1)]; % Creating one-period lag
Economicactivity = Countrydata.Outputgap; % Independent main variable
Govsize = Countrydata.Govsize; % Control variable 1
Debtp = Countrydata.DebtGDP; % Control variable 2
CPIlevel = Countrydata.CPIlevel; % Additional control variable 3
Years = Countrydata.Year; % Year for plotting and analysis
CPIgrowth = [NaN; CPIlevel(1:end-1)]; I have these codes so far to try to create lags but for some reason my lagged data and normal data shows same thing. What could be the problem?
Cyclicalitydata = readtable("Could be final data set.xlsx");
Countrydata = Cyclicalitydata(strcmp(Cyclicalitydata.Country, ‘Hungary’), :);
% Prepare variables
Fiscalvariable = Countrydata.CAPB1; % Dependent variable, original series
LaggedFiscalvariable = [NaN; Fiscalvariable(1:end-1)]; % Creating one-period lag
Economicactivity = Countrydata.Outputgap; % Independent main variable
Govsize = Countrydata.Govsize; % Control variable 1
Debtp = Countrydata.DebtGDP; % Control variable 2
CPIlevel = Countrydata.CPIlevel; % Additional control variable 3
Years = Countrydata.Year; % Year for plotting and analysis
CPIgrowth = [NaN; CPIlevel(1:end-1)]; lagged data, code MATLAB Answers — New Questions
Changes in how MFA frequency is Determined?
Recently a couple of my users began reporting a significant increase in the frequency in which they are required to re-authenticate. When prompted for ‘Stay Signed In’, they respond ‘yes’. Despite this, they are being asked to sign-in much more frequently than our policy states.
I don’t believe we have changed any relevant policy parameters, and so has anything changed in how sign-in frequency is determined?
Recently a couple of my users began reporting a significant increase in the frequency in which they are required to re-authenticate. When prompted for ‘Stay Signed In’, they respond ‘yes’. Despite this, they are being asked to sign-in much more frequently than our policy states. I don’t believe we have changed any relevant policy parameters, and so has anything changed in how sign-in frequency is determined? Read More
About what’s new with Postgres at Microsoft, 2024 edition
Just published this brand new blog post to share highlights of all the Azure & the open source work done by the Postgres team at Microsoft over the last 8 months. The title: What’s new with Postgres at Microsoft, 2024 edition.
The post contains a detailed infographic (handmade) that gives you a visual outline of all the different Postgres workstreams our engineering & PM teams have been driving.
And because the Postgres 17 code freeze just happened last month, I included highlights from some of the new PG17 capabilities our Postgres contributor team worked on as well.
If you’re an Azure Database for PostgreSQL – Flexible Server customer, you won’t be disappointed. Lots of new features rolled out in the last 8 months.
Just published this brand new blog post to share highlights of all the Azure & the open source work done by the Postgres team at Microsoft over the last 8 months. The title: What’s new with Postgres at Microsoft, 2024 edition. The post contains a detailed infographic (handmade) that gives you a visual outline of all the different Postgres workstreams our engineering & PM teams have been driving. And because the Postgres 17 code freeze just happened last month, I included highlights from some of the new PG17 capabilities our Postgres contributor team worked on as well. If you’re an Azure Database for PostgreSQL – Flexible Server customer, you won’t be disappointed. Lots of new features rolled out in the last 8 months. Read More
Help creating a training matrix! Please
Hi everyone,
I hope someone can help me out.
I’m wanting to creat a spreadsheet that acts as a training matrix, for the staff in my team.
What I would like to do is list what training staff have undertaken – when they finished the course and when the qualification expires.
However! I’d love to be able to have the cells change colour depending on how much time they have left before that qualification expires.
For example, if a qualification expires in a month then cell turns orange.
Or if there is over 6 months before it expires, the cell stays green.
So essentially the cell changes according to how much time you have left.
Hopefully that makes sense.
Does anyone have any smart ideas or suggestions?
Many, many thanks in advance!!
Hi everyone, I hope someone can help me out.I’m wanting to creat a spreadsheet that acts as a training matrix, for the staff in my team. What I would like to do is list what training staff have undertaken – when they finished the course and when the qualification expires. However! I’d love to be able to have the cells change colour depending on how much time they have left before that qualification expires. For example, if a qualification expires in a month then cell turns orange.Or if there is over 6 months before it expires, the cell stays green.So essentially the cell changes according to how much time you have left. Hopefully that makes sense.Does anyone have any smart ideas or suggestions? Many, many thanks in advance!! Read More
New Teams on Mac – Blank/Black Text
Sometimes, when opening teams, all text is either blank (non-existent) or shows up as black boxes.
Version below:
Sometimes, when opening teams, all text is either blank (non-existent) or shows up as black boxes. Version below: Read More
Need formula for help Excel
Same data in different columns has to be come to one column against the cell
Please find the example in attachment
Same data in different columns has to be come to one column against the cellPlease find the example in attachment Read More
table set up for mail merge
Hello,
Bottom Line Up Front:
I am attempting to set up an Excel sheet to use as the Merge Fields for a mail merge.
Background:
I have over 2300 supervisors at varying levels of experience that need the appropriate level of training. I pull a report from our data bank and save as an Excel sheet. From this data, i am trying to mine the length of time the supervisor has been in their position – Based on their start date and send the notifications accordingly.
First, I added a column for length of years and used this formula =DAYS(NOW(),F2)/365 and moved the decimal down to 2, e.g., “0.12”, to help me see if they are in the ranges i need; e.g., less than 1 year, between first and third year, and then the three and over years of experience. – this formula works fine.
Next, to initiate a mail merge to send mass invitations to the different training levels required by their experience, i added another column as “Subject” and used this formula
=IF(H2<1,”Priority”,IF(H2=1.1>=2.9,”CatchUp”,IF(H2>3,”Refresher”)))
the “Priority” and “CatchUp” work as i have hoped; however, the 1st Challenge – the “Refresher” does not ( i get no “Refresher” results). To further this challenge, i later discovered some people are on probation and some are not (because they previously held a supervisory position and did not need to redo it, yet they are in a new supervisory position) – so challenge #2 is to fix the above subject formula to include if there is a date in the Probation column to make this a “Priority” // also, if it does not have a date, to make this a “Catch Up”. #3 once i get these formulas fixed, is it possible to change the formatting to highlight Priority as Red, CatchUp as Orange, and Refresher as light green?
The next phase of the mail merge is to establish a body column – which i have not even attempted yet… Nevertheless, i am hoping that as the Subject Column is corrected that a NEW column of “Body” will reflect accordingly with:
“Priority = You are identified in HR Smart as a New Supervisor still on probation; Please, see the attachment to register. ” for
“CatchUp = You are identified in HR Smart as a Supervisor within your first and second years of experience; Please, see the attachment to register.” and finally, for
“Refresher = You are identified in HR Smart as a Seasoned Supervisor; Please, see the attachment to register.”
Can you help me fix/establish the formulas Please, so that i can then continue building the Mail Merge portion?
here is a screen shot to help you visualize this challenge:
Thank you in advance for even offering to help me.
v/r,
dave
Hello, Bottom Line Up Front:I am attempting to set up an Excel sheet to use as the Merge Fields for a mail merge. Background:I have over 2300 supervisors at varying levels of experience that need the appropriate level of training. I pull a report from our data bank and save as an Excel sheet. From this data, i am trying to mine the length of time the supervisor has been in their position – Based on their start date and send the notifications accordingly. First, I added a column for length of years and used this formula =DAYS(NOW(),F2)/365 and moved the decimal down to 2, e.g., “0.12”, to help me see if they are in the ranges i need; e.g., less than 1 year, between first and third year, and then the three and over years of experience. – this formula works fine. Next, to initiate a mail merge to send mass invitations to the different training levels required by their experience, i added another column as “Subject” and used this formula =IF(H2<1,”Priority”,IF(H2=1.1>=2.9,”CatchUp”,IF(H2>3,”Refresher”)))the “Priority” and “CatchUp” work as i have hoped; however, the 1st Challenge – the “Refresher” does not ( i get no “Refresher” results). To further this challenge, i later discovered some people are on probation and some are not (because they previously held a supervisory position and did not need to redo it, yet they are in a new supervisory position) – so challenge #2 is to fix the above subject formula to include if there is a date in the Probation column to make this a “Priority” // also, if it does not have a date, to make this a “Catch Up”. #3 once i get these formulas fixed, is it possible to change the formatting to highlight Priority as Red, CatchUp as Orange, and Refresher as light green? The next phase of the mail merge is to establish a body column – which i have not even attempted yet… Nevertheless, i am hoping that as the Subject Column is corrected that a NEW column of “Body” will reflect accordingly with:”Priority = You are identified in HR Smart as a New Supervisor still on probation; Please, see the attachment to register. ” for”CatchUp = You are identified in HR Smart as a Supervisor within your first and second years of experience; Please, see the attachment to register.” and finally, for”Refresher = You are identified in HR Smart as a Seasoned Supervisor; Please, see the attachment to register.” Can you help me fix/establish the formulas Please, so that i can then continue building the Mail Merge portion?here is a screen shot to help you visualize this challenge: Thank you in advance for even offering to help me.v/r,dave Read More
Behind the Scenes: Meet Brett Humphrey, Principal Product Manager and Advocate for Accessibility
Hi Microsoft 365 Insiders!
Behind every great innovation at Microsoft, there’s a story of passion and purpose. Meet Brett Humphrey, a principal product manager whose 25-year journey has been driven by a commitment to accessibility.
As we approach Global Accessibility Awareness Day, Brett shares his personal and professional milestones that underscore the importance of inclusive technology. From his mother’s influence to his own experiences with low vision, Brett’s narrative is a powerful reminder of why accessibility matters.
“Accessibility isn’t just about the number of people impacted; it’s about access,” Brett asserts. His work on Microsoft Teams’ design principles—efficiency, predictability, and clarity—reflects a deep understanding of the challenges faced by people with disabilities.
Join us in celebrating Brett’s contributions and the ongoing mission to close the digital divide in our latest blog: Behind the Scenes: Meet Brett Humphrey, Principal Product Manager and Advocate for Accessibility
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi Microsoft 365 Insiders!
Behind every great innovation at Microsoft, there’s a story of passion and purpose. Meet Brett Humphrey, a principal product manager whose 25-year journey has been driven by a commitment to accessibility.
As we approach Global Accessibility Awareness Day, Brett shares his personal and professional milestones that underscore the importance of inclusive technology. From his mother’s influence to his own experiences with low vision, Brett’s narrative is a powerful reminder of why accessibility matters.
“Accessibility isn’t just about the number of people impacted; it’s about access,” Brett asserts. His work on Microsoft Teams’ design principles—efficiency, predictability, and clarity—reflects a deep understanding of the challenges faced by people with disabilities.
Join us in celebrating Brett’s contributions and the ongoing mission to close the digital divide in our latest blog: Behind the Scenes: Meet Brett Humphrey, Principal Product Manager and Advocate for Accessibility
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Read More
Subtractive Baseline-correction
Hello All,
Im trying to do a subtractive baseline correction on pupil data. I wrote the skript already but when i plot the data, it seems like the baseline correction did not work. The graphs do not all start from the same point. Any ideas of what i could´ve done wrong?
Thank you in advance
%Verzeichnis
Verzeichnis = ‘/Users/eliebonin/Documents/MATLAB/edf_daten_elie/Datensatz eye tracking’;
%Daten laden
load(‘testmat3.mat’)
%Überprüfen der Größe der Matrix
[proben_anzahl, ~] = size (testmat3);
%Sicherstellen, dass die Anzahl der Proben größer oder gleich 10 ist
if proben_anzahl < 10
error (‘Es gibt nicht genügend Proben für Baseline correction’);
end
%Definieren des Zeitbereiches für die Baseline
baseline_zeitraum = 1:10; %Annahme: Die ersten zehn Samples entgsprechen dem Baseline-Zeitraum
%Berechnen des Mittelwerts während des baseline Zeitraums für jede Probe
baseline_groesse = mean(testmat3(:,baseline_zeitraum), 2);
%substraktion des Baseline-Mittelwerts von allen Pupillengrößen für jede
%Probe
baseline_corrected_daten = testmat3 – baseline_groesse;
save(‘baseline_correction.mat’, ‘baseline_corrected_daten’);Hello All,
Im trying to do a subtractive baseline correction on pupil data. I wrote the skript already but when i plot the data, it seems like the baseline correction did not work. The graphs do not all start from the same point. Any ideas of what i could´ve done wrong?
Thank you in advance
%Verzeichnis
Verzeichnis = ‘/Users/eliebonin/Documents/MATLAB/edf_daten_elie/Datensatz eye tracking’;
%Daten laden
load(‘testmat3.mat’)
%Überprüfen der Größe der Matrix
[proben_anzahl, ~] = size (testmat3);
%Sicherstellen, dass die Anzahl der Proben größer oder gleich 10 ist
if proben_anzahl < 10
error (‘Es gibt nicht genügend Proben für Baseline correction’);
end
%Definieren des Zeitbereiches für die Baseline
baseline_zeitraum = 1:10; %Annahme: Die ersten zehn Samples entgsprechen dem Baseline-Zeitraum
%Berechnen des Mittelwerts während des baseline Zeitraums für jede Probe
baseline_groesse = mean(testmat3(:,baseline_zeitraum), 2);
%substraktion des Baseline-Mittelwerts von allen Pupillengrößen für jede
%Probe
baseline_corrected_daten = testmat3 – baseline_groesse;
save(‘baseline_correction.mat’, ‘baseline_corrected_daten’); Hello All,
Im trying to do a subtractive baseline correction on pupil data. I wrote the skript already but when i plot the data, it seems like the baseline correction did not work. The graphs do not all start from the same point. Any ideas of what i could´ve done wrong?
Thank you in advance
%Verzeichnis
Verzeichnis = ‘/Users/eliebonin/Documents/MATLAB/edf_daten_elie/Datensatz eye tracking’;
%Daten laden
load(‘testmat3.mat’)
%Überprüfen der Größe der Matrix
[proben_anzahl, ~] = size (testmat3);
%Sicherstellen, dass die Anzahl der Proben größer oder gleich 10 ist
if proben_anzahl < 10
error (‘Es gibt nicht genügend Proben für Baseline correction’);
end
%Definieren des Zeitbereiches für die Baseline
baseline_zeitraum = 1:10; %Annahme: Die ersten zehn Samples entgsprechen dem Baseline-Zeitraum
%Berechnen des Mittelwerts während des baseline Zeitraums für jede Probe
baseline_groesse = mean(testmat3(:,baseline_zeitraum), 2);
%substraktion des Baseline-Mittelwerts von allen Pupillengrößen für jede
%Probe
baseline_corrected_daten = testmat3 – baseline_groesse;
save(‘baseline_correction.mat’, ‘baseline_corrected_daten’); matlab, pupil data, preprocessing MATLAB Answers — New Questions
Using DATEDIF doesn’t include first day (Calculating vacation days)
I have a SharePoint list generated by PowerAutomate to keep track of employee time off requests. I’m using two text columns called StartDate and EndDate. The column values look like 05/14/2024 00:00:00
I want a column to calculate how many days a person has taken off, minus weekends. A web search brought me to a Stack Overflow post from ten years ago that actually worked relatively well – I do not know what this means (is “FLOOR” relevant?).
=DATEDIF(StartDate,EndDate,”D”)-IF(WEEKDAY(EndDate)=7,FLOOR((DATEDIF(StartDate,EndDate,”D”)+WEEKDAY(StartDate))/7,1)*2,FLOOR((DATEDIF(StartDate,EndDate,”D”)+WEEKDAY(StartDate))/7,1)*2+1)+IF(WEEKDAY(StartDate)=7,2,1)
The issue is that, for example, if StartDate=05/30/2024 00:00:00 and EndDate=06/04/2024 00:00:00, the column is generating three days instead of four.
Similarly, if one day is taken off (05/14/2024 00:00:00-05/14/2024 00:00:00), it’s appearing as 0 instead of 1.
Theoretically, I could have PowerAutomate fudge the data but I want the calculate column to rely on the StartDate and EndDate columns in case they’re ever manually edited. And, although I’m not sure how, I could theoretically just add “1” to the column but I imagine there may be occasions that could be incorrect (ie., if someone mistakenly enters their vacation starting on a Sunday).
Bonus: How could I add this condition to the formula? IF value of column Approved is “Reject”, then 0.
I have a SharePoint list generated by PowerAutomate to keep track of employee time off requests. I’m using two text columns called StartDate and EndDate. The column values look like 05/14/2024 00:00:00 I want a column to calculate how many days a person has taken off, minus weekends. A web search brought me to a Stack Overflow post from ten years ago that actually worked relatively well – I do not know what this means (is “FLOOR” relevant?). =DATEDIF(StartDate,EndDate,”D”)-IF(WEEKDAY(EndDate)=7,FLOOR((DATEDIF(StartDate,EndDate,”D”)+WEEKDAY(StartDate))/7,1)*2,FLOOR((DATEDIF(StartDate,EndDate,”D”)+WEEKDAY(StartDate))/7,1)*2+1)+IF(WEEKDAY(StartDate)=7,2,1) The issue is that, for example, if StartDate=05/30/2024 00:00:00 and EndDate=06/04/2024 00:00:00, the column is generating three days instead of four. Similarly, if one day is taken off (05/14/2024 00:00:00-05/14/2024 00:00:00), it’s appearing as 0 instead of 1. Theoretically, I could have PowerAutomate fudge the data but I want the calculate column to rely on the StartDate and EndDate columns in case they’re ever manually edited. And, although I’m not sure how, I could theoretically just add “1” to the column but I imagine there may be occasions that could be incorrect (ie., if someone mistakenly enters their vacation starting on a Sunday). Bonus: How could I add this condition to the formula? IF value of column Approved is “Reject”, then 0. Read More
Why am I getting an “undefined function or variable” error when trying to launch EEGLAB?
I am trying to open the EEGLAB toolbox. I set the path to the EEGLAB toolbox, but it’s not letting me set the directory to the file with EEGLAB sample data, and when I type in "eeglab" to the command window, instead of opening the program it says "undefined function or variable". Why is this happening? I’m following all the tutorial steps.I am trying to open the EEGLAB toolbox. I set the path to the EEGLAB toolbox, but it’s not letting me set the directory to the file with EEGLAB sample data, and when I type in "eeglab" to the command window, instead of opening the program it says "undefined function or variable". Why is this happening? I’m following all the tutorial steps. I am trying to open the EEGLAB toolbox. I set the path to the EEGLAB toolbox, but it’s not letting me set the directory to the file with EEGLAB sample data, and when I type in "eeglab" to the command window, instead of opening the program it says "undefined function or variable". Why is this happening? I’m following all the tutorial steps. eeglab, error, unix MATLAB Answers — New Questions
Excel data
Hello,
I am not extremely advanced when it comes to using excel.
I have a table that lists all of our land owners and their corresponding field names.
I made another sheet with a data validation for the land owners and what I am hoping I can accomplish is when I select a land owner from the drop down then below that it will populate all the different fields associated with that specific land owner and the acres. I can’t seem to find a formula that does this.
Any help would be greatly appreciated!
Thanks
Hello, I am not extremely advanced when it comes to using excel. I have a table that lists all of our land owners and their corresponding field names. I made another sheet with a data validation for the land owners and what I am hoping I can accomplish is when I select a land owner from the drop down then below that it will populate all the different fields associated with that specific land owner and the acres. I can’t seem to find a formula that does this. Any help would be greatly appreciated! Thanks Read More
Video Labeler change time between frames
I am using the videolabeler to annotate timelapse videos taken with a microscope, is there any where I can change the start and end time, as well as the time between frames?
It seems like this is preset and I could not find anywhere to change it.
Thanks!I am using the videolabeler to annotate timelapse videos taken with a microscope, is there any where I can change the start and end time, as well as the time between frames?
It seems like this is preset and I could not find anywhere to change it.
Thanks! I am using the videolabeler to annotate timelapse videos taken with a microscope, is there any where I can change the start and end time, as well as the time between frames?
It seems like this is preset and I could not find anywhere to change it.
Thanks! videolabler, annotation, videos MATLAB Answers — New Questions