tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 215103d1361266807-sumif-not-working-staff-requirements
Sheet: Machine 1

 | Staff [NAME] by Job |  |  |  |  |  |  |  |  | 2013-02-18 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-02-19 00:00:00
Machine: | 1 - RV53B |  |  |  |  |  |  |  |  | 2013-02-20 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-02-21 00:00:00
Start Date: |  |  |  |  |  |  |  |  |  | 2013-02-22 00:00:00
End Date: |  |  |  |  |  |  |  |  |  | 2013-02-23 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-02-24 00:00:00
Tool | Day | Start Date | Staff Required | End Date |  |  |  |  |  | 2013-02-25 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-02-26 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-02-27 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-02 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-03 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-04 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-05 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-06 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-07 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-08 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  |  |  |  | 2013-03-10 00:00:00
Spreadsheet: 1e134802-2e8a-4680-889d-a4147abdf2eb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7848 | 57063 | Ingrid | Tempert | NED | 202 | 00:23:52 | 00:02:07 | 01:20:19 | [NAME] | 00:44:22 | 1 | 02:32:28
7848 | 60851 | Miranda | Broks | NED | 180 | 00:21:54 | 00:02:09 | 01:34:03 | 00:01:40 | 00:53:20 | 2 | 02:53:04
7848 | 58883 | [NAME] | Schuurkamp | NED | 181 | 00:18:07 | 00:02:07 | 01:41:09 | 00:01:23 | 00:54:14 | 3 | 02:57:00
Spreadsheet: 778272d1650968062-allocating-where-the-total-available-is-less-than-the-total-needed-allocation-by-ranking-with-under-supply
Sheet: Sheet1 (3)

RANK ALLOCATION
1 | 0.8
2 | 0.5
3 | 0.2
ORDER |  |  |  |  |  |  |  |  |  | ALLOCATION
 | CUST RANK |  | 1 | 3 | 2 | 2 | 3 | 1
AVAIL STOCK | CUST TOTAL | Minimum | CUST1 | CUST2 | CUST3 | CUST4 | CUST5 | CUST6 |  |  |  |  |  |  |  |  |  |  |  | TOTAL ALLOCATION | STOCK REMAINING |  |  |  |  |  |  |  |  | Alloc-more |  |  |  |  |  |  |  |  | TOTAL ALLOCATION | STOCK REMAINING
20 |  |  | 10 | 5 | 2 | 10 | 5 | 1
80 |  |  | 20 | 10 | 5 | 20 | 10 | 2
50 |  |  | 20 | 10 | 5 | 20 | 20 | 2
35 |  |  | 10 | 5 | 2 | 20 | 10 | 1
10 |  |  | 10 | 5 | 2 | 10 | 5 | 1
Spreadsheet: 786618d1657303770-how-to-add-month-by-month-to-get-ytd-using-getpivotdata-in-google-sheet-2022-07-08-oeldere-johnyam54-how-to-sum-vlookup
Sheet: Oeldere

 | Current formular
