tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1fac6836-a801-463b-af57-d4c2ad97a689
Sheet: D - Balance Sheet

BEST BUY CO., INC.
CONDENSED CONSOLIDATED BALANCE SHEETS
Historical Financials Recast for New Fiscal Year
($ in millions)
([NAME] and subject to reclassification)
 | Fiscal Year 2011 |  |  |  | Fiscal Year 2012
 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
 | 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-04-30 00:00:00 | 2011-07-30 00:00:00 | 2011-10-29 00:00:00 | 2012-01-28 00:00:00
ASSETS
Current assets
Cash and cash equivalents | 1748 | 915 | 724 | 1338 | 2793 | 2079 | 2073 | 1401
Short-term investments | 206 | 116 | 2 | 22 | 20 | 80 | 20 | 0
Receivables | 1538 | 1650 | 1770 | 2280 | 1713 | 1868 | 1968 | 2448
Merchandise inventories | 6021 | 6681 | 8416 | 7370 | 6508 | 6784 | 7780 | 6803
Other current assets | 1095 | 1091 | 1075 | 1040 | 1135 | 1080 | 1098 | 827
Total current assets
Net property & equipment | 4021 | 3937 | 3963 | 3809 | 3797 | 3781 | 3697 | 3491
Goodwill | 2408 | 2392 | 2441 | 2443 | 2506 | 2507 | 2447 | 1328
Tradenames | 155 | 150 | 145 | 132 | 136 | 136 | 131 | 129
Customer relationships | 248 | 229 | 220 | 203 | 194 | 179 | 165 | 229
Equity and other investments | 340 | 297 | 316 | 333 | 316 | 316 | 279 | 142
Other assets | 475 | 463 | 409 | 384 | 454 | 486 | 469 | 447
TOTAL ASSETS
LIABILITIES & EQUITY
Current liabilities
Accounts payable | 5698 | 5935 | 7573 | 6604 | 6102 | 6178 | 7557 | 6858
Accrued liabilities | 2923 | 2456 | 2419 | 2767 | 2884 | 2526 | 2549 | 2869
Short-term debt | 197 | 383 | 586 | 557 | 39 | 392 | 163 | 480
Current portion of long-term debt | 34 | 33 | 27 | 441 | 442 | 444 | 442 | 46
Total current liabilities
Long-term liabilities | 1243 | 1252 | 1196 | 1154 | 1179 | 1168 | 1161 | 1065
Long-term debt | 1101 | 1092 | 1084 | 692 | 1704 | 1701 | 1692 | 1685
Equity | 7059 | 6770 | 6596 | 7139 | 7222 | 6887 | 6563 | 4242
TOTAL LIABILITIES & EQUITY
Spreadsheet: 2995754b-008f-47cd-98a8-ea8eff59ca48
Sheet: Sheet1

Table 8--Oilseed prices received by U.S. farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybeans2 | Cottonseed3 | Sunflowerseed2 | Canola4 | Peanuts3 | Flaxseed4
year
 | $/bushel | $/short ton | $/cwt. | $/cwt. | Cents/pound | $/bushel
