Month: August 2024
Go deeper: Linux runtime visibility meets Wireshark
Aqua Tracee is an open source runtime security and forensics tool for Linux, built to address common Linux security issues. Tracee’s main use case is to be installed in a production environment and continuously monitor system activity and detect suspicious behavior. Some alternative use cases which Tracee can be used for are dynamic malware analysis, system tracing, forensic investigations, and more. These use cases could greatly benefit from a more interactive user experience and some tools to analyze Tracee’s output.
Aqua Tracee is an open source runtime security and forensics tool for Linux, built to address common Linux security issues. Tracee’s main use case is to be installed in a production environment and continuously monitor system activity and detect suspicious behavior. Some alternative use cases which Tracee can be used for are dynamic malware analysis, system tracing, forensic investigations, and more. These use cases could greatly benefit from a more interactive user experience and some tools to analyze Tracee’s output. Read More
Transfer Functions on Biologic Data Sets
I have blast data from 3 different organisms. Two animals and one human set. I am looking to develop a transfer function to translate the data sets from animal set to the human data set. I also have the ambient pressure from outside of the body for normalization as well as weight, speed of the wave, and weight of the individual body parts. I only have acess to the following toolboxes:
MATLAB Version 9.8 (R2020a)
Curve Fitting Toolbox Version 3.5.11 (R2020a)
Deep Learning Toolbox Version 14.0 (R2020a)
GUI Layout Toolbox Version 2.3.6 (R2023a)
Signal Processing Toolbox Version 8.4 (R2020a)
Statistics and Machine Learning Toolbox Version 11.7 (R2020a)
I want to be able to set up some sort of optimizaiton funciton that would work between both of the animal models, independetly. Likely a second order model. I have attached the raw data of the pressures as a CSV. Each of the data sets are computed at 0.8Mhz and the data listed by row is an maximum individual test, not a continous data set.
I am looking for gudiance on how to start this.
>>I have blast data from 3 different organisms. Two animals and one human set. I am looking to develop a transfer function to translate the data sets from animal set to the human data set. I also have the ambient pressure from outside of the body for normalization as well as weight, speed of the wave, and weight of the individual body parts. I only have acess to the following toolboxes:
MATLAB Version 9.8 (R2020a)
Curve Fitting Toolbox Version 3.5.11 (R2020a)
Deep Learning Toolbox Version 14.0 (R2020a)
GUI Layout Toolbox Version 2.3.6 (R2023a)
Signal Processing Toolbox Version 8.4 (R2020a)
Statistics and Machine Learning Toolbox Version 11.7 (R2020a)
I want to be able to set up some sort of optimizaiton funciton that would work between both of the animal models, independetly. Likely a second order model. I have attached the raw data of the pressures as a CSV. Each of the data sets are computed at 0.8Mhz and the data listed by row is an maximum individual test, not a continous data set.
I am looking for gudiance on how to start this.
>> I have blast data from 3 different organisms. Two animals and one human set. I am looking to develop a transfer function to translate the data sets from animal set to the human data set. I also have the ambient pressure from outside of the body for normalization as well as weight, speed of the wave, and weight of the individual body parts. I only have acess to the following toolboxes:
MATLAB Version 9.8 (R2020a)
Curve Fitting Toolbox Version 3.5.11 (R2020a)
Deep Learning Toolbox Version 14.0 (R2020a)
GUI Layout Toolbox Version 2.3.6 (R2023a)
Signal Processing Toolbox Version 8.4 (R2020a)
Statistics and Machine Learning Toolbox Version 11.7 (R2020a)
I want to be able to set up some sort of optimizaiton funciton that would work between both of the animal models, independetly. Likely a second order model. I have attached the raw data of the pressures as a CSV. Each of the data sets are computed at 0.8Mhz and the data listed by row is an maximum individual test, not a continous data set.
I am looking for gudiance on how to start this.
>> transfer function, biologics, curve fitting MATLAB Answers — New Questions
Error in Model Fitting
Hello! i have been to run this model fitting code but keeps on getting these error messages as:
FUN must have two input arguments.
userFcn_ME = initEvalErrorHandler(userFcn_ME,funfcn_x_xdata{3}, …
[params_fit, ~] = lsqcurvefit(obj_fun, params0, time, observed_I, [], [], options);
Find attached, the code,, Please help
function dydt = sir_model(t, y, beta, gamma)
S = y(1);
I = y(2);
R = y(3);
N = S + I + R; % Total population
dSdt = -beta * S * I / N;
dIdt = beta * S * I / N – gamma * I;
dRdt = gamma * I;
dydt = [dSdt; dIdt; dRdt];
end
function error = model_error(params, time, observed_I, y0)
beta = params(1);
gamma = params(2);
% Solve the differential equations
[~, y] = ode45(@(t, y) sir_model(t, y, beta, gamma), time, y0);
% Extract the infectious data from the solution
model_I = y(:, 2);
% Compute the error as the difference between model and observed data
error = model_I – observed_I’;
end
% Define the time vector and observed data
time = [0, 1, 2, 3, 4, 5]; % Example time points
observed_I = [10, 15, 20, 25, 30, 35]; % Example observed infectious data
% Initial guess for parameters
beta_guess = 0.3;
gamma_guess = 0.1;
params0 = [beta_guess, gamma_guess];
% Initial conditions
S0 = 1000; % Initial number of susceptible individuals
I0 = observed_I(1); % Initial number of infectious individuals
R0 = 0; % Initial number of recovered individuals
y0 = [S0; I0; R0];
% Define the objective function for fitting
obj_fun = @(params) model_error(params, time, observed_I, y0);
% Perform the curve fitting
options = optimoptions(‘lsqcurvefit’, ‘Display’, ‘off’);
[params_fit, ~] = lsqcurvefit(obj_fun, params0, time, observed_I, [], [], options);
% Display the fitted parameters
beta_fit = params_fit(1);
gamma_fit = params_fit(2);
disp([‘Fitted beta: ‘, num2str(beta_fit)]);
disp([‘Fitted gamma: ‘, num2str(gamma_fit)]);Hello! i have been to run this model fitting code but keeps on getting these error messages as:
FUN must have two input arguments.
userFcn_ME = initEvalErrorHandler(userFcn_ME,funfcn_x_xdata{3}, …
[params_fit, ~] = lsqcurvefit(obj_fun, params0, time, observed_I, [], [], options);
Find attached, the code,, Please help
function dydt = sir_model(t, y, beta, gamma)
S = y(1);
I = y(2);
R = y(3);
N = S + I + R; % Total population
dSdt = -beta * S * I / N;
dIdt = beta * S * I / N – gamma * I;
dRdt = gamma * I;
dydt = [dSdt; dIdt; dRdt];
end
function error = model_error(params, time, observed_I, y0)
beta = params(1);
gamma = params(2);
% Solve the differential equations
[~, y] = ode45(@(t, y) sir_model(t, y, beta, gamma), time, y0);
% Extract the infectious data from the solution
model_I = y(:, 2);
% Compute the error as the difference between model and observed data
error = model_I – observed_I’;
end
% Define the time vector and observed data
time = [0, 1, 2, 3, 4, 5]; % Example time points
observed_I = [10, 15, 20, 25, 30, 35]; % Example observed infectious data
% Initial guess for parameters
beta_guess = 0.3;
gamma_guess = 0.1;
params0 = [beta_guess, gamma_guess];
% Initial conditions
S0 = 1000; % Initial number of susceptible individuals
I0 = observed_I(1); % Initial number of infectious individuals
R0 = 0; % Initial number of recovered individuals
y0 = [S0; I0; R0];
% Define the objective function for fitting
obj_fun = @(params) model_error(params, time, observed_I, y0);
% Perform the curve fitting
options = optimoptions(‘lsqcurvefit’, ‘Display’, ‘off’);
[params_fit, ~] = lsqcurvefit(obj_fun, params0, time, observed_I, [], [], options);
% Display the fitted parameters
beta_fit = params_fit(1);
gamma_fit = params_fit(2);
disp([‘Fitted beta: ‘, num2str(beta_fit)]);
disp([‘Fitted gamma: ‘, num2str(gamma_fit)]); Hello! i have been to run this model fitting code but keeps on getting these error messages as:
FUN must have two input arguments.
userFcn_ME = initEvalErrorHandler(userFcn_ME,funfcn_x_xdata{3}, …
[params_fit, ~] = lsqcurvefit(obj_fun, params0, time, observed_I, [], [], options);
Find attached, the code,, Please help
function dydt = sir_model(t, y, beta, gamma)
S = y(1);
I = y(2);
R = y(3);
N = S + I + R; % Total population
dSdt = -beta * S * I / N;
dIdt = beta * S * I / N – gamma * I;
dRdt = gamma * I;
dydt = [dSdt; dIdt; dRdt];
end
function error = model_error(params, time, observed_I, y0)
beta = params(1);
gamma = params(2);
% Solve the differential equations
[~, y] = ode45(@(t, y) sir_model(t, y, beta, gamma), time, y0);
% Extract the infectious data from the solution
model_I = y(:, 2);
% Compute the error as the difference between model and observed data
error = model_I – observed_I’;
end
% Define the time vector and observed data
time = [0, 1, 2, 3, 4, 5]; % Example time points
observed_I = [10, 15, 20, 25, 30, 35]; % Example observed infectious data
% Initial guess for parameters
beta_guess = 0.3;
gamma_guess = 0.1;
params0 = [beta_guess, gamma_guess];
% Initial conditions
S0 = 1000; % Initial number of susceptible individuals
I0 = observed_I(1); % Initial number of infectious individuals
R0 = 0; % Initial number of recovered individuals
y0 = [S0; I0; R0];
% Define the objective function for fitting
obj_fun = @(params) model_error(params, time, observed_I, y0);
% Perform the curve fitting
options = optimoptions(‘lsqcurvefit’, ‘Display’, ‘off’);
[params_fit, ~] = lsqcurvefit(obj_fun, params0, time, observed_I, [], [], options);
% Display the fitted parameters
beta_fit = params_fit(1);
gamma_fit = params_fit(2);
disp([‘Fitted beta: ‘, num2str(beta_fit)]);
disp([‘Fitted gamma: ‘, num2str(gamma_fit)]); model fitting MATLAB Answers — New Questions
People contacts vanished
All my people contacts vanished my email provider is shaw.ca
All my people contacts vanished my email provider is shaw.ca Read More
Bookings Report Automation?
Here it is, August of 2024. We have multiple ai engines in existence. We have reusable space rockets. We have advanced robotics. We have VR headsets. What do we not have? An update to Microsoft Bookings reporting capabilities.
I’m in a government account environment, so Power Automate isn’t an option. MS Graph isn’t an option. We’re still operating off of a 2018 solution, an Excel connection to Online Exchange for reporting. We’re unable to access custom field data without manually running the .tsv report out of our 18 Bookings pages. Even doing so, the custom field entries are lumped into a single column. I’ve opened a support ticket to Microsoft inquiring if there is a better way to access custom field data. Microsoft’s answer was “no.”
Has anyone else out there figured out a workaround to automate access to custom field data in government account environments?
Here it is, August of 2024. We have multiple ai engines in existence. We have reusable space rockets. We have advanced robotics. We have VR headsets. What do we not have? An update to Microsoft Bookings reporting capabilities. I’m in a government account environment, so Power Automate isn’t an option. MS Graph isn’t an option. We’re still operating off of a 2018 solution, an Excel connection to Online Exchange for reporting. We’re unable to access custom field data without manually running the .tsv report out of our 18 Bookings pages. Even doing so, the custom field entries are lumped into a single column. I’ve opened a support ticket to Microsoft inquiring if there is a better way to access custom field data. Microsoft’s answer was “no.” Has anyone else out there figured out a workaround to automate access to custom field data in government account environments? Read More
How is the function FEEDBACK implemented in Matlab?
Hello together,
I used the function »feedback« to generate a closed-loop system, which worked well. Now I am trying to understand, how this function is mathematically implemented in Matlab. There are a lot of information’s, how to use the function, but I didn’t find anything which describes how it’s working and implemented mathematically. Does this function use iterative every sample from the output and add it to the input?
Thank you!Hello together,
I used the function »feedback« to generate a closed-loop system, which worked well. Now I am trying to understand, how this function is mathematically implemented in Matlab. There are a lot of information’s, how to use the function, but I didn’t find anything which describes how it’s working and implemented mathematically. Does this function use iterative every sample from the output and add it to the input?
Thank you! Hello together,
I used the function »feedback« to generate a closed-loop system, which worked well. Now I am trying to understand, how this function is mathematically implemented in Matlab. There are a lot of information’s, how to use the function, but I didn’t find anything which describes how it’s working and implemented mathematically. Does this function use iterative every sample from the output and add it to the input?
Thank you! feedback, closed loop, control MATLAB Answers — New Questions
Simulink Coder: Unknown type name mxarray
Hello. I have created a custom S Function block that outputs the sum of a user definable number of inputs and it works in simulation. The next step for me is to generate C code from it using Simulink Coder. For now I don’t want to inline the S function, I just want to test its autocoded functionality.
When I generate the src and header files and try to build an executable in eclipse I get the following errors:
unknown type name ‘RTWSfcnInfo’ in mymodel.h
unknown type name ‘mxarray’ in mymodel.h,simstruct_def.h, simstruct_internal.h
unknown type name ‘_ResolveVarFcn’ ini simstruct_def.h
#error unrecognized use in simstruct_compond.h
#error unhandled case in simstruct_compond.h
#error Must define one of RT, NRT, MATLAB_MEX_FILE, SL_INTERNAL, or FIPXT_SHARED_MODULE in simstruc_compcond.h
I have looked for a solution online and for other people this was solved by including mex.h – I have tried it and it did not work.
Thanks in advance!Hello. I have created a custom S Function block that outputs the sum of a user definable number of inputs and it works in simulation. The next step for me is to generate C code from it using Simulink Coder. For now I don’t want to inline the S function, I just want to test its autocoded functionality.
When I generate the src and header files and try to build an executable in eclipse I get the following errors:
unknown type name ‘RTWSfcnInfo’ in mymodel.h
unknown type name ‘mxarray’ in mymodel.h,simstruct_def.h, simstruct_internal.h
unknown type name ‘_ResolveVarFcn’ ini simstruct_def.h
#error unrecognized use in simstruct_compond.h
#error unhandled case in simstruct_compond.h
#error Must define one of RT, NRT, MATLAB_MEX_FILE, SL_INTERNAL, or FIPXT_SHARED_MODULE in simstruc_compcond.h
I have looked for a solution online and for other people this was solved by including mex.h – I have tried it and it did not work.
Thanks in advance! Hello. I have created a custom S Function block that outputs the sum of a user definable number of inputs and it works in simulation. The next step for me is to generate C code from it using Simulink Coder. For now I don’t want to inline the S function, I just want to test its autocoded functionality.
When I generate the src and header files and try to build an executable in eclipse I get the following errors:
unknown type name ‘RTWSfcnInfo’ in mymodel.h
unknown type name ‘mxarray’ in mymodel.h,simstruct_def.h, simstruct_internal.h
unknown type name ‘_ResolveVarFcn’ ini simstruct_def.h
#error unrecognized use in simstruct_compond.h
#error unhandled case in simstruct_compond.h
#error Must define one of RT, NRT, MATLAB_MEX_FILE, SL_INTERNAL, or FIPXT_SHARED_MODULE in simstruc_compcond.h
I have looked for a solution online and for other people this was solved by including mex.h – I have tried it and it did not work.
Thanks in advance! simulink, embedded coder, s-function MATLAB Answers — New Questions
Scaling dependence using equilibrate function
I want to use the function equilibrate, but I don’t understand the following written in Rescaling to Solve a Linear System.
"equilibrate is most useful when the scales of the b and x vectors in the original system x = Ab are irrelevant. However, if the scales of b and x are relevant, then using equilibrate to rescale A only for the linear system solve is not recommended. The obtained solution does not generally yield a small residual for the original system, even if expressed using the original basis vectors."
Could someone explain the meaning of this with an example?I want to use the function equilibrate, but I don’t understand the following written in Rescaling to Solve a Linear System.
"equilibrate is most useful when the scales of the b and x vectors in the original system x = Ab are irrelevant. However, if the scales of b and x are relevant, then using equilibrate to rescale A only for the linear system solve is not recommended. The obtained solution does not generally yield a small residual for the original system, even if expressed using the original basis vectors."
Could someone explain the meaning of this with an example? I want to use the function equilibrate, but I don’t understand the following written in Rescaling to Solve a Linear System.
"equilibrate is most useful when the scales of the b and x vectors in the original system x = Ab are irrelevant. However, if the scales of b and x are relevant, then using equilibrate to rescale A only for the linear system solve is not recommended. The obtained solution does not generally yield a small residual for the original system, even if expressed using the original basis vectors."
Could someone explain the meaning of this with an example? matrices MATLAB Answers — New Questions
How to make an individual cell change red or green based on value in the cell
As you can see here i have the percents of made putts displayed next to the pro average and scratch golfers percents. I would like to turn the cells green or red based on if they are equal or greater to the scratch golfers.
As you can see here i have the percents of made putts displayed next to the pro average and scratch golfers percents. I would like to turn the cells green or red based on if they are equal or greater to the scratch golfers. Read More
toggle and elseif in matlab
Try adding a variable doDisplay to toggle if the densities are displayed. Add this condition with an elseif block.
i do not understand what we are supposed to do in the above question(bold). this question is a part of futher practice in mathlab oramp. decision branching topic futher practice section in matworks course for basic matlab. how do i solve tha bove question
https://matlabacademy.mathworks.com/R2019b/portal.html?course=gettingstarted#chapter=13&lesson=2§ion=1Try adding a variable doDisplay to toggle if the densities are displayed. Add this condition with an elseif block.
i do not understand what we are supposed to do in the above question(bold). this question is a part of futher practice in mathlab oramp. decision branching topic futher practice section in matworks course for basic matlab. how do i solve tha bove question
https://matlabacademy.mathworks.com/R2019b/portal.html?course=gettingstarted#chapter=13&lesson=2§ion=1 Try adding a variable doDisplay to toggle if the densities are displayed. Add this condition with an elseif block.
i do not understand what we are supposed to do in the above question(bold). this question is a part of futher practice in mathlab oramp. decision branching topic futher practice section in matworks course for basic matlab. how do i solve tha bove question
https://matlabacademy.mathworks.com/R2019b/portal.html?course=gettingstarted#chapter=13&lesson=2§ion=1 elseif, toggle, decision branching MATLAB Answers — New Questions
How to find the roots of a non-polynomial equation in terms of symbolic variables ?
want to find the values of ‘K’ for which the function (D) becomes zero. ‘L’ and ‘a’ are the constants. Code:
syms A B L K a
D = [cosh(K*L)-cos(K*L), sinh(K*L)-sin(K*L); sinh(K*L)+sin(K*L)+K*a*L*(cosh(K*L)+cos(K*L)), cosh(K*L)-cos(K*L)+K*a*L*(sinh(K*L)+sin(K*L))];
d = det(D)
fzero(@(K) d, 10)
Error using fzero (line 309) Function value at starting guess must be finite and real.want to find the values of ‘K’ for which the function (D) becomes zero. ‘L’ and ‘a’ are the constants. Code:
syms A B L K a
D = [cosh(K*L)-cos(K*L), sinh(K*L)-sin(K*L); sinh(K*L)+sin(K*L)+K*a*L*(cosh(K*L)+cos(K*L)), cosh(K*L)-cos(K*L)+K*a*L*(sinh(K*L)+sin(K*L))];
d = det(D)
fzero(@(K) d, 10)
Error using fzero (line 309) Function value at starting guess must be finite and real. want to find the values of ‘K’ for which the function (D) becomes zero. ‘L’ and ‘a’ are the constants. Code:
syms A B L K a
D = [cosh(K*L)-cos(K*L), sinh(K*L)-sin(K*L); sinh(K*L)+sin(K*L)+K*a*L*(cosh(K*L)+cos(K*L)), cosh(K*L)-cos(K*L)+K*a*L*(sinh(K*L)+sin(K*L))];
d = det(D)
fzero(@(K) d, 10)
Error using fzero (line 309) Function value at starting guess must be finite and real. roots, non-polynomial MATLAB Answers — New Questions
Can’t do any courses on Mac
Whenever I open MATLAB Onramp or Simulink Onramp or any other courses I can’t get past the first page. Sometimes I can play the introductory video but afterwards the pointer cursor dissapears and I can’t interact with anything on the page and have to quit the tab. This has occured on the two most recent versions on three different browsers, I have cleared my cache for MATLAB and I am on macOS Sonoma.Whenever I open MATLAB Onramp or Simulink Onramp or any other courses I can’t get past the first page. Sometimes I can play the introductory video but afterwards the pointer cursor dissapears and I can’t interact with anything on the page and have to quit the tab. This has occured on the two most recent versions on three different browsers, I have cleared my cache for MATLAB and I am on macOS Sonoma. Whenever I open MATLAB Onramp or Simulink Onramp or any other courses I can’t get past the first page. Sometimes I can play the introductory video but afterwards the pointer cursor dissapears and I can’t interact with anything on the page and have to quit the tab. This has occured on the two most recent versions on three different browsers, I have cleared my cache for MATLAB and I am on macOS Sonoma. matlab MATLAB Answers — New Questions
COUNTIFS returns #VALUE!. Each of the criteria works in its countif. Reason: compare span 2 cols.
Hi: I have a COUNTIFS return #VALUE! when each of the 2 criteria would work in a COUNTIF on its own.
So, =COUNTIF($B$6:$C$33,”Apple”) and =COUNTIF($D$6:$D$33,”US”) both work on their own each return the count of rows satisfy the condition.
But if I combine the 2 criteria in a =COUNTIFS($B$6:$C$33,”Apple”,$D$6:$D$33,”US”), this will return #VALUE!
I’ve debugged and found is the criteria spanned 2 columns. If I adjust to only search within 1 column, the countifs works.
So, changing from:
=COUNTIFS($B$6:$C$33,”Apple”,$D$6:$D$33,”US”)
to:
=COUNTIFS($B$6:$B$33,”Apple”,$D$6:$D$33,”US”)
now works. So, I need to combine my Col B and Col C into a consolidated Column.
Wanted to check, is this by design? thnx –LC
I have MS 365 Apps for enterprise.
Hi: I have a COUNTIFS return #VALUE! when each of the 2 criteria would work in a COUNTIF on its own.So, =COUNTIF($B$6:$C$33,”Apple”) and =COUNTIF($D$6:$D$33,”US”) both work on their own each return the count of rows satisfy the condition.But if I combine the 2 criteria in a =COUNTIFS($B$6:$C$33,”Apple”,$D$6:$D$33,”US”), this will return #VALUE! I’ve debugged and found is the criteria spanned 2 columns. If I adjust to only search within 1 column, the countifs works.So, changing from:=COUNTIFS($B$6:$C$33,”Apple”,$D$6:$D$33,”US”)to:=COUNTIFS($B$6:$B$33,”Apple”,$D$6:$D$33,”US”)now works. So, I need to combine my Col B and Col C into a consolidated Column. Wanted to check, is this by design? thnx –LCI have MS 365 Apps for enterprise. Read More
To find the Missing rows
Every CEO should have both ‘SEYT’ and ‘ZZZZ’ records in Acc_Personal. I want to find any CEO record if anyone is missing ‘ZZZZ’ record. See table below.
CREATE TABLE DBO.TMP (CEO VARCHAR(20), Acc_Personal VARCHAR(20), AMT INT, DATEA DATETIME, STAT VARCHAR(1))
INSERT INTO DBO.TMP VALUES (‘10001′,’SEYT’,78, ‘2024-04-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10001′,’ZZZZ’,12, ‘2024-03-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10002′,’SEYT’,45, ‘2024-06-02′,’N’
INSERT INTO DBO.TMP VALUES (‘10002′,’ZZZZ’,55, ‘2024-07-07′,’D’
INSERT INTO DBO.TMP VALUES (‘10003′,’SEYT’,76, ‘2024-08-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10004′,’SEYT’,45, ‘2024-04-02′,’C’
INSERT INTO DBO.TMP VALUES (‘10004′,’ZZZZ’,21, ‘2024-07-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10005′,’SEYT’,57, ‘2024-04-01′,’N’
INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,59, ‘2024-04-01′,’B’
INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,47, ‘2024-02-01′,’A’
INSERT INTO DBO.TMP VALUES (‘10007′,’SEYT’,59, ‘2024-04-09′,’N’
Desired Output
—————–
CEO Acc_personal AMT DATEA STAT
1003
1005
1007
Every CEO should have both ‘SEYT’ and ‘ZZZZ’ records in Acc_Personal. I want to find any CEO record if anyone is missing ‘ZZZZ’ record. See table below. CREATE TABLE DBO.TMP (CEO VARCHAR(20), Acc_Personal VARCHAR(20), AMT INT, DATEA DATETIME, STAT VARCHAR(1)) INSERT INTO DBO.TMP VALUES (‘10001′,’SEYT’,78, ‘2024-04-09’,’N’INSERT INTO DBO.TMP VALUES (‘10001′,’ZZZZ’,12, ‘2024-03-09’,’N’INSERT INTO DBO.TMP VALUES (‘10002′,’SEYT’,45, ‘2024-06-02’,’N’INSERT INTO DBO.TMP VALUES (‘10002′,’ZZZZ’,55, ‘2024-07-07’,’D’INSERT INTO DBO.TMP VALUES (‘10003′,’SEYT’,76, ‘2024-08-09’,’N’INSERT INTO DBO.TMP VALUES (‘10004′,’SEYT’,45, ‘2024-04-02’,’C’INSERT INTO DBO.TMP VALUES (‘10004′,’ZZZZ’,21, ‘2024-07-09’,’N’INSERT INTO DBO.TMP VALUES (‘10005′,’SEYT’,57, ‘2024-04-01’,’N’INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,59, ‘2024-04-01’,’B’INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,47, ‘2024-02-01’,’A’INSERT INTO DBO.TMP VALUES (‘10007′,’SEYT’,59, ‘2024-04-09′,’N’ Desired Output—————–CEO Acc_personal AMT DATEA STAT100310051007 Read More
Microsoft 365 and Microsoft Office 2024 LTSC support on Windows Server 2025
For now, it is not clear if Microsoft 365 apps shall be supported on Windows Server 2025, at least during the mainstream support of the OS, although earlier there statements that said that they will be supported.
Microsoft Office 2024 LTSC does not include Windows Server 2025 as a supported OS. Would this mean it shall not be installable? Perhaps a the limited Microsoft 365 model shall be applied? I am interested in having office apps installed for offline use, on demand, on Windows Server 2025. Are there any clear and recent information on this topic?
For now, it is not clear if Microsoft 365 apps shall be supported on Windows Server 2025, at least during the mainstream support of the OS, although earlier there statements that said that they will be supported.Microsoft Office 2024 LTSC does not include Windows Server 2025 as a supported OS. Would this mean it shall not be installable? Perhaps a the limited Microsoft 365 model shall be applied? I am interested in having office apps installed for offline use, on demand, on Windows Server 2025. Are there any clear and recent information on this topic? Read More
Is code generation supported for “convolution1DLayer”?
Is code generation supported for "convolution1DLayer"?Is code generation supported for "convolution1DLayer"? Is code generation supported for "convolution1DLayer"? code, generation, convolution1dlayer, convolution, 1d, layer, deep, learning, neural, network, matlab, coder, spatial, temporal MATLAB Answers — New Questions
gwagwagagwa wag wa aggwagw
gwawagaggwawagag gwawagag thingspeak MATLAB Answers — New Questions
Having partial text in a cell change to bold.
I’m trying to have Excel bold the text after “MM ” in a cell. I would like to have it do this for the entire range. Right now I’m doing it manually. Here is an image of my worksheet.
Any help would be appreciated.
Thank you.
Scott
I’m trying to have Excel bold the text after “MM ” in a cell. I would like to have it do this for the entire range. Right now I’m doing it manually. Here is an image of my worksheet.Any help would be appreciated.Thank you.Scott Read More
Number format problem for large amounts of tim
I have a table with per line; Article (text), Quantity (integer or default value), unit time (in hours and minutes), total time (in number of months, number of days, number of hours, and number of minutes). The unit time can be 1 min, 5 min, 1 hour, 3 hours or 8 hours (1 table line per unit time quantity). The total time of the line is equal to the quantity multiplied by the unit time. Of course, at the bottom of the column, I add the total sum of all time totals for each line. The problem that arises concerns the format of the numbers for the time totals. It’s one of two things.
If my total time is greater than 31 days and I have used a customized format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (for example, if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month).
If this is not the case, there are two possible outcomes:
– If my customized format includes the number of months, the number of months is automatically set to 1, even if the cumulative time of my line is only one minute. Furthermore, if the accumulated time exceeds 1 month by even one minute, the number of months displayed will be 2, and so on.
– If my cumulative time is greater than 31 days and I’ve used a custom format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (e.g. if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month).
Hence my question: Is there a simple way of solving this problem?
I have a table with per line; Article (text), Quantity (integer or default value), unit time (in hours and minutes), total time (in number of months, number of days, number of hours, and number of minutes). The unit time can be 1 min, 5 min, 1 hour, 3 hours or 8 hours (1 table line per unit time quantity). The total time of the line is equal to the quantity multiplied by the unit time. Of course, at the bottom of the column, I add the total sum of all time totals for each line. The problem that arises concerns the format of the numbers for the time totals. It’s one of two things. If my total time is greater than 31 days and I have used a customized format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (for example, if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month). If this is not the case, there are two possible outcomes:- If my customized format includes the number of months, the number of months is automatically set to 1, even if the cumulative time of my line is only one minute. Furthermore, if the accumulated time exceeds 1 month by even one minute, the number of months displayed will be 2, and so on.- If my cumulative time is greater than 31 days and I’ve used a custom format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (e.g. if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month). Hence my question: Is there a simple way of solving this problem? Read More
Help to find in sequence issue in groups records
Hi, Every group_cost has different sequence of PP_Seq but it should not be any gap in the sequence of any group_cost rcords. It should always be increment by 1. I want to see any record/row of any group_cost if it has any issue in pp_seq and not increment by 1. I want to see when the issue of sequence is started then it will be corrected with other next rows.
Create table #Cost (group_cost char(10), PP_Seq int, date1 datetime, ST char(2))
insert into #cost (‘T1′,5,’2023-01-01′,’A’)
insert into #cost (‘T1′,6,’2023-02-01′,’A’)
insert into #cost (‘T1′,7,’2023-03-01′,’A’)
insert into #cost (‘T2′,12,’2023-01-01′,’A’)
insert into #cost (‘T2′,14,’2023-02-01′,’B’) — This pp_seq is not increment by 1. Should be in output
insert into #cost (‘T2′,15,’2023-03-01′,’A’)
insert into #cost (‘T3′,25,’2023-01-02′,’A’)
insert into #cost (‘T3′,26,’2023-02-01′,’A’)
insert into #cost (‘T3′,27,’2023-03-05′,’A’)
insert into #cost (‘T5′,65,’2023-01-01′,’A’)
insert into #cost (‘T5′,66,’2023-02-06′,’A’)
insert into #cost (‘T5′,67,’2023-03-04′,’W’)
insert into #cost (‘T5′,69,’2023-04-01′,’A’) — This pp_seq is not increment by 1. Should be in output
–Expected result
group_cost PP_Seq date1 ST Comments
T2 14 2023-02-01 B PP_Seq is not in seq. Also check next rows to correct.
T5 69 2023-04-01 A PP_Seq is not in seq. Also check next rows to correct.
Hi, Every group_cost has different sequence of PP_Seq but it should not be any gap in the sequence of any group_cost rcords. It should always be increment by 1. I want to see any record/row of any group_cost if it has any issue in pp_seq and not increment by 1. I want to see when the issue of sequence is started then it will be corrected with other next rows. Create table #Cost (group_cost char(10), PP_Seq int, date1 datetime, ST char(2))insert into #cost (‘T1′,5,’2023-01-01′,’A’)insert into #cost (‘T1′,6,’2023-02-01′,’A’)insert into #cost (‘T1′,7,’2023-03-01′,’A’) insert into #cost (‘T2′,12,’2023-01-01′,’A’)insert into #cost (‘T2′,14,’2023-02-01′,’B’) — This pp_seq is not increment by 1. Should be in output insert into #cost (‘T2′,15,’2023-03-01′,’A’) insert into #cost (‘T3′,25,’2023-01-02′,’A’)insert into #cost (‘T3′,26,’2023-02-01′,’A’)insert into #cost (‘T3′,27,’2023-03-05′,’A’) insert into #cost (‘T5′,65,’2023-01-01′,’A’)insert into #cost (‘T5′,66,’2023-02-06′,’A’)insert into #cost (‘T5′,67,’2023-03-04′,’W’)insert into #cost (‘T5′,69,’2023-04-01′,’A’) — This pp_seq is not increment by 1. Should be in output –Expected resultgroup_cost PP_Seq date1 ST CommentsT2 14 2023-02-01 B PP_Seq is not in seq. Also check next rows to correct. T5 69 2023-04-01 A PP_Seq is not in seq. Also check next rows to correct. Read More
