tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: SP-1

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-18 00:00:00
 |  |  | Monitoring Well #: | SP-1 |  |  |  | Well Depth: | 12.02 |  | ft |  |  | Screened/Open Interval: | 10 |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 6.5 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 3.07 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 12:15 | x |  | 6.27 | NA | 14.02 | NA | 978 | NA | 0.91 | NA | 18.6 | NA | 60.2 | NA | 250 | 3.57
 | 12:20 | x |  | 6.23 |  | 14.16 |  | 980 |  | 0.34 |  | 21.6 |  | 38.2 |  | 250 | 3.57
 | 12:25 | x |  | 6.24 |  | 14.23 |  | 979 |  | 0.22 |  | 22.4 |  | 24.6 |  | 250 | 3.57
 | 12:30 | x |  | 6.25 |  | 14.23 |  | 978 |  | 0.19 |  | 20.1 |  | 15.3 |  | 250 | 3.57
 | 12:35 | x |  | 6.26 |  | 14.25 |  | 979 |  | 0.17 |  | 13.8 |  | 11.9 |  | 250 | 3.57
 | 12:40 | x |  | 6.27 |  | 14.18 |  | 979 |  | 0.15 |  | 7 |  | 9.25 |  | 250 | 3.57
 | 12:45 | x |  | 6.28 |  | 14.22 |  | 980 |  | 0.14 |  | 4.6 |  | 6.15 |  | 250 | 3.57
 | 12:50 | x |  | 6.28 |  | 14.22 |  | 981 |  | 0.13 |  | 1.9 |  | 6.25 |  | 250 | 3.57
 | 12:55 | x |  | 6.29 |  | 14.25 |  | 981 |  | 0.13 |  | 1.6 |  | 6.04 |  | 250 | 3.57
 | 13:00 |  | x | 6.3 |  | 14.13 |  | 984 |  | 0.12 |  | 1.6 |  | 6.56 |  | 250 | 3.57
 | [NAME]: |  | 12:07:00 |  | Sample notes:
 | [NAME]: |  | 12:55:00
 | Sample Time: |  | 12:57:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 751340d1634053432-duplicate-transaction-reference-duplicated
Sheet: Sheet1

*Transaction Reference | Journal No. | Transaction Reference Duplicated?
AMBSG000800 | 323316 | No
HSBC-SGD-SGA10091BXN34BR4 | 325119 | Yes
HSBC-SGD-SGA10091BXN34BR4 | 325120 | Yes
System - Revaluation | 324327 | Yes
System - Revaluation | 324338 | Yes
System Balancing Transaction | 325120 | No
INV-0005 | 319769 | No
INV-0005- | 321319 | Yes
INV-0005- | 323489 | Yes
48952 | 322576 | No
51814 | 325348 | No
HSBC-SGD-SGA24091GUOFKTHC | 326400 | Yes
HSBC-SGD-SGA24091GUOFKTHC | 326401 | Yes
HSBC-SGD-SGA30081EPM5NGUA | 323820 | Yes
HSBC-SGD-SGA30081EPM5NGUA | 323821 | Yes
System - Revaluation | 324338 | Yes
Spreadsheet: 733001d1621351926-get-nth-match-for-index-match-within-a-specified-set-of-dates-budget-example
Sheet: May

Income Post Tax |  |  |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00
 | Income - Steven | Income - Monica
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Acct #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emergency | 4557
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Travel | 7859
 |  |  | Total In | Total Out |  | In(Out) |  | % to savings
Total
 | Expenses/Outflows |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted for savings
 | May |  |  |  | Date |  | Date |  |  | Date |  |  | Date |  | Date |  |  |  |  |  | Date
 | Spent
nth |  | Rent + Utilities | Student Loan | Insurance (car/renters) | Date | Gas | Date | Groceries | Cell Phones | Date | Entertainment/Eating out | (Explanation) | Date | Tithing | Date | Other/personal | (Explanation) | Savings | (Explanation) | Misc | Date | Unplanned | (Explanation) | Travel | Total Outflows
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
Spreadsheet: 220986d1363343317-generate-part-list-copy-of-partlist-example
Sheet: Blad1

amount | assembly A |  |  |  |  |  |  |  |  | aantal | part
 |  |  |  |  |  |  | assembly A | assembly A |  | 1 | part1
1 | part1 |  |  |  |  |  | assembly B |  |  | 2 | part2
2 | part2 |  |  |  |  |  | assemblyC |  |  | 4 | part3
4 | part3 |  |  |  |  |  | assemblyD |  |  | 4 | part1
2 | subassembly X |  |  |  |  |  |  |  |  | 12 | part4
 |  |  |  |  |  |  |  |  |  | 2 | part5
 | assembly B
3 | part3
8 | part6
1 | part7
1 | subassembly Y
 | assembly C
 | ,,,
 | ,,,
 | ,,,
 | ,,,
 | assembly D
 | ,,,
 | ,,,
 | ,,,
 | ,,,
amount | subassembly X
2 | part1
6 | part4
1 | part5
Spreadsheet: 107089d1304281580-getting-the-variable-name-if-data-has-the-number-1-from-list
Sheet: Sheet1 (2)

ID | *ace | *alpha | *arb | *b | *ccbd | Drugs I'm On | Drugs I'm on(2)
19003 | 1 | 0 | 1 | 0 | 1 | *ace | *arb | *ccbd
19004 | 1 | 0 | 0 | 0 | 1 | *ace | *ccbd
19005 | 1 | 0 | 0 | 0 | 1 | *ace | *ccbd
19006 | 0 | 0 | 0 | 0 | 1 | *ccbd
19007 | 0 | 0 | 1 | 0 | 0 | *arb
19008 | 0 | 0 | 0 | 1 | 0 | *b
19009 | 1 | 0 | 1 | 1 | 0 | *ace | *arb | *b
19010 | 0 | 0 | 0 | 0 | 1 | *ccbd
19011 | 1 | 0 | 0 | 1 | 0 | *ace | *b
19012 | 1 | 0 | 0 | 0 | 1 | *ace | *ccbd
19013 | 0 | 0 | 0 | 1 | 1 | *b | *ccbd
19014 | 1 | 0 | 0 | 1 | 0 | *ace | *b
19015 | 1 | 0 | 0 | 1 | 0 | *ace | *b
19016 | 1 | 0 | 0 | 1 | 0 | *ace | *b
19017 | 1 | 0 | 0 | 1 | 0 | *ace | *b
Spreadsheet: john_forney__15504__200107
Sheet: ST Ercot

ST-ERCOT
 |  | Deal Number | Total
Static Scheduling | Reliant Energy HL&P
 | Texas New Mexico Power
 | [NAME]
 | [NAME]
Unplanned Losses | American Electric Power Services Corp
 | [NAME]
 | [NAME]
 | Bryan Texas Utilities
 | City of Denton Municipal Utilities
 | City of Garland
 | City Public Services
 | Farmer's Electric Cooperative
 | Grayson-Collin Electric Cooperative
 | Greenville Electric Utility System
 | Lower Colorado River Authority
 | Magic Valley Electric Cooperative
 | Public Utilities Board of Brownsville
 | Reliant Energy HL&P
 | Rio Grande Electric Cooperative
 | South Texas Electric Cooperative
 | Southwest Electric Service Company
 | Texas Municipal Power
 | Texas New Mexico Power
 | Tex-La Electric Cooperative
 | TXU Electric Services
password for Totals sheet = ercot
 | Counterparty Name
 | TXU Electric Services
 | Texas New Mexico Power
 | Reliant Energy HL&P
 | City Public Services
 | American Electric Power Services Corp
 | Lower Colorado River Authority
 | American Electric Power Services Corp
 | [NAME]
 | [NAME]
 | Texas Municipal Power
 | South Texas Electric Cooperative
 | South Texas Electric Cooperative
 | Public Utilities Board of Brownsville
 | Southwest Electric Service Company
 | Farmer's Electric Cooperative
 | TXU Electric Services
 | TXU Electric Services
 | Tex-La Electric Cooperative
 | Magic Valley Electric Cooperative
 | South Texas Electric Cooperative
 | TXU Electric Services
 | City of Garland
 | Rio Grande Elerctic Cooperative
 | Grayson-Collin Electric Cooperative
 | Bryan Texas Utilities
 | City of Denton Municipal Utilities
 | Grrenville Electric Utiliy System
Spreadsheet: 155487d1336886851-cell-equals-anything-but-false-book2
Sheet: Sheet1

Neutral | A 1 | A 2 | C 1 | C 2 | Result
0 | 0 | A2 | 0 | 0 |  | Cell F2 = Anything but FALSE between A:E
0 | A1 | 0 | 0 | 0 |  | Cell F2 = Anything but FALSE between A:E
0 | 0 | 0 | C1 | 0 |  | Cell F2 = Anything but FALSE between A:E
0 | 0 | 0 | 0 | C2 |  | Cell F2 = Anything but FALSE between A:E
0 | 0 | A2 | 0 | 0 |  | Cell F2 = Anything but FALSE between A:E
Neutral | 0 | 0 | 0 | 0 |  | Cell F2 = Anything but FALSE between A:E
Spreadsheet: 732189d1620819309-xlookup-multiple-columns-xlookup
Sheet: Sheet1

Date | Description | Reference | Revenue | Expense | Balance |  | Date | Description | Reference | Debit | Credit | Balance |  | Date | Description | Reference | Debit | Credit | Balance
 | 0 | 0 | 0 | 0 | 460
2021-04-06 00:00:00 | CRAIG MAPHOSA | 14267 | 10000 | 0 | 10460 |  | 2021-04-06 00:00:00 | 11345728 | 14267 |  | 10000 |  |  | 2021-04-09 00:00:00 | [NAME] | 7a | 1000 | 0 | -61745
2021-04-07 00:00:00 | Suspense Account | 14268 | 14650 | 0 | 25110 |  | 07/04/2021 | ZIPIT 844923 012FBTC21096A8WH | 14268 |  | 14650 |  |  | 2021-04-08 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 14270 |  | 7375
2021-04-07 00:00:00 | Suspense Account | 14269 | 8500 | 0 | 33610 |  | 07/04/2021 | 11353259 | 14269 |  | 8500 |  |  | 07/04/2021 | ZIPIT 844923 012FBTC21096A8WH | 14268 |  | 14650
2021-04-08 00:00:00 | THANDOLWENKOSI SAYI | 14270 | 0 | 0 | 33610 |  | 2021-04-08 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 14270 |  | 7375 |  |  | 2021-04-06 00:00:00 | 11345728 | 14267 |  | 10000
2021-04-09 00:00:00 | 0 | 7a | 1000 | 0 | 34610 |  | 2021-04-09 00:00:00 | [NAME] | 7a | 1000 | 0 |  |  | 2021-04-13 00:00:00 | Suspense Account | 14271 | 23375 | 0
2021-04-12 00:00:00 | 0 | 8a | 450 | 0 | 35060 |  |  |  |  |  |  |  |  | 07/04/2021 | 11353259 | 14269 |  | 8500
2021-04-13 00:00:00 | Suspense Account | 14271 | 23375 | 0 | 58435 |  | 2021-04-13 00:00:00 | Suspense Account | 14271 | 23375 | 0 | -10200
44302 | 0 | 14272 | 179720 | 0 | 238155
44306 | 0 | 14278 | 8560 | 0 | 246715
44306 | 0 | 14279 | 510 | 0 | 247225
44308 | NESISA MHLANGA | 14273 | 0 | 0 | 247225
44312 | Suspense Account | 14274 | 2097.07 | 0 | 249322.07
44315 | 0 | 33a | 5600 | 0 | 254922.07
44315 | Suspense Account | 14275 | 1000 | 0 | 255922.07
44316 | Suspense Account | 14276 | 11547.5 | 0 | 267469.57
44316 | Suspense Account | 14277 | 5000 | 0 | 272469.57
Spreadsheet: 25695d1217177993-continuation-of-car-ownership-database-2-car-ownership-database
Sheet: 2008

INPUT |  |  |  |  |  |  |  |  |  | CALC (copy down fomula) | INPUT | CALC (copy down fomula)
Car Ownership Database |  |  |  | Today is the:
Forename | Surname | Home Phone No | Mobile No | [NAME] | Car Model | Car Registration | Description of work done | Date work done | Car Milage | Cambelt needs replacing? | Date of last MOT | Is MOT due? | Last row record?
[NAME] | Bloggs | 01428 724657 | [PHONE] | Bentley | 5TX | 1ZY 6NU | New Exhaust | 2005-03-02 00:00:00 | 60000 |  | 2008-07-03 00:00:00
[NAME] | [NAME] | 01224 593922 | [PHONE] | Audi | SX2 | 1ny 7ui | Repaired engine | 2008-06-26 00:00:00 | 60000 |  | 2006-07-02 00:00:00
Martin | Truser | 01428 722456 | [PHONE] | BMW | [NAME] | 7NY 8TT | Tyre replaced | 2008-04-23 00:00:00 | 70000 |  | 2008-01-28 00:00:00
[NAME] | [NAME] | 01304 142019 | [PHONE] | Renault | S3 | 9NQ 7FR | Checkup | 2008-07-24 00:00:00 | 38000 |  | 2008-03-05 00:00:00
[NAME] | Bloggs | 01428 724657 | [PHONE] | Bentley | 5TX | 1ZY 6NU | Cambelt fixed + MOT | 2007-07-25 00:00:00 | 100000 |  | 2007-07-25 00:00:00
Spreadsheet: 713205d1610592961-count-duplicates-in-a-range-ignoring-blanks-count-duplicates-ignoring-blanks
Sheet: Sheet1

Employee ID
TA32785655
SA12442673
AA21259159
CA84636028
OA61505754
LB71531251
TB19548089
SB46327164
PB67349700
EB32531079
SC17296774
FC70634829
AD17153037
CD14845828
JG66805710
CH36848865
CL41033165
LL21590248
RK32756907
EM26000697
MM12168514
HO10339330
RS31728184
SS43010028
TT33991592
CV22833553
[NAME]
JW15786388
BO44794874
TA53245548
JS13672576
TA13291311
Spreadsheet: 857527d1706534703-need-formulas-for-dynamic-list-where-column-locations-are-keep-on-changing-sumproduct-instead-countifs
Sheet: Report

 | Countif | Sumproduct / Automatic formula which can sense the column movement when pasting the datas
Single Countif Criteria |  |  | In Sheet `List' : In Column XXX - Count of DDD
Two [NAME] |  | Need formula which can sense the column movement when pasting the datas in `List' Sheet | In Sheet `List' : Count of Filter Column XXX : DDD, Column Status : for `Payment Received' and `Under Delivery'
Three [NAME] |  | Need formula which can sense the column movement when pasting the datas in `List' Sheet | In Sheet `List' : Count of Filter Column XXX : DDD, Column Status : only for `Under Delivery', and in column X2/Y2 = "Y"
Four [NAME] |  | Need formula which can sense the column movement when pasting the datas in `List' Sheet | In Sheet `List' : Count of Filter Column XXX : DDD, Column Status : for `Payment Received', in column X2/Y2 = "Y", and Column `Times attempted to delivery' have 5
 |  | Hello
 |  | Please refer the attached excel file. I am generating the list periodically and pasting that list to the pre-defined formulas populated file sheet named `Report'.
 |  | Now I am seeing the columns locations are getting changed every time and need to repopulate the countif formula every time.
 |  | Need formulas (in yellow background Sheet `Report' C3:C5) which can be automatically sense the column locations and countif.
 |  | thanks in Advance
 |  | Reference : <https://www.excelforum.com/excel-formulas-and-functions/1418543-changing-column-input-also-need-to-be-dynamic.html#post5913944>
 |  | Thanks to AliGW  helped to solve this for single criteria
 |  | Sekar
Spreadsheet: 79491d1279740218-reverse-lookup-golf-rack-games-gross-net-rounding-question
Sheet: PLAYER ID & INFO

 |  |  |  |  |  | instead of doing a vector lookup formula in row F, is there a formula where I just put the number in row G and it automatically puts that number at the end of the line?
 |  |  |  |  |  | for example if I had put 33 in cell G7 it would then automatically put that in cell R7 and would have left the other numbers in front, (19,28, 24, 24,etc..)
 |  |  |  |  |  | how do I get column D to round?
ID# | NAME: | AGE: | POINTS: |  | LAST PTS | GOT
1 | AUTREY, GENE | 63 |  |  |  |  | 25 | 21 | 22 | 27 | 25 | 21 | 23 | 24 | 28 | 19 | 33
2 | BAKKE, RICK | 60 |  |  |  |  | 22 | 20 | 16 | 21 | 27 | 19 | 20 | 28 | 21 | 28 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
3 | BARNETT, BILL - SR | 71 |  |  |  |  | 5 | 9 | 11 | 11 | 10 | 11 | 9 | 7 | 16 | 11 | 12 | 18
4 | BARNETT, BILLY | 35 |  |  |  |  | 33 | 33 | 32 | 31
5 | BAXTER, BENNY | 72
6 | BEAVERS, [NAME]
7 | BEESON, RANDY
8 | BERGER, CHARLIE | 65
9 | BOUDREAUX, CORY | 28
10 | BOUDREAUX, [NAME] | 48
11 | BUTT. MIKE | 60
12 | CAMEROTTO, MARIO
13 | CZYZ, DAN
14 | DAVIS, GARY
15 | DELISI, TOM
16 | FAULKNER, DAVE
17 | FUELBERG, RON
18 | GILCHREST, WIL
19 | GILMORE, GARRY
20 | GRANT, [NAME]
21 | HANEY, BOBBY
22 | HANEY, ROBBY
23 | HENDERSON, DONNIE
24 | HODGDON, CHUCK
25 | HUDSON, BUD
26 | JONES, ROD
27 | JORDAN, HERMAN
28 | [NAME], JIM
29 | KILGORE, GARY
30 | LANE, JERRY
31 | LANGE, BOBBY
32 | LANGE, JR
34 | [NAME], PETER
35 | McCORMICK, KEN
36 | McKELLAR, SHERYL
37 | McKELLAR, WALTER
38 | [NAME], DAN
39 | MILLER, [NAME]
40 | NEAL, GENE
41 | PAGE, KEITH
42 | PENTECOST, [NAME]
43 | PROCTOR, RON
44 | PROPST, PHILIP
45 | PROPST, SHEEP-DOG
46 | PURCELL, [NAME]
47 | SANCHEZ, JOHN
48 | SCHROEDER, BOOGER
49 | SKARBOVIG, [NAME]
50 | SMITH, DOUG
51 | SMITH, KENNY
52 | SMITH, PAM
53 | SMITH, [NAME]
54 | SMITH, SID
55 | SPURLOCK, JIMMY
56 | SPURLOCK, [NAME]
57 | STRAWBRIDGE, BILL
58 | STRAWBRIDGE, [NAME]
59 | VINCENT, ANDY
60 | VOYTEK, VINCE
61 | WARREN, [NAME]
33 | WHITE, RANDY
62 | WHITE, ROBERT
Spreadsheet: sally_beck__33782__EES Report
Sheet: NAICS Summary

[NAME] | NAICS_DESC | DEAL_VALUE_AMT
31122 Total | Starch and Vegetable Fats and Oils Manufacturing | 1682648.63
311611 Total | Animal (except Poultry) Slaughtering | 174375
321113 Total | Sawmills | 4412643.316000002
32212 Total | Paper Mills | 3126725.3525
322121 Total | Paper (except Newsprint) Mills | 12968541.5859
32213 Total | Paperboard Mills | 45361437.2982
322211 Total | Corrugated and [NAME] | 1183762.6184
32411 Total | Petroleum Refineries | 549636902.3512739
324191 Total | Petroleum Lubricating Oil and Grease Manufacturing | 708256.9260099999
324199 Total | All Other Petroleum and Coal Products Manufacturing | 2037145.9082
3251 Total | Basic Chemical Manufacturing | 37140592.1964
32511 Total | Petrochemical Manufacturing | 10436077.8266
32512 Total | Industrial Gas Manufacturing | 7193785.2148
325131 Total | [NAME] and Pigment Manufacturing | 52791649.92699999
325181 Total | Alkalies and [NAME] | 6052.79
325188 Total | All Other Basic Inorganic Chemical Manufacturing | 3192234.237100002
325193 Total | Ethyl Alcohol Manufacturing | 7650323.060000001
325211 Total | Plastics Material and [NAME] | 147939971.739
325222 Total | Noncellulosic Organic Fiber Manufacturing | 3036342.28
325311 Total | Nitrogenous Fertilizer Manufacturing | 26115161.78
325314 Total | Fertilizer (Mixing Only) Manufacturing | 17313730.02
327124 Total | Clay Refractory Manufacturing | 10927.991342
327212 Total | Other Pressed and [NAME] and Glassware Manufacturing | 20592
32731 Total | Cement Manufacturing | 1463690.5
32742 Total | Gypsum Product Manufacturing | 43953
327993 Total | Mineral Wool Manufacturing | 297570
331111 Total | Iron and Steel Mills | 24297988.1797
331312 Total | Primary Aluminum Production | 34862404.713
331315 Total | [NAME], Plate, and Foil Manufacturing | 552990
331421 Total | Copper Rolling, Drawing, and Extruding | 325000.54
331521 Total | [NAME] | 8795.54
332111 Total | Iron and Steel Forging | 208775.82
333514 Total | Special Die and Tool, Die Set, Jig, and Fixture Manufacturing | 379439.4
336412 Total | Aircraft Engine and Engine Parts Manufacturing | 1757679.9253
61131 Total | Colleges, Universities, and Professional Schools | 318818.587
 | TOTAL
Spreadsheet: 47596d1246649261-golf-handicap-formula-golf-schedule
Sheet: Team schedule

 |  |  | PLAYER SCHEDULE
 | PHONE
 |  |  |  |  |  |  |  | # golfers
1 | 2009-04-08 00:00:00 | 1 |  | 1 |  | 1 | 1
2 |  | 1 | 1 | 1 |  |  | 1 |  | 40
3 |  | 1 | 1 | 1 |  | 1 |  |  | 41
4 |  |  |  | 1 | 1 | 1 | 1
5 |  | 1 | 1 |  | 1 |  | 1 |  | 41
6 |  |  | 1 | 1 | 1 |  | 1 |  | 43
7 |  | 1 | 1 |  |  | 1 | 1 |  | 44
8 |  | 1 | 1 | 1 |  | 1 |  |  | 39
9 |  |  | 1 | 1 | 1 | 1 |  |  | 36
10 |  | 1 | 1 |  | 1 |  | 1 |  | 35
11 |  | 1 |  |  | 1 | 1 | 1
12 |  |  | 1 | 1 | 1 | 1 |  |  | 41
13 |  | 1 | 1 | 1 |  |  | 1 |  | 37
14 |  | 1 |  | 1 |  | 1 | 1
15 |  | 1 |  | 1 |  | 1 | 1
16 |  | 1 | 1 |  | 1 | 1
17 |  |  | 1 | 1 | 1 |  | 1
18 |  | 1 | 1 |  | 1 | 1
19 |  |  |  | 1 | 1 | 1 | 1
20 |  | 1 | 1 | 1 | 1
21 |  |  |  | 1 | 1 | 1 | 1
22 |  |  | 1
 |  |  |  |  |  |  |  |  | *=INT(0,8*(INT(AVERAGE(J6:[NAME]))
Spreadsheet: 101270d1299429941-vba-formula-to-add-selected-numbers-to-reach-a-value-number-matcher
Sheet: Sheet1

0.001 | 200 | Enter target value in B1
0.002 | x1= 200
0.002 | x2=
0.005 | Nearest sum= 200
0.01 | Distance= 0.00000
0.02
0.02
0.05
0.1
0.2
0.2
0.5
1
2
2
5
10
20
20
50
100
200
200
500
1000
2000
2000
5000
10000
20000
Spreadsheet: 871142d1717570571-percent-rank-of-an-array-percentrank
Sheet: Sheet1

 |  | Style Pnts | Surface | Distance | Class |  | PercentRank
 | 1 | 3 | 0.47 | 0 | 0.56
 | 2 | 7 | 0.4 | 0 | 0
 | 3 | 0 | 0.44 | 0.56 | 0.5
 | 4
 | 5 | 3 | 0.5 | 0 | 0.83
 | 6 | 0 | 0.72 | 0.67 | 0.72
 | 7 | 7 | 0.45 | 0.6 | 0.5
Spreadsheet: 802207d1666705044-series-on-different-columns-example-serie
Sheet: Sheet1

ElementA | ElementB | A | B
TeamA | TeamB | 1 | 1 |  |  | Team A Series
TeamA | TeamB | 1 | 1
TeamB | TeamA | 0 | 0
TeamA | TeamB | 1 | 1
TeamA | TeamB | 1 | 1
TeamB | TeamA | 0 | 0
TeamA | TeamB | 1 | 1
TeamB | TeamA | 0 | 0
TeamA | TeamB | 1 | 1
Spreadsheet: 758132d1638690006-dynamic-formula-to-determine-max-values-based-on-year-and-quarter-max-values-by-year-and-quarter_2
Sheet: Sheet2

Date of Sale | Price |  |  |  | Q | 2019 | 2020
2019-01-01 00:00:00 | 994 |  |  |  | 1
2019-01-08 00:00:00 | 777 |  |  |  | 2
2019-02-12 00:00:00 | 358 |  |  |  | 3
2019-03-16 00:00:00 | 974 |  |  |  | 4
2019-03-28 00:00:00 | 561
2019-04-02 00:00:00 | 654
2019-04-11 00:00:00 | 883
2019-06-16 00:00:00 | 214
2019-07-14 00:00:00 | 501
2019-07-23 00:00:00 | 318
2019-08-04 00:00:00 | 892
2019-09-24 00:00:00 | 285
2019-09-27 00:00:00 | 912
2019-09-30 00:00:00 | 218
2019-10-03 00:00:00 | 500
2019-12-29 00:00:00 | 905
2020-01-04 00:00:00 | 966
2020-02-10 00:00:00 | 138
2020-02-16 00:00:00 | 917
2020-03-21 00:00:00 | 146
2020-04-04 00:00:00 | 356
2020-04-12 00:00:00 | 512
2020-04-15 00:00:00 | 864
2020-04-15 00:00:00 | 123
2020-04-19 00:00:00 | 295
2020-04-23 00:00:00 | 320
2020-04-30 00:00:00 | 135
2020-04-30 00:00:00 | 957
2020-05-01 00:00:00 | 237
2020-06-10 00:00:00 | 751
2020-06-11 00:00:00 | 312
2020-06-21 00:00:00 | 908
2020-07-08 00:00:00 | 543
2020-08-05 00:00:00 | 636
2020-08-15 00:00:00 | 529
2020-08-16 00:00:00 | 338
2020-09-03 00:00:00 | 649
2020-09-23 00:00:00 | 1000
2020-09-24 00:00:00 | 952
2020-09-30 00:00:00 | 580
2020-10-16 00:00:00 | 727
2020-10-29 00:00:00 | 199
2020-12-09 00:00:00 | 268
2020-12-27 00:00:00 | 182
Spreadsheet: 06cecebc-d28b-4f9c-8e6d-763c8bcd3c29
Sheet: Sheet1

Table 5--Cottonseed meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2011/12 | 45 | 1090 | 0 | 1135 |  | 981.974 | 103.026 | 1085 | 50
2012/131 | 50 | 1125 | 0 | 1175 |  | 1010 | 115 | 1125 | 50
2013/142 | 50 | 990 | 0 | 1040 |  | 885 | 105 | 990 | 50
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2013-11-13 09:21:46.710000
Spreadsheet: 50157d1249545326-multiple-a-logical-result-array-with-a-text-array-and-return-text-book1
Sheet: Sheet1

 |  | [NAME] | [NAME] | [NAME] | [NAME] |  | Required result
height | Compulsory | compliant | compliant | non-compliant | non-compliant | #N/A | [NAME]
weight | flexible | compliant | compliant | compliant | compliant
character | Not important | non-compliant | non-compliant | compliant | non-compliant
health | flexible | compliant | compliant | non-compliant | non-compliant
position | flexible | non-compliant | compliant | non-compliant | compliant
location | Compulsory | non-compliant | non-compliant | compliant | compliant
qualification | Compulsory | compliant | compliant | non-compliant | compliant
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R45

Ime artikla
Spreadsheet: 875332d1721917334-how-to-automatically-filter-multiple-arrays-of-data-by-their-relevant-headings-lookup-sheet-test
Sheet: AccidentData

AccidentID | CreatedDate | AccidentNumber | OriginatorName | PhaseName | AccidentName | Description | OwnerName | AccidentToName | InitialProbabilityName | InitialSeverityName | PostProbabilityName | PostSeverityName | Notes | StatusName | Private | CustomFieldValueName | ReviewDate | AlarpStatusName
358064 |  | 1 |  |  | AN1 | AD1 |  |  |  |  |  |  | N1
358066 |  | 2 |  |  | AN2 | AD2 |  |  |  |  |  |  | N2
358065 |  | 3 |  |  | AN3 | AD3 |  |  |  |  |  |  | N3
358060 |  | 4 |  |  | AN4 | AD4 |  |  |  |  |  |  | N4
358055 |  | 5 |  |  | AN5 | AD5 |  |  |  |  |  |  | N5
358061 |  | 6 |  |  | AN6 | AD6 |  |  |  |  |  |  | [NAME]
358047 |  | 7 |  |  | AN7 | AD7 |  |  |  |  |  |  | N7
358058 |  | 8 |  |  | AN8 | AD8 |  |  |  |  |  |  | N8
358050 |  | 9 |  |  | AN9 | AD9 |  |  |  |  |  |  | N9
358053 |  | 10 |  |  | AN10 | AD10 |  |  |  |  |  |  | N10
358054 |  | 11 |  |  | AN11 | AD11 |  |  |  |  |  |  | N11
358057 |  | 12 |  |  | AN12 | AD12 |  |  |  |  |  |  | N12
358049 |  | 13 |  |  | AN13 | AD13 |  |  |  |  |  |  | N13
358062 |  | 14 |  |  | AN14 | AD14 |  |  |  |  |  |  | [NAME]
358063 |  | 15 |  |  | AN15 | AD15 |  |  |  |  |  |  | N15
358059 |  | 16 |  |  | AN16 | AD16 |  |  |  |  |  |  | N16
358051 |  | 17 |  |  | AN17 | AD17 |  |  |  |  |  |  | N17
358048 |  | 18 |  |  | AN18 | AD18 |  |  |  |  |  |  | N18
358052 |  | 19 |  |  | AN19 | AD19 |  |  |  |  |  |  | N19
358056 |  | 20 |  |  | AN20 | AD20 |  |  |  |  |  |  | N20