tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 44006d1242671823-conditional-removal-of-numerals-from-cell-value-bom_mixed
Sheet: Sheet1

MIKE BEZNER |  |  | jOB # |  | CHARTWELL AVIATION
03-10-09 |  |  |  | 211 | STEARMAN DR.
Number | Description |  | Qty
 | 360048CABLE, 500 MCM, 600V, QPLX |  | 175'
 | 360087TRANSFORMER, 25 KVA DUAL,POLE MT |  | 3
 | 360122POLES, 45', CLASS 2 |  | 2
 | 360124POLES, 50 FOOT, CLASS 2 |  | 4
 | 360126ANCHOR, EXPANDING 12,000 LB |  | 2
 | 360135BOLTS, CARRIAGE 3/8 X 5 |  | 18
360141 | BOLT, DOUBLE ARMING 5/8 X 18 |  | 12
 | 360146BOLTS, MACHINE,5/8 X 12 |  | 18
 | 360147BOLTS, MACHINE, 5/8 X 14 |  | 5
 | 360165*BRACKETS, TRANSFORMER, 3KVA-50K |  | 1
360171 | CLAMPS, GROUND ROD 5/8",36" |  | 1
 | 360186DEADEND CLAMP, ALUMINUM STRAIGHT |  | 12
 | 360188CONNECTOR, CONNECTOR 1/0-3 TO 2-6 |  | 10
 | 360212TWO BOLT CONNECTOR, 2STR - 2/0 STR |  | 3
 | 360217CROSSARM WOOD, 3-3/4 X 4 3/4" |  | 9
 | 360222CROSSARM PINS, STEEL, 5/8 X14 |  | 2
 | 360227CUTOUT, STANDARD, 27KV -1 |  | 3
 | 360229DEADEND GRIP, 3/8 |  | 4
 | 360236GROUND PLATE, POLE BOTTOM |  | 4
 | 3602393/8 GUY GRIPS |  | 4
 | 360240GUY GUARDS, ORANGE |  | 2
 | 360243HOTLINE STIRRUP, 4-1/0 MPS HLS- |  | 3
 | 360249INSULATOR, PIN TYPE 1/28 J NECK |  | 3
360251 | SPOOL INSULATORS, 3",36" |  | 1
 | 360252*SUSPENSION INSULATOR, 6",36" |  | 24
 | 360273LOCKNUTS, TYPE 3/8 |  | 18
 | 360274LOCKNUTS, 5/8 |  | 44
 | 360282NAILS, 8 PENNY GALVANIZED |  | 120
 | 360286PINS, POLE TOP, STEEL, 20",36" |  | 1
360290GUY HOOKS |  |  | 1
 | 360293LAG SCREWS, 1/2 X 4 |  | 50
 | 360313STAPLES, GROUND WIRE* |  | 200
 | 360319CONNECTOR, XFMR TANK GROUND |  | 3
 | 360337TIE WIRE, #4, 25# COILS |  | 40'
 | 360351WASHERS, SQUARE, 2 1/4 X 2 |  | 40
 | 360353WASHERS, SQUARE CURVED 3X3 |  | 19
 | 360355WOOD BRACE, 28",36" |  | 18
 | 360386COPPER, #2 SD STRANDED (BASTR7SD |  | 15
 | 360399GROUND RODS, 5/8 X 8 |  | 1
 | 360545ARMOR RODS, #1/0 ACSR |  | 4
 | 360552BRACKET, XFMR CLAMP |  | 5
 | 360557EQUIPMENT MOUNTS |  | 1
 | 360567GUY STRAIN INSULATOR, 3/4 X 78",36" |  | 2
 | 360569MOULDING**, WOOD GROUND WIRE |  | 20
360571 | POLE FOAM #25 |  | 4
 | 360573WILDLIFE [NAME] |  | 6
360611 | INSULTORS, SUSPENSION TYPE |  | 12
 | 360710CABLE GRIP, SINGLE EYE |  | 1
 | 360719POWER MOLD, BACKPLATE, 4 X 10 |  | 3
 | 360723POWER MOLD, RISER, 4X4 1/2 X10 |  | 3
cHARWELL hANGER
Spreadsheet: 29bc4bd5-680b-4db0-865e-27ea8d83bfbe
Sheet: Sheet1

Region | Categories | Unnamed: 2 | Unnamed: 3 | Number | Criteria | Unnamed: 6 | Unnamed: 7
 | Type | Change with age | Divergence |  | Age-test | Differential-expression test | Pattern test
PFC | Total | - | - | 12447 | - | - | -
PFC | - | Change | - | 6234 | p<0.001 in ≥1 species | - | -
PFC | I | Constant | Constitutive | 2286 | p>0.01 in all species | p<0.001 in ≥1 species pair | p>0. 01 in all species pairs
PFC | II | Change | Constitutive | 2761 | p<0.001 in ≥1 species | p<0.001 in ≥1 species pair | p>0. 01 in all species pairs
PFC | III | Change | Pattern | 1504 | p<0.001 in ≥1 species | p<0.001 in ≥1 species pair | p<0.001 in ≥1 species pair
PFC | - | Constant | No difference | 1348 | p>0.01 in all species | p>0. 001 in all species pairs | p>0. 001 in all species pairs
PFC | - | Change | No difference | 893 | p<0.001 in ≥1 species | p>0. 001 in all species pairs | p>0. 001 in all species pairs
CBC | Total | - | - | 12853 | - | - | -
CBC | - | Change | - | 5526 | p<0.001 in ≥1 species | - | -
CBC | I | Constant | Constitutive | 2704 | p>0.01 in all species | p<0.001 in ≥1 species pair | p>0. 01 in all species pairs
CBC | II | Change | Constitutive | 2753 | p<0.001 in ≥1 species | p<0.001 in ≥1 species pair | p>0. 01 in all species pairs
CBC | III | Change | Pattern | 1073 | p<0.001 in ≥1 species | p<0.001 in ≥1 species pair | p<0.001 in ≥1 species pair
CBC | - | Constant | No difference | 1840 | p>0.01 in all species | p>0. 001 in all species pairs | p>0. 001 in all species pairs
CBC | - | Change | No difference | 717 | p<0.001 in ≥1 species | p>0. 001 in all species pairs | p>0. 001 in all species pairs
Spreadsheet: 64538d1265369386-how-do-i-create-a-bar-chart-counting-y-or-n-book1
Sheet: Sheet1

 | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | [NAME] | y | y | n | n | y | y | n
 | Rich | y | y | n | y | y | y | y
 | [NAME] | y | y | y | n | y | y | y
 | [NAME] | y | n | y | y | y | y | n
Spreadsheet: c2af0742-8dc3-46a1-a2a4-94e4d7f1f8cd
Sheet: Net Revenues by Market

Juniper Networks, Inc.
Preliminary Net Revenues by Market
(in thousands)
(unaudited)
 | Three Months Ended June 30, |  |  |  | Six Months Ended June 30,
 | 2012 |  | 2011 |  | 2012 |  | 2011
Service Provider | 680971 |  | 729340 |  | 1366580 |  | 1471517
Enterprise | 392788 |  | 391204 |  | 739677 |  | 750639
Total
Spreadsheet: 868934d1715643668-calculating-shift-differential-shift-diff
Sheet: Sheet3

Shift Start | Shift End | Rate
19:00:00 | 22:30:00 | 1.5
22:30:00 | 06:30:00 | 1
In | Out | Total Differential
19:00:00 | 00:17:00
02:00:00 | 08:33:00
19:14:00 | 01:35:00
01:35:00 | 02:05:00
02:05:00 | 08:35:00
Spreadsheet: 788999d1658840817-collate-data-from-other-sheets-by-list-selection-example
Sheet: Master

 | Week 49
 |  | Hours Actual | Hours Target | Contract Actual | Contract Target |  |  |  |  |  |  | Outs Training | Outs Other
 | Store
 | Store 1
 | Store 2
 | Store 3
 | Store 4
 | Store 5
 | Store 6
 | Store 7
 | Store 8
 | Store 9
 | Store 10
 | Store 11
 | Store 12
 | Store 13
 | Store 14
 | Store 15
 | Store 16
 | Store 17
 | Area Total
Spreadsheet: 683799d1592946589-reconciliation-xlf-reconciliation
Sheet: Company Names and Alias

List of Unique Names from Company and from Taxes | [NAME] for All Companies
 | BLANK
 | [NAME]
 | PPG
 | AXXON
 | MARVAL
 | HABITAT ECOLOGICO
 | CETROGAR
 | CENTRAL PUERTO
 | NATURA COSMETICOS
 | AEROPUERTOS
 | NATURA COSMETICOS
 | BLANK
 | KAPSCH
 | [NAME] HUGHES
 | [NAME]
 | [NAME] SUPERIORES
 | PEPITO
 | [NAME]
 | ALLIANZ
 | CHEP ARGENTINA
 | AXXON
Spreadsheet: 148044d1333115497-indexing-issues-match
Sheet: Guestroom Takeoff

DRAWING | UNIT | ITEM | [NAME] | KITCHEN - BATH DRAWING | NOTES | QTY | CDI Cost | # Cabinets | FREIGHT EACH
A5-1 |  | [NAME] |  |  | Does not include countertops, appliances, plumbing or electrical.  Installation by others.
A5-1 |  | Vanity Cabinets |  |  | Does not include countertops, appliances, plumbing or electrical.  Installation by others.
A5-1 |  | [NAME] |  |  | Does not include countertops, appliances, plumbing or electrical.  Installation by others.
A5-1 |  | Vanity Cabinets |  |  | Does not include countertops, appliances, plumbing or electrical.  Installation by others.
 |  | `
 |  | S2-H vanites qty should be 24 and the S1-H vanity [NAME] should be  6/A-421. I copy the CDI Cost fron the Kitchette sheet, so the Column H value contaions the row I need for the other items I copy. In other words [NAME] 54 has all the data in need to move for [NAME] for S1-H Vanity, but how do I referred to this row in a function?
 | 6/A-421
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Spreadsheet: 752660d1634888083-conditional-rank-using-dynamic-array-function-conditional-rank_02
Sheet: Sheet7

Batch | Control recipe | Step Text | Rank | Rank with dynamic array function with spill range
14384960 | 395235 | Printing reference sample labels
14384960 | 395235 | Printing reference sample labels |  | 1
14384960 | 395235 | Printing reference sample labels |  | 1
14384960 | 395237 | Taking of reference samples |  | 1
14384960 | 395237 | Taking of reference samples |  | 1
14384960 | 395237 | Taking of reference samples |  | 1
14384960 | 395237 | Taking of reference samples |  | 1
14733213 | 401798 | Logbook |  | 1
14733213 | 401798 | Logbook |  | 1
14733213 | 403402 | Logbook |  | 2
14733213 | 403402 | Logbook |  | 2
14733213 | 403570 | Within requirements |  | 1
14384960 | 400354 | Printing reference sample labels |  | 2
14384960 | 400354 | Printing reference sample labels |  | 2
14384960 | 400938 | Taking of reference samples |  | 2
14384960 | 400938 | Taking of reference samples |  | 2
14384960 | 400938 | Taking of reference samples |  | 2
14384960 | 400938 | Taking of reference samples |  | 2
14384960 | 400940 | Number approved |  | 1
14733213 | 403756 | Logbook |  | 3
14733213 | 403756 | Logbook |  | 3
14733213 | 403756 | Logbook |  | 3
14733213 | 403756 | Logbook |  | 3
14733213 | 404116 | Within requirements |  | 2
14733213 | 404597 | Logbook |  | 4
14733213 | 404597 | Logbook |  | 4
14733213 | 404597 | Logbook |  | 4
14733213 | 404597 | Logbook |  | 4
14733213 | 404979 | Within requirements |  | 3
Spreadsheet: 4db27fe3-c17c-478c-8337-c0ecbb1b52d1
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
 | Time Series Workbook
 | 5676.0 Business Indicators, Australia
 | TABLE 23. INVENTORIES/SALES RATIO, Current prices, Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Inventories to sales ratio ;  Total (State) ;  Accommodation and food services ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531409K | 1999-03-01 00:00:00 | 2012-06-01 00:00:00 | 54 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Electricity, gas, water and waste services ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531308X | 2001-03-01 00:00:00 | 2012-06-01 00:00:00 | 46 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Manufacturing ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531281K | 1984-06-01 00:00:00 | 2012-06-01 00:00:00 | 113 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  [NAME] ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531254C | 2001-03-01 00:00:00 | 2012-06-01 00:00:00 | 46 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Retail trade ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531382W | 1999-03-01 00:00:00 | 2012-06-01 00:00:00 | 54 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Wholesale trade ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531355R | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | Quotient | RATIO | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 49078d1248352741-lookup-list-function-employee_reg
Sheet: Statement

 |  | PTO Schedule
 |  | Employee: |  | Heather
 |  | 2009 Entitlement: |  |  | 20
 |  | PTO Taken/Pending:
 |  | Date |  |  | Days
 |  |  | 2009-02-27 00:00:00 |  | 1
 |  |  | 2009-04-02 00:00:00 |  | 1
 |  |  | 2009-04-03 00:00:00 |  | 0.5
 |  |  | 2009-05-01 00:00:00 |  | 1
 |  |  | 2009-08-04 00:00:00 |  | 1
 |  |  | 2009-08-05 00:00:00 |  | 1
 |  |  | 2009-08-06 00:00:00 |  | 1
 |  |  | 2009-08-07 00:00:00 |  | 1
 |  |  | 2009-08-24 00:00:00 |  | 1
 |  | PTO Taken/Pending |  |  | 8.5
 |  | 2009 Remaining Entitlement: |  |  | 11.5
Spreadsheet: 105158d1302609983-counting-unique-values-with-conditions-copy-of-example
Sheet: Values

Back order Values
 | Value | Number of Customers
Over 6 months
12 - 26 Weeks
8 -12 weeks
0 - 12 Weeks
Total
Spreadsheet: 188356e6-334b-4676-91ce-c191f5d75a1f
Sheet: Sheet1

Table 10--U.S. oilseed meal prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybean | Cottonseed | Sunflowerseed | Peanut | Canola | Linseed
year | meal 2 | meal 3 | meal 4 | meal 5 | meal 6 | meal 7
 | $/Short ton
2001/02 | 167.72 | 136.16 | 87.27 | 112.32 | 143.33 | 121.29
2002/03 | 181.58 | 146.12 | 105 | 128.35 | 144.06 | 122.91
2003/04 | 256.05 | 183.47 | 111.14 | 177.56 | 188.45 | 159.25
2004/05 | 182.9 | 124.04 | 85.5 | 118.34 | 139.75 | 115.55
2005/06 | 174.1658333333333 | 144.2716666666667 | 77.46400000000001 | 106.9781818181818 | 140.5183333333333 | 115.53
2006/07 | 205.44 | 150.36 | 104.88 | 100 | 173.5 | 133.01
2007/08 | 335.94 | 253.81 | 172.81 |  | 251.32 | 228.81
2008/09 | 331.17 | 255.23 | 152.46 |  | 248.82 | 220.89
2009/10 | 311.27 | 220.9 | 151.04 |  | 224.92 | 209.23
2010/11 | 345.52 | 273.84 | 219.72 |  | 263.63 | 240.65
2011/12 | 393.53 | 275.13 | 246.75 |  | 307.59 | 265.68
2012/131 | 455-485 | 370-400 | 295-325 |  | 365-395 | 300-330
2011/12
October | 301.45 | 255.63 | 232.5 |  | 238.7 | 243.75
November | 290.37 | 240.5 | 224 |  | 235.2 | 239
December | 281.65 | 220.63 | 225.63 |  |  | 221.25
January | 310.65 | 213 | 223.5 |  | 253.98 | 209
February | 330.37 | 190 | 191.88 |  | 257.63 | 193.75
March | 365.95 | 225 | 191.88 |  | 277.83 | 216.25
April | 394.29 | 240.63 | 211.25 |  | 313.38 | 256.25
May | 415.17 | 270 | 230.5 |  | 333.69 | 279
June | 422.59 | 294.38 | 226.88 |  | 335.26 | 287.5
July | 515.82 | 350.5 | 300.5 |  | 378.86 | 343
August | 564.69 | 407.5 | 348.13 |  | 388.13 | 358.75
September | 529.37 | 393.75 | 354.38 |  | 370.79 | 340.63
2012/13
October1 | 488.46 | 343 | 287 |  | 354.49 | 334
1 Preliminary.  2 High-protein Decatur, IL.  3 41-percent Memphis.  4 34-percent North Dakota-Minnesota.
5 50-percent Southeast mills.  6 36-percent Pacific Northwest. 7 34-percent Minneapolis.
NA= Not available.
Source: USDA, Agricultural Marketing Service, Monthly Feedstuff Prices.
Last update: | 2012-11-15 11:15:57.810000
Spreadsheet: lisa_gang__22219__EPE_MARCH_2002
Sheet: MARCH(13)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-13 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | FOUR CORNERS | PALO VERDE | PALO VERDE | PALO VERDE |  | PALO VERDE | PALO VERDE
Pacific | Mountain | SALE | SALE | SALE | SALE | SALE |  | PURCHASE | PURCHASE
Standard | Standard | EPMI | EPMI | EPMI | EPMI | EPMI |  | EPMI | MIRANT
Time | Time | 22.25 | 22.25 |  |  |  |  | 121 | 141.5
 |  | CARRY OVER FROM 3/12 | ON GOING DAILY | FOR THE DAY | FOR THE DAY | BOOKOUT WITH AEP |  | BOOKOUT WITH AEP | ONGOING DAILY
 |  | 3/1/02-3/31/02 | 3/1/02-3/31/02 | 3/13/02-3/13/02 | 3/13/02-3/13/02 | 3/13/02-3/13/02 |  | 3/1/02-3/31/02 | 3/1/02-3/31/02
 |  | EPMI TAG#41424 | EPMI TAG#41437 | IPC TAG#P839E00 | WESCO TAG#56615 | BOOKOUT |  | BOOKOUT | EPMI TAG#41438 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL | DIRECT BILL | DIRECT BILL | DIRECT BILL |  | DIRECT BILL | DIRECT BILL
2400 | 0100 | 25 | 0 | 0 | 0 | 0 |  | 0 | 0
0100 | 0200 | 0 | 25 | 50 | 25 | 0 |  | 0 | 0
0200 | 0300 | 0 | 25 | 50 | 25 | 0 |  | 0 | 0
0300 | 0400 | 0 | 25 | 50 | 25 | 0 |  | 0 | 0
0400 | 0500 | 0 | 25 | 50 | 25 | 0 |  | 0 | 0
0500 | 0600 | 0 | 25 | 50 | 25 | 0 |  | 0 | 0
0600 | 0700 | 0 | 25 | 50 | 25 | 0 |  | 0 | 0
0700 | 0800 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
0800 | 0900 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
0900 | 1000 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1000 | 1100 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1100 | 1200 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1200 | 1300 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1300 | 1400 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1400 | 1500 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1500 | 1600 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1600 | 1700 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1700 | 1800 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1800 | 1900 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
1900 | 2000 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
2000 | 2100 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
2100 | 2200 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
2200 | 2300 | 0 | 0 | 0 | 0 | 50 |  | -50 | -25
2300 | 2400 | 0 | 25 | 50 | 25 | 0 |  | 0 | 0
2400 | 0100 | 0 | 25 | 50 | 25 | 0 |  | 0 | 0
 | MST Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  |  |  |  | TOTAL SALES |  |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)4C | EPE(G)PV | EPE(G)PV | EPE |  | EPE | PINWEST(G)PV
 |  | EPMI | EPMI | EPMI | EPMI | AEP |  | AEP | MIRANT
 |  | AZPS(T)FC3/PPD2 | AZPS(T)FC3/PPD2 | AEP | AEP | EPMI |  | EPMI | EPE
 |  | WALC(T)PPD2/COOLIDGE | WALC(T)PPD2/COOLIDGE | WESCO | CALPINE | EPE |  | EPE | EPMI
 |  | CRSP(L)COOLIDGE | CRSP(L)COOLIDGE | IPC | WESCO |  |  |  | EPE
 |  |  |  | ISO(T)PVD/SP15 | ISO(T)PVD/SP15 |  |  |  | EPE(T)PV/WW
 |  |  |  | IPC(L)SP15 | WESCO(L)SP15 |  |  |  | TEP(T)WW/SP3
 |  |  |  |  |  |  |  |  | EPE(T)SP3/LUNA
 |  |  |  |  |  |  |  |  | EPE(L)LUNA
Spreadsheet: 801881d1666452295-how-to-extend-sumproduct-formula-beyond-the-current-range-sumproduct-formula-issue
Sheet: Sheet1

Account | Amount |  |  | Sum of "start with 1 or 2"
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000 |  |  | Sum of "start with 1 or 2" |  | *trying to extend the rage
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
Spreadsheet: 126232d1319577532-vlookup-for-more-refreince-book1
Sheet: Sheet1

 |  |  |  |  |  |  | I want the values of
 |  |  |  |  | VALUE |  |  | AWD | 07:00:00 | C4
 | AWD |  | 07:00:00 | C1 | 3.1
 | AWD |  | 07:00:00 | C2 | 2.6 |  |  | AWD | 07:20:00 | C4
 | AWD |  | 07:00:00 | [NAME] | 2.1
 | AWD |  | 07:00:00 | C4 | 1.6 |  |  | AWD | 07:20:00 | C6
 | AWD |  | 07:00:00 | C5 | 1.1
 | AWD |  | 07:00:00 | C6 | 0.6
 | AWD |  | 07:00:00 | C7 | 0.1
 | SED |  | 07:00:00 | C1 | -0.4
 | SED |  | 07:00:00 | C2 | -0.9
 | SED |  | 07:00:00 | [NAME] | -1.4
 | SED |  | 07:00:00 | C4 | -1.9
 | SED |  | 07:00:00 | C5 | -2.4
 | SED |  | 07:00:00 | C6 | -2.9
 | SED |  | 07:00:00 | C7 | -3.4
 | AWD |  | 07:20:00 | C1 | -3.9
 | AWD |  | 07:20:00 | C2 | -4.4
 | AWD |  | 07:20:00 | [NAME] | -4.9
 | AWD |  | 07:20:00 | C4 | -5.4 |  |  |  | I tried the vlookup , but its wrong :(
 | AWD |  | 07:20:00 | C5 | -5.9 |  |  |  | =VLOOKUP($C$9&B$9&$E9,B6:F26,5,FALSE)
 | AWD |  | 07:20:00 | C6 | -6.4
 | AWD |  | 07:20:00 | C7 | -6.9
Spreadsheet: 232340d1367400975-returning-list-of-products-from-multiple-entries-0-product-list
Sheet: Ark1

 |  |  |  |  |  |  |  | List that shows the products in the order of appearence, no dublicates.
 |  |  |  |  |  |  |  | Summed amount of the product
 |  | product | Amoount |  | Product | Amount
 |  | a | 2
 |  | c | 4
 |  | a | 56
 |  | d | 8
 |  | d | 7
 |  | b | 8
 |  | c | 3
 |  | b | 6
Spreadsheet: 667847d1584528944-automating-supply-orders-frustration03
Sheet: INVENTORY

Item of requisition | Acct Assignment Cat. | Item Category | Material | Short Text | Quantity requested | Unit of Measure | Valuation Price | Total Value | Delivery Date | Material Group | Plant | Storage Location | Purchasing Group | Requisitioner | Req. Tracking Number | Desired Vendor | Fixed vendor | Supplying Plant | Purch. Organization | Purchasing info rec. | MPN material | StatusCode | Purchase order | Purchase Order Date | Outline agreement | Princ.agreement item
 | K | COPY THE CORRECT ROW | 100011111 | HAPPYZINGER,BANDAGE,3X3,100/BOX,11111 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW | 100022222 | SPONGE,GAUZE,PRE,RYN,2X2,4PL,NWVN,200/PK,22222 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW | 100033333 | DRESSING,NONADH,TELFA,3"X4",BOX OF 100,33333 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW | 100044444 | IBUPROFEN,200MG,TABLET,200X2,44444 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 153 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW | 100055555 | HOTDOG,BUNLENGTH,8/BOX,55555 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW | 100066666 | VIRUSTEST,50THINGS,144/BOX,66666 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW | 100077777 | CHAIR,RECLINER,LG,ONE,77777 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW | 100088888 | BOOK,REGULATIONS,ONE,88888 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW | 100099999 | TRIX,CEREAL,17OZBOX,99999 |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | COPY THE CORRECT ROW |  | DUMMY ROW ONLY THE ITEM # THAT CAN NOT BE FOUND WILL BE IN HERE |  | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 471962d1469351271-how-to-import-data-of-a-specific-row-selectable-from-one-sheet-to-another-transposed
Sheet: Sheet1

Serial Number | Name | Age | Height | Weight
1 | Anne | 23 | 167 | 55
2 | [NAME] | 25 | 172 | 65
3 | [NAME] | 31 | 178 | 92
Spreadsheet: 39884d1238142339-find-equal-distance-integers-677328_ndt2009
Sheet: Sheet1

Min | 0.05 |  | Series |  | Min |  | Bands |  | Result
[NAME] | 0.25 |  | Pairs | * | 2a | Minus | d | = | 1-SUM(B1:B2) |  | Apportionment | d | 1d
Bands | 10 |  | 4 |  | 0.1 |  | 9 |  | 0.7 |  | 0.2999999999999999 | 36 | 0.008333333333333331
 |  | d
Band 1 | 0.05
Band 2 | 0.05833333333333333 | 1
Band 3 | 0.06666666666666667 | 2
Band 4 | 0.075 | 3
Band 5 | 0.08333333333333333 | 4
Band 6 | 0.09166666666666666 | 5
Band 7 | 0.09999999999999999 | 6
Band 8 | 0.1083333333333333 | 7
Band 9 | 0.1166666666666667 | 8
Band 10 | 0.25
Band 11
Band 12
Band 13
Band 14
Band 15
 | 1 | 36
Spreadsheet: 860944d1708959540-less-than-or-greater-than-with-time-shift-log-aligw
Sheet: Sheet1

Break | Start 1st shift | Break | Finish 1st shift | Total
01:30:00 | 19:50:00 | 08:30:00 | 02:30:00
00:00:00 | 19:00:00 | 05:50:00 | 00:00:00
 |  |  |  | 1900-01-11 09:45:00
 |  |  |  | 1900-01-11 12:00:00
If total in Column E is less than 11, highlight in bold red.  If greater than 11, highlight bold black |  |  |  | 1900-01-11 10:30:00
 |  |  |  | 1900-01-11 12:00:00
 |  |  |  | 1900-01-11 11:45:00
 |  |  |  | 1900-01-11 12:30:00
Spreadsheet: 119899d1314833416-max-value-within-range-if-specific-text-in-specified-cell-problem-matchit-real-data-example
Sheet: Summary New

 | Van 1 | Van 2 | Van 3 | Van 4 | Van 5 | Van 6 | Van 7 | Van 8 | Van 9 | Van 10
FT
Guardian
Independent
IHT
Irish Inde
Irish Times
Mail
Telegraph
Times
Wall St
USA Today
The i paid
Observer
Total