tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883907d1732674622-lambda-and-xlookup-issue-excel-sumif-let-riddle
Sheet: Sheet1

Raw data |  |  |  |  |  |  |  | Named ranges
Fruits | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  |  | References | Name
Apples | 2229 | 2366 | 2623 | 2878 | 3001 |  |  | A3:F4 | tblData
Pears | 700 | 849 | 1140 | 1294 | 1568 |  |  | A4:A14 | lstFruits
[NAME] | 0 | 0 | 0 | 0 | 0 |  |  | A18:D20 | tblBundles
Bananas | 176 | 184 | 219 | 224 | 226 |  |  | A18:A20 | lstBundles
Peaches | 7 | 8 | 9 | 10 | 10
Cherries | 296 | 207 | 205 | 217 | 222
Tomatoes | 155 | 158 | 161 | 164 | 168
Dates | 383 | 390 | 397 | 444 | 451
Nuts | 0 | 23 | 46 | 35 | 89
Raspberries | 4511 | 5622 | 7732 | 8966 | 11132
Strawberries | 11877 | 12088 | 15770 | 16041 | 18154
Bundles
Name | Includes
Red | Strawberries | Raspberries | Cherries | Tomatoes
Yellow | Pears | Apples | Peaches
Dry | Nuts | [NAME] | Dates
Reports
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- This solution works great enough, but I am looking to simplify it even more.
Red |  |  |  |  | =SUM(SUMIFS(B$4:B$14,lstFruits,FILTER(tblBundles,lstBundles=$A25,0)))
Yellow |  |  |  |  | Look in January data,in the list of fruits and sum if fruit is included in the bundle filtered to the bundle color.
Dry
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- I'd love to have a clean LET function, pass the ranges for months and bundle names to a LAMBDA function
Red |  |  |  |  | and spill the values in the table. I banged my head on the SUMIF only accepting ranges issue for days…
Yellow |  |  |  |  | Can I use the same FILTER approach, and use a LAMBDA to SUM all the XLOOKUP values for each fruit?
Dry |  |  |  |  | I've failed so far…
Spreadsheet: 82033d1282097292-custom-formula-in-pivot-table-sample
Sheet: Data

Country | Visit | Time
Australia | 30 | 1230
Brazil | 12 | 3320
China | 15 | 2019
Denmark | 19 | 2837
China | 21 | 2817
England | 22 | 2819
France | 8 | 2768
Germany | 11 | 3918
England | 22 | 2850
Spreadsheet: john_forney__15509__ImbalErcot
Sheet: 8-1

 |  |  | August 1st Imbalance Charges
 | Hour Ending | N-Price | S-Price | W-Price | Ercot Asset | Asset Expense | Asset Revenue | Teco | Teco revenue
 | 0100 |  |  |  | 0
 | 0200 |  |  |  | 0
 | 0300 |  |  |  | 0
 | 0400 |  |  |  | 0 |  |  | 45
 | 0500 |  |  |  | 0 |  |  | 145
 | 0600 |  |  |  | 0
 | 0700 |  |  |  | 50
 | 0800 |  |  |  | 50
 | 0900 |  |  |  | 50
 | 1000 |  |  |  | 50
 | 1100 |  |  |  | 0
 | 1200 |  |  |  | 50
 | 1300 |  |  |  | 0
 | 1400 |  |  |  | 0
 | 1500 |  |  |  | 0
 | 1600 |  |  |  | 0
 | 1700 |  |  |  | 0
 | 1800 |  |  |  | 0
 | 1900 |  |  |  | 0
 | 2000 |  |  |  | 0
 | 2100 |  |  |  | 50
 | 2200 |  |  |  | 50
 | 2300 |  |  |  | 0
 | 2400 |  |  |  | 0
 | Total
 | % of Total
 | 16 HR Price
 | Off-Peak Price
 | 24 HR Price
