Sunday, December 6, 2009

Las Vegas Hotel Deals

Walter Mitty - Antimedale (Lecco)

the morning, 7.30 in Lecco ... Guido is the first to arrive and Jeck ...
James is not the meeting, a hug and lots of pats on the back, has not changed (except the beard whitened the artist Jack :-) ... Jack the fool ... to bar them immortal, a bianchino early in the morning to start your day.






Guido is an accident ... fell a little 'time ago ... it broke my ribs and now resumed for the first time to climb ... I forgot ... fell down stairs while :-) mica scale ... Guido oh ... however they are going to do Chiappa Marco and I were aiming to Bonatti in Medal but from below we see that the strike is still wet (it rained Friday) ... so we decide to Walter Mitty nell'antimedale.

It attacks the way the instructors ... after the first two pitches cross to the right for 100 yards catching up to the pillar on the right channel ... attacks via the right where the tree ... In all, 4 more shots ... The first wakes you out, makes anche un po' freddo ... Via nel complesso faticosa (per il nostro livello di allenamento) diciamo che le difficoltà sono di 5°-6° sostenuti tirando un po' di chiodi ... in libera credo 6c ... noi alla libera non ci pensiamo nemmeno e già così ne usciamo rotti ... nella via uso anche alcuni nuts (medio piccoli) e frend (medio piccoli) ... non l'avevo ancora ripetuta da quando è stata richiodata ... e come già accaduto ... snaturata ... così alcuni passaggi sono più obbligati ... sul terzo tiro sono aggiunti due fittoni su una placca a lato del percorso originale (un diedro giallo con alcuni frigoriferi appoggiati) ... la placca sembra dura quindi rimango sui blocchi ... fare attenzione a cosa prendo in mano mi dico ... you will come out on the strike at the attacker to Bonatti and Medale Brianzi ... but ... now that's enough for us ... we take two steps to the top again and smoking a cigarette.


Marco on the second pitch








I must learn to hold the phone straight :-)






Thursday, November 19, 2009

Tundra Ski Doo For Sale In Ontario

Organization - Excel 2003 UDF

the file can be downloaded by clicking here

Warning! for the proper functioning of the file is saved

, in fact, contains additional references.

Excel Version 2003

Contains macros - References added to:

Microsoft Windows Common Controls 6.0 (SP &)

  • Microsoft Scripting Runtime
    TreeView and Spreadsheet ( an initial message will ask you to enable ActiveX controls)

Description:

All''apertura file is created Bar not anchored with two buttons. The first "Wizard" recalls

the Forms to build an organization and modification of existing charts in spreadsheets saved as a data source whose name is preceded by or O_P_ O_.

The second refers to a form that helps in adding nodes directly to a spreadsheet data source.

The creation of organization charts is simplified by using a TreeView that helps you see the classic tree are also present options for editing, deleting, adding or moving nodes.

A Form that contains a Spreadsheet allows you to add more nodes to a single parent.

Each node is associated with two text fields longer be able to choose whether the node is a person or a collaborator. The creation of hierarchical diagrams provides the possibility to organize the field of individual text boxes, thanks to a dedicated form.

E 'can create diagrams in a Word document, a PowerPoint presentation or a new worksheet or a new Excel workbook.

E 'can choose the layout of the first node and the subsequent nodes.

Organization very large produce diagrams difficult to visualize, so as an organization is able to isolate a single branch and treat it separately.

Saving data that is the organization or branch block is allowed in two formats, Excel spreadsheet and two XML files. This second option is very experimental and probably more a curiosity than a real utility, however the format

XML 2D transforms the organization into a table that later reopened as a list in Excel will show the organization as a normal table where each column is always an outer layer of the structure.

Il formato XML 3D invece crea uno schema analogo alla visualizzazione nella TreeView.

Nel foglio Esempio1 viene mostrato come creare un foglio di Origine del tipo O_P_ a partire da una semplice tabella.

Nel foglio Esempio2 viene mostrato come è possibile usare un elenco di path per generare un Organigramma.

I fogli con prefisso E_ vengono utilizzati come elenchi di nodi da organizzare nella creazione dell'organigramma. Di questi fogli viene estratto l'elenco univoco dei testi e reso disponibile nella combo di assegnazione del nuovo nodo, una volta aggiunto il nodo la voce viene eliminata dalla combo. E' anche possibile copiare in for example, a series of memory cells and get the same result. If the memory is occupied by a text list will be created with the single word length of 4 characters.

To learn how to use this tool the best way is to create an organization from scratch, play, save, reopen and change the data source. The sheets in the folder are already created data sources with which you can do tests. In particular

sheets Modello_Oggetti reconstruct the pattern of the model of Office applications. This folder is likely to be transformed into a component additional saving it as XML.

The project code is commented, the routines were divided into 3 modules for clarity in reading. The form of the code is commented only partially. The functions in the module functions are very general and reusable, the board then read them carefully.

greetings

r

Wednesday, November 18, 2009

Funny Red Spot On Breast

Join

The CONCATENATE function in Excel has many limitations, you can not use formulas with matrix, you can not pass a range of multiple cells ... the UDF MCAT Harlan Grove solves these problems so dear, a really good feature. Basically it's a chain with the characteristics of the SUM function, and then accepts an arbitrary number of parameters, which can be represented by the range of multiple cells ... can also be used in a feature matrix, really cool ... here it is: Function

MCAT (ParamArray S ()) As String

'Copyright (C) 2002, Harlan Grove ' This is free software. It's use in derivative works is covered 'under the terms of the Free Software Foundation's GPL. See

'http://www.gnu.org/copyleft/gpl.html

'------------------------------------

'string concatenation analog to SUM Dim R As Range, x As Variant, y As Variant

