tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16f2f45a-07fc-4933-8709-050a5f6d9ce0
Sheet: Sheet1

Unnamed: 0 | Magnusson/ Ortmayer Routine | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | [NAME] (lbs) | 680 |  | In kgs= | 0
 | [NAME] (kg) = | 308.4459765943935
 | Sets | Reps | Weight |  | Weight (lbs)
Week 1 | Warm Up
 | 4 | 4 | 215 |  | 475
 | 2 | 2 | 247.5 |  | 540
 | 1 | 8+ | 215 |  | 475
 | If you hit all reps on Week 1 continue to Week 2, if not redo Week 1.
Week 2 | Warm Up
 | 4 | 4 | 215 |  | 475
 | 1 | 2 | 247.5 |  | 540
 | 1 | 2 | 277.5 |  | 610
 | 1 | 8+ | 215 |  | 475
 | If you hit all reps on Week 2 continue to Week 3, if not redo Week 2.
Week 3 | Warm Up
 | 4 | 4 | 220 |  | 485
 | 1 | 2 | 250 |  | 555
 | 1 | 2 | 282.5 |  | 620
 | 1 | 8+ | 220 |  | 485
Week 4 | Rest Week. No deadlifts, upper back only.
Week 5 | Warm Up
 | 4 | 4 | 220 |  | 485
 | 1 | 2 | 250 |  | 555
 | 1 | 2 | 282.5 |  | 620
 | 1 | 8+ | 220 |  | 485
 | If you hit all reps on Week 5 continue to Week 6, if not redo Week 5.
Week 6 | Warm Up
 | 4 | 4 | 225 |  | 500
 | 1 | 2 | 257.5 |  | 565
 | 1 | 2 | 287.5 |  | 635
 | 1 | 8+ | 225 |  | 500
 | If you hit all reps on Week 6 continue to Week 7, if not redo Week 6.
Week 7 | Warm Up
 | 4 | 4 | 230 |  | 510
 | 1 | 2 | 260 |  | 575
 | 1 | 2 | 292.5 |  | 645
 | 1 | 8+ | 230 |  | 510
Week 8 | Rest Week. No deadlifts, upper back only.
Week 9 | Warm Up
 | 4 | 4 | 230 |  | 510
 | 1 | 2 | 260 |  | 575
 | 1 | 2 | 292.5 |  | 645
 | 1 | 8+ | 230 |  | 510
 | If you hit all reps on Week 9 continue to Week 10, if not redo Week 9.
Week 10 | Warm Up
 | 4 | 4 | 235 |  | 520
 | 1 | 2 | 267.5 |  | 590
 | 1 | 2 | 297.5 |  | 655
 | 1 | 8+ | 235 |  | 520
 | If you hit all reps on Week 10 continue to Week 11, if not redo Week 10.
Week 11 | Warm Up
 | 4 | 4 | 240 |  | 530
 | 1 | 2 | 270 |  | 600
 | 1 | 2 | 302.5 |  | 665
 | 1 | 8+ | 240 |  | 530
Week 12 | Rest Week or Test Max
Spreadsheet: 703980d1605281435-possible-vlookup-testbadge
Sheet: Sheet1

Date/Time | Who | Credential Hotstamp | EMP ID
2020-11-12 17:50:54 | Green, [NAME] | 1001111 | TAB0100915
2020-11-12 18:31:32 | [NAME], [NAME] | 1001112 | TAB0100420
2020-11-12 08:56:40 | Doe, [NAME] | 1001113 | [NAME]
2020-11-12 09:56:40 | Black, [NAME] | 1001114 | TAB0100965
Spreadsheet: 112066d1308237587-updating-worksheets-book-3
Sheet: Sheet2

