tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 89656d1289415703-sumif-not-working-the-way-i-want-2011-budget-wip-trimmed
Sheet: PL

Store Entity |  | 65 |  |  | JAN | YEAR END
 |  | TOTAL REVENUE
 |  | [NAME]
 |  | ADD
 |  | LESS
 |  | COGS BEFORE INV ADJUSTMENTS
 |  | INV ADJUSTMENTS
 |  | FINAL COGS
 |  | GROSS PROFIT
 |  | TOTAL SALARIES & WAGES
 |  | TOTAL EXPENSES
 |  | TOTAL OPERATING INCOME
 |  | TOTAL OTHER INCOME/EXPENSES
 |  | INCOME FROM OPERATIONS
 |  | NET INCOME/LOSS
Spreadsheet: phillip_m_love__30658__9910_OA
Sheet: STG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ALL
REGION:  STORAGE
 |  |  | Total |  | Reclasses |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  |  |  |  |  |  |  | 0
3 |  | Cost of Inventory |  |  |  |  |  |  |  |  |  |  |  | -7876343
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 | -92370 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate |  |  |  |  |  |  |  | 123262
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  | -964594 |  | 0 |  | 0 |  | 8833187 |  |  |  | -2626533
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  |  |  | -376583
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 0
 |  | TOTAL
Spreadsheet: thomas_martin__39846__TXEOLRollout
Sheet: Sheet1

 |  |  |  | Texas EOL Products and Rollout Schedule
 | Phase 1 |  |  |  |  | Bullets
 |  |  |  | Prompt | Prompt | Prompt | Prompt | Prompt | Prompt
 | Basis |  |  | Month | Season | Season | Season + 1 | Season + 2 | Season + 3
 | Houston Ship Channel |  |  | Yes | Yes | Yes | Yes | Yes | Yes
 | Waha |  |  | Yes | Yes | Yes | Yes | Yes | Yes
 | Permian |  |  | Yes | Yes | Yes | Yes | Yes | Yes
 | Gas Daily
 | Houston Ship Channel |  |  | Yes | Yes | Yes | Yes | Yes
 | Waha |  |  | Yes | Yes | Yes | Yes | Yes
 | Phase 2
 |  |  |  | Next | Prompt | Prompt | Prompt
 | Physical |  |  | Day | Month Idx | Season Idx | Season + 1 Idx
 | Exxon Katy |  |  | Yes | Yes | Yes | Yes
 | Carthage |  |  | Yes | Yes | Yes | Yes
 | Waha |  |  | Yes | Yes | Yes | Yes
 |  |  |  | Bullets
 |  |  |  | Prompt
 | Basis |  |  | Season + 1
 | Houston Ship Channel |  |  | Yes
 | Waha |  |  | Yes
 | Permian |  |  | Yes
Spreadsheet: 813992d1674094327-selecting-the-nearest-static-location-weather-station-for-a-list-of-gps-tracker-points-gps_weather_sample_data
Sheet: Estepona Weather

Station name | Latitude | Longitude | dt_iso | Date_Time | T_Min (C) | [NAME] (C) | Pressure (hPa) | Humidity (%) | Wind_Speed (m/s) | Wind_Deg (˚) | [NAME]) | Clouds (%)
Estepona | 36.427277 | -5.150437 | 2020-06-05 06:00:00 +0000 UTC |  | 17.55 | 20 | 1014 | 82 | 4.6 | 230 |  | 40
Estepona | 36.427277 | -5.150437 | 2020-06-05 07:00:00 +0000 UTC |  | 18.05 | 20 | 1014 | 77 | 5.1 | 240 |  | 20
Estepona | 36.427277 | -5.150437 | 2020-06-05 08:00:00 +0000 UTC |  | 19.19 | 21 | 1014 | 73 | 5.7 | 240 |  | 20
Estepona | 36.427277 | -5.150437 | 2020-06-05 09:00:00 +0000 UTC |  | 19.78 | 22 | 1014 | 68 | 4.1 | 250 |  | 20
Estepona | 36.427277 | -5.150437 | 2020-06-05 10:00:00 +0000 UTC |  | 20.14 | 23.33 | 1014 | 69 | 5.1 | 260 |  | 20
Estepona | 36.427277 | -5.150437 | 2020-06-05 11:00:00 +0000 UTC |  | 20.7 | 25 | 1015 | 64 | 5.1 | 250 |  | 40
Estepona | 36.427277 | -5.150437 | 2020-06-05 12:00:00 +0000 UTC |  | 21.06 | 26.11 | 1014 | 64 | 6.2 | 260 |  | 20
Estepona | 36.427277 | -5.150437 | 2020-06-05 13:00:00 +0000 UTC |  | 21.37 | 26.11 | 1014 | 57 | 5.1 | 230 |  | 20
Estepona | 36.427277 | -5.150437 | 2020-06-05 14:00:00 +0000 UTC |  | 21.53 | 26.11 | 1014 | 61 | 5.1 | 230 |  | 20
Estepona | 36.427277 | -5.150437 | 2020-06-05 15:00:00 +0000 UTC |  | 21.59 | 26.67 | 1013 | 54 | 4.6 | 230 |  | 20
Spreadsheet: 803877d1667760991-combined-data-into-1-cell-book1
Sheet: Inspection Record

Date Inspection Completed | Date Received | Item Revision | Supplier | PO | Delivery Note | C of C Reference | Batch/Serial No. | Inspection Level | Lot Size | Sample Size | Inspection Step Failure (ref. tab 1) | Failure details | Accepted Qty | Rejected Qty | Inspector | NCR No. | CS No. | VRA No. | Time Taken for Inspection  (inc. admin) | Additional Comments | Time Taken per Sampled Part | Yield  Pass % | Turn around (days) | [NAME]. | A | B | C | D1 | D2 | E | F | G | H | I | J | K | L | M
 | 2022-11-06 00:00:00 |  |  |  | 3030299 |  | 12877665
Spreadsheet: 774542d1648540692-using-an-approriate-function-aaa
Sheet: Grade Sheet

 |  |  |  | 0.25 | 0.25 | 0.2 | 0.2 | 0.1
Student Name | Firstname | Lastname | [NAME] ID | Exam 1 | Exam 2 | Exam 3 | Project | LAB | FINAL MARK | Grade
 | Adam | Bryans | 1257896 | 85 | 90 | 100 | 90 | 88
 | [NAME] | Farmer | 1521450 | 75 | 80 | 72 | 100 | 82
 | Boone | Dunes | 1010256 | 89 | 85 | 75 | 95 | 70
 | [NAME] | [NAME] | 1234527 | 90 | 65 | 88 | 88 | 75
 | [NAME] | [NAME] | 1235471 | 67 | 62 | 90 | 80 | 77
 | [NAME] | [NAME] | 1316985 | 88 | 78 | 80 | 85 | 80
 | Coulter | Balabagan | 1256325 | 60 | 88 | 90 | 100 | 85
 | Fegin | Richmond | 1239856 | 100 | 90 | 70 | 85 | 100
 | Ford | [NAME] | 1297458 | 90 | 67 | 100 | 75 | 95
 | [NAME] | [NAME] | 1274587 | 85 | 88 | 70 | 72 | 75
 | Goodman | [NAME] | 1265894 | 72 | 60 | 65 | 80 | 90
 | Milgrom | Aquino | 1265844 | 65 | 75 | 72 | 90 | 70
 | [NAME] | Binay | 1268714 | 80 | 80 | 88 | 80 | 60
 | Smith | Adam | 1258987 | 77 | 85 | 68 | 70 | 80
1) Using an approriate function, find the student name.
2) Find the final mark of each student using this formula: (Exam 1 25%, Exam 2 25%, Exam3 20%, Project 20%, and Lab 10%).
3) Calculate the grade using a proper function.The reference table is given in sheet 3.
4) Insert a bar graph for the Student Name and [NAME].
Spreadsheet: 688946d1596029566-formula-to-calculate-days-in-month-item-is-held-days-month-item-held
Sheet: Sheet1

 |  |  |  | Days in month> | 31 | 29 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
Item | Holding Days | Purchase Date | Sale Date |  | Jan | Feb | March | April | May | June | July | August | Sept | Oct | Nov | Dec
 |  |  |  |  | 2020-01-01 00:00:00
Widget 1 | 205 | 2020-02-14 00:00:00 |  |  |  | 16 | 31 | 30 | 31 | 30 | 31 | 31 | 5
Widget 2 | 247 | 2020-04-07 00:00:00 |  |  |  |  |  | 24 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 9
Widget 3 | 16 | 2020-06-02 00:00:00 |  |  |  |  |  |  |  | 16
 |  |  |  |  |  | 2020-09-05 00:00:00
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-10-31 00:00:00 |  | 1338722.1
2001-11-30 00:00:00
50895
60874 | 2596
78169
500235
500248
500251
500254
500255
500262 | -3689
500267
Duke Energy Trading and Marketing
Contract  24693
2001-11-30 00:00:00 |  | 275313.72
2001-10-31 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 286922 | 117857 | 165811
 |  | 795961.29
2001-11-30 00:00:00
500241
500391 | 4778
500392 | 2682
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36403
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 61054d1261648890-excel-2007-excel-2007-connection-between-two-tables-711863-excel-2007-connection-beatween-two-tables
Sheet: Sheet1

 |  | Table 1 |  |  |  |  | Table 2
 |  |  |  |  |  |  |  | Program for production
 | r/b | Profiles | Up side | Dawn side |  |  | r/b | Profiles | Up side | Dawn side | bars
 | 1 | M11260 | M11063 | M11265 |  |  | 1 | M11260 |  |  | 100
 | 2 | M11064 | M11063 | M11012
 | 3 | M11018 | M11023 | M11015
 | 4 | M11044 | [NAME] | M11045
 | 5 | M11044 | [NAME] | M11045
 | 6 | M11048 | M11046 | M11047
 | 7 | M11048 | M11046 | M11047
 | 8 | [NAME] | M11019 | M11012
 | 9 | [NAME] | M11019 | M11012
 | 10 | M11062 | M11061 | M11009
 | 11 | M9658 | M9658A | M9652B
 | 12 | M11149 | [NAME] | M11012
 | 13 | M9653 | M9653A | M9652B
 | 14 | M11190 | M11189 | M11191
Spreadsheet: 135248d1325879005-excel-2007-pivot-table-top-5-filter-pivot-table-size-and-range-offset-function-to-define-dynamic-name
Sheet: Sheet1

name | marks
a | 4
b | 4
c | 6
d | 43
e | 34 |  |  |  | Row Labels | Sum of marks
f | 6 |  |  |  | a | 4
 |  |  |  |  | b | 4
 |  |  |  |  | c | 6
 |  |  |  |  | d | 43
 |  |  |  |  | e | 34
 |  |  |  |  | f | 6
 |  |  |  |  | Grand Total | 97
Spreadsheet: 44678d1243446881-countif-formula-with-two-conditions-countif-formula
Sheet: Sheet1

 |  |  | Name | Converted
 |  |  | Kelsey | No
 |  |  | Kelsey | No
 |  |  | Kelsey | No
 |  |  | Kelsey | No
 |  |  | Kelsey | Yes
 |  |  | Kelsey | Yes
 |  |  | Kelsey | Yes
 |  |  | Kelsey | Yes
 |  |  | Kelsey | Yes
 |  |  | Kelsey | Yes
 |  |  | [NAME] | No
 |  |  | [NAME] | No
 |  |  | [NAME] | No
 |  |  | [NAME] | No
 |  |  | [NAME] | Yes
 |  |  | [NAME] | Yes
 |  |  | [NAME] | Yes
 |  |  | [NAME] | Yes
 |  |  | [NAME] | Yes
 |  |  | [NAME] | Yes
Spreadsheet: 6ba128e6-cfd7-43e4-83b6-d28ef25356fa
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3382 | 15297 | Sonja | Krolik | GER | 0 |  |  |  |  |  | 1 | 2:05:02
3382 | 18701 | Alexandra | Laws | AUS | 0 |  |  |  |  |  | 2 | 2:09:36
3382 | 15263 | Helena | Edmonston | AUS | 0 |  |  |  |  |  | 3 | 2:09:41
3382 | 18705 | Katariina | Ebeling | FIN | 0 |  |  |  |  |  | 4
3382 | 18707 | [NAME] | Sodek | CAN | 0 |  |  |  |  |  | 5
3382 | 14396 | [NAME] | [NAME] | NZL | 0 |  |  |  |  |  | 6
3382 | 18692 | Natalya | Orchard | AUS | 0 |  |  |  |  |  | 7
3382 | 18706 | Carola | [NAME] | GER | 0 |  |  |  |  |  | 8
3382 | 18709 | Kathy | Walls | NZL | 0 |  |  |  |  |  | 9
3382 | 18708 | Alexandra | [NAME] | NZL | 0 |  |  |  |  |  | 10
Spreadsheet: 814160d1674197582-need-help-writing-an-automated-training-program-for-clients-2dpw-ul-
Sheet: set,rep,rest,tempo

Sets | Reps | Rest | Tempo
1 | 1 | 30s | 1-0-1-0
2 | 2 | 1 Min | 2-0-2-0
3 | 3 | 1.5 Min | 3-0-3-0
4 | 4 | 2 Min | 4-0-4-0
5 | 5 | 2.5 Min | 5-0-5-0
6 | 6 | 3 Min | 10-10-0
7 | 7 | 5 Min | 1-1-1-1
8 | 8 |  | 2-1-2-1
9 | 9 |  | 3-1-3-1
10 | 10 |  | 4-1-4-1
 | 11 |  | 5-1-5-1
 | 12 |  | 10-1-10-1
 | 13 |  | 1-2-1-2
 | 14 |  | 2-2-2-2
 | 15 |  | 3-2-3-2
 | 20 |  | 4-2-4-2
 | 25 |  | 5-2-5-2
 | 30 |  | 10-2-10-2
 | 50
 | 100 |  | 2-0-4-1
 | 20,15,15,10 |  | 2-0-5-1
 | 15,12,12,10 |  | 2-1-4-1
 | 12,10,10,8 |  | 2-1-5-1
 | 10,8,8,6 |  | 3-1-4-1
 | 8,6,6,4 |  | 3-1-5-1
 | 6,4,4,3 |  | 4-0-2-1
 | 6,8,8,10 |  | 4-1-2-1
 | 8,10,10,12 |  | 5-0-2-1
 | 10,12,12,15 |  | 5-1-2-1
 | 12,15,15,20 |  | 5-1-3-1
 | 20,15,10 |  | 5-1-1-1
 | 15,12,10 |  | 4-1-1-1
 | 12,10,8 |  | 1-1-4-1
 | 10,8,6 |  | 1-1-5-1
 | 6,4,3
 | 6,8,10 |  | 5-1-3-3
 | 8,10,12 |  | 5-5-3-3
 | 10,12,15 |  | 5-10-3-3
 | 12,15,20
 | 1-3
 | 3-6
 | 5-10
 | 8-12
 | 10-15
 | 10-20
 | 20-30
 | 30+
Spreadsheet: 850719d1701107116-return-value-yes-or-no-if-a-time-is-greater-or-less-than-a-time-displayed-in-another-cell-times
Sheet: Sheet1

Late? | SLA | Delivered time
Y | 09:00:00 | 10:55:00
Y | 08:00:00 | 10:54:37
Y | 09:00:00 | 10:50:00
Y | 08:00:00 | 10:44:57
N | 17:30:00 | 10:44:23
N | 17:30:00 | 10:44:23
N | 17:30:00 | 10:44:23
Y | 08:00:00 | 10:43:47
Spreadsheet: 792359d1660856668-car-share-pay-calculation-carshare
Sheet: Sheet1

 | Date | L, S, M, are names for example.
 |  | L | S | M | Z - driver |  | L. Pays | xx | to S.
MON | 2022-08-15 00:00:00 | Z | X | X | [NAME] payer/passenger |  |  | xx | to M.
TUE | 2022-08-16 00:00:00 | Z | X | X
WED | 2022-08-17 00:00:00 |  |  |  |  |  | S. Pays | xx | to L.
THU | 2022-08-18 00:00:00 |  |  |  |  |  |  | xx | to M.
FRI | 2022-08-19 00:00:00
 |  |  |  |  |  |  | M. Pays | xx | to S.
 |  |  |  |  |  |  |  | xx | to L.
Spreadsheet: 70069d1270732181-getting-around-maximum-7-if-statements-example1
Sheet: Sheet1

 | Long Code | Short Code | Neutral Code | Initiation Code
 | Overweight | Underweight | Neutral | 0
 | Outperform | Underperform | Peerperform | est. dropped coverage
 | Pairs
 |  |  |  |  |  |  |  |  | End Date | 180
Code | Code | New Rating Code | Old Rating Code |  | Ticker | BB Ticker | Date | Start Date | End Date | New Rating | Old Rating | Target Price | U/D Before ERN? | U/D After ERN? | Earnings Date | Date | Comment | Pair
1 | Short | Sell | Neutral |  | CHH | CHH Equity | 2010-03-25 00:00:00 | 2010-03-24 00:00:00 | 2010-09-20 00:00:00 | Underweight | Neutral | 31 |  |  |  | 2010-03-25 00:00:00 |  | 1
1 | Long Basket |  |  |  | [NAME] | ASCA  Equity
1 | Long Basket |  |  |  | BYD | BYD  Equity
1 | Long Basket |  |  |  | BYI | BYI  Equity
1 | Long Basket |  |  |  | CCL | CCL  Equity
1 | Long Basket |  |  |  | GET | GET  Equity
1 | Long Basket |  |  |  | H | H  Equity
1 | Long Basket |  |  |  | HOT | HOT  Equity
1 | Long Basket |  |  |  | IGT | IGT  Equity
1 | Long Basket |  |  |  | IILG | IILG  Equity
1 | Long Basket |  |  |  | MCS | MCS  Equity
1 | Long Basket |  |  |  | MGM | MGM  Equity
1 | Long Basket |  |  |  | OEH | OEH  Equity
1 | Long Basket |  |  |  | PNK | PNK  Equity
1 | Long Basket |  |  |  | RCL | RCL  Equity
1 | Long Basket |  |  |  | RLH | RLH  Equity
1 | Long Basket |  |  |  | SHFL | SHFL  Equity
1 | Long Basket |  |  |  | WMS | WMS  Equity
1 | Long Basket |  |  |  | WYN | WYN  Equity
1 | Long Basket |  |  |  | WYNN | WYNN  Equity
1 | Long Basket
Spreadsheet: 59694d1260279871-line-graph-in-descending-order-dist-3-jan-09-nov-09
Sheet: Complaint Costs 2009 YTD

 | Unit |  | Complaints Totals | % complaints costs v turnover | Turnover |  | Type | District | Plant | Plant name | Complaint Costs | Turnover | % against turnover
B | Cornelly Asphalt |  | 141210.08 | 0.0195396497653778 | 7226848.06 |  | A | A3 | B197 | [NAME] | 38 | 691026.29 | 5.499067191785134e-05
B | Torcoed Asphalt |  | 76922.16 | 0.01492429311941423 | 5154157.68 |  | A | A3 | B199 | [NAME] | 0 | 1080805.29 | 0
A | Torcoed [NAME] |  | 31139.23 | 0.005677822139975038 | 5484361.649999995 |  | A | A3 | B200 | Torcoed [NAME] | 1139.23 | 5484361.649999995 | 0.0002077233546405535
B | Llanwern Asphalt |  | 15742.8 | 0.003522077061295668 | 4469748.88 |  | A | A3 | B206 | Cornelly Quarry | 1112.08 | 3879245.889999994 | 0.0002866742742105481
C | Cardiff Concrete |  | 1644 | 0.0008847858124874827 | 1858076.81 |  | A | A3 | B208 | Llanwern Blast Furnace Slag | 0 | 491273.97 | 0
A | Creigiau Merchanting (1) |  | 1437.7 | 0.0006434793735813115 | 2234259.65 |  | A | A3 | B211 | Port Talbot Blast Furnace Slag | 0 | 2428763.94 | 0
A | Port Talbot Steel Slag |  | 1015.3 | 0.000576787865705833 | 1760265.88 |  | A | A3 | B213 | Port Talbot Steel Slag | 814.71 | 1760265.88 | 0.0004628334896771391
C | Tongwynlais Concrete |  | 1143.75 | 0.0005565019995536515 | 2055248.679999995 |  | A | A3 | B220 | Creigiau Merchanting (1) | 937.37 | 2234259.65 | 0.0004195438967892564
A | Cornelly Quarry |  | 886 | 0.0002283949058975484 | 3879245.889999994 |  | A | A3 | B228 | [NAME] Ffos [NAME] | 0 | 2305408.87 | 0
C | [NAME] |  | 223.67 | 0.0001497952632871921 | 1493171.38 |  | S | A3 | B328 | Cardiff Wharf | 0 | 837979.6199999994 | 0
A | [NAME] |  | 38 | 5.499067191785134e-05 | 691026.29 |  | S | A3 | B330 | [NAME] | 0 | 615247 | 0
A | [NAME] |  | 0 | 0 | 1080805.29 |  | S | A3 | B331 | [NAME] | 0 | 639111.67 | 0
A | Port Talbot Blast Furnace Slag |  | 0 | 0 | 2428763.94 |  | S | A3 | B333 | [NAME] | 0 | 180339.06 | 0
 |  |  |  |  |  |  | B | A3 | D100 | Torcoed Asphalt | 76922.16 | 5154157.68 | 0.01492429311941423
 |  |  |  |  |  |  | B | A3 | D102 | Cornelly Asphalt | 141210 | 7226848.06 | 0.01953963869554496
 |  |  |  |  |  |  | B | A3 | D101 | Llanwern Asphalt | 15742.8 | 4469748.88 | 0.003522077061295667
 |  |  |  |  |  |  | C | A3 | G220 | Bridgend Concrete | 0 | 2710809.39 | 0
 |  |  |  |  |  |  | C | A3 | G221 | Cardiff Concrete | 444 | 1858076.81 | 0.0002389567522776413
 |  |  |  |  |  |  | C | A3 | G233 | Tongwynlais Concrete | 1143.75 | 2055248.679999995 | 0.0005565019995536515
 |  |  |  |  |  |  | C | A3 | G234 | [NAME] | 0 | 1493171.38 | 0
Spreadsheet: 32947d1229107203-drag-copy-variable-data-inventory_list
Sheet: Sheet1

 | Location ID | Type of Storage | Stock | Weight | Color | Finish | Size | Quantity
1 | 1A
2 | 1B
3 | 1C
4 | 1D
5 | 1E
6 | 1F
7 | 1G
8 | 1H
9 | 1I
10 | 1J
11 | 1K
12 | 1L
13 | 2A
14 | 2B
15 | …….
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
Spreadsheet: 845474d1696972389-calculating-time-difference-where-time-format-includes-millisecond-time-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Added "." between sec and millisec.
 | Start timestamp | end timestamp |  |  | Start-time | End-time | Difference (Secs number) |  |  | Start-time | End-time | Difference (Seconds number)
 | 08/09/2023 11:35:02:286 | 08/09/2023 11:35:02:457 |  |  | 11:35:02:286 | 11:35:02:457 |  |  |  | 11:35:02.286000 | 11:35:02.457000
 | 08/09/2023 11:35:02:547 | 08/09/2023 11:35:03:287 |  |  | 11:35:02:547 | 11:35:03:287 |  |  |  | 11:35:02.547000 | 11:35:03.287000
 | 08/09/2023 11:35:05:288 | 08/09/2023 11:35:05:890 |  |  | 11:35:05:288 | 11:35:05:890 |  |  |  | 11:35:05.288000 | 11:35:05.890000
 | 08/09/2023 11:35:06:335 | 08/09/2023 11:35:06:567 |  |  | 11:35:06:335 | 11:35:06:567 |  |  |  | 11:35:06.335000 | 11:35:06.567000
 | 08/09/2023 11:35:07:289 | [NAME] 11:39:08:120 |  |  | 11:35:07:289 | 11:39:08:120 |  |  |  | 11:35:07.289000 | 11:39:08.120000
 |  |  |  |  |  |  | DATE(0+MID($B4,7,4),0+MID($B4,4,2),0+MID($B4,1,2))-TIME(0+MID($B4,12,2),0+MID($B4,15,2),0+MID($B4,18,2))
Spreadsheet: b4b211fe-7956-41b9-be43-b0716fd33ecc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259008 | 18105 | [NAME] | Forster | GBR |  | 00:29:18 | 00:01:19 | 00:47:51 | 00:01:12 | 00:17:28 | 1 | 01:37:06
Spreadsheet: 122914d1317237680-copying-multiple-cells-based-on-drop-down-employee-ranking
Sheet: BP Input WK2

Location | Employee # | Employee | Apps | Approval | AS+ | Preapprov | [NAME] | ITA | ITA% | Existing | Existing %
Store 479 | 241087 | Roark, [NAME] | 67 | 0.4179 | 14 | 0 | 0 | 14 | 0 | 0 | 0
Store 479 | 10594 | [NAME], Stephen | 35 | 60 | 1 | 8 | 12.5 | 10 | 0 | 0 | 0
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: 4

Name | lbs | oz | Oz (total) | Points
 | 33 | 0
 | 13 | 0
 | 14 | 10
 | 59 | 0
 | 5 | 2
 | 5 | 5
 | 19 | 2
 | 9 | 4
 | 0 | 0
 | 5 | 8
 | 0 | 0
 | 3 | 14
 | 6 | 4
 | 1 | 8
 | 15 | 0
 | 7 | 0
 | 9 | 0
 | 0 | 0
Spreadsheet: 330283d1404681117-formula-if-help-for-a-schedule-schedule-template-wip
Sheet: Part Timers

[NAME] | Monday | Available OP-CL |  | [NAME] | Monday | OP - 4
 | Tuesday | School |  |  | Tuesday | OP - 5:30
 | Wednesday | Available OP-CL |  |  | Wednesday | OP - 5:30
 | Thursday | School |  |  | Thursday | OP - 5:30
 | Friday | Available OP-CL |  |  | Friday | OP - 5:30
Isela | Monday | Available OP - CL
 | Tuesday | School
 | Wednesday | Available OP - CL
 | Thursday | School
 | Friday | 12 - CL
Spreadsheet: lisa_gang__22454__prel_epmi_salesjlo
Sheet: Mrkr_EPMI_SalesMay02

EPMI | May | 2002 | May 24 2002 12:57PM
Product | SPFS
SubProduct | BOOKO | MO |  |  |  | NODEL
Contract | 01PB-24445 | 00PB-23273 | 00PB-23274 | 99PB-21892 | 99PB-21896 | 00PB-23274
Contract Dates
Owner
COBH Flag
Est Price Flag
Rate |  |  |  |  |  |  | DAY MWH | TOTAL$$
1 | 800 | 1200 | 1200 | 600 | 320 |  |  | 110798
2 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
3 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
4 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
5 |  | 1200 | 1200 | 600 | 600 |  |  | 95928
6 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
7 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
8 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
9 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
10 | 800 | 1200 | 1175 | 600 | 600 | 25 |  | 117728
11 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
12 |  | 1200 | 1200 | 600 | 600 |  |  | 95928
13 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
14 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
15 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
16 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
17 | 800 | 1200 | 940 | 549 | 600 |  |  | 109248.75 | Contract 21892 cut on Real Time
18 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
19 |  | 1200 | 1200 | 600 | 600 |  |  | 95928
20 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
21 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
22 | 800 | 1200 | 1200 | 600 | 600 |  |  | 117728
TOTALS
Spreadsheet: 745070d1629724975-sum-if-value-match-formula-2
Sheet: 23-08-2021

Daily PMC Transfer Target Sheet
Serial No | Style No | Season | Column1 | Order QTY | RCV QTY | Remarks | Work -Area
1 | FZ-658 | EF-22 |  | 277 | 278 | Wait For Finishing | Inhouse
2 | FZ-654 | SP-22 |  | 400 | 328 | Wait For Finishing | Inhouse
3 | FZ-657 | EF-22 |  | 287 | 271 | Wait For Finishing | Inhouse
4 | JR-044 | SP-22 |  | 200 | 207 | Wait For Finishing | Inhouse
5 | FZ-668 | EF-22 |  | 370 | 356 | Wait For Finishing | Inhouse
6 | SA-355 | EF-22 |  | 154 | 153 | Wait For Finishing | Subcon
7 | SA-317 | EF-22 |  | 698 | 656 | Wait For Finishing | Subcon
8 | RB-1121 | EF-22 |  | 307 | 267 | Wait For Finishing | Subcon
9 | SS-1235 | [NAME] |  | 422 | 438 | Rework | Subcon
10 | SA-295 | WIN-21/22 |  | 300 | 286 | Recheck - Merchandiser | Inhouse
11 | SI-305 | WIN-21/22 |  | 300 | 314 | Wait For Size Grading | Inhouse
12 | RB-1203 | EA-21 |  | 400 | 459 | [NAME] | Subcon
13 | RB-1202 | EF-22 |  | 300 | 301 | [NAME] | Subcon
14 | EV-415 | WIN-21/22 |  | 202 | 202 | [NAME] | Subcon
15 | RB-1132 | EF-22 |  | 308 | 291 | [NAME] | Semi
16 | SO-010 | EF-22 |  | 1463 | 1484 | [NAME] | Subcon
17 | SO-016 | EF-22 |  | 480 | 522 | [NAME] | Subcon
18 | SS-1220 | EF-22 |  | 240 | 237 | [NAME] | Inhouse
19 | RB-1099 | EF-22 |  | 337 | 316 | [NAME] | Subcon
20 | ST-031 | EF-22 |  | 333 | 358 | Decession pending. Button N/A | Subcon
21 | FZ-620 | EF-22 |  | 316 | 314 | Dopatta N/A | Inhouse
 | MRP OK |  | Total | Result Will be 3812 Here
 |  |  | 3812
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: PHIL

Old course number | New course number
PHIL-301 | PHIL-3101
PHIL-311 | PHIL-3111
PHIL-330 | PHIL-3333
PHIL-371 | PHIL-3881
PHIL-386 | PHIL-3886
PHIL-470 | PHIL-4700
PHIL-524 | PHIL-4254
PHIL-533 | PHIL-4330
PHIL-542 | PHIL-4402