[00:00:01]
NOW, SOME PEOPLE WOULD TAKE THIS THE WRONG WAY.
THIS IS A DRINKING PLACE, MEANS IT'S SO EASY, YOU CAN GO TO THE PUB.
MOST PEOPLE I KNOW WHEN THEY GO TO THE PUP, THERE'S NO MORE WORKING.
WHICH WAY? WHERE DO YOU WANT? GET IN? NO, GO AHEAD.
WHERE'S DAYLIGHT BEFORE DARK? GUESS EVERYBODY'S GONNA MAKE IT.
ALRIGHT, I APPRECIATE EVERYBODY COMING THIS MORNING.
UH, ANYBODY THAT DOESN'T KNOW ME ON FAIR HARBOR PRECINCT FOOD COMMISSIONERS, UH, HE'S GENTLEMEN WITH, UH, PUB WORKS.COM.
I TALKED TO THEM, UH, BEEN ABOUT TWO WEEKS AGO NOW, I GUESS.
THEY DID A WEBINAR FOR ME IN MY OFFICE.
WE HEARD ABOUT THEIR PRODUCT AT ONE OF THE SCHOOLS THAT MIKE AND I WENT TO IN AUSTIN.
ONE OF THE OTHER COMMISSIONERS HAD TOLD US ABOUT IT AND THEY SAID IT WAS JUST AN AWESOME SYSTEM.
SO WE WATCHED WHAT THEY HAD TO SHOW US AND I WAS VERY IMPRESSED WITH IT.
I THINK IT'S SOMETHING THAT WILL WORK, UH, ESPECIALLY FOR THE, THE COUNTY, UH, THE, UH, COUNTY PRECINCTS.
UH, BUT I, IT CAN BE TAILORED TO WORK WITH THE CITIES AS WELL.
I THINK IT'D BE A REALLY GOOD, UH, THING FOR US TO LOOK AT AND, AND STRONGLY CONSIDER.
UH, YOU KNOW, MY OPINION IS IT WOULD HELP US WITH ALL KINDS OF AREAS.
KEEPING UP WITH OUR MATERIALS, KEEPING UP WITH OUR EQUIPMENT, UH, EVEN, YOU KNOW, BUDGET PLANNING, ALL THIS OTHER STUFF, AND BEING ABLE TO GET REAL NUMBERS ON WHAT WE HAVE SPENT ON ROADS THAT WE'VE HAD REPAIR OR WHATEVER.
SO WITH THAT, I'M GONNA LET THESE GUYS JUMP INTO IT AND INTRODUCE THEMSELVES AND A LITTLE BIT ABOUT 'EM AND THE PRODUCT.
ALRIGHT, WELL, WE'RE GONNA TALK ABOUT OUR ASSET MANAGE SYSTEM, UH, THIS MORNING AND TALKED ABOUT A NUMBER OF, UH, FEATURES AND FUNCTIONALITIES OF THAT.
UH, AND WE'LL GET BACK TO THIS SLIDE IN A, AT THE END OF, AT THE END OF THIS POWERPOINT, BUT WE'LL GO AHEAD AND INTRODUCE OURSELVES.
I'M DIRECTOR OF SALES FOR THE COMPANY.
UH, HE IS THE FOUNDER AND THE PRESIDENT OF THE COMPANY.
UH, AND, UH, UH, WHAT WE HAVE IS A COMPREHENSIVE WORK ORDER ASSET MANAGEMENT, JOB COSTING SYSTEM, UH, FOR BOTH CITIES, UH, AND COUNTIES.
SO IT'S A GOOD FIT IN BOTH ENVIRONMENTS.
AND BASICALLY WHAT WE DO IS WE DOCUMENT THE WORK THAT YOU DO EACH AND EVERY DAY.
UH, AND BY, BY DOCUMENTING THE WORK THAT YOU DO, YOU CAN BETTER REPORT ON WHAT HAPPENS, KEEP TRACK OF COSTS, AND JUST DO A BETTER JOB OVERALL AT MANAGING YOUR OPERATIONS.
AND IT GIVES YOU A LOT MORE VISIBILITY INTO WHAT'S GOING ON EACH AND EVERY DAY AND, AND EACH AND EVERY WEEK, YEAR AND MONTH.
SO, UH, WE'VE BEEN AROUND 20 YEARS.
WE'RE HEADQUARTERED IN SNOWMASS VILLAGE, COLORADO.
AND OF Y'ALL GO OUT THERE AND YOU EITHER SKI OR HUNT.
WE'RE, WE'RE 200 MILES WEST OF DENVER, UH, UH, NEAR ASPEN, COLORADO.
UH, AND WE'RE APPROACHING ABOUT 600 CUSTOMERS RIGHT NOW, UH, ACROSS THE US AND CANADA.
AND ABOUT AN EVEN SPLIT RIGHT NOW BETWEEN CITIES AND COUNTIES, WE'RE ALMOST 50 50 BETWEEN COUNTY CUSTOMERS AND CITY CUSTOMERS.
AND SINCE WE BEGAN AS A BUSINESS, WE'VE MAINTAINED ABOUT A 90% RETENTION RATE OF THOSE CUSTOMERS OVER 20 YEARS, WHICH WE THINK IS A, A REALLY GOOD RECORD.
IT SAYS THAT THE, THE, THE PRODUCT HAS A LOT OF SHELF LIFE.
UH, WE'VE, WE'VE GOT CUSTOMERS ALL THE WAY BACK TO 20 YEARS THAT ARE STILL USING THIS TODAY.
WE HAVE SOME HERE IN TEXAS, LIKE MIDLAND COUNTY, TEXAS, THAT HAVE USED IT FOR 15 YEARS OR, OR LONGER, UH, EACH AND EVERY DAY.
UH, SO WE TRY TO DO A VERY GOOD JOB IN OUR CUSTOMER SUPPORT AND CUSTOMER SERVICE TO, TO MAINTAIN THAT CUSTOMER BASE.
UH, SO AS I SAID, WE HAVE QUITE A FEW CUSTOMERS ACROSS THE SOUTH, UH, UH, INCLUDING, UH, QUITE A FEW IN TEXAS.
THIS IS JUST A PARTIAL LIST, BUT PROBABLY MOST NOTABLE FOR Y'ALL WOULD BE, UH, DON COUNTY, UH, HAS BEEN USING THIS FOR OVER FIVE YEARS.
UH, AND, UH, THE OTHER CLOSEST SPOT FOR YOU WOULD BE THE CITY OF WILEY.
AND THEY'VE BEEN USING THIS FOR ABOUT FOUR YEARS OR FIVE YEARS.
SO WE HAVE TWO, YOU KNOW, PRETTY PROMINENT CUSTOMERS IN THIS AREA, UH, THAT ARE
[00:05:01]
USING THIS TO, UH, A GREAT EXTENT.IN FACT, IN NOVEMBER I CAME DOWN, UH, WITH OUR MARKETING PERSON.
WE SHOT SOME VIDEOS, UH, UH, FOR, UH, THEY'RE GONNA PUT ON OUR WEBSITE.
AND, UH, I'LL, I'LL SEND THE LINKS TO TERRY, BUT WE HAVE A VIDEO THAT SHOT COLLIN COUNTY ABOUT HOW THEY USE IT.
AND WE HAVE A VIDEO SHOT OVER AT THE CITY OF WHITE WE'RE GONNA DO, OF ALL THEIR PUBLIC WORKS AND ROAD BRIDGE FOLKS.
SO, UH, AS I SAID, WE'RE, WE'RE A GOOD FIT IN EITHER ENVIRONMENT.
UH, UH, THE PRODUCT IS VERY ADAPTABLE.
UH, UH, CITIES TEND TO BE, UH, SERVICE REQUEST ORIENTED AND, UH, AND, AND COUNTIES TEND TO BE MORE TIME SHEET CENTRIC, BUT WE CAN ACCOMMODATE EITHER ONE.
SO, O OFTENTIMES, ESPECIALLY IN A LARGE TO MID-SIZE CITY, THE EVERYTHING IS, EVERYTHING'S DONE ON A, UH, ON AN INDIVIDUAL WORK ORDER.
EVERY POTHOLE HAS ITS OWN WORK ORDER.
AND IN THE COUNTY ENVIRONMENT, YOU TEND TO, UH, IN THE ROAD AND BRIDGE ENVIRONMENT, YOU TEND TO GO OUT AND JUST WORK OFF OF, UH, A TIME SHEET.
YOU WENT OUT AND FILL, FILL POTHOLES FOR EIGHT HOURS TODAY, AND THAT'S ALL YOU'RE GONNA DOCUMENT.
YOU, YOU DON'T HAVE A RECORD OF EVERY INDIVIDUAL POTHOLE THAT YOU FILL, BUT WE CAN WORK IN EITHER ENVIRONMENT QUITE WELL.
UH, AND, UH, WE'RE ALSO HAVE A LOT OF PROJECT MANAGEMENT CAPABILITIES, UH, AND, AND, UH, PROJECTS CAN BE VERY IMPORTANT.
THINGS LIKE, UM, UH, ROAD OVERLAYS IN THE SUMMER OR, OR CULVERTS, UH, CULVERT INSTALLATION OR BRIDGE INSTALLATIONS.
WE CAN KEEP TRACK OF ALL THE PROJECTS AND ALL THE COSTS AND ALL THE PEOPLE, ALL THE MATERIALS THAT GO INTO THAT.
SO THERE'S A, THERE'S A LIST OF THE COUNTY CUSTOMERS I'VE MENTIONED, UH, UH, COLIN ALREADY IN MIDLAND COUNTY.
UM, UM, I THINK ALSO, UH, FOR THE FOLKS FROM KAUFMAN, UH, WE ALSO HAVE, UM, MONTGOMERY COUNTY, TEXAS, WHICH IS JUST NORTH OF HOUSTON.
IT'S A COUNTY OF ABOUT 500,000 PEOPLE.
AND EACH COMMISSIONER HAS ABOUT 125,000 POPULATION AND THREE OF THEIR FOUR PRECINCTS USES RIGHT NOW.
UH, BUT, UH, BUT WE ALSO HAVE A NUMBER OF SMALLER AND, UH, UH, MIDSIZE, UH, CITIES AS WELL.
SO BELTON, ANYBODY'S FAMILIAR WITH THAT.
UH, LIVE OAK, WHICH IS OUTSIDE OF SAN ANTONIO, UH, LEON VALLEY, UH, CITY OF ONLY ABOUT 9,000.
SO YOU CAN, I I HOPE THAT ILLUSTRATES THAT WE CAN, THE PRODUCT SCALES VERY WELL.
SO WE, WE HAVE, WE HAVE LEON VALLEY WITH NINE, NINE OR 10,000 PEOPLE IN COLLIN COUNTY WITH 900,000 PEOPLE.
AND IT'S THE SAME PRODUCT AND THEY'RE BOTH GETTING ABOUT THE SAME VALUE OUT OF IT.
SO, UH, UH, UH, THE PROGRAM IS WINDOWS SPACE AND CAN'T RUN IN THE CLOUD IF, IF THAT'S WHERE IT WANTS IT TO EXIST OR IT CAN RUN ON YOUR LOCAL NETWORK OR ON YOUR SERVERS.
UH, AND, UH, BEING WINDOWS SPACE, WE THINK THAT THAT'S THE MOST UBIQUITOUS PLATFORM.
VIRTUALLY EVERYONE IN THE CITY COUNTY ENVIRONMENTS KNOW WINDOWS, UH, AND SO THAT WE THINK MAKES IT VERY EASY, STRAIGHTFORWARD TO USE.
WE USE THE SAME CONVENTIONS IN THE PROGRAM THAT YOU WOULD SEE IN, UH, A MICROSOFT PRODUCT.
YOU KNOW, IF YOU CLICK AT THE TOP OF THE HEAD OF ROAD CHANGES, THE, THE ROW AND REORDERS IT, ALL, ALL THOSE TYPES OF CONDITIONS, UH, OUR IMPLEMENTATIONS ARE, ARE, ARE PRETTY FAST.
UH, TYPICALLY A MATTER OF, UH, FROM A FEW WEEKS TO A FEW MONTHS.
BUT WE'RE NOT THE KIND OF PRODUCT THAT A YEAR LATER YOU'RE STILL IMPLEMENTING.
WE TYPICALLY WANT TO HAVE, DEPENDING ON THE CLIENT'S TIMEFRAME, BUT WE TYPICALLY WANT TO HAVE A CLIENT UP AND RUNNING DATA CONVERTED THE SYSTEM INSTALLED, AND ALL THE PEOPLE TRAINING WITHIN 90 DAYS.
SO THAT, THAT'S A PRETTY TYPICAL, UH, IF NOT EVEN A LENGTHY, UH, IMPLEMENTATION FOR US.
UH, AND AS I, AS I SAID, WE TRY TO MAINTAIN A VERY HIGH, UH, LEVEL OF CUSTOMER SUPPORT.
UH, WE HAVE MORE CUSTOMER SUPPORT PEOPLE THAN WE HAVE SALESPEOPLE.
SO THAT'LL TELL YOU WHERE, WHERE OUR COMPANY INVEST ITS MONEY.
AND, UH, WE TRY TO CALL OUR, OUR CLIENTS PROACTIVELY, UH, AT LEAST TWICE A YEAR TO MAKE SURE THAT THEY'RE, THAT THEY'RE GETTING WHAT THEY WANT OUT OF THE PRODUCT, THAT THEY'RE USING IT PROPERLY IF THEY DON'T HAVE ANY PROBLEMS. 'CAUSE SOMETIMES CUSTOMERS KIND OF FILL OUT A PROBLEM, LINGER, AND WE DON'T WANT THAT TO HAPPEN.
UH, SO WE TRY TO BE VERY PROACTIVE ABOUT KEEPING OUR CUSTOMERS UP TO DATE AND HAPPY.
SO THAT'S, UH, THAT'S MY LITTLE COMMERCIAL.
UH, ANY QUESTIONS ABOUT THE COMPANY? AND THEN BEFORE WE START GETTING INTO THE PRODUCT, NONE HEARD.
UH, SO WE, WE HAVE A, WE HAVE A FEW, UH, WE HAVE A FEW QUESTIONS THAT WE'D LIKE TO ASK, UH, OF THE AUDIENCE AND JUST, UH, BECAUSE WE HAVE A
[00:10:01]
MIXED GROUP, UH, AND I THINK WE'LL, WE'LL GO TO THE NEXT SLIDE, KEITH, WHICH WE JUST, SO, UM, OUR BASIC SYSTEM IS ASSET MANAGEMENT, JOB COSTING, KEEPING TRACK OF, OF, OF YOUR WORK, YOUR WORK ORDERS.UH, OUR SERVICE REQUEST SYSTEM IS BASICALLY KEEPING TRACK OF ALL THE PEOPLE THAT CALL IN, SO YOUR CITIZENS.
SO, UH, SO THAT, THAT'S MORE OF YOUR PROACTIVE, UM, OR REACTIVE MAINTENANCE.
SOMEBODY CALLS AND SAYS, I'VE GOT A POTHOLE, I'VE GOT A DOWN TREE, I'VE GOT A FLOOD.
SO YOU WANT TO KEEP TRACK OF ALL THE CALLS THAT COME IN, AND THEN HAVE A WAY TO DISTRIBUTE THOSE TO YOUR PEOPLE IN THE FIELD.
AND THEN TO DOCUMENT ALL THE WORK THAT OCCURS.
AND THEN WE HAVE A MODULAR CALL WORK ORDERS, WHICH, UH, WHICH IS, IS, IS FOR PLANNED WORK.
SO YOU KNOW, YOUR PLAN, YOU PLAN TO DO SOME SWEEPING, UH, CERTAIN, UH, AREAS.
YOU, MAYBE YOU PLAN TO DO ROAD GRADING IF YOU HAVE, UH, GRAVEL OR DIRT ROADS.
SO YOU CAN BUILD, SO YOU CAN BUILD A SCHEDULE OR A PLAN TO DO THE WORK.
UH, AND THEN WE HAVE A MOBILE MODULE THAT PEOPLE DEMONSTRATE, WHICH ALLOWS THE, UH, ALLOWS YOU TO TAKE THE, THE PRODUCT OUT INTO THE FIELD IF YOU HAVE THAT INTEREST.
IF I CAN GET MINE INCOME MODEL, PETE HAS HIS, WE'LL SHOW THAT LATER.
BUT ANYWAY, A, A, A MOBILE MODULE THAT'LL WORK ON A TABLET, WHICH WE'RE SHOWING BECAUSE THEY'RE A LARGE FORMAT OR WORK ON YOUR SMARTPHONE AND WILL AND BASICALLY ALLOWS YOU TO RECORD WORK, UH, AND TO CREATE SEARCH REQUESTS OUT IN THE FIELD.
UM, SO SOME, SOME OF YOU MAY BE INTERESTED IN THAT AND SOME MIGHT NOT BE INTERESTED IN THAT.
SO PRETTY MUCH ANY DEVICE THAT YOU MAY HAVE, AND IT'LL RUN CONNECTED REAL TIME OR IT'LL RUN DISCONNECTED.
SO IF YOU HAVE SOME RURAL AREAS WHERE YOU DON'T HAVE CELL SERVICE OR YOU DON'T HAVE A WIFI SERVICE, UH, YOU CAN STILL USE THE PRODUCT.
AND WHEN YOU GET WITHIN RANGE, IT'LL CONNECT BACK UP AND UPDATE, UH, ALL YOUR RECORDS.
AND THEN WE HAVE A, UH, A, A FLEET MAINTENANCE MODULE.
AND I'M NOT CERTAIN WHETHER YOU HAVE INTEREST IN THE FLEET, BUT WE, WE WANNA MAKE SURE THAT WE MENTION THIS.
AND THEN WE HAVE GIS, WHICH IS THE MAPPING MODULE, WHICH ALLOWS YOU TO PUT YOUR ASSETS ON MAPS, SEE YOUR, SEE ALL YOUR ASSETS ON A MAP, SEE ALL YOUR WORK ON A MAP, SO YOU KNOW, WHICH STOP SIGNS DID YOU REPLACE THIS YEAR, AND OR WHICH STOP SIGNS DO WE NEED TO GO OUT AND INSPECT, UH, THIS MONTH.
SO, WE'LL, WE'LL SHOW YOU ALL THE MAPPING CAPABILITIES.
SO, UM, I, I'VE SPOKEN TO TERRY NEXT, HE MENTIONED, UH, AND HE HAD ASKED YOU TO KIND OF DO A BROAD OVERVIEW.
SO, UH, UH, I JUST WANT TO VERIFY, IS THAT, IS THAT STILL THE PLAN? WE WANT TO SEE ALL THE, A LITTLE BIT OF ALL THESE MODULES? YES.
AND IS THERE ANY SPECIAL AREA THAT, THAT YOU WANT US TO HIT ON? IS THERE ANY, UH, UH, UH, REPORTING THAT YOU, YOU'D LIKE TO SEE? OR EXAMPLES OR REPORTS THAT YOU'D LIKE TO SEE? UM, I THINK BASICALLY WHAT, WHAT Y'ALL SHOWED ME IN DAY WAS, IS IT PERFECT APPLICATION FOR US? SO I THINK PRETTY MUCH DO WHAT YOU DID FOR US AT THE OFFICE, AND NOTHING GOT COVERED.
REMEMBER WHAT WE DID, BUT THAT'S ALRIGHT.
WE DO SO MANY DEMOS, IT'S REALLY HARD TO, YOU KNOW, NO OFFENSE, IT'S HARD TO KEEP TRACK OF ALL THE ONES WE DO.
WHAT WE'LL DO IS WE'LL GO AROUND THE HORN UP OUR LITTLE PIE CHART UP HERE AND, UH, POINT THINGS OUT.
YOU KNOW, IT'S, IT'S TYPICALLY, AS BOB MENTIONED, WE'RE A GREAT FIT FOR A CITY OF AURORA COUNTY, BUT THERE'S DIFFERENCES BETWEEN THE TWO.
AND AS BOB MENTIONED, A LOT OF TIMES CITIES, THIS IS A VERY BROAD BRUSH STROKE HERE, CITIES ARE MORE SERVICE REQUESTS, WORK ORDER ORIENTED COUNTIES ARE MORE PROJECT AND, UH, TIME SHEET ORIENTED.
BUT THE SYSTEM HAS TOOLS THAT HOPEFULLY WILL APPEAL TO, UH, BOTH TYPES OF CUSTOMERS THAT ARE HERE IN THE ROOM.
UM, AS BOB ALSO MENTIONED, THESE MAJOR SORT OF BLOCKS ON THE SCREEN REPRESENT THE PRIMARY MODULES IN THE SYSTEM.
SO IF THE CENTER IS THIS ASSET MANAGEMENT AND JOB COST AND CORE, AND IN THAT PART OF OUR SYSTEM IS WHERE YOU WILL KEEP AN INVENTORY OF ALL YOUR PEOPLE, ALL YOUR CONTRACTORS AND VENDORS, ALL YOUR VEHICLES AND EQUIPMENT, ALL THE MATERIALS AND PARTS THAT YOU USE, ALL THE TASKS THAT YOU PERFORM, ALL THE PROJECTS THAT YOU RUN, UM, BUT ALSO ALL THE ASSETS THAT YOU MANAGE, THE ROADS, THE BRIDGES, THE BUILDINGS, THE STREETS, THE SIGNS, UH, THE CULVERTS, THE CATTLE GUARDS, WHATEVER IT IS THAT YOU MANAGE.
HUB WORKS CAN BE CONFIGURED RATHER EASILY, EXTREMELY EASILY TO MODEL
[00:15:01]
THOSE THINGS.MODEL A STREET VERSUS A BRIDGE, A SIGN VERSUS A FIRE HYDROGEN, A FIRE HYDROGEN VERSUS A ROAD.
SO WE'VE GOT THAT IN THE CENTER OF EVERYTHING.
AND PART OF THAT IS WHAT WE CALL THE JOB COSTING CORE.
SO WE CAN RECORD DOCUMENT WORK, YOU USED THE TERM, WE DOCUMENT WORK, WE CAN RECORD THAT CHARLIE WENT TO FARM ROAD 49 80 14 89 AND DID MOTOR GRADING OR PATCHED POTHOLES, OR CLEARED THE DITCH, WHATEVER THOSE TASKS MIGHT BE.
THE LABOR COSTS, THE EQUIPMENT COST OF THE MATERIAL COSTS.
AND THOSE COSTS ARE THEN ALLOCATED BACK OUT TO THE ROAD NETWORK TO THE VEHICLES AND EQUIPMENT, TO THE INDIVIDUALS THAT PERFORM THE WORK FOR LABOR SOURCES, FOR ANY CONTRACTORS AND VENDORS THAT MIGHT HAVE DONE IT AS WELL.
SO THAT, THAT'S AT THE MIDDLE.
AND BOLTED ONTO THAT VERY SEAMLESSLY IS A SERVICE REQUEST MODULE.
SO IF FOLKS ARE PHONING IN WITH PROBLEMS, WE'VE GOT A POTHOLE HERE, WE'VE GOT A DOWN TREE THERE, WE'VE GOT FLOOD OVER HERE.
WE'VE GOT, UH, YOU KNOW, A TURNED UP CULVERT, YOU SMASHED MY MAILBOX WITH THE PLOW TRUCK OR THE MOTOR GRADER.
THOSE SERVICE REQUESTS CAN BE LOGGED.
THEY TIE INTO THE JOB COSTING MODULE.
THESE ARE ABOUT DEMAND MAINTENANCE WORK ORDERS ARE MORE ABOUT PLANNED MAINTENANCE.
WE CAN PROJECT ALL OF THIS ONTO A GIS MAP.
I'LL SHOW YOU A LITTLE BIT OF THAT.
WE CAN MAKE USE OF, UH, THE TABLET OR THE SMARTPHONE TO PROVIDE FUNCTIONALITY IN THE FIELD, EITHER CONNECTED OR DISCONNECTED.
AND THEN WE ALSO HAVE A VERY POWERFUL, EASY TO USE FLEET MAINTENANCE PIECE SO THAT YOU CAN KEEP TRACK OF ALL THE VEHICLE REPAIRS, THE TIRE ROTATIONS, THE OIL CHANGES, THE PM SCHEDULES, THE FUELING, UH, FOR YOUR VEHICLE FLEET.
THEY'RE ALL INTEGRATED, THEY ALL LOOK THE SAME.
WE ALSO HAVE A, UH, SOME ONLINE TOOLS THAT YOU CAN PROJECT ONTO YOUR CITY OR COUNTY WEBSITE.
HERE IS A REGULAR SERVICE REQUEST OF SOMEONE COMPLAINING ABOUT A POTHOLE, BUT ALSO A, A FLEET SERVICE REQUEST.
SO YOU'VE GOT A LARGE VEHICLE FLEET AND PEOPLE NEED TO SUBMIT IN AN ORDERLY MANNER THAT I NEED AN OIL CHANGE, I'VE GOT A BROKEN DOOR HANDLE, THE TAILGATE DOESN'T WORK.
INSTEAD OF JUST SHOWING UP AT THE GARAGE LEADING THE VEHICLE.
UH, A FLEET SERVICE REQUEST CAN BE A HANDY THING FOR BETTER, MORE ORGANIZED FLEET MANAGEMENT.
AND THIS ONLINE TOOL, THIS WEB-BASED TOOL, UH, GIVES YOU THAT CAPABILITY.
SO I'M, I'M JUST GOING TO GO THROUGH SOME OF THE SOFTWARE, SORT OF THE HIGH LEVEL, UH, TRY TO EXPLAIN THINGS AND REAL, YOU KNOW, JUST GENERAL LAYMAN'S TERMS HERE.
BUT IF YOU'VE GOT QUESTIONS, PLEASE DON'T BE SHY ABOUT ASKING THEM.
IF THIS IS A CONVERSATION, IT WILL BE A LOT MORE USEFUL AND INTERESTING THAN ME JUST, YOU KNOW, GIVING YOU A, THE PUBLIC'S LECTURE SERIES, WHICH I, I WANT ATTEND.
SO, UH, JUST AS THE BEGINNING, CAN EVERYBODY SEE, UH, WHAT WE'VE GOT GOING HERE? DO I NEED TO BUMP UP THE SCREEN RESOLUTION? I THINK WE DO.
THIS IS WHERE OUR OFFICE IS A VIEW FROM OUR OFFICE.
THIS IS LIKE, THIS IS LIKE 20 MILES FROM THE OFFICE.
LEMME CONCENTRATE HERE SO I CAN FIGURE THIS OUT.
MY SYSTEM WAS UPGRADED AGAINST MY, DIDN'T DO ANYTHING, DID IT?
ALRIGHT, WELL WE COULD, I MIGHT HAVE TO SPEND ALL DAY TRYING TO FIGURE THIS OUT.
SO LET'S NOT, UM, IN THE BACK, CAN YOU AT LEAST READ THOSE LINE ITEMS THERE? NO, NO.
CLICK OLD VERSION MAKES IT BIGGER.
PUT IT ON 150% AND, UH, THERE'S AN APPLY BUTTON, BUT IT, UH, SOME RESPOND.
THIS IS WHERE, UH, SIGN TO DO MAY.
FORTUNATELY I HAVE ALL THOSE THINGS I HAD TEED UP AND LOST.
SO I'M, I'M GONNA JUST UNPLUG THIS.
WE NEED, WE NEED FIVE MINUTES TO RE START TO, SO
[00:20:01]
STEVE, CAN YOU SING A SONG FOR US? HOW ABOUT MY WILD THROAT? CAN YOU DO THAT? SORRY ABOUT THAT.I DO NOT WANT CREATE A RIOT OUT HERE.
YOU HAVE TO CALL THE SHERIFF IN TO ARREST EVERYBODY.
SO ANY QUESTIONS ABOUT ANY OF OUR CUSTOMERS? STRIKE YOU FOR A MINUTE.
DOES YOUR SYSTEM HAVE THE ABILITY TO PUT THE INFORMATION ON DIRECTLY ONTO A FE OF FORCE ACCOUNT LABOR OR FORCE ACCOUNT PUT WELL, WE'D HAVE TO SEE YOUR FORM.
EVERY, EVERY COUNTY, EVERY STATE HAS DIFFERENT FEMA REPORTING REQUIRE.
BRING IT TO US AND THE ANSWER WILL BE YES BECAUSE, UH, WE'VE NEVER SEEN A STANDARDIZED FORM.
WE'VE ALWAYS HEARD THAT THE FEMA GUY HAS HIS OWN WAIT A AND WE CAN PROVIDE REPORTS THAT ADHERE TO THAT.
BUT NO ONE HAS EVER SHOWN US, SHOWN US A STANDARDIZED NATIONWIDE COURT.
UM, HEY BOB, COMMON COUNTY'S PROBABLY OUR CLOSEST NEIGHBOR.
THAT'S ONE OF YOUR CUSTOMERS HERE? YEAH.
HOW LONG HAVE THEY BEEN WITH Y'ALL? UH, OVER FIVE YEARS.
I WAS GONNA TRY AND GET IN TOUCH WITH SOMEBODY OVER THERE.
I'LL GIVE YOU, I'LL GIVE YOU A TON OF NAMES OVER THERE.
UM, UH, THEY WENT THROUGH EXTENSIVE RFT, I THINK THEY'RE AT NINE VENDORS, UH, TOOK TWO YEARS
SO IT WAS A VERY CAREFUL INVOLVED PROCESS.
AND AFTER TWO YEARS AND TWO FULL SUBMISSIONS, UH, OF I THINK A 60 OR 70 PAGE RFP, THEY ENDED UP CHOOSING CHOOSING US.
THEY WERE VERY, UH, THAT'S BETTER.
VERY, VERY DILIGENT, VERY CAREFUL.
UH, UH, AND THEY'VE BEEN, BEEN IMPLEMENTING FOR, THEY'VE BEEN IMPLEMENTED FOR OVER FIVE YEARS NOW.
AND THEY, THEY'RE USING VERY, VERY BROADLY, UH, IN, IN EVERY ASPECT OF IT.
I THINK THEY HAVE EVERYTHING NOW, BUT, BUT MOBILE, UH, AND THEY'LL PROBABLY GO TO THAT AND THEY'VE BEEN CONVERTING THEIR FLEET OVER, UH, AS WELL, UH, FOR, THEY STARTED THE CORE PRODUCT AND THEN, AND THEN KIND OF LAYERED IT ON IN A VERY LOGICAL WAY.
AND THEN A COUPLE YEARS AGO WE STARTED WITH THE, WITH THE FLEET SIDE AS WELL.
THEY HAVE SEVERAL HUNDRED VEHICLES, OF COURSE, YOU KNOW, PROBABLY FOUR OR 500 VEHICLES A PIECE OF, THEY USE ALL OUT ONE MAINTENANCE FACILITY, ALL THEIR VEHICLES.
THEY HAVE, THEY HAVE A CENTRAL SHOP THERE.
UM, UH, WHERE ROAD AND BRIDGE OPERATES OUT OF FOR, UH, PUBLIC WORKS.
AND UH, AND THEN THEY HAVE A CENTRAL SHOP WITH, I DON'T KNOW, 10, 10 15 BAYS, UH, FOR THE FLEET SIDE.
WHEN YOU GO OVER
SOUNDS LIKE THE CHEAPEST PLAN ANYWAY.
UH, AND WE'VE BEEN IMPLEMENTING, UH, MONTGOMERY COUNTY, UH, ON A PRECINCT BASIS FOR THE PAST THREE YEARS.
AND, UH, SO THEY, THEY, THEY STARTED WITH ONE PRECINCT WHERE, WHERE COLIN IS A UNIFIED COUNTY.
AND IT JUST STARTED, YOU KNOW, IT WAS FOR THE WHOLE OPERATION.
UH, YEAH, WELL THAT ONE PRECINCT, THEY HAD QUARTER MILLION PEOPLE.
DO THEY GOT QUARTER MILLION PEOPLE IN THAT ONE CREEK.
AND THEN I HAVE, AND THEN I HAVE DEWITT COUNTY, WHICH IS 10,000 PEOPLE.
IT, YEAH, IT, UH, IT'S VERY SMALL.
I THINK EACH COMMISSIONER HAS ABOUT 2000 PEOPLE IN, IN IT'S PRECINCT.
SO WE'RE, WE HAVE THE COMPLETE OPPOSITE, YOU KNOW, NOT 60 MILES AWAY FROM HOUSTON THE OTHER WAY.
SO, AND THEY'RE IN NEW YORK STATE TOO, SO THEY TOLERATE YANKEES,
SO HE DOESN'T MIND THAT HE'S FROM NEW YORK.
UH, I'M ACTUALLY, UH, UH, I'M A TEXAN.
I GRADUATED FROM NORTH TEXAS STATE, SO I DON'T KNOW HOW LONG AGO THEY SWITCHED THAT NAME, BUT, BUT I CAN'T EVEN REMEMBER WHAT THE UNIVERSITY I GRADUATED FROM.
'CAUSE THEY CHANGED THE NAME ON ME.
UH, SO YEAH, I, I GREW UP IN SAN ANTONIO AND THEN WENT TO NORTH TEXAS STATE, UH, AND THEN UNIVERSITY OF TEXAS AT SAN ANTONIO.
SO I HAVE A LONG HISTORY HERE.
PARDON? WHAT I MEANS YOU PART OF THE FURNITURE.
I'M, I'M A FIFTH GENERATION TEXAN
SO GRAYSON COUNTY'S NAMED AFTER MY GREAT-GRANDFATHER.
I'M A FIFTH GENERATION TEXAS, BUT I BROKE THE CHAIN 'CAUSE MY SON WAS BORN IN WASHINGTON DC
COULDN'T GET BACK FAST ENOUGH BACK.
[00:25:02]
ALRIGHT.READY WILL BE MORE SOPHISTICATED THAN IT'S IN THE GO FOR.
SO, UH, AS I WAS SAYING BEFORE, OUR INTERRUPTION, UM, WE'VE GOT VARIOUS MODULES.
THEY'RE ALL SEAMLESSLY INTEGRATED.
UH, THIS ASSET MANAGEMENT AND JOB COSTING CORE, MANY OF THE PIECES ARE FOUND HERE.
SO AT THE TOP OF OUR MENU IS THIS CONCEPT OF AN ACTIVITY.
AN ACTIVITY REPRESENTS THE DOCUMENTATION OF WORK, IN OTHER WORDS, AN EMPLOYEE AT A LOCATION PERFORMING A TASK.
AND IF YOU THINK OF THOSE THREE THINGS IN TERMS OF PUBLIC WORKS, THAT DEFINES PRETTY WELL LARGELY WHAT GOES ON DAY IN AND DAY OUT.
SO INDIVIDUALS GO TO YOUR VARIOUS LOCATIONS, YOUR VARIOUS ROADS, YOUR BRIDGES, YOUR BUILDINGS, YOUR STREETS, AND THEY PERFORM VARIOUS TASKS OR PERHAPS JOBS OR ACTIVITIES.
WE CALL THAT COMBO, THAT THREE ITEM COMBO AND ACTIVITY RECORD.
AND THAT ACCOUNTS FOR LABOR COSTS, EQUIPMENT COSTS, AND MATERIAL COSTS.
ALLOCATES THOSE COSTS OUT TO YOUR ROAD NETWORK OR WHATEVER ASSETS HAVE YOU WORKED ON.
AND IT'S THE FOUNDATION FOR ALL SORTS OF COST REPORTING.
SO IF WE LOOK AT INDIVIDUAL SCREENS, JUST, JUST TO GIVE YOU A FEEL FOR HOW THE SOFTWARE LOOKS.
NOW HERE'S AN EMPLOYEE RECORD AND, UM, LET'S JUST MAKE SURE I'VE GOT ALL RIGHT.
I I IT'S NOT DISPLAYING THE DATA.
THOSE ARE THE STANDARDIZED FORMS NOW.
EACH PROJECT SPECIALIST MAY DO THINGS DIFFERENTLY.
BUT THEY, THAT IS THE FORM THAT WE'RE SUPPOSED TO.
SO WE CAN PRODUCE ALL THIS K FOR, WE DON'T, WE MAY NOT PRINT IT ON THIS FORM, STICK THIS FORM INTO A PRINTER, BUT THIS IS ALL THE STUFF THAT WE DO.
SO WE CAN, WE CAN ATTRIBUTE ALL THE JOBS ALL TIED TO THE OPERATOR.
SOME OF THE SOFTWARE THAT WE HAVE,
WE, WE, UH, BOULDER COUNTY, COLORADO HAD A HUGE FLOOD IN SEPTEMBER, 2013, WASHED OUT 57 BRIDGES, 200 MILES ROAD, UH, 197 PRIVATE BRIDGES, PROBABLY, UH, CLOSE TO A BILLION DOLLARS IN DAMAGE.
AND THEY USED OUR PRODUCT EXCLUSIVELY TO TRACK ALL THE WORK THAT GOT DONE TO REMEDIATE, UH, THAT MASSIVE DISASTER.
AND THEY PRODUCED, WE PRODUCED ALL THE REPORTS FOR THAT.
THEY SUBMIT THE FEMA AT THE TIME.
WE JUST NEVER SEEN THIS PARTICULAR FORM.
THEY HAD WAY THAT THEY TRANSPOSED THE DATA INTO THE FORM.
BUT I KNOW ABOUT SEVEN YEARS AGO, FIVE AGO, I GUESS FLORIDA HAD A
AND, UH, AT THE TIME WE DIDN'T ATTRIBUTE THE OPERATOR TO EQUIPMENT.
AND YOU GOTTA, YOU CAN'T JUST SAY I DID EIGHT HOURS OF A BACKUP.
RIGHT? SO, SO WE, WE ENHANCE THE PROGRAM AND INCLUDE THAT IN A BUNCH OF OTHER FEATURES SO WE CAN PRODUCE THE, THE INFORMATION REQUIRES.
I DON'T, WE JUST HAVEN'T SEEN THIS FORM, BUT I PROBABLY HAD 50 ACCOUNTS IN AT LEAST OUR PRODUCT.
AND I THINK THEY JUST SUBMITTED ONE PROJECT SPECIALIST WITH SIDE.
BUT IF IT'S ON THAT FORM RIGHT THERE, I CAN MAKE THEM ALL.
[00:30:01]
WELL, YEAH, TECHNOLOGY'S ALWAYS FUN.SO, UM, BACK TO, UH, WHAT I WAS GETTING TO, AND AGAIN, WE'VE GOT QUESTIONS.
UM, WE'VE GOT A VARIETY OF SCREENS WHERE YOU CAN INVENTORY CONTRACTORS AND VENDORS, EMPLOYEES.
SO THIS IS ONE OF OUR SCREENS HERE FOR EMPLOYEES.
IF I LOOK AT A DIFFERENT SCREEN FOR CONTRACTORS AND VENDORS, YOU CAN SEE THAT NUMBER ONE, WE'RE A WINDOW SYSTEM AND MEAN LOOKING AT MULTIPLE WINDOWS AT THE SAME TIME PROVIDES A HIGHER DEGREE OF PRODUCTIVITY.
THE FACT THAT THE SCREENS LOOK VERY MUCH THE SAME FROM SCREEN TO SCREEN ALSO PROMOTES PRODUCTIVITY.
UH, SHORTENS THE LEARNING CURVE MAKES THE SOFTWARE EASIER.
WE'VE GOT VARIOUS FIELDS ON THE SCREEN.
YOU'LL NOTICE, I HOPE THAT SOME FIELDS HAVE A YELLOW BACKGROUND.
OTHERS HAVE A WHITE BACKGROUND.
WE USE A COLOR COATING CONVENTION.
YELLOW MANDATORY, WHITE OPTIONAL.
SO WHEN YOU'RE CREATING A NEW EMPLOYEE, JUST BY CLICKING THAT ADD BUTTON IMMEDIATELY FROM COLOR CODING, YOU KNOW WHAT TO, UH, WHAT YOU NEED TO ENTER AND WHAT YOU DON'T NEED TO ENTER AT THE MOMENT, UH, THAT, THAT FOR DATA ENTRY PEOPLE IS A REAL PROBLEM.
THEY, THEY LOOK AT A FORM, THERE'S 400 FIELDS ON IT AND, UH, THEY DON'T REALLY REALIZE THAT THERE'S ONLY FOUR THINGS I HAVE TO ENTER AND THEY'RE KIND OF CONFUSED.
SO THIS KIND OF COLOR CODING MAKES THE SOFTWARE EASIER TO USE.
AND EASE OF USE IS ONE OF THOSE THINGS.
IT'S NOT LIKE THIS ONE THING YOU CAN POINT TO THAT SAYS THE SOFTWARE IS EASY TO USE.
IT'S A WHOLE VARIETY OF LITTLE ITEMS THAT ITEMS MAKE THE USE OF THE SOFTWARE USE.
WHEN WE'RE LOOKING AT AN EMPLOYEE RECORD, FOR EXAMPLE, WE HAVE A TAB HERE CALLED THE ACTIVITY LOG.
AND THAT ACTIVITY LOG SHOWS US EVERYWHERE LIFE TO DATE.
YOU CAN SEE MY LIVE TO DATE RADIO BUTTON AT THE BOTTOM, EVERYWHERE LIFE TO DATE THAT THIS EMPLOYEE MIKE HARDY HAS WORKED.
WHERE HE WENT, WHAT DID HE DO, HOW MANY HOURS, WHAT WAS THE COST? AND THE SAME IS TRUE HERE FOR MY CONTRACTORS.
SO IF I HAVE, I DON'T HAVE MUCH DATA FOR CONTRACTORS, BUT THEY HAVE ALSO HAVE AN ACTIVITY LOG.
SO IT'S THE SAME EXACT CONCEPT.
LET'S LOOK AT A COUPLE OF OTHER ITEMS HERE.
IF I LOOK AT MY EQUIPMENT, I CAN LOOK AT ALL MY EQUIPMENT IN ONE LARGE FILE.
IF I, IF I MAY, OR MAYBE I JUST WANNA LOOK AT MY 41 PICKUP TRUCKS OR MY 22 PLOW TRUCKS, UH, INDIVIDUALLY.
SO IF WE LOOK AT PICKUP TRUCKS, AGAIN, IT'S ESSENTIALLY THE SAME SCREEN.
YELLOW, MANDATORY WHITE, OPTIONAL MULTIPLE TABS.
AND FOR EQUIPMENT, WE'VE GOT A WIDE ARRAY OF DATA THAT WE'RE HELPING YOU MANAGE.
CAN WE BRING IN PICTURES? YES, YOU MAY.
OF THE TRUCK RIGHT ON MY MORE BUTTON? MM-HMM.
UH, THERE'S A PICTURE OF THAT CHEVY PICKUP TRUCK.
IS IT NOT TIED TO THAT RECORD? I'M SORRY? IS IT TIED TO THAT RECORD? YES, IT IS.
WHEN YOU'RE ENTERING IT, I'M SORRY, IS IT TIED TO THE PUT IT IN? I DON'T QUITE UNDERSTAND YOUR QUESTION.
SO YOU'RE ENTERING OUR MAINTENANCE ON, UH, ON A S 10 LAKE.
AND YOU PULL UP THE RECORD FOR THAT WAY WHEN YOU CLICK ON SOMETHING.
IT DOESN'T JUST AUTOMATICALLY ONE OFF.
I'M SORRY, THE RECORD FOR THAT ONE VEHICLE, DOES THAT PICTURE POP UP? NO, I THINK WHAT SHE'S ASKING IS YOU HAVE TO CLICK ON, CLICK ON SOMETHING.
SO IF I'M LOOKING AT, LIKE, FOR EXAMPLE, THE FLEET WORK ORDER, THIS FLEET WORK ORDER HERE SAYS THAT I'M DOING WORK ON THAT CHEVY 2,500.
IT'S NOT SHOWING ME A PICTURE OF THAT VEHICLE.
BUT IF I CLICK ON THIS BLUE HYPERLINK, CAN YOU SEE THAT? THAT'S A BLUE HYPERLINK THERE.
THAT WHERE IT SAYS EQUIPMENT NAME IS BLUE IS AN UNDERSCORE.
SORRY, I CAN'T YOU, YOU'RE FAR AWAY.
SO, UM, IT'S A BLUE HYPERLINK AND WHEN YOU CLICK ON THE HYPERLINK THAT BRINGS UP THE EQUIPMENT RECORD FOR YOU.
NOW, WHETHER THERE'S A VEHICLE PICTURE ATTACHED TO THAT RECORD OR NOT, WE REALLY DON'T KNOW.
I MEAN, YOU'D HAVE TO CLICK ON THE MORE BUTTON AND THEN THERE, THERE, YOU KNOW, THEN CLICK ON THE DISPLAY AND THERE'S, THERE'S YOUR ITEMS. SO YOU'VE GOT A COUPLE OF MOUSE CLICKS TO GET TO IT.
UM, IF, IF YOU WERE TO TELL ME THAT WE WON'T BUY THE PROGRAM UNLESS YOU SHOW THAT PICTURE AUTOMATICALLY, I'LL IT DONE THIS AFTERNOON.
WELL, IT'S JUST A FILE SO YOU DON'T BE ABLE TO ATTACH IT TO YEAH.
ANY KIND OF A FILE THAT YOU HAVE.
THE ONLY REASON A PDF I HAD PROGRAM BEFORE THAT WHENEVER YOU ATTACHED A PICTURE TO IT, WHEN YOU BROUGHT UP THE INFORMATION ON THE PICTURE, WAS THERE TO, TO ROUND OUT THE INFORMATION.
THAT, THAT'S LIKE THE CHOREOGRAPH WAY OF DOING THINGS.
THEY MAKE THAT PICTURE AVAILABLE.
YEAH, THAT'S A NICE, SHE'S SHE'S A CHOREOGRAPHED QUEEN.
[00:35:01]
MM-HMMTHE, THE, THE CHALLENGE THERE IS, IS OFTENTIMES NOT THE PICTURE OF VEHICLE THAT, THAT'S A VEHICLE RECORD, BUT, UH, WE HAVE A LOT OF CLIENTS WHO WILL ATTACH A BEFORE AND AFTER OF EVERYTHING.
SO IF YOU HAVE A, IF YOU, AND THEY MAY HAVE 10 OR 12 OR 15 ATTACHMENTS THERE.
SO YOU MAY HAVE A A, YOU MAY HAVE A FLOOD, A WASHED OUT CULVERT, YOU TAKE SOME PHOTOS OF THAT AND YOU TAKE PHOTOS AS YOU FINISH IT.
AND THEN YOU MAY EVEN HAVE AS-BUILT DRAWINGS, UH, AND THE ENGINEERING DRAWINGS ALL ATTACHED TO THAT ONE RECORD TO THAT ASSET.
SO YOU CAN GO THROUGH THERE AND SAY, GO AHEAD GEORGE.
UM, I THINK IF YOU UNMUTE THE MUTE BUTTON, THAT LITTLE SQUARE BOX WILL START, STOP GOING UP ON YOUR REMOTE.
UNDO THE WHAT BUTTON? SEE THE LITTLE MUTE BUTTON? YEAH.
I THINK IF WE, ON YOUR, UH, REMOTE, ON YOUR REMOTE, IF WE UNMUTE IT, THAT WILL GUY GO AWAY, I THINK, RIGHT? STEVE? JUST REMOTE.
WHICH REMOTE? THE WHITE BLACK ONE.
I DON'T, SO LET'S CALL BACK UP JUST FOR ONE SECOND ABOUT THE, ABOUT THE MORE BUTTON.
UH, 'CAUSE IT TIES TO THE QUESTION HERE ABOUT FEMA.
UH, UH, MOST OF THE COUNTS, I KNOW THAT, THAT HAVE HAD A FEMA EVENT, UH, WANTS TO DOCUMENT THAT BEFORE AND AFTER.
IN ONE, IN ONE OF OUR, UH, UH, UH, BETTER CUSTOMERS IN FLORIDA INDIAN RIVER, UH, THEY HAD A FEMA EVENT.
AND SO WHAT THEY'VE DONE IS THEY'VE GONE AROUND AND THEY'VE TAKEN A PHOTO OF EVERY ASSET THAT THEY HAD.
IT TOOK 'EM A LONG TIME, BUT THEY ATTACHED THE PICTURE OF, OF EVERY SINGLE ASSET IN THE ENTIRE COUNTY.
BECAUSE WHEN THEY HAD THEIR HURRICANE, FEMA CONTENDED A LOT OF THINGS.
THERE WERE PARK BENCHES THAT WERE WASHED OUT AND, AND THEY WANTED TO SAY, WELL, THOSE BENCHES, SOME OF THOSE BENCHES WEREN'T THERE, SOME OF 'EM WERE DAMAGED, SOME OF 'EM, SO WE'RE NOT GOING TO PUT IN A HUNDRED NEW PARK BENCHES FOR YOU ALL BRAND NEW 'CAUSE YOU CLAIMED IT.
SO FROM HENCE FORWARD, THEY WANTED DOCUMENTATION OF ALL OF THE CONDITION AND A PICTURE OF ALL THEIR ASSETS THROUGHOUT THE WHOLE COUNTY.
SO, SO THE NEXT TIME THEY HAVE A PROBLEM, THEY CAN SAY, YEAH, IT WAS A NEW PARK BENCH AND WE, AND IT WAS WIPED OUT BY, BY THE HURRICANE.
SO THAT'S, THAT'S WHY, UH, IT'S, IT'S VERY IMPORTANT TO HAVE AS MUCH DOCUMENTATION IN YOUR ASSETS.
AND ALSO THE, UH, THE PHOTOS ARE GREAT, BUT THERE'S ALSO DATA FIELDS THAT SUPPORT THAT IN, UH, IN A WAY THAT YOU CAN RUN REPORTS.
SO FOR EXAMPLE, ON THIS PICKUP TRUCK, WE'VE GOT ACQUISITION DATE AND SERVICE DATE.
THERE'S EXPIRATION DATES FOR THE REGISTRATION.
THERE'S ALL SORTS OF DATES THAT CAN BE TIED TO THE ASSET THAT CAN DRIVE REPORTS SO THAT YOU CAN PULL OUT YOUR VEHICLE CONTEXT, A SUBSET OF YOUR VEHICLES THAT HAVE, UH, BEEN WITH YOU FOR 15 YEARS AND ARE SCHEDULED FOR REPLACEMENT OR, OR SOMETHING OF THAT NATURE.
UM, BUT JUST ROUNDING OUT A DISCUSSION OF, OF EQUIPMENT AND VEHICLES, UH, THERE ARE STANDARD ATTRIBUTES THAT WE'RE STORING.
UH, THE UNIT NUMBER IS A KEY ELEMENT.
THAT'S THE IDENTIFIER AND A DESCRIPTION IS VERY IMPORTANT.
UH, BUT WE'VE GOT DEPARTMENTALIZED AND CATEGORIZE VEHICLES AND EQUIPMENT SO THAT YOU CAN RUN REPORTS THAT JUST LOOK AT
I'M REALLY STRUGGLING WITH THE TECHNICAL SIDE HERE.
UM, YOU CAN RUN REPORTS THAT JUST LOOK AT PICKUP TRUCKS THAT BELONG TO A PARTICULAR DEPARTMENT OR PRECINCT, IF YOU WILL.
UM, SO THOSE ARE VERY IMPORTANT CAPABILITIES.
WE ARE, WE'RE HELPING YOU MANAGE THE DEPRECIATION SCHEDULE IF YOU WISH.
UH, WE'VE GOT A TIE IN TO ANY FUELING SYSTEM WE'VE EVER SEEN.
SO IF YOU HAVE A FUELING SYSTEM, YOU HAVE VARIOUS FUELING SYSTEMS HERE.
PETRO GAS BOY, WE USE FUEL MAN, FUEL MAN, FUEL MAN, GAS BOY, THE TWO SUPERHEROES OF FUEL, MY JOKES, IT'S NOT A GOOD.
SO WE, WE SIT, WE'VE INTERFACE WITH ALL THOSE SYSTEMS. UM, INTERFACING THOSE SYSTEMS IS VERY POWERFUL BECAUSE IT ALLOWS YOU TO BRING IN ODOMETER RES AND NOT ONLY THE FUEL CHARGES AND FUEL QUANTITIES, BUT THE ODOMETER RES HELP DRIVE A PM SCHEDULE.
I'M LOOKING AT THIS CHEVY PICKUP TRUCK ON ITS FLEET WORK ORDER LOG IS A COMPLETE MAINTENANCE HISTORY OF EVERYTHING THAT'S EVER BEEN DONE TO THAT VEHICLE.
AND A SIMPLE DOUBLE CLICK ON A ROW WILL BRING UP THAT WORK ORDER RECORD FOR.
SIMILARLY, THERE'S A AN ACTIVITY LOG TAB, WHICH SHOWS US WHERE THAT VEHICLE'S BEEN USED IN THE FIELD FOR WORK.
AND JUST AS WE SAW BEFORE, UH, YOU
[00:40:01]
CAN DOUBLE CLICK ON THE ROW AND THAT'LL BRING UP, OOPS, I DUNNO WHAT HAPPENED HERE FOLKS.I'M UH, NOT DOING A GREAT JOB AT THIS.
I KNOW WHAT THE PROBLEM IS HERE, BUT, UH, YOUR MATERIAL, YOU KNOW, LOOKING AT THESE VEHICLE RECORDS, THERE'S ACTIVITY LOGS THAT WILL SHOW US WHERE THAT VEHICLE HAS BEEN USED IN THE FIELD FOR VARIOUS JOBS.
AND THEN THERE'S A LIST VIEW THAT GIVES US A LISTING OF ALL THE VEHICLES WE'VE GOT ON FILE.
CLICKING ON COLUMN HEADINGS WILL SORT THE DATA BASED ON THE COLUMN HEADING AND CLICK DOUBLE CLICKING WILL OPEN UP THE RECORD FOR YOU AND TAKE YOU WHERE YOU, UH, ARE EXPECTING TO GO.
THERE'S ALSO WHAT WE CALL LOCATIONS.
LOCATIONS ARE THE ASSETS THAT YOU POSSESS, THAT YOU MANAGE THAT IS YOUR PRIMARY, UH, RESPONSIBILITY.
SO WE CAN, JUST LIKE WE DID WITH EQUIPMENT, THESE EQUIPMENT TYPES, WHICH ARE USER DEFINED, CUSTOMER DEFINED, ALLOW YOU TO SEGREGATE YOUR VEHICLES INTO VARIOUS CATEGORIES AND CLASSES.
THE SAME IS TRUE WITH LOCATIONS.
WE CAN BREAK UP OUR LOCATIONS INTO ANY NUMBER OF CUSTOMER DEFINED, UH, CATEGORIES.
SO I'VE GOT STREETS, I'VE GOT 464 STREETS AND I'VE GOT WATER LINES.
I'VE GOT A WHOLE VARIETY OF ITEMS HERE.
SO IF YOU LOOK AT SOME STREET RECORDS, HERE'S A REC, HERE'S A ROAD.
BABBITT LANE IS ONE OF OUR STREETS.
IT'S IN A CERTAIN DISTRICT, IT'S ASPHALT PAVED.
IT'S GOT, UH, VARIOUS METRIC ATTRIBUTES DOWN HERE ON THE LOWER LEFT AND WHAT WE CALL CUSTOM ATTRIBUTES OVER HERE ON THE LOWER RIGHT.
THIS ALLOWS YOU TO CUSTOMIZE PRECISE NATURE OF THAT ASSET THAT YOU'RE RESPONSIBLE FOR MAINTAINING.
WHEN WE LOOK AT THIS PARTICULAR BA LANE, IT HAS AN ACTIVITY LOG OUT HERE ON THE RIGHT, WHICH IS THE COMPLETE MAINTENANCE HISTORY OF WORK PERFORMED ON THAT ROADWAY.
IT'S GOT A SERIES OF FEATURES WHICH ALLOW US TO DEFINE SIGNS AND CULVERTS AND CATTLE GUARDS THAT MIGHT EXIST ON THAT ROADWAY.
SO IT'S GOT SERVICE REQUEST HISTORY AS WELL, WHICH IS SHOWING US ALL THE, WHAT A LOT OF CUSTOMERS CALL WORK ORDERS THAT HAVE BEEN CALLED IN, UH, ABOUT THAT ROADWAY.
SO IF I SORT THEM BY TYPE, LET'S AGAIN, I'VE GOT A NUMBER OF POTHOLE PROBLEMS HERE.
AND IF I WERE JUST TO DOUBLE CLICK ON ANY ONE OF THOSE, YOU WOULD BRING UP THAT, CAN WE PRINT THOSE WORK ORDERS? ABSOLUTELY.
A A LOT OF DIFFERENT WAYS YOU CAN PRINT THEM.
UM, FOR EXAMPLE, JUST A SIMPLE PRINTOUT.
WE CALL THIS WITH THE GRID AND, UM, LITTLE SHORT ON THE SCREEN REAL ESTATE.
BUT THAT WOULD BE ONE SAMPLE WE LIKE TO SHOW THE SAMPLE BECAUSE THIS CAME FROM A CUSTOMER REQUEST WHERE THE TOP SECTION OF THE SCREEN OF THE PRINT PREVIEW IS ALL THE NITTY GRITTY OF THE REQUEST.
THE BOTTOM HALF IS SORT OF A WORKSHEET THAT A CUSTOMER SUGGESTED WE ADD TO THE SYSTEM MANY YEARS AGO BECAUSE THEY WOULD PRINT THIS OUT AND HAND IT TO CHARLIE.
CHARLIE, TOM AND DICK WOULD TAKE CARE OF THAT PROBLEM.
AND UM, YOU KNOW, THEY, THEY WOULD PUT IN THE EMPLOYEES HERE, THE EQUIPMENT HERE AND THE MATERIALS USED THERE.
AND THEN THAT CAN BE USED BACK IN THE OFFICE TO TRANSCRIBE INTO WHAT WE CALL A CREW ACTIVITY, WHICH DOCUMENTS THE WORK, TIES IT TO THE SERVICE REQUEST.
AND IF YOU HAVE IT SO CONFIGURED WOULD CLOSE THE SERVICE REQUEST OUT.
UM, YOU KNOW, THERE'S A, SO WHEN WE, WHEN WE LOOK AT THIS REQUEST, THERE'S A NUMBER OF PRINT OPTIONS, EVEN EMAIL TOO.
AND WE CAN READ THE PRINT LIKE FOR EACH ROAD, SAY 2 57.
IF I WANTED TO PULL THAT, I COULD PRINT ALL OF THE ACTIVITY IF I WANTED.
YOU CAN SHOW IT WITH A MAP AS WELL THAT YOU'RE UNCLEAR ABOUT WHAT THE LOCATION.
SO THAT CAN BE PRINTED WITH AN APP.
SO WE, IF WE RAN A LOCATION COST REPORT, AND I WANT TO JUST GIMME A, YOU KNOW, GIMME A TASK SUMMARY FOR BAIT LANE, UH, THROUGH ANY DATE RANGE, YOU KNOW, I'LL, I'LL PICK THE YEAR 2017.
I DON'T KNOW IF I'VE GOT COURSE I'VE GOT THAT RIGHT.
SO THIS IS, YOU KNOW, EVERYTHING WE DID ON THAT ROAD, UH, IN THAT TIMEFRAME.
AND IT'S BREAKING IT OUT BY TASK.
[00:45:01]
OF DATA HERE.SO, UM, 16, YOU KNOW, THIS IS THE TOTAL COST FROM THAT YEAR.
WE SPENT $57,900 ON THIS ROAD, BUT IT'S TELLING US THAT THE ROAD IS ABOUT A THIRD OF A MILE LONG AND IT GIVES US A COST PER MILE.
SO, WHICH, YOU KNOW, FOR A ROAD MANAGER COULD BE A VERY VALUABLE STATISTIC AND KNOW WHAT I NEED TO ALLOCATE FOR BUDGETING PURPOSES OR WHAT HAVE YOU.
AND WE'RE BREAKING THOSE COSTS INTO LABOR EQUIPMENT AND MATERIAL, BUT ALSO CONTRACTOR COSTS.
WE KNOW FROM OUR, PARTICULARLY IN THE COUNTY ENVIRONMENT, THEY CONTRACT A LOT OF STUFF OUT FOR HAULING, FOR CERTIFICATE JOBS, ENGINEERING SERVICES OF THAT, THINGS OF THAT NATURE.
SO BEING ABLE TO ACCOUNT FOR THAT IS A VERY POWERFUL, UH, FEATURE.
BUT, BUT YOUR QUESTION WAS, CAN I ISOLATE WORK THAT WAS DONE ON ONE OF MY PARTICULAR ROWS EASILY? AND THE ANSWER IS, WELL, I MEAN, WELL I'VE BEEN USING THIS EVEN THOUGH I'VE BEEN BUNGLING THIS DEMO.
I HAVE BEEN USING THE SYSTEM FOR A LONG TIME.
I DO KIND OF KNOW WHAT I'M DOING HERE, EVEN THOUGH I'M NOT DEMONSTRATING THAT I, I GOT A NEW LAPTOP AND I'M TRYING TO CONVERT FROM THE NEW LAPTOP AND I, WE GOT HALFWAY THROUGH IT, SO I WENT BACK TO THE OLD LAPTOP AND UH, I GOTTA TURN OFF THE PHONE SOMETIMES ANYWAY, UH, SO YOU CAN DO THAT.
UM, SO THESE, THESE THINGS LIKE THESE BUILDING BLOCKS, THESE ARE ALL BUILDING BLOCKS INTO YOUR ACTIVITY DATABASE.
SO LET'S, LET'S JUST GO THROUGH A SCENARIO WHERE, UH, WE GET A SERVICE REQUEST, UH, FOR A POTHOLE, LET'S SAY.
SO SOMEBODY PHONES IN OR MAYBE SOMEBODY WENT TO OUR WEBSITE AND THEY SUBMITTED ONE OF THESE, UM, SERVICE REQUESTS.
SO THEY, THEY COULD COME TO THIS FORM AND THEY CAN SELECT THE ROAD THAT THEY LIVE ON.
THEY CAN SELECT A REQUEST TYPE LIKE A POTHOLE PROBLEM, AND THEY'LL FILL IN THEIR NAME, RANK, AND SERIAL NUMBER OVER HERE ON THE LEFT HAND SIDE AND PERHAPS A DESCRIPTION HERE.
AND THEY'LL, THEY'LL CLICK THE SUBMIT BUTTON AND THAT, THAT REQUEST THROUGH YOUR WEBSITE WILL AUTOMATICALLY FIND ITS WAY INTO THE PUBLIC'S DATABASE.
ANOTHER WAY TO GET THAT IN IS MAYBE THE PHONE RINGS AND YOU, UH, BRING UP YOUR SERVICE REQUEST SCREEN AND YOU'LL DO AN ADD.
AND HERE'S WHERE THE YELLOW, MANDATORY YELLOW, UH, WHITE OPTIONAL CAN BE VERY HELPFUL.
YOU AS A USER, AND I HOPE YOU CAN SEE THAT FROM THE BACK OF THE ROOM, THAT THERE ARE CERTAIN WHITE FIELDS AND YELLOW FIELDS.
UM, YOU AS THE CUSTOMER CAN CONFIGURE WHICH FIELDS ARE MANDATORY, WHICH ONES ARE NOT.
SO THE STATUS AUTOMATICALLY GETS SET TO OPEN.
UH, THE REQUEST TYPE, MAYBE I JUST TYPED LETTER P FOR POTHOLE.
IF I MISSPELLED POTHOLE LIKE THAT, YOU CAN CLEARLY SEE THAT THAT'S MISSPELLED.
AND WHEN I MOVE OFF OF THAT FIELD, WHAT'S GOING TO HAPPEN TO THAT WHEN WE THROW GARBAGE AWAY, WE'RE NOT A GARBAGE IN THE SYSTEM.
IF YOU, WE HAVE A CUSTOMER, YATES COUNTY, NEW YORK, UM, USED A COMPETITOR PRODUCT FOR A LONG TIME.
AND FERGUSON CORNERS ROAD WAS THE MOST IMPORTANT ROAD IN IN YATES COUNTY.
THIS IN THE SYSTEM, 18 DIFFERENT WAYS, ALL SPELLED WRONG.
THEY COULD NEVER RUN A REPORT FOR THEIR MOST IMPORTANT ROADWAY BECAUSE THE SYSTEM ALLOWED GARBAGE IN.
SO ALLOWING GARBAGE IN IS A REAL PROBLEM.
HOW DO YOU PREVENT THAT? YOU THROW GARBAGE AWAY.
MAKE IT EASY FOR THE USER TO SELECT THE APPROPRIATE ITEM.
I TYPE THE LETTER P AND FOUND THE POTHOLES.
IF THAT'S NOT WHAT I WANT, I OPEN THE DROP LIST AND ALPHABETICALLY THEY'RE THERE.
I MAKE A SIMPLE CLICK AND, AND IT, THE PROPER VALUE GETS INSERTED.
THE DATE AND TIME ARE PLUGGED IN AUTOMATICALLY.
I CAN CHANGE THAT WITH A CALENDAR.
WE'RE TYPING IN T FOR TODAY, Y FOR YESTERDAY, M FOR TOMORROW.
WELL WE'RE IN TEXAS M FOR ANA.
I I DID THAT IN OHIO AND THEY'RE LIKE ANA'S THAT, THAT'S A LONG TIME AGO.
ANYWAY, UM, SO TEAM FOR TODAY AND UH, WHEN I PICKED THE SIGN PROBLEM, CONNIE PEMBERTON AND ROAD AND BRIDGE WAS AUTOMATICALLY INSERTED THERE.
SO WE CAN SET UP SOME AUTOMATION FOR YOU SO THAT THE APPROPRIATE ASSIGNEE IS HANDED THE PROPER PROBLEM TYPES.
AND THEN ON MY LOCATIONS AGAIN, UH, THEY PHONED IN AND THEY SAID, WELL I LIVE ON BABCOCK LANE AND I'LL JUST TYPE IN BAB AND THERE'S BABBIT LANE, BUT BABCOCK WILL BE RIGHT BEHIND IT.
OR I CAN CLICK THIS LITTLE LOOKUP L BUTTON AND TYPE IN BAB AND THERE'S BABCOCK LANE DOUBLE CLICK AND BOOM, IT GOES IN THERE.
MAYBE THEY TOLD ME THEY WERE 53 BABCOCK CLAIM AND THEIR LAST NAME WAS SMITH.
AND I KNOW I'VE HEARD FROM SMITH BEFORE.
SO I JUST TYPE IN SMI AND CLICK MY FIND BUTTON.
AND THERE'S ALL THE SMITHS THAT HAVE CALLED IN PROBLEMS AND IT'S, IT'S OUR BUDDY KAREN SMITH.
I'M KEEPING TRACK OF ALL THE CALLS THAT SHE'S CAUSED US TO ENTER.
[00:50:01]
AND I'LL SELECT USE EXISTING CALL.AND THEN I'LL SAY, THIS IS A, YOU KNOW, WELL I, I'LL LET'S GO, LET'S FIND OUT IF IT'S A SEVEN EIGHT CALL
HAS ANYBODY HEARD OF THIS THING CALLED THE INTERNET? AND YOU SEE THOSE BLUE UNDER THOSE HYPERLINKS? SO WE'VE GOT HYPERLINKS THROUGHOUT THE SYSTEM.
IF I CLICK ON THAT LAST NAME, THAT BRINGS UP KAREN'S RECORD AND THERE'S HER NAME, YOU KNOW, PHONE NUMBER AND ALL THAT STUFF.
BUT THERE'S A TAB HERE CALLED THE SERVICE REQUEST LOG AND IT SAYS THERE'S A FOUR.
THIS FOUR TELLS ME THAT THERE'S, SHE'S CALLED OVERTIME.
DOES, DID ANYBODY USE, DOES ANYBODY USE QUICKBOOKS? YOU GOT YOUR CUSTOMERS AND QUICKBOOKS.
DO YOU KNOW HOW MANY CUSTOMERS YOU GOT? THEY DON'T TELL YOU THEY NEVER SHOW YOU A NUMBER.
YOU'RE LOOKING AT A GRID OF ITEMS. AND UNLESS YOU'RE THE RAIN MAN, YOU, YOU CAN'T TELL HOW MANY ITEMS WERE THE LIST.
SO YOU KNOW, WHEN I'M, YOU COULD EYEBALL THAT THERE'S FOUR, BUT IF THERE WAS SEVEN THERE OR OR 27 WHERE WE SCROLL BEYOND, YOU WOULD NEVER KNOW.
SO RIGHT OFF THE BAT, I KNOW IT'S FOUR 'CAUSE IF IT'S FOUR, IT'S LIKE, OKAY, SHE CALLS OCCASIONALLY IF IT'S 44, SHE'S LIKE A CONSTANT PERPETUAL CALLER.
I HAVE SOME THAT THAT WAY CALL IT.
AND I'M LIKE, WELL WE'VE BEEN, I'M FLIPPING THROUGH MY BOOK GOING, I DON'T THINK SO ANOTHER QUESTION IS THAT THESE PEOPLE WILL SAY, WELL YOU'VE NEVER COME TO MY ROAD.
OH YES, SO, SO THERE'S ANOTHER HYPERLINK RIGHT THERE.
CLICK ON THAT LOCATION NAME AND IT TAKES YOU RIGHT TO BAB BABCOCK LANE.
IT SAYS, YOU KNOW, WE WERE OUT THERE YESTERDAY ON THE 22ND, WE WERE OUT THERE DOING THIS AND THAT.
SO, YOU KNOW, LIKE I TALK ABOUT EASE OF USE, EASE OF USE ISN'T ONE THING, BUT BEING ABLE TO NAVIGATE FROM ONE SCREEN TO ANOTHER WITH A CLICK.
UH, UH, AND I'VE GOT THIS GREAT THING TO COMPARE IT TO QUICKBOOKS IS OUR, OUR COMPANY BOOKS ARE IN QUICKBOOKS AND IT'S LIKE ALMOST INFERIOR THING.
SO, UM, SO I'M ENTERING THE FACT THAT, UH, LEMME FINISH THIS NOTE OUT.
I'VE GOT THIS SERVICE REQUEST AND IT'S BEEN ASSIGNED TO CONNIE AND WHEN I CLICK THE SAVE, UH, SIGN IN THERE, UH, IT'S GOING TO, IT'S GONNA TRY TO DO AN AUTO EMAIL, BUT I DON'T HAVE OUTLOOK INSTALLED BECAUSE OF DON'T ASK ME WHY.
AND UH, SO IT'S GAVE ME A LITTLE ERROR MESSAGE ABOUT THAT.
SO THERE'S SOME AUTOMATION AS WELL BEHIND THE SCENES THAT CAN BE TURNED ON OR TURNED OFF WHERE WHEN I SAVE THAT RECORD, CONNIE'S AUTOMATICALLY RECEIVING AN EMAIL.
UM, ALSO IF SHE HAD THE TABLET, UH, ON HER, THIS IS ANOTHER
SO, SO, UH, BUT THAT WOULD ALSO GO TO CONNIE'S, UH, EMAIL IF SHE WAS, I CAN GET THAT TEAM DEALER THING HERE OR TO THE SMARTPHONE SO I CAN, UH, YOU PROBABLY CAN'T SEE THAT TOO WELL, BUT YOU KNOW, I'M LOGGED IN AS CONNIE PEMBERTON AND WHEN SHE TAPS ON THAT TILE FOR SERVICE REQUESTS, IT'S BRINGING UP A LIST OF HER REQUESTS.
SO, UH, YOU KNOW, THEY'RE NOT, THESE TWO SYSTEMS AREN'T IN SYNC 'CAUSE I COULDN'T GUARANTEE AN INTERNET CONNECTION HERE.
BUT, UH, YOU KNOW, SHE WOULD SEE THAT ON HER, ON HER SMARTPHONE OR HER TABLET OR YOU COULD EMAIL IT TO HER OR YOU COULD PRINT IT TO HER AND PUT HER ON HER SEAT OR IN INBOX.
SO, SO CONNIE GETS THIS REPORT AND UM, SO SHE'S GONNA LOG INTO THE SYSTEM, LET'S SAY.
SO SHE'LL COME IN INTO PUB WORKS AND WE HAVE THIS SCREEN WE CALL THE, UM, THE SERVICE REQUEST STATUS SCREEN.
AND MAYBE I'LL, IT WOULD BE AUTOMATICALLY FILTERED.
IN OTHER WORDS, IT WOULD JUST BE SHOWING THE REQUESTS.
OUR SCREEN'S A LITTLE CUT OFF AT THE BOTTOM THERE, BUT IT'S SHOWING ME A LIST OF REQUESTS THAT ARE ONLY FOR THIS PARTICULAR ASSIGNEE.
SO THE CONFIGURATION COULD BE THAT WHEN I LOG IN AND PRETENDING THAT I'M CONNIE, AND I COULD USE THIS AS WHAT WE CALL OUR START SCREEN.
SO WHEN I LOG INTO PUB WORKS, THIS SCREEN WOULD BE AUTOMATICALLY PRESENTED TO ME AUTOMATICALLY FILTERING BY ME AS THE ASSIGNEE.
SO I ONLY GET THE C AND HERE'S A GREAT EXAMPLE.
I'M NOT TALL ENOUGH, ONLY TALL TEXANS NEED TO REACH UP THERE AND POINT TO THAT 11 UP THERE.
UM, THERE'S 11 ITEMS IN THAT LIST.
SO I KNOW THAT I'VE GOT 11 OPEN SERVICE REQUESTS ON MY PLATE AND IT IS GIVING ME SORT OF A, A RUNDOWN OF EVERYTHING I'VE GOT HERE.
SO IF I, YOU KNOW, SORT THEM BY LOCATION, THERE'S THAT ONE FOR BABCOCK LANE WE JUST ENTERED AND I CAN DOUBLE CLICK ON THAT AND IT BRINGS UP THAT SERVICE REQUEST RECORD FOR ME.
I CAN REVIEW ALL THE NITTY GRITTY AND THE DETAILS.
I CAN ATTACH PHOTOGRAPHS OR PDFS OR WORD
[00:55:01]
DOCUMENTS OR ANY KIND OF DOCUMENT AT ALL THROUGH THE MORE BUTTON.I CAN SEE WHERE THAT IS ON MY MAP JUST BY CLICKING THE MAP BUTTON THERE.
IT IS PINPOINTED, IT'S IT'S RED, MEANING IT'S OPEN.
BUT THIS IS WHERE MY PROBLEM IS.
SO I GATHER MY CREW, WE GO OUT THERE, WE TAKE CARE OF THIS PROBLEM AND UH, WE HAVE THIS SERVICE REQUEST OPEN FOR US IN FRONT OF US.
I'M GOING TO DOCUMENT WORK THAT I'VE TAKEN CARE OF THIS PROBLEM.
SO THERE ON THE, RIGHT HERE ON THE RIGHT HAND SIDE ARE THESE TWO BUTTONS.
UH, WE'VE GOT A NUMBER OF DIFFERENT WAYS TO DOCUMENT WORK, BUT UH, FOR SERVICE REQUESTS, THERE ARE TWO OF DAILY ACTIVITY, WHICH IS A WAY TO DOCUMENT WORK FOR A SINGLE WORKER.
A CREW ACTIVITY IS A WAY TO DOCUMENT WORK FOR ONE OR MORE WORKERS.
SO I'LL CLICK ON CREW AND I'LL PICK MY POTHOLE REPAIR CREW.
AND WHEN I MADE THAT ONE SELECTION, IT FILLED IN MY TOM, DICK AND HARRY, MY NED GLENN AND KEN GOT FILLED IN.
BUT ALSO THAT WHAT GOT FILLED IN IS, UM, IT CAUSED THIS AUTOMATICALLY TO THAT SERVICE REQUEST PROBLEM.
UM, IT KNOWS IT'S A POTHOLE REPAIR AND I DID A POOR JOB IN TYING THESE TOGETHER.
I SHOULD HAVE PICKED A DIFFERENT TYPE, BUT IT'S FILLING OUT EVERYTHING IT KNOWS FROM THE REQUEST AND PUTTING IT HERE FOR ME.
AND I'VE GOT A CREW ALREADY ASSEMBLED AND THEY WERE SELECTED TO DO THE WORK WITH EQUIPMENT AND MATERIALS.
SO MY JOB COSTING RECORD HAS KIND OF LIKE FILLED IN ITSELF.
NOW WITH POWER COMES RESPONSIBILITY, WELL THEY DIDN'T ALL WORK EIGHT HOURS, SO LET ME JUST CHANGE THAT, YOU KNOW, IT WAS A TWO HOUR JOB.
AND UM, SO I WANT TO CHANGE ALL THOSE DETAILS THERE.
AND I'M GONNA SAY, WELL WE DIDN'T USE THOSE VEHICLES FOR THAT LONG.
WE USED THOSE FOR TWO HOURS AS WELL.
AND OUR PATCH MATERIAL, WE DIDN'T USE 10 BAGS OF IT, WE USED ONLY TWO BAGS OF IT.
SO AS I'M ENTERING OR UH, EDITING I SHOULD SAY THOSE QUANTITIES OF USE, MY JOB COSTS OVER HERE AND THEY'RE IN BLUE, THE PROJECTOR IS DOING A GOOD JOB OF SHOWING THEM IN BLUE.
UM, THESE BLUE NUMBERS UP HERE ARE GIVING ME A, A JOB COST FOR THIS PARTICULAR ITEM.
AND WHEN I CLICK THE SAVE BUTTON AT THE TOP OR THE BOTTOM OR JUST HIT ENTER, UM, THE SOFTWARE IS GOING TO CLOSE THAT REQUEST.
AND THE WAY I'VE GOT IT CONFIGURED RIGHT NOW, IT'S PROMPTING ME TO PUT IN A CLOSING COMMENT AND I'M GOING TO TYPE IN THIS CLOSING COMMENT BECAUSE I'M NOT A VERY GOOD SPELLER AND I'M JUST GONNA TYPE IN THAT GOBBLY BOOK.
SO THIS $178 AND 42 CENTS HAS NOW BEEN ALLOCATED AUTOMATICALLY THROUGH THE SYSTEM.
IT'S BEEN ALLOCATED TO THIS TASK, IT'S BEEN ALLOCATED TO THAT ROAD, IT'S BEEN ALLOCATED TO THE SERVICE REQUEST.
AND IF I CLICK ON THAT BLUE HYPERLINK THERE, IT'LL BRING UP THE SERVICE REQUEST RECORD FOR ME AND WILL NOTICE THAT IT'S BEEN CLOSED, IT'S INHERITED THAT COST, THAT NOTE OF GOBBLEDY GOBBLEDYGOOK HAS BEEN PLACED RIGHT THERE.
THE ACTIVITY LOG TAKES ON THE TOM, DICK AND HARRY WHO DID THE WORK AND THEIR ASSOCIATED COSTS.
SO WITH JUST A COUPLE OF CLICKS I WAS ABLE TO FIND THE PROBLEM, DOCUMENT THE WORK, TIE THEM TOGETHER AND CLOSE IT OUT.
YOU KNOW, LIKE I SAID, I PRACTICE THIS A LITTLE BIT EVEN THOUGH IT MIGHT NOT HAVE SEEM THAT WAY.
DO WE, THIS SOUND LIKE AHOE CREW? 'CAUSE SOMETIMES WE MAY SEND ONE PERSON HERE, ONE MAYOR, CAN IT JUST LIST LIKE ALL THE EMPLOYEES WHO WENT? ABSOLUTELY.
SO I, I USE THAT SORT OF ABBREVIATED THING, BUT IF I COME BACK TO MY CREW ACTIVITY SCREEN AND DO AN AD, IT'S, IT'S, UM, IT'S REMEMBERING I'VE GOT IT SET UP TO REMEMBER, BUT FROM THE LAST ENTRY, BUT THERE'S THE WHOLE LIST OF MY, ALL OF MY EMPLOYEES.
SO I CAN PICK WHOEVER I WANT AND UH, YOU KNOW, I'VE GOT BOB RE HE CAME IN AND HE WORKED FOR TWO HOURS AND KEN DOUGLAS DIDN'T SHOW UP TODAY, SO I'M GONNA REMOVE HIM FROM THE CREW.
BUT THAT'S A, A TEMPORARY REMOVAL JUST FOR THAT PARTICULAR INSTANCE.
SO YES, THE ANSWER IS YES, YOU'VE GOT ALL DEGREES OF FREEDOM TO ASSEMBLE ANY KIND OF AD HOC CREW YOU WANT.
WE'VE GOT CUSTOMERS WHO SET THEM UP AND CUSTOMERS WHO NEVER USE THEM.
UM, I CAN THINK OF A CUSTOMER IN MISSOURI THAT HAS THEIR VERY RIGID ABOUT THEIR CREWS.
THEY GET EVERYTHING, YOU KNOW, STAGED IN THE MORNING.
THEY CREATE A BUNCH OF THESE CREW ACTIVITIES, WHICH ESSENTIALLY LINES OUT THE WORK FOR THE DAY AND AT THE END OF THE DAY THEY JUST FILL IN THE BLANKS ON HOW MANY HOURS THEY'RE AT WORK.
SO IT IT'S A VERY HANDY TO DO A QUESTION ABOUT THE ASSOCIATED COST.
HOW HARD IS IT TO THAT YOU'RE GONNA HAVE TO GO IN THERE YEARS AND CHANGE
[01:00:01]
YOUR ASSOCIATEDBUT MY QUESTION IS, IS THAT SOMETHING THAT WOULD BE DONE ON OUR LEVEL MINE, BARRY, JEFF DWAYNE'S, OR IS THAT SOMETHING THAT'LL HAVE TO BE ADJUSTED BY IT DEPARTMENT? WE, WE, I'M GLAD YOU ASKED THAT QUESTION BECAUSE I THINK AS A COMPANY WHAT WE'VE DONE, YOU KNOW, WE'VE GONE TO DEMOS.
THIS IS A BIG GROUP, YOU KNOW, WE'VE DONE DEMOS ONSITE, OFFSITE, WE LISTEN TO WHAT FELLOWS LIKE YOU HAVE TO SAY, AND WE'VE GOT A SCREEN, I DON'T THINK YOU CAN SEE IT FROM WHERE YOU'RE SITTING, IT'S CALLED UPDATE RATES.
BECAUSE WHAT HAPPENS IS, HERE IT IS IN MARCH, WE'VE ENTERED EVERYTHING FOR JANUARY AND FEBRUARY, AND THEN WE SAY WE'RE GETTING A RETROACTIVE PAY RAISE OF, UH, 2%, RIGHT? OH CRUD.
NOW WE HAVE TO GO BACK AND CHANGE ALL OF THOSE RECORDS WE ENTERED.
WE HAVE A TOOL THAT DOES THAT FOR YOU.
OR MAYBE WE KNOW THAT HERE IT IS DECEMBER 30TH AND FOR NEXT YEAR EVERYBODY'S GETTING A DOLLAR AN HOUR RAISE.
WE WANT TO PUSH THAT DOLLAR AN HOUR RACE ACROSS TO EVERYBODY, WHETHER IT'S FOUR EMPLOYEES OR 44 OR 4 44 EMPLOYEES.
WE'VE GOT THIS TOOL HERE CALLED UPDATE RACE THAT LETS YOU DO THAT EXTRAORDINARILY EASILY, EITHER GOING FORWARD OR RETROACTIVELY DOING IT FROM MATERIALS OR EMPLOYEES OR EQUIPMENT.
SO, UM, IF YOU KNOW THAT ALL YOUR MOTOR GRADER RATES WENT FROM $75 AN HOUR TO 77 50 AN HOUR INSTEAD OF A HAND FOUR KI THOSE MOTOR GRADERS YOU CAN DO IN ONE FELL SWOOP, JUST KNOCK 'EM ALL OUT.
SO, UM, WE'VE HEARD THAT BEFORE.
WE'RE LIKE, OH, THEY'RE GONNA NEED THAT.
RIGHT? SO SOMEBODY TOLD US THAT WE NEED THAT AND WE'RE LIKE, HEY, THAT'S A PRETTY GOOD IDEA.
MAYBE WE SHOULD PUT THAT IN THE PROGRAM.
SO I'VE GOT A QUESTION ABOUT EMPLOYEE TURNOVER.
YOU HAVE TO KEEP THEM IN THERE TO KEEP THAT NAME ATTACHED TO THAT PARTICULAR, OR CAN YOU DELETE EMPLOYEES AS THEY LEAVE? BUT THE PROJECT CRAIG DUN ARE STILL THAT'S A, THAT'S A GREAT QUESTION AND THIS IS A, UH, A FLAW IN A LOT OF SYSTEMS THAT WE DON'T THANKFULLY HAVE.
YOU CAN SEE RIGHT HERE FOR MIKE CARD, ONE OF OUR EMPLOYEES HERE, HE'S GOT A RECORD ACTIVE CHECKBOX.
EVERY RECORD IN THE SYSTEM CAN BE EITHER ACTIVE OR INACTIVE BECAUSE EMPLOYEES COME AND GO.
VEHICLES ARE ARE BOUGHT AND SOLD, UH, MATERIALS ARE USED OR ABANDONED.
UM, SO WHEN MIKE HARDY RETIRES OR QUITS, OR IS FIRED OR WHATEVER, WE CAN, WE CAN MAKE HIM INACTIVE.
AND NOW HE WON'T APPEAR ON THAT DROPDOWN, THIS, BUT HE'LL STILL BE ON, BUT HE'S STILL IN THE SYSTEM.
THE WORK HE DID LAST MONTH, LAST YEAR, LAST DECADE, STILL IN THERE WITH HIS NAME ATTACHED TO IT.
IF WE ALLOWED YOU TO DELETE HIM, YOU WOULD RIP A HOLE IN THE DATABASE AND YOU'D BE LOOKING BACK AT A REPORT FROM LAST YEAR, LIKE, WHO DID THIS GRADING WORK FOR? US? WHO, WHO'S MANNING THE BACKHOE THAT DAY? THAT WAS SO, UH, THAT'S VERY IMPORTANT.
WE, WE CALL THAT REFERENTIAL INTEGRITY, BUT, UH, YOU DON'T NEED TO, YOU KNOW, BUST THAT OUT.
THE NEXT COCKTAIL PARTY YOU GO TO.
GOOD ANSWER, KIND OF REACTION.
BUT, YOU KNOW, HERE'S ANOTHER THING.
SO THE CUSTOMER MIGHT COME HERE NOT UNDERSTANDING LIKE THE INTRICACIES OF REFERENTIAL INTEGRITY, AND THEY'RE LIKE, OH YEAH, MIKE CARDY, HE QUIT, SO LET'S DELETE HIM.
ALRIGHT? AND I'LL SAY, YEAH, I'M GONNA DELETE IT.
YOU KNOW, IT'S GONNA SAY, YOU CAN'T, THERE'S NO ONE DELETED.
YOU SURE YOU WANT TO DELETE THIS GUY? I'M GONNA SAY YES.
IT'S GONNA SAY, WELL, I CAN'T DELETE HIM.
SO THE SOFTWARE ENFORCES THAT, WHICH IS REALLY IMPORTANT BECAUSE CUSTOMERS DON'T, THEY MIGHT FORGET, THEY MAY NOT UNDERSTAND THAT.
ANOTHER THING YOU MIGHT SAY, WELL, UM, YOU MIGHT SAY, WELL, WE DON'T WANT, WE DON'T WANT OUR USERS TO DELETE ANYTHING ANYWAY.
SO THERE'S USER POWERS THAT CAN BE ESTABLISHED, UH, THAT GIVE CERTAIN CUSTOMERS, LIKE, I'M LOGGED IN AS THIS ADMIN USER.
AND, UM, YOU CAN SEE THAT FOR EMPLOYEES.
I'VE GOT AD MODIFY AND DELETE POWER, SO I CAN BELIEVE WHOEVER I WANT.
BUT THE SOFTWARE, EVEN THOUGH I HAVE THAT POWER TURNED ON FOR MYSELF, THE SOFTWARE STILL ENFORCES THAT.
FORGIVE THE PHRASE THAT REFERENTIAL INTEGRITY RULE, BECAUSE WE DON'T WANT THAT WHOLE RANGE.
AND THAT THAT RULE APPLIES TO WHETHER IT'S A PICKUP TRUCK, HOT MIX, ASPHALT, EMPLOYEES, CONTRACTORS, TASKS, LOCATION, NEW NAME.
OKAY? SO WE, WE LOOKED AT THAT SERVICE REQUEST.
UM, THE SERVICE REQUEST AGAIN, UH, FOR A CITY ENVIRONMENT IN PARTICULAR.
BUT WE KNOW THE COUNTIES, UH, USE THESE EXTENSIVELY, UH, TO, TO MANAGE WHAT A LOT OF PEOPLE CALL A WORK ORDER.
BUT IT'S A DEMAND MAINTENANCE ITEM.
IT CAN BE TIED DIRECTLY TO ANY ONE OF YOUR ROADS OR BUILDINGS OR ASSETS.
UH, IT CAN BE USED AS A SORT OF A RECEIVER OF JOB COSTING INFORMATION AND, UM, VERY POWERFUL TOOL.
THEY CAN BE PRINTED, THEY CAN BE EMAILED.
YOU CAN HAVE DOCUMENTS LINKED TO THEM.
[01:05:02]
WE'VE GOT, UH, AN APPOINTMENT CALENDAR THAT YOU CAN, UH, ASSIGN THEM TO.I DON'T HAVE ANY SET UP RIGHT NOW, BUT, UM, YOU CAN PUT THINGS ON AN APPOINTMENT CALENDAR IF YOU'VE GOT METER READS THAT YOU'RE GONNA BE DOING, OR, UH, BACKFLOW METER, UH, INSPECTIONS OR WHATEVER THE CASE MAY BE.
SO YOU CAN PUT THESE ON AN APPOINTMENT CALENDAR AND, UH, WE'RE WORKING ON PUSHING THAT TO AN OUTLOOK CALENDAR AS WELL.
WE SHOULD HAVE THAT DONE SHORTLY.
UM, SO THERE'S, SO THE SERVICE REQUESTS TIE INTO THE JOB COST AND THAT TIE INTO THE ASSET MANAGEMENT AND ALL THE CORE DATA.
UH, THERE ARE VARIOUS TOOLS TO MANAGE THEM.
THERE'S ALSO A DASHBOARD THAT, UM, YOU CAN USE TO GIVE YOU SOME GRAPHICAL REPRESENTATION.
IT'S, UH, THE SCREEN RESOLUTION HAS MADE IT LOOK NOT AS GOOD AS THEY'RE SUPPOSED TO FILL IN THESE, THIS IS A WINDOWS 10 THING AT THIS SCREEN RESOLUTION.
BUT, UM, THESE CHARTS SHOULD LOOK NICER.
UM, DISAPPOINTING, UH, BETTER THE CURRENT SCREEN RESOLUTION, YOU'RE JUST NOT LOOKING THAT GREAT.
BUT IT'S A WAY FOR YOU TO VISUALLY SEE WHAT YOU'VE GOT OPEN AND CLOSED, PERHAPS, WHICH DEPARTMENT? I JUST WANNA SEE EVERYTHING IN ROAD AND BRIDGE.
AND THERE ARE THE VARIOUS ITEMS. UH, I'VE GOT ONE SIGN PROBLEM.
SEE, MY SCREEN IS CUT OFF AT THE BOTTOM BECAUSE OF THE SCREEN RESOLUTION, SO I CAN'T CHANGE MY TIMEFRAME RIGHT NOW.
SO YOU CAN SEE IT SAYS DATE RANGE FILTERING, BUT IT'S, IT'S CUT OFF.
IT'S, UM, ONE OF THOSE THINGS WHEN YOU CONNECT TO A PROJECTOR, UH, THEY, THEY HAVE NOT FIGURED OUT HOW TO PROJECT A HIGH QUALITY IMAGE USING HIGH RESOLUTION.
AND SO OUR SCREENS ARE DESIGNED TO FIT 1000 BY 700 AND THESE SCREENS PROJECTED A LOWER RESOLUTION THAN THAT.
SO WE'RE GETTING A LITTLE BIT OF, UH, LOSS OF FIDELITY
WE HAVE AN ANNUAL ROAD REPORT WHERE WE LIST THE ROADS, EVERY COVERTS, ET CETERA, ET CETERA.
WHAT WE WANT TO DO TO THEM THAT YEAR AND THE COST OF IT.
CAN IT DO SOMETHING LIKE THAT TOO? BECAUSE I HAVE TO MANUALLY DO THAT REPORT.
UM, IT PROBABLY CAN SUPPORT THAT ACTIVITY VERY WELL.
BUT DOING EXACTLY WHAT YOU JUST DESCRIBED, I WOULD SAY NO.
'CAUSE I'VE NEVER SEEN EXACTLY WHAT YOU WANT.
UM, BUT WHO IN KANSAS ASKED US ABOUT THAT? WAS IT RILEY COUNTY, KANSAS OR GOT THEIR, THEIR, THEY, THEY USED THE SAME TERM.
WE HAVE TO DO OUR ROAD REPORT, OUR ANNUAL ROAD REPORT, AND, UM, RENO, WAS IT RENO? AND, AND IT IS LIKE, WELL, WE DON'T DO IT EXACTLY LIKE THAT, BUT WE HAVE A LOT OF, WE HAVE REPORTS THAT YOU CAN USE TO SUPPORT THAT ACTIVITY.
UM, AND IT'S SIMILAR TO THE FEMA, UH, FORM HERE.
IF WE KNOW THE FORMAT PRECISELY THAT YOU'RE LOOKING FOR, WE COULD POTENTIALLY BUILD THAT REPORT FOR YOU.
UM, WE'VE DONE THAT IN A NUMBER OF CASES FOR CUSTOMERS.
'CAUSE THEY'VE, THEY'VE EITHER MADE IT SORT OF PART OF THE DEAL, IT'S MANDATORY, OR THEY'VE SAID MAYBE WE CAN GO TO THEIR OFFICE AND SHOW THEM.
HUH? DO MY SKIING COME HOME? VERY, I BET IT IS.
SO, UM, THEY, THEIR OWN REPORT, BUT THEY USED OUR PRODUCT BECAUSE ALL KANSAS COUNTIES HAVE A ROAD REPORT.
SO THAT'S WHAT I, THE COUNTY REQUIREMENT.
BUT, BUT THEY, THEY GOT ALL THE DATA OUT OF OURS AND THEN THEY REPORT, REPORT PRODUCE IT, BECAUSE YOU CAN EXPORT THE DATA OUT OF OUR SYSTEM.
SO YOU CAN EXPORT IT INTO A SPREADSHEET OR, OR A PDF OR ANYTHING.
SEE THAT MIGHT BE, YEAH, SO THEY EXPORT IT, THEY JUST EXPORT THE RAW DATA AND THEN THEY IMPORT IT ONTO THEIR ON END INTO THEIR PROGRAM AND THEN RUN THE PRINT REPORT OR ACTUALLY PRODUCE A PDF DF AND SEND IT IN TO THE STATE.
SO, YOU KNOW, WHEN WE GOT, WE GOT GOT A LITTLE EARLIER, A LITTLE EARLY FOR THE MEETING AND, YOU KNOW, EXTENSIVELY PREPPED THE COMPUTER TO SMOOTH DEMO.
UH, BUT WE DROVE AROUND AND WE NOTICED, UM, WE NOTICED THAT, UH, THERE'S ROAD OVERLAY PROJECT.
I DON'T KNOW WHAT DIRECTION IT'S BECAUSE THE SUN IS NOT, UH, SO, UH, I WAS, WE WERE IN THE CAR WONDERING WAS THAT A STATE PROJECT OR IF THAT'S A COUNTY PROJECT.
EITHER WAY, PROJECTS ARE SOMETHING THAT CITIES AND COUNTIES RUN ALL THE TIME.
WE'VE GOT A VERY NICE FEATURE IN THE PROJECT AREA.
LEMME JUST FIND, UM, THERE'S A WAY
[01:10:01]
TO DOCUMENT THE PROJECT TO EXPLAIN WHAT IT'S FOR, WHAT IT'S, UH, SUPPOSED TO DO.UM, WE CAN PUT ESTIMATES ON THE PROJECT AND CREATE ESTIMATE ACTIVITY RECORDS THAT LETS YOU SORT OF PROJECT WHAT THE PROJECT COSTS MIGHT BE.
THAT'S KIND OF WHAT OUR, AND THEN AS REAL ACTIVITIES ARE RECORDED, AGAIN, LET ME GO BACK.
WE SHOWED A CREW ACTIVITY, BUT LET ME JUST SHOW A DAILY ACTIVITY TO GIVE YOU AN IDEA OF HOW MANY PEOPLE DOCUMENT WORK THIS ACTIVITY FORM.
THERE'S A LOT OF FIELDS ON IT, BUT WHEN I CLICK ADD NEW, IT'S VERY NICE THAT THERE'S YELLOW, MANDATORY RED, OPTIONAL.
SO I TYPE IN A LETTER A FOR NET ARCATA.
LET'S SAY HE WORKED YESTERDAY.
HE WAS ON BAIT LANE AND HE DID THE TASK.
HE DID SOME PAINTING THERE OR MATERIAL HAULING.
I, I CLICKED MY LITTLE H SO HE WAS HAULING MATERIALS THERE.
AND UM, YOU KNOW, HE USED THAT CATERPILLAR SOMETHING.
THERE'S A WHOLE SERIES OF VEHICLES IN HERE.
HE USED THAT FOUR 9,000 TRUCK.
SO THIS, THIS ACTIVITY RECORD CAN BE TIED TO A PROJECT DOWN HERE ON THE LOWER LEFT IS MY LINKAGE TO A PROJECT.
AND I'VE GOT A LIST OF MY OPEN PROJECTS HERE.
AND WHEN I MAKE THAT SELECTION THERE, THAT 80 IS, THAT $318 AND CHANGE IS NOW TIED TO THAT PROJECT.
SO I CAN, I CAN NOT ONLY CREATE ESTIMATES FOR MY PROJECT USING THIS VERY SAME ACTIVITY FORM.
SO YOU DON'T HAVE TO LEARN A NEW TOOL, YOU'LL JUST USE THE ACTIVITY FORM TO CREATE YOUR ESTIMATES.
AND THEN AS REAL WORK IS PERFORMED, YOU'LL CREATE ACTUAL ACTIVITY RECORDS LIKE THIS ONE I JUST DID HERE.
AND THERE'S WAYS TO COMPARE THEM.
YOU KNOW, NORMALLY WE USE GO TO MEETINGS.
I'M LOOKING AROUND FOR MY PEN.
I DON'T HAVE ONE TO DRAW ON THE SCREEN, BUT I'VE GOT MY ACTUAL COST TO DATE, MY, MY ESTIMATE OVER HERE.
AND IT'S SHOWING ME, UH, MY VARIOUS VARIANCES, UH, UM, $12,700 UNDER BUDGET.
SO, UM, THERE'S WAYS TO COMPARE THEM.
THERE'S ALSO, UH, WAYS TO RUN REPORTS ON PROJECTS THAT ARE VERY, VERY HELPFUL.
SO, FOR EXAMPLE, MAYBE I'LL RUN A, A TASK, UH, COST SUMMARY REPORT.
AND THEN I'VE GOT ONE THAT'S PARTICULARLY CULVERT PIPE RECONSTRUCTION PROJECT.
AND IF I RUN THAT REPORT THERE, YOU KNOW, IT'S BREAKING DOWN THE, MY PROJECT ACTIVITIES AND ALL OF THEIR COSTS IN, YOU KNOW, ON A TASK BY TASK BASIS.
THAT'S, THAT'S WHAT THESE SEVEN WE'RE TELLING YOU.
HOW MANY, THERE ARE SEVEN TASKS WENT INTO THIS PROJECT AND HERE ARE THE VARIOUS COSTS.
OUR LABOR COSTS IS ABOUT 13,000 ARE OUTSIDE CONTRACTORS CHARGES ALMOST 40,000.
HERE'S THE, WHAT WE CALL THE COMMISSIONERS.
FORGIVE ME, BUT WE'VE USED THE TERM POLITICIAN FRIENDLY PIE CHARTS HERE.
SO, UM, YOU KNOW, A REPORT LIKE THIS, GOING TO A MEETING, A CITY COUNCIL MEETING OR A COUNTY COMMISSIONER MEETING WITH A REPORT LIKE THIS WILL REALLY SHOW THAT YOU'VE GOT YOUR ACT TOGETHER.
UH, VERY POWERFUL COMMUNICATION TOOL.
AND TO GET IT, YOU KNOW, I MEAN A LITTLE BIT OF TRAINING, YOU'LL BE ALMOST AS BAD AS ME AT OPERATING THE SOFTWARE.
UM, YOU'LL JUST MAKE A REPORT SELECTION, A LITTLE BIT OF FILTERING, PERHAPS SOME DATE RATE FILTERING AS WELL, IF APPROPRIATE.
CLICK THE OKAY BUTTON AND UH, VOILA, YOUR REPORT IS THERE.
AND, AND AS BOB WAS ALLUDING TO EARLIER, REPORTS CAN BE EXPORTED TO EXCEL OR PDF.
AND ONCE THEY'RE IN THOSE OTHER FORMATS, IT'S VERY EASY TO EMAIL THEM OR PRINT THEM OR, OR DO WHATEVER CAN DO WITH THEM.
YOU CAN ALSO PRINT IT TO ANY NUMBER OF PRINTERS ON YOUR NETWORK.
UM, SO YOU'VE GOT A WIDE VARIETY OF METHODS TO GET THIS REPORT OFF YOUR SCREEN AND INTO SOMEBODY'S HANDS.
AND THERE'S MORE THAN 500 REPORTS.
SO WE'RE REALLY SHOWING YOU JUST A LITTLE THIN THING.
THERE'S MORE THAN 500 REPORTS ALREADY WRITTEN IN THE, IN THE, AND ALMOST ALL WERE REQUESTED BY A CUSTOMER.
AND THEN THERE'S A REPORT CATALOG THAT'S BUILT IN.
SO IT HELPS YOU ZERO IN ON WHAT YOU'RE, SO YES, WHAT YOU'RE LOOKING FOR, WHAT REPORT YOU WANT.
AND THEN THERE'S EVEN A TUTORIAL TO SHOW YOU EXACTLY WHICH BUTTONS TO PUSH FOR THAT PARTICULAR REPORT, UH, UH, BUILT IN AS WELL FROM THE HELP SIDE.
SO, YOU KNOW, HE, SHOWING THAT PUT THE WRONG ONE, BUT IT'S, UH, YOU KNOW, WE'VE GOT A LOT OF, UM, YOU KNOW, ONLINE LINKS AND, AND VIDEOS AND TOOL TIPS.
OUR SUPPORT WEBSITE IS EVERY DAY GETTING FURTHER AND FURTHER FLESHED OUT WITH VARIOUS, UH, TOOLS THAT MAKE USING THE PROGRAM EASIER AND EASIER FOR YOU FOLKS
[01:15:01]
TO FIGURE IT OUT.SO, UH, BUT WE'RE CONSTANTLY ADDING REPORTS.
'CAUSE WE, WE WE'RE ADDING CUSTOMERS RIGHT UP TO NEARLY 600 AND, AND SOMEBODY CALLS UP.
SO WE'RE, WE'RE TRYING AS MUCH AS POSSIBLE TO ACCOMMODATE THE CUSTOMER'S NEEDS WITHOUT HAVING HAVE THEM THEMSELVES OR SOMEBODY IN IT HAVE TO WRITE A REPORT FOR THEM.
SO OUR CUSTOMER'S SUPPORT TEAM, IF YOU DON'T FIND A REPORT, THEN YOU CALL US UP.
AND MORE THAN LIKELY, 99% OF THE TIME, I WOULD SAY SOMEONE ON THE CUSTOMER SUPPORT TEAM WILL SAY, OKAY, WELL, WE'LL, WE'LL, WE'LL CREATE THAT REPORT FOR YOU EXACTLY THE WAY YOU WANT IT.
'CAUSE OFTENTIMES, YOU KNOW, CITY COUNCIL WILL WANT, WE WANT THAT DATA IN THE FIRST COLUMN, RIGHT? AND THEY'LL COMPLAIN THAT I DON'T WANT IT, YOU KNOW, IT'S DOWN AT THE END.
I WANT IT, I WANT A TOTAL COST TO BEGIN WITH INSTEAD TO END WITH.
SO WE'LL REORDER THE REPORT AND, AND CREATE IT AND PUT IT IN THE REPORT CAP LOG.
AND, AND MAYBE YOU MAY BE THE ONLY CLIENT THAT USES THAT REPORT OUT OF THE FIVE OR 600 CLIENTS WE HAVE.
WE TRY TO CUSTOMIZE THE PRODUCT, YOU KNOW, THE REPORTING TO MAKE SURE EVERYBODY GETS WHAT THEY NEED.
BECAUSE AT THE END OF THE DAY, THE REPORTING IS, IS REALLY THE, THE STRENGTH OF THE SYSTEM, RIGHT? BEING ABLE TO PUSH A FEW BUTTONS AND ANSWER A QUESTION RATHER THAN GOING BACK THROUGH BOXES.
BECAUSE WE'VE BEEN TO MANY PEOPLE'S OFFICES WHERE THEY SAY WE HAVE A RECORD OF ALL THE SAME QUESTION EVER DONE.
THEY'RE IN THOSE THREE BOXES IN THAT VERTICAL FILE, RIGHT? AND IF WE WANT TO KNOW HOW MUCH MONEY WE SPENT, I'VE GOTTA GO THROUGH AND IT TAKES ME, ME EIGHT HOURS FIRST TO FIND WHAT I NEED.
IT TAKES ME EIGHT HOURS OF WORK TO ANSWER THE CITY COUNCIL'S QUESTION OR COUNTY COMMISSIONERS, RIGHT? INSTEAD, INSTEAD OF THREE PUSHES THE BUTTON.
PLUS, UH, IN A LOT OF CASES WE HAVE COMMISSIONERS THEMSELVES WHO WANT TO DO REPORTING THEMSELVES.
THEY WANT TO KEEP UP BECAUSE WHEN, YOU KNOW, MRS. SMITH CALLS FOR THE 54 TIMES AND STARTS COMPLAINING, COMPLAINING THAT YOU HAVE TO A POLITICAL LEADER, YEAH.
THEN THEY WANT TO BE ABLE TO EITHER THEMSELVES OR THEIR ADMIN TO SAY, YOU KNOW, MR. SMITH, WE'VE BEEN OUT 54 TIMES, RIGHT? RIGHT.
AND WE'VE DONE THIS MUCH WORK ON FARM ROAD 3 0 2, IT'S NOT NOTHING, IT'S 18,000 LAST YEAR.
SO THOSE ARE THE KINDS OF QUESTIONS THAT, THAT, THAT ARE AGGRAVATING AND TAKE A LOT OF, UH, A LOT OF ADMINISTRATIVE TIME.
AND, AND YOU'RE NOT REALLY GETTING ANY WORK DONE
CAN YOU PUT IN THERE SOMETHING FOR UTILIZING LIKE THE DUMP TRUCKS FOR RESCUE AND THE FLOOD SITUATION? YES, YOU CAN.
WHEN WE LOOK AT, WE, YOU KNOW, WE DON'T USUALLY DEMONSTRATE TASKS, BUT WE'VE GOT A SIMILAR SCREEN.
YOU KNOW, HERE'S A LIST OF ALL THE TASKS.
WE HAVE 162 OF THEM IN THE SYSTEM, BUT THERE'S A CONCEPT OF A TASK TYPE BY SORT BY TASK TYPE BY CLICKING.
SO I'VE GOT A NUMBER OF ADMINISTRATIVE TASK TYPES.
I'VE GOT FACILITY MAINTENANCE, TASK TYPES, GENERAL MAINTENANCE, PARKS AND GROUNDS.
UM, AND THEN BASED ON, YOU KNOW, OVER TIME AS WE ENTER ACTIVITY RECORDS, I MIGHT WANNA RUN A WRONG SCREEN.
I MIGHT WANNA RUN A TASK COST REPORT BASED ON TASK TYPE EVERYTHING LAST YEAR.
SO, UH, A TASK TYPE SELECTION, UH, GATE FILTERING, AND LET'S SEE WHAT THIS REPORT LOOKS LIKE.
IT'S, IT'S, IT'S SEGREGATING ALL OF OUR ACTIVITIES, SUMMARIZING ALL OUR ACTIVITY, UH, BY TASK TYPE.
UH, SO IT'S SHOWING ME AT A HIGH LEVEL THAT, YOU KNOW, STREET MAINTENANCE, WE'VE SPENT 3,200 HOURS ON FACILITIES MAINTENANCE, ONLY 7 47 HOURS.
MAYBE I WANT TO DRILL INTO THAT.
I'M GONNA SAY, OKAY, WELL I DON'T WANNA RUN THAT REPORT.
YOU KNOW, GIMME A LOCATION SUMMARY, UH, REPORT OR GIMME A, A SUMMARY REPORT AND WHERE THE TASK TYPE IS FACILITY MAINTENANCE.
AND I'M GOING TO GET A DIFFERENT LISTING HERE.
SO THERE'S THE VARIOUS TASKS WE PERFORM IN THAT GROUP.
WE WERE ABLE TO DRILL DOWN WITH JUST A COUPLE OF MOUSE CLICKS.
IS THAT WHAT YOU WERE DRIVING AT? MM-HMM
SO I WASN'T SURE, YOU KNOW, IN THE FLOOD SITUATION, WE NEED TO RESCUE, WE NEED HIGH PROFILE VEHICLES.
THE FASTEST AND QUICKEST ARE DUMP TRUCKS.
YOU GRAB A LADDER AND SOME LIVE TICKETS AND YOU SEND THEM OUT THERE TO DRIVE AROUND THE ROAD AND GET PEOPLE OUT.
WHICH IS A, A REIMBURSABLE EXPENSE FROM PAYMENT.
SO YOU COULD, YOU CAN, YOU CAN STRUCTURE YOUR TASKS AND THAT'S ONE OF THE THINGS WE'VE PROBABLY WORKED WITH YOU ON IS UNDERSTANDING THAT SCENARIO AND MAKING CERTAIN THAT YOU'VE GOT DATA THAT WILL SUPPORT THAT AND THE REPORTING YOU NEED AFTER THE FACT.
UM, AND, AND YOU DON'T NEED TO HAVE THAT ON DAY ONE.
THAT CAN BE, YOU COULD DO THAT LITERALLY AFTER THE FACT.
YOU NEED TO CONSTRUCT THIS DATA.
YOU NEED TO PUT ALL THESE ACTIVITY RECORDS IN WITH THIS PARTICULAR TASK SO
[01:20:01]
THAT WE CAN EASILY PLUCK THEM OUT.BUT, BUT THE PROJECT IS THE SAVING GRACE.
WE, ALL OF OUR CUSTOMERS, UM, NOT ALL OF THEM, BUT MANY OF THEM WHO HAVE RUN INTO NATURAL DISASTERS WITH ONE SORT OR THE OTHER, HAVE USED PROJECT REPORTING TO, UH, HELP THEM PUT A, PUT THEIR ARMS AROUND ALL THESE ACTIVITIES THAT WENT INTO THE CLEANUP AND THE RECOVERY.
AND WE'VE GOT SOME REPORTS FOR THAT AS WELL.
WELL, WHY THEY USES FOR THE, FOR THE FLOOD, I GUESS A COUPLE YEARS AGO, FLOOD OR HAILSTORM, THE HAIL STORE.
WHEN WE WERE THERE, HE WAS TALKING ABOUT HOW THEY, UH, HAD USED THIS WAS THE HAILSTORM AND HOW MUCH DAMAGE THEY HAD.
AND THEY DID ALL THE, ALL THE REPORTING.
THEY, THEY, THEY CREATED PROJECTS FOR DIFFERENT BUILDINGS.
'CAUSE THEY HAD A LOT OF THEIR OWN FACILITIES DAMAGED.
UH, AND I THINK THEY HAD EVEN RELOCATED THEIR PUBLIC WORKS PEOPLE OUT OF THEIR, THEIR BUILDING WAS DESTROYED.
AND SO THEY CREATED PROJECTS FOR EACH ONE OF THOSE BUILDINGS AND THEN TRACKED ALL THE TASK AND ALL THE WORK AND ALL THE PEOPLE AND ALL THE EQUIPMENT THAT WENT IN, UH, UH, AND, AND ALL THE COST, UH, FOR THAT HAILSTORM, I WAS THINKING RE IT WAS A HAILSTORM BECAUSE THERE WAS STILL SOME DAMAGE THERE WHEN I WAS THERE IN NOVEMBER.
SOME, SOME BELT STILL HAD TARPS ON THE ROOF AND THAT KIND OF STUFF.
UH, YEAH, WE, SO THIS COMPREHENSIVE DETAIL, UH, THE SCREEN RE IS KIND OF MESSING WITH IT.
BUT, UM, WE'RE SHOWING HERE THAT ON THE LEFT HAND COLUMN, THE LABOR AND THEN IF THERE WAS EQUIPMENT USED, AND THEN IF THERE'S EQUIP MATERIALS USED OR ANY CONTRACTORS USED, UH, THESE THINGS ARE ALL BEING BROKEN OUT.
WE CAN SEE OUR EMPLOYEE NUMBER 8 0 1, MR. BENTON WORKED FOR AN HOUR AND CHANGED, UH, DOING THIS WORK.
SO, YOU KNOW, THIS COMPREHENSIVE DETAIL, I CAN'T SEE THAT FORM FROM HERE, BUT, UM, IT, IT, UM, IT'S GOT SOME SIMILARITIES.
THE OTHER THING FROM A FEMA PERSPECTIVE IS THAT IF WE LOOK AT, FOR EXAMPLE, UM, OUR EQUIPMENT SCREEN, AGAIN, LET'S LOOK AT OUR MOTOR GRADERS AS AN EXAMPLE.
WE NOT ONLY HAVE, UM, AN INTERNAL RATE.
SO, YOU KNOW, WHEN WE, WHEN WE USE THIS VEHICLE, IT'S $43 AN HOUR.
UH, WE ALSO HAVE A FEMA RATE, WHICH THEY'RE THE SAME IN THIS CASE, BUT THEY DON'T HAVE TO BE THE SAME.
BUT THERE'S ALSO A FEMA IDENTIFIER.
OKAY? THE FEMA GUY DOESN'T KNOW FROM ADAM WHAT UNIT TWO 30 IS, BUT HE KNOWS PERHAPS THAT, UH, 88 32 IS A MOTIVATOR.
SO ALL OF OUR SCREENS HAVE A FEMA CODE THAT CAN BE SUBSTITUTED WHEN WE RUN REPORTS SO THAT WHEN WE'RE GIVING REPORTS TO OUR FEMA REP, WE'RE SPEAKING THE RIGHT LANGUAGE.
SO AGAIN, THAT'S NOT SOMETHING WE THOUGHT OF.
THAT'S SOMETHING YOU SUGGESTED THAT OTHER MEETING NOT IDEA, LIKE THIS GREAT IDEA
IT WAS LIKE, WE THINK OF THIS.
SO, UM, OKAY, SO THERE'S, I JUST WANT IT FROM A REPORTING PERSPECTIVE.
YOU KNOW, THERE'S A WHOLE VARIETY OF REPORTS.
UH, THE SCREENS ARE VERY SIMILAR.
THERE'S RADIO BUTTONS TO MAKE THE SELECTION AND THEN FILTERING OF A WIDE VARIETY OF WAYS.
UH, MOST PROMINENT PERHAPS IS THE DATE FILTERING.
PEOPLE WANT TO LOOK AT THINGS THROUGH A CERTAIN DATE RANGE.
WE'VE TRIED TO MAKE THAT EASY.
SO WE'RE ABOUT AN HOUR AND A HALF.
DO YOU WANNA, UH, LOOK AT SOME FLEET STUFF? UH, UH, WE WERE THINKING ABOUT TWO HOURS.
IS THAT OKAY IF WE GOT ABOUT ANOTHER HALF HOUR? CAN Y'ALL HANDLE THAT? ABOUT 1130 I THINK IS WHAT YEAH, PROBABLY.
SO I'VE GOT SOMETHING ELSE AT NOON.
SO, BUT I THINK WE WANT TO, WE WANT TO COVER FLEET AND MAYBE, MAYBE HIT THE MAPPING BEFORE THAT.
AND, AND IF YOU HAVE MAPPING QUESTIONS, WE CAN ANSWER THOSE.
IF YOU HAVE TECHNICAL STUFF ON GIS WE'LL WE COULD CHANGE, WE'LL GO OFFLINE WITH THAT.
BUT WE'D LIKE TO SHOW YOU, YOU KNOW, HOW ALL THIS RELATES TO A MAP.
YEAH, THERE'S, UM, AND IF WE NEED TO STAY LONGER, I MEAN, SOME PEOPLE HAVE TO GO, WE'LL, WE'VE SCHEDULE THIS AFTERNOON.
SO ON THE FLEET SIDE, UM, THERE'S A, A LOT OF OPTIONS HERE.
UH, THERE'S FLEET SERVICE REQUESTS, WHICH CAN BE SUBMITTED THROUGH A WEBSITE OR NOT.
THEY CAN BE ENTERED INTO A FORM THAT IS VERY SIMILAR IN LOOK AND FIELD TO THE FORMS WE'VE SEEN BEFORE.
THE IDEA HERE IS THAT ORDERLY MANAGEMENT OF, OF VEHICLE SERVICE AND REPAIR.
UM, SO YOU MIGHT HAVE SHERIFF'S OFFICERS THAT WOULD GO TO A CONSOLE AND THEY'D ENTER THIS RECORD SAYING, HEY, MY, YOU KNOW, MY, MY TAHOE HAS GOT A BROKEN DOOR HANDLE AND THE TIRE'S FLAT AND THE LEFT BRAKE LIGHT DOESN'T WORK.
I'M THINKING OF MY OWN CAR RIGHT NOW,
[01:25:01]
COULD SUBMIT THAT AND THEN THE FLEET SERVICE MANAGER WHEN HE GETS IN THE MORNING CAN REVIEW THESE AND THEN SCHEDULE THEM FOR REPAIR.HE CAN ALSO DIRECTLY CONVERT, UH, A FLEET SERVICE REQUEST INTO A FLEET VIRTUAL.
WE'LL GET TO THAT IN A MOMENT.
THERE ARE FLEET WORK ORDERS AND THE FLEET WORK ORDERS ARE WHERE WE DOCUMENT ALL THE WORK, ALL THE LABOR PARTS, MATERIALS THAT WENT INTO REPAIRING A VEHICLE.
WE'LL DOCUMENT THE PM ITEM THAT WAS SERVICED IF ONE WAS SERVICED.
UH, WE CAN DOCUMENT WHETHER IT'S AN INSIDE COUNTY OR CITY EMPLOYEE DOING THE WORK OR IT'S AN OUTSIDE VENDOR OR DEALER DOING THE WORK.
WE CAN DOCUMENT THE ODOMETER, READING THE DATES, THE STATUS, A WIDE VARIETY OF I ITEMS TO HELP MANAGE VEHICLE REPAIRS.
WE'LL GET BACK THIS IN A SECOND TOO, BUT HERE AGAIN, WE'VE GOT OUR, OUR VEHICLE INVENTORY.
IT'S THE SAME VEHICLE INVENTORY WE SAW OVER HERE.
SO IF I GO TO EQUIPMENT, IT BREAKS OUT INTO THESE SUB SUBTYPES.
AND THE SAME IS TRUE OVER HERE.
SO I COULD EASILY FIND, WE WENT TO THE BIG A PWA SHOW, GUESS IT WAS IN ARIZONA, UH, THE SUMMER.
AND, UH, GUY'S LIKE, OH MY GOD, YOU CAN TELL ME I'VE GOT 41 PICKUPS.
HE STILL HASN'T BOUGHT THE PROGRAM YET, BUT, UM, WE'RE STILL WORKING ON IT.
UM, THERE'S THE FUEL AND OTER LOG THAT LETS US INTEGRATE TO A FUELING SYSTEM.
YOU MENTIONED YOU HAVE FUEL MAN.
SO AS AN EXAMPLE, UM, I CAN JUST BRING UP THE SCREEN, CLICK THE IMPORT BUTTON AND IT LOOKS LIKE I WAS DOING SOMETHING FOR THE YELLOWSTONE ACADEMY ON IT BEFORE.
BUT LET'S JUST GO TO MY C DRAW.
I THINK I'VE GOT MYSELF, IF THERE'S WHAT WE DO.
SO YOU MASTER 16, YOU KNOW, ONCE I, I WANT TO HAVE THAT TEED UP NIGHT.
DIDN'T GET THAT DONE, BUT, UH, DIDN'T REPORT ANY FOR SOME REASON.
SO IT'S TELLING US WHY DUPLICATE TRANSACTIONS.
SO THAT, THAT'S KIND OF A GOOD THING TO DEMONSTRATE.
IT WON'T LET US IMPORT DUPLICATES, WHICH IS, UH, SOMETHING THAT WE DON'T WANT TO INTRODUCE, BUT, BUT FINDING YOUR FILE, GETTING THE EXPORT OUT OF A FUEL MASTER OR A PETRO VAN IS, IS RATHER SIMPLE.
DOING THE IMPORT HAPPENS RATHER AUTOMATICALLY.
AND NOW YOU'VE GOT ACCURATE ODOMETER READINGS.
AND TO DRIVE YOUR PM SCHEDULE, YOU COULD ALSO HAVE AT YOUR FINGERTIPS A WHOLE SERIES OF FUELING REPORTS.
SO I MIGHT WANT TO RUN SOME, PERHAPS A SUMMARY, A LISTING GROUPED BY DEPARTMENT THAT OWNS THE VEHICLE.
AND, UH, LET'S JUST CLEAR OUT THE DATES AND IT'S GOING TO GIVE ME INFORMATION ABOUT WHICH DEPARTMENTS HAVE CONSUMED FUEL AND IN WHAT QUANTITIES AND COSTS.
SO JUST BY IMPORTING THOSE TRANSACTIONS, WHICH IS JUST A COUPLE OF MOUSE CLICKS, WE'VE GOT ALL THIS DATA ANALYSIS CAPABILITY AT OUR FINGERTIPS.
SO
WE'VE GOT A PM SCHEDULE, SO YOU CAN SET UP PM ITEMS. SO I'VE GOT A LUBE OIL AND FILTER.
THAT PM ITEM IS TIED TO 162 OF MY VEHICLES.
SOME ARE DONE AT 3000 MILES, BUT SOME ARE DONE AT DIFFERENT INTERVALS.
BUT ONCE A DEFAULT IS ESTABLISHED FOR A PM ITEM, IT CAN BE MODIFIED TO BETTER SUIT THE VEHICLE.
SO YOU CAN SEE FOR THIS FORD FOCUS, WE DO THIS BLUE OIL AND FILTER EVERY 6,000 MILES.
FOR THIS FREIGHTLINER, WE DO IT EVERY 500 HOURS.
AND FOR THIS, UH, GMC SIERRA, WE DO IT EVERY 3000 MILES.
SO I CAN MODIFY THAT INTERVAL ESTABLISHED LINK TO MY VEHICLES.
SO LET ME JUST RUN THAT FOR THE MONTH OF MARCH.
AND I WANT TO RUN THAT ON MY PICKUP TRUCKS FOR THE PM ITEM.
LET'S JUST PICK LU OIL AND FILTER FOR FUN.
AND I CLICK THE GENERATE LIST BUTTON AT THE BOTTOM AND IT RUNS THROUGH ALL OF MY VEHICLE INVENTORY, ALL OF MY MAINTENANCE HISTORY, ALL OF MY ODOMETER LOGS.
AND IT FOUND THAT WE'VE GOT 36 VEHICLES THAT ARE OVERDUE FOR SERVICE.
AND AT THIS POINT, I CAN, UH, EMAIL NOTIFICATIONS TO THE OWNERS.
I CAN CREATE WORK ORDERS DIRECTLY FROM HERE, UH,
[01:30:01]
THAT WILL LOOK AT THE OVERDUE LIST, THAT THE PM SCHEDULE PRODUCE, IT AUTOMATICALLY CREATE WORK ORDERS FOR ME.I'LL JUST CREATE ONE, THE SINGLE WORK ORDER FOR THE SELECTED ITEMS. THAT'S THE MOMENT.
WE BLACK TRIANGLE HERE IN THE UPPER LEFT, BUT YOU PROBABLY CAN'T SEE ANYWAY.
SO IT'S CREATING THAT FLEET WORK ORDER FOR ME.
AND IF I CLOSE THAT AND JUST COME OVER HERE TO MY FLEET WORK ORDERS.
THERE'S THAT FLEET WORK ORDER THAT WAS CREATED FOR ME AND IT'S ALREADY SET UP WITH PM ITEM A, PERHAPS I WANT TO CLICK THE EDIT BUTTON.
AND I'M GONNA SAY, WELL, OUR CURRENT ODOMETER IS 25,000 MILES.
AND I'M GOING TO ADD TO THIS THAT OUR MECHANIC NET ARCATA, YOU KNOW, SPENT TWO HOURS AND USED, YOU KNOW, USED THAT BOSCH WALKER BLADE AND USED ONE OF THOSE.
AND, UM, I'LL PICK MY KIT, MY PART KIT HERE, HERE, CHANGE KIT TYPE, WELL PUT HAVE IN THERE MY, MY OIL CHANGE KIT.
THERE'S THIS CONCEPT OF YOU CAN SELECT I, I'VE GLOSSED OVER SOME DETAILS HERE.
I CAN SELECT FOR MY PARTS INVENTORY, ANY PART EITHER NUMERICALLY OR ALPHABETICALLY.
BUT WE ALSO HAVE THE CONCEPT OF A KIT WHERE I CAN AGGREGATE CERTAIN PARTS INTO A KIT SO THAT IT MAKES THE DATA ENTRY PROCESS FASTER, EASIER, AND MORE ACCURATE.
SO WHEN I MAKE THIS ONE SELECTION FOR THE OIL CHANGE KIT THERE, IT EXPANDS THAT ONE ITEM INTO THE FOUR CONSTITUENT PARTS OF THAT KIT.
SO IT PREVENTS ME FROM FORGETTING SOMETHING.
IT PREVENTS ME FROM GETTING THE QUANTITIES WRONG.
THE KIT IS ALREADY STAGED FOR ME, AND I JUST SELECT IT.
I CAN REMOVE, MAYBE I, I'VE ALREADY PUT A B ICON WIPER BLADE ON.
SO LET ME GET RID OF THIS 51 20 WIPER BLADE AND I'LL JUST CLICK THE LEAP LINE ITEM AT THE BOTTOM.
AND IT'S REMOVED IT FROM THIS INSTANCE OF USE.
IT HASN'T ALTERED THE KIT, BUT JUST THIS INSTANCE OF USE, IT'S BEEN CHANGED.
AND I'LL CLICK THE SAVE BUTTON AND ALL THOSE PARTS GO IN MY WORK ORDER AND UH, I CAN CLICK SAVE TO THAT AS WELL.
AND THE COST OF DOING THIS WORK, THE LABOR $19 AND THE PARTS ABOUT 50, THAT 69 70 HAS BEEN TIED AUTOMATICALLY TO THAT CHEVY 2,500.
AND IF I WERE TO CLICK ON THAT HYPERLINK, OOPS, DOUBLE CLICK IT INSTEAD.
UM, THIS VEHICLE RECORD HAS BEEN AUTOMATICALLY UPDATED WITH THAT PARTICULAR FLEET WORK ORDER NUMBER 12,892.
SO THE SORT OF, UH, THE WAY THE DATA SPREADS OUT AUTOMATICALLY THROUGH THE SYSTEM AND HOW IT CAN BE CROSS-REFERENCED IS AUTOMATIC AND VERY POWERFUL.
OKAY, WHAT IF WE DON'T ANY PARTS? THAT'S A GREAT QUESTION.
A LOT OF AGENCIES DON'T STOP PARTS.
EVERYTHING COMES FROM CARQUEST OR NAPA OR O'REILLY.
SO IF I'M, LET'S JUST GO BACK TO THIS WORK ORDER.
I'M JUST GONNA CLICK EDIT AND I FORGOT TO PUT A PART ON THERE.
SO I'LL DOUBLE CLICK ON THAT ROW AND IT BRINGS IT UP FOR ME.
AND THE PART IS CALLED THE KAUFMAN, UH, COUNTY PART.
AND, UM, I USED ONE OF THOSE AND THEY WERE $55 AND 23 CENTS.
I CAN JUST TYPE IT IN RIGHT HERE.
EXACTLY WHAT IT'S, AND UM, SO WE CALL THIS ADDING PARTS ON THE FLY, OKAY? AND IN OUR PARTS INVENTORY, YOU CAN SEE IT.
I HAVE A, WE HAVE A MORE ELABORATE VERSION OF THIS WHERE YOU CAN ENTER THE, THE VENDOR AND THE PO AND THIS IS THE ABBREVIATED VERSION OF THIS ON THE FLY ENTRY.
BUT YOU'LL SEE THAT IT'S, IT'S, IT'S ASKING YOU, DO YOU WANT THIS TO GO IN AS NONSTOP OR STOP, OKAY? SO WE'VE GOT A SEPARATOR IN OUR PARTS INVENTORY THAT SAYS, OKAY, ALL THESE PARTS, THESE 37 ITEMS OF STOCK, THESE 13,240 ITEMS ARE NONSTOP.
WHAT IF YOU NEED AN OIL CHANGE BUT YOU DON'T DO IT INTERNALLY, YOU TAKE IT SOMEWHERE.
AND UH, SO THAT COUNT BEEN PART THERE.
SO I, IF I GO TO MY, LET ME FINISH THIS QUESTION AND THEN I'LL GET TO YOURS.
YOU SEE THAT PARTS HAS A SUBMENU STOCK AND NONSTOP.
IF I CLICK THAT NONSTOP ITEM AND GO, I'M JUST GONNA DO THE, I'M GOING REALLY FAST HERE.
I CLICKED THE LOCATE BUTTON AND I'M GONNA TYPE IN COUNTY AND THERE'S THAT KAUFMAN COUNTY THING.
IT DIDN'T, IT DIDN'T ASK ME TO TYPE IN K COUNTY.
I'M DOING A WILD CARD SEARCH, YOU KNOW WHAT I MEAN? I'M JUST TYPING WHATEVER CHARACTERS COME TO MIND AND IT'S FINDING ITS BEST MATCH.
DOUBLE CLICK ON THAT ROW, CLICK IT AND IT'S SAYING, SEE IT'S ADDED ON THE FLY MARCH 9TH, 2017.
SO, AND IT'S GOT A FLEET WORK ORDER LOG TAB TELLS US EXACTLY WHERE IT WAS USED AND ON WHAT VEHICLE AND BY WHAT MECHANIC.
OKAY, SO THE CROSS-REFERENCING IS REALLY IMPORTANT FOR US FLEET USERS.
WE STRUGGLE WITH THAT CROSS-REFERENCING CAPABILITY.
[01:35:01]
VEHICLE.I'M GONNA SEARCH FOR THAT FORD, UH, 9,000.
IT KNOWS IT'S A ROAD AND BRIDGE VEHICLE IN 1980.
SO IN BLUE HERE, I DON'T THINK YOU CAN TELL IT'S BLUE, BUT MY SCREEN, IT'S BLUE, IT'S SUPPOSED TO BE BLUE, IT'S A PROJECTOR THING.
I'M GONNA PUT IN THE LATEST, UH, 222,000 MILES.
WE REALLY HAVE HAD THIS THING FOR A LONG TIME.
I'M GOING TO ADD SOME DETAIL TO THIS AND I'M GONNA SAY, YOU KNOW, NED'S OUR GUY AND HE SPENT AN HOUR, OH, NOT NED, WE SENT THIS OUT TO THE FORD DEALER.
I DUNNO IF I GOT A FORD DEALER IN HERE, THANK YOU.
I DO HAVE A BOYER FORD BOYER FORD.
WE SENT IT TO THE BOYER FORD GUYS AND THEY, UH, THEY CHARGED US, YOU KNOW, AN HOUR AND THEY, THEY DO AN OIL CHANGE FOR 75 BUCKS SAVE.
SO I CAN PUT IN OUTSIDE VENDORS OR MY IN-HOUSE PEOPLE, I CAN MIX AND MATCH THEM ON THE SAME WORK ORDER.
SO ON THIS AD DETAIL, MAYBE I'LL PICK VINCE CUSTER AND HE SPENT EIGHT HOURS, YOU KNOW, WORKING ON A PARTICULAR PM ITEM, 500 HOUR SERVICE.
AND MAYBE, YOU KNOW, HE USED ALL THESE DIFFERENT PARTS.
I'M JUST PICKING THEM FROM THE LIST.
UH, I CAN EVEN, YOU KNOW, LOCATE A PART.
OH, THERE IT IS, THE GASKET, THE 2 0 9 62.
DO I WANT TO ENTER THAT ON MY WORK ORDER? YES I DO.
HOW MANY DID I USE? I USE THREE OF THEM.
AND YOU CAN SEE HERE THAT MY EMPLOYEE AND CONTRACTOR DETAILS OF WHICH THERE ARE TWO.
ONE IS FOR AN OUTSIDER AND ONE'S FOR AN INSIDER.
ALRIGHT, ENTER THE FLEET WORK ORDER.
WE HAVE A MORE BUTTON ONTO WHICH YOU CAN ADD PHOTOGRAPHS IF YOU WANTED TO.
BUT THIS HYPERLINK, I'VE FORGOTTEN YOUR NAME.
TELL ME YOUR VICKY, VICKI, THIS HYPERLINK VICKI WILL TAKE YOU RIGHT TO THE DETAILS OF THAT VEHICLE.
SO, UH, NO, WE DON'T DISPLAY THE PHOTO AUTOMATICALLY.
UM, BUT WE'RE SHOWING YOU ALL THE OTHER INFORMATION THAT SURROUNDS THAT VEHICLE.
ALL OF ITS ATTRIBUTES, ALL OF ITS HISTORY THROUGH THE ODOMETER LOG, THE FLEET WORK ORDER LOG, AND THE ACTIVITY LOG.
WE'RE SHOWING YOU ALL THOSE DETAILS WITH ONE MOUSE AROUND.
SO I'VE ENTERED SOME FLEET WORK ORDERS, LET'S SAY.
I MEAN I JUST, YOU KNOW, WE'RE DOING THESE DAY IN AND DAY OUT AND MAYBE NOW I NEED TO RUN SOME FLEET REPORTS.
UM, I'VE GOT SOME FLEET MAINTENANCE REPORTS.
I ALSO HAVE SOME EQUIPMENT PERHAPS, UH, EQUIPMENT REPLACEMENT REPORTS.
SO, UH, SO I MIGHT WANT TO FIND OUT, UH, WHICH VEHICLES DO I NEED TO REPLACE APPROACHING THEIR REPLACEMENT ODOMETER OR BASED ON A REPLACEMENT YEAR, IT'S GONNA SHOW ME EVERYTHING THAT I'M GOING TO REPLACE, UH, BEFORE THE YEAR 2017 AND GROUP THAT BY DEPARTMENT.
SO I'LL CLICK THAT OKAY BUTTON AND IT'S GIVEN ME A LIST OF REPLACEMENT CANDIDATES.
LET ME RERUN THAT AND JUST SAY, JUST SHOW ME THE REPLACEMENT CANDIDATES ONLY MATTERS NOW ON MY LIST.
SO THESE ARE ALL THE VEHICLES THAT WE WERE SUPPOSED TO REPLACE FOR THIS YEAR AND IT'S GIVING US LIFE TO DATE MAINTENANCE AND OTHER, UH, DEPARTMENTAL GROUPINGS, UH, THAT HELP US MAKE SENSE OF THIS INFORMATION.
ANOTHER REPORT FOR PERHAPS FROM A FLEET MAINTENANCE COST PERSPECTIVE, MAYBE I WANT THE, UH, THE COMPREHENSIVE SUMMARY, UH, FOR ALL OF MY PICKUP TRUCKS AND GROUP THAT BY DEPARTMENT.
I'LL SAY, GIMME THAT FOR EVERYTHING IN THE YEAR 2016.
AND, UH, YOU KNOW, SO IT'S GIMME A VERY, WELL, IT'S CALLED THE COMPREHENSIVE SUMMARY.
THIS IS AN EXAMPLE OF A REPORT WE CREATED FOR A CUSTOMER IN ARCADA, CALIFORNIA.
THEY WERE LIKE, WE LIKE YOUR SYSTEM, BUT YOU NEED TO HAVE THIS REPORT.
WELL GUESS WHAT? YOU ADDED THE REPORT.
UM, BUT IT'S GIVING US A LOT OF DETAIL ON THE COST OF MAINTENANCE, BOTH IN-HOUSE, OUTSIDE TIRES.
I'M NOT GETTING A LOT OF DATA HERE 'CAUSE I DON'T HAVE MY DATABASE FLESHED OUT VERY WELL.
IT'S ISOLATING OIL AND FUEL AND ALSO COST PER MILE.
SO THIS KIND OF REPORT, UH, A LOT OF OUR CUSTOMERS NOW USE IT SINCE WE ADDED IT A FEW YEARS AGO.
IT'S A VERY, WELL, IT'S JUST THAT IT'S THE COMPREHENSIVE SUMMARY.
IT GIVES THEM EVERYTHING THEY NEED TO KNOW ABOUT VEHICLE REPAIRS IN A GIVEN TIMEFRAME.
SO, YOU KNOW, TYPICALLY WE CAN SPEND A 90 MINUTE TIMEFRAME JUST IN FLEET ALONE.
[01:40:01]
I THINK A, I HOPE A PRETTY BROAD OVERVIEW.ONE THING TOO IS WHEN WE'RE ADDING PARTS ON WORK ORDERS, UH, THEY CAN BE DONE WITH A BARCODE SCANNER, WHICH MAKES IT, UH, PRETTY NICE.
UH, AGAIN, SPEED AND ACCURACY IS AN IMPORTANT THING.
THERE'S A LOT OF REPORT CHOICES HERE.
UH, THERE'S A LOT OF FILTERING MECHANISMS SO THAT YOU CAN ISOLATE AND JUST HONE IN AND DIAL INTO A SUBSET OF YOUR DATA.
UM, WE JUST DID A DATA CONVERSION FOR, UH, WILEY COUNTY, KANSAS AND THEY WERE USING A, A FLEET PRODUCT FOR 15 YEARS.
WE BROUGHT IN 15 YEARS, I THINK IT WAS LIKE 75,000 FLEET WORK ORDERS.
AND THIS, THIS WEALTH OF HISTORICAL DATA IS STILL WITH THEM.
NOW THEY CAN USE OUR SYSTEM, UH, TO SLICE AND DICE THAT AND, AND GET TO THOSE HISTORIES AND LOOK AT THE PAST, UH, IN A WAY THAT'S REALLY, REALLY POWERFUL AND HANDY FOR THEM.
SO DID I COVER WHAT WE WANTED TO COVER? YEAH, I THINK YOU'RE THE ORCHESTRATOR MAPPING.
ALRIGHT, LET'S TAKE A LOOK AT SOME OF THAT.
UM, YOU KNOW, WE'VE GOT A GIS MAP VIEWER.
IT'S BUILT ON THE ESRI ARC ENGINE PLATFORM.
UM, WE CAN INTEGRATE WITH ANY LAYER, ANY SPATIAL DATA YOU'VE GOT.
I'M NOT A GI DISCLAIMER, I'M NOT A GIS GUY, SO GO EASY ON ME.
UM, DON'T ASK ME ABOUT, DON'T ASK ME WHAT A IS 'CAUSE I DON'T KNOW
UM, BUT WHAT WE'VE TRIED TO DO IS CREATE, UM, A MAP THAT'S EASY FOR PEOPLE TO USE.
THEY USE ARC MAP AND IT'S EXTRAORDINARILY POWERFUL, BUT IT'S REALLY SOPHISTICATED.
IT'S, IT'S SORT OF THE FERRARI VERSUS THE FORD ONE 50.
SO ON THE LEFT HAND SIDE ARE, ARE THE VARIOUS, UM, LAYERS THAT MOST GIS PEOPLE ARE FAMILIAR WITH AND YOU CAN TURN THEM ON OR OFF WITH A CHECKBOX.
WE, WE BUILT THE SIMPLIFIED TOOLBAR ACROSS THE TOP THAT ISOLATES WHAT WE THOUGHT WERE THE PRIMARY TOOLS TO BE USED IN GIS.
SO FOR EXAMPLE, A ZOOM IN TOOL, I JUST DRAW A LITTLE BOX AND THAT ZOOMS IN.
AND AS I ZOOM IN, MORE AND MORE DETAILS START TO BECOME APPARENT.
AND I'VE GOT THE CONCEPT OF SELECTING LAYERS.
SO MAYBE I WANNA SELECT MY STREET CENTER LINES.
AND THEN IF I ZOOM IN JUST A WEE BIT MORE, UH, IF I CHOOSE MY SELECTION TOOL, I KNOW YOU PROBABLY CAN'T SEE THIS VERY WELL FROM THE BACK, BUT THAT'S JUST A SPRING RESOLUTION ISSUE.
IF I SELECT THAT LANE, IT GOES BLUE, YOU CAN SEE THAT IT'S GONE BLUE.
AND NOW I'VE MADE A SELECTION AND THERE'S A LINKAGE BETWEEN THAT SPATIAL MAPPED VISUAL DATA AND THE P WORKS DATA AND A RIGHT CLICK WILL EXPOSE THAT.
SO I CAN LOOK AT THE DETAILED HISTORY OF WORK THAT'S GONE ON AT THAT PARTICULAR LOCATION.
I CAN LOOK AT RIGHT CLICK THE SERVICE REQUEST HISTORY.
HERE ARE ALL THE SERVICE REQUESTS THAT HAVE BEEN CALLED IN FOR BAT AT LANE LIFE TO DATE, 64 POTHOLE PROBLEM.
CLICK ON THE COLUMN HEADINGS TO SORT DOUBLE CLICK TO BRING UP THE SERVICE REQUEST RECORD.
SO THE LINKAGE BETWEEN THE MAP AND THE DATA IS WE THINK RATHER INTUITIVE.
THE TRAINING IS THIS, CLICK ON THE ROAD AND THEN DO A RIGHT CLICK AND THEN MAKE THE APPROPRIATE SELECTION.
SO IT'S A, IT, IT'S A PRETTY SIMPLE TRAINING REGIMEN.
UM, I WANNA CREATE A NEW SERVICE REQUEST FOR THAT ROAD.
SO THERE'S A CREATE SERVICE REQUEST LINK, EXCUSE ME, MENU ITEM HERE.
AND THAT'LL OPEN UP THE SERVICE REQUEST SCREEN AND IT'LL PRE-POPULATE IT WITH THAT AT LANE.
'CAUSE THAT'S THE ROAD ON WHICH I CLICKED.
LET'S SEE HOW THIS MIGHT WORK FOR A SIGN.
SO LET ME TURN ON MY SIGNS, LAYERS SELECTABLE AS WELL.
I'M GONNA CLEAR MY SELECTION AND BRIEF PICK MY SELECTION.
I'LL CLICK ON THAT PARTICULAR SIGN AND THAT SIGN HAS TAKEN ON A BLUE DOT.
AND AGAIN, I CAN LOOK AT MY DISPLAY, THE PUBLIC'S DATA, WHAT ARE THE ATTRIBUTES OF THE SIGN? SO I I DIDN'T WHAT'S YOUR NAME? I DIDN'T GET YOUR NAME.
SO YOU KNOW, AS A GIS GUY, YOU'VE GOT THAT INFO TOOL AND WE KIND OF HAVE THAT HERE TOO.
UH, WE'VE GOT THAT INFO BUTTON, BUT IT DISPLAYS, WE'RE NOT SHOWING IT HERE.
I DON'T KNOW WHY IT'S NOT GS GUY.
SO THERE'S A WAY TO GET THIS TO WORK, BUT TYPICALLY THE INFO TOOL SHOWS YOU THE, THE ATTRIBUTE INFORMATION YOU WANT, BUT NOT IN THE MOST USER FRIENDLY MANNER.
UH, BUT WHEN WE DO IT THROUGH THE, THE RIGHT CLICK DISPLAY PUBLICS DATA, YOU KNOW, IT BRINGS UP THAT SIGN
[01:45:01]
RECORD ON A MORE USER FRIENDLY ENVIRONMENT.AND WE CAN SEE THAT THERE'S RETRO REFLECTIVITY READINGS HERE.
WE HAVE GOT A INSTALLATION DATE FIELD.
WE'VE GOT, IT'S ON A UAN POST.
IT'S WHITE ON RED IN COLOR, IT'S BEADED TO ENGINEERING GRADE OR WHATEVER THOSE THINGS ARE.
AND UH, FROM THIS SCREEN HERE AS WELL, WE'VE GOT AN ACTIVITY LOG.
WE CAN SEE ALL THE DIFFERENT TIMES.
WE DID, WE WERE DOING SOME STORM DRAIN MAINTENANCE ON THAT SIGN.
YOU KNOW, OUR GUYS WERE A LITTLE CONFUSED THAT DAY.
SO OUR DEMO DATA CAN BE A LITTLE HOKEY.
WE CREATE WITH A COMPUTER PROGRAM.
SO SOMETIMES WE HAVE BULLDOZERS, MOWING GRASS.
GOTTA KIND OF LIKE LOOK PAST THAT.
UM, SO THE MAP, YOU KNOW, HAS SOME REALLY NICE STANDARD GIS CAPABILITIES.
UM, BUT ALSO IT'S THE INTERACTION WITH THE PUB WORKS TRANSACTIONAL DATA THAT BRINGS OUT THE VALUE.
IF YOU DON'T APPROACH THE MAP FROM THE MAP, YOU CAN APPROACH THE MAP.
YOU CAN GET TO THE MAP FROM THE MAP BUTTON ON VARIOUS SCREENS.
SO IF WE LOOK AT A COUPLE OF SCREENS HERE, LET'S LOOK AT SOME, LET'S GO TO A ROAD RECORD BABBIT LANE.
SO THERE'S BABBITT LANE, AND BABBITT LANE HAS A MAP BUTTON.
I WENT TO THAT SIGN FOUR 18, IT HAS A MAP BUTTON.
ONE MORE EXAMPLE SERVICE REQUEST LOG.
SERVICE REQUEST LOG HAS A MAP BUTTON.
AND IF I CLICK THAT MAP BUTTON, GIVE A COUPLE SECONDS.
THERE IS THAT MAP SERVICE REQUEST AND IT'S PINPOINTED BASED ON ADDRESS.
IT'S BLUE BECAUSE IT'S CLOSED SO IT KNOWS WHERE THE ADDRESSES ARE.
YEAH, IT CAN EITHER CALCULATE THEM OR IF YOU'VE GOT A PARCEL LAYER IN THEM, YOU CAN FIND THAT PARCEL.
SO WE HAVE SOME ROADS THAT ARE, THEY'RE COUNTY ROADS, BUT HALF OF THEM ARE IN THE CITY.
IT DEPENDS ON THE UNDERLYING DATA.
SO IF YOU'VE GOT, YOU KNOW, IN OUR SYSTEM WE'VE GOT, I PROBABLY DIDN'T SHOW IT, BUT WE'VE GOT LOCATION ADDRESSES.
I HAVE IT TURNED OFF IN MY DEMO.
UH, BUT YOU CAN HAVE SPECIFIC ADDRESS DATA IN THERE.
WE CAN LINK DIRECTLY FOR THOSE PARCELS.
IN A LOT OF COUNTY ENVIRONMENTS, THEY DON'T, THEY MIGHT NOT HAVE THAT OR MIGHT NOT HAVE CHOSEN TO USE THAT.
YOU'LL PUT IT, IT'S, YOU KNOW, 1305 FARM ROAD 14 9 6 AND YOU KNOW, THE 1305 IS ONE POINT OFF AND IT'LL FIGURE IT OUT FROM THERE.
UH, SO I CAN, FROM A SERVICE REQUEST SCREEN, I CAN MAP FROM MY LOCATION FEATURE SCREEN, I CAN MAP THAT SINGLE FEATURE OR A VARIETY.
YOU'RE JUST GONNA FIND THAT STOP SIGN.
THERE'S MY STOP SIGN FOUR 18, UH, FROM MY, UH, STREET SCREEN, I CAN, OR MY ROAD SCREEN, MY LOCATION SCREEN.
I CAN DISPLAY THAT PARTICULAR ROAD AS WELL.
AND ONE LAST, UH, TRICK THAT I GOT UP MY SLEEVE.
LET'S SAY THAT WE WERE CONNIE PEMBERTON AGAIN, YOU WERE LOOKING AT OUR, OR MAYBE I'M NOT CONNIE, I'M LOOKING AT MY SERVICE REQUEST STATUS SCREEN.
LEMME RESIZE THAT SO I CAN FIT IT.
AND I MIGHT WANNA LOOK AT ALL OF MY OPEN, UH, POTHOLE PROBLEMS. SO I'VE GOT THESE FOUR POTHOLE PROBLEMS AND THERE'S A BUTTON DOWN HERE CALLED MAP, AND IT'S GOING TO, UM, SHOW US ON OUR MAP WHERE THOSE PROBLEMS ARE.
THEY'RE ALL, THEY'RE, THEY'RE A LITTLE CLUTTERED, BUT THERE'S THREE DOWN HERE, 1, 2, 3, AND THE FOURTH ONE'S UP THERE THAT I CAN'T QUITE REACH.
SO, UH, WE'VE TRIED TO BUILD IN AN EASY AND INTUITIVE, SIMPLE WAY TO PROVIDE MAPPING WITHOUT HAVING TO BE A GIS HEAVYWEIGHT.
UH, SO THAT, THAT'S MY NICKEL TOUR OF THE MAPPING.
UH, WE HAVE A COUPLE OF STAFFERS WHO ARE REALLY QUITE SKILLED IN GIS, NOT JUST OUR MANIFESTATION OF IT, BUT GS IN GENERAL.
AND THEY WOULD, UH, THEY COULD TAKE YOU THROUGH IT AD NAUSEUM IF YOU, SO YOU MAY WANT TO GO OUT AND LOOK AT, AT SIGNS, THEN STOP SIGNS AND THEN STOP SIGNS THAT FACE WEST OR SOUTH.
WELL, AND WE HAVE, WE DO HAVE SIGNS THAT SAY COUNTY MAINTENANCE STOPS HERE, RIGHT? COULD YOU PUT THOSE AND TAG THOSE AS YOU CAN? BECAUSE WHEN WE LOOK AT OUR SIGN REC, LET ME JUST, UH, THAT WOULD BE AN ATTRIBUTE OF THE SIGNS.
SO IF WE, IF WE GO TO OUR LOCATE, WE CALL 'EM LOCATION FEATURES.
AND AGAIN, THEY ARE, YOU KNOW, WE'VE GOT, LET ME JUST BACK UP TO THE BEGINNING.
WE, WE TALK ABOUT LOCATIONS, WE TALK ABOUT ACTIVITIES, WE DOCUMENT WORK AT ACTIVITIES, EMPLOYEES AT A LOCATION PERFORMING A TASK.
BUT LOCATIONS ARE THE BIG TICKET ITEMS. AND LOCATION FEATURES ARE THE SUBORDINATE ITEMS. SO YOU'LL HAVE A ROAD, IT'S GOT NINE SIGNS ON IT, RIGHT? IT'S A PARENT CHILD THING.
[01:50:01]
TO THAT ROAD.SO I CAN INVENTORY ALL MY SIGNS, ANY NUMBER OF THINGS.
I'VE GOT A WIDE VARIETY OF CUSTOM THINGS HERE, BUT HERE'S MY SIGNS AND YOU KNOW, THE ATTRIBUTES OF THE SIGN DOWN HERE IN THE LOWER LEFT, LOWER RIGHT, UM, THAT'S WHERE YOU WOULD VIEW THEY'RE CUSTOM.
SO YOU WOULD, THE THING YOU JUST MENTIONED, WHAT DID YOU JUST MENTION? I, THE COUNTY MAINTENANCE STOPS HERE, COUNTY MAINTENANCE STOPS HERE.
YOU COULD HAVE A SIGN FOR COUNTY MAINTENANCE STOPS HERE AND PUT A MILE MARKER ON IT EXACTLY TO BEGIN MILE POST RIGHT THERE.
I MEAN, I, IT'S BECAUSE I ALWAYS HAVE TO SEND 'EM TO GO LOOK AT THIS ADDRESS.
IS THE SIGN OFF THIS SIDE OF THAT ADDRESS OR THIS THAT, AND BASED ON THOSE ATTRIBUTES, WE'VE GOT A ANOTHER, UH, TOOL AND THE SYSTEM IS CALLED ASSET SEARCH.
ASSET SEARCH LETS YOU FIND THOSE NEEDLES IN THE HAYSTACK, FIND ME ALL THE RED SIGNS ON A UAN POSTS THAT ARE, UM, MT CODE.
THIS, YOU, YOU CAN, YOU KNOW, PUT THESE CRITERIA TOGETHER AND IT'S GONNA FIND YOU THE THREE THINGS BECAUSE YOU MIGHT HAVE, LIKE, WE GOT OUR, OUR BIGGEST SIGN CUSTOMER THAT I KNOW OF, I DON'T KNOW WHAT COLLIN'S DOING, BUT I KNOW COCHISE COUNTY, ARIZONA, THEY GOT 30,000 SIGNS.
AND FOR THEM TO FIND THOSE FOUR SIGNS, YOU KNOW, THAT'S A NEEDLE IN THEY, SO THEY USE THIS ASSET SEARCH TO HONE IN ON THE ATTRIBUTES AND PLUCK THOSE THINGS OUT.
AND ONCE YOU FIND THE ITEMS, YOU CAN MAP THEM AS WELL.
SO BECAUSE THEY WANT TO GO FROM, THEY WANT TO FIND ALL THEIR WARNING SIGNS THAT ARE ON A WOODEN POST AND REPLACE 'EM WITH A METAL POST AND THEY GOT 30,000 SIGNS.
THEY DON'T WANT TO DRIVE AROUND AND LOOK FOR 'EM.
THEY CAN, THEY CAN USE THIS SEARCH FEATURE AND IMMEDIATELY HONE IN, OH, WELL THERE'S 78 OF THOSE AND THEN THEY CAN PUT 'EM ON A MAP OR THEY COULD CREATE A WORK ORDER FOR ALL 78 AND HERE'S WHAT YOU GUYS ARE GONNA DO FOR THE NEXT, YOU KNOW, THREE WEEKS WE'RE GONNA REPLACE 78 WOODEN WOODEN POSTS WITH NEW GALVANIZED POSTS.
SO IT JUST GIVES YOU THE ABILITY TO HONE IN AND FIND THAT STUFF THAT'S, THAT HE SAYS, IS THE NEEDLE MY STACK? RIGHT? BUT YOU KNOW, YOU GOT THE PROBLEMS, BUT, BUT THE DATA'S OUT THERE.
SO WHAT I DID WAS I CREATED A SEARCH.
I SAID, SHOW ME ALL MY SIGNS THAT ARE R ONE DASH ONE, WHICH IS, UH, YOU SIGNED STUFF
IT'S ON A STEEL POLE AND IT FOUND FIVE, IT FOUND FIVE ITEMS. OR I CAN CREATE A WORK ORDER THAT SAYS INSPECT THEM, REPLACE THEM, CLEAN THEM, BRING 'EM BACK TO THE OFFICE, YOU KNOW, WHATEVER.
SO THAT, UH, THAT ASSET SEARCH TOOL GUY CREATED THAT GREAT JOB WITH THAT.
AND UH, THAT'S SUPER POWERFUL BECAUSE, YOU KNOW, WE'VE GOT AGENCIES WITH 30,000 SIGNS WITH 1500, 15,000 MANHOLES, YOU KNOW, ALL SORTS OF, YOU KNOW, LARGE QUANTITIES OF INVENTORY THAT THAT'S WHAT COMPUTERS ARE FOR.
SO LET'S, AND ANY, ANY, ANY
DO WE OWN OR LEASE THE SOFTWARE? YOU WOULD OWN THE SOFTWARE OUTSTANDINGLY? UH, AND IT'S, IF WE OWN IT, DO WE PURCHASE UPDATES OR ARE THEY AUTOMATIC? UH, WE HAVE AN ANNUAL MAINTENANCE FEE.
UH, UH, BUT THAT, THAT COVERS ANY NEW RELEASES, ANY, UH, FIXES ANY ENHANCEMENTS IN A NEW REPORT.
SO WHEN YOU SAY WE OWN IT, WE OWN THE LICENSE THOUGH.
YOU OWN, YOU OWN A PERPETUAL LICENSE, RIGHT? RIGHT.
NO, 'CAUSE IT'S YOUR IP, RIGHT? IT'S OUR IP.
YOU DON'T OWN THE SOURCE CODE, YOU OWN YOU, YOU OWN A PERPETUAL LICENSE.
JUST LIKE IF YOU BOUGHT ANOTHER SOFTWARE, YOU KNOW, A MICROSOFT PROBABLY PUT ON YOUR COMPUTER, YOU, YOU OWN IT IN PERPETUITY AND, AND, AND SOME VENDORS WILL CUT YOU OFF IF YOU DON'T PAY THE MAINTENANCE FEE.
AND I WANT TO MENTION FOR YOUR NEXT QUESTION, IT'S UNLIMITED USE.
SO IT'S NOT ON A PERCEIVED BASIS OR PER USER BASIS.
YOU CAN ADD PEOPLE, TAKE PEOPLE OFF.
YOU HAVE COMPLETE FLEXIBILITY AND CONTROL, UH, FOR AS MANY PEOPLE AS YOU WANT TO USE.
AND, AND THE SAME THING IF YOU HAVE THE MOBILE SIDE OF IT, YOU CAN HAVE AS MANY MOBILE USERS AS YOU WANT.
YOU CAN HAVE AS MANY TABLETS OR CELL PHONES.
SO IT'S PRETTY MUCH WIDE OPEN, UNRESTRICTED USE THAT YOU'RE IN COMPLETE CONTROL OF.
YOU DON'T HAVE TO CALL US TO DO ANYTHING.
THAT ALMOST FINISHES MY LAST QUESTION.
THAT IS A VERY IMPORTANT QUESTION.
IT'S COMPLETELY IN YOUR CONTROL AND YOUR OWNERSHIP.
BACK TO THE MAINTENANCE, THE FEE ON THAT, THAT COMES THAT SAY THAT YOU HAVE AN UPDATE THAT'S GOING TO CHANGE CONSIDERABLY.
DOES THAT MAINTENANCE FEE ALSO
[01:55:01]
INCLUDE, UH, RETRAINING? YES.WELL, KIND OF, I MEAN TRAINING, WE DO A LOT OF TRAINING ONLINE.
YOU HAVE WITH GOTOMEETING AND THOSE TRAINING SESSIONS END TO BE KIND OF LIKE AD HOC.
YOU KNOW, YOU'LL SAY, HEY LOOK, I, WE'VE GOT A NEW GUY AND WE WANT SHOW HIM HOW TO USE THE SERVICE TRUST THING.
BILL JACKSON'S GONNA, WE'VE GOT ONE OF OUR GUYS, BILL JACKSON, UH, AND HE'LL TAKE DO THAT FOR HOUR.
IF YOU ASK US TO COME OUT HERE FOR TWO DAYS, WE CHARGE FOR THAT.
SO, BUT IN GENERAL, UM, THERE, THERE'S AN ANSWER AT A HIGHER LEVEL, UH, THERE'S A COUPLE WAYS THAT SOFTWARE COMPANIES DO NEW RELEASES AND, AND ONE WAY THE TERM IS MONOLITHIC.
LIKE, LIKE MICROSOFT, LIKE EVERY TWO YEARS OR THREE YEARS, YOU GET THIS WHOLE NEW WINDOW SPIN AND IT'S JUST A NIGHTMARE, RIGHT? AND LIKE EVERY OTHER MICROSOFT RELEASE IS GOOD AND EVERY OTHER ONE'S BAD, RIGHT? SO, AND, AND THOSE COME OUT EVERY TWO YEARS OR THREE YEARS.
SO, SO WE'RE DOING, WE'RE IMPROVING THIS STUFF INCREMENTALLY AND, AND CONSTANTLY.
SO, SO WE'LL NEVER HAVE THAT, THAT THAT POINT WHERE YOU HAVE A BIG HUGE CHANGE.
IT'S SMALLER INCREMENTAL CHANGES, WHICH MAKES IT MUCH EASIER ON THE CLIENT BECAUSE WE'RE JUST ADDING A FEW FEATURES AT A TIME.
WELL, WILL IT BE LIKE MICROSOFT OR WHERE IT YOUR LEAKAGE? NO, IT'S GONNA BE A SITUATION WHERE YOU RELEASE SOMETHING AND EVERYBODY IN THE COUNTY GOES, MAN, THIS IS THE WORST THING EVER.
HEY GUYS, LOOK, WE DON'T LIKE THIS NEW RELEASE.
YOU HAVE NEVER RUN INTO THAT PROBLEM.
LIKE BOB SAYS, WE, OUR CHANGES ARE VERY SMALL, VERY INCREMENTAL.
YOU KNOW, UM, I HAVE A TERM, I'VE BEEN IN THE SOFTWARE BUSINESS FOR A LONG TIME AND I'VE GOT A TERM FOR WHAT A LOT OF VENDORS DO.
THEY PUT THE STEERING WHEEL IN THE BACK SEAT.
YOU'RE USED TO THE WAY IT IS AND NEXT THING YOU KNOW, OH, WE'VE MADE ALL THESE IMPROVEMENTS, BUT YOU GOTTA BE IN, YOU GOTTA TWIST AROUND.
AND IT'S LIKE, THIS IS BRAIN DAMAGE.
SO WE, WE TRY TO KEEP SOMETHING UNDER IT EARLY ON, YOU KEEP IT THE SAME.
'CAUSE WE DON'T WANNA HAVE TO RETRAIN EVERYBODY, RIGHT? WE DON'T WANT TO, ALL OF A SUDDEN YOU TURN 'EM ON AND NOW YOU CAN'T FIND YOUR, THE TOOLS YOU ARE USED TO USING.
I'VE ONLY BEEN HERE NINE YEARS AND WE'VE NEVER HAD THAT SITUATION YOU'RE TALKING ABOUT EVER.
CAN I ASK? BUT IT'S A GOOD QUESTION.
BUT, BUT SOME, ANOTHER COMMENT I MAKE IS PROBABLY MORE IMPORTANTLY YOU HAVE TURNOVER AND SOME PEOPLE LEAVE, SOME PEOPLE COME AND, AND OTHER PEOPLE GET PROMOTED AND GO TO OTHER DEPARTMENTS.
SO IN THAT CASE, WE PROVIDE FREE WEB TRAINING.
SO YOU GET A NEW EMPLOYEE AND YOU'VE GOT A GROUP OF PEOPLE WHO ALREADY KNOW HOW TO USE THE PRODUCT, BUT YOU DON'T WANNA SIT DOWN.
THEY'VE GOT WORK TO DO THEMSELVES OUT IN THE FIELD.
SO, SO THEY CAN CALL IN OUR CUSTOMER SUPPORT TEAM AND THEY'LL WALK THEM THROUGH AND, AND MAYBE IT'S AN HOUR A DAY, YOU KNOW, UH, FOR A WEEK OR MAYBE IT'S A COUPLE HOURS FOR A MONTH, UH, YOU KNOW, ONCE A WEEK FOR A MONTH.
BUT THAT, WELL, THEY'LL WALK A NEW PERSON THROUGH AND TRAIN THEM TO WHATEVER DEGREE THEY NEED TO BE TRAINED, UH, ON THE USE.
SO IS YOUR LICENSE PER USER? NO, IT'S NOT.
IT'S FOR THE ENTIRE DEPARTMENT.
AND HOW MUCH IS YOUR MODULES? HOW MUCH IS EACH MODULE OR THE LICENSE INCORPORATES ALL YOUR MODULES? NO, THE LICENSING IS BASED ON THAT.
IF YOU REMEMBER THE, IF YOU SAW THE CHART, IT WAS UH, IS THE, THERE'S THE CORE SYSTEM AND WHAT OTHER OPTIONAL MODULES YOU WANT.
HOW MUCH OF, HOW MUCH IS THE CORE AND HOW MUCH IS EACH MODULE? WELL, IT DEPENDS ON WHAT ENTITY YOU'RE WITH AND, AND, UH, I CAN, I CAN PUT TOGETHER, UH, A PRICING CODE, SOME PRICING INFORMATION.
SO IF THE COUNTY GOES WITH YOUR PROGRAM, THE CITY SETS THAT YOU USE, YOUR PROGRAM, IS THERE A PRICE BREAK? IS THERE SOME OH YEAH.
WE PRICE, WE PRICE, WE PRICE BASED ON SCALE, THE SIZE YOU ARE.
SO LIKE COLLIN COUNTY, THEY'RE VERY MUCH LARGER IN KAUFMAN, THEIR PRICE.
WE HAVEN'T EVEN QUOTED YOU A PRICE YET.
SO THEY'RE, YOU'RE, YOU WOULDN'T PAY WHAT THEY PAID.
WHEN WE SELL TO VALLEY, GOT LIKE 10,000 PEOPLE, I DON'T WANT TO PAY WHAT YOU PERHAPS WOULD CHARGE THE CITY.
I WANT TO PIGGYBACK WITH THE COUNTY, AND THOUGH THIS IS ALL ONE ENTITY, WE CAN IMPLEMENT THINGS THAT YEAH, WE CAN DO THAT.
OH YEAH, WE CAN ABSOLUTELY DO THAT.
YEAH, I'LL JUST NEED TO WORK IT UP.
I CAN'T, I DON'T, I CAN'T GET IT OUT OF MY HEAD, BUT WHY? YEAH,
SO, UH, SO YOU'RE, YOU'RE YOU'RE GONNA BE IN THE LOWER PRICING CATEGORY, NOT IN THE HIGHER PRICING CATEGORY.
WHEN WE START TALKING ABOUT BIGGER COUNTIES LIKE MONTGOMERY WITH 500,000 PEOPLE ARE, ARE COMMON WITH 900 OR MILL MINIMUM OF 200,000.
UH, SO WHAT WE DO IS, IS WE, WE BASICALLY HAVE A DISCOUNT SCHEDULE THAT TAKES THE PRICE LOWER, BUT WE CAN, BUT WE
[02:00:01]
CAN PATCH, PACKAGE IT UP, UH, UH, FOR BOTH THE COUNTY AND THE CITY.UH, AND, AND, AND GIVE YOU SOME ATTRACTIVE DISCOUNTS.
LET'S SAY THAT'S THE NEXT THING.
WE NEED SOME NUMBERS TO LOOK AT.
DID NOT ASK, INTRODUCE THAT EARLY ON.
I DIDN'T PUT IT UP THERE, BUT WE, BUT WE TEND TO BE ON THE MORE AFFORDABLE SCALE.
I WOULDN'T SAY WE ARE THE CHEAPEST PRODUCT.
THAT'S A BAD THING TO SAY ABOUT YOUR PRODUCT'S CHEAP, BUT, BUT WE TEND TO BE ON A MORE AFFORDABLE SCALE.
UH, AND I CAN TELL YOU IN IN, IN THE COLLIN COUNTY, RFP, WE WERE HALF THE PRICE OF THE OTHER COMPETING PRODUCTS.
THE ONES THAT YOU ARE FAMILIAR WITH.
WELL, COLLIN COUNTY, NO ONE BUT ME KNOWS IN THIS ROOM, KNOWS THIS.
WHEN COLLIN COUNTY STARTED LOOKING FOR A SOFTWARE PROGRAM FOR THEIR STREETS AND YEP.
THEY CALLED ME ABOUT CAR CRASH.
I DON'T KNOW, I DON'T REMEMBER WHAT THE YOUNG MAN'S NAME WAS.
THAT CALLED HIM, BUT HE CALLED HIM.
WE TALKED, WAS THAT WHO TALKED SEVERAL TIMES? CHRIS
AND HE'S, HE'S, HE'S SORT OF OUR, YOU CAN TALK OFF OF HIM.
HE'S, HE'S OUR, UH, HE'S OUR COORDINATOR OVER THERE AND HE WORKS FOR TAMMY, WHO'S THE ADMINISTRATIVE MANAGER, WORKS FOR, HE WAS ACTUALLY LEANING TOWARDS CHRONOGRAPH, BUT SOMEONE ELSE, SECURITY, I GUESS TO Y'ALL.
HE WAS, HE WENT TO THEIR USER GROUP IN DEN IN SOME OTHER USERS SAID BACK THINGS, SOME OUT AT THEIR YOUNG USER GROUP,
THAT KIND OF TURNED HIS HEAD A LITTLE BIT.
SHOULD THE COMMISSIONERS DECIDE TO DO THIS, WHAT ARE YOUR TRAINING? UH, PRO PROTOCOLS? YEAH.
DO YOU GO TO EACH INDIVIDUAL OFFICE OR IS IT A GROUP TRAINING? WELL, UH, IT CAN BE ANYTHING YOU WANT, BUT WHAT IT WOULD BE IS WE WOULD, WE WOULD WANT TO ACCOMMODATE, UH, WHATEVER WORKS BEST FOR YOU IN, IN YOUR, IN YOUR PRECINCT.
SO, SO MY INITIAL IDEA IS WE WANT TO TRAIN AT EACH PRECINCT.
NOW WE COULD COME IN ONE ROOM AND TRAIN EVERYBODY AT ONCE, BUT YOU HAVE, YOU OFTENTIMES HAVE SOME NUANCES AND SOME DIFFERENCES AT HOW YOUR OPERATIONS, I WAS MENTIONING THIS UH, EARLIER, UH, LIKE IN MONTGOMERY COUNTY, SAME THING.
THEY GOT FOUR PRECINCTS AND THE ONES CLOSEST TO HOUSTON ARE VERY URBAN AND THEY HAVE A LOT OF NEW INFRASTRUCTURE AND THE ROADS ARE NEW AND THEY HAVE COMPLETELY DIFFERENT PROBLEMS AND ISSUES THAN THE TWO RURAL PRECINCTS THAT ARE FURTHER OUT TOWARDS CONROE, WHERE THEY'RE DOING, WHERE THEY'RE ROAD, WHERE THEY'RE GRADING ROADS THERE.
AND THE OTHER ONES, THEY DON'T HAVE A DIRT ROAD.
AND SO WE'VE TRAINED EACH ONE OF THOSE PRECINCTS WET, HAVE ANYMORE, WE LOST OUR DIRT ROAD.
SO WE TRAIN EACH ONE OF THEIR PRECINCTS SEPARATELY BECAUSE THEY, THE, THE, THE COMMISSIONERS KIND OF HAVE A, A DIFFERENT TASK AND DIFFERENT JOBS AND DIFFERENT, UH, UH, CITIZEN REQUIREMENTS.
AND THEN ONE OF THE PRECINCTS IS VERY, UM, UH, UH, INTERESTED IN ONLY USING MOBILE DEVICES.
AND THEY, AND THEY PURCHASED MOBILE DEVICES FOR EVERYONE AND ONE OF THEIR OTHER PRECINCTS, THEY DON'T WANNA SPEND THE MONEY ON CELL PHONES FOR EVERYONE.
SO MY IDEA REALLY WOULD BE THAT WE, THAT WE WORK WITH YOU AND TRY TO HONE THE, THE, UM, OR TRY TO DEFINE THE TRAINING EXACTLY.
PRECINCT BY PRECINCT RATHER THAN ONE SIZE FITS ALL THAT, THAT TO ME AT LEAST SEEMS THE MOST LOGICAL WAY TO DO IT.
AND AND THE SAME THING WITH, WITH THE CITY IS, IS WE, WE TYPICALLY DO WHAT WE CALL A PRE-INSTALL ANALYSIS WHERE WE SPEND SOME TIME WITH THE CLIENT.
WE EITHER COME ON SITE OR WE DO IT OVER THE PHONE, BUT WE TRY TO UNDERSTAND YOUR OPERATIONS, OUR PEOPLE UNDERSTAND YOUR OPERATIONS SO WE CAN CONFIGURE THE SOFTWARE TO FIT YOU.
'CAUSE WE THINK THAT'S REALLY IMPORTANT THAT WE KNOW WHAT YOU DO AND HOW YOU DO IT.
'CAUSE EVERYBODY DOES THINGS A LITTLE DIFFERENTLY IN ROAD AND BRIDGE OF PUBLIC ORDERS.
AND SO THE MORE WE UNDERSTAND ABOUT YOUR OPERATIONS, THE BETTER WE CAN TAILOR THE TRAINING.
SO IN, IN THE, IN, IN THE INITIAL SERVICE REQUEST PRESENTATION, WHERE DOES THAT SERVICE REQUEST GO TO? IS IT LIKE JUST GO TO THE COUNTY WEBSITE AND THERE'S A FORM THERE THEY CAN FILL OUT OR WHAT? YES.
IN THE, IN THE DEMONSTRATION HE SHOWED YOU, YOU THERE'D BE A LINK ON YOUR WEBSITE.
JUST ON THE WEBSITE, NOT ON THE PER UH, IN OTHER WORDS.
HOW, HOW WILL IT BE DIVIDED UP? HOW, HOW WOULD IT BE DIVIDED WHO GETS WHAT WORK ORDER? BECAUSE YOU KNOW, I GET, I I STILL GET WORK ORDERS FOR PRECINCT ONE THROW AND PRECINCT FOUR THROWS BECAUSE MY PRECINCT WAS SPLIT BETWEEN ACTUALLY ALL THREE OF YOU
THAT'S, WE'D HAVE TO, WE'D HAVE TO LOOK, WE'D HAVE TO UNDERSTAND YOUR ENVIRONMENT A LITTLE BIT BETTER TO TRY TO FIGURE THAT OUT.
WELL, IT'S GOING TO HAVE EVERY ROAD FOR EACH PRECINCT IN IT, RIGHT? WELL, I GO, YOU KNOW, IF, IF YOU ROAD, IF YOU, IF YOU WERE TO GIVE ME A SPREAD TWO COLUMN SPREADSHEET OF ALL THE ROAD NAMES IN ONE COLUMN AND RIGHT
[02:05:01]
NEXT TO IT, THE SECOND COLUMN WAS THE PRECINCT.AND WHEN CITIZEN X PICKS, WE ALREADY HAVE THAT.
WHEN CITIZEN X PICKS A ROAD, WE'D KNOW THAT IT'S IN PRECINCT TWO.
AND THEN WE SORT OF FIND ITS WAY TO THE APPROPRIATE PLACE, YOU CALL THEM PRECINCTS.
IN OUR SYSTEM, WE WOULD CALL THEM DEPARTMENTS.
WE WOULD, EACH PRECINCT WOULD REPRESENT A SPECIFIC DEPARTMENT AND WE CAN, WE CAN CREATE A PUBLIC SYSTEM WHERE IT'S, EVEN THOUGH IT'S ONE BIG SYSTEM IF BROKEN INTO, UH, DEPARTMENTS THAT ARE SEPARATE.
UM, AND, AND, UH, IF YOU'RE IN DEPARTMENT A AND I'M IN DEPARTMENT B, I DON'T GET TO SEE YOUR STUFF AND YOU DON'T GET TO SEE MY STUFF.
BUT VICKY, BECAUSE YOU ARE AN ADMIN, LET'S SAY YOU GET TO SEE EVERYTHING.
BUT THAT'S PART OF THE PRE-INSTALL ANALYSIS BUSINESS WHERE WE NEED TO KIND OF UNDERSTAND YOUR ENVIRONMENT, YOUR OPERATION, YOUR DATA A LITTLE BIT BETTER, AND THEN WE CAN, WE CAN OFFER OPTIONS.
THIS IS HOW WE, THIS IS HOW WE THINK WE SHOULD CONFIGURE IT.
WHAT DO YOU THINK WE'LL BE LIKE, NAH, NO, NO.
AND THEN, YOU KNOW, WE'LL DO WHAT YOU WANT US TO DO.
I'M NOT KNOWN TO BE B WE'RE NOT HAVING, THAT'S GOOD.
BUT THE BETTER WE UNDERSTAND YOUR DATA, THE BETTER WE CAN CONFIGURE IT.
AND ALSO WE, WE WANT TO KNOW LIKE WHAT KIND OF, WHAT, WHAT SPECIAL REPORT, WHAT REPORTS DO YOU NEED? AND THEN WE CAN GO THROUGH AND LOOK AND SEE WHETHER WE HAVE, THEN WE KNOW WHETHER WE NEED TO CREATE A COUPLE SPECIAL REPORTS.
THAT'S WHAT WE DID WITH COLIN.
REPORTS, BUT YEAH, WE, WE DETERMINED EARLY ON, YOU KNOW, WHAT WE NEEDED TO DO THAT WAY.
SO THEN WE WANT TO DO ALL THE DATA CONVERSION.
WE WANT TO BRING IN ALL THE GIS DATA AND ALL THE ROADS AND ALL THE LAYERS, AND THEN WE WANT ALL YOUR EQUIPMENT, MATERIALS, UH, UH, VEHICLES, PARTS, YOU KNOW, ALL ALL THAT STUFF.
AND ALL THAT GETS CUSTOMIZED EXACTLY FOR YOU, PRECINCT BY PRECINCT, THE VEHICLES GONNA BE PAID AS WELL AS THE EMPLOYEES BECAUSE YOU KNOW, THEY'RE GONNA BE CHANGING AND MOVING AND RIGHT.
WE'RE GONNA, WE'RE GONNA AUCTION SOMETHING OFF.
WE'RE GONNA CHANGE PRECINCTS ON SOMETHING, YOU KNOW? DEFINITELY.
WHEN WE DID, UH, PETE ACTUALLY DID THIS, THIS TRAINING, BUT WE DID MAKE AND BID GEORGIA, THEY COMBINED THEIR CITY AND COUNTY ABOUT TWO YEARS AGO.
AND THEY'RE BOTH BIG 200,000 EACH.
THEY COMBINED THE CITY AND COUNTY AND COMBINED ALL THE JOBS TOGETHER AND COMBINED ALL THE VEHICLES THAT, AND THEY PUT OUT AN RFP THAT SAID THEY HAD 3000 VEHICLES.
WE WENT IN AND WE WON THAT RFP AND PETE AND ANOTHER BILL JACKSON WENT IN AND WHEN THEY GOT DONE, THEY HAD LIKE 1800 VEHICLES.
'CAUSE THEY HAD 1200 VEHICLES THAT HAD NOT BEEN DISPOSED OF PROPERLY, OR, OR PEOPLE HADN'T CATEGORIZED 'EM, OR, YOU KNOW, AND SO THEY, THEY DIDN'T KNOW ANY OF THAT, UH, BECAUSE THEY HAD AN OLDER, UH, AS 400 MAINFRAME SYSTEM.
AND, AND JUST BY GETTING OUR SOFTWARE IN, UH, THEY WERE ABLE TO REALLY UNDERSTAND WHAT THEY ACTUALLY HAD.
AND ALSO BECAUSE THEY WERE COMBINING A CITY AND A COUNTY TOGETHER INTO A UNIFIED OPERATION.
UH, BUT, UH, YOU KNOW, THAT, THAT'S, THAT'S WHAT HAPPENS WHEN, WHEN YOU GET GOOD DATA CONVERSION AND WE GET ALL THE INFORMATION IN THE SYSTEM, THEN YOU'LL HAVE A REAL HANDLE ON WHAT YOUR CAPITAL ASSETS ARE.
YOU KNOW, WHAT, WHAT VEHICLES NEED TO BE REPLACED OR NOT REPLACED.
UH, THERE'S JUST A LOT OF THINGS THAT CAN, GOOD THINGS THAT CAN HAPPEN ONCE YOU GET THE DATA.
GUYS, I, I'VE GOTTA GO BACK TO TER UH, IF Y'ALL WOULD PUT SOME NUMBERS TOGETHER WHILE WE, YOU KNOW, KEEP IN TOUCH AND GET SOME THINGS TOGETHER, THEN I CAN GET THAT OUT TO EVERYBODY ELSE.
AND IF YOU HAVE ANY MORE QUESTIONS OR WHATEVER EVERYBODY, UH, EMAILING ME OR CALL ME OR SOMETHING, THEN I'LL GET IT TO THEM OR, OKAY.
IS Y'ALL'S INFORMATION THE BILL YOU HANDED OUT TO US? YOU HAVE, UH, YEAH.
OUR WEBSITE, MY STUFF, BUT I, I'LL FOLLOW STUFF FOR, FOR YOU, TERRY.
UH, AND IF ANYBODY, WE CAN GOT AN OPEN AFTERNOON, WE CAN STAY HERE, UH,
AND UH, IF I DIDN'T HAVE ANOTHER MEETING, I'D TAKE Y'ALL LUNCH, BUT I'VE GOTTA GO MEET.