tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 767246d1644358244-power-query-transforming-and-organizing-very-messy-data-need-help-guidance-ideal-queary-layout
Sheet: Sheet1

Date of Brew | Beer Brand | Batch Number | [NAME] | Brewers | Malt Company 1 | Malt 1 | Malt 1 Location | Malt 1 Amount | Malt Company 2 | Malt 2 | Malt 2 Location | Malt 2 Amount | Malt Company 3 | Malt 3 | Malt Location 3 | Malt 3 Amount | Mineral 1 | Mineral 2 | Mineral 3 | Mineral 4 | [NAME] | End Mash | [NAME] | [NAME]
2022-02-08 00:00:00 | [NAME] | 1 | FV-100-1 | Name, 1 Name 2, Name 3 | Company 1 | Malt 1 | Silo 1 | 1000 | Company 2 | Malt 2 | Super Sack | 165 | Company 3 | Malt 3 |  | 600 | 10 | 20 | 40 | 40 | 02:30:00 | 02:45:00 | 151.5 | 164.2
2022-02-08 00:00:00 | [NAME] | 2 | FV-100-1 | Name, 1 Name 2, Name 3 | Company 1 | Malt 1 | Silo 1 | 1000 | Company 2 | Malt 2 | Super Sack | 165 | Company 3 | Malt 3 |  | 600 | 10 | 20 | 40 | 40 | 08:30:00 | 08:45:00 | 151.5 | 164.2
2022-02-08 00:00:00 | [NAME] | 3 | FV-100-1 | Name, 1 Name 2, Name 3 | Company 1 | Malt 1 | Silo 1 | 1000 | Company 2 | Malt 2 | Super Sack | 165 | Company 3 | Malt 3 |  | 600 | 10 | 20 | 40 | 40 | 10:30:00 | 10:45:00 | 151.5 | 164.2
2022-02-08 00:00:00 | [NAME] | 4 | FV-100-1 | Name, 1 Name 2, Name 3 | Company 1 | Malt 1 | Silo 1 | 1000 | Company 2 | Malt 2 | Super Sack | 165 | Company 3 | Malt 3 |  | 600 | 10 | 20 | 40 | 40 | 12:30:00 | 12:45:00 | 151.5 | 164.2
2022-02-09 00:00:00 | [NAME] | 1 | FV-100-2 | Name, 1 Name 2, Name 3 | Company 1 | Malt 1 | Silo 1 | 1000 | Company 2 | Malt 3 |  |  | Company 3 | Malt 3 |  | 600 | 10 | 20 | 40 | 40 | 02:30:00 | 02:45:00 | 151.5 | 164.2
2022-02-09 00:00:00 | [NAME] | 2 | FV-100-2 | Name, 1 Name 2, Name 3 | Company 1 | Malt 1 | Silo 2 | 1000 | Company 2 | Malt 3 |  |  | Company 3 | Malt 3 |  | 600 | 10 | 20 | 40 | 40 | 08:30:00 | 08:45:00 | 151.5 | 164.2
2022-02-09 00:00:00 | [NAME] | 3 | FV-100-2 | Name, 1 Name 2, Name 3 | Company 1 | Malt 1 | Silo 2 | 1000 | Company 2 | Malt 2 |  |  | Company 3 | Malt 3 |  | 600 | 10 | 20 | 40 | 40 | 10:30:00 | 10:45:00 | 151.5 | 164.2
2022-02-09 00:00:00 | [NAME] | 4 | FV-100-2 | Name, 1 Name 2, Name 3 | Company 1 | Malt 1 | Silo 2 | 1000 | Company 2 | Malt 2 |  |  | Company 3 | Malt 3 |  | 600 | 10 | 20 | 40 | 40 | 12:30:00 | 12:45:00 | 151.5 | 164.2
Spreadsheet: 855470d1705024741-matching-2-columns-with-multiple-same-values-sample
Sheet: Sheet1

X | Y | matched with row:
5.1 | 158.69
-139.47 | 45.67
-89.38 | 0
-80.46 | -139.47
123.5 | 5.1
55.98 | 5.36
65.55 | 9.87
0 | 5.1
5.1 | 0
10.5 | 0
5.22 | 55.98
5.1 | 1.24
Spreadsheet: theresa_staab__39592__Kennedy Nov Estimate email
Sheet: Kennedy Summary

 |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  |  | Verification Date:
 |  | Enron North America Corp. |  |  | Kennedy Oil
 |  |  |  |  | Bank:  First Interstate Bank
 |  |  |  |  | ABA:  102300129 | Due Date:
 |  |  |  |  | Acct:  362170342 | 2001-11-30 00:00:00
 |  |  |  |  |  | Payment Method:
 |  | Contact:  [NAME] |  |  | Contact:  [NAME] | Wire
 |  | Tel:  (303) 575-6485 |  |  | Tel:  (307) 682-8726 | Terms:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | Fax: (307) 682-6060 | Last Day of Month
Delivery Period: | Contract # | Meter # / Meter Name
 |  |  |  | Net Volume Mmbtu | WT. Average Price
2001-11-01 00:00:00 | 96023720 | [NAME]
 |  | South Kitty
 |  | TOTAL
 | Index | Discount / Premium | Price/MMBtu | Mcf Quantity | MMBtu Quantity | Amount Due
 | FOM CIG GD Box Draw
 | FOM IF NGPL-Midcont. Box Draw
 | FOM IF CIG - Rockies Box Draw
 | Add'l CIG GD +.10 - Box Draw
 | Add'l CIG GD - Box Draw
 | FOM CIG GD South Kitty
 | FOM IF NGPL-Midcont. South Kitty
 | FOM IF CIG - Rockies South Kitty
 | Add'l CIG GD -South Kitty
 | Add'l CIG GD +.10 - South Kitty
 | [NAME] | Fuel Loss | $             0.00 |  |  | $                                        0.00
 | [NAME] | Fuel Loss | $             0.00 |  |  | $                                        0.00
Total
 |  |  | TOTAL PAYMENT
Spreadsheet: b797da51-0058-41ac-8d8a-ca1dee609839
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5897 | 41634 | [NAME] | Stockwell | USA | 1006 | 00:12:45 | 00:03:41 | 00:45:25 | 00:03:53 | 00:33:17 | 1 | 01:39:00
5897 | 25150 | Scout | Bassett | USA | 1004 | 00:25:18 | 00:04:51 | 00:50:08 | 00:03:45 | 00:43:46 | 2 | [NAME]
5897 | 25135 | Kimberly | Fawcett | CAN | 1007 | 00:23:26 | 00:01:39 | 00:49:36 | 00:06:43 | 00:49:46 | 3 | 02:11:09
5897 | 32629 | [NAME] | Reinertsen | USA | 1005 | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: mary_fischer__25623__31Y
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031Y
COMPANY NAME  The LINC Corp Holding Company
ANALYSIS OF OTHER DEFERRED CHARGES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 2671de9c-1dd6-4447-9f54-b531a1bb990a
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (23 Entries):
 | 11 PCBs, other circuit carriers and EMS 11.4 Special PCBs 11.4.6 Micro via PCBs
No. | Company | Country | City | [NAME] | Hall/Booth
1 | AT&S Austria Technologie & Systemtechnik AG | Austria | Leoben-Hinterberg | 8700 | B1.125
2 | [NAME] Leiterplattenschnelldienst | Germany | [NAME] | 24145 | B1.542
3 | CICOREL SA | Switzerland | Boudry | 2017 | C1.409
4 | Cicor Technologies Ltd. | Switzerland | Zürich | 8050 | C1.409
5 | Cimulec SAS | France | ENNERY | 57365 | B1.611
6 | CML Group | Germany | Waldbronn | 76337 | B1.555
7 | ELVIA - pcb Groupe | France | Coutances | 50211 | B1.147
8 | Christian Enzmann GmbH | Germany | Geretsried | 82538 | B1.325
9 | [NAME] | Germany | Hilden | 40721 | B1.425
10 | ggp-Schaltungen GmbH | Germany | [NAME] | 37520 | B1.311
11 | GRAPHIC PLC | United Kingdom | Crediton, [NAME] | EX17 1HN | B1.432
12 | Hi-Q Electronics Pvt. Ltd.. | India | [NAME] | 635109 | [NAME]
13 | hmp HEIDENHAIN-MICROPRINT GmbH | Germany | Berlin | 12681 | B1.419
14 | Jenaer Leiterplatten GmbH | Germany | Jena | 07745 | B1.451
15 | KSG Leiterplatten GmbH | Germany | [NAME] | 09390 | B1.209
16 | LPKF Laser & Electronics AG | Germany | Garbsen | 30827 | B1.319
17 | META Leiterplatten GmbH & Co. [NAME] | Germany | Villingen-Schwenningen | 78056 | B1.329
18 | Optiprint AG | Switzerland | Berneck | 9442 | B1.464
19 | [NAME] | Switzerland | [NAME] | 6314 | C1.409
20 | RUWEL International GmbH | Germany | Geldern | 47608 | B1.642
21 | Samsung Electro-Mechanics GmbH | Germany | Schwalbach | 65824 | B6.173
22 | SOMACIS S.p.A | Italy | [NAME] (AN) | 60022 | B1.629
23 | Unimicron Technology Corp. | Taiwan | Taoyuan | 333 | B1.642
Spreadsheet: 830129d1684740252-check-for-date-range-within-date-range-for-forumv2
Sheet: Sheet1

Last year start | 2022-04-01 00:00:00 |  | Current year start | 2023-04-01 00:00:00 |  | Next year start | 2024-04-01 00:00:00
Last year end | 2023-03-31 00:00:00 |  | Current year end | 2024-03-31 00:00:00 |  | Next year end | 2025-03-31 00:00:00
Project | Start | End | Full Months in last year | Full Months in actual year | Full Months in next year
Project A | 2022-05-01 00:00:00 | 2025-06-28 00:00:00 | 11 | 12 | 2
Project B | 2023-08-01 00:00:00 | 2023-12-01 00:00:00 | 0 | 4 | 0
Project C | 2023-02-01 00:00:00 | 2023-11-01 00:00:00 | 2 | 7 | 0
Project D | 2025-04-02 00:00:00 | 2030-08-04 00:00:00 | 0 | 0 | 0
Spreadsheet: 738718d1625208364-two-problems-to-do-with-timesheets-submit-ans
Sheet: Sheet1

 | From | To | Rate | Hours | FORMULA | [NAME] |  | wanted answers
 | 0830 | 1030 |  |  |  |  |  | 2
 | 1730 | 0530 |  |  |  |  |  | 12
 | 1730 | 2200 |  |  |  |  |  | 4.5
Spreadsheet: stephanie_panus__39246__CES Trades that have not been paid
Sheet: Sheet1

CES Trades that have not been paid
Basis Trades
Deal # | 2000-12-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 |  | Total |  | Deal Expiration
N92407.1 | X | X | X | X |  |  |  |  |  |  |  |  | 2001-06-30 00:00:00
N92407.2 |  |  |  |  | X | X | X | X | X |  |  |  | 2002-06-30 00:00:00
[NAME] |  | X | X | X | X | X | X | X | X |  |  |  | 2002-03-31 00:00:00
[NAME] | X |  |  |  |  |  |  |  |  |  |  |  | 2001-03-31 00:00:00
NV5435.1 | X | X | X | X | X | X | X | X | X |  |  |  | 2002-06-30 00:00:00
NW7628.1 | X | X | X | X | X | X | X | X | X |  |  |  | 2003-10-31 00:00:00
Exposure | 9675.17 | 2777.81 | 2286.26 | 1904.41 | 1764.13 | 1792.89 | 1925.47 | 2362.71 | 10159.81
Nymex Trades
Deal # | 2000-12-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 |  |  | Total
N91852.1 |  |  |  |  |  | X | X | X | X |  |  |  | 2002-06-30 00:00:00
NW7721.1 |  |  |  |  | X | X | X | X | X |  |  |  | 2002-03-31 00:00:00
NE1116.1 |  |  |  |  |  | X | X | X | X |  |  |  | 2002-07-31 00:00:00
Exposure |  |  |  |  | 1161.92 | 11271.63 | 17236.08 | 27254.54
Total Exposure
Spreadsheet: 108537d1305594961-help-on-stopping-cells-from-changing-copy-of-copy-of-copy-of-copy-of-allowances
Sheet: Bank of Caitlin

 | Bank of Caitlin
 |  |  |  |  |  |  |  |  | Deposit |  | Withdrawals
 |  | Allowance Paid | Long Term Savings | Interest Paid | General Savings | Charity | Holiday Savings |  |  |  | Long Term Savings | Savings | Charity | Holiday
