u/-HeyDes-

Hi all. I have a Google Form that I use to log the start/end of a shift across different client locations and my sheet then uses a few basic formulas to work out pay rates based on location to create an invoice. I have been using this formula below in a cell to work out earnings without an issue (edited names out), but this year the hourly rate has increased in some locations and if I change this formula, it applies to last year's data and I want to retain that as it is.

=IF(A11="MC", 12.75, IF(A11="MV", 15, IF(A11="S", 12.75, IF(A11="FM", 12.75, IF(A11="W", 12.25, IF(A11="HH", 15, IF(A11="H", 14, IF(A11="L", 15, IF(A11="P", 13.5, IF(A11="QW", 13.5, IF(A11="WM", 12.75, IF(A11="V", 15,))))))))))))

If there any way that I can incorporate this year's changes without altering last year's data? I could easily just copy the form and sheet and change the values, but wanted to keep it all together. I can't share my sheet as it contains customer information and brief reports. I could copy and strip it if really needed, but will take time.

Hi all. Can I keep a Bahco Laplander in my boot inside an emergency get home bag? If not, what are the laws on dismantling it and having the blade and handle separate in the bag? (Wales)

I have been carrying one for the past few months, but concerned that I shouldn't be. I know it's a locking blade and a no-no in general without a valid reason, but from what I understand emergency preparedness is a valid reason.

I would rather dismantle than have a non-locking type blade or the rope saw type. If it's needed in an emergency, I wouldn't want to risk losing my fingers and making the emergency situation worse. I also go for a little walk through dense woodland most weekends and can use it there sometimes.

Thanks in advance