Date | 1
2011-06-05 00:00:00 | 0.07125
2011-05-29 00:00:00 | 0.07875
2011-05-22 00:00:00 | 0.12125
2011-05-15 00:00:00 | 0.1225
2011-05-08 00:00:00 | 0.07375
2011-05-01 00:00:00 | 0.09375
2011-04-24 00:00:00 | 0.10875
2011-04-17 00:00:00 | 0.01
2011-04-10 00:00:00 | 0.09875
2011-04-03 00:00:00 | 0.07125
2011-03-27 00:00:00 | 0.13875
Spreadsheet: tracy_geaccone__40280__Depreciation Rates
Sheet: Sheet1

 | Depreciation Rates:
 | Co. 0062
 |  | Buildings | 0.025
 |  | Office Furn.& Equip | 0.3334
 |  | Computers | 0.3334
 |  | Vehicles | 0.3334
 |  | Trucks,HD | 0.1
 |  | Communications Equip | 0.1
 |  | Gen.[NAME] | 0.1
 |  | Intangibles | 0.1
 |  | Transmission-onshore | 0.0213
 |  | Transmission-offshore | 0.0356
 | Co. 0536
 |  | All Classes | 0.04
 | Co. 0060
 |  | Buildings | 0.1
 |  | Office Furn.& Equip | 0.1
 |  | Computers | 0.1
 |  | Vehicles | 0.1
 |  | Trucks,HD | 0.1
 |  | Communications Equip | 0.1
 |  | Gen.[NAME] | 0.1
 |  | Intangibles | 0.1
 |  | Transmission-onshore | 0.012
 |  | Transmission-offshore | 0.012
 | Co. 0179 | Buildings | 0.0275
 |  | Office Furn.& Equip | 0.1
 |  | Computers | 0.1
 |  | Vehicles | 0.1
 |  | Trucks,HD | 0.1
 |  | Communications Equip | 0.1
 |  | Gen.[NAME] | 0.1
 |  | Intangibles | 0.044
 |  | Transmission-onshore | 0.0115
 |  | Transmission-offshore | 0.0464
 |  | Storage | 0.0125
 | Co. 141 | Buildings | s/l
 |  | Office Furn.& Equip | 0.1
 |  | Computers | 0.2
 |  | Vehicles | 0.2
 |  | Trucks,HD | 0.2
 |  | Communications Equip | 0.1
 |  | Gen.[NAME] | 0.1
 |  | Intangibles | n/a
 |  | Transmission-onshore | 0.0225
 |  | Transmission-offshore | n/a
 |  | Storage | n/a
Spreadsheet: 859051d1707499742-power-query-merge-applied-steps-power-query-help-2-
Sheet: Addresses

AddressRef | Address Name | Street | City | PostCode | Region |  |  | Region | Region Name
1 | Address 1 | Street 1 | City 1 | PostCode 1 | 1 |  |  | 1 | North
2 | Address 2 | Street 2 | City 2 | PostCode 2 | 2 |  |  | 2 | South
3 | Address 3 | Street 3 | City 3 | PostCode 3 | 3 |  |  | 3 | East
4 | Address 4 | Street 4 | City 4 | PostCode 4 | 4 |  |  | 4 | West
5 | Address 5 | Street 5 | City 5 | PostCode 5 | 1
6 | Address 6 | Street 6 | City 6 | PostCode 6 | 2
Spreadsheet: 41468d1239942197-matching-data-book1
Sheet: Sheet2

CustCode | Sales
221000000133
221000000232 |  | Error
221000000406
221000000497
221000000620
221000000638
221000000661
221000000679
221000000836
221000000976
221000001149
221000001206
221000001388
221000001495
221000001495
221000001578
221000001669
221000001867
221000002014
221000002394
221000002428
221000002477
221000002493
221000002733
221000002782
221000002972
221000003137
221000003350
221000003442
221000003681
221000003756
221000003855
221000003863
221000003939
221000003988
221000004077
221000004366 |  | Error
221000004432
221000004432
221000004432
221000004507
221000004507
221000004531
221000004606
221000004606
221000004614 |  | Error
221000004614 |  | Error
221000004788
221000004838
221000004853
221000005033
221000005108 |  | Error
221000005108 |  | Error
221000005108 |  | Error
221000005124
221000005249
221000005272
221000005306
221000005454
221000005959
221000006239
221000006254
221000006312
221000006338
Spreadsheet: 07a49de1-f3e0-41dd-bb40-728dcc2b737a
Sheet: Summary Results

 | Summary Results
 | Results of multiple scenarios may be compared here by using the "copy" and "paste special - values" feature to transfer values from column D to columns F through O
 | Press F9 each time inputs are changed to ensure completion of the COE calculation.   When "#N/A" appears,  press "F9" in the upper row on your keyboard to complete the calculation.  It may be necessary to press F9 more than once. See note for details. |  |  |  | [NAME] of Multiple Model Runs Below
 | Outputs Summary | units | Current Model Run |  | [[NAME]] | [[NAME]] | [[NAME]] | [[NAME]] | [[NAME]] | [[NAME]] | [[NAME]] | [[NAME]] | [[NAME]] | [[NAME]]
 | Net Year-One Cost of Energy (COE) | ¢/kWh
 | Annual Escalation of Year-One COE | %
 | Percentage of Tariff Escalated | %
 | Does modeled project meet minimum DSCR requirements?
 | Does modeled project meet average DSCR requirements?
 | Did you confirm that all minimum required inputs have green check cells?
 | Net Nominal Levelized Cost of Energy | ¢/kWh
 | Inputs Summary
 | Selected Technology
 | Generator Nameplate Capacity
 | Net Capacity Factor, Yr 1
 | Production, Yr 1 | kWh
 | Project Useful Life | Years
 |  | Years
 | % of Year 1 Tariff Rate Escalated | %
 | Net Installed Cost (Total Installed Cost less Grants) | $
 | Net Installed Cost (Total Installed Cost less Grants) | $/Watt
 | Operating Expenses, Aggregated, Yr 1 | ¢/kWh
 |  | %
 |  | %
 |  | %
 | [NAME] | Years
 |  | %
 | Federal Tax Benefts Used "as generated" or "carried forward"?
 | State Tax Benefts Used "as generated" or "carried forward"?
 | Type of Federal Incentive Assumed
 | Tax Credit-  or Cash- Based?
 | Other Grants or Rebates
 | Total of Grants or Rebates | $
 | Bonus Depreciation assumed?
 | Notes: User-Defined
Spreadsheet: 807231d1669812399-transfer-of-data-from-a-master-sheet-to-other-sheets-quest-2-1-
Sheet: cash in hand

Helper |  | Date | Description | Debit | Credit | Debit | Credit
Spreadsheet: 101185d1299309066-formula-needed-to-find-best-match-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | BEST
 |  |  |  |  |  | PRODUCT |  |  |  | ASSIGN | MATCHES
 |  |  |  |  | GOAL | LIST |  |  |  | ITEM CODE | ITEM
 |  |  |  |  | P | PEPSI |  |  |  | P | PEPSI
 |  |  |  |  | PD | PEPSI DIET |  |  |  | PD | DIET PEPSI
 |  |  |  |  | C | COKE |  |  |  | C | COKE
 |  |  |  |  | CD | COKE DIET |  |  |  | CD | DIET COKE
 |  |  |  |  | CDF | CAFFEINE FREE DIET COKE |  |  |  | CDF | DIET COKE FREE
 |  |  |  |  | CDF | COKE DIET FREE
 |  |  |  |  | P | 12 OZ PEPSI
 |  |  |  |  | C | COKE 12 OZ
Spreadsheet: 60073d1260592788-cell-with-vlookup-needs-to-add-two-cells-sample-sheet
Sheet: Totals

 | Cell B10 should show "5"
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals
Apples
Oranges
Peaches
Plums
Spreadsheet: 871111d1717549503-total-sum-from-multiple-sheets-sample-wb
Sheet: Summary

Customer Name |  | Set 1 | Set 2
Customer 1 |  | 2 | 7
Customer 2
Customer 3
Customer 4
Customer 5
Customer 6
Customer 7
Customer 8
Customer 9
Customer 10
Customer 11
Customer 12
Customer 13
Customer 14
Customer 15
Customer 16
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: St Jude

 |  | WEEK 10 FedEx St. Jude Classic
 |  | Total Earnings |  |  |  | Rankings Through Week 10 | Total
 | [NAME] | 0 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 2 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | [NAME] |  | YTD
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Spreadsheet: rick_buy__32698__DOUG
Sheet: 1299

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF DECEMBER 31, 1999
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 4368505.61 |  | 2207235.46 |  | 4145790.82 |  | 3961806.98 |  |  |  |  | LAST PAYMENT 12/31/99
 | PER CENT |  |  |  |  |  | 0 |  | 0
PUERTO QUETZAL | A/R |  | 2046377.11 |  | 0 |  | 0 |  | 0 |  |  |  |  | LAST PAYMENT 12/30/99
463 | PER CENT
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
416 | PER CENT
DABHOL POWER CO | A/R |  | 144874.81 |  | 0 |  | 0 |  | 0 |  |  |  |  | LAST PAYMENT 12/24/99
 | PER CENT
EMPRESA ENERGETICA | A/R |  | 1581340.62 |  | -189.2 |  | 2587123.06 |  | 546126.27 |  | 0 |  |  | LAST PAYMENT 12/6/99
 | PER CENT
EGEMINSA | A/R |  | 536193.6 |  | 807306.43 |  | 2650570.21 |  | 500614.52 |  | 26385.12 |  |  | LAST PAYMENT 12/23/99
 | PER CENT
TOTALS | A/R
 | PER CENT
Spreadsheet: 821851d1678943008-vstack-results-of-indirect-references-from-an-array-indirect_example_1
Sheet: output

 | Note - this part is done differently
 | but I used some VBA code to generatethis
 | Sheet# | SheetName | IsData? | Start Row | Start Column | # Columns |  | [NAME]
 |  | setup |  | 4 | 2 |  |  |  | data1!$C$4# | data1!$D$4# | data1!$E$4#
 |  | [NAME] |  |  |  |  |  | data2!$B$4# | data2!$C$4# | data2!$D$4# | data2!$E$4#
 |  | data2 |  |  |  |  |  | data3!$B$4# | data3!$C$4# | data3!$D$4# | data3!$E$4#
 |  | data3
 |  | output |  |  |  |  |  | The problem is that the below "VSTACKS" are formed by manually referencing I6, I7, I8…etc.
 |  |  |  |  |  |  |  |  | [NAME] | amount | account
Spreadsheet: chris_germany__1740__Stg invoice info
Sheet: Sheet1

 | Theoretical Storage Injections by Month for CES pursuant to 12/99 Energy Purchase Agreement with ENA
 |  | TCO stg |  |  |  | Sonat CSS |  |  |  | TRANSCO WSS |  |  |  | TRANSCO ESS
 |  | Sitara # SA-268094
 | Month/Yr | Dth | Invoice # | page # |  | Dth | Sitara # | Invoice # |  | Dth | Sitara # | Invoice # |  | Dth | Sitara # | Invoice #
 | Beg April Inv. | 170981 | #NA | #NA |  | 981 | #NA | #NA |  | 53989 | #NA | #NA |  | 291 | #NA | #NA
Injections | 2000-04-01 00:00:00 | ? | ? | ? |  | ? | ? | ? |  | Injection should have been zero |  |  |  | ? | ? | ?
 | 2000-05-01 00:00:00 | 1088289 | 11738SA | 4 |  | 145584 | SA-271438 | 11738SA |  | 65503 | SA-272678 | 11738SA |  | 3968 | SA-272678 | 11738SA
 | 2000-06-01 00:00:00 | 497015 | 12806SA | 4 |  | 146258 | SA-278456 | 12806SA |  | 63840 | SA-278452 | 12806SA |  | 3810 | SA-278452 | 12806SA
 | 2000-07-01 00:00:00 | 1089123 | 13961SA | 4 |  | 135032 | SA-312606 | 13961SA |  | 53568 | SA-312535 | 13961SA |  | 2666 | SA-312535 | 13961SA
 | #Note:  Beginning April Inventory is at the inventory meter.  We assume that all injection volumes are at the storage injection meter.  Injection fuel, if any, must be netted out to obtain inventory figure.
 |  | Volume is too low.
Spreadsheet: 808357d1670428088-compare-identical-numbers-false-output-number-compare-sample
Sheet: Sheet1

 |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 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
 | Data --> |  | 0 | 0 | 6764499.780000001 | 48997.21 | 51035.5 | 29396.49 | 23628.35 | 135695.69 | 176915.86 | 137927.55 | 51785.3 | 67934.38 | 47018 | 150464.5 | 32284.82 | 235006.13 | 46164.91 | 38408.97 | 41483.09 | 73706.3 | 54492.66 | 38032.71 | 48238.21000000001 | 56074.88 | 40876.55 | 110588.82 | 15197.9 | 16220.18 | 7437.58 | 6441.1 | 42080.81 | 76106.79 | 46487.82 | 33811.35 | 90481.14862068967 | 90481.14862068967 | 101592.2597318008 | 822912.3097318008 | -12505848.08875441 | 57205.57492559386 | 57205.57492559386 | 1119065.652815352 | 10397.63457926898 | 10591.76518004551 | 77399.78707502596 | 277435.5915584147 | 511748.9946927913 | 744897.6142225056 | 1344422.635870342 | 1966792.50193292 | 1211971.375685042 | 1311698.082025569 | 1278197.005777691 | 550103.3359600883 | -2300774.627738233 | 1708857.731980696 | -2460079.93547597 | 1750788.275509675 | -2841536.424612886 | 1020580.333067634 | -3700630.755623838 | 285965.793625594 | -3713529.592244365 | -130974.1479062069 | -4212386.535616292
 | Data sum -->
 | SUMIF greater than zero -->
 | SUMIF less than zero -->
 | Net difference of SUMIF -->
 | Compare Data Sum and SUMIF difference --> |  | <-- I expect this to be TRUE but it's false
 | (compare C8 to C12)
Spreadsheet: 805806d1668944103-how-to-show-value-added-tax-separate-from-vat-exempt-and-vat-zero-rated-vat-separattion
Sheet: SourceData

[NAME]
Date | TIN | CUSTOMER NAME | TAX IONVOICE NUMBER / REFERENCE | Particulars of Supplies | Exempt Supplies | Zero Rated Supplies | [NAME] (Incl. VAT) | Std Rated (Excl. VAT) | VAT Rate
03/10/2022 | 100100100 | Times | 1258 | Newspaper |  |  | 6 | 5.217391304347826 | 15 | VAT
 |  |  |  |  |  |  |  |  | 0 | Zero
 |  |  |  |  |  |  |  |  | 0 | Exempt
2022-10-05 00:00:00 | 100100200 | Butchery | 847 | Meat |  |  | 100 |  | 15 | VAT
2022-10-06 00:00:00 | 100100300 | Grocery | 3548 | Milk |  | 50 |  |  | 0 | Zero
2022-10-07 00:00:00 | 100100400 | Grocery | 96247 | Brown Sugar | 20 |  |  |  | 0 | Exempt
 |  |  |  |  |  |  |  |  | 15 | VAT
2022-10-11 00:00:00 | 100200253 | Gas Station | 44711 | Fuel | 75 |  |  |  | 0 | Zero
 |  |  |  |  |  |  |  |  | 0 | Exempt
 |  |  |  |  |  |  |  | 0 | 15 | VAT
13/10/2022 | 100100100 | Mobile money | 963258 | Electricity |  | 1000 |  |  | 0 | Zero
 |  |  |  |  |  |  |  |  | 0 | Exempt
 |  |  |  |  |  |  |  |  | 15 | VAT
 |  |  |  |  |  |  |  |  | 0 | Zero
 |  |  |  |  |  |  |  |  | 0 | Exempt
 |  |  |  |  |  |  |  |  | 15 | VAT
 |  |  |  |  |  |  |  |  | 0 | Zero
 |  |  |  |  |  |  |  |  | 0 | Exempt
Spreadsheet: 155383d1336780566-excel-2007-how-to-create-a-list-that-returns-unique-values-copy_hot-list
Sheet: Sheet1

Name | Enrollment
Florida State University | 41k
University of Florida | 50k
Florida Agricultural and Mechanical University (Tallahassee) | 13k
Florida Atlantic University (Boca Raton) | 29k
Florida Gulf Coast University (Ft. Myers) | 13k
Florida International University (Miami) | 48k
Florida State University (Tallahassee) | ?
University of Central Florida (Orlando) | 59k
University of Florida (Gainesville) | 50k
University of North Florida (Jacksonville) | 17k
University of South Florida (Tampa) | 47k
University of West Florida (Pensacola) | 12k
[edit] Florida College System | 800000k | http://www.fldoe.org/cc/
Brevard Community College | 15k
Florida State College at Jacksonville | 41k
Santa Fe College | 17k
Brevard Community College (Cocoa) | see brevard
Broward College (Davie) | 67k
College of Central Florida (Ocala) | 19k
Daytona State College (Daytona Beach) | 18k
Edison State College (Fort Myers) | 26k
Florida Keys Community College (Key West) | ?- three campuses | www.fkcc.edu
Florida State College at Jacksonville (Jacksonville) | 81k
Gulf Coast State College (Panama City) | 6k
Hillsborough Community College (Tampa) | 43k
Indian River State College (Ft. Pierce) | 45k
Lake-Sumter Community College (Leesburg) | 5k
Miami Dade College (Miami) | 162k
Northwest Florida State College (Niceville) | ?
Palm Beach State College (Lake Worth) | 51k
Pasco-Hernando Community College (New Port Richey) | ? | 4 campuses
Pensacola State College (Pensacola) | 36k
Polk State College (Winter Haven) | 20k
Santa Fe College (Gainesville) | ?
Seminole State College of Florida (Sanford) | 30k
South Florida Community College (Avon Park) | 16k
St. Johns River State College (Palatka) | 14k
St. Petersburg College (St. Petersburg, Florida) | 65k
State College of Florida, Manatee-Sarasota (Bradenton) | 30k
Tallahassee Community College (Tallahassee) | 18k
Valencia College (Orlando) | 36k
Barry University (Miami Shores) | 9k
Keiser University (Fort Lauderdale) | 17k
University of Tampa | 7k
Carlos Albizu University (Miami) | 16k
Johnson & Wales University (North Miami) | 16k
University of Miami (Coral Gables) | 16k
University of Phoenix (Orlando) | 321k
Virginia College (Pensacola) | 5k
Spreadsheet: 467922d1467044245-solver-question-excelexpert_3-4b
Sheet: Sheet1

Constraints |  |  |  |  | Total supply budget - Alpha | 150000
 |  |  |  |  | Total budget for Product 4 + 5 | 35000
 |  |  |  |  | Maximum % of budget spent on any product | 0.2
 |  |  |  |  | Minimum sales per product | 50
Product Group Alpha | Cost of Goods | Profit margin | Projected Sales | Total  Profit | Total Cost | Percent  of total
Product 1 | 55.87 | 0.115 | 250
Product 2 | 103 | 0.084 | 250
Product 3 | 8.45 | 0.082 | 250
Product 4 | 183.66 | 0.112 | 250
Product 5 | 288 | 0.139 | 250
Product 6 | 16.99 | 0.163 | 250
Total Cost of Goods
Product 4 + 5 only
Spreadsheet: 94460d1294263316-need-help-creating-a-timesheet-to-track-one-employee-over-different-jobs-jobssheets
Sheet: 12-18-10

[NAME]
Date | Job # | Customer | Job | Operation | Start | End | Total | Paid
2010-12-15 00:00:00 | 3 |  |  |  | 15:00:00 | 18:30:00 |  | Yes
2010-12-17 00:00:00 | 3 |  |  |  | 11:00:00 | 17:00:00 |  | Yes
 |  |  |  |  | Hours Worked
 |  |  |  |  | Hours Paid
 |  |  |  |  | Hours Unpaid
Spreadsheet: 2ff5c403-4172-4a3a-9791-31a49e49dae0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7523 | 29321 | Ana | Bargas | ARG | 0 | 00:14:42 | 00:01:03 | 00:41:14 | 00:00:45 | 00:22:03 | 1 | 01:23:12
7523 | 54988 | [NAME] | [NAME] | ARG | 0 | 00:14:56 | 00:01:53 | [NAME] | 00:01:08 | 00:22:05 | 2 | 01:24:27
7523 | 54987 | Valentina | Crespo | ARG | 0 | 00:15:49 | 00:01:23 | 00:40:33 | 00:01:06 | 00:24:43 | 3 | 01:26:58
7523 | 54989 | [NAME] | [NAME] | ARG | 0 | 00:14:14 | 00:01:18 | 00:42:22 | 00:01:11 | 00:27:34 | 4 | 01:30:02
7523 | 54986 | [NAME] | Crespo | ARG | 0 | 00:15:37 | 00:01:29 | 00:41:41 | 00:01:06 | [NAME] | 5 | 01:31:07
Spreadsheet: 771336d1646636390-if-and-match-formulas-summing-data-from-different-columns-personas_tareas_foro
Sheet: Horas por día febrero

Etiquetas de fila
2022-02-07
Persona2
D22040-ECO Ecoembes
00:39:45
2022-02-08
Persona3
D22004-CROP Project Management
01:41:14
2022-02-15
Persona3
D22004-CROP Project Management
00:43:50
2022-02-16
Persona3
D22004-CROP Project Management
00:26:50
2022-02-18
Persona3
D22004-CROP Project Management
00:35:05
2022-02-21
Persona3
D22004-CROP Project Management
00:33:00
00:34:32
[NAME]
2022-02-22
Persona2
D22040-ECO Ecoembes
04:09:00
Persona3
D22004-CROP Project Management
01:10:11
2022-02-24
Persona2
D22040-ECO Ecoembes
01:44:00
Persona3
D22004-CROP Project Management
00:27:40
00:36:10
2022-03-01
Persona1
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT
02:09:47
Persona3
D22004-CROP Project Management
00:39:47
2022-03-02
Persona1
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT
00:33:39
01:43:30
02:56:54
2022-03-03
Persona1
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT
00:44:49
02:10:58
Total general
Spreadsheet: 729763d1619327098-look-at-header-row-and-look-down-to-see-if-there-is-data-formula
Sheet: AUDIT

Month |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Helper Cell | Contains Data?
Does Sheet Contain Data?