Category: News
Fisher’s z transform with atanh() to rho goes to infinity
I have run Spearman’s correlations usign the following:
[rho, pval] = corr(A,B, ‘type’, ‘Spearman’, ‘rows’, ‘complete’);
I would like to conduct a fisher’s z transform on my rho values so that I can compare them later on.
Doing
atanh(rho)
sometimes outputs Inf or -Inf (particularly when the output of rho is 1 / -1). In cases where the output of rho is 1.000 or -1.000 this doesn’t occur.
I’m not entirely sure what I have missed or how I could fix this issue. Any help will be very much appreciated.I have run Spearman’s correlations usign the following:
[rho, pval] = corr(A,B, ‘type’, ‘Spearman’, ‘rows’, ‘complete’);
I would like to conduct a fisher’s z transform on my rho values so that I can compare them later on.
Doing
atanh(rho)
sometimes outputs Inf or -Inf (particularly when the output of rho is 1 / -1). In cases where the output of rho is 1.000 or -1.000 this doesn’t occur.
I’m not entirely sure what I have missed or how I could fix this issue. Any help will be very much appreciated. I have run Spearman’s correlations usign the following:
[rho, pval] = corr(A,B, ‘type’, ‘Spearman’, ‘rows’, ‘complete’);
I would like to conduct a fisher’s z transform on my rho values so that I can compare them later on.
Doing
atanh(rho)
sometimes outputs Inf or -Inf (particularly when the output of rho is 1 / -1). In cases where the output of rho is 1.000 or -1.000 this doesn’t occur.
I’m not entirely sure what I have missed or how I could fix this issue. Any help will be very much appreciated. statistics, z transform MATLAB Answers — New Questions
How to choose from a list of strings all the string with specific pattren follows by a digits
Hello,
I use FiledTrip to analyze iEEG data and stack with the following problem.
I try to use the ‘d’ to extract all the channels that start in the letters ‘RHL’ and are followed by any digit, but for some reason, it is not working.
I tried another approach that looked very similar, and I was expected to behave similarly. These is the two approaches:
When I defined depths_LH as:
depths_LH = {‘RHL*’};
I get the desired result. But when I defined depths_LH as
depths_LH = {‘RHLd’};
The code is not working (There is an error, but it seems empty)
This is the entire code:
depths_LH = {‘RHLd’};
reref_depthsLH = {‘RHL1’};
for d = 1:numel(depths_LH)
cfg = [];
cfg.channel = ft_channelselection(depths_LH{d}, data_prepro_ds_tr_ar.label);
disp([‘Selected channels (LH, pattern: ‘, depths_LH{d}, ‘):’]);
disp(cfg.channel); % Print the selected channels for this iteration
cfg.reref = ‘yes’;
cfg.refchannel = reref_depthsLH;
cfg.refmethod = ‘avg’;
cfg.updatesens = ‘yes’;
reref_depthsLH{d} = ft_preprocessing(cfg, data_prepro_ds_tr_ar);
end
Does anyone know what the problem is?
Thank you.Hello,
I use FiledTrip to analyze iEEG data and stack with the following problem.
I try to use the ‘d’ to extract all the channels that start in the letters ‘RHL’ and are followed by any digit, but for some reason, it is not working.
I tried another approach that looked very similar, and I was expected to behave similarly. These is the two approaches:
When I defined depths_LH as:
depths_LH = {‘RHL*’};
I get the desired result. But when I defined depths_LH as
depths_LH = {‘RHLd’};
The code is not working (There is an error, but it seems empty)
This is the entire code:
depths_LH = {‘RHLd’};
reref_depthsLH = {‘RHL1’};
for d = 1:numel(depths_LH)
cfg = [];
cfg.channel = ft_channelselection(depths_LH{d}, data_prepro_ds_tr_ar.label);
disp([‘Selected channels (LH, pattern: ‘, depths_LH{d}, ‘):’]);
disp(cfg.channel); % Print the selected channels for this iteration
cfg.reref = ‘yes’;
cfg.refchannel = reref_depthsLH;
cfg.refmethod = ‘avg’;
cfg.updatesens = ‘yes’;
reref_depthsLH{d} = ft_preprocessing(cfg, data_prepro_ds_tr_ar);
end
Does anyone know what the problem is?
Thank you. Hello,
I use FiledTrip to analyze iEEG data and stack with the following problem.
I try to use the ‘d’ to extract all the channels that start in the letters ‘RHL’ and are followed by any digit, but for some reason, it is not working.
I tried another approach that looked very similar, and I was expected to behave similarly. These is the two approaches:
When I defined depths_LH as:
depths_LH = {‘RHL*’};
I get the desired result. But when I defined depths_LH as
depths_LH = {‘RHLd’};
The code is not working (There is an error, but it seems empty)
This is the entire code:
depths_LH = {‘RHLd’};
reref_depthsLH = {‘RHL1’};
for d = 1:numel(depths_LH)
cfg = [];
cfg.channel = ft_channelselection(depths_LH{d}, data_prepro_ds_tr_ar.label);
disp([‘Selected channels (LH, pattern: ‘, depths_LH{d}, ‘):’]);
disp(cfg.channel); % Print the selected channels for this iteration
cfg.reref = ‘yes’;
cfg.refchannel = reref_depthsLH;
cfg.refmethod = ‘avg’;
cfg.updatesens = ‘yes’;
reref_depthsLH{d} = ft_preprocessing(cfg, data_prepro_ds_tr_ar);
end
Does anyone know what the problem is?
Thank you. strings MATLAB Answers — New Questions
Introducing Reading Coach, your AI-powered tutor
Hi Microsoft 365 Insiders!
:books:Attention educators and learners! We’re thrilled to introduce Reading Coach, your AI-powered reading fluency coach. This innovative tool is designed to enhance reading skills through personalized feedback and guidance.
Read our latest blog by Anoo Padte, Principal Product Manager on the Education team, to learn more about how Reading Coach works and empowers learners of all ages: Introducing Reading Coach, your AI-powered tutor
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi Microsoft 365 Insiders!
:books:Attention educators and learners! We’re thrilled to introduce Reading Coach, your AI-powered reading fluency coach. This innovative tool is designed to enhance reading skills through personalized feedback and guidance.
Read our latest blog by Anoo Padte, Principal Product Manager on the Education team, to learn more about how Reading Coach works and empowers learners of all ages: Introducing Reading Coach, your AI-powered tutor
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Condensing this?
I’m working with a program that exports data to look like this. Is there a faster way to condense this than going through it line by line?
I’m using Excel 13
I’m working with a program that exports data to look like this. Is there a faster way to condense this than going through it line by line? I’m using Excel 13 Read More
Search from MS Lists returning inconsistant results
I am running into two issues that are sort of playing off each other.
I use the MS Lists app to display a list of client names and corresponding items. The ClientName column is a lookup column with names formatted as Last, First Middle.
I have been able to format the JSON for ClientName so that the names are hyperlinks that will search for all entries with that client’s name. However, I am running into issues where the search is returning incomplete results. The current codes is:
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “a”,
“attributes”: {
“href”: “=’https://siteName.sharepoint.com/sites/listName/Lists/Hearings%20List/AllItems.aspx?env=WebViewList&q=’ + [$Hearing_x0020__x0023_.lookupValue]”,
“target”: “_top”,
“class”: “sp-field-fontSizeSmall sp-css-color-BlackText sp-field-bold”
},
“txtContent”: “[$Hearing_x0020__x0023_.lookupValue]”
}
I cannot figure out how to call a search natively within the MS Lists app (which would be the ideal solution, if anyone can point me to that), so the code I have runs a search in a browser version of Lists. However, I have found strange behaviors running searches in the browser version:
-Searching using the native Search bar at the top of the Lists app returns all results as expected.
-Searching using the browser version of Lists in Edge returns all results as expected.
-Searching using the browser version of Lists in Chrome (the system default browser) returns inconsistent results. (described below)
-Using the hyperlinks I formatted runs what seems to be an iframe in the Lists app, but returns the same inconsistent results as Chrome.
-Searching for a name that is Last, First Middle will usually only return one or two of the results.
-Searching for a name that is Last, First will return more than when including the Middle name, though with a few refreshes, might return all the results.
-Searching just the Last OR First name will return all the results (but also then returns results for more than one client).
Does anyone know how to correct these search behaviors and/or call the native search function within the Lists app?
I am running into two issues that are sort of playing off each other. I use the MS Lists app to display a list of client names and corresponding items. The ClientName column is a lookup column with names formatted as Last, First Middle. I have been able to format the JSON for ClientName so that the names are hyperlinks that will search for all entries with that client’s name. However, I am running into issues where the search is returning incomplete results. The current codes is: {
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “a”,
“attributes”: {
“href”: “=’https://siteName.sharepoint.com/sites/listName/Lists/Hearings%20List/AllItems.aspx?env=WebViewList&q=’ + [$Hearing_x0020__x0023_.lookupValue]”,
“target”: “_top”,
“class”: “sp-field-fontSizeSmall sp-css-color-BlackText sp-field-bold”
},
“txtContent”: “[$Hearing_x0020__x0023_.lookupValue]”
} I cannot figure out how to call a search natively within the MS Lists app (which would be the ideal solution, if anyone can point me to that), so the code I have runs a search in a browser version of Lists. However, I have found strange behaviors running searches in the browser version: -Searching using the native Search bar at the top of the Lists app returns all results as expected.-Searching using the browser version of Lists in Edge returns all results as expected.-Searching using the browser version of Lists in Chrome (the system default browser) returns inconsistent results. (described below)-Using the hyperlinks I formatted runs what seems to be an iframe in the Lists app, but returns the same inconsistent results as Chrome. -Searching for a name that is Last, First Middle will usually only return one or two of the results.-Searching for a name that is Last, First will return more than when including the Middle name, though with a few refreshes, might return all the results.-Searching just the Last OR First name will return all the results (but also then returns results for more than one client). Does anyone know how to correct these search behaviors and/or call the native search function within the Lists app? Read More
Mail-Enabled Public Folder: Email being received by one address but not another
Hello all,
I have a Mail-Enabled public folder that has two email addresses associated with it. For purposes of this discussion I’ll call them AddressOG (original) and AddressNew (new domain).
The public folder is set up to accept messages from all senders and block messages from none. AddressNew is set up as the default reply address.
When external users send an email to AddressNew, they get a failed delivery notice stating something along the lines of “the address could not be found.” When they send to AddressOG, the mail gets delivered without issue.
Both addresses are associated with the same public folder, so I’m struggling to find why mail would fail to one but not the other.
Any insight?
Hello all, I have a Mail-Enabled public folder that has two email addresses associated with it. For purposes of this discussion I’ll call them AddressOG (original) and AddressNew (new domain). The public folder is set up to accept messages from all senders and block messages from none. AddressNew is set up as the default reply address. When external users send an email to AddressNew, they get a failed delivery notice stating something along the lines of “the address could not be found.” When they send to AddressOG, the mail gets delivered without issue. Both addresses are associated with the same public folder, so I’m struggling to find why mail would fail to one but not the other. Any insight? Read More
Project Online-Features and core differences with MS Project 2019
Hi,
We are currently using Microsoft Project 2019 and are in the process of upgrading to Microsoft Project Online. Can anyone provide me a link where I can see the features of MS Project Online or information on the core difference between 2019 and the Online version?
Thanks
Teshome
Hi, We are currently using Microsoft Project 2019 and are in the process of upgrading to Microsoft Project Online. Can anyone provide me a link where I can see the features of MS Project Online or information on the core difference between 2019 and the Online version? ThanksTeshome Read More
Netsuite Web Query to Excel Throwing Active Scripting Error
I am new to this forum, and could very much use someone’s help. I am receiving an error while trying to pull report data from Netsuite via a web query. The error messages states “The Web.Page function requires Active Scripting to be enabled in Internet Explorer options. See https://go.microsoft.com/fwlink/?LinkId=506565 for details on how to enable Active Scripting. I went through the instructions on how to enable Active Scripting, but already have Active Scripting enabled. I am able to pull other Netsuite reports via the same web query method, so it is super weird that certain reports would throw this error message. The report I am trying to pull is 75,000 rows by 10 columns of data. Doesn’t seem excessively sized if size could be an issue. Any help with this would be much appreciated! Thanks!!
I am new to this forum, and could very much use someone’s help. I am receiving an error while trying to pull report data from Netsuite via a web query. The error messages states “The Web.Page function requires Active Scripting to be enabled in Internet Explorer options. See https://go.microsoft.com/fwlink/?LinkId=506565 for details on how to enable Active Scripting. I went through the instructions on how to enable Active Scripting, but already have Active Scripting enabled. I am able to pull other Netsuite reports via the same web query method, so it is super weird that certain reports would throw this error message. The report I am trying to pull is 75,000 rows by 10 columns of data. Doesn’t seem excessively sized if size could be an issue. Any help with this would be much appreciated! Thanks!! Read More
Messed up setting up OneDrive on my new computer
I got a new computer and had a company tech help set it up. Rather than just log into my OneDrive and let it sync files again, he copied some of the files in my Documents folder (just some, not all… long story) onto my new computer but did not turn on OneDrive sync. He told me I could just do that later. Now when I want to turn on syncing, OneDrive wants to make copies of every single file that’s currently on my hard drive, appending “- copy” to the end of each file name.
Is there any way to not have it do that? If I go to copy files between two regular drives, Windows always asks me what I want to do with files that have duplicate names. Why won’t OneDrive ask me that? I *really* don’t want to go through and delete 150+GB of duplicate files! Help!
I got a new computer and had a company tech help set it up. Rather than just log into my OneDrive and let it sync files again, he copied some of the files in my Documents folder (just some, not all… long story) onto my new computer but did not turn on OneDrive sync. He told me I could just do that later. Now when I want to turn on syncing, OneDrive wants to make copies of every single file that’s currently on my hard drive, appending “- copy” to the end of each file name. Is there any way to not have it do that? If I go to copy files between two regular drives, Windows always asks me what I want to do with files that have duplicate names. Why won’t OneDrive ask me that? I *really* don’t want to go through and delete 150+GB of duplicate files! Help! Read More
Forwarding emails from POP/IMAP email to outlook
Hi,
I have a work email (POP/IMAP) that I would like to forward to my new outlook account. But from all the dozen tutorials I watched this seems to work only from an outlook email to other emails. The add rule button does not appear for my POP/IMAP email, neither does it appear for my Gmail account, both connected to my Outlook app.
At the moment all my work emails are forwarded to my gmail account and everything works fine. I would like to switch from Gmail to Outlook to make use of all Outlook features. At the moment features like schedule email, integration of To Do and others are not available to non outlook accounts.
Unfortunately it seems like this is not possible, or did I misunderstand something? I don’t have the option to also create a work outlook account. So I rely on a simple forwarding from POP/IMAP mail to outlook, a simple option available in Gmail but not in Outlook.
Many thanks
Hi, I have a work email (POP/IMAP) that I would like to forward to my new outlook account. But from all the dozen tutorials I watched this seems to work only from an outlook email to other emails. The add rule button does not appear for my POP/IMAP email, neither does it appear for my Gmail account, both connected to my Outlook app. At the moment all my work emails are forwarded to my gmail account and everything works fine. I would like to switch from Gmail to Outlook to make use of all Outlook features. At the moment features like schedule email, integration of To Do and others are not available to non outlook accounts.Unfortunately it seems like this is not possible, or did I misunderstand something? I don’t have the option to also create a work outlook account. So I rely on a simple forwarding from POP/IMAP mail to outlook, a simple option available in Gmail but not in Outlook. Many thanks Read More
Business Applications Partner News: Week of May 13
Check out this week’s top resources to stay up-to-date on the latest Business Applications Partner News. Remember to sign up for the monthly Dynamics 365 and Power Platform partner pulse newsletters.
What to register for:
THIS WEEK!
May 13-15: Implementing Microsoft Cloud for Retail
May 15 (Santa Clara, CA, USA): Microsoft AI Partner Training Roadshow
May 16-17: Directions Asia
What to review/like/share:
Microsoft Partner Training calendar
Capgemini Invent helps FinTech company achieve rapid impact with Microsoft Copilot for Sales: LinkedIn | blog link
NEW! Microsoft Certification: Dynamics 365 Business Central Developer Associate
Case study: PwC helps businesses scale and grow with Dynamics 365 Finance
What to watch:
April Directions North America keynote recordings
May 2 Tech Talk: Power Pages Data Controls and External Data Connectivity
May 2 recording: Supply Chain Management Premium Partner Webinar
Reminders: Register for the upcoming partner events!
Events:
May 21-23: Microsoft Build
May 28-31 (PDT) | June 4-7 (IST), (BST): Accelerate Business Process Automation using Microsoft Power Platform Workshop
May 30: Copilot Studio Partner Opportunity Webinar
July 22: Microsoft Partner FY25 GTM Launch Event for Business Applications
Register for upcoming Microsoft AI Training Roadshows
Trainings:
April 1-May 31: Q4 Microsoft Catalyst Partner Training
June 11 (IST) (BST): Dynamics 365 Supply Chain Management – Demand Planning Workshop
FY24 High Volume Acceleration Program (Advanced)
Check out this week’s top resources to stay up-to-date on the latest Business Applications Partner News. Remember to sign up for the monthly Dynamics 365 and Power Platform partner pulse newsletters.
What to register for:
THIS WEEK!
May 13-15: Implementing Microsoft Cloud for Retail
May 15 (Santa Clara, CA, USA): Microsoft AI Partner Training Roadshow
May 16-17: Directions Asia
What to review/like/share:
Microsoft Partner Training calendar
Capgemini Invent helps FinTech company achieve rapid impact with Microsoft Copilot for Sales: LinkedIn | blog link
NEW! Microsoft Certification: Dynamics 365 Business Central Developer Associate
Case study: PwC helps businesses scale and grow with Dynamics 365 Finance
What to watch:
April Directions North America keynote recordings
May 2 Tech Talk: Power Pages Data Controls and External Data Connectivity
May 2 recording: Supply Chain Management Premium Partner Webinar
Reminders: Register for the upcoming partner events!
Events:
May 21-23: Microsoft Build
May 28-31 (PDT) | June 4-7 (IST), (BST): Accelerate Business Process Automation using Microsoft Power Platform Workshop
May 30: Copilot Studio Partner Opportunity Webinar
July 22: Microsoft Partner FY25 GTM Launch Event for Business Applications
Register for upcoming Microsoft AI Training Roadshows
Trainings:
April 1-May 31: Q4 Microsoft Catalyst Partner Training
June 11 (IST) (BST): Dynamics 365 Supply Chain Management – Demand Planning Workshop
FY24 High Volume Acceleration Program (Advanced) Read More
General CRC Generator – How to determine generator polynomial
Hello everyone,
In my current project I have to perform a CRC check. At first I had to do this using a regular block diagram, but now I would like to use the CRC generator block provided by Matlab. Unfortunately, I don’t know how to determine the polynomial from a given block diagram.
Like here in the example: How do I get the given polynomial from the diagram? (https://de.mathworks.com/help/comm/ref/generalcrcgenerator.html#)Hello everyone,
In my current project I have to perform a CRC check. At first I had to do this using a regular block diagram, but now I would like to use the CRC generator block provided by Matlab. Unfortunately, I don’t know how to determine the polynomial from a given block diagram.
Like here in the example: How do I get the given polynomial from the diagram? (https://de.mathworks.com/help/comm/ref/generalcrcgenerator.html#) Hello everyone,
In my current project I have to perform a CRC check. At first I had to do this using a regular block diagram, but now I would like to use the CRC generator block provided by Matlab. Unfortunately, I don’t know how to determine the polynomial from a given block diagram.
Like here in the example: How do I get the given polynomial from the diagram? (https://de.mathworks.com/help/comm/ref/generalcrcgenerator.html#) simulink, crc, polynomial MATLAB Answers — New Questions
An error occurred during simulation and the simulation was terminated
Error:An error occurred during simulation and the simulation was terminated
Caused by:
Derivative of state ‘1’ in block ‘ee4022/Battery/MPPT Solar Charge Controller/Mean/Model/integrator’ at time 0.0 is not finite. The simulation will be stopped. There may be a singularity in the solution. If not, try reducing the step size (either by reducing the fixed step size or by tightening the error tolerances)Error:An error occurred during simulation and the simulation was terminated
Caused by:
Derivative of state ‘1’ in block ‘ee4022/Battery/MPPT Solar Charge Controller/Mean/Model/integrator’ at time 0.0 is not finite. The simulation will be stopped. There may be a singularity in the solution. If not, try reducing the step size (either by reducing the fixed step size or by tightening the error tolerances) Error:An error occurred during simulation and the simulation was terminated
Caused by:
Derivative of state ‘1’ in block ‘ee4022/Battery/MPPT Solar Charge Controller/Mean/Model/integrator’ at time 0.0 is not finite. The simulation will be stopped. There may be a singularity in the solution. If not, try reducing the step size (either by reducing the fixed step size or by tightening the error tolerances) simulink MATLAB Answers — New Questions
How to plot Chroma_Features for an audio file?
%% Read in the file
clearvars;
close all;
file_path = ‘C:/Users/nimae/Downloads/audio_2024-05-12_17-59-56.ogg’;
[audio_data, sample_rate] = audioread(file_path);
%% Play original file
% pOrig = audioplayer(audio_data, sample_rate);
% pOrig.play;
%% Plot both audio channels
N = size(audio_data,1); % Determine total number of samples in audio file
figure;
subplot(2,1,1);
stem(1:N, audio_data(:,1));
title(‘Left Channel’);
subplot(2,1,2);
% Increase resolution by increasing the number of points in FFT
N = 2^nextpow2(length(audio_data(:,1)));
% Plot the spectrum with increased resolution
df = sample_rate / N;
w = (-N/2 : N/2 – 1) * df;
y = fft(audio_data(:,1), N) / N; % For normalizing, but not needed for our analysis
y2 = fftshift(y);
% Define the desired frequency range
f_min = 0; % Minimum frequency in Hz
f_max = 5.6e4; % Maximum frequency in Hz
% Find the corresponding indices in the frequency axis
idx_min = find(w >= f_min, 1, ‘first’);
idx_max = find(w <= f_max, 1, ‘last’);
% Plot the spectrum with increased resolution and within the desired frequency range
figure;
plot(w(idx_min:idx_max), abs(y2(idx_min:idx_max)));
xlabel(‘Frequency (Hz)’);
ylabel(‘Magnitude’);
title(‘Spectrum of Audio Signal’);
grid on;
hold on; % Add subsequent plots to the same figure
% Frequencies you provided
frequencies = [
16.35 32.702 65.404 130.808 261.616 523.232 1046.464 2092.928 4185.856 8371.712;
17.32 34.648 69.296 138.592 277.184 554.368 1108.736 2217.472 4434.944 8869.888;
18.35 36.708 73.416 146.832 293.664 587.328 1174.656 2349.312 4698.624 9397.248;
19.45 38.89 77.78 155.56 311.12 622.24 1244.48 2488.96 4977.92 9955.84;
20.60 41.202 82.404 164.808 329.616 659.232 1318.464 2636.928 5273.856 10547.712;
21.83 43.654 87.308 174.616 349.232 698.464 1396.928 2793.856 5587.712 11175.424;
23.12 46.248 92.496 184.992 369.984 739.968 1479.936 2959.872 5919.744 11839.488;
24.50 48.998 97.996 195.992 391.984 783.968 1567.936 3135.872 6271.744 12543.488;
25.96 51.912 103.824 207.648 415.296 830.592 1661.184 3322.368 6644.736 13289.472;
27.50 55 110 220 440 880 1760 3520 7040 14080;
29.14 58.27 116.54 233.08 466.16 932.32 1864.64 3729.28 7458.56 14917.12;
30.87 61.736 123.472 246.944 493.888 987.776 1975.552 3951.104 7902.208 15804.416
];
% Plot the frequencies you provided
for i = 1:size(frequencies, 1)
plot(frequencies(i, :), zeros(size(frequencies, 2)), ‘o’, ‘MarkerSize’, 5);
end
legend(‘Spectrum’, ‘Frequencies provided’);
% Convert frequencies to chroma values
chroma_values = mod(round(log2(frequencies/440) * 12), 12);
% Plot the chroma diagram
figure;
imagesc(chroma_values);
colormap(jet);
colorbar;
xlabel(‘Time’);
ylabel(‘Chroma’);
title(‘Chroma Diagram’);
function Y = chromagram_IF(d,sample_rate,fftlen,~,f_ctr,f_sd)
%% Function Definitions
% Calculate the chroma matrix. Use a long FFT to discriminate
% spectral lines as well as possible (2048 is the default value)
cfftlen=2048;
C = chromagram_IF(audio_data,sample_rate,cfftlen);
% The frame advance is always one quarter of the FFT length. Thus,
% the columns of C are at timebase of fftlen/4/sr
tt = (1:size(C,2))*cfftlen/4/sample_rate;
% Plot spectrogram using a shorter window
subplot(311)
sfftlen = 512;
specgram(audio_data,sfftlen,sample_rate);
% Always use a 60 dB colormap range
clim(max(clim)+[-60 0])
% .. and look only at the bottom 4 kHz of spectrum
axis([0 length(d)/sample_rate 0 4000])
title(‘Original Sound’)
% Now the chromagram, also on a dB magnitude scale
subplot(312)
imagesc(tt,1:12,20*log10(C+eps));
axis xy
clim(max(clim)+[-60 0])
title(‘Chromagram’)
% Y = chromagram_IF(d,sr,fftlen,nbin,f_ctr,f_sd)
% Calculate a "chromagram" of the sound in d (at sampling rate sr)
% Use windows of fftlen points, hopped by ffthop points
% Divide the octave into nbin steps
% Weight with center frequency f_ctr (in Hz) and gaussian SD f_sd
% (in octaves)
% Use instantaneous frequency to keep only real harmonics.
% 2006-09-26 dpwe@ee.columbia.edu
% Copyright (c) 2006 Columbia University.
%
% This file is part of LabROSA-coversongID
%
% LabROSA-coversongID is free software; you can redistribute it and/or modify
% it under the terms of the GNU General Public License version 2 as
% published by the Free Software Foundation.
%
% LabROSA-coversongID is distributed in the hope that it will be useful, but
% WITHOUT ANY WARRANTY; without even the implied warranty of
% MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
% General Public License for more details.
%
% You should have received a copy of the GNU General Public License
% along with LabROSA-coversongID; if not, write to the Free Software
% Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
% 02110-1301 USA
%
% See the file "COPYING" for the text of the license.
if nargin < 3; fftlen = 2048; end
%if nargin < 4; nbin = 12; end
if nargin < 5; f_ctr = 1000; end
if nargin < 6; f_sd = 1; end
%A0 = 27.5; % Hz
%A440 = 440; % Hz
%f_ctr_log = log(f_ctr/A0) / log(2);
fminl = octs2hz(hz2octs(f_ctr)-2*f_sd);
fminu = octs2hz(hz2octs(f_ctr)-f_sd);
fmaxl = octs2hz(hz2octs(f_ctr)+f_sd);
fmaxu = octs2hz(hz2octs(f_ctr)+2*f_sd);
%ffthop = fftlen/4;
nchr = 12;
% Calculate spectrogram and IF gram pitch tracks…
[p,m]=ifptrack(d,fftlen,sr,fminl,fminu,fmaxl,fmaxu);
[~,ncols] = size(p);
%disp([‘ncols = ‘,num2str(ncols)]);
% chroma-quantized IF sinusoids
Pocts = hz2octs(p+(p==0));
Pocts(p(:)==0) = 0;
% Figure best tuning alignment
nzp = find(p(:)>0);
%hist(nchr*Pmapo(nzp)-round(nchr*Pmapo(nzp)),100)
[hn,hx] = histogram(nchr*Pocts(nzp)-round(nchr*Pocts(nzp)),100);
centsoff = hx(hn == max(hn));
% Adjust tunings to align better with chroma
Pocts(nzp) = Pocts(nzp) – centsoff(1)/nchr;
% Quantize to chroma bins
PoctsQ = Pocts;
PoctsQ(nzp) = round(nchr*Pocts(nzp))/nchr;
% map IF pitches to chroma bins
Pmapc = round(nchr*(PoctsQ – floor(PoctsQ)));
Pmapc(p(:) == 0) = -1;
Pmapc(Pmapc(:) == nchr) = 0;
Y = zeros(nchr,ncols);
for t = 1:ncols
Y(:,t)=(repmat((0:(nchr-1))’,1,size(Pmapc,1))==repmat(Pmapc(:,t)’,nchr,1))*m(:,t);
end
end
hello,
i have coded this file and copied most of it from Columbian University, as you can see. I want to plot simply the chroma features for my file in variation of time, i mean determining exactly at which time which musical note is played in the file. For that we need at the X axis, time, and in Yaxis Frequencies of those musical notes(which i have provided in the "Frequencies" Matrix).
So I’d be thankful if someone can guide me a little bit through this. My code runs halfway but i don’t get the desired Chroma Diagram, said above.%% Read in the file
clearvars;
close all;
file_path = ‘C:/Users/nimae/Downloads/audio_2024-05-12_17-59-56.ogg’;
[audio_data, sample_rate] = audioread(file_path);
%% Play original file
% pOrig = audioplayer(audio_data, sample_rate);
% pOrig.play;
%% Plot both audio channels
N = size(audio_data,1); % Determine total number of samples in audio file
figure;
subplot(2,1,1);
stem(1:N, audio_data(:,1));
title(‘Left Channel’);
subplot(2,1,2);
% Increase resolution by increasing the number of points in FFT
N = 2^nextpow2(length(audio_data(:,1)));
% Plot the spectrum with increased resolution
df = sample_rate / N;
w = (-N/2 : N/2 – 1) * df;
y = fft(audio_data(:,1), N) / N; % For normalizing, but not needed for our analysis
y2 = fftshift(y);
% Define the desired frequency range
f_min = 0; % Minimum frequency in Hz
f_max = 5.6e4; % Maximum frequency in Hz
% Find the corresponding indices in the frequency axis
idx_min = find(w >= f_min, 1, ‘first’);
idx_max = find(w <= f_max, 1, ‘last’);
% Plot the spectrum with increased resolution and within the desired frequency range
figure;
plot(w(idx_min:idx_max), abs(y2(idx_min:idx_max)));
xlabel(‘Frequency (Hz)’);
ylabel(‘Magnitude’);
title(‘Spectrum of Audio Signal’);
grid on;
hold on; % Add subsequent plots to the same figure
% Frequencies you provided
frequencies = [
16.35 32.702 65.404 130.808 261.616 523.232 1046.464 2092.928 4185.856 8371.712;
17.32 34.648 69.296 138.592 277.184 554.368 1108.736 2217.472 4434.944 8869.888;
18.35 36.708 73.416 146.832 293.664 587.328 1174.656 2349.312 4698.624 9397.248;
19.45 38.89 77.78 155.56 311.12 622.24 1244.48 2488.96 4977.92 9955.84;
20.60 41.202 82.404 164.808 329.616 659.232 1318.464 2636.928 5273.856 10547.712;
21.83 43.654 87.308 174.616 349.232 698.464 1396.928 2793.856 5587.712 11175.424;
23.12 46.248 92.496 184.992 369.984 739.968 1479.936 2959.872 5919.744 11839.488;
24.50 48.998 97.996 195.992 391.984 783.968 1567.936 3135.872 6271.744 12543.488;
25.96 51.912 103.824 207.648 415.296 830.592 1661.184 3322.368 6644.736 13289.472;
27.50 55 110 220 440 880 1760 3520 7040 14080;
29.14 58.27 116.54 233.08 466.16 932.32 1864.64 3729.28 7458.56 14917.12;
30.87 61.736 123.472 246.944 493.888 987.776 1975.552 3951.104 7902.208 15804.416
];
% Plot the frequencies you provided
for i = 1:size(frequencies, 1)
plot(frequencies(i, :), zeros(size(frequencies, 2)), ‘o’, ‘MarkerSize’, 5);
end
legend(‘Spectrum’, ‘Frequencies provided’);
% Convert frequencies to chroma values
chroma_values = mod(round(log2(frequencies/440) * 12), 12);
% Plot the chroma diagram
figure;
imagesc(chroma_values);
colormap(jet);
colorbar;
xlabel(‘Time’);
ylabel(‘Chroma’);
title(‘Chroma Diagram’);
function Y = chromagram_IF(d,sample_rate,fftlen,~,f_ctr,f_sd)
%% Function Definitions
% Calculate the chroma matrix. Use a long FFT to discriminate
% spectral lines as well as possible (2048 is the default value)
cfftlen=2048;
C = chromagram_IF(audio_data,sample_rate,cfftlen);
% The frame advance is always one quarter of the FFT length. Thus,
% the columns of C are at timebase of fftlen/4/sr
tt = (1:size(C,2))*cfftlen/4/sample_rate;
% Plot spectrogram using a shorter window
subplot(311)
sfftlen = 512;
specgram(audio_data,sfftlen,sample_rate);
% Always use a 60 dB colormap range
clim(max(clim)+[-60 0])
% .. and look only at the bottom 4 kHz of spectrum
axis([0 length(d)/sample_rate 0 4000])
title(‘Original Sound’)
% Now the chromagram, also on a dB magnitude scale
subplot(312)
imagesc(tt,1:12,20*log10(C+eps));
axis xy
clim(max(clim)+[-60 0])
title(‘Chromagram’)
% Y = chromagram_IF(d,sr,fftlen,nbin,f_ctr,f_sd)
% Calculate a "chromagram" of the sound in d (at sampling rate sr)
% Use windows of fftlen points, hopped by ffthop points
% Divide the octave into nbin steps
% Weight with center frequency f_ctr (in Hz) and gaussian SD f_sd
% (in octaves)
% Use instantaneous frequency to keep only real harmonics.
% 2006-09-26 dpwe@ee.columbia.edu
% Copyright (c) 2006 Columbia University.
%
% This file is part of LabROSA-coversongID
%
% LabROSA-coversongID is free software; you can redistribute it and/or modify
% it under the terms of the GNU General Public License version 2 as
% published by the Free Software Foundation.
%
% LabROSA-coversongID is distributed in the hope that it will be useful, but
% WITHOUT ANY WARRANTY; without even the implied warranty of
% MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
% General Public License for more details.
%
% You should have received a copy of the GNU General Public License
% along with LabROSA-coversongID; if not, write to the Free Software
% Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
% 02110-1301 USA
%
% See the file "COPYING" for the text of the license.
if nargin < 3; fftlen = 2048; end
%if nargin < 4; nbin = 12; end
if nargin < 5; f_ctr = 1000; end
if nargin < 6; f_sd = 1; end
%A0 = 27.5; % Hz
%A440 = 440; % Hz
%f_ctr_log = log(f_ctr/A0) / log(2);
fminl = octs2hz(hz2octs(f_ctr)-2*f_sd);
fminu = octs2hz(hz2octs(f_ctr)-f_sd);
fmaxl = octs2hz(hz2octs(f_ctr)+f_sd);
fmaxu = octs2hz(hz2octs(f_ctr)+2*f_sd);
%ffthop = fftlen/4;
nchr = 12;
% Calculate spectrogram and IF gram pitch tracks…
[p,m]=ifptrack(d,fftlen,sr,fminl,fminu,fmaxl,fmaxu);
[~,ncols] = size(p);
%disp([‘ncols = ‘,num2str(ncols)]);
% chroma-quantized IF sinusoids
Pocts = hz2octs(p+(p==0));
Pocts(p(:)==0) = 0;
% Figure best tuning alignment
nzp = find(p(:)>0);
%hist(nchr*Pmapo(nzp)-round(nchr*Pmapo(nzp)),100)
[hn,hx] = histogram(nchr*Pocts(nzp)-round(nchr*Pocts(nzp)),100);
centsoff = hx(hn == max(hn));
% Adjust tunings to align better with chroma
Pocts(nzp) = Pocts(nzp) – centsoff(1)/nchr;
% Quantize to chroma bins
PoctsQ = Pocts;
PoctsQ(nzp) = round(nchr*Pocts(nzp))/nchr;
% map IF pitches to chroma bins
Pmapc = round(nchr*(PoctsQ – floor(PoctsQ)));
Pmapc(p(:) == 0) = -1;
Pmapc(Pmapc(:) == nchr) = 0;
Y = zeros(nchr,ncols);
for t = 1:ncols
Y(:,t)=(repmat((0:(nchr-1))’,1,size(Pmapc,1))==repmat(Pmapc(:,t)’,nchr,1))*m(:,t);
end
end
hello,
i have coded this file and copied most of it from Columbian University, as you can see. I want to plot simply the chroma features for my file in variation of time, i mean determining exactly at which time which musical note is played in the file. For that we need at the X axis, time, and in Yaxis Frequencies of those musical notes(which i have provided in the "Frequencies" Matrix).
So I’d be thankful if someone can guide me a little bit through this. My code runs halfway but i don’t get the desired Chroma Diagram, said above. %% Read in the file
clearvars;
close all;
file_path = ‘C:/Users/nimae/Downloads/audio_2024-05-12_17-59-56.ogg’;
[audio_data, sample_rate] = audioread(file_path);
%% Play original file
% pOrig = audioplayer(audio_data, sample_rate);
% pOrig.play;
%% Plot both audio channels
N = size(audio_data,1); % Determine total number of samples in audio file
figure;
subplot(2,1,1);
stem(1:N, audio_data(:,1));
title(‘Left Channel’);
subplot(2,1,2);
% Increase resolution by increasing the number of points in FFT
N = 2^nextpow2(length(audio_data(:,1)));
% Plot the spectrum with increased resolution
df = sample_rate / N;
w = (-N/2 : N/2 – 1) * df;
y = fft(audio_data(:,1), N) / N; % For normalizing, but not needed for our analysis
y2 = fftshift(y);
% Define the desired frequency range
f_min = 0; % Minimum frequency in Hz
f_max = 5.6e4; % Maximum frequency in Hz
% Find the corresponding indices in the frequency axis
idx_min = find(w >= f_min, 1, ‘first’);
idx_max = find(w <= f_max, 1, ‘last’);
% Plot the spectrum with increased resolution and within the desired frequency range
figure;
plot(w(idx_min:idx_max), abs(y2(idx_min:idx_max)));
xlabel(‘Frequency (Hz)’);
ylabel(‘Magnitude’);
title(‘Spectrum of Audio Signal’);
grid on;
hold on; % Add subsequent plots to the same figure
% Frequencies you provided
frequencies = [
16.35 32.702 65.404 130.808 261.616 523.232 1046.464 2092.928 4185.856 8371.712;
17.32 34.648 69.296 138.592 277.184 554.368 1108.736 2217.472 4434.944 8869.888;
18.35 36.708 73.416 146.832 293.664 587.328 1174.656 2349.312 4698.624 9397.248;
19.45 38.89 77.78 155.56 311.12 622.24 1244.48 2488.96 4977.92 9955.84;
20.60 41.202 82.404 164.808 329.616 659.232 1318.464 2636.928 5273.856 10547.712;
21.83 43.654 87.308 174.616 349.232 698.464 1396.928 2793.856 5587.712 11175.424;
23.12 46.248 92.496 184.992 369.984 739.968 1479.936 2959.872 5919.744 11839.488;
24.50 48.998 97.996 195.992 391.984 783.968 1567.936 3135.872 6271.744 12543.488;
25.96 51.912 103.824 207.648 415.296 830.592 1661.184 3322.368 6644.736 13289.472;
27.50 55 110 220 440 880 1760 3520 7040 14080;
29.14 58.27 116.54 233.08 466.16 932.32 1864.64 3729.28 7458.56 14917.12;
30.87 61.736 123.472 246.944 493.888 987.776 1975.552 3951.104 7902.208 15804.416
];
% Plot the frequencies you provided
for i = 1:size(frequencies, 1)
plot(frequencies(i, :), zeros(size(frequencies, 2)), ‘o’, ‘MarkerSize’, 5);
end
legend(‘Spectrum’, ‘Frequencies provided’);
% Convert frequencies to chroma values
chroma_values = mod(round(log2(frequencies/440) * 12), 12);
% Plot the chroma diagram
figure;
imagesc(chroma_values);
colormap(jet);
colorbar;
xlabel(‘Time’);
ylabel(‘Chroma’);
title(‘Chroma Diagram’);
function Y = chromagram_IF(d,sample_rate,fftlen,~,f_ctr,f_sd)
%% Function Definitions
% Calculate the chroma matrix. Use a long FFT to discriminate
% spectral lines as well as possible (2048 is the default value)
cfftlen=2048;
C = chromagram_IF(audio_data,sample_rate,cfftlen);
% The frame advance is always one quarter of the FFT length. Thus,
% the columns of C are at timebase of fftlen/4/sr
tt = (1:size(C,2))*cfftlen/4/sample_rate;
% Plot spectrogram using a shorter window
subplot(311)
sfftlen = 512;
specgram(audio_data,sfftlen,sample_rate);
% Always use a 60 dB colormap range
clim(max(clim)+[-60 0])
% .. and look only at the bottom 4 kHz of spectrum
axis([0 length(d)/sample_rate 0 4000])
title(‘Original Sound’)
% Now the chromagram, also on a dB magnitude scale
subplot(312)
imagesc(tt,1:12,20*log10(C+eps));
axis xy
clim(max(clim)+[-60 0])
title(‘Chromagram’)
% Y = chromagram_IF(d,sr,fftlen,nbin,f_ctr,f_sd)
% Calculate a "chromagram" of the sound in d (at sampling rate sr)
% Use windows of fftlen points, hopped by ffthop points
% Divide the octave into nbin steps
% Weight with center frequency f_ctr (in Hz) and gaussian SD f_sd
% (in octaves)
% Use instantaneous frequency to keep only real harmonics.
% 2006-09-26 dpwe@ee.columbia.edu
% Copyright (c) 2006 Columbia University.
%
% This file is part of LabROSA-coversongID
%
% LabROSA-coversongID is free software; you can redistribute it and/or modify
% it under the terms of the GNU General Public License version 2 as
% published by the Free Software Foundation.
%
% LabROSA-coversongID is distributed in the hope that it will be useful, but
% WITHOUT ANY WARRANTY; without even the implied warranty of
% MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
% General Public License for more details.
%
% You should have received a copy of the GNU General Public License
% along with LabROSA-coversongID; if not, write to the Free Software
% Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
% 02110-1301 USA
%
% See the file "COPYING" for the text of the license.
if nargin < 3; fftlen = 2048; end
%if nargin < 4; nbin = 12; end
if nargin < 5; f_ctr = 1000; end
if nargin < 6; f_sd = 1; end
%A0 = 27.5; % Hz
%A440 = 440; % Hz
%f_ctr_log = log(f_ctr/A0) / log(2);
fminl = octs2hz(hz2octs(f_ctr)-2*f_sd);
fminu = octs2hz(hz2octs(f_ctr)-f_sd);
fmaxl = octs2hz(hz2octs(f_ctr)+f_sd);
fmaxu = octs2hz(hz2octs(f_ctr)+2*f_sd);
%ffthop = fftlen/4;
nchr = 12;
% Calculate spectrogram and IF gram pitch tracks…
[p,m]=ifptrack(d,fftlen,sr,fminl,fminu,fmaxl,fmaxu);
[~,ncols] = size(p);
%disp([‘ncols = ‘,num2str(ncols)]);
% chroma-quantized IF sinusoids
Pocts = hz2octs(p+(p==0));
Pocts(p(:)==0) = 0;
% Figure best tuning alignment
nzp = find(p(:)>0);
%hist(nchr*Pmapo(nzp)-round(nchr*Pmapo(nzp)),100)
[hn,hx] = histogram(nchr*Pocts(nzp)-round(nchr*Pocts(nzp)),100);
centsoff = hx(hn == max(hn));
% Adjust tunings to align better with chroma
Pocts(nzp) = Pocts(nzp) – centsoff(1)/nchr;
% Quantize to chroma bins
PoctsQ = Pocts;
PoctsQ(nzp) = round(nchr*Pocts(nzp))/nchr;
% map IF pitches to chroma bins
Pmapc = round(nchr*(PoctsQ – floor(PoctsQ)));
Pmapc(p(:) == 0) = -1;
Pmapc(Pmapc(:) == nchr) = 0;
Y = zeros(nchr,ncols);
for t = 1:ncols
Y(:,t)=(repmat((0:(nchr-1))’,1,size(Pmapc,1))==repmat(Pmapc(:,t)’,nchr,1))*m(:,t);
end
end
hello,
i have coded this file and copied most of it from Columbian University, as you can see. I want to plot simply the chroma features for my file in variation of time, i mean determining exactly at which time which musical note is played in the file. For that we need at the X axis, time, and in Yaxis Frequencies of those musical notes(which i have provided in the "Frequencies" Matrix).
So I’d be thankful if someone can guide me a little bit through this. My code runs halfway but i don’t get the desired Chroma Diagram, said above. chromatography, audio MATLAB Answers — New Questions
How to break a waveform waveform into its constituent harmonics using FFT and see the harmonic waveforms at each frequency?
I want to use Simulink to see the harmonics of a voltage waveform. So far I have used the fft simulink tool and only found the magnitude of the harmonic frequencies. What I would like to do is issolate and observe the waveform at the different frequencies as shown in the figure below.I want to use Simulink to see the harmonics of a voltage waveform. So far I have used the fft simulink tool and only found the magnitude of the harmonic frequencies. What I would like to do is issolate and observe the waveform at the different frequencies as shown in the figure below. I want to use Simulink to see the harmonics of a voltage waveform. So far I have used the fft simulink tool and only found the magnitude of the harmonic frequencies. What I would like to do is issolate and observe the waveform at the different frequencies as shown in the figure below. fft, harmonics, dtft, signal processing MATLAB Answers — New Questions
for loops auto nidification problem
I have a function y= f(x) .
x is 10 x n and y= 1 x n
a performance function myperf = perf(y) gives a 1 x 1 value.
a target value mytar must be reached.
if mytar is not reached I must reiterate the process in this way :
for i=1:10
y(i)=f(x(i));
end
x=y % it must be 10 x n
and finally …
y=f(x);
So if myperf = perf(y) > mytar I must continue.
I can’t known how much iteration I’ll need.
x dimension is 10^niteration x n ( 10 ,100 ,1000 … 10^niteration)
I must pay attention to use intermediate results to not reinitialize the algorithm every time and loose resources.
What type of architecture cold I use ?
The most symple and understandable ?
Thanks !I have a function y= f(x) .
x is 10 x n and y= 1 x n
a performance function myperf = perf(y) gives a 1 x 1 value.
a target value mytar must be reached.
if mytar is not reached I must reiterate the process in this way :
for i=1:10
y(i)=f(x(i));
end
x=y % it must be 10 x n
and finally …
y=f(x);
So if myperf = perf(y) > mytar I must continue.
I can’t known how much iteration I’ll need.
x dimension is 10^niteration x n ( 10 ,100 ,1000 … 10^niteration)
I must pay attention to use intermediate results to not reinitialize the algorithm every time and loose resources.
What type of architecture cold I use ?
The most symple and understandable ?
Thanks ! I have a function y= f(x) .
x is 10 x n and y= 1 x n
a performance function myperf = perf(y) gives a 1 x 1 value.
a target value mytar must be reached.
if mytar is not reached I must reiterate the process in this way :
for i=1:10
y(i)=f(x(i));
end
x=y % it must be 10 x n
and finally …
y=f(x);
So if myperf = perf(y) > mytar I must continue.
I can’t known how much iteration I’ll need.
x dimension is 10^niteration x n ( 10 ,100 ,1000 … 10^niteration)
I must pay attention to use intermediate results to not reinitialize the algorithm every time and loose resources.
What type of architecture cold I use ?
The most symple and understandable ?
Thanks ! matlab, for loop MATLAB Answers — New Questions
Trying to set up Conditional Formatting or other
I have two ALPHA columns in Excel
($b19:$b126)
($b131:$b290)
I want to red-flag all cells in the first group that are equal to any cells in the second group.
I used to program a lot in Excel but that was a decade ago.
Thanks in advance for your help.
I have two ALPHA columns in Excel($b19:$b126) ($b131:$b290)I want to red-flag all cells in the first group that are equal to any cells in the second group.I used to program a lot in Excel but that was a decade ago.Thanks in advance for your help. Read More
Can Microsoft Defender for Cloud be integrated or used with Azure ExpressRoute
Anyone knows whether or not Microsoft Defender for Cloud can be integrated and used with Azure ExpressRoute?
Anyone knows whether or not Microsoft Defender for Cloud can be integrated and used with Azure ExpressRoute? Read More
Project -‘No Calculations Can be Performed Now’ File Corrupt
Hello,
I have Microsoft (bus.) 365 Project. I have been experiencing errors that lead to crashes. Below is one of the more request messages I’ll receive however the information in the warning does not match my project at all. I daily back up my file. However when a warning message like this appears and when i click “ok” my entire project file is distorted and damaged. Anyone have any insight on this, and how can it can be corrected, prevented and other tips? Thank you in advanced.
Hello,I have Microsoft (bus.) 365 Project. I have been experiencing errors that lead to crashes. Below is one of the more request messages I’ll receive however the information in the warning does not match my project at all. I daily back up my file. However when a warning message like this appears and when i click “ok” my entire project file is distorted and damaged. Anyone have any insight on this, and how can it can be corrected, prevented and other tips? Thank you in advanced. Read More
using a formula simlare to UNIQUE to create a list from a column of filled cells
I’m trying to figure out how to auto populate a list from a column with filled/empty cells. I know UNIQUE will populate a list, but sometimes the values are the same, and I need each cell with data to show up in the list.
I’m trying to figure out how to auto populate a list from a column with filled/empty cells. I know UNIQUE will populate a list, but sometimes the values are the same, and I need each cell with data to show up in the list. Read More