matt40k

Name	Description
Critical Hit	Unmodified 6 to hit
Critical Wound	Unmodified 6 to wound

Shooting

Name	Description
Heavy	+1 to hit if remained stationary

matt40k

gmai.com|gmail.com
gmail.colm|gmail.com
gmail.coml.com|gmail.com
gmail.on|gmail.com
gmal.com|gmail.com
goglemail.com|googlemail.com
homail.com|hotmail.com
htmail.com|hotmail.com

matt40k

$baseUri = "http://wahapedia.ru/wh40k9ed/"

$r = (Invoke-WebRequest -Uri "$($baseUri)Last_update.csv" -UseBasicParsing).Content | ConvertFrom-Csv -Delimiter "|" -Header "last_update" | Select-Object -Skip 1
$lastUpdated = $r.last_update

$factions = (Invoke-WebRequest -Uri "$($baseUri)Factions.csv" -UseBasicParsing).Content | ConvertFrom-Csv -Delimiter "|" -Header "id", "name", "link" | Select-Object -Skip 1
$datasheets = (Invoke-WebRequest -Uri "$($baseUri)Datasheets.csv" -UseBasicParsing).Content | ConvertFrom-Csv -Delimiter "|" -Header "id", "name", "link", "faction_id", "source_id", "role", "unit_composition", "transport", "power_points", "priest", "psyker", "open_play_only", "crusade_only", "virtual", "cost_per_unit", "Cost" | Select-Object -Skip 1
$wargear = (Invoke-WebRequest -Uri "$($baseUri)Wargear_list.csv" -UseBasicParsing).Content | ConvertFrom-Csv -Delimiter "|" -Header "id", "name", "type", "description", "source_id", "is_relic", "faction_id", "legend" | Select-Object -Skip 1
$datasheetWargear =

matt40k

let
    Source = Web.BrowserContents("https://rpi-imager-stats.raspberrypi.org"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "DIV.row:nth-child(3) > DIV.col-sm:nth-child(1) > TABLE.table.mt-4 > * > TR > :nth-child(1)"}, {"Column2", "DIV.row:nth-child(3) > DIV.col-sm:nth-child(1) > TABLE.table.mt-4 > * > TR > :nth-child(2)"}}, [RowSelector="DIV.row:nth-child(3) > DIV.col-sm:nth-child(1) > TABLE.table.mt-4 > * > TR"]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Image", type text}, {"Percentage", Percentage.Type}}),
    #"Add Timestamp" = Table.AddColumn(#"Changed Type", "Timestamp", each DateTime.LocalNow(), type datetime)
in
    #"Add Timestamp"

matt40k

$apikey = ""
$baseUri = "https://www.googleapis.com/customsearch/v1"
$cx = ""
$query = "site:https://app.powerbi.com"


function GetSearchResults([string]$start)
{
$uri = "$($baseUri)?key=$($apikey)&cx=$($cx)&q=$($query)&start=$($start)"
$c = Invoke-WebRequest -Uri $uri -UseBasicParsing -Method Get

matt40k

# Download URL for the latest Tabular Editor portable:
$TabularEditorUrl = Invoke-RestMethod -uri  https://api.github.com/repos/otykier/TabularEditor/releases/latest | select -ExpandProperty assets | select -expand browser_download_url | ? { $_.Contains("Portable")}

# Download destination (root of PowerShell script execution path):
$DownloadDestination = join-path (get-location) "TabularEditor.zip"

# Download from GitHub:
Invoke-WebRequest -Uri $TabularEditorUrl -OutFile $DownloadDestination

# Unzip Tabular Editor portable, and then delete the zip file:

matt40k

https://projects.raspberrypi.org/en/projects/astro-pi-flight-data-analysis/6

http://www.isstracker.com/historical

matt40k

$removeList = (Invoke-WebRequest -Uri https://gist.githubusercontent.com/matt40k/92b2aefd89f0002c0617cb1c5c9404e0/raw/RemoveList.txt -UseBasicParsing).Content
foreach ($removeItem in $removeList)
{
    Write-Host $removeItem
    Get-appxpackage $removeItem.Trim() -AllUsers | Remove-appxpackage -AllUsers
}

matt40k

$chromeExe = '"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"'
$outputDir = "C:\Temp\"

function GetScreenshot($fileName, $url)
{
    $command = @'
    cmd.exe /C $chromeExe --headless --disable-gpu --screenshot="$outputDir\$fileName.png" --window-size=1920,1024 $url
'@
    Invoke-Expression -Command:$command
}

matt40k

<#  
.SYNOPSIS  
    Extract T-SQL code from multiple RDL files

.NOTES  
    Author     : Arvind Shyamsundar ([email protected])
	
.PARAMETERS
	-RootFolder: full path to the root folder which contains the RDL files
	-Recurse: whether to search sub folders or not