Month: September 2024
Compare char data in a cell {‘x’} to a character ‘x’
I want to find what’s in my table that’s in a category column 1
If you read through you will see what I tries and how I finally figured it out. I’m posing the question because I can’t be the only person that wanted to do this simple (but not clearly and simply documented)
Starting with a text file:
HEADER that is ignored
R 0 5
L 5 0
Set up how I want the table (not that MATLAB will pay any attention)
app.StimInputTable.Data = table(‘Size’,[4 3],…
‘VariableTypes’,{‘categorical’,’uint8′,’uint8′});
What did I get? Got what I asked for
K>> class (app.StimInputTable.Data.Var1)
ans =
‘categorical’
K>> class (app.StimInputTable.Data.Var2)
ans =
‘uint8’
K>> class (app.StimInputTable.Data.Var3)
ans =
‘uint8’
Read in the file
app.StimInputTable.Data = readtable(infile);
MATLAB changes all the types
K>> class (app.StimInputTable.Data.Var1)
ans =
‘cell’
K>> class (app.StimInputTable.Data.Var2)
ans =
‘double’
K>> class (app.StimInputTable.Data.Var3)
ans =
‘double’
I can redo the .. table(… VariableTypes), but then it tosses all my category data instead of converting
So here’s my table, I can deal with the cells
K>> app.StimInputTable.Data
ans =
2×3 table
Var1 Var2 Var3
_____ ____ ____
{‘L’} 5 0
{‘R’} 0 5
So the char is considered a cell, ok I’ve seen a warning about how chars (or char vectors) get put into cells, but my users are not going to type "R" 5 0 etc these files already exist.
K>> app.StimInputTable.Data(jj,1)
ans =
table
Var1
{‘L’}
Try to pull it out and I get another table, not the cell
OK so I pull it this way
K>> app.StimInputTable.Data{jj,1}
ans =
1×1 cell array
{‘L’}
Now I have a more simple 1×1 cell array, now to the character out of the cell or compare cell to cell
How about I compare it to a cell with the char in it
K>> {‘L’}
ans =
1×1 cell array
{‘L’}
That looks good, same types, lets try it
K>> app.StimInputTable.Data{jj,1} == {‘L’}
Operator ‘==’ is not supported for operands of type ‘cell’.
So that didn’t work, so I’ll try
K>> cl = app.StimInputTable.Data{jj,1}
cl =
1×1 cell array
{‘L’}
Get the char out of the cell
K>> cl{1,1}
ans =
‘L’
K>> cl{1,1}== ‘L’
ans =
logical
1
Finally!
cl = app.StimInputTable.Data{jj,1}
if cl{1,1}== ‘L’
…
end
Is this really what I have to do? It took way too long to figure out. I never could find Help on how to extract the single cell of data out of a table. I have R and L as catagories when I use them later but can’t read them in as such initing the table size and variabletypes gets ignored by the read()
Wait a moment
app.StimInputTable.Data{j,1} % This gives a cell as above, but
app.StimInputTable.Data.Var1{j} % is going to work? Where is that documented?
ans =
‘L’
So now
if app.StimInputTable.Data.Var1{j} == ‘L’
Apparently using .Var1{i} is not the same as indexing with {j}
This works but where will you find it documented? Good luckI want to find what’s in my table that’s in a category column 1
If you read through you will see what I tries and how I finally figured it out. I’m posing the question because I can’t be the only person that wanted to do this simple (but not clearly and simply documented)
Starting with a text file:
HEADER that is ignored
R 0 5
L 5 0
Set up how I want the table (not that MATLAB will pay any attention)
app.StimInputTable.Data = table(‘Size’,[4 3],…
‘VariableTypes’,{‘categorical’,’uint8′,’uint8′});
What did I get? Got what I asked for
K>> class (app.StimInputTable.Data.Var1)
ans =
‘categorical’
K>> class (app.StimInputTable.Data.Var2)
ans =
‘uint8’
K>> class (app.StimInputTable.Data.Var3)
ans =
‘uint8’
Read in the file
app.StimInputTable.Data = readtable(infile);
MATLAB changes all the types
K>> class (app.StimInputTable.Data.Var1)
ans =
‘cell’
K>> class (app.StimInputTable.Data.Var2)
ans =
‘double’
K>> class (app.StimInputTable.Data.Var3)
ans =
‘double’
I can redo the .. table(… VariableTypes), but then it tosses all my category data instead of converting
So here’s my table, I can deal with the cells
K>> app.StimInputTable.Data
ans =
2×3 table
Var1 Var2 Var3
_____ ____ ____
{‘L’} 5 0
{‘R’} 0 5
So the char is considered a cell, ok I’ve seen a warning about how chars (or char vectors) get put into cells, but my users are not going to type "R" 5 0 etc these files already exist.
K>> app.StimInputTable.Data(jj,1)
ans =
table
Var1
{‘L’}
Try to pull it out and I get another table, not the cell
OK so I pull it this way
K>> app.StimInputTable.Data{jj,1}
ans =
1×1 cell array
{‘L’}
Now I have a more simple 1×1 cell array, now to the character out of the cell or compare cell to cell
How about I compare it to a cell with the char in it
K>> {‘L’}
ans =
1×1 cell array
{‘L’}
That looks good, same types, lets try it
K>> app.StimInputTable.Data{jj,1} == {‘L’}
Operator ‘==’ is not supported for operands of type ‘cell’.
So that didn’t work, so I’ll try
K>> cl = app.StimInputTable.Data{jj,1}
cl =
1×1 cell array
{‘L’}
Get the char out of the cell
K>> cl{1,1}
ans =
‘L’
K>> cl{1,1}== ‘L’
ans =
logical
1
Finally!
cl = app.StimInputTable.Data{jj,1}
if cl{1,1}== ‘L’
…
end
Is this really what I have to do? It took way too long to figure out. I never could find Help on how to extract the single cell of data out of a table. I have R and L as catagories when I use them later but can’t read them in as such initing the table size and variabletypes gets ignored by the read()
Wait a moment
app.StimInputTable.Data{j,1} % This gives a cell as above, but
app.StimInputTable.Data.Var1{j} % is going to work? Where is that documented?
ans =
‘L’
So now
if app.StimInputTable.Data.Var1{j} == ‘L’
Apparently using .Var1{i} is not the same as indexing with {j}
This works but where will you find it documented? Good luck I want to find what’s in my table that’s in a category column 1
If you read through you will see what I tries and how I finally figured it out. I’m posing the question because I can’t be the only person that wanted to do this simple (but not clearly and simply documented)
Starting with a text file:
HEADER that is ignored
R 0 5
L 5 0
Set up how I want the table (not that MATLAB will pay any attention)
app.StimInputTable.Data = table(‘Size’,[4 3],…
‘VariableTypes’,{‘categorical’,’uint8′,’uint8′});
What did I get? Got what I asked for
K>> class (app.StimInputTable.Data.Var1)
ans =
‘categorical’
K>> class (app.StimInputTable.Data.Var2)
ans =
‘uint8’
K>> class (app.StimInputTable.Data.Var3)
ans =
‘uint8’
Read in the file
app.StimInputTable.Data = readtable(infile);
MATLAB changes all the types
K>> class (app.StimInputTable.Data.Var1)
ans =
‘cell’
K>> class (app.StimInputTable.Data.Var2)
ans =
‘double’
K>> class (app.StimInputTable.Data.Var3)
ans =
‘double’
I can redo the .. table(… VariableTypes), but then it tosses all my category data instead of converting
So here’s my table, I can deal with the cells
K>> app.StimInputTable.Data
ans =
2×3 table
Var1 Var2 Var3
_____ ____ ____
{‘L’} 5 0
{‘R’} 0 5
So the char is considered a cell, ok I’ve seen a warning about how chars (or char vectors) get put into cells, but my users are not going to type "R" 5 0 etc these files already exist.
K>> app.StimInputTable.Data(jj,1)
ans =
table
Var1
{‘L’}
Try to pull it out and I get another table, not the cell
OK so I pull it this way
K>> app.StimInputTable.Data{jj,1}
ans =
1×1 cell array
{‘L’}
Now I have a more simple 1×1 cell array, now to the character out of the cell or compare cell to cell
How about I compare it to a cell with the char in it
K>> {‘L’}
ans =
1×1 cell array
{‘L’}
That looks good, same types, lets try it
K>> app.StimInputTable.Data{jj,1} == {‘L’}
Operator ‘==’ is not supported for operands of type ‘cell’.
So that didn’t work, so I’ll try
K>> cl = app.StimInputTable.Data{jj,1}
cl =
1×1 cell array
{‘L’}
Get the char out of the cell
K>> cl{1,1}
ans =
‘L’
K>> cl{1,1}== ‘L’
ans =
logical
1
Finally!
cl = app.StimInputTable.Data{jj,1}
if cl{1,1}== ‘L’
…
end
Is this really what I have to do? It took way too long to figure out. I never could find Help on how to extract the single cell of data out of a table. I have R and L as catagories when I use them later but can’t read them in as such initing the table size and variabletypes gets ignored by the read()
Wait a moment
app.StimInputTable.Data{j,1} % This gives a cell as above, but
app.StimInputTable.Data.Var1{j} % is going to work? Where is that documented?
ans =
‘L’
So now
if app.StimInputTable.Data.Var1{j} == ‘L’
Apparently using .Var1{i} is not the same as indexing with {j}
This works but where will you find it documented? Good luck get data in a cell MATLAB Answers — New Questions
How to model marine exhaust system using Simscape.
I want to create a simulation for marine exhaust systems for large vessels but I’m not sure how to set everything up.
I have values for temperature (from turbo), ambient temp (engine compartment), k values, h values, various exhaust pipe diameters, lengths, and thermal properties (stainless steel, aluminum, etc.).
Sections of the exhaust use a multilayer multi product insulation. I know the diameters at each layer, h and k values of the different layers, and thermal resistances of the layers.
Eventually, I want to include where the exhaust gas mixes with sea water in a mixing chamber.
My end goal is to create a model that can find the surface temperature, the internal temperature, and the internal pressure at any location of the exhaust system.
Can someone help with creating a basic model to start with?I want to create a simulation for marine exhaust systems for large vessels but I’m not sure how to set everything up.
I have values for temperature (from turbo), ambient temp (engine compartment), k values, h values, various exhaust pipe diameters, lengths, and thermal properties (stainless steel, aluminum, etc.).
Sections of the exhaust use a multilayer multi product insulation. I know the diameters at each layer, h and k values of the different layers, and thermal resistances of the layers.
Eventually, I want to include where the exhaust gas mixes with sea water in a mixing chamber.
My end goal is to create a model that can find the surface temperature, the internal temperature, and the internal pressure at any location of the exhaust system.
Can someone help with creating a basic model to start with? I want to create a simulation for marine exhaust systems for large vessels but I’m not sure how to set everything up.
I have values for temperature (from turbo), ambient temp (engine compartment), k values, h values, various exhaust pipe diameters, lengths, and thermal properties (stainless steel, aluminum, etc.).
Sections of the exhaust use a multilayer multi product insulation. I know the diameters at each layer, h and k values of the different layers, and thermal resistances of the layers.
Eventually, I want to include where the exhaust gas mixes with sea water in a mixing chamber.
My end goal is to create a model that can find the surface temperature, the internal temperature, and the internal pressure at any location of the exhaust system.
Can someone help with creating a basic model to start with? simscape, simulink, thermal fluids MATLAB Answers — New Questions
KQL Queries
Hi team,
Please help me write a KQL query which reflects the devices which are missing windows security patches, the condition i want to apply here is, i need the device’s sensor health=”Active” and Onboarding status=”Onboarded”.
right now i am using ”
“
Please help me out!
Thanks in advance! 🙂
Hi team,Please help me write a KQL query which reflects the devices which are missing windows security patches, the condition i want to apply here is, i need the device’s sensor health=”Active” and Onboarding status=”Onboarded”.right now i am using ” DeviceTvmSoftwareVulnerabilities | where RecommendedSecurityUpdate endswith “August 2024 security updates”| where DeviceName contains “xyz”| summarize by DeviceId, DeviceName, RecommendedSecurityUpdate, OSPlatform”Please help me out!Thanks in advance! 🙂 Read More
Force Excel to Open in Desktop and Limit to One User
Good day,
New to Sharepoint and looking for some insight…
I have a macro enabled workbook saved on a SharePoint site that will be available to multiple users. So far it seems that macros won’t work in the Excel web version which is good, but I also want to ensure that multiple people cannot open the file, edit it and save it simultaneously. I need to ensure that the file is only edited in the Desktop version of Excel. I have found “Check in” & Check out” under versioning but it seems to me that if someone forgets to check the file back in it will be come a huge issue.
I am ok if the file opens as Read Only for all users except the first user that is editing the file and did try it but there was no warning that another user was on the file. When I tried to save it, I was told it was a Read Only file but there was no initial warning. It seems like what I am asking may already be functioning but I don’t want a subsequent user working on the file for an hour only to be told it was Read Only and they can’t save their work.
Hope what I am asking/raising makes sense and would appreciate some guidance.
Thanks
Good day, New to Sharepoint and looking for some insight… I have a macro enabled workbook saved on a SharePoint site that will be available to multiple users. So far it seems that macros won’t work in the Excel web version which is good, but I also want to ensure that multiple people cannot open the file, edit it and save it simultaneously. I need to ensure that the file is only edited in the Desktop version of Excel. I have found “Check in” & Check out” under versioning but it seems to me that if someone forgets to check the file back in it will be come a huge issue. I am ok if the file opens as Read Only for all users except the first user that is editing the file and did try it but there was no warning that another user was on the file. When I tried to save it, I was told it was a Read Only file but there was no initial warning. It seems like what I am asking may already be functioning but I don’t want a subsequent user working on the file for an hour only to be told it was Read Only and they can’t save their work. Hope what I am asking/raising makes sense and would appreciate some guidance. Thanks Read More
Looking for Participants: ISV Partner Center Journey Study
Hello everyone!
I’m a UX researcher on the Commerce + Ecosystem team at Microsoft, and I’m excited to connect with ISV partners in this community. We’re working to improve the Partner Center experience, and your feedback could play a key role in shaping future updates.
I’m inviting you to participate in a 1:1, 60-minute research interview via Microsoft Teams. During this session, we’ll discuss your daily tasks and interactions with Partner Center, helping us better understand your needs and challenges.
If you’re interested, please take a moment to fill out this brief form: [https://forms.office.com/r/uXTCeFph2M].
Your input would be incredibly valuable, and I hope to hear from you soon!
Thank you!
Hello everyone!
I’m a UX researcher on the Commerce + Ecosystem team at Microsoft, and I’m excited to connect with ISV partners in this community. We’re working to improve the Partner Center experience, and your feedback could play a key role in shaping future updates.
I’m inviting you to participate in a 1:1, 60-minute research interview via Microsoft Teams. During this session, we’ll discuss your daily tasks and interactions with Partner Center, helping us better understand your needs and challenges.
If you’re interested, please take a moment to fill out this brief form: [https://forms.office.com/r/uXTCeFph2M].
Your input would be incredibly valuable, and I hope to hear from you soon!
Thank you! Read More
Dynamic Data masking in Azure PostgreSQL – Flexible Server for migrated Oracle workloads
Introduction
Dynamic data masking is essential when sensitive information, such as PII, needs to be protected while sharing data with third parties or during the transfer of data from production to lower environments. By replacing confidential data with fictitious or altered data, this technique ensures that developers, vendors, or external partners cannot access real PII, enhancing security and privacy.
This document offers guidelines for customers transitioning from Oracle to Azure PostgreSQL – Flexible Server who wish to mask their PII or PCI data in their lower environments. It details how to enable dynamic masking for a user or role in .
Enable the Server Level Parameters
To enable the server level parameter, navigate the azure portal left panel and search for ‘Server Parameters’ under settings section.
Search for “azure. Extensions” and in the value section click the checkbox for PGCRYPTO and ANON and select SAVE.
Once the above is completed search for “shared_preload_libraries” and in the value section click the checkbox for ANON and then click SAVE.
The above step would prompt the restart of the server.
Enable Dynamic Data masking
Once the server is restarted login the database either by using PgAdmin or through psql.
Here is an example that how to enable the Dynamic Masking:
Create a table.CREATE TABLE people_new ( id TEXT, firstname TEXT, lastname TEXT, phone TEXT);
Insert some new records.INSERT INTO people_new VALUES (‘E1’,David, ‘Miller’,’0609110911′);
INSERT INTO people_new VALUES (‘E2′,’Robert’, ‘Bruce’,’0708910911′);
SELECT * FROM people_new;
Issue the following statement to initialize the dynamic maskingSELECT anon.start_dynamic_masking();
Create a user/role for the masked userCREATE USER masked_user WITH PASSWORD ‘masked_user’;
Assign the anon masking for the user/roleSECURITY LABEL FOR anon on ROLE masked_user IS ‘MASKED’;
Create the dynamic masking for the phone column in the table people_newSECURITY LABEL FOR anon ON COLUMN people_new.phone IS ‘MASKED WITH FUNCTION anon.partial(phone,2,$$*****$$,2)’;
Grant all the permission for the table people_new to ‘masked_user’GRANT ALL ON TABLE people_new to masked_user;
Run the select command as POSTGRES user and you could see the following results with no masking in phone column
10. Login as ‘masked_user’ and execute SELECT * FROM people_new; you could find the following result as phone column is masked.
Disable Dynamic Masking
In order to disable the dynamic masking, use the following steps.
Issue the stop dynamic masking command as POSTGRES user.
SELECT anon.stop_dynamic_masking();
2. Login as ‘masked_user’ and check the values for people_new table
SELECT * FROM people_new;
You can see now the columns are unmasked.
3. To remove the roles assigned and the masked function, issue the following command.
SELECT anon.remove_masks_for_all_roles();
This would completely remove the functions created and the role assigned to the user ‘masked_user’
Feedback and suggestions
If you have feedback or suggestions for improving this data migration asset, please send an email to Database Platform Engineering Team.
Microsoft Tech Community – Latest Blogs –Read More
Keylogging malware protection built into Windows
Devices running Windows 11 and Windows 10 have built-in protection against malware and malicious software with Microsoft Defender Antivirus. Microsoft Defender Antivirus can detect and block keyloggers, screen scrapers, and other types of malware threats that can track, steal, or damage data on devices.
What is keylogger malware and screen scraper malware?
Keyloggers, also known as keystroke loggers, can record keystrokes, screenshots, and clipboard data. While screen scrapers are malicious programs that surreptitiously take screenshots and/or record videos of what is on your device’s screen, this kind of malware capability can exist independently without keylogging abilities. In both cases, stolen data is sent to an attacker over the network.
What is Microsoft Defender Antivirus and what does it do?
Microsoft Defender Antivirus comes with all versions of Windows 11 and Windows 10, and it is the next-generation protection component of Microsoft Defender for Endpoint, which offers additional capabilities such as endpoint detection and response and automated investigation and remediation. Microsoft Defender Antivirus uses machine learning, artificial intelligence, and the cloud-based Microsoft Intelligent Security Graph to block malware at first sight and in milliseconds. It also analyzes the behaviors and process trees of threats and can stop fileless malware and human-operated attacks.
How does protection work?
Let’s dive into more details about how we help prevent malware keyloggers from getting on the system in the first place. Protection from malware, which is turned on by default in Windows 11 and Windows 10, starts the moment you power on your device. Windows uses Secure Boot, Trusted Boot, and Measured Boot to verify the firmware, bootloader, kernel, drivers, and anti-malware software before loading them. These technologies help prevent malware from tampering with the boot sequence and compromising the device before Microsoft Defender Antivirus software starts up.
Once started, Microsoft Defender Antivirus takes advantage of multiple detection engines to block malware at first sight. The behavioral blocking and containment in Microsoft Defender for Endpoint can identify fileless malware and stop threats, even after threats start executing.
What if Microsoft Defender Antivirus isn’t used?
Users can consider enhancing security on unmanaged personal devices with Copilot+ PCs, which, as Secured-core PCs, bring advanced security to commercial and consumer devices. Secured-core PCs have hardware-backed security features enabled by default without any action required by the user, as well as Microsoft Security Baseline (a group of settings implemented by Microsoft based on security experts’ feedback). In addition to the layers of protection in Windows 11, Secured-core PCs provide advanced firmware safeguards and dynamic root-of-trust for measurement to help provide protection from chip to cloud. Learn more about the new Windows 11 security features.
What if malware is not detected and it tries to disable Microsoft Defender Antivirus?
Tamper protection, which is included in Windows 11 and Windows 10 and is on by default, safeguards some security settings—such as virus and threat protection—from being turned off or modified by malware, which helps protect against keyloggers.
What if a user who has admin rights on their machine turns off real-time scanning?
Microsoft Defender SmartScreen can block malware downloads before they get on the system even if Microsoft Defender Antivirus real-time scanning is turned off. Additional detection engines from Microsoft Defender for Endpoint can still find keyloggers.
How do I know there is keylogger protection when I’ve never seen a detection?
To show how Microsoft Defender for Endpoint detections and blocks, below we provide three keylogging examples in which two Windows 11 and Windows 10 built-in protections are disabled. These protections are:
Microsoft Defender Antivirus, which scans for malware on disk and in memory.
Microsoft Defender Smartscreen, which helps block malware downloads, including downloads by third-party browsers and email clients.
In the examples below, the screenshots show three different keyloggers being detected by Microsoft Defender for Endpoint.
Keylogger example 1
In addition to keylogging, this keylogger performed some exploration activities, also referred to as recon activities. Both activity types were detected.
Keylogger example 2
In this example, a keylogger spawned other files. Microsoft Defender for Endpoint was able to detect suspicious behavior.
Keylogger example 3
Here, the keylogger was prevented from running the first time. Even when the keylogger was explicitly allowed to run via the end user (with admin rights) approving the execution, the keylogger was unable to capture keystrokes and screenshots due to other prevention mechanisms.
The image below shows the detection of the three keyloggers we tested above. Although real-time protection was disabled earlier, Microsoft Defender Antivirus is shown as a detection source because enhanced detection and response (EDR) in Microsoft Defender for Endpoint can request that Microsoft Defender Antivirus scan files. Learn more at Endpoint detection and response in block mode.
Built-in protection in Windows 11 and Windows 10 helps protect against malware keyloggers by preventing them from getting into the system and running. For even better protection, consider using Microsoft Defender for Endpoint also. When both the built-in protection and Microsoft Defender for Endpoint are used together, you get better protection that’s coordinated across Microsoft products and services.
For more information, download the Windows 11 security guide PDF and see 13 reasons to use Microsoft Defender Antivirus with Microsoft Defender for Endpoint.
Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.
Microsoft Tech Community – Latest Blogs –Read More
Need help with validation formula for document list in Sharepoint list
I am trying to apply validation to document title column, we replacing spaces in title with dashes manually, Validation should fail if it cant find dash in title column, but only want to apply it to new items and not to existing items. So Title needs to contain “-” if thats true all good no need to check created date, But if dash is not found it should check wheter the Document [Created] date is less than today, if its less than today then all good, but if created date is equal to today then validation should fail.
This is the formula i have tried so far but it doesnt seem to work
=IF(FIND(“-“,Title),TRUE,IF(Created<TODAY(),TRUE,FALSE))
I am trying to apply validation to document title column, we replacing spaces in title with dashes manually, Validation should fail if it cant find dash in title column, but only want to apply it to new items and not to existing items. So Title needs to contain “-” if thats true all good no need to check created date, But if dash is not found it should check wheter the Document [Created] date is less than today, if its less than today then all good, but if created date is equal to today then validation should fail. This is the formula i have tried so far but it doesnt seem to work =IF(FIND(“-“,Title),TRUE,IF(Created<TODAY(),TRUE,FALSE)) Read More
Changing my OS reduced maximum number of threads for parallel processing
I recently changed my OS system from Fedora to Ubuntu 24.04. On Fedora I could setup a thread-based parallel pool with 10 threads no problem (parpool(‘threads’, 10). When I try doing the same thing in Ubuntu, I get the following error:
‘A minimum pool size of 10 was requested. The maximum thread-based pool size is currently 2.’
I’ve tried a couple of things with no luck
maxNumCompThreads(10)
I checked nproc to make sure that Ubuntu recognizes all the CPU’s – it does
reinstalled the parallel computing toolbox
Varying the settings in cluster profile manager
Is there anything else I could try?I recently changed my OS system from Fedora to Ubuntu 24.04. On Fedora I could setup a thread-based parallel pool with 10 threads no problem (parpool(‘threads’, 10). When I try doing the same thing in Ubuntu, I get the following error:
‘A minimum pool size of 10 was requested. The maximum thread-based pool size is currently 2.’
I’ve tried a couple of things with no luck
maxNumCompThreads(10)
I checked nproc to make sure that Ubuntu recognizes all the CPU’s – it does
reinstalled the parallel computing toolbox
Varying the settings in cluster profile manager
Is there anything else I could try? I recently changed my OS system from Fedora to Ubuntu 24.04. On Fedora I could setup a thread-based parallel pool with 10 threads no problem (parpool(‘threads’, 10). When I try doing the same thing in Ubuntu, I get the following error:
‘A minimum pool size of 10 was requested. The maximum thread-based pool size is currently 2.’
I’ve tried a couple of things with no luck
maxNumCompThreads(10)
I checked nproc to make sure that Ubuntu recognizes all the CPU’s – it does
reinstalled the parallel computing toolbox
Varying the settings in cluster profile manager
Is there anything else I could try? parallel computing, ubuntu, parfor, linux MATLAB Answers — New Questions
Number of bits per symbol (m) range in Reed-Solomon coding
I’m playing around with Reed-Solomon codes. In the parameters of rsenc, help shows m represents the "number of bits per symbol" and has the range of "3 to 16".
The way I understood on m is that it has minimum three bits per symbol, i.e., 000, 001, 010, …, 111. Am I correct? What if I need to use two bits or one bit per symbol? What am I supposed to do if I want to construct a message with length of 20 (as an example) and each symbol has bit (i.e., 0 or 1)?I’m playing around with Reed-Solomon codes. In the parameters of rsenc, help shows m represents the "number of bits per symbol" and has the range of "3 to 16".
The way I understood on m is that it has minimum three bits per symbol, i.e., 000, 001, 010, …, 111. Am I correct? What if I need to use two bits or one bit per symbol? What am I supposed to do if I want to construct a message with length of 20 (as an example) and each symbol has bit (i.e., 0 or 1)? I’m playing around with Reed-Solomon codes. In the parameters of rsenc, help shows m represents the "number of bits per symbol" and has the range of "3 to 16".
The way I understood on m is that it has minimum three bits per symbol, i.e., 000, 001, 010, …, 111. Am I correct? What if I need to use two bits or one bit per symbol? What am I supposed to do if I want to construct a message with length of 20 (as an example) and each symbol has bit (i.e., 0 or 1)? rsenc, reed-solomon MATLAB Answers — New Questions
Fill below the 3D terrain data
A=imread(‘appRasterNEDAPIService1708354512850-756880040.tif’);
X=1:324;
Y=1:194;
[X,Y]=meshgrid(X,Y);
surf(X,Y,A)
Hello. I have this terrain data. The size of A matrix is 194×324 and contain elevation data. I want to fill below the terrain from the elevation of the data to the 0 (mean sea level). I use fill code
hFill = fill3(X, Y, A, patchColor, ‘LineWidth’, 1, ‘EdgeColor’, patchColor, …
‘FaceAlpha’, 0.5);
However, it only fill below the surface with thin layer. I try to fill from the elevation to the 0 (mean sea level).
Thank you,A=imread(‘appRasterNEDAPIService1708354512850-756880040.tif’);
X=1:324;
Y=1:194;
[X,Y]=meshgrid(X,Y);
surf(X,Y,A)
Hello. I have this terrain data. The size of A matrix is 194×324 and contain elevation data. I want to fill below the terrain from the elevation of the data to the 0 (mean sea level). I use fill code
hFill = fill3(X, Y, A, patchColor, ‘LineWidth’, 1, ‘EdgeColor’, patchColor, …
‘FaceAlpha’, 0.5);
However, it only fill below the surface with thin layer. I try to fill from the elevation to the 0 (mean sea level).
Thank you, A=imread(‘appRasterNEDAPIService1708354512850-756880040.tif’);
X=1:324;
Y=1:194;
[X,Y]=meshgrid(X,Y);
surf(X,Y,A)
Hello. I have this terrain data. The size of A matrix is 194×324 and contain elevation data. I want to fill below the terrain from the elevation of the data to the 0 (mean sea level). I use fill code
hFill = fill3(X, Y, A, patchColor, ‘LineWidth’, 1, ‘EdgeColor’, patchColor, …
‘FaceAlpha’, 0.5);
However, it only fill below the surface with thin layer. I try to fill from the elevation to the 0 (mean sea level).
Thank you, image processing MATLAB Answers — New Questions
How can I upgrade my MATLAB Parallel Server cluster to the new version?
I would like to install the new version of MATLAB Parallel Server on my cluster. How can I do this?I would like to install the new version of MATLAB Parallel Server on my cluster. How can I do this? I would like to install the new version of MATLAB Parallel Server on my cluster. How can I do this? MATLAB Answers — New Questions
Import excel column as an item in SharePoint list
I have a huge excel file with a bunch of tabs that I would like to convert into one SharePoint List through PowerAutomate so that the list is always up to date.
All worksheets have the same format. The first column will be the sharepoint columns and the “Colonne2” will be a new item for each of the worksheet. I don’t need the “Colonne1” in the SharePoint List.
Here is an example of one worksheet:
Numéro de compteColonne1Colonne24160Subventions total40004310Billeterie 4351Parrainages Commandites15004353Ventes souvenirs 4450Revenus divers 4541Membres ou cartes d’adhésion 4512Prélèvements 4530Dons 4560Ventes à commission d’oeuvres artistique 4460Ventes boutique 4550Intérêts 4650Transferts de garderie codé comme paie de DNSSAB 4651Transfert de garderie pour événements culturels 5210Sous contractuel05310Transportation105311Per Diem nourriture bénévoles et artistes05320Cachets hors Ontario05321Cachets artistes Ontario05331Hébergement Artistes Conférenciers05332Techniciens3005334Équipements de programmation Locations et Achats4215335Location lieux, permis de terrain, etc.207,015350Publicité483,945354Relations publiques (réseautage)05356Achats matériaux prix3 034,155415Sécurité05420Traiteurs et nourritures pour vendre au public167,72
Any ideas how to do this? I want to use PowerAutomate so that the SharePoint list is always current but also gives me the history of each project. I guess I could copy the colums and paste as horizontal on each worksheet, but then the Excel will be clunky. Each worksheet is a project and we will be adding projects all the time.
I have a huge excel file with a bunch of tabs that I would like to convert into one SharePoint List through PowerAutomate so that the list is always up to date. All worksheets have the same format. The first column will be the sharepoint columns and the “Colonne2” will be a new item for each of the worksheet. I don’t need the “Colonne1” in the SharePoint List. Here is an example of one worksheet:Numéro de compteColonne1Colonne24160Subventions total40004310Billeterie 4351Parrainages Commandites15004353Ventes souvenirs 4450Revenus divers 4541Membres ou cartes d’adhésion 4512Prélèvements 4530Dons 4560Ventes à commission d’oeuvres artistique 4460Ventes boutique 4550Intérêts 4650Transferts de garderie codé comme paie de DNSSAB 4651Transfert de garderie pour événements culturels 5210Sous contractuel05310Transportation105311Per Diem nourriture bénévoles et artistes05320Cachets hors Ontario05321Cachets artistes Ontario05331Hébergement Artistes Conférenciers05332Techniciens3005334Équipements de programmation Locations et Achats4215335Location lieux, permis de terrain, etc.207,015350Publicité483,945354Relations publiques (réseautage)05356Achats matériaux prix3 034,155415Sécurité05420Traiteurs et nourritures pour vendre au public167,72 Any ideas how to do this? I want to use PowerAutomate so that the SharePoint list is always current but also gives me the history of each project. I guess I could copy the colums and paste as horizontal on each worksheet, but then the Excel will be clunky. Each worksheet is a project and we will be adding projects all the time. Read More
Colour fill a whole row based on formatted cell colour
I have conditional formatting on a column (B), based on the text that is entered. This is on a spreadsheet that has a dynamic calendar list, so the cell could change colour based on the day/month/year. Is there a way that the whole row can be colour filled to match the colour fill in column B?
I have conditional formatting on a column (B), based on the text that is entered. This is on a spreadsheet that has a dynamic calendar list, so the cell could change colour based on the day/month/year. Is there a way that the whole row can be colour filled to match the colour fill in column B? Read More
Calculated Column – count and sum if column values contain exact text
I have 10 questions, each with various points assigned to them
Each question can contains either a Met, Not Met or NA
I want to get the total points for the Mets and the Not Mets
I can get the Not Met formula to work but I believe my Met formula is also including Not Mets because “Met” is used. How can I set up my formula so it only looks at the exact word of Met?
This is what I have so far
=SUM((IF(NOT(ISERROR(Search(“Met”,[Question 1]))),10)
+(IF(NOT(ISERROR(Search(“Met”,[Question 2]))),2)
+(IF(NOT(ISERROR(Search(“Met”,[Question 3]))),10)
I have 10 questions, each with various points assigned to themEach question can contains either a Met, Not Met or NAI want to get the total points for the Mets and the Not Mets I can get the Not Met formula to work but I believe my Met formula is also including Not Mets because “Met” is used. How can I set up my formula so it only looks at the exact word of Met? This is what I have so far =SUM((IF(NOT(ISERROR(Search(“Met”,[Question 1]))),10)+(IF(NOT(ISERROR(Search(“Met”,[Question 2]))),2)+(IF(NOT(ISERROR(Search(“Met”,[Question 3]))),10) Read More
Export List of All Documents in SharePoint to Excel
Hello. I am trying to mirror the SharePoint hierarchy in an export query to Excel. I can use the “Export to Excel” feature from the library, but the output sorts the lists by folders and then items. I want to export a list showing folders and each item in that folder. I need this to show our compliance activities, and I figure there has to be an easier way than manual folder-by-folder extraction. Thank you.
Hello. I am trying to mirror the SharePoint hierarchy in an export query to Excel. I can use the “Export to Excel” feature from the library, but the output sorts the lists by folders and then items. I want to export a list showing folders and each item in that folder. I need this to show our compliance activities, and I figure there has to be an easier way than manual folder-by-folder extraction. Thank you. Read More
Unused Join affects performance on View select
The query below runs in less than 1 second when dbo.CustomerTeam, which contains 6 rows, is a table but almost 4 minutes when it is created as a view. ProjectManagement contains 737615 rows. The query plan shows 221663 rows read on ProjectManagement to Project/ProjectTask join when CustomerTeam is a table but 4195075 when it is a view – despite CustomerTeam not being on the join path! Rows read on the Project Management to Customer Team join is 149790 in both cases – which is the number of rows in team ‘Sales Team’. Why is the performance on the ProjectManagement to Project/ProjectTask join being negatively influenced by CustomerTeam, which is on a different join, being a view? SELECT CustomerFROM ProjectManagement pm LEFT OUTER JOIN dbo.CustomerTeam ct ON ct.[Customer Team DynID] = pm.[Customer Team DynID] LEFT OUTER JOIN dbo.Project p INNER JOIN dbo.ProjectTask pt ON p.[Project DynID] = pt.[Project DynID] ON pt.[Project DynID] = pm.[Project DynID] AND pt.[Task DynID] = pm.[Task DynID] LEFT OUTER JOIN dbo.Customer c ON p.[Customer DynID] = c.[Customer DynID]WHERE ct.[Customer Team] IN (‘Sales Team’) GROUP BY CustomerOPTION(RECOMPILE) Read More
Connect a SharePoint online calendar using “Connect to Outlook” on IOS
I have an Event list and i can use the “Connect to Outlook” to connect a SharePoint online event list to my outlook:-
but on my MAC machine, this options will be disabled.. so how i can Connect a SharePoint online calendar using “Connect to Outlook” on IOS?? Thanks
I have an Event list and i can use the “Connect to Outlook” to connect a SharePoint online event list to my outlook:- but on my MAC machine, this options will be disabled.. so how i can Connect a SharePoint online calendar using “Connect to Outlook” on IOS?? Thanks Read More
Show a full calendar view for an Event list inside a modern page + allow to “Connect to Outlook”
I want to show a Calendar inside my modern sharepoint online page. Now seems there are 2 ways based on this link https://sharepointmaven.com/how-to-create-a-calendar-view-on-a-sharepoint-list/ ..
1) Create a custom list and use the Calendar view
2) Create an actual Event list
Now I do not want to use the first option as i can not use the “Connect to Outlook” to connect the sharepoint calendar to my outlook on Windows machine, as the source is not an actual event but rather a custom list with a calendar view.
But using the second point, i can use the “Connect to Outlook”,
but the problem is that i am unable to show the full calendar view on a modern page in a user friendly way. now i used this Embed web part, with an iframe and IsDlg=1 parameter, as follow:-
but the result i got was not very pleasant, as follow:-
where there is a lot of free space on top + when i click on the “+Add” link to add a new event or click to view existing event >> the event will be shown on the embed web part with all the other screen sections which is not very user friendly, as follow:-
so how i can have a full calendar view inside modern web page in a user friendly and modern way + the ability to use “Connect to Outlook”??
Thanks
I want to show a Calendar inside my modern sharepoint online page. Now seems there are 2 ways based on this link https://sharepointmaven.com/how-to-create-a-calendar-view-on-a-sharepoint-list/ .. 1) Create a custom list and use the Calendar view2) Create an actual Event list Now I do not want to use the first option as i can not use the “Connect to Outlook” to connect the sharepoint calendar to my outlook on Windows machine, as the source is not an actual event but rather a custom list with a calendar view. But using the second point, i can use the “Connect to Outlook”, but the problem is that i am unable to show the full calendar view on a modern page in a user friendly way. now i used this Embed web part, with an iframe and IsDlg=1 parameter, as follow:- but the result i got was not very pleasant, as follow:- where there is a lot of free space on top + when i click on the “+Add” link to add a new event or click to view existing event >> the event will be shown on the embed web part with all the other screen sections which is not very user friendly, as follow:- so how i can have a full calendar view inside modern web page in a user friendly and modern way + the ability to use “Connect to Outlook”??Thanks Read More
Payout Percentage Based on Achievement Percentage
I have a table with achievement % minimum, target, and a max cap with corresponding payout percentage amounts. I need a formula that will look up any given % achieved and return the corresponding payout percentage, BUT the payout percentage could fall anywhere between the rows. In other words, these are NOT inflexible tiers. The payout percentages could be any decimal between 2% and 3.75%.
% Goal Achieved
Payout Percentage
Min
80.000%
2.000%
Target
100.000%
2.500%
Max
150.000%
3.750%
Expected Results:
>If employee achieved 79% of goal, result would be 0% payout based on minimum not achieved.
>If employee achieved 90% of goal, result would be 2.25% payout (i.e. between the 2% and 2.5% tier)
>If employee achieved 175% of goal, result would be capped at the 3.75% payout.
Assume the % goal value I am looking up is in cell A1, what formula can I enter in B1 to return the corresponding payout percentage?
I have a table with achievement % minimum, target, and a max cap with corresponding payout percentage amounts. I need a formula that will look up any given % achieved and return the corresponding payout percentage, BUT the payout percentage could fall anywhere between the rows. In other words, these are NOT inflexible tiers. The payout percentages could be any decimal between 2% and 3.75%. % Goal AchievedPayout PercentageMin80.000%2.000%Target100.000%2.500%Max150.000%3.750%Expected Results:>If employee achieved 79% of goal, result would be 0% payout based on minimum not achieved.>If employee achieved 90% of goal, result would be 2.25% payout (i.e. between the 2% and 2.5% tier)>If employee achieved 175% of goal, result would be capped at the 3.75% payout.Assume the % goal value I am looking up is in cell A1, what formula can I enter in B1 to return the corresponding payout percentage? Read More
