ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Target Calculator
3
Current TargetRunning Balance
4
15000
5
6
Worksheet
7
Today Total:-1500
8
MealCaloriesInstructions:
9
The goal is to keep the "Running Balance" near 0!
10
Use this calculator to find your target calories per day.
11
Replace the "Current Target" number here with that number.
12
Fill in each of your meals and calories (I personally only do calories)
13
Click "New Day" to clear the sheet and it will update your running balance
14
"Running Balance" is the number you want to keep close to 0
15
If, for whatever reason, the balance is wrong, you can manually change it.
16
17
Technical Details:
18
Click "File" -> "Make A Copy" to use this sheet yourself.
19
To use the button, you may need to grant Google Scripts access.
20
When it says "This app isn't verified," click "Advanced" -> "Go to DietCalc(unsafe)"
21
To see or edit the code, you can go to "Tools" -> "Script Editor".
22
It should match what's below, but if it's not there, add this:
23
function newDay() {
var sheet = SpreadsheetApp.getActiveSheet();
var balance = sheet.getRange("D4").getValue();
var target = sheet.getRange("B4").getValue();
var today = sheet.getRange("E7").getValue();
sheet.getRange("D4").setValue(balance+today-target);
sheet.getRange("B9:E29").clearContent();
}
24
25
26
27
28
29
30
31
32
33
34
Clicking this will clear the worksheet and tally the balance
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100