tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155244d1336740155-vlookupish-query-vlookupish
Sheet: Spelling

 | Group | Raw Score | Spelling Age | +/- | 2011-09-21 00:00:00 | 2011-09-28 00:00:00 | 2011-10-05 00:00:00 | 2011-10-12 00:00:00 | 2011-10-19 00:00:00 | 2011-11-02 00:00:00 | 2011-11-09 00:00:00 | 2011-11-16 00:00:00 | 2011-11-23 00:00:00 | 2011-11-30 00:00:00 | 2011-12-07 00:00:00 | 2011-12-14 00:00:00 | 2012-01-11 00:00:00 | 2012-01-18 00:00:00 | 2012-01-25 00:00:00 | 2012-02-01 00:00:00 | 2012-02-08 00:00:00 | 2012-02-22 00:00:00 | 2012-02-29 00:00:00 | 2012-03-07 00:00:00 | 2012-03-14 00:00:00 | 2012-03-21 00:00:00 | 2012-04-25 00:00:00 | 2012-05-02 00:00:00 | 2012-05-09 00:00:00
Tyler B | Top | 33 | 8.11yrs |  | 6 | 16 | 7 | 1 | 1 | 5 | 13 | 11 | 11 | 10 | 12 | 10 | 12 | 10 | 6 | 16 | 14 | 16 | 16 | 16 | 16 | Ab | 15 | 16 | 13
[NAME] | Top | 34 | 9.02yrs |  | 8 | 16 | 12 | 16 | 16 | 13 | 15 | 16 | 14 | 14 | 16 | 16 | 15 | 13 | 15 | 16 | 16 | 16 | 16 | 16 | 14 | 16 | 14 | 14 | 15
Rhiana D | Top | 26 | 7.08yrs |  | 4 | 15 | 14 | 15 | 15 | 11 | 14 | 12 | 13 | 10 | 11 | 8 | 15 | 13 | 6 | 15 | 14 | 16 | 16 | 16 | 5 | 9 | 7 | 9 | 10
Summer H | Top | 31 | 8.07yrs |  | 6 | Ab | 11 | 15 | 13 | 13 | 12 | 12 | 14 | 6 | Ab | 16 | 15 | 9 | 5 | 16 | 16 | 14 | 15 | 14 | 9 | 10 | 9 | 16 | 9
Gabrielle H | Top | 23 | 7.03yrs |  | 6 | 10 | Ab | 10 | 10 | 4 | 8 | 12 | 14 | 6 | 10 | 12 | 15 | 7 | 13 | 16 | 14 | 14 | 14 | 16 | 16 | 13 | 15 | 16 | 11
Spreadsheet: 64257d1265132910-search-tabs-and-return-results-kc-environmental-aspects-and-impacts-worksheet-questions
Sheet: Process - Activity 3

Operating Condition | Process Evaluated |  | Date |  |  |  |  | Team
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
Spreadsheet: 798586d1664559292-case-sensitive-with-match-while-using-arrays-match1
Sheet: match-1array

UNMATCH |  | (check existing grades) |  | =SUMPRODUCT((1*ISNA(MATCH(A5:A1000,E5:E8,0))=1)*(A5:A1000<>"")*1) |  |  |  |  |  | case-unsensitive
 |  |  |  | =REDUCE(0,FILTER(A5:A1000,A5:A1000<>""),LAMBDA(a,b,a+ISNA(MATCH(TRUE,EXACT(b,E5:E8),0)))) |  |  |  |  |  | case-sensitive
grade |  |  |  | grade
A | 1 |  |  | A
A | 2 |  |  | B
B | 3 |  |  | b
C | 4 |  |  | C
D | 5
a | 6
F | 7
A | 8
A | 9
B | 10
B | 11
D | 12
A | 13
B | 14
Spreadsheet: james_steffes__12828__residental rate components
Sheet: CA