Direct Cost 1 | cost centres | 202104 | 202105 | 202106 | 202107 | 202108 | 202109 | 202110 | 202111 | 202112 | 202201 | 202202 | 202203 | SUM of TOTAL
Direct Cost 1 | Product 1 | 8571 | 9221 | 9541 | 4626 | 6726 | 5564 | 4378 | 5478 | 2869 | 8168 | 4108 | 6362
Direct Cost 1 | Product 2 | 8967 | 6031 | 8099 | 3025 | 4125 | 6815 | 6750 | 2605 | 5762 | 8093 | 7911 | 9626
Direct Cost 1 | Product 3 | 6514 | 5936 | 5680 | 8987 | 8266 | 6823 | 9391 | 8028 | 4672 | 3982 | 8039 | 4318
Direct Cost 1 | Product 4 | 4072 | 8040 | 7331 | 8748 | 9476 | 7030 | 7669 | 4775 | 3316 | 7485 | 5264 | 7264
Direct Cost 1 | Product 5 | 6158 | 5015 | 3579 | 3306 | 8319 | 9361 | 4328 | 3251 | 8589 | 4009 | 9034 | 8755
Direct Cost 1 | Product 6 | 9165 | 5076 | 2808 | 9358 | 7173 | 4212 | 4056 | 6976 | 9119 | 7006 | 7793 | 9104
Direct Cost 1 | Product 7 | 8460 | 2758 | 4428 | 3933 | 5784 | 2881 | 5145 | 8767 | 6491 | 3142 | 3513 | 7790
Indirect Costs 1 | Product 1 | 5607 | 6761 | 7086 | 6513 | 7875 | 7267 | 5056 | 7114 | 5806 | 5019 | 5832 | 7142
Indirect Costs 1 | Product 2 | 5171 | 6375 | 6528 | 6129 | 5855 | 7280 | 5735 | 7220 | 8277 | 7626 | 5878 | 5942
Indirect Costs 1 | Product 3 | 6108 | 7199 | 8394 | 5048 | 5656 | 5925 | 6734 | 5101 | 6990 | 7442 | 7880 | 7722
Indirect Costs 1 | Product 4 | 7978 | 6698 | 6884 | 7211 | 5184 | 5013 | 6663 | 6087 | 7851 | 7781 | 8286 | 8286
Indirect Costs 1 | Product 5 | 6662 | 6286 | 7185 | 5063 | 7132 | 6676 | 6613 | 5982 | 7676 | 6161 | 7898 | 5929
Indirect Costs | Product 1 | 3403 | 3125 | 4643 | 3366 | 4892 | 4814 | 5508 | 4936 | 4036 | 4075 | 3100 | 4552
Indirect Costs | Product 2 | 4611 | 3659 | 5569 | 3353 | 4895 | 5035 | 3395 | 3926 | 5174 | 3147 | 4497 | 3526
Indirect Costs | Product 3 | 3812 | 5499 | 5302 | 3304 | 3312 | 5563 | 5444 | 4960 | 4629 | 5181 | 3799 | 5226
Indirect Costs | Product 4 | 5448 | 5275 | 4479 | 3205 | 4816 | 4563 | 5391 | 3487 | 4899 | 4502 | 5460 | 3556
Indirect Costs | Product 5 | 3801 | 3664 | 5105 | 3481 | 3468 | 4703 | 5027 | 3976 | 3826 | 4981 | 3217 | 4745
Spreadsheet: 36e800f9-d17a-4454-b463-0374ab089a74
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2013 | 6696 | [NAME] | Näsvik | SWE |  | 01:03:21 | 00:00:00 | 03:26:03 | 00:00:00 | 02:17:05 | 1 | 06:46:30
2013 | 6615 | Marcus | Lindqvist | FIN |  | 01:26:21 | 00:00:00 | 03:43:02 | 00:00:00 | 02:43:25 | 2 | 07:52:49
2013 | 6617 | [NAME] | Malmstrom | SWE |  | 01:21:19 | 00:00:00 | 04:09:01 | 00:00:00 | 00:00:00 | DNF | 00:00:00
2013 | 6616 | [NAME] | Treadaway | GBR |  | 00:58:10 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
2013 | 6664 | Per | Dicander | SWE |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
2013 | 6685 | [NAME] | Darley | GBR |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 866331d1713281226-consolidating-reults-in-summary-sheet-summary
Sheet: Summary Sheet

Ticket Numbers | 2024-04-15 00:00:00 | 2024-04-14 00:00:00 | 2024-04-13 00:00:00 | 2024-04-12 00:00:00
Ticket 1
Ticket 2
Ticket 3
Ticket 4
Ticket 5
Ticket 6
Ticket 7
Ticket 8
Ticket 9
Spreadsheet: 179177d1347047900-inserting-words-from-a-predefined-set-randomly-random-text
Sheet: Sheet1

 |  | red
 |  | red
 |  | red
 |  | red
 |  | red
 |  | red
 |  | blue
 |  | blue
 |  | blue
 |  | blue
 |  | blue
 |  | blue
 |  | blue
 |  | blue
 |  | white
 |  | white
 |  | white
 |  | white
 |  | white
 |  | white
Spreadsheet: 32541d1228752515-if-statements-and-date-logic-sample-resource-model_hourly_view_2
Sheet: Sheet1

Name | Allocation | Start Date | End Date | 2008-12-01 00:00:00 | 2008-12-08 00:00:00 | 2008-12-15 00:00:00 | 2008-12-22 00:00:00 | 2008-12-29 00:00:00 | 2009-01-05 00:00:00 | 2009-01-12 00:00:00 | 2009-01-19 00:00:00 | 2009-01-26 00:00:00 | 2009-02-02 00:00:00 | 2009-02-09 00:00:00 | 2009-02-16 00:00:00 | 2009-02-23 00:00:00 | 2009-03-02 00:00:00 | 2009-03-09 00:00:00 | 2009-03-16 00:00:00 | 2009-03-23 00:00:00 | 2009-03-30 00:00:00 | 2009-04-06 00:00:00 | 2009-04-13 00:00:00 | 2009-04-20 00:00:00 | 2009-04-27 00:00:00 | 2009-05-04 00:00:00 | 2009-05-11 00:00:00 | 2009-05-18 00:00:00 | 2009-05-25 00:00:00 | 2009-06-01 00:00:00 | 2009-06-08 00:00:00 | 2009-06-15 00:00:00 | 2009-06-22 00:00:00 | 2009-06-29 00:00:00
AA | 0.8 | 2008-12-01 00:00:00 | 2009-02-25 00:00:00 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AA | 1 | 2008-12-01 00:00:00 | 2009-03-17 00:00:00 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AA | 0.5 | 2008-02-04 00:00:00 | 2009-04-15 00:00:00 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AA | 1 | 2008-12-01 00:00:00 | 2009-06-30 00:00:00 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5
AA | 0.75 | 2008-12-01 00:00:00 | 2009-06-18 00:00:00 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 0 | 0
AA | 1 | 2008-12-01 00:00:00 | 2008-12-31 00:00:00 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AA | 0.9 | 2009-01-12 00:00:00 | 2009-06-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 0 | 0 | 0
AA | 1 | 2009-01-12 00:00:00 | 2009-06-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5
Spreadsheet: 142217d1329740526-counting-unique-values-in-a-named-range-using-countif-activeclients
Sheet: Sheet1

JANUARY | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | FEBRUARY | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | [NAME] | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | APRIL | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | MAY | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | [NAME] | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | JULY | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | AUGUST | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | SEPTEMBER | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | OCTOBER | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | NOVEMBER | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE |  | DECEMBER | CLIENT ID | FIRST NAME | LAST NAME | DATE | BALANCE
 | 1 |  |  |  |  |  |  | 20
 | 2 |  |  |  |  |  |  | 21
 | 3 |  |  |  |  |  |  | 22
 | 4 |  |  |  |  |  |  | 23
 | 5 |  |  |  |  |  |  | 24
 | 6 |  |  |  |  |  |  | 25
 | 7 |  |  |  |  |  |  | 26
 | 8 |  |  |  |  |  |  | 1
 | 9 |  |  |  |  |  |  | 2
 | 1 |  |  |  |  |  |  | 3
 | 2 |  |  |  |  |  |  | 4
 | 3 |  |  |  |  |  |  | 5
 | 4
 | 5
TOTAL ACTIVE CLIENTS
Spreadsheet: 833372d1686922350-assign-day-to-time-sum-with-rollover-timetest-1-
Sheet: Times

Order | Time |  | 2023-06-19 00:00:00
1 | 0:28:20
2 | 0:28:20
3 | 0:56:40
4 | 0:39:00
5 | 6:55:00
6 | 2:11:40
7 | 1:06:42
8 | 0:37:39
9 | 0:26:21
10 | 4:08:20
11 | 0:21:00
12 | 0:49:30
13 | 0:48:20
14 | 3:01:40
15 | 0:39:28.800000
16 | 0:41:40
17 | 11:21:40
18 | 1:38:20
19 | 0:35:50
20 | 4:25:00
21 | 0:28:20
22 | 0:28:20
23 | 0:56:40
24 | 0:39:00
25 | 6:55:00
26 | 2:11:40
27 | 1:06:42
28 | 0:37:39
29 | 0:26:21
30 | 4:08:20
31 | 0:21:00
32 | 0:49:30
33 | 0:48:20
34 | 3:01:40
35 | 0:39:28.800000
36 | 0:41:40
37 | 11:21:40
38 | 1:38:20
39 | 0:35:50
40 | 4:25:00
Spreadsheet: 161855d1339660838-filling-empty-cells-with-value-of-previous-and-or-subsequent-cells-value-forumgi
Sheet: Sheet1

Company&Year | Value
CompanyA2003 | #N/A
CompanyB2003 | #N/A
CompanyC2003 | #N/A
CompanyA2004 | 9
CompanyB2004 | 6
CompanyC2004 | 8
CompanyA2005 | #N/A
CompanyB2005 | #N/A
CompanyC2005 | #N/A
CompanyA2006 | 10
CompanyB2006 | 4
CompanyC2006 | 6
Spreadsheet: 266469d1379620825-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-county-fips-codes
Sheet: WYOMING-49

 | COUNTY | CODE
 | Albany | 1
 | Big Horn
 | Campbell
 | Carbon
 | Converse
 | Crook
 | Fremont
 | Goshen
 | Hot Springs
 | [NAME]
 | Laramie
 | Lincoln
 | [NAME]
 | [NAME]
 | Park
 | Platte
 | [NAME]
 | Sublette
 | Sweetwater
 | Teton
 | Uinta
 | [NAME]
 | Weston
Spreadsheet: 875214d1721797846-sum-column-data-in-arrays-from-multiple-sheets-test-1-2-3-4-5-6-7-
Sheet: 1

151-26 | 150-66 | 150-74 | 153-11 | 150-19 | 153-14 | 152-16 | 153-20 | 153-19 | 152-14
589 | 21 | 175 | 791 | 273 | 369 | 252 | 789 | 917 | 802
967 | 2 | 14 | 758 | 781 | 490 | 44 | 539 | 789 | 189
634 | 371 | 825 | 131 | 917 | 805 | 103 | 2 | 184 | 691
949 | 686 | 757 | 655 | 196 | 474 | 36 | 426 | 136 | 425
690 | 759 | 567 | 880 | 161 | 221 | 347 | 888 | 134 | 343
656 | 156 | 853 | 74 | 254 | 119 | 32 | 758 | 802 | 745
713 | 240 | 584 | 117 | 282 | 392 | 174 | 9 | 263 | 158
451 | 379 | 174 | 380 | 162 | 96 | 709 | 597 | 157 | 879
257 | 332 | 338 | 570 | 513 | 843 | 287 | 71 | 946 | 337
668 | 464 | 330 | 111 | 716 | 301 | 759 | 793 | 311 | 988
864 | 961 | 652 | 924 | 590 | 215 | 68 | 919 | 873 | 744
686 | 503 | 216 | 909 | 227 | 866 | 259 | 148 | 683 | 40
184 | 60 | 593 | 637 | 399 | 928 | 576 | 616 | 53 | 769
261 | 571 | 342 | 406 | 77 | 992 | 198 | 553 | 875 | 710
75 | 385 | 938 | 172 | 167 | 638 | 932 | 48 | 768 | 883
379 | 905 | 925 | 398 | 54 | 272 | 228 | 563 | 146 | 196
32 | 922 | 669 | 180 | 42 | 764 | 829 | 451 | 765 | 188
609 | 457 | 349 | 905 | 905 | 533 | 561 | 130 | 327 | 685
598 | 496 | 667 | 145 | 131 | 954 | 530 | 945 | 393 | 201
56 | 589 | 624 | 791 | 929 | 415 | 163 | 338 | 336 | 919
260 | 932 | 897 | 375 | 403 | 967 | 731 | 676 | 644 | 137
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 2Inter O&M 1-10

Table 5.2.19.  Present Value of Intermittent Operations and [NAME] (Years 1-10)
 |  |  |  |  |  |  |  |  |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of O&M Costs for Year:
Component | Unit Cost | Unit | Quantity | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  | Total Present Value of Intermittent Operations & Maintenace Costs (Years 1-10):
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5212

5212 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 75572d1276114427-chart-annual-and-quarterly-book9
Sheet: Sheet1

[NAME]) | S&P | [NAME]
1992-03-01 00:00:00 | 403.69 | 2461249
1992-06-01 00:00:00 | 408.14 | 2461246
1992-09-01 00:00:00 | 417.8 | 2461249
1992-12-01 00:00:00 | 435.71 | 2461249
1993-03-01 00:00:00 | 451.67 | 2471305
1993-06-01 00:00:00 | 450.53 | 2471305
1993-09-01 00:00:00 | 458.93 | 2471305
1993-12-01 00:00:00 | 466.45 | 2471305
1994-03-01 00:00:00 | 445.77 | 2461216
1994-06-01 00:00:00 | 444.27 | 2461216
1994-09-01 00:00:00 | 462.71 | 2461216
1994-12-01 00:00:00 | 459.27 | 2461216
Spreadsheet: 165370d1341203411-summing-linked-cells-july-sched-ed
Sheet: PILOT COSTS (2)

SAIPAN-CHINA; CREW CHANGE 757
PILOT | POSITION | OT 26-70 | OT>70 | OT DAY | PAY | PERDIEM | TOTAL | TAFB
1
2
3
4
5
6
7
8
9
10
11
12
TOTAL CHINA CR CH
 |  |  |  |  |  |  |  |  |  | TOTAL OPS 757 AUG
 |  |  |  |  |  |  |  |  |  |  |  | COMPARISON- CREW CHANGE V. AUGMENTED 757
 |  |  |  |  |  |  |  |  |  |  |  |  | CH | AUG
 |  |  |  |  |  |  |  |  |  |  |  | OT 26-70
 |  |  |  |  |  |  |  |  |  |  |  | OT>70
 |  |  |  |  |  |  |  |  |  |  |  | OT DAY
 |  |  |  |  |  |  |  |  |  |  |  | PAY
 |  |  |  |  |  |  |  |  |  |  |  | PERDIEM
 |  |  |  |  |  |  |  |  |  |  |  | TOT CHvAUG
 |  |  |  |  |  |  |  |  |  |  |  | TOT OPS
 |  |  |  |  |  |  |  |  |  |  |  | DIFF
Spreadsheet: 676799d1588971698-extract-info-from-workbook-and-make-a-list-search-for-extra
Sheet: Food

 | Food |  |  |  |  |  |  | Catering |  |  |  |  |  |  | Rentals
 | Item | Comment | Amount | Price | Total |  |  | Item | Comment | Amount | Price | Total |  |  | Item | Comment | Amount | Price | Total
 | Coffee Day 1 |  | 34 | 12 |  |  |  | Lunch Day 1 |  | 45 | 50 |  |  |  | Tent Day 3 | Raining Extra: 100% | 1 | 100
 | Fruits Day 1 |  | 23 | 34 |  |  |  | Lunch Day 2 | Sponsor: 10% | 53 | 50
 | Coffee Day 2 | Extra: 100% | 54 | 12 |  |  |  | Lunch Day 3 |  | 46 | 50
 | Fruits Day 2 |  | 57 | 34
 | Coffee Day 3 |  | 8 | 12
 | Frutis Day 3 |  | 78 | 34
 | Drinks |  | 45 | 45
 | Snacks | Extra: 50% | 76 | 12
Spreadsheet: daren_farmer__6643__MarHourSurvey
Sheet: Hours

 | 2675
 | Senior Specialist
RC | Position | Activity Name | Last Month | Hours
2675 | Senior Specialist | [NAME] of Docs/Reg&Audit | 0
2675 | Senior Specialist | Customer Service | 10
2675 | Senior Specialist | P-4 Project | 0
2675 | Senior Specialist | Regulatory Reporting | 142
Spreadsheet: sally_beck__33776__Headcount Addition Form0900
Sheet: Headcount Addition

Energy Operations - 2000 Budget
Increase in Headcount Justification Form
Complete only highlighted sections
Company No. | 413
RC No. | 105594
RC Owner / Department Head | [NAME]
Business Controller
 | Admin. [NAME] | Sr. [NAME]. | [NAME] | Sr. [NAME] | Analyst | Staff | Specialist | Sr. Specialist | Manager | Director | Sr. Director
Headcount Addition(s) |  |  |  |  |  |  | 1 |  | 1
Base Salary |  |  |  |  |  |  | 40000 |  | 70000
Fully Loaded Cost Factor | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55
Est. Increase in Support Costs
Effective Date of Addition | July
Business Purpose: | Additional Headcount required for:1) Agricultural Trading: new business added, not anticipated at time of budget
 | 2) Rate & Currency Trading - Confirms and Settlements: manager added to work with Laurel.
 | Back-up financial confirmation expertise needed, FX and interest rate trading activity increased in 2000,
 | complexity of confirmations and settlements increased with proliferation of enron entites (5 to 15 intercompany entities), adding another prime broker, Goldman, Sachs.
Commercial Person that will be supported by Headcount Addition | [NAME]
Commercial Person Headcount Addition discussed with | [NAME] |  |  |  |  |  |  |  |  | Date:
Approvals:
Business Controller |  |  |  |  |  |  |  |  |  | Date:
Vice President, Energy Operations |  |  |  |  |  |  |  |  |  | Date:
Spreadsheet: 72567d1273245746-grouping-multiple-rows-together-by-month-for-summary-view-sample
Sheet: Query 1

Pkey | RUN_DATE | mem_a | mem_d | mem_p | mama | mam_d | mam_p | a mam/mem | d mam/mem | p mam/mem
1 | 2010-05-06 07:01:18 | 256530 | 31008 | 129314 | 1220 | 23 | 36
2 | 2010-05-06 07:31:31
3 | 2010-05-06 08:01:20
4 | 2010-05-06 08:31:13
5 | 2010-05-06 09:01:44
6 | 2010-05-06 09:31:32
7 | 2010-05-06 10:01:44
8 | 2010-06-05 10:31:29
9 | 2010-06-06 11:01:24
10 | 2010-06-06 11:31:25
11 | 2010-06-06 12:01:32
12 | 2010-06-06 12:31:47
13 | 2010-06-06 13:01:29
Spreadsheet: 67379d1268027777-look-up-two-databases-and-display-certain-values-greekboyuk-3-bvj
Sheet: description of problem

