Jan-Philipp Igla jpigla

Excel Tipps & Tricks

=RECHTS(A2;LÄNGE(A2)-FINDEN("@";WECHSELN(A2;"/";"@";LÄNGE(A2)-LÄNGE(WECHSELN(A2;"/";"")));1))

=DATUM(1970;1;1)+(LINKS([ZELLE];10)/86400)

	function check_position_sistrix_api() {

	const sistrix_key = 'XXX';

	const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('check position with sistrix');

	// Werte (Domain, Device) werden eingelesen
	let domain = sheet.getRange('H7').getValue();
	let device = sheet.getRange('H8').getValue();

	// h/t: https://pastebin.com/WzrQanMx

	// Define the class for your questions and answers here.
	// They should be marked up in a consistent manner.
	var questionClass = 'question';
	var answerClass = 'answer';

	// Output schema to console. Set to `false` if adding via tag manager.
	var logOutput = false;

	function daily_si() {

	const sistrix_key = 'XXX';

	// Führe die Funktion 'append_date' aus, welche das heutige Datum in die Datumsspalte schreibt.
	append_date();

	let ss_si_data = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Tägliche Sichtbarkeit');

	let cell_wip = ss_si_data.getRange('A2');

	# Make a separate list for each airline
	x1 = list(flights[flights['name'] == 'United Air Lines Inc.']['arr_delay'])
	x2 = list(flights[flights['name'] == 'JetBlue Airways']['arr_delay'])
	x3 = list(flights[flights['name'] == 'ExpressJet Airlines Inc.']['arr_delay'])
	x4 = list(flights[flights['name'] == 'Delta Air Lines Inc.']['arr_delay'])
	x5 = list(flights[flights['name'] == 'American Airlines Inc.']['arr_delay'])

	# Assign colors for each airline and the names
	colors = ['#E69F00', '#56B4E9', '#F0E442', '#009E73', '#D55E00']
	names = ['United Air Lines Inc.', 'JetBlue Airways', 'ExpressJet Airlines Inc.'',

	# Start Setup for Jupyter Notebooks
	import pandas as pd
	import numpy as np
	import re
	import matplotlib.pyplot as plt
	%matplotlib inline
	from IPython.display import display as dpl

	# Pandas options
	pd.set_option('display.max_colwidth', None)

	# Python collection
	#
	#

	# list from list without empty values
	list_clean = [x for x in list_orig if str(x) != 'nan']

	const puppeteer = require('puppeteer');
	const devices = require('puppeteer/DeviceDescriptors');
	var fs = require('fs');
	const mergeImg = require('merge-img');
	const ampToolboxCacheUrl = require('amp-toolbox-cache-url').createCacheUrl;

	const Good3G = {
	'offline': false,
	'downloadThroughput': 1.5 * 1024 * 1024 / 8,
	'uploadThroughput': 750 * 1024 / 8,