tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 57728d1257949374-embedding-a-sumif-in-an-hlookup-workbook1-ex
Sheet: Data Comes in Like this

Data Comes In Like This
 |  | Indicator 1 |  |  | Indicator 2 |  |  |  | Red
Site | Region | Kids | Men | Women | Kids | Men | Women |  | Blue
Site 1 | Red | 1 | 5 | 0 | 4 | 1 | 5 |  | Green
Site 2 | Red | 1 | 4 | 5 | 0 | 1 | 0
Site 3 | Blue | 5 | 0 | 3 | 1 | 2 | 4
Site 4 | Blue | 3 | 5 | 3 | 4 | 0 | 4
Site 5 | Blue | 3 | 1 | 4 | 1 | 2 | 2
Site 6 | Blue | 4 | 0 | 0 | 2 | 1 | 2
Site 7 | Green | 4 | 5 | 2 | 2 | 5 | 3
Site 8 | Green | 0 | 2 | 0 | 2 | 2 | 1
Site 9 | Green | 3 | 0 | 3 | 5 | 2 | 2
Site 10 | Green | 4 | 1 | 0 | 3 | 3 | 3
I want to summarize it on another worksheet Like This
Choose Region | Red
 | Kids | Men | Women | Total
Indicator 1
Indicator 2 |  |  |  |  |  | In here, I want the values from the above table that represents the sum of the Region chosen
Spreadsheet: kate_symes__18825__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-09 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624 | 282.12 | 2609 | 247.42 | 748
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 |  |  |  |  |  | ..
Spreadsheet: 539678d1506331968-help-with-a-sum-ifs-index-match-function-please-example
Sheet: current data format

Customer number | Product code | Date | Net sales
2001 | 1 | 2011-07-01 00:00:00 | 50 |  | Sum of Net sales | Column Labels
2001 | 2 | 2011-07-01 00:00:00 | 65 |  | Row Labels | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | Grand Total
2001 | 3 | 2011-08-01 00:00:00 | 71 |  | 2001 | 115 | 71 | 53 |  |  | 239
2001 | 4 | 2011-09-01 00:00:00 | 53 |  | 2002 | 43 |  |  | 45 | 23 | 111
2002 | 1 | 2011-11-01 00:00:00 | 45 |  | 2003 |  | 12 |  |  |  | 12
2002 | 2 | 2011-12-01 00:00:00 | 23 |  | 2004 | 42 |  | 155 |  |  | 197
2002 | 3 | 2011-07-01 00:00:00 | 43 |  | Grand Total | 200 | 83 | 208 | 45 | 23 | 559
2003 | 1 | 2011-08-01 00:00:00 | 12
2004 | 1 | 2011-09-01 00:00:00 | 67
2004 | 2 | 2011-07-01 00:00:00 | 42
2004 | 3 | 2011-09-01 00:00:00 | 56
2004 | 2 | 2011-09-01 00:00:00 | 32
Spreadsheet: 695000d1599944292-formular-for-minus-automatic-david111
Sheet: Sheet1

 | INCOME |  |  |  |  | EXPENDITURE
 | NO | TAREHE | MAELEZO | CASH | BANK | TAREHE | MAELEZO | KIASI | SALIO
 |  |  | A | 1000 | 2000 |  | B | 100
 |  |  |  | 4000 | 1000 |  |  | 2000
 |  |  |  | 2000 |  |  |  | 1000
 |  |  |  | 5000 |  |  |  | 6000
 |  |  |  | 70000 |  |  |  | 9000
 |  |  |  | 90000 | 4000 |  |  | 12000
 |  |  |  | 40000 |  |  |  | 7000
 |  |  |  | 80000 |  |  |  | 5000
Spreadsheet: 114869d1310564173-data-analysis-algorithm-24-segment-lengths
Sheet: Sheet1

