tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 2

 | December 20 | December 27 | January 3 | January 10 | January 17
Total Interest Rate* | 737320415 | 734549856 | 685071453 | 690578292 | 684708161
SDs and MSPs** | 621218071 | 619220188 | 570264153 | 573961277 | 568020528
Other | 116102345 | 115329668 | 114807299 | 116617015 | 116687633
Total Cross-Currency | 28024285 | 28274953 | 28682606 | 28768464 | 28376341
SDs and MSPs | 24276703 | 24495417 | 24902200 | 25006510 | 24659602
Other | 3747582 | 3779536 | 3780406 | 3761954 | 3716739
Total Credit | 17741854 | 17160679 | 17122903 | 17588412 | 17400549
SDs and MSPs | 13306870 | 12818317 | 12811947 | 13052358 | 12911817
Other | 4434984 | 4342362 | 4310956 | 4536054 | 4488732
Total FX**** | 62900000 | 62900000 | 62900000 | 62900000 | 62900000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 8840000 | 8840000 | 8840000 | 8840000 | 8840000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 3400000 | 3400000 | 3400000 | 3400000 | 3400000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 858226554 | 855125488 | 806016962 | 812075168 | 805625051
Weekly snapshot, gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. Because this table shows the aggregated notional values of swaps by participant, the totals on this table are twice those displayed on the "Gross Notional Outstanding by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 59166d1259633052-set-cell-to-take-value-from-most-recently-filled-in-column-duncar
Sheet: Sheet2

 |  |  |  | Oct | Nov | Dec | Jan
Program 1 | 100 | 0.3 | Program 1 | 10 | 15 |  | 30
Program 2 | 150 | 0.3333333333333333 | Program 2 | 15 | 30 |  | 50
Program 3 | 125 | 0.28 | Program 3 | 10 | 20 |  | 35
Spreadsheet: 274757d1383214028-merging-two-data-sets-with-different-organizational-qualities-data_set_results
Sheet: Sheet1

DATA SET A |  |  |  | VLOOKUP |  | DATA SET B
Company A | data | data | data |  |  | Contractor A Company A $500
Company B | data | data | data |  |  | Contractor A Company B $800
Company C | data | data | data |  |  | Contractor B Company A $600
 |  |  |  |  |  | Contractor B Company C $200
 |  |  |  |  |  | Contractor C Company B $100
 |  |  |  |  |  | Contractor C Company C $500
Spreadsheet: 752105d1634582764-reshaping-a-matrix-with-formulas-reshape_matrix
Sheet: Sheet1

 | Original Matrix:
 | 59 | 59 | 63 | 30 | 70 | 9
 | 40 | 6 | 45 | 75 | 92 | 1
 | 6 | 19 | 6 | 93 | 78 | 1
 | 89 | 100 | 30 | 44 | 9 | 9
 | 51 | 80 | 89 | 53 | 62 | 2
 | 81 | 9 | 33 | 39 | 16 | 8
 | 99 | 58 | 74 | 19 | 77 | 2
 | 41 | 66 | 51 | 73 | 7 | 7
 | Reshape to Matrix where MOD(columns_new,columns_old)=0 and MOD(rows_old,rows_new)=0
 | columns_old |  |  |  | columns_new |  | 12 |  | MOD
 | rows_old |  |  |  | rows_new |  | 4 |  | MOD
 | Reshaped Matrix: |  |  | Pattern to repeat: |  |  |  | equiv.
 | Reshape to Matrix where MOD(columns_new,columns_old)<>0 and MOD(rows_old,rows_new)<>0
 | e.g. take 5 × 4 matrix and turn into 10 × 2 matrix
 | 19 | 18 | 99 | 37 |  |  |  |  |  |  |  | 19 | 18 | 99 | 37
 | 100 | 23 | 79 | 15 |  |  |  |  |  |  |  | 100 | 23 | 79 | 15 |  | 18
 | 6 | 20 | 70 | 46 |  |  |  |  |  |  |  | 6 | 20 | 70 | 46 |  | 99
 | 24 | 2 | 90 | 12 |  |  |  |  |  |  |  | 24 | 2 | 90 | 12 |  | 37
 | 90 | 89 | 48 | 85 |  |  |  |  |  |  |  | 91 | 89 | 48 | 85 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 | columns_old |  |  |  | columns_new |  | 10 |  | MOD |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 | rows_old |  |  |  | rows_new |  | 2 |  | MOD |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | Reshaped Matrix: |  |  | Pattern to repeat: |  |  |  | equiv. |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
 | Should be: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
 | 19 | 18 | 99 | 37 | 100 | 23 | 79 | 15 | 6 | 20 |  |  |  |  |  |  | 89
 | 70 | 46 | 24 | 2 | 90 | 12 | 90 | 89 | 48 | 85 |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85
Check
 |  | 18 | 99 | 37 | 100 | 23 | 79 | 15 | 6 | 20 |  |  | 100 | 6 | 24 | 90 | 18 | 23 | 20 | 2 | 89
 | 70 | 46 | 24 | 2 | 90 | 12 | 90 | 89 | 48 | 85 |  | 99 | 79 | 70 | 90 | 48 | 37 | 15 | 46 | 12 | 85
 |  | 18 | 99 | 37 | 100 | 23 | 79 | 15 | 6 | 20 |  |  | 100 | 6 | 24 | 90 | 18 | 23 | 20 | 2 | 89
 | 70 | 46 | 24 | 2 | 90 | 12 | 90 | 89 | 48 | 85 |  | 99 | 79 | 70 | 90 | 48 | 37 | 15 | 46 | 12 | 85
 |  | 18 | 99 | 37 | 100 | 23 | 79 | 15 | 6 | 20 |  |  | 100 | 6 | 24 | 90 | 18 | 23 | 20 | 2 | 89
 | 70 | 46 | 24 | 2 | 90 | 12 | 90 | 89 | 48 | 85 |  | 99 | 79 | 70 | 90 | 48 | 37 | 15 | 46 | 12 | 85
Spreadsheet: 492327d1481039773-formula-to-copy-filtered-data-to-another-tab-example-with-table
Sheet: Output

Code | Type | Number |  |  |  |  |  |  |  |  | Criteria Table
 |  |  |  |  |  |  |  |  |  |  | Project
 |  |  |  |  |  |  |  |  |  |  | Major Project
 |  |  |  |  |  |  |  |  |  |  | MSA Small Project
 |  |  |  |  |  |  |  |  |  |  | MSA Standard Project
 |  |  |  |  |  |  |  |  |  |  | Programme
Spreadsheet: 773753d1648035734-formula-range-based-on-another-cell-value-test-demo-2
Sheet: Sheet1

 |  |  |  |  |  | POINT | SPEC |  |  | RESULT1 | RESULT2 | RESULT3...
 |  |  |  |  |  | 1 |  | 3.0 CAR |  | 1.1 | 1.6
 |  |  |  |  |  | 2 |  | 3.0 CAR |  | 1.5 | 1.4
 |  |  |  |  |  | 3 |  | 3.5 CAR |  | 2.5 | 1.3
 |  |  |  |  |  | 4 |  | 3.5 CAR |  | 2.1 | 2.2
 |  |  |  |  |  | 5 |  | 3.0 CAR |  | 1.5 | 1.3
 |  |  |  |  |  | 6 |  | 4.0 CAR |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 7 |  | 3.0 CAR |  | 2.5 | 1.3
 |  |  |  | 3 | 6
 |  |  |  |  |  | 8 |  | 3.0 CAR |  | 1.1 | 1.6
 |  |  |  |  |  | 9 |  | 3.0 CAR |  | 1.5 | 1.3
 |  |  |  |  |  | 10 |  | 4.0 CAR |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 11 |  | 3.0 CAR |  | 2.5 | 1.3
 |  |  |  | 9 | 11
 |  |  |  |  |  | 12 |  | 3.0 CAR |  | 1.1 | 1.6
 |  |  |  |  |  | 13 |  | 3.5 CAR |  | 2.5 | 1.3
 |  |  |  |  |  | 14 |  | 3.5 CAR |  | 2.1 | 2.2
 |  |  |  |  |  | 15 |  | 3.0 CAR |  | 1.5 | 1.3
 |  |  |  |  |  | 16 |  | 4.0 CAR |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 17 |  | 3.0 CAR |  | 2.5 | 1.3
 |  |  |  | 13 | 15
 |  |  |  |  |  | 1 |  | 3.0 HOME |  | 1.1 | 1.6
 |  |  |  |  |  | 2 |  | 3.0 HOME |  | 1.4 | 1.4
 |  |  |  |  |  | 3 |  | 3.5 HOME |  | 1.3 | 1.3
 |  |  |  |  |  | 4 |  | 3.5 HOME |  | 2.1 | 2.2
 |  |  |  |  |  | 5 |  | 3.0 HOME |  | 1.2 | 2.1
 |  |  |  |  |  | 6 |  | 4.0 HOME |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 7 |  | 3.0 HOME |  | 2.5 | 1.3
 |  |  |  | 1 | 5
 |  |  |  |  |  | 8 |  | 3.0 HOME |  | 1.1 | 1.6
 |  |  |  |  |  | 9 |  | 3.0 HOME |  | 1.5 | 1.3
 |  |  |  |  |  | 10 |  | 3.5 HOME |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 11 |  | 3.5 HOME |  | 2.5 | 1.3
 |  |  |  | 8 | 10
 |  |  |  |  |  | 12 |  | 3.5 HOME |  | 1.1 | 1.6
 |  |  |  |  |  | 13 |  | 3.5 HOME |  | 2.5 | 1.3
 |  |  |  |  |  | 14 |  | 3.5 HOME |  | 2.1 | 2.2
 |  |  |  |  |  | 15 |  | 3.5 HOME |  | 1.5 | 1.3
 |  |  |  |  |  | 16 |  | 3.5 HOME |  | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 17 |  | 3.5 HOME |  | 2.5 | 1.3
 |  |  |  | 12 | 15
Spreadsheet: 532411d1502274011-help-with-a-formula-for-populating-a-rota-with-names-blank-template-rota
Sheet: Rota

 |  |  | Sen. |  |  | Sen. |  |  | Sen. |  |  | Sen. |  |  | Sen. |  |  | Sen. |  |  | Sen.
 | Mon |  | Initial | [NAME] |  | Initial | Wed |  | Initial | Thurs |  | Initial | Fri |  | Initial | Sat |  | Initial | Sun |  | Initial
AM |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 8.15-3.15 |  |  | 8.15-3.15
 |  | 7.30-12 |  |  | 7.30-2.30 |  |  | 7.30-12 |  |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 8.15-3 |  |  | 8.15-3
 |  | 7.30-10 |  |  | 7.30-12 |  |  | 7.30-10 |  |  | 7.30-2.30 |  |  | 7.30-10 |  |  | 8.15-3 |  |  | 8.15-3
 |  | 7.30-10 |  |  | 7.30-10 |  |  | 7.30-10 |  |  | 7.30-12 |  |  | 7.30-10 |  |  | 8.15-1.45 |  |  | 8.15-1.45
Activities
PM |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30
 |  | 3-10 |  |  | 3-10 |  |  | 3-10 |  |  | 2.30-9 |  |  | 3-10 |  |  | 3-10 |  |  | 3-10
 |  | 2-9 |  |  | 2-9 |  |  | 2-9 |  |  | 2-9 |  |  | 2-9 |  |  | 2-9 |  |  | 2-9
 |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 3-9 |  |  | 3-9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4-10
 |  | 10-4 |  |  | 10-4 |  |  | 10-4 |  |  | 10-4 |  |  | 10-4
 |  | 11-3 |  |  |  |  |  | 10-3 |  |  | 11-3
 |  | 10-4 |  |  |  |  |  | 10-4 |  |  |  |  |  | 10-4 |  |  | 3-5 |  |  | 9-2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3-5 |  |  | 9-2
 |  | 8-11 |  |  |  |  |  |  |  |  | 8-11 |  |  |  |  |  | 9-2 |  |  | 9-2
 |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 5-9 |  |  | 3-9
 |  | 12-4 |  |  | 12-4 |  |  | 12-4 |  |  | 12-4 |  |  | 12-5
 |  | 12-4 |  |  | 12-4 |  |  | 12-4 |  |  | 12-4 |  |  | 12-5
W/N
S/I
CSV
[NAME]
Support Staff
[NAME]
Domestic
Training
Spreadsheet: 834314d1687648755-formula-to-average-shipment-weight-by-piece-dims_list_by_weight
Sheet: ppususr.dimslistif(jfkug>Sheet1

 | Finals for |  | Total Pcs |  | Total Wgt.
 | shipment "x" |  |  |  |  |  | Average Wgt per piece in Kg
AWBNO | # of pieces | WGHT | L | W | H
[PHONE] | 1 | 20 | 12 | 12 | 20
[PHONE] | 2 | 30 | 15 | 20 | 18
[PHONE] | 1 | 10 | 12 | 10 | 10
[PHONE] | 4 | 200 | 48 | 40 | 25
[PHONE] | 3 | 500 | 20 | 20 | 20 |  |  | Should be 500/5pcs=100
[PHONE] | 1 | 0 | 20 | 10 | 15 |  |  | I would like the 100 in H9 & H10
[PHONE] | 1 | 0 | 25 | 18 | 10
 | 1 | 350 | 48 | 40 | 40
 | 2 | 777 | 20 | 20 | 20 |  |  | should be 777/3pcs = 259
 | 1 | 0 | 30 | 30 | 30 |  |  | I would like the 259 in H13
 | This List gets pulled from another program and varies with the number of shipments
 | and sometimes lists all the weight together as shown above
 | Is there a formula to automate when it sees 0 in the weight column to combine these all and then
 | divide by total number of pcs to get the correct average weight per piece?
LHR |  |  | 17.515
Spreadsheet: 732949d1621334883-highlight-duplicate-text-in-multiple-columns-p_tracker
Sheet: Quant_Active_Fund_Growth_Option

ICICI Bank Ltd
Fortis Healthcare Ltd
Hindustan Copper Ltd
Stylam Industries Ltd
Tech Mahindra Ltd
Oracle Financial Services Software Ltd
Tata Steel Long Products Ltd
Deepak Fertilisers & Petrochemicals Corp Ltd
Vedanta Ltd
Infosys Ltd
Sun Pharmaceuticals Industries Ltd
J.B. Chemicals & Pharmaceuticals Ltd
Cadila Healthcare Ltd
Steel Authority Of India Ltd Shs Dematerialised
Thyrocare Technologies Ltd
Grasim Industries Ltd
General Insurance Corporation of India
ICICI Securities Ltd
Bharti Airtel Ltd
Bharat Petroleum Corp Ltd
Linde India Ltd
INEOS Styrolution India Ltd
Bharat Rasayan Ltd
Hindustan Petroleum Corp Ltd
Petronet LNG Ltd
Alembic Pharmaceuticals Ltd
ITC Ltd
L&T Technology Services Ltd
Anupam Rasayan India Ltd
IDFC First Bank Ltd
Nureca Ltd
Jubilant Pharmova Ltd
Axis Bank Ltd
Wipro Ltd
Canara Bank Shs Dematerialised
Oberoi Realty Ltd
PTC India Financial Services Ltd
Caplin Point Laboratories Ltd
GMM Pfaudler Ltd
Kansai Nerolac Paints Ltd
BASF India Ltd Shs Dematerialised
Aurobindo Pharma Ltd
AAVAS Financiers Ltd
Shriram City Union Finance Ltd
Welspun India Ltd
E I D Parry India Ltd
Procter & Gamble Health Ltd Shs Dematerialised
Rossari Biotech Ltd Ordinary Shares
Mastek Ltd
Aditya Birla Fashion and Retail Ltd
JSW Ispat Special Products Ltd.
Amara Raja Batteries Ltd
Dabur India Ltd Shs Dematerialised
Spreadsheet: 0cff6e9a-90c1-4c05-87d7-ed50e927d1a0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7790 | 53572 | Kristina | Mandt | GER | 0 | 01:00:14 | 00:01:37 | 01:44:41 | 00:01:30 | [NAME] | 1 | [NAME]
7790 | 57189 | Marlies | Groenewold | NED | 0 | 01:05:41 | 00:01:22 | 01:48:19 | 00:01:33 | 00:42:11 | 2 | 03:39:04
7790 | 66195 | Emilie | De Vries | NED | 0 | 01:09:48 | 00:01:37 | 01:58:36 | 00:01:49 | 00:38:32 | 3 | 03:50:21
7790 | 57187 | Anne | Hobbelt | NED | 0 | 01:04:48 | 00:01:10 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 799487d1665107067-if-then-and-greater-than-less-than-formula-blondielocks-example
Sheet: Sheet1

date | days | due
2022-01-01 00:00:00 | 0
2022-01-02 00:00:00
2022-01-15 00:00:00
2022-01-16 00:00:00
2022-01-31 00:00:00
2022-02-01 00:00:00
2022-02-15 00:00:00
2022-03-01 00:00:00
2022-03-15 00:00:00
Spreadsheet: 140653d1328836677-how-to-return-data-corresponding-to-one-value-to-another-worksheet-test-1-
Sheet: Summary Sheet

 | 11-2- | Type specific value in cell to the left.
 |  |  |  |  |  |  |  |  |  | Have all information related to 10-2- be copied to the space in the yellow.
Spreadsheet: tracy_geaccone__40441__OM EST - OPERATIONS - 2001 - 2002 REVISED FORMAT
Sheet: Orig '02 Plan Net

ORIGINAL '02 PLAN NET  O & M COSTS
(including Benefits & Payroll Taxes)
OPERATIONS
( $ In Thousands)
 |  |  |  |  |  |  |  |  |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Net |  | Gross O&M |  | Net |  | Net
 |  |  |  |  |  |  |  |  |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | % O(U) |  | 2002 |  | 2002
Department |  |  |  |  |  |  |  |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | 2000 Plan |  | Dec |  | Sum
NNG |  |  |  |  |  |  |  |  |  | 6774 |  | 7368 |  | 7233 |  | 7068 |  | 7066 |  | 7433 |  | 9008 |  | 8115 |  | 8453 |  | 8453 |  | 7612 |  |  |  | 8068
TW |  |  |  |  |  |  |  |  |  | 2166.403 |  | 2185.425 |  | 2144.461 |  | 2122.357 |  | 2151.378 |  | 2174.504 |  | 2148.327 |  | 2165.205 |  | 2156.355 |  | 2153.188 |  | 2122.55 |  |  |  | 2204.767
Citrus |  |  |  |  |  |  |  |  |  |  |  |  |  | 2670.165 |  | 2877.501 |  | 2846.096 |  | 2885.957 |  | 2956.525 |  | 2984.717 |  | 2956.854 |  | 2912.51 |  | 2878.492 |  |  |  | 2855.159
Northern Border Partners
EOTT (Co 1195) |  |  |  |  |  |  |  |  |  | 3074.9 |  | 3603.471 |  | 3275.955 |  | 3468.866 |  | 3515.904 |  | 3591.606 |  | 3552.738 |  | 3435.01 |  | 3424.314 |  | 3290.913 |  | 3212.154 |  |  |  | 3161.855
[NAME] |  |  |  |  |  |  |  |  |  | 133.29 |  | 135.337 |  | 135.337 |  | 135.337 |  | 135.337 |  | 135.337 |  | 135.337 |  | 135.337 |  | 135.337 |  | 135.337 |  | 135.337 |  |  |  | 135.337
Enron Construction Services
EAMR |  |  |  |  |  |  |  |  |  | 43.119 |  | 44.078 |  | 43.119 |  | 43.119 |  | 43.119 |  | 43.119 |  | 43.119 |  | 43.119 |  | 43.119 |  | 43.119 |  | 43.119 |  |  |  | 43.119
ETS
Other *
Total
* For companies outside of ETS
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Nationals

Washington Nationals | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Washington Nationals | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
Hoover, [NAME] | ML | ML | ML | ML | ML | ML |  | From Athletics | -1
Kimbrel, [NAME] | ML | ML | ML | ML | ML | ML |  | From Giants | -3.5
Lyles, Jordan | ML | ML | ML | ML | ML | ML |  | From Reds | -6
Martin, [NAME] | ML | ML | ML | ML | ML | ML
[NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
Brito, Javier | ML | ML | ML | ML | ML | ML |  | Chico, [NAME] | 0.4
Brown, Brooks | ML | ML | ML | ML | ML | ML |  | Izturis, Cesar | 0.2 | 0.2
Bumgarner, [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], Blaine | 0.1
Delany, [NAME] | ML | ML | ML | ML | ML | ML |  | Sisco, [NAME] | 0.4
Desme, Gregory | ML | ML | ML | ML | ML | ML |  | To Athletics | 0.5
Furbush, [NAME] | ML | ML | ML | ML | ML | ML |  | To Mariners | 1
[NAME], Mariano | ML | ML | ML | ML | ML | ML |  | To Padres |  | 0.5
Green, Nick | ML | ML | ML | ML | ML | ML
Hill, [NAME] | ML | ML | ML | ML | ML | ML
Jaso, [NAME] | ML | ML | ML | ML | ML | ML
Jimenez, Cesar | ML | ML | ML | ML | ML | ML
Kiker, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Larish, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Pino, Yohan | ML | ML | ML | ML | ML | ML
Swindle, R.J. | ML | ML | ML | ML | ML | ML
Wells, [NAME] | 12.6
Holliday, [NAME] | 12 | 12
Rivera, Mariano | 11.7 | 11.7
Blalock, Hank | 8.2 | 8.2 | 8.2
Looper, Braden | 5.3
Wang, [NAME] | 4.9 | A3
Lowry, [NAME] | 4.1
Rodriguez, [NAME] | 3.9 | 3.9
Tazawa, Junichi | 3.1 | 3.1 | 3.1 | 3.1
Wakefield, [NAME] | 3.1 | 3.1
[NAME], Stephen | 3 | A2 | A3
Markakis, Nick | 3 | A2 | A3
Rodriguez, [NAME] | 2.6
[NAME], [NAME] | 2.5 | A2 | A3
[NAME], [NAME] | 2.3 | A3
[NAME], [NAME] | 1.9 | A2 | A3
Pena, [NAME] | 1.3 | A2 | A3
Burgos, Ambiorix | 1.1 | A3
Littleton, [NAME] | 0.9 | A2 | A3
Tankersley, [NAME] | 0.8 | A2 | A3
Jimenez, Ubaldo | 0.7 | A1 | A2 | A3
O'Flaherty, [NAME] | 0.7 | A1 | A2 | A3
Smith, [NAME] | 0.7 | A1 | A2 | A3
Santiago, [NAME] | 0.5 | A
Bonifacio, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Hundley, Nick | 0.3 | 0.7 | A1 | A2 | A3
Upton, Justin | 0.3 | 0.7 | A1 | A2 | A3
Schoeneweis, Scott | 0.2 | 0.2
Spreadsheet: 50436d1249898450-of-subtotal-sample
Sheet: Test1

 | Test report
 | Phase Desc | (All)
 | Activity | (All)
 | Description | (All)
 | Resource Group | (All)
 | Country | (All)
 | Workforce | (All) |  |  |  |  |  | Now you can see the total year -1 value for stage 1 is 100% and for stage 2 is 100% but when I select the country field to USA or India in page filter the total is not coming to 100%. Is there any way to get the total to 100% however the page filter changes
 | Rate Type | (All)
 | OM ID | Opportunity Name | Status | Stage | Phase | Year - 1
 | 123456 | Project Ride | Capital Committee Review 1 | Stage 1 | PMO | 0.08377458112621407
 |  |  |  |  | Service Delivery | 0.6565801766974045 |  | means % of Subtotal for Year 1
 |  |  |  |  | Transition | 0.2596452421763811
 |  |  | OG Review 3 | Stage 2 | PMO | 0.08377458112621407
 |  |  |  |  | Service Delivery | 0.6565801766974045
 |  |  |  |  | Transition | 0.2596452421763811
 | Total |  |  |  |  | 2
 | Grand Total |  |  |  |  | 2
Spreadsheet: 730284d1619625234-adding-up-previous-month-book1
Sheet: Sheet1

Central London Forward | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00
Barnsbury | 14.2693109315185 | 32.96927548560896 | 46.45670636608536 | 52.64659010350206 | 52.64659010350206 | 52.64659010350206
Finsbury Park | 10.53547426626967 | 24.34223734581029 | 34.3004253509145 | 38.87060825180774 | 38.87060825180774 | 38.87060825180774
[NAME] | 18.964164185453 | 43.81674464766765 | 61.74177654898625 | 69.96824046505033 | 69.96824046505033 | 69.96824046505033
 | I want a formula to add this month and previously to the current month
 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00
Barnsbury
Spreadsheet: 195118d1353425417-text-help-maintenance-report-x4l
Sheet: X4L - Stockton

[NAME] Less - Stockton
Product | Issue | Part Req | Part Price | Status | Del Date | Fitting Date
Livestrong S-Series | [NAME] | [NAME] | 67.74 | Part On Order | Uk [NAME] | 2012-12-03 00:00:00
Cable Crossover | Cable Snapped | Cable | 40 | Fitted
Cable Crossover | Cable Snapped | Cable | 40 | Part Arrived | Stock | 2012-11-26 00:00:00
 |  |  | Fix Rate | Percentage Here
 |  | Total
Spreadsheet: 105426d1302785339-filtering-help-examplecase
Sheet: Sheet1

Raw Data |  |  |  |  |  |  |  | Output
group | value a | value b |  |  |  |  |  | group | value a | value b
a | 3 | 222 |  |  |  |  |  | a | 3 | 222
a | 5 | 223 |  |  |  |  |  | a | 5 | 223
a | 2 | 224 |  |  |  |  |  | a | 2 | 224
b | 1 | 225 |  |  |  |  |  | d | 3 | 234
b | 1 | 226 |  |  |  |  |  | d | 4 | 235
b | 4 | 227 |  |  |  |  |  | d | 5 | 236
b | 6 | 228 |  |  |  |  |  | d | 6 | 237
b | -2 | 229 |  |  |  |  |  | d | 7 | 238
c | 0 | 230
c | 12 | 231
c | 4 | 232
c | 8 | 233
d | 3 | 234
d | 4 | 235
d | 5 | 236
d | 6 | 237
d | 7 | 238
Spreadsheet: errol_mclaughlin_jr__10074__Bkrqs829
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request #829
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: | 2001-07-19 00:00:00
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [NAME] | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed
TRADE-TRACK-16 | TRADE-TRACK-16 | X |  |  | -A | CENTRAL | X | X | X | X |  | X | WTI/BBL/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
TRADE-TRACK-17 | TRADE-TRACK-17 | X |  |  | -B | WEST | X | X | X | X |  | X | WTI/BBL/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
TRADE-TRACK-18 | TRADE-TRACK-18 | X |  |  | -C | EAST | X | X | X | X |  | X | WTI/BBL/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
TRADE-TRACK-19 | TRADE-TRACK-19 | X |  |  | -D | TEXAS | X | X | X | X |  | X | WTI/BBL/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
TRADE-TRACK-20 | TRADE-TRACK-20 | X |  |  | -E | PRICE | X | X | X | X |  | X | WTI/BBL/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
[NAME] | [NAME] | X |  |  | -F | PRICE | X | X | X | X |  | X | WTI/BBL/USD | [NAME] | MTM | Trading Track | 2001-07-23 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.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
trohaue |  |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | ST
kkeiser |  |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | ST
plove |  |  |  |  |  |  |  |  |  |  |  |  | Master booklist |  | - | -
abike |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | ST
owinfre |  |  |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | Y | JB
dbaumba |  |  |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List |  | - | -
emclaug
 |  |  |  |  |  |  |  |  |  |  |  |  | Any questions, please contact :
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52465)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x57197)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x31462)