ABCD
1
ItemInputs / ResultsNotes (if any)
2
1. Select your Skin Type in cell B4 & enter the UV Index in cell B5.
2. (optional) Enter information in cells B7-B11. If you're not wearing suncreen, ensure cell B8 is set to 0.
3. Evaluate the results in cells B45-B48. Don't discard your priors; while at least one study found calculators like this to be more accurate than self-assessments, at least one found the opposite.
3
Inputs
4
Skin TypeType 1For help, see the guides in the next tab.
5
UV Index20You can get this from a weather app or website.
6
7
(optional) Time in the Sun (minutes)30Lines 10 and 47 require this input to work properly.
8
(optional) Sunscreen SPF0Set this to 0 if you will not be wearing sunscreen.
9
(optional) Sunscreen Quantity UsedTypical usage (lower end of range)
10
(optional) Discount for sweating over time?YesUses the time set in Cell B7.
11
(optional) How much skin is exposed?Face & Arms & LegsLine 48 requires this input to work properly.
43
44
Results
45
1% of People in these Conditions Will Be Sunburnt After11 minutes<- Calculation of this value went outside accepted bounds; this outcome has low accuracy.
46
Alternative Projection of "Time until Sunburn"8 minutesSeems to approximate time until ~1.5% of people will be sunburnt.
47
Percent of Population w/ Sunburn Degree 1 at Time Exposed92.5%<- Calculation of this value went outside accepted bounds; this outcome has low accuracy.
48
'Optimal' Daily Sun Exposure in These Conditions#N/A<- Calculation of this value went outside accepted bounds; this outcome has low accuracy.
49
50
Additional Info & Disclaimers"Proximity to UV reflective surfaces such as water, white sand or snow can reduce times by up to a factor of 2. UV exposure in shaded areas can be up to 50% of full sun exposure. Only material opaque to UV will [fully] prevent sunburn on covered areas. ... Allow 20 minutes to let sunscreen become effective and reapply every two hours. Babies of all skin types should avoid sun."
- Direct quote from Wolfram Alpha's (not good) calculator which seems somewhat useful and somewhat helps me CYA