Month: July 2024
Help designing very low pass filters (sub-mHz) for long time series
I am relatively new to filter design so patience is appreciated.
I have an extremely long time series (e.g. ~100 million data points) with a sample rate of 0.2 Hz and I want to apply a series of lowpass filters to the signal at query frequencies of e.g. 1/10 Hz, 1/100 Hz, 1/1000 Hz, 1/10000 Hz, and so on. However, the filtered datasets look roughly identical regardless of what lowpass filter I use.
Fig 1: Zoom view of section of time series to show small differences in filtered time series.
The spectrum of the signal suggests that there is plenty of power at the lower frequencies, so I would think that the results should be different depending on which lowpass cutoff I use.
Fig 2: Spectrum of signal
I wonder if it has something to do with trying to filter sub-mHz levels. Most of the filter questions/answers that I have found are dealing with audio sampling and much higher frequencies. Are there some defaults in MATLAB which design filters to be better behaved at higher frequencies and these assumptions break down at lower frequencies?
I have not done filter design before. All my previous filtering experiences has just used plug-and-play MATLAB functions like lowpass, highpass, bandpass. How would I go about designing an adequate filter for these low frequency signals?
Alternatively, is there nothing wrong with the result and my intuition about what the filter results should look like is just wrong?
Any help is appreciated.I am relatively new to filter design so patience is appreciated.
I have an extremely long time series (e.g. ~100 million data points) with a sample rate of 0.2 Hz and I want to apply a series of lowpass filters to the signal at query frequencies of e.g. 1/10 Hz, 1/100 Hz, 1/1000 Hz, 1/10000 Hz, and so on. However, the filtered datasets look roughly identical regardless of what lowpass filter I use.
Fig 1: Zoom view of section of time series to show small differences in filtered time series.
The spectrum of the signal suggests that there is plenty of power at the lower frequencies, so I would think that the results should be different depending on which lowpass cutoff I use.
Fig 2: Spectrum of signal
I wonder if it has something to do with trying to filter sub-mHz levels. Most of the filter questions/answers that I have found are dealing with audio sampling and much higher frequencies. Are there some defaults in MATLAB which design filters to be better behaved at higher frequencies and these assumptions break down at lower frequencies?
I have not done filter design before. All my previous filtering experiences has just used plug-and-play MATLAB functions like lowpass, highpass, bandpass. How would I go about designing an adequate filter for these low frequency signals?
Alternatively, is there nothing wrong with the result and my intuition about what the filter results should look like is just wrong?
Any help is appreciated. I am relatively new to filter design so patience is appreciated.
I have an extremely long time series (e.g. ~100 million data points) with a sample rate of 0.2 Hz and I want to apply a series of lowpass filters to the signal at query frequencies of e.g. 1/10 Hz, 1/100 Hz, 1/1000 Hz, 1/10000 Hz, and so on. However, the filtered datasets look roughly identical regardless of what lowpass filter I use.
Fig 1: Zoom view of section of time series to show small differences in filtered time series.
The spectrum of the signal suggests that there is plenty of power at the lower frequencies, so I would think that the results should be different depending on which lowpass cutoff I use.
Fig 2: Spectrum of signal
I wonder if it has something to do with trying to filter sub-mHz levels. Most of the filter questions/answers that I have found are dealing with audio sampling and much higher frequencies. Are there some defaults in MATLAB which design filters to be better behaved at higher frequencies and these assumptions break down at lower frequencies?
I have not done filter design before. All my previous filtering experiences has just used plug-and-play MATLAB functions like lowpass, highpass, bandpass. How would I go about designing an adequate filter for these low frequency signals?
Alternatively, is there nothing wrong with the result and my intuition about what the filter results should look like is just wrong?
Any help is appreciated. filter, time series, fft, data, signal processing MATLAB Answers — New Questions
MATLAB recommended me to download the latest pre-released version is there any difference between that and the normal versions
NilNil Nil nil MATLAB Answers — New Questions
New Teams Uninstalling After Reboot
I am having an issue in our environment with the New MS Teams uninstalling itself after rebooting, or if a user is working within their Windows profile. This is issue just started occurring 06/06/2024. Here are the following troubleshooting steps I have tried to resolve the issue with no prevail.
• Isolated the issue to domain-joined machines.
• Uninstalled and reinstalled the Teams client.
• Removed the Classic Teams client and Teams System-Wide Installer.
• Deleted all Classic Teams program data folders, including AppData and any Teams Addin folder.
• Verified that there are no Group Policies managing or deploying the new Teams.
• Managed the new Teams deployment in Intune via an Entra ID security group and removed the group associated with the application package.
• Confirmed that ME Endpoint Central has no configurations or updates managing the new Teams.
• Deployed the latest May and June 2024 Cumulative Security updates to test machines, but the new Teams client still uninstalls after rebooting.
• Repaired the Edge Webview2 Runtime component.
• Checked application logs; none are associated with Teams.
• Moved a test machine from the “Workstation OU” to the “Test OU” to bypass the Endpoint Central Agent push by group policy, rebooted with and without the Endpoint Central agent, but the new Teams client still uninstalled.
• Reviewed the Teams Update Policy in the Teams Admin Center; it is set to update all users within the organization to the new Teams.
• Removed the Endpoint Central agent from his machine, rebooted, and the new Teams client did not uninstall. However, it uninstalled overnight once he connected to the domain the following day.
• Raised support tickets with ME Endpoint Central and Microsoft to check machine logs.
If anyone knows anything, any help would be greatly appreciated.
I am having an issue in our environment with the New MS Teams uninstalling itself after rebooting, or if a user is working within their Windows profile. This is issue just started occurring 06/06/2024. Here are the following troubleshooting steps I have tried to resolve the issue with no prevail. • Isolated the issue to domain-joined machines.• Uninstalled and reinstalled the Teams client.• Removed the Classic Teams client and Teams System-Wide Installer.• Deleted all Classic Teams program data folders, including AppData and any Teams Addin folder.• Verified that there are no Group Policies managing or deploying the new Teams.• Managed the new Teams deployment in Intune via an Entra ID security group and removed the group associated with the application package.• Confirmed that ME Endpoint Central has no configurations or updates managing the new Teams.• Deployed the latest May and June 2024 Cumulative Security updates to test machines, but the new Teams client still uninstalls after rebooting.• Repaired the Edge Webview2 Runtime component.• Checked application logs; none are associated with Teams.• Moved a test machine from the “Workstation OU” to the “Test OU” to bypass the Endpoint Central Agent push by group policy, rebooted with and without the Endpoint Central agent, but the new Teams client still uninstalled.• Reviewed the Teams Update Policy in the Teams Admin Center; it is set to update all users within the organization to the new Teams.• Removed the Endpoint Central agent from his machine, rebooted, and the new Teams client did not uninstall. However, it uninstalled overnight once he connected to the domain the following day.• Raised support tickets with ME Endpoint Central and Microsoft to check machine logs. If anyone knows anything, any help would be greatly appreciated. Read More
Need to extract boundary layer thickness from 2D planar PIV data.
This is 2D Planar PIV data at a freestream velocity of ~ 13 m/s.
My code currently selects a velocity profile where max(profile_u) = 12.41 m/s. I want to use a velocity profile where max(profile_u) is closer to 13 m/s.
Scatter(u,y) will show all the velocity profiles I am working with.
clc;
close all;
clear all;
%% BASELINE
% Load the data
opts = detectImportOptions(‘FlatPlate_Baseline_avg0001(in).csv’);
opts.VariableNamingRule = ‘preserve’;
data = readtable(‘FlatPlate_Baseline_avg0001(in).csv’, opts);
% Extract variables
x = data.x / 1000; % Convert to meters
y = data.y / 1000; % Convert to meters
u = data.u;
v = data.v;
%%
% Filter data for x values between 0.05m to 0.08m
filter_indices = (x >= 0.05) & (x <= 0.08);
x_filtered = x(filter_indices);
y_filtered = y(filter_indices);
u_filtered = u(filter_indices);
v_filtered = v(filter_indices);
% Find unique x and y values within the filtered range
unique_x = unique(x_filtered);
unique_y = unique(y_filtered);
nu = 1.5e-5;
kappa = 0.41;
B = 5.0;
profile_spacing = 2 / 1000;
profile_x_positions = unique_x(unique_x >= 0.05);
wall_shear_stress = zeros(size(profile_x_positions));
u_tau_values = zeros(size(profile_x_positions));
delta_99_values = zeros(size(profile_x_positions));
delta_star_values = zeros(size(profile_x_positions)); % Displacement thickness
theta_values = zeros(size(profile_x_positions)); % Momentum thickness
for i = 1:length(profile_x_positions)
profile_indices = find(abs(x – profile_x_positions(i)) < 1e-6);
profile_y = y(profile_indices);
profile_u = u(profile_indices);
valid_indices = profile_y > 0 & profile_y * max(profile_u) / nu > 1e-6;
profile_y = profile_y(valid_indices);
profile_u = profile_u(valid_indices);
if isempty(profile_y) || isempty(profile_u)
fprintf(‘No valid data points at x = %f meters. Skipping…n’, profile_x_positions(i));
continue;
end
% Estimate u_inf (freestream velocity) as the max value of the profile
u_inf = max(profile_u);
% f(eta) = u / u_inf
f_eta = profile_u / u_inf;
[f_eta_unique, unique_indices] = unique(f_eta);
profile_y_unique = profile_y(unique_indices);
% Find y_99 where f(eta) = 0.99
y_99 = interp1(f_eta_unique, profile_y_unique, 0.99, ‘linear’, ‘extrap’);
eta_99 = 0.99;
% delta_99
delta_99 = y_99 / eta_99;
delta_99_values(i) = delta_99;
% displacement thickness (delta_star)
delta_star = abs(trapz(profile_y, (1 – f_eta)));
delta_star_values(i) = delta_star;
% momentum thickness (theta)
theta = abs(trapz(profile_y, f_eta .* (1 – f_eta)));
theta_values(i) = theta;
Re_theta = (u_inf * theta)/nu;
% Calculate wall shear stress and friction velocity
fun_u_tau = @(u_tau) mean(profile_u – (u_tau / kappa) * log(profile_y * u_tau / nu + 1) – B * u_tau);
try
options = optimset(‘Display’, ‘off’);
u_tau = fzero(fun_u_tau, [0.01, 10], options);
u_tau_values(i) = u_tau;
catch err
fprintf(‘Cannot converge at x = %f meters: %sn’, profile_x_positions(i), err.message);
continue;
end
rho = 1.225;
tau_wall = rho * u_tau^2;
wall_shear_stress(i) = tau_wall;
% % Plot y/delta vs u/u_inf
% figure;
% y_over_delta = profile_y / delta_99;
% u_over_u_inf = profile_u / u_inf;
% plot(u_over_u_inf, y_over_delta, ‘-o’);
% title(sprintf(‘Velocity Profile at x = %.3f meters’, profile_x_positions(i)));
% xlabel(‘u / u_{infty}’);
% ylabel(‘y / delta’);
% grid on;
end
% Display the results
results_table = table(profile_x_positions, delta_99_values, delta_star_values, theta_values);
disp(results_table);
disp([‘Momentum Thickness Reynolds Number (Re_theta): ‘, num2str(Re_theta)]);This is 2D Planar PIV data at a freestream velocity of ~ 13 m/s.
My code currently selects a velocity profile where max(profile_u) = 12.41 m/s. I want to use a velocity profile where max(profile_u) is closer to 13 m/s.
Scatter(u,y) will show all the velocity profiles I am working with.
clc;
close all;
clear all;
%% BASELINE
% Load the data
opts = detectImportOptions(‘FlatPlate_Baseline_avg0001(in).csv’);
opts.VariableNamingRule = ‘preserve’;
data = readtable(‘FlatPlate_Baseline_avg0001(in).csv’, opts);
% Extract variables
x = data.x / 1000; % Convert to meters
y = data.y / 1000; % Convert to meters
u = data.u;
v = data.v;
%%
% Filter data for x values between 0.05m to 0.08m
filter_indices = (x >= 0.05) & (x <= 0.08);
x_filtered = x(filter_indices);
y_filtered = y(filter_indices);
u_filtered = u(filter_indices);
v_filtered = v(filter_indices);
% Find unique x and y values within the filtered range
unique_x = unique(x_filtered);
unique_y = unique(y_filtered);
nu = 1.5e-5;
kappa = 0.41;
B = 5.0;
profile_spacing = 2 / 1000;
profile_x_positions = unique_x(unique_x >= 0.05);
wall_shear_stress = zeros(size(profile_x_positions));
u_tau_values = zeros(size(profile_x_positions));
delta_99_values = zeros(size(profile_x_positions));
delta_star_values = zeros(size(profile_x_positions)); % Displacement thickness
theta_values = zeros(size(profile_x_positions)); % Momentum thickness
for i = 1:length(profile_x_positions)
profile_indices = find(abs(x – profile_x_positions(i)) < 1e-6);
profile_y = y(profile_indices);
profile_u = u(profile_indices);
valid_indices = profile_y > 0 & profile_y * max(profile_u) / nu > 1e-6;
profile_y = profile_y(valid_indices);
profile_u = profile_u(valid_indices);
if isempty(profile_y) || isempty(profile_u)
fprintf(‘No valid data points at x = %f meters. Skipping…n’, profile_x_positions(i));
continue;
end
% Estimate u_inf (freestream velocity) as the max value of the profile
u_inf = max(profile_u);
% f(eta) = u / u_inf
f_eta = profile_u / u_inf;
[f_eta_unique, unique_indices] = unique(f_eta);
profile_y_unique = profile_y(unique_indices);
% Find y_99 where f(eta) = 0.99
y_99 = interp1(f_eta_unique, profile_y_unique, 0.99, ‘linear’, ‘extrap’);
eta_99 = 0.99;
% delta_99
delta_99 = y_99 / eta_99;
delta_99_values(i) = delta_99;
% displacement thickness (delta_star)
delta_star = abs(trapz(profile_y, (1 – f_eta)));
delta_star_values(i) = delta_star;
% momentum thickness (theta)
theta = abs(trapz(profile_y, f_eta .* (1 – f_eta)));
theta_values(i) = theta;
Re_theta = (u_inf * theta)/nu;
% Calculate wall shear stress and friction velocity
fun_u_tau = @(u_tau) mean(profile_u – (u_tau / kappa) * log(profile_y * u_tau / nu + 1) – B * u_tau);
try
options = optimset(‘Display’, ‘off’);
u_tau = fzero(fun_u_tau, [0.01, 10], options);
u_tau_values(i) = u_tau;
catch err
fprintf(‘Cannot converge at x = %f meters: %sn’, profile_x_positions(i), err.message);
continue;
end
rho = 1.225;
tau_wall = rho * u_tau^2;
wall_shear_stress(i) = tau_wall;
% % Plot y/delta vs u/u_inf
% figure;
% y_over_delta = profile_y / delta_99;
% u_over_u_inf = profile_u / u_inf;
% plot(u_over_u_inf, y_over_delta, ‘-o’);
% title(sprintf(‘Velocity Profile at x = %.3f meters’, profile_x_positions(i)));
% xlabel(‘u / u_{infty}’);
% ylabel(‘y / delta’);
% grid on;
end
% Display the results
results_table = table(profile_x_positions, delta_99_values, delta_star_values, theta_values);
disp(results_table);
disp([‘Momentum Thickness Reynolds Number (Re_theta): ‘, num2str(Re_theta)]); This is 2D Planar PIV data at a freestream velocity of ~ 13 m/s.
My code currently selects a velocity profile where max(profile_u) = 12.41 m/s. I want to use a velocity profile where max(profile_u) is closer to 13 m/s.
Scatter(u,y) will show all the velocity profiles I am working with.
clc;
close all;
clear all;
%% BASELINE
% Load the data
opts = detectImportOptions(‘FlatPlate_Baseline_avg0001(in).csv’);
opts.VariableNamingRule = ‘preserve’;
data = readtable(‘FlatPlate_Baseline_avg0001(in).csv’, opts);
% Extract variables
x = data.x / 1000; % Convert to meters
y = data.y / 1000; % Convert to meters
u = data.u;
v = data.v;
%%
% Filter data for x values between 0.05m to 0.08m
filter_indices = (x >= 0.05) & (x <= 0.08);
x_filtered = x(filter_indices);
y_filtered = y(filter_indices);
u_filtered = u(filter_indices);
v_filtered = v(filter_indices);
% Find unique x and y values within the filtered range
unique_x = unique(x_filtered);
unique_y = unique(y_filtered);
nu = 1.5e-5;
kappa = 0.41;
B = 5.0;
profile_spacing = 2 / 1000;
profile_x_positions = unique_x(unique_x >= 0.05);
wall_shear_stress = zeros(size(profile_x_positions));
u_tau_values = zeros(size(profile_x_positions));
delta_99_values = zeros(size(profile_x_positions));
delta_star_values = zeros(size(profile_x_positions)); % Displacement thickness
theta_values = zeros(size(profile_x_positions)); % Momentum thickness
for i = 1:length(profile_x_positions)
profile_indices = find(abs(x – profile_x_positions(i)) < 1e-6);
profile_y = y(profile_indices);
profile_u = u(profile_indices);
valid_indices = profile_y > 0 & profile_y * max(profile_u) / nu > 1e-6;
profile_y = profile_y(valid_indices);
profile_u = profile_u(valid_indices);
if isempty(profile_y) || isempty(profile_u)
fprintf(‘No valid data points at x = %f meters. Skipping…n’, profile_x_positions(i));
continue;
end
% Estimate u_inf (freestream velocity) as the max value of the profile
u_inf = max(profile_u);
% f(eta) = u / u_inf
f_eta = profile_u / u_inf;
[f_eta_unique, unique_indices] = unique(f_eta);
profile_y_unique = profile_y(unique_indices);
% Find y_99 where f(eta) = 0.99
y_99 = interp1(f_eta_unique, profile_y_unique, 0.99, ‘linear’, ‘extrap’);
eta_99 = 0.99;
% delta_99
delta_99 = y_99 / eta_99;
delta_99_values(i) = delta_99;
% displacement thickness (delta_star)
delta_star = abs(trapz(profile_y, (1 – f_eta)));
delta_star_values(i) = delta_star;
% momentum thickness (theta)
theta = abs(trapz(profile_y, f_eta .* (1 – f_eta)));
theta_values(i) = theta;
Re_theta = (u_inf * theta)/nu;
% Calculate wall shear stress and friction velocity
fun_u_tau = @(u_tau) mean(profile_u – (u_tau / kappa) * log(profile_y * u_tau / nu + 1) – B * u_tau);
try
options = optimset(‘Display’, ‘off’);
u_tau = fzero(fun_u_tau, [0.01, 10], options);
u_tau_values(i) = u_tau;
catch err
fprintf(‘Cannot converge at x = %f meters: %sn’, profile_x_positions(i), err.message);
continue;
end
rho = 1.225;
tau_wall = rho * u_tau^2;
wall_shear_stress(i) = tau_wall;
% % Plot y/delta vs u/u_inf
% figure;
% y_over_delta = profile_y / delta_99;
% u_over_u_inf = profile_u / u_inf;
% plot(u_over_u_inf, y_over_delta, ‘-o’);
% title(sprintf(‘Velocity Profile at x = %.3f meters’, profile_x_positions(i)));
% xlabel(‘u / u_{infty}’);
% ylabel(‘y / delta’);
% grid on;
end
% Display the results
results_table = table(profile_x_positions, delta_99_values, delta_star_values, theta_values);
disp(results_table);
disp([‘Momentum Thickness Reynolds Number (Re_theta): ‘, num2str(Re_theta)]); aerodynamics, indexing, plotting, vectors MATLAB Answers — New Questions
How to get optimal number of clusters in data set using fuzzy c means? Please answer this it is very important for my study.
How to get optimal number of clusters in data set using fuzzy c means? Please answer this it is very important for my study.How to get optimal number of clusters in data set using fuzzy c means? Please answer this it is very important for my study. How to get optimal number of clusters in data set using fuzzy c means? Please answer this it is very important for my study. fcm MATLAB Answers — New Questions
Converting smtp email
hello
hello how can i convert smtp email to smb with exchange server?what connectors i need to use? 10x rami Read More
Copilot in PowerPoint 365 do not edit the slides anymore?
I wonder, is the copilot for Microsoft PowerPoint not editing the slides anymore? It is rather providing only default options i.e. add image, organize ppt, add slide etc but do not edit the slides anymore i.e. no more prompt for changing the fonts, animating the bullets, reducing or increasing the text etc. Or is it only happening with me?
I wonder, is the copilot for Microsoft PowerPoint not editing the slides anymore? It is rather providing only default options i.e. add image, organize ppt, add slide etc but do not edit the slides anymore i.e. no more prompt for changing the fonts, animating the bullets, reducing or increasing the text etc. Or is it only happening with me? Read More
How to disable the ‘Join’ button for meetings
Is there a way to disable the JOIN button on a scheduled meeting? We would like to have the user enter the meeting ID and password in order to have an MTR joint he room.
Its for security purposes.
Thanks
Is there a way to disable the JOIN button on a scheduled meeting? We would like to have the user enter the meeting ID and password in order to have an MTR joint he room. Its for security purposes. Thanks Read More
Using imrotate without losing quality
I’m in a situation that I need to be able to randomly rotate (0-359 angle degrees) different images. I’m currently using _imrotate()_ but considering that the images are small and the quality is important, I noticed that the images lose their qualities, specially in curve lines. I can still rotate my images 0, 90, 180 and 270 degrees without losing any qualities but I wanted to know if there is any way to rotate an image with more degrees without losing the quality.I’m in a situation that I need to be able to randomly rotate (0-359 angle degrees) different images. I’m currently using _imrotate()_ but considering that the images are small and the quality is important, I noticed that the images lose their qualities, specially in curve lines. I can still rotate my images 0, 90, 180 and 270 degrees without losing any qualities but I wanted to know if there is any way to rotate an image with more degrees without losing the quality. I’m in a situation that I need to be able to randomly rotate (0-359 angle degrees) different images. I’m currently using _imrotate()_ but considering that the images are small and the quality is important, I noticed that the images lose their qualities, specially in curve lines. I can still rotate my images 0, 90, 180 and 270 degrees without losing any qualities but I wanted to know if there is any way to rotate an image with more degrees without losing the quality. image processing, rotate, imrotate, quality, imagequality MATLAB Answers — New Questions
How to use Battery Pulse Analysis with both Discharge and Charge Pulses?
I’m wondering if there is any way to modify analysis described below (see link) so that the code can analyze a mixture of charge and discharge pulses?
I am using the battery discharge pulse analysis described in the link below to analyze the discharge of my batteries. Works great with discharge only pulses!
I have a new data set that includes discharge AND charge pulses, however, and when I try to analyze the data I run into this error "Warning: Battery:InvalidTestType. TestType mixed is not supported."
https://www.mathworks.com/help/autoblks/ug/generate-parameter-data-for-estimations-circuit-battery-block.html
Thank you!I’m wondering if there is any way to modify analysis described below (see link) so that the code can analyze a mixture of charge and discharge pulses?
I am using the battery discharge pulse analysis described in the link below to analyze the discharge of my batteries. Works great with discharge only pulses!
I have a new data set that includes discharge AND charge pulses, however, and when I try to analyze the data I run into this error "Warning: Battery:InvalidTestType. TestType mixed is not supported."
https://www.mathworks.com/help/autoblks/ug/generate-parameter-data-for-estimations-circuit-battery-block.html
Thank you! I’m wondering if there is any way to modify analysis described below (see link) so that the code can analyze a mixture of charge and discharge pulses?
I am using the battery discharge pulse analysis described in the link below to analyze the discharge of my batteries. Works great with discharge only pulses!
I have a new data set that includes discharge AND charge pulses, however, and when I try to analyze the data I run into this error "Warning: Battery:InvalidTestType. TestType mixed is not supported."
https://www.mathworks.com/help/autoblks/ug/generate-parameter-data-for-estimations-circuit-battery-block.html
Thank you! battery, pulse MATLAB Answers — New Questions
How can I resolve this error ?
While simulating model in Simulink I got error as "External input specified in the Configuration Parameters dialog box on the Data Import/Export page (or as an option to SIM command) to a model containing no root level input ports"While simulating model in Simulink I got error as "External input specified in the Configuration Parameters dialog box on the Data Import/Export page (or as an option to SIM command) to a model containing no root level input ports" While simulating model in Simulink I got error as "External input specified in the Configuration Parameters dialog box on the Data Import/Export page (or as an option to SIM command) to a model containing no root level input ports" to workspace, from workspace MATLAB Answers — New Questions
segmentação de dados
gostaria de saber se é possível usar uma única segmentação de dados para varias tabelas dinâmicas em diferentes planilhas na mesma pasta de trabalho.
contexto: eu tenho 3 tabelas diferentes, usadas para diferentes propósitos. Com essas tabelas eu crie tabelas dinâmicas e com os dados unificados criei um dashboard. Porém na hora de usar os filtros dinâmicos (segmentação) eles só aceitam conexão com uma mesma pasta de trabalho mesmo todos os dados sendo iguais nas diferentes planilhas. Nas tabelas tenho a mesma base de dados, que são nome, e até mesmo datas e meses.
gostaria de saber se é possível usar uma única segmentação de dados para varias tabelas dinâmicas em diferentes planilhas na mesma pasta de trabalho. contexto: eu tenho 3 tabelas diferentes, usadas para diferentes propósitos. Com essas tabelas eu crie tabelas dinâmicas e com os dados unificados criei um dashboard. Porém na hora de usar os filtros dinâmicos (segmentação) eles só aceitam conexão com uma mesma pasta de trabalho mesmo todos os dados sendo iguais nas diferentes planilhas. Nas tabelas tenho a mesma base de dados, que são nome, e até mesmo datas e meses. Read More
Hello, I would like to know how to draw a shaded region like this?
I am trying to estimate the parameters for a mathematical model, I managed to do it but there remains a problem of determining the confidence interval and drawing the shaded region which contains the majority of the data points.I am trying to estimate the parameters for a mathematical model, I managed to do it but there remains a problem of determining the confidence interval and drawing the shaded region which contains the majority of the data points. I am trying to estimate the parameters for a mathematical model, I managed to do it but there remains a problem of determining the confidence interval and drawing the shaded region which contains the majority of the data points. parameter estimation, confidence interval, curve fitting MATLAB Answers — New Questions
Excel – best way to perform my end result
I have data with the following headers, name, class and amount. (I can delete the unwanted columns just fine)
1) I need to sort by class and have total amounts based on each class. ( I know how to sort and use subtotal groups) I can’t figure out out to copy that info with just the totals of each class and identify who those amounts belong to. I use paste special, value (I still end up with the rows expanding out)
Data I start with (with several rows (including more than 1 name) and multiple classes with varying amounts)
NameWhy date date 2 n/a n/a n/a Class AmountJoe SmithHoliday 06/06/2024 ########## 0.00 0.00 Y 281.00_General Operations195.00
2) after I get the data of just the totals for each class I am going to have my rows with the class with the amount in a column and the name relating somehow to the that data. In the end I will have multiple names and amounts going horizontal with some other added columns and formulas to determine a incentive payout but based on the amount in each class. ( I have figured out to use transpose and or just some simple formulas to make this happen. I just thought maybe if you knew the big picture you would see an easier way to get around it all)
ClassJoe Smith% (amount/total)Bonus AmountFinal Funding200781%910
I have data with the following headers, name, class and amount. (I can delete the unwanted columns just fine)1) I need to sort by class and have total amounts based on each class. ( I know how to sort and use subtotal groups) I can’t figure out out to copy that info with just the totals of each class and identify who those amounts belong to. I use paste special, value (I still end up with the rows expanding out) Data I start with (with several rows (including more than 1 name) and multiple classes with varying amounts)NameWhy date date 2 n/a n/a n/a Class AmountJoe SmithHoliday 06/06/2024 ########## 0.00 0.00 Y 281.00_General Operations195.00 2) after I get the data of just the totals for each class I am going to have my rows with the class with the amount in a column and the name relating somehow to the that data. In the end I will have multiple names and amounts going horizontal with some other added columns and formulas to determine a incentive payout but based on the amount in each class. ( I have figured out to use transpose and or just some simple formulas to make this happen. I just thought maybe if you knew the big picture you would see an easier way to get around it all)ClassJoe Smith% (amount/total)Bonus AmountFinal Funding200781%910 Read More
Why .net says it is not supported
I have exagear installed on my Samsung Andriod to emulate windows in it. I specifically activated Windows in it. Then I downloaded.net and now .net the installer says This OS does not support it. what should I do now?
I have exagear installed on my Samsung Andriod to emulate windows in it. I specifically activated Windows in it. Then I downloaded.net and now .net the installer says This OS does not support it. what should I do now? Read More
Regarding Triworker.exe crash to cbscore.dll with an error code of c0000005…
Hello to all, On Windows 11 Pro 24H2 RP latest build I sometimes get a crash regarding Windows Modules Installer Worker. This is the complete error message under the Windows Error Reporting Dialog under control panel and then security and mantainance and then etc etc etc It says this :
Description
Faulting Application Path: C:WindowsWinSxSamd64_microsoft-windows-servicingstack_31bf3856ad364e35_10.0.26100.998_none_ab30feedb06cf8c8TiWorker.exe
Problem signature
Problem Event Name: APPCRASH
Application Name: TiWorker.exe
Application Version: 10.0.26100.998
Application Timestamp: f6990ba2
Fault Module Name: cbscore.dll
Fault Module Version: 10.0.26100.998
Fault Module Timestamp: a149c54c
Exception Code: c0000005
Exception Offset: 000000000004c140
OS Version: 10.0.26100.2.0.0.256.48
Locale ID: 1033
Additional Information 1: 7fcc
Additional Information 2: 7fccea33ab95e3af7744a9e0e0dde74b
Additional Information 3: d367
Additional Information 4: d367613844bd03775cf0e169aaa7fdb7
Extra information about the problem
Bucket ID: c811e39e947f331e3acf5ddcf708b0aa (1931865968783962282)
Anyways, I think it has to do with whenever it is in use and the memory usage gets high enough on the process known as triworker.exe it might crash that process in question which is triworker.exe although I am not entirely sure about that though.!! Anyways, If there is a possible fix or workaround I am open ears to anybody who might know of it!.. Thanks in advance for listening and Have a great day and stay safe also!.
Hello to all, On Windows 11 Pro 24H2 RP latest build I sometimes get a crash regarding Windows Modules Installer Worker. This is the complete error message under the Windows Error Reporting Dialog under control panel and then security and mantainance and then etc etc etc It says this : DescriptionFaulting Application Path: C:WindowsWinSxSamd64_microsoft-windows-servicingstack_31bf3856ad364e35_10.0.26100.998_none_ab30feedb06cf8c8TiWorker.exeProblem signatureProblem Event Name: APPCRASHApplication Name: TiWorker.exeApplication Version: 10.0.26100.998Application Timestamp: f6990ba2Fault Module Name: cbscore.dllFault Module Version: 10.0.26100.998Fault Module Timestamp: a149c54cException Code: c0000005Exception Offset: 000000000004c140OS Version: 10.0.26100.2.0.0.256.48Locale ID: 1033Additional Information 1: 7fccAdditional Information 2: 7fccea33ab95e3af7744a9e0e0dde74bAdditional Information 3: d367Additional Information 4: d367613844bd03775cf0e169aaa7fdb7Extra information about the problemBucket ID: c811e39e947f331e3acf5ddcf708b0aa (1931865968783962282) Anyways, I think it has to do with whenever it is in use and the memory usage gets high enough on the process known as triworker.exe it might crash that process in question which is triworker.exe although I am not entirely sure about that though.!! Anyways, If there is a possible fix or workaround I am open ears to anybody who might know of it!.. Thanks in advance for listening and Have a great day and stay safe also!. Read More
How do I encrypt email messages outlook
Hello
Please i need your help on this issue.
How do I encrypt email messages outlook.
Are any steps I need to follow to configure encrypt email messages on outlookAre they any license I need to haveAre they any requirements I need to meet
Hello Please i need your help on this issue. How do I encrypt email messages outlook. Are any steps I need to follow to configure encrypt email messages on outlookAre they any license I need to haveAre they any requirements I need to meet Read More
Importing a Database into VS Code
About
This article will talk through how one can import an existing database that lives on a SQL Server either on prem or in Azure onto a local machine. This import will create a .sqlproj. Per the documentation a sql Project is:
A Management Studio project is a collection of logically related scripts and files that can be saved together for database administration and development.
Once we have this then we will have the ability to make and test changes locally, place the contents under source control, and leverage Azure DevOps for CI/CD deployment. One misnomer that I will call out is that we will do this all without leveraging a Visual Studio License, which historically has been a prerequisite for managing SQL Databases.
Pre Reqs
In order to follow along with this process, one will need to have a combination of access and software installed on their computer. I will be walking through using Visual Studio Code; however, the process is quite similar if leveraging Azure Data Studio.
Visual Studio Code with the SQL Database Projects Extension OR Azure Data Studio
Via network connectivity/firewall ability to establish a connection to the desired SQL Database
Ability to login to the database and read all schema objects. This can be achieved via SQL Login or Entra ID. We will use Entra ID for our purposes.
Importing the Database
Now we will go step by step how to effectively download and recreate the database schema files on our local machine. This process will entail Creating the Connection Profile, Downloading the Database, and Confirming Your Local Copy.
Creating the Connection Profile
The first step is to launch Visual Studio Code (VS Code), or Azure Data Studio. Once we have this launched VS Code, we will leverage the Command Pallet in VS Code by the shortcut Ctrl+Shift+P and type in “Database Projects”
This will provide a list of actions one can perform in VS Code leveraging the Database Projects Extension. In our case we want to select “Database Projects: Create Project From Database”
After selecting this you will see an option to “Create Connection Profile” –it is possible if you have previously used Data Studio or VS Code to create a Connection Profile to the desired database in the past. If so, then feel free to skip this section.
The next prompt will ask you for the connection string. We will use just the server address to keep it basic. I am using a SQL PaaS Database that contains just the sample schema/data for Adventure Works.
We will then be prompted for an optional parameter to include the name of the database we’d like to download. I HIGHLY recommend scoping your project import to a single database. The reason behind this is, typically, individual databases are maintained, operated, and scoped for a single purpose. This means in the grand scheme of source control management and CI/CD we would want to scope our projects according to not only lifecycle but purpose as well.
In my case the database name is “sqlmoveme“
We will then be prompted to how to authenticate to the SQL DB. I will be using “Microsoft Entra Id – Universal”. The next screen will confirm the Entra Account we will be using to connect if leveraging SQL Login it will ask for the username and password. Odds are you will be choosing the “Add” option. When clicking this VS Code will launch a new browser session where you will log/MFA into the Entra ID Tenant.
After this step the MSSQL library will be testing a connection behind the scenes. This can be confirmed in the VS Code Output window by selecting MSSQL from the drop down and inspecting the logging:
Downloading the Database
After connecting VS Code will now prompt you to give your project a name. I would recommend naming the project either the same as your database or something similar.
After this VS Code will now ask what folder we should download and create the .sqlproj in.
I would recommend each database you are downloading have a separate folder. This will help later if we want to put our database under source control.
Once we have a location we will be asked how to import the database. This can be a bit of a dealer’s choice; however, I am going to choose to import the “Schema/Object Type” option. Others are perfectly fine.
Once selecting this you will be prompted if permissions and security scripts should be included. I would advise you not to include this as it will contain the credentials for SQL Logins, which we should not be storing under source control.
The next prompt around “SDK-style project” may sound a bit confusing. This is prompting the user if they’d like to leverage Use SDK-style projects with the SQL Database Projects extension though listed in preview at the time of this writing I’d still encourage you to select this option. It will let us build the .sqlproj leveraging a ‘dotnet build’ build command and more importantly won’t require us to have Visual Studio.
Once selected VS Code will download the database locally and the result, in the case of Adventure Works, will look like:
Confirming Your Local Copy
At this point we can see the database schemas, in our example this is just `dbo` and `SalesLT`. If expanding these folders we can see all the object types and their definitions. In this screenshot the table Address has been selected and one can see the associated SQL script:
Let’s make a change and save it. I am going to add an “Address Line3” with NULLs being allowed into our table definition and save it.
Now let’s right click the Address.sql file in the File Explorer and select “Reveal in File Explorer”. This will launch File Explorer where we can confirm the date modified on our Address.sql has been updated.
Building the Database
Now that we confirmed we can make these changes in our local .sqlproj the next logical question is how should we deploy or product an artifact to deploy. Since we are using the SDK-style projects with the SQL Database Projects extension a `dotnet build` command entered in the VS Code terminal will produce our deployable artifact. I am going to use .dacpac for future iterations of this blog series.
Next Steps
Once we have the .dacpac file locally we can deploy this either manually through SQL Server Management Studio or Azure Data Tools or preferrable through a CI/CD process which I will cover in a future post leveraging the SqlAzureDacpacDeployment task. However; before we do that we should discuss how to push the database project we just created to source control. To be alerted when this blog is available be sure to follow me on Tech Community
Microsoft Tech Community – Latest Blogs –Read More
how to plot signals in matlab.ans
how to plot these signals in matlab
y1(t)=x(t-3)
y2(t)=x(t+5)
y3(t)=x(-t)how to plot these signals in matlab
y1(t)=x(t-3)
y2(t)=x(t+5)
y3(t)=x(-t) how to plot these signals in matlab
y1(t)=x(t-3)
y2(t)=x(t+5)
y3(t)=x(-t) signal MATLAB Answers — New Questions
Is it Entra ID and Entra External ID Collab + Entra External ID B2C? Or?
Hi,
Will someone please clarify something for me.
Are Entra ID and Entra External ID different products or just the same product separated into logical tenants for the purpose of security partitioning?
I was reviewing the FAQ for an upcoming CIAM webinar the following question was presented:
Question: I am currently using Azure AD B2B collaboration and B2B direct connect, have these experiences changed?
Answer: Azure AD B2B collaboration and B2B direct connect are now part of Microsoft Entra External ID as External ID B2B collaboration and B2B direct connect. There are no changes to your product experience, B2B collaboration features remain in the same location in the Microsoft Entra admin center within the workforce tenant, allowing you to secure all business guests, streamline collaboration, and limit access risks extending ID Governance to external users.
This indicates that if you are currently using Azure AD for guest accounts (due to the limitations of Azure B2C) then there’s no change. The conclusion then is the only benefit of using Entra External ID is strictly for any new/future capabilities and replacement of Azure AD B2C. We are looking for federation of B2C customers IdP customers on a more enterprise level, not just Google and Facebook but we desire to have the security partition in place and not have guest accounts in our Entra ID Enterprise tenant.
Very confusing.
Thanks.
Hi,Will someone please clarify something for me. Are Entra ID and Entra External ID different products or just the same product separated into logical tenants for the purpose of security partitioning? I was reviewing the FAQ for an upcoming CIAM webinar the following question was presented: Question: I am currently using Azure AD B2B collaboration and B2B direct connect, have these experiences changed?Answer: Azure AD B2B collaboration and B2B direct connect are now part of Microsoft Entra External ID as External ID B2B collaboration and B2B direct connect. There are no changes to your product experience, B2B collaboration features remain in the same location in the Microsoft Entra admin center within the workforce tenant, allowing you to secure all business guests, streamline collaboration, and limit access risks extending ID Governance to external users. This indicates that if you are currently using Azure AD for guest accounts (due to the limitations of Azure B2C) then there’s no change. The conclusion then is the only benefit of using Entra External ID is strictly for any new/future capabilities and replacement of Azure AD B2C. We are looking for federation of B2C customers IdP customers on a more enterprise level, not just Google and Facebook but we desire to have the security partition in place and not have guest accounts in our Entra ID Enterprise tenant. Very confusing. Thanks. Read More
