tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102394d1300332222-vlookup-problem-for-employees-with-same-shift-example-of-pull-from-schedule
Sheet: goal sheet

2011-01-02 00:00:00 | <-enter date
[NAME] | 10-5
angie | 10-3
mark | 12-8
[NAME] | 12-8
robby | 3-8
 | [NAME] | filtered | sort order | Rank | no blanks |  | sorted times
[NAME]
[NAME]
[NAME]
Mark
[NAME]
robby
angie
becky
micky
[NAME]
 |  | shift | sort order |  |  |  |  | 1 | 10-7 |  | =VLOOKUP(ROW()-ROW($E$5),$B$6:$C$15,2,FALSE)
 |  | 9-11 | 1 |  |  |  |  | 2 | 10-4 |  | 10-6
 |  | 9-6 | 2 |  |  |  |  | 3 | 10-3
 |  | 9-5 | 3 |  |  |  |  | 4 | 11-7
 |  | 9-4 | 4 |  |  |  |  | 5 | Paris Hilton |  | 1030-630
 |  | 9-11/2-8 | 5 |  |  |  |  | 6 | Ratan Tata |  | 1030-330
 |  | 9-11/3-8 | 6 |  |  |  |  | 7 | [NAME]
 |  | 10-7 | 7 |  |  |  |  | 8 | [NAME]
 |  | 10-6 | 8 |  |  |  |  | 9 | [NAME]
 |  | 10-5 | 9 |  |  |  |  | 10 | [NAME]
 |  | 10-4 | 10
 |  | 10-3 | 11
 |  | 1030-630 | 12
 |  | 1030-530 | 13
 |  | 1030-430 | 14
 |  | 1030-330 | 15
 |  | 11-7 | 16
 |  | 11-6 | 17
 |  | 11-5 | 18
 |  | 11-4 | 19
 |  | 11-3 | 20
 |  | 12-8 | 21
 |  | 12-7 | 22
 |  | 12-6 | 23
 |  | 12-5 | 24
 |  | 12-4 | 25
 |  | 1-8 | 26
 |  | 1-7 | 27
 |  | 1-6 | 28
 |  | 1-5 | 29
 |  | 1-10 | 30
 |  | 2-8 | 31
 |  | 2-7 | 32
 |  | 2-6 | 33
 |  | 2-11 | 34
 |  | 3-8 | 35
 |  | 3-9 | 36
 |  | 3-10 | 37
 |  | 3-11 | 38
 |  | 3-12 | 39
Spreadsheet: 61184d1261992892-problem-using-lookup-test
Sheet: Working Sheet

Company A
Company A
Company A
Company A
Company A
Company A
Company A
Company A
Company A
Company A
Company C
Company C
Company C
Company C
Company C
Company C
Company C
Company C
Company C
Company C
Company C
Company C
Company C
Company B
Company B
Company B
Company B
Company B
Company B
Company B
Company B
Company B
Company B
Company D
Company D
Company D
Company D
Company D
Company D
Company D
Spreadsheet: 199823d1355332475-help-separating-standardised-text-string-challenge-postal
Sheet: Sheet1

[NAME], The (Winson Green Road, B18 4AW)
Actress & Bishop (36 Ludgate Hill, B3 1EH)
Adam & Eve, The (Bradford Street, B12 0JD)
Adderley Park, The (168 Adderley Road, B8 1EH)
Albion Vaults, The (Cato Street North, B7 5AP)
All Bar One (43 Newhall Street, B3 3NY)
All Bar One (Brindley Place, B1 2HL)
Spreadsheet: 456645d1460983250-peroster-dilemna-calculate-hours-worked-for-scific-shifts-on-public-holidays-using-tables-ph_hoursworked
Sheet: Sheet1

# | Name | 2016-01-01 00:00:00 | 2016-01-02 00:00:00 | 2016-01-03 00:00:00 | 2016-01-04 00:00:00 | Total | PHW | PHW Hours
1 | Name | Day | X | Night | X |  |  | 18
2 | Name | Day | Day | Day | Day |  |  | 16
3 | Name | Day | Day | X | X |  |  | 8
4 | Name | X | Day | X | Day |  |  | 0
5 | Name | Night | Night | Night | Night |  |  | 20
Table Public Holidays |  |  | Table Shift
Date |  |  | Shift | Hrs
2016-01-01 00:00:00 |  |  | Day | 8
2016-01-03 00:00:00 |  |  | Night | 10
 |  |  | X | 0
Spreadsheet: 130286d1322151250-problem-charting-med-use-example
Sheet: Sheet1

 | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Medication |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x
Med A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x
Med B
Spreadsheet: 773953d1648130944-using-vlookup-with-an-if-and-function-forum_example
Sheet: Sheet1

Product | Shop 1 | Shop 2 |  | Child | Drop Off | Pick Up | Cost | Days | Total | Paid | Owed
08:00:00 | 15:30:00 | 21 |  | 1 | 08:00:00 | 16:00:00 |  | 1 |  | 0
08:00:00 | 16:00:00 | 23.5 |  | 2 | 09:00:00 | 15:30:00 |  | 2 |  | 0
08:00:00 | 16:30:00 | 26 |  | 3 | 08:30:00 | 17:00:00 |  | 3 |  | 0
08:00:00 | 17:00:00 | 26 |  | 4 | 09:00:00 | 16:00:00 |  | 4 |  | 0
08:00:00 | 17:30:00 | 27 |  | 5 | 08:00:00 | 16:00:00 |  | 5 |  | 0
08:00:00 | 18:00:00 | 28 |  | 6
08:30:00 | 15:30:00 | 18.5
08:30:00 | 16:00:00 | 21
08:30:00 | 16:30:00 | 23.5
08:30:00 | 17:00:00 | 26
08:30:00 | 17:30:00 | 27
08:30:00 | 18:00:00 | 28
09:00:00 | 15:30:00 | 16
09:00:00 | 16:00:00 | 18.5
09:00:00 | 16:30:00 | 21
09:00:00 | 17:00:00 | 23.5
09:00:00 | 17:30:00 | 26
09:00:00 | 18:00:00 | 28
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Gettysburg 

 |  |  |  |  |  |  | 2013 Gettysburg
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Every other Tuesday (opp. [NAME]).  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 31cbd49d-3c8f-4d25-9b49-d840ea9ab10f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5206.0 Australian National Accounts: National Income, Expenditure and Product
 | Table 19. Social Assistance Benefits Payments, Current prices
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
General government - National ;  Health ; |  |  | Original | A2301964W | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Sickness benefits ; |  |  | Original | A2301965X | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Benefits to ex-servicemen and their dependants ; |  |  | Original | A2301966A | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Permanent disablement benefits ; |  |  | Original | A2301967C | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Old age benefits ; |  |  | Original | A2301968F | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Unemployment benefits ; |  |  | Original | A2301969J | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Family and child benefits ; |  |  | Original | A2301970T | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Other ; |  |  | Original | A2301971V | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Total social security ; |  |  | Original | A2301972W | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Other social assistance benefit payments ; |  |  | Original | A2301973X | 1959-09-01 00:00:00 | 2010-06-01 00:00:00 | 204 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Total personal benefits payments ; |  |  | Original | A2301974A | 1959-09-01 00:00:00 | 2010-06-01 00:00:00 | 204 | $ Millions | DERIVED | Quarter | 3
General government - State and local ;  Total personal benefits payments ; |  |  | Original | A2301975C | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
General government ;  Total personal benefits payments ; |  |  | Original | A2301976F | 1961-09-01 00:00:00 | 2010-06-01 00:00:00 | 196 | $ Millions | DERIVED | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: mark_taylor__24801__Bradford Report 110199
Sheet: summary

1999-11-01 00:00:00 |  |  |  | 1999-10-25 00:00:00 |  |  |  | %Change
Sum of Excess MTM |  |  |  | Sum of Excess MTM
Enron Entity | Total |  |  | Enron Entity | Total
ECT | 54818640 |  |  | ECT | 90744661
EGSC | 218567185.9904858 |  |  | EGSC | 239728951.9340102
EPMI | 16589013 |  |  | EPMI | 18008085
Grand Total | 289974838.9904858 |  |  | Grand Total | 348481697.9340101
Sum of Excess MTM |  |  |  | Sum of Excess MTM
E-Rtg | Total |  |  | E-Rtg | Total
2 | 12403359 |  |  | 2 | 16200361
3 | 4358605 |  |  | 3 | 10142193
4 | 35870636 |  |  | 4 | 39515544.49069374
5 | 122184166.5701665 |  |  | 5 | 127437960.6582064
6 | 30314158.38769963 |  |  | 6 | 43851780.49069374
7 | 3107446 |  |  | 7 | 6221574
8 | 58428188.69384982 |  |  | 8 | 67980334.24534687
9 | 11253743.00407747 |  |  | 9 | 22219401.78680203
10 | 6793427.334692491 |  |  | 10 | 6993328.262267344
11 | 5261109 |  |  | 11 | 7919220
Grand Total | 289974838.9904859 |  |  | Grand Total | 348481697.9340102
Sum of Excess MTM |  |  |  | Sum of Excess MTM
Explanation | Total |  |  | Explanation | Total
Amending Threshold | 484946 |  |  | Amending Threshold | 1806175
Amending Threshold to $10MM | 1267901 |  |  | Amending Threshold to $10MM | 5653856
Amending Threshold to $5MM | 1151475 |  |  | Amending Threshold to $5MM | 2472861
Canada | 215674741.9904858 |  |  | Canada | 238687198.9340102
Commercial Objection | 39525796 |  |  | Commercial Objection | 55821650
Credit Monitoring | 110093 |  |  | Credit Monitoring | 1936518
Guarantee for $100MM | 395138 |  |  | Guarantee for $100MM | 1075515
Guarantee for $12MM | 4510115 |  |  | Guarantee for $12MM | 3375371
Guarantee for $15MM | 4621805 |  |  | Guarantee for $15MM | 6028321
Margin Call | 13108921 |  |  | Margin Call | 20589711
Workout | 9123907 |  |  | Workout | 11034521
Grand Total | 289974838.9904858 |  |  | Grand Total | 348481697.9340101
Spreadsheet: 3ef2c43f-158c-4189-bf5d-14d051c9b5a8
Sheet: Sheet1

Release: International Unemployment Rates and Employment Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=202
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-12 4:03 PM CDT
 | Real-Time | Period
Name: | Start | End
International Unemployment Rates and Employment Indexes | 2010-11-04 00:00:00 | Current
Link:
http://www.bls.gov/fls/intl_unemployment_rates_monthly.htm | 2010-11-04 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 2010-11-04 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-11-04 00:00:00
2010-12-02 00:00:00
2011-01-06 00:00:00
2011-02-03 00:00:00
2011-03-03 00:00:00
2011-03-31 00:00:00
2011-05-05 00:00:00
2011-06-02 00:00:00
2011-07-07 00:00:00
2011-08-04 00:00:00
2011-09-01 00:00:00
2011-10-06 00:00:00
2011-11-03 00:00:00
2011-12-02 00:00:00
2012-01-05 00:00:00
2012-02-02 00:00:00
2012-03-08 00:00:00
2012-04-05 00:00:00
2012-05-03 00:00:00
2012-05-31 00:00:00
2012-07-05 00:00:00
2012-08-02 00:00:00
2012-09-06 00:00:00
2012-10-05 00:00:00
2012-11-06 00:00:00
2012-12-06 00:00:00
2013-01-03 00:00:00
2013-01-31 00:00:00
2013-03-07 00:00:00
2013-04-04 00:00:00
2013-05-02 00:00:00
2013-06-07 00:00:00
2013-07-03 00:00:00
2013-08-01 00:00:00
Spreadsheet: 266747d1379709670-30-files-received-type-data-all-different-but-needs-to-be-counted-as-the-same-in-1-sheet-final-should-look-like
Sheet: Inbound Data 363

Center 363
Row Labels | Sum of Stand | Sum of Groundballs | Sum of Flyballs | Sum of Bowling Balls | Sum of Desk | Sum of Rolling Balls | Sum of Hotel | Sum of Local | Sum of Other | Sum of Transition | Sum of Tree | Sum of Shrub
2010-10-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 457 | 0 | 0 | 0 | 0 | 0
2010-10-09 00:00:00 | 0 | 38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5
2010-10-11 00:00:00 | 0 | 22 | 0 | 10 | 0 | 0 | 0 | 7 | 0 | 0 | 117 | 0
2010-10-12 00:00:00 | 0 | 27 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 0
Grand Total | 0 | 87 | 0 | 17 | 0 | 0 | 457 | 7 | 0 | 0 | 133 | 5
Note: In this sheet there are no concierge & DHL
Spreadsheet: 585262d1533689418-dynamic-hyperlink-to-last-column-goto-a1-to-b1-to-c1-data-set-grows-hyperlink-to-d1-hyperlink-demostration
Sheet: Sheet1

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME] | Header 9 | Header 10 | [NAME] | Header 12 | Header 13 | 321321 | 321
 |  |  | Last Row based on Column B | Mixed | Text
 |  |  |  | ^ array formula
 |  |  | Last Column in row 1 | Mixed | Text
 | fds |  |  | ^ array formula
 | 321
 | 43242
 |  |  |  | If you want Red cell, you either have to convert to table or require VBA
 | asdas
 | 423423
321 |  |  | 4324
 |  |  | 23
 |  |  |  | 4
 |  |  |  |  | 234 |  |  |  |  |  |  | 234
 |  |  |  |  |  | 24 |  |  |  |  | 234
 |  |  |  |  |  |  | 234 |  |  | 432
 |  |  |  |  |  |  |  | 4 | 32423
Spreadsheet: 456981d1461154601-creating-class-rosters-by-grade-sample
Sheet: Student Roster

Kindergarten
1 | [NAME] | 2011-06-18 00:00:00
2
3
4
Grade One
1 | [NAME] | 2010-07-04 00:00:00
2 | [NAME] | 2010-02-18 00:00:00
3
4
Grade Two
1 | [NAME] | 2009-04-22 00:00:00
2 | [NAME] | 2009-03-26 00:00:00
3
4
Spreadsheet: mary_fischer__25641__111
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111
COMPANY NAME  Pierce Mechanical
ANALYSIS OF OTHER CURRENT ASSETS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Wire transfer overage of funds |  | 130931 |  | -47374 |  |  |  | -428543
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 768489d1644998981-formula-to-extract-rows-that-meet-certain-criteria-into-another-table-example
Sheet: 2

P0. Planning
Project Budget
Project Priority | 0
Total Project Costs | 167000
FUNDING
Source | Amount (Ex GST)
Loan 1 | 200000
Total Funding Allocated |  |  |  | I would like all priorities from [NAME] that match the priority in cell B4 on this page to be listed below.
 |  |  |  | Row 20 below is what I've come up with so far, but it is supposed to be an array formula and when
EXPENDITURE (TO DATE) |  |  |  | I hit ctrl+shift+enter it doesn't work. It does work without the { } but only for one entry.
 |  |  |  | When I drag the formula down it doesn't return any values
PURCHASE ORDERS
P.O.# | Item Description | Project Component | Task | Supplier | Priority | PO Total | Actual Expenses | Remaining Balance
INVOICES
PO Number | Item Description | Project Component | Task | Supplier | Priority | PO Balance | Invoice Amount | Invoice Number | Invoice Date
Spreadsheet: 453857d1459489912-unique-list-of-data-sample
Sheet: Sheet1

 |  |  |  |  |  |  | Condition 1 | BBB
 |  |  |  |  |  |  | Condition 2 | 1
 |  |  | Client Name | Name | Amount | Type |  | Name | Amount
 |  |  | ABC | AA | 10 | 1
 |  |  | ABC | AA | 20 | 1
 |  |  | PQR | AA | 20 | 1
 |  |  | LMO | BBB | 10 | 2
 |  |  | FACE | BBB | 40 | 1
 |  |  | KEEP | DD | 40 | 2
 |  |  | SMOOTH | DD | 50 | 1
 |  |  | LIKE | EEE | 60 | 1
 |  |  | DEM | FFF | 100 | 1
Spreadsheet: 51263d1250792869-formulas-for-the-list-headers-financial-report
Sheet: Sheet1

 | EXAMPLE 1
 | Report for | 2009-08-20 00:00:00
Project | Previous Report for Aug-09 | 2009-08-20 00:00:00 | 2009-09-20 00:00:00 | 2009-10-20 00:00:00 | 2009-11-20 00:00:00 | 2009-12-20 00:00:00 | 2010-01-20 00:00:00 | 2010-02-20 00:00:00 | 2010-03-20 00:00:00 | 2010-04-20 00:00:00 | 2010-05-20 00:00:00 | 2010-06-20 00:00:00 | 2010-07-20 00:00:00
AAA | 15 | 10 | 30 | 50 | 70 | 90 | 110 | 130 | 150 | 170 | 190 | 210 | 230
BBB | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
CCC | 25 | 30 | 10 | 20 | 10 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0
Total | 60 | 60 | 60 | 90 | 100 | 115 | 135 | 155 | 170 | 190 | 210 | 230 | 250
 | EXAMPLE 2
 | Report for | 2009-08-20 00:00:00
Project | Previous Report for Aug-09 | Aug-09 | Sep-09 | Oct-09 | Nov-09 | Dec-09 | Jan-10 | Feb-10 | Mar-10 | Apr-10 | May-10 | Jun-10 | Jul-10
AAA | 15 | 10 | 30 | 50 | 70 | 90 | 110 | 130 | 150 | 170 | 190 | 210 | 230
BBB | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
CCC | 25 | 30 | 10 | 20 | 10 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0
Total | 60 | 60 | 60 | 90 | 100 | 115 | 135 | 155 | 170 | 190 | 210 | 230 | 250
 | EXAMPLE 3
 | Report for | 2009-08-20 00:00:00
Project | Previous Report for Aug-09 | 2009-08-20 00:00:00 | 2009-09-20 00:00:00 | 2009-10-20 00:00:00 | 2009-11-20 00:00:00 | 2009-12-20 00:00:00 | 2010-01-20 00:00:00 | 2010-02-20 00:00:00 | 2010-03-20 00:00:00 | 2010-04-20 00:00:00 | 2010-05-20 00:00:00 | 2010-06-20 00:00:00 | 2010-07-20 00:00:00
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
AAA | 15 | 10 | 30 | 50 | 70 | 90 | 110 | 130 | 150 | 170 | 190 | 210 | 230
BBB | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
CCC | 25 | 30 | 10 | 20 | 10 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0
Total | 60 | 60 | 60 | 90 | 100 | 115 | 135 | 155 | 170 | 190 | 210 | 230 | 250
Spreadsheet: 117370d1312741724-excel-chart-help-excelforum_787143
Sheet: Stacked Columns

 |  | Influence |  | Influence
 |  | Yes | No | Yes | No
0.44 | A | 0.11 | 0.33 | 0.25 | 0.75
0.11 | B | 0 | 0.11 | 0 | 1
0.44 | C | 0.44 | 0 | 1 | 0
 |  |  |  |  |  |  | stacked column chart using yellow range
 |  |  |  |  |  |  | apply labels from green range with [NAME] [NAME] (http://appspro.com)
Spreadsheet: 781613d1653443790-amend-dates-in-respective-cells-when-a-certain-date-is-reached-and-recycle-monthly-dajmcnn_example
Sheet: Sheet1

Date | Description | Amt |  | Reference Data
2022-06-01 00:00:00 | AAAA | -20.5 |  | xxxxx
2022-06-01 00:00:00 | BBBB | -100
2022-06-02 00:00:00 | CCCC | -34.29
2022-06-11 00:00:00 | DDDD | -15.99
2022-06-11 00:00:00 | EEEE | -60
2022-06-18 00:00:00 | FFFF | -9.99
Spreadsheet: 028f1401-7389-488b-80a0-8e57da841820
Sheet: Sheet1

Degree Level, Top 10 Places of Origin for | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Australia, 2011
Places of Origin | Top 10 Places of Origin | Total Number of International Students | Undergraduate Degree-seeking International Students | Undergraduate Non-degree-seeking International Students | (Post-)Graduate Degree-seeking International Students | (Post-)Graduate Non-degree-seeking International Students | Other Non-degree International Students
#1 | China | 4415 | 50410 | 12825 | 32173 | 2015 | 743
#2 | Malaysia | 2751 | 13619 | 796 | 3339 | 219 | 34
#3 | India | 2092 | 5414 | 427 | 8535 | 1131 | 211
#4 | Vietnam | 1727 | 6122 | 1762 | 2932 | 151 | 13
#5 | Indonesia | 1310 | 5605 | 1136 | 2490 | 120 | 0
#6 | South Korea | 1168 | 6195 | 1375 | 1101 | 101 | 2
#7 | Singapore | 975 | 6916 | 242 | 1131 | 92 | 14
#8 | Nepal | 909 | 5427 | 146 | 1122 | 200 | 5
#9 | Saudi Arabia | 899 | 2064 | 687 | 3324 | 114 | 3
#10 | Thailand | 788 | 1110 | 190 | 2332 | 90 | 6
Total of All Places of Origin | Total | 242351 | 131342 | 23386 | 81032 | 6591 | 1074
Source: Australian Education International
Spreadsheet: 66cdaa0f-0de9-43e7-b40b-7b3ac515ae3b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43542462 | 2014-10-12 03:04:55 | AXIS | 0 | 3 | 5 | 1024315 | dangie | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43542667 | 2014-10-12 03:20:21 | ALLIES | 0 | 3 | 5 | 1024315 | dangie | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
Spreadsheet: 267202d1380008802-grouping-the-percentage-using-if-and-if-issue
Sheet: Sheet6

Item Name | Sales Price | Cost price | GROUPS |  | Actual Need
A | 5 | 0.09
B | 2.5 | 0.21
C | 6 | 0.25
D | 4.5 | 0.3
E | 1 | 0 |  |  | GROUP E | Desired results
F | 2.5 | 0.05
G | 1.5 | 0.25
H | 3.5 | 0.3
I | 1.5 | 0 |  |  | GROUP E | Desired results
J | 2.5 | 0.05
K | 3.5 | 0.1
Spreadsheet: 776940d1650011524-un-text-numbers-in-filtered-data-test-filter
Sheet: FILTERED

C O P Y       F O R M A T T I N G      F R O M   R O W  2 |  |  |  |  |  |  |  |  |  |  |  |  | Office
 |  |  |  |  |  |  |  |  |  |  |  |  | From | 2022-02-01 00:00:00
OFİS | REZ. END | KONTRAT | PLAKA | PICK UP TIME | DROP OFF TIME | GEÇİŞLER | +  %18 | TAHSİL | DIFF. | AÇIKLAMA | Plate No Change | Test Column | To | 2022-02-28 00:00:00
 | 44602 | 21252973 | 34EAY791 | 44574.[PHONE] | 44576.[PHONE] | 13 | 15.34 | 0 | -15.34 |  | yes
AAA | 44602 | 21252973 | 34EAY849 | 44576.493275463 | 44606.574212963 | 84.5 | 99.71 | 0 | -99.71 |  | yes
AAA | 44614 | 21286472 | 34EAY847 | 44586.[PHONE] | 44616.699375 | 1038.75 | 1225.73 | 1396.5 | 170.77
CCC | 44594 | 21386309 | 34DZE265 | 44587.[PHONE] | 44594.[PHONE] | 5.75 | 6.79 | 0 | -6.79
CCC | 44595 | 21412720 | 34EAY850 | 44593.[PHONE] | 44595.[PHONE] | 14.5 | 17.11 | 35 | 17.89
DDD | 44610 | 21456238 | 34DYN110 | 44604.[PHONE] | 44611.[PHONE] | 29.5 | 34.81 | 11.8 | -23.01
EEE | 44593 | 21308722 | 34DZD645 | 44567.597962963 | 44594.[PHONE] | 211.25 | 249.28 | 266 | 16.72
EEE | 44593 | 21311591 | 34EVF059 | 44584.[PHONE] | 44593.[PHONE] | 184 | 217.12 | 177 | -40.12
EEE | 44620 | 21354809 | 34DYZ460 | 44611.[PHONE] | 44620.[PHONE] | 131.75 | 155.47 | 203.5 | 48.03
FFF | 44620 | 21413462 | 34DYN598 | 44617.[PHONE] | 44620.[PHONE] | 23 | 27.14 | 18 | -9.14
FFF | 44620 | 21438720 | 34EVE922 | 44599.[PHONE] | 44601.[PHONE] | 39.5 | 46.61 | 30.33 | [NAME] |  | yes
FFF | 44620 | 21438720 | 34DYN417 | 44601.[PHONE] | 44613.[PHONE] | 247 | 291.46 | 189.67 | -101.79 |  | yes
FFF | 44620 | 21515174 | 34DZD334 | 44616.[PHONE] | 44620.[PHONE] | 218 | 257.24 | 203.25 | -53.99