tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43625d1242266454-excel-2007-formula-automation-input-20field-excel1-1-
Sheet: PIVOT

Account Location | (All) |  | AD PRICE TOPOGRAPHY
Sum of AD Price | # of SMB's
City | 1 | 2 | 3 | 4 | 6 | 7 | 9 | 23 | 24 | Grand Total
Anchorage, AK |  |  | 20000 |  |  |  |  |  |  | 20000
Autauga, AL | 2500 |  |  |  |  |  |  |  |  | 2500
Baldwin, AL | 5000 |  |  |  |  |  |  |  |  | 5000
[NAME], AR | 5000 |  |  |  |  |  |  |  |  | 5000
Blount, AL | 2500 |  |  |  |  |  |  |  |  | 2500
Butte, CA |  | 17500 |  |  |  |  |  |  |  | 17500
Calhoun, AL | 10000 |  |  |  |  |  |  |  |  | 10000
Coconino, AZ | 3750 |  |  |  |  |  |  |  |  | 3750
Colbert, AL | 2500 |  |  |  |  |  |  |  |  | 2500
Craighead, AR | 7500 |  |  |  |  |  |  |  |  | 7500
Crawford, AR | 2500 |  |  |  |  |  |  |  |  | 2500
Dale, AL | 2500 |  |  |  |  |  |  |  |  | 2500
Elmore, AL | 2500 |  |  |  |  |  |  |  |  | 2500
Etowah, AL | 10000 |  |  |  |  |  |  |  |  | 10000
Faulkner, [NAME] | 2500 |  |  |  |  |  |  |  |  | 2500
Houston, AL | 2500 | 7500 |  |  |  |  |  |  |  | 10000
Jefferson, AL |  |  |  |  | 21250 |  |  |  |  | 21250
[NAME], AR | 7500 |  |  |  |  |  |  |  |  | 7500
[NAME], UT | 2500 |  |  |  |  |  |  |  |  | 2500
Kern, CA |  |  |  | 35000 |  |  |  |  |  | 35000
Lauderdale, AL | 2500 | 7500 |  |  |  |  |  |  |  | 10000
[NAME], AL | 2500 |  |  |  |  |  |  |  |  | 2500
[NAME], AL | 10000 |  |  |  |  |  |  |  |  | 10000
Limestone, AL | 2500 |  |  |  |  |  |  |  |  | 2500
Lonoke, AR | 2500 |  |  |  |  |  |  |  |  | 2500
[NAME], AL |  |  | 10000 | 15000 |  |  |  |  |  | 25000
Maricopa, AZ |  |  |  |  |  |  |  | 87500 |  | 87500
Mobile, AL |  |  | 11250 | 18750 |  |  |  |  |  | 30000
Montgomery, AL |  | 7500 |  | 15000 |  |  |  |  |  | 22500
Morgan, AL | 3750 | 8750 |  |  |  |  |  |  |  | 12500
Pima, AZ |  |  |  |  | 50000 |  |  |  |  | 50000
Pinal, AZ | 3750 |  |  |  |  |  |  |  | 93750 | 97500
Pulaski, AR |  |  |  | 12500 |  |  |  |  |  | 12500
Saline, AR | 2500 |  |  |  |  | 22500 |  |  |  | 25000
[NAME], AR | 2500 |  |  |  |  |  |  |  |  | 2500
Sequoyah, OK | 2500 |  | 10000 |  |  |  |  |  |  | 12500
Shelby, AL | 3750 |  |  |  |  |  |  |  |  | 3750
St. Clair, AL | 3750 |  |  |  |  |  | 33750 |  |  | 37500
Tuscaloosa, AL | 10000 |  |  |  |  |  |  |  |  | 10000
Washington, AR | 5000 | 12500 |  |  |  |  |  |  |  | 17500
Yavapai, AZ |  | 6250 |  | 15000 |  |  |  |  |  | 21250
Grand Total | 128750 | 67500 | 51250 | 111250 | 71250 | 22500 | 33750 | 87500 | 93750 | 667500
Spreadsheet: 770939d1646340253-limitations-in-xpath-1-0-in-filterxml-book3-1-
Sheet: Sheet2

D4866064DE10 |  |  | 52 | 56 | 54 | 54 | 48 | 54 | 52 | 68 | 69
D4866064DE10 |  |  | 52 | 56 | 54 | 54 | 48 | 54 | 52 | 68 | 69
Spreadsheet: 675249d1588213597-help-with-sumif-s-i-think-i-need-to-sum-for-columns-but-based-on-criteria-sheet-attached-book4
Sheet: Sheet1

 |  | ID Column |  |  | Company |  |  |  |  |  |  | DC |  |  | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Counter | Balance
 |  | H |  |  | 1000 |  |  |  |  |  |  | 40 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Need something here | I need a formula that will do a sumif(s) or something that will look at Company and sum by DC and see if the 6 lines net to zero.
 |  | D |  |  | 1000 |  |  |  |  |  |  | 50 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | I need it to say if 40 add and if 50 subtract
 |  | D |  |  | 1000 |  |  |  |  |  |  | 40 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | When it gets to a new Company number start over
 |  | D |  |  | 1000 |  |  |  |  |  |  | 50 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | Counter or ID Column may help
 |  | D |  |  | 1000 |  |  |  |  |  |  | 40 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | I want to add to VBA code I already have for other operations so if a formula works that is fine or if code is easier that is fine as well
 |  | D |  |  | 1000 |  |  |  |  |  |  | 50 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | H |  |  | 2000 |  |  |  |  |  |  | 40 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Need something here |  | I have tried things like this but have failed
 |  | D |  |  | 2000 |  |  |  |  |  |  | 50 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | D |  |  | 2000 |  |  |  |  |  |  | 40 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | D |  |  | 2000 |  |  |  |  |  |  | 50 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | H |  |  | 3000 |  |  |  |  |  |  | 40 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Need something here
 |  | D |  |  | 3000 |  |  |  |  |  |  | 50 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | D |  |  | 3000 |  |  |  |  |  |  | 40 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | D |  |  | 3000 |  |  |  |  |  |  | 50 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Spreadsheet: 773163d1647659701-if-then-function-result-is-true-but-changes-to-false-when-cell-is-relocated-excel-problem-example
Sheet: Test Sheet

TestNu |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME]
2 |  |  | D/L | D/L | EER | Filter | FWD | RCA ([NAME].) | RCA (W)
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | Here is the Function >
 |  |  | The Function/Condition in the above cell is TRUE
 |  |  | Move this cell to say [NAME], or anwhere to the left of Column D, and the value when the condition is true changes to a condition that is false even though nothing has changed inside the function within the cell
Spreadsheet: 25dd81cc-e94d-4d6a-bb81-66961ea06263
Sheet: Morocco population census

جدول 15: السكان في المغرب بحسب [NAME] تعداد 1994
Table 15: Population of Morocco 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 |  |  |  |  |  |  |  |  | 1560000 | 1614000 | 3174000
5-9 |  |  |  |  |  |  |  |  | 1599000 | 1657000 | 3256000
10-14 |  |  |  |  |  |  |  |  | 1589000 | 1617000 | 3206000
15-19 |  |  |  |  |  |  |  |  | 1433000 | 1409000 | 2842000
20-24 |  |  |  |  |  |  |  |  | 1287000 | 1248000 | 2535000
25-29 |  |  |  |  |  |  |  |  | 1069000 | 981000 | 2049000
30-34 |  |  |  |  |  |  |  |  | 1013000 | 923000 | 1936000
35-39 |  |  |  |  |  |  |  |  | 771000 | 804000 | 1575000
40-44 |  |  |  |  |  |  |  |  | 631000 | 657000 | 1288000
45-49 |  |  |  |  |  |  |  |  | 425000 | 406000 | 831000
50-54 |  |  |  |  |  |  |  |  | 451000 | 375000 | 827000
55-59 |  |  |  |  |  |  |  |  | 330000 | 329000 | 659000
60-64 |  |  |  |  |  |  |  |  | 350000 | 329000 | 679000
65-69 |  |  |  |  |  |  |  |  | 182000 | 205000 | 387000
70-74 |  |  |  |  |  |  |  |  | 196000 | 180000 | 376000
75+ |  |  |  |  |  |  |  |  | 188000 | 210000 | 399000
غير محدد    Not stated | ... | ... |  | ... | ... | ... | ... | ... | ... | ... | ...
المجموع    Total | … | … | … | … | … | … | ... | ...
جدول 16: السكان في المغرب بحسب [NAME] تعداد 2004
Table 16: Population of Morocco by age groups, 2004 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 |  |  |  |  |  |  |  |  | 1435000 | 1488000 | 2923000
5-9 |  |  |  |  |  |  |  |  | 1502000 | 1553000 | 3055000
10-14 |  |  |  |  |  |  |  |  | 1614000 | 1669000 | 3283000
15-19 |  |  |  |  |  |  |  |  | 1583000 | 1576000 | 3159000
20-24 |  |  |  |  |  |  |  |  | 1522000 | 1479000 | 3001000
25-29 |  |  |  |  |  |  |  |  | 1292000 | 1233000 | 2525000
30-34 |  |  |  |  |  |  |  |  | 1149000 | 1080000 | 2229000
35-39 |  |  |  |  |  |  |  |  | 993000 | 918000 | 1911000
40-44 |  |  |  |  |  |  |  |  | 968000 | 919000 | 1887000
45-49 |  |  |  |  |  |  |  |  | 731000 | 769000 | 1500000
50-54 |  |  |  |  |  |  |  |  | 600000 | 631000 | 1231000
55-59 |  |  |  |  |  |  |  |  | 388000 | 372000 | 760000
60-64 |  |  |  |  |  |  |  |  | 400000 | 341000 | 741000
65-69 |  |  |  |  |  |  |  |  | 274000 | 261000 | 535000
70-74 |  |  |  |  |  |  |  |  | 267000 | 236000 | 503000
75+ |  |  |  |  |  |  |  |  | 302000 | 295000 | 597000
غير محدد    Not stated | ... | ... |  | ... | ... | ... | ... | ... | ... | ... | ...
المجموع    Total | … | … | … | … | … | … | ... | ...
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: cb

Curt. Sean |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 266761d1379716907-budgeting-spread-sheet-create-reminder-area-for-bills-due-7-days-before-the-due-date-due_dates
Sheet: Sheet1

Reminders | Due_Dates | Bill_Type | Amount_Due | Days_Till_Due | Paid?_Y/N |  |  | Paid?_Y/N | (All)
 | 2013-09-10 00:00:00 | RENT | 16771 |  | Y
 | 2013-09-11 00:00:00 | INSURANCE | 7306 |  | Y |  |  | Sum of Amount_Due
 | 2013-09-12 00:00:00 | ELECTRICITY | 19454 |  | Y |  |  | Bill_Type | Due_Dates | Total
 | 2013-09-13 00:00:00 | RENT | 10679 |  | Y |  |  | ELECTRICITY | 2013-09-12 00:00:00 | 19454
 | 2013-09-14 00:00:00 | INSURANCE | 13061 |  | Y |  |  |  | 2013-09-15 00:00:00 | 1581
 | 2013-09-15 00:00:00 | ELECTRICITY | 1581 |  | Y |  |  |  | 2013-11-18 00:00:00 | 11989
 | 2013-09-16 00:00:00 | RENT | 1703 |  | Y |  |  |  | 2013-11-21 00:00:00 | 16049
 | 2013-09-17 00:00:00 | INSURANCE | 24412 |  | Y |  |  |  | 2013-11-24 00:00:00 | 29144
 | 2013-11-18 00:00:00 | ELECTRICITY | 11989 |  | N |  |  |  | 2013-11-27 00:00:00 | 29310
 | 2013-11-19 00:00:00 | RENT | 29562 |  | N |  |  |  | 2013-11-30 00:00:00 | 12713
 | 2013-11-20 00:00:00 | INSURANCE | 11948 |  | N |  |  | ELECTRICITY Total |  | 120240
 | 2013-11-21 00:00:00 | ELECTRICITY | 16049 |  | N |  |  | INSURANCE | 2013-09-11 00:00:00 | 7306
 | 2013-11-22 00:00:00 | RENT | 20312 |  | N |  |  |  | 2013-09-14 00:00:00 | 13061
 | 2013-11-23 00:00:00 | INSURANCE | 21130 |  | N |  |  |  | 2013-09-17 00:00:00 | 24412
 | 2013-11-24 00:00:00 | ELECTRICITY | 29144 |  | N |  |  |  | 2013-11-20 00:00:00 | 11948
 | 2013-11-25 00:00:00 | RENT | 20541 |  | N |  |  |  | 2013-11-23 00:00:00 | 21130
 | 2013-11-26 00:00:00 | INSURANCE | 18434 |  | N |  |  |  | 2013-11-26 00:00:00 | 18434
 | 2013-11-27 00:00:00 | ELECTRICITY | 29310 |  | N |  |  |  | 2013-11-29 00:00:00 | 20071
 | 2013-11-28 00:00:00 | RENT | 5487 |  | N |  |  | INSURANCE Total |  | 116362
 | 2013-11-29 00:00:00 | INSURANCE | 20071 |  | N |  |  | RENT | 2013-09-10 00:00:00 | 16771
 | 2013-11-30 00:00:00 | ELECTRICITY | 12713 |  | N |  |  |  | 2013-09-13 00:00:00 | 10679
 |  |  |  |  |  |  |  |  | 2013-09-16 00:00:00 | 1703
 |  |  |  |  |  |  |  |  | 2013-11-19 00:00:00 | 29562
 |  |  |  |  |  |  |  |  | 2013-11-22 00:00:00 | 20312
 |  |  |  |  |  |  |  |  | 2013-11-25 00:00:00 | 20541
 |  |  |  |  |  |  |  |  | 2013-11-28 00:00:00 | 5487
 |  |  |  |  |  |  |  | RENT Total |  | 105055
 |  |  |  |  |  |  |  | Grand Total |  | 341657
