tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 34674d1231980498-how-do-i-find-sum-values-based-on-2-critera-hours-worked
Sheet: Sheet1

[NAME] | 2009-01-01 00:00:00 | 5 | Manager |  |  |  | 2009-01-01 00:00:00
[NAME] | 2009-02-01 00:00:00 | 4 | Temp |  |  |  | 2009-02-01 00:00:00
[NAME] | 2009-03-01 00:00:00 | 3 | Temp |  |  |  | 2009-03-01 00:00:00
[NAME] | 2009-04-01 00:00:00 | 1 | Temp |  |  |  | 2009-04-01 00:00:00
[NAME] | 2009-02-01 00:00:00 | 2 | Full Time |  |  |  | 2009-05-01 00:00:00
[NAME] | 2009-02-01 00:00:00 | 3 | Manager |  |  |  | 2009-06-01 00:00:00
 |  |  |  |  |  |  | 2009-07-01 00:00:00
 |  |  |  |  |  |  | 2009-08-01 00:00:00
 |  |  |  |  |  |  | 2009-09-01 00:00:00
 | FROM | TO |  |  |  |  | 2009-10-01 00:00:00
 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 |  |  |  |  | 2009-11-01 00:00:00
[NAME] | 8 |  |  |  |  |  | 2009-12-01 00:00:00
[NAME] | 4
[NAME] | 0
[NAME] | 0
[NAME] | 2
 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
[NAME] | 5 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 29046d1223706124-two-dimensional-help-jg-master
Sheet: GT-Sat

 |  |  |  |  |  |  |  |  |  |  | # in class
 | RODEO: MSLBRA
 | DATE:
 | DIVISION:  Jr. Girls
 | EVENT:  [NAME]
 | PERFORMANCE: Rodeo #1
 | Secretary's Signature:
 | # | NAME | HOMETOWN | DRAW | OFFICIAL TIME | BACK UP TIME | PENALTY AND COMMENT | TOTAL | PLACE | Pts
 | 6431 | CallieRuth Bridgforth | Anywhere, NY |  |  |  |  |  | 1 | 73 | Jr. Girls Goat Tying-Saturday
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A |  |  |  |  |  |  | ---
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
 | --- | #N/A | #N/A
Spreadsheet: 268508d1380658830-need-help-with-if-statements-if_statement_exs
Sheet: Infants Wt

Baby ID | Infants Wt | Q.a | Q.b | Q.c | Q.d
1 | 10.7
2 | 17.1
3 | 17.2
4 | 18.2
5 | 20.6
6 | 15.8
7 | 17.8
8 | 18.8
9 | 10.8
10 | 16
11 | 15.4
12 | 19.6
13 | 17.8
14 | 20.8
15 | 17.9
16 | 15.9
17 | 19.8
18 | 17.8
19 | 21.5
20 | 18.3
21 | 14.5
AVERAGE
Spreadsheet: 151259d1334843983-shared-worksheet-report
Sheet: PT

 |  |  |  | Time in Minutes  & NO OF PGS
 | Valeurs
Operator Name | Time in Minutes | NO OF PGS | NO OF PGS/MN
Mo | 59.99999999999994 | 80 | 1.333333333333335
[NAME] | 89.99999999999991 | 80 | 0.8888888888888897
[NAME] | 125.0000000000001 | 105 | 0.8399999999999992
[NAME] | 40.00000000000001 | 20 | 0.4999999999999998
[NAME] | 179.9999999999999 | 80 | 0.4444444444444446
(blank) | 0 |  | #N/A
Grand Total | 494.9999999999999 | 365 | 0.7373737373737375
Spreadsheet: 676487d1588832863-index-match-formula-manager-and-employee-for-work-contact-tree-book4
Sheet: Contact Tree

 |  |  |  |  |  |  |  |  |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
Work [NAME] |  |  |  | Work [NAME] |  |  |  | Work [NAME]
Work Mob. |  |  |  | Work Mob. |  |  |  | Work Mob.
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Personal Mob. |  |  |  | Personal Mob. |  |  |  | Personal Mob.
 |  |  |  |  |  |  |  |  |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
ID |  |  |  | ID |  |  |  | ID |  |  |  | I need the same here but I want the formula to be based upon who the manger is for each employee
Position |  |  |  | Position |  |  |  | Position |  |  |  | so that their information is below the person that is there manager.
Mobile |  |  |  | Mobile |  |  |  | Mobile
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
ID |  |  |  | ID |  |  |  | ID |  |  |  | I need the same here but I want the formula to be based upon who the manger is for each employee
Position |  |  |  | Position |  |  |  | Position |  |  |  | so that their information is below the person that is there manager.
Mobile |  |  |  | Mobile |  |  |  | Mobile
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
ID |  |  |  | ID |  |  |  | ID |  |  |  | I need the same here but I want the formula to be based upon who the manger is for each employee
Position |  |  |  | Position |  |  |  | Position |  |  |  | so that their information is below the person that is there manager.
Mobile |  |  |  | Mobile |  |  |  | Mobile
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | <------ I need the name of the employee to populate in the heading of the contact information.
 |  |  |  |  |  |  |  |  |  |  |  | I need the same here but I want the formula to be based upon who the manger is for each employee
