Category: News
Excel Online…How to clear multiple cells across multiple tabs
I have been searching but unable to find an answer or solution
I am new to all this Macro and Scripting stuff in Excel. But I have a Workbook that I was able to create a Macro to clear multiple cells across multiple sheets. All proud until I put in on our sharepoint just to find Excel Online doesn’t support macros.
Below is what I have going. Is there a way to be able to clear this data using the book in excel online. I have seen references to Automate and Inserting buttons but I am not finding anything on my end. Any help would be greatly appreciated.
Sub Button1_Click()
response = MsgBox(“Are You Sure you want to clear data?”, vbYesNo)
If response = vbNo Then
MsgBox (“Macro Ending”)
Exit Sub
End If
Sheets(“AUS”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“DAL”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“HOU”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“NOR”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“OKC”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“PHX”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“SAN”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“STL”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“WAC”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
End Sub
I have been searching but unable to find an answer or solution I am new to all this Macro and Scripting stuff in Excel. But I have a Workbook that I was able to create a Macro to clear multiple cells across multiple sheets. All proud until I put in on our sharepoint just to find Excel Online doesn’t support macros. Below is what I have going. Is there a way to be able to clear this data using the book in excel online. I have seen references to Automate and Inserting buttons but I am not finding anything on my end. Any help would be greatly appreciated. Sub Button1_Click()
response = MsgBox(“Are You Sure you want to clear data?”, vbYesNo)
If response = vbNo Then
MsgBox (“Macro Ending”)
Exit Sub
End If
Sheets(“AUS”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“DAL”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“HOU”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“NOR”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“OKC”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“PHX”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“SAN”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“STL”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
Sheets(“WAC”).Range(“B11:I16,B19:I24,B27:I32,B3:I8”).ClearContents
End Sub Read More
Is there a way to “Mute Member for me” in meetings
Sometimes I am in the office, and usually with my colleagues have to meeting being together in the same office and the same session. So, the people in the office hear the voice and then the reverb of the specialist who is talking.
So would be great if, like “Pin for me” functionality, I could “Mute for me” a collaborator.
Thanks in advance to everyone.
Best regards!
Sometimes I am in the office, and usually with my colleagues have to meeting being together in the same office and the same session. So, the people in the office hear the voice and then the reverb of the specialist who is talking.So would be great if, like “Pin for me” functionality, I could “Mute for me” a collaborator. Thanks in advance to everyone.Best regards! Read More
NEW 1-Day ILT coming end of May and Copilot course end of June
Note: Please click on image to view full-size. Thank you
Note: Please click on image to view full-size. Thank you Read More
How AI and digital transformation are driving inclusion, productivity, and accessibility
Technology and artificial intelligence are not only transforming various industries, but also creating new opportunities for inclusion and empowerment for people with disabilities. According to the World Health Organization, more than one billion people live with some form of disability, and they often face barriers to access information, education, employment, health care, and social services. Technology can play a vital role in bridging these gaps and enhancing the quality of life for people with disabilities. In particular AI can offer innovative solutions to overcome some of the challenges and limitations that people with disabilities face in their daily lives. Therefore, it is important to involve people with disabilities in the design, development, and evaluation of AI applications, and to ensure that AI is aligned with the principles of human rights, dignity, and diversity.
Technology and AI can help people with disabilities in various ways, such as:
Assistive technology: Providing AI-powered tools such as speech recognition, text-to-speech, computer vision, and natural language processing.
Access to learning: Enabling accessible and personalized learning experiences that can adapt to the needs and preferences of learners with disabilities, such as adaptive curriculum, interactive feedback, and gamification.
Communication tools: Facilitating better communications through tools such as chatbots, digital assistants, online platforms, and smart devices that can help empower people socially and on the job.
In our work at Microsoft, we have the honor of partnering with a variety of nonprofit organizations where technology and AI innovations are helping drive inclusion and productivity for those with disabilities.
Special Olympics International (SOI) is leveraging technology to help empower athletes. To build a digital athlete registration portal as part of its new Center of Excellence, the SOI technology team examined how SOI athletes and SOI employees with intellectual and developmental disabilities navigated different websites and external registration systems. To help athletes and employees register independently, the SOI team took the observations and feedback from their focus groups into consideration when creating a streamlined athlete registration portal and designed it to be easy to navigate. Simple adjustments such as reducing the options to click away, asking only one question at a time, gamifying the process by awarding medals for completing portions of the registration, and making it screen-reader compatible are helping ensure a more inclusive, productive experience for athletes to self-register and partake in the competition, community and fun.
Goodwill Industries of Orange County and its e-commerce platform Shopgoodwill.com are serving their communities by empowering people who want to work, no matter their station in life. Whether they’re a veteran returning to the workforce, a person with a mental health diagnosis, or someone with a physical or intellectual disability, Goodwill will help them find employment.
The Shopgoodwill.com e-commerce platform is using AI as a productivity tool for the process of photographing, identifying, and cataloging items to be sold on their website. Employees use smart devices with custom vision to capture imagery and classify the item, which then uses computer vision to extract information from elements such as the material label and merchandise tags that get fed into a large language model that helps catalog the item and ready it for sale. For employees with disabilities, this type of AI functionality is transformative. It can make the actual day-to-day of the job easier, expand the number of people who are able to fill these types of roles, and help drive increased revenue to fund the program.
Further recognizing the power or AI, Goodwill’s workforce development teams are in the beginning stages of leveraging AI to more accurately work with their employment program participants to put them into scenarios and working environments that will help them achieve their best by optimizing past performance capabilities with available jobs and pairing individuals with the right opportunities.
Digital technology and AI can create more inclusive and accessible solutions that can empower people with disabilities to achieve their goals and aspirations. We are proud to work with and support nonprofit organizations with technology that enables greater accessibility to help create a more inclusive and equitable world.
Learn more
For more information about Microsoft responsible AI principles, read more here: Empowering responsible AI practices | Microsoft AI. If you are interested in making your content more inclusive and user-friendly with Microsoft Accessibility tools, we have a variety of resources available.
Continue the conversation by joining us in the Nonprofit Community! Want to share best practices or join community events? Become a member by “Joining” the Nonprofit Community. To stay up to date on the latest nonprofit news, make sure to Follow or Subscribe to the Nonprofit Community Blog space!
Microsoft Tech Community – Latest Blogs –Read More
How to write this function in Matlab having inner product
Here,
inner product is defined as <u,v>=
Is this is correct?
function F_val = F(wi, ci, Li, K, e, sigma, zi)
% Compute the first term: K <e sum from i to N ci Li, e sum from i to N ci Li>
term1 = K * e^2 * sum(exp(sum(ci .* Li)) .* exp(sum(ci .* Li)));
% Compute the second term: K <e sum from i to N ci Li, -2 sigma>
term2 = K * e * sum(exp(sum(ci .* Li)) * (-2 * sigma));
% Compute the third term: summation i to N e ci <e^wi, wi>
term3 = e * sum(zi .* ci .* exp(wi));
% Compute the final result: F(w) = term1 + term2 + term3
F_val = term1 + term2 + term3;
endHere,
inner product is defined as <u,v>=
Is this is correct?
function F_val = F(wi, ci, Li, K, e, sigma, zi)
% Compute the first term: K <e sum from i to N ci Li, e sum from i to N ci Li>
term1 = K * e^2 * sum(exp(sum(ci .* Li)) .* exp(sum(ci .* Li)));
% Compute the second term: K <e sum from i to N ci Li, -2 sigma>
term2 = K * e * sum(exp(sum(ci .* Li)) * (-2 * sigma));
% Compute the third term: summation i to N e ci <e^wi, wi>
term3 = e * sum(zi .* ci .* exp(wi));
% Compute the final result: F(w) = term1 + term2 + term3
F_val = term1 + term2 + term3;
end Here,
inner product is defined as <u,v>=
Is this is correct?
function F_val = F(wi, ci, Li, K, e, sigma, zi)
% Compute the first term: K <e sum from i to N ci Li, e sum from i to N ci Li>
term1 = K * e^2 * sum(exp(sum(ci .* Li)) .* exp(sum(ci .* Li)));
% Compute the second term: K <e sum from i to N ci Li, -2 sigma>
term2 = K * e * sum(exp(sum(ci .* Li)) * (-2 * sigma));
% Compute the third term: summation i to N e ci <e^wi, wi>
term3 = e * sum(zi .* ci .* exp(wi));
% Compute the final result: F(w) = term1 + term2 + term3
F_val = term1 + term2 + term3;
end write function with inner product MATLAB Answers — New Questions
how to count a sequence of data arrays with cut off?
i have 5 data in one array. For example, the data array [2.33 2.00 1.60 1.59 1.99]. If the cutoff is 1.50, it means the amount of data is 4 (pay attention to the order of the data). the number 1.99 in the 5th index is not counted.
This is my code
cnr_all=[2.33 2.00 1.60 1.59 1.99];
cut_off=1.50;
N=zeros(size(cnr_all));
for i=1:numel(cnr_all)
if cnr_all[i] >= cut_off;
N=N+1;
break;
end
end
disp(N)i have 5 data in one array. For example, the data array [2.33 2.00 1.60 1.59 1.99]. If the cutoff is 1.50, it means the amount of data is 4 (pay attention to the order of the data). the number 1.99 in the 5th index is not counted.
This is my code
cnr_all=[2.33 2.00 1.60 1.59 1.99];
cut_off=1.50;
N=zeros(size(cnr_all));
for i=1:numel(cnr_all)
if cnr_all[i] >= cut_off;
N=N+1;
break;
end
end
disp(N) i have 5 data in one array. For example, the data array [2.33 2.00 1.60 1.59 1.99]. If the cutoff is 1.50, it means the amount of data is 4 (pay attention to the order of the data). the number 1.99 in the 5th index is not counted.
This is my code
cnr_all=[2.33 2.00 1.60 1.59 1.99];
cut_off=1.50;
N=zeros(size(cnr_all));
for i=1:numel(cnr_all)
if cnr_all[i] >= cut_off;
N=N+1;
break;
end
end
disp(N) loop, if statement, break MATLAB Answers — New Questions
Blank plot on my computer
This is my code and I was wondering why is my figure 6 empty:
https://dontpad.com/labpdsmikiThis is my code and I was wondering why is my figure 6 empty:
https://dontpad.com/labpdsmiki This is my code and I was wondering why is my figure 6 empty:
https://dontpad.com/labpdsmiki graphics MATLAB Answers — New Questions
Problem with StopRecording button
I’m using this code to record my voice, but when the recording is less than 5 seconds, the file played by the function sound is the file recorded before the last one.
This function records the voice when i push the ‘StartRecording’ button:
function StartRecording_Callback(hObject, eventdata, handles)
RecordStatus = get(hObject,’Value’);
runstr=get(hObject,’string’);
if RecordStatus == 1
% start recording
fs = 44100;
obj = audiorecorder(fs, 16, 1);
recordblocking(obj, 5);
y = getaudiodata(obj);
clear obj
save recording.mat y
else
% stop recording
StopRecording(handles);
end
This function is the callback for the function StopRecording:
function StopButton_Callback(hObject, eventdata, handles)
StopRecording(guidata(hObject));
This function saves, plays and plots the audio file:
function StopRecording(handles)
fs = 44100;
load recording y;
[filename, pathname] = uiputfile(‘*.wav’, ‘Save file name’);
cd (pathname);
audiowrite(filename, y, fs);
sound(y,fs);
handles.x = y;
handles.fs = fs;
axes(handles.axes1);
time = 0:1/fs:(length(handles.x)-1)/fs;
plot(time,handles.x);
title(‘Original Signal’);
axes(handles.axes2);
specgram(handles.x, 1024, handles.fs);
title(‘Encrypted Signal’);
I want to record, play and plot the file just created.I’m using this code to record my voice, but when the recording is less than 5 seconds, the file played by the function sound is the file recorded before the last one.
This function records the voice when i push the ‘StartRecording’ button:
function StartRecording_Callback(hObject, eventdata, handles)
RecordStatus = get(hObject,’Value’);
runstr=get(hObject,’string’);
if RecordStatus == 1
% start recording
fs = 44100;
obj = audiorecorder(fs, 16, 1);
recordblocking(obj, 5);
y = getaudiodata(obj);
clear obj
save recording.mat y
else
% stop recording
StopRecording(handles);
end
This function is the callback for the function StopRecording:
function StopButton_Callback(hObject, eventdata, handles)
StopRecording(guidata(hObject));
This function saves, plays and plots the audio file:
function StopRecording(handles)
fs = 44100;
load recording y;
[filename, pathname] = uiputfile(‘*.wav’, ‘Save file name’);
cd (pathname);
audiowrite(filename, y, fs);
sound(y,fs);
handles.x = y;
handles.fs = fs;
axes(handles.axes1);
time = 0:1/fs:(length(handles.x)-1)/fs;
plot(time,handles.x);
title(‘Original Signal’);
axes(handles.axes2);
specgram(handles.x, 1024, handles.fs);
title(‘Encrypted Signal’);
I want to record, play and plot the file just created. I’m using this code to record my voice, but when the recording is less than 5 seconds, the file played by the function sound is the file recorded before the last one.
This function records the voice when i push the ‘StartRecording’ button:
function StartRecording_Callback(hObject, eventdata, handles)
RecordStatus = get(hObject,’Value’);
runstr=get(hObject,’string’);
if RecordStatus == 1
% start recording
fs = 44100;
obj = audiorecorder(fs, 16, 1);
recordblocking(obj, 5);
y = getaudiodata(obj);
clear obj
save recording.mat y
else
% stop recording
StopRecording(handles);
end
This function is the callback for the function StopRecording:
function StopButton_Callback(hObject, eventdata, handles)
StopRecording(guidata(hObject));
This function saves, plays and plots the audio file:
function StopRecording(handles)
fs = 44100;
load recording y;
[filename, pathname] = uiputfile(‘*.wav’, ‘Save file name’);
cd (pathname);
audiowrite(filename, y, fs);
sound(y,fs);
handles.x = y;
handles.fs = fs;
axes(handles.axes1);
time = 0:1/fs:(length(handles.x)-1)/fs;
plot(time,handles.x);
title(‘Original Signal’);
axes(handles.axes2);
specgram(handles.x, 1024, handles.fs);
title(‘Encrypted Signal’);
I want to record, play and plot the file just created. sound, audiowrite, audiorecorder MATLAB Answers — New Questions
Why is my script not detecting changes in UI?
Hi all! I am relatively new to app design in Matlab and I’m trying to design an app for an automated recording set-up. The idea is that users can define metadata in the UI (animal ID, duration of trial, etc.) before starting the session, then start and pause the session as needed, and then monitor the recording from the app while the automation is controlled in a separate matlab script (i.e. the automation is not running on the callbacks). I can get my app to pass information back to the base script using assignin for basic inputs and pass data back to the UI for monitoring like a timer and temperature. However, I can’t figure out how to execute my code only when the user starts the trial. To start with something simple, I have written an UpdateTimer function that updates the timer when called in the main script (I had originally written a timer into the callback but then nothing else can run so now the user will see the timer update everytime something runs in the automation to approximate the time since starting) and I have some dummy temperature data. When the user clicks Start on the UI, I would like the timer and temperature to update every 10 seconds. However, no matter what I try, the script can’t tell when the button has changed. Can anyone help me??
Main Script:
clear all;
close all;
b1_State = ‘NotStarted’; %Initial state of start button
Box1 = TestApp; %Calling UI
%pause(15); %I can pause is for 15seconds and quickly enter everything and then hit start and the following will work, but I don’t want the user to be on a time limit before starting the session
switch b1_State %This was the last thing I tried, I’ve also tried while and if loops with no success either
case ‘Recording’
test = 5;
Box1.Timer_EditField.Value = UpdateTimer(b1_StartTime, b1_PauseTime, b1_Duration, Box1);
Box1.TemperatureCEditField.Value = num2str(25);
pause(10)
Box1.Timer_EditField.Value = UpdateTimer(b1_StartTime, b1_PauseTime, b1_Duration, Box1);
Box1.TemperatureCEditField.Value = num2str(35);
end % Eventually I will specify what happens when the script is paused, but I just wanted to get one case working first
UpdateTimer Script (Note I’m still working on what happens if the user pauses and then continues the recording):
function update = UpdateTimer(StartTime, PauseTime, Duration, Box)
Now = datestr(now, "HH:MM:SS.FFF");
Now_H = str2double(Now(1:2));
Now_M = str2double(Now(4:5));
Now_S = str2double(Now(7:12)) + Now_M*60 + Now_H*3600;
Start_H = str2double(StartTime(1:2));
Start_M = str2double(StartTime(4:5));
Start_S = str2double(StartTime(7:12)) + Start_M*60 + Start_H*3600;
Update_S = Now_S – Start_S;
if Update_S < Duration*60
A(1) = floor(Update_S/3600);
A(2) = floor((Update_S – A(1)*3600)/60);
A(3) = Update_S – A(1)*3600 – A(2)*60;
update = sprintf(‘%02.0f:%02.0f:%02.3f’, A(1), A(2), A(3));
else
Box.Timer_EditField.Value = ‘Session Over’;
Box.PAUSEButton.Text = ‘END’;
Box.PAUSEButton.BackgroundColor = ‘Red’;
Box.LampColor = ‘#9aa0a2’;
Box.STARTButton.Text = ‘START’;
end
UI Script Attached if needed!
Thank you SO much in advance for any guidance!!Hi all! I am relatively new to app design in Matlab and I’m trying to design an app for an automated recording set-up. The idea is that users can define metadata in the UI (animal ID, duration of trial, etc.) before starting the session, then start and pause the session as needed, and then monitor the recording from the app while the automation is controlled in a separate matlab script (i.e. the automation is not running on the callbacks). I can get my app to pass information back to the base script using assignin for basic inputs and pass data back to the UI for monitoring like a timer and temperature. However, I can’t figure out how to execute my code only when the user starts the trial. To start with something simple, I have written an UpdateTimer function that updates the timer when called in the main script (I had originally written a timer into the callback but then nothing else can run so now the user will see the timer update everytime something runs in the automation to approximate the time since starting) and I have some dummy temperature data. When the user clicks Start on the UI, I would like the timer and temperature to update every 10 seconds. However, no matter what I try, the script can’t tell when the button has changed. Can anyone help me??
Main Script:
clear all;
close all;
b1_State = ‘NotStarted’; %Initial state of start button
Box1 = TestApp; %Calling UI
%pause(15); %I can pause is for 15seconds and quickly enter everything and then hit start and the following will work, but I don’t want the user to be on a time limit before starting the session
switch b1_State %This was the last thing I tried, I’ve also tried while and if loops with no success either
case ‘Recording’
test = 5;
Box1.Timer_EditField.Value = UpdateTimer(b1_StartTime, b1_PauseTime, b1_Duration, Box1);
Box1.TemperatureCEditField.Value = num2str(25);
pause(10)
Box1.Timer_EditField.Value = UpdateTimer(b1_StartTime, b1_PauseTime, b1_Duration, Box1);
Box1.TemperatureCEditField.Value = num2str(35);
end % Eventually I will specify what happens when the script is paused, but I just wanted to get one case working first
UpdateTimer Script (Note I’m still working on what happens if the user pauses and then continues the recording):
function update = UpdateTimer(StartTime, PauseTime, Duration, Box)
Now = datestr(now, "HH:MM:SS.FFF");
Now_H = str2double(Now(1:2));
Now_M = str2double(Now(4:5));
Now_S = str2double(Now(7:12)) + Now_M*60 + Now_H*3600;
Start_H = str2double(StartTime(1:2));
Start_M = str2double(StartTime(4:5));
Start_S = str2double(StartTime(7:12)) + Start_M*60 + Start_H*3600;
Update_S = Now_S – Start_S;
if Update_S < Duration*60
A(1) = floor(Update_S/3600);
A(2) = floor((Update_S – A(1)*3600)/60);
A(3) = Update_S – A(1)*3600 – A(2)*60;
update = sprintf(‘%02.0f:%02.0f:%02.3f’, A(1), A(2), A(3));
else
Box.Timer_EditField.Value = ‘Session Over’;
Box.PAUSEButton.Text = ‘END’;
Box.PAUSEButton.BackgroundColor = ‘Red’;
Box.LampColor = ‘#9aa0a2’;
Box.STARTButton.Text = ‘START’;
end
UI Script Attached if needed!
Thank you SO much in advance for any guidance!! Hi all! I am relatively new to app design in Matlab and I’m trying to design an app for an automated recording set-up. The idea is that users can define metadata in the UI (animal ID, duration of trial, etc.) before starting the session, then start and pause the session as needed, and then monitor the recording from the app while the automation is controlled in a separate matlab script (i.e. the automation is not running on the callbacks). I can get my app to pass information back to the base script using assignin for basic inputs and pass data back to the UI for monitoring like a timer and temperature. However, I can’t figure out how to execute my code only when the user starts the trial. To start with something simple, I have written an UpdateTimer function that updates the timer when called in the main script (I had originally written a timer into the callback but then nothing else can run so now the user will see the timer update everytime something runs in the automation to approximate the time since starting) and I have some dummy temperature data. When the user clicks Start on the UI, I would like the timer and temperature to update every 10 seconds. However, no matter what I try, the script can’t tell when the button has changed. Can anyone help me??
Main Script:
clear all;
close all;
b1_State = ‘NotStarted’; %Initial state of start button
Box1 = TestApp; %Calling UI
%pause(15); %I can pause is for 15seconds and quickly enter everything and then hit start and the following will work, but I don’t want the user to be on a time limit before starting the session
switch b1_State %This was the last thing I tried, I’ve also tried while and if loops with no success either
case ‘Recording’
test = 5;
Box1.Timer_EditField.Value = UpdateTimer(b1_StartTime, b1_PauseTime, b1_Duration, Box1);
Box1.TemperatureCEditField.Value = num2str(25);
pause(10)
Box1.Timer_EditField.Value = UpdateTimer(b1_StartTime, b1_PauseTime, b1_Duration, Box1);
Box1.TemperatureCEditField.Value = num2str(35);
end % Eventually I will specify what happens when the script is paused, but I just wanted to get one case working first
UpdateTimer Script (Note I’m still working on what happens if the user pauses and then continues the recording):
function update = UpdateTimer(StartTime, PauseTime, Duration, Box)
Now = datestr(now, "HH:MM:SS.FFF");
Now_H = str2double(Now(1:2));
Now_M = str2double(Now(4:5));
Now_S = str2double(Now(7:12)) + Now_M*60 + Now_H*3600;
Start_H = str2double(StartTime(1:2));
Start_M = str2double(StartTime(4:5));
Start_S = str2double(StartTime(7:12)) + Start_M*60 + Start_H*3600;
Update_S = Now_S – Start_S;
if Update_S < Duration*60
A(1) = floor(Update_S/3600);
A(2) = floor((Update_S – A(1)*3600)/60);
A(3) = Update_S – A(1)*3600 – A(2)*60;
update = sprintf(‘%02.0f:%02.0f:%02.3f’, A(1), A(2), A(3));
else
Box.Timer_EditField.Value = ‘Session Over’;
Box.PAUSEButton.Text = ‘END’;
Box.PAUSEButton.BackgroundColor = ‘Red’;
Box.LampColor = ‘#9aa0a2’;
Box.STARTButton.Text = ‘START’;
end
UI Script Attached if needed!
Thank you SO much in advance for any guidance!! appdesigner, userinterface MATLAB Answers — New Questions
How do I make this code a global one, which works for different pictures associated with skin wounds?
clear all
close all
[Im,map] = imread("rana2.jpg");
imshow(Im,map)
ImBgnd = rgb2gray(Im)
ImBgnd = double(ImBgnd)/255
[ImH,ImS,ImV] = ConversieHSV(Im);
%Conversie HSV
imshow(ImH/360)
imshow(ImS/100)
imshow(ImV/100)
ImBinarHS = Filtrare(ImH,350,5);
ImBinarHSf = imfill(ImBinarHS,"holes");
imshow(ImBinarHSf)
Imfinal = Im.*uint8(ImBinarHSf);
imshow(Imfinal)
ImBinarVS = Filtrare(ImS,70,35);
ImBinarVS = ~ImBinarVS;
ImBinarVSf = imfill(ImBinarVS,"holes");
imshow(ImBinarVS)
Imfinal = Im.*uint8(ImBinarVSf);
imshow(Imfinal)
ImfinS = ImBinarHSf&ImBinarVSf;
Imfinal = Im.*uint8(~ImfinS);
imshow(Imfinal)
[ImH,ImS,ImV] = ConversieHSV(Im);
imshow(ImH/360)
imshow(ImS/100)
imshow(ImV/100)
ImBinarHI = Filtrare(ImH,10,1);
ImBinarHIf = imfill(ImBinarHI,"holes");
imshow(ImBinarHIf)
Label = bwlabel(ImBinarHIf)
Label(Label~=1) = 0;
Label = ~Label
Imfinal = Im.*uint8(ImBinarHIf);
imshow(Imfinal)
ImBinarVI = Filtrare(ImS,70,35);
ImBinarVI = ~ImBinarVI;
ImBinarVIf = imfill(ImBinarVI,"holes");
imshow(ImBinarVI)
Imfinal = Im.*uint8(ImBinarVIf);
imshow(Imfinal)
ImfinI = ImBinarHIf&ImBinarVIf&Label;
ImfinI = ImfinI-ImfinS;
ImfinI = imclearborder(ImfinI);
Imfinal = Im.*uint8(~ImfinI);
imshow(Imfinal);
ImfinalIS = ImfinI|ImfinS;
ImfinalP = ~ImfinalIS;
ImFinalI(:,:,1) = ImBgnd.*(ImfinI*255)/255;
ImFinalI(:,:,2) = ImBgnd.*(ImfinI*0)/255;
ImFinalI(:,:,3) = ImBgnd.*(ImfinI*0)/255;
ImFinalS(:,:,1) = ImBgnd.*(ImfinS*100)/255;
ImFinalS(:,:,2) = ImBgnd.*(ImfinS*100)/255;
ImFinalS(:,:,3) = ImBgnd.*(ImfinS*100)/255;
ImFinalP(:,:,1) = ImBgnd.*(ImfinalP*0)/255;
ImFinalP(:,:,2) = ImBgnd.*(ImfinalP*255)/255;
ImFinalP(:,:,3) = ImBgnd.*(ImfinalP*0)/255;
ImfinalIS = Im.*uint8(~ImfinalIS);
Imfinal = ImFinalP+ImFinalI+ImFinalS
imshow(Imfinal)
imshowpair(Im,Imfinal,"montage")
%this is what i did wrong, this is not global
%
%and this is what i realised for this photo, this was the original photo, for this i made the code
%
%i need to help me if you can, i need to do this code global for mode photoes for my graduation, but i dont know how to continue, thank you guys!clear all
close all
[Im,map] = imread("rana2.jpg");
imshow(Im,map)
ImBgnd = rgb2gray(Im)
ImBgnd = double(ImBgnd)/255
[ImH,ImS,ImV] = ConversieHSV(Im);
%Conversie HSV
imshow(ImH/360)
imshow(ImS/100)
imshow(ImV/100)
ImBinarHS = Filtrare(ImH,350,5);
ImBinarHSf = imfill(ImBinarHS,"holes");
imshow(ImBinarHSf)
Imfinal = Im.*uint8(ImBinarHSf);
imshow(Imfinal)
ImBinarVS = Filtrare(ImS,70,35);
ImBinarVS = ~ImBinarVS;
ImBinarVSf = imfill(ImBinarVS,"holes");
imshow(ImBinarVS)
Imfinal = Im.*uint8(ImBinarVSf);
imshow(Imfinal)
ImfinS = ImBinarHSf&ImBinarVSf;
Imfinal = Im.*uint8(~ImfinS);
imshow(Imfinal)
[ImH,ImS,ImV] = ConversieHSV(Im);
imshow(ImH/360)
imshow(ImS/100)
imshow(ImV/100)
ImBinarHI = Filtrare(ImH,10,1);
ImBinarHIf = imfill(ImBinarHI,"holes");
imshow(ImBinarHIf)
Label = bwlabel(ImBinarHIf)
Label(Label~=1) = 0;
Label = ~Label
Imfinal = Im.*uint8(ImBinarHIf);
imshow(Imfinal)
ImBinarVI = Filtrare(ImS,70,35);
ImBinarVI = ~ImBinarVI;
ImBinarVIf = imfill(ImBinarVI,"holes");
imshow(ImBinarVI)
Imfinal = Im.*uint8(ImBinarVIf);
imshow(Imfinal)
ImfinI = ImBinarHIf&ImBinarVIf&Label;
ImfinI = ImfinI-ImfinS;
ImfinI = imclearborder(ImfinI);
Imfinal = Im.*uint8(~ImfinI);
imshow(Imfinal);
ImfinalIS = ImfinI|ImfinS;
ImfinalP = ~ImfinalIS;
ImFinalI(:,:,1) = ImBgnd.*(ImfinI*255)/255;
ImFinalI(:,:,2) = ImBgnd.*(ImfinI*0)/255;
ImFinalI(:,:,3) = ImBgnd.*(ImfinI*0)/255;
ImFinalS(:,:,1) = ImBgnd.*(ImfinS*100)/255;
ImFinalS(:,:,2) = ImBgnd.*(ImfinS*100)/255;
ImFinalS(:,:,3) = ImBgnd.*(ImfinS*100)/255;
ImFinalP(:,:,1) = ImBgnd.*(ImfinalP*0)/255;
ImFinalP(:,:,2) = ImBgnd.*(ImfinalP*255)/255;
ImFinalP(:,:,3) = ImBgnd.*(ImfinalP*0)/255;
ImfinalIS = Im.*uint8(~ImfinalIS);
Imfinal = ImFinalP+ImFinalI+ImFinalS
imshow(Imfinal)
imshowpair(Im,Imfinal,"montage")
%this is what i did wrong, this is not global
%
%and this is what i realised for this photo, this was the original photo, for this i made the code
%
%i need to help me if you can, i need to do this code global for mode photoes for my graduation, but i dont know how to continue, thank you guys! clear all
close all
[Im,map] = imread("rana2.jpg");
imshow(Im,map)
ImBgnd = rgb2gray(Im)
ImBgnd = double(ImBgnd)/255
[ImH,ImS,ImV] = ConversieHSV(Im);
%Conversie HSV
imshow(ImH/360)
imshow(ImS/100)
imshow(ImV/100)
ImBinarHS = Filtrare(ImH,350,5);
ImBinarHSf = imfill(ImBinarHS,"holes");
imshow(ImBinarHSf)
Imfinal = Im.*uint8(ImBinarHSf);
imshow(Imfinal)
ImBinarVS = Filtrare(ImS,70,35);
ImBinarVS = ~ImBinarVS;
ImBinarVSf = imfill(ImBinarVS,"holes");
imshow(ImBinarVS)
Imfinal = Im.*uint8(ImBinarVSf);
imshow(Imfinal)
ImfinS = ImBinarHSf&ImBinarVSf;
Imfinal = Im.*uint8(~ImfinS);
imshow(Imfinal)
[ImH,ImS,ImV] = ConversieHSV(Im);
imshow(ImH/360)
imshow(ImS/100)
imshow(ImV/100)
ImBinarHI = Filtrare(ImH,10,1);
ImBinarHIf = imfill(ImBinarHI,"holes");
imshow(ImBinarHIf)
Label = bwlabel(ImBinarHIf)
Label(Label~=1) = 0;
Label = ~Label
Imfinal = Im.*uint8(ImBinarHIf);
imshow(Imfinal)
ImBinarVI = Filtrare(ImS,70,35);
ImBinarVI = ~ImBinarVI;
ImBinarVIf = imfill(ImBinarVI,"holes");
imshow(ImBinarVI)
Imfinal = Im.*uint8(ImBinarVIf);
imshow(Imfinal)
ImfinI = ImBinarHIf&ImBinarVIf&Label;
ImfinI = ImfinI-ImfinS;
ImfinI = imclearborder(ImfinI);
Imfinal = Im.*uint8(~ImfinI);
imshow(Imfinal);
ImfinalIS = ImfinI|ImfinS;
ImfinalP = ~ImfinalIS;
ImFinalI(:,:,1) = ImBgnd.*(ImfinI*255)/255;
ImFinalI(:,:,2) = ImBgnd.*(ImfinI*0)/255;
ImFinalI(:,:,3) = ImBgnd.*(ImfinI*0)/255;
ImFinalS(:,:,1) = ImBgnd.*(ImfinS*100)/255;
ImFinalS(:,:,2) = ImBgnd.*(ImfinS*100)/255;
ImFinalS(:,:,3) = ImBgnd.*(ImfinS*100)/255;
ImFinalP(:,:,1) = ImBgnd.*(ImfinalP*0)/255;
ImFinalP(:,:,2) = ImBgnd.*(ImfinalP*255)/255;
ImFinalP(:,:,3) = ImBgnd.*(ImfinalP*0)/255;
ImfinalIS = Im.*uint8(~ImfinalIS);
Imfinal = ImFinalP+ImFinalI+ImFinalS
imshow(Imfinal)
imshowpair(Im,Imfinal,"montage")
%this is what i did wrong, this is not global
%
%and this is what i realised for this photo, this was the original photo, for this i made the code
%
%i need to help me if you can, i need to do this code global for mode photoes for my graduation, but i dont know how to continue, thank you guys! image processing, filter, choose file to process MATLAB Answers — New Questions
Create accessible PDFs with Microsoft 365 apps
Hi Microsoft 365 Insiders!
In the spirit of Global Accessibility Awareness Day, let’s highlight the importance of creating PDFs that everyone can access and enjoy. Our latest blog post by Peter Wu provides a comprehensive guide on how to create accessible PDFs using Microsoft 365 apps.
Blog link: Create accessible PDFs with Microsoft 365
Here’s why this matters:
• Over 1 billion people worldwide live with disabilities. Making your content accessible empowers them to fully participate in the digital world.
• Microsoft 365 apps have built-in tools that help you make content accessible as you go, including the Accessibility Checker that runs while you work.
• When saving or exporting your document as a PDF, use the ‘Save or Export as PDF’ command to preserve accessibility features. Remember, ‘Print as PDF’ won’t keep your PDFs accessible.
Let’s embrace these practices and ensure that our digital content is inclusive for all. Check out the blog to learn more about creating accessible PDFs and join us in making a difference!
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!
In the spirit of Global Accessibility Awareness Day, let’s highlight the importance of creating PDFs that everyone can access and enjoy. Our latest blog post by Peter Wu provides a comprehensive guide on how to create accessible PDFs using Microsoft 365 apps.
Blog link: Create accessible PDFs with Microsoft 365
Here’s why this matters:• Over 1 billion people worldwide live with disabilities. Making your content accessible empowers them to fully participate in the digital world.• Microsoft 365 apps have built-in tools that help you make content accessible as you go, including the Accessibility Checker that runs while you work.• When saving or exporting your document as a PDF, use the ‘Save or Export as PDF’ command to preserve accessibility features. Remember, ‘Print as PDF’ won’t keep your PDFs accessible.
Let’s embrace these practices and ensure that our digital content is inclusive for all. Check out the blog to learn more about creating accessible PDFs and join us in making a difference!
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
New sharepoint there is no timestamp
Hello
Please i need your help on this issue.
On the classic SharePoint, we are able to see the timestamp when we modify list on calendar.
But On the new SharePoint there is no timestamp
Hello Please i need your help on this issue. On the classic SharePoint, we are able to see the timestamp when we modify list on calendar. But On the new SharePoint there is no timestamp Read More
NPS on reboot choses wrong certificate
Seems that recently (after May 2024 update?) certificate selected for Microsoft: Smart Care or other certificate does not “stick”
I need it to use RAS template certificate, but on reboot it will select longest certificate ie Remote Desktop
And ofcourse all my wireless clients (machine certificate based RADIUS authentication) are DENIED access and hell breaks lose.
Same issue with primary-to-secondary NPS sync (where whole config gets exported from source, deleted on destination & re-imported on destination, as scheduled task)
Anybody has any idea how to force specific certificate to STAY as selected by admin (me)
Thanks
Seb
Seems that recently (after May 2024 update?) certificate selected for Microsoft: Smart Care or other certificate does not “stick”I need it to use RAS template certificate, but on reboot it will select longest certificate ie Remote Desktop And ofcourse all my wireless clients (machine certificate based RADIUS authentication) are DENIED access and hell breaks lose. Same issue with primary-to-secondary NPS sync (where whole config gets exported from source, deleted on destination & re-imported on destination, as scheduled task) Anybody has any idea how to force specific certificate to STAY as selected by admin (me) Thanks Seb Read More
Files that are encrypted through the sensitivity label.
Hello
Please i need your help on this issue.
The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files
I’ve opened the Excel file on my MAC that is in my downloads folder.
This issue looks to be on all files that are encrypted through the sensitivity label.
I am able to open the file while on 16.84 then when I update to the latest update 16.85 I would get the permissions error so when I uninstalled 16.85 and reinstall 16.84 it would open again.
Hello Please i need your help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I’ve opened the Excel file on my MAC that is in my downloads folder.This issue looks to be on all files that are encrypted through the sensitivity label.I am able to open the file while on 16.84 then when I update to the latest update 16.85 I would get the permissions error so when I uninstalled 16.85 and reinstall 16.84 it would open again. Read More
How to only redeploy a power apps inside a solution from Test to PROD without the need to reconfigur
I have 2 environments;
1) Test
2) PROd
and 2 SharePoint sites:-
1)Test
2) PROD
and i have a solution which contains the following:-
1) 1 Power Apps
2) 55 workflows
3) 90 environment variables
when i did the first move from Test to PROD >> i were asked to reconfigure all the environment variables which sound valid, now i modified the power apps inside my Test envelopment, by changing some formats and coloring.. then i export the solution from Dev but when i tired to import the solution inside my PROD environment, i were not asked to define the environment variables and the environment variables on PROD got the values of the Test environment.. so how i can force the import to use the existing environment variables inside PROD?
I have 2 environments; 1) Test2) PROd and 2 SharePoint sites:-1)Test2) PROD and i have a solution which contains the following:- 1) 1 Power Apps2) 55 workflows3) 90 environment variables when i did the first move from Test to PROD >> i were asked to reconfigure all the environment variables which sound valid, now i modified the power apps inside my Test envelopment, by changing some formats and coloring.. then i export the solution from Dev but when i tired to import the solution inside my PROD environment, i were not asked to define the environment variables and the environment variables on PROD got the values of the Test environment.. so how i can force the import to use the existing environment variables inside PROD? Read More
New Windows skilling snack: Advanced network security
Already tackled the Network security basics for endpoints? Ready to build on your knowledge? In under 2 hours, explore these collections of overviews and demos that will help you give your organization the worry-free environment it deserves. Dive deeper into Zero Trust, VPN, Microsoft Defender Firewall, cloud security, how security is evolving in 2024, and more. Read and watch up on all of these critical topics or choose your pick at Skilling snack: Advanced network security.
Unfamiliar with Windows skilling snacks?
There is a sea of technical information out there, so here’s a new way to dive in without getting overwhelmed!
Every two weeks, there will be a handpicked snack-size selection of essential articles, demos, deep dives, and learning modules on a specific topic—all of which can be consumed in less than two hours. Skill up over a long lunch break, the weekend, or a slow day at the office! Break the routine with hands-off video or use your browser to turn an article into a read-aloud experience while you get up and stretch, take a walk, or multitask.
To catch up and view the whole menu, see Windows skilling snacks: bite-sized learning for IT pros.
Bon appétit!
Already tackled the Network security basics for endpoints? Ready to build on your knowledge? In under 2 hours, explore these collections of overviews and demos that will help you give your organization the worry-free environment it deserves. Dive deeper into Zero Trust, VPN, Microsoft Defender Firewall, cloud security, how security is evolving in 2024, and more. Read and watch up on all of these critical topics or choose your pick at Skilling snack: Advanced network security.
Unfamiliar with Windows skilling snacks?
There is a sea of technical information out there, so here’s a new way to dive in without getting overwhelmed!
Every two weeks, there will be a handpicked snack-size selection of essential articles, demos, deep dives, and learning modules on a specific topic—all of which can be consumed in less than two hours. Skill up over a long lunch break, the weekend, or a slow day at the office! Break the routine with hands-off video or use your browser to turn an article into a read-aloud experience while you get up and stretch, take a walk, or multitask.
To catch up and view the whole menu, see Windows skilling snacks: bite-sized learning for IT pros.
Bon appétit! Read More
Can I update questions in forms with live data?
I’m attempting to build a pre-qualification form (rather about 50 of them) and one of the questions is “please select your income range” with either a drop-down list or a radio button.
The issue is the income ranges are updated quarterly and on 50 forms, it becomes a huge task to keep them updated.
Is there a way I can set the forms to pull the income ranges from an excel spreadsheet, so I only have one doc to keep updated?
Or another solution that will allow this?
I’m attempting to build a pre-qualification form (rather about 50 of them) and one of the questions is “please select your income range” with either a drop-down list or a radio button. The issue is the income ranges are updated quarterly and on 50 forms, it becomes a huge task to keep them updated. Is there a way I can set the forms to pull the income ranges from an excel spreadsheet, so I only have one doc to keep updated? Or another solution that will allow this? Read More
The views look different.
Hello,
Could you do me a favor?
I created two lists but the view(mode) looks different. I don’t know why.
1.
2.
Hello, Could you do me a favor?I created two lists but the view(mode) looks different. I don’t know why. 1. 2. Read More
Azure Devops pipeline parameter pass
Hello,
How can I pass the parameter from stageA to stageB?
The parameter output is an output from bicep file, called by a job.
I would like to use this output on the next stage.
Thanks,
Istvan
Hello, How can I pass the parameter from stageA to stageB?The parameter output is an output from bicep file, called by a job.I would like to use this output on the next stage. Thanks,Istvan Read More
Bookings Link not displaying correct times
I have been experiencing this issue intermittently for the past 6 months or so. In my booking page, it shows that I have 6 separate slots, but when I send the link to somebody else, it only shows 2 of the 6 times as available.
I have been experiencing this issue intermittently for the past 6 months or so. In my booking page, it shows that I have 6 separate slots, but when I send the link to somebody else, it only shows 2 of the 6 times as available. Read More