Month: June 2024
BUG: MS Edge and other web apps installed with Edge lag on Ubuntu 20.04 and above
When using any web app installed via MS Edge or having even a single tab open on the browser, the browser lags for a few seconds after opening the App tray in Ubuntu 20.04 and above. The window becomes completely unresponsive for a few second and any action made during that time, like scroll or text input are reflected post that time and then the window works completely fine.
Device Info:
.-/+oossssoo+/-. aaryan@spectre-noble
`:+ssssssssssssssssss+:` ——————–
-+ssssssssssssssssssyyssss+- OS: Ubuntu 24.04 LTS x86_64
.ossssssssssssssssssdMMMNysssso. Host: HP Spectre x360 2-in-1 Laptop 14-ef2xxx
/ssssssssssshdmmNNmmyNMMMMhssssss/ Kernel: 6.8.0-36-generic
+ssssssssshmydMMMMMMMNddddyssssssss+ Uptime: 1 hour, 39 mins
/sssssssshNMMMyhhyyyyhmNMMMNhssssssss/ Packages: 2018 (dpkg), 15 (snap)
.ssssssssdMMMNhsssssssssshNMMMdssssssss. Shell: bash 5.2.21
+sssshhhyNMMNyssssssssssssyNMMMysssssss+ Resolution: 3000×2000
ossyNMMMNyMMhsssssssssssssshmmmhssssssso DE: GNOME 46.0
ossyNMMMNyMMhsssssssssssssshmmmhssssssso WM: Mutter
+sssshhhyNMMNyssssssssssssyNMMMysssssss+ WM Theme: Adwaita
.ssssssssdMMMNhsssssssssshNMMMdssssssss. Theme: Yaru-prussiangreen-dark [GTK2/3]
/sssssssshNMMMyhhyyyyhdNMMMNhssssssss/ Icons: Yaru-prussiangreen-dark [GTK2/3]
+sssssssssdmydMMMMMMMMddddyssssssss+ Terminal: gnome-terminal
/ssssssssssshdmNNNNmyNMMMMhssssss/ CPU: 13th Gen Intel i7-1355U (12) @ 5.000GHz
.ossssssssssssssssssdMMMNysssso. GPU: Intel Raptor Lake-P [Iris Xe Graphics]
-+sssssssssssssssssyyyssss+- Memory: 10199MiB / 31790MiB
`:+ssssssssssssssssss+:`
.-/+oossssoo+/-.
When using any web app installed via MS Edge or having even a single tab open on the browser, the browser lags for a few seconds after opening the App tray in Ubuntu 20.04 and above. The window becomes completely unresponsive for a few second and any action made during that time, like scroll or text input are reflected post that time and then the window works completely fine.Device Info: .-/+oossssoo+/-. aaryan@spectre-noble
`:+ssssssssssssssssss+:` ——————–
-+ssssssssssssssssssyyssss+- OS: Ubuntu 24.04 LTS x86_64
.ossssssssssssssssssdMMMNysssso. Host: HP Spectre x360 2-in-1 Laptop 14-ef2xxx
/ssssssssssshdmmNNmmyNMMMMhssssss/ Kernel: 6.8.0-36-generic
+ssssssssshmydMMMMMMMNddddyssssssss+ Uptime: 1 hour, 39 mins
/sssssssshNMMMyhhyyyyhmNMMMNhssssssss/ Packages: 2018 (dpkg), 15 (snap)
.ssssssssdMMMNhsssssssssshNMMMdssssssss. Shell: bash 5.2.21
+sssshhhyNMMNyssssssssssssyNMMMysssssss+ Resolution: 3000×2000
ossyNMMMNyMMhsssssssssssssshmmmhssssssso DE: GNOME 46.0
ossyNMMMNyMMhsssssssssssssshmmmhssssssso WM: Mutter
+sssshhhyNMMNyssssssssssssyNMMMysssssss+ WM Theme: Adwaita
.ssssssssdMMMNhsssssssssshNMMMdssssssss. Theme: Yaru-prussiangreen-dark [GTK2/3]
/sssssssshNMMMyhhyyyyhdNMMMNhssssssss/ Icons: Yaru-prussiangreen-dark [GTK2/3]
+sssssssssdmydMMMMMMMMddddyssssssss+ Terminal: gnome-terminal
/ssssssssssshdmNNNNmyNMMMMhssssss/ CPU: 13th Gen Intel i7-1355U (12) @ 5.000GHz
.ossssssssssssssssssdMMMNysssso. GPU: Intel Raptor Lake-P [Iris Xe Graphics]
-+sssssssssssssssssyyyssss+- Memory: 10199MiB / 31790MiB
`:+ssssssssssssssssss+:`
.-/+oossssoo+/-.
Read More
Calculate hours between start date and end date, but if no end date is provided use now
Date of Incident Date of Resolution Total Downtime (Hrs)
21/06/2024 08:3021/06/2024 11:303:0021/06/2024 10:0023/06/2024 10:0048:0025/06/2024 04:01 1091266:08
The spreadsheet is meant to calculate time between Date of Incident and Date of Resolution.
But if there’s no Date of Resolution it should use todays date and time.
However it gives a value that’s wildly inaccurate values
Date of Incident Date of Resolution Total Downtime (Hrs)21/06/2024 08:3021/06/2024 11:303:0021/06/2024 10:0023/06/2024 10:0048:0025/06/2024 04:01 1091266:08 The spreadsheet is meant to calculate time between Date of Incident and Date of Resolution. But if there’s no Date of Resolution it should use todays date and time.However it gives a value that’s wildly inaccurate values Read More
Outlook keeps crashing while on background (Macbook)
Hi everyone, I have a problem with latest versions of Outlook desktop client for Mac. I’m using version 16.86.2 (24062313) and when I open the application and keep it in background, after 10 or 20 mins it suddenly closes automatically with no message appearing on the screen. This is bad because I loose all reminders from my calendar related to work meetings and other stuff.
I’ve already tried to uninstall the application, delete all cache and temporary files, restart the mac and reinstall. I can’t find the option to clear cache as reported here https://support.microsoft.com/en-gb/office/clear-the-cache-in-outlook-for-mac-6f230dfa-7f12-4606-bb1a-55ee19087033
Can I try a different way?
Hi everyone, I have a problem with latest versions of Outlook desktop client for Mac. I’m using version 16.86.2 (24062313) and when I open the application and keep it in background, after 10 or 20 mins it suddenly closes automatically with no message appearing on the screen. This is bad because I loose all reminders from my calendar related to work meetings and other stuff. I’ve already tried to uninstall the application, delete all cache and temporary files, restart the mac and reinstall. I can’t find the option to clear cache as reported here https://support.microsoft.com/en-gb/office/clear-the-cache-in-outlook-for-mac-6f230dfa-7f12-4606-bb1a-55ee19087033 Can I try a different way? Read More
Several errors Desktop, Exploeer.exe crashing
Whenever I use the full screen in any application I keep getting: This causes the full screen application to hang for anywhere 3-10 seconds with it lately getting worse. I noticed that it gets worse when I’m out of ram. This happens every 5-15min. Explorere.exe crashing can cause other things to crash a coupe of seconds later.
Whenever I do anything, take a screenshot, or tab back out from a game my desktop looks like:
Or they look like: I hover over them with my mouse, then go off it and it doesn’t remove the highlight, but I can apply it again.
Or missing icons in the taskbar.
I have all the latest drivers from Nvidia. I have no group policy, I have ran disk checks (no errors ever) and no corruption of the SSD.
Additional information: running on a MSI laptop RTX 3080Ti with 1440p 244hz screen and 4k extra screen to the side.
This has been going on for over 2 months.
Whenever I use the full screen in any application I keep getting: This causes the full screen application to hang for anywhere 3-10 seconds with it lately getting worse. I noticed that it gets worse when I’m out of ram. This happens every 5-15min. Explorere.exe crashing can cause other things to crash a coupe of seconds later. Whenever I do anything, take a screenshot, or tab back out from a game my desktop looks like:Or they look like: I hover over them with my mouse, then go off it and it doesn’t remove the highlight, but I can apply it again. Or missing icons in the taskbar. I have all the latest drivers from Nvidia. I have no group policy, I have ran disk checks (no errors ever) and no corruption of the SSD. Additional information: running on a MSI laptop RTX 3080Ti with 1440p 244hz screen and 4k extra screen to the side. This has been going on for over 2 months. Read More
MS Projects – Conversation function
Are there plans, via the conversation function, to be able to ONLY chat with specific individuals rather than the message coming up in the main chat (similar to JIRA/Atlassian)
Are there plans, via the conversation function, to be able to ONLY chat with specific individuals rather than the message coming up in the main chat (similar to JIRA/Atlassian) Read More
Laplacian sharpening filter in frequency domain
Hello everybody, I have written a code to do sharpening in frequency domain with Laplacian filter. The point is theLaplacian must be be between-1,1. Therefore it was divided to its max. I don’t know why it doesn’t work. I was wondering if anyone has any experience how to fix this problem? clear
close all
clc
a=imread(‘moon.tif’);
a=im2double(a);
subplot(2,3,1);
imshow(a);
title(‘Input image’);
[m,n]=size(a);
A=fft2(a);
subplot(2,3,2);
imshow(uint8(abs(A)));
title(‘F.T. of i/p without shift’);
A_shift=fftshift(A);
A_real=abs(A_shift);
subplot(2,3,3);
imshow(uint8(A_real));
title(‘F.T. of i/p after shift’);
A_high=zeros(m,n);
D=zeros(m,n);
for u=1:m
for v=1:n
H(u,v)=-4*(pi^2)*((u-(m./2))^2+(v-(n./2))^2);
end
end
% Get maximum value of Laplacian
max_val = max(abs(H),[],’all’);
% Normalize Laplacian to range [-1,1]
H_normalized = H / max_val;
% Compute inverse Fourier transform
Laplacian_inverse = ifft2((H_normalized.*A_shift));
% Get real part of Laplacian inverse
Laplacian_real = abs(Laplacian_inverse);
subplot(2,3,4);
imshow(H);
title(‘Laplacian filter’);
subplot(2,3,5);
mesh(H)
title(‘Surface plot BHPF’);
subplot(2,3,6);
imshow(uint8(Laplacian_real));
title(‘Laplacian HP filtered image’);Hello everybody, I have written a code to do sharpening in frequency domain with Laplacian filter. The point is theLaplacian must be be between-1,1. Therefore it was divided to its max. I don’t know why it doesn’t work. I was wondering if anyone has any experience how to fix this problem? clear
close all
clc
a=imread(‘moon.tif’);
a=im2double(a);
subplot(2,3,1);
imshow(a);
title(‘Input image’);
[m,n]=size(a);
A=fft2(a);
subplot(2,3,2);
imshow(uint8(abs(A)));
title(‘F.T. of i/p without shift’);
A_shift=fftshift(A);
A_real=abs(A_shift);
subplot(2,3,3);
imshow(uint8(A_real));
title(‘F.T. of i/p after shift’);
A_high=zeros(m,n);
D=zeros(m,n);
for u=1:m
for v=1:n
H(u,v)=-4*(pi^2)*((u-(m./2))^2+(v-(n./2))^2);
end
end
% Get maximum value of Laplacian
max_val = max(abs(H),[],’all’);
% Normalize Laplacian to range [-1,1]
H_normalized = H / max_val;
% Compute inverse Fourier transform
Laplacian_inverse = ifft2((H_normalized.*A_shift));
% Get real part of Laplacian inverse
Laplacian_real = abs(Laplacian_inverse);
subplot(2,3,4);
imshow(H);
title(‘Laplacian filter’);
subplot(2,3,5);
mesh(H)
title(‘Surface plot BHPF’);
subplot(2,3,6);
imshow(uint8(Laplacian_real));
title(‘Laplacian HP filtered image’); Hello everybody, I have written a code to do sharpening in frequency domain with Laplacian filter. The point is theLaplacian must be be between-1,1. Therefore it was divided to its max. I don’t know why it doesn’t work. I was wondering if anyone has any experience how to fix this problem? clear
close all
clc
a=imread(‘moon.tif’);
a=im2double(a);
subplot(2,3,1);
imshow(a);
title(‘Input image’);
[m,n]=size(a);
A=fft2(a);
subplot(2,3,2);
imshow(uint8(abs(A)));
title(‘F.T. of i/p without shift’);
A_shift=fftshift(A);
A_real=abs(A_shift);
subplot(2,3,3);
imshow(uint8(A_real));
title(‘F.T. of i/p after shift’);
A_high=zeros(m,n);
D=zeros(m,n);
for u=1:m
for v=1:n
H(u,v)=-4*(pi^2)*((u-(m./2))^2+(v-(n./2))^2);
end
end
% Get maximum value of Laplacian
max_val = max(abs(H),[],’all’);
% Normalize Laplacian to range [-1,1]
H_normalized = H / max_val;
% Compute inverse Fourier transform
Laplacian_inverse = ifft2((H_normalized.*A_shift));
% Get real part of Laplacian inverse
Laplacian_real = abs(Laplacian_inverse);
subplot(2,3,4);
imshow(H);
title(‘Laplacian filter’);
subplot(2,3,5);
mesh(H)
title(‘Surface plot BHPF’);
subplot(2,3,6);
imshow(uint8(Laplacian_real));
title(‘Laplacian HP filtered image’); frequency MATLAB Answers — New Questions
Simulink model: how to get cameraParams?
Hello,
so im building this simulink model in which I need the cameraParameters for computation. I tried the constant block to load the cameraParams in, but sadly the structure of the cameraParams is so convoluted, that It doesnt work.
Can Someone show me an easy way to get the cameraParams into the simulink model?
Thank you for any help!Hello,
so im building this simulink model in which I need the cameraParameters for computation. I tried the constant block to load the cameraParams in, but sadly the structure of the cameraParams is so convoluted, that It doesnt work.
Can Someone show me an easy way to get the cameraParams into the simulink model?
Thank you for any help! Hello,
so im building this simulink model in which I need the cameraParameters for computation. I tried the constant block to load the cameraParams in, but sadly the structure of the cameraParams is so convoluted, that It doesnt work.
Can Someone show me an easy way to get the cameraParams into the simulink model?
Thank you for any help! simulink, cameraparameters, image analysis, image processing MATLAB Answers — New Questions
error in using psat
Access to an object’s fields is only permitted within its methods.
Error in PVclass/setup_pv (line 54)
a.vbus = a.bus + Bus.n;
Error in fm_ncomp (line 37)
PV = setup_pv(PV);
Error in fm_spf (line 33)
fm_ncomp
Error in fm_set (line 720)
fm_spf
Error while evaluating UIControl Callback.
I got this error during load flow perform in matlab 2016a using psat 2.1.10Access to an object’s fields is only permitted within its methods.
Error in PVclass/setup_pv (line 54)
a.vbus = a.bus + Bus.n;
Error in fm_ncomp (line 37)
PV = setup_pv(PV);
Error in fm_spf (line 33)
fm_ncomp
Error in fm_set (line 720)
fm_spf
Error while evaluating UIControl Callback.
I got this error during load flow perform in matlab 2016a using psat 2.1.10 Access to an object’s fields is only permitted within its methods.
Error in PVclass/setup_pv (line 54)
a.vbus = a.bus + Bus.n;
Error in fm_ncomp (line 37)
PV = setup_pv(PV);
Error in fm_spf (line 33)
fm_ncomp
Error in fm_set (line 720)
fm_spf
Error while evaluating UIControl Callback.
I got this error during load flow perform in matlab 2016a using psat 2.1.10 psat matlab, simulink MATLAB Answers — New Questions
Unrecognized function or variable ‘fpval’.
Hello
Can you please guide me on how to fix the following error:
Unrecognized function or variable ‘fpval’.
Error in stepwisefit>stepcalc (line 368)
pval = fpval(fstat,df0,dfe);
Error in stepwisefit (line 150)
[B,SE,PVAL,stats] = stepcalc(allx,y,in);
Error in newrobuststepwise (line 28)
[b,se,pval1,inmodel1,stats,nextstep,history] = stepwisefit(Xdata,Ydata);
I used a stepwise function whose parameter pval is one of its outputsHello
Can you please guide me on how to fix the following error:
Unrecognized function or variable ‘fpval’.
Error in stepwisefit>stepcalc (line 368)
pval = fpval(fstat,df0,dfe);
Error in stepwisefit (line 150)
[B,SE,PVAL,stats] = stepcalc(allx,y,in);
Error in newrobuststepwise (line 28)
[b,se,pval1,inmodel1,stats,nextstep,history] = stepwisefit(Xdata,Ydata);
I used a stepwise function whose parameter pval is one of its outputs Hello
Can you please guide me on how to fix the following error:
Unrecognized function or variable ‘fpval’.
Error in stepwisefit>stepcalc (line 368)
pval = fpval(fstat,df0,dfe);
Error in stepwisefit (line 150)
[B,SE,PVAL,stats] = stepcalc(allx,y,in);
Error in newrobuststepwise (line 28)
[b,se,pval1,inmodel1,stats,nextstep,history] = stepwisefit(Xdata,Ydata);
I used a stepwise function whose parameter pval is one of its outputs stepwisefit, fpval MATLAB Answers — New Questions
Writing an Article on Balayage vs. Ombre Hair
I need to create an article explaining the differences between balayage and ombre hair techniques. Both methods are popular, but many people confuse them.
#### Problem
My English writing skills are not strong enough to write the article. I struggle with grammar, vocabulary, and organizing content coherently. Additionally, I’m not confident in researching and presenting technical details accurately.
#### Need
I need help generating a clear, well-written, and informative article on Balayage vs. Ombre Hair.
I need to create an article explaining the differences between balayage and ombre hair techniques. Both methods are popular, but many people confuse them.#### ProblemMy English writing skills are not strong enough to write the article. I struggle with grammar, vocabulary, and organizing content coherently. Additionally, I’m not confident in researching and presenting technical details accurately.#### NeedI need help generating a clear, well-written, and informative article on Balayage vs. Ombre Hair. Read More
Embed Web from internal server (intranet) (http) in SharePoint Online
Is there a way to embed a web that is from internal server?
I want to embed from http://[address]/ but it always gets error.
I also try using iframe-based embed code and get this error.
Thank you
Is there a way to embed a web that is from internal server?I want to embed from http://[address]/ but it always gets error.I also try using iframe-based embed code and get this error.Thank you Read More
Microsoft 365 Retention Policy or Exchange (Legacy) Policy in Exchange Online for In-Place Archiving
Hi,
Just a doubt, im trying to implement for automation of moving primary inbox to In-place Archive mailbox,
should i use the retention tags/ policy under Exchange(Legacy) in DLM on Microsoft Purview Compliance?
Or would the newer Microsoft 365 Retention Policy/Label be able to do this automation too?
Thanks!
Hi, Just a doubt, im trying to implement for automation of moving primary inbox to In-place Archive mailbox,should i use the retention tags/ policy under Exchange(Legacy) in DLM on Microsoft Purview Compliance? Or would the newer Microsoft 365 Retention Policy/Label be able to do this automation too? Thanks! Read More
Struggling with Rack Server and Windows 11. Any Advice?
Hello everyone,
I’m having some trouble with my rack server setup and Windows 11, and I could really use some advice. Here are the main issues I’m encountering:
Compatibility: It seems like there might be some compatibility issues between my rack server hardware and Windows 11. Certain drivers are not installing correctly, and some hardware isn’t being recognized.Performance: Since upgrading to Windows 11, I’ve noticed a significant drop in performance. Tasks that used to run smoothly on Windows 10 are now sluggish, and I’m experiencing frequent lag.Networking: Setting up the network configurations has been more challenging than expected. There are intermittent connectivity issues, and network speeds are not consistent.Security: The security settings in Windows 11 are different, and I’m having trouble configuring them to match my previous setup. Some of the security features seem to be interfering with server operations.Software Compatibility: Some of the software that I was using on Windows 10 isn’t working correctly on Windows 11. There are compatibility issues, and I haven’t found suitable replacements or updates yet.
Has anyone else faced similar problems? If so, how did you resolve them? Are there any specific settings or configurations I should look into? Any tips on optimizing performance and ensuring compatibility would be greatly appreciated.
Thanks in advance for your help!
Hello everyone,I’m having some trouble with my rack server setup and Windows 11, and I could really use some advice. Here are the main issues I’m encountering:Compatibility: It seems like there might be some compatibility issues between my rack server hardware and Windows 11. Certain drivers are not installing correctly, and some hardware isn’t being recognized.Performance: Since upgrading to Windows 11, I’ve noticed a significant drop in performance. Tasks that used to run smoothly on Windows 10 are now sluggish, and I’m experiencing frequent lag.Networking: Setting up the network configurations has been more challenging than expected. There are intermittent connectivity issues, and network speeds are not consistent.Security: The security settings in Windows 11 are different, and I’m having trouble configuring them to match my previous setup. Some of the security features seem to be interfering with server operations.Software Compatibility: Some of the software that I was using on Windows 10 isn’t working correctly on Windows 11. There are compatibility issues, and I haven’t found suitable replacements or updates yet.Has anyone else faced similar problems? If so, how did you resolve them? Are there any specific settings or configurations I should look into? Any tips on optimizing performance and ensuring compatibility would be greatly appreciated.Thanks in advance for your help! Read More
In-Place upgrade to Windows 11 from Windows 10 If PC not compatible
Hi all,
I was prompted on Windows 10 to upgrade to Windows 11 as Windows 10 will end of life soon. The problem is that my PC is not compatible with Windows 11 (No TPM 2.0). Is there any way to in-place upgrade to Windows 11 if the device is not compatible?
I don’t want to clean install Windows 11 from USB drive because I don’t want to lost data and keep the current apps running.
Let me know if there are reliable options out there.
Thanks
Hi all, I was prompted on Windows 10 to upgrade to Windows 11 as Windows 10 will end of life soon. The problem is that my PC is not compatible with Windows 11 (No TPM 2.0). Is there any way to in-place upgrade to Windows 11 if the device is not compatible? I don’t want to clean install Windows 11 from USB drive because I don’t want to lost data and keep the current apps running. Let me know if there are reliable options out there. Thanks Read More
QueryTables bug for Excel 2019 and Excel 2021
I wrote a VBA code to download stock data from Yahoo Finance. To explain the bug that I discovered, I wrote the following VBA program. The VBA program downloads data for stock symbols SPY, XXX, and QQQ from the Yahoo Finance website and displays the downloaded data on sheet 1. Because the stock symbol XXX does not exist, the QueryTables to download the data of Stock XXX will generate an error. I used “On Error Resume Next” to ignore the error and move to the next line of the program to download data for stock QQQ. For Excel 2010, if the query to download data of a stock fails because the Yahoo Finance web server does not have the data., the next downloads for other stocks can still work. But, for Excel 2019 and Excel 2021. maybe other Excel of newer versions too, if a query for a stock fails, all next queries for other stocks will fail unless I restart Excel. I tested the problem in Windows 10 and 11, and the results are the same. Do any people know why new versions of Excel have this problem while Excel 2010 does not? I would appreciate it if someone could help me to solve this problem.
I need to download data for over a hundred stocks. Data for some stock symbols are sometimes missing in Yahoo Finance. Because of the bug, if the download for one stock ticker fails, I have to restart Excel and download the data from the beginning again.
************************************************************
Private Sub Download_From_Yahoo_Click()
On Error Resume Next
Dim web_Link As String
‘Download Data for Stock Symbol SPY
web_Link = “https://query1.finance.yahoo.com/v7/finance/download/SPY?period1=1687851663&period2=1719474063&interval=1d&events=history&includeAdjustedClose=true“
With Sheet1.QueryTables.Add(Connection:=”TEXT;” & web_Link, _
Destination:=Sheet1.Range(“A1”))
.Name = “import_1”
.FieldNames = True ‘ field names in source data appear as column headers
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 1252
.TextFileStartRow = 1 ‘ Start data from row 2 to exclude headings
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False
End With
‘ Download Data for Stock Symobol XXX
web_Link = “https://query1.finance.yahoo.com/v7/finance/download/XXX?period1=1687851663&period2=1719474063&interval=1d&events=history&includeAdjustedClose=true“
With Sheet1.QueryTables.Add(Connection:=”TEXT;” & web_Link, _
Destination:=Sheet1.Range(“I1”))
.Name = “import_2”
.FieldNames = True ‘ field names in source data appear as column headers
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 1252
.TextFileStartRow = 1 ‘ Start data from row 2 to exclude headings
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False
End With
‘ Download Data for Stock Symobol QQQ
web_Link = “https://query1.finance.yahoo.com/v7/finance/download/QQQ?period1=1687851663&period2=1719474063&interval=1d&events=history&includeAdjustedClose=true“
With Sheet1.QueryTables.Add(Connection:=”TEXT;” & web_Link, _
Destination:=Sheet1.Range(“Q1”))
.Name = “import_3”
.FieldNames = True ‘ field names in source data appear as column headers
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 1252
.TextFileStartRow = 1 ‘ Start data from row 2 to exclude headings
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False
End With
End Sub
I wrote a VBA code to download stock data from Yahoo Finance. To explain the bug that I discovered, I wrote the following VBA program. The VBA program downloads data for stock symbols SPY, XXX, and QQQ from the Yahoo Finance website and displays the downloaded data on sheet 1. Because the stock symbol XXX does not exist, the QueryTables to download the data of Stock XXX will generate an error. I used “On Error Resume Next” to ignore the error and move to the next line of the program to download data for stock QQQ. For Excel 2010, if the query to download data of a stock fails because the Yahoo Finance web server does not have the data., the next downloads for other stocks can still work. But, for Excel 2019 and Excel 2021. maybe other Excel of newer versions too, if a query for a stock fails, all next queries for other stocks will fail unless I restart Excel. I tested the problem in Windows 10 and 11, and the results are the same. Do any people know why new versions of Excel have this problem while Excel 2010 does not? I would appreciate it if someone could help me to solve this problem.I need to download data for over a hundred stocks. Data for some stock symbols are sometimes missing in Yahoo Finance. Because of the bug, if the download for one stock ticker fails, I have to restart Excel and download the data from the beginning again.************************************************************Private Sub Download_From_Yahoo_Click()On Error Resume NextDim web_Link As String’Download Data for Stock Symbol SPYweb_Link = “https://query1.finance.yahoo.com/v7/finance/download/SPY?period1=1687851663&period2=1719474063&interval=1d&events=history&includeAdjustedClose=true”With Sheet1.QueryTables.Add(Connection:=”TEXT;” & web_Link, _Destination:=Sheet1.Range(“A1”)).Name = “import_1”.FieldNames = True ‘ field names in source data appear as column headers.RowNumbers = False.FillAdjacentFormulas = False.PreserveFormatting = True.RefreshOnFileOpen = False.RefreshStyle = xlOverwriteCells.SavePassword = False.SaveData = True.AdjustColumnWidth = True.RefreshPeriod = 0.TextFilePromptOnRefresh = False.TextFilePlatform = 1252.TextFileStartRow = 1 ‘ Start data from row 2 to exclude headings.TextFileParseType = xlDelimited.TextFileTextQualifier = xlTextQualifierDoubleQuote.TextFileConsecutiveDelimiter = False.TextFileTabDelimiter = True.TextFileSemicolonDelimiter = False.TextFileCommaDelimiter = True.TextFileSpaceDelimiter = False.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1).TextFileTrailingMinusNumbers = True.Refresh BackgroundQuery:=FalseEnd With’ Download Data for Stock Symobol XXXweb_Link = “https://query1.finance.yahoo.com/v7/finance/download/XXX?period1=1687851663&period2=1719474063&interval=1d&events=history&includeAdjustedClose=true”With Sheet1.QueryTables.Add(Connection:=”TEXT;” & web_Link, _Destination:=Sheet1.Range(“I1”)).Name = “import_2”.FieldNames = True ‘ field names in source data appear as column headers.RowNumbers = False.FillAdjacentFormulas = False.PreserveFormatting = True.RefreshOnFileOpen = False.RefreshStyle = xlOverwriteCells.SavePassword = False.SaveData = True.AdjustColumnWidth = True.RefreshPeriod = 0.TextFilePromptOnRefresh = False.TextFilePlatform = 1252.TextFileStartRow = 1 ‘ Start data from row 2 to exclude headings.TextFileParseType = xlDelimited.TextFileTextQualifier = xlTextQualifierDoubleQuote.TextFileConsecutiveDelimiter = False.TextFileTabDelimiter = True.TextFileSemicolonDelimiter = False.TextFileCommaDelimiter = True.TextFileSpaceDelimiter = False.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1).TextFileTrailingMinusNumbers = True.Refresh BackgroundQuery:=FalseEnd With’ Download Data for Stock Symobol QQQweb_Link = “https://query1.finance.yahoo.com/v7/finance/download/QQQ?period1=1687851663&period2=1719474063&interval=1d&events=history&includeAdjustedClose=true”With Sheet1.QueryTables.Add(Connection:=”TEXT;” & web_Link, _Destination:=Sheet1.Range(“Q1”)).Name = “import_3”.FieldNames = True ‘ field names in source data appear as column headers.RowNumbers = False.FillAdjacentFormulas = False.PreserveFormatting = True.RefreshOnFileOpen = False.RefreshStyle = xlOverwriteCells.SavePassword = False.SaveData = True.AdjustColumnWidth = True.RefreshPeriod = 0.TextFilePromptOnRefresh = False.TextFilePlatform = 1252.TextFileStartRow = 1 ‘ Start data from row 2 to exclude headings.TextFileParseType = xlDelimited.TextFileTextQualifier = xlTextQualifierDoubleQuote.TextFileConsecutiveDelimiter = False.TextFileTabDelimiter = True.TextFileSemicolonDelimiter = False.TextFileCommaDelimiter = True.TextFileSpaceDelimiter = False.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1).TextFileTrailingMinusNumbers = True.Refresh BackgroundQuery:=FalseEnd WithEnd Sub Read More
ASR rule “Block Win32 API calls from Office macro Block XLS
Hi All, we have deploy defender for Endpoint in customer organization and the rule “ASR rule “Block Win32 API calls from Office macro” block old version of Excel with macro, we set exclusion for a path that contain this file but problem persist.
If we convert this file into new version of Excel problem not appears, there is a solution for this problem or we need to convert all files into new version ?
Many Thanks
Guido
Hi All, we have deploy defender for Endpoint in customer organization and the rule “ASR rule “Block Win32 API calls from Office macro” block old version of Excel with macro, we set exclusion for a path that contain this file but problem persist.If we convert this file into new version of Excel problem not appears, there is a solution for this problem or we need to convert all files into new version ? Many Thanks Guido Read More
Visualization of InterCellThermal connections in battery pack?
Hi,
I have created a 5S5P lithium ion battery pack with cylindrical cells using square topology. I have set the ambient thermal path to "cell based thermal resistance". In the module properties ,it says number of inter cell thermal connections are 20 and number of inter parallel assembly thermal connections are 52. My question is,
How these 20 and 52 thermal connections are happening? How can i visualize it? I don’t understand the matrix form of the above mentioned connections.
How the thermal resistance for each cell is calculated here? I want to model forced air convection. Is the pre set value of 1K/W goes well for my model?
How cell level ambient path thermal resistance is set as 25 K/W?How is it different from point number 2?
I have attached the image also for further reference.
Thank you.
SudeepHi,
I have created a 5S5P lithium ion battery pack with cylindrical cells using square topology. I have set the ambient thermal path to "cell based thermal resistance". In the module properties ,it says number of inter cell thermal connections are 20 and number of inter parallel assembly thermal connections are 52. My question is,
How these 20 and 52 thermal connections are happening? How can i visualize it? I don’t understand the matrix form of the above mentioned connections.
How the thermal resistance for each cell is calculated here? I want to model forced air convection. Is the pre set value of 1K/W goes well for my model?
How cell level ambient path thermal resistance is set as 25 K/W?How is it different from point number 2?
I have attached the image also for further reference.
Thank you.
Sudeep Hi,
I have created a 5S5P lithium ion battery pack with cylindrical cells using square topology. I have set the ambient thermal path to "cell based thermal resistance". In the module properties ,it says number of inter cell thermal connections are 20 and number of inter parallel assembly thermal connections are 52. My question is,
How these 20 and 52 thermal connections are happening? How can i visualize it? I don’t understand the matrix form of the above mentioned connections.
How the thermal resistance for each cell is calculated here? I want to model forced air convection. Is the pre set value of 1K/W goes well for my model?
How cell level ambient path thermal resistance is set as 25 K/W?How is it different from point number 2?
I have attached the image also for further reference.
Thank you.
Sudeep simscape battery, thermal resistance, heat transfer, thermal modeling MATLAB Answers — New Questions
Multiple language on custom tab
I have created my own Custom tab using Json files i have file Structure as
resources >> sl_toolstrip_plugins.json
>>json >> customTab.json
>> customTab_actions.json
>>arasTab_popups.json
from this structure i am loading my custom tab but when i change language of matlab all other tabs change language except custom tab.
how can i add Json of that language or how can i load my custom tab in that language. . . .?
how can i change language of my custom tab according to matlab language …?I have created my own Custom tab using Json files i have file Structure as
resources >> sl_toolstrip_plugins.json
>>json >> customTab.json
>> customTab_actions.json
>>arasTab_popups.json
from this structure i am loading my custom tab but when i change language of matlab all other tabs change language except custom tab.
how can i add Json of that language or how can i load my custom tab in that language. . . .?
how can i change language of my custom tab according to matlab language …? I have created my own Custom tab using Json files i have file Structure as
resources >> sl_toolstrip_plugins.json
>>json >> customTab.json
>> customTab_actions.json
>>arasTab_popups.json
from this structure i am loading my custom tab but when i change language of matlab all other tabs change language except custom tab.
how can i add Json of that language or how can i load my custom tab in that language. . . .?
how can i change language of my custom tab according to matlab language …? simulink, custom tab MATLAB Answers — New Questions
Why am I receiving an abnormal exit error when running “ar_0001” from the Model Advisor?
While executing check for ar_0001 on my models, I get an abnormal exit error
Abnormal exit: Unrecognized function or variable ‘non’.While executing check for ar_0001 on my models, I get an abnormal exit error
Abnormal exit: Unrecognized function or variable ‘non’. While executing check for ar_0001 on my models, I get an abnormal exit error
Abnormal exit: Unrecognized function or variable ‘non’. abnormal exit, mab MATLAB Answers — New Questions
Simulink Library Browser shows empty content of a custom library
He guys,
we have created a library with several sub-libraries and added them to the Simulink library browser using to the following tutorials:
https://de.mathworks.com/help/simulink/ug/creating-block-libraries.html
https://de.mathworks.com/help/simulink/ug/adding-libraries-to-the-library-browser.html
The library contains all sub-libraries as subsystem blocks,which opens the associated library using a callback function.
All, except one sub-library, are created correctly and you can see all blocks of each sub-library in the SL Browser. For reasons I don’t understand, the content of one sub-library is not displayed in the SL Browser. The content of this sublibrary is displayed blank. However, when I open this empty library from the SL Browser with right-click, it opens correctly and show me the correct content. This means, that this sublibrary was created correctly.
Does anyone have an idea how I can fix this error? I am at my wit’s end.
Thanks everybody and with best wishes,
LarsHe guys,
we have created a library with several sub-libraries and added them to the Simulink library browser using to the following tutorials:
https://de.mathworks.com/help/simulink/ug/creating-block-libraries.html
https://de.mathworks.com/help/simulink/ug/adding-libraries-to-the-library-browser.html
The library contains all sub-libraries as subsystem blocks,which opens the associated library using a callback function.
All, except one sub-library, are created correctly and you can see all blocks of each sub-library in the SL Browser. For reasons I don’t understand, the content of one sub-library is not displayed in the SL Browser. The content of this sublibrary is displayed blank. However, when I open this empty library from the SL Browser with right-click, it opens correctly and show me the correct content. This means, that this sublibrary was created correctly.
Does anyone have an idea how I can fix this error? I am at my wit’s end.
Thanks everybody and with best wishes,
Lars He guys,
we have created a library with several sub-libraries and added them to the Simulink library browser using to the following tutorials:
https://de.mathworks.com/help/simulink/ug/creating-block-libraries.html
https://de.mathworks.com/help/simulink/ug/adding-libraries-to-the-library-browser.html
The library contains all sub-libraries as subsystem blocks,which opens the associated library using a callback function.
All, except one sub-library, are created correctly and you can see all blocks of each sub-library in the SL Browser. For reasons I don’t understand, the content of one sub-library is not displayed in the SL Browser. The content of this sublibrary is displayed blank. However, when I open this empty library from the SL Browser with right-click, it opens correctly and show me the correct content. This means, that this sublibrary was created correctly.
Does anyone have an idea how I can fix this error? I am at my wit’s end.
Thanks everybody and with best wishes,
Lars simulink, custom library, blank library, sl browser MATLAB Answers — New Questions