If TypeOf x Is Range Then
For Each R In x.Cells
mcat = mcat & R.Value Next R
ElseIf IsArray(x) Then
For Each y In x
mcat = mcat & IIf(IsArray(y), mcat(y), y)
Next y
Else
mcat = mcat & x
End
If Next x End Function








I drew inspiration from this function to create a UDF like to extremely useful to Join VB ... JoinUDF returns a string created from the combination of substrings contained in the source parameter is bounded by the parameter delimiter.


Source will be a range of more cells or an array, delimiter can be any value or range or an array (in this case is the concatenation of substrings).


Like Join this feature can be used to concatenate strings, omitting it will be used as a delimiter Delimiter string length zero (la funzione Join viceversa usa come defoult lo spazio).


Function JoinUDF( _
Source As Variant, _ Optional Delimiter As Variant = "") As String
'di Roberto Mensa Nick r Dim Rng As Range, x() As String, y As Variant Dim i As Long
If TypeName(Source) = "Range" Then ReDim x(Source.Count - 1)
For Each Rng In Source
x(i) = CStr(Rng.Value) i = i + 1 Next
ElseIf IsArray(Source) Then For Each y In Source
ReDim Preserve x(i)
x (i) = CStr (IIf (IsArray (y), JoinUDF (y), y))
i = i + 1 Next


Else ReDim x (0)
x (0) = CStr (Source) End
If

If IsArray (Delimiter) Or TypeName (Delimiter) = "Range" Then Delimiter =
JoinUDF (Delimiter) End If

JoinUDF = Join (x, CStr (Delimiter)) End Function




greetings
r


Wednesday, November 4, 2009

Gift Card Shower Wording

Dashboard Charts (Excel )

Lately I'm impassioning the dashboard charts ... type tacchimetro car :-)
attach two files, I added a throttle effect, the macros only affect this ... for the rest work with ordinary Excel functions

Link 1 Link 2





greetings r

Nikon Digital Camera Battery Use Cold

Osvaldo Cavandoli - Scatter charts (Excel)

After Cavandoli Test ... for those who want to practice with the scatter plots ... some pictures of the line of the legendary Osvaldo Cavandoli ... Link to file


greetings r

Tuesday, November 3, 2009

Pool Table Minimum Clearances

prime factorization (VB)

Two agile functions for prime factorization of a number. Greetings
r


Dim T As Long Dim R As Long Dim S As String

'is based on the principle that a number R = Sqr(N)
T = N Mod 2 + 1
F = 1
If N = 1 Then S = N
Else
Do Until F > R
F = F + T
If (N) Mod F = 0 Then
S = S & F & "*"
N = N / F
F = F - T
R = Sqr(N)
End If
Loop
If N = 1 Then
S = Left(S, Len(S) - 1)
Else
S = S & N
End If
End If

Fattori_primi = S
'volendo una matrice sostituire con
'Fattori_primi = Split(S, "*")

End Function


Public Function PrimiB2(ByVal N As Long) As Long()
'di Nur
Dim arrF() As Long
Dim F As Long, NP As Long, d As Long
Dim Stp As Long, Radice As Long
If N = 1 Then
ReDim arrF(0)
arrF(0) = 1
Else
Radice = Sqr(N)
d = 1
Stp = N Mod 2 + 1
Do Until d > Radice
d = d + Stp
If N Mod d = 0 Then
NP = NP + 1
ReDim Preserve arrF(NP - 1)
arrF(NP - 1) = d
N = N / d
d = d - Stp
Radice = Sqr(N)
End If

If Loop ReDim Preserve arrF
d (NP)
arrF (NP) = N
ElseIf d = 1 Then ReDim
arrF (0)
arrF (0) = N
End If End If

PrimiB2 = arrF
End Function



Sore Spot Stomach Pregnant

TextBox with validation data (MSForm - VBA - VBScript)

text boxes (TextBox) are among the controls used in the creation of the UserForm. They are suitable for data visualization, but they are often used to gather input. In this regard it is worth specifying that the data that are defendants in the TextBox are text or string data. Problems arise when you want to enter different data types, such as dates or numbers. In these cases it is always good contralateral placing no validation of the data.
propose an example that uses regular expressions to check if the data was written correctly. The check is done and Exit event uses a generic routine that is passed to the pattern. I preferred writing to alert you in a Label control any error message, rather than using annoying error messages.
< N Then


'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
' for example, inserting a new


'UserForm (UserForm1) containing:
' a Label (Label1) and three TextBox
'other path can be found at:
' http://excelvba.altervista.org/blog/index.php/Excel-VBA/Espressioni-Regolari-e-Pattern-applicazione-Form.html


' Paste all the code in the form

'class of

userform Private Sub UserForm_Initialize () With Me
. Caption = "Sample TextBox with validation
. Label1.Caption =" "
. Label1.ForeColor = & HFF &
. TextBox1.Tag = "European Data"
. TextBox2.Tag = "Tax Code"
. TextBox3.Tag = "Decimal" . TextBox1.Text = "12/10/2009" . TextBox2 . Text = "DVXJHT61B12Z600F"
.TextBox3.Text = "2,5" End With End Sub
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
'data europea
UserForm_Controllo_Event_Exit Me.Label1, _
Me.TextBox1, _
Cancel, _
"^(3[01][12]\d0?[1-9])/(0?[13578]1012)/" &amp; _
"(\d{2}(192021)\d{2})$" &amp; _
"^(30[12]\d0?[1-9])/(0?[469]11)/(\d{2}" &amp; _
"(192021)\d{2})$" &amp; _
"^(2[0-8][01]\d0?[1-9])/(0?2)/(\d{2}" &amp; _
(192,021) \\ d {2}) $ "& _
" ^ 29 / (0? 2) / (200000) $ "& _
" ^ 29 / (0? 2) / (192 021) ? (0 [48] [2468] [048] "& _
[13579] [26]) $"
End Sub Private Sub

