Month: July 2024
Team Channel Post Order Concern
My organization uses team channels across multiple office locations. We have consolidated into managing all case files across our region. We manage most communications and shared documents/ spreadsheets through team’s channels related to specific tasks/ roles a staff member may be working in for that day. Due to the rapid turnover (daily task changes) we need clear organization within our teams channels.
We post case tasks in teams in certain channels for follow up. These build up rapidly as we have thousands of case files and a never ending chain of work. Some days channels can have 10-20 action items posted. The problem comes into play when someone actions an item and comments on the post. It then pulls the post to the most recent spot (top or bottom depending on how it set). We are needing the posts to stay in order of date/ time posted as we start to lose items that haven’t been actioned yet. Everyday we are digging through posts trying to make sure all get actioned. It’s very stressful and not efficient. Maybe teams is not the best method but we haven’t sorted out an alternative since this suddenly change in our division.
Is there anyway we can adjust the order settings for posts in channels?
My organization uses team channels across multiple office locations. We have consolidated into managing all case files across our region. We manage most communications and shared documents/ spreadsheets through team’s channels related to specific tasks/ roles a staff member may be working in for that day. Due to the rapid turnover (daily task changes) we need clear organization within our teams channels. We post case tasks in teams in certain channels for follow up. These build up rapidly as we have thousands of case files and a never ending chain of work. Some days channels can have 10-20 action items posted. The problem comes into play when someone actions an item and comments on the post. It then pulls the post to the most recent spot (top or bottom depending on how it set). We are needing the posts to stay in order of date/ time posted as we start to lose items that haven’t been actioned yet. Everyday we are digging through posts trying to make sure all get actioned. It’s very stressful and not efficient. Maybe teams is not the best method but we haven’t sorted out an alternative since this suddenly change in our division. Is there anyway we can adjust the order settings for posts in channels? Read More
Stockhistory data doesnt update for today but using the STOCK.Price function does
Using stockhistory formula on some stocks to pull stock price for 3-months or 1-year historical. However, they never include todays stock price even a few hours after close. I checked (https://support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6)) which states that the delay is 15 mins for US stocks yet it wont show these values in stockhistory formula. It does work if you use STOCKCELL.price but wondering why there is a discrepancy here.
Using stockhistory formula on some stocks to pull stock price for 3-months or 1-year historical. However, they never include todays stock price even a few hours after close. I checked (https://support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6)) which states that the delay is 15 mins for US stocks yet it wont show these values in stockhistory formula. It does work if you use STOCKCELL.price but wondering why there is a discrepancy here. Read More
Fix QuickBook𝘀 Keeps Crashing error says “QuickBook𝘀 Not Responding”
I’ve been using QuickBook𝘀 for my small business for a while now, but recently I’ve been encountering a frustrating issue. Every time I try to open QuickBook𝘀, it crashes and displays a message that says “QuickBook𝘀 is not responding.” This happens right after the program launches, and I’m unable to proceed further.
I’ve been using QuickBook𝘀 for my small business for a while now, but recently I’ve been encountering a frustrating issue. Every time I try to open QuickBook𝘀, it crashes and displays a message that says “QuickBook𝘀 is not responding.” This happens right after the program launches, and I’m unable to proceed further. Read More
Help me Fix QuickBook𝘀 Keeps Freezing issue after update
I’ve been using QuickBook𝘀 for managing my business finances, but I’ve been running into a persistent issue lately. While I’m working in QuickBook𝘀, the application frequently freezes, making it impossible to continue with my tasks.
I’ve been using QuickBook𝘀 for managing my business finances, but I’ve been running into a persistent issue lately. While I’m working in QuickBook𝘀, the application frequently freezes, making it impossible to continue with my tasks. Read More
How to Fix QuickBook𝘀 Crashes on Startup in Windows 11
I’m facing a frustrating issue with QuickBook𝘀 that I hope someone can help me with. Every time I try to launch QuickBook𝘀, it crashes immediately on startup, and I’m unable to access any of my financial data.
I’m facing a frustrating issue with QuickBook𝘀 that I hope someone can help me with. Every time I try to launch QuickBook𝘀, it crashes immediately on startup, and I’m unable to access any of my financial data. Read More
Excel Chess Games Viewer 2.1
Excel Chess Games Viewer 2.1 is a slightly upgraded version of my Excel Chess Games Viewer 2.0, which now includes an option to flip the chessboard, and 77 of the most famous chess games ever.
Can you guess the brilliant move 29 for Black, in the game below?
Happy International Chess Day!
Excel Chess Games Viewer 2.1 is a slightly upgraded version of my Excel Chess Games Viewer 2.0, which now includes an option to flip the chessboard, and 77 of the most famous chess games ever. Can you guess the brilliant move 29 for Black, in the game below? Happy International Chess Day! Read More
New Blog | Leveraging insider risk visibility to strengthen your data security
Recent research reveals that insider risks are surging more each day. Over the past year, an alarming 63%[1] of data breaches were traced back to insiders, whether through inadvertent errors or malicious intent. These internal threats call for innovative solutions that can dynamically adapt to data security risks, instead of the widely available fragmented and one-size-fits-all solutions, where rigid controls can stymie legitimate business activities and lenient policies might leave the door open to data loss.
Striking the right balance between productivity and data security is critical, and that’s where the user visibility of Microsoft Purview Insider Risk Management, combined with the dynamic controls of Adaptive Protection, can help. These solutions enable organizations to tailor data protection strategies by integrating insider risk levels, determined by user activities, with different policy engines, allowing for automatic adjustments of policies as insider risk levels change.
Microsoft Purview Insider Risk Management correlates various signals, such as unusual access patterns and data exfiltration, to identify potential malicious or inadvertent insider risks, including IP theft, data leakage, and security violations. Insider Risk Management enables customers to create data handling policies based on their own internal policies, governance, and organizational requirements. Built with privacy by design, users are pseudonymized by default, and role-based access controls and audit logs are in place to help ensure user-level privacy.
The evolution of dynamic controls with Adaptive Protection within access management
This week we’re thrilled to announce the general availability of the integration between Adaptive Protection in Microsoft Purview and Microsoft Entra Conditional Access. Organizations frequently struggle to implement effective data security and access management because they rely on fragmented and siloed solutions. These disjointed approaches hinder the consistent rollout of new security controls and can create exploitable gaps. Microsoft’s integration of Adaptive Protection and Conditional Access, however, offers a streamlined and integrated solution that seamlessly automates access controls for users based on their insider risk levels, thereby reducing the complexity of managing multiple disparate systems.
Consider a scenario where an employee at an organization is flagged as a potential insider risk; they are working on a sensitive project and they start to demonstrate risky activity detected in Insider Risk Management. With the integration of Adaptive Protection and Conditional Access, the organization can swiftly apply access policies to this employee if needed, and these policy controls can increase as the employee’s activities become riskier. The policy will then automatically ramp up controls and can restrict access to critical applications and systems without manual involvement of the data security admin, thus adding a protective layer against insider risks.
In Conditional Access, admins can now combine insights on insider and sign-in risks, to protect data against both external and internal threats with a comprehensive and multi-layered security strategy against unauthorized access, data leaks, and theft. With Conditional Access now being used to tackle both external and insider threats, your data remains secure, thereby bolstering your organization’s resilience against evolving cyber threats.
Read the full post here: Leveraging insider risk visibility to strengthen your data security
By Nathalia Borges
Recent research reveals that insider risks are surging more each day. Over the past year, an alarming 63%[1] of data breaches were traced back to insiders, whether through inadvertent errors or malicious intent. These internal threats call for innovative solutions that can dynamically adapt to data security risks, instead of the widely available fragmented and one-size-fits-all solutions, where rigid controls can stymie legitimate business activities and lenient policies might leave the door open to data loss.
Striking the right balance between productivity and data security is critical, and that’s where the user visibility of Microsoft Purview Insider Risk Management, combined with the dynamic controls of Adaptive Protection, can help. These solutions enable organizations to tailor data protection strategies by integrating insider risk levels, determined by user activities, with different policy engines, allowing for automatic adjustments of policies as insider risk levels change.
Microsoft Purview Insider Risk Management correlates various signals, such as unusual access patterns and data exfiltration, to identify potential malicious or inadvertent insider risks, including IP theft, data leakage, and security violations. Insider Risk Management enables customers to create data handling policies based on their own internal policies, governance, and organizational requirements. Built with privacy by design, users are pseudonymized by default, and role-based access controls and audit logs are in place to help ensure user-level privacy.
The evolution of dynamic controls with Adaptive Protection within access management
This week we’re thrilled to announce the general availability of the integration between Adaptive Protection in Microsoft Purview and Microsoft Entra Conditional Access. Organizations frequently struggle to implement effective data security and access management because they rely on fragmented and siloed solutions. These disjointed approaches hinder the consistent rollout of new security controls and can create exploitable gaps. Microsoft’s integration of Adaptive Protection and Conditional Access, however, offers a streamlined and integrated solution that seamlessly automates access controls for users based on their insider risk levels, thereby reducing the complexity of managing multiple disparate systems.
Consider a scenario where an employee at an organization is flagged as a potential insider risk; they are working on a sensitive project and they start to demonstrate risky activity detected in Insider Risk Management. With the integration of Adaptive Protection and Conditional Access, the organization can swiftly apply access policies to this employee if needed, and these policy controls can increase as the employee’s activities become riskier. The policy will then automatically ramp up controls and can restrict access to critical applications and systems without manual involvement of the data security admin, thus adding a protective layer against insider risks.
In Conditional Access, admins can now combine insights on insider and sign-in risks, to protect data against both external and internal threats with a comprehensive and multi-layered security strategy against unauthorized access, data leaks, and theft. With Conditional Access now being used to tackle both external and insider threats, your data remains secure, thereby bolstering your organization’s resilience against evolving cyber threats.
Figure 1: New ‘insider risk’ condition in Conditional Access
Read the full post here: Leveraging insider risk visibility to strengthen your data security Read More
Windows Update Error 0x800f0983 Cumulative Update for Windows 11 Insider Preview (10.0.26120.1252)
Hi,
I can’t install the Cumulative Update for Windows 11 Insider Preview (10.0.26120.1252) (KB5038603) on Windows Update, it shows the error 0x800f0983. I’m Brazilian and I’m deaf too… The English language is very hard for me… I have the Insider Preview, Dev Channel, installed on my Windows 11 PRO.
The Diagnostics Tools for Repair the Windows Update doesn’t works, and I already try the REM command to change the CatRoot2 folder name, but its fails due to banned permission rights.
I need help, please…
Hi, I can’t install the Cumulative Update for Windows 11 Insider Preview (10.0.26120.1252) (KB5038603) on Windows Update, it shows the error 0x800f0983. I’m Brazilian and I’m deaf too… The English language is very hard for me… I have the Insider Preview, Dev Channel, installed on my Windows 11 PRO. The Diagnostics Tools for Repair the Windows Update doesn’t works, and I already try the REM command to change the CatRoot2 folder name, but its fails due to banned permission rights. I need help, please… Read More
Project for Web – Project Access issues
Hi, We have all our projects on Project for Web. All of a sudden since a couple of days ago the project managers and also resources are not able to access some of their projects. I am not able to pinpoint a pattern to which projects. It is happening to multiple projects and every person has access limits to one or more projects. For example PM1 has access to his Project1 but not to Project2. The resource1 who is assigned to both of these projects can not open either of them. Also this started last week. So until last week they were all able to access all their projects!
How can I troubleshoot this?
This is the error they get on Microsoft Project Web:
this is the error they get when trying to open the app on Project Model Driven App:
Hi, We have all our projects on Project for Web. All of a sudden since a couple of days ago the project managers and also resources are not able to access some of their projects. I am not able to pinpoint a pattern to which projects. It is happening to multiple projects and every person has access limits to one or more projects. For example PM1 has access to his Project1 but not to Project2. The resource1 who is assigned to both of these projects can not open either of them. Also this started last week. So until last week they were all able to access all their projects! How can I troubleshoot this? This is the error they get on Microsoft Project Web: this is the error they get when trying to open the app on Project Model Driven App: Read More
iOS Personal Not Installing Required Applications
I configured Intune to setup BYOD iOS personal devices.
Everything was working. I retired my phone from Intune so that I could document the process. After documenting the process, I noticed that the required applications were not installing even after several days. While my phone shows Compliant in Intune, I did noticed that the Serial and Phone numbers of the phone were not being populated in the Overview.
Also I check the help & support page. After running my email address, this came up:
Any help would be appreciated.
I configured Intune to setup BYOD iOS personal devices. Everything was working. I retired my phone from Intune so that I could document the process. After documenting the process, I noticed that the required applications were not installing even after several days. While my phone shows Compliant in Intune, I did noticed that the Serial and Phone numbers of the phone were not being populated in the Overview. Also I check the help & support page. After running my email address, this came up: Any help would be appreciated. Read More
Copy rows from one set of sheets to another set of sheets, based on a condition
Hey all!
Newbie, and could use some help, as I am not sure of the best way to achieve what I’m hoping to do :grinning_face:
Effectively, various focus areas for a company have been identified (IT, HR, FINANCE, COMMS, SALES). One sheet for each.
Each focus area has tasks assigned there.
Each of these tasks is assigned to a specific region (South, North, West, East, Central). One sheet per each.
There are five focus areas, and five regions
So, looking at the ‘IT” sheet, I want all the tasks taking place in the SOUTH to be copied to a ‘SOUTH’ sheet
Then, still looking at the ‘ IT’ sheet, I want all the tasks taking place in the “NORTH’ to be copied to NORTH’ sheet.
You’d make your way through all the IT tasks, then HR then finance, then comms, then sales, with tasks for each copied to a new sheet correlating with the region.
Basically, every task that’s assigned to a focus area will be copied to its respective region tab.
I’ve seen examples of copying one or even two to another tab, but really not sure how it operates with multiples!
Pls note, the other columns (C to E) are blank now, but will have data later. I also cannot lump all the focus areas into a single sheet 🙁
Graphics below!
Thank you!
Hey all!Newbie, and could use some help, as I am not sure of the best way to achieve what I’m hoping to do :grinning_face: Effectively, various focus areas for a company have been identified (IT, HR, FINANCE, COMMS, SALES). One sheet for each. Each focus area has tasks assigned there. Each of these tasks is assigned to a specific region (South, North, West, East, Central). One sheet per each. There are five focus areas, and five regions So, looking at the ‘IT” sheet, I want all the tasks taking place in the SOUTH to be copied to a ‘SOUTH’ sheet Then, still looking at the ‘ IT’ sheet, I want all the tasks taking place in the “NORTH’ to be copied to NORTH’ sheet. You’d make your way through all the IT tasks, then HR then finance, then comms, then sales, with tasks for each copied to a new sheet correlating with the region. Basically, every task that’s assigned to a focus area will be copied to its respective region tab. I’ve seen examples of copying one or even two to another tab, but really not sure how it operates with multiples! Pls note, the other columns (C to E) are blank now, but will have data later. I also cannot lump all the focus areas into a single sheet 🙁 Graphics below! Thank you! Read More
libstdc++.so.6: __cxa_thread_atexit_impl: invalid needed version 54
I got the error as show in my quesiton while I’m compling a fortran program on linux using matlab mex and libraries: libstdc++.so.6: __cxa_thread_atexit_impl: invalid needed version 54. Could some one help resolve this problem? Thank you!I got the error as show in my quesiton while I’m compling a fortran program on linux using matlab mex and libraries: libstdc++.so.6: __cxa_thread_atexit_impl: invalid needed version 54. Could some one help resolve this problem? Thank you! I got the error as show in my quesiton while I’m compling a fortran program on linux using matlab mex and libraries: libstdc++.so.6: __cxa_thread_atexit_impl: invalid needed version 54. Could some one help resolve this problem? Thank you! libstdc++.so MATLAB Answers — New Questions
Update booking events to individual staff member’s office 365 calendar
How to update individual staff member’s calendar with the booking events?
How to update individual staff member’s calendar with the booking events? Read More
VBA
Need to find errors in this excel VBA Code
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet
Set ws = Me
Dim selectedQueue As String
Dim col As Integer
Dim cell As Range
Dim queueFound As Boolean
Dim i As Long
‘ Handle queue selection in cell A1
If Not Intersect(Target, Range(“A1”)) Is Nothing Then
selectedQueue = ws.Range(“A1”).Value
queueFound = False
‘ Unhide/hide columns based on queue selection
On Error GoTo ErrorHandler
Application.ScreenUpdating = False
‘ Loop through columns G to CZ
For col = 7 To 104
If ws.Cells(5, col).MergeCells Then
Set cell = ws.Cells(5, col).MergeArea
If Not IsError(cell.Cells(1, 1).Value) And Not IsEmpty(cell.Cells(1, 1).Value) Then
If Trim(CStr(cell.Cells(1, 1).Value)) = Trim(selectedQueue) Or Trim(selectedQueue) = “All Queues” Then
‘ Unhide the columns if they are hidden
If cell.Columns.Hidden Then
cell.Columns.Hidden = False
End If
‘ Select the first cell of the unhidden merged area
cell.Cells(1, 1).Select
queueFound = True
Else
‘ Hide the columns if they are not the selected queue
cell.Columns.Hidden = True
End If
End If
Else
‘ If the column is blank, hide it
ws.Columns(col).Hidden = True
End If
Next col
‘ If “All Queues” is selected, show all queues data
If selectedQueue = “All Queues” Then
For col = 7 To 104
ws.Columns(col).Hidden = False
Next col
queueFound = True
End If
‘ If the queue is not found, show a message
If Not queueFound Then
MsgBox “Queue not found in row 5.”
End If
Application.ScreenUpdating = True
Exit Sub
ErrorHandler:
MsgBox “An error occurred: ” & Err.Description
Application.ScreenUpdating = True
End If
‘ Handle status changes and timestamping
If Not Intersect(Target, Range(“G6:G1000”)) Is Nothing Then
If Not IsEmpty(Target) Then
‘ Define headers and their corresponding columns
Dim headers As Variant
headers = Array(“Status”, “Commence”, “Awaiting”, “Re-Picked”, “Completed”)
Dim headerCol As Integer
Dim statusCol As Integer
Dim timestampCol As Integer
‘ Find the header columns
For i = LBound(headers) To UBound(headers)
headerCol = Application.Match(headers(i), ws.Rows(6), 0)
If headers(i) = “Status” Then statusCol = headerCol
If Target.Column = statusCol Then
‘ Get corresponding timestamp column
Select Case Target.Value
Case “Commence”
timestampCol = Application.Match(“Commence”, ws.Rows(6), 0)
Case “Awaiting”
timestampCol = Application.Match(“Awaiting”, ws.Rows(6), 0)
Case “Re-Picked”
timestampCol = Application.Match(“Re-Picked”, ws.Rows(6), 0)
Case “Completed”
timestampCol = Application.Match(“Completed”, ws.Rows(6), 0)
End Select
‘ Insert timestamp
If timestampCol > 0 Then
ws.Cells(Target.Row, timestampCol).Value = Now
End If
End If
Next i
End If
End If
End Sub
Need to find errors in this excel VBA Code Private Sub Worksheet_Change(ByVal Target As Range)Dim ws As WorksheetSet ws = MeDim selectedQueue As StringDim col As IntegerDim cell As RangeDim queueFound As BooleanDim i As Long’ Handle queue selection in cell A1If Not Intersect(Target, Range(“A1”)) Is Nothing ThenselectedQueue = ws.Range(“A1”).ValuequeueFound = False’ Unhide/hide columns based on queue selectionOn Error GoTo ErrorHandlerApplication.ScreenUpdating = False’ Loop through columns G to CZFor col = 7 To 104If ws.Cells(5, col).MergeCells ThenSet cell = ws.Cells(5, col).MergeAreaIf Not IsError(cell.Cells(1, 1).Value) And Not IsEmpty(cell.Cells(1, 1).Value) ThenIf Trim(CStr(cell.Cells(1, 1).Value)) = Trim(selectedQueue) Or Trim(selectedQueue) = “All Queues” Then’ Unhide the columns if they are hiddenIf cell.Columns.Hidden Thencell.Columns.Hidden = FalseEnd If’ Select the first cell of the unhidden merged areacell.Cells(1, 1).SelectqueueFound = TrueElse’ Hide the columns if they are not the selected queuecell.Columns.Hidden = TrueEnd IfEnd IfElse’ If the column is blank, hide itws.Columns(col).Hidden = TrueEnd IfNext col’ If “All Queues” is selected, show all queues dataIf selectedQueue = “All Queues” ThenFor col = 7 To 104ws.Columns(col).Hidden = FalseNext colqueueFound = TrueEnd If’ If the queue is not found, show a messageIf Not queueFound ThenMsgBox “Queue not found in row 5.”End IfApplication.ScreenUpdating = TrueExit SubErrorHandler:MsgBox “An error occurred: ” & Err.DescriptionApplication.ScreenUpdating = TrueEnd If’ Handle status changes and timestampingIf Not Intersect(Target, Range(“G6:G1000”)) Is Nothing ThenIf Not IsEmpty(Target) Then’ Define headers and their corresponding columnsDim headers As Variantheaders = Array(“Status”, “Commence”, “Awaiting”, “Re-Picked”, “Completed”)Dim headerCol As IntegerDim statusCol As IntegerDim timestampCol As Integer’ Find the header columnsFor i = LBound(headers) To UBound(headers)headerCol = Application.Match(headers(i), ws.Rows(6), 0)If headers(i) = “Status” Then statusCol = headerColIf Target.Column = statusCol Then’ Get corresponding timestamp columnSelect Case Target.ValueCase “Commence”timestampCol = Application.Match(“Commence”, ws.Rows(6), 0)Case “Awaiting”timestampCol = Application.Match(“Awaiting”, ws.Rows(6), 0)Case “Re-Picked”timestampCol = Application.Match(“Re-Picked”, ws.Rows(6), 0)Case “Completed”timestampCol = Application.Match(“Completed”, ws.Rows(6), 0)End Select’ Insert timestampIf timestampCol > 0 Thenws.Cells(Target.Row, timestampCol).Value = NowEnd IfEnd IfNext iEnd IfEnd IfEnd Sub Read More
Assistance Needed: SQL Server 2019 Log Shipping for SharePoint SQL FCI Database
I hope this message finds you well.
I need some information regarding SQL Server 2019. Our client requires a Disaster Recovery (DR) solution for their SharePoint SQL Failover Cluster Instance (FCI) database. As they do not have an enterprise license, we need to use the standard edition, which necessitates an FCI for High Availability (HA).
We are considering configuring log shipping for DR purposes. However, I have come across some information suggesting that log shipping may not be supported with an FCI. Could anyone confirm whether this is the case? If it is supported, are there any specific considerations or best practices we should be aware of?
I hope this message finds you well.I need some information regarding SQL Server 2019. Our client requires a Disaster Recovery (DR) solution for their SharePoint SQL Failover Cluster Instance (FCI) database. As they do not have an enterprise license, we need to use the standard edition, which necessitates an FCI for High Availability (HA).We are considering configuring log shipping for DR purposes. However, I have come across some information suggesting that log shipping may not be supported with an FCI. Could anyone confirm whether this is the case? If it is supported, are there any specific considerations or best practices we should be aware of? Read More
Where does Windows 11 store File History
I had File History running in Windows for a while, probably staring under WIndows 10. I could go the the drive where History was stored and browse through the versions of files there with File Explorer. I recently discovered, to my horror, that File History was NOT running on my machine. I started it up, and it is now running. However when I go to the drive where the files are to be copied, I can”t find them. I find old ones from last year, with the date & time added to each version, but nothing new. When I use the built in restore feature I can see a few recent versions of a file that is updated every weekday. But I can NOT find anything using File Explorer. Google has let me down, Microsoft Help has let me down. I have found nothing about WHERE the files are stored.
(I’m no Windows expert but I’ve been using it since the Windows NT days, when I was a Microsoft SQL Server MVP. I’m long retired, but not a complete newby.)
I had File History running in Windows for a while, probably staring under WIndows 10. I could go the the drive where History was stored and browse through the versions of files there with File Explorer. I recently discovered, to my horror, that File History was NOT running on my machine. I started it up, and it is now running. However when I go to the drive where the files are to be copied, I can”t find them. I find old ones from last year, with the date & time added to each version, but nothing new. When I use the built in restore feature I can see a few recent versions of a file that is updated every weekday. But I can NOT find anything using File Explorer. Google has let me down, Microsoft Help has let me down. I have found nothing about WHERE the files are stored.(I’m no Windows expert but I’ve been using it since the Windows NT days, when I was a Microsoft SQL Server MVP. I’m long retired, but not a complete newby.) Read More
Attachment Column from List not showing up in Forms
I am trying to build a List to feed my forms, and I’m hoping to allow those who fill out the form to be able to add an attachment. Is this possible? I was able to add an attachments column in my list, but it’s not showing up as a field option when I create the form.
I am trying to build a List to feed my forms, and I’m hoping to allow those who fill out the form to be able to add an attachment. Is this possible? I was able to add an attachments column in my list, but it’s not showing up as a field option when I create the form. Read More
creating loop that stops at correct formula for the given input.
I am writting a program the finds the polynomial using the least-square method and Gausian elimination and from there displays the correct polynomial equation. The code for the least-square and the Gaussian elimination works fine, where I am having trouble is at the end getting the display of the polynomial equation depending on what value of "n" you show correcty and nothing lower then or higher then the corresponding the chosen value of "n". What loop would for best to do this? My fist thought is and if else loop but how would I set this up to run correctly?
clear, close, clc
%input
x=[0 1 2 3 4 5];
y=[2.1 7.7 13.6 27.2 40.9 61.1];
n=8; %order of the polynomial you want to find
%%%LEAST SQUARE METHOD-FINDS POLYNOMIAL FOR GIVEN DATA SET%%%%%
%INPUT SECTION
x=x; %x-cordinates from data-input; independent vairiables
y=y; %y-cordinates from data-output; dependent vairiables
%CALCULATIONS SECTION
k=length(x); %NUMBER OF AVAILABLE DATA POINTS
m=n+1; %SIZE OF THE COEFFICENT MATRIX
A=zeros(m,m); %COEFFICENT MATRIX
for j=1:m
for i=1:m
A(j,i)=sum(x.^(i+j-2));
end
end
B=zeros(m,1); %FORCING FUNCTION VECTOR
for i=1:m;
B(i)=sum(y.*x.^(i-1));
end
a1=AB %COEFFICIENTS FOR THE POLYNOMINAL–> y=a0+a1*x+a2*x^2….an*x^n CAN BE REPLACED BY GAUSSIAN ELIMINATION
%%%%%=========GAUSSIAN ELIMINATION TO FIND "a"========%%%%%%
%%%INPUT SECTION
%CALCULATION SECTION
AB=[A B]; %Augumentent matrix
R=size(AB,1); %# OF ROWS IN AB
C=size(AB,2); %# OF COLUMNS IN AB
%%%%FOWARD ELIMINATION SECTION
for J=1:R-1
[M,I]=max(abs(AB(J:R,J))); %M=MAXIMUM VALUE, I=LOCATION OF THE MAXIMUM VALUE IN THE 1ST ROW
temp=AB(J,:);
AB(J,:)=AB(I+(J-1),:);
AB(I+(J-1),:)=temp;
for i=(J+1):R;
if AB(i,J)~=0;
AB(i,:)=AB(i,:)-(AB(i,J)/AB(J,J))*AB(J,:);
end
end
end
%%%%BACKWARDS SUBSTITUTION
a(R)=AB(R,C)/AB(R,R);
for i=R-1:-1:1
a(i)=(AB(i,C)-AB(i,i+1:R)*a(i+1:R)’)/AB(i,i);
end
disp(a)
%========END OF GAUSSIAN ELIMINATION=======%%%%%%%%
%STANDARD DEVIATION
Y_bar=mean(y); %ADVERAGE OF y
St=sum((y-Y_bar).^2);
SD=sqrt(St/(k-1)); %STANDARD DEVIATION
%STANDARD ERROR
for i=1:m;
T(:,i)=a(i)*x.^(i-1); %T=INDIVIDUAL POLYNOMIAL TERMS
end
for i=1:k
y_hat(i)=sum(T(i,:));
end
Sr=sum((y-y_hat).^2);
Se=sqrt(Sr/(k-(n+1))); %STANDARD ERROR-Se
%COEFFICIENT OF DETERMINATION
Cd=(St-Sr)/St %COEFFICIENT OF DETERMINATION (r^2)
fprintf(‘For n=%d. Coefficient of Determination=%0.5fn’,n,Cd)
%EQUATION FOR THE POLYNOMIAL
syms x y
for n=1
a0=a(:,1);a1=a(:,2);a2=a(:,3);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2
end
for n=2
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3
end
for n=3
a0=a(:,1);a1=a(:,2);a2=a(:,2);a3=a(:,4);a4=a(:,5);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4
end
for n=4
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5
end
for n=5
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7)
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6
end
for n=6
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7
end
for n=7
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8
end
for n=8
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);a9=a(:,10);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8+a9*x.^9
end
for n=9
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);a9=a(:,10);a10=a(:,11);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8+a9*x.^9+a10*x.^10
endI am writting a program the finds the polynomial using the least-square method and Gausian elimination and from there displays the correct polynomial equation. The code for the least-square and the Gaussian elimination works fine, where I am having trouble is at the end getting the display of the polynomial equation depending on what value of "n" you show correcty and nothing lower then or higher then the corresponding the chosen value of "n". What loop would for best to do this? My fist thought is and if else loop but how would I set this up to run correctly?
clear, close, clc
%input
x=[0 1 2 3 4 5];
y=[2.1 7.7 13.6 27.2 40.9 61.1];
n=8; %order of the polynomial you want to find
%%%LEAST SQUARE METHOD-FINDS POLYNOMIAL FOR GIVEN DATA SET%%%%%
%INPUT SECTION
x=x; %x-cordinates from data-input; independent vairiables
y=y; %y-cordinates from data-output; dependent vairiables
%CALCULATIONS SECTION
k=length(x); %NUMBER OF AVAILABLE DATA POINTS
m=n+1; %SIZE OF THE COEFFICENT MATRIX
A=zeros(m,m); %COEFFICENT MATRIX
for j=1:m
for i=1:m
A(j,i)=sum(x.^(i+j-2));
end
end
B=zeros(m,1); %FORCING FUNCTION VECTOR
for i=1:m;
B(i)=sum(y.*x.^(i-1));
end
a1=AB %COEFFICIENTS FOR THE POLYNOMINAL–> y=a0+a1*x+a2*x^2….an*x^n CAN BE REPLACED BY GAUSSIAN ELIMINATION
%%%%%=========GAUSSIAN ELIMINATION TO FIND "a"========%%%%%%
%%%INPUT SECTION
%CALCULATION SECTION
AB=[A B]; %Augumentent matrix
R=size(AB,1); %# OF ROWS IN AB
C=size(AB,2); %# OF COLUMNS IN AB
%%%%FOWARD ELIMINATION SECTION
for J=1:R-1
[M,I]=max(abs(AB(J:R,J))); %M=MAXIMUM VALUE, I=LOCATION OF THE MAXIMUM VALUE IN THE 1ST ROW
temp=AB(J,:);
AB(J,:)=AB(I+(J-1),:);
AB(I+(J-1),:)=temp;
for i=(J+1):R;
if AB(i,J)~=0;
AB(i,:)=AB(i,:)-(AB(i,J)/AB(J,J))*AB(J,:);
end
end
end
%%%%BACKWARDS SUBSTITUTION
a(R)=AB(R,C)/AB(R,R);
for i=R-1:-1:1
a(i)=(AB(i,C)-AB(i,i+1:R)*a(i+1:R)’)/AB(i,i);
end
disp(a)
%========END OF GAUSSIAN ELIMINATION=======%%%%%%%%
%STANDARD DEVIATION
Y_bar=mean(y); %ADVERAGE OF y
St=sum((y-Y_bar).^2);
SD=sqrt(St/(k-1)); %STANDARD DEVIATION
%STANDARD ERROR
for i=1:m;
T(:,i)=a(i)*x.^(i-1); %T=INDIVIDUAL POLYNOMIAL TERMS
end
for i=1:k
y_hat(i)=sum(T(i,:));
end
Sr=sum((y-y_hat).^2);
Se=sqrt(Sr/(k-(n+1))); %STANDARD ERROR-Se
%COEFFICIENT OF DETERMINATION
Cd=(St-Sr)/St %COEFFICIENT OF DETERMINATION (r^2)
fprintf(‘For n=%d. Coefficient of Determination=%0.5fn’,n,Cd)
%EQUATION FOR THE POLYNOMIAL
syms x y
for n=1
a0=a(:,1);a1=a(:,2);a2=a(:,3);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2
end
for n=2
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3
end
for n=3
a0=a(:,1);a1=a(:,2);a2=a(:,2);a3=a(:,4);a4=a(:,5);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4
end
for n=4
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5
end
for n=5
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7)
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6
end
for n=6
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7
end
for n=7
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8
end
for n=8
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);a9=a(:,10);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8+a9*x.^9
end
for n=9
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);a9=a(:,10);a10=a(:,11);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8+a9*x.^9+a10*x.^10
end I am writting a program the finds the polynomial using the least-square method and Gausian elimination and from there displays the correct polynomial equation. The code for the least-square and the Gaussian elimination works fine, where I am having trouble is at the end getting the display of the polynomial equation depending on what value of "n" you show correcty and nothing lower then or higher then the corresponding the chosen value of "n". What loop would for best to do this? My fist thought is and if else loop but how would I set this up to run correctly?
clear, close, clc
%input
x=[0 1 2 3 4 5];
y=[2.1 7.7 13.6 27.2 40.9 61.1];
n=8; %order of the polynomial you want to find
%%%LEAST SQUARE METHOD-FINDS POLYNOMIAL FOR GIVEN DATA SET%%%%%
%INPUT SECTION
x=x; %x-cordinates from data-input; independent vairiables
y=y; %y-cordinates from data-output; dependent vairiables
%CALCULATIONS SECTION
k=length(x); %NUMBER OF AVAILABLE DATA POINTS
m=n+1; %SIZE OF THE COEFFICENT MATRIX
A=zeros(m,m); %COEFFICENT MATRIX
for j=1:m
for i=1:m
A(j,i)=sum(x.^(i+j-2));
end
end
B=zeros(m,1); %FORCING FUNCTION VECTOR
for i=1:m;
B(i)=sum(y.*x.^(i-1));
end
a1=AB %COEFFICIENTS FOR THE POLYNOMINAL–> y=a0+a1*x+a2*x^2….an*x^n CAN BE REPLACED BY GAUSSIAN ELIMINATION
%%%%%=========GAUSSIAN ELIMINATION TO FIND "a"========%%%%%%
%%%INPUT SECTION
%CALCULATION SECTION
AB=[A B]; %Augumentent matrix
R=size(AB,1); %# OF ROWS IN AB
C=size(AB,2); %# OF COLUMNS IN AB
%%%%FOWARD ELIMINATION SECTION
for J=1:R-1
[M,I]=max(abs(AB(J:R,J))); %M=MAXIMUM VALUE, I=LOCATION OF THE MAXIMUM VALUE IN THE 1ST ROW
temp=AB(J,:);
AB(J,:)=AB(I+(J-1),:);
AB(I+(J-1),:)=temp;
for i=(J+1):R;
if AB(i,J)~=0;
AB(i,:)=AB(i,:)-(AB(i,J)/AB(J,J))*AB(J,:);
end
end
end
%%%%BACKWARDS SUBSTITUTION
a(R)=AB(R,C)/AB(R,R);
for i=R-1:-1:1
a(i)=(AB(i,C)-AB(i,i+1:R)*a(i+1:R)’)/AB(i,i);
end
disp(a)
%========END OF GAUSSIAN ELIMINATION=======%%%%%%%%
%STANDARD DEVIATION
Y_bar=mean(y); %ADVERAGE OF y
St=sum((y-Y_bar).^2);
SD=sqrt(St/(k-1)); %STANDARD DEVIATION
%STANDARD ERROR
for i=1:m;
T(:,i)=a(i)*x.^(i-1); %T=INDIVIDUAL POLYNOMIAL TERMS
end
for i=1:k
y_hat(i)=sum(T(i,:));
end
Sr=sum((y-y_hat).^2);
Se=sqrt(Sr/(k-(n+1))); %STANDARD ERROR-Se
%COEFFICIENT OF DETERMINATION
Cd=(St-Sr)/St %COEFFICIENT OF DETERMINATION (r^2)
fprintf(‘For n=%d. Coefficient of Determination=%0.5fn’,n,Cd)
%EQUATION FOR THE POLYNOMIAL
syms x y
for n=1
a0=a(:,1);a1=a(:,2);a2=a(:,3);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2
end
for n=2
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3
end
for n=3
a0=a(:,1);a1=a(:,2);a2=a(:,2);a3=a(:,4);a4=a(:,5);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4
end
for n=4
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5
end
for n=5
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7)
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6
end
for n=6
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7
end
for n=7
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8
end
for n=8
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);a9=a(:,10);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8+a9*x.^9
end
for n=9
a0=a(:,1);a1=a(:,2);a2=a(:,3);a3=a(:,4);a4=a(:,5);a5=a(:,6);a6=a(:,7);a7=a(:,8);a8=a(:,9);a9=a(:,10);a10=a(:,11);
sympref("FloatingPointOutput",true);
y=a0+a1*x+a2*x.^2+a3*x.^3+a4*x.^4+a5*x.^5+a6*x.^6+a7*x.^7+a8*x.^8+a9*x.^9+a10*x.^10
end loop to display equation for changing input, loop MATLAB Answers — New Questions
Nonlinear constraint not satisfied for paretosearch
Hi community,
I am using paretosearch for a 2-objective optimization problem to maximize them. Based on hardcoded values, I know objective #2 can be at least . So I want to make it a constraint that in the constraint function, I specify objective #2 has to be greater than , which I know it can be achieved. But after I run the algorithm and get the pareto front, there are points on the pareto front whose objective #2 is lower than the constrainted value, why this is the case?
As shown in the attached picture, I already set a constraint that objective #2 has to be greater than . But the pareto front still has the points that are lower than . Why this is the case? Can I not set the constraint this way?
I am setting this constraint in the mindset that I want the solver to explore more in this direction.
Thank you!
XiaoweiHi community,
I am using paretosearch for a 2-objective optimization problem to maximize them. Based on hardcoded values, I know objective #2 can be at least . So I want to make it a constraint that in the constraint function, I specify objective #2 has to be greater than , which I know it can be achieved. But after I run the algorithm and get the pareto front, there are points on the pareto front whose objective #2 is lower than the constrainted value, why this is the case?
As shown in the attached picture, I already set a constraint that objective #2 has to be greater than . But the pareto front still has the points that are lower than . Why this is the case? Can I not set the constraint this way?
I am setting this constraint in the mindset that I want the solver to explore more in this direction.
Thank you!
Xiaowei Hi community,
I am using paretosearch for a 2-objective optimization problem to maximize them. Based on hardcoded values, I know objective #2 can be at least . So I want to make it a constraint that in the constraint function, I specify objective #2 has to be greater than , which I know it can be achieved. But after I run the algorithm and get the pareto front, there are points on the pareto front whose objective #2 is lower than the constrainted value, why this is the case?
As shown in the attached picture, I already set a constraint that objective #2 has to be greater than . But the pareto front still has the points that are lower than . Why this is the case? Can I not set the constraint this way?
I am setting this constraint in the mindset that I want the solver to explore more in this direction.
Thank you!
Xiaowei optimization, nonlinear MATLAB Answers — New Questions
MSSA method multichannel spectrum analysis
How we can use multichannel spectrum analysis with time series contain temporal and spatial data :time, latitude , longitude ?
the time is daily-based data , lat-log is 2.5x 5 degrees ???How we can use multichannel spectrum analysis with time series contain temporal and spatial data :time, latitude , longitude ?
the time is daily-based data , lat-log is 2.5x 5 degrees ??? How we can use multichannel spectrum analysis with time series contain temporal and spatial data :time, latitude , longitude ?
the time is daily-based data , lat-log is 2.5x 5 degrees ??? multichannel singular spectrum MATLAB Answers — New Questions