Disadvantages of Spreadsheets – Obstacles to Compliance in the Healthcare Industry

Most of the regulatory compliance issues we talked about concerning spreadsheets have been related to financial data. But there are other kinds of data that are stored in spreadsheets which may also cause regulatory problems in the future.

In the US, a legislation known as HIPAA or Health Insurance Portability and Accountability Act is changing the way health care establishments and practitioners handle patient records. The HIPAA Privacy Rule is aimed at protecting the privacy of individually identifiable health information a.k.a. protected health information (PHI).

Examples of PHI include common identifiers like a patient’s name, address, Social Security Number, and so on, which can be used to identify the patient. HIPAA covers a wide range of health care organisations and service providers, including: health plan payers, health care clearing houses, hospitals, doctors, dentists, etc.

To protect the confidentiality, integrity, and availability of PHI, covered entities are required to implement technical policies such as access controls, authentication, and audit controls. These can easily be implemented on server-based systems.

Sad to say, many health care organisations who have started storing data electronically still rely on spreadsheet-based systems. Those policies are hard to implement in spreadsheet-based systems, where files are handled by end-users who are overloaded with their main line of work (i.e. health care) and have very little concern for data security.

In some of these systems, spreadsheet files containing PHI may have multiple versions in different workstations. Chances are, none of these files have any access control or user authentication mechanism whatsoever. Thus, changes can easily be made without proper documentation as to who carried out the changes.

And because the files are normally easily accessible, unauthorised disclosures – whether done intentionally or accidentally – will always be a lingering threat. Remember that HIPAA covered entities who are caught disclosing PHI can be fined from $50,000 up to $500,000 plus jail time.

But that’s not all. Through the HITECH Act of 2009, business associates of covered entities will now have to comply with HIPAA standards as well. Business associates are those companies who are performing functions and services for covered entities.

Examples of business associates are accounting firms, law firms, consultants, and so on. They automatically need to comply with the standards the moment they too deal with PHI.

 

More Spreadsheet Blogs

 

Spreadsheet Risks in Banks

 

Top 10 Disadvantages of Spreadsheets

 

Disadvantages of Spreadsheets – obstacles to compliance in the Healthcare Industry

 

How Internal Auditors can win the War against Spreadsheet Fraud

 

Spreadsheet Reporting – No Room in your company in an age of Business Intelligence

 

Still looking for a Way to Consolidate Excel Spreadsheets?

 

Disadvantages of Spreadsheets

 

Spreadsheet woes – ill equipped for an Agile Business Environment

 

Spreadsheet Fraud

 

Spreadsheet Woes – Limited features for easy adoption of a control framework

 

Spreadsheet woes – Burden in SOX Compliance and other Regulations

 

Spreadsheet Risk Issues

 

Server Application Solutions – Don’t let Spreadsheets hold your Business back

 

Why Spreadsheets can send the pillars of Solvency II crashing down

?

Advert-Book-UK

amazon.co.uk

?

Advert-Book-USA

amazon.com

 

Check our similar posts

ecoVaro to tackle water stress

For many people within the UK, water is not really something to worry about. Surely enough of it falls out the sky throughout the year that it does feel highly unlikely that we?ll ever run out of it. There certainly does seem to be an abundance of Branded Water available in plastic bottles on our supermarket shelves.

Water, water, every where,
And all the boards did shrink;
Water, water, every where,
Nor any drop to drink.

The Rime of the Ancient Mariner ? Samuel Taylor Coleridge

Despite this, Once-unthinkable water crises are becoming commonplace.  If you consider that In England and Wales, we use 16 billion litres of clean drinking water every day ? that’s equivalent to 6,400 Olympic sized swimming pools.

Currently, water companies can provide slightly more than we need ? 2 billion litres are available above and beyond what we’re using.  In some areas, though, such as south east England, there is no surplus and, as such, these regions are more likely to face supply restrictions in a dry year.

If we take little moment to reflect on some of the most notable water related stories over the past few years, we’ll start to get a picture of just how real the potential and the threat of water shortages can be.

Reservoirs in Chennai, India?s sixth-largest city, are nearly dry right now. Last year, residents of Cape Town, South Africa narrowly avoided their own Day Zero water shut-off.

It was only year before that, Rome rationed water to conserve scarce resources.

