diff options
| -rw-r--r-- | challenge-120/eric-cheung/excel-vba/Challenge_120.xlsm | bin | 0 -> 29321 bytes | |||
| -rw-r--r-- | challenge-120/eric-cheung/excel-vba/ch-1.bas | 41 | ||||
| -rw-r--r-- | challenge-120/eric-cheung/excel-vba/ch-2.bas | 47 | ||||
| -rw-r--r-- | stats/pwc-current.json | 299 | ||||
| -rw-r--r-- | stats/pwc-language-breakdown-summary.json | 74 | ||||
| -rw-r--r-- | stats/pwc-language-breakdown.json | 1650 | ||||
| -rw-r--r-- | stats/pwc-leaders.json | 362 | ||||
| -rw-r--r-- | stats/pwc-summary-1-30.json | 106 | ||||
| -rw-r--r-- | stats/pwc-summary-121-150.json | 122 | ||||
| -rw-r--r-- | stats/pwc-summary-151-180.json | 106 | ||||
| -rw-r--r-- | stats/pwc-summary-181-210.json | 32 | ||||
| -rw-r--r-- | stats/pwc-summary-211-240.json | 96 | ||||
| -rw-r--r-- | stats/pwc-summary-31-60.json | 20 | ||||
| -rw-r--r-- | stats/pwc-summary-61-90.json | 116 | ||||
| -rw-r--r-- | stats/pwc-summary-91-120.json | 30 | ||||
| -rw-r--r-- | stats/pwc-summary.json | 32 |
16 files changed, 1618 insertions, 1515 deletions
diff --git a/challenge-120/eric-cheung/excel-vba/Challenge_120.xlsm b/challenge-120/eric-cheung/excel-vba/Challenge_120.xlsm Binary files differnew file mode 100644 index 0000000000..86274169b0 --- /dev/null +++ b/challenge-120/eric-cheung/excel-vba/Challenge_120.xlsm diff --git a/challenge-120/eric-cheung/excel-vba/ch-1.bas b/challenge-120/eric-cheung/excel-vba/ch-1.bas new file mode 100644 index 0000000000..bbfee11466 --- /dev/null +++ b/challenge-120/eric-cheung/excel-vba/ch-1.bas @@ -0,0 +1,41 @@ +Attribute VB_Name = "ModTask_01"
+Option Explicit
+Public Const strMyTitle As String = "Eric Cheung"
+
+Function OddEvenSwap(nNum) As Integer
+
+ Dim strBin As String, strNuBin As String
+ Dim strTemp As String, strNuTemp As String
+ Dim nLoop As Integer
+
+ strBin = Format(Application.WorksheetFunction.Dec2Bin(nNum), "00000000")
+
+ For nLoop = 0 To 3
+ strTemp = Mid(strBin, 2 * nLoop + 1, 2)
+ strNuTemp = strTemp
+
+ If strTemp = "01" Then
+ strNuTemp = "10"
+ ElseIf strTemp = "10" Then
+ strNuTemp = "01"
+ End If
+
+ strNuBin = strNuBin & strNuTemp
+ Next nLoop
+
+ OddEvenSwap = Application.WorksheetFunction.Bin2Dec(strNuBin)
+
+End Function
+
+Sub Task_01()
+
+ Dim varInputNum
+
+ Do
+ varInputNum = InputBox("Please enter a number between 1 to 255", strMyTitle, 101)
+ If varInputNum = "" Then Exit Sub
+ Loop Until varInputNum > 0 And varInputNum < 256
+
+ MsgBox "The answer for odd even bit position swap of " & varInputNum & " is: " & OddEvenSwap(varInputNum)
+
+End Sub
diff --git a/challenge-120/eric-cheung/excel-vba/ch-2.bas b/challenge-120/eric-cheung/excel-vba/ch-2.bas new file mode 100644 index 0000000000..2fad9a79ea --- /dev/null +++ b/challenge-120/eric-cheung/excel-vba/ch-2.bas @@ -0,0 +1,47 @@ +Attribute VB_Name = "ModTask_02"
+Option Explicit
+'https://www.varsitytutors.com/basic_geometry-help/how-to-find-the-angle-of-clock-hands
+'https://www.omnicalculator.com/math/clock-angle#method-2-use-a-clock-angle-formula
+
+Function ClockAngle(strTime) As Double
+
+ Const nSectorToDegree As Integer = 30
+ Const nDayToHour As Integer = 12
+ Const nDiv As Integer = 5
+
+ Dim nHour As Integer, dMinute As Double, dFactor As Double
+
+ nHour = Val(Left(strTime, 2)) Mod nDayToHour
+ dMinute = Val(Right(strTime, 2)) / nDiv
+
+ ClockAngle = Abs(nHour - dMinute) * nSectorToDegree
+
+ If dMinute > 0 Then
+ dFactor = dMinute * nSectorToDegree / nDayToHour
+ If nHour >= dMinute Then
+ ClockAngle = ClockAngle + dFactor
+ Else
+ ClockAngle = ClockAngle - dFactor
+ End If
+ End If
+
+ ClockAngle = Abs(Round(ClockAngle, 2))
+
+ If ClockAngle > 180 Then
+ ClockAngle = 360 - ClockAngle
+ End If
+
+End Function
+
+Sub Task_02()
+
+ Dim varInputNum
+
+ Do
+ varInputNum = InputBox("Please enter the time", strMyTitle, "04:00")
+ If varInputNum = "" Then Exit Sub
+ Loop Until varInputNum <> ""
+
+ MsgBox "The smallest angle spanned by the time " & varInputNum & " is: " & ClockAngle(varInputNum) & " degrees"
+
+End Sub
diff --git a/stats/pwc-current.json b/stats/pwc-current.json index ef9ed6b1ca..7bde76809a 100644 --- a/stats/pwc-current.json +++ b/stats/pwc-current.json @@ -1,42 +1,145 @@ { - "plotOptions" : { - "series" : { - "borderWidth" : 0, - "dataLabels" : { - "format" : "{point.y}", - "enabled" : 1 - } - } + "title" : { + "text" : "The Weekly Challenge - 120" }, - "tooltip" : { - "followPointer" : 1, - "pointFormat" : "<span style='color:{point.color}'>{point.name}</span>: <b>{point.y:f}</b><br/>", - "headerFormat" : "<span style='font-size:11px'>{series.name}</span><br/>" + "legend" : { + "enabled" : 0 }, - "xAxis" : { - "type" : "category" + "subtitle" : { + "text" : "[Champions: 17] Last updated at 2021-07-06 09:45:46 GMT" + }, + "series" : [ + { + "name" : "The Weekly Challenge - 120", + "data" : [ + { + "name" : "Abigail", + "y" : 2, + "drilldown" : "Abigail" + }, + { + "name" : "Belmark Caday", + "y" : 1, + "drilldown" : "Belmark Caday" + }, + { + "name" : "Cheok-Yin Fung", + "y" : 2, + "drilldown" : "Cheok-Yin Fung" + }, + { + "y" : 2, + "name" : "Dave Cross", + "drilldown" : "Dave Cross" + }, + { + "drilldown" : "Flavio Poletti", + "y" : 6, + "name" : "Flavio Poletti" + }, + { + "drilldown" : "James Smith", + "y" : 3, + "name" : "James Smith" + }, + { + "y" : 4, + "name" : "Luca Ferrari", + "drilldown" : "Luca Ferrari" + }, + { + "name" : "Lucas Ransan", + "y" : 2, + "drilldown" : "Lucas Ransan" + }, + { + "drilldown" : "Mark Anderson", + "name" : "Mark Anderson", + "y" : 2 + }, + { + "drilldown" : "Mohammad S Anwar", + "y" : 2, + "name" : "Mohammad S Anwar" + }, + { + "y" : 2, + "name" : "Niels van Dijke", + "drilldown" : "Niels van Dijke" + }, + { + "drilldown" : "Paulo Custodio", + "y" : 2, + "name" : "Paulo Custodio" + }, + { + "drilldown" : "Peter Scott", + "name" : "Peter Scott", + "y" : 1 + }, + { + "drilldown" : "Roger Bell_West", + "name" : "Roger Bell_West", + "y" : 4 + }, + { + "y" : 3, + "name" : "Simon Green", + "drilldown" : "Simon Green" + }, + { + "y" : 2, + "name" : "Steve Bresson", + "drilldown" : "Steve Bresson" + }, + { + "drilldown" : "Stuart Little", + "y" : 4, + "name" : "Stuart Little" + } + ], + "colorByPoint" : 1 + } + ], + "yAxis" : { + "title" : { + "text" : "Total Solutions" + } + }, + "chart" : { + "type" : "column" }, "drilldown" : { "series" : [ { - "id" : "Abigail", + "name" : "Abigail", "data" : [ [ "Perl", 2 ] ], - "name" : "Abigail" + "id" : "Abigail" }, { "id" : "Belmark Caday", + "name" : "Belmark Caday", "data" : [ [ "Perl", 1 ] - ], - "name" : "Belmark Caday" + ] + }, + { + "id" : "Cheok-Yin Fung", + "name" : "Cheok-Yin Fung", + "data" : [ + [ + "Perl", + 2 + ] + ] }, { "data" : [ @@ -45,8 +148,8 @@ 2 ] ], - "id" : "Dave Cross", - "name" : "Dave Cross" + "name" : "Dave Cross", + "id" : "Dave Cross" }, { "data" : [ @@ -63,11 +166,10 @@ 2 ] ], - "id" : "Flavio Poletti", - "name" : "Flavio Poletti" + "name" : "Flavio Poletti", + "id" : "Flavio Poletti" }, { - "name" : "James Smith", "data" : [ [ "Perl", @@ -78,9 +180,11 @@ 1 ] ], + "name" : "James Smith", "id" : "James Smith" }, { + "id" : "Luca Ferrari", "name" : "Luca Ferrari", "data" : [ [ @@ -91,8 +195,7 @@ "Blog", 2 ] - ], - "id" : "Luca Ferrari" + ] }, { "name" : "Lucas Ransan", @@ -111,50 +214,51 @@ 2 ] ], - "id" : "Mark Anderson", - "name" : "Mark Anderson" + "name" : "Mark Anderson", + "id" : "Mark Anderson" }, { - "name" : "Mohammad S Anwar", "id" : "Mohammad S Anwar", "data" : [ [ "Perl", 2 ] - ] + ], + "name" : "Mohammad S Anwar" }, { - "name" : "Niels van Dijke", "id" : "Niels van Dijke", "data" : [ [ "Perl", 2 ] - ] + ], + "name" : "Niels van Dijke" }, { - "name" : "Paulo Custodio", + "id" : "Paulo Custodio", "data" : [ [ "Perl", 2 ] ], - "id" : "Paulo Custodio" + "name" : "Paulo Custodio" }, { "name" : "Peter Scott", - "id" : "Peter Scott", "data" : [ [ "Perl", 1 ] - ] + ], + "id" : "Peter Scott" }, { + "id" : "Roger Bell_West", "name" : "Roger Bell_West", "data" : [ [ @@ -165,10 +269,10 @@ "Raku", 2 ] - ], - "id" : "Roger Bell_West" + ] }, { + "id" : "Simon Green", "data" : [ [ "Perl", @@ -179,22 +283,21 @@ 1 ] ], - "id" : "Simon Green", "name" : "Simon Green" }, { - "name" : "Steve Bresson", "data" : [ [ "Perl", 2 ] ], + "name" : "Steve Bresson", "id" : "Steve Bresson" }, { - "name" : "Stuart Little", "id" : "Stuart Little", + "name" : "Stuart Little", "data" : [ [ "Perl", @@ -208,109 +311,21 @@ } ] }, - "title" : { - "text" : "The Weekly Challenge - 120" - }, - "yAxis" : { - "title" : { - "text" : "Total Solutions" + "plotOptions" : { + "series" : { + "borderWidth" : 0, + "dataLabels" : { + "enabled" : 1, + "format" : "{point.y}" + } } }, - "chart" : { - "type" : "column" - }, - "legend" : { - "enabled" : 0 - }, - "subtitle" : { - "text" : "[Champions: 16] Last updated at 2021-07-06 04:23:48 GMT" + "tooltip" : { + "followPointer" : 1, + "headerFormat" : "<span style='font-size:11px'>{series.name}</span><br/>", + "pointFormat" : "<span style='color:{point.color}'>{point.name}</span>: <b>{point.y:f}</b><br/>" }, - "series" : [ - { - "colorByPoint" : 1, - "name" : "The Weekly Challenge - 120", - "data" : [ - { - "drilldown" : "Abigail", - "y" : 2, - "name" : "Abigail" - }, - { - "y" : 1, - "drilldown" : "Belmark Caday", - "name" : "Belmark Caday" - }, - { - "name" : "Dave Cross", - "drilldown" : "Dave Cross", - "y" : 2 - }, - { - "drilldown" : "Flavio Poletti", - "y" : 6, - "name" : "Flavio Poletti" - }, - { - "drilldown" : "James Smith", - "y" : 3, - "name" : "James Smith" - }, - { - "name" : "Luca Ferrari", - "drilldown" : "Luca Ferrari", - "y" : 4 - }, - { - "name" : "Lucas Ransan", - "y" : 2, - "drilldown" : "Lucas Ransan" - }, - { - "y" : 2, - "drilldown" : "Mark Anderson", - "name" : "Mark Anderson" - }, - { - "y" : 2, - "drilldown" : "Mohammad S Anwar", - "name" : "Mohammad S Anwar" - }, - { - "name" : "Niels van Dijke", - "y" : 2, - "drilldown" : "Niels van Dijke" - }, - { - "y" : 2, - "drilldown" : "Paulo Custodio", - "name" : "Paulo Custodio" - }, - { - "drilldown" : "Peter Scott", - "y" : 1, - "name" : "Peter Scott" - }, - { - "name" : "Roger Bell_West", - "y" : 4, - "drilldown" : "Roger Bell_West" - }, - { - "y" : 3, - "drilldown" : "Simon Green", - "name" : "Simon Green" - }, - { - "name" : "Steve Bresson", - "drilldown" : "Steve Bresson", - "y" : 2 - }, - { - "y" : 4, - "drilldown" : "Stuart Little", - "name" : "Stuart Little" - } - ] - } - ] + "xAxis" : { + "type" : "category" + } } diff --git a/stats/pwc-language-breakdown-summary.json b/stats/pwc-language-breakdown-summary.json index 2559bfdfc3..ff5b6d35d3 100644 --- a/stats/pwc-language-breakdown-summary.json +++ b/stats/pwc-language-breakdown-summary.json @@ -1,37 +1,16 @@ { - "xAxis" : { - "labels" : { - "style" : { - "fontFamily" : "Verdana, sans-serif", - "fontSize" : "13px" - } - }, - "type" : "category" - }, - "title" : { - "text" : "The Weekly Challenge Contributions [2019 - 2021]" - }, - "tooltip" : { - "pointFormat" : "<b>{point.y:.0f}</b>" - }, "subtitle" : { - "text" : "Last updated at 2021-07-06 04:23:48 GMT" + "text" : "Last updated at 2021-07-06 09:45:46 GMT" + }, + "yAxis" : { + "min" : 0, + "title" : { + "text" : null + } }, "series" : [ { "name" : "Contributions", - "dataLabels" : { - "format" : "{point.y:.0f}", - "align" : "right", - "style" : { - "fontSize" : "13px", - "fontFamily" : "Verdana, sans-serif" - }, - "y" : 10, - "color" : "#FFFFFF", - "enabled" : "true", - "rotation" : -90 - }, "data" : [ [ "Blog", @@ -39,25 +18,46 @@ ], [ "Perl", - 5705 + 5707 ], [ "Raku", 3586 ] - ] + ], + "dataLabels" : { + "align" : "right", + "enabled" : "true", + "color" : "#FFFFFF", + "style" : { + "fontFamily" : "Verdana, sans-serif", + "fontSize" : "13px" + }, + "rotation" : -90, + "y" : 10, + "format" : "{point.y:.0f}" + } } ], - "legend" : { - "enabled" : "false" - }, "chart" : { "type" : "column" }, - "yAxis" : { - "min" : 0, - "title" : { - "text" : null + "xAxis" : { + "type" : "category", + "labels" : { + "style" : { + "fontSize" : "13px", + "fontFamily" : "Verdana, sans-serif" + } } + }, + "tooltip" : { + "pointFormat" : "<b>{point.y:.0f}</b>" + }, + "title" : { + "text" : "The Weekly Challenge Contributions [2019 - 2021]" + }, + "legend" : { + "enabled" : "false" } } diff --git a/stats/pwc-language-breakdown.json b/stats/pwc-language-breakdown.json index 8134350250..85fe3122f4 100644 --- a/stats/pwc-language-breakdown.json +++ b/stats/pwc-language-breakdown.json @@ -1,645 +1,18 @@ { - "chart" : { - "type" : "column" - }, - "yAxis" : { - "title" : { - "text" : "Total Solutions" - } - }, "legend" : { "enabled" : "false" }, - "series" : [ - { - "name" : "The Weekly Challenge Languages", - "colorByPoint" : "true", - "data" : [ - { - "name" : "#001", - "y" : 161, - "drilldown" : "001" - }, - { - "drilldown" : "002", - "y" : 125, - "name" : "#002" - }, - { - "y" : 81, - "drilldown" : "003", - "name" : "#003" - }, - { - "name" : "#004", - "y" : 99, - "drilldown" : "004" - }, - { - "drilldown" : "005", - "y" : 78, - "name" : "#005" - }, - { - "drilldown" : "006", - "y" : 58, - "name" : "#006" - }, - { - "drilldown" : "007", - "y" : 64, - "name" : "#007" - }, - { - "name" : "#008", - "y" : 78, - "drilldown" : "008" - }, - { - "drilldown" : "009", - "y" : 76, - "name" : "#009" - }, - { - "y" : 65, - "drilldown" : "010", - "name" : "#010" - }, - { - "name" : "#011", - "y" : 85, - "drilldown" : "011" - }, - { - "y" : 89, - "drilldown" : "012", - "name" : "#012" - }, - { - "name" : "#013", - "drilldown" : "013", - "y" : 85 - }, - { - "name" : "#014", - "y" : 101, - "drilldown" : "014" - }, - { - "name" : "#015", - "y" : 99, - "drilldown" : "015" - }, - { - "y" : 71, - "drilldown" : "016", - "name" : "#016" - }, - { - "y" : 84, - "drilldown" : "017", - "name" : "#017" - }, - { - "y" : 81, - "drilldown" : "018", - "name" : "#018" - }, - { - "drilldown" : "019", - "y" : 103, - "name" : "#019" - }, - { - "y" : 101, - "drilldown" : "020", - "name" : "#020" - }, - { - "y" : 72, - "drilldown" : "021", - "name" : "#021" - }, - { - "y" : 68, - "drilldown" : "022", - "name" : "#022" - }, - { - "y" : 97, - "drilldown" : "023", - "name" : "#023" - }, - { - "y" : 74, - "drilldown" : "024", - "name" : "#024" - }, - { - "drilldown" : "025", - "y" : 59, - "name" : "#025" - }, - { - "name" : "#026", - "drilldown" : "026", - "y" : 74 - }, - { - "y" : 60, - "drilldown" : "027", - "name" : "#027" - }, - { - "name" : "#028", - "y" : 80, - "drilldown" : "028" - }, - { - "drilldown" : "029", - "y" : 79, - "name" : "#029" - }, - { - "drilldown" : "030", - "y" : 117, - "name" : "#030" - }, - { - "y" : 89, - "drilldown" : "031", - "name" : "#031" - }, - { - "name" : "#032", - "y" : 94, - "drilldown" : "032" - }, - { - "y" : 110, - "drilldown" : "033", - "name" : "#033" - }, - { - "name" : "#034", - "drilldown" : "034", - "y" : 64 - }, - { - "name" : "#035", - "y" : 64, - "drilldown" : "035" - }, - { - "y" : 68, - "drilldown" : "036", - "name" : "#036" - }, - { - "drilldown" : "037", - "y" : 67, - "name" : "#037" - }, - { - "name" : "#038", - "y" : 68, - "drilldown" : "038" - }, - { - "drilldown" : "039", - "y" : 62, - "name" : "#039" - }, - { - "name" : "#040", - "drilldown" : "040", - "y" : 73 - }, - { - "name" : "#041", - "drilldown" : "041", - "y" : 76 - }, - { - "name" : "#042", - "drilldown" : "042", - "y" : 92 - }, - { - "y" : 68, - "drilldown" : "043", - "name" : "#043" - }, - { - "y" : 85, - "drilldown" : "044", - "name" : "#044" - }, - { - "drilldown" : "045", - "y" : 96, - "name" : "#045" - }, - { - "name" : "#046", - "drilldown" : "046", - "y" : 87 - }, - { - "name" : "#047", - "y" : 84, - "drilldown" : "047" - }, - { - "drilldown" : "048", - "y" : 108, - "name" : "#048" - }, - { - "name" : "#049", - "y" : 89, - "drilldown" : "049" - }, - { - "name" : "#050", - "drilldown" : "050", - "y" : 98 - }, - { - "name" : "#051", - "y" : 89, - "drilldown" : "051" - }, - { - "name" : "#052", - "y" : 91, - "drilldown" : "052" - }, - { - "y" : 101, - "drilldown" : "053", - "name" : "#053" - }, - { - "name" : "#054", - "y" : 103, - "drilldown" : "054" - }, - { - "name" : "#055", - "drilldown" : "055", - "y" : 88 - }, - { - "name" : "#056", - "drilldown" : "056", - "y" : 95 - }, - { - "drilldown" : "057", - "y" : 80, - "name" : "#057" - }, - { - "y" : 69, - "drilldown" : "058", - "name" : "#058" - }, - { - "y" : 89, - "drilldown" : "059", - "name" : "#059" - }, - { - "drilldown" : "060", - "y" : 85, - "name" : "#060" - }, - { - "y" : 81, - "drilldown" : "061", - "name" : "#061" - }, - { - "name" : "#062", - "drilldown" : "062", - "y" : 58 - }, - { - "name" : "#063", - "y" : 89, - "drilldown" : "063" - }, - { - "name" : "#064", - "drilldown" : "064", - "y" : 80 - }, - { - "name" : "#065", - "drilldown" : "065", - "y" : 73 - }, - { - "drilldown" : "066", - "y" : 84, - "name" : "#066" - }, - { - "name" : "#067", - "y" : 90, - "drilldown" : "067" - }, - { - "name" : "#068", - "drilldown" : "068", - "y" : 75 - }, - { - "name" : "#069", - "drilldown" : "069", - "y" : 83 - }, - { - "name" : "#070", - "y" : 93, - "drilldown" : "070" - }, - { - "drilldown" : "071", - "y" : 78, - "name" : "#071" - }, - { - "drilldown" : "072", - "y" : 112, - "name" : "#072" - }, - { - "name" : "#073", - "drilldown" : "073", - "y" : 110 - }, - { - "drilldown" : "074", - "y" : 115, - "name" : "#074" - }, - { - "drilldown" : "075", - "y" : 113, - "name" : "#075" - }, - { - "name" : "#076", - "drilldown" : "076", - "y" : 99 - }, - { - "drilldown" : "077", - "y" : 98, - "name" : "#077" - }, - { - "name" : "#078", - "drilldown" : "078", - "y" : 127 - }, - { - "y" : 122, - "drilldown" : "079", - "name" : "#079" - }, - { - "drilldown" : "080", - "y" : 127, - "name" : "#080" - }, - { - "name" : "#081", - "drilldown" : "081", - "y" : 114 - }, - { - "name" : "#082", - "drilldown" : "082", - "y" : 114 - }, - { - "name" : "#083", - "y" : 127, - "drilldown" : "083" - }, - { - "name" : "#084", - "drilldown" : "084", - "y" : 119 - }, - { - "y" : 114, - "drilldown" : "085", - "name" : "#085" - }, - { - "drilldown" : "086", - "y" : 104, - "name" : "#086" - }, - { - "name" : "#087", - "drilldown" : "087", - "y" : 101 - }, - { |
