Month: July 2024
Copy cell from an array of sheets.
I have 4 sheets. “Jane Doe, John Smith, Keven Brown, and Jean Grey” Each of these sheets contains information associated with an employee.
I want to be able to populate the Current Active Employee sheet cells D-Q with the information from each of the sheets based on if the employee number matches/is the same.
I have inserted this equation on ‘Current Active Employees’!D1-Q7, but have not gotten any results.
Any suggestions?
I have 4 sheets. “Jane Doe, John Smith, Keven Brown, and Jean Grey” Each of these sheets contains information associated with an employee. I want to be able to populate the Current Active Employee sheet cells D-Q with the information from each of the sheets based on if the employee number matches/is the same. I have inserted this equation on ‘Current Active Employees’!D1-Q7, but have not gotten any results. Any suggestions? Read More
Azure Inherited roles, but still access denied
Hi,
In e.g. Key Vault, when looking for the Access Control I can see that user account have custom contributor role inherited from the subscription level. When looking for the role more deeply it shows:
“Showing 500 of 15937 permissions View all (will take a moment to load)“
E.g. having the following permissions: Read Secret Properties and Write Secret. So all should be kind of okay..? 🙂
But when I’m looking for the e.g. secrets in the key vault, it gives me back “The operation is not allowed by RBAC.” and “You are unauthorized to view these contents.“. I thought there could be a “deny” rules, but nothing in there either.
What could be the trick on here? What might be blocking or missing the access to the resources.
Btw, I just tested, I was able to create the Key Vault by myself.
Hi, In e.g. Key Vault, when looking for the Access Control I can see that user account have custom contributor role inherited from the subscription level. When looking for the role more deeply it shows:”Showing 500 of 15937 permissions View all (will take a moment to load)”E.g. having the following permissions: Read Secret Properties and Write Secret. So all should be kind of okay..? 🙂 But when I’m looking for the e.g. secrets in the key vault, it gives me back “The operation is not allowed by RBAC.” and “You are unauthorized to view these contents.”. I thought there could be a “deny” rules, but nothing in there either. What could be the trick on here? What might be blocking or missing the access to the resources. Btw, I just tested, I was able to create the Key Vault by myself. Read More
XXX virtual machines should enable Azure Disk Encryption or EncryptionAtHost.
Hello everyone, I’m facing issues related to a policy:
However, the policy does not recognize that it is encrypted and shows it as non-compliant.
The same happens when enabling Azure Disk Encryption (ADE): the policy still indicates that it is non-compliant.
Has anyone else experienced this?
Hello everyone, I’m facing issues related to a policy:Linux virtual machines should enable Azure Disk Encryption or EncryptionAtHost.Windows virtual machines should enable Azure Disk Encryption or EncryptionAtHost. After enabling EncryptionAtHost, it appears as encrypted in the portal. However, the policy does not recognize that it is encrypted and shows it as non-compliant. The same happens when enabling Azure Disk Encryption (ADE): the policy still indicates that it is non-compliant. Has anyone else experienced this? Read More
Billed and unbilled daily rated usage reconciliation API v2 (GA)
I’m testing this new api and I need the information BillingProvider that was in the sdk but I can’t find it in this new api.
Is it possible to retrieve this information?
Thank you in advance
I’m testing this new api and I need the information BillingProvider that was in the sdk but I can’t find it in this new api.Is it possible to retrieve this information?Thank you in advance Read More
Mail Merge and Excel
Hello everyone, I could really use some insight here. I am pulling out my hair as I cannot figure out what is going on. I have rows of records from which I am trying to merge some of the info into Mail Merge. The normal data does not seem to be a problem. However, when I try to merge in Dates this is where the trouble begins. In my Mail Merge Letter I have Merge Fields that have From and To Dates that I am trying to merge in but I keep getting numbers that represent the dates. Especially the To Date and some other dates I have in the letter. Only the From Date is displaying correctly. So, as an example, I have: Monday, March 18, 2024 to 45375 when it should display as Sunday, March 24, 2024. I have applied the switches and yet I still keep getting the numbers. The date for the To Date in the Excel workbook is calculated if this makes any difference. =IF(M2=””,””,M2+6). Can anyone help me figure this out? I really need to perform these Mail Merges but these numbers being generated will mean nothing to no one. Seems like such a simple process yet being so complicated.
Here is the Merge field set up but regardless of this it is just showing the numbers on the merge/preview. {MERGEFIELD End_Date @ “dddd, MMMM d, yyyy” }. What am I missing??
Thank you to any folks that can help me figure this out.
Carl
Hello everyone, I could really use some insight here. I am pulling out my hair as I cannot figure out what is going on. I have rows of records from which I am trying to merge some of the info into Mail Merge. The normal data does not seem to be a problem. However, when I try to merge in Dates this is where the trouble begins. In my Mail Merge Letter I have Merge Fields that have From and To Dates that I am trying to merge in but I keep getting numbers that represent the dates. Especially the To Date and some other dates I have in the letter. Only the From Date is displaying correctly. So, as an example, I have: Monday, March 18, 2024 to 45375 when it should display as Sunday, March 24, 2024. I have applied the switches and yet I still keep getting the numbers. The date for the To Date in the Excel workbook is calculated if this makes any difference. =IF(M2=””,””,M2+6). Can anyone help me figure this out? I really need to perform these Mail Merges but these numbers being generated will mean nothing to no one. Seems like such a simple process yet being so complicated. Here is the Merge field set up but regardless of this it is just showing the numbers on the merge/preview. {MERGEFIELD End_Date @ “dddd, MMMM d, yyyy” }. What am I missing?? Thank you to any folks that can help me figure this out. Carl Read More
Ad-Hoc Data Exploration Feature
Ad-Hoc Data Exploration Feature
We are excited to introduce the new Data Exploration feature, designed to enhance your ability to delve deeper into the data presented on any Dashboard.
If the information you’re seeking isn’t readily available on the dashboard, this feature allows you to extend your exploration beyond the data displayed in the tiles, potentially uncovering new insights.
Directly from a dashboard, you can refine your exploration using a user-friendly, form-like interface. This intuitive and dynamic experience is tailored for insights explorers seeking insights based on high volumes of data in near real time.
You can add filters, create aggregations, and switch visualization types without writing queries to easily uncover insights.
With this new feature, you are no longer bound by the limitations of pre-defined dashboards, nor are you required to master KQL (Kusto Query Language). As independent explorers, you have the freedom for ad-hoc exploration, leveraging existing tiles to kickstart your journey.
Learn more about this feature Explore data in dashboard tiles (preview) – Azure Data Explorer | Microsoft Learn
Azure Data Explorer Web UI team is looking forward to your feedback in KustoWebExpFeedback@service.microsoft.com
You’re also welcome to add more ideas and vote for them here – https://aka.ms/adx.ideas
Microsoft Tech Community – Latest Blogs –Read More
Mid-Year Viva Connections Recap and Highlights
Viva Connections serves as a gateway to a modern employee experience. From streamlining tasks to enhancing communication, dashboard cards bring in actionable tasks and information from virtually anywhere into a single dynamic app for employees.
We have seen growing adoption of Viva Connections, making us one of the most popular apps in Microsoft Teams. We are continuing to invest in Viva Connections, addressing customer feedback and enhancing capabilities. Here are the latest and greatest highlights.
Staying Connected
Viva Connections is all about connecting you to the things you need, and now, you can get Desktop Notifications to ensure you don’t miss the latest news and announcements. This new capability gives your employees the ability to control which notifications they want to receive within Teams.
To better connect your employees to the resources they need most, we’ve recently rolled out the ability to import global navigation items into the Viva Connections Resources tab.
We’ve also released Viva Connections on the web that brings a dynamic, beautiful app experience directly into the browser.
Enhancing Communication Capabilities
The new customizable Spotlight offers communicators a sleek, above-the-fold section to highlight key news. Up to eleven pieces of news can be added to the Spotlight carousel for announcements and campaigns that need extra emphasis and durability. In case you missed it, read more about Spotlight here.
Highlight key news and campaigns with Spotlight
Announcements
New communication features also enable Regional Announcements, which provides additional attribute-based targeting based on job, title, and location. This is specifically geared for reaching Frontline Workers (FLWs) working in different regions, branches, stores, or departments by using filtering.
Filter your audience based on FLW attributes like location, department, and job title.
Learn more about how to set up regional filtering and using FLW announcements. Note this feature requires Frontline licensing.
Analytics for Admins
Admins can now understand how and when users engage with components of the Viva Connections experience. You can see data on overall traffic, usage, and engagement across each of your organization’s Connections experiences. Learn more about how to access usage data here.
A view of analytics in Viva Connections
Dashboard Card Experiences & Bot Extensions
Dashboard cards in Viva Connections are the building blocks to a modern employee experience. We’ve focused heavily on creating and enhancing cards for all audiences. You can now personalize dashboard cards on desktop allowing your employees to customize their view by adding, removing or reordering the dashboard cards.
Here are some of the top dashboard card updates:
OneDrive Card update
This new card allows organizations to add a OneDrive Files Card to the Viva Connections dashboard, showing recently accessed, shared, or favorite files. This card is now generally available and requires no action for setup.
Pulse Card
The Viva Pulse card in Viva Connections allows you to create Pulse survey (s) via the dashboard, giving employees a quick and targeted way to share feedback and participate in workplace surveys. Once the survey is complete, the owner can view the response rate right on the card.
Assigned Tasks Card
The Assigned Tasks card automatically displays information to users about their assigned tasks to. This information is retrieved from the Tasks app in Teams and enables users to quickly take action and accomplish tasks right from their dashboard.
Learn more about our Viva Connections dashboard cards in this blog.
We hope you’re seeing how these features collectively enhance employee engagement, streamline communication, and provide valuable insights into employee interactions with the app. Keep checking back to see what we do next!
Microsoft Tech Community – Latest Blogs –Read More
How can I iterate through an array using a for loop?
I want to iterate through an array of file locations using a for loop.
My current code is something like this:
% Paths where the files are located
P1 = C:UsersmeDocuments\My Info
%Find excel files in path
%Pull data
% Write into a file
Now this code works great, but now I need to do the same thing to multiple paths while maintaining efficiency. To do this, I created an array of the paths I need to iterate through. How do I use a for loop to iterate through these paths? Here is what I have so far, but my code breaks when it tries to read the path because the text is not scalar when trying to use ‘dir’. Here is what I currently have:
% Paths where the files are located
P1 = C:UsersmeDocuments\My Info
P2 = C:UsersmeDocuments\My data
%Array of paths
Array = {‘P1, P2’}
for i = 1:length(Array)
%Find excel files in path
%Pull data
% Write into a fileI want to iterate through an array of file locations using a for loop.
My current code is something like this:
% Paths where the files are located
P1 = C:UsersmeDocuments\My Info
%Find excel files in path
%Pull data
% Write into a file
Now this code works great, but now I need to do the same thing to multiple paths while maintaining efficiency. To do this, I created an array of the paths I need to iterate through. How do I use a for loop to iterate through these paths? Here is what I have so far, but my code breaks when it tries to read the path because the text is not scalar when trying to use ‘dir’. Here is what I currently have:
% Paths where the files are located
P1 = C:UsersmeDocuments\My Info
P2 = C:UsersmeDocuments\My data
%Array of paths
Array = {‘P1, P2’}
for i = 1:length(Array)
%Find excel files in path
%Pull data
% Write into a file I want to iterate through an array of file locations using a for loop.
My current code is something like this:
% Paths where the files are located
P1 = C:UsersmeDocuments\My Info
%Find excel files in path
%Pull data
% Write into a file
Now this code works great, but now I need to do the same thing to multiple paths while maintaining efficiency. To do this, I created an array of the paths I need to iterate through. How do I use a for loop to iterate through these paths? Here is what I have so far, but my code breaks when it tries to read the path because the text is not scalar when trying to use ‘dir’. Here is what I currently have:
% Paths where the files are located
P1 = C:UsersmeDocuments\My Info
P2 = C:UsersmeDocuments\My data
%Array of paths
Array = {‘P1, P2’}
for i = 1:length(Array)
%Find excel files in path
%Pull data
% Write into a file matlab, for loop, array MATLAB Answers — New Questions
Using experimental data on geotrajectory function and checking trajectory dynamics with lookuPose function (SATCOM toolbox)
Hello everyone,
Im using SATCOM toolbox to evaluate a SATCOM link.
I have experimental flight profile data with a samplerate of 100Hz, that im using in the geotrajectory function
trajectory = geoTrajectory(Waypoints=[lat lon alt],TimeOfArrival=time,Velocities=[vnedx vnedy vnedz],ReferenceFrame="NED",Orientation=Euler);
then im using the lookupPose function to extract dynamical information
[position,orientation,velocity,acceleration,angularVelocity] = lookupPose(trajectory,time);
Finally, Im comparing the experimental data with the information provided by lookupPose.
Position, orientation and velocity matched the experimental data that was provided in the geotrajectory function.
I derived experimental acceleration using a forward difference numerical derivative of the experimental velocity data. When I compared this experimental acceleration data to the acceleration provided by the lookupPose, the results did not match exactly for velocity in x and y, but they were comparable. This is expected since the lookupPose might be using a different derivative method (see Figure below). However the velocity in z did not match at all.
The results shown above are derived using a sample rate of 1Hz ( I downsampled the experimental data). The problem arises when I increase the sample rate for example to 10 Hz. As seen in the images below the acceleration provide by the lookupPose function goes bersek.
My questions are:
Does the lookupPose function has a minimum sample rate limit (1Hz).
What is the numerical derivative used by the lookupPose function to calculate acceleration from velocity?
Is there a way to change the numerical derivative used by lookupPose to calculate acceleration?
Why does the Z component of acceleration does not match for a sample rate of 1Hz (even worse for 0.1 Hz).
As a reference these are the comparitions between experimental data of velocity ( given to geotrajetory ) and what the lookuppose outputs, (this comparisson is for 10Hz). The results are exactly the same.
Any help or guidance you could provide would be greatly appreciated. Thank you in advance for your assistance!.Hello everyone,
Im using SATCOM toolbox to evaluate a SATCOM link.
I have experimental flight profile data with a samplerate of 100Hz, that im using in the geotrajectory function
trajectory = geoTrajectory(Waypoints=[lat lon alt],TimeOfArrival=time,Velocities=[vnedx vnedy vnedz],ReferenceFrame="NED",Orientation=Euler);
then im using the lookupPose function to extract dynamical information
[position,orientation,velocity,acceleration,angularVelocity] = lookupPose(trajectory,time);
Finally, Im comparing the experimental data with the information provided by lookupPose.
Position, orientation and velocity matched the experimental data that was provided in the geotrajectory function.
I derived experimental acceleration using a forward difference numerical derivative of the experimental velocity data. When I compared this experimental acceleration data to the acceleration provided by the lookupPose, the results did not match exactly for velocity in x and y, but they were comparable. This is expected since the lookupPose might be using a different derivative method (see Figure below). However the velocity in z did not match at all.
The results shown above are derived using a sample rate of 1Hz ( I downsampled the experimental data). The problem arises when I increase the sample rate for example to 10 Hz. As seen in the images below the acceleration provide by the lookupPose function goes bersek.
My questions are:
Does the lookupPose function has a minimum sample rate limit (1Hz).
What is the numerical derivative used by the lookupPose function to calculate acceleration from velocity?
Is there a way to change the numerical derivative used by lookupPose to calculate acceleration?
Why does the Z component of acceleration does not match for a sample rate of 1Hz (even worse for 0.1 Hz).
As a reference these are the comparitions between experimental data of velocity ( given to geotrajetory ) and what the lookuppose outputs, (this comparisson is for 10Hz). The results are exactly the same.
Any help or guidance you could provide would be greatly appreciated. Thank you in advance for your assistance!. Hello everyone,
Im using SATCOM toolbox to evaluate a SATCOM link.
I have experimental flight profile data with a samplerate of 100Hz, that im using in the geotrajectory function
trajectory = geoTrajectory(Waypoints=[lat lon alt],TimeOfArrival=time,Velocities=[vnedx vnedy vnedz],ReferenceFrame="NED",Orientation=Euler);
then im using the lookupPose function to extract dynamical information
[position,orientation,velocity,acceleration,angularVelocity] = lookupPose(trajectory,time);
Finally, Im comparing the experimental data with the information provided by lookupPose.
Position, orientation and velocity matched the experimental data that was provided in the geotrajectory function.
I derived experimental acceleration using a forward difference numerical derivative of the experimental velocity data. When I compared this experimental acceleration data to the acceleration provided by the lookupPose, the results did not match exactly for velocity in x and y, but they were comparable. This is expected since the lookupPose might be using a different derivative method (see Figure below). However the velocity in z did not match at all.
The results shown above are derived using a sample rate of 1Hz ( I downsampled the experimental data). The problem arises when I increase the sample rate for example to 10 Hz. As seen in the images below the acceleration provide by the lookupPose function goes bersek.
My questions are:
Does the lookupPose function has a minimum sample rate limit (1Hz).
What is the numerical derivative used by the lookupPose function to calculate acceleration from velocity?
Is there a way to change the numerical derivative used by lookupPose to calculate acceleration?
Why does the Z component of acceleration does not match for a sample rate of 1Hz (even worse for 0.1 Hz).
As a reference these are the comparitions between experimental data of velocity ( given to geotrajetory ) and what the lookuppose outputs, (this comparisson is for 10Hz). The results are exactly the same.
Any help or guidance you could provide would be greatly appreciated. Thank you in advance for your assistance!. satellite communication toolbox, lookuppose function, acceleration MATLAB Answers — New Questions
SharePoint Video Transcript Automated File Create and Download
For every video uploaded to SharePoint, transcripts are produced. However, we need a separate file (word document) containing the transcript text for each video. We can manually download the transcript for each video from SharePoint, but our aim is to automate this process. Ideally, every time a video is uploaded to SharePoint, a transcript would be generated, and the corresponding file would be automatically downloaded and saved in the same SharePoint folder.
We attempted to use Power Automate for this task, but after several months of working with MS support and the Product Groups it seems that this is not feasible, and they do not intend to address this issue.
I am hoping someone in this community can help us find a way to accomplish this goal using Power Automate.
For every video uploaded to SharePoint, transcripts are produced. However, we need a separate file (word document) containing the transcript text for each video. We can manually download the transcript for each video from SharePoint, but our aim is to automate this process. Ideally, every time a video is uploaded to SharePoint, a transcript would be generated, and the corresponding file would be automatically downloaded and saved in the same SharePoint folder. We attempted to use Power Automate for this task, but after several months of working with MS support and the Product Groups it seems that this is not feasible, and they do not intend to address this issue. I am hoping someone in this community can help us find a way to accomplish this goal using Power Automate. Read More
Calculated Column to Average numbers in column, dividing by number of columns with values
I have a SP list that will have some columns populated and some left blank. Each column is scored out of 5. If i have 3 columns with 5 and 3 columns left blank I would like the calculated column to see 3 values, add them and divide by the number of columns with values.
So in this case it would see 5,5,5 totalling 15 and divide by only 3 to give me an average of 5. Currently it would divide by 6 columns.
I have a SP list that will have some columns populated and some left blank. Each column is scored out of 5. If i have 3 columns with 5 and 3 columns left blank I would like the calculated column to see 3 values, add them and divide by the number of columns with values. So in this case it would see 5,5,5 totalling 15 and divide by only 3 to give me an average of 5. Currently it would divide by 6 columns. Read More
OneNote notebook share permissions unexpectantly change from edit to view
I have a user who has shared their notebook with over a dozen users and has granted them edit permissions. They are reporting that occasionally (it has happened more than once) that the permissions for the other users changes to view for no apparent reason. The notebook owner, to fix the issue, needs to reshare the notebook with the correct permissions. They are getting frustrated that they have to do this at all.
Is there a scenario that might explain why this is happening? Is this a bug?
Please advise.
I have a user who has shared their notebook with over a dozen users and has granted them edit permissions. They are reporting that occasionally (it has happened more than once) that the permissions for the other users changes to view for no apparent reason. The notebook owner, to fix the issue, needs to reshare the notebook with the correct permissions. They are getting frustrated that they have to do this at all.Is there a scenario that might explain why this is happening? Is this a bug?Please advise. Read More
¿How can I transform an already working code to a GUI?
I have a code that works fine and gives me the expected outputs. I don´t know how to transform that code into an app that asks me for the inputs and returns the plot of such result.I have a code that works fine and gives me the expected outputs. I don´t know how to transform that code into an app that asks me for the inputs and returns the plot of such result. I have a code that works fine and gives me the expected outputs. I don´t know how to transform that code into an app that asks me for the inputs and returns the plot of such result. gui, graphical interface, guide, appdesigner MATLAB Answers — New Questions
Matlab Runtime eval command permission denied
Hi,
I’m currently trying to get a compiled simulink model running inside a docker container. For this, I’m using the matlab runtime r2022b image from the docker hub. To futher investigate some errors, I started a virtual machine with ubuntu 20 and installed matlab runtime. When I try to run my application with the compiled bash script, I get: "Permission denied"
I installed matlab runtime on the user desktop and also in the standard folder, but it did not work.Hi,
I’m currently trying to get a compiled simulink model running inside a docker container. For this, I’m using the matlab runtime r2022b image from the docker hub. To futher investigate some errors, I started a virtual machine with ubuntu 20 and installed matlab runtime. When I try to run my application with the compiled bash script, I get: "Permission denied"
I installed matlab runtime on the user desktop and also in the standard folder, but it did not work. Hi,
I’m currently trying to get a compiled simulink model running inside a docker container. For this, I’m using the matlab runtime r2022b image from the docker hub. To futher investigate some errors, I started a virtual machine with ubuntu 20 and installed matlab runtime. When I try to run my application with the compiled bash script, I get: "Permission denied"
I installed matlab runtime on the user desktop and also in the standard folder, but it did not work. matlab runtime, linux, installation MATLAB Answers — New Questions
how to extract range of dates from timetable?
hi all,
The attached screenshot shows some data I need to extract based on time from the timetable.
For example, all measurements were collected on July 8, 2021, then all measurements were collected on July 9, 2021, and so on.
your help is appreciatedhi all,
The attached screenshot shows some data I need to extract based on time from the timetable.
For example, all measurements were collected on July 8, 2021, then all measurements were collected on July 9, 2021, and so on.
your help is appreciated hi all,
The attached screenshot shows some data I need to extract based on time from the timetable.
For example, all measurements were collected on July 8, 2021, then all measurements were collected on July 9, 2021, and so on.
your help is appreciated timetable MATLAB Answers — New Questions
Mimic excel report in SSRS using VS 2019
Hi All,
I have a user who wants the SSRS report to look exactly the same as the current excel sheet. I have done my best, but I am stuck at the tail end. Hope I get some advice. The first screen shot is my SSRS Report using Matrix table (mimicking excel ). Until now I am good , now I need to add a calculated field Total=(casecount+casecount1), which should look like the second screen shot. Here the “Total” needs to be next 2024, Facility should be empty , the rest will be the same. I tried adding total to row group, column group and many more things nothing worked. Any advice?
Thanks
Hi All,I have a user who wants the SSRS report to look exactly the same as the current excel sheet. I have done my best, but I am stuck at the tail end. Hope I get some advice. The first screen shot is my SSRS Report using Matrix table (mimicking excel ). Until now I am good , now I need to add a calculated field Total=(casecount+casecount1), which should look like the second screen shot. Here the “Total” needs to be next 2024, Facility should be empty , the rest will be the same. I tried adding total to row group, column group and many more things nothing worked. Any advice?Thanks Read More
Please help urgent due FRIDAY
I am working on coding a game in excel 2048. I haven’t used any macros or VBA’s and I have made I combined function for the movement and whether a 2 or 4 can spawn in that cell with an IF AND function. I finished off the function and everything seemed fine until i got the too many arguments alert. Sorry about how long the formula is. But i need an option as its due friday
=IF(AND($L$5=1,$M$5=2,F5<2),4,IF(AND($L$5=1,$M$5=1,F5<2),2,IF(AND(G10=”down”,F5=F6,F6<>F7,F7<>F8),0,IF(AND(G10=”down”,F6=0),0,IF(AND(G10=”down”,F6<>F5,F6=F7),0,IF(AND(G10=”down”,F6<>F5,F6<>F7,F7=F8),0,IF(AND(G10=”down”,F5<>F6,F7=0),0,IF(AND(G10=”down”,F5<>F6,F7<>F6,F8=0),0,IF(AND(G10=”right”,F5<>G5,G5<>H5,H5=I5),0,IF(AND(G10=”right”,F5<>G5,G5=H5),0,IF(AND(G10=”right”,F5=G5),0,IF(AND(G10=”right”,F5<>G5,G5<>H5,H5<>I5,I5=0),0,IF(AND(G10=”right”,F5<>G5,G5<>H5,G5=0),0,IF(AND(G10=”left”,F5<>G5,G5<>0),F5,IF(AND(G10=”left”,F5<>G5,G5=0,H5<>F5,H5=0,F5<>I5),F5,IF(AND(G10=”left”,F5<>G5,G5=0,F5<>H5,H5=0,F5=I5),F5+I5,IF(AND(G10=”left”,F5<>G5,G5=0,F5=H5),F5+H5,IF(AND(G10=”left”,F5<>G5,G5=0,F5<>H5,H5=0,F5<>I5),0,IF(AND(G10=”left”,F5=G5,f5>0),F5+G5,IF(AND(G10=”up”,F5=F6,f5>0),F5+F6,IF(AND(G10=”up”,F5<>F6,F6=0,F5=H5),F5+H5,IF(AND(G10=”up”,F5<>F6,F6=0,F5<>F7,F7=0,F5=F8),F5+F8,F5,IF(AND(g10=”left”,f5<>g5,f5=0,g5>0,h5<>g5,h5<>0),f5+g5,IF(AND(g10=”left”,f5<>g5,f5=0,g5>0,h5<>g5,h5=0,g5=i5),g5+I5,IF(and(g10=”left”,f5=0,g5=0,h5>0,i5<>h5),f5+h5,IF(AND(g10=”left”,f5=0,g5=0,h5=0,i5>0),f5+i5,IF(and(g10=”left”,f5=0,g5=h5,g5>0),g5+h5,IF(AND(g10=”left”,f5=0,g5=0,h5>0,i5=h5),i5+h5,IF(AND(g10=”up”,f5=0,f6>0,f7<>f6,f7<>0),f5+f6,IF(AND(g10=”up”,f5=0,f6=0,f7>0,f7<>f8),f5+f8,IF(AND(g10=”up”,f5=0,f6=0,f7=0,f8<>0),f5+f8,IF(AND(g10=”up”,f5=0,f6>0,f6=f7),f6+f7,IF(AND(g10=”up”,f5=0,f6=0,f7=0,f8>0),f5+f8,IF(AND(g10=”up”,f5=0,f6=f7,f6>0),f6+f7,IF(AND(g10=”up”,f5=0,f6>0,f7=0,f8=f6),f6+f8,IF(AND(g10=”up”,f5=0,f6=0,f7=f8),f7+f8,))))))))))))))))))))))))))))))))))))
I am working on coding a game in excel 2048. I haven’t used any macros or VBA’s and I have made I combined function for the movement and whether a 2 or 4 can spawn in that cell with an IF AND function. I finished off the function and everything seemed fine until i got the too many arguments alert. Sorry about how long the formula is. But i need an option as its due friday =IF(AND($L$5=1,$M$5=2,F5<2),4,IF(AND($L$5=1,$M$5=1,F5<2),2,IF(AND(G10=”down”,F5=F6,F6<>F7,F7<>F8),0,IF(AND(G10=”down”,F6=0),0,IF(AND(G10=”down”,F6<>F5,F6=F7),0,IF(AND(G10=”down”,F6<>F5,F6<>F7,F7=F8),0,IF(AND(G10=”down”,F5<>F6,F7=0),0,IF(AND(G10=”down”,F5<>F6,F7<>F6,F8=0),0,IF(AND(G10=”right”,F5<>G5,G5<>H5,H5=I5),0,IF(AND(G10=”right”,F5<>G5,G5=H5),0,IF(AND(G10=”right”,F5=G5),0,IF(AND(G10=”right”,F5<>G5,G5<>H5,H5<>I5,I5=0),0,IF(AND(G10=”right”,F5<>G5,G5<>H5,G5=0),0,IF(AND(G10=”left”,F5<>G5,G5<>0),F5,IF(AND(G10=”left”,F5<>G5,G5=0,H5<>F5,H5=0,F5<>I5),F5,IF(AND(G10=”left”,F5<>G5,G5=0,F5<>H5,H5=0,F5=I5),F5+I5,IF(AND(G10=”left”,F5<>G5,G5=0,F5=H5),F5+H5,IF(AND(G10=”left”,F5<>G5,G5=0,F5<>H5,H5=0,F5<>I5),0,IF(AND(G10=”left”,F5=G5,f5>0),F5+G5,IF(AND(G10=”up”,F5=F6,f5>0),F5+F6,IF(AND(G10=”up”,F5<>F6,F6=0,F5=H5),F5+H5,IF(AND(G10=”up”,F5<>F6,F6=0,F5<>F7,F7=0,F5=F8),F5+F8,F5,IF(AND(g10=”left”,f5<>g5,f5=0,g5>0,h5<>g5,h5<>0),f5+g5,IF(AND(g10=”left”,f5<>g5,f5=0,g5>0,h5<>g5,h5=0,g5=i5),g5+I5,IF(and(g10=”left”,f5=0,g5=0,h5>0,i5<>h5),f5+h5,IF(AND(g10=”left”,f5=0,g5=0,h5=0,i5>0),f5+i5,IF(and(g10=”left”,f5=0,g5=h5,g5>0),g5+h5,IF(AND(g10=”left”,f5=0,g5=0,h5>0,i5=h5),i5+h5,IF(AND(g10=”up”,f5=0,f6>0,f7<>f6,f7<>0),f5+f6,IF(AND(g10=”up”,f5=0,f6=0,f7>0,f7<>f8),f5+f8,IF(AND(g10=”up”,f5=0,f6=0,f7=0,f8<>0),f5+f8,IF(AND(g10=”up”,f5=0,f6>0,f6=f7),f6+f7,IF(AND(g10=”up”,f5=0,f6=0,f7=0,f8>0),f5+f8,IF(AND(g10=”up”,f5=0,f6=f7,f6>0),f6+f7,IF(AND(g10=”up”,f5=0,f6>0,f7=0,f8=f6),f6+f8,IF(AND(g10=”up”,f5=0,f6=0,f7=f8),f7+f8,)))))))))))))))))))))))))))))))))))) Read More
Heure déroulante
Bonjour,
Pourriez-vous me guider pour avoir l’heure déroulante sur chaque feuille de travail comme sur l’ordinateur en bas à droite. Merci
Bonjour,Pourriez-vous me guider pour avoir l’heure déroulante sur chaque feuille de travail comme sur l’ordinateur en bas à droite. Merci Read More
Error while running Teams workflow for sending message to a channel by triggering webhook
Hi,
I was using the incoming webhook connectors for sending messages to channels via webhooks. Recently heard that these connectors are no longer supported and need to use workflows. I had setup a workflow for the same and tried to trigger it from the UI itself. But every time it is returning an error as shown below. I tried to hit the workflow URL externally and it returned success (202) response, but no messages were delivered to my channel.
Error shown while running the workflow from UI.
Flow ‘3d8843ba-0636-0d1d-bb10-7234s4r4fea5’ cannot be installed.
Please help me to find a solution to replace my old incoming webhook connectors.
Thanks.
Hi,I was using the incoming webhook connectors for sending messages to channels via webhooks. Recently heard that these connectors are no longer supported and need to use workflows. I had setup a workflow for the same and tried to trigger it from the UI itself. But every time it is returning an error as shown below. I tried to hit the workflow URL externally and it returned success (202) response, but no messages were delivered to my channel.Error shown while running the workflow from UI.Flow ‘3d8843ba-0636-0d1d-bb10-7234s4r4fea5’ cannot be installed.Please help me to find a solution to replace my old incoming webhook connectors. Thanks. Read More
B2B Users Risky Policies Mitigation
Is there a possibility for B2B users to mitigate Risky Policies in the resource tenant?
Auto-remediation policies not helpful for password change due to different home tenant and no MS references that helps to mitigate B2B users other than exclusion from the risky group.
Is there a possibility for B2B users to mitigate Risky Policies in the resource tenant? Auto-remediation policies not helpful for password change due to different home tenant and no MS references that helps to mitigate B2B users other than exclusion from the risky group. Read More
