tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 08f8befe-b461-4c72-ae2f-0b8b1822212e
Sheet: T8

الجدول 8: السكان في الأردن بحسب [NAME] تعداد 1994
Table 8: Population of Jordan by age groups, 1994 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total |  | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 316307 | 300609 | 16375 | 15510 | 242933 | 230782 | 73374 | 69854 | 332682 | 316119 | 648801
5-9 | 289767 | 276639 | 13289 | 12914 | 220987 | 211628 | 68780 | 65011 | 303056 | 289553 | 592609
10-14 | 271179 | 257880 | 11285 | 10322 | 207860 | 198604 | 63319 | 59276 | 282464 | 268202 | 550666
15-19 | 251160 | 232388 | 17175 | 10464 | 194129 | 180378 | 57031 | 52010 | 268335 | 242852 | 511187
20-24 | 243622 | 209801 | 35291 | 12762 | 191806 | 166094 | 51816 | 43707 | 278913 | 222563 | 501476
25-29 | 209365 | 169587 | 44406 | 11504 | 166150 | 136017 | 43215 | 33570 | 253771 | 181091 | 434862
30-34 | 145584 | 126792 | 27717 | 9242 | 117967 | 103144 | 27617 | 23648 | 173301 | 136034 | 309335
35-39 | 98364 | 90146 | 15322 | 6660 | 79303 | 72849 | 19061 | 17297 | 113686 | 96806 | 210492
40-44 | 73128 | 68012 | 10420 | 4840 | 57507 | 54366 | 15621 | 13646 | 83548 | 72852 | 156400
45-49 | 63161 | 64239 | 6570 | 3607 | 51162 | 52235 | 11999 | 12004 | 69731 | 67846 | 137577
50-54 | 61149 | 53169 | 4350 | 2480 | 49729 | 42777 | 11420 | 10392 | 65499 | 55649 | 121148
55-59 | 48299 | 43322 | 2521 | 1699 | 38940 | 34671 | 9359 | 8651 | 50820 | 45021 | 95841
60-64 | 35251 | 32754 | 1585 | 1409 | 27704 | 25845 | 7547 | 6909 | 36836 | 34163 | 70999
65-69 | 22799 | 19433 | 877 | 841 | 18037 | 15760 | 4762 | 3673 | 23676 | 20274 | 43950
70-74 | 13621 | 15997 | 531 | 711 | 10222 | 12250 | 3399 | 3747 | 14152 | 16708 | 30860
75+ | 15835 | 16448 | 447 | 676 | 11450 | 12745 | 4385 | 3703 | 16282 | 17124 | 33406
غير محدد    Not stated | 2134 | 1517 | 907 | 256 | 1644 | 1082 | 490 | 435 | 3041 | 1773 | 4814
المجموع    Total | 2160725 | 1978733 | 209068 | 105897 | 1687530 | 1551227 | 473195 | 427533 | 2369793 | 2084630 | 4454423
Spreadsheet: 773850d1648072506-updating-one-cell-based-on-the-value-of-another-xlookup-cant-have-merged-cells
Sheet: Sheet1

 |  |  | Salesmen |  | Sales
 |  | You can't have these cells Merged>> | [NAME] |  | 250
 |  |  | [NAME] |  | 100
 |  |  | [NAME] |  | 35
 |  |  | [NAME] |  | 598
 |  |  | Doug |  | 633
 |  |  | [NAME] |  | 250
 |  |  | [NAME] |  | 99
 |  |  | [NAME] |  | 75
 |  |  | [NAME] |  | 149
 |  |  | [NAME] |  |  | << You can't have this cell merged.
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: NURS

Old course number | New course number
NURS-304 | NURS-3140
NURS-305 | NURS-3150
NURS-306 | NURS-3160
NURS-307 | [NAME]
NURS-330 | NURS-3300
NURS-401 | [NAME]
NURS-402 | NURS-4120
NURS-403 | NURS-4130
NURS-450 | NURS-4501
NURS-470 | NURS-4701
[NAME] | NURS-4801
NURS-501 | NURS-5101
NURS-550 | NURS-5500
NURS-551 | NURS-5510
NURS-552 | NURS-5520
NURS-553 | NURS-5530
NURS-745 | NURS-6145
NURS-750 | NURS-6150
NURS-780 | NURS-7180
NURS-781 | [NAME]
NURS-782 | [NAME]
NURS-790 | NURS-7790
NURS-791 | NURS-7791
NURS-800 | DNP-9180
NURS-802 | NURS-8102
NURS-803 | NURS-8103
NURS-807 | NURS-8107
NURS-808 | NURS-8108
NURS-809 | NURS-8109
NURS-810 | NURS-8110
NURS-821 | NURS-8210
NURS-822 | NURS-8220
NURS-835 | NURS-8350
NURS-840 | [NAME]
NURS-841 | NURS-8641
NURS-846 | NURS-8946
NURS-855 | NURS-8550
NURS-856 | NURS-8956
NURS-860 | NURS-8610
NURS-861 | NURS-8611
NURS-862 | NURS-8612
NURS-863 | [NAME]
NURS-870 | NURS-8701
NURS-871 | NURS-8671
NURS-875 | NURS-8675
NURS-876 | NURS-8976
NURS-880 | [NAME]
NURS-890 | NURS-8900
Spreadsheet: lynn_blair__24355__KB ALLOCATION
Sheet: POINTS

 | POI | NOMS | SCHD
TW GRAY | 60667 | 118454
EP DUMAS | 186 | 100000
CIG DUMAS | 360 | 67348
NNG/CMS BEAVER | 1309 | 51164
GPM DUMAS | 18058 | 30111
PLAINVIEW SOUTH
LINAM RANCH | 1709 | 102833
SID RICHARDSON JAL | 62873 | 55321
WESTERN GAS [NAME] | 54018 | 52500
[NAME] | 506 | 48229
SHELL TIPPETT | 799 | 45202
LLANO LEA | 200 | 41500
CONOCO MERTZON | 2511 | 36742
EP PLAINS 30" | 57088 | 31082
W GAS [NAME] | 183 | 30262
ALTURA GAINES | 78023 | 30180
GPM DUMAS | 18058 | 30111
GPM FULLERTON | 36511 | 24071
TW HALLEY | 60749 | 17110
AQUILA BECKHAM | 269 | 16000
WARREN EUNICE | 6751 | 15605
MITCHELL CO2 | 89 | 13500
GPM SPRABERRY | 2689 | 12999
GPM [NAME] | 36513 | 12000
TRANSOK SANDSTONE | 3482 | 10402
POWERTEX | 2568 | 10000
Spreadsheet: 104599d1302135906-sort-max-and-min-based-off-another-column-book1
Sheet: Sheet2

Name | Gender | Pushups | Crunches | Run
Male 1 | M | 56 | 50 | 9.34
Male 2 | M | 45 | 52 | 8.45
Female 1 | F | 45 | 52 | 9.54
Female 2 | F | 51 | 54 | 10.45
Male 3 | M | 54 | 55 | 11.56
Male 4 | M | 56 | 52 | 10.28
Female 3 | F | 43 | 62 | 9.38
Male 5 | M | 51 | 60 | 8.48
Spreadsheet: 581429d1531298856-compare-2-sheets-and-show-balance-bbsn
Sheet: IN HAND

CODE | CUSTOMER NAME | ADDRESS | DATE OF KEEPING | Serial Number | Item Name | Gross Weight | Net Weight | Principal | Remarks | Column1 | Column2
Spreadsheet: 605346d1547042971-alphabetize-column-while-moving-associated-data-alphabetize-help-please
Sheet: BrandC

PartnerName
 | 463.2027967667249 | 462.8356535832722 | 5.945228286597271 | 936.081618430692 | 611.7510713468588 | 644.0539235473321 | 531.4182847168448
 | 408.2781709134989 | 75.09648543953695 | 890.6285663994797 | 191.6722969660937 | 539.8248979676086 | 502.5574834406353 | 945.776170739571
 | 691.7737879570437 | 169.6601876019197 | 998.5498650595058 | 497.14287841173 | 910.130018528134 | 186.5639401052046 | 519.4023390688657
 | 918.4328651347789 | 619.6154592403802 | 200.164872743817 | 766.3049213652104 | 21.77717290008463 | 47.42697449745503 | 85.94243235362842
 | 484.2164827402113 | 605.0868570543804 | 357.857974062953 | 23.55174813753147 | 943.9494421526666 | 815.9243118795096 | 407.0053049887655
Spreadsheet: 51442d1251117466-count-all-unique-values-text-definition-of-unique-d-book1-1-
Sheet: Sheet1

 | 11 UNIQUE VALUES