CALIFORNIA
 |  | Minimum charge per meter ($/month) a |  |  |  |  | Total Minimum |  | Distribution (/kWh) |  |  |  | Transmission |  | FTA -fixed transition amount (/kWh) | [NAME]. | Generation/Energy (/kWh) |  |  |  |  |  |  | Public Purpose Programs (/kWh) | Nuclear Decommission (/kWh) | Restructuring Implementation Rate l | CTC |  |  | Transmission Revenue Balancing  Acct. Adj. | PUC Reimbursement fee | Legislated rate reduction (%) |  | DWR procurement (/kWh) | Notes
 |  | Transmission | Distribution | Public Purpose | Generation | Nuclear decommissioning |  |  | Baseline (Tier I) | Nonbaseline/Tier II |  |  |  |  |  |  | Baseline | [NAME] (PGE) | 101-130% | 131-200% | 201-300% | over 300% |  |  |  |  | Baseline | Nonbaseline
 |  |  |  |  |  |  |  |  |  | Summer | Winter
PG&E |  |  |  |  |  |  |  |  | 3.663 | 4.735 | 4.735 | b | 0.505 |  | 1.01 | 0.275 | 5.699 | 6.359 |  |  |  |  | c | 0.386 | 0.051 |  |  |  | d | -0.156 | 0.012 | 0.1 | e |  | Tariff effective 7/1/01
SCE |  |  |  |  |  |  |  | f | 3.434 |  |  | g | 0.387 |  | 1.089 |  | 7.828 |  | 9.976 | 14.523 | 18.464 | 20.812 |  | 0.349 | 0.066 |  |  |  | h |  |  | 0.1 | e | 10.907 | Tariff effective 6/3/01
SDG&E |  |  |  |  |  |  |  | I | 3.94 | 5.154 | 4.442 |  | 0.541 | j | 1.239 | 0.151 |  |  |  |  |  |  | k | 0.352 | 0.065 | 0.147 | 0.053 | 1.294 | l |  |  |  |  |  | Tariff filed 7/2/01
Notes:
All charges are in cents unless otherwise noted
a) Charges are a per day rate - here a 30 day month is assumed
b) The non-baseline amount is the same year round
c) Generation is based on total rate less distribution, trans., PPP, ND and FTA (where applicable)
d) CTC is calculated residually by subtracting the "PX" charge from the generation charge. An alternative calculation exists where minimum charge is invoked.
e) Represents a 10% reduction in CTC. Those eligible for credit will repay the bonds or other ratemaking mechanism used to provide the credit.  It does not apply to increases in rates after 1/3/01.
f) The "min. charge" (here -the daily charge x 30) is applicable when when kWh used multiplied by a rate of $0.08282/kWh plus the applicable basic charge (currently $0.033) is less than the min. charge.
g) Distribution charge is the same for all usage amounts
h) Equal to Total Generation minus Averaged Procured Energy Charge
I) The Utility Distribution Company Total Rate is $0.170/day, here multiplied by 30 (days/month)
j) Includes Transmission Revenue Balancing Account Adjustment of 0.152/kWh and Trans. Access Charge Adjustment of 0.004/kWh
k) Market rates
l) The sum of rates for Internally and [NAME] Costs, Ongoing CTC and Reliability Must Run Generation Rates (it is unclear why [NAME] and CTC are listed again separately)
Spreadsheet: 677179d1589226724-using-countifs-in-data-validation-countifs-validation
Sheet: Sheet1

 | Skill | Item |  |  |  |  | Valid Activity | Activity | Item List | Available |  | Options
 | ARMOUR | SHIELD |  |  |  |  | ARMOUR | ARMOUR | BUCKLER | 0
 |  |  |  |  |  |  | WEAPONS | ARMOUR | CHAIN
 |  |  |  |  |  |  |  | ARMOUR | CUIRASS
 |  |  |  |  |  |  |  | ARMOUR | FULL PLATE
 |  |  |  |  |  |  |  | ARMOUR | GREAVES
 |  |  |  |  |  |  |  | ARMOUR | HAUBE
 |  |  |  |  |  |  |  | ARMOUR | HAUBERK
 |  |  |  |  |  |  |  | ARMOUR | HELM
 |  |  |  |  |  |  |  | ARMOUR | SHIELD | 0
 |  |  |  |  |  |  |  | WEAPONS | AXE
 |  |  |  |  |  |  |  | WEAPONS | BOW
 |  |  |  |  |  |  |  | WEAPONS | FALCHION | 0
 |  |  |  |  |  |  |  | WEAPONS | MACE
 |  |  |  |  |  |  |  | WEAPONS | SLING | 0
 |  |  |  |  |  |  |  | WEAPONS | SPEAR | 0
 |  |  |  |  |  |  |  | WEAPONS | SWORD
