tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5566003d-db4d-491e-83ec-8e862a27176b
Sheet: Emissionsberegninger marginal

Opgørelse af emissioner
Kraftvarmeanlæg
Antal anlæg | Marginal | Anlæg | Type* | Brændselsforbrug | Elproduktion | Emisf. CO2 | CO2 | Emisf. [NAME] | NOx | Emisf. SO2 | SO2 | Emisf. CH4 | CH4 | Emisf. N2O | N2O
 | % |  |  | lokalt GJ | MWh | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME]
1
2
3
4
5
I alt
Kedelanlæg
Antal anlæg | Marginal | Anlæg |  | Brændselsforbrug |  | Emisf. CO2 | CO2 | Emisf. [NAME] | NOx | Emisf. SO2 | SO2 | Emisf. CH4 | CH4 | Emisf. N2O | N2O
 | % |  |  | lokalt GJ |  | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME]
1
2
3
4
5
I alt
Andre varmeproduktionsanlæg
Antal anlæg | Marginal | Anlæg |  | Brændselsforbrug |  | Emisf. CO2 | CO2 | Emisf. [NAME] | NOx | Emisf. SO2 | SO2 | Emisf. CH4 | CH4 | Emisf. N2O | N2O
 | % |  |  | lokalt GJ |  | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME] | kg/GJ | [NAME]
1
2
3
4
I alt
 | Marginal | Anlæg | Varme | CO2 | NOx | SO2 | CH4 | N2O
 | % |  | MWh | kg/MWh | kg/MWh | kg/MWh | kg/MWh | kg/MWh
 | Samlet marginal
Spreadsheet: 43c23f5a-f41b-439f-a719-527f9c7c51a8
Sheet: Sheet1

GENERAL | 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
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
 | Country Club TIF Plan, Project Area 6 |  | 2007-04-06 00:00:00 |  | Meet Statutory Activation
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor | [NAME], Director
 |  |  |  |  |  | Finance Director
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, | City Planning & Development
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents |  | Tax Increment Financing Commission
 | Reason For Legislation
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | City Planning & Development
 |  |  |  |  |  |  | Other
 |  |  |  |  |  |  | Kansas City, MO School District
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By |  |  | Tax Increment Financing Com.
 |  |  |  |  | Recommendation |  |  |  |  |  | Resolution
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME], Development Specialist, EDC
Reviewed by:
Reference Numbers
Spreadsheet: chris_germany__1871__TCO PAL Deal Prompt
Sheet: Model

Columbia Gas Parking & Lending |  |  |  |  |  | 2001-03-21 00:00:00 | Deal #6
PAL Volume | 310000 |  | w/o Index
 |  | TCO | TCO |  | PAL | PAL
 | NYMEX | Basis | Index | Total | Indicator | Volume | Value | PV Factor | PV Value | PAL Fee | PV PAL Fee | PV Profit
2001-04-01 00:00:00 |  |  |  | 5.38 | p |  |  | 0.9997235750731724
2001-05-01 00:00:00 | 5.37 | 0.26 |  |  |  |  |  | 0.9956471638194163
2001-06-01 00:00:00 |  |  |  |  |  |  |  | 0.9915461304083709
2001-07-01 00:00:00 | 5.35 | 0.23 | 0.0025 |  |  |  |  | 0.98773044101502
2001-08-01 00:00:00 | 5.37 | 0.23 | 0.0025 |  |  |  |  | 0.9839196739755462
2001-09-01 00:00:00 | 5.35 | 0.18 | 0.0025 |  |  |  |  | 0.9801794698168694
2001-10-01 00:00:00 | 5.35 | 0.225 | 0.0025 |  |  |  |  | 0.9765746560489015
2001-11-01 00:00:00 | 5.47 |  |  |  |  |  |  | 0.9729125432089629
2001-12-01 00:00:00 | 5.415 | 0.31 | 0.03 |  | l |  |  | 0.9693663856038193
2002-01-01 00:00:00 | 5.44 | 0.31 | 0.03 |  |  |  |  | 0.9656135111511036
2002-02-01 00:00:00 | 5.43 | 0.31 | 0.03 |  |  |  |  | 0.9618798299822233
2002-03-01 00:00:00 |  |  |  |  |  |  |  | 0.9585146080022802
2002-04-01 00:00:00 |  |  |  |  |  |  |  | 0.954774467165146
2002-05-01 00:00:00 |  |  |  |  |  |  |  | 0.9511687686289929
2002-06-01 00:00:00 |  |  |  |  |  |  |  | 0.947406206186989
2002-07-01 00:00:00 |  |  |  |  |  |  |  | 0.9436795663164272
2002-08-01 00:00:00 |  |  |  |  |  |  |  | 0.9398293154790527
2002-09-01 00:00:00 |  |  |  |  |  |  |  | 0.9359459581106956
2002-10-01 00:00:00 |  |  |  |  |  |  |  | 0.9321158896693434
2002-11-01 00:00:00 |  |  |  |  |  |  |  | 0.9281628013704429
2002-12-01 00:00:00 |  |  |  |  |  |  |  | 0.9242712028653612
2003-01-01 00:00:00 |  |  |  |  |  |  |  | 0.9201984201850117
2003-02-01 00:00:00 |  |  |  |  |  |  |  | 0.9161455043140875
2003-03-01 00:00:00 |  |  |  |  |  |  |  | 0.9124201156132493
 |  |  | Spread |  |  |  |  | Totals
 |  |  | Time Value |  |  |  |  | Rate
 |  |  |  |  |  |  |  | Daily PAL Fee Rate |  | -0.0006
Spreadsheet: john_forney__15543__s_10-23-01
Sheet: Sheet1

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-10-23 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  |  |  |  |  |  |  | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350
Enron Call |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mirant Call |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
CP1 |  |  |  |  |  |  |  | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28.5
CP2 |  |  |  |  |  |  |  | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Total
[NAME]: |  | Deal Details
30
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 12 |  | 23
831246.1 |  | [NAME] | 100 | 28.5 | 7 |  | 22
831337.1 |  | [NAME] | 250 | 30 | 7 |  | 22
795243.16 |  | Enron Call | -100 |  | 7 |  | 22
830836.1 |  | Enron Call | 100 |  | 7 |  | 22
831338.1 |  | CP2 | -250 | 30 | 7 |  | 22
831260.1 |  | CP1 | -100 | 28.5 | 7 |  | 22
Spreadsheet: 081dfc3b-7e43-4a0f-8284-c849e1205e0d
Sheet: Sheet1

Table 6--Cottonseed oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | Million pounds
2011/12 | 165 | 755 | 10.34710675614 | 930.34710675614 |  | 571.485951572824 | 258.861155183316 | 830.34710675614 | 100
2012/131 | 100 | 800 | 20 | 920 |  | 600 | 220 | 820 | 100
2013/142 | 100 | 720 | 0 | 820 |  | 515 | 220 | 735 | 85
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2013-07-15 08:35:32.800000
Spreadsheet: 729640d1619230083-ranking-list-based-on-test-scores-new-hire-testing
Sheet: Sheet1

Name A-Z |  | Written Exam |  | Fintess Eval |  | Interview |  | Average of 3 tests | Overall Rank
Last | First | Score | Place | Score | Place | Score | Place |  |  |  |  | Written Exam Helper 1 | Written Exam Helper 2 | Fitness Eval Helper 1 | Fitness Eval Helper 2 | Interview Helper 1 | Interview Helper 2
 |  | 88 |  | 22 |  | 58
 |  | 100 |  | 88 |  | 90
 |  | 100 |  | 85 |  | 25
 |  | 100 |  | 86 |  | 23
 |  | 100 |  | 87 |  | 24
 |  | 100 |  | 88 |  | 25
 |  | 100 |  | 89 |  | 26
 |  | 100 |  | 91 |  | 27
 |  | 100 |  | 90 |  | 28
 |  | 100 |  | 92 |  | 29
 |  | 100 |  | 93 |  | 30
 |  | 100 |  | 94 |  | 31
 |  | 100 |  | 95 |  | 32
 |  | 100 |  | 96 |  | 33
 |  | 100 |  | 97 |  | 34
 |  | 100 |  | 98 |  | 35
 |  | 100 |  | 85 |  | 36
 |  | 100 |  | 84 |  | 37
 |  | 100 |  | 83 |  | 38
 |  | 100 |  | 82 |  | 39
 |  | 100 |  | 81 |  | 40
 |  | 100 |  | 80 |  | 41
 |  | 100 |  | 79 |  | 42
 |  | 100 |  | 78 |  | 43
 |  | 100 |  | 77 |  | 45
 |  | 100 |  | 76 |  | 45
 |  | 100 |  | 75 |  | 46
 |  | 100 |  | 74 |  | 47
 |  | 100 |  | 73 |  | 48
 |  |  |  | 72 |  | 49
