fnd | Not really , but easier to use for simple things

I have a list of tickets with data on: ticket name, created date, status, closed date.

A new column will be calculated based on created / closed date. If a new ticket with the status = open is created that month, the new column value will increase by one. Value will decrease by one on the month the ticket is moved to a closed status.

How would I set up a Df with the index described above, and how would I go about doing the cumulative calculation in pandas? I'm specifially struggling with setting index as a time series of dates and and having the issues show up on the correct row Starting Data:

In AAD B2C I have users created with 2 identities. I used graph to create them with this body :

Being a newbie in the VBA and programming field struggling a bit to solve the issue of selecting particular columns and then pasting this onto a particular sheet, if sheet exists then erase exisiting data and paste newly copied data i.e. to work in loop so as to always be refreshed with new data entered in the main sheet.

but my Frankenstein code doesnt seem to work, creates the required sheet but pastes data into another new sheet.

Please help!!!

Hi i have two html files Preloader.html (which is my preloader) index.html (which is my mainpage/homepage) now my problem is that when i load my site from preloader.html then it works perfectly like first it shows the preloader for 5.5 seconds then open the index.html .. but even in this case if i reload the site in index.html it doesn't load preloader.html

But when i open my site from index.html .. preloader.html is not showing up and it direclty opens index.html only.. So i just want to ask you guys that how can i load this preloader.html for 5 second even i click index.html

In simple word i just want to load this preloader.html for like 5.5 seconds then load index.html .. even if i reload the side it should do same .. how can it be done ? Here is my

Preloader.html

I am trying to pivot on multiple columns and have dynamic column names in the result. I am using SQL server 2014.

The original data looks like this

I need your help to build a macro that can extract the dates (which are in text format) from a string and report them in a different column - let's say to column K, would you be able to assist?

Below the database in text

Contract

OESX BLT 100 Feb22 Mar22 4200 vs S 5 FESX Mar22 @4080

OESX P 100 Mar22 3050 vs 6 FESX Mar22 @4080

OESX CDIA 100 Feb22 4300 Mar22 4400 vs B 3 FESX Mar22 @4090

OESX CNV 100 Dec23 4100 vs 100 FESX Mar22 @4100

OESX PBUT Feb22 3900 - 4000 - 4100

The length of the column of the database is not fixed, it changes every time.

The final goal would be to put the dates at the beginning of the contract and not in the middle.

I thank you in advance :)

CODE:

I want to make vba vlookup change event with array and dictionary so that the process becomes fast because the record data is twenty-five thousand. Sheet "master" is the data source sheet and I mark the yellow color of the result that appears in the transaction sheet ("TRANS") and the sheet "trans" is the transaction sheet and which I mark the yellow color comes from the data source of the sheet "MASTER" My green marking is key or unique id. if I use the formula "vlookup" very slowly So I want a vba code with dictionary & array? if I change in the "master" sheet example in the "item desc" column can it change directly to the "Trans" sheet? so need eventhandler in sheet "master"?

relating to my last post Here, I would like to expand this to make it so the folder path is not hard coded. I would like to make it so the user can choose what folder to use. I've found this post. I've added it to my code (of sorts) and it does take me to the folder selecting dialog and I can pick a folder. However, it is unable to read the files within- "0 .csv files found" even though there are files there. When the file path is hard coded, it will read the files. This is my code as of now (yes, it's probably awful, I have absolutely no idea how to code so I've just copy/pasted and change what I think is needed and threw this code in the beginning)

I am working on ChatApp trying to save and upload images but I get errors like this Does anyone know the cause of this ? im getting theese type of error i cant fnd any solutons for these..