tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 702579d1604419235-top-25-values-based-on-another-criteria-top-n-example-simplified
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | What I want to do: |  | List the top 25 values based on Price 2 for the entire year (period 1-12), then list them in column L with their respective value per month. And on the 26th row I need a "other" to show the complete sum per period.
List of data |  |  |  |  |  |  |  |  |  |  | based on Price 2
 |  |  |  |  |  |  |  |  |  |  | Price 1 | January | February | March | April | May | June | July | August | September | October | November | December
Item | month | Price 1 | price 2 | price 3 | price 4 |  |  |  |  | 1st
Item 1 | 1 | 100 | 90 | -30 | 60 |  |  |  |  | 2nd
Item 2 | 1 | 110 | 80 | -25 | 50 |  |  |  |  | 3rd
Item 1 | 2 | 120 | 60 | -30 | 60 |  |  |  |  | 4th
Item 4 | 1 | 100 | 90 | -30 | 60 |  |  |  |  | All other
Item 1 | 3 | 100 | 90 | -30 | 60
Item 3 | 1 | 100 | 90 | -30 | 60
Item 2 | 2 | 100 | 90 | -30 | 60 |  |  |  |  | Example of end result
Item 1 | 1 | 200 | 170 | -54 | 52 |  |  |  |  |  | based on Price 2 | 1
Item 2 | 1 | 300 | 250 | -70 | 180 |  |  |  |  |  | Price 1 | January | February | March | April | May | June | July | August | September | October | November | December
Item 1 | 2 | 600 | 500 | -100 | 400 |  |  |  |  | 1st | Item 3 |  | 0 | 0
Item 4 | 1 | 70 | 67 | -17 | 50 |  |  |  |  | 2nd | Item 1 | 300 | 940 | 100
Item 1 | 2 | 220 | 200 | -20 | 180 |  |  |  |  | 3rd | Item 2 | 410 | 100 | 300
Item 3 | 1 | 1500 | 1400 | -300 | 1100 |  |  |  |  | 4th | Item 4 | 170 | 0 | 0
Item 2 | 3 | 300 | 270 | -70 | 200 |  |  |  |  | All other | All other
 |  |  |  | Price 2 for selection
 |  |  |  |  | 1 | 2 | 3 | Total sum | Placement in list
 |  |  |  | Item 1 |  |  |  |  | 2
 |  |  |  | Item 2 |  |  |  |  | 3
 |  |  |  | Item 3 |  | 0 | 0 |  | 1
 |  |  |  | Item 4 |  | 0 | 0 |  | 4
 |  |  |  | Price 1 for presentation
 |  |  |  |  | 1 | 2 | 3 | Total sum
 |  |  |  | Item 3 |  | 0 | 0
 |  |  |  | Item 1
 |  |  |  | Item 2
 |  |  |  | Item 4 |  | 0 | 0
Spreadsheet: 172595d1344266704-pulling-multiple-lines-from-several-sheets-into-1-based-on-a-single-value-sample1
Sheet: Def-209

Note | Fund Allocated to/From | As Of Date | Amount Added to [NAME] | Amount Allocated out | New Running Total | Coresponding JE
 | RBC002 | 2011-08-03 00:00:00 | 157465 |  |  | JBC45L46 | 209
Spreadsheet: 700232d1603082898-how-to-add-calendar-days-but-exclude-holidays-to-current-date-example-problem
Sheet: Sheet1

Start date | calendar days to add | Result |  |  |  |  |  |  | 2020-10-26 00:00:00 | HOLIDAYS
2020-10-15 00:00:00 | 15 |  |  |  |  |  |  |  | 2020-11-02 00:00:00
 |  | [NAME]:J7)
 |  | =($A$2+$B$2)-COUNTIF($J$1:$J$7,">="&$A$2)+COUNTIF($J$1:$J$7,">"&A$2+$B$2)
 |  | =WORKDAY($A$2,$B$2,$J$1:$J$7)
 |  | =WORKDAY.INTL($A$2,$B$2,"0000000",$J$1:$J$7)+WORKDAY($A$2,1,$J$1:$J$7)-$A$2
 |  |  | better but not accurate if days to add is 8
 |  | =WORKDAY(A2+(B2-1),1,holidays)
 |  |  | better but not accurate if [NAME] date is 19/10/20
 |  | =WORKDAY(WORKDAY.INTL(A2,B2,"0000000",holidays),1,holidays)
