Month: September 2024
Need help with #N/A display for IF Function
Hello Experts,
I’m reworking a sheet that I did not create and need help with replacing the #N/A display with a blank when the referencing cell is blank. Is this possible? The formula works as intended so it’s technically correct, however, I want this formula to work when rows are also blank. This sheet is used to help us calculate employee tips and pay.
Please see image of the summary sheet. The rows calculate the information from the daily sheets. The daily sheets reference the Jobs table.
On the daily sheet, column C references the Jobs table on the summary sheet. Column O references column C to calculate what happens to columns P – U. The formula for column O is:
=IF(ISBLANK(C5),””,INDEX(JOB_DATA,MATCH(C5,JOB_NAME,0),4))
JOB_DATA is the entire row in the Jobs table. JOB_NAME is the Position column.
The blank rows on the summary and daily sheets are there for us to add/remove employees. Is there a way for these #N/A cells to show as a blank?
Hello Experts, I’m reworking a sheet that I did not create and need help with replacing the #N/A display with a blank when the referencing cell is blank. Is this possible? The formula works as intended so it’s technically correct, however, I want this formula to work when rows are also blank. This sheet is used to help us calculate employee tips and pay. Please see image of the summary sheet. The rows calculate the information from the daily sheets. The daily sheets reference the Jobs table. On the daily sheet, column C references the Jobs table on the summary sheet. Column O references column C to calculate what happens to columns P – U. The formula for column O is: =IF(ISBLANK(C5),””,INDEX(JOB_DATA,MATCH(C5,JOB_NAME,0),4)) JOB_DATA is the entire row in the Jobs table. JOB_NAME is the Position column. The blank rows on the summary and daily sheets are there for us to add/remove employees. Is there a way for these #N/A cells to show as a blank? Read More
Getting an error when using nested IF function
I’m trying to sort through a column of remarks. If any of the remarks contain one word, I need to pull that word out. If it says a different word, I need to pull that one out. No remark should have both, but some will have neither. If there is neither, it can be left blank.
I’ve tried to use
=IF((FIND(“FWA”,DATA!AM7)), “FWA”,
IF(FIND(“JBER”,DATA!AM7),”JBER”))
which will work for the first value, but for the second I get a “#VALUE!” error.
What am I doing wrong here? As far as I can tell the syntax is legit.
I’m trying to sort through a column of remarks. If any of the remarks contain one word, I need to pull that word out. If it says a different word, I need to pull that one out. No remark should have both, but some will have neither. If there is neither, it can be left blank. I’ve tried to use=IF((FIND(“FWA”,DATA!AM7)), “FWA”,IF(FIND(“JBER”,DATA!AM7),”JBER”))which will work for the first value, but for the second I get a “#VALUE!” error. What am I doing wrong here? As far as I can tell the syntax is legit. Read More
Stock Tracking Form and DB
Hi all,
I’ve attached a DB/Form im compiling to do a simple intake form for stock holding, Consignment Number needs to be unique, when inputting the TM_Carton_ID on the subform i want it to look up against the DB and bring back if its Pure or mixed, but i cant seem to get it to happen for multiple lines.
See my attached DB, any help on this would be useful, feel free to add any additions too, once this is live the TM_Carton_ID will be scanned in via a device and we need to tell the user if that carton is a pure carton or a mixed carton.
any help would be great on this thanks.
DB is below.
https://drive.google.com/file/d/1UgD7rwVlKIe_0EHKlDQ2TWqhkbwyLzBx/view?usp=sharing
Hi all, I’ve attached a DB/Form im compiling to do a simple intake form for stock holding, Consignment Number needs to be unique, when inputting the TM_Carton_ID on the subform i want it to look up against the DB and bring back if its Pure or mixed, but i cant seem to get it to happen for multiple lines. See my attached DB, any help on this would be useful, feel free to add any additions too, once this is live the TM_Carton_ID will be scanned in via a device and we need to tell the user if that carton is a pure carton or a mixed carton. any help would be great on this thanks.DB is below. https://drive.google.com/file/d/1UgD7rwVlKIe_0EHKlDQ2TWqhkbwyLzBx/view?usp=sharing Read More
Capture First Chance Exceptions Using Debug Diagnostic Tool
Steps to Capture First Chance Exceptions Using Debug Diagnostic Tool (DebugDiag)
Introduction
In the world of software development, debugging is an essential skill. Debug Diagnostic Tool (DebugDiag) is a powerful utility designed to assist in troubleshooting various issues related to application crashes, hangs, and performance bottlenecks. One of the critical functionalities of DebugDiag is capturing first chance exceptions.
A first chance exception occurs when an exception is thrown in an application, before it is handled..
This blog will walk you through the steps to capture these exceptions effectively.
Understanding First Chance Exceptions
When an exception is thrown, it is initially caught by the runtime before any catch blocks are executed. This is considered a “first chance” event.
If the exception is not handled (caught), it becomes a “second chance” exception when it propagates up the call stack and is eventually unhandled.
Prerequisites
Before we dive into the steps, ensure you have the following:
Debug Diagnostic Tool (DebugDiag) installed on your system.
Administrator privileges to configure and run DebugDiag.
Access to the application or process you intend to monitor.
Steps to Capture First Chance Exceptions Using DebugDiag
Step 1: Launch DebugDiag
First, open the DebugDiag tool. You can find it in the Start menu under “Debug Diagnostic Tool.” Ensure you run it with administrator privileges to access all its features.
Step 2: Create a New Rule
Once DebugDiag is open, you need to create a new rule to capture exceptions:
Click on the “Rules” tab.
Select “Add Rule.”
Choose “Crash” as the rule type and click “Next.”
Step 3: Select the Target Process – IIS Web application pool
The next step involves selecting the application or process you want to monitor:
You can choose from a list of running processes or provide an executable path.
Select the target process and click “Next.”
Step 4: Configure Exceptions
In this step, you’ll configure the tool to capture first chance exceptions:
Under advance settings click on Exceptions
Under “Exceptions,” click “Add Exception.”
If you know the exact exception you can type the exception under “Optional Exception Name” or you can select the exception from the given exception name
Set the “Action Type” to “Full Userdump.”
Set the “Action Limit” to 10
Click on “Save & Close”
Click “OK” to save the settings.
For example, If you need to configure the exception. Select CLR(.NET) 4.x Exception and mention Exception name as System.Security.Cryptography.CryptographicException.
This is how it can be set :
In case you are facing issues with your application and you see Exception name as System.Runtime.InteropServices.COMException, you can enable the debug diag for such first chance exception like this :
Step 5: Specify Advanced Settings
DebugDiag offers advanced settings for fine-tuning the capture process:
You can configure options such as the number of user dumps to capture, the location to save the dump files, and notifications.
Adjust these settings according to your requirements and click “OK.”
Step 6: Activate the Rule
After configuring the rule, you need to activate it:
Click “Finish” to complete the rule setup.
The rule will now appear in the “Rules” tab. Ensure it is checked to activate it.
Step 7: Monitor and Capture Exceptions
With the rule active, DebugDiag will monitor the selected process for exceptions:
When a first chance exception occurs, DebugDiag will capture a full user dump of the process.
You can view the captured dumps in the specified location.
Conclusion
Capturing first chance exceptions using Debug Diagnostic Tool (DebugDiag) is a crucial step in troubleshooting and resolving application crashes. By following the steps outlined in this blog, you can effectively monitor your applications, capture critical exception data, and analyze the root causes of crashes. This proactive approach will enable you to enhance the stability and reliability of your software, ultimately providing a better experience for your users.
List of Common Exceptions
Here are some common exceptions you might encounter and want to capture:
AccessViolationException: Indicates that an invalid memory access occurred.
NullReferenceException: Occurs when an attempt is made to access a null object reference.
OutOfMemoryException: Thrown when the system runs out of memory.
StackOverflowException: Happens when the execution stack overflows due to excessive recursion.
ArgumentException: Raised when an invalid argument is passed to a method.
InvalidOperationException: Indicates that a method call is invalid for the object’s current state.
FileNotFoundException: Thrown when an attempt to access a file that does not exist on disk fails.
By capturing and analyzing these exceptions, you can gain deeper insights into application behavior and improve overall software quality.
Additional Resources
For further reading and resources on DebugDiag and exception handling, consider the following:
Debug Diagnostic Tool Documentation
WinDbg Debugging Tool
Best Practices for Exception Handling in .NET
Happy debugging!
Microsoft Tech Community – Latest Blogs –Read More
Where can I download Matlab compiler for R2009a version
Dear All,
I am looking for Matlab compiler compatible for R2009a version.
How can I do that?Dear All,
I am looking for Matlab compiler compatible for R2009a version.
How can I do that? Dear All,
I am looking for Matlab compiler compatible for R2009a version.
How can I do that? matlab compiler MATLAB Answers — New Questions
using mask parameter in Matlab Function block
Hi everyone
I’ve created a mask for a Matab-Function block.
How can I use the mask parameters in Matlab-Function block function?Hi everyone
I’ve created a mask for a Matab-Function block.
How can I use the mask parameters in Matlab-Function block function? Hi everyone
I’ve created a mask for a Matab-Function block.
How can I use the mask parameters in Matlab-Function block function? mask, paramerter MATLAB Answers — New Questions
New! Learn How Copilot in OneDrive Can Revolutionize Your Workflow
Introducing Copilot in OneDrive – Now generally available for all Copilot-licensed commercial users! If you work with OneDrive, this is a game-changer.
What’s in It for You?
Quick Summaries: Find out how Copilot can instantly summarize large technical documents, saving you hours of manual reading.
Document Comparison Made Easy: Learn how to compare multiple files side-by-side without opening them, perfect for managing contracts, reports, and more.
Read the Full Blog Here to explore these features and start leveraging Copilot’s AI capabilities today.
Upcoming Event: Join us on October 8th for the AI Innovations for the New Era of Work and Home.
We Want Your Feedback: How are you planning to use Copilot in OneDrive? Read the blog and share your thoughts below!
Introducing Copilot in OneDrive – Now generally available for all Copilot-licensed commercial users! If you work with OneDrive, this is a game-changer.
What’s in It for You?
Quick Summaries: Find out how Copilot can instantly summarize large technical documents, saving you hours of manual reading.
Document Comparison Made Easy: Learn how to compare multiple files side-by-side without opening them, perfect for managing contracts, reports, and more.
Read the Full Blog Here to explore these features and start leveraging Copilot’s AI capabilities today.
Upcoming Event: Join us on October 8th for the AI Innovations for the New Era of Work and Home.
We Want Your Feedback: How are you planning to use Copilot in OneDrive? Read the blog and share your thoughts below! Read More
Automatic installation of Roots Updates
You can use the registry parameter to redirect the source of root certificate updates:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftSystemCertificatesAuthRootAutoUpdate
“RootDirURL”=”d:…….”
Is it possible to automatically distribute certificates of intermediate certification authorities in this way?
You can use the registry parameter to redirect the source of root certificate updates:HKEY_LOCAL_MACHINESOFTWAREMicrosoftSystemCertificatesAuthRootAutoUpdate
“RootDirURL”=”d:…….”Is it possible to automatically distribute certificates of intermediate certification authorities in this way? Read More
Power Query in Excel with Python
Let me first say that I really enjoy Python in Excel and getting data into Excel with Queries work well, so congrats to all involved in improving Excel so much.
I am triggered to ask a question from what was released in Power BI Desktop some time ago: The ability to embed Python inside queries, just like you can do for SQL. Excel queries have been able to the SQL version for a long time. Is there plans to expand to Python as well? As example in PBI I can do the following:
let
Source = Python.Execute
(“import pandas as pd
import glob, os
# more Python statement here
“)
in
Source
Will this also come to Power Query in Excel?
Let me first say that I really enjoy Python in Excel and getting data into Excel with Queries work well, so congrats to all involved in improving Excel so much. I am triggered to ask a question from what was released in Power BI Desktop some time ago: The ability to embed Python inside queries, just like you can do for SQL. Excel queries have been able to the SQL version for a long time. Is there plans to expand to Python as well? As example in PBI I can do the following: let Source = Python.Execute(“import pandas as pdimport glob, os# more Python statement here”)in Source Will this also come to Power Query in Excel? Read More
Calculating the Trendline
When analyzing a scatter plot, what method does Excel use to create the Trendline?
I’m assuming that the Trendline is the same as the Line of Best Fit and would use a method such as “Least Squares Method” to calculate the linear equation with the highest possible correlation coefficient.
When analyzing a scatter plot, what method does Excel use to create the Trendline? I’m assuming that the Trendline is the same as the Line of Best Fit and would use a method such as “Least Squares Method” to calculate the linear equation with the highest possible correlation coefficient. Read More
How do I stop people putting stuff in my calendar why I have allowed an ms booking service slot
I have set up a service in a shared MS bookings page. But I have only allowed certain appointments on certain days and for certain times. At the moment I have it linked to a shared calendar and my calendar and I have “blocked out” the times in my calendar to prevent other people within the organisation booking meetings for the allocated slots but that then means bookings thinks I’m booked so they go in to the shared calendar (which I knew would happen) but how can I stop other people booking my time in my outlook calendar and therefore taking my availability away from this service
I have set up a service in a shared MS bookings page. But I have only allowed certain appointments on certain days and for certain times. At the moment I have it linked to a shared calendar and my calendar and I have “blocked out” the times in my calendar to prevent other people within the organisation booking meetings for the allocated slots but that then means bookings thinks I’m booked so they go in to the shared calendar (which I knew would happen) but how can I stop other people booking my time in my outlook calendar and therefore taking my availability away from this service Read More
Python – MATLAB not working: MATLAB cant find python environment, numpy not working, fooof not working
Hi everyone,
I’ve been stuck on trying to run some matlab-python code for a week now and nothing seems to work. I am trying to run the following code: https://github.com/fooof-tools/fooof_mat?tab=readme-ov-file which requires python to be compatible with MATLAB. I’ve read so many things but nothing has worked so far. This is my first time trying to code in python-matlab simultaneously so the answer might be something simple that I am just not aware of.
What has worked so far:
I created a new environment called ‘env’ which is located in location ‘fri_test’. In this environment I have installed fooof, matlibplot, pandas.
Then, I open a fresh MATLAB window and type in the following:
pyenv
This is the output:
ans =
PythonEnvironment with properties:
Version: "3.9"
Executable: "/Users/c1034944/fri_test/env/bin/python"
Library: "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/libpython3.9.dylib"
Home: "/Users/c1034944/fri_test/env"
Status: NotLoaded
ExecutionMode: InProcess
I then run:
python_env_path = ‘/Users/c1034944/fri_test/env/bin/python’
pyenv("Version",python_env_path);
py.list({‘This’,’is a’,’list’})
output:
ans =
Python list with no properties.
[‘This’, ‘is a’, ‘list’]
Lastly, run this again to check the python environment:
pyenv
output:
ans =
PythonEnvironment with properties:
Version: "3.9"
Executable: "/Users/c1034944/fri_test/env/bin/python"
Library: "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/libpython3.9.dylib"
Home: "/Users/c1034944/fri_test/env"
Status: Loaded
ExecutionMode: InProcess
ProcessID: "42704"
ProcessName: "MATLAB"
As you can see the ‘executable’ is finding the correct location of the environment I created in fri_test. The ‘ExecutionMode’ has also now updated to ‘InProcess’. However, the ‘Library" is still calling the python version from the Library/Developer.
To test if numpy is working, I run the following:
freq=([0 0.9766 1.9531 2.9297])
py.numpy.array(freq)
this is the error message:
Unable to resolve the name py.numpy.array.
More info: The ‘fooof’ code I am trying to run contains the following line: py.numpy.array(freqs), where ‘freqs’ is a list of 1 x 257 numbers. To my understanding py.numpy.array(freqs) converts the matlab (.mat) file ‘freqs’ into a python-compatible array.
Conclusion: I have no idea what is the issue here and why numpy is not working. I know that MATLAB and python versions are compatible, but maybe I am making a different mistake. I am hoping that finding a solution to numpy problem and that may fix the whole issue – is there any other way to convert .mat files into python arrays?
Any suggestions would be helpful!
Healthy Regards,
VyteHi everyone,
I’ve been stuck on trying to run some matlab-python code for a week now and nothing seems to work. I am trying to run the following code: https://github.com/fooof-tools/fooof_mat?tab=readme-ov-file which requires python to be compatible with MATLAB. I’ve read so many things but nothing has worked so far. This is my first time trying to code in python-matlab simultaneously so the answer might be something simple that I am just not aware of.
What has worked so far:
I created a new environment called ‘env’ which is located in location ‘fri_test’. In this environment I have installed fooof, matlibplot, pandas.
Then, I open a fresh MATLAB window and type in the following:
pyenv
This is the output:
ans =
PythonEnvironment with properties:
Version: "3.9"
Executable: "/Users/c1034944/fri_test/env/bin/python"
Library: "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/libpython3.9.dylib"
Home: "/Users/c1034944/fri_test/env"
Status: NotLoaded
ExecutionMode: InProcess
I then run:
python_env_path = ‘/Users/c1034944/fri_test/env/bin/python’
pyenv("Version",python_env_path);
py.list({‘This’,’is a’,’list’})
output:
ans =
Python list with no properties.
[‘This’, ‘is a’, ‘list’]
Lastly, run this again to check the python environment:
pyenv
output:
ans =
PythonEnvironment with properties:
Version: "3.9"
Executable: "/Users/c1034944/fri_test/env/bin/python"
Library: "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/libpython3.9.dylib"
Home: "/Users/c1034944/fri_test/env"
Status: Loaded
ExecutionMode: InProcess
ProcessID: "42704"
ProcessName: "MATLAB"
As you can see the ‘executable’ is finding the correct location of the environment I created in fri_test. The ‘ExecutionMode’ has also now updated to ‘InProcess’. However, the ‘Library" is still calling the python version from the Library/Developer.
To test if numpy is working, I run the following:
freq=([0 0.9766 1.9531 2.9297])
py.numpy.array(freq)
this is the error message:
Unable to resolve the name py.numpy.array.
More info: The ‘fooof’ code I am trying to run contains the following line: py.numpy.array(freqs), where ‘freqs’ is a list of 1 x 257 numbers. To my understanding py.numpy.array(freqs) converts the matlab (.mat) file ‘freqs’ into a python-compatible array.
Conclusion: I have no idea what is the issue here and why numpy is not working. I know that MATLAB and python versions are compatible, but maybe I am making a different mistake. I am hoping that finding a solution to numpy problem and that may fix the whole issue – is there any other way to convert .mat files into python arrays?
Any suggestions would be helpful!
Healthy Regards,
Vyte Hi everyone,
I’ve been stuck on trying to run some matlab-python code for a week now and nothing seems to work. I am trying to run the following code: https://github.com/fooof-tools/fooof_mat?tab=readme-ov-file which requires python to be compatible with MATLAB. I’ve read so many things but nothing has worked so far. This is my first time trying to code in python-matlab simultaneously so the answer might be something simple that I am just not aware of.
What has worked so far:
I created a new environment called ‘env’ which is located in location ‘fri_test’. In this environment I have installed fooof, matlibplot, pandas.
Then, I open a fresh MATLAB window and type in the following:
pyenv
This is the output:
ans =
PythonEnvironment with properties:
Version: "3.9"
Executable: "/Users/c1034944/fri_test/env/bin/python"
Library: "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/libpython3.9.dylib"
Home: "/Users/c1034944/fri_test/env"
Status: NotLoaded
ExecutionMode: InProcess
I then run:
python_env_path = ‘/Users/c1034944/fri_test/env/bin/python’
pyenv("Version",python_env_path);
py.list({‘This’,’is a’,’list’})
output:
ans =
Python list with no properties.
[‘This’, ‘is a’, ‘list’]
Lastly, run this again to check the python environment:
pyenv
output:
ans =
PythonEnvironment with properties:
Version: "3.9"
Executable: "/Users/c1034944/fri_test/env/bin/python"
Library: "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.9/lib/libpython3.9.dylib"
Home: "/Users/c1034944/fri_test/env"
Status: Loaded
ExecutionMode: InProcess
ProcessID: "42704"
ProcessName: "MATLAB"
As you can see the ‘executable’ is finding the correct location of the environment I created in fri_test. The ‘ExecutionMode’ has also now updated to ‘InProcess’. However, the ‘Library" is still calling the python version from the Library/Developer.
To test if numpy is working, I run the following:
freq=([0 0.9766 1.9531 2.9297])
py.numpy.array(freq)
this is the error message:
Unable to resolve the name py.numpy.array.
More info: The ‘fooof’ code I am trying to run contains the following line: py.numpy.array(freqs), where ‘freqs’ is a list of 1 x 257 numbers. To my understanding py.numpy.array(freqs) converts the matlab (.mat) file ‘freqs’ into a python-compatible array.
Conclusion: I have no idea what is the issue here and why numpy is not working. I know that MATLAB and python versions are compatible, but maybe I am making a different mistake. I am hoping that finding a solution to numpy problem and that may fix the whole issue – is there any other way to convert .mat files into python arrays?
Any suggestions would be helpful!
Healthy Regards,
Vyte fooof, python, matlab, matlab python, numpy, python array, library, executable MATLAB Answers — New Questions
Why is MATLAB R2020a, R2020b, or R2023b not detecting a silent Support Package installation?
I installed a Support Package silently with an offline Support Package download. When I open MATLAB, the support package doesn’t appear to be installed when checking Add-ons>Manage or when running:
matlabshared.supportpkg.getInstalledI installed a Support Package silently with an offline Support Package download. When I open MATLAB, the support package doesn’t appear to be installed when checking Add-ons>Manage or when running:
matlabshared.supportpkg.getInstalled I installed a Support Package silently with an offline Support Package download. When I open MATLAB, the support package doesn’t appear to be installed when checking Add-ons>Manage or when running:
matlabshared.supportpkg.getInstalled MATLAB Answers — New Questions
Equivalent Methods of Python __setitem__ and _getitem__ methods
What are the equivalent methods in matlab of the python methods __setitem__ and _getitem__?
Thank you,
VirginioWhat are the equivalent methods in matlab of the python methods __setitem__ and _getitem__?
Thank you,
Virginio What are the equivalent methods in matlab of the python methods __setitem__ and _getitem__?
Thank you,
Virginio python MATLAB Answers — New Questions
Excel Power Query API Get Call duplicating calls when loading
I am making an API call in Excel Power Query. The data comes into PQ, I parse and transform the data. The issue comes into getting the data out of PQ. If I try to save it as a table in the worksheet, upon loading it calls the API again and if the list is more than 1k rows, it fails. If I to keep the query as a connection only and load to the data model, it calls the API url again and it also fails if there are more than 1k rows.
I have tried to use Table.Buffer, transform the data, copy the data (this fails because the number of cells), reference the API call Query, filtering, and load the query to the data model but they all call the API again. It ends up maxing out my API call Quota. I have searched through so many forums and websites and I have exhausted all I know for resources. I do not understand why the data will not cache after the call and allow me to pull the data into a table without making another call to the API or failing. Any thoughts, course of action or even a cursing would be great at this point. Thank you in advance for any input.
Here is a link to the file setup- I have removed the API Key but you can see the structure
I am making an API call in Excel Power Query. The data comes into PQ, I parse and transform the data. The issue comes into getting the data out of PQ. If I try to save it as a table in the worksheet, upon loading it calls the API again and if the list is more than 1k rows, it fails. If I to keep the query as a connection only and load to the data model, it calls the API url again and it also fails if there are more than 1k rows. I have tried to use Table.Buffer, transform the data, copy the data (this fails because the number of cells), reference the API call Query, filtering, and load the query to the data model but they all call the API again. It ends up maxing out my API call Quota. I have searched through so many forums and websites and I have exhausted all I know for resources. I do not understand why the data will not cache after the call and allow me to pull the data into a table without making another call to the API or failing. Any thoughts, course of action or even a cursing would be great at this point. Thank you in advance for any input. Here is a link to the file setup- I have removed the API Key but you can see the structure Structure File Sample Read More
Update Bookings Not Functioning
Is anyone else experiencing issues where the Update Booking button is not functioning? We are not able to reassign 1:1 appointments and the button does not respond in any manner when we click it. Any ideas how to troubleshoot?
Is anyone else experiencing issues where the Update Booking button is not functioning? We are not able to reassign 1:1 appointments and the button does not respond in any manner when we click it. Any ideas how to troubleshoot? Read More
In process .NET COM DLL
Is it even possible to get an in process .net COM library exposed from an installed MSIX package. I have tried every combination of extensions (com4:ManagedInProcessServer came closest) and still can’t figure it out. An application within the package doesn’t have any issue creating an object instance based on the COM class id so I know that my Registry.dat is correct but I can’t figure out the application manifest piece of the puzzle. I want to be able to create instances of COM objects from outside the packaged application so that I can share logic between my applications.
If you have a working example of an app manifest can you reply?
Thanks.
Is it even possible to get an in process .net COM library exposed from an installed MSIX package. I have tried every combination of extensions (com4:ManagedInProcessServer came closest) and still can’t figure it out. An application within the package doesn’t have any issue creating an object instance based on the COM class id so I know that my Registry.dat is correct but I can’t figure out the application manifest piece of the puzzle. I want to be able to create instances of COM objects from outside the packaged application so that I can share logic between my applications. If you have a working example of an app manifest can you reply? Thanks. Read More
Extend only two lines on a plot
I made a plot on Matlab with three experimental data lines and two theoretical. I need to extend only the two theoretical (Vturb and Vlam) to the top of the plot. Everything I’ve tried has not worked so any ideas would be much appreciated.
%140%
DP140= [0.200 0.192 0.182 0.170 0.162 0.151 0.138 0.132 0.130 0.122 0.117 0.108 0.102 0.087 0.076];
DPlb140=DP140*5.20;
V140=((2*DPlb140)/0.00238).^(1/2);
VCL140 = V140/29.5626;
%60 Hz%
DP60 = [0.043 0.045 0.042 0.040 0.038 0.037 0.035 0.032 0.031 0.031 0.027 0.026 0.024 0.021 0.018];
DPlb60=DP60*5.20;
V60=((2*DPlb60)/0.00238).^(1/2);
VCL60 = V60/13.7076;
%100 Hz%
DP100 = [0.123 0.118 0.112 0.108 0.103 0.095 0.089 0.085 0.081 0.078 0.075 0.065 0.062 0.057 0.042];
DPlb100=DP100*5.20;
V100=((2*DPlb100)/0.00238).^(1/2);
r = [0 2 4 6 8 10 12 14 16 18 20 22 24 26 28]/304.8;
R = 0.125;
rR = r/R;
VCL100 = V100/23.1836;
Vlam = (1-rR.^2);
Vturb = (1-rR).^(1/7);
plot(VCL140, rR)
hold on
plot(VCL60, rR)
plot(VCL100, rR)
plot(Vturb,rR)
plot(Vlam,rR)
ylabel("r/R")
xlabel("V/Vcl")
title("Velocites vs. Distance")
legend("Meas V140","Meas V60","Meas V100", "Laminar", "Turbulent")
hold offI made a plot on Matlab with three experimental data lines and two theoretical. I need to extend only the two theoretical (Vturb and Vlam) to the top of the plot. Everything I’ve tried has not worked so any ideas would be much appreciated.
%140%
DP140= [0.200 0.192 0.182 0.170 0.162 0.151 0.138 0.132 0.130 0.122 0.117 0.108 0.102 0.087 0.076];
DPlb140=DP140*5.20;
V140=((2*DPlb140)/0.00238).^(1/2);
VCL140 = V140/29.5626;
%60 Hz%
DP60 = [0.043 0.045 0.042 0.040 0.038 0.037 0.035 0.032 0.031 0.031 0.027 0.026 0.024 0.021 0.018];
DPlb60=DP60*5.20;
V60=((2*DPlb60)/0.00238).^(1/2);
VCL60 = V60/13.7076;
%100 Hz%
DP100 = [0.123 0.118 0.112 0.108 0.103 0.095 0.089 0.085 0.081 0.078 0.075 0.065 0.062 0.057 0.042];
DPlb100=DP100*5.20;
V100=((2*DPlb100)/0.00238).^(1/2);
r = [0 2 4 6 8 10 12 14 16 18 20 22 24 26 28]/304.8;
R = 0.125;
rR = r/R;
VCL100 = V100/23.1836;
Vlam = (1-rR.^2);
Vturb = (1-rR).^(1/7);
plot(VCL140, rR)
hold on
plot(VCL60, rR)
plot(VCL100, rR)
plot(Vturb,rR)
plot(Vlam,rR)
ylabel("r/R")
xlabel("V/Vcl")
title("Velocites vs. Distance")
legend("Meas V140","Meas V60","Meas V100", "Laminar", "Turbulent")
hold off I made a plot on Matlab with three experimental data lines and two theoretical. I need to extend only the two theoretical (Vturb and Vlam) to the top of the plot. Everything I’ve tried has not worked so any ideas would be much appreciated.
%140%
DP140= [0.200 0.192 0.182 0.170 0.162 0.151 0.138 0.132 0.130 0.122 0.117 0.108 0.102 0.087 0.076];
DPlb140=DP140*5.20;
V140=((2*DPlb140)/0.00238).^(1/2);
VCL140 = V140/29.5626;
%60 Hz%
DP60 = [0.043 0.045 0.042 0.040 0.038 0.037 0.035 0.032 0.031 0.031 0.027 0.026 0.024 0.021 0.018];
DPlb60=DP60*5.20;
V60=((2*DPlb60)/0.00238).^(1/2);
VCL60 = V60/13.7076;
%100 Hz%
DP100 = [0.123 0.118 0.112 0.108 0.103 0.095 0.089 0.085 0.081 0.078 0.075 0.065 0.062 0.057 0.042];
DPlb100=DP100*5.20;
V100=((2*DPlb100)/0.00238).^(1/2);
r = [0 2 4 6 8 10 12 14 16 18 20 22 24 26 28]/304.8;
R = 0.125;
rR = r/R;
VCL100 = V100/23.1836;
Vlam = (1-rR.^2);
Vturb = (1-rR).^(1/7);
plot(VCL140, rR)
hold on
plot(VCL60, rR)
plot(VCL100, rR)
plot(Vturb,rR)
plot(Vlam,rR)
ylabel("r/R")
xlabel("V/Vcl")
title("Velocites vs. Distance")
legend("Meas V140","Meas V60","Meas V100", "Laminar", "Turbulent")
hold off plotting, plot MATLAB Answers — New Questions
how do I create array with numbers and characters to then put into a table?
I’m trying to create a table from an array for which I need empty certain coluns to display blank (or NA). I tried this….
switch n
case 1
sumT =array2table({k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload},’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 2
sumT =array2table({k,ZIA,’_’,f1,’_’,’_’,R2,Irms,Pload},’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 3
sumT =array2table([k,ZIA,’_’,’_’,f2,’_’,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 4
sumT =array2table([k,ZIA,’_’,’_’,’_’,f2pk,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
otherwise
disp(‘oops’)
end
I’ve tried :
array2table({k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload}…
array2table([k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload]…
array2table([{k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload}]….
etc, but none of these combinations seem to work.
sumT =array2table([k,ZIA,f1pk,’ ‘,’ ‘,’ ‘,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
results in :
this one,
sumT =array2table([{k,ZIA,f1pk,’ ‘,’ ‘,’ ‘,R2,Irms,Pload}],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
generates this output.
How do I display the contents of the "containers}?
how can I include doubles and blanks in the same array and then display them as such in a table?
Thank you.I’m trying to create a table from an array for which I need empty certain coluns to display blank (or NA). I tried this….
switch n
case 1
sumT =array2table({k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload},’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 2
sumT =array2table({k,ZIA,’_’,f1,’_’,’_’,R2,Irms,Pload},’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 3
sumT =array2table([k,ZIA,’_’,’_’,f2,’_’,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 4
sumT =array2table([k,ZIA,’_’,’_’,’_’,f2pk,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
otherwise
disp(‘oops’)
end
I’ve tried :
array2table({k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload}…
array2table([k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload]…
array2table([{k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload}]….
etc, but none of these combinations seem to work.
sumT =array2table([k,ZIA,f1pk,’ ‘,’ ‘,’ ‘,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
results in :
this one,
sumT =array2table([{k,ZIA,f1pk,’ ‘,’ ‘,’ ‘,R2,Irms,Pload}],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
generates this output.
How do I display the contents of the "containers}?
how can I include doubles and blanks in the same array and then display them as such in a table?
Thank you. I’m trying to create a table from an array for which I need empty certain coluns to display blank (or NA). I tried this….
switch n
case 1
sumT =array2table({k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload},’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 2
sumT =array2table({k,ZIA,’_’,f1,’_’,’_’,R2,Irms,Pload},’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 3
sumT =array2table([k,ZIA,’_’,’_’,f2,’_’,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
case 4
sumT =array2table([k,ZIA,’_’,’_’,’_’,f2pk,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
otherwise
disp(‘oops’)
end
I’ve tried :
array2table({k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload}…
array2table([k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload]…
array2table([{k,ZIA,f1pk,’_’,’_’,’_’,R2,Irms,Pload}]….
etc, but none of these combinations seem to work.
sumT =array2table([k,ZIA,f1pk,’ ‘,’ ‘,’ ‘,R2,Irms,Pload],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
results in :
this one,
sumT =array2table([{k,ZIA,f1pk,’ ‘,’ ‘,’ ‘,R2,Irms,Pload}],’VariableNames’,{‘k’,’ ZIA’, ‘f1pk’,’fres1′,’fres2′,’f2pk’,’R2′,’Irms’,’Pload’})
generates this output.
How do I display the contents of the "containers}?
how can I include doubles and blanks in the same array and then display them as such in a table?
Thank you. cell arrays, tables, mixed variables MATLAB Answers — New Questions
Appointments Created Through Graph API with Local Time and Local Timezone showing as UTC Time
Within the last month Appointments created through the Graph API using Local Time and Local Timezone, have been showing as the UTC time, but still showing the Local Timezone.
Using the Graph API the Appointment Start and End times were set in as local times with the local timezone. Until this last month, these appointments were created successfully and the bookings emails were also showing the correct times. But within the last month, the Times in the Bookings system and emails were showing as UTC.
It seems like Microsoft pushed some update that caused times to be processed differently, the times submitted were treated as UTC times
When did Microsoft push this update and where is the update post on it? Thank you
Within the last month Appointments created through the Graph API using Local Time and Local Timezone, have been showing as the UTC time, but still showing the Local Timezone. Using the Graph API the Appointment Start and End times were set in as local times with the local timezone. Until this last month, these appointments were created successfully and the bookings emails were also showing the correct times. But within the last month, the Times in the Bookings system and emails were showing as UTC.It seems like Microsoft pushed some update that caused times to be processed differently, the times submitted were treated as UTC timesWhen did Microsoft push this update and where is the update post on it? Thank you Read More