Spreadsheet: 709344d1608257214-formula-to-highlight-duplicate-name-cells-in-multiple-rows-and-mult-columns-based-on-date-duplicate-name-finder
Sheet: Sheet1

 | date | crew member 1 | crew member 2 | crew member 3 | crew member 4 | crew member 5
 | 2020-09-28 00:00:00 | fred | bob | [NAME] | [NAME]
 | 2020-09-28 00:00:00 | shannon | jill | ed
 | 2020-09-28 00:00:00 | emily | [NAME] | fred
 | 2020-09-28 00:00:00 | [NAME] | [NAME] | [NAME]
 | 2020-09-29 00:00:00 | fred | bob | ed
 | 2020-09-29 00:00:00 | shannon | [NAME] | [NAME]
 | 2020-09-29 00:00:00 | [NAME] | emily | fred
 | 2020-09-30 00:00:00 | ed | emily | [NAME]
 | 2020-10-01 00:00:00 | ed | [NAME] | [NAME]
 | 2020-10-01 00:00:00 | shannon | jill | ed
 | 2020-10-01 00:00:00 | bob | fred | [NAME]
 | 2020-10-01 00:00:00 | jill | [NAME] | shannon
Spreadsheet: 329928d1404459875-formula-in-column-only-on-visible-cells-dynamic-referencing-excelforum-hidencellsdifference
Sheet: Tabelle1

ID | Num | Date | Dif
i1 | 11 | Date1
i1 | 33 | Date2 | 22
i1 | 66 | Date3 | 33
i3 | 18 | [NAME]
i3 | 39 | Date5 | 21
i5 | 66 | Date6
Spreadsheet: 878571d1725672116-points-given-to-8-people-over-a-year-ef_points_given_to_8_people_over_a_year
Sheet: Best so far

All staff should get 2,250 points over the year, and payout average time should be almost same
Who gets points |  |  | Shuffle | Month | Points
1 | 2 | 3 | 0.963648963587452 | 2 | 500
2 | 3 | 4 | 0.02944407159919527 | 12 | 500
3 | 4 | 5 | 0.1295807727570575 | 10 | 500
4 | 5 | 6 | 0.5754428820377623 | 5 | 500
5 | 6 | 7 | 0.8679796790384262 | 3 | 500
6 | 7 | 8 | 0.07233510110281227 | 11 | 500
7 | 8 | 1 | 0.380303939326276 | 8 | 500
8 | 1 | 2 | 0.3833204689697636 | 7 | 500
1 | 5 | 0 | 0.1647296944486828 | 9 | 750
2 | 6 | 0 | 0.3838452086299818 | 6 | 750
3 | 7 | 0 | 0.7896530675737038 | 4 | 750
4 | 8 | 0 | 0.9886767686453116 | 1 | 750
 |  |  | Standard Deviation
Name | Shuffle | Staff # | 0.9682458365518543 | Check
[NAME] | 0.5431674275289499 | 2 | 27 | 2250
[NAME] | 0.2868309472236167 | 8 | 27 | 2250
[NAME] | 0.4472004758960726 | 7 | 26 | 2250
[NAME] | 0.4601813426272907 | 6 | 25 | 2250
[NAME] | 0.5024616933917431 | 4 | 28 | 2250
[NAME] | 0.4861438436970233 | 5 | 27 | 2250
George | 0.6623888211664215 | 1 | 26 | 2250
[NAME] | 0.5269949997494184 | 3 | 28 | 2250
Payout |  | 2 get 750 each, 3 get 500 each |  |  | Points each
1 | January | [NAME] | [NAME] |  | 750
2 | February | George | [NAME] | [NAME] | 500
3 | March | [NAME] | [NAME] | [NAME] | 500
4 | April | [NAME] | [NAME] |  | 750
5 | May | [NAME] | [NAME] | [NAME] | 500
6 | June | [NAME] | [NAME] |  | 750
7 | July | [NAME] | George | [NAME] | 500
8 | August | [NAME] | [NAME] | George | 500
9 | September | George | [NAME] |  | 750
10 | October | [NAME] | [NAME] | [NAME] | 500
11 | November | [NAME] | [NAME] | [NAME] | 500
12 | December | [NAME] | [NAME] | [NAME] | 500
Spreadsheet: 745665d1630086342-sumproduct-addition-using-wildcards-book2
Sheet: Sheet1

 |  |  |  | 2021-07-24 00:00:00
 |  |  |  | 5 | Data Acquisition - Steep
Data Acquisition - Steep Creek |  | <- wildcard doesn't work |  | 8 | Data Acquisition - Steep Creek | 5 | Data Acquisition - Steep Creek
 |  | <- no wildcard does work |  | 10 | Data Acquisition - Clearwater | 6 | Data Acquisition - Steep Creek
 |  |  |  | 5 | Data Acquisition - Clearwater | 7 | Data Acquisition - Clearwater
 |  |  |  | 6 | Data Acquisition - Steep Creek | 8 | Data Acquisition - Steep Creek
 |  |  |  |  |  | 9 | Data Acquisition - Steep Creek
 |  | <- works but isn't picking up E5 (which it should using the wildcard)
 |  | <- works but isn't picking up E5 (which it should using the wildcard)
 | I want it to add the green cells, so answer should be 47. I need the wildcard to pick up the red highlighted one.
Spreadsheet: 819942d1677774525-count-range-with-dates-not-working-sample-aet
Sheet: DROP DOWN

drop down menu
<> |  | <> |  | ALL
2023-02-27 00:00:00 |  |  |  | 2023-02-28 00:00:00
 |  |  |  |  |  | Overrides
 |  |  |  |  |  | Suspended /RRT
 |  |  |  |  |  | Claim closed
Spreadsheet: 0be7c83d-95f2-4814-aa58-e0897876ab84
Sheet: Detailed Cash Report

GIRL SCOUTS OF MICHIGAN SHORE TO SHORE |  |  |  |  |  | TROOP  # |  |  |  |  |  |  |  |  | PREPARED BY:
 |  |  |  |  |  | FOR THE YEAR |  |  | -
 |  |  |  | INCOME |  |  |  |  |  | EXPENSES
 | Date | Activity / Description |  | Dues | Fall Product / Cookie Sales | Other Funds / Sponsorship |  | TOTAL          INCOME |  | Program Events | Product Sales Sweep/   Square Fees | Badges & Pin Awards | Supplies | Service Projects | Trips & Fees | Copies / Postage |  | TOTAL          EXPENSES |  | Running Balance
 |  | Beginning Balance
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
32
33
34
35
36
37
38
39
40
 |  | TOTALS
 |  | YEAR ENDING
 |  | INCOME
 |  | TOTAL
 |  | EXPENSES
 |  | TOTAL
 |  | N E T
 |  | ADD:   Beginning Balance
 |  | ENDING BALANCE
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: RSmith

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 777723d1650563853-serpentine-numbers-in-a-table-formula-serpentineformula_forum3
Sheet: Sheet3

40 | 39 | 38 | 37 | 36 | 35 | 34 | 33 | 32 | 31
21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Spreadsheet: 587096d1534843468-random-assign-with-equal-count-testing
Sheet: Sheet3

No | Name | Number Task | RAND formula | Validator A | Validator B | Validator C | Validator C
1 | Person A | 2
2 | Person B | 2
3 | Person C | 2
4 | Person D | 2
5 | Person E | 5
6 | Person F | 1
7 | Person G | 1
8 | Person H | 0
9 | Person I | 0
10 | Person J | 0
Spreadsheet: 77ba5e66-27da-4342-90ba-8a3eb44cd2ad
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38880179 | 2013-12-08 03:18:55 | AXIS | 1 | 6 | 3 | 1453121 | KlaasG9 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38931437 | 2013-12-11 17:34:44 | AXIS | 0 | 4 | 7 | 1166072 | hellskitchen29 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
38949572 | 2013-12-12 23:14:27 | AXIS | 1 | 4 | 0 | 1401055 | PanzerBellota | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
38949864 | 2013-12-12 23:26:05 | ALLIES | 0 | 1 | 4 | 1401055 | PanzerBellota | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
Spreadsheet: 534565d1503332219-randbetween-function-with-conditions-personal-tutor-test-spreadsheet
Sheet: Sheet1

