tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683605d1592843413-return-a-value-on-a-row-which-satisfies-a-condition-formulas
Sheet: Sheet1

Length ↓ / Diameter  → | 6 | 8 | 10 | 12 | 14 | 16
1000 | 10.02508738556673 | 5.871946100528567 | 4.211400677229841 | 2.000161962262141 | 1.505408209951998 | 1.130909303086452
900 | 12.32517790907409 | 7.25711649563905 | 5.209029234375978 | 2.473744106904616 | 1.856309216401486 | 1.397118535814626
600 | 13.37062102473855 | 7.892480471858927 | 5.648932609285289 | 2.668301492861927 | 2.011203399076348 | 1.513550458204409
400 | 14.23243567856045 | 8.41495158093445 | 6.020280881277645 | 2.862726066394936 | 2.145896223213431 | 1.616868531930135
250 | 15.09951449305406 | 8.956271788678006 | 6.410528271330596 | 3.060181355303883 | 2.301334100512764 | 1.741071017558297
175 | 20.06070309247687 | 11.94606793966054 | 8.521902870698204 | 4.070365298968864 | 3.045246130909925 | 2.302917635255948
150 | 20.11695228602526 | 11.99302378818789 | 8.559402333063796 | 4.098057209638839 | 3.071083081056553 | 2.326917291169926
Enter Length | 175
No. of holes
Diameter
Spreadsheet: sally_beck__33697__Metrics 0609
Sheet: New Products

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | GRM New Products
Results based on Activity through June 9, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 10
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0
- Exits |  | 0 |  | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 0 |  |  | 0.653 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 2 | 0.6 |  |  | 1 | 0.75 |  | 3 | 21.5 |  |  |  |  | 1 | 7.5
Identified Margin
Budget |  | 7.7 |  |  | 7.7 |  |  |  | 7.7 |  |  | 7.7 |  |  |  |  |  | 10.4
$ Coverage
$ millions
Spreadsheet: 40640d1239037771-comparing-sheets-cells-book1-2-1-
Sheet: dif

Diffrence-jan-09 -feb-2009
Roll no | Student name | Total
101 | rama | 200
102 | soma | 2
103 | bima | -25
104 | manja | 125
105 | seena | 277
106 | sesaa | 297
107 | kupla | 0
108 | chonu | 0
109 | paddu | -240
110 | menaka | 0
111 | chenmini | 27
112 | karku | 0
113 | [NAME] | 0
114 | kaadu | 0
115 | korethi | -301
116 | akku | 0
117 | saku | 0
118 | suru | 0
119 | [NAME] | 0
120 | siddu | 0
121 | lachhu | 0
122 | putti | 0
123 | [NAME] | 0
124 | godhu | 0
Spreadsheet: 273431d1382711053-sumproduct-or-countif-when-1-counting-between-dates-and-2-adding-the-values-that-fall-in-miles1
Sheet: Sheet1

Date | [NAME]
 |  |  |  |  |  | [NAME]
2013-10-01 00:00:00 | 10 |  |  |  | Jan
2013-10-02 00:00:00 | 5 |  |  |  | Feb
2013-10-03 00:00:00 | 3 |  |  |  | Mar
2013-10-04 00:00:00 | 2 |  |  |  | Apr
2013-10-05 00:00:00 | 13 |  |  |  | May
2013-10-06 00:00:00 | 1 |  |  |  | Jun
2013-11-01 00:00:00 | 5 |  |  |  | Jul
2013-11-08 00:00:00 | 9 |  |  |  | Aug
2013-11-15 00:00:00 | 5 |  |  |  | Sep
 |  |  |  |  | Oct
 |  |  |  |  | Nov
 |  |  |  |  | Dec
Spreadsheet: 673124d1587191970-how-to-display-the-latest-20-dates-from-a-data-sheet-golf-handicap-index-calculation-txt007_20200418
Sheet: Lastest20scores

