tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103382d1301106401-help-with-index-match-and-offset-forumla-copy-of-pipeline-report
Sheet: Report

 | Pipeline Report
 |  |  |  |  |  |  |  | Notes: | The same company can be in different parts of the pipeline (statuses).
 |  |  |  |  |  |  |  |  | If a company is in two different parts of the pipeline (e.g. in Active & Prospect), it will have different information for the clients and target tab.
 | *(Data on Seperate Tab) |  |  |  |  |  |  |  | My main problem is getting the client (target) tab generated from the data in the separate tab.
 |  |  | Work so Far |  |  |  |  |  |  |  | What it should look like
(hide) | (hide) | (hide)
Criteria | Criteria | Row | Status | Sector | Sub-Sector | Company | Client (Target) |  |  |  | Status | Sector | Sub-Sector | Company | Client (Target)
 |  |  | Active |  |  |  |  |  |  |  | Active
 |  |  |  | Sector 1 |  |  |  |  |  |  |  | Sector 1
 |  |  |  |  | Sub-Sector A |  |  |  |  |  |  |  | Sub-Sector A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company A | Bob(15)+Sue(12)+David(5)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company F | David+John(75)
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company C | Mary(55)
 |  |  |  |  |  |  |  |  |  |  |  | Sector 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company B | Bob+Sue+David+John(6)+Mary(3)
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company D | Sue(87)+John(655)+Mary(45)
 |  |  |  |  |  |  |  |  |  |  | Prospect
 |  |  |  |  |  |  |  |  |  |  |  | Sector 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company A | John(8)+Mary
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company F | Mary(45)+Bob(33)+Sue(1)
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company C | [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company E | Mary+David(155)+John(65)+Sue(23)+Bob
 |  |  |  |  |  |  |  |  |  |  |  | Sector 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company D | Bob+David(12)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company G | Sue+John(14)
 |  |  |  |  |  |  |  |  |  |  | Closed
 |  |  |  |  |  |  |  |  |  |  |  | Sector 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company C | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Sector 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company G | Mary(18)+Bob(98)+David(62)
Spreadsheet: 1d36766e-61ec-4d09-8637-6dd0cf3416b9
Sheet: Sheet1

introns | genes | introns X genes
0 | 15 | 0
1 | 65 | 65
2 | 82 | 164
3 | 75 | 225
4 | 55 | 220
5 | 43 | 215
6 | 13 | 78
7 | 15 | 105
8 | 5 | 40
9 | 3 | 27
10 | 2 | 20
11 | 0 | 0
12 | 2 | 24
13 | 0 | 0
14 | 0 | 0
15 | 0 | 0
16 | 0 | 0
17 | 0 | 0
18 | 0 | 0
19 | 0 | 0
20 | 0 | 0
21 | 0 | 0
22 | 0 | 0
23 | 0 | 0
24 | 1 | 24
 | 376 | 1207
Spreadsheet: 544839d1509048813-changing-color-of-line-chart-with-source-data-chart-samples
Sheet: Dynamic Chart More Series

All | month 1 | month 2 | month 3 |  |  |  |  | Named Ranges | [NAME]
k | 6 | 7 | 3 |  |  |  |  | Series K
1 | 4 | 2 | 8 |  |  |  |  | Series 1 |  |  | Series 3
2 | 7 | 3 | 7 |  |  |  |  | Series 2 |  |  | Not used when [NAME] is set to a specific value
3 | 9 | 6 | 8 |  |  |  |  | Series 3 |  |  | and Month is set to all
 |  |  |  |  |  |  |  | Series [NAME]
 |  |  |  |  |  |  |  | Series Label 1 |  |  | Legend works because [NAME] is hidden
 |  |  |  |  |  |  |  | Series Label 2
 |  |  |  |  |  |  |  | Series Label 3
 |  |  |  |  |  |  |  | [NAME]
Grade | All | Month | All
Spreadsheet: 176885d1346134885-facing-issue-in-copy-paste-of-excel-data-from-o-column-to-filtered-cells-of-another-column-copy-of-new_task
Sheet: Sheet1

Contig ID | Sequence
Contig 1
Contig 1
Contig 1
Contig 1
Contig 1
Contig 2
Contig 2
Contig 2
Contig 2
Contig 4
Contig 4
Contig 4
Contig 4
Contig 4
Contig 4
Contig 4
Contig 4
Contig 5
Contig 5
Contig 5
 |  |  | Contig | Sequence
 |  |  | Contig 1 | ACtgcTCGGA
 |  |  | Contig 2 | CgatataAAgac
 |  |  | Contig 4 | ACCATAGGAaaa
 |  |  | Contig 5 | TCcTGggAC
Spreadsheet: 161078d1339407015-making-cells-disappear-on-click-and-copying-contents-between-cells-samplediary
Sheet: New Diary

 | 2012-06-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | drop down menu's will be employee names
MON |  |  | CBT? |  | CBT? | Y | CBT? | y | CBT? | Y | CBT? | Y
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  | Vehicle 1
9-11:00am |  |  | Start time: |  | Start time: |  | Start time: |  | Start time: |  | Start time: |  |  |  | Vehicle 2
 |  |  | Bike | customer | Bike | customer | Bike | customer | Bike | customer | Bike | customer |  |  | Vehicle 3
 |  |  |  | paid? |  | paid? |  | paid? |  | paid? |  | paid? |  |  | Vehicle 4
 |  |  | Bike | customer | Bike | customer | Bike | customer | Bike | customer | Bike | customer |  |  | Vehicle 5
 |  |  |  | paid? |  | paid? |  | paid? |  | paid? |  | paid? |  |  | Vehicle 6
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  | Vehicle 7
11-13:00pm |  |  | Start time: |  | Start time: |  | Start time: |  | Start time: |  | Start time:
 |  |  | Bike | customer | Bike | customer | Bike | customer | Bike | customer | Bike | customer
 |  |  |  | paid? |  | paid? |  | paid? |  | paid? |  | paid?
 |  |  | Bike | customer | Bike | customer | Bike | customer | Bike | customer | BIke | customer |  |  |  | I want each day to look like this
 |  |  |  | paid? |  | paid? |  | paid? |  | paid? |  | paid? |  |  |  | in the Diary Plan worksheet I want
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  |  | there is some extra information that
14-16:00pm |  |  | Start time: |  | Start time: |  | Start time: |  | Start time: |  | Start time: |  |  |  |  | will be entered to the end of each day
 |  |  | Bike | customer | Bike | customer | Bike | customer | Bike | customer | Bike | customer
 |  |  |  | paid? |  | paid? |  | paid? |  | paid? |  | paid?
 |  |  | Bike | customer | Bike | customer | Bike | customer | BIke | customer | Bike | customer
 |  |  |  | paid? |  | paid? |  | paid? |  | paid? |  | paid?
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
18-20:00pm |  |  | Start time: |  | Start time: |  | Start time: |  | Start time: |  | Start time:
 |  |  | Bike | customer | Bike | customer | Bike | customer | Bike | customer | Bike | customer
 |  |  |  | paid? |  | paid? |  | paid? |  | paid? |  | paid?
 |  |  | Bike | customer | Bike | customer | Bike | customer | Bike | customer | Bike | customer
 |  |  |  | paid? |  | paid? |  | paid? |  | paid? |  | paid?
Spreadsheet: 215ff58c-d418-47fb-9fb9-d8dfe29d94dc
Sheet: Sheet1

Table 7--U.S. textile exports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Feb. | Mar. | Apr. |  | Apr.
Item | 2013 | 2013 | 2013 |  | 2012
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 232167 | 244937.66 | 244686.047 |  | 215806.119
Cotton | 125091 | 130801.615 | 125705.037 |  | 101185.214
Linen | 6454 | 7018.848 | 6790.453 |  | 7187.924
Wool | 2238 | 2463.349 | 2870.298 |  | 3090.662
Silk | 936 | 1270.316 | 1054.95 |  | 959.582
Manmade | 97447 | 103383.532 | 108265.309 |  | 103382.737
Apparel: | 25407 | 27042.419 | 26462.174 |  | 22205.352
Cotton | 10969 | 11873.331 | 11643.623 |  | 9980.317
Linen | 426 | 435.435 | 456.675 |  | 414.623
Wool | 1402 | 1561.117 | 1488.855 |  | 1132.27
Silk | 1347 | 1251.246 | 1320.734 |  | 952.011
Manmade | 11263 | 11921.29 | 11552.287 |  | 9726.131
Home furnishings: | 3755 | 4506.409 | 4528.871 |  | 4337.736000000001
Cotton | 1746 | 2257.492 | 2253.592 |  | 2131.295
Linen | 185 | 182.631 | 226.332 |  | 187.281
Wool | 149 | 121.151 | 101.616 |  | 90.436
Silk | 114 | 100.2 | 123.266 |  | 103.054
Manmade | 1560 | 1844.935 | 1824.065 |  | 1825.67
Floor coverings: | 29336 | 31534.765 | 31854.42 |  | 28044.203
Cotton | 1959 | 2329.308 | 2291.035 |  | 1778.046
Linen | 897 | 1205.378 | 1171.204 |  | 873.512
Wool | 2715 | 3068.364 | 2983.614 |  | 3343.977
Silk | 47 | 35.219 | 28.513 |  | 39.215
Manmade | 23718 | 24896.496 | 25380.054 |  | 22009.453
Total exports: 2/ | 290767 | 308152.341 | 307619.383 |  | 270526.588
Cotton | 139842 | 147336.096 | 141959.172 |  | 115171.764
Linen | 7963 | 8842.291 | 8644.664 |  | 8663.339
Wool | 6508 | 7219.131 | 7447.393 |  | 7661.714
Silk | 2443 | 2656.981 | 2527.463 |  | 2053.862
Manmade | 134011 | 142097.842 | 147040.691 |  | 136975.909
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 06/14/13.
Spreadsheet: 208767d1358920830-sort-data-with-conditions-on-another-worksheet-selected_1
Sheet: Sheet1

 | CATEGORY 1 | CATEGORY 2 | CATEGORY 3 | CATEGORY 4 | CATEGORY 5 | CATEGORY 6 | CATEGORY 7 |  | CATEGORY 1 | Check
[NAME] | SELECTED |  |  | SELECTED |  |  | SELECTED |  | CATEGORY 5 | SELECTED
MIKE |  |  | SELECTED
ALEX |  |  |  |  |  |  |  |  |  |  |  |  | CATEGORY 1 | SELECTED
ROBIN | SELECTED |  |  |  |  |  |  |  | Name |  |  |  | CATEGORY 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | CATEGORY 3
[NAME] |  |  |  |  | SELECTED |  |  |  |  |  |  |  | CATEGORY 4
 |  |  |  |  |  |  |  |  |  |  |  |  | CATEGORY 5
 |  |  |  |  |  |  |  |  |  |  |  |  | CATEGORY 6
 |  |  |  |  |  |  |  |  |  |  |  |  | CATEGORY 7
Spreadsheet: 851000d1701273406-creating-a-grid-of-combined-values-combined-ages-grid
Sheet: People

Name | Age |  | Name | Age
[NAME] | 43 |  | Rita | 13
[NAME] | 54 |  | Serena | 7
[NAME] | 23 |  | [NAME] | 65
[NAME] | 22 |  | [NAME] | 43
Grant | 11 |  | [NAME] | 21
[NAME] | 75 |  | Marge | 87
[NAME] | 66 |  | Fran | 56
[NAME] | 43 |  | [NAME] | 21
[NAME] | 19 |  | Veronica | 34
[NAME] | 76 |  | Kathy | 11
[NAME] | 23 |  | Rebecca | 54
Walter | 12 |  | [NAME] | 65
[NAME] | 11 |  | Amanda | 12
Pablo | 78 |  | [NAME] | 76
Spreadsheet: 694594d1599710160-formula-help-multiple-values-formula
Sheet: Sheet1

 |  | 2.5 |  | IF C2 IS BETWEEN 2 AND 2.4 C3 NEEDS TO DISPLAY 20
#7 Bo_Ry
#6 bebo021999
#2 wk9128
 |  | Upper Limit | Incident Stat Scale
 |  | 5 | 2.5 |  | 0
 |  | 2.5 | 2 | 2.4 | 20
 |  | 2 | 1.5 | 1.9 | 40
 |  | 1.5 | 1 | 1.4 | 60
 |  | 1 | 0.5 | 0.9 | 80
 |  | 0.5 | 0 | 0.4 | 100
 | When C2 key in 0.5
 | When C2 key in 0.9
 | When C2 key in 1.4
 | When C2 key in 2.5
Spreadsheet: 791392d1660320300-vlookup-across-multiple-sheets-and-add-results-sample-finance
Sheet: Jul

Monthly Financial Report
Deposits | Source |  | Expense | Vendor |  | Allocated Funds | Reason |  | Previous Month Bal | Current Bal | Allocated Bal | Available Bal |  | Deposits
5000 | Income |  | 199 | Fuel |  |  |  |  |  |  |  |  |  | Payments
 |  |  | 300 | Cell |  |  |  |  |  |  |  |  |  | Previous Allocated
 |  |  | 225 | Cable |  |  |  |  |  |  |  |  |  | Newly Allocated
Spreadsheet: darrell_schoolcraft__7575__SUNFLOWER - NNG - HOURLY - 2002
Sheet: 9

WEEKENDS & AFTER 17:00 -
EMERGENCY CONTACTS: |  |  | [NAME] (PAGER)
 | S2 | [NAME] | S5 | HOLCOLM | S2 | [NAME] | S5 | S2, S4 & S5 | TOTAL
HOUR | MWH | MWH | MWH | MMBTU | MMBTU | MMBTU | MMBTU | MMBTU SUBTOTAL | MMBTU
09:00:00 |  | 0 | 0 | 6.75 | 325.1183
10:00:00 |  | 0 | 0 | 6.75 | 325.1183
11:00:00 |  | 0 | 0 | 6.75 | 325.1183
12:00:00 |  | 0 | 0 | 6.75 | 325.1183
13:00:00 |  | 0 | 0 | 6.75 | 278.7818524041217
14:00:00 |  | 0 | 0 | 6.75 | 298.1840238059713
15:00:00 |  | 0 | 0 | 6.75 | 317.5396681536001
16:00:00 |  | 0 | 0 | 6.75 | 325.1183
17:00:00 |  | 0 | 0 | 6.75 | 325.1183
18:00:00 |  | 0 | 0 | 6.75 | 325.1183
19:00:00 |  | 0 | 0 | 6.75 | 325.1183
20:00:00 |  | 0 | 0 | 6.75 | 325.1183
21:00:00 |  | 0 | 0 | 6.75 | 325.1183
22:00:00 |  | 0 | 0 | 6.75 | 278.7818524041217
23:00:00 |  | 0 | 0 | 6.75 | 171.0568181943001
1900-01-01 00:00:00 |  | 0 | 0 | 6.75 | 131.3727352819895
1900-01-01 01:00:00 |  | 0 | 0 | 6.75 | 91.36451240375277
1900-01-01 02:00:00 |  | 0 | 0 | 6.75 | 81.3080037920256
1900-01-01 03:00:00 |  | 0 | 0 | 6.75 | 91.36451240375277
1900-01-01 04:00:00 |  | 0 | 0 | 6.75 | 81.3080037920256
1900-01-01 05:00:00 |  | 0 | 0 | 6.75 | 131.3727352819895
1900-01-01 06:00:00 |  | 0 | 0 | 6.75 | 200.6267011080192
1900-01-01 07:00:00 |  | 0 | 0 | 6.75 | 210.4492391992825
1900-01-01 08:00:00 |  | 0 | 0 | 6.75 | 259.3290941907262
DAILY
TOTAL
Spreadsheet: 861334d1709221667-search-within-a-range-of-matched-ids-and-find-a-matched-pair-of-numbers-matchnotmatch
Sheet: Planilha1

Amount | ID | Comments
-10 | 1199802
30.71 | 1199802
99.93 | 1199802
99.93 | 1199802
99.93 | 1199802
47.95 | 1199802
10 | 1199802
68.3 | 1199802
33 | 1199802
59.97 | 27389985
98.48 | 27389985
-10 | 8789625
10 | 8789625
5 | 8789625
7 | 8789625
5 | 8789625
1 | 8789625
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: GEOG

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD  DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | [NAME] | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL | 1
 | PERCENTAGE
 | COURSE
1 | GEOG 110 | 1 | X | 1 | X | 1 | 3 | 1 | 3 | 1
1 | GEOG 110H | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
4 | GEOG 111 | 1 | X | 1
5 | GEOG 114 | 1
4 | GEOG 119X4 | 1
5 | GEOG 120 | 1
5 | GEOG 126 | 1
5 | GEOG 175 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 229244d1366340462-copying-worksheets-issue-1234-my-house
Sheet: DC Fee Detail

 |  |  |  |  |  |  |  |  | Project Number
 | Exchange Rate |  |  | Currency Used: | MOP |  |  |  | Proposal Date:
 | 8.034 | USD to MOP
 | 7.7756 | USD to HKD |  | CN | SD | DD | CD | Submission | CA
 | 1.03 | HKD to MOP |  | Concept Design | Schematic Design | Design Development | Construction Documentation |  | Tender and Contract Adminstration
 |  |  | Phase Duration | 1 | 1 | 1 | 1 | N/A | 1
 | ID - Interior Consultant Team |  | Firm Name |  |  |  |  |  |  | TOTAL
 | Interior Design
 | FFE Specification
 | Lighting Design
 | Renderings
 | On Site Supervision (ID RSS)
 | Other:
 | Other:
 | Macau Tax Estimate |  | 0.12
 |  | Subtotal by Phase
 |  |  |  |  |  |  |  | Interior Design Fee Total
 | LC - Lead Consultant Team |  | Firm Name
 | Architecture |  | AED
 | Interior Design Production |  | AID
 | Structural Design |  | ARUPS
 | MEP Design |  | PBA
 | ELV Engineering
 | Fire Services Design
 | Fire Safety Engineering |  | ARUPF
 | Lighting Design
 | Acoustic Consultant
 | Traffic Design
 | Audio / Visual Consultant
 | [NAME]
 | Facade Consultant
 | Landscape
 | Renderings
 | Other:
 | Other:
 |  | Subtotal by Phase
 |  |  |  |  |  |  |  | Lead Consultant Design Fee Total
 | DC - Direct Consultants |  | Firm Name | CN | SD | DD | CD | Submission | CA
 | [NAME] |  |  | 234567 |  |  |  |  |  |  | Currency Converter
 | Signage and Graphics |  |  | 56879 | 56879 | 56879 | 56879 |  |  |  | USD | 100
 | Creative Consultant |  |  |  | 56879 | 56879 | 56879 |  |  |  | USD
 | Cost Planning / Review |  |  |  | 56879 | 56879 | 56879 |  |  |  | MOP
 | Statutory Consultant |  | MPS |  | 56879 | 56879 | 56879 |  |  |  | HKD
 | Other:
 | Other:
 |  | Subtotal by Phase
 |  |  |  |  |  |  |  | Direct Consultant Design Fee Total
 | RSS - Site Survey Team |  | Firm Name
 | RSS Arch / ID (Lead Consultant)
 | RSS Structural
 | RSS MEP
 | 3rd Party Life Safety Checker
 | RSS Fire Safety
 | RSS Statutory Consultant
 | Other:
 | Other:
 |  | Subtotal by Phase
 |  |  |  |  |  |  |  | Resident Site Surveyor Fee Total
Spreadsheet: stacey_white__38771__Constellation as of 11-28-2001
Sheet: Constellation Daily $ Exposure

 |  | 2001-11-28 00:00:00 | 2001-11-28 00:00:00 | 2001-11-29 00:00:00 | 2001-11-29 00:00:00 | 2001-11-30 00:00:00 | 2001-11-30 00:00:00 | 2001-12-01 00:00:00 | 2001-12-01 00:00:00 | 2001-12-02 00:00:00 | 2001-12-02 00:00:00 | 2001-12-03 00:00:00 | 2001-12-03 00:00:00 | 2001-12-04 00:00:00 | 2001-12-04 00:00:00 | 2001-12-05 00:00:00 | 2001-12-05 00:00:00
Portfolio | Counterparty | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Total
EAST | CONSTELLPOWSOU |  |  | 225256.35 | 123508 | 6594.4 | 23020.62 | 31050.94 | 25571.27 | 31050.94 | 25571.27 | 83099 | 25571.27 | 83088.76 | 25571.27 | 83074.83 | 25571.27 | 817600.1
WEST | CONSTELLPOWSOU |  |  | 134128.09 | 21432.53 | 134128.09 | 21432.53 | 140227.87 | 19031.35 | 38062.71 | 19031.35 | 140227.87 | 19031.35 | 140227.87 | 19031.35 | 140227.87 | 19031.35 | 1005252.2
Grand Total: |  |  |  | 359384.43 | 144940.49 | 140722.48 | 44453.15 | 171278.81 | 44602.62 | 69113.64 | 44602.62 | 223326.83 | 44602.62 | 223316.64 | 44602.62 | 223302.7 | 44602.62 | 1822852.3
Spreadsheet: a54f38fa-1194-40ad-ba9a-e3f67637c19f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Wholesale Trade: Sales and Inventories
 |  | 42: Total [NAME], Except Manufacturers' Sales Branches and Offices: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: September 21, 2014 (2:21 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 138830 | 132921 | 150672 | 146927 | 141749 | 150869 | 150768 | 147079 | 152030 | 158307 | 145676 | 151302
1993 | 140824 | 138267 | 159749 | 154677 | 153693 | 158043 | 152798 | 159014 | 158768 | 160576 | 156357 | 155449
1994 | 143826 | 143069 | 171413 | 157193 | 163090 | 168454 | 157254 | 177898 | 172066 | 176341 | 171870 | 172425
1995 | 165397 | 161211 | 186778 | 170025 | 185818 | 186564 | 172384 | 191076 | 181621 | 193246 | 184672 | 180188
1996 | 178477 | 176150 | 189303 | 189906 | 195454 | 185356 | 193212 | 196149 | 190873 | 209454 | 189016 | 190993
1997 | 186983 | 181571 | 200205 | 198723 | 200357 | 199810 | 200632 | 195457 | 206341 | 215636 | 188397 | 203733
1998 | 187750 | 183337 | 211184 | 204583 | 198874 | 210701 | 204982 | 199128 | 207425 | 212915 | 196656 | 209585
1999 | 184434 | 188602 | 225471 | 212372 | 211738 | 226910 | 215120 | 223078 | 226580 | 226868 | 225903 | 232083
2000 | 208053 | 218632 | 248659 | 222637 | 243460 | 247509 | 226260 | 246918 | 236862 | 248451 | 236370 | 230743
2001 | 229917 | 217231 | 245078 | 229085 | 244303 | 234330 | 228826 | 242911 | 223722 | 243615 | 227250 | 218884
2002 | 220173 | 210596 | 234089 | 237757 | 244150 | 234015 | 241943 | 245497 | 237792 | 255957 | 235200 | 238359
2003 | 235174 | 223885 | 251546 | 246386 | 244130 | 248362 | 252090 | 245444 | 255103 | 270656 | 240271 | 263198
2004 | 242352 | 244228 | 293553 | 277602 | 268938 | 286906 | 272669 | 285219 | 285668 | 286559 | 286381 | 295045
2005 | 266359 | 267299 | 315635 | 295367 | 299864 | 311151 | 289152 | 321789 | 319033 | 320282 | 310566 | 312826
2006 | 298102 | 289656 | 343521 | 311503 | 341292 | 346421 | 319057 | 353369 | 329286 | 342856 | 327941 | 323500
2007 | 319799 | 303872 | 355022 | 342331 | 364874 | 358504 | 345511 | 370222 | 343925 | 384891 | 364601 | 348237
2008 | 359515 | 347020 | 377426 | 389109 | 395499 | 405983 | 403310 | 385984 | 385870 | 382213 | 307241 | 320578
2009 | 286965 | 277083 | 310080 | 304921 | 299644 | 322612 | 315333 | 310779 | 321656 | 329795 | 314202 | 332953
2010 | 301654 | 299905 | 363792 | 352350 | 341324 | 361275 | 345270 | 358057 | 357794 | 363074 | 363972 | 372988
2011 | 349739 | 338834 | 416660 | 390370 | 397129 | 408313 | 378082 | 416103 | 401709 | 400896 | 393484 | 398155
2012 | 381326 | 381712 | 429172 | 413808 | 431230 | 410317 | 398482 | 424494 | 397298 | 436298 | 417595 | 404850
Spreadsheet: 794958d1662438487-returning-data-based-on-furthest-right-cell-greater-than-zero-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Problem
 | 1 | 10 | 10 | 10 | 0 | 10 | 10 | 10 | 0 | 10 | 10 | 10
 | 2 |  |  |  | 0 |  |  |  | 0
 | 3 |  |  |  | 0 |  |  |  | 0
 | 4 |  |  |  | 1 |  |  |  | 0
 | 5 |  |  |  | 2 |  |  |  | 0
 | 6 |  |  |  | 3 |  |  |  | 0
 | 7 |  |  |  | 4 |  |  |  | 0
 | 8 |  |  |  | 5 |  |  |  | 1
 | 9 |  |  |  | 6 |  |  |  | 2
 | 10 |  |  |  | 7 |  |  |  | 3
Spreadsheet: 593397d1539121048-pulling-previous-averages-based-on-combo-box-example-1
Sheet: Sheet2

Data Entered | (All)
Row Labels | Element Average
Element2 | 2.138888888888889
Grand Total | 2.138888888888889
 |  | August, September, October | May thru October
 | November Average | Previous 3 Month | Previous 6 Month | YTD
Element1 | 1 | 2.44 | 2.6 | 2.33
Element2 | 1 | 2.33 | 2.37 | 2.14
Spreadsheet: 867963d1714691066-trying-to-exclude-certain-results-from-location-columns-in-a-transactional-inventory-manufacturing-inventory
Sheet: Inventory

NEXT BIN NO.
BIN NO. | ITEM NO. | ITEM NAME | [NAME] | ASSEMBLY | QUANTITY O.H. | [NAME] | WIP QUANTITY | WIP LOCATION | VENDOR
1 | 1839201 | Example Name | Example Description | 400cm2 |  |  |  |  | [NAME]
2 | E02190 | Example Name 2 | Example Description 2 | Alpha Pilot |  |  |  |  | Electra
3 | E00087 | Example Name 3 | Example Description 3 | 400cm2 |  |  |  |  | Electra
4 | 46189 | Example Name 4 | Example Description 4 | COTS |  |  |  |  | KC Tools
5 | 17 | Example Name 5 | Example Description 5 | Alpha Pilot |  |  |  |  | Test
Spreadsheet: 742603d1627913090-service-scheduler-that-prevents-double-booking-service-scheduler-example
Sheet: Technicians

Technician | Location
Name 1 | TN
Name 2 | WA
Name 3 | VA
Name 4 | VA
Name 5 | AL
Name 6 | CA
Name 7 | GA
Name 8 | VA
Name 9 | VA
Name 10 | TX
3rd Party | NA
Need a Tech | NA
Spreadsheet: cf980001-8356-4142-9998-6904a5460156
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
41005641 | 2014-04-15 20:58:36 | ALLIES | 0 | 5 | 6 | 1284754 | thorgal72 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
41005928 | 2014-04-15 21:12:39 | AXIS | 1 | 6 | 3 | 1284754 | thorgal72 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
Spreadsheet: 56021d1256152294-counting-occurences-of-values-relating-to-date-range-example
Sheet: Sheet1

2009-10-21 00:00:00 |  | current day at time of creating 21/10/2009!
 |  | 2009-10-20 00:00:00 | 2009-10-21 00:00:00 | 2009-10-22 00:00:00
 | Count of Tuba | 8 | 9
 | Less than 30 days |  | ?
 | Between 30-90 days |  | ? |  |  | once the report has been pasted in to the dailt report and the data is complete in this spreadsheet
 | Over 90 days |  | ? |  |  | the current days values are copied and pasted (values) so the formula does not make them go blank (20/10/2009)
 |  |  |  |  |  | the formula in the current day is also present in the next day (22/10/2009)
 | Count of Trumpet | 6 | 6
 | Less than 30 days |  | ?
 | Between 30-90 days |  | ?
 | Over 90 days |  | ?
 | Count of Cornet | 5 | 6
 | Less than 30 days |  | ?
 | Between 30-90 days |  | ?
 | Over 90 days |  | ?
Spreadsheet: daren_farmer__5035__HPLN0405
Sheet: Sheet1

HPLN0405.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - April 5, 2001
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-04-05 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | LS HPL [NAME] |  |  | 25 | 20
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher