Brad Landers bradland

## gear_map.csv

          
            id
            gear

            
              0
              R

            
              1
              N

            
              2
              1st

            
              3
              2nd

            
              4
              3rd

            
              5
              4th

            
              6
              5th

            
              7
              6th

            
              8
              7th

## gs_data_updater.js
function onOpen(e) {
   SpreadsheetApp.getUi()
       .createMenu('Data Mgmt')
       .addItem('Refresh Pipeline Data', 'getData')
       .addToUi();
 }

function getData() {
  // 'Data Import' sheet uses IMPORTDATA() function to pull CSV data from Pipeline application. This function
  // only updates once an hour by default. This formula is used to alter the import URL so that the function

## 488 GT3 In Gear Acceleration Test.csv

          
            lap_time
            throttle
            mph
            rpm
            gear
            hg
            fg

            
              172264
              1.00
              27.66
              3139.65
              2
              -0.04
              0.52

            
              172280
              1.00
              27.86
              3161.41
              2
              -0.04
              0.57

            
              172296
              1.00
              28.06
              3177.08
              2
              -0.04
              0.59

            
              172316
              1.00
              28.32
              3205.00
              2
              -0.03
              0.60

            
              172332
              1.00
              28.53
              3229.73
              2
              -0.01
              0.60

            
              172348
              1.00
              28.74
              3254.50
              2
              0.00
              0.62

            
              172364
              1.00
              28.95
              3279.07
              2
              0.01
              0.61

            
              172384
              1.00
              29.23
              3310.62
              2
              0.03
              0.61

            
              172396
              1.00
              29.39
              3331.57
              2
              0.03
              0.63

## ac-telemetry.rb
#!/usr/bin/env ruby

$: << './lib'

require 'socket'
require 'bindata'
require 'json'

class UTF8String < BinData::String
  def snapshot

## pingr
#!/usr/bin/env ruby

require 'logger'
require 'open3'
require 'optparse'
require 'ostruct'
require 'thread'

class ShellScript

## movtogif
#!/bin/bash

# argument one is the input base file name

#ffmpeg -i $1.flv -vcodec png -vframes 1 -ss 00:00:$2 -an -f rawvideo -s 640x480 $1-640x480.png
ffmpeg -i $1 -s 600x400 -pix_fmt rgb24 -r 10 -f gif - | gifsicle --optimize=3 --delay=15 > out.gif

## pcars_net.rb
require 'bindata'

# Record definition
class PCarsNet < BinData::Record
  endian :little

  uint16 :build_version_number # 0
  uint8 :packet_type # 2
  bit4 :session_state # 3
  bit4 :game_state # 3

## axlsx_defined_name_issue.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                bradland
                / axlsx_defined_name_issue.md
            
            
              Created
              August 16, 2015 19:56
            
          
    Description and reproduction

Running the script axlsx_print_area.rb (provided at end of issue) will produce an Excel workbook that, when unzipped, contains the workbook.xml contents; also provided below. It can be observed that the name attributes of the <definedName> nodes have been altered from their original form. This has a couple of undesirable side-effects.


It breaks behavior specified in the examples (repeating headers). Repeating headers are not actually produced.


Tangentially, it prevents one from using any of the built-in names specified in the source of Axlsx::DefinedName.


It mangles valid defined names, leading to confusion. For example, if the defined name "Example_Range" is specified, it will be converted to "ExampleRange".


## axlsx_print_area.rb
require 'axlsx'
require 'pry'

p = Axlsx::Package.new
wb = p.workbook

# Build up a matrix of data
cols = ("A".."L").to_a
rows = (1..100).map do |i|
  cols.zip(cols.dup.fill(i.to_s)).map(&:join)

## fosl_ext_layout.txt
─ lib
  ├── fosl_ext
  │   └── parser.rb
  └── fosl_ext.rb
	function onOpen(e) {
	SpreadsheetApp.getUi()
	.createMenu('Data Mgmt')
	.addItem('Refresh Pipeline Data', 'getData')
	.addToUi();
	}

	function getData() {
	// 'Data Import' sheet uses IMPORTDATA() function to pull CSV data from Pipeline application. This function
	// only updates once an hour by default. This formula is used to alter the import URL so that the function
lap_time	throttle	mph	rpm	gear	hg	fg
172264	1.00	27.66	3139.65	2	-0.04	0.52
172280	1.00	27.86	3161.41	2	-0.04	0.57
172296	1.00	28.06	3177.08	2	-0.04	0.59
172316	1.00	28.32	3205.00	2	-0.03	0.60
172332	1.00	28.53	3229.73	2	-0.01	0.60
172348	1.00	28.74	3254.50	2	0.00	0.62
172364	1.00	28.95	3279.07	2	0.01	0.61
172384	1.00	29.23	3310.62	2	0.03	0.61
172396	1.00	29.39	3331.57	2	0.03	0.63
	#!/usr/bin/env ruby

	$: << './lib'

	require 'socket'
	require 'bindata'
	require 'json'

	class UTF8String < BinData::String
	def snapshot
	#!/usr/bin/env ruby

	require 'logger'
	require 'open3'
	require 'optparse'
	require 'ostruct'
	require 'thread'

	class ShellScript
	#!/bin/bash

	# argument one is the input base file name

	#ffmpeg -i $1.flv -vcodec png -vframes 1 -ss 00:00:$2 -an -f rawvideo -s 640x480 $1-640x480.png
	ffmpeg -i $1 -s 600x400 -pix_fmt rgb24 -r 10 -f gif - \| gifsicle --optimize=3 --delay=15 > out.gif
	require 'bindata'

	# Record definition
	class PCarsNet < BinData::Record
	endian :little

	uint16 :build_version_number # 0
	uint8 :packet_type # 2
	bit4 :session_state # 3
	bit4 :game_state # 3
	require 'axlsx'
	require 'pry'

	p = Axlsx::Package.new
	wb = p.workbook

	# Build up a matrix of data
	cols = ("A".."L").to_a
	rows = (1..100).map do \|i\|
	cols.zip(cols.dup.fill(i.to_s)).map(&:join)
	─ lib
	├── fosl_ext
	│ └── parser.rb
	└── fosl_ext.rb