Category: News
Matlab Online Figures Won’t Close
I have a Simulink / Matlab program that runs scrips and generates many figures. They are generated in a script and then closed in the same script. When I run it on the computer the figures close. When I run it online however, the figure contents close but there is a blank figure left that will not close at all. I have to exit Matlab Online and open a new session to ever get rid of them.
How do I properly get Matlab figures to close online?
figure(101);
hold on;
plot(BASEQ.Time,BASEQ.LSAngularWorkonArm);
plot(BASEQ.Time,BASEQ.RSAngularWorkonArm);
plot(BASEQ.Time,BASEQ.LEAngularWorkonForearm);
plot(BASEQ.Time,BASEQ.REAngularWorkonForearm);
plot(BASEQ.Time,BASEQ.LWAngularWorkonClub);
plot(BASEQ.Time,BASEQ.RWAngularWorkonClub);
ylabel(‘Work (J)’);
grid ‘on’;
%Add Legend to Plot
legend(‘LS Angular Work’,’RS Angular Work’,’LE Angular Work’,’RE Angular Work’,’LW Angular Work’,’RW Angular Work’);
legend(‘Location’,’southeast’);
%Add a Title
title(‘Angular Work on Distal Segment’);
subtitle(‘BASE’);
%Save Figure
savefig(‘BaseData Charts/BASE_Plot – Angular Work’);
%Close Figure
close(101);I have a Simulink / Matlab program that runs scrips and generates many figures. They are generated in a script and then closed in the same script. When I run it on the computer the figures close. When I run it online however, the figure contents close but there is a blank figure left that will not close at all. I have to exit Matlab Online and open a new session to ever get rid of them.
How do I properly get Matlab figures to close online?
figure(101);
hold on;
plot(BASEQ.Time,BASEQ.LSAngularWorkonArm);
plot(BASEQ.Time,BASEQ.RSAngularWorkonArm);
plot(BASEQ.Time,BASEQ.LEAngularWorkonForearm);
plot(BASEQ.Time,BASEQ.REAngularWorkonForearm);
plot(BASEQ.Time,BASEQ.LWAngularWorkonClub);
plot(BASEQ.Time,BASEQ.RWAngularWorkonClub);
ylabel(‘Work (J)’);
grid ‘on’;
%Add Legend to Plot
legend(‘LS Angular Work’,’RS Angular Work’,’LE Angular Work’,’RE Angular Work’,’LW Angular Work’,’RW Angular Work’);
legend(‘Location’,’southeast’);
%Add a Title
title(‘Angular Work on Distal Segment’);
subtitle(‘BASE’);
%Save Figure
savefig(‘BaseData Charts/BASE_Plot – Angular Work’);
%Close Figure
close(101); I have a Simulink / Matlab program that runs scrips and generates many figures. They are generated in a script and then closed in the same script. When I run it on the computer the figures close. When I run it online however, the figure contents close but there is a blank figure left that will not close at all. I have to exit Matlab Online and open a new session to ever get rid of them.
How do I properly get Matlab figures to close online?
figure(101);
hold on;
plot(BASEQ.Time,BASEQ.LSAngularWorkonArm);
plot(BASEQ.Time,BASEQ.RSAngularWorkonArm);
plot(BASEQ.Time,BASEQ.LEAngularWorkonForearm);
plot(BASEQ.Time,BASEQ.REAngularWorkonForearm);
plot(BASEQ.Time,BASEQ.LWAngularWorkonClub);
plot(BASEQ.Time,BASEQ.RWAngularWorkonClub);
ylabel(‘Work (J)’);
grid ‘on’;
%Add Legend to Plot
legend(‘LS Angular Work’,’RS Angular Work’,’LE Angular Work’,’RE Angular Work’,’LW Angular Work’,’RW Angular Work’);
legend(‘Location’,’southeast’);
%Add a Title
title(‘Angular Work on Distal Segment’);
subtitle(‘BASE’);
%Save Figure
savefig(‘BaseData Charts/BASE_Plot – Angular Work’);
%Close Figure
close(101); figures, close, plot MATLAB Answers — New Questions
Is Login Named User available on machines without a display?
I have a machine without a GUI or display. Can I still use the Login Named User license option?I have a machine without a GUI or display. Can I still use the Login Named User license option? I have a machine without a GUI or display. Can I still use the Login Named User license option? MATLAB Answers — New Questions
Is there a list of MatLab tutors?
Is there a list of MatLab tutors somewhere that I can hire on an hourly basis to help me get started?
I prefer someone I can talk to by telephone using one of the screen sharing apps.
I probably only need an hour or two to get started, but may need the occasional hour or two later on as I tackle more advanced tasks.Is there a list of MatLab tutors somewhere that I can hire on an hourly basis to help me get started?
I prefer someone I can talk to by telephone using one of the screen sharing apps.
I probably only need an hour or two to get started, but may need the occasional hour or two later on as I tackle more advanced tasks. Is there a list of MatLab tutors somewhere that I can hire on an hourly basis to help me get started?
I prefer someone I can talk to by telephone using one of the screen sharing apps.
I probably only need an hour or two to get started, but may need the occasional hour or two later on as I tackle more advanced tasks. matlab tutors MATLAB Answers — New Questions
How best to get rid of zeroes as a result of empty cells.
A formula in the destination worksheet creates a content based on the contents of a source spreadsheet. In doing so, if a cell is empty in the source worksheet, Excel puts a 0 in its place on the destination worksheet. The formula needs to perform this as the data is being created in the destination worksheet. How best to remove the zero in place of a blank (“”)?
=LET(
data,pi_pkgdata,
recordType,PI_Package!$A$7:$A$1600,
CHOOSECOLS(FILTER(data,(recordType=”PCODE”),”NO RECORDS”),4,158,59,60,58,42,11,12,13,14,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,15,16,139,140,17,19,21,23,25,18,20,22,24,26,157,141,142,143,144,145,146,147,148,149,150,151,152,153,154,41,155,156,49,47,48,46,159,160,161,162,163,164,165,166,167,168,169,170,43,171,44))
A formula in the destination worksheet creates a content based on the contents of a source spreadsheet. In doing so, if a cell is empty in the source worksheet, Excel puts a 0 in its place on the destination worksheet. The formula needs to perform this as the data is being created in the destination worksheet. How best to remove the zero in place of a blank (“”)? =LET(data,pi_pkgdata,recordType,PI_Package!$A$7:$A$1600,CHOOSECOLS(FILTER(data,(recordType=”PCODE”),”NO RECORDS”),4,158,59,60,58,42,11,12,13,14,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,15,16,139,140,17,19,21,23,25,18,20,22,24,26,157,141,142,143,144,145,146,147,148,149,150,151,152,153,154,41,155,156,49,47,48,46,159,160,161,162,163,164,165,166,167,168,169,170,43,171,44)) Read More
anyone else having issues with techcommunity “bell”?
Hi all,
the flyout for the notifications does not seem to render well anymore
logging off / on / shift+F5 does not help.
For “${…}” content: Expected a string or something automatically convertible to string (number, date or boolean), or “template output” , but this has evaluated to a sequence+hash (wrapper: f.e.dom.NodeListModel): ==> notification.target.entity.@view_href [in template “custom.user.profile-private-activity-notifications” at line 105, column 81] —- Tip: This XML query result can’t be used as string because for that it had to contain exactly 1 XML node, but it contains 0 nodes. That is, the constructing XML query has found no matches. —- —- FTL stack trace (“~” means nesting-related): – Failed at: ${notification.target.entity.@view_href} [in template “custom.user.profile-private-activity-notifications” in macro “displayNotificationMessage” at line 105, column 79] – Reached through: @displayNotificationMessage notificat… [in template “custom.user.profile-private-activity-notifications” at line 158, column 41] —-
Hi all,
the flyout for the notifications does not seem to render well anymorelogging off / on / shift+F5 does not help.
For “${…}” content: Expected a string or something automatically convertible to string (number, date or boolean), or “template output” , but this has evaluated to a sequence+hash (wrapper: f.e.dom.NodeListModel): ==> notification.target.entity.@view_href [in template “custom.user.profile-private-activity-notifications” at line 105, column 81] —- Tip: This XML query result can’t be used as string because for that it had to contain exactly 1 XML node, but it contains 0 nodes. That is, the constructing XML query has found no matches. —- —- FTL stack trace (“~” means nesting-related): – Failed at: ${notification.target.entity.@view_href} [in template “custom.user.profile-private-activity-notifications” in macro “displayNotificationMessage” at line 105, column 79] – Reached through: @displayNotificationMessage notificat… [in template “custom.user.profile-private-activity-notifications” at line 158, column 41] —-
Read More
Error importing an Excel database into SQL Server
Error importing an Excel database into SQL Server: An external component threw an exception. (System data)
——————————
Program Location:
en System.Data.OleDb.DataSourceWrapper.InitializeAndCreateSession(OleDbConnectionString constr, SessionWrapper& sessionWrapper)
en System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
en System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
en System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
en System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
en System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
en System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
en System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
en System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
en System.Data.OleDb.OleDbConnection.Open()
en Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
en Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e)
How can I solve that problem? I have installed the 32-bit and 64-bit version of Microsoft Access Database Engine 2016 Redistributable and with neither of them it works, it still gives me the same error. I have 64-bit Office installed.
Error importing an Excel database into SQL Server: An external component threw an exception. (System data) ——————————Program Location: en System.Data.OleDb.DataSourceWrapper.InitializeAndCreateSession(OleDbConnectionString constr, SessionWrapper& sessionWrapper)en System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)en System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)en System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)en System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)en System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)en System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)en System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)en System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)en System.Data.OleDb.OleDbConnection.Open()en Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)en Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e) How can I solve that problem? I have installed the 32-bit and 64-bit version of Microsoft Access Database Engine 2016 Redistributable and with neither of them it works, it still gives me the same error. I have 64-bit Office installed. Read More
Best cameras, microphones, and speakers for main meeting room of (a) 10 people, and (b) 25 people
I will much appreciate advice as to most appropriate gear to achieve a good to excellent experience for both physical attendees at a meeting and also for those remoting in.
I will much appreciate advice as to most appropriate gear to achieve a good to excellent experience for both physical attendees at a meeting and also for those remoting in. Read More
SharePoint Subscription Edition Sync with One Drive
I am not able to get the configuration completed to sync SharePoint using one drive. Windows Server 2022 standard VM, SharePoint Subscription Edition, SQL Server 2022. SharePoint is working, I am the point of configure things for the One Drive Sync to work on the same domain and network with RDS. Any help would be greatly appreciated.
Thank you,
Dee Payton
+1 480-215-7956
email address removed for privacy reasons
I am not able to get the configuration completed to sync SharePoint using one drive. Windows Server 2022 standard VM, SharePoint Subscription Edition, SQL Server 2022. SharePoint is working, I am the point of configure things for the One Drive Sync to work on the same domain and network with RDS. Any help would be greatly appreciated. Thank you,Dee Payton+1 480-215-7956email address removed for privacy reasons Read More
Microsoft will require MFA for all Azure users
This July, Azure teams will begin rolling out additional tenant-level security measures to require multi-factor authentication (MFA). Establishing this security baseline at the tenant level puts in place additional security to protect your cloud investments and company.
MFA is a security method commonly required among cloud service providers and requires users to provide two or more pieces of evidence to verify their identity before accessing a service or a resource. It adds an extra layer of protection to the standard username and password authentication.
The roll-out of this requirement will be gradual and methodical to minimize impact on your use cases. The blog post below provides helpful information from the Azure product team to assist you in getting ready to MFA-enable your access to Azure services. Going forward, the team will provide communications to you about your specific roll-out dates through direct emails and Azure Portal notifications. Expect these in the coming months.
Read on to learn why and how MFA is important to securing customers on Azure and your workloads, environments, and users.
If you do not wait to wait for the roll-out, set up MFA now with the MFA wizard for Microsoft Entra.
– Erin
How MFA works
Multi-factor authentication (MFA) is a security method that requires users to provide two or more pieces of evidence to verify their identity before accessing a service or a resource. The evidence can be something the user knows (such as a password or a PIN), something the user has (such as a phone or a token), or something the user is (such as a fingerprint or a face scan).
MFA adds an extra layer of protection to the standard username and password authentication, making it harder for attackers to compromise accounts and steal data. MFA can also help prevent unauthorized access due to phishing, credential stuffing, brute force, or password reuse attacks.
Entra ID supports various MFA methods, such as Microsoft Authenticator app, SMS, voice call, and hardware tokens. Users can choose the method that suits their preferences and needs. Admins can also use Entra ID Conditional Access policies to tune when MFA is required based on signals such as the user’s location, device, role, or risk level.
Why MFA is important for Azure tenant security
The need for MFA is more important than ever, as cyberattacks are becoming more frequent, sophisticated, and damaging. According to a report by Microsoft, 99.9% of compromised accounts did not use MFA. The report also found that MFA can block more than 99.2% of account compromise attacks, making it one of the most effective security measures available. As noted in the report, MFA can block more than 99.9% of account compromise attacks, making it one of the most effective security measures available.
The rise of the hybrid workforce and accelerated digital transformation of businesses by the COVID-19 pandemic expanded risk scenarios for employees and companies. Today, more people work outside of the office and access data and applications from various devices and locations. All of this has increased the attack surface and the potential for unauthorized access, as users may use unsecured networks, devices, or passwords. MFA can help mitigate these risks by adding an extra verification step and preventing access from unknown or suspicious sources.
MFA is also a key component of identity and access management, which involves ensuring that only authorized and authenticated users can access the services and resources. One of the three areas of engineering advancements within Microsoft’s Secure Future Initiative focuses on implementing new identity protections and MFA at the tenant level helps you with identity protections. MFA not only reduces the risk of account compromise and data breach, but it also helps you comply with various security standards and regulations, such as PCI DSS, HIPAA, GDPR, and NIST.
Don’t wait to set up MFA
To help you keep users and data safe, MFA is now available and free for you to enable at the tenant level. You can set up MFA today with the MFA wizard for Microsoft Entra.
If you have additional questions, please review the MFA FAQ on Microsoft Learn for more information and learn more about the Secure Future Initiative and Microsoft’s built-in security features here.
Microsoft Tech Community – Latest Blogs –Read More
Project for the Web Roadmap Visualisation
We have just start to use this solution and noticing that on some project added to the roadmap that the first task selected to be displayed is not shown in the designed order, even though the entered dates and order of tasks should have it displayed at the top of the added roadmap entry. This makes for a messy visualisation of the created roadmap entry and reduces its value.
We have recreated entries in the roadmap, and even the roadmap itself and still have the experience.
Keen to understand if anyone else is having the same experience and whether this is a known issue with the solution?
We have just start to use this solution and noticing that on some project added to the roadmap that the first task selected to be displayed is not shown in the designed order, even though the entered dates and order of tasks should have it displayed at the top of the added roadmap entry. This makes for a messy visualisation of the created roadmap entry and reduces its value. We have recreated entries in the roadmap, and even the roadmap itself and still have the experience. Keen to understand if anyone else is having the same experience and whether this is a known issue with the solution? Read More
Sumifs and Dates
I am trying to use the SUMIFS function but am unsure how to include the day and month as one of the criteria. I tried “5/1-5/31” and even listed all the days and set it as “K1:K30” but neither works.
I am trying to use the SUMIFS function but am unsure how to include the day and month as one of the criteria. I tried “5/1-5/31” and even listed all the days and set it as “K1:K30” but neither works. Read More
Copying date from one sheet to another sheet using script.
I am using power automate to create a PDF of a worksheet and email to someone. Now the worksheet if populated by formulas. Therefore, when power automate pulls the worksheet to creat a PDF the data doesn’t come with it.
So I figured no big deal, i’ll just create a script that will copy the formula filled data to paste the values and formating to another worksheet.
Well, after banging my head agains the wall for about 3 hours, I can’t seem to get it to work.
I was able to come up with this using the record actions button.
function main(workbook: ExcelScript.Workbook) {
let report8453 = workbook.getWorksheet(“Report8453”);
let selectedSheet = workbook.getActiveWorksheet();
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange().copyFrom(selectedSheet.getRange(), ExcelScript.RangeCopyType.values, false, false);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange().copyFrom(selectedSheet.getRange(), ExcelScript.RangeCopyType.formats, false, false);
}
But what I found out real fast is that this only works with what ever worksheet you are currently looking at. So if you don’t watch it, you’ll copy and paste to the wrong worksheet and also find out real fast there is no undo.
So after going back and restoring to an orginal version of what I am looking at. I came up with this.
function main(workbook: ExcelScript.Workbook) {
let Tn8453 = workbook.getWorksheet(“Tn8453”);
let report8453 = workbook.getWorksheet(“Report8453”);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange(“A1:D18”).copyFrom(Tn8453.getRange(“A1:D18”), ExcelScript.RangeCopyType.values, false, false);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange(“A1:D18”).copyFrom(Tn8453.getRange(“A1:D18”), ExcelScript.RangeCopyType.formats, false, false);
}
This is the code that I came up with, and it worked for about 2 min, then started getting an error.
Line 5: Range copyFrom: There was an internal error while processing the request.
What I thought I was doing was telling it to go to worksheet Tn8453 and copy those cells, and then pasting what I needed. But still get the error above.
Now at the very least, I just manully did what I wanted, and it came out looking great.
Is there something missing?
Thank you for your help.
Chip
I am using power automate to create a PDF of a worksheet and email to someone. Now the worksheet if populated by formulas. Therefore, when power automate pulls the worksheet to creat a PDF the data doesn’t come with it. So I figured no big deal, i’ll just create a script that will copy the formula filled data to paste the values and formating to another worksheet. Well, after banging my head agains the wall for about 3 hours, I can’t seem to get it to work. I was able to come up with this using the record actions button. function main(workbook: ExcelScript.Workbook) {
let report8453 = workbook.getWorksheet(“Report8453”);
let selectedSheet = workbook.getActiveWorksheet();
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange().copyFrom(selectedSheet.getRange(), ExcelScript.RangeCopyType.values, false, false);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange().copyFrom(selectedSheet.getRange(), ExcelScript.RangeCopyType.formats, false, false);
} But what I found out real fast is that this only works with what ever worksheet you are currently looking at. So if you don’t watch it, you’ll copy and paste to the wrong worksheet and also find out real fast there is no undo. So after going back and restoring to an orginal version of what I am looking at. I came up with this. function main(workbook: ExcelScript.Workbook) {
let Tn8453 = workbook.getWorksheet(“Tn8453”);
let report8453 = workbook.getWorksheet(“Report8453”);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange(“A1:D18”).copyFrom(Tn8453.getRange(“A1:D18”), ExcelScript.RangeCopyType.values, false, false);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange(“A1:D18”).copyFrom(Tn8453.getRange(“A1:D18”), ExcelScript.RangeCopyType.formats, false, false);
} This is the code that I came up with, and it worked for about 2 min, then started getting an error. Line 5: Range copyFrom: There was an internal error while processing the request. What I thought I was doing was telling it to go to worksheet Tn8453 and copy those cells, and then pasting what I needed. But still get the error above. Now at the very least, I just manully did what I wanted, and it came out looking great. Is there something missing? Thank you for your help.Chip Read More
Embedded workbook Dropdown list not Working
Hi everyone,
I have a workbook with multiple dropdowns embedded from onedrive into our website as an IFrame.
All was working prefect till about 10 May when all the dropdowns stopped working (no arrow and no values)
If I open it in onedrive or desktop, everything works perfectly.
What I’ve tried so far with no success:
1. Confirmed embedded code has “AllowTyping=True”.
2. Scroll lock is not on (think this would be issue on desktop app)
3. Advance/Display options: For Objects, Show “ALL” is selected.
4. Document is not corrupted: Re did the whole document from scratch with updated Data validation lists from only a single sheet (previous was from multiple sheets)
5. Same issue in Chrome & Edge. Requested friends and work colleagues to try on their PC’s with all having the same issue with the dropdowns.
I have noticed when embedding in onedrive at “customize how this embedded workbook will appear….” as soon as I “view actual size” the dropdowns disappear, same as the Iframe in the website.
This is from a public site so not sure if I’m allowed to share the site link or even the embedded code?
Please help as this was suppose to be for a product launch on Monday but due to this everything is on hold.
Any help will be appreciated!
Link to our Site:
Embedded Excel Calculator in our Website
Hi everyone, I have a workbook with multiple dropdowns embedded from onedrive into our website as an IFrame.All was working prefect till about 10 May when all the dropdowns stopped working (no arrow and no values)If I open it in onedrive or desktop, everything works perfectly.What I’ve tried so far with no success:1. Confirmed embedded code has “AllowTyping=True”.2. Scroll lock is not on (think this would be issue on desktop app)3. Advance/Display options: For Objects, Show “ALL” is selected.4. Document is not corrupted: Re did the whole document from scratch with updated Data validation lists from only a single sheet (previous was from multiple sheets)5. Same issue in Chrome & Edge. Requested friends and work colleagues to try on their PC’s with all having the same issue with the dropdowns. I have noticed when embedding in onedrive at “customize how this embedded workbook will appear….” as soon as I “view actual size” the dropdowns disappear, same as the Iframe in the website. This is from a public site so not sure if I’m allowed to share the site link or even the embedded code?Please help as this was suppose to be for a product launch on Monday but due to this everything is on hold.Any help will be appreciated!Link to our Site:Embedded Excel Calculator in our Website Read More
Outlook deleting forwarded email
We have 4 email accounts that end in *name.onmicrosoft.com that is used for teams account. When we forward a meeting invite to those accounts, it automatically gets sent to trash folder. We looked at setting on outlook.com but can’t seem to get it to stay in inbox. Kind of lost where to look next.
Would there be a setting in our microsoft365 account or azure account that we could check for?
send and receiving emails works as it should but its only when we forward an invite to those address, it automatically gets deleted.
any help would be appreciated.
Thank you!
We have 4 email accounts that end in *name.onmicrosoft.com that is used for teams account. When we forward a meeting invite to those accounts, it automatically gets sent to trash folder. We looked at setting on outlook.com but can’t seem to get it to stay in inbox. Kind of lost where to look next. Would there be a setting in our microsoft365 account or azure account that we could check for?send and receiving emails works as it should but its only when we forward an invite to those address, it automatically gets deleted. any help would be appreciated.Thank you! Read More
Insurance spreadsheet
Hi
I am trying to get the spreadsheet to give a sum of zero in the cell if the formula sums to a negative number or keep the positive number if it is greater than 0.
I am solving for how much the insurance company will pay.
Scenario-
If the Amt billed to insurance is <Deductible then the patient will pay
If the Amt billed to insurance is >Deductible then Insurance will pay the amount over the deductible-coinsurance.
After the deductible is paid by the patient, then they will owe the coinsurance % for the amount over the deductible and the insurance will pay the balance.
Example
$1357 billed to insurance
$500 Deductible 20% coinsurance
$1357-500 (pt amount of Ded)
$857 * 20% coinsurance =$171.40
Patient would pay $500 ded and $171.40 coinsurance for total of $671.40.
Insurance would pay $685.60
If the Deductible was $5000 then $1357 would be billed and it would all be patient deductible.
I cannot figure out how to make my spreadsheet work!
Insurance Covered ServicesUnits CostTotal Billed AmountCODEIns Units AETNATotal Contractual AmountRe-exams2 $65.00$130.0099212 $36.61$73.22Manipulations 1-2 reg0 $55.00$0.0098940 $24.56$0.00Manipulations 3-4 reg18 $65.00$1,170.0098941 $34.28$617.04Extra Spinal0 $38.00$0.0098943 $23.06$0.00Estim22 $30.00$0.0097014 $13.28$0.00Traction18 $33.00$594.0097012 $13.82$248.76 Rehab16 $30.00$480.0097110 $26.14$418.24 $2,374.00 $1,357.26Total Insurance Billed Amount $1,357.26Insurance Contractual $1,357.26Estimated Insurance Adjustment $1,016.74Noncovered Services Cash Manipulations3 $60.00$180.00 Cash Re-exam3 $50.00$150.00 Cash Rehab 0 $20.00$0.00 Cash Acupuncture/Dry Needling0 $60.00$0.00 Cash Decompression0 $60.00$0.00 SoftWave0 $ – $0.00 Total Noncovered Services $330.00 Total Insurance and Noncovered Services $1,687.26Deductible to be met: $500.00Services after deductible $0.00Coinsurance 20.00% $171.45Copays $0.00 $0.00Estimated insurance payment $685.81Estimated Patient Balance $1,001.45
HiI am trying to get the spreadsheet to give a sum of zero in the cell if the formula sums to a negative number or keep the positive number if it is greater than 0.I am solving for how much the insurance company will pay. Scenario-If the Amt billed to insurance is <Deductible then the patient will payIf the Amt billed to insurance is >Deductible then Insurance will pay the amount over the deductible-coinsurance. After the deductible is paid by the patient, then they will owe the coinsurance % for the amount over the deductible and the insurance will pay the balance.Example$1357 billed to insurance$500 Deductible 20% coinsurance$1357-500 (pt amount of Ded)$857 * 20% coinsurance =$171.40Patient would pay $500 ded and $171.40 coinsurance for total of $671.40. Insurance would pay $685.60 If the Deductible was $5000 then $1357 would be billed and it would all be patient deductible. I cannot figure out how to make my spreadsheet work! Insurance Covered ServicesUnits CostTotal Billed AmountCODEIns Units AETNATotal Contractual AmountRe-exams2 $65.00$130.0099212 $36.61$73.22Manipulations 1-2 reg0 $55.00$0.0098940 $24.56$0.00Manipulations 3-4 reg18 $65.00$1,170.0098941 $34.28$617.04Extra Spinal0 $38.00$0.0098943 $23.06$0.00Estim22 $30.00$0.0097014 $13.28$0.00Traction18 $33.00$594.0097012 $13.82$248.76 Rehab16 $30.00$480.0097110 $26.14$418.24 $2,374.00 $1,357.26Total Insurance Billed Amount $1,357.26Insurance Contractual $1,357.26Estimated Insurance Adjustment $1,016.74Noncovered Services Cash Manipulations3 $60.00$180.00 Cash Re-exam3 $50.00$150.00 Cash Rehab 0 $20.00$0.00 Cash Acupuncture/Dry Needling0 $60.00$0.00 Cash Decompression0 $60.00$0.00 SoftWave0 $ – $0.00 Total Noncovered Services $330.00 Total Insurance and Noncovered Services $1,687.26Deductible to be met: $500.00Services after deductible $0.00Coinsurance 20.00% $171.45Copays $0.00 $0.00Estimated insurance payment $685.81Estimated Patient Balance $1,001.45 Read More
Upcoming May 2023 Microsoft 365 Champion Community Call
Join our next community call on May 28 to deep dive into the Copilot for Microsoft 365 Success Kit. We will be starting the call at 5 minutes past the hour for both of our sessions (at 8:05 AM and 5:05 PM PT), and it will still end at the top of the hour (9:00 AM and 6:00 PM PT, respectively).
If you have not yet joined our Champion community, sign up here to get access to the calendar invites, program assets, and previous call recordings.
Microsoft Tech Community – Latest Blogs –Read More
Consolidated Recommendation API Phase 1
We are pleased to announce the release of Phase 1 of our new Consolidated Recommendation API.
The Consolidated Recommendation API introduces a unified interface structure that enables developers to retrieve, apply, or dismiss recommendations in a unified pattern. Instead of requiring individual API calls for each new recommendation, this pipeline will surface any current and new recommendations with a single implementation.
This release supports budget, keyword, and responsive search ads recommendations. Get recommendations with a single service operation RetrieveRecommendations, and apply them with ApplyRecommendations.
Key Features
No need to code each recommendation separately.
Work with current and new recommendations in a single implementation.
Reduce developer effort.
Easier integration of systems with Microsoft Advertising recommendations.
New API Interfaces
Ad Insight API
ApplyRecommendationEntity, ApplyRecommendations, BudgetPointType, CampaignBudgetRecommendation, DismissRecommendationEntity, DismissRecommendations, KeywordRecommendation, RecommendationBase, RecommendationType, ResponsiveSearchAdRecommendation, RetrieveRecommendations.
Learn more about the Micrsoft Advertising Ad Insight API service operations.
Microsoft Tech Community – Latest Blogs –Read More
Variable Browser Tab Issue
So I was using the Variable Browser ealier today and for some reason, the tab in the Variable Browser is actually not showing up. Can you tell me if there is a way to get that tab back.
This is the proof btw.So I was using the Variable Browser ealier today and for some reason, the tab in the Variable Browser is actually not showing up. Can you tell me if there is a way to get that tab back.
This is the proof btw. So I was using the Variable Browser ealier today and for some reason, the tab in the Variable Browser is actually not showing up. Can you tell me if there is a way to get that tab back.
This is the proof btw. variable browser MATLAB Answers — New Questions
Offline Documentation works for GUI, but not for CLI
We installed the docuemtation ISO on our RHEL 8 server that is offline and we are able to get to the documentation from the gui by changing the help to localy installed.
However, the >>> doc command bring up nothing – just drops to the promps after typing it.
We are on 2024a.
We also set a startup.m file with the docroot listed for the full path – although, this might not be needed because its locally installed in the Matlab directory.We installed the docuemtation ISO on our RHEL 8 server that is offline and we are able to get to the documentation from the gui by changing the help to localy installed.
However, the >>> doc command bring up nothing – just drops to the promps after typing it.
We are on 2024a.
We also set a startup.m file with the docroot listed for the full path – although, this might not be needed because its locally installed in the Matlab directory. We installed the docuemtation ISO on our RHEL 8 server that is offline and we are able to get to the documentation from the gui by changing the help to localy installed.
However, the >>> doc command bring up nothing – just drops to the promps after typing it.
We are on 2024a.
We also set a startup.m file with the docroot listed for the full path – although, this might not be needed because its locally installed in the Matlab directory. offline documentation, cli MATLAB Answers — New Questions
New Blog | Microsoft Teams DLP Playbook
May 2024 Edition
We’re so excited to publish the updated Teams DLP Playbook!
This document provides an overview of how enterprise customers can deploy Microsoft Teams-DLP for protecting sensitive information. Microsoft Purview Data Loss Prevention has integrations with multiple workloads that help to protect customer data with a single policy. Teams DLP is one of the workloads within Microsoft Purview Data Loss Prevention. This guide walks through the different aspects of deploying use cases across content/containers.
Get the full book here: Microsoft Teams DLP Playbook
By Sarahzin Shane
May 2024 Edition
We’re so excited to publish the updated Teams DLP Playbook!
This document provides an overview of how enterprise customers can deploy Microsoft Teams-DLP for protecting sensitive information. Microsoft Purview Data Loss Prevention has integrations with multiple workloads that help to protect customer data with a single policy. Teams DLP is one of the workloads within Microsoft Purview Data Loss Prevention. This guide walks through the different aspects of deploying use cases across content/containers.
Get the full book here: Microsoft Teams DLP Playbook