tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b61e1eb0-f154-40f4-8117-4acf8f6be1dd
Sheet: Sheet1

Gene | Chromosome | Dfam ID | rejected by [NAME] et al.
FBgn0002862 | 3R | 49768
FBgn0004173 | 3R | 49709
FBgn0004174 | 3R | 49708
[NAME] | 3L | 49588
FBgn0028537 | 2L | 49089
FBgn0028583 | X | 50040
FBgn0028855 | 2L | 49088
FBgn0029518 | X | 49895
FBgn0030338 | X | 49959
FBgn0031102 | X | 50028 | CG15462
FBgn0031276 | 2L | 48978
[NAME] | 2L | 49030
FBgn0032280 | 2L | 49056
FBgn0032282 | 2L | 49058
FBgn0032284 | 2L | 49060
FBgn0032708 | 2L | 49114 | CG15166
FBgn0033049 | 2R | 16118
FBgn0033587 | 2R | 49221
FBgn0033594 | 2R | 49222
FBgn0034010 | 2R | 49272
FBgn0034268 | 2R | 49314 | CG4989
FBgn0034377 | 2R | 4237
FBgn0034699 | 2R | 49482 | CG13504
FBgn0034828 | 2R | 49491
FBgn0035856 | 3L | 49565
FBgn0036131 | 3L | 49586
FBgn0036322 | 3L | 49598
FBgn0036393 | 3L | 49610
FBgn0036394 | 3L | 49611
FBgn0036588 | 3L | 49625
FBgn0036591 | 3L | 49627
FBgn0036870 | 3L | 49646
FBgn0037161 | 3L | 49664 | CG14460
FBgn0037420 | 3R | 49691
FBgn0037694 | 3R | 49736
FBgn0037769 | 3R | 49740
FBgn0038148 | 3R | 49761
FBgn0038242 | 3R | 49770
FBgn0038384 | 3R | 49778 | CG5470
FBgn0039103 | 3R | 49841 | CG13819
[NAME] | 3R | 49855 | [NAME]
FBgn0040523 | 3R | 49721
FBgn0040553 | 3R | 49760
FBgn0040566 | 3R | 49788 | CG14328
FBgn0040591 | 3R | 49839 | CG13828
FBgn0040613 | 3R | 49863 | CG12509
FBgn0040646 | X | 50036 | CG14580
FBgn0040717 | 2L | 48990
FBgn0040725 | 2L | 48979
FBgn0040729 | 2R | 49343
[NAME] | 2R | 49319 | CG14503
FBgn0040747 | 2R | 49268
FBgn0040797 | 3L | 49626
FBgn0040831 | 3L | 49568 | CG13673
FBgn0040893 | X | 49901 | CG14774
FBgn0040928 | X | 49940 | CG15345
FBgn0040971 | 2L | 49069 | CG15494
FBgn0046873 | 3R | 49694
FBgn0050126 | 2R | 49326
FBgn0050282 | 2R | 49478 | CG30282
FBgn0050353 | 2R | 49209 | CG30353
FBgn0050475 | 2R | 49269
FBgn0050479 | 2R | 49266
FBgn0051545 | 3R | 49687 | CG31545
FBgn0051556 | 3R | 49692
FBgn0051934 | 2L | 48985 | CG31934
FBgn0052070 | 3L | 49581 | CG32070
FBgn0052071 | 3L | 49584
FBgn0052073 | 3L | 49585
[NAME] | 3L | 49582 | [NAME]
FBgn0052098 | 3L | 49597 | CG32098
FBgn0052345 | 3L | 49506 | CG32345
FBgn0052504 | X | 50029 | CG32504
FBgn0052511 | X | 50033
FBgn0052534 | X | 50020
FBgn0052550 | X | 50012
FBgn0052552 | X | 50008 | CG32552
FBgn0052553 | X | 50009 | CG32553
FBgn0052689 | X | 49953
FBgn0052710 | X | 49941
FBgn0052733 | X | 49936
FBgn0052797 | X | 49908
FBgn0052824 | X | 50027 | CG32824
FBgn0052829 | 2L | 49025
FBgn0052830 | 2L | 49063
FBgn0053220 | X | 49918 | CG33220
FBgn0053251 | X | 49998
FBgn0053267 | 3L | 49592
FBgn0053280 | 3L | 49552 | CG33280
FBgn0053665 | X | 49929 | CG33665
FBgn0053797 | 4 | 49892
FBgn0066084 | 2R | 49499 | CG30425
FBgn0069921 | 4 | 49894
[NAME] | 2L | 49126 | CG41071
Spreadsheet: 754804d1636512281-using-sumif-with-an-or-or-else-trades-template-
Sheet: RESULTS 1

 | BREAKOUT STRATEGY NOTES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MEAN G/L | >= 4 | >= 5 | >= 6 | >= 7 | >= 8 | >= 9 | >= 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All-TIME (5)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 10 Wk
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 5 Wk
 | Trading Days | 252 | Annual calendar trading days
 | No Trade Days | 15 | Days w/ no trades available |  |  |  |  |  |  |  |  |  |  |  |  | TRADES | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Days Off | 0 | Vacation or other days w/ no trading |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Traded % |  | Used in Annualized Gain calculations |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | RULES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Enter only on 1 of 7 ideal setups |  |  |  |  |  |  |  | WEEKLY
 | Entry is within 10c of identified entry level |  |  |  |  |  |  |  | WEEK | TRADES | WIN % | POINTS | G/L $ | ENTRY % |  | ENTRY (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | [NAME] stop loss for entry price < 20 is 30c, > 20 is 50c |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Primary exit is 5x20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | ANNUALIZED GAIN CALCULATOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIN % (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Net Profit |  |  | ATI |  |  |  |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | GAIN/LOSS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 |  | All-time | Last 3 Wk | > 1 pt | > 2 pt | > 3 pt | > 4 pt
 | Win % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POINTS (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Profit % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Days (Traded) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Trades |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Wins |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Points (Net)
 | Points % (Net)
 | Points (Wk Ave)
 | Points (Annualized)
 | Entry Success %
 | Negative trades |  |  | Greatest sequence of negative trades
 | Ave [NAME] trades |  |  | Average sequence of negative trades
 | PM Trades
 | PM Trades %
 | PM Points (Net)
 | PM Win %
 | SETUP RESULTS
 | Setup | Trades | Trades % | Win % | Last 3 Wk | Points G/L | Entry %
 | PMH
 | PM Consolidation
 | Pivot
 | HOD
 | R2G
 | Daily
 | Consolidation
 | MAX GAIN
 |  | Ave | Mean 20%
 | Entry-High
 | High-Exit
 |  |  |  | > 1 pt | > 2 pt | > 3 pt | > 4 pt
 | Trades
 | % of All
 | ENTRY TIMES
 |  | Trades | Trades % | Ave
 | 8:30-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-15:59
Spreadsheet: tracy_geaccone__40346__sharris1001wk3
Sheet: Current Est Vs. Forecast 

Transwestern Pipeline Company
($[NAME])
October:  10/01/01 thru 10/16/01 |  |  |  |  |  | 2001-10-18 09:49:49.190000
Current Estimate vs. Forecast |  | October, 2001
 |  | 3rd Current | Weekly
 |  | Estimate | Forecast | [NAME] |  | Comments
West Demand Revenues |  | 10.42 | 10.539 | 0.1189999999999998 |  | USGT $11K,  Astra $3K Negotiated Rate
 |  |  |  |  |  | New Contracts:  PPL EnergyPlus, [NAME]
West Commodity Revenues |  | 0.822063 | 0.9064820000000005 | 0.08441900000000047 |  | West IT deals $92K
East Demand Revenues |  | 1.111 | 1.228 | 0.117 |  | Assumed [NAME] turn back in October
East Commodity Revenues |  | 0.143 | 0.1579999999999999 | 0.0149999999999999 |  | Higher IT Rates
[NAME] |  | 0.672 | 0.694 | 0.02199999999999991 |  | New Contract: Burlington; Reliant $2K
[NAME] Revenues |  | 0.08399999999999996 | 0.06200000000000006 | -0.02199999999999991 |  | Lower IT Volumes
PNR Revenues |  | 0 | 0.005047899999999999 | 0.005047899999999999
Revenue Variance |  | 13.252063 | 13.5925299 | 0.3404668999999974
Fuel Price [NAME] |  | 0.612 | 0.494 | -0.118 |  | MTD index price of $1.84 vs. 3nd CE index price of $2.28
Fuel Volume Variance-Unhedged |  | 0 | -0.122 | -0.122 |  | Lower retained volumes
Sales Margin Variance on Unhedged |  | 0 | 0.048 | 0.048 |  | Over-retained fuel sales
Hedging Adjustment |  | 2.206 | 2.206 | 0
Other Adjustment |  | 0 | 0 | 0
Fuel Variance (Excludes UAF) |  | 2.818 | 2.627 | -0.192
Current Month Margin Variance |  | 16.070063 | 16.2195299 | 0.1484668999999973
Expenses |  | -0.944 | -0.944 | 0
Non-Recurring |  | 0 | 0 | 0
Other |  | -0.004 | -0.004 | 0
Total Current Month Variance |  | 15.122063 | 15.2715299 | 0.1484668999999973
[NAME] |  | 48.063 | 47.153 | -0.9100000000000037
2nd Qtr |  | 52.278 | 52.278 | 0
1st Qtr |  | 47.784 | 47.784 | 0
October 31, 2001 YTD |  | 163.247063 | 162.4865299 | -0.7615331000000063 |  | Includes September Actuals
 |  |  |  |  |  | YTD variance decreased due to OBA re-evaluations for August & September
Spreadsheet: 124832d1318631223-excel-2007-if-statement-and-match-function-problem-cost
Sheet: Cost

Type | Error | Cost
PC | Harddrive | 50
MAC | Harddrive | 60
PC | Monitor | 110
MAC | Monitor | 120
PC | Keyboard | 30
PC | Touchpad | 40
Spreadsheet: 870484d1716989668-if-statement-with-variable-length-range-help
Sheet: Sheet3

Structure Level | CAD file | Version | State (CAD) | Context | CAD Chack | Option and lower level CAD
0 | 11111111.ASM | x | x | x | -
1 | CAD Not Found | x | x | x | Non CAD item
2 | CAD Not Found | x | x | x | -
2 | CAD Not Found | x | x | x | -
1 | 222222.ASM | x | x | x | Has CAD
2 | 333333333.PRT | x | x | x | -
2 | 44444444.PRT | x | x | x | -
2 | 5555555.ASM | x | x | x | -
1 | CAD Not Found | x | x | x | Blank
2 | 777777777.PRT | x | x | x | -
2 | 888888888.PRT | x | x | x | -
2 | 999999.PRT | x | x | x | -
2 | 1011111.PRT | x | x | x | -
2 | 102222222.PRT | x | x | x | -
Spreadsheet: 877217d1723947124-fully-automatic-seating-plan-exam-hall-for-various-group-input
Sheet: 3rd bba 

S. No | Register No | Student Name
1 | 128118001 | Achu
2 | 128118002 | Asva
3 | 128118004 | [NAME]
4 | 128118005 | Desh
5 | 128118006 | Deva
6 | 128118007 | [NAME]
7 | 128118008 | Gows
8 | 128118009 | Gudi
9 | 128118011 | Kris
10 | 128118012 | Mait
11 | 128118013 | [NAME]
12 | 128118014 | Mart
13 | 128118015 | Nand
14 | 128118017 | Than
15 | 128118018 | Srid
16 | 128118019 | Ramy
17 | 128118020 | [NAME]
18 | 128118021 | Saga
19 | 128118022 | [NAME]
20 | 128118023 | Sahn
21 | 128118024 | Saya
22 | 128118025 | Shah
23 | 128118026 | Sham
24 | 128118027 | [NAME]
25 | 128118028 | Sree
26 | 128118029 | Srin
Spreadsheet: 153715d1336027215-how-do-i-sumif-a-date-range-using-rows-not-columns-copy-of-cashflow-statement-1
Sheet: Weekly

 |  | Opening Balance |  |  |  |  |  |  |  |  |  |  |  |  |  | Closing Balance
 | Cash on Hand
 | CASH RECEIPTS
 | Cash Sales
 | EFTPOS Sales
 | TOTAL CASH RECEIPTS
 | CASH PAID OUT
 | Tonkin
 | Decosti
 | Discount Packaging
 | Coca Cola Amatil
 | Juice
 | Chicken
 | Fresh Vegetables
 | Other (Specify)
 | Other (Specify)
 | Other (Specify)
 | Wages
 | Rent
 | Repairs & maintenance
 | Advertising
 | Telephone
 | Utilities (Electricity)
 | Utilities (Gas)
 | Utilities (Water/Waste)
 | Miscellaneous (Specify)
 | Miscellaneous (Specify)
 | SUBTOTAL
 | [NAME]'s Withdrawal
 | TOTAL CASH PAID OUT
 | CASH POSITION (End of Week)
Spreadsheet: 456020d1460610026-help-compare-2-columns-different-sheets-if-value-match-copy-the-value-of-other-cell-test
Sheet: Sheet1

 | 2 | 4011100240216 | [NAME] | 1.8 | 1.74757281553398
 |  | 8691707135052 | [NAME] [NAME], caremel si nuga 125 gr. | 0.49 | 0.4757281553398058
 |  | 8691707077079 | Ciocolata Crazy [NAME] si orez expandata 30 gr. | 0.98 | 0.9514563106796116
 |  | 8691707038933 | Ciocolata cu alune Winergy 40 gr. | 0.98 | 0.9514563106796116
 |  | 8691707038117 | [NAME] nuga [NAME] 40 gr. | 0.9 | 0.8737864077669902
 |  | 8690997026521 | [NAME] crema de caspsuni 80 gr, | 1.85 | 1.796116504854369
x |  | 80177609 | [NAME] 50 gr. | 2.75 | 2.669902912621359
x |  | 40084701 | [NAME] | 5.35 | 5.194174757281553
 | 1.48 | 5900951138982 | Ciocolata Mars 47gr | 1.9 | 1.844660194174757
 |  | [PHONE] | [NAME] | 3.3 | 3.203883495145631
 | 1.48 | [PHONE] | [NAME]  57.5GR | 1.9 | 1.844660194174757
 |  | 5900951025808 | [NAME] 21,5gr | 1.4 | 1.359223300970874
 |  | 5000159461122 | [NAME] 50gr | 1.9 | 1.844660194174757
 |  | 5000159484923 | Ciocolata Snickers Intense Choc 50 gr. | 2 | 1.941747572815534
x |  | 5000159472906 | [NAME] gr | 1.73 | 1.679611650485437
 |  | 5201911001000 | Crema de ciocolata Finetti 1 kg. | 19.5 | 18.93203883495146
 |  | 6422358541754 | CREMA DE ALUNE NUTELLA 400 GR. | 16.2 | 15.72815533980582
 |  | 1000000000115 | CREMA DE ALUNE 1 KG SG | 110 | 106.7961165048544
x |  | 8000500023976 | Ferrero Raffaello T15 150 gr. | 12.4 | 12.03883495145631
 | 2.2 |  | [NAME], [NAME] 43 gr. | 2.8 | 2.718446601941747
x |  | 40084176 | Kinder Country 23,5gr | 1.75 | 1.699029126213592
 |  | 8000500023624 | Kinder Happy Hippo T5 | 9.5 | 9.223300970873787
x |  | 40084077 | [NAME] T1 | 1.55 | 1.504854368932039
x |  | 40084107 | Kinder Suprize | 3.8 | 3.689320388349514
x |  | 80310891 | [NAME] cu surprize [NAME] gr. | 4 | 3.883495145631068
 |  | 54088191 | KINDER OUA SURPRIZE Roz 20GR | 3.8 | 3.689320388349514
 |  | 8699462604851 | [NAME] surprize Little Farm 25 gr. | 1.2 | 1.16504854368932
 |  | 8699462604004 | [NAME] cu surprize Toy Toy 25 gr. | 1.3 | 1.262135922330097
x |  | 8600939354315 | Praline ciocolata [NAME] 204 gr. | 12.5 | 12.13592233009709
 |  | 5999539461022 | IEPURAS DE CIOCOLATA NIC 18 GR. | 0.57 | 0.5533980582524272
 |  | 5999539461091 | IEPURAS DE CIOCOLATA NIC 40 GR. | 0.95 | 0.9223300970873786
 |  | 5999539700015 | OUA DE CIOCOLATA LINGA ROSU 23 GR. | 0.5 | 0.4854368932038835
 |  | 5998759704810 | OUA DE CIOCOLATA LINGA 23 GR. CU MODELE | 0.52 | 0.5048543689320388
 |  | 5998759700997 | OUA DE CIOCOLATA DE PASTE LINGA 120 GR. | 2.6 | 2.524271844660194
 |  | 5998759704742 | OUA DE CIOCOLATA UMPLUTE DE PASTE LINGA 120 GR. | 2.61 | 2.533980582524272
 |  | 1000000000504 | TOPPING THE CIOCOLATA PACIFIC 1 KG. | 37 | 35.92233009708738
 |  | 4008400102528 | PRALINE DE CIOCOLATA CU CIRESE SI LICHIOR MON CHERI FERRERO | 10 | 9.70873786407767
Spreadsheet: 36467d1234358044-display-and-print-orders-first-rows-test-1-
Sheet: xyz

Sipariş | Sipariş Kategorisi | Orjinal Yükleme [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Kontrol Sonucu | 5
1000 | a | 2008-11-26 00:00:00 | 2008-10-08 00:00:00 | 2008-01-10 00:00:00 | 2009-02-09 00:00:00 | 01.02.2009 05.02.2009 06.02.2009 | 2009-02-09 00:00:00 | N |  | 2
1000 | b | 2008-11-26 00:00:00 | 2009-02-14 00:00:00 |  | 2008-10-15 00:00:00
1000 | c | 2008-11-26 00:00:00 | 2008-10-05 00:00:00 | 2009-01-10 00:00:00 | 2009-01-18 00:00:00
1005 | a | 2008-11-26 00:00:00 | 2008-10-08 00:00:00 |  | 2008-10-15 00:00:00 |  |  |  |  | 5
1005 | b | 2008-11-26 00:00:00 | 2008-10-08 00:00:00 | 2008-10-08 00:00:00 | 2008-10-15 00:00:00
1010 | a | 2009-03-04 00:00:00 | 2009-01-15 00:00:00 | 2009-01-05 00:00:00 | 2009-01-21 00:00:00 |  |  |  |  | 7
1010 | b | 2009-02-11 00:00:00 | 2008-12-24 00:00:00 |  | 2008-12-31 00:00:00
1012 | 3 |  |  |  |  |  |  |  |  | 9
1012 | 4
1050 |  |  |  |  |  |  |  |  |  | 11
1050
Spreadsheet: 29046d1223706124-two-dimensional-help-jg-master
Sheet: GT-Sun

 |  |  |  |  |  |  |  |  |  |  | # in class
 | RODEO: MSLBRA
 | DATE:
 | DIVISION:  Jr. Girls
 | EVENT:  [NAME]
 | PERFORMANCE: Rodeo #1
 | Secretary's Signature:
 | # | NAME | HOMETOWN | DRAW | OFFICIAL TIME | BACK UP TIME | PENALTY AND COMMENT | TOTAL | PLACE | Pts
 | 6431 | CallieRuth Bridgforth | Anywhere, NY |  |  |  |  |  | 1 | 73
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
Spreadsheet: 26313d1218463903-finding-min-from-another-worksheet-help-please
Sheet: Data

Date |  |  |  |  | [NAME] | Min Low | Highest High | Lowest Low
2007-09-10 00:00:00 |  |  |  |  | 1489.58 | 1439.29 | 1489.58 | FORUMLA HERE
2007-09-17 00:00:00 |  |  |  |  | 1549.02 | 1484.24 | 1549.02
2007-10-01 00:00:00 |  |  |  |  | 1576.09 | 1527.25 | 1576.09
2007-10-16 00:00:00 |  |  |  |  | 1550.66 | 1490.4 | 1550.66
2007-10-22 00:00:00 |  |  |  |  | 1544.67 | 1489.56 | 1544.67
2007-10-29 00:00:00 |  |  |  |  | 1552.76 | 1536.43 | 1552.76
2007-11-12 00:00:00 |  |  |  |  | 1492.14 | 1466.47 | 1492.14
2007-11-19 00:00:00 |  |  |  |  | 1456.7 | 1456.7 | 1456.7
2007-11-26 00:00:00 |  |  |  |  | 1518.27 | 1504.96 | 1518.27
2007-12-10 00:00:00 |  |  |  |  | 1523.57 | 1504.96 | 1523.57
 |  |  |  |  | [NAME] high = highest high
 |  |  |  |  | Min low = lowest low
Spreadsheet: 469695d1468068991-report-using-looksup-match-and-pivot-help-oeldere-469693d1468068329-report-using-looksup-match-and-pivot-help-file
Sheet: Blad2

Aantal van Student In | Kolomlabels
Rijlabels | aprYY | febYY | janYY | junYY | [NAME] | Eindtotaal
[NAME] |  |  |  | 1 | 1 | 2
109 |  |  |  |  | 1 | 1
136 |  |  |  | 1 |  | 1
[NAME] | 1 | 1 | 1 |  | 1 | 4
160 |  |  | 1 |  |  | 1
86 |  |  |  |  | 1 | 1
99 | 1 | 1 |  |  |  | 2
[NAME] |  | 1 |  |  |  | 1
176 |  | 1 |  |  |  | 1
Virgin | 3 |  | 1 | 1 | 2 | 7
102 | 1 |  |  |  |  | 1
103 |  |  |  |  | 1 | 1
104 |  |  | 1 |  |  | 1
109 | 1 |  |  |  |  | 1
111 |  |  |  |  | 1 | 1
91 | 1 |  |  |  |  | 1
92 |  |  |  | 1 |  | 1
Eindtotaal | 4 | 2 | 2 | 2 | 4 | 14
Spreadsheet: 863447d1710937031-if-statement-or-alternative-grading-etaf2
Sheet: Sheet1

Grading | Business Critical | Critical | Major | Minor | Observation |  | Excellent | There are no Non-Compliance issues and no Observations on this audit. | If each column if blank = Blank
Excellent | 0 | 0 | 0 | 0 | 0 |  | Good | There are no Minor Non-Compliances on this audit. (There is at least one Observation.) | If the score in each column is zero the cell populates "Excellent"
Good | 0 | 0 | 0 | 0 | 1 |  | Fair | There are no Major Non-Compliances on this audit. (There is at least one Minor Non-Compliance.) | Business Critical Column (B9) is 1 or more than 1 the cell in All populates "Fail"
Fair | 0 | 0 | 0 | 1 |  |  | Needs Improvement | There are three or fewer (i.e. between 1 and 3) Major Non-Compliances on this audit. | Critical Column (C9) is 1-3 = "Unsatisfactory"
Needs Improvement |  | 0 | 3 |  |  |  | Unsatisfactory | There are four or more Major Non-Compliances on this audit. | Critical Column (C9) is 4 or more than 4 = "Fail"
Unsatisfactory |  | 3 | 4 |  |  |  |  | There are three or fewer (i.e. between 1 and 3) Critical Non-Compliances on this audit. | Major [NAME] (D9) is 1-3 = "Needs Improvement"
Fail | 1 | 4 |  |  |  |  | Fail | There are four or more Critical Non-Compliances on this audit. | Major [NAME] (D9) is 4 or more than 4 = "Unsatisfactory"
 |  |  |  |  |  |  |  | There are one or more Business Critical Non-Compliances on this audit. | Minor Column (E9) is 1 or more than 1 = "Fair"
Factory Result | 0 | 0 | 0 | 0 | 0 |  |  |  | Observation Column (F9) is 1 or more than 1 = "Good"
 |  |  |  |  |  |  |  |  | fail | OR( B9>=1 , c9>=4, E9>=1 )
 |  |  |  |  |  |  |  |  | Unsatisfactory | OR(AND(C9>=1,C9<=3),D9>=4)
 |  |  |  |  |  |  |  |  | Needs Improvement | AND(D9>=1,D9<=3)
 |  |  |  |  |  |  |  |  | Fair | E9>1
 |  |  |  |  |  |  |  |  | good | F9>=1
 |  |  |  |  |  |  |  |  | Excellent | Sum(B9:F9)=0
 |  |  |  |  |  |  |  |  | BLANK | AND(B9="",C9="",D9="",E9="",F9="")
Spreadsheet: 00dcd6e3-b12b-413e-b53f-cdc8be3acb21
Sheet: Sheet1

Office of Fleet Management Services | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Cost Comparison Between
Enterprise Provided Vehicle and Mileage Reimbursement
Effective March 1, 2012
DAILY VEHICLE NEEDS
Enter [NAME]'s Name
Enter Agency
Enter Destination
Enter Number of Miles for the Trip
Enter the Number of Days for the Trip
 | Enterprise |  | Personal
 | Vehicle |  | Vehicle
Lowest Cost Transportation: | 0 |  | 0
Go to Enterprise
Spreadsheet: 861659d1709546797-linking-and-deleting-cell-data-league-blank
Sheet: BLANK

 |  | MATCH 1 |  | POINTS | MATCH 2 |  | POINTS | MATCH 3 |  | POINTS | MATCH 4 |  | POINTS | MATCH 5 |  | POINTS | MATCH 6 |  | POINTS | MATCH 7 |  | POINTS | MATCH 8 |  | POINTS | POINTS | DROPS | NET POINTS | SECTION WINS | TOTAL WEIGHT
 |  | 2023-11-12 00:00:00 |  |  | 2023-11-26 00:00:00 |  |  | 2023-12-10 00:00:00 |  |  | 2023-12-17 00:00:00 |  |  | 2024-01-07 00:00:00 |  |  | 2024-02-04 00:00:00 |  |  | 2024-02-18 00:00:00 |  |  | 2024-03-03 00:00:00
1
2
3
4
5 |  | 151 | 0 | 2 | 167 | 2 | 2 | 173 | 3 | 2 | 80 | 1 | 4 | 62 | 0 | 3 | 150 | 7 | 1 | 237 | 14 | 2 | 124 | 12
6
7 |  | 183 | 15 | 1 | 117 | 15 | 3 | 114 | 11 | 2 | 162 | 15 | 2 | 9 | 7 | 5 | 104 | 5 | 3 | 155 | 15 | 5 | 84 | 10 | 2
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 82765d1282781623-extract-data-to-different-workbook-example-workbook
Sheet: 2

 |  |  | 2008-01-02 00:00:00
Location | Trips | Liters | Gallons
[NAME] | 1 | 378.5 | 100
Centurion | 2 | 757 | 200
Dragon | 3 | 1135.5 | 300
Bldg 0039 | 4 | 1514 | 400
Fac 1 | 5 | 1892.5 | 500
Man | 6 | 2271 | 600
Dog Pen | 7 | 2649.5 | 700
Canal | 8 | 3028 | 800
Hot | 9 | 3406.5 | 900
 | 10 | 3785 | 1000
[NAME]
 | 55 | 20817.5 | 5500
 | 110 | 41635 | 11000
Spreadsheet: 330087d1404521443-comparing-cells-with-a-reference-source-and-skip-blanks-excelforummergedcellsformula-2014-07-04-20-28
Sheet: MacroToCalculate

[NAME] in Cell AG23 is now: =OkNgDash4(AC19,Y23:AF23)
Formula auto adjusts if rows/columns are inserted or deleted.
The following routines are required (ModCalculateOkNgDash4):
a. Function OkNgDash4()
b. Function IsMerged()
c. Function IsTopLeftCellOfMergedRange()
Reference: |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/1020365-comparing-cells-with-a-reference-source-and-skip-blanks.html#post3750429
Installation Insructions:
a. Open this [NAME]
b. Open the [NAME] that needs to have the Macro Installed ([NAME]).
c. In the Project Explorer, 'Right Click on ModCalculateOkNgDash4 associated with this file.
d. Export ModCalculateOkNgDash4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Case 2 - Merged Cells and macro
e. 'Right Click' on any [NAME] in Project Exlorer for the 'Target Workbook' |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BATCH NO.: |  |  |  | 4021
f. Import Module ModCalculateOkNgDash4 into the 'Target Workbook'.
[NAME] the 'Target Workbook'.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4021 |  | 4021 |  | 4021 |  | OK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell AG23 contains formula that uses macro OkNgDash4()
Spreadsheet: 873187d1719612107-highlight-data-based-on-matching-concantenated-criteria-matching
Sheet: CustList

Customer# | BR | KD | MX | NX |  | matching criteria
102538 | 7 | 17 | 68 | 27 |  | 102538BR
1105190 | 5 | 115 | 309 | 68
1213919 | 0 | 24 | 10 | 4 |  | 1213919NX
1293493 | 52 | 58 | 9 | 39 |  | 1293493BR
130096 | 0 | 8 | 0 | 4 |  | 130096NX
1308261 | 27 | 17 | 18 | 34 |  | 1308261NX
131128 | 0 | 0 | 0 | 0 |  | 131128BR
230617 | 9 | 1 | 0 | 4 |  | 230617NX
503512 | 4 | 138 | 4 | 194
790888 | 49 | 139 | 16 | 276
89215 | 7 | 104 | 16 | 28
89273 | 9 | 6 | 20 | 55 |  | 89273KD
89352 | 0 | 6 | 27 | 220 |  | 89352KD
89353 | 34 | 4 | 12 | 284 |  | 89353KD | 89353MX
89356 | 4 | 351 | 322 | 73 |  | 89356MX
89363 | 7 | 20 | 72 | 146 |  | 89363MX
89572 | 9 | 133 | 22 | 170 |  | #N/A