tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dan_hyvl__4874__Reliant-Etx-HLP
Sheet: TAGG

Buyer | [NAME] | Deal No. | Originator | Type | Deal Date | Status | Reason | Quantity | Comm | Delivery Ref | Index | Beg Date | End Date | Price
ENA | ENTEX | NJ0095.2 | Wallis Jan | Swap | 2000-06-27 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-07-01 00:00:00 | 2000-10-31 00:00:00 | US 3.3550
ENA | ENTEX | NJ7675.4 | Wallis Jan | Swap | 2000-06-27 00:00:00 | Pending | Sent to legal | 5000 [NAME]/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-07-01 00:00:00 | 2000-10-31 00:00:00 | US 3.6050
ENA | ENTEX | NJ9458.6 |  | Forward | 2000-07-17 00:00:00 | Pending | Sent to legal | 20000 MMBtu/day | NG | IF-KATY/TAIL | NX1 | 2000-08-01 00:00:00 | 2000-08-31 00:00:00 | US -0.0200
ENTEX | ENA | NJ9458.7 |  | Forward | 2000-07-28 00:00:00 | Pending | Sent to legal | 20000 MMBtu/day | NG | IF-KATY/TAIL | NX1 | 2000-08-01 00:00:00 | 2000-08-31 00:00:00 | US -0.0200
ENA | ENTEX | NJ9458.8 |  | Forward | 2000-07-28 00:00:00 | Pending | Sent to legal | 20000 MMBtu/day | NG | IF-KATY/TAIL | NX1 | 2000-08-01 00:00:00 | 2000-08-31 00:00:00 | US 0.8075
[NAME] | ENA | NO0793.2 |  | Swap | 2000-06-27 00:00:00 | Pending | Sent to legal | 20000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-07-01 00:00:00 | 2000-10-31 00:00:00 | US 4.4925
[NAME] | ENA | NP4359.1 | [NAME] | Swap | 2000-06-30 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-12-01 00:00:00 | 2001-01-31 00:00:00 | US 4.4650
[NAME] | ENA | NP4459.1 | Wallis Jan | Swap | 2000-06-30 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2000-10-31 00:00:00 | US 4.4500
[NAME] | ENA | NP5288.1 |  | Swap | 2000-07-05 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2000-10-31 00:00:00 | US 4.2400
[NAME] | ENA | NP5288.2 |  | Swap | 2000-07-05 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-12-01 00:00:00 | 2001-01-31 00:00:00 | US 4.2750
[NAME] | ENA | NP8804.1 | [NAME] | Swap | 2000-07-06 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2001-01-31 00:00:00 | US 4.1750
ENA | [NAME] | NQ0954.1 | [NAME] | Swap | 2000-07-07 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2001-01-31 00:00:00 | US 4.2600
RELIANTENERES | ENA | NR3501.1 | Wallis Jan | Swap | 2000-07-18 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-08-01 00:00:00 | 2001-03-31 00:00:00 | US 4.0600
ENTEXGASRES | ENA | NT0366.1 | Wallis Jan | Flex Price | 2000-07-31 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-KATY/TAIL | NX1 | 2000-09-01 00:00:00 | 2000-09-30 00:00:00 | US 0.0175
ENA | [NAME] | NT6120.1 | Wallis Jan | Swap | 2000-08-02 00:00:00 | Pending | Sent to legal | 10000 MMBtu/day | NG | IF-HPL/SHPCHAN | NX1 | 2000-09-01 00:00:00 | 2000-09-30 00:00:00 | US 4.2125
Spreadsheet: 93460d1293036667-help-on-a-account-speadsheet-copy-of-accounts
Sheet: Sheet3

MONEY OUT |  |  |  |  |  |  | MONEY IN
PAYEE | ACCOUNT NO | AMOUNT | DATE OF DIRECT DEBIT | END DATE | BANK TAKEN FROM |  | PAYEE | AMOUNT | DATE OF PAYMENT | BANK PAID INTO
PAYEE 1 |  | 10 |  | till paid | Emily |  | COMEX 2000 UK | 3000 |  | DEAN |  | Money owed to [NAME] | 360 | loan for 1st dec
PAYEE 2 |  | 65 |  | till paid | Emily |  | Maternity Allowance | 500 |  | EMILY |  |  | 800 | money lent in dec
PAYEE 3 |  | 35 |  | 2015 | Emily |  | Child Benefit | 135 |  | EMILY
PAYEE 4 |  | 35 |  | 2015 | Emily |  | [NAME] | 35 |  | EMILY |  | total
PAYEE 5 |  | 260 |  | 2014-06-01 00:00:00 | Emily
PAYEE 6 |  | 18 |  | ongoing | [NAME] |  | TOTAL INCOME
PAYEE 7 |  | 120 |  | 2013-10-01 00:00:00 | Emily
PAYEE 8 |  | 196 |  | ongoing | Emily
PAYEE 9 |  | 45 |  | 2012 | Emily
PAYEE 10 |  | 21 |  | ongoing | [NAME] |  | AVAILABLE INCOME
PAYEE 11 |  | 360 |  | 2014-07-01 00:00:00 | Emily
PAYEE 12 |  | 95 |  | till paid | Emily |  | BANK TOTAL
PAYEE 13 |  | 120 |  | ongoing | [NAME]
PAYEE 14 |  | 550 |  | ongoing | [NAME] |  | TOTAL PAID TO DATE
PAYEE 15 |  | 40 |  | 2011-07-01 00:00:00 | [NAME]
PAYEE 16 |  | 50 |  | ongoing | Emily |  | TOTAL LEFT TO PAY
PAYEE 17 |  | 35 |  | ongoing | Emily
PAYEE 18 |  | 40 |  | ongoing | Emily
PAYEE 19 |  | 12 |  | ongoing | Emily
PAYEE 20 |  | 158 |  | ongoing | [NAME] |  | SPARE OVERALL
PAYEE 21 |  | 12 |  | ongoing | [NAME]
Emily Total
Dean Total
Total
Spreadsheet: mary_fischer__25814__2 EES Cons 1CE 2CE variance analysis
Sheet: WHSEES4

EES - WHSEES4
(in millions)
DR/(CR)
(Income)/Loss
 | 1CE | 2CE | [NAME] |  | Reasons for variance
Net Income Before Tax | 830 | 762
Permanent Differences
Dividends | 0 | 0
Equity Earnings | 0 | 0
Foreign Operations | 0 | 0
Foreign Taxes | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
Other - Expense related to IC purchase | 0 | -20
Other - Reverse additional June revenue | 0 | 5
Total Permanent Differences
Temporary Differences
Depreciation, Depletion, & Amort. | 0 | -1
Partnership Equity | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
Price Risk Management | -249 | 165
Regulatory Contingencies | 0 | 0
Other - Rev of Purchase Price Write-off | 0 | -8
Other - Rev Management Overview | 0 | 4
Total Temporary Differences
Total State Taxable Income
Current State Tax Exp/(Bene) | 0 | 0
Total Federal Taxable (Income)/Loss
Current Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal | 91 | 91
Other State | 0 | 0
Other Foreign | 0 | 0
Total Current Tax Expense (Benefit)
Deferred Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal | -91 | -91
Other State | 0 | 0
Other Foreign | 0 | 0
Total Deferred Tax Expense (Benefit)
Total Tax Expense (Benefit)
Net (Income) / Loss
Effective Rate
Spreadsheet: 879135d1726581460-conditional-formatting-based-on-days-remaining-bloc-12th-floor-procurement-schedule
Sheet: Sheet1

 |  |  |  |  | Project: | Bloc 12th Floor Lift Lobby & WC's
 |  |  |  |  | Todays Date:
 |  |  |  |  | Project Start Date: | 2024-09-16 00:00:00
 | Procurement Schedule
Item | Description | Supplier / Subcontractor | Lead Time (wks) | Date Order Required | Actual Start Date
1 | Electrical | Imperial | 1 |  | 2024-09-16 00:00:00
2 | Ceiling & Partitioning Materials |  | 1 |  | 2024-09-25 00:00:00
3 | Timber Laminate Doors | Forza | 4 |  | 2024-10-02 00:00:00
4 | IPS Systems | Concept Cubicles | 4 |  | 2024-11-04 00:00:00
5 | Flooring | Bramhall | 1 |  | 2024-10-28 00:00:00
6 | Tiling Labour | [NAME] | 4 |  | 2024-11-11 00:00:00
7 | Tiling Materials | CTC | 3 |  | 2024-11-11 00:00:00
8 | Frameless Square Mirrors | [NAME] | 2 |  | 2024-11-25 00:00:00
9 | WC Accessories | [NAME] | 6 |  | 2024-11-25 00:00:00
10 | Circular Mirrors | Online
11 | Builders Clean | Kath | 2 |  | 2024-11-29 00:00:00
12 | [NAME] | Signs Express / Sign Supplier | 2 |  | 2024-11-18 00:00:00
Spreadsheet: 764541d1642782852-conditional-formatting-and-rolling-totals-sample
Sheet: Sheet1

2022-10-03 00:00:00 |  |  | 2022-10-10 00:00:00 |  |  | 2022-10-17 00:00:00 |  |  | 2022-10-24 00:00:00 |  |  | 2022-10-31 00:00:00 |  |  | 2022-11-07 00:00:00 |  |  | 2022-11-14 00:00:00 |  |  | 2022-11-21 00:00:00
5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5
5 |  |  | 2 |  |  | 5 |  |  | 4 |  |  | 5 |  |  | 5 |  |  | 3
Spreadsheet: 0fd99d65-5937-4af7-a6d9-ec343e89e1e8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259742 | 75759 | Michel | Uteau Berrios | CHI |  | 00:29:30 | 00:01:02 | 02:40:15 | 00:01:20 | 01:28:08 | 1 | 04:40:15
259742 | 75755 | Mario | Campos | CHI |  | 00:36:42 | 00:01:06 | 02:53:08 | 00:01:20 | 01:39:02 | 2 | 05:11:18
259742 | 75757 | Cesar | [NAME] | CHI |  | 00:41:21 | [NAME] | 03:02:25 | 00:01:11 | 01:43:45 | 3 | 05:30:24
259742 | 75613 | Pablo | Mendieta | ARG |  | [NAME] | 00:01:22 | 03:10:04 | [NAME] | 02:00:43 | 4 | 05:48:05
259742 | 75758 | Emilio | [NAME] | CHI |  | 00:50:16 | 00:01:58 | 03:25:18 | [NAME] | 01:59:19 | 5 | 06:17:28
259742 | 75756 | Rodrigo | Cordovero | CHI |  | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 731418d1620331837-dynamic-tab-reference-name-change-based-on-cell-value-example-sheet
Sheet: Facility 2 Shutdown

Facility | Date | Day
2 | 2021-01-02 00:00:00
2 | 2021-01-03 00:00:00
2 | 2021-01-04 00:00:00
2 | 2021-01-05 00:00:00
2 | 2021-01-06 00:00:00
2 | 2021-01-07 00:00:00
2 | 2021-01-08 00:00:00
2 | 2021-01-10 00:00:00
2 | 2021-01-17 00:00:00
2 | 2021-01-18 00:00:00
2 | 2021-01-24 00:00:00
2 | 2021-01-30 00:00:00
2 | 2021-02-14 00:00:00
2 | 2021-02-15 00:00:00
2 | 2021-02-20 00:00:00
2 | 2021-02-21 00:00:00
2 | 2021-03-07 00:00:00
2 | 2021-03-14 00:00:00
2 | 2021-03-28 00:00:00
2 | 2021-04-02 00:00:00
2 | 2021-04-03 00:00:00
2 | 2021-04-04 00:00:00
2 | 2021-04-05 00:00:00
2 | 2021-04-11 00:00:00
2 | 2021-04-12 00:00:00
2 | 2021-04-13 00:00:00
2 | 2021-04-15 00:00:00
2 | 2021-04-24 00:00:00
2 | 2021-04-25 00:00:00
Spreadsheet: 135683d1326184293-solved-unable-to-sort-by-date-after-vlookup-date-from-text
Sheet: Sheet1

Login | FirstName | LastName | Date Created | AuditStr | Login Cleanse | Date Cleanse | Date Cleanse
gatcl | [NAME] | Gatto | 22/09/2009 02:44 PM | Create
spear | [NAME] | [NAME] | 22/09/2009 02:44 PM | Create
thokr | [NAME] | Thomasson | 22/09/2009 02:44 PM | Create
[NAME] | [NAME] | Whalen | 22/09/2009 02:44 PM | Create
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
yeoem | [NAME] | Yeoman | 24/09/2009 10:05 AM | Create
mashu | Huw | Mason | 24/09/2009 10:05 AM | Create
brola | Lauraine | Brown | 24/09/2009 10:05 AM | Create
freln | [NAME] | Frederiksen | 24/09/2009 10:05 AM | Create
simro | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
oshbr | Briony | [NAME] | 24/09/2009 10:05 AM | Create
metcr | [NAME] | Metters | 24/09/2009 10:05 AM | Create
[NAME] | [NAME] | [NAME] | 23/09/2009 10:05 AM | Create
walgh | [NAME] | Walters | 24/09/2009 10:05 AM | Create
hawbr | [NAME] | Hawtin | 24/09/2009 10:05 AM | Create
kergr | Greg | [NAME] | 24/09/2009 10:05 AM | Create
gooro | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
hargr | Greg | [NAME] | 24/09/2010 10:05 AM | Create
robjh | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
schst | [NAME] | Schoemaker | 24/09/2009 10:05 AM | Create
setba | Bagus | Setiadi | 24/09/2009 10:05 AM | Create
morka | [NAME] | Morgenstern | 24/02/2009 10:05 AM | Create
warjo | Jon | Warby | 24/09/2009 10:05 AM | Create
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
piegr | Greg | Pietsch | 24/09/2009 10:05 AM | Create
smibe | Barrie | [NAME] | 24/09/2009 10:05 AM | Create
hinst | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
bisst | [NAME] | Bisset | 01/06/2009 10:05 AM | Create
comst | [NAME] | Comino | 24/09/2009 10:05 AM | Create
comgr | Greg | Comber | 24/09/2009 10:05 AM | Create
Spreadsheet: 768003d1644781438-sumif-range-len-split-range-test_rev01-jtm2019hyo-
Sheet: IE

 |  |  |  |  |  | FORMULA. | SHOULD |  | [NAME] |  | Test
1 |  | CDL-11
2 |  | CDT-11
3 |  | GE-11
4 |  | GE-12
5 |  | M-11
6 |  | M-12
7 |  | M-13
8 |  | SSTD-ADM12
9 |  | SSTD-EST13
10 |  | SSTD-EST15
11 |  | SSTD-PISC01
12 |  | SSTD-PISC02
13 |  | SSTD-PISC03
14 |  | SSTD-PISC04
15 |  | STD-AA11
16 |  | STD-AA12
17 |  | STD-AA13
18 |  | STD-AA14
19 |  | STD-AA21
20 |  | STD-AA22
21 |  | STD-AA31
22 |  | STD-AA32
23 |  | STD-AA33
24 |  | STD-AA41
25 |  | STD-AB11
26 |  | STD-AB12
27 |  | STD-AB13
28 |  | STD-AB14
29 |  | STD-AB21
30 |  | STD-AB22
31 |  | STD-AB31
32 |  | STD-AB32
33 |  | STD-AB33
34 |  | STD-AB34
35 |  | STD-AB41
36 |  | STD-AC11
37 |  | STD-AC12
38 |  | STD-AC13
39 |  | STD-AC14
40 |  | STD-AC21
41 |  | STD-AC22
42 |  | STD-AC31
43 |  | STD-AC32
44 |  | STD-AC33
45 |  | STD-AC41
46 |  | STD-ADM11
47 |  | STD-ADM12
48 |  | STD-ADM13
49 |  | STD-ADM14
50 |  | STD-ADM15
51 |  | STD-ADM21
52 |  | STD-ADM22
53 |  | STD-ADM23
54 |  | STD-ADM24
55 |  | STD-ADM31
56 |  | STD-ADM32
57 |  | STD-ADM33
58 |  | STD-ADM41
59 |  | STD-ADM42
60 |  | STD-ADM43
61 |  | STD-ADM44
62 |  | STD-ADM51
63 |  | STD-AUD11
64 |  | STD-AUD12
65 |  | STD-AUD13
66 |  | STD-AUD14
67 |  | STD-AUD15
68 |  | STD-AUD21
69 |  | STD-AUD31
70 |  | STD-AUD32
71 |  | STD-CAF11
72 |  | STD-CAF21
73 |  | STD-CAF31
74 |  | STD-CAF32
75 |  | STD-CAF33
76 |  | STD-CAF34
77 |  | STD-CIST01
78 |  | STD-CIST02
79 |  | STD-CIST03
80 |  | STD-EST11
81 |  | STD-EST12
82 |  | STD-EST13
83 |  | STD-EST14
84 |  | STD-EST15
85 |  | STD-INCD01
86 |  | STD-INCD02
87 |  | STD-INCD03
88 |  | STD-PISC01
89 |  | STD-PISC11
90 |  | STD-PISC21
91 |  | STD-T11
92 |  | STD-T12
93 |  | STD-T13
94 |  | STD-T14
95 |  | STD-T15
96 |  | STD-T16
97 |  | STD-T17
98 |  | STD-T18
99 |  | STD-T21
100 |  | STD-T22
101 |  | STD-T23
102 |  | STD-T24
103 |  | STD-T25
104 |  | STD-T26
105 |  | STD-T31
106 |  | STD-T32
107 |  | STD-T33
108 |  | STD-T34
109 |  | STD-T35
110 |  | STD-T36
111 |  | STD-T37
112 |  | STD-T41
113 |  | STD-VIV11
114 |  | TD-AA
115 |  | TD-AB
116 |  | TD-AC
117 |  | TD-ADM
118 |  | TD-AUD
119 |  | TD-CAF
120 |  | TD-CIST
121 |  | TD-EST
122 |  | TD-INCD01
123 |  | TD-PISC
124 |  | TD-SSEE
125 |  | TD-TALL
126 |  | TD-VIV
127 |  | TE-T33
128 |  | TE-T34
129 |  | TE-T35
130 |  | TE-T37
131 |  | [NAME]
132 |  | TG-12
133 |  | TGE-T31
134 |  | TTF-11
135 |  | TTF-12
Spreadsheet: chris_stokley__3931__Curves
Sheet: Sheet1