Player
A |  |  |  |  |  | B |  |  |  |  |  | C |  |  |  |  |  | D
 | Average of differential |  |  |  |  |  | Average of differential |  |  |  |  |  | Average of differential |  |  |  |  |  | Average of differential
 | Handicap Index |  |  |  |  |  | Handicap Index |  |  |  |  |  | Handicap Index |  |  |  |  |  | Handicap Index
Date | Course | Score | Rating | Slope | Differential | Date | Course | Score | Rating | Slope | Differential | Date | Course | Score | Rating | Slope | Differential | Date | Course | Score | Rating | Slope | Differential
How to get the latest 20 games based on the date?
Spreadsheet: 174041d1344894354-autopopulate-table-in-sheet-1-when-entries-are-put-into-sheet-2-3-4-etc-autofill-table-on-another-sheet
Sheet: Sheet - 02

 |  | Sheet # | Sheet - 02
 |  | Key | AA | AB | AC | AD | AE |  | Done
1 | 1 | Sheet - 02 | 1 | 25 | 9 | no | ZA |  | Yes
2 | 1 | Sheet - 02 | 1 | 35 | 9 | no | ZA |  | Yes
3 | 1 | Sheet - 02 | 1 | 45 | 9 | no | ZA |  | Yes
4 | 1 | Sheet - 02 | 1 | 55 | 9 | no | ZA |  | Yes
5 | 1 | Sheet - 02 | 1 | 65 | 9 | no | ZA |  | Yes
6 | 1 | Sheet - 02 | 1 | 75 | 9 | no | ZA |  | Yes
7 | 1 | Sheet - 02 | 1 | 25 | 9 | no | ZB |  | Yes
8 | 1 | Sheet - 02 | 1 | 35 | 9 | no | ZB |  | Yes
9 | 1 | Sheet - 02 | 1 | 45 | 9 | no | ZB |  | Yes
10 | 1 | Sheet - 02 | 1 | 55 | 9 | no | ZB |  | Yes
11 | 1 | Sheet - 02 | 1 | 65 | 9 | no | ZB |  | Yes
12 | 1 | Sheet - 02 | 1 | 75 | 9 | no | ZB |  | Yes
13 | 1 | Sheet - 02 | 1 | 25 | 9 | no | ZC |  | Yes
14 | 1 | Sheet - 02 | 1 | 35 | 9 | no | ZC |  | Yes
15 | 1 | Sheet - 02 | 1 | 45 | 9 | no | ZC |  | Yes
16 | 1 | Sheet - 02 | 1 | 55 | 9 | no | ZC |  | Yes
17 | 1 | Sheet - 02 | 1 | 65 | 9 | no | ZC |  | Yes
18 | 1 | Sheet - 02 | 1 | 75 | 9 | no | ZC |  | Yes
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
 |  | Sheet - 02
Spreadsheet: 086dfbd8-bfcd-4533-861c-18c539ccfbfe
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FMATG | Test | FMATG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FMATG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FMATG | Result | FMATG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 267111d1379953180-lookup-then-find-within-a-range-then-output-see-file-index-match-if
Sheet: Sheet1

Diameter | Low | High | Name |  | Strictly Example data: actual data comprises of over 20,000 rows and so the solution cannot be manual.
52 | 12 | 14 | A
52 | 15 | 16 | B |  | In a separate tab;
52 | 17 | 19 | C |  | if the | Diameter = | 52 | 65
52 | 20 | 25 | D
65 | 12 | 14 | E |  | and the | Height = | 15.5 | 12.2
65 | 15 | 16 | F
65 | 17 | 19 | G |  | then I want the | Result = | B | E
65 | 20 | 25 | H
 |  |  |  |  | and so on… | My Example
 |  |  |  |  | i.e. looks up the diameter, then looks up which range the height falls into and outputs a "name"
Spreadsheet: 194313d1353100167-cells-blank-or-contain-spaces-sample-text-or-spaces
Sheet: Sheet1

PAYEE_NAME_1
[NAME] | 0 | 0
BANKOLE | 0 | 0
ELI | 0 | 0
JOSIE | 0 | 0
NAILA | 0 | 0
GALINA | 0 | 0
 | 0 | 0
