<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Subscribe to Our Blog Stay up to date with the latest tips and news.
Filter By:
Sort By:

Roadblocks to Avoid in Digital Transformation

No matter what industry you work in, getting people on board for big changes is difficult. When workers are used to a certain way of completing a task, it can feel like you're turning their world upside down when you implement a new process into the mix. There are a number of challenges that are involved with any digital transformation of a business whether they are vast or small changes. We've identified a few scenarios that you may encounter in your endeavor to improve your workflow through digital means: 1. Support for your digital transformation dreams Challenge: Drumming up support for digital transformation can be difficult — especially in a large, multi-division utility company that is also highly regulated. Workaround: Get the C-suite on board. Digital transformation tends to be a top-down initiative,  often starting with the CIOs and CEOs. Twenty-eight percent of CIOs own or sponsor digital transformation initiatives, while 23 percent of CEOs do so as well. If you can articulate the value that a digital transformation can have on a company to the higher-ups, it will be a lot easier to get them on board. Remember, some key benefits of this switch are cost reduction, more flexibility while increasing the amount of options that are available for workers and management, and more security for assets and workers. 2. Finding new talent Challenge: According to McKinsey, utilities tend to be perceived as analog-era companies. This makes it hard for them to attract digital-economy professionals like data scientists. Workaround: Don’t focus on hiring data scientists or engineers. Go the no-code route. A no-code platform like AppSheet comes with machine learning baked into its engine, enabling citizen developers—the people who are closest to the data—to leverage powerful machine learning tools and build transformative applications. Put another way, one way to cut costs while not compromising vision is to use no-code. No-code allows you to create your own applications that are specific to your individual needs as long as you have the data to input into our system. 3. Adopting new technologies Challenge: McKinsey also points out that utilities tend to have complex legacy operations and IT environments. These environments tend to inhibit quick innovation. Workaround: Migrate away from legacy systems when it makes sense, in favor of agile, software-defined alternatives. Often, when a company has been around for a while, processes continue to be used that are out-dated and inefficient. Don't allow your company to live in stasis. While it definitely is scary to make a big change in your company, often updating systems cuts costs and increases productivity if implemented in a calm and collected manner. 4. Developing a plan Challenge: Utility companies often launch pilot projects, only to have them fail—wasting time, and resources while creating doubt about the value of digital transformation in the process. Workaround: Proceed with caution. Don’t rush into digital transformation. Drum up support for digital change, form a technology task force, and visit with different department leaders to discover common challenges and investigate digital solutions to them. You wouldn't jump into a body of water before knowing how deep it is right? Same goes with implementing advanced technological systems. It's important to not rush through this work. If you set up things correctly, taking into account possible problems, you will have a solid system that will last a long time and grow with your business. Conclusion Of course, these aren't all of the potential challenges that one might face when implementing digital transformation, but we think it is a good place to jump start your thinking when it comes to presenting these ideas to others in your company. No-code provides powerful software for you to combat problems in your company in ways that you see fit. We hope that you'll consider jumping on this train because it is barreling through the industry fast and missing out will cause a lot of headaches down the line.

Improving Construction Safety

Construction sites can be dangerous. Construction work, by nature, is also physical work. And depending on the type of construction job, employees are often working under conditions where there's a potential to be harmed. According to the OSHA, one in every five worker deaths happens in construction. The top causes of private sector construction fatalities include electrocution, getting struck by an object, and getting caught between objects. These accidents cause 59.9 percent of construction-related deaths. Clearly, worker safety is a very serious matter for construction companies. Providing workers with the proper safety mechanisms can literally be a matter of life and death. To maintain safe working conditions, a growing number of companies are using mobile apps to streamline construction safety. Apps can act as critical liaisons between administrators, field managers, and workers, helping teams share important safety-related information in a way that is fast, convenient, and reliable. Recent advancements in no-code development have also made it possible for construction teams to design, develop, and deploy apps in a way that is easy and affordable. With that in mind, here are some of the top ways that apps can help improve construction safety. Communicating with teams Construction workers are often dispersed across large physical distances, whether they’re in tall buildings, massive warehouses, or enormous lots. Work is usually autonomously performed outside of the sight of a direct manager. Site managers and administrators can use apps to issue critical weather or safety-related alerts, reducing the need to track down employees manually across construction zones. Issuing reminders Injuries can happen when employees get careless about safety requirements. For example, workers may be inclined to remove helmets, gloves, or goggles from time to time. A crew may head into a work zone without enough water during a heat wave. As such, safety reminders should be sent on an ongoing basis to avoid unnecessary lapses in protocol.  Managers can use apps to transmit digital reminders on a daily, weekly, or monthly basis. Managers can also embed digital signature requests to notifications, requiring workers to sign off on important safety checks. These workflows protect both the workers and the company. Improving transparency Site managers are typically responsible for overseeing many workers. It’s important to have a solid understanding of where workers are and what they are doing. However, tracking can be tricky when using non-digital management systems. Apps can be used to communicate team locations and project updates, allowing managers to see exactly where all of their workers are across different sites at any point. For example, a manager could use an app to receive a notification whenever someone from the team enters into a high-risk situation, such as working in a fall zone or transporting heavy or dangerous items. Sharing emergency information No matter how much precaution you take, accidents happen. At some point, something will go wrong and a manager will need to take action.  One challenge facing construction teams is tracking down emergency contacts — especially when working at a remote site away from computers or employee files. Mobile apps can help here, too, by serving as a database where employees can enter family or medical contacts and add notes related to health issues and allergies. Having easy access to this information can be very helpful when emergency action is needed. These are just a few ways that apps can be used to improve construction safety. AppSheet, for instance, offers a sample Safety Reporting App that teams can use to report and log accidents. Check out the construction safety reporting app here: AppSheet also allows you to build custom apps using your company’s data. To experience the power of agile no-code development, try AppSheet today for free.

Feature Friday: Top Ten Empowering Features of the Year

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. To close out 2019, we wanted to highlight the top feature releases of the year. We took this list very seriously, in part because we released so much this year that it made our heads spin. Rather than rehash the data pulls and heart breaks over what made the list, we’ll take you straight to the good stuff.  The Top Ten 10. File Generating Workflows If you work with workflows, chances are you also use the "Save File" feature. Because of its popularity, we grew this feature over the course of 2019 to include custom PDF sizes, .ics calendar invites, and more. To learn more about the “so awesome”capability of this feature, see how the AppSheet Community has been using it. 9. SNAPSHOT() SNAPSHOT() is a new release, but within the first few days of availability it was used more than 3000 times. For those of you that have applications that incorporate daily inspection reports of a worksite or you have large amounts of data displayed in a dashboard that you would like to send to your executive team automatically, this is a great expression to add.  8. Bulk Select The small but mighty action that made a big impact for applications built by everyone in the AppSheet Community, including our staff. With this feature you can scroll through the view highlighting the rows where you want to apply a normal action. If you've never used it before, there's a sample app included below where you can give it a whirl.  7. Data: execute an action on a set of rows As displayed below, there are a number of actions you can take to modify data or navigation within your application. One of the purposes of these action types is to save you time and make your applications more efficient. If you're looking for an automated version of the popular bulk select feature, this action makes that happen. 6. Customizable Dashboards Interactive mode, tabs, and custom sizing all provided new and powerful ways to display your data in this view type. according to fellow Creators, “The dashboards and data analytics side of app sheet is honestly my favorite.” The data supports this too, with tens of thousands of dashboards being added to applications this year.    5. Add a new row to another table using values from this row Released this summer, this action has been a hot topic. With this action you can specify which separate table data should be added to while defining each column added, allowing rows of data to quickly be updated and moved across all tables in your application.  4. Predictive Values Need to estimate the cost of a project or predict customer churn? You'll love predictive values. Technically we released a beta of this feature in late 2018, but we’ve made so many updates to it this year that it was an absolute must to include on this list.  3. Predictive Classification If you've ever wondered why we call ourselves an "Intelligent Platform" this is one of the reasons why. This release plus a little machine learning can help improve your apps in countless ways.    2. Map Point Grouping Maps can become very cluttered very, very quickly. We wanted to help avoid this often frustrating display issue by giving you the option of grouping your pins together or leaving them separate on your map display.  1. Optical Character Recognition (OCR) Extracting information such as prices or names from an image became possible this year. Since the beta release in late July, this feature has been used in thousands of applications making it number one on our list for a reason. It’s highly customizable, powerful, and a complete game changer.    That’s a wrap on the top features of the year! Stop by the AppSheet community to let us know what your favorite feature of the year was.  Thank you all for a fantastic 2019 and a very Happy New Year!   

The Modern Approach to EAM

Utilities, gas, construction, and manufacturing providers are increasingly using custom apps to streamline enterprise asset management (EAM). This makes digital EAM a top technology to watch in 2020 and beyond. Enterprise asset management challenges any large industrial provider. The average company can have hundreds of thousands of assets scattered across multiple locations. These assets include human resources, machines, vehicles, wide area networking components, servers, and more. And each system plays a vital role in the ongoing stability and profitability of the organization. Using software to manage EAM Traditionally, most of these systems and machines operated independently, making it difficult to achieve effective enterprise asset management (EAM) goals. Today, though, more and more industrial providers are moving digital transformation initiatives forward, implementing cutting-edge solutions to oversee the sum of their assets. There are hurdles to the digitization of EAM, however. Off-the-shelf EAM software is very expensive with costs often exceeding $11,000 per user. EAM can be a costly investment for the budget-conscious organization, especially when considering all of the additional technological expenses facing companies today (e.g., data management, the cloud, computers, communications, insurance, and more). It’s possible, however, to build your own EAM apps using a no-code app platform — saving your company thousands of dollars while building a solution that matches your precise needs. The no-code approach to EAM Using a no-code app platform like AppSheet, it’s possible to build individual apps for specific EAM processes. For example, you could build apps to track HR processes, workflows, data management, inventory, and more by merging these functions into a centralized reporting app. Here are some of the benefits that come with using no-code EAM apps. Agile asset tracking One of the problems with out-of-the-box EAM platforms is that they lack the ability to enable you to easily create and track new and custom assets.  By using a no-code EAM platform, however, a company can create specific apps on an as-needed basis. For example, a manufacturing company may decide to start tracking IoT solutions. This could be easily accomplished by taking data from Sheets or Excel and building an app to provide ongoing expense reports.  Fewer errors  Human error remains a major challenge with EAM solutions, which still require physical data entry. It’s very common for data to be entered incorrectly, resulting in inaccurate reporting and untrustworthy results.  No-code EAM eliminates manual data entry by creating a system where information can be entered via digital fields and intuitive drop-down menus. This removes the need to manually transcribe data — increasing data integrity and helping your business make smarter decisions.  If a data value is entered incorrectly on a no-code platform, it’s far easier to detect and correct the mistake. No-code apps offer greater data transparency than traditional paper-based data entry systems. Authorized users can access, review, and update data from any device. Cloud-based management  A study by Software Advice found that 86 percent of EAM buyers prefer a cloud-based EAM solution. This statistic highlights the need for streamlined back-end management and affordable storage. No-code app platforms like AppSheet leverage the cloud to deliver powerful, SaaS-based building functionality. It’s a far more cost-effective approach to running an on-premise EAM solution or hiring developers to build one from scratch for you.  Learn more about AppSheet’s no-code platform.

Feature Friday: Duration, CONTEXT() Updates, and a New Onboarding View

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters.  Duration  Duration is part of the Date and Time expression family and allows you to calculate duration of seconds, minute, or hours. This has been expanded to make it easier to compute intervals in TOTALSECONDS(), TOTALMINUTES(), and TOTALHOURS(). These functions are great ways to track hours worked by your employees or manage duration of time spent on a project.   CONTEXT() Update The function CONTEXT(option) is used to return a Text value that indicates where in the app this expression is being used. It's useful for "meta-data" operations but in a rather limited scope. We've expanded the functionality to include a fourth option, CONTEXT("AppName"). You can take a deeper dive into the technical side of CONTEXT() functions in reviewing this help document.  Coming Soon: New Onboarding View  The “About View” that your users currently interact with is rather static. To improve the experience for onboarding those that use your applications, keep an eye out for a soon to be released “Onboarding View.” You’ll have multiple pages for content, swiping capabilities and more.  Top Features of the Year  Next week we will be releasing our list of the Top Ten Features of the Year. stay tuned to see if your favorite made the list!    How will you use these new features in what you’re creating? Stop by the AppSheet community and let us know! Happy app building!

Year in Review: AppSheet 2019

Another amazing year is in the books and we couldn’t be more thankful to our devoted app creators and community. This year, we greeted over 100k new app creators and 190k new app users. Welcome to the family, everyone. And, wow, have you all been busy! In 2019, app creators produced over 490,000 new mobile and desktop applications. That’s an app created nearly every minute. Also, we're now deployed in over 190 countries. Recently, we’ve made it even easier for AppSheet creators to share the love. Check out our new resources page for an array of tools that will help you inspire your team to build apps, digitize processes, and grow your productivity. Speaking of growth, let’s take a moment to highlight the AppSheet team. At the start of 2019, we had 17 full-—time employees in our Seattle office. Now, we total more than 40 employees in Seattle, plus part-time team members spread all around the world. We will carry this ethos into 2020 and continue our commitment to personalized customer experience. As always, the AppSheet User Community remained the place for our most vibrant, engaged, and enthusiastic platform advocates. We now have over 17.5k community members who published a total of 30k posts and comments. This is the place where users and AppSheet team members connect and work to improve the platform — this ecosystem has always been important to us and we look forward to working with all of you in the new year. The AppSheet platform has also experienced tremendous growth. In 2019, over 50 new features were introduced with expanded functionality across all areas. We’ve improved each facet of our platform with special emphasis on UI richness, enterprise capabilities, machine learning, and artificial intelligence. To learn more about how no-code platforms bring machine learning and AI technology to businesses of all sizes, read our new white paper, “Why the Future of Machine Learning is No-Code”. This year certainly has been a whirlwind of positive change and we can’t wait to keep the momentum rolling into the new decade. Here’s to a happy, healthy 2020 to our AppSheet community near and far! Finally, check out some more statistics from the past year: Most popular sample apps Explore & copy sample apps to get your project started Inventory Management Stock Management Order Capture Manufacturing Inventory Sales Report Work Order Store Inventory Quote and Proposal Project Management Top 5 new features in 2019 OCR  Map Point Grouping   Predictive Classification  Predictive Values Add a new row to another table using values from this row  Most common app use case  

