Wednesday, January 20, 2010

How To Use Galileo Ct-1380

A landslide Scarenna ... or maybe not?

Scarenna is the historic cliff that lies between Wort and Canzo ... is where I started to climb ... where many have taken the first steps.
Last year I remember a banner hanging on the rock ... it said "No to the quarry."
seemed to want to * close * the cliff that served as valuable limestone to produce cement ... Then nothing.
Sunday's surprise, the first 100 meters of the cliff ... the road is blocked, a landslide invades the roadway of the small road that runs along the climbing wall.
Frana natural ... * intended or landslide?
think evil is a sin ... but we often guesses.
And you how you feel?

hello
r
ps The photo of the landslide



Tuesday, January 12, 2010

Wat To Lock For In A Spotting Scope

initial capital

PROPER Excel function converts all the words of the string passed as its argument in lower case with capitalized words ... is not very useful except for a list of names and surnames.
The function (UDF also) that I propose to convert a text extended to comply with certain rules of grammar. The text passed as an argument it is changed only in the beginning letters of words, letters, following a carriage return and in the letters that follow a period, exclamation point and a question mark. Following a routine to test the result. Would it be possible
do the trim first or conversion lcase ... but if you want, in fact, if you want you can do before passing the argument to the function. Greetings

r


MaiuscoInizialeMigliorato Function (
_ ByVal s As String) As String '
'__________________________________________
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'by Robert Mensa nick r
'__________________________________________
' ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Dim v, i As Long
Dim re As Object
Set re = CreateObject("vbscript.regexp")
re.Pattern = _
"(^ _
"lowercase." & _ VbNewLine & _

"become the tiny capital"
& _ "if a sentence begins!" & _ VbNewLine & _

"become the tiny capital" & _
"after a point, point" & _
"exclamation or a question mark" & _ vbNewLine & _

"the become sensitive case "& _
" after a break. "
MsgBox s, vbOKOnly, "before"
MaiuscoInizialeMigliorato MsgBox (s),
_ vbOKOnly, "After" End Sub



Monday, January 11, 2010

How To Hack Poptropica For Credits

Cavandoli improved test ... the second test with expert Excel

's colleagues and friends coming for the second Cavandoli Test ... download the file at this link


fun :-) greetings

r

ps
then scroll to the bottom there is also a portrait of me :-) I had to paint by hand
nearly 100,000 cells
you believe it? :-)

Friday, January 8, 2010

Naruto Futanari Kokoro Tenshin

Strange Attractors (Peter de Jong - Excel Charts)

few days ago nell'NG excel, Joan asked if we could see a strange attractor in excel. I honestly did not even know what they were ... so I followed the link where you explained what they were (
link to Wikipedia, and others ...
link, link2

).

Soon I am passionate about this game of twists and randomness ... so I prepared a folder Excel which allows you to * play * in the true sense of the word, the curves of Peter de Jong ... Then I found a version and I have invented two more (the number 3 and 4) the right to make the game more varied

:-) The file that you can download by clicking here

(the file contains macros to be saved and to avoid errors in carrying out the same) you will find everything you need to create random sets, save the most beautiful, automatically create charts of different colors and with different number of points ... from 10,000 to 200,000 ... you should play with a set of 10,000 points for any increase after the number of points, this will allow for quick updates or see the graph as a result returns the same series with the variants 2, 3 or 4. An example
the link

discussion nell'NG
the link in the youth blog


Greetings
r

Monday, January 4, 2010

Flat Irons For Hair/ J C Penney

Currency Converter (Add-in Excel 2003)

I am surviving the holiday season :-)

What I propose is a tool for converting currencies.
The add-in can be downloaded by clicking here
.
on how and where to save the add-in to see the Help section:
"Troubleshooting add-ons"

Once the file is saved you can add references from the menu Tools-> Add-ons ... if you can use the Browse button to locate the file.
an example can easily illustrate what happens ... this is a string that can perform a search in google type convert a euro in U.S. dollars:


http://www.google.it/search?q=1+EUR+in+USD
page that opens you will see the result at the top of the instrument calculator google ... that number is what is recovered as a result of the conversion from the add ... :-)

In this way we delegate to update the Google index conversion ... a heartfelt thanks :-)

Once you add the component to open Excel will create a toolbar is not anchored with a button to display the Form of the drive.






Combo are displayed in two lists of currencies used in the conversion. In the first column you will find the 3-letter code that refers to the currency (eg EUR for the euro), the currency name in the second and third countries in which it is used.

clicking on the column headers to sort you get alternately increasing and decreasing respect for each click on the title you want to sort.

close the form the conversion result is copied into memory, so it is available to be pasted into the cell.

not choosing any value from the second combo, the conversion will happen in the defoult €.

It 'goes without saying that for it to work properly Internet Explorer must be installed and the computer must be connected to the Internet. The VBA project is not protected, the code is not commented, although it will be easy to understand how it works.
What about ... fun

Greetings
r

ps



clicking here you can download the workbook (xls) ... as you can then save as Excel add-in, so the xla file is automatically saved to the folder which contains the AddIns