Picture Zero | albert Toolkit Data Entry
albert Toolkit
Data Entry Portal
⚙ Admin / Configure
Picture Zero
Albert Toolkit
PICTURE ZERO
🏠Home
On Set
🍽️Food
💧Bottled Water
📦Materials
♻️Waste
Utilities
⚡Energy + Water
🔋Generators
Travel
🚗Vehicle Fuel
✈️Air Travel
🚂Rail Travel
⛵Boat Travel
Logistics
📦Couriers
🚢Freight
🏨Accommodation
albert Toolkit
Select a category below to log data.
On Set
🍽️
Food
Daily meal counts
💧
Bottled Water
Water deliveries
🪣
Materials
8 material types
♻️
Waste
Disposal & recycling
Utilities
⚡
Energy + Water
Utility bills & meters
🔋
Generators
Fuel deliveries
Travel
🚗
Vehicle Fuel
Vehicles & fuel
✈️
Air Travel
Flights
🚂
Rail Travel
Train journeys
⛵
Boat Travel
Ferries & boats
Logistics
📦
Couriers
Air, moto & van
🚢
Freight
Sea & rail freight
🏨
Accommodation
Hotel & housing
Energy + Water
Log each utility bill or meter reading as a separate entry.
Utility Consumption Entry
Generators
Log each fuel delivery or generator usage entry.
Vehicle Fuel
Log fuel use and mileage for all production vehicles.
Air Travel
Log all flights — commercial, chartered, and helicopter.
Rail Travel
Log all train journeys.
Boat Travel
Log ferry journeys and filming boat fuel usage.
Couriers
Log air, motorcycle, and van/HGV courier shipments.
Air Consignment
Motorcycle Courier
Truck / Van / HGV Courier
Freight
Log train, sea tanker and cargo ship freight movements.
Accommodation
Log all production accommodation bookings.
Food
Log meal counts by type for each catering day.
Bottled Water
Log all bottled water deliveries.
Materials
Log consumption of batteries, paper, paint, cardboard, metal, plastic, textiles and timber.
Batteries
Paper
Paint
Cardboard
Plastics
Metal
Textiles
Timber
Waste
Log all waste collection and disposal entries.

⚙ Configuration

Add each production and the URL of its albert Toolkit spreadsheet on SharePoint.
Register an app in Azure AD (portal.azure.com) with delegated permissions: Files.ReadWrite and Sites.ReadWrite.All. Set the redirect URI to the URL where this app is hosted as a Single-page application.

Step 1 — Register an Azure AD App
Go to portal.azure.com → Azure Active Directory → App registrations → New registration.
Name it albert Toolkit Data Entry. Under Redirect URIs choose Single-page application and enter the URL where you host this file.


Step 2 — Add API permissions
Under API permissions, add delegated Microsoft Graph permissions:
Files.ReadWrite and Sites.ReadWrite.All.
Click Grant admin consent.


Step 3 — Configure this app
Copy the Tenant ID and Client ID from the app registration overview into the Azure AD tab above.


Step 4 — Add productions
In the Productions tab, add each production and paste the SharePoint URL of its albert Toolkit .xlsx file. (Right-click the file in SharePoint → Copy link, or use the browser address bar when the file is open.)


Demo mode
Without Azure config, the app runs in demo mode — all forms work and show a confirmation, but nothing is written to SharePoint.

Switch Production