f | 1 |  | 15
ew | 3
d | 1
dw | 1
ew | 3
r | 1
ef | 1
er | 2
re | 1
fer | 1
fr | 1
ew | 3
t | 1
rf | 4
er | 2
w | 1
rf | 4
fe | 2
rf | 4
we | 1
rf | 4
fe | 2
Spreadsheet: 852480d1702500129-tracking-year-on-year-reductions-and-filtering-by-year-company-example-book1
Sheet: Sheet1

Client Name | Measurement No. | Reporting Year End Date | Metric 1 | Metric 2 | Metric 3 | All metrics
XYZ | 1 | 2021-12-31 00:00:00 | 11.24 | 0 | 68.656 | 79.896
XYZ | 2 | 2022-12-31 00:00:00 | 4.322 | 0 | 87.90400000000001 | 92.22600000000001
Client 0 | 1 | 2021-12-31 00:00:00 | 65.4 | 15.33 | 438.426 | 519.1560000000001
Client 0 | 2 | 2022-12-31 00:00:00 | 75.88 | 0 | 926.726 | 1002.606
Client 1 | 1 | 2020-12-31 00:00:00 | 4.899 | 5.793 | 2676.736 | 2687.428
Client 1 | 2 | 2021-12-31 00:00:00 | 5.525 | 4.876 | 1781.235 | 1791.636
Client 1 | 3 | 2022-12-31 00:00:00 | 4.881 | 3.422 | 1878.017 | 1886.32
Client 2 | 1 | 2021-12-31 00:00:00 | 0 | 5.435 | 102.96 | 108.395
Client 3 | 1 | 2021-12-31 00:00:00 | 0.556 | 55.959 | 2675.106 | 2731.621
Client 4 | 1 | 2021-12-31 00:00:00 | 3.053 | 1.074 | 116.943 | 121.07
Client 5 | 3 | 2022-12-31 00:00:00 | 34.84591687854545 | 19.21613192400001 | 306.8050795617932 | 360.8671283643387
Client 6 | 1 | 2021-12-31 00:00:00 | 0 | 1.714 | 68.656 | 70.37
Client 6 | 2 | 2022-12-31 00:00:00 | 1.347368678041091 | 0.06751694584951237 | 67.95213954313658 | 69.36702516702718
Client name | 1 | 2022-08-31 00:00:00 | 15.012990998 | 7.916002128 | 6300.784961293 | 6323.713954419
Client 7 | 1 | 2021-03-31 00:00:00 | 0 | 0 | 15.982 | 15.982
Client 7 | 2 | 2022-03-31 00:00:00 | 0 | 0 | 30.354 | 30.354
Client 7 | 3 | 2023-03-31 00:00:00 | 0 | 0 | 317.640361163427 | 317.640361163427
Single measurement | 1 | 2021-12-31 00:00:00 | 0.197 | 18.189 | 227.872 | 246.258
Spreadsheet: 0bd5c8bc-5ae2-4ce5-8275-d8222dcccc51
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 2. GOODS AND SERVICES, Summary: Original, Current prices
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Balance on goods and services ; |  |  | Original | A2717903C | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Credits, Total goods and services ; |  |  | Original | A2717883F | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Credits, Total goods ; |  |  | Original | A2717881A | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Credits, Rural goods ; |  |  | Original | A2717884J | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Credits, Non-rural goods ; |  |  | Original | A2717931L | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Credits, Net exports of goods under merchanting ; |  |  | Original | A2718034F | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Credits, Non-monetary gold ; |  |  | Original | A2718037L | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Credits, Total services ; |  |  | Original | A2718332C | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Debits, Total goods and services ; |  |  | Original | A2717891F | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Debits, Total goods ; |  |  | Original | A2718054R | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Debits, Consumption goods ; |  |  | Original | A2718056V | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Debits, Capital goods ; |  |  | Original | A2718126R | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Debits, Intermediate and other merchandise goods ; |  |  | Original | A2718182J | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Debits, Non-monetary gold ; |  |  | Original | A2718320V | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Debits, Total services ; |  |  | Original | A2718454A | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 39556d1237832923-unique-change-number-count-sample
Sheet: Sheet1