Spreadsheet: 70650d1271352402-bring-scattered-data-to-correct-columns-sample-2
Sheet: Sheet1

PARCEL/ACCT # | CERTIFICATE ID | YEAR | APPROVAL | DATE | CD | NAME | REASON | COMMENT | Prior Assmt | New Assmt | Difference
9819 | 9114 | 2007 | DAA    12/10/2008 | 2008-06-18 00:00:00 | P | A LAUGENI & SONS INC | TDS   TAX DATA SOLUTIONS | REMOVE BY CTGS 12-57 | 554999 | 0 | -554999
9829 | 9583 | 2007 | DAA    12/10/2008 | 2008-12-10 00:00:00 | P | A. DELEO | TDS   TAX DATA SOLUTIONS | REDUCE PER FINANCIAL DATA | 1207500 | 481040 | -726460
9595 | 8770 | 2006 | DAA    11/27/2007 | 2007-11-28 00:00:00 | P | A.DELEO CONSTRUCTION CO | TDS   TAX DATA SOLUTIONS | REDUCE ASSMT | 1895638 | 1173500 | -722138
Spreadsheet: 703451d1605007357-retrieve-column-where-sum-is-less-than-zero-forum
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
CODE A | -10 | -30 | -19 | -25 | 29 | -9 | 25 | 30 | 9
CODE A | 48 | 44 | 47 | -12 | -41 | -44 | 5 | 30 | 29
CODE A | 37 | 9 | -14 | -37 | -42 | -20 | 27 | 30 | -9
CODE B | -5 | -31 | 9 | -39 | 10 | 4 | 3 | -25 | -7
CODE B | 44 | 38 | 31 | 41 | 47 | 8 | -8 | -49 | -22
 | First column where sum of values is less than 0
CODE A | 4
CODE B | 7
Spreadsheet: 41113a66-1867-424c-a643-855da6f12397
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2205 | 10734 | [NAME] | [NAME] | ITA | 103 | 00:23:34 | 00:00:00 | 01:13:54 | 00:00:00 | 00:40:01 | 1 | 02:17:29
2205 | 5454 | Erin | [NAME] | AUS | 109 | 00:20:38 | 00:00:00 | 01:17:15 | 00:00:00 | 00:45:16 | 2 | 02:23:09
2205 | 5373 | [NAME] | [NAME] | ITA | 102 | 00:19:10 | 00:00:00 | 01:15:50 | 00:00:00 | 00:49:24 | 3 | 02:24:24
2205 | 7010 | [NAME] | Cabianca | ITA | 106 | 00:20:35 | 00:00:00 | 01:20:23 | 00:00:00 | 00:47:42 | 4 | 02:28:41
2205 | 10868 | Ljudmilla | [NAME] | ITA | 108 | 00:25:38 | 00:00:00 | 01:17:12 | 00:00:00 | [NAME] | 5 | [NAME]
Spreadsheet: vkaminski__40828__VARMODEL2000
Sheet: CorrMatrix

 |  | Copper | Lead | Nickel | Silver | Tin | Zinc | Gold | Cocoa Beans | TC
Aluminium | 1 | 0.6741884739274787 | 0.2723699873176951 | 0.1744611887747593 | 0 | 0.1987975378059851 | 0.4674718218977857 | 0 | -0.04428079820962257 | 0
Copper | 0.6741884739274787 | 1 | 0.4103452626947168 | 0.1257788209695571 | 0 | 0.19658829232685 | 0.6363978826000132 | 0 | 0.09617321633616685 | 0
Lead | 0.2723699873176951 | 0.4103452626947168 | 1 | 0.03119679829822686 | 0 | 0.1242742686810336 | 0.3749325716812363 | 0 | 0.09494730902536082 | 0
Nickel | 0.1744611887747593 | 0.1257788209695571 | 0.03119679829822686 | 1 | 0 | 0.04026969342301367 | 0.07637496198235766 | 0 | -0.01904722919621025 | 0
Silver | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
Tin | 0.1987975378059851 | 0.19658829232685 | 0.1242742686810336 | 0.04026969342301367 | 0 | 1 | 0.301680503623918 | 0 | 0.1801552017040746 | 0
Zinc | 0.4674718218977857 | 0.6363978826000132 | 0.3749325716812363 | 0.07637496198235766 | 0 | 0.301680503623918 | 1 | 0 | 0.1550963644377781 | 0
Gold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
Cocoa Beans | -0.04428079820962257 | 0.09617321633616685 | 0.09494730902536082 | -0.01904722919621025 | 0 | 0.1801552017040746 | 0.1550963644377781 | 0 | 1 | 0
TC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
 | Please check Nickel to Copper & Al correlations
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Balance Sheet

Raw Materials Balances 29th February - 2024
Sr # | ITEM NAME | KG | Hyperlinks |  | AliGW
1 | 2-EH Acid
2 | A.C.N
3 | AC-406
4 | AC-434
5 | AC-530-532-510
6 | AC-601
7 | Acetic Acid
8 | Acetone
9 | Acrylamide
10 | Acrylic Acid
11 | Adipic Acid
12 | AEEA
13 | AM-11
14 | AM-3
15 | Amino Silicone Fluid
16 | Ammonia Liquor
17 | Ammonium Chloride
18 | Anti Scaling
19 | AP-10 (Sinopol)
20 | APS
21 | BA
22 | Benzoyl chloride
23 | BC
24 | BDO
25 | BG
26 | BGA
27 | [NAME]
28 | Butyl Di Glycol
29 | Cabopol Powder
30 | Calcium Hydroxide
31 | [NAME]
32 | Castor Oil
33 | Caustic Soda
34 | CDMDI
35 | Cobalt
36 | D.O.P
37 | DBP
38 | DCDA
39 | DCP
40 | DEA
41 | DEG
42 | DOA
43 | DSP
44 | E-22
45 | EA
46 | EL
47 | EP-09
48 | Ethanol
49 | [NAME]
50 | FES-773
51 | FES-993
52 | Formaldehyde
53 | Formic Acid
54 | GE Silicone 12500
55 | GE Silicone M 350
56 | Glupanol
57 | Glycerine
58 | Gum Rosan
59 | H2O2
60 | H2SO4
61 | Hardness Controler
62 | HCL
63 | [NAME]
64 | Hypo
65 | IPA
66 | [NAME]
67 | Lead Oxide
68 | Liquid [NAME]
69 | Lithium
70 | Long Oil
71 | MA
72 | MAA
73 | Margal
74 | MARLIPAL 13-70-60
75 | MDI-1
76 | MEG
77 | MEK
78 | Methanol
79 | [NAME]
80 | MMA
81 | MTT
82 | N-Butanol
83 | NC
84 | [NAME]
85 | N-Propanol Alcohol
86 | OILIC ACID
87 | OP-25
88 | OPS-25
89 | PA
90 | [NAME]
91 | Penta
92 | Phosphoric Acid
93 | Pigment Blue
94 | Pigment Red Oxide
95 | PPM
96 | PPS
97 | Provichem2202
98 | Pyodene
99 | Ronglet C
100 | Salt
101 | SBC
102 | SBO
103 | SBS
104 | SFO
105 | SLS
106 | Sobutol
107 | [NAME]
108 | Sodium Acetate
109 | Sodium Sterate
110 | Sodium Sulphate
111 | Starch
112 | [NAME]
113 | [NAME]
114 | Stone Salt
115 | Styrene
116 | SULPHONIC ACID
117 | Tallow F.Acid
118 | TBHP
119 | TEA
120 | Technical A (ISO)
121 | TEDA (A33D) (Cat - 2)
122 | TEDA (Cat - 1)
123 | TEG
124 | Tegostab (B.8948)
125 | Tegostab (B.8950)
126 | [NAME]
127 | Toluene
128 | Tonic Acid
129 | Transformer Oil
130 | Tri Sodium Phospate
131 | Trimethylolpropane
132 | Unknown Chemical
133 | Urea
134 | Valeric Acid
135 | VAM
136 | Xylene
Spreadsheet: 5dee5a41-a3e8-4f5a-af42-ad2f7e42ed96
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das AHV-Rentenalter wird erhöht.
 | [NAME]?