Spreadsheet: jeff_dasovich__14234__Vons Model
Sheet: Deal Comps

 | Appendix 8
 | Acquisition Multiples
 | Buyer |  | [NAME]
 |  |  |  |  |  | Calculation of Acquisition Value of Vons
 | Food Lion, Inc. |  | Kash N' Carry Food Stores
 | [NAME] nv |  | Stop & Shop Companies, Inc.
 | Smith's Food & Drug Centers, Inc. |  | Smitty's Supermarkets, Inc.
 | Bruckman, [NAME], Sherrill |  | Jitney Jungle Stores of  America, Inc.
 | KKR |  | Brunos, Inc.
 | [NAME] nv |  | Mayfair Supermarkets, Inc.
 | Food 4 Less Holdings, Inc. |  | Ralph's Grocery Company
 | Stop & Shop Companies, Inc. |  | Purity Supreme, Inc.
 | Yucaipa Cos. |  | Dominick's
 | Winn Dixie Stores, Inc. |  | Thriftway Stores, Inc.
 | Quality Food Centers, Inc. |  | Olson's Food Stores
 | J. Sainsbury Plc. |  | Giant Food Inc.
 | Investcorp SA |  | Star Markets Co. Inc.
 | Hannaford Bros. Co. |  | Boney Wiker & Sons
 | Yucaipa Cos. |  | Smitty's Super Valu, Inc.
 | Cisneros Group |  | Pueblo International, Inc.
 | Randall's Management Corp. Inc. |  | Cullum Companies, Inc.
 | Freeman Spogli & Co., Inc. |  | Purity Supreme, Inc.
 | Food 4 Less Holdings, Inc. |  | Alpha Beta Company, Inc.
 | Freeman Spogli & Co., Inc. |  | Buttrey Foods and Drug Stores Co. Inc.
 | KKR |  | Stop & Shop Companies, Inc.
 | KKR |  | Safeway
Spreadsheet: 676820d1588996989-what-formula-can-i-use-to-get-a-value-from-a-range-dummy
Sheet: Sheet1

 | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 | Score 6
Test 1 | 100
Test 2 |  | 80
Test 3 |  |  |  |  | 0
Test 4
Test 5
Test 6 |  |  | N/A
Test 7
Test 8 |  |  |  |  |  | 60
Test 9
Test 10
 |  |  |  |  |  |  |  | There is only One value per column.
Results |  |  |  |  |  |  |  | What I want, is to bring this values to the results row.
 | =SUM(B3:B12)
 |  |  |  | The results row shows 0 for those blank or N/A when using =SUM.
 |  |  |  | I don't want that, I want to show the actual N/A, the actual [blank] and the actual value on the range
 |  |  |  | What can I use instead of =SUM() ???
Spreadsheet: 376978d1423760298-look-up-max-learning
Sheet: Sheet1

 | this Is simple example, I want to create function in column E
 | SCHEME | POTENTIAL INCENTIVES | ACHIEVEMENT | INCENTIVES earn
 | 0%-100% | 100 | 1.28
 | 101%-114% | 200
 | 115%-119% | 300
 | 120%- | 400
 |  |  |  | 100 | meaning, if 100%, we earned 100
 |  |  |  | 0 | meaning, since the achievment is 128%, then the value is 0
 |  |  |  | 0 | meaning, since the achievement is 128%, then the value is 0
 |  |  |  | 400 | meaning, since the achievementis 128% (>=120%), then the value is 400, as shown on potential incentives
Spreadsheet: 488091d1478490639-automated-model-help-data-flow-reporting-metrics1
Sheet: Manager - pivot

Row Labels | Average of Total days from manager decision to interview to phone interview | Average of Total days from phone interview date to in person interview date | Average of Total days from phone interview to date offer extended
Humcap | 2 | 2 | 5
Lucas Inc. | 2 | 2 | 5
RH | 2 | 2 | 5
ServTech | 2 | 2 | 5
TEK | 1.99009900990099 | 2.087912087912088 | 5.087912087912088
Grand Total | 1.996632996632997 | 2.029739776951673 | 5.029739776951673
 | Total days from description received to vendor submitted candidate to labor
Spreadsheet: 725116d1616534765-calendar-date-update-by-year-calendar-by-year-update
Sheet: 2022

 | Payroll Calendar 2022
2022-01-01 00:00:00
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Spreadsheet: 438353d1451935539-employee-timesheet-calculating-hours-worked-arbeitszeit_mitarbeiter_seepf-rdli_3
Sheet: March

March
Date | Start Time | Break Start | Break End | End Time | Total Hours Worked | Comments
2016-03-01 00:00:00
2016-03-02 00:00:00
2016-03-03 00:00:00
2016-03-04 00:00:00
2016-03-05 00:00:00
2016-03-06 00:00:00
2016-03-07 00:00:00
2016-03-08 00:00:00
2016-03-09 00:00:00
2016-03-10 00:00:00
2016-03-11 00:00:00
2016-03-12 00:00:00
2016-03-13 00:00:00
2016-03-14 00:00:00
2016-03-15 00:00:00
2016-03-16 00:00:00
2016-03-17 00:00:00
2016-03-18 00:00:00
2016-03-19 00:00:00
2016-03-20 00:00:00
2016-03-21 00:00:00
2016-03-22 00:00:00
2016-03-23 00:00:00
2016-03-24 00:00:00
2016-03-25 00:00:00
2016-03-26 00:00:00
2016-03-27 00:00:00
2016-03-28 00:00:00
2016-03-29 00:00:00
2016-03-30 00:00:00
2016-03-31 00:00:00
Spreadsheet: 549750d1511896491-sum-multiple-worksheets-lkk-pf-cycle-count-master
Sheet: AB

Date: |  | LKK Cycle Count | Location AB
Location | Code | Description | Count | Recount
AB-01-A-01 | 979 |  | 1
AB-01-A-02
[NAME]
AB-01-B-02
AB-01-C-01
AB-01-C-02
AB-02-A-01
AB-02-A-02
AB-02-B-01
AB-02-B-02
AB-02-C-01
AB-02-C-02
AB-03-A-01
AB-03-A-02
AB-03-B-01
AB-03-B-02
AB-03-C-01
AB-03-C-02
AB-04-A-01
AB-04-A-02
AB-04-B-01
AB-04-B-02
AB-04-C-01
AB-04-C-02
AB-05-A-01
[NAME]
[NAME]
[NAME]
[NAME]
AB-05-C-02
AB-06-A-01
AB-06-A-02
AB-06-B-01
AB-06-B-02
AB-06-C-01
AB-06-C-02
AB-07-A-01
AB-07-A-02
AB-07-B-01
AB-07-B-02
AB-07-C-01
AB-07-C-02
AB-08-A-01
AB-08-A-02
AB-08-B-01
AB-08-B-02
AB-08-C-01
AB-08-C-02
AB-09-A-01
AB-09-A-02
[NAME]
[NAME]
[NAME]
AB-09-C-02
AB-10-A-01
AB-10-A-02
AB-10-B-01
AB-10-B-02
AB-10-C-01
AB-10-C-02
AB-11-A-01
AB-11-A-02
AB-11-B-01
AB-11-B-02
AB-11-C-01
AB-11-C-02
AB-12-A-01
AB-12-A-02
AB-12-B-01
AB-12-B-02
AB-12-C-01
AB-12-C-02
AB-13-A-01
[NAME]
[NAME]
[NAME]
[NAME]
AB-13-C-02
AB-14-A-01
AB-14-A-02
[NAME]
AB-14-B-02
AB-14-C-01
AB-14-C-02
Spreadsheet: 163817d1340471559-how-can-i-do-a-double-lookup-doublelookup
Sheet: Sheet1

 | Material: | SA-516-70 |  | Temp: | 600 |  | Stress:
Material | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000
SA-516-70 | 20000 | 20000 | 20000 | 19400 | 18100 | 12000 | 6700 | 2500
SA-516-60 | 17100 | 17100 | 17100 | 16400 | 15300 | 10800 | 5900 | 2500
SA-515-60 | 17100 | 17100 | 17100 | 16400 | 15300 | 10800 | 5900 | 2500
SA-285-C | 15700 | 15700 | 15700 | 15300 | 14300 | 10800 | 5900 | NA
Spreadsheet: 61973d1262880374-how-to-show-all-entries-that-meet-a-certain-criteria-in-a-seperate-worksheet-example-of-table
Sheet: BK2

Start Age | 16 | End Age | 18 | Total Count: | 3
ID Number | Name | DOB | Manager | 09 Budget | 10 Budget | Ext Fund | Top Rate Y/N | A/B?C
2 | [NAME] | 1992-06-02 00:00:00 | 17.61095890410959 | MG | 100
3 | [NAME] | 1992-03-03 00:00:00 | 17.86027397260274 | MG | 1000
6 | [NAME] | 1993-01-04 00:00:00 | 17.01917808219178 | PW | 100
 |  |  | This is the working table
Spreadsheet: 110081d1306861298-retrieve-multiple-values-from-range2-based-on-single-criteria-from-range-1-example
Sheet: Sheet1

PRODUCT CATEGORY | PRODUCT |  |  | ENTER PRODUCT CATEGORY
A | 1 |  |  | B
A | 2
A | 3
A | 4 |  |  | returned data below
A | 5 |  |  | PRODUCT
A | 6 |  |  | 1
A | 7 |  |  | 2
A | 8 |  |  | 3
A | 9 |  |  | 4
A | 10 |  |  | 5
A | 11 |  |  | 6
A | 12
A | 13
A | 14
A | 15
A | 16
A | 17
A | 18
A | 19
A | 20
A | 21
A | 22
B | 1
B | 2
B | 3
B | 4
B | 5
B | 6
C | 1
C | 2
C | 3
C | 4
C | 5
C | 6
C | 7
C | 8
C | 9
Spreadsheet: 42346d1240928933-transposing-columns-of-data-into-rows-of-data-ka_analyst-1-
Sheet: Sheet1 (2)

