Month: October 2024
Xlookup to return values that is in tabular format
How do I get XLookUp to return the value based on 3-criterias and the corresponding values are in tabular form?
I know I can get if the values 1) Blank or 2) Start/End Mark… are in single column via vlookup. However the dataset is huge (60K lines) and 3MB. My instinct says it will be a long lookup.
How do I get XLookUp to return the value based on 3-criterias and the corresponding values are in tabular form? I know I can get if the values 1) Blank or 2) Start/End Mark… are in single column via vlookup. However the dataset is huge (60K lines) and 3MB. My instinct says it will be a long lookup. Read More
Conditional Formatting – Sharepoint List
It has been a while since using sharepoint lists and I am a bit out of practice!
I have set up a list which shows a list of Assessments which each staff member needs to complete and the date it expires. Not everyone has to do the same assessments.
I need to add to add conditional formatting into a date column to do the following:
If the cell is blank for it to be shaded grey.
If the date has expired the for it to be shaded red (the light coloured red)
If the date has not expired for it to be coloured green (the light green).
Any help much appreciated.
It has been a while since using sharepoint lists and I am a bit out of practice! I have set up a list which shows a list of Assessments which each staff member needs to complete and the date it expires. Not everyone has to do the same assessments. I need to add to add conditional formatting into a date column to do the following: If the cell is blank for it to be shaded grey.If the date has expired the for it to be shaded red (the light coloured red)If the date has not expired for it to be coloured green (the light green). Any help much appreciated. Read More
S/mime in a complex Environment
I need to implement Smime certificates in an organization, The environment is as following:-Active directory has a domain different than the domain used in -M365/Intune/Exchange online thus there is a UserPrincipalName mismatch.-User’s identity is federated and provisioned using Okta to M365 thus no AD connect running. What would be the best way to achieve this? In detailed steps Read More
Changing TCP Receive Window in C#
Hi,I have an embedded board with limited RAM (25 KB) and have defined two TCP sockets on it.I can communicate effectively with my Windows application, which I developed in C#. However, I encounter a problem when the Ethernet cable is abruptly disconnected. In this situation, due to the TCP timeout and retry procedure, the embedded board runs out of memory and stops functioning. After consulting with an expert from the company, I learned that this issue is related to the TCP receive window on the PC side (since the receive window on my embedded board is already reduced). They suggested that if I can decrease the TCP receive window for my socket in C#, it may help prevent my board from becoming unresponsive. And they are correct, because when I replaced the PC with another embedded board, this problem did not occur. I would greatly appreciate any guidance you can provide on how to reduce the TCP receive window just for the connected socket in C# not all adapters window size. Thank you! Read More
how to 2d plot simple ?
x=deg2rad(17)
tan(x/2) =(1-cos(x))/(sin(x))x=deg2rad(17)
tan(x/2) =(1-cos(x))/(sin(x)) x=deg2rad(17)
tan(x/2) =(1-cos(x))/(sin(x)) 2d plot, plotting, plot MATLAB Answers — New Questions
Convert Point Spread Function translate to MTF
Hi
I have a guassian point spread function and i would like to find the equivalent MTF in frequency domain.
I have the following code with assistance from : https://www.mathworks.com/matlabcentral/answers/274848-point-spread-function-translate-to-mtf
x=[1,2,3,4,5,6,7,8,9,10,11,12,13]
y=[0,1,3,21,46,156,222,140,111,25,14,3,2]
LSF=[x,y];
OTF = fftshift(fft(LSF)); % OTF
MTF = abs(OTF); % absolute value of OTF
MTF = MTF./max(MTF); % normalize
% correct sampling frequency for conversion on frequency bins to frequency
Size = length(MTF);
spacing = 1.12e-6;% pixel size
fsx = abs(1/spacing); % turn into sampling frequency
a = linspace(-Size/2,Size/2,Size); % form scale for conversion based on frequency bins
conversionx = fsx./Size; % conversion factor for frequency bin units to frequency (unit^-1)
Psi = a.*conversionx; % frequency (unit^-1)
figure
plot(Psi,MTF)
xlim([0,Psi(end)])
xlabel(‘cycles/unit’)
ylabel(‘MTF’)
could someone please help me convert the X axis from cycles/unit to lp/mm , i am not sure how this conversion is peformedHi
I have a guassian point spread function and i would like to find the equivalent MTF in frequency domain.
I have the following code with assistance from : https://www.mathworks.com/matlabcentral/answers/274848-point-spread-function-translate-to-mtf
x=[1,2,3,4,5,6,7,8,9,10,11,12,13]
y=[0,1,3,21,46,156,222,140,111,25,14,3,2]
LSF=[x,y];
OTF = fftshift(fft(LSF)); % OTF
MTF = abs(OTF); % absolute value of OTF
MTF = MTF./max(MTF); % normalize
% correct sampling frequency for conversion on frequency bins to frequency
Size = length(MTF);
spacing = 1.12e-6;% pixel size
fsx = abs(1/spacing); % turn into sampling frequency
a = linspace(-Size/2,Size/2,Size); % form scale for conversion based on frequency bins
conversionx = fsx./Size; % conversion factor for frequency bin units to frequency (unit^-1)
Psi = a.*conversionx; % frequency (unit^-1)
figure
plot(Psi,MTF)
xlim([0,Psi(end)])
xlabel(‘cycles/unit’)
ylabel(‘MTF’)
could someone please help me convert the X axis from cycles/unit to lp/mm , i am not sure how this conversion is peformed Hi
I have a guassian point spread function and i would like to find the equivalent MTF in frequency domain.
I have the following code with assistance from : https://www.mathworks.com/matlabcentral/answers/274848-point-spread-function-translate-to-mtf
x=[1,2,3,4,5,6,7,8,9,10,11,12,13]
y=[0,1,3,21,46,156,222,140,111,25,14,3,2]
LSF=[x,y];
OTF = fftshift(fft(LSF)); % OTF
MTF = abs(OTF); % absolute value of OTF
MTF = MTF./max(MTF); % normalize
% correct sampling frequency for conversion on frequency bins to frequency
Size = length(MTF);
spacing = 1.12e-6;% pixel size
fsx = abs(1/spacing); % turn into sampling frequency
a = linspace(-Size/2,Size/2,Size); % form scale for conversion based on frequency bins
conversionx = fsx./Size; % conversion factor for frequency bin units to frequency (unit^-1)
Psi = a.*conversionx; % frequency (unit^-1)
figure
plot(Psi,MTF)
xlim([0,Psi(end)])
xlabel(‘cycles/unit’)
ylabel(‘MTF’)
could someone please help me convert the X axis from cycles/unit to lp/mm , i am not sure how this conversion is peformed image analysis, image processing, resolution MATLAB Answers — New Questions
Double Slider, Two slide bars
Hi everyone,
Is there anyway to put to slide bars on the same slider to make the slider work as a numeric interval with GUI?. Something like the color bar with nodes of the colormapeditor from Matlab, just with two nodes.Hi everyone,
Is there anyway to put to slide bars on the same slider to make the slider work as a numeric interval with GUI?. Something like the color bar with nodes of the colormapeditor from Matlab, just with two nodes. Hi everyone,
Is there anyway to put to slide bars on the same slider to make the slider work as a numeric interval with GUI?. Something like the color bar with nodes of the colormapeditor from Matlab, just with two nodes. slider, double, guide, gui, rangeslider MATLAB Answers — New Questions
Modeling condensation of the outer pipe surface of the Pipe (MA) Simscape model
Hey!
I am working on a project currently, where I would like to evaluate the conndensed water mass at the outer surface of a pipe.
To give you an example: A cold fluid below 0 °C / 32 °F is flowing through a pipe. The pipe is placed into a container with moist air. Assuming that the wall temperature is equal to the temperature of the fluid inside the pipe, water included in moist air should eventually condensate at the outer wall surface.
Hence my question, does anyone know how to model such a behaviour? I know how to model condensation inside the pipe, which is not of interest now, but I am not aware how to model the condensation inside the container at the outer pipe surface. Is this even possible?
Thank you for helping me out in advance!Hey!
I am working on a project currently, where I would like to evaluate the conndensed water mass at the outer surface of a pipe.
To give you an example: A cold fluid below 0 °C / 32 °F is flowing through a pipe. The pipe is placed into a container with moist air. Assuming that the wall temperature is equal to the temperature of the fluid inside the pipe, water included in moist air should eventually condensate at the outer wall surface.
Hence my question, does anyone know how to model such a behaviour? I know how to model condensation inside the pipe, which is not of interest now, but I am not aware how to model the condensation inside the container at the outer pipe surface. Is this even possible?
Thank you for helping me out in advance! Hey!
I am working on a project currently, where I would like to evaluate the conndensed water mass at the outer surface of a pipe.
To give you an example: A cold fluid below 0 °C / 32 °F is flowing through a pipe. The pipe is placed into a container with moist air. Assuming that the wall temperature is equal to the temperature of the fluid inside the pipe, water included in moist air should eventually condensate at the outer wall surface.
Hence my question, does anyone know how to model such a behaviour? I know how to model condensation inside the pipe, which is not of interest now, but I am not aware how to model the condensation inside the container at the outer pipe surface. Is this even possible?
Thank you for helping me out in advance! pipe (ma), condensation MATLAB Answers — New Questions
SharePoint Search Insights Suddenly Not Providing Data
Hi All,
On a weekly basis I click on “All Site Settings” and then “Search Insights and Configuration.” I would then go this section of the page:
and then download the reports. They used to be separated into individual days and I would see the search queries and their metrics for the full 28 days. However, in the last couple of weeks this information seems to be missing. No configurations that would affect this have been changed (to the best of my knowledge, and I am the SharePoint site runner), so I’m unsure what’s happening.
It now only provides blank data like this:
across 4 days separated by a week, instead of every day:
I would love if someone could please assist, thanks very much.
Hi All, On a weekly basis I click on “All Site Settings” and then “Search Insights and Configuration.” I would then go this section of the page: and then download the reports. They used to be separated into individual days and I would see the search queries and their metrics for the full 28 days. However, in the last couple of weeks this information seems to be missing. No configurations that would affect this have been changed (to the best of my knowledge, and I am the SharePoint site runner), so I’m unsure what’s happening. It now only provides blank data like this: across 4 days separated by a week, instead of every day: I would love if someone could please assist, thanks very much. Read More
फोनपे में शिकायत कैसे दर्ज करें?
Phone Pe: Phone Pe in में, आप,,ट्रांज़ैक्शन” या 886_11×11624,”इतिहास” सेक्शन में जाकर असफल लेनदेन का चयन करके उस लेनदेन को देख सकते हैं और “24/7 वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प का उपयोग करके पैसे वापस प्राप्त कर सकते हैं।,,
Phone Pe: Phone Pe in में, आप,,ट्रांज़ैक्शन” या 886_11×11624,”इतिहास” सेक्शन में जाकर असफल लेनदेन का चयन करके उस लेनदेन को देख सकते हैं और “24/7 वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प का उपयोग करके पैसे वापस प्राप्त कर सकते हैं।,, Read More
Analyze in Excel: How to force Credentials Window / Password Prompt to pop up
I need assistance to force Excel to ask for User Credentials / Password Prompt when accessing Power BI data.
I am using Analyze in Excel that connect to a Power BI datamodel that is located in the service.
I am logged into my Excel Desktop app and can see the Power BI Datamodel/Dataset.
However, once selected, as it tries to load there is an error that says:
“Cannot create the PivotTable. An error has occurred when creating the PivotTable. Please make sure that you have permissions to the data, that the model is valid and the credentials are correct.”
There is a similiar issue when using Excel for Web.
The user profile has full permissions over the datamodel/dataset.
The first image is what I need to pop up.
The second image is the error I’m getting (without being prompted to confirm credentials. user already signed in)
I need assistance to force Excel to ask for User Credentials / Password Prompt when accessing Power BI data.I am using Analyze in Excel that connect to a Power BI datamodel that is located in the service.I am logged into my Excel Desktop app and can see the Power BI Datamodel/Dataset.However, once selected, as it tries to load there is an error that says:”Cannot create the PivotTable. An error has occurred when creating the PivotTable. Please make sure that you have permissions to the data, that the model is valid and the credentials are correct.”There is a similiar issue when using Excel for Web.The user profile has full permissions over the datamodel/dataset.The first image is what I need to pop up.The second image is the error I’m getting (without being prompted to confirm credentials. user already signed in)credentials window pop up that is not appearingerror that is shown when trying to connect to Power BI datamodel/dataset Read More
Initiatives have to keep same metric format as Key Results
Hi everyone,
is it bug or feature that Key Results aligned to Objective can have mixed format of metric while Initiatives underneath can’t? Probably hard to understand, so let’s explain it like this:
Objectives’ Outcome is always set as percentage of completionKey results’ Metric may be set as numeric, percentage, even currency and still may contribute to Objective aboveInitiative has to keep same metric format as Key results otherwise contribution is not available to set
Example: KR set as reach 2 (number), Initiatives set with milestones as percentage completed, “Manage contributions” dialog doesn’t allow to choose some of those Initiatives as they have no metric or wrong metric format.
Is that by reason and could I understand why? It’s is possible to combine KRs contributing to Os but why not Is to KR?
Hi everyone,is it bug or feature that Key Results aligned to Objective can have mixed format of metric while Initiatives underneath can’t? Probably hard to understand, so let’s explain it like this:Objectives’ Outcome is always set as percentage of completionKey results’ Metric may be set as numeric, percentage, even currency and still may contribute to Objective aboveInitiative has to keep same metric format as Key results otherwise contribution is not available to setExample: KR set as reach 2 (number), Initiatives set with milestones as percentage completed, “Manage contributions” dialog doesn’t allow to choose some of those Initiatives as they have no metric or wrong metric format. Is that by reason and could I understand why? It’s is possible to combine KRs contributing to Os but why not Is to KR? Read More
Any Advice for SharePoint Sites Information Architecture with Great UX/UI?
Hi!
I’ve been working as a content admin in SharePoint Online for some time, and now I’m eager to get to the next level—learning how to build solutions that truly meet business needs and at the same time have an excellent UX and UI.
Currently, I’m most interested in how to arrange content on team sites as well as communication sites so that users can easily understand what can be found there and quickly navigate to it. Any advice, resources, or best practices you can share, please?
Hi! I’ve been working as a content admin in SharePoint Online for some time, and now I’m eager to get to the next level—learning how to build solutions that truly meet business needs and at the same time have an excellent UX and UI. Currently, I’m most interested in how to arrange content on team sites as well as communication sites so that users can easily understand what can be found there and quickly navigate to it. Any advice, resources, or best practices you can share, please? Read More
फोनपे में शिकायत कैसे दर्ज करें?
Phone Pe: Phone Pe in में, आप,,ट्रांज़ैक्शन” या 886_11×11624,”इतिहास” सेक्शन में जाकर असफल लेनदेन का चयन करके उस लेनदेन को देख सकते हैं और “24/7 वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प का उपयोग करके पैसे वापस प्राप्त कर सकते हैं।,,
Phone Pe: Phone Pe in में, आप,,ट्रांज़ैक्शन” या 886_11×11624,”इतिहास” सेक्शन में जाकर असफल लेनदेन का चयन करके उस लेनदेन को देख सकते हैं और “24/7 वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प का उपयोग करके पैसे वापस प्राप्त कर सकते हैं।,, Read More
email delivery report in ExO
Where specifically in Exchange Online (ExO) would an admin need to navigate to if they needed to get a detailed report to show how many messages from a specific external address had landed in their recipients inbox(es), and how many had been quarantined and under what category (with details, e.g. date/time/recipient affected etc). Are there any out-of-the-box reports that can help with this and meet this criteria?
Where specifically in Exchange Online (ExO) would an admin need to navigate to if they needed to get a detailed report to show how many messages from a specific external address had landed in their recipients inbox(es), and how many had been quarantined and under what category (with details, e.g. date/time/recipient affected etc). Are there any out-of-the-box reports that can help with this and meet this criteria? Read More
SharePoint Site Error
The list view threshold has been exceeded , how can I fix this
The list view threshold has been exceeded , how can I fix this Read More
Outlook Meeting Duplication and Removal Issue || 365 Outlook
When I accept an Outlook meeting, it gets duplicated in my calendar. I end up with two instances of the same meeting—one marked as accepted and the other not accepted. When I accept the duplicated meeting, it doesn’t duplicate further but remains marked as accepted. Additionally, when the meeting organizer cancels the meeting and I try to remove it from my calendar via the Outlook app (by clicking ‘Remove from my calendar’), the meeting doesn’t get removed. However, if I do this from Outlook Web, the meeting is successfully removed and also the duplicated one.
I would be glad for some help here thank you!
When I accept an Outlook meeting, it gets duplicated in my calendar. I end up with two instances of the same meeting—one marked as accepted and the other not accepted. When I accept the duplicated meeting, it doesn’t duplicate further but remains marked as accepted. Additionally, when the meeting organizer cancels the meeting and I try to remove it from my calendar via the Outlook app (by clicking ‘Remove from my calendar’), the meeting doesn’t get removed. However, if I do this from Outlook Web, the meeting is successfully removed and also the duplicated one.I would be glad for some help here thank you! Read More
Planner: Double appointment notifications
When using planner for scheduling, I receive double notifications for every appointment, one from outlook and one from Planner. Is there a way to prevent this?
When using planner for scheduling, I receive double notifications for every appointment, one from outlook and one from Planner. Is there a way to prevent this? Read More
Streamline on a curve surface
i heve results of a flow abouve curve surface and i want to present few stream lines but i get a wired flat surface result, how can i fix it . i provide my velocity and gride. My code is streamline(X,Y,U,V)i heve results of a flow abouve curve surface and i want to present few stream lines but i get a wired flat surface result, how can i fix it . i provide my velocity and gride. My code is streamline(X,Y,U,V) i heve results of a flow abouve curve surface and i want to present few stream lines but i get a wired flat surface result, how can i fix it . i provide my velocity and gride. My code is streamline(X,Y,U,V) streamline MATLAB Answers — New Questions
Write date to mySQL with millisecond precision
Hey everybody,
I have some data, that I want ot parse in an mySQL database. The data consists of a timestamp which has millisecond precision and some other colums. The data is stored in a table.
I use mysql-connector-java-5.1.47mysql-connector-java-5.1.47-bin.jar as described to connect to the database and write with:
sqlwrite(conn,’Messdaten’,testtable(1:5,:))
Inserting into the database works, however the millisecond precision is gone altough I declared the column as datetime(3). The data that is being stored has the e.g. the value 2019-02-16 10:59:46.000 instead of 2019-02-16 10:59:46.425
Can somebody please gibe me a hint what I am doing wrong ?
Thanks in advance!Hey everybody,
I have some data, that I want ot parse in an mySQL database. The data consists of a timestamp which has millisecond precision and some other colums. The data is stored in a table.
I use mysql-connector-java-5.1.47mysql-connector-java-5.1.47-bin.jar as described to connect to the database and write with:
sqlwrite(conn,’Messdaten’,testtable(1:5,:))
Inserting into the database works, however the millisecond precision is gone altough I declared the column as datetime(3). The data that is being stored has the e.g. the value 2019-02-16 10:59:46.000 instead of 2019-02-16 10:59:46.425
Can somebody please gibe me a hint what I am doing wrong ?
Thanks in advance! Hey everybody,
I have some data, that I want ot parse in an mySQL database. The data consists of a timestamp which has millisecond precision and some other colums. The data is stored in a table.
I use mysql-connector-java-5.1.47mysql-connector-java-5.1.47-bin.jar as described to connect to the database and write with:
sqlwrite(conn,’Messdaten’,testtable(1:5,:))
Inserting into the database works, however the millisecond precision is gone altough I declared the column as datetime(3). The data that is being stored has the e.g. the value 2019-02-16 10:59:46.000 instead of 2019-02-16 10:59:46.425
Can somebody please gibe me a hint what I am doing wrong ?
Thanks in advance! sql, sqlwrite, millisecond precision, mysql, mysql-connector-java-5.1.47 MATLAB Answers — New Questions