Antwort | Ja | [NAME]
[NAME] | 0.33 | 0.3
Neutral/Weiss nicht | 0.12 | 0.14
[NAME] | 0.55 | 0.56
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 585987d1534142469-return-value-for-first-consective-blank-cell-ignore-proceeding-blank-cells-return-value-for-first-consective-blank-cell-ignore-proceeding-blank-cells
Sheet: Sheet1

 | Original list |  | Helper Column with dates  between first and last dates left blank |  | Expected Output |  | Ideal
 | 2018-06-30 00:00:00 |  | 2018-06-30 00:00:00 |  | 2018-06-30 00:00:00 |  | Start | End
 | 2018-07-01 00:00:00 |  | 2018-07-01 00:00:00 |  | 2018-07-01 00:00:00
 | 2018-07-06 00:00:00 |  | 2018-07-06 00:00:00 |  | 2018-07-06 00:00:00
 | 2018-07-07 00:00:00 |  |  |  | to
 | 2018-07-08 00:00:00 |  |  |  | 2018-07-15 00:00:00
 | 2018-07-09 00:00:00 |  |  |  | 2018-07-20 00:00:00
 | 2018-07-10 00:00:00 |  |  |  | 2018-08-17 00:00:00
 | 2018-07-11 00:00:00 |  |  |  | to
 | 2018-07-12 00:00:00 |  |  |  | 2018-08-19 00:00:00
 | 2018-07-13 00:00:00
 | 2018-07-14 00:00:00
 | 2018-07-15 00:00:00 |  | 2018-07-15 00:00:00
 | 2018-07-20 00:00:00 |  | 2018-07-20 00:00:00
 | 2018-08-17 00:00:00 |  | 2018-08-17 00:00:00
 | 2018-08-18 00:00:00
 | 2018-08-19 00:00:00 |  | 2018-08-19 00:00:00
Spreadsheet: 77913d1278412766-dynamic-sort-dynamic-sorting
Sheet: Rankings

Location | Amount
Town A | 10198
Town B | 11962
Town C | 14456
Town D | 9682
Town E | 7750
Town F | 10276
Town G | 6257
Town H | 10261
Town I | 10053
Town J | 15632
Town K | 12662
Town L | 10801
Town M | 12041
Town N | 11374
Town O | 12133
Town P | 10736
Town Q | 9597
Spreadsheet: 776825d1649935554-fvschedule-formula-annual-to-monthly-interest-rates-fvschedule-interest-rates
Sheet: Sheet1

 |  | Opening | % p.a | Closing |  | FVSCHEDULE
 |  | 10000 | 0.06
Spreadsheet: 199893d1355347879-pivot-grouping-other-method-help-please-test
Sheet: data

Bus Area | Case ID | CHFS? | System Day | O/B | Test Case Description
FINAL NOTICE | Case NOT 1.1 | Y | 0 | Batch | case1 step1
FINAL NOTICE | Case NOT 1.1 | Y | 1 | On-Line | case1 step2
FINAL NOTICE | Case NOT 1.1 | Y | 1 | On-Line | case1 step3
FINAL NOTICE | Case NOT 1.1 | Y | 1 | Batch | case1 step4
FINAL NOTICE | Case NOT 1.1 | Y | 2 | On-Line | case1 step5
FINAL NOTICE | Case NOT 1.1 | Y | 22 | Batch | case1 step6
FINAL NOTICE | Case NOT 1.1 | Y | 23 | On-Line | [NAME]
FINAL NOTICE | Case NOT 1.1 | Y | 23 | Legacy | case1 step8
FINAL NOTICE | Case NOT 1.1 | Y | 23 | Batch | case1 step9
FINAL NOTICE | Case NOT 1.1 | Y | 23 | Legacy | case1 step10
FINAL NOTICE | Case NOT 1.1 | Y | 23 | Batch | case1 step11
FINAL NOTICE | Case NOT 1.1 | Y | 24 | On-Line | case1 step12
FINAL NOTICE | Case NOT 2.1 | Y | 0 | Batch | Case2 step13
FINAL NOTICE | Case NOT 2.1 | Y | 1 | On-Line | Case2 step14
FINAL NOTICE | Case NOT 2.1 | Y | 1 | On-Line | Case2 step15
FINAL NOTICE | Case NOT 2.1 | Y | 1 | Batch | Case2 step16
FINAL NOTICE | Case NOT 2.1 | Y | 2 | On-Line | Case2 step17
FINAL NOTICE | Case NOT 2.1 | Y | 22 | Batch | Case2 step18
FINAL NOTICE | Case NOT 2.1 | Y | 23 | On-Line | Case2 step19
FINAL NOTICE | Case NOT 2.1 | Y | 23 | Legacy | Case2 step20
FINAL NOTICE | Case NOT 2.1 | Y | 23 | Batch | Case2 step21
FINAL NOTICE | Case NOT 2.1 | Y | 23 | Legacy | Case2 step22
FINAL NOTICE | Case NOT 2.1 | Y | 23 | Batch | Case2 [NAME]
FINAL NOTICE | Case NOT 2.1 | Y | 24 | On-Line | Case2 step24
Spreadsheet: louise_kitchen__24239__2002 Plan Group Expense Summary 2
Sheet: EIS by Support Dept

EIS Charges by Support Department
$$ in Thousands
 | 2000 | 2001
 | Forecast | Plan
BA&R | 542 | 462
Transaction Support | 19 | 15
Energy Ops and EOL | 2579 | 2859
HR | 175 | 199
Legal | 429 | 540
PR | 48 | 55
Tax | 181 | 200
Research | 145 | 240
CABC and Esource | 161 | 248
Technical Services | 81 | 155
Treasury | 89 | 102
Total for all Support Depts.
Spreadsheet: 808989d1670834122-if-and-or-formula-help-sample-excel
Sheet: Sheet1

[NAME] | TransactionDate | Transaction Month Month | Invoice No | Amount | Pay terms | Over Due | 2022-12-01 00:00:00 | 2023-01-01 00:00:00
ABC Ltd | 2022-11-18 00:00:00 |  | 010 | 1500 | 30 EOM
ABC Ltd | 2022-10-05 00:00:00 |  | 002 | 2000 | 30 EOM | 2000
XYZ Ltd | 2022-09-22 00:00:00 |  | Inv 0010 | 200 | 60 EOM | 200
XYZ Ltd | 2022-10-26 00:00:00 |  | Inv 0050 | 500 | 60 EOM
PQR Ltd | 2022-08-15 00:00:00 |  | 7685 | 650 | 60 EOM | 650
PQR Ltd | 2022-07-15 00:00:00 |  | 4942 | 500 | 60 EOM | 500
PQR Ltd | 2022-11-28 00:00:00 |  | 5187 | 300 | 60 EOM
Spreadsheet: 145237d1331400976-supply-a-column-of-table-as-a-data-validation-list-sample
Sheet: Sheet1

 | I want data validation in this cell such that I can have the values of Table1>Name as the dropdown. I want this because this serve as a dynamic list
 |  |  |  |  |  | table
 |  |  |  |  |  | SR | Name
 |  |  |  |  |  | 1 | Name1
 |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  | 3 | Name3
 |  |  |  |  |  | 4 | Name4
 |  |  |  |  |  | 5 | Name5
 |  |  |  |  |  | 6 | Name6
 |  |  |  |  |  | 7 | Name7
 |  |  |  |  |  | 8 | Name8
Spreadsheet: 118003d1313344167-excel-formula-amalgamation-negativevolindex
Sheet: Portfolio

 |  | Indicator: | Negative Volume Index
 |  | [NAME]: | If today's volume is less than yesterday's volume:
 |  |  | NVI = yesterday's NVI + (((TC - YC) / YC) * yesterday's NVI)
 |  |  | If today's volume is greater than yesterday's volume:
 |  |  | NVI = yesterday's NVI
 |  |  | If today's volume equals yesterday's volume:
 |  |  | NVI = yesterday's NVI
 |  |  | TC = Today Closed, YC = Yesterday Closed
Date | Open | High | Low | Close | Volume | Today Closed -  Previous Closed | Col G / Previous Closed | Col H / Previous NVI | NVI
2009-01-07 00:00:00 | 91.81 | 92.5 | 90.26 | 91.01 | 26894600 |  |  |  | 1000
2009-01-08 00:00:00 | 90.43 | 93.15 | 90.04 | 92.7 | 23912000