tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 183857d1349073544-freeze-half-the-page-verticaly-help1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Risked | Made | Lost
1
2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NBA |  |  |  | NFL |  |  |  | CFB |  |  |  | WNBA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | W | L | T | % | W | L | T | % | W | L | T | % | W | L | T | %
 |  |  |  |  |  |  |  |  |  |  |  |  | Underdog
 |  |  |  |  |  |  |  |  |  |  |  |  | Chosen
 |  |  |  |  |  |  |  |  |  |  |  |  | Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Away
 |  |  |  |  |  |  |  |  |  |  |  |  | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  | Money ln
 |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | ALL
 |  |  |  |  |  |  |  |  |  |  |  |  | Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Away
 |  |  |  |  |  |  |  |  |  |  |  |  | W/L
98
99
100
Spreadsheet: michelle_cash__26486__DC XMS Recap-Final TW 8-24
Sheet: Summary

DIOMEDES CHRISTODOULOU
EXPENSE REPORT RECAP
1998 - 2001
 |  |  |  | Per Sheet 1 | Tie Out Amts | Diff
Paid [NAME] in US $
Paid [NAME] in Reais
Personal Due Company in US $
Personal Due Company in Reais
Missing Receipts in US $
Missing Receipts in Reais
Missing Airline Ticket Receipts in US $
Missing Airline Ticket Receipts in Reais
Personal Meals in US $
Personal Meals in Reais
[NAME] in or < $75 in US $
[NAME] in or < $75 in Reais
Spreadsheet: 785597d1656509351-problem-with-sumifs-formula-sample
Sheet: Summary

 | Descriptions | T1 |  |  |  |  | N1 |  |  |  |  | O1 |  |  |  |  | T2 |  |  |  |  | T3
 |  | Tidel-5th | Tidel-5th | Tidel-5th | Tidel-5th | Tidel-5th | Tidel-8th | Tidel-8th | Tidel-8th | Tidel-8th | Tidel-8th | Elnet | Elnet | Elnet | Elnet | Elnet | NMR | NMR | NMR | NMR | NMR | Vel-1 | Vel-1 | Vel-1 | Vel-1 | Vel-1
 |  | Apr'22 | May'22 | Jun'22 | Jul'22 | [NAME] | Apr'22 | May'22 | Jun'22 | Jul'22 | [NAME] | Apr'22 | May'22 | Jun'22 | Jul'22 | [NAME] | Apr'22 | May'22 | Jun'22 | Jul'22 | [NAME] | Apr'22 | May'22 | Jun'22 | Jul'22 | [NAME]
 | Summary_1
 | [NAME]
Spreadsheet: 837612d1690289100-conditional-formatting-formula-help-required-formatting-example-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME]
 | Car License Plate Number | Booked into reception | Pre inspection completed | Parts ordered | Parts Delivered | Repairs Underway | Work complete |  | RED | YELLOW | BLUE | GREEN
 | ABC 001 | Y | Y
 | ABC 002 | Y | Y | Y | Y
 | ABC 003 | Y | Y | Y | Y | Y
 | ABC 004 | Y | Y | Y | Y | Y | Y
 | ABC 005 | Y | Y | Y | Y
 | ABC 006 | Y | Y | Y | Y | Y
 | ABC 007 | Y | Y
 | ABC 008 | Y | Y | Y | Y | Y | Y
 | ABC 009 | Y | Y | Y | Y | Y
 | ABC 010 | Y | Y | Y | Y | Y
 | ABC 011 | Y | Y | Y | Y | Y | Y
 | ABC 012 | Y | Y | Y | Y | Y
 | ABC 013 | Y | Y | Y | Y
 | ABC 014 | Y | Y | Y | Y | Y | Y
 | ABC 015 | Y | Y
 | ABC 016 | Y | Y | Y | Y | Y | Y
 | ABC 017 | Y | Y | Y | Y | Y
 | ABC 018 | Y | Y | Y | Y | Y | Y
 | ABC 019 | Y | Y | Y | Y
Spreadsheet: 844101d1695903217-find-the-estimated-time-required-to-manufacture-a-product-based-on-non-linear-min-max-data-anotherwayofdoingit-lacksadjuster
Sheet: AnotherWayOfDoingit-LacksAdjust

