tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163836d1340478455-how-can-i-do-a-double-lookup-double-lookup-sample
Sheet: Sheet1

 | Material: | SA-516-60 |  | Temp: | 550 |  | Stress:
Material | -20 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000
SA-516-70 | 20000 | 20000 | 20000 | 20000 | 19400 | 18100 | 12000 | 6700 | 2500
SA-516-60 | 17100 | 17100 | 17100 | 17100 | 16400 | 15300 | 10800 | 5900 | 2500
SA-515-60 | 17100 | 17100 | 17100 | 17100 | 16400 | 15300 | 10800 | 5900 | 2500
SA-285-C | 15700 | 15700 | 15700 | 15700 | 15300 | 14300 | 10800 | 5900 | NA
Spreadsheet: 21324d1208713195-project-tracking-help-project-tracking-sheet
Sheet: Sheet1

Project Tracking |  |  |  | Total Value
 |  |  |  | 4000
Name of Customer | Project Ref/Name | Product | Quantity | Potential Value | Won/Lost/Pending | Approx Deliver Date
Pye Homes | Chichester House | [NAME] | 4 Each | 4000 | Pending | August | won
 |  |  |  |  |  |  | lost
 |  |  |  |  |  |  | pending
 |  |  |  |  |  |  | Win/loss [NAME]
 |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  | May
 |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  | Dec
 |  |  |  |  |  |  | Total | 0
Spreadsheet: 179451d1347267561-help-with-formatting-and-index-formula-ef183_excel-problem
Sheet: BU Name 

 |  |  |  |  |  |  |  |  |  | Original |  |  | Current |  |  | Key Dates
 |  |  |  |  |  |  |  |  |  | Cycle | Cost Tape |  | Cost Tape |  | Remaining | Should Cost
 | BU | Name | ME or EE | Intel Platform | Program | Series | Model | Part No. | Volume (K) | (YYMM) | $ | Opportunity | $ | Achieved | Opportunity | Finished/Tgt | G.A.
 | Elite | [NAME] | ME | Roman | Knock | A | J | 0 | 100 | 1207 | 112.65 | 7.08 | 110 |  |  | 2012-05-25 00:00:00 | 2012-04-17 00:00:00
 | Elite | bob | ME | Roman | [NAME] | B | 20 | 11111 | 25 | 1208 | 190.74 | 9.44 | 185 |  |  | 2012-08-01 00:00:00 | 2012-05-28 00:00:00
 | Elite | bob | ME | Roman | Tock | C | Z | 22222 | 25 | 1209 | 154.42 | 8.78 | 150 |  |  | 2012-07-23 00:00:00 | 2012-06-18 00:00:00
 | Elite | bob | EE | Roman | Grill | D | X | 33333 | 100 | 1207 | 161.77 | 5.65 | 158 |  |  | 2012-05-25 00:00:00 | 2012-04-17 00:00:00
 | Elite | bob | EE | Roman | Jones | E | Y | 44444 | 25 | 1208 | 270.73 | 33.57 | 255 |  |  | 2012-08-01 00:00:00 | 2012-05-28 00:00:00
 | Elite | bob | EE | Roman | [NAME] | F | P | 55555 | 25 | 1209 | 247.38 | 25.92 | 235 |  |  | 2012-07-23 00:00:00 | 2012-06-18 00:00:00
 |  |  |  |  |  |  | ME Extended Totals ($K) |  |  |  |  |  |  |  |  | EE Extended Totals ($K)
 |  |  |  |  |  |  |  | Remaining |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  | Achieved | Opportunity |  |  |  |  |  |  |  | Achieved | Opportunity
Spreadsheet: 4dc6b05b-fc73-4641-a8d4-8734597e6c41
Sheet: SR_LRPRELIMSUM