Construction Management Programs in the United States

At AppSheet, a huge part of our mission is to help professionals excel in their careers. No matter your industry, we provide the platform to help you work better and innovate on the job. Our blog also serves as a resource for industry trends, workplace inspiration, and ideas for career continuing education.   This post is the first in a series where we'll index popular continuing education programs by industry. This week, we share a database of construction management programs in the United States. If you want to start a construction management career or expand on your established career in construction, start your research of programs right here. In typical AppSheet fashion, we’ve converted the database into an easy-to-use application. Explore construction programs by state or use the map tab to locate a construction school near you. You can also search the app to pull up programs by degree type (certificate, associate, bachelor, or even PhD) or keyword. Click into the program to find a description, address, and link to the program website. In addition to construction management programs, the database includes information for other construction degrees such as those in green buildings, building construction technology, sustainable construction, building inspection, and more. Check out the app embedded below. Click on the "details" tab or visit the construction program app page to copy it for use on your own phone, table, or laptop. We'll continuously update this app, so check back if you don't find the right program for you! Construction management programs by state California Cosumnes River College A.S. in Construction Management Technology Degree type: Associate Program description: This program offers training of management-level employees for the construction industry, as well as preparation for transfer to a four-year college or university construction program. Graduates may be employed by contractors, business and government agencies for work in project planning, estimating and project coordinating. A student planning to transfer to a four-year college or university should consult the lower division requirements of the anticipated college program. Construction Management Technology Certificate Degree type: Certificate Program description: This CRC program offers training of management-level employees for the construction industry, as well as preparation for transfer to a four-year college or university construction program. Graduates may be employed by contractors, business and government agencies for work in project planning, estimating and project coordinating. A student planning to transfer to a four-year college or university should consult the lower division requirements of the anticipated college program. Green Buildings Certificate Degree type: Certificate Program description: The purpose of this certificate is to develop job skills and an understanding of green strategies for high performance buildings and livable communities. It is focused at students and professionals in the fields of architecture; construction; building management; construction management; building inspection; design technology; landscape; and planning, who want to acquire a comprehensive knowledge of an integrated, economic life-cycle approach to the design of the built environment. It includes study of green rating systems, material choices and environmental strategies for a livable, sustainable future. American River College Building Trades and Construction Associate Degree Degree type: Associate Program description: The STRIPE Pre-apprenticeship program teaches you basic construction skills and introduces the building trades. In an apprenticeship, you’ll receive on-the-job training, paid employment, and instruction in many industrial processes and building methods.  Building Trades and Construction Certificate Degree type: Certificate Program description: The STRIPE Pre-apprenticeship program teaches you basic construction skills and introduces the building trades. In an apprenticeship, you’ll receive on-the-job training, paid employment, and instruction in many industrial processes and building methods.  Sierra College Construction Management Degree type: Certificate Program description: Do you love working with your hands? Learn everything from job safety to construction skills. Get in-demand skills in our hands-on classes including electrical, plumbing, carpentry and solar energy. Construction Basics Skills Certificate Degree type: Associate Program description: Do you love working with your hands? Learn everything from job safety to construction skills. Get in-demand skills in our hands-on classes including electrical, plumbing, carpentry and solar energy. Energy Surveying and Lighting Retrofits Degree type: Certificate Program description: Do you love working with your hands? Learn everything from job safety to construction skills. Get in-demand skills in our hands-on classes including electrical, plumbing, carpentry and solar energy. Victor Valley College Photovoltaic Technician Program Degree type: Certificate Program description: Construction Technology’s Photovoltaic Technician Program teaches students the knowledge and skills needed to enter this fast-growing industry. Building construction technology Degree type: Associate Program description: The Construction Technology program provides preparation for a wide variety of positions in the construction field as a contractor, supervisor, building inspector, or tradesperson. The program offers the opportunity to be self-employed and the pride and satisfaction of creating and building with your own hands. Florida Florida State College at Jacksonville Building construction technology Degree type: Associate Program description: The Associate in Science (A.S.) in Building Construction Technology degree program prepares students for a rewarding career in the all encompassing construction fields for both residential and commercial construction. Designed to prepare the students for numerous industry standards and practical certifications, instruction consists of academic as well as laboratory and hands-on training. Upon successful completion, students will be qualified for a position as an entry-level building construction technician, responsible for performing a variety of job functions, from hands-on work to supervision. Michigan Michigan State University Bachelor of Science in Construction Management Degree type: Bachelor's Program description: The Construction Management major is nationally accredited by the American Council for Construction Education since 1999. It is one of the earliest established construction management programs in the nation. Core areas of study include: Project management; Site planning and development; Building materials and structure; Information Modeling (BIM); Planning, scheduling and project control; Commercial, residential and heavy construction; Building construction systems; contracts and documents; Construction safety and protection; Quantity takeoffs, estimating and accounting; Construction business and finance; Energy efficiency and sustainability. Master of Science in Construction Management Degree type: Master's Program description: The Construction Management Master of Science degree is designed to provide breadth in the managerial, technological, economic and environmental aspects of construction. The program is also designed to provide depth and breadth through a systems approach encompassing project management, estimating, scheduling and project controls, housing, land acquisition and development, architectural and engineering design, construction technology, real estate, finance, business management and marketing. PhD Concentration in Construction Management Degree type: PhD Program description: The Doctor of Philosophy in Planning, Design and Construction with a concentration in construction management will enable SPDC students to meet future challenges. The doctoral program is designed to focus on scholarly research, and combine the technical and managerial aspects of construction projects. This program is designed to provide the depth and breadth in the managerial, technological, economic and environmental aspects of construction. The aim of this degree is to prepare students to become globally engaged citizen-leaders and scholars in the built environment. Minnesota University of Minnesota Bachelor of Applied Science in Construction Management Degree type: Bachelor's Program description: Our mission is to prepare future construction leaders to sustainably manage the built environment. Founded in 1997, the program has gained significant support from industry and alumni over our program's history, blending technology and management into a well-rounded yet flexible curriculum. Construction Management Certificate Degree type: Certificate Program description: Designed and taught by industry professionals, the program focuses on management skills necessary for success in the construction industry. You'll gain essential skills and knowledge in estimating documents; scheduling contracts; planning project execution; measuring results and ensuring quality; and managing projects. Montana University of Montana Sustainable Construction Technology Certificate of Applied Science Degree type: Certificate Program description: The mission of the Sustainable Construction Technology Program is to provide the regional workforce with credentialed, skilled and competent individuals who are responsive to emerging workforce needs. Certificate of Applied Science Degree type: Associate Program description: The Sustainable Construction Technology program provides students the opportunity to learn sustainable construction skills in a competency-based learning environment. Students work hand-in-hand with professionals both on campus and at construction sites. Certificate of Applied Science - Construction Management Degree type: Certificate Program description: The program provides students the opportunity to learn construction skills in a competency based learning environment. In addition to general education courses, students in the program learn the various steps of becoming a successful tradesperson in the construction industry, including safe practices, management and skills competencies. Students construct real world projects and can earn a Certificate of Applied Science and continue for another year to earn an Associate of Applied Science Degree. New York Alfred State University Construction Engineering Technology Degree type: Associate Program description: The program in construction engineering technology includes a well-designed balance of theoretical and laboratory studies, providing students with a broad knowledge of civil engineering technology and the construction fields. This field is expanding rapidly, and our technical curricula will give you a broad-based education, as well as the hands-on skills and experience needed for leadership in today’s construction business. Construction Management Degree type: Bachelor's Program description: Do you dream of a leadership role in the construction industry? Then this program is for you. Our expert faculty have designed a series of courses that will familiarize you with all aspects of construction management. Technical course work is combined with specific construction management courses as well as several business courses, giving you a broad-based education. Pennsylvania Pennsylvania College of Technology Residential Construction Technology & Management: Architecture Concentration Degree type: Bachelor's Program description: With a degree in Residential Construction Technology & Management, you’ll explore architecture and design principles and master industry-standard software like AutoCAD. Pair these hands-on skills with residential construction management courses and you’ll be real-world ready. Residential Construction Technology & Management: Building Construction Technology Concentration Degree type: Bachelor's Program description: This bachelor-level program lays the framework in residential construction. Studying everything from layout to materials and methods, you’ll learn what it takes to build a home and a career. Management courses on topics like estimating, scheduling, and code compliance coupled with leadership-building experience fuel your momentum to play a leading role in this dynamic field. Building Construction Technology Degree type: Associate Program description: Plan, design, and execute homes and smaller-scale commercial buildings. From estimating and layout to material selection and safety considerations, coursework taps into all phases of the construction process from start to finish. Concrete Science Technology Degree type: Associate Program description: From buildings to bridges, concrete is everywhere. Concrete science experts are in demand. In this program, you’ll analyze the properties of concrete. Explore admixture techniques. And learn which type is best suited for the job at hand. The only one of its kind on the East Coast, this industry-driven major pulls together science, technology, and construction to deliver the specialized skillset that employers need most. Construction Management Degree type: Bachelor's Program description: When you come to Penn College, you’ll leave prepared. With the vision and technical know-how to build a better tomorrow. As a construction manager, you’ll be a major player in seeing construction projects from concept through completion. You’ll tackle estimating and planning. Oversee purchasing. Manage subcontractors. Supervise staff. And best of all, you’ll have a job waiting for you post-graduation. Actually, the vast majority of our students have offers before tossing their caps! Utah Weber State University Construction Management Degree type: Bachelor's Program description: Program Prerequisite: Declare a Program of Study in Construction Management Construction Management Degree type: Associate Program description: Grade Requirements: A grade of “C” or better in all major courses, business courses, and support courses is required (a grade of “C-” is not acceptable) in addition to an overall GPA for all courses of 2.00 or higher. Utah Valley University Construction Management Degree type: Bachelor's Program description: This program provides courses in building construction, construction management and construction science that apply to all segments of the construction industry with an emphasis on heavy civil and commercial construction. Facilities Management Degree type: Associate Program description: This program is designed to prepare graduates to manage physical facilities such as resorts, health care centers, government facilities, recreational complexes, schools, industrial plants, and apartment buildings. Cabinetry & Architectural Woodworking Degree type: Associate Program description: This program prepares students to find employment in factory production, set-up milling, assembling, and installing highly customized cabinetry in residences, banks, department stores, and restaurants. Construction Management Degree type: Certificate Program description: A Certificate of Completion for students seeking an applied education in construction. The courses can lead the students who desire to further their education towards the AAS and/or BS degree in Construction Management. Cabinetry & Architectural Woodworking Degree type: Certificate Program description: This program prepares students to find employment in factory production, set-up milling, assembling, and installing highly customized cabinetry in residences, banks, department stores, and restaurants. Washington Renton Technical College Construction Management Degree type: Certificate Program description: The Construction Management program offers students important administrative and personnel skills to become successful project managers, superintendents, estimators and more. Some the skills covered include reading and interpreting drawings, estimating costs, sequencing work activities and applying technology to measure results. Students can enroll on a part-time or full-time basis. Construction Management Degree type: Associate Program description: The Construction Management program offers students important administrative and personnel skills to become successful project managers, superintendents, estimators and more. Some the skills covered include reading and interpreting drawings, estimating costs, sequencing work activites and applying technology to measure results. Students can enroll on a part-time or full-time basis. Clover Park Technical College Construction Trades Academy Pre-Apprenticeship Program (C-TAPP) Certificate Degree type: Certificate Program description: This apprenticeship readiness program prepares students with the knowledge and skills necessary for employment in the construction industry. This one-quarter program covers safety, hand and power tool use, math, carpentry trades, print and plan reading, and employment preparation. Students entering the one-quarter Pre-Apprenticeship Construction Trades program will be required to complete entry and quarterly assessments while enrolled in the program. These assessments will not determine eligibility for the program. Construction Technologies Associate of Applied Technology Degree / Associate in Applied Science – T Degree Degree type: Associate Program description: This program is designed to train construction professionals and facilities managers for building applications and systems that consume a minimal amount of non-renewable resources and contribute to environmental and personal health. This program will prepare graduates for careers in resource energy management, indoor air quality, solar installation, home energy rating systems, and other specialties that support the design, building, and maintenance of sustainable living environments. Construction Technology Certificate Degree type: Certificate Program description: This certificate program builds on the knowledge and skills students earn in the C-TAPP certificate, which serves as the first quarter of the program, and provides an introduction to residential construction technologies. Grays Harbor College Carpentry Technology Degree type: Associate Program description: The Carpentry Technology program teaches the fundamental skills required for those seeking a career in construction or career advancement. Those wishing to explore carpentry as a career and those with personal interests in carpentry are also welcome. Students receive hands-on training with the tools of the trade in the various phases of residential construction, as well as building codes, drawings, estimation, math, and layout. Strong emphasis is placed on work habits and safety. Carpentry Technology Degree type: Certificate Program description: The Carpentry Technology program teaches the fundamental skills required for those seeking a career in construction or career advancement. Those wishing to explore carpentry as a career and those with personal interests in carpentry are also welcome. Students receive hands-on training with the tools of the trade in the various phases of residential construction, as well as building codes, drawings, estimation, math, and layout. Strong emphasis is placed on work habits and safety. Edmonds Community College Construction Management Associate of Technical Arts Degree Degree type: Associate Program description: The Construction Management Associate of Technical Arts Degree program is primarily designed for students with experience in some phase of the construction industry who want to specialize in construction project management. The program is designed to meet the needs of the working student. Most courses are offered in the evening. Certificate in Building Inspection Degree type: Certificate Program description: The certificate in Building Inspection is designed for students interested in, or presently employed in, the building inspection field. The program is designed to meet the needs of the working student. Most courses are offered in the evening. Construction Management Certificate Degree type: Certificate Program description: The Construction Management Certificate program is primarily designed for students with experience in some phase of the construction industry who want to specialize in construction project management. The program is designed to meet the needs of the working student. Most courses are offered in the evening. This certificate requires successful completion of a minimum of 58 credits as outlined. Civil Construction Management and Inspection Certificate Degree type: Certificate Program description: The Civil Construction Management and Inspection Certificate program is primarily intended for students with experience in the construction industry who want to specialize in road or utility construction project management or inspection. The program is designed to meet the needs of the working student. Most courses are offered in the evening. This certificate requires successful completion of a minimum of 47 credits as outlined.

