Sc-im-Tutorial/Lesson14_Conditional_Function_IF.sc at master · jonnieey/Sc-im-Tutorial · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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
# This data file was generated by the Spreadsheet Calculator Improvised (sc-im)
# You almost certainly shouldn't edit it.

newsheet "Sheet1"
movetosheet "Sheet1"
format A 75 2 0
format B 38 2 0
format 20 3
format 21 3
leftstring A0 = "1.Go to C9. Type =@sum(E0:E5,@eqs(D0, \"Male\"))"
label B0 = "Name"
label C0 = "Age"
label D0 = "Gender"
label E0 = "Marks"
leftstring A1 = "2.Go to C10. Type =@sum(E0:E5,@eqs(D0, \"Female\"))"
leftstring B1 = "John"
let C1 = 19
label D1 = "Male"
let E1 = 63
leftstring A2 = "3.Go to C11. Type =@avg(E0:E5, C0<24)"
leftstring B2 = "Jane"
let C2 = 21
label D2 = "Female"
let E2 = 66
leftstring B3 = "Stephen"
let C3 = 23
label D3 = "Male"
let E3 = 69
leftstring A4 = "5.Go to D13. Type \\"@if(C13<40, \"Weak\", \"Strong\")  "
leftstring B4 = "Mary"
let C4 = 25
label D4 = "Female"
let E4 = 72
leftstring A5 = "6.Change value of C13 to 21"
leftstring B5 = "Abigael"
let C5 = 27
label D5 = "Female"
let E5 = 75
leftstring A6 = "7.Type :int recalc "
leftstring A7 = "8.Change value of C13 to 90"
leftstring A8 = "9.Type :int recalc "
leftstring B9 = "Sum marks of male students"
leftstring A10 = "10.Go to D14. "
leftstring B10 = "Sum marks of female students"
leftstring A11 = "11.Type \\"@if(C14<30, \"Oversold\", @if(C14>70, \"Overbought\", \"Normal\"))"
leftstring B11 = "Average marks of students below 24 yrs"
leftstring A12 = "12.Repeat steps 7-10 for C14"
label B13 = "ADX VALUE"
let C13 = 50
label B14 = "RSI VALUE"
let C14 = 80
leftstring A20 = "NOTE: @eqs({string_expr1}, {string_expr2}).\n Returns 1 if string_exp1 is equal to string_expr2"
leftstring A21 = "NOTE: command int recalc re-evaluates\n the dep-graph to get updated values"
cellcolor C9 "fg=WHITE bg=BLUE"
cellcolor C10 "fg=WHITE bg=BLUE"
cellcolor C11 "fg=WHITE bg=BLUE"
cellcolor A12 "fg=RED bg=BLACK bold=1"
cellcolor D13 "fg=WHITE bg=BLUE"
cellcolor D14 "fg=WHITE bg=BLUE"
cellcolor A20 "fg=RED bg=BLACK bold=1"
cellcolor A21 "fg=RED bg=BLACK bold=1"
goto A0