tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 173402d1344537303-calculation-time-too-high-cvtcb07-version-2-
Sheet: Sheet1

[NAME] | DataList | Your Array | C/V | Non-Array using helper in Column A
0.0001 | 010383S^^^^0 | 010383S^^^^0 | 1 | 010383S^^^^0
1.0002 | 010426R-CO^^^^200 | 010426R-CO^^^^200 | 1 | 010426R-CO^^^^200
16.0003 | 510426R-CO^^CCN35-89NV-XL^03/26/2012^20 | 010455R^^^^0 | 1 | 010455R^^^^0
2.0004 | 010455R^^^^0 | 010455R^^^^0 | 1 | 010455R^^^^0
2.0005 | 010455R^^^^0 | 010455R^^^^0 | 1 | 010455R^^^^0
2.0006 | 010455R^^^^0 | 010455R^^^^0 | 1 | 010455R^^^^0
2.0007 | 010455R^^^^0 | 010455R^^^^0 | 1 | 010455R^^^^0
2.0008 | 010455R^^^^0 | 010455R^^^^0 | 1 | 010455R^^^^0
2.0009 | 010455R^^^^0 | 010491R^^^^450 | 1 | 010491R^^^^450
8.001 | 010491R^^^^450 | 010502R^^^^0 | 1 | 010502R^^^^0
17.0011 | 810491R^^CFRZC-65WH-L^06/12/2012^4 | 010502R^^^^0 | 1 | 010502R^^^^0
18.0012 | 810491R^^CFRZC-65WH-M^06/12/2012^21 | 010520S-CO^^^^0 | 1 | 010520S-CO^^^^0
19.0013 | 810491R^^CFRZC-65WH-XL^06/12/2012^10 | 010520S-CO^^^^157 | 1 | 010520S-CO^^^^157
9.0014 | 010502R^^^^0 | 010520S-CO^^Alteration^05/31/2012^10 | 1 | 010520S-CO^^Alteration^05/31/2012^10
9.0015 | 010502R^^^^0 | 010520S-CO^^Alteration^05/31/2012^47 | 1 | 010520S-CO^^Alteration^05/31/2012^47
11.0016 | 010520S-CO^^^^0 | 010520S-CO^^Note^^1 | 1 | 010520S-CO^^Note^^1
12.0017 | 010520S-CO^^^^157 | 510426R-CO^^CCN35-89NV-XL^03/26/2012^20 | 1 | 510426R-CO^^CCN35-89NV-XL^03/26/2012^20
15.0018 | 010520S-CO^^Note^^1 | 810491R^^CFRZC-65WH-L^06/12/2012^4 | 1 | 810491R^^CFRZC-65WH-L^06/12/2012^4
13.0019 | 010520S-CO^^Alteration^05/31/2012^10 | 810491R^^CFRZC-65WH-M^06/12/2012^21 | 1 | 810491R^^CFRZC-65WH-M^06/12/2012^21
14.002 | 010520S-CO^^Alteration^05/31/2012^47 | 810491R^^CFRZC-65WH-XL^06/12/2012^10 | 1 | 810491R^^CFRZC-65WH-XL^06/12/2012^10
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
Spreadsheet: phillip_platter__31378__RT-STCA August
Sheet: Aug09

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | PRICE | MARKET | FEES | CONG | A_S CHARGE | BASIS | FERC ADJ | ENPOWER DEALS | TMM | LINE LOSSES | P_L | FILE SOURCE | TAG NO
2001-08-09 00:00:00 |  | Y | 1 | 1 |  | SP15 | ST CALI | 12 |  |  | 30 | PWRX |  |  |  |  |  |  | 724376,724377 | 1
2001-08-09 00:00:00 |  | Y | 2 | 5 |  | SP15 | ST CALI | 12 |  |  | 25 | PWRX |  |  |  |  |  |  | 724376,724377 | 1
2001-08-09 00:00:00 |  | Y | 6 | 6 |  | SP15 | ST CALI | 12 |  |  | 25 | EES |  |  |  |  |  |  | 724376,724378 | 1
2001-08-09 00:00:00 |  | Y | 7 | 7 |  | SP15 | EES | 17 |  |  | 20 | STCALI |  |  |  |  |  |  | 724379,724382 | 1
2001-08-09 00:00:00 |  | Y | 8 | 8 |  | PV/SP15 | EPE | 17 |  | EPMI_CISO_DESERT | 45 | STCALI |  |  |  |  |  |  | 724380,724381,724382 | 1
2001-08-09 00:00:00 |  | Y | 9 | 9 |  | PV/SP15 | EPE | 11 |  | EPMI_CISO_DESERT | 50 | STCALI |  |  |  |  |  |  | 724380,724381,724382 | 1
2001-08-09 00:00:00 |  | Y | 9 | 9 |  | SP15 | EES | 6 |  |  | 25 | STCALI |  |  |  |  |  |  | 724379,724382 | 1
2001-08-09 00:00:00 |  | Y | 10 | 10 |  | PV/SP15 | SRP | 17 |  | EPMI_CISO_DESERT | 42 | STCALI |  |  |  |  |  |  | 725271,724381,724382 | 1
2001-08-09 00:00:00 |  | Y | 11 | 12 |  | SP15 | CORAL | 17 |  |  | 50 | STCALI |  |  |  |  |  |  | 725748,724382 | 1
2001-08-09 00:00:00 |  | Y | 13 | 15 |  | SP15 | SRP | 17 |  |  | 57 | STCALI |  |  |  |  |  |  | 725271,724381,724382 | 1
2001-08-09 00:00:00 |  | Y | 16 | 17 |  | SP15 | WESCO | 15 |  |  | 48 | STCALI | 0.36 |  |  |  |  |  | 725749,724382 | 1
2001-08-09 00:00:00 |  | Y | 16 | 17 |  | SP15 | NEVI | 2 |  |  | 48 | STCALI |  |  |  |  |  |  | 725750,724382 | 1
2001-08-09 00:00:00 |  | Y | 18 | 18 |  | SP15 | NEVI | 15 |  |  | 48 | STCALI |  |  |  |  |  |  | 725750,724382 | 1
2001-08-09 00:00:00 |  | Y | 18 | 18 |  | SP15 | EES | 2 |  |  | 36 | STCALI |  |  |  |  |  |  | 724379,724382 | 1
2001-08-09 00:00:00 |  | Y | 19 | 22 |  | SP15 | EES | 17 |  |  | 36 | STCALI |  |  |  |  |  |  | 724379,724382 | 1
2001-08-09 00:00:00 |  | Y | 23 | 24 |  | SP15 | ST CALI | 12 |  |  | 28 | EES |  |  |  |  |  |  | 724376,724378 | 1
Spreadsheet: 672442d1586872176-need-one-formula-to-divide-the-sum-of-one-column-by-another-sample
Sheet: Sheet1

