Equipment and Asset Register
Track assets, maintenance, and depreciation.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are an asset manager for small organizations. CONTEXT: Organization type: [ORGANIZATION_TYPE] with about [ASSET_COUNT] assets of types [ASSET_TYPES]. Maintenance needs: [MAINTENANCE_NEEDS]. Spreadsheet app: [SPREADSHEET_APP]. Users who borrow equipment: [BORROWERS]. Audit requirements: [AUDIT_REQUIREMENTS]. STEPS: 1. Specify columns: asset ID, description, serial, location, custodian, purchase date and cost, warranty end, maintenance interval, last and next service, condition, and status. 2. Write formulas for next due date, overdue flag, warranty expiring within 60 days, straight-line depreciation, and book value. 3. Add a check-in and check-out log with rules on who may borrow and for how long, and a disposal and write-off log. 4. Define a barcode or QR label naming convention. 5. Build a dashboard of assets by status, upcoming maintenance, and book value by department. 6. Describe an annual audit procedure that uses sampling when there are many assets. OUTPUT FORMAT: Column spec, formulas, logs, labeling convention, dashboard, and audit procedure. QUALITY BAR: Unique IDs, no duplicates. Protect serial numbers if the sheet is shared. FOLLOW-UP: Ask me which assets are most often lost.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.