tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: richard_shapiro__32386__Worksheet Shapiro 100072
Sheet: Salary

[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2002
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PLAN
 | KEY ONLY IN BLUE CELLS
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
 |  |  |  |  |  | MERIT/OTHER
 |  |  |  |  |  | applied at
 |  |  |  |  |  | 0.0425
 | Regular Salaries
 | Employee 1 | 0
 | Employee 2 | 0
 | Employee 3 | 0
 | Employee 4 | 0
 | Employee 5 | 0
 | Employee 6 | 0
 | Employee 7 | 0
 | Employee 8 | 0
 | Employee 9 | 0
 | Employee 10 | 0
 | Employee 11 | 0
 | Employee 12 | 0
 | Employee 13 | 0
 | Employee 14 | 0
 | Employee 15 | 0
 | Employee 16 | 0
 | Employee 17 | 0
 | Employee 18 | 0
 | Employee 19 | 0
 | Employee 20 | 0
 | Employee 21 | 0
 | Employee 22 | 0
 | Employee 23 | 0
 | Employee 24 | 0
 | Employee 25 | 0
 | Employee 26 | 0
 | Employee 27 | 0
 | Employee 28 | 0
 | Employee 29 | 0
 | Employee 30 | 0
 | Employee 31 | 0
 | Employee 32 | 0
 | Employee 33 | 0
 | Employee 34 | 0
 | Employee 35 | 0
 | Employee 36 | 0
 | Employee 37 | 0
 | Employee 38 | 0
 | Employee 39 | 0
 | Employee 40 | 0
 | Employee 41 | 0
 | Employee 42 | 0
 | Employee 43 | 0
 | Employee 44 | 0
 | Employee 45 | 0
 | Employee 46 | 0
 | Employee 47 | 0
 | Employee 48 | 0
 | Employee 49 | 0
 | Employee 50 | 0
 | TOTAL
 | Cumulative Salaries
 | Payroll Taxes (does not reflect mid-month percentage changes)
 | Overtime
 | TOTAL
Spreadsheet: 849026d1699590751-newbie-help-if-vlookup-not-sure-which-formula-to-use-formula-help-example-aligw
Sheet: Summary Sheet

FY24 Board Approved | FY Board Approved Date | FY24 Construction Start Date |  |  |  |  |  |  |  |  |  | FILTER |  |  |  |  | CHOOSECOLS
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Store 4 |  |  |  |  |  |  |  |  |  |  |  | Store 14 | 00:00:00 | 00:00:00 | 2024-03-01 00:00:00 |  | Store 14 | 00:00:00 | 2024-03-01 00:00:00
Store 9 |  |  |  |  |  |  |  |  |  |  |  | Store 20 | 00:00:00 | 2024-04-04 00:00:00 | 00:00:00 |  | Store 20 | 2024-04-04 00:00:00 | 00:00:00
UNDER CONSTRUCTION |  |  |  |  |  |  |  |  |  |  |  | Store 21 | 00:00:00 | 2024-05-05 00:00:00 | 00:00:00 |  | Store 21 | 2024-05-05 00:00:00 | 00:00:00
Store 14 |  | 2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | Store 22 | 00:00:00 | 2024-06-06 00:00:00 | 00:00:00 |  | Store 22 | 2024-06-06 00:00:00 | 00:00:00
BOARD APPROVED
Store 20 | 2024-04-04 00:00:00
Store 21 | 2024-05-05 00:00:00
Store 22 | 2024-06-06 00:00:00
The 'Examples' below is basically the Result that I'm looking for:
Examples
Store 1 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Store 4 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Store 10 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Spreadsheet: 886575d1736612878-count-if-function-should-be-count-value-of-charactor-as-a-half-salary-nirman22
Sheet: After

SN |  | 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 | Full  Day | Half  Day | W/O | Leave | Total
1 | Deepak Gote | p | p | p | p | w | p | h | w | p | p | p | w | p | p | w | p | p | p | w | p | p | w | p | p | p | w | p | p | p | p | p | 23.5 |  | 4
2 | Atul Shinde | p | l | p | p | w | p | p | w | p | p | h | w | p | p | w | h | p | p | w | p | p | w | p | p | p | w | p | p | p | p | p | 22 |  | 4
3 | [NAME] | p | l | p | p | w | h | p | w | p | p | p | w | p | p | w | p | p | h | w | p | h | w | p | p | p | w | p | p | p | p | p | 21.5 |  | 4
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
41
42
43
44
45
46
47
48
49
Spreadsheet: fbcd36e7-6577-41b6-9009-699cd1c62b04
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
 | Accepting property as an addition |  |  |  | To declare as Park Property and to remain such forever.
 | to Big Shoal Greenway.
Details |  |  |  |  | Positions/Recommendations
 |  |  |  |  | Sponsor |  |  |  | Parks & Recreation
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Parks & Recreation
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | Director, Parks & Recreation
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By |  | Bd. of Parks & Recreation Commissioners
 |  |  |  |  | Recommendation |  |  |  | Resolution #28824 on May 25, 2010.
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | 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
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME], ASLA |  | 2010-06-01 00:00:00
 | Interim Manager, Planning & Design, [NAME] and Recreation