Period | 1 | Reg Price | Reg Cost | 2 | Reg Price | Reg Cost | 3 | Reg Price | Reg Cost | Times Changed or No Change
Product A | 2 | 3.5 | 1.5 | 2 | 3.5 | 1.5 | 3 | 3.5 | 1.5 | 2
Product B | 2 | 3.5 | 1.5 | 2.5 | 3.5 | 1.5 | 2.75 | 3.5 | 1.5 | 3
Product C | 2 | 3.5 | 1.5 | 2 | 3.5 | 1.5 | 2 | 3.5 | 1.5 | 1
Spreadsheet: 0f0b204b-fd0b-410b-b979-d3f2a0ded542
Sheet: Sheet1

ZONEID | [NAME] | KS0210001 | KS0210002 | KS0210003 | KS0210004 | KS0210005 | KS0210006
00CNGS | ACOCKS GREEN | 10882 | 984 | 3570 | 3560 | 1493 | 4376
00CNGT | ASTON | 9670 | 1846 | 3185 | 4183 | 2088 | 3982
00CNGU | BARTLEY GREEN | 11160 | 1143 | 3812 | 3582 | 1437 | 4294
00CNGW | BILLESLEY | 10514 | 840 | 3560 | 3505 | 1326 | 4278
00CNGX | [NAME] | 9319 | 1764 | 2458 | 4806 | 2408 | 4274
00CNGY | [NAME] | 11172 | 554 | 3552 | 3192 | 1214 | 3851
00CNGZ | BRANDWOOD | 10049 | 724 | 3623 | 2993 | 1169 | 3938
00CNHA | EDGBASTON | 8530 | 315 | 3171 | 1468 | 525 | 2560
00CNHB | ERDINGTON | 10320 | 769 | 3533 | 2962 | 1225 | 3865
00CNHC | HALL GREEN | 9293 | 379 | 2729 | 3069 | 1130 | 3393
00CNHD | HANDSWORTH WOOD | 9739 | 761 | 3207 | 3443 | 1287 | 3403
00CNHE | HARBORNE | 9557 | 340 | 3250 | 2150 | 890 | 2959
00CNHF | HODGE HILL | 9727 | 851 | 3357 | 3250 | 1383 | 3907
00CNHG | KINGS NORTON | 9982 | 985 | 3318 | 3204 | 1333 | 3897
00CNHH | KINGSTANDING | 9720 | 1190 | 3465 | 3487 | 1426 | 4310
00CNHJ | LADYWOOD | 7813 | 731 | 3157 | 1562 | 702 | 2628
00CNHK | LONGBRIDGE | 10288 | 934 | 3142 | 3456 | 1410 | 3855
00CNHL | LOZELLS AND EAST HANDSWORTH | 9713 | 1807 | 3016 | 4364 | 2102 | 4120
00CNHM | MOSELEY AND KINGS HEATH | 10682 | 577 | 3276 | 2716 | 1084 | 3395
00CNHN | NECHELLS | 10793 | 1866 | 4017 | 3926 | 1932 | 4435
00CNHP | NORTHFIELD | 10784 | 631 | 3791 | 3130 | 1193 | 4064
00CNHQ | OSCOTT | 10103 | 484 | 3291 | 3154 | 1233 | 3774
00CNHR | PERRY BARR | 8929 | 426 | 2663 | 2940 | 1210 | 2994
00CNHS | QUINTON | 9786 | 696 | 3244 | 2913 | 1141 | 3710
00CNHT | SELLY OAK | 8307 | 286 | 3005 | 1627 | 638 | 2241
00CNHU | SHARD END | 11302 | 1250 | 4482 | 3478 | 1476 | 4944
00CNHW | SHELDON | 9140 | 506 | 3367 | 2573 | 1078 | 3604
00CNHX | SOHO | 8800 | 1409 | 2619 | 3742 | 1599 | 3512
00CNHY | SOUTH YARDLEY | 10907 | 1014 | 3283 | 3892 | 1681 | 4235
[NAME] | SPARKBROOK | 9739 | 2173 | 2826 | 4791 | 2387 | 4493
00CNJA | SPRINGFIELD | 9306 | 1342 | 2417 | 4241 | 2003 | 3903
00CNJB | STECHFORD AND YARDLEY NORTH | 10001 | 862 | 3370 | 3344 | 1333 | 4109
00CNJC | STOCKLAND GREEN | 9185 | 600 | 2937 | 2594 | 1015 | 3379
00CNJD | SUTTON FOUR OAKS | 9274 | 133 | 3278 | 2466 | 799 | 2891
00CNJE | SUTTON NEW HALL | 8896 | 183 | 2648 | 2660 | 935 | 2638
00CNJF | SUTTON TRINITY | 9887 | 330 | 3194 | 2875 | 1022 | 3170
00CNJG | SUTTON VESEY | 9391 | 168 | 2932 | 2775 | 929 | 2964
00CNJH | TYBURN | 9301 | 942 | 3254 | 3044 | 1217 | 3957
00CNJJ | WASHWOOD HEATH | 8256 | 1678 | 2348 | 4203 | 2216 | 3824
00CNJK | WEOLEY | 10575 | 997 | 3763 | 3355 | 1248 | 4076
Spreadsheet: 101007d1299179614-if-and-if-and-formula-formula-problem
Sheet: Sheet1