x | y | change rows | 24 [NAME] |  | [3,4,2]
0.1 | 0 |  | 3 | 3,
0.2 | 0 |  | 4 | 3,4,
0.3 | 0 |  | 2 | 3,4,2
0.4 | 24 | 5
0.5 | 24
0.6 | 24
0.7 | 0 | 8
0.8 | 0
0.9 | 0
1 | 24 | 11
1.1 | 24
1.2 | 24
1.3 | 24
1.4 | 0 | 15
1.5 | 0
1.6 | 0
1.7 | 0
1.8 | 24 | 19
1.9 | 24
2 | 0 | 21
Spreadsheet: 102076d1300129060-counting-occurrences-only-once-in-a-list-of-duplicates-basing-the-range-off-of-a-date-example
Sheet: Shipping and Invoice

 |  |  |  |  |  |  |  |  | Date |  | Value
 |  |  |  |  |  |  |  |  | 1110104 |  | 111
 |  |  |  |  |  |  |  |  | 1110104 |  | 111
 |  |  |  |  |  |  |  |  | 1110104 |  | 123
 |  |  |  |  |  |  |  |  | 1110104 |  | 234
 |  |  |  |  |  |  |  |  | 1110104 |  | 234
 |  |  |  |  |  |  |  |  | 1110104 |  | 234
 |  |  |  |  |  |  |  |  | 1110104 |  | 555
 |  |  |  |  |  |  |  |  | 1110208 |  | 444
 |  |  |  |  |  |  |  |  | 1110208 |  | 677
 |  |  |  |  |  |  |  |  | 1110208 |  | 677
 |  |  |  |  |  |  |  |  | 1110208 |  | 677
 |  |  |  |  |  |  |  |  | 1110208 |  | 677
 |  |  |  |  |  |  |  |  | 1110208 |  | 677
 |  |  |  |  |  |  |  |  | 1110208 |  | 888
 |  |  |  |  |  |  |  |  | 1110208 |  | 999
 |  |  |  |  |  |  |  |  | 1110208 |  | 321
 |  |  |  |  |  |  |  |  | 1110303 |  | 432
 |  |  |  |  |  |  |  |  | 1110303 |  | 543
 |  |  |  |  |  |  |  |  | 1110303 |  | 654
 |  |  |  |  |  |  |  |  | 1110303 |  | 765
 |  |  |  |  |  |  |  |  | 1110303 |  | 876
 |  |  |  |  |  |  |  |  | 1110303 |  | 987
 |  |  |  |  |  |  |  |  | 1110303 |  | 998
 |  |  |  |  |  |  |  |  | 1110311 |  | 909
 |  |  |  |  |  |  |  |  | 1110311 |  | 808
 |  |  |  |  |  |  |  |  | 1110311 |  | 808
 |  |  |  |  |  |  |  |  | 1110311 |  | 808
Spreadsheet: 157152d1337631592-multiple-calculations-formula-products
Sheet: Products

 | Date | Product 01 |  | Product 02 |  | Product 03 |  | Product 04 |  | Product 05 |  | Product 06 |  | Product 07 |  | Product 08 |  | Product 09 |  | Product 10 |  | Product 11 |  | Product 12 |  | Product 13 |  | Product 14 |  | Product 15 |  | Product 16 |  | Product 17 |  | Product 18 |  | Product 19 |  | Product 20 |  | Product 21 |  | Product 22 |  | Product 23 |  | Product 24 |  | Product 25 |  | Product 26 |  | Product 27 |  | Product 28 |  | Product 29 |  | Product 30 |  | Product 31 |  | Product 32 |  | Product 33 |  | Product 34 |  | Product 35 |  | Product 36 |  | Product 37 |  | Product 38 |  | Product 39 |  | Product 40 |  | Product 41 |  | Product 42 |  | Product 43 |  | Product 44 |  | Product 45 |  | Product 46 |  | Product 47 |  | Product 48 |  | Product 49 |  | Product 50 |  | Product 51 |  | Product 52 |  | Product 53 |  | Product 54 |  | Product 55 |  | Product 56 |  | Product 57 |  | Product 58 |  | Product 59 |  | Product 60 |  | Product 61 |  | Product 62 |  | Product 63 |  | Product 64 |  | Product 65 |  | Product 66 |  | Product 67 |  | Product 68 |  | Product 69 |  |  | Total
 | 2012-05-06 00:00:00 | 73 | 1 | 50 | 1 | 2 | 1 |  |  |  |  |  |  | 8 | 1 | 4 | 1 |  |  |  |  |  |  |  |  | 15 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 1 |  |  | 2.5 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.3 | 3 | 14.3 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 14 | 2
 | 2012-05-07 00:00:00 | 75 | 1 |  |  |  |  |  |  |  |  | 23 | 1 | 6 | 1 | 4 | 1 |  |  | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 1 | 22 | 1 | 28 | 1 | 7 | 2 |  |  |  |  | 3.5 | 1 | 2.5 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.5 | 2 | 13.65 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 2 | 12 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2
 |  |  |  | [NAME] = (C3*D3)+(E3*F3)+……+(EI3*EJ3)
Spreadsheet: 52778d1252595818-linking-pivot-tables-to-one-another-example-1-
Sheet: Sheet2

[NAME] | (All) |  |  | [NAME] | (All)
Count of DATA6 |  |  |  | Count of DATA4
DATA2 | Total |  |  | DATA3 | Total
1 | 1 |  |  | 5 | 1
2 | 1 |  |  | 10 | 2
3 | 1 |  |  | 15 | 1
4 | 1 |  |  | (blank)
(blank) |  |  |  | Grand Total | 4
Grand Total | 4
Spreadsheet: 328523d1403934058-how-to-link-drop-down-list-to-table-groups-tracker-by-month
Sheet: Sheet2

Japan Foundation
Dikti Pendidik - Ratna
JICA Group (Edith)
SSQ Sandy
Dikti Pendidik
BMW Tour - POSCO
Taisho Group
JTA Group (Unitika Union)
Friedrich Stiftung Foundation
Herawati Santoso - LHK
[NAME]
Buckman Training Group
[NAME]
[NAME]
CARGILL
HM Sampoerna
[NAME]
Hands Seidel Foundation
Tupperware MC
[NAME] PT
Kajima - Yoshiko
SMI Travel
Ace Life Assurance
GPDI (Pantekosta Conference)
Indoaqua Culture
Indoaqua Culture - Dinas
Kemdikbud Paudni - Panitia
Kemdikbud Paudni - Luar Negri
Kemdikbud Paudni - Dalam Negri
[NAME]
IAAF - Youth Program
[NAME] (wedding)
BMW Tour Group 4
UDIEN REIS G-48/14
[NAME]
Travindo - Inbound China
SOKA GAKKAI Indonesia
Persi
IIEF - Online Booking (Allotment pls CXL)
CIFOR Indonesia (Allotment pls CXL)
Wedding Wicaksono & ESA
HK Electric
IAAF - CECS Level III Combined Event
Trilogy Music Indonesia
[NAME] Indonesia
Rama Tour Group
[NAME]
PP Muhammadiyah
UNEP - KLH
Spreadsheet: 376a0c9d-06f0-46e7-94b0-c8d4919ed73d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | 2012-2013 LINE UP CARD | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  | THIS COMPLETED FORM IS TO BE TURNED IN
 |  |  | TO THE REFEREE PRIOR TO THE MATCH
DATE OF GAME:________________________TIME OF GAME:________________SITE:_________________________
GENDER:____________________________AGE GROUP:__________________________________________________
TEAM NAME: ______________________________________________________________________________________
YOUR TEAM JERSEY COLOR:_______________________________________________________________________
OPPONENT FOR GAME:____________________________________________________________________________
 |  |  |  |  | List all Team Bench Personnel (Maximum of 4)
The following players are eligible to play in today's game. |  |  |  |  | Name |  | Position with team
 |  |  |  | 1
No. | LAST NAME, FIRST NAME |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  |  | If applicable…
 |  |  |  |  | The following players are on the Team Roster but are not one of the 18
 |  |  |  |  | players eligible to play in today's game
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | I hereby certify that the players listed are properly registered with US Youth
 |  |  |  | Soccer and are eligible to play per NL Rules.
 |  |  |  | Signature of Team Coach or Manager
 |  |  |  | Print Name of Team Coach or Manager
Referee's Signature:__________________________________________Print Name:_______________________________________ Date:________________
Spreadsheet: 707855d1607511696-vlookup-with-match-reference-question
Sheet: Sheet1

Sum of Rate your app experience | Column Labels |  |  |  |  |  |  | App Experience | Zoom | Teams | WebEx
Row Labels | Zoom | Teams | WebEx | Competitor 1 | (blank) | Grand Total |  | 1
1 |  | 1 |  |  |  | 1 |  | 2
3 | 3 |  | 3 | 3 |  | 9 |  | 3
4 | 72 |  | 48 | 8 |  | 128 |  | 4
5 | 80 | 65 | 5 | 65 |  | 215 |  | 5
(blank)
Grand Total | 155 | 66 | 56 | 76 |  | 353
Spreadsheet: 859580d1707917849-grand-total-should-not-exceed-from-cell-value-book1
Sheet: DANISH BHAI

 |  |  |  | MIN | MAX | MIN | MAX
 |  |  |  | 39500 | 45500 | 1 | 5
 |  | AHATRAM | 3505000
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-01 00:00:00
 |  | 2024-02-02 00:00:00
 |  | 2024-02-03 00:00:00
 |  | 2024-02-04 00:00:00
 |  | 2024-02-05 00:00:00
 |  | 2024-02-06 00:00:00
 |  | 2024-02-07 00:00:00
 |  | 2024-02-08 00:00:00
 |  | 2024-02-09 00:00:00
Spreadsheet: 31328d1227129444-formula-between-worksheets-example-spreadsheet-cm-updated
Sheet: Sheet2

0.00125 | 0.00125 | 0.0012 | 0.00101 | 0.0006100000000000001 | 0.0005 | 0.0004800000000000001
0.00125 | 0.00125 | 0.0012 | 0.00101 | 0.0006100000000000001 | 0.0005 | 0.0004800000000000001
0.00136 | 0.00136 | 0.00128 | 0.00111 | 0.0007 | 0.00055 | 0.0005200000000000001
0.00141 | 0.00141 | 0.00141 | 0.00118 | 0.00072 | 0.00058 | 0.00055
0.00145 | 0.00145 | 0.00145 | 0.00122 | 0.00084 | 0.0006100000000000001 | 0.0005700000000000001
Spreadsheet: 719822d1613838674-copy-paste-a-dynamic-sheet-cell-formula-using-indirect-cell-not-incrementing-indirect_error
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Fred
 |  |  |  |  |  |  |  |  |  |  |  | Fred
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Fred
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | DropDown
 | [NAME]
 | Fred
Spreadsheet: 680479d1591041000-assessment-report-result-formulas-measures-assessment
Sheet: Result_Document Review

