tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 717541d1612726158-vlookup-filter-by-date-input-book1
Sheet: RawData

Description | Key 1 | Key 2 | A | B | C | date
B1 | A1 |  | 268 | 210 | 290 | 29/01/2021
B2 | A2 | C2 | 200 | 678 | 290 | 29/01/2021
B3 | A3 | [NAME] | 220 | 220 |  | 29/01/2021
B4 | A4 |  | 301 | 431 |  | 29/01/2021
B5 | A5 |  | 309 | 230 | 369 | 29/01/2021
B6 | A6 |  | 215 | 340 |  | 29/01/2021
B7 | A7 |  |  |  | 431 | 29/01/2021
B8 | A8 |  | 329 | 431 |  | 29/01/2021
B9 | A9 |  |  | 134 |  | 29/01/2021
B10 | A10 |  | 431 |  |  | 29/01/2021
B11 | A11 |  | 499 | 310 | 459 | 29/01/2021
B12 | A12 |  | 678 |  |  | 29/01/2021
B13 | A13 |  | 220 | 200 | 200 | 29/01/2021
B14 | A14 |  | 431 | 255 | 678 | 29/01/2021
B15 | A15 |  | 230 | 233 | 220 | 29/01/2021
B16 | A16 |  |  | 200 | 431 | 29/01/2021
B17 | A17 |  | 499 |  | 230 | 29/01/2021
B18 | A18 |  | 510 | 200 |  | 29/01/2021
B1 | A1 |  |  | 201 | 215 | 2021-02-02 00:00:00
B2 | A2 |  | 229 |  |  | 2021-02-02 00:00:00
B3 | A3 |  |  | 209 | 329 | 2021-02-02 00:00:00
B4 | A4 |  |  | 200 |  | 2021-02-02 00:00:00
B5 | A5 |  |  |  | 431 | 2021-02-02 00:00:00
B6 | A6 |  | 268 | 499 | 499 | 2021-02-02 00:00:00
B7 | A7 |  |  | 510 | 200 | 2021-02-02 00:00:00
B8 | A8 |  | 200 |  |  | 2021-02-02 00:00:00
B9 | A9 |  | 200 | 678 | 268 | 2021-02-02 00:00:00
B10 | A10 |  |  | 220 | 268 | 2021-02-02 00:00:00
B11 | A11 |  | 215 | 431 |  | 2021-02-02 00:00:00
B12 | A12 |  |  | 230 | 200 | 2021-02-02 00:00:00
B13 | A13 |  | 329 |  |  | 2021-02-02 00:00:00
B14 | A14 |  | 469 | 215 | 215 | 2021-02-02 00:00:00
B15 | A15 |  |  |  |  | 2021-02-02 00:00:00
B16 | A16 |  |  | 329 | 329 | 2021-02-02 00:00:00
B17 | A17 |  | 349 |  |  | 2021-02-02 00:00:00
B18 | A18 |  | 369 | 431 | 200 | 2021-02-02 00:00:00
Spreadsheet: d2dac520-c083-4558-8019-3f5697c19450
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
FBCX | Test | FBCX | [NAME] (1-6) Antibodies, (CSF) | [NAME] (1-6) Ab, CSF | Complement Fixation (CF) | [NAME], leak proof vial: ScwLkPf |  |  | 2 | mL | Submit 2 mL spinal fluid. Ship refrigerate. | 0.5 mL | Specimens other than	CSF Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range:  < 1:1                  Interpretive Criteria:            < 1:1 Antibody Not Detected           > or = 1:1 Antibody Detected             Diagnosis of infections of the central nervous system is accomplished by demonstrating the presence of intrathecally-produced specific antibody. Interpretation of results may be complicated by low antibody levels found in CSF, passive transfer of antibody from blood, and contamination via bloody taps. The interpretation of CSF results must consider CSF-serum antibody ratios to the infectious agent.        Test Performed By:  Focus Diagnostics, Inc.                                             5785 Corporate Avenue                                             Cypress, CA 90630-4750 | Monday through Friday | 2-5 days | 4-7 days | 6 | 86658 |  |  |  |  | Focus Diagnositics, Inc.
FBCX | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
FBCX | Result | Z0366 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBCX | Result | Z0367 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBCX | Result | Z0368 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBCX | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBCX | Result | Z0370 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBCX | Result | Z0371 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 3 - Table 2

