ngs

dev-troubleshoot

Mac の開発環境トラブルシューティング用スクリプト集。

スクリプト一覧

スクリプト	用途
fix-colima.sh	Colima ディスクロック解除 & 再起動
start-dev-services.sh	開発サービス一括起動 (Colima + DynamoDB + MySQL)

ngs

GET /screen1.png HTTP/2.0
Host: fa839ff20af6a7f2f5e4g19bf1ayyyyyb.oast.me
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
Accept-Encoding: gzip, deflate, br, zstd
Accept-Language: zh-CN,zh;q=0.9
Priority: u=0, i
Sec-Ch-Ua: "Not(A:Brand";v="8", "Chromium";v="144", "Google Chrome";v="144"
Sec-Ch-Ua-Mobile: ?0
Sec-Ch-Ua-Platform: "Windows"
Sec-Fetch-Dest: document

ngs

1. 月次集計シート - SUMIFS/COUNTIFS式 (行129, 132, 138, 141):

=COUNTIFS('売上データ'!B:B,">="&DATE(2024,{month},1),'売上データ'!B:B,"<"&DATE(2024,{month+1 if month < 12 else 1},1))
=SUMIFS('計算シート'!F:F,'売上データ'!B:B,">="&DATE(2024,{month},1),'売上データ'!B:B,"<"&DATE(2024,{month+1 if month < 12 else 1},1))

複数条件での集計、日付関数、シート間参照を組み合わせた複雑な式。

2. カテゴリ分析シート - ABC分類式 (行221):

ngs

// http://jan5.fc2web.com/model/mr_color.html
[cols, ...rows] = $$('table[border="1"] tr').map(tr => Array.from(tr.childNodes).filter(cn => cn.nodeName === 'TD').map(td => td.getAttribute('bgcolor') || td.innerText))
'| ' + cols.join(' | ') + ' |\n| ---- | ---- | ---- | ---- | ---- | ---- |\n| ' + rows.map(row => row.join(' | ').replace(/\n/g, '<br>')).join(' |\n| ').replace(/#([A-F0-9]{6})/g, '![$1](https://dummyimage.com/20x20/$1/fff&text=+)')

ngs

# /etc/systemd/system/gpio-watch.service

[Unit]
Description=gpio-watch is a tool for running scripts in response to GPIO events.

[Service]
User=root
WorkingDirectory=/root
ExecStart=/usr/bin/gpio-watch 6:rising
Restart=always

ngs

MusicDir = /home/pi/music

ALSADevice = default
ALSAMixer1 = Headphone
#ALSAMixer2 = Master

ALSAStutterDefeat = no

ngs

#include <Arduino_MKRIoTCarrier.h>
MKRIoTCarrier carrier;
float temperature = 0;
float humidity = 0;
float pressure = 0;
float gyroscope_x, gyroscope_y, gyroscope_z;
float accelerometer_x, accelerometer_y, accelerometer_z;
float pixel = 3, r = 25, g = 20, b = 40;
int none = 0;
int light = 1;

ngs

// tinyCylon_2_1.c
// 22 february 2010 - dale wheat - added mode memory
// based on tinyCylon2.c
// revised firmware for tinyCylon LED scanner
// written by dale wheat - 18 november 2008
// based on behavior of original tinyCylon firmware

// notes:

// device = ATtiny13A

ngs

# https://docs.docker.com/engine/install/ubuntu/

apt-get update -y

apt-get install -y \
    apt-transport-https \
    ca-certificates \
    curl \
    gnupg-agent \
    software-properties-common

ngs

/**
 * Responds to any HTTP request.
 *
 * @param {!express:Request} req HTTP request context.
 * @param {!express:Response} res HTTP response context.
 */

const fetch = require('node-fetch');

exports.handle = async (req, res) => {