Climate change is likely to mean higher temperatures which may drive up the demand for water (alongside population growth) and increase evaporation from reservoirs and water courses during spring and summer.

The impact of climate change on total rainfall is uncertain, but the rain that does fall is likely to arrive in heavier bursts in winter and summer. Heavier rain tends to flow off land more quickly into rivers and out to sea, rather than recharging groundwater aquifers.

A greater chance of prolonged dry periods is also conceivable.  This combined with the harsh reality that no human population can sustain itself without sufficient access to fresh water.

If present conditions continue, 2 out of 3 people on Earth will live within a water-stressed zone by 2025

What is water stress?

Water stress is a term used to describe situation when demand for water is greater than the amount of water available at a certain period in time, and also when water is of poor quality and this restricts its usage. Water stress means deterioration in both the quantity of available water and the quality of available water due to factors affecting available water.

Water stress refers to the ability, or lack thereof, to meet human and ecological demand for water. Compared to scarcity, water stress is a more inclusive and broader concept.

Water Stress considers several physical aspects related to water resources, including water scarcity, but also water quality, environmental flows, and the accessibility of water.

Supply and Demand

Major factors involved when water scarcity strikes is when a growing populations demand for water exceeds the areas ability to service that need.

Increased food production and development programs also lead to increased demand for water, which ultimately leads to water stress.

Increased need for agricultural irrigation in order to produce more crops or sustain livestock are major contributors to localised water stress.

Overconsumption

The demand for water in a given population is fairly unpredictable.  Primarily, based on the fact that you can never accurately predict human behaviour and changes in climate.

If too many people are consuming more water than they need because they mistakenly believe that water is freely available and plentiful, then water stress could eventually occur.

This is also linked to perceived economic prosperity of a give region.  Manufacturing demand for water can have huge impact regardless whether water is actively used within the manufacturing process or not.

Water Quality

Water quality in any given area is never static.  Water stress could happen as a result of rising pollution levels having a direct impact on water quality.

Water contamination happens when new industries either knowingly or unknowingly contaminate water with their industrial practices.

Largely, this can happen and frequently does so because these industries do not take effective control of monitoring and managing their impact on communal water supplies.  Incorrectly assuming this is the responsibility of an additional third party like the regional water company.

The truth is, water quality and careful monitoring of it is all of our responsibility.

Water Scarcity

Simple increases in demand for water can in itself contribute to water scarcity. However,  these are often preceded by other factors like poverty or just the natural scarcity of water in the area.

In many instances, the initial locations of towns or cities were not influenced by the close proximity of natural resources like water, but rather in pursuit of the extraction of other resources like Gold, Coal or Diamonds.

For Instance, Johannesburg,  South Africa is the largest City in South Africa and is one of the 50 largest urban areas in the world. It is also located in the mineral rich Witwatersrand range of hills and is the centre of large-scale gold and diamond trade.

Johannesburg is also one of the only major cities of the world that was not built on a river or harbour.   However, it does have streams that contribute to two of Southern Africas mightiest rivers – Limpopo and the Orange rivers.  However, most of the springs from which many of these streams emanate are now covered in concrete!

Water Stress and Agriculture

Peter Buss, co-founder of Sentek Technology calls ground moisture a water bank and manufactures ground sensors to interrogate it. His hometown of Adelaide is in one of the driest states in Australia. This makes monitoring soil water even more critical, if agriculture is to continue. Sentek has been helping farmers deliver optimum amounts of water since 1992.

The analogy of a water bank is interesting. Agriculturists must ?bank? water for less-than-rainy days instead of squeezing the last drop. They need a stream of real-time data and utilize cloud-based storage and processing power to curate it.

Sentek?s technology can be found in remote places like Peru?s Atacamba desert and the mountains of Mongolia, where it supports sustainable floriculture, forestry, horticulture, pastures, row crops and viticulture through precise delivery of scarce water.

This relies on precision measurement using a variety of drill and drop probes with sensors fixed at 4? / 10cm increments along multiples of 12? / 30cm up to 4 times. These probe soil moisture, soil temperature and soil salinity, and are readily repositioned to other locations as crops rotate.

Peter Buss is convinced that measurement is a means to an end and only the beginning. ?Too often, growers start watering when plants don’t really need it, wasting water, energy, and labour. By accurately monitoring water can be saved until when the plant really needs it.

Peter also emphasises that crop is the ultimate sensor, and that ?we should ask the plant what it needs?.

This takes the debate a stage further. Water wise farmers should plant water-wise crops, not try to close the stable door after the horse has bolted and dry years return.

The South Australia government thinks the answer also lies in correct farm dam management. It wants farmers to build ones that allow sufficient water to bypass in order to sustain the natural environment too.

There is more to water management than squeezing the last drop. Soil moisture goes beyond measuring for profit. It is about farming sustainably using data from sensors to guide us.

Ecovaro is ahead of the curve as we explore imaginative ways to exploit the data these provide for the common good of all.

A Quarter of the World?s Population, Face High Water Stress

Data from WRI?s Aqueduct tools reveal that 17 countries ? home to one-quarter of the world?s population?face ?extremely high? levels of baseline water stress, where irrigated agriculture, industries and municipalities withdraw more than 80% of their available supply on average every year. 

Water stress poses serious threats to human lives, livelihoods and business stability. It’s poised to worsen unless countries act: Population growth, socioeconomic development and urbanization are increasing water demands, while climate change can make precipitation and demand more variable.  

How to manage water stress

Water stress is just one dimension of water security. However, like any challenge, its outlook depends on adequate monitoring and management of environmental data.

Even countries with relatively high water stress have effectively secured their water supplies through proper management by leveraging the knowledge they have garnered by learning from the data they gathered.

3 ways to help reduce water stress

In any geography, water stress can be reduced by measures ranging from common sense to innovative technology solutions.

There are countless solutions, but here are three of the most straightforward:

1. Increase agricultural efficiency: The world needs to make every drop of water go further in its food systems. Farmers can use seeds that require less water and improve their irrigation techniques by using precision watering rather than flooding their fields.

Businesses need to increase investments to improve water productivity, while engineers develop technologies that improve efficiency in agriculture.

Consumers can reduce food loss and waste, which uses one-quarter of all agricultural water.

2. Invest in grey and green infrastructure:  D Data produced by Aqueduct Alliance  –  shows that water stress can vary tremendously over the year.  WRI and the World Bank?s research shows that built infrastructure (like pipes and treatment plants) and green infrastructure (like wetlands and healthy watersheds) can work in tandem to tackle issues of both water supply and water quality.

3. Treat, reuse and recycle:  We need to stop thinking of wastewater as waste.

Treating and reusing it creates a ?new? water source.

There are also useful resources in wastewater that can be harvested to help lower water treatment costs. For example, plants in Xiangyang, China and Washington, D.C. reuse or sell the energy- and nutrient-rich byproducts captured during wastewater treatment.

Summary

The data is undeniably clear, there are very worrying trends in water.

Businesses and other other organisations need to start taking action now and investing in better monitoring and management, we can solve water issues for the good of people, economies and the planet. We collectively cannot kick this can down the road any further, or assume that this problem will be solved by others.

It is time, for a collective sense of responsibility and for everyone to invest in future prosperity of our Planet as a collective whole.  Ecological preservation should be at the forefront of all business plans because at the end of the day profit is meaningless without an environment to enjoy it in!

Reducing Your Carbon Footprint

Climate change creates a loud buzz across the globe. People are talking about how extreme the weather is, how polluted the environment has become or how devastating the results of carbon emissions are. While it is true that humans contribute a large impact to the worsening climate situations, people are also the most influential key towards making this world a better place. As much as the increase in carbon emissions results from what you do, the healthy change can also start in you.

Although it is a bit difficult to determine what you can do to help the society, do not be disheartened. The devastating forces may be massive for you to work through, but there are countless simple actions?you can take to reduce your carbon footprints day by day.

Home

While you are in the comfort of your home, you can start saving energy to reduce your carbon emission. You could’replace your standard light bulbs with compact fluorescent ones. A compact fluorescent bulb saves more than 2/3rds or up to 1,300 pounds of carbon dioxide in its lifetime. This bulb contains mercury, so make sure to choose a brand that has lower mercury than others.

Another thing, you can do to reduce your carbon footprint at home, is to mind your electronics. When you do not use your gadgets and appliances, make sure you unplug them. If you buy new ones, take time to look at the energy rating of the electronics to save you more energy in future use.

Alternative renewable energy is also a good thing to shift into. Try solar, hydro or wind power at home. Setting up your own residential solar panels and building your own turbines are excellent ways to choose green energy.

Food

The food industry is one of the largest contributors of carbon emissions. You may not have control over the food processing, but you can lower your carbon footprint by buying local products in the market. These local products are not transported from far off places, so the carbon dioxide released from them is lower compared to imported ones. Take a look at the packaging as well; less packaging means less waste.

If you have a big backyard, you could use your it to grow food. ?Eating food, either fruit or vegetable, which you grow at home is energy efficient. No more fuel combustion from transportation and other consequent food processing.

Travel

When you have your own car, accelerating it slowly and smoothly, as well as maintaining speed while driving will help lower your carbon emissions. If you drive a lot, it would be better to get a green car. As of now, you can consider using?public transportation and go for road travel rather than air travel when you take long distance trips. But when you need to take planes, better choose a non-stop flight instead of connecting ones.

Indeed, there are many ways you can combat global warming and climate change. The road to improved life quality through energy efficiency might be hard, but a transformed lifestyle can make a big difference. Start now ? lighten your carbon footprint and help save the world.

Contact Us

  • (+353)(0)1-443-3807 – IRL
  • (+44)(0)20-7193-9751 – UK
5 Ways To Grow Your Business | How Field Service Management Software Helps

Building up any business is already hard, more so when it involves providing field services.

A field service business owner has to manage the usual tasks, like scheduling jobs efficiently or inventory checks, and you have to do it while your employees are scattered about on various locations.

It’s the reason FieldElite was created, to provide companies with a much better way to manage and monitor their field workers.

Aside from effective management for your workforce on the move, field service management software can also help your business grow.

5 Ways Using Field Service Management Software Grows Your Business

1. Management Integration

You replace manual field service processes. If your business also uses other management apps, like CRM, payroll, industry-specific software, etc., make sure to integrate them with your chosen field service management software.?

Make those software work side-by-side with your field service management app to achieve streamlined business management.

Integration also removes the possibility of duplicate input on the regular system used and your field service management software, maximising your efficiency and business growth.

2. Improved Tracking

Utilising a field service management software gives you better tracking of every aspect of your field service business.

  • Track your inventory numbers in real-time ? know exactly how much stock is on hand for parts, and when it’s time to order more
  • Constant updates on Key Performance Indicators ? ensure your business is running smoothly
  • First-time fix rates tracking ? avoid wrong rate application
  • Monitor your technician?s performance ? ensuring quality work, in turn, profit.

Grow your business by having improved tracking on meaningful data and analytics produced from your field service management software.

3. Cost Cutting

Cutting costs can improve your bottom line and a lot of businesses turn to laying off technicians to cut costs. With a field service management software, there?s no need to go this route.

You cut costs through no manual processes needing to be completed. No need to hire back-office staff to field service calls or produce paperwork orders.

Your field service software should have all your automated needs met for efficient field job management.

An example of cost-cutting using field service app:

Track how much your technicians drive and find alternate routes for them to take.

  • Reduce gas expenses
  • Reduce repair bills for the truck
  • Finding better alternate routes can give more time to get to more jobs
  • Increased efficiency for the field technician

4.? Mobile Adaptability

Field service companies are focusing on mobility to grow their business. With a field service management software, technicians have on hand the tools and information needed to complete their job.

Field technicians can utilise the following field service software features:

  • Limit how much time they spend completing administrative work with the automated work-order management
  • Complete checklists on their mobile device and follow step-by-step instructions
  • Check service history
  • Close job orders/calls, collect signatures and start the invoice process

With a mobile app, technicians can complete a call faster, increasing the number of job order scheduled each day, giving additional revenue and that helps to grow your business.

5. Automation

What good is a field service management software without automated features??

Automation, in any industry, is an important factor in managing and growing your business.

Here are some examples of automation features and tools that your software needs in field service:

  • Create and convert quotations into work orders
  • Schedule/Reschedule jobs
  • Accept jobs in the field
  • Convert jobs into invoices
  • Preventative maintenance service
  • Customer updates
  • Automated job reports

Business Growth with your Field Service Management Software

Field service management software is growing businesses through automation, tracking and workflow management.

Your operation can run smarter and more efficiently, all while empowering your field technicians to do their job smoothly.

If you haven’t turned to a field service management software yet, you’re missing out on chances to grow your business.

Check out FieldElite to help grow your field service business today!

Ready to work with Denizon?