tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683516d1592805324-create-table-from-two-sources-table-requirements-vb
Sheet: Table

 |  |  |  |  |  |  |  |  |  |  |  | Output Required - Extending model
Table 1 | Country | Model | Type | Cost | Sell |  |  |  |  |  | Extended Tables | Country | Model | Type | Cost | Sell
 | Australia | Apple | Fuji | 1000 | 1200 |  |  | When an item is added in Example 1 Models, the table extends a single line for each country with the new item |  |  |  | Australia | Apple | Fuji | 1000 | 1200
 | Australia | Apple | Pink Lady | 900 | 1150 |  |  |  |  |  |  | Australia | Apple | Pink Lady | 900 | 1150
 | United States | Apple | Fuji | 800 | 1100 |  |  |  |  |  |  | Australia | Orange | [NAME] | 600 | 850 | New ITEM
 | United States | Apple | Pink Lady | 700 | 1050 |  |  |  |  |  |  | United States | Apple | Fuji | 800 | 1100
 | Samoa | Apple | Fuji | 600 | 1000 |  |  |  |  |  |  | United States | Apple | Pink Lady | 700 | 1050
 | Samoa | Apple | Pink Lady | 500 | 950 |  |  |  |  |  |  | United States | Orange | [NAME] | 600 | 850 | New ITEM
 | Fiji | Apple | Fuji | 400 | 900 |  |  |  |  |  |  | Samoa | Apple | Fuji | 600 | 1000
 | Fiji | Apple | Pink Lady | 300 | 850 |  |  |  |  |  |  | Samoa | Apple | Pink Lady | 500 | 950
 | France | Apple | Fuji | 200 | 800 |  |  |  |  |  |  | Samoa | Orange | [NAME] | 600 | 850 | New ITEM
 | France | Apple | Pink Lady | 100 | 750 |  |  |  |  |  |  | Fiji | Apple | Fuji | 400 | 900
 |  |  |  |  |  |  |  |  |  |  |  | Fiji | Apple | Pink Lady | 300 | 850
 |  |  |  |  |  |  |  |  |  |  |  | Fiji | Orange | [NAME] | 600 | 850 | New ITEM
 |  |  |  |  |  |  |  |  |  |  |  | France | Apple | Fuji | 200 | 800
 |  |  |  |  |  |  |  |  |  |  |  | France | Apple | Pink Lady | 100 | 750
 |  |  |  |  |  |  |  |  |  |  |  | France | Orange | [NAME] | 600 | 850 | New ITEM
 |  |  |  |  |  |  |  |  |  |  |  | New Guinea | Apple | Fuji | 200 | 800 |  | New Country
 |  |  |  |  |  |  |  |  |  |  |  | New Guinea | Apple | Pink Lady | 100 | 750 |  | New Country
 |  |  |  |  |  |  |  |  |  |  |  | New Guinea | Orange | [NAME] | 600 | 850 | New ITEM | New Country
 |  |  |  |  |  |  |  |  |  |  |  | NEW COUNTRY
 |  |  |  |  |  |  |  |  |  |  |  | NEW COUNTRY
 |  |  |  |  |  |  |  |  |  |  |  | NEW COUNTRY
Spreadsheet: 740808d1626604145-alternative-ways-to-calculate-circular-references-circular-reference-group
Sheet: Sheet4

 | 1437627954 | 3153853241 | 6978221145 | 3725285302 | 9837203502 | 5617674665 | 8223171350 | 2008564781 | 7704971773
169 | 231 | 894 | 835 | 838 | 156 | 504 | 668 | 810 | 872
 |  |  |  |  |  |  |  |  | 4365762383
173237705 | 169
1437627954 | 231
3153853241 | 894
6978221145 | 835
3725285302 | 838
9837203502 | 156
5617674665 | 504
8223171350 | 668
2008564781 | 810
7704971773 | 872
Spreadsheet: 202842d1356754898-sorting-a-master-list-of-names-into-proper-teams-help
Sheet: Teams

XL
The Spreadsheet
YOUN
Bond, [NAME]
GASK
[NAME]
FEUI
The Mexico Mystics
DLEW
That [NAME]
[NAME]
Cherokee Tomahawk
MCK
Team McKayla
BIRD
Big D
PW
Pink Wookies
[NAME]
Dallas Birds of Prey
KOBE
This is Kobe's Team
Spreadsheet: 815249d1674833144-retrieve-value-from-cell-above-test2701
Sheet: Sheet1

Part2 | QtyOS | Stock | QtyAv | Av | StockAv | Fulfil
Part1 | 25 | 50
Part1 | 25 | 50
Spreadsheet: 149361d1333879840-help-with-pivot-tables-multiple-chart-from-one-pivot-table_jpr73
Sheet: Data

City | Supp | App | %
Leeds | 20 | 163
[NAME] | 15 | 176
Liverpool | 19 | 189
London | 32 | 250
Spreadsheet: 790514d1659749836-cumipmt-and-cumprinc-formulas-need-help-loan-calculation
Sheet: List1

 | Calculation | From month | Till month | Interest rate | Loan amount | Interest | Principal | Repaid amount | Monthly payment
 | Year 1 - 3 | 1 | 36 | 0.095 | 8400000
 | Year 4 - 6 | 37 | 60 | 0.075
 | Year 6 and more | 61 | 180 | 0.05
Spreadsheet: 888325d1738827978-distinct-count-with-multiple-criteria-powerpivot-measure
Sheet: Sheet1

ContactID | Name | Ref# | Year-Quarter | Year-Month | Within 3 days
1386123 | [NAME] | 10340901 | 2024-4Q | 2024/11 | 1 |  |  |  |  | Column Labels
1386123 | [NAME] | 10340903 | 2024-4Q | 2024/11 | 1 |  |  |  | Row Labels | 2024-4Q |  | Measure
1043300 | [NAME] | 10340620 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] |  |  | 1
1359798 | [NAME] | 10341301 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] |  |  | 3
1359798 | [NAME] | 10341815 | 2024-4Q | 2024/11 | 1 |  |  |  | Fanny |  |  | 0
1359798 | [NAME] | 10341819 | 2024-4Q | 2024/11 | 0 |  |  |  | George |  |  | 1
1422173 | [NAME] | 10341334 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] |  |  | 0
1422173 | [NAME] | 10341814 | 2024-4Q | 2024/11 | 0 |  |  |  | Kelly |  |  | 0
1417558 | Fanny | 10340506 | 2024-4Q | 2024/11 | 0 |  |  |  | [NAME] |  |  | 2
1427137 | Fanny | 10341574 | 2024-4Q | 2024/11 | 0 |  |  |  | [NAME] |  |  | 3
1032860 | George | 10340483 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] |  |  | 3
1032860 | George | 10341714 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] |  |  | 2
1053487 | [NAME] | 10339831 | 2024-4Q | 2024/11 | 0 |  |  |  | Shelly |  |  | 2
1388526 | Kelly | 10340211 | 2024-4Q | 2024/11 | 0 |  |  |  | [NAME] |  |  | 1
1388526 | Kelly | 10341542 | 2024-4Q | 2024/11 | 0 |  |  |  | Grand Total
1000499 | [NAME] | 10341582 | 2024-4Q | 2024/11 | 1
1032874 | [NAME] | 10340323 | 2024-4Q | 2024/11 | 0
1379008 | [NAME] | 10341578 | 2024-4Q | 2024/11 | 1
1395771 | [NAME] | 10340963 | 2024-4Q | 2024/11 | 1
1395771 | [NAME] | 10341067 | 2024-4Q | 2024/11 | 1
1403510 | [NAME] | 10341732 | 2024-4Q | 2024/11 | 1
1423740 | [NAME] | 10340357 | 2024-4Q | 2024/11 | 1
1429002 | [NAME] | 10340358 | 2024-4Q | 2024/11 | 0
1046933 | [NAME] | 10341055 | 2024-4Q | 2024/11 | 1
1046933 | [NAME] | 10341132 | 2024-4Q | 2024/12 | 1
1358709 | [NAME] | 10342012 | 2024-4Q | 2024/11 | 0
1391956 | [NAME] | 10341623 | 2024-4Q | 2024/11 | 1
1365420 | [NAME] | 10339878 | 2024-4Q | 2024/11 | 1
1365420 | [NAME] | 10340129 | 2024-4Q | 2024/11 | 1
1365420 | [NAME] | 10340585 | 2024-4Q | 2024/12 | 1
1365420 | [NAME] | 10341904 | 2024-4Q | 2024/12 | 1
1397903 | Shelly | 10341780 | 2024-4Q | 2024/11 | 1 |  |  |  | distictcount [ContactID] for each [Year-Month] where [Within 3 days] =1
1429685 | Shelly | 10342049 | 2024-4Q | 2024/12 | 1
1398005 | [NAME] | 10341192 | 2024-4Q | 2024/11 | 1
1398005 | [NAME] | 10341193 | 2024-4Q | 2024/11 | 1
Spreadsheet: 8daac8c1-1fc1-411a-be76-85fb3eaaefc9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Not Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: July 29, 2014 (7:19 pm)
Period | Value
Jan-2008 | 44
Feb-2008 | 48
Mar-2008 | 49
Apr-2008 | 49
May-2008 | 49
Jun-2008 | 45
Jul-2008 | 43
Aug-2008 | 38
Sep-2008 | 35
Oct-2008 | 32
Nov-2008 | 27
Dec-2008 | 26
Jan-2009 | 24
Feb-2009 | 29
Mar-2009 | 31
Apr-2009 | 32
May-2009 | 34
Jun-2009 | 37
Jul-2009 | 38
Aug-2009 | 36
Sep-2009 | 30
Oct-2009 | 33
Nov-2009 | 26
Dec-2009 | 24
[NAME] | 24
[NAME] | 27
Mar-2010 | 36
Apr-2010 | 41
[NAME] | 26
[NAME] | 28
[NAME] | 26
Aug-2010 | 23
Sep-2010 | 25
Oct-2010 | 23
Nov-2010 | 20
Dec-2010 | 23
Jan-2011 | 21
Feb-2011 | 22
Mar-2011 | 28
Apr-2011 | 30
May-2011 | 28
Jun-2011 | 28
Jul-2011 | 27
Aug-2011 | 25
Sep-2011 | 24
Oct-2011 | 25
Nov-2011 | 23
Dec-2011 | 24
Jan-2012 | 23
Feb-2012 | 30
Mar-2012 | 34
Apr-2012 | 34
May-2012 | 35
Jun-2012 | 34
Jul-2012 | 33
Aug-2012 | 31
Sep-2012 | 30
Oct-2012 | 29
Nov-2012 | 28
Dec-2012 | 28
Spreadsheet: 160602d1339136213-finding-player-and-avg-top-3-scores-copy-of-ringer-percent-experiment3
Sheet: Sheet1

card # | Last Name | First Name | date | cat | sanction # | shoes | ringers | % | W | L | P | Hi Game
614016 |  |  |  |  |  |  |  |  | 4 | 1 | 1 | 56
614016 |  |  |  |  |  |  |  |  | 5 | 0 | 1 | 54
614111 | Smith | [NAME] | jan 1 2012 | m | 44-44-66 | 150 | 70 | 15 | 2 | 3 | 4 | 22
614111 | Smith | [NAME] | jan 2 2012 | m | 44-44-67 | 180 | 84 | 47 | 1 | 5 | 0 | 50
614112 |  |  |  |  |  |  |  |  | 3 | 1 | 2 | 44
614016 |  |  |  |  |  |  |  | 11 | 3 | 2 | 3 | 15
614111 | Smith | [NAME] | jan 3 2012 | m | 44-44-68 | 200 | 98 | 49 | 5 | 0 | 1 | 55
614112
614016
614111 | Smith | [NAME] | jan 4 2012 | m | 44-44-69 | 210 | 99 | 47
614112 |  |  |  |  |  |  |  | 59
614016 |  |  |  |  |  |  |  | 11
614111 | Smith | [NAME] | jan 5 2012 | m | 44-44-70 | 250 | 123 | 49
614112 |  |  |  |  |  |  |  | 47
614016 |  |  |  |  |  |  |  | 11
614111 | Smith | [NAME] | jan 6 2012 | m | 44-44-71 | 260 | 149 | 57
614016 |  |  |  |  |  |  |  |  | 4 | 0 | 1 | 66
614111 | Smith | [NAME] | jan 7 2012 | m | 44-44-72 | 244 | 100 | 43 | 3 | 2 | 2 | 45
614112
614016
 |  |  |  |  |  |  |  | 51.66666666666666 |  | <- average of 3 largest number
 |  |  |  |  |  |  |  |  |  | for checking only
 |  |  |  |  |  |  |  | compare to sheet2
Spreadsheet: 81257d1281497129-organizing-data-by-time-on-a-different-sheet-tournament-software-template
Sheet: Alpha List - Day 1

Last Name | First Name | Tee Time | Course
Spreadsheet: daren_farmer__5930__hpl0609
Sheet: Sheet1

HPLN0609.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 09, 2000
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-09 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 40 | 40
Enron (FM) |  | HPL - Texoma |  | HPL | 20 | 20
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 5 | 5
Enron (S) |  | Oasis Sealy |  | ENA | 20 | 0
Enron (ES) |  | Reklaw |  | ENA | 20 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Delhi TOG #3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 104670d1302184685-a-countif-formula-to-pull-actual-value-countif-help
Sheet: Sheet1

Department | Complaint
FINANCIAL_SERVICES | ASSISTANCE |  |  |  |  |  |  |  |  |  |  | REWARDS |  | ACCOUNT CLOSED/SETTLED
FINANCIAL_SERVICES | ASSISTANCE | Top 10 Departments |  |  |  |  |  |  |  |  |  | ATM |  | ASSISTANCE
FOREX | ARRANGEMENT |  | Department | Complaint Type |  |  |  |  |  |  |  | AVAF_ADMIN |  | ARRANGEMENT
MARKETING | DECLINE | EG | Financial Services | ASSISTANCE |  |  |  |  |  |  |  | CREDITCARD |  | ATTITUDE
ATM | DECLINE | 1 |  |  |  |  |  |  |  |  |  | FINANCIAL_SERVICES |  | BUSINESS HOURS
MARKETING | DECLINE | 2 |  |  |  |  |  |  |  |  |  | FOREX |  | [NAME] / KNOWLEDGE
FINANCIAL_SERVICES | ASSISTANCE | 3 |  |  |  |  |  |  |  |  |  | MARKETING |  | DECLINE
 |  | 4 |  |  |  |  |  |  |  |  |  | PERSONAL_LOANS |  | CHARGES
 |  | 5 |  |  |  |  |  |  |  |  |  | STOP_CARD_TRUST_DEP_MERCHANTS |  | DEBT COUNSELLING
 |  | 6 |  |  |  |  |  |  |  |  |  | NAC_VIRGIN_MONEY |  | DEBIT ORDER RELATED
 |  | 7 |  |  |  |  |  |  |  |  |  | BRANCHES |  | FICA
 |  | 8 |  |  |  |  |  |  |  |  |  | BUSINESS_SML |  | INCORRECT INFO
 |  | 9 |  |  |  |  |  |  |  |  |  |  |  | INTEREST RATE
 |  | 10 |  |  |  |  |  |  |  |  |  |  |  | INSTRUCTIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ITC-RELATED
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LACK IN PROCESS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | POS PURCHASE
 |  |  |  |  |  |  |  |  |  |  |  |  |  | REPOSSESSED
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SET-OFF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SL AGREEMENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SYSTEM RELATED
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DELAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3RD PARTY
Spreadsheet: 61889d1262797541-extended-unique-filter-help-filtering-unique-values
Sheet: Sheet1

B | BLUE | 2 | 30
R | RED | 4 | 20
G | GREEN | 6 | 5
R | RED | 4 | 25
B | BLUE | 2 | 40
Y | YELLOW | 8 | 20
G | GREEN | 6 | 10
P | PURPLE | 10 | 35
B | BLUE | 2 | 10
 | BLUE
 | RED
 | GREEN
 | BLUE
 | YELLOW
 | PURPLE
I need to bring the cell values down to the second box.
B14:B19 is filtered looking for unique values from B4:B12
The values in columns A & C will always be associated with the value in column B (ex. BLUE will always have B & 2)
I need the resulting sum of the unique values in column D (ex. BLUE should be 80)
Spreadsheet: 884664d1733907331-need-help-to-have-both-holidays-of-japan-and-french-to-be-reflected-on-calendar-excel-upgrade-needed_2025_retro-planning-_1211
Sheet: Holidays

JAPAN HOLIDAYS
 | New Year's
 | Bank OFF Day | 2025-01-02 00:00:00
 | Bank OFF Day | 2025-01-03 00:00:00
 | Coming of Age Day (second Monday in January) |  |  | DATE(year,monthnumber,1+7*nth_occurrence)-WEEKDAY(DATE(year,monthnumber,8-dayofweek))
 | National Foundation Day | February 11 (Observed on February 12) |  | where year is in B2 and month (as a number 1 to 12) is in A2, and where xday is a number representing the day of the week (1 = Sun through to 7 = Sat), so for 1st Saturday that becomes
 | Emperor’s Birthday | February 23 (Observed on February 24)
 | Vernal Equinox Day | 2025-03-20 00:00:00 |  | For holidays that are the nearest Friday or Monday if they fall on a weekend
 | Shōwa Day | 2025-04-29 00:00:00 |  | DATE(year,monthnumber,daynumber)+IF(WEEKDAY(DATE(year,monthnumber,daynumber))=1,1,IF(WEEKDAY(DATE(year,monthnumber,daynumber))=7,-1,0))
 | Constitution Memorial Day | 2025-05-03 00:00:00
 | Greenery Day | May 4 (Observed on May 6)
 | Children’s Day | 2024-05-05 00:00:00
 | Marine Day | July 15 (Third Monday in July)
 | Mountain Day | August 11 (Observed on August 12)
 | Obon Festival
 | Obon Festival
 | Obon Festival
 | Respect for the Aged Day | September 16 (Third Monday in September)
 | Autumnal Equinox Day | 2025-09-23 00:00:00
 | Sports Day | October 14 (Second Monday in October)
 | Culture Day | November 3 (Observed on November 4)
 | Labor Thanksgiving Day | November 23 (Observed on November 24)
FRENCH HOLIDAYS
2025-01-01 00:00:00 | New Year's Day
2025-04-21 00:00:00 | Easter Monday
2025-05-01 00:00:00 | Labour Day
2025-05-08 00:00:00 | Victory in Europe Day
2025-05-29 00:00:00 | Ascension Day
2025-06-09 00:00:00 | Whit Monday
2025-07-14 00:00:00 | Bastille Day
2025-08-15 00:00:00 | Assumption Day
2025-11-01 00:00:00 | All Saints Day
2025-11-11 00:00:00 | Armistice Day
2025-12-25 00:00:00 | Christmas Day
Spreadsheet: sally_beck__33911__GlobalMgmtSum-Q101-0118
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
TOT_ALLOCATION | 1st QUARTER 2001 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-12-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
 | Crude & Products |  | 0 | 0 |  |  |  |  |  |  | 10361
COAL | Coal |  |  | 753.424 |  |  |  |  |  |  | 3055
SO2 | Emissions |  |  | 39.063 |  |  |  |  |  |  | 804
WEATHER | Weather |  |  | 0 |  |  |  |  |  |  | 1923
INSURANCE | Global Risk Markets |  | 0 | 0 |  |  |  |  |  |  | 732
ECT_INV_IRFX | Financial Trading |  |  | 0 |  |  |  |  |  |  | 2315
 | Transportation |  | 0 | 0 |  |  |  |  |  |  | 153
 | LNG |  |  | 0 |  |  |  |  |  |  | 1145
 | Middle East |  |  | 0 |  |  |  |  |  |  | 779
 | Puerto Rico |  |  | 591 |  |  |  |  |  |  | 561
 | Finance and Structuring |  | 0 | 0 |  |  |  |  |  |  | 55.061
 | Office of the Chairman |  | 0 | 0 |  |  |  |  |  |  | 464.792
 | Subtotal Commercial
 | [NAME] |  |  |  |  |  |  |  |  | 0 | 0
 | Group Allocated to Teams |  | 0 | 0
 | Total
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100169

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
CHURN/RELOCATION - Dept. 100169
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-05-23 00:00:00 | CHU03767021359000 |  | [NAME] | Phone-Lucent/EB  4653a/EB  4155b | 1 | 75 | /EACH | 75
 |  |  |  |  |  |  | Ticket Total |  | 75
2001-05-23 00:00:00 | CHU03767021359001 |  | [NAME] | Chair/EB  4653a/EB  4155b | 1 | 25 | /EACH | 25
 |  |  |  |  |  |  | Ticket Total |  | 25
2001-05-23 00:00:00 | CHU03767021359002 |  | [NAME] | Boxes/EB  4653a/EB  4155b | 1 | 25 | /EACH | 25
 |  |  |  |  |  |  | Ticket Total |  | 25
2001-05-23 00:00:00 | CHU03767021518000 |  | Equipment Equipment | Pick up and delete phone/EB  4155b/OLD Terminate | 1 | 75 | /EACH | 75
 |  |  |  |  |  |  | Ticket Total |  | 75
2001-05-24 00:00:00 | CHU03898021971000 |  | [NAME] | Phone Modification/EB  4150J/MOD Modification | 1 | 10 | /EACH | 10
 |  |  |  |  |  |  | Ticket Total |  | 10
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 210
 |  |  |  |  |  |  | Total for Dept_100169 |  | 210
Spreadsheet: 112201d1308317287-summing-up-itunes-sales-xls-included-match-index-lookup-eufeb10
Sheet: Total

Apple Identifier | Artist/Show/Developer | Title | Quantity | Share | Total | Currency
341512345 | [NAME] | [NAME] time - Single
354512376 | [NAME] | [NAME]
426712376 | Departure | [NAME]
252462626 | No time | Bright Light
341561278 | Pasante | Please
537384356 | ole ole | numesh
426427245 | Xero | a Smoke
265016870 | [NAME] | [NAME]
246272897 | Various Artists | Motion Xe Energy, [NAME]. 4
351613515 | [NAME] | It's All Right
Spreadsheet: 872238d1718638650-dashboard-without-pivot-tables-only-formula-and-functions-dummy_data-2-
Sheet: dashboard

 |  | Fiscal Month |  |  | Staff Type
 | Select the fiscal month → | 2023P08 |  |  | OS Lvl 1 Phone
 |  | Fiscal Week |  |  | [NAME]
 | Select the fiscal week → | 2023P08W3 |  |  | OS Lvl 1 Phone
 |  | Supervisors |  |  | Agent Name
 | Select the Team Manager → | [NAME] |  |  | [NAME]
 | Case Component
 | Case Details | Answered | SAT | Surveys | Pos. Survey | Neg. Survey | AHT
 | Team | Answered | SAT | Surveys | Pos. Survey | Neg. Survey | AHT
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: b19cd93c-7f8c-4c8e-bc6a-6161657fa796
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
MPA | Test | MPA | Mycophenolic Acid, Serum | Mycophenolic Acid, S | Tandem Mass Spectrometry (MS/MS) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.25  mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | MYCOPHENOLIC ACID (MPA) 1.0-3.5 mcg/mL  MPA GLUCURONIDE 35-100 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 3 days | 1 | 80299 |  |  |  |  | Rochester
MPA | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
MPA | Result | 15226 | Mycophenolic Acid | Mycophenolic Acid | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 23905-3
MPA | Result | 15227 | MPA Glucuronide | MPA Glucuronide | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 23906-1
Spreadsheet: 94190d1294073259-pull-first-value-pick-up-a-multiple-value
Sheet: Pick up a Value

 |  |  |  |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 20 | 20 | 30 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 99
 |  |  |  |  |  | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 53250 | 53250 | 52750 | 52500 | 52500 | 52500 | 52500 | 52500 | 52500 | 52500 | 52500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 50500 | 35500
 |  | Steps | Value
 |  | 10
 |  | 20
 |  | 30
 |  | 32
 |  | 40
 |  | 99
Spreadsheet: 143320d1330365460-how-to-realign-data-in-columns-to-rows-example
Sheet: Sheet1

 | How it looks now
1 | 9 | 17 | 25 | etc
2 | 10 | 18 | 26
3 | 11 | 19 | 27
4 | 12 | 20 | 28
5 | 13 | 21 | 29
6 | 14 | 22 | 30
7 | 15 | 23 | 31
8 | 16 | 24 | 32
 | How I need it to look
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Spreadsheet: 704570d1605626230-formula-to-populate-data-from-a-single-tab-to-other-tabs-and-then-back-to-the-single-tab-sample
Sheet: Vicky

Date | Sales order number | Account owner | Order value | Vendor | Expected Month of Delivery | % Probability | Comments
2020-01-09 00:00:00 | [PHONE] | Vicky | 11079.97 | Various | DEC | PIPELINE | Chased up
2020-01-30 00:00:00 | [PHONE] | Vicky | 8927.1 | Hikvision | DEC | [NAME] | Expected reply in March
Spreadsheet: 854524d1704369833-shift-work-sick-leave-and-hours-worked-calculator-sample-sheet
Sheet: Sheet1

Hours Calculator V1.0 | Thursday XXth January to Wednesday XXst January
Day | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W |  |  |  | Overtime Shift
Month | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Hours | How many sick in PP? |  | RDO
[NAME] |  |  |  |  |  |  |  |  |  | OT | Nightshift | Nightshift | Training day 8 Hours | Nightshift |  |  |  | nightshift
 |  |  |  |  |  |  |  |  |  |  |  | Leave | RDO |  |  |  |  | day shift
 |  |  |  |  |  |  |  |  | RDO |  |  | Day Shift |  |  |  |  |  | Leave
 |  |  |  |  |  |  |  |  |  |  | WC |  |  | Training day 8 Hours |  |  |  | Training day 8 Hours
 |  |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  |  |  | Sick
 |  |  |  |  |  |  |  |  |  |  |  |  | RDO |  |  |  |  | WC
STAFF NUMBERS
Overtime Shift
roster day off
nightshift 7-7
day shift
leave with detail /alternative duties
nightshift 11-7
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 12 | 343 | 355
Asia | - | - | -
Europe | - | 109 | 109
North America | 12 | 234 | 246
Other | - | - | -
Index | 6224 | 6919 | 13143
Asia | - | 60 | 60
Europe | 2096 | 736 | 2832
North America | 4065 | 6083 | 10148
Other | 63 | 40 | 103
Other | 66 | 354 | 420
Exotic | - | - | -
Swaptions | 66 | 354 | 420
Total Return Swap | - | - | -
TOTAL | 6302 | 7616 | 13918
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Northeast Trading

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 390000
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount
 | Analyst & Associate Headcount
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Boondoggle | 21273
 | Relocation | 26321
 | Employee Placement Fee | 26250