Aug. 29, 2015

Health

Weighed in today at 163.6 and here's my ExcelDiet.com sheet.

The key disturbing issue to me is my trendline is going up.  This is clearly telling me what I've been doing for the last 10 months isn't working. This is my fourth attempt to follow the red goal line and I've failed 3 times so far. Even worse is I don't know why I've failed to lose weight or have a stable trendline. On the positive side I use to weigh 185, so I'n down over 20 lbs. from that point.

Like the rule "Buy low sell high," what sounds easy can be very difficult to implement. One difference is I haven't been following the Excel Diet but more of a Paleo/Atkins/Bulletproof type diet where I eat lot's of fat and low carb. I've been measuring my blood sugar since  March 29, 2015.

One of my favorite sayings is "If you do what you've done, you'll get what you've got." Basically, what I've been doing in this time frame hasn't worked, I need to try something new.

News

No big news stories but topics being talked about are:

• Katrina 10 year anniversary
• ISIS
• Global warming
• Iran Nuke Deal with the US

Stocks

Stocks came back big time. For some reason big losses means big gains a few days later. This seems like an easy strategy to take advantage on if you can trade short term.

PURGE - Prioritize Ur Goals Everyday

1. Clean Desk
2. BS = 83
3. W < 160
4. Move Listi.net to SQL server
5. Proofread Wisdom of a Dad
6. Work on cover
1. Install Photoshop
7. Finish report at work

Accomplished Tasks

1. Cleaned bathroom
2. Vacuumed house
3. Cleaned dog poop
4. Took dog for a walk
5. Designed Book cover w/o photoshop
6. Took dog to All American burger and skipped the buns

Ideas

1. Bathroom cleaning product.  
2. Dog food made out of treats
3. Business to help people who are afraid of dogs overcome their fear
4. Product to help write a book

Excel Diet

Got a download of the spreadsheet to day and tried to upload the book to Scribd.com but had and issue.

Listi.net

Working on porting the website from Microsoft Access to SQL server. I've set up a table and got a script to be able to read and write to the table. My backlog is the following:

1. Create main tables in SQL server database
1. Identify main tables
2. Set up the table(s) on Godaddy website
2. Load data from access to SQL server
3. Make sure data is getting backed up
4. Need a process to copy data from MS Access to SQL server

Microsoft Access Database

The main database is called ListMaker.mdb

The relevant tables and description are:

1.       PageCache – stores webpages for quick access so queries aren’t needed. Created to optimize the response time

2.       ListInfo – Information about a list

3.       GenData – Most important table where all the list info is stored

a.       GD_Id

b.      GD_status

c.       GD_Desc

d.      GD_Memo

e.      GD_UID

f.        GD_DateAdded

g.       GD_DateDeleted

h.      GD_Category_Id

i.         GD_nbr_items

4.       GenOrg – Stores the organization of the database

There may be an issue with autonumber fields as the numbers to be loaded must match data in the access database. 

Aug. 26, 2015

4:05 A.M and I up again. Had to pee and wife was snoring.

XD - Excel Diet

I ate okay yesterday, very low carb. BPC +Bulletproof coffe for breakfast, two questbars for lunch, nuts and low cal grape drink for a snack and for dinner tuna with seeds and pistachios and some cheese. Walked almost 18,000 steps.

POD - Principle of Day

Each day I randomly select a focus from a list of key principles I keep in a spreadsheet. Yesterday's was FOCUS. I take the principle and create an image using pbrush.exe (Paint brush software). I then show it on my desktop to remind me.

I2$
I'd like to have a better way to turn an idea into money as I haven't yet done this. I have a few books that could help. From Idea to Success , $100 Startup, and The 22 Immutable Laws of BRANDING. are on my bookshelf that I've read but know need to implement.

I had 2 downloads of the XD (Excel Diet) spreadsheet yesterday. I'm over 100 so this could be the opportunity to focus on.

I had a few new ideas and I'm not sure to work on them or to work on something else. I could also DAMAGE (Don't Ask Me Ask Google Everything) on how to go from idea to money

Why I've failed with my previous ideas?

Here is a list of reasons, maybe excuses why I've failed.