NP15 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00
PG&E Embedded Gen | 59.43256747708413 | 48.96865527254178 | 31.7827289284468 | 31.84309763270342 | 29.22609339285203 | 29.64585407564599 | 32.11372849889211
NP Wholesale Curve | 30.5 | 32.2 | 35.25 | 37.75 | 37.25 | 36 | 34.5
SP15
[NAME] | 73.81519703247416 | 42.45760704894467 | 41.77009755323155 | 41.1619741512337 | 41.51262476722149 | 41.88140505279726 | 41.91968559123667
SP Wholesale Curve | 30.35 | 31.5 | 31.85 | 34.65 | 35.25 | 34.75 | 33.75
Spreadsheet: 688312d1595703594-get-max-value-from-an-alphanumeric-range-with-criteria-get-max-value-from-alphanumeric-range-based-on-criteria
Sheet: Sheet1

 |  | Code | [NAME] Number
 |  | R | R00100
 |  | S | [NAME]
 |  | E | E00099
 |  |  | Serial Number
 |  |  | R00087
 |  |  | R00061
 |  |  | R00059
 |  |  | R00088
 |  |  | R00028
 |  |  | S00063
 |  |  | S00051
 |  |  | S00062
 |  |  | S00094
 |  |  | S00025
 |  |  | E00073
 |  |  | [NAME]
 |  |  | E00025
 |  |  | E00063
 |  |  | E00063
 |  |  | R00092
 |  |  | R00029
 |  |  | R00059
 |  |  | R00027
 |  |  | R00056
 |  |  | S00022
 |  |  | S00052
 |  |  | S00097
 |  |  | S00060
 |  |  | S00054
 |  |  | E00013
 |  |  | E00064
 |  |  | E00098
 |  |  | E00012
 |  |  | E00092
 |  |  | S00078
 |  |  | S00030
 |  |  | S00046
 |  |  | S00086
 |  |  | S00057
 |  |  | E00038
 |  |  | E00099
 |  |  | E00008
 |  |  | E00084
 |  |  | E00001
 |  |  | R00060
 |  |  | R00045
 |  |  | R00082
 |  |  | R00057
 |  |  | R00008
 |  |  | S00089
 |  |  | S00096
 |  |  | S00027
 |  |  | S00043
 |  |  | S00062
 |  |  | E00027
 |  |  | E00067
 |  |  | E00043
 |  |  | E00074
 |  |  | E00019
 |  |  | R00100
 |  |  | R00099
 |  |  | R00004
 |  |  | R00018
 |  |  | R00088
 |  |  | S00009
 |  |  | S00087
 |  |  | S00002
 |  |  | S00096
 |  |  | S00008
 |  |  | [NAME]
 |  |  | E00065
 |  |  | E00002
 |  |  | [NAME]
 |  |  | E00043
 |  |  | S00050
 |  |  | S00013
 |  |  | S00049
 |  |  | S00006
 |  |  | S00096
 |  |  | E00044
 |  |  | E00058
 |  |  | E00025
 |  |  | E00020
 |  |  | E00016
 |  |  | R00006
 |  |  | S00070
 |  |  | S00007
 |  |  | S00078
 |  |  | S00072
 |  |  | S00006
 |  |  | E00023
 |  |  | E00081
 |  |  | E00028
 |  |  | E00074
 |  |  | E00019
 |  |  | R00055
 |  |  | R00044
 |  |  | R00049
 |  |  | R00063
 |  |  | R00098
 |  |  | S00085
 |  |  | S00053
 |  |  | S00081
 |  |  | S00082
 |  |  | [NAME]