New Horizons for Digital Transformation in Oil and Gas

In the oil and gas sector, extracting valuable resources and transforming them into usable assets is the name of the game. The digital transformation of this industry is not all that different. Incorporating technologies into the oil and gas sectors is all about extracting value in areas that are either under served or reliant on outdated systems and processes. In other words, digital transformation involves using technologies to make an a oil and gas company operate more efficiently. This work leads to greater output and improved financial performance.  Digital transformation is impacting all areas of the global oil and gas industries, including exploration and production (E&P) companies that search for hydrocarbon reservoirs, drill and sell raw materials; drilling companies that contract with E&P companies; refineries that purchase and manufacture energy products; well-servicing companies that construct and maintain drilling rigs; shipping companies that transport materials to global distribution centers; and regulatory bodies that govern all of the above organizations. Basically, everyone is turning their heads toward technology to provide solutions for issues in their businesses. Here are some specific examples of how digital transformation can impact the oil and gas sector today: A new reservoir of resources Before a company can start drilling, a team of engineers must plan ahead to form a safe and operationally efficient strategy that is also cost-effective. Drilling engineers create these plans, using a combination of engineering specialties, including completion engineering, operational engineering, production engineering, and reservoir engineering. Technological advancements in drilling engineering are helping companies tap into new reservoirs of natural gas and oil that were previously inaccessible. In the past, companies were typically confined to depths of about 30 meters when drilling for oil and gas. Now, companies are using extended reach drilling and advanced stimulation technology to better understand rock and fluid interactions. As a result, companies can drill deeper and more effectively than ever — all while reducing their environmental footprint. There are two types of well stimulation practices: Matrix stimulation, which involves acidizing wellborne areas in order to dissolve dolomite and limestone formations and make the reservoir rock more permeable. Hydraulic stimulation, which is the more common approach and involves forcing open fissures in subterranean rock formations using high pressure liquid in order to extract natural resources. Advancements in stimulation software have made it possible to create and execute well stimulation projects. MFrac, for instance, is a leading hydraulic program, while STIMPRO is used commonly for matrix acidizing analysis. Fabricating toward the future In the ultra-competitive oil and gas industry, time is critical for success. Broken parts need to be fabricated and replaced rapidly — especially in something like a central delivery point (CDP), where several different operators may use the same CDP system to process gas, separate natural gas liquids and different pressure gasses, and scrub hydrocarbons. Downtime in this type of system can impact multiple operations, driving the need for fast and cost-effective repairs. Over the past few years, oil and gas companies have been increasingly relying on additive engineering or 3D printing to enable affordable and timely part fabrication; 3D printing also makes it possible to manufacture parts locally, reducing travel time, and lowering total repair costs. For example, an oil rig in the Persian Gulf no longer has to ship a product from a plant in China or the U.S. Now, that part can be manufacured on-site. Looking forward, 3D printing will play a massive role in digital transformation for the oil and gas industry.  The key idea to remember when thinking about technology integration is that it should always be agency-driven. Integrating technology into your industry shouldn't be limiting your choices, it should be expanding them. 3D printing has allowed business to create parts for themselves so there is less time waiting on others to complete jobs. Finding new technological horizons for refining While we think that adopting technologies into one's business is invaluable in this current age, that doesn't mean that industry professionals always know how or why they should do it. The refining industry is at a crossroads right now with cracking the code for how they can use digital transformation to grow their businesses. Digitization is occurring in the refinery sector, albeit slowly. According to Accenture, 50 percent of oil refiners consider themselves to be digital or semi-digital. But there is little evidence of advanced digital maturity beyond pilots and proofs of concept. “Most refineries have not moved beyond basic digital technologies like cloud technologies or next-generation advanced process control,” Accenture says. “More cutting-edge technologies like artificial intelligence, mixed reality, and edge computing are still not prevalent.” Right now, there are three major hurdles inhibiting digital adoption for refineries: Budgetary restrictions, a lack of strategy, and a lack of digital skills in the refinery workforce. “By failing to grow their digital operations, there is still significant potential value which refiners are not realizing,” Accenture continues. A good start for any refining business is to work through what problems they'd like to find digital solutions for. Then, begin documenting the data they currently have on that problem. No-code application development is able to start solving so many problems as long as you're able to input the data in a cleanly-formatted, and standardized manner. Machine learning improves R&D processes E&P companies need to know where to drill for oil. To determine the best locations, they rely on geophysical data gleaned from geophysicists, who conduct surveys using digital sensing instruments, which extract information from above and below the Earth’s surface. Over the last two decades, we have seen dramatic advances in geophysical software and instruments. Today, geophysicists are using advanced seismic processing solutions, prestack seismic interpretation, depth imaging, and quantitative predictive interpretation in order to figure out where to move their operations. Looking forward, artificial intelligence (AI) and similar technologies will play a massive role in helping geophysicists process the vast amounts of data they are collecting on a daily basis. In one example, machine learning is being applied to analyzing well log data. “Reliably predicting lithology becomes one of the key problems in reservoir characterization,” explains data scientist Tannistha Maiti. “In practice, combination of physical models, local geological knowledge, and experience to reduce large seismic and well log datasets into low-dimensional models of the Earth are used. Unfortunately, these simplified physical and geological assumptions do not always hold true in practice, making the inferred model highly uncertain and biased.” “This problem can be reformulated using general machine learning models,” Maiti continues. “Hence, it would be a good idea to predict the lithologies of the huge well dataset in a basin with some algorithms.” Machine learning is being implemented across industries because of its power and adaptability. Not only is it streamlining work processes, but it’s future-proofing businesses by growing with the data that is collected as opposed to only updating when a technician releases a new iteration of the software. Safety can improve with digital transformation Oil and gas companies are under enormous pressure to ensure their systems are operationally sound. This is critical for both personal and environmental safety. The BP oil explosion, for instance — which killed 11 people and resulted in one of the greatest environmental disasters of all time — was partially the result of valve malfunctions, leaks, and misinterpreted pressure tests. Technology is playing a much bigger role today in helping companies avoid this type of issue. Connected devices and sensors, for example, can now be embedded directly into various parts of a well and transmit data back for analysis. Advancements in big data and AI are also helping crew members notice trends and predict when equipment should be checked or repaired. It's easy to forget just how much new technologies play in making work environments safer, if implemented carefully and consciously. One of the first thoughts for any business wanting to digitally transform their business should be: how will this make my business and workers more safe? Conclusion We've covered a few key areas of oil and gas that have potential to improve through incorporating technology. All of these hurdles can be overcome with careful planning, and a conscious effort in trying to make your business run more smoothly and efficiently while also keeping your worker's safety in mind. The first step is always the hardest, but we hope this inspires you dig a little deeper, you'll be surprised what good things you'll bring to the surface!  

Feature Friday: Intersect, Table Sorting, and ICS Calendar

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters.    INTERSECT() Are you a list person? If so, then you probably have a few lists running with common items that you wish you could manage differently. We’d like to give you a bit of sanity back by introducing you to our INTERSECT() function.  Whether you're managing inventory or events, you’re going to want to go straight to your editor and add this function. It takes all the elements which are common to both of the original lists and stores them in another list. The newly created list becomes a summary of the elements that we similar.  Our community has had a few days to work with this feature and has some great suggestions on how to implement this new expression. To learn more stop by the AppSheet Community.  Table Sorting in Dashboards A small but mighty feature, this update allows Tables displayed in Dashboards to be sorted by their headers. Previously, Tables that displayed in Dashboards were relatively static. This new capability, however, provides a more interactive way to present your data.  We introduced this update in our new and improved Office Hours this week. If you missed the session, we've got you covered.    ICS Calendar Attachments   We're expanding the options available for the file types that can be sent in your workflows. The latest addition is the ICS Calendar (also known as .ics) which allows you to send calendar invitations in an email message. If you've received a meeting request or event invitation in an email, you've used .ics before.  This workflow update can be used for sending calendar information for everything from formal meeting requests to surprise party invites. Information sent in your .ics file can include location, date, time and more. To learn more about working with workflows, review our workflow support series.  How will you use these new features in what you’re creating? Stop by the AppSheet community and let us know! Happy app building!

2of54

How to Build an App to Manage Your Event

From conferences, open houses and fundraisers to weddings, birthday parties, and holiday get togethers, events take a ton of planning. You may be the event coordinator for your organization ...

Construction Management: Buy Off-the-Shelf or Build Your Own Apps?

Digital technology is changing industries and their players. Smartphones and mobile apps have made it easy for companies across verticals to do business in new, more efficient, and customer-...