TextBox2_Exit (ByVal Cancel As MSForms.ReturnBoolean)
'tax code
UserForm_Controllo_Event_Exit Me . Label1,
Me.TextBox2 _, _
Cancel,
_ "^ ([AZ] {6})" & _
"(((\\ d {2}) [ACELMRT] (3 [01] [12 ] \\ d0 [1-9] "& _
" 7071 [56] \\ d4 [1-9])) "& _
" ((\\ d {2}) [DHPS] (30 [12] \\ d0 [1-9] 70 " &amp; _
"[56]\d4[1-9]))" &amp; _
"((\d{2})B(2[0-8]1\d0[1-9]6[0-8]5\d4[1-9]))" &amp; _
"((0[048][2468][048][13579][26])B(2969)))" &amp; _
"([A-Z]{1})([0-9L-NPQ-V]{3})" &amp; _
"([A-Z]{1})$"

End Sub

Private Sub TextBox3_Exit(ByVal Cancel As MSForms.ReturnBoolean)
'numero a virgola mobile
UserForm_Controllo_Event_Exit Me.Label1, _
Me.TextBox3, _
Cancel, _
"^(0[+-]?" &amp; _
"((?!0)\d+([,]\d+)?" &amp; _
"[0]+([,]\d+)?))$"

End Sub


Sub UserForm_Controllo_Event_Exit( _
ByRef oLabel As MSForms.Label, _
ByRef oControl As MSForms.Control, _
ByRef Cancel As MSForms.ReturnBoolean, _
Optional ByVal sPattern As String = "[\w\s]+")
'______________________________________________
'¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'Di Roberto Mensa nick r
'______________________________________________
'¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'Effettua un controllo sul testo digitato in un
'controllo, se il controllo ha esito negativo
'ripassa cancel=true impedendo l'uscita del focus
'e seleziona l'intero testo digitato
'da richiamare dall'evento exit di controlli che
'hanno cancel come argomento
'oLabel è il controllo Label entro cui comunicare
'il messaggio di errore

Dim re As Object
Static sLabelCaption As String
Static bCancel As Boolean

If bCancel = False Then
sLabelCaption = oLabel.Caption
End If

Set re = CreateObject("vbscript.regexp")
re.Pattern = sPattern
re.ignorecase = True
With oControl
If Len(.Text) > 0 Then
If re.test(.Text) = False Then
oLabel.Caption = _
"Testo " &amp; .Tag &amp; " - Non valido!"
.SelStart = 0
.SelLength = Len(.Text)
Cancel = True
bCancel = True
End If
End If

If End With Cancel = False Then
bCancel = False
oLabel.Caption = sLabelCaption
End If End Sub




Monday, November 2, 2009

What Should I Wear For My Birthday Dinner??

CSV for each sheet in the active Excel workbook (Excel - VBA)

The code that I propose is to create, starting from data contained in the sheets in a workbook, a series of csv file (or txt).
The Save As file of this type in fact carried out by VB code does not recognize decimal delimiters incorrectly, so the comma is replaced by point ...
is used a reference library to use the Scripting FileSystemObject.
to get the huge potential of the FSO will find many examples in the help of VBScript. Leditor VBScript accessible from the menu Tools-> Macro> Microsoft Script Editor ... (You may need to install the first access to any OK) ... Editor online help is then available chapter vbscript within which you will find topics related to the FileSystemObject. Greetings

r





Option Explicit 'in a standard form of the VBA project ' ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'Di Roberto Mensa nick r
'______________________________________________
'¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'crea per ogni foglio della cartella di lavoro
'un file csv o txt (modificando la costante
'Estensione_file)
'i file vengono salvati nel percorso nella stessa

'posizione della cartella attiva 'se un file csv con lo stesso percorso-nome esiste 'già sarà sovrascritto
Dim Sh As Excel.Worksheet
Dim Rng As Excel.Range
Dim S As String
Dim FSO As Object
Dim tS As Object
Dim Wb As Excel.Workbook
Dim sPath As String
Const ForWriting As Long = 2
Const Estensione_file As String = ".csv"
Set Wb = ActiveWorkbook

Set FSO = CreateObject("Scripting.FileSystemObject")
sPath = Wb.Path '
On Error Resume Next
For Each Sh In Wb.Worksheets
Set Rng = UsedRange_Value(Sh, , True)
S = CSV_text(Rng)
Set tS = FSO.OpenTextFile(FSO.BuildPath( _
sPath, Sh.Name &amp; Estensione_file _
), ForWriting, True)
tS.Write S
tS.Close
Next
End Sub
Function CSV_text( _
Rng As Excel.Range, _ Option D
As String = "") As String '
'______________________________________________ << eventualmente da cambiare
¯¯¯¯¯¯¯¯¯¯¯¯¯
'by Robert Mensa nick r
'______________________________________________
' ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'parameter opzionale D indica il delimitatore
'da utilizzare nella scrittura del file
Dim R As Long, C As Long
Dim S As String, St As String

For R = 1 To Rng.Rows.Count
St = ""
For C = 1 To Rng.Columns.Count
St = St &amp; D &amp; Rng(R, C).Text
Next C
If Len(Replace(St, D, "")) Then
St = Right(St, Len(St) - 1)
Else
St = ""
End If
S = S &amp; St &amp; VBA.Constants.vbNewLine
Next R

CSV_text = VBA.Left(S, Len(S) - 2)
End Function
Function UsedRange_Value( _
Optional Sh As Worksheet, _
Optional Rng As Range, _
Optional WithFormulas As Boolean = False) _ As Excel.Range


'______________________________________________
' ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'by Robert Mensa nick r
'______________________________________________
' ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'Returns the minimum range rectangular
' which includes all cells enhanced
'in sheet or in the range that we spend as
' argument

'Returns Nothing if no cell is
' enhanced

'will be ignored by passing Sh Rng

'not passing arguments will be sought
' active sheet in the range of
folder 'containing only the cells that contain active
' a constant value

'passing will
WithFormulas = True' also considered the cells with a
'formula

Dim S As String, ts As String Dim
RE As Object Dim
maxrate As Long Dim maxc
minR As Long As Long, Mincio As Long Dim V


'Check for the first two arguments and septum
' If the search range
Sh
Is Nothing Then If Rng Is Nothing Then
September Rng = [a1]. Parent.UsedRange
End If
September Sh = Rng.Parent
= Rng Else
September Sh.UsedRange
End If On Error Resume Next


'sets the range of cells containing a value
' constant
September UsedRange_Value Rng.SpecialCells = (_
xlCellTypeConstants)

' Control If the optional parameter
WithFormulas
Then 'add the cells that contain formulas
If TypeName (UsedRange_Value) = "Nothing" Then
September UsedRange_Value = _
Rng.SpecialCells (xlCellTypeFormulas, 23)
Else
September UsedRange_Value = _
Union (
UsedRange_Value _, _
Rng.SpecialCells (xlCellTypeFormulas, 23))

End If End If On Error GoTo 0


'verification that the range is not empty If
TypeName (UsedRange_Value) = "Range" Then
'I check if it contains more areas
If UsedRange_Value.Areas.Count> 1 Then
' recovery
set the coordinates to 'rectangular range
' Warning!
'behavior is not documented
' Address reported to range
'Rng.Address returns up to 257
' characters
For Each V In UsedRange_Value
S = S & V. _
Address (True, True, xlR1C1)
Next
Set RE = CreateObject("vbscript.regexp")
RE.Global = True

RE.Pattern = "C\d+:,"
tS = RE.Replace(S, "")

RE.Pattern = "\d+"
maxR = RE.Execute(tS)(0)
minR = maxR
For Each V In RE.Execute(tS)
If V
minR = V
ElseIf V > maxR Then
maxR = V
End If
Next

RE.Pattern = "R\d+:,"
tS = RE.Replace(S, "")

RE.Pattern = "\d+"
maxC = RE.Execute(tS)(0)
minC = maxC
For Each V In RE.Execute(tS)
If V
minC = V < minR Then
ElseIf V > maxC Then
maxC = V
End If Next

September UsedRange_Value Sh.Range = (_
Sh.Cells (minR, Mincio), _
Sh.Cells (maxrate, maxc))

End If End If End Function




< minC Then




Saturday, October 31, 2009

Colorful Bracelets Meanings

Via Taveggia - Horn Medal (Lecco)

For people like me is near Lecco ... began the season :-) Medale


It starts from the Cassin ... and the following week to go to Taveggia ...


Via fifth-degree ... Maybe 6th ... but little forced ... The attack is written the name of the street ... therefore impossible to make mistakes ... the report we had not ... but the route does not require much sense of direction ... you can only go wrong negli ultimi tiri ... infatti ho sbagliato :-) direi che l'unico consiglio è ... attenzione agli ultimi due tiri quelli prima dell'uscita dalla via (III) ... alla partenza del pen'ultimo tiro, dopo il primo fittone io ho tenuto dritto in un diedrino (chiodo e piastrina poco affidabili) la via invece passa a destra , certo il chiodo sembra chiamare "è di qui vieni ... c'è anche una piastrina ..." così io mi ci infilo ... ma la roccia diventa rotta e instabile, se proprio decidete di fare questa variante occhio a dove mettete mani e piedi ... comunque ... rimontato il diedro (chiodo) si recupera la via.Anche sull'ultimo tiro (toccato a Valter) attenzione ... tenere sempre la destra ... come in autostrada ... è Play it safe ... move to the left of the nails are rock but you end up running ... the tap-roots are a little 'distant but the difficulties do not exceed the fifth grade.

positive note is the close proximity to the streets and Eternium Mexico and Clouds ... for us (out of practice) is still too demanding ... but nice to see friends and Stefano Luciano climb over. The rest of last shot offers an ideal location to take pictures on Luciano tiro chiave di Messico e Nuvole una placca mozzafiato che termina con una fessura (5 protezioni sul tiro di 20-25 metri). Settimana prossima l'Anniversario ...
Lecco all'alba ...
Il Medale ... e Valter
L'attacco della via ...
a metà parete ...



Luciano on Mexico and Clouds ... the crux ...





























Largest Average Women In The World

Recursive functions (VB)

ecco due funzioni ricorsive semplici semplici ... io amo le funzioni di questo tipo ... risultano spesso sconvenienti ma sono affascinanti ... e aiutano a ragionare in modo diverso ... la prima è per verificare il numero di dimensioni di una matrice ... la seconda serve a calcolare il fattoriale di un numero ... Function N_Dim(arr As Variant, Optional ByVal l As Long = 1) As Long On Error Resume Next
ArrayDims = LBound (arr, l) If Err Then
N_Dim N_Dim = (arr, l + 1) End If
End Function Function
Fact_If (ByVal N As Long) As Double 'recursive function to calculate the factorial ' of a number N =

Fact_If If N = 1 Then Fact_If Fact_If Fact_If * (N - 1)
End Function








California Tax Deed Sales

Cavandoli Test (Excel - Scatter charts)

Here's what I wrote in the email sent to colleagues
"you ride a short test to assess your preparation on the scatter charts in Excel" in the attached file that you can scaricare a questo link

Link al file
<>

Friday, October 30, 2009

Build Sand Rail Frame

English Ordinals (Excel-VBA-VBSript)

Da una piacevole conversazione con Nur sono nate alcune funzioni che propongo ... Della serie ... Funzioni inutili ... ecco English_Ordinal O_R e Ordinals_R che trasforma un numero nel rispettivo ordinale inglese ... e Is_Ordinal che verifica se la stringa passata come argomento è o meno un ordinale inglese. Il gioco stava nel *costringersi* ad usare le RegExp ... ma in questo caso forse hanno perso la gara ...

'lanciare test
Sub test()
Dim i As Long For i = 0 To 999 Cells(i + 1, 1) = English_Ordinal(i) End Sub

Function English_Ordinal(L As Long) As String
Dim re As Object
Dim S As String

S = L Set re = CreateObject("vbscript.regexp") re.Pattern = _
"((1[2-9]1)(2[2-9]2)(3[2-9]3)([04-9]1[0-9][2-9]0[2-9][4-9]))$"
S = re.Replace(S, ";$2st$3nd$4rd$5th")
re.Pattern = "(.*);.*?(\d+[a-z]{2}).*$"
English_Ordinal = re.Replace(S, "$1$2")
End Function

Public Function Is_Ordinal(S As String) As Boolean
Dim re As Object
S = "0" &amp; S
Set re = CreateObject("VBScript.RegExp")
re.Pattern = "^\d*([02-9](1st2nd3rd[04-9]th))(1\dth)$"
Is_Ordinal = re.test(S)
End Function

Function Ordinals_R(l As Long) As String
Dim v, c As Long, i As Long
v = Array("th", "st", "nd", "rd")
c = Right(l, 1)
If Right(l, 2) - 10
c Then _
If c
Ordinals_R = l &amp; v(i)
End Function

Function O_R(l As Long) As String
'breve
Dim v, c As Long
v = Array("th", "st", "nd", "rd")
c = Right(l, 1)
O_R = l &amp; v (IIf (Right (l, 2) - 10 = c, 0, IIf (C> 3, 0, c))) End Function



<>
< 4 Then i = c



Thursday, October 29, 2009

Surround Sound Preamp Card

North Ridge of the Brenta Crozzon

the evening ... first





The camp ...


The view of the Campanile Basso




On the edge ... 1



On top ...

Sunset ...
Dawn ...

The descent ...

































Sunday, October 11, 2009

Vitamins That Help Hypersomnia

Lettera aperta a Silvio Berlusconi

Dear President,

the Constitutional Court ruling that rejected the Alfano was a blow for her. The strategies of his most trusted advisers and Napolitano's assurances had convinced that the outcome of this story would have been beneficial.
Who writes, however, has always been rather skeptical about the verdict that the consultation was called to give birth. The facts that I am right, but this does not matter. Her personal reaction, at least that hot, which is humanly understandable. It was, in fact, a personal defeat, political and judicial.
She now flaunting his popular support, brandishing a weapon to use in a war against everything and everyone. This brings pleasure to some supporters of the center as in the past when he found himself under pressure often gave her the best. Others are worried that his obstinacy could lead the country into a spiral of self-struggle. Perhaps it is true that among the requirements of a leader is also to remain calm even when the pressures are increasing, it is best to look at the matter with a little 'more than posting. How
wrote David Giacalone, we must not believe that the popular vote is an assessment that exceeds the criminal and autonomy between the two is the basis for the rule of law. She
consensus has always had, over the last fifteen years. He had in 1994, 2001 and 2008, when he won the election. And it did in 1996 and 2006, when despite having the most votes of his opponents have lost. It is the consent of a majority of the country has seen in her a hope for change or to choose the lesser evil. However, millions of Italians who fear most the electoral programs of the center that his legal problems. This is the consensus
enough to go often (but not always) to the government. That did not prevent his opponents, because without it, the tried everything to get back at those early nineties did miss their appointment with history. In short, it puts away the twist of fate and the pitfalls of politics. By now you should be accustomed to smear campaigns and legal proceedings. These are so much easier if the judiciary decides to wear a helmet and get a straight leg in the political arena.
If, however, the courts do, what she is not only a victim, but also the culprit. As it is for the other problems afflicting the Italian justice. The CSM is at the mercy of the currents togate, the commonality of the careers of judges and public prosecutors is an affront to the rights of defense and the processes are so long as to violate timely international standards that require equity. These are things we know for years and, since 1994, there was plenty of time to intervene, but this was not done.
She will not, perhaps, the only culprit. The undisputed leader who has exercised the deployment of so-called Second Republic in the center makes it, but at least the main suspect. Who writes for years wanted to see robust reform of the Italian judicial system, which today is one of the most embarrassing and disarming the country weights. As in many other areas.
Italy is plagued by a suffocating tax and a massive public debt. From public and private monopolies and oligarchies (?). Da una burocrazia elefantiaca e da una pubblica amministrazione poco produttiva. Lo è oggi e lo era nel 1994. La popolazione invecchia e la sostenibilità del sistema pensionistico per le prossime generazioni è affidata a un atto di fede. La crescita economica è un miraggio da molto prima che arrivasse la crisi. Servono modernizzazione e svecchiamento, un taglio netto alla spesa pubblica, alle tasse, ai parlamentari e alle province. Liberalizzazioni e meritocrazia. In poche parole, la rivoluzione liberale che lei ha promesso quindici anni fa e che ancora attendiamo.
Se lei è convinto che a colpirla sia stata una magistratura politicizzata, allora il colpo è arrivato da una sua mancata riforma. Da anni gli italiani, anche e soprattutto those who vote for her, are affected daily by its failure to reform. Make public queues at counters, waiting for a life sentences that never arrive, are scrambling in vain to try to figure out how to fill out a tax return and subtract the tax you see a disproportionate share of the fruits of their labor. Blame
with the world or the Communists, or with the Communist world, is of little value. It vents anger, and stir the souls of the most ardent fans, but is the end of Don Quixote against the windmills. To change the status quo we need more. Do as suggested Brunetta two councils of ministers a week. We spend more and less to praise the country and meets with the reforms that Italy has bisogno. Ha una maggioranza blindata e un consenso popolare da record. Non ha più Casini o Follini vari da usare come scuse per l'immobilismo e molte delle cose da fare le può trovare già scritte nel programma che ha presentato agli elettori un anno fa. O in quelli delle elezioni precedenti.
Cambi il paese e gli italiani non avranno solo i processi, ma qualche buon motivo in più per ricordarla.

Con stima. E speranza.

Friday, September 11, 2009

Can You Die From Hypersomnia

Atreju 2009 / Ritorno al Futuro Liveblogging

Atreju 2009 , terzo giorno. Torniamo a occuparci della prima festa della Giovane Italia per seguire, per lo speciale di Tocqueville, uno degli incontri più interessanti della kermesse. "Ritorno al futuro. L'epoca di internet tra informazione, economia and freedom. "guests Italo Bocchino, Claudio Velardi, Luigi Crespi, Diego Bianchi and mayor.



19:11 Zoro:" Yes, Internet is a mirror of reality, not c 'is nothing more to add. One reason the figures of D'Alema and La Russa incumbent in the distance. "

19:09 " Google has set up a monster that even Google itself can be defeated. "

19:07 Velardi, "The regulation of the Internet can only take place in the world. not even enough for the G20. The national policies are doomed to failure."

19:01 Crespi praises of Obama. Andrea glares.

18:55 "Defending the public is vital, but the enemy is not who have to download an evil, but the Google code. If I stand accused of sexual assault, the news will have thousands of hits and will finish in first place. If the day after they are cleared, the news goes unnoticed in the first place and there will still be the wrong one. "

18:51 Crespi, "Bocchino knows what he's talking, but I hear on TV political talk about shooting a lot of crap. Internet mirrors society: the gossip and even before there was rubbish, only faster now. "

18:50 'Internet will be the lever to bring down the oppressive regimes. Governments can not control. "

18:48 "Google, progressive model, you come to terms with Iran. If the American blogosphere, in a bipartisan way, to protest, even Google would go back. "

18:45 Internet and dictatorships, it is Andrea's turn again. "Not only Iran, in Moldova there was a twitter revolution, only that the press does not mention it because the government is Communist. For our sample, governments can not control the uprising from below that use these tools. "

18:40 "The Islamic theocracies will fall for three reasons: young people and women who want to live like those of other countries, and the Internet, which is not yet controlled. The future web will topple the Berlin wall. "

18:38 "We have to wonder about politicians to protect the privacy of those who is not a public figure, to combat online fraud and defamation."

18:33 "The Internet allows politics to those who have less economic resources, but the greater the risk of superficiality. A Wikipedia article that has been there for five years and very popular is a guarantee yesterday that mass movement is likely to create false ".

18.30 Internet come censura o come possibile strumento del potere. Cosa può fare il legislatore? Per Bocchino il web è come la nitroglicerina: non possiamo farne a meno, ma se innavvertitamente la lasciamo cadere per terra ci facciamo male.

18.27 «Internet è uno strumento per fare politica, non la soluzione ai mali della politica. Ha potenzialità eccezionali, ma rimane sempre uno strumento».

18.24 Parola a Zoro, alias Diego Bianchi. «Tocqueville ragiona in prospettiva, chi non la pensa come loro è ora che inizi a fare lo stesso. A sinistra ci sono tentativi che falliscono per la solita capacità di sinistra di litigare». Si thanks for the publicity.

18:23 "When Berlusconi says he does not need the internet because he has read, I fall for the arms."

18:22 "I have to take one pebble from the shoe, the first President Bush was elected from the internet. Or rather, the web has sanctioned the defeat of Kerry 'is staged revenge of La Mancha.

18:19 "The nonsense you find in the press, but the power of the Internet lies in its ability to self-correct. If I write nonsense on my blog, after 30 seconds I do note in a comment and immediately lose credibility and readers. "

18:17 "I do not know where ends where the freedom and the beginning of anarchy, "he says Andrea," my freedom ends where he began to give blows to the nose of others. " In the first version was a handful, but the audience seemed to like it.

18:16 "From a cultural point of view," the Montaruli asks, "how reliable is the network"?

18:15 "Internet is changing the world. To treat cystitis my dog \u200b\u200bI have entrusted to the network. "

18:10 Montaruli Augusta, moderator of the debate, causing Velardi. "If D'Alema and Veltroni are boiled because open tv, who is not in the PD? Answer: "No, the PD needs a new leader. " Amen.

18:07 "We are not late on the U.S.. The Obama phenomenon is born thanks to recent innovations, YouTube and Facebook, which allowed him to build a remarkable consensus among small donors. " Andrea moans behind him ...

18:05 "My brother dragged me into this world, now step two hours per day on Facebook and I have a blog to be updated daily. And to think that when I was young there was a black and white television channels and two, to send an urgent letter, I had the pocket. "

18:02 Word to Crespi, opening in Cav-style "are the best pollster in the last 150 years." He says he does not know a person you do influence the polls and that the new media have changed my life.


18:00 After fitting tribute to the victims of the Twin Towers, we start with Mouthpiece. Now sweeping the field from the items that run: I do not for election in Campania, but if I did would lead my campaign on new media.

Wednesday, September 9, 2009

Free Plans Off Road Buggy

09/09/09. Il futuro inizia oggi

09/09/2009. It is not the date of the end of the world, but in his small, this day will go down in history. The eleventh edition of Atreju, which begins today, is the first license plate Young Italy, the new youth training of the PDL. The future starts today, in celebration of the twentieth anniversary of the fall of the Berlin Wall and the search new myths for a generation that wants to change politics and Italy.



20:25 The evening draws to a close. Last question about Baptists, that Berlusconi hopes to soon see behind bars. Good evening to all.

20:23 Tribute due to the fall of the wall, with the usual trips to the Communists and the announcement of major events for November 9.

20:18 "No multiethnic Italy." Legocelodurismo? No, "the left wants to make batches of immigrants to change the Italian electorate that rejects them forever."

20:16 "Do not do as Visco. No state tax and the national police jailed into the treasury. "

20:14 "We've already done a lot, but if someone suggested they go ahead."

20:12 "Tomorrow will inaugurate the Magdalene a new ultra-modern conference center."

20:07 Application for a girl who cut down the wall today? Berlusconi, in addition to persuade her to get invited to dinner, dhe said tearing down those that constrain the meritocracy. The university needs to be changed: more and more on proximity to the world of work. Then the wall of lovers: the young couples have problems to get a house. Finally, in the workplaces.


20:05 "The alliances we have not yet decided. Are the only two certainties in Scopelliti Formigoni in Lombardy and Calabria. "

20:03 A boy wonder who will recover between Kaka and the Knight Casini and who would suggest for the exhibition on the role models for young people (one of the stand Atreju).

20:01 "amend the Constitution equalizing the age of active and passive. If one is mature enough to choose their representatives, it is for candidates to represent his fellow citizens'

20:00 "you too will be our class leader"

19:59 Flurry of jokes about Soru. Silvio kills a man dead.

19:57 "I like all Italians. I love football, beautiful life, beautiful women. Not like the lords of the minority cattocomunista.

19:52 "Ours is a liberal party of mass, with freedom of conscience and the possibility of dissent. Keep regular coordination meetings to involve the local area. Fini with a misunderstanding. "


19:50
"All right, civil society," calls for melons, "but it would be better to involve the youth organization to replace the new ruling class? And there is space for dissent? "

19:47 It 's time for questions. A Berlusconi leads boy on the attention to Libya. He defends relations with Gaddafi, and without fear, pulls out a healthy dose of cynicism: we did it for oil and gas. "Now all the countries of the former colonies, we consider a model."

19:42 'Giorgio, you always speak Council of Ministers. Tonight I am taking a little revenge. " And down the first joke.

19:40 Knight recalls all the great electoral victories the last two years except for one: the Friuli. Who knows how it will be happy Simone ...

19:38 "Enrico Fermi was an Italian. We must return to nuclear power. With the French charged atom Energy 50% less. Know how to exploit the French and Polish and will return in modernity. "

19:37 'associations of enterprises are satisfied with our action. Others say that what cattocomunisti.

19:31 The Italian justice system sucks. Discovery of hot water.


19:29
"Via the ICI for three years and financial due diligence to avoid the assaults of the eighties that have increased public debt." We did not expect a jab at Bettino. Chapeau!

19:26 on 15 September delivery of the first house to the earthquake victims of Abruzzo. The 21 schools will reopen. Apartments delivered by September 30. And all without raising taxes. The people of Atreju peels his hands from clapping.

19:24 Defense ducesca Alitalia Italian and self-sufficient. Socialist current Tremonti.

19:21 Berlusconi defends membership in South Stream, the most important geopolitical turning point since the beginning of the legislature.

19:19 Memorable claim of "politics of the cuckoo." And a small confession: it was copied by Putin.

19:17 "We made an agreement Obama and Putin, helping to lay the foundations for a world without nuclear weapons"

19:10 Carrela on merits of the government, start with the foreign policy (Russia-Georgia mediation, aid to Gaza, the EU moratorium on the climate package, meetings and summits, G8). Lights and shadows.

19:07 Yesterday was the day that Berlusconi has passed, for days as prime minister, Alcide De Gasperi. Wow!

19:05 Tips for purchases. The Knight opens suggesting two books to the youth of PDL.

19:03 Silvio makes his entrance on the stage of young Italians. Greeted by a standing ovation from the innate and di Mameli.

19:00 Opening in grand style. Guest of honor: Silvio Berlusconi.

Saturday, September 5, 2009

Recording Tv On Vcr With No Tuner

La Repubblica degli Then say the dodgers

The fight against tax evasion back to bear fruit, in recent times. Since his officers are not afraid of sudden transfers if they stick their noses where they should not, the Guardia di Finanza travels shipped. in the first five months of the year were discovered hidden in the income tax to 13.7 billion euro plus VAT of 2.3 and 8.7 of IRAP. If 2008 was a record year for the fight against tax evasion, in 2009 the results have improved by 10% and confirm the seriousness of the intentions of a minister of Economy who have not love, but already a couple of legislatures ago, tried to attack evaders by putting a bounty on them (in short, to encourage the collaboration of municipalities in the struggle, the latter was left 30% of the recovered crossing the databases).
In this atmosphere, it will not be a coincidence that has returned to the surface just now storiaccia Ezio Mauro and his penthouse in the Parioli bought in black. The Director of the Republic, the herald of moral superiority, the usual editorial writing haughty and arrogant demagogue to react to Berlusconi and his henchmen pennivendoli, has even confessed to the crime (as is covered by a prescription, say his co-worker labor), arranging a defense shyster like, "Yes, yes, I evaded taxes, but for those few that I paid I paid more than necessary."
course his are all lies, as confirmed a notary, deputy director of Italy today and the former director of the Revenue Tax. The story is murky, but emblematic of the moral stature of one who raises his finger and pretend to give lessons to others. It found a clear summary and made lots of links on Right Ideal Camelot. Take a look and beware of the moralists of begging.

Friday, September 4, 2009

Eastern Ace Of Spaces

birthers ... The realpolitik of

The guru of obama green jobs, Van Jones, was among the signatories in 2004, an appeal calling on conspiracy to expose the responsibility of the U.S. in the attacks of 11 September 2001. When the news came up, he is justified saying that the appeal does not correspond to his views today and forever. Let's also pretend it's true. Then the administration has embarked signing a blank, on trust. The Americans are in very good hands, I must say ...

Thursday, August 20, 2009

What Shoes To Wear With A Light Blue Dress

Frattini

L ' interview released yesterday to the press by Foreign Minister Frattini says a lot of foreign policy orientation of the Berlusconi government. In the period 2001-2006 was characterized by a center-right ideological rhetoric and pro-American Prime Minister, also focusing on the direct and personal relationship with Bush and Putin had tried to make Italy the bridge link between the U.S. and Russia. Distrust, largely reciprocated, for the European Union is bound to need to look elsewhere for legitimacy and a role at international level. The culmination of that strategy were agreements at Pratica di Mare and the game stood until the eagle held the relationship between American and the Russian bear. The personal friendship with President Texan enables the rider to make the rounds in Washington tolerate waltz with the uncomfortable ally Russia and the profession of Americans, accompanied by the Italian participation in missions in Afghanistan and Iraq, had enabled Finmeccanica to get rich contracts Stars and Stripes. After the brief intermission
Prodi and his momentary sense realignment in europe, the center has returned to government in April last year, impressing with its policy Foreign markedly realistic approach. Now, in fact, have become priority objectives of energy security and our country's attention has been directed toward two major suppliers like Russia and Libya. By the first was signed a historic treaty of friendship as discussed, at least for a while terminating the litigation in exchange for the opening of colonial exploitation wells Libyans by Eni (plus boundary with good intentions in terms of containment ' illegal immigration). In the second, however, the approach has gone through the mediating position taken by Italy in the Russian-Georgian conflict (already a source of friction with Cheney in the final months of office Bush), and more recentemente, per l'adesione italiana al progetto del gasdotto South Stream.
La crisi economica, il cambiamento degli scenari globali, l'avvicendamento alla Casa Bianca hanno spinto il governo Berlusconi a definire, in maniera più stringente che in passato, gli interessi nazionali prioritari. L'impostazione realista della nostra politica estera si legge tra le righe in tutta l'intervista rilascita da Frattini.
È riconosciuta la priorità del teatro afghano, ma non si parla di nuovi soldati da inviare in Medio Oriente: come contributo al surge di Obama, Frattini si limita a prospettare il prolungamento della permanenza dei soldati attualmente dispiegati. Prolungamento, comunque, subordinato al risultato delle elezioni (For which, among other things, is wisely set a goal not in terms of turnout, but the uniformity of the latter).
The minister must not escape as did Russians 25 years ago, but to stabilize the situation it is necessary to deal with the Taliban linked to Al Qaeda and Iran, which also is for Italy an important trading partner.
Frattini, finally, defends the choice of Italian divert their investments in the South Stream gas pipeline and its strategic alliance with Moscow, which is grown in recent years by the governments of the center-right and center.
mean a renewed sense of realpolitik statocentrica, a policy of hands-free unit veiled by some concessions NATO and the good relations Atlantic. Several things are changing in the world and our foreign policy seems groped to adapt.
Meanwhile, in Afghanistan, is pleased to welcome a new election which takes place in those hours despite Taliban threats. It is hoped that what today is another step on the long road towards democracy in a land where Western values \u200b\u200bare terribly difficult to succeed. And they seem destined to toil in the future.

Wednesday, August 12, 2009

Pros And Cons Of Orgasimns

But as cages, need more freedom

university, work, campaign and holidays the last few months have been rather slow to Mithrandir. Let's try to lose a bit 'of attendance to follow this little virtual space.

You know, run a lot of things on the internet, in newspapers and on TV, but some make you want to throw down two lines at once. This is the case of the cages wage Soviet Agostini found the Northern League. Taking advantage of the climate parasol, and season best suited to excel in which populist fire, Calderoli & co. launched the idea of \u200b\u200blinking pay the cost of living that exists locally. To swell the payroll beyond the Po, of course.

The trouble, though, is that this time, unlike the case for fiction to be subtitled in Bergamo and regional flags, the Northern League has gone well behind Berlusconi. Unless late and clumsy denials .

Now, one might say that even if life in the South is cheaper, in fact there is already a differentiation of wages that, in fact, is detrimental to the southern compared to the cost of living differential. Beyond the facts, however, the idea seems wrong. The road would lead to wire cages salary and wage inflation, creating many small escalators and risks triggering an inflationary spiral.

Try to give the country a federal system is all well and good, but only if federalism is used as a lever to empower local authorities to a virtuous management of public affairs. So you bring up a thousand little centralisms , intended to trace all the defects dell'elefantiaca state machine. Let

wages are determined freely in the market, maybe a bit 'lightweight dall'asfissiante tax wedge. It would, if anything, to further promote the wise second-level bargaining, agreements to relocate in the direction of individual companies and entities is not yet public premises but still.

If you really want to find un parametro a cui ancorare i salari, perché non scegliere la produttività? Diamo più soldi ai più bravi, a prescindere dal dialetto che parlano e dalle fiction che guardano in tv. E affermiamo un modello contrattuale finalmente meritocratico.