tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 341465 | 329748 |  | 15605 | 36925 | 36557 | 171258 | 176277 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 333969 | 323101 |  | 10827 | 32325 | 36557 | 128578 | 132874 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 329682 | 320457 |  | 15442 | 35751 | 36557 | 144515 | 142776 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 342762 | 331995 |  | 15281 | 37608 | 36557 | 142892 | 142891 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 356704 | 341499 |  | 14075 | 42720 | 36557 | 154730 | 152625 |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 | 347396 | 339399 |  | 8714 | 42100 | 36557 | 137236 | 137167 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 311632 | 306676 |  | 5665 | 40058 | 36557 | 142439 | 141867 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 324740 | 325588 |  | 5802 | 36491 | 36557 | 142898 | 143630 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 277846 | 274739 |  | 2164 | 33031 | 36557 | 125215 | 121176 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 | 293086 | 284913 |  | 4532 | 27174 | 36557 | 127095 | 131638 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 290783 | 285199 |  | 4298 | 39107 | 36557 | 131827 | 131638 |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 |  |  |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 |  |  |  |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 |  |  |  |  |  |  |  |  |  |  |  | 2001-12-04 00:00:00
16
17
18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.98
20 |  |  |  |  |  |  |  |  |  |  |  |  | 1378106 | 1316146
21 |  |  |  |  |  |  |  |  |  |  |  |  | 9216070 | 9272400
22 |  |  |  |  |  |  |  |  |  |  |  |  | 3546065 | 3512740
23 |  |  |  |  |  |  |  |  |  |  |  |  | 1623705 | 1620245
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-03-11 00:00:00
CBS Dollars
 |  |  | 84461
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Derbyshire

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 874094d1720653787-needs-if-formula-for-certain-condition-to-meet-team-bonus-farooq48-
Sheet: MEASURE METRICS

 | UID | Available Measures | CONDITION | %PGI | RGI | GSI | OP | TOTAL
 |  |  | All present | 0.3 | 0.2 | 0.2 | 0.3
 |  |  | No RGI | 0.4 |  | 0.3 | 0.3
 |  |  | No GSI | 0.4 | 0.3 |  | 0.3
 |  |  | No RGI & GSI | 0.7 |  |  | 0.3
 |  |  | 0.2 | 2
 |  |  | 0.3 | 3
 |  |  | 0.4 | 4
 |  |  | 0.5 | 5
 |  |  | 0.6 | 6
 |  |  | 0.7 | 7
 |  |  | 0.8 | 8
Spreadsheet: 731428d1620335479-comparing-time-and-date-values-excel-forum
Sheet: Sheet1

22:31:00 | 2018-09-07 00:00:00 | 21:26:00 | 2018-09-07 00:00:00 | No
21:29:00 | 2018-09-04 00:00:00 | 22:35:00 | 2018-09-04 00:00:00 | No
23:59:00 | 2018-08-25 00:00:00 | 01:25:00 | 2018-08-26 00:00:00 | Yes
21:53:00 | 2018-08-25 00:00:00 | 18:58:00 | 2018-08-25 00:00:00 | Yes
19:13:00 | 2018-08-24 00:00:00 | 20:05:00 | 2018-08-24 00:00:00 | No
Spreadsheet: 755037d1636643535-lookup-multiple-columns-to-return-value-example-list
Sheet: Sheet1

Acct # | [NAME] # | Dep - example of what I want it to say | Amt
TS067908 | 1 | GHI | 0
TS067566 | 1 | CUS | 0
GW088036 | 1 | GHI | 0
GW088244 | 1 | SP | 0
MW166153 | 1 | SP | -645.93
MW179521 | 1 | GHI | 0
MW179529 | 1 | SP | 0
MW180044 | 1 | CUS | 0
MW177508 | 1 | SP | 0
CC167234 | 1 | GHI | -1301.1
CC169916 | 1 | SP | -70.56
CC172877 | 1 | SP | 458.81
CD325354 | 1 | GHI | 0
CD317969 | 1 | SP | -420
CD325808 | 1 | SP | 0
CD321383 | 1 | SP | -460.64
CD325896 | 1 | CUS | 0
CD325537 | 1 | SP | 0
BS302805 | 1 | GHI | -400
OL553783 | 1 | CUS | 0
Spreadsheet: 2f8b12d8-d621-455b-aedb-8e24989d8159
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | [NAME] | Einlaufzeit | Schlusszeit
1 | Deschwanden | Reto
2 | Thekkemuriyil | Ria
3 | Abel | Viola
4 | Schilliger | [NAME]
5 | Salzone | Selina
6 | Karadere | Merijem
7 | Schläfli | Florian
8 | Abel | Fabia
9 | Nobbe | Francisco
10 | Lötscher | Viviane
11 | [NAME] | [NAME]
12 | Abel | [NAME]
13 | Lötscher | Severin
14 | Hordos | Noël
15 | Burch | Damian
16 | Ammann | [NAME]
17 | Schaumlechner | Florian
18 | Zimmermann | Sophie
19 | Spöring | Céline
20 | Studhalter | [NAME]
21 | [NAME] | Armando
22 | [NAME] | Laurin
23 | Meyer | [NAME]
24 | [NAME] | Giacumin
25 | Commerell | Felix
26 | Boos | Corsin
27 | Ammann | [NAME]
28 | Abel | [NAME]
29 | [NAME] | [NAME]
30 | Spöring | Corinne
31 | Furrer | Mirjam
32 | Ummel | Dominik
33 | Spöring | [NAME]
34 | Furrer | Remo
35 | Burch | Cyrill
36 | Fähndrich | Cyril
37 | Boos | [NAME]
38 | Ummel | [NAME]
39 | Bacchetta | Elio
40 | Fähndrich | Nadine
41 | Egli | Remo
42 | Piazza | Camillo
43 | Näpflin | Severin
44 | Bacchetta | Avelino
45 | [NAME] | Esther
46 | [NAME] | Leo |  |  |  |  |  |  |  |  |  | .
47 | Studhalter | Beat
Spreadsheet: daren_farmer__6653__CES - April
Sheet: CSGT

Purchase
 | From Spinnaker
 | At Brazos 368 (B368)
 | For IF-.08 for base vols & GDA-.08 for swing vols
 |  | Plus $.18 Transport
Sale
 | To Dow
 | At Cowtrap Facility (864101)
 |  | Operated By Coastal States Gas
 |  | [NAME] States Gas [PHONE]
 | For IF-.07 for base vols & GDA-.07 for swing vols
Term
 | Will be extended per [NAME]
Other
 | CSGT does not require nominations
 | Whatever is produced is allocated to Dow
 | Jan vols are approximately 1233 [NAME]
Deal Numbers
 |  | Jan & Feb | Mar | Apr
 | Swing | P - 144271 | 144271 | 144271
 |  | S - 144273 | 202422 | 227880
 | Tsp | T - 148795 | 148795 | 148795
 | Base | P - 144264 | 144264 | 144264
 |  | S - 144265 | 210770 | 227895
Spreadsheet: 120430d1315290207-how-to-calculate-a-list-exampl
Sheet: Sheet1

host2 | error03 |  | error03 | host2 |  |  |  |  |  |  |  |  |  | error03
[NAME] | error10 |  | error10 | [NAME] | host4 |  |  |  |  |  |  |  |  | error10
host4 | error10 |  | error11 | host2 | [NAME] |  |  |  |  |  |  |  |  | error11
host2 | error11 |  | error12 | [NAME] | [NAME] |  |  |  |  |  |  |  |  | error12
[NAME] | error11 |  | error03 | host2 |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | error12 |  | error03 | host2 |  |  |  |  |  |  |  |  |  | error15
[NAME] | error12 |  | error16 | host6 |  |  |  |  |  |  |  |  |  | error16
host4 | [NAME] |  | error17 | [NAME] |  |  |  |  |  |  |  |  |  | error17
[NAME] | error15 |  | error22 | [NAME] | host4 |  |  |  |  |  |  |  |  | error22
[NAME] | error15 |  | error23 | [NAME] | host4 |  |  |  |  |  |  |  |  | error23
host6 | error16 |  | error32 | host6 |  |  |  |  |  |  |  |  |  | error32
[NAME] | error17 |  | error33 | host4 |  |  |  |  |  |  |  |  |  | error33
[NAME] | error22 |  | error34 | host4 |  |  |  |  |  |  |  |  |  | error34
host4 | error22
[NAME] | error23 |  | Note: array formual is used and should be confirmed [NAME] ctrl+shift+enter
host4 | error23
host6 | error32
host4 | error33
host4 | error34
Spreadsheet: 269987d1381340425-count-if-yes-1-copy-value-of-a-diff-cell-from-another-worksheet-count-if-1-yes-multiple-return-formula-
Sheet: daily sheet

orginazation | interested | signed up
costco | yes | no
wal mart | yes | yes
good year | no | no
tom's | yes | yes
store 1 | yes | yes
store 2 | no | no
store 3 | no | no
store 4 | no | no
store 5 | no | no
store 6 | no | no
store 7 | yes | no
store 8 | yes | yes
store 9 | yes | yes
store 10 | yes | yes
store 11 | yes | no
store 12 | yes | no
Spreadsheet: 705253d1605963629-formula-that-searches-string-in-multiple-fields-and-writes-adjacent-cell-value-product_reviews
Sheet: Sheet2

Customer ID | Product #1 | Product #2 | Product #3 | Product #4 | Review1 | Review1_Comments | Review2 | Review2_Comments | Review3 | Review3_Comments | Review4 | Review4_Comments
1 | yaz |  |  |  | Product #3 | abc | Product #8 | mtj | Product #1 | yaz | Product #9 | mno
2 | bct |  |  |  | Product #9 | def | Product #5 | pzs | Product #7 | [NAME] | Product #1 | bct
3 | ghi |  |  |  | Product #1 | ghi | Product #6 | wap | Product #3 | uts | Product #7 | sdw
4 |  | [NAME] |  |  | Product #7 | jkl | Product #2 | [NAME] | Product #4 | rqp | Product #6 | ttp
5 |  | mno |  |  | Product #2 | mno | Product #3 |  | Product #5 | onm | Product #4 | anm
6 |  |  |  |  | Product #8 | pqr | Product #9 | wmd | Product #6 | lkj | Product #5 | ery
7 |  | ihg |  |  | Product #4 | [NAME] | Product #7 | [NAME] | Product #2 | ihg | Product #3
8 |  | cig |  |  | Product #6 | vwx | Product #4 | ots | Product #8 | efd | Product #2 | cig
9 | acb |  |  |  | Product #5 | yza | Product #1 | acb | Product #9 | bca | Product #8 | qow
Spreadsheet: 748417d1632138074-conditional-formatting-formula-highlight-cells-with-different-values-within-a-criteria-format-transaction-method-column
Sheet: Trans Method

 | Sort by Client Number |  |  |  | Sort by Trans Method |  |  |  | Sort by Other
 | Client Number |  | Trans Method |  | Client Number |  | Trans Method |  | Client Number |  | Trans Method
 | 116 |  | AMEX |  | 116 |  | AMEX |  | 34806 |  | AMEX
 | 116 |  | AMEX |  | 116 |  | AMEX |  | 34806 |  | AMEX
 | 116 |  | AMEX |  | 116 |  | AMEX |  | 355289 |  | AMEX
 | 203 |  | M/CARD |  | 890 |  | AMEX |  | 12552 |  | M/CARD
 | 748 |  | M/CARD |  | 1560 |  | AMEX |  | 23588 |  | M/CARD
 | 890 |  | AMEX |  | 3337 |  | AMEX |  | 28410 |  | M/CARD
 | 1560 |  | DEBIT |  | 3337 |  | AMEX |  | 34806 |  | M/CARD
 | 1560 |  | AMEX |  | 34806 |  | AMEX |  | 297487 |  | M/CARD
 | 2189 |  | DEBIT |  | 34806 |  | AMEX |  | 355289 |  | AMEX
 | 3337 |  | DEBIT |  | 355289 |  | AMEX |  | 355289 |  | AMEX
 | 3337 |  | DEBIT |  | 355289 |  | AMEX |  | 1560 |  | DEBIT
 | 3337 |  | AMEX |  | 355289 |  | AMEX |  | 2189 |  | DEBIT
 | 3337 |  | AMEX |  | 1560 |  | DEBIT |  | 36890 |  | DEBIT
 | 3337 |  | M/CARD |  | 2189 |  | DEBIT |  | 43400 |  | DEBIT
 | 3942 |  | DEBIT |  | 3337 |  | DEBIT |  | 116 |  | AMEX
 | 3942 |  | DEBIT |  | 3337 |  | DEBIT |  | 116 |  | AMEX
 | 8045 |  | M/CARD |  | 3942 |  | DEBIT |  | 116 |  | AMEX
 | 12552 |  | M/CARD |  | 3942 |  | DEBIT |  | 890 |  | AMEX
 | 23588 |  | M/CARD |  | 36890 |  | DEBIT |  | 1560 |  | AMEX
 | 28410 |  | M/CARD |  | 43400 |  | DEBIT |  | 3337 |  | AMEX
 | 34806 |  | M/CARD |  | 297487 |  | DEBIT |  | 3337 |  | AMEX
 | 34806 |  | AMEX |  | 203 |  | M/CARD |  | 297487 |  | DEBIT
 | 34806 |  | AMEX |  | 748 |  | M/CARD |  | 3337 |  | DEBIT
 | 36890 |  | DEBIT |  | 3337 |  | M/CARD |  | 3337 |  | DEBIT
 | 43400 |  | DEBIT |  | 8045 |  | M/CARD |  | 3942 |  | DEBIT
 | 297487 |  | DEBIT |  | 12552 |  | M/CARD |  | 3942 |  | DEBIT
 | 297487 |  | M/CARD |  | 23588 |  | M/CARD |  | 203 |  | M/CARD
 | 355289 |  | AMEX |  | 28410 |  | M/CARD |  | 748 |  | M/CARD
 | 355289 |  | AMEX |  | 34806 |  | M/CARD |  | 3337 |  | M/CARD
 | 355289 |  | AMEX |  | 297487 |  | M/CARD |  | 8045 |  | M/CARD
Spreadsheet: tracy_geaccone__40377__Corp Opex Detail
Sheet: Department

 |  | EREC RENEWABLE ENERGY CORP.
 |  | CONSOLIDATED
 |  | 2002 PLAN OPERATING COSTS
 |  | By Department
 |  | ($ thousands)
 |  | Department |  | Operating Costs
 |  | G&A
 |  | Accounting, IT, & Planning |  | 9270
 |  | Communications |  | 786
 |  | Corp Unallocated |  | 1306
 |  | Executive / Admin |  | 10242
 |  | Government & Regulatory |  | 1094
 |  | HR, Risk, & Safety |  | 5424
 |  | [NAME] |  | 364
 |  | Legal |  | 2692
 |  | Quality Management |  | 5937
 |  | Transportation |  | 814
 |  | Commercial
 |  | Origination
 |  | Structuring & Execution |  | 7101
 |  | Commercial Engineering |  | 770
 |  | Marketing & Communications |  | 3648
 |  | Production Management |  | 1543
 |  | Engineering
 |  | Engineering
 |  | [NAME] |  | 1031
 |  | Total Operating Costs
