tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 755227d1636728362-help-wedding-planner-seatplan
Sheet: Table Plan

 | 1 | 1 |  | [NAME] | 125
 | 1 | 2 |  |  | #N/A
 | 1 | 3 |  |  | #N/A
 | 1 | 4 |  |  | #N/A |  |  |  |  |  |  |  |  | Select names from the dropdown
 | 1 | 5 |  |  | #N/A |  |  |  |  |  |  |  |  | lists in column E, to fill the seats
 | 1 | 6 |  |  | #N/A |  |  |  |  |  |  |  |  | at the tables
 | 1 | 7 |  |  | #N/A
 | 1 | 8 |  |  | #N/A | #N/A |  |  |  |  |  |  |  | Based on technique shown here:
 | 2 | 1 |  |  | #N/A |  |  |  |  |  |  |  |  | http://www.contextures.com/xlDataVal03.html
 | 2 | 2 |  |  | #N/A
 | 2 | 3 |  |  | #N/A
 | 2 | 4 |  |  | #N/A
 | 2 | 5 |  |  | #N/A
 | 2 | 6 |  |  | #N/A
 | 2 | 7 |  |  | #N/A
 | 2 | 8 |  |  | #N/A | #N/A
 | 3 | 1 |  |  | #N/A
 | 3 | 2 |  |  | #N/A
 | 3 | 3 |  |  | #N/A
 | 3 | 4 |  |  | #N/A
 | 3 | 5 |  |  | #N/A
 | 3 | 6 |  |  | #N/A
 | 3 | 7 |  |  | #N/A
 | 3 | 8 |  |  | #N/A | #N/A
Spreadsheet: 24af7fd0-2ec4-46b1-a8c0-0d3a52345e6a
Sheet: Sheet1

Table 1--U.S. cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  | 2012/13
Item | 2011/12 |  | Oct. |  | Nov. |  | Dec.
 | Million acres
Upland:
Planted | 14.428 |  | 12.121 |  | 12.121 |  | 12.121
Harvested | 9.156 |  | 10.206 |  | 10.206 |  | 10.206
 | Pounds
Yield/harvested acre | 772 |  | 782 |  | 790 |  | 781
 | Million 480-lb. [NAME]
Beginning stocks | 2.572 |  | 3.081 |  | 3.081 |  | 3.081
Production | 14.722 |  | 16.63 |  | 16.79 |  | 16.6
Total supply   1/ | 17.307 |  | 19.716 |  | 19.876 |  | 19.686
[NAME] use | 3.278 |  | 3.375 |  | 3.375 |  | 3.375
Exports | 11.12 |  | 10.875 |  | 10.875 |  | 11.075
Total use | 14.398 |  | 14.25 |  | 14.25 |  | 14.45
Ending stocks  2/ | 3.081 |  | 5.424 |  | 5.624 |  | 5.224
 | Percent
Stocks-to-use ratio | 21.4 |  | 38.1 |  | 39.5 |  | 36.2
 | 1,000 acres
Extra-long staple:
Planted | 307.4 |  | 239 |  | 239 |  | 239
Harvested | 304.9 |  | 237.4 |  | 237.4 |  | 237.4
 | Pounds
Yield/harvested acre | 1340 |  | 1328 |  | 1328 |  | 1.328
 | 1,000 480-lb. [NAME]
Beginning stocks | 28 |  | 269 |  | 269 |  | 269
Production | 851 |  | 657 |  | 657 |  | 657
Total supply   1/ | 885 |  | 926 |  | 926 |  | 926
[NAME] use | 22 |  | 25 |  | 25 |  | 25
Exports | 594 |  | 725 |  | 725 |  | 725
Total use | 616 |  | 750 |  | 750 |  | 750
Ending stocks  2/ | 269 |  | 176 |  | 176 |  | 176
 | Percent
Stocks-to-use ratio | 43.7 | 30.2 | 23.5 |  | 23.5 |  | 23.5
1/ Includes imports.  2/ Includes unaccounted.
Last update:  12/12/12.
Sources: USDA, World Agricultural Outlook Board; and USDC,
U.S. Census Bureau.
Spreadsheet: 851364d1701588051-filter-function-with-dynamically-changing-data-column-based-on-value-in-another-field-filter-calling-dynamic-data-column
Sheet: Data Validation

Nationality |  | Events
 |  | Event 1
Austria |  | Event 2
Belgium |  | Event 3
Brazil |  | Event 4
Chile
China
Colombia
Costa Rica
France
Germany
India
Indonesia
Ireland
Italy
Mexico
Netherlands
New Zealand
Nigeria
Pakistan
Peru
Philippines
Russian Federation
South Africa
South Korea
Sweden
Turkey
Ukraine
United Kingdom
United States
Vietnam
Spreadsheet: 832429d1686322411-formula-for-getting-all-names-just-once-wether-they-are-duplicate-of-unique-excel-forum-requied-formula
Sheet: Sheet2

Day | District | Facility Name
 |  |  |  |  | Sample  result
 |  |  |  |  | Day | District | Facility Name
 |  |  |  |  | 2021-12-01 00:00:00 | Sheikhan | [NAME]
 |  |  |  |  | 2022-01-22 00:00:00 | Sheikhan | FP Ibrahim
 |  |  |  |  | 2022-01-22 00:00:00 | Sheikhan | FP Shafia
 |  |  |  |  | 2022-01-22 00:00:00 | Sheikhan | Shazia
Spreadsheet: 192917d1352627937-duplicating-only-the-formatting-of-a-row-not-content-scheduletest
Sheet: Receivers

Current Receivers | ADD NEW LINES AS NECESSARY, |  |  | FOR SPECIFIC LOCATION CODES SEE GBC TOLL BOOK
BIG W HOXTON PARK | 2000-00
BIG W MONARTO | 5000-02
BIG W WARWICK | 4370-01
BUNNINGS ASHFIELD | 2000-00
BUNNINGS AUBURN | 2000-00
BUNNINGS BANKSTOWN | 2000-00
BUNNINGS BELCONNEN | 2600-00
BUNNINGS BELMONT | 2300-00
BUNNINGS BELROSE | 2000-00
BUNNINGS CAMPBELLTOWN | 2000-00
BUNNINGS CARINGBAH | 2000-00
BUNNINGS CASTEL HILL | 2000-00
BUNNINGS CASULA | 2000-00
BUNNINGS FYSHWICK | 2600-00
BUNNINGS GREENACRE | 2000-00
BUNNINGS HASTINGS | 3220-01
BUNNINGS LAKE HAVEN | 2250-01
BUNNINGS LIDCOME | 2000-00
BUNNINGS MASCOT | 2000-00
BUNNINGS MCGRATHS HILL | 2000-01
BUNNINGS MINCHINBURY | 2000-00
BUNNINGS MUDGEE | 2000-03
BUNNINGS NARRABEEN | 2000-00
BUNNINGS NORTH ROCKS | 2000-00
BUNNINGS PENRITH | 2000-00
BUNNINGS PRESTONS | 2000-00
BUNNINGS [NAME] | 2000-00
BUNNINGS ROSE BAY | 2000-00
BUNNINGS SALAMANDER | 2000-02
BUNNINGS TUGGERANONG | 2600-00
BUNNINGS WANGARATTA | 3000-03
BUNNINGS WARRAWONG | 2500-00
BUNNNGS NARELLAN | 2000-00
ENVIRO SMART | 4000-00
[NAME] | 4000-00
LONGARA BRUSH | 4000-00
MASTERS HOXTON PARK | 2000-00
METCASH QLD | 4000-00
[NAME] | 5000-00
NON-SLIP | 2000-00
[NAME] | 4000-00
PADDINGTON HARDWARE | 4000-00
PARAMOUNT BROWNS | 5000-00
PF BRADY | 2000-00
SPAR ACACIA RIDGE | 4000-00
THE BROOM MAN | 2000-00
[NAME] | 3000-03
WOOLWORTHS GEPPS CROSS | 5000-00
WOOLWORTHS LARAPINTA | 4000-00
WOOLWORTHS MINCHINBURY | 2000-00
WOOLWORTHS WARNERVALE | 2250-01
Spreadsheet: 0a2641e8-0504-490f-9d2f-661a1aaed42f
Sheet: Sheet1

AQR Risk-Balanced Commodities Strategy Fund | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
2014-03-31 00:00:00
[NAME]
NAV: $36,481,360
Asset Class | Security Description | Exposure | Quantity
Commodity | Brent Oil Future | 2792400 | 26
Commodity | Cocoa Future | 1300200 | 44
Commodity | Coffee Future | 1467675 | 22
Commodity | Corn Future | 5244862.5 | 207
Commodity | Cotton No. 2 Future | 794920 | 17
Commodity | Gas Oil Future (100MT) | 2776050 | 31
Commodity | Gold Future | 5648720 | 44
Commodity | Heating Oil ULSD Future | 2210695.2 | 18
Commodity | Lead Future | 208000 | 4
Commodity | Lean Hog Future | 1526100 | 30
Commodity | Live Cattle Future | 4235000 | 77
Commodity | LME Aluminum | 953793.75 | 21
Commodity | LME Copper | 6978562.5 | 42
Commodity | Natural Gas Future | 2069880 | 47
Commodity | Nickel Future | 1241916 | 13
Commodity | Silver Future | 1481400 | 15
Commodity | Soy Meal Future | 3307170 | 69
Commodity | Soy Oil Future | 2425200 | 100
Commodity | Soybean Future | 4931775 | 69
Commodity | Sugar Future | 1612094.4 | 81
Commodity | Unleaded Gas RBOB Future | -243894.0000000002 | -2
Commodity | Wheat Future | 281687.5 | 8
Commodity | WTI Crude Future | 4335260 | 43
Commodity | Zinc Future | 2651325 | 53
Spreadsheet: 727211d1617777301-start-list-on-first-friday-of-the-month-yearly-calendar
Sheet: 2021

2021-01-01 00:00:00
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Fred
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.28.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-28 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 0 | 5 | 0 | 3 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 22 | 1 | 5 | 2 | 1 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 20 | 1 | 6 | 1 | 1 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-28 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 22 | 0 | 4 | 0 | 0 | 0 | 1 | 1 | 0
 | 5TH FL | 34 | 20 | 22 | 0 | 4 | 1 | 2 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 20 | 0 | 5 | 0 | 2 | 1 | 1 | 2 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 4 | 2 | 0 | 0 | 0 | 1 | 0
 | Total House Census
Spreadsheet: mary_fischer__25617__37D
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY # 037D
COMPANY NAME     Artemis Fair Value
ANALYSIS OF RESERVE ITEMS
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City
EXTENSION: 39690
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 108363d1305405001-exact-value-in-vlookup-sampleworkbookmedian-5132011
Sheet: Effects-AA

BP Drug | Systolic | Diastolic | Diuretic
*ace | 6.8 | 6.6 | False
*alpha | 17.9 | 12 | False
*arb | 15.4 | 11.2 | False
*b | 9.1 | 10.5 | False
*ccbd | 20.2 | 13 | False
*ccbn | 14.8 | 13.1 | False
*pd | 19.1 | 12.4 | True
*ld | 26.7 | 10.1 | True
*td | 19.1 | 12.4 | True
*b+td | 15.4 | 11.2 | True
*ace+td | 15.4 | 11.2 | True
*pd+td | 15.4 | 11.2 | True
*ara+td | 15.4 | 11.2 | True
*aag+td | 15.4 | 11.2 | True
*a+b | 15.4 | 11.2 | False
*ace+ccbd | 15.4 | 11.2 | False
*cag | 15.4 | 11.2 | False
*ara | 15.4 | 11.2 | False
*aa | 15.4 | 11.2 | False
Spreadsheet: 3e305fbb-b713-4a80-a7fd-cc32907775f2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2453 | 6001 | Sarka | [NAME] | CZE | 21 | 00:34:56 | 00:00:00 | 00:44:37 | 00:00:00 | 00:29:06 | 1 | 01:48:40
2453 | 13628 | Ailín | Do [NAME] | ARG | 40 | 00:42:28 | 00:00:00 | 00:57:32 | 00:00:00 | 00:47:02 | 2 | 02:27:01
2453 | 13629 | Yesica | [NAME] | ARG | 37 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 732919d1621316441-file-path-formula-for-the-sub-folder-file-path
Sheet: Sheet1

 | [NAME] | Excel Files | Expected Result | [NAME]
[NAME] | Folder_1 ------> |  | D:\Jasond\Excell\File Path\Folder_1\
[NAME] | Folder_2 ------> |  | D:\Jasond\Excell\File Path\Folder_2\
[NAME] | Folder_3  ------> |  | D:\Jasond\Excell\File Path\Folder_3\
[NAME] | Folder_4 ------> | My excel files
[NAME]
Spreadsheet: 79884d1280147879-inserting-blank-rows-test_insert
Sheet: Sheet1

sr.no | 2010-04-01 00:00:00 | today date
1 | 2010-04-01 00:00:00 | 2010-07-26 00:00:00
2 | 2010-04-02 00:00:00 | 2010-07-26 00:00:00
3 | 2010-04-03 00:00:00 | 2010-07-26 00:00:00
4 | 2010-04-04 00:00:00 | 2010-07-26 00:00:00
5 | 2010-04-05 00:00:00 | 2010-07-26 00:00:00
6 | 2010-04-06 00:00:00 | 2010-07-26 00:00:00
7 | 2010-04-07 00:00:00 | 2010-07-26 00:00:00
8 | 2010-04-08 00:00:00 | 2010-07-26 00:00:00
9 | 2010-04-09 00:00:00 | 2010-07-26 00:00:00
10 | 2010-04-10 00:00:00 | 2010-07-26 00:00:00
11 | 2010-04-11 00:00:00 | 2010-07-26 00:00:00
12 | 2010-04-12 00:00:00 | 2010-07-26 00:00:00
13 | 2010-04-13 00:00:00 | 2010-07-26 00:00:00
14 | 2010-04-14 00:00:00 | 2010-07-26 00:00:00
15 | 2010-04-15 00:00:00 | 2010-07-26 00:00:00
16 | 2010-04-16 00:00:00 | 2010-07-26 00:00:00
17 | 2010-04-17 00:00:00 | 2010-07-26 00:00:00
18 | 2010-04-18 00:00:00 | 2010-07-26 00:00:00
Spreadsheet: daren_farmer__5040__HPLN0412
Sheet: Sheet1

HPLN0412.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - April 12, 2001
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-04-12 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 8
Enron (S) |  | LS HPL Katy I/C |  | Enron | 25 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: darrell_schoolcraft__7312__Warm Start Ramp Up
Sheet: Warm Start Data

Hour | Unit 1 | Unit 2 | Unit 3 | Gross | Net
0
1 |  | 15
2 | 15 | 25
3 | 25 | 25 | 10
4 | 150 | 25 | 30
5 | 150 | 150 | 70
6 | 150 | 150 | 140
Spreadsheet: 806848d1669633840-trying-to-modify-a-complex-formula-that-outputs-a-spilled-result-in-multiple-columns-dpd-gk-2-
Sheet: Expected Result

Generic Name | Strength | Dosage Form | Route | DIN/PDIN/NPN
 |  |  |  | Marketed | Approved
Diphenhydramine | 25 mg | Tablet | Oral | 02141728, 02017849, 02097583, 02229492 02229960, 02239029, 02257548, 02348608, 02479710 | 02246449, 02258994, 02249529, 02515849,  02245778, 02521512 02431599, 02436930, 02508796
Diphenhydramine | 6.25 mg/5 mL | Solution | Oral | 02019698, 02248858, 02478242 | 02311232
Diphenhydramine | 50 mg | Tablet | Oral | 01934414, 01991086. 01946986, 02097575, 02229959, 02230398, 02230485, 00583332, 02237789, 02239138, 02257556, 02490943, 02478757, 02498952, 02470144, 02409259 | 02246450, 02263882, 02456303, 02515830, 02532484
Diphenhydramine | 50 mg | Capsule | Oral | 02061597, 00757691, 00489867, 02237169, 02238644, 02244203, 02409224, 02321270 | 02361256, 02447827, 02247659, 02270900, 02318849, 02483122, 02491850
Diphenhydramine | 25 mg | Capsule | Oral | 00757683, 02306352, 02383268, 02365685, 02304252 | 02520745, 02411415
Diphenhydramine | 12.5 mg | Tablet (Chewable) | Oral | 02061287 | 02312352
Diphenhydramine | 12.5 mg/5 mL | Solution | Oral | 02019736, 02465108
Diphenhydramine | 12.5 mg/5 mL | Liquid | Oral | 02248859
Diphenhydramine | 12.5 mg/5 mL | Elixir | Oral | 02298503 | 02311240
Diphenhydramine | 12.5 mg | Tablet (Orally Disintegrating) | Oral | 02505649
Diphenhydramine | 50 mg/30 mL | Liquid | Oral | 02419769
Diphenhydramine | 50 mg/30 mL | Solution | Oral | 02427427, 02432129, 02474867, 02464683
DIPHENHYDRAMINE | 6.25 mg/5 mL | Syrup | Oral |  | 02368374
DIPHENHYDRAMINE | 25 mg | Strip | Oral |  | 02284170
DIPHENHYDRAMINE | 12.5 mg | Tablet | Oral |  | 02247762
Diphenhydramine | 50 mg/mL | Liquid | Intramuscular,  Intravenous | 02219336, 00596612
Diphenhydramine | 50 mg/mL | Solution | Intramuscular,  Intravenous | 02369567
Diphenhydramine | 2% | Cream | Topical | 02247560 | 02401932, 02354578
DIPHENHYDRAMINE | 2%/w/w | Cream | Topical |  | 02321076
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 123747 | 125404
2 | 136303 | 136568
3 | 133829 | 132786
4 | 121812 | 124335
5 | 135753 | 135000
6 | 93187 | 92162
7 | 117640 | 128075
8 | 91512 | 84712
9 | 84604 | 91453
10 | 90899 | 91453
11 | 131808 | 130588
12 | 135284 | 139763
13 | 122655 | 120130
14 | 146110 | 140982
15 | 126731 | 124892
16 | 109303 | 87448
17 | 92306 | 88128
18 | 116598 | 119654
19 | 102987 | 101351
20 | 98817 | 96680
21 | 93323 | 91470
22 | 95675 | 94741
23 | 83327 | 81908
24 | 82183 | 80551
25 | 95465 | 94075
26 | 96011 | 94746
27 | 109356 | 107224
28
29
30
31
2001-05-31 00:00:00 |  |  | 94855
2001-06-27 00:00:00
Spreadsheet: 86284d1286296835-vlookup-based-on-multiple-criteria-example
Sheet: Sheet1

Workbook one
Account Number | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00
41001-71-01
41001-71-03 | 0
41002-71-01
41002-71-02
41030-71-01 | 0
42001-72-00
46103-76-00 | 0
48001-78-00 | 0
70011-71-03
70011-72-00
70011-73-00
70011-74-00
70011-76-00
70011-78-00
Workbook two
 | 2010-01-10 00:00:00 |  |  | 2010-02-10 00:00:00 |  |  | 2010-03-10 00:00:00
Account Number | Location 1 | Location 4 | Total | Location 1 | Location 4 | Total | Location 1 | Location 4 | Total
41001-71-01 | 6000 | 0 | 6000 | 0 | 0 | 0 | 1000 | 0 | 1000
41001-71-03 | 0 | 0 | 0 | 1000 | 0 | 1000 | 20 | 0 | 20
41002-71-01 | 462.22 | 0 | 462.22 | 0 | 0 | 0 | 30 | 0 | 30
41002-71-02 | 0 | 0 | 0 | 6523 | 0 | 6523 | 70 | 0 | 70
41030-71-01 | 125.23 | 0 | 125.23 | 0 | 0 | 0 | 1000 | 0 | 1000
42001-72-00 | 0 | 54085.79 | 54085.79 | 0 | 0 | 0 | 0 | 0 | 0
46103-76-00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.9 | 12.9
48001-78-00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 5000
70011-71-03 | 60000 | 0 | 60000 | 56251 | 0 | 56251 | 1253 | 0 | 1253
70011-72-00 | 0 | 1987.28 | 1987.28 | 0 | 4003.66 | 4003.66 | 0 | 6546.58 | 6546.58
70011-73-00 | 0 | 196.7 | 196.7 | 0 | 3936.13 | 3936.13 | 0 | 77.25 | 77.25
70011-74-00 | 0 | 296.53 | 296.53 | 0 | 415.35 | 415.35 | 0 | 226.29 | 226.29
70011-76-00 | 0 | 564.73 | 564.73 | 0 | 534.33 | 534.33 | 0 | 979.29 | 979.29
70011-78-00 | 0 | 32.78 | 32.78 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 83159d1283205787-sorting-rows-and-moving-columns-in-a-locked-sheet-alloy
Sheet: eleref

Element Name | Chemical Symbol | Atomic # | [NAME]
Actinium | Ac | 89 | 4
Aluminum | Al | 13 | 7
Americium | Am | 95 | 9
Antimony | Sb | 51 | 11
Argon | Ar | 18 | 12
Arsenic | As | 33 | 14
Astatine | At | 85 | 16
Barium | Ba | 56 | 19
Berkelium | Bk | 97 | 20
Beryllium | Be | 4 | 23
Bismuth | Bi | 83 | 24
Bohrium | Bh | 107 | 27
[NAME] | B | 5 | 28
Bromine | Br | 35 | 31
Cadmium | Vd | 48 | 32
Calcium | Ca | 20 | 35
Californium | Cf | 98 | 40
Carbon | C | 6 | 39
Cerium | Ce | 58 | 40
Cesium | Cs | 55 | 45
Chlorine | Cl | 17 | 48
Chromium | Cr | 24 | 51
Cobalt | Co | 27 | 52
Copper | Cu | 29 | 55
Curium | Cm | 96 | 56
Dubnium | Db | 105 | 59
Dysprosium | Dy | 66 | 59
Einsteinium | Es | 99 | 64
Erbium | Er | 68 | 65
Europium | Eu | 63 | 70
Fermium | Fm | 100 | 73
Fluorine | F | 9 | 75
Francium | Fr | 87 | 79
Gadolinium | Gd | 64 | 80
Gallium | Ga | 31 | 84
Germanium | Ge | 32 | 85
Gold | Au | 79 | 88
Hafnium | Hf | 72 | 89
Hassium | Hs | 108 | 91
Helium | He | 2 | 93
Holmium | [NAME] | 67 | 96
Hydrogen | H | 1 | 1
Indium | In | 49 | 98
Iodine | I | 53 | 101
Iridium | Ir | 77 | 103
Iron | Fe | 26 | 106
Krypton | Kr | 36 | 108
Lanthanum | La | 57 | 112
Lawrencium | [NAME] | 103 | 115
Lead | Pb | 82 | 119
Lithium | [NAME] | 3 | 122
Lutetium | [NAME] | 71 | 128
Magnesium | [NAME] | 12 | 127
Manganese | Mn | 25 | 131
Meitnerium | Mt | 109 | 133
Mendelevium | [NAME] | 101 | 137
Mercury | Hg | 80 | 139
Molybdenum | Mo | 42 | 140
Neodumium | Nd | 60 | 141
Neon | Ne | 10 | 144
Neptunium | Np | 93 | 145
Nickel | Ni | 28 | 150
Niobium | Nb | 41 | 152
Nitrogen | N | 7 | 157
Nobelium | No | 102 | 159
Osmium | Os | 76 | 163
[NAME] | O | 8 | 165
Palladium | Pd | 46 | 167
Phosphorus | P | 15 | 169
Platinum | Pt | 78 | 173
Plutonium | Pu | 94 | 175
Polonium | Po | 84 | 178
Potassium | K | 19 | 181
Praseodymium | Pr | 59 | 184
Promethium | Pm | 61 | 186
Protactnium | Pa | 91 | 190
Radium | Ra | 88 | 192
Radon | Rn | 86 | 195
Rhenium | Re | 75 | 197
Rhodium | Rh | 45 | 201
Rubidium | Rb | 37 | 204
Rutherfordium | Rf | 104 | 207
Ruuthenium | Ru | 44 | 209
Samarium | Sm | 62 | 209
Scandium | Sc | 21 | 210
Seaborgium | [NAME] | 106 | 222
Selenium | Se | 34 | 223
Silicon | Si | 14 | 226
Silver | Ag | 47 | 227
Sodium | Na | 11 | 232
Strontium | Sr | 38 | 231
Sulfur | S | 16 | 238
Tantalum | Ta | 73 | 237
Technetium | Tc | 43 | 244
Tellurium | Te | 52 | 243
Terbium | Tb | 65 | 247
Thallium | Tl | 81 | 247
Thorium | Th | 90 | 251
Thulium | Tm | 69 | 252
Tin | Sn | 50 | 257
Titanium | Ti | 22 | 258
Tungsten | W | 74 | 259
Uranium | U | 92 | 262
Vanadium | V | 23 | 261
[NAME] | Xe | 54 | 262
Ytterbium | Yb | 70 | 266
Yttrium | Y | 39 | 264
Zinc | Zn | 30 | 277
Zirconium | Zr | 40 | 268
Spreadsheet: 19701f93-1211-400b-bb02-8e57f54a5571
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42224890 | 2014-07-09 09:22:23 | AXIS | 1 | 6 | 2 | 1599538 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42224970 | 2014-07-09 09:35:53 | ALLIES | 1 | 6 | 2 | 1599538 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42237875 | 2014-07-10 07:17:01 | ALLIES | 1 | 7 | 1 | 759427 | luger | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42238008 | 2014-07-10 07:40:00 | ALLIES | 0 | 2 | 7 | 1443685 | david.kahn | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42238110 | 2014-07-10 07:55:25 | AXIS | 0 | 6 | 7 | 1443685 | david.kahn | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42240571 | 2014-07-10 14:05:39 | ALLIES | 1 | 6 | 5 | 676105 | Didji | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42309988 | 2014-07-15 09:42:48 | ALLIES | 1 | 7 | 4 | 1198315 | Tibor_Mars1 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42310061 | 2014-07-15 09:57:09 | AXIS | 0 | 4 | 7 | 1198315 | Tibor_Mars1 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42324250 | 2014-07-16 10:46:00 | ALLIES | 0 | 5 | 10 | 1605408 | player1605408 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42324422 | 2014-07-16 11:08:02 | AXIS | 0 | 4 | 10 | 1605408 | player1605408 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42391356 | 2014-07-21 09:45:16 | ALLIES | 0 | 4 | 7 | 1575000 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42391493 | 2014-07-21 10:02:27 | AXIS | 1 | 7 | 3 | 1575000 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42396380 | 2014-07-21 18:18:26 | ALLIES | 1 | 7 | 4 | 1351059 | misterfunny | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42396659 | 2014-07-21 18:28:34 | AXIS | 1 | 7 | 2 | 1351059 | misterfunny | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42405541 | 2014-07-22 09:22:43 | ALLIES | 1 | 7 | 4 | 1542223 | guy.warmoes | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42405633 | 2014-07-22 09:42:54 | AXIS | 1 | 7 | 5 | 1542223 | guy.warmoes | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42420253 | 2014-07-23 11:41:56 | ALLIES | 1 | 7 | 5 | 1388575 | Shocking Blue | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42420424 | 2014-07-23 11:51:09 | AXIS | 1 | 7 | 3 | 1388575 | Shocking Blue | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri