- Reset master to upstream/main (16,697 commits) - Overlay 2,271 local-only files (skills, tools, workspace, configs, apps) - Restore IDENTITY.md and USER.md templates - Build verified, gateway running, Discord working Co-Authored-By: Claude Opus 4.6 <[email protected]>
51 lines
1.6 KiB
Bash
51 lines
1.6 KiB
Bash
#!/bin/bash
|
|
# Analyze home improvement projects
|
|
|
|
SHEET_ID="1G6KEBQER_qBI3Hau8GUBrhEOf4FrHMtmKypPjD_8pBw"
|
|
CACHE_FILE="/tmp/husprojekt_liste.txt"
|
|
ANALYSIS_FILE="/tmp/husprojekt_analyse.md"
|
|
|
|
# Read fresh data (use read-projects.sh)
|
|
echo "📊 Fetching latest project data..."
|
|
cd "$(dirname "$0")" && bash read-projects.sh > /dev/null 2>&1
|
|
|
|
# Parse and analyze
|
|
echo "🔍 Analyzing projects..."
|
|
|
|
TOTAL_PROJECTS=$(grep -c "|" "$CACHE_FILE" | tail -1)
|
|
echo ""
|
|
echo "📋 Total Projects: $TOTAL_PROJECTS"
|
|
echo ""
|
|
|
|
# Top 10 priorities (lowest number = highest priority)
|
|
echo "🎯 Top 10 Priorities:"
|
|
grep "|" "$CACHE_FILE" | sort -t'|' -k2 -n | head -10 | \
|
|
awk -F'|' '{printf " %2s. %-50s (%s, %s)\n", $2, $1, $3, $4}'
|
|
echo ""
|
|
|
|
# Quick wins (< 1 hour, simple tasks)
|
|
echo "⚡ Quick Wins (< 1 time):"
|
|
grep "|" "$CACHE_FILE" | grep -E "(min|30)" | \
|
|
awk -F'|' '{printf " - %-50s (%s, %s)\n", $1, $3, $4}'
|
|
echo ""
|
|
|
|
# Largest projects (by estimated time)
|
|
echo "🏗️ Largest Projects (by time):"
|
|
grep "|" "$CACHE_FILE" | grep "timer" | \
|
|
sort -t'|' -k3 -rn | head -5 | \
|
|
awk -F'|' '{printf " - %-50s (%s, %s)\n", $1, $3, $4}'
|
|
echo ""
|
|
|
|
# Categories
|
|
echo "📂 Categories:"
|
|
echo " Indvendigt: $(grep -iE "(køkken|stue|soveværelse|badeværelse|kontor|gardarobe)" "$CACHE_FILE" | wc -l)"
|
|
echo " Udvendigt: $(grep -iE "(terasse|skur|facade|have|hoveddør|glasdør)" "$CACHE_FILE" | wc -l)"
|
|
echo " Teknisk: $(grep -iE "(netværk|gulvvarme|smart|stikkontakt)" "$CACHE_FILE" | wc -l)"
|
|
echo ""
|
|
|
|
echo "✅ Analysis complete!"
|
|
echo ""
|
|
echo "📁 Cached to:"
|
|
echo " - $CACHE_FILE"
|
|
echo " - $ANALYSIS_FILE (if exists)"
|