Load Response Preliminary Settlement Summary Report
SR_LRPRELIMSUM_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  |  | Location Information |  | Day Ahead |  | Real Time
Trading Date | Trading Interval | Program Name | Location ID | Location Name | Day Ahead Cleared MW | Day Ahead Locational Marginal Price | Real Time Amount Interrupted | LR Deviation | Real Time Locational Marginal Price
Date | Hour End | String | Number | String | MWh | $/MWh | MWh | MWh | $/MWh
Spreadsheet: 53988d1253907388-sorting-via-auto-filter-causes-formulas-to-change-data-filter-test
Sheet: JobCodes

Eff Date | Job Code | Description
1901-01-01 | C111 | Machine Operator
2001-07-01 | C112 | Director
1901-01-01 | C113 | [NAME]
1901-01-01 | C114 | Analyst
1901-01-01 | C116 | Executive Secretary
1901-01-01 | C117 | Senior Analyst
2001-07-20 | C118 | Compliance Officer
2008-01-24 | C119 | Supervisor
2008-07-01 | C120 | Assistant Director
Spreadsheet: 746696d1630951873-how-many-names-are-common-between-lists-and-how-many-are-not-in-any-list-sales-sample
Sheet: Webinar

Violet
Nova
[NAME]
[NAME]
Zoe
Ava
Charlotte
Sophia
Amelia
[NAME]
[NAME]
[NAME]
Harper
Camila
[NAME]
[NAME]
Luna
Ella
[NAME]
Sofia
Emily
Avery
Mila
[NAME]
Eleanor
[NAME]
Layla
Penelope
Aria
Chloe
Spreadsheet: 774406d1648460105-search-for-next-available-day-find-next-available-day
Sheet: Sheet1

Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Chosen | Results
01:00:00 | 05:00:00 | 03:00:00 | 04:00:00 | 08:00:00 |  |  | Sunday | Monday
02:00:00 | 02:00:00 | 08:00:00 | 09:00:00 | 05:00:00 |  |  | Monday | Monday
 |  | 09:00:00 | 06:00:00 |  |  |  | Saturday | Wednesday
07:00:00 | 08:00:00 |  |  | 07:00:00 |  |  | Tuesday | Tuesday
 |  |  |  | 02:00:00 |  |  | Wednesday | Friday
Spreadsheet: 176018d1345708638-help-creating-form-to-save-data-into-new-sheets-day-end-and-waste1
Sheet: END DAY

 | Horse & Groom
Day |  |  | Date
Staff Name |  |  |  | Hours
PROMO FOR |  | PRODUCT |  |  | CONSUMED
EXPENSES |  |  |  |  |  | £
TOTAL
 |  | TAKINGS / Z-READ
LESS EXPENSES |  | MONEY EXPECTED |  | ACTUAL TOTAL |  | + / -
Spreadsheet: 3f29feba-5441-4423-9e54-0bf54da5f2d3
Sheet: Sheet1

 | Study Title |  |  | Date Study Completed | Principal Investigator Name(s) | Principal Investigator Credentials | Role(s) of organization's Nurse(s) in the Study | Study Scope                                Check only one |  |  | Study Types                           Check all that apply
 |  | Date Approved by IRB (mm/dd/yy) | Study Status |  |  |  |  | Internal to a Single Organization | Multiple Organizations within a System | Independent Organizations Collaboratively | Replication | Qualitative | Quantitative
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
33
34
35
36
37
38
39
40
41
42
Spreadsheet: 213647d1360602038-premium-calculations-premium-calculations
Sheet: Calculations

GHI
 |  |  | Addition Details: |  |  |  |  |  |  |  | 2013-12-23 00:00:00
Sl | EMP.NUM | EMPLOYEE NAME | [NAME] | Relationship | Date of birth ( dd/ mm/yyyy) | Completed Age | Gender | Category | DOJ | [NAME] | Prorata days | Prorata pre
1 | 1111 | Sagar | [NAME] | Father | 1942-06-26 00:00:00 |  | M | 1 | 2013-01-24 00:00:00 | 200000
 |  |  |  |  |  | need formulae to calculate the age
 |  |  |  |  | 1 | Calumn "B" premium
 |  |  |  |  | 2 | Calumn "C" premium
 |  |  |  |  | 3 | Calumn "D" premium
 |  |  |  |  | 7187 | if "I4" cell is "1", formulae has to check the "G4" (Age) and pick the value(premium) from Database sheet according to the age bracket and calculate the Prorata Premium
