tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 8d8f32fb-29e8-4839-abd3-e4bec9d15d88
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3711 | 18158 | [NAME] | Brkic | SRB | 0 | 00:20:41 | 00:00:00 | 01:12:29 | 00:00:00 | [NAME] | 1 | 02:12:14
3711 | 21430 | Anja | [NAME] | SVK | 0 | 00:24:09 | 00:00:00 | 01:11:37 | 00:00:00 | [NAME] | 2 | 02:17:20
3711 | 21432 | [NAME] | [NAME] | AUS | 0 | 00:25:56 | 00:00:00 | 01:14:57 | 00:00:00 | [NAME] | 3 | [NAME]
3711 | 21431 | Jelena | Luksic | CRO | 0 | 00:25:39 | 00:00:00 | 01:32:40 | 00:00:00 | 00:45:53 | 4 | 02:44:12
3711 | 21433 | Maja | Simlesa | CRO | 0 | [NAME] | 00:00:00 | 01:31:04 | 00:00:00 | 00:54:58 | 5 | 02:50:10
3711 | 21434 | Visnja | Skevin | CRO | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
3711 | 21435 | Kristinka | [NAME] | CRO | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 847641d1698483938-value-error-on-using-sort-filter-test2
Sheet: Result

 | Depo-1 | APPLE INC | 197.35 |  |  | APPLE INC | 0 | 197.35
 | Depo-2 | World Bank | 898 |  | Depo-2 | World Bank | 0 | 898
 | Depo-3 | [NAME] | 959.62 |  | Depo-3 | [NAME] | 0 | 959.62
 | Depo-4 | Lustiana | 61977.08 |  | Depo-4 | Lustiana | 0 | 61977.08
 | Depo-5 | WOE | 452 |  | Depo-5 | WOE | 0 | 452
 | Depo-5.1 | Dish | 6536 |  | Depo-5.1 | Dish | 0 | 6536
 | Depo-5.2 | [NAME] | 1245 |  | Depo-5.2 | [NAME] | 0 | 1245
 | Depo-6 | Custo Rica | 81196 |  | Depo-6 | Custo Rica | 0 | 81196
 | Depo-7 | THE WOLD IS GONE | 1547428.48 |  | Depo-7 | THE WOLD IS GONE | 0 | 1547428.48
 | Depo-10 | ABC | 2664 |  | Depo-10 | ABC | 0 | 2664
 | Depo-15 | LOSS ANGELES,TEXAS | 4664 |  | Depo-15 | LOSS ANGELES,TEXAS | 0 | 4664
Spreadsheet: 08bef3e4-b7a4-4063-b929-1a9f32e5eb12
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6929 | 15682 | [NAME] | [NAME] | RUS | 159 | 00:11:56 | 00:00:00 | 00:24:29 | 00:01:18 | 00:18:03 | 1 | 00:55:48
6929 | 46691 | Pertti | Tuomainen | FIN | 158 | 00:12:42 | 00:00:00 | 00:25:27 | 00:01:33 | 00:20:27 | 2 | 01:00:10
6929 | 21752 | Kaarel | [NAME] | EST | 161 | 00:12:55 | 00:00:00 | [NAME] | 00:02:03 | 00:20:07 | 3 | 01:02:25
6929 | 39243 | [NAME] | Billingsley | USA | 160 | 00:14:02 | 00:00:00 | 00:28:57 | 00:03:59 | [NAME] | 4 | 01:20:19
6929 | 7910 | Antti | Mustonen | FIN | 0 | 00:12:52 | 00:00:00 | 00:45:38 | 00:02:46 | 00:20:59 | 5 | 01:22:16
6929 | 47074 | Matti | Makinen | FIN | 0 | 00:12:43 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 271909d1382104878-count-of-hours-worked-by-hour-of-day-hours-tracking-example
Sheet: Sheet1

 |  |  |  | 0 | 1 | 0
Agent | Date | Day of Week | Hours Worked | Help | Start | Stop | 08:00:00
 | 2013-01-01 00:00:00 |  |  | 00:00:00 | 16:00:00 | 20:00:00
 |  |  |  | 00:00:00 | 10:00:00 | 18:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
 |  |  |  | 00:00:00
Spreadsheet: 2c9fbdb8-e407-429c-8978-5a589f91f364
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | KAMU NET BORÇ STOKU (*)
 |  |  |  |  |  |  |  |  | (Milyar TL)
 |  | KAMU BRÜT İÇ BORÇ STOKU | [NAME] DIŞ BORÇ STOKU | KAMU BRÜT TOPLAM BORÇ STOKU (I) | TCMB NET VARLIKLARI (II) | [NAME] (III) (**) | İŞSİZLİK SİGORTASI FONU NET VARLIKLARI (IV) | KAMU NET TOPLAM BORÇ STOKU (I - II - III - IV) | KAMU NET TOPLAM BORÇ STOKU / GSYH (%)
 | 2000 | 54.4926979 | 31.33247416728698 | 85.82517206728697 | 11.0041807974283 | 2.667035994778 | 0.362098 | 71.79185727508066 | 43.07734884053382
 | 2001 | 125.6451245917039 | 63.91105738511924 | 189.5561819768232 | 22.85408781080138 | 5.07468116252 | 2.182248 | 159.4451650035018 | 66.37351383711356
 | 2002 | 155.2062261320602 | 102.0184041392348 | 257.2246302712951 | 25.37477699956719 | 11.264884052612 | 4.954368000000001 | 215.6306012191159 | 61.52505340036755
 | 2003 | 202.1079884320033 | 95.57769567214832 | 297.6856841041516 | 24.7334949997425 | 13.05333027306301 | 8.928983999999998 | 250.9698748313461 | 55.18481704229023
 | 2004 | 235.1048161391412 | 97.94459919587122 | 333.0494153350124 | 27.89131599975 | 17.23494354104959 | 13.317211778 | 274.6059440162128 | 49.12159591885344
 | 2005 | 259.8010621934591 | 91.53070947117455 | 351.3317716646336 | 30.79301402900001 | 32.22287088663889 | 18.02913602752 | 270.2867507214747 | 41.65103134918361
 | 2006 | 268.2861341188563 | 97.60456487297085 | 365.8906989918272 | 45.68501819899791 | 38.25606516130001 | 23.747812004389 | 258.2018036271402 | 34.0460101391719
 | 2007 | 273.2620708158823 | 82.25691385387161 | 355.5189846697539 | 41.76906033299822 | 34.60330594314996 | 30.7052430932525 | 248.4413753003532 | 29.46486401797063
 | 2008 | 295.7871624679082 | 112.4447669434 | 408.2319294113082 | 60.37104713199773 | 41.51597207367884 | 38.35246350851612 | 267.9924466971156 | 28.19387586458762
 | 2009 | 347.3784325114471 | 118.311177246621 | 465.6896097580682 | 65.99515913099772 | 47.71326438264791 | 42.09528420823305 | 309.8859020361895 | 32.53195225201598
 | 2010 | 368.9339127839299 | 128.1694586933359 | 497.1033714772659 | 86.21601386599768 | 47.16550674087125 | 45.93887917121913 | 317.7829716991778 | 28.92092829765902
 | 2011 | 387.5662055697601 | 158.8758896860338 | 546.4420952557939 | 143.1623685810071 | 59.76158348377228 | 53.52126160241914 | 289.9968815885953 | 22.34676192919222
 | 2012 | 408.3673381211901 | 154.4680790337868 | 562.8354171549768 | 189.5015276969973 | 71.60980951402236 | 61.16243052581913 | 240.561649418138 | 16.97924236556688
 | 2013 | 430.2506843542614 | 193.0329771937449 | 623.2836615480063 | 271.11029554 | 84.18172936757003 | 70.35163319473999 | 197.6400034456963 | 12.65697955756284
 | 2014 Ç1 | 436.3291131813199 | 199.6435764585318 | 635.9726896398518 | 289.4490729799999 | 81.87425022893386 | 72.82400834243998 | 191.825358088478 | 11.88440480490903
 | (*) Bazı verilerde geriye dönük güncellemeler olabilmektedir
 | (**) Tüm mevduatları ve [NAME].
Spreadsheet: 759329d1639495829-return-multiple-sheet-names-in-different-fields-multiple_sheets_array
Sheet: Sheet4

hostname | Type | Object ID | Make | Model
BEAM01 | Beamer | b001 | Dell | Fast
BEAM02 | Beamer | b002 | Hp | Cheap
BEAM03 | Beamer | b003 | Dell | Cheap
Deskt01 | Desktop | d001 | Hp | Fast
Deskt02 | Desktop | d002 | Dell | Fast
Deskt03 | Desktop | d003 | Hp | Fast
DoST01 | [NAME] | do001 | Dell | Cheap
DoST02 | [NAME] | do002 | Hp | Cheap
DoST03 | [NAME] | do003 | Dell | Cheap
Spreadsheet: 849773d1700163707-calculate-duration-in-hours-minutes-per-day-from-list-of-date-times-raw-user-log-times-only2
Sheet: Table1

Min | [NAME] | Duration
2023-09-03 08:47:00 | 2023-09-03 12:17:00 | 03:30:00
2023-09-05 06:53:00 | 2023-09-05 12:29:00 | 05:36:00
2023-09-06 07:24:00 | 2023-09-06 16:09:00 | 08:45:00
2023-09-07 06:10:00 | 2023-09-07 12:50:00 | 06:40:00
2023-09-08 05:54:00 | 2023-09-08 14:17:00 | 08:23:00
2023-09-11 09:14:00 | 2023-09-11 11:44:00 | 02:30:00
2023-09-12 09:19:00 | 2023-09-12 13:09:00 | 03:50:00
2023-09-13 09:05:00 | 2023-09-13 14:28:00 | 05:23:00
2023-09-14 07:28:00 | 2023-09-14 16:45:00 | 09:17:00
2023-09-15 07:34:00 | 2023-09-15 18:26:00 | 10:52:00
2023-09-17 20:07:00 | 2023-09-17 20:07:00 | 00:00:00
2023-09-18 08:30:00 | 2023-09-18 22:30:00 | 14:00:00
2023-09-19 08:30:00 | 2023-09-19 09:12:00 | 00:42:00
2023-09-20 06:47:00 | 2023-09-20 21:19:00 | 14:32:00
2023-09-21 08:55:00 | 2023-09-21 13:59:00 | 05:04:00
2023-09-22 07:08:00 | 2023-09-22 16:42:00 | 09:34:00
2023-09-25 09:17:00 | 2023-09-25 12:31:00 | 03:14:00
2023-09-26 08:30:00 | 2023-09-26 22:15:00 | 13:45:00
2023-09-27 06:37:00 | 2023-09-27 22:05:00 | 15:28:00
2023-09-28 09:36:00 | 2023-09-28 13:31:00 | 03:55:00
2023-09-29 08:26:00 | 2023-09-29 15:16:00 | 06:50:00
2023-10-02 08:33:00 | 2023-10-02 14:18:00 | 05:45:00
2023-10-03 07:48:00 | 2023-10-03 13:48:00 | 06:00:00
2023-10-04 08:44:00 | 2023-10-04 20:54:00 | 12:10:00
2023-10-05 02:30:00 | 2023-10-05 21:34:00 | 19:04:00
2023-10-06 06:37:00 | 2023-10-06 14:49:00 | 08:12:00
2023-10-08 08:37:00 | 2023-10-08 13:26:00 | 04:49:00
2023-10-10 07:43:00 | 2023-10-10 22:25:00 | 14:42:00
2023-10-11 08:18:00 | 2023-10-11 15:05:00 | 06:47:00
2023-10-12 08:08:00 | 2023-10-12 15:10:00 | 07:02:00
2023-10-13 07:32:00 | 2023-10-13 12:46:00 | 05:14:00
2023-10-15 06:27:00 | 2023-10-15 06:27:00 | 00:00:00
2023-10-16 07:09:00 | 2023-10-16 22:05:00 | 14:56:00
2023-10-17 07:15:00 | 2023-10-17 17:20:00 | 10:05:00
2023-10-18 07:33:00 | 2023-10-18 16:07:00 | 08:34:00
2023-10-19 07:50:00 | 2023-10-19 14:42:00 | 06:52:00
2023-10-20 07:00:00 | 2023-10-20 11:55:00 | 04:55:00
2023-10-23 08:03:00 | 2023-10-23 13:51:00 | 05:48:00
2023-10-24 05:48:00 | 2023-10-24 17:35:00 | 11:47:00
2023-10-25 08:47:00 | 2023-10-25 14:29:00 | 05:42:00
2023-10-26 07:52:00 | 2023-10-26 13:59:00 | 06:07:00
2023-10-27 07:12:00 | 2023-10-27 14:03:00 | 06:51:00
2023-10-30 07:58:00 | 2023-10-30 18:30:00 | 10:32:00
2023-10-31 07:58:00 | 2023-10-31 14:34:00 | 06:36:00
2023-11-01 07:53:00 | 2023-11-01 18:21:00 | 10:28:00
2023-11-02 08:03:00 | 2023-11-02 15:44:00 | 07:41:00
2023-11-03 07:40:00 | 2023-11-03 19:16:00 | 11:36:00
2023-11-04 08:47:00 | 2023-11-04 10:34:00 | 01:47:00
2023-11-06 08:37:00 | 2023-11-06 15:23:00 | 06:46:00
2023-11-07 11:26:00 | 2023-11-07 17:49:00 | 06:23:00
2023-11-08 09:07:00 | 2023-11-08 23:00:00 | 13:53:00
2023-11-09 08:49:00 | 2023-11-09 17:37:00 | 08:48:00
2023-11-13 07:44:00 | 2023-11-13 17:06:00 | 09:22:00
2023-11-14 08:37:00 | 2023-11-14 12:02:00 | 03:25:00
Spreadsheet: 725749d1616838206-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-2021-jt
Sheet: TXs

 | Date | Txs | Student Number | Student Name | Receipt Number | Invoice Number | Amount | Notes
 | 2020-01-01 00:00:00 | Opening Balance | ST 001 | [NAME] |  | C001 | 400
 | 2020-01-10 00:00:00 | Student Invoice | ST 004 | O'Neil James |  | 0001 | 2000
 | 2020-01-01 00:00:00 | Opening Balance | ST 002 | [NAME] |  | C002 | 2000
 | 2020-01-12 00:00:00 | Cash Received | ST 001 | [NAME] | R010 | C001 | 300
 | 2020-01-12 00:00:00 | Student Invoice | ST 003 | [NAME] |  | 3 | 2000
 | 2020-01-13 00:00:00 | Cash Received | ST 002 | [NAME] | R011 | 2 | 2000
 | 2020-01-13 00:00:00 | Student Invoice | ST 004 | O'Neil James |  | 4 | 2000
 | 2020-01-14 00:00:00 | Student Invoice | ST 001 | [NAME] |  | 0001 | 2300
 | 2020-01-19 00:00:00 | Cash Received | ST 003 | [NAME] | R013 | 3 | 1500
 | 2020-01-20 00:00:00 | Cash Received | ST 004 | O'Neil James | R014 | 4 | 2000
 | 2020-05-12 00:00:00 | Cash Received | ST 001 | [NAME] | R012 | 0001 | 2300
 | 2020-05-13 00:00:00 | Student Invoice | ST 002 | [NAME] |  | 6 | 2300
 | 2020-05-14 00:00:00 | Student Invoice | ST 003 | [NAME] |  | 7 | 2300
 | 2020-05-15 00:00:00 | Student Invoice | ST 004 | O'Neil James |  | 8 | 2300
 | 2020-09-09 00:00:00 | Student Invoice | ST 001 | [NAME] |  | 0005 | 2500
 | 2020-09-10 00:00:00 | Student Invoice | ST 002 | [NAME] |  | 10 | 2500
 | 2020-09-11 00:00:00 | Student Invoice | ST 003 | [NAME] |  | 11 | 2500
 | 2020-09-12 00:00:00 | Cash Received | ST 001 | [NAME] | R015 | 0005 | 2400
Spreadsheet: 586103d1534196018-formula-to-colculate-different-rates-from-different-hours-sheet
Sheet: Time sheet

Driver Name | Date |  | Brief details of work | Start | End | Hours | Rate Type | Night out | Expenses | Total cost
 | Sunday |  |  | 17:00:00 | 03:00:00
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
Spreadsheet: 045e48e8-ad1c-40d2-95c7-e0bb32dfe2c5
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
KCCL | Test | KCCL | Potassium, Serum | Potassium, S | Potentiometric, Indirect Ion-Selective Electrode. Also available as part of [NAME]. | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =12 months: 3.6-5.2 mmol/L Reference values have not been established for patients that are less than 12 months of age. | Monday through Sunday Continuously | Same day/1 day | 2 days | 1 | 84132 |  |  |  |  | Rochester
KCCL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
KCCL | Result | KCCL | Potassium, S | Potassium, S | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 2823-3
Spreadsheet: 698172d1601826521-vlookup-with-rank-and-if-tournament
Sheet: 5

[NAME]: |  |  |  |  |  |  | Voor:
Raja paar |  | Mängijate nimed |  |  |  |  |  | [NAME]
11-12 | 1
 | 2
 | 3
9-10 | 1
 | 2
 | 3
12-11 | 1
 | 2
 | 3
14-13 | 1
 | 2
 | 3
9-10 | 1
 | 2
 | 3
 |  | [NAME] tulemus:
 |  | HCP
 |  | [NAME]:
 |  | [NAME]
 |  | V/punkt
[NAME]: |  | _____________________ |  | [NAME]: | ___________________________
Spreadsheet: 821819d1678909401-conditionally-fill-blank-cells-with-n-a-na-in-blank-cell
Sheet: Sheet1

Input | Prompt
 | N/A |  | Type N/A into the cell next to the one where you want it to show
 | N/A |  | Right align the prompt cell
X | N/A |  | Add spaces to the right of the N/A in the cell until it appears where you want it
 | N/A
YY | N/A |  | Unfortunately, you can't hide the column or minimise the column width
 | N/A
 | N/A
ZZZ | N/A
 | N/A
 | N/A
 | N/A
 | N/A
 | N/A
 | N/A
 | N/A
 | N/A
 | N/A
 | N/A
 | N/A
Spreadsheet: 887683d1737992201-find-and-sort-nearest-date-testing
Sheet: Monthly Ledger

Date | ID | Member [NAME] | Monthly Contribution | Late Days | Late Fee | Total Contribution | Loan ID | Loan Date | Need to Pay Intalment | [NAME] 2% | Intrest Paid Date | Late Intrest Days | Intrest Late Fee | [NAME] | [NAME] | Total Amount
Spreadsheet: andy_zipper__235__eEuropean WEMR 300501
Sheet: Exec.Summary

UK Marketing Report Executive Summary:       Week Ending 30/05/01
 |  |  |  |  |  |  | w/e 30/05 | w/e 23/05 | Company Name
Continental Markets:
Password Applications Initiated |  |  |  |  |  |  | 6 | 1
Execution Ids Issued |  |  |  |  |  |  | 0 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 0 | 1
UK Markets:
Password Applications Initiated |  |  |  |  |  |  | 1 | 2
Execution Ids Issued |  |  |  |  |  |  | 0 | 1
New Customers Trading for the 1st time |  |  |  |  |  |  | 1 | 1 | UK Power: BP Gas Marketing Ltd.
Nordic Markets:
Password Applications Initiated |  |  |  |  |  |  | 1 | 0
Execution Ids Issued |  |  |  |  |  |  | 0 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 0 | 0
Global Markets:
Password Applications Initiated |  |  |  |  |  |  | 0 | 0
Execution Ids Issued |  |  |  |  |  |  | 0 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 2 | 0 | International Coal: Transcor AG, Petrochemicals:BP Chemicals Ltd.- UK Benzene.
Metals (Excludes US customers in total count):
Password Applications Initiated |  |  |  |  |  |  | 1 | 0
Execution Ids Issued |  |  |  |  |  |  | 0 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 0 | 1
Totals:
Guest ID's Issued |  |  |  |  |  |  | 40 | 35
Password Applications Initiated |  |  |  |  |  |  | 9 | 3
Execution Ids Issued |  |  |  |  |  |  | 0 | 1
New Customers Trading for the 1st time |  |  |  |  |  |  | 3 | 3
Spreadsheet: 837691d1690359790-formula-to-use-indirect-with-index-and-match-from-different-sheets-index-match-problem-with-indirect
Sheet: Inspector 4

 | Inspectors | COMPANY
 |  | Company 1 | Company 2 | Company 3 | Company 4 | Company 5
 | Inspector 1
 | Inspector 2
 | Inspector 3
 | Inspector 4
 | Inspector 5
 | Inspector 6
 |  | 0.1575 | 0.18 | 0.2025 | 0 | 0
 |  | 0.035 | 0.035 | 0.035 | 0 | 0
 |  | 0.13 | 0.1525 | 0.1675 | 0 | 0
 |  | 0.08 | 0.105 | 0.09499999999999999 | 0 | 0
 |  | 0.1066666666666667 | 0.1333333333333333 | 0.14 | 0 | 0
 |  | 0.02333333333333333 | 0.03166666666666667 | 0.035 | 0 | 0
 |  | 0.5325 | 0.6375 | 0.675 | 0 | 0
Spreadsheet: 122827d1317188684-need-help-in-developing-macros-20437-01-part3a
Sheet: Brisbane

BRANCH - BRISBANE
[NAME] | January | Rate | Commission | Bonus | February | Rate | Commission | Bonus | March | Rate | Commission | Bonus | Grand Total
[NAME], [NAME] | 3990 | 0.045 | 199.5 |  | 2770 | 0.015 | 55.4 |  | 2980 | 0.015 | 59.6 |  | 10054.5
[NAME], [NAME] | 5425 | 0.075 | 434 |  | 3785 | 0.03 | 113.55 |  | 4060 | 0.045 | 203 |  | 14020.55
Leonard, [NAME] | 7320 | 0.12 | 878.4 | 1250 | 5990 | 0.09 | 539.1 |  | 5415 | 0.075 | 433.2 |  | 21825.7
Mahoney, [NAME] | 6235 | 0.09 | 561.15 |  | 5050 | 0.06 | 303 |  | 5620 | 0.075 | 449.6 |  | 18218.75
Penfold, [NAME] | 8915 | 0.15 | 1337.25 | 1250 | 7830 | 0.12 | 939.5999999999999 | 1250 | 7680 | 0.12 | 921.5999999999999 | 1250 | 31373.45
[NAME], [NAME] | 6980 | 0.105 | 767.8 |  | 5670 | 0.075 | 453.6 |  | 6120 | 0.09 | 550.8 |  | 20542.2
Warner, Scott | 4880 | 0.06 | 292.8 |  | 5990 | 0.09 | 539.1 |  | 6350 | 0.09 | 571.5 |  | 18623.4
Average | 6249.285714285715 |  | 682.0600000000001 |  | 5297.857142857143 |  | 390.13 |  | 5460.714285714285 |  | 413.4 |  | 19236.93571428571
[NAME] | 8915 |  | 1337.25 |  | 7830 |  | 939.5999999999999 |  | 7680 |  | 921.5999999999999 |  | 31373.45
Min | 4880 |  | 292.8 |  | 5050 |  | 303 |  | 5415 |  | 413.4 |  | 18218.75
Monthly Total | 43745 |  | 4470.900000000001 | 2500 | 37085 |  | 2943.35 | 1250 | 38225 |  | 3189.3 | 1250 | 203487.6857142857
Min, Max & Average not included in the N5 totals
Spreadsheet: 768714d1645097551-help-with-formula-to-capitalize-state-abbreviations-only-and-use-proper-for-all-other-text-book2
Sheet: Sheet1

 |  |  |  |  | Another Example
 | MEMBER 44444 |  |  |  | 1313 INVENTOR LN
 | STATE VALLEY WC |  |  |  | MOBILE  AL 65050
 | 3201 FAKE ROAD
 | GRAND RAPIDS  MI  49999
 | [NAME]: |  | Wanted Results: |  |  |  | Wanted Results:
 |  |  | Member 44444 |  |  |  | 1313 Inventor [NAME]
 |  |  | State Valley Wc |  |  |  | Mobile  AL 65050
 |  |  | 3201 Fake Road
 |  |  | Grand Rapids, MI  49999
Spreadsheet: 45520d1244239036-calendar-and-buttons-3m-valley
Sheet: Veg Glycerine (2)

Veg. Glycerine 99.7 BIO-K
576 Lbs./Drum
[NAME]
Lot # | CB242261208
Batch # | 121108
PO | USMMMF9H45
Rel. | N/A | 2009-04-20 00:00:00
Veg. Glycerine 99.7 BIO-K
576 Lbs./Drum
[NAME]
Lot # | CB242261208
Batch # | 121108
PO | USMMMF9H45
Rel. | N/A | 2009-04-20 00:00:00
Spreadsheet: 87987d1287878096-match-dates-and-names-on-different-sheets-and-colour-cells-test-date
Sheet: Calendar

 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00
Name
[NAME]
George
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 29b56446-4d6d-4d22-b78c-41637277f684
Sheet: Sheet1

MULTNOMAH COUNTY LOAN DENIAL RATES BY INCOME-RACE GROUPINGS : 2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Home Purchase & Occupation
I.  Total Applications
Race/Ethnicity | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 11 | 34 | 10 | 23 | 78
Asian | 27 | 157 | 482 | 160 | 398 | 1224
Blacks | 7 | 72 | 175 | 59 | 128 | 441
Hispanic | 11 | 107 | 404 | 108 | 149 | 779
White | 151 | 1451 | 4969 | 2010 | 6236 | 14817
Overall Total | 233 | 2049 | 7825 | 2864 | 8258 | 21229
II.  Total Denials
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 4 | 4 | 0 | 3 | 11
Asian | 8 | 12 | 49 | 10 | 42 | 121
Blacks | 1 | 17 | 30 | 9 | 20 | 77
Hispanic | 5 | 24 | 61 | 15 | 20 | 125
White | 31 | 192 | 487 | 147 | 438 | 1295
Overall Total | 52 | 284 | 707 | 211 | 601 | 1855
III. Denial Rates (II/I) * 100
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 0.3636363636363636 | 0.1176470588235294 | 0 | 0.1304347826086956 | 0.141025641025641
Asian | 0.2962962962962963 | 0.07643312101910828 | 0.1016597510373444 | 0.0625 | 0.1055276381909548 | 0.0988562091503268
Blacks | 0.1428571428571428 | 0.2361111111111111 | 0.1714285714285714 | 0.1525423728813559 | 0.15625 | 0.1746031746031746
Hispanic | 0.4545454545454545 | 0.2242990654205607 | 0.150990099009901 | 0.1388888888888889 | 0.1342281879194631 | 0.1604621309370989
White | 0.2052980132450331 | 0.1323225361819435 | 0.09800764741396659 | 0.07313432835820896 | 0.07023733162283514 | 0.08739960855773773
Overall Total | 0.2231759656652361 | 0.1386041971693509 | 0.09035143769968051 | 0.0736731843575419 | 0.07277791232744006 | 0.08738047011163974
Source: HMDA (LAR) 2003
Spreadsheet: 08e36881-2a58-40a2-9a01-984406c04983
Sheet: Natural Gas

[NAME]
Natural Gas Bill Information |  |  | Calculated Values
From Date | To Date | Therms /Month | Days | Average Temp | Average BTU/Hr | Avg. Watts
 |  | 12.897 |  |  |  |  |  |  |  | 2 | 2014-02-13 00:00:00
 |  | 11.076 |  |  |  |  |  |  |  | 2 | 2014-01-15 00:00:00
 |  | 8.485 |  |  |  |  |  |  |  | 2 | 2013-12-12 00:00:00
 |  | 4.643 |  |  |  |  |  |  |  | 2 | 2013-11-11 00:00:00
 |  | 1.472 |  |  |  |  |  |  |  | 5 | 2013-10-10 00:00:00
 |  | 1.36 |  |  |  |  |  |  |  | 4 | 2013-09-11 00:00:00
 |  | 1.355 |  |  |  |  |  |  |  | 3 | 2013-08-12 00:00:00
 |  | 1.466 |  |  |  |  |  |  |  | 3 | 2013-07-12 00:00:00
 |  | 1.351 |  |  |  |  |  |  |  | 3 | 2013-06-12 00:00:00
 |  | 4.612 |  |  |  |  |  |  |  | 3 | 2013-05-13 00:00:00
 |  | 5.849 |  |  |  |  |  |  |  | 2 | 2013-04-12 00:00:00
 |  | 9.692 |  |  |  |  |  |  |  | 1 | 2013-03-14 00:00:00
 |  | 7.904 |  |  |  |  |  |  |  | 5 | 2013-02-13 00:00:00
 |  | 11.023 |  |  |  |  |  |  |  | 3 | 2013-01-15 00:00:00
 |  | 3.487 |  |  |  |  |  |  |  | 6 | 2012-12-12 00:00:00
 |  | 2.141 |  |  |  |  |  |  |  | 2 | 2012-11-09 00:00:00
 |  | 1.929 |  |  |  |  |  |  |  | 1 | 2012-10-11 00:00:00
 |  | 1.021 |  |  |  |  |  |  |  | 4 | 2012-09-12 00:00:00
 |  | 1.021 |  |  |  |  |  |  |  | 4 | 2012-08-13 00:00:00
 |  | 1.018 |  |  |  |  |  |  |  | 4 | 2012-07-13 00:00:00
 |  | 1.238 |  |  |  |  |  |  |  | 4 | 2012-06-12 00:00:00
 |  | 1.464 |  |  |  |  |  |  |  | 4 | 2012-05-10 00:00:00
 |  | 2.254 |  |  |  |  |  |  |  | 4 | 2012-04-11 00:00:00
 |  | 6.781 |  |  |  |  |  |  |  | 4 | 2012-03-13 00:00:00
 |  | 9.128 |  |  |  |  |  |  |  | 4 | 2012-02-13 00:00:00
 |  | 10.573 |  |  |  |  |  |  |  | 2 | 2012-01-13 00:00:00
 |  | 6.946 |  |  |  |  |  |  |  | 4 | 2011-12-12 00:00:00
 |  | 2.572 |  |  |  |  |  |  |  | 4 | 2011-11-09 00:00:00
 |  | 1.232 |  |  |  |  |  |  |  | 4 | 2011-10-11 00:00:00
 |  | 0.785 |  |  |  |  |  |  |  | 4 | 2011-09-12 00:00:00
 |  | 0.895 |  |  |  |  |  |  |  | 4 | 2011-08-11 00:00:00
 |  | 1.346 |  |  |  |  |  |  |  | 4 | 2011-07-13 00:00:00
 |  | 1.234 |  |  |  |  |  |  |  | 4 | 2011-06-13 00:00:00
 |  | 2.127 |  |  |  |  |  |  |  | 4 | 2011-05-12 00:00:00
 |  | 4.033 |  |  |  |  |  |  |  | 4 | 2011-04-12 00:00:00
 |  | 6.933 |  |  |  |  |  |  |  | 2 | 2011-03-14 00:00:00
 |  |  |  |  |  |  |  |  |  | 7 | 2011-02-13 00:00:00