Consolidated income statement |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Net revenue | 17777.966 | -170.883 | -479.647824020162 | 1620.842824020162 | 18748.278 | 0.05457947213983871 | 0.09205629484566878
Cost of goods sold (COGS) | -5996.626 | 33.81599999999999 | 193.8855356992177 | -487.0285356992181 | -6255.953 | 0.04324548504442327 | 0.08266088917864638
Gross profit | 11781.34 | -137.067 | -285.7622883209443 | 1133.814288320944 | 12492.325 | 0.06034839839950279 | 0.09678149572055376
Selling, general and administrative (SG&A) | -5304.347000000002 | 54.099 | 137.1808595056457 | -266.2348595056447 | -5379.302000000001 | 0.0141308628564456 | 0.05093249735626551
Other operating income | 371.731 | -2.011 | 3.991739432017175 | 90.20326056798282 | 463.915 | 0.2479857746596328 | 0.2439772275451229
Normalized operating income   (normalized EBIT) | 6848.723999999998 | -84.979 | -144.5896893832814 | 957.7826893832824 | 7576.937999999996 | 0.1063284197173078 | 0.1396651518332998
Special items above EBIT | -84.297 | 0 | 0.8769746055796332 | 120.0160253944204 | 36.596 | nm | nm
Net finance results | -244.013 |  |  |  | -377.1849999999999 | 0.5457578079856398
Share of results of associates | 0.027 |  |  |  | 0.228 | nm
Income tax expense | -1513.984 |  |  |  | -1581.003 | 0.04426665010990871
Profit | 5006.456999999999 |  |  |  | 5655.574000000001 | 0.1296559622902986
Attributable to Ambev holders | 4975.598999999999 |  |  |  | 5608.504000000002 | 0.1272017700783368
Attributable to non-controlling interests | 30.858 |  |  |  | 47.06999999999999 | nm
Normalized profit | 5090.753999999999 |  |  |  | 5618.978000000001 | 0.1037614467326455
Attributable to Ambev holders | 5059.895999999999 |  |  |  | 5571.908000000001 | 0.1011902220915217
Normalized EBITDA | 7885.029 | -0.2669999999999959 | -176.3786929308075 | 926.5576929308078 | 8634.941 | 0.09510580113275435 | 0.1175124490670496
Spreadsheet: 144360d1330953333-problem-sorting-pivot-table-which-is-referencing-data-from-two-different-worksheets-book2
Sheet: Sheet3

Id | Value1 | Value2 | Value3 | Value4 |  |  |  |  | Values
009 |  |  |  |  |  |  |  | Row Labels | Sum of Value1 | Sum of Value2 | Sum of Value3 | Sum of Value4
012 |  |  |  |  |  |  |  | 006 | 2 | 21 | 12 | 7
006 |  |  |  |  |  |  |  | 009 | 3 | 4 | 23 | 2
 |  |  |  |  |  |  |  | 012 | 11 | 8 | 3 | 14
 |  |  |  |  |  |  |  | Grand Total | 16 | 33 | 38 | 23
Spreadsheet: 95701d1295293544-power-pivot-sample
Sheet: Summary

Rank | Record | Company | Commission | Premium
1 | SPRIN33 | Springfield | 10000 | 20000
2 | DYDU11 | Dye Tee Shirt Shop | 1000 | 212341
10 | FOURS71 | Four Ways, Inc | 55000 | 123040
Spreadsheet: 108050d1305149862-auto-populating-excel-calendar-ts1019273743
Sheet: NOV

 | November 2011
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
 | 6 | Daylight Savings Ends | 7 |  | 8 |  | 9 |  | 10 |  | 11 | Veterans Day | 12
 | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19
 | 20 |  | 21 |  | 22 |  | 23 |  | 24 | Thanksgiving | 25 |  | 26
 | 27 |  | 28 |  | 29 |  | 30
