Archanos

Male
from Malkier, The Blight

  • Activity

    • VBA - Excel as an RDb

      6 years ago

      Archanos

      Well, like it or not, one of the things I have to put up with at work is the fact that we can't develop or edit real Relational (SQL) Databases. Even Access is out of the question due to the way the SharePoint server is configured, and no, they won't let us change the settings.

      However, one of the many tricks I learned early on last year when working on information service solutions for my department, and have made great strides in perfecting, is using VBA applications that work inside of Excel to use Excel's worksheets as data tables with specialized code that allows me to use and edit information in Excel like a true relational database. I have to manage all the data heirarchies in runtime, so it's not as flexible-on-the-fly like Access or SQL would be; but, I have developed some really powerful input/reporting applications for my department. With the OOP I've learned to use it just keeps getting more accurate, more efficient, and much faster to develop full-feature applications.

      A recent re-development of an old Excel spreadsheet we used to one of my Excel Databases is nearly complete. So far it uses 6 separate worksheet data tables for the database pre-sets that can be customized/edited by the user and 2 worksheet data tables for the input records/reporting.

      The reporting tool itself can generate charts and report tables based on performance overtime for all of the data; and, it can output those charts and reports directly into PowerPoint slides and Word documents. Unlike the previous version of the analysis algorithm that analyzed the data in a 4 dimensional array, this new one is able to analyze the data in a 6 dimensional array and be delimited to a particular span of time.

      If you're scratching your head over why I am using a data analysis algorithm that uses a 6 dimensional array, I'm not surprised. Believe me, I looked at every possible solution to this problem from every angle I could. This was the only solution that allowed me to generate the reports that my superiors were expecting in a timely manner.

      For example, to create the charts, format them, label them, and copy them into a PowerPoint presentation it would normally take me hours. The algorithm crunches the data and creates all the charts I need and copies them into PowerPoint/Word in less than 30 seconds.

      Three years ago I used to use Excel formulas with linked charts and tables, but the amount of time it took to recalculate after every data entry was annoying. I'm talking data sets of over 27,000 records and well over 4,000 multi-conditional COUNTIFS(). My algorithm does it faster and I don't have to worry about whether or not the data is accessible to PowerPoint after the presentation is made.

    • 6 years ago

      Archanos
    • Computer burn out sucks.

      6 years ago

      Archanos

      Well, my not so old system burned out to the point that it could not be salvaged. How burned out was it? Well, let's just put it this way, the AMD Phenom CPU was actually fused into the socket. Motherboard was toast, so was the CPU and the RAM. And, hey! Why stop there? It also completely fragged my Raid 0 OS drives, so I got to lose all the data on those. Happy, happy, joy, joy. (I learned years ago to make regular back-ups, so I didn't lose anything.)

      Well, that just meant I got to build a new system. Did not use AMD or ATI parts on this one. I went full hog with an EVGA X58 4X Classified motherboard and a 6-core Intel i7 990 Extreme edition CPU and 24GB of RAM. The GPU on this build is a EVGA 680 4GB. I am very, very very happy with this system. There is a slight delay when accessing seldom used hard drives, but I have no complaints other than that.

      I'm working on a desktop mod to change how I access programs and system information on the fly. So far it's look'n pretty sweet. I'll post a screenshot of my desktop up in my image galleries, and once I get done configuring the cabling and drives on the inside I'll post shots of the finished system.

      On the programing side of things I'm starting to learn OOP VBA and VB.NET. Wish me luck on that stuff. I'm still scratch'n my head about how exactly classes function.

    • Long time . . .

      7 years ago

      Archanos

      Well, it has been a while since my last update. (Over a year) But, I've been peeking my head in to watch the videos posted between work and Warcraft.

      Yes, Warcraft. I did start to play again, but then something happened last week. Blizz released Version 5.0.4, and the changes they made to my favorite character classes ruined the game. Entirely. I've canceled my subs, I am never going back. Notice that I haven't used any curse words about the changes, because Warcraft really isn't worth the effort to curse out anymore. I tried Diablo III (heck, it was free with the annual pass) and it couldn't hold my interest past 15 minutes.

      I'm sad that I have to leave the game. smiley2.gif I met a lot of great people in the game, and some not so great, we had fun in the raids and instances, but that started to change gradually over the past two years. People would server/facton hop, stop playing because of x and y, and the guild I was in originally ended up being just me after I took a two month break from the game. Found another guild, but that one only had a few active (if you could really call it that since they rarely talked) members. I liked the socializing and snarky remarks people made in my first guild. Those days are gone now and it's time to move on. I really thought I would be able to play until the very last expansion was released for it, but, oh well.

      That will just free up more of my time to live my life and build applications. I've become quite good at VBA for Excel and building reporting algorithms that crunch hundreds of thousands of rows of data to create meaningful data analysis and charts that I can use to justify the benefits of initiatives and programs where I work. I am going to be taking my VBA skills to the limit with my next project. A full fledged student information system housed inside of an Excel workbook. I know I could use Access to build it, and I could, I have the skills and experience to do so standing on my head, but there are several reasons why I'm going with Excel.
      1. Our data servers are SharePoint
      2. SharePoint lists, with the amount of data we are going to be pushing, are extremely slow in Access
      3. The SQL server another department uses for their projects is not exactly approved and could be *yoinked* at anytime
      4. Data analysis, number crunching and charts are more easily done inside of Excel
      5. With Excel VBA I can tweak and tool to do a number of special case implementations and cross check for data entry errors before the data is committed to the spreadsheets.
      6. Everyone at work is addicted to Excel.

      I would really, really, really like to code an SQL/ASP implementation to manage the data on an SQL server like Oracle, but as I said, the SQL server (they're using Microsoft's SQL Server) is not exactly approved to be running in the configuration it is and they could pull the plug on it any day at any hour. So if that were to happen we would lose access to all of our records. Yes, we could configure the SQL to incrementally back itself up to a specific file on the SharePoint, but it would not really do us any good unless we had a program running that could pick up right when the sever was disconnected so we wouldn't have any downtime while we try and get another server up and running, if we could.

      So far in the past year I have developed another 9 full applications inside of Excel. Some of the VBA code I've developed for these applications does stuff that even online forum sites run by professionals said is impossible to do in Excel. smiley0.gif It is a little more difficult for me to develop applications compared to a normal software development environment because I am the only one in my department that knows how to develop software. So that means I have to write the requirements, develop the design of the application, write all the code, and then do all the scenario testing myself. Makes it interesting, but it gets a little cumbersome having to perform all the levels of software development by myself.

      Next I plan on learning programming in C in preparation to move on to iOS application development. Notice I said "application" not "app". I'm not looking forward to becoming a millionaire through the app store. I am very interested in Objective C development as well as C# for Microsoft OS just from a personal growth stand point.

      I think some of my journal entries in the future might be some of the more advanced and trickier implementations of VBA that I've developed. Let me know what you guys think. (If anyone is still watching me that is smiley6.gif )

    • Technical Acronym Translations

      13 years ago

      Archanos

      LAST UPDATED :: 2011.08.20 : Wednesday @ 1500 Hrs

      For those who read my Journals and say, "WTF is he babbling about?" These acronym translations should help you out. Later I'll make another journal with definitions and technology explanations. I will be adding to this list....

      Interfaces
      AGP - Accelerated Graphics Port
      ATA - Advanced Technology Attachment
      CF - Crossfire
      DEAMON - Disk And Execution Monitor
      EPP - Enhanced Performance Profile
      DSL - Digital Subscriber Line (as in xDSL)
      DVI - Digital Video Interface
      ENET - Ethernet
      Gbps - Gigabits per second
      GHz - Gigahertz
      HT - Hyper-Threading [Intel] (also Hyper-Transport [AMD])
      HTTP - Hypertext Transfer Protocol
      HTTPS - Hyper Text Transfer Protocol Secure sockets
      I/O - Input / Output
      IDE - Integrated Drive Electronics
      IEEE 1394 - Institute of Electrical & Electronics Engineers high speed serial bus standard (FireWire, iLink)
      IP - Internet Protocol
      iSCSI - Internet Small Computer Systems Interface (over TCP/IP)
      ISDN - Integrated Services Digital Network
      ISA - Industry Standard Architecture (PC slot)
      Kbps - Kilobits per second
      LAN - Local Area Network
      LPT - Local Printer Terminal
      Mbps - Megabits per second
      MHz - Megahertz
      MIDI - Musical Instrument Digital Interface
      PATA - Parallel Advanced Technology Attachment
      PCI - Peripheral Component Interconnect (Personal Computer Bus)
      PCIE - Peripheral Component Interconnect Express (Personal Computer Bus)
      PS2 - Personal System 2
      RAID - Redundant Array of Inexpensive Disks (Redundant Array of Independent Disks)
      QXGA - Quantum EXtended Graphics Array (2048 x 1536)
      QSXGA - Quantum Super EXtended Graphics Array (2560 x 2048)
      SATA - Serial Advanced Technology Attachment
      SCSI - Small Computer Serial Interface
      SLI - Scalable Link Interface
      SLI - Scanline Interleave Mode
      SSH - Secure Socket Shell
      SSL - Secure Socket Layer
      SVGA - Super Video Graphics Array (800 x 600)
      SXGA - Super Extended Graphics Array (1280 x 1024 [1.25:1])
      SXGA+ - Super Extended Graphics Array Plus (1400 x 1050)
      T1 - T-carrier 1 (digital transmission line, 1.544 Mbps, 24 voice channels)
      T2 - T-carrier 2 (digital transmission line, 6.312 Mbps, 96 voice channels)
      T3 - T-carrier 3 (digital transmission line, 44.736 Mbps, 672 voice channels)
      T4 - T-carrier 4 (digital transmission line, 274.176 Mbps, 4032 voice channels)
      TCP - Transmission Control Protocol
      USB - Universal Serial Bus
      UXGA - Ultra EXtended Graphics Array (1600 x 1200)
      VGA - Video Graphics Array (640 x 480)
      WAN - Wide Area Network
      WiFi - Wireless Fidelity (IEEE 802.11b Wireless Networking)
      WXGA - Wide Extended Graphics Array (1366 x 768 [1.78:1])
      WSXGA - Wide Super Extended Graphics Array (1680 x 1050 [1.6:1])
      WUXGA - Wide Ultra Extended Graphics Array (1920 x 1200 [1.6:1])
      xDSL - x Digital Subscriber Line (any type)
      XGA - Extended Graphics Array (1024 x 768)

      Hardware Components
      AT - Advanced Technology
      ATX - Advanced Technology Extended
      BIOS - Basic Input/Output System
      BIOS - Basic Input/Output Services
      BIOS - Binary Operating System (computers)
      BIOS - Built in Operating System
      BTX - Balanced Technology Extended
      CAS - Column Address Signal
      CCD - Charge Coupled Device
      CCFL - Cold Cathode Flourescent Light
      CD - Compact Disk
      CF - Compact Flash
      CMOS - Complementary Metal-Oxide Semiconductor
      CMOS - Configuration Memory Operating System
      CPU - Central Processing Unit
      DDR - Double Data Rate
      DIMM - Dual In-line Memory Module
      DL - Dual Layer
      DVD - Digital Versatile Disk
      DVD - Digital Video Disk
      DVD - Digital Video Drive
      FDD - Floppy Disk Drive
      GDDR - Graphics Double Data Rate
      GPU - Graphics Processing Unit
      HDD - Hard Disk Drive
      HD-DVD - High Definition Digital Video Disk
      HS - Heat Sink
      IGP - Integrated Graphics Processor
      KBD - Keyboard
      LCD - Liquid Crystal Display
      LED - Light Emiting Diode
      MCR - Memory Card Reader
      MSE - Mouse
      NPU - Network Processing Unit
      OLED - Organic Light Emitting Diode
      PC - Personal Computer
      PDA - Personal Data Assistant
      PPU - Physics Processing Unit
      PSU - Power Supply Unit
      PRT - Printer
      PWM - Pulse Width Modulation
      RAM - Random Acess Memory
      ROM - Read Only Memory
      SD - Secure Digital
      SSD - Solid State Drive
      SIMM - Single In-line Memory Module
      SPU - Sound Processing Unit
      TFT - Thin Film Transistor

      Miscellaneous
      DD - Dolby Digital
      DTS - Digital Theater Sound
      THX - [not an acronym] Lucasfilm quality standards (name derived from Tomlinson Holman's eXperiment and from George Lucas's first movie, THX-1138)

      Personnel
      CTA - Computer Technology Associate
      OEM - Original Equipment Manufacturer
      RMA - Return Merchandise Authorization

      Power Supplies
      OCP - Over Current Protection
      OLP - Overload Protection
      OTP - Over Temperature Protection
      OVP - Over Voltage Protection
      PFC - Power Factor Correction
      SCP - Short-Circuit Protection
      UVP - Under Voltage Protection
      VAC - Voltage Alternating Current

      Software
      ASCII - American Standard Code for Information Interchange
      ASP - Active Server Page
      AVI - Audio Video Interleaved
      DB - Database
      DHTML - Dynamic Hypertext Markup Language
      DV - Digital Video
      EBCDIC - Extended Binary Coded Decimal Interchange Code
      GIF - Graphics Interchange Format
      GUI - Graphical User Interface
      HTML - Hypertext Markup Language
      JPEG - Joint Photographic Experts Group
      MP3 - Moving Picture Experts Group Layer-3 Audio
      MPEG - Moving Picture Experts Group
      OS - Operating System
      OCR - Optical Character Recognition
      P2P - Peer to Peer Network
      PHP - Hypertext Preprocessor
      PNG - Portable Network Graphics
      VBA - Visual Basic for Applications
      WMV - Windows Media Video
      WYSIWYG - What You See Is What You Get
      XHTML - Extensible Hypertext Markup Language
      XML - Extensible Markup Language

      Storage
      BIT - Binary Digit (0 or 1)
      BYTE - Binary Table (Contains 8 Bits [01101001])
      Gb - Gigabit (1,000,000,000 bits [or 10^6 bits])
      GB - Gigabyte (1,000,000,000 bytes [or 10^6 bytes])
      Kb - Kilobit (1,000 bits [or 10^3 bits])
      KB - Kilobyte (1,000 bytes [or 10^3 bytes])
      Mb - Megabit (1,000,000 bits [10^6 bits])
      MB - Megabyte (1,000,000 byte

    • 2019 years ago

      Archanos
    • 2019 years ago

      Archanos
  • About Me

  • Comments (186)

    • Strider165

      10 years ago

      Definitely need pictures.

    • Strider165

      10 years ago

      That thing is pretty damn sexy.

    • Strider165

      10 years ago

      Yeah, I would definitely wait for a while. Not worth it, yet.

    • Strider165

      10 years ago

      Core i7 processors get rid of front side bus. It uses a supposedly faster "QuickPath Interconnect."

    • Strider165

      11 years ago

      Thanks!

    • Strider165

      11 years ago

      Well you could just not build one for a few years. Don't stop completely!

    • Strider165

      11 years ago

      Fair enough. Looks like a really nice card either way.

    • Strider165

      11 years ago

      Just something so that you don't have to swap out ALL the drives. You can just let them die one by one.

    • Strider165

      11 years ago

      RAID array smiley8.gif

    • Strider165

      11 years ago

      If I was a bit more focused, I'd probably engage you in this intellectual discussion. smiley6.gif

    • egamer86

      11 years ago

      Vol 4 of Madlax and Star Ocean EX are missing. I've been (trying) to watch them for like a week. I still have them though.

    • egamer86

      11 years ago

      I've got a question for you. What would you choose for a system RAM upgrade? PC2-8500 with CAS of 5-5-5-15 or PC2-6400 with CAS 4-4-4-12.

      Just thought I'd ask someone else that might understand my dilemma.

    • Strider165

      11 years ago

      Wow, that's rough.

      You should make yourself laugh. smiley8.gif

    • Strider165

      11 years ago

      Ah, that sucks. Good that you have backups at least.

    • Strider165

      11 years ago

      WoW can really suck people in. Glad to see you've come back to reality! smiley8.gif

    • Strider165

      11 years ago

      Sweet! Awesome to see you back, man!

      I've added you and put you back on watch! Sorry about that, I just wasn't sure you were actually coming back.

    • Strider165

      12 years ago

      Holy crap, you're on? You haven't been on in like 4 months.

    • Strider165

      12 years ago

      Hey, I'm going to take you off watch/friends list because you haven't been around much for a long time. Let me know if you're going to become active again, and I'll gladly friend request you and all that again. Good luck with everything!

    • egamer86

      12 years ago

      The thing is, I did that with the drivers. All of them are the most up to date, but they still want to be all shitty and not have the resolution I want. Also, my OS is XP not Vista yet. I don't think Vista is good enough at the moment to put on my computer. I was going to go with the x64 version of XP as well, but a lot of the programs I need for school don't have 64 bit support.

    • egamer86

      12 years ago

      I've got the nVidia 8800GTX and an Intel E6600 Core 2 Duo.

    • Strider165

      12 years ago

      Yeah, from what I hear, right now their in a tight situation financially.

    • egamer86

      12 years ago

      Would you happen to know what needs to be updated so that way I can set my resolution to 1280x768? My drivers currently don't have that resolution listed. It's kinda pissing me off...

    • Strider165

      12 years ago

      Haha, fair enough.

    • Strider165

      12 years ago

      Yeah, both companies are well respected and usually ahead of the game. *shrug*

    • Strider165

      12 years ago

      The majority of companies I thought had decent drivers out for Vista, or the XP drivers work for vista. I'm surprised to hear you bring up companies like that not having drivers. They're quality companies.

    • Strider165

      12 years ago

      It's been too long good sir. Come join us once more.

    • Strider165

      12 years ago

      Where have you been?

    • last_one

      12 years ago

      Yep it is. And the mac ones seem to fit too, they're all cute on the outside but inside they are pure evil.

    • last_one

      12 years ago

      I dont even use ghost anymore, i just keep my windows boot on a fat32 partition and back it up when I backup suse.

      But anyways i was talking about norton's OS tan character...the old lechard.

      Post edited 9/26/06 6:05PM

    • Strider165

      12 years ago

      Yeah, it's a big undertaking if you actually want to make it a side buisness. However, you could just try selling one on ebay and see how it goes.

    • last_one

      12 years ago

      buy a generator.

    • Strider165

      12 years ago

      haha, sorry....I just happened to go back to my homepage and see you on my watchlist right after you posted it

    • damhippies99

      13 years ago

      well for practice we mainly use bokken's but we do use real swords on ocassion go to www.budk.com. i got the heavy metal master 2...my baby. a tai chi and the dragon master sword with the double agent buouy

    • last_one

      13 years ago

      Actually, you can't straight out install OSX on a pc (intel based machines like IBM's you can with a little bit of hacking) but i'm installing panther, and that I need a cpu emulator for, good thing mac programing doesn't take up much power.

      Thank you god for open source programing.

      Post edited 8/10/06 1:41AM

    • egamer86

      13 years ago

      Damn dude...

    • Strider165

      13 years ago

      Oh, ok. Still though, the thing has to be pretty kick ass.

    • egamer86

      13 years ago

      Etched titanium always = cool

    • SptnReaper

      13 years ago

      Preferably, something compatible with Alienware computers.

    • SptnReaper

      13 years ago

      I would use it more for Gaming and Photos. Budget wise, Under $120 for the card.

    • omegawolf

      13 years ago

      lol, you do too much. You're not superman you know. *shameless quote*

      Anyway, it's a favor. I expect it to be on the backburner for more important things so take your time. I believe my cooling equipment will be arriving today en mass though so hopefully I can get that set up, the leaks worked out, and by tomorrow get it installed.

    • omegawolf

      13 years ago

      Yeah, tell me about it. My last system was fantastic like that. I can't believe it's that difficult to block the wires back together after splicing connectors on them. Of course, I could do it myself, but I'd have to "crack the code" first.

    • omegawolf

      13 years ago

      yeah...i believe looking at manuals is against my manly nature as well smiley8.gif And since the case doesn't actually have any manuals per se, I'll have to take note of what's printed on the connectors and get back to you. It was fairly puzzling.

    • omegawolf

      13 years ago

      What 's the mobo and case model, and what front-x controls are you referring too? Onboard sound interface or the regular front panel reset, power buttons and LED's or is it something else?

      We have the same mobo, even if you did go the whole way and fit it with CrossFire. Check the manual, I'm attempting to conect the earphone and microphone from the case tot he mobo...and so far I haven't had much luck getting either to work correctly. My case is the AeroCool CoolView like I posted in my journal. If I do end up making one last attempt at connecting it correctly than it'll have to be before I install the watercooling, because once I do that I'm not really going to want to open it up again except to install additional ram and the X1900.

    • tigergirl

      13 years ago

      thank you

    • SptnReaper

      13 years ago

      you think im going to retract my request?

      hmmmm deny or accept my friend.

    • omegawolf

      13 years ago

      Yeah...I'd much rather be playing games at this point but in the interest of being ABLE to play those games...I'll make a few sacrafices to get this thing kick ass.

    • Strider165

      13 years ago

      Ah well....hopefully you can finagle something. I didn't even realize you could mod heatsink/fan's but it makes sense.

    • Strider165

      13 years ago

      Wow, that's pretty hott.....or should I say cool.... smiley6.gif
      Sucks about the RAM though, never fun when you have to remove other components just to upgrade the RAM.

    • Strider165

      13 years ago

      Very cool, how do you modify them? just out of curiosity.

    • egamer86

      13 years ago

      But you are making so much more money than me. I mean, you can finance your computer spending with your job. I can barely cover a month's rent with mine.

  • Archanos's Pictures

    Images

  • Questions

    No questions have been answered yet