1. Twixcel - Twitter automation because Twitter changed the API so software stopped working.
2. No one knows about the idea
3. If someone does know I'm not following up
4. I'm not charging for any of my content
5. I get excited, work on project, slow my work and then move on to next project
6. I haven't committed any cash to an idea
7. I haven't gotten any feedback
8. I'm working solo
9. I have a job so I can only work on my ideas in my spare time

WOAD
I worked on Wisdom of a Dad on train in morning and afternoon and at lunch and at night. I'm editing the book which is pretty boring. I've noticed that there are still many typos, duplicate content. I'm still adding content to it which is bad. I'll never finish if I keep doing this, so unless the content is earth shattering I'll keep the idea in a separate place, maybe in my blog.

Dog
Walked Lola with Cheryl and Max. Lola almost ran into street at Hollywood park after I took her off leash,. I screamed, "LOLA STOP" and she did. I've been thinking about how I dealt with neighbor with a dog. I was correcting the husband because he was holding his dog's leash too tight when around my dog. A few days later I saw his wife and she didn't remember me but she would up letting my and Lola into her back yard. Her dog Riley is a puppy but was very aggressive and excited with Lola. Lola already had a play date with Stella. When we got home she was panting very hard and was even shaking a little.

She just went through a phase of not eating her food.

Work

Worked on creating trade blotter in Python. After 2 weeks to a month awaiting permission, I set up a meeting with Anudeep and Ivan to chat about the method to get the data to be merged into our online Risk system. Ivan doesn't shet up. He's one of those people that my saying "I'm smart enough to know I'm not that smart."

Work was fun. I even worked late which I haven't done for a while. Boss finally said hello to me which is pissing me off. One of the reasons I worked late is that I have my car back.

Walked from work with Evan. He was stressed because he had to work on a project for Debby who is his boss's boss.

I merged Shortcuts to my main spreadsheet at work.

Family
Max was sick last night but felt better today. Nigel had his first day of school today. I hope it went well.

Cheryl saw neighbor walking her dog and was afraid that neighbor would criticize what she was wearing as she's done it before.

Health

My blood sugar has been good for me the last couple of days all under 100. 82 at 8 pm. 92 at 8:30 am. 

I walked 17,900 steps which is 7.9 miles according to Walk Logger app on my phone.

Goals

1. Declutter - Desk is messy
2. W < 160
3. I2$ - Turn an Idea into money
4. WOAD - Wisdom of a Dad
5. bs = 83
6. No foot pain
7. Listi.net accessing SQL Server
8. Read books I have, especially library books
9. Add content to Twixcel spreadsheet
10. Learn the Hanukah song on the Guitar

Messy desk

Stocks

Stocks bounced back yesterday in the morning and dropped near the close yesterday. It's my understanding that the close tells you what the big investors are doing. I don't know if this is true or not. Here is the chart.

Dow Chart

I'm thinking that the market up at the close would be a buying signal.

Aug. 24, 2015

At home my son Nigel is away at college, we dropped him off 2 days ago. I miss him a lot. I feel an emptiness and miss all the little things we did together from just helping me sweep up the dirt in front of the house to seeing him each day. I miss the way he would play with Lola and I want to try to get Max to do the same. Max came home from a Jet practice at Hofstra and got 11 signatures but didn't pet Lola. I asked him to and he did.

We took the dog to a dog park in Massapequa and no dogs were there. Lola sniffed around for a while and then we walked a little and left.

Had dinner at a outdoor place that's hard to find with Cheryl and Lola. Had a chicken wrap and a beer and blood sugar was at 144. Now that Nigel is in college I have to fix my health.

Earlier in the day I walked Lola to her friend Stella's house. I did it completely off leash. It's a short walk. I've been practicing with Lola going down stairs with me. She's not allowed to go until I go. If she does I give her a correction.  I've been working on leaving the curb. She's not allowed to leave curb and go into the street until I do. I can even fake it and she knows to wait for me. She's a very smart girl.

Wrestling

I watched wrestling with Max. We watched the Undertaker vs Brock Lesner. I predicted that the Undertaker would win. Since Brock won the first contest if the Undertaker wins the second fight they could have a rematch. The fight ended in a surprising way. Brock got the Undertaker in a submission move and the Undertaker tapped out. The ref didn't see it because he was checking for a pin. The bell rang but the ref said there was no tap out as he didn't see it. While the ref was talking to the bell keeper, the Undertake knocked Brock in the nuts, and then put him in a submission move. Brock didn't tap out but gave the Undertaker the middle finger. Brock eventually passed out and the the ref stopped the fight at that time.

At 50 years old it's pretty amazing that the Undertaker could wrestle. There was another match Kevin Owen vs. a Flying Scotish Guy. I was surprised that the KO won as he's fat and out of shape.

WOAD - Wisdom of a Dad

I worked on the book trying to organize the chapter on Success which in the table of contents went from page 40 to 105. It was very boring and difficult to do this. I'm thinking if there's a way to monetize the book. 

I worked a little on the cover and it needs work.

 I'm not ready to spend money on it. 

Listi.net

Go the website to use Sql Server in a little over an hour but it was just a sample program. http://Listi.net/dbtest2.asp.

While developing the code I got a -2147217843 error This login failed because the password to server login(user) fails. The problem was caused by the password having single quotes around it but it didn't need any password.

Health

I mowed the lawn and walked a little yesterday, but my left ankle by the Achilles tendon still hurts. I played tennis 2 days ago against Max and beat him 6 - 0. I want to start working out with weights but don't yet have a plan. I woke up at 4 AM to pee and thinking about website.

News

Story in News yesterday about 3 guys that saved a train from a crazy Muslim I think, they didn't really say that, with an AK47 and lot's of ammo. This happened in France.

Reading a story in the Generational Dynamics blog about Obamacare and the Fraud that was committed by John Xenakis.

Stocks

Big losses on Friday, Market was down 530 points. 

ASP Code

<html>
<head>
<title>My First ASP Page
</head>
<body bgcolor="white" text="black">
<%
'test access to database
' from https://www.webwiz.co.uk/kb/asp-tutorials/connecting-to-an-access-database.htm
'Dimension variables
Dim adoCon         'Holds the Database Connection Object
Dim rsGuestbook    'Holds the recordset for the records in the database
Dim strSQL         'Holds the SQL query to query the database
response.write("dbtest2.asp")


'Create an ADO connection object
on error resume next
Set adoCon = Server.CreateObject("ADODB.Connection")
if err <> 0 then
 response.write( err & " " & err.description)
 response.end
end if
response.write( "after adocon

")



'Set an active connection to the Connection object using a DSN-less connection
on error resume next

response.write("connecting to sql server")
'adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("../access_db/xd.mdb") 
'response.write("

err = " & err & " " & err.description & "

")
'response.write("")

on error resume next
response.write("connecting to odorDBuser2")
adoCon.Open "Driver={SQL Server};Server=<server name got from Godaddy>;Database=odorDBuser2;Uid=odorDBuser2;Pwd=*********;"
response.write("

err = " & err & " " & err.description & "

")
response.write("")


'Create an ADO recordset object
Set rsGuestbook = Server.CreateObject("ADODB.Recordset")

'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "select * from test_table;"

'Open the recordset with the SQL query 
rsGuestbook.Open strSQL, adoCon


'Loop through the recordset 
Do While not rsGuestbook.EOF 

    'Write the HTML to display the current record in the recordset 
    Response.Write ("

") 
    Response.Write (rsGuestbook("test_one")) 
    Response.Write ("

") 
    Response.Write (rsGuestbook("test_two")) 
    Response.Write ("

") 

    'Move to the next record in the recordset 
    rsGuestbook.MoveNext 
Loop

randomize
x = int(rnd() * 100)
response.write("x = " & x)
on error resume next
strSQL = "insert into test_table values('xyz'," & x & ",'zzz')"
response.write("strSQL = " & strSQL)
rsGuestbook.Close
rsGuestbook.Open strSQL, adoCon
response.write("

err = " & err & " " & err.description & "

")
 'Reset server objects
rsGuestbook.Close
Set rsGuestbook = Nothing
Set adoCon = Nothing
%>

</body>
</html>