tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744692d1629382822-to-get-latest-status-based-on-status-date-per-id-final-status-example
Sheet: Sheet1

Column A is to consider ID in column C and its statuses in column B to revert Final status based on the latest date in column D
Final status | Status | ID | Status date
No status | No status | 97979 | 2021-07-11 22:18:29
Approved | Approved | 333 | 2021-07-11 21:20:39
Approved | Approved | 123 | 2021-07-11 21:01:32
Approved | Approved | 123 | 2021-07-11 20:34:40
Approved | Approved | 123 | 2021-07-10 21:25:58
No status | Approved | 97979 | 2021-07-09 06:39:34
Approved | Rejected | 333 | 2021-07-08 20:31:39
No status | Approved | 97979 | 2021-07-07 06:34:06
No status | Rejected | 97979 | 2021-06-25 11:35:54
Approved | Approved | 123 | 2021-06-20 03:50:38
No status | Rejected | 97979 | 2021-06-18 13:28:38
No status | Rejected | 97979 | 2021-06-11 13:07:49
No status | Rejected | 97979 | 2021-06-11 11:02:24
No status | Rejected | 97979 | 2021-06-11 10:34:59
No status | Rejected | 97979 | 2021-06-09 12:57:04
No status | Rejected | 97979 | 2021-05-31 00:07:29
Approved | Approved | 123 | 2021-05-04 13:46:36
Approved | Approved | 123 | 2021-05-03 21:58:38
Approved | No status | 123 | 2021-05-03 21:47:06
Approved | No status | 123 | 2021-05-03 21:23:32
Approved | Approved | 123 | 2021-05-03 20:32:10
Approved | Approved | 123 | 2021-05-03 20:31:03
Spreadsheet: 866238d1713199988-help-with-formulas-to-populate-a-calendar-kansas-scheduler-calendar-test-v1
Sheet: Kitting Schedule

[NAME] from date below↓ | ↓Minimum # of Kits↓ | DO NOT EDIT IN THIS REPORT
2024-04-04 00:00:00 | 25
Client | Job # | # of Stores | # of Pieces | Ship Date | Notes
 | 246061 | 120 | 120 | 2024-04-10 00:00:00 | 0
HALL 246063 [10] | 246063 | 50 | 50 | 2024-04-10 00:00:00 | 0
P&S 246437 [10] | 246437 | ? | 5650 | 2024-04-10 00:00:00 | 0
Spreadsheet: 30b92fa3-1126-4e1d-aa1e-bc9c09b241c5
Sheet: Sheet1

 | Local Unit Statistics Worksheet
 | Directions:  [NAME] the worksheet with estimates of what you believe the correct values to be for your local unit.  Then, using the U.S. Census Bureau Quick Facts for your county/counties, record the actual statistics.  (See http://quickfacts.census.gov/qfd/index.html).  How do the values compare?
 | County/District | County |  | County |  | County |  | County |  | District
 |  | Est. | Actual | Ext. | Actual | Est. | Actual | Est. | Actual | Total
1. | What was the county population according to the latest census?
2. | How has this population changed?
3. | What percentage of the population is under 18 years?
4. | What percentage of the population is over 65 years?
5. | What percentage of the population is female?
6. | What percentage of the population is:
 | White?
 | Black?
 | American Indian?
 | Asian?
 | Hispanic or Latino?
7. | What percentage of residents spoke a language other than English at home (age 5+)?
8. | What percentage of the over-25 population graduated from high school?
9. | What percentage of the over-25 population has a bachelor's degree or higher?
10. | What is the median household income?
11. | What percentage of residents have income below poverty level?
12. | How many people are there per square mile?
Spreadsheet: 777897d1650651419-fvschedule-formula-annual-to-monthly-interest-rates-fvschedule-interest-rates
Sheet: Sheet1

 |  | Opening | % p.a | Closing |  | FVSCHEDULE |  | Principle value
 |  | 10000 | 0.06
 |  |  |  |  |  |  |  | Future value
Spreadsheet: f4577fff-105e-4daa-b4eb-bbafc163880d
Sheet: Sheet1

DAFTAR PESERTA PLPG RAYON 112 UNIVERSITAS NEGERI SEMARANG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
TAHAP VII  GUGUS BADAN DIKLAT PROV. [NAME]. SUMBING
[NAME] Tanggal 14 - 23  Agustus  2011
Kelas : | Elektronika
No | No Peserta | Nama | Sekolah | Kab./Kota
1 | 11032852610862 | JOKO PRAMONO | SMK N 2 ADIWERNA | Kab. Tegal
2 | 11036352611694 | ANIK GAYATRI | SMK (STM) N 5 SEMARANG | [NAME]
3 | 11032453310987 | SIGIT YUWONO | SMK (STM) MUHAMMADIYAH 3 WELERI | Kab. Kendal
4 | 11032753311031 | MUSTARI | SMK N 1 Ampelgading | Kab. Pemalang
5 | 11036253310218 | IWAN ISNADI | SMK (STM) N  2 SALATIGA | [NAME]
6 | 11036353311655 | SISMARDIYANTO | SMK (STM) N 4 | [NAME]
7 | 11036353311656 | JOKO SUTOPO | SMK (STM) MUHAMMADIYAH 2 | [NAME]
8 | 11036353311657 | [NAME] | SMK (STM) SEPULUH NOPEMBER | [NAME]
9 | 11036353311716 | JOKO SALAM | SMK (STM) N 3 SEMARANG | [NAME]
10 | 11036353311717 | SAFRUDIN | SMK (STM) N 4 | [NAME]
11 | 11032453410957 | PRIH HARJANTO | SMK (STM) N 3 KENDAL | Kab. Kendal
12 | 11036253410217 | NOOR WIDIYANTO | SMK (STM) N  2 SALATIGA | [NAME]
13 | 11036353411693 | SUNARKO | SMK (STM) N 4 | [NAME]
14 | 11036353411720 | ICE FAULIA | SMK (STM) N 4 | [NAME]
15 | 11032822710655 | AHMAD SUSANTO | SMP N 2 PANGKAH | Kab. Tegal
16 | 11032422710695 | BUDI TRI KARTIKA | SMP N 1 BRANGSONG | Kab. Kendal
17 | 11032422710727 | SUPRIYANTO | SMP N 1 PAGERUYUNG | Kab. Kendal
18 | 11032422710731 | SARWIYADI | SMP N 1 PATEAN | Kab. Kendal
19 | 11036222710114 | TRI UTOMO | SMP NEGERI 2 SALATIGA | [NAME]
20 | 11036222710131 | SATIMAN | SMP NEGERI  4 SALATIGA | [NAME]
21 | 11036222710139 | WAHYU EKO SUGIARTO | SMP NEGERI 5 SALATIGA | [NAME]
22 | 11036222710141 | [NAME] | SMP NEGERI   6 SALATIGA | [NAME]
23 | 11036222710164 | NUGROHO WIDAYANTO | SMP NEGERI  10 SALATIGA | [NAME]
24 | 11030906310913 | JUWARIYAH | SMP N 1 TERAS | Kab. Boyolali
25 | 11030906310962 | SUKIRNO | SMP MUHAMMADIYAH 3 AMPEL | Kab. Boyolali
26 | 11030906310910 | HERU RIWAYANTO | SMP N 1 WONOSEGORO | Kab. Boyolali
27 | 11031406310893 | GUNAWAN WIBISONO | SMP N 1 PLUPUH | Kab. Sragen
28 | 11031406310913 | MURYADI | SMP N 1 SAMBIREJO | Kab. Sragen
29 | 11030406310670 | SOLEKHAN | SMP Negeri 1 Punggelan | Kab. Banjarnegara
30 | 11030406310677 | [NAME] SUWARNA | SMP Negeri 2 Mandiraja | Kab. Banjarnegara
31 | 11031406310992 | YANU ADI SUSANTO | SMP N 2 SUMBERLAWANG | Kab. Sragen
32 | 11030322710788 | RUSLIZAR HARAHAP | SMP N 1 BUKATEJA | Kab. [NAME]
33 | 11036161710954 | YOHANNA FRANCISCA. GUNARSIH | SMK (STM) N 5 SURAKARTA | [NAME]
34 | 11030761710728 | KUSPARTANA | SMK N 2 WONOSOBO | Kab. Wonosobo
35 | 11031461711092 | NURLINTANG | SMK (STM) MUHAMMADIYAH 6 GEMOLONG | Kab. Sragen
36 | 11031461711093 | PUJI WIDODO | SMK (STM) N 2 SRAGEN | Kab. Sragen
37 | 11031661710597 | MUGI MURWOTO | SMK (STM) N 1 BLORA | Kab. Blora
38 | 11030961711155 | TRI ROHMADI | SMK (STM) NEGERI 1 KLEGO | Kab. Boyolali
Spreadsheet: c103dc5a-6ec8-4f8f-8fb8-ff143ea06e90
Sheet: Egypt

 |  | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
Export Sales | Egypt | This yr | Last yr | This yr | Last yr | This yr | Last yr
2012-09-06 00:00:00 |  | 86.5 | 140 | 66 | 0
 |  | 146.5 | 147.5 | 66 | 0
 |  | 146.5 | 150.2 | 66 | 24.3
 |  | 146.5 | 150.2 | 66 | 24.3
 |  | 146.5 | 150.2 | 66 | 24.3
 |  | 87 | 63.2 | 130.7 | 112
 |  | 87 | 60 | 130.7 | 112
 |  | 87 | 60 | 130.7 | 161.5
 |  | 163.5 | 96 | 140.9 | 161.5
 |  | 137 | 87.3 | 199.7 | 170.2
 |  | 137 | 147.3 | 199.7 | 170.2
 |  | 77 | 207.3 | 263.9 | 170.2
 |  | 77 | 147.3 | 263.9 | 215.5
 |  | 145.5 | 147.3 | 263.9 | 215.5
 |  | 128.5 | 147.3 | 285.2 | 215.5
 |  | 128.5 | 147.3 | 285.2 | 215.5
 |  | 128.5 | 174.3 | 285.2 | 215.5
 |  | 68.5 | 174.3 | 347.9 | 215.5
 |  | 189 | 174.3 | 357.9 | 270.9
 |  | 206 | 234.3 | 357.9 | 270.9
 |  | 246 | 182.5 | 357.9 | 318.4
 |  | 186 | 162.2 | 414 | 338.7
 |  | 195 | 233.7 | 414 | 338.7
 |  | 177 | 280.2 | 433.8 | 366.5
 |  | 187 | 263.5 | 444.9 | 433.3
 |  | 127 | 233.2 | 499 | 466.1
 |  | 67 | 156.1 | 575.5 | 545.5
 |  | 50 | 142 | 595.3 | 630.2
 |  | 0 | 142 | 649 | 630.2
 |  | 0 | 87 | 649 | 716.8
 |  | 0 | 93.5 | 677.3 | 716.8
 |  | 0 | 66.5 | 677.3 | 745.6
 |  | 0 | 6.5 | 677.3 | 811.3
 |  | 0 | 8 | 677.3 | 848.3
 |  | 0 | 78 | 677.3 | 848.3
 |  | 0 | 102 | 677.3 | 848.3
 |  | 0 | 138 | 677.3 | 881.7 |  |  | 60
 |  | 0 | 138 | 677.3 | 881.7 |  |  | 60
 |  | 0 | 102 | 677.3 | 929.4 |  |  | 60
 |  | 0 | 222 | 677.3 | 929.4 |  |  | 60
 |  | 0 | 222 | 677.3 | 929.4 |  |  | 60
 |  | 0 | 222 | 677.3 | 929.4 |  |  | 60
 |  | 0 | 201 | 677.3 | 1005.9 |  |  | 60
 |  | 0 | 201 | 677.3 | 1005.9 |  |  | 60
 |  | 0 | 184 | 677.3 | 1025.6 |  |  | 60
 |  | 0 | 244 | 677.3 | 1025.6 |  |  | 60
 |  | 0 | 84 | 677.3 | 1200 |  |  | 60
 |  | 0 | 84 | 677.3 | 1200 |  |  | 120
 |  | 0 | 84 | 677.3 | 1200 |  |  | 120
 |  | 0 | 68 | 677.3 | 1224.1 |  |  | 120
 |  | 0 | 68 | 677.3 | 1224.1 |  |  | 120
 |  | 0 | 68 | 677.3 | 1224.1 |  |  | 120
 |  | 120 | 86.5 | 0 | 66
 |  | 120 | 146.5 | 0 | 66
 |  | 180 | 146.5 | 0 | 66
 |  | 180 | 146.5 | 0 | 66
 |  | 180 | 146.5 | 0 | 66
 |  | 246 | 87 | 0 | 130.7
 |  | 206 | 163.5 | 53.4 | 140.9
 |  | 206 | 137 | 53.4 | 199.7
 |  | 146 | 137 | 116.5 | 199.7
 |  | 146 | 77 | 116.5 | 263.9
 |  | 146 | 77 | 131.1 | 263.9
 |  | 146 | 145.5 | 150.6 | 263.9
 |  | 86 | 128.5 | 214.7 | 285.2
 |  | 116 | 196.5 | 389.5 | 394
 |  | 134 | 128.5 | 270.9 | 285.2
 |  | 134 | 68.5 | 270.9 | 347.9
 |  | 134 | 189 | 270.9 | 357.9
 |  | 194 | 206 | 270.9 | 357.9
 |  | 194 | 246 | 270.9 | 357.9
 |  | 221 | 186 | 270.9 | 414
 |  | 221 | 195 | 270.9 | 414
 |  | 201 | 177 | 293.9 | 433.8
 |  | 174 | 187 | 333.8 | 444.9
Spreadsheet: 715415d1611693187-need-to-compare-one-list-to-another-on-an-invoice-and-sum-up-associated-costs-in-matches-sample
Sheet: Sorting Data

Chemo
Abraxane
[NAME]
[NAME]
Alimta
Avastin
Azacitidine
Benamustin
Bendeka
Bleomycin
Bortezomib
Brentuximab
Camptosar
Carbazetaxol
Carboplatin
Carfilzomib
[NAME]
Cyclophosphomide
Cyramza
Cytoxan
Dacarbazine
Dacogen
Daratumumab
[NAME]
Decitabine
Docetaxel
Doxil
Doxorub
[NAME]
Eligard22
Ellence
Eloxatin
Emend
Erbitux
Etoposide
Faslodex
Fluoruracil
Ganciclovir
Gemcitabine
Gemzar
Halaven
[NAME]
Hycamtin
Imfinzi
Ipilumimab
Irinotecan
Kadcyla
Keytruda
Kyprolis
Leucovorin
Libtayo
Liposomal
Methotrexate
Nano-particulate
Neulasta
Neuplasta
Neupogen
Nevelbine
NPlate
Oncovin
Opdivo
[NAME]
Paclitaxel
Palonosetron
[NAME]
Paraplatin
Perjeta
Platinol
Premetrexed
Procrit
Rituxin
Taxol
Taxotere
Tecentri Q
Toposar
Topotecan
Trelstar
Vectibix
Velban
Velcade
Vidaza
Vinblastine
Vincristine
Vinorelbine
Yervoy
[NAME]
Spreadsheet: benjamin_rogers__1039__Consolidated 6 Peaker-051800
Sheet: CF

ANNUAL CASH FLOW AND IRR
GENCO CASH FLOW
('000 $) | Close | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Check
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00
EBITDA less Contract Amortization | 0
Plus Property Tax Liability | 0
Less Property Tax Expense | 0
Less Principal Payments | 0
Less Interest Payments | 0
Pre-Tax Cash Flow
GenCo's State Tax Benefit/(Expense) | 0
GenCo's Federal Tax Benefit/(Expense) | 0
After-Tax Cash Flow
IRR Calculation
('000 $) | Close | 2001
Equity Partner's Contribution |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Equity Partner's After-Tax Cashflow
Salvage Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Equity Partner's Net Cashflow
IRR
Spreadsheet: 128641d1321142746-v-look-up-help-invoice-v10
Sheet: Mr Vamplew11-12-2011

KingFisher Tackle
Customer: | Mr [NAME]
Ref No.: AC101KFT
Contact No. [PHONE]
Amount Customer Wants | Item Description |  |  | Cost of Item | Total Cost |  |  |  |  |  | Stock Availibility | Item Description in Stocklist | Price
No | Description |  |  | Item Cost | Total Cost |  |  |  |  |  |  |  | 0
0 |  |  |  | 0 | 0 |  |  |  |  |  | 50 | 1 Pint Fresly Turned Caster | 2
0 |  |  |  | 0 | 0 |  |  |  |  |  | 100 | 1/2 Pint Red Maggots | 0.6
0 |  |  |  | 0 | 0 |  |  |  |  |  | 20 | 1KG Worms | 15
0 |  |  |  | 0 | 0 |  |  |  |  |  | 25 | 6mm Miracle Baits Snowball Pellets | 3
0 |  |  |  | 0 | 0 |  |  |  |  |  | 20 | Bag of KingFisherTackle 4mm Feed Pellet | 2.5
0 |  |  |  | 0 | 0 |  |  |  |  |  | 10 | Discorger | 0.5
0 |  |  |  | 0 | 0 |  |  |  |  |  | 15 | [NAME] | 3
0 |  |  |  | 0 | 0 |  |  |  |  |  | 200 | KingFisher Tackle £20 [NAME] Used | -20
0 |  |  |  | 0 | 0 |  |  |  |  |  | 2 | Maver Mxi Series 5 Attachments | 50
0 |  |  |  | 0 | 0 |  |  |  |  |  | 1 | Maver Mxi Series 5 SeatBox | 350
0 |  |  |  | 0 | 0 |  |  |  |  |  | 5 | Maver Umbrellas | 20
0 |  |  |  | 0 | 0 |  |  |  |  |  | 2 | [NAME] and Keep Net Pack | 30
0 |  |  |  | 0 | 0 |  |  |  |  |  | 15 | Miracle Paste 500g | 2.5
0 |  |  |  | 0 | 0 |  |  |  |  |  | 10 | [NAME] 16 Barbed Hooks Xtra Strong | 2
 |  |  |  | Total Excluding VAT | 0
 |  |  |  | VAT Rate | 0.2
 |  |  |  | Discount | £0.00
 |  |  |  | Discounted Total Excluding VAT | 0
 |  |  |  | Discounted Total VAT | 0
 |  |  |  | Total To Pay | 0
KingFisher Tackle
1 House Lakes, [NAME], Lincs, PE21TZ6
44[PHONE]
Hope To See You Soon!
Come To Us For Your Fishing Needs!
Spreadsheet: 794967d1662451624-make-a-summary-based-on-note-in-the-cell-make-an-summary-based-on-the-last-data-contain-note
Sheet: SUM AFTER NOTE

 |  | NO | DATE | Feed |  |  | NOTE |  |  |  | RESULT
 |  |  |  | Morning | Night | TOTAL
 |  | 1 | 2022-09-01 00:00:00 | 0 | 0 |  |  |  |  | PARSIAL DATE |  |  | THIS IS THE FORMULA THAT DEVINE THE LAST DATA > 0
 |  | 2 | 2022-09-02 00:00:00 | 30 | 0
 |  | 3 | 2022-09-03 00:00:00 | 30 | 30 |  |  |  |  | FEED BEFORE "PARSIAL" |  |  | THIS IS FINE
 |  | 4 | 2022-09-04 00:00:00 | 150 | 120
 |  | 5 | 2022-09-05 00:00:00 | 90 | 70
 |  | 6 | 2022-09-06 00:00:00 | 120 | 100 |  |  |  |  | FEED AFTER "PARSIAL" |  |  | THIS IS ERROR
 |  | 7 | 2022-09-07 00:00:00 | 120 | 120 |  |  |  |  | FEED AFTER "PARSIAL" |  |  | THIS THE RESULT THAT I WANT
 |  | 8 | 2022-09-08 00:00:00 | 150 | 30
 |  | 9 | 2022-09-09 00:00:00 | 150 | 30 |  | PARSIAL
 |  | 10 | 2022-09-10 00:00:00 | 150 | 60
 |  | 11 | 2022-09-11 00:00:00 | 150 | 75
 |  | 12 | 2022-09-12 00:00:00 | 150 | 33
 |  | 13 | 2022-09-13 00:00:00 | 150 | 30
 |  | 14 | 2022-09-14 00:00:00 | 0 | 0
 |  | 15 | 2022-09-15 00:00:00 | 0 | 0
Spreadsheet: kate_symes__18143__Deal Correction 2-12
Sheet: Prior Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-02-09 00:00:00 | 2001-02-09 00:00:00 | 2001-02-08 00:00:00 | LTSW | KS | Houston | TFS | Delivery Point: from SP to Palo |  | 517599 | Palo | Q3-02 | On [NAME] | 25 | 210 | SPP
 |  |  |  | KS Count
 | 2001-02-09 00:00:00 | 2001-02-09 00:00:00 | 2000-12-06 00:00:00 | LTSW | MM | Houston | Natsource | Broker fee: from 0 to .0075 |  | 475170 | SP-15 | Q3-01 | On [NAME] | 25 | 200 | EES
 |  |  |  | MM Count
 |  |  |  | Grand Count
Spreadsheet: 37344d1235327409-remove-duplicates-based-while-keeping-other-rows-in-tact-example
Sheet: Sheet1

 |  |  |  | This is What I Have
Part Number | Price | Quantity | Name | Description | Category | Manufacturer
KQ437AA#ABA | 1500 | 9 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
KQ437AA#ABA | 2000 | 20 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
KQ437AA#ABA | 1800 | 3 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
KQ437AA#ABA | 2300 | 0 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
[NAME] | 400 | 20 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
[NAME] | 350 | 15 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
[NAME] | 380 | 30 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
[NAME] | 345 | 5 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
KDL-32M4000 | 550 | 0 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
KDL-32M4000 | 680 | 0 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
KDL-32M4000 | 600 | 8 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
KDL-32M4000 | 700 | 0 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
 |  |  |  | This is What I Want
KQ437AA#ABA | 1500 | 32 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
[NAME] | 345 | 70 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
KDL-32M4000 | 550 | 8 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
Spreadsheet: 873914d1720517275-breakeven-point-break-even
Sheet: JT

 |  |  |  |  |  |  | Data > What-If Analysis > Goal Seek
 |  |  |  | Sales | 22424242.42424243
 |  |  |  | Profit
 |  |  |  | Tax1 (Refer below)
 |  |  |  | Tax2 (Fixed @25%)
 |  |  |  | Tax1 - Tax2
 |  | Profit |  | Tax1
 | First Slab | 600000 | 0
 | Next | 200000 | 0.1
 | Next | 300000 | 0.2
 | Next | 900000 | 0.3
 | Next | 3000000 | 0.36
 | Over 5,000,000 |  | 0.39
Spreadsheet: 1006044b-93c5-45f1-a2c4-9a47b11827b0
Sheet: Table 4.1

4.1 Turnover of retail establishments
Month | 2010–11 | 2011–12 | 2012–13 | 2013-14 | 2014-15
Value (a)(b) – $ million
July | 20401.7 | 20764.3 | 21564.4 | 22020.7 | 23310.7
August | 20436 | 20891.1 | 21567.8 | 22160.8
September | 20426.7 | 20905.7 | 21670.4 | 22351.9
October | 20231.8 | 20959.8 | 21639.8 | 22464.8
November | 20374.4 | 20996.3 | 21576.5 | 22628.7
December | 20436 | 21031.8 | 21556.4 | 22816.1
January | 20423.4 | 20970.9 | 21750.8 | 23074.3
February | 20644.8 | 21023.5 | 22016.1 | 23109.3
March | 20545.3 | 21298.4 | 21905.8 | 23134.4
April | 20730.4 | 21250.1 | 21907.3 | 23132.4
May | 20652.2 | 21457.7 | 21986.2 | 23067.2
June | 20587.3 | 21730.5 | 21987.2 | 23216.8
Annual | 245890 | 253280.1 | 261128.7 | 273177.4
Annual change (a) – per cent
July | 4.100397487511572 | 1.777302871819501 | 3.853248122980318 | 2.115987460815049 | 5.858124401131676
August | 3.964551526960264 | 2.22695243687609 | 3.239178406115514 | 2.749469115997002
September | 3.970132388645425 | 2.344970063691136 | 3.657854078074394 | 3.144842734790316
October | 2.366411827505431 | 3.598295752231621 | 3.244305766276383 | 3.812419708130392
November | 1.266930092696143 | 3.052359824092974 | 2.763344017755514 | 4.876601858503477
December | 2.258739229206498 | 2.915443335290661 | 2.494318127787466 | 5.843740142138756
January | 1.878095865196116 | 2.680748553130229 | 3.718962943888897 | 6.084833661290617
February | 3.753141019197898 | 1.834360226303971 | 4.721383214022396 | 4.965457097306071
March | 2.96795986588549 | 3.665558546236866 | 2.85185741651955 | 5.608560289968878
April | 2.823754656243963 | 2.506946320379711 | 3.092691328511393 | 5.592199860320534
May | 2.265445884316193 | 3.900310862765238 | 2.462985315294745 | 4.916720488306296
June | 1.526800376768563 | 5.552937976325211 | 1.181288971721784 | 5.592344636879631
Annual | 2.753436049159832 | 3.005449591280668 | 3.098782731055451 | 4.614084932066059
(a) Figures are seasonally adjusted.
(b)  Excludes hotels, licensed clubs, video hire outlets, hairdressing and beauty salons,
motor vehicle sales, motor vehicle parts and tyre retailing, fuel retailing and
marine equipment retailing. |  |  |  |  |  |  |  | Update
Source: ABS, Retail Trade, Australia, cat. no. 8501.0. July 2014 release. |  |  |  |  |  |  |  | 2014-10-01 00:00:00
Spreadsheet: 270077d1381362736-forecasting-daily-customer-count-due-to-certain-variables-forecasting-and-schedule
Sheet: Weather Forecast

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Date | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat
 | Temp
Closed below 70 | Weather
Closed below 77 if rain
 | Potential
Capacity | Less Actual Expected Visitors
5000 | Rain Loss
Rain loss | 70 degrees to 79 degrees (loss)
60% decrease | 80 degrees to 89 degrees (no change)
Temp | 90 degrees to 99 degrees (increase)
70= 40% decrease | 100 and up (increase
80= No change | Total Expected Customer Count
90= 40% increase
100=60% increase
Spreadsheet: 866430d1713347899-calculation-of-step-tax-with-sumproduct-function-under-the-condition-of-non-exemption-data
Sheet: Sheet1

Amount | Rate |  | Amount | Tax
12000 | 0 |  | 24000
20000 | 0.1 |  |  |  |  | 8000
27000 | 0.15 |  | This is absolutely true |  |  | 4000
40000 | 0.2
 | 0.25
Amount | Rate |  | Amount | Tax
12000 | 0.1 |  | 24000 | ????? |  | 12000
20000 | 0.15 |  |  |  |  | 8000
27000 | 0.2 |  |  |  |  | 4000
40000 | 0.25 |  | The expected answer in this case
 | 0.3
Spreadsheet: 726834d1617527127-sumproduct-adding-date-to-time-range-only-works-for-same-date-calculate-intermediate-task-dates-and-times-with-breaks-final-solution_mlan
Sheet: Production scedule

start date | run time |  |  |  | working week | [NAME] | fri
2021-02-01 14:00:00 |  | = 11 modules in 74 working hours |  |  | start work | 06:30:00 | 06:30:00 | start break | break time
 |  |  |  |  | morning break start | 09:00:00 | 09:00:00 | 09:00:00 | 20
 |  |  |  |  | morning break end | 09:20:00 | 09:20:00 | 12:00:00 | 25
 |  |  |  |  | lunch break start | 12:00:00
 |  |  |  |  | lunch break end | 12:25:00
 |  |  |  |  | end work | 15:15:00 | 11:50:00
 |  |  |  | run time | [NAME] and Times | Friday without breaks | Friday breaks (preliminary) | Mon - Thu without breaks | Mon - Thu breaks (prelim) | If Friday >11:50 | "New" Friday breaks (preliminary) | Prelim Due Date | If Friday >11:50 | "New" Friday Final breaks | Final Breaks | Final Due Date | Final Due Date  If Friday >11:50 |  | Total Time | Total Breaks and Time Between | Time Worked
 |  |  | 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
Spreadsheet: 25171d1216306966-create-a-list-by-job-code-book1
Sheet: Line-up Sheet

 |  | Server |  |  |  |  |  | [NAME]
 | 1 |  |  |  |  | # of | 1
 | 2 |  |  |  |  | AM | 2
 | 3 |  |  |  |  | 0 | 3
 | 4 |  |  |  |  | # of | 4
 | 5 |  |  |  |  | PM | 5
 | 6 |  |  |  |  | 0 | 6
 | 7 |  |  |  |  |  | 7
 | 8 |  |  |  |  |  | 8
 | 9 |  |  |  |  |  | 9
 | 10 |  |  |  |  |  | 10
 | 11 |  |  |  |  |  | 11
 | 12 |  |  |  |  |  | 12
 | 13 |  |  |  |  |  | 13
 | 14 |  |  |  |  |  | 14
 | 15 |  |  |  |  |  | 15
 | 16 |  |  |  |  |  | 16
 | 17
 | 18 |  |  |  |  |  |  | Dish/Garden Bar
 | 19 |  |  |  |  |  | 1
 | 20 |  |  |  |  |  | 2
 | 21 |  |  |  |  |  | 3
 | 22 |  |  |  |  |  | 4
 | 23 |  |  |  |  |  | 5
 | 24 |  |  |  |  |  | 6
 | 25 |  |  |  |  |  | 7
 | 26 |  |  |  |  |  | 8
 | 27 |  |  |  |  |  | 9
 | 28 |  |  |  |  |  | 10
 | 29
 | 30 |  |  |  |  |  |  | Host/QSS
 | 31 |  |  |  |  |  | 1
 | 32 |  |  |  |  |  | 2
 | 33 |  |  |  |  |  | 3
 | 34 |  |  |  |  |  | 4
 | 35 |  |  |  |  |  | 5
 | 36 |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  | [NAME] |  |  |  |  | 8
 | 1 |  |  |  |  |  | 9
 | 2 |  |  |  |  |  | 10
 | 3 |  |  |  |  |  | 11
 | 4 |  |  |  |  |  | 12
 | 5 |  |  |  |  |  | 13
 | 6 |  |  |  |  |  | 14
 |  |  |  |  |  |  | 15
 |  | Bar |  |  |  |  | 16
 | 1 |  |  |  |  |  | 17
 | 2
 | 3 |  |  |  |  |  |  | Shift Lead
 | 4 |  |  |  |  |  | 1
 | 5 |  |  |  |  |  | 2
 | Monday |  |  |  |  |  |  | 2008-07-04 00:00:00