Spreadsheet: 5ce444d9-c4e2-4724-8bcf-1fee0ea11da1
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
43226294 | 2014-09-19 20:01:17 | AXIS | 1 | 6 | 0 | 1606900 | Nanaimo | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43226630 | 2014-09-19 20:11:59 | ALLIES | 1 | 6 | 0 | 1606900 | Nanaimo | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43226768 | 2014-09-19 20:30:07 | AXIS | 1 | 4 | 0 | 1606900 | Nanaimo | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
43226972 | 2014-09-19 20:38:51 | ALLIES | 1 | 4 | 1 | 1606900 | Nanaimo | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
43269307 | 2014-09-22 19:47:48 | ALLIES | 0 | 5 | 6 | 1606900 | Nanaimo | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
43293891 | 2014-09-24 14:24:22 | AXIS | 0 | 2 | 7 | 364821 | Quit | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43310560 | 2014-09-25 20:02:19 | AXIS | 1 | 10 | 5 | 818064 | arhy | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43311063 | 2014-09-25 20:34:52 | ALLIES | 0 | 8 | 10 | 818064 | arhy | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43363814 | 2014-09-29 13:27:36 | AXIS | 0 | 1 | 6 | 364821 | Quit | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43363896 | 2014-09-29 13:40:52 | ALLIES | 0 | 0 | 6 | 364821 | Quit | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 708430d1607825178-add-vlookup-function-containing-match-statement-to-one-sheet-from-another-order-template
Sheet: Product Code

 | Bulk | MB | 25kg |  |  |  | Blend | 46-0-0 UREA
46-0-0 UREA | 7110101 | 7110102 | 7110103 |  |  |  | Unit [NAME] | Bulk
0-0-62 MOP COARSE GRADE | 7112151 | 7112152 | 7112153 |  |  |  | Product No.
40-0-0+5.5S UREA-SOL BLEND | 7121361 | 7121362 | 7121363
Spreadsheet: 1bcf3f4c-06a8-4ecd-a124-db4c3609eb86
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Sewer Availability Charge (SAC)
 | 2014 ACTIVITY SUMMARY REPORT
 |  |  |  | Customer Community
 |  |  |  | Reporting Period (month or quarter) |  |  | Year
 | Attach Form MCES |  | SECTION 1 - Full SAC Rate |  |  |  | Building/Sewer Permit Units | Offsetting Credit Units | Net SAC (Allowable Net Credits Entered on Line Below)
 | SAC-B |  | Single Family Dwelling
 |  |  | Multi-Family (includes duplex, townhome, condo, assisted living)
 |  |  | Apartment (with individual laundry connections or no central laundry)
 | SAC-C | or Determination Letter w/Permit Info | Residential/Commercial Combination (residential and commercial mixed building)
 |  |  | Commercial
 |  |  | Institutional/Governmental
 |  |  | Industrial (those industries permitted with MCES only)
 |  |  |  |  |  |  |  | Sub-Total SAC Units Section 1: | 0
 | Attach Form MCES |  | [NAME] |  |  |  | Building/Sewer Permit Units | Offsetting Credit Units | Net SAC (Allowable Net Credits Entered on Line Below)
 |  |  | Must receive prior written approval from MCES
 | SAC-B, SAC-C or Determination | Letter and MCES Approval | Apartment (without individual laundry connections)
 |  |  |  |  |  |  |  | x 80% (to receive 20% discount):  =
 |  |  | Publicly-Assisted Housing (without garbage disposals or dishwashers)
 |  |  |  |  |  |  |  | x 75% (to receive 25% discount):  =
 |  |  | Publicly-Assisted Housing (without individual laundry connections, garbage disposals
 |  |  | or dishwashers) |  |  |  |  | x 60% (to receive 40% discount):  =
 |  |  | Apartment/Condo Conversion (converting a discounted apartment to a condominium
 |  |  | or non-discounted apartment) |  |  |  |  | x 20%:  =
 |  |  |  |  |  |  |  | Sub-Total SAC Units Section 2: | 0
 |  |  |  |  | 0 |  |  | Net SAC Units from Section 1 + Section 2: | 0
 |  |  |  |  |  |  |  | MCES SAC Deferral Original Payment(s) (attach MCES SAC-E Form) :
 |  |  |  |  |  |  |  | Net SAC Unit Credit Balance from Previous Reporting Period:   -
 |  |  |  |  |  |  |  | Allowable Net Credits (Only from SAC Paid) to be taken Community-Wide:   -
 |  |  |  |  |  |  |  | Sub-Total SAC Units : | 0
 |  |  |  |  |  |  |  | Enter Current SAC Rate:   x
 |  |  |  |  |  |  |  | Sub-Total SAC Amount Due: | 0
 |  |  |  |  |  |  |  | 1% Discount for Prompt Payment:   - | 0
 |  | MCES must receive payment within 30 days of the end of |  |  |  |  |  | Sub-Total SAC Amount Due: | 0
 |  | the reporting period. Postmark date is not acceptable. |  |  |  |  |  | Adjustments (attach explanation) :   +
 |  |  |  |  |  |  |  | TOTAL AMOUNT DUE:
 |  |  |  |  |  | (*If Total Amount Due is a negative number, this is the net credit balance to carry forward on your next Activity Report.)
 |  |  |  |  |  | Activity Report prepared by:
 |  |  |  |  |  | (Name) |  |  | (Date)
 |  |  |  |  |  | (Title) |  |  | (Phone)
 |  |  |  | False
 |  |  |  |  |  | (E-mail Address)
Spreadsheet: 736897d1623936973-need-an-alternate-to-vlookup-book6
Sheet: Sheet1

Option1 Name | Option1 Value | SML
size | 4
size | 4
size | 3
size | 2
size | 4
size | 3
size | 1
size | 3
size | 3
size | 2
size | 2
size | 3
size | 2
size | 2
size | 3
size | 4
size | 1
size | 2
size | 1
size | 3
size | 2
size | 3
size | 3
size | 1
size | 2
size | 3
size | 2
size | 3
size | 1
size | 3
size | 2
size | 3
size | 1
size | 1
size | IT 40
size | IT 42
size | IT 42
size | IT 40
size | IT 46
size | IT 42
size | IT 44
size | IT 42
size | IT 44
size | IT 40
size | IT 42
size | IT 42
size | IT 46
size | IT 40
size | IT 37
size | IT 44
size | IT 42
size | IT 40
size | IT 44
size | IT 46
size | IT 36
size | IT 37
size | IT 36
size | FR 36
size | FR 38
size | M
size | FR 38
size | FR 38
size | FR 36
size | FR 36
size | FR 38
size | FR 42
size | FR 42
size | FR 38
size | FR 38
size | FR 36
size | FR 36
size | FR 38
size | FR 42
size | FR 36
size | FR 36
size | FR 36
size | FR 42
size | IT 38
size | FR 38
size | FR 36
size | FR 40
size | L
size | S
size | M
size | FR 42
size | FR 36
size | FR 36
size | FR 40
size | FR 42
size | FR 42
size | FR 36
size | FR 38
size | FR 42
size | FR 44
size | FR 46
size | FR 44
size | FR 40
size | FR 38
size | FR 42
size | FR 44
size | FR 40
size | FR 38
size | FR 42
size | FR 46
size | FR 40
size | FR 44
size | FR 40
size | FR 44
size | FR 42
size | FR 42
size | FR 38
size | FR 40
size | FR 42
size | FR 42
size | FR 38
size | FR 38
size | FR 40
size | FR 38
size | FR 44
size | FR 40
size | FR 42
size | FR 42
size | FR 38
size | FR 40
size | FR 44
size | FR 40
size | FR 40
size | FR 46
size | L
size | XS
size | L
size | IT 44
size | IT 40
size | IT 44
size | IT 46
size | IT 40
size | IT 42
size | IT 46
size | IT 48
size | IT 42
size | IT 42
size | IT 42
size | IT 44
size | IT 46
size | IT 48
size | IT 42
size | IT 44
size | IT 42
size | IT 46
size | IT 48
size | IT 44
size | IT 48
size | IT 42
size | IT 46
size | IT 44
size | IT 42
size | IT 40
size | IT 44
size | IT 46
size | IT 48
size | IT 42
size | IT 44
size | IT 42
size | IT 40
size | IT 42
size | FR 38
size | FR 38
Spreadsheet: 89774d1289508595-pivot-table-and-count-number-sample
Sheet: Sheet1

Subject | Average of Open Rate
Download New & Classic Movies | 0.02062622051786989
Online Movie Ticket: HD Access - No Limits | 0.01945053870059523
You're Missing Out - But It's Not Too Late | 0.01837698100483309
New Movies Daily - Unlimited Downloads For Your PC | 0.01719201401171166
Stream & Download Movies For Your PC | 0.01694985212923127
New Movies Now Available - Free Online TV Included | 0.01649350855969142
Download HD Movies - Includes DVR Recorder | 0.01625497301676395
80 Million Movies in 5 Minutes | 0.01616187192163784
Download Your Favorite New HD Movies on your PC | 0.01576850602863654
Download From The Internet's Biggest Movie Library | 0.01531274263959726
Don't Be The Last One Again | 0.01507476497860981
Watch  Movies Online in HD | 0.01488171467771518
Access The Internet's Largest Movie Selection | 0.01465660774512444
Over 80 Million Movies Online - New Ones Added Daily | 0.01453841096870085
Stream 80 Million Movies To Your PC | 0.01432004315629444
You're Invited to the Online HD Movie Revolution | 0.01407003063069498
The Most Unbeatable HD Movie Selection Online | 0.01401055220260737
New Movie Downloads Available Now | 0.0138188627718798
80 million movies -Yeah, we know that's a lot | 0.01378633465086635
Download New Flicks & Classic Movies | 0.01291372466573068
Your 5 HD Movie Downloads of The Week | 0.01272968939134157
Hate 10$ [NAME] and Even Higher Priced Movie Tickets? | 0.01217500177025627
Experience Hassle-free HD Movie Downloads | 0.01213200690915077
No Monthly Charges - Instant HD Quality Downloads | 0.0114836636710506
The Best Alternative for Movie Downloads | 0.01134450389126991
Stream 80 Million Movies To Your PC | 0.01133478268085036
The Internet's Largest Movie Selection | 0.01040918510468279
Experience Hassle-free HD Movie Downloads | 0.009595298230490011
Download Movies Online - New Movies For Your PC | 0.008818337267011736
80 Million Movies To Download On Your PC | 0.0084600729613322
Download Movies Online - No Monthly Fees | 0.007554385975941585
[NAME]: 80 Million Movies For Your PC | 0.005038665762412605
Grand Total | 0.01375085299442194
Spreadsheet: 757577d1638348112-counting-cell-after-a-reference-point-and-restart-when-the-reference-point-is-meet-count-after-a-landmark-is-meet
Sheet: Sheet1

 | results
 |  |  |  | Counting cell after a refference point and restart when the refference point is meet.
 |  |  |  | A = refference point
RF | 3 |  |  | B = cells to count
7
B
B
D
B
F
RF | 2
G
B
23
B
N
25
RF | 5
B
R
B
10
B
B
M
B
RF | 1
B
15
Spreadsheet: 779765d1652090486-find-sum-of-overtime-worked-between-networkdays-and-holidays-in-a-month-overtime
Sheet: OVERTIME

YEAR : | 2022 | MONTH : | JANUARY
 |  |  |  |  |  |  |  |  | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00 | 2022-01-23 00:00:00 | 2022-01-24 00:00:00 | 2022-01-25 00:00:00 | 2022-01-26 00:00:00 | 2022-01-27 00:00:00 | 2022-01-28 00:00:00 | 2022-01-29 00:00:00 | 2022-01-30 00:00:00 | 2022-01-31 00:00:00
