Category: News
STM32H753ZI Toolchain Folder Name Conflict
I’m trying to generate C code from a block in my Simulink model and deploy this to an STM Nucleo board with the STM32H753ZIT6 processor. I am able to generate C code from my model but have so far been unable to deploy it to the board. I have followed the instructions at https://uk.mathworks.com/help/ecoder/stm32-setup-and-configuration.html to setup the STM32 support package but when I right click the block and select "Deploy this subsystem to hardware", I get the following error:
Error:The definition of property ‘TOOLCHAIN_FOLDER_NAME’ in class ‘stm32cube.mdkarm’ differs from its definition in the superclass ‘stm32cube.mxprojectParser’. This is caused by either conflicting access permissions or differing values of the Constant attribute.
Has anyone come across this before? I cannot find the classes the error is referring to.I’m trying to generate C code from a block in my Simulink model and deploy this to an STM Nucleo board with the STM32H753ZIT6 processor. I am able to generate C code from my model but have so far been unable to deploy it to the board. I have followed the instructions at https://uk.mathworks.com/help/ecoder/stm32-setup-and-configuration.html to setup the STM32 support package but when I right click the block and select "Deploy this subsystem to hardware", I get the following error:
Error:The definition of property ‘TOOLCHAIN_FOLDER_NAME’ in class ‘stm32cube.mdkarm’ differs from its definition in the superclass ‘stm32cube.mxprojectParser’. This is caused by either conflicting access permissions or differing values of the Constant attribute.
Has anyone come across this before? I cannot find the classes the error is referring to. I’m trying to generate C code from a block in my Simulink model and deploy this to an STM Nucleo board with the STM32H753ZIT6 processor. I am able to generate C code from my model but have so far been unable to deploy it to the board. I have followed the instructions at https://uk.mathworks.com/help/ecoder/stm32-setup-and-configuration.html to setup the STM32 support package but when I right click the block and select "Deploy this subsystem to hardware", I get the following error:
Error:The definition of property ‘TOOLCHAIN_FOLDER_NAME’ in class ‘stm32cube.mdkarm’ differs from its definition in the superclass ‘stm32cube.mxprojectParser’. This is caused by either conflicting access permissions or differing values of the Constant attribute.
Has anyone come across this before? I cannot find the classes the error is referring to. stm32, embedded coder MATLAB Answers — New Questions
Function dnlim unrecognized.
I am trying to build a subsuircuit library using a netlist of ADCMP604 in matlab. The netlist is given below. On running the following commands :
subcircuit2ssc(‘ADCMP604.cir’,’+comp_1′);
ssc_build comp_1;
I am getting the following error:
>> convert3
Error using spiceSubckt/getFunctionCalls
Function dnlim unrecognized.
Error in spiceSubckt/loadSubckt
Error in spiceSubckt
Error in subcircuit2ssc
Error in subcircuit2ssc (line 31)
subcircuit2ssc(netlist,target);
Error in convert3 (line 1)
subcircuit2ssc(‘ADCMP604.cir’,’+comp_1′);
How do I resolve this?
* ADCMP604 SPICE Macro-model – BETA
* Description: RR, 2.5 to 5.5V, SS, LVDS Comparator
* Developed by: AR/ADGT
* Revision History:
* 1.0 (1/2021) – AR – BETA release
* Copyright (c) 1998-2021 Analog Devices, Inc. All rights reserved.
* Not Modeled:
* Temperature effects
* PSRR vs Frequency
* CMRR vs Frequency
*
* Parameters modeled include:
* VOS
* IVR
* Input Impedance
* Active Gain
* VOD
* AC Performance
* Supply Range and Current
*
* This is a BETA model only.
* This is not the final model.
*
* Node Assignments
* Q
* | VEE
* | | Vp
* | | | Vn
* | | | | VCCI/VCCO
* | | | | | QB
* | | | | | |
.subckt ADCMP604 1 2 3 4 5 6
B1 0 VDIN I=10u*dnlim(uplim(V(3),V(5)+.2,.1), V(2)-.5 ,.1)+1n*V(3)
B2 VDIN 0 I=10u*dnlim(uplim(V(4),V(5)+.2,.1), V(2)-.5, .1)+1n*V(4)
C1 VDIN 0 .5f Rpar=470k
D5 0 VDH0 DLAT
C4 4 2 1p Rpar=370k
C10 3 2 1p Rpar=370k
C7 5 1 200f
C8 1 2 200f
A6 N004 0 N002 0 0 0 VDH0 0 OTA g=500u linear Vlow=-1e308 Vhigh=1e308
D6 0 N004 DLAT
C3 N004 0 1p
G1 0 N004 0 VDH0 500µ
R4 N001 N003 14.5k
A8 N001 2 0 0 0 N002 0 0 SCHMITT vt=.4 vh=0 trise=1n tfall=1.5n
D1 VDIN 0 DVGAIN
D3 N003 2 DBLE
D2 5 4 DBIASR
D4 4 2 DBIASF
D7 5 3 DBIASR
D8 3 2 DBIASF
C15 5 6 200f
C16 6 2 200f
D10 5 2 DBURNSDI
R1 5 2 19.2k
D11 5 2 DBURNSDO
D12 2 6 DESD
D13 6 5 DESD
D14 1 5 DESD
D15 2 1 DESD
D17 4 5 DESD
D16 2 4 DESD
D18 4 3 DBIASC
D9 3 5 DESD
D19 2 3 DESD
R2 1 Vcm 10Meg
R5 Vcm 6 10Meg
M1 N010 N010 2 2 NPD
M2 1 N010 2 2 NPD M=100
B4 2 N010 I=(17.5u+1u*V(0))*(1-V(VDH))
D22 2 N010 DLIM1
M3 N008 N008 5 5 PPU
M4 1 N008 5 5 PPU M=100
B5 N008 5 I=(17.5u-1u*V(0))*(V(VDH)+1)
D23 N008 5 DLIM1
M5 N012 N012 2 2 NPD
M6 6 N012 2 2 NPD M=100
B6 2 N012 I=(17.5u+1u*V(0))*(V(VDH)+1)
D24 2 N012 DLIM1
M7 N011 N011 5 5 PPU
M8 6 N011 5 5 PPU M=100
B7 N011 5 I=(17.5u-1u*V(0))*(1-V(VDH))
D25 N011 5 DLIM1
C2 VDH0 0 40f
B8 0 VDH0 I=100u*tanh(V(VDIN)/50m)*uplim(dnlim(100m*V(5,2)+1,1,.1),1.5,.1)
A2 0 VDH0 0 0 0 0 VDH 0 OTA g=6.5m iout=5m Rout=1k Cout=700f vlow=-1 vhigh=1
C9 VDH0 0 q=120f*dnlim(x,.7,.1)**1.5-100f*dnlim(-x,.7,.1)**1.5
D26 VDIN 0 DVLIM
C12 1 6 3p
A3 2 Vcm 0 0 0 0 0 0 OTA g=100m iout=17.5u ref=-1.26 Rout=1Meg Cout=1f vlow=-1e308 vhigh=1e308
C13 5 2 5p Rpar=83k
C14 N001 2 1p Rpar=100
I1 2 N001 12.52m
S1 2 5 5 0 SVDDP
.model SVDDP SW(level=2 Ron=10 Roff=100Meg vt=.5 vh=-.2 ilimit=10.36m)
.model DVGAIN D(Ron=15k Roff=2Meg vfwd=15.3m epsilon=10m vrev=15.3m revepsilon=10m)
.model DVLIM D(Ron=1k Roff=100Meg vfwd=60m epsilon=10m vrev=60m revepsilon=10m)
.model DBLE D(Ron=31k Roff=1Meg vfwd=1.3 epsilon=100m)
.model DLAT D(Ron=1 Roff=76k Vfwd=1 Vrev=1 epsilon=.9 revepsilon=.9)
.model DBIASF D(Ron=300k Roff=1G vfwd=-400m epsilon=200m ilimit=2u )
.model DBIASR D(Ron=80k Roff=1G vfwd=1 epsilon=150m ilimit=2u )
.model DESD D(Ron=100 Roff=1G vfwd=650m epsilon=500m)
.model DBURNSDI D(Ron=100 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=500u)
.model DBURNSDO D(Ron=100 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=209u)
.model DP D(Ron=1000 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=20m)
.model DBIASC D(Roff=100Meg Ron=750k vfwd=10u vrev=10u epsilon=10u revepsilon=10u ilimit=1u revilimit=1u)
.model NPD VDMOS(kp=72.45u ksubthres=.1 vto=1)
.model PPU VDMOS(kp=72.45u vto=-1 ksubthres=.1 pchan)
.model DLIM1 D(Ron=100 Roff=1G vfwd=1 epsilon=500m)
.model DSHT D(Ron=10k Roff=100Meg vfwd=2.2 epsilon=500m ilimit=.8u)
.ends ADCMP604I am trying to build a subsuircuit library using a netlist of ADCMP604 in matlab. The netlist is given below. On running the following commands :
subcircuit2ssc(‘ADCMP604.cir’,’+comp_1′);
ssc_build comp_1;
I am getting the following error:
>> convert3
Error using spiceSubckt/getFunctionCalls
Function dnlim unrecognized.
Error in spiceSubckt/loadSubckt
Error in spiceSubckt
Error in subcircuit2ssc
Error in subcircuit2ssc (line 31)
subcircuit2ssc(netlist,target);
Error in convert3 (line 1)
subcircuit2ssc(‘ADCMP604.cir’,’+comp_1′);
How do I resolve this?
* ADCMP604 SPICE Macro-model – BETA
* Description: RR, 2.5 to 5.5V, SS, LVDS Comparator
* Developed by: AR/ADGT
* Revision History:
* 1.0 (1/2021) – AR – BETA release
* Copyright (c) 1998-2021 Analog Devices, Inc. All rights reserved.
* Not Modeled:
* Temperature effects
* PSRR vs Frequency
* CMRR vs Frequency
*
* Parameters modeled include:
* VOS
* IVR
* Input Impedance
* Active Gain
* VOD
* AC Performance
* Supply Range and Current
*
* This is a BETA model only.
* This is not the final model.
*
* Node Assignments
* Q
* | VEE
* | | Vp
* | | | Vn
* | | | | VCCI/VCCO
* | | | | | QB
* | | | | | |
.subckt ADCMP604 1 2 3 4 5 6
B1 0 VDIN I=10u*dnlim(uplim(V(3),V(5)+.2,.1), V(2)-.5 ,.1)+1n*V(3)
B2 VDIN 0 I=10u*dnlim(uplim(V(4),V(5)+.2,.1), V(2)-.5, .1)+1n*V(4)
C1 VDIN 0 .5f Rpar=470k
D5 0 VDH0 DLAT
C4 4 2 1p Rpar=370k
C10 3 2 1p Rpar=370k
C7 5 1 200f
C8 1 2 200f
A6 N004 0 N002 0 0 0 VDH0 0 OTA g=500u linear Vlow=-1e308 Vhigh=1e308
D6 0 N004 DLAT
C3 N004 0 1p
G1 0 N004 0 VDH0 500µ
R4 N001 N003 14.5k
A8 N001 2 0 0 0 N002 0 0 SCHMITT vt=.4 vh=0 trise=1n tfall=1.5n
D1 VDIN 0 DVGAIN
D3 N003 2 DBLE
D2 5 4 DBIASR
D4 4 2 DBIASF
D7 5 3 DBIASR
D8 3 2 DBIASF
C15 5 6 200f
C16 6 2 200f
D10 5 2 DBURNSDI
R1 5 2 19.2k
D11 5 2 DBURNSDO
D12 2 6 DESD
D13 6 5 DESD
D14 1 5 DESD
D15 2 1 DESD
D17 4 5 DESD
D16 2 4 DESD
D18 4 3 DBIASC
D9 3 5 DESD
D19 2 3 DESD
R2 1 Vcm 10Meg
R5 Vcm 6 10Meg
M1 N010 N010 2 2 NPD
M2 1 N010 2 2 NPD M=100
B4 2 N010 I=(17.5u+1u*V(0))*(1-V(VDH))
D22 2 N010 DLIM1
M3 N008 N008 5 5 PPU
M4 1 N008 5 5 PPU M=100
B5 N008 5 I=(17.5u-1u*V(0))*(V(VDH)+1)
D23 N008 5 DLIM1
M5 N012 N012 2 2 NPD
M6 6 N012 2 2 NPD M=100
B6 2 N012 I=(17.5u+1u*V(0))*(V(VDH)+1)
D24 2 N012 DLIM1
M7 N011 N011 5 5 PPU
M8 6 N011 5 5 PPU M=100
B7 N011 5 I=(17.5u-1u*V(0))*(1-V(VDH))
D25 N011 5 DLIM1
C2 VDH0 0 40f
B8 0 VDH0 I=100u*tanh(V(VDIN)/50m)*uplim(dnlim(100m*V(5,2)+1,1,.1),1.5,.1)
A2 0 VDH0 0 0 0 0 VDH 0 OTA g=6.5m iout=5m Rout=1k Cout=700f vlow=-1 vhigh=1
C9 VDH0 0 q=120f*dnlim(x,.7,.1)**1.5-100f*dnlim(-x,.7,.1)**1.5
D26 VDIN 0 DVLIM
C12 1 6 3p
A3 2 Vcm 0 0 0 0 0 0 OTA g=100m iout=17.5u ref=-1.26 Rout=1Meg Cout=1f vlow=-1e308 vhigh=1e308
C13 5 2 5p Rpar=83k
C14 N001 2 1p Rpar=100
I1 2 N001 12.52m
S1 2 5 5 0 SVDDP
.model SVDDP SW(level=2 Ron=10 Roff=100Meg vt=.5 vh=-.2 ilimit=10.36m)
.model DVGAIN D(Ron=15k Roff=2Meg vfwd=15.3m epsilon=10m vrev=15.3m revepsilon=10m)
.model DVLIM D(Ron=1k Roff=100Meg vfwd=60m epsilon=10m vrev=60m revepsilon=10m)
.model DBLE D(Ron=31k Roff=1Meg vfwd=1.3 epsilon=100m)
.model DLAT D(Ron=1 Roff=76k Vfwd=1 Vrev=1 epsilon=.9 revepsilon=.9)
.model DBIASF D(Ron=300k Roff=1G vfwd=-400m epsilon=200m ilimit=2u )
.model DBIASR D(Ron=80k Roff=1G vfwd=1 epsilon=150m ilimit=2u )
.model DESD D(Ron=100 Roff=1G vfwd=650m epsilon=500m)
.model DBURNSDI D(Ron=100 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=500u)
.model DBURNSDO D(Ron=100 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=209u)
.model DP D(Ron=1000 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=20m)
.model DBIASC D(Roff=100Meg Ron=750k vfwd=10u vrev=10u epsilon=10u revepsilon=10u ilimit=1u revilimit=1u)
.model NPD VDMOS(kp=72.45u ksubthres=.1 vto=1)
.model PPU VDMOS(kp=72.45u vto=-1 ksubthres=.1 pchan)
.model DLIM1 D(Ron=100 Roff=1G vfwd=1 epsilon=500m)
.model DSHT D(Ron=10k Roff=100Meg vfwd=2.2 epsilon=500m ilimit=.8u)
.ends ADCMP604 I am trying to build a subsuircuit library using a netlist of ADCMP604 in matlab. The netlist is given below. On running the following commands :
subcircuit2ssc(‘ADCMP604.cir’,’+comp_1′);
ssc_build comp_1;
I am getting the following error:
>> convert3
Error using spiceSubckt/getFunctionCalls
Function dnlim unrecognized.
Error in spiceSubckt/loadSubckt
Error in spiceSubckt
Error in subcircuit2ssc
Error in subcircuit2ssc (line 31)
subcircuit2ssc(netlist,target);
Error in convert3 (line 1)
subcircuit2ssc(‘ADCMP604.cir’,’+comp_1′);
How do I resolve this?
* ADCMP604 SPICE Macro-model – BETA
* Description: RR, 2.5 to 5.5V, SS, LVDS Comparator
* Developed by: AR/ADGT
* Revision History:
* 1.0 (1/2021) – AR – BETA release
* Copyright (c) 1998-2021 Analog Devices, Inc. All rights reserved.
* Not Modeled:
* Temperature effects
* PSRR vs Frequency
* CMRR vs Frequency
*
* Parameters modeled include:
* VOS
* IVR
* Input Impedance
* Active Gain
* VOD
* AC Performance
* Supply Range and Current
*
* This is a BETA model only.
* This is not the final model.
*
* Node Assignments
* Q
* | VEE
* | | Vp
* | | | Vn
* | | | | VCCI/VCCO
* | | | | | QB
* | | | | | |
.subckt ADCMP604 1 2 3 4 5 6
B1 0 VDIN I=10u*dnlim(uplim(V(3),V(5)+.2,.1), V(2)-.5 ,.1)+1n*V(3)
B2 VDIN 0 I=10u*dnlim(uplim(V(4),V(5)+.2,.1), V(2)-.5, .1)+1n*V(4)
C1 VDIN 0 .5f Rpar=470k
D5 0 VDH0 DLAT
C4 4 2 1p Rpar=370k
C10 3 2 1p Rpar=370k
C7 5 1 200f
C8 1 2 200f
A6 N004 0 N002 0 0 0 VDH0 0 OTA g=500u linear Vlow=-1e308 Vhigh=1e308
D6 0 N004 DLAT
C3 N004 0 1p
G1 0 N004 0 VDH0 500µ
R4 N001 N003 14.5k
A8 N001 2 0 0 0 N002 0 0 SCHMITT vt=.4 vh=0 trise=1n tfall=1.5n
D1 VDIN 0 DVGAIN
D3 N003 2 DBLE
D2 5 4 DBIASR
D4 4 2 DBIASF
D7 5 3 DBIASR
D8 3 2 DBIASF
C15 5 6 200f
C16 6 2 200f
D10 5 2 DBURNSDI
R1 5 2 19.2k
D11 5 2 DBURNSDO
D12 2 6 DESD
D13 6 5 DESD
D14 1 5 DESD
D15 2 1 DESD
D17 4 5 DESD
D16 2 4 DESD
D18 4 3 DBIASC
D9 3 5 DESD
D19 2 3 DESD
R2 1 Vcm 10Meg
R5 Vcm 6 10Meg
M1 N010 N010 2 2 NPD
M2 1 N010 2 2 NPD M=100
B4 2 N010 I=(17.5u+1u*V(0))*(1-V(VDH))
D22 2 N010 DLIM1
M3 N008 N008 5 5 PPU
M4 1 N008 5 5 PPU M=100
B5 N008 5 I=(17.5u-1u*V(0))*(V(VDH)+1)
D23 N008 5 DLIM1
M5 N012 N012 2 2 NPD
M6 6 N012 2 2 NPD M=100
B6 2 N012 I=(17.5u+1u*V(0))*(V(VDH)+1)
D24 2 N012 DLIM1
M7 N011 N011 5 5 PPU
M8 6 N011 5 5 PPU M=100
B7 N011 5 I=(17.5u-1u*V(0))*(1-V(VDH))
D25 N011 5 DLIM1
C2 VDH0 0 40f
B8 0 VDH0 I=100u*tanh(V(VDIN)/50m)*uplim(dnlim(100m*V(5,2)+1,1,.1),1.5,.1)
A2 0 VDH0 0 0 0 0 VDH 0 OTA g=6.5m iout=5m Rout=1k Cout=700f vlow=-1 vhigh=1
C9 VDH0 0 q=120f*dnlim(x,.7,.1)**1.5-100f*dnlim(-x,.7,.1)**1.5
D26 VDIN 0 DVLIM
C12 1 6 3p
A3 2 Vcm 0 0 0 0 0 0 OTA g=100m iout=17.5u ref=-1.26 Rout=1Meg Cout=1f vlow=-1e308 vhigh=1e308
C13 5 2 5p Rpar=83k
C14 N001 2 1p Rpar=100
I1 2 N001 12.52m
S1 2 5 5 0 SVDDP
.model SVDDP SW(level=2 Ron=10 Roff=100Meg vt=.5 vh=-.2 ilimit=10.36m)
.model DVGAIN D(Ron=15k Roff=2Meg vfwd=15.3m epsilon=10m vrev=15.3m revepsilon=10m)
.model DVLIM D(Ron=1k Roff=100Meg vfwd=60m epsilon=10m vrev=60m revepsilon=10m)
.model DBLE D(Ron=31k Roff=1Meg vfwd=1.3 epsilon=100m)
.model DLAT D(Ron=1 Roff=76k Vfwd=1 Vrev=1 epsilon=.9 revepsilon=.9)
.model DBIASF D(Ron=300k Roff=1G vfwd=-400m epsilon=200m ilimit=2u )
.model DBIASR D(Ron=80k Roff=1G vfwd=1 epsilon=150m ilimit=2u )
.model DESD D(Ron=100 Roff=1G vfwd=650m epsilon=500m)
.model DBURNSDI D(Ron=100 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=500u)
.model DBURNSDO D(Ron=100 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=209u)
.model DP D(Ron=1000 Roff=1Meg vfwd=1.6 epsilon=500m ilimit=20m)
.model DBIASC D(Roff=100Meg Ron=750k vfwd=10u vrev=10u epsilon=10u revepsilon=10u ilimit=1u revilimit=1u)
.model NPD VDMOS(kp=72.45u ksubthres=.1 vto=1)
.model PPU VDMOS(kp=72.45u vto=-1 ksubthres=.1 pchan)
.model DLIM1 D(Ron=100 Roff=1G vfwd=1 epsilon=500m)
.model DSHT D(Ron=10k Roff=100Meg vfwd=2.2 epsilon=500m ilimit=.8u)
.ends ADCMP604 matlab, simscape MATLAB Answers — New Questions
Why does the MATLAB Web App Server service fail to start?
I am using MATLAB Web App Server (product version). When I attempt to start my server using webapps-start or webapps-restart, I receive the following error:
MATLAB Web App Server service failed to start.
Check the logs files for more information:
C:ProgramDataMathWorkswebappsR2024alogswebapps_<timestamp>.log
C:ProgramDataMathWorkswebappsR2024alogswebapps_service_start.err
C:ProgramDataMathWorkswebappsR2024alogswebapps_service_start.out
How do I troubleshoot this?I am using MATLAB Web App Server (product version). When I attempt to start my server using webapps-start or webapps-restart, I receive the following error:
MATLAB Web App Server service failed to start.
Check the logs files for more information:
C:ProgramDataMathWorkswebappsR2024alogswebapps_<timestamp>.log
C:ProgramDataMathWorkswebappsR2024alogswebapps_service_start.err
C:ProgramDataMathWorkswebappsR2024alogswebapps_service_start.out
How do I troubleshoot this? I am using MATLAB Web App Server (product version). When I attempt to start my server using webapps-start or webapps-restart, I receive the following error:
MATLAB Web App Server service failed to start.
Check the logs files for more information:
C:ProgramDataMathWorkswebappsR2024alogswebapps_<timestamp>.log
C:ProgramDataMathWorkswebappsR2024alogswebapps_service_start.err
C:ProgramDataMathWorkswebappsR2024alogswebapps_service_start.out
How do I troubleshoot this? webappserver, startup MATLAB Answers — New Questions
Creating variables based on conditions with other variables
Hello all,
I am quite new to azure devops and I am struggling with understanding why my approaches to do something in the pipelines doesn’t work.
Starting from a template, I have such a piece of code in it, to which I will pass variables:
steps:
– ${{ if gt(length(parameters.artifactoryUrl), 0) }}:
– bash: |
<doSomeWorkHere>
displayName: Do some work only if the URL is provided
Then in the pipeline everything starts from variables definition like so:
variables:
– name: isRelease
value: eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’)
– name: isSnapshot
value: eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’)
# set artifactory url to stable if release, to stage if snapshot or else to empty (no publish to artifactory)
– name: artifactoryUrl
${{ if and( and( eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’), ne(variables[‘Build.Reason’], ‘Schedule’)), not( and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’), ne(variables[‘Build.Reason’], ‘Schedule’)))) }}:
value: ‘someURL1’
${{ if and( not( and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’), ne(variables[‘Build.Reason’], ‘Schedule’)) ), and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’), ne(variables[‘Build.Reason’], ‘Schedule’)) ) }}:
value: ‘someURL2’
${{ if and( not( and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’), ne(variables[‘Build.Reason’], ‘Schedule’)) ), not ( and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’), ne(variables[‘Build.Reason’], ‘Schedule’)) ) ) }}:
value: ”
The value of artifactoryUrl is passed into the template mentioned above. This actually works. But it looks quite unreadable and there are some duplications. So I made my attemp to simplify it. Instead of checking the same thing as in the previous variables definitions, I tried to reuse those new variables in another conditional expressions like so:
variables:
– name: isRelease
value: eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’)
– name: isSnapshot
value: eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’)
# set artifactory url to stable if release, to stage if snapshot or else to empty (no publish to artifactory)
– name: artifactoryUrl
${{ if and(eq(variables[‘isRelease’], true), ne(variables[‘Build.Reason’], ‘Schedule’)) }}:
value: ‘someUrl1’
${{ if and(eq(variables[‘isSnapshot’], true), ne(variables[‘Build.Reason’], ‘Schedule’)) }}:
value: ‘someUrl2’
${{ if or(and(eq(variables[‘isRelease’], false), eq(variables[‘isSnapshot’], false)), eq(variables[‘Build.Reason’], ‘Schedule’)) }}:
value: ”
Why referring to the previously created variables doens’t work? I already tried to use in those conditions different types of variables (macro, compile-time, run-time) and nothing worked for me. What I am missing?
# Oh forgot to mention, we use older Azure Devops instance, so “else”, “elseif” is not recognized.
Hello all,I am quite new to azure devops and I am struggling with understanding why my approaches to do something in the pipelines doesn’t work.Starting from a template, I have such a piece of code in it, to which I will pass variables: steps:
– ${{ if gt(length(parameters.artifactoryUrl), 0) }}:
– bash: |
<doSomeWorkHere>
displayName: Do some work only if the URL is provided Then in the pipeline everything starts from variables definition like so: variables:
– name: isRelease
value: eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’)
– name: isSnapshot
value: eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’)
# set artifactory url to stable if release, to stage if snapshot or else to empty (no publish to artifactory)
– name: artifactoryUrl
${{ if and( and( eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’), ne(variables[‘Build.Reason’], ‘Schedule’)), not( and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’), ne(variables[‘Build.Reason’], ‘Schedule’)))) }}:
value: ‘someURL1’
${{ if and( not( and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’), ne(variables[‘Build.Reason’], ‘Schedule’)) ), and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’), ne(variables[‘Build.Reason’], ‘Schedule’)) ) }}:
value: ‘someURL2’
${{ if and( not( and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’), ne(variables[‘Build.Reason’], ‘Schedule’)) ), not ( and ( eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’), ne(variables[‘Build.Reason’], ‘Schedule’)) ) ) }}:
value: ” The value of artifactoryUrl is passed into the template mentioned above. This actually works. But it looks quite unreadable and there are some duplications. So I made my attemp to simplify it. Instead of checking the same thing as in the previous variables definitions, I tried to reuse those new variables in another conditional expressions like so: variables:
– name: isRelease
value: eq(variables[‘Build.SourceBranch’], ‘refs/heads/master’)
– name: isSnapshot
value: eq(variables[‘Build.SourceBranch’], ‘refs/heads/develop’)
# set artifactory url to stable if release, to stage if snapshot or else to empty (no publish to artifactory)
– name: artifactoryUrl
${{ if and(eq(variables[‘isRelease’], true), ne(variables[‘Build.Reason’], ‘Schedule’)) }}:
value: ‘someUrl1’
${{ if and(eq(variables[‘isSnapshot’], true), ne(variables[‘Build.Reason’], ‘Schedule’)) }}:
value: ‘someUrl2’
${{ if or(and(eq(variables[‘isRelease’], false), eq(variables[‘isSnapshot’], false)), eq(variables[‘Build.Reason’], ‘Schedule’)) }}:
value: ” Why referring to the previously created variables doens’t work? I already tried to use in those conditions different types of variables (macro, compile-time, run-time) and nothing worked for me. What I am missing? # Oh forgot to mention, we use older Azure Devops instance, so “else”, “elseif” is not recognized. Read More
Unable to invite external users to Microsoft Viva Goals
I need to share the dashboard with external users and have tried adding guest users to the Viva Goals OKRs, but they are unable to access the organization. Has anyone else encountered this issue, or can someone confirm if this feature is unavailable in Viva Goals?
I need to share the dashboard with external users and have tried adding guest users to the Viva Goals OKRs, but they are unable to access the organization. Has anyone else encountered this issue, or can someone confirm if this feature is unavailable in Viva Goals? Read More
Highlight an entire row based on data in one cell
Hello all,
I have searched and tried many of the solutions in the previous posts, but I am having difficulty with the rule. I’m attempting to highlight an entire row if a cell in the E column states “YES”.
I am running a MacBook with Excel Version 16.86 (24060916).
Hello all, I have searched and tried many of the solutions in the previous posts, but I am having difficulty with the rule. I’m attempting to highlight an entire row if a cell in the E column states “YES”. I am running a MacBook with Excel Version 16.86 (24060916). Read More
Gmail accounts trouble sending emails
Problem with Sending Emails in New Outlook (Version 1.2024.625.600)
I’ve set up two email accounts in my New Outlook:
1. A personal Gmail account
2. A Google Workspace email account
Issue:
Sometimes, emails from these accounts fail to send and remain in the draft folder. This happens inconsistently, with no clear pattern. The problem occurs with both accounts and affects emails with and without attachments.
Workaround:
When emails fail to send in Outlook, I can successfully send them by:
1. Logging into the respective Gmail account through a web browser
2. Opening the email from the draft folder
3. Sending it from there without any issues
I’m unable to identify why this problem occurs in Outlook but not in the web interface. Can you help me troubleshoot this issue?
Problem with Sending Emails in New Outlook (Version 1.2024.625.600)I’ve set up two email accounts in my New Outlook:1. A personal Gmail account2. A Google Workspace email accountIssue:Sometimes, emails from these accounts fail to send and remain in the draft folder. This happens inconsistently, with no clear pattern. The problem occurs with both accounts and affects emails with and without attachments.Workaround:When emails fail to send in Outlook, I can successfully send them by:1. Logging into the respective Gmail account through a web browser2. Opening the email from the draft folder3. Sending it from there without any issuesI’m unable to identify why this problem occurs in Outlook but not in the web interface. Can you help me troubleshoot this issue? Read More
﹡﹡Exᴘᴇʀᴛ Sᴜᴘᴘᴏʀᴛ ꜰᴏʀ Qᴜɪᴄᴋ-B00ᴋs Eʀʀᴏʀ 15222﹕ Cᴏɴᴛᴀᴄᴛ Us ꜰᴏʀ Assɪsᴛᴀɴᴄᴇ﹡﹡
Update Internet Explorer: Ensure that you have the latest version of Internet Explorer installed.Add Intuit URL to Trusted Sites: Go to Internet Explorer settings, add *.intuit.com and *.Qᴜɪᴄᴋ-B00ᴋs to the Trusted Sites.Check Digital Signature: Verify that the digital signature is enabled for the Intuit content.Update Qᴜɪᴄᴋ-B00ᴋs: Ensure that your Qᴜɪᴄᴋ-B00ᴋs software is up-to-date.Disable Antivirus/Firewall: Temporarily disable any antivirus or firewall that might be blocking the update.
For further assistance, contact Qᴜɪᴄᴋ-B00ᴋs Expert Support for personalized help.
Update Internet Explorer: Ensure that you have the latest version of Internet Explorer installed.Add Intuit URL to Trusted Sites: Go to Internet Explorer settings, add *.intuit.com and *.Qᴜɪᴄᴋ-B00ᴋs to the Trusted Sites.Check Digital Signature: Verify that the digital signature is enabled for the Intuit content.Update Qᴜɪᴄᴋ-B00ᴋs: Ensure that your Qᴜɪᴄᴋ-B00ᴋs software is up-to-date.Disable Antivirus/Firewall: Temporarily disable any antivirus or firewall that might be blocking the update.For further assistance, contact Qᴜɪᴄᴋ-B00ᴋs Expert Support for personalized help. Read More
Microsoft Security Recommendation issues and Impersonation
Within the numerous dashboards for Microsoft, we see impersonation protection as failed/not compliant, or not enabled in our environment. This is a 2-part question:
1. Does it work well? Why do we see impersonated emails in our environment despite having the users set up for it? We have seen 3 in the last week for our CEO even though he is on the list.
2. Despite having it on and our owned domains added, the environment still shows we don’t have it setup. Also, it gives us a limit of 350 users, are we supposed to check each person one by one? Why negatively impact security scores when you are only supposed to set this up for VIPs? Why not allow it to be on for all users?
EDIT: This is what it advises even though you are limited to 350 users. Ensure that all users have an assigned anti-phishing policy with ‘Enable domains to protect’, ‘Include domains I own’ and ‘Include custom domains’ options enabled, by either updating your existing policies or creating new ones.
Within the numerous dashboards for Microsoft, we see impersonation protection as failed/not compliant, or not enabled in our environment. This is a 2-part question: 1. Does it work well? Why do we see impersonated emails in our environment despite having the users set up for it? We have seen 3 in the last week for our CEO even though he is on the list. 2. Despite having it on and our owned domains added, the environment still shows we don’t have it setup. Also, it gives us a limit of 350 users, are we supposed to check each person one by one? Why negatively impact security scores when you are only supposed to set this up for VIPs? Why not allow it to be on for all users? EDIT: This is what it advises even though you are limited to 350 users. Ensure that all users have an assigned anti-phishing policy with ‘Enable domains to protect’, ‘Include domains I own’ and ‘Include custom domains’ options enabled, by either updating your existing policies or creating new ones. Read More
transforme.tech – doações online, gestão e indicadores sociais para ONG/OSC
A transforme.tech é a parceira ideal para ONG/OSC, fundações, associações, agências missionárias e organizações comprometidas com a transformação socioambiental!
Por meio de uma plataforma online nós simplificamos e automatizamos processos financeiros, viabilizamos o recebimento de doações online, possibilitamos a geração de indicadores de desenvolvimento social e aprimoramos a transparência entre doadores/associados.
Além disso, por meio da plataforma sua organização consegue fazer a gestão de inscrições em cursos e eventos com total facilidade e muito mais. Tudo, em um só lugar!
Saiba mais: https://transforme.tech/
A transforme.tech é a parceira ideal para ONG/OSC, fundações, associações, agências missionárias e organizações comprometidas com a transformação socioambiental! Por meio de uma plataforma online nós simplificamos e automatizamos processos financeiros, viabilizamos o recebimento de doações online, possibilitamos a geração de indicadores de desenvolvimento social e aprimoramos a transparência entre doadores/associados.Além disso, por meio da plataforma sua organização consegue fazer a gestão de inscrições em cursos e eventos com total facilidade e muito mais. Tudo, em um só lugar! Saiba mais: https://transforme.tech/ Read More
Streamlining SAP Processes with Azure OpenAI, Copilot Studio, and Power Platform
In today’s fast-paced business environment, intelligent business processes and efficient collaboration are key to the success of organizations. A recent study by Microsoft on AI has shown that 71% of organizations are already using AI to add value to and speed up their business processes, the report also states that for every $1 invested organizations are seeing a return of 3.5X their investments.
SAP systems have data related to business processes while the Microsoft Graph has data related to collaboration such as emails, chats, schedules etc. To use both these forms of data together with AI would transform the business processes of many organizations.
As every organization is different, apart from using out-of-the-box solutions, organizations are looking for the convenience of being able to build their own customs solutions when they need it and as they want it. Microsoft offers powerful AI and low code development tools that are easily connected to SAP systems that enable individuals and organizations to develop their own intelligent copilots and bots to enhance their business processes and workflows.
From a Microsoft perspective we are working on helping customers and partners leverage SAP with AI in three buckets:
Working with SAP to provide a fantastic out of the box experience to customers and partners. The SAP Joule & Microsoft Copilot announcement at Sapphire (Joule to Integrate with Microsoft Copilot | SAP Sapphire | SAP News Center) and also the SAP S/4HANA Public Cloud & Microsoft Copilot integration are the first tangible results of our collaboration.
Our functional Copilots (Copilot for Sales, Copilot for Finance, Copilot for Services, …) provide a similar out of the box experience but focusing on M365 applications. Copilot for Finance for example, accelerates time-to-impact for finance professionals by surfacing insights that support strategic decision-making and reduce the time that’s spent on manual, repetitive work. It comes with an out of the box integration in Outlook and Excel and allows customers and partners to extend the integration to other systems using a custom connector.
Since out of the box solutions from SAP and Microsoft will never address all customer requirements, Copilot Studio offers powerful AI and low code development tools that are easily connected to SAP systems to develop your own intelligent copilots and bots to enhance your business processes and workflows.
To demonstrate how seamless and easy it is to utilize AI using Microsoft AI tools, we will explore a scenario that demonstrates how SAP data, along with Copilot Studio, Azure OpenAI, Microsoft Teams, and the Microsoft Power Platform can be leveraged to streamline a business process.
The Scenario description and demonstration:
1) Customer Inquiry and Complaint.
A customer reaches out to the salesperson with a complaint regarding a delayed order.
2) Order Investigation,
The salesperson investigates the customer’s orders via a chatbot deployed on Teams, delving deep into the delayed order with AI-summarized insights with context from Outlook emails, Teams’ messages and data directly from the SAP system.
3) Generated Report.
The salesperson figures out the issue, has AI generate a report summarizing the conversation and the cause of the delay. The report is then sent via email to the customer through chat with the bot on Teams.
Here is a video demonstration of the scenario:
In this way, the salesperson has utilized AI to understand and summarize various order-related data from different sources (SAP and Microsoft Graph), convert data from one format to another, and has progressed from identifying the root cause of a problem to updating the customer via email, all through a Teams chat.
The scenario as observed above, unfolds in several steps (as shown in the video), each highlighting different Microsoft technologies working in harmony to resolve the issue as shown in the image below:
Azure OpenAI provides the foundation for developing and training the bot that provides access to the AI models that generate responses. The Power Platform, particularly Power Automate, integrates various services, including SAP systems and the M365 Graph enabling data flow and automation. The SAP ERP connector ensures real-time data retrieval and updates from SAP systems, enhancing the bot’s ability to interact with enterprise data. Finally, Copilot Studio allows for the customization and deployment of AI copilots, making the bot adaptable to specific business needs, in this case, deploying it on Teams.
Explore how to build this scenario on this GitHub link which has detailed step by step instructions on how to build it from scratch. The link also contains the exported Power Platform flows that one can import into their own environment to refer to and use.
Here is a brief description of the different technical components used in the diagram and how to learn more about them and how to set them up:
1. Set up a bot on Azure AI Studio: Azure AI Studio allows you to create and test bots using the Chat Playground. You can get access to Azure AI Studio here.
2. Set up Microsoft Power Platform: By creating a Microsoft 365 developer account, you gain access to the Power Platform, which includes Power Automate among others. Create a M365 Developer account and get access to the Power Platform here.
3. Set up SAP connection in Power Automate: To connect Power Automate flows to your SAP system and make use of the SAP ERP connector you must establish a connection between the Power Platform and your SAP system. Read more about the connector here.
4. Set up / Sign up for Copilot Studio: Copilot Studio enables you to create and customize AI copilots. You can build and deploy copilots that leverage generative AI, enhancing the capabilities of your bot. You can learn more about it and get access to it here.
This scenario is just one example of how these technologies can transform and make business processes more efficient by harnessing the power of AI and Automation. With the Microsoft tools mentioned above and their easy connectivity to SAP systems and the Microsoft Graph, you have all the tools in your arsenal to make a task/business process AI powered. The next blog will explore how to enhance this scenario with components that make the data more visually appealing using Adaptive Cards and also explore how to integrate authorization into the solution.
Microsoft Tech Community – Latest Blogs –Read More
Readjust a camera data set
I have a data set of size 2000*300*20. It is a data from a camera with 2000 pixel.
I want to extract out the last data set in the x and y cordinates i.e. at 300 and 20.
Afterwards, I want to use it to replace all the data points of all other x and y components.
I have made some attempts but with no success, I will attached my code for any for useful comments. Thanks
m=size(A.Volume); % A data of size; 2000*300*20
new_A.Volume=A.Volume;
for i = 1:m(2);
for j = 1:m(3);
new_A.Volume(i, j)=A.Volume(:,m(2),m(3));
end
endI have a data set of size 2000*300*20. It is a data from a camera with 2000 pixel.
I want to extract out the last data set in the x and y cordinates i.e. at 300 and 20.
Afterwards, I want to use it to replace all the data points of all other x and y components.
I have made some attempts but with no success, I will attached my code for any for useful comments. Thanks
m=size(A.Volume); % A data of size; 2000*300*20
new_A.Volume=A.Volume;
for i = 1:m(2);
for j = 1:m(3);
new_A.Volume(i, j)=A.Volume(:,m(2),m(3));
end
end I have a data set of size 2000*300*20. It is a data from a camera with 2000 pixel.
I want to extract out the last data set in the x and y cordinates i.e. at 300 and 20.
Afterwards, I want to use it to replace all the data points of all other x and y components.
I have made some attempts but with no success, I will attached my code for any for useful comments. Thanks
m=size(A.Volume); % A data of size; 2000*300*20
new_A.Volume=A.Volume;
for i = 1:m(2);
for j = 1:m(3);
new_A.Volume(i, j)=A.Volume(:,m(2),m(3));
end
end readjust a camera data set MATLAB Answers — New Questions
Building C Code of Simulink Model with UDP Send/Receive
Hi all,
I am about to build Simulink models utilizing the "UDP Send" or "UDP Receive" blocks from the DSP System Toolbox.
I am not building an executable (*.exe) from the Simulink Model directly. The source and header files generated in the "…grt_rtw" are referenced in further code that comes from our inhouse software toolchain…
The overall building toolchain works for many other models / applications. Only now, as i am playing around with the UDP blocks I am receiving a linker error (LNK2019 unresolved external symbol) when building the code in Visual Studio.
Is it even possible to use the "UDP Send" and "UDP Receive" blocks for code generation other than building an *.exe?
I have referenced the DAHhostLib_network.h and *.rtw.h as well as the *.c files.
I understand, that the networkdevice.dll is cruicial for this to be working. According to one of our IT guys, I am in need of a *.lib file to link to that *.dll? But we couldn’t find any.
Thank you for any help! Would be great to get this running somehow 🙂
Best,
RaphaelHi all,
I am about to build Simulink models utilizing the "UDP Send" or "UDP Receive" blocks from the DSP System Toolbox.
I am not building an executable (*.exe) from the Simulink Model directly. The source and header files generated in the "…grt_rtw" are referenced in further code that comes from our inhouse software toolchain…
The overall building toolchain works for many other models / applications. Only now, as i am playing around with the UDP blocks I am receiving a linker error (LNK2019 unresolved external symbol) when building the code in Visual Studio.
Is it even possible to use the "UDP Send" and "UDP Receive" blocks for code generation other than building an *.exe?
I have referenced the DAHhostLib_network.h and *.rtw.h as well as the *.c files.
I understand, that the networkdevice.dll is cruicial for this to be working. According to one of our IT guys, I am in need of a *.lib file to link to that *.dll? But we couldn’t find any.
Thank you for any help! Would be great to get this running somehow 🙂
Best,
Raphael Hi all,
I am about to build Simulink models utilizing the "UDP Send" or "UDP Receive" blocks from the DSP System Toolbox.
I am not building an executable (*.exe) from the Simulink Model directly. The source and header files generated in the "…grt_rtw" are referenced in further code that comes from our inhouse software toolchain…
The overall building toolchain works for many other models / applications. Only now, as i am playing around with the UDP blocks I am receiving a linker error (LNK2019 unresolved external symbol) when building the code in Visual Studio.
Is it even possible to use the "UDP Send" and "UDP Receive" blocks for code generation other than building an *.exe?
I have referenced the DAHhostLib_network.h and *.rtw.h as well as the *.c files.
I understand, that the networkdevice.dll is cruicial for this to be working. According to one of our IT guys, I am in need of a *.lib file to link to that *.dll? But we couldn’t find any.
Thank you for any help! Would be great to get this running somehow 🙂
Best,
Raphael udp, networkdevice.dll MATLAB Answers — New Questions
Windows Server 2022 Essential Activation
Hi,
I’m writing for the company in which I work.
The company, 1 year ago, bought a little server and the reseller gave us it with Windows Server 2022 Essential installed. The PK was put on the side of the server and gave us also a DVD.
After a year, the server was giving some issues, so I’ve decided to buy a new HD to install it again.
I’ve tried to put the DVD of Windows Server 2022 Essential into pc but I’ve just discovered it is in Deutch and I cannot speak in that language so for me is impossible to install it.
Since I was not able to find any iso of this OS in microsoft website I’ve downloaded the 2022 standard evaluation.
After installation I’ve tried to put into the activation tool the PK we have for this computer but system says this PK is not valid.
Pls can anyone help me to understand how can I install again the 2022 essential with our PK?
Thank you
Hi,I’m writing for the company in which I work.The company, 1 year ago, bought a little server and the reseller gave us it with Windows Server 2022 Essential installed. The PK was put on the side of the server and gave us also a DVD.After a year, the server was giving some issues, so I’ve decided to buy a new HD to install it again.I’ve tried to put the DVD of Windows Server 2022 Essential into pc but I’ve just discovered it is in Deutch and I cannot speak in that language so for me is impossible to install it.Since I was not able to find any iso of this OS in microsoft website I’ve downloaded the 2022 standard evaluation.After installation I’ve tried to put into the activation tool the PK we have for this computer but system says this PK is not valid.Pls can anyone help me to understand how can I install again the 2022 essential with our PK?Thank you Read More
SUM If with multiple Not equal to criteria.
I am having trouble with the formula below. The first part works perfectly. It is when I get to the is not equal to part that the formula does not work.
=sumif(‘APXBalances’!E:E,’APXBalances’!B:B=24,’APXBalances’!A:A”0735″)-SUMIFS(‘APXBalances’!C:C,”<>”,’APXBalances’!C:C,”<>00000″,’APXBalances’!C:C”<>05757″)
Here is an example of my data
FundAYAPPNRemaining Cash Balance BudgetAppropriation Cash AvailableAppropriation Accrued Cash Available073522 052623.4252623.4207352200000014899.9814899.980735220575500007352205862037723.4437723.4407352213001000
I am having trouble with the formula below. The first part works perfectly. It is when I get to the is not equal to part that the formula does not work. =sumif(‘APXBalances’!E:E,’APXBalances’!B:B=24,’APXBalances’!A:A”0735″)-SUMIFS(‘APXBalances’!C:C,”<>”,’APXBalances’!C:C,”<>00000″,’APXBalances’!C:C”<>05757″) Here is an example of my data FundAYAPPNRemaining Cash Balance BudgetAppropriation Cash AvailableAppropriation Accrued Cash Available073522 052623.4252623.4207352200000014899.9814899.980735220575500007352205862037723.4437723.4407352213001000 Read More
Custom Sort Excel Online
Hi I have an Online Excel Sheet (used in Safari). I have custom sort with three layers, it works. But it does not update automatically if I add more data, I need to reopen the sort menue (see picture) and reapply it. Is there any way to automate this?
Thanks for the help!
Hi I have an Online Excel Sheet (used in Safari). I have custom sort with three layers, it works. But it does not update automatically if I add more data, I need to reopen the sort menue (see picture) and reapply it. Is there any way to automate this? Thanks for the help! Read More
The Impact of Copilot on Excel Users and Analysts
Microsoft Copilot for Excel is poised to revolutionize the way users interact with data. By automating routine tasks like data cleaning, formatting, and formula creation, Copilot frees up valuable time for analysts to focus on strategic thinking, complex problem-solving, and deriving deeper insights. However, it’s essential to recognize that Copilot is a tool to augment human capabilities, not replace them. Successful integration of Copilot into workflows requires a balance of human expertise and AI-driven automation.
Microsoft Copilot for Excel is poised to revolutionize the way users interact with data. By automating routine tasks like data cleaning, formatting, and formula creation, Copilot frees up valuable time for analysts to focus on strategic thinking, complex problem-solving, and deriving deeper insights. However, it’s essential to recognize that Copilot is a tool to augment human capabilities, not replace them. Successful integration of Copilot into workflows requires a balance of human expertise and AI-driven automation. Read More
Quick- B00ks Remote Hosting: Benefits and Recommendations?
Hi everyone,
I’m considering using remote hosting for Quick- B00ks to streamline our business processes and improve accessibility for our team. What are the key benefits of using Quick- B00ks remote hosting? Are there any particular providers or setups you would recommend based on your experience? Any potential downsides or issues I should be aware of? Appreciate any insights or tips from those who have used it!
Thanks!
Hi everyone,I’m considering using remote hosting for Quick- B00ks to streamline our business processes and improve accessibility for our team. What are the key benefits of using Quick- B00ks remote hosting? Are there any particular providers or setups you would recommend based on your experience? Any potential downsides or issues I should be aware of? Appreciate any insights or tips from those who have used it!Thanks! Read More
Microsoft partner seeking to develop chatbots using Microsoft Copilot Studio for nonprofits
I am a Microsoft partner seeking to develop chatbots using Microsoft Copilot Studio for nonprofits and the education industry. Who can I contact at Microsoft to get started?
I am a Microsoft partner seeking to develop chatbots using Microsoft Copilot Studio for nonprofits and the education industry. Who can I contact at Microsoft to get started? Read More
data filter and pivot table manipulate data
Given
A list of 12 street names in different notations (column ORIGNALSCHREIBWEISE)
Problem I – Filter
Adding a filter and opening the dropdown list shows a reduced number (9 of 12) of ORIGNALSCHREIBWEISE-entries with standardised notations:
Problem II – pivot table
Creating a pivot table from the list the result is the same as in the filter drop down list: the number of notations is reduce to 9:
Error Interpretation
In both test cases Excel doesn’t work case sensitiv. It interprets
Sankt-Martin-str. / Sankt-Martin-Str.St.-martin-Str. / St.-Martin-Str.St.-Martin-straße / St.-Martin-Straße
as identical strings.
Question
How can I force Excel to work in both cases case sensitive?
GivenA list of 12 street names in different notations (column ORIGNALSCHREIBWEISE) Problem I – FilterAdding a filter and opening the dropdown list shows a reduced number (9 of 12) of ORIGNALSCHREIBWEISE-entries with standardised notations: Problem II – pivot tableCreating a pivot table from the list the result is the same as in the filter drop down list: the number of notations is reduce to 9: Error InterpretationIn both test cases Excel doesn’t work case sensitiv. It interpretsSankt-Martin-str. / Sankt-Martin-Str.St.-martin-Str. / St.-Martin-Str.St.-Martin-straße / St.-Martin-Straßeas identical strings.QuestionHow can I force Excel to work in both cases case sensitive? Read More