Students | Personal Tutor (randomly allocated) |  | Staff List | Capacity | No. allocated
Student 1 |  |  | Staff 1 | 10
Student 2 |  |  | Staff 2 | 10
Student 3 |  |  | Staff 3 | 12
Student 4 |  |  | Staff 4 | 12
Student 5 |  |  | Staff 5 | 10
Student 6 |  |  | Staff 6 | 8
Student 7 |  |  | Staff 7 | 10
Student 8 |  |  | Staff 8 | 8
Student 9 |  |  | Staff 9 | 10
Student 10 |  |  | Staff 10 | 9
Student 11 |  |  | Staff 11 | 10
Student 12 |  |  | Staff 12 | 9
Student 13 |  |  | Staff 13 | 12
Student 14 |  |  | Staff 14 | 8
Student 15 |  |  | Staff 15 | 10
Student 16 |  |  | Staff 16 | 10
Student 17 |  |  | Staff 17 | 10
Student 18 |  |  | Staff 18 | 12
Student 19 |  |  | Staff 19 | 10
Student 20 |  |  | Staff 20 | 10
Student 21 |  |  | Total capacity/allocated
Student 22
Student 23
Student 24
Student 25
Student 26
Student 27
Student 28
Student 29
Student 30
Student 31
Student 32
Student 33
Student 34
Student 35
Student 36
Student 37
Student 38
Student 39
Student 40
Student 41
Student 42
Student 43
Student 44
Student 45
Student 46
Student 47
Student 48
Student 49
Student 50
Student 51
Student 52
Student 53
Student 54
Student 55
Student 56
Student 57
Student 58
Student 59
Student 60
Student 61
Student 62
Student 63
Student 64
Student 65
Student 66
Student 67
Student 68
Student 69
Student 70
Student 71
Student 72
Student 73
Student 74
Student 75
Student 76
Student 77
Student 78
Student 79
Student 80
Student 81
Student 82
Student 83
Student 84
Student 85
Student 86
Student 87
Student 88
Student 89
Student 90
Student 91
Student 92
Student 93
Student 94
Student 95
Student 96
Student 97
Student 98
Student 99
Student 100
Student 101
Student 102
Student 103
Student 104
Student 105
Student 106
Student 107
Student 108
Student 109
Student 110
Student 111
Student 112
Student 113
Student 114
Student 115
Student 116
Student 117
Student 118
Student 119
Student 120
Student 121
Student 122
Student 123
Student 124
Student 125
Student 126
Student 127
Student 128
Student 129
Student 130
Student 131
Student 132
Student 133
Student 134
Student 135
Student 136
Student 137
Student 138
Student 139
Student 140
Student 141
Student 142
Student 143
Student 144
Student 145
Student 146
Student 147
Student 148
Student 149
Student 150
Student 151
Student 152
Student 153
Student 154
Student 155
Student 156
Student 157
Student 158
Student 159
Student 160
Student 161
Student 162
Student 163
Student 164
Student 165
Student 166
Student 167
Student 168
Student 169
Student 170
Student 171
Student 172
Student 173
Student 174
Student 175
Student 176
Student 177
Student 178
Student 179
Student 180
Student 181
Student 182
Student 183
Student 184
Student 185
Student 186
Student 187
Student 188
Student 189
Student 190
Student 191
Student 192
Student 193
Student 194
Student 195
Student 196
Student 197
Student 198
Student 199
Student 200
Spreadsheet: 832569d1686441330-help-with-xlookup-combined-with-index-match-and-table-references-rate-prob
Sheet: working

