tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 599662d1543241715-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: Master

Date | [NAME] |  |  |  | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7
 | Sickcall and Med Documentation
 | Infection, Asepsis, & Sterile Techniques
 | Medication Administration
 | Injections
 | Pharmacology
 | Venipuncture
 | EENT Primary Care
 | Respiratory Primary Care
 | Abdominal Primary Care
 | Orthopedic Primary Care
 | Basic Wound Primary Care
 | Skin Disease Primary Care
 | Primary Care Pre-Examination Review |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Primary Care Exam |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Intro to Battlefield Medicine
 | Battlefield Communication/ Documentation
 | Casualty Movement
 | Combat Medical Aid Bag
 | Combat Casualty Assessment
 | Control Bleeding
 | Airway Management
 | [NAME] Trauma
 | Shock
 | Vascular Access
 | Fieldcraft 1 Pre-Examination Review |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Field Craft Exam |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Head Injuries with Traumatic Brain Injuries
 | Ocular Injuries
 | Burns
 | [NAME]
 | Musculoskeletal Trauma
 | [NAME] |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Field Craft 2 Exam |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] Training
 | Casualty Triage
 | Suicide Prevention
 | [NAME] and Geneva Conv.
 | Environmental Threat
 | Fieldcraft 3 Pre-Examination Review |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Field Craft Exam |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
Spreadsheet: 817768d1676434063-calculating-payment-due-dates-automatically-subscription-tracker-150223
Sheet: Interface

 | Service details |  |  | Billing period |  |  |  |  |  | Context
 | Subscription | Date commenced | Payment Next Due | QTY | Unit |  |  |  |  | 1 | The date as of me creating this is 14 Feb 23.
 | Spotify | 2019-12-18 00:00:00 |  | 4 | w |  |  |  |  | 2 | The cells that are highlighted orange are user input. (Column B, C, E, F)
 | ExpressVPN | 2022-04-19 00:00:00 |  | 3 | m |  |  |  |  | 3 | The cells that are white with orange text are automatic calculations. (Column D)
 | Hulu | 2021-07-21 00:00:00 |  | 1 | m |  |  |  |  | 4 | Column D (Payment Next Due) needs to update every time the previous due date has passed.
 | [NAME] | 2023-01-29 00:00:00 |  | 1 | w |  |  |  |  | 5 | Cell [NAME] is left blank to provide space for solution.
 | Amazon Prime | 2023-02-11 00:00:00 |  | 1 | d |  |  |  |  | 6 | Problem: How do I create the auto-calculations for column D? Thank you for your time.
 | MasterClass | 2023-02-12 00:00:00 |  | 2 | d
 | Tidal | 2023-02-13 00:00:00 |  | 3 | d
 | Apple Music | 2021-11-09 00:00:00 |  | 12 | m
 | HubSpot | 2022-08-16 00:00:00 |  | 1 | m
 | Zenefits | 2020-07-22 00:00:00 |  | 1 | m
 | Disney+ | 2023-01-06 00:00:00 |  | 1 | w
 | Audible | 2022-04-26 00:00:00 |  | 1 | d
 | GrandBox | 2021-11-11 00:00:00 |  | 3 | m
 | Kindle Direct | 2021-02-11 00:00:00 |  | 3 | m
 | Netflix | 2022-01-09 00:00:00 |  | 12 | m
 | [NAME]
Spreadsheet: 56183d1256273402-non-existing-date-to-0-example
Sheet: 10607

 | Vehicle service record
 | VEHICLE MAKE: | TRUCK. ISUZU NPR50 A | ID: | 10607
 | YEAR: | 2003 | REGO: | WZM-680 | Master |  | Service History
 | TEAM: | [NAME]
 | DATE: | 2005-01-01 00:00:00 | 2005-02-01 00:00:00
 | MILEAGE: | 26000 | 28000
 | COMMENTS
 | SERVICE:
 | Change oil
 | Lubricate chassis
 | Change oil filter
 | Change air filter
 | Change transmission fluid
 | Flush cooling system
 | Add antifreeze
 | Align wheels
 | Rotate tires
 | Replace tires
 | Adjust brakes
 | Tune engine
 | Other service
 | Other service
 |  |  |  |  |  |  |  | Double Click
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
ANALYSIS OF RESERVE ITEMS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-99 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 118674d1313870904-find-the-exact-p-n-in-a-multi-p-n-range-of-cells-book6
Sheet: Sheet1

P/N | SHELF | QTY |  | CODE | SHELF | TOTAL  QTY
AA | 1 | 1 |  | A | 2 | 0
AA | 2 | 2
AB | 3 | 3
AB | 2 | 4 |  | CODE | SHELF | TOTAL  QTY
BB | 1 | 5 |  | A | 2 | 52
BB | 2 | 6 |  |  |  | SHOULD BE 46
CC | 1 | 7 |  |  |  | cells: A9, A10, A14, A17 only
A, CA, D | 2 | 8
A, CA, DA | 2 | 9
EE | 2 | 10 |  | The P/N is a combination of the alphabeth letters
EE | 3 | 11 |  | They can in a length of 2-3-4 lettres
FF | 4 | 12 |  | Column A presents how the warehouse clerek build the list.
GG, A, BB | 2 | 13 |  | The table is only a short example of a very long list.
GG | 6 | 14 |  | Column A cannot be changed in order to present a single P/N per row.
HH | 7 | 15 |  | How can I fine the exact P/N A while skipping (leaving out) the AA, Ca and so on ?
JJ, KK, A | 2 | 16 |  | Obviously, FIND and SEARCH does not fit.
GG | 6 | 17
MM | 8 | 18
GG, NN, BB | 9 | 19
Spreadsheet: 95187d1294850121-refreshing-daily-stock-values-upon-opening-workbook-stocks
Sheet: Portfolio

Port. Value: | 33000
Cash Value: | 11467.19 | 0.347490606060606
ICF International (ICFI) |  | Under [NAME] (UA) |  | Value Line Inc (VALU) |  | Solar ETF (TAN) |  | Harmonic Inc (HLIT) |  | Gilead Sciences (GILD)
Last Trade: | 25.45 | Last Trade: | 54.45 | Last Trade: | 14.13 | Last Trade: | 7.75 | Last Trade: | 8.39 | Last Trade: | 37.01
Trade Time: | 3:30PM EST | Trade Time: | 3:31PM EST | Trade Time: | 2:38PM EST | Trade Time: | 3:31PM EST | Trade Time: | 3:31PM EST | Trade Time: | 3:31PM EST
Change: | Up 0.10 (0.39%) | Change: | Down 0.77 (1.39%) | Change: | Down 0.03 (0.21%) | Change: | Up 0.10 (1.31%) | Change: | Down 0.06 (0.76%) | Change: | Up 0.35 (0.95%)
Prev Close: | 25.35 | Prev Close: | 55.22 | Prev Close: | 14.16 | Prev Close: | 7.65 | Prev Close: | 8.45 | Prev Close: | 36.66
Open: | 25.44 | Open: | 55.91 | Open: | 14.13 | Open: | 7.8 | Open: | 8.45 | Open: | 36.75
Bid: | 25.36 x 300 | Bid: | 54.41 x 200 | Bid: | 14.10 x 200 | Bid: | 7.74 x 3700 | Bid: | 8.38 x 5400 | Bid: | 37.01 x 300
Ask: | 25.44 x 200 | Ask: | 54.45 x 200 | Ask: | 14.24 x 200 | Ask: | 7.75 x 4200 | Ask: | 8.39 x 5200 | Ask: | 37.02 x 4600
1y Target Est: | 31 | 1y Target Est: | 49.11 | 1y Target Est: | N/A | NAV¹: | 8 | 1y Target Est: | 8.8 | 1y Target Est: | 44.67
Beta: | 0.5528580936115132 | Beta: | 1.582092203260316 | Beta: | 0.5169347896012666 | Beta: | 1.967737332946396 | Beta: | -0.1430760779240827 | Beta: | -0.06380137095477982
Shares: | 100 | Shares: | 86 | Shares: | 47 | Shares: | 200 | Shares: | 1000 | Shares: | 100
Current Value: | 2545 | Current Value: | 4682.7 | Current Value: | 664.11 | Current Value: | 1550 | Current Value: | 8390 | Current Value: | 3701
$/day: | 10 | $/day: | -66.22000000000025 | $/day: | -1.409999999999968 | $/day: | 20 | $/day: | -60 | $/day: | 35.00000000000045
Weight: | 0.07712121212121212 | Weight: | 0.1419 | Weight: | 0.02012454545454545 | Weight: | 0.04696969696969697 | Weight: | 0.2542424242424243 | Weight: | 0.1121515151515152
Dow Jones Industrial Average (DJI) |  | Standards & Poors 500 (GSPC)
Index Value: | 11673.47 | Index Value: | 1274.22
Trade Time: | 3:46PM EST | Trade Time: | 3:46PM EST
Change: | Up 36.02 (0.31%) | Change: | Up 4.47 (0.35%)
Today's Change: | -62.62999999999977
 | 537.6
Spreadsheet: 702860d1604577399-pick-up-sales-data-for-different-periods-based-on-customer-account-start-date-customer-sales-data
Sheet: Sheet1

Account Number | Date account set up | Month account set up | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 |  | Sales in 0-3 months | Sales in 3-6 months | Sales after 6 months
1667379 | 2020-01-03 00:00:00 | Jan2020 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1667376 | 2020-01-06 00:00:00 | Jan2020 | 489.99 | 46.48 | 321.23 | 1013.37 | 0 | 1163.42 | 1316.19 | 575.77 | 154.85 | 0 | 0 | 0
1668465 | 2020-02-13 00:00:00 | Feb2020 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 343.21 | 58.58 | 0 | 0
1668467 | 2020-02-13 00:00:00 | Feb2020 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1669454 | 2020-03-12 00:00:00 | Mar2020 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1669456 | 2020-03-12 00:00:00 | Mar2020 | 0 | 0 | 0 | 629.89 | 360.9 | 548.5 | 616.15 | 0 | 628.15 | 1048.96 | 0 | 0
1669455 | 2020-03-12 00:00:00 | Mar2020 | 0 | 0 | 0 | 1246.85 | 12541.21 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1669506 | 2020-03-12 00:00:00 | Mar2020 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1669457 | 2020-03-13 00:00:00 | Mar2020 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 237.13 | 0 | 0
1669466 | 2020-03-13 00:00:00 | Mar2020 | 0 | 0 | 0 | 0 | 0 | 348.01 | 0 | 0 | 0 | 0 | 0 | 0
1669471 | 2020-03-13 00:00:00 | Mar2020 | 0 | 0 | 0 | 0 | 0 | 212.3 | 387.76 | 301.53 | 0 | 1099.01 | 0 | 0
1669520 | 2020-03-23 00:00:00 | Mar2020 | 0 | 0 | 0 | 27971.1 | 0 | 435.24 | 0 | 0 | 447 | 0 | 0 | 0
1669632 | 2020-04-01 00:00:00 | Apr2020 | 0 | 0 | 0 | 361.03 | 4472.39 | 11218.09 | 9329.1 | 11671 | 23169.24 | 9692.33 | 0 | 0
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: August

 |  | 2022-08-01 00:00:00 | 2022-08-02 00:00:00 | 2022-08-03 00:00:00 | 2022-08-04 00:00:00 | 2022-08-05 00:00:00 | 2022-08-06 00:00:00
 |  | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 | 2022-08-12 00:00:00 | 2022-08-13 00:00:00
 |  | 2022-08-15 00:00:00 | 2022-08-16 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-08-19 00:00:00 | 2022-08-20 00:00:00
 |  | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00 | 2022-08-26 00:00:00 | 2022-08-27 00:00:00
 |  | 2022-08-29 00:00:00 | 2022-08-30 00:00:00 | 2022-08-31 00:00:00 | 2022-09-01 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00
 |  | 2022-09-05 00:00:00 | Notes
Spreadsheet: 767830d1644666117-what-if-analysis-to-calculate-the-effect-of-new-pricing-example-calculation-update
Sheet: Desired Result

 |  |  |  |  |  |  |  |  | Product 1 |  | Product 2 |  | Product 3 |  | Product 4 |  | Sum of Quantity | Sum of Amount
