tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 835960d1689000147-finding-the-price-from-newest-date-to-oldest-with-n-data-example
Sheet: Sheet1

SKU | Price | PO date |  |  | Result: |  | Price 1 | Price 2 | Price 3
A | 34.242424 | 2015-12-18 00:00:00 |  |  |  | A | 38.06666666666667 | 34.242424 | 37.86666666666667
A | 38.06666666666667 | 2017-07-18 00:00:00 |  |  |  | B | 38.84848486666667 | 39.51515153333334
A | 37.86666666666667 | 2015-09-30 00:00:00 |  |  |  | C | 34.84848466666667 | 34.84848484666666 | 35
A | 38.53333333333333 | 2015-04-14 00:00:00 |  |  |  | D | 35.75757575333333
A | 39.86666666666667 | 2015-01-15 00:00:00 |  |  |  | E | 37.87878787333334 | 37.87878854 | 38
B | 39.51515153333334 | 2016-03-31 00:00:00
B | 38.84848486666667 | 2016-04-16 00:00:00 |  |  | [NAME]:
C | 34.84848466666667 | 2016-02-11 00:00:00 |  |  |  |  | Price 1 | Price 2 | Price 3
C | 34.84848484666666 | 2016-01-20 00:00:00 |  |  |  | A |  | 34.242424 | 37.86666666666667
C | 35 | 2015-12-16 00:00:00 |  |  |  | B |  | 39.51515153333334
D | 35.75757575333333 | 2015-11-14 00:00:00 |  |  |  | C |  | 34.84848484666666 | 35
E | 38 | 2015-02-24 00:00:00 |  |  |  | D
E | 38 | 2015-04-07 00:00:00 |  |  |  | E |  | 37.87878854 | 38
E | 38 | 2015-06-17 00:00:00
E | 38 | 2015-07-09 00:00:00
E | 38 | 2015-08-25 00:00:00 |  |  | Price 1 | Price with newest date
E | 37.87878854 | 2015-09-17 00:00:00 |  |  | Price 2 | Price with 2nd newest date
E | 37.87878787333334 | 2015-10-17 00:00:00 |  |  | Price 3 | Price with 3rd newest date
Spreadsheet: 88155d1288074160-excel-2010-conditional-formatting-across-mulitpe-colums-copy-of-patch
Sheet: Sheet2

DEVICE | PORTS |  | DeviceRow | PortRow
EDGE1 | 1
R2C2-PPA | 1/01
R2C2-PPB | 1/02
R2C2-PPC | 1/03
EDGE2 | 1/04
BCC-RR1 | 1/05
R5C4-PPA | 1/06
CISCO-DWDM-BCT-BCC | 1/07
R1C4-PPA | 1/08
BDC-NOC-ASA | 1/09
R1C0-NORTEL SWITCH | 1/10
R2C3-PPY | 1/11
BCT-SW1 | 1/12
BDC-NOC-SW1 | 1/13
R1C2-PPB | 1/14
BCC-PIPN1 | 1/15
 | 1/16
 | 1/17
 | 1/18
 | 1/19
 | 1/20
 | 1/21
 | 1/22
 | 1/23
 | 1/24
 | 1/25
 | 1/26
 | 1/27
 | 1/28
 | 1/29
 | 1/30
 | 1/31
 | 1/32
 | 1/33
 | 1/34
 | 1/35
 | 1/36
 | 1/37
 | 1/38
 | 1/39
 | 1/40
 | 1/41
 | 1/42
 | 1/43
 | 1/44
 | 1/45
 | 1/46
 | 1/47
 | 1/48
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 2
 | 2/01
 | 2/02
 | 2/03
 | 2/04
 | 2/05
 | 2/06
 | 2/07
 | 2/08
 | 2/09
 | 2/10
 | 2/11
 | 2/12
 | 2/13
 | 2/14
 | 2/15
 | 2/16
 | 2/17
 | 2/18
 | 2/19
 | 2/20
 | 2/21
 | 2/22
 | 2/23
 | 2/24
 | 2/25
 | 2/26
 | 2/27
 | 2/28
 | 2/29
 | 2/30
 | 2/31
 | 2/32
 | 2/33
 | 2/34
 | 2/35
 | 2/36
 | 2/37
 | 2/38
 | 2/39
 | 2/40
 | 2/41
 | 2/42
 | 2/43
 | 2/44
 | 2/45
 | 2/46
 | 2/47
 | 2/48
 | 20
 | 21
 | 22
 | 23
 | 24
 | 3
 | 3/01
 | 3/02
 | 3/03
 | 3/04
 | 3/05
 | 3/06
 | 3/07
 | 3/08
 | 3/09
 | 3/10
 | 3/11
 | 3/12
 | 3/13
 | 3/14
 | 3/15
 | 3/16
 | 3/17
 | 3/18
 | 3/19
 | 3/20
 | 3/21
 | 3/22
 | 3/23
 | 3/24
 | 3/25
 | 3/26
 | 3/27
 | 3/28
 | 3/29
 | 3/30
 | 3/31
 | 3/32
 | 3/33
 | 3/34
 | 3/35
 | 3/36
 | 3/37
 | 3/38
 | 3/39
 | 3/40
 | 3/41
 | 3/42
 | 3/43
 | 3/44
 | 3/45
 | 3/46
 | 3/47
 | 3/48
 | 4
 | 5
 | 6
 | 6/1
 | 6/2
 | 7
 | 8
 | 9
 | SL17-UC
 | SL8-UC
 | GE0/1
Spreadsheet: 288645d1389266646-formula-correction-sales-2013-2014-kym-edit
Sheet: Overview

 |  |  | Overview Of Year Sales 2013/2014
 |  | Total Net To Date |  |  | Monies Owed To Date
 |  | Total VAT To Date |  |  | Avarage Sales (Net) Per Month
 |  | Total Gross To Date |  |  | Bad Debt to Date
 |  | Total Paid To Date
 |  | Sales (Net) To Date Yearly
 |  | Company Totals (Net) |  | Percentage Of Yearly Sales (Net) % |  |  | April | May | June | July | August | September | October | November | December | January | February | March
 |  | Client 1
 |  | Client 2
 |  | Client 3
 |  | Client 4
 |  | Client 5
 |  | Client 6
 |  | Client 7
 |  | Client 8
 |  | Client 9
 |  | Client 10
 |  | Client 11
 |  | Client 12
 |  | Client 12
 |  | Client 13
 |  | Client 14
 |  | Client 15
 |  | Client 16
 |  | Client 17
 |  | Client 18
 |  | Client 19
 |  | Client 20
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 21
 |  | Client 22
 |  | Client 23
 |  | Client 24
 |  | Client 25
 |  | Client 26
 |  | Client 27
Spreadsheet: 102522d1300450490-sumproduct-and-iserror-daily-backlog-reasons
Sheet: Analysis

