tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 39490d1237695705-being-able-to-type-a-code-and-search-stats-test
Sheet: main page

Filter | 12 Months | 2009-03-01 00:00:00 | 2009-03-01 00:00:00 | 2009-02-01 00:00:00 | 2009-02-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2008-12-01 00:00:00 | 2008-12-01 00:00:00 | 2008-12-01 00:00:00 | 2008-12-01 00:00:00 | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-06-01 00:00:00 | 2008-06-01 00:00:00 | 2008-05-01 00:00:00 | 2008-05-01 00:00:00 | 2008-05-01 00:00:00 | 2008-05-01 00:00:00
Code | Player | Saf | Test 2 | Saf | Test 1 | Saf | Test 3 | Saf | Test 2 | Saf | Test 1 | [NAME] 2nd | [NAME] | Test 1 | Ind | Test 4 | Ind | Test 3 | Ind | Test 2 | Ind | Test 1 | Win | Test 3 | Win | Test 2 | Win | Test 1
HUSM | [NAME] | 50 | 19 | 4 | 0 | 30 | 45 | 0 | 2 | 0 | 8 | 70 | 35 | 0 | 90 | 19 | 53 | X | 54 | 1 | 146 | 31 | 12 | 18 | 10 | 40 | 56 | 1
Spreadsheet: 42cbe17c-48c0-48a2-946d-62afc412b7b5
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 48. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (NT), Original (Number, $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
1. . . [NAME] ; |  |  | Original | A2413737T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413738V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413739W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413740F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413741J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413742K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413743L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413744R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413745T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413746V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413747W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 854406d1704295349-how-to-create-a-dynamic-unique-list-from-multiple-sheets-column-practice1-3-
Sheet: Sheet1

 | Sheet 1 |  |  |  |  | Sheet 2 |  |  | Sheet 3 |  |  | Sheet 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Your solution |  | Excel 365 solution
 | Items | Jan | Feb | Mar |  | Items | Jan |  | Items | Feb |  | Items | Mar
 | Apple |  |  |  |  | Apple | 6 |  | Iwatch | 3 |  | TV | 4 |  |  |  | Watch
 | Watch |  |  |  |  | Watch | 2 |  | Apple | 5 |  | Watch | 5 |  |  |  | Dell
 | Dell |  |  |  |  | Dell | 6 |  | Watch | 1 |  | Dell | 1 |  |  |  | Iphone
 | Iphone |  |  |  |  | Iphone | 7 |  | Samsung | 5 |  | Apple | 8 |  |  |  | Iwatch
 | Iwatch |  |  |  |  |  |  |  | Dell | 2 |  | Huawei | 4 |  |  |  | Samsung
 | Samsung |  |  |  |  |  |  |  | Iphone | 3 |  |  |  |  |  |  | Mac
 | Mac |  |  |  |  |  |  |  | Mac | 6 |  |  |  |  |  |  | Nokia
 | Nokia |  |  |  |  |  |  |  | Nokia | 7 |  |  |  |  |  |  | TV
 | TV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Huawei
 | Huawei
 | Note: | Sheet 1 is the summary report
 | Yellow | Yellow highlight is the first items in Jan
 | Blue | Blue highlight items are the items getting from items in "Sheet 2, 3, 4" once it updates
 | Question: | How to automatically get the "Items" in "Sheet 2, 3, 4" into "Sheet 1 table" without duplicate
 |  | So the blue higlight items are the items that wanted to automatically update once there is data in Sheet 2, 3,4
Spreadsheet: 764659d1642860339-requesting-for-a-nested-formula-to-allot-the-amount-variable-lookup-anil_kumar2011-
Sheet: Sheet1

 |  |  |  |  | Category | Amount | Rank
 |  |  |  |  | 5 | 0 | 31
 |  |  |  |  | 5 | 0 | 28
 |  |  |  |  | 1 | 10000 | 4
 |  |  |  |  | 5 | 0 | 34
 |  |  |  |  | 5 | 0 | 21
 |  |  |  |  | 5 | 0 | 20
 |  |  |  |  | 5 | 0 | 37
 |  |  |  |  | 5 | 0 | 27
 |  |  |  |  | 1 | 10000 | 3
 |  |  |  |  | 5 | 0 | 13
 |  |  |  |  | 1 | 10000 | 1
 |  |  |  |  | 5 | 0 | 36
 |  |  |  |  | 5 | 0 | 16
 |  |  |  |  | 5 | 0 | 15
 |  |  |  |  | 1 | 10000 | 7
 |  |  |  |  | 5 | 0 | 29
 |  |  |  |  | 3 | 6000 | 11
 |  |  |  |  | 5 | 0 | 17
 |  |  |  |  | 5 | 0 | 22
 |  |  |  |  | 5 | 0 | 19
 |  |  |  |  | 5 | 0 | 12
 |  |  |  |  | 1 | 10000 | 5
 |  |  |  |  | 3 | 6000 | 10
 |  |  |  |  | 5 | 0 | 24
 |  |  |  |  | 5 | 0 | 26
 |  |  |  |  | 5 | 0 | 18
 |  |  |  |  | 3 | 6000 | 8
 |  |  |  |  | 5 | 0 | 30
 |  |  |  |  | 5 | 0 | 38
 |  |  |  |  | 5 | 0 | 35
 |  |  |  |  | 3 | 6000 | 9
 |  |  |  |  | 5 | 0 | 33
 |  |  |  |  | 1 | 10000 | 2
 |  |  |  |  | 5 | 0 | 25
 |  |  |  |  | 5 | 0 | 32
 |  |  |  |  | 1 | 10000 | 6
 |  |  |  |  | 5 | 0 | 23
 |  |  |  |  | 5 | 0 | 14
Spreadsheet: louise_kitchen__23064__Gross and Net
Sheet: Sheet1

 | Tax Company |  | Gross
11/29/01 Payday
 | 923 | NEPCO Services International, INC | 41036.76
 | 974 | National Energy Production Corp | 5508958.49
 | 983 | Operational Energy Corp | 106186.09
 | 1214 | Garden State Paper Company LLC | 842673.3
 | Total Gross
 | Total Net |  | 4669447.04
11/30/01 Payday
 | 1 | Enron Management Inc. | 79307.89
 | 11 | Enron Corp. | 9517559.35
 | 21 | ECT Strategic Value Corp | 7664.29
 | 60 | Transwestern Pipeline Co. | 594271.76
 | 62 | Florida Gas Transimssion Co. | 962652.72
 | 82 | Enron Engineering & Constructino Co. | 787670.9
 | 85 | Citrus Corp | 70789.91
 | 111 | Pierce Mechanical | 57327.63
 | 172 | Northern Plains Natrual Gas Co. | 597782.62
 | 179 | Northern Natural Gas Com. | 2858266.27
 | 359 | Enron Expat Services Inc. | 1543337.62
 | 364 | Enron North America Corp | 4886920.39
 | 366 | Enron Operations Services Corp | 580374.27
 | 535 | Enron Operations, L.P. | 79249.61
 | 548 | NBP Services Corp | 396926.05
 | 901 | Enron Property & Services Corp | 132695.35
 | 966 | Enron Overseas Services | 142266.07
 | 985 | Enron Energy Services Operations, Inc. | 5022034.58
 | 1041 | Enron Metals & Commodity Copr. | 247352.92
 | 1123 | Enron Trading Services, Inc. | 73862.11
 | 1195 | Enron Pipeline Services Company | 587999.81
 | 1202 | Enron Asset Management Resources, Inc. | 406201.35
 | 1206 | Enron Industrial Markets LLC | 519900.74
 | 1658 | EFS Construction [NAME] | 188109.17
 | 015A | The Bentley Co. | 450825
 | 017H | Enron Bradband Services Inc. | 1652557.85
 | 060P | Enron Communications Leasing, Inc. | 18816.95
 | 063Q | EGEP Services Inc. | 213701.93
 | 083E | Enron Networks LLC | 5593956.78
 | Total Gross
 | Total Net |  | 24459226.43
Spreadsheet: mary_fischer__25718__PRM-Ptshp PhoneList
Sheet: Sheet1

PRM/PARTNERSHIPS Phone List
NAME | EXT. | LOC. | Shift | TITLE | HOME | D.O.B
PRM/PARTNERSHIPS |  |  |  |  |  | Fax: [PHONE]
Ashton, [NAME] | x5-7250 | 1719d | Reg | Tax Specialist | [PHONE] | 2001-11-28 00:00:00
Caminos, [NAME] | x5-4771 | 1730a | 2 | Tax Analyst | [PHONE] | 2001-03-31 00:00:00
[NAME], [NAME] (Helen) | x5-4518 | 1705b | 2 | Tax Analyst | [PHONE] | 2001-11-19 00:00:00
Fischer, [NAME] | x3-5449 | 1715d | 2 | Supervisor | [PHONE] | 2001-10-20 00:00:00
[NAME], [NAME] | x3-0341 | 1714a | 1 | Tax Analyst | [PHONE] | 2000-06-28 00:00:00
[NAME], [NAME] | x5-6317 | 1715c | 1 | Tax Specialist | [PHONE] | 2001-12-15 00:00:00
Mathew-Joy, [NAME] | x5-8337 | 1727b | 1 | Tax Specialist | [PHONE] | 2001-11-26 00:00:00
Matthews, Jackie | x5-4720 | 1782a | 1 | Tax Analyst | [PHONE] | 2001-06-27 00:00:00
Merritt, [NAME] | x5-3862 | 1710b | 2 | Tax Analyst | [PHONE] | 2001-09-12 00:00:00
Ng, [NAME] | x3-3205 | 1720 | 1 | Manager | [PHONE] | 2000-12-04 00:00:00
Nugent, Caroline | x3-0910 | 1725 | 1 | Manager | [PHONE] | 2000-06-17 00:00:00
Ramsey, [NAME] | x5-4413 | 1704a | 2 | Tax Analyst | [PHONE] | 2001-11-14 00:00:00
Reyna, Selma | x3-1765 | 1727a | Reg | Asst.Admin II | [PHONE] | 1975-09-14 00:00:00
Richards, Todd | x5-3522 | 1715b | 2 | Sr. Tax Analyst | [PHONE] | 2001-07-12 00:00:00
Swafford, [NAME] | x3-6124 | 1724 | 2 | Sr. Director | [PHONE] | 2000-12-31 00:00:00
Zhang, [NAME] | x3-5735 | 1715e | 2 | Sr. Tax Analyst | [PHONE] | 2001-01-20 00:00:00
Zarate, [NAME] | x5-6883 | 1729 | Reg | Student Learner | [PHONE] | 2001-12-10 00:00:00
BUSINESS  ANALYSIS & REPORTING
Burgess,  [NAME] | x5-5045 | 3AC1352 | 2 | Director | [PHONE] | 2001-09-07 00:00:00
Eggebrecht, Kurt | x3-3979 | 1734 | 1 | Director | [PHONE] | 2001-06-19 00:00:00
Esperance, [NAME] | x5-5650 | 3ac1359a | 1 | Tax Specialist | [PHONE] | 2001-08-08 00:00:00
Guthrie, [NAME] | x3-9605 | 1726 | Reg | Director | [PHONE] | 2001-09-18 00:00:00
[NAME], [NAME] | x5-8276 | 1734 | 2 | Director | [PHONE] | 2001-07-04 00:00:00
Kent, [NAME] | x5-4774 | 1714c | 2 | Sr. Tax Specialist | [PHONE] | 2001-11-08 00:00:00
Locklear, [NAME] | x3-9701 | 1762 | 2 | Director | [PHONE] | n/a
[NAME], [NAME] | x6-6011 | 3ac1349 | 2 | Tax Clerk | [PHONE] | 2001-09-25 00:00:00
Sharp, [NAME] | x3-0931 | 1742c | 2 | Tax Specialist | [PHONE] | 2001-05-08 00:00:00
Smith, [NAME] | x6-6141 | 3ac1359 | Reg | Contractor | N/A | 2001-04-27 00:00:00
Ware, [NAME] | x5-6594 | 3ac1364 | Reg | Director | [PHONE] | 2001-08-09 00:00:00
[NAME], [NAME] | x 3-6432 | 1738 | Reg | Director | [PHONE] | 2001-10-06 00:00:00
INTERNS
HR REPS
[NAME] | x5-7809 | 1029
[NAME] | X5-6167 | 2AC1267
Clerks
[NAME] |  |  | [NAME]
West, [NAME] |  |  | [NAME], [NAME]
TREASURY DEPT.
[NAME] |  | **[NAME]
VENDOR SET UP HOT-LINE - 3-7373
*[NAME] | x3-6382 |  | x5-7706 | Helena Payne | Chely Mondragon | x3-7227
[NAME] | x3-3505 |  | x3-3067 | [NAME]
AP Hotline: x3-7127 | Resolution Center  x3-1411 |  | Computer Help: x3-4727 |  | Phone Help x3-1717 | SAP Help 5-4727
Spreadsheet: 80520d1280760769-updating-monthly-total-test1
Sheet: February

Items | Requested | Total
A | 1 | 1
D | 2 | 2
R | 3 | 3
S | 4 | 4
T | 5 | 5
U | 6 | 6
M | 7 | 7
W | 8 | 8
Q | 9 | 9
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: b082e3ca-3aaa-4ef4-af5f-966446f5a2f6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  | COMITATO SARDO 2011
CLASSIFICA GENERALE Sardo   2011 |  |  |  |  | ACCESSO AL MASTER FINALE
Class. | [NAME] | Punti |  |  | mete
1 |  | 0 |  |  | 0
2 |  | 0 |  |  | 0
3 |  | 0 |  |  | 0
4 |  | 0 |  |  | 0
5 |  | 0 |  |  | 0
6 |  | 0 |  |  | 0
7 |  | 0 |  |  | 0
8 |  | 0 |  |  | 0
9 |  | 0 |  |  | 0
10 |  | 0 |  |  | 0
11 |  | 0 |  |  | 0
12 |  | 0 |  |  | 0
13 |  | 0 |  |  | 0
14 |  | 0 |  |  | 0
15 |  | 0 |  |  | 0
Spreadsheet: 439984d1452623710-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-summary1
Sheet: Table

Employee Name | Start Date | Years of Service | vac available | hours used | hours remaining
A | 2014-10-23 00:00:00
B | 2015-08-11 00:00:00
C | 2014-10-27 00:00:00
D | 2015-03-30 00:00:00
E | 2015-03-21 00:00:00
F | 2015-05-29 00:00:00
G | 2013-11-20 00:00:00
H | 2015-07-15 00:00:00
I | 2012-08-31 00:00:00
J | 2014-01-27 00:00:00
K | 2012-07-09 00:00:00
L | 2014-10-29 00:00:00
M | 2015-01-01 00:00:00
N | 2010-07-20 00:00:00
Spreadsheet: 542311d1507804345-formatting-latitude-and-longitude-numbers-sandbox-sheet-latlong-diff
Sheet: Worksheet

 | latitude | longitude | Cleansed latitude | Cleansed longitude
[NAME] | 515252891 | -0.3194179 | 5152530662 | -0.3193723
Loc2 | 51.4937169 | -0.1922681 | 51.49370229 | -0.19223323
Loc3 | 51.4616404 | -0.11585 | 51.46162452 | -0.11573601
Loc4 | 559492892 | -32180392 | 55.94930497 | -3.21805529
Loc5 | 55.9492892 | -3.2180392 | 55.94929521 | -3.21800433
Loc6 | 51.4833781 | -0.1856391 | 51.48338395 | -0.18564044
Loc7 | 51.4868038 | -0.2814827 | 51.48681549 | -0.28146929
Loc8 | 51.493007 | -0.2361278 | 51.49276652 | -0.23609293
Loc9 | 51.48033 | -0.258152 | 51.492753 | -0.23610961
Loc10 | 51.429274 | -0.170543 | 51.42927985 | -0.17053629
Loc11 | 51.4926399 | -0.1935221 | 51.49264449 | -0.19355227
Loc12 | 51.591244 | -0.0063247 | 51.59122984 | -0.0063475
Loc13 | 51.5083203 | -0.2061731 | 51.50972759 | -0.20679805
Loc14 | 53.64127 | -1.7977349 | 53.64120481 | -1.79791997
Loc15 | 51.6495303 | -0.0513738 | 51.64954777 | -0.05144354
Loc16 | 51.424418 | -0.334577 | 51.424418 | -0.334577
Loc17 | 50.5556074 | -3.5041805 | 50.55599508 | -3.50322161
Loc18 | 51.540692 | -1.915547 | 51.54067865 | -1.91552018
Loc19 | 51.5064885 | -0.1462095 | 51.5064885 | -0.1462095
Loc20 | 51.4922815 | -0.1922825 | 51.49227065 | -0.19235492
[NAME] | 50.7125814 | -1.9746151 | 50.71255338 | -1.9745239
[NAME] | 53.117281 | -2.798331 | 53.10489659 | -2.77811787
Loc23 | 51.4157273 | -0.3790132 | 51.4157273 | -0.3790132
Loc24 | 51.4620218 | -0.2257446 | 51.46363272 | -0.2298913
Loc25 | 52.74713 | 0.4357897 | 52.74712351 | 0.43618398
Loc26 | 51.5306325 | -0.0935696 | 51.53058077 | -0.09363666
Spreadsheet: 878561d1725654493-need-formulas-to-get-average-of-monthly-productivity-per-person-productivity-changes_v2
Sheet: Monthly Average

Months | Person 1 | Months | Person 2 | Months | Person 3
2024-09-01 00:00:00 | 0.68 | 2024-09-01 00:00:00 |  | 2024-09-01 00:00:00
2024-10-01 00:00:00 | 0.43 | 2024-10-01 00:00:00 |  | 2024-10-01 00:00:00
2024-11-01 00:00:00 | 0.23 | 2024-11-01 00:00:00 |  | 2024-11-01 00:00:00
2024-12-01 00:00:00 | 0.22 | 2024-12-01 00:00:00 |  | 2024-12-01 00:00:00
2025-01-01 00:00:00 | 0.49 | 2025-01-01 00:00:00 |  | 2025-01-01 00:00:00
2025-02-01 00:00:00 | 0.82 | 2025-02-01 00:00:00 |  | 2025-02-01 00:00:00
Spreadsheet: 853470d1703326819-issue-qty-equals-to-purchase-qty-xl-help
Sheet: Sheet1

TRAN DATE | TRAN TYPE | ITEM CODE | RECEIPT QTY | ISSUE QTY |  | DESIRED RESULT (ISSUE QTY)
2023-04-01 00:00:00 | PURC | A | 10 |  |  | 0
2023-04-01 00:00:00 | PURC | B | 40 |  |  | 0
2023-04-01 00:00:00 | PURC | C | 70 |  |  | 0
2023-04-01 00:00:00 | PURC | D | 100 |  |  | 0
2023-04-01 00:00:00 | PURC | E | 130 |  |  | 0
2023-04-02 00:00:00 | SALE | A | 0
2023-04-02 00:00:00 | SALE | B | 0
2023-04-02 00:00:00 | SALE | C | 0
2023-04-02 00:00:00 | SALE | D | 0
2023-04-02 00:00:00 | SALE | E | 0
2023-05-02 00:00:00 | PURC | A | 120 |  |  | 0
2023-05-02 00:00:00 | PURC | B | 50 |  |  | 0
2023-05-02 00:00:00 | PURC | C | 80 |  |  | 0
2023-05-02 00:00:00 | PURC | D | 110 |  |  | 0
2023-05-02 00:00:00 | PURC | E | 140 |  |  | 0
2023-05-03 00:00:00 | SALE | A | 0
2023-05-03 00:00:00 | SALE | B | 0
2023-05-03 00:00:00 | SALE | C | 0
2023-05-03 00:00:00 | SALE | D | 0
2023-05-03 00:00:00 | SALE | E | 0
2023-06-03 00:00:00 | PURC | B | 45 |  |  | 0
2023-06-03 00:00:00 | PURC | C | 75 |  |  | 0
2023-06-03 00:00:00 | PURC | D | 101 |  |  | 0
2023-06-03 00:00:00 | PURC | E | 77 |  |  | 0
2023-06-03 00:00:00 | PURC | A | 60 |  |  | 0
2023-07-04 00:00:00 | PURC | B | 95 |  |  | 0
2023-07-04 00:00:00 | PURC | C | 101 |  |  | 0
2023-07-04 00:00:00 | PURC | D | 211 |  |  | 0
2023-07-04 00:00:00 | PURC | E | 99 |  |  | 0
2023-07-04 00:00:00 | PURC | A | 20 |  |  | 0
2023-07-04 00:00:00 | TRFR | A | 0
2023-07-05 00:00:00 | TRFR | D | 0
2023-07-05 00:00:00 | TRFR | B | 0
2023-08-05 00:00:00 | PURC | C | 123 |  |  | 0
2023-08-05 00:00:00 | TRFR | E | 0
2023-08-06 00:00:00 | TRFR | C | 0
Spreadsheet: 6603fde9-4743-409d-85b8-d2bb9c51a835
Sheet: Sheet1

Undergraduate Majors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Faculty of Humanities
Study Year | Major [NAME] |  |  |  |  | Enrolment Headcount
 |  | 1999-00 | 2000-01 | 2001-02 | 2002-03 | 2003-04 | 2004-05 | 2005-06 | 2006-07* | 2007-08 | 2008-09
 | Single | 208 | 248 | 303 | 397 | 615 | 639 | 671 | 664 | 711 | 744
 | Combined | 15 | 15 | 6 | 6 | 11 | 19 | 15 | 21 | 16 | 23
Year I | Sub-Total: | 223 | 263 | 309 | 403 | 626 | 658 | 686 | 685 | 727 | 767
 | Gen./Integ. Studies | 2 | 0 | 0 | 0 | 0 | 103 | 96 | 273 | 456 | 463
 | Total: | 225 | 263 | 309 | 403 | 626 | 761 | 782 | 958 | 1183 | 1230
 | Single | 169 | 222 | 255 | 287 | 385 | 623 | 607 | 536 | 507 | 482
 | Combined | 48 | 28 | 25 | 53 | 37 | 55 | 67 | 57 | 40 | 31
Year II | Sub-Total: | 217 | 250 | 280 | 340 | 422 | 678 | 674 | 593 | 547 | 513
 | Gen./Integ. Studies | 1 | 2 | 2 | 1 | 1 | 36 | 52 | 78 | 108 | 141
 | Total: | 218 | 252 | 282 | 341 | 423 | 714 | 726 | 671 | 655 | 654
 | Single | 265 | 242 | 267 | 310 | 361 | 355 | 508 | 510 | 446 | 437
 | Combined | 123 | 80 | 67 | 54 | 48 | 58 | 62 | 66 | 67 | 47
Year III | Sub-Total: | 388 | 322 | 334 | 364 | 409 | 413 | 570 | 576 | 513 | 484
 | Gen./Integ. Studies | 8 | 5 | 2 | 3 | 2 | 1 | 33 | 52 | 80 | 81
 | Total: | 396 | 327 | 336 | 367 | 411 | 414 | 603 | 628 | 593 | 565
 | Single | 73 | 118 | 163 | 187 | 257 | 183 | 242 | 339 | 383 | 321
 | Combined | 50 | 67 | 58 | 71 | 54 | 31 | 44 | 58 | 52 | 62
Year IV | Sub-Total: | 123 | 185 | 221 | 258 | 311 | 214 | 286 | 397 | 435 | 383
 | Gen./Integ. Studies | 0 | 0 | 3 | 1 | 4 | 0 | 2 | 34 | 86 | 123
 | Total: | 123 | 185 | 224 | 259 | 315 | 214 | 288 | 431 | 521 | 506
 | Single | 715 | 830 | 988 | 1181 | 1618 | 1800 | 2028 | 2049 | 2047 | 1984
 | Combined | 236 | 190 | 156 | 184 | 150 | 163 | 188 | 202 | 175 | 163
TOTAL: | Sub-Total: | 951 | 1020 | 1144 | 1365 | 1768 | 1963 | 2216 | 2251 | 2222 | 2147
 | Gen./Integ. Studies | 11 | 7 | 7 | 5 | 7 | 140 | 183 | 437 | 730 | 808
 | Total: | 962 | 1027 | 1151 | 1370 | 1775 | 2103 | 2399 | 2688 | 2952 | 2955
 | Adjusted Total: | 895 | 977 | 1091 | 1326 | 1775 | 2103 | 2399 | 2688
Male |  |  | 320 | 340 | 399 | 534 | 623 | 743 | 867 | 996 | 1029
Female |  |  | 705 | 810 | 970 | 1241 | 1480 | 1656 | 1821 | 1956 | 1926
Full-Time |  |  | 875 | 990 | 1189 | 1594 | 1925 | 2196 | 2414 | 2584 | 2552
Part-Time |  |  | 150 | 160 | 180 | 181 | 178 | 203 | 274 | 368 | 403
*Interactive Arts and Science, Medieval and Renaissance Studies were added in 2007-08.
Spreadsheet: 5864075a-ecd5-40e6-bfbf-ebe272bc8497
Sheet: Sheet1

May Precipitation History at Washington, D.C. (KDCA) | Unnamed: 1
 | MAY
1871 | 3.45
1872 | 1.43
1873 | 5.22
1874 | 2.82
1875 | 1.01
1876 | 3.02
1877 | 2.26
1878 | 5.27
1879 | 1.58
1880 | 3.37
1881 | 1.86
1882 | 5
1883 | 2.5
1884 | 3.09
1885 | 2.85
1886 | 10.6
1887 | 2.5
1888 | 4.77
1889 | 10.69
1890 | 4.73
1891 | 3.72
1892 | 4.07
1893 | 5.41
1894 | 4.03
1895 | 3.09
1896 | 2.26
1897 | 6.97
1898 | 3.6
1899 | 2.53
1900 | 4.02
1901 | 2.81
1902 | 3.35
1903 | 2.75
1904 | 2.64
1905 | 3.22
1906 | 1.8
1907 | 5.03
1908 | 6.1
1909 | 3.77
1910 | 3.43
1911 | 0.87
1912 | 4.84
1913 | 4.56
1914 | 1.72
1915 | 2.18
1916 | 2.3
1917 | 1.84
1918 | 2.35
1919 | 5.27
1920 | 1.42
1921 | 5.82
1922 | 4.27
1923 | 1.5
1924 | 6.73
1925 | 1.67
1926 | 2.22
1927 | 2.21
1928 | 4
1929 | 2.29
1930 | 1.81
1931 | 4.84
1932 | 5.07
1933 | 6.26
1934 | 3.85
1935 | 3.54
1936 | 5.32
1937 | 4.02
1938 | 3.51
1939 | 0.41
1940 | 3.1
1941 | 1.58
1942 | 3.51
1943 | 5.3
1944 | 1.11
1945 | 3.06
1946 | 6.99
1947 | 4.44
1948 | 8.87
1949 | 6.33
1950 | 5.76
1951 | 2.74
1952 | 4.73
1953 | 10.69
1954 | 2.98
1955 | 3.38
1956 | 2.17
1957 | 1.4
1958 | 2.77
1959 | 2.89
1960 | 4.35
1961 | 2.57
1962 | 3.46
1963 | 1.06
1964 | 1.46
1965 | 1.72
1966 | 2.74
1967 | 4.27
1968 | 4.23
1969 | 1.2
1970 | 2.79
1971 | 6.8
1972 | 4.78
1973 | 3.39
1974 | 4.37
1975 | 4.71
1976 | 3.57
1977 | 1.73
1978 | 5.13
1979 | 3.55
1980 | 2.64
1981 | 3.42
1982 | 5.11
1983 | 4.62
1984 | 3.8
1985 | 5.79
1986 | 0.75
1987 | 2.54
1988 | 4.5
1989 | 7.77
1990 | 5.2
1991 | 1.57
1992 | 3.41
1993 | 3.4
1994 | 1.56
1995 | 4.19
1996 | 4.96
1997 | 3.04
1998 | 4.05
1999 | 1.28
2000 | 3.08
2001 | 3.71
2002 | 2.17
2003 | 7.06
2004 | 2.98
2005 | 4.61
2006 | 2.21
2007 | 1.75
2008 | 10.66
2009 | 8.05
2010 | 2.4
Spreadsheet: 164997d1340980878-vlookup-problem-rennresultater-test
Sheet: Buschdorf

Date: |  |  |  | Ort: | Buschdorf
Org.:
Classe:
Place | Nr | Nom & Prénom |  | Jury 1 | Class. | Jury 2 | Total
1 |  |  |  | 13 | 0 | 12
2 |  |  |  | 15 | 3 | 6
3 |  |  |  | 11 | 0 | 9
4 |  |  |  | 15 | 2 | 3
5 |  |  |  | 9 | 0 | 9
6 |  |  |  | 12 | 0 | 6
7 |  |  |  | 15 | 1 | 0
8 |  |  |  | 14 | 0 | 0
9 |  |  |  | 14 | 0 | 0
10 |  |  |  | 9 | 0 | 3
11 |  |  |  | 11 | 0 | 0
12 |  |  |  | 8 | 0 | 3
13 |  |  |  | 5 | 0 | 3
14 |  |  |  | 6 | 0 | 0
Spreadsheet: 689431d1596393275-populate-data-to-one-sheet-from-another-and-a-formula-to-fill-cells-based-on-criteria-sample
Sheet: Data Sheet

Name |  | Stock | On Hand | +/- |  | Name |  | Stock | On Hand | +/-
Celery |  | 2 |  |  |  | Brussels - Lb |  | 2
[NAME] |  | 4 |  |  |  | Lemon |  | 4
Spinach |  | 2 |  |  |  | Lime |  | 4
Avocado |  | 6 |  |  |  | Kale - Green |  | 3
Cilantro |  | 2 |  |  |  | Kale - Red |  | 2
Jalapeno |  | 3 |  |  |  | [NAME] |  | 2
Carrot |  | 1 |  |  |  | Lettuce - Red |  | 2
Tomato |  | 0 |  |  |  | Lettuce - Green |  | 2
[NAME] |  | 1 |  |  |  |  |  | 0
Onion |  | 6 |  |  |  |  |  | 0
Broccoli |  | 2 |  |  |  |  |  | 0
Califlower |  | 2 |  |  |  |  |  | 0
Cabbage - Green |  | 1 |  |  |  |  |  | 0
Cabbage - Red |  | 1 |  |  |  |  |  | 0
[NAME] |  | 1 |  |  |  |  |  | 0
Rainbow Chard |  | 1 |  |  |  |  |  | 0
[NAME] |  | 4 |  |  |  | Oranges - Lb |  | 2
Asparagus |  | 1 |  |  |  | [NAME] |  | 2
Green Bean |  | 2 |  |  |  | [NAME] |  | 2
Basil |  | 1 |  |  |  | Blueberry |  | 2
[NAME] |  | 6 |  |  |  | [NAME] |  | 2
[NAME] |  | 0 |  |  |  | Watermelon |  | 1
Olive Oil |  | 1 | 1.25 |  |  | Salt - Pink |  | 1 | 1
Avocado Oil |  | 1 | 0.25 |  |  | ACV |  | 2 | 2
Coconut Oil |  | 1 | 1.5 |  |  | [NAME] |  | 2
Salt - Coarse |  | 1 | 1 |  |  | [NAME] |  | 2
Pepper |  | 1 | 1
Onion Powder |  | 1 | 1.25
[NAME] |  | 1 | 1.25
Eggs - 18 count |  | 1
Milk - Qt |  | 8
Rubbing Alcohol |  | 4 | 2
Bleach |  | 1 | 1.25
Toilet Paper |  | 24 | 26
Diapers |  | 1 | 1.5
 |  | 0
Spreadsheet: 47265d1246271220-how-do-i-conditionally-count-asterisk-in-a-cell-test
Sheet: Sheet1

 | Date | Supervisor | Missed IR | Missed PIN
 | 2009-06-15 00:00:00 | [NAME], [NAME] | *
 | 2009-06-15 00:00:00 | [NAME], [NAME] | *
 | 2009-06-15 00:00:00 | [NAME], [NAME] |  | *
 | 2009-06-16 00:00:00 | Salud, Glenn | *
 | 2009-06-16 00:00:00 | Salud, Glenn |  | *
 | 2009-06-17 00:00:00 | Lapasaran, [NAME] | * | *
 | 2009-06-18 00:00:00 | Rubis, [NAME] | *
 | 2009-06-19 00:00:00 | Rubis, [NAME] |  | *
 |  | should be able to count all missed by Supervisor
 | SUPERVISOR | Missed IR | Missed PIN
 | [NAME], [NAME]
 | Salud, Glenn
 | Lapasaran, [NAME]
 | Rubis, [NAME]
Spreadsheet: 866038d1712965929-num-error-in-xirr-formula-xirr2
Sheet: Sheet1 (2)

SOLV
Event | Date | Shares | Price | $
Buy | 2024-04-01 00:00:00 | 51 | 74.40549
Spinoff
fr. MMM
Curr. Val.
 | XIRR