Author: PuTI
Microsoft Defender For Endpoint API Recommendations
Good Afternoon;
We have integrated with the API Endpoint to get the recommendations, we then use the recommendation id to get a list of machine references, which works fine.
We encountered an issue where one of our recommendation id had a / in the string. For example
va-_-microsoft-_-edge_chromium-based/odbc
This isn’t the exact item, but it did have a / in it.
My question is: Is the / in there supposed to be encoded, stripped away? If we then use this id to hit the next endpoint for get a list of machine References, it will error.
Good Afternoon;We have integrated with the API Endpoint to get the recommendations, we then use the recommendation id to get a list of machine references, which works fine.We encountered an issue where one of our recommendation id had a / in the string. For exampleva-_-microsoft-_-edge_chromium-based/odbcThis isn’t the exact item, but it did have a / in it.My question is: Is the / in there supposed to be encoded, stripped away? If we then use this id to hit the next endpoint for get a list of machine References, it will error. Read More
Deploy and configure Azure Monitor Applied Skills assessment not available
Does anyone know when the Applied Skills: Deploy and Configure Azure Monitor assessment will be available again?
I’ve been trying to take it for the past few weeks, but it keeps showing the message “This assessment is currently undergoing maintenance,” as shown in the screenshot.
Does anyone know when the Applied Skills: Deploy and Configure Azure Monitor assessment will be available again? I’ve been trying to take it for the past few weeks, but it keeps showing the message “This assessment is currently undergoing maintenance,” as shown in the screenshot. Read More
Word accessibility checker stuck on “updating results”
I have a weird issue with a user and the Check Accessibility feature in Word. It’s required that they use it before they send these documents out as they go to various clients. About a month ago, it just stopped working correctly, and gets stuck on “Updating Results”
New document with text added using Word desktop app – worksExisting document from SharePoint using Word desktop app – doesn’t work. Same document works with the web version of WordSave document from SharePoint to local desk using Word desktop app – worksOpening an Word attachment in email using Word desktop app – works. Saving same attachment to OneDrive then using Word desktop app – doesn’t work.
So the problem appears to be centered around files that get opened on OneDrive/SharePoint and using the Word app. It works when it’s a local file, but the same file that is saved in SharePoint will not work. The web version will work though.
We are on the monthly enterprise channel, and currently on version 2406, build 16.017726.20206 9×64).
Any ideas?
I have a weird issue with a user and the Check Accessibility feature in Word. It’s required that they use it before they send these documents out as they go to various clients. About a month ago, it just stopped working correctly, and gets stuck on “Updating Results” New document with text added using Word desktop app – worksExisting document from SharePoint using Word desktop app – doesn’t work. Same document works with the web version of WordSave document from SharePoint to local desk using Word desktop app – worksOpening an Word attachment in email using Word desktop app – works. Saving same attachment to OneDrive then using Word desktop app – doesn’t work.So the problem appears to be centered around files that get opened on OneDrive/SharePoint and using the Word app. It works when it’s a local file, but the same file that is saved in SharePoint will not work. The web version will work though. We are on the monthly enterprise channel, and currently on version 2406, build 16.017726.20206 9×64). Any ideas? Read More
How to Migrate Files from Dropbox to OneDrive While Maintaining Folder Structure
I have a corporate Dropbox account where each folder is named after a specific deal from my database. Inside each deal folder, there are subfolders representing the different stages of the deal as it progresses through the database.
Recently, I set up a Microsoft 365 business account and recreated the same folder structure in OneDrive. This means I have the deal folders with their corresponding names, and within each deal folder, I’ve already created the stage-based subfolders.
What I want to achieve is to migrate all the files from Dropbox to their respective folders in OneDrive.
Example:
In Dropbox, I have a folder named “Company1” that contains subfolders like “Emails,” “Attachments,” and “Presentations.” Each of these subfolders contains files.
In OneDrive, I’ve already created the “Company1” folder with the same subfolders: “Emails,” “Attachments,” and “Presentations.” I need to transfer the files from Dropbox so that files from “Emails” in Dropbox go into “Emails” in OneDrive under the “Company1” folder, and so on for the other subfolders.
Request:
I’m looking for the best method to perform this migration while ensuring that the folder structure and file placement remain intact. Is there a native method within Microsoft 365 to accomplish this, or do you know of any third-party applications that can handle this type of migration efficiently? Any advice or step-by-step guidance would be greatly appreciated!
I have a corporate Dropbox account where each folder is named after a specific deal from my database. Inside each deal folder, there are subfolders representing the different stages of the deal as it progresses through the database.Recently, I set up a Microsoft 365 business account and recreated the same folder structure in OneDrive. This means I have the deal folders with their corresponding names, and within each deal folder, I’ve already created the stage-based subfolders.What I want to achieve is to migrate all the files from Dropbox to their respective folders in OneDrive.Example:In Dropbox, I have a folder named “Company1” that contains subfolders like “Emails,” “Attachments,” and “Presentations.” Each of these subfolders contains files.In OneDrive, I’ve already created the “Company1” folder with the same subfolders: “Emails,” “Attachments,” and “Presentations.” I need to transfer the files from Dropbox so that files from “Emails” in Dropbox go into “Emails” in OneDrive under the “Company1” folder, and so on for the other subfolders.Request:I’m looking for the best method to perform this migration while ensuring that the folder structure and file placement remain intact. Is there a native method within Microsoft 365 to accomplish this, or do you know of any third-party applications that can handle this type of migration efficiently? Any advice or step-by-step guidance would be greatly appreciated! Read More
Is there a „=Sheetname(1)“ in Excel for direct input into a cell (no macro or VBA)
I am looking for an Excel-function „sheetname(1)“ with name of the first sheet presented in the workspace for the construction of references. Does this function exist in Excel 365 for direct input without macro or VBA?
Rolf Heller
I am looking for an Excel-function „sheetname(1)“ with name of the first sheet presented in the workspace for the construction of references. Does this function exist in Excel 365 for direct input without macro or VBA?Rolf Heller Read More
Bookings is greyed out
Hi, we’ve noticed today that bookings is grey out, we have 6 services and all are affected, I can’t see any obvious changes as to why this might be. Any initial thoughts would be grateful, thanks
Hi, we’ve noticed today that bookings is grey out, we have 6 services and all are affected, I can’t see any obvious changes as to why this might be. Any initial thoughts would be grateful, thanks Read More
Cash amortization table
Hello,
I am trying to figure which formulate would be best to populate the chart. I am currently doing basic manual formulas for each row but can be very time consuming.
For each week I have total sales. I am trying to figure how much I can expect to collect each week. For example, the cells in yellow are indicating to me in which week to expect to collect the totals sales from week number 1, $500,000
Any suggestion greatly appreciated.
Hello, I am trying to figure which formulate would be best to populate the chart. I am currently doing basic manual formulas for each row but can be very time consuming. For each week I have total sales. I am trying to figure how much I can expect to collect each week. For example, the cells in yellow are indicating to me in which week to expect to collect the totals sales from week number 1, $500,000 Any suggestion greatly appreciated. Read More
Why is the initial working folder not opening when I start MATLAB?
I set the "initial working folder" in my MATLAB Preferences so MATLAB will open my preferred folder when I use the shortcut icon. However, when I first open MATLAB on Windows, the initial working folder is not the folder I specified. How do I change the initial working folder folder that MATLAB opens?I set the "initial working folder" in my MATLAB Preferences so MATLAB will open my preferred folder when I use the shortcut icon. However, when I first open MATLAB on Windows, the initial working folder is not the folder I specified. How do I change the initial working folder folder that MATLAB opens? I set the "initial working folder" in my MATLAB Preferences so MATLAB will open my preferred folder when I use the shortcut icon. However, when I first open MATLAB on Windows, the initial working folder is not the folder I specified. How do I change the initial working folder folder that MATLAB opens? initial, working, folder, preferences, shortcut MATLAB Answers — New Questions
uitable copy function allowing for numerical values of mixture of of numbers and chars.
Hi, I have a uitable and have a copy function as below. This works fine if the table is solely numbers
function CopyTableData(app,src,event)
tbl = event.ContextObject;
% fieldnames(event)
% event.InteractionInformation
s=tbl.Data;
size_s = size(s);
str = ”;
for i=1:size_s(1)
for j=1:size_s(2)
str = sprintf ( ‘%s%ft’, str, s(i,j) );
end
str = sprintf ( ‘%sn’, str );
end
clipboard(‘copy’,str);
end
There are instances where my table will be a cell array and I have modified the function (for the str = sprintf ( ‘%s%ft’, str, s{i,j}) to:
function CopyTableData(app,src,event)
tbl = event.ContextObject;
% fieldnames(event)
% event.InteractionInformation
s=tbl.Data;
size_s = size(s);
str = ”;
for i=1:size_s(1)
for j=1:size_s(2)
try
str = sprintf ( ‘%s%ft’, str, s(i,j) );
catch
str = sprintf ( ‘%s%ft’, str, s{i,j} );
end
end
str = sprintf ( ‘%sn’, str );
end
clipboard(‘copy’,str);
end
However, when my data is as below (cellarray) in which the contents of all columns in the cellarray are numbers, but the very last column ‘info" are charss
I get this when pasted into excel (notice the last column is incorrect and actually split into 2)
this is how I created my dummy data:
uit=app.UITableSummary;
dx=9437;
z1=5795;
z2=5775.2
dz=z2-z1
tilt_mrads=-2.1084
A={dx,z1,z2,dz,tilt_mrads,’info’};
d=uit.Data; % Get Current table data
uit.Data = [d; A]; %Add new row to current data
I kept on adding this and just manually replaced the ‘info’ value in the last column (’10’, ’12’, etc..) and the numeric values in the 2nd from last column (-2.11, -1.59, etc..)
thanks for any helpHi, I have a uitable and have a copy function as below. This works fine if the table is solely numbers
function CopyTableData(app,src,event)
tbl = event.ContextObject;
% fieldnames(event)
% event.InteractionInformation
s=tbl.Data;
size_s = size(s);
str = ”;
for i=1:size_s(1)
for j=1:size_s(2)
str = sprintf ( ‘%s%ft’, str, s(i,j) );
end
str = sprintf ( ‘%sn’, str );
end
clipboard(‘copy’,str);
end
There are instances where my table will be a cell array and I have modified the function (for the str = sprintf ( ‘%s%ft’, str, s{i,j}) to:
function CopyTableData(app,src,event)
tbl = event.ContextObject;
% fieldnames(event)
% event.InteractionInformation
s=tbl.Data;
size_s = size(s);
str = ”;
for i=1:size_s(1)
for j=1:size_s(2)
try
str = sprintf ( ‘%s%ft’, str, s(i,j) );
catch
str = sprintf ( ‘%s%ft’, str, s{i,j} );
end
end
str = sprintf ( ‘%sn’, str );
end
clipboard(‘copy’,str);
end
However, when my data is as below (cellarray) in which the contents of all columns in the cellarray are numbers, but the very last column ‘info" are charss
I get this when pasted into excel (notice the last column is incorrect and actually split into 2)
this is how I created my dummy data:
uit=app.UITableSummary;
dx=9437;
z1=5795;
z2=5775.2
dz=z2-z1
tilt_mrads=-2.1084
A={dx,z1,z2,dz,tilt_mrads,’info’};
d=uit.Data; % Get Current table data
uit.Data = [d; A]; %Add new row to current data
I kept on adding this and just manually replaced the ‘info’ value in the last column (’10’, ’12’, etc..) and the numeric values in the 2nd from last column (-2.11, -1.59, etc..)
thanks for any help Hi, I have a uitable and have a copy function as below. This works fine if the table is solely numbers
function CopyTableData(app,src,event)
tbl = event.ContextObject;
% fieldnames(event)
% event.InteractionInformation
s=tbl.Data;
size_s = size(s);
str = ”;
for i=1:size_s(1)
for j=1:size_s(2)
str = sprintf ( ‘%s%ft’, str, s(i,j) );
end
str = sprintf ( ‘%sn’, str );
end
clipboard(‘copy’,str);
end
There are instances where my table will be a cell array and I have modified the function (for the str = sprintf ( ‘%s%ft’, str, s{i,j}) to:
function CopyTableData(app,src,event)
tbl = event.ContextObject;
% fieldnames(event)
% event.InteractionInformation
s=tbl.Data;
size_s = size(s);
str = ”;
for i=1:size_s(1)
for j=1:size_s(2)
try
str = sprintf ( ‘%s%ft’, str, s(i,j) );
catch
str = sprintf ( ‘%s%ft’, str, s{i,j} );
end
end
str = sprintf ( ‘%sn’, str );
end
clipboard(‘copy’,str);
end
However, when my data is as below (cellarray) in which the contents of all columns in the cellarray are numbers, but the very last column ‘info" are charss
I get this when pasted into excel (notice the last column is incorrect and actually split into 2)
this is how I created my dummy data:
uit=app.UITableSummary;
dx=9437;
z1=5795;
z2=5775.2
dz=z2-z1
tilt_mrads=-2.1084
A={dx,z1,z2,dz,tilt_mrads,’info’};
d=uit.Data; % Get Current table data
uit.Data = [d; A]; %Add new row to current data
I kept on adding this and just manually replaced the ‘info’ value in the last column (’10’, ’12’, etc..) and the numeric values in the 2nd from last column (-2.11, -1.59, etc..)
thanks for any help uitable, sprintf MATLAB Answers — New Questions
Regenerative Braking using BLDC Motor
hi am developing a regenrative simple circuit using the vedio series and the model from how to design motor controllers using simscape electrical. i have made some changes to The back model and i am able to reach a point where i am able to chagre a capacitor bank at constant angular velocity source. Futher i wanted to integrate a brake controll with pid contoller whcih i am not able to figure out and want help with to complelete my regenrative model with respect to electrical side not consisdering the vehicle parameter right now.
If there are model or block which will be helpfull please pin the link. open to any sugessition and help.
thanks and regardshi am developing a regenrative simple circuit using the vedio series and the model from how to design motor controllers using simscape electrical. i have made some changes to The back model and i am able to reach a point where i am able to chagre a capacitor bank at constant angular velocity source. Futher i wanted to integrate a brake controll with pid contoller whcih i am not able to figure out and want help with to complelete my regenrative model with respect to electrical side not consisdering the vehicle parameter right now.
If there are model or block which will be helpfull please pin the link. open to any sugessition and help.
thanks and regards hi am developing a regenrative simple circuit using the vedio series and the model from how to design motor controllers using simscape electrical. i have made some changes to The back model and i am able to reach a point where i am able to chagre a capacitor bank at constant angular velocity source. Futher i wanted to integrate a brake controll with pid contoller whcih i am not able to figure out and want help with to complelete my regenrative model with respect to electrical side not consisdering the vehicle parameter right now.
If there are model or block which will be helpfull please pin the link. open to any sugessition and help.
thanks and regards #regenerativebraking, #bldc_motor MATLAB Answers — New Questions
Linkdata not refreshing graph
I have code for a battery controler i’m making, and as part of that i want to display some live results as it continues running. The whole system runs in a repreating while loop which you can see below(have removed some code to make it legible).
while On = ‘true’
%% Initialise Display
Display = figure(‘Name’,’Controler Display’,’NumberTitle’,’off’);
tiledlayout(2,1)
ax1 = nexttile;
plot(ax1,Display_timebase,Display_Power_cmd, "DisplayName","ESS Power Command (kW)")
title ‘ESS input/output’
hold on
plot(ax1,Display_timebase,Display_Grid_Demand,"DisplayName","Grid Demand")
plot(ax1,Display_timebase,Display_Available_Power, "DisplayName","Available Power (kW)")
ylim([-300 320])
legend
xline(0)
hold off
ylabel("ESS Power in/output")
xlabel("Time")
xlim([-12 48])
ax2 = nexttile;
plot(ax2,Display_timebase,Display_ESS_SoC)
title ‘SoC over time’
ylim([0 1.05])
ylabel("ESS SoC")
xlabel("Time")
xlim([-12 48])
xline(0)
linkdata(Display,’on’)
drawnow
%%%%%%%%%%%
%% Additional Code
%%%%%%%%%%%
%% Update Display values
Display_Power_cmd = [Historical_power_cmd Navigator_Outputs.Power_cmd’];
Display_Grid_Demand = [Historical_Grid_Demand Navigator_Outputs.Grid_Demand’];
Display_Available_Power = [Historical_Available_Power Mapper_Outputs.Available_Power’];
Display_ESS_SoC = [Historical_SoC ESS_SoC_array’];
drawnow
end
I’m aware that being in a while loop suppresses figure updates, hence why i’ve included the drawnows but my figures still refuse to update. What am i doing wrong here?I have code for a battery controler i’m making, and as part of that i want to display some live results as it continues running. The whole system runs in a repreating while loop which you can see below(have removed some code to make it legible).
while On = ‘true’
%% Initialise Display
Display = figure(‘Name’,’Controler Display’,’NumberTitle’,’off’);
tiledlayout(2,1)
ax1 = nexttile;
plot(ax1,Display_timebase,Display_Power_cmd, "DisplayName","ESS Power Command (kW)")
title ‘ESS input/output’
hold on
plot(ax1,Display_timebase,Display_Grid_Demand,"DisplayName","Grid Demand")
plot(ax1,Display_timebase,Display_Available_Power, "DisplayName","Available Power (kW)")
ylim([-300 320])
legend
xline(0)
hold off
ylabel("ESS Power in/output")
xlabel("Time")
xlim([-12 48])
ax2 = nexttile;
plot(ax2,Display_timebase,Display_ESS_SoC)
title ‘SoC over time’
ylim([0 1.05])
ylabel("ESS SoC")
xlabel("Time")
xlim([-12 48])
xline(0)
linkdata(Display,’on’)
drawnow
%%%%%%%%%%%
%% Additional Code
%%%%%%%%%%%
%% Update Display values
Display_Power_cmd = [Historical_power_cmd Navigator_Outputs.Power_cmd’];
Display_Grid_Demand = [Historical_Grid_Demand Navigator_Outputs.Grid_Demand’];
Display_Available_Power = [Historical_Available_Power Mapper_Outputs.Available_Power’];
Display_ESS_SoC = [Historical_SoC ESS_SoC_array’];
drawnow
end
I’m aware that being in a while loop suppresses figure updates, hence why i’ve included the drawnows but my figures still refuse to update. What am i doing wrong here? I have code for a battery controler i’m making, and as part of that i want to display some live results as it continues running. The whole system runs in a repreating while loop which you can see below(have removed some code to make it legible).
while On = ‘true’
%% Initialise Display
Display = figure(‘Name’,’Controler Display’,’NumberTitle’,’off’);
tiledlayout(2,1)
ax1 = nexttile;
plot(ax1,Display_timebase,Display_Power_cmd, "DisplayName","ESS Power Command (kW)")
title ‘ESS input/output’
hold on
plot(ax1,Display_timebase,Display_Grid_Demand,"DisplayName","Grid Demand")
plot(ax1,Display_timebase,Display_Available_Power, "DisplayName","Available Power (kW)")
ylim([-300 320])
legend
xline(0)
hold off
ylabel("ESS Power in/output")
xlabel("Time")
xlim([-12 48])
ax2 = nexttile;
plot(ax2,Display_timebase,Display_ESS_SoC)
title ‘SoC over time’
ylim([0 1.05])
ylabel("ESS SoC")
xlabel("Time")
xlim([-12 48])
xline(0)
linkdata(Display,’on’)
drawnow
%%%%%%%%%%%
%% Additional Code
%%%%%%%%%%%
%% Update Display values
Display_Power_cmd = [Historical_power_cmd Navigator_Outputs.Power_cmd’];
Display_Grid_Demand = [Historical_Grid_Demand Navigator_Outputs.Grid_Demand’];
Display_Available_Power = [Historical_Available_Power Mapper_Outputs.Available_Power’];
Display_ESS_SoC = [Historical_SoC ESS_SoC_array’];
drawnow
end
I’m aware that being in a while loop suppresses figure updates, hence why i’ve included the drawnows but my figures still refuse to update. What am i doing wrong here? figure, linkdata MATLAB Answers — New Questions
unknown parameters in Radon transform example
in https://www.mathworks.com/help/images/detect-lines-using-the-radon-transform.html line 31 of example code: [x1,y1] = pol2cart(deg2rad(1),5000) , where 5000 comes from? the same line 34, [x91,y91] = pol2cart(deg2rad(91),100) – where 100 comes from?
[SL: fixed URL by removing trailing comma]in https://www.mathworks.com/help/images/detect-lines-using-the-radon-transform.html line 31 of example code: [x1,y1] = pol2cart(deg2rad(1),5000) , where 5000 comes from? the same line 34, [x91,y91] = pol2cart(deg2rad(91),100) – where 100 comes from?
[SL: fixed URL by removing trailing comma] in https://www.mathworks.com/help/images/detect-lines-using-the-radon-transform.html line 31 of example code: [x1,y1] = pol2cart(deg2rad(1),5000) , where 5000 comes from? the same line 34, [x91,y91] = pol2cart(deg2rad(91),100) – where 100 comes from?
[SL: fixed URL by removing trailing comma] radon example, pol2cart MATLAB Answers — New Questions
Simulate api failure when using the C# sdk
Hi
I use the C# SDK to call the grap api, now the tester wants to test the app, but there is a scenario that the call to API should fail, lets say the API is not reachable or request takes a long time, I tried some proxy apps to prevent outgoing request to graph api, but I did not succussed. Can you help ?
HiI use the C# SDK to call the grap api, now the tester wants to test the app, but there is a scenario that the call to API should fail, lets say the API is not reachable or request takes a long time, I tried some proxy apps to prevent outgoing request to graph api, but I did not succussed. Can you help ? Read More
phishing emails with only a name as the sender and no visible email address
There has been a sudden surge of spam or phishing emails flooding the main inbox, with only a name as the sender and no visible email address. Could this be due to a newly exploited vulnerability in the app or web app?
Clicking on the senders just expend a empty span and holding open the “contact” of it but once again its just the name, no address.
I have received like on of them every hour ….
On webapp from Edge :
literally says “No sender address” here, c’mon it’s an email, how is this even permitted/supported/possible ??
There has been a sudden surge of spam or phishing emails flooding the main inbox, with only a name as the sender and no visible email address. Could this be due to a newly exploited vulnerability in the app or web app? Clicking on the senders just expend a empty span and holding open the “contact” of it but once again its just the name, no address. I have received like on of them every hour …. On webapp from Edge :literally says “No sender address” here, c’mon it’s an email, how is this even permitted/supported/possible ?? Read More
Unique identifier #
Hi,
I’m trying to create a list of unique identifier numbers that users can link to their activity line items with a their expenses along with a way that shows the user if a unique identifier number was already used to avoid duplication/errors. Does excel have the functionality to do this? If so, can you kindly explain? Thank you!
Hi, I’m trying to create a list of unique identifier numbers that users can link to their activity line items with a their expenses along with a way that shows the user if a unique identifier number was already used to avoid duplication/errors. Does excel have the functionality to do this? If so, can you kindly explain? Thank you! Read More
Troubles accessing Chat
Hi all,
Since yesterday, we discover that some people of our organisation stop randomly accessing to the chat icon. The error message says Sorry … we didn’t find this application.
Anyone got it? have you solve it?
Thanks MG
Hi all, Since yesterday, we discover that some people of our organisation stop randomly accessing to the chat icon. The error message says Sorry … we didn’t find this application. Anyone got it? have you solve it? Thanks MG Read More
Talking to your relational Database using GPT not just to one table or view, but to multiple v/t
Dear Community, What is the best solution for a chat app that can interact with a relational database, not just limited to a single table or view? Thank you!
Dear Community, What is the best solution for a chat app that can interact with a relational database, not just limited to a single table or view? Thank you! Read More
How to use a template file in VBA when it is stored online (Teams or SharePoint)?
As many companies are on the brink of migrating to Microsoft 365 and moving all files from the file server to the cloud (OneDrive/SharePoint), I need to know how I can use templates stored in Teams, from VBA.
Here is an example:
I have an Excel file in which I generate a chart, using a chart template with VBA.
This works fine as long the chart template is on a file server, but when I move it to Teams, my code can’t use the template.
so the template path is:
(xxxxxxxxxxxxxxx = company id).
When I run the procedure, I get this error message:
How can I solve this?
GrtZ, BartH_NL
As many companies are on the brink of migrating to Microsoft 365 and moving all files from the file server to the cloud (OneDrive/SharePoint), I need to know how I can use templates stored in Teams, from VBA.Here is an example:I have an Excel file in which I generate a chart, using a chart template with VBA.This works fine as long the chart template is on a file server, but when I move it to Teams, my code can’t use the template.so the template path is:https://xxxxxxxxxxxxxx.sharepoint.com/sites/msteams_a046009/Shared%20Documents/General/DRR%20Test/DRR.crtx(xxxxxxxxxxxxxxx = company id).When I run the procedure, I get this error message:How can I solve this? GrtZ, BartH_NL Read More
Creating a Rubric with Checkboxes and Auto Calculations
Hello all,
I’ve been trying to figure this out on my own, but to no avail. I would like to make a scoring rubric for faculty to use on student projects that auto-calculates. If a certain box is checked, it will assign a value and the section total will be tallied up at the end. I have the Sum function no problem. What I cannot figure out is how to get the check boxes formatted so they will create a certain value for that rubric item.
For example, if B7 is checked, that should return a value of 4. If unchecked, a value of 0. If D8 is checked, that should return a value of 2 (if unchecked, then 0).
Everything would be tallied up in H11 so the instructors do not have to manually calculate the overall score. They simply check a box for each criteria listed in 7-10 and get the sum total. (I have the SUM function inserted and working properly)
Any help on how to format the check boxes to return values is much appreciated. I’ve spent hours using tutorials and articles and am stumped! Thank you.
Hello all, I’ve been trying to figure this out on my own, but to no avail. I would like to make a scoring rubric for faculty to use on student projects that auto-calculates. If a certain box is checked, it will assign a value and the section total will be tallied up at the end. I have the Sum function no problem. What I cannot figure out is how to get the check boxes formatted so they will create a certain value for that rubric item. For example, if B7 is checked, that should return a value of 4. If unchecked, a value of 0. If D8 is checked, that should return a value of 2 (if unchecked, then 0).Everything would be tallied up in H11 so the instructors do not have to manually calculate the overall score. They simply check a box for each criteria listed in 7-10 and get the sum total. (I have the SUM function inserted and working properly) Any help on how to format the check boxes to return values is much appreciated. I’ve spent hours using tutorials and articles and am stumped! Thank you. Read More
List all DL’s in on-prem Exchange with Zero members
We are trying to clean up our 1000’s of Distribution Lists before migrating them to 365.
Could somebody please help me with a script that would accomplish this?
I have tried everything I can think of and have struck out miserably.
Thanks in advance.
We are trying to clean up our 1000’s of Distribution Lists before migrating them to 365.Could somebody please help me with a script that would accomplish this?I have tried everything I can think of and have struck out miserably.Thanks in advance. Read More