Date | Work Centre | On Pick | 50 - Partial | 45 - Open | 30 - Awaiting Kitting | 20 - Shortage Manufacturing | 20 - Shortage Supply Chain | 20 - Shortage VMI | JDE System | Capacity | Short Dated Order
2011-03-15 00:00:00 | 3788VA15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 86078530-d5bf-4a3b-adf1-3156ba751528
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflowerseed | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 | Cents/pound
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/12 | 51.9 | 53.22 | 83.2 | 57.19 | 100.15 | 56.09 | 48.11 | 50.33
2012/13 | 47.13 | 48.6 | 65.87 | 56.17 | 91.83 | 46.66 | 39.64 | 43.24
2013/141 | 39 | 65 | 58 | 44.5 | 68 | 40 | 42.5 | 40
2014/151 | 37.0-41.0 | 44.0-48.0 | 59.0-63.0 | 42.0-46.0 | 70.0-74.0 | 41.5-43.5 | 39.0-43.0 | 35.0-39.0
2012/13
October | 49.31 | 51.31 | 74 | 57.5 | 103 | 54.75 | 51.6 | 42.27
November | 46.27 | 49.05 | 70.3 | 58.2 | 99.9 | 51.93 | 57 | 37.15
December | 47.16 | 50.06 | 67.5 | 57.13 | 98.56 | 50.63 |  | 40.92
January | 48.85 | 50.94 | 65.25 | 57.19 | 96.75 | 52.06 | 52.45 | 43.5
February | 49.33 | 51.56 | 65 | 59.38 | 86 | 51.71 | 45.56 | 41.93
March | 48.62 | 50.2 | 64.6 | 58.95 | 79.05 | 47.76 |  | 45
April | 49.28 | 49.94 | 64 | 60.44 | 77.5 | 47.06 | 43.5 | 43.5
May | 49.31 | 49.75 | 64 | 60.45 | 80 | 45.23 | 44.5 | 43.86
June | 47.84 | 48.25 | 64 | 57.5 | 82.75 | 42.5 | 48.5 | 48.44
July | 45.19 | 46.19 | 64 | 53.25 | 84 | 38.91 | 53.25 | 49.13
August | 42.33 | 43.1 | 64 | 48.05 | 83 | 38.93 | 56.89 | 43.18
September | 42.12 | 42.81 | 63.75 | 46 | 82 | 38.46 | 64.78 | 40.02
2013/14
October | 39.66 | 41.19 | 60.5 | 44.88 | 81 | 37.85 | 43 | 33.17
November | 39.58 | 42.05 | 57.4 | 45.05 | 78.7 | 38.79 | 48 | 38.88
December | 37.63 | 43.19 | 57 | 42.63 | 75.38 | 38.31 | 41.5 | 39.62
January | 34.95 | 47.1 | 57 | 39.75 | 65.7 | 38.79 | 33 | 35.84
February | 37.11 | 57.81 | 57 | 42.56 | 62.06 | 41.07 | 38 | 35.67
March | 40.82 | 69.94 | 58 | 45.75 | 59.06 | 43.19 | 40.67 | 41.63
April | 41.87 | 75 | 59 | 47.63 | 57.75 | 41.94 | 53 | 45.5
May1 | 40.68 | 84.25 | 59 | 47.5 | 57.2 | 41.02 |  | 47
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
NA = Not available.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2014-06-13 08:22:44.550000
Spreadsheet: 157248d1337682596-excel-2007-applying-a-value-to-a-row-book1
Sheet: Sheet1

 | Score | 1 | 1 | 2 | 1 | 3
 |  | Supplier 1 | Supplier 2 | Supplier 1 | Supplier 2 | Supplier 3 |  | Total | Score
 |  | Supplier 3 | Supplier 5 | Supplier 2 |  | Supplier 4 |  | Supplier 1 | 3
 |  | Supplier 5 |  | Supplier 3 |  |  |  | Supplier 2 | 4
 |  |  |  | Supplier 4 |  |  |  | Supplier 3 | 6
 |  |  |  |  |  |  |  | Supplier 4 | 5
 |  |  |  |  |  |  |  | Supplier 5 | 2
Spreadsheet: 757141d1638043163-income-tax-calculation-formula-income-tax-calculation-formula-tms
Sheet: Sheet1

Income Tax Calculator (2021)
Areas | Rates | Fixed Amount | Fixed Amount For | Rate Calculation 1 | Rate Calculation 2 | Total |  |  | Income | 2500000
24000 | 15 | 0 | 0
53000 | 20 | 3600 | 24000 |  |  |  |  |  | Income Tax
190000 | 27 | 9400 | 53000
650000 | 35 | 30190 | 130000
more than 650000 | 40 | 212190 | 65000
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: PG&E

56698
Day | Scheduled | Measured
1 | 199560 | 201126
2 | 147248 | 148629
3 | 192955 | 194271
4 | 192652 | 193485
5 | 169009 | 165596
6 | 114940 | 116973
7 | 160759 | 162355
8 | 98370 | 98207
9 | 62643 | 63670
10 | 91985 | 93377
11 | 102048 | 103020
12 | 66395 | 66527
13 | 82203 | 82687
14 | 24040 | 26899
15 | 89433 | 90967
16 | 74986 | 75328
17 | 55046 | 56156
18 | 58054 | 58951
19 | 141458 | 117983
20 | 67088 | 71618
21 | 89187 | 89692
22 | 109277 | 110124
23 | 125238 | 117326
24 | 72075 | 74353
25 | 77339 | 77870
26 | 103220 | 103694
27 | 145252 | 145564
28
29
30
31
2001-05-31 00:00:00 |  |  | -10045
2001-06-27 00:00:00
Spreadsheet: 733103d1621395599-formula-to-get-the-max-record-with-condition-book1
Sheet: Data

 | Category | Quarter | 2021 | Past Highest Record
 | A | 1Q
 | B | 1Q
 | C | 1Q
 | D | 1Q |  |  |  | Is there any formula to get this result without using the pivot table below?
 | E | 1Q
 | F | 1Q
 | G | 1Q
 | H | 1Q
 | Category | Month | 2021 | Past Highest Record
 | A | 3
 | B | 3
 | C | 3
 | D | 3
 | E | 3
 | F | 3
 | G | 3
 | H | 3
 | Sales Fiscal Quarter | 1Q
 | Sum of Sales | Column Labels
 | Row Labels | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | Grand Total
 | A | 102500 | 58400 | 62000 | 57000 | 69300 | 69400 | 76700 | 90300 | 92900 | 75800 | 60600 | 76200 | 891100
 | B | 12500 | 7300 | 12900 | 13400 | 12900 | 10300 | 16900 | 19000 | 21000 | 24400 | 21300 | 18900 | 190800
 | C | 26300 | 20600 | 30400 | 51400 | 34600 | 58800 | 45900 | 79600 | 61000 | 55000 | 69500 | 52800 | 585900
 | D | 30600 | 17900 | 10800 | 23600 | 16700 | 30300 | 17800 | 36600 | 33400 | 35600 | 39700 | 66300 | 359300
 | E | 7400 | 11500 | 9500 | 18500 | 20500 | 26200 | 14800 | 46000 | 43000 | 31100 | 22800 | 25600 | 276900
 | F | 20100 | 10600 | 18400 | 16500 | 39500 | 24900 | 36700 | 72900 | 96600 | 74900 | 72800 | 91100 | 575000
 | G | 4500 | 7100 | 4700 | 4500 | 4100 | 11200 | 21300 | 33100 | 50000 | 38900 | 25500 | 25500 | 230400
 | H | 0 | 200 | 0 | 200 | 1800 | 6300 | 6200 | 14100 | 20900 | 1200 | 12300 | 3600 | 66800
 | I | 6100 | 2600 | 4400 | 6500 | 10300 | 16700 | 16400 | 28500 | 32700 | 39700 | 12600 | 14200 | 190700
 | Grand Total | 210000 | 136200 | 153100 | 191600 | 209700 | 254100 | 252700 | 420100 | 451500 | 376600 | 337100 | 374200 | 3366900
 | Sales Month | 3
 | Sum of Sales | Column Labels
 | Row Labels | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | Grand Total
 | A | 30800 | 20300 | 21200 | 16800 | 19100 | 25200 | 25300 | 32900 | 35700 | 29800 | 23400 | 43000 | 323500
 | B | 5000 | 2900 | 4100 | 4800 | 4900 | 4100 | 3800 | 7500 | 7300 | 8100 | 8700 | 8700 | 69900
 | C | 7900 | 7200 | 11900 | 9300 | 10600 | 24500 | 13900 | 32000 | 18500 | 16900 | 29000 | 25800 | 207500
 | D | 10200 | 3800 | 5800 | 5600 | 4100 | 8400 | 7600 | 14600 | 12200 | 11500 | 11000 | 32300 | 127100
 | E | 1400 | 5800 | 2400 | 4700 | 8000 | 13900 | 2700 | 20100 | 12600 | 11900 | 7900 | 16500 | 107900
 | F | 6600 | 3500 | 2900 | 3900 | 10200 | 9500 | 12700 | 18200 | 27300 | 31100 | 29400 | 50200 | 205500
 | G |  | 4300 | 1500 |  | 2300 | 6300 | 3800 | 9600 | 22100 | 13800 | 2000 | 12200 | 77900
 | H | 0 | 100 | 0 | 100 | 1700 | 0 | 3900 | 0 | 8200 | 0 | 5500 | 3500 | 23000
 | I | 2300 | 400 | 2200 | 1700 | 2700 | 15200 | 6000 | 13400 | 17000 | 17000 | 7700 | 2500 | 88100
 | Grand Total | 64200 | 48300 | 52000 | 46900 | 63600 | 107100 | 79700 | 148300 | 160900 | 140100 | 124600 | 194700 | 1230400