Reviewed by:
 | [NAME]
 | Director, [NAME] and Recreation
Spreadsheet: 54505d1254487450-lookup-based-on-2-values-sample
Sheet: Sheet1

Item | Location | [NAME] in this column to  produce this result | Item | Location | Qty
01-00008 | AFMKT | 1 | 01-00019. | NCREW | 32
01-00008 | STORE | 2 | 01-00018. | STORE | 25
01-00011. | STORE | 6 | 01-00015. | STORE | 9
01-00012. | STORE | 0 | 01-00018. | CSSM | 7
01-00013. | STORE | 0 | 01-00011. | STORE | 6
01-00014. | STORE | 0 | 01-00008 | QA | 5
01-00015. | STORE | 9 | 01-00018. | CSBIR | 4
01-00016. | STORE | 3 | 01-00018. | GSTA | 4
01-00017. | STORE | 0 | 0050 910 000100. | ZERO | 4
01-00018. | CSAUS | 0 | 01-00008 | NCREW | 3
01-00018. | CSRFB | 2 | 01-00016. | STORE | 3
01-00018. | CSRPR | 2 | 01-00008 | STORE | 2
01-00018. | GSTA | 4 | 01-00018. | CSRFB | 2
01-00018. | LOAN | 0 | 01-00018. | CSRPR | 2
01-00018. | STORE | 25 | 01-00008 | AFMKT | 1
01-00019. | NCREW | 32 | 01-00018. | CSAUS | 1
01-00019. | STORE | 0 | 01-00019. | QA | 1
 |  |  | 01-00017. | STORE | 0
 |  |  | 01-00018. | LOAN | 0
 |  |  | 0050 910 000100. | NCREW | 0
 |  |  | 0050 910 000100. | QA | 0
 |  |  | 0050 910 000100. | STORE | 0
Spreadsheet: 709395d1608285168-display-n-a-instead-of-00-jan-00-sample
Sheet: 4th book view