Spreadsheet: 675735d1588443673-use-data-in-multiple-cells-to-return-result-example
Sheet: Apr - Reg

 | Month | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM | 30
 | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Day | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol 1/2 FD | 20.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol 1/2 PD | 15
Child's Name | Parent's Name | Address
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Spreadsheet: vkaminski__40848__Psim2001
Sheet: Covar

 | Covar Data
 | H: coefficient relating power price movement to load: Price=Price0*exp(H*deltaLoad/Load) |  |  |  |  |  |  |  | 0.5
 |  | Long Dim | 3
 |  | Short Dim | 4
 | Long term vols and correlation for:
Dimension | LOAD | Power PRICE | Fuel Price
3 | 1 | 1 | 1 | TYPE |  |  | 1=LOG Normal, 0=Normal
Vol | 0.03 | 0.06 | 0.04
Correl | 1 | 0.5 | 0
 | 0.5 | 1 | 0
 | 0 | 0 | 1
 | SHORT Term Volatility
 | (daily-ized) for :
Dimension | TEMP | Actual Load | PRICE | Actual Price
4 | 0 | 1 | 1 | 1 | TYPE |  | 1=LOG Normal, 0=Normal
Vol | 1 | 0.001 | 0.2 | 0.001
Temp | 1 | 0 | 0 | 0
LoadAct | 100 | 1 | 0 | 0.8
Price | 100 | 100 | 1 | 0
PriceAct | 100 | 100 | 100 | 1
Spreadsheet: 217079d1361981711-export-without-code-test_example
Sheet: Total

TOTALS
 | Travel Int |  | 0
 | Travel GC |  | #N/A
 | Windsurf Expenses |  | #N/A
 | Social Security |  | #N/A
 | Telephone |  | 0
 | Business Dinners |  | #N/A
 | Assets |  | #N/A
 | Insurance |  | #N/A
 | TOTAL OUT GOING |  | #N/A
 | TOTAL INCOME |  | 0
 | BALANCE |  | #N/A
Spreadsheet: 887149d1737356831-find-all-matched-vlookup-returned-first-or-last-occurrence-i-need-all-matched-results-penalty
Sheet: Sheet1

 |  |  | =[@Registered]-[@Attended] | REQUIRED RESULTS HERE | =[@Penalty]*[@Absent]
Branch | Registered | Attended | Absent | Penalty | Plenty Amount |  | Branch | From | To | Penalty |  | Branch
A |  |  | 0 | 0 |  |  | A | 3 | 5 | 300 |  | A
A |  |  | 1 | 0 |  |  | A | 6 | 7 | 500 |  | B
A |  |  | 2 | 0 |  |  | A | 8 |  | 700 |  | C
A |  |  | 3 | 300 |  |  | B | 2 | 5 | 250 |  | D
A |  |  | 4 | 300 |  |  | B | 6 | 7 | 350 |  | E
A |  |  | 5 | 300 |  |  | B | 8 |  | 400 |  | F
A |  |  | 6 | 500 |  |  | C | 1 | 3 | 150
A |  |  | 7 | 500 |  |  | C | 4 | 6 | 270
A |  |  | 8 | 700 |  |  | C | 7 |  | 325
A |  |  | 9 | 700 |  |  | D | 1 | 2 | 75
A |  |  | 10 | 700 |  |  | D | 3 | 5 | 180
A |  |  | 11 | 700 |  |  | D | 6 | 8 | 225
A |  |  | 12 | 700 |  |  | D | 9 |  | 300
A |  |  | 13 | 700 |  |  | E | 1 | 5 | 900
A |  |  | 14 | 700 |  |  | E | 6 | 8 | 200
A |  |  | 15 | 700 |  |  | E | 9 | 12 | 800
A |  |  | 16 | 700 |  |  | E | 13 |  | 600
A |  |  | 17 | 700 |  |  | F | 1 | 6 | 500
B |  |  | 0 | 0 |  |  | F | 7 | 8 | 400
B |  |  | 1 | 0 |  |  | F | 9 | 11 | 100
B |  |  | 2 | 250 |  |  | F | 12 | 16 | 700
B |  |  | 3 | 250 |  |  | F | 17 |  | 300
B |  |  | 4 | 250
B |  |  | 5 | 250
B |  |  | 6 | 350
B |  |  | 7 | 350
B |  |  | 8 | 400
B |  |  | 9 | 400
B |  |  | 10 | 400
B |  |  | 11 | 400
B |  |  | 12 | 400
B |  |  | 13 | 400
B |  |  | 14 | 400
B |  |  | 15 | 400
B |  |  | 16 | 400
B |  |  | 17 | 400
C |  |  | 0 | 0
C |  |  | 1 | 150
C |  |  | 2 | 150
C |  |  | 3 | 150
C |  |  | 4 | 270
C |  |  | 5 | 270
C |  |  | 6 | 270
C |  |  | 7 | 325
C |  |  | 8 | 325
C |  |  | 9 | 325
C |  |  | 10 | 325
C |  |  | 11 | 325
C |  |  | 12 | 325
C |  |  | 13 | 325
C |  |  | 14 | 325
C |  |  | 15 | 325
C |  |  | 16 | 325
C |  |  | 17 | 325
D |  |  | 0 | 0
D |  |  | 1 | 75
D |  |  | 2 | 75
D |  |  | 3 | 180
D |  |  | 4 | 180
D |  |  | 5 | 180
D |  |  | 6 | 225
D |  |  | 7 | 225
D |  |  | 8 | 225
D |  |  | 9 | 300
D |  |  | 10 | 300
D |  |  | 11 | 300
D |  |  | 12 | 300
D |  |  | 13 | 300
D |  |  | 14 | 300
D |  |  | 15 | 300
D |  |  | 16 | 300
D |  |  | 17 | 300
E |  |  | 0 | 0
E |  |  | 1 | 900
E |  |  | 2 | 900
E |  |  | 3 | 900
E |  |  | 4 | 900
E |  |  | 5 | 900
E |  |  | 6 | 200
E |  |  | 7 | 200
E |  |  | 8 | 200
E |  |  | 9 | 800
E |  |  | 10 | 800
E |  |  | 11 | 800
E |  |  | 12 | 800
E |  |  | 13 | 600
E |  |  | 14 | 600
E |  |  | 15 | 600
E |  |  | 16 | 600
E |  |  | 17 | 600
F |  |  | 0 | 0
F |  |  | 1 | 500
F |  |  | 2 | 500
F |  |  | 3 | 500
F |  |  | 4 | 500
F |  |  | 5 | 500
F |  |  | 6 | 500
F |  |  | 7 | 400
F |  |  | 8 | 400
F |  |  | 9 | 100
F |  |  | 10 | 100
F |  |  | 11 | 100
F |  |  | 12 | 700
F |  |  | 13 | 700
F |  |  | 14 | 700
F |  |  | 15 | 700
F |  |  | 16 | 700
F |  |  | 17 | 300
Spreadsheet: 42451d1241018991-excel-2007-excel-2007-to-excel-2003-conversion-forum1
Sheet: Summary

Spirit Airlines Airports Conditions
Airport | Currently | Will soon be |  | Airport | Currently | Will soon be
ACY |  |  |  | MCO
ATL |  |  |  | MDE
AUA |  |  |  | MGA
BOG |  |  |  | MYR
BOS |  |  |  | NAS
BQN |  |  |  | ORD
CTG |  |  |  | PAP
CUN |  |  |  | PBI
DCA |  |  |  | PTY
DTW |  |  |  | PUJ
FLL |  |  |  | RSW
FPO |  |  |  | SAP
GUA |  |  |  | SDQ
KIN |  |  |  | SJO
LAS |  |  |  | SJU
LAX |  |  |  | STI
LGA |  |  |  | STT
LIM |  |  |  | SXM
MBJ |  |  |  | TPA
 | 0SM
 | M1/4SM
 | 1/16SM
 | 1/8SM
 | 3/16SM
 | 1/4SM
 | 5/16SM
 | 3/8SM
 | 1/2SM
 | 5/8SM
 | 3/4SM
 | 7/8SM
 | 1SM
 | 1 1/8SM
 | 1 1/4SM
 | 1 3/8SM
 | 1 1/2SM
 | 1 5/8SM
 | 1 3/4SM
 | 1 7/8SM
 | 2SM
 | 2 1/4SM
 | 2 1/2SM
 | 2 3/4SM
 | OVC001
 | OVC002
 | OVC003
 | OVC004
 | OVC005
 | OVC006
 | OVC007
 | OVC008
 | OVC009
 | BKN001
 | BKN002
 | BKN003
 | BKN004
 | BKN005
 | BKN006
 | BKN007
 | BKN008
 | BKN009
 | VV
 | 100
 | 200
 | 300
 | 400
 | 500
 | 600
 | 700
 | 800
 | 900
 | 1000
 | 1100
 | 1200
 | 1300
 | 1400
 | 1500
 | 1600
 | 1700
 | 1800
 | 1900
 | 2000
 | 2100
 | 2200
 | 2300
 | 2400
 | 2500
 | 2600
 | 2700
 | 2800
 | 2900
 | 3000
 | 3100
 | 3200
 | 3300
 | 3400
 | 3500
 | 3600
 | 3700
 | 3800
 | 3900
 | 4000
 | 4100
 | 4200
 | 4300
 | 4400
 | 4500
 | 4600
 | 4700
 | 4800
Spreadsheet: 784400d1655721613-countifs-formula-to-count-unique-text-with-multiple-criteria-sample
Sheet: Sheet1

START DATE | COURSE NAME | TRAINER | Hours | COURSE NAME | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
2022-04-20 00:00:00 | [NAME] 1 | Trainer 1 | 4 | [NAME] 1
2022-04-21 00:00:00 | [NAME] 1 | Trainer 1 | 4 | [NAME] 2
2022-05-20 00:00:00 | [NAME] 1 | Trainer 1 | 4 | [NAME] 3
2022-05-20 00:00:00 | [NAME] 1 | Trainer 1 | 4
2022-05-20 00:00:00 | [NAME] 2 | Trainer 1 | 1.5 | Trainer 1
2022-05-20 00:00:00 | [NAME] 2 | Trainer 1 | 1.5 | [NAME] 1 |  |  |  | 4 | 4 | 4
2022-05-21 00:00:00 | [NAME] 2 | Trainer 1 | 1.5 | [NAME] 2 |  |  |  |  | 3
2022-05-21 00:00:00 | [NAME] 2 | Trainer 1 | 1.5 | [NAME] 3
2022-06-20 00:00:00 | [NAME] 1 | Trainer 1 | 4 | Trainer 2
2022-06-20 00:00:00 | [NAME] 1 | Trainer 1 | 4 | [NAME] 1 |  |  |  |  | 4
2022-04-20 00:00:00 | [NAME] 2 | Trainer 2 | 1.5 | [NAME] 2 |  |  |  | 1.5 | 1.5 | 1.5
2022-04-20 00:00:00 | [NAME] 2 | Trainer 2 | 1.5 | [NAME] 3 |  |  |  |  |  | 0.5
2022-05-20 00:00:00 | [NAME] 2 | Trainer 2 | 1.5
2022-05-20 00:00:00 | [NAME] 1 | Trainer 2 | 4
2022-05-20 00:00:00 | [NAME] 1 | Trainer 2 | 4
2022-05-20 00:00:00 | [NAME] 1 | Trainer 2 | 4
2022-05-20 00:00:00 | [NAME] 2 | Trainer 2 | 1.5
2022-06-20 00:00:00 | [NAME] 2 | Trainer 2 | 1.5
2022-06-20 00:00:00 | [NAME] 3 | Trainer 2 | 0.5