[NAME] | [NAME] | [NAME] | [NAME] | [NAME] to PersonnelTBL | [NAME] to PersonnelTBL | =XLOOKUP([@[Personnel [NAME] Name],INDEX(PersonnelTBL,MATCH([@Year],PersonnelTBL[#Headers],0),MATCH("Rate",PersonnelTBL[#Headers],0)))
Task | Partner | Year | Personnel Name | Labor Category | Project Role | Rate | % FTE | Hours | Cost | Column11
3a | Safal | BY | Fake Name1
3b(i) | Safal | BY | Fake Name2
3b(ii) | Safal | BY | Fake Name3
3b(iii) | Safal | BY | Fake Name4
3c | Safal | BY | Fake Name5
3c(i) | Safal | BY | Fake Name6
3c(ii) | Safal | BY | Fake Name7
3c(ii) | Safal | BY | Fake Name8
3d | Safal | BY | Fake Name9
3e | Safal | BY | Fake Name10
3f | Safal | BY | Fake Name11
3g(i) | Safal | BY | Fake Name12
3g(ii) | Safal | BY
3g(iii) | Safal | BY
Spreadsheet: b56e9f3e-b9c4-4782-9b33-293c969a5c64
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
G6PD | Test | G6PD | Glucose-6-Phosphate Dehydrogenase (G-6-PD), Quantitative, Erythrocytes | G-6-PD, QN, RBC | Kinetic Spectrophotometry (KS) | Yellow-Top (ACD) Tube: ACD |  |  | 4 | mL | Container/Tube: Preferred: Yellow top (ACD solution B) Acceptable: EDTA [NAME]: 6 mL Collection Instructions: Do not transfer blood to other containers. Forms: If not ordering electronically, submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | 8.8-13.4 U/g hemoglobin | Monday through Saturday | 1 day | 4 days | 1 | 82955 |  |  |  |  | Rochester
G6PD | [NAME] | ACDB | [NAME] ACD-B |  |  |  | Refrigerated | 20 days
G6PD | Result | G6PD_ | G-6-PD, QN, RBC | G-6-PD, QN, RBC | Numeric |  |  |  |  | U/g Hb |  |  |  |  |  |  |  |  |  | 32546-4 | Glucose-6-Phosphate dehydrogenase:CCnt:Pt:RBC:Qn:
Spreadsheet: 73920d1274453510-excel-2007-autofilter-with-dropdowns-filter_pulldown
Sheet: Sheet1

frame | category | group | opt1 | opt2 | opt3 | opt4
123 | aa | aaaaaa | 1000 | 1010 | 1020 | 1030
123 | aa | bbbbbb | 1000 | 1010 | 1020 | 1040
123 | aa | cccccc | 2000 | 1010 | 1040 | 1030
123 | bb | dddddd | 3000 | 3010 | 3020 | 3030
456 | aa | eeeeee | 1000 | 1010 | 1020 | 1030
789 | aa | [NAME] | 1000 | 1010 | 1020 | 1030
Spreadsheet: 319d7dda-6b25-4d7a-b0b9-2b5276014e59
Sheet: Sheet1

2012 W-2 Balancing Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Employee Name: |  | Employee ID:
Assignment 1 | Year to Date Gross Pay: | 0 |  | Self Service [NAME]:
Assignment 2 | Year to Date Gross Pay: | 0
Assignment 3 | Year to Date Gross Pay: | 0
Assignment 4 | Year to Date Gross Pay: | 0
 | Severance Pay: | 0
 | [NAME] Assist: | 0
 |  |  |  | County Gross: | 0
 | Total | 0 |  | Minus:
 |  |  |  | Excess Insurance | 0
 | Minus Refunds: |  |  | Meals | 0
 |  | 0 |  | [NAME] Assist | 0
 |  | 0 |  | Ex Sev up to $25,000.00 | 0
 |  | 0 |  | TRS, 403(b) and 457(b) | 0
 |  | 0 |  | County Taxable: | 0
 |  | 0
 | Minus Other: |  |  | Box 1 Federal | 0
 | Trainee | 0 |  | [NAME] | 0
 | Foreign Sourced Income | 0 |  | Box 5 Medicare | 0
 | Independent Contractor | 0 |  | Box 12 C Excess | 0
 |  |  |  | Box 12 E 403(b) | 0
 | Adjusted Gross Pay: | 0 |  | Box 12 G 457(b) | 0
 |  |  |  | Box 14 Meals | 0
 | Minus: |  |  | Box 14 Ex Sev | 0
 | Ex Sev up to $25,000.00 | 0 |  | Box 16 State | 0
 | [NAME] Assist | 0 |  | [NAME] | 0
 | Meals | 0 |  | [NAME] | 0
 | Healthcare | 0
 | Dental | 0
 | Vision | 0
 | Health Flex | 0
 | Dependent Flex | 0
 | Misc Benefit Plan | 0
 | City Taxable: | 0
 | Minus:
 | Parking | 0
 | Add:
 | Ex Sev up to $25,000.00 | 0
 | [NAME] Assist | 0
 | FICA Taxable: | 0 | SS Cap is $110,100.00
 | Minus:
 | *403(b) Matched | 0
 | *403(b) Unmatched | 0
 | *RSA-1 457(b) | 0
 | Ex Sev up to $25,000.00 | 0
 | State Taxable: | 0
 | Minus:
 | *TRS 401(a) 7.25 Pct | 0
 | *TRS 401(a) 8.25 Pct | 0
 | *TRS 401(a) Flat | 0
 | Minus:
 | 1042 S Income | 0
 | Add:
 | Meals | 0
 | Ex Sev up to $25,000.00 | 0
 | Federal Taxable: | 0