Flows/Query and export

Flows

Query and export

Main story · The customer asks the example queries in plain language, follows a citation into the chain and back, and exports CSV.

Who
The presenter, acting as the customer, Velmora Battery Works
Starts at
Queries and export, no answer yet
Ends with
Four example queries answered; the labelled data previewed and saved as CSV
Step 1 of 10 This screen is not drawn yet

  1. 1 Ask

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries

    No answers yet

    Ask one of the five example queries in the box above. The answers of this sitting stay here, newest first.

    Presses the example Show Category 1 emissions by supplier. 1: it fills the box. Then presses Ask 2. A query is not confirmed.

  2. 2 Answering

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries
    Answering…The AI is reading the labelled data. The answer lands here, at the top of the list.

    Sees Answering… under the box, in the place the answer will take. The box and the examples take no other query meanwhile. Nothing to press.

  3. 3 Category 1 by contributing party

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries
    Answers of this sitting, newest first
    Show Category 1 emissions by supplier.Oct 25 15:03

    Category 1 by contributing party: each figure is the party’s own Scope 1–2, as it reported it. Brisemont is Velmora’s direct supplier; its 35.7 passed on includes Quillara’s 23.3.

    Sees Quillara 23.3 and Brisemont 12.4 tCO2e, each the party’s own figure citing its STS transaction with its review status, and the total 35.7. Brisemont is Velmora’s direct supplier; its 35.7 passed on includes Quillara’s 23.3. Opens the cited STS-EX-0001 1.

  4. 4 In the chain

    Presenter’s control

    Chain view

    CNT-BR-0417 · Battery-grade lithium carbonate, 15.6 t · mine → refiner → carrier → customer

    1. Q
      Quillara LithiumMine · extraction

      24 t lithium concentrate

      Accepted

      STS-EX-0001

    2. B
      Brisemont RefiningRefiner · processing

      24 t concentrate → 15.6 t lithium carbonate

      Accepted

      STS-PR-0001

    3. F
      Ferrovane FreightCarrier · transportation

      CNT-BR-0417 · 15.6 t, Mejillones → Austin

      Accepted

      STS-SH-0001

    4. V
      Velmora Battery WorksCustomer · end of the chain

      CNT-BR-0417 delivered

      No transaction of its own

    Roll-upComplete · the customer’s Scope 3 is Ferrovane’s reported total, 38.2 tCO2e
    PartyOwn emissionsEmbedded receivedReported totalReview
    QQuillara23.3 tCO2enot applicable23.3 tCO2eAccepted
    BBrisemont12.4 tCO2e23.3 tCO2e35.7 tCO2eAccepted
    FFerrovane2.5 tCO2e35.7 tCO2e38.2 tCO2eAccepted

    The Chain view opens with Quillara’s transaction in the drawer, at its place in the chain. The answers stay where they were. Presses Back to answers 1.

  5. 5 Ask about lithium extraction

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries
    Answers of this sitting, newest first
    Show Category 1 emissions by supplier.Oct 25 15:03

    Category 1 by contributing party: each figure is the party’s own Scope 1–2, as it reported it. Brisemont is Velmora’s direct supplier; its 35.7 passed on includes Quillara’s 23.3.

    The Category 1 answer is still on screen. Presses What Scope 3 emissions are attributable to lithium extraction? 1 and Ask 2.

  6. 6 Lithium extraction

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries
    Answers of this sitting, newest first
    What Scope 3 emissions are attributable to lithium extraction?Oct 25 15:04

    Lithium extraction is Quillara Lithium’s step: its own Scope 1–2, measured, trucking to the refinery included. It reaches Velmora inside Brisemont’s 35.7, in Category 1.

    Show Category 1 emissions by supplier.Oct 25 15:03

    Category 1 by contributing party: each figure is the party’s own Scope 1–2, as it reported it. Brisemont is Velmora’s direct supplier; its 35.7 passed on includes Quillara’s 23.3.

    The answer lands on top, Oct 25 15:04: 23.3 tCO2e, Quillara’s own figure, citing STS-EX-0001 — its trucking to the refinery included. Then presses Which STS transactions support Category 4 transportation emissions? 1 and Ask 2.

  7. 7 Category 4 transportation

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries
    Answers of this sitting, newest first
    Which STS transactions support Category 4 transportation emissions?Oct 25 15:05

    The mine’s trucking to the refinery is inside STS-EX-0001 and counts in Category 1; the 35.7 the carrier received is the refiner’s figure relayed, counted in Category 1.

    What Scope 3 emissions are attributable to lithium extraction?Oct 25 15:04

    Lithium extraction is Quillara Lithium’s step: its own Scope 1–2, measured, trucking to the refinery included. It reaches Velmora inside Brisemont’s 35.7, in Category 1.

    Show Category 1 emissions by supplier.Oct 25 15:03

    Category 1 by contributing party: each figure is the party’s own Scope 1–2, as it reported it. Brisemont is Velmora’s direct supplier; its 35.7 passed on includes Quillara’s 23.3.

    The answer, Oct 25 15:05: STS-SH-0001 only — Ferrovane, refiner → customer, 2.5 tCO2e, parent STS-PR-0001. One line says why nothing else is in it: the mine’s trucking to the refinery is inside STS-EX-0001 and counts in Category 1; the 35.7 the carrier received is the refiner’s figure relayed, counted in Category 1. Then presses Which battery products contribute most to Category 11 emissions? 1 and Ask 2.

  8. 8 Not in this chain yet, and why

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries
    Answers of this sitting, newest first
    Which battery products contribute most to Category 11 emissions?Oct 25 15:06
    not in this chain yet — downstream of the customer

    Category 11 is the use of the sold batteries, after Velmora Battery Works: it would be reported by the buyers and users of the batteries, labelled the same STS way, once the chain extends past the customer. This chain ends at Velmora, so there is no figure yet, and no product is ranked.

    No transaction is cited: there is no number to cite.
    Which STS transactions support Category 4 transportation emissions?Oct 25 15:05

    The mine’s trucking to the refinery is inside STS-EX-0001 and counts in Category 1; the 35.7 the carrier received is the refiner’s figure relayed, counted in Category 1.

    What Scope 3 emissions are attributable to lithium extraction?Oct 25 15:04

    Lithium extraction is Quillara Lithium’s step: its own Scope 1–2, measured, trucking to the refinery included. It reaches Velmora inside Brisemont’s 35.7, in Category 1.

    Show Category 1 emissions by supplier.Oct 25 15:03

    Category 1 by contributing party: each figure is the party’s own Scope 1–2, as it reported it. Brisemont is Velmora’s direct supplier; its 35.7 passed on includes Quillara’s 23.3.

    The new answer lands on top, Oct 25 15:06: not in this chain yet — downstream of the customer, and where the figure would come from — the buyers of the batteries — with no citation because there is no number to cite. In Export keeps CSV 1; Excel and JSON are built if time allows. Presses Download CSV 2.

  9. 9 Preview of the file

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries
    Answers of this sitting, newest first
    Which battery products contribute most to Category 11 emissions?Oct 25 15:06
    not in this chain yet — downstream of the customer

    Category 11 is the use of the sold batteries, after Velmora Battery Works: it would be reported by the buyers and users of the batteries, labelled the same STS way, once the chain extends past the customer. This chain ends at Velmora, so there is no figure yet, and no product is ranked.

    No transaction is cited: there is no number to cite.
    Which STS transactions support Category 4 transportation emissions?Oct 25 15:05

    The mine’s trucking to the refinery is inside STS-EX-0001 and counts in Category 1; the 35.7 the carrier received is the refiner’s figure relayed, counted in Category 1.

    Before the file is saved, its first rows: one row per STS transaction, the columns named for what they hold. own_emissions_tco2e with own_category adds up to the customer’s Scope 3 (23.3 + 12.4 + 2.5 = 38.2); the cumulative columns already include upstream and are never summed. Presses Save CSV 1. A download is not confirmed.

  10. 10 CSV saved

    Presenter’s control

    Queries and export

    Ask about the labelled data of CNT-BR-0417. Every number cites the STS transactions behind it.

    The five example queries
    Answers of this sitting, newest first
    Which battery products contribute most to Category 11 emissions?Oct 25 15:06
    not in this chain yet — downstream of the customer

    Category 11 is the use of the sold batteries, after Velmora Battery Works: it would be reported by the buyers and users of the batteries, labelled the same STS way, once the chain extends past the customer. This chain ends at Velmora, so there is no figure yet, and no product is ranked.

    No transaction is cited: there is no number to cite.
    Which STS transactions support Category 4 transportation emissions?Oct 25 15:05

    The mine’s trucking to the refinery is inside STS-EX-0001 and counts in Category 1; the 35.7 the carrier received is the refiner’s figure relayed, counted in Category 1.

    What Scope 3 emissions are attributable to lithium extraction?Oct 25 15:04

    Lithium extraction is Quillara Lithium’s step: its own Scope 1–2, measured, trucking to the refinery included. It reaches Velmora inside Brisemont’s 35.7, in Category 1.

    Show Category 1 emissions by supplier.Oct 25 15:03

    Category 1 by contributing party: each figure is the party’s own Scope 1–2, as it reported it. Brisemont is Velmora’s direct supplier; its 35.7 passed on includes Quillara’s 23.3.

    Sees the file saved: the labelled data, one row per STS transaction, never the supplier’s files. End of the flow.