Month: July 2024
Issue with Vulnerability Management for Microsoft Defender for Endpoint on Rocky 9
We are experiencing an issue with the Vulnerability Management feature for Microsoft Defender for Endpoint on Rocky 9 Linux. The system is not showing any data for software packages or discovering vulnerable ones. Despite the presence of a vulnerability for OpenSSH, it was not reported by the system.
Thanks
We are experiencing an issue with the Vulnerability Management feature for Microsoft Defender for Endpoint on Rocky 9 Linux. The system is not showing any data for software packages or discovering vulnerable ones. Despite the presence of a vulnerability for OpenSSH, it was not reported by the system. Thanks Read More
Overwriting the maximum function evaluation
Hi all, I have some data to be fitted with the function (please refer to my code). However, despite manually setting the maximumfunctionevaluation limit, the computer doesn’t seem to take it and it says the solver stops prematurely. May I ask what have I done wrong?
%% Preparation
clear;clc
data = importdata("FCPIB-293K-2.5mW-400nm-Jan072021 -ibg -bg -chirp.csv"); % insert file path within parenthesis
%% Preamble
% Fundamental constants
h = 4.0135667696*10^-15; % units: eV/ Hz
c = 3*10^8; % SI units
kB = 8.617333268*10^-5; % units: eV/ K
% Clean up of data to select range of values
wavelength = data(1:end, 1);
delay_t = data(1, 1:end); % conatains all of the delay times
E = (h*c)./(wavelength*10^-9); % contains all of the probe energies
Range_E = E>=1.5 & E<=2.2;
Range_T = delay_t>=0.5 & delay_t<=1000;
% for one delay time
T = find(Range_T);
T_min = min(T);
T_max = max(T);
t = 57; % choose an integer b/w T_min and T_max
delaytime = delay_t(1, t);
disp(delaytime)
% Initial parameter guess and bounds
lb = [0, 293, -1]; ub = [Inf, 1200, 1];
y0 = [2*10^9, 1000, 0.5];
% Data for fitting
E_p = E(Range_E); % selected probe energies
delta_Abs = -1*data(Range_E,t);
delta_Abs_norm = delta_Abs./max(abs(delta_Abs)); % normalised delta_Abs
Range_Efit = E_p>=1.62 & E_p<=max(E_p);
E_fit = E_p(Range_Efit);
delta_Abs_norm_fit = delta_Abs_norm(Range_Efit);
% Fitting function
function F = MB(y, E_fit)
F = y(1).*exp(-(E_fit./(8.617333268*10^-5.*y(2)))) + y(3);
end
%% Curve fitting options
% % Initial parameter guess and bounds
% lb = [0, 293, -1]; ub = [Inf, 800, 1];
% y0 = [1.2*10^9, 700, 0.5];
% lsqcurvefit and choose between different algorithm that lsqcurvefit employs (3C1, comment those lines that are not choosen and uncomment the line that is choosen, if not, matlab will take the last line of "optim_lsq" by default)
optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘levenberg-marquardt’, ‘MaxFunctionEvaluations’,10^10, ‘MaxIterations’, 10^10, ‘FunctionTolerance’,10^-10, ‘StepTolerance’, 10^-10);
% optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘trust-region-reflective’, ‘MaxFunctionEvaluations’,10^10, ‘MaxIterations’,10^10, ‘FunctionTolerance’,10^-20, ‘StepTolerance’, 10^-20);
% optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘interior-point’, ‘MaxFunctionEvaluations’,1000, ‘MaxIterations’, 1000, ‘FunctionTolerance’,10^-20, ‘StepTolerance’, 10^-20);
% Solver for lsqcurvefit
[y, residualnorm, residual, exitflag, output, lambda, jacobian] = lsqcurvefit(@MB, y0, E_fit, delta_Abs_norm_fit, lb, ub);
%% Plot command
plot(E_p, delta_Abs_norm,’Black’)
hold on
plot(E_fit, MB(y, E_fit), ‘LineWidth’, 1.0, ‘Color’, ‘red’)
xlabel(‘Probe Photon Energy (eV)’)
ylabel(‘Normalised Delta A (a.u.)’)
legend(‘Experimental Data’, ‘Fitted Curve’)
disp(y(1,1))
disp(y(1,2))
disp(y(1,3))Hi all, I have some data to be fitted with the function (please refer to my code). However, despite manually setting the maximumfunctionevaluation limit, the computer doesn’t seem to take it and it says the solver stops prematurely. May I ask what have I done wrong?
%% Preparation
clear;clc
data = importdata("FCPIB-293K-2.5mW-400nm-Jan072021 -ibg -bg -chirp.csv"); % insert file path within parenthesis
%% Preamble
% Fundamental constants
h = 4.0135667696*10^-15; % units: eV/ Hz
c = 3*10^8; % SI units
kB = 8.617333268*10^-5; % units: eV/ K
% Clean up of data to select range of values
wavelength = data(1:end, 1);
delay_t = data(1, 1:end); % conatains all of the delay times
E = (h*c)./(wavelength*10^-9); % contains all of the probe energies
Range_E = E>=1.5 & E<=2.2;
Range_T = delay_t>=0.5 & delay_t<=1000;
% for one delay time
T = find(Range_T);
T_min = min(T);
T_max = max(T);
t = 57; % choose an integer b/w T_min and T_max
delaytime = delay_t(1, t);
disp(delaytime)
% Initial parameter guess and bounds
lb = [0, 293, -1]; ub = [Inf, 1200, 1];
y0 = [2*10^9, 1000, 0.5];
% Data for fitting
E_p = E(Range_E); % selected probe energies
delta_Abs = -1*data(Range_E,t);
delta_Abs_norm = delta_Abs./max(abs(delta_Abs)); % normalised delta_Abs
Range_Efit = E_p>=1.62 & E_p<=max(E_p);
E_fit = E_p(Range_Efit);
delta_Abs_norm_fit = delta_Abs_norm(Range_Efit);
% Fitting function
function F = MB(y, E_fit)
F = y(1).*exp(-(E_fit./(8.617333268*10^-5.*y(2)))) + y(3);
end
%% Curve fitting options
% % Initial parameter guess and bounds
% lb = [0, 293, -1]; ub = [Inf, 800, 1];
% y0 = [1.2*10^9, 700, 0.5];
% lsqcurvefit and choose between different algorithm that lsqcurvefit employs (3C1, comment those lines that are not choosen and uncomment the line that is choosen, if not, matlab will take the last line of "optim_lsq" by default)
optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘levenberg-marquardt’, ‘MaxFunctionEvaluations’,10^10, ‘MaxIterations’, 10^10, ‘FunctionTolerance’,10^-10, ‘StepTolerance’, 10^-10);
% optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘trust-region-reflective’, ‘MaxFunctionEvaluations’,10^10, ‘MaxIterations’,10^10, ‘FunctionTolerance’,10^-20, ‘StepTolerance’, 10^-20);
% optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘interior-point’, ‘MaxFunctionEvaluations’,1000, ‘MaxIterations’, 1000, ‘FunctionTolerance’,10^-20, ‘StepTolerance’, 10^-20);
% Solver for lsqcurvefit
[y, residualnorm, residual, exitflag, output, lambda, jacobian] = lsqcurvefit(@MB, y0, E_fit, delta_Abs_norm_fit, lb, ub);
%% Plot command
plot(E_p, delta_Abs_norm,’Black’)
hold on
plot(E_fit, MB(y, E_fit), ‘LineWidth’, 1.0, ‘Color’, ‘red’)
xlabel(‘Probe Photon Energy (eV)’)
ylabel(‘Normalised Delta A (a.u.)’)
legend(‘Experimental Data’, ‘Fitted Curve’)
disp(y(1,1))
disp(y(1,2))
disp(y(1,3)) Hi all, I have some data to be fitted with the function (please refer to my code). However, despite manually setting the maximumfunctionevaluation limit, the computer doesn’t seem to take it and it says the solver stops prematurely. May I ask what have I done wrong?
%% Preparation
clear;clc
data = importdata("FCPIB-293K-2.5mW-400nm-Jan072021 -ibg -bg -chirp.csv"); % insert file path within parenthesis
%% Preamble
% Fundamental constants
h = 4.0135667696*10^-15; % units: eV/ Hz
c = 3*10^8; % SI units
kB = 8.617333268*10^-5; % units: eV/ K
% Clean up of data to select range of values
wavelength = data(1:end, 1);
delay_t = data(1, 1:end); % conatains all of the delay times
E = (h*c)./(wavelength*10^-9); % contains all of the probe energies
Range_E = E>=1.5 & E<=2.2;
Range_T = delay_t>=0.5 & delay_t<=1000;
% for one delay time
T = find(Range_T);
T_min = min(T);
T_max = max(T);
t = 57; % choose an integer b/w T_min and T_max
delaytime = delay_t(1, t);
disp(delaytime)
% Initial parameter guess and bounds
lb = [0, 293, -1]; ub = [Inf, 1200, 1];
y0 = [2*10^9, 1000, 0.5];
% Data for fitting
E_p = E(Range_E); % selected probe energies
delta_Abs = -1*data(Range_E,t);
delta_Abs_norm = delta_Abs./max(abs(delta_Abs)); % normalised delta_Abs
Range_Efit = E_p>=1.62 & E_p<=max(E_p);
E_fit = E_p(Range_Efit);
delta_Abs_norm_fit = delta_Abs_norm(Range_Efit);
% Fitting function
function F = MB(y, E_fit)
F = y(1).*exp(-(E_fit./(8.617333268*10^-5.*y(2)))) + y(3);
end
%% Curve fitting options
% % Initial parameter guess and bounds
% lb = [0, 293, -1]; ub = [Inf, 800, 1];
% y0 = [1.2*10^9, 700, 0.5];
% lsqcurvefit and choose between different algorithm that lsqcurvefit employs (3C1, comment those lines that are not choosen and uncomment the line that is choosen, if not, matlab will take the last line of "optim_lsq" by default)
optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘levenberg-marquardt’, ‘MaxFunctionEvaluations’,10^10, ‘MaxIterations’, 10^10, ‘FunctionTolerance’,10^-10, ‘StepTolerance’, 10^-10);
% optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘trust-region-reflective’, ‘MaxFunctionEvaluations’,10^10, ‘MaxIterations’,10^10, ‘FunctionTolerance’,10^-20, ‘StepTolerance’, 10^-20);
% optim_lsq = optimoptions(‘lsqcurvefit’, ‘Algorithm’, ‘interior-point’, ‘MaxFunctionEvaluations’,1000, ‘MaxIterations’, 1000, ‘FunctionTolerance’,10^-20, ‘StepTolerance’, 10^-20);
% Solver for lsqcurvefit
[y, residualnorm, residual, exitflag, output, lambda, jacobian] = lsqcurvefit(@MB, y0, E_fit, delta_Abs_norm_fit, lb, ub);
%% Plot command
plot(E_p, delta_Abs_norm,’Black’)
hold on
plot(E_fit, MB(y, E_fit), ‘LineWidth’, 1.0, ‘Color’, ‘red’)
xlabel(‘Probe Photon Energy (eV)’)
ylabel(‘Normalised Delta A (a.u.)’)
legend(‘Experimental Data’, ‘Fitted Curve’)
disp(y(1,1))
disp(y(1,2))
disp(y(1,3)) curve fitting, lsqcurvefit MATLAB Answers — New Questions
Difficulties converting E-001
Hi,
I’m importing an excel file to Matlab where example 45E-001 is divided into two column so A[1,1]= 45 and B[1,1]=E-001. "A" comes in as a double and "B" as a cell and when I’m trting to use str2double I only get Nan in each row. I would like to be able to do C = A .* B and that C[1,1] = 4.5.
Thank youHi,
I’m importing an excel file to Matlab where example 45E-001 is divided into two column so A[1,1]= 45 and B[1,1]=E-001. "A" comes in as a double and "B" as a cell and when I’m trting to use str2double I only get Nan in each row. I would like to be able to do C = A .* B and that C[1,1] = 4.5.
Thank you Hi,
I’m importing an excel file to Matlab where example 45E-001 is divided into two column so A[1,1]= 45 and B[1,1]=E-001. "A" comes in as a double and "B" as a cell and when I’m trting to use str2double I only get Nan in each row. I would like to be able to do C = A .* B and that C[1,1] = 4.5.
Thank you matlab, scientific number MATLAB Answers — New Questions
How do you compute the product of a matrix and each column of another matrix without a for loop in MATLAB, or is this just not possible?
A 4×14 matrix (C) is multiplied by each column of a 14xN matrix (x) – hence by N individual 14 element column vectors – to form N individual 4 element column vectors – represented by a 4xN matrix (y) -, where N is a known yet large number, let’s assume N = 132 for simplicity.
I use a for loop for this operation:
N = 132;
C = [0,1,0,0,0,0,0,0,0,-1,0,-0.68,0, 1.53;
0,0,0,1,0,0,0,0,0,-1,0,-0.64,0,-1.92;
0,0,0,0,0,1,0,0,0,-1,0, 0.86,0,-1.92;
0,0,0,0,0,0,0,1,0,-1,0, 0.91,0, 1.53];
x = rand(14,N);
for n = 1:N
y(:,n) = C*x(:,n);
end
y
This works fine, however, I wondered how this operation could be implemented without a for loop in MATLAB – all variables in the loop are available prior to the first iteration – to utilize MATLAB’s matrix multiplication optimization and thus improve runtime performance, or is this just not possible?
Thanks in advance for any help!A 4×14 matrix (C) is multiplied by each column of a 14xN matrix (x) – hence by N individual 14 element column vectors – to form N individual 4 element column vectors – represented by a 4xN matrix (y) -, where N is a known yet large number, let’s assume N = 132 for simplicity.
I use a for loop for this operation:
N = 132;
C = [0,1,0,0,0,0,0,0,0,-1,0,-0.68,0, 1.53;
0,0,0,1,0,0,0,0,0,-1,0,-0.64,0,-1.92;
0,0,0,0,0,1,0,0,0,-1,0, 0.86,0,-1.92;
0,0,0,0,0,0,0,1,0,-1,0, 0.91,0, 1.53];
x = rand(14,N);
for n = 1:N
y(:,n) = C*x(:,n);
end
y
This works fine, however, I wondered how this operation could be implemented without a for loop in MATLAB – all variables in the loop are available prior to the first iteration – to utilize MATLAB’s matrix multiplication optimization and thus improve runtime performance, or is this just not possible?
Thanks in advance for any help! A 4×14 matrix (C) is multiplied by each column of a 14xN matrix (x) – hence by N individual 14 element column vectors – to form N individual 4 element column vectors – represented by a 4xN matrix (y) -, where N is a known yet large number, let’s assume N = 132 for simplicity.
I use a for loop for this operation:
N = 132;
C = [0,1,0,0,0,0,0,0,0,-1,0,-0.68,0, 1.53;
0,0,0,1,0,0,0,0,0,-1,0,-0.64,0,-1.92;
0,0,0,0,0,1,0,0,0,-1,0, 0.86,0,-1.92;
0,0,0,0,0,0,0,1,0,-1,0, 0.91,0, 1.53];
x = rand(14,N);
for n = 1:N
y(:,n) = C*x(:,n);
end
y
This works fine, however, I wondered how this operation could be implemented without a for loop in MATLAB – all variables in the loop are available prior to the first iteration – to utilize MATLAB’s matrix multiplication optimization and thus improve runtime performance, or is this just not possible?
Thanks in advance for any help! matlab, matrix, for loop, matlab function, time series, speed MATLAB Answers — New Questions
How to continually clock in data during a simulation within Simulink
Hi,
I am experimenting within Simulink, and I wish to be able to run a simulation while clocking in input data several times during the simulation. I though to use a selector block and a counter limited block, however I keep getting run-time errors which identify a range problem with the idx input on the selector. I have set the Starting index (port) option in the selector and also set the input port size to 1, but the error says it is not in the permissable range (0 through 0).
I’m a bit confused with the error, and I am hoping it could be further explained. Further guidance would be appreciated.
I have attached a capture of my test with the parameters and the error for context.
Regards.Hi,
I am experimenting within Simulink, and I wish to be able to run a simulation while clocking in input data several times during the simulation. I though to use a selector block and a counter limited block, however I keep getting run-time errors which identify a range problem with the idx input on the selector. I have set the Starting index (port) option in the selector and also set the input port size to 1, but the error says it is not in the permissable range (0 through 0).
I’m a bit confused with the error, and I am hoping it could be further explained. Further guidance would be appreciated.
I have attached a capture of my test with the parameters and the error for context.
Regards. Hi,
I am experimenting within Simulink, and I wish to be able to run a simulation while clocking in input data several times during the simulation. I though to use a selector block and a counter limited block, however I keep getting run-time errors which identify a range problem with the idx input on the selector. I have set the Starting index (port) option in the selector and also set the input port size to 1, but the error says it is not in the permissable range (0 through 0).
I’m a bit confused with the error, and I am hoping it could be further explained. Further guidance would be appreciated.
I have attached a capture of my test with the parameters and the error for context.
Regards. selector block, counter limited, reset counter MATLAB Answers — New Questions
Error in Manager data synchronization via SCIM
Hello!
My name is Alex Moiseev, and I am experiencing an issue with user synchronization via SCIM with Azure Active Directory. Well, actually with manager synchronization.
As far as I understand, the approach of provisioning of the user is the following.
Step 1. Provisioner tries to get info about the user by id with GET User resource request.
Step 2. Based on information received, Provisioner decides should the whole information about the user be sent or there is a need only to update certain fields.
Step 3. Provisioner send POST or PUT/PATCH request with user details to create/update user on the receiver side.
And everything works more or less ok, but the managers.
In user data to provide there is one field, which is used for manager info:
urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager
When there is no manager on consumer side assigned to the user, everything works perfectly.
The provisioner sends manager info in both cases – with existing and with non-existing user.
If the manager is changed on Azure AD side, we still receive manager data in the field mentioned in PATCH request in order to overwrite stored manager.
But when the manager is removed on Azure AD side, we didn’t receive any information about it – urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager field doesn’t exist in PATCH request.
We thought, that may be because we didn’t add manager information in GET User resource response.
We tried to add manager information there according to the documentation (https://docs.microsoft.com/en-us/azure/active-directory/app-provisioning/use-scim-to-provision-users-and-groups) by adding
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”: {
“manager”: “0”
},
We use “0” in order to make the provisioner to send us information about the manager in each request.
But we’ve got an error there:
Error message
We are not able to deserialize the resource received from your SCIM endpoint because your SCIM endpoint is not fully compatible with the Azure Active Directory SCIM client. Here is the resource we received from your SCIM endpoint:
{
“schemas”: [
“urn:ietf:params:scim:schemas:core:2.0:User”,
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”
],
“externalId”: “Worker”,
“id”: “1548197”,
“userName”: “email address removed for privacy reasons”,
“name”: {
“familyName”: “Ker”,
“givenName”: “Wor”
},
“emails”: [
{
“value”: “email address removed for privacy reasons”,
“type”: “work”,
“primary”: true
}
],
“title”: “Developer”,
“locale”: “nl”,
“timezone”: “CEST”,
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”: {
“manager”: “0”
},
“active”: true,
“displayName”: “Wor Ker”
}
Please refer to the Azure Active Directory SCIM provisioning documentation (https://docs.microsoft.com/en-us/azure/active-directory/app-provisioning/use-scim-to-provision-users-and-groups) and adapt the SCIM endpoint to be able to process provisioning requests from Azure Active Directory.
We have reviewed the documentation referenced, and the format for specifying the manager is exactly as indicated in the documentation.
If the “manager” field is removed from the data, the error does not occur.
So, the questions are:
1. How should we provide manager information in the response of GET User resource call?
2. How should we catch the removing of the manager in Azure in a proper way?
I would appreciate your assistance in resolving this issue.
I’d like to know what is causing the error and how to correctly transmit manager information via SCIM.
Thank you in advance for your attention and help!
Yours sincerely,
Alex Moiseev
Hello!My name is Alex Moiseev, and I am experiencing an issue with user synchronization via SCIM with Azure Active Directory. Well, actually with manager synchronization. As far as I understand, the approach of provisioning of the user is the following.Step 1. Provisioner tries to get info about the user by id with GET User resource request.Step 2. Based on information received, Provisioner decides should the whole information about the user be sent or there is a need only to update certain fields.Step 3. Provisioner send POST or PUT/PATCH request with user details to create/update user on the receiver side.And everything works more or less ok, but the managers. In user data to provide there is one field, which is used for manager info:urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager When there is no manager on consumer side assigned to the user, everything works perfectly.The provisioner sends manager info in both cases – with existing and with non-existing user.If the manager is changed on Azure AD side, we still receive manager data in the field mentioned in PATCH request in order to overwrite stored manager.But when the manager is removed on Azure AD side, we didn’t receive any information about it – urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager field doesn’t exist in PATCH request. We thought, that may be because we didn’t add manager information in GET User resource response.We tried to add manager information there according to the documentation (https://docs.microsoft.com/en-us/azure/active-directory/app-provisioning/use-scim-to-provision-users-and-groups) by adding “urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”: {
“manager”: “0”
},We use “0” in order to make the provisioner to send us information about the manager in each request.But we’ve got an error there: Error message
We are not able to deserialize the resource received from your SCIM endpoint because your SCIM endpoint is not fully compatible with the Azure Active Directory SCIM client. Here is the resource we received from your SCIM endpoint:
{
“schemas”: [
“urn:ietf:params:scim:schemas:core:2.0:User”,
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”
],
“externalId”: “Worker”,
“id”: “1548197”,
“userName”: “email address removed for privacy reasons”,
“name”: {
“familyName”: “Ker”,
“givenName”: “Wor”
},
“emails”: [
{
“value”: “email address removed for privacy reasons”,
“type”: “work”,
“primary”: true
}
],
“title”: “Developer”,
“locale”: “nl”,
“timezone”: “CEST”,
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”: {
“manager”: “0”
},
“active”: true,
“displayName”: “Wor Ker”
}
Please refer to the Azure Active Directory SCIM provisioning documentation (https://docs.microsoft.com/en-us/azure/active-directory/app-provisioning/use-scim-to-provision-users-and-groups) and adapt the SCIM endpoint to be able to process provisioning requests from Azure Active Directory.We have reviewed the documentation referenced, and the format for specifying the manager is exactly as indicated in the documentation.If the “manager” field is removed from the data, the error does not occur. So, the questions are:1. How should we provide manager information in the response of GET User resource call?2. How should we catch the removing of the manager in Azure in a proper way? I would appreciate your assistance in resolving this issue.I’d like to know what is causing the error and how to correctly transmit manager information via SCIM.Thank you in advance for your attention and help! Yours sincerely,Alex Moiseev Read More
Making a quotation filled with data from a table on another worksheet
Good morning,
I haven’t been using Excel a lot but I’ve found a template for a quotation that I want to upgrade. On the first sheet I have all the information that needs to come in the quote, and the second sheet I made a table with all items that could come in the quote. Description, quantity, my price, clients price.
No I’ve got the table at the point I can use it like I want but actually the prices that we sell for should be together with the description, so how can I use one pull down item and make the other colums, like price to follow?
Good morning,I haven’t been using Excel a lot but I’ve found a template for a quotation that I want to upgrade. On the first sheet I have all the information that needs to come in the quote, and the second sheet I made a table with all items that could come in the quote. Description, quantity, my price, clients price. No I’ve got the table at the point I can use it like I want but actually the prices that we sell for should be together with the description, so how can I use one pull down item and make the other colums, like price to follow? Read More
How can I Identify where Office 365 Connectors are used in my Teams
Is there a way to identify all the teams in my tenant that use office 365 connectors? With the announcement that Microsoft will be retired sconnectors soon I want to be proactive in knowing which of my teams need help to migrate away from their usage.
Thanks
Is there a way to identify all the teams in my tenant that use office 365 connectors? With the announcement that Microsoft will be retired sconnectors soon I want to be proactive in knowing which of my teams need help to migrate away from their usage.Thanks Read More
Error – Connect-ExchangeOnline Error Acquiring Token: System.Net.Http.HttpRequestException
Error
Connect-ExchangeOnline
Error Acquiring Token:
System.Net.Http.HttpRequestException: An error occurred while sending the request. —> System.Net.WebException: Remote name could not be resolved: ‘server.proxy.local’
Error Connect-ExchangeOnlineError Acquiring Token:System.Net.Http.HttpRequestException: An error occurred while sending the request. —> System.Net.WebException: Remote name could not be resolved: ‘server.proxy.local’ Read More
re-org index and statistics update jobs are failing
how to resolve failing re-org index and statistics jobs, there are not enough information in the logfile and I verified there are no jobs running at the same time,
Message
Executed as user: CFSsqlmsdata2016svr. ….0.4125.3 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 8:00:00 PM Progress: 2024-07-03 20:00:01.90 Source: {5FB65CC1-7283-42ED-84DA-2A2506E11D2F} Executing query “DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp…”.: 100% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 0% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ApiPoller_CS_Detail_hi…”.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ValueToMonitor_CS_Deta…”.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbNamingConte…”.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbSite_CS_Det…”.: 4% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentError_CS_Detail_his…”.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentStatus_CS_Detail_hi…”.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_DynamicEvidence_CS_Detail_hi…”.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Detail] ON [dbo]….”.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 9% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Hourly] ON [dbo]….”.: 10% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 10% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItemStatus_Hourly] ON …”.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_PortEvidence_CS_Detail_hist]…”.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ProcessEvidence_CS_De… The package execution fa… The step failed.
wondering how to resolve this issue, if any idea please let me know
Thank You,
how to resolve failing re-org index and statistics jobs, there are not enough information in the logfile and I verified there are no jobs running at the same time, MessageExecuted as user: CFSsqlmsdata2016svr. ….0.4125.3 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 8:00:00 PM Progress: 2024-07-03 20:00:01.90 Source: {5FB65CC1-7283-42ED-84DA-2A2506E11D2F} Executing query “DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp…”.: 100% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 0% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ApiPoller_CS_Detail_hi…”.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ValueToMonitor_CS_Deta…”.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbNamingConte…”.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbSite_CS_Det…”.: 4% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentError_CS_Detail_his…”.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentStatus_CS_Detail_hi…”.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_DynamicEvidence_CS_Detail_hi…”.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Detail] ON [dbo]….”.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 9% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Hourly] ON [dbo]….”.: 10% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 10% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItemStatus_Hourly] ON …”.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_PortEvidence_CS_Detail_hist]…”.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ProcessEvidence_CS_De… The package execution fa… The step failed. wondering how to resolve this issue, if any idea please let me know Thank You, Read More
SMS Reminders
You cannot configure anything in your Bookings settings beyond a checkbox to turn the SMS feature on/off.
There is no ability to configure the reminders, for example, sending an SMS 1 hour before the meeting time.
Is there any way to control the SMS reminders like similar to Email reminders ?
Also is there a way to setup SMS reminders in Personal Bookings?
You cannot configure anything in your Bookings settings beyond a checkbox to turn the SMS feature on/off. There is no ability to configure the reminders, for example, sending an SMS 1 hour before the meeting time. Is there any way to control the SMS reminders like similar to Email reminders ? Also is there a way to setup SMS reminders in Personal Bookings? Read More
How to edit the default.aspx page at a Project Online site?
Hey,
I am pretty sure that I had edited the default.aspx page at https://xxxx.sharepoint.com/sites/pwa/default.aspx last October. However, I realized that I cannot update this default page anymore. I tried to append mode=edit at the end of the URL, but no luck.
Would you please advise how I should update this default.aspx page as a site collection administrator?
Thank you very much!
Hey, I am pretty sure that I had edited the default.aspx page at https://xxxx.sharepoint.com/sites/pwa/default.aspx last October. However, I realized that I cannot update this default page anymore. I tried to append mode=edit at the end of the URL, but no luck. Would you please advise how I should update this default.aspx page as a site collection administrator? Thank you very much! Read More
Control System Tuner always selects maximum value
Hey,
I am new to the Matlab Control System Toolbox and want to try out the Control System Tuner but I am facing a weird problem.
This is my control loop:
And I want to tune the PI controller to achieve a stable response. So I have specified the following Step Tracking Goal:
However, the Control System Tuner just gives me the maximum possible gain:
Does someone of you has an idea if I have to adjust the settings somehow or what else could be the reason for this behaviour?
ThanksHey,
I am new to the Matlab Control System Toolbox and want to try out the Control System Tuner but I am facing a weird problem.
This is my control loop:
And I want to tune the PI controller to achieve a stable response. So I have specified the following Step Tracking Goal:
However, the Control System Tuner just gives me the maximum possible gain:
Does someone of you has an idea if I have to adjust the settings somehow or what else could be the reason for this behaviour?
Thanks Hey,
I am new to the Matlab Control System Toolbox and want to try out the Control System Tuner but I am facing a weird problem.
This is my control loop:
And I want to tune the PI controller to achieve a stable response. So I have specified the following Step Tracking Goal:
However, the Control System Tuner just gives me the maximum possible gain:
Does someone of you has an idea if I have to adjust the settings somehow or what else could be the reason for this behaviour?
Thanks simulink, control MATLAB Answers — New Questions
How to use fft to analyse the refelction specturm?
I wanna get spatial frequency from FFT, just like the picture. I have already got the reflection spectrum.The wavelength and corresponding intensity are saved in Excel.
aa = xlsread(‘C:UsersjcDesktop6.27xx.xlsx’);
x = linspace(1510,1590,16001);%wavelength
y = aa(1:16001,2); %intensity
wavelength = x*1e-9;%nm
wavenumber = 1./wavelength;
wavenumberfit = linspace(wavenumber(1),wavenumber(16001),16001);I wanna get spatial frequency from FFT, just like the picture. I have already got the reflection spectrum.The wavelength and corresponding intensity are saved in Excel.
aa = xlsread(‘C:UsersjcDesktop6.27xx.xlsx’);
x = linspace(1510,1590,16001);%wavelength
y = aa(1:16001,2); %intensity
wavelength = x*1e-9;%nm
wavenumber = 1./wavelength;
wavenumberfit = linspace(wavenumber(1),wavenumber(16001),16001); I wanna get spatial frequency from FFT, just like the picture. I have already got the reflection spectrum.The wavelength and corresponding intensity are saved in Excel.
aa = xlsread(‘C:UsersjcDesktop6.27xx.xlsx’);
x = linspace(1510,1590,16001);%wavelength
y = aa(1:16001,2); %intensity
wavelength = x*1e-9;%nm
wavenumber = 1./wavelength;
wavenumberfit = linspace(wavenumber(1),wavenumber(16001),16001); fft, reflction spectrum, spatial frenquency MATLAB Answers — New Questions
Operands to the logical AND (&&) and OR (||) operators must be convertible to logical scalar values. Use the ANY or ALL functions to reduce operands to logical scalar values.
Hi, I get the following error with the given code,
"Operands to the logical AND (&&) and OR (||) operators must be convertible to logical scalar values. Use the ANY or ALL functions to reduce operands to logical scalar values."
This performs a minimization using the active set method. But seemingly, it stops over this operator problem.
Any ideas welcome!
% Define symbolic variables
syms x1 x2 x3 lambda1 lambda3
% Objective function
f = x1^2 + x2^2 + x3^2 – x1 + 2*x2 – 4*x3;
% Constraints
g1 = -x1 + x2 + 1; % -x1 + x2 >= -1 is equivalent to g1 <= 0
g2 = x1 + x2 + x3 + 3; % x1 + x2 + x3 >= -3 is equivalent to g2 <= 0
g3 = x3; % x3 >= 0 is equivalent to g3 <= 0
% Initial point
x0 = [0; 0; 0];
% Iterative process
x = x0;
activeSet = []; % Initially empty active set
maxIter = 10; % Maximum number of iterations
tol = 1e-6; % Tolerance for convergence
for iter = 1:maxIter
% Compute gradients of the objective function and constraints
grad_f = gradient(f, [x1, x2, x3]);
grad_g1 = gradient(g1, [x1, x2, x3]);
grad_g2 = gradient(g2, [x1, x2, x3]);
grad_g3 = gradient(g3, [x1, x2, x3]);
% Evaluate gradients at the current point
grad_f_val = double(subs(grad_f, {x1, x2, x3}, x’));
grad_g1_val = double(subs(grad_g1, {x1, x2, x3}, x’));
grad_g2_val = double(subs(grad_g2, {x1, x2, x3}, x’));
grad_g3_val = double(subs(grad_g3, {x1, x2, x3}, x’));
% Check KKT conditions to determine active set
if abs(grad_g1_val) < tol && subs(g1, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 1]; % Constraint 1 is active
end
if abs(grad_g2_val) < tol && subs(g2, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 2]; % Constraint 2 is active
end
if abs(grad_g3_val) < tol && subs(g3, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 3]; % Constraint 3 is active
end
% Solve the subproblem using the active set
A_eq = [];
b_eq = [];
A_ineq = [];
b_ineq = [];
lb = [];
ub = [];
options = optimoptions(‘quadprog’, ‘Display’, ‘off’);
if any(activeSet == 1)
A_ineq = [A_ineq; -1, 1, 0];
b_ineq = [b_ineq; -1];
end
if any(activeSet == 2)
A_ineq = [A_ineq; 1, 1, 1];
b_ineq = [b_ineq; -3];
end
if any(activeSet == 3)
A_ineq = [A_ineq; 0, 0, 1];
b_ineq = [b_ineq; 0];
end
[x_new, ~, exitflag] = quadprog(eye(3), -grad_f_val’, A_ineq, b_ineq, A_eq, b_eq, lb, ub, [], options);
% Check convergence
if norm(x_new – x) < tol
break;
end
% Update x and active set
x = x_new;
activeSet = unique(activeSet);
end
% Display results
disp([‘Optimal point: x = [‘, num2str(x’), ‘]’]);
disp([‘Objective function value: ‘, num2str(double(subs(f, {x1, x2, x3}, x’)))]);Hi, I get the following error with the given code,
"Operands to the logical AND (&&) and OR (||) operators must be convertible to logical scalar values. Use the ANY or ALL functions to reduce operands to logical scalar values."
This performs a minimization using the active set method. But seemingly, it stops over this operator problem.
Any ideas welcome!
% Define symbolic variables
syms x1 x2 x3 lambda1 lambda3
% Objective function
f = x1^2 + x2^2 + x3^2 – x1 + 2*x2 – 4*x3;
% Constraints
g1 = -x1 + x2 + 1; % -x1 + x2 >= -1 is equivalent to g1 <= 0
g2 = x1 + x2 + x3 + 3; % x1 + x2 + x3 >= -3 is equivalent to g2 <= 0
g3 = x3; % x3 >= 0 is equivalent to g3 <= 0
% Initial point
x0 = [0; 0; 0];
% Iterative process
x = x0;
activeSet = []; % Initially empty active set
maxIter = 10; % Maximum number of iterations
tol = 1e-6; % Tolerance for convergence
for iter = 1:maxIter
% Compute gradients of the objective function and constraints
grad_f = gradient(f, [x1, x2, x3]);
grad_g1 = gradient(g1, [x1, x2, x3]);
grad_g2 = gradient(g2, [x1, x2, x3]);
grad_g3 = gradient(g3, [x1, x2, x3]);
% Evaluate gradients at the current point
grad_f_val = double(subs(grad_f, {x1, x2, x3}, x’));
grad_g1_val = double(subs(grad_g1, {x1, x2, x3}, x’));
grad_g2_val = double(subs(grad_g2, {x1, x2, x3}, x’));
grad_g3_val = double(subs(grad_g3, {x1, x2, x3}, x’));
% Check KKT conditions to determine active set
if abs(grad_g1_val) < tol && subs(g1, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 1]; % Constraint 1 is active
end
if abs(grad_g2_val) < tol && subs(g2, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 2]; % Constraint 2 is active
end
if abs(grad_g3_val) < tol && subs(g3, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 3]; % Constraint 3 is active
end
% Solve the subproblem using the active set
A_eq = [];
b_eq = [];
A_ineq = [];
b_ineq = [];
lb = [];
ub = [];
options = optimoptions(‘quadprog’, ‘Display’, ‘off’);
if any(activeSet == 1)
A_ineq = [A_ineq; -1, 1, 0];
b_ineq = [b_ineq; -1];
end
if any(activeSet == 2)
A_ineq = [A_ineq; 1, 1, 1];
b_ineq = [b_ineq; -3];
end
if any(activeSet == 3)
A_ineq = [A_ineq; 0, 0, 1];
b_ineq = [b_ineq; 0];
end
[x_new, ~, exitflag] = quadprog(eye(3), -grad_f_val’, A_ineq, b_ineq, A_eq, b_eq, lb, ub, [], options);
% Check convergence
if norm(x_new – x) < tol
break;
end
% Update x and active set
x = x_new;
activeSet = unique(activeSet);
end
% Display results
disp([‘Optimal point: x = [‘, num2str(x’), ‘]’]);
disp([‘Objective function value: ‘, num2str(double(subs(f, {x1, x2, x3}, x’)))]); Hi, I get the following error with the given code,
"Operands to the logical AND (&&) and OR (||) operators must be convertible to logical scalar values. Use the ANY or ALL functions to reduce operands to logical scalar values."
This performs a minimization using the active set method. But seemingly, it stops over this operator problem.
Any ideas welcome!
% Define symbolic variables
syms x1 x2 x3 lambda1 lambda3
% Objective function
f = x1^2 + x2^2 + x3^2 – x1 + 2*x2 – 4*x3;
% Constraints
g1 = -x1 + x2 + 1; % -x1 + x2 >= -1 is equivalent to g1 <= 0
g2 = x1 + x2 + x3 + 3; % x1 + x2 + x3 >= -3 is equivalent to g2 <= 0
g3 = x3; % x3 >= 0 is equivalent to g3 <= 0
% Initial point
x0 = [0; 0; 0];
% Iterative process
x = x0;
activeSet = []; % Initially empty active set
maxIter = 10; % Maximum number of iterations
tol = 1e-6; % Tolerance for convergence
for iter = 1:maxIter
% Compute gradients of the objective function and constraints
grad_f = gradient(f, [x1, x2, x3]);
grad_g1 = gradient(g1, [x1, x2, x3]);
grad_g2 = gradient(g2, [x1, x2, x3]);
grad_g3 = gradient(g3, [x1, x2, x3]);
% Evaluate gradients at the current point
grad_f_val = double(subs(grad_f, {x1, x2, x3}, x’));
grad_g1_val = double(subs(grad_g1, {x1, x2, x3}, x’));
grad_g2_val = double(subs(grad_g2, {x1, x2, x3}, x’));
grad_g3_val = double(subs(grad_g3, {x1, x2, x3}, x’));
% Check KKT conditions to determine active set
if abs(grad_g1_val) < tol && subs(g1, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 1]; % Constraint 1 is active
end
if abs(grad_g2_val) < tol && subs(g2, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 2]; % Constraint 2 is active
end
if abs(grad_g3_val) < tol && subs(g3, {x1, x2, x3}, x’) <= 0
activeSet = [activeSet, 3]; % Constraint 3 is active
end
% Solve the subproblem using the active set
A_eq = [];
b_eq = [];
A_ineq = [];
b_ineq = [];
lb = [];
ub = [];
options = optimoptions(‘quadprog’, ‘Display’, ‘off’);
if any(activeSet == 1)
A_ineq = [A_ineq; -1, 1, 0];
b_ineq = [b_ineq; -1];
end
if any(activeSet == 2)
A_ineq = [A_ineq; 1, 1, 1];
b_ineq = [b_ineq; -3];
end
if any(activeSet == 3)
A_ineq = [A_ineq; 0, 0, 1];
b_ineq = [b_ineq; 0];
end
[x_new, ~, exitflag] = quadprog(eye(3), -grad_f_val’, A_ineq, b_ineq, A_eq, b_eq, lb, ub, [], options);
% Check convergence
if norm(x_new – x) < tol
break;
end
% Update x and active set
x = x_new;
activeSet = unique(activeSet);
end
% Display results
disp([‘Optimal point: x = [‘, num2str(x’), ‘]’]);
disp([‘Objective function value: ‘, num2str(double(subs(f, {x1, x2, x3}, x’)))]); operands, scalar, values MATLAB Answers — New Questions
help.
Hello ,
I’m working with a pivot report that I built for almost two years, suddenly at some point, I can’t group date by month, even though everything was working properly, and I checked all the possibilities I know (date, blank, etc.).
The second part is that if I open the same file on another computer, I manage to group the date.
Anyone recognize the problem and know how to advise please.
Hello ,I’m working with a pivot report that I built for almost two years, suddenly at some point, I can’t group date by month, even though everything was working properly, and I checked all the possibilities I know (date, blank, etc.).The second part is that if I open the same file on another computer, I manage to group the date.Anyone recognize the problem and know how to advise please. Read More
Help. Csv file to excel
Hello,
I have a question about importing a csv file to excel.
When I am importing a csv file in excel, the time does not seem to import right. I convert the text to columns, but the time does something strange.
First in the csv file it is in minutes and in excel suddenly in seconds.
Second the numbers who end with a 0 get another number of numbers behind the comma. This results in a different alignment. Which results in that i cannot make the right calculations. These numbers are with a factor 1000 smaller than the numbers who are aligned normal.
(This happens on a macbook btw)
Does someone maybe know why this happens or knows a solution?
Thank you in advance!
Hello, I have a question about importing a csv file to excel. When I am importing a csv file in excel, the time does not seem to import right. I convert the text to columns, but the time does something strange. First in the csv file it is in minutes and in excel suddenly in seconds. Second the numbers who end with a 0 get another number of numbers behind the comma. This results in a different alignment. Which results in that i cannot make the right calculations. These numbers are with a factor 1000 smaller than the numbers who are aligned normal. (This happens on a macbook btw) Does someone maybe know why this happens or knows a solution? Thank you in advance! Read More
Using templates with Copilot in Word
Hi.
I am trying to figure out how to get Copilot in Word to draft a new document but using an existing .dotx template, but alias I just can’t.
I need to know if there’s specific steps to follow to be able to do that I’m not aware of or if I should just stop trying so hard because it’s simply something that is not available in Copilot for Word.
Thanks in advance.
Hi.I am trying to figure out how to get Copilot in Word to draft a new document but using an existing .dotx template, but alias I just can’t.I need to know if there’s specific steps to follow to be able to do that I’m not aware of or if I should just stop trying so hard because it’s simply something that is not available in Copilot for Word.Thanks in advance. Read More
Remove, Hide, or Relocate the Connection Bar in Windows App when in Full Screen on Cloud PC
When using Cloud PC in full screen mode the connection bar always pops up. It’s not Pinned so it auto hides.
This issue is the bar pops up anytime the mouse is on top of screen. When using a browser, for example, to navigate to a different tab the user has to mouse to top of the screen.
This mouse movement pops up the Connection bar which is VERY invasive and blocks a large portion of the top screen which blocks the browsers tabs.
Users have to shift this left/right every time or move the mouse away (wait till it disappears) then hope they have better aiming to click on tab without bringing curser to top of screen… or else the annoying Connection bar pops up.
Is there ANY method to be able to any of the these
Relocate the connection bar to left side screen (right side interferes with up/down scroll)Delay the connection bar popup for few seconds (mouse on top of screen few seconds to show connection bar)Or permanently remove it and use Windows hotkeys to break out of Full Screen modeAny other idea…
When using Cloud PC in full screen mode the connection bar always pops up. It’s not Pinned so it auto hides. This issue is the bar pops up anytime the mouse is on top of screen. When using a browser, for example, to navigate to a different tab the user has to mouse to top of the screen. This mouse movement pops up the Connection bar which is VERY invasive and blocks a large portion of the top screen which blocks the browsers tabs.Users have to shift this left/right every time or move the mouse away (wait till it disappears) then hope they have better aiming to click on tab without bringing curser to top of screen… or else the annoying Connection bar pops up. Is there ANY method to be able to any of the theseRelocate the connection bar to left side screen (right side interferes with up/down scroll)Delay the connection bar popup for few seconds (mouse on top of screen few seconds to show connection bar)Or permanently remove it and use Windows hotkeys to break out of Full Screen modeAny other idea… Read More
