Haruo Kinoshita haruo31

## BreakUpCells.bas
Option Explicit

Sub breakUpMergedCells()
    Dim curSheet As Worksheet
    Dim eCell As Range, curRange As Range
    Dim curAddr As String
    Dim fillCell As Range
    Dim filledValue As String

    Set curSheet = ActiveSheet

## ProcessBroker.java
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.Reader;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

/**
 * ProcessBroker pb = new ProcessBroker("ps -ef | grep java".split(" "));

## generate_ios_icons.sh
#!/bin/sh
#
# Copyright 2017 haruo31 <haruo31@underthetree.jp>
# Original by 2014 Wenva <lvyexuwenfa100@126.com>
#
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is furnished

## readme.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                haruo31
                / readme.md
            
            
              Last active
              July 27, 2018 04:38
            
              
                放送大学の単位認定試験 過去問PDFを Mac（もしくはLinux, 要はghostscriptで）でまとめる手順
              
          
    目的

過去問と回答が大学Webサービスからダウンロードできるが、学期ごとに全部バラバラで非常に管理がしにくいので、科目ごとに結合して１つのPDFとして扱えるようにする。
準備

適当なディレクトリに必要な科目の過去問と回答をダウンロードして保存する。自分は２期分を保存した。

  
## shell command
$ find . -name '*.m2ts' | xargs stat -c%s | paste -s -d+ | bc

## Sample2Main.java
package jp.underthetree;

import java.io.*;

import org.apache.lucene.document.Document;
import org.apache.lucene.document.Field.Store;
import org.apache.lucene.document.StringField;
import org.apache.lucene.index.DirectoryReader;
import org.apache.lucene.index.IndexWriter;
import org.apache.lucene.index.IndexWriterConfig;

## SampleMain.java
package sample;

import java.io.BufferedReader;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.UncheckedIOException;
import java.nio.file.Files;
import java.util.Random;

## howm-haruo31.rcp
(:name howm-haruo31
       :website "http://howm.sourceforge.jp/"
       :description "Write fragmentarily and read collectively."
       :type http-tar
       :options ("xzf")
       :url "http://howm.sourceforge.jp/a/howm-1.4.3.tar.gz"
       :build `(("./configure" ,(concat "--with-emacs=" el-get-emacs)) ("make")))

## dvdrip.sh
#!/bin/sh

set -xe

DRIVE=/dev/sr0
TARGET=`pwd`
TMP=`mktemp -d --suffix=dvdbackup -p $TARGET`

pushd $TMP
dvdbackup -M -i $DRIVE

## determine_dirname.sh
#!/bin/sh

BASE=`dirname $0 | xargs -I\{\} sh -c "cd {}; pwd"`
	Option Explicit

	Sub breakUpMergedCells()
	Dim curSheet As Worksheet
	Dim eCell As Range, curRange As Range
	Dim curAddr As String
	Dim fillCell As Range
	Dim filledValue As String

	Set curSheet = ActiveSheet
	import java.io.IOException;
	import java.io.InputStream;
	import java.io.InputStreamReader;
	import java.io.Reader;
	import java.util.ArrayList;
	import java.util.Arrays;
	import java.util.List;

	/**
	* ProcessBroker pb = new ProcessBroker("ps -ef \| grep java".split(" "));
	#!/bin/sh
	#
	# Copyright 2017 haruo31 <haruo31@underthetree.jp>
	# Original by 2014 Wenva <lvyexuwenfa100@126.com>
	#
	# Permission is hereby granted, free of charge, to any person obtaining a copy
	# of this software and associated documentation files (the "Software"), to deal
	# in the Software without restriction, including without limitation the rights
	# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
	# copies of the Software, and to permit persons to whom the Software is furnished
	package jp.underthetree;

	import java.io.*;

	import org.apache.lucene.document.Document;
	import org.apache.lucene.document.Field.Store;
	import org.apache.lucene.document.StringField;
	import org.apache.lucene.index.DirectoryReader;
	import org.apache.lucene.index.IndexWriter;
	import org.apache.lucene.index.IndexWriterConfig;
	package sample;

	import java.io.BufferedReader;
	import java.io.File;
	import java.io.IOException;
	import java.io.InputStream;
	import java.io.InputStreamReader;
	import java.io.UncheckedIOException;
	import java.nio.file.Files;
	import java.util.Random;
	(:name howm-haruo31
	:website "http://howm.sourceforge.jp/"
	:description "Write fragmentarily and read collectively."
	:type http-tar
	:options ("xzf")
	:url "http://howm.sourceforge.jp/a/howm-1.4.3.tar.gz"
	:build `(("./configure" ,(concat "--with-emacs=" el-get-emacs)) ("make")))
	#!/bin/sh

	set -xe

	DRIVE=/dev/sr0
	TARGET=`pwd`
	TMP=`mktemp -d --suffix=dvdbackup -p $TARGET`

	pushd $TMP
	dvdbackup -M -i $DRIVE
	#!/bin/sh

	BASE=`dirname $0 \| xargs -I\{\} sh -c "cd {}; pwd"`