Audit Report
Audited Store: |  | from: |  |  |  | to:
Scope of audit:
Store contact person:
Store Profile:  [# stores, type certifications, in-store processing]
Audit Conclusion
Best practice | > 92
Good performance | 91.9 - 84%
Acceptable | 83.9 - 76%
Need improv. | < 76%
Detailed Assessment Report: Overview Scoring SHSHS in %
Chapters | Dry and [NAME] | Meat General | Hyg. [NAME] | Meat | Fish &SF | Meat Processing | Bakery General | Bakery Processing | Fruits and Vegetables | Delivery
Achieved  score in % Store Inspections
Achieved  score in % Store Documentation | No Applicable
No. of applicable requirements
Total  No. of points ( for applicable req)
Total No. of achieved points
Detailed Score | req. evaluation | req. evaluation | req. evaluation | req. evaluation | req. evaluation | req. evaluation
3
2
1
Chapters | Achieved  score in % Document Review
HACCP
Construction and Facility Management
Human Resources
Personal Hygiene / Infection Control and Protective Clothing
Cleaning and Sanitation
Pest Control
Calibration
Foreign Bodies Control
Product Return Withdrawal and Recall
Meat General
Meat Processing
Fish and Seafood
Cheese, [NAME], [NAME], Eggs General
Cheese, [NAME], [NAME], Eggs Processing
Bakery General
Bakery Processing
Fruits and Vegetables
Delivery
Spreadsheet: 786248d1657064357-using-index-match-to-populate-a-table-based-of-drop-down-list-in-a-given-cell-populate_state_data-3-test1
Sheet: Search

 | Select State | -
Organization | Address | City | State | Zip code
Spreadsheet: 42970d1241593362-sum-across-multiple-sheets-demo2
Sheet: 31

 | Estimated | No.Sold | Free | Remarks
Apple | 26 | 12 | 5
Green | 15 | 12 | 6 | Free
Kashmiur | 17 | 15 | 7
Grape | 19 | 30 | 10
 |  |  | 4
 |  |  | 4
 |  |  | 4
[NAME] | 28 | 19 | 9
Pine Apple | 28 | 20 | 8
Kiwi | 30 | 17 | 13
Spreadsheet: 168486d1342471093-sumif-formula-for-months-sumif-sample-oeldere-
Sheet: Sheet1

 | Estimated Date of PI Receipt | Total Estimated PI | month |  | Rijlabels | Som van Total Estimated PI
 | 2012-06-30 00:00:00 | 50 | 6 |  | 1 | 0
 | 2012-06-30 00:00:00 | 100 | 6 |  | 6 | 200
 | 2012-07-30 00:00:00 | 2 | 7 |  | 7 | 8
 | 2012-08-23 00:00:00 | 2 | 8 |  | 8 | 6
 | 2012-06-30 00:00:00 | 50 | 6 |  | 9 | 8
 |  |  | 1 |  | 10 | 12
 |  | Estimated PI | 1 |  | 11 | 4
 | 2012-06-01 00:00:00 | 0 | 6 |  | 12 | 16
 | 2012-07-01 00:00:00 | 6 | 7 |  | Eindtotaal | 254
 | 2012-08-01 00:00:00 | 4 | 8
 | 2012-09-01 00:00:00 | 8 | 9
 | 2012-10-01 00:00:00 | 12 | 10
 | 2012-11-01 00:00:00 | 4 | 11
 | 2012-12-01 00:00:00 | 16 | 12
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: Subcontractor Variations

 |  |  |  |  |  |  |  | RPC Electrical
 |  |  |  |  |  | Subcontractor Finacial Report
 |  | Site Address |  |  |  |  | Subcontractor [NAME]
 |  |  |  |  |  | Variation Account
 |  |  |  |  |  | Sub Total
 |  |  |  |  |  | Less Paid to Date
 |  |  |  |  |  | Adjusted Total
 |  |  |  |  |  | Less Retention
 |  | Variation Account - |  |  |  | Remaing to Pay Total
 |  | Note: Items with no values are yet to be formally instructed.
 |  | Description of variation |  |  |  |  |  | Value £/p
 |  | Item | Description |  | Qty | Unit | Rate | Extension
 |  | 1.01 |  | testing values | 1 | nr | 1.32 | 132
 |  | 2.02 |  | Electrical works | 10 | nr | 2.4 | 2400
Spreadsheet: 167903d1342151039-rounding-up-problems-2012-2-kimbap-hoping
Sheet: Student info

 | Class number | é | 1 |  |  | Student Information |  |  |  |  |  |  |  |  |  |  |  |  |  | ✂                                       ✂
 |  |  |  | No. |  | 학부 (Dept) | 학년 (Year) | 학번 (I.D.) | 이름 (name) | 소속학과 (?) | E-Mail | 전화번호 | 수강상태 (?) |  | 학본                    (Student number) |  | English name
 |  |  |  |  |  |  |  |  | 닐 |  |  |  |  |  | 1 |  | a
 |  |  |  | 2 |  | 제약공학과 | 1 | sunshinekate | 김기화 | 제약공학과 | [EMAIL] | 010-6251-4110 | 수강중 |  | 2 |  | b
 |  |  |  | 3 |  | 영어학과 | 3 | nornor1027 | 김성엽 | 영어학과 | [EMAIL] | 010-7553-6223 | 수강중 |  | 3 |  | c
 |  |  |  | 4 |  | 시각디자인학과 | 1 | ksy931203 | 김수연 | 시각디자인학과 | [EMAIL] | 010-6412-2065 | 수강중 |  | 4 |  | d
 |  |  |  | 5 |  | 신소재공학과 | 1 | asdfyo | 김영훈 | 신소재공학과 | [EMAIL] | 010-8996-9320 | 수강중 |  | 5 |  | e
 |  |  |  | 6
 |  |  |  | 7 |  | 신소재공학과 | 1 | ktm1397 | 김태민 | 신소재공학과 | [EMAIL] | 010-3364-6763 | 수강중 |  |  |  | g
 |  |  |  | 8 |  | 기초과학부 | 1 | rampb78 | 박은민 | 기초과학부 | [EMAIL] | 010-3179-4278 | 수강중 |  |  |  | h
 |  |  |  | 9 |  | 제약공학과 | 1 | jihye1415 | 박지혜 | 제약공학과 | [EMAIL] | 010-4613-7021 | 수강중 |  |  |  | i
 |  |  |  | 10 |  | 제약공학과 | 1 | dnlwogml93 | 위재희 | 제약공학과 | [EMAIL] | 010-3606-7583 | 수강중 |  |  |  | j
 |  |  |  | 11 |  | 시각디자인학과 | 1 | thdus314 | [NAME] | 시각디자인학과 | [EMAIL] | 010-3008-5061 | 수강중 |  |  |  | k
 |  |  |  | 12 |  | 제약공학과 | 1 | kain832 | 이우행 | 제약공학과 | [EMAIL] | 010-2997-9312 | 수강중 |  |  |  | l
 |  |  |  | 13 |  | 중어중국학과 | 1 | joobe0123 | 이주엽 | 중어중국학과 | [EMAIL] | 010-4506-8272 | 수강중 |  |  |  | m
 |  |  |  | 14 |  | 시각디자인학과 | 1 | ekrcy99 | 최민지 | 시각디자인학과 | [EMAIL] | 010-3944-5117 | 수강중 |  |  |  | n
 |  |  |  | 15 |  | 역사학과 | 1 | [NAME] | 최서영 | 역사학과 | [EMAIL] | 010-5434-9022 | 수강중 |  |  |  | o
 |  |  |  | 16 |  | 사회복지학과 | 1 | cic2093 | 최소은 | 사회복지학과 | [EMAIL] | 010-8211-2093 | 수강중 |  |  |  | p
 |  |  |  | 17 |  | 간호학과 | 1 | [NAME] | 최원진 | 간호학과 | [EMAIL] | 010-7659-3007 | 수강중 |  |  |  | q
 |  |  |  | 18 |  | 시각디자인학과 | 1 | houng1993 | 홍주리 | 시각디자인학과 | [EMAIL] | 010-8879-0281 | 수강중 |  |  |  | r
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  |  |  | é | é | é | é | é | é | é | é |  | é |  | é
 |  | é |  |  |  | to get this information: |  |  |  |  |  |  |  |  | to get this information: |  | Type in manually
 |  | é
 |  | é |  |  |  | 1. lms.sunmoon.ac.kr |  |  |  |  |  |  |  |  | 1.  lms.sunmoon.ac.kr
 |  | é |  |  |  | 2. Choose a class number then 수강생관리 (11th menu option) |  |  |  |  |  |  |  |  | 2. to be completed
 |  | é |  |  |  | 3. 엑셀다운 |  |  |  |  |  |  |  |  | 3
 |  | é |  |  |  | 4. Copy and paste ('values' only) |  |  |  |  |  |  |  |  | 4
 |  | é
 | Check the online attendance webpage to see who has unregistered.  Remove their data from this worksheet (do not delete the row). Otherwise, the averages in the Final Grades and Averages worksheets will be incorrect.  Please also remove test, participation, and homework scores.   However, make sure there are at least 10 "1's" on the attendance worksheet to take the score down to "0".
Spreadsheet: 681848d1591787490-separate-mobile-number-in-another-cell-book1
Sheet: Sheet1

CODE | NAME & ADDRESS | NEED MOBILE NUMBER |  |  | OFFICE ADDRESS | NEED MOBILE NUMBER
37021/9 | [NAME],PANAGADI ROAD,,MOOVENDAR SCHOOL(NEAR),SIVAGANGAI,0,[PHONE] |  | [NAME] | 4 | OWNER OF TATA AC, OMNI CAR,FARMER,,0, 0 |  |  |  |  | 1
37021/9 | MRSAMAYAMUTHU V,7/B LAJAPATHI RAY STREET,,SIVAGANGAI,,630561, 0 |  | [NAME] | 2 | [NAME],SIVAGANGAI,0, 0,[PHONE] |  |  |  |  | 1
37021/9 | MRRAVICHANDRAN N,ALLOOR,,BANGADI(PO),NATTARASANKOTTAI,SIVAGANGAI,0, 0 |  | MRRAVICHANDRAN N | 2 | CONDUCTOR,,TNSTC,DEVAKOTTAI,0, 0 |  |  |  |  | 1
37021/10 | MRSUTHAKARAN S,38C SURABHI APARTMENTS,,NEW DANIEL,[NAME] |  | MRSUTHAKARAN S | 4 | CHIT LIEN,53019/31,,0, 0 |  |  |  |  | 1
Spreadsheet: darrell_schoolcraft__7261__saledoc02_16aTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-02-15 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/16/02-02/19/02 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.05
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/16/2002 | 2002-02-19 00:00:00 | 20000 |  | 5000 |  | 5000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 5000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date: