🖨️ — Cost Sheet Generator

Cloud-native version of the Art Pro Sublimation desktop cost sheet tool. Provide image URLs, set your rate, and get back a branded Excel invoice — ready to download and print on A4.

---

How It Works

1. You provide a list of image URLs (print-ready files)
2. The actor downloads each image, reads its pixel dimensions and DPI
3. It parses the filename to extract quantity and description
4. It calculates area (sqft) and cost at your specified rate
5. It generates a branded .xlsx invoice with the full Art Pro layout
6. The Excel file is stored in the Key-Value Store with a direct download URL

---

Filename Convention

Images should follow this naming pattern for automatic parsing:

{number}{separator}{quantity}{description}.ext

Example Filename	File #	Qty	Description
1-2 Large Banner.jpg	1	2	Large Banner
2-1_SmallPoster.png	2	1	SmallPoster
3-5 Flex Board.tif	3	5	Flex Board
logo.jpg	0	1	logo (fallback)

---

Input Example

{
    "images": [
        { "url": "https://example.com/1-2_LargeBanner.jpg" },
        { "url": "https://example.com/2-1_SmallPoster.png", "filename": "2-1 Small Poster.png" },
        { "url": "https://example.com/3-5_FlexBoard.tif" }
    ],
    "rate": 35,
    "invoiceNo": "INV-0042",
    "customerName": "Ali Traders",
    "folderName": "March Batch",
    "designer": "Usman",
    "comments": "Urgent delivery",
    "printType": "CHINA/NORMAL/FLU",
    "logoUrl": "https://example.com/logo.jpeg",
    "outputFilename": "cost_sheet.xlsx"
}

---

Output

1. Excel Cost Sheet (.xlsx)

Stored in the Key-Value Store. The direct download URL is included in both the actor logs and the dataset output, e.g.:

https://api.apify.com/v2/key-value-stores/{id}/records/cost_sheet.xlsx

The Excel file features:

• Yellow / Blue / Orange branded accent stripes
• Black header band with company name and contact
• Rate and QR area in the header
• Invoice metadata (number, customer, designer, comments)
• 10-column data table (S No, QTY, Description, W×L, T/F, Price, Amount)
• Alternating row shading
• Auto multi-sheet (new sheet every 35 items, continuous numbering)
• Grand totals in PKR
• Fit-to-page A4 print layout

2. Structured JSON Summary

Pushed to the Dataset output:

• download_url — direct link to the Excel file
• total_sqft, total_cost_pkr — grand totals
• line_items[] — per-image breakdown (dimensions, DPI, cost)
• skipped[] — any images that failed with error details

---

Configuration

Parameter	Type	Default	Description
images	array	(required)	Image objects with url and optional filename
rate	integer	35	PKR per square foot
lengthOverride	integer	0	Force width in inches (0 = auto from DPI)
invoiceNo	string	""	Invoice reference number
customerName	string	""	Customer name on the invoice
folderName	string	""	Order / folder label
designer	string	""	Designer name
comments	string	""	Comments line
printType	string	CHINA/NORMAL/FLU	Print type label
logoUrl	string	""	URL to a logo image for the header
outputFilename	string	cost_sheet.xlsx	Output filename

---

License

ISC