Industry Leadership | NEE-UKI
Industry Leadership | NEE-UKI
Industry Leadership | SWE-BeNeLux
Industry Leadership | SWE-France | STG Led
Industry Leadership | SWE-Italy | STG Led
Industry Leadership | SWE-Italy | STG Led
Industry Leadership | SWE-Italy | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-CEE | STG Led
LM Coordinated Audiences | GMU-CEE | STG Led
LM Coordinated Audiences | GMU-GCG | STG Led
LM Coordinated Audiences | GMU-GCG | STG Led
LM Coordinated Audiences | GMU-GCG | STG Led
LM Coordinated Audiences | GMU-India-South Asia | STG Led
LM Coordinated Audiences | GMU-India-South Asia | STG Led
Industry Leadership | GMU-ASEAN | STG Led
Industry Leadership | GMU-ASEAN | STG Led
Industry Leadership | GMU-ASEAN | STG Led
Industry Leadership | GMU-ASEAN | STG Led
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-CEE | STG Led
Industry Leadership | GMU-CEE | STG Led
Industry Leadership | GMU-CEE | STG Led
Industry Leadership | GMU-CEE | STG Led
Industry Leadership | GMU-GCG | STG Led
Industry Leadership | GMU-India-South Asia | STG Led
Industry Leadership | GMU-Korea | STG Led
Industry Leadership | GMU-Korea | STG Led
Industry Leadership | GMU-MEA | STG Led
Industry Leadership | GMU-MEA | STG Led
Industry Leadership | GMU-MEA | STG Led
Industry Leadership | GMU-MEA | STG Led
BAO | GMU-India-South Asia
OIT | GMU-A/NZ
Workload Optimized Systems | NEE-UKI | STG Led
Workload Optimized Systems | NA-United States | STG Led
Workload Optimized Systems | NA-Canada | STG Led
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Withdraw Application

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Intake
Activity Name | Withdraw Application
Activity Description / Purpose | Client requests to withdraw their Application for benefits
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Case Closure |  |  | Accounting
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
[NAME] goes on ORACLE and checks “WITHDRAW"
Screener checks disposition of application
Makes Notes on case
Deny Case
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 87679d1287565845-if-two-conditions-are-met-only-then-look-for-example
Sheet: Sheet1

Date | Fruit Mix | Area
2010-10-05 00:00:00 | [NAME] | Area 1
2010-10-05 00:00:00 |  | Area 1b
2010-10-07 00:00:00 |  | Area 8
2010-10-08 00:00:00 |  | Garden
2010-10-06 00:00:00 |  | Area 1b
2010-10-10 00:00:00 |  | Area 1a
2010-10-11 00:00:00 |  | area 3 & 4
etc |  | Area 1
If Area on Sheet 1 equal area on sheet "Fruit Mix" and the date on Sheet 1 equals the date on sheet "Fruit Mix" then show me the fruit mix allocated
Spreadsheet: 94104d1293951846-drag-formula-but-maintain-references-vlookup-example
Sheet: Sheet2

 |  | Device | COVERAGE
 |  | color LaserJet 2550 series | 0.0522
 |  | color LaserJet 3700 | 0.01222
 |  | Color LaserJet 3800 | 0.03333
 |  | Color LaserJet 4500 | 0.022142
 |  | Color LaserJet 4550 | 0.0215
 |  | color LaserJet 4600 | 0.023356
 |  | color LaserJet 4650 | 0.05151
 |  | Color LaserJet 4700 | 0.02656
 |  | Color LaserJet 4730mfp | 0.02145
 |  | Color LaserJet 4730mfp | 0.011545
Spreadsheet: 138362d1327621703-sorting-apples-and-bananas-from-one-list-into-two-separate-lists-splitlist
Sheet: Sheet1