Org. | Product 1 | Product 2 | Product 3 | Product 4 | Last Order # | Last Order Date | # Orders 2021 | Account | Quantity | Amount | Quantity | Amount | Quantity | Amount | Quantity | Amount |  |  | Average Price
Reseller 1 | 28.95 |  | 49.95 |  | 10 | 2021-12-01 00:00:00 |  | AAA | 10 |  |  |  | 10
Reseller 2 |  |  |  | 49.95 | 20 | 2021-04-30 00:00:00 |  | BBB | 20 |  |  |  |  |  | 15
Reseller 3 | 26.95 |  |  |  | 100 | 04/05/2021 |  | CCC | 949
Distributor 1 | 19.7 | 20 | 23.4 |  | 1500 | 07/09/2021 |  | DDD | 29000 |  | 9600 |  | 45000
Distributor 2 |  | 20 |  | 30 | 10 | 2021-08-03 00:00:00 |  | EEE | 0 |  | 1200 |  |  |  | 5000
Distributor 3 | 20 | 19.7 | 23.4 | 23.05 | 12 | 10/19/2021 |  | FFF | 2800 |  | 162000 |  | 48000 |  | 125000
New pricing from Current Sales based on org type, product, and order quantity in Pricing Schedule
Updated calculation
Spreadsheet: 869420d1715985205-vllook-up-or-a-similar-function-to-look-up-a-date-range-vllook-up-or-a-similar-function-to-look-up-a-date-range-v-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-20 00:00:00 | 2024-05-27 00:00:00 | 2024-06-03 00:00:00 | 2024-06-10 00:00:00 | 2024-06-17 00:00:00 | 2024-06-24 00:00:00 | 2024-07-01 00:00:00 | 2024-07-08 00:00:00 | 2024-07-15 00:00:00 | 2024-07-22 00:00:00 | 2024-07-29 00:00:00 | 2024-08-05 00:00:00 | 2024-08-12 00:00:00
 |  |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6
 |  | Billing Amount | Payment terms | Days | Billing date | Billing date | Billing date | Billing date | Billing date | Billing date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date
 | A | 15000 |  | 7 | 2024-04-22 00:00:00
 | B | 75000 |  | 35 | 2024-04-30 00:00:00 |  |  |  |  |  | 2024-05-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 75000 | 0 | 0 | 0 | 0 | 0 | 0
 | C | 12500 |  | 35 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 0 | 0 | 0 | 0 | 0
 | D | 7000 |  | 35 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 7000 | 0 | 0 | 0 | 0 | 0 | 0
 | E | 75000 |  | 21 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F | 12500 |  | 21 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | G | 7000 |  | 21 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | H | 12000 |  | 21 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | I | 12500 |  | 35 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 0 | 0 | 0 | 0 | 0
 | J | 13000 |  | 14 | 2024-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 13000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | =MATCH(1,--ISNUMBER((MATCH($L$6:$V$6,SEQUENCE(W$4-W$3+1,,W$3),0))),0)
Spreadsheet: 674229d1587727521-n-a-error-when-using-format-control-with-index-match-client-list
Sheet: Client Data

 |  |  | Products |  |  |  |  | Display
Client | ACV | Renwal Date | Product Reviews | Brand Reviews | Dealership Reviews | AAO | Experiences | URL | Product Reviews | Brand Reviews | Dealership Reviews | AAO | Experiences | Stakeholders | Project?
Company 1 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 2 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 3
Company 4 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 5 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 6 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 7 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 8 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 9 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 10 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 11 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 12 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 13a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 0
Asia | - | 20 | 20
Europe | - | 551235 | 551235
North America | - | 566960 | 566960
Other | 0 | 0
Index
Asia | - | 118780 | 118780
Europe | 876982 | 2548228 | 3425210
North America | 1294486 | 2312423 | 3606909
Other | 19682 | 260622 | 280304
Other | 0
Exotic | - | 55192 | 55192
Swaptions | - | 542503 | 542503
Total Return Swap | - | 284 | 284
TOTAL
Spreadsheet: 831512d1685692346-query-for-using-if-in-data-validation-sample-144-aligw
Sheet: Sheet1

BUY / SELL | AMOUNT | QTY | RATE | SYMBOL | NAME | DATE
BUY | 300 | 83549.18 | 29.92 | HDFC_BALA_ADV_125H1OT | HDFC BALANCED ADV FUND(IDCW) | 2023-04-25 00:00:00
BUY | 560 | 2837.19 | 22.21 | HDFC_BALA_ADV_125H1OT | HDFC BALANCED ADV FUND(IDCW) | 2020-09-03 00:00:00
SELL | -400 | 16802.49 | 29.76 | HDFC_BALA_ADV_125H1OT | HDFC BALANCED ADV FUND(IDCW) | 2023-04-26 00:00:00
Spreadsheet: e1bd90a3-97bf-48c3-95d3-bf5cc2ab4ac7
Sheet: 31

Uke: | 31 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: errol_mclaughlin_jr__10839__BOOKREQUESTNG-X-OPTY
Sheet: Sheet1

From: | Risk Management -Controls |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Requestor:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
NG-X-OPT-NG | NG-X-OPT-NG |  |  | X | )B |  |  |  |  |  |  | X | USD | [NAME] | MTM/ACCRUAL | [NAME] | 2001-10-24 00:00:00
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
 |  |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC
Access List | Administrator* |  |  |  |  |  |  |  |  |  |  |  | Hierarchy
trohaue |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP
emclaug |  |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS
molney |  |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA
[NAME]
kloibl |  |  |  |  |  |  |  |  |  |  |  |  | PORTFOLIO NAME |  | Added (Y/N) | Processors ID
 |  |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-CREDIT
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-BU
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-CM
 |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNTING USD
 |  |  |  |  |  |  |  |  |  |  |  | IF: | GDI
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GD-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Index
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Gas
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GAS III & IV
Spreadsheet: 22944d1212146634-how-to-identify-extra-items-and-duplicate-respectively-vlookup
Sheet: Sheet1

LATEST |  |  | BOSS SEND |  |  | New in BOSS Sheet and not in your latest Sheet |  | Available in your latest sheet but NOT in Boss Sheet
ID | Name |  | ID | Name
147 | [NAME] |  | 123 | harish |  | NEW in Boss Send |  | New in LATEST
789 | jhon |  | 456 | bikash |  | bikash |  | jhon
258 | partho |  | 789 | jhon |  | jhon |  | New in LATEST
456 | bikash |  | 312 | [NAME] |  | NEW in Boss Send |  | bikash
369 | sumit |  | 645 | [NAME] |  | NEW in Boss Send |  | New in LATEST
159 | kidman |  | 978 | [NAME] |  | [NAME] |  | New in LATEST
213 | [NAME] |  | 213 | [NAME] |  | [NAME] |  | [NAME]
357 | rose |  | 546 | brono |  | brono |  | New in LATEST
258 | [NAME] |  | 879 | rhohan |  | rhohan |  | New in LATEST
879 | rhohan
546 | brono
978 | [NAME]
Spreadsheet: 4f1e1f8d-28cb-48ce-8eca-fd0538e0561c
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
CTCP | Test | CTCP | Circulating Tumor Cells (CTC) for Prostate Cancer by CellSearch, Blood | Circulating Tumor Cells, Prostate | CellSearch System | [NAME] Cell Collection Kit (Supply T630) |  |  | 7.5 | mL | [NAME] must be shipped immediately to ensure processing can be completed within 96 hours of draw. Send specimen Monday through Friday only and not the day before a holiday.   Container/Tube: Circulating Tumor Cell Collection Kit (Supply T630) containing CellSave tubes [NAME]: 15 mL in 2 CellSaves tubes each containing 7.5 mL Collection Instructions: Send specimen on same day of draw. Additional Information: Date and time of draw are required. Forms: If not ordering electronically, submit a Pathology/Cytology Request Form (Supply T246) with the specimen. | 7.5 mL | Hemolysis	Mild reject; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	[NAME] drawn in a tube other than CellSave tube or specimen submitted for reasons other than monitoring metastatic prostate carcinoma | An interpretive report will be provided. | Monday through Friday, Sunday | 4 days | 5 days |  | Profile |  |  |  |  | Rochester
CTCP | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 4 days
CTCP | Result | 50979 | [NAME] | [NAME] | Alphanumeric
CTCP | Result | 50980 | [NAME] | [NAME] | Alphanumeric
CTCP | Result | 50981 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
CTCP | Result | 50982 | Order Date | Order Date | Alphanumeric
CTCP | Result | 50983 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68123-9 | Circulating tumor cells.prostate:NCnc:Pt:[NAME]:Qn:
CTCP | Result | 50984 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59465-5
CTCP | Result | 50985 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
CTCP | Result | 50986 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
CTCP | Result | 50987 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CTCP | Result | 50988 | Reviewed By | Reviewed By | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CTCP | Result | 50989 | Release Date | Release Date | Alphanumeric
CTCP | Billing Component | CTCP |  | CELL ENUMERATION PHYS INTERP |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86153
CTCP | Billing Component | CTCP |  | CELL ENUMERATION & ID |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86152