tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a373c74-1d3b-4795-9200-d041355ad053
Sheet: Orig

Cycle Menu Template for Grades K-8
(Include serving sizes and component contribrtions daily for each menu item)
Weekly Total | Portion [NAME] | Component Contribution
Meat/Meat Alternates (oz) (minimum 1 oz/day; 8-10/week)
Grains (minimum 1/day; 8-9/week)
Vegetables (cups)
dark green (½ c minimum)
red/orange (¾ c minimum)
beans/legumes (½ c minimum)
starchy (½ c minimum)
other (½ c minimum)
additional (1 c minimum)
Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
Daily Total | Serving Size | Component Contribution | Daily Total | Serving Size | Component Contribution | Daily Total | Serving Size | Component Contribution | Daily Total | Serving Size | Component Contribution | Daily Total | Serving Size | Component Contribution
M/MAs (oz) (minimum 1 oz/day; 8-10/week) |  |  | M/MAs (oz) (minimum 1 oz/day; 8-10/week) |  |  | M/MAs (oz) (minimum 1 oz/day; 8-10/week) |  |  | M/MAs (oz) (minimum 1 oz/day; 8-10/week) |  |  | M/MAs (oz) (minimum 1 oz/day; 8-10/week)
Grains (minimum 1/day; 8-9/week) |  |  | Grains (minimum 1/day; 8-9/week) |  |  | Grains (minimum 1/day; 8-9/week) |  |  | Grains (minimum 1/day; 8-9/week) |  |  | Grains (minimum 1/day; 8-9/week)
Vegetables (cups) |  |  | Vegetables (cups) |  |  | Vegetables (cups) |  |  | Vegetables (cups) |  |  | Vegetables (cups)
dark green  (½ c minimum) |  |  | dark green  (½ c minimum) |  |  | dark green  (½ c minimum) |  |  | dark green  (½ c minimum) |  |  | dark green  (½ c minimum)
red/orange  (¾ c minimum) |  |  | red/orange  (¾ c minimum) |  |  | red/orange  (¾ c minimum) |  |  | red/orange  (¾ c minimum) |  |  | red/orange  (¾ c minimum)
beans/legumes  ([NAME] c minimum) |  |  | beans/legumes  ([NAME] c minimum) |  |  | beans/legumes  ([NAME] c minimum) |  |  | beans/legumes  ([NAME] c minimum) |  |  | beans/legumes  ([NAME] c minimum)
starchy  ([NAME] c minimum) |  |  | starchy  ([NAME] c minimum) |  |  | starchy  ([NAME] c minimum) |  |  | starchy  ([NAME] c minimum) |  |  | starchy  ([NAME] c minimum)
other  (½ c minimum) |  |  | other  (½ c minimum) |  |  | other  (½ c minimum) |  |  | other  (½ c minimum) |  |  | other  (½ c minimum)
additional  (1 c minimum) |  |  | additional  (1 c minimum) |  |  | additional  (1 c minimum) |  |  | additional  (1 c minimum) |  |  | additional  (1 c minimum)
Spreadsheet: 88da65b6-b6d0-455e-bfa1-79979958fdae
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
SAM | Test | SAM | Entamoeba [NAME], Serum | [NAME], S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Expected values: negative | Tuesday, Thursday; 9 a.m. | Same day/1 day | 7 days | 1 | 86753 |  |  |  |  | Rochester
SAM | [NAME] | SERUM | Serum |  |  |  | Frozen | 5 days
SAM | Result | 9049 | [NAME], S | [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5150-8
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 13d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 68537 | 822779 | 811420 | 15381 | 80824 | 118724
Europe | - | - | 803774 | - | - | 114475
North America/Asia | 68537 | 822779 | 7646 | 15381 | 80824 | 4249
Other | - | - | - | - | - | -
Index | 851330 | 3749481 | 5909348 | 442706 | 1774228 | 1622102
Asia | - | - | 177223 | - | - | 40073
Europe | - | - | 5093293 | - | - | 1442219
North America | 851330 | 3749481 | 182873 | 442706 | 1774228 | 62614
Other | - | - | 455959 | - | - | 77196
OTHER* | - | - | 605422 | - | - | 288398
TOTAL | 919867 | 4572260 | 7326190 | 458087 | 1855052 | 2029224
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 141617d1329370043-need-a-wildcard-solution-in-an-if-statement-wo-sch-excel-2003
Sheet: JAN12

DATE |  | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
 |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T
 | EMP# | 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
BILLY | 480 | N | N |  |  |  |  |  |  |  |  |  |  | D | D | D | D | D | D | D | WD |  |  |  |  |  | WD | D | D | D | D | D
JACK | 485 |  |  | [NAME] | N | N | WN |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N | N
[NAME] | 500 |  |  | N | N |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | D | D | D | D | D | D | D |  |  | WD
FRED | 505 |  | WD |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  | WD
 |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T
 |  | 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
[NAME] | 510 |  | D | D | D | D |  |  |  |  |  |  |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | D | D | D | D | D
CARL | 515 |  |  |  |  |  |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N | N
DON | 520 |  | N |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | D | D | D | D | D | D | D
FRANK | 525 |  | N |  | WD |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | N | N | N | N | N | N | N
Spreadsheet: 28036d1221834181-transfering-data-to-new-source-transferring-crystal-to-excel
Sheet: Sheet1

00:00 | 3
00:15 | 1
00:30 | 1
00:45 | 2 |  | sum of b2:[NAME]
01:00 | 1 |  | 7
02:00 | 3
03:00 | 1 |  | This counts as an entire hour. The issue is (if you look at 2am-3am) there is only
03:15 | 1 |  | one entry for the hour. I am trying to sum up everything at hourly time periods, so
04:00 | 1 |  | I'm wondering if I could make it do a search of times (2:00,2:15, 2:30, 2:45) first -
04:15 | 1 |  | then give me the results of those cells. So it would look like this
04:30 | 1
05:15 | 1 |  | 7 | 1 | 3 | 2
05:30 | 1 |  | 1900-01-01 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00
05:45 | 1
06:00 | 1
07:00 | 2
07:30 | 2
07:45 | 1
08:00 | 3
08:15 | 4
08:30 | 3
08:45 | 6
09:00 | 3
09:15 | 6
09:30 | 10
09:45 | 5
10:00 | 5
10:15 | 3
10:30 | 2
10:45 | 4
11:00 | 2
11:15 | 2
11:30 | 1
11:45 | 4
12:00 | 2
12:15 | 3
12:30 | 5
12:45 | 5
13:00 | 3
13:15 | 4
13:30 | 4
13:45 | 3
14:00 | 5
14:15 | 5
14:30 | 3
14:45 | 3
15:00 | 8
15:15 | 5
15:30 | 9
15:45 | 13
16:00 | 5
16:15 | 3
16:30 | 5
16:45 | 1
17:00 | 3
17:15 | 7
17:30 | 3
17:45 | 5
18:00 | 1
18:15 | 1
18:45 | 3
19:00 | 3
19:15 | 2
19:30 | 2
19:45 | 2
20:00 | 5
20:30 | 6
20:45 | 1
21:00 | 2
21:15 | 1
21:30 | 1
22:00 | 3
22:15 | 2
22:45 | 3
23:00 | 1
23:15 | 3
23:30 | 4
Spreadsheet: 741356d1626985071-formula-to-look-into-sheet-named-here-and-extract-values-into-columns-in-sheet-named-output-extract-values-kvs-mod
Sheet: OUTPUT expected

 |  |  |  | Section I |  |  | Section II |  |  | Section III
S/N | Name + Unique # | Name | Sales # | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 | BPC | 1 | 1 | TNT | 2 | 2
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 | BPC | 1 | 1 | TNT | 2 | 2
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 | BPC | 1 | 1 | TNT | 2 | 2
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 | BPC | 1 | 1 | TNT | 2 | 2
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 | BPC | 1 | 1 | TNT | 2 | 2
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 | BPC | 1 | 1 | TNT | 2 | 2
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 | BPC | 1 | 1 | TNT | 2 | 2
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1 | BPC | 1 | 1 | TNT | 2 | 2
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777778 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777779 | BPC | 1 | 1
Spreadsheet: 797062d1663691065-adding-second-if-criteria-to-array-formula-jade-help-file
Sheet: Results

Fiche | Annee | [NAME] | Mat | Grp | DateDeb | AnneeSanct | MoisSanct | JourSanct | IndTransm | TxfMat | Etat | Service | [NAME] | NoSeqMat | NbNotesAnt | ChemScol | DateInscriptionRes
1 | 2021 | 3 | 961213 | RE1 |  | 2022 | 02 | 18 | 1 |  | 1 | 8 | SU | 339259 | 0
1 | 2021 | 3 | 961222 |  | 20210907 | 2022 | 02 | 04 | 1 |  | 1 | 1 | SU | 328774 | 0
2 | 2021 | 1 | 961012 |  | 20211202 | 2022 | 01 | 11 | 1 |  | 1 | 1 | EC | 330088 | 0
2 | 2021 | 1 | 961034 | RE1 | 20220120 | 2022 | 01 | 20 | 1 |  | 1 | 8 | SU | 338205 | 0
3 | 2021 | 1 | 960623 |  | 20211208 | 2022 | 01 | 27 | 1 |  | 1 | 1 | SU | 330089 | 0
3 | 2021 | 1 | 960644 |  | 20220113 | 2022 | 02 | 22 | 1 |  | 1 | 1 | EC | 330091 | 0
4 | 2021 | 1 | 961195 |  | 20211119 | 2022 | 02 | 08 | 1 |  | 1 | 1 | SU | 329886 | 0
4 | 2021 | 1 | 961204 |  | 20211125 | 2022 | 01 | 19 | 1 |  | 1 | 1 | SU | 329887 | 0
4 | 2021 | 1 | 961175 |  | 20210318 | 2022 | 02 | 15 | 1 |  | 1 | 1 | PN | 322911 | 0
5 | 2021 | 2 | 961185 | B | 20210520 | 2022 | 02 | 10 | 1 |  | 1 | 1 | 60 | 324331 | 0
Spreadsheet: 0ec93f4d-726c-430d-b0cb-81404705c315
Sheet: Sheet1

[NAME] AND RECREATION - TIME SHEET | 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
V - Vac   S - Sick   FE - Family Emerg   DR - Doctor   H - Holiday    FH - Floating  Hol   WH - Worked Hol   CE - Comp Earned   CT - Comp Taken    OT - Overtime
Last Name/First Name |  |  |  |  | Work Location/Section |  |  |  |  | Job Title | YJC
Payroll period starting and ending date (M/D/Y) |  |  |  | 10/6 - 10/19 |  | Pay Period | 22 | [NAME] | 33185 |  | Proj.Code | 33000
Time of Day Worked |  | Day | Date | Reg | Shift | O.T. | C.E. | Vac. | Sick. | S/FE/DR | C.T. | Hol/Oth | Total
 |  | Sa | 2012-10-06 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | Su | 2012-10-07 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | M | 2012-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | T | 2012-10-09 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | W | 2012-10-10 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | Th | 2012-10-11 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | F | 2012-10-12 00:00:00 |  |  |  |  |  |  |  |  |  | 0
Sub Total Week 1 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  | Sa | 2012-10-13 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | Su | 2012-10-14 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | M | 2012-10-15 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | T | 2012-10-16 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | W | 2012-10-17 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | Th | 2012-10-18 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 |  | F | 2012-10-19 00:00:00 |  |  |  |  |  |  |  |  |  | 0
Sub Total Week 2 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
Total Hrs. Pay Period |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
Reason for O.T., C.T. or Notes (such as last day in City employment or other news)
Employees Signature |  |  |  |  | Supervisor Signature |  |  |  |  |  | Phone
Please use a separate time sheet for each work location. All time sheets must be signed. All recreation center time sheets must be turned in to supervisor no later than Wednesday prior to
payday. Employees need to ensure that time sheets are clearly legible and accurate. Please highlight out-of-title hours. Failure to do so may result in an incorrect paycheck.
Spreadsheet: 97e8ee5f-54c7-4c07-83b7-caf2e0729129
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
FORM F:  Wireless Per Pole Fee Report Form - City of Portland, Oregon
This form is for use by wireless companies that pay a Right-of-Way Use (per-pole) fee.
LINE 1a | Name of Company:_______________________________________________________
LINE 1b | Address (city, state, zip):_______________________________________________________
LINE 2 | Reporting Period:  Year:_______ |  |  | (Jan - Dec)
 |  | ___Annual Report     or |  | ___Minimum Annual Fee
 |  | (answer all) |  | (skip to LINE 13)
LINE 3 | Annual per-pole fee paid last reporting period (e.g., $3,386.25, $5,000.00, etc.) |  |  |  |  |  | $____________
LINE 4 | CPI change from Dec 31 of prior year to Dec 31 of report year |  |  |  |  |  | %___________
 | (CPI figure to be provided by the City)
LINE 5 | Fee increase (multiply LINE 3 by LINE 4) |  |  |  |  |  | $____________
LINE 6 | Annual per-pole fee applicable for reporting period (add LINE 3 and LINE 5) |  |  |  |  |  | $____________
LINE 7 | Monthly per-pole fee applicable for reporting period (divide LINE 6 by the number 12) |  |  |  |  |  | $____________
LINE 8 | Total number of poles in Portland's public right-of-way with facilities attached (see agreement, permit, or franchise for definition of Attached Facilities) |  |  |  |  |  | __________
LINE 9 | Provide the following detail for each pole counted in LINE 8
 | (add more rows as necessary)
 | Site number or site ID | Pole location (address, or street intersection if address is unavailable) |  |  | Date installed | Months in RoW - 2011 | Fee (multiply months by LINE 7)
1 |  |  |  |  |  |  | $
2 |  |  |  |  |  |  | $
3 |  |  |  |  |  |  | $
4 |  |  |  |  |  |  | $
5 |  |  |  |  |  |  | $
6 |  |  |  |  |  |  | $
LINE 10 | Subtotal of fee (Total of all fees for all poles in LINE 9) |  |  |  |  |  | $____________
LINE 11 | Other Credits / Adjustments (list all by source and amount; attach additional pages if needed):
 | 1. Minimum Annual Fee previously paid for reporting period. |  |  |  |  | $________________
 | 2. Other (specify) |  |  |  |  | $________________
 | Total |  |  |  |  |  | $____________
LINE 12 | TOTAL FEE (Subtract LINE 11 from LINE 10) |  |  |  |  |  | $____________
LINE 13 | MINIMUM ANNUAL FEE DUE FOR THIS YEAR. |  |  |  |  |  | $____________
LINE 14 | TOTAL REMITTANCE: |  |  |  |  |  | $____________
Signature: |  |  |  |  | Date
_____________________________________________________________________________
Print name, title, telephone number and email address
I hereby certify that all statements made in this report and any of its attachments are true, complete and accurate to the best of my knowledge.
Remit to: City of Portland, Office for Community Technology, P.O. Box 745, Portland, OR 97207-0745
Form issue date:  12/29/09
Spreadsheet: 166826d1341826589-excel-2007-copying-data-from-list-to-multiple-worksheets-sample-for-excel-forum
Sheet: data for week

 |  | SALES |  |  |  |  |  | CANCELS
ref no | SALESPERSON | PG | ATP | SPG | SALES | SALE VALUE | BOND | PG2 | ATP3 | SPG4 | CANCEL VALUE
1 | [NAME] | 1 | 1 |  | 2 | 40 | 12 |  |  |  | 0
2 | Iain [NAME] | 1 | 1 | 2 | 4 | 80 | 24 |  |  |  | 0
3 | [NAME] |  | 4 | 3 | 7 | 140 | 42 |  |  |  | 0 |  |  |  |  | PG | ATP | SPG
4 | [NAME] | 1 | 7 | 1 | 9 | 180 | 54 | 1 | 3 | 0 | 80 |  |  |  | SALE | 20 | 20 | 20
5 | [NAME] |  | 3 | 2 | 5 | 100 | 30 |  |  |  | 0 |  |  |  | BOND | 6 | 6 | 6
6 | [NAME] Townsend |  | 5 |  | 5 | 100 | 30 |  |  |  | 0
7 | [NAME] |  | 1 |  | 1 | 20 | 6 |  |  |  | 0
8 | [NAME] |  | 6 | 3 | 9 | 180 | 54 | 0 | 2 | 1 | 60
9 | [NAME] |  | 1 |  | 1 | 20 | 6 |  |  |  | 0
10 | [NAME] |  | 6 |  | 6 | 120 | 36 | 0 | 4 |  | 80
11
12 etc
 | Total | 3 | 35 | 11 | 49 | 980 | 294 | 1 | 9 | 1 | 220
Spreadsheet: 64492d1265326691-generating-new-table-from-system-report-claims
Sheet: Sheet1

 |  |  | Existing structure |  |  |  |  | Wanted structure
Claim # | Coverage | Date | Loss/reserve | Amount | Quarter |  |  | Claim # | Coverage | Loss/reserve | Q4 | Q3 | Q2
CLOK-9000020 | PD | 2009-07-01 00:00:00 | Reserve | 1000 | 3 |  |  | CLOK-9000020 | PD | Reserve | 343 | 893
CLOK-9000020 | PD | 2009-07-15 00:00:00 | Paid Loss | -893.08 | 3 |  |  | CLOK-9000020 | PD | Paid Loss | -343 | -893
CLOK-9000020 | PD | 2009-07-29 00:00:00 | Reserve | -106.92 | 3 |  |  | CLAR-9000143 | COLL | Reserve | 3600
CLOK-9000020 | PD | 2009-10-05 00:00:00 | Paid Loss | -342.99 | 4 |  |  | CLAR-9000143 | COLL | Paid Loss | -3600
CLOK-9000020 | PD | 2009-10-05 00:00:00 | Reserve | 342.99 | 4 |  |  | CLAR-9000143 | PD | Reserve | 800
CLAR-9000143 | COLL | 2009-10-22 00:00:00 | Reserve | 3600 | 4 |  |  | CLAR-9000143 | PD | Paid Loss | -800
CLAR-9000143 | PD | 2009-10-26 00:00:00 | Paid Loss | -780.76 | 4
CLAR-9000143 | PD | 2009-10-26 00:00:00 | Reserve | 800 | 4
CLAR-9000143 | PD | 2009-10-26 00:00:00 | Reserve | -19.24 | 4
CLAR-9000143 | COLL | 2009-11-16 00:00:00 | Paid Loss | -2616.5 | 4
CLAR-9000143 | COLL | 2009-11-16 00:00:00 | Reserve | -983.5 | 4
CLAR-9000171 | PD | 2009-11-03 00:00:00 | Reserve | 2100 | 4
CLAR-9000171 | BI | 2009-11-03 00:00:00 | Reserve | 4000 | 4
CLAR-9000171 | PD | 2009-11-05 00:00:00 | Paid Loss | -2283.88 | 4
CLAR-9000171 | PD | 2009-11-05 00:00:00 | Reserve | 183.88 | 4
CLAR-9000183 | COLL | 2009-11-10 00:00:00 | Reserve | 2400 | 4
CLAR-9000183 | PD | 2009-11-10 00:00:00 | Reserve | 2100 | 4
CLAR-9000183 | PD | 2009-11-19 00:00:00 | Paid Loss | -3427.08 | 4
CLAR-9000183 | PD | 2009-11-19 00:00:00 | Reserve | 1327.08 | 4
CLAR-9000183 | PD | 2009-12-10 00:00:00 | Reserve | 1472.92 | 4
CLAR-9000183 | COLL | 2009-12-16 00:00:00 | Paid Loss | -5068.75 | 4
CLAR-9000183 | COLL | 2009-12-16 00:00:00 | Paid Loss | -80 | 4
CLAR-9000183 | COLL | 2009-12-16 00:00:00 | Reserve | 2668.75 | 4
CLAR-9000183 | COLL | 2009-12-16 00:00:00 | Reserve | 80 | 4
CLAR-9000183 | PD | 2009-12-30 00:00:00 | Paid Loss | -1906.74 | 4
CLAR-9000183 | PD | 2009-12-30 00:00:00 | Reserve | 433.82 | 4
CLAR-9000188 | COLL | 2009-11-10 00:00:00 | Reserve | 2400 | 4
CLAR-9000188 | PD | 2009-11-10 00:00:00 | Reserve | 2100 | 4
CLAR-9000188 | BI | 2009-11-20 00:00:00 | Reserve | 4000 | 4
Spreadsheet: 786851d1657509650-how-to-get-a-set-of-memory-array-formulas-from-a-region-area-forum-help7-11
Sheet: Sheet1

 | 15.5 | 24 | 35.9 | 21.3 |  |  |  | 15.5 | > | {15.5,24,35.9,21.3}
 |  | 89 | 11 | 12.8 | 19.3 |  |  | 89 | > | {89,11,12.8,19.3}
 |  |  | 16.8 | 33.4 | 36.7 | 6.8 |  | 16.8 | > | {16.8,33.4,36.7,6.8}
 | 3.6 |  | 7.8 | 3.5 |  | 2.6 |  | 3.6 | > | {3.6,7.8,3.5,2.6}
Spreadsheet: john_griffith__16031__2_5_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 135 | 145 | 53.9 | 57.9 | 0.7 | 2002-02-05 14:40:00
 | CL J2 | 20.5 | 250 | 258 | 47.6 | 49.1 | 0.62 | 2002-02-05 14:40:00
 | CL K2 | 20.5 | 330 | 334 | 46.2 | 46.7 | 0.6 | 2002-02-05 14:40:00
 | CL M2 | 20.5 | 380 | 390 | 45 | 46.1 | 0.59 | 2002-02-05 14:40:00
 | CL N2 | 20.5 | 422 | 430 | 43.6 | 44.5 | 0.57 | 2002-02-05 14:40:00
 | CL Q2 | 20.5 | 450 | 465 | 42.2 | 43.6 | 0.55 | 2002-02-05 14:40:00
 | CL U2 | 20.5 | 470 | 480 | 40.8 | 41.6 | 0.53 | 2002-02-05 14:40:00
 | [NAME] | 20.5 | 475 | 495 | 38.2 | 39.8 | 0.5 | 2002-02-05 14:40:00
 | CL X2 | 20.5 | 480 | 500 | 36.3 | 37.9 | 0.48 | 2002-02-05 14:40:00
 | [NAME] | 20.5 | 493 | 505 | 35.5 | 36.4 | 0.46 | 2002-02-05 14:40:00
 | CL F3 | 20.5 | 495 | 515 | 34 | 35.4 | 0.45 | 2002-02-05 14:40:00
 | CL G3 | 20.5 | 505 | 525 | 33.3 | 34.6 | 0.44 | 2002-02-05 14:40:00
 | CL M3 | 21 | 535 | 550 | 30.2 | 31 | 0.4 | 2002-02-05 14:40:00
 | CL Z3 | 21 | 540 | 568 | 26.5 | 27.9 | 0.36 | 2002-02-05 14:40:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 121474d1316090793-how-to-use-multiple-autofilters-nhl94-player-ratings
Sheet: Vancouver

Canucks
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | Stick Lt | [NAME] | Glove Lt
G | [NAME] | L | 1 | 204 | 65 | 65 | 65 | 65 | 65 | 25 | 25 | 25 | 65 | 65 | 55 | 55
G | [NAME] | L | 35 | 180 | 45 | 55 | 85 | 85 | 45 | 25 | 25 | 25 | 45 | 55 | 45 | 55
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
C | Cliff Ronning | L | 7 | 180 | 85 | 85 | 65 | 55 | 45 | 45 | 65 | 55 | 85 | 35 | 65 | 35
C | [NAME] | L | 32 | 188 | 55 | 55 | 65 | 55 | 55 | 55 | 55 | 65 | 55 | 25 | 55 | 35
C | Petr Nedved | L | 19 | 180 | 45 | 45 | 65 | 55 | 45 | 35 | 55 | 100 | 65 | 45 | 55 | 55
C | [NAME] | L | 15 | 220 | 45 | 45 | 55 | 55 | 45 | 45 | 45 | 55 | 55 | 25 | 45 | 45
LW | [NAME] | L | 14 | 196 | 85 | 85 | 65 | 55 | 55 | 35 | 65 | 55 | 55 | 45 | 65 | 65
LW | [NAME] | L | 8 | 196 | 55 | 55 | 65 | 65 | 55 | 55 | 55 | 85 | 65 | 35 | 55 | 35
LW | [NAME] | L | 27 | 228 | 65 | 55 | 55 | 55 | 55 | 65 | 45 | 55 | 65 | 65 | 45 | 65
LW | [NAME] | R | 17 | 212 | 45 | 55 | 55 | 55 | 55 | 45 | 45 | 85 | 55 | 35 | 45 | 55
LW | [NAME] | L | 29 | 228 | 45 | 45 | 45 | 55 | 45 | 55 | 45 | 35 | 55 | 55 | 45 | 100
LW | [NAME] | L | 23 | 196 | 45 | 45 | 45 | 55 | 45 | 55 | 45 | 55 | 55 | 55 | 45 | 55
RW | Pavel Bure | L | 10 | 180 | 85 | 100 | 85 | 65 | 65 | 45 | 85 | 65 | 65 | 65 | 65 | 45
RW | [NAME] | R | 16 | 212 | 65 | 65 | 65 | 65 | 65 | 55 | 65 | 65 | 65 | 55 | 65 | 45
RW | [NAME] | R | 25 | 228 | 35 | 45 | 55 | 55 | 55 | 45 | 45 | 45 | 55 | 55 | 45 | 65
RW | [NAME] | R | 26 | 212 | 45 | 45 | 35 | 45 | 45 | 55 | 45 | 55 | 45 | 55 | 45 | 65
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
D | [NAME] | L | 21 | 196 | 65 | 55 | 55 | 65 | 45 | 55 | 65 | 35 | 65 | 35 | 65 | 45
D | [NAME] | L | 44 | 228 | 45 | 45 | 55 | 65 | 55 | 45 | 55 | 25 | 65 | 45 | 55 | 55
D | [NAME] | L | 24 | 220 | 55 | 55 | 55 | 55 | 55 | 45 | 55 | 35 | 65 | 35 | 55 | 65
D | [NAME] | L | 5 | 212 | 45 | 55 | 45 | 55 | 65 | 65 | 45 | 35 | 65 | 65 | 45 | 65
D | [NAME] | L | 6 | 196 | 45 | 45 | 55 | 55 | 45 | 55 | 45 | 45 | 55 | 25 | 45 | 55
D | [NAME] | L | 22 | 228 | 45 | 45 | 35 | 55 | 45 | 55 | 55 | 45 | 55 | 55 | 45 | 65
D | [NAME] | R | 3 | 212 | 55 | 55 | 45 | 55 | 55 | 65 | 65 | 35 | 65 | 35 | 65 | 45
D | [NAME] | R | 4 | 220 | 55 | 55 | 45 | 55 | 65 | 65 | 55 | 35 | 55 | 65 | 55 | 65
Spreadsheet: 71058d1271793664-assigning-values-from-fixed-data-set-to-variable-data-set-zipcode_class
Sheet: Variable

ZIP | Class
613
614
616
617
622
623
624
627
631
636
637
638
641
660
662
664
667
669
670
674
676
198
199
501
544
601
602