apples | 50kg
lemons | 12kg
bananas | 30kg
apples | 15kg
apples | 20kg
carrots | 5kg
carrots | 12kg
bananas | 20kg
lemons | 15kg
apples | 7kg
Spreadsheet: 154931d1336606976-excel-2007-reapply-the-auto-filter-on-a-workbook-after-the-enter-key-stroke-sample
Sheet: MATERIAL LIST

 | Client: | MATERIAL LIST
 |  |  |  |  | FUNDINGS
 |  |  |  |  |  |  |  |  |  |  | FUNDINGS
 |  |  |  |  |  |  |  |  |  |  | WX
 |  |  |  |  |  |  |  |  |  |  | UTILITY
 |  |  |  |  |  |  |  |  |  |  | SERC
 |  |  |  |  |  |  |  |  |  |  | OTHER
 |  |  |  |  |  |  |  |  |  |  | 50/50 WX/UTILITY
 | Total Job Materials
 | Total Job Labor: Crew Hrs: | 0
 | Total Job Cost:
Spreadsheet: 42144d1240701210-break-up-and-move-text-to-next-cell-parsedata
Sheet: Sheet1

10/14 24445008289492791715706 BELK #378 COLUMBIA SC 72.22 | 10/14 | 24445008289492791715706 | BELK #378 COLUMBIA SC | 72.22
10/20 24332398295000885150772 SANDHILLS DENTISTRY COLUMBIA SC 1,528.12 | 10/20 | 24332398295000885150772 | SANDHILLS DENTISTRY COLUMBIA SC | 1,528.12
10/24 12982980200000242573036 Payment Thank You Electronic Chk 50.00 | 10/24 | 12982980200000242573036 | Payment Thank You Electronic Chk | 50.00
10/25 24246518300508230675930 TOYS R US #8823 SPARTANBURG SC 24.36 | 10/25 | 24246518300508230675930 | TOYS R US #8823 SPARTANBURG SC | 24.36
10/27 74301338301118000100033 H RUBIN VISION CENTER #3 COLUMBIA SC 312.86 | 10/27 | 74301338301118000100033 | H RUBIN VISION CENTER #3 COLUMBIA SC | 312.86
10/27 24226388302360760426908 WM SUPERCENTER COLUMBIA SC 221.77 | 10/27 | 24226388302360760426908 | WM SUPERCENTER COLUMBIA SC | 221.77
11/04 24164078309091004691759 TARGET 00013193 COLUMBIA SC 212.93 | 11/04 | 24164078309091004691759 | TARGET 00013193 COLUMBIA SC | 212.93
11/04 24164078309091008109451 TARGET 00013193 COLUMBIA SC 122.08 | 11/04 | 24164078309091008109451 | TARGET 00013193 COLUMBIA SC | 122.08
11/04 24445008310518745003105 TJMAXX #0339 COLUMBIA SC 70.56 | 11/04 | 24445008310518745003105 | TJMAXX #0339 COLUMBIA SC | 70.56
11/04 24164078310861000061075 BOOKS A MILLIO00002774 COLUMBIA SC 44.69 | 11/04 | 24164078310861000061075 | BOOKS A MILLIO00002774 COLUMBIA SC | 44.69
Spreadsheet: 117993d1313331330-best-way-to-represent-this-data-pivotcharts
Sheet: Sheet1

Date | Shift | T1 | T2 | T3
2011-08-07 00:00:00 | A |  |  |  |  | Shift | (All)
2011-08-08 00:00:00 | A
2011-08-09 00:00:00 | A |  |  |  |  | Row Labels | Sum of T1 | Sum of T2 | Sum of T3 |  |  |  |  |  | Row Labels | Sum of T1 | Sum of T2 | Sum of T3
2011-08-10 00:00:00 | A |  |  |  |  | 2011-08-07 00:00:00 | 638 | 586 | 1531 |  |  |  |  |  | A | 366 | 365 | 846
2011-08-11 00:00:00 | A |  |  |  |  | 2011-08-08 00:00:00 | 747 | 1027 | 1099 |  |  |  |  |  | 2011-08-07 00:00:00 | 296 | 137 | 613
2011-08-12 00:00:00 | A |  |  |  |  | 2011-08-09 00:00:00 | 901 | 1432 | 1418 |  |  |  |  |  | 2011-08-08 00:00:00 | 70 | 228 | 233
2011-08-13 00:00:00 | A |  |  |  |  | 2011-08-10 00:00:00 | 653 | 1177 | 864 |  |  |  |  |  | B | 75 | 71 | 375
2011-08-14 00:00:00 | A |  |  |  |  | 2011-08-11 00:00:00 | 1437 | 724 | 1431 |  |  |  |  |  | 2011-08-07 00:00:00 | 57 | 7 | 43
2011-08-15 00:00:00 | A |  |  |  |  | 2011-08-12 00:00:00 | 853 | 681 | 1009 |  |  |  |  |  | 2011-08-08 00:00:00 | 18 | 64 | 332
2011-08-16 00:00:00 | A |  |  |  |  | 2011-08-13 00:00:00 | 687 | 1157 | 598 |  |  |  |  |  | C | 593 | 817 | 1062
2011-08-07 00:00:00 | B |  |  |  |  | 2011-08-14 00:00:00 | 1748 | 1440 | 1069 |  |  |  |  |  | 2011-08-07 00:00:00 | 260 | 128 | 556
2011-08-08 00:00:00 | B |  |  |  |  | 2011-08-15 00:00:00 | 1352 | 1722 | 1010 |  |  |  |  |  | 2011-08-08 00:00:00 | 333 | 689 | 506
2011-08-09 00:00:00 | B |  |  |  |  | 2011-08-16 00:00:00 | 1306 | 2248 | 869 |  |  |  |  |  | D | 351 | 360 | 347
2011-08-10 00:00:00 | B |  |  |  |  | Grand Total | 10322 | 12194 | 10898 |  |  |  |  |  | 2011-08-07 00:00:00 | 25 | 314 | 319
2011-08-11 00:00:00 | B |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-08 00:00:00 | 326 | 46 | 28
2011-08-12 00:00:00 | B |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 1385 | 1613 | 2630
2011-08-13 00:00:00 | B
2011-08-14 00:00:00 | B
2011-08-15 00:00:00 | B
2011-08-16 00:00:00 | B
2011-08-07 00:00:00 | C
2011-08-08 00:00:00 | C
2011-08-09 00:00:00 | C
2011-08-10 00:00:00 | C
2011-08-11 00:00:00 | C
2011-08-12 00:00:00 | C
2011-08-13 00:00:00 | C
2011-08-14 00:00:00 | C
2011-08-15 00:00:00 | C
2011-08-16 00:00:00 | C
2011-08-07 00:00:00 | D
2011-08-08 00:00:00 | D
2011-08-09 00:00:00 | D
2011-08-10 00:00:00 | D
2011-08-11 00:00:00 | D
2011-08-12 00:00:00 | D
2011-08-13 00:00:00 | D
2011-08-14 00:00:00 | D
2011-08-15 00:00:00 | D
2011-08-16 00:00:00 | D
Spreadsheet: 816423d1675615191-lookup-for-match-and-mismatch-example
Sheet: Sheet1

Pipe Number | Spex | Result |  |  | Pipe Number | Spec
2-P311.02 | F40 | Do Not Match | <- The result I want to be calculated. |  | 2-P311.02 | F40
2-P311.03 | F40 | Match | <- The result I want to be calculated. |  | 2-P311.03 | F40
 |  |  |  |  | 2-P311.10 | [NAME]
 |  |  |  |  | 2-P314.01 | F40
 |  |  |  |  | 2-P311.03 | F40
 |  |  |  |  | 2-P311.02 | A30
 |  |  |  |  | 2-P314.08 | F40
 |  |  |  |  | 2-P314.20 | F40
 |  |  |  |  | 2-P311.02 | F40
 |  |  |  |  | 2-P315.04 | [NAME]
 |  |  |  |  | 2-P311.03 | F40
 |  |  |  |  | 2-P316.20 | [NAME]
 |  |  |  |  | 2-P311.03 | F40
 |  |  |  |  | 2-P317.11 | F40
 |  |  |  |  | 2-P323.05 | F40
 |  |  |  |  | 2-P323.50 | F40
 |  |  |  |  | 2-P326.01 | F63
 |  |  |  |  | 2-P326.03 | F63
 |  |  |  |  | 2-P326.04 | F63
 |  |  |  |  | 2-P326.05 | F63
 |  |  |  |  | 2-P326.06 | F63
 |  |  |  |  | 2-P326.07 | F63