Category: News
how to generate {8,3} regular graphs for large number of vertices
hyperbolic latticeshyperbolic lattices hyperbolic lattices graph, matrices MATLAB Answers — New Questions
Need help setting print areas
I’m use Excel for Mac and recently my worksheets are not staying at one page when I select “fit to page”.
I larger spreadsheets and I can get the width to fit to the page by going to Page Layout –> Width –> 1 Page, but if I put the height to 1 Page instead of Automatic then it shrinks the entire spreadsheet to a small corner of the page. I can’t figure out why there are so many extra lines at the bottom of the spreadsheet, its blank and there’s no data. If I try to print or save as PDF, it will have an extra 3 – 4 blank pages at the bottom.
Can anyone help?
I’m use Excel for Mac and recently my worksheets are not staying at one page when I select “fit to page”. I larger spreadsheets and I can get the width to fit to the page by going to Page Layout –> Width –> 1 Page, but if I put the height to 1 Page instead of Automatic then it shrinks the entire spreadsheet to a small corner of the page. I can’t figure out why there are so many extra lines at the bottom of the spreadsheet, its blank and there’s no data. If I try to print or save as PDF, it will have an extra 3 – 4 blank pages at the bottom. Can anyone help? Read More
split Each Data store
How we can Split Each data store while training neural network with not disturbing the sequence of Images and labels so that it can train images and corresponding labels accordingly.
Thanks in advance.How we can Split Each data store while training neural network with not disturbing the sequence of Images and labels so that it can train images and corresponding labels accordingly.
Thanks in advance. How we can Split Each data store while training neural network with not disturbing the sequence of Images and labels so that it can train images and corresponding labels accordingly.
Thanks in advance. datastore, split, labels MATLAB Answers — New Questions
Auto Classify Power BI Reports
Hello,
Is there a way to automatically classify Power BI reports with scans? I have been testing and reviewing documentation but I can’t find anything. Thank you.
Hello, Is there a way to automatically classify Power BI reports with scans? I have been testing and reviewing documentation but I can’t find anything. Thank you. Read More
2d matrices with nearest hoppings (square lattice)
2d matrices2d matrices 2d matrices 2d matrics MATLAB Answers — New Questions
Assigned staff member not showing in confirmation email
I’ve seen many, many complaints about this but no response/resolution being posted.
The staff member assigned to an appointment no longer shows in the confirmation emails. How do we fix this? Customers need to know who they are assigned to.
I’ve seen many, many complaints about this but no response/resolution being posted. The staff member assigned to an appointment no longer shows in the confirmation emails. How do we fix this? Customers need to know who they are assigned to. Read More
Average a set of values based on date
So I am trying to average a set of values that we record each day, then drop them into a different sheet. I want to do this for every day of the year, but when I pull the formula down in the table, it only moves my set of numbers being average down 1 spot instead of 6 like I want. I have attached two pictures of the example data that I want to average as well as the picture of the final results that I want out of it. What I am confused is how to get the next set of averages to populate on the right date without having to do it manually for the entire year.
Data Set 1: 3/31/24
Data Set 2: 4/1/24
End Result average compilation:
So I am trying to average a set of values that we record each day, then drop them into a different sheet. I want to do this for every day of the year, but when I pull the formula down in the table, it only moves my set of numbers being average down 1 spot instead of 6 like I want. I have attached two pictures of the example data that I want to average as well as the picture of the final results that I want out of it. What I am confused is how to get the next set of averages to populate on the right date without having to do it manually for the entire year.Data Set 1: 3/31/24Data Set 2: 4/1/24End Result average compilation: Read More
azure automation hybrid worker platform best practice
Hi
We’re moving services around and checking that some of your architecture is according to best practices.
What is the recommendations on where to install Azure automation hybrid worker?
Can we install on an AD server?
AD Sync Server?
Dedicated server?
Kind Regards
HiWe’re moving services around and checking that some of your architecture is according to best practices.What is the recommendations on where to install Azure automation hybrid worker?Can we install on an AD server? AD Sync Server?Dedicated server?Kind Regards Read More
Conditional Formatting a Table
I am new to this so bare with me.
I am creating a schedule for 5 people. There are two columns and 8 rows. The column on the left has a dropdown menu with options 1-8 representing hours. There is also another cell containing a dropdown menu with the names of the 5 people who will be scheduling. The goals are as follows:
A row will automatically shade as the number of hours are choses. For example, if in the first row “1 hour” is chosen by “Dale”, the row will be shaded the color assigned to Dale. If 2 hours, 2 rows, etc. After 8 rows is shaded, the entire table is full.
currently, the rows are correctly shading with the selected number of hours and in the in the correct colors.
Here are the problems:
1. When another name is chosen from the drop-down menu, the rows that are already shaded automatically change to the color of the new user. They need to stay the original color and be locked for changes.
2. Number of hours can manually be entered ending up at more than 8 hours per day. Is there a way to limit input to the drop down only, no manual entry?
3. When I go back in to conditional formatting, the formulas are different. Is there something I am doing wrong? A way to prevent this from happening?
Conditional Formatting rules entered in each row for each user.
Row 1 =AND($A$2=”DAVE”, C5>=1) ….
Row 2 =AND($A$2=”DAVE”, C5+C6>=2) ….
Row 3 =AND($A$2=”DAVE”, C5+C6+C7>=3) ….
Any help is appreciated.
I am new to this so bare with me. I am creating a schedule for 5 people. There are two columns and 8 rows. The column on the left has a dropdown menu with options 1-8 representing hours. There is also another cell containing a dropdown menu with the names of the 5 people who will be scheduling. The goals are as follows: A row will automatically shade as the number of hours are choses. For example, if in the first row “1 hour” is chosen by “Dale”, the row will be shaded the color assigned to Dale. If 2 hours, 2 rows, etc. After 8 rows is shaded, the entire table is full. currently, the rows are correctly shading with the selected number of hours and in the in the correct colors. Here are the problems:1. When another name is chosen from the drop-down menu, the rows that are already shaded automatically change to the color of the new user. They need to stay the original color and be locked for changes. 2. Number of hours can manually be entered ending up at more than 8 hours per day. Is there a way to limit input to the drop down only, no manual entry?3. When I go back in to conditional formatting, the formulas are different. Is there something I am doing wrong? A way to prevent this from happening? Conditional Formatting rules entered in each row for each user. Row 1 =AND($A$2=”DAVE”, C5>=1) ….Row 2 =AND($A$2=”DAVE”, C5+C6>=2) ….Row 3 =AND($A$2=”DAVE”, C5+C6+C7>=3) …. Any help is appreciated. Read More
External email senders appear in DLP Activity Explorer
Why would I be seeing ingress DLP incidents and not solely egress? Does anyone else see this activity? I have triple checked all of my policies and they are all set to: Content is shared from Microsoft 365 with people outside my organization.
I’m going crazy, any guidance would help!
ty
Why would I be seeing ingress DLP incidents and not solely egress? Does anyone else see this activity? I have triple checked all of my policies and they are all set to: Content is shared from Microsoft 365 with people outside my organization. I’m going crazy, any guidance would help!ty Read More
Linked Cells between sheets not crossing over properly
I have two workbooks with linked cells that have been saved numerous times for over a year without problem. Today I open up my one sheet and there are a lot of #NAME? errors for some of those linked cells. The formulas for those particular cells all look similar to the one below. Where the word “Rent” is there should be a cell number so that the value of that cell shows up. The only way it’s allowing me to edit correctly is to manually change every single one.
The only way I’ve ever linked these is by inputting = then double clicking on the appropriate cell and the value shows up and the sheets are linked. I cannot do that anymore. The “formula” always pops up with a word in it (related to the horizontal line but not exactly the same) not the cell number.
I’ve now spent 3 hours working with online support to be told that my content is the problem and now I must manually enter all of these values. I don’t believe this as my content didn’t change and other values on the same sheets were linked the exact same way without problem.
I’m not a computer person, I’m learning. I’m a hairstylist just trying to keep my bookkeeping up. Please, any response needs to be as if you’re speaking with a 5 year old as I do not understand tech well at all.
='[Budget 2024 .xlsx]January’!Rent should be ='[Budget 2024 .xlsx]January’!$h$86
I have two workbooks with linked cells that have been saved numerous times for over a year without problem. Today I open up my one sheet and there are a lot of #NAME? errors for some of those linked cells. The formulas for those particular cells all look similar to the one below. Where the word “Rent” is there should be a cell number so that the value of that cell shows up. The only way it’s allowing me to edit correctly is to manually change every single one. The only way I’ve ever linked these is by inputting = then double clicking on the appropriate cell and the value shows up and the sheets are linked. I cannot do that anymore. The “formula” always pops up with a word in it (related to the horizontal line but not exactly the same) not the cell number. I’ve now spent 3 hours working with online support to be told that my content is the problem and now I must manually enter all of these values. I don’t believe this as my content didn’t change and other values on the same sheets were linked the exact same way without problem. I’m not a computer person, I’m learning. I’m a hairstylist just trying to keep my bookkeeping up. Please, any response needs to be as if you’re speaking with a 5 year old as I do not understand tech well at all. ='[Budget 2024 .xlsx]January’!Rent should be ='[Budget 2024 .xlsx]January’!$h$86 Read More
Run batch job on remote VM from Azure Data Factory
Hello,
I am new to Azure and work in an environment that is mixed Azure and on-prem.
I do not have access to alter firewall rules.
I do have Managed virtual networks set up for at least 1 Azure item.
I have an on prem REST application.
I have an Azure VM that is able to access REST on its vnet.
I have an Azure ADF instance on a vnet that can contact the VM but not the REST application.
I want to pipe ADF through the VM to obtain the data. I don’t even know if this is a thing.
Anyone with experience on this can outline what I should be trying to do?
thank you!
Hello, I am new to Azure and work in an environment that is mixed Azure and on-prem.I do not have access to alter firewall rules. I do have Managed virtual networks set up for at least 1 Azure item. I have an on prem REST application.I have an Azure VM that is able to access REST on its vnet.I have an Azure ADF instance on a vnet that can contact the VM but not the REST application. I want to pipe ADF through the VM to obtain the data. I don’t even know if this is a thing.Anyone with experience on this can outline what I should be trying to do? thank you! Read More
Attrition Rate calculation in Excel
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)
MTD – Total Nos of attrition/ Total Nos of Head count
YTD – total attrition from starting month to end month / average HC of starting month to end month
Don’t forget in headcount calculation we will also consider headcount attrited as a total calculation
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)MTD – Total Nos of attrition/ Total Nos of Head countYTD – total attrition from starting month to end month / average HC of starting month to end month Don’t forget in headcount calculation we will also consider headcount attrited as a total calculation Read More
GCCH Monthly M365 Webinar: New Teams Updates and Cross-Cloud Collaboration Envisioning
We’re looking forward to our next GCCH M365 Webinar on Tuesday, April 30, at 1200 EDT. It’s the Dave show as we’ll be joined by both Dave Jennings (new Teams) and Dave Nobles (empowering secure and effective collaboration between GCCH and DoD). To receive a calendar invite, please register here.
In addition, please find attached a roll up of April M365 roadmap highlights. Happy to field any questions with what is included.
Microsoft Tech Community – Latest Blogs –Read More
Sharing Recorded Teams session when external sharing is restricted
Hi all,
I have a question about recorded sessions from TEAMs
As part of our company policy, I had to restrict sharepoint external sharing only to a ppl that are part of a security group (in SharePoint admin -> Policies -> Sharing -> ). This however looks like has an impact on TEAMS recordings and external users invited to these meetings do not have access to recordings.
The recording is usually saved to OneDrive, so I guess the SharePoint external share restriction applies to OneDrive as well? If this is the root case of preventing external users to access recordings, what options are available?
Or is there a way to have this restrictions for SharePoint but not for OneDrive?
Hi all, I have a question about recorded sessions from TEAMs As part of our company policy, I had to restrict sharepoint external sharing only to a ppl that are part of a security group (in SharePoint admin -> Policies -> Sharing -> ). This however looks like has an impact on TEAMS recordings and external users invited to these meetings do not have access to recordings. The recording is usually saved to OneDrive, so I guess the SharePoint external share restriction applies to OneDrive as well? If this is the root case of preventing external users to access recordings, what options are available? Or is there a way to have this restrictions for SharePoint but not for OneDrive? Read More
How to stop “Convert to Stocks” popup
I am trying to use excel to create a spreadsheet of products. One column has an abbreviation for the product family. These are 3 letter uppercase. For the first time Excel keeps popping up a prompt to convert to stocks. The prompt blocks the data in the adjacent field. I have tried every option suggested on the web for disabling this and none of them work. This flaw is making excel unusable. Any advice?
I am trying to use excel to create a spreadsheet of products. One column has an abbreviation for the product family. These are 3 letter uppercase. For the first time Excel keeps popping up a prompt to convert to stocks. The prompt blocks the data in the adjacent field. I have tried every option suggested on the web for disabling this and none of them work. This flaw is making excel unusable. Any advice? Read More
MS 203 Microsoft 365 Certified: Messaging Administrator Associate has been retired
what is MS 203 (Microsoft 365 Certified: Messaging Administrator Associate) replacement. what is the roadmap for exchange server and exhangeonline? if anyone knew so please guide me.
what is MS 203 (Microsoft 365 Certified: Messaging Administrator Associate) replacement. what is the roadmap for exchange server and exhangeonline? if anyone knew so please guide me. Read More
How do I make my power query automation more dynamic?
I have created an automation using power query where it’ll fetch data from a workbook called “Data”. I have manipulated the data to achieve my desired table format. The table’s final columns are: Vendor Name, Contract #, and (after pivoting the columns) the Total Amount Outstanding for the years 2019-2024 (6 separate columns). The problem I am running into is that some of my input, “Data”, workbooks only have years 2019-2023 while some have years 2020-2024. Since the initial data file I constructed my table around contained the years 2019-2024, any file I load into the table that does not include the same years reports an error message saying something like: “The column 2024 of the table was not found”. I know these sorts of things work great with standardized datasets but in this case, my years will fluctuate by one or two. How can I make my table more dynamic so that regardless of whether the file contains the same years (2019-2024) or different (i.e., 2019-2023, 2020-2024, etc…) it will still read it in and perform my desired formatting without any error messages?
I have created an automation using power query where it’ll fetch data from a workbook called “Data”. I have manipulated the data to achieve my desired table format. The table’s final columns are: Vendor Name, Contract #, and (after pivoting the columns) the Total Amount Outstanding for the years 2019-2024 (6 separate columns). The problem I am running into is that some of my input, “Data”, workbooks only have years 2019-2023 while some have years 2020-2024. Since the initial data file I constructed my table around contained the years 2019-2024, any file I load into the table that does not include the same years reports an error message saying something like: “The column 2024 of the table was not found”. I know these sorts of things work great with standardized datasets but in this case, my years will fluctuate by one or two. How can I make my table more dynamic so that regardless of whether the file contains the same years (2019-2024) or different (i.e., 2019-2023, 2020-2024, etc…) it will still read it in and perform my desired formatting without any error messages? Read More
Schedule Alerts in Microsoft Sentinel
Hello all,
I have some Playbooks in azure that were created using the Logic App Designer to send me an email alert whenever the incident is created / triggered. I want to have these to go off or be active only during specific hours, for example 10am – 3pm.
Is this possible and how would I achieve this?
Thanks for any help in advance
Hello all,I have some Playbooks in azure that were created using the Logic App Designer to send me an email alert whenever the incident is created / triggered. I want to have these to go off or be active only during specific hours, for example 10am – 3pm.Is this possible and how would I achieve this?Thanks for any help in advanceAlertsPlaybooks Read More
Battery Builder to Simulink Model Perfromance Check
I have created a Prismatic battery pack from Battery Builder App, after that i have got 2 blocks in simulink as simscape blocks. After that i want to find the performance,SOC, CCCV, Input/output Power with respect to load,speed or terrain and power losses due to resistance, cell behaviour and few more if you suggest. But I am not able to understand the conversion from simscape physical model to simulink model. if you could provide me any suggestion will be helpful.I have created a Prismatic battery pack from Battery Builder App, after that i have got 2 blocks in simulink as simscape blocks. After that i want to find the performance,SOC, CCCV, Input/output Power with respect to load,speed or terrain and power losses due to resistance, cell behaviour and few more if you suggest. But I am not able to understand the conversion from simscape physical model to simulink model. if you could provide me any suggestion will be helpful. I have created a Prismatic battery pack from Battery Builder App, after that i have got 2 blocks in simulink as simscape blocks. After that i want to find the performance,SOC, CCCV, Input/output Power with respect to load,speed or terrain and power losses due to resistance, cell behaviour and few more if you suggest. But I am not able to understand the conversion from simscape physical model to simulink model. if you could provide me any suggestion will be helpful. simulink, simscape, battery builder, battery, performance, heavy load vehicle MATLAB Answers — New Questions