This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
let | |
fnErlangC = | |
( | |
number_of_calls as number, | |
period_of_minutes as number, | |
average_handling_time as number, | |
required_service_level as number, | |
target_answer_time as number, | |
maximum_occupancy as number, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Function: fnHoltWinters | |
Description: Trying to replicate HoltWinters quantitative smoothing with Power Query. | |
Author: Chris Aragao | |
Change Log: | |
11.13.2023 - Initial release. Initial code was based off of this tutorial: https://www.exceldemy.com/holt-winters-exponential-smoothing-in-excel/. | |
It was aimed at solely duplicating the output and did so. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sparkline = | |
// dummy value in a table | |
VAR _vals = { | |
( 0, 500 ), | |
( 1, 700 ), | |
( 2, 1200 ), | |
( 3, 1250 ), | |
( 4, 550 ), | |
( 5, 780 ), | |
( 6, 990 ), |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
target card = | |
// unsat, below, near, hit | |
VAR _Q1_result = "unsat" | |
VAR _Q2_result = "below" | |
VAR _Q3_result = "near" | |
VAR _Q4_result = "hit" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://vega.github.io/editor/#/url/vega-lite/N4KABGBEAWCmCWBzaAXSAuMBWADDgNOFAO7wAmK0G2ehEkZAhio9aBBOJAG6MA2AV1gBnagG0iEdhxmQAmrEYAnagEYAnLjoyOkAKoA5agDsBfPtp1QAkgAkAsgFETZi5J2Rr1gIIBlby7mlh6GAPq28MIoAPZK8ADG-NQATAAsAOzpAGzpuLTushHIsCqYpkEFugAy0cQlgW5W9AAizLDUkDiqAPRd3Rq4kO4AvsHSVvKKpWADqsGyhg3zunZOS5X0Xn4BZa7L9GERUbEJSZjJWMk46ul4+U1QRXDT5Y1NkDV1L3sbUK0o7UwnR6fVmQxko3c4w8CmUak0yX2UEWuwqD08DmcqLeEy2-nW6MOkRicUSfBSWCyl3UqjuSMgT3q2PpnyZYFe9P+gKgfVBCPBHEhMmhslh0wGAGZ6Sj2T90assbK0e88TslTiQgZwsSTmSUllVJcsLT7u9Gd9lRNWRaNbIuR1eT1JQKIEKOCLdGL4VhUtKjMzfhi1gH5T58SH3kTjqSzmBklkqRKcLdTRNzQT3taMxN7UDHf1NKkXWA3VJA17MAMsH7sx4FbXZKqG7ooyTTuTzulVAAOKlXVMedMRq21NkcwO5nkgp2aLDF0tgD30CszTRZGvDuuY5ubMNq8eErVHNt6zvpCWpdRJgeFJDPHdQLObu1tB3TguU+djctTb3pDfqvS9bPise4PvoR46jGHZxt2yTdsa14EIGQ6AYGT5oeik7Ar0M5YOkX5Qj+cKVpo3YAQeKrbiBu7bOBra6rG8HdukyTJCayHoqhlEjl84HYfmAzdoRwrEeKmjqBRcpUcGmEqmBNHIpB0btik6ipJemh0ihd5jtJvF6ZaHgCe+AzqCJ7pifCWScZG-pybi1EOXWCnOQsyknkx6izt26jaVxuk2iyo5BROr55qZ6g2RZZboiuGgGlJRmNk5PEuXRikQdqKmnmASapPB6Tdv5ZqBeBGFpS+ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"data": { | |
"values": [ | |
{ | |
"Year": 1950, | |
"UN": null, | |
"IHME": null, | |
"IIASA": null, | |
"UN_Historical": 2477675000, | |
"Higher": null, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"$schema": "https://vega.github.io/schema/vega-lite/v5.json", | |
"usermeta": { | |
"deneb": { | |
"build": "1.5.1.0", | |
"metaVersion": 1, | |
"provider": "vegaLite", | |
"providerVersion": "5.6.1" | |
}, | |
"interactivity": { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"title": { | |
"text": "% Rating based on Category Type", | |
"anchor": "middle", | |
"color": "white", | |
"font": "helvatica", | |
"fontSize": 30 | |
}, | |
"data": { | |
"values": [ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "My New Theme", | |
"visualStyles": { | |
"*": { | |
"*": { | |
"visualHeader": [{ | |
"show": false, | |
"showOptionsMenu": false, | |
"transparency": 0, | |
"foreground": { |