Tuesday, February 15, 2011

Back in time

 

Funny how you can go from customer to customer, and here you are again…

  • Timeframes that are impossible (for them)
  • Customer who think they can keep up
  • Old services which are unstable
  • Managers who are hamstrung
  • Technology that is untested
  • Staff who are apathetic
  • Network that is failing
  • Patches on band aids

But we need to move X to Y because of Z, so lets give it a red-hot-go…

What could go wrong?

Tuesday, February 08, 2011

Invert text in a cell

 

If cell A1 contains:
microsoft excel

The formula/function in cell B1:
=ReverseCell(A1,TRUE)

returns:
lecxe tfosorcim

 

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Adding the Macro
1. Copy the below macro, by highlighting the macro code and pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Press the keys ALT+Q to exit the Editor, and return to Excel.

Code:

Option Explicit
Function ReverseCell(Rcell As Range, Optional IsText As Boolean)
'http://www.ozgrid.com/VBA/ReverseCell.htm
'Enter the function like this for text:
'=Reversecell(A1,TRUE)
'Or either of the ways below for numeric data
'=Reversecell(A1,FALSE)
'=Reversecell(A1)
'
Dim i As Integer
Dim StrNewNum As String
Dim strOld As String
strOld = Trim(Rcell)
For i = 1 To Len(strOld)
  StrNewNum = Mid(strOld, i, 1) & StrNewNum
Next i
If IsText = False Then
  ReverseCell = CLng(StrNewNum)
Else
  ReverseCell = StrNewNum
End If
End Function

 

 

Came from : http://excel.bigresource.com/Track/excel-cBcjrDfS/ thanks !

Thursday, February 03, 2011

We are writing this letter on behalf of x-y-z Inc

 

Dear x y z Administrator:

We are writing this letter on behalf of x y z Inc., ("x y zPictures") who owns certain rights under copyright law in the title x y z.

You are receiving this notice because your Internet account was identified as having been used recently to copy and/or distribute illegally the copyrighted motion pictures and/or television shows listed at the bottom of this notice. This notice provides you with the information you need in order to take immediate action that can prevent serious legal and other consequences. These actions include:

1. Stop downloading or uploading without authorization any motion pictures or TV shows owned or distributed by x y z ; and

2. Permanently delete from your computer(s) all unauthorized copies you may have already made of these movies and TV shows.

If this notice is being received by an Internet Service Provider (ISP), please forward the notice to the individual associated with the activities.

The unauthorized distribution or public performance of copyrighted works constitutes copyright infringement under the Copyright Act, Title 17 U.S Code Section 106(3)-(4). This conduct may also violate the Berne Convention for the Protection of Literary and Artistic Works and The Universal Copyright Convention, as well as bilateral treaties with other countries that allow for protection of x y z copyrighted works even beyond U.S borders.

Copyright infringement also violates your ISP’s terms of service and could lead to limitation or suspension of your Internet service.  You should take immediate action to prevent your Internet account from being used for illegal activities.

An MPAA website, www.respectcopyrights.org, offers step-by-step instructions to ensure that your Internet account is not being used to violate the copyright laws.  Also, the site can point you to an array of legal choices for enjoying movies and TV shows online. You can also learn there how theft of motion pictures and TV shows damages our economy and costs thousands of Americans their jobs.

Please contact us at the above listed address or by replying to this email should you have any questions.

We are providing this notice based on our good faith belief that the use of motion pictures and television programs owned by x y z Industries Inc. in the manner complained of is not authorized by the copyright owners, their agents, or the law.  The information in this notification is accurate. Under penalty of perjury, we are authorized to act on behalf of the owners of the exclusive rights that are being infringed.  This letter is without prejudice to the rights and remedies of Columbia Pictures, all of which are expressly reserved.

We appreciate your assistance and thank you for your cooperation in this matter.  In your future correspondence with us, please refer to Case ID x y z.

Your prompt response is requested.

Respectfully,

D. Brewer
Enforcement Coordinator
Peer Media Technologies, Inc.
copyrightqs@mediasentry.com

------------------------------

INFRINGEMENT DETAIL
--------------------

Infringing Work: x y z
First Found: 31 Jan 2011 03:08:14 EST (GMT -0500)
Last Found: 31 Jan 2011 03:08:14 EST (GMT -0500)
IP Address: x y z
IP Port: 51413
Protocol: BitTorrent
Torrent InfoHash: x y z
Containing file(s):
x y z .[x y z.com].torrent (x y z bytes)

Blog Archive