User full name | Date | Time | Event name
[NAME] | 2020-09-23 00:00:00 | 09:24 | Course module viewed
[NAME] | 2020-10-15 00:00:00 | 10:58 | Course module viewed
[NAME] Meersseman | 2020-10-22 00:00:00 | 10:53 | Course module viewed
[NAME] | 2020-10-23 00:00:00 | 20:10 | Course module viewed
Akash Shah | 2020-10-30 00:00:00 | 10:00 | Course module viewed
[NAME] | 2020-11-02 00:00:00 | 14:18 | Course module viewed
[NAME] | 2020-11-02 00:00:00 | 15:45 | Course module viewed
Quinten Croes | 2020-11-07 00:00:00 | 12:02 | Course module viewed
[NAME] | 2020-11-09 00:00:00 | 11:16 | Course module viewed
Anke Bellens | 2020-11-09 00:00:00 | 17:14 | Course module viewed
Filipe Torrado | 2020-11-10 00:00:00 | 22:25 | Course module viewed
[NAME] | 2020-11-12 00:00:00 | 13:48 | Course module viewed
[NAME] | 2020-11-16 00:00:00 | 17:48 | Course module viewed
[NAME] | 2020-11-27 00:00:00 | 12:23 | Course module viewed
[NAME] | 2020-11-27 00:00:00 | 21:27 | Course module viewed
[NAME] | 2020-11-30 00:00:00 | 09:03 | Course module viewed
[NAME] | 2020-11-30 00:00:00 | 20:10 | Course module viewed
[NAME] | 2020-12-02 00:00:00 | 00:09 | Course module viewed
Sofia Bankovova | 2020-12-02 00:00:00 | 14:17 | Course module viewed
[NAME] | 2020-12-05 00:00:00 | 12:13 | Course module viewed
Marek Estok | 2020-12-06 00:00:00 | 21:51 | Course module viewed
[NAME] | 2020-12-14 00:00:00 | 15:17 | Course module viewed
[NAME] | 2020-12-17 00:00:00 | 04:41 | Course module viewed
Spreadsheet: e6887bce-fb34-4e2d-bb59-61a35604b138
Sheet: Sheet1

Women Ages 18 and [NAME], Who Have Had a Pap Smear Within the Past Three Years,  by Selected Demographics, Maine, 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Unweighted Number | Weighted Number | % | LCL | UCL
Maine Total |  | 2914 | 354235.2233433299 | 85.01403426930368 | 83.39867495561472 | 86.62939358299262
Nationwide (States and DC) |  |  |  | 85
County
 | Androscoggin | 170 | 24938.28268199191 | 85.05298872926585 | 76.07333361235294 | 94.03264384617877
 | Aroostook | 160 | 21588.38451233537 | 89.37986860319084 | 85.0101499737616 | 93.7495872326201
 | Cumberland | 523 | 72473.75367084623 | 86.66262940506093 | 83.56029956951133 | 89.76495924061051
 | Franklin | 100 | 7868.726455772879 | 77.90629388701059 | 68.45039447459466 | 87.36219329942652
 | Hancock | 142 | 18982.27276818359 | 85.98427244840775 | 80.4572421461157 | 91.5113027506998
 | Kennebec | 244 | 30424.17788169724 | 85.73791328911315 | 80.30241712437814 | 91.17340945384817
 | Knox | 172 | 11934.88891876038 | 86.43825121523552 | 79.45322710815668 | 93.42327532231438
 | Lincoln | 130 | 9604.967547329828 | 85.9069768969637 | 78.8952106637453 | 92.9187431301821
 | Oxford | 105 | 13975.87028510254 | 86.04788817660317 | 78.84576112113683 | 93.2500152320695
 | [NAME] | 244 | 35304.95126949429 | 81.90283649550865 | 76.08796992940083 | 87.71770306161649
 | Piscataquis | 64 | 6360.590258380993 | 86.16968393327103 | 79.34456780749953 | 92.99480005904253
 | Sagadahoc | 101 | 9688.080233509658 | 88.71626220203655 | 81.48456826658501 | 95.94795613748808
 | Somerset | 101 | 13052.2509823211 | 83.77529589487894 | 77.24045585186828 | 90.31013593788961
 | [NAME] | 134 | 10788.98659084836 | 81.38303116469493 | 73.80726618041479 | 88.95879614897507
 | Washington | 113 | 8856.777779556021 | 79.89842897098171 | 71.45103691859288 | 88.34582102337055
 | York | 345 | 49734.075218443 | 85.70922188628299 | 80.67756278864839 | 90.7408809839176