Spreadsheet: 717176d1612521806-return-all-matches-between-two-arrays-array-match-sample
Sheet: Sheet1

 | This is an example of how the data is listed although not in adjacent columns
 | Order No | SKU | Coat |  |  |  | Cat1 SKU's |  | Order No | SKU 1 | SKU 2
 | 45609 | G99 | SU |  |  |  | WEN
 | 45609 | COS | SU |  |  |  | PI |  | 24898
 | 45609 | G99 | SU |  |  |  | DABI |  | 76785
 | 45609 | COH | SU |  |  |  | M2VP |  | 48076
 | 24898 | 981 | HT |  |  |  | M2OP
 | 24898 | 400 | HT |  |  |  | [NAME]
 | 24898 | M2VP | HT |  |  |  | WENB2
 | 76785 | 981 | OX |  |  |  | COS |  |  |  |  |  |  |  | This would be a great result
 | 76785 | [NAME] | OX |  |  |  | COH |  |  |  |  |  |  |  | Order No | SKU1 | SKU2
 | 76785 | 981 | OX |  |  |  |  |  |  |  |  |  |  |  |  | COS | COH
 | 76785 | [NAME] | OX |  |  |  |  |  |  |  |  |  |  |  | 24898 | M2VP | -
 | 76785 | 669 | OX |  |  |  |  |  |  |  |  |  |  |  | 76785 | [NAME] | [NAME]
 | 48076 | PI | BU |  |  |  |  |  |  |  |  |  |  |  | 48076 | PI | PI
 | 48076 | G99 | BU
 | 48076 | PI | BU
 | 48076 | G99 | BU
Spreadsheet: 48291d1247526390-using-dget-in-a-table-dgettest
Sheet: Sheet1

XYZ | ABC
1 | dog
2 | cat
3 | [NAME] |  |  |  | XYZ | Result
4 | fat |  |  |  | 1
5 | house |  |  |  | 2
6 | freak |  |  |  | 3
7 | show |  |  |  | 4
8 | pizza
9 | ham
10 | burger
11 | cheese
12 | red
13 | sox
14 | base
15 | ball
16 | fall
17 | stall
18 | mall
19 | kill
20 | bill
Spreadsheet: 674416d1587829946-if-formula-closing-bracket-is-a-issue-for-me-taxation-format-fy2020-2021
Sheet: TaxSheet

Employee Details |  |  |  |  |  | 2020-03-31 00:00:00 |  | Allowances exempt u/s 10(for Service Period) |  |  |  |  |  | Add: Any other income from other sources |  |  |  |  | Less: Exemption on Home Loan Interest (Sec 24) |  |  |  | Less: Deduction under [NAME] ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Less: Deduction under chapter VI A |  |  |  |  |  |  |  |  | Addition Exemption |  |  |  | Tax Calculation
Emp ID | Emp Name | Gender | PAN | DOB | DOJ | Age | Gross Annual Income | H.R.A. exemption | Standard Deduction | Professional Tax | CEA | LTA | Income under the head salaries | Bank ( Saving /FD /Rec ) | N.S.C.(accrued/ Recd ) | Post Ofice M.I.S (6 yrs.) | Post Office Recring Deposit (5 yrs.) | Any Other Income | Loss from house property (Section 24) | Additional tax exemption for First Time Home Buyers (Budget 2016) | Interest paid on Home Improvement Loan ([NAME] 30,000) | Gross Total Income | EPF & VPF' | PPF | SCSS | N.S.C | FD (5 Years and above) | Tax Saving Bond | ELLS | LIC | I. New Pension Scheme (NPS) (u/s 80CCC) | Pension Plans/Mutual Fund | HL - PRINCIPLE | Stamp Duty & Registration Charges | SSA | TUTION FEES | 80CCD9(1) NPS | 80 C Total Deduction | 80 D | 80 D -For Parents | 80 E | 80DD | 80DDB | 80G | 80GG | 80U | 80TTA | 80CCD(2) NPS | 80EEA (Interest on Home Loan for Affordable Home) (Budget 2019) | Sec 80EEB (Interest on Auto Loan for Electronic Vehicle) (Budget 2019) | Total Income | Tax Rebate | Total Income After [NAME] | Total Tax Payable @ Old Regime | Total Tax Payable @ New Regime | Tax Surcharge | Edn Cess | Net Tax Payable | Tax Deducted Til Date | Tax Remianing to be Paid | Per Month Tax Deduction
AR1001 | AUGUSTIN RAJ A | MALE | AJUPA5100C | 1987-02-01 00:00:00 | 2019-03-29 00:00:00 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =ROUND(IF(((TODAY()-E3)/365)<60,IF(BB3<=250000,0,IF(BB3<=500000,((BB3-250000)*5%),IF(BB3<=750000,((BB3-500000)*10%+12500),IF(BB3<=1000000,((BB3-750000)*20%+37500),IF(BB3<=1250000,((BB3-1000000)*25%+75000),IF(BB3<=1500000,((BB3-1250000)*30%+125000),((BB3-1
AR1002 | RAJ A | MALE | AJUPA5100C | 1958-02-01 00:00:00 | 2019-03-29 00:00:00 |  |  |  |  |  |  | 0
AR1003 | AUGUSTIN | MALE | AJUPA5100C | 1939-02-01 00:00:00 | 2019-03-29 00:00:00 |  |  |  |  |  |  | 0
Spreadsheet: 886664d1736762232-multiple-coulmns-to-be-auto-generated-based-on-permutation-dataset
Sheet: Sheet1

 |  | Dataset
 |  | A | Ignore | 1001 | 1002 | Ignore | 1003
 |  | B | Ignore | 2001 | 2002 | Ignore | Ignore
 |  | ID | Subject 1 | Subject 2 | Subject 3 | Subject 5 | Subject 6
 |  | 1 | 100 | 200 | 300 | 800 | 900
 |  | 2
 |  | 3
 |  | 4
 |  | Desired output
 |  | A &B | ID | Amount | Amount |  | A &B | ID | Amount | Amount
 |  | 1001 | 1
 |  | 1001 | 2
 |  | 1001 | 3
 |  | 1001 | 4
 |  | 1002 | 1
 |  | 1002 | 2
 |  | 1002 | 3
 |  | 1002 | 4
 |  | 1003 | 1
 |  | 1003 | 2
 |  | 1003 | 3
 |  | 1003 | 4
 |  | 2001 | 1 |  | 200
 |  | 2001 | 2 |  | 201
 |  | 2001 | 3 |  | 202
 |  | 2001 | 4 |  | 203
 |  | 2002 | 1 |  | 300
 |  | 2002 | 2
 |  | 2002 | 3
 |  | 2002 | 4
Spreadsheet: 140619d1328821171-inventory-yfeb-food-total-values
Sheet: 2-11-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 24791a1c-1a8c-4e87-bdd1-a44026ded102
Sheet: 8. Szkodowość

Załącznik nr 8 do opisu przedmiotu zamówienia
Szkodowść 2009-2012
2009
rodzaj ubezpieczenia | ilość szkód | wysokość wypłaconych odszkodowań
ogień i inne zdarzenia losowe | 14 | 23548.93
715 - mienie od wszystkich ryzk  - ryzyka naturalne | 26 | 63637.31
716 - mienie od wszystkich ryzk  - kradzieź | 10 | 3719.31
NNW | 7 | 3400
AC | 3 | 1717.94
OC ogólne | 250 | 170894.12
 | łącznie 2009
2010
rodzaj ubezpieczenia | ilość szkód | wysokość wypłaconych odszkodowań | rezerwy
elektronika | 1 | 3815.64
ogień i inne zdarzenia losowe | 11 | 22877.19
715 - mienie od wszystkich ryzk  - ryzyka naturalne | 31 | 77118.86
NNW | 7 | 4100
AC | 5 | 6933.61
OC komunikacyjne | 8 | 8240.59
OC ogólne | 198 | 108295.4 | 3739.85
 | łącznie 2010
2011 do 15.10
rodzaj ubezpieczenia | ilość szkód | wysokość wypłaconych odszkodowań | rezerwy
elektronika | 11 | 24971.5 | 11791.65
ogień i inne zdarzenia losowe | 7 | 8617.5 | 9046
715 - mienie od wszystkich ryzk  - ryzyka naturalne | 45 | 76664.36 | 3159
716 - mienie od wszystkich ryzk  - kradzież | 1 | 0 | 1079
714 - maszyny i urządzenia od awarii | 4 | 0 | 25375.05
NNW | 6 | 4400
AC | 5 | 7775.72 | 3079
OC komunikacyjne | 2 | 2736.51
OC ogólne | 111 | 24197.97 | 23522.5
 | łącznie 2011
2012 do 17.09
rodzaj ubezpieczenia | ilość szkód | wysokość wypłaconych odszkodowań | rezerwy
mienie od wszystkich ryzyk | 22 | 61870.38 | 13200
NNW | 3 | 800
OC ogólne | 18 | 41163.51 | 7279.97
AC komunikacyjne | 1 | 599.47
 | łącznie 2012
Spreadsheet: 795046d1662477920-help-with-formula-and-function-absence-tracker-hslt-absence-tracker-klhc-
Sheet: Employee Leave Tracker

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for sickness | Reason For Leave of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month | Column1 | Column2
 | Employee 1 | 2021-12-22 00:00:00 | 2021-12-30 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Leave of Absence Paid |  | International Sport Selection
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Leave of Absence Unpaid |  | Degree ceremony/wedding
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-22 00:00:00 | Sickness Absence | Chest & Respiratory
Spreadsheet: 56398d1256594732-dynamic-find-and-divide-example-data
Sheet: Sheet1

 |  | False | True | True | False | False | True | True | True
 |  | Total 1 | Subtotal 1 | Subtotal 2 | Total 2 | Total 3 | Subtotal 1 | Subtotal 2 | Subtotal 3
 | USA | 10 | 5 | 5 | 12 | 19 | 5 | 5 | 9
 | Japan | 15 | 6 | 9 | 11 | 22 | 11 | 8 | 3
 | Mexico | 5 | 4 | 1 | 8 | 13 | 3 | 6 | 4
 | USA
 | Japan
 | Mexico
Spreadsheet: 217359d1362052773-evenly-amortise-value-over-financial-year-months-cashflowpere
Sheet: assumptions

 | Income | FY14 | FY15
 | Committed
 | Forecast
 |  | 100000000 | 125000000
 |  | FY14 | FY15
 | Target Gross Margin | 0.25 | 0.25
 |  | FY14 | FY15
 | PC | 0.15 | 0.1
 | Hire Fees | 0.25 | 0.2
 | Labour | 0.3 | 0.4
 | Materials | 0.3 | 0.3
Spreadsheet: darrell_schoolcraft__7762__imbalsumm0106
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -12949
3531 |  | -169301
60667
60749 |  | -186868
61206
61334 | -54539
62960
INDEX
2001-05-31 00:00:00 |  |  | 1177095.58
2001-06-11 00:00:00
Spreadsheet: 99990770-e1f5-4e0b-9c36-2735d057ecde
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
NMDCS | Test | NMDCS | NMDA-Receptor Antibody by CBA, Serum | NMDA-R Ab CBA, Serum | Cell-binding assay (CBA) detects IgG specific for NMDA-R (N-Methyl-D-aspartate receptor) by indirect immunofluorescence (IFA) | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Additional Information: Include relevant clinical information, name, phone number, mailing address, and E-mail address (if applicable) of ordering physician | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild reject; Gross reject Other	NA | Negative | Wednesday, Friday; 8 a.m. | Negative: 2-4 days; Positive: 5-7 days | 6 days | 1 | 86255 |  |  |  |  | Rochester
NMDCS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
NMDCS | Result | 61516 | NMDA-R Ab CBA, Serum | NMDA-R Ab CBA, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process