tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 06f5057b-c912-4fa8-b499-23a111d8711e
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2012-09-11 00:00:00 | State Senate District 5 - Democratic
 | Harris, d | Pierce, d | Howard, r | [NAME], r | [NAME]
Canaan | 77 | 160
Charlestown | 115 | 129 |  |  | 1
Claremont Ward 1 | 79 | 79 |  | 2 | 1
Claremont Ward 2 | 155 | 130
Claremont Ward 3 | 149 | 63 | 3
Cornish | 42 | 140 | 3 |  | 1
Enfield | 87 | 213
Hanover | 154 | 1037
Lebanon Ward 1 | 109 | 251
Lebanon Ward 2 | 86 | 207 |  | 1
Lebanon Ward 3 | 68 | 229
Lyme | 41 | 244
Plainfield | 62 | 210
Totals | 1224 | 3092 | 6 | 3 | 3
 | State Senate District 6 - Democratic
 | Leonard, d | Cataldo, r | Green, r | [NAME]
Alton | 203 |  | 2 | 1
Barnstead | 261 |  |  | 3
Gilmanton | 218 |  |  | 2
Farmington | 245 | 3 | 7 | 4
New Durham | 148 |  | 3 | 1
Rochester Ward 1 | 242 | 2 | 5 | 2
[NAME] | 240 |  | 8
[NAME] 3 | 242 | 1 | 7 | 2
Rochester Ward 4 | 268 |  | 2 | 2
Rochester Ward 5 | 214
Rochester Ward 6 | 210 |  | 6 | 1
Totals | 2491 | 6 | 40 | 18
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 7 Reading

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 7
Grade 7 Reading [NAME]
Raw Score | Scale Score*** | Level
0 | 124 | D
1 | 135 | D
2 | 142 | D
3 | 147 | D
4 | 151 | D
5 | 155 | D
6 | 159 | D
7 | 164 | D
8 | 169 | D
9 | 175 | D
10 | 180 | D
11 | 184 | D
12 | 186 | D
13 | 188 | D
14 | 190 | P
15 | 192 | P
16 | 193 | P
17 | 194 | P
18 | 196 | P
19 | 197 | P
20 | 199 | P
21 | 200 | M
22 | 202 | M
23 | 204 | M
24 | 206 | E
25 | 209 | E
26 | 214 | E
27 | 223 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 267948d1380311641-pulling-data-from-a-master-list-company-wide-employee-list-final1
Sheet: Dallas

EMP ID | Dallas Org Chart |  |  |  |  |  | I want a formula that will have the employee name autopopulated.
 | Seabolt, [NAME] |  |  |  |  |  | The Emp Id And Position will pull once the name is populated
 | Shakhmeyster, [NAME] |  | this is a helper cell |  |  |  | I think the names should be pulled from "Location & Job Title".
 |  |  | count of
Sales
 | [NAME], [NAME] |  | location | Little Rock |  | Just change the info in these two cells and it will populate in the green columns that I made
 |  |  | job title | sales manager
 |  |  |  | EMP ID | NAME | JOB | [NAME]
Administrative
Operation
 | [NAME], [NAME]
Drivers
 | [NAME], Erasto
Yard Employees
 | [NAME], [NAME]
[NAME]
 | [NAME], [NAME]
Spreadsheet: 478638d1472927017-how-to-automate-date-in-subsequent-tabs-general-daily-cashflow_sept_vik-rev-02
Sheet: 091416

XXXX INC.
DAILY CASH FLOW POSITION AS ON |  |  |  | 2016-09-14 00:00:00
 | .
INCOMING (XXXX) |  |  |  |  |  | INCOMING (YYYY)
Driver | ROUTE | MONEY COLLECTED |  |  |  | Driver | ROUTE | MONEY COLLECTED
 |  | CASH | Money Order | CHECKS |  |  |  | CASH | Money Order | CHECKS
JAVIER | 8
[NAME] | 8 |  |  |  |  | LUIS C | 31
HARVEY | 12 |  |  |  |  | AUGY | 32
ROJO | 13 |  |  |  |  | BUD | 33
EFREN | 16
BRENT | 25 |  |  |  |  |  | Total Routes
LUIS G | 50
[NAME] | 150 |  |  |  |  |  | SHORT
[NAME] | 550 |  |  |  |  |  | HOLDS
WILSON | 76 |  |  |  |  |  | RECEIPTS
LUIS G 8/9 | 50 |  |  |  |  |  | Total Outgo
ROJO 8/9 | 13
JAVIER M 8/8 | 8
[NAME] | 450
 | Collection |  |  |  |  |  | DEPOIST TO ROCKVIEW
 | Total Routes
 | Other Cashflow
 | Previous Day not accounted
 | Checks reced in Mail |  |  |  |  | XXXX- MISC.
 | Checks redeposited NSF
 | Checks on HOLD |  |  |  |  | NAME |  | SHORTAGE
 |  |  |  |  |  | [NAME] |  | 0
 | Total Incoming (XXXX) |  |  |  |  | HARVEY |  | 0
 |  |  |  |  |  | ROJO |  | 0
 |  |  |  |  |  | EFREN |  | 0
OUTGOING (XXXX) |  |  |  |  |  | BRENT |  | 0
 | [NAME] |  |  |  |  | LUIS G |  | 0
 | Petty cash (Receipts) |  |  |  |  | [NAME] |  | 0
 | Mechanics |  |  |  |  | [NAME] |  | 0
 | Payroll |  |  |  |  | WILSON |  | 0
 | [NAME] |  |  |  |  | CLAUDIO RT |  | 0
 | [NAME]
 | Rockview |  |  |  |  | TOTAL SHORTAGE
 | [NAME]
 | Checks Bounced |  |  |  |  | [NAME]
 |  |  |  |  |  | DATE |  | CREDIT
 | Total Outgoing (XXXX)
RECONCILIATION (XXXX)
 | Total Incoming (XXXX)
 | Total Outgoing (XXXX)
 | [NAME]
 | BANK DEPOSITS
 | CASH HANDED OVER
 | SHORTAGE
Spreadsheet: 587048d1534803558-data-lookup-across-multiple-sheets-using-data-validation-sample
Sheet: Master

 | Select a Date
 | Select Geo |  |  |  |  |  | [NAME]
 | Receiving |  |  | [NAME] |  |  | Crash Rate
 | Cartons Received |  |  | [NAME] |  |  | Loads
 | % to LW |  |  | % to LW |  |  | Crashes
 | Average 12 week cartons |  |  | 12 week average |  |  | Crash Rate
 | This week vs 12 Week % |  |  |  |  |  | 6 wk [NAME]
 | Item Level Received Cartons |  |  | OOS Audits
 | Item Level Receiving Percentage
 |  |  |  | [NAME]
 | Errors |  |  | % to LW
 | [NAME] |  |  | 12 week average
 | [NAME] not on File
 | Error % |  |  | [NAME]
 |  |  |  | [NAME]
 | Logins |  |  | % to LW
 |  |  |  | 12 week average
 | [NAME]
 | % to LW
 | 12 week average (unique) |  |  | Units Refilled
 | Total Logins
 | % to LW |  |  | Total Units Refilled
 | 12 week averge (total) |  |  | % to LW
 |  |  |  | Average 12 week
 |  |  |  | This week vs 12 Week %
Spreadsheet: 477159d1472150818-formula-to-add-row-data-if-blank-then-data-from-different-sheet-with-reference-criteria-sumofthings_response
Sheet: Estimate Full Year

2016-06-01 00:00:00 | YTD
 |  |  | Help Here
 |  |  | Completed + Plan2 | Plan | Historic | Var C+P2 vs. Plan | % | Var C+P2 vs. [NAME] | %
 |  | C Holcom
 |  | A Ivanson
 |  | B Risuto
 |  | M Franklin
Spreadsheet: 03791b22-419c-4228-9849-e053e0f50d98
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
FHV2Q | Test | FHV2Q | HIV-2 DNA/RNA Qualitative Real-Time PCR | HIV-2 DNA/RNA [NAME] | Real Time-Polymerase Chain Reaction (PCR) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 5 | mL | Container/Tube: Yellow top (ACD solution A) or lavender top (EDTA) [NAME]: 1 mL | 0.4 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Reference Range: Not Detected   This test was developed and its performance characteristics have been determined by Focus Diagnostics. Performance characteristics refer to the analytical performance of the test.   This test is performed pursuant to a license agreement with Roche Molecular Systems, Inc.   Test Performed by: Focus Diagnostics, Inc.                                        5785 Corporate Ave.                                        Cypress, CA 90630 | Monday through Sunday | 1 - 3 days | 3 - 6 days | 1 | 87538 |  |  |  |  | Focus Diagnositics, Inc.
FHV2Q | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 7 days
FHV2Q | Result | Z0711 | HIV-2 DNA/RNA | HIV-2 DNA/RNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 587348d1534969066-conditional-formula-based-on-sales-amount-jtakwformula-bonus2
Sheet: Sheet1

 |  |  |  | Criteria | Sales Amount |  | % Bonus
 |  |  |  | Less than 500k | 0 |  | 0
 |  |  |  | Greater than 500k but less than 750K | 500000 |  | 0.015 | Greater than 500k but less than 750K - 1.5%
 |  |  |  | Greater than [NAME] but less than 1M | 750000 |  | 0.015 | Upto 750K = 1.5% |  | 1.5% + 0.5%
 |  |  |  | Greater than 1M but less than 2M | 1000000 |  | 0.03 | Upto 1M Sales Bonus rate is 750K = 1.5%, Next 250K 2% |  | 1.5%+1.5%
 |  |  |  | Greater than 2M but less than 3M | 2000000 |  | 0.04 | Upto 2M Sales Bonus rate is 750K = 1.5%, Next 250K 2% ; Next 1M=3%
 |  |  |  | Greater than 3M | 3000000 |  | 0.05 | >2M Sales Bonus rate is 750K = 1.5%, Next 250K 2% ; Next 1M=3%, Next = 5%
 |  |  |  |  |  |  |  | 750000 | 0.015
Input | Input |  | [NAME] |  |  |  |  | 250000 | 0.02
[NAME] | Sales amount | Bonus Rate | Bonus Amount |  |  |  |  | 1000000 | 0.03
Sales 1 | 560000 |  | 0.015 |  | Example of 1,350,000
Sales 2 | 751000
Sales 3 | 795000 |  |  |  | 750000 | 0.015
Sales 4 | 2300000 |  |  |  | 250000 | 0.02
Sales 5 | 3500000 |  |  |  | 350000 | 0.03
Sales 6 | 1350000
Spreadsheet: 845767d1697121456-sumproduct-with-multiple-criteria-and-table-proof-of-concept_revenue
Sheet: Sheet1

 |  |  |  | ITEM |  | VALUE/ |  |  |  | VALUE/ |  |  |  |  |  |  | SCENARIO
allocation type | allocation type | allocation type | category | [NAME] | NO. UNITS | UNIT | NSA/UNIT | CAP RATE | GFA/UNIT | UNIT | comment |  | NSA | GFA | VALUE |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 1 | 1 | REVENUE | 4B HOUSE - N | 8 | 10000 | 250 | 1 |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1
 | 2 | 2 | REVENUE | 4B DUAL OCCUPANCY - N | 16 | 10000 | 210 | 1 |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0
 | 3 | 3 | REVENUE | 4B HOUSE - S | 8 | 10000 | 250 | 1 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0
 | 4 | 4 | REVENUE | 4B DUAL OCCUPANCY - S | 16 | 10000 | 210 | 1 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1
 | 5 | 5 | REVENUE
 | 6 | 6 | REVENUE
 | 7 | 7 | REVENUE
 | 8 | 8 | REVENUE
 | 9 | 9 | REVENUE
 | 10 | 10 | REVENUE
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | COMMENT
 |  |  |  |  | NSA | NSA | NSA | NSA | NSA | NSA | NSA | NSA
 |  | want to skip this step
 |  | all | acquisition | Legals and establisment fees
 |  |  | acquisition | Stamp Duty - North
 |  |  | acquisition | Stamp Duty - South
 |  |  | acquisition | Land Purchase - North
 |  |  | acquisition | Land Purchase - South
 |  |  | acquisition | Consultant Fees
 |  |  | acquisition | Valuation
Spreadsheet: 56698d1256826336-moving-information-within-a-workbook-and-inserting-in-sheets-esupply
Sheet: Sheet1

Conway | FXF | FXNL | Old D | R+L |  | Conway | FXF |  | Old D | R+L | Lowest Carrier   250 | Conway | FXF | FXNL | Old D | R+L | Lowest Carrier   300
200 | 200 | 200 | 200 | 200 |  | 250 | 250 |  | 250 | 250 |  | 300 | 300 | 300 | 300 | 300
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 |  |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 70 | 70 |  | 80 |  | 118.19 | 78.16 |  |  | 80 |  | 133.83 | 93.79199999999997 | 93.11399999999998 |  | 86.97
109 | 84.63599999999997 | 84.63599999999997 |  | 80 |  | 118.19 | 95.356 |  |  | 80 |  | 133.83 | 114.426 | 113.604 |  | 86.97
109 | 70 | 70 |  | 80 |  | 118.19 | 78.16 |  |  | 80 |  | 133.83 | 93.79199999999997 | 93.11399999999998 |  | 86.97
109 | 84.63599999999997 | 84.63599999999997 |  | 80 |  | 118.19 | 95.356 |  |  | 80 |  | 133.83 | 114.426 | 113.604 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 |  |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 |  |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 |  |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 84.63599999999997 | 84.63599999999997 |  | 80 |  | 118.19 | 95.356 |  |  | 80 |  | 133.83 | 114.426 | 113.604 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 |  |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 70 | 70 |  | 80 |  | 118.19 | 78.16 |  |  | 80 |  | 133.83 | 93.79199999999997 | 93.11399999999998 |  | 86.97
109 | 70 | 70 |  | 80 |  | 118.19 | 78.16 |  |  | 80 |  | 133.83 | 93.79199999999997 | 93.11399999999998 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 |  |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
 | ok this is what I need to do I need to take F3:F15 information and move it to sheet2 and insert it into A1:15
 | the same goes for column l but that needs to go into sheet 2 in column b
Spreadsheet: 149999d1334242633-sumif-formula-that-looks-at-specific-names-across-two-seperate-ranges-and-4-different-sheets-excel-help-example
Sheet: Totals

 |  | Total | Sheet 1 |  | Sheet 2 |  | Sheet 3
Administration fees |  | Sum of all admin fee from both ranges on all 4 sheets | Sum of all admin fee from both ranges on Sheet1 |  | Sum of all admin fee from both ranges on Sheet2 |  | Sum of all admin fee from both ranges on Sheet3
Property inspection |  | Sum of all Ins fees from both ranges on all 4 sheets | Sum of all admin fee from both ranges on Sheet1 |  | Sum of all admin fee from both ranges on Sheet2 |  | Sum of all admin fee from both ranges on Sheet3
Property preservation |  | Sum of all Prop pres from both ranges on all 4 sheets | Sum of all admin fee from both ranges on Sheet1 |  | Sum of all admin fee from both ranges on Sheet2 |  | Sum of all admin fee from both ranges on Sheet3
BPO |  | Sum of all BPO from both ranges on all 4 sheets | Sum of all admin fee from both ranges on Sheet1 |  | Sum of all admin fee from both ranges on Sheet2 |  | Sum of all admin fee from both ranges on Sheet3
Property appraisal |  | Sum of all Prop appr from both ranges on all 4 sheets | Sum of all admin fee from both ranges on Sheet1 |  | Sum of all admin fee from both ranges on Sheet2 |  | Sum of all admin fee from both ranges on Sheet3
Title search |  | Sum of all Title from both ranges on all 4 sheets | Sum of all admin fee from both ranges on Sheet1 |  | Sum of all admin fee from both ranges on Sheet2 |  | Sum of all admin fee from both ranges on Sheet3
Document fees |  | Sum of all Doc fee from both ranges on all 4 sheets | Sum of all admin fee from both ranges on Sheet1 |  | Sum of all admin fee from both ranges on Sheet2 |  | Sum of all admin fee from both ranges on Sheet3
Insurance fees |  | Sum of all Ins fee from both ranges on all 4 sheets | Sum of all admin fee from both ranges on Sheet1 |  | Sum of all admin fee from both ranges on Sheet2 |  | Sum of all admin fee from both ranges on Sheet3
 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 546458d1510062144-cascading-drop-down-data-validation-lists-with-only-unique-items-remove-duplicates-breakdown-and-max-with-index
Sheet: Sheet1

 |  |  |  |  | Remove Duplicates
 |  |  | [NAME] |  |  |  | [NAME] | <-- Drop down
 |  |  | Fred
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  |  |  |  | Match finds first example like this
 |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  |  |  |  | but if you watn to find the last example you must use
 |  |  | [NAME]
 |  |  |  | This is used as a named range (Ctrl+F3) to create a dynamic drop down | =F6:INDEX(F6:F13,COUNTIF(F6:F13,"*?"))
Spreadsheet: 136534d1326712275-maintaining-text-year-test-booklet
Sheet: 2012

 | Year | 2012
Name | Score | last year
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
Spreadsheet: 83067d1283124520-check-for-xx-yy-point-inside-outside-graphic-area-example_a
Sheet: LIMITS_FOR_ENVELOPE

 | Limits |  |  |  | Envelope Limits |  |  | Extra Envelop Limit Right
 | X Axxis | Y Axxis |  |  | X Axxis | Y Axxis |  | X Axxis | Y Axxis
MZFW_1 | 19 | 181000 |  |  | 29 | 123000 |  | 115 | 157900
MZFW_2 | 123 | 181000 |  |  | 9 | 241000 |  | 104 | 123000
MLDW_1 | 17 | 192000 |  |  | 29 | 275000
MLDW_2 | 127 | 192000 |  |  | 133 | 275000
 |  |  |  |  | 127 | 192000
 |  |  |  |  | 125 | 183000
 |  |  |  |  | 115 | 157900
 |  |  |  |  | 88 | 123000
 |  |  |  |  | 29 | 123000
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: HPL

HPL
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Gottlob |  | Gas |  | HPL |  | 5749630
Riley |  | Gas |  | HPL |  | 1546776
Morris |  | Gas |  | HPL |  | 723434
[NAME], [NAME] |  | Gas |  | HPL |  | 247870
Hall |  | Gas |  | HPL |  | 216719
Snieder |  | Gas |  | HPL
Lamphier |  | Gas |  | HPL
[NAME] |  | Gas |  | HPL |  | 43010
[NAME] |  | Gas |  | HPL |  | 37419
Weissman |  | Gas |  | HPL |  | 12580
Lofton |  | Gas |  | HPL |  | 10149
Peyton |  | Gas |  | HPL |  | 2431
[NAME] |  | Gas |  | HPL |  | -42841
Papayoti |  | Gas |  | HPL
Total
Spreadsheet: 772711d1647440349-need-help-with-lookup-values-between-tabs-book1-6-
Sheet: PDR KIT