District
 | Aroostook | 160 | 21588.38451233537 | 89.37986860319084 | 85.0101499737616 | 93.7495872326201
 | Central | 345 | 43476.42886401834 | 85.13911526565909 | 80.87697180182835 | 89.40125872948983
 | Cumberland | 523 | 72473.75367084623 | 86.66262940506093 | 83.56029956951133 | 89.76495924061051
 | Downeast | 255 | 27839.05054773961 | 83.94992933970772 | 79.25892660365251 | 88.64093207576295
 | [NAME] | 537 | 42016.92329044816 | 85.46031333431027 | 81.82938455693228 | 89.09124211168825
 | Penquis | 308 | 41665.54152787529 | 82.52666801623917 | 77.4466976033576 | 87.60663842912074
 | Western | 375 | 46782.87942286733 | 84.04650053488805 | 78.60139921278493 | 89.49160185699117
 | York | 345 | 49734.075218443 | 85.70922188628299 | 80.67756278864839 | 90.7408809839176
Data Source: Behavioral Risk Factor Surveillance System
Only includes women with an Intact cervix
% = Weighted percentage of respondents
LCL = Lower 95% confidence level of the weighted percentage; UCL = Upper 95% confidence level of the weighted percentage
All percentages are weighted to be more representative of the population of Maine and to adjust for non-response.
Spreadsheet: 111405d1307758469-add-subtract-from-time-values-time-edit-example
Sheet: Sheet1

6:45PM | 8:15PM | <<<add 5 minutes to A and B
4:30PM | 6:00PM | <<<subtract 10 minutes to A and B
2:45PM | 4:15PM | <<<add 7 minutes to A and B
8:30PM | 10:00PM | etc..  Using different minute values
12:30PM | 2:00PM | etc..  Using different minute values
[NAME] | [NAME] | etc..  Using different minute values
8:30AM | 11:16AM | etc..  Using different minute values
6:30PM | 9:15PM | etc..  Using different minute values
7:00AM | 9:46AM | etc..  Using different minute values
4:30PM | 6:00PM | etc..  Using different minute values
[NAME] | 10:30AM | etc..  Using different minute values
12:00N | 2:31PM | etc..  Using different minute values
3:15PM | [NAME] | etc..  Using different minute values
1:00PM | 2:50PM | etc..  Using different minute values
3:30PM | 5:15PM | etc..  Using different minute values
7:00AM | 8:50AM | etc..  Using different minute values
12:45PM | 2:30PM | etc..  Using different minute values
9:30AM | 11:15AM | etc..  Using different minute values
3:15PM | 5:00PM | etc..  Using different minute values
5:00PM | 6:50PM | etc..  Using different minute values
7:30PM | 9:15PM | etc..  Using different minute values
5:15PM | 7:03PM | etc..  Using different minute values
8:00PM | 9:48PM | etc..  Using different minute values
8:30PM | 10:00PM | etc..  Using different minute values
2:30PM | 4:00PM | etc..  Using different minute values
1:15PM | 2:45PM | etc..  Using different minute values
7:00AM | 8:30AM | etc..  Using different minute values
[NAME] | 9:30AM | etc..  Using different minute values
5:45PM | 7:15PM | etc..  Using different minute values
10:15AM | 11:45AM | etc..  Using different minute values
8:00PM | 9:30PM | etc..  Using different minute values
1:00PM | 2:30PM | etc..  Using different minute values
3:15PM | 4:45PM | etc..  Using different minute values
7:00AM | 9:09AM | etc..  Using different minute values
10:00AM | 12:06PM | etc..  Using different minute values
7:30AM | 9:30AM | etc..  Using different minute values
10:15AM | 12:15PM | etc..  Using different minute values
5:45PM | [NAME] | etc..  Using different minute values
8:30PM | 10:30PM | etc..  Using different minute values
6:30PM | 7:15PM | etc..  Using different minute values
12:30PM | 1:15PM | etc..  Using different minute values
12:00N | 1:45PM | etc..  Using different minute values
1:00PM | 2:45PM | etc..  Using different minute values
6:00PM | [NAME] | etc..  Using different minute values
10:45AM | 1:30PM | etc..  Using different minute values
7:30AM | 10:00AM | etc..  Using different minute values
2:15PM | 3:45PM | etc..  Using different minute values
2:15PM | 4:49PM | etc..  Using different minute values
Spreadsheet: 881558d1729666513-is-there-any-other-formula-besides-vlookup-and-spill-source-excel
Sheet: Report

 |  |  |  |  |  |  | TOB Sep 2024 Payroll Report
 |  | 2024-09-22 14:47:18 |  |  |  |  | Period |  | 2024-09-19 00:03:21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOURCE
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Emp. ID. No. | 0 | 0 | 0 | [NAME] | Basic Salary | Housing Allowance | Other Earnings | Deduction
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2340210505 | 0 | 0 | 0 | 7000 | 5000 | 1500 | 500 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2060952872 | 0 | 0 | 0 | 14000 | 10370 | 2593 | 1037 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2210022188 | 0 | 0 | 0 | 8700 | 6400 | 1600 | 700 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2068045588 | 0 | 0 | 0 | 6800 | 5115 | 1204 | 481 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2161713041 | 0 | 0 | 0 | 6900 | 4670 | 1093 | 1185 | 48
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2390118335 | 0 | 0 | 0 | 8478 | 5704 | 1426 | 1348 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total =
Spreadsheet: 28522d1222815382-excel-2007-incorrect-sumproduct-with-random-numbers-oddbehaviour
Sheet: Sheet1

 | 1
 | 3
 | 6
Spreadsheet: 853993d1703949070-chatgpt-says-this-cant-be-done-without-vba-track-menstruation_2
Sheet: Sheet1

[NAME] | Menstruation Start | Menstruation End | Fertile Start | Ovulating | Fertile End | Menstruation Period | Fertility Period
 |  |  |  |  |  |  |  |  | Your most recent cycle start date |  | 2023-12-08 00:00:00
 |  |  |  |  |  |  |  |  | Your typical cycle length in days |  | 31
 |  |  |  |  |  |  |  |  | Days from period start until ovulation begins |  | 14
 |  |  |  |  |  |  |  |  | Typical menstruation days |  | 4
Spreadsheet: 1d552dd9-dcae-4840-a8a7-5b359f59f5b2
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | 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
 | Area |  | Yield | Supply |  |  |  |  | Disappearance
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
August 1 |  |  |  | stocks | Production | Imports | Total |  | food | Crush | residual | Exports | Total | stocks
 | 1,000 acres |  | Pounds/acre | Million pounds
2011/12 | 1140.6 | 1080.6 | 3385.702387562465 | 1515.939 | 3658.59 | 253.8966184896708 | 5428.425618489671 |  | 2805 | 603.601 | 470.3079841901033 | 546.1856342995678 | 4425.094618489671 | 1003.331
2012/131 | 1638 | 1604 | 4216.521197007482 | 1003.331 | 6763.3 | 118.743 | 7885.374 |  | 2734.836 | 655.96265 | 528.4915199182553 | 1195.334830081745 | 5114.625 | 2770.749
2013/142 | 1058 | 1030 | 3787.233009708738 | 2770.749 | 3900.85 | 65 | 6736.599 |  | 2815 | 550 | 409.5990000000002 | 700 | 4474.599 | 2262
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2013-12-12 09:42:17.760000
Spreadsheet: 151907d1335182607-excel-2007-problem-with-a-vlookup-if-example
Sheet: Sheet1

2:00-10:00 | AAOffice | jone | A | NP | BBF |  | PRO |  |  | Presto | MCOM |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | L | L | 1 | L | B2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
7:30 - 12:00 | AAOffice | Sonia |  | NP |  | HBF | PRO |  |  |  |  | STFD |  |  | 1 | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
7:30 - 3:30 | AAOffice | Ana |  |  |  | HBF | PRO |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | L | L | 1 | 1 | 1 | 1 | 1 | 1 | B2 | 1 | 1 | 1 | 1
8:00 - 4:00 | AAH | [NAME] |  | NP |  | HBF |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | L | L | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B2 | 1 | 1 | 1 | 1 | 1
8:00 - 4:00 | AAH | [NAME] | A | NP | BBF |  | PRO |  |  | Presto | MCOM |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | L | L | 1 | 1 | 1 | 1 | 1 | 1 | B2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 263a63f5-2eec-40b4-a386-619c3903c0ec
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
PAHD | Test | PAHD | Phthalic Anhydride, IgE | Phthalic Anhydride, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	>or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PAHD | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PAHD | Result | PAHD | Phthalic Anhydride, IgE | Phthalic Anhydride, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7601-8
Spreadsheet: 759394d1639509300-dynamic-array-challenge-filter-from-multiple-tables-test-to-figure-out-groupings
Sheet: Sheet1

Name | AlternateRoute | PrimaryRoute |  | Building | Route | Clearance | PropMgr |  | Name | Clearance | Status
[NAME] | B | A |  | Bldg1 | A | Gold | [NAME] |  | [NAME] | Gold | Level1
[NAME] | D | A |  | Bldg2 | A | Silver | [NAME] |  | [NAME] | Silver | Level1
[NAME] | A | B |  | Bldg3 | B | Gold | Smith |  | [NAME] | Gold | Level2
[NAME] | A | B |  | Bldg4 | C | Silver | [NAME] |  | [NAME] | Silver | Level2
[NAME] | B | C |  | Bldg5 | C | [NAME] | Smith |  | [NAME] | [NAME] | Level1
Carol | C | D |  | Bldg6 | D | Gold | [NAME] |  | Carol | Silver | Level3
The three tables above all have many more rows and will grow over time…
Filter by ALL or by PropMgr
 | [NAME]
Result - Shows all Names & statuses who have as primary or alternate routes - Either in a pivot table or a dynamic list
 | PropMgr | Building | Route | Clearance | AlternateRoute | PrimaryRoute | Name | Status
 |  | Bldg1 | A | Gold |  | A | [NAME] | Level2
 | [NAME] | Bldg1 | A | Gold | A |  | [NAME] | Level1
 | [NAME] | Bldg2 | A | Silver |  | A | [NAME] | Level 2
 | [NAME] | Bldg2 | A | Silver | A |  | [NAME] | Level1
 | [NAME] | Bldg4 | C | Silver | C |  | Carol | Level3
Spreadsheet: 2019d642-5b28-4fdf-9c28-7dfbf69cea7d
Sheet: Sheet1

Appendix 11: Syphilis Patient Documentation Sheet for the Center of Hope | Unnamed: 1 | Unnamed: 2
 | Dossier [NAME]: Sant Lespwa
Patient: femme
Point de Service: Sant Lespwa
Adresse:
[NAME] | [NAME] | Enfant
Nom: | Nom: | Nom:
Prénom: | Prénom: | Prénom:
Date de naissance: | Date de naissance: | Date de naissance:
#Dossier Sant Lespwa: | #[NAME] (s'il en a un):
#[NAME] (si elle en a un): | [NAME] disponible:        oui     non | #[NAME] (s'il en a un):
 | Si l'homme n'est pas disponible,
Date teste + syphilis: | la raison:
Dates traitements syphilis & sign. | Dates traitements syphilis & sign. | Date traitement syphilis & sign.
1er: | 1er: | 1er:
2e: | 2e:
3e: | 3e: | Réference à l'hôpital:  oui    non
Allergie à la PNC:    oui      non | Allergie à la PNC:   oui    non | Allergie à la PNC:  oui       non
Résultat teste VIH: | Résultat teste VIH: | Résultat teste VIH: