tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 483015d1475427845-using-excel-to-write-wiring-connection-plan-sorting-wire-connection-gk-v2
Sheet: terminal block

1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  | Terminal block | Terminal connection |  |  |  |  |  |  | Helper
Date | Approved | Checked | Draw |  |  | Cable : H07-red | Cable : H07-red | Cable : H07-black | Cable : H07-black |  |  | X220 |  |  |  | Cable : H07-black | Cable : H07-black | Cable : H07-black | Cable : H07-black
 |  |  |  |  |  | 2.5 | 1.5 | 2.5 | 1.5 | Apparatus | Terminal |  | Terminal number | Apparatus | Terminal | 2.5 | 1.5 | 2.5 | 1.5
 |  |  | Drawn title |  |  |  |  |  |  |  |  |  | 1 | K7 | 11 |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | K11 | 21 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | a5
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | S1 | 1 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | S1 | 2 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 21 | X2 | 53 |  |  |  | X
SOME DATA , same on every page |  |  | DRAWN TITLE |  |  |  |  |  |  |  |  |  | ZZZ14 | X2 | 66 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  | X | K4 | 59 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  | 26 | K7 | 12 |  |  | X
SOME DATA , same on every page |  |  | TERMINALS X220
SOME DATA , same on every page |  |  | DRAWN TITLE
1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  | Terminal block | Terminal connection
Date | Approved | Checked | Draw |  |  | Cable : H07-red | Cable : H07-red | Cable : H07-black | Cable : H07-black |  |  | X300 |  |  |  | Cable : H07-black | Cable : H07-black | Cable : H07-black | Cable : H07-black
 |  |  |  |  |  | 2.5 | 1.5 | 2.5 | 1.5 | Apparatus | Terminal |  | Terminal number | Apparatus | Terminal | 2.5 | 1.5 | 2.5 | 1.5
 |  |  | Drawn title |  |  |  |  |  |  |  |  |  | 1 | X50 | 11 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | X50 | 12 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | X50 | 21 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | X50 | 22 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | X51 | 11 |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | X51 | 12 |  |  | X
SOME DATA , same on every page |  |  | DRAWN TITLE |  |  |  |  |  |  |  |  |  | 67 | X51 | 21 |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 68 | X51 | 22 |  |  | X
SOME DATA , same on every page |  |  | TERMINALS X221
SOME DATA , same on every page |  |  | DRAWN TITLE
1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  | Terminal block | Terminal connection
Date | Approved | Checked | Draw |  |  |  |  |  |  |  |  | X500 |  |  |  | Elka wire red | Elka wire black
 |  |  |  |  |  |  |  |  |  | Apparatus | Terminal |  | Terminal number | Apparatus | Terminal | 2.5 | 1.5
 |  |  | Drawn title |  |  |  |  |  |  |  |  |  | 150 | S102 | 1 | x
 |  |  |  |  |  |  |  |  |  |  |  |  | 151 | S102 | 2 |  | x
SOME DATA , same on every page |  |  | DRAWN TITLE
SOME DATA , same on every page |  |  | TERMINALS X222
SOME DATA , same on every page |  |  | DRAWN TITLE
Spreadsheet: 018cb0d5-833f-42b9-9632-2a2444c2d30d
Sheet: Sheet1

 | Card Type | Annual Fee | Grocery | Restaurant | Gas (Regular) | Gas (Costco) | Travel | Department | Costco
 | Blue Cash Preferred | 75 | 0.06 | 0.01 | 0.03 | 0.01 | 0.01 | 0.03 | 0.01
 | Blue Cash Everyday | 0 | 0.03 | 0.01 | 0.02 | 0.01 | 0.01 | 0.02 | 0.01
 | Costco AMEX | 0 | 0.01 | 0.02 | 0.03 | 0.03 | 0.02 | 0.01 | 0.01
 | Blue Cash Preferred | 75
 | Blue Cash | 0
 | Costco AMEX | 0
 |  | Supermarkets | 0
 |  | Restaurants | 0
 |  | Gas (Regular) | 0
 |  | Gas (Costco) | 0
 |  | Travel | 0
 |  | Department | 0
 |  | Costco | 0
Spreadsheet: 328709d1404036327-index-match-if-function-wonder-why-excel-kept-refer-to-the-wrong-want-formula-error-dgk-4
Sheet: Appendix

ABBREVIATION
 | Shipment mode
 |  |  |  |  | SEA
 |  |  |  |  | AIR
 |  |  |  |  | ROAD
 | Routing Order
 |  |  |  |  | Import
 |  |  |  |  | Export
 | Volume
 |  |  |  |  | FCL
 |  |  |  |  | LCL
 | Shipment Terms
 |  |  |  |  | Door
 |  |  |  |  | O.Port
 |  |  |  |  | D.Port
 |  |  |  |  | CFS
 |  |  |  |  | Ex Work
 |  |  |  |  | Transhipment
 | Type of Bill
 |  |  |  |  | Original
 |  |  |  |  | Telex Release
 | Port Klang Port Charges
 |  |  |  |  | Agency Fee
 |  |  |  |  | Seal
 |  |  |  |  | CRM
 |  |  |  |  | Telex Release
 |  |  |  |  | ARC
 |  |  |  |  | Container Cleaning Fee
 | Sea Custom Clearance
 |  |  |  |  | Forwarding Fee
 |  |  |  |  | Additional Container
 |  |  |  |  | [NAME]
 |  |  |  |  | Additional Set
 |  |  |  |  | SMK
 |  |  |  |  | EFT
 |  |  |  |  | [NAME]
 |  |  |  |  | Container Divertion
 |  |  |  |  | Transhipment
 |  |  |  |  | [NAME]
 |  |  |  |  | Administration Documentations
 |  |  |  |  | Duty Drawback
 |  |  |  |  | Repass
 |  |  |  |  | SSR
 |  |  |  |  | Additional Container
 |  |  |  |  | Breakbulk /Part of
 | Air Custom Clearance
 |  |  |  |  | Forwarding Fee (1st 100kgs)
 |  |  |  |  | Exp. Transportation Fee, <50, Min 45kgs
 |  |  |  |  | Exp. Transportation Fee, 51 - 100kgs
 |  |  |  |  | Exp. Transportation Fee, 101 - 200kgs
 |  |  |  |  | Exp. Transportation Fee, 201 - 500kgs
 |  |  |  |  | Exp. Transportation Fee, 501 - 1000kgs
 |  |  |  |  | Exp. Transportation Fee, 1001kgs
 | Warehouse Charges
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | FAF - CFS
 |  |  |  |  | Storage
 |  |  |  |  | [NAME]
 |  |  |  |  | De/Stuffing Westport
 |  |  |  |  | De/Stuffing Northport
 |  |  |  |  | Empty Positioning W2W
 |  |  |  |  | Empty Positioning W2N
 |  |  |  |  | Empty Positioning N2N
 |  |  |  |  | Empty Positioning N2W
 | Transportation
 |  |  |  |  | Trucking 1 Ton
 |  |  |  |  | Trucking 3 Tons
 |  |  |  |  | Trucking 5/8 Tons
 |  |  |  |  | Trucking 10 Tons
 |  |  |  |  | [NAME] (16Tons)
 |  |  |  |  | [NAME] (20Tons)
 | Currency
 |  |  |  |  | RM
 |  |  |  |  | USD
 |  |  |  |  | EURO
 |  | Flight Routing |  |  | Direct
 |  |  |  |  | Transit
Spreadsheet: 738158d1624878139-ifs-with-nested-vlookup-ifs-vlookup-test
Sheet: Easy Input

 | Postcode |  | [NAME]
 | N |  | 1
 | Number of Arrays |  |  | Array 1 | [NAME] | Array 3 | [NAME] | Array 5
 | Number of Modules |  |  | 14
 | Module Power (Wp) |  |  | 330
 | Total Installed Cap (kWp)
 | Orientation (° from south) |  |  | 50
 | Inclination (° from horizontal) |  |  | 35
 | Irradiance (kk) |  |  | !=IFS(D4="1",VLOOKUP($E$13,'Zone 1 - London'!$B$2:$AL$93,Formulas!$J$2:$J$37,TRUE)), (D4="2",VLOOKUP($E$13,'Zone 2 - Brighton'!$B$2:$AL$93,Formulas!$J$2:$J$37,TRUE))
 | Shading Factor |  |  | 0.96
 | Annual Output
 | Total Annual Output
Spreadsheet: 868727d1715389822-auto-insert-rows-excel_spacing_question-austinholtby2-
Sheet: Sheet1

Row Labels | Description |  |  | Row Labels | Description |  | Row Labels | Description |  | Row Labels | Description |  | Col. F | Col. I | Col. L |  | Row Labels | Description |  | Row Labels | Description |  | Row Labels | Description |  | Row Labels | Description
12300 | EE CI |  |  | 12300 | EE CI |  | 12300 | EE CI |  | 12300 | EE CI
12300 | EE OP AD&D |  |  |  |  |  |  |  |  | 12300 | EE OP AD&D
12300 | EE OP LIFE INS |  |  | 12300 | EE OP LIFE INS |  | 12300 | EE OP LIFE INS |  | 12300 | EE OP LIFE INS
12300 | FAMILY RESPONSILBILTY |  |  | 22000 | United Way |  | 12300 | FAMILY RESPONSILBILTY |  | 12300 | FAMILY RESPONSILBILTY
12300 | GARNISHMENT |  |  | 22200 | Employer WSIB |  | 12300 | [NAME] |  | 12300 | GARNISHMENT
12300 | [NAME] |  |  | 22300 | Employer EHT |  | 12300 | SPOUSE OP LIFE |  | 12300 | [NAME]
12300 | SPOUSE OP AD&D |  |  | 22400 | RRSP EE |  | 22000 | United Way |  | 12300 | SPOUSE OP AD&D
12300 | SPOUSE OP LIFE |  |  | 22400 | RRSP EE VOL |  | 22200 | Employer WSIB |  | 12300 | SPOUSE OP LIFE
22000 | United Way |  |  | 22400 | RRSP ER |  | 22300 | Employer EHT |  | 22000 | United Way
22200 | Employer WSIB |  |  | 22500 | Social Club |  | 22400 | RRSP EE |  | 22200 | Employer WSIB
22300 | Employer EHT |  |  | 22700 | Vacation paid |  | 22400 | RRSP EE VOL |  | 22300 | Employer EHT
22400 | RRSP EE |  |  | 22700 | Vacation pay Accrual |  | 22400 | RRSP ER |  | 22400 | RRSP EE
22400 | RRSP EE VOL |  |  | 23200 | STAT PAY ACCRUAL |  | 22500 | Social Club |  | 22400 | RRSP EE VOL
22400 | RRSP ER |  |  | 23700 | Federal extra income tax |  | 22700 | Vacation paid |  | 22400 | RRSP ER
22500 | Social Club |  |  | 23700 | Federal income tax |  | 22700 | Vacation pay Accrual |  | 22500 | Social Club
22700 | Vacation paid |  |  | 23700 | Ontario income tax |  | 23200 | STAT PAY ACCRUAL |  | 22700 | Vacation paid
22700 | Vacation pay Accrual |  |  | 23800 | Employment insurance |  | 23700 | Federal extra income tax |  | 22700 | Vacation pay Accrual
23200 | STAT PAY ACCRUAL |  |  | 23800 | Employment insurance (ER) |  | 23700 | Federal income tax |  | 23200 | STAT PAY ACCRUAL
 |  |  |  | 23900 | Canada pension plan |  | 23700 | Ontario income tax |  | 23700 | Federal extra income tax
Spreadsheet: 132579d1323829935-formula-to-calculate-single-cell-based-on-many-variables-point-formula
Sheet: Sheet1

Example 1 |  |  |  |  | Cells below show race results
 | Result Cell | Points |  |  | If Selection |  | 1st | 2nd | 3rd | 4th | 5th
 |  | 5 |  |  | 5 |  | 5 | 4 | 8 | 2 | 6
 |  | 2 |  |  | 4 |  |  |  |  |  |  |  | Note DH = Dead Heat
 |  | 1 |  |  | 8 | Dividend | 12 | 3.7 | 10 | 5.2 | 2.35
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] To a Race
 |  |  |  |  |  |  |  |  |  |  |  |  | Result | 1st | 2nd | 3rd | 4th | 5th
 |  | Notes |  |  |  |  |  |  |  |  |  |  | if 1s<$6 | 3 | 2 | 1
 |  | In this example 1st is horse 5 (cell H4) therefore it would get 3 points (Table Cell O10) for coming |  |  |  |  |  |  |  |  |  |  | if 1st>$6 but <$11 | 1
 |  | 1st plus 1 point because it's dividend is >$6 (Table Cell 011) + 1 point because its dividend |  |  |  |  |  |  |  |  |  |  | if st > $11 | 1
 |  | is >$11 (Table Cell O12) which = 5 points allocated in Cell C5 etc. |  |  |  |  |  |  |  |  |  |  | if DH 1st & 2nd | 2.5 | 2.5 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | if 1st>$6 but <$11 | 0.5 | 0.5 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | if 1st > $11 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | if DH 1st, 2nd & 3rd
 |  |  |  |  |  |  |  |  |  |  |  |  | under $6 | 2 | 2 | 2
Example 2 DH 1st & 2nd |  |  |  |  | Cells below show race results |  |  |  |  |  |  |  | $6.01 - $11.00 | 2.33 | 2.33 | 2.33
 | Result Cell | Points |  |  | If selection |  | 1st | 2nd | 3rd | 4th | 5th |  | $11+ | 2.66 | 2.66 | 2.66
 |  | 4 |  |  | 5 |  | 5 | 4 | 8 | 2 | 6 |  | if DH 2nd & 3rd | 0 | 1.5 | 1.5
 |  | 2.5 |  |  | 4 |  |  |  |  |  |  |  | if DH 2nd,3rd & 4th | 0 | 1 | 1 | 1
 |  | 1 |  |  | 8 | Dividend | 12 | 3.7 | 10 | 5.2 | 2.35 |  | if DH 3rd & 4th | 0 | 0 | 0.5 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  | if DH 3rd, 4th & 5th | 0 | 0 | 0.33 | 0.33 | 0.33
 |  | Notes
 |  | In this example it is [NAME] for 1st & 2nd, therefore 1st is horse 5 (cell H20) get 2.5 points
 |  | per (Table Cell O13) + 0.5 pts per (Table Cell O14) + 1 pts per (Table Cell O15) = Total 4pts
 |  | 2nd horse pays <$6 therefore gets 2.5 pts per (Table Cell P13) & 3rd horse 1 pt per (Table Cell Q13)
 |  | …. And so on for the rest of the table
Spreadsheet: 882773d1731239219-help-please-any-idea-for-a-solution-caberetedoc
Sheet: Sheet1

Product | Sales Option | Currency | Wholesale | Retail | Select Product | Select Sales | Select Currency | Wholesale | Retail |  | Product | Sales Option | Currency
One | Agentur | EUR | 100,00 | 200,00 | Two | Agentur | CHF
One | Agentur | USD | 120,00 | 240,00 |  |  |  |  |  |  | Two | Distribution | USD
One | Agentur | CHF | 100,00 | 200,00 |  |  |  |  |  |  |  |  | CHF
One | Distribution | EUR | 80,00 | 200,00
One | Distribution | USD | 90,00 | 240,00
One | Distribution | CHF | 80,00 | 200,00
Two | Agentur | EUR | 170,00 | 300,00
Two | Agentur | USD | 210,00 | 370,00
Two | Agentur | CHF | 170,00 | 300,00
Two | Distribution | EUR | 120,00 | 300,00
Two | Distribution | USD | 150,00 | 370,00
Two | Distribution | CHF | 120,00 | 300,00
Spreadsheet: 862494d1710207261-exclude-holidays-in-total-holiday-sample-1-
Sheet: Feb

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 2017-02-01 00:00:00 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 807253d1669820299-conditional-formatting-that-checks-multiple-cells-sample
Sheet: December 2022

December
 |  |  |  |  | Entry # | Tracking # |  |  |  | Date Received | Date Completed |  |  |  | [NAME]
 |  |  |  |  | 123456 |  |  |  |  |  |  |  |  |  | Entered, Given #
 |  |  |  |  | 123456 | 123456 |  |  |  |  |  |  |  |  | Tracking # Assigned
 |  |  |  |  | 123456 | 123456 |  |  |  | 2022-11-01 00:00:00 |  |  |  |  | Received
 |  |  |  |  | 123456 | 123456 |  |  |  | 2022-11-01 00:00:00 | 14/5/22 |  |  |  | Completed
Spreadsheet: 740443d1626343385-increasing-the-reference-row-in-a-series-of-random-formulas-by-one-demo
Sheet: Preventing

Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 188 | 206 | 231
2021-22 Q2 | 378 | 387 | 502.6
2021-22 Q3 | 568 | 565 | 740
2021-22 Q4 | 568 | 726 | 964
Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 1 | 0 | 0.2
2021-22 Q2 | 1 | 1 | 1
2021-22 Q3 | 1 | 2 | 1.8
2021-22 Q4 | 1 | 3 | 2.6
Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 10 | 7 | 6.6
2021-22 Q2 | 10 | 16 | 11.2
2021-22 Q3 | 10 | 23 | 19.2
2021-22 Q4 | 10 | 35 | 29
Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 155 | 145 | 205
2021-22 Q2 | 312 | 282 | 460.8
2021-22 Q3 | 469 | 351 | 635.4
2021-22 Q4 | 469 | 430 | 801.2
Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 53 | 82 | 84.4
2021-22 Q2 | 106 | 151 | 176
2021-22 Q3 | 159 | 227 | 264.2
2021-22 Q4 | 159 | 297 | 356.4
Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 7 | 9 | 9
2021-22 Q2 | 7 | 15 | 17.2
2021-22 Q3 | 7 | 27 | 25.8
2021-22 Q4 | 7 | 41 | 35
Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 13 | 12 | 12.8
2021-22 Q2 | 13 | 21 | 25
2021-22 Q3 | 13 | 31 | 35.4
2021-22 Q4 | 13 | 33 | 45.6
Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 2606 | 312 | 772
2021-22 Q2 | 2916 | 2017 | 2184
2021-22 Q3 | 2916 | 4524 | 3955
2021-22 Q4 |  | 6833 | 5338
Fin Year | Current Year | Prev Yr | 5 yr Ave
2021-22 Q1 | 230 | 371 | 245.4
2021-22 Q2 | 234 | 653 | 607.8
2021-22 Q3 | 234 | 738 | 804.4
2021-22 Q4 | 234 | 847 | 956.4
Spreadsheet: 41422d1239890136-help-with-formatting-temp
Sheet: Sheet1

33195
Promotion Mats
2009-02-13 00:00:00 | 821017
2009-03-30 00:00:00 | 65320
50999
Inc Actvty - Exceptional Items
2009-02-16 00:00:00 | 64023
2009-03-02 00:00:00 | 64519
2009-03-02 00:00:00 | 64519
2009-03-16 00:00:00 | 164351
71000
Contribution Recharg
2009-03-31 00:00:00 | 65354
72000
Contribution Recharg
2009-03-31 00:00:00 | 65354
[NAME]
1st Level-Com Psyc
2009-02-19 00:00:00 | 64066
2009-03-19 00:00:00 | 64916
[NAME]
1st Level-Other Ps
2009-03-30 00:00:00 | 65320
Spreadsheet: john_griffith__15781__10_19_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 57 | 250 | 350 | 39.7 | 55.6 | 1.71 | 2001-10-19 10:23:00
 | [NAME] | 58 | 650 | 750 | 43.1 | 49.8 | 1.69 | 2001-10-19 10:23:00
 | HU F2 | 59 | 875 | 975 | 43.4 | 48.4 | 1.7 | 2001-10-19 10:23:00
 | HU G2 | 60 | 1050 | 1150 | 42.2 | 46.3 | 1.67 | 2001-10-19 10:23:00
 | [NAME] | 61 | 1150 | 1250 | 40.4 | 43.9 | 1.62 | 2001-10-19 10:23:00
 | [NAME] | 67 | 1350 | 1475 | 39.3 | 42.9 | 1.73 | 2001-10-19 10:23:00
 | [NAME] | 68 | 1400 | 1550 | 36.8 | 40.8 | 1.66 | 2001-10-19 10:23:00
 | [NAME] | 68 | 1475 | 1600 | 35.9 | 39 | 1.6 | 2001-10-19 10:23:00
 | HU N2 | 67 | 1400 | 1600 | 32.7 | 37.4 | 1.48 | 2001-10-19 10:23:00
 | [NAME] |  |  |  | 28.9 | 34.2 | 1.39 | 2001-10-04 14:29:00
 | HU U2 |  |  |  |  |  | 0.05 | 2001-09-06 10:39:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 8d363970-1bda-493f-a1cd-4b01cdb6278d
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
36080513 | 2013-05-24 01:32:46 | AXIS | 1 | 5 | 1 | 800235 | Black Arrow | 7366 | mediterranean | 1942-05-27 | 1942-05-27 | Panzers [NAME] | Panzer contre [NAME]
36080602 | 2013-05-24 01:46:07 | ALLIES | 0 | 3 | 5 | 800235 | Black Arrow | 7366 | mediterranean | 1942-05-27 | 1942-05-27 | Panzers [NAME] | Panzer contre [NAME]
36080739 | 2013-05-24 02:26:12 | AXIS | 1 | 10 | 8 | 452638 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 182324d1348426242-fetch-data-return-multiple-rows-based-on-cell-content-test-15-
Sheet: Raw

TrackingNumber | BusinessPartner | DateDate | OriginationDate | Trane | [NAME] | Amt | UserID | RI
1 | L | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | N | 1 | 1 | PARMCRUX | 12345
2 | M | 2012-01-02 00:00:00 | 2012-01-02 00:00:00 | Y | 2 | 1 | PARLOLS | 12345
3 | L | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 | N | 3 | 1 | PARMCRUX | 12345
4 | M | 2012-01-04 00:00:00 | 2012-01-04 00:00:00 | Y | 4 | 1 | PARLOPEZ | 12345
5 | L | 2012-01-05 00:00:00 | 2012-01-05 00:00:00 | N | 5 | 1 | PARLOPEZ | 12345
TrackingNumber | BusinessPartner | DateDate | OriginationDate | Trane | [NAME] | Amt | UserID | RI
1 | L | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | N | 1 | 1 | PARMCRUX | 12345
3 | L | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 | N | 3 | 1 | PARMCRUX | 12345
4 | M | 2012-01-04 00:00:00 | 2012-01-04 00:00:00 | Y | 4 | 1 | PARLOPEZ | 12345
5 | L | 2012-01-05 00:00:00 | 2012-01-05 00:00:00 | N | 5 | 1 | PARLOPEZ | 12345
Spreadsheet: daren_farmer__5504__HPL-Oct
Sheet: June 00

 |  | Reliant Energy - Entex
 |  | Enron Capital &  Trade/Houston Pipe Line
 |  | MONTHLY NOMINATION SUMMARY
 |  |  | From |  | Month to Date
Gas Flow Day |  | [NAME]. | 2000-10-01 00:00:00 | 1999-09-18 00:00:00
Houston Pipe Line
982000 |  | HPL  Points | 65000
981326 | Industrial Tier 1 & 2 | Enterprise | 5000
981195 | Industrial Tier 1 & 2 | Huntsman East | 4000
981258 | Industrial Tier 1 & 2 | Champions | 2000
981279, 981280, 981293 | Lufkin/Diboll- Temple Inland
980073 | Huntv,Woodls,[NAME]
Total HPL
Midcon |  |  | 70000
Total  Midcon
NGPL Spring City Gate |  |  | 1000
Total  NGPL
PAYBACK |  |  | 0
Total Available
Allocated as Follows:
Residential
012-41991-301 | 91% Domestic | HPL 76 | 910
016-41991-301 | Transactions 2-5,7 | ECT Trans # 1
016-41991-313 | Contract terminated 07/31/00 | NGMS 308 | 0
016-41991-306 | Trans 6- Silsbee |  | 250
016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll | 0
 | Subtotal
016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1
Total Residential
Industrial
012-41991-301 | 9% Industrial | HPL 76 | 90
016-41991-311 | Terminated 12/31/99 | CNG | 0
016-41991-306 | Trans 6 -Tier 1 - Entex | Tier 1 | 21000
016-91000-303 | Trans 6 -Tier 1 - Unit | Tier 1
016-41991-306 | Trans 6 -Tier 2 - Entex | [NAME] | 7000
016-91000-303 | Trans 6 - Tier 2  - Unit | [NAME] | 500
016-41991-306 | VA Hospital - Terminated 07/31/00 | VA Hosp | 0
Total Industrial at meter 2000
016-91000-301 | existing | NSS/Vidor | 4000
016-41991-306 | [NAME]. | Lufkin Diboll | 8000
016-41991-312 | [NAME]. | Temple Inland | 2800
Total Industrial not at meter 2000
Total Industrial
Huntsville/Woodlands/Conroe
016-41991-301 | Trans 6 -Huntsville |  | 500
016-41991-301 | Trans 9 -Woodlands |  | 2000
016-41991-301 | Trans 8 - Conroe |  | 0
Total H/W/C
Transportation
012-41991-204 |  | IT | 0
012-41991-203 |  | Firm Trsp | 10000
Total Transportation
Total Allocated
Check Available = Allocated
Transport Receipts |  | [NAME]
012-41991-204 | TEJAS THOMPSONVILLE From PanCanadian | 6296 | 10000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 5000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 10000
Spreadsheet: 294175d1391222046-move-data-from-tab-to-different-named-tab-based-on-value-in-k-master-view
Sheet: NVC 

Serial Number | Model | Building | Total [NAME] | Total [NAME] | Room | Campus
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  |  |  |  | NVC
 |  |  | 0 | 0
`
Spreadsheet: 151643d1335035677-how-do-i-link-cells-to-tabs-and-make-a-certain-tal-always-viewable-grade-1-1-
Sheet: input

 |  |  | Player |  |  |  |  | Medical Form |  |  |  |  |  |  |  | Sizes | Shorts |  | Socks |  | Shirt
Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expenses
Round | jumper No | Date | Versus | Team | Result | score | Payment | Trys | Goals | F/Goal | [NAME] | Sent off | B/F  points | Players player | [NAME] | Shirt sox | Doubles | raffle | Other | early Pay
1 |  | 2012-04-01 00:00:00 |  |  | won | 20-12
2 |  | 2012-04-08 00:00:00 |  |  | won | 24-10
3 |  | 2012-04-15 00:00:00 |  |  | won | 48-14
4 |  | 2012-04-22 00:00:00
5 |  | 2012-04-29 00:00:00
6 |  | 2012-05-06 00:00:00
7 |  | 2012-05-13 00:00:00
 |  | 2012-05-20 00:00:00
8 |  | 2012-05-27 00:00:00
9 |  | 2012-06-03 00:00:00
 |  | 2012-06-10 00:00:00
11 |  | 2012-06-17 00:00:00
12 |  | 2012-06-24 00:00:00
13 |  | 2012-07-01 00:00:00
14 |  | 2012-07-08 00:00:00
15 |  | 2012-07-15 00:00:00
16 |  | 2012-07-22 00:00:00
17 |  | 2012-07-29 00:00:00
18 |  | 2012-08-05 00:00:00
19 |  | 2012-08-12 00:00:00
Elimination Final |  | 2012-08-18 00:00:00
Qualifying Final |  | 2012-08-19 00:00:00
1st Semi Final |  | 2012-08-25 00:00:00
2nd Semi Final |  | 2012-08-26 00:00:00
Preliminary Final |  | 2012-09-02 00:00:00 |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Final |  | 2012-09-09 00:00:00
 |  |  |  | After 12 games
 |  |  | Player Signature:…………………. |  |  |  |  | Date Received……………………….. |  |  |  |  |  |  |  |  | TOTAL PAYMENT  DUE |  |  |  | 0
 |  |  | Cheque No:…………………………. |  |  |  |  | President Signature:…………………
Spreadsheet: 477265d1472211599-backwards-vlookup-ak-forum-example
Sheet: Reports 

 | Title | Location
 | Title 1