tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0bd88412-fc11-4070-a601-8601b56c3f98
Sheet: Sheet2

ADAMTS13  TESTING | CPT CODE | SAMPLE TYPE
ADAMTS13 ACTIVITY | 85397 | PLATELET POOR PLASMA
ADAMTS13 INHIBITION TEST | 85335 | PLATELET POOR PLASMA
ADAMTS13 ANTIBODY QUANT | 85320 | SERUM
SERUM PROTEINS
ALBUMIN | 82040 | SERUM
HS C REACTIVE PROTEIN | 86141 | SERUM
TRANSFERRIN | 84466 | SERUM
IGA-IMMUNOGLOBULIN | 82784 | SERUM
IGG-IMMUNOGLOBULIN | 82784 | SERUM
IGM-IMMUNOGLOBULIN | 82784 | SERUM
[NAME] | 86160 | SERUM
C4-COMPLEMENT | 86160 | SERUM
HAPTOGLOBIN | 83010 | SERUM
CYSTATIN C | 82610 | SERUM
RHEUMATOID FACTOR | 86431 | SERUM
ANTI STRYSTOLYSIN O | 86060 | SERUM
COMPLEMENT TESTING
ANTI-FACTOR H ANTIBODY | 83516 | SERUM OR PLASMA
C2-COMPLEMENT | 86160 | SERUM
[NAME] | 86160 | SERUM
C4-COMPLEMENT | 86160 | SERUM
C5-COMPLEMENT | 86160 | SERUM
C6-COMPLEMENT | 86160 | SERUM
C7-COMPLEMENT | 86160 | SERUM
C8-COMPLEMENT | 86160 | SERUM
C9-COMPLEMENT | 86160 | SERUM
FACTOR B | 86160 | SERUM
C1 ESTERASE INHIBITOR | 86160 | SERUM
FACTOR I | 86160 | SERUM
FACTOR H | 86160 | SERUM
C1q | 86160 | SERUM
PROPERDIN | 86160 | SERUM
C4 BINDING PROTEIN | 86160 | SERUM
[NAME] | 86160 x4 | SERUM
URINE
URINARY MICROALBUMIN | 82043 | URINE
Spreadsheet: 128902d1321340653-to-improve-my-deduction-file-deduction
Sheet: Sheet1

Personal Insurance | Partial Payment of $269.22 |  |  |  | 269.22
PM6040
 | 1st Payment |  | 2011-04-01 00:00:00 |  |  | 22.45
 | 2nd Payment |  | 2011-05-01 00:00:00 |  |  | 22.43
 | 3rd Payment |  | 2011-06-01 00:00:00 |  |  | 22.43
 | 4th Payment |  | 2011-07-01 00:00:00 |  |  | 22.43
 | 5th Payment |  | 2011-08-01 00:00:00 |  |  | 22.43
 | 6th Payment |  | 2011-09-01 00:00:00 |  |  | 22.43
 | 7th Payment |  | 2011-10-01 00:00:00 |  |  | 22.43
 | 8th Payment |  | 2011-11-01 00:00:00 |  |  | 22.43
 | 9th Payment |  | 2011-12-01 00:00:00 |  |  | 22.43
 | 10th Payment |  | 2012-01-01 00:00:00 |  |  | 22.43
 | 11th Payment |  | 2012-02-01 00:00:00 |  |  | 22.45
 | 12th Payment |  | 2012-03-01 00:00:00 |  |  | 22.45
Spreadsheet: 797232d1663769439-auto-filter-update-excel-2-filter-aligw
Sheet: Masterfile

Product Number | Brand | Delete
5000044 | SIKKENS
5000077 | SIKKENS
5000078 | SIKKENS | Yes
5000083 | SIKKENS
5000084 | SIKKENS
5000085 | SIKKENS
5000086 | TRIMETAL | Yes
5000901 | SIKKENS
5002047 | SIKKENS
5002048 | SIKKENS
5002049 | SIKKENS
5002050 | SIKKENS | Yes
5002051 | TRIMETAL
5002052 | TRIMETAL
5002053 | TRIMETAL | Yes
5002054 | TRIMETAL
5002055 | ACOAT
5002056 | ACOAT
5002057 | ACOAT | Yes
5002058 | ACOAT
5002059 | ACOAT
5002060 | ACOAT
5002690 | ACOAT
5002691 | ACOAT
5005991 | ACOAT | Yes
5006790 | ACOAT
5006801 | ACOAT
5006884 | ACOAT | Yes
5008009 | ACOAT
5008021 | ACOAT
5008489 | ACOAT
5008490 | SIKKENS
5008492 | SIKKENS
5008493 | TRIMETAL | Yes
5008508 | TRIMETAL
5008509 | TRIMETAL
5008514 | TRIMETAL | Yes
5008519 | SIKKENS
5008520 | SIKKENS | Yes
5008521 | ACOAT
5008522 | HERBOL | Yes
5008523 | HERBOL
5008524 | HERBOL
5008527 | HERBOL | Yes
5008528 | HERBOL
5008529 | HERBOL
5008530 | HERBOL | Yes
5008531 | HERBOL
5008533 | HERBOL
5008620 | HERBOL
5008621 | HERBOL | Yes
5008623 | SIKKENS
5008624 | SIKKENS
5008637 | SIKKENS | Yes
5008638 | TRIMETAL
5008652 | TRIMETAL
5008653 | TRIMETAL | Yes
5009312 | TRIMETAL
5009929 | TRIMETAL | Yes
Spreadsheet: 865312d1712339656-trying-to-extract-data-based-on-county-countymonthdaylisting
Sheet: Sheet1

Data Table |  |  |  |  |  | Search Table
Month | Day | Year | County/Counties | Intensity |  | Enter County |  | Grant |  | # of Occurrences |  |  |  | Desired Results
1 | 1 | 1850 | Grant | EF0
2 | 2 | 1851 | Grant, Lafayette | EF1 |  | Occurences | County | Month | Day | Year | County/Counties | Intensity |  |  | Occurences | County | Month | Day | Year | County/Counties | Intensity
3 | 3 | 1852 | Lafayette | EF2 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1850 | Grant | EF0
4 | 4 | 1853 | La Crosse | EF3 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1851 | Grant, Lafayette | EF1
2 | 2 | 1851 | Grant, La Crosse | EF4 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1851 | Grant, La Crosse | EF4
2 | 2 | 1851 | Grant | EF5 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1851 | Grant | EF5
7 | 7 | 1856 | Lafayette | EF0 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 1900 | Grant | EF3
8 | 8 | 1857 | Lafayette | EF1 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 1903 | Grant | EF0
9 | 9 | 1858 | Monroe | EF2 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 1904 | Grant | EF1
10 | 10 | 1900 | Grant | EF3 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7 | 1905 | Grant, Lafayette | EF2
11 | 11 | 1901 | La Crosse | EF4 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 1925 | Grant, La Crosse | EF5
12 | 12 | 1902 | Lafayette | EF5 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 7 | 1926 | Grant, La Crosse | EF0
5 | 5 | 1903 | Grant | EF0 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 7 | 1926 | Grant, Lafayette | EF1
6 | 6 | 1904 | Grant | EF1 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 11 | 1960 | Grant | EF4
7 | 7 | 1905 | Grant, Lafayette | EF2
4 | 8 | 1906 | Lafayette | EF3
5 | 7 | 1907 | La Crosse | EF4
6 | 6 | 1925 | Grant, La Crosse | EF5
5 | 7 | 1926 | Grant, La Crosse | EF0
5 | 7 | 1926 | Grant, Lafayette | EF1
7 | 9 | 1958 | Lafayette | EF2
8 | 10 | 1959 | Monroe | EF3
9 | 11 | 1960 | Grant | EF4
5 | 12 | 1961 | La Crosse | EF5
Spreadsheet: 847121d1698198823-athletics-spread-sheet-find-winner-athletics-spreadsheet-attempt-1
Sheet: Overall

 |  |  |  |  | OVERALL POINTS
TIBROGARGAN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL |  | HOUSE | TOTAL
 |  |  |  |  |  |  |  |  | TIBROGARGAN
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL |  | COOCHIN
 |  |  |  |  |  |  |  |  | COONOWRIN
COOCHIN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
COONOWRIN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
Spreadsheet: 763177d1642020969-lookup-referencing-question-between-multiple-sheets-excel-question-doc
Sheet: STANDINGS

RANK | NAME | TEAM EARNINGS
1 | PARTICIPANT 1
2 | PARTICIPANT 2
3 | PARTICIPANT 3
4 | PARTICIPANT 4
5 | PARTICIPANT 5
6 | PARTICIPANT 6
7 | PARTICIPANT 7
8 | PARTICIPANT 8
9 | PARTICIPANT 9
10 | PARTICIPANT 10
11 | PARTICIPANT 11
12 | PARTICIPANT 12
13 | PARTICIPANT 13
14 | PARTICIPANT 14
15 | PARTICIPANT 15
16 | PARTICIPANT 16
17 | PARTICIPANT 17
18 | PARTICIPANT 18
19 | PARTICIPANT 19
20 | PARTICIPANT 20
21 | PARTICIPANT 21
22 | PARTICIPANT 22
23 | PARTICIPANT 23
24 | PARTICIPANT 24
25 | PARTICIPANT 25
26 | PARTICIPANT 26
27 | PARTICIPANT 27
28 | PARTICIPANT 28
29 | PARTICIPANT 29
30 | PARTICIPANT 30
31 | PARTICIPANT 31
32 | PARTICIPANT 32
33 | PARTICIPANT 33
34 | PARTICIPANT 34
35 | PARTICIPANT 35
36 | PARTICIPANT 36
37 | PARTICIPANT 37
38 | PARTICIPANT 38
39 | PARTICIPANT 39
40 | PARTICIPANT 40
41 | PARTICIPANT 41
42 | PARTICIPANT 42
43 | PARTICIPANT 43
44 | PARTICIPANT 44
45 | PARTICIPANT 45
46 | PARTICIPANT 46
47 | PARTICIPANT 47
48 | PARTICIPANT 48
49 | PARTICIPANT 49
50 | PARTICIPANT 50
51 | PARTICIPANT 51
52 | PARTICIPANT 52
53 | PARTICIPANT 53
54 | PARTICIPANT 54
55 | PARTICIPANT 55
56 | PARTICIPANT 56
57 | PARTICIPANT 57
58 | PARTICIPANT 58
59 | PARTICIPANT 59
60 | PARTICIPANT 60
61 | PARTICIPANT 61
62 | PARTICIPANT 62
63 | PARTICIPANT 63
64 | PARTICIPANT 64
65 | PARTICIPANT 65
66 | PARTICIPANT 66
67 | PARTICIPANT 67
68 | PARTICIPANT 68
69 | PARTICIPANT 69
70 | PARTICIPANT 70
71 | PARTICIPANT 71
72 | PARTICIPANT 72
73 | PARTICIPANT 73
74 | PARTICIPANT 74
75 | PARTICIPANT 75
76 | PARTICIPANT 76
77 | PARTICIPANT 77
78 | PARTICIPANT 78
79 | PARTICIPANT 79
80 | PARTICIPANT 80
81 | PARTICIPANT 81
82 | PARTICIPANT 82
83 | PARTICIPANT 83
84 | PARTICIPANT 84
85 | PARTICIPANT 85
Spreadsheet: 879700d1727266181-return-list-of-people-at-specific-date-and-shift-nihilimus-excelforum-22-spill-365-aligw
Sheet: Blad1

 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00
[NAME] | v | v | v | v | v
[NAME] | v | l | l | v | v
[NAME] | d | l | l | v | v
[NAME] | d | v | v | d | v
[NAME] | l | v | v | v | v
Available people at specific date:
Type date: | 2024-01-01 00:00:00
v | l | d
[NAME] | [NAME] | [NAME]
[NAME] |  | [NAME]
 | l | d
[NAME] | [NAME] | [NAME]
[NAME] |  | [NAME]
Spreadsheet: bc46b494-4dd6-4edd-a2ef-c05fd5b9664b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7457 | 57735 | [NAME] | Nakazawa | JPN | 0 | 00:00:00 | 00:00:00 | 00:34:04 | 00:01:35 | 00:26:59 | 1 | 01:02:38
7457 | 57736 | [NAME] | Yanagawa | JPN | 0 | 00:00:00 | 00:00:00 | 00:36:55 | 00:01:53 | 00:24:00 | 2 | 01:02:47
7457 | 57737 | Keiji | Nagai | JPN | 0 | 00:00:00 | 00:00:00 | 00:37:53 | 00:01:53 | 00:24:30 | 3 | 01:04:17
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: Sheet8

Number | Box Number
969 | 210
750 | 180
935 | 309
492 | 354
803 | 772
587 | 962
302 | 186
297 | 702
888 | 705
546 | 703
927 | 331
690 | 401
764 | 345
764 | 974
667 | 482
903 | 209
271 | 401
918 | 383
941 | 275
25 | 826
221 | 267
184 | 641
287 | 608
795 | 797
844 | 711
6 | 483
728 | 786
202 | 723
81 | 701
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: CDIS

Old course number | New course number
CDIS-304 | CDIS-3400
CDIS-305 | CDIS-2100
CDIS-306 | CDIS-3100
CDIS-307 | CDIS-3200
CDIS-310 | CDIS-3300
CDIS-330 | CDIS-3500
CDIS-345 | CDIS-3600
CDIS-410 | CDIS-4400
CDIS-440 | CDIS-4200
CDIS-450 | CDIS-4500
CDIS-470 | CDIS-4700
CDIS-480 | CDIS-4800
CDIS-511 | CDIS-4100
CDIS-520 | CDIS-4150
CDIS-530 | CDIS-4600
CDIS-540 | CDIS-4300
CDIS-600 | CDIS-6100
CDIS-650 | CDIS-6200
CDIS-700 | CDIS-7200
CDIS-705 | CDIS-7400
CDIS-710 | CDIS-7500
CDIS-720 | CDIS-7550
CDIS-730 | CDIS-7100
CDIS-740 | CDIS-7600
CDIS-750 | CDIS-7700
CDIS-760 | CDIS-7800
CDIS-770 | CDIS-7300
CDIS-805 | CDIS-8000
CDIS-815 | CDIS-8100
CDIS-830 | CDIS-8200
CDIS-835 | CDIS-8300
CDIS-850 | CDIS-8840
CDIS-852 | CDIS-8850
CDIS-853 | CDIS-8810
CDIS-854 | CDIS-8820
CDIS-858 | [NAME]
CDIS-870 | CDIS-8700
CDIS-880 | CDIS-8800
CDIS-890 | CDIS-8900
Spreadsheet: 797015d1663671447-count-function-to-not-count-blank-cells-with-formula-in-them-sortandcount
Sheet: Sheet1

NAME | Code |  |  | Status [good] | Status [Bad] | Status [In progress]
[NAME] doe | good
[NAME] | bad |  |  | name x | name xxxx
jane doe |  |  |  | name xx | name xxxxx |  |  | Count Good | [NAME] | Count In progress
[NAME] |  |  |  | name xxx
name x | good
name xx | good
name xxx | good
name xxxx | bad
name xxxxx | bad
 |  |  |  |  |  | Since there is  no in progress
 |  |  |  |  |  | staus, its blank
 | Input
 |  |  |  | outputs
 |  |  |  |  |  |  |  |  | This should be zero, how do I fix this? please
Spreadsheet: 141826d1329474837-conditional-formatting-using-lists-0203
Sheet: Sheet2

Black | [NAME] | [NAME] |  |  | Black | Blue | Yellow | Green | Pink
Blue | [NAME] | [NAME] |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Scott
Yellow | [NAME] | [NAME] |  |  | [NAME] | [NAME] | [NAME] | Michelle | [NAME]
Green | [NAME] | Michelle
Pink | Scott | [NAME]
Spreadsheet: 016ab397-60d0-45ac-817c-8d45c2bf76ea
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | INCOME ELIGIBILITY SCALE | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | HOUSEHOLD ELIGIBILITY FOR USDA FOODS
 | (Effective July 1, 2013 through June 30, 2014)
HOUSEHOLD SIZE | ANNUAL | MONTHLY | TWICE PER MONTH | EVERY 2 WEEKS | WEEKLY
1 | 17235 | 1436 | 718 | 663 | 331
2 | 23265 | 1939 | 969 | 895 | 447
3 | 29295 | 2441 | 1221 | 1127 | 563
4 | 35325 | 2944 | 1472 | 1359 | 679
5 | 41355 | 3446 | 1723 | 1591 | 795
6 | 47385 | 3949 | 1974 | 1823 | 911
7 | 53415 | 4451 | 2226 | 2054 | 1027
8 | 59445 | 4954 | 2477 | 2286 | 1143
Each Additional
Family Member + | 6030 | 503 | 251 | 232 | 116
Spreadsheet: 716430d1612206083-personal-budget-tracker-help-needed-sumif-budget-tracker-2021-sumproduct
Sheet: Home

Item | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Electric | 80 | 150 | 70 | 70 | 70 | 70 | 70 | 110 | 150 | 90 | 65 | 60
Internet | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60
Cable | 85 | 85 | 85 | 85 | 85 | 85 | 85 | 85 | 85 | 85 | 85 | 85
Water
Planet Fitness | 12
Car Payment
Car Insurance
Groceries
Optavia
Dining out
Spreadsheet: 730959d1620069484-dynamic-formula-to-split-data-in-column-c-and-repeat-the-remaining-columns-split-range
Sheet: Data

Date | Company | Truck | No1 | No2 | No3 | No4 | Quantity
2021-04-01 00:00:00 | Company1 | 6578, 7496 | 20.66 | 29.51 | 4398 |  | 37.46
2021-04-01 00:00:00 | Company2 | 2951 | 20.21 | 32.35 | 4106 |  | 48.02
2021-04-01 00:00:00 | Company3 | 2971 | 16.44 | 23.76 | 4484 |  | 26.78
2021-04-01 00:00:00 | Company4 | 2473, 7416 | 18.26 | 30.33 | 4432 |  | 106.54
2021-04-01 00:00:00 | Company5 | 9241, 8162, 2493, 3697 | 22.75 | 31 | 4186 |  | 222.44
2021-04-02 00:00:00 | Company4 | 3724, 1564, 4571, 8947 | 20.51 | 29.65 | 4432 |  | 192.32
2021-04-02 00:00:00 | Company2 | 7415 | 18.85 | 34.31 | 4106 |  | 42
2021-04-02 00:00:00 | Company6 | 5312 | 25.14 | 24 | 4596 |  | 42.14
2021-04-02 00:00:00 | Company1 | 6578, 7496 | 20.39 | 30.15 | 4398 |  | 61.1
2021-04-02 00:00:00 | Company7 | 1589 | 22.71 | 29.71 | 4411 |  | 33.04
2021-04-03 00:00:00 | Company5 | 5761 | 21.87 | 31.39 | 4186 |  | 57.44
2021-04-03 00:00:00 | Company3 | 8129, 9481 | 16 | 22.85 | 4484 |  | 75.74
2021-04-03 00:00:00 | Company1 | 6578, 7496 | 20.13 | 29.15 | 4398 |  | 36.4
2021-04-04 00:00:00 | Company4 | 6741, 7492 | 20.41 | 30.45 | 4486 |  | 95.74
2021-04-04 00:00:00 | Company1 | 6578, 7496 | 21.77 | 30.18 | 4347 |  | 57.66
2021-04-04 00:00:00 | Company7 | 1589 | 22.15 | 29.71 | 4466 |  | 33
2021-04-05 00:00:00 | Company4 | 8524, 9516, 7416, 2473 | 19.61 | 30.45 | 4486 |  | 201.82
2021-04-05 00:00:00 | Company6 | 9423, 9138 | 23.21 | 23.31 | 4588 |  | 76.52
2021-04-05 00:00:00 | Company1 | 6578, 7496 | 20.17 | 29.55 | 4347 |  | 58.56
2021-04-06 00:00:00 | Company4 | 1564, 8126 | 18.55 | 30.37 | 4486 |  | 94.5
2021-04-06 00:00:00 | Company6 | 5312 | 22.11 | 26.71 | 4588 |  | 40.88
2021-04-06 00:00:00 | Company8 | 8462, 3598 | 20.89 | 29.79 | 4480 |  | 76.32
2021-04-06 00:00:00 | Company1 | 6578, 7496 | 20.31 | 28.22 | 4347 |  | 33.94
2021-04-06 00:00:00 | Company7 | 1589 | 23.94 | 29.73 | 4466 |  | 36.4
2021-04-07 00:00:00 | Company5 | 7981 | 20.16 | 31.44 | 4185 |  | 43.9
2021-04-07 00:00:00 | Company4 | 6741, 2951 | 18.84 | 30.73 | 4387 |  | 100.1
2021-04-07 00:00:00 | Company2 | 3984 | 18.19 | 33.67 | 4056 |  | 49.62
2021-04-07 00:00:00 | Company8 | 8462, 3598 | 17.71 | 28.31 | 4429 |  | 77.48
2021-04-07 00:00:00 | Company1 | 6578, 7496 | 19.55 | 28.77 | 4436 |  | 34.72
2021-04-07 00:00:00 | Company7 | 1589 | 21.18 | 29.15 | 4352 |  | 35.84
2021-04-07 00:00:00 | Company11 |  |  |  |  |  | 35.84
2021-04-06 00:00:00 | Company1 | 6578, 7496 | 20.31 | 28.22 | 4347 |  | 33.94
2021-04-06 00:00:00 | Company7 | 1589 | 23.94 | 29.73 | 4466 |  | 36.4
2021-04-07 00:00:00 | Company5 | 7981 | 20.16 | 31.44 | 4185 |  | 43.9
2021-04-07 00:00:00 | Company4 | 6741, 2951 | 18.84 | 30.73 | 4387 |  | 100.1
Spreadsheet: 275245d1383415872-how-to-use-index-and-match-with-multiple-criteria-driverssample
Sheet: Drivers

RaceID | Year | Race | Pos | Driver | Time
1 | 2012 | 7 | 1 | Driver 1 | Race time 1
1 | 2012 | 7 | 2 | Driver 2 | Race time 2
1 | 2012 | 7 | 3 | Driver 3 | Race time 3
1 | 2012 | 7 | 4 | Driver 4 | Race time 4
2 | 2012 | 8 | 1 | Driver 5 | Race time 5
2 | 2012 | 8 | 2 | Driver 6 | Race time 6
2 | 2012 | 8 | 3 | Driver 7 | Race time 7
2 | 2012 | 8 | 4 | Driver 8 | Race time 8
3 | 2013 | 1 | 1 | Driver 9 | Race time 9
3 | 2013 | 1 | 2 | Driver 10 | Race time 10
Spreadsheet: 168799d1342587983-radio-buttons-radiobutton-solution
Sheet: SUMMARY PAGE

 |  | Revenue | Nights | ARR
 | Segment 1 |  |  |  |  |  |  |  | 3
 | Segment 2
 | Segment 3
 | Segment 4
 | Segment 5
 | Segment 6
 | Segment 7
 | Segment 8
 | Segment 9
 | Segment 10
 | Segment 11
 |  |  |  |  |  |  |  |  |  |  | *** Function that once I click Hotel 1, the data from DATA Sheet will populate to column C D E.
Spreadsheet: phillip_m_love__30062__CentralFRED0800
Sheet: ASum 

TAGG | Counterparty | Amount
24554/24585 Total |  | 10049.1921650316
24918/24949 Total |  | 7096.32284235991
E22563.8 Total |  | -23929.54
E28811.5 Total |  | -127505
E28811.E Total |  | 127505
E28811.I Total |  | -158689
E49515.2 Total |  | 352125.9
E85005.K Total |  | -50556.26
EW4539.2 Total |  | -744999.95
EW4539.3 Total |  | 744999.95
EW4976.4 Total |  | -1869999.85
EXOTIC-TP Total |  | -130735
N02838.1 Total |  | 161200
N70012.B Total |  | 0
N70012.C Total |  | 0
N70012.R Total |  | 1751337.3629
N70012.U Total |  | 0
N90091.5 Total |  | -1757799.863
N90091.7 Total |  | 1757799.863
NA7585.4 Total |  | -161240
NA7585.5 Total |  | 161240
NA7585.C Total |  | -150
NA7585.D Total |  | 150
NB4011.1 Total |  | -223818.45
NB4304.1 Total |  | -74606.15
NB4325.4 Total |  | -364653
NB4325.5 Total |  | 364653
NM5846.1 Total |  | 0.0775
NM5846.2 Total |  | -0.1085
NN2218.3 Total |  | 0
NS7894.1 Total |  | 19121.9625
NS7895.1 Total |  | 6566.73
NV8650.4 Total |  | -305437.5
NV8650.5 Total |  | 305437.5
NW0661.2 Total |  | 29822.5
NW0661.3 Total |  | -29822.5
NX3715.1 Total |  | 10000
Spreadsheet: 05eddf32-94cf-44e7-88a5-ba7ad1ded21a
Sheet: Attachment F - Rental S + U

Rental Sources and Uses
Address: | xxx Street
Description: | Rehab/new const of xxx sq ft building, # BD, # [NAME], # units
Uses
ACQUISITION COSTS
Purchase Price | 0 | Use price from HRA listing
Closing Costs - Acquisition | 0 | Include $500 fee payable to HRA, waived for NSP properties
Total Acquisition Costs
CONSTRUCTION COSTS
Hard Construction Costs | 0 | Contract Amount
Contingency | 0 | 10% rehab; 5% new construction
Total Construction Costs
SOFT COSTS
Design and Construction Management | 0 | [NAME] 6% of estimated hard costs
Legal Work | 0
Radon/Abestos/Lead Tests | 0 | Note: if HRA has provided tests, it is expected this estimate will be minimal
Soil Tests | 0
Survey | 0
Marketing | 0 | [NAME] $500/unit marketing expense
Holding Costs (maintenance, utilities) | 0 | Homes with NSP financing cannot include these in TDC calculation
Property Insurance | 0
Total Soft Costs
Developer’s Fee |  | [NAME] 10% of Total Construction & Soft Costs, Less Acquisition Purchase Price
TOTAL DEVELOPMENT COSTS |  | Total of Acquisition, Construction Costs, Soft Costs, and Developer Fee
NSP eligible TDC |  | TDC less holding costs (only on homes with NSP financing)
Projected Value Gap |  | Amount needed for positive cash flow (From Attachment G)
Permanent Sources* |  | *Developer must demonstrate ability to secure all identified sources.
Equity | 0 | Developer contribution
Bank Loan | 0 | Name terms
HRA Value Gap Assistance | 0
Other Source | 0
Other Source | 0
Other Source | 0
Total |  | Total of permanent sources should equal Total Development Costs.
Spreadsheet: 127945d1320695081-count-number-of-sales-on-country-level-counting-number-of-sales
Sheet: Sheet1

 | Country | Agent | May 11 | Jun 11 | Jul 11 | Aug 11 | Sep 11 | Oct 11 | Nov 11
 | Canada | A |  |  |  | 4000 | 4000 | 4000 | 4000
 | Canada | B | 4000 | 4000 | 4000 | 4000
 | Canada | C | 4000 |  |  |  | 4000 | 4000 | 4000
 | USA | D | 4000 |  |  | 4000 | 4000 | 4000 | 4000
 | USA | E | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
 | USA | F | 4000 | 4000 |  |  |  | 4000 | 4000
 | Mexico | G | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
 | Mexico | H |  |  | 4000 | 4000
 | Mexico | I | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
 | Caribbean | J | 4000 |  |  |  |  |  | 4000
 | Caribbean | K | 4000 |  |  |  | 4000 | 4000 | 4000
 | Caribbean | L | 4000 |  |  |  | 4000 |  | 4000
 |  |  |  |  | Tabel of 'results':
 |  |  | May 11 | Jun 11 | Jul 11 | Aug 11 | Sep 11 | Oct 11 | Nov 11
 | Canada |  | - | - | 2 | 2 | 3 | 3 | 2
 | USA |  | - | - | 3 | 2 | 2 | 3 | 3
 | Mexico |  | - | - | 3 | 3 | 3 | 3 | 2
 | Carribbean |  | - | - | 3 | 0 | 2 | 2 | 3
Spreadsheet: 883869d1732621397-if-and-formula-support-range-status-formula-v2
Sheet: Sheet1

Stocked This Year | Stocked Last Year | Status
Stocked | Stocked | LFL
Not Stocked | Not Stocked | Off Plan
Stocked | Not Stocked | Incremental
Not Stocked | Stocked | Discontinued
Item Code | Description | Stocked This Year | Stocked Last Year | Status
1234 | Test 1 | Stocked | Stocked
5678 | Test 2 | Not Stocked | Not Stocked
1648 | Test 3 | Stocked | Not Stocked
Spreadsheet: 126182d1319559002-using-max-on-uncalculated-totals-testsheet1-1-
Sheet: Sheet1

item # | days | cost
1 | 30 | 17
2 | 120 | 100
3 | 12 | 10
4 | 60 | 40
5 | 70 | 50
6 | 90 | 50
7 | 130 | 47
8 | 50 | 62
9 | 55 | 34
10 | 22 | 9
 |  | 1.24
Spreadsheet: 35720d1233324821-doing-a-vlookup-and-returning-multiple-entries-example
Sheet: Sheet1

Counter |  | 1 | 2 | 3
Y1 | Y | red | blue | blue
X1 | X | pink | blue | orange
Z1 | Z | red | blue | orange
X2 | X | red | blue | pink
X3 | X | blue | red | red
 | X
 | orange
 | pink
 | red
Spreadsheet: edc11e1f-80a8-4ca1-91dd-e2728734eff8
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
QEBV | Test | QEBV | [NAME] (EBV), Molecular Detection, Quantitative PCR, Blood | Epstein-Barr Virus PCR, Quant, B | LightCycler Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems Inc.) | EDTA (lavender-top) tube: EDTA |  |  | 5 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 5 mL Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | None detected | Monday through Saturday; Varies | Same day/1 day | 3 days | 1 | 87799 |  |  |  |  | Rochester
QEBV | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
QEBV | Result | 82987 | Epstein-Barr Virus PCR, Quant, B | Epstein-Barr Virus PCR, Quant, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
QEBV | Result | 21862 | Copies/mL | Copies/mL | Numeric |  |  |  |  | copies/mL |  |  |  |  |  |  |  |  |  | 36923-1 | [NAME] virus DNA:NCnc:Pt:[NAME]:Qn:Probe.amp.tar
QEBV | Result | 26399 | Lower 95% Confidence Interval | Lower 95% Confidence Interval | Numeric |  |  |  |  | copies/mL
QEBV | Result | 26400 | Upper 95% Confidence Interval | Upper 95% Confidence Interval | Numeric |  |  |  |  | copies/mL
Spreadsheet: 834710d1688024604-how-to-restart-counting-the-order-of-occurrence-of-duplicates-for-non-adjacent-cells-order-of-occurrence-of-duplicates-for-non-adjacent-cells
Sheet: Tabelle1

 | My data | Countif | my wish
 | banana
 | banana
 | banana
 | banana
 | apple
 | apple
 | banana
 | banana
 | apple
 | apple
 | apple
 | apple