Spreadsheet: 81380d1281594464-excel-2007-advanced-addition-formula-test-catchment-auto-addition
Sheet: After

From | To | Numbers | Cumulative
 | 1
1 | 2 | 1 | 1
2 | 3 | 1 | 2
3 | 4 | 1 | 6 | <---- Any formula for this instead of
4 | 5 | 1 | 7 | manually adding D5, C6, D10, D13
 |  |  |  | & D16?
 | a
a | 3 | 1 | 1
 | b
b | 3 | 1 | 1
 | c
c | 3 | 1 | 1
Spreadsheet: 170920d1343497213-counting-sequences-trends
Sheet: sheet1

P/B |  | 1 | 2 | 0
2
2 |  |  |  |  |  | There are 1 consecutive P's
2 |  |  |  |  |  | There are 2 consecutive B's
2 |  |  | 2 |  |  | There are 0 consecutive T's
1
1
1 |  | 2
0
0
0
0
Spreadsheet: 217437d1362068114-using-address-with-vlookup-table_array-argument-address_vlookup
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 |  | 1 | a
 |  |  |  |  |  |  |  | 1 | b
1 | vlookup($a3;address(a$1;9):address(7;10);2;false) |  |  |  |  |  |  | 2 | c
2 |  |  |  |  |  |  |  | 2 | d
3 |  |  |  |  |  |  |  | 2 | e
4 |  |  |  |  |  |  |  | 3 | f
 |  |  |  |  |  |  |  | 4 | g
Spreadsheet: 868224d1714976525-combine-multiple-xlookups-with-multiple-if-statements-ifs-with-xlookup-query
Sheet: Sheet1

 | PO | WBS | CE | DT | Account
 | 3106050272 | N-0500100.24.03.06 | 422010
 |  | N-0500100.24.03.06 | 422000 | YD
 |  | [NAME] | 422005 |  |  |  | Lookup 1 |  |  | [NAME]
 |  | N-0500100.24.03.08 | 422006
 |  |  |  |  |  |  | 422010 | 24.23.03.06 |  | N-0500100.24.03.06 | 24.23.03.06
 |  |  |  |  |  |  | 422005 | 24.23.03.07 |  | N-0500100.24.03.08 | 24.23.03.08
Spreadsheet: 119719d1314689275-problems-calculating-with-1000000000000000-or-10-15-bug-or-ignorance
Sheet: Sheet1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 854654d1704453593-offset-values-and-identify-leftover-balance-cells-book2
Sheet: Example

 |  |  |  |  |  |  |  |  | Need this output through [NAME]
Ref No |  |  | Client Name | Address | Date | Amount |  |  | Cumulative Sum
1 |  |  | ABC | XYZ | 2022-04-14 00:00:00 | 370
2 |  |  | ABC | XYZ | 2022-04-15 00:00:00 | 650
3 |  |  | ABC | XYZ | 2022-05-19 00:00:00 | 1357
4 |  |  | ABC | XYZ | 2022-06-29 00:00:00 | 708
5 |  |  | ABC | XYZ | 2022-08-18 00:00:00 | 4200
6 |  |  | ABC | XYZ | 2022-09-15 00:00:00 | 1003
7 |  |  | ABC | XYZ | 2022-09-27 00:00:00 | 885
8 |  |  | ABC | XYZ | 2022-11-07 00:00:00 | 7080
9 |  |  | ABC | XYZ | 2022-11-25 00:00:00 | 944
10 |  |  | ABC | XYZ | 2022-12-07 00:00:00 | -17197
11 |  |  | ABC | XYZ | 2023-01-10 00:00:00 | 708 |  |  | Pending
12 |  |  | ABC | XYZ | 2023-02-04 00:00:00 | 550 |  |  | Pending
13 |  |  | ABC | XYZ | 2023-02-13 00:00:00 | 490 |  |  | Pending
14 |  |  | ABC | XYZ | 2023-03-15 00:00:00 | 1003 |  |  | Pending
15 |  |  | ABC | XYZ | 2023-03-15 00:00:00 | -1 |  |  | Pending
Spreadsheet: 54063d1254073089-problem-nesting-if-and-match-functions-tabla-tp1
Sheet: Sheet1

 | Instalation 12V
 | Item | Location | V | I | P | Length | Temp | Section | Section | Section AWG | Weight | Price
 |  |  | [v] | [amp] | [watt] | [ft] | [cº] | Thermal | Tension |  | [g/m] | [u$s/m]
 |  |  | 12 | 50 |  | 15 |  |  | 74.4047619047619 | #N/A