Spreadsheet: 867105d1713990671-clean-and-convert-text-then-average-avgtxt
Sheet: Sheet1

SP1 | SP2 | SP3 | SP4 |  | AVG
84.T | 69. | 65T | 70 |  | 72
73. | 80. | 54 | 66 |  | 68.25 |  |  | 68.25
72 | 70T | 54 | 60 |  | 64 |  |  | 64
 | 63 | 73. | 59T |  | 65 |  |  | 65
73.T | 70. | 47. | 72 |  | 65.5 |  |  | 65.5
83. | 70. |  |  |  | 76.5 |  |  | 76.5
Spreadsheet: 265308d1379177720-reduce-the-number-of-column-quality-mis
Sheet: Email

Name of the Evaluator | Name of the CSE | Call ID | Date of Email | Date of Evaluation | Call Length | Email Opening / Closing | Verification | Resolution |  |  | Reference |  |  |  | [NAME] |  |  |  | Email Opening / Closing |  | Total Scored | Total Possible | Quality Score | Overall Rating | Agent Satisfaction | Feedback | Fatal Error
 |  |  |  |  |  | Appropriate Opening using Standard Script | Verification | Resolution | Tagging / Classification | Proactive Service | Understanding the Issue | Interim Response Sent within Stipulated TAT | Follow Up / Escalation within the Stipulated TAT | Final Response Sent | Sentence Correction, Spelling and Grammar | Courtesy and Tone of Email | Empathy & Acknowledgement | Appropriate Format Used | Appropriate Closure using Standard Script | Appropriate Signature Used
Nishith | [NAME] | 1111 | 2013-09-15 00:00:00 | 2013-09-15 00:00:00 |  | YES - 3 | CORRECT AND [NAME] VERIFICATION - 15 | CORRECTLY AND COMPLETELY RESOLVED - 15 | CORRECTLY UPDATED - 10 | YES - 5 | MET EXPECTATIONS - 5 | YES - 5 | TIMELY FOLLOWUP / ESCALATION - 5 | YES - 10 | GOOD - 10 | GOOD - 3 | YES - 2 | YES - 5 | YES - 2 | YES - 5 | 100 | 100 | 1 | 8 | 8 | This is a test entry for email 1
Nishith | [NAME] | 2222 | 2013-09-15 00:00:00 | 2013-09-15 00:00:00 |  | YES - 3 | CORRECT AND [NAME] VERIFICATION - 15 | CORRECTLY AND COMPLETELY RESOLVED - 15 | CORRECTLY UPDATED - 10 | YES - 5 | MET EXPECTATIONS - 5 | YES - 5 | TIMELY FOLLOWUP / ESCALATION - 5 | YES - 10 | GOOD - 10 | GOOD - 3 | YES - 2 | YES - 5 | YES - 2 | YES - 5 | 100 | 100 | 1 | 10 - Extremely Satisfied | 8 | This is a test entry for email 2
Nishith | [NAME] | 3333 | 2013-09-15 00:00:00 | 2013-09-15 00:00:00 |  | YES - 3 | CORRECT AND [NAME] VERIFICATION - 15 | CORRECTLY AND COMPLETELY RESOLVED - 15 | INCORRECTLY UPDATED - 0 | YES - 5 | MET EXPECTATIONS - 5 | NA - NOT APPLICABLE | TIMELY FOLLOWUP / ESCALATION - 5 | YES - 10 | GOOD - 10 | GOOD - 3 | YES - 2 | YES - 5 | YES - 2 | YES - 5 | 65 | 95 | 0.6842105263157895 | 7 | 10 - Extremely Satisfied | This is a test entry for email 3
Spreadsheet: 39936d1238171691-how-to-make-multiple-name-show-up-only-once-in-pivot-table-sk-group
Sheet: Database

 | Name | Specialties | Group
 | Adam | banana | Fruit
 | Adam | orange | Fruit
 | Adam | icecream | Deserts
 | Adam | coffee | Beverage
 | Adam | hot dog | Fast food
 | [NAME] | cheese cake | Deserts
 | [NAME] | hot chocolate | Beverage
 | [NAME] | mango | Fruit
 | [NAME] | burger | Fast food
 | [NAME] | orange | Fruit
 | [NAME] | coke | Beverage
 | [NAME] | french fries | Fast food
 | [NAME] | banana | Fruit
 | [NAME] | coffee | Beverage
 | [NAME] | hot dog | Fast food
Spreadsheet: 134735d1325605478-histogramm-and-function-example-1
Sheet: Sheet1

CODE OF PLACE | NAME | TOTAL POPULATION | IF VILLAGE SHOW YES IF NOT SHOW NOT
8596 | ATHENS CITY | 5000000
845236 | [NAME] | 880000
781236 | PYLI VILLAGE | 145000
7895 | THESSALONIKI CITY | 3000000
5412 | PEIREAS CITY | 2000000
784132 | DESFINA VILLAGE | 20000
852136 | [NAME] | 59000
8521 | PATRA CITY | 900000
785214 | NARTA VILLAGE | 201000
963258 | KEFALOS VILLAGE | 90000
Spreadsheet: 792236d1660804154-date-function-with-transpose-forum-upload-hd-5-1-
Sheet: Checkin Temp

Name | Car Rego | Mobile Number | Day or Night Shift | Check in Date | Check out Date | Fatigue Room | Fatigue Room Date | Site Supervisor | Site Supervisor Mobile Number | Back to Back
Neville, [NAME]
 |  |  |  | 2022-08-17 00:00:00 | 2022-08-24 00:00:00 |  | 2022-09-21 00:00:00
 |  |  |  | 2022-08-30 00:00:00 | 2022-09-06 00:00:00
 |  |  |  | 2022-09-14 00:00:00 | 2022-09-21 00:00:00
 | Check in | Check out
 | 2022-08-01 00:00:00 | 2022-09-22 00:00:00
Spreadsheet: 600346d1543607470-adding-flight-times-in-a-rolling-time-window-both-forward-and-backward-looking-ef1254869-flying-time-100-in-672
Sheet: Sheet1

In lieu of having actual data …
04:00:00 |  | [NAME] of | 4 days, 4:00:00 | flying hours
22:00:00 |  | in last | 28 days, 0:00:00 | hours
Date/Time | Event | [NAME] | Earliest Departure | OK?
2019-01-05 18:00:00
 | Dep
 | Arr
Spreadsheet: 174568d1345116335-combining-2-workbooks-workbook-2
Sheet: name 5

name 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012/13
 | MINIMUM INFORMATION THAT HAS TO BE RECORDED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADDITIONAL INFORMATION THAT MAY BE RECORDED
 | A | Annual Leave |  |  |  |  | T | Training |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Compassionate |  |  |  |  | S1 | Sickness Paid |  |  |  |  | M1 | Maternity Leave Paid
 | B | Bank Holiday |  |  |  |  | O | Other Authorised Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME]
 | S | Sickness |  |  |  |  | U | Unauthorised Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Jury Service |  |  |  |  | S2 | Sickness Half Pay
 | M | Maternity Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Suspension |  |  |  |  |  |  |  |  |  |  | M2 | Maternity Leave Unpaid
Contracted Hours |  |  | 37.5 | A/L | 217.5 |  | B/H | 67.5 |  | Combined |  |  | 285
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | S | O | U | M | T | B | A | Annual Leave Outstanding
APRIL | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
MAY | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
[NAME] | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
JULY | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
AUG | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
SEPT | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
OCT | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
NOV | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
DEC | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
JAN | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
FEB | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
MAR | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285
ANNUAL LEAVE ENTITLEMENT |  |  |  |  |  |  | 285 |  | hrs |  |  |  |  |  | CRB checked:  02/07/08   Renewal date:  02/07/11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 24659d1215358248-displaying-in-another-sheet-production-by-dates-v3-1-
Sheet: result manualy

 | Date | Day | Month | Year
 |  | 1 | 7 | 2008
Batch | Machine | Flavour | Market | Units | Liters | ml | set | material | Closure
1 | ave | mango | local | 1 | 6000 | 200 | 24 | pet | 28
2 | ave | apple | export | 2 | 1000 | 500 | 24 | pet | 29
Spreadsheet: 745386d1629895732-sum-if-vlookup-matches-criteria-copy-of-raw-data-v2
Sheet: Data_Input (2)

 |  | Date | [NAME] | Vehicle Fleet Number | Driver | Volume | Volume from D-Bowser | Destination | Initial KM | Float | Final KM | Total KM/HRS | Float Variance | [NAME] in LTRS | Actual Volume Used | Expected Value | Average LITRE/KM-HR | Reg Number | Vehicle Type | [NAME] | Cost | Price per Liter | Destination | Cost/KM
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-01 | [NAME] | 160 |  | KASUMBALESA | 100000 | 9.5 |  |  |  |  |  | 165.78
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-02 | [NAME] | 110 |  | KAPIRI | 100000 | 8.8
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-03 | [NAME] | 285 |  | SOLWEZI | 100000 | 6.2
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-01 | [NAME] | 285 |  | SOLWEZI | 100300 | 8.2
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-02 | [NAME] | 160 |  | KASUMBALESA | 100300 | 7.5
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-03 | [NAME] | 160 |  | KASUMBALESA | 100300 | 5.8
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-01 | [NAME] | 110 |  | KAPIRI | 100400 | 6
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-02 | [NAME] | 285 |  | SOLWEZI | 100400 | 7.2
 |  | 2021-08-25 00:00:00 | STATION 1 | MT-03 | [NAME] | 160 |  | KASUMBALESA | 100400 | 5.8
 |  |  |  | LD 01 |  | 250 |  | PROCESS | 1000 | 0 |  |  |  |  |  | 180
 |  |  |  | LD 02 |  | 200 |  | PROCESS | 1000 | 0 |  |  |  |  |  | 300
 |  |  |  | LD 03 |  | 210 |  | PROCESS | 1000 | 0 |  |  |  |  |  | 250
 |  |  |  | LD 01 |  | 180 |  | PROCESS | 1010 | 0 |  |  |  |  |  | 230
 |  |  |  | LD 02 |  | 300 |  | PROCESS | 1010 | 0 |  |  |  |  |  | 240
 |  |  |  | LD 03 |  | 250 |  | PROCESS | 1010 | 0 |  |  |  |  |  | 250
 |  |  |  | LD 01 |  | 230 |  | PROCESS | 1020 | 0
 |  |  |  | LD 02 |  | 240 |  | PROCESS | 1020 | 0
 |  |  |  | LD 03 |  | 250 |  | PROCESS | 1020 | 0
 |  |  |  | ALZ-8497 |  | 40 |  | [NAME] | 150000 | 0 |  |  |  |  |  | 50
 |  |  |  | ABZ-6320 |  | 50 |  | [NAME] | 160000 | 0 |  |  |  |  |  | 60
 |  |  |  | ALT-559 |  | 60 |  | [NAME] | 170000 | 0 |  |  |  |  |  | 70
 |  |  |  | ALZ-8497 |  | 50 |  | [NAME] | 150500 | 0 |  |  |  |  |  | 45
 |  |  |  | ABZ-6320 |  | 60 |  | [NAME] | 160500 | 0 |  |  |  |  |  | 55
 |  |  |  | ALT-559 |  | 70 |  | [NAME] | 170500 | 0 |  |  |  |  |  | 65
 |  |  |  | ALZ-8497 |  | 45 |  | [NAME] | 151000 | 0
 |  |  |  | ABZ-6320 |  | 55 |  | [NAME] | 161000 | 0
 |  |  |  | ALT-559 |  | 65 |  | [NAME] | 171000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140