PlanC | Restore local CrashPlan Home backups even after Code42

I am working on a query for an insurance application and it has insurance plans. Let’s say PlanA, PlanB, PlanC, PlanD

The insurance plans are in the database and I can fetch them directly using a select query.

I am trying to search row by column value in spreadsheet (Google Sheets) API Google documentation having API for find & Replace but no API available for find/search.

Some approaches i already tried to achieve searching by value in spreadsheet.

1. Google Visualization API Query Language: this approach is returning rows matching values.

   Some issues in response:

   a) Not returning row number (No indexing)

   b) search is case sensitive

   Is it possible to get row number in result of this method?

2. Set column

I have data that looks something like this

In my scenario, we offer multiple plans to customers. (planA, planB, planC etc.) planA is lower than planB and planB is lower than planC. A customer can move from lower plan to higher plan but not vice-versa. If a customer is on planA and wants to 'activate' planB, then planA must be cancelled. Essentially, a plan can be 'activated' and 'deactivated'. I had 2 designs in mind.

I have this input sheet here in which the data is inputed and from which I have to transfer some of the fields. This form should be completed every day and the date at the corner should be changed.

Also, I have these Database sheet for produced in reality and Database sheet for the setups of the machines and I am using the date as a key. However, I want to check first whether these dates are already in the Real production database in order to excluse duplicates before occuring. The logic is if there is already the same date, the user can choose whether to overwrite it or cease the process, and if there is no such date, to transfer the data on the next free row. The code for two of the three DB is below. How to change and finetune (probably the second loop) to have it not overwriting the whole DB with the last input value. Design improvements of the datebases would be also appreciated.

I'm trying to get the mean of each column while grouped by id, BUT for the calculation only the 50% between the first 25% quantil and the third 75% quantil should be used. (So ignore the lowest 25% of values and the highest 25%)

The data:

We are using AD deployed Daemon applications that have full read/write access to user's calendar in office 365 to get meeting notifications from Graph API. We have moved away from EWS because of constant issues and MS depreciating its use.

There does not currently seem to be a way of restricting the scope of Office 365 Calendar.ReadWrite permission from the organization level to a group/user.

Fortune 500 customers are worried that our application has access to all sensitive data inside their mailboxes and not ready to provide admin consent for Calendar.ReadWrite permission. I have explained all the security measures that are in plance such as use of certificates for application identity while registering service in AD, Admin consent requirement so that we can access calendars and get/set information and also communication is secure as it is from office 365 graph API hosted in Azure to our application which is also hosted in Azure.

As AD admins they can anytime decline consent to the application but clients think that it is too late in case there is a security incident.

Still, such organization is reluctant.

Is there any way to restrict the scope of the calendar.ReadWrite permission?

Can we audit MS Graph API calls for a specific user mailbox by using office 365 management API's?

Can we disable MS Graph API call for a specific user mailbox similar to the way EWS has EWSEnabled property on the mailbox?

Is there any policy that I can set under Security and Compliance admin section of office 365 to better control such applications from an exchange admin side?

Code42 decided to terminate their "CrashPlan for Home" service. This means that after the shutdown date of October 22, 2018, CrashPlan will delete your backup on their servers, which is to be expected, but much more annoyingly, you will no longer be able to restore CrashPlan backups that you stored locally. Effectively, Code42 is reaching into your computer to break your backups for you.

PlanC is an open source project to enable restore from existing CrashPlan Home backups to be performed.

However, when attempting to restore I received an error:

I have a following XML nodes in the table. But when I fetch the data I was not able to read it properly