Skip to content

Instantly share code, notes, and snippets.

View Cooluck's full-sized avatar

Roman Rybalchenko Cooluck

View GitHub Profile
// ==UserScript==
// @name VK.com Kill news feed
// @namespace Cooluck
// @author Roman Rybalchenko
// @description Hide all posts from vk.com feed. Скрывает в ленте VK посты.
// @include https://vk.com/feed*
// @include https://vkontakte.ru/feed*
// @require https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js
// @version 0.16
// ==/UserScript==
@philbritton
philbritton / datetable.cs
Created March 21, 2014 00:40
create a killer date table in power query for excel
let CreateDateTable = (StartDate as date, EndDate as date, optional Culture as nullable text) as table =>
let
DayCount = Duration.Days(Duration.From(EndDate - StartDate)),
Source = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),
TableFromList = Table.FromList(Source, Splitter.SplitByNothing()),
ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", type date}}),
RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}),
InsertYear = Table.AddColumn(RenamedColumns, "Year", each Date.Year([Date])),
InsertQuarter = Table.AddColumn(InsertYear, "QuarterOfYear", each Date.QuarterOfYear([Date])),
InsertMonth = Table.AddColumn(InsertQuarter, "MonthOfYear", each Date.Month([Date])),