Weekend Yardwork
This week was mostly spent working on a spreadsheet for the Web Development team. Jacob is still out at his dad's house until the first. Andrea goes back and forth between three houses. Kris wins a prize for working a weekend 12-hour stretch and then goes to can pears. And I spend the weekend with yardwork and some airsoft work in the basement.
Excel-lent Spreadsheet for WebDev
This week, I was given a project by Theresa - create a Web Development Customer database in Excel. We had roughly 250 customers, their addresses, and some additional contact info. The raw data was arranged alphabetically by town on several word document label templates.
In order to import the information, I had to first save the documents as plain text and then format the data into rows. Then the data was imported into Excel using the Import Raw Data function. This allows you to import data and separate it into various fields manually by selecting the spacing at which you want the data to be separated - this is why putting the data into rows is important. Because of some minor formatting errors, you still have to go through and make sure the data goes into the correct fields.
After I imported the raw data, I selected all rows and grouped the information. That will allow you to arrange the rows by selecting a specific collomn and arranging it to your specifications. Once I have grouped the information, I can the use the Sort function to sort the business name column alphabetically.
The actual data entry and formatting took roughly 3 days, So I actually finished it up on Friday. It was a good project and I am happy to say, I had it finished way faster than anyone thought and in time to get the last hour of work to relax.
Kids Enjoying their last full week of summer
Jacob is still at his dad's house. He plans to stay there until right before school starts. It is understandable considering how little else he has to do at home. Well, at least to him. He still doesn't know we have a Gamecube. He will soon enough.
Andrea has been runnng back and forth between our hous, her grandparent's house, and her aunt Leann's house. She doesn't have that much to do, either. She said she looks forward to getting back to school. Her aunt has promised her an Ipod if she can get straight A's this year. I don't think it will happen, not because I don't think she can do it, but because her poor attitude about schoolwork usually prevents her from succeeding.
The kids start to school on the 5th. Andrea will be in the 8th grade this year. Jacob will be in 5th grade. Both are excited about starting back to school.
Kris wins a Target Gift Certificate at a 12-hour work day
Saturday, Kris worked a 12-hour day at Xcel. They made a big push to get several accounts finished up and Kris' boss asked Kris to come in. They had a potluck lunch, prizes, and candy. At the end of the day, Kris won a $50 Gift Card for Target. She said she had a good time and is looking forward to using her gift card to get herself something nice. She really deserves it as she works very hard.
My Weekend
I've been working on my Cyma AKS-47 this weekend. I made a trade with Jason for a nice G&G GR16 flashhider and have mounted that ont he muzzle of my AKS. I am happy to say that the Cyma AEG has withstood rougly 8000+ rounds of heavy full auto and has stood up well. Initial testing has completed and I will begin midify the gun to my taste.
Step One is to buy a rail interface system and new grip. I plan to use the Black set made by KM. It has an "ergo" - style pistol grip and the rail system simply replaces the current foregrip. This mod will only set me back $50, but it will allow me to moung a collapsible front grip and places my red dot in a "scout" position.
Step Two will involve buying a DTP metal AKS reciever. This will add additional stability to the body of the gun. It will run about $100, unless I can fing the G&G metal body which runs $50. This is mostly to beef up the gun and add more weight.
Step Three will involve replacing all of my Cyma hicap mags with Marui Standards and G&P Mid Caps. The Cyma hicaps hold 300 - 350 rounds each, but I don't like having to wind the mags every 100 shots. So they are going to be replaced with standards and Midcaps and will likely go into the reserve slot to beef up the number of mags I have for an event.
Last summer, I had 10 MP5 midcaps which made it really easy to simply take 3-4 mags to the field at a time. The events would last about an hour, so at the end of that time, all I had to do is replace the empty ones.
Step Four is actually more of an addition to step three, but I plan to buy a Star AK 3000-round drum magazine. This magazine is electric winding so I can shoot conituously for the entire 3000 rounds. This is mostly an idea to use if I need to play the support gunner role. It also makes you a hell of a threat to know you can put 3000 rounds onto any target on the field.
Once I'm finished with modding the AK, I plan to buy another rifle. The AKS is really going to fill the role as a backup rifle. So I didn't really plan to do much else with it after the modding is done. We'll see how the next few months go to see where this project leads. I'll post some pics soon, I promise! :)
Yardwork :(
Sunday, I mowed the lawn. It had really gotten out of hand how quickly it was growing and due to the last few weekend of eather, I have been unable to mow. During the week, it is even harder with work. This last few weeks have been really busy and I just don't feel like doing anything wehn I get home. I spent four hours working on the yard yesterday. I may have taken less time if it weren't for the antiquated piece of shit mower we have.
Kris sold our new mower when we moved to the apartment in Chippewa two years ago. I still can't believe she sold it for $100 when we paid almost $350 for it! It was a very nice bagmower that would have spun right through this yard in about two hours. I'm kinda irked that she sold it, especially when she sold it to one of her friends who could have just as easily gone out and bought a riding lawnmower.
I told Kris after I was done that we needed to buy a new mower because this old one really is more of a hinderance to mowing than anything else. The blades dull very quickly, the drive train on it is shot, and it weighs a ton. The thing is about 30 years old and having to push that thing up the slope of our backyard is quite a workout. Also, due to its age, despite being well taken care of, it is bad need of servicing. The motor occasionally cuts out and dies after about 30 minutes. And when the botom gets clogged with mulch, tipping it over to clean it out floods the engine and takes about 30-40 minutes to settle down.
Really, the mower is a piece of junk that should have gone to the scrapyard years ago. It does work, but having to mow the same spot three times really takes away from its usefulness. I miss my LawnKing. It was really nice. And having to spend more money to get another just really pisses me off.
Excel-lent Spreadsheet for WebDev
This week, I was given a project by Theresa - create a Web Development Customer database in Excel. We had roughly 250 customers, their addresses, and some additional contact info. The raw data was arranged alphabetically by town on several word document label templates.
In order to import the information, I had to first save the documents as plain text and then format the data into rows. Then the data was imported into Excel using the Import Raw Data function. This allows you to import data and separate it into various fields manually by selecting the spacing at which you want the data to be separated - this is why putting the data into rows is important. Because of some minor formatting errors, you still have to go through and make sure the data goes into the correct fields.
After I imported the raw data, I selected all rows and grouped the information. That will allow you to arrange the rows by selecting a specific collomn and arranging it to your specifications. Once I have grouped the information, I can the use the Sort function to sort the business name column alphabetically.
The actual data entry and formatting took roughly 3 days, So I actually finished it up on Friday. It was a good project and I am happy to say, I had it finished way faster than anyone thought and in time to get the last hour of work to relax.
Kids Enjoying their last full week of summer
Jacob is still at his dad's house. He plans to stay there until right before school starts. It is understandable considering how little else he has to do at home. Well, at least to him. He still doesn't know we have a Gamecube. He will soon enough.
Andrea has been runnng back and forth between our hous, her grandparent's house, and her aunt Leann's house. She doesn't have that much to do, either. She said she looks forward to getting back to school. Her aunt has promised her an Ipod if she can get straight A's this year. I don't think it will happen, not because I don't think she can do it, but because her poor attitude about schoolwork usually prevents her from succeeding.
The kids start to school on the 5th. Andrea will be in the 8th grade this year. Jacob will be in 5th grade. Both are excited about starting back to school.
Kris wins a Target Gift Certificate at a 12-hour work day
Saturday, Kris worked a 12-hour day at Xcel. They made a big push to get several accounts finished up and Kris' boss asked Kris to come in. They had a potluck lunch, prizes, and candy. At the end of the day, Kris won a $50 Gift Card for Target. She said she had a good time and is looking forward to using her gift card to get herself something nice. She really deserves it as she works very hard.
My Weekend
I've been working on my Cyma AKS-47 this weekend. I made a trade with Jason for a nice G&G GR16 flashhider and have mounted that ont he muzzle of my AKS. I am happy to say that the Cyma AEG has withstood rougly 8000+ rounds of heavy full auto and has stood up well. Initial testing has completed and I will begin midify the gun to my taste.
Step One is to buy a rail interface system and new grip. I plan to use the Black set made by KM. It has an "ergo" - style pistol grip and the rail system simply replaces the current foregrip. This mod will only set me back $50, but it will allow me to moung a collapsible front grip and places my red dot in a "scout" position.
Step Two will involve buying a DTP metal AKS reciever. This will add additional stability to the body of the gun. It will run about $100, unless I can fing the G&G metal body which runs $50. This is mostly to beef up the gun and add more weight.
Step Three will involve replacing all of my Cyma hicap mags with Marui Standards and G&P Mid Caps. The Cyma hicaps hold 300 - 350 rounds each, but I don't like having to wind the mags every 100 shots. So they are going to be replaced with standards and Midcaps and will likely go into the reserve slot to beef up the number of mags I have for an event.
Last summer, I had 10 MP5 midcaps which made it really easy to simply take 3-4 mags to the field at a time. The events would last about an hour, so at the end of that time, all I had to do is replace the empty ones.
Step Four is actually more of an addition to step three, but I plan to buy a Star AK 3000-round drum magazine. This magazine is electric winding so I can shoot conituously for the entire 3000 rounds. This is mostly an idea to use if I need to play the support gunner role. It also makes you a hell of a threat to know you can put 3000 rounds onto any target on the field.
Once I'm finished with modding the AK, I plan to buy another rifle. The AKS is really going to fill the role as a backup rifle. So I didn't really plan to do much else with it after the modding is done. We'll see how the next few months go to see where this project leads. I'll post some pics soon, I promise! :)
Yardwork :(
Sunday, I mowed the lawn. It had really gotten out of hand how quickly it was growing and due to the last few weekend of eather, I have been unable to mow. During the week, it is even harder with work. This last few weeks have been really busy and I just don't feel like doing anything wehn I get home. I spent four hours working on the yard yesterday. I may have taken less time if it weren't for the antiquated piece of shit mower we have.
Kris sold our new mower when we moved to the apartment in Chippewa two years ago. I still can't believe she sold it for $100 when we paid almost $350 for it! It was a very nice bagmower that would have spun right through this yard in about two hours. I'm kinda irked that she sold it, especially when she sold it to one of her friends who could have just as easily gone out and bought a riding lawnmower.
I told Kris after I was done that we needed to buy a new mower because this old one really is more of a hinderance to mowing than anything else. The blades dull very quickly, the drive train on it is shot, and it weighs a ton. The thing is about 30 years old and having to push that thing up the slope of our backyard is quite a workout. Also, due to its age, despite being well taken care of, it is bad need of servicing. The motor occasionally cuts out and dies after about 30 minutes. And when the botom gets clogged with mulch, tipping it over to clean it out floods the engine and takes about 30-40 minutes to settle down.
Really, the mower is a piece of junk that should have gone to the scrapyard years ago. It does work, but having to mow the same spot three times really takes away from its usefulness. I miss my LawnKing. It was really nice. And having to spend more money to get another just really pisses me off.

