Sunday, August 28, 2011

Allo everyone. Just checking in.

I thought of my blog because recently I was doing a project for my moms insurance company, and it was stuff I hadn't really dealt with before. So I just thought I'd share a few methods I used.

The issue was that she had to fill out 70+ forms a day with basic information copy and pasted from a spread sheet, and wanted it to be auto-mated. The spreadsheet was excel, and the document was a .PDF

First off I just built the basic interface in netbeans
       -File selection module for selecting excel/pdf files
       -Start button
       -TextArea for errors and such (Ex. No file selected)
Then imported the API's for reading/writing such files
       -Jxl [Java excel file reader]
       -AprisePDF
There were 7 columns.
       -Corp. Id
       -Corp Name
       -blank
       -rep first name
       -rep last name
       -insurance type
It was pretty easy to rip the info from the xl file, but the insurance type was the only slightly difficult one.
For each insurance type there was a repeated row with only the insurance type field changed, so you had to somehow skip over these rows so you don't get extras, and you have to figure out all the types of insurance they have.

The insurance types stack, so you only really have to count the number of rows containing the corp ID.
Solution:

try {         
w = Workbook.getWorkbook(inputWorkbook);
Sheet sheet = w.getSheet(0);
while (sheet.getRows() >= row  ) {
nt insurancetype = 1;
System.out.println("SchoolID: " + sheet.getCell(0, row).getContents());
System.out.println("Name: " + sheet.getCell(1, row).getContents());
System.out.println("Representative: " + sheet.getCell(5, row).getContents() + " " + sheet.getCell(6, row).getContents());
if (sheet.getCell(0, row).getContents().contentEquals(sheet.getCell(0, row+1).getContents())) {
nsurancetype++;
}
if (sheet.getCell(0, row).getContents().contentEquals(sheet.getCell(0, row+2).getContents())) {
insurancetype++;
}
if (sheet.getCell(0, row).getContents().contentEquals(sheet.getCell(0, row+3).getContents())) {
insurancetype++;
}
if (sheet.getCell(0, row).getContents().contentEquals(sheet.getCell(0, row+4).getContents())) {
insurancetype++;
}
System.out.println("insurance type: " + insurancetype);
row = row+insurancetype;
System.out.println(row);
replaceAxisGlobal(Integer.parseInt(sheet.getCell(0, row).getContents()), sheet.getCell(1, row).getContents(), insurancetype, sheet.getCell(5, row).getContents() + " " + sheet.getCell(6, row).getContents());
}
} catch(Exception ex) {
System.out.println(ex);        
}


Monday, July 11, 2011

Java game development.

I've gotten down to bussiness and am finally actually learning full java. This is probably going to take a while, however I'm getting into game design now. Real game design. Not MapleStory. But maybe I'll be back sometime. Just for fun.

Tuesday, July 5, 2011

It's been a while since I've last posted..

It's been a while since I've last posted and I decided I'd give whoever reads this an update on my computer life. I've been playing GMS probably a bit too much, and am now level 99, along with PalTheHealer, who is 95. Our guild has leveled up to 2 and we have about 25 members. I also have about 10 mill. on my character, and am dealing a total of 142,000 damage with swipe.

[Zenith]
Guild: HymenShock
Alliance: SuperPimp
GuildRep: 30,000
FamilyRep: 47,894
| HandCappedX | Level 99 | Str+24/Dex+20 | 10,000,000 mesos | Guild contribution 5k+ |

In other news, I've started learning Python, the programming language. Its a very compact language, and it seems to have a friendly community of developers which I'm looking forward to learning from. I'm pretty early in the learning phase and only know how to do a few simple things, as I just started learning tonight.

Learning/Learned:
String functions
Importing functions
Math functions
Random Numbers
Etc
etc

Thursday, June 23, 2011

Status report..

I haven't posted in a couple days, sorry about that. Yesterday I hit up Hurricane Harbor with friends, and stayed out late, so I didn't have much time for anything.

So here's the news. I decided to make a guild, 'HymenShock'. Nice name right? Anyways yeah, the guild is just friends irl currently, but that'll probably change when we start expanding. Other news, I hit level 50 with HandCappedX, I hit level 41 with 8BitWinner, and we started new Cygnus characters for fun. The other guys are 33 or so, and I'm 26 because I'm a day behind.

Tl;dr:
8BitWinner - 41 I/L Wizard
HandCappedX - 50 Wild Hunter
HymenSlapper - 26 Blaze Wizard
Guild [Zenith] - HymenShock - 1 10000/20000 GP

Tuesday, June 21, 2011

MapleStory level 1-42 SpeedRun

Yesterday my friends and I decided to make new chars in Zenith and see how high we could get them. The five of us all hit 40+ within ten hours of playing. :D


So now I have a new level 42 Wild Hunter, and they're super fun to play.

Chars (Zenith):
HandCappedX - WildHunter - Level 42
8BitWinner - I/l Mage - Level 37

Buddies: Borghald, SpiritToast, SpiritMuffin, Tamik, PalTheHealer

Oh and we're planning on making a guild when we get to fifty, because now we have 5 constant players. Join us?

Monday, June 20, 2011

2000 Views! Excitement. :)

Its pretty cool to hit 2,000 views, and still be growing at an exponential rate. I started playing GMS with a couple friends yesterday, so I suppose I'll keep everyone updated on that as well as whatever else I decide to code. I figure some people need high level characters for packets, so I might as well help them out, and its fun to be playing again.

Started at level 27 yesterday, got off at 2AM this morning and was level 37. I've already done all of the Mushroom Kingdom quests, and now I'm moving on to Orbis. I'm playing in the Zenith channel, and if anyone wants to get a guild started, I'm sure we could work something out.

Current Character: 8BitWinner-37-I/L Mage
Buddys Playing: Borghald, SpiritToast.

Sunday, June 19, 2011

More updates!

Even though Kevin told me not to, I decided to run some updates because I've been bored out of my mind. Here's the rev log for builds three and four.

Screen shots are coming soon.

*Build 3*
[+]ServerConstants
    *Now contains data for WeaponLeveling
[+]MapleMap.java
    *Has WeaponLevelUp Methods
    *Imports ServerConstants.java
[+]Added dropOverheadMessage Method in MapleCharacter.java
[+]MapleMonster and ServerConstants are now imported into Equip.java
[+]Added the rest of WeaponLevelup methods into Equip.java
[+]Imported Equip.java into Commands.java
[+]Added Commands
    *@WeaponLevel - Displays your weapons level
    *!LevelWeapon - Levels up your weapon
*Build 4*
[-]'[Notice]' no longer shows up when dropping messages
[-]Temporarily removed Zakum event for testing
[x]Fixed stupid bugs