Author: PuTI
OPTIMOPTIONS does not support code generation for function ‘ga’.
I get this error OPTIMOPTIONS does not support code generation for function ‘ga’ when I try to run a matlab function in simulink using genetic algorithm optimization methode;
options = optimoptions(‘ga’, ‘Display’, ‘iter’, …
‘PopulationSize’, 50, … % You can adjust this
‘MaxGenerations’, 100, … % You can adjust this
‘UseParallel’, true); % Use parallel computing if available
could someone help me please ?I get this error OPTIMOPTIONS does not support code generation for function ‘ga’ when I try to run a matlab function in simulink using genetic algorithm optimization methode;
options = optimoptions(‘ga’, ‘Display’, ‘iter’, …
‘PopulationSize’, 50, … % You can adjust this
‘MaxGenerations’, 100, … % You can adjust this
‘UseParallel’, true); % Use parallel computing if available
could someone help me please ? I get this error OPTIMOPTIONS does not support code generation for function ‘ga’ when I try to run a matlab function in simulink using genetic algorithm optimization methode;
options = optimoptions(‘ga’, ‘Display’, ‘iter’, …
‘PopulationSize’, 50, … % You can adjust this
‘MaxGenerations’, 100, … % You can adjust this
‘UseParallel’, true); % Use parallel computing if available
could someone help me please ? genetic algorithm, simulink, optimization MATLAB Answers — New Questions
Volume Shadow Service crashes within NTDLL.DLL
I am trying to back up my disk with Dantz Retrospect using Open Volume Backup — i.e. VSS disk images. This has worked well for over a year, but since August 3, 2024 I am getting this event in the Windows 10 Event viewer:
Faulting application name: vssvc.exe, version: 10.0.19041.4355
Faulting module name: ntdll.dll, version: 10.0.19041.4522
Exception code: 0xc0000374
Fault offset: 0x00000000000f
I have re-registered all the dlls.
I have rummaged around on ChatGPT and Copilot for suggestions. None of them identified or resolved the problem. I have run:
scf /scannowother suggested utilities that I am not allowed to post here
I have re-installed Windows 10 and applied all the updates again.
I also get the same error if I try to create a Volume Shadow Copy “manually.”
So, it seems to me that this may have been caused by the KB5040525 update? How do I figure out for sure what the problem is and how do I fix it? Copilot claims no one else has seen the problem.
Upgrading to Windows 11 is not an option as my hardware is not supported there.
I am trying to back up my disk with Dantz Retrospect using Open Volume Backup — i.e. VSS disk images. This has worked well for over a year, but since August 3, 2024 I am getting this event in the Windows 10 Event viewer: Faulting application name: vssvc.exe, version: 10.0.19041.4355Faulting module name: ntdll.dll, version: 10.0.19041.4522Exception code: 0xc0000374Fault offset: 0x00000000000f I have re-registered all the dlls.I have rummaged around on ChatGPT and Copilot for suggestions. None of them identified or resolved the problem. I have run:scf /scannowother suggested utilities that I am not allowed to post hereI have re-installed Windows 10 and applied all the updates again.I also get the same error if I try to create a Volume Shadow Copy “manually.” So, it seems to me that this may have been caused by the KB5040525 update? How do I figure out for sure what the problem is and how do I fix it? Copilot claims no one else has seen the problem. Upgrading to Windows 11 is not an option as my hardware is not supported there. Read More
How to create a customer plugin using dotnet 6.0
Hi,
I implement a base application ( a standard app), now i want to create a customer plugin inherited from the base app,
My goal is to linked between there and implement the new features in the customer plugin without touch the base app.
Thanks
Hi,I implement a base application ( a standard app), now i want to create a customer plugin inherited from the base app,My goal is to linked between there and implement the new features in the customer plugin without touch the base app.Thanks Read More
New Survey: Your Input for the Microsoft Sentinel Ecosystem
Survey Link: https://forms.office.com/r/Yy7WWFGyeD
Solutions and integrations in the Microsoft Sentinel ecosystem, such as those available in Content Hub, are pivotal in bolstering the security coverage of organizations. As our customers increasingly integrate Microsoft Sentinel with Microsoft Defender XDR, by enabling our unified SOC platform, the importance of this ecosystem only increases.
In this brief survey, we seek your suggestions on improving Microsoft Sentinel’s ecosystem. Whether it’s a feature request, an idea for a new solution, or an enhancement to an existing one, we welcome your feedback. Feel free to submit multiple responses if you have multiple suggestions.
Your insights will help us prioritize features that matter most to you. Thank you for your contributions!
The Microsoft SIEM & XDR Team
Microsoft respects your privacy. Review our online Privacy Statement here: https://privacy.microsoft.com/en-us/privacystatement
Survey Link: https://forms.office.com/r/Yy7WWFGyeD
Solutions and integrations in the Microsoft Sentinel ecosystem, such as those available in Content Hub, are pivotal in bolstering the security coverage of organizations. As our customers increasingly integrate Microsoft Sentinel with Microsoft Defender XDR, by enabling our unified SOC platform, the importance of this ecosystem only increases.
In this brief survey, we seek your suggestions on improving Microsoft Sentinel’s ecosystem. Whether it’s a feature request, an idea for a new solution, or an enhancement to an existing one, we welcome your feedback. Feel free to submit multiple responses if you have multiple suggestions.
Your insights will help us prioritize features that matter most to you. Thank you for your contributions!
The Microsoft SIEM & XDR TeamMicrosoft respects your privacy. Review our online Privacy Statement here: https://privacy.microsoft.com/en-us/privacystatement Read More
Copilot Learning Hub: Seu Portal para Dominar o Microsoft Copilot
Você já quis ter um lugar único para aprender tudo sobre o Microsoft Copilot? Imagine ter um site onde você pode encontrar artigos, vídeos e laboratórios práticos que são relevantes para você, independentemente da tecnologia com a qual você trabalha. O Copilot Learning Hub foi projetado para ser a sua fonte principal para tudo relacionado ao Microsoft Copilot. Neste artigo, vamos dar uma olhada neste hub, o que ele pode fazer por você e como ele pode ajudá-lo a aprender e dominar o Microsoft Copilot.
Novo Curso Gratuito de Treinamento no Microsoft Learn – Coleção Oficial: Passo 1: Compreender o Copilot
Não há nada mais satisfatório do que aprender algo novo, e a Microsoft sabe disso. Temos uma nova série de cursos gratuitos no Microsoft Learn, que é a plataforma oficial de aprendizado da Microsoft. Eles são uma ótima maneira para qualquer pessoa interessada em aprender mais sobre o Microsoft Copilot.
A coleção é dividida em quatro módulos, para que você possa aprender sobre:
Compreender como a IA Generativa e o Copilot Funcionam
Compreender o Copilot para o Microsoft 365
Explorar mais com o Microsoft Copilot
Começar com o Copilot para o Microsoft 365
Para acessar essa coleção, basta clicar no link: Coleção Oficial: Passo 1: Compreender o Copilot.
Depois de concluir qualquer curso desta coleção, você receberá um certificado de conclusão que poderá compartilhar nas redes sociais, no seu currículo ou no perfil do LinkedIn.
O que é o Copilot Learning Hub?
O Copilot Learning Hub é uma plataforma onde você pode encontrar todos os recursos necessários para aprender o Microsoft Copilot em um só lugar. Este hub foi projetado para ajudar usuários de todas as áreas tecnológicas—como desenvolvedores, profissionais de TI, usuários de negócios, cientistas de dados, estudantes e muito mais—a acessar e aplicar o conhecimento de forma eficaz, com documentação detalhada, tutoriais interativos e exemplos práticos.
Por exemplo, na seção Comece sua Jornada de Aprendizado com o Copilot, você encontrará tutoriais, cursos, documentações, vídeos e outros recursos para ajudá-lo a aprender e dominar o Microsoft Copilot. Nesta seção, você pode aprender sobre:
Passo 1: Compreender o Copilot
Passo 2: Adotar o Copilot
Passo 3: Expandir o Copilot
Passo 4: Criar o Copilot
Se você observar, cada seção começa com conhecimentos básicos até que você possa alcançar e dominar a ferramenta, até chegar a um ponto onde possa desenvolver suas próprias soluções com o Microsoft Copilot.
Um outro ótimo recurso para quem gosta de aprender com vídeos é a série de vídeos nesta seção que o ajudará a entender melhor o Microsoft Copilot.
E eu gostaria de aproveitar esta oportunidade para compartilhar a lista de reprodução completa de vídeos sobre o Microsoft Copilot:
Vamos dar uma olhada mais de perto nos principais benefícios desse hub.
Benefícios do Copilot Learning Hub
Aqui estão alguns dos principais benefícios do Copilot Learning Hub:
Centro de Recursos Abrangente: Este é o seu hub para tudo relacionado a este tópico. O Copilot Learning Hub tem uma enorme coleção de artigos, vídeos e laboratórios práticos, facilitando para os usuários encontrar e usar os recursos que são mais adequados para eles.
Caminhos de Aprendizado Estruturados: Com laboratórios práticos e tutoriais passo a passo, os usuários podem colocar em prática seus conhecimentos em cenários do mundo real, o que os ajuda a entender melhor e desenvolver suas habilidades.
Oportunidades de Certificação: Após concluir os cursos disponíveis no hub, você pode ganhar badges/certificações que mostram que você é um especialista na sua área e dão um impulso na sua carreira profissional.
Quais são os principais recursos do Copilot Learning Hub? Vamos nos aprofundar e dar uma olhada mais de perto.
Recursos do Copilot Learning Hub
O Copilot Learning Hub tem alguns recursos excelentes que tornam o aprendizado do Microsoft Copilot mais fácil e eficaz.
Artigos e Documentação Aprofundados: Temos muitos artigos detalhados e documentação que fornecem aos usuários todas as informações de que precisam sobre o Microsoft Copilot, incluindo suas funcionalidades, melhores práticas e como tirar o máximo proveito dele.
Conteúdo de Vídeo Engajador: Tutoriais em vídeo e webinars com conteúdo de alta qualidade ajudam os usuários a entender conceitos complexos e a se manterem atualizados com os últimos desenvolvimentos do Microsoft Copilot.
Laboratórios Interativos: Laboratórios práticos permitem que os usuários experimentem o Microsoft Copilot em um ambiente seguro e controlado, o que ajuda a aprender fazendo.
Suporte da Comunidade: O hub também conecta os usuários a uma grande comunidade de aprendizes e especialistas, o que facilita a colaboração e o compartilhamento de conhecimentos.
Se você é uma organização que deseja treinar seus funcionários, a plataforma é uma ótima maneira de fazer isso.
Por exemplo, há cursos de treinamento específicos para aqueles que ocupam cargos de liderança em uma organização, como o treinamento: Transforme seus negócios com a IA da Microsoft, que também está disponível gratuitamente na plataforma.
Qualquer Função, Qualquer Nível de Habilidade!
O Copilot Learning Hub foi projetado para ajudar usuários de todas as áreas tecnológicas, independentemente de sua função ou nível de habilidade. Seja você um iniciante ou um especialista, encontrará recursos que são adequados para você.
Comece agora a sua Jornada com o Copilot Learning Hub
O Copilot Learning Hub é um recurso incrível para qualquer pessoa que queira se tornar um especialista no Microsoft Copilot. Ele oferece todos os recursos de que você precisa, além de caminhos de aprendizado estruturados e laboratórios interativos, para que você possa melhorar suas habilidades e conhecimentos.
Incentivamos você a explorar o Copilot Learning Hub e aproveitar ao máximo todas as ótimas informações que encontrará lá. Se você está apenas começando ou procurando aprofundar seus conhecimentos, este hub tem algo para todos.
Conclusão
O Copilot Learning Hub é o seu portal para dominar o Microsoft Copilot. Seja você um desenvolvedor, profissional de TI, usuário de negócios, cientista de dados, estudante ou apenas alguém interessado em aprender mais sobre o Microsoft Copilot, o hub tem algo para você. Com uma enorme coleção de artigos, vídeos e laboratórios práticos, você pode encontrar os recursos que precisa para aprender e dominar o Microsoft Copilot em um só lugar. Então, por que esperar? Comece sua jornada de aprendizado com o Copilot hoje!
Esperamos que você tenha gostado deste artigo e o achado útil. Se você tiver alguma dúvida ou sugestão, deixe nos comentários abaixo. Adoraria ouvir você!
Até a próxima!
Microsoft Tech Community – Latest Blogs –Read More
Solve more complex problems in matlab
Hello, I have the following problem: Determine m so that the equation (m-2)x²-3mx+(m+2)=0 has one positive root and one negative root.
I have written the following code and I am getting Empty sym: 0-by-1
syms x m
assume(m~=0);
eq = (m-2)*x^2-3*m*x+(m+2) == 0;
eq_roots = solve(eq, x);
x1 = eq_roots(1);
x2 = eq_roots(2);
cond1 = x1 < 0;
cond2 = 0 < x2;
s=solve([cond1, cond2], m, ‘Real’, true,’ReturnConditions’, true)
s.conditions
Is there any way to solve problems like this in matlab?
I am a beginner in matlab and I am using problems that I know how to solve mathematically to train the use of matlabHello, I have the following problem: Determine m so that the equation (m-2)x²-3mx+(m+2)=0 has one positive root and one negative root.
I have written the following code and I am getting Empty sym: 0-by-1
syms x m
assume(m~=0);
eq = (m-2)*x^2-3*m*x+(m+2) == 0;
eq_roots = solve(eq, x);
x1 = eq_roots(1);
x2 = eq_roots(2);
cond1 = x1 < 0;
cond2 = 0 < x2;
s=solve([cond1, cond2], m, ‘Real’, true,’ReturnConditions’, true)
s.conditions
Is there any way to solve problems like this in matlab?
I am a beginner in matlab and I am using problems that I know how to solve mathematically to train the use of matlab Hello, I have the following problem: Determine m so that the equation (m-2)x²-3mx+(m+2)=0 has one positive root and one negative root.
I have written the following code and I am getting Empty sym: 0-by-1
syms x m
assume(m~=0);
eq = (m-2)*x^2-3*m*x+(m+2) == 0;
eq_roots = solve(eq, x);
x1 = eq_roots(1);
x2 = eq_roots(2);
cond1 = x1 < 0;
cond2 = 0 < x2;
s=solve([cond1, cond2], m, ‘Real’, true,’ReturnConditions’, true)
s.conditions
Is there any way to solve problems like this in matlab?
I am a beginner in matlab and I am using problems that I know how to solve mathematically to train the use of matlab equation MATLAB Answers — New Questions
How do I get past grid parameter restrictions when trying to create custom training data for a YOLOv4 LIDAR object detection network?
I have been following and modifying the example for LIDAR Complex-YOLOv4 Object Detection, and I am running into an issue when creating training data using the createTrainingData.m file. The Standard pcRange block [xMin = -25.0 xMax = 25.0 yMin = 0.0 yMax = 50.0 zMin = -7.0 and zMax = 15.0] is too small for my data set, and the origin position cuts off most of the point cloud regions I want to capture (see image ROI_within_PointCloud). I would like to adjust the pcRange to allow for an ROI as seen in the attached image DesiredROI_2D_PointCloud.
When I drop the xMin and/or yMin values below the standard, i.e. xMin < -25 and/or yMin < 0, to capture the desired region I receive the following error:
———————————————————————————————————–
Error using sub2ind (line 71)
Out of range subscript.
Error in helper.preprocess (line 53)
mapIndices = sub2ind([bevHeight,bevWidth],locMod(:,1),locMod(:,2));
Error in createTrainingData (line 42)
[processedData,~] = helper.preprocess(ptCloud,gridParams);
———————————————————————————————————-
As far as I can tell after diving into the sub2ind function, this error is occuring due to v, the newly sorted array of points, failing this portion of the if statement: min(v,[],’all’) < 1. I can adjust xMax and yMax to be larger in the positive direction and have no issues.
How do I get past this issue and move/modify the region of interest within the point cloud scene? Can I adjust the origin location of the point cloud some how? Or can I remove the restriction on expanding the ROI into the negative quadrants?I have been following and modifying the example for LIDAR Complex-YOLOv4 Object Detection, and I am running into an issue when creating training data using the createTrainingData.m file. The Standard pcRange block [xMin = -25.0 xMax = 25.0 yMin = 0.0 yMax = 50.0 zMin = -7.0 and zMax = 15.0] is too small for my data set, and the origin position cuts off most of the point cloud regions I want to capture (see image ROI_within_PointCloud). I would like to adjust the pcRange to allow for an ROI as seen in the attached image DesiredROI_2D_PointCloud.
When I drop the xMin and/or yMin values below the standard, i.e. xMin < -25 and/or yMin < 0, to capture the desired region I receive the following error:
———————————————————————————————————–
Error using sub2ind (line 71)
Out of range subscript.
Error in helper.preprocess (line 53)
mapIndices = sub2ind([bevHeight,bevWidth],locMod(:,1),locMod(:,2));
Error in createTrainingData (line 42)
[processedData,~] = helper.preprocess(ptCloud,gridParams);
———————————————————————————————————-
As far as I can tell after diving into the sub2ind function, this error is occuring due to v, the newly sorted array of points, failing this portion of the if statement: min(v,[],’all’) < 1. I can adjust xMax and yMax to be larger in the positive direction and have no issues.
How do I get past this issue and move/modify the region of interest within the point cloud scene? Can I adjust the origin location of the point cloud some how? Or can I remove the restriction on expanding the ROI into the negative quadrants? I have been following and modifying the example for LIDAR Complex-YOLOv4 Object Detection, and I am running into an issue when creating training data using the createTrainingData.m file. The Standard pcRange block [xMin = -25.0 xMax = 25.0 yMin = 0.0 yMax = 50.0 zMin = -7.0 and zMax = 15.0] is too small for my data set, and the origin position cuts off most of the point cloud regions I want to capture (see image ROI_within_PointCloud). I would like to adjust the pcRange to allow for an ROI as seen in the attached image DesiredROI_2D_PointCloud.
When I drop the xMin and/or yMin values below the standard, i.e. xMin < -25 and/or yMin < 0, to capture the desired region I receive the following error:
———————————————————————————————————–
Error using sub2ind (line 71)
Out of range subscript.
Error in helper.preprocess (line 53)
mapIndices = sub2ind([bevHeight,bevWidth],locMod(:,1),locMod(:,2));
Error in createTrainingData (line 42)
[processedData,~] = helper.preprocess(ptCloud,gridParams);
———————————————————————————————————-
As far as I can tell after diving into the sub2ind function, this error is occuring due to v, the newly sorted array of points, failing this portion of the if statement: min(v,[],’all’) < 1. I can adjust xMax and yMax to be larger in the positive direction and have no issues.
How do I get past this issue and move/modify the region of interest within the point cloud scene? Can I adjust the origin location of the point cloud some how? Or can I remove the restriction on expanding the ROI into the negative quadrants? yolov4, matlab, object detection, grid, parameters, lidar, roi MATLAB Answers — New Questions
Box-Whisker Plot with 5 and 95 percentiles and non-symmetric distributions.
Dear all,
I have a 1000×2 matrix, M, where each column represents the data of two variables. I would like to plot a boxplot of the two distributions of the data, by specifying the length of the whiskers:
boxplot(M,’Whisker’,w)
However, I would like the upper and lower whiskers to represent the 5th and 95th percentiles respectively. In doing so, I have two problems:
Both the distributions are highly non-symmetric, therefore, the suggestion provided here does not work, since the multiplier w is not the same for the upper and lower whiskers.
Apparently, w can only takes on a scalar value, therefore, I cannot specify different multipliers for different distributions. Is there a way around this problem. In a follow up question of the same Q&A they suggest to use hold on, however the output is not good because of the overlapping of the figures.
It would be great if w could take the form of a 2xsize(M,2) array, in order to specify a specific multiplier for each distribution and for both the upper and lower whisker separately. However, I was not capable of editing in this way the original "boxplot" function.
Thanks in advance,
EdoardoDear all,
I have a 1000×2 matrix, M, where each column represents the data of two variables. I would like to plot a boxplot of the two distributions of the data, by specifying the length of the whiskers:
boxplot(M,’Whisker’,w)
However, I would like the upper and lower whiskers to represent the 5th and 95th percentiles respectively. In doing so, I have two problems:
Both the distributions are highly non-symmetric, therefore, the suggestion provided here does not work, since the multiplier w is not the same for the upper and lower whiskers.
Apparently, w can only takes on a scalar value, therefore, I cannot specify different multipliers for different distributions. Is there a way around this problem. In a follow up question of the same Q&A they suggest to use hold on, however the output is not good because of the overlapping of the figures.
It would be great if w could take the form of a 2xsize(M,2) array, in order to specify a specific multiplier for each distribution and for both the upper and lower whisker separately. However, I was not capable of editing in this way the original "boxplot" function.
Thanks in advance,
Edoardo Dear all,
I have a 1000×2 matrix, M, where each column represents the data of two variables. I would like to plot a boxplot of the two distributions of the data, by specifying the length of the whiskers:
boxplot(M,’Whisker’,w)
However, I would like the upper and lower whiskers to represent the 5th and 95th percentiles respectively. In doing so, I have two problems:
Both the distributions are highly non-symmetric, therefore, the suggestion provided here does not work, since the multiplier w is not the same for the upper and lower whiskers.
Apparently, w can only takes on a scalar value, therefore, I cannot specify different multipliers for different distributions. Is there a way around this problem. In a follow up question of the same Q&A they suggest to use hold on, however the output is not good because of the overlapping of the figures.
It would be great if w could take the form of a 2xsize(M,2) array, in order to specify a specific multiplier for each distribution and for both the upper and lower whisker separately. However, I was not capable of editing in this way the original "boxplot" function.
Thanks in advance,
Edoardo bow-whisker plot, confidence intervals MATLAB Answers — New Questions
How to model PID flow control with throttling (butterfly) valve in wells turbine in owc?
I want to model PID-controlled butterfly throttling valve to control the flow. the butterfly valve put before the well turbine to avoid the stalling ,this behavior which demonstrates when the flow coefficient surpasses a critical value
and how can i draw Airflow control scheme strategy for OWC plant equipped with Wells turbine like this in matlabI want to model PID-controlled butterfly throttling valve to control the flow. the butterfly valve put before the well turbine to avoid the stalling ,this behavior which demonstrates when the flow coefficient surpasses a critical value
and how can i draw Airflow control scheme strategy for OWC plant equipped with Wells turbine like this in matlab I want to model PID-controlled butterfly throttling valve to control the flow. the butterfly valve put before the well turbine to avoid the stalling ,this behavior which demonstrates when the flow coefficient surpasses a critical value
and how can i draw Airflow control scheme strategy for OWC plant equipped with Wells turbine like this in matlab owc, simulink, butterfly valve, pid controller MATLAB Answers — New Questions
Where do I find my sharepoint form?
I’m a bit confused!
I created a form, have a link to it on a page that looks like this:
If I click this link, it opens the form I created.
I don’ remember where I copied this link from.
I am trying to link to this form from another page. AND I want to edit the form – but can’t find where/how I do this!
Thanks in advance.
Amber
I’m a bit confused!I created a form, have a link to it on a page that looks like this: https://mycompany.sharepoint.com/:l:/s/ambertest/FKRPIB72pvNDvoC4t1TFCTMBitqYSm8AauzGLQbWGK9_Pg?nav=NGZkZDM2M2UtNjMyZi00OTRkLWE1ZGEtNTBkM2NlNGIyMjZl If I click this link, it opens the form I created.I don’ remember where I copied this link from. I am trying to link to this form from another page. AND I want to edit the form – but can’t find where/how I do this!Thanks in advance.Amber Read More
Critical tasks on Gantt chart view on SharePoint project Site
Hello,
We are on Project server 2019 on Premise system. The projects are published to the PWA and have connected a SharePoint site for the project. The SharePoint project Tasks page shows project schedule task in list. The Task list has a Gantt Chart view . Is there a way to see Critical tasks on Gantt chart view of Project task list?
If not, are there any possible ways we could extend Gantt view to show Critical task.
Hello, We are on Project server 2019 on Premise system. The projects are published to the PWA and have connected a SharePoint site for the project. The SharePoint project Tasks page shows project schedule task in list. The Task list has a Gantt Chart view . Is there a way to see Critical tasks on Gantt chart view of Project task list?If not, are there any possible ways we could extend Gantt view to show Critical task. Read More
Booking on off hours
I have been using the Booking calendar for a while now and more often than not, it allows people to schedule appointments that are not within the Booking hours. It even allows them to book on days where the schedule is set to closed for the day. It is becoming a major problem, as it requires us contacting that person and potentially rescheduling.
Do you know why this is happening and do you have an ETR? (expected time of resolution)
I have been using the Booking calendar for a while now and more often than not, it allows people to schedule appointments that are not within the Booking hours. It even allows them to book on days where the schedule is set to closed for the day. It is becoming a major problem, as it requires us contacting that person and potentially rescheduling. Do you know why this is happening and do you have an ETR? (expected time of resolution) Read More
Filtering a list and chart multiple series
Hello and thanks for any advice. I’ve simplified my scenario as below. A teacher and student have a walking contest over 7 days. Column A is date, Column B is role (i.e. teacher or student), Column C is miles walked. I would like to create a line chart with 2 data series comparing the teacher’s walking to the student’s walking.
Ideally, when selecting the data for each series, I could input a formula filtering Column B for either “teacher” or “student” and then plotting the associated ‘miles walked’, I’ve included a sample data set.
RoleMiles walked1/1/2001Teacher11/1/2001Student21/2/2001Teacher51/2/2001Student41/3/2001Teacher21/3/2001Student11/4/2001Teacher31/4/2001Student41/5/2001Teacher51/5/2001Student11/6/2001Teacher21/6/2001Student31/7/2001Teacher51/7/2001Student1
Hello and thanks for any advice. I’ve simplified my scenario as below. A teacher and student have a walking contest over 7 days. Column A is date, Column B is role (i.e. teacher or student), Column C is miles walked. I would like to create a line chart with 2 data series comparing the teacher’s walking to the student’s walking. Ideally, when selecting the data for each series, I could input a formula filtering Column B for either “teacher” or “student” and then plotting the associated ‘miles walked’, I’ve included a sample data set. RoleMiles walked1/1/2001Teacher11/1/2001Student21/2/2001Teacher51/2/2001Student41/3/2001Teacher21/3/2001Student11/4/2001Teacher31/4/2001Student41/5/2001Teacher51/5/2001Student11/6/2001Teacher21/6/2001Student31/7/2001Teacher51/7/2001Student1 Read More
Email Content Missing in Sent Emails
After sending an email, when I look at it in sent, some of the content is missing and if I forward the email to the same person, all the content is visible. This does not happen to all emails I send, no idea why this is happening, please help…BOB
After sending an email, when I look at it in sent, some of the content is missing and if I forward the email to the same person, all the content is visible. This does not happen to all emails I send, no idea why this is happening, please help…BOB Read More
Je n’ai plus accès à la formule IMAGE
Je suis sur la version 2408 (17928.20114). Depuis la dernière mise à jour je n’ai plus accès a la fonction “IMAGE” et donc plus la possibilité d’incruster une image via un lien URL dans les cellules concernées. Est-ce qu’une mise à jour visant à régler ce problème arrive ? ou est-ce qu’une autre formule de ce type peux venir remplacer temporairement ou définitivement la formule “IMAGE” ?
Je suis sur la version 2408 (17928.20114). Depuis la dernière mise à jour je n’ai plus accès a la fonction “IMAGE” et donc plus la possibilité d’incruster une image via un lien URL dans les cellules concernées. Est-ce qu’une mise à jour visant à régler ce problème arrive ? ou est-ce qu’une autre formule de ce type peux venir remplacer temporairement ou définitivement la formule “IMAGE” ? Read More
Compare string values and automate look-up (multi-step)
Hi,
I have a specific multi-step task I would like to automate in excel, ideally with the use of a formula.
I have four columns (A. application year, B. patent ID, C. backward citations and D. forward citations). Columns C and D contain strings (comma separated values).
First step:
1) For each row, I want to identify if there is a matching string value present in both column C and D. In column E (new column), I want to output the matching citation. E.g. in image file attached, cell E2 contains US1111, the string value that is present in both C2 and D2.
Second step (column F)
2) I want to then search for patent US1111 (value in E2) in column B (list of all patents) and identify it’s application year (column A).
Third step (column G)
3) If the output in F2 (matching citation year) is less than the value in A2, then the formula searches column B for value in E2 (US1111) and in the corresponding row, the output is “DELETE”.
An example in the data attached is
Row 2: In C2 and D2, the matching string/citation is US1111. Ideal Output in E2 is “US1111”.
Then formula in F2, searches for US1111 in column B and output’s it’s application year from column A (A16: 1994). Output in F2 = 1994.
Then in G2, new formula compares F2 (1994) to A2 (2024) and if F2<A2 (1994<2024), the formula searches for US1111 (E2) in column B and outputs “DELETE” in the corresponding row column G (G16 in our example spreadsheet as US1111 is located in B16.
any help would be greatly appreciated!
Many many thanks
Hi, I have a specific multi-step task I would like to automate in excel, ideally with the use of a formula. I have four columns (A. application year, B. patent ID, C. backward citations and D. forward citations). Columns C and D contain strings (comma separated values). First step:1) For each row, I want to identify if there is a matching string value present in both column C and D. In column E (new column), I want to output the matching citation. E.g. in image file attached, cell E2 contains US1111, the string value that is present in both C2 and D2. Second step (column F)2) I want to then search for patent US1111 (value in E2) in column B (list of all patents) and identify it’s application year (column A). Third step (column G)3) If the output in F2 (matching citation year) is less than the value in A2, then the formula searches column B for value in E2 (US1111) and in the corresponding row, the output is “DELETE”. An example in the data attached isRow 2: In C2 and D2, the matching string/citation is US1111. Ideal Output in E2 is “US1111”.Then formula in F2, searches for US1111 in column B and output’s it’s application year from column A (A16: 1994). Output in F2 = 1994.Then in G2, new formula compares F2 (1994) to A2 (2024) and if F2<A2 (1994<2024), the formula searches for US1111 (E2) in column B and outputs “DELETE” in the corresponding row column G (G16 in our example spreadsheet as US1111 is located in B16. any help would be greatly appreciated! Many many thanks Read More
Formating a cell in Excel based on multiple conditions
Social Media Posts Analysis:
I have a tabular columns on excel with days (1-31) in columns and the months (1-12) in rows, which looks like this:
The data to this feeds from another sheet in the same excel file. This data is basically saying the date on which a post was made on a social media:
I have made the tabular column (Image 1) using countifs function, where it automatically takes the day and month from the Date column and places it in appropriate cell in the 1st sheet.
For example:
Sheet1!B2=COUNTIFS(Sheet2!$D:$D,Sheet1!B$1,Sheet2!$E:$E,Sheet1!$A2)
Now my question is:
I want to format the tabular column (Image 1) as follows:
No Background color to cell -> If no posts have been made on this day and month at all or the day (DD) and month (MM) appears only in one year (there can be more than one post in the same date (DD/MM/YYYY), that is not a problem)Yellow -> If there are atleast two posts in the same day (DD) and month (MM) but in two separate years (YYYY)Green -> If there are atleast three posts in the same day (DD) and month (MM) but in three separate years (YYYY)
I hope that was clear. Please help me out if there are any methods to acheive this formating in Excel.
Let me know if you need any further clarfications.
Thanks in advance,
Eashwar
Social Media Posts Analysis:I have a tabular columns on excel with days (1-31) in columns and the months (1-12) in rows, which looks like this:The data to this feeds from another sheet in the same excel file. This data is basically saying the date on which a post was made on a social media: I have made the tabular column (Image 1) using countifs function, where it automatically takes the day and month from the Date column and places it in appropriate cell in the 1st sheet.For example:Sheet1!B2=COUNTIFS(Sheet2!$D:$D,Sheet1!B$1,Sheet2!$E:$E,Sheet1!$A2)Now my question is:I want to format the tabular column (Image 1) as follows:No Background color to cell -> If no posts have been made on this day and month at all or the day (DD) and month (MM) appears only in one year (there can be more than one post in the same date (DD/MM/YYYY), that is not a problem)Yellow -> If there are atleast two posts in the same day (DD) and month (MM) but in two separate years (YYYY)Green -> If there are atleast three posts in the same day (DD) and month (MM) but in three separate years (YYYY) I hope that was clear. Please help me out if there are any methods to acheive this formating in Excel.Let me know if you need any further clarfications. Thanks in advance,Eashwar Read More
Windows – unable to create a ‘Windows Hello’ PIN
Hi,
a new user is able to log-in using ’email address’ and set a PIN for ‘Windows Hello’, works fine.
But a local user migrated profile (using Profwiz) cannot add a PIN since the ‘login page’ shows as the imagem below and then close quickly.
I already tried:
1) WSRESET command to refresh connection to his cloud account, but no success;
2) Instruction from that article below regarding to reset folder ‘NGC’ permissions, but no success:
* this environment is ‘Windows 10 Pro’ or ‘Windows 11 Pro’ and the users has ‘M365 E3’ license.
Hi, a new user is able to log-in using ’email address’ and set a PIN for ‘Windows Hello’, works fine.But a local user migrated profile (using Profwiz) cannot add a PIN since the ‘login page’ shows as the imagem below and then close quickly. I already tried:1) WSRESET command to refresh connection to his cloud account, but no success;2) Instruction from that article below regarding to reset folder ‘NGC’ permissions, but no success:https://answers.microsoft.com/en-us/windows/forum/all/help-i-forgot-my-pin-for-windows-hello-and-i/537620d4-da87-4794-99f4-684931b036a0 * this environment is ‘Windows 10 Pro’ or ‘Windows 11 Pro’ and the users has ‘M365 E3’ license. Read More
Editor lacking in New Outlook
Unless I am missing something, I find the New Outlook (which I’ve been using for about a year) very lacking when it comes to formatting an email. In the classic Outlook I believe I had the full Microsoft Word functionality whereas that is not the case with the New Outlook. Is there a way to get full Microsoft Word functionality when creating an email in the New Outlook?
Unless I am missing something, I find the New Outlook (which I’ve been using for about a year) very lacking when it comes to formatting an email. In the classic Outlook I believe I had the full Microsoft Word functionality whereas that is not the case with the New Outlook. Is there a way to get full Microsoft Word functionality when creating an email in the New Outlook? Read More
What’s the quality of the matlab orbit propagation?
Do orbvital toolkits include earth, sun moon, planets?
Do they include earth gravity perturbations?
Do they include atmospheric drag? As function of lat-lon sun angle and solar F10.7?
Do they include variable drag as function of satellite shape and aspect?Do orbvital toolkits include earth, sun moon, planets?
Do they include earth gravity perturbations?
Do they include atmospheric drag? As function of lat-lon sun angle and solar F10.7?
Do they include variable drag as function of satellite shape and aspect? Do orbvital toolkits include earth, sun moon, planets?
Do they include earth gravity perturbations?
Do they include atmospheric drag? As function of lat-lon sun angle and solar F10.7?
Do they include variable drag as function of satellite shape and aspect? orbit precision MATLAB Answers — New Questions