Spreadsheet: 806990d1669708574-transfer-of-data-from-a-master-sheet-to-other-sheets-quest
Sheet: cash in hand

Helper |  | Date | Description | Debit | Credit
Spreadsheet: 786448d1657197344-issue-counting-names-in-multiple-rows-book1
Sheet: Jul-22 (2)

 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 2021-07-04 00:00:00 |  |  |  |  |  |  |  |  | Alicia
 |  | Alicia, Ally | [NAME], [NAME] | [NAME] | Alicia | Team A |  |  |  |  | Ally
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  |  | [NAME]
 |  | [NAME] | Alicia | [NAME] | Ally | Team B
 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Phones |  | Ally | [NAME] | [NAME] | Ally | Team A
 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Phones |  | [NAME] | [NAME] | [NAME] | Ally | Team B
Spreadsheet: 140852d1328908610-summing-across-multiple-worksheets-machine-production-charts-ver-3
Sheet: Dashboard

2012-01-24 00:00:00 |  | Total Of each tab by adding values in Column F 7 - 8am row.
2012-01-25 00:00:00
2012-01-26 00:00:00
2012-01-27 00:00:00
2012-01-28 00:00:00
2012-01-29 00:00:00
2012-01-30 00:00:00
2012-01-31 00:00:00
2012-02-01 00:00:00
2012-02-02 00:00:00
2012-02-03 00:00:00
2012-02-04 00:00:00
2012-02-05 00:00:00
2012-02-06 00:00:00
2012-02-07 00:00:00
2012-02-08 00:00:00
2012-02-09 00:00:00
2012-02-10 00:00:00
2012-02-11 00:00:00
2012-02-12 00:00:00
2012-02-13 00:00:00
2012-02-14 00:00:00
2012-02-15 00:00:00
2012-02-16 00:00:00
2012-02-17 00:00:00
2012-02-18 00:00:00
2012-02-19 00:00:00
2012-02-20 00:00:00
2012-02-21 00:00:00
2012-02-22 00:00:00
2012-02-23 00:00:00
2012-02-24 00:00:00
2012-02-25 00:00:00
2012-02-26 00:00:00
2012-02-27 00:00:00
2012-02-28 00:00:00
2012-02-29 00:00:00
2012-03-01 00:00:00
2012-03-02 00:00:00
2012-03-03 00:00:00
2012-03-04 00:00:00
2012-03-05 00:00:00
2012-03-06 00:00:00
2012-03-07 00:00:00
2012-03-08 00:00:00
2012-03-09 00:00:00
2012-03-10 00:00:00
2012-03-11 00:00:00
2012-03-12 00:00:00
2012-03-13 00:00:00
2012-03-14 00:00:00
2012-03-15 00:00:00
2012-03-16 00:00:00
2012-03-17 00:00:00
2012-03-18 00:00:00
2012-03-19 00:00:00
2012-03-20 00:00:00
2012-03-21 00:00:00
2012-03-22 00:00:00
2012-03-23 00:00:00
2012-03-24 00:00:00
2012-03-25 00:00:00
2012-03-26 00:00:00
2012-03-27 00:00:00
2012-03-28 00:00:00
2012-03-29 00:00:00
2012-03-30 00:00:00
2012-03-31 00:00:00
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: BU53 KRE

 |  |  |  |  | BU53 KRE