Spreadsheet: 746506d1630779072-automatically-work-out-percentage-increase-to-balance-figure-midshires-master-2022
Sheet: playlist

 | Our Next Event of the 2021 season is……. |  |  |  |  |  | PLAYER INDEX
 | The Weekender at Telford |  |  |  | [NAME] | 11am |  |  |  | 00:08:00
 | Friday 27th August |  |  |  |  |  | 1 |  | 32
 | Nearest the pins:    in 1 = 11th   in 2 = 15th    in 3 = 2nd             Glory Hole = 7th |  |  | Captains Bottle = 3rd     Longest drive = 14th |  |  | 2 |  | 33
 | GROUP | Tee-Time | Player | Official Handicap | Playing Handicap | To Pay | 3 |  | 34
7 | 1 |  |  |  |  | Paid | 4 |  | 35 |  |  |  | H'Cap | To Pay
28 |  | 12:06:00 |  |  |  | Paid | 5 |  | 36
46 |  |  |  |  |  | Paid | 6 |  | 37
 |  |  |  |  |  |  | 7 |  | 38
26 | 2 |  |  |  |  | Paid | 8 |  | 39
48 |  |  |  |  |  | Paid | 9 |  | 40
50 |  |  |  |  |  | Paid | 10 |  | 41
 |  |  |  |  |  |  | 11 |  | 42
53 | 3 |  |  |  |  | Paid | 12 |  | 43
57 |  |  |  |  |  | Paid | 13 |  | 44
20 |  |  |  |  |  | Paid | 14 |  | 45
41 |  |  |  |  |  | Paid | 15 |  | 46
4 | 4 |  |  |  |  | Paid | 16 |  | 47
10 |  |  |  |  |  | Paid | 17 |  | 48
27 |  |  |  |  |  | Paid | 18 |  | 49
34 |  |  |  |  |  | Paid | 19 |  | 50
13 | 5 |  |  |  |  | Paid | 20 |  | 51
22 |  |  |  |  |  | Paid | 21 |  | 52
35 |  |  |  |  |  | Paid | 22 |  | 53
43 |  |  |  |  |  | Paid | 23 |  | 54
18 | 6 |  |  |  |  | Paid | 24 |  | 55
29 |  |  |  |  |  | Paid | 25 |  | 56
45 |  |  |  |  |  | Paid | 26 |  | 57
49 |  |  |  |  |  | Paid | 27 |  | 58
8 | 7 |  |  |  |  | Paid | 28 |  | 59
23 |  |  |  |  |  | Paid | 29 |  | 60
30 |  |  |  |  |  | Paid | 30 |  | 61
39 |  |  |  |  |  | Paid | 31 |  | 62
1 | 8 |  |  |  |  | Paid |  |  | 63
33 |  |  |  |  |  | Paid |  |  | 64
47 |  |  |  |  |  | Paid |  |  | 65
68 |  |  |  |  |  | Paid |  |  | 66
9 | 9 |  |  |  |  | Paid |  |  | 67
32 |  |  |  |  |  | Paid |  |  | 68
37 |  |  |  |  |  | Paid |  |  | 69
69 |  |  |  |  |  | Paid |  |  | 70
 | 10 |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  | 72
 | 11
 | 12
 | 13
Spreadsheet: 79463d1279724805-conditional-partially-coping-of-rows-in-excel-partial-copying-of-rows-on-bases-of-several-conditions-1
Sheet: Database

[NAME] | Date | Country | Status | Closing Date | Reference | Status  Ins. | Germany | Poland | Romania
x | 2010-04-13 00:00:00 | Romania | PAO |  |  |  |  |  | True
x | 2010-05-20 00:00:00 | Romania | CG
x | 2010-05-28 00:00:00 | Poland | PAO |  |  |  |  | True
x | 2010-06-07 00:00:00 | Poland | CG |  |  |  |  |  |  |  |  | Germany | Poland | Romania
x | 2010-01-03 00:00:00 | Romania | PAO | Q2 2010 | x |  |  |  | True
x | 2010-06-29 00:00:00 | Romania | PAO |  |  |  |  |  | True
x | 2010-02-22 00:00:00 | Poland | CG
x | 2010-04-13 00:00:00 | Romania | CG
x | 2010-04-14 00:00:00 | Romania | CG
x | 2010-04-15 00:00:00 | Romania | CG
x | 2010-04-16 00:00:00 | Poland | CG
x | 2010-04-17 00:00:00 | Poland | CG
x | 2010-04-18 00:00:00 | Poland | CG
x | 2010-04-19 00:00:00 | Poland | PAO | Q3 2010 |  |  |  | True
x | 2010-04-20 00:00:00 | Poland | CG
x | 2010-04-21 00:00:00 | Romania | CG
x | 2010-04-22 00:00:00 | Poland | PAO | Q3 2010 | x |  |  | True
x | 2010-04-23 00:00:00 | Poland | CG
x | 2010-04-24 00:00:00 | Germany | CG
x | 2010-04-25 00:00:00 | Poland | CG
x | 2010-04-26 00:00:00 | Romania | CG
x | 2010-04-27 00:00:00 | Romania | PAO |  |  |  |  |  | True
x | 2010-04-28 00:00:00 | Poland | CG
x | 2010-04-29 00:00:00 | Poland | PAO | Q4 2010 |  |  |  | True
x | 2010-04-30 00:00:00 | Germany | CG
x | 2010-05-01 00:00:00 | Germany | PAO | Q3 2010 |  |  | True
x | 2010-05-02 00:00:00 | Poland | PAO | Q3 2010 | x |  |  | True
x | 2010-05-03 00:00:00 | Romania | CG
x | 2010-05-04 00:00:00 | Romania | CG
Spreadsheet: 119068d1314185984-index-and-match-function-rank
Sheet: Rank

Display | Engine Oil.jpg | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Exhaust.jpg | Cat.jpg | Alternator.jpg | Starter.jpg | Shock Absorber.jpg | Coil Spring.jpg | Wheel Bearing.jpg | Turbo.jpg
Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Spreadsheet: 866533d1713455998-pull-values-from-data-sheet-into-check-sheet-based-on-serial-no-doc1_etaf
Sheet: Check

Reg 1 |  |  |  |  | Reg 2
Serial No | 1114 | Serial No | 1119 |  | Serial No | 1112 | Serial No | 1120
Margin result |  | Margin result |  |  | Margin result |  | Margin result
Reg 3 |  |  |  |  | Reg 4
Serial No | 1113 | Serial No | 1115 |  | Serial No | 1122 | Serial No | 1118
Margin result |  | Margin result |  |  | Margin result |  | Margin result
Reg 5 |  |  |  |  | Reg 6
Serial No | 1116 | Serial No | 1123 |  | Serial No | 1117 | Serial No | 1121
Margin result |  | Margin result |  |  | Margin result |  | Margin result
Spreadsheet: 126246d1319582509-excel-2007-excel-2007-data-sorting-formula-help-excel-help
Sheet: Sheet1

 |  |  |  |  |  | 2011-01-01 00:00:00
 |  |  |  | Production by Well | Well 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 3 | 3 | 3 | 5 | 5 | 6 | 7 | 0 | 0 | 9
 |  |  |  |  | Well 2 | 0 | 2 | 2 | 2 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 6
 |  |  |  |  | Well 3 | 0 | 0 | 0 | 0 | 6 | 6 | 6 | 5 | 5 | 5 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 0 | 0 | 0 | 9
 |  |  |  |  | Well 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 4 | 4 | 4 | 4 | 6 | 0 | 0 | 0 | 7 | 7 | 7
 |  |  |  |  | Well 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 5 | 6
 |  |  |  |  | Well 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3 | 4 | 5 | 6 | 0 | 3 | 3 | 5 | 6
Spreadsheet: 70406d1271169251-cumulative-summing-book2
Sheet: Sheet1

 | Month | Feb
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct
 | Sales | 100 | 150 | 200 | 130 | 120 | 100 | 80 | 50 | 567 | 400
 | YTD Sales
 | If I change the C5, can the sales number will be cummulative till that month. For e,g - Till Feb YTD sales will be 250 and If I want to change the Month as Apr then YTD sales will be 580
Spreadsheet: 35448d1233055142-copying-hyperlinks-december-2008-excel-forum-daily-accts
Sheet: 1(a)

Incomes |  |  |  |  |  |  | 1(a)
beginning of | 1(a) | december 2008
Name of Company | Money X | Money Y | Total
[NAME] | 0 | 0 | 0 |  |  | [NAME] | A5 | B16 | C16 | F16
Вагриус книги | 0 | 0 | 0 |  |  | Вагриус книги | A20 | B32 | C32 | F32
Вагриус правда | 0 | 0 | 0 |  |  | Вагриус правда | A36 | B48 | C48 | F48
Вагриус минус | 0 | 0 | 0 |  |  | Вагриус минус | A52 | B64 | C64 | F64
Плюс-минус | 0 | 0 | 0 |  |  | Плюс-минус | A68 | B80 | C80 | F80
Издательство Вагриус | 0 | 0 | 0 |  |  | Издательство Вагриус | A84 | [NAME] | C96 | F96
Вагриус плюс-минус | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A100 | B112 | C112 | F112
Общий Итог: | 0 | 0 | 0 |  |  |  |  | B115 | C115 | F115
 |  |  |  |  |  | [NAME] | A122 | B134 | C134 | F134
 |  |  |  |  |  | Вагриус книги | A138 | B150 | C150 | F150
 |  |  |  |  |  | Вагриус правда | A154 | B166 | C166 | F166
Expenditures |  |  |  |  |  | Вагриус минус | A170 | B182 | C182 | F182
end of | 1(a) | december 2008 |  |  |  | Плюс-минус | A186 | B198 | C198 | F198
Name of Company | Money X | Money Y | Total |  |  | Издательство Вагриус | A202 | B214 | C214 | F214
[NAME] | 79045 | 0 | 79045 |  |  | Вагриус плюс-минус | A218 | B230 | C230 | F230
Вагриус книги | 0 | 0 | 0 |  |  |  |  | B233 | C233 | F233
Вагриус правда | 415.34 | 0 | 415.34
Вагриус минус | 0 | 0 | 0
Плюс-минус | 0 | 0 | 0
Издательство Вагриус | 0 | 0 | 0
Вагриус плюс-минус | 0 | 0 | 0
Общий Итог: | 79460.34 | 0 | 79460.34
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -582808 | -589587
2 | -491131 | -493683
3 | -483505 | -493167
4 | -445803 | -487144
5 | -518969 | -516271
6 | -574375 | -598988
7 | -558264 | -565744
8 | -579105 | -609898
9 | -573367 | -599107
10 | -609561 | -607106
11 | -611554 | -604165
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 78487
2002-03-11 00:00:00
CBS Dollars
 |  |  | 277487
Spreadsheet: 94566d1294341010-a-simpler-way-to-do-nested-vlookups-capital-plan-help
Sheet: Proj Detail Report

 |  |  |  | Contact Person
 |  |  |  | Department
 |  |  |  | Type of Project
 |  |  |  | Useful Life
 |  |  |  | Category
 |  |  |  | Priority
 |  |  |  | Total Expenditures
 | Capital Improvement Plan
 | City of Washington City, Utah
 | Date of Completion
 | Project Name | test
 | Project Number
 | Description
 | Justification
 | [NAME] | Amount | Year
 |  |  |  | Expenditure #1 | Expenditure #1 Amount | Date of Expenditure #1
 |  |  |  | Expenditure #2 | Expenditure #2 Amount | Date of Expenditure #2
 |  |  |  | Expenditure #3 | Expenditure #3 Amount | Date of Expenditure #3
 |  |  |  | Expenditure #4 | Expenditure #4 Amount | Date of Expenditure #4
 |  |  |  | Expenditure #5 | Expenditure #5 Amount | Date of Expenditure #5
 |  |  |  | Expenditure #6 | Expenditure #6 Amount | Date of Expenditure #6
 |  |  |  | Expenditure #7 | Expenditure #7 Amount | Date of Expenditure #7
 |  |  |  | Expenditure #8 | Expenditure #8 Amount | Date of Expenditure #8
 |  |  |  | Expenditure #9 | Expenditure #9 Amount | Date of Expenditure #9
 |  |  |  | Expenditure #10 | Expenditure #10 Amount | Date of Expenditure #10
 | Total Expenditures | 2011 | 2012 | 2013 | 2014 | 2015
 | Funding Source Detail | Amount | Year
 |  |  |  | Funding Source #1 | Funding Source #1 Amount | Date of Funding Source #1
 |  |  |  | Funding Source #2 | Funding Source #2 Amount | Date of Funding Source #2
 |  |  |  | Funding Source #3 | Funding Source #3 Amount | Date of Funding Source #3
 |  |  |  | Funding Source #4 | Funding Source #4 Amount | Date of Funding Source #4
 |  |  |  | Funding Source #5 | Funding Source #5 Amount | Date of Funding Source #5
 |  |  |  | Funding Source #6 | Funding Source #6 Amount | Date of Funding Source #6
 |  |  |  | Funding Source #7 | Funding Source #7 Amount | Date of Funding Source #7
 |  |  |  | Funding Source #8 | Funding Source #8 Amount | Date of Funding Source #8
 |  |  |  | Funding Source #9 | Funding Source #9 Amount | Date of Funding Source #9
 |  |  |  | Funding Source #10 | Funding Source #10 Amount | Date of Funding Source #10
 |  |  |  | Funding Source #11 | Funding Source #11 Amount | Date of Funding Source #11
 |  |  |  | Funding Source #12 | Funding Source #12 Amount | Date of Funding Source #12
 |  |  |  | Funding Source #13 | Funding Source #13 Amount | Date of Funding Source #13
 |  |  |  | Funding Source #14 | Funding Source #14 Amount | Date of Funding Source #14
 |  |  |  | Funding Source #15 | Funding Source #15 Amount | Date of Funding Source #15
 | Total Funding | 2011 | 2012 | 2013 | 2014 | 2015
Spreadsheet: 767431d1644477531-converting-source-data-to-simplified-data-pq-transform-investment-aligw
Sheet: Result

Item | Purpose Code | Institutional Sector | Country | Currency Code
DI | 39900 | FA | JP | USD
DI | 39900 | NF | AU | USD
DI | 39900 | NF | HK | USD
DI | 39900 | NF | KY | USD
DI | 39900 | NF | KY | USD
OT | 31220 | IC | AE | AED
OT | 31220 | IC | AE | EUR
OT | 31220 | IC | AE | SAR
Spreadsheet: 83319d1283324487-excel-2007-reports-across-tabs-dynamic-field-ranges-water5
Sheet: Data

Date | C25 | C46 | M25 | M45 | Total Sale
2010-08-31 00:00:00 | 9 | 59 | 19 | 6 | 36.25
2010-08-31 00:00:00 | 14 | 11 | 3 | 12 | 14.6
2010-08-31 00:00:00 | 10 | 0 | 20 | 25 | 18.75
2010-08-31 00:00:00 | 1 | 2 | 3 | 4 | 3.7
2010-08-31 00:00:00 | 17 | 83 | 32 | 153 | 118.45
Spreadsheet: 93895d1293658320-formula-for-sport-rankings-cagrapplerrankings2010
Sheet: 215

Ranking | First Name | Last Name | School | Section | Grade
1 | Tank | Knowles | Calvary Chapel | SS | 12
2 | [NAME] | Ferguson | Clovis | CS | 12 | zink 1
3 | Porfi | [NAME] | Poway | SD | 12 | reno 3
4 | Malique | Micenheimer | Mcnair | SJ | 12
5 | Hayden | Yacobucci | [NAME] | SS | 12 | reno 4
6 | [NAME] | Singer | Moorpark | SS | 11 | reno 6
7 | Scot | [NAME] | Mt. Pleasant | CC | 12
8 | Sean | Medley | [NAME] | CS | 10
9 | [NAME] | Lopez | Paramount | SS | 12
10 | Justin | Walker | De La Salle | NC | 11
11 | Will | [NAME] | Ukiah | NC | 12
Spreadsheet: d754b84f-99bd-4ee9-adf0-880e85dfbcd0
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
40903856 | 2014-04-08 20:10:49 | ALLIES | 1 | 6 | 2 | 701256 | player701256 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
40904257 | 2014-04-08 20:39:23 | AXIS | 0 | 5 | 6 | 939846 | Tristan710 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40904462 | 2014-04-08 20:55:51 | ALLIES | 0 | 5 | 6 | 939846 | Tristan710 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40918858 | 2014-04-09 21:42:04 | ALLIES | 1 | 5 | 4 | 1024653 | [NAME] | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
40919207 | 2014-04-09 21:55:12 | AXIS | 1 | 5 | 3 | 1024653 | [NAME] | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
41020537 | 2014-04-16 21:01:53 | ALLIES | 1 | 6 | 0 | 1249072 | player1249072 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
41020724 | 2014-04-16 21:22:35 | AXIS | 0 | 4 | 6 | 1249072 | player1249072 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 42843d1241480177-sort-by-largest-number-in-column-by-formula-function-rank
Sheet: Sheet1

Name | Number | rank unique | Answer
Emily | 10 | 5 | Havit | 40
Joliet | 20 | 4 | [NAME] | 30
[NAME] | 30 | 2 | [NAME] | 30
[NAME] | 30 | 3 | Joliet | 20
Havit | 40 | 1 | Emily | 10
Spreadsheet: 579037d1529650424-populate-list-from-the-master-list-no-vlookup-where-you-already-provide-the-1st-column-_generate-a-list-from-master-list
Sheet: Region

 |  | Region
 |  | West | << example: If we select "West" then all the cells from D9:F9 onwards should auto-populate based
 |  | Product | Region | Sales
 |  | Dynamic Heavy |  | 250
 |  | Dynamic Light |  | 206
 |  | Dynamic Medium |  | 238
 |  | Laser Heavy |  | 225
 |  | Laser Light |  | 242
 |  | Laser Medium |  | 245
 |  | Light [NAME] |  | 236
 |  | Light [NAME] |  | 207
 |  | Light Milli |  | 211
Spreadsheet: 668031d1584618552-cash-projection-with-date-delay-criteria-cash-projection-example
Sheet: Sheet1

 | Transaction Date
Provider | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
AMEX | 2 | 2 | 2 | 4 | 3 | 3 | 2 |  |  | i.e. if AMEX transaction date is Monday, then it takes +2 days for money to be received to account
Paypal | 3 | 3 | 5 | 5 | 5 | 4 | 3
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday
 | 2020-03-01 00:00:00 | 2020-03-02 00:00:00 | 2020-03-03 00:00:00 | 2020-03-04 00:00:00 | 2020-03-05 00:00:00 | 2020-03-06 00:00:00 | 2020-03-07 00:00:00 | 2020-03-08 00:00:00 | 2020-03-09 00:00:00 | 2020-03-10 00:00:00 | 2020-03-11 00:00:00 | 2020-03-12 00:00:00 | 2020-03-13 00:00:00 | 2020-03-14 00:00:00 | 2020-03-15 00:00:00 | 2020-03-16 00:00:00 | 2020-03-17 00:00:00 | 2020-03-18 00:00:00 | 2020-03-19 00:00:00 | 2020-03-20 00:00:00 | 2020-03-21 00:00:00 | 2020-03-22 00:00:00 | 2020-03-23 00:00:00 | 2020-03-24 00:00:00 | 2020-03-25 00:00:00 | 2020-03-26 00:00:00 | 2020-03-27 00:00:00 | 2020-03-28 00:00:00 | 2020-03-29 00:00:00 | 2020-03-30 00:00:00 | 2020-03-31 00:00:00
Sales - AMEX | 5000 | 10000 | 2000 | 4000 | 5000 | 7500 | 3500 | 2000 | 6000 | 7000 | 1500 | 4500 | 4000 | 3500 | 8000 | 6000 | 4000 | 4500 | 1000 | 5000 | 10000 | 6000 | 9000 | 8500 | 4500 | 6000 | 5000 | 3000 | 2500 | 10000 | 6500
Cash - AMEX (how it should be)
Cash - AMEX (formula)
Sales - Paypal
Cash -  Paypal
Spreadsheet: 36986aeb-cb7e-4fb2-8fc5-7b84361afde1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7100 | 39859 | Toni | [NAME] | ESP | 74 | 00:21:08 | 00:02:36 | 01:33:00 | 00:00:56 | 00:24:53 | 1 | [NAME]
7100 | 39860 | Ruben | Sánchez | ESP | 77 | 00:24:03 | 00:02:33 | 01:29:49 | 00:01:00 | 00:26:45 | 2 | 02:24:11
7100 | 39857 | [NAME] | Pellicer | ESP | 78 | 00:23:13 | 00:02:07 | 01:49:47 | 00:01:08 | 00:30:46 | 3 | 02:47:01
7100 | 47245 | [NAME] | [NAME] | BRA | 75 | 00:40:24 | 00:02:01 | 01:37:44 | 00:01:46 | 00:30:53 | 4 | 02:52:49
7100 | 39856 | Joaquin | Carrasco | ESP | 76 | 00:27:46 | 00:01:39 | 01:57:30 | 00:00:56 | [NAME] | 5 | 02:54:38
7100 | 47257 | Jorge | [NAME] | ESP | 79 | 00:29:12 | 00:01:31 | 01:55:09 | [NAME] | 00:41:46 | 6 | 03:09:28
Spreadsheet: 854196d1704166325-function-to-track-gain-loss-for-weight-bf-bmi-bone-mass-etc-body-measurement-tracker-bvj-
Sheet: Sheet1 (2)

DATE | WEIGHT | BF % | MUSCLE % | PROTEIN MASS lbs | B M I | BONE MASS lbs | VISCERAL INDEX | FAT MASS | METABOLIC AGE
2024-01-01 00:00:00 | 190.5 | 0.308 | 65.5 | 28.4 | 27.6 | 7.1 | 9 | 58.6 | 59
2024-01-15 00:00:00
2024-02-01 00:00:00
2024-02-15 00:00:00
2024-03-01 00:00:00
2024-03-15 00:00:00
2024-04-01 00:00:00
GOAL | 155 | 0.23 | <70 | <45 | <22 | >5.7 | 9 | <55 | <55
DIFFERENCE
Spreadsheet: 765838d1643635286-how-to-get-value-before-last-data-input-book1
Sheet: Sheet1

 | 1 | C | 3 |  |  |  | Old | New
 | 2 | A | 2 |  |  | C
 | 3 | B | 10 |  |  | A
 | 4 | A | 6 |  |  | B
 | 5 | C | 4
 | 6 | B | 9
 | 7 | A | 4
 | 8 | C | 6
 | 9 | B | 10
 | 10 | B | 10
 | 11 | C | 5
 | 12 | C | 4