tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18833__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-12 00:00:00 |  | 263.78 | 24240 | 255.08 | 7632
 | 2001-03-11 00:00:00 |  | 265 | 0 | 230 | 200 | 219.32 | 111 | 174.9 | 264 |  | 255.41 | 23256
 | 2001-03-10 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 247.11 | 873 | 227.78 | 709
 | 2001-03-09 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 277.5 | 52 | 230.19 | 982
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624 | 282.12 | 2609 | 247.42 | 748
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 |  |  |  |  |  | ..
Spreadsheet: 66a29c67-4594-442a-a441-e089e2dfb043
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CBLAS | Test | CBLAS | Blastomyces Antibody by EIA, [NAME] | Blastomyces Ab, EIA, CSF | Enzyme Immunoassay (EIA) | [NAME], round-bottom, plastic vial: ScwRBPl |  |  | 1 | mL | Container/Tube: Sterile vial [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative | Monday through Friday, Sunday; 9 a.m. | 1 day | 3 days | 1 | 86612 |  |  |  |  | Rochester
CBLAS | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
CBLAS | Result | CBLAS | Blastomyces Ab, EIA, CSF | Blastomyces Ab, EIA, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18197-4
Spreadsheet: 730813d1619964575-find-the-percentage-a-cell-is-in-a-time-range-and-the-average-time-within-each-5x20-strategy-tms
Sheet: RESULTS

 |  |  |  | TimeRange is a Named [NAME] defining cells B4:B9
 | TIME TRADED % |  | Using SPILL | =IFERROR(AVERAGEIFS(DATA!C:C,DATA!C:C,">="&TIMEVALUE(LEFT(TimeRange,FIND("-",TimeRange)-1)),DATA!C:C,"<"&TIMEVALUE(RIGHT(TimeRange,(LEN(TimeRange)-FIND("-",TimeRange))))),0)
 |  |  |  |  | SUMIFS | COUNTIFS | SUMIFS/COUNTIFS
 | 6:00-8:59 |  |  | =IFERROR(AVERAGEIFS(DATA!C:C,DATA!C:[NAME]:C,"<"&TIMEVALUE(RIGHT(B4,(LEN(B4)-FIND("-",B4))))),0)
 | 9:30-9:49 |  | 0.3994731800766283
 | 9:50-10:29 |  | 0.4210317460317461
 | 10:30-11:29 |  | 0.4563131313131313 |  |  |  |  | TMS TEST 15:00
 | 11:30-14:59 |  | 0.5157986111111111 |  |  |  |  | SUMIFS | COUNTIFS
 | 15:00-16:00 |  | 0.625 | Note: 15:00 entry added to test the formula for this range
 | GAIN/LOSS
 | Trading Days Span | 53
 | Trading Days
 | Trading Days %
 | Total Wins
 | Total Points /share
 | Average Points /share |  |  | Excluding top 2 and bottom 2
 | Win/Loss % |  |  | Note, this is Win % on days there was a 5x20 strategy win
 | ENTRY REASON %
 | PM CONSOLIDATION
 | R2G
 | MOMO
 | CONSOLIDATION
 | PMH
 | BO
 | HIGHS %
 | Entry-High Ave |  |  | Percentage High above Entry
 | High-Close Ave |  |  | Percentage High above Close
Spreadsheet: 5276e106-c228-423d-ba49-5b852d3e3965
Sheet: Fall 2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
HSE Continuing Studies
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Tuition Code | Amount Per Credit | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B6

Local 6
Nom: | Benoît Grégoire
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2014-01-01 00:00:00
[NAME]: | 2
Réservé: | Réservé
Prix: | 140
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 794959d1662439777-make-an-average-based-on-the-data-that-contain-number-0-make-an-average-based-on-the-last-data-contain-number
Sheet: FIND SUMMARY

 |  | NO | DATE | Feed |  |  |  |  |  |  | RESULT
 |  |  |  | Morning | Night | TOTAL
 |  | 1 | 2022-09-01 00:00:00 | 0 | 0 |  |  |  |  | LAST FEED |  |  | 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 |  |  |  |  | LAST 5 DAYS |  |  | THIS IS THE AVERAGE I WANT FROM THE LAST FEED
 |  | 4 | 2022-09-04 00:00:00 | 150 | 120
 |  | 5 | 2022-09-05 00:00:00 | 90 | 70 |  |  |  |  | LAST 10 DAYS |  |  | I WANT TO MAKE BOTH AUTOMATICALLY AVERAGING FEED FROM THE PAST 5 OR 10 DAYS SINCE THE LAST DATE THAT CONTAIN NUMBER
 |  | 6 | 2022-09-06 00:00:00 | 120 | 100
 |  | 7 | 2022-09-07 00:00:00 | 120 | 120
 |  | 8 | 2022-09-08 00:00:00 | 150 | 30
 |  | 9 | 2022-09-09 00:00:00 | 150 | 30
 |  | 10 | 2022-09-10 00:00:00 | 150 | 30
 |  | 11 | 2022-09-11 00:00:00 | 150 | 30
 |  | 12 | 2022-09-12 00:00:00 | 150 | 30
 |  | 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: 733088d1621381342-column-g-will-not-sum-up-using-formula-sum-g-g542-book1
Sheet: Sheet1

 | Total = |  |  |  | Total = |  |  | Total Submitted |  | Total= |  |  | Remaining Owed
Date | Expense | Cost |  | Date | Hours | Cost |  |  |  | Date | Paid
2021-04-29 00:00:00 | Airfare to VA | 529.4 |  | 2021-05-05 00:00:00 | 1 |  |  |  |  | 2021-05-18 00:00:00 | 1200
2021-05-09 00:00:00 | Airfare Luggage to VA | 35 |  | 2021-05-06 00:00:00 | 1
2021-05-07 00:00:00 | Airfare Luggage to UT | 35 |  | 2021-05-07 00:00:00 | 1
2021-05-12 00:00:00 | Batteries | 20.93 |  | 2021-05-08 00:00:00 | 1
2021-05-07 00:00:00 | Airfare to NC | 496.4
2021-05-04 00:00:00 | Car Rental VA | 493.72
Spreadsheet: 883582d1732207630-calculate-average-times-something-is-entered-per-date-urgent-case-tracking-2024
Sheet: Sheet1

Case Number | Date Entered
68498 | 2024-11-13 00:00:00
68554 | 2024-11-14 00:00:00
68581 | 2024-11-15 00:00:00
68550 | 2024-11-15 00:00:00
68612 | 2024-11-18 00:00:00
68618 | 2024-11-18 00:00:00
68629 | 2024-11-18 00:00:00
68641 | 2024-11-19 00:00:00
68647 | 2024-11-19 00:00:00
68651 | 2024-11-19 00:00:00
68652 | 2024-11-19 00:00:00
68695 | 2024-11-20 00:00:00
68710 | 2024-11-20 00:00:00
68711 | 2024-11-20 00:00:00
68725 | 2024-11-21 00:00:00
Spreadsheet: 719727d1613767135-multi-search-with-aggregate-colleague-list-vs-final-list-example
Sheet: Sheet1

[NAME] | Site | Primary Need |  | Colleague List
Colleague 1 | A | Transfer - No Need
Colleague 2 | A (existing) | ABC
Colleague 3 | B | XYZ
Colleague 4 | C | TEST
Colleague 5 | C | Transfer - No Need
Colleague 6 | B | ABC
Colleague 7 | A | XYZ
Colleague 8 | B (existing) | TEST
Colleague 9 | C | TEST
Colleague 10 | A | XYZ
 | If colleague has a Site listed with the word "exisiting" and or a Primary Need with the word "Transfer", colleague should not appear on Colleague List. I was able to omit colleagues with site word existing but need it also for primary need transfer word.
Spreadsheet: 158731d1338380357-how-to-go-to-a-specific-cell-onworksheetactivateevent
Sheet: Sheet1

Date
2012-05-22 00:00:00
2012-05-23 00:00:00
2012-05-24 00:00:00
2012-05-25 00:00:00
2012-05-26 00:00:00
2012-05-27 00:00:00
2012-05-28 00:00:00
2012-05-29 00:00:00
2012-05-30 00:00:00
2012-05-31 00:00:00
2012-06-01 00:00:00
2012-06-02 00:00:00
2012-06-03 00:00:00
2012-06-04 00:00:00
2012-06-05 00:00:00
2012-06-06 00:00:00
2012-06-07 00:00:00
2012-06-08 00:00:00
2012-06-09 00:00:00
2012-06-10 00:00:00
2012-06-11 00:00:00
2012-06-12 00:00:00
2012-06-13 00:00:00
2012-06-14 00:00:00
2012-06-15 00:00:00
2012-06-16 00:00:00
2012-06-17 00:00:00
2012-06-18 00:00:00
2012-06-19 00:00:00
2012-06-20 00:00:00
2012-06-21 00:00:00
Spreadsheet: 845470d1696968326-problem-with-league-table-golfscoresmultiplayerlive
Sheet: Handicaps

 |  |  | 2023-12-04 00:00:00 | 2024-01-08 00:00:00 | 2024-02-05 00:00:00 | 2024-03-04 00:00:00 | 2024-04-08 00:00:00 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00
Team/Hcap | StartHcp
Team1
Player1 | 12
Player2 | 17
Player3 | 16
Player4 | 17
Team2
Player5 | 10
Player6 | 15
Player7 | 19
Player8 | 22
Team3
Player9 | 15
Player10 | 20
Player11 | 25
Player12 | 28
Team4
Player13 | 13
Player14 | 19
Player15 | 21
Player16 | 22
Team5
Player17 | 12
Player18 | 14
Player19 | 19
Player20 | 23
Team6
Player21 | 17
Player22 | 19
Player23 | 22
Player24 | 25
Team7
Player22 | 10
Player23 | 16
Player24 | 22
Player25 | 25
Spreadsheet: 220534dd-e8ef-4483-9bbe-0c038687242e
Sheet: Tata-Tertib

 | DIKLAT ONLINE PPPPTK IPA
 | Selamat datang di Program Diklat Online Pusat [NAME] dan Pemberdayaan Pendidik Ilmu Pengetahuan Alam (PPPPTK IPA). Sebelum Anda [NAME], mohon pelajari tata tertib peserta Diklat Online PPPPTK IPA.
 | TATA TERTIB PESERTA DIKLAT ONLINE
 | 1.      [NAME] hanya diperkenankan memilih [NAME] satu mata diklat,
 | 2.      Selama proses pembelajaran asyinchoronous peserta diharuskan [NAME] secara mandiri [NAME] dalam bentuk modul digital, PowerPoint dan flash.
 | 3.      Peserta diharuskan [NAME] synchronous (chatting) dan/atau web conference, apabila fasilitator meminta peserta untuk [NAME] [NAME].
 | 4.      Mengakses link terkait dengan [NAME] oleh fasilitator.
 | 5.      Mengerjakan tugas-tugas [NAME] setiap [NAME].
 | 6.      Menjawab evaluasi formatif untuk setiap [NAME] [NAME] waktu [NAME]..
 | 7.      Peserta yang nilainya tidak memenuhi nilai ambang batas (passing grade) atau angka kurang dari 70 (Nilai < 70) untuk setiap kegiatan [NAME] (diskusi, [NAME], [NAME] kegiatan tersebut sesuai dengan waktu [NAME] oleh fasilitator.
 | 8.      Semua kegiatan [NAME] [NAME], artinya peserta tidak diperkenankan [NAME] orang lain untuk mengisi diskusi, tugas [NAME] soal-soal tes.
 | 9.      [NAME] diketahui peserta tidak aktif dalam pembelajaran selama [NAME] 3 hari secara berturut-turut akan diberikan peringatan.
 | 10.  [NAME] jelasan dalam [NAME] fasilitator [NAME] bersangkutan pada jam kerja atau dapat melalaui administrator sistem diklat online.
 | 11.  Penilaian fasilitator bersifat final.
 | 12.  [NAME] tidak diperkenankan [NAME] tugas peserta lain.
 | 13.  Dalam memberikan komentar pada forum, gunakan [NAME] sopan [NAME].
 | 14.  Peserta yang mengikuti seluruh proses [NAME] nilai passing grade, [NAME] peserta diklat online [NAME] [NAME].
 | 15.  [NAME] biaya [NAME] kegiatan pembelajaran online, ditanggung oleh peserta.
 | CARA BELAJAR
 | 1.        [NAME] setelah [NAME],
 | 2.        [NAME] semua [NAME] ada pada pembelajaran (Forum, Chat, Web Conference),
 | 3.        Kerjakan soal-soal ([NAME], formatif, maupun take home test),
 | 4.        Kerjakan tugas (Pengamatan, praktikum, laporan, LKS) [NAME] [NAME] fasilitator anda,
 | 5.        Tanyakan jika [NAME] atau jika [NAME] dengan fasilitator.
Spreadsheet: 121555d1316148426-alternative-to-if-and-concencate-to-return-a-date-as-month-and-year-book1
Sheet: PIVOT

 | Month | Data
 | 12 2010 |  | 5-2011 |  | DEC 2010 |  | 2010-12-18 00:00:00 |  | 2011-05-26 00:00:00 |  | (blank) |  | Total Number | Total Percent
Subject | Number | Percent | Number | Percent | Number | Percent | Number | Percent | Number | Percent | Number | Percent
Finance |  | 0 |  | 0 |  | 0 |  | 0 | 1 | 0.1 | 1 | 0.1 | 2 | 0.2
Information |  | 0 |  | 0 | 1 | 0.1 |  | 0 |  | 0 |  | 0 | 1 | 0.1
New |  | 0 | 1 | 0.1 |  | 0 |  | 0 |  | 0 | 2 | 0.2 | 3 | 0.3
Other | 1 | 0.1 |  | 0 |  | 0 | 1 | 0.1 |  | 0 | 1 | 0.1 | 3 | 0.3
Unknown |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 1 | 0.1 | 1 | 0.1
(blank) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Grand Total | 1 | 0.1 | 1 | 0.1 | 1 | 0.1 | 1 | 0.1 | 1 | 0.1 | 5 | 0.5 | 10 | 1
Spreadsheet: 716343d1612181306-retrieve-filtered-rows-from-one-table-into-another-tables-sample
Sheet: Sheet1

id | region | quantity |  | northerns |  | Northerns | Quantity | Height |  | id | q
1 | North | 100 |  |  |  | 1
2 | North | 200 |  |  |  | 2
3 | North | 100 |  |  |  | 4
4 | North | 300 |  |  |  | 7
5 | South | 100 |  |  |  | 8
6 | South | 400 |  |  |  | 9
7 | North | 500 |  |  |  | 11
8 | North | 100 |  |  |  | 14
9 | North | 200 |  |  |  | 15
10 | South | 100 |  |  |  | 16
11 | North | 300 |  |  |  | 18
12 | South | 100 |  |  |  | 21
13 | South | 400
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 |  |  |  |  |  | This table is what I want. Here, the "Northerns" column is manual, but I want it dynamic, from the source table
Spreadsheet: phillip_m_love__30157__PeopleFRED
Sheet: Recon Variances

DESK | TAGG | [NAME] | VLookupGL | [NAME] | ABS | FVAR/AVAR | Desk Adjustment | GL Adjustment/Reclass | Comments
People | N30819.1 | -261374.9564999999 | 261391.46 | 16.50350000013714 | 16.50350000013714 |  |  |  | Immaterial; under $100 |  | False
People | N18064.4 | 200 | 0 | 200 | 200 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17872.5 | 600 | 0 | 600 | 600 |  |  |  | In FL not GL, Acct to look at |  | False
People | N18064.2 | -1937.5 | 0 | -1937.5 | 1937.5 |  |  |  | In FL not GL, Acct to look at |  | False
People | N18064.1 | -5490.875 | 0 | -5490.875 | 5490.875 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17805.1 | -5500.95 | 0 | -5500.95 | 5500.95 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17807.1 | -7751.55 | 0 | -7751.55 | 7751.55 |  |  |  | In FL not GL, Acct to look at |  | False
People | [NAME] | -9300 | 0 | -9300 | 9300 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17798.2 | 15500.0155 | 0 | 15500.0155 | 15500.0155 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17798.1 | -15887.5155 | 0 | -15887.5155 | 15887.5155 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17800.1 | -18600 | 0 | -18600 | 18600 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17813.1 | -18600 | 0 | -18600 | 18600 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17808.1 | -28151.1 | 0 | -28151.1 | 28151.1 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17799.2 | -28790.01 | 0 | -28790.01 | 28790.01 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17872.2 | -37237.4325 | 0 | -37237.4325 | 37237.4325 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17872.1 | -50228.37 | 0 | -50228.37 | 50228.37 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17872.7 | 274425 | 0 | 274425 | 274425 |  |  |  | In FL not GL, Acct to look at |  | False
People | N17872.3 | 640325 | 0 | 640325 | 640325 |  |  |  | In FL not GL, Acct to look at |  | False
Spreadsheet: 81281d1281523403-100-stacked-bar-problem-chart_problem
Sheet: Sheet1

Chart #
1 | Green | Red
 | 6 | 1
2 | Green | Red
 | 5 | 2
3 | Green | Red
 | 4 | 3
4 | Green | Red
 | 3 | 4
5 | Green | Red
 | 2 | 5
6 | Green | Red
 | 1 | 6
Spreadsheet: 66863d1267549358-forecasting-trends-prediction-forecasting-example
Sheet: Forecasting Example

Area | Sales | Demand | Drivetime | Penetration | Weighted Penetration
A | 9999 | 49280 | 6.57 | 20.29017857142857 | 3.088307240704501
B | 8754 | 33546 | 8.64 | 26.09551064210338 | 3.020313731724928
C | 8034 | 51278 | 11.83 | 15.6675377354811 | 1.324390341122663
D | 7878 | 51950 | 8.77 | 15.16458132820019 | 1.729142682805039
E | 7233 | 38566 | 9.25 | 18.75486179536379 | 2.027552626525815
F | 5643 | 43193 | 7.46 | 13.0646169518209 | 1.751289135632828
G | 4445 | 65587 | 14.31 | 6.777257688261392 | 0.4736029132258135
H | 4432 | 49717 | 11.23 | 8.914455819940866 | 0.7938072858362302
I | 3245 | 41802 | 15.17 | 7.762786469546912 | 0.5117196090670344
J | 3089 | 40429 | 11.74 | 7.640555047119642 | 0.6508138881703271
Spreadsheet: 079d1006-d2c7-46e2-94d6-9189c71237ea
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
 | 5671.0 Lending Finance, Australia
 | TABLE 34. LEASE FINANCE COMMITMENTS, By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413927F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413929K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413930V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413931W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413932X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413933A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413934C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413935F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413936J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413938L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413939R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413940X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413941A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413942C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 6f5258b1-5c7c-441c-9b0c-c78d85d1d4d2
Sheet: Sheet1

ns1:Position | ns1:PosStatus | ns1:PosStatusComplement | ns1:PosStatusComplementData | ns1:CompetitorFEIID | ns1:CompetitorFirstname | ns1:CompetitorFamilyname | ns1:HorseFEIID | ns1:HorseCompleteName | ns1:Prize | ns1:PrizeCurrency | ns1:IsWNominated | ns1:TeamNF | ns1:CompetingFor | ns1:JudgeKTech | ns1:JudgeKArt | ns1:[NAME] | ns1:JudgeEArt | ns1:[NAME] | ns1:JudgeHArt | ns1:JudgeCTech | ns1:JudgeCArt | ns1:JudgeMTech | ns1:[NAME] | ns1:JudgeBTech | ns1:JudgeBArt | ns1:JudgeFTech | ns1:JudgeFArt | ns1:TotalScore
Spreadsheet: 710668d1609175635-find-and-return-values-based-off-of-multiple-conditions-return-multiple-matches-with-multiple-conditions-jacc-2
Sheet: REQUEST Jacc interp

PRODUCT | QTY REQ | Filter | Filter | Filter | Solver binary | Solver result
39573004420 | 420 |  | 1.73217304018652e+17 | 28 | 0
 |  | 39573004420 | 2.7312981702202e+17 | 30 | 1
 |  | 39573004420 | 2.7312981702202e+17 | 35 | 1
 |  | 39573004420 | 2.73129817022021e+17 | 40 | 0
 |  | 39573004420 | 1.7321730397559e+17 | 40 | 1
 |  | 39573004420 | 1.7321730397559e+17 | 45 | 0
 |  | 39573004420 | 2.73129817021973e+17 | 50 | 1
 |  | 39573004420 | 2.73129817021973e+17 | 50 | 0
 |  | 39573004420 | 2.7312981702198e+17 | 52 | 1
 |  | 39573004420 | 2.73129817021976e+17 | 52 | 1
 |  | 39573004420 | 2.7312981702198e+17 | 53 | 1
 |  | 39573004420 | 2.73129817021981e+17 | 53 | 1
 |  | 39573004420 | 2.73129817022021e+17 | 55 | 0
 |  | 39573004420 | 2.73129817021992e+17 | 55 | 1
 |  | 39573004420 | 2.73129817021995e+17 | 55 | 0
 |  | 39573004420 | 1.7321730397559e+17 | 55 | 0
 |  |  |  |  | Sum
 |  |  |  |  | Deviation