tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94278d1294141243-convert-data-with-logfile-structure-to-spreadsheet-structure-extract-from-list
Sheet: Sheet1

---------- | TYPE | NUMBER | NAME | CALLTYPEV2 | OTHERPARTYTYPE | ENDCAUSE | ENDCAUSESIP | ENDCAUSESTRING | ENDLOCATION | CALLSTARTTIME | CONNSTARTTIME | CALLENDTIME | DURATION | NEWVOICEMAIL
TYPE=CALL1 | CALL1 | 123456789 | [NAME] | 2 | 2 | 1 | -1 | Called party ended the call | 2 | 2009-6-29 17:56:30 | 2009-6-29 17:56:36 | 2009-6-29 18:1:48 | 0:5:12 | NO
NUMBER=123456789 | CALL | 123456777 | [NAME] | 2 | 2 | 1 | -1 | Called party ended the call | 2 | 2009-7-8 12:52:18 | 2009-7-8 12:52:38 | 2009-7-8 12:54:36 | 0:1:58 | NO
NAME=[NAME] | CALL | 123456789 | [NAME] | 2 | 2 | 1 | -1 | Called party ended the call | 2 | 2009-6-29 17:56:30 | 2009-6-29 17:56:36 | 2009-6-29 18:1:48 | 0:5:12 | NO
CALLTYPEV2=2 | CALL 50 | 999999999 | martin | 2 | 2 | 1 | -1 | Called party ended the call | 2 | 2009-7-8 12:52:18 | 2009-7-8 12:52:38 | 2009-7-8 12:54:36 | 0:1:58 | yes
OTHERPARTYTYPE=2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
ENDCAUSE=1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
ENDCAUSESIP=-1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
ENDCAUSESTRING=Called party ended the call | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
ENDLOCATION=2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
CALLSTARTTIME=2009-6-29 17:56:30 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
CONNSTARTTIME=2009-6-29 17:56:36 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
CALLENDTIME=2009-6-29 18:1:48 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
DURATION=0:5:12 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
NEWVOICEMAIL=NO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
----------
TYPE=CALL
NUMBER=123456777
NAME=james
CALLTYPEV2=2
OTHERPARTYTYPE=2
ENDCAUSE=1
ENDCAUSESIP=-1
ENDCAUSESTRING=Called party ended the call
ENDLOCATION=2
CALLSTARTTIME=2009-7-8 12:52:18
CONNSTARTTIME=2009-7-8 12:52:38
CALLENDTIME=2009-7-8 12:54:36
DURATION=0:1:58
NEWVOICEMAIL=NO
----------
TYPE=CALL
NUMBER=123456789
NAME=[NAME]
CALLTYPEV2=2
OTHERPARTYTYPE=2
ENDCAUSE=1
ENDCAUSESIP=-1
ENDCAUSESTRING=Called party ended the call
ENDLOCATION=2
CALLSTARTTIME=2009-6-29 17:56:30
CONNSTARTTIME=2009-6-29 17:56:36
CALLENDTIME=2009-6-29 18:1:48
DURATION=0:5:12
NEWVOICEMAIL=NO
-----------
TYPE=CALL 50
NUMBER=999999999
NAME=martin
CALLTYPEV2=2
OTHERPARTYTYPE=2
ENDCAUSE=1
ENDCAUSESIP=-1
ENDCAUSESTRING=Called party ended the call
ENDLOCATION=2
CALLSTARTTIME=2009-7-8 12:52:18
CONNSTARTTIME=2009-7-8 12:52:38
CALLENDTIME=2009-7-8 12:54:36
DURATION=0:1:58
NEWVOICEMAIL=yes
----------
Spreadsheet: 158680d1338342914-creating-dynamic-list-dyna
Sheet: Sheet1

Number | Name | Class | Region | Category
1 | N1 | q | East | SC
2 | N2 | w | West | ST
3 | N3 | e | North | General
4 | N4 | r | South | Other
5 | N5 | t | EW
6 | [NAME] | y
7 | N7 | a
8 | N8 | s
9 | N9 | d
10 | N10 | f
11 | N11 | g
12 | N12 | h
13 | N13 | j
14 | [NAME] | k
15 | N15 | l
16 | N16 | o
17 | N17 | p
18 | N18
19 | N19
20 | N20
21 | N21
22 | N22
23 | N23
24 | N24
25 | N25
26 | N26
27 | N27
28 | N28
29 | N29
30 | N30
31 | N31
32 | N32
33 | N33
34 | N34
35 | N35
36 | N36
37 | N37
38 | N38
39 | N39
40 | N40
41 | N41
42 | N42
43 | N43
44 | N44
45 | N45
46 | N46
47 | N47
48 | N48
49 | N49
50 | N50
51 | N51
52 | N52
53 | N53
Spreadsheet: 848737d1699380243-combine-aggregated-lists-in-to-a-separate-combined-list-aggregated-lists
Sheet: Blue Train

Ref No | Vehicle | Colour
Spreadsheet: 52527d1252347807-two-questions-on-how-to-make-my-formulae-smarter-example2-for-excel-forum
Sheet: Tabulation Sheet

 | Building A | Building B | Building C | Building D | Building E | Building F
2009-08-27 00:00:00 | 68490.84603883 | 16.31664971169139 | 6092.987747191803 | 26388.03765869401 | 8976 | 28689
2009-08-28 00:00:00 | 66372.13348389001 | 16.08753038104565 | 8815.951187131503 | 26097.95138549998 | 8406 | 27278
2009-08-29 00:00:00 | 44956.85562133697 | 10.10507706739083 | 6229.252117156901 | 13413.440887451 | 5745 | 17798
2009-08-30 00:00:00 | 44846.849243164 | 10.10681771393839 | 6604.246116638198 | 13394.670242305 | 5084 | 17003
2009-08-31 00:00:00 | 67627.940612789 | 15.3011383442219 | 9926.8482780443 | 26909.65103149401 | 9229 | 29270
2009-09-01 00:00:00 | 67569.48471068901 | 16.17069368483375 | 9878.2219581612 | 26223.46923828201 | 9273 | 27209
2009-09-02 00:00:00 | 68106.01068114898 | 15.81167832901622 | 9931.964427951796 | 25127.83332824901 | 8625 | 28638
2009-09-03 00:00:00 | 51656.43554687399 | 15836.5128326397 | 9685.206455228803 | 24577.96285248001 | 9138 | 28800
2009-09-04 00:00:00 | 50132.533172609 | 16904.44430541749 | 9359.645427706802 | 24585.550857547 | 8510 | 29296
2009-09-05 00:00:00 | 30124.917480471 | 5414.915740969399 | 4184.551227569598 | 9745.256820678998 | 3600 | 14017
2009-09-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2009-09-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2009-09-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 127319d1320294416-excel-2007-need-to-find-if-duplicate-values-exist-in-a-master-sheet-compare-in-new-generated-sh-mutkumram-2011-11-02
Sheet: Output

priority | internal | co no | pol no | rid no | proces | step
5 | 1 | 2R | 12345785 | 0 | ANS | NYN
5 | -2 | 3G | 12358953 | 0 | ADD | chg
5 | -4 | 3K | 12003915 | 0 | Pol | chk
Spreadsheet: 127636d1320437382-excel-2007-count-unique-records-book1
Sheet: Sheet1

Name | Received
[NAME] | Q1
[NAME] | Q1
[NAME] | Q3
[NAME] | Q1
[NAME] | Q1
[NAME] | Q2 |  |  |  |  | Received | Unique People
[NAME] | Q2 |  |  |  |  | Q1 | 3
[NAME] | Q1 |  |  |  |  | Q2 | 2
[NAME] | Q2 |  |  |  |  | Q3 | 2
[NAME] | Q3 |  |  |  |  | Q4 | 1
[NAME] | Q4
[NAME] | Q4
[NAME] | Q4
[NAME] | Q4
[NAME] | Q4
Spreadsheet: 193981d1353003109-picking-up-neighbor-numbers-in-the-follow-row-another-if-then-scenario-workbook121
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 11 |  |  | 5
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 11 |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
6 | 13 | 16 | 22
Spreadsheet: 795783d1662937781-i-am-trying-to-build-a-formula-for-inventory-storage-values-one-worksheet-to-another-ft-testing-hd
Sheet: Totals

TEMPLATE NAMES | INVENTORY STORAGE
Blue Hydrangea
Blue Ink
Blue Pigment
Blueberries
Blueberry Field
[NAME]
[NAME]
Blush
Board Games Factory
Boat Pulpit
Boat Supplies Factory
Boat Yard
[NAME]
[NAME]
Boba Tea Supplies Factory
Boba Tea Supplies Store
Bobotie
[NAME]
[NAME]
Bok Choy
Bok Choy Field
Bolster
Book Ends
Book Weight
Bookcase
[NAME]
Bookstore
Boots
Boston Creme Donut
Bottle Factory
[NAME]
[NAME]
[NAME]
 | TAKE  DATA FROM THE "STORAGE" WORKSHEET COLUMN  G. AND INPUT IT THROUGH A FORMULA INTO THE "TOTALS" WORKSHEET IN COLUMN B.
Spreadsheet: 889752d1740666320-index-match-match-with-multiple-criteria-index-match-match-with-multiple-criteria
Sheet: Sheet1

 | Example Data |  |  |  |  |  |  | Required Output
 |  |  |  |  |  |  |  | Asset # | Task 1 |  | Task 2 |  | Task 3 |  | Task 4 |  | ← Task number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] string (used for further processing)
 | Asset # | Start Date | Task 1 | Task 2 | Task 3 | Task 4 |  |  | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | ← Task event (e.g. 1 = 1st, 2 = 2nd)
 | 10001 | 2023-03-02 00:00:01 | x |  |  |  |  | 10001 | 2023-03-02 00:00:01 | 2026-05-05 00:00:00 |  |  | 2026-05-05 00:00:00 |  |  |  | [NAME] required for output. This requires a formula to pull from B6:G16
 | 10002 | 2023-04-13 00:00:02 | x |  |  |  |  | 10002 | 2023-04-13 00:00:02 | 2027-10-04 00:00:00
 | 20001 | 2024-04-18 00:00:07 |  |  | x | x |  | 20001 |  |  |  |  | 2024-04-18 00:00:07 |  | 2024-04-18 00:00:07 | 2027-08-01 00:00:00
 | 20002 | 2024-05-20 00:00:08 |  |  |  | x |  | 20002 |  |  |  |  |  |  | 2024-05-20 00:00:08 | 2026-09-21 00:00:00
 | 20003 | 2024-05-31 00:00:09 |  | x |  |  |  | 20003 |  |  | 2024-05-31 00:00:09 | 2026-04-02 00:00:00 | 2026-04-02 00:00:00
 | 10001 | 2026-05-05 00:00:00 | x |  | x
 | 10002 | 2027-10-04 00:00:00 | x
 | 20001 | 2027-08-01 00:00:00 |  |  |  | x
 | 20002 | 2026-09-21 00:00:00 |  |  |  | x
 | 20003 | 2026-04-02 00:00:00 |  | x | x
Spreadsheet: 88df74a9-a479-4f83-b897-05b17b1d588d
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
SPB | Test | SPB | Pigeon Breeders Disease Serology, Serum | Pigeon Breeders Disease Serology, S | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | > or =16 years: < or =53.3 mg/L | Monday through, Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86671 |  |  |  |  | Rochester
SPB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SPB | Result | SPB | Pigeon Breeders Disease Serology, S | Pigeon Breeders Disease Serology, S | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 38368-7
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 6

 | Nov 30 |  | Dec 7 |  | Dec 14 |  | Dec 21
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500
SD/MSPs** | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap event volumes by asset class and participant type (in number of events), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type 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]
Spreadsheet: 286050d1388037573-data-gathering-spreadsheet-heartstone_help
Sheet: Arena

Date | ME | CPU | Win/Loss |  |  |  | Win/Loss | Druid | [NAME] | Mage | Paladin | Priest | Rogue | Warlock | Warrior
 | Paladin | Mage | Loss |  |  |  | Druid |  |  |  |  |  |  |  |  | =SUM(F2:M2)
 | Paladin | Mage | Loss |  |  |  | [NAME]
 | Paladin | Druid | Win |  |  |  | Mage
2013-11-01 00:00:00 | Paladin | Rogue | Loss |  |  |  | Paladin
2013-11-01 00:00:00 | [NAME] | Mage | Win |  |  |  | Priest
 | [NAME] | Priest | Win |  |  |  | Rogue
2013-11-04 00:00:00 | [NAME] | [NAME] | Win |  |  |  | Warlock
2013-11-05 00:00:00 | [NAME] | Rogue | Loss |  |  |  | Warrior
2013-11-06 00:00:00 | [NAME] | [NAME] | Win |  |  |  |  | =SUM(F2:F9)
2013-11-11 00:00:00 | [NAME] | Paladin | Win
 | [NAME] | Mage | Loss
 | [NAME] | Priest | Win
 | [NAME] | Warlock | Loss
 | Mage | [NAME] | Win
 | Mage
 | Mage
 | Mage
Spreadsheet: 194965d1353372460-help-with-bar-charts-or-something-better-to-compare-two-year-sales-charting-query-compare-2011-vs-2012
Sheet: Sheet2

Sum of Grand Total | Year
Company | 2011 | 2012 | Grand Total
CINCOTTA CHEMIST - BEAUMONT HILLS | 59.61 |  | 59.61
CINCOTTA CHEMIST - BELROSE | 1665.83 | 1124.91 | 2790.74
CINCOTTA CHEMIST - BLACKTOWN | 530.19 | 266.19 | 796.3800000000001
CINCOTTA CHEMIST - BURWOOD | 59.61 | 74.34 | 133.95
CINCOTTA CHEMIST - CARLINGFORD | 375.63 | 105.35 | 480.98
CINCOTTA CHEMIST - ENGADINE | 1559.35 | 291.84 | 1851.19
CINCOTTA CHEMIST - FIVE DOCK | 2416.35 | 465.84 | 2882.19
CINCOTTA CHEMIST - MERRYLANDS | 10372.84 | 5253.63 | 15626.47
CINCOTTA CHEMIST - NEUTRAL BAY | 1153.95 | 1141.15 | 2295.1
CINCOTTA CHEMIST - PIALBA | 0 |  | 0
CINCOTTA CHEMIST - REVESBY | 1383.18 | 254.77 | 1637.95
CINCOTTA CHEMIST GLEBE | 1212.16 | 1239.24 | 2451.4
CINCOTTA DISCOUNT CHEMIST RIVERSTON |  | 242.94 | 242.94
Grand Total | 20788.7 | 10460.2 | 31248.9
Spreadsheet: 164596d1340816602-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: MedicalManagement

Announcement Number | Employee Announcements
1
2
3
4
5
6
7
Announcement Number | Manager [NAME]
1
2
3
4
5
6
7
Spreadsheet: 67248d1267819683-excel-2007-dependent-drop-down-box-products
Sheet: Product

 | B/F or T/B | S/S |  | Quantity | Seat | Back
Hollow Fibre (Corovin) 2” | 12” | 12” |  | 1
Ok, so what I am trying to do here is firstly match a filling to a price
A2 contains the fillings in a drop down box taken from sheets 2 (list). It also contains a dimension of 2” in this example
You will see that on sheet 2 each filling has a seat price and a back price
I need a formula that returns a price that is calculated according to its filling, dimesions (B2 and C2) and price.
So, what we should get is this:-
 | B/F or T/B | S/S |  | Quantity | Seat | Back
Hollow Fibre (Corovin) 2” | 12” | 12” |  | 1 | 3.08 | 2.46
I hope this makes sense
Thank you
Spreadsheet: 738721d1625211380-how-can-i-adapt-multiple-sumproduct-formula-into-single-formula-sumproduct-example
Sheet: Sheet1

 |  | AA | AB | AC | AD
 |  | No | Yes | Yes | No
AA | YN | 1 | 3 | 5 | 8
AB | YY | 2 | 4 | 2 | 7
AC | NY | 3 | 5 | 7 | 4
AD | YN | 1 | 1 | 9 | 3
 |  |  |  |  |  |  |  | <<< How can I get this answer with single formula
 |  |  |  |  |  |  |  | I want to avoid just + adding sumproducts
Spreadsheet: 1bed8fa2-462d-4b16-8d29-74023829abb5
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Dec. | Jan. | Feb. |  | Feb.
Region/country | 2012 | 2013 | 2013 |  | 2012
 | 1,000 pounds 1/
North America | 128561.284 | 104814.416 | 132256.313 |  | 135234.706
Canada | 2607.225 | 2959.098 | 2724.511 |  | 2958.872
Costa Rica | 961.033 | 199.368 | 788.641 |  | 798.743
Dominican Republic | 5924.564 | 3981.692 | 6358.245 |  | 5559.827
El Salvador | 20594.708 | 13232.068 | 18308.671 |  | 20636.558
Guatemala | 6976.458 | 6580.228 | 7761.34 |  | 6846.417
Haiti | 12417.199 | 8448.22 | 12292.378 |  | 10935.061
Honduras | 31609.029 | 17598.227 | 28209.277 |  | 29024.805
Mexico | 33682.466 | 38789.236 | 42105.729 |  | 41925.688
Nicaragua | 13760.184 | 13025.862 | 13652.658 |  | 16543.857
South America | 3804.262 | 5059.74 | 3865.94 |  | 3593.075
Brazil | 121.364 | 93.478 | 131.639 |  | 221.161
Colombia | 1480.093 | 1794.295 | 1663.199 |  | 1041.966
Peru | 2139.697 | 3129.484 | 2020.194 |  | 2217.657
Europe | 9550.135 | 10660.673 | 10037.095 |  | 9355.796
Germany | 789.844 | 863.799 | 958.4 |  | 681.597
Italy | 1627.681 | 1686.528 | 1448.906 |  | 1490.982
Portugal | 1085.556 | 1194.01 | 1107.773 |  | 872.043
Turkey | 3805.249 | 4847.443 | 4480.481 |  | 3939.35
Asia | 457745.032 | 547968.57 | 521706.88 |  | 436542.434
Bahrain | 985.505 | 1166.533 | 1331.887 |  | 1514.367
Bangladesh | 35129.594 | 52851.101 | 51746.584 |  | 45803.296
Cambodia | 16769.271 | 18211.497 | 17091.386 |  | 18240.814
China | 207309.192 | 234106.926 | 229485.161 |  | 166266.178
Hong Kong | 927.597 | 877.38 | 811.289 |  | 904.54
India | 49763.097 | 60273.695 | 58861.543 |  | 57998.006
Indonesia | 26866.206 | 32741.73 | 29632.134 |  | 25997.349
Israel | 814.994 | 888.908 | 792.455 |  | 967.693
Japan | 1009.387 | 992.684 | 914.717 |  | 1147.706
Jordan | 4199.536 | 4267.479 | 4332.655 |  | 4052.509
Malaysia | 2612.682 | 3207.3 | 2963.467 |  | 2489.386
Pakistan | 46314.679 | 64598.634 | 52624.61 |  | 49778.48
Philippines | 4450.578 | 4982.837 | 4892.683 |  | 4775.144
South Korea | 4989.27 | 5997.976 | 5039.854 |  | 5332.133
Sri Lanka | 6376.124 | 7697.095 | 6420.051 |  | 7058.379
Taiwan | 2643.202 | 2664.392 | 2471.331 |  | 2720.612
Thailand | 7074.895 | 6680.908 | 6658.897 |  | 6520.883
Vietnam | 38583.156 | 44721.133 | 44717.441 |  | 33975.526
Oceania | 28.721 | 26.855 | 10.305 |  | 14.708
Africa | 13078.707 | 16080.987 | 11443.885 |  | 13143.356
Egypt | 7985.532 | 8995.577 | 6835.211 |  | 7160.672
Kenya | 1703.138 | 1693.832 | 1250.237 |  | 1812.913
[NAME] | 1880.87 | 3032.771 | 1522.063 |  | 2159.158
[NAME] | 488.26 | 892.035 | 726.662 |  | 651.388
World 2/ | 612768.141 | 684611.241 | 679320.418 |  | 597884.075
 |  |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update:  04/12/13.
Spreadsheet: 36029c84-575c-44fd-a12a-d5938087ccec
Sheet: Sheet1

Street Name | From | To | Unnamed: 3
Cecelia st | Lexington | [NAME]
Lexington | [NAME] | 8th
Wilson st | [NAME] | Hood
Airport Rd | Loop | 79
Kimbro | 7th | Cecelia
[NAME] | 7th | Lake
[NAME] | 2nd | 4th
4th | Vance | Fowzer
4th | Fowzer | [NAME]
Tenth | Main | [NAME]
Bull Branch | Parking Lot/Patch |  | This is for the dumpster not the whole parking lot
5TH | Main | Porter | Drainage Swale in the parking area
Otis | Parking Lot
[NAME] | 2nd | 7th
JM Cuba Dr | [NAME] | North Dr.
[NAME] | Loop | Dead End
[NAME] | Loop | Radius
North Dr | [NAME]. | Bridge
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | North Dr.
[NAME] | [NAME] | Hike /Bike
[NAME] | Lake Dr. | 1901 | 1901 is an address
[NAME] | 1901 | [NAME] | 1901 is an address
[NAME] | [NAME] | End
[NAME] | Radius | 40' raduis
Smith St | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
Vernon | 2nd st | 7th St
[NAME] | [NAME] | North Dr.
[NAME] | [NAME] | [NAME]
Mills St | [NAME] | [NAME]
3rd St | [NAME] | [NAME]
[NAME] | 7th St | Bridge
[NAME] | Main | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | 500 Sams
[NAME] | [NAME] | 2nd St
[NAME] | 3rd St | 2nd St
[NAME] | 2nd st | 1st St
[NAME] | Church 3rd | [NAME]
Southwood Hills | Loop | 1901 | 1901 is an address
[NAME] | 10th St | 7th St
Timbercrest | [NAME] | [NAME]
Cypress | Timbercrest | Pinehurst
Pinehurst | [NAME] | [NAME]
[NAME] | North Dr | End
Hosack | Main | Jones
Gravel Pit | Thorndale | 79
2nd Ave all | 1st  Ave all | Walnut
Old CouplandRd | 95 | end
[NAME] | Velma | Pin Tail
[NAME]. | [NAME]
Spreadsheet: 96099d1295548539-multiple-formulas-in-one-cell-book1
Sheet: Sheet1

 | JULY 2010- JUNE 2011
 | Name:
 | D.O.H:      July 23, 1990
 | Length of Service: 20 Yrs
 | Accrual 1-14 years: 13.36
 | Accrual 15 Years and over: 16.67
 | [NAME] accrual date: 7/23/2005
 | Current Max Vacation: 400.08
 | [NAME] at 15 years: 400.08
 | [NAME]: 1040
 | June 2010 Ending Balance |  |  |  | 400 |  |  | June 2010 Ending Balance |  |  |  | 1040
 |  |  | VACATION |  | [NAME]: 400.08 |  |  |  |  | SICK |  | [NAME]: 1040
 | MONTH | EARNED HOURS | HOURS USED | DATES USED | BALANCE |  |  | MONTH | EARNED HOURS | HOURS USED | DATES USED | BALANCE
 | July | 16.67 | 24 | 7/2(8), 7/8(2), 7/9(4),7/12(4), 7/16(8), 7/19(8) | 376.08 |  |  | July | 14 | 64 | FMLA              7/21 - 7/23; 7/26 - 7/30
 | August | 16.67 | 0 |  |  |  |  | August | 14 | 108 | FMLA 8/2-8/6; 8/9-8/13; 8/16 - 8/20; 8/23-8/27; 8/30-31
 | September | 7.25 | 0 |  |  |  |  | September | 14 | 92 | FMLA 9/1-9/3; 9/6-9/10; 9/13-9/17; 9/20-9/24; 9/27-9/30
 | October | 0 | 0 |  |  |  |  | October | 14 | 88 | FMLA 10/1; 10/4-10/8; 10/11-10/15; 10/18-10/22; 10/25-10/29
 | November | 0 | 0 |  |  |  |  | November | 14 | 100 | FMLA 11/1-11/5; 11/8-11/12; 11/15-11/19; 11/22-11/26;11/29-11/30
 | December | 5 | 5 | 12/13 (2), 12/17(3) |  |  |  | December | 14 | 32 | FMLA 12/6-12/9 - PT 12/22 (2), 12/25(2)
 | January | 11 | 11 | 1/10(8),1/14(3) |  |  |  | January | 14 | 2 | 1/3(2)
 | February |  |  |  |  |  |  | February
 | March |  |  |  |  |  |  | March
 | April |  |  |  |  |  |  | April
 | May |  |  |  |  |  |  | May
 | June |  |  |  |  |  |  | June
Spreadsheet: 859595d1707925011-formula-on-color-coding-color-coding-v1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | RED | ORANGE | YELLOW | GREEN | BLUE | INDIGO | VIOLET
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 0 | 1 | 0 | 1
65 |  | Red | Orange | Green | Indigo | Orange | Indigo | Blue
66 |  | Blue | Green | Orange | Orange | Indigo | Blue | Indigo
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
Spreadsheet: 36242d1234092885-charting-non-contiguous-data-ranges-diabetes-log
Sheet: Trends

 |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4
Lables | Bins | Frequency | Percentage | Frequency | Percentage | Frequency | Percentage | Frequency | Percentage
< 60 | 60
60 - 100 | 100
100 - 140 | 140
140 - 180 | 180
180 - 220 | 220
220 - 300 | 300
300 +
Samples
 |  | Month 1 |  | Month 2 |  | Month 3
Lables | Bins | Frequency | Percentage | Frequency | Percentage | Frequency | Percentage
< 60 | 60
60 - 100 | 100
100 - 140 | 140
140 - 180 | 180
180 - 220 | 220
220 - 300 | 300
300 +
Samples
Spreadsheet: 704192d1605423919-vlookup-and-if-statement-combination-for-a-date-test-formulas
Sheet: Sheet1

 | POST | NAME | PHONE NUMBER | TRIP # | GOV | CERT
 | G - 2
 | G - 2A
 | G - 4
 | G - 4A
 | G - 6
 | G - 6A
 | G - 6B
Spreadsheet: 748537d1632206707-check-if-time-range-is-within-another-time-range-example2
Sheet: Sheet1

Test | Name | 08:00-16:00
Different | Name | 08:00-16:00
Test | Name | HOL |  |  |  |  | {=IF(ISNUMBER(SEARCH("*Test*";$A$2));IF(IFERROR(VALUE(RIGHT(C$2;5))>VALUE(LEFT(C$2;5)););IF(IFERROR(AND(VALUE(LEFT(C$2;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$2;5))>=VALUE(RIGHT($B13;5))););1;0);IF(IFERROR(AND(VALUE(LEFT(C$2;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$2;5))+"24:00:00">=VALUE(RIGHT($B13;5))););1;0)))
Test | Name | 16:00-24:00 |  |  |  |  | {+IF(ISNUMBER(SEARCH("*Test*";$A$3));IF(IFERROR(VALUE(RIGHT(C$3;5))>VALUE(LEFT(C$3;5)););IF(IFERROR(AND(VALUE(LEFT(C$3;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$3;5))>=VALUE(RIGHT($B13;5))););1;0);IF(IFERROR(AND(VALUE(LEFT(C$3;5))<=VALUE(LEFT($B13;5));VALUE(RIGHT(C$3;5))+"24:00:00">=VALUE(RIGHT($B13;5))););1;0)))
Test | Name | HOL
Test | Name | 08:00-16:00 |  |  |  |  | As you can see the only thing that changed is, column A row number and columns C row number
Test | Name | 08:00-16:00
Test | Name | 08:00-16:00
Test | Name | 08:00-16:00 |  |  |  | Problem | I have to do + untill I reach this 10th row which makes my formula too long if more rows will be added in the future
 |  |  |  |  |  | Question | How to shorten the formula, so I can for example check 50+ rows in the future
 | 08:00-09:00
 | 09:00-10:00
 | 10:00-11:00
 | 11:00-12:00
 | 12:00-13:00
 | 13:00-14:00
 | 14:00-15:00
 | 15:00-16:00
 | 16:00-17:00
 | 17:00-18:00
 | 18:00-19:00
 | 19:00-20:00
 | 20:00-21:00
 | 21:00-22:00
 | 22:00-23:00
 | 23:00-24:00