Daily Required Run rate

DimaMD  No problem ...Achieved spends is spends column in acheived sheet and it corresponds to "spend" column in Planned sheet

DimaMD  sharing my dymmy data with you please check 

https://globalappsportal-my.sharepoint.com/:f:/g/personal/prajakta_keni_dentsu_com/Eqg95-48_1xLvywddqMSI2gBx8BHjFYxDLwB8mP8fmK0LA?e=pFmEMU

DimaMD Sharing dymmy data with you please check
https://globalappsportal-my.sharepoint.com/:f:/g/personal/prajakta_keni_dentsu_com/Eqg95-48_1xLvywddqMSI2gBx8BHjFYxDLwB8mP8fmK0LA?e=pFmEMU 

Anonymous Thank you for providing the file, but could you explain how you do the calculations, because I don't understand how the amounts are planned, how you calculate them

DimaMD  Yes ,
1.firstly I am getting acheived data Daily
2.and planned data Monthly,so first Query is to convert it to daily

Daily planned spends= monthly planned spends/no of days in month
(e.g. if my planned spends for oct 22 is 300000 so i want to show is daily 9677 (300000/no. of days in month).
3.once that is resolved i want to show daily required runrate formula for that is 
no of days left = end of the month day-current day
(if I select 11th of oct so no of days will be 20 i.e. 31st oct -11oct)
Daily runrate =(Daily planned spends-daily acheived spend)/no. of days left


Attatching an image for better understanding 

Hi, Anonymous Sorry for the delay, how do you calculate "Archive spend"? and which column corresponds to the amount in the "Planned Data" table?

DimaMD  Any luck on this ?

HI, Anonymous Currently, there are several ideas we are trying to implement.