tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5b2235fe-823f-4f54-bb71-9f8660ad3ebc
Sheet: 9 Mos

Johnson & Johnson and Subsidiaries
Condensed Consolidated Statement of Earnings
(Unaudited; in Millions Except Per Share Figures) | NINE MONTHS
 | 2011 |  |  |  | 2010 |  |  |  | Percent
 |  |  | Percent |  |  |  | Percent |  | Increase
 | Amount |  | to Sales |  | Amount |  | to Sales |  | (Decrease)
Sales to customers | 48775 |  | 100 |  | 45943 |  | 100 |  | 6.164159937313627
Cost of products sold | 15022 |  | 30.79856483854433 |  | 13752 |  | 29.93274274644669 |  | 9.235020360674811
Selling, marketing and administrative expenses | 15511 |  | 31.80112762685802 |  | 14244 |  | 31.00363493894609 |  | 8.894973322100535
Research and development expense | 5393 |  | 10.95689390056381 |  | 4862 |  | 10.58267853644734 |  | 10.9214315096668
Interest (income)expense, net | 332 |  | 0.6806765761148129 |  | 234 |  | 0.5093267744814226
Other (income)expense, net | -115 |  | -0.2357765248590466 |  | -1868 |  | -3.965907755261955
Restructuring expense | 589 |  | 1.207585853408508 |  | 0 |  | 0
Earnings before provision for taxes on income | 12043 |  | 24.68092772936955 |  | 14719 |  | 32.03752475894043 |  | -18.18058292003533
Provision for taxes on income | 2589 |  | 5.308047155304972 |  | 3327 |  | 7.231581960255099 |  | -22.18214607754734
Net earnings | 9454 |  | 19.38288057406458 |  | 11392 |  | 24.79594279868533 |  | -17.01193820224719
Net earnings per share  (Diluted) | 3.4 |  |  |  | 4.08 |  |  |  | -16.66666666666667
Average shares outstanding  (Diluted) | 2777.6 |  |  |  | 2792
Effective tax rate | 21.49796562318359 | % |  |  | 22.60343773354168 | %
Adjusted earnings before provision for taxes and net earnings
Earnings before provision for taxes on income | 13696 | (1) | 28.07995899538698 |  | 13379 | (2) | 29.12086716148271 |  | 2.369384856865237
Net earnings | 10738 | (1) | 22.01537672988211 |  | 10415 | (2) | 22.66939468471802 |  | 3.101296207393183
Net earnings per share  (Diluted) | 3.87 | (1) |  |  | 3.73 | (2) |  |  | 3.75335120643432
Effective tax rate | 0.2159754672897196 |  |  |  | 0.2215412213169893
(1) The $1,653 million difference between as reported earnings and as adjusted earnings before provision for taxes on income is the exclusion of expense due to restructuring ($676 million, of which $589 million is reported as restructuring expense and $87 million is included in cost of products sold), expense due to litigation matters ($654 million), additional DePuy ASR™ Hip recall costs ($109 million) and a mark-to-market adjustment associated with a currency option and deal costs related to the planned acquisition of Synthes ($214 million).  Net earnings and net earnings per share (diluted) on these items are $1,284 million and $0.47 per share, respectively.
(2) The difference between as reported earnings and as adjusted earnings before provision for taxes on income, net earnings and net earnings per share (diluted) is the exclusion of income from net litigation of $1,340 million, $977 million and $0.35 per share, respectively.
Spreadsheet: 7237e949-a191-49bb-8c0a-5a51a7bfa35a
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
TCPT | Test | TCPT | Trichophyton rubrum, IgE | Trichophyton Rubrum, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
TCPT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TCPT | Result | TCPT | Trichophyton Rubrum, IgE | Trichophyton Rubrum, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6860-1
Spreadsheet: 870144d1716708186-regarding-copying-different-rows-in-excel-and-pasting-in-different-columns-excel-forums
Sheet: Sheet1