I | 0 | 0
SYED | 0 | 0
DIENER | 0 | 0
LILY | 0 | 0
WENYANG | 0 | 0
MOHAMMAD | 0 | 0
RONGSHENG | 0 | 0
FELIZARDO | 0 | 0
 | 0 | 0
SHUZHEN | 0 | 0
Spreadsheet: 167875d1342127768-excel-2007-help-with-a-complicated-lookup-reference-array-formula-rowcol-lookup
Sheet: Sheet1

700
 |  | 1 | 2 | 3 | 4 | 5
 | a | 245 | 300 | 295 | 500 | 355
 | b | 225 | 325 | 425 | 525 | 625
 | c | 250 | 350 | 450 | 550 | 650
 | d | 275 | 375 | 0 | 575 | 675
 | e | 0 | 0 | 0 | 0 | 700
 | f | 0 | 0 | 0 | 0 | 0
Spreadsheet: 22049d1210441175-validation-data-example
Sheet: Sheet2

hosam | 1 |  |  |  |  | Class | Name | Value
nasser | 5 |  |  |  |  | Class A | hosam | 1
khaled | 3 |  |  |  |  | Class b | nasser | 5
nasser |  |  |  |  |  | Class A | khaled | 3
hosam | 2 |  | the Input data |  |  | Class b | nasser | 0
hany |  |  |  |  |  | Class A | hosam | 2
tamer |  |  |  |  |  | Class C | hany | 0
hany |  |  |  |  |  | Class b | tamer | 0
khaled | 7 |  |  |  |  | Class C | hany | 0
[NAME] | 8 |  |  |  |  | Class A | khaled | 7
 |  |  |  |  |  | Class A | khaled | 8
 |  |  |  |  |  |  |  |  |  | Sum of Value | Class
 |  |  |  |  |  |  |  |  |  | Name | Class A | Class b | Class C | Grand Total
 |  |  |  |  |  | Sum of Value |  |  |  | hany |  |  | 0 | 0
Class A |  |  |  |  |  | Class | Name | Total |  | hosam | 3 |  |  | 3
hosam | 3 |  |  |  |  | Class A | hosam | 3 |  | khaled | 18 |  |  | 18
khaled | 18 |  |  |  |  |  | khaled | 18 |  | nasser |  | 5 |  | 5
 |  |  |  |  |  | Class A Total |  | 21 |  | tamer |  | 0 |  | 0
 |  |  |  |  |  | Class b | nasser | 5 |  | Grand Total | 21 | 5 | 0 | 26
 |  |  |  |  |  |  | tamer | 0
 |  |  |  |  |  | Class b Total |  | 5
 |  |  |  |  |  | Class C | hany | 0
 |  |  |  |  |  | Class C Total |  | 0
Class B |  |  |  |  |  | Grand Total |  | 26
tamer
nasser | 5
 |  |  |  | The Output Data
Class C
hany
shady
[NAME]
Spreadsheet: 161934d1339675670-showing-cells-that-is-related-to-a-cell-multiple-result-formula-that-shows-each-store-when-clicked-data-validation
Sheet: Sheet1

Storename | Handled by this salesperson
MURAH | [NAME] |  |  | Yellow Column C
Cross | Ian |  |  | IF(B2=Sheet2!$A$1,COUNT($C$1:$C1)+1,"")
Soulmate | [NAME] |  |  | Then copy down
Generalized | [NAME]
Welcomm | [NAME]
The Alphabet | Wally
1 for 2 | [NAME]
Salesperson List
[NAME]
Ian
[NAME]
Wally
[NAME]
Spreadsheet: 672392d1586859127-login-logout-formula-login-logout
Sheet: Sheet3

People | In | Out | Date |  |  | 2020-01-01 00:00:00 |  | 2020-01-02 00:00:00
Girl 1 | 07:28:00 | 10:12:00 | 2020-01-01 00:00:00 |  |  | In | Out | In | Out
Girl 1 | 11:30:00 | 13:47:00 | 2020-01-01 00:00:00 |  | Guy 1
Girl 1 | 14:46:00 | 12:56:00 | 2020-01-01 00:00:00 |  | Guy 2
Guy 2 | 00:00:00 | 03:00:00 | 2020-01-01 00:00:00 |  | Guy 3
Guy 2 | 04:00:00 | 12:00:00 | 2020-01-01 00:00:00 |  | Girl 1
Guy 2 | 14:10:00 | 16:32:00 | 2020-01-01 00:00:00 |  | Girl 2
Guy 3 | 09:21:00 | 16:00:00 | 2020-01-01 00:00:00
Girl 2 | 02:51:00 | 03:07:00 | 2020-01-01 00:00:00
Girl 2 | 08:46:00 | 18:00:00 | 2020-01-01 00:00:00
Guy 1 | 06:59:00 | 14:20:00 | 2020-01-02 00:00:00
Guy 1 | 15:00:00 | 17:00:00 | 2020-01-02 00:00:00
Girl 1 | 09:18:00 | 03:52:00 | 2020-01-02 00:00:00
Girl 1 | 16:00:00 | 17:03:00 | 2020-01-02 00:00:00
Guy 3 | 05:58:00 | 13:05:00 | 2020-01-02 00:00:00
Guy 3 | 14:43:00 | 17:01:00 | 2020-01-02 00:00:00
Spreadsheet: 866356d1713291470-cell-content-in-3-columns-to-copy-into-a-new-4th-column-excel-forum-sample-2
Sheet: Sheet2

 | Existing Data |  |  |  |  | Desired | Finished | Result
 |  | 1 |  |  |  |  | 1
1 |  |  |  |  | 1
1 |  |  |  |  | 1
 |  | 1 |  |  |  |  | 1
 |  | 1 |  |  |  |  | 1
 | 1 |  |  |  |  | 1
1 |  |  |  |  | 1
 | 1 |  |  |  |  | 1
1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2
 |  | 1 |  |  |  |  | 1
 | 1 |  |  |  |  | 1
2 |  |  |  |  | 2
 |  | 2 |  |  |  |  | 2
 | 1 |  |  |  |  | 1
2 |  |  |  |  | 2
 |  | 3 |  |  |  |  | 3
 |  | 1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2
1 |  |  |  |  | 1
1 |  |  |  |  | 1
 | 3 |  |  |  |  | 3
Spreadsheet: 166489d1341600190-formula-problem-vlookup-combined-with-if-statement-excel-spreadheet-if-statement-with-vloolup
Sheet: Angel Count

Invoice Creation Date | Billing Specialist | Invoice Number | Sold To Customer | Comments | Contract Type
2012-07-05 00:00:00 | [NAME] | 1154516 | ADS INC |  | SAMPLE
2012-07-05 00:00:00 | [NAME] | 1154517 | ADS INC |  | SAMPLE
2012-07-05 00:00:00 | [NAME] | 1154345 | ALCO SRL |  | COMMERCIAL PO
2012-07-05 00:00:00 | [NAME] | 1154353 | KARDA SYSTEMS LLC 4Y9Y2 |  | COMMERCIAL PO
2012-07-05 00:00:00 | [NAME] | 1154353 | KARDA SYSTEMS LLC 4Y9Y2 |  | COMMERCIAL PO
2012-07-05 00:00:00 | [NAME] | 1154340 | MJL ENTERPRISES |  | COMMERCIAL PO
2012-07-05 00:00:00 | [NAME] | 1154344 | SEK SOLUTIONS |  | COMMERCIAL PO
2012-07-05 00:00:00 | [NAME] | 1154365 | TACTICAL DISTRIBUTORS LLC |  | COMMERCIAL PO
2012-07-05 00:00:00 | [NAME] | 1154312 | USAF AFMC |  | BPA GSA 5965P
2012-07-05 00:00:00 | [NAME] | 1154384 | USAF AFMC |  | EXCHANGE
2012-07-05 00:00:00 | [NAME] | 1154331 | USAF AFMC |  | BPA GSA 5965P
2012-07-05 00:00:00 | [NAME] | 1154332 | USAF AFMC |  | BPA GSA 5965P
2012-07-05 00:00:00 | [NAME] | 1154336 | USAF AFMC |  | BPA GSA 6072P
2012-07-05 00:00:00 | [NAME] | 1154325 | USAF AFMC |  | BPA GSA 0110X
2012-07-05 00:00:00 | [NAME] | 1154329 | USAF AFMC |  | BPA GSA 5965P
2012-07-05 00:00:00 | [NAME] | 1154330 | USAF AFMC |  | BPA GSA 5965P
2012-07-05 00:00:00 | [NAME] | 1154326 | USAF AFMC |  | BPA GSA 0110X
2012-07-05 00:00:00 | [NAME] | 1154380 | VICTOR FORWARD LLC |  | COMMERCIAL PO
2012-07-05 00:00:00 | [NAME] | 1154339 | VICTOR FORWARD LLC |  | COMMERCIAL PO
Spreadsheet: martin_cuilla__25355__Bid package1101_0302
Sheet: Sheet1

 |  |  |  | Eagle Gas Marketing Company (EAGLE), subsidiary of Mustang Fuel Corporation
 |  |  |  | 2000 [NAME], Oklahoma City, OK 73106-6036
 |  |  |  | Main  (405) 557-9475     Fax (405) 557-9427
 |  |  |  | Outside Okla. [PHONE], ext. 475
 |  |  |  | E-mail [EMAIL]
PHYSICAL GAS AVAILABLE
Terms are shown below .  All bids should be based on "Inside F.E.R.C.'s Gas Market Report" Index price.  All packages will be sold firm, subject to standard GISB force majeure
language.  Election by [NAME] not to process downstream of the Delivery Point, will not be considered a Force Majeure event.  The volume nominated to [NAME] prior to each month will be
a volume within the Quantity Range shown below.  Once the month begins,  the Quantity will be delivered as nominated on a firm basis.  If interested in bidding  on any of the packages
shown below,  please indicate your bid on this form or a similar form and return to EAGLE by regular mail, reply to this e-mail or facsimile on or before 5:00 PM CST Tuesday, September 11,
2001 ATTN:  GAS MARKETING DEPT.  Bids will be evaluated based on the following:  a) creditworthiness & past payment history  b) competitively priced bids with preference given
to greater of multi-pipe (where applicable) and bonus add-ons. c) service reliability and d) payment on or before the 25th by wire or ACH.
ALL BIDS SUBJECT TO FINAL APPROVAL BY EAGLE'S MANAGEMENT *Note: Please bid package 5a-d as one package with different index locations, if necessary.
 | PACKAGE | QUANTITY  RANGE (MMBTUD) |  | DELIVERY POINT(S) | WINTER BIDS NOV. 2001 THROUGH MARCH 2002 |  |  |  | 1 YEAR BID BEGINNING NOV. 1, 2001
 | OKLAHOMA PACKAGES
1 | Enogex(East) | 2,000 to 4,000 |  | Enogex pool
2 | Spring Valley Plt. | 7000 to 8,500 | 1) 7 months | 1) TOT (Transok) 2) ONG pool;
 |  |  | 2) 1 year | 3) *Tailgate meters into TOK or ONG
 |  |  |  | *pending OBA agmts.
3 | Northern (TOK) | 200 to 500 |  | [NAME]
4 | PEPL wellhead | up to 200 |  | [NAME]
5a | Reliant (Flex) | 4,500 to 6,000 |  | pool
5b | Reliant (South) | 300 to 500 |  | pool
5c | Reliant (North) | 1,000 to 2,000 |  | pool
5d | Reliant (WA-1) | up to 500 |  | pool
6 | Transok (TOG) | 1,000 to 4,000 |  | interconnect or transfer meter
 | TEXAS PACKAGES
7 | Gulfsouth ([NAME]) | 1,000 to 2,500 | 1) 7 months | Koch Area 8 & 9 pool & wellhead
8 | East TX Pipeline (Carthage) | 3,000 to 5,000 |  | Eagle's ETGS pool
9 | Trunkline | up to 300 | 1) 7 months | [NAME] no. 82653
10 | TGPL (Texas Zone 0) | 3,000 to 4,500 |  | various wellhead and inct. pts.
Spreadsheet: phillip_allen__29934__Post_offices
Sheet: port_a

Year | 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
Investment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1350000
Rent | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394 | 98394
Expenses | -10000
Debt Serv
Cash Flow
IRR
Sales Price |  | 1164000
Debt |  | 0.8
Loan Amount
Rate |  | 0.0725
Term |  | 25
Payment
Down Payment
Closing Cost
Cash to Close
Spreadsheet: 34b94475-39bc-4f0e-a27f-280fb2d7dd10
Sheet: Sheet1

Oglala Lakota College | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Application for Leave
Name: |  |  |  |  | Department:
Types of leave available, please list type of leave taken and number of hours of leave taken on
 | chart below.
Sick: (SL), Annual: (AL), Personal:(PL), Consulting: (CN), Compensatory: (CP), LWOP
 |  |  |  |  |  |  | Amount & Type
From: Date/Hour |  |  | To: Date/Hour |  |  | Total Time | of [NAME]
8:30:  April 11, 2008 |  |  | 5:00:  April 11, 2008 |  |  | 8 | PL
**I agree that any leave in excess of amount available to me will be LWOP (Leave Without Pay).
 | Applicant's Signature |  |  |  |  | Date
 | Supervisor Signature |  |  |  |  | Date
Approval ____________________ |  |  |  | Disapproved/Reason for: _________________________
 |  |  |  | ______________________________________________
Spreadsheet: 202614d1356646497-how-can-i-create-a-point-system-for-attendance-tardies-absents-etc-absent-solution
Sheet: Sheet1

Employees | october |  |  | november |  |  |  | Total
 | Tardies | Excused Call-ins | Unexcused call-ins | Tardies | Excused call-ins | Unexcused call-ins |  |  |  | Tardies | 0.5
[NAME] | 0 | 1 | 2 | 3 | 2 | 6 |  |  |  | Excused Call-ins | 1
[NAME] | 1 | 1 | 0 | 0 | 0 | 2 |  |  |  | Unexcused call-ins | 3
[NAME] | 4 | 2 | 1 | 1 | 1 | 1
Sue | 0 | 1 | 2 | 3 | 7 | 1
Employees | october |  |  | november |  |  |  | Total
 | Tardies | Excused Call-ins | Unexcused call-ins | Tardies | Excused call-ins | Unexcused call-ins |  |  |  | Tardies | 0.5
[NAME] | 0 | 1 | 2 | 3 | 2 | 6 |  |  |  | Excused Call-ins | 1
[NAME] | 1 | 1 | 0 | 0 | 0 | 2 |  |  |  | Unexcused call-ins | 3
[NAME] | 4 | 2 | 1 | 1 | 1 | 1
Sue | 0 | 1 | 2 | 3 | 7 | 1
Weight
Spreadsheet: 867019d1713928920-how-can-i-add-value-based-on-two-different-variables-example
Sheet: Sheet5

Sum of Count of Rating |  |  |  |  | Score | 1 through 6 | 7, 8 | 9, 10 |  | This should be my results
Region | Rating | Total |  |  | NA |  |  | 81
ANZ | 1 | 18 |  |  | EMEA |  |  | 235
 | 2 | 1 |  |  | ANZ |  |  | 8
 | 4 | 2
 | 6 | 1
 | 9 | 1
 | 10 | 7 |  |  | Work table
ANZ Total |  | 30
EU | 1 | 7 |  |  | Score | 1 through 6 | 7, 8 | 9, 10
 | 2 | 12 |  |  | NA |  |  | x |  | What is the right formula?
 | 3 | 23 |  |  | EMEA |  |  | x
 | 4 | 4 |  |  | ANZ |  |  | x
 | 5 | 13
 | 6 | 9
 | 7 | 12
 | 8 | 45
 | 9 | 77
 | 10 | 158
EU Total |  | 360
NA | 1 | 11
 | 2 | 17
 | 3 | 175
 | 4 | 7
 | 5 | 12
 | 6 | 3
 | 7 | 11
 | 8 | 12
 | 9 | 22
 | 10 | 59
NA Total |  | 329
Grand Total |  | 719
Spreadsheet: 825925d1681649326-checkbox-concatenate-formula-on-text-problem-checkboxes-aligw
Sheet: Sheet1

 |  |  | True | True | False | False |  |  |  | False
 |  |  | 300 | 301 | 302 | 303 | 304 | 305 | 306 | 307 | 308 | 309 | 310
 |  | 301,
AliGW:
Spreadsheet: 120616d1315408271-months-counting-problem-in-pivot-table-791292
Sheet: Sheet1

Year | Month | Shipment | Date
2010 | 1 | 143 | 2010-01-01 00:00:00 |  |  | Sum of Shipment
2010 | 2 | 254 | 2010-02-01 00:00:00 |  |  | Date | Total
2010 | 3 | 345 | 2010-03-01 00:00:00 |  |  | 2010-01-01 00:00:00
2010 | 4 | 26 | 2010-04-01 00:00:00 |  |  | 2010-02-01 00:00:00 | 0.7762237762237763
2010 | 5 | 365 | 2010-05-01 00:00:00 |  |  | 2010-03-01 00:00:00 | 0.358267716535433
2010 | 6 | 46 | 2010-06-01 00:00:00 |  |  | 2010-04-01 00:00:00 | -0.9246376811594202
2010 | 7 | 170 | 2010-07-01 00:00:00 |  |  | 2010-05-01 00:00:00 | 13.03846153846154
2010 | 8 | 34 | 2010-08-01 00:00:00 |  |  | 2010-06-01 00:00:00 | -0.873972602739726
2010 | 9 | 97 | 2010-09-01 00:00:00 |  |  | 2010-07-01 00:00:00 | 2.695652173913043
2010 | 10 | 88 | 2010-10-01 00:00:00 |  |  | 2010-08-01 00:00:00 | -0.8
2010 | 11 | 94 | 2010-11-01 00:00:00 |  |  | 2010-09-01 00:00:00 | 1.852941176470588
2010 | 12 | 150 | 2010-12-01 00:00:00 |  |  | 2010-10-01 00:00:00 | -0.09278350515463918
2011 | 1 | 46 | 2011-01-01 00:00:00 |  |  | 2010-11-01 00:00:00 | 0.06818181818181818
2011 | 2 | 109 | 2011-02-01 00:00:00 |  |  | 2010-12-01 00:00:00 | 0.5957446808510638
2011 | 3 | 68 | 2011-03-01 00:00:00 |  |  | 2011-01-01 00:00:00 | -0.6933333333333334
2011 | 4 | 234 | 2011-04-01 00:00:00 |  |  | 2011-02-01 00:00:00 | 1.369565217391304
2011 | 5 | 200 | 2011-05-01 00:00:00 |  |  | 2011-03-01 00:00:00 | -0.3761467889908257
2011 | 6 | 68 | 2011-06-01 00:00:00 |  |  | 2011-04-01 00:00:00 | 2.441176470588236
2011 | 7 | 301 | 2011-07-01 00:00:00 |  |  | 2011-05-01 00:00:00 | -0.1452991452991453
2011 | 8 | 155 | 2011-08-01 00:00:00 |  |  | 2011-06-01 00:00:00 | -0.66
2011 | 9 | 97 | 2011-09-01 00:00:00 |  |  | 2011-07-01 00:00:00 | 3.426470588235294
2011 | 10 | 377 | 2011-10-01 00:00:00 |  |  | 2011-08-01 00:00:00 | -0.4850498338870432
2011 | 11 | 201 | 2011-11-01 00:00:00 |  |  | 2011-09-01 00:00:00 | -0.3741935483870968
2011 | 12 | 70 | 2011-12-01 00:00:00 |  |  | 2011-10-01 00:00:00 | 2.88659793814433
 |  |  |  |  |  | 2011-11-01 00:00:00 | -0.46684350132626
 |  |  |  |  |  | 2011-12-01 00:00:00 | -0.6517412935323383
 |  |  |  |  |  | Grand Total
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 10d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, January 11 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].