airsaylongcome:


Interesting stuff. I'm really interested in these analysis.

Quick one. Don't put the date like you have put in that spreadsheet. It can make analysis difficult in future. Instead, Create a column called Date and enter the Date there for each transaction/row.

oh wow, I just learned this. let me quickly do that. wow thanks so much, sir.

Emeskhalifa:


you sha no want make I link up with you sir

Lol! Even the guys I linked up with the Data giveaway you did, neither of them know me! You go shock. Na here and one other platform na hin we dey "meet". I kind of like it that way. No real reason.
I'm a bit active on the Programming section here so you go dey see my moniker well well

airsaylongcome:


As in... This one caught me "offside". Sniper fire everywhere. With laser guided bullets as soon as target is locked.

airsaylongcome:


Hahaha! You win!!
Just means I have to "Waka" with sense on these Nairaland streets... As I dey knack people head, people dey wait to busrt my own

So na BUSRT ur head dey do . Kpele

Nostradamus1:

So na BUSRT ur head dey do . Kpele

airsaylongcome:


Lol! Even the guys I linked up with the Data giveaway you did, neither of them know me! You go shock. Na here and one other platform na hin we dey "meet". I kind of like it that way. No real reason.
I'm a bit active on the Programming section here so you go dey see my moniker well well

Wow. Alright sir. I noticed that you frequent this section. Thank you so much for the help. Once I start my Program God's willing with HiiT, I'd still contact you for advice and solutions to any excel that is beyond me sir.

Thank you so much for what you did for me so far.

Sir Airsaylongcome boss good evening sorry I don come again, pls don't get tired of me.

Pls, how do I make the entire row in which a failed transaction appears to have its text color as red?

I have attached an image below. these were done manually (I changed their color one at a time, it could be a whole lot of work if one is dealing with a huge record.

Emeskhalifa:

my only problem is it doesn't have a future. what happens if tomorrow another government comes and abolishes it? what will I do?

About this, I'm almost certain that Agency Banking is here to stay. During the height of Corona Lock down, I was talking with a Ugandan friend living in Sierra Leone. He mentioned this Agency Banking stuff and how a lot of people are going into it there. At the time I was evaluating a Core Banking software and he had adapted the software to be able to do agency banking. He spent money to buy these POS machines and ATM card writer to test his changes. And when he did a demo for me it worked well. But me I was just a techie and did not see the value of what he was talking about. In fact to be frank, I did not think Nigerians would accept Agency Banking or that people would want to start up small businesses as Agency Banks. I was damned wrong.

I don't think a future government will ban it. MTN is diving into this big time. In Nigeria, Finance is a big driver of Tech innovations so I expect it to be available for long. Whether it will be sustainable long term is a different matter because small businesses like yours will start competing by reducing their charges

Emeskhalifa:
Sir Airsaylongcome boss good evening sorry I don come again, pls don't get tired of me.

Pls, how do I make the entire row in which a failed transaction appears to have its text color as red?

I have attached an image below. these were done manually (I changed their color one at a time, it could be a whole lot of work if one is dealing with a huge record.

Let's link up on this around 8pm tonight. Right now I dey "lick" some bottles of stout so my brain don shift small

But it's straightforward stuff. Something called conditional formatting. But we go link up. Make I finish my "licking" first

airsaylongcome:


About this, I'm almost certain that Agency Banking is here to stay. During the height of Corona Lock down, I was talking with a Ugandan friend living in Sierra Leone. He mentioned this Agency Banking stuff and how a lot of people are going into it there. At the time I was evaluating a Core Banking software and he had adapted the software to be able to do agency banking. He spent money to buy these POS machines and ATM card writer to test his changes. And when he did a demo for me it worked well. But me I was just a techie and did not see the value of what he was talking about. In fact to be frank, I did not think Nigerians would accept Agency Banking or that people would want to start up small businesses as Agency Banks. I was damned wrong.

I don't think a future government will ban it. MTN is diving into this big time. In Nigeria, Finance is a big driver of Tech innovations so I expect it to be available for long. Whether it will be sustainable long term is a different matter because small businesses like yours will start competing by reducing their charges

It's safe to make a long term plan using the agency banking as source of livelihood/Means of survival then

airsaylongcome:


Let's link up on this around 8pm tonight. Right now I dey "lick" some bottles of stout so my brain don shift small

But it's straightforward stuff. Something called conditional formatting. But we go link up. Make I finish my "licking" first

Hahahahaha Alright boss thanks.

Emeskhalifa:


Hahahahaha Alright boss thanks.

So the method I've found just highlights the cells with Failed, not the entire row. Maybe someone reading this thread has an idea how to do that?

airsaylongcome:


So the method I've found just highlights the cells with Failed, not the entire row. Maybe someone reading this thread has an idea how to do that?

Good morning boss. How do the highlighting pls?

Emeskhalifa:


Good morning boss. How do the highlighting pls?

https://www.ablebits.com/office-addins-blog/2014/06/10/excel-conditional-formatting-formulas/#formula-text-values

If you still have issues let me know

airsaylongcome:


https://www.ablebits.com/office-addins-blog/2014/06/10/excel-conditional-formatting-formulas/#formula-text-values

If you still have issues let me know

Good afternoon boss. Thanks so much for this. This will go a long way to broaden my knowledge of excel. Thank you sir.

Boss Airsaylongcome good morning sir. I just want to say thank you for all the help, the accuracy of this solution is 99%.

Do you know that just yesterday when I applied it, I discovered three of my sales rep were stealing from the profit?

one took 50% of the profit the other took 1k and another staff took 1k. I was speechless.
it left me heartbroken, coz the one that took 50% happens to be someone I could swear with my life that she is 100% honest. she could not say anything this morning rather than cry and ask for forgiveness.

Emeskhalifa:
Boss Airsaylongcome good morning sir. I just want to say thank you for all the help, the accuracy of this solution is 99%.

Do you know that just yesterday when I applied it, I discovered three of my sales rep were stealing from the profit?

one took 50% of the profit the other took 1k and another staff took 1k. I was speechless.
it left me heartbroken, coz the one that took 50% happens to be someone I could swear with my life that she is 100% honest. she could not say anything this morning rather than cry and ask for forgiveness.

50% profit stolen! And that's gross profit o. You haven't removed selling expenses like staff salary and "rent" for the space you are operating from.

Me I've always believed in computerising any business no matter the size. I had a a friend in University years back. He was a hot head like me. Hotter headed sef.

Way back before data science became a trend he said to me: "Santos (that was my nickname back in the day) , the witchcraft is in the data. You go see other businesses dey accuse successful business say na witchcraft dem dey use. Whereas that successful business na sales data dem dey look to make forecasts and set targets"

This was back in 2009. Man ran into trouble again at that Uni (he had previously had trouble at his first Uni for questioning a lecturers solution to a question). Managed to get his transcript just before school Disciplinary Committee suspended him for questioning Dean of Student Affairs. Got admitted into a UK uni and is now doing very well in the UK.

The witchcraft is in the data. That stuck with me ever since.

I'm happy you have been able to identify that your business is being attacked by your employees. Again if I was a consultant, I would advise you to set daily targets for each of your outlets. Anything over the targets, have an agreement to share the profit in some ratio with the staff.

Note that your staff may have their own POS terminals at your outlets running it as their "side hustle". That's something you have to consider and have an antidote for. I have previously consulted for a bar/nightclub and business owner was shocked to find out that his staff were selling their own inventory of drinks inside his club! He was only able to find that out when I suggested that he should reconcile sales based on category of payments. All cash sales should be reconciled separately from all POS sales.

Emeskhalifa:

na hin be say first thing I'd do once I get to Lagos by November na to open POS outlet before heading to HiiT be that

Definitely, you fit even forget skill sef

Meanwhile this thread >>>

airsaylongcome:


50% profit stolen! And that's gross profit o. You haven't removed selling expenses like staff salary and "rent" for the space you are operating from.

Me I've always believed in computerising any business no matter the size. I had a a friend in University years back. He was a hot head like me. Hotter headed sef.

Way back before data science became a trend he said to me: "Santos (that was my nickname back in the day) , the witchcraft is in the data. You go see other businesses dey accuse successful business say na witchcraft dem dey use. Whereas that successful business na sales data dem dey look to make forecasts and set targets"

This was back in 2009. Man ran into trouble again at that Uni (he had previously had trouble at his first Uni for questioning a lecturers solution to a question). Managed to get his transcript just before school Disciplinary Committee suspended him for questioning Dean of Student Affairs. Got admitted into a UK uni and is now doing very well in the UK.

The witchcraft is in the data. That stuck with me ever since.

I'm happy you have been able to identify that your business is being attacked by your employees. Again if I was a consultant, I would advise you to set daily targets for each of your outlets. Anything over the targets, have an agreement to share the profit in some ratio with the staff.

Note that your staff may have their own POS terminals at your outlets running it as their "side hustle". That's something you have to consider and have an antidote for. I have previously consulted for a bar/nightclub and business owner was shocked to find out that his staff were selling their own inventory of drinks inside his club! He was only able to find that out when I suggested that he should reconcile sales based on category of payments. All cash sales should be reconciled separately from all POS sales.

Apologies for replying late boss. Have been busy offline.

But wow, you just opened my eyes to something I never thought of. What if they have their separate termina for side hustle since now they can't easily take money from the business anymore
I will consider placing them on target and come with a sharing formula once they go past the target

Boss Airsaylongcome good morning sir.
It's been a while, how is everything sir
I have been enjoying that your formula, there is no room to take even one Naira again except if the transaction wasn't carried on the POS I gave them which I do send people they don't know to make withdrawal randomly and bring back the pos receipt so I'd know which pos they are using.

You won't believe it sir, one of my staff stopped working for some flimsy excuses. Later on, I discovered he stopped coz it became almost impossible to take money from the business since we implemented that formula.
Honestly I'd remain indebted to you sir. I really appreciate it boss


Meanwhile, I am humbly seeking your opinion on how to carryout this excel computation in the best way because the method I used seems like it will not allow me to carry out some calculations easily.
Picture is below sir

Emeskhalifa:
Boss Airsaylongcome good morning sir.
It's been a while, how is everything sir
I have been enjoying that your formula, there is no room to take even one Naira again except if the transaction wasn't carried on the POS I gave them which I do send people they don't know to make withdrawal randomly and bring back the pos receipt so I'd know which pos they are using.

You won't believe it sir, one of my staff stopped working for some flimsy excuses. Later on, I discovered he stopped coz it became almost impossible to take money from the business since we implemented that formula.
Honestly I'd remain indebted to you sir. I really appreciate it boss


Meanwhile, I am humbly seeking your opinion on how to carryout this excel computation in the best way because the method I used seems like it will not allow me to carry out some calculations easily.
Picture is below sir

What calculation are you trying to do? It's not very obvious from the spreadsheet

Emeskhalifa:

lolz it is everywhere. even here POS are just scattered around like I said boss, na game of numbers remain wey all of us wey dey do the business dey do now



just like you helped me without knowing me, I do hope others will see this and learn from it.

thanks one more time, God bless you abundantly sir.


you sha no want make I link up with you sir you may have your reasons and I won't question that, I will keep your moniker at heart and will always seek for your help sir. also when I enter Lagos for my training, will notify you sir. Thank you very much sir

This thread is so helpful... I have sent you a WhatsApp message boss...