PDR KITS
TAG | PDR001 | PDR002 | PDR003 | PDR004 | PDR005 | PDR006 | PDR007 | PDR008 | PDR009 | PDR010 | PDR011 | PDR012 | PDR013 | PDR014 | PDR015 | PDR016 | PDR017
ALLOCATION
DENT PULLER | 1
SLIDING HAMMER | 2
GLUE GUN | 3
GLASS PLATE | 4
WINDOW WEDGE | 5
HAMMER | 6
PUNCH | 7
DENT TOOLS | 8
TOOL HANDLES | 9
[NAME] | 10
BONNET RING | 11
PLUGS LARGE | 12
PLUGS MEDIUM | 13
PLUGS SMALL | 14
GLUE STICKS | 15
Spreadsheet: 71ccd004-4826-4d59-b477-b1e54a97c83a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Total Construction: U.S. Total
 |  | Not Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: May 20, 2013 (3:56 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002 | 59516 | 58588 | 63782 | 69504 | 73384 | 77182 | 78863 | 79460 | 76542 | 75710 | 71362 | 63984
2003 | 59877 | 58526 | 64506 | 69638 | 74473 | 80377 | 82971 | 85191 | 83841 | 83133 | 77915 | 71050
2004 | 64934 | 64138 | 73238 | 78354 | 83736 | 89932 | 93614 | 96164 | 92538 | 90582 | 86394 | 77733
2005 | 71474 | 72048 | 81345 | 85485 | 92959 | 99632 | 103158 | 106706 | 103269 | 102339 | 97549 | 88172
2006 | 81058 | 81478 | 92855 | 95324 | 102495 | 107607 | 108423 | 110434 | 104191 | 101582 | 95339 | 86436
2007 | 79406 | 79177 | 88905 | 93375 | 100534 | 105399 | 107090 | 110430 | 105150 | 103847 | 94822 | 84218
2008 | 77349 | 77227 | 82779 | 87743 | 92781 | 96338 | 98483 | 99786 | 96755 | 95612 | 86067 | 76645
2009 | 66944 | 66296 | 71624 | 75187 | 76808 | 81429 | 83379 | 84368 | 81213 | 79949 | 71906 | 64098
2010 | 55586 | 54019 | 60228 | 66422 | 68906 | 74035 | 73077 | 75834 | 74764 | 73470 | 68019 | 60202
2011 | 50971 | 50184 | 56130 | 60682 | 65845 | 71297 | 69929 | 75101 | 73515 | 73282 | 68476 | 62825
2012 | 56535 | 56108 | 60939 | 66201 | 71635 | 76491 | 78070 | 81457 | 79357 | 81438 | 76737 | 69520
Spreadsheet: 152175d1335278834-assign-a-value-on-conditions-aga_oldest_date_example_24apr12_02
Sheet: Sheet1

id | off_rec | date | year | AGA_formula | ISZ_formula
4 | 56255 | 1999-03-23 00:00:00 | 1999 | 1 | 1
4 | 56255 | 2000-04-17 00:00:00 | 2000 | 0
4 | 56255 | 2000-10-25 00:00:00 | 2000 | 0 | 1
4 | 53358 | 2000-11-24 00:00:00 | 2000 | 0
4 | 53358 | 2000-12-21 00:00:00 | 2000 | 1 | 1
4 | 56255 | 2001-03-23 00:00:00 | 2001 | 1 | 1
4 | 56255 | 2002-06-07 00:00:00 | 2002 | 0
4 | 56255 | 2002-07-08 00:00:00 | 2002 | 0
4 | 56255 | 2002-08-07 00:00:00 | 2002 | 0
4 | 56255 | 2002-09-09 00:00:00 | 2002 | 0
4 | 56255 | 2002-10-07 00:00:00 | 2002 | 0
4 | 56255 | 2002-11-07 00:00:00 | 2002 | 0
4 | 56255 | 2002-12-09 00:00:00 | 2002 | 1 | 1
4 | 56255 | 2003-01-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-02-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-03-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-03-31 00:00:00 | 2003 | 0
4 | 56255 | 2003-04-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-05-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-05-15 00:00:00 | 2003 | 0
4 | 56255 | 2003-06-09 00:00:00 | 2003 | 0
4 | 56255 | 2003-07-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-08-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-09-08 00:00:00 | 2003 | 0
4 | 56255 | 2003-10-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-11-07 00:00:00 | 2003 | 0
4 | 56255 | 2003-12-08 00:00:00 | 2003 | 1 | 1
4 | 56255 | 2004-01-07 00:00:00 | 2004 | 0
4 | 56255 | 2004-02-09 00:00:00 | 2004 | 0
4 | 56255 | 2004-02-27 00:00:00 | 2004 | 0
4 | 56255 | 2004-03-08 00:00:00 | 2004 | 0
4 | 56255 | 2004-04-07 00:00:00 | 2004 | 0
4 | 56255 | 2004-05-07 00:00:00 | 2004 | 0
4 | 56255 | 2004-06-07 00:00:00 | 2004 | 0
4 | 56255 | 2004-07-07 00:00:00 | 2004 | 0
4 | 56255 | 2004-08-09 00:00:00 | 2004 | 0
4 | 56255 | 2004-09-07 00:00:00 | 2004 | 0
4 | 56255 | 2004-10-07 00:00:00 | 2004 | 0
4 | 56255 | 2004-11-08 00:00:00 | 2004 | 0
4 | 56255 | 2004-12-07 00:00:00 | 2004 | 1 | 1
4 | 56255 | 2005-01-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-02-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-03-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-04-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-05-09 00:00:00 | 2005 | 0
4 | 56255 | 2005-06-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-07-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-08-08 00:00:00 | 2005 | 0
4 | 56255 | 2005-09-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-10-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-11-07 00:00:00 | 2005 | 0
4 | 56255 | 2005-12-07 00:00:00 | 2005 | 1 | 1
16 | 28865 | 2004-08-11 00:00:00 | 2004 | 1 | 1
17 | 50114 | 2000-04-10 00:00:00 | 2000 | 1 | 1
18 | 67912 | 2002-05-16 00:00:00 | 2002 | 1 | 1
22 | 24410 | 1999-03-24 00:00:00 | 1999 | 1 | 1
22 | 56879 | 2001-09-25 00:00:00 | 2001 | 1 | 1
31 | 34766 | 1999-11-01 00:00:00 | 1999 | 1 | 1
31 | 34766 | 2000-02-04 00:00:00 | 2000 | 0
31 | 34766 | 2000-09-07 00:00:00 | 2000 | 1 | 1
31 | 34766 | 2001-07-06 00:00:00 | 2001 | 1 | 1
31 | 34766 | 2003-02-20 00:00:00 | 2003 | 0
31 | 34766 | 2003-03-03 00:00:00 | 2003 | 0
31 | 34766 | 2003-03-14 00:00:00 | 2003 | 0
31 | 34766 | 2003-04-02 00:00:00 | 2003 | 1 | 1
Spreadsheet: 009e7954-fbb4-486d-9d42-1345cf5b4d3f
Sheet: Sheet1

RDR-CCB Contact Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | July 31, 2006 – v.1.0 for circulation
RDR Chapter | RDR Chapter Title | (Roughly) Corresponding BCD Chapter | BCD Chapter Title | Primary CCB Contact | Secondary CCB Contact
II-1 | ILC Parameters | 1 | Baseline Parameters | Kubo | [NAME]
II-2 | Electron Source | 2 | Electron Source | Kuriki | [NAME]
II-3 | Positron Source | 3 | Positron Source | Kuriki | [NAME]
II-4 | Damping Rings | 4 | Damping Ring | [NAME] | Kubo
II-5 | RTML | 5 | RTML | Kubo | [NAME]
II-6 | [NAME] | 6 | Main Linac | Funk | Mishra
II-7 | Beam Delivery | 7 | Beam Delivery Systems | Blair | Markiewicz
II-8 | Beam Dynamics | (1) | ([NAME]) | [NAME] | Kubo
II-9 | Operations and Availability | 10 | Operations and Availaility | [NAME] | Kuriki
III-1 | Magnets
III-2 | Vacuum
III-3 | Modulator | 6 | Main Linac | Mishra | Funk
III-4 | Klystron | 6 | Main Linac | Mishra | Pagani
III-5 | Power Distribution | 6 | Main Linac | Funk | Funk
III-6 | Cavities | 6 | Main Linac | Pagani | Funk
III-7 | Cryomodules | 6 | Main Linac | Pagani | Funk
III-8 | LLRF | 11 | Instrumentation and Control | Mishra | Funk
III-9 | Instrumentation | 11 | Instrumentation and Control | Markiewicz | Blair
III-10 | Dumps and Collimators |  |  | Markiewicz | Kubo
III-11 | Controls and Timing | 11 | Instrumentation and Control | Kuriki | Blair
IV | Conventional Facilities | 9 | CF/S | [NAME] | Mishra
V | Sample Sites | 9 | CF/S | [NAME] | Mishra
VI | Cost | 8 | Cost and Engineering | [NAME] | tbd
 | [NAME] | : +81-29-864-5224 | [NAME] at lcdev.kek.jp
 | [NAME] | : +44 1784 443513 | g.blair at rhul.ac.uk
 | [NAME] | : [PHONE] | lwfunk at jlab.org
 | [NAME] | : +81 29 864 5715 | kiyoshi.kubo at kek.jp
 | [NAME] | : +81-29-864-5744 or 5226 | masao.kuriki at kek.jp
 | [NAME] | : +[PHONE] | [NAME] slac.stanford.edu
 | [NAME] | : +[PHONE] | mishra at fnal.gov
 | [NAME] | : +39 02 503 19561 | carlo.pagani at desy.de
 | [NAME] | : +41 22 767 5323 | [NAME].[NAME] at cern.ch
Spreadsheet: 229797d1366580698-i-want-to-keep-names-asscoiated-with-value-cells-when-sorted-sample-for-clavin
Sheet: Sheet1

baron | 56
clavin | 68
roni | 95
[NAME] | 105
gabby | 58