ORIGINAL TABLE |  |  |  | END RESULT TABLE
Reference Number | Reason Number
reference no1 | reason1 |  |  | reference no1 | 0
[NAME] | reason1 |  |  | [NAME] | reason1
[NAME] | reason2 |  |  | reference no3 | reason1 | reason2 | [NAME]
[NAME] | [NAME] |  |  | reference no4 | 0
[NAME] | reason4 |  |  | reference no5 | reason1
[NAME] | reason5 |  |  | reference [NAME] | reason1
reference no3 | reason1 |  |  | reference no7 | reason1
reference no3 | reason2 |  |  | reference [NAME] | reason1 | reason2 | [NAME]
reference no4 |  |  |  | reference no9 | 0
reference no5 | reason1 |  |  | reference no10 | reason1 | reason2 | [NAME] | reason4 | reason5 | reason6
reference [NAME] | reason1 |  |  | reference no11 | reason1
reference [NAME] | reason2 |  |  | reference no12 | 0
reference [NAME] | [NAME] |  |  | reference no13 | reason1
reference no7 |  |  |  | reference no14 | reason1 | reason2 | [NAME] | reason4
reference [NAME] | reason1 |  |  | reference no15
reference no9 | reason1 |  |  | reference no16
reference no10 | reason1 |  |  | reference no17
reference no11 | reason1
reference no11 | reason2
reference no11 | [NAME]
reference no12
reference no13 | reason1
reference no13 | reason2
reference no13 | [NAME]
reference no13 | reason4
reference no13 | reason5
reference no13 | reason6
reference no14 | reason1
reference no15
reference no16 | reason1
reference no17 | reason1
reference no17 | reason2
reference no17 | [NAME]
reference no17 | reason4
Spreadsheet: 0a0022fc-c24d-4aa7-b80a-1c9369c93f93
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
 | 5671.0 Lending Finance, Australia
 | TABLE 11. FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial Finance - Transport equipment ; |  |  | Original | A2413510X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Commercial Finance - Other plant and equipment ; |  |  | Original | A2413511A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Commercial Finance - Total ; |  |  | Original | A2413512C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413513F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | DERIVED | Month | 1
TOTAL ; |  |  | Original | A2413514J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 136802d1326828103-populate-table-from-other-sheets-based-on-drop-down-selection-fast-solutions-2012-scorecard-sue-1
Sheet: Tot Mach Signed, Not Installed

Total Machines Signed, Not Installed
 |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank
 | 2012 YTD |  | January 2012 |  | February 2012 |  | March 2012 |  | April 2012 |  | May 2012 |  | June 2012
Ahub
Dhub
Hhub
Ihub
[NAME]
Lhub |  | - |  | - |  | - |  | - |  | - |  | - |  | -
Mhub
Nhub
Ohub
Shub
Uhub
Vhub
Wino
Yhub |  | - |  | - |  | - |  | - |  | - |  | - |  | -
Total |  | 13 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7
 | July 2012 |  | August 2012 |  | September 2012 |  | October 2012 |  | November 2012 |  | December 2012
Ahub
Dhub
Hhub
Ihub
[NAME]
Lhub |  | - |  | - |  | - |  | - |  | - |  | -
Mhub
Nhub
Ohub
Shub
Uhub
Vhub
Wino
Yhub |  | - |  | - |  | - |  | - |  | - |  | -
Total |  | 9 |  | 10 |  | 11 |  | 8 |  | 13 |  | 12
Spreadsheet: 215590d1361422065-format-copy-paste-comma-separated-data-in-one-cell-to-other-with-other-values-comma-delimited-data-formatting-example
Sheet: Copy of Original

Code Number | 701702703 |  |  | Zone1ANew
Code Number | 709 | 224-230,234,235,236,237,269,268,266,256,254 |  | Zone1ANew
Code Number | 709 | 273,276,277,290,293,334,355,367,378,389,390,344-353 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 701702703 | 276 | 277 | 290 | 293 | 334 | 355 | 367 | 378 | 389 | 390 | 344-353
Code Number | 810 |  |  | Zone1BNew |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 709
Code Number | 709 |  |  | Zone1CNew
Code Number | 811 | 345234235356 |  | Zone1DNew
Spreadsheet: 743660d1628667412-extract-values-into-column-f2-f40-if-condition-is-met-exctract_values_conditionsmet-ans
Sheet: Here

Category | Area | Helper | Cat 2 |  | Area
Cat 1 | [NAME]
Cat 1 | [NAME]
Cat 1 | Bel
Cat 1 | Gal
Cat 1 | Gue
Cat 1 | Harr
Cat 1 | [NAME]
Cat 1 | Meirer
Cat 1 | Mon
Cat 1 | [NAME]
Cat 1 | Ruther
Cat 1 | Science
Cat 1 | Tusc
Cat 1 | [NAME]
Cat 1 | Was
Cat 2 | [NAME]
Cat 2 | Craw
Cat 2 | Def
Cat 2 | High
Cat 2 | Hoc
Cat 2 | [NAME]
Cat 2 | Lawr
Cat 2 | Mer
Cat 2 | Mor
Cat 2 | Mus
Cat 2 | Nob
Cat 2 | [NAME]
Cat 2 | Pen
Cat 2 | [NAME]
Cat 2 | Way