Gold Back Chain | 2 | 6.01 | A1 need to copied in HIJKL | B1 need to copied to h6 | C1 need to copied to L6
Gold besari | 489 | 84.09 | A2 need to copied to NOPQR | B2 need to copied to n6 | C2 need to copied to R6
Gold Chain 10GM | 2 | 20.11 | A3 neee to copied to TUVWX | B3 need to copied to t6 | [NAME] need to copied to x6 |  | Month |  | June |  |  |  | Month |  | June |  |  |  | Month |  | June
Gold Chain 12GM | 5 | 60.28 | 1. Page will be landscape
Gold Chain 16GM | 5 | 80.22 | 2. Per page 6 separate boxes will b there |  |  |  | Qty |  | Date | Less/Add | Actual |  | Qty |  | Date | Less/Add | Actual |  | Qty |  | Date | Less/Add | Actual
Gold Chain 24GM | 3 | 72.16 | 3. Left side values need to paste automatically in the right side empty columns
Gold chain 2GM | 2 | 4.23
Gold Chain 4GM | 5 | 20.47
Gold Chain 6GM | 5 | 30.08
Gold chain 8GM | 11 | 88.61
Spreadsheet: 779494d1651819536-how-to-index-match-a-cell-that-has-formula-with-another-sheet-reference-efwitherror-no-error-aligw
Sheet: Sheet3

ID | Time | Code | Sequence | Name
101 | 06:30:00 | A | 1
101 | 06:31:00 | B | 2
101 | 06:32:00 | C | 3
101 | 06:33:00 | D | 4
101 | 06:34:00 | E | 5
101 | 06:35:00 | F | 6
101 | 06:36:00 | G | 7
101 | 06:37:00 | H | 8
101 | 06:38:00 | I | 9
101 | 06:38:00 | J | 10
101 | 06:39:00 | K | 11
101 | 06:39:00 | L | 12
101 | 06:40:00 | M | 13
101 | 06:40:00 | N | 14
101 | 06:41:00 | O | 15
101 | 06:42:00 | P | 16
101 | 06:43:00 | Q | 17
101 | 06:44:00 | R | 18
101 | 06:45:00 | S | 19
101 | 06:46:00 | T | 20
101 | 06:46:00 | U | 21
101 | 06:47:00 | V | 22
101 | 06:48:00 | W | 23
101 | 06:49:00 | X | 24
101 | 06:50:00 | Y | 25
101 | 06:51:00 | Z | 26
101 | 06:53:00 | AA | 27
101 | 06:53:00 | AB | 28
101 | 06:55:00 | AC | 29
101 | 06:58:00 | AD | 30
102 | 08:00:00 | AE | 1
102 | 08:10:00 | AF | 2
102 | 08:15:00 | AG | 3
Spreadsheet: 195b62a2-9323-4fc9-af8f-320b60fdcc11
Sheet: Bldg. with Daily Schedule

 |  |  |  | Room
 |  |  | Period | Attendance
 |  |  | 1st | 19
 |  |  | 2nd | 21
 |  |  | 3rd | 23
 |  |  | 4th | 14
 |  |  | 5th | 0
 |  |  | 6th | 16
 |  |  | 7th | 20
 |  |  | 8th | 23
 |  |  | Total
 |  |  | FTE  for this Room
Spreadsheet: 870207d1716764588-aggregate-hlookup-not-working-test-book
Sheet: Ratings

YR 1 |  |  |  |  |  |  |  |  |  |  | '+IMP | Y2 | Y3 | Y4
 |  |  |  | X | 47 |  |  |  |  |  | X | 3 | 1 | 1
 |  |  |  | Y | 7 |  |  |  |  |  | Y | 0.75 | 0.5 | 0.25
 |  |  |  | MIN
 |  |  |  | MAX
SIZE | AGILITY | BALANCE | COORDINATION | POWER | REACTION TIME | SPEED | FLEXIBILITY | STRENGTH | ENDURANCE | ATH IQ | MOTOR | MENTAL |  | FT OFF | FT DEF | BB OFF | BB DEF | BskB OFF | BskB DEF | SCR OFF | SCR DEF | HKY OFF | HKY DEF | LAX OFF | LAX DEF | GLF OFF | GLF DEF | TEN OFF | TEN DEF |  |  | '+IMP | '+IMP | '+IMP
Spreadsheet: 718641d1613246205-extract-values-using-left-right-or-mid-function-left_right_mid_function_extractvalues
Sheet: Sheet1

Date | E1 | E2 | E3 |  | Date | E1 | E2 | E3
2021-04-04 00:00:00 | 4 | 3 | 2021 |  | 2021-04-04 00:00:00 | 04 | 04 | 2021
2021-04-11 00:00:00 | 4 | 11 | 2021 |  | 2021-04-11 00:00:00 | 04 | 11 | 2021
2021-04-18 00:00:00 | 4 | 18 | 2021 |  | 2021-04-18 00:00:00 | 04 | 18 | 2021
2021-04-25 00:00:00 | 4 | 25 | 2021 |  | 2021-04-25 00:00:00 | 04 | 25 | 2021
Spreadsheet: 159676d1338813647-sum-if-based-on-multiple-criteria-sample
Sheet: Summary

Account Manager | Sector | Client ID | [NAME] | QTD Signings |  |  | TOTAL Signings | Week 1 Signings |  |  | Week 2 Signings |  |  | Week 3 Signings |  |  | Week 4 Signings
 |  |  |  | <$1M | $1M-$10M | >$10M |  | <$1M | $1M-$10M | >$10M | <$1M | $1M-$10M | >$10M | <$1M | $1M-$10M | >$10M | <$1M | $1M-$10M | >$10M
AAA | Com | 1581008 | 111
AAA | Com | 1727159 | 222
AAA | Com | 1222880 | 333
BBB | Com | 1293811 | 444
CCC | Com | 1478314 | 555
BBB | Com | 1484060 | 333
CCC | Com | 1496686 | 555
AAA | Com | 1551211 | 222
ZZZ | Com | 1103623 | 111
[NAME] | Com | 1464644 | 111
YYY | Com | 1511914 | 222
MMM | Dis | 1533574 | 333
SSS | Dis | 1168242 | 444
CCC | Dis | 1333836 | 555
[NAME] | Dis | 1623591 | 333
AAA | Dis | 1100271 | 555
ZZZ | Dis | P0050AB | 222
[NAME] | Dis | 1438230 | 111
YYY | Dis | 1045970 | 111
MMM | Dis | 1473461 | 222
SSS | Dis | 1186570 | 333
CCC | Dis | 1393442 | 444
[NAME] | Dis | 1347070 | 555
AAA | Dis | 1257066 | 333
ZZZ | Dis | 1178898 | 555
[NAME] | Dis | 1704531 | 222
YYY | Dis | 1244756 | 111
MMM | Fin | 1060302 | 111
SSS | Fin | 1063739 | 222
CCC | Fin | 1490011 | 333
[NAME] | Fin | 1265133 | 444
AAA | Fin | 1156715 | 555
ZZZ | Fin | 1438293 | 333
[NAME] | Fin | 1461101 | 555
YYY | Fin | 1547965 | 222
MMM | Fin | 1637631 | 111
SSS | Fin | 1648886 | 111
CCC | Ind | 1060110 | 222
[NAME] | Ind | 1612357 | 333
AAA | Ind | 1487380 | 444
ZZZ | Ind | 1074984 | 555
[NAME] | Ind | 1269962 | 333
YYY | Ind | 1201330 | 555
MMM | Ind | 1434580 | 222
SSS | Ind | 1478215 | 111
CCC | Ind | 1698949 | 111
[NAME] | Ind | 1366466 | 222
AAA | Ind | 1336534 | 333
ZZZ | Pub | 1444687 | 444
[NAME] | Pub | 1607713 | 555
YYY | Pub | P007V2B | 333
MMM | Pub | 1268612 | 555
SSS | Pub | 1738365 | 222
CCC | Pub | 1406463 | 111
[NAME] | Pub | 1053077 | 111
AAA | Pub | 1114267 | 222
ZZZ | Pub | 1422308 | 333
[NAME] | Pub | 1453275 | 444
YYY | Pub | 1487780 | 555
MMM | Pub | 1432912 | 333
SSS | Pub | 1250898 | 555
CCC | Pub | 1328252 | 222
[NAME] | Pub | 1626891 | 111
AAA | Pub | 3169527 | 111
ZZZ | Pub | 3169400 | 222
[NAME] | Pub | 3169455 | 333
YYY | Pub | 3169438 | 444
MMM | Pub | 3169405 | 555
SSS | Pub | 3169411 | 333
CCC | Pub | P003LRC | 555
[NAME] | Pub | P003LRE | 222
AAA | Pub | [NAME] | 111
ZZZ | Pub | P003LSF | 111
[NAME] | Pub | 1650608 | 222
YYY | Pub | 1540012 | 333
MMM | Pub | 3169423 | 444
SSS | Pub | 1740324 | 555
CCC | Pub | 1707790 | 333
[NAME] | Pub | 1461624 | 555
Spreadsheet: 818633d1676978631-calculating-remaining-months-from-date-column-remaining-month-1-
Sheet: Sheet1

Start Date | First day of month | Remaining Month | Cost to Com | Calculate |  | Mismatch in [NAME] | Working Formula
2022-06-29 00:00:00 |  |  | 424689
2022-04-01 00:00:00 |  |  | 57327
2023-02-01 00:00:00 |  |  | 15098
2022-11-10 00:00:00
2023-06-01 00:00:00
2022-07-01 00:00:00
2023-02-21 00:00:00
Spreadsheet: 783539d1654887342-skip-duplicate-value-in-countif-skip-duplicate-value-in-countif-v2
Sheet: Sheet1

 | Skip duplicate value in Countif according to the specific items
 |  |  |  |  |  |  |  |  | tomatoes | <<---- key in any fruit names in the list
 | Date | Inv-numbers | fruit | fruit | fruit | fruit
 | 2015-05-01 00:00:00 | 1 | oranges | grapefruits | tomatoes | limes | <<---- 1st invoice
 | 2015-05-02 00:00:00 | 2 | nectarines | rockmelons | peaches | plums
 | 2015-05-03 00:00:00 | 3 | bananas | tomatoes | apples | tomatoes | <<---- 2nd invoice |  |  | INCORRECT OUTCOME |  |  |  | DESIRED OUTCOME
 | 2015-05-04 00:00:00 | 4 | strawberries | raspberries | blueberries | kiwifruit
 | 2015-05-05 00:00:00 | 5 | apples | pears | oranges | apples |  |  |  | Inv-quantity |  |  |  | Inv-quantity
 | 2015-05-06 00:00:00 | 6 | watermelons | rockmelons | honeydew | bananas |  |  |  |  |  |  |  | 4
 | 2015-05-07 00:00:00 | 7 | apples | avocados | apples | nectarines
 | 2015-05-08 00:00:00 | 8 | raspberries | blueberries | peaches | plums |  |  |  | *Wrong : 7 tomatoes in 7 invoices accordingly |  |  |  | *Correct : 7 tomatoes in 4 invoices accordingly
 | 2015-05-09 00:00:00 | 9 | bananas | apricots | peaches | tomatoes | <<---- 3rd invoice
 | 2015-05-10 00:00:00 | 10 | tomatoes | tomatoes | watermelons | tomatoes | <<---- 4th invoice
Spreadsheet: 774694d1648621712-count-how-many-replenishment-do-i-need-by-date-sample
Sheet: Sheet1

SKU_ID | INNER QTY | ORIGINAL | UPDATE | VIEWS | FAILED VISITS | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-05 00:00:00 | 2022-02-06 00:00:00 | 2022-02-07 00:00:00 | 2022-02-08 00:00:00 | 2022-02-09 00:00:00 | 2022-02-10 00:00:00 | 2022-02-11 00:00:00 | 2022-02-12 00:00:00 | 2022-02-13 00:00:00 | 2022-02-14 00:00:00 | 2022-02-15 00:00:00 | 2022-02-16 00:00:00 | 2022-02-17 00:00:00 | 2022-02-18 00:00:00 | 2022-02-19 00:00:00 | 2022-02-20 00:00:00 | 2022-02-21 00:00:00 | 2022-02-22 00:00:00 | 2022-02-23 00:00:00 | 2022-02-24 00:00:00 | 2022-02-25 00:00:00 | 2022-02-26 00:00:00 | 2022-02-27 00:00:00 | 2022-02-28 00:00:00
1800059 | 20 | 90 | 90 | 83 | 0 | 1 | 0 | 27 | 17 | 9 | 5 | 5 | 2 | 5 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 2 | 0 | 2 | 0 | 1 | 1 | 0 | 1 | 2
Spreadsheet: 2f7e0cdd-bea0-430c-97d6-e332749a2f5e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | OWS-6 Cost Sharing Funds Request Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Company Name Here
Labor Funding Request |  |  |  |  |  | Running Total
Function or Task | WBS Task | Assigned Personnel | [NAME] | Projected Labor Hours | Task Funding Request
Write GetView spec | WBS 4.2.1 Item 3 | Sr. Software Eng. | 50 | 100 | 5000
Modify brand x client to support with GetView | WBS 4.2.1 Item 4 | Assoc. Software Eng. | 30 | 150 | 4500
 |  | Expand form as needed
Total Labor |  |  |  |  | 9500 | 9500
Travel Funding Request
Function or Event | Duration | Aspects of Travel | Est. Trip Cost | # of Travelers | Trip Funding Request
OWS-6 Kickoff | 4 days | flight, lodging, per diem | 3000 | 1 | 3000
OWS-6 Demo | 2 days | flight, lodging, per diem | 3000 | 2 | 6000
Total Travel |  |  |  |  | 9000 | 18500
Other Expense Requests
Expense Type | Purpose or Use | Justification | Est. Cost | Amount (Units) | Expense Funding Request
Brand X Server CPU | Host WBS software | Required by submitter in order to have adequate infrastructure to show results | 5000 | 1 | 5000
[NAME] (Seat licenses) | Data storage and retrieval | Required by submitter in order to have adequate infrastructure to show results | 3000 | 20 | 60000
Total Other Expenses |  |  |  |  | 65000 | 83500
Grand Total Matching Funds Request |  |  |  |  | 83500
Spreadsheet: 771666d1646783082-iferror-index-aggregate-formula-to-copy-and-paste-across-two-workheets-test2
Sheet: Under Contract

BRANCH | CUSTOMER NUMBER | CUSTOMER | ADDRESS 2 | STREET ADDRESS | CITY | STATE | MANUFACTURER | SEGMENT | EQUIP ID | PROD | MODEL | OMD SERIAL | INSTALL DATE | PRGM | ZIP CODE | Description
44 | 447432 | LITHIUM TECHNOLOGIES INC | [NAME] |  | AUSTIN | TX | CANON |  |  |  | C10
74 | 740280 | POWER ENGINEERS | AUSTIN SOUTH |  | AUSTIN | TX | XEROX |  |  |  | C1020
44 | 447432 | LITHIUM TECHNOLOGIES INC | [NAME] |  | AUSTIN | TX | RICOH |  |  |  | C1027
44 | 447432 | LITHIUM TECHNOLOGIES INC | [NAME] |  | AUSTIN | TX | SAVIN |  |  |  | C103
75 | 756062 | CELTIC BANK |  |  | AUSTIN | TX | MINOLTA |  |  |  | C1030
44 | 447432 | LITHIUM TECHNOLOGIES INC | [NAME] |  | AUSTIN | TX | SHARP |  |  |  | C1041
57 | 574113 | CHEM GROUP MRP SERVICES | 2443 GORDON STREET |  | AUSTIN | TX | CANON |  |  |  | C4235
57 | 574113 | CHEM GROUP MRP SERVICES | 2443 GORDON STREET |  | AUSTIN | TX | CANON |  |  |  | CB35C
44 | 443173 | NELSON STAFFING | [NAME] |  | AUSTIN | TX | CANON |  |  |  | CB50C
74 | 740280 | POWER ENGINEERS | AUSTIN SOUTH |  | AUSTIN | TX | CANON |  |  |  | [NAME]
44 | 447432 | LITHIUM TECHNOLOGIES INC | [NAME] |  | AUSTIN | TX | CANON |  |  |  | CB5540
74 | 740644 | POWER ENGINEERS | VIA FORTUNA |  | AUSTIN | TX | CANON |  |  |  | CB5550
44 | 447432 | LITHIUM TECHNOLOGIES INC | [NAME] |  | AUSTIN | TX | HP |  |  |  | CE825
74 | 740280 | POWER ENGINEERS | AUSTIN SOUTH |  | AUSTIN | TX | HP |  |  |  | P55UV
44 | 442153 | LITHIUM TECHNOLOGIES INC |  |  | AUSTIN | TX | EPSON |  |  |  | P570E
75 | 756058 | CELTIC BANK |  |  | AUSTIN | TX | BROTHER |  |  |  | PB8900
44 | 447432 | LITHIUM TECHNOLOGIES INC | [NAME] |  | AUSTIN | TX | [NAME] |  |  |  | PC364
75 | 755610 | CELTIC BANK |  |  | AUSTIN | TX | PANASONIC |  |  |  | S2046
74 | 740280 | POWER ENGINEERS | AUSTIN SOUTH |  | AUSTIN | TX | KODAK |  |  |  | S2070
Spreadsheet: 66387d1267046673-return-value-within-a-normalized-range-sss
Sheet: CANSCOR

100 | HIGH OF DAY |  | 22.7 | 0.227 | 100
(•) | CLOSE OF DAY |  | 20.3 | 8.404200000000001 | -20
-100 | LOW OF DAY |  | 18.7 | -0.187 | -100
 | RANGE DIF |  | 4 | 2 | 20.7 | <  ZERO
100 | 22.7
95 | 22.6
90 | 22.5
85 | 22.4
80 | 22.3
75 | 22.2
70 | 22.1
65 | 22
60 | 21.9
55 | 21.8
50 | 21.7
45 | 21.6
40 | 21.5
35 | 21.4
30 | 21.3
25 | 21.2
20 | 21.1
15 | 21
10 | 20.9
5 | 20.8
0 | 20.7
-5 | 20.6
-10 | 20.5
-15 | 20.4
-20 | 20.3 | (•)
-25 | 20.2
-30 | 20.1
-35 | 20
-40 | 19.9
-45 | 19.8
-50 | 19.7
-55 | 19.6
-60 | 19.5
-65 | 19.4
-70 | 19.3
-75 | 19.1999999999999
-80 | 19.1
-85 | 19
-90 | 18.8999999999999
-95 | 18.8
-100 | 18.6999999999999
Spreadsheet: 77209d1277733537-displaying-the-colour-of-a-conditional-format-in-another-cell-copy-of-forum-excel-1-
Sheet: Score Sheet

 |  | KEY PERFORMANCE INDICATORS
 |  |  |  | SCORE SHEET
 |  |  |  |  | 2010
 | 1 ACCESS |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | ASSESSMENT
 | COURT TEAM |  |  |  |  | 0.92
 | OUTREACH |  |  |  |  | 0.95
 | TELEPHONE |  |  |  |  | 0.1
 | 2 CASEWORK |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | DISCRIMINATION
 | FIF DEBT
 | NEW LEGAL AID
 | RENT ARREARS
 | 3 CLIENTS |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | COMPLAINTS
 | DAY 1
 | NO SHOW RATE
 | WAITING RATE
 | 4 QUALITY |  | Quarter 4 |  |  | Quarter 1 |  |  | Quarter 2 |  |  | Quarter 3
 | ADVICE CHECKED
 | FILE REVIEWS
 | LSC KPI
 | RESILIENCE TEST
 | 5 STAKEHOLDERS |  | Quarter 4 |  |  | Quarter 1 |  |  | Quarter 2 |  |  | Quarter 3
 | CLIENT SATISFACTION
 | EXTERNAL PANEL
 | MEETINGS HELD
 | NEW RECRUITS
 | 6 SOCIAL POLICY |  | Quarter 4 |  |  | Quarter 1 |  |  | Quarter 2 |  |  | Quarter 3
 | EVIDENCE RATE
 | LINK DELIVERY
 | MEDIA [NAME]
 | PRODUCTS
 | 7 COMPLIANCES |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | FILING LIVE
 | FIRE TESTS
 | FIRST AIDERS
 | INSURANCES LIVE
 | 8 PEOPLE |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | CONTRACTS ISSUED
 | APPRAISALS
 | SICKNESS RATE
 | TRAINED RECRUITS
 | 9 MONEY |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | CASH TO PLAN
 | EXPENDITURE
 | INCOME TO PLAN
 | SIGNED CONTRACTS
Spreadsheet: 237499d1369233329-how-do-i-tie-a-column-to-a-pivot-table-z_examplefile
Sheet: Weekly

Date - pick week/month | 2012-10-16 00:00:00 | Goals
operationsmanager | One, Om | 0.85 | 0.005 | 0.93 | 0.93 | 1 | 0.93 | 0.25 | 0.7 | 0.011 | N/A | 379 | N/A |  | >5
 |  | Data
unitmanager | [NAME] | PC% | Fail% | E-Mail% | Cell% | %Goal | RecAsk% | Recurring% | Availability | Unaccounted | %WRAP | AHT(IB) | UnconOthr | Global360 | Points | pc | f | e | c | g | a | rec | a | u | aht | 360
One, Um |  | 0.8095238095238095 | 0.01072124756335283 | 0.8 | 0.8181818181818182 | 1 | 0.8888888888888888 | 0.1204620462046205 | 0.752107142857143 | 0.01023872180451128 | 0.2725416398549873 | 476.6420966420966 | 0.01938721804511278 | 0
Two, Um |  | 1 | 0.006045949214026602 | 0.8333333333333334 | 0.8 | 1 | 1 | 0.1607669616519174 | 0.6626749411512947 | -0.01616092445966189 | 0.2661692707912553 | 351.4673231871083 | 0.03390969398673229 | 0
Grand Total |  | 0.8918918918918919 | 0.008634646519158122 | 0.8125 | 0.8125 | 1 | 0.9583333333333334 | 0.1376811594202899 | 0.7102862003402381 | -0.002106474532172525 | 0.2698354044587266 | 416.83875106929 | 0.02617832482737917 | 0
Spreadsheet: 866209d1713181954-titles-association-with-by-products-titles-association-aligw
Sheet: Φύλλο1

titles association table |  |  |  |  |  | τελικος πινακας
titles | byproduct | Quantity |  |  |  | titles | Quantity | byproduct | Quantity |  | in the frame is the final paper to be printed
συρταρι 1 | α | 1 |  |  |  | συρταρι 1 | 2 |  | 2
συρταρι 1 | β | 2 |  |  |  |  |  | β | 4
συρταρι 1 | γ | 1 |  |  |  |  |  | γ | 2
συρταρι 1 | δ | 1 |  |  |  |  |  | δ | 2
συρταρι 2 | q1 | 1 |  |  |  | συρταρι 2 | 5 |  | 5
συρταρι 2 | c | 2 |  |  |  |  |  | c | 10
συρταρι 2 | v | 1 |  |  |  |  |  | v | 5
Spreadsheet: 138488d1327680691-if-and-lookup-bid-sheet-to-po
Sheet: Sheet1