ID |  |  |  | ID |  |  |  | ID |  |  |  | so that their information is below the person that is there manager.
Position |  |  |  | Position |  |  |  | Position
Mobile |  |  |  | Mobile |  |  |  | Mobile
[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Spreadsheet: 118629d1313805499-excel-2007-validation-libro3
Sheet: Hoja1

OPERATION | INV. Nº | DATE INVOICE / PAYMENT | CLIENT | VALUE | DUE VALUE
Sold | 1000 | 2009-08-20 00:00:00 | DW China / Access Int | 26520 | 26520
Paid | 1000 | 2011-05-20 00:00:00 | DW China / Access Int | -6000 | 20520
Paid | 1000 | 2011-06-15 00:00:00 | DW China / Access Int | -10900 | 9620
Sold | 1001 | 2009-12-11 00:00:00 | VINOTECA | 2653200 | 2653200
Paid | 1001 | 2010-04-06 00:00:00 | VINOTECA | -442200 | 2211000
Sold | 993 | 2009-12-29 00:00:00 | CAFÉ TREBONS | 176880 | 176880
Sold | 994 | 2009-12-29 00:00:00 | CAFÉ TREBONS | 88440 | 88440
Sold | 995 | 2009-12-29 00:00:00 | CAFÉ TREBONS | 176880 | 176880
Sold | 996 | 2009-12-29 00:00:00 | CAFÉ TREBONS | 72360 | 72360
Paid | 993 | 2010-02-19 00:00:00 | CAFÉ TREBONS | -176880 | 0
I want to create a Validation in Column E that when column A is written "Paid" I only can fill in a negative number.
In other words when I type a positive number in column E I should get error message (when in A is "Paid") stating that only negative numbers are allowed.
I use the formula =IF($A2="Paid";H2<0;"") but this gives me always the error message by typing positive number independent of what is written in column A
Spreadsheet: 3e0495be-c307-4df7-8b49-b8ca0ae395a8
Sheet: SUMMARY-Biennial

FEB 2011 VS. NOV 2010
FEBRUARY 2011 FORECAST |  |  | 2008-09 | 2010-11 | 2012-13 | 2014-15 | Chg: 2008-09 | % chg | Chg: 2010-11 | % chg | Chg: 2012-13 | % chg
1 | AMCPU
 | REVENUES
 | Basic
 | Additional $51
 | Gifted & Talented
 | Extended time
 | Basic Skills:
 |  | Compensatory
 |  | LEP
 |  | LEP Concentration
 | Sparsity
 | Transport Sparsity
 | Training & Experience
 | Late Contract Penalty
 | One-time Reduction
 | Operating Capital
 | Equity
 | Transition
 | Q Comp
 | Referendum Revenue
 | Alternative [NAME]:
 |  | All Categories
 | TOTAL REVENUE
 | LEVIES
 | Operating Capital Levy
 | Equity [NAME]
 | [NAME]
 | Q Comp
 | [NAME]
 | TOTAL LEVY
 | AID ENTITLEMENTS
 | Basic
 | Additional $51
 | Gifted & Talented
 | Extended time
 | Basic Skills:
 |  | Compensatory
 |  | LEP
 |  | LEP Concentration
 | Sparsity
 | Transport Sparsity
 | Training & Experience
 | Late Contract Penalty
 | One-time Reduction
 | Operating Capital
 | Equity
 | Transition
 | Q Comp
 | Referendum Equalization Aid
 | Tax Base Replacement Aid
 | Alternative [NAME]:
 |  | All Categories
 | TOTAL AID ENTITLEMENT
 | General [NAME] (IDEAS)
 | Tax Base Repl Entitlemt (thru FY07)
 | TRA Reduction
 | GRAND TOTAL AID ENTITLEMENT
Spreadsheet: 779569d1651857523-lookup-function-with-4-different-parameters-milestone-calculator
Sheet: Milestones

Milestone Calculator
Project Size: | Large
Urgency: | High |  |  |  |  | The goal is for the user to indicate the desired completion date, the size and the urgency of the project and the dates would appear automatically, using the duration for each scenario that are indicated in the calculation tab.  It would probably have to take the required completion date and sustract the durations of all the activities to come
Required Completion Date: | 2022-12-20 00:00:00
Milestone | Estimated Duration | Date
Milestone 1
Milestone 2
Milestone 3
Milestone 4
Milestone 5
Milestone 6
Milestone 7
Milestone 8
Milestone 9
Milestone 10
Project Length
Spreadsheet: 150106d1334291645-choosing-a-worksheet-with-drop-down-list-then-selecting-data-with-another-drop-down-list-example
Sheet: Technical Support Log

Technical Support Log
Date:
Tech Specialist:
Company Name:
Contact Person:
Phone #:
[NAME]:
Type of Call:
Model : |  |  | Other: |  |  | Conditions:
S/N: |  |  |  |  |  | Flowrate |  | SCFM
 |  |  |  |  |  | Pressure |  | PSIG
 |  |  |  |  |  | Inlet Temp |  | °F
 |  |  |  |  |  | Ambient |  | °F
Alarm Code | Description |  | Cause |  |  | Remedy
F1
USER MANUAL
NOTES/RESOLUTION:
Spreadsheet: tracy_geaccone__40541__tw_actflash_o&m
Sheet: tw0901

[NAME]
O&M by Alternate Hierarchy
Period Ending September 30, 2001
5th Workday
 | Actual | Actual | Flash | Over/(Under) | Over/(Under) | Actual | Actual
 | August 2001 | September 2001 | September 2001 | Prior Month | Flash | YTD September 2001 | YTD August 2001
ETS - Commercial (AGR-TP10) | 108777.7 |  | 167000 |  |  |  | 1486618.29
ETS - Market Services (AGR-TP20) | 122832.08 |  | 196000 |  |  |  | 1033689.01
ETS - Operations (AGR-TP30) | 2477725.17 |  | 1132000 |  |  |  | 18328524.03
ETS - Finance & Accounting (AGR-TP40) | 763111.09
ETS - Systems (AGR-TP50) | 305579.14 |  | 352000 |  |  |  | 1769510.62
ETS - Legal (AGR-TP60) | 74578.7 |  | 126000 |  |  |  | 573583.74
ETS - HR (AGR-TP70) | 22705.03 |  | 23000 |  |  |  | 194840.04
ETS - Executive (AGR-TP80) | 49691.09 |  | 23000 |  |  |  | 870262.2
Total O&M Expense
(A) R111080 includes YTD September Adjustment for FI/CO reconciliation of $143,306.68 (AGR-TP40)
( A ) Commercial | 79
Credit last month due to reclassing
Southwest Gas Capacity fee from G&A
to Tspt revenue. | 142
Other | -63
( B ) Operations | -533
August Gallup Sector 5 P/L Repairs - Risk Mgmt.
Settlement from X.001097.[PHONE] | -323
Other | -25
Spreadsheet: 96967d1296193475-looking-for-advice-to-improve-function-of-workbook-lab-stuff
Sheet: Chemical Report

Daily Chemical Usage Report
# | Chemical Name | Compound | Starting | Used | Ending | %
1 | Acetone | C3H6O | 0
2 | Ammonium nitrate | NH4NO3 | 0
3 | distilled water | H2O | 0
4 | Erythritol | C4H10O4 | 0
5 | Ethanol | C2H6O | 0
6 | Hexamine | C6H12N4 | 0
7 | Nitric Acid | HNO3 | 0
8 | potassium nitrate | KNO3 | 0
9 | Sodium bicarbonate | CHNaO3 | 0
10 | sulfuric acid | H2SO4 | 0
11 |  |  | 0
12 |  |  | 0
13 |  |  | 0
14 |  |  | 0
15 |  |  | 0
16 |  |  | 0
17 |  |  | 0
18 |  |  | 0
19 |  |  | 0
20 |  |  | 0
21 |  |  | 0
22 |  |  | 0
23 |  |  | 0
24 |  |  | 0
25 |  |  | 0
Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Spreadsheet: 787498d1-883f-462c-afb0-159a7428f6fe
Sheet: Sheet1

A | B | C | D | E | F | G | H | I | J | K | L | M
 |  |  | Child | No. of | Per | Amount | 2006-07 | Amount | 2006-07 | 2006-07 | 2006-07 | 2006-07
2006-05-06 00:00:00 | AEA | LEA | Count | Identified | Cent | from | Net  LEA | from AEA | Net  AEA | Funds | 15% [NAME] | 15% [NAME]
Fall 05 Data | Portion | Flow through | 2005 | [NAME] | for | [NAME]  to AEA | Flow | Entitlement | Funds | for | for EIS | for EIS
 |  | AEAs to LEAs | 6-21 | 6-21 | Non- | for Non-Pub | through | for Non-Pub |  | Non-Pub | LEA | AEA
 | 06-07 | 06-07 |  | 2005 | Public |  |  | Services |  | Services
AEA |  |  |  |  | E / D | C * F | C - G | B * F | B - I | G + I | H * 15% | J * 15%
AEA 01 | 5201510 | 1848964 | 4558 | 108 | 0.02369460289600702 | 43810 | 1805154 | 123248 | 5078262 | 167058 | 270773 | 761739
AEA 07 | 9919136 | 3569690 | 9465 | 126 | 0.0133122028526149 | 47520 | 3522170 | 132046 | 9787090 | 179566 | 528326 | 1468064
AEA 08 | 5243984 | 1835590 | 4309 | 113 | 0.02622418194476677 | 48137 | 1787453 | 137519 | 5106465 | 185656 | 268118 | 765970
AEA 09 | 7156086 | 2749530 | 6038 | 44 | 0.00728718118582312 | 20036 | 2729494 | 52148 | 7103938 | 72184 | 409424 | 1065591
AEA 10 | 9004843 | 3473635 | 9226 | 82 | 0.008887925428137872 | 30873 | 3442762 | 80034 | 8924809 | 110907 | 516414 | 1338721
AEA 11 | 16348355 | 6515805 | 15880 | 127 | 0.007997481108312342 | 52110 | 6463695 | 130746 | 16217609 | 182856 | 969554 | 2432641
AEA 4 &12 | 6127171 | 2326865 | 5091 | 100 | 0.01964250638381457 | 45705 | 2281160 | 120353 | 6006818 | 166058 | 342174 | 901023
AEA 13 | 4680707 | 1682233 | 4256 | 28 | 0.006578947368421052 | 11067 | 1671166 | 30794 | 4649913 | 41861 | 250675 | 697487
AEA 14 | 1829427 | 575803 | 1711 | 1 | 0.0005844535359438924 | 337 | 575466 | 1069 | 1828358 | 1406 | 86320 | 274254
AEA 15 | 3567414 | 1217741 | 3115 | 12 | 0.003852327447833066 | 4691 | 1213050 | 13743 | 3553671 | 18434 | 181958 | 533051
AEA 16 | 2840720 | 963183 | 2690 | 44 | 0.01635687732342007 | 15755 | 947428 | 46465 | 2794255 | 62220 | 142114 | 419138
Total | 71919353 | 26759039 | 66339 | 785 | 0.01183315998130813 | 320041 | 26438998 | 868165 | 71051188 | 1188206 | 3965850 | 10657679
Spreadsheet: 176767d1346092349-lookup-on-mult-match-lookup_values-modified-by-tigeravatar-
Sheet: Analysis

ID# | L Name | F Name | DOB | G | PLAN | PROVIDER | DOS | POS | CPT | CPT DESC | MOD | DX | DxDescr | ICD-9-CM Description
10000 | Doe | [NAME] | 1/1/2000 |  |  |  |  |  |  |  |  | 311 | DEPRESSIVE DISORDER NEC | Depressive disorder NEC
10000 | Doe | [NAME] | 1/1/2000 |  |  |  |  |  |  |  |  | 530.81 | ESOPHAGEAL REFLUX | Esophageal reflux
10000 | Doe | [NAME] | 1/1/2000 |  |  |  |  |  |  |  |  | 272.4 | HYPERLIPIDEMIA NEC/NOS | Hyperlipidemia NEC/NOS
10001 | Lui | [NAME] | 1/1/2003 |  |  |  |  |  |  |  |  | 401.9 | HYPERTENSION NOS | Hypertension NOS
10001 | Lui | [NAME] | 1/1/2003 |  |  |  |  |  |  |  |  | 250 | [NAME] ST UNCNTR | [NAME] uncntr
10001 | Lui | [NAME] | 1/1/2003 |  |  |  |  |  |  |  |  | 272.4 | HYPERLIPIDEMIA NEC/NOS | Hyperlipidemia NEC/NOS
10002 | [NAME] | [NAME] | 1/1/2006 |  |  |  |  |  |  |  |  | 272.4 | HYPERLIPIDEMIA NEC/NOS | Hyperlipidemia NEC/NOS
10002 | [NAME] | [NAME] | 1/1/2006 |  |  |  |  |  |  |  |  | 584.9 | ACUTE RENAL FAILURE NOS | Acute kidney failure NOS
10002 | [NAME] | [NAME] | 1/1/2006 |  |  |  |  |  |  |  |  | 560.1 | PARALYTIC ILEUS | Paralytic ileus
10002 | [NAME] | [NAME] | 1/1/2006 |  |  |  |  |  |  |  |  | 997.4 | COMP-DIGESTV SYSTEM* | Surg comp-digestv system
10002 | [NAME] | [NAME] | 1/1/2006 |  |  |  |  |  |  |  |  | 401.9 | HYPERTENSION NOS | Hypertension NOS
10002 | [NAME] | [NAME] | 1/1/2006 |  |  |  |  |  |  |  |  | 560.9 | INTESTINAL OBSTRUCT NOS | Intestinal obstruct NOS
10002 | [NAME] | [NAME] | 1/1/2006 |  |  |  |  |  |  |  |  | 401.1 | BENIGN HYPERTENSION | Benign hypertension
10002 | [NAME] | [NAME] | 1/1/2006 |  |  |  |  |  |  |  |  | 263.9 | PROTEIN-CAL MALNUTR NOS | Protein-cal malnutr NOS
10003 | Mint | Leaf | 1/1/2014 |  |  |  |  |  |  |  |  | 443.9 | PERIPH VASCULAR DIS NOS | Periph vascular dis NOS
10003 | Mint | Leaf | 1/1/2014 |  |  |  |  |  |  |  |  | 433.1 | OCL CRTD ART W/O INFRCT | Ocl crtd art wo infrct
10003 | Mint | Leaf | 1/1/2014 |  |  |  |  |  |  |  |  | 585.2 | CHRO KIDNEY DIS STAGE II | Chro kidney dis stage II
10003 | Mint | Leaf | 1/1/2014 |  |  |  |  |  |  |  |  | 272.4 | HYPERLIPIDEMIA NEC/NOS | Hyperlipidemia NEC/NOS
10004 | Adams | [NAME] | 1/1/2018 |  |  |  |  |  |  |  |  | 491.9 | CHRONIC BRONCHITIS NOS | Chronic bronchitis NOS
10004 | Adams | [NAME] | 1/1/2018 |  |  |  |  |  |  |  |  | 401.9 | HYPERTENSION NOS | Hypertension NOS
10004 | Adams | [NAME] | 1/1/2018 |  |  |  |  |  |  |  |  | 491.1 | MUCOPURUL CHRONIC BRONCHITIS | Mucopurul chr bronchitis
10004 | Adams | [NAME] | 1/1/2018 |  |  |  |  |  |  |  |  | 530.81 | ESOPHAGEAL REFLUX | Esophageal reflux
Spreadsheet: 885978d1735921024-additional-formula-to-add-to-the-main-one-book10
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | country | risk score
 |  | Country | score |  |  |  |  |  |  |  | algeria | 25
 | country operating | italy |  |  |  |  |  |  |  |  | turkey | 11
 | country reporting | UK |  |  |  |  |  |  |  |  | UAE | 16
 | country fiscal tax | canada |  |  |  |  |  |  |  |  | UK | 8
 | country payment | spain |  |  |  |  |  |  |  |  | USA | 12
 | country manager | algeria |  |  |  |  |  |  |  |  | canada | 10
 |  |  |  |  |  |  |  |  |  |  | italy | 20
 |  |  |  |  |  |  |  |  |  |  | spain | 30
 |  |  |  |  |  |  |  |  |  |  | germany | 25
 | CONDITION: | If the country of operation refers only to Italy, and the other selections (country of reporting, fiscal tax, payment, and manager) are different, proceed with the normal calculation. However, if any of these other selections also indicate Italy, assign a score of 60.01, regardless of the normal sum. Please integrate this condition into the main formula below.
 | FORMULA TO INTEGRATE WITH AN ADDITIONAL CONDITION:
 | =IF(COUNTIF(N9:N22,"Prohibited")>0,80.01,IF(COUNTIF(N9:N22,"Restricted")>0,60.01,IF(N24="Prohibited",60.01,IF(N40="Prohibited",60.01,IF(I36="Relevant Adverse Media",60.01,IF(N40="Restricted",60.01,IF(OR(ISNUMBER(MATCH(I26,Industry!$C$8:$C$12,0)),I35="PEP",SUM(--ISNUMBER(MATCH(#REF!,Dashboard!I9:I22,0)))>0),60.01,0)))))))
Spreadsheet: e6474534-e1e2-48e1-8e37-93dd4ef76926
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
TBPB | Test | TBPB | Mycobacteria Probe Ident Broth | Mycobacteria Probe Ident Broth |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87150 |  |  |  |  | Rochester
TBPB | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 44063d1242738161-cumulative-return-for-rolling-dates-cumul-return
Sheet: Sheet1

 |  |  | Date | Return | Cumul return |  | Date | Return | Cumul return |  | Date | Return | Cumul return
 |  |  | 2009-05-06 00:00:00 | 0.001 | 0.006015020015005312 |  | 2009-05-09 00:00:00 | 0.001 | 0.009036084126124999 |  | 2009-05-17 00:00:00 | 0.001 | 0.01713668238619848
 |  |  | 2009-05-05 00:00:00 | 0.001 | 0.005010010005000343 |  | 2009-05-08 00:00:00 | 0.001 | 0.008028056070054967 |  | 2009-05-16 00:00:00 | 0.001 | 0.01612056182437427
 |  |  | 2009-05-04 00:00:00 | 0.001 | 0.004006004000999486 |  | 2009-05-07 00:00:00 | 0.001 | 0.007021035035020162 |  | 2009-05-15 00:00:00 | 0.001 | 0.01510545636800642
 |  |  | 2009-05-03 00:00:00 | 0.001 | 0.003003000999999506 |  | 2009-05-06 00:00:00 | 0.001 | 0.006015020015005312 |  | 2009-05-14 00:00:00 | 0.001 | 0.01409136500300345
 |  |  | 2009-05-02 00:00:00 | 0.001 | 0.002000999999999697 |  | 2009-05-05 00:00:00 | 0.001 | 0.005010010005000343 |  | 2009-05-13 00:00:00 | 0.001 | 0.0130782867162873
 |  |  | 2009-05-01 00:00:00 | 0.001 |  |  | 2009-05-04 00:00:00 | 0.001 | 0.004006004000999486 |  | 2009-05-12 00:00:00 | 0.001 | 0.01206622049579154
 |  |  |  |  |  |  | 2009-05-03 00:00:00 | 0.001 | 0.003003000999999506 |  | 2009-05-11 00:00:00 | 0.001 | 0.01105516533046114
 |  |  |  |  |  |  | 2009-05-02 00:00:00 | 0.001 | 0.002000999999999697 |  | 2009-05-10 00:00:00 | 0.001 | 0.01004512021025095
 |  |  |  |  |  |  | 2009-05-01 00:00:00 | 0.001 |  |  | 2009-05-09 00:00:00 | 0.001 | 0.009036084126124999
 |  |  |  |  |  |  |  |  |  |  | 2009-05-08 00:00:00 | 0.001 | 0.008028056070054967
 |  |  |  |  |  |  |  |  |  |  | 2009-05-07 00:00:00 | 0.001 | 0.007021035035020162
 |  |  |  |  |  |  |  |  |  |  | 2009-05-06 00:00:00 | 0.001 | 0.006015020015005312
 |  |  |  |  |  |  |  |  |  |  | 2009-05-05 00:00:00 | 0.001 | 0.005010010005000343
 |  |  |  |  |  |  |  |  |  |  | 2009-05-04 00:00:00 | 0.001 | 0.004006004000999486
 |  |  |  |  |  |  |  |  |  |  | 2009-05-03 00:00:00 | 0.001 | 0.003003000999999506
 |  |  |  |  |  |  |  |  |  |  | 2009-05-02 00:00:00 | 0.001 | 0.002000999999999697
 |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00 | 0.001
Spreadsheet: 867051d1713957585-populate-sheet-with-specific-data-from-a-different-sheet-test-report-ans
Sheet: Sprint Roadmap

Sprint 1 |  |  | Sprint 2 |  |  | Sprint 3 |  |  | Sprint 4
Issue Number | Summary | Points | Issue Number | Summary | Points | Issue Number | Summary | Points | Issue Number | Summary | Points
Spreadsheet: 07a93679-5149-4c38-ba01-c94e4162ccc6
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
9831 | Test | 9831 | Mucicarmine Stain for Mucin | Mucicarmine Stain for Mucin | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. Note: A pathology report and a brief history are required. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88313 |  |  |  |  | Rochester
9831 | [NAME] | MIXED | Mixed |  |  |  | Ambient
9831 | Result | 9831 | [NAME]'s Mucicarmine ST for Mucin | [NAME]'s Mucicarmine ST for Mucin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10822-5 | Mucin.microscopic observation:Prid:Pt:Tiss:Nom:Mucicarmine stain.Mayer