Spreadsheet: e18f3546-1308-46cc-8dc1-edd48a450fa9
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
44500790 | 2014-12-18 22:35:06 | ALLIES | 1 | 6 | 4 | 1508834 | foch | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 672757d1586987227-payroll-project-for-ytd-payrolefinal
Sheet: Kenya Time Sheet

WAGE | OT RATE | BONUS | SOC SEC | MEDICARE | FEDERAL | STATE | HEALTH | DENTAL | VISION | 401K |  |  | VAC TIME EARNED | VAC TIME LEFT | SICK TIME EARNED | SICK TIME LEFT
20 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-10-17 00:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2019-11-04 00:00:00 | 10:00:00 | 12:30:00 | 13:30:00 | 20:00:00
2019-11-05 00:00:00 | 09:00:00 | 12:30:00 | 13:30:00 | 20:00:00
2019-11-06 00:00:00 | 09:00:00 | 12:30:00 | 13:30:00 | 19:00:00
2019-11-07 00:00:00 | 09:00:00 | 12:30:00 | 13:30:00 | 18:00:00
2019-11-08 00:00:00 | 09:00:00 | 12:30:00 | 13:30:00 | 18:00:00
2019-11-09 00:00:00
2019-11-10 00:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2019-11-11 00:00:00 | 09:00:00 | 12:00:00 | 13:00:00 | 18:00:00
2019-11-12 00:00:00 | 09:30:00 | 13:00:00 | 13:30:00 | 18:00:00
2019-11-13 00:00:00
2019-11-14 00:00:00
2019-11-15 00:00:00
2019-11-16 00:00:00
2019-11-17 00:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2019-11-18 00:00:00
2019-11-19 00:00:00
2019-11-20 00:00:00
2019-11-21 00:00:00
2019-11-22 00:00:00
2019-11-23 00:00:00
2019-11-24 00:00:00
Spreadsheet: 739335d1625652313-index-and-match-3-criteria-for-result-sample-data
Sheet: sUMMARY

 | P3
 | APAC |  |  |  |  |  |  |  |  |  |  | P1 | US
Sunday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
Monday |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Tuesday |  |  |  |  |  |  |  |  |  |  |  | P2 | US
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
Thursday |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Friday |  |  |  |  |  |  |  |  |  |  |  | P3 | US
Saturday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
 |  |  |  |  |  |  |  |  |  |  |  | P4 | US
 |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
 |  |  |  |  |  |  |  |  |  |  |  | P5 | US
 |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
Sheet: 9a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 7539367 | 15925641 | 23465008
 | FRA | 34475850 | 23886446 | 58362296
 | Exotic |  | 3519121 | 3519121
 | Inflation |  | 2536519 | 2536519
 | IRS- [NAME] | 112958545 | 99678646 | 212637190
 | OIS | 20418240 | 18543289 | 38961529
 | VNS | <10,000 |  | <10,000
 | Zero Coupon | 220444 |  | 220444
With Optionality | Callable Swap |  | 828411 | 828411
 | Cap/Floor |  | 10375883 | 10375883
 | Debt Option |  | 657492 | 657492
 | Exotic Option |  | 1366594 | 1366594
 | Swaption |  | 28524278 | 28524278
Cross-Currency | Exotic |  | 133357 | 133357
 | Swap |  | 18203435 | 18203435
TOTAL |  | 175612446 | 224179111 | 399791557
Estimated gross notional amount outstanding, November 23 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 94992d1294719683-extracting-info-to-another-worksheet-fault-issues-2-
Sheet: Removed Faults

 | QUOTE NUMBER | DATE REPORTED | TIME REPORTED | FAULT TYPE | FAULT DETAILS | PRIORITY | STATUS | DATE RESOLVED | TIME RESOLVED | RELEVANT FILES | CONTACT
 | 0 | 2010-12-28 00:00:00 | 17:25:00 | Hardware |  | HIGH | Closed | 2011-01-11 00:00:00 | 12:08:38 |  |  |  |  |  |  |  |  | 2011-01-11 12:08:57
 | 0 | 2010-10-14 00:00:00 | N/A | Hardware |  | HIGH |  |  |  |  |  |  |  |  |  |  |  | 2011-01-11 12:06:36 |  |  |  | ..\VI system developments
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-11 12:05:58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\EM80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\FMECA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\VI system developments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\Video Imaging System
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..\Work Files
Spreadsheet: 772501d1647333215-higher-values-in-col-a-than-col-b-sum-rows-with-the-higher-value-and-show-difference-cols-a-b-higher-difference-1-
Sheet: Sheet1

2 | 3 |  |  |  | 2 | 3
2 | 1 |  |  |  | 2 | 1
2 | 3 |  |  |  | 2 | 3
2 | 1 |  |  |  | 2 | 1
2 | 2 |  |  |  | 2 | 2
2 | 3 |  |  |  | 2 | 3
4 | 2 |  |  |  | 4 | 2
4 | 3 |  |  |  | 4 | 3
4 | 5 |  |  |  | 4 | 5
2 | 1 |  |  |  | 2 | 1
Column A total | Column B Total | Total of the highest value from A + B for each row |  |  |  | Difference between Columns A + B where Column A is higher value
Spreadsheet: 36470d1234358493-moving-rows-to-anoter-worksheet-based-on-certain-criteria-anz-maximizer-monthly-kpi
Sheet: Louise

Opportunity Leader | Address Book Entry | Close Date | Number of Analyzers required | Total Capital | Annual Number of Cartridges | Annual Cartridge Revenue | Status | Confidence Rating | Revenue
want all rows from data drop sheet with name = [NAME] to appear here
 |  |  |  |  |  |  |  |  | 1000000
d
f
f
4 |  |  | 0 | 0 |  | 0 |  | 0 | 1000000
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 9d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 1791332 | 282849 | 2044049 | 184312
OTHER* | 796430 | 775622 | 68742 | 408565
TOTAL | 2587762 | 1058471 | 2112791 | 592877
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, FRA, Fixed-Fixed, Inflation, OIS, and Swaption.
Spreadsheet: 142348d1329782529-need-to-identify-if-values-are-formatted-as-tax-ein-ssn-or-not-copy-idendtify-tid
Sheet: Sheet1

Vendor | Tax Number | Type Of Business | SSN/EIN/Needs Corrected
3000000 | 12-3456789 | Corporation | EIN
3000001 | 23-4567891 | Partnership | EIN
3000002 | 345-67-8912 | Individual | SSN
3000003 | bunk |  | [NAME]
3000004 | 456-78-9123 | Bunk | SSN
Spreadsheet: 33948d1230911426-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-later-version-of-excel-revised
Sheet: Distributions

Name of Former Participant | Reason For Distribution | Married Yes/No | Amount Distributed | Annuity/ [NAME] | Spousal Consent secured
 | Termination | Yes | 0 | [NAME] | NA
 | Termination | No | 0 | [NAME] | NA
 | Termination | No | 0 | [NAME] | NA
Total
Participant | Age | Employment Term Date | Payment date | Payment Timely | Form 1099-R
 |  |  |  |  | Yes – Code “G”
 |  |  |  |  | Yes – Code “1”
 |  |  |  |  | Yes – Code “1”
LOANS
Participant | Participant Account Balance | 50% of Participant Account Balance | Loan Amount | Percent/Years | Loan Balance | Consent Secured
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
Spreadsheet: 142808d1330016129-excel-2007-combining-two-countif-statements-counting-dates
Sheet: Sheet1

Data | Name | Date |  |  | Name | Claims | Count of Dates
1 | [NAME] | 2012-01-01 00:00:00 |  |  | [NAME]
1 | [NAME] | 2012-01-01 00:00:00 |  |  | [NAME]
1 | [NAME] | 2012-01-01 00:00:00 |  |  | [NAME]
2 | [NAME] | 2012-01-01 00:00:00
2 | [NAME] | 2012-01-01 00:00:00
2 | [NAME] | 2012-01-01 00:00:00
3 | [NAME] | 2012-01-01 00:00:00
3 | [NAME] | 2012-01-01 00:00:00
3 | [NAME] | 2012-01-01 00:00:00
4 | [NAME] | 2012-01-01 00:00:00
4 | [NAME] | 2012-01-01 00:00:00
4 | [NAME] | 2012-01-01 00:00:00
1 | [NAME] | 2012-01-01 00:00:00
1 | [NAME] | 2012-01-02 00:00:00
1 | [NAME] | 2012-01-02 00:00:00
2 | [NAME] | 2012-01-02 00:00:00
2 | [NAME] | 2012-01-02 00:00:00
2 | [NAME] | 2012-01-02 00:00:00
3 | [NAME] | 2012-01-02 00:00:00
3 | [NAME] | 2012-01-02 00:00:00
3 | [NAME] | 2012-01-02 00:00:00
4 | [NAME] | 2012-01-02 00:00:00
4 | [NAME] | 2012-01-02 00:00:00
4 | [NAME] | 2012-01-02 00:00:00
Spreadsheet: 888746d1739312641-vlookup-is-returning-garbage-from-no-telling-where-test2-1-
Sheet: 2004 frequency

Frequency | Number | Name | current
159 | 282 | I'm Going Home
156 | 146 | Hallelujah
146 | 155 | Northfield
142 | 300 | Calvary
138 | 45t | New Britain
138 | 480 | Redemption
136 | 384 | Panting For Heaven
129 | 59 | [NAME]
128 | 99 | [NAME]
128 | 276 | Bridgewater
125 | 63 | Coronation
124 | 475 | A thankful Heart
123 | 171 | Exhortation (first)
123 | 335 | Return Again
122 | 142 | Stratfield
122 | 270 | Confidence
121 | 40 | Lenox
121 | 47b | Idumea
117 | 318 | Present Joys
115 | 143 | Pleyel's Hymn (first)
112 | 503 | Lloyd
110 | 32t | Corinth
110 | 358 | Murillo's [NAME]
108 | 454 | The Better Land
107 | 68b | Ortonville
107 | 178 | Africa
106 | 569b | [NAME]
104 | 36b | Ninety-Fifth
102 | 84 | Amsterdam
102 | 112 | The Last Words Of Copernicus
101 | 34b | St. Thomas
100 | 217 | Ballstown
99 | 299 | New Jerusalem
97 | 159 | Wondrous Love
96 | 101t | Canaan's Land
95 | 31t | Ninety-Third Psalm
93 | 274t | The Golden Harp
90 | 168 | Cowper
90 | 192 | Schenectady
Spreadsheet: 0bbff19d-7640-4484-88cf-f2c9b8ac6ff2
Sheet: 1 YEAR

Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff
 | MUID |  |  |  | ACCT
Prepared by
Last Modified on
PI |  |  |  |  | DEPT
Project Title
Sponsor
 | Budget Period
 | BUDGET ITEM | Name or Comment |  |  |  | GRANT | Cost Share | TOTAL
A. | PERSONNEL
6000 | PI Acad. Year
6000 | Co-I Acad Year
6000 | Co-I Acad Year
6000 | Other Professional
6000 | Total Professional
6007 | PI Summer
6007 | Co-I Summer
6007 | Co-I Summer
6007 | Total Sumr Salaries
6008 | Post Doc/Fellow Full-Time
6012 | Clinical/Lab Staff Full-Time
6013 | Clinical/Lab Staff Part-Time
6020 | Full-Time Hourly Staff
6035 | Part-Time Hourly Staff
6050 | Undergraduate Students
6024 | GRA-Academic Year | #: |  | Biweekly $: |  |  | 0
6024 | GRA-Summer | #: |  | Biweekly $: |  |  | 0
6024 | Total GRA
6195 | Fringe FT |  |  |  | 0.285
6195 | [NAME] |  |  |  | 0.16
6195 | Fringe PT & Summer Students |  |  |  | 0.08
6195 | Total Fringes
 | TOTAL PERSONNEL
B. | NONPERSONNEL
6200 | Office Expenses
6235 | Lab Supplies
6247 | Equipment > $5000
6265 | Computer Software
6505 | Consulting Fees
6602 | Student Stipends
6900 | Domestic Travel
6900 | Domestic Travel
6900 | Total Domestic Travel
6930 | Foreign Travel
7010 | Publications
7225 | Tuition
 | TOTAL NONPERSONNEL
 | TOTAL DIRECT COSTS
 | MTDC BASE
7520 | F&A Costs |  |  |  | 0.51
 | TOTAL PROJ COSTS
Spreadsheet: 872695d1719056110-getting-data-from-one-workbook-to-another-croy79-ghm-team-v2-aligw
Sheet: Girls

 | Name | 100m | 200m | 800m | 1500m | Shot | Discus | Long | High |  | Name | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2012 |  | x |  | x |  | x | x |  |  |  | [NAME] | x | x | x |  | x | x | x | x
 | [NAME] | x | x | x |  | x | x | x | x |  | [NAME] | x | x | x |  |  |  | x | x
 | Matilda Dawson | x |  |  |  |  |  |  | x |  | Ella Spink | x |  | x |  | x | x
12 Years | [NAME] | x | x | x |  |  |  | x | x |  | Matilda Dawson | x |  |  |  |  |  |  | x
 | [NAME] |  |  |  |  | x | x |  |  |  | [NAME] |  |  |  |  | x | x
 | [NAME] |  |  |  |  |  |  | x |  |  | [NAME] |  |  |  |  |  |  | x
 |  | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2013
11 Years
 |  | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2014
10 Years
2015 |  | 100 | 200 | Long
9 Years
Spreadsheet: 156852d1337522759-highlight-a-different-cell-based-on-current-active-cell-book1_scamp53
Sheet: Sheet1

19 | 6 | 17 | 4 | 21 | 15 | 16 | 17 |  | 2 | 15 | 14 | 20 | 4 | 21 | # | [NAME] | guess
14 |  | 14 |  |  |  | 15 |  | 4 |  | 10 |  | 4 |  | 18 | 1 | 1 |  | e | 0.12702
25 | 3 | 25 | 13 | 6 | 16 | 16 | 25 | 21 |  | 8 | 16 | 25 | 9 | 25 | 2 | 1 |  | t | 0.09056
12 |  | 15 |  | 11 |  | 13 |  | 25 |  | 25 |  | 14 |  | 14 | 3 | 2 |  | a | 0.08167
18 | 11 | 7 | 11 | 4 | 21 |  | 25 | 23 | 23 | 16 | 11 | 18 | 7 | 13 | 4 | 8 |  | o | 0.07507
20 |  | 8 |  | 21 |  | 5 |  | 23 |  | 18 |  | 4 |  | 21 | 5 | 2 |  | i | 0.06966 |  | Cell G6 should be highlighted (filled) i.e. active cell column and row-15
13 | 24 | 15 | 19 |  | 1 | 25 | 7 | 15 | 20 | 20 | 25 | 14 | 3 |  | 6 | 6 |  | n | 0.06749
6 |  | 8 |  | 6 |  | 16 |  | 7 |  |  |  | 6 |  | 25 | 7 | 13 |  | s | 0.06327
7 | 18 | 18 | 17 | 23 | 11 | 16 |  | 4 | 21 | 15 | 7 | 24 | 25 | 19 | 8 | 4 |  | h | 0.06094
18 |  |  |  | 23 |  | 18 |  | 21 |  | 7 |  |  |  | 6 | 9 | 2 |  | r | 0.05987
 | 12 | 25 | 10 | 8 | 15 | 14 | 18 |  | 5 | 18 | 7 | 15 | 19 | 7 | 10 | 2 |  | d | 0.04253