3.a.
Item | Description | Unit | Village Produce | City Produce | Country Produce | Best Bid $ | Best Company Quote | Last Price Paid
Avocados | 48 ct. | Case | 61.8 | 60.3 | 59.46 |  |  | 57.94
Cauliflower | 12 ct. | Case | 12.8 | 12.9 | 13.27 |  |  | 13.26
Cucumbers | Medium | Case | 11.1 | 11.52 | 10.91 |  |  | 11.34
Grapes | Red Seedless | [NAME] | 19.32 | 19.5 | 19.14 |  |  | 18.72
Lettuce | [NAME], 24 ct. | Case | 9.53 | 9.84 | 10.27 |  |  | 10.02
Lettuce | Romaine, 24 ct. | Case | 17.75 | 17.82 | 18.22 |  |  | 18.1
Pears | D'Anjou | Case | 20.82 | 20.58 | 20.64 |  |  | 20.62
Peppers | [NAME], Med. | Case | 8.3 | 8.38 | 9.28 |  |  | 9.02
Pineapples | 7 ct. | Case | 10.5 | 10.38 | 10.68 |  |  | 10.08
Potatoes | B Reds | 50# [NAME] | 15.06 | 14.82 | 14.88 |  |  | 14.98
Potatoes | Peeled, Large | 25# [NAME] | 17.52 | 17.22 | 17.28 |  |  | 17.18
Squash | Yellow #2 | 30# Case | 8.55 | 8.71 | 8.98 |  |  | 9.1
Strawberries | Driscoll | Flat | 18.29 | 18.06 | 17.1 |  |  | 18.3
3.b.
Item | Description | Unit | Par Value | On Hand | Special Order | Order Amount
Avocados | 48 ct. | Case | 6 | 2 | 3
Cauliflower | 12 ct. | Case | 5 | 1
Cucumbers | Medium | Case | 3 | 0
Grapes | Red Seedless | [NAME] | 4 | 1
Lettuce | [NAME], 24 ct. | Case | 5 | 2 | 4
Lettuce | Romaine, 24 ct. | Case | 3 | 0.5
Pears | D'Anjou | Case | 3 | 1
Peppers | [NAME], Med. | Case | 7 | 2 | 5
Pineapples | 7 ct. | Case | 4 | 0
Potatoes | B Reds | 50# [NAME] | 3 | 0.5
Potatoes | Peeled, Large | 25# [NAME] | 4 | 1 | 4
Squash | Yellow #2 | 30# Case | 5 | 2 | 2
Strawberries | Driscoll | Flat | 3 | 1.5
3.c.
 |  | [NAME]
Supplier |  |  |  | [NAME]
Company Name: | Village Produce |  |  | P.O. Number | 456
Street Address: | 123 Somewhere |  |  | Order Date: | 2000-01-01 00:00:00
City, State, Zip: | Village, CA 12345 |  |  | Delivery Date: | 2000-01-02 00:00:00
Phone Number: | 555-5555 |  |  | Phone Number: | 555-5557
Fax Number: | 555-5556 |  |  | Fax Number: | 555-5558
E-Mail: | [EMAIL] |  |  | E-Mail: | [EMAIL]
Contact: | Mr. [NAME] |  |  | Buyer: | Ms. [NAME]
Item | Description | Unit | Quantity | Unit Price $ | Extension
Total
Spreadsheet: 705203d1605925338-convert-time-series-ohlc-data-frequency-from-daily-to-weekly-ohlc-data
Sheet: -disregard-

Week | Year | Open | High | Low | Close
49 | 2014
50 | 2014
51 | 2014
52 | 2014
53 | 2014
1 | 2015
2 | 2015
3 | 2015
4 | 2015
5 | 2015
6 | 2015
7 | 2015
8 | 2015
9 | 2015
10 | 2015
11 | 2015
12 | 2015
13 | 2015
14 | 2015
15 | 2015
16 | 2015
17 | 2015
18 | 2015
19 | 2015
20 | 2015
21 | 2015
22 | 2015
23 | 2015
24 | 2015
25 | 2015
26 | 2015
27 | 2015
28 | 2015
29 | 2015
30 | 2015
31 | 2015
32 | 2015
33 | 2015
34 | 2015
35 | 2015
36 | 2015
37 | 2015
38 | 2015
39 | 2015
40 | 2015
41 | 2015
42 | 2015
43 | 2015
44 | 2015
45 | 2015
46 | 2015
47 | 2015
48 | 2015
49 | 2015