#!/usr/bin/env python3
"""Generated OfficeCLI script for sales-pipeline-q2.xlsx"""
import json, subprocess, tempfile, os
FILE = "sales-pipeline-q2.xlsx"
def batch(commands):
 with tempfile.NamedTemporaryFile(mode="w", suffix=".json", delete=False) as f:
 json.dump(commands, f)
 f.flush()
 result = subprocess.run(
 ["officecli", "batch", FILE, "--input", f.name],
 capture_output=True, text=True
 )
 os.unlink(f.name)
 if result.returncode != 0:
 print(result.stderr or result.stdout)
 raise RuntimeError(f"Batch failed: {result.returncode}")
 print(result.stdout, end="")
subprocess.run(["officecli", "create", FILE], check=True)
# Turn 1: sales-pipeline-q2-turn1
batch(json.loads('[\n {\n "command": "set",\n "path": "/Sheet1",\n "props": {\n "name": "Pipeline"\n }\n },\n {\n "command": "set",\n "path": "/",\n "props": {\n "theme.font.major.latin": "Aptos",\n "theme.font.minor.latin": "Aptos"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A1",\n "props": {\n "value": "Q2 Sales Pipeline Tracker",\n "font.size": 20,\n "bold": true,\n "font.color": "FFFFFF",\n "fill": "0B6E4F",\n "halign": "center",\n "valign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A1:G1",\n "props": {\n "merge": true,\n "fill": "0B6E4F"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/row[1]",\n "props": {\n "height": 42\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A3",\n "props": {\n "value": "Total Pipeline",\n "bold": true,\n "font.color": "0B6E4F",\n "font.size": 10,\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B3",\n "props": {\n "value": "Weighted Value",\n "bold": true,\n "font.color": "0B6E4F",\n "font.size": 10,\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C3",\n "props": {\n "value": "Win Rate",\n "bold": true,\n "font.color": "0B6E4F",\n "font.size": 10,\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D3",\n "props": {\n "value": "Avg Days in Stage",\n "bold": true,\n "font.color": "0B6E4F",\n "font.size": 10,\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A4",\n "props": {\n "formula": "=SUM(C7:C21)",\n "numberFormat": "$#,##0",\n "font.size": 18,\n "bold": true,\n "font.color": "0B6E4F",\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B4",\n "props": {\n "formula": "=SUM(G7:G21)",\n "numberFormat": "$#,##0",\n "font.size": 18,\n "bold": true,\n "font.color": "0B6E4F",\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C4",\n "props": {\n "formula": "=2/15",\n "numberFormat": "0%",\n "font.size": 18,\n "bold": true,\n "font.color": "0B6E4F",\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D4",\n "props": {\n "formula": "=AVERAGEIF(E7:E21,\\">0\\")",\n "numberFormat": "0.0",\n "font.size": 18,\n "bold": true,\n "font.color": "0B6E4F",\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A3:D3",\n "props": {\n "fill": "E8F5E9",\n "border.bottom": "thin",\n "border.bottom.color": "0B6E4F"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A4:D4",\n "props": {\n "fill": "F5F5DC",\n "border.bottom": "medium",\n "border.bottom.color": "C8A951"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A6",\n "props": {\n "value": "Company",\n "bold": true,\n "font.color": "FFFFFF",\n "fill": "0B6E4F",\n "halign": "center",\n "font.size": 11\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B6",\n "props": {\n "value": "Stage",\n "bold": true,\n "font.color": "FFFFFF",\n "fill": "0B6E4F",\n "halign": "center",\n "font.size": 11\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C6",\n "props": {\n "value": "Deal Size",\n "bold": true,\n "font.color": "FFFFFF",\n "fill": "0B6E4F",\n "halign": "center",\n "font.size": 11\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D6",\n "props": {\n "value": "Owner",\n "bold": true,\n "font.color": "FFFFFF",\n "fill": "0B6E4F",\n "halign": "center",\n "font.size": 11\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E6",\n "props": {\n "value": "Days in Stage",\n "bold": true,\n "font.color": "FFFFFF",\n "fill": "0B6E4F",\n "halign": "center",\n "font.size": 11\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F6",\n "props": {\n "value": "Stage Key",\n "bold": true,\n "font.color": "FFFFFF",\n "fill": "0B6E4F",\n "halign": "center",\n "font.size": 11\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G6",\n "props": {\n "value": "Weighted Value",\n "bold": true,\n "font.color": "FFFFFF",\n "fill": "0B6E4F",\n "halign": "center",\n "font.size": 11\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/row[6]",\n "props": {\n "height": 24\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A7",\n "props": {\n "value": "Acme Corp"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B7",\n "props": {\n "value": "Prospecting"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C7",\n "props": {\n "value": 45000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D7",\n "props": {\n "value": "Sarah Chen"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E7",\n "props": {\n "value": 12\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F7",\n "props": {\n "formula": "=B7"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G7",\n "props": {\n "formula": "=IF(B7=\\"Prospecting\\",C7*0.1,IF(B7=\\"Discovery\\",C7*0.25,IF(B7=\\"Proposal Sent\\",C7*0.5,IF(B7=\\"Negotiation\\",C7*0.75,IF(B7=\\"Closed Won\\",C7*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A8",\n "props": {\n "value": "Bolt Industries"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B8",\n "props": {\n "value": "Discovery"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C8",\n "props": {\n "value": 120000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D8",\n "props": {\n "value": "Marcus Webb"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E8",\n "props": {\n "value": 8\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F8",\n "props": {\n "formula": "=B8"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G8",\n "props": {\n "formula": "=IF(B8=\\"Prospecting\\",C8*0.1,IF(B8=\\"Discovery\\",C8*0.25,IF(B8=\\"Proposal Sent\\",C8*0.5,IF(B8=\\"Negotiation\\",C8*0.75,IF(B8=\\"Closed Won\\",C8*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A9",\n "props": {\n "value": "Crescent Health"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B9",\n "props": {\n "value": "Proposal Sent"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C9",\n "props": {\n "value": 87000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D9",\n "props": {\n "value": "Sarah Chen"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E9",\n "props": {\n "value": 21\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F9",\n "props": {\n "formula": "=B9"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G9",\n "props": {\n "formula": "=IF(B9=\\"Prospecting\\",C9*0.1,IF(B9=\\"Discovery\\",C9*0.25,IF(B9=\\"Proposal Sent\\",C9*0.5,IF(B9=\\"Negotiation\\",C9*0.75,IF(B9=\\"Closed Won\\",C9*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A10",\n "props": {\n "value": "DataPulse Inc"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B10",\n "props": {\n "value": "Negotiation"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C10",\n "props": {\n "value": 210000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D10",\n "props": {\n "value": "Marcus Webb"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E10",\n "props": {\n "value": 5\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F10",\n "props": {\n "formula": "=B10"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G10",\n "props": {\n "formula": "=IF(B10=\\"Prospecting\\",C10*0.1,IF(B10=\\"Discovery\\",C10*0.25,IF(B10=\\"Proposal Sent\\",C10*0.5,IF(B10=\\"Negotiation\\",C10*0.75,IF(B10=\\"Closed Won\\",C10*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A11",\n "props": {\n "value": "Evergreen Solutions"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B11",\n "props": {\n "value": "Closed Won"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C11",\n "props": {\n "value": 65000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D11",\n "props": {\n "value": "Li Zhang"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E11",\n "props": {\n "value": 0\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F11",\n "props": {\n "formula": "=B11"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G11",\n "props": {\n "formula": "=IF(B11=\\"Prospecting\\",C11*0.1,IF(B11=\\"Discovery\\",C11*0.25,IF(B11=\\"Proposal Sent\\",C11*0.5,IF(B11=\\"Negotiation\\",C11*0.75,IF(B11=\\"Closed Won\\",C11*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A12",\n "props": {\n "value": "FairPoint Media"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B12",\n "props": {\n "value": "Discovery"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C12",\n "props": {\n "value": 33000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D12",\n "props": {\n "value": "Li Zhang"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E12",\n "props": {\n "value": 14\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F12",\n "props": {\n "formula": "=B12"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G12",\n "props": {\n "formula": "=IF(B12=\\"Prospecting\\",C12*0.1,IF(B12=\\"Discovery\\",C12*0.25,IF(B12=\\"Proposal Sent\\",C12*0.5,IF(B12=\\"Negotiation\\",C12*0.75,IF(B12=\\"Closed Won\\",C12*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A13",\n "props": {\n "value": "GreenLeaf Tech"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B13",\n "props": {\n "value": "Proposal Sent"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C13",\n "props": {\n "value": 175000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D13",\n "props": {\n "value": "Sarah Chen"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E13",\n "props": {\n "value": 30\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F13",\n "props": {\n "formula": "=B13"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G13",\n "props": {\n "formula": "=IF(B13=\\"Prospecting\\",C13*0.1,IF(B13=\\"Discovery\\",C13*0.25,IF(B13=\\"Proposal Sent\\",C13*0.5,IF(B13=\\"Negotiation\\",C13*0.75,IF(B13=\\"Closed Won\\",C13*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A14",\n "props": {\n "value": "Horizon Labs"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B14",\n "props": {\n "value": "Prospecting"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C14",\n "props": {\n "value": 52000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D14",\n "props": {\n "value": "Marcus Webb"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E14",\n "props": {\n "value": 19\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F14",\n "props": {\n "formula": "=B14"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G14",\n "props": {\n "formula": "=IF(B14=\\"Prospecting\\",C14*0.1,IF(B14=\\"Discovery\\",C14*0.25,IF(B14=\\"Proposal Sent\\",C14*0.5,IF(B14=\\"Negotiation\\",C14*0.75,IF(B14=\\"Closed Won\\",C14*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A15",\n "props": {\n "value": "IntelliWare"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B15",\n "props": {\n "value": "Negotiation"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C15",\n "props": {\n "value": 98000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D15",\n "props": {\n "value": "Li Zhang"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E15",\n "props": {\n "value": 11\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F15",\n "props": {\n "formula": "=B15"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G15",\n "props": {\n "formula": "=IF(B15=\\"Prospecting\\",C15*0.1,IF(B15=\\"Discovery\\",C15*0.25,IF(B15=\\"Proposal Sent\\",C15*0.5,IF(B15=\\"Negotiation\\",C15*0.75,IF(B15=\\"Closed Won\\",C15*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A16",\n "props": {\n "value": "JetStream Analytics"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B16",\n "props": {\n "value": "Closed Lost"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C16",\n "props": {\n "value": 140000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D16",\n "props": {\n "value": "Sarah Chen"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E16",\n "props": {\n "value": 0\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F16",\n "props": {\n "formula": "=B16"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G16",\n "props": {\n "formula": "=IF(B16=\\"Prospecting\\",C16*0.1,IF(B16=\\"Discovery\\",C16*0.25,IF(B16=\\"Proposal Sent\\",C16*0.5,IF(B16=\\"Negotiation\\",C16*0.75,IF(B16=\\"Closed Won\\",C16*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A17",\n "props": {\n "value": "KnightBridge Capital"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B17",\n "props": {\n "value": "Discovery"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C17",\n "props": {\n "value": 310000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D17",\n "props": {\n "value": "Marcus Webb"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E17",\n "props": {\n "value": 3\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F17",\n "props": {\n "formula": "=B17"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G17",\n "props": {\n "formula": "=IF(B17=\\"Prospecting\\",C17*0.1,IF(B17=\\"Discovery\\",C17*0.25,IF(B17=\\"Proposal Sent\\",C17*0.5,IF(B17=\\"Negotiation\\",C17*0.75,IF(B17=\\"Closed Won\\",C17*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A18",\n "props": {\n "value": "LunarEdge Systems"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B18",\n "props": {\n "value": "Proposal Sent"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C18",\n "props": {\n "value": 72000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D18",\n "props": {\n "value": "Li Zhang"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E18",\n "props": {\n "value": 25\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F18",\n "props": {\n "formula": "=B18"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G18",\n "props": {\n "formula": "=IF(B18=\\"Prospecting\\",C18*0.1,IF(B18=\\"Discovery\\",C18*0.25,IF(B18=\\"Proposal Sent\\",C18*0.5,IF(B18=\\"Negotiation\\",C18*0.75,IF(B18=\\"Closed Won\\",C18*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A19",\n "props": {\n "value": "Mosaic Digital"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B19",\n "props": {\n "value": "Prospecting"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C19",\n "props": {\n "value": 41000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D19",\n "props": {\n "value": "Sarah Chen"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E19",\n "props": {\n "value": 7\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F19",\n "props": {\n "formula": "=B19"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G19",\n "props": {\n "formula": "=IF(B19=\\"Prospecting\\",C19*0.1,IF(B19=\\"Discovery\\",C19*0.25,IF(B19=\\"Proposal Sent\\",C19*0.5,IF(B19=\\"Negotiation\\",C19*0.75,IF(B19=\\"Closed Won\\",C19*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A20",\n "props": {\n "value": "NorthStar Logistics"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B20",\n "props": {\n "value": "Negotiation"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C20",\n "props": {\n "value": 155000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D20",\n "props": {\n "value": "Marcus Webb"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E20",\n "props": {\n "value": 16\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F20",\n "props": {\n "formula": "=B20"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G20",\n "props": {\n "formula": "=IF(B20=\\"Prospecting\\",C20*0.1,IF(B20=\\"Discovery\\",C20*0.25,IF(B20=\\"Proposal Sent\\",C20*0.5,IF(B20=\\"Negotiation\\",C20*0.75,IF(B20=\\"Closed Won\\",C20*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A21",\n "props": {\n "value": "OmniTech Partners"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B21",\n "props": {\n "value": "Closed Won"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/C21",\n "props": {\n "value": 88000,\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/D21",\n "props": {\n "value": "Li Zhang"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/E21",\n "props": {\n "value": 0\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/F21",\n "props": {\n "formula": "=B21"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/G21",\n "props": {\n "formula": "=IF(B21=\\"Prospecting\\",C21*0.1,IF(B21=\\"Discovery\\",C21*0.25,IF(B21=\\"Proposal Sent\\",C21*0.5,IF(B21=\\"Negotiation\\",C21*0.75,IF(B21=\\"Closed Won\\",C21*1,0)))))",\n "numberFormat": "$#,##0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A7:A21",\n "props": {\n "font.size": 10,\n "bold": true,\n "font.color": "333333"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/B7:G21",\n "props": {\n "font.size": 10,\n "halign": "center"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A7:G21",\n "props": {\n "border.all": "thin",\n "border.color": "D0D0D0"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A7:G7",\n "props": {\n "fill": "F5F5DC"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A9:G9",\n "props": {\n "fill": "F5F5DC"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A11:G11",\n "props": {\n "fill": "F5F5DC"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A13:G13",\n "props": {\n "fill": "F5F5DC"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A15:G15",\n "props": {\n "fill": "F5F5DC"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A17:G17",\n "props": {\n "fill": "F5F5DC"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A19:G19",\n "props": {\n "fill": "F5F5DC"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A21:G21",\n "props": {\n "fill": "F5F5DC"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A8:G8",\n "props": {\n "fill": "FFFFFF"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A10:G10",\n "props": {\n "fill": "FFFFFF"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A12:G12",\n "props": {\n "fill": "FFFFFF"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A14:G14",\n "props": {\n "fill": "FFFFFF"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A16:G16",\n "props": {\n "fill": "FFFFFF"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A18:G18",\n "props": {\n "fill": "FFFFFF"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/A20:G20",\n "props": {\n "fill": "FFFFFF"\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/col[A]",\n "props": {\n "width": 22\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/col[B]",\n "props": {\n "width": 16\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/col[C]",\n "props": {\n "width": 14\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/col[D]",\n "props": {\n "width": 16\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/col[E]",\n "props": {\n "width": 15\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/col[F]",\n "props": {\n "width": 16,\n "hidden": true\n }\n },\n {\n "command": "set",\n "path": "/Pipeline/col[G]",\n "props": {\n "width": 16\n }\n },\n {\n "command": "add",\n "parent": "/Pipeline",\n "type": "formulacf",\n "props": {\n "sqref": "E7:E21",\n "formula": "=AND(E7<10,e7>0)",\n "fill": "C6EFCE",\n "font.color": "006100"\n }\n },\n {\n "command": "add",\n "parent": "/Pipeline",\n "type": "formulacf",\n "props": {\n "sqref": "E7:E21",\n "formula": "=AND(E7>=10,E7<=20)",\n "fill": "FFEB9C",\n "font.color": "9C6500"\n }\n },\n {\n "command": "add",\n "parent": "/Pipeline",\n "type": "formulacf",\n "props": {\n "sqref": "E7:E21",\n "formula": "=E7>20",\n "fill": "FFC7CE",\n "font.color": "9C0006"\n }\n },\n {\n "command": "add",\n "parent": "/Pipeline",\n "type": "chart",\n "props": {\n "chartType": "barStacked",\n "title": "Pipeline Value by Rep & Stage",\n "series1": "Prospecting:86000,52000,0",\n "series2": "Discovery:0,430000,33000",\n "series3": "Proposal Sent:262000,0,72000",\n "series4": "Negotiation:0,365000,98000",\n "series5": "Closed Won:0,0,153000",\n "series6": "Closed Lost:140000,0,0",\n "categories": "Sarah Chen,Marcus Webb,Li Zhang",\n "colors": "88C999,3CB371,C8A951,D4AF37,0B6E4F,CC4444",\n "x": 0,\n "y": 23,\n "width": 7,\n "height": 18,\n "legend": "bottom",\n "axisTitle": "Deal Value ($)",\n "axisNumFmt": "$#,##0",\n "chartFill": "FAFAFA",\n "plotFill": "FFFFFF",\n "gapwidth": 80,\n "title.size": 13,\n "title.bold": true,\n "title.color": "0B6E4F",\n "legendfont": "9:555555:Aptos",\n "axisfont": "9:555555:Aptos"\n }\n }\n]'))
# Turn 2: sales-pipeline-q2-turn2
batch(json.loads('[\n {\n "command": "set",\n "path": "/Pipeline",\n "props": {\n "freeze": "A7"\n }\n }\n]'))
subprocess.run(["officecli", "validate", FILE], check=True)
print(f"\nDone: {FILE}")
</div><div class="naked_ctrl">
<form action="/index.cgi/contrast" method="get" name="gate">
<p><a href="http://altstyle.alfasado.net">AltStyle</a> によって変換されたページ <a href="https://raw.githubusercontent.com/wiki/iOfficeAI/OfficeCLI/use-cases/excel/files/sales-pipeline-q2.py">(-&gt;オリジナル)</a>
/ <label>アドレス: <input type="text" name="naked_post_url" value="https://raw.githubusercontent.com/wiki/iOfficeAI/OfficeCLI/use-cases/excel/files/sales-pipeline-q2.py" size="22" /></label> <label>モード: <select name="naked_post_mode">
<option value="default">デフォルト</option>
<option value="speech">音声ブラウザ</option>
<option value="ruby">ルビ付き</option>
<option value="contrast" selected="selected">配色反転</option>
<option value="larger-text">文字拡大</option>
<option value="mobile">モバイル</option>
</select>
<input type="submit" value="表示" />
</p>
</form>
</div>