Month: June 2024
How to implement Steer by wire system model in simulink
How to implement Steer by wire system model in simulink? Please help me with this.How to implement Steer by wire system model in simulink? Please help me with this. How to implement Steer by wire system model in simulink? Please help me with this. simulink, simulation, steer by wire, model, output MATLAB Answers — New Questions
Can “pipe(G)” block be used to model forced air convection?
Hello,
i am trying to model a battery pack with forced air convection cooling. The pipe(G) block can be used to transfer heat from gas flowing inside a pipe to intended surface geometry. But it is internal flow. My concern is i want to model heat transfer from the surface to the gas(air). But that will become external flow problem. Is it possible to do so?
please help!
thanks.Hello,
i am trying to model a battery pack with forced air convection cooling. The pipe(G) block can be used to transfer heat from gas flowing inside a pipe to intended surface geometry. But it is internal flow. My concern is i want to model heat transfer from the surface to the gas(air). But that will become external flow problem. Is it possible to do so?
please help!
thanks. Hello,
i am trying to model a battery pack with forced air convection cooling. The pipe(G) block can be used to transfer heat from gas flowing inside a pipe to intended surface geometry. But it is internal flow. My concern is i want to model heat transfer from the surface to the gas(air). But that will become external flow problem. Is it possible to do so?
please help!
thanks. heat transfer, thermal modeling, forced convection MATLAB Answers — New Questions
find all pathbetween 2 node under constraint
hey
i want to find all path between A to B ( start from left buttom)
i have tryed to use meshgrid and allpath command without succses
the constraint are the i can go right or up only
also, i need to write code that calculates the probability on each node to go up or right if given that all route is equal probability
i will appreciate hint how to write my code and which commands to use
here is the meshhey
i want to find all path between A to B ( start from left buttom)
i have tryed to use meshgrid and allpath command without succses
the constraint are the i can go right or up only
also, i need to write code that calculates the probability on each node to go up or right if given that all route is equal probability
i will appreciate hint how to write my code and which commands to use
here is the mesh hey
i want to find all path between A to B ( start from left buttom)
i have tryed to use meshgrid and allpath command without succses
the constraint are the i can go right or up only
also, i need to write code that calculates the probability on each node to go up or right if given that all route is equal probability
i will appreciate hint how to write my code and which commands to use
here is the mesh node, allphath MATLAB Answers — New Questions
How can I add a mouse movement listener to a custom ui component?
Hello everyone,
I have created a MatLab app that uses mousemovement events. It uses the WindowButtonMotion callback of the UIFigure that was described here https://nl.mathworks.com/matlabcentral/answers/775147-how-to-create-mouse-movement-event-on-uiaxes-in-app-designer-to-catch-cursor-location-on-the-axes in the answer (Method 2) by Adam Danz
The app works nicely. However, now that the project is evolving, I would like to convert the App to a Custom UI Component. But MatLab components do not seem to include a UIFigure, and therefore no WindowsButtonMotion event/callback. The Custom UI Component itself (comp) and UIAxes do not have a WindowButtonMotion event.
What I would like is a mousemovement event/callback/listener that calls a function so that I can check the mouse position against criteria and take appropriate action. This seems like very common functionality, but I cannot figure out how to accomplish this in a Custom UI Component.
Any ideas?Hello everyone,
I have created a MatLab app that uses mousemovement events. It uses the WindowButtonMotion callback of the UIFigure that was described here https://nl.mathworks.com/matlabcentral/answers/775147-how-to-create-mouse-movement-event-on-uiaxes-in-app-designer-to-catch-cursor-location-on-the-axes in the answer (Method 2) by Adam Danz
The app works nicely. However, now that the project is evolving, I would like to convert the App to a Custom UI Component. But MatLab components do not seem to include a UIFigure, and therefore no WindowsButtonMotion event/callback. The Custom UI Component itself (comp) and UIAxes do not have a WindowButtonMotion event.
What I would like is a mousemovement event/callback/listener that calls a function so that I can check the mouse position against criteria and take appropriate action. This seems like very common functionality, but I cannot figure out how to accomplish this in a Custom UI Component.
Any ideas? Hello everyone,
I have created a MatLab app that uses mousemovement events. It uses the WindowButtonMotion callback of the UIFigure that was described here https://nl.mathworks.com/matlabcentral/answers/775147-how-to-create-mouse-movement-event-on-uiaxes-in-app-designer-to-catch-cursor-location-on-the-axes in the answer (Method 2) by Adam Danz
The app works nicely. However, now that the project is evolving, I would like to convert the App to a Custom UI Component. But MatLab components do not seem to include a UIFigure, and therefore no WindowsButtonMotion event/callback. The Custom UI Component itself (comp) and UIAxes do not have a WindowButtonMotion event.
What I would like is a mousemovement event/callback/listener that calls a function so that I can check the mouse position against criteria and take appropriate action. This seems like very common functionality, but I cannot figure out how to accomplish this in a Custom UI Component.
Any ideas? windowbuttonmotion, custom ui component, app designer MATLAB Answers — New Questions
blazor reading paramater from GET string
I have a blazor page
<h1>Hello, world!</h1>
<h2>The time on the server is @DateTime.Now LAT:@Request.Query[“lat”] LONG:@Request.Query[“long”]</h2>
where I am trying to read parameters but the error I get is
I also tried
<h2>The time on the server is @DateTime.Now LAT:@Context.Request.Query[“lat”] LONG:@Context.Request.Query[“long”]</h2>
and
<h2>The time on the server is @DateTime.Now LAT:@HttpContext.Current.Request.Query[“lat”]
LONG:@HttpContext.Current.Request.Query[“long”]</h2>
but the IDE doesnt understand Context/ or HttpContext.Current
I have a blazor page @PAGE
<h1>Hello, world!</h1>
<h2>The time on the server is @DateTime.Now LAT:@Request.Query[“lat”] LONG:@Request.Query[“long”]</h2>where I am trying to read parameters but the error I get is I also tried<h2>The time on the server is @DateTime.Now LAT:@Context.Request.Query[“lat”] LONG:@Context.Request.Query[“long”]</h2>
and
<h2>The time on the server is @DateTime.Now LAT:@HttpContext.Current.Request.Query[“lat”]
LONG:@HttpContext.Current.Request.Query[“long”]</h2>but the IDE doesnt understand Context/ or HttpContext.Current Read More
Planner Premium calculation is strange
Hi,
I encountered a strange behavior of the <% complete> field in the premium planner when you change the <duration> and/or <effort> fields after you started a task, e.g.
Set <start date>=today, <duration>=20 days, <effort>=40hours, <% complete>=50%Then change <duration> and <effort> to accommodate for unexpected delay/scope extension
Doing this, you will end up with a completely broken <% complete> value as shown in the image below.
It seems that the <duration> field is somehow integrated in the calculation of <% complete>, which I feel is odd.
Happy to get some feedback
Lasse
Hi,I encountered a strange behavior of the <% complete> field in the premium planner when you change the <duration> and/or <effort> fields after you started a task, e.g.Set <start date>=today, <duration>=20 days, <effort>=40hours, <% complete>=50%Then change <duration> and <effort> to accommodate for unexpected delay/scope extensionDoing this, you will end up with a completely broken <% complete> value as shown in the image below.It seems that the <duration> field is somehow integrated in the calculation of <% complete>, which I feel is odd.Happy to get some feedbackLasse Read More
<img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/590617iDF2BA16A92779068/image-size/large?v=v2&px=999" title="Planner Premium calculation is strange” />
Does Microsoft discriminate against health care providers?
At Health IT we specialise in looking after doctors in private practice. If you are in Queensland we probably look after your local GP and your local specialist. Almost all of our customers are the very definition of a small business.
For many years we’ve been driving technology forward for these customers on the Microsoft platform. Until now we’ve been official partners which means we know what we are doing and have some access to Microsoft to help solve our customer’s problems.
To be eligible to be a current Microsoft partner we have to have some certifications and prove some growth. Our growth is well and truly above their requirements EXCEPT, they only count customers with seats between 11-300. Your local doctor has an average seat count of 7.5, and we look after more than 300 of these customers.
An MSP half our size but without our specialty would easily qualify to be a Microsoft partner. But because we focus on and work almost exclusively for doctors, we can’t be. Although we’re growing much faster than they require, they don’t count our growth.
I have taken this up with Partner support and obviously they can’t change the rules, as unfair as they may be. How can we get some common sense applied to this problem, or are Microsoft happy to discriminate against the most important industry in the country?
At Health IT we specialise in looking after doctors in private practice. If you are in Queensland we probably look after your local GP and your local specialist. Almost all of our customers are the very definition of a small business.For many years we’ve been driving technology forward for these customers on the Microsoft platform. Until now we’ve been official partners which means we know what we are doing and have some access to Microsoft to help solve our customer’s problems.To be eligible to be a current Microsoft partner we have to have some certifications and prove some growth. Our growth is well and truly above their requirements EXCEPT, they only count customers with seats between 11-300. Your local doctor has an average seat count of 7.5, and we look after more than 300 of these customers.An MSP half our size but without our specialty would easily qualify to be a Microsoft partner. But because we focus on and work almost exclusively for doctors, we can’t be. Although we’re growing much faster than they require, they don’t count our growth.I have taken this up with Partner support and obviously they can’t change the rules, as unfair as they may be. How can we get some common sense applied to this problem, or are Microsoft happy to discriminate against the most important industry in the country? Read More
修改信箱安全信策略,備用信箱無法收到驗證碼
註冊五個outlook信箱使用,分別都已經設定備用信箱了,但近期要修改新增備用信箱,在輸入原先的備用信箱收取驗證碼時,出現『我們無法傳送驗證碼。請再試一次。』,已經測試很多次都出現這訊息,導致我無法進入安全策略裡面設定,請問這是什麼原因?以及如何排除問題?
PS. 有確認原先的備用信箱輸入是正確的
註冊五個outlook信箱使用,分別都已經設定備用信箱了,但近期要修改新增備用信箱,在輸入原先的備用信箱收取驗證碼時,出現『我們無法傳送驗證碼。請再試一次。』,已經測試很多次都出現這訊息,導致我無法進入安全策略裡面設定,請問這是什麼原因?以及如何排除問題?PS. 有確認原先的備用信箱輸入是正確的 Read More
Conversion of abc unbalanced waveforms to balanced symmetrical components waveforms
I want to convert my three phase unbalanced sinusoidal waveforms to its balanced symmetrical component waveforms. I’m getting phasor(real and imaginary) of symmetrical component waveform but I want the sinusoidal waveform. How can I extract that.
Please help me regarding to this.
Thanking YouI want to convert my three phase unbalanced sinusoidal waveforms to its balanced symmetrical component waveforms. I’m getting phasor(real and imaginary) of symmetrical component waveform but I want the sinusoidal waveform. How can I extract that.
Please help me regarding to this.
Thanking You I want to convert my three phase unbalanced sinusoidal waveforms to its balanced symmetrical component waveforms. I’m getting phasor(real and imaginary) of symmetrical component waveform but I want the sinusoidal waveform. How can I extract that.
Please help me regarding to this.
Thanking You symmetrical components, three phase, unbalanced MATLAB Answers — New Questions
Match Block Sizes in Simulink (2021b)
Does anyone know how to add "Match Size" function in Simulink? I have been using this function a lot since 2013b but I was shocked by not seeing this feature in 2021b. The shortcut for this was Ctlr+A+S. Thanks in advance!Does anyone know how to add "Match Size" function in Simulink? I have been using this function a lot since 2013b but I was shocked by not seeing this feature in 2021b. The shortcut for this was Ctlr+A+S. Thanks in advance! Does anyone know how to add "Match Size" function in Simulink? I have been using this function a lot since 2013b but I was shocked by not seeing this feature in 2021b. The shortcut for this was Ctlr+A+S. Thanks in advance! keyboard shortcuts, simulink, 2021b, modify block diagram appearance MATLAB Answers — New Questions
How can I optimize the the code below which assigns grey-scale color values to a color array from pixels in an image?
Hi!
I am trying to optimise the code below, which is the only part of a program i have made which uses for loops, and as such is fairly time consuming.
The program essentially uses two cameras, with their positions calibrated and defined relative to the position of an object they are imaging. The object is created in the virtual space by importing it as a point cloud and converting this to a triangulated surface. The code uses information about the normal vector to each triangle on the surface to figure out whether each camera can actually "see" that point on the object in the real world, and then uses the relevant pixel data for that point (each point is mapped onto the image to find out which pixel refers to it) to assign the correct colour value to the color array for the point cloud.
Any advice would be appreciated, I’m fairly new to matlab and definitely new to the concept of eliminating for loops and code optimisation.
If i haven’t explained the code clearly enough please let me know.
Thanks,
Toby
%Assign color to points if the surface faces towards the relevant camera
for m=1:numberoffaces
camera1vector=locationcamera1-P(m,:);
camera2vector=locationcamera2-P(m,:);
if (dot(camera1vector,F(m,:)))<0
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
elseif (dot(camera2vector,F(m,:)))<0
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
else
colors(m)= (0);
colors(m)= (0);
colors(m)= (0);
end
endHi!
I am trying to optimise the code below, which is the only part of a program i have made which uses for loops, and as such is fairly time consuming.
The program essentially uses two cameras, with their positions calibrated and defined relative to the position of an object they are imaging. The object is created in the virtual space by importing it as a point cloud and converting this to a triangulated surface. The code uses information about the normal vector to each triangle on the surface to figure out whether each camera can actually "see" that point on the object in the real world, and then uses the relevant pixel data for that point (each point is mapped onto the image to find out which pixel refers to it) to assign the correct colour value to the color array for the point cloud.
Any advice would be appreciated, I’m fairly new to matlab and definitely new to the concept of eliminating for loops and code optimisation.
If i haven’t explained the code clearly enough please let me know.
Thanks,
Toby
%Assign color to points if the surface faces towards the relevant camera
for m=1:numberoffaces
camera1vector=locationcamera1-P(m,:);
camera2vector=locationcamera2-P(m,:);
if (dot(camera1vector,F(m,:)))<0
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
elseif (dot(camera2vector,F(m,:)))<0
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
else
colors(m)= (0);
colors(m)= (0);
colors(m)= (0);
end
end Hi!
I am trying to optimise the code below, which is the only part of a program i have made which uses for loops, and as such is fairly time consuming.
The program essentially uses two cameras, with their positions calibrated and defined relative to the position of an object they are imaging. The object is created in the virtual space by importing it as a point cloud and converting this to a triangulated surface. The code uses information about the normal vector to each triangle on the surface to figure out whether each camera can actually "see" that point on the object in the real world, and then uses the relevant pixel data for that point (each point is mapped onto the image to find out which pixel refers to it) to assign the correct colour value to the color array for the point cloud.
Any advice would be appreciated, I’m fairly new to matlab and definitely new to the concept of eliminating for loops and code optimisation.
If i haven’t explained the code clearly enough please let me know.
Thanks,
Toby
%Assign color to points if the surface faces towards the relevant camera
for m=1:numberoffaces
camera1vector=locationcamera1-P(m,:);
camera2vector=locationcamera2-P(m,:);
if (dot(camera1vector,F(m,:)))<0
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
colors(m)= imageGL(pixelposition1(m,2),pixelposition1(m,1));
elseif (dot(camera2vector,F(m,:)))<0
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
colors(m)= imageGR(pixelposition2(m,2),pixelposition2(m,1));
else
colors(m)= (0);
colors(m)= (0);
colors(m)= (0);
end
end point cloud, for loop, for, performance, optimization, calibration, colormap, image processing, stereo imaging MATLAB Answers — New Questions
convert double to signed int
Hi,
Some doubt: if A=40000 = 0x9C40 and I’d like that 0x9C40 would be as signed integer – what shall be done?
executing int16, I’m getting
int16(A) = 32767
Any suggestion so that I’ll get -25,536 ?Hi,
Some doubt: if A=40000 = 0x9C40 and I’d like that 0x9C40 would be as signed integer – what shall be done?
executing int16, I’m getting
int16(A) = 32767
Any suggestion so that I’ll get -25,536 ? Hi,
Some doubt: if A=40000 = 0x9C40 and I’d like that 0x9C40 would be as signed integer – what shall be done?
executing int16, I’m getting
int16(A) = 32767
Any suggestion so that I’ll get -25,536 ? type conversion MATLAB Answers — New Questions
How to Convert OST to PST Free?
Download Advik OST to PST Converter software for Windows. This tool will convert OST file to PST with same folder structure. Thus, no data loss will take place. It will export all emails, calendar, contacts, notes, etc data from .ost into .pst format.
YOu can download the software and try it for free.
Steps to Convert OST to PST
Launch Advik OST to PST Converter in your PC.Click Select Files and add Add OST file in software.Select mailbox folders and click Next.Choose PST as saving option.Click Convert button.
Done! The software will start converting OST file in PST format automatically.
Download Advik OST to PST Converter software for Windows. This tool will convert OST file to PST with same folder structure. Thus, no data loss will take place. It will export all emails, calendar, contacts, notes, etc data from .ost into .pst format. YOu can download the software and try it for free. Steps to Convert OST to PSTLaunch Advik OST to PST Converter in your PC.Click Select Files and add Add OST file in software.Select mailbox folders and click Next.Choose PST as saving option.Click Convert button.Done! The software will start converting OST file in PST format automatically. Read More
Azure Chaos Studio supports new fault for Azure Event Hub
Azure Chaos Studio supports new fault for Azure Event Hubs.
Azure Chaos Studio is a managed service that uses chaos engineering to help you measure, understand, and improve your cloud application and service resilience. Chaos engineering is a methodology by which you inject real-world faults into your application to run controlled fault injection experiments.
Azure Chaos Studio has added a new fault action for Azure Event Hubs called Change Event Hub State.
This fault action lets users disable entities within a targeted Azure Event Hubs namespace either partially or fully to test messaging infrastructure for maintenance or failure scenarios for an application dependent on an Event Hub.
The fault can be used in the Azure portal by designing experiments, deploying templates, or using the REST API. The fault library contains more information and examples.
This article will cover the how-to setup the fault action in Azure Chaos Studio for Azure Event Hub called Change Event Hub State.
Create Event Hubs namespace
Step 1: Go to Azure Portal – https://portal.azure.com/ ; Login with your userId and password.
Step 2: Click on Create a resource and then select Event Hubs.
Step 3: Click on Create event hubs namespace.
Step 4: Click on Review + Create.
Step 5: Click on Create.
Step 6: Click on Go to resource.
Create Event Hub
Step 1: Now create the Event Hub.
Step 2: Click on Event Hub
Step 3: Provide a suitable name to the event Hub. Then Click on review & Create.
Step 4: Click on Create.
The Event Hub is created.
Chaos Studio
Step 1: Now Create Chaos Studio
Step 2: Click on Target
Step 3: You will be able to view the Event Hub namespace created by earlier.
Step 4: Select on Eventhubnamespace Created and click on “Enable targets”.
Step 5: Click on Review+ Enable
Step 6: Click on Enable
Step 7: Click on Go to Resource
Step 7: Go to Chaos Studio, by searching Chaos Studio in the Search bar.
Step 8: Click on Create.
Step 9: Provide a suitable name to the experiment. Click on Experiment Designer.
Step 10: Add the Action.
Step 11: Firstly, add the fault to disable the Azure Event Hub.
Step 12: In Faults dropdown select the Change Event Hub State.
Chage the event hub state to “Disable”.
Step 13: Click on Target Resources.
Step 14: On Target Resources Select the radio button “Manually select from a list”. Select your Event hub namespace. And Click on Add.
Step 15: Click on Add Delay.
Then change the Duration to the desired delay. In this case, I have added a 1-minute delay. Click on Add.
This means that when this experiment runs, it will first disable the Event Hub for the duration of 1 minute.
In the next step, we will change the Event Hub State back to Active.
Step 16: Now again add the fault and select the Change Event Hub state, like you did in Step 11.
Step 17: Now set the desiredState as Active.
Step 18: Click on Target Resources and select the Event Hub namespace like you did in previous step and click on Add.
Step 19: Click on Review and Create.
Step 20: Click on Create.
Step 21: Click on Go to resource.
Step 22: Now click on Identity.
Step 23: Click on Azure Add role assignments. Change the role to Azure Event Hub Data Owner and Save it.
Step 24: Click on Overview. The status will change to Running after approximately a min.
Step 25: Once the state is running. Go to your Event Hub. You will notice that state is disabled.
Step 26: As we have added the delay of 1 min in our experiment setup earlier, the event hub state change to Active after a minute.
Microsoft Tech Community – Latest Blogs –Read More
Error using cell/unique (line 85) Cell array input must be a cell array of character vectors.
i have created a cell to store [4×4] matrices. total matrices in a cell are 10. i want to find unique matrices of that cell and their occurrence.???
how can i do that in matlab. unique wont woks with a cell having matrix entries.i have created a cell to store [4×4] matrices. total matrices in a cell are 10. i want to find unique matrices of that cell and their occurrence.???
how can i do that in matlab. unique wont woks with a cell having matrix entries. i have created a cell to store [4×4] matrices. total matrices in a cell are 10. i want to find unique matrices of that cell and their occurrence.???
how can i do that in matlab. unique wont woks with a cell having matrix entries. unique, matrix similarity MATLAB Answers — New Questions
Problems with connecting to the ROS master using rosinit
I am running ros on a raspberry pi 4 and used the following code to try to establish a global ROS node
setenv(‘ROS_MASTER_URI’,’http://192.168.1.2:11311′)
setenv(‘ROS_IP’,’192.168.1.1′)
rosinit(‘192.168.1.2’)
and the error message that pops up on rosinit is
‘ Connection to process with Exchange: "ce85a6ab-8a96-40e9-9f51-c8fa6ac4ded8 " was lost.
It never happened before as I was able to establish the connect previously, and neither using rosshutdown or rebooting the raspberry pi workedI am running ros on a raspberry pi 4 and used the following code to try to establish a global ROS node
setenv(‘ROS_MASTER_URI’,’http://192.168.1.2:11311′)
setenv(‘ROS_IP’,’192.168.1.1′)
rosinit(‘192.168.1.2’)
and the error message that pops up on rosinit is
‘ Connection to process with Exchange: "ce85a6ab-8a96-40e9-9f51-c8fa6ac4ded8 " was lost.
It never happened before as I was able to establish the connect previously, and neither using rosshutdown or rebooting the raspberry pi worked I am running ros on a raspberry pi 4 and used the following code to try to establish a global ROS node
setenv(‘ROS_MASTER_URI’,’http://192.168.1.2:11311′)
setenv(‘ROS_IP’,’192.168.1.1′)
rosinit(‘192.168.1.2’)
and the error message that pops up on rosinit is
‘ Connection to process with Exchange: "ce85a6ab-8a96-40e9-9f51-c8fa6ac4ded8 " was lost.
It never happened before as I was able to establish the connect previously, and neither using rosshutdown or rebooting the raspberry pi worked ros, rosinit MATLAB Answers — New Questions
how can I load library ‘ehsCpuLib’ in MATLAB simulation. currently I am using MATLAB version R2019A
currently I am using MATLAB version R2019A. While running the simulation which is compatible with rt lab, i get an error message "Failed to load library ehsLibCpu".currently I am using MATLAB version R2019A. While running the simulation which is compatible with rt lab, i get an error message "Failed to load library ehsLibCpu". currently I am using MATLAB version R2019A. While running the simulation which is compatible with rt lab, i get an error message "Failed to load library ehsLibCpu". opal-rt, rt-lab, matlab, simulation MATLAB Answers — New Questions
Listing select data from one tab in another
I am trying to find a formula to list select data from one tab into tab sheet on the same document.
For example, say Tab 1 had the following information listed in Column A:
Apples AOranges AOranges BApples B
I want Tab 2 to automatically find all instances where Apples appear in the list and then list them like this:
Apples AApples B
At the moment, all I can do is a formula to only show where Apples are listed, but the formula leaves lots of blank spaces in between the listings, so it looks like this:
Apples A Apples B
Is there any way I can just get specific data from one tab to be listed in another tab with no gaps in rows?
I am trying to find a formula to list select data from one tab into tab sheet on the same document. For example, say Tab 1 had the following information listed in Column A:Apples AOranges AOranges BApples B I want Tab 2 to automatically find all instances where Apples appear in the list and then list them like this:Apples AApples B At the moment, all I can do is a formula to only show where Apples are listed, but the formula leaves lots of blank spaces in between the listings, so it looks like this:Apples A Apples B Is there any way I can just get specific data from one tab to be listed in another tab with no gaps in rows? Read More
Why is XLOOKUP not returning the value on one sheet but does on another?
Attached is the spreadsheet I am working on. Very simple request. base_data contains a product SKU, fineline code and a few others. The worksheet product-heliumSKU uses a LET statement to take data from base_data and using the fineline code, use it to look up in another spreadsheet (fineline-heliumSKU) to obtain the helium SKU. But alas, it seems to not find the helium SKU, yet the same XLOOKUP does return the helium SKU (see fineline-heliumSKU). There has to be something wrong with the XLOOKUP in the LET statement, just stumped.
Attached is the spreadsheet I am working on. Very simple request. base_data contains a product SKU, fineline code and a few others. The worksheet product-heliumSKU uses a LET statement to take data from base_data and using the fineline code, use it to look up in another spreadsheet (fineline-heliumSKU) to obtain the helium SKU. But alas, it seems to not find the helium SKU, yet the same XLOOKUP does return the helium SKU (see fineline-heliumSKU). There has to be something wrong with the XLOOKUP in the LET statement, just stumped. Read More
Can i dynamically filter a list on a page to match content to the page title
Hi Folks,
I have a Sharepoint list (Risk_links) with groupings that provides links to areas of risk.
I have an index page
I also have a page for EACH risk category that provides guidance on that topic.
On each topic page I have hosted the ‘list web part’ that links to RIsk_links.
~~
What I am hoping to achieve is to have each topic page filter the Risk_links list to only show the same items with the same category as the page title
E.G.
Topic page = Asbestos
filter the Risk_links list to only show ‘Asbestos’ rows.
~
I could create a list in each page, and manually upload the relevant content, what i’d like though is the one master list that is dynamically filtered so i can keep one thing current rather than having to keep many things current.
This would also help me create a page template so that new topics could be added fairly seamlessly.
~
Is there a setting (or some JSON) that can help the list in each topic page to dynamically filter the list as desired?
Thanks
Hi Folks, I have a Sharepoint list (Risk_links) with groupings that provides links to areas of risk. I have an index pageI also have a page for EACH risk category that provides guidance on that topic. On each topic page I have hosted the ‘list web part’ that links to RIsk_links. ~~ What I am hoping to achieve is to have each topic page filter the Risk_links list to only show the same items with the same category as the page title E.G. Topic page = Asbestosfilter the Risk_links list to only show ‘Asbestos’ rows. ~ I could create a list in each page, and manually upload the relevant content, what i’d like though is the one master list that is dynamically filtered so i can keep one thing current rather than having to keep many things current. This would also help me create a page template so that new topics could be added fairly seamlessly. ~ Is there a setting (or some JSON) that can help the list in each topic page to dynamically filter the list as desired? Thanks Read More