Surname | Name | UserID | Job Role |  | Job role | Action Group | Description |  | [NAME] | ALLOC_BATCHJOBS, CTJR_ARREAR ADV,  CTJR_VIEW ONLY, DHO_ARREARS_ACT | Allocations [NAME], GPI Batch Jobs (Letter Production), Create Manual Adjustments, Authorise and Delete Manual Adjustments, [NAME] Rent Statements, View Rent Accounts, View Addresses, View Admin Units, Arrears Actions (DHO), Create Accounts
King | Nick | NKING | ALLOC_BATCHJOBS |  | ALLOC_BATCHJOBS | ALLOC_BATCHJOBS | Allocations [NAME]
King | Nick | NKING | CTJR_ARREAR ADV |  | ALLOC_BATCHJOBS | GPI_BATCHJOBS | GPI Batch Jobs (Letter Production)
King | Nick | NKING | CTJR_VIEW ONLY |  | CTJR_ARREAR ADV | ACCADJ_CREATE | Create Manual Adjustments
King | Nick | NKING | DHO_ARREARS_ACT |  | CTJR_ARREAR ADV | ACCADJ_MAINT | Authorise and Delete Manual Adjustments
ABBOT | jOSEPHINE | JABBOT | CTJR_VIEW ONLY |  | CTJR_ARREAR ADV | ACCOUNT_MAINT | Maintain Rent Accounts
ABBOT | JOSEPHINE | JABBOT | HRAENQ |  | CTJR_ARREAR ADV | ACCOUNT_STATMNT | Produce Ad-hoc Rent Statements
ABBOT | JOSEPHINE | JABBOT | HRMENQ |  | CTJR_ARREAR ADV | ACCOUNT_VIEW | View Rent Accounts
ABBOT | JOSEPHINE | JABBOT | HSGJR_VIEWONLY |  | CTJR_VIEW ONLY | ACCOUNT_VIEW | View Rent Accounts
ABBOT | JOSEPHINE | JABBOT | HSG_CUST_SERV |  | CTJR_VIEW ONLY | ADDRESS_VIEW | View Addresses
ABELL | [NAME] | ABELLL | HRAENQ |  | CTJR_VIEW ONLY | ADMINUNIT_VIEW | View Admin Units
ABELL | [NAME] | ABELLL | HRMENQ |  | CTJR_VIEW ONLY | ARREARS_INFO2 | View Arrears Info Without Income Details
ABELL | [NAME] | ABELLL | HSGJR_VIEWONLY |  | DHO_ARREARS_ACT | DHO_ARREARS ACT | Arrears Actions (DHO)
ABELL | [NAME] | ABELLL | HRMENQ |  | DHO_ARREARS_ACT | DHO_RENTS | Rents Updating for DHO staff
ABELL | [NAME] | ABELLL | HSG_RMO |  | HRAENQ | ARREARS_DETAILS | View Arrears Details
ACHILLE | [NAME] | DACHIL | ALLOC_BATCHJOBS |  | HRAENQ | ARREARS_PERIODS | View Arrears Periods Details
ACHILLE | [NAME] | DACHIL | CTJR_VIEW ONLY |  | HRMENQ | APT_BREAK | Break Appointment
ACHILLE | [NAME] | DACHIL | HRAENQ |  | HRMENQ | APT_CREATE | Create Appointments
ACHILLE | [NAME] | DACHIL | HRMENQ |  | HSGJR_VIEWONLY | ADDRESS_VIEW | View Addresses
ACHILLE | [NAME] | DACHIL | HSG_REREG |  | HSGJR_VIEWONLY | ADMINUNIT_VIEW | View Admin Units
 |  |  |  |  | HSGJR_VIEWONLY | ESTATES | Estates Product Area
 |  |  |  |  | HSGJR_VIEWONLY | GENENQ | General Enquiries
 |  |  |  |  | HSGJR_VIEWONLY | HOUSEHOLD_VIEW | [NAME]
 |  |  |  |  | HSG_CUST_SERV | ADDRESS_VIEW | View Addresses
 |  |  |  |  | HSG_CUST_SERV | CONTACT_COM | HCS - Complete Contacts
 |  |  |  |  | HSG_RMO | [NAME] | Appointment View
 |  |  |  |  | HSG_RMO | APP_VIEW | View Appointments
 |  |  |  |  | HSG_RMO | APT_BREAK | Break Appointment
 |  |  |  |  | HSG_REREG | ADDRESS_MAINT | Create and Maintain Addresses
 |  |  |  |  | HSG_REREG | ADDRESS_VIEW | View Addresses
Spreadsheet: 167125d1341910260-vlookup-all-repeated-text-under-same-name-book1
Sheet: Sheet1

Name | Color |  | Unique Names | Total Pencils
[NAME] | blue |  | [NAME] | 2
[NAME] | yellow |  | [NAME] | 3
[NAME] | red |  | Christine | 2
[NAME] | green |  | Darcy | 4
[NAME] | yellow
Christine | white
Christine | black
Darcy | black
Darcy | purple
Darcy | pink
Darcy | orange
Spreadsheet: 768381d1644943187-trying-to-look-up-and-filter-data-example
Sheet: RED K COL

COL
Id numeric | Component name | Result text