Month: July 2024
Invoke-command Access denied on Windows 11 but works with Windows 10
I’m trying to connect to a remote computer using Invoke-Command while running an elevated Powershell ise. I recently upgraded to Windows 11 and my scripts no longer work and are giving me an Access is denied error. Here is a test script I’ve been using to try and resolve the issue.
$Creds = Import-CliXml -Path “C:InstallPowerCredsCred.xml”
Invoke-Command -ComputerName $Computer -Credential $Creds -ScriptBlock {
Test-Path “\networkFileLocation”
This is working just fine on my secondary computer with Windows 10. I cloned my Windows 10 computer to a new computer to test Windows 11 in our environment. I’ve checked all the execution policies and they are set the same as my Windows 10 computer. Trust for Delegation Kerbos Only is turned on for all computers, this was required for Windows 10 to get over the Double-Hop. Does anyone know if there is a setting that is new with Windows 11 that needs to be changed
I’m trying to connect to a remote computer using Invoke-Command while running an elevated Powershell ise. I recently upgraded to Windows 11 and my scripts no longer work and are giving me an Access is denied error. Here is a test script I’ve been using to try and resolve the issue.$Creds = Import-CliXml -Path “C:InstallPowerCredsCred.xml”Invoke-Command -ComputerName $Computer -Credential $Creds -ScriptBlock {Test-Path “\networkFileLocation”This is working just fine on my secondary computer with Windows 10. I cloned my Windows 10 computer to a new computer to test Windows 11 in our environment. I’ve checked all the execution policies and they are set the same as my Windows 10 computer. Trust for Delegation Kerbos Only is turned on for all computers, this was required for Windows 10 to get over the Double-Hop. Does anyone know if there is a setting that is new with Windows 11 that needs to be changed Read More
Determine training compliance with IF/IFS function(s)
Hi, I wonder if someone can help with the following:
I’m trying to determine mandatory training compliance for the first quarter of 24/25 and an excerpt of my massive spreadsheet looks like the below:
Training LevelLatest eLearningLatest Level 1Refresh by:Latest Level 2Refresh by:Latest Level 3Refresh by:Compliance112/09/2023 231/05/202319/01/202119/01/2024 308/12/2020 19/01/202119/01/2024 409/01/2024 21/02/202221/02/2025
We have got four different levels of training, and each employee is allocated to a level according to their role. The spreadsheet references their level of training, the latest date that they attended their relevant session and when they are due to refresh their training (except eLearning which is not refreshed).
I need to work out a formula for the ‘compliance’ column to show whether the employee is currently compliant or not. So what I am trying to test is: if the employee is level x and they are due to refresh their training on date y are they compliant on 01/07/2024? For the staff who are designated eLearning only, the formula only needs to take into consideration whether there is a date in the relevant column earlier than 01/07/2024.
I have tried variations of the IF/IFS formula including AND and OR functions and various IF formulas nested into each other, but I can’t seem to be able to write a formula that will differentiate between ‘compliant’ and ‘not compliant’ answers. I keep getting one or the other!
Any suggestions will be very much appreciated, thank you!
Anastasia
Hi, I wonder if someone can help with the following: I’m trying to determine mandatory training compliance for the first quarter of 24/25 and an excerpt of my massive spreadsheet looks like the below:Training LevelLatest eLearningLatest Level 1Refresh by:Latest Level 2Refresh by:Latest Level 3Refresh by:Compliance112/09/2023 231/05/202319/01/202119/01/2024 308/12/2020 19/01/202119/01/2024 409/01/2024 21/02/202221/02/2025 We have got four different levels of training, and each employee is allocated to a level according to their role. The spreadsheet references their level of training, the latest date that they attended their relevant session and when they are due to refresh their training (except eLearning which is not refreshed).I need to work out a formula for the ‘compliance’ column to show whether the employee is currently compliant or not. So what I am trying to test is: if the employee is level x and they are due to refresh their training on date y are they compliant on 01/07/2024? For the staff who are designated eLearning only, the formula only needs to take into consideration whether there is a date in the relevant column earlier than 01/07/2024. I have tried variations of the IF/IFS formula including AND and OR functions and various IF formulas nested into each other, but I can’t seem to be able to write a formula that will differentiate between ‘compliant’ and ‘not compliant’ answers. I keep getting one or the other! Any suggestions will be very much appreciated, thank you! Anastasia Read More
HTTP request to get list items while including image thumbnail links
Hi all,
In Power Automate, if you use the “Get files (properties only)” SharePoint action, the JSON response will include multiple thumbnail URLs (small, medium, large) for each file in the following format:
https://eastus1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=jpg&cs=N2FiNzg2MmMtNDIzFNQ&docid=https%3a%2f%2fmytenant.sharepoint.com%3a443%2f_api%2fv2.0%2fdrives%2fb!XwWFqzfnlvrVjzA9Fk%2fitems%2f01UCDPGRBBQ%3fversion%3dPublished&access_token={long-token-edited-out}&width=800&height=800
If possible, I’d like to be able to select one of those URLs while doing an API call like this:
/_api/Web/Lists/GetByTitle(‘big_document_library’)/Items?$select=ID,FileLeafRef,{something-to-get-thumbnail?}&$top=5000
Does anyone know if this is possible or what would be the best way to get both items and their corresponding thumbnails in bulk? If possible, I’d like to avoid making separate API requests just to get the thumbnails. Thanks!
Hi all, In Power Automate, if you use the “Get files (properties only)” SharePoint action, the JSON response will include multiple thumbnail URLs (small, medium, large) for each file in the following format: https://eastus1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=jpg&cs=N2FiNzg2MmMtNDIzFNQ&docid=https%3a%2f%2fmytenant.sharepoint.com%3a443%2f_api%2fv2.0%2fdrives%2fb!XwWFqzfnlvrVjzA9Fk%2fitems%2f01UCDPGRBBQ%3fversion%3dPublished&access_token={long-token-edited-out}&width=800&height=800 If possible, I’d like to be able to select one of those URLs while doing an API call like this: /_api/Web/Lists/GetByTitle(‘big_document_library’)/Items?$select=ID,FileLeafRef,{something-to-get-thumbnail?}&$top=5000 Does anyone know if this is possible or what would be the best way to get both items and their corresponding thumbnails in bulk? If possible, I’d like to avoid making separate API requests just to get the thumbnails. Thanks! Read More
Quick-Books Open But Not Showing – How Do I Retrieve It?
Hi everyone, I’m encountering an issue with Quick-Books where it seems to be running in the background but isn’t displaying on my screen. When I check Task Manager, it shows that Quick-Books is indeed running. I’ve tried clicking on the icon in the taskbar, but nothing happens. Restarting my computer didn’t resolve the issue either. Does anyone know how I can retrieve the Quick-Books window or force it to appear on my screen? Thanks in advance for your help!
Hi everyone, I’m encountering an issue with Quick-Books where it seems to be running in the background but isn’t displaying on my screen. When I check Task Manager, it shows that Quick-Books is indeed running. I’ve tried clicking on the icon in the taskbar, but nothing happens. Restarting my computer didn’t resolve the issue either. Does anyone know how I can retrieve the Quick-Books window or force it to appear on my screen? Thanks in advance for your help! Read More
Inserting an image (QR Code in form of URL or image within cell) from table into Mail Merge
I’ve seen topics similar to this but I can’t find an exact answer or an answer that has worked for me so far. Basically, I have a table that includes a distinct QR code in a column that I want to add into a mail merge. The QR code can be accessed as a URL or it’s a picture in a cell itself (I have both columns because I don’t know which one is more easily mail merged). I can’t figure out how to set up the mail merge field to pull up the image, I either end up with just the URL text or !VALUE. Thanks!
I’ve seen topics similar to this but I can’t find an exact answer or an answer that has worked for me so far. Basically, I have a table that includes a distinct QR code in a column that I want to add into a mail merge. The QR code can be accessed as a URL or it’s a picture in a cell itself (I have both columns because I don’t know which one is more easily mail merged). I can’t figure out how to set up the mail merge field to pull up the image, I either end up with just the URL text or !VALUE. Thanks! Read More
Announcing Public Preview of Inbound SMTP DANE with DNSSEC for Exchange Online
We are thrilled to announce the Public Preview of Inbound SMTP DANE with DNSSEC, a new capability of Exchange Online that enhances the security of email communications by supporting two security standards: DNS-based Authentication of Named Entities (DANE) for SMTP and Domain Name System Security Extensions (DNSSEC).
The Public Preview for Inbound SMTP DANE with DNSSEC is currently rolling out. Instructions for implementing it in your tenant are at How SMTP DNS-based Authentication of Named Entities (DANE) secures email communications. PowerShell cmdlets for implementing SMTP DANE are also available in your tenant.
SMTP DANE and DNSSEC
SMTP DANE uses a TLS Authentication (TLSA) DNS record to verify the identity of a destination mail server and provides a secure connection between sending and receiving mail servers that is resistant to both TLS-downgrade attacks and adversary-in-the-middle attacks (a form of eavesdropping where the communication is monitored or modified by a bad actor).
DNSSEC uses cryptographic signatures to ensure that the destination domain’s DNS records are authentic and were not tampered with in transit.
These two standards work together to prevent spoofing, hijacking, and interception of email messages.
Inbound SMTP DANE with DNSSEC benefits
By using SMTP DANE with DNSSEC, you can:
Better protect your email domain(s) from impersonation;
Help ensure your messages are delivered to the intended recipients using encryption and without being altered or redirected; and
Enhance your email reputation by demonstrating compliance with the latest security standards.
Improving Email Security
We released Outbound SMTP DANE with DNSSEC in 2022, and we’re excited to begin the Public Preview for Inbound SMTP DANE with DNSSEC. We are including Inbound SMTP DANE with DNSSEC in our enterprise and consumer email offerings at no charge as part of our efforts to improve email security for everyone. We urge other email providers and domain owners to adopt these standards and collectively raise the bar for email security and protect users from malicious actors.
We have already implemented inbound SMTP DANE with DNSSEC for several Outlook email domains, and we will complete the implementation for remaining Outlook domains (including Hotmail) by the end of 2024.
We are eager to see the impact of this feature on the email security landscape and we look forward to continuing to innovate and deliver an email offering with industry-leading security like SMTP DANE with DNSSEC.
Opt-in to the Public Preview Today
You can opt into the Public Preview today and start using inbound SMTP DANE with DNSSEC by following the enablement steps in this documentation. We welcome your feedback and suggestions for improving this feature, as well.
Email Security Roadmap
Our target dates for upcoming roadmap items are:
August 2024 – Inbound SMTP DANE with DNSSEC and MTA-STS report in the Exchange admin center
October 2024 – General Availability of Inbound SMTP DANE with DNSSEC
End of 2024
Deploying Inbound SMTP DANE with DNSSEC for all Outlook domains
Transition provisioning of mail records for all newly created Accepted Domains into DNSSEC-enabled infrastructure underneath *.mx.microsoft
February 2025 – Mandatory Outbound SMTP DANE, set per-tenant/per-remote domain
Learn more about the provisioning change at Implementing Inbound SMTP DANE with DNSSEC for Exchange Online Mail Flow.
Learn more about .microsoft and its subdomains at Introducing cloud.microsoft: a unified domain for Microsoft 365 apps and services.
Feedback
We welcome your feedback and want to hear from you about your experience with Inbound SMTP DANE with DNSSEC. Please comment on this post if you have any feedback or concerns and we will reply or reach out to you directly as needed.
Microsoft 365 Messaging Team (formerly the Exchange Online Transport Team)
Microsoft Tech Community – Latest Blogs –Read More
Error using newly added wavelet to wavemngr
I am working with a tool in matlab that matches an orthogonal wavelet to a given prototype signal. The attatched image depicts the information stored within the waveletFilter structure generated by the tool.
I would like to add the f/g filters to wavemngr(). I begin by saving f and calling the .mat file by the wavelet short name I plan to use. I then run the following script:
wsname = ‘L1F’;
wname = ‘L1OptimizedFilter’;
eval([wsname ‘=waveletFilterL1.f/sqrt(2);’]);
save(wsname, wsname);
wavemngr(‘add’, wname, wsname, 1, ”, [wsname ‘.mat’]);
When I use wavemngr(‘read’) to validate the addition of my filter, it is there.
However, when I then proceed to access any information regarding the properties, or use the filter with a given transform, I get an error message saying my filter has not been found.I am working with a tool in matlab that matches an orthogonal wavelet to a given prototype signal. The attatched image depicts the information stored within the waveletFilter structure generated by the tool.
I would like to add the f/g filters to wavemngr(). I begin by saving f and calling the .mat file by the wavelet short name I plan to use. I then run the following script:
wsname = ‘L1F’;
wname = ‘L1OptimizedFilter’;
eval([wsname ‘=waveletFilterL1.f/sqrt(2);’]);
save(wsname, wsname);
wavemngr(‘add’, wname, wsname, 1, ”, [wsname ‘.mat’]);
When I use wavemngr(‘read’) to validate the addition of my filter, it is there.
However, when I then proceed to access any information regarding the properties, or use the filter with a given transform, I get an error message saying my filter has not been found. I am working with a tool in matlab that matches an orthogonal wavelet to a given prototype signal. The attatched image depicts the information stored within the waveletFilter structure generated by the tool.
I would like to add the f/g filters to wavemngr(). I begin by saving f and calling the .mat file by the wavelet short name I plan to use. I then run the following script:
wsname = ‘L1F’;
wname = ‘L1OptimizedFilter’;
eval([wsname ‘=waveletFilterL1.f/sqrt(2);’]);
save(wsname, wsname);
wavemngr(‘add’, wname, wsname, 1, ”, [wsname ‘.mat’]);
When I use wavemngr(‘read’) to validate the addition of my filter, it is there.
However, when I then proceed to access any information regarding the properties, or use the filter with a given transform, I get an error message saying my filter has not been found. wavelet, wavemngr, wpdec MATLAB Answers — New Questions
Error using feval Function to evaluate must be represented as a string scalar, character vector, or function_handle object.
% Example5_5.m
% Solution to Example 5.5. This program calculates and plots
% the concentration of cell mass, concentration of penicillin,
% optimal temperature profile, and adjoint variable of a batch
% penicillin fermentor. It uses the function COLLOCATION to
% solve the set of system and adjoint equations.
clear
clc
clf
% Input data
w = input(‘ Enter w”s as a vector : ‘);
y0 = input(‘ Vector of known initial conditions = ‘);
yf = input(‘ Vector of final conditions = ‘);
guess = input(‘ Vector of guessed initial conditions = ‘);
fname = input(‘n M-file containing the set of differential equations : ‘);
fth = input(‘ M-file containing the necessary condition function : ‘);
n = input(‘ Number of internal collocation points = ‘);
rho = input(‘ Relaxation factor = ‘);
% Solution of the set of differential equations
[t,y] = collocation(fname,0,1,y0,yf,guess,n,rho,[],w,fth);
% Temperature changes
for k = 1:n+2
options=optimset;
theta(k) = fzero(fth,30,options,y(:,k),w);
end
% Plotting the results
subplot(2,2,1), plot(t,y(1,:))
xlabel(‘Time’)
ylabel(‘Cell’)
title(‘(a)’)
subplot(2,2,2), plot(t,y(2,:))
xlabel(‘Time’)
ylabel(‘Penicillin’)
title(‘(b)’)
subplot(2,2,3), plot(t,y(3,:))
xlabel(‘Time’)
ylabel(‘First Adjoint’)
title(‘(c)’)
subplot(2,2,4), plot(t,theta)
xlabel(‘Time’)
ylabel(‘Temperature (deg C)’)
title(‘(d)’)
function f = Ex5_5_func(t,y,w,fth)
% Function Ex5_5_func.M
% This function introduces the set of ordinary differential
% equations used in Example 5.5.
% Temperature
options=optimset;
theta = fzero(fth,30,options,y,w);
% Calculating the b’s
b1 = w(1) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
if b1<0, b1=0; end
b2 = w(4) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
if b2<0, b2=1e-6; end
b3 = w(5) * (1-w(2)*(theta-w(6))^2) / (1-w(2)*(25-w(6))^2);
if b3<0, b3=0; end
% Evaluating the function values
f(1) = b1*y(1) – b1/b2*y(1)^2;
f(2) = b3*y(1);
f(3) = -b1*y(3) + 2*b1/b2*y(1)*y(3) – b3;
f = f’; % Make it a column vector
function ftheta = Ex5_5_theta(theta,y,w)
% Function Ex5_5_theta.M
% This function calculates the value of the necessary condition
% as a function of the temperature (theta). It is used in solving
% Example 5.5.
% Calculating the b’s
b1 = w(1) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
db1 = w(1)*(-w(2))*2*(theta-w(3)) / (1-w(2)*(25-w(3))^2);
b2 = w(4) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
db2 = w(4)*(-w(2))*2*(theta-w(3)) / (1-w(2)*(25-w(3))^2);
b3 = w(5) * (1-w(2)*(theta-w(6))^2) / (1-w(2)*(25-w(6))^2);
db3 = w(5)*(-w(2))*2*(theta-w(6)) / (1-w(2)*(25-w(6))^2);
% The function
ftheta = y(3)*(y(1)*db1-y(1)^2*(db1*b2-db2*b1)/b2^2)+y(1)*db3;
function [x,y] = collocation(ODEfile,x0,xf,y0,yf,guess,n,rho,tol,varargin)
%COLLOCATION Solves a boundary value set of ordinary differential
% equations by the orthogonal collocation method.
%
% [X,Y]=COLLOCATION(‘F’,X0,XF,Y0,YF,GAMMA,N) integrates the set of
% ordinary differential equations from X0 to XF by the Nth-degree
% orthogonal collocation method. The equations are contained in
% the M-file F.M. Y0, YF, and GAMMA are the vectors of initial
% conditions, final conditions, and starting guesses respectively.
% The function returns the independent variable in the vector X
% and the set of dependent variables in the matrix Y.
%
% [X,Y]=COLLOCATION(‘F’,X0,XF,Y0,YF,GAMMA,N,RHO,TOL,P1,P2,…)
% uses relaxation factor RHO and tolerance TOL for convergence
% test. Additional parameters P1, P2, … are passed directly to
% the function F. Pass an empty matrix for RHO or TOL to use the
% default value.
%
% See also SHOOTING
% (c) N. Mostoufi & A. Constantinides
% January 1, 1999
% Initialization
if nargin < 7 | isempty(n)
n = 1;
end
if nargin < 8 | isempty(rho)
rho = 1;
end
if nargin < 9 | isempty(tol)
tol = 1e-6;
end
y0 = (y0(:).’)’; % Make sure it’s a column vector
yf = (yf(:).’)’; % Make sure it’s a column vector
guess = (guess(:).’)’; % Make sure it’s a column vector
% Checking the number of guesses
if length(yf) ~= length(guess)
error(‘ The number of guessed conditions is not equal to the number of final conditions.’)
end
r = length(y0); % Number of initial conditions
m = r + length(yf); % Number of boundary conditions
% Checking the number of equations
ftest = feval(ODEfile,x0,[y0 ; guess],varargin{:});
if length(ftest) ~= m
error(‘ The number of equations is not equal to the number of boundary conditions.’)
end
fprintf(‘n Integrating. Please wait.nn’)
% Coefficients of the Legendre polynomial
for k = 0 : n/2
cl(2*k+1) = (-1)^k * gamma(2*n-2*k+1) / …
(2^n * gamma(k+1) * gamma(n-k+1) * gamma(n-2*k+1));
if k < n/2
cl(2*k+2) = 0;
end
end
zl = roots(cl); % Roots of the Legendre polynomial
z = [-1; sort(zl); 1]; % Collocation points (z)
x = (xf-x0)*z/2+(xf+x0)/2; % Collocation points (x)
% Bulding the vector of starting values of the dependent variables
[p,q] = RK(ODEfile,x0,xf,(xf-x0)/20,[y0 ; guess],2,varargin{:});
for k = 1:m
y(k,:) = spline(p,q(k,:),x’);
end
y(r+1:m,end) = yf(1:m-r);
% Building the matrix A
Q(:,1) = ones(n+2,1);
C(:,1) = zeros(n+2,1);
for i = 1:n+1
Q(:,i+1) = x.^i;
C(:,i+1) = i*x.^(i-1);
end
A = C*inv(Q);
for k = 1:m
k1 = (k-1)*(n+2)+1;
k2 = k1 + n+1;
Am(k1:k2,k1:k2) = A; % Building the matrix Am
Y(k1:k2) = y(k,:); % Building the vector Y
end
Y = Y’; % Make it a column vector
Y1 = Y * 1.1;
iter = 0;
maxiter = 100;
F = zeros(m*(n+2),1);
Fa = zeros(m*(n+2),1);
dY = zeros(m*(n+2),1);
position = []; % Collocation points excluding boundary conditions
for k = 1:m
if k <= r
position = [position, (k-1)*(n+2)+[2:n+2] ];
else
position = [position, (k-1)*(n+2)+[1:n+1] ];
end
end
% Newton’s method
while max(abs(Y1 – Y)) > tol & iter < maxiter
iter = iter + 1;
fprintf(‘ Iteration %3dn’,iter)
Y1 = Y;
% Building the vector F
for k = 1:n+2
F(k : n+2 : (m-1)*(n+2)+k) = …
feval(ODEfile,x(k),Y(k : n+2 : (m-1)*(n+2)+k),varargin{:});
end
fnk = Am * Y – F;
% Set dY for derivation
for k = 1:m*(n+1)
if Y(position(k)) ~= 0
dY(position(k)) = Y(position(k)) / 100;
else
dY(position(k)) = 0.01;
end
end
% Calculation of the Jacobian matrix
for k = 1:m
for kk = 1:n+1
a = Y;
nc = (k-1)*(n+1)+kk;
a(position(nc)) = Y(position(nc)) + dY(position(nc));
for kkk = 1:n+2
Fa(kkk : n+2 : (m-1)*(n+2)+kkk) = …
feval(ODEfile,x(kkk),a(kkk:n+2:(m-1)*(n+2)+kkk),varargin{:});
end
fnka = Am * a – Fa;
jacob(:,nc) = (fnka(position) – fnk(position))…
/ dY(position(nc));
end
end
% Next approximation of the roots
if det(jacob) == 0
Y(position) = Y(position) + max([abs(dY(position)); 1.1*tol]);
else
Y(position) = Y(position) – rho * inv(jacob) * fnk(position);
end
end
% Rearranging the y’s
for k = 1:m
k1 = (k-1)*(n+2)+1;
k2 = k1 + n+1;
y(k,:) = Y(k1:k2)’;
end
x = x’;
if iter >= maxiter
disp(‘Warning : Maximum iterations reached.’)
end% Example5_5.m
% Solution to Example 5.5. This program calculates and plots
% the concentration of cell mass, concentration of penicillin,
% optimal temperature profile, and adjoint variable of a batch
% penicillin fermentor. It uses the function COLLOCATION to
% solve the set of system and adjoint equations.
clear
clc
clf
% Input data
w = input(‘ Enter w”s as a vector : ‘);
y0 = input(‘ Vector of known initial conditions = ‘);
yf = input(‘ Vector of final conditions = ‘);
guess = input(‘ Vector of guessed initial conditions = ‘);
fname = input(‘n M-file containing the set of differential equations : ‘);
fth = input(‘ M-file containing the necessary condition function : ‘);
n = input(‘ Number of internal collocation points = ‘);
rho = input(‘ Relaxation factor = ‘);
% Solution of the set of differential equations
[t,y] = collocation(fname,0,1,y0,yf,guess,n,rho,[],w,fth);
% Temperature changes
for k = 1:n+2
options=optimset;
theta(k) = fzero(fth,30,options,y(:,k),w);
end
% Plotting the results
subplot(2,2,1), plot(t,y(1,:))
xlabel(‘Time’)
ylabel(‘Cell’)
title(‘(a)’)
subplot(2,2,2), plot(t,y(2,:))
xlabel(‘Time’)
ylabel(‘Penicillin’)
title(‘(b)’)
subplot(2,2,3), plot(t,y(3,:))
xlabel(‘Time’)
ylabel(‘First Adjoint’)
title(‘(c)’)
subplot(2,2,4), plot(t,theta)
xlabel(‘Time’)
ylabel(‘Temperature (deg C)’)
title(‘(d)’)
function f = Ex5_5_func(t,y,w,fth)
% Function Ex5_5_func.M
% This function introduces the set of ordinary differential
% equations used in Example 5.5.
% Temperature
options=optimset;
theta = fzero(fth,30,options,y,w);
% Calculating the b’s
b1 = w(1) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
if b1<0, b1=0; end
b2 = w(4) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
if b2<0, b2=1e-6; end
b3 = w(5) * (1-w(2)*(theta-w(6))^2) / (1-w(2)*(25-w(6))^2);
if b3<0, b3=0; end
% Evaluating the function values
f(1) = b1*y(1) – b1/b2*y(1)^2;
f(2) = b3*y(1);
f(3) = -b1*y(3) + 2*b1/b2*y(1)*y(3) – b3;
f = f’; % Make it a column vector
function ftheta = Ex5_5_theta(theta,y,w)
% Function Ex5_5_theta.M
% This function calculates the value of the necessary condition
% as a function of the temperature (theta). It is used in solving
% Example 5.5.
% Calculating the b’s
b1 = w(1) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
db1 = w(1)*(-w(2))*2*(theta-w(3)) / (1-w(2)*(25-w(3))^2);
b2 = w(4) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
db2 = w(4)*(-w(2))*2*(theta-w(3)) / (1-w(2)*(25-w(3))^2);
b3 = w(5) * (1-w(2)*(theta-w(6))^2) / (1-w(2)*(25-w(6))^2);
db3 = w(5)*(-w(2))*2*(theta-w(6)) / (1-w(2)*(25-w(6))^2);
% The function
ftheta = y(3)*(y(1)*db1-y(1)^2*(db1*b2-db2*b1)/b2^2)+y(1)*db3;
function [x,y] = collocation(ODEfile,x0,xf,y0,yf,guess,n,rho,tol,varargin)
%COLLOCATION Solves a boundary value set of ordinary differential
% equations by the orthogonal collocation method.
%
% [X,Y]=COLLOCATION(‘F’,X0,XF,Y0,YF,GAMMA,N) integrates the set of
% ordinary differential equations from X0 to XF by the Nth-degree
% orthogonal collocation method. The equations are contained in
% the M-file F.M. Y0, YF, and GAMMA are the vectors of initial
% conditions, final conditions, and starting guesses respectively.
% The function returns the independent variable in the vector X
% and the set of dependent variables in the matrix Y.
%
% [X,Y]=COLLOCATION(‘F’,X0,XF,Y0,YF,GAMMA,N,RHO,TOL,P1,P2,…)
% uses relaxation factor RHO and tolerance TOL for convergence
% test. Additional parameters P1, P2, … are passed directly to
% the function F. Pass an empty matrix for RHO or TOL to use the
% default value.
%
% See also SHOOTING
% (c) N. Mostoufi & A. Constantinides
% January 1, 1999
% Initialization
if nargin < 7 | isempty(n)
n = 1;
end
if nargin < 8 | isempty(rho)
rho = 1;
end
if nargin < 9 | isempty(tol)
tol = 1e-6;
end
y0 = (y0(:).’)’; % Make sure it’s a column vector
yf = (yf(:).’)’; % Make sure it’s a column vector
guess = (guess(:).’)’; % Make sure it’s a column vector
% Checking the number of guesses
if length(yf) ~= length(guess)
error(‘ The number of guessed conditions is not equal to the number of final conditions.’)
end
r = length(y0); % Number of initial conditions
m = r + length(yf); % Number of boundary conditions
% Checking the number of equations
ftest = feval(ODEfile,x0,[y0 ; guess],varargin{:});
if length(ftest) ~= m
error(‘ The number of equations is not equal to the number of boundary conditions.’)
end
fprintf(‘n Integrating. Please wait.nn’)
% Coefficients of the Legendre polynomial
for k = 0 : n/2
cl(2*k+1) = (-1)^k * gamma(2*n-2*k+1) / …
(2^n * gamma(k+1) * gamma(n-k+1) * gamma(n-2*k+1));
if k < n/2
cl(2*k+2) = 0;
end
end
zl = roots(cl); % Roots of the Legendre polynomial
z = [-1; sort(zl); 1]; % Collocation points (z)
x = (xf-x0)*z/2+(xf+x0)/2; % Collocation points (x)
% Bulding the vector of starting values of the dependent variables
[p,q] = RK(ODEfile,x0,xf,(xf-x0)/20,[y0 ; guess],2,varargin{:});
for k = 1:m
y(k,:) = spline(p,q(k,:),x’);
end
y(r+1:m,end) = yf(1:m-r);
% Building the matrix A
Q(:,1) = ones(n+2,1);
C(:,1) = zeros(n+2,1);
for i = 1:n+1
Q(:,i+1) = x.^i;
C(:,i+1) = i*x.^(i-1);
end
A = C*inv(Q);
for k = 1:m
k1 = (k-1)*(n+2)+1;
k2 = k1 + n+1;
Am(k1:k2,k1:k2) = A; % Building the matrix Am
Y(k1:k2) = y(k,:); % Building the vector Y
end
Y = Y’; % Make it a column vector
Y1 = Y * 1.1;
iter = 0;
maxiter = 100;
F = zeros(m*(n+2),1);
Fa = zeros(m*(n+2),1);
dY = zeros(m*(n+2),1);
position = []; % Collocation points excluding boundary conditions
for k = 1:m
if k <= r
position = [position, (k-1)*(n+2)+[2:n+2] ];
else
position = [position, (k-1)*(n+2)+[1:n+1] ];
end
end
% Newton’s method
while max(abs(Y1 – Y)) > tol & iter < maxiter
iter = iter + 1;
fprintf(‘ Iteration %3dn’,iter)
Y1 = Y;
% Building the vector F
for k = 1:n+2
F(k : n+2 : (m-1)*(n+2)+k) = …
feval(ODEfile,x(k),Y(k : n+2 : (m-1)*(n+2)+k),varargin{:});
end
fnk = Am * Y – F;
% Set dY for derivation
for k = 1:m*(n+1)
if Y(position(k)) ~= 0
dY(position(k)) = Y(position(k)) / 100;
else
dY(position(k)) = 0.01;
end
end
% Calculation of the Jacobian matrix
for k = 1:m
for kk = 1:n+1
a = Y;
nc = (k-1)*(n+1)+kk;
a(position(nc)) = Y(position(nc)) + dY(position(nc));
for kkk = 1:n+2
Fa(kkk : n+2 : (m-1)*(n+2)+kkk) = …
feval(ODEfile,x(kkk),a(kkk:n+2:(m-1)*(n+2)+kkk),varargin{:});
end
fnka = Am * a – Fa;
jacob(:,nc) = (fnka(position) – fnk(position))…
/ dY(position(nc));
end
end
% Next approximation of the roots
if det(jacob) == 0
Y(position) = Y(position) + max([abs(dY(position)); 1.1*tol]);
else
Y(position) = Y(position) – rho * inv(jacob) * fnk(position);
end
end
% Rearranging the y’s
for k = 1:m
k1 = (k-1)*(n+2)+1;
k2 = k1 + n+1;
y(k,:) = Y(k1:k2)’;
end
x = x’;
if iter >= maxiter
disp(‘Warning : Maximum iterations reached.’)
end % Example5_5.m
% Solution to Example 5.5. This program calculates and plots
% the concentration of cell mass, concentration of penicillin,
% optimal temperature profile, and adjoint variable of a batch
% penicillin fermentor. It uses the function COLLOCATION to
% solve the set of system and adjoint equations.
clear
clc
clf
% Input data
w = input(‘ Enter w”s as a vector : ‘);
y0 = input(‘ Vector of known initial conditions = ‘);
yf = input(‘ Vector of final conditions = ‘);
guess = input(‘ Vector of guessed initial conditions = ‘);
fname = input(‘n M-file containing the set of differential equations : ‘);
fth = input(‘ M-file containing the necessary condition function : ‘);
n = input(‘ Number of internal collocation points = ‘);
rho = input(‘ Relaxation factor = ‘);
% Solution of the set of differential equations
[t,y] = collocation(fname,0,1,y0,yf,guess,n,rho,[],w,fth);
% Temperature changes
for k = 1:n+2
options=optimset;
theta(k) = fzero(fth,30,options,y(:,k),w);
end
% Plotting the results
subplot(2,2,1), plot(t,y(1,:))
xlabel(‘Time’)
ylabel(‘Cell’)
title(‘(a)’)
subplot(2,2,2), plot(t,y(2,:))
xlabel(‘Time’)
ylabel(‘Penicillin’)
title(‘(b)’)
subplot(2,2,3), plot(t,y(3,:))
xlabel(‘Time’)
ylabel(‘First Adjoint’)
title(‘(c)’)
subplot(2,2,4), plot(t,theta)
xlabel(‘Time’)
ylabel(‘Temperature (deg C)’)
title(‘(d)’)
function f = Ex5_5_func(t,y,w,fth)
% Function Ex5_5_func.M
% This function introduces the set of ordinary differential
% equations used in Example 5.5.
% Temperature
options=optimset;
theta = fzero(fth,30,options,y,w);
% Calculating the b’s
b1 = w(1) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
if b1<0, b1=0; end
b2 = w(4) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
if b2<0, b2=1e-6; end
b3 = w(5) * (1-w(2)*(theta-w(6))^2) / (1-w(2)*(25-w(6))^2);
if b3<0, b3=0; end
% Evaluating the function values
f(1) = b1*y(1) – b1/b2*y(1)^2;
f(2) = b3*y(1);
f(3) = -b1*y(3) + 2*b1/b2*y(1)*y(3) – b3;
f = f’; % Make it a column vector
function ftheta = Ex5_5_theta(theta,y,w)
% Function Ex5_5_theta.M
% This function calculates the value of the necessary condition
% as a function of the temperature (theta). It is used in solving
% Example 5.5.
% Calculating the b’s
b1 = w(1) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
db1 = w(1)*(-w(2))*2*(theta-w(3)) / (1-w(2)*(25-w(3))^2);
b2 = w(4) * (1-w(2)*(theta-w(3))^2) / (1-w(2)*(25-w(3))^2);
db2 = w(4)*(-w(2))*2*(theta-w(3)) / (1-w(2)*(25-w(3))^2);
b3 = w(5) * (1-w(2)*(theta-w(6))^2) / (1-w(2)*(25-w(6))^2);
db3 = w(5)*(-w(2))*2*(theta-w(6)) / (1-w(2)*(25-w(6))^2);
% The function
ftheta = y(3)*(y(1)*db1-y(1)^2*(db1*b2-db2*b1)/b2^2)+y(1)*db3;
function [x,y] = collocation(ODEfile,x0,xf,y0,yf,guess,n,rho,tol,varargin)
%COLLOCATION Solves a boundary value set of ordinary differential
% equations by the orthogonal collocation method.
%
% [X,Y]=COLLOCATION(‘F’,X0,XF,Y0,YF,GAMMA,N) integrates the set of
% ordinary differential equations from X0 to XF by the Nth-degree
% orthogonal collocation method. The equations are contained in
% the M-file F.M. Y0, YF, and GAMMA are the vectors of initial
% conditions, final conditions, and starting guesses respectively.
% The function returns the independent variable in the vector X
% and the set of dependent variables in the matrix Y.
%
% [X,Y]=COLLOCATION(‘F’,X0,XF,Y0,YF,GAMMA,N,RHO,TOL,P1,P2,…)
% uses relaxation factor RHO and tolerance TOL for convergence
% test. Additional parameters P1, P2, … are passed directly to
% the function F. Pass an empty matrix for RHO or TOL to use the
% default value.
%
% See also SHOOTING
% (c) N. Mostoufi & A. Constantinides
% January 1, 1999
% Initialization
if nargin < 7 | isempty(n)
n = 1;
end
if nargin < 8 | isempty(rho)
rho = 1;
end
if nargin < 9 | isempty(tol)
tol = 1e-6;
end
y0 = (y0(:).’)’; % Make sure it’s a column vector
yf = (yf(:).’)’; % Make sure it’s a column vector
guess = (guess(:).’)’; % Make sure it’s a column vector
% Checking the number of guesses
if length(yf) ~= length(guess)
error(‘ The number of guessed conditions is not equal to the number of final conditions.’)
end
r = length(y0); % Number of initial conditions
m = r + length(yf); % Number of boundary conditions
% Checking the number of equations
ftest = feval(ODEfile,x0,[y0 ; guess],varargin{:});
if length(ftest) ~= m
error(‘ The number of equations is not equal to the number of boundary conditions.’)
end
fprintf(‘n Integrating. Please wait.nn’)
% Coefficients of the Legendre polynomial
for k = 0 : n/2
cl(2*k+1) = (-1)^k * gamma(2*n-2*k+1) / …
(2^n * gamma(k+1) * gamma(n-k+1) * gamma(n-2*k+1));
if k < n/2
cl(2*k+2) = 0;
end
end
zl = roots(cl); % Roots of the Legendre polynomial
z = [-1; sort(zl); 1]; % Collocation points (z)
x = (xf-x0)*z/2+(xf+x0)/2; % Collocation points (x)
% Bulding the vector of starting values of the dependent variables
[p,q] = RK(ODEfile,x0,xf,(xf-x0)/20,[y0 ; guess],2,varargin{:});
for k = 1:m
y(k,:) = spline(p,q(k,:),x’);
end
y(r+1:m,end) = yf(1:m-r);
% Building the matrix A
Q(:,1) = ones(n+2,1);
C(:,1) = zeros(n+2,1);
for i = 1:n+1
Q(:,i+1) = x.^i;
C(:,i+1) = i*x.^(i-1);
end
A = C*inv(Q);
for k = 1:m
k1 = (k-1)*(n+2)+1;
k2 = k1 + n+1;
Am(k1:k2,k1:k2) = A; % Building the matrix Am
Y(k1:k2) = y(k,:); % Building the vector Y
end
Y = Y’; % Make it a column vector
Y1 = Y * 1.1;
iter = 0;
maxiter = 100;
F = zeros(m*(n+2),1);
Fa = zeros(m*(n+2),1);
dY = zeros(m*(n+2),1);
position = []; % Collocation points excluding boundary conditions
for k = 1:m
if k <= r
position = [position, (k-1)*(n+2)+[2:n+2] ];
else
position = [position, (k-1)*(n+2)+[1:n+1] ];
end
end
% Newton’s method
while max(abs(Y1 – Y)) > tol & iter < maxiter
iter = iter + 1;
fprintf(‘ Iteration %3dn’,iter)
Y1 = Y;
% Building the vector F
for k = 1:n+2
F(k : n+2 : (m-1)*(n+2)+k) = …
feval(ODEfile,x(k),Y(k : n+2 : (m-1)*(n+2)+k),varargin{:});
end
fnk = Am * Y – F;
% Set dY for derivation
for k = 1:m*(n+1)
if Y(position(k)) ~= 0
dY(position(k)) = Y(position(k)) / 100;
else
dY(position(k)) = 0.01;
end
end
% Calculation of the Jacobian matrix
for k = 1:m
for kk = 1:n+1
a = Y;
nc = (k-1)*(n+1)+kk;
a(position(nc)) = Y(position(nc)) + dY(position(nc));
for kkk = 1:n+2
Fa(kkk : n+2 : (m-1)*(n+2)+kkk) = …
feval(ODEfile,x(kkk),a(kkk:n+2:(m-1)*(n+2)+kkk),varargin{:});
end
fnka = Am * a – Fa;
jacob(:,nc) = (fnka(position) – fnk(position))…
/ dY(position(nc));
end
end
% Next approximation of the roots
if det(jacob) == 0
Y(position) = Y(position) + max([abs(dY(position)); 1.1*tol]);
else
Y(position) = Y(position) – rho * inv(jacob) * fnk(position);
end
end
% Rearranging the y’s
for k = 1:m
k1 = (k-1)*(n+2)+1;
k2 = k1 + n+1;
y(k,:) = Y(k1:k2)’;
end
x = x’;
if iter >= maxiter
disp(‘Warning : Maximum iterations reached.’)
end collocation MATLAB Answers — New Questions
THD analysis of mathematical simulink model
I have done mathematical modelling of my system in simulink then how to perform the THD analysisI have done mathematical modelling of my system in simulink then how to perform the THD analysis I have done mathematical modelling of my system in simulink then how to perform the THD analysis thd, mathematical model MATLAB Answers — New Questions
Quic~kB00ks Unrecoverable Error When Opening Company File
Hi everyone,
I’m encountering a frustrating issue with Quic~kB00ks. Every time I try to open my company file, I receive an “Unrecoverable Error” message. The error codes vary, but it’s making it impossible for me to access my data. I’ve tried restarting my computer and running Quic~kB00ks as an administrator, but nothing seems to work. Has anyone else experienced this issue? What steps can I take to resolve it?
Hi everyone,I’m encountering a frustrating issue with Quic~kB00ks. Every time I try to open my company file, I receive an “Unrecoverable Error” message. The error codes vary, but it’s making it impossible for me to access my data. I’ve tried restarting my computer and running Quic~kB00ks as an administrator, but nothing seems to work. Has anyone else experienced this issue? What steps can I take to resolve it? Read More
Quick~B00ks Automatic Backup Not Working – Help Needed!
Hi everyone,
I’m having an issue with Quick~B00ks where the automatic backup feature isn’t working. I’ve set it up to back up my company files daily, but it seems like it’s not creating any backups at all. I’ve double-checked the settings, and everything seems correct.
Has anyone else encountered this problem? What steps did you take to resolve it? I really need to ensure my data is backed up regularly. Any advice or solutions would be greatly appreciated!
Hi everyone,I’m having an issue with Quick~B00ks where the automatic backup feature isn’t working. I’ve set it up to back up my company files daily, but it seems like it’s not creating any backups at all. I’ve double-checked the settings, and everything seems correct.Has anyone else encountered this problem? What steps did you take to resolve it? I really need to ensure my data is backed up regularly. Any advice or solutions would be greatly appreciated! Read More
Outlook Add-On: Measurably improving meeting effectiveness
Hi everyone,
We have built an add-on that syncs all Outlook calendar data from your organization and turns it into individual & organizational recommendations based on best practices for running effective meetings.
We have two clients and great feedback so far, being able to save 15+ hours/meetings in the first week, reducing average meeting length across the org by 8 min and more.
Looking for more early adopters that are fed up with ineffective meetings.
If this is you, feel free to book time with me directly here or be part of our benchmarking report.
Dm for more info. Appreciate being able to tap into this expert + user network!!
Hi everyone,We have built an add-on that syncs all Outlook calendar data from your organization and turns it into individual & organizational recommendations based on best practices for running effective meetings. We have two clients and great feedback so far, being able to save 15+ hours/meetings in the first week, reducing average meeting length across the org by 8 min and more. Looking for more early adopters that are fed up with ineffective meetings. If this is you, feel free to book time with me directly here or be part of our benchmarking report. Dm for more info. Appreciate being able to tap into this expert + user network!! Read More
Referencing sheets based on a drop-down option
Hi there guys! Hopefully this question isn’t super complicated, but I am trying to make things simple for my co-workers. We’re making a project hours tracker using excel since our team is too small to need an online project management service. Here’s the gist of what I want to do…
In one workbook, each employee has identical worksheet templates which can be filled in as needed with tasks done during the month. Let’s say we have 3 employees on the team. That means, our workbook contains 3 separate worksheets which act as individual logs for each employee. The name of each worksheet is the name of the employee (‘Employee Name’). In their respective worksheets, employees are to log a work entry by filling in three columns per entry: the project name (drop-down selection), a description of the task, and then the numbers of hours spent on that task.
Also in the workbook, there is a fourth worksheet which is for our supervisor. I would like for him, from a drop down, to select the employee’s name he wishes to make an hours report on. So, when he selects the name…maybe we can say John Smith is the employee…the worksheet essentially fills out a report with the projects John Smith worked on and the total hours for each, then creates a pie chart showing percentages.
Most of the functionality of this idea is working pretty well, but for the tallying of hours in the final report, I’m having trouble getting functions to reference the appropriate worksheet. To tally hours, I’m using a SUMIF formula that looks like this:
=SUMIF(‘Employee Name’!A:A,’Hours Report’!A3,’Employee Name’!D:D)
‘Employee Name’!A:A references the full column of project names in the employee log. ‘Hours Report’!A3 references the cell with the project name being tallied in the final report. ‘Employee Name’!D:D references the column of hours logged by the employee.
The worksheet reference name (‘Employee Name’) needs to be changed based on what employee the final report is about, so it can address the appropriate log to sum hours from. I haven’t a clue how to do thus, and tried things like ADDRESS, VLOOKUP, and others without much luck. Any suggestions, thoughts, or solutions?
Hi there guys! Hopefully this question isn’t super complicated, but I am trying to make things simple for my co-workers. We’re making a project hours tracker using excel since our team is too small to need an online project management service. Here’s the gist of what I want to do…In one workbook, each employee has identical worksheet templates which can be filled in as needed with tasks done during the month. Let’s say we have 3 employees on the team. That means, our workbook contains 3 separate worksheets which act as individual logs for each employee. The name of each worksheet is the name of the employee (‘Employee Name’). In their respective worksheets, employees are to log a work entry by filling in three columns per entry: the project name (drop-down selection), a description of the task, and then the numbers of hours spent on that task. Also in the workbook, there is a fourth worksheet which is for our supervisor. I would like for him, from a drop down, to select the employee’s name he wishes to make an hours report on. So, when he selects the name…maybe we can say John Smith is the employee…the worksheet essentially fills out a report with the projects John Smith worked on and the total hours for each, then creates a pie chart showing percentages.Most of the functionality of this idea is working pretty well, but for the tallying of hours in the final report, I’m having trouble getting functions to reference the appropriate worksheet. To tally hours, I’m using a SUMIF formula that looks like this:=SUMIF(‘Employee Name’!A:A,’Hours Report’!A3,’Employee Name’!D:D) ‘Employee Name’!A:A references the full column of project names in the employee log. ‘Hours Report’!A3 references the cell with the project name being tallied in the final report. ‘Employee Name’!D:D references the column of hours logged by the employee. The worksheet reference name (‘Employee Name’) needs to be changed based on what employee the final report is about, so it can address the appropriate log to sum hours from. I haven’t a clue how to do thus, and tried things like ADDRESS, VLOOKUP, and others without much luck. Any suggestions, thoughts, or solutions? Read More
SharePoint search no longer available for nearly all users
Hello Community,
we currently have a problem with a customers SharePoint site collection.
From all users, only one user account can search for documents on the site collection. No other user can search for documents anymore.
All the users who are searching for documents have the required permissions on both the library and document, when the users navigate manually to the document, they can open it – so there should be no permission problem here.
we also checked if the libraries and lists are searchable (in the library settings), which is positive.
We also triggered a reindex multiple times over the last few days, but that didn’t really help.
I don’t know where the problem is, since one user seems to be able to search for documents but nobody else can.
Can anybody give us some advice on what to check next or what this problem is?
Hello Community, we currently have a problem with a customers SharePoint site collection.From all users, only one user account can search for documents on the site collection. No other user can search for documents anymore.All the users who are searching for documents have the required permissions on both the library and document, when the users navigate manually to the document, they can open it – so there should be no permission problem here.we also checked if the libraries and lists are searchable (in the library settings), which is positive. We also triggered a reindex multiple times over the last few days, but that didn’t really help. I don’t know where the problem is, since one user seems to be able to search for documents but nobody else can. Can anybody give us some advice on what to check next or what this problem is? Read More
Sharepoint List Validation
I have a status column in a SharePoint list. I need to write validation to make sure the statuses go in order. The correct order for all entries should be ” not started” -> ” In Work” -> “Complete”. I also want to make it so that if the list item is a “Material Site transfer” to “XYZ city” it will allow you to choose ” in transit” so the order would be ” not started” -> ” In Work” -> ” in transit” ->”Complete” but only if the Request type = material site transfer and To location = XYZ city. Any help would be appreciated, Im not savvy with coding.
I have a status column in a SharePoint list. I need to write validation to make sure the statuses go in order. The correct order for all entries should be ” not started” -> ” In Work” -> “Complete”. I also want to make it so that if the list item is a “Material Site transfer” to “XYZ city” it will allow you to choose ” in transit” so the order would be ” not started” -> ” In Work” -> ” in transit” ->”Complete” but only if the Request type = material site transfer and To location = XYZ city. Any help would be appreciated, Im not savvy with coding. Read More
Please help
I have been messing with conditional formatting all day and have no idea how to figure this out.
Please help us as this is will greatly help our unit save so much time, thank you so much!!
PS: I manually colored these boxes to show how I wish the formatting would look like after inserting formular/rules.
I have been messing with conditional formatting all day and have no idea how to figure this out.Please help us as this is will greatly help our unit save so much time, thank you so much!!PS: I manually colored these boxes to show how I wish the formatting would look like after inserting formular/rules. Read More
Azure Data Scientist Associate
Hi everyone,
I was wandering if anyone can help me.
I have completed the AI Fundamentals (AI-900) exam, the Data Fundamentals (DP-900) exam and the Azure Data Scientist Associate (DP-100) exam. This has really furthered my knowledge on becoming a data scientist.
What is the next step? How do I apply for jobs and further my knowledge?
Thanks
Josh
Hi everyone,I was wandering if anyone can help me.I have completed the AI Fundamentals (AI-900) exam, the Data Fundamentals (DP-900) exam and the Azure Data Scientist Associate (DP-100) exam. This has really furthered my knowledge on becoming a data scientist.What is the next step? How do I apply for jobs and further my knowledge?ThanksJosh Read More
Can’t manually add booking or edit a booking
Hey! I’m desperate for some help!
For the last couple days, I can’t manually add a booking to my shared calendar nor can I edit one. I’m able to click on the day I want to add a booking and I’m able to click the booking I want to edit but when it comes time to click “create booking” or “edit booking” to publish it on the calendar, the box just blinks and doesn’t do anything. I’ve tried having a coworker add a booking or edit one and he also is having the same problem so it’s not just my computer.
What’s weird is that I can add time off with no problem. That’s the only thing Bookings will let me put on the calendar.
Anyone have any idea what the problem may be?? I’ve tried googling but I can’t find anyone on the problem I’ve been having.
Thank you!
Hey! I’m desperate for some help! For the last couple days, I can’t manually add a booking to my shared calendar nor can I edit one. I’m able to click on the day I want to add a booking and I’m able to click the booking I want to edit but when it comes time to click “create booking” or “edit booking” to publish it on the calendar, the box just blinks and doesn’t do anything. I’ve tried having a coworker add a booking or edit one and he also is having the same problem so it’s not just my computer. What’s weird is that I can add time off with no problem. That’s the only thing Bookings will let me put on the calendar. Anyone have any idea what the problem may be?? I’ve tried googling but I can’t find anyone on the problem I’ve been having. Thank you! Read More
How to Fix Quick~B00ks Abort Error During Company File Access?
Hi everyone,
I’m encountering an issue with Quick~B00ks where the program abruptly shuts down with an “Abort Error” message whenever I try to access my company file. This has been happening consistently over the past few days and it’s really affecting my workflow. I’ve tried restarting my computer and updating Quick~B00ks to the latest version, but the problem persists. Has anyone else experienced this issue? What steps can I take to resolve this error?
Hi everyone,I’m encountering an issue with Quick~B00ks where the program abruptly shuts down with an “Abort Error” message whenever I try to access my company file. This has been happening consistently over the past few days and it’s really affecting my workflow. I’ve tried restarting my computer and updating Quick~B00ks to the latest version, but the problem persists. Has anyone else experienced this issue? What steps can I take to resolve this error? Read More
Announcing API Management and API Center Community Live Stream on Thursday, July 25th
Microsoft Tech Community – Latest Blogs –Read More