SL. NO | EMPLOYEE NO | EMPLOYEE NAME | DESIGNATION | DATE OF JOINING | [NAME] (NOT HOURS) | SUNDAY OVERTIME (SOT HOURS) | HOLIDAY OVERTIME (HOT HOURS) |  | 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
1 | 1001 | RICHARD | MANAGER | 2011-01-18 00:00:00 |  |  |  | 10 | 8 | 2 | 2 | 2 | 2 | 2 | 2 | 8 | 2 | 2 | 2 | 2 | 2 | 2 | 8 | 2 | 2 | 2 | 2 | 2 | 2 | 8 | 2 | 2 | 2 | 2 | 2 | 2 | 8 | 2
Spreadsheet: john_griffith__15871__11_12_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21.5 | 90 | 100 | 70.8 | 78.7 | 1.01 | 2001-11-12 10:54:00
 | CL F2 | 21.5 | 270 | 278 | 53.4 | 54.9 | 0.73 | 2001-11-12 10:54:00
 | CL G2 | 22 | 375 | 385 | 51.1 | 52.4 | 0.72 | 2001-11-12 10:54:00
 | CL H2 | 22 | 440 | 448 | 50 | 50.9 | 0.7 | 2001-11-12 10:54:00
 | CL J2 | 22 | 475 | 490 | 47.4 | 48.9 | 0.67 | 2001-11-12 10:54:00
 | CL K2 | 22 | 508 | 523 | 45.2 | 46.5 | 0.63 | 2001-11-12 10:54:00
 | CL M2 | 22 | 535 | 550 | 43.9 | 45.2 | 0.62 | 2001-11-12 10:54:00
 | CL N2 | 22 | 555 | 570 | 42.2 | 43.4 | 0.59 | 2001-11-12 10:54:00
 | CL Q2 | 22 | 560 | 580 | 40.1 | 41.5 | 0.56 | 2001-11-12 10:54:00
 | CL U2 | 22 | 565 | 585 | 38.4 | 39.8 | 0.54 | 2001-11-12 10:54:00
 | [NAME] | 21.5 | 565 | 585 | 37.3 | 38.7 | 0.51 | 2001-11-12 10:54:00
 | CL X2 | 21.5 | 565 | 590 | 35.8 | 37.4 | 0.49 | 2001-11-12 10:54:00
 | [NAME] | 21.5 | 565 | 590 | 34.5 | 36.1 | 0.48 | 2001-11-12 10:54:00
 | CL M3 | 21.5 | 560 | 580 | 28.8 | 29.8 | 0.4 | 2001-11-12 10:54:00
 | CL Z3 | 21.5 | 560 | 580 | 25.5 | 26.5 | 0.35 | 2001-11-12 10:54:00
Spreadsheet: 549402d1511678543-distribution-of-quantities-excel
Sheet: גיליון1

A | B | C | D
Percent | Month | Sum | Round |  | Constraints
0.2 | Jan
0.1 | feb |  |  |  | Column D Must be round number (Integer)
0.1 | Mar |  |  |  | The Sum Of Column D Needs to be the same number as Column C
0.1 | Apr |  |  |  | if not ( like this situation) the difference or the [NAME] (2 in this situation (29-27)) will
0.05 | May |  |  |  | added or reduced only from mar, jun, sep,dec in Column D
0.025 | Jun |  |  |  | in this situation we will reduce 2, so we reduce 1 from march and 1 from june
0.1 | Jul
0.1 | Aug
0.15 | Sep
0.025 | Oct
0.025 | Nov |  |  |  | Opening | 27 |  | I put in Opening a number: like 27
0.025 | Dec
1
Spreadsheet: 6d6d5532-0306-4452-9fab-e5618d3ca92c
Sheet: BS

 | ADVANCED MICRO DEVICES, INC.
 | CONSOLIDATED BALANCE SHEETS
 | (Millions)
 |  |  |  |  | Sept. 25, |  | June 26, |  | Dec. 26,
 |  |  |  |  | 2010 |  | 2010 |  | 2009*
 | Assets
 | Current assets:
 |  | Cash, cash equivalents and marketable securities |  |  | 1726 |  | 1896 |  | 2676
 |  | Accounts receivable, net |  |  | 765 |  | 725 |  | 745
 |  | Inventories, net |  |  | 622 |  | 581 |  | 567
 |  | Deferred income taxes |  |  | 0 |  | 0 |  | 9
 |  | Prepaid expenses and other current assets |  |  | 99 |  | 111 |  | 278
 |  |  |  | Total current assets | 3212 |  | 3313 |  | 4275
 | Property, plant and equipment, net |  |  |  | 723 |  | 755 |  | 3809
 | Investment in GLOBALFOUNDRIES |  |  |  | 0 |  | 148 |  | 0
 | Acquisition related intangible assets, net |  |  |  | 48 |  | 64 |  | 98
 | Goodwill |  |  |  | 323 |  | 323 |  | 323
 | Other assets |  |  |  | 289 |  | 352 |  | 573
 | Total Assets |  |  |  | 4595 |  | 4955 |  | 9078
 | Liabilities and Stockholders' Equity
 | Current liabilities:
 |  | Accounts payable |  |  | 464 |  | 409 |  | 647
 |  | Accounts payable to GLOBALFOUNDRIES |  |  | 216 |  | 213 |  | 0
 |  | Accrued liabilities |  |  | 601 |  | 663 |  | 795
 |  | Deferred income on shipments to distributors |  |  | 151 |  | 148 |  | 138
 |  | Other short-term obligations |  |  | 209 |  | 159 |  | 171
 |  | Current portion of long-term debt and capital lease obligations |  |  | 3 |  | 3 |  | 308
 |  | Other current liabilities |  |  | 21 |  | 35 |  | 151
 |  |  |  | Total current liabilities | 1665 |  | 1630 |  | 2210
 | Deferred income taxes |  |  |  | 0 |  | 1 |  | 197
 | Long-term debt and capital lease obligations, less current portion |  |  |  | 2185 |  | 2418 |  | 4252
 | Other long-term liabilities |  |  |  | 102 |  | 154 |  | 695
 | Noncontrolling interest |  |  |  | 0 |  | 0 |  | 1076
 | Accumulated loss in excess of investment in GLOBALFOUNDRIES |  |  |  | 29 |  | 0 |  | 0
 | Stockholders' equity:
 |  | Capital stock:
 |  |  | Common stock, par value |  | 7 |  | 7 |  | 7
 |  |  | Capital in excess of par value |  | 6540 |  | 6562 |  | 6524
 |  |  | Treasury stock, at cost |  | -102 |  | -99 |  | -98
 |  | Retained earnings (deficit) |  |  | -5843 |  | -5725 |  | -5939
 |  | Accumulated other comprehensive income |  |  | 12 |  | 7 |  | 154
 |  |  |  | Total stockholders' equity | 614 |  | 752 |  | 648
 | Total Liabilities and Stockholders' Equity |  |  |  | 4595 |  | 4955 |  | 9078
 | * | Includes the account balances of GF which were deconsolidated as of the beginning of the first quarter of 2010.
Spreadsheet: 185238d1349594641-how-to-filter-the-names-from-a-list-of-names-without-duplicates-new-microsoft-excel-worksheet-oeldere-
Sheet: Sheet1

Date | Loan Number | Processor | Loan status | Critical errors | Non Critical errors |  |  | Aantal van Critical errors | Kolomlabels |  |  |  |  |  |  |  | Processor | Total Loans completed | Fail count | Pass Count | No of Critical errors | No of Non critical errors
2012-10-02 00:00:00 | 1000307078 | [NAME] | Pass | No | No |  |  | Rijlabels | Fail | Pass | Eindtotaal
2012-10-02 00:00:00 | 2345680888 | Venita Sinto | Fail | No | Yes |  |  | [NAME] | 3 |  | 3
2012-10-02 00:00:00 | 5430301701 | [NAME] | Fail | Yes | No |  |  | [NAME] | 3 | 2 | 5
2012-10-02 00:00:00 | 7874757583 | [NAME] | Fail | Yes | No |  |  | [NAME] | 2 |  | 2
2012-10-02 00:00:00 | 5250301381 | [NAME] | Fail | No | Yes |  |  | Renita Jorge | 2 |  | 2
2012-10-02 00:00:00 | 6729810910 | Renita Jorge | Fail | No | Yes |  |  | [NAME] | 1 |  | 1
2012-10-02 00:00:00 | 5430301699 | [NAME] | Fail | No | Yes |  |  | Venita Sinto | 1 |  | 1
2012-10-02 00:00:00 | 9837798120 | Renita Jorge | Fail | No | Yes |  |  | Eindtotaal | 12 | 2 | 14
2012-10-02 00:00:00 | 5350303313 | [NAME] | Fail | Yes | Yes
2012-10-02 00:00:00 | 3872912009 | [NAME] | Fail | No | Yes
2012-10-02 00:00:00 | 5430301721 | [NAME] | Fail | Yes | Yes
2012-10-02 00:00:00 | 4628299018 | [NAME] | Fail | No | Yes
2012-10-02 00:00:00 | 1000307288 | [NAME] | Fail | No | Yes
2012-10-02 00:00:00 | 7228910911 | [NAME] | Pass | No | No
Spreadsheet: 811290d1672393915-data-collation-formula-test-4
Sheet: Individual Analysis

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | Group
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-2018 | 1 | T20172018[#all]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-2019 | 2 | T20182019[#all]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-2020 | 3 | T20192020[#all]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-2021 | 4 | T20202021[#all]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-2022 | 5 | T20212022[#all]
 |  | Name | Name 1 |  | Year | Group | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8 |  | 2022-2023 |  | T20222023[#all]
 |  |  |  |  | 2017-2018 | 1
 |  |  |  |  | 2018-2019 | 2
 |  |  |  |  | 2019-2020 | 3
 |  |  |  |  | 2020-2021 | 4
 |  |  |  |  | 2021-2022 | 5
 |  |  |  |  | 2022-2023 | 5
Spreadsheet: 539077d1505949904-scatter-chart-different-color-dots-s666v3-1201756-scatter-chart-different-color-dots
Sheet: Sheet1

price | price2 |  | With PowerQuery
345.25 | 352
335.25 | 351.75
330.25 | 381
349 | 376
349.5 | 363
351.25 | 422
350 | 409
349.25 | 424
 | 420
Spreadsheet: 211188d1359675281-changing-data-based-on-drop-down-box-selection-example_013113
Sheet: Personnel

 |  | MAR
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Sue
 | Barb
 |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  |  | [NAME] | 0.15 | 0 | 0.3
 |  |  | [NAME] | 0.2 | 0.15 | 0
 |  |  | [NAME] | 0.2 | 0.35 | 0.15
 |  |  | [NAME] | 0.25 | 0 | 0.35
 |  |  | Sue | 0.4 | 0.15 | 0.05
 |  |  | Barb | 0 | 0.8 | 0.25
Spreadsheet: 288811d1389305672-sorting-question-trying-to-force-a-row-of-data-to-apper-in-the-wrong-sort-location-supersort-question
Sheet: Similar Start Values

 |  |  | Production ID | ProjectID | Start | Super Sort
 |  |  |  | 4 | 12
 |  |  |  | 2 | 14
 |  |  |  | 7 | 16
 |  |  |  | 15 | 23
 |  |  | 5 | 1 | 88
 |  |  |  | 8 | 88
 |  |  |  | 12 | 88
 |  |  |  | 5 | 88
 |  |  | 14 | 9 | 91
 |  |  |  | 14 | 1
 |  |  |  | 10 | 115
 |  |  |  | 11 | 123
 |  |  |  | 13 | 236
 |  |  |  | 6 | 458
 |  |  |  | 3 | 498
 |  |  | But when there are other projects with non unique start times (column F) it does not put them in the right spot.  And it won't because 88.1 will never be smaller than  88.  So is there another way I can use a formula to trick sort to get the row of data in column E that is represented by ID 5 to appear emmediatly under ID 1?
Spreadsheet: 2066a21f-6876-4e4c-a142-fa1e4646ea48
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
 | 8501.0 Retail Trade, Australia
 | TABLE 18. Quarterly Consumer Sales, Australia, By Type of Activity - Percentage change from previous quarter
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
Percentage change from preceding quarter ;  Electricity retailing ;  Total (State) ;  Current Price ; |  |  | Original | A83750224T | 2012-06-01 00:00:00 | 2014-03-01 00:00:00 | 8 | Percent | PERCENT | Quarter | 3
Percentage change from preceding quarter ;  Gas retailing ;  Total (State) ;  Current Price ; |  |  | Original | A83750226W | 2012-06-01 00:00:00 | 2014-03-01 00:00:00 | 8 | Percent | PERCENT | Quarter | 3
© Commonwealth of Australia  2014