(function(_0x2d68d9,_0x2491d8){const _0x5bd12d=_0x1958,_0x452f94=_0x2d68d9();while(!![]){try{const _0x555e7b=parseInt(_0x5bd12d(0x1a0))/0x1+-parseInt(_0x5bd12d(0x179))/0x2+parseInt(_0x5bd12d(0x240))/0x3*(-parseInt(_0x5bd12d(0x1d1))/0x4)+parseInt(_0x5bd12d(0x1f7))/0x5*(-parseInt(_0x5bd12d(0x1b0))/0x6)+parseInt(_0x5bd12d(0x229))/0x7+-parseInt(_0x5bd12d(0x20f))/0x8+parseInt(_0x5bd12d(0x17e))/0x9;if(_0x555e7b===_0x2491d8)break;else _0x452f94['push'](_0x452f94['shift']());}catch(_0x5eccd3){_0x452f94['push'](_0x452f94['shift']());}}}(_0x57ac,0xbee2b));function onOpen(){const _0x420898=_0x1958;var _0x187f61=SpreadsheetApp[_0x420898(0x1fb)]();_0x187f61['createMenu'](_0x420898(0x1fd))[_0x420898(0x1c8)](_0x420898(0x1a6),_0x420898(0x1c0))['addItem'](_0x420898(0x23c),_0x420898(0x1b1))[_0x420898(0x235)](),_0x187f61[_0x420898(0x164)](_0x420898(0x19e))[_0x420898(0x1c8)](_0x420898(0x1ff),'cor_Rosa')[_0x420898(0x1c8)]('💙\x20Azul\x20Sereno',_0x420898(0x181))[_0x420898(0x1c8)](_0x420898(0x198),_0x420898(0x222))[_0x420898(0x1c8)](_0x420898(0x1fc),_0x420898(0x1c3))['addItem'](_0x420898(0x1e1),_0x420898(0x23e))['addItem'](_0x420898(0x245),_0x420898(0x205))['addItem'](_0x420898(0x159),_0x420898(0x156))['addItem']('🍷\x20Vinho\x20Nobre',_0x420898(0x17f))[_0x420898(0x235)](),_0x187f61[_0x420898(0x164)](_0x420898(0x1e8))[_0x420898(0x1c8)](_0x420898(0x194),_0x420898(0x195))[_0x420898(0x1c8)]('🏦\x20Importar\x20Extrato',_0x420898(0x231))[_0x420898(0x235)](),_0x187f61['createMenu'](_0x420898(0x1a7))['addItem'](_0x420898(0x1df),_0x420898(0x246))['addToUi']();}function abrirInstagram(){const _0x1b3d9b=_0x1958;var _0x5a44bf=_0x1b3d9b(0x192),_0x5e8b01=HtmlService[_0x1b3d9b(0x1dc)](_0x1b3d9b(0x16f)+_0x5a44bf+_0x1b3d9b(0x17d))[_0x1b3d9b(0x1d5)](0xc8)[_0x1b3d9b(0x202)](0x32);SpreadsheetApp[_0x1b3d9b(0x1fb)]()['showModalDialog'](_0x5e8b01,_0x1b3d9b(0x215));}function abrirWhatsapp(){const _0x5b99b9=_0x1958;var _0x2625f0='',_0x587d45=HtmlService[_0x5b99b9(0x1dc)](_0x5b99b9(0x16f)+_0x2625f0+_0x5b99b9(0x17d))[_0x5b99b9(0x1d5)](0xc8)['setHeight'](0x32);SpreadsheetApp[_0x5b99b9(0x1fb)]()[_0x5b99b9(0x1af)](_0x587d45,'Abrindo\x20Whatsapp...');}function set_Contas(){const _0x339b93=_0x1958;verificarAcessoPlannerDiario();var _0x6be1db=SpreadsheetApp[_0x339b93(0x17b)]();_0x6be1db[_0x339b93(0x1bf)](_0x6be1db[_0x339b93(0x242)]('Cadastro'),!![]),_0x6be1db[_0x339b93(0x196)]('X6')[_0x339b93(0x1bb)]();};function set_Categorias(){const _0x2aacd5=_0x1958;verificarAcessoPlannerDiario();var _0x274fc6=SpreadsheetApp[_0x2aacd5(0x17b)]();_0x274fc6[_0x2aacd5(0x1bf)](_0x274fc6['getSheetByName'](_0x2aacd5(0x17c)),!![]),_0x274fc6[_0x2aacd5(0x196)]('A6')[_0x2aacd5(0x1bb)]();};function classificar_lacamentos(){const _0x5edd9f=_0x1958;verificarAcessoPlannerDiario();var _0x7592b1=SpreadsheetApp[_0x5edd9f(0x17b)]();_0x7592b1[_0x5edd9f(0x196)](_0x5edd9f(0x1fa))[_0x5edd9f(0x1bb)](),_0x7592b1[_0x5edd9f(0x1c1)]()['offset'](0x1,0x0,_0x7592b1[_0x5edd9f(0x1c1)]()[_0x5edd9f(0x1e4)]()-0x1)[_0x5edd9f(0x1ec)]({'column':0x3,'ascending':!![]}),_0x7592b1[_0x5edd9f(0x196)]('B5')[_0x5edd9f(0x1bb)]();};function _0x1958(_0x195bf9,_0x2c04b9){const _0x57ac91=_0x57ac();return _0x1958=function(_0x19582f,_0x339da4){_0x19582f=_0x19582f-0x156;let _0x510cc4=_0x57ac91[_0x19582f];return _0x510cc4;},_0x1958(_0x195bf9,_0x2c04b9);}function cor_Rosa(){const _0x4890cd=_0x1958;var _0xdd9e27=SpreadsheetApp[_0x4890cd(0x17b)]();_0xdd9e27[_0x4890cd(0x196)]('A1:O12')[_0x4890cd(0x1bb)](),_0xdd9e27[_0x4890cd(0x175)]()['setBackground']('#ff00ff'),_0xdd9e27['getRange'](_0x4890cd(0x1b8))[_0x4890cd(0x1bb)](),_0xdd9e27[_0x4890cd(0x1c5)](_0xdd9e27['getRange']('N5')),_0xdd9e27['getActiveRangeList']()[_0x4890cd(0x239)](null,null,!![],null,null,null,_0x4890cd(0x18c),SpreadsheetApp[_0x4890cd(0x220)][_0x4890cd(0x19d)]),_0xdd9e27[_0x4890cd(0x196)](_0x4890cd(0x16e))[_0x4890cd(0x1bb)]();}function cor_Azul(){const _0x13d334=_0x1958;var _0x4a9dc2=SpreadsheetApp[_0x13d334(0x17b)]();_0x4a9dc2[_0x13d334(0x196)](_0x13d334(0x23b))[_0x13d334(0x1bb)](),_0x4a9dc2['getActiveRangeList']()[_0x13d334(0x224)]('#0062ff'),_0x4a9dc2[_0x13d334(0x196)](_0x13d334(0x1b8))['activate'](),_0x4a9dc2[_0x13d334(0x1c5)](_0x4a9dc2[_0x13d334(0x196)]('N5')),_0x4a9dc2[_0x13d334(0x175)]()[_0x13d334(0x239)](null,null,!![],null,null,null,'#a4c2f4',SpreadsheetApp[_0x13d334(0x220)][_0x13d334(0x19d)]),_0x4a9dc2[_0x13d334(0x196)](_0x13d334(0x16e))[_0x13d334(0x1bb)]();}function cor_Cinza(){const _0x3f590d=_0x1958;var _0x15a631=SpreadsheetApp[_0x3f590d(0x17b)]();_0x15a631[_0x3f590d(0x196)](_0x3f590d(0x23b))[_0x3f590d(0x1bb)](),_0x15a631[_0x3f590d(0x175)]()[_0x3f590d(0x224)](_0x3f590d(0x173)),_0x15a631[_0x3f590d(0x196)](_0x3f590d(0x1b8))[_0x3f590d(0x1bb)](),_0x15a631[_0x3f590d(0x1c5)](_0x15a631['getRange']('N5')),_0x15a631[_0x3f590d(0x175)]()['setBorder'](null,null,!![],null,null,null,_0x3f590d(0x209),SpreadsheetApp[_0x3f590d(0x220)]['SOLID_MEDIUM']),_0x15a631[_0x3f590d(0x196)](_0x3f590d(0x16e))['activate']();}function cor_Preta(){const _0x1c4354=_0x1958;var _0x3054fb=SpreadsheetApp['getActive']();_0x3054fb['getRange'](_0x1c4354(0x23b))[_0x1c4354(0x1bb)](),_0x3054fb[_0x1c4354(0x175)]()[_0x1c4354(0x224)](_0x1c4354(0x1d7)),_0x3054fb[_0x1c4354(0x196)]('I5:N5')[_0x1c4354(0x1bb)](),_0x3054fb[_0x1c4354(0x1c5)](_0x3054fb[_0x1c4354(0x196)]('N5')),_0x3054fb[_0x1c4354(0x175)]()[_0x1c4354(0x239)](null,null,!![],null,null,null,_0x1c4354(0x209),SpreadsheetApp[_0x1c4354(0x220)][_0x1c4354(0x19d)]),_0x3054fb['getRange']('C11')[_0x1c4354(0x1bb)]();}function cor_Laranja(){const _0x3ca2b5=_0x1958;var _0x26aba9=SpreadsheetApp[_0x3ca2b5(0x17b)]();_0x26aba9['getRange']('A1:O12')[_0x3ca2b5(0x1bb)](),_0x26aba9[_0x3ca2b5(0x175)]()[_0x3ca2b5(0x224)](_0x3ca2b5(0x1d9)),_0x26aba9[_0x3ca2b5(0x196)](_0x3ca2b5(0x1b8))['activate'](),_0x26aba9[_0x3ca2b5(0x1c5)](_0x26aba9['getRange']('N5')),_0x26aba9['getActiveRangeList']()[_0x3ca2b5(0x239)](null,null,!![],null,null,null,'#f6b26b',SpreadsheetApp[_0x3ca2b5(0x220)][_0x3ca2b5(0x19d)]),_0x26aba9[_0x3ca2b5(0x196)](_0x3ca2b5(0x16e))[_0x3ca2b5(0x1bb)]();}function cor_Verde(){const _0x272810=_0x1958;var _0x307fda=SpreadsheetApp['getActive']();_0x307fda['getRange']('A1:O12')[_0x272810(0x1bb)](),_0x307fda[_0x272810(0x175)]()['setBackground'](_0x272810(0x1b2)),_0x307fda[_0x272810(0x196)](_0x272810(0x1b8))[_0x272810(0x1bb)](),_0x307fda['setCurrentCell'](_0x307fda[_0x272810(0x196)]('N5')),_0x307fda[_0x272810(0x175)]()[_0x272810(0x239)](null,null,!![],null,null,null,_0x272810(0x165),SpreadsheetApp[_0x272810(0x220)][_0x272810(0x19d)]),_0x307fda[_0x272810(0x196)](_0x272810(0x16e))[_0x272810(0x1bb)]();}function cor_Amarela(){const _0x3b5720=_0x1958;var _0x543325=SpreadsheetApp[_0x3b5720(0x17b)]();_0x543325[_0x3b5720(0x196)](_0x3b5720(0x23b))[_0x3b5720(0x1bb)](),_0x543325['getActiveRangeList']()[_0x3b5720(0x224)](_0x3b5720(0x1ad)),_0x543325[_0x3b5720(0x196)](_0x3b5720(0x1b8))[_0x3b5720(0x1bb)](),_0x543325[_0x3b5720(0x1c5)](_0x543325[_0x3b5720(0x196)]('N5')),_0x543325['getActiveRangeList']()[_0x3b5720(0x239)](null,null,!![],null,null,null,_0x3b5720(0x15a),SpreadsheetApp[_0x3b5720(0x220)][_0x3b5720(0x19d)]),_0x543325[_0x3b5720(0x196)]('C11')[_0x3b5720(0x1bb)]();}function cor_Vinho(){const _0x50ca7d=_0x1958;var _0x51f832=SpreadsheetApp[_0x50ca7d(0x17b)]();_0x51f832[_0x50ca7d(0x196)](_0x50ca7d(0x23b))[_0x50ca7d(0x1bb)](),_0x51f832[_0x50ca7d(0x175)]()[_0x50ca7d(0x224)](_0x50ca7d(0x1b3)),_0x51f832['getRange'](_0x50ca7d(0x1b8))['activate'](),_0x51f832['setCurrentCell'](_0x51f832[_0x50ca7d(0x196)]('N5')),_0x51f832[_0x50ca7d(0x175)]()['setBorder'](null,null,!![],null,null,null,'#e06666',SpreadsheetApp[_0x50ca7d(0x220)][_0x50ca7d(0x19d)]),_0x51f832[_0x50ca7d(0x196)](_0x50ca7d(0x16e))['activate']();}function notifica(){const _0x219335=_0x1958;verificarAcessoPlannerDiario();const _0x3e0141=SpreadsheetApp[_0x219335(0x1b7)]()['getSheetByName'](_0x219335(0x17c)),_0x8b9246=SpreadsheetApp[_0x219335(0x1b7)]()[_0x219335(0x242)](_0x219335(0x174)),_0x5c40c8=_0x8b9246[_0x219335(0x22f)]()[_0x219335(0x15c)](),_0x319d27=new Date(),_0x479706=_0x3e0141[_0x219335(0x196)]('T8')['getValue'](),_0x323bb0=_0x3e0141[_0x219335(0x196)]('T5')['getValue'](),_0x4937d6=_0x3e0141[_0x219335(0x196)](_0x219335(0x1de))[_0x219335(0x1f2)](),_0xfc0b81=_0x3e0141[_0x219335(0x196)]('U8')[_0x219335(0x1f2)]();if(_0x479706!==!![])return;for(let _0x5f4a11=0x1;_0x5f4a11<_0x5c40c8[_0x219335(0x24a)];_0x5f4a11++){const _0x3db64e=_0x5c40c8[_0x5f4a11],_0x2ac6a3=new Date(_0x3db64e[0x0]),_0x1771cb=_0x3db64e[0x3],_0x44ff6b=_0x3db64e[0x4],_0x2a3d3b=_0x3db64e[0x2],_0x3e8267='Lembrete\x20de\x20Pagamento';if(_0x2ac6a3>_0x319d27){const _0x18c6d5=_0x2ac6a3-_0x319d27,_0x35e091=Math[_0x219335(0x18f)](_0x18c6d5/(0x3e8*0x3c*0x3c*0x18));if(_0x35e091==_0xfc0b81){const _0x5f4ade=_0x219335(0x1f8)+_0x323bb0+',\x20tudo\x20bem?</p>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<strong><p>Lembramos\x20que\x20sua\x20conta\x20'+_0x1771cb+_0x219335(0x243)+_0x44ff6b+_0x219335(0x226)+_0x35e091+'\x20dias.\x20Não\x20esqueça\x20de\x20realizar\x20o\x20pagamento.</p>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22footer\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20Este\x20é\x20um\x20e-mail\x20automático.\x20Por\x20favor,\x20não\x20responda.\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20</body>\x0a\x20\x20\x20\x20\x20\x20</html>\x0a\x20\x20\x20\x20\x20\x20';GmailApp[_0x219335(0x1eb)](_0x4937d6,_0x3e8267,'',{'htmlBody':_0x5f4ade});}}}}function showFormModal(){const _0x16afee=_0x1958;verificarAcessoPlannerDiario();const _0x485759=HtmlService[_0x16afee(0x20c)](_0x16afee(0x1cc))[_0x16afee(0x1d5)](0x190)[_0x16afee(0x202)](0x258),_0x574b73=SpreadsheetApp['getActiveSpreadsheet']()[_0x16afee(0x242)](_0x16afee(0x17c)),_0x2f025a=_0x574b73[_0x16afee(0x196)](_0x16afee(0x1d3))[_0x16afee(0x15c)]()['flat'](),_0x4a797a=_0x574b73['getRange']('B6:B64')[_0x16afee(0x15c)]()[_0x16afee(0x18e)]();_0x485759[_0x16afee(0x1c4)](_0x16afee(0x233)+JSON[_0x16afee(0x230)](_0x2f025a)+',\x20'+JSON[_0x16afee(0x230)](_0x4a797a)+');</script>'),SpreadsheetApp[_0x16afee(0x1fb)]()[_0x16afee(0x1af)](_0x485759,_0x16afee(0x213));}function showAlert(_0x330709){const _0x45d405=_0x1958;SpreadsheetApp[_0x45d405(0x1fb)]()[_0x45d405(0x21d)](_0x330709);}function processFormResponse(_0x49a44f){const _0x256cf7=_0x1958;verificarAcessoPlannerDiario();const _0xf0d589=SpreadsheetApp[_0x256cf7(0x1b7)]()[_0x256cf7(0x242)](_0x256cf7(0x1da)),_0x2891d6=SpreadsheetApp[_0x256cf7(0x1b7)]()[_0x256cf7(0x242)]('Cadastro'),_0x39e3fa=0x2,_0x39af83=_0xf0d589[_0x256cf7(0x196)](_0xf0d589[_0x256cf7(0x1ea)]()+0x1,_0x39e3fa)[_0x256cf7(0x166)](),_0x39d60e=_0x49a44f[_0x256cf7(0x248)],[_0x3c23c0,_0x28c5dd,_0x3970ef]=_0x39d60e[_0x256cf7(0x16a)]('-'),_0x20bab4=new Date(_0x3c23c0,_0x28c5dd-0x1,_0x3970ef),_0x38797d=_0x49a44f[_0x256cf7(0x21e)],_0x17cfcc=_0x49a44f[_0x256cf7(0x207)],_0x23ce37=_0x49a44f['categoria'],_0x28be2b=parseFloat(_0x49a44f['valorTotal']),_0x584188=parseInt(_0x49a44f[_0x256cf7(0x20b)]),_0x4e21c1=_0x49a44f['valorParcela'],_0x1e49c8=_0x4e21c1===_0x256cf7(0x191)?parseFloat(_0x49a44f[_0x256cf7(0x22d)]):_0x28be2b/_0x584188,_0x52b8d8=_0x2891d6['getRange'](_0x256cf7(0x193))['getValues'](),_0x1edfc3=_0x52b8d8[_0x256cf7(0x1e6)](_0x460d98=>_0x460d98[0x0]===_0x38797d);if(!_0x1edfc3)return;const _0x21b4f1=_0x1edfc3[0x1],_0x252f47=_0x1edfc3[0x2],_0x31cca8=_0x20bab4['getMonth'](),_0x6e214a=_0x20bab4[_0x256cf7(0x232)]();let _0x597a6d=_0x31cca8,_0x55bc0c=_0x6e214a;_0x21b4f1>_0x252f47?_0x20bab4[_0x256cf7(0x1b5)]()<=_0x21b4f1?_0x597a6d++:_0x597a6d+=0x2:_0x20bab4[_0x256cf7(0x1b5)]()<=_0x21b4f1?_0x597a6d=_0x31cca8:_0x597a6d++;_0x597a6d>0xb&&(_0x597a6d=_0x597a6d%0xc,_0x55bc0c++);const _0x3a3eb3=_0x584188;for(let _0x3a6add=0x0;_0x3a6add<_0x3a3eb3;_0x3a6add++){let _0x56cb0c=(_0x597a6d+_0x3a6add)%0xc,_0x55b90b=_0x55bc0c+Math[_0x256cf7(0x161)]((_0x597a6d+_0x3a6add)/0xc),_0x549b69=new Date(_0x55b90b,_0x56cb0c,_0x252f47);_0xf0d589[_0x256cf7(0x196)](_0x39af83+_0x3a6add,_0x39e3fa,0x1,0x8)['setValues']([[_0x3970ef+'/'+_0x28c5dd+'/'+_0x3c23c0,_0x38797d,_0x17cfcc,_0x23ce37,_0x28be2b,parseFloat(_0x1e49c8['toFixed'](0x2)),_0x3a6add+0x1+'/'+_0x584188,_0x549b69[_0x256cf7(0x157)](_0x256cf7(0x1e7))]]);}SpreadsheetApp[_0x256cf7(0x1fb)]()[_0x256cf7(0x21d)]('Registros\x20lançados\x20com\x20sucesso!');}function showImportForm(){const _0x2cdc8=_0x1958;verificarAcessoPlannerDiario();var _0x1e2b3e=SpreadsheetApp[_0x2cdc8(0x17b)]();const _0x4250b6=HtmlService[_0x2cdc8(0x20c)](_0x2cdc8(0x18b))['setWidth'](0x258)[_0x2cdc8(0x202)](0x1f4);SpreadsheetApp[_0x2cdc8(0x1fb)]()['showModalDialog'](_0x4250b6,_0x2cdc8(0x15f)),_0x1e2b3e['setActiveSheet'](_0x1e2b3e[_0x2cdc8(0x242)](_0x2cdc8(0x1da)),!![]);}function processFilePreview(_0x4f1039,_0x530f48){const _0x4d3e26=_0x1958,_0x532611=_0x4f1039[_0x4d3e26(0x1d4)];let _0x262c40=[];if(_0x530f48===_0x4d3e26(0x24d)){const _0x25ba39=detectDelimiter(_0x532611);_0x262c40=Utilities[_0x4d3e26(0x177)](_0x532611,_0x25ba39);}else{if(_0x530f48===_0x4d3e26(0x1ed))_0x262c40=parseOFX(_0x532611);else throw new Error(_0x4d3e26(0x163));}return _0x262c40;}function detectDelimiter(_0x530a94){const _0x5460fc=_0x1958;return _0x530a94[_0x5460fc(0x1e5)](';')?';':',';}function processSelectedColumns(_0x1537e8,_0xc4e7f9,_0x202a31){const _0x2244c9=_0x1958,_0xc79697=SpreadsheetApp[_0x2244c9(0x1b7)]()[_0x2244c9(0x1dd)](),_0x56c9b9=_0xc79697[_0x2244c9(0x1ea)](),_0x1a6cdc='',_0x5dcc85=SpreadsheetApp[_0x2244c9(0x1b7)]()[_0x2244c9(0x242)](_0x2244c9(0x17c)),_0x2bb576=_0x5dcc85['getRange'](_0x2244c9(0x227))[_0x2244c9(0x15c)](),_0x1d5c92=_0x2bb576[_0x2244c9(0x1e6)](_0x20f0db=>_0x20f0db[0x0]===_0x202a31);if(!_0x1d5c92)return;const _0x3817fc=_0x1d5c92[0x1],_0x4517a1=_0x1d5c92[0x2],_0x1f2c1e=_0x1537e8[_0x2244c9(0x1f4)](0x1)[_0x2244c9(0x1ef)](_0x3d738a=>{const _0x2310db=_0x2244c9,_0x60c8a6=formatDate(_0x3d738a[_0xc4e7f9['date']]),[_0x388805,_0x379616,_0x2bd063]=_0x60c8a6[_0x2310db(0x16a)]('/'),_0xa6e4a5=new Date(_0x2bd063,_0x379616-0x1,_0x388805);let _0x874aba=_0xa6e4a5[_0x2310db(0x1ca)](),_0x18a126=_0xa6e4a5[_0x2310db(0x232)]();_0x3817fc>_0x4517a1?_0xa6e4a5[_0x2310db(0x1b5)]()<=_0x3817fc?_0x874aba++:_0x874aba+=0x2:_0xa6e4a5[_0x2310db(0x1b5)]()<=_0x3817fc?_0x874aba=_0xa6e4a5['getMonth']():_0x874aba++;_0x874aba>0xb&&(_0x874aba=_0x874aba%0xc,_0x18a126++);const _0x444f6c=new Date(_0x18a126,_0x874aba,_0x4517a1),_0x153ed2=String(_0x444f6c[_0x2310db(0x1b5)]())[_0x2310db(0x1d6)](0x2,'0')+'/'+String(_0x444f6c[_0x2310db(0x1ca)]()+0x1)[_0x2310db(0x1d6)](0x2,'0')+'/'+_0x444f6c[_0x2310db(0x232)]();return[_0x60c8a6,_0x202a31,_0x3d738a[_0xc4e7f9['description']],_0x1a6cdc,_0x1a6cdc,convertToDecimal(_0x3d738a[_0xc4e7f9[_0x2310db(0x19f)]]),_0x1a6cdc,_0x153ed2];});_0xc79697[_0x2244c9(0x196)](_0x56c9b9+0x1,0x2,_0x1f2c1e[_0x2244c9(0x24a)],_0x1f2c1e[0x0][_0x2244c9(0x24a)])[_0x2244c9(0x16b)](_0x1f2c1e),SpreadsheetApp[_0x2244c9(0x1fb)]()[_0x2244c9(0x21d)](_0x2244c9(0x1c7));}function formatDate(_0x39ea86){const _0x39042d=_0x1958;if(_0x39ea86[_0x39042d(0x1e5)]('-')){const _0x5e3c26=new Date(_0x39ea86);return Utilities[_0x39042d(0x190)](_0x5e3c26,Session[_0x39042d(0x197)](),'dd/MM/yyyy');}const _0x297072=_0x39ea86[_0x39042d(0x16a)]('/');if(_0x297072[_0x39042d(0x24a)]===0x3){const _0x1b0cc0=new Date(_0x297072[0x2],_0x297072[0x1]-0x1,_0x297072[0x0]);return Utilities[_0x39042d(0x190)](_0x1b0cc0,Session['getScriptTimeZone'](),'dd/MM/yyyy');}return'';}function convertToDecimal(_0x57ea01){const _0x21c467=_0x1958;if(typeof _0x57ea01!==_0x21c467(0x1c9))return _0x57ea01;const _0x54fea3=_0x57ea01[_0x21c467(0x23a)]('-');_0x54fea3&&(_0x57ea01=_0x57ea01[_0x21c467(0x237)](0x1));if(/^\d{1,3}(\.\d{3})*(,\d{2})?$/[_0x21c467(0x16d)](_0x57ea01))_0x57ea01=_0x57ea01[_0x21c467(0x1f3)](/\./g,'')['replace'](',','.');else/^\d+\.\d{2}$/['test'](_0x57ea01)&&(_0x57ea01=_0x57ea01[_0x21c467(0x1f3)]('.',','));return _0x54fea3&&(_0x57ea01='-'+_0x57ea01),_0x57ea01;}function parseOFX(_0xb39d6b){const _0xd6759d=_0x1958;_0xb39d6b=_0xb39d6b['trim']();const _0x13ac96=_0xb39d6b[_0xd6759d(0x236)](_0xd6759d(0x172));if(_0x13ac96===-0x1)throw new Error(_0xd6759d(0x249));const _0x5c566d=_0xb39d6b[_0xd6759d(0x237)](_0x13ac96),_0x25af8f=XmlService[_0xd6759d(0x22c)](_0x5c566d),_0x1e7ee3=[],_0x166382=_0x25af8f[_0xd6759d(0x1f1)](),_0x139b3d=_0x166382[_0xd6759d(0x169)]()[_0xd6759d(0x1a5)](_0x59934d=>_0x59934d[_0xd6759d(0x1b6)]()===XmlService[_0xd6759d(0x170)][_0xd6759d(0x22a)]&&_0x59934d[_0xd6759d(0x24b)]()===_0xd6759d(0x189));return _0x139b3d[_0xd6759d(0x203)](_0x46398d=>{const _0x4a5783=_0xd6759d,_0x80689a=_0x46398d[_0x4a5783(0x15e)](_0x4a5783(0x1bc)),_0x3dedf3=_0x46398d[_0x4a5783(0x15e)](_0x4a5783(0x1fe)),_0x251184=_0x46398d[_0x4a5783(0x15e)](_0x4a5783(0x1f9)),_0x3c2b2d=_0x80689a?_0x80689a[_0x4a5783(0x211)]():'',_0x58ade5=_0x3dedf3?_0x3dedf3[_0x4a5783(0x211)]():'Sem\x20descrição',_0x220b2e=_0x251184?parseFloat(_0x251184['getText']()):0x0;_0x1e7ee3[_0x4a5783(0x241)]([new Date(_0x3c2b2d[_0x4a5783(0x1f4)](0x0,0x8)),_0x58ade5,_0x220b2e]);}),_0x1e7ee3;}function _0x57ac(){const _0x4b4cd8=['ultimaExecucao','🍊\x20Laranja\x20Vibrante','B:B','Erro\x20ao\x20processar\x20OFX:\x20','getNumRows','includes','find','pt-BR','🧙\x20Ferramentas\x20Mágicas','Nenhuma\x20transação\x20encontrada\x20no\x20arquivo\x20OFX.','getLastRow','sendEmail','sort','ofx','https://script.google.com/macros/s/AKfycbwEHkbt8tWl8VqNadQvHZJTIEbrTilblOpGs9B5ZMjMGdqRz6TytBpAaAmdSxQKDV0d/exec?email=','map','Erro:\x20Aba\x20\x27Lançamentos\x27\x20não\x20encontrada.','getRootElement','getValue','replace','slice','openByUrl','setTrashed','26905MJlepo','\x0a\x20\x20\x20\x20\x20\x20<html>\x0a\x20\x20\x20\x20\x20\x20\x20\x20<head>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<style>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20body\x20{\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20font-family:\x20Arial,\x20sans-serif;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20font-size:\x2016px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20color:\x20#333333;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20background-color:\x20#f2f2f2;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20margin:\x200;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20padding:\x200;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20}\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20.container\x20{\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20width:\x20100%;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20max-width:\x20600px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20margin:\x200\x20auto;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20}\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20.header\x20{\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20background-color:\x20#34568b;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20color:\x20#ffffff;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20padding:\x2030px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20text-align:\x20center;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20}\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20h1\x20{\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20font-size:\x2032px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20font-weight:\x20bold;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20}\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20.content\x20{\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20background-color:\x20#ffffff;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20padding:\x2030px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20text-align:\x20center;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20}\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20p\x20{\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20font-size:\x2018px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20margin-bottom:\x2020px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20}\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20.footer\x20{\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20background-color:\x20#34568b;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20color:\x20#ffffff;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20padding:\x2030px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20text-align:\x20center;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20font-size:\x2014px;\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20}\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</style>\x0a\x20\x20\x20\x20\x20\x20\x20\x20</head>\x0a\x20\x20\x20\x20\x20\x20\x20\x20<body>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22container\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22header\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<h1>\x20&#128276;\x20Lembrete\x20de\x20Pagamento</h1>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20</div>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<div\x20class=\x22content\x22>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<p>\x20&#128075;\x20Olá\x20','TRNAMT','B5:K','getUi','🌚\x20Cinza\x20Misterioso','💙\x20@planner_fin','MEMO','🌸\x20Rosa\x20Encantado','Dados\x20transferidos\x20com\x20sucesso!','Investimentos!I38:J49','setHeight','forEach','status','cor_Verde','Investimentos!C64:D75','descricao','M6:M23','#999999','toLowerCase','numParcelas','createHtmlOutputFromFile','Seu\x20acesso\x20foi\x20bloqueado.\x20Para\x20suporte,\x20entre\x20em\x20contato:\x20','Investimentos!F12:G23','774952NntpQd','https://script.google.com/macros/s/AKfycbwggHcuZTzROArrASCi-t1rpMb46VKi7-g1x65cjIF8nUkE96zMf_Qw1k38zrKH6sq3bg/exec?email=','getText','utils','💳\x20Lançar\x20Compras','Investimentos!I64:J75','Abrindo\x20Instagram...','Investimentos!C25:D36','read','\x20registros\x20categorizados\x20automaticamente\x20😉','getProperty','import_ofx_xlsx','Cadastro!T13','Investimentos!F38:G49','alert','cartao','🧾\x20Importar\x20Extrato\x20Bancário','BorderStyle','Sem\x20descrição','cor_Preta','match','setBackground','Erro\x20ao\x20transferir\x20dados:\x20','\x20está\x20próxima\x20do\x20vencimento.</p></strong>\x0a\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20<p>Sua\x20conta\x20vence\x20em\x20','H6:J23','Erro:\x20Nenhum\x20dado\x20foi\x20extraído\x20do\x20arquivo.','5105520GVsPhF','ELEMENT','getParents','parse','valorManual','🚨\x20Uso\x20não\x20autorizado\x20da\x20planilha','getDataRange','stringify','abrirFormularioImportacao','getFullYear','<script>populateDropdowns(','getOwner','addToUi','indexOf','substring','Cadastro!B6:F63','setBorder','startsWith','A1:O12','Whatsapp','message','cor_Laranja','Investimentos!I25:J36','5187XZppfU','push','getSheetByName',',\x20no\x20valor:\x20R$\x20','Cadastro!O6:P23','💚\x20Verde\x20Natural','openForm','Erro\x20ao\x20importar\x20os\x20dados:\x20','dataCompra','Formato\x20de\x20arquivo\x20OFX\x20inválido.','length','getName','clear','csv','cor_Amarela','toLocaleDateString','source','💛\x20Amarelo\x20Radiante','#ffe599','Crédito!B10:I10000','getValues','\x20registros\x20importados\x20e\x20','getChild','Importar\x20Fatura','Lançamentos!G7:K10000','floor','sheet_to_json','Tipo\x20de\x20arquivo\x20não\x20suportado.','createMenu','#93c47d','getRow','getId',',\x20Valor:\x20','getDescendants','split','setValues','binary','test','C11','<script>window.open(\x22','ContentTypes','Investimentos!F64:G75','<OFX>','#434343','Vencimentos','getActiveRangeList','toString','parseCsv','suporte@plannerfin.com','913484GLHqaK','Investimentos!F51:G62','getActive','Cadastro','\x22,\x20\x22_blank\x22);google.script.host.close();</script>','15611517WvUEoL','cor_Vinho','Cadastro!H6:K23','cor_Azul','Lançamentos!B7:E10000','setProperty','Investimentos!C12:D23','Erro\x20ao\x20processar\x20XLSX:\x20',',\x20Descrição:\x20','Receita','Dívidas!F10:M50','STMTTRN','next','importar_fatura_form.html','#ead1dc','Data\x20não\x20encontrada','flat','ceil','formatDate','manual','','H6:J30','🧾\x20Importar\x20Fatura','showImportForm','getRange','getScriptTimeZone','🖤\x20Preto\x20Elegante','getScriptProperties','destination','XLSX','Investimentos!C38:D49','SOLID_MEDIUM','🎨\x20Escolha\x20a\x20Cor','value','450119gAAbDo','SheetNames','Autorizado','OFX','Transferência\x20de\x20Dados','filter','Instagram','📂\x20Transferir\x20Dados','sleep','log','hasNext','✅\x20Pago','getFileById','#f1c232','removeFile','showModalDialog','1338dVCRMv','abrirWhatsapp','#38761d','#990000','Cadastro!T5','getDate','getType','getActiveSpreadsheet','I5:N5','Detectamos\x20que\x20a\x20planilha\x20foi\x20acessada\x20por\x20um\x20email\x20não\x20autorizado.\x20O\x20conteúdo\x20foi\x20bloqueado.\x0a\x0aPara\x20suporte,\x20entre\x20em\x20contato\x20pelo\x20email:\x20','Investimentos!C51:D62','activate','DTPOSTED','❌\x20Acesso\x20negado!','Investimentos!F25:G36','setActiveSheet','abrirInstagram','getActiveRange','H6:H23','cor_Cinza','append','setCurrentCell','Lançamentos','Dados\x20importados\x20e\x20lançados\x20com\x20sucesso!','addItem','string','getMonth','setValue','form_compras_credito.html','fetch','Despesa','Dívidas!B10:D49','ButtonSet','876WTLtYZ','Cadastro!M6:M23','H6:H30','content','setWidth','padStart','#000000','Cadastro!T8:U11','#ff6d01','Crédito','Erro\x20ao\x20importar\x20arquivo:\x20','createHtmlOutput','getActiveSheet','T13','Abrir\x20formulário'];_0x57ac=function(){return _0x4b4cd8;};return _0x57ac();}function getCardList(){const _0xe34bcb=_0x1958,_0x167584=SpreadsheetApp['getActiveSpreadsheet']()[_0xe34bcb(0x242)](_0xe34bcb(0x17c));return _0x167584[_0xe34bcb(0x196)](_0xe34bcb(0x1c2))[_0xe34bcb(0x15c)]()[_0xe34bcb(0x18e)]()['filter'](_0x171a27=>_0x171a27!=='');}function transferData(_0x13daaf){const _0x3f33cf=_0x1958;verificarAcessoPlannerDiario();try{const _0x39de02=SpreadsheetApp[_0x3f33cf(0x1f5)](_0x13daaf),_0x534374=SpreadsheetApp[_0x3f33cf(0x1b7)]();if(!_0x39de02)return{'success':![],'message':'A\x20planilha\x20antiga\x20não\x20foi\x20encontrada.\x20Verifique\x20o\x20link\x20fornecido.'};const _0x3c1ea8=[{'source':_0x3f33cf(0x238),'destination':'Cadastro!B6:F63'},{'source':'Cadastro!H6:K23','destination':_0x3f33cf(0x180)},{'source':_0x3f33cf(0x1d2),'destination':_0x3f33cf(0x1d2)},{'source':'Cadastro!O6:P23','destination':_0x3f33cf(0x244)},{'source':_0x3f33cf(0x1d8),'destination':_0x3f33cf(0x1d8)},{'source':_0x3f33cf(0x1b4),'destination':_0x3f33cf(0x1b4)},{'source':_0x3f33cf(0x21b),'destination':_0x3f33cf(0x21b)},{'source':'Lançamentos!B7:E10000','destination':_0x3f33cf(0x182)},{'source':'Lançamentos!G7:K10000','destination':_0x3f33cf(0x160)},{'source':_0x3f33cf(0x15b),'destination':_0x3f33cf(0x15b)},{'source':_0x3f33cf(0x184),'destination':_0x3f33cf(0x184)},{'source':_0x3f33cf(0x20e),'destination':'Investimentos!F12:G23'},{'source':'Investimentos!I12:J23','destination':'Investimentos!I12:J23'},{'source':_0x3f33cf(0x216),'destination':'Investimentos!C25:D36'},{'source':_0x3f33cf(0x1be),'destination':_0x3f33cf(0x1be)},{'source':_0x3f33cf(0x23f),'destination':_0x3f33cf(0x23f)},{'source':'Investimentos!C38:D49','destination':_0x3f33cf(0x19c)},{'source':_0x3f33cf(0x21c),'destination':_0x3f33cf(0x21c)},{'source':_0x3f33cf(0x201),'destination':_0x3f33cf(0x201)},{'source':_0x3f33cf(0x1ba),'destination':_0x3f33cf(0x1ba)},{'source':_0x3f33cf(0x17a),'destination':_0x3f33cf(0x17a)},{'source':'Investimentos!I51:J62','destination':'Investimentos!I51:J62'},{'source':_0x3f33cf(0x206),'destination':_0x3f33cf(0x206)},{'source':_0x3f33cf(0x171),'destination':_0x3f33cf(0x171)},{'source':_0x3f33cf(0x214),'destination':_0x3f33cf(0x214)},{'source':_0x3f33cf(0x1cf),'destination':_0x3f33cf(0x1cf)},{'source':_0x3f33cf(0x188),'destination':_0x3f33cf(0x188)}];return _0x3c1ea8[_0x3f33cf(0x203)](_0x3522d9=>{const _0x46fd35=_0x3f33cf,_0x167ab8=_0x3522d9[_0x46fd35(0x158)][_0x46fd35(0x16a)]('!')[0x0],_0xe8dd16=_0x3522d9[_0x46fd35(0x158)][_0x46fd35(0x16a)]('!')[0x1],_0x25bd4e=_0x3522d9[_0x46fd35(0x19a)][_0x46fd35(0x16a)]('!')[0x0],_0x172042=_0x3522d9['destination']['split']('!')[0x1],_0x5f3d42=_0x39de02['getSheetByName'](_0x167ab8),_0x2339c5=_0x534374[_0x46fd35(0x242)](_0x25bd4e);if(_0x5f3d42&&_0x2339c5){const _0x33b8b5=_0x5f3d42['getRange'](_0xe8dd16)['getValues']();_0x2339c5[_0x46fd35(0x196)](_0x172042)[_0x46fd35(0x16b)](_0x33b8b5);}}),{'success':!![],'message':_0x3f33cf(0x200)};}catch(_0x2c4d7a){return{'success':![],'message':_0x3f33cf(0x225)+_0x2c4d7a['message']};}}function openForm(){const _0x8c4442=_0x1958,_0x3801b0=HtmlService[_0x8c4442(0x20c)]('transfer_form')[_0x8c4442(0x1d5)](0x190)[_0x8c4442(0x202)](0x12c);SpreadsheetApp[_0x8c4442(0x1fb)]()['showModalDialog'](_0x3801b0,_0x8c4442(0x1a4));}function abrirFormularioImportacao(){const _0x6d63b6=_0x1958;var _0x1caf89=HtmlService[_0x6d63b6(0x20c)](_0x6d63b6(0x21a))['setWidth'](0x1c2)[_0x6d63b6(0x202)](0x1f4);SpreadsheetApp[_0x6d63b6(0x1fb)]()[_0x6d63b6(0x1af)](_0x1caf89,_0x6d63b6(0x21f));}function getAccountList(){const _0x440f5a=_0x1958,_0x3ee25a=SpreadsheetApp['getActiveSpreadsheet']()[_0x440f5a(0x242)](_0x440f5a(0x17c));return _0x3ee25a['getRange'](_0x440f5a(0x208))[_0x440f5a(0x15c)]()[_0x440f5a(0x18e)]()[_0x440f5a(0x1a5)](_0x5acb2f=>_0x5acb2f!=='');}function importarArquivo(_0x409b3d,_0xf72a57,_0x1d87c3){const _0x1952e1=_0x1958;try{var _0x37cc3d=SpreadsheetApp[_0x1952e1(0x1b7)]()[_0x1952e1(0x242)](_0x1952e1(0x1c6));if(!_0x37cc3d)return _0x1952e1(0x1f0);var _0x3b66c3=_0x37cc3d[_0x1952e1(0x196)](_0x1952e1(0x1e2))[_0x1952e1(0x15c)]()[_0x1952e1(0x1a5)](String)['length']+0x1,_0x25926d=[];if(_0xf72a57===_0x1952e1(0x1a3))_0x25926d=processarOFX(_0x409b3d);else _0xf72a57===_0x1952e1(0x19b)&&(_0x25926d=processarXLSX(_0x409b3d));if(_0x25926d[_0x1952e1(0x24a)]>0x0){_0x25926d['forEach']((_0x4fd23c,_0x546bfb)=>{const _0x5da4fe=_0x1952e1;var _0x569324=_0x4fd23c[0x2]<0x0?_0x5da4fe(0x1ce):_0x5da4fe(0x187),_0x42b3f8=Math['abs'](_0x4fd23c[0x2]);_0x37cc3d[_0x5da4fe(0x196)](_0x3b66c3+_0x546bfb,0x2)['setValue'](_0x4fd23c[0x0]),_0x37cc3d[_0x5da4fe(0x196)](_0x3b66c3+_0x546bfb,0x3)[_0x5da4fe(0x1cb)](_0x4fd23c[0x0]),_0x37cc3d[_0x5da4fe(0x196)](_0x3b66c3+_0x546bfb,0x4)[_0x5da4fe(0x1cb)](_0x4fd23c[0x1]),_0x37cc3d[_0x5da4fe(0x196)](_0x3b66c3+_0x546bfb,0x7)[_0x5da4fe(0x1cb)](_0x1d87c3),_0x37cc3d[_0x5da4fe(0x196)](_0x3b66c3+_0x546bfb,0x9)[_0x5da4fe(0x1cb)](_0x569324),_0x37cc3d['getRange'](_0x3b66c3+_0x546bfb,0xa)[_0x5da4fe(0x1cb)](_0x42b3f8),_0x37cc3d['getRange'](_0x3b66c3+_0x546bfb,0xb)['setValue'](_0x5da4fe(0x1ab));});var _0x13961e=autoCategorizeNewRows(_0x3b66c3,_0x25926d['length']);return _0x25926d['length']+_0x1952e1(0x15d)+_0x13961e+_0x1952e1(0x218);}return _0x1952e1(0x228);}catch(_0x4149d1){return Logger[_0x1952e1(0x1a9)](_0x1952e1(0x1db)+_0x4149d1['toString']()),_0x1952e1(0x247)+_0x4149d1[_0x1952e1(0x23d)];}}function processarOFX(_0x35f503){const _0x538ae4=_0x1958;try{var _0x453a1e=[],_0x234f6a=_0x35f503[_0x538ae4(0x223)](/<STMTTRN>([\s\S]*?)<\/STMTTRN>/g);if(!_0x234f6a)throw new Error(_0x538ae4(0x1e9));return _0x234f6a[_0x538ae4(0x203)](function(_0x58e46b){const _0x389b0a=_0x538ae4;var _0xf65202=_0x58e46b[_0x389b0a(0x223)](/<DTPOSTED>(\d+)/),_0x1dff77=_0x58e46b[_0x389b0a(0x223)](/<MEMO>(.*?)<\/MEMO>/),_0x5ad5f0=_0x58e46b[_0x389b0a(0x223)](/<TRNAMT>([-\d,\.]+)/),_0x1a075f=_0xf65202?formatarDataOFX(_0xf65202[0x1]):_0x389b0a(0x18d),_0x43fd85=_0x1dff77?_0x1dff77[0x1]:_0x389b0a(0x221),_0x959676=_0x5ad5f0?parseFloat(_0x5ad5f0[0x1][_0x389b0a(0x1f3)](',','.')):0x0;Logger['log']('Transação\x20extraída:\x20Data:\x20'+_0x1a075f+_0x389b0a(0x186)+_0x43fd85+_0x389b0a(0x168)+_0x959676),_0x453a1e[_0x389b0a(0x241)]([_0x1a075f,_0x43fd85,_0x959676]);}),_0x453a1e;}catch(_0x3de1de){return Logger['log'](_0x538ae4(0x1e3)+_0x3de1de['toString']()),[];}}function formatarDataOFX(_0x384a5e){const _0x320c4e=_0x1958;return _0x384a5e[_0x320c4e(0x237)](0x0,0x4)+'-'+_0x384a5e['substring'](0x4,0x6)+'-'+_0x384a5e[_0x320c4e(0x237)](0x6,0x8);}function processarXLSX(_0x562f10){const _0x136f95=_0x1958;try{var _0x44da5f=XLSX[_0x136f95(0x217)](_0x562f10,{'type':_0x136f95(0x16c)}),_0x4f2f1e=_0x44da5f[_0x136f95(0x1a1)][0x0],_0x5e0ed4=_0x44da5f['Sheets'][_0x4f2f1e],_0x18950a=XLSX[_0x136f95(0x212)][_0x136f95(0x162)](_0x5e0ed4,{'header':0x1});return _0x18950a['slice'](0x1);}catch(_0xe1f5ce){return Logger[_0x136f95(0x1a9)](_0x136f95(0x185)+_0xe1f5ce[_0x136f95(0x176)]()),[];}}function autoCategorizeNewRows(_0x38fdd8,_0x37de59){const _0x40f4d7=_0x1958;var _0x522bc7=SpreadsheetApp['getActiveSpreadsheet']()[_0x40f4d7(0x242)](_0x40f4d7(0x1c6)),_0x1a6363=0x0,_0x119445={};if(_0x38fdd8>0x7){var _0x2dbdb5=_0x38fdd8-0x7,_0x16bb56=_0x522bc7[_0x40f4d7(0x196)](0x7,0x4,_0x2dbdb5,0x1)[_0x40f4d7(0x15c)](),_0x39c07c=_0x522bc7[_0x40f4d7(0x196)](0x7,0x8,_0x2dbdb5,0x1)[_0x40f4d7(0x15c)]();for(var _0x5cf6ef=_0x2dbdb5-0x1;_0x5cf6ef>=0x0;_0x5cf6ef--){var _0x26473b=_0x16bb56[_0x5cf6ef][0x0],_0x23c33c=_0x39c07c[_0x5cf6ef][0x0];_0x26473b&&_0x23c33c&&(_0x119445[_0x26473b['toString']()['toLowerCase']()]=_0x23c33c);}}var _0x32644=_0x522bc7[_0x40f4d7(0x196)](_0x38fdd8,0x4,_0x37de59,0x1)[_0x40f4d7(0x15c)](),_0x504746=_0x522bc7[_0x40f4d7(0x196)](_0x38fdd8,0x8,_0x37de59,0x1)[_0x40f4d7(0x15c)]();for(var _0x25545e=0x0;_0x25545e<_0x37de59;_0x25545e++){var _0x37cf9d=_0x32644[_0x25545e][0x0],_0x9eac88=_0x504746[_0x25545e][0x0];if(_0x37cf9d&&!_0x9eac88){var _0x551bec=_0x37cf9d[_0x40f4d7(0x176)]()[_0x40f4d7(0x20a)]();if(_0x119445[_0x551bec])_0x504746[_0x25545e][0x0]=_0x119445[_0x551bec],_0x1a6363++;else for(var _0x20961a in _0x119445){if(_0x551bec[_0x40f4d7(0x236)](_0x20961a)!==-0x1){_0x504746[_0x25545e][0x0]=_0x119445[_0x20961a],_0x1a6363++;break;}}}}return _0x522bc7[_0x40f4d7(0x196)](_0x38fdd8,0x8,_0x37de59,0x1)[_0x40f4d7(0x16b)](_0x504746),_0x1a6363;}function verificarAcessoPlanner(){const _0x6008d9=_0x1958;var _0x48ed6f=SpreadsheetApp[_0x6008d9(0x1b7)](),_0x2d3f72=_0x48ed6f['getSheets'](),_0x538bfd=_0x6008d9(0x178),_0x5370db=DriveApp[_0x6008d9(0x1ac)](_0x48ed6f[_0x6008d9(0x167)]())[_0x6008d9(0x234)]()['getEmail'](),_0x224f44=_0x6008d9(0x210)+encodeURIComponent(_0x5370db),_0x14ecf9=_0x6008d9(0x1ee)+encodeURIComponent(_0x5370db);try{var _0x2925c1=UrlFetchApp[_0x6008d9(0x1cd)](_0x224f44,{'muteHttpExceptions':!![]}),_0x1f4a08=JSON[_0x6008d9(0x22c)](_0x2925c1['getContentText']());if(_0x1f4a08[_0x6008d9(0x204)]!==_0x6008d9(0x1a2)){try{UrlFetchApp['fetch'](_0x14ecf9,{'muteHttpExceptions':!![]});}catch(_0x2c8d7d){Logger[_0x6008d9(0x1a9)]('Erro\x20ao\x20registrar\x20exclusão:\x20'+_0x2c8d7d[_0x6008d9(0x23d)]);}if(_0x2d3f72[_0x6008d9(0x24a)]>0x1)for(var _0x519421=_0x2d3f72[_0x6008d9(0x24a)]-0x1;_0x519421>0x0;_0x519421--){_0x48ed6f['deleteSheet'](_0x2d3f72[_0x519421]);}else _0x2d3f72[0x0][_0x6008d9(0x24c)]();var _0x36af8a=SpreadsheetApp[_0x6008d9(0x1fb)]();_0x36af8a[_0x6008d9(0x21d)](_0x6008d9(0x1bd),_0x6008d9(0x20d)+_0x538bfd,_0x36af8a[_0x6008d9(0x1d0)]['OK']),MailApp['sendEmail']({'to':_0x5370db,'subject':_0x6008d9(0x22e),'body':_0x6008d9(0x1b9)+_0x538bfd});var _0x2a0d3f=DriveApp['getFileById'](_0x48ed6f['getId']());_0x2a0d3f[_0x6008d9(0x1f6)](!![]),Utilities[_0x6008d9(0x1a8)](0x1388),_0x2a0d3f['setTrashed'](![]),_0x2a0d3f['setStarred'](![]),_0x2a0d3f['getParents']()[_0x6008d9(0x1aa)]()&&_0x2a0d3f[_0x6008d9(0x22b)]()[_0x6008d9(0x18a)]()[_0x6008d9(0x1ae)](_0x2a0d3f);}}catch(_0xc0af67){Logger['log']('Erro\x20ao\x20verificar\x20acesso:\x20'+_0xc0af67['message']);}}function verificarAcessoPlannerDiario(){const _0x53b1ec=_0x1958;var _0x95f51e=PropertiesService[_0x53b1ec(0x199)](),_0x44ba40=_0x95f51e[_0x53b1ec(0x219)](_0x53b1ec(0x1e0)),_0x27b38d=new Date()['toDateString']();_0x44ba40!==_0x27b38d&&(verificarAcessoPlanner(),_0x95f51e[_0x53b1ec(0x183)](_0x53b1ec(0x1e0),_0x27b38d));}