# Kodindonesia

A fairly difficult puzzle: Let's solve it together, to learn more C# concepts

Topics:
07:16 convert one line of text into a "List of integers"
10:57 "Tuple": to group individually named-variables
11:34 "List of Tuple": to identify the landing area
14:57 ready to rock and roll! We start writing the puzzle's solution!
16:12 "Properties" can be used to give a name to often-used formulas
26:50 we try, but the code needs one improvement
27:55 we write the improvement
30:14 success on the first scenario!
30:57 trying the 2nd scenario shows a mistake in the code, and we fix it
32:26 success on the 2nd scenario: where the lander starts quite far from the landing area
33:28 success on the 3rd scenario: where the lander starts very fast and in the wrong direction
35:03 success on the 4th scenario: where the landing area is inside a deep canyon
35:36 we try the last scenario, but the code needs one last improvement
40:13 success on the last scenario: where the landing area is on top of a mountain

Our videos appear first on Bitchute/BitSlide, and only later on YouTube.

Topics:
02:45 rules of the sudoku puzzle
03:55 inputs and outputs
04:59 solutions
10:00 show arrows indicating the precedents (input cells for the current cell's formula)
13:05 convert input text to many Excel cells ("space separated" information)
18:09 starting to create the solution from an empty sheet
18:27 COUNTIF()
24:17 INDEX() to re-arrange cells (like we did in the Onboarding tutorial)
29:25 AND() condition

Topics:
03:31 loop within loop: "for" loop within the "while" loop (game loop)
03:43 "for" loop is mostly used to iterate n times, with a counter variable
04:27 (1) "for" loop initializes the counter
04:38 (2) "for" loop verifies when to stop with a condition
04:49 (3) "for" loop updates the counter. For example, i++ increases it by 1
05:57 coding the solution

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Topics:
04:01 the goal
07:58 loop inside a loop
08:02 "for" loop
10:00 to "run" a program: step-by-step
17:04 coding the solution
21:04 eliminating an error in the code (debugging)

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Topics:
04:22 CodinGame "Show Testcases" button, to see inputs and outputs of many puzzles.
09:49 MID() get part of a text
15:53 FIND() find the position of a text inside another text
19:47 UPPER() to convert a text to upper case

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Topics:
02:17 CodinGame puzzle explanations, inputs, and outputs
06:54 presentation of the final Excel solution, before re-creating it
12:58 starting to re-create the solution
13:40 giving a unique code for each board's cell: string & string
14:52 locking rows and columns of a formula with \$ and the key F4
16:28 showing the goal/light on the grid: IF(condition, valueIfTrue, valueIfFalse)
17:44 moving Thor step by step towards the goal
19:17 CodinGame OUTPUT: choose(index, valueIf1, valueIf2, valueIf3)
21:37 beyond the solution: let's also show the path of Thor in the board
22:36 MATCH() formula. How to find an element in a group

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Topics:
13:11 we create our first "method" method_name() : indented group of instructions
14:13 first "function" function_name() : indented group of instructions, return value
15:10 "bool" data can be true or false variable_name = condition
15:49 using constants, instead of disseminating numbers, is a good habit CONSTANT_NAME capitalized = constantValue
18:31 "ternary operator " variable_name = valueIfTrue if condition else valueIfValse
20:40 how to compare your code with other people's code in CodinGame

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Topics:
02:57 variable types: string
06:51 variable types: integer
08:51 conversion from string to int: int.Parse("123")
13:24 C# comments: // and /* */
18:51 loop: while (condition) { group of instructions }
23:50 if (condition) {} else {}
28:31 how to organise the code elements together

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Topics:
04:51 Variables: string, integer data types
08:13 convert string to integer number
08:45 Comments: # single line and multi-line '''
09:43 Inputs and Outputs: input('"question") print("output")
12:14 Loop: while
15:10 step-by-step code execution: what "RUN" means, and the "Debug" button
18:25 if then else

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Topics:
03:32 instead of Excel, you can use "LibreOffice Calc".
05:49 variable type: String/Text (left aligned)
06:20 variable type: Number (right aligned)
06:49 variable type: Date (right aligned)
07:02 variable type: Boolean (aligned to the centre)
07:13 cell name
08:19 formulas (usually begin with =)
12:05 solving the CodinGame Onboarding puzzle in Excel: inputs, outputs
14:42 rearranging data from vertical to horizontal, and creating groups of four
15:19 copy & "paste-special", with transpose
16:25 INDEX(group_of_cells, pointer), cell I6 = INDEX(\$D\$6:\$D\$65, \$H6 * 4 + I\$4)
17:34 copying formulas and blocking rows / columns with \$
17:41 copying formulas horizontally / vertically by dragging with mouse
19:28 formula to calculate the outputs
19:39 converting from string/text to number: the why and the how-to
23:11 IF(condition, outputIfTrue, outputIfFalse)

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Topics:
02:57 variable types: string
06:51 variable types: integer
08:51 conversion from string to int: int.Parse("123")
13:24 C# comments: // and /* */
18:51 loop: while (condition) { group of instructions }
23:50 if (condition) {} else {}
28:31 how to organise the code elements together

To chat with the Indo Koding family: https://discord.gg/kWTJtqx

Kalian belajar Coding dengan game.
Mulai dari video ini.

To chat with the Indo Koding family: https://discord.gg/kWTJtqx