2003/04 | 7.34 | 117 | 12.1 | 10.6 | 19.3 | 5.88
2004/05 | 5.74 | 107 | 13.7 | 10.7 | 18.9 | 8.07
2005/06 | 5.66 | 96 | 12.1 | 9.62 | 17.3 | 5.94
2006/07 | 6.43 | 111 | 14.5 | 11.9 | 17.7 | 5.8
2007/08 | 10.1 | 162 | 21.7 | 18.3 | 20.5 | 13
2008/09 | 9.97 | 223 | 21.8 | 18.7 | 23 | 12.7
2009/10 | 9.59 | 158 | 15.1 | 16.2 | 21.7 | 8.15
2010/11 | 11.3 | 161 | 23.3 | 19.3 | 22.5 | 12.2
2011/12 | 12.5 | 260 | 29.1 | 24 | 31.8 | 13.9
2012/13 | 14.4 | 252 | 25.4 | 26.5 | 30.1 | 13.8
2013/141 | 12.20-13.70 | 230-270 | 20.25-22.75 | 18.05-20.55 | 22.75-25.25 | 12.75-14.25
2012/13
September | 14.3 | 254 | 28.9 | 26.5 | 35.2 | 13.3
October | 14.2 | 254 | 26.3 | 27 | 33.7 | 13.6
November | 14.3 | 255 | 26.7 | 26.7 | 32.6 | 14.1
December | 14.3 | 252 | 24.8 | 27.1 | 36.9 | 13.8
January | 14.3 | 249 | 26.3 | 26.8 | 31.2 | 13.7
February | 14.6 | 217 | 26.1 | 27.8 | 28.2 | 14.3
March | 14.6 |  | 24.6 | 27.3 | 27.8 | 14.4
April | 14.4 |  | 24.8 | 27.5 | 26.8 | 14.9
May | 14.9 |  | 24 | 28 | 27.1 | 15.4
June | 15.1 |  | 24.4 | 27.4 | 27 | 15.2
July | 15.3 |  | 23.7 | 26.2 | 24.2 | 15.1
August | 14.1 |  | 23.7 | 22.2 | 25.1 | 14.9
2013/14
September | 13.3 | 190 | 22.6 | 20.7 | 25.5 | 13.1
October | 12.5 | 281 | 23 | 21 | 26 | 13.5
November | 12.7 | 248 | 20.8 | 20.4 | 26.6 | 13.4
December | 13 | 246 | 18.8 | 21.2 | 24.6 | 13.5
January | 12.9 | 230 | 20.3 | 18.4 | 25.4 | 13.3
February1 | 13.1 | 227 | 22.6 | 17.3 | 22.8 | 13
1 Preliminary.  2 September-August.  3August-July. 4 July-June.
NA = Not available. |  | cwt.=hundredweight.
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Last update: | 2014-03-11 21:12:49.590000
Spreadsheet: 484937d1476598695-select-from-a-dropdown-list-to-enter-data-in-other-cells-basketball-score-sheet-basketball-
Sheet: Sheet2

Teams
 | Team 1 |  | Team 2 |  | Team 3 |  | Team 4 |  | Team 5 |  | Team 6 |  | Team 7 |  | Team 8 |  | Team 9
1 | Player 1 | 1 | Player 1 | 1 | Player 1 | 1 | Player 1 | 1 | Player 1 | 1 | Player 1 | 1 | Player 1 | 1 | Player 1 | 1 | Player 1
2 | Player 2 | 2 | Player 2 | 2 | Player 2 | 2 | Player 2 | 2 | Player 2 | 2 | Player 2 | 2 | Player 2 | 2 | Player 2 | 2 | Player 2
3 | Player 3 | 3 | Player 3 | 3 | Player 3 | 3 | Player 3 | 3 | Player 3 | 3 | Player 3 | 3 | Player 3 | 3 | Player 3 | 3 | Player 3
4 | Player 4 | 4 | Player 4 | 4 | Player 4 | 4 | Player 4 | 4 | Player 4 | 4 | Player 4 | 4 | Player 4 | 4 | Player 4 | 4 | Player 4
5 | Player 5 | 5 | Player 5 | 5 | Player 5 | 5 | Player 5 | 5 | Player 5 | 5 | Player 5 | 5 | Player 5 | 5 | Player 5 | 5 | Player 5
6 | Player 6 | 6 | Player 6 | 6 | Player 6 | 6 | Player 6 | 6 | Player 6 | 6 | Player 6 | 6 | Player 6 | 6 | Player 6 | 6 | Player 6
7 | Player 7 | 7 | Player 7 | 7 | Player 7 | 7 | Player 7 | 7 | Player 7 | 7 | Player 7 | 7 | Player 7 | 7 | Player 7 | 7 | Player 7
8 | Player 8 | 8 | Player 8 | 8 | Player 8 | 8 | Player 8 | 8 | Player 8 | 8 | Player 8 | 8 | Player 8 | 8 | Player 8 | 8 | Player 8
9 | Player 9 | 9 | Player 9 | 9 | Player 9 | 9 | Player 9 | 9 | Player 9 | 9 | Player 9 | 9 | Player 9 | 9 | Player 9 | 9 | Player 9
10 | Player 10 | 10 | Player 10 | 10 | Player 10 | 10 | Player 10 | 10 | Player 10 | 10 | Player 10 | 10 | Player 10 | 10 | Player 10 | 10 | Player 10
Spreadsheet: 39c42ebc-c8bc-46dc-a17f-5ec838ffd5bb
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0018755 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Castle Bay WWTF | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Pender | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4
 |  |  |  |  |  | Area (acres): |  | 6.15 |  | Area (acres): |  | 8.82 |  | Area (acres): |  | 5 |  | Area (acres): |  | 6.7
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5
 |  |  |  |  |  | Annual Rate (in): |  | 31.27 |  | Annual Rate (in): |  | 31.27 |  | Annual Rate (in): |  | 31.27 |  | Annual Rate (in): |  | 31.27
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 886340d1736358176-if-multiple-options-excel-forum-2025-01-08
Sheet: Sheet1

 |  | Plastering Ceilings | Plaster walls Linear M | [NAME] m2 | Ceiling Plaster  area | Ceiling plaster double plaster board layer  (allow 25mm gap) | mineral wool insulation (10kg/m3 density) | Floor | Room | Ares M2
 |  |  | 0 | 0 |  |  |  | House front | Front Facade
 |  |  | 0 | 0 |  |  |  | LGF:- | Front Area  External | 5
 |  |  | 15 | 39 | 13 | 1 | 1 | LGF:- | Bed 1  - | 13
 |  |  | 39 | 11 | 11 |  |  | LGF:- | Bed 2  - | 11
 |  |  |  |  |  |  |  | LGF:- | Lightwell -
 |  |  | 0 | 0 |  |  |  | House front | Front Facade
 |  |  | 0 | 0 |  |  |  | LGF:- | Front Area  External
 |  | [NAME] Ceiling Plaster  area 13m²  'Ceiling plaster double plaster boardd layer  (allow 25mm gap)  mineral wool insulation (10kg/m3 density) | 15 | 39 | 13 | 1 | 1 | LGF:- | Bed 1  -
 |  |  | 0 | 0 | 0 |  |  | LGF:- | Bed 1  -
 |  | LGF:-Lightwell - Ceiling Plaster  area3m² | 0 | 0 | 3 |  |  | LGF:- | Lightwell -
 |  | I need to be able to include the headings if there is  a 1 in the column below Column G. If there is not then as in c5. When no entry in column F then no entry at all
 |  | Or anaother way I need to have one foumulae for all the possible options.
