tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 5

 | Sep 27 | Oct 4 | Oct 11 | Oct 18 | Oct 25
Total Interest Rate | 84500 | 84500 | 84500 | 84500 | 84500
Cleared** | N/A*** | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 323000 | 323000 | 323000 | 323000 | 323000
Weekly total, estimated swap event volumes by asset class and cleared status (in number of events), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**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: 860756d1708734737-want-a-drop-down-menu-to-format-group-of-cells-from-a-reference-sheet-formatting-help
Sheet: 1

AREA SERVED |  |  |  |  | DESIGN |  |  | PRE | FINAL |  |  | NOTE | % of Design
 |  | NO. | TYPE | SIZE
REMARKS:
Spreadsheet: 213264d1360414645-help-merge-sheets-data-deep
Sheet: UIC

 |  | AD | SD | TD
 |  | 42 | 35 | 67
 |  | 23 | 45 | 67
Spreadsheet: 78426d1278773522-formula-that-automatically-uses-the-last-cell-in-a-row-book1-lookup-issue
Sheet: player info

 | CURRENT REQUIRMENTS
player ID | Name | tees | index | points |  |  | points made on last round played
1 | tom | B | 4.7 | 31 |  |  | 30 |  | e3 would stay at 31
2 | [NAME] | B | 7.9 | 28 |  |  | 20 |  | e4 would move to 25
3 | [NAME] | G | 22.5 | 23 |  |  | 20 |  | e5 would move to 21
4 | [NAME] | W | 14.7 | 21 |  |  | 15 |  | e6 would move to 19
5 | henry | B | 9.9 | 27 |  |  | 28 |  | e7 would stay at 27
6 | mary | R | 28.1 | 7 |  |  | 5 |  | e8 would move to 6
7 | sue | R | 16.8 | 19 |  |  | 7 |  | e9 would go down the max of 4 to 15
 |  |  |  | row E represents the points needed for the next round and I want it calculated from the "points made on last round played"
 |  |  |  | the points are adjusted as follows:
 |  |  |  | a player at or +1/-1 has no adjustment (quota stays the same)
 |  |  |  | a player over their points by 2-4 moves up +1, below their points by 2-4 goes down -1
 |  |  |  | a player over their points by 5-7 moves up +2, below their points by 5-7 goes down -2
 |  |  |  | a player over their points by 8-10 moves up +3, below their points by 8-10 goes down -3
 |  |  |  | A player at 11 or more over goes up +4 and under goes down -4.  4 is the MAX adjustment
For the last numeric value in a vector use LOOKUP, eg:
E3: =LOOKUP(9.99E+307,H3:V3)
If you want to account for possibility of 0 numbers then:
E3: =IF(COUNT(H3:V3),LOOKUP(9.99E+307,H3:V3),"")
In f3 and fill down
INDIRECT(ADDRESS(ROW(),SUMPRODUCT(--(H3:V3>0))+7))
will give you the last value in the row
Score sheet:
[NAME]: =VLOOKUP(A10,'player info'!A3:D9,3,FALSE)
G10: =VLOOKUP(A10,'player info'!A3:D9,4,FALSE)
IFERROR(VLOOKUP($A10,'player info'!$A$2:$D$9,COLUMN()-3,FALSE),"") drag over to G10 and down
IFERROR(VLOOKUP($A10,'player info'!$A$3:$D$9,COLUMN()-2,FALSE),"") drag down
Spreadsheet: 186298d1349977698-macro-to-automatically-insert-rows-between-changes-in-data-macro-example
Sheet: Sheet1

 |  | Actual | 2012 TSMB OPER
 |  | Sep | Sep
 |  | 2012 | 2012
Binghamtom Live Event - MISCELLANEOUS: 33503370 | 30330408: Live Events Concessions Rev | 0 | 4778
Binghamtom Live Event - MISCELLANEOUS: 33503370 | Live Events Revenue | 0 | 4778
Binghamtom Live Event - MISCELLANEOUS: 33503370 | Live Events BCF | 0 | 4778
Binghamtom Live Event - Spedie Fest & Ballon Rally: 33503371 | 54144001: Outside Talent Fees - Live Events | 3000 | 0
Binghamtom Live Event - Spedie Fest & Ballon Rally: 33503371 | 54147007: Miscellaneous - Live Events | 345.6 | 0
Binghamtom Live Event - Spedie Fest & Ballon Rally: 33503371 | Live Events Expense | 3345.6 | 0
Binghamtom Live Event - Spedie Fest & Ballon Rally: 33503371 | Live Events BCF | -3345.6 | 0
[NAME] Palooza: 33503375 | 30330406: Live Events Sponsorship Rev | 500 | 0
[NAME] Palooza: 33503375 | Live Events Revenue | 500 | 0
[NAME] Palooza: 33503375 | Live Events BCF | 500 | 0
[NAME] | 30330406: Live Events Sponsorship Rev | 500 | 0
[NAME] | 30330408: Live Events Concessions Rev | 0 | 4778
[NAME] | Live Events Revenue | 500 | 4778
[NAME] | 54144001: Outside Talent Fees - Live Events | 3000 | 0
[NAME] | 54147007: Miscellaneous - Live Events | 345.6 | 0
[NAME] | Live Events Expense | 3345.6 | 0
[NAME] | Live Events BCF | -2845.6 | 4778
Spreadsheet: 866673d1713561643-building-commish-tracker-struggling-with-formulas-marc-daily-tracker
Sheet: Comm Tracker

2024 | Goal | Actual Burn | % to Goal | Commish Potential | 0-100% | 101-200% | 201-250% | 251%+
Q1 |  |  |  |  | 1X | 1.25X | 2X
Q2 | 230000 | 250000 |  | 10000
Q3 | 230000 | 500000 |  | 10000
Q4
Spreadsheet: cd735703-203a-45b5-882f-91d4483970d9
Sheet: General

GENERAL |  |  |  |  |  |  | 120547
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Phase II Line Creek Watershed Study |  |  |  | Authorize the Director of Water Services to execute an
 | Planning Assistance to States Program |  |  |  | Agreement and expend funds.
Details                Project No. 82000154 |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Water Services Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Water Services Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | Water Services Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | Water Services Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | 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 |  |  |  |  | 100000
 |  |  |  |  | Account Codes |  |  |  |  | 13-3090-808208-B-82000154
 |  |  |  |  |  |  |  |  |  | Water and Sewer NC2
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME] |  | 2012-06-12 00:00:00
 | Project Manager
Reviewed by:
 | [NAME] |  | 2012-06-12 00:00:00
 | Waterways Division Manager
Reference Numbers |  |  | 110483
Spreadsheet: chris_germany__1684__200004strg
Sheet: Strg Proxy

[NAME] worksheet
CES Storage Allotment on TCO for COH Choice 2000/2001
 | FSS-SCQ | 6295922
 | SST-MDQ-W | 113053
 | SST-MDQ-S | 56527
 |  |  | S | W
 | COH-03 PORTSMOUTH | 22-15 | 927 | 1854
 | COH-07 TOLEDO | 23-1 | 15734 | 31467
 | COH-07 [NAME] | 23-3 | 2364 | 4727
 | COH-07 [NAME] | 23-4 | 1834 | 3667
 | COH-07 COLUMBUS | 23-5 | 14701 | 29402
 | COH-07 DAYTON | 23-6 | 2502 | 5004
 | COH-07 MANSFIELD | 23-8 | 2680 | 5359
 | COH-07 OHIO MISC | 23-9 | 3261 | 6521
 | COH-05 PARMA | 23N-2 | 7673 | 15345
 | COH-05 SANDUSKY | 23N-7 | 3096 | 6192
 | COH-08 PITTSBURGH | 24-35 | 1724 | 3447
 | COH-08 NEWCASTLE | 24-39 | 34 | 68
Actual Storage MDQ Effective 4/1/2000
 | FSS-SCQ | 6050607
 | SST-MDQ-W | ???
 | SST-MDQ-S | 54327
 | [NAME] 3/31/2000 | 170981
 | [NAME]
 | [NAME] | Inject % |  | Balance | Monthly | Daily
 | 2000-04-01 00:00:00 | 0.13 |  | 170981
 | 2000-05-01 00:00:00 | 0.18
 | 2000-06-01 00:00:00 | 0.18
 | 2000-07-01 00:00:00 | 0.18
 | 2000-08-01 00:00:00 | 0.18
 | 2000-09-01 00:00:00 | 0.13
 | 2000-10-01 00:00:00 | 0.02
 | 2000-11-01 00:00:00 | 0
 | 2000-12-01 00:00:00 | 0
Spreadsheet: 782455d1654065629-how-to-count-without-splitting-data-from-cell-count-left-with-sumproduct-aligw
Sheet: Sheet1

Date | Item |  |  |  | A035F | A035FZ | A135F
2022-05-01 00:00:00 | A035F-BLUE |  |  | 2022-05-01 00:00:00
2022-05-01 00:00:00 | A035F-BLACK |  |  | 2022-05-05 00:00:00
2022-05-01 00:00:00 | A035F-BLACK |  |  | 2022-05-08 00:00:00
2022-05-01 00:00:00 | A035F-BLACK |  |  | 2022-05-10 00:00:00
2022-05-05 00:00:00 | A035F-BLACK |  |  | 2022-05-15 00:00:00
2022-05-05 00:00:00 | A035F-BLACK
2022-05-05 00:00:00 | A035F-BLACK
2022-05-05 00:00:00 | A035FZ-BLACK
2022-05-08 00:00:00 | A035FZ-BLACK
2022-05-08 00:00:00 | A035FZ-BLACK
2022-05-08 00:00:00 | A135F-BLUE
2022-05-08 00:00:00 | A135F-BLUE
2022-05-08 00:00:00 | A135F-BLUE
2022-05-08 00:00:00 | A135F-BLUE
2022-05-10 00:00:00 | A135F-BLUE
2022-05-10 00:00:00 | A135F-BLUE
2022-05-10 00:00:00 | A135F-BLUE
2022-05-10 00:00:00 | A135F-BLUE
2022-05-10 00:00:00 | A135F-Peach
2022-05-10 00:00:00 | A135F-Peach
2022-05-10 00:00:00 | A035FZ-BLUE
2022-05-10 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
2022-05-15 00:00:00 | A035FZ-BLUE
Spreadsheet: 773101d1647615632-see-avaibility-non-avaibility-based-in-tab-3-based-on-tab-1-tab-2-hopper-portfolio-management-to-send
Sheet: 3-Team Calendar

 |  |  |  |  | Week Of:
 |  |  |  |  | Week Number:
TEAM MEMBERS
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Vaish Vemireddy
Spreadsheet: 782809d1654282166-need-help-with-mult-ifs-statement-with-indexing-sample-data
Sheet: Sheet1

Source_Num | Code_Num | Type | Value |  |  |  | Code_Num | A_Value | B_Value
412358 | 147 | A | 6 |  |  |  | 147 | 6
56425 | 152 | A | 15 |  |  |  | 152 | 15
64323 | 321 | B | 15 |  |  |  | 321 | 11 | 15
59988 | 321 | A | 11 |  |  |  | 474 |  | 30
74613 | 321 | A | 11 |  |  |  | 852 | 14 | 18
52625 | 474 | B | 30 |  |  |  | 985 | 12 | 20
61932 | 852 | A | 14
23164 | 852 | B | 18
78456 | 985 | A | 12
525252 | 985 | B | 20
14785 | 985
13698 |  | A
Spreadsheet: 272995d1382564169-compare-columns-and-delete-duplicates-book1
Sheet: Org-Data

Source address | Destination address | Destination Port | Application | IP Protocol
192.168.1.2 | 192.168.250.10 | 53 | dns | udp
192.168.1.3 | 192.168.250.20 | 53 | dns | udp
192.168.1.2 | 192.168.250.10 | 53 | dns | udp
192.168.1.3 | 192.168.250.20 | 53 | dns | udp
192.168.1.6 | 192.168.250.10 | 53 | dns | udp
192.168.1.3 | 192.168.250.20 | 53 | dns | udp
192.168.1.6 | 192.168.125.33 | 53 | dns | udp
192.168.1.6 | 192.168.125.33 | 135 | msrpc | tcp
192.168.3.1 | 192.168.125.70 | 135 | msrpc | tcp
192.168.3.1 | 192.168.125.45 | 135 | msrpc | tcp
192.168.3.1 | 192.168.125.70 | 135 | msrpc | tcp
192.168.3.3 | 192.168.125.33 | 135 | msrpc | tcp
192.168.3.1 | 192.168.125.45 | 135 | msrpc | tcp
192.168.3.3 | 192.168.125.45 | 135 | msrpc | tcp
192.168.3.1 | 192.168.125.70 | 135 | msrpc | tcp
192.168.3.1 | 192.168.125.45 | 135 | msrpc | tcp
192.168.3.3 | 192.168.125.33 | 135 | msrpc | tcp
Spreadsheet: 014e2455-a765-4490-89ae-c77ccb83e473
Sheet: Sheet1

ตารางการ  Ranking  รอบที่  ๑/๒๕๕๕  ประจำปีงบประมาณ  ๒๕๕๕ ( งานสร้างสุขภาพและอนามัยสิ่งแวดล้อม ) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
สำนักงานสาธารณสุขอำเภอโพธิ์ศรีสุวรรณ  จังหวัดศรีสะเกษ
วันที่ | เวลา | งานที่ตรวจ | ผู้ตรวจ | สถานที่ตรวจ
๒๙ กุมภาพันธ์ ๒๕๕๕ | ๐๙.๐๐ - ๐๙.๓๐ น. | ศูนย์เด็ก + โภชนาการ | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
 | ๐๙.๓๐ - ๑๐.๐๐ น. | อนามัยโรงเรียน | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
 | ๑๐.๐๐ - ๑๐.๓๐ น. | มะเร็ง | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
 | ๑๐.๓๐ - ๑๑.๐๐ น. | ไอโอดีน | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
 | ๑๑.๐๐ - ๑๑.๓๐ น. | ผู้พิการ | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
 | ๑๑.๓๐ - ๑๒.๐๐ น. | ผู้สูงอายุ | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
 | ๑๓.๓๐ - ๑๔.๐๐ น. | ชมรมสร้างสุขภาพประชาชนอายุ ๑๕ ปีขึ้นไป | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
 | ๑๔.๐๐ - ๑๔.๓๐ น. | อนามัยสิ่งแวดล้อม | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
 | ๑๔.๓๐ - ๑๕.๐๐ น. | ทันตสาธารณสุข + งานยาเสพติด + งานสุขภาพจิต | เนื่องจากเป็นแฟ้มงานที่ได้ดำเนินการตรวจไปแล้ว สสอ.เพื่อรวบรวมข้อมูล
 |  | งานอนามัยแม่และเด็ก | จึงขอความร่วมมือจากรพ.สต.ทุกแห่งได้นำแฟ้มงานมาไว้ที่ เป็นภาพรวมต่อไป
๑. มีนาคม ๒๕๕๕ | ๐๙.๐๐ - ๑๒.๐๐ น. | เก็บตกเอกสารทุกงานตามผู้รับผิดชอบนัดหมาย | นางสาวจิรวรรณ  บุญรัตนเมธี | สสอ.โพธิ์ศรีสุวรรณ
Spreadsheet: 217288d1362036839-calculating-ytd-of-monthly-averages-ytdcalculations-rev
Sheet: Sheet1

 | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00 |  |  | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00
 | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams
xxx | 30000 |  | 20000 |  | 21000 |  | 20000 |  | 25000 |  | 26000 |  | 36000 |  | 40000 |  | 27000 |  | 25800 |  | 28000 |  | 34000 |  |  | 25 |  | 30 |  | 25 |  | 25 |  | 25 |  | 26 |  | 24 |  | 28 |  | 29 |  | 21 |  | 23 |  | 20
 | SELECT DATE |  | YTD | YTD per Team
 | 2012-03-01 00:00:00
 |  |  |  |  | If the month chosen is April then we should have a formula that calculates as follows:   = (30000/25)+(20000/30)+(21000/25)+(20000/25)  Note : that this is a simple example and that my dates go back a few years and not just in 2012 Note2 :
 | 2012-01-01 00:00:00
 | 2012-02-01 00:00:00
 | 2012-03-01 00:00:00
 | 2012-04-01 00:00:00
 | 2012-05-01 00:00:00
 | 2012-06-01 00:00:00
 | 2012-07-01 00:00:00
 | 2012-08-01 00:00:00
 | 2012-09-01 00:00:00
 | 2012-10-01 00:00:00
 | 2012-11-01 00:00:00
 | 2012-12-01 00:00:00
Spreadsheet: b069483f-5728-440d-b3ef-6339b35052fd
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
COMT | Test | COMT | Catechol-O-Methyltransferase Genotype | [NAME] Genotype | Polymerase Chain Reaction (PCR) with Allele-Specific Primer Extension (ASPE) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavendar-top (EDTA) Tube: EDTA |  |  | 3 | mL | Multiple whole blood EDTA genotype tests can be performed on a single specimen after a single extraction. See Multiple Whole Blood EDTA Genotype Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: Lavender top (EDTA) [NAME]: 3 mL  Collection Instructions: Send specimen in original tube. Additional Information: 1. Bone marrow and liver transplants will interfere with testing. Call Mayo Medical Laboratories at [PHONE] or [PHONE] for instructions. 2. Transfusions will interfere with testing for up to 4 to 6 weeks. DNA obtained from white cells may not provide useful information for patients who received a recent transfusion of blood that was not leukocyte-reduced. Wait 4 to 6 weeks until transfused cells have left the patient's circulation before drawing the patient's blood specimen for genotype testing. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.3 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Wednesday; 8 a.m. | 2 days | 8 days | 1 | 81479 |  |  |  |  | Rochester
COMT | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
COMT | Result | 83301 | [NAME] Genotype | [NAME] Genotype | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
COMT | Result | 24215 | Reviewed by | Reviewed by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 703880d1605205470-how-to-reference-a-certain-sheet-in-an-dynamic-averageifs-function-sampleworkbook
Sheet: 5

Depth (ft) | Column A | Column B | Column C
0 | 301 | 326 | 351
5 | 302 | 327 | 352
10 | 303 | 328 | 353
15 | 304 | 329 | 354
20 | 305 | 330 | 355
25 | 306 | 331 | 356
30 | 307 | 332 | 357
35 | 308 | 333 | 358
40 | 309 | 334 | 359
45 | 310 | 335 | 360
50 | 311 | 336 | 361
55 | 312 | 337 | 362
60 | 313 | 338 | 363
65 | 314 | 339 | 364
70 | 315 | 340 | 365
75 | 316 | 341 | 366
80 | 317 | 342 | 367
85 | 318 | 343 | 368
90 | 319 | 344 | 369
95 | 320 | 345 | 370
100 | 321 | 346 | 371
105 | 322 | 347 | 372
110 | 323 | 348 | 373
115 | 324 | 349 | 374
120 | 325 | 350 | 375
Spreadsheet: 701218d1603629659-hyperlink-to-locate-multiple-common-max-value-hyperlink-sample
Sheet: Sheet1

30+ | 60+ | 90+ | 120+
0 | 0 | 0 | 0
9 | 1 | 10 | 4 |  | Category | [NAME]
6 | 0 | 0 | 0 |  | 30+
27 | 34 | 5 | 1 |  | 60+
1 | 3 | 0 | 5 |  | 90+ |  | Only looks up first [NAME] value. Can this be tweaked to locate both values when hyperlinked is clicked. Please suggest an alternative.
2 | 2 | 0 | 1 |  | 120+
4 | 5 | 3 | 9
0 | 0 | 0 | 0
1 | 0 | 10 | 6
Spreadsheet: 160562d1339111441-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: Claims

Announcement Number | Employee Announcements
1
2
3
4
5
6
7
Announcement Number | Manager [NAME]
1
2
3
4
5
6
7
Spreadsheet: 813723d1673957287-vlookup-not-producing-the-answer-im-looking-for-excel-check
Sheet: Input - TU

Input - TU
 |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  | 2023-01-31 00:00:00
 |  |  | 1
[NAME]
1 | [NAME]. Rate |  | 0.008541666666666666
22 |  |  | 0.01
6 |  |  | 0.008958333333333334
23 |  |  | 0.01
3 |  |  | 0.015
24 |  |  | 0.008333333333333333
 | Average Loan Size |  | 3000000
 |  |  | 3000000
 |  |  | 3000000
 | TU (GBP)
 | TU (Count)
TOTAL | Budgeted December | December |  |  |  |  |  |  |  |  | 5 |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  | 5
 | Split |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.15
 |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  | 1 |  |  |  |  |  |  |  | 0.15
 |  |  | 0
 |  |  |  | 0.7
TOTAL | Budgeted | September | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 74.01023884955356 |  |  |  |  |  |  |  |  |  |  |  | 75.8743001371925 |  |  |  |  |  |  |  |  |  |  |  | 301.585824130613
TOTAL | Sale & Run Off Year 5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 70.17250084797769 |  |  |  |  |  |  |  |  |  |  |  | 142.090049483335 |  |  |  |  |  |  |  |  |  |  |  | 145.8644141342644
TOTAL | Budgeted December | December |  |  |  |  |  |  |  |  | 46.51011516815163 |  |  |  | 312.8614477272174 |  |  |  |  |  |  |  |  |  |  |  | 320.7929355122466 |  |  |  |  |  |  |  |  |  |  |  | 345.0446287516825
TOTAL | Sale & Run Off Year 5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 140.3450016959554 |  |  |  |  |  |  |  |  |  |  |  | 214.0075981186925 |  |  |  |  |  |  |  |  |  |  |  | 289.983780481148
TOTAL |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  | #REF! |  |  | #REF! | 86221267.60709992 |  |  |  |  |  |  |  | 94874833.20553713 |  |  |  | 94874833.20553713 |  |  |  |  |  |  |  | 94874833.20553713 |  |  |  | 94874833.20553713
 |  |  |  |  | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
 | Total Number of Loans Written Per Year |  |  |  |  |  |  |  |  |  |  |  | 2014-12-01 00:00:00 | 2015-12-01 00:00:00 | 2016-12-01 00:00:00 | 2017-12-01 00:00:00 | 2018-12-01 00:00:00 | 2019-12-01 00:00:00 | 2020-12-01 00:00:00 | 2021-12-01 00:00:00 | 2022-12-01 00:00:00 | 2023-12-01 00:00:00
 | Accumulative Number of Loans Before W/O |  |  |  |  |  |  |  |  |  |  |  | 5000000 | 105000000 | 205000000 | 305000000 | 405000000 | 505000000 | 605000000 | 705000000 | 805000000 | 905000000
 | Accumulative Number of Loans After W/O |  |  |  | 16.83 | 50.985 | 70.5375 | 70.5375 | 70.5375 | 70.5375
 |  |  |  |  |  |  |  |  |  |  |  |  | 2015-09-01 00:00:00 | 2016-09-01 00:00:00 | 2017-09-01 00:00:00 | 2018-09-01 00:00:00 | 2019-09-01 00:00:00 | 2020-09-01 00:00:00 | 2021-09-01 00:00:00 | 2022-09-01 00:00:00 | 2023-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 25000000 | 50000000 | 150000000 | 200000000 | 275000000 | 325000000 | 400000000 | 450000000 | 500000000
Spreadsheet: 771801d1646854036-nested-ifs-with-index-function-query-sample-data
Sheet: Results

SupplierName | ControlName | Outcome
Supplier 1 | Control 1
Supplier 1 | Control 1
Supplier 1 | Control 1
Supplier 1 | Control 2
Supplier 1 | Control 2
Supplier 1 | Control 3
Supplier 1 | Control 3
Supplier 2 | Control 1
Supplier 2 | Control 1
Supplier 2 | Control 2