tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857431d1706454927-how-to-take-the-net-present-value-of-column-of-numbers-npv
Sheet: Sheet1

 |  | NPV
 |  | 68 | -2979.65
 | 1 | 69 | -3426.597499999999
 | 2 | 70 | -3940.587124999999
 | 3 | 71 | -4531.675193749998
 | 4 | 72 | -5211.426472812498
 | 5 | 73 | -5993.140443734373
 | 6 | 74 | -6892.111510294528
 | 7 | 75 | -7925.928236838707
 | 8 | 76 | -8074.851499999999
 | 9 | 77 | -8074.851499999999
 | 10 | 78 | -8074.851499999999
 | 11 | 79 | -8074.851499999999
 | 12 | 80 | -8074.851499999999
 | 13 | 81 | -8074.851499999999
 | 14 | 82 | -8074.851499999999
 | 15 | 83 | -8074.851499999999
 | 16 | 84 | -8074.851499999999
 | 17 | 85 | -8074.851499999999
 | 18 | 86 | -8074.851499999999
 | 19 | 87 | 264753.6258698964
 | 20 | 88 | 277991.3071633913
 | 21 | 89 | 291890.8725215608
 | 22 | 90 | 306485.4161476389
 | 23 | 91 | 321809.6869550208
 | 24 | 92 | 337900.1713027718
 | 25 | 93 | 354795.1798679105
Spreadsheet: 708562d1607930387-array-index-problems-need-assistance-or-any-advice-to-help-to-create-formula-to-enable-to-book1
Sheet: Before Sheet

Information in Spreadsheet 1
Family ID | No of Children | Student ID
2022 | 2
2022 | 2
2023 | 2
2023 | 2
2841 | 2
2841 | 2
2405 | 3
2026 | 2
2378 | 3
2377 | 1
2378 | 3
2028 | 3
2691 | 2
2331 | 1
Spreadsheet: 4d90abc2-8f46-4579-9b63-da4e4c0bca95
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
 | IX.A. Produto [NAME], Óptica da Despesa/ Gross Domestic Product, [NAME]
 | Descrição | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 |  | Description
 | Variação percentual de volume/Growth rate in volume (%)
 | Consumo final | 2.5 | 33.6 | 5.8 | 4.9 | 6.8 | 5.2 | 7.5 | 6.1 |  | Total Consumption
 | Consumo privado | 0.7 | 34.9 | 5.4 | 4.3 | 7 | 4.5 | 7.5 | 6.1 |  | Private Consumption
 | Consumo final, governo | 16.3 | 25.4 | 8.7 | 9.1 | 5.3 | 10.2 | 7.2 | 6.5 |  | Government Consumption
 | Forma. bruta de capital fixo | -24.3 | 33.6 | -7.8 | -5.6 | 10.2 | 6.2 | 5.8 | 11.2 |  | Gross Capital Formation
 | Variação de existências | 90.3 | -105.4 | -203.9 | -273.3 | -147.6 | -445.7 | 36.7 | 11.9 |  | Variation of Stocks
 | Exportações | 50.4 | 38.3 | 19 | 21.3 | 6.3 | 12.2 | 15.9 | 0.5 |  | Exports
 | Bens | 77.6 | 21.1 | 22.2 | 31.9 | 4.9 | 15 | 13.1 | -3.5 |  | Goods
 | [NAME] | -27.2 | 159 | 8.5 | -17.8 | 14.6 | -2.5 | 33.8 | 22.5 |  | Services
 | Menos: Importações | -21.3 | 104.6 | 4.6 | 1.7 | 5.5 | 1.2 | 12.8 | 2.8 |  | Minus: Imports
 | Bens | -22.5 | 105.7 | 3.2 | 4.3 | 3.5 | 1.9 | 7.5 | -7 |  | Goods
 | [NAME] | -16.6 | 100.5 | 10.1 | -7.9 | 13.7 | -1.8 | 33.4 | 33.6 |  | Services
 | PIBpm | 12.3 | 9.2 | 6.5 | 7.9 | 8.4 | 8.7 | 7.3 | 6.7 |  | GDP (mp)
 | Descrição | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 |  | Description
 | Variação percentual de preços/Growth rate in price (%)
 | Consumo final | 17.7 | 3.3 | 6.4 | 8 | 7.2 | 7.8 | 7.4 | 9 |  | Total Consumption
 | Consumo privado | 15.4 | 6.5 | 6.4 | 7 | 7.5 | 8.6 | 7.9 | 9.4 |  | Private Consumption
 | Consumo final, governo | 30.2 | -14.2 | 6.3 | 14.8 | 5.3 | 2.6 | 3.8 | 6.3 |  | Government Consumption
 | Forma. bruta de capital fixo | 9.6 | 32.4 | -10 | 2.8 | 7.3 | 5.6 | -0.5 | 1 |  | Gross Capital Formation
 | Variação de existências | 54.2 | 36.4 | -40.9 | 0.3 | -927.4 | -122.2 | 6.1 | -25.7 |  | Variation of Stocks
 | Exportações | 42 | 0.5 | -1.3 | 8.5 | 13.4 | 5.8 | 0.9 | 0.2 |  | Exports
 | Bens | 36.8 | 1.4 | 6.3 | 9.8 | 15.5 | 5 | 1.8 | 2.5 |  | Goods
 | [NAME] | 95.8 | -20.6 | -19.9 | 1 | 2.2 | 8.3 | -2.9 | -7.7 |  | Services
 | Menos: Importações | 42.4 | -3.7 | -2.7 | 7.4 | 4.9 | 4 | -0.6 | 0.5 |  | Minus: Imports
 | Bens | 44.3 | -4.1 | -2.5 | 10 | 5.5 | 3 | 0.6 | 4.9 |  | Goods
 | [NAME] | 34.9 | -2.1 | -3.3 | -3.2 | 3.3 | 8 | -3.3 | -7.1 |  | Services
 | PIBpm | 14.5 | 7.9 | 4.8 | 7.5 | 8.8 | 9.3 | 7.4 | 8.2 |  | GDP (mp)
 | (1) Estimativas preliminares/ Preliminary figures
 | Fonte/Source: Instituto Nacional de Estatística
Spreadsheet: dana_davis__4507__1 Central Records Form
Sheet: ZOO69683

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 404 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20144 |  | Wire Transfers |  |  |  |  |  | Z0069683
 |  | JILP Wire Transfers
 |  | Wire Transfers |  |  |  | 1997-05-01 00:00:00 | 1997-08-01 00:00:00
 |  | Wire Transfers |  |  |  | 1997-11-01 00:00:00 | 1997-12-01 00:00:00
 |  | Wire Transfers Co. 527 |  |  |  | 1997-01-01 00:00:00 | 1997-04-01 00:00:00
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: 390270d1429577201-returning-data-from-a-table-based-on-a-drop-down-selection-table-returns-from-drop-down-s-
Sheet: Tables

 | Table 1 |  |  |  |  |  | Table 2 |  |  |  |  |  |  | Table 3
No. | Good | Average | Poor | Good | Average | Poor | Level | Good | Average | Poor | Good | Average | Poor | Level | Good | Average | Poor | Good | Average | Poor
1 |  |  |  | 1 | 0.75 | 0.5 | 1 |  |  |  | 2 | 0.45 | 0.333 | 1 |  |  |  | 5 | 3 | 1
Spreadsheet: 52205d1251906721-how-to-figure-if-a-value-falls-between-values-in-a-list-profile2
Sheet: Sheet1

Station | Elevation | Rise | Run | Slope
1655.2 | 4238.6
 |  | 0.3900000000003274 | -24.79999999999995 | -0.01572580645162613
1680 | 4238.21
 |  | 0.2300000000004729 | -50 | -0.004600000000009459
1730 | 4237.98
 |  | -0.2300000000004729 | -50 | 0.004600000000009459
1780 | 4238.21
 |  | 0.3599999999996726 | -50 | -0.007199999999993451
1830 | 4237.85
 |  | -0.3999999999996362 | -88.96000000000004 | 0.00449640287769375
1918.96 | 4238.25
 |  | 0.2100000000000364 | -84.00999999999999 | -0.002499702416379436
2002.97 | 4238.04
 |  | -0.6000000000003638 | -97.02999999999997 | 0.006183654539836793
2100 | 4238.64
 |  | 0.8400000000001455 | -185.6799999999998 | -0.004523912106851283
2285.68 | 4237.8
 |  | -0.1700000000000728 | -82.80999999999995 | 0.002052892162783153
2368.49 | 4237.97
 |  | 0.1900000000005093 | -41.51000000000022 | -0.004577210310780735
2410 | 4237.78
 |  | -0.8400000000001455 | -186.1399999999999 | 0.004512732351993908
2596.14 | 4238.62
 |  | 0.2100000000000364 | -84.84000000000015 | -0.0024752475247529
2680.98 | 4238.41
 |  | -0.2600000000002183 | -59.01999999999998 | 0.004405286343616035
2740 | 4238.67
 |  | 0.6499999999996362 | -70 | -0.009285714285709089
2810 | 4238.02
 |  | -0.4399999999995998 | -97.67000000000007 | 0.004504965700825223
2907.67 | 4238.46
 |  | -0.1700000000000728 | -85.36000000000013 | 0.001991565135895882
2993.03 | 4238.63
 |  | 0.1999999999998181 | -26.9699999999998 | -0.007415647015195387
3020 | 4238.43
 |  | -1.079999999999927 | -194.3200000000002 | 0.005557842733634862
3214.32 | 4239.51
Spreadsheet: 740429d1626340111-power-query-refresh-and-sumifs-excel-forum-example
Sheet: Sheet1

 |  |  | 2021-01-01 00:00:00 |  | 2021-02-01 00:00:00 |  | 2021-03-01 00:00:00
Acc Number | Customer Name | Partner Status | Distribution | Project | Distribution | Project | Distribution | Project
Example1 | Example 1 | Partner
Example2 | Example 2 | Partner
Example3 | Example 3 | Partner
Example4 | Example 4 | Partner
Pulled through PQ
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: ASTRON

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | [NAME] | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | ASTRON 150 | 1 | X | 1 | X | 1
5 | ASTRON 160 | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 1b1bde18-fc45-4963-a7b6-7dfba43b25e6
Sheet: Sheet1

Table 6--Cottonseed oil:  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
 | Million pounds
2010/11 | 92.539 | 835 | 0.202 | 927.741 |  | 598.913 | 163.828 | 762.741 | 165
2011/121 | 165 | 755 | 10.347 | 930.347 |  | 571.486 | 258.861 | 830.347 | 100
2012/132 | 100 | 830 | 0.3 | 930.3 |  | 700.3 | 130 | 830.3 | 100
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2012-12-17 14:07:33.030000
Spreadsheet: 158486d1338281260-reverse-horizontal-lookup-from-a-vertical-code-ef100_ys0fbqoh7iqdmnj-copy
Sheet: Sheet1

Code | Assets |  |  |  |  |  | Liabilities |  |  | Other |  |  | Transactions
 | Product1 | Product2 | Product3 | Product4 | Product5 | Product6 | Product7 | Product8 | Product9 | Product10 | Product11 | Product12 | Product13 | Product14
123 | 19768.32 | 623635.6036335983 |  | 89912.242022 | 2320 |  | 40408.74021732264 | 2712.085821008514 | 4026.272246311245 |  |  | 48922.16474468567 | 7899.74 | 17426.831622997
345 | 23552.64 | 150901.3121486976 | 224964.2984347449 | 122280.833132 | 960 |  | 86202.99064172842 | 19119.26626846797 | 3797.995496426 |  |  | 30003.13852394901 | 19956.02 | 33340.16549879903
789 | 25850.88 | 594848.1678111497 | 272426.2247639535 | 63945.08658800001 | 3360 |  | 129587.0325181295 | -620.1170811373916 | 45138.83790826312 |  |  | 63798.41834619919 | 24589.74 | 149742.3556213533
1011 | 4872.959999999999 | 59835.83350716323 |  | 79018.35302 | 960 |  | 50229.57649032576 | -1150.0609635847 | 19554.08834650903 |  |  | 7188.295880108656 | 24083.03 | 23028.72962532401
1213 | 26732.16 | 237585.2559051067 | 69437.95702589634 | 91640.200404 | 3200 |  | 31947.27161257337 | 1187.366244389833 | 10142.18312515496 |  |  | 45741.03871704078 | 7599.11 | 16460.01462476458
1415 | 55157.76 | 448909.534932224 | 28514.11898944738 | 145469.967391 | 3760 |  | 119679.8755129859 | 25231.63498874196 | 11040.37039951114 |  |  | 47122.25911444653 | 11615.92 | 221921.9347543528
1617 | 44271.36 | 403649.9536848106 | 165490.6230938634 | 78297.08837499999 | 6800 |  | 69505.85749185053 | 5337.444969282263 | 10439.91002909717 |  |  | 104557.4538916645 | 17953.89 | 16635.622326886
1819 | 27613.44 | 181195.9353921357 |  | 39240.74111800001 | 3360 |  | 42291.844160188 | -199.0238897882485 | 2809.140368973916 |  |  | 42223.6654877874 | 20399.61 | 39150.66913610792
2021 | 18869.76 | 190188.7649311953 | 130237.6782138035 | 121089.857692 | 1440 |  | 68325.0161642254 | -646.7378238154757 |  |  |  | 55632.4985575797 | 16646.88 | 79602.5876288823
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For each code, I need to find Top 5 products
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  |  |  |  |  |  | And return their names and values
123 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So output would look something like this
345
789 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Value
1011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | top1 name | top 1 value
1213 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | top2 name | top2 value
1415 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | etc.
1617 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
1819 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
2021
Spreadsheet: 765029d1643128111-how-to-extract-and-list-all-values-from-table-range-that-meet-certain-criteria-sample-ids
Sheet: Sheet1

ITEM ID > | MEN000059 | A | B | C | D | E | F | G | H | I | J |  | Parent ID
1 |  |  |  |  |  |  |  |  |  |  |  |  | MEN000059
2 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
3 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
4 |  |  |  |  |  |  |  |  |  |  |  |  | SUB000076
5 |  |  |  |  |  |  |  |  |  |  |  |  | SUB000005
6
7
8
9
10
A
A
A
A
A
A
Spreadsheet: drew_fossum__8677__Fixed3
Sheet: MEC_8_Expired

NORTHERN NATURAL GAS COMPANY
FUEL HEDGING BOOK
MID-AMERICAN ENERGY COMPANY-EXPIRED
Prod. | Contract | Contract | Fixed |  | Volume | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | IF-Ventura | IF-Ventura | (4) | (4) | (4)
1999-11-01 00:00:00 | 105706 | MEC |  |  | 40000 | 3.04
1999-12-01 00:00:00 | 105706 | MEC |  |  | 40000 | 2.11
2000-01-01 00:00:00 | 105706 | MEC |  |  | 40000 | 2.33
2000-02-01 00:00:00 | 105706 | MEC |  |  | 40000 | 2.58
2000-03-01 00:00:00 | 105706 | MEC |  |  | 40000 | 2.55
2000-04-01 00:00:00 | 105706 | MEC |  |  | 30000 | 2.8
 |  |  |  |  |  |  | NGI-Chicago
1999-11-01 00:00:00 | 105706 | MEC |  |  | -40000 | 3.131
1999-12-01 00:00:00 | 105706 | MEC |  |  | -40000 | 2.2
2000-01-01 00:00:00 | 105706 | MEC |  |  | -40000 | 2.44
2000-02-01 00:00:00 | 105706 | MEC |  |  | -40000 | 2.68
2000-03-01 00:00:00 | 105706 | MEC |  |  | -40000 | 2.53
2000-04-01 00:00:00 | 105706 | MEC |  |  | -30000 | 2.93
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 119059d1314178818-excel-2007-copy-rows-to-new-tab-still-lost
Sheet: Less than 5

name | amount | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
abc | 1 | 112 | 134 | 156 | 178 | 111 | 112
mno | 3 | 12a | 34b | 56c | 78d | 55e | 12f
Spreadsheet: 549995d1512034305-random-numbers-from-specific-range-with-fixed-sum-in-excel-zeszyt2
Sheet: PAPER 2

 |  | MAXIMUM MARKS FOR EACH SECTION
NAME | TOTAL | 4 | 4 | 4 | 4 | 4
STUDENT 1 | 15
STUDENT 2 | 15
STUDENT 3 | 17
 | 0
STUDENT 4 | 15
STUDENT 5 | 20
STUDENT 6 | 20
STUDENT 7 | 18
STUDENT 8 | 20
STUDENT 9 | 15
 | 0
 | 0
STUDENT 10 | 18
 | 0
STUDENT 11 | 15
STUDENT 12 | 15
STUDENT 13 | 15
STUDENT 14 | 15
STUDENT 15 | 16
STUDENT 16 | 19
STUDENT 17 | 19
STUDENT 18 | 20
 | 0
STUDENT 19 | 20
STUDENT 20 | 20
STUDENT 21 | 18
 | 0
STUDENT 22 | 19
STUDENT 23 | 16
STUDENT 24 | 20
STUDENT 25 | 19
STUDENT 26 | 19
Spreadsheet: 703270d1604921239-formula-or-pivot-advice-welcomed-on-how-to-achieve-customer-lifetime-statistics-sample-data
Sheet: Sheet1

ID | Tax date | Date Due | Type | Contact | Details | Order ID | Invoice ref | Currency | Amount | Paid | Cleared
128715 | 2020-05-14 | 2020-05-14 | SI | [NAME] |  | 39970 | SI-36189 | GBP | 44 | 44 | Yes
125425 | 2020-03-31 | 2020-03-31 | SI | [NAME] |  | 39003 | SI-35222 | GBP | 0 |  | Yes
116103 | 2019-12-04 | 2019-12-04 | SI | [NAME] |  | 36074 | SI-32569 | GBP | 53.56 | 53.56 | Yes
110696 | 2019-10-09 | 2019-10-09 | SI | [NAME] |  | 34211 | SI-31005 | GBP | 37.66 | 37.66 | Yes
104807 | 2019-07-23 | 2019-07-23 | SI | [NAME] |  | 32348 | SI-29335 | GBP | 76.36 | 76.36 | Yes
101467 | 2019-06-07 | 2019-06-07 | SI | [NAME] |  | 31388 | SI-28407 | GBP | 4.95 | 4.95 | Yes
96520 | 2019-04-03 | 2019-04-03 | SI | [NAME] |  | 29799 | SI-27019 | GBP | 40.56 | 40.56 | Yes
17074 | 2016-07-15 | 2016-07-15 | SI | [NAME] |  | 4981 | SI-5043 | GBP | 19.96 | 19.96 | Yes
13849 | 2016-06-07 | 2016-07-07 | SI | A. Clarkson Associates |  | 3983 | SI-4217 | GBP | 75.79 | 75.79 | Yes
13833 | 2016-06-07 | 2016-06-07 | SI | A Tyers |  | 3944 | SI-4206 | GBP | 90.48 | 90.48 | Yes
12288 | 2016-05-20 | 2016-05-20 | SI | A Tyers |  | 3496 | SI-3800 | GBP | 75.48 | 75.48 | Yes
6827 | 2016-03-15 | 2016-03-13 | SI | A Tyers |  | 1912 | SI-2433 | GBP | 58.75 | 58.75 | Yes
3690 | 2016-02-02 | 2016-01-31 | SI | A Tyers |  | 918 | SI-1617 | GBP | 68.76 | 68.76 | Yes
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44019

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44019
Number of cores |  | 4
Spare cores |  | 0
Core size |  | 2.5mm2
Cable Type |  | Cu, PVC, SWA
Drawing References
Cable Service |  | CB482 CBF trip to Transpower
Panel Number | T44 PP |  | Panel Number |  | [NAME]
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | [NAME] | INITIAL
1 | 20/ADY441182 |  | TBY5:21 |  | B111
2 | 20/ADY441186 |  | TBY5:22 |  | B113
3 | 20/ADY441185 |  | TBY5:23 |  | B112
4 | 20/ADY441189 |  | TBY5:24 |  | B114
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes
Edition Notes | 2011-08-02 00:00:00 | Was cable 4519 |  |  |  | DJC
 |  | On G6 this cable was 2145, existing cable - renumber
 |  | G4 sheet has this cable as 12 cores
Spreadsheet: 166902d1341842864-if-statement-to-check-multiple-cells-for-value-combinations-book1
Sheet: Sheet1

Available Date | Add Flag | Lead Time | Product |  | Output
2012-01-01 00:00:00 | N | 0 | 5 |  | 2012-01-01 00:00:00 |  | If AvailableDate is not blank and AddFlag = N output AvailableDate
2012-01-01 00:00:00 | y | 1 | 0 |  | 2012-01-02 00:00:00 |  | If AvailableDate is not blank and AddFlag =  Y, output calculated date (AvailableDate + LeadTimeDays)
? | n | 15 | 5 |  | 15 |  | If AvailableDate is blank and AddFlag = N output LeadTimeEstimate (number of days)
? | y | 5 | 15 |  | 20 |  | If AvailableDate is blank and AddFlag = Y output calculated number of days (LeadTimeEstimate + LeadTimeEstimate for Product)
Spreadsheet: 889997d1741103189-help-with-conditional-formatting-for-inspection-rp_iprp
Sheet: In-Process

 | Customer Name:
 | Part Name:
 | Customer Part#:
 | Revision:
 | Tool#
 | Material
 | Notify Supervisor if cells turn red after data entry
 | Dimension and Visual |  |  |  |  |  |  |  |  |  |  |  | Inspection Method |  | Notes: Production/ [NAME]
 | Inspection Method |  |  |  |  |  |  |  |  |  |  |  |  |  | If applicable enter notes or approval sign-off on dimensions/visuals
 | No | Date | Time | Operator | Lot Number
 |  |  |  |  |  |  |  |  |  | 3.7 | 3.7 | 3.7
 |  |  |  |  |  |  |  |  |  | 3.5 | 3.5 | 3.5
Spreadsheet: 844616d1696380645-assistance-in-updating-formula-showing-value-error-book2-excel-365-
Sheet: cashmeresyrups.com.au (3)

 |  |  |  | FORMULA USED FOR CALCULATIONS IN TABLE (ABOVE- excluding Row 20)
 |  |  |  | (COLUMN F) = UNIT PRICE = 1 ITEM
 |  |  |  | (COLUMN H) = TOTAL (inc GST)  =SUM(UNIT PRICE, GST)
 |  |  |  | (COLUMN H = SUM(COLUMN F, COLUMN G) multiplied by COLUMN A) =SUM(UNIT PRICE, GST)*QANTITY
 |  |  |  | (COLUMN H) = TOTAL AMOUNT PAYABLE
Spreadsheet: 76406d1276900487-needed-a-search-function-that-allows-for-some-variability-quick-example
Sheet: Sheet1

List 1 |  |  | List 2 |  |  | unique to list 1 |  | overlap |  | unique to list 2
[NAME] | 234 |  | IPI58473891 | 67 |  | IPI57342848 | 5 | [NAME] | 234 | [NAME] | 99
IPI57342848 | 5 |  | [NAME] | 232 |  | IPI33889943 | 10 | [NAME] | 232 | IPI58473891 | 67
IPI57489329 | 4000 |  | [NAME] | 230 |  | IPI66698032 | 333 | [NAME] | 230 | IPI33889943 | 26
IPI66698032 | 333 |  | [NAME] | 99 |  | IPI57489329 | 4000 | IPI57342848 | 5
IPI33889943 | 10 |  | IPI33889943 | 26 |  |  |  | IPI57342848 | 10
IPI11223344 | 31 |  | IPI57342848 | 10 |  |  |  | IPI11223344 | 31
 |  |  | IPI11223344 | 31
Spreadsheet: 701615d1603850565-sumifs-without-a-matching-criteria-book2
Sheet: Sheet2

 |  |  |  |  |  |  | [NAME] |  |  |  | Title 1 | Title 2 | Title 3 | Amount
 |  |  |  | YES |  |  |  |  |  |  | NO | NO | Yes | 1
 |  |  |  |  |  |  |  |  |  |  | NO | NO | Yes | 2
 |  |  |  |  |  |  |  |  |  |  | NO | NO | Yes | 3
 |  |  |  |  |  |  |  |  |  |  | NO | YES | Yes | 4
 |  |  |  |  |  |  |  |  |  |  | NO | YES | Yes | 5
 |  |  |  |  |  |  |  |  |  |  | NO | YES | NO | 6
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 7
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 8
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 9
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 10
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 11
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 12
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 13
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 14
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 15
 |  |  |  |  |  |  |  |  |  |  | NO | NO | NO | 16
Spreadsheet: 368141d1420303714-saving-as-tab-delimited-question-pq-1
Sheet: P2

Block Line# | Input path | BLOCK | Output path | Comment
"
1 | [C1_ACM2_Bit1] | _AND_ | [LVAR_C1L1_OV1] | <AND Lmts12>
1 | [C4_ACM1_Bit2] | ;
2 | [LVAR_C1L1_OV1] | _OR_ | [C1_ACM1_Bit1] | <Turn on Fan when lmt1&2 or 3 is on>
2 | [C4_ACM1_Bit3] | ;
3 | [LVAR_C1L2_OV1] | _BUF_ | [C1_ACM1_Bit2] | <Buz>
 |  | ;
4 |  | _OREG_ | [C1L1_OptLap]_[NONE] | <Options>
 |  | ;
"
Spreadsheet: 288e4882-eab3-434c-85b0-dd327942d908
Sheet: Todo (6)

 | TO DO LIST
 | Name : | [NAME] 6
 | Progress
 | No | To Do | Status
 | 1 | To Do 1 | Done
 | 2 | To Do 2 | Done
 | 3 | To Do 3 | Done
 | 4 | To Do 4 | Done
 | 5 | To Do 5
 | 6 | To Do 6
 | 7 | To Do 7
 | 8 | To Do 8
 | 9 | To Do 9
 | 10 | To Do 10
 | 11 | To Do 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 25500d1216828366-count-unused-cells-in-a-used-range-countblanks
Sheet: Sheet1

1 |  | counta | 20
2 |  | countblank | 65516 | <= I want this number to be 3, because there are three blank cells in my data range
3
4
5 |  | I want to protect the range A1:A23, since that is the range with information in it
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 484989d1476636565-fill-the-form-in-sheet3-using-data-from-sheet1-school-report
Sheet: اليحر

 |  | [NAME]
 |  | [NAME] : | العين |  |  | [NAME] : | 1243
 |  | المحطـة : | [NAME] |  |  | الحلقـــــــــــــــة : | رياض أطفال
 |  | المدرسة : | روضة اليحر |  |  | الرقم التسلسلي :
 | م | [NAME] | حجم الحافلة (عدد الركاب) | عدد الطلبة المنقولين | اسم السائق |  | عدد أيام الغياب (بدون توفير بديل)
 | 1 | [NAME] | 23 | 12 | داود خان محمد ايوب خان
 | 2 | [NAME] | 61 | 54 | دوست علي رئيس خان
 | 5 | B0027339 | 34 | 19 | راشد علي محمود
 | 3 | B0026280 | 36 | 31 | رحمن الدين جمال الدين
 | 4 | B0004331 | 23 | 21 | رهان خان خان ملوك
 | 6 | B0021357 | 60 | 42 | ضياء الرحمن جول جاهان
 | 7 | B0009700 | 23 | 20 | عبدالمجيد فارامبانا لوكال
 | 10 | B0009408 | 61 | 38 | محمد الياس محمد يوسف
 | 8 | B0017487 | 61 | 50 | محمد زمان كريم خان
 | 9 | B0009414 | 61 | 41 | محمد سليم
 | الاجمالي
 | [NAME] المحطة |  |  |  |  |  | [NAME]
 | ............................. |  |  |  |  |  | .................................
 | ملخص شهادات انجاز خدمة النقل المدرسي ( للمدرسة )
 |  | [NAME] : |  |  |  | [NAME] :
 |  | المحطـــة : |  |  |  | الحلقـــــــــــــــــة :
 |  | المدرسـة : |  |  |  | [NAME] :
 |  |  |  |  |  | الوظيفة :
 | أولا:- الحافلات المدرسية
 | بيانات الحافلات المدرسية
 | م | البند |  |  | خط فردي | خط زوجي | الاجمالي
 | 1 | حافلة كبيرة |  |  | 2 | 3
 | 2 | حافلة صغيرة |  |  | 5 | 0
 | الاجمالي
 | [NAME] خدمة النقل المدرسي (من قبل المدرسة)
 | [NAME] خدمة النقل المدرسي
 | م
 | 1
 | 2
 | 3
 | 4
 | ثالثا:-  معالجة  الملاحظات  ( من قبل المحطة )
 | معالجة الملاحظات من قبل المحطة [NAME] خدمة النقل المدرسي
 | م
 | 1
 | 2
 | 3
 | 4
 | [NAME] المحطة |  |  |  |  | [NAME]
 | ............................. |  |  |  |  | .................................