22 |  | 24 |  | 14 |  | 15 |  | 25 |  | 26 |  | 7 |  | 15 | 11 | 8 |  | l | 0.04025
11 | 7 | 23 | 18 | 15 | 19 | 7 | 18 | 17 |  | 25 | 15 | 17 | 18 | 20 | 12 | 2 |  | c | 0.02782
25 |  | 11 |  | 7 |  | 25 |  | 9 |  | 4 |  | 15 |  | 18 | 13 | 6 |  | u | 0.02758
17 | 15 | 16 | 11 | 13 | 18 |  | 16 | 18 | 23 | 13 | 24 | 25 | 14 | 17 | 14 | 9 |  | m | 0.02406
g | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 15 |  | w | 0.0236
0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 16 | 9 |  | f | 0.02228
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 17 | 7 |  | g | 0.02015
0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 18 | 16 |  | y | 0.01974
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 5 | g | p | 0.01929
0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 20 | 5 |  | b | 0.01492 |  | Active Cell is G21
0 | 0 | 0 | g |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 21 | 8 |  | v | 0.00978
0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 | 22 | 1 |  | k | 0.00772
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | g | 23 | 7 |  | j | 0.00153
0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 | 24 | 4 |  | x | 0.0015
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | g | 0 | 25 | 18 |  | q | 0.00095
0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 26 | 1 |  | z | 0.00074
0 | 0 | 0 | 0 | 0 | g | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | $G$21
0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 888039d1738349719-excel-formula-help-ef1668_attendance-tracker
Sheet: Absences

Name | Leave_Type | Start_date | End_date |  | Days | 0 |  | Row | Date | Ref | Type
[NAME] | Ex | 2025-01-10 00:00:00 | 2025-01-12 00:00:00
[NAME] | UNEX | 2025-01-15 00:00:00 | 2025-01-17 00:00:00
[NAME] | Ex | 2025-01-08 00:00:00
[NAME] | UNEX | 2025-01-22 00:00:00 | 2025-01-25 00:00:00
[NAME] | NCNS | 2025-01-27 00:00:00 | 2025-01-29 00:00:00
[NAME] | UNEX | 2025-01-13 00:00:00 | 2025-01-14 00:00:00
Spreadsheet: 84767d1284804911-sum-with-counta-and-countif-with-many-matching-criteria-example
Sheet: Sheet1

 | Happy |  | Doc
Week 35 | 0.95 | 0.7 | 0.88 | 0.6 | Monday
 | 0.92 | 0.65 | 0.67 | 0.5 | Tuesday
 | 0.87 | 0.75 | 0.72 | 0.59 | Wednesday
 | 0.98 | 0.8 | 0.62 | 0.48 | Thursday
 | 0.99 | 0.82 | 0.8 | 0.78 | Friday
 | N/A | 0 | N/A | 0 | Saturday
 | N/A | 0 | N/A | 0 | Sunday
Week 36 | 0.85 | 0.71 | 0.8 | 0.72 | Monday
 | 0.87 | 0.65 | 0.85 | 0.75 | Tuesday
 | 0.95 | 0.8 | 0.89 | 0.78 | Wednesday
 | 0.93 | 0.82 | 0.9 | 0.79 | Thursday
 | 0.89 | 0.69 | 0.95 | 0.82 | Friday
 | N/A | 0 | 0.95 | 0.88 | Saturday
 | N/A | 0 | N/A | 0 | Sunday
 | Actual | Capacity | Actual | Capacity
 |  |  |  |  |  | Based on sum all percentages devided by sum(counta all cells within a week minus countif all N/A within a week) in Actual column
Actual | Week 35 | Week 36
Doc |  |  |  |  |  | based on sum all percentages within a week but Monday to Friday devided by 5 in capacity column
Happy
5 Days
Doc |  |  |  |  |  | Based on sum all percentages within a week but Monday to Sunday devided by 7 in capacity column
Happy
7 Days
Doc
Happy