Educational Content Domain Outcomes |  |  | Number of Eligible Individuals enrolled and receiving instruction in educational content domain |  |  |  | Number of Eligible Individuals with demonstrated improvement of skills in educational content domain |  |  |  | Number of eligible individuals who left program without an educational improvement
 |  |  | Program Year 2017 |  | Program Year 2018 |  | Program Year 2017 |  | Program Year 2018 |  | Program Year 2017 |  | Program Year 2018
Reading
Writing
Mathematics
English Language Acquisition
Civics/Citizenship Education
Workforce Preparation Employability Skills
TOTALS
Spreadsheet: 274488d1383133527-recognise-two-different-employee-id-numbers-in-one-cell-example
Sheet: Sheet3

1-3 | 1-3 | 1 | 3 | 1
1-4 | 1-4 | 1 | 4 | 1
2-5 | 2-5 | 2 | 5 | 3
5-2 | 2-5 | 5 | 2 | 0
6-1 | 1-6 | 6 | 1 | 0
7-3 | 3-7 | 7 | 3 | 0
2-5 | 2-5 | 2 | 5 | 1
9-4 | 4-9 | 9 | 4 | 0
9-5 | 5-9 | 9 | 5 | 0
9-6 | 6-9 | 9 | 6 | 0
Spreadsheet: 72935d1273621244-cumulative-means-graph-crosses-cumulative-means
Sheet: Sheet1

 | game number | Crosses per game
 | 1 | 5
 | 2 | 9
 | 3 | 5
 | 4 | 9
 | 5 | 16
 | 6 | 7
 | 7 | 4
 | 8 | 7
 | 9 | 11
 | 10 | 11
 | 11 | 3
 | 12 | 14
 | 13 | 7
 | 14 | 6
 | 15 | 5
 | 16 | 6
 | 17 | 4
 | 18 | 3
 | 19 | 8
 | 20 | 5
 | 21 | 2
 | 22 | 10
 | 23 | 10
 | 24 | 3
 | 25 | 13
 | 26 | 12
 | 27 | 4
 | 28 | 4
 | 29 | 6
Spreadsheet: 796643d1663415252-xlookup-with-multiple-criteria-options-example-workbook-5-aligw
Sheet: HOS

United Kingdom | Queen | [NAME] |  | Head of State | Royalty | Head of Government
Oman | Sultan | [NAME] |  | President | Emir | Prime Minister
Denmark | Queen | Margrethe II |  |  | Emperor
Sweden | King | [NAME] |  |  | King
Eswatini | King | [NAME] |  |  | Queen
Japan | Emperor | [NAME] |  |  | Sultan
[NAME] | Prince | [NAME]
Norway | King | [NAME]
[NAME] | King | [NAME]
Jordan | King | [NAME]
Bahrain | King | Sheikh [NAME] ibn Isa Al Khalifah
Morocco | King | [NAME]
Luxembourg | Grand Duke | Henri
Andorra | Co-Prince | Archbishop [NAME] Vives Sicília
Cambodia | King | [NAME]
Monaco | Prince | [NAME]
Kuwait | Emir | Sheikh [NAME]
Bhutan | King | [NAME]
Tonga | King | Tupou VI
Netherlands | King | [NAME]
Australia | Prime Minister | [NAME]
USA | President | [NAME]
Spreadsheet: 220878d1363288858-how-to-copy-rows-from-sheet1-to-sheet2-test1formula
Sheet: Sheet1

Hostname - OLD | Hostname - NEW | IP Address | Description
[NAME] | NEW065498 | 10.65.49.8 | Dr.[NAME]
C-64704 | NEW064704 | 10.64.70.4 | Dr nice
S-064778 | NEW064778 | 10.64.77.8 | hello
S-067135 | NEW067135 | 10.67.13.5 | test
Spreadsheet: 788598d1658568715-formula-not-loading-correct-data-sample-quarter-tolls
Sheet: Sample Quarter Tolls

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  | Harbour | Harbour | Eastern
 | Date | Category | Airport | Bridge | Tunnel | Distributor |  | Taxi (GST included)
 | 2022-07-06 00:00:00 | Taxi | 5.1 | 2.5
 | 2022-07-07 00:00:00 | Taxi |  |  | 3
End of Week 1
 | 2022-07-14 00:00:00 | Taxi |  |  |  | 8.72
End of Week 2
 | 2022-07-23 00:00:00 | School |  | 2.5 | 3
Categories
Private
School |  |  |  |  |  |  | Taxi
Taxi |  |  |  |  |  |  | Count =
Spreadsheet: 89406d1289214311-adding-values-to-drop-down-lists-that-are-selected-by-users-product-quote
Sheet: Sheet1

Description | unit price | quantity | total |  | unit buy price | unit sell price | unit margin | total buy price | total sale price | total margin | %             margin
Product1 | 1081 | 2 | 2162 |  | 730.7 | 1081 | 350.3 | 1461.4 | 2162 | 700.5999999999999 | 0.3240518038852914
 | 791 | 7 | 5537 |  | 525.06 | 791 | 265.9400000000001 | 3675.42 | 5537 | 1861.58 | 0.3362073324905184
 | 727 | 4 | 2908 |  | 479.36 | 727 | 247.64 | 1917.44 | 2908 | 990.56 | 0.3406327372764786
 | 329 | 2 | 658 |  | 249 | 329 | 80 | 498 | 658 | 160 | 0.243161094224924
Spreadsheet: 831181d1685467765-referencing-spilled-array-to-create-spilled-array-test3
Sheet: Sheet1

Data Table |  |  |  | Set Target Name: |  | Yellow section should match Green sections |  |  |  |  |  |  |  |  |  |  |  |  |  | Scores Table
[NAME] | Report Year | Sales |  | [NAME] |  | Spilled arrays. |  |  |  |  |  | Expected Results |  |  |  |  |  |  |  |  | 2001 | 2003
Name1 | 2001 | 0.2601754007917111 |  |  |  | Automatically adjusting number of rows |  |  |  |  |  | Manually set number of Rows |  |  |  |  |  |  |  |  | 3 | 5
Name1 | 2001 | 0.5589487394348224 |  | Year List |  | Target Score | Target Value | Min Score | Min Name | Min Name Value |  | Target Score | Target Value | Min Score | Min Name | Min Name Value |  |  | [NAME] | 2 | 4 | 6
Name1 | 2002 | 0.0339131073571044
Name1 | 2003 | 0.6124610747021023 |  | 2002 |  | 4 | 0.3713101902579494 |  |  | 0
Name1 | 2002 | 0.2151687574897279 |  | 2003 |  | 6 | 0.002212278013714819 |  |  | 0
[NAME] | 2002 | 0.0273300349704646
[NAME] | 2001 | 0.5169532134791222 |  |  |  | 2 | 0.3713101902579494 | 1 | Name1 | 0.2490818648468323
[NAME] | 2001 | 0.8352239108885394 |  |  |  | 6 | 0.002212278013714819 | 5 | Name1 | 0.6124610747021023
[NAME] | 2002 | 0.3439801552874848
[NAME] | 2003 | 0.002212278013714819 |  |  |  | [NAME] |  |  |  |  |  |  | u |  |  |  | d |  | f
Name3 | 2005 | 0.33333 |  |  |  |  |  |  |  |  |  |  |  | 2001 | 0.8191241402265335 |  |  |  |  | 2002 | 0.3713101902579494
 |  |  |  |  |  | 4 |  | 4 | [NAME] | 1.352177124367662 |  |  | Name1 | 2002 | 0.2490818648468323 |  | 0.8191241402265335 |  | [NAME] | 2001 | 1.352177124367662
 |  |  |  |  |  | 6 |  | 6 | [NAME] | 0.002212278013714819 |  |  | Name1 | 2003 | 0.6124610747021023 |  | 0.2490818648468323 |  | [NAME] | 2003 | 0.002212278013714819
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2002 | 0.3713101902579494 |  | 0.6124610747021023
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2001 | 1.352177124367662 |  | 0.2490818648468323
 |  |  |  |  |  | Bo_Ry Solution |  |  |  |  |  |  | [NAME] | 2003 | 0.002212278013714819 |  | 0.3713101902579494
 |  |  |  |  |  |  |  |  |  |  |  |  | Name3 | 2005 | 0.33333 |  | 1.352177124367662
 |  |  |  |  |  | 2 |  | 1 | Name1 | 0.2490818648468323 |  |  |  |  |  |  | 1.352177124367662
 |  |  |  |  |  | 6 |  | 5 | Name1 | 0.6124610747021023 |  |  |  |  |  |  | 0.3713101902579494
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002212278013714819
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.33333
Spreadsheet: 868492d1715211099-count-if-there-are-2-probabilities-book1
Sheet: sheet

shift | Date | AM & PM | Reason |  |  |  |  |  | fault |  |  | need to multiply twice for cell C4 into this cell
123 | 2024-05-05 00:00:00 | AM & PM | 1 |  |  |  |  |  | Not at Fault |  |  | need to multiply twice for cell C9 into this cell
345 | 2024-05-05 00:00:00 | AM | 1 |  |  |  |  |  | Total
678 | 2024-05-06 00:00:00 | PM | 1 |  |  |  |  |  | Reason
910 | 2024-05-06 00:00:00 | PM | 5 |  |  |  |  |  | (1) | leave
112 | 2024-05-07 00:00:00 | AM | 5 |  |  |  |  |  | (2) | sick
131 | 2024-05-08 00:00:00 | AM & PM | 5 |  |  |  |  |  | (3) | annual
 |  |  |  |  |  |  |  |  | (4) | medical
 |  |  |  |  |  |  |  |  | (5) | not required
 |  |  |  |  |  |  |  |  | (6) | stopped
 |  |  |  |  |  |  |  |  | (7) | casual
 |  |  |  |  |  |  |  |  | (8) | suspend
 |  |  |  |  |  |  |  |  | (9) | other
 | if only 'am' or 'pm', the reason stays single, in Cell L3 and L4
 | how do I double the count of cells (C4-C9) into L3 or [NAME] if  the 'Am & Pm' is used
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Lead Oxide

Raw Material |  | Lead Oxide
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 1244.1
Total
Spreadsheet: 710192d1608761323-extract-cell-value-if-several-conditions-are-met-excel-example
Sheet: Sheet1

Schedule A
JAN | Mo | [NAME] | We | Th | Fr | Sa | Su
 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Person A | Area 1 | Area 6 | Area 5 | Area 4 | Area 3 | Area 2 | Area 1
Person B | Area 2 | Area 1 | Area 6 | Area 5 | Area 4 | Area 3 | Area 2
Person C | Area 3 | Area 2 | Area 1 | Area 6 | Area 5 | Area 4 | Area 3
Person D | Area 4 | Area 3 | Area 2 | Area 1 | Area 6 | Area 5 | Area 4
Person E | Area 5 | Area 4 | Area 3 | Area 2 | Area 1 | Area 6 | Area 5
Person F | Area 6 | Area 5 | Area 4 | Area 3 | Area 2 | Area 1 | Area 6
Schedule B
JAN | Mo | [NAME] | We | Th | Fr | Sa | Su
 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Area 1
Area 2
Area 3
Area 4
Area 5
Area 6
Spreadsheet: 39813d1238084788-looking-up-a-range-of-cells-with-criterias-attached-book1_mar26
Sheet: Sheet1

Euro | ROI PI | FARM | UK NB | IRL NB | PEN | All-In-One | Value
0.36 | 0.21 | 0.15 | 0.11 | 0.1 | 0.12 | 0.19 | 0.8
0.41 | 0.25 | 0.19 | 0.17 | 0.14 | 0.16 | 0.23 | 1
0.51 | 0.31 | 0.25 | 0.23 | 0.2 | 0.22 | 0.29 | 1.2
0.55 | 0.37 | 0.31 | 0.29 | 0.26 | 0.28 | 0.35 | 1.4
Spreadsheet: 787830d1658078879-cbbox-that-will-dynamically-show-current-year-month-and-year-payments_to_qi-copy
Sheet: Dashboard

 |  |  |  |  |  |  |  |  |  | Months |  | use |  |  | Months
 | 82 | [NAME] | 18 | 600 | Jul-2022 |  |  |  |  | [NAME] |  | Current Month Year |  |  | Jan
44745 | 68 | [NAME] | 11 | 1500 | Jul-2022 |  |  |  |  | Feb-2022 |  | Current year |  |  | Feb
44752 | 44 | [NAME] | 18 | 1500 | Jul-2022 |  |  | 7 |  | Mar-2022 |  | Current Month |  |  | Mar
44755 | 95 | [NAME] | 3 | 1500 | Jul-2022 |  |  |  |  | Apr-2022 |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  | May-2022 |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  | Jun-2022 |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  | Jul-2022 |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  | Aug-2022 |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  | Sep-2022 |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  | Oct-2022 |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  | Nov-2022 |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  | Dec-2022 |  |  |  |  | Dec
Spreadsheet: 686688d1594752443-budgeting-spreadsheet-sample-budget_1
Sheet: Sheet1

 | Paycheck Amount | 2400 | Date Paid | 2020-08-01 00:00:00 |  |  | This would be on a different page:
 |  |  |  |  |  |  | Bills | Amount | Due Date | Paycheck 1 | Paycheck 2
 |  |  |  |  |  |  | Gas | 65 | 15
 |  |  |  |  |  |  | Water | 45 | 28
 |  |  |  |  |  |  | Mortgage | 1700 | 1
 | Bills | Amount | Dates Due |  |  |  | Credit Card | 150 | 1
 | Gas | 65 | 2020-08-15 00:00:00 |  |  |  | Gas | 75 | 15
 | Water | 45 | 2020-08-28 00:00:00 |  |  |  | Electric | 150 | 20
 | Mortgage | 1700 | 2020-08-01 00:00:00
 | Credit Card | 150 | 2020-08-01 00:00:00
 | Gas | 75 | 2020-08-15 00:00:00
 | Electric | 150 | 2020-08-20 00:00:00
 |  |  |  |  |  |  | Total Due
Spreadsheet: 885249d1734693117-need-help-with-production-planning-spreadsheet-test-automatic-productionplanning
Sheet: Productieplanning

Day | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | thuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Date | 2024-12-16 00:00:00 | 2024-12-17 00:00:00 | 2024-12-18 00:00:00 | 2024-12-19 00:00:00 | 2024-12-20 00:00:00 | 2024-12-21 00:00:00 | 2024-12-22 00:00:00 | 2024-12-23 00:00:00 | 2024-12-24 00:00:00 | 2024-12-25 00:00:00 | 2024-12-26 00:00:00 | 2024-12-27 00:00:00 | 2024-12-28 00:00:00 | 2024-12-29 00:00:00 | 2024-12-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-01 00:00:00 | 2025-01-02 00:00:00 | 2025-01-03 00:00:00 | 2025-01-04 00:00:00 | 2025-01-05 00:00:00 | 2025-01-06 00:00:00 | 2025-01-07 00:00:00 | 2025-01-08 00:00:00 | 2025-01-09 00:00:00 | 2025-01-10 00:00:00 | 2025-01-11 00:00:00 | 2025-01-12 00:00:00 | 2025-01-13 00:00:00 | 2025-01-14 00:00:00 | 2025-01-15 00:00:00 | 2025-01-16 00:00:00 | 2025-01-17 00:00:00 | 2025-01-18 00:00:00 | 2025-01-19 00:00:00 | 2025-01-20 00:00:00 | 2025-01-21 00:00:00 | 2025-01-22 00:00:00 | 2025-01-23 00:00:00 | 2025-01-24 00:00:00 | 2025-01-25 00:00:00 | 2025-01-26 00:00:00 | 2025-01-27 00:00:00 | 2025-01-28 00:00:00 | 2025-01-29 00:00:00 | 2025-01-30 00:00:00 | 2025-01-31 00:00:00 | 2025-02-01 00:00:00 | 2025-02-02 00:00:00 | 2025-02-03 00:00:00 | 2025-02-04 00:00:00 | 2025-02-05 00:00:00 | 2025-02-06 00:00:00 | 2025-02-07 00:00:00 | 2025-02-08 00:00:00 | 2025-02-09 00:00:00 | 2025-02-10 00:00:00 | 2025-02-11 00:00:00 | 2025-02-12 00:00:00 | 2025-02-13 00:00:00 | 2025-02-14 00:00:00 | 2025-02-15 00:00:00 | 2025-02-16 00:00:00
Day capacity | 9 | 8 | 7 | 7 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 7 | 0 | 0 | 9 | 0 | 0 | 0 | 8 | 0 | 0 | 9 | 9 | 4 | 0 | 0 | 0 | 0 | 9 | 9 | 4 | 0 | 0 | 0 | 0 | 9 | 9 | 5 | 0 | 0 | 0 | 0 | 9 | 9 | 5 | 0 | 0 | 0 | 0 | 9 | 9 | 6 | 0 | 0 | 0 | 0 | 9 | 9 | 5 | 0 | 0 | 0 | 0
product 1
product 2
product 3
# of product 1
# of product 2
# of product 3
Spreadsheet: 69472d1270013913-need-help-about-pivot-table-and-pivot-chart-source-data
Sheet: Scholarship

Scholarship Code | Scholarship Name | Major Required | Amount Granted per Year | Duration (Year)
UAS | University Achievement Scholarship | MKT | 6000 | 3
IECS | International Education Costs Scholarship | ACC | 4000 | 3
DLOTS | Dutch Lady Orange Tulip Scholarship | MGT | 16000 | 1
GAFS | [NAME] | FIN | 7500 | 2
NTS | Northcote Trust Scholarship | ACC | 8000 | 2
WLS | World Leadership Scholarship | MGT | 5000 | 3
CBS | Clare Burton Scholarship | MKT | 10000 | 2
JHCS | [NAME] CPEP Scholarship | BIS | 18000 | 1
EIS | Endeavour International scholarship | FIN | 12000 | 1
IDS | International Development Scholarship | ECON | 6000 | 3
NUS | Northcote University Scholarship | MGT | 10000 | 2
BTS | Broadcast Technology Scholarship | BIS | 9000 | 2
RTS | Rotary Training Scholarship | STAT | 7000 | 3
PAS | Power Academy Scholarship | BIS | 5000 | 3
NGS | National Government Scholarship | ACC | 9500 | 3
TOS | Training Overseas Scholarship | MKT | 11000 | 2
GUES | Global Undergraduate Exchange Scholarship | BIS | 7000 | 3
WMS | Wide MOET Scholarship | ECON | 9000 | 2
IAS | Irish AID Scholarship | MGT | 6000 | 3
CHS | Chevening High Scholarship | STAT | 12000 | 3
Spreadsheet: 871281d1717670089-help-with-lookup-functions-lookup
Sheet: Sheet1

[NAME]
 | part1 | part2 | part4 | part5 | part6 | part7 | part3
dim3 | 2 | 5 | 3 | 5 | 4 | 8 | 2
dim2 | 2 | 8 | 8 | 5 | 4 | 2 | 9
dim1 | 5 | 6 | 8 | 9 | 6 | 2 | 2
dim4 | 5 | 7 | 6 | 8 | 5 | 1 | 1
DATA2
 | part3 | part7 | part1 | part2 | part5 | part4 | part6
dim4 | 2 | 2 | 5 | 5 | 4 | 8 | 2
dim2 | 5 | 8 | 6 | 7 | 4 | 2 | 7
dim1 | 3 | 8 | 8 | 6 | 6 | 2 | 6
dim3 | 5 | 5 | 9 | 8 | 5 | 1 | 2
DIFF
 | part1 | part2 | part3 | part4 | part5 | part5 | part6
dim1
dim2
dim3
dim4
Spreadsheet: 92062d1291737417-url-link-from-one-sheet-to-another-test-sheet
Sheet: Data From Deviation Sheet

820016 |  | 1234567890 | 000E5C05F23E | 1234 ORCHID RD | cable-upstream 2/3.0 | -0.76 | 45.4 | 1.13 | 0.37 | 4.8 | 1.2
820016 |  | 1234567890 | 000CE5EE6A36 | 1234 FRANKO ST | cable-upstream 4/5.0 | -10.47 | 48.72 | 0.07 | 0.49 | 0.3 | 1.7
820016 |  | 1234567890 | 001692FD2C40 | 1234 PIN CHERRY ST | Cable6/0/2-upstream0 | -4.25 | 46.5 | 0.43 | 0.56 | 1.8 | 1.5
820016 | 820016B26 | 1234567890 | 891002703240 | 1234 ANTHONY CT | Cable6/0/2-upstream0 | -7.09 | 56.71 | 0.54 | 3.23 | 1.9 | 11
820016 | 820016B25 | 1234567890 | 5CEBME39W052704 | 2345 VINANTA ST | Cable6/0/2-upstream0 | -1.13 | 50.96 | 0.36 | 0.35 | 1.5 | 2
820016 | 820016B25 | 1234567890 | 0014E82E7AF2 | 2345 VINANTA ST | Cable6/0/2-upstream0 | -2.51 | 47.88 | 0.22 | 0.59 | 0.8 | 2.5
820016 | 820016B24 | 1234567890 | 209254824 | 2345 PIN CHERRY ST | Cable6/0/2-upstream0 | -3.99 | 45.69 | 0.66 | 1.51 | 2.9 | 5
820016 |  | 1234567890 | 918BNE8AJ429779 | 2345 KINGSTREE ST | Cable6/0/2-upstream0 | -5.41 | 50.96 | 0.46 | 0.54 | 1.9 | 2
820016 |  | 1234567890 | 218358588 | 2345 PIN CHERRY ST | Cable6/0/2-upstream0 | -1.51 | 44.9 | 0.46 | 1.96 | 1.7 | 7.5
Spreadsheet: 33374d1229674208-row-value-concatination-for-matching-rows-of-another-column-stringconcat
Sheet: Sheet2

File | Screen
US1 | INV1 | US1 | INV1, [NAME], A2, R3, AC
US2 | INV1 | US2 | INV1, D1, R1, R2, A5
US3 | LU1 | US3 | [NAME], LU2, [NAME], A4
US3 | LU2
US1 | A1
US1 | A2
US3 | A3
US2 | D1
US2 | R1
US2 | R2
US1 | R3
US3 | A4
US2 | A5
US1 | AC
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -2143 | -1613 | -799 | -2000
2 | -2506 | -1613 | -2650 | -2000
3 | -2108 | -1613 | -2614 | -2000
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
index
2001-12-31 00:00:00 |  |  |  |  | -133109.25
2002-01-03 00:00:00
CBS Volume
 |  |  | -40794
Spreadsheet: 730190d1619601276-index-match-from-bottom-up-with-multi-criteria-bottomupmulti
Sheet: Register

Name | Country | score |  |  |  |  |  |  | hoped result
ALAN | USA | 6 |  |  |  | ALAN | USA |  | 10
ALAN | USA | 9 |  |  |  | CATHY | BRASIL
ALAN | USA | 10 |  |  |  | DANIEL | UK
BOB | UK | 5 |  |  |  | FRANK | DENMARK |  | 22
BOB | UK | 6 |  |  |  | [NAME] | CHINA |  | 9
CATHY | CANADA | 6
CATHY | BRASIL | 3
CATHY | BRASIL
DANIEL | DENMARK | 3
DANIEL | UK
DANIEL | UK
EDGAR | EGYPT | 37
FRANK | FINLAND | 7
FRANK | DENMARK | 22
[NAME] | CHINA | 5
[NAME] | CHINA
[NAME] | CHINA | 9
[NAME] | UGANDA | 7
HARRY | HUNGARY | 10
Spreadsheet: phillip_m_love__30158__OntFRED
Sheet: Recon Variances

DESK | TAGG | [NAME] | VLookupGL | [NAME] | Abs | Desk Adjustment | GL Adjustment/Reclass | Comments
Ontario | NR3878.2 | 0 | -0.031 | -0.031 | 0.031 |  |  | Immaterial; under $100 |  | True | False
Ontario | NS6767.1 | 0 | -11624.845 | -11624.845 | 11624.845 |  |  | In Ontario GL, Sithe FL, change mapping |  | True | True
Ontario | NS2550.1 | 0 | -27899.876 | -27899.876 | 27899.876 |  |  | In Ontario GL, Sithe FL, change mapping |  | True | True
Ontario | NI0331.2 | 0 | -34100 | -34100 | 34100 |  |  | In GL not FL, Economics to look at |  | False | False
Ontario | NS9352.1 | 0 | 74622.7049 | 74622.7049 | 74622.7049 |  |  | In GL not FL, Economics to look at |  | False | True
Ontario | NI0331.1 | 0 | 183953.97 | 183953.97 | 183953.97 |  |  | In GL not FL, Economics to look at |  | False | False
Ontario | EW4045.A | 0 | -330298.7715 | -330298.7715 | 330298.7715 |  |  | In GL not FL, Economics to look at |  | False | False