Friday, July 31, 2015

Can be Improved - Soap story

When ever I start using new soap, it leaves with me question to dispose of the leftovers (scrap pieces that can not be handled ! so goes waste) .... there are many ways people has written all over the web for reusing these leftovers to make new soap bar or liquid soap for hand wash or putting into a nylon bag ...

but that is not the ultimate solution, how this situation can be improved ? is there any better way to remove this wastage (all over world) ?

can the concept being changed itself to eliminate the root cause ?

one of the design modification which i can suggest of is ... to modify the base design of soap bar itself ..

see image below, which indicates recycled paper insert at the core of soap bar, which is embedded at the time of manufacturing itself, now after use, when u reach upto this paper core, u will still be able to handle the piece and leftover is simple paper which you can through of .... if needed it can be thin water proof coated paper so that it lasts in water use. and one more advantage this will have, it will provide strength to the remaining to hold in hand, as the soap become think it becomes difficult to hold in hand and normally collapses, the insert will provide adequate strength to it.



what do u say ?

any other idea ?

Tuesday, July 28, 2015

How to decode Rediffmail link

Many times if u received some link in rediffmail, it is encoded by rediff in some format which may not be accepted by proxy giving security warning message, so here is macro written to convert it to actual URL.

So here is what u need to do :-

step 1) Copy and paste the following two code snippets into module section of VB editor window

=== copy above below (without these lines)===

Sub Convert_Link()

' programmed by mdp

Call FR("%3A", ":")
Call FR("%2D", "-")
Call FR("%3D", "=")
Call FR("%2F", "/")
Call FR("%3F", "?")
Call FR("%5F", "_")
Call FR("%2E", ".")
Call FR("%26", "&")


Call FR("http://www.rediffmail.com/cgi-bin/red.cgi?red=", "")

End Sub

Sub FR(F_What, R_This)
Cells.Replace What:=F_What, Replacement:=R_This, LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub

=== copy above code ===

step 2) save this file with some name
step 3) when u receive link through rediff account, copy link to this excel sheet in any cell and press run macro button, then it will show convert_link program name, run that program, which will automatically replace this link with decoded link, copy this link and paste into ur browser :-)

so enjoy :-) cheers !!