Spreadsheet: 882367d1730736382-ranking-points-for-tied-positions-skittler62-order-of-merit-365-aligw
Sheet: Signature

 | RANKING | PLAYER | EVENT 1 |  |  | EVENT 2 |  |  | EVENT 3 |  |  | EVENT 4 |  |  | EVENT 5 |  |  | EVENT 6 |  |  | EVENT 7 |  |  | EVENT 8 |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Points
 | 1 | Justin Derby |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 2 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | 3 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 4 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | 5 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | 6 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | 7 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | 8 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | 9 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tblData = B5:E15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tblPoints = G5:H10
Spreadsheet: 828622d1683643695-while-using-xlookup-the-first-2-lines-work-than-it-stops-testboox
Sheet: ElecticityIn

Datum | value (kWh)
2022-01-01 01:00:00 | 0.01 |  | Test waarde, moet 0 zijn
2022-01-01 02:00:00 | 0.02 |  | Test waarde, moet 0 zijn
2022-01-01 03:00:00 | 0.03 |  | Test waarde, moet 0 zijn
2022-01-01 04:00:00 | 0.04 |  | Test waarde, moet 0 zijn
2022-01-01 05:00:00 | 0
2022-01-01 06:00:00 | 0
2022-01-01 07:00:00 | 0
2022-01-01 08:00:00 | 0
2022-01-01 09:00:00 | 0
2022-01-01 10:00:00 | 0
2022-01-01 11:00:00 | 0
2022-01-01 12:00:00 | 0
2022-01-01 13:00:00 | 0
2022-01-01 14:00:00 | 0
2022-01-01 15:00:00 | 0
2022-01-01 16:00:00 | 0
2022-01-01 17:00:00 | 0
2022-01-01 18:00:00 | 0
2022-01-01 19:00:00 | 0
2022-01-01 20:00:00 | 0
2022-01-01 21:00:00 | 0
2022-01-01 22:00:00 | 0
2022-01-01 23:00:00 | 0
2022-01-02 00:00:00 | 0
2022-01-02 01:00:00 | 0
2022-01-02 02:00:00 | 0
2022-01-02 03:00:00 | 0
2022-01-02 04:00:00 | 0
2022-01-02 05:00:00 | 0
2022-01-02 06:00:00 | 0
2022-01-02 07:00:00 | 0
Spreadsheet: d248b4cb-5ab9-4047-ac79-419d863c10cb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3547 | 10330 | Ulrike | Striednig | AUT | 10 | 00:19:12 | 00:00:49 | 00:22:01 | 00:01:08 | 00:25:59 | 1 | 01:09:11
3547 | 15679 | Sabine | Houdek | GER | 9 | 00:22:04 | 00:00:56 | 00:27:08 | 00:00:59 | 00:27:44 | 2 | 01:18:56
Spreadsheet: 588062d1535465611-trying-to-condense-daily-shipping-to-semi-weekly-based-on-a-variety-of-shared-locations-shipping-example-revised
Sheet: Data

Shipment Date | Tracking ID | Net Charge Amount | Recipient Name | Recipient Address Line 1
2018-04-09 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Office ABC
2018-04-10 00:00:00 | [PHONE] | 17.19 | Aoife [NAME] | Office ABC
2018-04-10 00:00:00 | [PHONE] | 17.9 | [NAME] | Office ABC
2018-04-10 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Office ABC
2018-04-11 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Office ABC
2018-04-17 00:00:00 | [PHONE] | 17.9 | [NAME] | Office ABC
2018-04-17 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Office ABC
2018-04-18 00:00:00 | [PHONE] | 17.9 | Aoife [NAME] | Office ABC
2018-04-24 00:00:00 | [PHONE] | 17.99 | Kieron Parra | Office ABC
2018-04-25 00:00:00 | [PHONE] | 17.99 | Kieron Parra | Office ABC
2018-04-27 00:00:00 | [PHONE] | 17.99 | Kieron Parra | Office ABC
2018-04-30 00:00:00 | [PHONE] | 18.03 | [NAME] | Office ABC
2018-04-30 00:00:00 | [PHONE] | 18.03 | Kieron Parra | Office ABC
2018-04-09 00:00:00 | [PHONE] | 17.9 | [NAME] | Office JKL
2018-04-09 00:00:00 | [PHONE] | 17.9 | [NAME] | Office JKL
2018-04-11 00:00:00 | [PHONE] | 17.9 | [NAME] | Office JKL
2018-04-17 00:00:00 | [PHONE] | 17.9 | [NAME] | Office JKL
2018-04-18 00:00:00 | [PHONE] | 17.9 | [NAME] | Office JKL
2018-04-18 00:00:00 | [PHONE] | 17.9 | Mila Pearce | Office JKL
2018-04-27 00:00:00 | [PHONE] | 17.99 | [NAME] | Office JKL
2018-04-09 00:00:00 | [PHONE] | 12.74 | [NAME] | Office XYZ
2018-04-10 00:00:00 | [PHONE] | 17.9 | Evie-Rose O'Moore | Office XYZ
2018-04-11 00:00:00 | [PHONE] | 12.74 | Evie-Rose O'Moore | Office XYZ
2018-04-12 00:00:00 | [PHONE] | 12.74 | [NAME] | Office XYZ
2018-04-12 00:00:00 | [PHONE] | 12.74 | [NAME] | Office XYZ
2018-04-17 00:00:00 | [PHONE] | 12.74 | Faye Hendricks | Office XYZ
2018-04-18 00:00:00 | [PHONE] | 12.74 | Tess Emery | Office XYZ
2018-04-18 00:00:00 | [PHONE] | 12.74 | [NAME] | Office XYZ
2018-04-18 00:00:00 | [PHONE] | 12.74 | Faye Hendricks | Office XYZ
2018-04-18 00:00:00 | [PHONE] | 12.74 | [NAME] | Office XYZ
2018-04-19 00:00:00 | [PHONE] | 12.74 | [NAME] | Office XYZ
2018-04-19 00:00:00 | [PHONE] | 17.9 | [NAME] | Office XYZ
2018-04-20 00:00:00 | [PHONE] | 17.19 | [NAME] | Office XYZ
2018-04-20 00:00:00 | [PHONE] | 12.74 | Faye Hendricks | Office XYZ
2018-04-24 00:00:00 | [PHONE] | 17.27 | Tess Emery | Office XYZ
2018-04-27 00:00:00 | [PHONE] | 12.8 | Faye Hendricks | Office XYZ
2018-04-27 00:00:00 | [PHONE] | 12.8 | Evie-Rose O'Moore | Office XYZ
Current Total Shipping Charges:
Spreadsheet: 723615d1615810903-vlook-or-countif-help-for-forumula-across-tabs-please-tracker-sheet
Sheet: ONE

organisation |  | Name |  | email address | account Y/N | Name | email | Manager
home |  | Mr bloggs |  | [EMAIL]
home |  | mrs bloggs |  | [EMAIL]
far |  | mr bloggs 2 |  | [EMAIL]
far |  | mr bloggs 3 |  | [EMAIL]
island |  | [NAME] |  | [EMAIL]
beach |  | [NAME] |  | [EMAIL]
beach |  | [NAME] paste |  | [EMAIL]
beach |  | sandra p |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | If the email address in column B of tab CSP matches any email address in column E of tab MT, see if the user type in column D of CSP tab is OA, if it is, put YES into  column G of sheet MT into column . Also put the managers name from column E tab CSP into column I tab CSP
Spreadsheet: 850943d1701247965-excel-indirect-demotest
Sheet: Quant Small Cap Fund

Period Invested for | ₹10000 Invested on | Latest Value | Absolute Returns | Annualised Returns | [NAME] | Rank within Category
1 Week | 45251 | 10175.5 | 0.0175 | - | 0.18% | 1/24
1 Month | 45226 | 10918.4 | 0.0918 | - | 7.27% | 4/25
3 Month | 45166 | 10888.5 | 0.0888 | - | 9.42% | 12/24
6 Month | 45072 | 12878.8 | 0.2879 | - | 26.29% | 9/24
YTD | 44925 | 13491.3 | 0.3491 | - | 34.73% | 14/24
1 Year | 44893 | 13793.5 | 0.3794 | 37.94% | 32.40% | 5/23
2 Year | 44526 | 15434.2 | 0.5434 | 24.16% | 19.67% | 3/23
3 Year | 44162 | 31086.1 | 2.1086 | 45.89% | 34.85% | 1/21
5 Year | 43432 | 40032.9 | 3.0033 | 31.95% | 24.92% | 1/16
10 Year | 41606 | 56662.3 | 4.6662 | 18.93% | 23.40% | 10/10
Since Inception | 41281 | 60697.8 | 5.0698 | 18.00% | 23.34% | 20/25
Spreadsheet: 150915d1334732595-sorting-cells-and-deleting-duplicates-except-for-first-instance-sample2
Sheet: Sheet1

Start | Finish |  | S Duplicate | F Duplicate |  | S2 | F2 |  | S3 | [NAME]
04:30:00 | 14:00:00
05:55:00 | 12:30:00
05:30:00 | 15:30:00
20:25:00 | 12:30:00
05:30:00 | 14:30:00
20:31:00 | 21:30:00
05:30:00 | 14:30:00
21:30:00 | 21:31:00
05:30:00 | 21:30:00
20:30:00 | 17:30:00
01:30:00 | 15:30:00
20:30:00 | 20:00:00
20:30:00 | 16:00:00
20:30:00 | 21:30:00
Sample Date |  |  | Calculates whether the data is a duplicate or not |  |  | Based on if it’s a duplicate or not this formula will either make the time read "00:00" or stay the same |  |  | Sorts the remaining data
 |  |  |  | One of these two is where the formulas are failing
Spreadsheet: 91429d1291154240-check-3-columns-for-2-criterion-sample
Sheet: Sheet1

desktop computer | laptop computer | netbook computer
Don’t own | 1 - 2 years | Don’t own
5 or more years | 3 - 4 years | Don’t own
5 or more years | Don’t own | 1 - 2 years
Don’t own | 1 - 2 years | Don’t own
5 or more years | 3 - 4 years | Less than a year
Less than a year | 1 - 2 years | Don’t own
5 or more years | 5 or more years | 5 or more years
5 or more years | 1 - 2 years | Don’t own
Spreadsheet: 271871d1382092841-formula-for-forecasting-orders-account-forecast-sheet-
Sheet: Cooking

Cooking Forecast |  |  |  | Period: | 7
 |  | Budget | 1000
 |  | Operational Day No | 1 | 2 |  |  | 3 |  | 4 | 5 | 6 | 7 |  |  | 8 | 9 | 10 | 11 | 12 |  |  | 13 | 14 | 15 | 16 | 17 |  |  | 18 | 19 | 20 | 21 | 22
Lookup | Category | Date | 2013-09-26 00:00:00 | 2013-09-27 00:00:00 | 2013-09-28 00:00:00 | 2013-09-29 00:00:00 | 2013-09-30 00:00:00 | 31 | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00 | 2013-10-14 00:00:00 | 2013-10-15 00:00:00 | 2013-10-16 00:00:00 | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | Total | Budget | [NAME]
 | Cooking Materials | Asda
Spreadsheet: 648123d1572886831-closest-match-with-multiple-criteria-3-criteria-sample-of-boxes-selection-sorted-
Sheet: Sheet1

 |  |  | Box | Dimension 1 | Dimension 2 | Dimension 3
 | C2 | EF | Box5 | 600 | 400 | 320 |  |  | C2
 | C2 | SN | Box2 | 600 | 400 | 335
 | C2 | SN | Box3 | 600 | 400 | 400
 | C2 | SN | Box4 | 600 | 400 | 400 | 30.26
 | C2 | SN | Box1 | 601.9799999999999 | 401.32 | 320.04 | 32
 | C1 | 600 | 400 | 420 | deep
 | C2 | 600 | 400 | 320 | deep
 | [NAME] | 600 | 400 | 220 | deep
 | C4 | 400 | 300 | 220 | deep
 | C5 | 300 | 200 | 170 | deep
 | C6 | 1000 | 600 | 414 | deep
 | MOCKUP |  |  |  |  |  |  |  | C2 | Box5
 | Closest match formula finds that the closest match for length is 600
 | This matches [NAME], Box3, Box4, Box5
 | Next closest match to width is 400
 | This matches [NAME], Box3, Box4, Box5
 | Next closest match is depth
 | This matches Box5 only
 | Therefore answer should be Box5
Spreadsheet: 79cc519d-477e-4d75-985c-6bf95817d379
Sheet: JAN

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-01-01 00:00:00 | TO | 2015-01-31 00:00:00 |  | MO. NO.: |  | 1
Holiday Pay |  |  |  | HP | 15
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 165 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  | HP | 7.5 |  | 7.5
 |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 11 |  | 12 |  | 13 |  | 14 |  | 15 | Time sheets due | 16 |  | 17
 |  | HP | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 25 |  | 26 |  | 27 |  | 28 |  | 29 | Pay day | 30
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 757134d1638037383-how-to-xlookup-if-the-search-keys-are-comma-separated-excelforum
Sheet: Sheet2

Product ID | Quantity |  |  |  | Search | Result
AB001 | 1209 |  |  |  | AB001,HN002
HN002 | 3407 |  |  |  | AB001
CN890 | 3340 |  |  |  | CN890
MK003 | 5600 |  |  |  | MK003,CN890
Spreadsheet: 62654d1263560872-advanced-if-find-or-left-right-formula-example
Sheet: Test

 | Long Description | Desired Description | [NAME] | Result
 | BKG 4.0 CL G 3210x2550 LS 28   PKGL NE | BKG 4.0 CL G 3210x2550 | Contains "LS" | Display the cell contains before the found word
 | BKG 6.0 CL G 6000x3210 JU 10   PKGL NE | BKG 6.0 CL G 6000x3210 | Contains "JU" | Display the cell contains before the found word
 | FOP 2.0 CL G 1920x1220 SS 100 | FOP 2.0 CL G 1920x1220 | Contains "SS" | Display the cell contains before the found word
 | FOR 4.0 CL G 2140x1320 SS 20 E BROC | BROC | Contains "FOR" | 4 Characters from the right
 | RPA 4.0 CL G 2140x1320 SS 48 E AUTM | AUTM | Contains "RPA" | 4 Characters from the right
 | RGA 2.0 CL G 1840x1240 SS 90 E GALL | GALL | Contains "RGA" | 4 Characters from the right
 | 6.4mm [NAME] | 6.4mm [NAME] | Contains no known words | Returns the Cell value
Spreadsheet: 679840d1590654753-how-to-consolidate-duplicate-rows-and-sum-their-values-automatically-consolidate
Sheet: Sheet1

Meat | 140 |  |  | Meat | 140
Bread | 60 |  |  | Bread | 460 |  |  | `
Bread | 200 |  |  | Egg | 10
Egg | 10 |  |  | Oak | 100
Oak | 100 |  |  | Salt | 180
Salt | 150
Salt | 30
Bread | 200
Spreadsheet: 820653d1678214500-moving-average-excluding-zeroes-example
Sheet: Sheet1

Area | 1
Office | 0010
BDM/ROM | Doe, [NAME]
State | Maryland
Weekending
2023-01-07 00:00:00 | 45625
2023-01-14 00:00:00 | 53045
2023-01-21 00:00:00 | 43657
2023-01-28 00:00:00 | 57894
2023-02-04 00:00:00 | 50321
2023-02-11 00:00:00 | 58034
2023-02-18 00:00:00 | 65347
2023-02-25 00:00:00 | 48347
2023-03-04 00:00:00 | 0
2023-03-11 00:00:00 | 0
2023-03-18 00:00:00 | 0
Spreadsheet: 716356d1612185475-retrieve-filtered-rows-from-one-table-into-another-tables-sample
Sheet: Sheet1

id | region | quantity |  | northerns |  | Northerns | Quantity | Height |  | ID |  | QTY
1 | North | 100 |  |  |  | 1 |  |  |  |  | North | 100
2 | North | 200 |  |  |  | 2 |  |  |  | 2 | North | 200
3 | North | 100 |  |  |  | 4 |  |  |  | 3 | North | 100
4 | North | 300 |  |  |  | 7 |  |  |  | 4 | North | 300
5 | South | 100 |  |  |  | 8 |  |  |  | 7 | North | 500
6 | South | 400 |  |  |  | 9 |  |  |  | 8 | North | 100
7 | North | 500 |  |  |  | 11 |  |  |  | 9 | North | 200
8 | North | 100 |  |  |  | 14 |  |  |  | 11 | North | 300
9 | North | 200 |  |  |  | 15 |  |  |  | 14 | North | 500
10 | South | 100 |  |  |  | 16 |  |  |  | 15 | North | 100
11 | North | 300 |  |  |  | 18 |  |  |  | 16 | North | 200
12 | South | 100 |  |  |  | 21 |  |  |  | 18 | North | 300
13 | South | 400 |  |  |  |  |  |  |  | 21 | North | 500
14 | North | 500
15 | North | 100
16 | North | 200
17 | South | 100
18 | North | 300
19 | South | 100
20 | South | 400
21 | North | 500
source table
Spreadsheet: 138481d1327680389-importing-excel-data-into-outlook-calendar-example
Sheet: Sheet1

PURCHASE ORDERS
# | Size | Sup. | Ship | ü | Rec. Date
 |  | PHL
704 | 32 | NW | 02/14/12
 |  | PHL
1000 | BR | Moerings | 2012-01-02 00:00:00
 |  | PHL
1000 | BR | Moerings | 2012-01-02 00:00:00
 |  | PHL
 |  | PHL
 |  | PHL
2016 | 72 | AGStarts | 2012-01-02 00:00:00
792 | 72 | AGStarts | 2012-01-02 00:00:00
792 | 72 | AGStarts | 2012-01-02 00:00:00
72 | 72 | AGStarts | 2012-01-02 00:00:00
1152 | 72 | AGStarts | 2012-01-02 00:00:00
1152 | 72 | AGStarts | 2012-01-02 00:00:00
72 | 72 | AGStarts | 2012-01-02 00:00:00
1440 | 72 | AGStarts | 2012-01-02 00:00:00
3960 | 72 | Holt | 02/15/2012
1872 | 72 | Holt | 02/15/2012
3888 | 72 | Deroose | 2012-01-03 00:00:00
792 | 72 | AG-3 | 2012-01-02 00:00:00
432 | 72 | NW | 02/14/2012
 |  | PHL
720 | 72 | [NAME] | 2012-10-02 00:00:00
Spreadsheet: 0120cf67-c770-4ec7-b1a5-2707dcac9bbd
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
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 16. PERIOD AVERAGE EXCHANGE RATES, Units of Foreign Currency per Australian Dollar
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Euro ; |  |  | Original | A1829846V | 1978-07-01 00:00:00 | 2009-06-01 00:00:00 | 372 | $ | INDEX | Month | 1
[NAME] ; |  |  | Original | A1829847W | 1978-07-01 00:00:00 | 2009-06-01 00:00:00 | 372 | $ | INDEX | Month | 1
United States Dollar ; |  |  | Original | A1829844R | 1978-07-01 00:00:00 | 2009-06-01 00:00:00 | 372 | $ | INDEX | Month | 1
United Kingdom Pound ; |  |  | Original | A1829845T | 1978-07-01 00:00:00 | 2009-06-01 00:00:00 | 372 | $ | INDEX | Month | 1
Special Drawing Right ; |  |  | Original | A1829848X | 1978-07-01 00:00:00 | 2009-06-01 00:00:00 | 372 | $ | INDEX | Month | 1
Trade Weighted Index ; |  |  | Original | A1829849A | 1978-07-01 00:00:00 | 2009-06-01 00:00:00 | 372 | $ | INDEX | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 787195d1657680248-excel-formula-not-carrying-down-correctly-using-wrong-intervals-of-rows-sample-sheet-formula
Sheet: Option 1 Percentage Summary

PM | January |  | February |  | March |  | April
 | Mid Month (14th) | Month | Mid Month (14th) | Month | Mid Month (15th) | Month | Mid Month (15th) | Month
 | -0.0389 | -0.4006 | -0.15 | -0.4967 | N/A | N/A | N/A | N/A
 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
AVERAGE
Spreadsheet: 126070d1319505624-need-help-in-excel-sumifs-match-potential-rent
Sheet: Summary

Search Engine
Search For Ranking: | 4
Result Development:
Summary Statistics
Apartment Complex | Total Units | Occupied Units | Occupancy Rate | Rank by [NAME] | Potential Rent | Actual Rent | % of Potential Rent
Lakeview Apartments
Mountaintop View
Oak Tree Living
[NAME]
Sunset Valley
 |  |  |  |  | Total Rent:
List of Rental Property
Seq No. | Apartment Complex | Unit # | # Bed | Rental Price | Occupied | [NAME] | Recommendation
1 | [NAME] | 101 | 1 | 750 | Yes | 2004
2 | Lakeview Apartments | 11 | 1 | 875 | No | 2008
3 | Lakeview Apartments | 12 | 1 | 875 | No | 2001
4 | Mountaintop View | A | 1 | 875 | No | 2004
5 | Mountaintop View | B | 2 | 950 | No | 2010
6 | Mountaintop View | C | 3 | 1200 | Yes | 2010
7 | Sunset Valley | 101 | 1 | 550 | Yes | 2010
8 | Sunset Valley | 102 | 1 | 550 | No | 2010
9 | Sunset Valley | 103 | 1 | 550 | No | 2003
10 | Sunset Valley | 201 | 1 | 550 | Yes | 2003
11 | Oak Tree Living | 21 | 1 | 1000 | Yes | 2004
12 | Oak Tree Living | 22 | 1 | 1000 | Yes | 2004
13 | Oak Tree Living | 23 | 2 | 1200 | No | 2004
Spreadsheet: 137009d1326909602-indirect-function-copy-of-qa-tracking-sheet
Sheet: Summary

 | Name | Qad | Perfect Entries | Mistakes | [NAME]
 | [NAME] | 0 | 0 | 0
 | Tamar | 4 | 3 | 1 | 0.75
 | Frost | 0 | 0 | 0
 | Abu | 1 | 1 | 0 | 1
 | Fetter | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0
 | Porsa | 0 | 0 | 0
 | Julie | 0 | 0 | 0
 | Nors | 0 | 0 | 0
 | Team Total: | 5 | 4 | 1 | 0.875
 | Date | Count
 | 2012-01-01 00:00:00 | 0
 | 2012-01-02 00:00:00 | 0
 | 2012-01-03 00:00:00 | 0
 | 2012-01-04 00:00:00 | 0
 | 2012-01-05 00:00:00 | 0
 | 2012-01-06 00:00:00 | 0
 | 2012-01-07 00:00:00 | 0
 | 2012-01-08 00:00:00 | 0
 | 2012-01-09 00:00:00 | 0
 | 2012-01-10 00:00:00 | 0
 | 2012-01-11 00:00:00 | 0
 | 2012-01-12 00:00:00 | 2
 | 2012-01-13 00:00:00 | 0
 | 2012-01-14 00:00:00 | 0
 | 2012-01-15 00:00:00 | 0
 | 2012-01-16 00:00:00 | 0
 | 2012-01-17 00:00:00 | 0
 | 2012-01-18 00:00:00 | 2
 | 2012-01-19 00:00:00 | 0
 | 2012-01-20 00:00:00 | 0
 | 2012-01-21 00:00:00 | 0
 | 2012-01-22 00:00:00 | 0
 | 2012-01-23 00:00:00 | 0
 | 2012-01-24 00:00:00 | 0
 | 2012-01-25 00:00:00 | 0
 | 2012-01-26 00:00:00 | 0
 | 2012-01-27 00:00:00 | 0
 | 2012-01-28 00:00:00 | 0
 | 2012-01-29 00:00:00 | 0
 | 2012-01-30 00:00:00 | 0
 | 2012-01-31 00:00:00 | 0
 | Total: | 4