by

5 questions to ask if you have data on spreadsheets

Does this sound familiar?You started to hold some data about your business in a spreadsheet. Then you added some more and then kept adding and editing details from it.Soon you had a sizeable number of records and you began to share it with your team. Before you knew it the spreadsheet was being used by several people at one timeIf this is the case and you have some data on spreadsheets then you’ve risked some part of your business without realizing it.Go through these points to see what the risks are and some solutions:

  1. Is it (the spreadsheet) secure? Do you have it password protected? Is it easy to copy/download and take away with you? If it is not you risk your data being copied, losing your business info and at worst information being sold to your competitors or in the data market.
  2. Is it private? – Is it stored in an area with restricted access? Do you know who has access to the spreadsheet? If it has a free access to all you face the same risks mentioned above without you knowing it.
  3. Is it backed up?  is the spreadsheet stored in an area which gets regularly backed-up? This is a real risk for any sort of data that you are collecting. If you are working on it make sure you save it and back it up. Either store it in a place where your company’s backup systems will pick it up or store it to the cloud.
  4. Is it simultaneously editable? is the spreadsheet used by several people (more than 2) and can they edit it simultaneously? This is so common a problem that the ill-effects are often ignored. Lack of ability to edit simultaneously is a major efficiency killer. Time you can spend doing something productive is wasted waiting for the spreadsheet to be free. Teams often resort to other unproductive ways of dealing with this like, noting their changes somewhere else and adding them to the main spreadsheet later. Making a copy of the main spreadsheet on their PC, changing it and then uploading it to the main one – risking overwriting someone else’s changes. A good solution is to use a cloud spreadsheet like Google. But even better is to think if there is a system which can help with handling this data.
  5. Is it auditable? – Can you know who changed what? Lack of this will at best, make you wonder who change what – at worst will make you doubt the entire data.

The ideal solution for all these is to see if the data you’ve got can be captured and managed in an application. If not, follow the above points to make it risk-free and productive for your business.

Is this ‘TrueForYou’ or your business? Are you holding some (or lot!) of data in spreadsheets?
If yes, we can help to de-risk and improve efficiency.
Contact us on hello@techrelief.co.uk

Write a Comment

Comment

Webmentions

  • celecoxib dosing

    celecoxib dosing

    celecoxib dosing

  • sertraline vs bupropion

    sertraline vs bupropion

    sertraline vs bupropion

  • how long does it take celebrex to work

    how long does it take celebrex to work

    how long does it take celebrex to work

  • buspar vs klonopin

    buspar vs klonopin

    buspar vs klonopin

  • augmentin 625

    augmentin 625

    augmentin 625

  • celexa and weightloss

    celexa and weightloss

    celexa and weightloss

  • ashwagandha dosage for testosterone

    ashwagandha dosage for testosterone

    ashwagandha dosage for testosterone

  • reye's syndrome aspirin

    reye’s syndrome aspirin

    reye’s syndrome aspirin

  • amitriptyline withdrawal symptoms

    amitriptyline withdrawal symptoms

    amitriptyline withdrawal symptoms

  • allopurinol uric acid

    allopurinol uric acid

    allopurinol uric acid

  • aripiprazole wiki

    aripiprazole wiki

    aripiprazole wiki

  • ddavp spray comprar

    ddavp spray comprar

    ddavp spray comprar

  • effexor side effects first week

    effexor side effects first week

    effexor side effects first week

  • augmentin drug interactions

    augmentin drug interactions

    augmentin drug interactions

  • flexeril 10 mg

    flexeril 10 mg

    flexeril 10 mg

  • flomax pro compressor

    flomax pro compressor

    flomax pro compressor

  • diltiazem cd vs er

    diltiazem cd vs er

    diltiazem cd vs er

  • what will 200 mg of citalopram do

    what will 200 mg of citalopram do

    what will 200 mg of citalopram do

  • cozaar medicine

    cozaar medicine

    cozaar medicine

  • ezetimibe in children

    ezetimibe in children

    ezetimibe in children

  • depakote drug interactions

    depakote drug interactions

    depakote drug interactions

  • contrave jitters

    contrave jitters

    contrave jitters

  • diclofenac sodium topical gel

    diclofenac sodium topical gel

    diclofenac sodium topical gel

  • amoxicillin 400mg/5ml

    amoxicillin 400mg/5ml

    amoxicillin 400mg/5ml

  • what type of antibiotic is bactrim

    what type of antibiotic is bactrim

    what type of antibiotic is bactrim

  • bactrim 800/160 para que sirve

    bactrim 800/160 para que sirve

    bactrim 800/160 para que sirve

  • can dogs take cephalexin

    can dogs take cephalexin

    can dogs take cephalexin

  • does ciprofloxacin treat strep throat

    does ciprofloxacin treat strep throat

    does ciprofloxacin treat strep throat

  • keflex side effects pregnancy

    keflex side effects pregnancy

    keflex side effects pregnancy

  • gabapentin nightmares

    gabapentin nightmares

    gabapentin nightmares

  • generic viagra - mastercard

    generic viagra – mastercard

    generic viagra – mastercard

  • co escitalopram 20 mg

    co escitalopram 20 mg

    co escitalopram 20 mg

  • is cephalexin a antibiotic

    is cephalexin a antibiotic

    is cephalexin a antibiotic

  • duloxetine and nerve pain

    duloxetine and nerve pain

    duloxetine and nerve pain

  • ic fluoxetine hcl

    ic fluoxetine hcl

    ic fluoxetine hcl

  • cymbalta vs lyrica

    cymbalta vs lyrica

    cymbalta vs lyrica

  • lexapro withdrawals

    lexapro withdrawals

    lexapro withdrawals

  • metronidazole inhalation

    metronidazole inhalation

    metronidazole inhalation

  • side affects of zoloft

    side affects of zoloft

    side affects of zoloft

  • rybelsus vs ozempic

    rybelsus vs ozempic

    rybelsus vs ozempic

  • rybelsus lose weight

    rybelsus lose weight

    rybelsus lose weight

  • semaglutide b12

    semaglutide b12

    semaglutide b12

  • furosemide sottocute

    furosemide sottocute

    furosemide sottocute

  • metformin forgetfulness

    metformin forgetfulness

    metformin forgetfulness

  • weightlifting lisinopril

    weightlifting lisinopril

    weightlifting lisinopril

  • tamoxifen chemoprevention

    tamoxifen chemoprevention

    tamoxifen chemoprevention

  • valtrex hind

    valtrex hind

    valtrex hind

  • lyrica cost at walmart

    lyrica cost at walmart

    lyrica cost at walmart

  • can i take sulfamethoxazole with milk

    can i take sulfamethoxazole with milk

    can i take sulfamethoxazole with milk

  • metronidazole kellymom

    metronidazole kellymom

    metronidazole kellymom

  • gabapentin wirkungsweise

    gabapentin wirkungsweise

    gabapentin wirkungsweise

  • cialis mg

    cialis mg

    cialis mg

  • buy some cialis

    buy some cialis

    buy some cialis

  • tadalafil bph

    tadalafil bph

    tadalafil bph

  • tadalafil tablets 40 mg

    tadalafil tablets 40 mg

    tadalafil tablets 40 mg

  • genuine viagra online uk

    genuine viagra online uk

    genuine viagra online uk

  • 25mg viagra generic

    25mg viagra generic

    25mg viagra generic

  • sildenafil pills 100mg

    sildenafil pills 100mg

    sildenafil pills 100mg

  • pharmacy price comparison viagra

    pharmacy price comparison viagra

    pharmacy price comparison viagra

  • buy sildenafil in mexico

    buy sildenafil in mexico

    buy sildenafil in mexico

  • viagra pills for sale nz

    viagra pills for sale nz

    viagra pills for sale nz

  • indian pharmacy phentermine

    indian pharmacy phentermine

    indian pharmacy phentermine

  • cialis lower blood pressure

    cialis lower blood pressure

    cialis lower blood pressure

  • viagra tablets in india price

    viagra tablets in india price

    viagra tablets in india price

  • tadalafil dapoxetine

    tadalafil dapoxetine

    tadalafil dapoxetine

  • can you buy viagra over the counter in europe

    can you buy viagra over the counter in europe

    can you buy viagra over the counter in europe

  • cialis tadalafil 20 mg

    cialis tadalafil 20 mg

    cialis tadalafil 20 mg

  • how long does tadalafil take to work

    how long does tadalafil take to work

    how long does tadalafil take to work