VISUAL BASIC 6
SOFTWARE DEVELOPMENT
POWER DISTRIBUTION DATABASE
COMMERCIAL PROGRAM
TRACKING OF FACILITY POWER DISTRIBUTION
DATE: 2004
TRACKING POWER DISTRIBUTION
MUTLI USE
AFTER DOING MANY POWER DISTRIBUTION WALKTHRUS, AND SINGLE LINE DRAWINGS, IT OCCURRED TO ME COMPANIES COULD USE A PROGRAM TO ADEQUATELY TRACK ALL THE BUILDING POWER DISTRIBUTION AND ELECTRICAL LOADS.
I DECIDED TO DESIGN A TOOL TO IDENTIFY ALL POWER DISTRIBUTION EQUIPMENT AND EQUIPMENT FROM THE "INCOMING UTILITY" DOWN TO "PANELBOARDS AND THE INSTALLED EQUIPMENT".
I HAD TO DEVELOP IT "BETWEEN JOBS" TO MAKE SURE MY WORK REMAINED MY OWN PROPERTY. I WOULDN'T MIND A COMPANY SHARING THE SUPPORT SO WE COULD SPLIT THE REWARDS. ALTHOUGH I'VE SEEN COMPANIES DO THIS FOR OTHER EMPLOYESS WHO DEVELOP NEW PRODUCTS, I FOUND IN MY CASE MOST ARE NOT WANTING TO SEE ME BENEFIT, SO THEY'D PREFER TO "NOT SHARE" MY DEVELOPMENT IN FAVOR OF "KEEPING THE WHOLE THING".
THIS PROJECT IS NOT COMPLETE, UNFORTUNATELY, "VISUAL STUDIO 6" GOT REPLACED BY NOW VISUAL STUDIO 2017, REQUIRNG ME TO START OVER. THIS WAS STARTED "2009-2010" WHEN I HAD MORE TIME.
MIMICKING MICROSOFT: I DESIGNED THIS PROGRAM WITH A "LOGIN" FEATURE.
I WANTED TO BE ABLE TO IDENTIFY USERS IN A MULTI USER ENVIRONMENT. I WANTED TO HAVE A RECORD OF, "WHICH USER" MADE CHANGES TO "ANY FILE". AND WHEN". IN A MULTI USER ENVIRONMENT THIS CAN HELP TRACK DOWN WHEN ERRORS ARE INTRODUCED AND BY WHOM. SO UNTRAINED PERSONS DO NOT MODIFY WITHOUT PERMISSION.
THE NEXT SCREEN ALLOWED THE USER TO SELECT A PRE-EXISTING PROJECT OR CREATE A NEW PROJECT FROM THE BEGINNING.
I WANTED THIS TO ACT LIKE A "WINDOWS TYPE" PROGRAM, WHERE THE DATA FOR EACH INDIVIUAL SITE COULD BE STORED IN SEPARATE IDENTIFIABLE PROJECT FILES. IT WOULD BE INTUITIVE TO "RETRIEVE , AND MODIFY" OR "CREATE A NEW PROJECT FILE FOR A NEW SITE PROJECT".
LIKE MOST WINDOWS PROGRAMS, THE USER IS ABLE TO NAVIGATE AND STORE/ RETRIEVE FILES FROM ANY COMPUTER DIRECTORY JUST LIKE ANY TYPICAL WINDOWS PROGRAM. THE "DEFAULT FILE TYPE" IS FILTERED TO SEE ONLY FILES RELEVANT TO THE PROGRAM IN A DIRECTORY FOR SELECTION. (ALLOWING SELECTION OF ONLY THOSE FILES YOU COULD OPEN WITH MY SOFTWARE). SO THE PROGRAM WOULD RECOGNIZE THE FILE STRUCTURE AND AVOID CRASHING BECAUSE OF SELECTING "INCOMPATIBLE FILES".)
ONCE A PROJECT IS SELECTED, THIS NEXT SCREEN ACTED AS THE PROJECT "SWITCH BOARD" TO ALL PROJECT ACTIVITY.
ONCE A FILE WAS SELECTED, THIS WOULD DISPLAY ALL THE "PROJECT DESCRIPTION DATA" FOR THAT FILE.
IN THE CASE OF A "NEWLY CREATED PROJECT", THIS USER INTERFACE ALLOWED FOR THE INPUT OF ALL "PROJECT DESCRIPTION DATA" TO IDENTIFY THE FILE.
THE INTERFACE DISPLAYS: PROJECT NAME, CUSTOMER, CUSTOMER PROJECT NUMBER, AND A "DESCRIPTION/ TITLE" OF THE PROJECT FOR IDENTIFICATION.
1. THE PANEL SCHEDULE BUTTON: ALLOWED THE USER TO OPEN A FORM ANALOGOUS TO THE SWITCHBOARD, MCC OR PANELBOARDS TO CREATE OR MODIFY EQUIPMENT POWER DISTRIBUTION ASSIGNMENT.
ALL THE BUTTONS ALLOWED THE USER TO ACCESS TO THE INPUT FORMS TO ALLOW THE USER TO CREATE A "NEW LOAD" IN THE SYSTEM AND SET ITS PROPERTIES.
2. PANEL BOARDS.DEFINE OR MODIFY DISTRIBUTION EQUIPMENT
3. EQUIPMENT: DEFINE OR MODIFY ELECTRICAL EQUIPMENT LOADS.
4. OUTLETS: DEFINE OR MODIFY ELECTRICAL OUTLETS.
4. LIGHTS: DEFINE OR MODIFY ELECTRICAL LIGHTS .
THIS FORM IS AN EXAMPLE OF USER INTERFACE TO INPUT ELECTRICAL LOAD DATA. THERE ARE DIFFERENT SCREENS FOR LOADING ALL THE ELECTRICAL EQUIPMENT IN A FACILTY AND ALSO THEIR RATINGS.
1.ELECTRICAL EQUIPMENT, 2. LIGHTS, & 3. OUTLETS.
YOU CAN SEE INPUT BOXES FOR ALL OF EACH DEVICES PROPERTIES. THIS ALLOWED THE PROGRAM TO PERFORM "LOAD AND AMPACITY CALCULATIONS". VARIOUS FIELDS ALLOWED FOR SEARCHING FOR INDIVIUAL DEVICES AND RETRIEVING EQUIPMENT LOCATIONS OR PERFORMANCE DATA.
TO THE LEFT IS THE "PANELBOARD" INTERFACE FOR A PANEL ASSIGNMENT. THE INTERFACE MIMICS A PANELBOARD SCHEDULE FOR INTUITIVE USE.
1. AFTER DEFINING A PANELBOARD IN THE DATABASE, IT WOULD APPEAR BY "ID" IN THE CENTER PULL DOWN FOR SELECTION. ALSO A PANELSCHEDULE COULD BE DEFINED WITH AN ID BY INPUTTING A VALUE IN THE PULL DOWN.
IF THE PANEL WAS PRE EXISTING, WHEN YOU SELECTED IT BY ID, IT WOULD PULL UP THE PANEL DESCRIPTIVE INFORMATION ADN AUTO POPULATE AND LOAD ASSIGNMENTS ON EACH CIRCUIT.
IT WOULD ADD THE AMPS PER PHASE AND CREATE TOTALS IN THE LOWER OUTPUT BOXES. IT WOULD ALSO SHOW THE BREAKERS SIZES FOR EACH CIRCUIT.
IF A NEW PANEL- IT WOULD ALLOW THE USER TO ENTER THE DATA AND AUTOSIZE BREAKERS AND DO ALL CALCULATIONS.
IF THE PANEL ALREADY EXISTED, WHEN SELECTED THROUGH THE PULL DOWN TOP CENTER, THE SCHEDULE WOULD "AUTOPOULATE" THE CIRCUITS AND EACH AND EVERY DEVICE ASSIGNED TO THE CIRCUITS. AMPERAGES WOULD BE TOTALED FOR EACH CIRCUIT WHILE THE SOFTWARE WOULD ALERT IF A CIRCUIT WAS OVER LOADED. "AUTO-POPULATION" DID INSTANT "RECALULATION" OF PHASE LOADING TO HELP IDENTIFY PANELBOARD IMBALANCE BETWEEN THE PHASES. YOU COULD ALSO MODIFY PANELBOARD PROPERTIES THROUGH THIS INTERFACE.
BY SELECTING -(DBL-CLICKING) AN INDIVIDUAL CIRCUIT INPUTBOX - THE PROGRAM PRODUCED A "POP UP" WHICH ALLOWED THE USER TO SEE THE INDIVIDUAL ITEMS LOADED ON THE CIRCUIT.
EACH ITEM LOADED ON A CIRCUIT WOULD HAVE ITS CORRESPONDING AMP RATING IN ANOTHER COLUMN WHICH ALL WERE SUMMED FOR ANALYSIS BY THE USER. ON THE RIGHT THE USER COULD SELECT ANY CIRCUIT "BY NUMBER" TO SEE ITS SIMILAR LOADING. LOADS COULD THEN BE MOVED BY "DRAG-DROP" FROM CIRCUIT TO CIRCUIT AND "RE-ANALYZIED" AND LOAD SUMMED.
THIS FORM ALLOWED THE USER TO BRING UP A LIST OF ALL UNASSIGNED LOADS, SORTED BY TYPE. AND ON THE RIGHT A LIST OF EACH CIRCUIT ON A TAB, THAT WHEN SELECTED, BROUGHT UP THAT CIRCUITS LOADING
THIS ALLOWED THE USER TO DRAG-DROP "UN-ASSIGNED" LOADS TO INDIVIUAL CIRCUITS FOR ASSIGNMENT WHILE SEEING THE LOAD EFFECT ON THE CIRCUIT. THE LOAD NOW BEING ASSIGNED WOULD THEN DISAPEAR FROM THE UNASSIGNED LIST. THIS ALLOWED THE USER TO CHECK THAT ALL LOADS WERE ASSIGNED AND NOT "FORGOTTEN".
.
THE USER ALSO BRING UP A LIST OF ALL UN-ASSIGNED LOADS. BY RETURNING TO THE MAIN POWER DISTRIBTION DEVICE FORM, IT THEN SHOWED ALL NEWLY REASSIGNED LOADS AS WELL AS AN OPTION TO IDENTIFY ALL OVERLOADED CIRCUITS OR THE NEED TO RESIZE A BREAKER. ALL CALCULATIONS COULD THEN BE PERFORMED TO FILL OUT THE PANEL SCHEDULE AND ASSURE PHASE BALANCING.
OPENING THE PROJECT DATABASE FILE IN MSACCESS ALLOWED USER TO GENRATE REPORTS AND PANEL SCHEDULES WITH A CLICK.
I AM ALMOST SURE SOMEONE WILL SEE MY PROGRAM AND RUSH IT TO DEVELOPMENT. SINCE LARGE COMPANIES HAVE MONEY. BUT AGAIN REMEMBER YOU SAW IT HERE 1ST.(2016)
I CREATE GREAT IDEAS AND CAN PRODUCE WHILE OTHERS GET RICH AND COPPY MY IDEAS AND WORK. YET I AM WITHOUT A PROFITTABLE JOB, HAVE NO INSUARNCE, GIVEN NOTHING FOR RETIREMENT. AND PEOPLE ON JOBS TRY TO USE OR LAY ME OFF TO PROTECT THIER POSITIONS. UPPER MANAGEMENT OFTEN TAKES NO TIME TO REVIEW WHATS GOING ON TRUSTING MIDDLE MANAGERS WHO GET RID OF ANY COMPETITION. WHILE FRIENDS WHO HAVE NOT INNOVATED ANYTHING , MAKE LIGHT AND SUGGEST I WORK HARDER BECAUSE THEY HAVE CUSHY JOBS AND NO ONE HAS EVERY ASKED MUCH OF THEM.
Bootstrap Slider