tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103320d1301063689-pivot-look-up-but-with-changing-dates-sal-sales-trial
Sheet: Sales Chart data

Sale Chart
 |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  | 52
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  | 53
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  | 18
 | Average
Spreadsheet: 71502d1272278404-excel-2007-transfer-specific-lines-to-other-chart-cello
Sheet: Veicules

 |  | Veicules Caracteristics
 |  | Type | Brand | Km
 |  | Sedan | Peugeot | 300 |  |  |  |  |  | Type
 |  | Van | Mercedes | 400 |  |  |  |  | Brand | SUV
 |  | Sedan | Mercedes | 500 |  |  |  |  | Jeep | 410
 |  | Truck | Mercedes | 620 |  |  |  |  | Volvo | 150
 |  | Coupe | Mazda | 320
 |  | SUV | Volvo | 150
 |  | SUV | Jeep | 410
Spreadsheet: 689718d1596617169-extract-data-from-different-cells-based-on-colour-question1
Sheet: Sheet1

What I have:
 | A | B
X | 10 | 11
Z | 5 | 11
Y | 1 | 6
What I want:
Red | Yellow | Blue
X-A | Z-A | Y-A
X-B | Y-B
What I want (alternative):
Red | Red | Yellow | Yellow | Blue | Blue
X | A | Z | A | Y | A
X | B | Z | B
Spreadsheet: 887949d1738263079-how-to-extend-sumifs-to-new-data-how-to-append-items-into-a-list-excel-forum-sumifs-help-questions
Sheet: Sheet1

Order Number | Name | Amount | Order Items | Total NUMBER  Orders from person | TotAL REVENUE from person | All Order Items Ever List
1 | AA | 110 | A, B |  |  | A,B,D,E,F,G,H
2 | BB | 130 | C,A
3 | AA | 120 | D,E
4 | CC | 80 | F
5 | BB | 80 | F
6 | CC | 140 | G, H
7 | AA | 80 | F
8 | AA | 140 | G,H
9 | BB | 80 | F
10 | DD | 50 | I
Spreadsheet: 39722d1238004826-lookup-question-inv-try-two_1-1
Sheet: Search

This is what I am looking for.
Search range
From | To
1001 | 001222 | 7
005001 | 005100 | 5
Output
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
Spreadsheet: 724452d1616165604-lookup-text-over-multi-column-and-row-array-to-return-row-number-lookup-value-over-multi-column-and-row-array
Sheet: Sheet1

 | [NAME] | [NAME] |  | Parent | Child | Child 2 | Child 3 | Child 4
 | Parent Output Manual | Jo |  | Ami | [NAME] | [NAME] | [NAME] | [NAME]
 | Parent Output Formula |  |  | Jo | [NAME] | [NAME] | [NAME] | Dom
 |  |  |  | Ian | [NAME] | Eva | [NAME] | Ash
Spreadsheet: 86839d1286810667-how-can-i-compare-graph-data-copy-loan-20graph
Sheet: Sheet1

 |  | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
 | Title | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00
 | Total Loan Portfolio | 2353162.49 | 2408010.2 | 2438359.59 | 2344688 | 2269460 | 2214212.2 | 2134904.14 | 2111438.11 | 2096520.6 | 2097126.89 | 2107095.97 | 2054523.21
 | Title | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00
 | Total Loan Portfolio | 2046569.94 | 2100778.67 | 2114325.16 | 1999116.75 | 1959855.86 | 1899040.64 | 1876900.12 | 1855027.57 | 1830799.83 | 1843748.3 | 1798441.43 | 1767807.69
Spreadsheet: 741332d1626974653-problem-creating-statuses-based-on-populated-cells-statustest-doc
Sheet: Sheet1

Object 1 | Object 2 | Current Status | Step 1 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8 | Step 9 | Step 10 | Step 11
 |  |  | 2021-06-06 00:00:00 | 2021-06-18 00:00:00 | 2021-06-22 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-28 00:00:00 | 2021-07-01 00:00:00 | 2021-07-03 00:00:00 | 2021-07-04 00:00:00 | 2021-07-22 00:00:00
 |  |  | 2020-04-01 10:00:00 | 2021-07-05 11:22:48 |  |  | 2021-07-05 11:22:48
 |  |  | 2020-04-01 11:00:00 |  |  | 2021-04-30 11:21:02 | 2021-07-05 11:24:02
 |  |  | 2020-04-01 13:00:00 | 2021-07-05 11:23:12 |  |  | 2021-07-05 11:23:12
 |  |  | 2020-04-01 14:00:00 | 2021-07-05 11:23:25 |  |  | 2021-07-05 11:23:25
 |  |  | 2020-04-01 15:00:00 | 2021-07-05 11:23:40 |  |  | 2021-07-05 11:23:40
 |  |  | 2021-04-01 11:00:00 |  |  | 2021-04-30 11:21:02 | 2021-07-05 11:24:02
Spreadsheet: 846537d1697711488-cross-checking-between-two-lists-excel-forum-1-
Sheet: Sheet1

First List | Second List | [NAME] downwards
XXL-S-M-L-XL | XXL-M-L-XL-3XL | True
XXL | XXL-XL | True
3XL | 4XL-3XL-S-M-L-XL-XXL | True
XXL-S-M-L-XL | S-M-L-XL | True
XL | XXL-S-M-XL | True
XXL-S-XL-3XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-M-L-XL | S-M-XL | True
XXL | XXL-3XL-S-M-L-XL | True
XL | S-XL | True
XL | S-XL | True
S-XL | XL | True
XXL-3XL-S-M-L-XL | XXL-3XL-S-M-L-XL | True
XXL-XL | XXL | True
S-M-L-XL | XXL-S-M-L-XL | True
S-M-XL | [NAME] | True
XL | XXL-S-M-L-XL | True
XXL | S | False
XXL-XL | XXL-3XL | True
XXL-S-M-L-XL | XXL-XL-S-M-L | True
XXL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-M-L-XL | XXL-S-3XL | True
XXL-S-M-L-XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-M-L-XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-XL | XXL-S-M-L-XL-3XL-4XL | True
S | XXL-3XL-S-M-L-XL | True
S-XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-M-XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-M | S-XL | False
XXL-S-M-L-XL-3XL-4XL | XXL-S-XL | True
XXL-S-XL-4XL | XL-XXL | True
XXL-S | S-M-L-XL-XXL-3XL | True
XXL-S-XL-3XL-4XL | S-XL | True
XXL-S-3XL-4XL | S | True
XXL-S-M-L-XL | XXL-S-M-XL | True
S | S-M-L-XL-XXL-3XL | True
XXL-S-M-XL | S-M-XL | True
S | XXL-S-M-XL | True
S | S-M-XL | True
S | XXL-S | True
XXL-XL-3XL-4XL | XXL-S-XL | True
S-L | XXL-XL | False
Spreadsheet: 56121d1256231378-calculating-sub-totals-for-different-cost-centres-costcentretest
Sheet: Sheet1

October | Cost Centre | Income | Wages | Materials
 | main | 100 | 20 | 1.25
 | red | 56 | 21.5 | 3
 | blue | 11 | 18 | 2.5
 | red | 32 | 29 | 5.25
 | green | 78 | 13.5 | 1
 | red | 108 | 15 | 0
 | blue | 93 | 19 | 0.5
 | main | 42 | 19 | 6
 | pink | 56 | 22 | 0.25
 | pink | 88 | 18 | 0.75
 | pink | 100 | 20 | 1.25
 | blue | 56 | 21.5 | 3
 | pink | 11 | 18 | 2.5
Sub-totals:
 | main | 142 | 39 | 7.25
 | red | 88 | 36.5 | 3
 | blue | 104 | 37 | 3
 | green | 78 | 13.5 | 1
 | pink | 255 | 78 | 4.75
