tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 30239d1225677287-conditional-formatting-question-match-1-
Sheet: Sheet1

 |  | Selected Numbers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winner
 |  | 12 | 14 | 49 | 34 | 25 | 98 | 16 | 86 | 123 | 160 | 15 | 37 | 59 | 236 | 112 | 22 | 7 |  |  | Player1
 |  | 13 | 17 | 36 | 55 | 74 | 93 | 131 |  |  |  |  |  |  |  |  |  |  |  |  | Player26
Player1 |  | 12 | 49 | 86 | 123 | 160 | 14 | 6
Player2 |  | 23 | 38 | 53 | 68 | 83 | 98 | 1
Player3 |  | 21 | 37 | 53 | 69 | 85 | 101 | 1
Player4 |  | 49 | 25 | 28 | 31 | 34 | 37 | 4
Player5 |  | 1 | 48 | 95 | 142 | 189 | 236 | 1
Player6 |  | 4 | 47 | 90 | 133 | 176 | 219 | 0
Player7 |  | 2 | 25 | 48 | 71 | 94 | 117 | 1
Player8 |  | 5 | 26 | 47 | 68 | 89 | 110 | 0
Player9 |  | 2 | 14 | 26 | 38 | 50 | 62 | 1
Player10 |  | 4 | 13 | 22 | 31 | 40 | 49 | 3
Player11 |  | 5 | 11 | 17 | 23 | 29 | 35 | 1
Player12 |  | 12 | 15 | 18 | 21 | 24 | 27 | 2
Player13 |  | 13 | 14 | 15 | 16 | 17 | 18 | 5
Player14 |  | 14 | 22 | 30 | 38 | 46 | 54 | 2
Player15 |  | 15 | 17 | 19 | 21 | 23 | 25 | 3
Player16 |  | 16 | 19 | 22 | 25 | 28 | 31 | 3
Player17 |  | 1 | 5 | 9 | 13 | 17 | 21 | 2
Player18 |  | 4 | 9 | 14 | 19 | 24 | 29 | 1
Player19 |  | 9 | 14 | 19 | 24 | 29 | 34 | 2
Player20 |  | 21 | 36 | 51 | 66 | 81 | 96 | 1
Player21 |  | 22 | 25 | 28 | 31 | 34 | 37 | 4
Player22 |  | 23 | 55 | 87 | 119 | 151 | 183 | 1
Player23 |  | 24 | 47 | 70 | 93 | 116 | 139 | 1
Player24 |  | 25 | 29 | 33 | 37 | 41 | 45 | 2
Player25 |  | 26 | 23 | 20 | 17 | 14 | 11 | 2
Player26 |  | 36 | 55 | 74 | 93 | 112 | 131 | 6
Spreadsheet: 222072d1363745905-sum-corresponding-cells-sum
Sheet: Sheet1

 | 20 |  | 5 |  | 10 |  | 10 | 50 |  | SUM | Headings
 | 17 |  | 3 |  | 5 |  | 5 | 47 |  | ?? | SUM the corresponding Headings, sum here should be b1+d1+f1+h1+i1
 | 15 |  |  |  |  |  | 7 | 58 |  | ?? | SUM the corresponding Headings, sum here should be b1+dh1,i1
 |  |  |  |  | 10 |  |  | 10 |  |  | SUM the corresponding Headings, sum here should be f1+i1
Spreadsheet: 59a8db1a-2911-4b0e-8f3e-07b75b78c7f8
Sheet: Sheet1

Table 5--U.S. and world fiber prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Mar. | Apr. | May |  | May
Item | 2013 | 2013 | 2013 |  | 2012
 | Cents per pound
Domestic cotton prices:
Adjusted world price | 72.92 | 71.74 | 71.82 |  | 68.75
Upland spot 41-34 | 82.8 | 80.94 | 79.84 |  | 72.51
Pima spot 03-46 | 111.65 | 116.5 | 133 |  | 123.55
Average price received by
upland producers | 75.3 | 75.4 | 75.7 |  | 84.4
Far Eastern cotton quotes:
A Index | 94.74 | 92.9 | 92.3 |  | 87.95
Memphis/Eastern | 97.06 | 94.31 | 93.45 |  | 90.85
Memphis/Orleans/Texas | 96.81 | 94.06 | 93.2 |  | 90.85
California/Arizona | 100 | 97.56 | 96.55 |  | 91.35
 |  | Dollars per pound
Wool prices (clean):
U.S. 56s | NQ | NQ | NQ |  | NQ
Australian 56s 1/ | 4 | 3.74 | 3.71 |  | 4.24
U.S. 60s | NQ | NQ | NQ |  | NQ
Australian 60s 1/ | 5.63 | 5.17 | 5.1 |  | 6.29
U.S. 64s | NQ | NQ | NQ |  | NQ
Australian 64s 1/ | 5.84 | 5.38 | 5.18 |  | 6.07
NQ = No quote.
1/  In bond, Charleston, SC.
Sources: USDA, Cotton Price Statistics; Cotlook Ltd., [NAME];
and trade reports.
Last update:  06/14/13.
Spreadsheet: 792046d1660719995-part-no-creation-i-want-to-create-a-unique-part-no-based-on-spreadsheet-data-example-part-no-formula
Sheet: Sheet1

Category | Type | Part No. | Desired Result |  | REPLACEMENT | 1
APPLIANCES | REPLACEMENT |  | APP-1-001 |  | INSTALLATION | 2
APPLIANCES | REPLACEMENT |  | APP-1-002 |  | CLIENT SUPPLIED | 3
APPLIANCES | REPLACEMENT |  | APP-1-003
APPLIANCES | REPLACEMENT |  | APP-1-004
APPLIANCES | REPLACEMENT |  | APP-1-005
APPLIANCES | REPLACEMENT |  | APP-1-006
APPLIANCES | INSTALLATION |  | APP-2-001
APPLIANCES | INSTALLATION |  | APP-2-002
APPLIANCES | INSTALLATION |  | APP-2-003
APPLIANCES | INSTALLATION |  | APP-2-004
APPLIANCES | INSTALLATION |  | APP-2-005
APPLIANCES | CLIENT SUPPLIED |  | APP-3-001
APPLIANCES | CLIENT SUPPLIED |  | APP-3-002
APPLIANCES | CLIENT SUPPLIED |  | APP-3-003
APPLIANCES | CLIENT SUPPLIED |  | APP-3-004
LIGHTING | REPLACEMENT |  | LIG-1-001
LIGHTING | REPLACEMENT |  | LIG-1-002
LIGHTING | REPLACEMENT |  | LIG-1-003
LIGHTING | REPLACEMENT |  | LIG-1-004
LIGHTING | INSTALLATION |  | LIG-2-001
LIGHTING | INSTALLATION |  | LIG-2-002
LIGHTING | INSTALLATION |  | LIG-2-003
LIGHTING | INSTALLATION |  | LIG-2-004
LIGHTING | CLIENT SUPPLIED |  | LIG-3-001
LIGHTING | CLIENT SUPPLIED |  | LIG-3-002
LIGHTING | CLIENT SUPPLIED |  | LIG-3-003
Spreadsheet: 297087d1392282622-how-to-fetch-first-few-values-or-names-from-excel-column-combination-task
Sheet: Sheet1

 |  | Combinations of
 | Data | set of first 3, 4 times | set of first 6, 3 times | set of first 12, 2 times | set of all , 30 single tme
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Chaw | Chaw | Chaw | Chaw | Chaw
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Mathew | Mathew | Mathew | Mathew | Mathew
 | Cooper | Cooper | Cooper | Cooper | Cooper
 | Helward | Helward | Helward | Helward | Helward
 | Tron | Tron | Tron | Tron | Tron
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Sara | Sara | Sara | Sara | Sara
 | Harbinger | Harbinger | Harbinger | Harbinger | Harbinger
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Jacy | Jacy | Jacy | Jacy | Jacy
 | Sarwana |  | Sarwana | Sarwana | Sarwana
 | Sorghama |  | Sorghama | Sorghama | Sorghama
 | [NAME] |  | [NAME] | [NAME] | [NAME]
 | parker |  | parker | parker | parker
 | Zubeda |  | Zubeda | Zubeda | Zubeda
 | Zaanvi |  | Zaanvi | Zaanvi | Zaanvi
 | Toad |  |  | Toad | Toad
 | [NAME] |  |  | [NAME] | [NAME]
 | Helward |  |  | Helward | Helward
 | Tron |  |  | Tron | Tron
 | [NAME] |  |  | [NAME] | [NAME]
 | Sara |  |  | Sara | Sara
 | Sarwana |  |  |  | Sarwana
 | Sorghama |  |  |  | Sorghama
 | [NAME] |  |  |  | [NAME]
 | Sara |  |  |  | Sara
 | Harbinger |  |  |  | Harbinger
 | [NAME] |  |  |  | [NAME]
Spreadsheet: 88459d1288273094-formula-to-return-text-on-a-set-condition-20101027-estimate-pack
Sheet: Requisition of materials

 |  |  |  |  |  |  |  | Estimate:
Requisition of materials
Requested by
Date
Job name
 |  | Order number  (to be completed by buyer) | Quantity | Description of goods / materials |  |  | Potential suppliers
Notes / Remarks   Type here
Requisition completed by:
Signed:
Spreadsheet: 47442d1246470081-how-to-sort-2-sets-of-data-with-dates-to-correlate-each-other-coefficient
Sheet: Sheet1

Dates 1 | Price 1 | Dates 2 | Price 2
1996-03-18 00:00:00 | 10 | 1996-03-18 00:00:00 | 13.5
1996-03-19 00:00:00 | 10.125 | 1996-03-19 00:00:00 | 14
1996-03-20 00:00:00 | 10.125 | #N/A | #N/A
1996-03-22 00:00:00 | 10.25 | 1996-03-22 00:00:00 | 14
1996-03-25 00:00:00 | 10.25 | 1996-03-25 00:00:00 | 14.0625
#N/A | #N/A | 1996-03-26 00:00:00 | 13.25
1996-03-27 00:00:00 | 10.25 | 1996-03-27 00:00:00 | 13.1875
1996-03-28 00:00:00 | 10.25 | 1996-03-28 00:00:00 | 13.125
1996-03-29 00:00:00 | 10.25 | 1996-03-29 00:00:00 | 13.5
Spreadsheet: jim_schwieger__14487__Inv_WC_true_up
Sheet: Prime Rate Calc- NET

Date | Prime Rate | Principal | Principle * Daily Prime Rate
 |  |  |  |  |  |  |  |  |  |  | Prime Rate
2001-06-01 00:00:00 |  |  |  |  | 1 |  |  |  |  |  | Date Change |  | Rate
 |  |  |  |  |  |  |  |  |  |  | 2001-01-04 00:00:00 |  | 0.09
 |  |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 |  | 0.085
 |  |  |  |  |  |  |  |  |  |  | 2001-03-21 00:00:00 |  | 0.08
 |  |  |  |  |  |  |  |  |  |  | 2001-04-19 00:00:00 |  | 0.075
 |  |  |  |  |  |  |  |  |  |  | 2001-05-16 00:00:00 |  | 0.07
 |  |  |  |  |  |  |  |  |  |  | 2001-06-28 00:00:00 |  | 0.0675
 |  |  |  |  |  |  |  |  |  |  | 2001-08-22 00:00:00 |  | 0.065
 |  |  |  |  |  |  |  |  |  |  | 2001-09-18 00:00:00 |  | 0.06
 |  |  |  |  |  |  |  |  |  |  | 2001-10-03 00:00:00 |  | 0.055
 |  |  |  |  |  | Jun
 |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  | 1
Spreadsheet: 217150d1361993613-problems-with-index-and-match-formula-sample-worksheet_1
Sheet: TableC

 | Period | Yellow | Blue | Red | Green | Black
 | Q1 | 78789 | 978 | 4511 | 618 | 5133
 | Q2 | 2215 | 21 | 1544 | 5419 | 87877
 | Q3 | 159 | 357 | 852 | 456 | 9587
 | Q4 | 1254 | 2558 | 5693 | 3624 | 22364
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: netLibrary

NetLibrary
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | Price for 2006-2007 | Price per access
NetLibrary
Accesses | 43 | 33 | 74 | 183 | 209 | 96 | 46 | 111 | 137 | 133 | 57 | 51 |  | 0 | N/A
Turnaways | 6 | 0 | 0 | 18 | 34 | 26 | 19 | 17 | 10 | 31 | 20 | 23
Note: We have 4,478 shared titles
COUNTER-Compliant?: | No
Spreadsheet: 584416d1533162456-highlight-dates-from-event-duration-on-calendar-ef1178_staff_calendar_auto_populate_range
Sheet: Calendar

 |  |  |  |  |  |  |  |  | Month | 1
 |  |  |  |  |  |  |  |  | Year | 2018
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5
Spreadsheet: 649bcbff-3d1e-4b41-bf13-88ef41b2a609
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
F8A | Test | F8A | Coagulation Factor VIII Activity Assay, Plasma | Coag Factor VIII Activity Assay, P | Activated Partial Thromboplastin Clot-Based Assay | Light blue-top (citrate) tube: LgtBlu |  |  | 1 | mL | See Coagulation Studies in Special Instructions.   Specimen Type: Platelet-poor plasma Collection Container/Tube: Light-blue top (citrate) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Spin down, remove plasma, and spin plasma again.  2. Freeze specimen immediately at < or =-40 degrees C, if possible. Additional Information: 1. Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. 2. Patient must not be receiving [NAME] or heparin therapy. 3. Each coagulation assay requested should have its own vial. 4. If priority specimen, mark request form, give reason, and request a call-back. 5. Not offered for detection of hemophilia carrier. 6. Coagulation testing is highly complex, often requiring the performance of multiple assays and correlation with clinical information. For that reason, we suggest ordering Coagulation Consultations. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Adults: 55-200% Normal, full-term newborn infants or healthy premature infants usually have normal or elevated factor [NAME].* *See Pediatric Hemostasis References in Coagulation Studies in Special Instructions. | Monday through Friday | 1 day | 3 days | 1 | 85240 |  |  |  |  | Rochester
F8A | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
F8A | Result | F8A | Coag Factor VIII Activity Assay, P | Coag Factor VIII Activity Assay, P | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 3209-4 | Coagulation factor VIII activity actual/Normal:RelTime:Pt:PPP:Qn:Coag
Spreadsheet: 197405d1354331901-if-a-cell-equals-x-then-format-that-many-cells-for-input-ppjn348-bracket-help
Sheet: Elite 8

 | Total Points
SOUTH | PPG this RD
WEST
EAST
MIDWEST
Spreadsheet: 273114d1382618051-special-remove-duplicate-filter-example
Sheet: Sheet1

Lab A | Address A |  | Cleveland | OH | Zip A | Cuyahoga | 8071 | Facility Type | 621512 | Contact Person | First | Last | Contact Position
Lab A | Address A |  | Cleveland | OH | ZipA | Cuyahoga | 8071 | Facility Type | 621512 | Contact Person | First | Last | Contact Position
Lab B | Address B |  | New Iberia | LA | Zip B | Iberia | 8071 | Facility Type | 621512 | Contact Person | First | Last | Contact Position
Lab B | Address B |  | New Iberia | LA | Zip B | Iberia | 8071 | Facility Type | 621512 | Contact Person | First | Last | Contact Position
Lab C- Client
Lab C | Address C |  | [NAME] | FL | Zip C | Broward | 8011 | Facility Type | 621493 | Contact Person | First | Last | Contact Position
Lab C | Address C |  | [NAME] | FL | Zip C | Broward | 8011 | Facility Type | 621493 | Contact Person | First | Last | Contact Position
Lab D | Adress D |  | Cedar Rapids | IA | Zip D | [NAME] | 8071 | Facility Type | 621512 | Contact Person | First | Last | Contact Position
Spreadsheet: 804537d1668133988-how-to-count-numbers-in-a-column-based-on-a-set-of-numbers-excelhelp1-dwyane-
Sheet: Sheet1

2 | 16
4 | 11
0 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | numbers | count | Total Percentage | Set1(2,4,0) | Set2(5,17,10)
17 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
5 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
0 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
5 | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
22 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 1e32ce20-d166-4e53-abf9-9f7b4f155ab4
Sheet: Sheet1

 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | GYRATORY MIXING AND COMPACTION TEMPERATURES
As of June, 22 2010
 | SUPPLIER RECOMMENDATIONS |  |  |  |  | 2010
 |  |  |  |  |  | Shipping
UDOT APPROVED | BINDER | MIXING | COMPACTION | SPECIFIC | Lbs. per [NAME] | Approval ??
SUPPLIER | GRADE | TEMP. °F | TEMP. °F | GRAVITY, 60.0°F | at  60.0°F
[NAME] | PG58-22
[NAME] | PG58-28
[NAME] | PG64,-28 | 313 - 325 | 279 - 297 | 1.032 | 8.6124573408 | Yes
[NAME] | PG64,-34 | 316 - 329 | 284 - 302 | 1.028 | 8.579075723199999 | Yes
[NAME] | PG70,-28 | 318 - 331 | 284 - 302 | 1.034 | 8.6291481496 | Yes
[NAME] | PG58,-34 | 306 - 320 | 275 - 293 | 1.024 | 8.545694105599999 | Yes
[NAME] | [NAME] | 295 - 305 | 275 - 283 | 1.034 | 8.6291481496 | Yes
Ergon | [NAME] | 292-304 | 269-279 | 1.0305 | 8.599939234199999 | Yes
Ergon | PG64,-28 | 347-362 | 321-332 | 1.0291 | 8.588255668039999 | Yes
Ergon | PG64,-34 | 377-393 | 347-360 | 1.026 | 8.562384914399999 | Yes
Ergon | PG64,-34S | 386-404 | 351-366 | 1.0226 | 8.534010539439999 | Yes
Ergon | PG70,-28S | 404-421 | 372-385 | 1.0278 | 8.57740664232 | Yes
Staker Parsons | [NAME] | 298-309 | 278-285 | 1.021 | 8.5206578924 | Yes
Staker Parsons | PG58,-34 | 306-313 | 286-294 | 1.011 | 8.4372038484 | Yes
Staker Parsons | PG64,-28 | 313-325 | 290-300 | 1.029 | 8.587421127599999 | Yes
Staker Parsons | PG64,-34 | 306-313 | 286-294 | 1.011 | 8.4372038484 | Yes
Staker Parsons | PG70,-28 | 318-326 | 297-305 | 1.021 | 8.5206578924 | Yes
Idaho Asphalt Supply | PG58,-34 | 306 - 320 | 275 - 293 | 1.024 | 8.545694105599999 | Yes
Idaho Asphalt Supply | PG64,-28 | 313 - 325 | 279 - 297 | 1.032 | 8.6124573408 | Yes
Idaho Asphalt Supply | PG64,-34 | 316 - 329 | 284 - 302 | 1.028 | 8.579075723199999 | Yes
Idaho Asphalt Supply | PG70,-28 | 318 - 331 | 284 - 302 | 1.034 | 8.6291481496 | Yes
Idaho Asphalt Supply | [NAME] | 295 - 305 | 275 - 283 | 1.034 | 8.6291481496 | Yes
Mountain States Asphalt | [NAME] | 300-312 | 280-290 | 1.035 | 8.637493553999999 | Yes
Mountain States Asphalt | PG64,-22 | 312-325 | 291-302 | 1.043 | 8.704256789199999 | Yes
Mountain States Asphalt | PG64,-34 | 368-379 | 341-351 | 1.033 | 8.620802745199999 | Yes
Suncor | PG58,-34 |  |  | 1.034 | 8.6291481496 | Yes
Suncor | PG64,-28 | 313-321 | 292-300 | 1.031 | 8.604111936399999 | Yes
Suncor | PG64,-34 | 301-309 | 281-289 | 1.025 | 8.554039509999999 | No
Suncor | PG76,-28 | 321-329 | 300-308 | 1.027 | 8.570730318799999 | Yes
Paramount (Frenley, NV) | PG58,34 | 329-339 | 311-319 | 1.012 | 8.4455492528 | Yes
Paramount (Frenley, NV) | PG64,-34 | 328-338 | 308-317 | 1.0115 | 8.4413765506 | Yes
Paramount (Frenley, NV) | PG64,-22 | 302-312 | 283-291 | 1.028 | 8.579075723199999 | Yes
Paramount (Frenley, NV) | [NAME] | 283-292 | 265-273 | 1.031 | 8.604111936399999 | Yes
Paramount (Frenley, NV) | PG64,-28UT | 321-330 | 302-310 | 1.0222 | 8.53067237768 | Yes
Paramount  (LA, CA) | PG 70-28 | 317-328 | 280-284 | 1.024 | 8.545694105599999 | Yes
Spreadsheet: 440208c5-1c47-4e9f-8fe0-1c4a696c5789
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4353 | 15266 | [NAME] | [NAME] | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00 | Elite Men
4352 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00 | Elite Women
Spreadsheet: 753191d1635279690-summarizing-amount-of-payments-per-calendar-year-based-on-start-and-end-of-lease-summarizing-amount-of-payments-per-calendar-year-based-on-start-and-end-of-lease
Sheet: Sheet1

Contract Start | Contact End | Rate Per Month |  |  | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028
09-01-2020 | 04-01-2027 | 5 |  | Total Cost($)
12-01-2021 | 06-01-2025 | 10
01-01-2021 | 01-01-2022 | 3
05-01-2022 | 07-01-2028 | 8
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: PCCW (Hong Kong)

PCCW (Hong Kong)
Date | Channel | Start (Local) | End (Local) | Notes
2010-11-21 00:00:00 | 636 | 22:00:00 | 00:00 (22/11) | Round [NAME] (Singles)
2010-11-22 00:00:00 | 636 | 04:00:00 | 06:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 636 | 22:00:00 | 00:00 (23/11) | Round [NAME] (Singles)
2010-11-23 00:00:00 | 636 | 04:00:00 | 06:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 636 | 22:00:00 | 00:00 (24/11) | Round [NAME] (Singles)
2010-11-24 00:00:00 | 636 | 04:00:00 | 06:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 636 | 22:00:00 | 00:00 (25/11) | Round [NAME] (Singles)
2010-11-25 00:00:00 | 636 | 04:00:00 | 06:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 636 | 22:00:00 | 00:00 (26/11) | Round [NAME] (Singles)
2010-11-26 00:00:00 | 636 | 04:00:00 | 06:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 636 | 22:00:00 | 00:00 (27/11) | Round [NAME] (Singles)
2010-11-27 00:00:00 | 636 | 04:00:00 | 06:00:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 636 | 22:00:00 | 00:30 (28/11) | Semi-Final 1 - Live (Singles)
2010-11-28 00:00:00 | 636 | 04:00:00 | 06:30:00 | Semi-Final 2 - Live (Singles)
2010-11-29 00:00:00 | 636 | 01:30:00 | 04:30:00 | Singles Final - Live
Spreadsheet: 782883d1654364081-demand-plan-basis-on-90-warehouse-utilization-book1
Sheet: Sheet2

Effective sq.ft | Closing stock |  | Total Tonnage | 4.03 | 4.03 | Total space utilized | Ref. | Total Capacity (mT) | Opening (Jun-1st) | Demand Plan | DN Forecast | Closing Stock | Days | Utilization % | Ref.
 | NP FFL |  |  | NP FFL
9360.4 |  |  |  |  |  |  | '=IF(E$1*B3<0,0,E$1*B3) | 1581.148648648649 | 1219.15 |  | 1395.5 | 2123.65 | 24.98411764705882 |  | =g3/a3
10437.5 |  |  |  |  |  |  |  | 1763.091216216216 | 1952.6 |  | 1446.6 | 2905.3 | 45.87315789473683
15121 |  |  |  |  |  |  |  | 2554.222972972973 | 2575.65 |  | 2216.5 | 3158.450000000001 | 32.11983050847459
3614.5 |  |  |  |  |  |  |  | 610.5574324324324 | 782.4499999999999 |  | 1238.65 | 743.0999999999999 | 26.22705882352941
15750 |  |  |  |  |  |  |  | 2660.472972972973 | 1096.8 |  | 358.2 | 2837.900000000001 | 30.9589090909091
8965.5 |  |  |  |  |  |  |  | 1514.442567567567 | 2003.75 |  | 793.3 | 1210.45 | 0
18652 |  |  |  |  |  |  |  | 3150.675675675676 | 2389.75 |  | 3273.5 | 7915.549999999999 | 50.52478723404255
34764.25999999999 |  |  |  |  |  |  |  | 5872.341216216216 | 10248.7 |  | 11070.95 | 6910.383333333333 | 40.6493137254902
Table 1 |  |  |  |  |  |  |  | Table 2
June |  |  |  | July |  |  |  |  | Ref. | K3=B15 and so on
Opening Stock | Demand Plan | DN Forecast | Closing Stock | Opening Stock | Demand Plan | DN Forecast | Closing Stock
0 | 2300 | 600 |  |  | 0 | 1000 | 700
658.3499999999999 | 2399.3 | 958.3499999999999 | 2099.3 |  | 0 | 900 | 1199.3
114 | 2799.3 | 814 | 2099.3 |  | 0 | 900 | 1199.3
560.65 | 1199.3 | 1060.65 | 699.2999999999997 |  | 0 | 300 | 399.2999999999997
0 | 2099.3 | 0 | 2099.3 |  | 0 | 900 | 1199.3
6.75 | 0 | 0 | 6.75 |  | 0 | 0 | 6.75
30 | 8799.3 | 1830 | 6999.299999999999 |  | 0 | 3000 | 3999.299999999999
0 | 7732.633333333333 | 1200 | 6532.633333333333 |  | 0 | 2800 | 3732.633333333333
Table 3
Spreadsheet: 87822d1287679177-key-formula-adjustment-new-example
Sheet: 1161

 |  | Full Year |  | Actual | Actual | Actual | Actual | Actual | Actual
 |  | Budget |  | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6
KEY |  | 2010/11 |  | 2010/11 | 2010/11 | 2010/11 | 2010/11 | 2010/11 | 2010/11
212011  Sales in Cnt to PPE*        Total Sales | 212011  Sales in Cnt to PPE |  |  | -5557.09 | -8735.6 | -19670 | -12196.6 | -18508.35 | -7973.16
212018  Sales in Cnt to Proc*        Total Sales | 212018  Sales in Cnt to Proc | -829401 |  | -204002.85 | -183855.67 | -273346.32 | -233836.73 | -285125 | -271544.55
212201  Sales in Cnty out BL*        Total Sales | 212201  Sales in Cnty out BL | 0 |  | -1733.7 | -1240.35 | -351.6 | -110.2 | -2430 | 0
212401  Sales out Cnt to PPE*        Total Sales | 212401  Sales out Cnt to PPE | 0 |  | -60908.63 | -33634.76 | -73039.41 | -15176.61 | -56263 | -81248.35
212701  Sales other group*        Total Sales | 212701  Sales other group |  |  | 0 | 0 | 0 | 0 | 0.35 | 0.46
212708  Energy Surcharge Int*        Total Sales | 212708  Energy Surcharge Int | -55900 |  | -34815.14 | -37124.26 | -56839.38 | -46362.4 | -46692.81 | -47657.47
213011  External Sales*        Total Sales | 213011  External Sales | -7464600 |  | -290865.69 | -350855.77 | -317479.35 | -231376.33 | -455140.94 | -287934.78
213519  Energy Surcharge Ext*        Total Sales | 213519  Energy Surcharge Ext | -503099 |  | -52900.88 | -53266.09 | -73137.58 | -41490.57 | -83729.92 | -63618.19
213534  Sundry Sales*        Total Sales | 213534  Sundry Sales
213544  Other Income - Revenue*        Total Sales | 213544  Other Income - Revenue
*        Total Sales*        Total Sales | *        Total Sales | -8853000 |  | -650783.9800000001 | -668712.5 | -813863.6399999999 | -580549.44 | -947889.67 | -759976.04
612114  Finished Gds PC Revv*        Inter Segmental Transfers | 612114  Finished Gds PC Revv | 0 |  | -53388 | -64239 | -87757 | -106099 | -73079 | -57594
*        Inter Segmental Transfers*        Inter Segmental Transfers | *        Inter Segmental Transfers | 0 |  | -53388 | -64239 | -87757 | -106099 | -73079 | -57594
**       Gross Segmental Sales**       Gross Segmental Sales | **       Gross Segmental Sales | -8853000 |  | -704171.9800000001 | -732951.5 | -901620.6399999999 | -686648.44 | -1020968.67 | -817570.04 |  | -4863931.27
Spreadsheet: 747169d1631266825-lookup-details-in-sheet-2-return-information-upgrades-pricingupdate_testing
Sheet: Sheet1

Azure Region | Company | Application | Subscription | Resource Group Name | Service | Service Name | [NAME] | sku Family | skuCode/Name | sku [NAME] | Runtime Stack | OS | Current Est Monthly Cost | [NAME] | upgrade ProudctName | Type | Est Monthly Cost | Currency Code
SA North |  |  | Production |  | ASP-zanetrgemtp001-b3a9 |  | Standard |  | S1 |  | PHP 7.4 | Windows | $106,58 | I13
SA North |  |  | Production |  | Azure Database for MySQL Server |  | Basic | Gen5 | B_Gen5_1 | 5120 |  |  | $34,09
Spreadsheet: 140934d1328970091-excel-2007-multiple-indentical-lookups-required-from-table-array-excel-forum-help
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69598301