Spreadsheet: 116311d1311743083-excel-2007-countifs-to-gather-data-from-multiple-sheets-based-on-multiple-criteria-ratings-of-surveys
Sheet: ANALYSIS 2

 | HR POC NUMBER | [NAME]
 | SURVEY NAME | Recruitment Feedback Survey
 | DATE FROM | 2011-02-25 00:00:00
 | DATE TO | 2011-03-03 00:00:00
Q1 | FIELDS | Too early to tell | Requires Improvement | Developing as required | Fully Demonstrated | No Rating | Total
 |  | 1 | 2 | 3 | 4
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Total Per Rating
 | Percentage
Q2 | FIELDS | Too early to tell | Requires Improvement | Developing as required | Fully Demonstrated | No Rating | Total
 |  | 1 | 2 | 3 | 4
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Total Per Rating
 | Percentage
Q3 | FIELDS | Too early to tell | Requires Improvement | Developing as required | Fully Demonstrated | No Rating | Total
 |  | 1 | 2 | 3 | 4
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Total Per Rating
 | Percentage
Q4 | FIELDS | Too early to tell | Requires Improvement | Developing as required | Fully Demonstrated | No Rating | Total
 |  | 1 | 2 | 3 | 4
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Total Per Rating
 | Percentage
Spreadsheet: 150035d1334253690-pivot-help-required-example-file-attached-book1-1-
Sheet: Sheet1

Category | Status | Volume
ABC | Assigned | 1 |  | Sum of Volume | Column Labels
DEF | Assigned | 32 |  | Row Labels | Assigned | Closed | In Prog | New | Resolved | Grand Total
GHI | Assigned | 2 |  | ABC | 5 | 7 |  | 23 | 10 | 45
JKL | In Prog | 2 |  | DEF | 32 | 12 | 3 | 8 | 1 | 56
ABC | Assigned | 4 |  | GHI | 3 | 6 |  | 8 |  | 17
DEF | In Prog | 3 |  | JKL |  | 4 | 3 |  | 9 | 16
GHI | Closed | 6 |  | Grand Total | 40 | 29 | 6 | 39 | 20 | 134
JKL | Closed | 4
ABC | Closed | 7
DEF | New | 8
GHI | New | 8 |  |  | The above pivot currently shows the count of Assigned for ABC as 2
JKL | Resolved | 9
ABC | Resolved | 10 |  |  | I want it to show the sum of volume for ABC in assigned status. With the above as example ABC total volume in Assigned is 5
DEF | Resolved | 1
GHI | Assigned | 1 |  |  | So under assigned for ABC it should show 5 and not count as 2
JKL | In Prog | 1
ABC | New | 23
DEF | Closed | 12
Spreadsheet: 0ef4a3aa-24ba-4cf1-b444-613cc2697a0c
Sheet: Sheet1

HEALTH CARE PROPERTY INVESTORS | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
Please list in [NAME] (Skip Rows Between Entries) |  |  |  |  |  |  | ------------------------------------------------------------------------------------------$ Amounts per Each Share (to 6 places) of Stock Held on Record Date------------------------$ Amounts per Each Share (to 6 places) of Stock Held on Record Date--------------------------------------------------------------------------------------------
 |  |  |  |  |  |  |  | Year Taxable to Shareholders |  |  | Form 1099 Box 1 Breakdown |  |  | Box 1 Total | Box 2a | Box 2b | Box 2c | Box 2d | Box 2e |  | Box 3 | Box 6 | Box 8 | Box 9
 |  |  | Reclass | Estimated |  |  |  |  |  |  |  |  |  |  |  | Long Term Capital Gain Distributions
 |  |  | or | or |  |  | Total | [NAME]. [NAME]. (852(b)(7) |  |  |  |  | Foreign | Taxable | Total |  | Qualified | Unrecap |  | Long-Term |  | Foreign | Cash | Noncash | Exempt
Security |  | Ticker | Merger | Corrected | Record | Payable | Distribution | 2000 | 2002 | 2001 | Income | Short-term | Tax | Ordinary | Capital Gain | 28% Rate | 5 Year Gain | Sec. 1250 | Section 1202 | Rate Gain | Return of | Tax | Liquidation | Liquidation | Interest
Description | CUSIP | Symbol | (R or M) | (E or C) | Date | Date | Per Share | (Prior Year) | (Next Year) | (Current Year) | Dividends | Capital  Gain | Paid | Dividends | Distribution | Gain | (Included in 21) | Gain | Gain | (10 or 20%) | Capital | Paid | Distribution | Distribution | Dividends
(1) | (2) | (3) | (4) | (5) | (6) | (7) | (8)=(9)+(10)+(11) | (9) | (10) | (11)=(15)+(16)+(22)+(24) | (12) | (13) | (14) | (15)=(12)+(13) | (16)=(17)+(19)+(21) | (17) | (18) | (19) | (20) | (21) | (22) | (23) | (24) | (25) | (26)
Common |  | HCP |  |  | 2001-02-05 00:00:00 | 2001-02-20 00:00:00 | 0.76 |  |  | 0.76 | 0.4437 |  |  | 0.4437 |  |  |  |  |  |  | 0.3163
Common |  | HCP |  |  | 2001-05-03 00:00:00 | 2001-05-18 00:00:00 | 0.77 |  |  | 0.77 | 0.4495 |  |  | 0.4495 |  |  |  |  |  |  | 0.3205
Common |  | HCP |  |  | 2001-08-03 00:00:00 | 2001-08-20 00:00:00 | 0.78 |  |  | 0.78 | 0.4554 |  |  | 0.4554 |  |  |  |  |  |  | 0.3246
Common |  | HCP |  |  | 2001-11-02 00:00:00 | 2001-11-20 00:00:00 | 0.79 |  |  | 0.79 | 0.4612 |  |  | 0.4612 |  |  |  |  |  |  | 0.3288
Totals for 2001 |  |  |  |  |  |  |  |  |  | 3.1 | 1.8098 |  |  | 1.8098 |  |  |  |  |  |  | 1.2902
Spreadsheet: 236496d1368806544-sequence-conundrum-sequence_problem2
Sheet: Sheet1

GL Code | TB Group | Required Column | Explanation
5 | Cash | [NAME]
7 | Cash | Cash2
2 | Cash | Cash3
5 | Cash | [NAME] | 5 has already occurred within cash group so stays at 1
8 | Cheque | Cheque1
1 | Cheque | Cheque2
7 | Cheque | Cheque3
8 | Cheque | Cheque1 | 8 has already occurred within Cheque group so stays at 1
9 | Cash | Cash4
10 | Cash | Cash5
4 | Cash | Cash6
1 | Cheque | Cheque2 | 1 has already occurred within Cheque group so stays at 2
Spreadsheet: 151351d1334867311-sumif-with-three-intersecting-values-test
Sheet: Event Finder Data

I.D. | Condition | User Defined Field 4
MFR5-3343 | INITIAL CAL | CAL - NO ADJUSTMENT
244333 | INITIAL CAL | CAL - NO ADJUSTMENT
654SD5 | IN TOLERANCE | CAL - NO ADJUSTMENT
155132 | INITIAL CAL | CAL - NO ADJUSTMENT
654SD5 | INITIAL CAL | CAL - NO ADJUSTMENT
MFR5-3343 | INITIAL CAL | CAL - NO ADJUSTMENT
654SD5 | IN TOLERANCE | CAL - NO ADJUSTMENT
654SD5 | INITIAL CAL | CAL - NO ADJUSTMENT
244333 | INITIAL CAL | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
654SD5 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
155132 | INITIAL CAL | CAL - NO ADJUSTMENT
654SD5 | DAMAGED | CAL/ADJUSTED TO SPECS
654SD5 | DAMAGED | CAL/ADJUSTED TO SPECS
155132 | DAMAGED | REJECTED
244333 | VENDOR REPAIR | CAL/ADJUSTED TO SPECS
MFR5-3343 | DAMAGED | CAL/ADJUSTED TO SPECS
155132 | IN TOLERANCE | CAL - NO ADJUSTMENT
654SD5 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
155132 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | INOPERATIVE | CAL - NO ADJUSTMENT
654SD5 | IN TOLERANCE | CAL - NO ADJUSTMENT
155132 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
654SD5 | INOPERATIVE | REPAIR/CAL
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | VENDOR REPAIR | REPAIR/CAL
155132 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
155132 | IN TOLERANCE | CAL - NO ADJUSTMENT
155132 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
654SD5 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | INOPERATIVE | REPAIR/CAL
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
654SD5 | VENDOR REPAIR | REPAIR/CAL
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
MFR5-3343 | IN TOLERANCE | CAL - NO ADJUSTMENT
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
654SD5 | INOPERATIVE | REPAIR/CAL
244333 | IN TOLERANCE | CAL - NO ADJUSTMENT
654SD5 | IN TOLERANCE | CAL - NO ADJUSTMENT
Spreadsheet: 668411d1584805949-extracting-by-area-code-email-sent-example
Sheet: Sheet1

Name | Website | [NAME] | Telephone | Contact | Item Sent1 | Sent | Y/N1 | Item Sent2 | Sent | Y/N2 | Item Sent3 | Sent | Y/N3
Company1 |  | [EMAIL]\ | 4153624022 | KnarlyGuy1 | Qual | 2020-02-07 00:00:00 |  | Qual2 | 2020-02-12 00:00:00 |  | Slow | 2020-03-17 00:00:00
Company2 | https://www.website.com | [EMAIL]\ | 4155657103 | KnarlyGuy2 | Qual | 2020-02-07 00:00:00 |  | Qual2 | 2020-02-12 00:00:00 |  | Intro | 2020-03-10 00:00:00
Company3 | https://www.website.com | [EMAIL]\ | 6504012000 | [NAME] | Qual | 2020-02-07 00:00:00 |  | Qual2 | 2020-02-12 00:00:00 |  | Intro | 2020-02-14 00:00:00
Company4 | https://www.website.com | [EMAIL]\ | (650) 854-8585 | KnarlyGuy4 | Qual | 2020-02-07 00:00:00 |  | Qual2 | 2020-02-11 00:00:00 |  | Intro | 2020-03-02 00:00:00
Company5 | https://www.website.com | [EMAIL]\ | (650) 681-8420 | KnarlyGuy5 | Qual | 2020-02-12 00:00:00 |  | Qual2 | 2020-02-14 00:00:00
Company6 | https://www.website.com | [EMAIL]\ | 2159886800 | KnarlyGuy6 | Qual | 2020-02-07 00:00:00 |  | Qual2 | 2020-02-11 00:00:00
Company7 | https://www.website.com | [EMAIL]\ | (415) 392-7442 | KnarlyGuy7 | Qual | 2020-02-06 00:00:00 | No |  |  | No |  | 2020-02-24 00:00:00
Company8 | https://www.website.com | [EMAIL]\ | 4152628100 | KnarlyGuy8 | Qual | 2020-02-07 00:00:00 |  | Qual2 | 2020-02-14 00:00:00 |  | Slow | 2020-03-17 00:00:00
Company9 | https://www.website.com | [EMAIL]\ | 6788121101 | KnarlyGuy9 | Qual | 2020-02-07 00:00:00 | No | Qual2 | 2020-02-14 00:00:00 | No |  |  | No
Company10 | https://www.website.com | [EMAIL]\ | 6035188112 | KnarlyGuy10 | Qual | 2020-02-07 00:00:00 | Yes | Intro | 2020-02-10 00:00:00 | No | Intro | 2020-02-10 00:00:00 | No
Company11 | https://www.website.com | [EMAIL]\ | 6506218808 | KnarlyGuy11 | Qual | 2020-02-07 00:00:00 | No |  |  |  |  |  | No
Company12 | https://www.website.com | [EMAIL]\ | 2127587325 | KnarlyGuy12 | Qual | 2020-02-07 00:00:00 |  |  |  |  | Intro | 2020-03-02 00:00:00
Spreadsheet: 856239d1705562517-formula-help-tester-rank
Sheet: RFA Tables

 | Growth Allowance
 | Growth | Scope Growth | Cost
 | Increase in Quantities | 4000
 |  | Growth – Total
 | Table 5.1 Commercial Pricing Summary
 | Ref. | Description | Budget | A | B | C | D
 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 |  | Total Amount
 |  | Pricing Rank
 | Table 5.2 Budget and Price Comparison - Recommended Contractor
 | A | Total Award Value
 | B | Growth Allowance
 | C | TOTAL VALUE (A+B)
 | D | Total Budget
 | E | Budget Gain/Loss (D-C)
 | Table 5.3 Forecast and Price Comparison - Recommended Contractor
 | A | Total Award Value
 | B | Growth Allowance
 | C | TOTAL VALUE (A+B)
 | D | Total Forecast
 | E | Forecast Gain/Loss (D-C)
Spreadsheet: 102f3c9d-32cc-4060-bb73-66e60b122081
Sheet: Public Administration MPA

Enrolled Public Administration MPA
Academic Years 2011 - 2012
 | FS2010 |  |  | SS2010 |  |  | SP2011 |  |  | FS2011 |  |  | SS2011 |  |  | SP2012
Ethnicity | Female | Male | Total | Female | Male | Total | Female | Male | Total | Female | Male | Total | Female | Male | Total | Female | Male | Total | Grand Total
Asian | 1 | 1 | 2 | 0 | 1 | 1 | 3 | 1 | 4 | 2 | 2 | 4 | 1 | 0 | 1 | 2 | 0 | 2 | 14
Black/African American | 13 | 6 | 19 | 7 | 1 | 8 | 11 | 5 | 16 | 9 | 5 | 14 | 5 | 0 | 5 | 7 | 2 | 9 | 71
Hispanic/Latino | 8 | 3 | 11 | 4 | 1 | 5 | 8 | 1 | 9 | 7 | 0 | 7 | 5 | 0 | 5 | 6 | 0 | 6 | 43
Multiple Race/Ethnicity | 1 | 1 | 2 | 0 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 3 | 2 | 1 | 3 | 0 | 1 | 1 | 12
Non Res International | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 2 | 2 | 4 | 0 | 0 | 0 | 2 | 2 | 4 | 11
Not Specified | 11 | 3 | 14 | 5 | 1 | 6 | 7 | 4 | 11 | 5 | 6 | 11 | 3 | 1 | 4 | 6 | 7 | 13 | 59
White | 58 | 26 | 84 | 34 | 11 | 45 | 63 | 27 | 90 | 66 | 29 | 95 | 36 | 17 | 53 | 62 | 28 | 90 | 457
Grand Total | 92 | 41 | 133 | 50 | 17 | 67 | 93 | 40 | 133 | 93 | 45 | 138 | 52 | 19 | 71 | 85 | 40 | 125 | 667
Spreadsheet: 164321d1340727139-multiple-conditional-formatting-conditional-format
Sheet: Measures

Description | NY | NY ADG | WY | WY ADJ | KC | KC ADJ | AVG | QC Score
Measure
Sub Measure 1a | 68.41 | 71.41 | 62.74 | 65.74000000000001 | 68.61 | 71.61 | 69.58666666666666 | 64.34
Sub Measure 1b | 51.87 | 54.87 | 45.28 | 48.28 | 50 | 53 | 52.05 | 48.05
Measure 3 | 81.4 | 84.4 | 75.81 | 78.81 | 75.43 | 78.43 | 80.54666666666667 | 76.64
Measure 4 | 88.98 | 91.98 | 86.13 | 89.13 | 86.87 | 89.87 | 90.32666666666667 | 83.67
Measure 5 | 21.05 | 24.05 | 27.49 | 30.49 | 26.37 | 29.37 | 27.97 | 21.31
Measure 6 | 67.02 | 70.02 | 63.81 | 66.81 | 59.87 | 62.87 | 66.56666666666666 | 67.03
Measure 7 | 76.37 | 79.37 | 70.81 | 73.81 | 71.03 | 74.03 | 75.73666666666666 | 74.51
Measure 8
Sub Measure 8 | 72.26 | 75.26 | 65.8 | 68.8 | 49.64 | 52.64 | 65.56666666666666 | 48.46
Spreadsheet: 75060d1275583191-excel-2007-compiling-summary-of-items-across-worksheets-example_summary
Sheet: Co_A

Company A
Item | Catalogue No | Quantity
Item A | 1234 | 2
Item B | 12345 | 1
Item C | 123 | 2
Item D | 123456 | 2
Item E | 12 | 1
Item C | 123 | 2
Item A | 1234 | 2
Spreadsheet: 838384d1690977779-pairing-variables-and-coding-the-output-sample-dataset-v4-hansdouwe-solution-
Sheet: Example of Desired Output

Transaction No | Customer ID | Date (DD/MM/YYYY) | Apple | Pepper | [NAME] | Blueberry | [NAME] | [NAME] | Peach | Grape
1 | 111181 | 2021-08-20 00:00:00 | 1 |  |  |  |  |  | 11
2 | 111182 | 2021-08-20 00:00:00 | 2 |  |  |  | 9 | 10
3 | 111203 | 2021-08-23 00:00:00 | 2 | 6 |  | 8 | 9 | 10 | 11 | 12
4 | 111111 | 2021-08-16 00:00:00
5 | 111143 | 2021-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | Data Legend
6 | 111112 | 2021-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Label | Coding
7 | 111151 | 2021-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 1
8 | 111192 | 2021-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red Apple | 2
9 | 111158 | 2021-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | Green Pepper | 3
10 | 111111 | 2021-08-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red Pepper | 4
11 | 111116 | 2021-08-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | Orange Pepper | 5
12 | 111112 | 2021-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 6
13 | 111122 | 2021-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 7
14 | 111128 | 2021-08-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | Blueberry | 8
15 | 111181 | 2021-08-21 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 9
16 | 111136 | 2021-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 10
17 | 111133 | 2021-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | Peach | 11
18 | 111177 | 2021-08-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | Grape | 12
19 | 111209 | 2021-08-28 00:00:00
20 | 111191 | 2021-08-23 00:00:00
21 | 111119 | 2021-08-05 00:00:00
22 | 111111 | 2021-08-01 00:00:00
23 | 111133 | 2021-08-11 00:00:00
24 | 111112 | 2021-08-16 00:00:00
25 | 111114 | 2021-08-02 00:00:00
26 | 111209 | 2021-08-29 00:00:00
27 | 111136 | 2021-08-11 00:00:00
28 | 111187 | 2021-08-20 00:00:00
29 | 111171 | 2021-08-19 00:00:00
30 | 111209 | 2021-08-30 00:00:00
31 | 111204 | 2021-08-23 00:00:00
32 | 111206 | 2021-08-24 00:00:00
33 | 111197 | 2021-08-22 00:00:00
34 | 111194 | 2021-08-22 00:00:00
35 | 111162 | 2021-08-18 00:00:00
36 | 111167 | 2021-08-18 00:00:00
37 | 111155 | 2021-08-17 00:00:00
38 | 111165 | 2021-08-18 00:00:00
39 | 111173 | 2021-08-19 00:00:00
40 | 111203 | 2021-08-23 00:00:00
Spreadsheet: 673736d1587508129-how-to-search-for-a-column-and-sum-contents-old-feedlot-head-day-tracking
Sheet: Monthly Data

Month Beginning | 2020-04-01 00:00:00
Lot | Harris1
Total Head Days | 180
Date | Harris1 | Harris2 | Check
Head Days