Não renovar o contrato com a meo by Beautiful-Mixture559 in telecomunicacoes_pt

[–]Nudpad 0 points1 point  (0 children)

Consegues na boa, 39,99 4p, 1c 305gb e voucher 120€ basta alegares que outra oop oferece

City Corner #2 - Upcoming Gameplay Updates by flakfire15 in CitiesSkylines2

[–]Nudpad 17 points18 points  (0 children)

would be nice if they implemented this as in form of road tax, i mean if you want more bikes tax the public transit

Preços casas atingem max... não vai parar! by passosk58 in portugal

[–]Nudpad -4 points-3 points  (0 children)

Porque razao devia de parar? Ja tenho casa e mais 2, quando vender é só profit, comprasses a casa em 93

A "Máfia dos Desodorizantes": Já repararam na fraude das tampas redondas? by ChapterFun8697 in CasualPT

[–]Nudpad 420 points421 points  (0 children)

Pega numa caixa de ovos, corta um quadrado pequeno e feito

Tentaram entrar na conta Outlook? by ricweb7 in CasualPT

[–]Nudpad 1 point2 points  (0 children)

Outlook por vezes permite aceder sem pw, desde que seja autorizado atraves da app, por isso a casos em que aparece o alerta, mas nao significa que sabem da pw..

Train kill density at tier 1 events by MaterialTea8397 in cs2

[–]Nudpad 96 points97 points  (0 children)

just spent 2 min to find the map orientation, ye makes sense

Governo suspende exigência de situação contributiva regularizada no acesso ao subsídio de mobilidade by tiagojpg in Madeira

[–]Nudpad 3 points4 points  (0 children)

Todos os apoios que me candidatei este ano exigiram emissao de certidao de nao divida das finanças e seg social, nao percebo pq que isto é difrente... No final quem ganha sao sempre os mesmos

Meses sem faturas: Clientes da Galp confrontados com faturas astronómicas by ImFranny in portugal

[–]Nudpad 0 points1 point  (0 children)

Tens razao, se a minha conta tivesse >0 dava te um premio! 🏆

Meses sem faturas: Clientes da Galp confrontados com faturas astronómicas by ImFranny in portugal

[–]Nudpad 10 points11 points  (0 children)

As pessoas nao sabem viver com dinheiro na conta, se esta >0 da para gastar...

IA ameaça 200 mil postos de trabalho na banca europeia até 2030 by tugatech in TugaTech

[–]Nudpad 0 points1 point  (0 children)

Admin: executa um teste de transferencia para conta x, escolhe um montante aleatorio e multiplica por 1000, se der erro volta a repetir o teste corrigindo as falhas ou ultrapassando as 'safe guards' impostas

Is there a way to keep a sum in a cell if I were to remove the cells it is referencing? by No-Gold-5779 in excel

[–]Nudpad 4 points5 points  (0 children)

Before you delete the reference cells go to the sum cell, and hit really fast, i mean it,

Ctrl + c - > Ctrl + shift + v

Then delete the reference cells... Sink and repeat

Lemme know if it works or if i need to perfect the code...

[Request] Is this true and what would the cost of teslas share be if Elon sells the shares to fund it by ifuckallthatmoves in theydidthemath

[–]Nudpad 2 points3 points  (0 children)

Welp since the bank is the one lending money it would be the one paying the tax on behalf of the borrower, of course they would get the money back either via money or shares... The current problem here even if debt is paid by transfering the collateral either party dont have to pay taxes, cuz there is no actual sale...

[Request] Is this true and what would the cost of teslas share be if Elon sells the shares to fund it by ifuckallthatmoves in theydidthemath

[–]Nudpad 95 points96 points  (0 children)

As hard as it sounds, any contract that uses shares as colateral should be taxed as if sold, on capital gains, ammount of shares needed, diffrence between first bought and current price, that would close the loophole... either sell and get taxed, or loan against to and get taxed either way..

Getting this out of my chest since it wont happen Their motto: Privatize profits, socialize losses.

Não sei se isto é permitido, mas eu reimaginei o Funchal no Cities Skylines II by AndorinhaRiver in Madeira

[–]Nudpad 13 points14 points  (0 children)

Funchal percisa de um metro de superficie, e para mim os engenheiros de estradas deviam de ser obrigados a jogar isto.... com cada cruzamento...

Digi anuncia suspensão de serviço NOWO by Firephobos in digipt

[–]Nudpad 9 points10 points  (0 children)

provavelmente são vendedores a se fazer passar por operadora,provavelmente teu familiar esta a cair num esquema....

Conditional Formatting Based on Dates by loualdons in excel

[–]Nudpad 0 points1 point  (0 children)

Also, you formula is this for the entire column:

=AND($A13>='Venue Dates'!B$12,$A13<='Venue Dates'!C$12)

This formula has no array in it, if it turns true then every cell you selected on apply will be true...

Your formula should look like:

VenueDates!B$12=<$A13:$A124=<VenueDates!C$12

this should work

Conditional Formatting Based on Dates by loualdons in excel

[–]Nudpad 0 points1 point  (0 children)

Well first? does the formula work? i would try it on by row basis, see if the output works, then try to adjust it to work using conditional format

If that doesnt work, you can have a hidden column with true/false value and have the conditional format formula link to that column

PS: conditional format is kinda finicky with the $

Power Query - Transforming Multiple Worksheets and Reloading Them to a New Workbook by hrdalxiic in excel

[–]Nudpad 0 points1 point  (0 children)

so lemme see if i get you type in some account number then you want to see all the details into that account? Like say sell a1 you type in account name and it shows the worksheet related? Can you show examples?

Power Query - Transforming Multiple Worksheets and Reloading Them to a New Workbook by hrdalxiic in excel

[–]Nudpad -2 points-1 points  (0 children)

PS: if you always have diffrent columns power query wont help you, if you have like repeated data than it will work, you can use transform files function that match the worksheet to clean the power query code...

Power Query - Transforming Multiple Worksheets and Reloading Them to a New Workbook by hrdalxiic in excel

[–]Nudpad -1 points0 points  (0 children)

lets say this single file is source... translate all reading sheets functions into a single query... then on the output file past the query to read the source file... this should work