MICROSOFT OFFICE
AP DEVELOPMENT
MICORSOFT OFFICE PROGRAMS
OFFICE DOCUMENTATION
USE OF TYPICAL WINDOWS PRODUCTIONS
DATE: 2003-2018
MICROSOFT OFFICE
MUTLI USE
I UNDERSTAND THAT MICROSOFT OFFICE IS VERY USEFUL AND OFTEN THE "STANDARD TOOL" FOR OFFICE WORK.
A LOT OF COMPANIES IN THEIR JOB PREREQUISITES IDENTIFY MICROSOFT OFFICE AS A REQUIREMENT. THIS SAMPLE IS TO SIMPLY CONFIRM MY BASIC ABILTY IN MICROSOFT OFFICE TOOLS.
I CAN WORK WITH EXCEL, MS ACCESS, POWERPOINT, OUTLOOK ,VBA, VISUAL BASIC AND OLDER VERIONS OF MS PROJECT (IT HAS BEEN OVER A DECADE SINCE I WORKED IN MANAGEMENT, MSPROJECT HAS CHANGED AND I HAVE NOT HAD ACCESS TO THE SOFTWARE TO MAINTAIN MY SKILLSET.)
EXCEL.
HERE ARE A FEW EXAMPLES OF EXCEL I HAVE DONE- TO ASSURE YOU MY BASIC USE OF THE PRODUCT. I ADMIT I AM NO EXCEL EXPERT.
I HAVE WITNESSED SOME OF YOU TURN EXCEL INTO A COMPUTING TOOL.
I'D LIKE TO RECCOMEND THAT VBA WOULD BE THE TOOL OF CHOICE TO PROGRAM AND REDUCE ERRORS AND IS A LOT MORE FLEXIBLE. EXCEL CONTAINS VBA.
1. I HAVE DONE SPREADSHEETS TO SIMPLY SORT AND STORE DATA. (THE PRIMARY USE OF A SPREADSHEET.)
THIS A "SWITCHBOARD" TO DEFINE AND HYPERLINK VARIOUS OTHER SPEADSHEETS FOR INTUITIVE ACCESS. (A DEPARTMENT LIST FOR EQUIPMENT ASSET MANAGEMENT IS SHOWN). EQUIPMENT IS SORTED BY DEPARTMENT.
"CALCULATIONS USING FUNCTIONS".
HERE IS A TIME SHEET THAT I CREATED. I HAD TO SUBMIT EVERY ACCOUNTING PERIOD. I DECIDED TO AUTOMATE THE DATES OF EACH WEEK IN THE PERIOD, BASED ON A "PULL DOWN" MENU TO SELECT THE PERIOD. RATHER THAN HAVE TO RETYPE DATE CHANGES,EACH MONTH.I SHARED THIS FORM WITH OTHER CONTRACTORS TO USE.
SO TIMESHEETS WOULD BE UNIFORM.
SELECTING THE PERIOD FROM THE "PULL DOWN MENU" CHANGES THE DATES AUTOMATICALLY.
HERE I AM CHANGING FROM "PERIOD 1" TO "PERIOD 4".
.
THE VALUES IN THE DATES COLUMNS CHANGE AUTOMATICALLY.
THE HOURS SHOWN IN EACH ROW WERE SUMMED IN A VERTICAL COLUMN FOR ALL PROJECTS. ALL HOURS AND EXTRA DATA WERE SUMMED IN COLUMNS IN THE ROW AT THE BOTTOM RIGHT. TOTAL COST SUMMED ACROSS THE BOTTOM ROW. (A TYPICAL SPREADSHEET DESIGN USING FUNCTIONS)
THE MACRO WAS DONE IN VISUAL BASIC FOR APPLICATIONS EMBEDDED IN THE SPREADSHEET. THIS WAS A SIMPLE MACRO. HERE IS PART OF THE CODE ON THE IMAGE ON YOUR RIGHT.
SIMULATING A DOCUMENT DESIGN: HERE IS A PANELBOARD SCHEDULE- CALCULATIONS WERE AUTOMATED BY EXCEL FUNCTIONS TO ADD THE AMPACITIES OF EACH COLUMN BY PHASE.
(MORE INTUITIVE EASY TO FILL IN VIA COMPUTER)
1. SWITCHBOARD :(HYPERLINKED). SELECTING A BUTTON NAVIGATES THE USER TO THE APPROPRIATE DEPARTMENT LIST OF SPREADSHEETS.
2. SECONDARY SWITCHBOARD. SELECTING THE DRAWING DISCIPLINE NAVIGATES THE USER, TO THE DRAWINGS OF THE CORRECT DRAWING LIST, FOR THAT DEPARTMENT.
3. DESTINATION: DRAWING TRACKING SPREADSHEET. SHOWS EACH INDIVIUAL DRAWING STATUS AND PROPERTIES FOR PROJECT DRAWING MANAGEMENT.
HERE IS AN EXAMPLE OF "VBA" USE. HERE I AM INVOKING A CALENDAR CONTROL FOR INPUT OF DATES. AUTOMATED RATHER THAN HAVING TO HAND TYPE DATES AND CONSULTING A CALENDAR.
1. SELECTING THE CELL PRODUCES A DIALOG- SAYING I'M LAUNCHING A MACRO. (THIS IS FOR MY INFORMATION ONLY. I WILL REMOVE LATER). NOTE CHANGES TO EFFECT THE HIGHLIGHTED CELL CONTAINING "2/27/2018"
2. SELECTING THE CELL PRODUCES A PULL DOWN MENU FOR THE DATE.
3. THE "DATE CONTROL" IS INVOKED BY CLICKING ON THE PULLDOWN MENU, TO SEE THE CALENDAR CONTROL.
I WILL SELECT 4/18/2018, AS MY NEW DATE TO ENTER.
SELECTING THE DATE FROM THE CALENDAR CONTROL- INPUTS THE DATE BACK INTO THE SELECTED CELL.
HERE IS THE VBA CODE THAT PERFORMS THE TASK. JUST TO SAY, I DO PROGRAM SOME VBA.
EXCEL.
PROBLEM IS MICROSOFT OFTEN CHANGES PROGRAMMING OBJECTS, METHODS AND EVENTS FROM WINDOWS VERSION TO VERSION.
REQUIRING ME TO EXPERIMENT IN ORDER TO RECREATE WORK I'VE ALREADY DONE BEFORE. I AM NOT A WINDOWS DEVELOPER. I DO SIMPLE VBA ON AN AS NEEDED BASIS. SOMETIMES IT TAKES TIME TO WORK OUT THE IDIOSYNCRASIES DUE TO MICROSOFTS UNEXPECTED CHANGES.
PEOPLE WILL OFTEN CHALLENGE ME TO DO A SIMPLE TASK- THEN WHEN IT TAKES AN HOUR - THEY GO "OH THATS O.K. - I DIDN'T THINK IT TOOK THAT LONG" (MEANING THEY THINK "I CANT DO IT"). BUT I HAVE TO DISCOVER WINDOWS HAS CHANGED SINCE MY LAST PROGRAMMING WORK AND NEED TIME TO FIGURE OUT "WHAT HAS CHANGED". I.E. IS THE OBJECT "OBSOLETE" OR "PLACED ELSEWHERE IN THE SYSTEM" REQUIRING LOADING? HAVE THE EVENTS OR METHODS CHANGED? I AM NOT A WINDOWS DEVELOPER- I SIMPLY COOKBOOK THE TASK WHEN I SEE A NEED.
WHY DID I MENTION THIS? I JUST WATCHED A MANAGER STRUGGLE "ALL DAY" AT $50/HR AND ALL WEEKEND TO TWEEK HIS PRESENTATION TO "SHOW OFF" AND MAKE THIS CONTROL WORK TO "NO SUCCESS". WHILE OTHER ENGINEERS MARVEL AT HIS TWEEKS.
HE HAS GIVEN UP AND SELECTED ANOTHER METHOD.
BUT IF I TAKE 6 HOURS AT MY LITTLE SALARY- THEY'D EXPLODE, AS TO ME "WASTING TIME". SINCE IT SHOULD ONLY TAKE A FEW MINUTES- "IF I KNEW WHAT I WAS DOING".
OFFER TO HELP? HE ALWAYS CURTLY TELLS ME -NO THANKS- HE KNOWS WHAT HE IS DOING- I TRY NOT TO BOTHER HIM.
MS ACCESS.
I AM NOT FLUENT IN MSACCESS BUT CAN CREATE AND MAINTAIN DATABASES. DEFINE TABLES, FORMAT DATA AND NORMALIZE DATA INPUT.
I HAVE CREATED A DATABSE OR TWO FOR COMPANY USE. 1. SIEMENS: TO HELP PARTS SELECTION FROM A TABLE FOR PURCHASING PARTS FOR CUSTOMIZED SYSTEMS AND PRODUCING COST QUOTES.
I STARTED THE TASK OF A DATBASE FOR CAD TRACKING AT WRIGLEY, BUT IT WAS TERMINATED DUE TO LACK OF INTEREST IN USE. MOST PREFER TO ASK FOR REQUEST, BUT LEAVE NO TRAIL TO DETERMINE TIME AND EXPECTATIONS. MY DATABASE APPLICATION WAS TO TRACK CAD REQUESTS . IT WAS A METHOD FOR MANAGERS TO REMOTELY IDENTIFY WHAT THE STATUS OF THE REQUEST WAS AND WHO GOT PRIORITY ON REQUESTS. IT WAS HARD ENOUGH ASKING PEOPLE TO WRITE DOWN THEIR COST CENTER SO THEY COULD BE BILLED FOR THEIR REQUESTS. THEY HAD TO FILLOUT A "C.R.U.D."(CAD REQUEST UTILIZATION DOCUMENT.) SO I ABANDONED THIS. THE ACCESS PROGRAM WAS CALLED "C.R.A.P." (CAD REQUEST APPLICATION PROGRAM) PART OF MY OTHER VISION- "F.I.R.E."(FACILTIES INTEGRATED RESOURCE ENVIRONMENT.) I'LL EXPLAIN THAT UNDER MY "HTML DEVELOPMENT". NO ONE WANTED TO FILL OUT THE "CRUD" AND LOGIN THE "CRAP" (LOL).
ALTHOUGH LIKE PROMETHIUS, I TRIED TO GIVE THEM "FIRE".
HERE IS THE USER INTERFACE FOR THE C.R.A.P. (CAD REQUEST APPLICATION PROGRAM) A USER COULD LOGIN: REQUESTOR, CAD PERSONNEL OR CAD MANAGER.
THEN FILL IN A REQUEST FOR A CAD ACTIVITY. DEFINING REQUIRED INFO AND A DATE REQUIRED.
THE CAD DEPT MANAGER COULD THEN CHECK THE ACTIVITY LIST , WHICH COULD BE PRIORITIZED BY THE MANAGER. HE COULD THEN ASSIGN NUMBERS TO PRIORITY, ONCE HE LOGGED IN - HE HAD SOLE ACCESS TO THIS FUNCTION.
DESIGNER COULD LOG IN AND SEE THE PRIORITY AND TASKS ASSIGNED TO HIS NAME. AS HE MADE DAILY PROGRESS HE COULD UPDATE THE STATUS OF THE REQUEST.
REQUESTORS COULD LOG IN AT ANY TIME TO CHECK THE STATUS OF ALL THEIR REQUESTS AND THE PRIORITY ASSIGNED.
THE ARROWS AT BOTTOM ALLOWED THE USER TO SCROLL THROUGH ALL ASSIGNED WORK. THUS ALL COULD BE TRACKED AND DOCUMENTED.
YOU COULD ALSO PERFORM A SEARCH TO FIND PARTICULAR ASSIGNMENTS OR A DESIGNERS WORKLOAD.
I AM NOT AN ACCESS DATABASE DEVELOPER , BUT CAN WRITE SIMPLE QUERIES AS I NEED THEM. WHICH MAY TAKE A LITTLE TIME TO MAKE ACCURATE BUT I HAVE WORKED IN MSACCESS TO A DEGREE. . BUT I HAVE ALSO USED ACCESS TO SEARCH DATABASES FOR MY PERSONAL PROGRAMS. I USED "ADO", "RDO" AND "RDA". I ALSO USED ACCESS TO CONNECT TO THE MLFB DATABASE, FOR MOTOR AND DRIVE CONFIGURATION FOR A HMI MODULE PROGRAM FOR THE SIMOVERT MV DRIVE SOFTWARE I DEVELOPED AT SIEMENS.
TO AUTOMATE MANUFACTURING PROJECT MANAGEMENT TASKS-HERE IS THE PROJECT PARTS MASTER TABLE. OVER 1300 STANDARD PARTS FOR USE..
THE PROJECT MANUFACTURING DATABASE READ IN THE DATA EXTRACTED FROM A CAD FILE INTO A TABLE. EACH PART SORTED BY THE "CUBE" (COST CENTER) THE PARTS WOULD GO INTO.
QUERIES ALLOWED ME TO MAKE REPORTS AND COST ESTIMATES.
QUERIES COULD BE PERFORMED TO CREATE SEPARATE REPORTS FOR PURCHASING AND ASSEMBLERS.
DOS. OCCASIONALLY I STILL MUST GO INTO THE DISK OPERATING SYSTEM. I STRONGLY USED D.O.S. IN THE OLD DAYS FOR COMPUTER DEVELOPMENT. I RARELY NEED TO USE IT NOW, EXCEPT TO CREATE BATCH FILES, IF CERTAIN ACTIONS ARE NEEDED LIKE FORMATTING, AUTOMATE ACTIONS, RENAME DIRECTORIES, OR MAKE NEW DRIVE DESIGNATIONS.
I HAVE OPENED THE SYSTEM REGISTRY AND POSESS SOME KNOWLEDGE OF SEARCHING KEYS AND DELETING KEYS MANUALLY, BUT I DARE NOT TRY THIS WITH WINDOWS 7 WITHOUT SOME MORE EXPERIENCE. IN "WINDOWS XP", I COULD FIND AND ELIMINATE SOME VIRUSES OR FIND STRANGE ACTIVITY VIA THE "WINDOWS TASK MANAGER" TO ELIMINATE THE "FAKE ENTRIES" IN THE REGISTRY OR PERFORM "OS" REPAIRS.
HERE IS THE A SHORT LIST OF A FEW BATCH FILES I NEEDED TO CREATE ON MY PRESENT JOB. 2011-2014. I PERFORMED SIMPLE AUTOMATED SERVER FILE BACK UPS FOR MY DEPARTMENT, UNTIL WE COULD PURCHASE MORE SERVER MEMORY SPACE FOR BACK UPS. "DOS" HAS FEW USES FOR ME TYPICALLY. BUT I CAN HANDLE SIMPLE "DOS" IF THE NEED ARISES. I "COOK BOOK" I AM NOT A "DOS DEVELOPER."
THIS BATCH FILE CREATES A "NEW DIRECTORY" ON A HARDRIVE AND NAMES IT USING THE CURRENT DATE..THEN COPIES THE CONTENTS FROM A REMOTE DRIVE DIRECTORY.
THIS RUNS A PROGRAM CALLED "TERRA COPY" AND ALLOWS COPYING OF DATA FROM THE NETWORK TO A LOCAL USB HARD DRIVE FOR PERIODIC BACK UPS.
THIS BATCH FILE WAS NEEDED TO DUPLICATE THE CONTENTS OF ONE USB DISK TO ANOTHER ON A PERIODIC BASIS IN AN "INCREMENTAL BACKUP".
I DON'T USE "DOS" EVERYDAY, BUT IT COMES IN HANDY ON OCCASION. IN THE 90'S I USED TO USE IT TO INSTALL COMPUTER SOFTWARE IN AN AUTOMATED MANNER, LONG BEFORE MICROSOFT AUTOMATED WINDOWS AND OTHER SOFTWARE INSTALLATION, RESPONDING TO PROMPTS IN DOS AUTOMATICALLY, WHILE I WAS ELSE WHERE IN THE FACILTIES DOING MAINTAINANCE AND DESKTOP SUPPORT. THAT WAS THE "80'S & 90'S".
