Month: September 2024
windows defender
i can not disable my real time protection settings why?
i can not disable my real time protection settings why? Read More
Combining Two dax measures to avoid dax reference
Hi Team,
I have created two dax codes as below:
Related_(Target cost)_1 =
VAR TargetValue =
CALCULATE (
SUM ( Target[Value] ),
‘Target'[DBName-Point_id] = MAX ( ‘Accruals'[DBName-Point_Id] )
&& ‘Target'[TargetType] = 1
&& ‘Target'[month] = FORMAT ( MAX ( ‘Accruals'[Date] ), “mmmm” )
)
VAR days =
SUMX ( ‘Accruals’, TargetValue )
RETURN
–days/[no of days]
COALESCE ( days / [no of days], 0 )Target cost_1 =
SUMX ( ‘Accruals’, COALESCE ( [Related_(Target cost)_1], 0 ) )
Their results individually as shown below
Is it possible to merge these dax measures into a single dax ? Also, final values at the total & column will be same as below ?
I am doing this in order to avoid the reference of measures within another dax.
Please help me.
Thanks in advance!
Hi Team, I have created two dax codes as below: Related_(Target cost)_1 =
VAR TargetValue =
CALCULATE (
SUM ( Target[Value] ),
‘Target'[DBName-Point_id] = MAX ( ‘Accruals'[DBName-Point_Id] )
&& ‘Target'[TargetType] = 1
&& ‘Target'[month] = FORMAT ( MAX ( ‘Accruals'[Date] ), “mmmm” )
)
VAR days =
SUMX ( ‘Accruals’, TargetValue )
RETURN
–days/[no of days]
COALESCE ( days / [no of days], 0 )Target cost_1 =
SUMX ( ‘Accruals’, COALESCE ( [Related_(Target cost)_1], 0 ) ) Their results individually as shown below Is it possible to merge these dax measures into a single dax ? Also, final values at the total & column will be same as below ? I am doing this in order to avoid the reference of measures within another dax.Please help me. Thanks in advance!@SergeiBaklan Read More
Calls on behalf of callqueues are always Anonymous
We have noticed that for all our users when they calll on behalf of a callqueue are calling “Anonymous”. We have assigned resource accounts to the callqueues that have valid phone numbers. We have added the resource accounts the right way (Assign callier ID).
Users in the callqueue are able to call on behalf of the resource account. In all cases the caller ID on the recieving side sees “Anonymous” of “Private” instead of the number of the resource account. This worked fine till about a week ago.
This is completely seperate from the assigned Caller ID policy of the user. When we assign the same resource account in a Caller ID policy and assig the policy to a user, the numer of the resource account does show at the receiving end.
There seems to be a problem with the “call on behalf of a resource account” setting in all queues. We have tried several queues, resource accounts.
We have noticed that for all our users when they calll on behalf of a callqueue are calling “Anonymous”. We have assigned resource accounts to the callqueues that have valid phone numbers. We have added the resource accounts the right way (Assign callier ID). Users in the callqueue are able to call on behalf of the resource account. In all cases the caller ID on the recieving side sees “Anonymous” of “Private” instead of the number of the resource account. This worked fine till about a week ago.This is completely seperate from the assigned Caller ID policy of the user. When we assign the same resource account in a Caller ID policy and assig the policy to a user, the numer of the resource account does show at the receiving end. There seems to be a problem with the “call on behalf of a resource account” setting in all queues. We have tried several queues, resource accounts. Read More
Azure-related events in a separate Log Analytics workspaces
Hi all,
I have question about collecting Azure-related events (Entra ID, Office365, Microsoft Defender and etc.) in a separate Log Analytics workspaces.
Architecture:
– One Azure tenant
– Four subscriptions
– Log analytics workspace in every subscription
– Microsoft Sentinel enabled on every Log analytics workspace
My question is: what is the best practice or the best way to collect specific Entra ID events (e.g., events related to accounts used by the finance department) in a specific Log Analytics Workspace (LAW) dedicated to the finance department? Also, how can I collect other events for Office 365 and Microsoft Defender (related to the finance department) and store in (LAW) dedicated to the finance department?
I want to store those events in the default tables for Entra ID, Office 365, and Defender within the LAW. I do not want to store the filtered data in custom tables within the LAWs.
Hi all, I have question about collecting Azure-related events (Entra ID, Office365, Microsoft Defender and etc.) in a separate Log Analytics workspaces. Architecture:- One Azure tenant – Four subscriptions- Log analytics workspace in every subscription- Microsoft Sentinel enabled on every Log analytics workspaceMy question is: what is the best practice or the best way to collect specific Entra ID events (e.g., events related to accounts used by the finance department) in a specific Log Analytics Workspace (LAW) dedicated to the finance department? Also, how can I collect other events for Office 365 and Microsoft Defender (related to the finance department) and store in (LAW) dedicated to the finance department?I want to store those events in the default tables for Entra ID, Office 365, and Defender within the LAW. I do not want to store the filtered data in custom tables within the LAWs. Read More
Integrating Azure SQL with Django : A Step-by-Step Guide
Hi👋 I’m Sourabh and student ambassador from Bangalore studying Computer Science from BIT
Integrating Django with Azure SQL
Migrating your Django project to a cloud-based database like Azure SQL can significantly enhance its scalability, reliability, and performance. This guide will walk you through the process of integrating Django with Azure SQL.
Prerequisites
1. Azure Subscription: Get Azure for Students to receive $100 in credits for 12 months.
2. Django Project: Ensure you have an existing Django project set up.
3. VS Code: Install Visual Studio Code for your code editing needs.
Required Packages
pip install django pyodbc mssql-django
ODBC Driver installation
To connect Django to Azure SQL, you’ll need to install the ODBC driver for SQL Server. The following command installs the ODBC Driver 17 for SQL Server depending on your operating system:
For Ubuntu/Linux:
sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add –
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17
sudo apt-get install -y unixodbc-dev
For macOS:
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
brew install –no-sandbox msodbcsql17 mssql-tools
For Windows:
You can download and install the driver from Microsoft’s website.
Once the driver is installed, your Django project should be able to connect to Azure SQL using the mssql-django package.
Why Azure SQL Over SQLite3?
Scalability: Handles large datasets and high traffic effortlessly.
Reliability: Managed by Microsoft, offering high availability and disaster recovery.
Security: Advanced features like encryption, threat detection, and compliance.
Performance: Features like automatic tuning and intelligent query processing.
Remote Access: Access your database from anywhere.
Step-by-Step Integration
1. Set Up Azure SQL Database
Deployment option for Azure SQLNote – deployment can also be done through Azure Portal
Create a Resource Group:
az group create -l <location> -n <MyResourceGroup>
Create a SQL Server:
az sql server create -n <server-name> -l <location> –admin-user <admin-user> –admin-password <admin-password> -g <resource-group>
Create the Database:
az sql db create -g <resource-group> -s <server-name> -n my-db –service-objective GP_Gen5_2
Allow Your IP in Firewall:
az sql server firewall-rule create –resource-group <resource-group> –server <server-name> –name AllowMyClientIP –start-ip-address <your_public_ip> –end-ip-address <your_public_ip>
2. Install Required Packages
pip install django pyodbc mssql-django
3. Configure Django Settings
In settings.py, update the DATABASES section:
DATABASES = {
‘default’: {
‘ENGINE’: ‘mssql’,
‘NAME’: ‘my-db’,
‘USER’: ‘<admin-user>’,
‘PASSWORD’: ‘<admin-password>’,
‘HOST’: ‘<server-name>.database.windows.net’,
‘PORT’: ”,
‘OPTIONS’: {
‘driver’: ‘ODBC Driver 17 for SQL Server’,
},
}
}
4. Make Migrations and Migrate
python manage.py makemigrations
python manage.py migrate
5. Run the Server
python manage.py runserver
And that’s it! Your Django project is now integrated with Azure SQL :party_popper:.
Additional Resources:
– Azure SQL Documentation
– mssql-django GitHub Repository
Happy coding!
Useful Links
1. Creating REST API with Python, Django, and Azure SQL
2. Create REST API in Python with Django and Azure SQL
3. Deploy Python (Django/Flask) App with PostgreSQL on Azure
4. Azure SQL Migration with Data Studio
5. Azure SQL Django Sample on GitHub
Microsoft Tech Community – Latest Blogs –Read More
Announcement: GetAccept’s Digital Sales Room now available on Microsoft AppSource
Over the years, GetAccept has invested significantly in integrating with the Microsoft ecosystem. As a company transforming the digital sales landscape for nearly a decade, GetAccept has continuously evolved its product to meet the changing needs of revenue teams. While the platform has expanded its capabilities to streamline proposals, CPQ enhancement, and contract workflows for Microsoft Dynamics users, its core mission remains unchanged: to empower revenue teams by bringing personal and engaging interactions back to the online sales process, all within a powerful digital sales room.
In today’s increasingly complex B2B buying journey, standing out is more challenging than ever. B2B buyers now spend over 90% of their journey researching independently, leaving sales teams with only a small window of opportunity to make an impact. This is where GetAccept’s Digital Sales Room makes a difference — allowing you to influence and engage buyers even when you’re not physically present.
GetAccept’s Digital Sales Room empowers revenue teams to increase win rates by engaging and understanding buyers from opportunity to customer, removing friction and increasing engagement in the buying process directly from within your CRM.
Read the full Press Release or check out the GetAccept AppSource page
Over the years, GetAccept has invested significantly in integrating with the Microsoft ecosystem. As a company transforming the digital sales landscape for nearly a decade, GetAccept has continuously evolved its product to meet the changing needs of revenue teams. While the platform has expanded its capabilities to streamline proposals, CPQ enhancement, and contract workflows for Microsoft Dynamics users, its core mission remains unchanged: to empower revenue teams by bringing personal and engaging interactions back to the online sales process, all within a powerful digital sales room. In today’s increasingly complex B2B buying journey, standing out is more challenging than ever. B2B buyers now spend over 90% of their journey researching independently, leaving sales teams with only a small window of opportunity to make an impact. This is where GetAccept’s Digital Sales Room makes a difference — allowing you to influence and engage buyers even when you’re not physically present. GetAccept’s Digital Sales Room empowers revenue teams to increase win rates by engaging and understanding buyers from opportunity to customer, removing friction and increasing engagement in the buying process directly from within your CRM. Read the full Press Release or check out the GetAccept AppSource page Read More
TEC 2024 Rolls Into Dallas
The Practical Microsoft 365 Event
TEC 2024 (aka, “The Experts Conference”) takes place at the Loews Arlington Hotel on Tuesday and Wednesday next week (October 1-2, 2024) with full-day workshops on Monday, September 30. The last few tickets still remain if you find the sudden urge to mix technology with Tex-Mex cruisine.
TEC is my favorite technology conference. There are several reasons why:
A great team of people organize and run TEC. They’re all smiles.
There are always great keynote speakers (see below).
Speakers and attendees have the chance to mingle and exchange ideas in a way that just doesn’t happen at large conferences like Microsoft Ignite.
TEC includes fun sessions like the PowerShell script-off where competitors have the chance to strut their PowerShell skills in solving some real-world problems using my favorite scripting language. This year, the competitors are banned from using AI tools like ChatGPT and Microsoft 365 Copilot (both of which can generate pretty awful code) but can “phone a friend” to get advice.
Great conference parties where vendors aren’t demanding their pound of flesh before people can attend.
Unfortunately, TEC sessions are not recorded for later access. A substantial cost is involved in recording a conference and the TEC organizers decided to keep ticket prices low by eliminating “nice to have but unnecessary” costs. However, articles covering many TEC sessions appear on Practical365.com after the event, so you can keep an eye on that site to learn more.
TEC 2024 Keynote Speakers
TEC selects keynote speakers to provoke conference attendees to think about the current state of IT rather than to push the latest and greatest product. This year, TEC 2024 features:
Paul Thurrott, the well-known co-host of the Windows Weekly webcast and the brains behind Thurrott.com, will cover the future of Windows (or the lack thereof). Paul is never one to hold back on his opinions, so attendees can expect some fireworks in this session.
Andy Greenberg, a senior writer for Wired.com, covers “From Crypto Crime to Cyberwar: Stories From the Front Lines.” TEC attendees will receive a copy of Andy’s latest book, “Tracers in the Dark: The Global Hunt for the Crime Lords of Cryptocurrency” and can have their copy signed.
Shinesa Cambric from Microsoft will talk about “Identity. Where it’s been and where it’s going.” Shinesa will also hold a signing for her “Cloud Auditing Best Practices” book. Given the ongoing very real threat to on-premises and cloud deployments through badly-protected user accounts, this session should be thought-provoking.
TEC keynote speakers are an integral part of the event. The best example I can give about how keynote speakers participate in a really impactful way is how Alex Weinert, VP of Entra Security at Microsoft, took the time to sit down and help a user remove some malware from her PC at TEC 2022. Talk about going beyond the call of duty!
Workshops
TEC 2024 hosts two Microsoft 365 workshops: one on understanding and managing conditional access policies, the other on using PowerShell to automate common administrative scenarios for on-premises and cloud environments. Both are good topics, and the conditional access workshop has racked up a large attendance. I guess this reflects the challenges of building conditional access policies for an organization and the need for people to understand exactly how conditional access conditions work when Entra ID evaluates inbound connections, including controlling access by guest accounts. I hope that the session emphasizes how to impose practical security instead of using policies to make the user experience miserable.
I plan to spend some time in both workshops and look forward to learning something new from the presenters.
On to Dallas
Naturally, I’ll be looking for topics that I can cover in the Office 365 for IT Pros eBook and in articles for this site. I usually find several things to write about after attending TEC sessions, and I expect TEC 2024 to be no different. See you in Dallas!
Error importing matlab.engine in python
I am getting the following error when I type import matlab.engine in python IDLE
Traceback (most recent call last):
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 45, in <module>
pythonengine = importlib.import_module("matlabengineforpython"+_PYTHONVERSION)
File "C:UsersudvasAppDataLocalProgramsPythonPython37libimportlib__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 965, in _find_and_load_unlocked
ModuleNotFoundError: No module named ‘matlabengineforpython3_7’
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 61, in <module>
pythonengine = importlib.import_module("matlabengineforpython"+_PYTHONVERSION)
File "C:UsersudvasAppDataLocalProgramsPythonPython37libimportlib__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 670, in _load_unlocked
File "<frozen importlib._bootstrap>", line 583, in module_from_spec
File "<frozen importlib._bootstrap_external>", line 1043, in create_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
ImportError: DLL load failed: The specified procedure could not be found.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
import matlab.engine
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 64, in <module>
‘MathWorks Technical Support for assistance: %s’ % e)
OSError: Please reinstall MATLAB Engine for Python or contact MathWorks Technical Support for assistance: DLL load failed: The specified procedure could not be found.
I am using Matlab 2020a and python 3.7.1.I am getting the following error when I type import matlab.engine in python IDLE
Traceback (most recent call last):
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 45, in <module>
pythonengine = importlib.import_module("matlabengineforpython"+_PYTHONVERSION)
File "C:UsersudvasAppDataLocalProgramsPythonPython37libimportlib__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 965, in _find_and_load_unlocked
ModuleNotFoundError: No module named ‘matlabengineforpython3_7’
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 61, in <module>
pythonengine = importlib.import_module("matlabengineforpython"+_PYTHONVERSION)
File "C:UsersudvasAppDataLocalProgramsPythonPython37libimportlib__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 670, in _load_unlocked
File "<frozen importlib._bootstrap>", line 583, in module_from_spec
File "<frozen importlib._bootstrap_external>", line 1043, in create_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
ImportError: DLL load failed: The specified procedure could not be found.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
import matlab.engine
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 64, in <module>
‘MathWorks Technical Support for assistance: %s’ % e)
OSError: Please reinstall MATLAB Engine for Python or contact MathWorks Technical Support for assistance: DLL load failed: The specified procedure could not be found.
I am using Matlab 2020a and python 3.7.1. I am getting the following error when I type import matlab.engine in python IDLE
Traceback (most recent call last):
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 45, in <module>
pythonengine = importlib.import_module("matlabengineforpython"+_PYTHONVERSION)
File "C:UsersudvasAppDataLocalProgramsPythonPython37libimportlib__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 965, in _find_and_load_unlocked
ModuleNotFoundError: No module named ‘matlabengineforpython3_7’
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 61, in <module>
pythonengine = importlib.import_module("matlabengineforpython"+_PYTHONVERSION)
File "C:UsersudvasAppDataLocalProgramsPythonPython37libimportlib__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 670, in _load_unlocked
File "<frozen importlib._bootstrap>", line 583, in module_from_spec
File "<frozen importlib._bootstrap_external>", line 1043, in create_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
ImportError: DLL load failed: The specified procedure could not be found.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
import matlab.engine
File "C:UsersudvasAppDataLocalProgramsPythonPython37libsite-packagesmatlabengine__init__.py", line 64, in <module>
‘MathWorks Technical Support for assistance: %s’ % e)
OSError: Please reinstall MATLAB Engine for Python or contact MathWorks Technical Support for assistance: DLL load failed: The specified procedure could not be found.
I am using Matlab 2020a and python 3.7.1. python, engine MATLAB Answers — New Questions
Why do I receive error 5201 – Unable to connect with required Mathworks Services
Whenever I try to run MATLAB software, it displays the error message, ‘Unable to connect with required Mathworks Services(error 5201)
I’ve seen similar solutions on here, but the descriptions don’t seem the same.Whenever I try to run MATLAB software, it displays the error message, ‘Unable to connect with required Mathworks Services(error 5201)
I’ve seen similar solutions on here, but the descriptions don’t seem the same. Whenever I try to run MATLAB software, it displays the error message, ‘Unable to connect with required Mathworks Services(error 5201)
I’ve seen similar solutions on here, but the descriptions don’t seem the same. error 5201 MATLAB Answers — New Questions
Setup/Configure a DSN-less database without the Database Toolbox GUI MATLAB R2018b
Please how do I setup a DSN-less database connection without using the Database Toolbox GUI on MATLAB R2018b?Please how do I setup a DSN-less database connection without using the Database Toolbox GUI on MATLAB R2018b? Please how do I setup a DSN-less database connection without using the Database Toolbox GUI on MATLAB R2018b? dsn-less, sql server MATLAB Answers — New Questions
The code returns a value in the form of “theta_3b(x, z) =.”. How can I get this to return just theta_3b=
syms f g x y z
% % % % % Temperature Formula 3b % % % % %
theta_3b=0;
for n=0:25
t=0;
beta6 = (n*pi)/H;
eta6 = (((2*pi)/L)*(n+0.5));
mew6 = -1036;
lamda6 = (beta6.^2)+(eta6.^2)+(mew6.^2);
f(x,y,z) = sin(beta6*z).*cos(eta6*x).*sin(mew6*y).*cos(mew6*y);
C_nmp_numerator6 = int(int(int(f,z,[0 H]),y,[0 W]),x,[0 (L/2)]);
g(x,y,z) = ((cos(mew6*y)^2).*sin(mew6*y) – ((h/(k*mew6)).*(sin(mew6*y)^2).*cos(mew6*y)));
C_nmp_denominator6 = ((L*H)/8)* (int(g,y,[0 W]));
C_nmp6 = C_nmp_numerator6/C_nmp_denominator6;
theta_3b = theta_3b+(C_nmp6*(sin(beta6*z)*cos(eta6*x)*((cos(mew6*y)-(h/(k*mew6))*sin(mew6*y)))*exp(-(lamda6^2)*alpha*t)));
end
theta_3b = vpa(subs(theta_3b, {x,y,z}, {X,Y,Z}))syms f g x y z
% % % % % Temperature Formula 3b % % % % %
theta_3b=0;
for n=0:25
t=0;
beta6 = (n*pi)/H;
eta6 = (((2*pi)/L)*(n+0.5));
mew6 = -1036;
lamda6 = (beta6.^2)+(eta6.^2)+(mew6.^2);
f(x,y,z) = sin(beta6*z).*cos(eta6*x).*sin(mew6*y).*cos(mew6*y);
C_nmp_numerator6 = int(int(int(f,z,[0 H]),y,[0 W]),x,[0 (L/2)]);
g(x,y,z) = ((cos(mew6*y)^2).*sin(mew6*y) – ((h/(k*mew6)).*(sin(mew6*y)^2).*cos(mew6*y)));
C_nmp_denominator6 = ((L*H)/8)* (int(g,y,[0 W]));
C_nmp6 = C_nmp_numerator6/C_nmp_denominator6;
theta_3b = theta_3b+(C_nmp6*(sin(beta6*z)*cos(eta6*x)*((cos(mew6*y)-(h/(k*mew6))*sin(mew6*y)))*exp(-(lamda6^2)*alpha*t)));
end
theta_3b = vpa(subs(theta_3b, {x,y,z}, {X,Y,Z})) syms f g x y z
% % % % % Temperature Formula 3b % % % % %
theta_3b=0;
for n=0:25
t=0;
beta6 = (n*pi)/H;
eta6 = (((2*pi)/L)*(n+0.5));
mew6 = -1036;
lamda6 = (beta6.^2)+(eta6.^2)+(mew6.^2);
f(x,y,z) = sin(beta6*z).*cos(eta6*x).*sin(mew6*y).*cos(mew6*y);
C_nmp_numerator6 = int(int(int(f,z,[0 H]),y,[0 W]),x,[0 (L/2)]);
g(x,y,z) = ((cos(mew6*y)^2).*sin(mew6*y) – ((h/(k*mew6)).*(sin(mew6*y)^2).*cos(mew6*y)));
C_nmp_denominator6 = ((L*H)/8)* (int(g,y,[0 W]));
C_nmp6 = C_nmp_numerator6/C_nmp_denominator6;
theta_3b = theta_3b+(C_nmp6*(sin(beta6*z)*cos(eta6*x)*((cos(mew6*y)-(h/(k*mew6))*sin(mew6*y)))*exp(-(lamda6^2)*alpha*t)));
end
theta_3b = vpa(subs(theta_3b, {x,y,z}, {X,Y,Z})) vpa MATLAB Answers — New Questions
Convert string to 256 Characters
How to create the Matlab source text which will be equivalent to this Fortran text? The character variable must be 256 characterts long
Character*256 TEXT
TEXT = ‘Unformatted Data Version=’
Print*, TEXT
END
Thanks!How to create the Matlab source text which will be equivalent to this Fortran text? The character variable must be 256 characterts long
Character*256 TEXT
TEXT = ‘Unformatted Data Version=’
Print*, TEXT
END
Thanks! How to create the Matlab source text which will be equivalent to this Fortran text? The character variable must be 256 characterts long
Character*256 TEXT
TEXT = ‘Unformatted Data Version=’
Print*, TEXT
END
Thanks! 256 characters, string, fortran MATLAB Answers — New Questions
Conditional format cells based on overbooking of slot for a resource
Hi,
I am trying to highlight resource in column A starting cell A2. Here I will list resources and many will come more than once. This resource shall be shown as booking in time slots starting column B2. Such slots can be many (~300). Booking is shown by marking a x in corresponding cell.
If a resource comes more than once, and it has same slot more than once, then this resouce needs to be highlighted.
Example data is below:
ResourceSlot-1Slot-2Slot-3Slot-4Slot-5Slot-6Slot-7Slot-8Slot-9Slot-10Slot-11Slot-12Slot-13M-1xx M-2 xx M-2 xx M-3 xxxxx M-4 x M-3xx M-4 xxx xx
In this case, resource M-3 cell will be highlighted.
So conditional formatting shall be in Column A.
Pls help with suitable formula,
Hi, I am trying to highlight resource in column A starting cell A2. Here I will list resources and many will come more than once. This resource shall be shown as booking in time slots starting column B2. Such slots can be many (~300). Booking is shown by marking a x in corresponding cell.If a resource comes more than once, and it has same slot more than once, then this resouce needs to be highlighted.Example data is below:ResourceSlot-1Slot-2Slot-3Slot-4Slot-5Slot-6Slot-7Slot-8Slot-9Slot-10Slot-11Slot-12Slot-13M-1xx M-2 xx M-2 xx M-3 xxxxx M-4 x M-3xx M-4 xxx xx In this case, resource M-3 cell will be highlighted.So conditional formatting shall be in Column A.Pls help with suitable formula, Read More
Appointments from Mac calendars are shown as free
Appointments from iPhone/Mac calendars are shown as free in Bookings. It does not matter whether I add the Mac calendar as a separate account in Outlook or just import it. How can I see both my Google calendar and my Mac calendar in Booking?
Appointments from iPhone/Mac calendars are shown as free in Bookings. It does not matter whether I add the Mac calendar as a separate account in Outlook or just import it. How can I see both my Google calendar and my Mac calendar in Booking? Read More
Conditional Format calculated across relative references, applied to an absolute reference
Hi there 😊 I would like to place some conditional formatting on some helper text to highlight it when a user has made an error. I have created a dummy file to replicate what I am trying to do – a combination of “Bargain” selected in column D / [Price] and “High” in column F / [Demand] should trigger the rule and format cell H2. I’ve tried a bunch of different approaches but have only been successful in getting the formatting to respond to combinations in a single row rather than all rows. I’m sure that this will get solved quickly but it’s been doing my head in! Looking forward to your advice – thanks in advance 🤗
UPDATE: I’ve at least been able to get a formula to output “TRUE” to a single cell… but I can’t get it to work as a conditional formatting formula and would like to avoid using a helper cell if I can. The following formula works if I place it in a helper cell that I specify the conditional formula to check: =IF(FILTER(Table1[Type],(Table1[Price]=”Bargain”)*(Table1[Demand]=”High”),””)<>””,”TRUE”)
Hi there 😊 I would like to place some conditional formatting on some helper text to highlight it when a user has made an error. I have created a dummy file to replicate what I am trying to do – a combination of “Bargain” selected in column D / [Price] and “High” in column F / [Demand] should trigger the rule and format cell H2. I’ve tried a bunch of different approaches but have only been successful in getting the formatting to respond to combinations in a single row rather than all rows. I’m sure that this will get solved quickly but it’s been doing my head in! Looking forward to your advice – thanks in advance 🤗 UPDATE: I’ve at least been able to get a formula to output “TRUE” to a single cell… but I can’t get it to work as a conditional formatting formula and would like to avoid using a helper cell if I can. The following formula works if I place it in a helper cell that I specify the conditional formula to check: =IF(FILTER(Table1[Type],(Table1[Price]=”Bargain”)*(Table1[Demand]=”High”),””)<>””,”TRUE”) Read More
System.UnauthorizedAccessException: Access to the Path is Denied During Azure Pipeline Execution
Hello,
I’m experiencing an issue with our Azure DevOps pipeline running on a self-hosted agent. During the initial execution, the pipeline fails with the following error message:
System.UnauthorizedAccessException: Access to the path ‘D:pathtofile.dll’ is denied.
The error occurs during built-in tasks like Initialize Job and Checkout. However, when I retrigger the pipeline, it passes successfully.
Details:
When the error occurs, the DLL file mentioned in the error is locked, and attempting to delete it manually results in a prompt indicating that the DLL is in use by another process.To mitigate this, I created a PowerShell script that restarts explorer.exe every 5 minutes. This allows the pipeline to pass on retriggering.The issue persists during the initial run of the pipeline, which is causing disruptions.
Questions:
Why does this error only occur during the first execution of the pipeline, and why is it resolved upon retriggering?Could this be related to file lock management by the self-hosted agent, or interference from explorer.exe or other processes?What would be the best approach to avoid this issue altogether, without having to rely on restarting explorer.exe?
Any guidance or recommendations to resolve this issue would be greatly appreciated.
Environment Details:
Agent Type: Self-hostedOS: windows
Hello,I’m experiencing an issue with our Azure DevOps pipeline running on a self-hosted agent. During the initial execution, the pipeline fails with the following error message:System.UnauthorizedAccessException: Access to the path ‘D:pathtofile.dll’ is denied.The error occurs during built-in tasks like Initialize Job and Checkout. However, when I retrigger the pipeline, it passes successfully.Details:When the error occurs, the DLL file mentioned in the error is locked, and attempting to delete it manually results in a prompt indicating that the DLL is in use by another process.To mitigate this, I created a PowerShell script that restarts explorer.exe every 5 minutes. This allows the pipeline to pass on retriggering.The issue persists during the initial run of the pipeline, which is causing disruptions.Questions:Why does this error only occur during the first execution of the pipeline, and why is it resolved upon retriggering?Could this be related to file lock management by the self-hosted agent, or interference from explorer.exe or other processes?What would be the best approach to avoid this issue altogether, without having to rely on restarting explorer.exe?Any guidance or recommendations to resolve this issue would be greatly appreciated.Environment Details:Agent Type: Self-hostedOS: windows Read More
How get Refinitiv/Microsoft to refresh/update stock list ?
Hello,
I have shares of 2 companies, which are not found in the Stock Data types. These are fairly new shares, which listed about 2-3 weeks ago. How do I get about requesting Microsoft to update/refresh the list of shares ? The data comes from Refinitiv. So looks like an issue at their end.
I have given feedback from excel to MS multiple times, but nothing has happened.
This had happened once last year as well. However after a few days that share got added.
Thanks.
Hello, I have shares of 2 companies, which are not found in the Stock Data types. These are fairly new shares, which listed about 2-3 weeks ago. How do I get about requesting Microsoft to update/refresh the list of shares ? The data comes from Refinitiv. So looks like an issue at their end. I have given feedback from excel to MS multiple times, but nothing has happened. This had happened once last year as well. However after a few days that share got added. Thanks. Read More
Clarity on Entra ID licensing
Hi,
We purchased 2 Microsoft Entra ID Governance licenses and applied one to an account with global administrator (GA) role. However, when I log in to the Azure portal with the GA account and navigate to the Microsoft Entra ID section, the license is showing as “Microsoft Entra ID Free.” Additionally, the conditional access policies are greyed out, with a message stating: “Create your own policies and target specific conditions like cloud apps, sign-in risk, and device platforms with Microsoft Entra ID Premium.”
Why isn’t the Entra ID Governance license applied to the GA account taking effect? Am I missing something? Could someone please shed some light on this?
Thanks,
James
Hi, We purchased 2 Microsoft Entra ID Governance licenses and applied one to an account with global administrator (GA) role. However, when I log in to the Azure portal with the GA account and navigate to the Microsoft Entra ID section, the license is showing as “Microsoft Entra ID Free.” Additionally, the conditional access policies are greyed out, with a message stating: “Create your own policies and target specific conditions like cloud apps, sign-in risk, and device platforms with Microsoft Entra ID Premium.” Why isn’t the Entra ID Governance license applied to the GA account taking effect? Am I missing something? Could someone please shed some light on this?Thanks,James Read More
How to take negative of the neural network function for maximization?
I have created a neural network in matlab using the nntool and now I using the trained neural network as a fitness function for my genetic algorithm to maximize the output of my function given 3 input variables. Optimization in matlab is by default used for minimization but as i want to maximize my function i understand that I need to take negative of the function but I am not able to take a negative of the neural network function as we do for normal functions.I have created a neural network in matlab using the nntool and now I using the trained neural network as a fitness function for my genetic algorithm to maximize the output of my function given 3 input variables. Optimization in matlab is by default used for minimization but as i want to maximize my function i understand that I need to take negative of the function but I am not able to take a negative of the neural network function as we do for normal functions. I have created a neural network in matlab using the nntool and now I using the trained neural network as a fitness function for my genetic algorithm to maximize the output of my function given 3 input variables. Optimization in matlab is by default used for minimization but as i want to maximize my function i understand that I need to take negative of the function but I am not able to take a negative of the neural network function as we do for normal functions. genetic algorithm, neural network, optimization, functions, ga, matlab MATLAB Answers — New Questions
Applying weighted regression for Parameter estimation in Simulink
Hello everybody,
I am dealing with parameter estimation in Simulink with 3 measured outputs (y1, y2, y3) that have different weights on my model. It is not rational to simply introduce all the outputs with similar impact on the fitting process. How may I use a weighted objective function in the parameter estimation process in Simulink?
I appreciate any other recommendation to have relaible parameter estimation process.
Thanks in advance.
Kourosh.Hello everybody,
I am dealing with parameter estimation in Simulink with 3 measured outputs (y1, y2, y3) that have different weights on my model. It is not rational to simply introduce all the outputs with similar impact on the fitting process. How may I use a weighted objective function in the parameter estimation process in Simulink?
I appreciate any other recommendation to have relaible parameter estimation process.
Thanks in advance.
Kourosh. Hello everybody,
I am dealing with parameter estimation in Simulink with 3 measured outputs (y1, y2, y3) that have different weights on my model. It is not rational to simply introduce all the outputs with similar impact on the fitting process. How may I use a weighted objective function in the parameter estimation process in Simulink?
I appreciate any other recommendation to have relaible parameter estimation process.
Thanks in advance.
Kourosh. weighted regression, parameter estimation MATLAB Answers — New Questions