Registration number : | BU53 KRE |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | VOLVO |  | 2003-11-27 00:00:00 | 12 Months | 2004-12-01 00:00:00 | 675
Specification : | 6 x 2 RCT (2 Axle) |  | 2004-11-30 00:00:00 | 12 Months | 2005-12-01 00:00:00 | 650
Type : | FM9 |  | 2005-11-30 00:00:00 | 12 Months | 2006-12-01 00:00:00 | 650
1st Registered : | 01.12.03 |  | 2006-11-30 00:00:00 | 12 Months | 2007-12-01 00:00:00 | 650
Engine : | [NAME] |  | 2007-11-30 00:00:00 | 12 Months | 2008-12-01 00:00:00 | 650
[NAME] : | 26,000kg |  | 2008-11-28 00:00:00 | 12 Months | 2009-12-01 00:00:00 | 650
 |  |  | 2009-11-30 00:00:00 | 12 Months | 2010-12-01 00:00:00 | 650
 |  |  | 2010-11-30 00:00:00 | 12 Months | 2011-12-01 00:00:00 | 650
 |  |  | 2011-11-30 00:00:00 | 12 Months | 2012-12-01 00:00:00 | 650
Back To Index
Spreadsheet: 271365d1381920726-inventory-and-stock-sheet-running-total-calculation-inventory-data
Sheet: S

