Category: News
Exporting Emails to PDF
Does anyone know if there is a way to export a group of emails (or a folder of emails) to pdf in the new Outlook?
Does anyone know if there is a way to export a group of emails (or a folder of emails) to pdf in the new Outlook? Read More
Weekday Formula where if the date is a Sunday it returns the original value
I am using the WEEKDAY function to return the week beginning and end dates, from a date in another cell, where beginning of the week is Sunday, and end of the week is Saturday.
It works where a date falls on any day of the week, apart from Sunday itself. If the date I need the week beginning and end date for is also a Sunday, and the beginning date itself, it’s showing the date of the previous Sunday.
Example:
Examples A, C and D return the correct results. But when the date I am trying to get week beginning and end for is also on a Sunday, it’s returning the previous week start and end dates. When I need it to return the same value essentially, as Sunday is the beginning of the week.
Has anyone come across this before and know of a workaround? I’m completely stuck and would very much appreciate some help!
I am using the WEEKDAY function to return the week beginning and end dates, from a date in another cell, where beginning of the week is Sunday, and end of the week is Saturday. It works where a date falls on any day of the week, apart from Sunday itself. If the date I need the week beginning and end date for is also a Sunday, and the beginning date itself, it’s showing the date of the previous Sunday. Example:Examples A, C and D return the correct results. But when the date I am trying to get week beginning and end for is also on a Sunday, it’s returning the previous week start and end dates. When I need it to return the same value essentially, as Sunday is the beginning of the week. Has anyone come across this before and know of a workaround? I’m completely stuck and would very much appreciate some help! Read More
How to access my Outlook Classic Templates in New Outlook?
If you want to save time and hassle when composing emails, you can use templates. Templates allow you to access professional and consistent messages that impress your recipients. You can open and reuse the templates that you created in Classic Outlook.
Usable templates are pre-written email messages you can customize and send with just a few clicks. You may create a variety of templates for different purposes, such as:
– Thanking a customer for their feedback
– Responding to a support ticket
– Requesting a review or a testimonial
– Announcing a promotion or a new product
And many more! Usable templates help you communicate effectively and efficiently without compromising on quality, style, or your precious time.
In under two minutes, this video will show you how to save an email to your local drive and open your Outlook Classic templates in New Outlook.
https://youtu.be/6HoYiraeHXk?si=yNvt8nCOgSNIPonZ
/Teresa #traccreations4e 5/14/2024
If you want to save time and hassle when composing emails, you can use templates. Templates allow you to access professional and consistent messages that impress your recipients. You can open and reuse the templates that you created in Classic Outlook.
Usable templates are pre-written email messages you can customize and send with just a few clicks. You may create a variety of templates for different purposes, such as:
– Thanking a customer for their feedback
– Responding to a support ticket
– Requesting a review or a testimonial
– Announcing a promotion or a new product
And many more! Usable templates help you communicate effectively and efficiently without compromising on quality, style, or your precious time.
In under two minutes, this video will show you how to save an email to your local drive and open your Outlook Classic templates in New Outlook.
https://youtu.be/6HoYiraeHXk?si=yNvt8nCOgSNIPonZ
/Teresa #traccreations4e 5/14/2024 Read More
Add gridline at only the 0 axis for Waterfall chart
Hello,
I have a waterfall chart that reads dynamic data that could potentially cross the 0 axis line. I want to avoid gridlines on the whole chart, but would like to add one for the 0 axis to highlight when the chart goes negative. I thought about trying a combo chart but waterfalls don’t allow this. Is there any other way to implement this, potentially with VBA?
Hello, I have a waterfall chart that reads dynamic data that could potentially cross the 0 axis line. I want to avoid gridlines on the whole chart, but would like to add one for the 0 axis to highlight when the chart goes negative. I thought about trying a combo chart but waterfalls don’t allow this. Is there any other way to implement this, potentially with VBA? Read More
Help needed in Excel
I have a cell that changes their values when I enter a text in another cell. This are validations.
Cell L46 = Error – Please provide an explanation
Cell E46 is blank
Then when I write an Explanation in Cell E46
then
Cell E46 = OK
Where I can see those conditions in my excel s/s.
I looked in conditional format but it’s not there, there isn’t a Macro in my s/s
Can someone help?
Thanks
I have a cell that changes their values when I enter a text in another cell. This are validations. Cell L46 = Error – Please provide an explanation Cell E46 is blank Then when I write an Explanation in Cell E46 then Cell E46 = OK Where I can see those conditions in my excel s/s.I looked in conditional format but it’s not there, there isn’t a Macro in my s/s Can someone help? Thanks Read More
How can I apply the ISNUMBER function row-by-row until a value is found?
I can use the ISNUMBER formula explicitly to get the result I want. However, I need to do a dynamic row-by-row search until a value is returned and then stop. For example, I want to determine if the value in column A is found in ANY of the rows in column R. If it is, then I want to return the value in that row’s column S and place it in column G. In my example I am explicitly searching R5 for the value in A3 and returning S5 to G3. Now, how would I get it to look in R1, R2, R3… until if found the match? The trick for me is having to use the ISNUMBER function to search a string of values in a cell. Otherwise, with my basic understanding I could use a MATCH or INDEX formula I think.
Thanks!
I can use the ISNUMBER formula explicitly to get the result I want. However, I need to do a dynamic row-by-row search until a value is returned and then stop. For example, I want to determine if the value in column A is found in ANY of the rows in column R. If it is, then I want to return the value in that row’s column S and place it in column G. In my example I am explicitly searching R5 for the value in A3 and returning S5 to G3. Now, how would I get it to look in R1, R2, R3… until if found the match? The trick for me is having to use the ISNUMBER function to search a string of values in a cell. Otherwise, with my basic understanding I could use a MATCH or INDEX formula I think. Thanks! Read More
Excel calculation slow after version 2308 update
Hello, We have a large excel model which has property “ForceFullCalculation” switched on due to issues with usability and excel crashing. If Excel is updated to any version past 2307 the calculation time significantly increases (by about 70%) which is an issue when calculating iteratively for instance if we are using Solver. I know that the best solution would be to redesign the Workbook so that we don’t have to have “ForceFullCalculation” switched on however we have deliverables that need to be met. We have rolled back Excel version to 2307 thinking there would be a fix in a more recent version however this has not happened and we don’t want to be stuck on version 2307 forever. Any advice on the cause/solutions to this problem would be greatly appreciated. Read More
Installing .Net 8.0 via Intune Using Winget
I am trying to get .NET 8.0 installed on user machines via a PowerShell script via Intune. I upload the following script. I have tested locally on a machine and works well, but fails when sending through Intune as a script.
# Install .NET 8.0 using Winget
winget install –silent –exact Microsoft.DotNet.Runtime.8
The problem is that if winget has not been used before on new install of windows, you have to “accept” this agreement about region of PC. It fails at this point. I attached the photo of what I get.
I need to figure out what needs to be added to script to automatically accept the agreement for region and silently install .NET 8.0.
I am trying to get .NET 8.0 installed on user machines via a PowerShell script via Intune. I upload the following script. I have tested locally on a machine and works well, but fails when sending through Intune as a script. # Install .NET 8.0 using Wingetwinget install –silent –exact Microsoft.DotNet.Runtime.8 The problem is that if winget has not been used before on new install of windows, you have to “accept” this agreement about region of PC. It fails at this point. I attached the photo of what I get.I need to figure out what needs to be added to script to automatically accept the agreement for region and silently install .NET 8.0. Read More
Is it safe to delete appdata folder on Windows 11?
My C drive is running out of space and I found the app data folder takes up more 60GB space. Can I safely delete the whole folder?
My C drive is running out of space and I found the app data folder takes up more 60GB space. Can I safely delete the whole folder? Read More
How to code equation
Hello, just wondering if this equation could be coded like this:
Any feedback will be greatly appreciated. Thanks
m = 10e-3
a = 0.05
c = 0.1
x(t) = m/a e^-(c/a)tHello, just wondering if this equation could be coded like this:
Any feedback will be greatly appreciated. Thanks
m = 10e-3
a = 0.05
c = 0.1
x(t) = m/a e^-(c/a)t Hello, just wondering if this equation could be coded like this:
Any feedback will be greatly appreciated. Thanks
m = 10e-3
a = 0.05
c = 0.1
x(t) = m/a e^-(c/a)t equation code MATLAB Answers — New Questions
Which technique to use for Satellite Imagery?
Hello,
I am new to image classification and am seeking to classify oil spills in SAR imagery using an unsupervised or adaptive thresholding method. I have experimented with various thresholding techniques, including Otsu, but none have consistently performed well across all SAR satellite images. While Otsu’s method yields satisfactory results for some images, those containing land areas often obscure the oil spill, as depicted in the attached image.
Additionally, I have attempted mean shift segmentation, but it lacks adaptability, requiring a separate bandwidth setting for each image.
Could anyone provide guidance on which method or combination of methods to employ in order to achieve the desired results?
Thank youHello,
I am new to image classification and am seeking to classify oil spills in SAR imagery using an unsupervised or adaptive thresholding method. I have experimented with various thresholding techniques, including Otsu, but none have consistently performed well across all SAR satellite images. While Otsu’s method yields satisfactory results for some images, those containing land areas often obscure the oil spill, as depicted in the attached image.
Additionally, I have attempted mean shift segmentation, but it lacks adaptability, requiring a separate bandwidth setting for each image.
Could anyone provide guidance on which method or combination of methods to employ in order to achieve the desired results?
Thank you Hello,
I am new to image classification and am seeking to classify oil spills in SAR imagery using an unsupervised or adaptive thresholding method. I have experimented with various thresholding techniques, including Otsu, but none have consistently performed well across all SAR satellite images. While Otsu’s method yields satisfactory results for some images, those containing land areas often obscure the oil spill, as depicted in the attached image.
Additionally, I have attempted mean shift segmentation, but it lacks adaptability, requiring a separate bandwidth setting for each image.
Could anyone provide guidance on which method or combination of methods to employ in order to achieve the desired results?
Thank you classification, image segmentation, computer vision, image processing, satellite imagery, sar MATLAB Answers — New Questions
Transfer Learning using deepNetwork Designer to show Precision and Recall, F1 score, Mean Average Precision and Mean Absolute Error.
I have tried to use deepNetwork Designer to perform Transfer Learning and have used Darknet53 network. Then I set my images (already preprocessed images of Person) to be the Data. After setting the Training Options, I proceeded to Training. I can see the on the results the Accuracy, Loss, and other info. However, I want to know if it’s possible to also show the Precision and Recall, F1 Score, Mean Average Precision? I am trying to find detailed documentations and would love to hear from other experts here. I am still exploring Experiment Manager if it’s possible there but am hoping somebody here who has a commendable idea on how to do these? Thank you so much.I have tried to use deepNetwork Designer to perform Transfer Learning and have used Darknet53 network. Then I set my images (already preprocessed images of Person) to be the Data. After setting the Training Options, I proceeded to Training. I can see the on the results the Accuracy, Loss, and other info. However, I want to know if it’s possible to also show the Precision and Recall, F1 Score, Mean Average Precision? I am trying to find detailed documentations and would love to hear from other experts here. I am still exploring Experiment Manager if it’s possible there but am hoping somebody here who has a commendable idea on how to do these? Thank you so much. I have tried to use deepNetwork Designer to perform Transfer Learning and have used Darknet53 network. Then I set my images (already preprocessed images of Person) to be the Data. After setting the Training Options, I proceeded to Training. I can see the on the results the Accuracy, Loss, and other info. However, I want to know if it’s possible to also show the Precision and Recall, F1 Score, Mean Average Precision? I am trying to find detailed documentations and would love to hear from other experts here. I am still exploring Experiment Manager if it’s possible there but am hoping somebody here who has a commendable idea on how to do these? Thank you so much. #deep learning, #transfer learning, #darknet53, imageclassification MATLAB Answers — New Questions
zcv variable Potential conflicting usages of identifier
Hello,
What’s a ZCV variable ? I am trying to generate code from a model that contains several referenced models, and I am getting this error:
Potential conflicting usages of identifier ‘ZCV_pidController_T’: a global identifier from ‘speed_controller’, and a global identifier from ‘current_controller’ This conflict may be resolved by either increasing the maximum identifier length on the Identifiers pane of the Configuration Parameters dialog box or by changing the name of the conflicting identifier.
I tried increasing the identifier max length it did not workHello,
What’s a ZCV variable ? I am trying to generate code from a model that contains several referenced models, and I am getting this error:
Potential conflicting usages of identifier ‘ZCV_pidController_T’: a global identifier from ‘speed_controller’, and a global identifier from ‘current_controller’ This conflict may be resolved by either increasing the maximum identifier length on the Identifiers pane of the Configuration Parameters dialog box or by changing the name of the conflicting identifier.
I tried increasing the identifier max length it did not work Hello,
What’s a ZCV variable ? I am trying to generate code from a model that contains several referenced models, and I am getting this error:
Potential conflicting usages of identifier ‘ZCV_pidController_T’: a global identifier from ‘speed_controller’, and a global identifier from ‘current_controller’ This conflict may be resolved by either increasing the maximum identifier length on the Identifiers pane of the Configuration Parameters dialog box or by changing the name of the conflicting identifier.
I tried increasing the identifier max length it did not work embedded coder, simulink MATLAB Answers — New Questions
How to import MATLAB generated ARXML file.
Hello,
I have created a SIMULINK model using AUTOSAR architecture blockset and generated ARXML code from it.
I need to import same model using import commands but it is throughing errors. Is it possible to do so?
If yes what is the correct process and commands required.
Regards,
Varun SinghHello,
I have created a SIMULINK model using AUTOSAR architecture blockset and generated ARXML code from it.
I need to import same model using import commands but it is throughing errors. Is it possible to do so?
If yes what is the correct process and commands required.
Regards,
Varun Singh Hello,
I have created a SIMULINK model using AUTOSAR architecture blockset and generated ARXML code from it.
I need to import same model using import commands but it is throughing errors. Is it possible to do so?
If yes what is the correct process and commands required.
Regards,
Varun Singh smiulink, arxml, import MATLAB Answers — New Questions
Can MS Copilot integrate with other CRM?
We are using Zoho can MS Copilot be integrated to it?
We are using Zoho can MS Copilot be integrated to it? Read More
What to do When Quickbooks payroll not working when downloading payroll updates?
Can someone please assist why my Quickbooks Payroll not Working when Downloading Payroll Updates and offer guidance on resolving this issue? Any advice or suggestions would be greatly appreciated. Thank you.
Can someone please assist why my Quickbooks Payroll not Working when Downloading Payroll Updates and offer guidance on resolving this issue? Any advice or suggestions would be greatly appreciated. Thank you. Read More
Power Query what is faster for 2nd query ? Reference or source table from output of 1st query ?
I know that power query will refresh the first query on all referenced query.
Meaning, if you have a “main” query and then transformations in multiple query, the “main” will be refreshed every time. Slowing down your process.
Is it better to output the first query to a table and then use that as a source for the other queries ?
I know that power query will refresh the first query on all referenced query.Meaning, if you have a “main” query and then transformations in multiple query, the “main” will be refreshed every time. Slowing down your process. Is it better to output the first query to a table and then use that as a source for the other queries ? Read More
Best way to add endpoint firewall rule through Intune
Hello,
I have a 3rd party app deployed to all my endpoints that requires specific ports and servers allowed through the local devices outbound firewall. After looking through some Microsoft support articles for Intune, I did find something however it will only let me use IP Address ranges. I need to use DNS Hostnames instead.
Is there a way in Intune for me to do this through Endpoint Security -> Firewall that I’m missing or do I have to script something and deploy it through Intune instead?
Appreciate the assistance!
Hello, I have a 3rd party app deployed to all my endpoints that requires specific ports and servers allowed through the local devices outbound firewall. After looking through some Microsoft support articles for Intune, I did find something however it will only let me use IP Address ranges. I need to use DNS Hostnames instead. Is there a way in Intune for me to do this through Endpoint Security -> Firewall that I’m missing or do I have to script something and deploy it through Intune instead?Appreciate the assistance! Read More
How to Manage Preferred Languages in Microsoft Edge via Registry or Preferences File?
I’m trying to manage the preferred languages in Microsoft Edge on Windows. Specifically, I want to remove certain languages that appear in the “edge://settings/languages” settings (e.g., Dutch).
I have a few questions regarding this:
Registry Settings: Is there a registry key that controls the preferred languages in Edge? I’ve checked the `HKEY_CURRENT_USERSoftwareMicrosoftEdge` path but found no clear indicators related to language preferences. If the preferred languages are stored in the registry, could you please provide the exact path or any subkeys where these settings are managed?Preferences JSON File: If the preferred languages are not controlled via the registry, could they be stored in the `Preferences` JSON file located at
“C:Users$Env:UserNameAppDataLocalMicrosoftEdgeUser DataDefaultPreferences”
? If so, can anyone guide me on how to modify this file safely to update or remove language preferences?
Best Practices: Are there any best practices or recommended methods for programmatically managing language settings in Edge? Whether through PowerShell, registry modifications, or editing the JSON preferences file, I would appreciate any advice or scripts that have worked for others.
Thank you in advance for your assistance!
I’m trying to manage the preferred languages in Microsoft Edge on Windows. Specifically, I want to remove certain languages that appear in the “edge://settings/languages” settings (e.g., Dutch). I have a few questions regarding this:Registry Settings: Is there a registry key that controls the preferred languages in Edge? I’ve checked the `HKEY_CURRENT_USERSoftwareMicrosoftEdge` path but found no clear indicators related to language preferences. If the preferred languages are stored in the registry, could you please provide the exact path or any subkeys where these settings are managed?Preferences JSON File: If the preferred languages are not controlled via the registry, could they be stored in the `Preferences` JSON file located at “C:Users$Env:UserNameAppDataLocalMicrosoftEdgeUser DataDefaultPreferences”? If so, can anyone guide me on how to modify this file safely to update or remove language preferences? Best Practices: Are there any best practices or recommended methods for programmatically managing language settings in Edge? Whether through PowerShell, registry modifications, or editing the JSON preferences file, I would appreciate any advice or scripts that have worked for others.Thank you in advance for your assistance! Read More
What are common causes for QuickBooks Migration Failed Unexpectedly and how can it be resolved?
Can someone please explain why QuickBooks migration failed unexpectedly? Seeking urgent assistance to resolve this issue and ensure a smooth transition of data. Any guidance or troubleshooting solutions steps would be heartly appreciated.
Can someone please explain why QuickBooks migration failed unexpectedly? Seeking urgent assistance to resolve this issue and ensure a smooth transition of data. Any guidance or troubleshooting solutions steps would be heartly appreciated. Read More