Month: June 2024
MATLAB R2024a Silent Installation Issue – Unable to Load Product Files
I am facing a problem while attempting to install MATLAB R2024a on my Linux server (Ubuntu 22.04.4 LTS) using the silent installation method. Despite following the provided instructions and specifying the necessary parameters in the installer_input.txt file, the installation process fails with an error indicating that the installer is unable to load the product files.
Setup Details:
– Server Operating System: Ubuntu 22.04.4 LTS
– MATLAB Version: R2024a
– Installation Method: Silent installation using installer_input.txt file
– Path to the installer file: ~/matlab_R2024a_Linux
The error message I receive during the installation process is as follows:
“`
(May 23, 2024 23:54:26) Unable to load product files. Product files must be in the same folder as the input file. For help getting the product files, see the installation documentation on <a HREF="https://www.mathworks.com/pi_noprode_mpi_R2024a_glnxa64">MATLAB Answer</a>.
“`
I have confirmed that the MATLAB product files (contents of the "archives" directory) are located in the same directory as the installer_input.txt file. I have also verified that the installer_input.txt file does not contain any explicit line specifying the product files folder, as the installer assumes the product files are in the same directory by default.
The installation command I am using is:
“`
./install -mode silent -inputFile installer_input.txt -logFile installation_log.txt
“`
I have reviewed the installation_log.txt file, but it does not provide any additional information beyond the error message mentioned above.
To assist you in investigating this issue further, please find the following information:
– Path to the directory containing the installer_input.txt file: ~/matlab_R2024a_Linux
– List of files and directories present in the same directory as the installer_input.txt file:
“`
drwxrwxr-x 8 yugao yugao 4096 May 24 00:15 ./
drwxr-x— 33 yugao yugao 12288 May 24 00:53 ../
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 archives/
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 bin/
drwxrwxr-x 3 yugao yugao 4096 May 24 00:15 cefclient/
-r-xr-xr-x 1 yugao yugao 11147 Nov 19 2023 install*
-rw-r–r– 1 yugao yugao 9313 May 24 00:17 installer_input.txt
-r–r–r– 1 yugao yugao 83813 Jan 23 01:57 license_agreement.txt
-r–r–r– 1 yugao yugao 777345 Apr 21 11:07 mathworks_installation_help_de.pdf
-r–r–r– 1 yugao yugao 765184 Apr 20 11:01 mathworks_installation_help_es.pdf
-r–r–r– 1 yugao yugao 779814 Apr 21 10:52 mathworks_installation_help_fr.pdf
-r–r–r– 1 yugao yugao 772296 Apr 21 10:35 mathworks_installation_help_it.pdf
-r–r–r– 1 yugao yugao 652022 Apr 20 10:53 mathworks_installation_help_ja_JP.pdf
-r–r–r– 1 yugao yugao 769398 Apr 20 10:53 mathworks_installation_help_ko_KR.pdf
-r–r–r– 1 yugao yugao 760789 Apr 20 10:54 mathworks_installation_help.pdf
-r–r–r– 1 yugao yugao 874129 Apr 20 10:53 mathworks_installation_help_zh_CN.pdf
-r–r–r– 1 yugao yugao 9021 Nov 19 2023 readme.txt
drwxrwxr-x 12 yugao yugao 4096 May 24 00:15 resources/
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 sys/
drwxrwxr-x 3 yugao yugao 4096 May 24 00:15 ui/
-r–r–r– 1 yugao yugao 310 May 2 12:28 VersionInfo.xml
“`
I would greatly appreciate your guidance in resolving this silent installation issue and successfully installing MATLAB R2024a on my Ubuntu server. If you require any additional information or have specific troubleshooting steps you would like me to follow, please let me know.
Thank you for your attention to this matter and your assistance.I am facing a problem while attempting to install MATLAB R2024a on my Linux server (Ubuntu 22.04.4 LTS) using the silent installation method. Despite following the provided instructions and specifying the necessary parameters in the installer_input.txt file, the installation process fails with an error indicating that the installer is unable to load the product files.
Setup Details:
– Server Operating System: Ubuntu 22.04.4 LTS
– MATLAB Version: R2024a
– Installation Method: Silent installation using installer_input.txt file
– Path to the installer file: ~/matlab_R2024a_Linux
The error message I receive during the installation process is as follows:
“`
(May 23, 2024 23:54:26) Unable to load product files. Product files must be in the same folder as the input file. For help getting the product files, see the installation documentation on <a HREF="https://www.mathworks.com/pi_noprode_mpi_R2024a_glnxa64">MATLAB Answer</a>.
“`
I have confirmed that the MATLAB product files (contents of the "archives" directory) are located in the same directory as the installer_input.txt file. I have also verified that the installer_input.txt file does not contain any explicit line specifying the product files folder, as the installer assumes the product files are in the same directory by default.
The installation command I am using is:
“`
./install -mode silent -inputFile installer_input.txt -logFile installation_log.txt
“`
I have reviewed the installation_log.txt file, but it does not provide any additional information beyond the error message mentioned above.
To assist you in investigating this issue further, please find the following information:
– Path to the directory containing the installer_input.txt file: ~/matlab_R2024a_Linux
– List of files and directories present in the same directory as the installer_input.txt file:
“`
drwxrwxr-x 8 yugao yugao 4096 May 24 00:15 ./
drwxr-x— 33 yugao yugao 12288 May 24 00:53 ../
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 archives/
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 bin/
drwxrwxr-x 3 yugao yugao 4096 May 24 00:15 cefclient/
-r-xr-xr-x 1 yugao yugao 11147 Nov 19 2023 install*
-rw-r–r– 1 yugao yugao 9313 May 24 00:17 installer_input.txt
-r–r–r– 1 yugao yugao 83813 Jan 23 01:57 license_agreement.txt
-r–r–r– 1 yugao yugao 777345 Apr 21 11:07 mathworks_installation_help_de.pdf
-r–r–r– 1 yugao yugao 765184 Apr 20 11:01 mathworks_installation_help_es.pdf
-r–r–r– 1 yugao yugao 779814 Apr 21 10:52 mathworks_installation_help_fr.pdf
-r–r–r– 1 yugao yugao 772296 Apr 21 10:35 mathworks_installation_help_it.pdf
-r–r–r– 1 yugao yugao 652022 Apr 20 10:53 mathworks_installation_help_ja_JP.pdf
-r–r–r– 1 yugao yugao 769398 Apr 20 10:53 mathworks_installation_help_ko_KR.pdf
-r–r–r– 1 yugao yugao 760789 Apr 20 10:54 mathworks_installation_help.pdf
-r–r–r– 1 yugao yugao 874129 Apr 20 10:53 mathworks_installation_help_zh_CN.pdf
-r–r–r– 1 yugao yugao 9021 Nov 19 2023 readme.txt
drwxrwxr-x 12 yugao yugao 4096 May 24 00:15 resources/
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 sys/
drwxrwxr-x 3 yugao yugao 4096 May 24 00:15 ui/
-r–r–r– 1 yugao yugao 310 May 2 12:28 VersionInfo.xml
“`
I would greatly appreciate your guidance in resolving this silent installation issue and successfully installing MATLAB R2024a on my Ubuntu server. If you require any additional information or have specific troubleshooting steps you would like me to follow, please let me know.
Thank you for your attention to this matter and your assistance. I am facing a problem while attempting to install MATLAB R2024a on my Linux server (Ubuntu 22.04.4 LTS) using the silent installation method. Despite following the provided instructions and specifying the necessary parameters in the installer_input.txt file, the installation process fails with an error indicating that the installer is unable to load the product files.
Setup Details:
– Server Operating System: Ubuntu 22.04.4 LTS
– MATLAB Version: R2024a
– Installation Method: Silent installation using installer_input.txt file
– Path to the installer file: ~/matlab_R2024a_Linux
The error message I receive during the installation process is as follows:
“`
(May 23, 2024 23:54:26) Unable to load product files. Product files must be in the same folder as the input file. For help getting the product files, see the installation documentation on <a HREF="https://www.mathworks.com/pi_noprode_mpi_R2024a_glnxa64">MATLAB Answer</a>.
“`
I have confirmed that the MATLAB product files (contents of the "archives" directory) are located in the same directory as the installer_input.txt file. I have also verified that the installer_input.txt file does not contain any explicit line specifying the product files folder, as the installer assumes the product files are in the same directory by default.
The installation command I am using is:
“`
./install -mode silent -inputFile installer_input.txt -logFile installation_log.txt
“`
I have reviewed the installation_log.txt file, but it does not provide any additional information beyond the error message mentioned above.
To assist you in investigating this issue further, please find the following information:
– Path to the directory containing the installer_input.txt file: ~/matlab_R2024a_Linux
– List of files and directories present in the same directory as the installer_input.txt file:
“`
drwxrwxr-x 8 yugao yugao 4096 May 24 00:15 ./
drwxr-x— 33 yugao yugao 12288 May 24 00:53 ../
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 archives/
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 bin/
drwxrwxr-x 3 yugao yugao 4096 May 24 00:15 cefclient/
-r-xr-xr-x 1 yugao yugao 11147 Nov 19 2023 install*
-rw-r–r– 1 yugao yugao 9313 May 24 00:17 installer_input.txt
-r–r–r– 1 yugao yugao 83813 Jan 23 01:57 license_agreement.txt
-r–r–r– 1 yugao yugao 777345 Apr 21 11:07 mathworks_installation_help_de.pdf
-r–r–r– 1 yugao yugao 765184 Apr 20 11:01 mathworks_installation_help_es.pdf
-r–r–r– 1 yugao yugao 779814 Apr 21 10:52 mathworks_installation_help_fr.pdf
-r–r–r– 1 yugao yugao 772296 Apr 21 10:35 mathworks_installation_help_it.pdf
-r–r–r– 1 yugao yugao 652022 Apr 20 10:53 mathworks_installation_help_ja_JP.pdf
-r–r–r– 1 yugao yugao 769398 Apr 20 10:53 mathworks_installation_help_ko_KR.pdf
-r–r–r– 1 yugao yugao 760789 Apr 20 10:54 mathworks_installation_help.pdf
-r–r–r– 1 yugao yugao 874129 Apr 20 10:53 mathworks_installation_help_zh_CN.pdf
-r–r–r– 1 yugao yugao 9021 Nov 19 2023 readme.txt
drwxrwxr-x 12 yugao yugao 4096 May 24 00:15 resources/
drwxrwxr-x 4 yugao yugao 4096 May 24 00:15 sys/
drwxrwxr-x 3 yugao yugao 4096 May 24 00:15 ui/
-r–r–r– 1 yugao yugao 310 May 2 12:28 VersionInfo.xml
“`
I would greatly appreciate your guidance in resolving this silent installation issue and successfully installing MATLAB R2024a on my Ubuntu server. If you require any additional information or have specific troubleshooting steps you would like me to follow, please let me know.
Thank you for your attention to this matter and your assistance. installation MATLAB Answers — New Questions
Error using loadlibrary Building okFrontPanel_thunk_pcwin64 failed. Compiler output is: cl -I”D:QuanProgram FilesMATLABR2023bexterninclude” /Zc:__cplusplus /Zp8 /W3 /
Error using loadlibrary
Building okFrontPanel_thunk_pcwin64 failed. Compiler output is:
cl -I"D:QuanProgram FilesMATLABR2023bexterninclude" /Zc:__cplusplus /Zp8 /W3 /nologo -I"C:UsersQuanDesktop256X256matlab"
-I"C:UsersQuanDesktop256X256matlabOpal Kelly" "okFrontPanel_thunk_pcwin64.c" -LD -Fe"okFrontPanel_thunk_pcwin64.dll"
okFrontPanel_thunk_pcwin64.c
LINK : fatal error LNK1104: cannot open file ‘okFrontPanel.lib’Error using loadlibrary
Building okFrontPanel_thunk_pcwin64 failed. Compiler output is:
cl -I"D:QuanProgram FilesMATLABR2023bexterninclude" /Zc:__cplusplus /Zp8 /W3 /nologo -I"C:UsersQuanDesktop256X256matlab"
-I"C:UsersQuanDesktop256X256matlabOpal Kelly" "okFrontPanel_thunk_pcwin64.c" -LD -Fe"okFrontPanel_thunk_pcwin64.dll"
okFrontPanel_thunk_pcwin64.c
LINK : fatal error LNK1104: cannot open file ‘okFrontPanel.lib’ Error using loadlibrary
Building okFrontPanel_thunk_pcwin64 failed. Compiler output is:
cl -I"D:QuanProgram FilesMATLABR2023bexterninclude" /Zc:__cplusplus /Zp8 /W3 /nologo -I"C:UsersQuanDesktop256X256matlab"
-I"C:UsersQuanDesktop256X256matlabOpal Kelly" "okFrontPanel_thunk_pcwin64.c" -LD -Fe"okFrontPanel_thunk_pcwin64.dll"
okFrontPanel_thunk_pcwin64.c
LINK : fatal error LNK1104: cannot open file ‘okFrontPanel.lib’ link : fatal error lnk1104: cannot open file ‘okfr MATLAB Answers — New Questions
I would like to quantize a Sinewave correctly, and identify where the issues is with my code
Hi,
With the code below, I am trying to Quantize the Sinewave by varying the quantity of bits from 16-bits down via Bit Shifting, and then play a sound.
The waveform is normalised, however I am not replicating the waveform correctly and I just cannot seem to find where my error is.
I have attached some .jpg files at nBits = 1, 8 and 15.
Any help or guidance would be very appreciated.
% Sampling Frequency
fs = 8000;
% Sample Period
Ps = 1/fs;
% Sample Time from zero to two seconds in 125us steps (Ps)
t = 0:Ps:2;
% Waveform Frequency
waveFreq = 2;
% Sinewave signal
waveSignal = sin(2*pi*waveFreq*t);
waveInt = int16(waveSignal*2^15);
% Quantize waveform via truncation. (Reduce the least significant bit – LSB)
nBits = 1;
quantWave = bitshift(waveInt,nBits);
% Cast waveform back into a double data type
quantWaveDub = double(quantWave)/2^(16-nBits);
% Normalise the waveform due to bit change
quantWaveDub = quantWaveDub/max(abs(quantWaveDub));
% Plot Sinewave signal
figure(1);
plot(t,waveSignal);
ylim([-1.5 1.5]);
sound(waveSignal,fs);
pause(1);
% Plot Quantized signal
figure(2);
plot(t,quantWaveDub);
ylim([-1.5 1.5]);
sound(quantWaveDub,fs);Hi,
With the code below, I am trying to Quantize the Sinewave by varying the quantity of bits from 16-bits down via Bit Shifting, and then play a sound.
The waveform is normalised, however I am not replicating the waveform correctly and I just cannot seem to find where my error is.
I have attached some .jpg files at nBits = 1, 8 and 15.
Any help or guidance would be very appreciated.
% Sampling Frequency
fs = 8000;
% Sample Period
Ps = 1/fs;
% Sample Time from zero to two seconds in 125us steps (Ps)
t = 0:Ps:2;
% Waveform Frequency
waveFreq = 2;
% Sinewave signal
waveSignal = sin(2*pi*waveFreq*t);
waveInt = int16(waveSignal*2^15);
% Quantize waveform via truncation. (Reduce the least significant bit – LSB)
nBits = 1;
quantWave = bitshift(waveInt,nBits);
% Cast waveform back into a double data type
quantWaveDub = double(quantWave)/2^(16-nBits);
% Normalise the waveform due to bit change
quantWaveDub = quantWaveDub/max(abs(quantWaveDub));
% Plot Sinewave signal
figure(1);
plot(t,waveSignal);
ylim([-1.5 1.5]);
sound(waveSignal,fs);
pause(1);
% Plot Quantized signal
figure(2);
plot(t,quantWaveDub);
ylim([-1.5 1.5]);
sound(quantWaveDub,fs); Hi,
With the code below, I am trying to Quantize the Sinewave by varying the quantity of bits from 16-bits down via Bit Shifting, and then play a sound.
The waveform is normalised, however I am not replicating the waveform correctly and I just cannot seem to find where my error is.
I have attached some .jpg files at nBits = 1, 8 and 15.
Any help or guidance would be very appreciated.
% Sampling Frequency
fs = 8000;
% Sample Period
Ps = 1/fs;
% Sample Time from zero to two seconds in 125us steps (Ps)
t = 0:Ps:2;
% Waveform Frequency
waveFreq = 2;
% Sinewave signal
waveSignal = sin(2*pi*waveFreq*t);
waveInt = int16(waveSignal*2^15);
% Quantize waveform via truncation. (Reduce the least significant bit – LSB)
nBits = 1;
quantWave = bitshift(waveInt,nBits);
% Cast waveform back into a double data type
quantWaveDub = double(quantWave)/2^(16-nBits);
% Normalise the waveform due to bit change
quantWaveDub = quantWaveDub/max(abs(quantWaveDub));
% Plot Sinewave signal
figure(1);
plot(t,waveSignal);
ylim([-1.5 1.5]);
sound(waveSignal,fs);
pause(1);
% Plot Quantized signal
figure(2);
plot(t,quantWaveDub);
ylim([-1.5 1.5]);
sound(quantWaveDub,fs); bitshift, quantization, waveform MATLAB Answers — New Questions
Need help with Powershell
I have created One Folder in each user’s OneDrive named as K drive, and migrated data in that folder.
I need the size of that folder from each user’s OneDrive through PowerShell.
I have created One Folder in each user’s OneDrive named as K drive, and migrated data in that folder.I need the size of that folder from each user’s OneDrive through PowerShell.@powershelll Read More
I’m looking for Excel Formula to pull Average Weekly Sales before and after an event.
I’m looking for a excel formula that will provide average sales before and after a date when a facility was closed. In column A I have the facility location #, and in the row going across I have weekly sales data from 2022 to 2024: During the time of 1/10/2023 to 2/10/2023 the facility was down, and the formula I’m trying to write would provide the Average weekly sales for 5 wks prior to the facility closing on 1/10/2023, then the average weekly sales 4 weeks after the facility re-opened on 2/10/23.
I’m looking for a excel formula that will provide average sales before and after a date when a facility was closed. In column A I have the facility location #, and in the row going across I have weekly sales data from 2022 to 2024: During the time of 1/10/2023 to 2/10/2023 the facility was down, and the formula I’m trying to write would provide the Average weekly sales for 5 wks prior to the facility closing on 1/10/2023, then the average weekly sales 4 weeks after the facility re-opened on 2/10/23. Read More
Get a report of retrieved Cloud Policies
Cloud policies are the alternative to the classic Group Policies that have been around since Windows 2000. They can be used to configure different policy settings for Microsoft 365 apps, they don’t require an AD infrastructure and use Entra ID instead. In this post, I analyze the registry key information and how we can extract a report like the gpresult tool does for GPs
Full Article https://andresgorzelany.blog/2024/06/21/get-a-report-of-retrieved-cloud-policies/
Cloud policies are the alternative to the classic Group Policies that have been around since Windows 2000. They can be used to configure different policy settings for Microsoft 365 apps, they don’t require an AD infrastructure and use Entra ID instead. In this post, I analyze the registry key information and how we can extract a report like the gpresult tool does for GPs
Full Article https://andresgorzelany.blog/2024/06/21/get-a-report-of-retrieved-cloud-policies/
Read More
KeyTips now available in Office for Mac
Microsoft 365 Insiders,
Happy Friday! Great news for Office for Mac users! KeyTip support is finally coming to Office for Mac, enhancing navigation and boosting productivity. Want to learn more about these popular keyboard shortcuts? Check out our latest blog post by Hugo Garcia, Product Manager on the Microsoft 365 team: KeyTips now available in Office for Mac
KeyTips in Office for Mac are now available to Microsoft 365 Insiders, and they’ll be available to all Office for Mac users in the coming months.
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Microsoft 365 Insiders,
Happy Friday! Great news for Office for Mac users! KeyTip support is finally coming to Office for Mac, enhancing navigation and boosting productivity. Want to learn more about these popular keyboard shortcuts? Check out our latest blog post by Hugo Garcia, Product Manager on the Microsoft 365 team: KeyTips now available in Office for Mac
KeyTips in Office for Mac are now available to Microsoft 365 Insiders, and they’ll be available to all Office for Mac users in the coming months.
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Simulink – How to create a conditional “if” block
Dear experts,
I have a simulink model, in this model there are two equations.
The 1st eq applies when the speed increases from 50 to 70 rpm
The 2nd eq is applied when the speed decreases from 70 to 50 rpm
So when the speed goes from 50 to 70, I use the 1st eq. Until the speed reaches >=70.
Then I start using the 2nd eq. Until the speed reaches <=50.
and so on.
How can I create blocks for this purpose in simulink.
Thank you.Dear experts,
I have a simulink model, in this model there are two equations.
The 1st eq applies when the speed increases from 50 to 70 rpm
The 2nd eq is applied when the speed decreases from 70 to 50 rpm
So when the speed goes from 50 to 70, I use the 1st eq. Until the speed reaches >=70.
Then I start using the 2nd eq. Until the speed reaches <=50.
and so on.
How can I create blocks for this purpose in simulink.
Thank you. Dear experts,
I have a simulink model, in this model there are two equations.
The 1st eq applies when the speed increases from 50 to 70 rpm
The 2nd eq is applied when the speed decreases from 70 to 50 rpm
So when the speed goes from 50 to 70, I use the 1st eq. Until the speed reaches >=70.
Then I start using the 2nd eq. Until the speed reaches <=50.
and so on.
How can I create blocks for this purpose in simulink.
Thank you. conditional block in simulink MATLAB Answers — New Questions
Dynamics 365: User licensing for users without CRM access
Hello,
am I allowed to have activated users in D365 that do not have a valid license? The users do not have CRM access, do not work in CRM and only serve as record owners. I could not find anything useful in the license model. The option of creating users as contacts and using them is out of the question, as we really want to license the users in the further course of the project and use them as record owners.
Greetings
Alex
Hello, am I allowed to have activated users in D365 that do not have a valid license? The users do not have CRM access, do not work in CRM and only serve as record owners. I could not find anything useful in the license model. The option of creating users as contacts and using them is out of the question, as we really want to license the users in the further course of the project and use them as record owners. GreetingsAlex Read More
Looking for a solution on how to best approach this problem
Hello all,
I am interested in finding the best solution or direction for what I want to do. I am tired of seeing a wall of text that looks like a computer vomited in Teams chat every time a user posts this information. I am looking to group the strings together by group name. Here is the original data, just condensed:
Updated Batch Validation Results:
Update sets associated to release but not in release batch: [ “ABC_Group1_STRY1009926_AD_V2”, “ABC_Group1_STRY1006750_AD”, “ABC_Group2_STRY1016743_CMA” ]
Update sets not associated to the release but in release batch: [ “ABC_Group1_STRY0978210_AR_Scope”, “ABC_Group2_STRY0978210_AR” ]
Stories with update sets in release batch but not associated with release: [ “STRY0978210” ]
What I envision is:
Updated Batch Validation Results:
Update sets associated to release but not in release batch:
[ “ABC_Group1_STRY1009926_AD_V2”, “ABC_Group1_STRY1006750_AD”]
[“ABC_Group2_STRY1016743_CMA” ]
Update sets not associated to the release but in release batch:
[ “ABC_Group1_STRY0978210_AR_Scope”]
[“ABC_Group2_STRY0978210_AR” ]
Stories with update sets in release batch but not associated with release: [ “STRY0978210” ]
What would be a best solution to look into to reformat the Teams message either before or after it has been posted by someone else in a group chat?
Hello all, I am interested in finding the best solution or direction for what I want to do. I am tired of seeing a wall of text that looks like a computer vomited in Teams chat every time a user posts this information. I am looking to group the strings together by group name. Here is the original data, just condensed: Updated Batch Validation Results: Update sets associated to release but not in release batch: [ “ABC_Group1_STRY1009926_AD_V2”, “ABC_Group1_STRY1006750_AD”, “ABC_Group2_STRY1016743_CMA” ] Update sets not associated to the release but in release batch: [ “ABC_Group1_STRY0978210_AR_Scope”, “ABC_Group2_STRY0978210_AR” ] Stories with update sets in release batch but not associated with release: [ “STRY0978210” ] What I envision is: Updated Batch Validation Results: Update sets associated to release but not in release batch: [ “ABC_Group1_STRY1009926_AD_V2”, “ABC_Group1_STRY1006750_AD”] [“ABC_Group2_STRY1016743_CMA” ] Update sets not associated to the release but in release batch: [ “ABC_Group1_STRY0978210_AR_Scope”][“ABC_Group2_STRY0978210_AR” ] Stories with update sets in release batch but not associated with release: [ “STRY0978210” ] What would be a best solution to look into to reformat the Teams message either before or after it has been posted by someone else in a group chat? Read More
compare several dates in a single cell on multiple lines to a single date in another cell
Hi, I have a sheet that lists appointment dates on separate lines within a cell. I want a formula that will count the number of dates that appear in the cell that occurred before a specified date located within another cell.
example:
appointments after 1/1/20196 months# appointments on or before 6 months07/25/2022 Follow up Appointment – By Phone – 1 of 2 – 30 MIN
11/10/2022 Follow up Appointment – By Phone – 2 of 2 – 30 MIN
04/03/2023 Med Check – Video – 30 MIN
05/02/2023 Med Check – Video – 30 MIN
05/30/2023 Med Check – Video – 30 MIN 11/19/2022(I want a formula that will return 2 here since 2 dates in column A are before the date in column B)
Hi, I have a sheet that lists appointment dates on separate lines within a cell. I want a formula that will count the number of dates that appear in the cell that occurred before a specified date located within another cell. example: appointments after 1/1/20196 months# appointments on or before 6 months07/25/2022 Follow up Appointment – By Phone – 1 of 2 – 30 MIN 11/10/2022 Follow up Appointment – By Phone – 2 of 2 – 30 MIN 04/03/2023 Med Check – Video – 30 MIN 05/02/2023 Med Check – Video – 30 MIN 05/30/2023 Med Check – Video – 30 MIN 11/19/2022(I want a formula that will return 2 here since 2 dates in column A are before the date in column B) Read More
Experience the revamped Forms with your Microsoft account
We’ve recently updated the end-to-end experience for Microsoft account holders, from form creation to response analysis, making it more modern and intuitive. This exciting revamp gives you a fresh look on the landing, portal, design, and result pages. Whether you’re planning a family reunion, organizing a party, or simply doing a check-in, the new Forms offers a seamless and enjoyable experience from start to finish. Let’s explore the new experience together!
To give you a better sense of the revamped experience and put it to good use, let’s create a party invitation together. Summer is here—imagine you’re planning a barbecue at your place, inviting friends over for some fun and good times together.
New template type – invitation and check-in
In the portal page, we’ve organized templates into four categories. Alongside survey and quiz, we’ve added invitation and check-in templates. Since you’re planning a barbecue party and want to save some time for crafting the invitation, you can just select invitation template to begin crafting your own.
Access templates anytime
Upon entering the design page, you’ll notice that you can easily access various templates on the left side pane. In this instance, as you realize your birthday is approaching, you decide to expand your plans beyond just a barbecue and include a celebration. You locate the Birthday party invitation template and make the switch accordingly.
Customize style and layout
From the right-side pane, you have the option to select a style from our suggestions or personalize your own. Additionally, you can choose the layout of the cover page for your invitation. In this scenario, considering it’s your birthday, you opt for a birthday-themed style. Recognizing that most of the audience will likely view the invitation on their phones, you select a layout optimized for mobile viewing.
Versatile distribution options
After creating the invitation, it’s time to send it out! In the new distribution interface, you can now choose to live present the form to your audience for better engagement. Alternatively, you can still send your form using traditional methods such as URL, QR code, email, or sharing on social media. Simply select your preferred method and send the invitation to your friends and family.
Why wait? Visit forms.office.com now and try out the revamped experience with your Microsoft account.
Microsoft Tech Community – Latest Blogs –Read More
AI21 Jamba-Instruct launches on Azure AI Models-as-a-Service
In collaboration with AI21, Microsoft is excited to announce AI21’s Jamba-Instruct foundation chat completion model available now as a serverless API within Azure AI’s Models-as-a-Service. This marks a new collaboration between AI21 and Microsoft, and the first time Jamba-Instruct is widely available through a cloud partner.
“We are thrilled to collaborate with Microsoft to introduce Jamba-Instruct to Microsoft Azure customers. This collaboration underscores our shared commitment to empowering enterprises with innovative AI solutions,” said Pankaj Dugar, SVP, GM North America of AI21. “Microsoft’s dedication to putting customers first and making cutting-edge technology accessible aligns perfectly with our mission at AI21. With Jamba-Instruct available on Azure AI, customers now have access to a transformative tool that will revolutionize how they approach language processing and drive unprecedented levels of efficiency and insight.”
Azure AI provides a diverse array of advanced and user-friendly models, enabling customers to select the model that best fits their use case. Over the past eight months, we’ve expanded our model catalog through our partnerships with leading generative AI model providers to release their models and with Microsoft Research for releasing Phi-3. Azure AI model catalog lets developers select from over 1,600+ foundational models, including LLMs, SLMs, chat completion, and multimodal models from industry leaders like AI21, Cohere, Databricks, Deci AI, Hugging Face, Microsoft Research, Mistral AI, NVIDIA, OpenAI, and Stability AI. This extensive selection ensures that Azure customers can find the most suitable model for their unique use case.
The Jamba-Instruct model
In offering Jamba-Instruct as part of the Models as a Service (MaaS) offering, both AI21 and Microsoft affirm their commitment to equipping enterprise developers with increased choice in models to build and scale generative AI applications through popular LLM developer tools like Azure AI prompt flow, Azure AI Common API Inference, LangChain, and AI21’s Azure client.
Based on information from AI21, Jamba-Instruct is their most recent and powerful model to date. With the production-grade Mamba-based model, Jamba-Instruct leverages its hybrid architecture to achieve great performance, quality, and cost efficiency. In parallel, Azure AI offers a safe and compliant platform for setting up and running AI solutions, and a wide range of tools and services for creating, refining, and testing AI models. Additionally, Azure AI Content Safety offers filters that are enabled to screen for harmful content generated by the model, helping developers build safe and trustworthy applications.
Features of Jamba-Instruct
As outlined by AI21, Jamba-Instruct stands out for the following:
Unprecedented context window length: Offering a 70K context window, Jamba-Instruct is built to effectively handle long context instances. From streamlining document comprehension to enabling more robust and sophisticated RAG Engine mechanisms, Jamba-Instruct’s context window opens new opportunities for powerful GenAI workflows.
Superior performance on long context use cases: According to AI21, Jamba-Instruct outperforms across long context use case benchmarks, including QA (question answering) on earnings call transcripts and extracting key insights from lengthy legal documents. To view information on results for long-context QA benchmarks, on AI21’s Jamba base model, check out the whitepaper.
Cost-efficient processing: Due to its unique hybrid architecture, Jamba-Instruct handles lengthy context on a smaller cloud footprint, according to AI21.
Value for cost: According to AI21, Jamba-Instruct is highly competitive in common quality benchmarks, and its pricing makes it an intuitive choice for enterprises looking to build and scale GenAI applications while optimizing for cost. Simply put, Jamba-Instruct delivers high value for its cost among its size class.
Accelerating time to production
By utilizing the instruction-tuned Jamba-Instruct on Azure’s platform, organizations can harness the full potential of AI while having safe, reliable, and secure use. As an instruction-tuned model, Jamba-Instruct comes with built-in safety instructions, chat capabilities, and complex command comprehension needed to make it ready for immediate use by enterprises.
Developers using Jamba-Instruct can work seamlessly with tools in Azure AI Studio, such as Azure AI Content Safety, Azure AI Search, and prompt flow to enhance effective AI practices. Here are some main advantages that highlight the smooth integration and strong support system provided by Jamba-Instruct with Azure, Azure AI and Models as a Service:
Enhanced Security and Compliance: Azure places a strong emphasis on data privacy and security, adopting Microsoft’s comprehensive security protocols to protect customer data. With Jamba-Instruct on Azure AI Studio, enterprises can operate confidently, knowing their data remains within the secure bounds of the Azure cloud, thereby enhancing privacy and operational efficiency.
Content Safety Integration: Customers can integrate Jamba-Instruct models with content safety features available through Azure AI Content Safety, enabling additional responsible AI practices. This integration facilitates the development of safer AI applications, ensuring content generated or processed is monitored for compliance and ethical standards.
Simplified Assessment of LLM flows: Azure AI’s prompt flow allows evaluation flows, which help developers to measure how well the outputs of LLMs match the given standards and goals by computing metrics. This feature is useful for workflows created with Jamba-Instruct; it enables a comprehensive assessment using metrics such as groundedness, which gauges the pertinence and accuracy of the model’s responses based on the input sources when using a retrieval augmented generation (RAG) pattern.
Client integration: You can use the API and key with various clients. Use the provided API in Large Language Model (LLM) tools such as prompt flow, OpenAI, LangChain, LiteLLM, CLI with curl and Python web requests. Deeper integrations and further capabilities coming soon.
Simplified Deployment and Inference: By deploying AI21 models through MaaS with pay-as-you-go inference APIs, developers can take advantage of the power of Jamba-Instruct without managing underlying infrastructure in their Azure environment. You can view the pricing on Azure Marketplace for Jamba-Instruct based on input and output token consumption.
These features demonstrate Azure’s commitment to offering an environment where organizations can harness the full potential of AI technologies like Jamba-Instruct efficiently and responsibly, driving innovation while maintaining high standards of security and compliance.
With Azure AI’s commitment to data security, privacy, and pay-as-you-go inference APIs, developers can focus on building, knowing that their enterprise data remains secure without needing to dedicate additional time to maintaining complex infrastructure.
Getting started with Jamba-Instruct on Azure
We invite you to innovate using Jamba-Instruct on Azure AI Studio. There are a wide variety of use cases that companies are building including automated term sheet generators, product description generators, and virtual health assistants. You can view various other use cases here.
To start building, enter the Azure AI Studio model catalog and utilize the Jamba-Instruct model. To view documentation on getting started, visit this link. Deploying Jamba-Instruct takes a couple of minutes by following these clear steps:
Familiarize Yourself: If you’re new to Azure AI Studio, start by reviewing this documentation to understand the basics and set up your first project.
Access the Model Catalog: Open the model catalog in AI Studio.
Find the Model: Use the filter to select the AI21 collection or click the “View models” button on the MaaS announcement card.
Select the Model: Open the AI21-Jamba-Instruct model from the list.
Deploy the Model: Click on ‘Deploy’ and choose the Pay-as-you-go (PAYG) deployment option.
Subscribe and Access: Subscribe to the offer to gain access to the model (usage charges apply), then proceed to deploy it.
Explore the Playground: After deployment, you will automatically be redirected to the Playground. Here, you can explore the model’s capabilities.
Customize Settings: Adjust the context or inference parameters to fine-tune the model’s predictions to your needs.
Access Programmatically: Click on the “View code” button to obtain the API, keys, and a code snippet. This enables you to access and integrate the model programmatically.
Integrate with Tools: Use the provided API in Large Language Model (LLM) tools such as prompt flow, Semantic Kernel, LangChain, or any other tools that support REST API with key-based authentication for making inferences.
FAQs
What does it cost to use the Jamba-Instruct model on Azure?
You are billed based on the number of prompt and completions tokens. You can review the pricing in the Marketplace offer details tab when deploying the model. You can also find the pricing on the Azure Marketplace.
Paygo-inference-input tokens are 1k for 0.007, and paygo-inference-output-tokens are 1k for 0.0005.
Do I need GPU capacity in my Azure subscription to use Jamba-Instruct?
No, you do not need GPU capacity. The Jamba-Instruct is offered as an API through Models as a Service.
Is Jamba-Instruct available in Azure Machine Learning Studio?
Yes, Jamba-Instruct is available in the model catalog in both Azure AI Studio and Azure Machine Learning Studio.
Jamba-Instruct is listed on the Azure Marketplace. Can I purchase and use Jamba-Instruct directly from Azure Marketplace?
Azure Marketplace is our foundation for commercial transactions for models built on or built for Azure. The Azure Marketplace enables the purchasing and billing of Jamba-Instruct. However, model discoverability occurs in both Azure Marketplace and the Azure AI model catalog. Meaning you can search and find Jamba-Instruct in both the Azure Marketplace and Azure AI model catalog.
If you search for Jamba-Instruct in Azure Marketplace, you can subscribe to the offer before being redirected to the Azure AI model catalog in Azure AI Studio where you can complete subscribing and can deploy the model.
If you search for Jamba-Instruct in the Azure AI model catalog, you can subscribe and deploy the model from the Azure AI model catalog without starting from the Azure Marketplace. The Azure Marketplace still tracks the underlying commerce flow.
Given that Jamba-Instruct is billed through the Azure Marketplace, does it retire my Azure consumption commitment (aka MACC)?
Yes, Jamba-Instruct is an “Azure benefit eligible” Marketplace offer, which indicates MACC eligibility. Learn more about MACC here: https://learn.microsoft.com/en-us/marketplace/azure-consumption-commitment-benefit
Is my inference data shared with AI21? What about safety, privacy, and data processing?
No, Microsoft does not share the content from prompts or outputs with AI21. Learn more about data use through model catalog here: Data, privacy, and security for use of models through the Model Catalog in Azure AI Studio
Are there rate limits for the Jamba-Instruct model on Azure?
Yes, there are rate limits for the Jamba-Instruct model on Azure. Each deployment has a rate limit of 400 tokens per minute and 1,000 API requests per minute. Contact Azure customer support if you have additional questions.
Is the Jamba-Instruct model region specific?
Jamba-Instruct model API endpoints can be created in AI Studio projects to Azure Machine Learning workspaces in EastUS2 and Sweden Central. If you want to use the model in prompt flow in project or workspaces in other regions, you can use the API and key as a connection to prompt flow manually. Essentially, you can use the API from any Azure region once you create it in EastUS2 or Sweden Central.
Can I fine-tune the Jamba-Instruct model on Azure?
You cannot currently fine-tune the model through Azure AI Studio.
Can I use MaaS models in any Azure subscription types?
Customers can use MaaS models in all Azure subsection types with a valid payment method, except for the CSP (Cloud Solution Provider) program. Free or trial Azure subscriptions are not supported.
Microsoft Tech Community – Latest Blogs –Read More
Sync Up Episode 11: Live from Microsoft 365 Conference!
The latest edition of Sync Up is live now in your favorite podcast app! This month, Arvind Mishra and I are explored all the announcements and energy of the Microsoft 365 Community Conference! Even better, we had on-site interviews with a host of OneDrive experts!
Mark Kashman (you read that right, the Mark Kashman, of Intrazone!) talked about our experiences at the conference, including the :robot_face: Age of Copilots, the magic of in-person conferences, and some of the amazing SharePoint-related features that were shown off!
Lesha Bhansali shared how OneDrive is available everywhere, from Windows to Mac to Teams to Outlook, making it easy for your users to be productive inside the apps that they already use!
Carter Green talked about the latest improvements we’re bringing to the OneDrive desktop app, including :rainbow: colored folders, and Sync health report exports!
Vishal Lodha made a second consecutive appearance on Sync Up to talk about the amazing customer interactions we had, including an amazing panel where customers shared their experiences with OneDrive and how they’ve unlocked that power for their users!
Show: https://aka.ms/SyncUp | Apple Podcasts: https://aka.ms/SyncUp/Apple | Spotify: https://aka.ms/SyncUp/Spotify | RSS: https://aka.ms/SyncUp/RSS
But wait, there’s more! Our last episode of Sync Up on Data Migration is now available on YouTube! Be sure to check it out & subscribe!
If you weren’t able to attend the conference, here’s just a sneak peak of the experience!
That’s all for this week! Thank you all for listening!
Microsoft Tech Community – Latest Blogs –Read More
What’s new in Microsoft Intune June 2024
As spring turns to summer, and sprouts appear in my garden, I think about all the preparation I’ve made for their environment—turning the soil, setting up the watering system, adding peat moss—and know that the yield will be greater and the harvest better. Such is the case with Microsoft Intune. As we continue to enhance the capabilities, each one an investment, the cumulative result is a richer and more robust management experience. Below, we highlight some of the newest features.
New troubleshooting tool for mobile devices
Part of diagnosing an issue is not only defining what is wrong but also what is not wrong. Our customers asked for a simple way to temporarily remove apps and configurations from a device managed in Microsoft Intune as part of the troubleshooting process. The result is a feature we call Remove apps and configuration (RAC). Before RAC, removing settings involved excluding devices from policy assignments or removing users from groups, and then waiting for devices to check in. After diagnosing the device, those assignments and group memberships would need to be restored one by one. Now, RAC affords a set of useful troubleshooting steps:
Real-time monitoring of which policies and apps are removed/restored
Selective restore of individual apps and policies
Temporary removal of apps and policies with an automated restore in 8 to 24 hours
Policy assignments and group membership remain unchanged
This initial release will be distributed in early July. It will support iOS/iPadOS and Android corporate-owned devices, and it will be available to GCC, GCC High, and DoD environments on release. For more information on this tool, follow the update on the Microsoft 365 roadmap.
Windows enrollment attestation preview is here
Last month we talked about device attestation capabilities coming to Intune. This month, the public preview of Windows enrollment attestation is starting to roll out with the new reporting and Device Attest action.
This feature builds on attestation by applying it to enrollment. Applicable Windows devices have their enrollment credentials stored in the device hardware, in this case Trusted Platform Module (TPM) 2.0, and Intune can then attest to this storage—meaning that the device enrolled securely. Successful devices show as Completed in the report. Devices that are Not Started or Failed can be retried using the new Device Attest at the top of the report. This will be available in public preview by the end of June.
Stay up to date on the release of this capability to the public Microsoft 365 roadmap.
More granular endpoint security access controls
Role-based access control (RBAC) enhances organizations’ ability to configure access to specific workloads while maintaining a robust security posture. Our customers asked for even more granular controls to help scope security work across geographic areas, business units, or different teams to only relevant information and features. In this latest release, we are adding specific permission sets to enable more flexibility in creating custom roles for:
Endpoint detection and response
Application control
Attack surface reduction
We plan to have new permission sets for all endpoint security workloads in the future.
We know that many of our customers use a custom role with Security baselines permission to manage security workloads, so we are automatically adding the new permissions to this role. This way, no permissions will be lost for existing users. For new custom roles that are granted Security baselines permission, these will not include the new permissions by default but rather only those without specific permission sets.
This update also applies to customers using the Microsoft Defender console to manage security policies, and it is available in GCC, GCC High, and DoD environments. Read more about granular RBAC permissions.
So much of what we do is a direct result of customer feedback. Please join our community, visit the Microsoft Feedback portal, or leave a comment on this post. We value all your input, so please share it, especially after working with these exciting new capabilities.
Stay up to date! Bookmark the Microsoft Intune Blog and follow us @MSIntune on X and on LinkedIn to continue the conversation.
Microsoft Tech Community – Latest Blogs –Read More
A (simple) way to use ismember between datetime arrays with different formats?
Is there a (simple) way to use ismember between datetime arrays with different formats?
% Input
A = datetime(…
[’19-Jun-2023′,
’20-Jun-2023′,
’21-Jun-2023′,
’22-Jun-2023′,
’23-Jun-2023′,
’24-Jun-2023′,
’25-Jun-2023′]);
tmp = [{’23-Jun-2023 19:00:00′}
{’24-Jun-2023 16:00:00′}
{’24-Jun-2023 11:00:00′}
{’19-Jun-2023 16:00:00′}
{’20-Jun-2023 10:00:00′}
{’21-Jun-2023 10:00:00′}
{’22-Jun-2023 09:00:00′}
{’23-Jun-2023 14:00:00′}
{’19-Jun-2023 17:00:00′}
{’20-Jun-2023 11:00:00′}
{’21-Jun-2023 17:00:00′}
{’22-Jun-2023 15:00:00′}
{’23-Jun-2023 06:00:00′}
{’24-Jun-2023 11:00:00′}
{’25-Jun-2023 19:00:00′}
{’20-Jun-2023 11:00:00′}
{’21-Jun-2023 09:00:00′}
{’23-Jun-2023 12:00:00′}
{’25-Jun-2023 17:00:00′}
{’23-Jun-2023 12:00:00′}
{’22-Jun-2023 07:00:00′}];
B = datetime(tmp, ‘InputFormat’, ‘dd-MMM-yyyy HH:mm:ss’);
ismember(A,B)Is there a (simple) way to use ismember between datetime arrays with different formats?
% Input
A = datetime(…
[’19-Jun-2023′,
’20-Jun-2023′,
’21-Jun-2023′,
’22-Jun-2023′,
’23-Jun-2023′,
’24-Jun-2023′,
’25-Jun-2023′]);
tmp = [{’23-Jun-2023 19:00:00′}
{’24-Jun-2023 16:00:00′}
{’24-Jun-2023 11:00:00′}
{’19-Jun-2023 16:00:00′}
{’20-Jun-2023 10:00:00′}
{’21-Jun-2023 10:00:00′}
{’22-Jun-2023 09:00:00′}
{’23-Jun-2023 14:00:00′}
{’19-Jun-2023 17:00:00′}
{’20-Jun-2023 11:00:00′}
{’21-Jun-2023 17:00:00′}
{’22-Jun-2023 15:00:00′}
{’23-Jun-2023 06:00:00′}
{’24-Jun-2023 11:00:00′}
{’25-Jun-2023 19:00:00′}
{’20-Jun-2023 11:00:00′}
{’21-Jun-2023 09:00:00′}
{’23-Jun-2023 12:00:00′}
{’25-Jun-2023 17:00:00′}
{’23-Jun-2023 12:00:00′}
{’22-Jun-2023 07:00:00′}];
B = datetime(tmp, ‘InputFormat’, ‘dd-MMM-yyyy HH:mm:ss’);
ismember(A,B) Is there a (simple) way to use ismember between datetime arrays with different formats?
% Input
A = datetime(…
[’19-Jun-2023′,
’20-Jun-2023′,
’21-Jun-2023′,
’22-Jun-2023′,
’23-Jun-2023′,
’24-Jun-2023′,
’25-Jun-2023′]);
tmp = [{’23-Jun-2023 19:00:00′}
{’24-Jun-2023 16:00:00′}
{’24-Jun-2023 11:00:00′}
{’19-Jun-2023 16:00:00′}
{’20-Jun-2023 10:00:00′}
{’21-Jun-2023 10:00:00′}
{’22-Jun-2023 09:00:00′}
{’23-Jun-2023 14:00:00′}
{’19-Jun-2023 17:00:00′}
{’20-Jun-2023 11:00:00′}
{’21-Jun-2023 17:00:00′}
{’22-Jun-2023 15:00:00′}
{’23-Jun-2023 06:00:00′}
{’24-Jun-2023 11:00:00′}
{’25-Jun-2023 19:00:00′}
{’20-Jun-2023 11:00:00′}
{’21-Jun-2023 09:00:00′}
{’23-Jun-2023 12:00:00′}
{’25-Jun-2023 17:00:00′}
{’23-Jun-2023 12:00:00′}
{’22-Jun-2023 07:00:00′}];
B = datetime(tmp, ‘InputFormat’, ‘dd-MMM-yyyy HH:mm:ss’);
ismember(A,B) ismember, datetime, cell MATLAB Answers — New Questions
Copilot For Service Issue.
I am trying to connect Copilot for service to my teams. Copilot for Service is showing a disconnect sign when I have a meeting with clients. Does anyone know what the issue is.
I am trying to connect Copilot for service to my teams. Copilot for Service is showing a disconnect sign when I have a meeting with clients. Does anyone know what the issue is. Read More
Nested IF and OR functions not returning correct values
I’m trying to set up an IF function to check data in a column and insert specific values in another. I’ve nested other OR and IF functions within it, but the data keeps returning true even if it is false. I don’t see any obvious errors. Any thoughts? This is my current function:
=IF(OR($C2:$C131=”ADMIN”,$C2:$C131=”PLANT”),”CAT1″,IF(OR($C2:$C131=”ENDO”,$C2:$C131=”ONC”,$C2:$C131=”VAS”,$C2:$C131=”PLASTIC”,$C2:$C131=”SURG”,$C2:$C131=”MIS”),”CAT2″,IF(OR($C2:$C131=”CARDIO”,$C2:$C131=”COLOR”,$C2:$C131=”LARY”,$C2:$C131=”TRUM”,),”CAT3″,” “)))
I’m trying to set up an IF function to check data in a column and insert specific values in another. I’ve nested other OR and IF functions within it, but the data keeps returning true even if it is false. I don’t see any obvious errors. Any thoughts? This is my current function: =IF(OR($C2:$C131=”ADMIN”,$C2:$C131=”PLANT”),”CAT1″,IF(OR($C2:$C131=”ENDO”,$C2:$C131=”ONC”,$C2:$C131=”VAS”,$C2:$C131=”PLASTIC”,$C2:$C131=”SURG”,$C2:$C131=”MIS”),”CAT2″,IF(OR($C2:$C131=”CARDIO”,$C2:$C131=”COLOR”,$C2:$C131=”LARY”,$C2:$C131=”TRUM”,),”CAT3″,” “))) Read More
sql query realted to null and not null values in a temp table
Hi all,
1.This is my table from that I have to select that not null values of ID1 and ID3, also select NULL value of ID2 and ID4 not null value.
2. If ID1,ID3 having both NULL and NOT NULL values means show all NOT NULL values.
3. ID2 having NULL values means show that NULL value of ID2.
4.ID 4 has NOT NULL value means show that ID4 NOT NULL value .
if the records have similar columns then take not null values, no similar take whether null or not null
output should be like this :
can anyone please help me with this, Thanks in advance!!
Hi all,1.This is my table from that I have to select that not null values of ID1 and ID3, also select NULL value of ID2 and ID4 not null value.2. If ID1,ID3 having both NULL and NOT NULL values means show all NOT NULL values.3. ID2 having NULL values means show that NULL value of ID2.4.ID 4 has NOT NULL value means show that ID4 NOT NULL value .if the records have similar columns then take not null values, no similar take whether null or not null output should be like this : can anyone please help me with this, Thanks in advance!! Read More
MidDay Café Episode 55 – AI and the Employee Experience
As the capabilities, and transformational power of AI, continue to evolve at a quickening pace, organizations are grappling with choices around when and how to implement and its impact on organizations and their employee experience. Microsoft is committed to helping organizations begin today building that AI muscle so they can assess and be prepared to adapt new modes of work and workstreams ushered in by this rapidly evolving age of Enterprise AI.
In this MidDay Café hosts Tyrelle Barnes and Michael Gannotti have a sit-down discussion around AI, the need to build AI muscle at an individual and organizational level now, and its impact on the employee experience. Also discussed are Microsoft services that can help customers more fully assess their organizations use of AI and its impact in a data driven fashion.
Resources:
Microsoft Copilot for Microsoft 365—Features and Plans | Microsoft 365
Microsoft Copilot for Microsoft 365 documentation | Microsoft Learn
Copilot for Microsoft 365 Adoption Playbook | Microsoft Copilot
Deploying Copilot for Microsoft 365 in four chapters – Inside Track Blog
Copilot Success Kit – Microsoft Adoption
Employee Experience and Engagement | Microsoft Viva
Microsoft Viva | Microsoft Learn
Microsoft Viva – Microsoft Adoption
*The following are AI driven notes automatically provided by Microsoft Teams Meeting Recap
Meeting notes:
AI Transformation: Michael and Tyrelle discussed the ongoing AI transformation in the workplace, emphasizing its rapid pace and the need for organizations to adapt quickly to leverage AI effectively. They highlighted the importance of AI in driving innovation and efficiency.
AI’s Impact on Innovation: Michael and Tyrelle emphasized the transformative impact of AI on innovation, noting the rapid pace at which AI is evolving and its significance in driving workplace efficiency and productivity.
Organizational Adaptation: They discussed the necessity for organizations to quickly adapt to the AI transformation, highlighting the importance of being proactive in leveraging AI to remain competitive in the market.
AI in the Workplace: The conversation included insights on the integration of AI into various aspects of the workplace, stressing the need for organizations to embrace AI to enhance their operational capabilities.
AI in Mobile Devices: Michael highlighted the integration of AI into mobile devices, such as iOS and Android, and the implications for workplace productivity and personal convenience. This underscores the ubiquity of AI and the necessity for organizations to consider mobile platforms in their AI strategies.
AI Integration in Mobile: Michael discussed the widespread integration of AI into mobile platforms, including iOS and Android devices, and how this trend is influencing workplace productivity and personal convenience.
AI Ubiquity: The conversation underscored the ubiquity of AI and the importance for organizations to incorporate mobile AI strategies into their overall approach to technology adoption.
AI Compliance and Security: Michael stressed the importance of using AI tools that are compliant and secure for enterprise needs, pointing out the limitations of consumer AI tools in a professional setting. This highlights the need for organizations to choose AI solutions that align with their security and compliance requirements.
Enterprise AI Compliance: Michael emphasized the critical need for AI tools to be compliant with enterprise security and regulatory standards, differentiating between the capabilities of enterprise-grade AI and consumer AI tools.
Security Limitations: He pointed out the limitations and potential risks associated with using consumer AI tools in professional settings, advocating for the selection of AI solutions that meet organizational security and compliance needs.
AI Tool Selection: The discussion included the importance of carefully selecting AI tools that align with an organization’s security policies and compliance requirements to ensure data protection and regulatory adherence.
Employee Experience and AI: Tyrelle discussed the impact of AI on employee experience, particularly in reducing stress and repetitive tasks. This underscores the potential of AI to improve workplace satisfaction and productivity.
AI’s Role in Employee Experience: Tyrelle highlighted the positive impact of AI on employee experience, focusing on how AI can alleviate stress and reduce the burden of repetitive tasks, thereby improving overall workplace satisfaction and productivity.
Workplace Satisfaction: The conversation explored the potential of AI to enhance workplace satisfaction by assisting employees with tasks that can be automated, allowing them to focus on more meaningful work.
AI and Innovation Pace: Michael and Tyrelle reflected on the accelerated pace of innovation due to AI, predicting a significant leap in technological advancements in the coming years. They emphasized the importance of organizations being proactive in adopting AI to stay competitive.
Accelerated Technological Advancements: Michael and Tyrelle discussed the accelerated pace of innovation driven by AI, predicting that the coming years will see significant leaps in technological advancements, which organizations must proactively adopt to maintain a competitive edge.
Proactive AI Adoption: They emphasized the need for organizations to be proactive in adopting AI technologies, highlighting the competitive advantage gained by staying ahead in the rapidly evolving AI landscape.
Future of AI Innovation: The conversation included insights into the future trajectory of AI innovation, suggesting that the pace of development is likely to continue accelerating, further transforming industries and work practices.
Viva and Copilot Integration: Michael and Tyrelle discussed the integration of Viva and Copilot, highlighting how these tools together can enhance employee experience by providing insights and facilitating more efficient work processes. This demonstrates the synergy between different Microsoft tools in improving workplace productivity.
Viva and Copilot Synergy: Michael and Tyrelle explored the integration of Viva and Copilot, detailing how the synergy between these Microsoft tools can lead to enhanced employee experiences and more efficient work processes.
Insights and Efficiency: The discussion highlighted how the combination of Viva and Copilot provides valuable insights and facilitates efficiency, demonstrating the potential of integrated tools to improve workplace productivity.
Improving Productivity: They discussed the role of Viva and Copilot in improving workplace productivity, emphasizing the importance of leveraging integrated tools to streamline work processes and enhance employee engagement.
Thanks for visiting!
Tyrelle Barnes LinkedIn : Michael Gannotti LinkedIn
Microsoft Tech Community – Latest Blogs –Read More