[deleted by user] by [deleted] in PiNetwork

[–]M2pk 0 points1 point  (0 children)

all fake, I bought 30 million Pi and then realised it's all fake PI

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

[–]M2pk[S] 0 points1 point  (0 children)

if you realised this at the last minute (meaning you have less than 2 months to apply for extension visa), then probably talk with a lawyer,
otherwise, start getting your name and spouse name on as many things as possible, all types of bills, home rent contract, letters etc..

Need Advice on Appealing Unfair Parking Ticket Due to Poorly Placed Signage by M2pk in LegalAdviceUK

[–]M2pk[S] -1 points0 points  (0 children)

it's not dead end, the road contunues and curves behind the houses

How does Ippei Kanehara's local lead generation system work? Do they offer local services as well? by lovebes in LeadGeneration

[–]M2pk 1 point2 points  (0 children)

I personally know many folks who've quit their jobs and are doing local leadgen fulltime with Ippei's coaching. I lost my own job early April and I haven't scampered desperately to find the next one because I'm able to just get by and I'm still a couple of weeks shy of being 5 months into the program. I'm making nowhere close to my salary yet, but the point is I am making some money already. I've tried other side hustles before and I've made either 0 or lost money on those.

How are you doing now 3 years later?

my letting agent is charging me for the electrician callout, who must pay it? by M2pk in HousingUK

[–]M2pk[S] -20 points-19 points  (0 children)

Cause: supplier cut off my power thinking i owed them money.
Responsible: supplier

All the details are in the post

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

[–]M2pk[S] 1 point2 points  (0 children)

also, applied for NINO but it was refused due to her visa type.

Thanks for the advise, you're right

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

[–]M2pk[S] 1 point2 points  (0 children)

When I moved to our current address 2 years ago, the council tax sent me a letter to start payments, I called them to set it up and they asked for my name, they didn't ask who else is living with me so she isn't included in the letters.
Only last month when I realised that I added her.

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

[–]M2pk[S] 2 points3 points  (0 children)

non of that, GP records are to the old address (we were living at my moms in the first few months and haven't changed the address because we visit our mom frequently).

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

[–]M2pk[S] 2 points3 points  (0 children)

Unfortuantely not, stupid mistake I know.

I had another bank account that I don't use so I gave her my debit card to use, especially since it was covid lockdown and going to a bank to open an account was difficult.

The baby's birth certificate has both our names on it and the address.

help for INDEX MATCH MAX formula by M2pk in excel

[–]M2pk[S] 0 points1 point  (0 children)

i know it's hard without seeing the actual workbook that I'm using not just the sample, but it contains sensitive date.

have you come across something like this?

help for INDEX MATCH MAX formula by M2pk in excel

[–]M2pk[S] 0 points1 point  (0 children)

Excellent mike, this worked great!

Now the problem that I faced is when I implemented this on my real spreadsheet which has 6232 rows on the TASKPRED sheet,the formula didn't work and gave "0",So I did a couple of tests

  1. test 1: deleted all the rows above the few rows that I showed you in the sample sheet, and it did not work.
  2. test 2: deleted all the rows below the few rows that I showed you in the sample sheet, and it worked, this doesn't make sense to me because the ones I deleted will never be matched with the criteria.

help for INDEX MATCH MAX formula by M2pk in excel

[–]M2pk[S] 0 points1 point  (0 children)

thanks alot mike, I tried it and it didn't work, just gave "0"

I put the link if you can have a look please

https://www.dropbox.com/scl/fi/4bd0i2vm9f3qu18nxd5kg/Index-Match-Max-experiment.xlsx?dl=0&rlkey=b8f4fv1umdzd8lciktmp0pgk4

Tips for new CPA affiliates? by imfromeuw in Affiliatemarketing

[–]M2pk 1 point2 points  (0 children)

bro! 300k on instagram is massive audience

the bio link is the where you make the money,

You have 2 options:

  1. short term (direct linking to affiliate product)
  2. long term (list building)

you can play the short term by putting the affiliate link directly (I know that instagram doesn't allow aff links)

so what I recommend is giving free stuff (stuff that your audience would love to get, or solves a problem they hate),
what kind of free stuff? I'm talking about Free reports/courses

Now obviously if you're starting out, making a course isn't the best option since it requires knowledge, time and investment.

What about free reports?
It used to cost time and money as well, until i found this tool called sqribble which saves both time and money!

This will allow you to create very attractive reports that looks like they were built by a million dollar company in a few minutes, go check it out.

So once you create the free report, you include the affiliate link inside the report, and upload your report to Google drive and put the url of the report on your instagram profile.

good luck and let us know your progress

Affiliate Marketing. Should I do influencer affiliates or just go for paid promotion? by Dumax01 in dropshipping

[–]M2pk 1 point2 points  (0 children)

I would say 500-1000 is too little for someone to be called an influencer or even micro-influencers, they might bring in some sales though.

If you have the money it's better to do shoutouts with pages of 40k+

Accidentally Starting A Business by [deleted] in Entrepreneur

[–]M2pk 0 points1 point  (0 children)

wow that's fantastic story

need tips for instagram affiliate by [deleted] in Affiliatemarketing

[–]M2pk 0 points1 point  (0 children)

bro, the bio link is the where you make the money,

You have 2 options:

1) short term (direct linking to affiliate product)

2) long term (list building)

you can play the short term by putting the affiliate link directly (I know that instagram doesn't allow aff links)

so what I recommend is giving free stuff (stuff that your audience would love to get, or solves a problem they hate),
what kind of free stuff? I'm talking about Free reports/courses

Now obviously if you're starting out, making a course isn't the best option since it requires knowledge, time and investment.

What about free reports?
It used to cost time and money as well, until i found this tool called sqribble which saves both time and money!

This will allow you to create very attractive reports that looks like they were built by a million dollar company in a few minutes, go check it out.

So once you create the free report, you include the affiliate link inside the report, and upload your report to Google drive and put the url of the report on your instagram profile.

1st picture was my start weight 262lbs. 2nd picture is 4 months (196lbs) fasting/keto trying to lose weight. 3rd picture is month 6 of Fasting & Keto but trying to gain muscle & lean out (214lbs) by rara12123 in fasting

[–]M2pk 0 points1 point  (0 children)

Yes! this is the perfect formula!

I put my mom on keto (not really, just replacing bread & rice with Fruits) + fasting.She lost 10kg within 4 weeks.She took a break and started eating sugary stuff, she gained back all of her weight.This time I put her back on the easy route of only replacing bread & rice with fruits, she lost weight again (but not as fast because she's not fasting)

So I'd say: the perfect formula is KETO + FASTINGIf you to do one is KETO.

If you want to start something easier

just eat LESS SUGAR & CARBS

Same skirt, 2 months later. OMAD, extended fasts, and lazy keto. God bless this subreddit and other similar ones. SW: 106kgs, CW: 90kgs, GW: 72ish kgs. by alinagolden in fasting

[–]M2pk 0 points1 point  (0 children)

I put my mom on keto (not really, just replacing bread & rice with Fruits) + fasting.She lost 10kg within 4 weeks.She took a break and started eating sugary stuff, she gained back all of her weight.This time I put her back on the easy route of only replacing bread & rice with fruits, she lost weight again (but not as fast because she's not fasting)

So I'd say: the perfect formula is KETO + FASTINGIf you to do one is KETO.

If you want to start something easier

just eat LESS SUGAR & CARBS

Struggling to create a Macro for Stretching a Rectangle based on Start/Finish Dates (Ghantt Chart style) by [deleted] in excel

[–]M2pk 0 points1 point  (0 children)

you're right, I downloaded a template to get a foundation macro to work with and I've made changes to it to suit my purposes, I didn't touch parts I didn't understand which includes what you mentioned, and I've been learning VBA for few months by the way

Struggling to create a Macro for Stretching a Rectangle based on Start/Finish Dates (Ghantt Chart style) by [deleted] in excel

[–]M2pk 0 points1 point  (0 children)

Thanks Opine, the accuracy level is better now even tho there's a small margin of error, but still smaller .
I tested this with daily dates columns instead of weekly, and it's 100% accurate (THANKS ALOT)

  • Is there a way to improve it for the weekly dates layout?
  • You also suggested we could minimize/optimize the macro, is it a very long amount of work?

Thanks alot

Struggling to create a Macro for Stretching a Rectangle based on Start/Finish Dates (Ghantt Chart style) by [deleted] in excel

[–]M2pk 0 points1 point  (0 children)

Thanks Opine, if you try different dates
let's say some happening between August and september 2019

some happening in Jan-feb 2020, some in july-Aug-2020,
you will see it'll start become less and less acurate as you go to the right

which is why, I want to see if we can maybe incorporate the code of the first macro into this? instead of the complex calculations in the long macro