Products | Price |  | Transaction
Dual Media Convertor | 3000 |  | Purchase
Single Media Convertor | 1800 |  | Sell
Media Convertor Rack | 2500
8 Port I-Ball | 1000
16 Port I-Ball | 1700
Cat-5 Cable I-Ball 2 Pair
16 Port TP-Link
6 [NAME]
9 [NAME]
15 U Box Wall Rack
15 U Box Floor Standing Rack
22 U Box Floor Standing Rack
FMS 48 Core
FMS 24 Core
Patch Panel Box
Termination Box
Enclosure
48 Fiber With Rope
48 Fiber Armored & Unarmored
24 Fiber Armored & Unarmored
12 Fiber Armored & Unarmored
48 CoreFiber  Unarmored
24 Core Fiber Unarmored
12 Core Fiber Unarmored
6 Core Fiber Unarmored
4 Core Fiber Unarmored
[NAME]
[NAME]
5 MM Steel Rope
4 MM Steel Rope
4.8 MM Steel Rope
Steel Clip 6 Core
Steel Clip 12 Core
Steel Clip 24 Core
Steel Clip 48 Core
[NAME] [[NAME]
Lock
3750 Cisco 24 Port Switch
2960 Cisco 24 Port Switch
2950 Cisco 24 Port Switch
Power Supply Cable
15 [NAME]
Cable Manager
Spreadsheet: 356046d1414953158-how-to-find-repeated-or-most-common-numbers-from-rows-max-repeat
Sheet: Sheet1

01 04 05 13 16 | 02 06 13 16 20 | 03 07 09 13 16 | 08 10 12 13 16 | 11 13 15 16 17 | 13 14 16 18 19
01 02 03 12 15 | 01 04 09 12 19 | 01 05 12 18 20 | 01 06 12 16 17 | 01 07 08 12 14 | 01 10 11 12 13
01 05 09 14 17 | 02 03 05 09 18 | 04 05 06 09 12 | 05 07 09 16 19 | 05 08 09 10 11 | 05 09 13 15 20
Spreadsheet: eric_saibi__9748__011602
Sheet: Gavin 01

Owner Name | AEP
Station Name | [NAME]
Unit Name | [NAME] 01
NERC Region | ECAR
State | OH
Fuel Type | Coal
Capacity | 1,300 MW
Start Date | 2002-01-16 00:00:00
End Date | 2002-01-18 00:00:00
Comments | Tube leak.
SIC | 4911
Plant ID | 1010019
Unit ID | 1003919
Outage ID | 19511
Spreadsheet: 729742d1619300100-auto-data-fatch-datebook1
Sheet: data

2021-04-10 00:00:00 | 10:00:00 | 16:00:00
2021-04-11 00:00:00 | 12:00:00 | 16:00:00
2021-04-12 00:00:00 | 12:00:00 | 16:00:00
2021-04-13 00:00:00 | 12:00:00 | 16:00:00
2021-04-14 00:00:00 | 12:00:00 | 16:00:00
2021-04-15 00:00:00 | 12:00:00 | 16:00:00
2021-04-16 00:00:00 | 12:00:00 | 16:00:00
2021-04-17 00:00:00 | 12:00:00 | 16:00:00
2021-04-19 00:00:00 | 12:00:00 | 16:00:00
2021-04-22 00:00:00 | 12:00:00 | 16:00:00
2021-04-23 00:00:00 | 12:00:00 | 16:00:00
2021-04-24 00:00:00 | 12:00:00 | 16:00:00
2021-04-25 00:00:00 | 12:00:00 | 16:00:00
2021-04-26 00:00:00 | 12:00:00 | 16:00:00
2021-04-27 00:00:00 | 12:00:00 | 16:00:00
2021-04-28 00:00:00 | 12:00:00 | 16:00:00
2021-04-29 00:00:00 | 12:00:00 | 16:00:00
2021-04-30 00:00:00 | 12:00:00 | 16:00:00
2021-05-03 00:00:00 | 12:00:00 | 16:00:00
2021-05-04 00:00:00 | 12:00:00 | 16:00:00
2021-05-05 00:00:00 | 12:00:00 | 16:00:00
2021-05-06 00:00:00 | 12:00:00 | 16:00:00
2021-05-07 00:00:00 | 12:00:00 | 16:00:00
2021-05-08 00:00:00 | 12:00:00 | 16:00:00
2021-05-09 00:00:00 | 12:00:00 | 16:00:00
2021-05-10 00:00:00 | 12:00:00 | 16:00:00
2021-05-11 00:00:00 | 12:00:00 | 16:00:00
2021-05-15 00:00:00 | 12:00:00 | 16:00:00
2021-05-16 00:00:00 | 12:00:00 | 16:00:00
Spreadsheet: 725391d1616665706-help-required-in-filter-formula-filter_formula_sample
Sheet: ExpectedResult

 | Date | 2021-02-01 00:00:00 | To | 2021-03-31 00:00:00
 |  | Assigned | Closed |  |  |  |  | S.No. | Ticket No. | Ticket type | Status | Assigned Date | Closed Date
 | Low |  |  |  |  | Filter formula -- >> |  |  | 2122 | Low | Closed | 2021-02-02 00:00:00 | 2021-02-05 00:00:00
 | Medium |  |  |  |  |  |  | 4 | 2226 | High | Closed | 2021-02-10 00:00:00 | 2021-03-15 00:00:00
 | High |  |  |  |  |  |  | 7 | 2137 | Medium | Closed | 2021-02-10 00:00:00 | 2021-03-02 00:00:00
 |  |  |  |  |  |  |  | 10 | 2242 | Low | Closed | 2021-03-18 00:00:00 | 2021-02-15 00:00:00
Spreadsheet: 781729d1653502714-how-to-index-match-a-cell-that-has-formula-with-another-sheet-reference-efwitherror-fixed-aligw-with-2-repeat
Sheet: Sheet2

ID | Start | End | Begin | Last |  | ID | Total Places |  | ID | Unique
101 |  |  |  |  |  | 101 |  | 30 | 101
102 |  |  |  |  |  | 102 | 3 |  | 102
103 |  |  |  |  |  | 103 | 5 |  | 103 | 2
101
Spreadsheet: 109843d1306633980-sum-different-cells-fruit-countif
Sheet: Sheet1

Helper 1 | Helper 2
First Row in Group | Last Row in Group | Item | Count/List
4 | 11 | APPLE | 4 | List 1
 |  | ORANGE | 2 | List 1
 |  | APPLE | 4 | List 1
 |  | BANANA | 1 | List 1
 |  | APPLE | 4 | List 1
 |  | PEAR | 1 | List 1
 |  | ORANGE | 2 | List 1
 |  | APPLE | 4 | List 1
13 | 16 | BANANA | 1 | List 2
 |  | ORANGE | 1 | List 2
 |  | PEAR | 1 | List 2
 |  | APPLE | 1 | List 2
18 | 20 | APPLE | 2 | List 3
 |  | APPLE | 2 | List 3
 |  | PEAR | 1 | List 3
22 | 0
Spreadsheet: 403da580-f596-4ee2-9e0c-d3c733f6872a
Sheet: Sheet1

STATE PROCUREMENT OFFICE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
NOTICE OF REQUEST FOR EXEMPTION FROM HRS CHAPTER 103D
TO: |  |  |  |  | Chief Procurement Officer
FROM:
 |  |  |  |  | Name of Requesting Department
Pursuant to HRS §103D-102(b)(4) and HAR chapter 3-120, the Department requests a procurement exemption for the following:
1.  Describe the goods, services or construction:
2.  Vendor/Contractor/Service Provider: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. Amount of Request:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $
4. Term of Contract: |  |  |  | From: |  |  |  |  | To: |  |  |  |  | 5. Prior SPO-007, Procurement Exemption (PE):
6.  Explain in detail, why it is not practicable or not advantageous for the department to procure by competitive means:
7. Explain in detail, the process that will be or was utilized in selecting the vendor/contractor/service provider:
8.  [NAME] the primary responsible staff person(s) conducting and managing this procurement.  (Appropriate delegated       procurement authority and completion of mandatory training required).       *Point of contact (Place asterisk after name of person to contact for additional information).
Name |  |  |  |  |  |  | Division/Agency |  |  |  |  | Phone Number |  |  |  | e-mail address
All requirements/approvals and internal controls for this expenditure is the responsibility of the department. I certify that the information provided above is, to the best of my knowledge, true and correct.
Department Head Signature:                                                                                                             Date:
For Chief Procurement Officer Use Only
Chief Procurement Officer (CPO) Comments:
_________________________________________________________________________________________
 | Department Head Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
For Chief Procurement Officer Use Only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Notice Posted:
Inquiries about this request shall be directed to the contact named in No. 8.  Submit written objection to this notice to issue an exempt contract within seven calendar days or as otherwise allowed from date notice posted to:
 |  |  |  |  |  |  | [EMAIL]
 |  |  |  |  |  |  | [EMAIL]
Chief Procurement Officer (CPO) Comments:
 |  |  | Approved |  |  |  |  | Disapproved |  |  |  |  |  | No Action Required
 |  |  |  |  |  |  |  |  |  |  |  | Chief Procurement Officer Signature                            Date
 |  |  |  |  |  |  |  |  |  |  |  |  | Chief Procurement Officer Signature
 |  |  | Chief Procurement Officer |  |  |  |  |  |  |  | Date
Spreadsheet: 266737d1379706620-formula-for-value-by-date-and-find-number-count-with-word-on-multiple-sheets-setup-exception-tracking-by-ae-example
Sheet: John

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception %
2013-03-31 00:00:00 |  |  |  |  |  |  | 0 | 47
2013-04-05 00:00:00 | Bankers Network Corp of America | Siamack Shariat | [NAME] | Octabiano | 37439 | paystub >30 | 1 | 70
2013-05-16 00:00:00 | Goodview Financial | [NAME] | [NAME] | Kwan | 38964 | paystub >30
2013-05-29 00:00:00 | Selection Realty & Mortgage | Hang Ngo | Hang Ngo | [NAME] | 39234 | missing prelim | 2 | 40
2013-06-03 00:00:00 | Gold House | [NAME] | [NAME] | Zhai | 39304 | asset stmt missing 2 pgs
2013-06-03 00:00:00 | Goodview Financial | [NAME] | [NAME] | [NAME] | 39331 | paystub >30
2013-06-07 00:00:00 | Happy Real Estate | [NAME] | [NAME] | Zhang | 39363 | missing prelim
2013-06-10 00:00:00 | Best Financial & Mgmt Co. | Dhiren Unadkat | [NAME] | Dhanki | 39455 | missing W2 & prelim, assets >45
2013-06-13 00:00:00 | Primary Realty & Finance | [NAME] | Julia Kong | Zhang | 39575 | missing prelim
2013-06-19 00:00:00 | Best Financial & Mgmt Co. | Dhiren Unadkat | [NAME] | Shteyn | 39688 | missing prelim
2013-06-26 00:00:00 | Goodview Financial | [NAME] | [NAME] | Tong | 39858 | paystub >30 | 7 | 17
2013-07-08 00:00:00 | Phoenix Real Estate Investment Corp. | [NAME] | [NAME] | [NAME] | 40100 | missing 2012 W2 | 1 | 19
2013-08-21 00:00:00 | Phoenix Real Estate Investment Corp. | [NAME] | [NAME] | [NAME] | 40910 | missing 2012 W2
2013-08-22 00:00:00 | Phoenix Real Estate Investment Corp. | [NAME] | [NAME] | Ibarra | 40946 | paystub >30 | 2 | 18
2013-09-18 00:00:00 | Gold House Realty & Mortgage | [NAME] | [NAME] | Ong | 41304 | asset >45 & paystub >30
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: EAST-CON-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ECTR (EGM) / LRC
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL