tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 122703d1317079772-summing-values-based-on-a-dynamic-date-range-3month_sum
Sheet: Summary1

Month | Total | PartA | % Met | Target |  | Month | Total | PartB | % Met | Target
2010-04-01 00:00:00 | 29897 |  |  |  |  | 2010-04-01 00:00:00 | 29907
2010-05-01 00:00:00 | 35192 |  | 0.9721546961325966 |  |  | 2010-05-01 00:00:00 | 35202 |  | 0.9721546961325966
2010-06-01 00:00:00 | 35365 |  | 0.98 |  |  | 2010-06-01 00:00:00 | 35375 |  | 0.98
2010-07-01 00:00:00 | 28803 |  | 0.98 |  |  | 2010-07-01 00:00:00 | 28813 |  | 0.98
2010-08-01 00:00:00 | 28013 |  | 0.98 |  |  | 2010-08-01 00:00:00 | 28023 |  | 0.98
2010-09-01 00:00:00 | 27343 |  | 0.97 |  |  | 2010-09-01 00:00:00 | 27353 |  | 0.97
2010-10-01 00:00:00 | 30088 |  | 0.97 |  |  | 2010-10-01 00:00:00 | 30098 |  | 0.97
2010-11-01 00:00:00 | 28295 |  | 0.97 |  |  | 2010-11-01 00:00:00 | 28305 |  | 0.97
2010-12-01 00:00:00 | 32194 |  | 0.95 |  |  | 2010-12-01 00:00:00 | 32204 |  | 0.95
2011-01-01 00:00:00 | 31690 |  | 0.98 |  |  | 2011-01-01 00:00:00 | 31700 |  | 0.98
2011-02-01 00:00:00 | 28039 |  | 0.98 |  |  | 2011-02-01 00:00:00 | 28049 |  | 0.98
2011-03-01 00:00:00 | 33277 |  | 0.92 |  |  | 2011-03-01 00:00:00 | 33287 |  | 0.92
2011-04-01 00:00:00 | 30455 |  | 0.9788198238734974 |  |  | 2011-04-01 00:00:00 | 30465 |  | 0.9788198238734974
2011-05-31 00:00:00 | 33092 |  | 0.9899485461289936 |  |  | 2011-05-31 00:00:00 | 33102 |  | 0.9899485461289936
2011-06-30 00:00:00 | 31650 |  | 0.9852446768771013 |  |  | 2011-07-31 00:00:00 | 26072 |  | 0.9809914555651749
2011-07-31 00:00:00 | 26062 |  | 0.9809914555651749 |  |  | 2011-08-31 00:00:00 | 26990 |  | 0.9761921991461032
2011-08-31 00:00:00 | 26980 |  | 0.9761921991461032
Spreadsheet: 692004d1598008728-calculating-ltd-and-etc-using-multiple-data-excel-issues
Sheet: Sheet1

 | LTD | ETC |  |  |  |  |  |  |  |  | A | A | A | A | A | F | F | F | F
1 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
2 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
3 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
4 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
5 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
6 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
7 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 3 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 3 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 4 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 6 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 7 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 7 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Spreadsheet: 1fac6836-a801-463b-af57-d4c2ad97a689
Sheet: F - Segment Information

BEST BUY CO., INC.
SEGMENT INFORMATION
Financials Recast for New Fiscal Year
($ in millions)
([NAME] and subject to reclassification)
 | Fiscal Year 2011 |  |  |  |  | Fiscal Year 2012
 | Q1 | Q2 | Q3 | Q4 | Year | Q1 | Q2 | Q3 | Q4 | Year
 | 2010-05-01 00:00:00 | 2010-07-31 00:00:00 | 2010-10-30 00:00:00 | 2011-01-29 00:00:00 | 2011-01-29 00:00:00 | 2011-04-30 00:00:00 | 2011-07-30 00:00:00 | 2011-10-29 00:00:00 | 2012-01-28 00:00:00 | 2012-01-28 00:00:00
DOMESTIC SEGMENT PERFORMANCE SUMMARY
Revenue | 8511 | 8185 | 7938 | 12611 |  | 8392 | 7977 | 8055 | 12583
Gross profit | 2117 | 2119 | 2087 | 2969 |  | 2147 | 2026 | 2033 | 2810
SG&A | 1734 | 1759 | 1758 | 1954 |  | 1776 | 1787 | 1784 | 1905
Operating income | 383 | 360 | 329 | 988 |  | 366 | 239 | 249 | 888
Key Metrics:
Comparable store sales % change(1)
Gross profit as % of revenue
SG&A as % of revenue
Operating income as % of revenue
Adjusted (non-GAAP) Key Metrics:
Gross profit as % of revenue(2)
SG&A as % of revenue(2)
Operating income(2)
Operating income as % of revenue(2)
INTERNATIONAL SEGMENT PERFORMANCE SUMMARY
Revenue | 2811 | 2717 | 3043 | 4086 |  | 2977 | 2879 | 3090 | 4088
Gross profit | 738 | 707 | 788 | 991 |  | 774 | 736 | 820 | 1044
SG&A | 693 | 676 | 686 | 748 |  | 681 | 715 | 688 | 831
Operating income (loss) | 45 | 31 | 102 | 135 |  | 94 | 21 | 132 | -1009
Key Metrics:
Comparable store sales % change(1)
Gross profit as % of revenue
SG&A as % of revenue
Operating income (loss) as % of revenue
Adjusted (non-GAAP) Key Metrics:
Gross profit as % of revenue(2)
SG&A as % of revenue(2)
Operating income(2)
Operating income as % of revenue(2)
(1) Best Buy’s comparable store sales is comprised of revenue at stores, call centers, and Web sites operating for at least 14 full months as well as  revenue related to other comparable sales channels. Relocated, remodeled and expanded stores are excluded from the comparable store sales calculation until at least 14 full months after reopening. Acquired stores are included in the comparable store sales calculation beginning with the first full quarter following the first anniversary of the date of the acquisition. The portion of the calculation of the comparable store sales percentage change attributable to the International segment excludes the effect of fluctuations in foreign currency exchange rates. The method of calculating comparable store sales varies across the retail industry. As a result, [NAME] method of calculating comparable store sales may not be the same as other retailers’ methods.
(2) Domestic segment excludes the impact of previously announced restructuring charges. International segment excludes the impact of previously announced restructuring charges, Best Buy Europe transaction costs and goodwill impairment. Please see worksheet titled “Non-GAAP Reconciliation.”
Spreadsheet: 726268d1617133647-formula-to-sum-data-from-table-production-stock-calculation
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Stock Level
Priority | Customer | Alcohol | Amount | [NAME] (cl) | Bottle | Cork | ABV | Duty | Liquid Req (3%) | Bottles | Corks | Boxes |  |  | Bottles | Corks | Boxes
1 | [NAME] | [NAME] | 800 | 50 | Nocturn | 6301 | 0.4 |  |  |  |  |  |  |  | 880 | 800 | 2000
2 | [NAME] | [NAME] | 600 | 50 | Nocturn | 6301 | 0.25
3 | [NAME] | [NAME] | 600 | 50 | Nocturn | 6301 | 0.25
4 | [NAME] | Vodka | 1000 | 70 | Nocturn | 6303 | 0.4
5 | [NAME] | Vodka | 500 | 5 | Apex | 6302 | 0.2
6
7
8
9
10
11
12
13
14
15
[NAME]
[NAME]
Spreadsheet: 821906d1678982440-time-by-name-drop-down-list-example-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper Column
Task | Lead | Start Date | End Date | Start Time | End Time | Total Time |  | Pipe Time Tracking |  |  | Start Date | End Date | Start Time | End Time | Total Time
10" 90° Elbows | [NAME] |  |  |  |  |  |  | 60" - 20' Pipe |  |  | 2023-02-17 00:00:00 | 2023-03-13 00:00:00 | 10:00:00 | 10:40:00
 |  | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 07:40:00 | 10:00:00
 |  | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 12:50:00 | 16:05:00
 |  | 2023-02-02 00:00:00 | 2023-02-02 00:00:00 | 07:42:00 | 13:25:00
 |  | 2023-02-07 00:00:00 | 2023-02-07 00:00:00 | 10:45:00 | 16:20:00 |  |  |  |  |  | [NAME]
 |  | 2023-02-08 00:00:00 | 2023-02-08 00:00:00 | 06:35:00 | 16:30:00
 |  | 2023-02-09 00:00:00 | 2023-02-09 00:00:00 | 06:42:00 | 16:30:00
 |  | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 | 06:30:00 | 15:30:00
 |  | 2023-02-13 00:00:00 | 2023-02-13 00:00:00 | 06:40:00 | 15:10:00
 |  | 2023-02-14 00:00:00 | 2023-02-14 00:00:00 | 15:00:00 | 16:30:00
 |  | 2023-02-15 00:00:00 | 2023-02-15 00:00:00 | 06:30:00 | 11:00:00
 |  | 2023-02-21 00:00:00 | 2023-02-21 00:00:00 | 15:25:00 | 16:30:00
 |  | 2023-02-22 00:00:00 | 2023-02-22 00:00:00 | 06:40:00 | 13:45:00
6" 90° Elbows | [NAME]
 |  | 2023-02-07 00:00:00 | 2023-02-07 00:00:00 | 13:50:00 | 14:50:00
4" 90° Elbows | [NAME]
 |  | 2023-02-07 00:00:00 | 2023-02-07 00:00:00 | 14:50:00 | 15:45:00
60" Elbows | [NAME]
 |  | 2023-03-02 00:00:00 | 2023-03-02 00:00:00 | 09:50:00 | 15:20:00
 |  | 2023-03-06 00:00:00 | 2023-03-06 00:00:00 | 14:30:00 | 16:30:00
 |  | 2023-03-07 00:00:00 | 2023-03-07 00:00:00 | 07:30:00 | 15:50:00
 |  | 2023-03-08 00:00:00 | 2023-03-08 00:00:00 | 07:30:00 | 14:10:00
Welding | [NAME]
 |  | 2023-02-24 00:00:00 | 2023-02-24 00:00:00 | 08:30:00 | 10:30:00
 |  | 2023-02-24 00:00:00 | 2023-02-24 00:00:00 | 12:30:00 | 15:00:00
 |  | 2023-03-02 00:00:00 | 2023-03-02 00:00:00 | 08:10:00 | 08:20:00
 |  | 2023-03-02 00:00:00 | 2023-03-02 00:00:00 | 09:45:00 | 16:10:00
 |  | 2023-03-06 00:00:00 | 2023-03-06 00:00:00 | 08:10:00 | 16:25:00
 |  | 2023-03-07 00:00:00 | 2023-03-07 00:00:00 | 08:10:00 | 16:30:00
 |  | 2023-02-09 00:00:00 | 2023-02-09 00:00:00 | 09:00:00 | 15:00:00
 |  | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 | 08:20:00 | 11:50:00
Spreadsheet: 886014d1735954057-pull-number-from-column-with-other-text-sats-1
Sheet: Sheet1

1d ago
+ 2 sats |  |  |  |  |  |  |  | 2 | Sats
1d ago
+ 4 sats |  |  |  |  |  |  |  | 4
1d ago
+ 4 sats |  |  |  |  |  |  |  | 4
2d ago
+ 385 sats |  |  |  |  |  |  |  | 385
2d ago
+ 4 sats |  |  |  |  |  |  |  | 4
2d ago
+ 4 sats |  |  |  |  |  |  |  | 4
2d ago
+ 15 sats |  |  |  |  |  |  |  | 15
Spreadsheet: 77337d1277831998-formula-calculation-based-on-yes-no-list-quote_analyser2-1-
Sheet: 05-07-10

Job # | Quote Value | Sector | Description | Job Won | Sectors | Job Won |  | Building |  |  |  |  |  | LandScaping
1 | 200 | Building |  | Yes | Building | Yes
2 | 200 | Building |  |  | Landscaping | No
3 | 200 | Landscaping |  | No
4 | 200 | Building |  | Yes
5 | 200 | Landscaping
6 | 200
7 | 200 | Landscaping |  | Yes
8 | 200
9 | 200
10 | 200
13 | 200
Spreadsheet: phillip_m_love__30020__STORAGE
Sheet: JAN00GULFCOAST

NGPL GULF COAST STORAGE
 | K#114786 |  |  |  | K#114846
 | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl
[NAME] | 1054402 |  |  |  | 994695
2000-01-01 00:00:00 | 0 | -2056 | 0 | -13736 | 0 | -13333 | 0 | 0
2000-01-02 00:00:00 | 0 | -2056 | 0 | -13736 | 0 | -13333 | 0 | 0
2000-01-03 00:00:00 | 0 | -2056 | 0 | -13736 | 0 | -13333 | 0 | 0
2000-01-04 00:00:00 | 0 | -2056 | 0 | -13736 | 0 | -13333 | 0 | 0
2000-01-05 00:00:00 | 0 | -2056 | 0 | -13736 | 0 | -1953 | 0 | 0
2000-01-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-16 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-17 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-19 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-20 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-21 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-22 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2000-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Balance
MWQ | 1371225 |  |  |  | 999975
Diff Stor Bal & MWQ
Total Combined Balance
Spreadsheet: 55628d1255719139-dual-lookup-vlookup-match-criteria-dual-lookup
Sheet: Data

ID | Brand | instant | overall | upsell 1 | upsell 2
TMDF | RT | 0.256 | 0.325 | 0.245 | 0.245
TMDF | [NAME] | 0.4321 | 0.328 | 0.3554 | 0.245
WQBD | RT | 0.205 | 0.148 | 0.245 | 0.245
WQBD | [NAME] | 0.3899 | 0.1258 | 0.24 | 0.3547
HAQC | RT | 0.139 | 0.36547 | 0.13 | 0.245
HAQC | [NAME] | 0.12 | 0.259 | 0.214 | 0.254
YXXX | RT | 0.745 | 0.2453 | 0.145 | 0.2145
YXXX | [NAME] | 0.5 | 0.368 | 0.245 | 0.254
PPYH | RT | 0.25 | 0.257 | 0.34 | 0.245
PPYH | [NAME] | 0.28 | 0.548 | 0.257 | 0.215
SPKL | RT | 0.298 | 0.624 | 0.524 | 0.215
SPKL | [NAME] | 0.297 | 0.325 | 0.24 | 0.35
FGTY | RT | 0.338 | 0.3205 | 0.235 | 0.25
FGTY | [NAME] | 0.324 | 0.242 | 0.245 | 0.255
Spreadsheet: lynn_blair__24418__FERC docket RM01-9_Aug2001a
Sheet: Item 2 - PQ2TRANSW080101

Seq # | PHC | Pipeline DUNS # | Pipeline Name | Filing Date | First Day of Reporting Period | Name of Contact Person | Phone Number of Contact Person | Original/Revised Filing Indicator
Seq # | PDC | Pipeline DUNS # | Contract or Transaction ID # | Offer # | Releasing Shipper Name | Releasing Shipper DUNS # | Acquiring Shipper Name | Acquiring Shipper DUNS # | Contract Quantity | Releasing Shipper's Contract Rate | Acquiring Shipper's Contract Rate | Term Begin Date | Term End Date | Award Date
1 | PHC | 007933047 | Transwestern Pipeline Company | 2001-09-30 00:00:00 | 2001-08-01 00:00:00 | [NAME] | (402) 398-7060 | O
 | PDC | 007933047 | 21165 | 3020 | Pacific Gas and Electric Company | 025301339 | Sempra Energy Trading Corp. | 609746565 | 15000 | 0.3138 | 1.0177 | 2001-05-01 00:00:00 | 2001-10-31 00:00:00 | 2000-12-27 00:00:00
 | PDC | 007933047 | 21165 | 3067 | Pacific Gas and Electric Company | 025301339 | Texaco Natural Gas, Inc. | 183333145 | 50000 | 0.3138 | 0.6008 | 2001-06-01 00:00:00 | 2001-10-01 00:00:00 | 2001-04-06 00:00:00
 | PDC | 007933047 | 21165 | 3072 | Pacific Gas and Electric Company | 025301339 | PG&E Energy Trading-Gas Corporation | 834692394 | 60000 | 0.3138 | 0.5767 | 2001-07-01 00:00:00 | 2001-10-31 00:00:00 | 2001-04-20 00:00:00
 | PDC | 007933047 | 8255 | 3111 | Southern California Gas Company | 006908826 | ACN Power, Inc. | 059091384 | 481 | 0.4006 | 0.4006 | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 | 2001-07-24 00:00:00
 | PDC | 007933047 | 8255 | 3112 | Southern California Gas Company | 006908826 | Sempra Energy Solutions, LLC | 968254276 | 208 | 0.4006 | 0.4006 | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 | 2001-07-24 00:00:00
 | PDC | 007933047 | 8255 | 3113 | Southern California Gas Company | 006908826 | Exelon Energy Ohio, Inc. | 079333451 | 306 | 0.4006 | 0.4006 | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 | 2001-07-24 00:00:00
 | PDC | 007933047 | 8255 | 3114 | Southern California Gas Company | 006908826 | Enron Energy Services, Inc. | 004328568 | 2314 | 0.4006 | 0.4006 | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 | 2001-07-24 00:00:00
 | PDC | 007933047 | 8255 | 3115 | Southern California Gas Company | 006908826 | Enron Energy Services, Inc. | 004328568 | 11 | 0.4006 | 0.4006 | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 | 2001-07-24 00:00:00
 | PDC | 007933047 | 8255 | 3116 | Southern California Gas Company | 006908826 | Enron Energy Services, Inc. | 004328568 | 7 | 0.4006 | 0.4006 | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 | 2001-07-24 00:00:00
 | PDC | 007933047 | 8255 | 3117 | Southern California Gas Company | 006908826 | TXU Energy Trading California | 848757274 | 1267 | 0.4006 | 0.4006 | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 | 2001-07-24 00:00:00
 | PDC | 007933047 | 21165 | 3119 | Pacific Gas and Electric Company | 025301339 | BP Energy Company | 625275755 | 25000 | 0.3138 | 1.13 | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 | 2001-07-27 00:00:00
Spreadsheet: 703287d1604932803-extract-values-in-a-column-excluding-blanks-extract-values
Sheet: Okay

Sales ID | Company | Date | Sales Associates | Sales City Designation | Retrun 1,0
777777777 | 3Wala | 1999 | [NAME] |  | 1
777777777 | 3Wala | 1999 | Peo |  | 1
777777777 | 3Wala | 1999 | Wilo |  | 1
777777777 | 3Wala | 1999 |  |  | 1
777777777 | 3Wala | 1999 |  |  | 1
777777777 | 3Wala | 1999 |  |  | 1
777777777 | 3Wala | 1999 |  |  | 1
777777777 | 3Wala | 1999 |  |  | 1
777777777 | 3Wala | 1999 |  |  | 1
777777777 | 3Wala | 1999 |  |  | 1
777777777 | 3Wala | 2000 | [NAME] |  | 1
777777777 | 3Wala | 2000 | Peo |  | 1
777777777 | 3Wala | 2000 |  |  | 1
777777777 | 3Wala | 2000 |  |  | 1
777777777 | 3Wala | 2000 |  |  | 1
777777777 | 3Wala | 2000 |  |  | 1
777777777 | 3Wala | 2000 |  |  | 1
777777777 | 3Wala | 2000 |  |  | 1
777777777 | 3Wala | 2000 |  |  | 1
777777777 | 3Wala | 2000 |  |  | 1
777777777 | 3Wala | 2001 | [NAME] |  | 1
777777777 | 3Wala | 2001 | [NAME] |  | 1
777777777 | 3Wala | 2001 | Ganio |  | 1
777777777 | 3Wala | 2001 | Dina |  | 1
777777777 | 3Wala | 2001 | Lang |  | 1
777777777 | 3Wala | 2001 | Clarios |  | 1
777777777 | 3Wala | 2001 |  |  | 1
777777777 | 3Wala | 2001 |  |  | 1
777777777 | 3Wala | 2002 |  |  | 1
777777777 | 3Wala | 2002 | Ganio |  | 1
777777777 | 3Wala | 2002 | Lang |  | 1
777777777 | 3Wala | 2002 | Clarios |  | 1
777777777 | 3Wala | 2002 | Redio |  | 1
777777777 | 3Wala | 2002 | Credo |  | 1
777777777 | 3Wala | 2003 | [NAME] |  | 1
777777777 | 3Wala | 2003 | Ganio |  | 1
777777777 | 3Wala | 2003 | Lang |  | 1
777777777 | 3Wala | 2003 | Clarios |  | 1
777777777 | 3Wala | 2003 | Redio |  | 1
887333444 | Forg | 1999 | Forg, [NAME] |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 1999 |  |  | 1
887333444 | Forg | 2000 |  |  | 1
887333444 | Forg | 2000 |  |  | 1
887333444 | Forg | 2000 |  |  | 1
887333444 | Forg | 2000 |  |  | 1
887333444 | Forg | 2000 |  |  | 1
887333444 | Forg | 2000 |  |  | 1
887333444 | Forg | 2000 |  |  | 1
887333444 | Forg | 2000 |  |  | 1
887333444 | Forg | 2000 | Door, Trial J. |  | 1
887333444 | Forg | 2000 | Long, [NAME] |  | 1
700000000 | Gone | 2001 | Apple, Letter M. |  | 0
700000000 | Gone | 2001 | Bannana, [NAME] |  | 0
700000000 | Gone | 2001 | Orange, [NAME] |  | 0
700000000 | Gone | 2001 | Grape, [NAME] |  | 0
700000000 | Gone | 2001 | Mango, [NAME] |  | 0
700000000 | Gone | 2002 | Batter, [NAME] |  | 0
700000000 | Gone | 2002 | Beancurd, [NAME] |  | 0
700000000 | Gone | 2002 | Beans, [NAME] |  | 0
700000000 | Gone | 2002 | Beef, [NAME] |  | 0
Spreadsheet: 769491d1645556296-predict-linear-voorspellen-linear-vb-
Sheet: Blad1

Maand | 140010 | 140002 | 140003 | 140004 | 140001 | 140014 | 140015 | 140008 | 140041 | 140042 | 140026 | 140043 | 140028 | 140011 | 140012 | 140019 | 140025 | 140024 | 140009 | 140029 | 140036 | 140037 | 140083 | 140082 | 140039 | 140040 | 140044 | 140070 | 140071 | 140072 | 140073 | 140074 | 171006 | 171001 | 171002 | 171003 | 171004 | 171005 | 140047 | 140048 | 140049 | 140050 | 195020 | 195021 | 140051 | 140052 | 140053 | 140054 | 140084
6 | 57 | 293 | 92 | 38 | 260 | 78 | 29 | 5 | 61 | 3 | 2 | 0 | 1 | 3 | 3 | 9 | 13
7 | 79 | 101 | 55 | 44 | 236 | 48 | 52 | 15 | 5 | 7 | 5 | 5 | 10 | 4 | 14 | 9 | 17
8 | 42 | 223 | 26 | 47 | 249 | 54 | 6 | 5 | 66 | 3 | 1 | 5 | 6 | 11 | 0 | 6 | 2
9 | 46 | 124 | 55 | 46 | 225 | 114 | 62 | 1 | 1 | 7 | 1 | 2 | 11 | 7 | 3 | 13 | 4
10 | 51 | 180 | 53 | 49 | 240 | 49 | 44 | 17 | 3 | 6 | 2 | 4 | 4 | 4 | 2 | 20 | 0
11 | 78 | 205 | 51 | 77 | 352 | 99 | 42 | 25 | 66 | 7 | 6 | 2 | 1 | 6 | 3 | 42 | 15
12 | 54 | 244 | 84 | 71 | 217 | 61 | 49 | 15 | 48 | 9 | 16 | 2 | 9 | 6 | 2 | 45 | 11
1 | 90 | 276 | 55 | 99 | 230 | 76 | 30 | 17 | 129 | 14 | 4 | 4 | 8 | 3 | 3 | 25 | 35
2 | 49 | 114 | 70 | 37 | 312 | 114 | 56 | 25 | 2 | 1 | 0 | 1 | 2 | 5 | 0 | 14 | 3
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 77443d1277912394-extract-room-number-and-student-id-and-put-them-in-other-cells-studenthousing-3-
Sheet: 3707

Building No:- 3707 | Mrs. [NAME] | Mr. [NAME] | Mr. [NAME]
Date | RoomNo | RoomNo | RoomNo
2010-06-30 00:00:00 | 14C | 21B | 24B
OUTSTANDING
SATISFACTORY
UNSATISFACTORY
DOOR UNLOCKED
WINDOW UNLOCKED
LOCKER UNLOCKED
CARPET Not SWEPT
DUST
BEDS UNMADE
MESSY
MICROWAVE DIRTY
FREEZER DIRTY
REFRIGERATOR DIRTY
LIGHTS / APPLIANCES ON
CEILING FAN ON
OPEN FOOD NOT STORED
TRASH IN ROOM / HEAD
MIRROR / SHELF DIRTY
SINK / BRIGHTWORK DIRTY
FLOOR IN BATH DIRTY
TUB / SHOWER DIRTY
SHOWER CURTAIN DIRTY
TOILET DIRTY
ODOR
Dirty TILE
Spreadsheet: 104635d1302165049-long-if-statement-forum
Sheet: Sheet1

 |  |  | VALIDATION |  |  | January |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  | March
Jan Test 1 |  | Drag and copy this cell does not change "!$D8"
Jan Test 1
Jan Test 1
Jan Test 1
Jan Test 1
Jan Test 1
Jan Test 1
Jan Test 1
Jan Test 1
Number of categories added |  |  | 0 | 52
Number of clients added |  |  | 49
Spreadsheet: 724669d1616305524-sumifs-with-multiple-criteria-and-multiple-30-ranges-check-test
Sheet: Check

ID Code | &ANN | &PER | &CAR | &COM, &MIL, &DOM, &CORT |  | < Code to summarise in column by ID
469
2708
2786
3180
3387
4455
4840
5000
5110
6958
7502
9922
 | Individual Code | Individual Code | Individual Code | Combined Codes
 |  |  |  | 4 codes combined =formula 4 times as long.
 | 7.6 | 7.6 | 0 | 0
 | 0 | 0 | 0 | 9.6
 | 7.6 | 0 | 0 | 0
 | 0 | 0 | 7 | 0
 | 7.6 | 0 | 0 | 0
 | 0 | 7 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 5
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
Spreadsheet: 78e860fe-a9a6-4af5-a013-6333059056c6
Sheet: Winter Resident

Analytical Key | [NAME] (ABMI) | Species (Scientific Name) | Intactness (%) | Occurrence in the Boreal Plains Ecozone (%) | Relative to Reference | Threat
BlackcappedChickadee | Black-capped Chickadee | Poecile atricapillus | 98.863980453962 | 30.37 | Above | ESRD - Secure
BlueJay | [NAME] | Cyanocitta cristata | 99.834311144337 | 14.3 | Below | ESRD - Secure
BorealChickadee | Boreal Chickadee | Poecile hudsonica | 76.3833226604492 | 32.35 | Below | ESRD - Secure
BrownCreeper | [NAME] | Certhia americana | 74.2538270216494 | 6.3 | Below | ESRD - Sensitive
CommonRaven | [NAME] | Corvus corax | 97.944143163335 | 60.3 | Above | ESRD - Secure
EveningGrosbeak | Evening [NAME] | Coccothraustes vespertinus | 81.0266516087799 | 6.17 | Below | ESRD - Secure
GrayJay | [NAME] | Perisoreus canadensis | 84.3218238683208 | 82.83 | Below | ESRD - Secure
HairyWoodpecker | [NAME] | Picoides villosus | 96.4958856538474 | 8.69 | Below | ESRD - Secure
PileatedWoodpecker | [NAME] | Dryocopus pileatus | 99.255223433518 | 16.59 | Above | ESRD - Sensitive
RedbreastedNuthatch | Red-breasted Nuthatch | Sitta canadensis | 98.9766426713838 | 39.06 | Below | ESRD - Secure
RuffedGrouse | [NAME] | Bonasa umbellus | 72.3240930963704 | 23.2 | Below | ESRD - Secure
WhitewingedCrossbill | White-winged Crossbill | [NAME] leucoptera | 92.9384248887636 | 47.19 | Below | ESRD - Secure
 |  | Average Intactness
Spreadsheet: 728280d1618398911-index-match-formula-to-summarize-data-by-specific-column-information-sample-file
Sheet: Sheet1

Initial table
Quarter | 2 | 2 | 2 | 2 | 2 | 2 | 2
Month | Apr | Apr | Apr | Apr | Apr | Apr | Apr
Week | 13 | 13 | 14 | 14 | 14 | 14 | 14
Activity / Day | 2021-04-01 00:00:00 | 2021-04-02 00:00:00 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-07 00:00:00 | 2021-04-08 00:00:00 | 2021-04-09 00:00:00
Activity 1 |  |  | 2 | 1 | 2
Activity 2 |  | 2 |  | 3 |  | 2
Activity 3 |  |  | 1 |  | 2 |  | 2
Activity 4 |  | 2 |  |  | 1 | 3
Activity 5 |  |  | 1 |  |  |  | 2
Activity 6 | 5 |  |  | 2 |  | 1 | 2
Activity 7 |  |  |  | 1 | 1 |  | 1
Activity 8 |  | 2 | 3 |  |  | 1
Activity 9 |  | 2 |  | 1 | 2 |  | 1
Activity 10 | 3 |  | 1 |  |  | 1
Final table
 | Week
Activity | 14
Activity 1 | 5
Activity 2 | 7
Activity 3 | 5
Activity 4 | 6
Activity 5 | 3
Activity 6 | 10
Activity 7 | 3
Activity 8 | 6
Activity 9 | 6
Activity 10 | 5