i.e. subtotals are the following sums:-
 | main | C2+C9 | D2+D9 | E2+E9
 | red | C3+C5+C7 | D3+D5+D7 | E3+E5+E7
 | blue | C4+C8+C13 | D4+D8+D13 | E4+E8+E13
 | green | C6 | D6 | E6
 | pink | C10+C11+C12+C14 | D10+D11+D12+D14 | E10+E11+E12+E14
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME] | fire at Milagro on 15th has prevented payback
NNG |  |  |  | Dollar Valued | [NAME] | working on 10,000/d to sell
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
NGPL |  |  |  | Volumetric | [NAME] | received 35,000 mmbtus in payback in 7/01
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Red Cedar |  |  |  | Volumetric | [NAME] | [NAME] is talking to Red Cedar about cash out
SoCal |  |  |  | Volumetric | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME] | 108,000 mmbtus received in payback in 7/01
EOG |  |  |  | Dollar Valued | [NAME] | 47,000 mmbtus received in payback in 7/01
[NAME] |  |  |  | Dollar Valued | [NAME] | 6/30/01 bal of $887,643.73 invoiced-not rec'd as of 7/27/01
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Oasis |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME] | scheduling 3,000/d in payback
PG&E Topock |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Calpine |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 712828d1610438768-how-to-calculate-daily-average-test
Sheet: Sheet2

Date | ID | Count | Y/N | Daily Average | Working Day | ID & Day Wise Avg. | Date Wise Total Sum |  | Manually Calculated
2021-01-01 00:00:00 | 1311 | 31.99999999999999 | No |  |  |  |  |  | Date | ID | Count | Y/N | Daily Average | Working Day | ID & Day Wise Avg. | Date Wise Total Sum | [NAME]. | [NAME]
2021-01-01 00:00:00 | PS1555 | 60.00000000000001 | Yes |  |  |  |  |  | 2021-01-01 00:00:00 | 1311 | 31.99999999999999 | No | 0
2021-01-01 00:00:00 | 1466 | 46.00000000000001 | Yes |  |  |  |  |  | 2021-01-01 00:00:00 | PS1555 | 60.00000000000001 | Yes
2021-01-01 00:00:00 | PS1558 | 44 | Yes |  |  |  |  |  | 2021-01-01 00:00:00 | 1466 | 46.00000000000001 | Yes
2021-01-02 00:00:00 | PS1555 | 57 | Yes |  |  |  |  |  | 2021-01-01 00:00:00 | PS1558 | 44 | Yes
2021-01-02 00:00:00 | PS1558 | 42 | Yes |  |  |  |  |  | 2021-01-02 00:00:00 | PS1555 | 57 | Yes
2021-01-02 00:00:00 | 1465 | 23 | Yes |  |  |  |  |  | 2021-01-02 00:00:00 | PS1558 | 42 | Yes
2021-01-03 00:00:00 | 1465 | 49 | Yes |  |  |  |  |  | 2021-01-02 00:00:00 | 1465 | 23 | Yes
2021-01-03 00:00:00 | PS1558 | 50.00000000000001 | Yes |  |  |  |  |  | 2021-01-03 00:00:00 | 1465 | 49 | Yes
2021-01-03 00:00:00 | PS1585 | 61 | Yes |  |  |  |  |  | 2021-01-03 00:00:00 | PS1558 | 50.00000000000001 | Yes
2021-01-03 00:00:00 | 705 | 6 | No |  |  |  |  |  | 2021-01-03 00:00:00 | PS1585 | 61 | Yes
 |  |  |  |  |  |  |  |  | 2021-01-03 00:00:00 | 705 | 6 | No | 0
 |  |  |  |  |  |  |  |  |  |  | *color just for better understanding
 |  |  |  |  |  | based to column D (Y/N), if yes then find the average of a particular date, if No then take the Yes to get the average of a particular date.
 |  |  |  |  |  | if the NO changed to YES then it should include automatically to get the average.
Spreadsheet: 859302d1707735617-weighted-avg-cost-of-debt-hedge-avg-weighted-cost-of-debt
Sheet: Sheet1

 | Hedging
 | Essentially you have entered into a swap and will pay the fixed swap rate and receive the floating rate
 | Swap Rate | 0.0359
 | Rate |  |  | 0.0655575126636044 | 0.06540580142514121 | 0.06533263565157851
 | Notional Amount / Profile |  |  | 62725446.37702945 | 63098444.0561285 | 63472860.63993054
 | Pay Leg
 | [NAME]
 | Net
 | Debt |  |  | 120000000 | 120000000 | 120000000
 |  | 0.0615
 | Net Payment
 | Weighted Average Cost of Debt
 | Weighted Average Cost of Debt
Spreadsheet: 196537d1354033277-pulling-information-from-one-sheet-to-another-trackingphys
Sheet: Sheet1

[NAME] | Brent | Scott | Mine | [NAME] | Lance | To run Report 1-2-11 | home daily | Retion radar | Directed |  |  |  |  | Has Disc | Annual | 2010 | 2011 |  | I need all Physicals, CDLs and [NAME] that are before (But
[NAME] at hire | Div/Passport exp | Hire Date | Code | Truck | FMT | Driver | Home # | Cell # | Home Town | State | HM | Phy Exp | CDL Exp. | HM Exp | Review | Birth-Date | Yr. |  | not equal to) the date of 2/1/13.
10+ | OTR | 2008-06-11 00:00:00 | 6910 | 1134 | Mitch | [NAME] |  | 1800-67563 |  |  |  | 2013-01-02 00:00:00 | 2013-09-08 00:00:00 | 2014-05-25 00:00:00 |  | 2012-01-02 00:00:00 | 1950
10 | OTR | 2012-11-21 00:00:00 | 60194 | 1192 | Mitch | [NAME] |  | [PHONE] |  |  |  | 2012-07-16 00:00:00 | 2012-01-23 00:00:00 | 2015-11-21 00:00:00 |  | 2012-01-03 00:00:00 | 1961
1.5 | OTR-R | 2009-08-05 00:00:00 | 6087 | 1241 | Brent | [NAME] |  | [PHONE] |  |  |  | 2013-07-18 00:00:00 | 2013-05-05 00:00:00 | 2013-01-03 00:00:00 |  | 2012-01-16 00:00:00 | 1951
Spreadsheet: 55177d1255345184-filter-by-only-first-4-numbers-copy-of-malchemist-1-
Sheet: 31523

Date of Order | Date of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080319 | 2008-03-19 | 228673 | Cordless rotary hammer TE 6-A | 1 | 185.93 | 124538 | 31523
20080319 | 2008-03-19 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 77.5499999999999 | 124538 | 31523
20080319 | 2008-03-19 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.59 | 124538 | 31523
20080319 | 2008-03-19 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.59 | 124538 | 31523
Spreadsheet: 55276d1255428703-searching-for-text-book1
Sheet: Sheet1

 |  | Enter word: | rt
fgrs |  | 0
sd |  | 0
vc |  | 0
rf |  | 0
rs |  | 0
g |  | 0
[NAME] |  | 0
rt |  | 1
hbrt |  | 1
b |  | 0
rt |  | 1
bgf |  | 0
b |  | 0
fdb |  | 0
t |  | 0
hbrt |  | 1
rt |  | 1
htr |  | 0
g |  | 0
 |  | 0
vbfd |  | 0
[NAME] |  | 1
gb |  | 0
rtg |  | 1
tr |  | 0
gb |  | 0
ds |  | 0
[NAME] |  | 1
fbvtr |  | 0
gb |  | 0
tr |  | 0
grt |  | 1
g |  | 0
er |  | 0
gf |  | 0
ds |  | 0
vbfd |  | 0
df |  | 0
sv |  | 0
fd |  | 0
Spreadsheet: theresa_staab__39597__Producer Pricing Detail Nov01
Sheet: Internal Xfer Summary

ENA-ACCRUAL
Activity Summary
IF CIG Rockies
IF NGPL - Midcont.
 |  |  |  | Purchases |  |  |  | Xfer to ENA DENVER |  |  |  |  |  |  |  |  |  |  | MMBtu |  |  |  |  | should be 0 | should = column j
 | Producer | Type | Volume | Index | Total Netback | $/MMBtu | Total $ | Index | Index Disc./Prem. | Gathering | $/Mmbtu | [NAME] | $ Revenue | Gross CIG GD Vol |  | % of Total CIG GD |  | Net volume | allocation | Sale | Purch | [NAME] | Exp | diff |  | GD resale
 | [NAME] | FOM/Box Draw |  | CIG GD |  |  |  | CIG GD
 |  | FOM/S. Kitty |  | CIG GD |  |  |  | CIG GD
 |  | FOM/Box Draw |  | IF NGPL-Midcont. |  |  |  | IF NGPL-Midcont.
 |  | FOM/S. Kitty |  | IF NGPL-Midcont. |  |  |  | IF NGPL-Midcont.
 |  | FOM/S. Kitty |  | IF CIG |  |  |  | IF CIG
 |  | FOM/Box Draw |  | IF CIG |  |  |  | IF CIG
 |  | Add'l GD +.10 Box Draw |  | CIG GD |  |  |  | CIG GD
 |  | Add'l GD + .10 S. Kitty |  | CIG GD |  |  |  | CIG GD
 |  | Add'l GD - discount Box Draw |  | CIG GD |  |  |  | CIG GD
 |  | Add'l GD - discount [NAME] |  | CIG GD |  |  |  | CIG GD
 | Independent |  |  | CIG GD |  |  |  | CIG GD
 |  |  |  | IF NGPL-Midcont. |  |  |  | IF NGPL-Midcont.
 |  |  |  | IF CIG |  |  |  | IF CIG
 | MTG |  |  | CIG GD |  |  |  | CIG GD | 0
 |  |  |  | IF CIG |  |  |  | IF CIG | 0
 | Phillips |  |  | CIG GD |  |  |  | CIG GD
 |  |  |  | IF NGPL-Midcont. |  |  |  | IF NGPL-Midcont.
 |  |  |  | IF CIG |  |  |  | IF CIG
 | Wellstar | FOM |  | CIG GD |  |  |  | CIG GD
 |  | FOM |  | IF NGPL-Midcont. |  |  |  | IF NGPL-Midcont.
 |  | FOM |  | IF CIG |  |  |  | IF CIG
 |  | Add'l |  | IF CIG |  |  |  | IF CIG
 |  | FOM |  | CIG GD |  |  |  | CIG GD
 |  | FOM |  | IF CIG |  |  |  | IF CIG
 |  | Add'l |  | IF CIG |  |  |  | IF CIG
 |  |  |  | CIG GD |  |  |  | CIG GD
 | Citation |  |  | CIG GD |  |  |  | IF CIG |  |  |  |  |  |  |  |  | Citation
Purchase from CGS sale to ENA | CGS (gain)
 |  |  |  |  |  | Total Purchases |  |  |  |  | Total Sales to ENA Denver
Sale to CGS | CGS (Fuel/Loss) |  |  |  |  |  |  | CIG GD-.14 | 0.14
 |  |  |  |  |  |  |  |  |  |  | xfer price
 |  |  | Volume
Total Production Purchases
Total Sales to ENA DENVER |  |  |  |  |  |  |  | Kennedy Consolidation Summary
 |  |  |  |  |  |  |  |  | Sitara  # | WA Prem. ([NAME].) | WA Gathering Cost
Total Sales to CGS |  |  |  |  |  |  |  | FOM NGPL | 265881
 | Net Position |  |  | Buy/Sell Net : |  |  |  | FOM CIG | 272502
 |  |  |  |  |  |  |  | FOM CIG GD | 265902
CGS Gathering |  |  |  |  |  |  |  | Add'l CIG GD + .10 | 1019833
FT. Union Gathering |  |  |  |  |  |  |  | Add'l CIG GD - Disc. | 1073420
 |  |  |  | Gathering Net:
 |  |  |  | Net ENA ACCRUAL Activity:
Spreadsheet: 191346d1352079078-rank-and-sort-excluding-0-in-sort-field-qualifying-test-answer
Sheet: Sheet1

Qualifying Position | Name | Q1 | Q2 | Q3 | Qualifying Average | Help1 | Help2 | Help3 | Try This
5 | Todd H | 26.789 | 23.56 | 22.546 |  |  |  |  |  | <<Sorted on the colum from Small to Large
1 | [NAME] | 28 | 23 | 25
2 | Vic A | 26 | 25 | DNF
8 | Todd P | 25.543 | 26.875 | 30.56
9 | Will R | 30.56 | 26.875 | 25.543
6 | M Hook | 27.8 | 27.9 | 30
4 | [NAME] | 23 | DNF | 45
3 | [NAME] | 27 | DNF | DNF
7 | [NAME] | DNF | DNF | DNF
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Options AA

 | Options
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  | 71500
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  | 0 |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 3
 |  |  |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 1
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 877177d1723855585-need-help-with-sumif-statement-excel-conditional-sumif-1-
Sheet: SCORECARD

Quick WVI Calculator
Good Credentials & Permissions
Bad/No Credentials or Permissions | 0
Critical | 17
High | 60
Medium | 14
Low | 2
WVI
Access Rate
Spreadsheet: 846472d1697651151-sum-values-in-between-hour-intervals-total-by-interval
Sheet: Sheet1

HOUR | Instances |  |  | From |  | Expected Result
 | 34 |  | AM Shift | 06:00:00
01:00:00 | 36 |  | PM Shift | 14:00:00 |  | Shift | Total
02:00:00 | 22 |  | Night Shift | 22:00:00 |  | AM Shift | 551
03:00:00 | 16 |  |  |  |  | PM Shift | 463
04:00:00 | 14 |  |  |  |  | Night Shift | 219
05:00:00 | 25
06:00:00 | 31
07:00:00 | 41
08:00:00 | 91
09:00:00 | 116
10:00:00 | 80
11:00:00 | 44
12:00:00 | 68
13:00:00 | 80
14:00:00 | 74
15:00:00 | 72
16:00:00 | 46
17:00:00 | 81
18:00:00 | 66
19:00:00 | 35
20:00:00 | 44
21:00:00 | 45
22:00:00 | 36
23:00:00 | 36
Spreadsheet: 118124d1313480811-conditional-statement-krish
Sheet: Sheet1

CREDIT APPROVAL MEMORANDUM FOR SELF HELP GROUPS
APPLICANT DETAILS
NAME OF THE SHG
ADDRESS |  |  |  |  |  |  |  |  | TEHSIL |  |  |  |  | DISTRICT |  | MADURAI
STATE |  | [NAME] |  |  | DATE |  |  |  | ZONE |  | SOUTH |  |  | PINCODE
FILE NO. |  | 118 |  | NAME OF OFFICE BEARERS |  |  |  | JAYANTHI&KALAISELVI |  |  |  |  |  | TELEPHONE
SM NAME |  | ANANDA KUMAR |  |  |  |  | TYPE OF SHG |  | CREDIT LINKED 1 |  |  |  |  | FI DATE
NAME OF THE SHPI |  |  |  | MADURAI NON FORMAL EDUCATION CENTER |  |  |  |  | SHPI RECOMANDATION |  |  |  | POSITIVE |  | FI RECOMANDATION |  |  | POSITIVE
KYC details of Applicant
 |  | Document Accepted |  |  |  |  |  |  |  | Document Accepted |  |  |  |  |  |  | [NAME]
ID Proof |  | Bank Pass Book with photograph issued by SBI and its subsidiaries or Nationalised Banks |  | 8 |  |  |  | Address Proof |  | Bank Pass Book with photograph issued by SBI and its subsidiaries or Nationalised Banks |  |  |  |  |  |  | YES
SOURCING DETAILS
PRODUCT SCHEME |  |  | Linking of Self-Help Groups through SHPI as ICICI Bank Intermediary |  |  |  |  |  | PURPOSE |  | INCOME GENERATING LOAN |  |  |  |  | [NAME] |  | 12
LOAN APPLIED |  |  | 350000 | DISBURSEMENT MODE |  |  |  | DIRECT CREDIT | RELATION OF SHG/SHG MEMBERS WITH ICICI GROUP CO. DIRECTOR |  |  |  |  |  |  |  |  | YES
[NAME] |  |  | ECS/AUTO DEBIT | 8 | PROCESSING FEE |  |  | 0.01 |  | [NAME] PATTERN |  |  |  | MONTHLY
COF |  | SHPI PAYOUT |  |  | 0.02 |  |  |  |  | PENAL INTEREST |  |  | Applicable Rate+2% |  | SANCTIONED INT RATE
BORROWER NORMS
NAME OF SHG
CREDIT RELATION  WITH  BANK |  |  |  |  | FRESH |  |  | REMARKS:
IF CREDIT [NAME], THEN LOAN CYCLE |  |  |  |  | CREDIT LINKED 1
SCORE CARD SHG |  |  |  |  | 80
SHPI SCORE CARD |  |  |  |  | 76
EXISTING CC/RF |  |  |  |  | YES
EXISTING CC/RF LIMIT |  |  |  |  | 10000
IF TL, STATUS |  |  |  |  | OPEN
Existing TL Outstanding |  |  |  |  | 1000
MAXIMUM [NAME]
CORPUS WITH SHG |  |  |  |  | 5000
MINIMUM CORPUS |  |  |  |  | YES
NO. OF MEMBERS |  |  |  |  | 20
DUE [NAME] REPORT |  |  |  |  | POSITIVE
DE – DUPE |  |  |  |  | MATCH FOUND
RBI DEFAULTER |  |  |  |  | NO
CATEGORY OF CLIENT |  |  |  |  | Farmer carrying allied [NAME] activity
FUNDING LIMIT
0
POLICY COMPLIANCE
GO
SANCTIONING AUTHORITY
 |  | SHG = SHPI
 |  | [NAME]
 |  | Minus Existing CC Limit
 |  |  |  |  |  |  |  | 0.005
 |  |  |  |  |  |  |  | 0.01
 | No go | IF Corpus is less than 5K
 | No go | IF any TL is running A25
 | Go
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
Spreadsheet: 838670d1691243808-summing-columns-with-multiple-if-statement-if-statment_v2
Sheet: List1

 | surova iverica
 | DOL | ŠIR | KOS | CORE |  | HPL 1 | HPL 2 | OPOMBA | SUM HPL 1 | SUM HPL 2 | SUM HPL 3 |  |  | SHOULD BE [NAME]
POLICA | 1.5 | 1 | 1 |  | M2 | 1 |  |  |  |  |  | M2 |  | 1.5
SPREDNJA | 2.5 | 1 | 1 |  | M2 |  | 1 |  |  |  |  | M2 |  | 2.5
LEVO/DESNO | 3.5 | 1 | 1 |  | M2 |  | 2 |  |  |  |  | M2 |  | 0
ZADNJA | 4.5 | 1 | 1 |  | M2 | 2 |  |  |  |  |  | M2 |  | 0
STROP | 5.5 | 1 | 1 |  | M2 | 1 | 1 |  |  |  |  | M2 |  | 0
POLICA | 6.6 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 13.2
 |  |  | IVERICA SKUPAJ |  | M2 |  |  | UTP SKUPAJ |  |  |  | M2