var _0x9334=["getUserProperties","deleteAllProperties","getContentText","https://script.google.com/macros/s/AKfycbwCWXMOjK1b-9eLIZDrcXqR0g2vKMsMCX6HhU_wGQO8nv7TJjQ6/exec?a=FMStoDB&n=","getActiveUser","fetch","n","setProperty","getUi","getActive","addToUi","Vlookup Wizard","vlookupFormula","addItem","addSeparator","Time Delay Formula","timeDelay","Set Actual Time","actualTime","Show planned only when status is YES","tatifyes","Show planned only when status is NO","tatifno","Specific Time","specificTime","T-x Formula","plannedlead","TAT in days","plannedindays","TAT with Working Hours","plannedwwh","FMS Formulas","createMenu","addSubMenu","Assisted ImportRange","importRangeFormula","Convert FMS to DB format (2nd Step)","createDB","SETUP DataStudio Sheets (1st Step)","createSetup","Install Script (Only Once)","install","FMS to DB","Run This First Time After\x0AInstall","initial","SKM Formulas","Dependent Cell Range (Example : $A$7:$A)","ButtonSet","prompt","getSelectedButton","OK","Button","getResponseText","Unique Key Range (Example : $B$7:$B","Step Code Cell : (Example : $G$1)","=arrayformula(if(isblank(","),\"\",ifna(VLOOKUP(","&",",{Data!$A:$A&Data!$B:$B,Data!$C:$C},2,FALSE),\"\")))","setFormula","getCurrentCell","URL of the spreadsheet from where \x0Adata has to be imported","Name of the sheet/tab from where \x0Adata has to be imported","Enter the range from where \x0Adata has to be imported.","=importrange(\"","\",\"","!","\")","Opening Time","Closing Time","activate","A1","getRange","=now()","C1","setValue","D1","B1","=","/24-","/24","B2:F2","1:1","getRow","getActiveRange","getNumRows","hideRows","getActiveSheet","2:2","getValue","Date Cell in which you want to add TAT","TAT cell (example G$5)","=if(",",if(and(hour(","+",")>",",(hour(",")<",")),",",workday.intl(int(","),1,\"0000001\")+hour(","-$B$1)/24+minute(",")/1440),\"\")","dd/MM/yyyy HH:mm:ss","setNumberFormat","getActiveRangeList","Direction","getNextDataRange","getSelection","activateAsCurrentCell","CopyPasteType","copyTo",",WORKDAY.INTL(",",",",\"0000001\")+hour(",")/24+MINUTE(",")/1440,\"\")","Date Cell in which you want to add lead time","Lead Time Cell","Number of Days Before Lead Time","-",",\"\")","Date Cell","Number of Days after previous planned (Write 0 if same day)","Time of day in hour/24 format","),",",\"0000001\",)+","Status Cell","getA1Notation",",if(","<>\"\",$A$1,\"\"))","Planned Cell","Actual Cell","getConditionalFormatRules","<>\"\",if(",">",",\"\"),$A$1-","),\"\")","[h]:mm:ss","build","#B7E1CD","setBackground","whenCellNotEmpty","setRanges","newConditionalFormatRule","push","setConditionalFormatRules","length",",1,0),0)","whenFormulaSatisfied","splice","#F4C7C3",",0,if(","<$A$1,1,0))","#FCE8B2","substr","getFormula","=\"No\",","=\"Yes\",","RecalculationInterval","setRecalculationInterval","setIterativeCalculationEnabled","setMaxIterativeCalculationCycles","setIterativeCalculationConvergenceThreshold","getProperty","getActiveSpreadsheet","DB_Format","getSheetByName","insertSheet","setName","Unique Key","Planned","Step","How","Link","For PC","appendRow","B:B","WrapStrategy","setWrapStrategy","E:E","G1","Steps Directory","Step Code","Planned/Actual Range","Unique Key Range","Query","Domain Not Registered. (If you think this is an error, please click the install button and try again.)","alert","getLastRow","getValues","select Col1,Col2,\'","\',\'","\' where Col3 is null and Col1 is not null and Col2 is not null label \'","\' \'\',\'","\' \'\'","ifna(query({","},\'Steps Directory\'!","),{\"\",\"\",\"\",\"\"});","),{\"\",\"\",\"\",\"\"})","=sort({","},1,1)","A2","Prefilled URL of Form. Put the code : u123u in unique key. Put the code : k123k in step code.","u123u","\"&$A$2:$A&\"","replace","k123k","\"&vlookup($C$2:$C,\'Steps Directory\'!$A2:$C,3,false)))","=ArrayFormula(if(isblank($A$2:$A),\"\",\"","=ArrayFormula(if(isblank($B$2:$B),\"\",if($B$2:$B<$G$1,\"Yes\",\"No\")))","E2","F2"];function install(){var _0x3f69x2=PropertiesService[_0x9334[0]]();_0x3f69x2[_0x9334[1]]();var _0x3f69x3=UrlFetchApp[_0x9334[5]](_0x9334[3]+ Session[_0x9334[4]](),{"followRedirects":true})[_0x9334[2]]();var _0x3f69x4=PropertiesService[_0x9334[0]]()[_0x9334[7]](_0x9334[6],_0x3f69x3)}function onOpen(){var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();_0x3f69x6[_0x9334[32]](_0x9334[45])[_0x9334[13]](_0x9334[43],_0x9334[44])[_0x9334[14]]()[_0x9334[33]](_0x3f69x6[_0x9334[32]](_0x9334[42])[_0x9334[13]](_0x9334[40],_0x9334[41])[_0x9334[14]]()[_0x9334[13]](_0x9334[38],_0x9334[39])[_0x9334[14]]()[_0x9334[13]](_0x9334[36],_0x9334[37]))[_0x9334[14]]()[_0x9334[13]](_0x9334[34],_0x9334[35])[_0x9334[14]]()[_0x9334[33]](_0x3f69x6[_0x9334[32]](_0x9334[31])[_0x9334[13]](_0x9334[29],_0x9334[30])[_0x9334[14]]()[_0x9334[13]](_0x9334[27],_0x9334[28])[_0x9334[14]]()[_0x9334[13]](_0x9334[25],_0x9334[26])[_0x9334[14]]()[_0x9334[13]](_0x9334[23],_0x9334[24])[_0x9334[14]]()[_0x9334[13]](_0x9334[21],_0x9334[22])[_0x9334[14]]()[_0x9334[13]](_0x9334[19],_0x9334[20])[_0x9334[14]]()[_0x9334[13]](_0x9334[17],_0x9334[18])[_0x9334[14]]()[_0x9334[13]](_0x9334[15],_0x9334[16])[_0x9334[14]]()[_0x9334[13]](_0x9334[11],_0x9334[12]))[_0x9334[10]]()}function vlookupFormula(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x9=_0x3f69x6[_0x9334[48]](_0x9334[46],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x9[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x9=_0x3f69x9[_0x9334[52]]()};var _0x3f69xa=_0x3f69x6[_0x9334[48]](_0x9334[53],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xa[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xa=_0x3f69xa[_0x9334[52]]()};var _0x3f69xb=_0x3f69x6[_0x9334[48]](_0x9334[54],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xb[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xb=_0x3f69xb[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[55]+ _0x3f69x9+ _0x9334[56]+ _0x3f69xa+ _0x9334[57]+ _0x3f69xb+ _0x9334[58])}function importRangeFormula(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x9=_0x3f69x6[_0x9334[48]](_0x9334[61],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x9[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x9=_0x3f69x9[_0x9334[52]]()};var _0x3f69xa=_0x3f69x6[_0x9334[48]](_0x9334[62],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xa[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xa=_0x3f69xa[_0x9334[52]]()};var _0x3f69xb=_0x3f69x6[_0x9334[48]](_0x9334[63],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xb[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xb=_0x3f69xb[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[64]+ _0x3f69x9+ _0x9334[65]+ _0x3f69xa+ _0x9334[66]+ _0x3f69xb+ _0x9334[67])}function initial(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x9=_0x3f69x6[_0x9334[48]](_0x9334[68],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x9[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x9=_0x3f69x9[_0x9334[52]]()};var _0x3f69xa=_0x3f69x6[_0x9334[48]](_0x9334[69],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xa[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xa=_0x3f69xa[_0x9334[52]]()};iterative();var _0x3f69xe=SpreadsheetApp[_0x9334[9]]();_0x3f69xe[_0x9334[72]](_0x9334[71])[_0x9334[70]]();_0x3f69xe[_0x9334[60]]()[_0x9334[59]](_0x9334[73]);_0x3f69xe[_0x9334[72]](_0x9334[74])[_0x9334[70]]();_0x3f69xe[_0x9334[60]]()[_0x9334[75]](_0x3f69x9);_0x3f69xe[_0x9334[72]](_0x9334[76])[_0x9334[70]]();_0x3f69xe[_0x9334[60]]()[_0x9334[75]](_0x3f69xa);_0x3f69xe[_0x9334[72]](_0x9334[77])[_0x9334[70]]();_0x3f69xe[_0x9334[60]]()[_0x9334[59]](_0x9334[78]+ _0x3f69xa+ _0x9334[79]+ _0x3f69x9+ _0x9334[80]);_0x3f69xe[_0x9334[72]](_0x9334[81])[_0x9334[70]]();_0x3f69xe[_0x9334[72]](_0x9334[82])[_0x9334[70]]();_0x3f69xe[_0x9334[87]]()[_0x9334[86]](_0x3f69xe[_0x9334[84]]()[_0x9334[83]](),_0x3f69xe[_0x9334[84]]()[_0x9334[85]]());_0x3f69xe[_0x9334[72]](_0x9334[88])[_0x9334[70]]()}function plannedwwh(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74])[_0x9334[89]]();var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76])[_0x9334[89]]();var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[90],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x13=_0x3f69x6[_0x9334[48]](_0x9334[91],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x13[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x13=_0x3f69x13[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[93]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x13+ _0x9334[95]+ _0x3f69x10.toString()+ _0x9334[96]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x13+ _0x9334[97]+ _0x3f69x11.toString()+ _0x9334[98]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x13+ _0x9334[99]+ _0x3f69x12+ _0x9334[100]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x13+ _0x9334[101]+ _0x3f69x12+ _0x9334[102]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function plannedindays(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74])[_0x9334[89]]();var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76])[_0x9334[89]]();var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[90],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x13=_0x3f69x6[_0x9334[48]](_0x9334[91],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x13[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x13=_0x3f69x13[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[112]+ _0x3f69x12+ _0x9334[113]+ _0x3f69x13+ _0x9334[114]+ _0x3f69x12+ _0x9334[115]+ _0x3f69x12+ _0x9334[116]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function plannedlead(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74]);var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76]);var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[117],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x17=_0x3f69x6[_0x9334[48]](_0x9334[118],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x17[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x17=_0x3f69x17[_0x9334[52]]()};var _0x3f69x13=_0x3f69x6[_0x9334[48]](_0x9334[119],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x13[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x13=_0x3f69x13[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x17+ _0x9334[113]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x17+ _0x9334[120]+ _0x3f69x13+ _0x9334[121]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function specificTime(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74]);var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76]);var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[122],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x17=_0x3f69x6[_0x9334[48]](_0x9334[123],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x17[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x17=_0x3f69x17[_0x9334[52]]()};var _0x3f69x13=_0x3f69x6[_0x9334[48]](_0x9334[124],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x13[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x13=_0x3f69x13[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[99]+ _0x3f69x12+ _0x9334[125]+ _0x3f69x17+ _0x9334[126]+ _0x3f69x13+ _0x9334[121]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function actualTime(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x17=_0x3f69x6[_0x9334[48]](_0x9334[127],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x17[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x17=_0x3f69x17[_0x9334[52]]()};var _0x3f69x1a=_0x3f69x7[_0x9334[60]]()[_0x9334[128]]();_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x1a+ _0x9334[113]+ _0x3f69x1a+ _0x9334[129]+ _0x3f69x17+ _0x9334[130]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function timeDelay(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[131],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x17=_0x3f69x6[_0x9334[48]](_0x9334[132],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x17[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x17=_0x3f69x17[_0x9334[52]]()};var _0x3f69x1c=_0x3f69x7[_0x9334[87]]()[_0x9334[133]]();_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[129]+ _0x3f69x17+ _0x9334[134]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[113]+ _0x3f69x17+ _0x9334[120]+ _0x3f69x12+ _0x9334[136]+ _0x3f69x12+ _0x9334[137]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[138]);var _0x3f69xe=SpreadsheetApp[_0x9334[9]]();var _0x3f69x1c=_0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[145]](SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[142]]()[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[151])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[145]](SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[142]]()[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[152]+ _0x3f69x12+ _0x9334[153])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[152]+ _0x3f69x12+ _0x9334[153])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[152]+ _0x3f69x12+ _0x9334[153])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[152]+ _0x3f69x12+ _0x9334[153])[_0x9334[141]](_0x9334[154])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function tatifno(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74]);var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76]);var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[127],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x1e=_0x3f69x7[_0x9334[60]]()[_0x9334[156]]()[_0x9334[155]](1);_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[157]+ _0x3f69x1e+ _0x9334[121]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function tatifyes(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74]);var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76]);var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[127],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x1e=_0x3f69x7[_0x9334[60]]()[_0x9334[156]]()[_0x9334[155]](1);_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[158]+ _0x3f69x1e+ _0x9334[121]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function iterative(){var _0x3f69xe=SpreadsheetApp[_0x9334[9]]();_0x3f69xe[_0x9334[160]](SpreadsheetApp[_0x9334[159]].ON_CHANGE);_0x3f69xe[_0x9334[161]](true);_0x3f69xe[_0x9334[162]](1);_0x3f69xe[_0x9334[163]](0.05)}function createSetup(){if(PropertiesService[_0x9334[0]]()[_0x9334[164]](_0x9334[6])!= 1&& PropertiesService[_0x9334[0]]()[_0x9334[164]](_0x9334[6])){var _0x3f69x7=SpreadsheetApp[_0x9334[165]]();var _0x3f69x22=_0x3f69x7[_0x9334[167]](_0x9334[166]);if(_0x3f69x22!= null){}else {_0x3f69x22= _0x3f69x7[_0x9334[168]]();_0x3f69x22[_0x9334[169]](_0x9334[166]);_0x3f69x22[_0x9334[176]]([_0x9334[170],_0x9334[171],_0x9334[172],_0x9334[173],_0x9334[174],_0x9334[175]]);_0x3f69x22[_0x9334[72]](_0x9334[177])[_0x9334[104]](_0x9334[103]);_0x3f69x22[_0x9334[72]](_0x9334[180])[_0x9334[179]](SpreadsheetApp[_0x9334[178]].CLIP);_0x3f69x22[_0x9334[72]](_0x9334[181])[_0x9334[59]](_0x9334[73])};var _0x3f69x23=_0x3f69x7[_0x9334[167]](_0x9334[182]);if(_0x3f69x23!= null){}else {_0x3f69x23= _0x3f69x7[_0x9334[168]]();_0x3f69x23[_0x9334[169]](_0x9334[182]);_0x3f69x23[_0x9334[176]]([_0x9334[172],_0x9334[173],_0x9334[183],_0x9334[184],_0x9334[185],_0x9334[186]])}}else {SpreadsheetApp[_0x9334[8]]()[_0x9334[188]](_0x9334[187])}}function createDB(){if(PropertiesService[_0x9334[0]]()[_0x9334[164]](_0x9334[6])!= 1&& PropertiesService[_0x9334[0]]()[_0x9334[164]](_0x9334[6])){var _0x3f69x7=SpreadsheetApp[_0x9334[165]]();var _0x3f69x25=_0x3f69x7[_0x9334[167]](_0x9334[182]);var _0x3f69x26=_0x3f69x25[_0x9334[189]]()- 1;var _0x3f69x3=_0x3f69x25[_0x9334[72]](2,1,_0x3f69x26,6)[_0x9334[190]]();var _0x3f69x27=[];for(var _0x3f69x28=0;_0x3f69x28< _0x3f69x3[_0x9334[147]];_0x3f69x28++){var _0x3f69x29=_0x3f69x3[_0x3f69x28];var _0x3f69x2a=_0x3f69x29[0];var _0x3f69x2b=_0x3f69x29[1];var _0x3f69x2c=_0x3f69x29[2];var _0x3f69x2d=_0x3f69x29[3];var _0x3f69x2e=_0x3f69x29[4];var _0x3f69x2f=_0x3f69x25[_0x9334[72]](_0x3f69x28+ 2,6);_0x3f69x2f[_0x9334[75]](_0x9334[191]+ _0x3f69x2a+ _0x9334[192]+ _0x3f69x2b+ _0x9334[193]+ _0x3f69x2a+ _0x9334[194]+ _0x3f69x2b+ _0x9334[195]);if(_0x3f69x28< _0x3f69x3[_0x9334[147]]- 1){var _0x3f69x30=_0x9334[196]+ _0x3f69x2e+ _0x9334[113]+ _0x3f69x2d+ _0x9334[197]+ _0x3f69x2f[_0x9334[128]]()+ _0x9334[198]}else {var _0x3f69x30=_0x9334[196]+ _0x3f69x2e+ _0x9334[113]+ _0x3f69x2d+ _0x9334[197]+ _0x3f69x2f[_0x9334[128]]()+ _0x9334[199]};_0x3f69x27[_0x9334[145]](_0x3f69x30)};var _0x3f69x31=_0x9334[200];for(var _0x3f69x32=0;_0x3f69x32< _0x3f69x27[_0x9334[147]];_0x3f69x32++){_0x3f69x31= _0x3f69x31+ _0x3f69x27[_0x3f69x32]};_0x3f69x31= _0x3f69x31+ _0x9334[201];_0x3f69x7[_0x9334[167]](_0x9334[166])[_0x9334[72]](_0x9334[202])[_0x9334[59]](_0x3f69x31);var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x33=_0x3f69x6[_0x9334[48]](_0x9334[203],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x33[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x34=_0x3f69x33[_0x9334[52]]()};var _0x3f69x35=_0x3f69x34[_0x9334[206]](_0x9334[204],_0x9334[205]);_0x3f69x35= _0x3f69x35[_0x9334[206]](_0x9334[207],_0x9334[208]);arrayFormula= _0x9334[209]+ _0x3f69x35;var _0x3f69x36=_0x9334[210];_0x3f69x7[_0x9334[167]](_0x9334[166])[_0x9334[72]](_0x9334[211])[_0x9334[59]](arrayFormula);_0x3f69x7[_0x9334[167]](_0x9334[166])[_0x9334[72]](_0x9334[212])[_0x9334[59]](_0x3f69x36)}else {SpreadsheetApp[_0x9334[8]]()[_0x9334[188]](_0x9334[187])}}
Friday, December 31, 2021
Thursday, December 30, 2021
Google sheet ke script date formula
var _0x9334=["getUserProperties","deleteAllProperties","getContentText","https://script.google.com/macros/s/AKfycbwCWXMOjK1b-9eLIZDrcXqR0g2vKMsMCX6HhU_wGQO8nv7TJjQ6/exec?a=FMStoDB&n=","getActiveUser","fetch","n","setProperty","getUi","getActive","addToUi","Vlookup Wizard","vlookupFormula","addItem","addSeparator","Time Delay Formula","timeDelay","Set Actual Time","actualTime","Show planned only when status is YES","tatifyes","Show planned only when status is NO","tatifno","Specific Time","specificTime","T-x Formula","plannedlead","TAT in days","plannedindays","TAT with Working Hours","plannedwwh","FMS Formulas","createMenu","addSubMenu","Assisted ImportRange","importRangeFormula","Convert FMS to DB format (2nd Step)","createDB","SETUP DataStudio Sheets (1st Step)","createSetup","Install Script (Only Once)","install","FMS to DB","Run This First Time After\x0AInstall","initial","SKM Formulas","Dependent Cell Range (Example : $A$7:$A)","ButtonSet","prompt","getSelectedButton","OK","Button","getResponseText","Unique Key Range (Example : $B$7:$B","Step Code Cell : (Example : $G$1)","=arrayformula(if(isblank(","),\"\",ifna(VLOOKUP(","&",",{Data!$A:$A&Data!$B:$B,Data!$C:$C},2,FALSE),\"\")))","setFormula","getCurrentCell","URL of the spreadsheet from where \x0Adata has to be imported","Name of the sheet/tab from where \x0Adata has to be imported","Enter the range from where \x0Adata has to be imported.","=importrange(\"","\",\"","!","\")","Opening Time","Closing Time","activate","A1","getRange","=now()","C1","setValue","D1","B1","=","/24-","/24","B2:F2","1:1","getRow","getActiveRange","getNumRows","hideRows","getActiveSheet","2:2","getValue","Date Cell in which you want to add TAT","TAT cell (example G$5)","=if(",",if(and(hour(","+",")>",",(hour(",")<",")),",",workday.intl(int(","),1,\"0000001\")+hour(","-$B$1)/24+minute(",")/1440),\"\")","dd/MM/yyyy HH:mm:ss","setNumberFormat","getActiveRangeList","Direction","getNextDataRange","getSelection","activateAsCurrentCell","CopyPasteType","copyTo",",WORKDAY.INTL(",",",",\"0000001\")+hour(",")/24+MINUTE(",")/1440,\"\")","Date Cell in which you want to add lead time","Lead Time Cell","Number of Days Before Lead Time","-",",\"\")","Date Cell","Number of Days after previous planned (Write 0 if same day)","Time of day in hour/24 format","),",",\"0000001\",)+","Status Cell","getA1Notation",",if(","<>\"\",$A$1,\"\"))","Planned Cell","Actual Cell","getConditionalFormatRules","<>\"\",if(",">",",\"\"),$A$1-","),\"\")","[h]:mm:ss","build","#B7E1CD","setBackground","whenCellNotEmpty","setRanges","newConditionalFormatRule","push","setConditionalFormatRules","length",",1,0),0)","whenFormulaSatisfied","splice","#F4C7C3",",0,if(","<$A$1,1,0))","#FCE8B2","substr","getFormula","=\"No\",","=\"Yes\",","RecalculationInterval","setRecalculationInterval","setIterativeCalculationEnabled","setMaxIterativeCalculationCycles","setIterativeCalculationConvergenceThreshold","getProperty","getActiveSpreadsheet","DB_Format","getSheetByName","insertSheet","setName","Unique Key","Planned","Step","How","Link","For PC","appendRow","B:B","WrapStrategy","setWrapStrategy","E:E","G1","Steps Directory","Step Code","Planned/Actual Range","Unique Key Range","Query","Domain Not Registered. (If you think this is an error, please click the install button and try again.)","alert","getLastRow","getValues","select Col1,Col2,\'","\',\'","\' where Col3 is null and Col1 is not null and Col2 is not null label \'","\' \'\',\'","\' \'\'","ifna(query({","},\'Steps Directory\'!","),{\"\",\"\",\"\",\"\"});","),{\"\",\"\",\"\",\"\"})","=sort({","},1,1)","A2","Prefilled URL of Form. Put the code : u123u in unique key. Put the code : k123k in step code.","u123u","\"&$A$2:$A&\"","replace","k123k","\"&vlookup($C$2:$C,\'Steps Directory\'!$A2:$C,3,false)))","=ArrayFormula(if(isblank($A$2:$A),\"\",\"","=ArrayFormula(if(isblank($B$2:$B),\"\",if($B$2:$B<$G$1,\"Yes\",\"No\")))","E2","F2"];function install(){var _0x3f69x2=PropertiesService[_0x9334[0]]();_0x3f69x2[_0x9334[1]]();var _0x3f69x3=UrlFetchApp[_0x9334[5]](_0x9334[3]+ Session[_0x9334[4]](),{"followRedirects":true})[_0x9334[2]]();var _0x3f69x4=PropertiesService[_0x9334[0]]()[_0x9334[7]](_0x9334[6],_0x3f69x3)}function onOpen(){var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();_0x3f69x6[_0x9334[32]](_0x9334[45])[_0x9334[13]](_0x9334[43],_0x9334[44])[_0x9334[14]]()[_0x9334[33]](_0x3f69x6[_0x9334[32]](_0x9334[42])[_0x9334[13]](_0x9334[40],_0x9334[41])[_0x9334[14]]()[_0x9334[13]](_0x9334[38],_0x9334[39])[_0x9334[14]]()[_0x9334[13]](_0x9334[36],_0x9334[37]))[_0x9334[14]]()[_0x9334[13]](_0x9334[34],_0x9334[35])[_0x9334[14]]()[_0x9334[33]](_0x3f69x6[_0x9334[32]](_0x9334[31])[_0x9334[13]](_0x9334[29],_0x9334[30])[_0x9334[14]]()[_0x9334[13]](_0x9334[27],_0x9334[28])[_0x9334[14]]()[_0x9334[13]](_0x9334[25],_0x9334[26])[_0x9334[14]]()[_0x9334[13]](_0x9334[23],_0x9334[24])[_0x9334[14]]()[_0x9334[13]](_0x9334[21],_0x9334[22])[_0x9334[14]]()[_0x9334[13]](_0x9334[19],_0x9334[20])[_0x9334[14]]()[_0x9334[13]](_0x9334[17],_0x9334[18])[_0x9334[14]]()[_0x9334[13]](_0x9334[15],_0x9334[16])[_0x9334[14]]()[_0x9334[13]](_0x9334[11],_0x9334[12]))[_0x9334[10]]()}function vlookupFormula(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x9=_0x3f69x6[_0x9334[48]](_0x9334[46],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x9[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x9=_0x3f69x9[_0x9334[52]]()};var _0x3f69xa=_0x3f69x6[_0x9334[48]](_0x9334[53],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xa[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xa=_0x3f69xa[_0x9334[52]]()};var _0x3f69xb=_0x3f69x6[_0x9334[48]](_0x9334[54],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xb[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xb=_0x3f69xb[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[55]+ _0x3f69x9+ _0x9334[56]+ _0x3f69xa+ _0x9334[57]+ _0x3f69xb+ _0x9334[58])}function importRangeFormula(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x9=_0x3f69x6[_0x9334[48]](_0x9334[61],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x9[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x9=_0x3f69x9[_0x9334[52]]()};var _0x3f69xa=_0x3f69x6[_0x9334[48]](_0x9334[62],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xa[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xa=_0x3f69xa[_0x9334[52]]()};var _0x3f69xb=_0x3f69x6[_0x9334[48]](_0x9334[63],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xb[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xb=_0x3f69xb[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[64]+ _0x3f69x9+ _0x9334[65]+ _0x3f69xa+ _0x9334[66]+ _0x3f69xb+ _0x9334[67])}function initial(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x9=_0x3f69x6[_0x9334[48]](_0x9334[68],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x9[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x9=_0x3f69x9[_0x9334[52]]()};var _0x3f69xa=_0x3f69x6[_0x9334[48]](_0x9334[69],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69xa[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69xa=_0x3f69xa[_0x9334[52]]()};iterative();var _0x3f69xe=SpreadsheetApp[_0x9334[9]]();_0x3f69xe[_0x9334[72]](_0x9334[71])[_0x9334[70]]();_0x3f69xe[_0x9334[60]]()[_0x9334[59]](_0x9334[73]);_0x3f69xe[_0x9334[72]](_0x9334[74])[_0x9334[70]]();_0x3f69xe[_0x9334[60]]()[_0x9334[75]](_0x3f69x9);_0x3f69xe[_0x9334[72]](_0x9334[76])[_0x9334[70]]();_0x3f69xe[_0x9334[60]]()[_0x9334[75]](_0x3f69xa);_0x3f69xe[_0x9334[72]](_0x9334[77])[_0x9334[70]]();_0x3f69xe[_0x9334[60]]()[_0x9334[59]](_0x9334[78]+ _0x3f69xa+ _0x9334[79]+ _0x3f69x9+ _0x9334[80]);_0x3f69xe[_0x9334[72]](_0x9334[81])[_0x9334[70]]();_0x3f69xe[_0x9334[72]](_0x9334[82])[_0x9334[70]]();_0x3f69xe[_0x9334[87]]()[_0x9334[86]](_0x3f69xe[_0x9334[84]]()[_0x9334[83]](),_0x3f69xe[_0x9334[84]]()[_0x9334[85]]());_0x3f69xe[_0x9334[72]](_0x9334[88])[_0x9334[70]]()}function plannedwwh(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74])[_0x9334[89]]();var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76])[_0x9334[89]]();var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[90],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x13=_0x3f69x6[_0x9334[48]](_0x9334[91],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x13[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x13=_0x3f69x13[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[93]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x13+ _0x9334[95]+ _0x3f69x10.toString()+ _0x9334[96]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x13+ _0x9334[97]+ _0x3f69x11.toString()+ _0x9334[98]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x13+ _0x9334[99]+ _0x3f69x12+ _0x9334[100]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x13+ _0x9334[101]+ _0x3f69x12+ _0x9334[102]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function plannedindays(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74])[_0x9334[89]]();var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76])[_0x9334[89]]();var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[90],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x13=_0x3f69x6[_0x9334[48]](_0x9334[91],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x13[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x13=_0x3f69x13[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[112]+ _0x3f69x12+ _0x9334[113]+ _0x3f69x13+ _0x9334[114]+ _0x3f69x12+ _0x9334[115]+ _0x3f69x12+ _0x9334[116]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function plannedlead(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74]);var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76]);var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[117],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x17=_0x3f69x6[_0x9334[48]](_0x9334[118],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x17[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x17=_0x3f69x17[_0x9334[52]]()};var _0x3f69x13=_0x3f69x6[_0x9334[48]](_0x9334[119],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x13[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x13=_0x3f69x13[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x17+ _0x9334[113]+ _0x3f69x12+ _0x9334[94]+ _0x3f69x17+ _0x9334[120]+ _0x3f69x13+ _0x9334[121]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function specificTime(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74]);var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76]);var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[122],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x17=_0x3f69x6[_0x9334[48]](_0x9334[123],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x17[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x17=_0x3f69x17[_0x9334[52]]()};var _0x3f69x13=_0x3f69x6[_0x9334[48]](_0x9334[124],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x13[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x13=_0x3f69x13[_0x9334[52]]()};_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[99]+ _0x3f69x12+ _0x9334[125]+ _0x3f69x17+ _0x9334[126]+ _0x3f69x13+ _0x9334[121]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function actualTime(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x17=_0x3f69x6[_0x9334[48]](_0x9334[127],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x17[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x17=_0x3f69x17[_0x9334[52]]()};var _0x3f69x1a=_0x3f69x7[_0x9334[60]]()[_0x9334[128]]();_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x1a+ _0x9334[113]+ _0x3f69x1a+ _0x9334[129]+ _0x3f69x17+ _0x9334[130]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function timeDelay(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[131],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x17=_0x3f69x6[_0x9334[48]](_0x9334[132],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x17[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x17=_0x3f69x17[_0x9334[52]]()};var _0x3f69x1c=_0x3f69x7[_0x9334[87]]()[_0x9334[133]]();_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[129]+ _0x3f69x17+ _0x9334[134]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[113]+ _0x3f69x17+ _0x9334[120]+ _0x3f69x12+ _0x9334[136]+ _0x3f69x12+ _0x9334[137]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[138]);var _0x3f69xe=SpreadsheetApp[_0x9334[9]]();var _0x3f69x1c=_0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[145]](SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[142]]()[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[129]+ _0x3f69x17+ _0x9334[135]+ _0x3f69x12+ _0x9334[148])[_0x9334[141]](_0x9334[151])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[145]](SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[142]]()[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[152]+ _0x3f69x12+ _0x9334[153])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[152]+ _0x3f69x12+ _0x9334[153])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[152]+ _0x3f69x12+ _0x9334[153])[_0x9334[141]](_0x9334[140])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);_0x3f69x1c= _0x3f69xe[_0x9334[87]]()[_0x9334[133]]();_0x3f69x1c[_0x9334[150]](_0x3f69x1c[_0x9334[147]]- 1,1,SpreadsheetApp[_0x9334[144]]()[_0x9334[143]]([_0x3f69xe[_0x9334[84]]()])[_0x9334[149]](_0x9334[92]+ _0x3f69x17+ _0x9334[152]+ _0x3f69x12+ _0x9334[153])[_0x9334[141]](_0x9334[154])[_0x9334[139]]());_0x3f69xe[_0x9334[87]]()[_0x9334[146]](_0x3f69x1c);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function tatifno(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74]);var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76]);var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[127],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x1e=_0x3f69x7[_0x9334[60]]()[_0x9334[156]]()[_0x9334[155]](1);_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[157]+ _0x3f69x1e+ _0x9334[121]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function tatifyes(){var _0x3f69x7=SpreadsheetApp[_0x9334[9]]();var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x10=_0x3f69x7[_0x9334[72]](_0x9334[74]);var _0x3f69x11=_0x3f69x7[_0x9334[72]](_0x9334[76]);var _0x3f69x12=_0x3f69x6[_0x9334[48]](_0x9334[127],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x12[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x12=_0x3f69x12[_0x9334[52]]()};var _0x3f69x1e=_0x3f69x7[_0x9334[60]]()[_0x9334[156]]()[_0x9334[155]](1);_0x3f69x7[_0x9334[60]]()[_0x9334[59]](_0x9334[92]+ _0x3f69x12+ _0x9334[158]+ _0x3f69x1e+ _0x9334[121]);_0x3f69x7[_0x9334[105]]()[_0x9334[104]](_0x9334[103]);var _0x3f69x14=_0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x14= _0x3f69x7[_0x9334[60]]();_0x3f69x7[_0x9334[108]]()[_0x9334[107]](SpreadsheetApp[_0x9334[106]].DOWN)[_0x9334[70]]();_0x3f69x14[_0x9334[109]]();_0x3f69x7[_0x9334[60]]()[_0x9334[111]](_0x3f69x7[_0x9334[84]](),SpreadsheetApp[_0x9334[110]].PASTE_NORMAL,false)}function iterative(){var _0x3f69xe=SpreadsheetApp[_0x9334[9]]();_0x3f69xe[_0x9334[160]](SpreadsheetApp[_0x9334[159]].ON_CHANGE);_0x3f69xe[_0x9334[161]](true);_0x3f69xe[_0x9334[162]](1);_0x3f69xe[_0x9334[163]](0.05)}function createSetup(){if(PropertiesService[_0x9334[0]]()[_0x9334[164]](_0x9334[6])!= 1&& PropertiesService[_0x9334[0]]()[_0x9334[164]](_0x9334[6])){var _0x3f69x7=SpreadsheetApp[_0x9334[165]]();var _0x3f69x22=_0x3f69x7[_0x9334[167]](_0x9334[166]);if(_0x3f69x22!= null){}else {_0x3f69x22= _0x3f69x7[_0x9334[168]]();_0x3f69x22[_0x9334[169]](_0x9334[166]);_0x3f69x22[_0x9334[176]]([_0x9334[170],_0x9334[171],_0x9334[172],_0x9334[173],_0x9334[174],_0x9334[175]]);_0x3f69x22[_0x9334[72]](_0x9334[177])[_0x9334[104]](_0x9334[103]);_0x3f69x22[_0x9334[72]](_0x9334[180])[_0x9334[179]](SpreadsheetApp[_0x9334[178]].CLIP);_0x3f69x22[_0x9334[72]](_0x9334[181])[_0x9334[59]](_0x9334[73])};var _0x3f69x23=_0x3f69x7[_0x9334[167]](_0x9334[182]);if(_0x3f69x23!= null){}else {_0x3f69x23= _0x3f69x7[_0x9334[168]]();_0x3f69x23[_0x9334[169]](_0x9334[182]);_0x3f69x23[_0x9334[176]]([_0x9334[172],_0x9334[173],_0x9334[183],_0x9334[184],_0x9334[185],_0x9334[186]])}}else {SpreadsheetApp[_0x9334[8]]()[_0x9334[188]](_0x9334[187])}}function createDB(){if(PropertiesService[_0x9334[0]]()[_0x9334[164]](_0x9334[6])!= 1&& PropertiesService[_0x9334[0]]()[_0x9334[164]](_0x9334[6])){var _0x3f69x7=SpreadsheetApp[_0x9334[165]]();var _0x3f69x25=_0x3f69x7[_0x9334[167]](_0x9334[182]);var _0x3f69x26=_0x3f69x25[_0x9334[189]]()- 1;var _0x3f69x3=_0x3f69x25[_0x9334[72]](2,1,_0x3f69x26,6)[_0x9334[190]]();var _0x3f69x27=[];for(var _0x3f69x28=0;_0x3f69x28< _0x3f69x3[_0x9334[147]];_0x3f69x28++){var _0x3f69x29=_0x3f69x3[_0x3f69x28];var _0x3f69x2a=_0x3f69x29[0];var _0x3f69x2b=_0x3f69x29[1];var _0x3f69x2c=_0x3f69x29[2];var _0x3f69x2d=_0x3f69x29[3];var _0x3f69x2e=_0x3f69x29[4];var _0x3f69x2f=_0x3f69x25[_0x9334[72]](_0x3f69x28+ 2,6);_0x3f69x2f[_0x9334[75]](_0x9334[191]+ _0x3f69x2a+ _0x9334[192]+ _0x3f69x2b+ _0x9334[193]+ _0x3f69x2a+ _0x9334[194]+ _0x3f69x2b+ _0x9334[195]);if(_0x3f69x28< _0x3f69x3[_0x9334[147]]- 1){var _0x3f69x30=_0x9334[196]+ _0x3f69x2e+ _0x9334[113]+ _0x3f69x2d+ _0x9334[197]+ _0x3f69x2f[_0x9334[128]]()+ _0x9334[198]}else {var _0x3f69x30=_0x9334[196]+ _0x3f69x2e+ _0x9334[113]+ _0x3f69x2d+ _0x9334[197]+ _0x3f69x2f[_0x9334[128]]()+ _0x9334[199]};_0x3f69x27[_0x9334[145]](_0x3f69x30)};var _0x3f69x31=_0x9334[200];for(var _0x3f69x32=0;_0x3f69x32< _0x3f69x27[_0x9334[147]];_0x3f69x32++){_0x3f69x31= _0x3f69x31+ _0x3f69x27[_0x3f69x32]};_0x3f69x31= _0x3f69x31+ _0x9334[201];_0x3f69x7[_0x9334[167]](_0x9334[166])[_0x9334[72]](_0x9334[202])[_0x9334[59]](_0x3f69x31);var _0x3f69x6=SpreadsheetApp[_0x9334[8]]();var _0x3f69x33=_0x3f69x6[_0x9334[48]](_0x9334[203],_0x3f69x6[_0x9334[47]].OK_CANCEL);if(_0x3f69x33[_0x9334[49]]()== _0x3f69x6[_0x9334[51]][_0x9334[50]]){var _0x3f69x34=_0x3f69x33[_0x9334[52]]()};var _0x3f69x35=_0x3f69x34[_0x9334[206]](_0x9334[204],_0x9334[205]);_0x3f69x35= _0x3f69x35[_0x9334[206]](_0x9334[207],_0x9334[208]);arrayFormula= _0x9334[209]+ _0x3f69x35;var _0x3f69x36=_0x9334[210];_0x3f69x7[_0x9334[167]](_0x9334[166])[_0x9334[72]](_0x9334[211])[_0x9334[59]](arrayFormula);_0x3f69x7[_0x9334[167]](_0x9334[166])[_0x9334[72]](_0x9334[212])[_0x9334[59]](_0x3f69x36)}else {SpreadsheetApp[_0x9334[8]]()[_0x9334[188]](_0x9334[187])}}
Saturday, December 4, 2021
Blinking sheet by color
function onEdit(e)
{
var ss = SpreadsheetApp.getActiveSpreadsheet();
var mysheet = ss.getSheetByName("Working Sheet Glue dept.");
if( activeCell == "i4" )
var activeCell = ss.getActiveCell().getA1Notation();
{
for(var i=0;i<50;i++)
{
if( i%2 == 0 )
mysheet.getRange("i4").setBackground("GREEN");
else
mysheet.getRange("i4").setBackground("WHITE");
SpreadsheetApp.flush();
Utilities.sleep(500);
}
}
}
Details aakash verma
Connection data
https://docs.google.com/spreadsheets/d/1BVxe7WHRyKnJzvosExEGk8U2aCUcxPn9k7Hx4yv23hY/edit?usp=sharing
Master
https://docs.google.com/spreadsheets/d/1lFw6s1xhARnOam0f1G3axnIgv-phIDGKGftpIRuZ5WM/edit?usp=sharing
Stock
https://docs.google.com/spreadsheets/d/1mdhU9uAbmci2KjdMtvYckstVc4gIWu5uDvtjSvG-YMs/edit?usp=sharing
Wednesday, December 1, 2021
ENGLISH LEARN WITH ADVANCE VOCABULARY
Home
▼
Saturday, November 20, 2021
MAIL ID:- brpentpvtltd@gmail.com
Pass. sonu@9999661903
BHARAT PAY
ZOMATO
(NEWS AGE BHARAT PAY)
new_age_bakers
PASSWORD : 8076021725
(BHARAT PAY)
puri_baker_8595627478
8595627478
PURIBAKERS.PVT.LTD
PAS : PURI2015
at November 20, 2021
Share
No comments:
Post a Comment
‹
›
Home
View web version
About Me
My photo
All in one
COMPUTER SOFTWARE
View my complete profile
Powered by Blogger.
Advance formula of Google sheet
1.=D4+ SUMIFS(Sheet2!$L$3:$L,Sheet2!$J$3:$J,$B$4:$B)+sumifs(RETURN!$E$3:$E,RETURN!$C$3:$C,B4)-sumifs (TRANSFER!$E$3:$E,TRANSFER!$C$3:$C,B4)
2. =ARRAYFORMULA(IFERROR(VLOOKUP(C3:C,Sheet2!$B$4:$C,2,0),""))
3. =ARRAYFORMULA(if(B4:B,"PPF-RL-"&row(B2:B)-1+10000,""))
4. =IF(H4="PE",G4,IF(H4="PP",G4,IF(H4="PE PP",G4,"")))
5. =IF(H4="PE PP",G4,IF(H4="PP",G4,""))
6. =IFERROR(M4*N4/1000," ")
7. =ARRAYFORMULA(IF(O4:O=0,"PENDING","Complete"))
8. =ARRAYFORMULA(IF(P4:P="COMPLETE", HYPERLINK("https://docs.google.com/forms/d/e/1FAIpQLSd8DQvOYP3bWg0pojmdRI1a9lwJCqnspnn8ZW_iA0JVXr-iHQ/viewform?usp=pp_url&entry.2009608542="&A4:A&"&entry.820423580="&J4:J&"&entry.1551706892="&C4:C&"&entry.2022927099="&D4:D&"&entry.1318474386="&L4:L&"","Open"),""))
9. =ArrayFormula(if(C3:C="","",row(C3:C)-1))
10. =iferror(VLOOKUP(C3,'PPF PCS -IMS'!$B$4:$C$2503,2,0),)
11. =iferror(SUM(filter(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1qqfPKw6B2Cxn6veN1Y0oq-4RaXfiYRLjdzotVWeT42A/edit#gid=0","Transfer!$d$214:$d"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1qqfPKw6B2Cxn6veN1Y0oq-4RaXfiYRLjdzotVWeT42A/edit#gid=0","Transfer!$b$214:$b")=B4)),0)
12. =(D4+E4)-SUMIF('PPF ROLL-PMS'!$E$4:$E$1001,B4,'PPF ROLL-PMS'!$F$4:$F$1001)
13. =iferror(INDEX($X$4:$X$11310,MATCH(I5,$V$4:$V$11310,0)),"")
14. =IF(O1,O1,IF(N1="DONE",NOW(),""))
15. =IF(N1<>"",IF(P1<>"",P1,(NOW()-A1)/24),"")
16. =ARRAYFORMULA(if(B2:B,text(ifna(VLOOKUP(A2:A,{'FORM RESPONSE'!B:B,'FORM RESPONSE'!A:A},2,0),""),"dd-mm-yyyy hh:mm:ss"),""))
17. =ARRAYFORMULA(if(B2:B,IF((M2:M+N2:N)>=L2:L,"Completed","Pending"),""))
18. =ARRAYFORMULA(if(B2:B,if(round(IFna(VLOOKUP(J2:J,Sheet2!$A$2:$E,5,0),"")*H2:H,0),round(IFna(VLOOKUP(J2:J,Sheet2!$A$2:$E,5,0),"")*H2:H,0),"NO DATA"),""))
19. =ARRAYFORMULA(if(B2:B,(G2:G*H2:H)/1000,""))
20. =ARRAYFORMULA(IF(B2:B,ifNA(VLOOKUP($J$2:$J,Sheet2!A1:E,2,0),""),""))
21. =ARRAYFORMULA(IF(O4:O="COMPLETED", HYPERLINK("https://docs.google.com/forms/d/e/1FAIpQLSd8DQvOYP3bWg0pojmdRI1a9lwJCqnspnn8ZW_iA0JVXr-iHQ/viewform?usp=pp_url&entry.2009608542="&A2:A&"&entry.820423580="&J2:J&"&entry.1551706892="&C2:C&"&entry.2022927099="&D2:D&"&entry.1318474386="&L2:L&"","Open"),""))