tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867622d1714451834-need-attendace-sheet-for-saleman-visited-diffrent-regions-with-different-items-book4-12-aligw
Sheet: Sheet1

 |  | Salesman | Items | Region
 |  | Salesman101 | Item-1 | REG-1
 |  | Salesman101 | Item-2 | REG-3
 |  | Salesman101 | Item-3 | REG-3
 |  | Salesman111 | Item-1 | [NAME]
 |  | Salesman111 | Item-2 | REG-3
 |  | Salesman111 | Item-3 | REG-1
 |  | Salesman111 | Item-4 | REG-3
 |  | Salesman111 | Item-5 | REG-3
 |  | Salesman111 | Item-6 | [NAME]
 |  | Salesman111 | Item-7 | REG-3
 |  | Salesman111 | Item-8 | REG-5
 |  | Salesman111 | Item-9 | [NAME]
 |  | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME] |  |  |  | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME]
Salesman101 | Item-1 |  |  |  |  |  |  |  |  | Salesman101 | 0.33 |  | 0.67
Salesman101 | Item-2 |  |  | 0.3333333333333333 |  |  |  |  |  | Salesman111 | 0.11 |  | 0.56 |  | 0.11 | 0.22
Salesman101 | Item-3 |  |  | 0.3333333333333333 |  |  |  |  |  | Salesman121 |  | 0.5 |  | 0.5
Salesman111 | Item-4 |  |  | 0.1111111111111111
Salesman111 | Item-1 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-2 |  |  | 0.1111111111111111
Salesman111 | Item-3 | 0.1111111111111111
Salesman111 | Item-4 |  |  | 0.1111111111111111
Salesman111 | Item-5 |  |  | 0.1111111111111111
Salesman111 | Item-6 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-7 |  |  | 0.1111111111111111
Salesman111 | Item-8 |  |  |  |  | 0.1111111111111111
Spreadsheet: 470804d1468668338-sorting-two-different-values-book1-1-prc
Sheet: Pivot

 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | R-01 | 10.47 | 45.04 | 182.76 | 7.16 | 1.24 | 37.54 | 0.65 | 0.28 | 4.36 | 400 | B | KA 02
 | R-07 | 10.06 | 50.57 | 114.96 | 9.73 | 0.93 | 28.86 | 0.6 | 0.74 | 9.21 | 400 | E | KA 05
 | R-08 | 7.84 | 45.85 | 146.36 | 3.98 | 1.29 | 44.29 | 0.73 | 0.41 | 20.69 | 400 | F | KA 06
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | RR-05 | 11.31 | 46.76 | 112.06 | 6.84 | 0.72 | 37.34 | 0.71 | 0.33 | 9.33 | 400 | C | KA 03
 | RR-09 | 10.95 | 47.59 | 113.88 | 4.93 | 1.27 | 38.29 | 0.71 | 0.39 | 14 | 400 | G | KA 07
 | RR-12 | 10.83 | 48.1 | 129.52 | 7.03 | 1.39 | 35.85 | 0.67 | 0.34 | 11.91 | 400 | I | KA 09
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | GR-01 | 11.22 | 47.61 | 80.64 | 8.68 | 0.96 | 32.48 | 0.62 | 0.4 | 7.96 | 400 | A | KA 01
 | GR-06 | 11.42 | 50.28 | 116.1 | 9.36 | 0.93 | 27.83 | 0.59 | 0.47 | 5.12 | 400 | D | KA 04
 | GR-11 | 8.07 | 52.71 | 62.19 | 11.97 | 0.78 | 27.78 | 0.69 | 0.34 | 12.3 | 400 | H | KA 08
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | GR-01 | 11.22 | 47.61 | 80.64 | 8.68 | 0.96 | 32.48 | 0.62 | 0.4 | 7.96 | 400 | A | KA 01
 | GR-06 | 11.42 | 50.28 | 116.1 | 9.36 | 0.93 | 27.83 | 0.59 | 0.47 | 5.12 | 400 | D | KA 04
 | GR-11 | 8.07 | 52.71 | 62.19 | 11.97 | 0.78 | 27.78 | 0.69 | 0.34 | 12.3 | 400 | H | KA 08
 | R-01 | 10.47 | 45.04 | 182.76 | 7.16 | 1.24 | 37.54 | 0.65 | 0.28 | 4.36 | 400 | B | KA 02
 | R-07 | 10.06 | 50.57 | 114.96 | 9.73 | 0.93 | 28.86 | 0.6 | 0.74 | 9.21 | 400 | E | KA 05
 | R-08 | 7.84 | 45.85 | 146.36 | 3.98 | 1.29 | 44.29 | 0.73 | 0.41 | 20.69 | 400 | F | KA 06
 | RR-05 | 11.31 | 46.76 | 112.06 | 6.84 | 0.72 | 37.34 | 0.71 | 0.33 | 9.33 | 400 | C | KA 03
 | RR-09 | 10.95 | 47.59 | 113.88 | 4.93 | 1.27 | 38.29 | 0.71 | 0.39 | 14 | 400 | G | KA 07
 | RR-12 | 10.83 | 48.1 | 129.52 | 7.03 | 1.39 | 35.85 | 0.67 | 0.34 | 11.91 | 400 | I | KA 09
Spreadsheet: 126728d1319837563-excel-2007-conditional-format-cells-today-conditional-format-v-today1
Sheet: Sheet1

I NEED A CONDITIONAL FORMAT FOR CELLS LESS THAN TODAY??? Row 4 Working Automatically.
See [NAME] for Row 4.
 | Today
2011-10-15 00:00:00
a
 |  | r |  |  |  |  |  | q |  |  | t
x |  |  |  | f
 | e
b |  |  |  |  |  | v
 |  |  |  |  |  |  |  |  |  |  |  | t
RESULTS NEEDED TO POPULATE CONDITIONAL FORMULA BELOW THE DATE ROW-
Spreadsheet: 133437d1324394787-calculating-gross-from-a-percentage-calculating-gross-from-percentage
Sheet: Sheet1

35 | 97.8854 | Takes the % from column A, the amount in column B, and puts the gross into column C
35 | 58.73704
35 | 29.36271
40 | 43.43228
40 | 15.32907
40 | 54.50304
40 | 5.1096
25 | 4.55945
25 | 1.82376
25 | 0.91191
25 | 10.94274
Spreadsheet: 103361d1301085983-auto-categorization-with-if-function-auto-categorization
Sheet: Sheet1

Keyword | Category
dog diagnosis | uncategorized
dogs health problems | uncategorized
sick puppy | uncategorized
pet illness | uncategorized
pet health problems | uncategorized
sick pets | uncategorized
dog ear problems | uncategorized
dog heart murmur | uncategorized
cat skin problems | uncategorized
dog skin problems | uncategorized
dog dry skin | uncategorized
skin conditions in dogs | uncategorized
dog skin problem | uncategorized
cat diseases | uncategorized
cat disease | uncategorized
feline diseases | uncategorized
dog diseases | uncategorized
rabbit diseases | uncategorized
allergies in dogs | uncategorized
pet allergies | uncategorized
cat arthritis | uncategorized
arthritis dogs | uncategorized
dog arthritis treatment | uncategorized
arthritis dog | uncategorized
Spreadsheet: 38760d1236893225-count-in-multiple-ranges-count
Sheet: Sheet1

 |  |  |  |  | Status | Days Old | Severity
 |  |  |  |  | Open | 2 | 2
 |  |  |  |  | Open | 3 | 3
 |  |  |  |  | Open | 55 | 2
 |  |  |  |  | Open | 30 | 4
 |  |  |  |  | Pending | 11 | 4 |  |  | Requirement
 |  |  |  |  | Pending | 26 | 4 |  |  | count only if the status is open
 |  |  |  |  | Pending | 37 | 2
 |  |  |  |  | Closed | 11 | 4 |  |  | I need to count against values in 3 columns
 |  |  |  |  | Closed | 11 | 2 |  |  | if open
 |  |  |  |  | Closed | 12 | 2 |  |  | and if lessthan 10 days and Sev 1
 |  |  |  |  | Closed | 23 | 2 |  |  | and if lessthan 10 days and Sev 2
 |  |  |  |  | Closed | 36 | 2 |  |  | and if lessthan 10 days and Sev 3
 |  |  |  |  | Closed | 33 | 3 |  |  | and if lessthan 10 days and Sev 4
 |  |  |  |  | Closed | 44 | 3 |  |  | and if morethan 10 and lessthan 20 and sev 1
 |  |  |  |  | Closed | 54 | 4 |  |  | etc
 |  |  |  |  | Closed | 100 | 2
 |  |  |  |  | Open | 10 | 1
 |  |  |  |  | Open | 15 | 1
 |  |  |  |  | Open | 16 | 2
 |  |  |  |  | Open | 15 | 3
 |  |  |  |  | Open | 56 | 3
 |  |  |  |  | Open | 33 | 1
 |  |  |  |  | Open | 38 | 2
 |  |  |  |  | Open | 99 | 4
 |  |  |  |  | Age of the defect in Days | Sev1 | Sev2 | Sev3 | Sev4
 |  |  |  |  | 0-10days | 1 | 1 | 1 | 0
 |  |  |  |  | 11-20days | 0 | 0 | 0 | 0
 |  |  |  |  | 21-30days | 2 | 1 | 1 | 0
 |  |  |  |  | 31-50days | 2 | 1 | 1 | 0
 |  |  |  |  | 50+days | 2 | 1 | 1 | 0
Spreadsheet: 90208d1289958584-counting-the-number-of-rows-in-column-b-for-a-given-row-in-column-a-field-count-by-tables-example-pivot
Sheet: Sheet1

INITIAL |  |  |  | DESIRED
 |  |  |  | Table Name | Field Count
Table Name | Field Name |  |  | abc | 6
abc | x |  |  | def | 5
abc | y |  |  | ghi | 11
abc | z |  |  | klm | 3
abc | q
abc | r
abc | s
def | g |  |  | Row Labels | Count of Field Name
def | h |  |  | abc | 6
def | i |  |  | def | 5
def | j |  |  | ghi | 11
def | k |  |  | klm | 3
ghi | a |  |  | Grand Total | 25
ghi | b
ghi | c
ghi | d
ghi | e |  |  | Use a simple pivot table to count the field names for each table. Double click on the number 6, for example, and get a list of the field names for the specific table.
ghi | f
ghi | g
ghi | h
ghi | i
ghi | j
ghi | k
klm | e
klm | f
klm | g
Spreadsheet: 150102d1334288007-take-column-data-from-one-sheet-to-another-based-on-unique-identifier-sample1
Sheet: Sales

[NAME] | Order number | Version
[EMAIL] | 69009
[EMAIL] | 69010
[EMAIL] | 69011
[EMAIL] | 69012
[EMAIL] | 69013
[EMAIL] | 69014
[EMAIL] | 69015
[EMAIL] | 69016
[EMAIL] | 69017
[EMAIL] | 69018
[EMAIL] | 69019
[EMAIL] | 69020
[EMAIL] | 69021
[EMAIL] | 69022
Spreadsheet: 13c98d28-039d-4ac0-a731-bcabc4ee19ef
Sheet: Sheet1

WPU Value Fiscal Years 1976-2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | WPU | Dollar | Percent
Year | Value | Change | Change
1975-76 | 621 | 0 | -----
1976-77 | 683 | 62 | 0.0998389694041868
1977-78 | 732 | 49 | 0.07174231332357248
1978-79 | 795 | 63 | 0.0860655737704918
1979-80 | 852 | 57 | 0.07169811320754717
1980-81 | 946 | 94 | 0.1103286384976526
1981-82 | 1003 | 57 | 0.06025369978858351
1982-83 | 1103 | 100 | 0.09970089730807577
1983-84 | 1103 | 0 | 0
1984-85 | 1124 | 21 | 0.01903898458748867
1985-86 | 1180 | 56 | 0.0498220640569395
1986-87 | 1204 | 24 | 0.02033898305084746
1987-88 | 1204 | 0 | 0
1988-89 | 1204 | 0 | 0
1989-90 | 1240 | 36 | 0.02990033222591362
1990-91 | 1346 | 106 | 0.08548387096774193
1991-92 | 1408 | 62 | 0.04606240713224369
1992-93 | 1490 | 82 | 0.05823863636363636
1993-94 | 1539 | 49 | 0.03288590604026845
1994-95 | 1608 | 69 | 0.04483430799220273
1995-96 | 1672 | 64 | 0.03980099502487562
1996-97 | 1739 | 67 | 0.04007177033492823
1997-98 | 1791 | 52 | 0.02990224266820012
1998-99 | 1854 | 63 | 0.03517587939698492
1999-00 | 1901 | 47 | 0.02535059331175836
2000-01 | 2006 | 105 | 0.05523408732246186
2001-02 | 2116 | 110 | 0.05483549351944168
2002-03 | 2132 | 16 | 0.007561436672967864
2003-04 | 2150 | 18 | 0.008442776735459663
2004-05 | 2182 | 32 | 0.01488372093023256
2005-06 | 2280 | 98 | 0.04491292392300641
2006-07 | 2417 | 137 | 0.06008771929824561
2007-08 | 2514 | 97 | 0.04013239553165081
2008-09 | 2577 | 63 | 0.02505966587112172
Average increase from 1977 to 2008 |  |  | 0.04447531509874934
10 Year Increase from 2000 to 2009 |  |  | 0.3365008131163466
10 Year Average increase from 2000 to 2009 |  |  | 0.03365008131163465
Spreadsheet: 59274d1259767506-vlook-up-from-across-several-worksheet-sample09
Sheet: October 09

Name | Ref. Date | Code | Ref. source | 1st Contact | Sale Date
A Test | 2009-10-01 00:00:00 | 10001 | Street | 2009-10-05 00:00:00 | 2009-10-07 00:00:00
B Test | 2009-10-02 00:00:00 | 10002 | Home | 2009-10-08 00:00:00 | 2009-10-13 00:00:00
C Test | 2009-10-02 00:00:00 | 10003 | Work | 2009-10-08 00:00:00 | 2009-10-13 00:00:00
D Test | 2009-10-05 00:00:00 | 10004 | Team Air | 2009-10-06 00:00:00 | 2009-10-18 00:00:00
E Test | 2009-10-06 00:00:00 | 10005 | Self | 2009-10-07 00:00:00 | 2009-10-07 00:00:00
F Test | 2009-10-06 00:00:00 | 10006 | Home | 2009-10-06 00:00:00 | 2009-10-13 00:00:00
G Test | 2009-10-06 00:00:00 | 10007 | Street | 2009-10-06 00:00:00 | 2009-10-09 00:00:00
H Test | 2009-10-07 00:00:00 | 10008 | Self | 2009-10-12 00:00:00 | 2009-10-22 00:00:00
F Test | 2009-10-08 00:00:00 | 10009 | Team Air | 2009-10-12 00:00:00 | 2009-10-21 00:00:00
Spreadsheet: 778664d1651212818-find-sequence-of-numbers-sequence
Sheet: Sheet1

Date | 2022-04-01 00:00:00 | 2022-04-02 00:00:00 | 2022-04-03 00:00:00 | 2022-04-04 00:00:00 | 2022-04-05 00:00:00 | 2022-04-06 00:00:00 | 2022-04-07 00:00:00 | 2022-04-08 00:00:00 | 2022-04-09 00:00:00 | 2022-04-10 00:00:00 | 2022-04-11 00:00:00 | 2022-04-12 00:00:00 | 2022-04-13 00:00:00 | 2022-04-14 00:00:00 | 2022-04-15 00:00:00 | Sequence
reading-1 | 2 | 1 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 2 | 1 | 3 | 4 | 2 | 3 | Y
reading-2 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 3 | N
reading-3 | 2 | 2 | 1 | 1 | 2 | 1 | 3 | 4 | 2 | 3 | 4 | 5 | 2 | 1 | 3 | Y
[NAME] | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 2 | 1 | 2 | 3 | 1 | 1 | 2 | 1 | Y
Need formula when a sequence of 3 or more numbers appear at least once  (if yes, 'Y', else 'N')
Spreadsheet: 71f82586-64dd-409e-bc3a-b5a846e7df45
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
PARO | Test | PARO | Paroxetine, Serum | Paroxetine, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube: Red top  [NAME]: 0.5 mL Collection Instructions: Spin down within 2 hours of draw. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | 30-90 ng/mL | Monday through Friday | 2 days | 5 days | 1 | 80299 |  |  |  |  | Rochester
PARO | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
PARO | Result | 83731 | Paroxetine, S | Paroxetine, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 9699-0
Spreadsheet: 75166d1275680025-create-macro-to-do-vlookup-sku-to-material-number-x-ref-formatter-exmpl
Sheet: Sheet1

Paste your unfomatted SKU list in Column A, then Click the Button
Paste SKUs Here (start in row 4): | Formatted Sku | Compressed Sku |  | Price | Alpha | Basic
3JTD32K | 0003JTD032K | 3JTD32K |  | 3 | JTD | 032K | #N/A
3JTX315N | 0003JTX315N | 3JTX315N |  | 3 | JTX | 315N
3JTX316N | 0003JTX316N | 3JTX316N |  | 3 | JTX | 316N
3JTX318N | 0003JTX318N | 3JTX318N |  | 3 | JTX | 318N
3KHB22G | 0003KHB022G | 3KHB22G |  | 3 | KHB | 022G
3KHB49Q | 0003KHB049Q | 3KHB49Q |  | 3 | KHB | 049Q
3KHB55Q | 0003KHB055Q | 3KHB55Q |  | 3 | KHB | 055Q
3KHB56Q | 0003KHB056Q | 3KHB56Q |  | 3 | KHB | 056Q
3KHB96H | 0003KHB096H | 3KHB96H |  | 3 | KHB | 096H
3KHB97H | 0003KHB097H | 3KHB97H |  | 3 | KHB | 097H
Spreadsheet: 693215d1598868020-if-formula-but-ignore-blank-and-move-to-next-criteria-pq-mf-summary-aligw
Sheet: Females

 | Names | Dates | Location
 |  |  |  |  | Names | Dates | Location
 |  |  |  |  | Steff | 1981-08-09 00:00:00 | Liverpool
 |  |  |  |  | Michelle | 1984-02-01 00:00:00 | [NAME]
Spreadsheet: cf5113e5-b939-47a7-ab83-3a2889e3de72
Sheet: Sheet1

B | JEWISH_freq | JEWISH_rank
702 | 0.02789 | 15
704 | 7e-05 | 80
705 | 0.02394 | 17
707 | 7e-05 | 78
747 | 7e-05 | 74
801 | 0.03716 | 11
1301 | 0.00053 | 60
1302 | 0.03131 | 13
1401 | 0.00197 | 45
1402 | 0.04775 | 6
1403 | 7e-05 | 86
1501 | 0.01 | 25
1502 | 0.00013 | 72
1503 | 0.00934 | 27
1508 | 0.00053 | 61
1509 | 0.00053 | 62
1510 | 0.00158 | 48
1513 | 7e-05 | 87
1516 | 0.00138 | 50
1517 | 0.01907 | 21
1518 | 0.00118 | 52
1524 | 0.00072 | 56
1525 | 7e-05 | 81
1529 | 0.00059 | 58
1531 | 0.0002 | 65
1801 | 0.05887 | 2
1803 | 0.00013 | 68
1805 | 0.0002 | 64
2702 | 0.00829 | 29
2703 | 0.00072 | 55
2705 | 0.00335 | 37
2707 | 0.00303 | 40
2708 | 7e-05 | 82
2709 | 0.00013 | 70
2712 | 0.00059 | 59
3501 | 0.0513 | 4
3502 | 0.04939 | 5
3503 | 0.0267 | 16
3505 | 0.00013 | 73
3508 | 0.02322 | 18
3555 | 0.00026 | 63
3701 | 0.00947 | 26
3702 | 0.00105 | 53
3704 | 0.00013 | 67
3801 | 0.10359 | 1
3802 | 0.00013 | 71
3809 | 7e-05 | 79
3901 | 0.00355 | 36
3906 | 0.00164 | 47
3910 | 0.00138 | 49
3924 | 0.00092 | 54
4001 | 0.00927 | 28
4002 | 0.00717 | 31
4006 | 0.00322 | 38
4101 | 0.04242 | 8
4102 | 0.01625 | 24
4201 | 0.00118 | 51
4202 | 0.0002 | 66
4402 | 0.0419 | 9
4403 | 0.02881 | 14
4405 | 0.00447 | 32
4406 | 7e-05 | 84
4460 | 7e-05 | 75
4501 | 0.00401 | 33
4701 | 0.00184 | 46
4702 | 0.00013 | 69
4801 | 0.00237 | 43
4804 | 0.00072 | 57
4901 | 0.03729 | 10
5001 | 0.03499 | 12
5002 | 0.00388 | 34
5004 | 7e-05 | 77
5101 | 0.04348 | 7
5107 | 0.00243 | 42
5108 | 0.00763 | 30
5109 | 7e-05 | 83
5137 | 7e-05 | 76
5201 | 0.05485 | 3
5301 | 0.01625 | 23
5501 | 0.02065 | 19
5601 | 0.00316 | 39
5701 | 0.01842 | 22
5702 | 0.00362 | 35
5703 | 0.0025 | 41
5801 | 0.01973 | 20
7301 | 0.00217 | 44
7801 | 7e-05 | 85
8202 | 7e-05 | 88
Spreadsheet: 687674d1595344684-calculation-issue-calculation-isue
Sheet: Sheet1

 |  |  | Packs | Cost | [NAME] | Total | Total
 |  |  |  | Per Pack [NAME], VAT | 0.23 | Per Pack Inc Vat
 | Calculated by formula |  | 8 | 4.15
 |  |  |  |  | Total to Pay
 | My problem is the cost of the individual Item multiplied by the number of items is not the same as if multiplied on paper
 |  |  |  |  |  | Full Price Per Pack | Total
 | Simple Calculation |  | 8 |  |  | 5.1
 |  |  |  |  |  | Error
Spreadsheet: 706155d1606501278-dip-in-bell-curve-data-distribution-generator-r1-1-2-
Sheet: curve type

 | Curve List Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checker
Duration % --> | Progress: | 0
Curve Value % --> | Bell Shaped | 0 | 0.005 | 0.005 | 0.015 | 0.015 | 0.04 | 0.04 | 0.075 | 0.075 | 0.115 | 0.115 | 0.115 | 0.115 | 0.075 | 0.075 | 0.04 | 0.04 | 0.015 | 0.015 | 0.005 | 0.005
 | Back Loaded | 0 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065
 | Front Loaded | 0 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035
 | Linear | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
 | Offset Triangular | 0 | 0.01 | 0.01 | 0.025 | 0.025 | 0.035 | 0.035 | 0.05 | 0.05 | 0.065 | 0.065 | 0.075 | 0.075 | 0.085 | 0.085 | 0.07 | 0.07 | 0.05 | 0.05 | 0.035 | 0.035
Spreadsheet: 857886d1706744612-create-a-changeable-output-from-checkbox-criteria-check-box-help
Sheet: Output

 | EU27 | Count |  | LATAM | Count
 | France | 12 |  | Brazil | 9
 | Germany | 32 |  | Argentina | 44
 | Spain | 1
 | Italy | 5
 | Netherlands | 7
 |  | Count |  | LATAM | Count
 | France | 12 |  | Brazil | 9
 | Germany | 32 |  | Argentina | 44
 | Spain | 1
 | Italy | 5
 | Netherlands | 7
Spreadsheet: 717568d1612742205-returning-multiple-results-from-between-two-dates-rwr-vehicle-fuel-tracking-worksheetrevised
Sheet: WA230

Choose a Vehicle below to change pages |  |  |  |  | Vehicle Fuel Tracking Worksheet
 |  |  |  |  | Date | Mileage | Fuel (Gallons) | Fuel ($$.$$) | MPG
WA 211 | WA 248 | ESG 244
WA 223 | WA 255 | ESG 251
WA 224 | WA 256 | ESG 258
WA 229 | WA 257 | ESG 267
WA 230 | WA 261 | ESG 268
WA 231 | WA276 | ESG 270
WA 232 | WA 278 | ESG 271
WA 234 | WA 50 | ESG 277
WA 239 | WA265 | ESG 279
WA 240 | WA266 | ESG 280
WA 242 | WA 202
Spreadsheet: 3b39c74e-fd69-471a-b775-bf2365d7d2a4
Sheet: Details & Draw Requests

 | Period One |  |  |  | Period Two |  |  |  | Period Three
Instructions: Use this tab to make draw request from IOD escrow. Only modify shaded blue cells. | Month 1 Forecast | Month 1 Actual | Month 2 Forecast | Month 2 Actual | Month 3 Forecast | Month 3 Actual | Month 4 Forecast | Month 4 Actual | Month 5 Forecast | Month 5 Actual | Month 6 Forecasted | Month 6 Actual | Month 7 Forecasted | Month 7 Actual | Month 8 Forecast | Month 8 Actual | Month 9 Forecast | Month 9 Actual | Month 10 Forecast | Month 10 Actual | Month 11 Forecast | Month 11 Actual | Month 12 Forecast | Month 12 Actual | Month 13 Forecast | Month 13 Actual | Month 14 Forecast | Month 14 Actual | Month 15 Forecast | Month 15 Actual | Month 16 Forecast | Month 16 Actual | Month 17 Forecast | Month 17 Actual | Month 18 Forecast | Month 18 Actual | Month 19 Forecast | Month 19 Actual | Month 20 Forecast | Month 20 Actual | Month 21 Forecast | Month 21 Actual | Month 22 Forecast | Month 22 Actual | Month 23 Forecast | Month 23 Actual | Month 24 Forecast | Month 24 Actual | Month 25 Forecast | Month 25 Actual | Month 26 Forecast | Month 26 Actual | Month 27 Forecast | Month 27 Actual | Month 28 Forecast | Month 28 Actual | Month 29 Forecast | Month 29 Actual | Month 30 Forecast | Month 30 Actual | Month 31 Forecast | Month 31 Actual | Month 32 Forecast | Month 32 Actual | Month 33 Forecast | Month 33 Actual | Month 34 Forecast | Month 34 Actual | Month 35 Forecast | Month 35 Actual | Month 36 Forecast
 | 0 |  | 0
 | 0 |  | 0
 | 0 |  | 0
 | 0 |  | 0
Total Occupied Units
Total Resident Days
EGI
 | 0 | 0 | 0 | 0
 | 0 |  | 0
 | 0 |  | 0
 | 0 |  | 0 |  | 0 |  | 0
Total Expenses
NOI
P+I | 0 |  | 0
MIP | 0 |  | 0
Income/Loss per Period
Cumulative Income/Loss
Expense Ratio | NA | NA | NA | NA
% of UW Expense
Occupancy
[NAME]
Dollar Difference from Scheduled Draws
Amount Approved (entered by HUD)
Escrow Balance
IOD Base Requirement
Spreadsheet: 752657d1634887327-check-previous-days-to-see-if-there-is-a-match-then-return-results-from-matching-columns-sample-a
Sheet: Sample

 | High | Low | Close | Pivot | Data being collected (Hi Analysis) |  |  | Data being collected (Lo Analysis |  |  | Forumula needed to extract data from the Hi analysis and [NAME] analysis
2020-12-25 00:00:00 | 0.97572 | 0.97002 | 0.97261
 | 0.97726 | 0.9716 | 0.97599
 | 0.97844 | 0.97275 | 0.97368 |  | 0.9749 | 0.9756 | 0.9762 | 0.9725 | 0.9717 | 0.9712
 | 0.9759 | 0.97272 | 0.97432
 | 0.98128 | 0.97353 | 0.9799 |  | 0.9829 | 0.9839 | 0.9847 | 0.9791 | 0.9781 | 0.9773
 | 0.98578 | 0.9784 | 0.97853
 | 0.98168 | 0.97733 | 0.9788
 | 0.9857 | 0.97834 | 0.98246 |  | 0.9853 | 0.9855 | 0.987 | 0.9822 | 0.982 | 0.9804
 | 0.98987 | 0.9815 | 0.98843 |  | 0.9916 | 0.9928 | 0.9936 | 0.9866 | 0.9855 | 0.9846
 | 0.98997 | 0.98298 | 0.98546
 | 0.98858 | 0.98285 | 0.985 |  |  |  |  |  |  |  | 0.9853 | 0.9855 | 0.987 | 0.9822 | 0.982 | 0.9804
 | 0.98585 | 0.9812 | 0.9837 |  |  |  |  |  |  |  | 0.9853 | 0.9855 | 0.987 | 0.9822 | 0.982 | 0.9804
 | 0.98885 | 0.98216 | 0.98757 |  | 0.9901 | 0.991 | 0.9917 | 0.9866 | 0.9858 | 0.985 | 0.9916 | 0.9928 | 0.9936 | 0.9866 | 0.9865 | 0.9846
 | 0.98868 | 0.98132 | 0.98132 |  |  |  |  |  |  |  | 0.9853 | 0.9855 | 0.987 | 0.9791 | 0.9781 | 0.9773
 | 0.98537 | 0.98058 | 0.98237 |  |  |  |  |  |  |  | 0.9853 | 0.9855 | 0.987 | 0.9822 | 0.982 | 0.9804
 | 0.98419 | 0.97946 | 0.98004 |  |  |  |  |  |  |  | 0.9829 | 0.9839 | 0.9847 | 0.9791 | 0.9781 | 0.9773
 | 0.98334 | 0.97836 | 0.97932 |  |  |  |  |  |  |  | 0.9749 | 0.9756 | 0.9762 | 0.9725 | 0.9717 | 0.9712
2021-01-19 00:00:00
2021-01-20 00:00:00
2021-01-21 00:00:00
Spreadsheet: 853084d1703032484-subtotal-with-multiple-criteria-and-or-sumproduct-test-sumproduct
Sheet: Surveys_Sent_2023-12-19_14-44

 |  |  | The formula generating the results in the Opened column for sms and email are not accurate.
 | Delivery Method | Total | Opened | Responded
 | sms
 | [NAME]
 | Total
 | Response %
 | Totals
status | dontcontact | sent | opened | responded | deliverymethod
 |  | 2023-12-19 12:03:55 | 2023-12-19 12:06:16 |  | sms
 |  | 2023-12-19 12:03:55 |  |  | sms
 |  | 2023-12-19 12:03:55 |  |  | sms
 |  | 2023-12-19 12:03:55 |  |  | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 | 2023-12-19 12:07:31 | 2023-12-19 12:08:01 | sms
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 |  |  | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 | 2023-12-19 14:15:08 | 2023-12-19 14:15:30 | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 |  |  | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:53 |  |  | sms
 |  | 2023-12-19 12:03:53 | 2023-12-19 12:09:13 | 2023-12-19 12:09:29 | sms
 |  | 2023-12-19 12:03:53 |  |  | sms
 |  | 2023-12-19 12:03:54 | 2023-12-19 12:07:31 | 2023-12-19 12:08:01 | sms
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 |  |  | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 | 2023-12-19 14:15:08 | 2023-12-19 14:15:30 | email
Spreadsheet: 98747d1297616074-conditional-formatting-rule-returning-true-but-format-not-applied-conditionalformattingnotworking
Sheet: Sheet1

Task Name | Status | Expected Finish Date | Date Closed | Not Closed | Estimated Finish Date past-due | Today Value | Expected Closed Value | Both Conditions
One | Started | 2011-02-10 00:00:00 | 2011-02-09 00:00:00
Two | Waiting | 2011-02-14 00:00:00
Three | Started | 2011-02-09 00:00:00
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: FABRICATION

FABRICATION
[NAME]. | SAP NO. | NAME | SECTION
 | 224 |  |  | C
 | 212 |  |  | C
 | 239 |  |  | C
 | 146 |  |  | B
 | 215 |  |  | B
 | 193 |  |  | A
 | 128 |  |  | C
 | 179 |  |  | B
 | 138 |  |  | B
 | 221 |  |  | B
 | 134 |  |  | A
 | 202 |  |  | B
 | 143 |  |  | B
 | 169 |  |  | C
 | 178 |  |  | C