LCPL Feedstock Dashboard

This guide is for Administrators of the LCPL Feedstock Dashboard — the team members responsible for keeping daily, weekly, stock, shipment, and forecast data accurate and up to date. It covers everything needed to log in, navigate the Data Entry Console, add and maintain records in each of the six data-entry forms, and keep the system secure.

Administrators have full read/write access to the underlying dataset. Regular dashboard viewers cannot see or use any of the functions described in this guide. Please handle admin credentials responsibly — see Section 9 (Security Recommendations).

On the main dashboard, click Admin Login in the top-right of the header.
Enter your Username and Password in the sign-in dialog.
Click Sign In (or press Enter).
If the credentials are correct, the dashboard header will display an ADMIN badge, and the Data Entry Console will open automatically.
If the credentials are incorrect, an "Invalid username or password" message appears — re-enter your details and try again.

The factory-default credentials shipped with this system are username admin / password admin123. These MUST be changed by your IT/development team before the dashboard is used in a live environment — see Section 9.

Press Esc at any time to close the login dialog without signing in.

Once signed in, you land in the Data Entry Console — a dedicated full-page workspace separate from the public dashboard.

Filter forms search box	Type keywords to quickly filter/find a form in the sidebar list.
User Guide (sidebar)	Opens an in-app quick-reference guide summarising every form — useful as a refresher while you work.
Data Entry navigation list	Six forms: Daily Report, Weekly Average, PX/AA/PTA Stocks, PX Ship Arrivals, AA Ship Arrivals, PCI Forecast.

From the public dashboard, admins can return to this console at any time using the "Back to Admin Panel" button that appears in the header once logged in.

4.1 Daily Report Entry Core form

Captures the daily price snapshot that powers the Daily Report KPI cards on the dashboard.

Date	Required
Crude Oil (WTI) $/bbl	Optional
PX (NE Asia) $/ton	Required
PTA (CFR China) $/ton	Required
Acetic Acid $/ton	Optional

The PTA Spread is calculated automatically from PTA and PX — you do not need to enter it manually.

Select the Date using the date picker.
Enter the Crude Oil price (optional).
Enter the PX price (required).
Enter the PTA price (required).
Enter the Acetic Acid price (optional).
Click Save Daily to store the entry.

To correct a mistake, find the row in the table below the form, click Edit, adjust the values, and click Update. To remove an entry entirely, click Delete.

4.2 Weekly Average Entry Core form

Records the weekly average price used for monthly average calculations and the Weekly Report on the dashboard.

Week Date	Required
Avg Crude Oil ($/bbl)	Required
Avg PX ($/ton)	Required
Avg PTA ($/ton)	Required
Avg Acetic Acid ($/ton)	Required

Select the Week Date (typically the Monday of the week).
Enter the average Crude Oil price.
Enter the average PX price.
Enter the average PTA price.
Enter the average Acetic Acid price.
Click Add Weekly to save.

Existing weekly rows can be edited or deleted the same way as Daily Report entries, using the Edit and Delete buttons in the table.

4.3 PX, AA & PTA Stocks Entry Inventory

Tracks tank/warehouse inventory levels that appear in the Stock Report section of the dashboard.

Date	Required
PX Stock (MT)	Optional
AA Stock (MT)	Optional
PTA Stock (MT)	Optional

Date is required, and while each stock value is individually optional, at least one figure should be entered per record for it to be meaningful.

Select the Date for the stock record.
Enter the PX Stock in Metric Tons.
Enter the AA Stock in Metric Tons.
Enter the PTA Stock in Metric Tons.
Click Add Stock to save.

4.4 PX Ship Arrivals Entry Logistics

Manages incoming Paraxylene shipments — contract type, source and quantity — shown in the PX Ship Arrivals table on the dashboard.

Arrival Date	Required
Contract Type	TERM or SPOT
Source	e.g. Kuwait, Oman, Taiwan
Quantity (MT)	Required

Select the Arrival Date.
Choose the Contract Type (TERM or SPOT).
Enter the Source (e.g. Kuwait, Oman, Taiwan).
Enter the Quantity in Metric Tons.
Click Add Shipment to save.

4.5 AA Ship Arrivals Entry Chemical

Manages Acetic Acid shipment arrivals and pricing data together, feeding the Acetic Acid Ship Arrivals table and the AA price series.

Ship Date	Required
Type (Spot / Term)	Required
Origin	Required
Quantity (MTs)	Required
— Price sub-form —
Date	Required
Price ($/ton)	Required

This form has two independent sub-sections — Shipments and Prices — and the Monthly Average price is calculated automatically from the price history you enter.

Shipments: fill in Ship Date, Type (Spot/Term), Origin, and Quantity, then click Add Shipment.
Prices: fill in Date and Price, then click Add Price.
Shipment status (IN TRANSIT / Arrived) can be updated directly from the record table — see Section 5.3.

4.6 PCI Forecast Entry Forecast

Updates the Wood Mackenzie PCI Forecast values that drive the forecast chart at the bottom of the Monthly Report.

Month	Required
Forecast PX ($/MT)	Required
Forecast PTA ($/MT)	Required

Select the Month from the dropdown.
Enter the Forecast PX price.
Enter the Forecast PTA price.
Click Add Forecast to save.

5.1 Editing a Record

Every data table beneath a form includes an Edit button on each row. Click it to load that record's values back into the form fields above, make your corrections, and click the form's Update button to save the change.

5.2 Deleting a Record

Click the Delete button on any row to permanently remove that record. There is no undo — double-check the row before confirming.

5.3 Updating Shipment Status

Both PX Ship Arrivals and AA Ship Arrivals tables display a status badge for each shipment:

IN TRANSIT	Amber. Default status for a newly added shipment — it has not yet arrived.
Arrived	Green. Marked once the cargo has been received and confirmed.

Use the action button next to a shipment's status badge to toggle it between IN TRANSIT and Arrived as the shipment progresses. This updates the badge shown on the public dashboard's Ship Arrival tables in real time.

All data entered in the console is sent to the server-side api.php endpoint, which persists it centrally so every user viewing the dashboard sees the same, up-to-date figures.

Every Save / Add / Update / Delete action triggers an automatic save to the backend — there is no separate "publish" step. The dashboard also keeps a local "Last Updated On" timestamp (stored in the browser's local storage) so users can see at a glance how fresh the data is. When you click Back to Dashboard, the console automatically refreshes the Daily Report, Weekly Report and Monthly Report views so your latest changes are immediately visible.

Because saving happens automatically and immediately, always double-check values before clicking Save/Add/Update — especially Delete actions, which cannot be undone.

Administrators can generate the same PDF export available to regular viewers by returning to the dashboard (Back to Dashboard) and clicking Export PDF in the header. This is useful for producing a dated record of the dashboard immediately after finishing a batch of data entry.

Enter	Submit the active form / confirm login
Esc	Close the current modal or cancel an action
Ctrl + S	Save the currently focused entry

The dashboard currently ships with a single, hard-coded administrator account (admin / admin123) defined directly in the page's client-side code. Anyone who can view the page source can see these credentials. Treat this as a placeholder only.

Change the default username and password immediately in a production/live deployment, and avoid reusing them across systems.
Ask your IT or development team to move authentication to the server side (api.php or a proper login service) rather than checking credentials in the browser.
Limit who is given the Admin Login credentials — every admin has full edit and delete rights across all six forms.
Log out (or close the browser tab) when you step away from a shared or public computer that is signed in as Admin.
Periodically review the Daily/Weekly/Stock/Shipment tables for unexpected changes, especially if credentials may have been shared more broadly than intended.

Enter Daily Report figures at the same time each business day to keep day-on-day % change figures meaningful.
Use the Monday of each week consistently as the Week Date in Weekly Average entries so weekly tables line up correctly.
Record stock levels on the same cadence as your physical inventory checks to avoid gaps in the Stock Report.
Update shipment statuses (IN TRANSIT → Arrived) promptly so the Ship Arrival tables reflect real-world logistics accurately.
Review the PCI Forecast monthly, or whenever Wood Mackenzie issues a new outlook, to keep the forecast chart current.
Before exporting a PDF for distribution, verify the date/month filters and expand any tables that recipients need to see.

"Invalid username or password" on login
Double-check for extra spaces or Caps Lock. If you still cannot sign in, confirm the current credentials with your system administrator, as they may have been changed from the default.

A saved entry doesn't appear on the dashboard
Return to the dashboard using Back to Dashboard rather than a browser refresh, so the app can pull the latest saved data. If the issue persists, check your network connection, since saves are sent to the api.php backend.

PDF export is blank or missing charts
Make sure the relevant sections are expanded before exporting, and allow a few seconds for the "Generating PDF Report..." process to complete before closing the tab.

Wrong data displayed after selecting a date
Confirm you're using the Daily Report date picker (for daily figures) versus the Monthly Report's Year/Month filters (for monthly figures) — they control different sections of the dashboard independently.

Daily Report	Date, Crude Oil ($/bbl), PX ($/ton), PTA ($/ton)*, Acetic Acid ($/ton)
Weekly Average	Week Date, Avg Crude Oil, Avg PX, Avg PTA, Avg Acetic Acid*
PX/AA/PTA Stocks	Date*, PX Stock (MT), AA Stock (MT), PTA Stock (MT)
PX Ship Arrivals	Arrival Date, Contract Type, Source, Qty (MT)
AA Ship Arrivals	Ship Date, Type, Origin, Quantity (MTs) — plus Price entries: Date, Price ($/ton)
PCI Forecast	Month, Forecast PX ($/MT), Forecast PTA ($/MT)*

* Required field