Month: June 2024
Incomplete plot of an integral function
Hi,
I’m having a problem plotting an integal function. Basically, the graph comes out incomplete. Am I doing something wrong or is there a more efficient way to plot the intgral of function (f)? I’ve attached the graph I’m getting and the code I’m using. Your help is greatly appreciated.
syms t X Y;
d=0.5;
f= 121864 *(exp(-2*(((X-(-d*cos(628*t)+7*t)).^2) + ((Y-(d*sin(628*t))).^2))/0.0002)) ;
Z =int(f,t,0,0.4);
fsurf(Z,[-0.1 1.22 -0.61 0.61],’EdgeColor’,’none’);
view([0,90]);
colormap jet;
colorbar;
ax = gca;
ax.FontSize = 24;
xlabel(‘X(mm)’)
ylabel(‘Y(mm)’)
zlabel(‘E=J/mm^2’)Hi,
I’m having a problem plotting an integal function. Basically, the graph comes out incomplete. Am I doing something wrong or is there a more efficient way to plot the intgral of function (f)? I’ve attached the graph I’m getting and the code I’m using. Your help is greatly appreciated.
syms t X Y;
d=0.5;
f= 121864 *(exp(-2*(((X-(-d*cos(628*t)+7*t)).^2) + ((Y-(d*sin(628*t))).^2))/0.0002)) ;
Z =int(f,t,0,0.4);
fsurf(Z,[-0.1 1.22 -0.61 0.61],’EdgeColor’,’none’);
view([0,90]);
colormap jet;
colorbar;
ax = gca;
ax.FontSize = 24;
xlabel(‘X(mm)’)
ylabel(‘Y(mm)’)
zlabel(‘E=J/mm^2’) Hi,
I’m having a problem plotting an integal function. Basically, the graph comes out incomplete. Am I doing something wrong or is there a more efficient way to plot the intgral of function (f)? I’ve attached the graph I’m getting and the code I’m using. Your help is greatly appreciated.
syms t X Y;
d=0.5;
f= 121864 *(exp(-2*(((X-(-d*cos(628*t)+7*t)).^2) + ((Y-(d*sin(628*t))).^2))/0.0002)) ;
Z =int(f,t,0,0.4);
fsurf(Z,[-0.1 1.22 -0.61 0.61],’EdgeColor’,’none’);
view([0,90]);
colormap jet;
colorbar;
ax = gca;
ax.FontSize = 24;
xlabel(‘X(mm)’)
ylabel(‘Y(mm)’)
zlabel(‘E=J/mm^2’) integral, integration, plotting, 3d plots MATLAB Answers — New Questions
Coloured Favourites Folders
Would be nice to have coloured folders (at least the standard yellow, per File Explorer, but customisable would be even better.
Anyone know if this is coming at some stage? It’s pretty boring as it stands.
Would be nice to have coloured folders (at least the standard yellow, per File Explorer, but customisable would be even better. Anyone know if this is coming at some stage? It’s pretty boring as it stands. Read More
Any way to display the number of days that a task has been in a bucket (kanban board)?
Hello,
Is there a way on the kanban board task cards to display how many days tasks have been in its current bucket?
Thank you
DK
Hello, Is there a way on the kanban board task cards to display how many days tasks have been in its current bucket?Thank youDK Read More
Azure Advisor Integration with Troubleshooting Guides for enhanced performance
Azure Advisor provides a personalized approach to receiving recommendations for your server by analyzing its configuration and telemetry data. This service aims to enhance various aspects of your server, including reliability, cost efficiency, security, operational excellence, and performance. By leveraging Azure Advisor, you gain access to tailored, proactive, and actionable recommendations designed to help your server operate at its optimal level.
You can now receive new recommendations that include checks for long-running queries, orphaned prepared transactions, databases approaching the 1 billion transaction usage limit (to prevent potential transaction wraparound scenarios), and servers exceeding the 80% bloat ratio. These new recommendations are seamlessly integrated with the troubleshooting guides available on the Azure Portal: Troubleshooting guides – Azure Database for PostgreSQL – Flexible Server | Microsoft Learn.
You can use these troubleshooting guides to help implement the Azure Advisor Performance recommendations for your Azure Database for Postgres Flexible Server. When you receive a recommendation, you will be directed to the appropriate troubleshooting guides. Be sure to follow the prerequisites section to ensure that all necessary data is provided before proceeding with the troubleshooting steps.
Let us walk through an example of a long-running transaction recommendation and see how the integration of troubleshooting guides can assist you in resolving the issue:
1. For the recommendation on Long Running Transactions, Go to Help -> Troubleshooting guides -> High CPU Usage -> Long Running Transactions as shown in the visual. This visual highlights the troubleshooting guides available on the portal, illustrating the various scenarios they can help you identify and resolve any server issues.
2. This will provide you with PIDs for the long running transactions on the server.
3. There is a dropdown to pick a specific PID which shows you the details of the PID as below. You can go through each PID and understand what is causing the issue.
4. We also provide you with recommendations on what steps need to be taken to resolve the issue.
5. You may have to follow additional steps for all the PIDs identified as long running and resolve them based on the recommendation provided.
In conclusion, leveraging Azure Advisor and the integrated troubleshooting guides can significantly enhance the performance, reliability, and efficiency of your Azure Database for Postgres Flexible Server. By proactively addressing recommendations such as long-running queries, orphaned prepared transactions, transaction limits, and bloat ratios, you can ensure your server operates at its best.
We encourage you to explore the Azure Portal and utilize these tools to stay ahead of potential issues. Start implementing the Azure Advisor performance recommendations today and make use of the detailed troubleshooting guides to maintain a robust and high-performing database environment.
Acknowledgement: This post was co-authored by Guy Bowerman and Gayathri Paderla.
Microsoft Tech Community – Latest Blogs –Read More
Can I create a new serial port on the Arduino Uno to run a Simulink model in real time that also uses a serial port?
I’m attempting to run the example MODBUS RS485 Communication Between Client and Server Using Arduino Board with two Arduino Uno units. These units have only one dedicated serial port on pins 0 and 1. When I go to Monitor and Tune the Client Model, I get an error message for all 6 MODBUS blocks in the model that reads:
Error evaluating ‘InitFcn’ callback of codertarget.arduinobase.internal.arduino_ModbusRS485MasterRead block (mask) ‘arduino_modbus_client/Modbus RS485 Client Read’.
Callback string is ‘codertarget.arduinobase.conflictcheck.validateandregisterBlocks(gcbh);’
Caused by:
The SerialPin_1 ‘1’ being used by ‘arduino_modbus_client/Modbus RS485 Client Read’ is currently in use by ‘Monitor and tune over XCP on Serial’. To resolve the conflict, change the value of SerialPin_1 in ‘arduino_modbus_client/Modbus RS485 Client Read’ to an alternate valid value.
It appears that the only port the Arduino Uno has is in use by the USB interface with my desktop computer. I know that ArduinoIDE has the SoftwareSerial library addon that is supposed to allow you to assign pins to create a separate serial port, but I don’t know if a similar operation is possible in Simulink. Or perhaps I can create the new port in ArduinoIDE for use in the Simulink model. Thank you.I’m attempting to run the example MODBUS RS485 Communication Between Client and Server Using Arduino Board with two Arduino Uno units. These units have only one dedicated serial port on pins 0 and 1. When I go to Monitor and Tune the Client Model, I get an error message for all 6 MODBUS blocks in the model that reads:
Error evaluating ‘InitFcn’ callback of codertarget.arduinobase.internal.arduino_ModbusRS485MasterRead block (mask) ‘arduino_modbus_client/Modbus RS485 Client Read’.
Callback string is ‘codertarget.arduinobase.conflictcheck.validateandregisterBlocks(gcbh);’
Caused by:
The SerialPin_1 ‘1’ being used by ‘arduino_modbus_client/Modbus RS485 Client Read’ is currently in use by ‘Monitor and tune over XCP on Serial’. To resolve the conflict, change the value of SerialPin_1 in ‘arduino_modbus_client/Modbus RS485 Client Read’ to an alternate valid value.
It appears that the only port the Arduino Uno has is in use by the USB interface with my desktop computer. I know that ArduinoIDE has the SoftwareSerial library addon that is supposed to allow you to assign pins to create a separate serial port, but I don’t know if a similar operation is possible in Simulink. Or perhaps I can create the new port in ArduinoIDE for use in the Simulink model. Thank you. I’m attempting to run the example MODBUS RS485 Communication Between Client and Server Using Arduino Board with two Arduino Uno units. These units have only one dedicated serial port on pins 0 and 1. When I go to Monitor and Tune the Client Model, I get an error message for all 6 MODBUS blocks in the model that reads:
Error evaluating ‘InitFcn’ callback of codertarget.arduinobase.internal.arduino_ModbusRS485MasterRead block (mask) ‘arduino_modbus_client/Modbus RS485 Client Read’.
Callback string is ‘codertarget.arduinobase.conflictcheck.validateandregisterBlocks(gcbh);’
Caused by:
The SerialPin_1 ‘1’ being used by ‘arduino_modbus_client/Modbus RS485 Client Read’ is currently in use by ‘Monitor and tune over XCP on Serial’. To resolve the conflict, change the value of SerialPin_1 in ‘arduino_modbus_client/Modbus RS485 Client Read’ to an alternate valid value.
It appears that the only port the Arduino Uno has is in use by the USB interface with my desktop computer. I know that ArduinoIDE has the SoftwareSerial library addon that is supposed to allow you to assign pins to create a separate serial port, but I don’t know if a similar operation is possible in Simulink. Or perhaps I can create the new port in ArduinoIDE for use in the Simulink model. Thank you. arduino, serial, communication MATLAB Answers — New Questions
Automated controls project DC motor controlcre
Automated controls project DC motor control
1..Mathimathical Model of the system
2. Simulink model of the DC Motor(simulink file)
3. Root locus diagram using matlab
4. Intrducing of PID controlel
5. System response before and after adding the PID controller
6. ConclusionAutomated controls project DC motor control
1..Mathimathical Model of the system
2. Simulink model of the DC Motor(simulink file)
3. Root locus diagram using matlab
4. Intrducing of PID controlel
5. System response before and after adding the PID controller
6. Conclusion Automated controls project DC motor control
1..Mathimathical Model of the system
2. Simulink model of the DC Motor(simulink file)
3. Root locus diagram using matlab
4. Intrducing of PID controlel
5. System response before and after adding the PID controller
6. Conclusion create code MATLAB Answers — New Questions
Serial Receive in Desktop Real-Time Kernel Mode
I am trying to get an input from a serial input in Simulink Desktop Real-Time.
To do so I have a "Serial Configuration" block and a "Serial Receive" block which is connected to a "To Workspace" block. (see screenshot below)
I am able to run the model in "Conneceted IO Mode". However, if I change the mode to "Kernel Mode", the model does not work anymore. Simulink states:
Serial Failed Code genreation inofrmation file does not exist.
0 of 1 models built (0 models already up to date)
Build duration: 0h 0m 19.781s
Error(s) encountered while building "Serial_Read"
Is it possible to use serial inputs in "Kernel Mode"? If yes, how can I avoid getting this error?I am trying to get an input from a serial input in Simulink Desktop Real-Time.
To do so I have a "Serial Configuration" block and a "Serial Receive" block which is connected to a "To Workspace" block. (see screenshot below)
I am able to run the model in "Conneceted IO Mode". However, if I change the mode to "Kernel Mode", the model does not work anymore. Simulink states:
Serial Failed Code genreation inofrmation file does not exist.
0 of 1 models built (0 models already up to date)
Build duration: 0h 0m 19.781s
Error(s) encountered while building "Serial_Read"
Is it possible to use serial inputs in "Kernel Mode"? If yes, how can I avoid getting this error? I am trying to get an input from a serial input in Simulink Desktop Real-Time.
To do so I have a "Serial Configuration" block and a "Serial Receive" block which is connected to a "To Workspace" block. (see screenshot below)
I am able to run the model in "Conneceted IO Mode". However, if I change the mode to "Kernel Mode", the model does not work anymore. Simulink states:
Serial Failed Code genreation inofrmation file does not exist.
0 of 1 models built (0 models already up to date)
Build duration: 0h 0m 19.781s
Error(s) encountered while building "Serial_Read"
Is it possible to use serial inputs in "Kernel Mode"? If yes, how can I avoid getting this error? simulink, real-time, kernel mode, serial, serial receive MATLAB Answers — New Questions
writestruct() fails to write empty child element to XML file
I need to write a empty, nested element within an XML file. An XML example of what I’d like to achieve is:
<?xml version="1.0" encoding="UTF-8"?>
<Problem>
<elementA>14</elementA>
<elementB>
<child/>
</elementB>
</Problem>
The nested element in this case is called "child". I expected the following MATLAB code to produce this result:
s.elementA = 14;
s.elementB.child = [];
writestruct(s,’test.xml’,’StructNodeName’,’Problem’)
However, this generates the following XML, whereupon the "child" element is entirely missing:
<?xml version="1.0" encoding="UTF-8"?>
<Problem>
<elementA>14</elementA>
<elementB/>
</Problem>
How can I produce a result with an empty, nested element?I need to write a empty, nested element within an XML file. An XML example of what I’d like to achieve is:
<?xml version="1.0" encoding="UTF-8"?>
<Problem>
<elementA>14</elementA>
<elementB>
<child/>
</elementB>
</Problem>
The nested element in this case is called "child". I expected the following MATLAB code to produce this result:
s.elementA = 14;
s.elementB.child = [];
writestruct(s,’test.xml’,’StructNodeName’,’Problem’)
However, this generates the following XML, whereupon the "child" element is entirely missing:
<?xml version="1.0" encoding="UTF-8"?>
<Problem>
<elementA>14</elementA>
<elementB/>
</Problem>
How can I produce a result with an empty, nested element? I need to write a empty, nested element within an XML file. An XML example of what I’d like to achieve is:
<?xml version="1.0" encoding="UTF-8"?>
<Problem>
<elementA>14</elementA>
<elementB>
<child/>
</elementB>
</Problem>
The nested element in this case is called "child". I expected the following MATLAB code to produce this result:
s.elementA = 14;
s.elementB.child = [];
writestruct(s,’test.xml’,’StructNodeName’,’Problem’)
However, this generates the following XML, whereupon the "child" element is entirely missing:
<?xml version="1.0" encoding="UTF-8"?>
<Problem>
<elementA>14</elementA>
<elementB/>
</Problem>
How can I produce a result with an empty, nested element? writestruct, xml, structures MATLAB Answers — New Questions
How to solve non_linear equation
Post Content Post Content @staff MATLAB Answers — New Questions
Now available for streaming: Executive Summit by Ultimate Partner
The recent Executive Summit by Ultimate Partner event grew out of the massive success of past digital and live events and a desire to help achieve more as Microsoft Partners navigate the tectonic shifts, Cloud GTM, and this Decade of the Ecosystem. You won’t see any event like this; the livestream is worth your time to learn and grow your business!
Sponsors for this event included Tackle.io, Microsoft, AvePoint, PartnerTap, Enavate, the WIT Network, swXtch.io, Impartner Software, ntegral as Advisor, Transcends Marketing, and Elastic and EY as Partners.
Thank you @VinceMenzione for all your work on this event!
The recent Executive Summit by Ultimate Partner event grew out of the massive success of past digital and live events and a desire to help achieve more as Microsoft Partners navigate the tectonic shifts, Cloud GTM, and this Decade of the Ecosystem. You won’t see any event like this; the livestream is worth your time to learn and grow your business!
Sponsors for this event included Tackle.io, Microsoft, AvePoint, PartnerTap, Enavate, the WIT Network, swXtch.io, Impartner Software, ntegral as Advisor, Transcends Marketing, and Elastic and EY as Partners.
Thank you @VinceMenzione for all your work on this event! Read More
How can I color the specific region of the image?
Hi!
I want to change the color of specific region in an image. The background color should be different from the eyes color of the image shown below. Thanks
img = imread(‘C:UsersJunaid KhanDesktopjun.png’);
bn=im2bw(img);
imshow(bn)
bn=bwareaopen(bn,100);
imshow(bn)
[L,n]=bwlabel(bn);
imshow(label2rgb(L));
prop=regionprops(L);
The above is the input image and while I run this code the output is like this.
I want to change the eyes and mouth color and also the background color should not be same.
ThanksHi!
I want to change the color of specific region in an image. The background color should be different from the eyes color of the image shown below. Thanks
img = imread(‘C:UsersJunaid KhanDesktopjun.png’);
bn=im2bw(img);
imshow(bn)
bn=bwareaopen(bn,100);
imshow(bn)
[L,n]=bwlabel(bn);
imshow(label2rgb(L));
prop=regionprops(L);
The above is the input image and while I run this code the output is like this.
I want to change the eyes and mouth color and also the background color should not be same.
Thanks Hi!
I want to change the color of specific region in an image. The background color should be different from the eyes color of the image shown below. Thanks
img = imread(‘C:UsersJunaid KhanDesktopjun.png’);
bn=im2bw(img);
imshow(bn)
bn=bwareaopen(bn,100);
imshow(bn)
[L,n]=bwlabel(bn);
imshow(label2rgb(L));
prop=regionprops(L);
The above is the input image and while I run this code the output is like this.
I want to change the eyes and mouth color and also the background color should not be same.
Thanks image processing MATLAB Answers — New Questions
PID control action for AC reference of variable amplitude and frequency.
i have seen example of controlling output dc voltage of DC to DC buck converter using PID controller. I want to implement DC to AC converter. I tried using PID controller. Since i am comparing output AC signal(continuously varying) with reference sinusoidal signal, PID controller is not providing expected output. In case of DC to DC, both reference signal was constant. In my case, it is continuously varying sine wave. Can anyone suggest any way to get accurate DC to AC conversion? i changed kp and ki parameters to get needed response. it is working well. but, when i change frequency of input reference signal, output signal amplitude drops and again i have to change PID parameters.
P.S. when i change frequency of input reference signal, again i have to change PID gain parameters. Can PID controller work with continuously varying reference signal(in terms of amplitude and frequency both) ?i have seen example of controlling output dc voltage of DC to DC buck converter using PID controller. I want to implement DC to AC converter. I tried using PID controller. Since i am comparing output AC signal(continuously varying) with reference sinusoidal signal, PID controller is not providing expected output. In case of DC to DC, both reference signal was constant. In my case, it is continuously varying sine wave. Can anyone suggest any way to get accurate DC to AC conversion? i changed kp and ki parameters to get needed response. it is working well. but, when i change frequency of input reference signal, output signal amplitude drops and again i have to change PID parameters.
P.S. when i change frequency of input reference signal, again i have to change PID gain parameters. Can PID controller work with continuously varying reference signal(in terms of amplitude and frequency both) ? i have seen example of controlling output dc voltage of DC to DC buck converter using PID controller. I want to implement DC to AC converter. I tried using PID controller. Since i am comparing output AC signal(continuously varying) with reference sinusoidal signal, PID controller is not providing expected output. In case of DC to DC, both reference signal was constant. In my case, it is continuously varying sine wave. Can anyone suggest any way to get accurate DC to AC conversion? i changed kp and ki parameters to get needed response. it is working well. but, when i change frequency of input reference signal, output signal amplitude drops and again i have to change PID parameters.
P.S. when i change frequency of input reference signal, again i have to change PID gain parameters. Can PID controller work with continuously varying reference signal(in terms of amplitude and frequency both) ? simulink MATLAB Answers — New Questions
Pseudo-terminal will not be allocated because stdin is not a terminal.
When trying to ssh to linux device form matlab scirpts, i get these messages as in screenshot, any thoughts why this can happen and how can we get terminal?When trying to ssh to linux device form matlab scirpts, i get these messages as in screenshot, any thoughts why this can happen and how can we get terminal? When trying to ssh to linux device form matlab scirpts, i get these messages as in screenshot, any thoughts why this can happen and how can we get terminal? matlab MATLAB Answers — New Questions
VBA-Excel weird behaviour on .RANGE(“B3”).Value – Read On
Using the following statements- when the SAVE dialog box appears, the filename is not pre-populated.
B3 is the filename and defined as General in the Excel spreadsheet.
Dim csv_fileName ‘As String (tried Variant as well)
‘ Build the Export File
csv_fileName = create_csv.Range(“B3”).Value & “.csv”
However, if I add a string value in front, then it works
csv_fileName = “anything” & create_csv.Range(“B3”).Value & “.csv”
Sub ExportToCSVFile()
Dim cell As Range
Dim colIndex As Long
Dim colMax As Integer
Dim create_csv As Worksheet
Dim csv_fileName As String
Dim currentUser As String
Dim delimiter As String
Dim extractedCount As Integer
Dim line As String
Dim oneDrivePath As String
Dim myChoicePath As String
Dim productToHelium_ws As String
Dim rng As Range
Dim rowIndex As Long
Dim spDirectory As String
Dim src_ws As Worksheet
Dim stream As Object ‘ ADODB.Stream
On Error GoTo ErrorHandler
‘ Set the maximum number of columns to extract
colMax = 3
‘ Set the worksheet location for the input variables
Set create_csv = ThisWorkbook.Sheets(“Create_CSV”)
‘ Build the Export File
csv_fileName = create_csv.Range(“B3”).Value & “.csv”
‘ Get the output Directory
myChoicePath = create_csv.Range(“B7”).Value
‘ Set the name of the source worksheet that holds the data for export
Set src_ws = ThisWorkbook.Sheets(“sheet2”)
‘
‘ Define the file path for the CSV file
‘ The user must have created a shortcut link to the SharePoint location. This is explained in the create_csv worksheet.
‘
If myChoicePath = “My Choice” Then
filePath = Application.GetSaveAsFilename(InitialFileName:=csv_fileName, FileFilter:=”CSV Files (*.csv), *.csv”)
‘ Check if user cancelled the Save As dialog
If filePath = “False” Then
Exit Sub
Else ‘ assume we have a SharePoint location chosen. C18 is the SP location
.
.
.
Using the following statements- when the SAVE dialog box appears, the filename is not pre-populated. B3 is the filename and defined as General in the Excel spreadsheet. Dim csv_fileName ‘As String (tried Variant as well)’ Build the Export Filecsv_fileName = create_csv.Range(“B3”).Value & “.csv” However, if I add a string value in front, then it workscsv_fileName = “anything” & create_csv.Range(“B3”).Value & “.csv” Sub ExportToCSVFile() Dim cell As Range Dim colIndex As Long Dim colMax As Integer Dim create_csv As Worksheet Dim csv_fileName As String Dim currentUser As String Dim delimiter As String Dim extractedCount As Integer Dim line As String Dim oneDrivePath As String Dim myChoicePath As String Dim productToHelium_ws As String Dim rng As Range Dim rowIndex As Long Dim spDirectory As String Dim src_ws As Worksheet Dim stream As Object ‘ ADODB.Stream On Error GoTo ErrorHandler ‘ Set the maximum number of columns to extract colMax = 3 ‘ Set the worksheet location for the input variables Set create_csv = ThisWorkbook.Sheets(“Create_CSV”) ‘ Build the Export File csv_fileName = create_csv.Range(“B3”).Value & “.csv” ‘ Get the output Directory myChoicePath = create_csv.Range(“B7”).Value ‘ Set the name of the source worksheet that holds the data for export Set src_ws = ThisWorkbook.Sheets(“sheet2”) ‘ ‘ Define the file path for the CSV file ‘ The user must have created a shortcut link to the SharePoint location. This is explained in the create_csv worksheet. ‘ If myChoicePath = “My Choice” Then filePath = Application.GetSaveAsFilename(InitialFileName:=csv_fileName, FileFilter:=”CSV Files (*.csv), *.csv”) ‘ Check if user cancelled the Save As dialog If filePath = “False” Then Exit Sub Else ‘ assume we have a SharePoint location chosen. C18 is the SP location… Read More
Printer brought back online shows as “Stopped” in Azure Portal and “Attention Required” on clients
The fix listed here…:
https://learn.microsoft.com/en-us/universal-print/fundamentals/universal-print-troubleshooting-support-howto
….Does not work in my experience. Or takes entirely too long, it’s been 20+ minutes at time of posting this and they have not had their status updated. They receive print jobs and process them despite throwing errors while doing so due to the inaccurate status in Azure from the connector.
The fix listed here…:https://learn.microsoft.com/en-us/universal-print/fundamentals/universal-print-troubleshooting-support-howto….Does not work in my experience. Or takes entirely too long, it’s been 20+ minutes at time of posting this and they have not had their status updated. They receive print jobs and process them despite throwing errors while doing so due to the inaccurate status in Azure from the connector. Read More
Excel Geography fails to recognize state county… Denver County, Colorado …
Every time I go and try to get excel geo to update the state of Colorado counties although I have provided the county names, the system will not recognize Denver as a county and therefore, will not map correctly the data I have in another column. When I enter Denver County, Colorado it continually returns the following. Any idea?
Delta County, ColoradoColoradoDenverColorado
Every time I go and try to get excel geo to update the state of Colorado counties although I have provided the county names, the system will not recognize Denver as a county and therefore, will not map correctly the data I have in another column. When I enter Denver County, Colorado it continually returns the following. Any idea?Delta County, ColoradoColoradoDenverColorado Read More
Instructions on configuring a customized Search Page in SharePoint
Is there any instructions on creating and/or customizing SharePoint search and not use the PnP webparts? I thought I had seen something a few years ago, but now I can’t find it, everything, including YouTube points you to the PnP Search webparts. My company is worried about security of APIs.
Is there any instructions on creating and/or customizing SharePoint search and not use the PnP webparts? I thought I had seen something a few years ago, but now I can’t find it, everything, including YouTube points you to the PnP Search webparts. My company is worried about security of APIs. Read More
Bookings – Having specific availability in different services
Hi!
In my office we have 4 staff members. We have a set schedule that determines that 2 members work from home and 2 work from the office.
Example
Monday: Staff A and B works from home
Tuesday: Staff C and D works from home
Wednesday: Staff A and C works from home
Thursday: Staff B and D works from home
I want to set up two services: one for in-person appointments and one for virtual meetings appointments.
How can I set up the availability for my staff if they are available Monday through Thursday during business hours but some days only available for the in-person appointments and other days for the virtual meetings appointments.
Hi! In my office we have 4 staff members. We have a set schedule that determines that 2 members work from home and 2 work from the office. ExampleMonday: Staff A and B works from homeTuesday: Staff C and D works from homeWednesday: Staff A and C works from homeThursday: Staff B and D works from home I want to set up two services: one for in-person appointments and one for virtual meetings appointments. How can I set up the availability for my staff if they are available Monday through Thursday during business hours but some days only available for the in-person appointments and other days for the virtual meetings appointments. Read More
Excel adding filename to formula when creating duplicate file copy
Excel adding original path and filename to formula referencing another worksheet within the same file when creating duplicate file copy
I have regular issues when creating copies of a file, where the formulas will seemingly randomly decide to reference the original file, rather than the Sheet and Cell within the new file. I need to create an end of month duplicate of each of my project files.
I use a Project_Details tab/worksheet in excel to contain header information and general info for a project. eg, Customer name and address, and Estimated Project Value or other figures I will use in calculations in multiple places in different tabs/worksheets throughout the workbook/file.
As these files are passed up to a manager for end of month records, I create a duplicate of my file with the year and month reference. However, this will occasionally and seemingly randomly update the reference formulas from (for example):
‘Project_Details’!$C$12
to
‘[c:documentsProj_1234-Client_ABC-2024.05]Project_Details’!$C$12
Where [c:documentsProj_1234-Client_ABC-2024.05] is the file for last month and is in the CURRENT file “c:documentsProj_1234-Client_ABC-Current”. So the Current file now looks to the May 2024 file for info.
How do I stop this? Can I force Excel to not do this without having to Find and Replace file names in every copy of the file?
Is there an order that worksheets are copied and formulas updated when copying a formula that defaults to the original file reference if the referenced worksheet isn’t in the new file yet?
Excel adding original path and filename to formula referencing another worksheet within the same file when creating duplicate file copy I have regular issues when creating copies of a file, where the formulas will seemingly randomly decide to reference the original file, rather than the Sheet and Cell within the new file. I need to create an end of month duplicate of each of my project files.I use a Project_Details tab/worksheet in excel to contain header information and general info for a project. eg, Customer name and address, and Estimated Project Value or other figures I will use in calculations in multiple places in different tabs/worksheets throughout the workbook/file.As these files are passed up to a manager for end of month records, I create a duplicate of my file with the year and month reference. However, this will occasionally and seemingly randomly update the reference formulas from (for example):’Project_Details’!$C$12to'[c:documentsProj_1234-Client_ABC-2024.05]Project_Details’!$C$12Where [c:documentsProj_1234-Client_ABC-2024.05] is the file for last month and is in the CURRENT file “c:documentsProj_1234-Client_ABC-Current”. So the Current file now looks to the May 2024 file for info. How do I stop this? Can I force Excel to not do this without having to Find and Replace file names in every copy of the file? Is there an order that worksheets are copied and formulas updated when copying a formula that defaults to the original file reference if the referenced worksheet isn’t in the new file yet? Read More
person who doesnt enjoy the work, is doing a wrong job! And I can help figure their happiness.
Security and respect is something that we all need, for ourselves, our families, our fortune.
We are here to give people what they need. They are here, because they wanna trust us as the best. We are not going to prove them wrong, by not giving what we want.
We are going to prove them, that they have come to right place now.
Security and respect is something that we all need, for ourselves, our families, our fortune. We are here to give people what they need. They are here, because they wanna trust us as the best. We are not going to prove them wrong, by not giving what we want. We are going to prove them, that they have come to right place now. Read More