Count | Price | High Price | Low Price | High Count | k
50 |  | 2526.78 | 300 | 10000
100
500
1000
2000
2500
5000
5500
9000
10000
Spreadsheet: 657b2e6f-7bb3-43c2-81da-e9f4aa391d69
Sheet: Stmts. of Operations

 | HASBRO, INC. AND SUBSIDIARIES
 | Consolidated Statements of Operations
 | Fiscal Years Ended in December
 | (Thousands of Dollars Except Per Share Data)
 |  |  |  |  | 2012 |  | 2011 |  | 2010
 | Net revenues ……………………………………………………………………………………..…. |  | $ |  | 4088983 |  | 4285589 |  | 4002161
 | Costs and expenses
 | Cost of sales……………………………………………………………………………………… |  |  |  | 1671980 |  | 1836263 |  | 1690057
 | Royalties …………………………………………………………………………………………. |  |  |  | 302066 |  | 339217 |  | 248570
 | Product development ………………………………………………………….. |  |  |  | 201197 |  | 197638 |  | 201358
 | Advertising ……………………………………………………………………………………….. |  |  |  | 422239 |  | 413951 |  | 420651
 | Amortization of intangibles………….…………..………………………………………….….. |  |  |  | 50569 |  | 46647 |  | 50405
 | Program production cost amortization…………………………………………………….….. |  |  |  | 41800 |  | 35798 |  | 22069
 | Selling, distribution and administration ……………………..………………………………… |  |  |  | 847347 |  | 822094 |  | 781192
 | Total expenses ……………………………………………………………………………….. |  |  |  | 3537198 |  | 3691608 |  | 3414302
 | Operating profit …...……………………….……………………………………………….. |  |  |  | 551785 |  | 593981 |  | 587859
 | Non-operating (income) expense
 | Interest expense …………………………………….…………….….…….…………………… |  |  |  | 91141 |  | 89022 |  | 82112
 | Interest income …………………………………….…………….….…….…………………….. |  |  |  | -6333 |  | -6834 |  | -5649
 | Other (income) expense, net ………………….……………………………………………….. |  |  |  | 13575 |  | 25400 |  | 3676
 | Total non-operating expense, net ………………………………………………………........ |  |  |  | 98383 |  | 107588 |  | 80139
 | Earnings before income taxes…………………………………………………...………… |  |  |  | 453402 |  | 486393 |  | 507720
 | Income taxes ………………………………………….………….………………………………… |  |  |  | 117403 |  | 101026 |  | 109968
 | Net earnings………. ………………………….……….………………………...…………. |  | $ |  | 335999 |  | 385367 |  | 397752
 | Per common share
 | Net earnings
 | Basic …………………………………………………………………………………………… |  | $ |  | 2.58 |  | 2.88 |  | 2.86
 | Diluted …………………………………………………………………………………………. |  | $ |  | 2.55 |  | 2.82 |  | 2.74
 | Cash dividends declared ……………………………………………………………………….. |  | $ |  | 1.44 |  | 1.2 |  | 1
See accompanying notes to consolidated financial statements.
Spreadsheet: 778808d1651330198-go-to-named-range-after-selecting-item-from-drop-down-go-to-named-range-when-selecting-from-drop-down
Sheet: Sheet1

BR1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR10 |  | BR2 | BR2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR11 |  | BR3 | BR3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR12 |  | BR4 | BR4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR13 |  | BR5 | BR5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | BR6 | BR6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR7 | BR7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR8 | BR8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR9 | BR9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR10 | BR10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR11 | BR11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR12 | BR12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR13 | BR13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Br1
Inv | Date | Amount
112 | 2022-04-01 00:00:00 | 450.25
Spreadsheet: 267708d1380144115-help-with-solver-as-solver-gives-wrong-answer-help
Sheet: Q3

Test Case | Date of Birth | Age | Remark
1 | 1992-10-30 00:00:00
2 | 1992-09-01 00:00:00
3 | 1973-05-01 00:00:00
4 | 2004-07-02 00:00:00
Spreadsheet: 481713d1474613394-match-dates-and-sum-values-match-dates-and-sum-values-match-dates-and-sum-values-example
Sheet: Master

OVERALL STAFF REQUIREMENTS
 | Venue1 | Venue1 | Venue1 | Venue2 | Venue2 | Venue2 | Venue3 | Venue3 | Venue3
START DATE | FLT Operators | Tele | Crew | FLT Operators | Tele | Crew | FLT Operators | Tele | Crew
2018-02-27 00:00:00
2018-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/editpost.php?do=updatepost&postid=4486983
2018-03-01 00:00:00
2018-03-02 00:00:00
2018-03-03 00:00:00
2018-03-04 00:00:00
2018-03-05 00:00:00
2018-03-06 00:00:00
2018-03-07 00:00:00
2018-03-08 00:00:00
2018-03-09 00:00:00
2018-03-10 00:00:00
2018-03-11 00:00:00
2018-03-12 00:00:00
2018-03-13 00:00:00
2018-03-14 00:00:00
2018-03-15 00:00:00
2018-03-16 00:00:00
2018-03-17 00:00:00
2018-03-18 00:00:00
2018-03-19 00:00:00
2018-03-20 00:00:00
2018-03-21 00:00:00
2018-03-22 00:00:00
2018-03-23 00:00:00
2018-03-24 00:00:00
2018-03-25 00:00:00
2018-03-26 00:00:00
2018-03-27 00:00:00
2018-03-28 00:00:00
2018-03-29 00:00:00
2018-03-30 00:00:00
2018-03-31 00:00:00
2018-04-01 00:00:00
2018-04-02 00:00:00
2018-04-03 00:00:00
2018-04-04 00:00:00
2018-04-05 00:00:00
2018-04-06 00:00:00
2018-04-07 00:00:00
2018-04-08 00:00:00
2018-04-09 00:00:00
2018-04-10 00:00:00
2018-04-11 00:00:00
2018-04-12 00:00:00
2018-04-13 00:00:00
2018-04-14 00:00:00
2018-04-15 00:00:00
2018-04-16 00:00:00
2018-04-17 00:00:00
2018-04-18 00:00:00
2018-04-19 00:00:00
2018-04-20 00:00:00
2018-04-21 00:00:00
2018-04-22 00:00:00
2018-04-23 00:00:00
2018-04-24 00:00:00
2018-04-25 00:00:00
2018-04-26 00:00:00
2018-04-27 00:00:00
2018-04-28 00:00:00
2018-04-29 00:00:00
2018-04-30 00:00:00
Spreadsheet: 109146d1306080865-compare-two-values-target-v-actual-difference-sample-target-comparison
Sheet: Sheet1

Month | Target | Actual | [NAME] | Cum. Target | Cum. Actual | Cum. [NAME]
2011-01-01 00:00:00 | 100 | 80
 | 90 | 120
 | 200 | 250
TOTAL
Spreadsheet: 768003d1644781438-sumif-range-len-split-range-test_rev01-jtm2019hyo-
Sheet: BZ

1 | 1 | BC01_x001C_
2 | 2 | BC02_x001C_
3 | 3 | BC03_x001C_
4 | 4 | BC04_x001C_
5 | 5 | [NAME]_
6 | 6 | BC06_x001C_
7 | 7 | BC07_x001C_
8 | 8 | BC08_x001C_
9 | 9 | BC09_x001C_
10 | 10 | BC10_x001C_
11 | 11 | BC11_x001C_
12 | 12 | BC12_x001C_
13 | 13 | BC13_x001C_
14 | 14 | BC14_x001C_
15 | 15 | BC15_x001C_
16 | 16 | BC16_x001C_
17 | 17 | BC17_x001C_
18 | 18 | BC18_x001C_
19 | 19 | BC19_x001C_
20 | 20 | BC20_x001C_
21 | 21 | BC21_x001C_
22 | 22 | BC22_x001C_
23 | 23 | BC23_x001C_
24 | 24 | BC24_x001C_
25 | 25 | BC25_x001C_
26 | 1 | BE01_x001C_
27 | 2 | BE02_x001C_
28 | 3 | BE03_x001C_
29 | 4 | BE04_x001C_
30 | 5 | BE05_x001C_
31 | 6 | BE06_x001C_
32 | 7 | [NAME]_
33 | 8 | BE08_x001C_
34 | 9 | [NAME]_
35 | 10 | BE10_x001C_
36 | 11 | BE11_x001C_
37 | 12 | [NAME]_
38 | 13 | [NAME]_
39 | 14 | BE14_x001C_
40 | 15 | BE15_x001C_
41 | 16 | BE16_x001C_
42 | 17 | BE17_x001C_
43 | 18 | BE18_x001C_
44 | 19 | BE19_x001C_
45 | 20 | BE20_x001C_
46 | 21 | BE21_x001C_
47 | 22 | BE22_x001C_
48 | 23 | BE23_x001C_
49 | 24 | BE24_x001C_
50 | 25 | BE25_x001C_
51 | 26 | BE26_x001C_
52 | 27 | [NAME]_
53 | 28 | BE28_x001C_
54 | 29 | BE29_x001C_
55 | 30 | BE30_x001C_
56 | 31 | BE31_x001C_
57 | 32 | BE32_x001C_
58 | 33 | BE33_x001C_
59 | 34 | BE34_x001C_
60 | 35 | BE35_x001C_
61 | 36 | BE36_x001C_
62 | 37 | BE37_x001C_
63 | 38 | BE38_x001C_
64 | 39 | [NAME]_
65 | 40 | BE40_x001C_
66 | 41 | [NAME]_
67 | 1 | [NAME]
68 | 2 | BCL02_x001C_
69 | 3 | BCL03_x001C_
70 | 4 | BCL04_x001C_
71 | 5 | BCL05_x001C_
72 | 6 | BCL06_x001C_
73 | 7 | BCL07_x001C_
74 | 8 | BCL08_x001C_
75 | 9 | BCL09_x001C_
76 | 10 | BCL10_x001C_
77 | 11 | BCL11_x001C_
78 | 12 | BCL12_x001C_
79 | 13 | BCL13_x001C_
80 | 14 | BCL14_x001C_
81 | 15 | BCL15_x001C_
82 | 16 | BCL16_x001C_
83 | 17 | BCL17_x001C_
84 | 18 | BCL18_x001C_
85 | 19 | BCL19_x001C_
86 | 20 | BCL20_x001C_
87 | 21 | BCL21_x001C_
88 | 22 | BCL22_x001C_
89 | 23 | BCL23_x001C_
90 | 24 | BCL24_x001C_
91 | 1 | BEL01_x001C_
92 | 2 | BEL02_x001C_
93 | 3 | BEL03_x001C_
94 | 4 | BEL04_x001C_
95 | 5 | BEL05_x001C_
96 | 6 | BEL06_x001C_
97 | 7 | BEL07_x001C_
98 | 8 | BEL08_x001C_
99 | 9 | BEL09_x001C_
100 | 10 | BEL10_x001C_
101 | 11 | BEL11_x001C_
102 | 12 | BEL12_x001C_
103 | 13 | BEL13_x001C_
104 | 14 | BEL14_x001C_
105 | 15 | BEL15_x001C_
106 | 16 | BEL16_x001C_
107 | 17 | BEL17_x001C_
108 | 18 | BEL18_x001C_
109 | 19 | BEL19_x001C_
110 | 20 | BEL20_x001C_
111 | 21 | BEL21_x001C_
112 | 22 | BEL22_x001C_
113 | 23 | BEL23_x001C_
114 | 24 | BEL24_x001C_
115 | 25 | BEL25_x001C_
116 | 26 | BEL26_x001C_
117 | 27 | BEL27_x001C_
118 | 28 | BEL28_x001C_
119 | 29 | BEL29_x001C_
120 | 30 | BEL30_x001C_
121 | 31 | BEL31_x001C_
122 | 32 | BEL32_x001C_
123 | 33 | BEL33_x001C_
124 | 34 | BEL34_x001C_
125 | 35 | BEL35_x001C_
126 | 36 | BEL36_x001C_
127 | 37 | BEL37_x001C_
128 | 38 | BEL38_x001C_
129 | 39 | BEL39_x001C_
130 | 40 | BEL40_x001C_
131 | 41 | [NAME]_
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: DX54 TYC

 |  |  |  |  | DX54 TYC
Registration number : | DX54 TYC |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2004-11-30 00:00:00 | 12 Months | 2005-12-01 00:00:00 | 1200
Specification : | 6 x 2 A (3 Axle) |  | 2005-11-30 00:00:00 | 12 Months | 2006-12-01 00:00:00 | 1200
Type : | FTG XF95.480 |  | 2006-11-30 00:00:00 | 12 Months | 2007-12-01 00:00:00 | 1200
1st Registered : | 01.12.04 |  | 2007-11-30 00:00:00 | 12 Months | 2008-12-01 00:00:00 | 1200
Engine : | XE CI 12.60 litre |  | 2008-11-28 00:00:00 | 12 Months | 2009-12-01 00:00:00 | 1200
[NAME] : | 44,000kg |  | 2009-11-30 00:00:00 | 12 Months | 2010-12-01 00:00:00 | 1200
 |  |  | 2010-11-30 00:00:00 | 12 Months | 2011-12-01 00:00:00 | £1200 + £2.50 online fee
 |  |  | 2011-11-29 00:00:00 | 12 Months | 2012-12-01 00:00:00 | 700 | RP HGV
Back To Index
Spreadsheet: 868276d1715009028-first-post-ai-cant-seem-to-help-me-sample-sheet
Sheet: Sales Tax Liabilities Orig

[NAME] | Originating Master Name | Journal Entry | Account Number | Account Description | Series | Location | Description | User Who Posted | State | Payments | Accruals | Originating Source | Reference | Originating Posted Date
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 3267 | Feb 2024 MS SALES TAX | galmager | MS | 4395.3 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 1107 | Feb 2024 AL SALES TAX G/L | galmager | AL | 0 | 9.22 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 1107 | Feb 2024 AL LOCAL SALES TAX | galmager | AL | 1890.99 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 1107 | Feb 2024 AL SALES TAX | galmager | AL | 2836.49 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 1107 | Feb 2024 AL SALES TAX | galmager | AL | 4189.92 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 5102 | Feb 2024 AL SALES TAX G/L | galmager | AL | 0 | 2327.16 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 5102 | Feb 2024 AL SALES TAX | galmager | AL | 1268.21 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 5102 | Feb 2024 AL SALES TAX | galmager | AL | 4589.89 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 5102 | Feb 2024 AL LOCAL SALES TAX | galmager | AL | 6341.07 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 5148 | Feb 2024 AL SALES TAX G/L | galmager | AL | 10.33 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 5148 | Feb 2024 AL LOCAL SALES TAX | galmager | AL | 1361.02 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
45382 |  | 711 | [PHONE]-0000-000 | Sales Taxes Payable | Financial | 5148 | Feb 2024 AL SALES TAX | galmager | AL | 4927.21 | 0 | LKC 02.24 SLSTA | SALES TAX 0005 0224 | 45399
Spreadsheet: 33952d1230914166-show-a-certain-cell-depending-on-data-from-a-drop-down-menu-publishing-calendar-fy10
Sheet: Sheet1

Stock Receipt and Release Schedule FY 10
MAY |  |  |  |  |  |  | [NAME]
Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday |  | Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday
 |  |  |  |  | 1 |  | 1 | 2 | 3 | 3 | 4 | 5
4 BH | 5 | 6 | 6 | 7 | 8 |  | 8 | 9 | 10 | 10 | 11 | 12
11 | 12 | 13 | 13 | 14 | 15 |  | 15 | 16 | 17 | 17 | 18 | 19
18 | 19 | 20 | 20 | 21 | 22 |  | 22 | 23 | 24 | 24 | 25 | 26
25 BH | 26 | 27 | 27 | 28 | 29 |  | 29 | 30
JULY |  |  |  |  |  |  | AUGUST
Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday |  | Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday
 |  | 1 | 1 | 2 | 3
6 | 7 | 8 | 8 | 9 | 10 |  | 3 | 4 | 5 | 5 | 6 | 7
13 | 14 | 15 | 15 | 16 | 17 |  | 10 | 11 | 12 | 12 | 13 | 14
20 | 21 | 22 | 22 | 23 | 24 |  | 17 | 18 | 19 | 19 | 20 | 21
27 | 28 | 29 | 29 | 30 | 31 |  | 24 | 25 | 26 | 26 | 27 | 28
 |  |  |  |  |  |  | 31 BH
SEPTEMBER |  |  |  |  |  |  | OCTOBER
Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday |  | Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday
 | 1 | 2 | 2 | 3 | 4 |  |  |  |  |  | 1 | 2
7 | 8 | 9 | 9 | 10 | 11 |  | 5 | 6 | 7 | 7 | 8 | 9
14 | 15 | 16 | 16 | 17 | 18 |  | 12 | 13 | 14 | 14 | 15 | 16
21 | 22 | 23 | 23 | 24 | 25 |  | 19 | 20 | 21 | 21 | 22 | 23
28 | 29 | 30 | 30 |  |  |  | 26 | 27 | 28 | 28 | 29 | 30
NOVEMBER |  |  |  |  |  |  | DECEMBER
Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday |  | Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday
 |  |  |  |  |  |  |  | 1 | 2 | 2 | 3 | 4
2 | 3 | 4 | 4 | 5 | 6 |  | 7 | 8 | 9 | 9 | 10 | 11
9 | 10 | 11 | 11 | 12 | 13 |  | 14 | 15 | 16 | 16 | 17 | 18
16 | 17 | 18 | 18 | 19 | 20 |  | 21 | 22 | 23 | 23 | 24 | 25 BH
23 | 24 | 25 | 25 | 26 | 27 |  | 28 BH | 29 | 30 | 30 | 31
30
JANUARY |  |  |  |  |  |  | FEBRUARY
Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday |  | Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday
 |  |  |  |  | 1 BH |  | 1 | 2 | 3 | 3 | 4 | 5
4 | 5 | 6 | 6 | 7 | 8 |  | 8 | 9 | 10 | 10 | 11 | 12
11 | 12 | 13 | 13 | 14 | 15 |  | 15 | 16 | 17 | 17 | 18 | 19
18 | 19 | 20 | 20 | 21 | 22 |  | 22 | 23 | 24 | 24 | 25 | 26
25 | 26 | 27 | 27 | 28 | 29
[NAME] |  |  |  |  |  |  | APRIL
Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday |  | Monday | Tuesday | Wednesday AM | Wednesday PM | Thursday | Friday
1 | 2 | 3 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 BH
8 | 9 | 10 | 10 | 11 | 12 |  | 5 BH | 6 | 7 | 7 | 8 | 9
15 | 16 | 17 | 17 | 18 | 19 |  | 12 | 13 | 14 | 14 | 15 | 16
22 | 23 | 24 | 24 | 25 | 26 |  | 19 | 20 | 21 | 21 | 22 | 23
29 | 30 | 31 | 31 |  |  |  | 26 | 27 | 28 | 28 | 29 | 30
Spreadsheet: 0921caa1-7d9e-4df9-8118-99d89247a1ed
Sheet: Sheet1

2013 MONTHLY LEAVE ACCRUAL RATES AND ACCUMULATION LIMITS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Effective January 1, 2013
SICK LEAVE
[NAME] | Yearly Accrual | January 184 Hrs | February 160 Hrs | March        168 Hrs | April           176 Hrs | May           184 Hrs | June          160 Hrs | July           184 Hrs | August        176 Hrs | September 168 Hrs | October 184 Hrs | November 168 Hrs | December 176 Hrs | Accumulation Limit
.057471/Hr. | 15 days/yr | 10.574664 | 9.19536 | 9.655128 | 10.114896 | 10.574664 | 9.19536 | 10.574664 | 10.114896 | 9.655128 | 10.574664 | 9.655128 | 10.114896 | No Limit
ANNUAL LEAVE
Years of                     Cumulative Service | Yearly Accrual | January 184 Hrs | February 160 Hrs | March        168 Hrs | April           176 Hrs | May           184 Hrs | June          160 Hrs | July           184 Hrs | August        176 Hrs | September 168 Hrs | October 184 Hrs | November 168 Hrs | December 176 Hrs | Accumulation Limit
Less than 5 years (.057471/Hr.) | 15 days/yr | 10.574664 | 9.19536 | 9.655128 | 10.114896 | 10.574664 | 9.19536 | 10.574664 | 10.114896 | 9.655128 | 10.574664 | 9.655128 | 10.114896 | 240 hrs/30 days
5 but less than 10 yrs (.068966/Hr.) | 18 days/yr | 12.689744 | 11.03456 | 11.586288 | 12.138016 | 12.689744 | 11.03456 | 12.689744 | 12.138016 | 11.586288 | 12.689744 | 11.586288 | 12.138016 | 480 hrs/60 days
10 but less than 20 yrs (.076628/Hr.) | 20 days/yr | 14.099552 | 12.26048 | 12.873504 | 13.486528 | 14.099552 | 12.26048 | 14.099552 | 13.486528 | 12.873504 | 14.099552 | 12.873504 | 13.486528 | 480 hrs/60 days
20 years and over (.095785/Hr.) | 25 days/yr | 17.62444 | 15.3256 | 16.09188 | 16.85816 | 17.62444 | 15.3256 | 17.62444 | 16.85816 | 16.09188 | 17.62444 | 16.09188 | 16.85816 | 480 hrs/60 days
Spreadsheet: 59739-vlookup-error-alanh
Sheet: Sheet1

DEVICE # | MODEL
27-0384202 | CLASSIC
31E-0780805 | TP I
34G-0670261 | TP II
34H2-0906558 | TP II
343P2-0395893 | 343
344AP-0150496 | 344
27-0384203
31E-0780806
34G-0670262
34H2-0906559
343P2-0395894
344AP-0150497
27-0384204
31E-0780807
34G-0670263
34H2-0906560
343P2-0395895
344AP-0150498
27-0384205
31E-0780808
34G-0670264
34H2-0906561
343P2-0395896
344AP-0150499
Spreadsheet: 852919d1702905201-nested-if-statements-with-data-validation-not-working-dropdownlist
Sheet: D

Dropdown | Cond | Values
[0 - 10] |  | 10 |  | =IF(B2="Zero_Ten",Zero_Ten,IF(B2="Ten_Twenty",Ten_Twenty,IF(B2="Twenty_Thirty",Twenty_Thirty,IF(B2="Thirty_Forty",Thirty_Forty,IF(B2="Forty_Fifty",Forty_Fifty,IF(B2="Fifty_Sixty",Fifty_Sixty,IF(B2="Sixty_Seventy",Sixty_Seventy,IF(B2="Seventy_Eighty",Seventy_Eighty,IF(B2="Eighty_Ninety",Eighty_Ninety,IF(B2="Ninety_Hund",Eighty_Hund,0))))))))))
[10 - 20] |  | 20 |  | =IF(B2="Zero_Ten",Zero_Ten,IF(B2="Ten_Twenty",Ten_Twenty,IF(B2="Twenty_Thirty",Twenty_Thirty,IF(B2="Thirty_Forty",Thirty_Forty,IF(B2="Forty_Fifty",Forty_Fifty,IF(B2="Fifty_Sixty",Fifty_Sixty,IF(B2="Sixty_Seventy",Sixty_Seventy,0)))))))
[20 - 30] |  | 30
[0 - 10] |  | 4
[40 - 50] |  | 43
[20 - 30] |  | 24
[60 - 70] |  | 64
[50 - 60] |  | 59
[50 - 60] |  | 57
[50 - 60] |  | 56
[50 - 60] |  | 52
[50 - 60] |  | 55
[50 - 60] |  | 55
[50 - 60] |  | 54
[50 - 60] |  | 58
[50 - 60] |  | 58
[50 - 60] |  | 59
[50 - 60] |  | 60
[50 - 60] |  | 53
[50 - 60] |  | 57
Spreadsheet: 123129d1317365418-when-using-match-function-can-your-lookup-array-be-multiple-rows-and-columns-help
Sheet: Sheet1

 |  | 6
A | B | #N/A | SOLUTION 1 |  | A | A | 2
 |  | 6 | SOLUTION 2 |  | B | B | 4
 |  |  |  |  | A | B | 6
 |  |  |  |  | D | B | 4
 |  |  |  |  | E | A | 5
Spreadsheet: marie_heard__24528__Millennium Gas Mktg
Sheet: ms

CONFIRMATION CREDIT INFORMATION SHEET: Deal #YE2249.1/2 & YE2140.1
 |  | ATTORNEY:
DATE: | 2001-10-26 00:00:00 | DEAL MAKER: | [NAME]
COUNTERPARTY: | Millennium Gas Marketing, LLC | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING)
LIMIT $ MILLIONS
Incorporation State
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | 0
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X
Cash | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0
COLLATERAL ROUNDING
Delivery Amount | 50000
Return Amount | 50000
HOLDING and USE OF COLLATERAL
Permitted
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE - Condition of Guarantee Release
APPLY TO:
-Counterparty | X
-Guarantor
Debt Ratings Change
-Below = S&P/Moody's
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Interest
Non-Specific | X
-Unilateral | X
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | n/a
-Counterparty ($[NAME])
-Guarantor ($[NAME])
Change in ownership
FINANCIAL STATEMENTS
-Standard
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
**Letter of credit for $50,000 issued 10/5/01 (#[NAME]) for financial transactions.  Any exposure above this l/c
will be collateralized as necessary.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x6-6002