tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 782757d1654242404-counting-cells-up-to-a-value-excluding-some-sample-worksheet-attached-copy-vc-aligw
Sheet: Hot & Cold Spot (90.5°C for 10)

 | [NAME]
 | First
 | Second
 | Third
 | Rows (for checking) | Probe 1 | Probe 2 | Probe 3 | Probe 4 | Probe 5 | Probe 6 | Probe 7 | Probe 8
 |  | 3 |  | 3 |  | 3 |  | 3
 |  | 4 |  | 3 |  | 4 |  | 4
 |  | 5 | 3 | 3 |  | 5 |  | 6
 |  | 6 | 4 | 3 |  | 6 |  | 5
 |  | 8 | 5 | 3 |  | 8 |  | 8
 |  | 12 | 6 | 4 |  | 12 |  | 12
 |  | 30 | 8 | 5 |  | 30 |  | 6
 |  | 50 | 12 | 6 |  | 50 |  | 50
 |  | 70 | 30 | 8 |  | 70 |  | 70
 |  | 90 | 50 | 12 |  | 3 |  | 5
 |  | 95 | 70 | 30 |  | 4 |  | 4
 |  | 90.5 | 90 | 50 |  | 90 |  | 90
 |  | 60 | 95 | 70 |  | 4 |  | 4
 |  | 50 | 90.5 | 90 |  | 1 |  | 1
 |  | 4 | 60 | 95 |  | 4 |  | 4
 |  | 3 | 3 | 90.5 |  | 3 |  | 3
 |  | 1 | 30 | 60 |  | 1 |  | 1
 |  | 6 | 20 | 3 |  | 6 |  | 6
 |  | 3 | 10 | 30 |  | 3 |  | 3
 |  | 4.5 | 6 | 20 |  | 4.5 |  | 4.5
 |  |  | 3 | 10
 |  |  | 4.5 | 6
 |  |  |  | 3
 |  |  |  | 4.5
Spreadsheet: 803572d1667557033-accumulating-time-based-on-time-values-in-another-cell-trial-flexi
Sheet: Lookups

Day | Monday |  | Tabs | Start | Finish | 1/2 Annual Leave | Public Holidays
Night | Tuesday |  |  | 2022-02-20 00:00:00 | 2022-04-02 00:00:00 | Annual Leave | 2022-01-01 00:00:00
Rest | Wednesday |  |  |  |  | Compassionate | 2022-03-17 00:00:00
 | Thursday |  |  |  |  | Flexi taken | 2022-03-18 00:00:00
 | Friday |  |  |  |  | Force Majeure | 2022-04-18 00:00:00
 | Saturday |  |  |  |  | Good Friday | 2022-05-02 00:00:00
 | Sunday |  |  |  |  | Half Flexi | 2022-06-06 00:00:00
 |  |  |  |  |  | Jury | 2022-08-01 00:00:00
 |  |  |  |  |  | Meeting | 2022-10-31 00:00:00
 |  |  |  |  |  | Other | 2022-12-25 00:00:00
 |  |  |  |  |  | Public Holiday | 2022-12-26 00:00:00
 |  |  |  |  |  | Sick leave
 |  |  |  |  |  | TOIL taken
 |  |  |  |  |  | Training
 |  |  |  |  |  |  |  |  |  |  | Lookups
Spreadsheet: 765541d1643381240-insert-a-column-of-cells-based-on-a-simple-number-insert-a-block-of-cells-001
Sheet: Sheet1

4 |  |  | d1 | e1 | f1 | g1 | h1
 |  |  | d2 | e2 | f2 | g2 | h2
 |  |  | d3 | e3 | f3 | g3 | h3
 |  |  | d4 | e4 | f4 | g4 | h4
 |  |  | d5 | e5 |  | g5 | h5
 |  |  | d6 |  |  | g6
 |  |  | d7
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-09-P-0219

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-09-P-0219 |  |  | 1P
W912LP-09-P-0219 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -13023 | -11000
2 | -20518 | -15000
3 | 0 | 0
4 | -6053 | -7500
5 | -27198 | -10000
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
2001-05-31 00:00:00 |  |  | 12683
2001-06-05 00:00:00
Spreadsheet: 820988d1678375335-data-selection-using-drop-down-options-book1-andyd1234-
Sheet: 0103

[NAME] | Status | Contract Value |  |  | qty | value
123 | Won | 132500 |  | won
124 | In Process | 155000 |  | lost
127 | Lost | 76000 |  | in process
128 | Won | 145000
130 | Won | 30000
131 | In Process | 22000
134 | In Process | 86000
137 | In Process | 90000
139 | Lost | 40000
141 | Won | 200000
Spreadsheet: 885152d1734573492-how-to-change-denominations-into-currency-viclea-book1
Sheet: Sheet1

 |  |  |  | 50 | 20 | 10 | 5 | 1 | 0.25 | 0.1 | 0.05 | 0.01
151.2
 |  | Solution
Spreadsheet: 124077d1318063871-find-max-time-between-dates-copy-of-2007-2010-rwi-lti-mti-free-days-data-2-
Sheet: Sheet1

Date | Injury | Department
2007-01-01 00:00:00 | LTI | Mining
2007-01-01 00:00:00 | RWI | Mining
2007-01-12 00:00:00 | MTI | Mining
2007-02-12 00:00:00 | RWI | Mining
2007-02-23 00:00:00 | RWI | Geology
2007-02-25 00:00:00 | RWI | Mining
2007-03-04 00:00:00 | RWI | Mining
2007-03-21 00:00:00 | RWI | Mining
2007-04-18 00:00:00 | LTI | Mining
2007-04-21 00:00:00 | RWI | Geology
2007-04-28 00:00:00 | RWI | Mining
2007-05-05 00:00:00 | LTI | [NAME]
2007-05-07 00:00:00 | LTI | Mining
2007-05-12 00:00:00 | RWI | Engineering
2007-05-22 00:00:00 | MTI | Mining
2007-05-29 00:00:00 | MTI | Mining
2007-06-01 00:00:00 | RWI | Mining
2007-06-01 00:00:00 | RWI | Mining
2007-06-03 00:00:00 | MTI | Mining
2007-06-06 00:00:00 | RWI | [NAME]
2007-07-17 00:00:00 | MTI | Mining
2007-08-01 00:00:00 | LTI | Mining
2007-08-01 00:00:00 | RWI | Geology
2007-08-05 00:00:00 | MTI | Projects
2007-08-14 00:00:00 | LTI | Geology
2007-08-15 00:00:00 | MTI | HR & Admin
2007-09-03 00:00:00 | LTI | HR & Admin
2007-09-20 00:00:00 | RWI | Geology
2007-09-21 00:00:00 | LTI | Mining
Spreadsheet: eric_saibi__9870__101901R
Sheet: Big Cajun II 03

Owner Name | Louisiana Generating
Station Name | Big Cajun II Power Station
Unit Name | Big Cajun II 03
NERC Region | SERC
State | LA
Fuel Type | Coal
Capacity | 611 MW
Start Date | 2002-03-15 00:00:00
End Date | 2002-04-25 00:00:00
Prv. Start Date | 2001-10-16 00:00:00
Prv. End Date | 2001-11-26 00:00:00
Comments | The work will be done in the spring; approx spring start date
SIC | 4911
Plant ID | 1005163
Unit ID | 1004084
Outage ID | 10756
Spreadsheet: 848982d1699559052-vlook-up-from-pivot-sheet-on-two-condition-sample-file
Sheet: Raw

Level | Product | Qua A | Qua B
S1 | Apple | 20 | 10
S2 | Orange | 171 | 18
P1 | Kiwi | 23 | 34
S2 | Apple | 133 | 34
P1 | Orange | 132 | 23
S1 | Kiwi | 214 | 2
P1 | Apple | 133 | 4
S2 | Orange | 22 | 222
P1 | Kiwi | 12 | 344
S1 | Apple | 123 | 344
S2 | Orange | 221 | 444
P1 | Kiwi | 1244 | 321
Spreadsheet: 870304d1716842918-inserting-rows-and-keeping-formula-anonymised-history-group-spreadsheet
Sheet: A - DAY BOOK

 |  |  |  |  |  |  |  |  |  |  | INCOME |  |  |  |  |  | EXPENDITURE
Date | Description | Cash Debit | Cash Credit | Bank Debit | Bank Credit | CASH BALANCE | BANK BALANCE | CREDITORS | [NAME] | Check col | Subs | Donations | Meetings | Bank interest | [NAME] | [NAME]. | Supplies | Equipment | Meetings4 | Bank charges | Exp. [NAME]
 | Balance brought forward |  | 0 |  | 3636.87 | 0 |  | 0 | 0
Janauary 2023
2 | Subs (Smith) |  |  |  |  |  |  |  |  |  | 10
9 | Sub (Jones) |  |  |  | 5 |  |  |  |  |  | 5
15 | Monthly fee |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
22 | Online payment - Village Hall Mickleham |  |  | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 | Sub ( Bloggs) |  |  |  | 5 |  |  |  |  |  | 5
30 | Online payment - |  |  |  | 10 |  |  |  |  |  |  |  | 10
 | Sub (Fred) |  |  |  | 10 |  |  |  |  |  | 5 | 5
Total
Spreadsheet: 792699d1661088341-summarizing-weeklies-into-a-monthly-testrunyearxls
Sheet: Month01

ID | Name | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 | 2023-01-07 00:00:00 | 2023-01-08 00:00:00 | 2023-01-09 00:00:00 | 2023-01-10 00:00:00 | 2023-01-11 00:00:00 | 2023-01-12 00:00:00 | 2023-01-13 00:00:00 | 2023-01-14 00:00:00 | 2023-01-15 00:00:00 | 2023-01-16 00:00:00 | 2023-01-17 00:00:00 | 2023-01-18 00:00:00 | 2023-01-19 00:00:00 | 2023-01-20 00:00:00 | 2023-01-21 00:00:00 | 2023-01-22 00:00:00 | 2023-01-23 00:00:00 | 2023-01-24 00:00:00 | 2023-01-25 00:00:00 | 2023-01-26 00:00:00 | 2023-01-27 00:00:00 | 2023-01-28 00:00:00 | 2023-01-29 00:00:00 | 2023-01-30 00:00:00 | 2023-01-31 00:00:00
Week04
100 | [NAME]
101 | [NAME]
102 | Fredericson
103 | [NAME]
Spreadsheet: james_steffes__12820__Enron status 12-5-01
Sheet: Enron 12-5-01

ESI-ID | Service Order Status | Service Order Type | TDSP Name | [NAME] 12-5-01
10443720006871343 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720007738300 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720006522263 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720003630335 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720003625902 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720006171483 | Cancelled | Switch | TXU ELECTRIC CO (TDSP) | Cancelled
10443720005335301 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720003001397 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720004233186 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720004431331 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720005335270 | Complete | Switch | TXU ELECTRIC CO (TDSP) | DTP In Review
10443720003538593 | Cancelled | Switch | TXU ELECTRIC CO (TDSP) | Cancelled
Spreadsheet: 86272d1286290664-sumif-with-multiple-conditions-active-cc
Sheet: Card Totals

 | Chase (WaMu) | Amazon | Bank of America | Citi Platinum | [NAME] | [NAME] | Citi Forward | Citi (Jillian) | 53rd | [NAME] ([NAME]) | [NAME] (Jillian) | Discover | Total
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-01 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-01 00:00:00
Spreadsheet: 784464d1655743127-extract-month-number-from-month-name-different-language-2022-06-20-oeldere-sonu1975-book1
Sheet: Insert Data

 |  |  |  |  |  |  |  |  | ↓↓ Insert actual year ↓↓ |  |  |  |  | ↓↓ Insert actual month ↓↓ |  |  |  |  | ↓↓ Insert actual month ↓↓
 |  |  |  |  |  |  |  |  | 2022 |  |  |  |  | Maj
english | swedish
Jan | 1
Feb | 2
Mar | 3
Apr | 4
May | 5
Jun | 6
Jul | 7
Aug | 8
Sep | 9
Oct | 10
Nov | 11
Dec | 12
Spreadsheet: 741124d1626849022-countifs-and-dates-stats-wip
Sheet: Calculation

Current Open Tickets
Closed Calls
Total Calls
Calls Per SVD for June | OPEN | CLOSED
HUBBLE
SEAS AP & VENDOR
SEAS DEVELOPMENT
SEAS ASSESSMENT
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS sys admin
SEAS T & B
Totals
Weekly totals Open | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00
Hubble BI Team (DO NOT ASSIGN)
SEAS AP and Vendor
SEAS Development
SEAS Assessment
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS System Admin
SEAS Treasury & Banking
Weekly totals closed
HUBBLE
SEAS AP & VENDOR
SEAS DEVELOPMENT
SEAS ASSESSMENT
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS sys admin
SEAS T & B
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, November 30 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 91707d1291378462-vlookup-problem-test-database
Sheet: TestProducts

Product | Unit |  |  |  |  |  | Catergory |  | Flashings | Unit | Price | Labour | Rooffng | Unit | Price | Labour
.42 Zincalume CGI | m2 |  |  |  |  |  | Roofing |  | 100 | L/M | 3.5 | 4 | Zinc | m2 | 12 | 2
.42 Zincalume Superdek | m2 |  |  |  |  |  | Flashing |  | 200 | L/M | 6.5 | 4 | Colorbond | m2 | 13 | 3
.42 Zincalume Smartspan | m2 |  |  |  |  |  | Wall Cladding |  | 300 | L/M | 7.5 | 4 | Galv | m2 | 14 | 4
.42 Zincalume Prodek | m2 |  |  |  |  |  | Downpipes
5 | ln |  |  |  |  |  | Gutters
6 | ea |  |  |  |  |  | [NAME]
7 | m2 |  |  |  |  |  | Anticon
8 | m2
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 273175d1382629725-sumif-problem-117
Sheet: Trends by Day

 |  |  | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual
 | Date |  | Daily Budget |  | Travalos |  | Premiers |  | Mailouts |  | Trans |  | Units
 | Store Goals
 | Sunday
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 |  |  | x | x |  |  | x | x | x | x | x | x | x | x
Spreadsheet: 821954d1679009600-single-array-multiple-criteria-single-column-output-dynamic-range-issue
Sheet: Example

Data Column
2023-02-27 18:01:33, Processing FEDCBA (654321)
2023-02-27 18:01:49, Sorting...
2023-02-27 18:02:11, Updating…
2023-02-27 18:03:02, Pass ended
2023-02-27 18:03:47, [NAME] ended, 9 reconciles
2023-02-27 18:03:47, Processing ABCFED (123654)
2023-02-27 18:04:31, Sorting...
2023-02-27 18:05:58, [NAME]… | Start Time | End Time | Time Per Account | Desired Outcome (Dynamic ranges of Column C - Column B )
2023-02-27 18:06:09, Pass ended |  |  |  | 00:02:14
2023-02-27 18:06:15, [NAME] ended, 5 reconciles | 18:03:47 | 18:06:15 | 00:02:14 | 00:02:28
 | 18:06:16 | 18:09:47 |  | 00:03:31
2023-02-27 18:06:16, Processing CBADEF (321456) | 18:09:51 | 18:09:51 |  | 00:00:00
2023-02-27 18:06:47, Sorting... | 18:09:52 | 18:11:05 |  | 00:01:13
2023-02-27 18:08:22, Updating…
2023-02-27 18:09:37, Pass ended
2023-02-27 18:09:47, [NAME] ended, 4 reconciles
2023-02-27 18:09:51, Processing account FBCDEA (623451)
2023-02-27 18:09:51, Warning: Nothing for this account, skipping…
2023-02-27 18:09:52, Processing ACBDFE (132465)
2023-02-27 18:09:59, Sorting...
2023-02-27 18:10:22, [NAME]…
2023-02-27 18:11:01, Pass ended
2023-02-27 18:11:05, [NAME] ended, 4 reconciles
Spreadsheet: 583776d1532635975-index-match-for-sheet-name-in-another-workbook-md_de_dash-forum_help
Sheet: 033300-020

07/24/18
10:47 AM |  |  |  |  |  | 12 Month Actual
 |  |  |  |  |  | Central TFC
033300-020 |  |  |  |  |  | For the Month Ending June 30, 2018
 | July | August | September | October | November | December | January | February | March | April | May | June | Year to Date
Operating Income | 120873 | 113232 | 110840 | 82177 | 92682 | 93201 | 79329 | 76246 | 104427 | 129393 | 109120 | 112113 | 1223633
Personnel Expenses | 42942 | 37599 | 38327 | 40646 | 42925 | 43184 | 44596 | 43721 | 44780 | 40663 | 41364 | 41154 | 501901
Operating Expenses | 54937 | 51900 | 48348 | 47544 | 50626 | 47501 | 40891 | 39279 | 45078 | 59534 | 51347 | 83266 | 620251
Total Direct Expenses | 97879 | 89499 | 86675 | 88190 | 93551 | 90685 | 85487 | 83000 | 89858 | 100197 | 92711 | 124420 | 1122152
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Program Operating Margin | 22994 | 23733 | 24165 | -6013 | -869 | 2516 | -6158 | -6754 | 14569 | 29196 | 16409 | -12307 | 101481
Program Operating % | 0.190232723602459 | 0.209596227214922 | 0.218016961385781 | -0.0731713253100016 | -0.00937614639304288 | 0.0269954185040933 | -0.0776260888199776 | -0.0885816960889752 | 0.13951372729275 | 0.225638172080406 | 0.15037573313783 | -0.109773175278514 | 0.80184053132773
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Overhead Expenses | 12671 | 11113 | 10026 | 11169 | 11372 | 12732 | 10006 | 12663 | 10475 | 10625 | 10391 | 12460 | 135703
Total Expenses | 110550 | 100612 | 96701 | 99359 | 104923 | 103417 | 95493 | 95663 | 100333 | 110822 | 103102 | 136880 | 1257855
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Income Over/Under Expenses | 10323 | 12620 | 14139 | -17182 | -12241 | -10216 | -16164 | -19417 | 4094 | 18571 | 6018 | -24767 | -34222
 | = | = | = | = | = | = | = | = | = | = | = | = | =
6020 Population | 26 | 27 | 24 | 22 | 22 | 22 | 19 | 19 | 23 | 26 | 26 | 0
6040 Units | 58 | 24 | 24 | 14 | 13 | 21 | 20 | 35 | 4 | 102 | 36 | 0
6041 Units | 0 | 13 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0
Spreadsheet: 134231d1325107915-2-ifs-and-a-return-sample-2
Sheet: Sheet1

 | Volts | Amps Low | Amps High | Charger Type | Helper count
 | 6 | 100 | 199 | 380M1-6C | 1
 | 6 | 200 | 299 | 450M1-6C | 2
 | 6 | 300 | 399 | 510M1-6C | 3
 | 6 | 400 | 499 | 600M1-6C | 4
 |  |  |  |  | 5
 | 12 | 100 | 199 | 250M1-12C | 6
 | 12 | 200 | 299 | 380M1-12C | 7
 | 12 | 300 | 399 | 450M1-12C | 8
 | 12 | 400 | 499 | 525M1-12C | 9
 | Battery | Amps | Cells | Charger Type
 | 12-85F-7 | 255 | 12
 | 12-85F-9 | 340 | 12 |  |  | I want a formula that returns this as the value
 | 12-180-15BI | 180 | 12 |  |  | - the amps needs to fall inbetween the low and high amps above & = the number of cells
 | 12-85F-13 | 510 | 12
 | 12-425-40BI | 425 | 12
 | 12-125F-11 | 625 | 12
 | 12-125F-13 | 750 | 12
 | 12-125F-15 | 875 | 12
 | 12-85F-19 | 765 | 12
 | 12-85F-21 | 850 | 12
Spreadsheet: 87850d1287710056-how-to-insert-data-in-a-new-worksheet-based-on-criterias-sample1
Sheet: Expected

SampleA | [NAME] | Name
A1 | B1 | Name1
A1 | B1 | [NAME]
A1 | B1 | Name3
A2 | B1 | Name1
A2 | B1 | [NAME]
A2 | B1 | Name3
A3 | B1 | Name1
A3 | B1 | [NAME]
A3 | B1 | Name3
A4 | B2 | Name4
A4 | B2 | Name4
A5 | B2 | Name5
A5 | B2 | Name5
A6 | B3 | Name6
Spreadsheet: 164063d1340636037-count-number-of-repeat-stays-repeatvisitors
Sheet: Sheet3

CARD NO | LEVEL | RESORT | DEPART DATE | NIGHTS | MONTH | YEAR | Pr Yr Visits |  | Members with [NAME] in year 2010,2011,2012 per Tier
9251 | GOLD | DPS | 2010-09-08 00:00:00 | 14 |  |  |  |  |  | 2010 | 2011 | 2012
7061 | PLATINUM | CGK | 2012-08-01 00:00:00 | 5 |  |  |  |  | Gold
2045 | BLACK | PVG | 2011-08-01 00:00:00 | 2 |  |  |  |  | Platinum
2761 | RED | CGK | 2010-08-02 00:00:00 | 3 |  |  |  |  | Black
7061 | PLATINUM | DPS | 2012-06-01 00:00:00 | 4 |  |  |  |  | Red
7061 | PLATINUM | MNL | 2012-06-01 00:00:00 | 4
9251 | GOLD | DPS | 2011-12-08 00:00:00 | 14 |  |  |  |  | Resort with Most no. of repeat stay per year
9251 | GOLD | DPS | 2012-11-08 00:00:00 | 14 |  |  |  |  |  | Resort | Count
2761 | RED | CGK | 2011-08-02 00:00:00 | 3 |  |  |  |  | 2010
2733 | GOLD | MNL | 2011-08-10 00:00:00 | 3 |  |  |  |  | 2011
 |  |  |  |  |  |  |  |  | 2012
 |  |  |  |  |  |  |  |  | RESORT COUNT of Repeats
 |  |  |  |  |  |  |  |  |  | 2010 | 2011 | 2012
 |  |  |  |  |  |  |  |  | CGK
 |  |  |  |  |  |  |  |  | DPS
 |  |  |  |  |  |  |  |  | MNL
 |  |  |  |  |  |  |  |  | PVG
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -28994 | -28956
2 | -58020 | -57711
3 | -57789 | -57711
4 | -57818 | -57711
5 | -29948 | -29013
6 | -17354 | -18500
7 | -38858 | -38303
8 | -23897 | -23492
9 | -66545 | -67340
10 | -67813 | -67340
11 | -67191 | -67340
12 | -36674 | -36088
13 | -47122 | -47000
14 | -45072 | -45048
15 | -33797 | -32900
16 | -57765 | -57276
17 | -57995 | -57276
18 | -57788 | -57276
19 | -57778 | -57276
20 | -67624 | -78500
21 | -69502 | -65394
22 | -74831 | -79942
23 | -70809 | -71599
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 19592
2002-02-23 00:00:00
CBS Dollars
 |  |  | 186633
Spreadsheet: 746843d1631069672-count-distinct-values-and-return-required-group-categories-count-distinct-values
Sheet: Sheet1

Site | User | Output
Boston | A1 | Medium
Boston | A1 | Medium
Boston | A2 | Medium
Boston | A3 | Medium
Chicago | B1 | Small
Chicago | B1 | Small
Chicago | B1 | Small
Chicago | B1 | Small
Chicago | B2 | Small
LA | C1 | Small
LA | C1 | Small
LA | C2 | Small
Denver | D1 | Large
Denver | D2 | Large
Denver | D3 | Large
Denver | D4 | Large
Denver | D5 | Large
Spreadsheet: 1e427e68-a044-415e-80d9-1fad28dd1441
Sheet: Sheet1

YONEX-SUNRISE KEJURNAS 2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Tunggal Dewasa Putra-TDA
Badminton Tournament Planner - www.tournamentsoftware.com
 | St. | Round 1 | Round 2 | Round 3 | Quarterfinals | Semifinals | Final | Winner
1 | DKI Jakarta | [NAME] [1]
 |  |  | [NAME] [1]
2 |  | Bye 1 | #1:
3 | [NAME] | [NAME] |  | #33:
4 | [NAME] | [NAME] | #2:
5 | [NAME] | Pandu Dewantoro [9/16] |  |  | #49:
6 | DKI Jakarta | Ramdoni | #3:
7 | [NAME] | [NAME] Vimala |  | #34:
8 | Kalimantan Selatan | Taufik Qurahman | #4:
9 | [NAME] | Banda Sigit Pamungkas [5/8] |  |  |  | #57:
 |  |  | Banda Sigit Pamungkas [5/8]
10 |  | Bye 5 | #5:
11 | Papua | [NAME] |  | #35:
12 | Riau | [NAME] | #6:
13 | DKI Jakarta | [NAME] [9/16] |  |  | #50:
14 | [NAME] | [NAME] | #7:
15 | [NAME] | [NAME] |  | #36:
16 | [NAME] | [NAME] | #8:
17 | [NAME] | [NAME] |  |  |  |  | #61:
 |  |  | [NAME]
18 |  | Bye 3 | #9:
19 | [NAME] | [NAME] |  | #37:
20 | [NAME] | Furi Ibnu Handoko | #10:
21 | DKI Jakarta | [NAME] [9/16] |  |  | #51:
22 | Bali | Ryobe | #11:
23 | Kalimantan Selatan | [NAME] |  | #38:
24 | Banten | [NAME] | #12:
25 | [NAME] | [NAME] [5/8] |  |  |  | #58:
 |  |  | [NAME] [5/8]
26 |  | Bye 7 | #13:
27 | Aceh | [NAME] |  | #39:
28 | DKI Jakarta | [NAME] | #14:
29 | DKI Jakarta | Yoga Pratama [9/16] |  |  | #52:
30 | Sulawesi Selatan | [NAME] | #15:
31 | [NAME] | Syahrir |  | #40:
32 | [NAME] | [NAME] | #16:
33 | DKI Jakarta | [NAME] (Dki) |  |  |  |  |  | #63:
34 | [NAME] | Fisher | #17:
35 | Bali | [NAME] |  | #41:
36 | [NAME] | [NAME] P. [9/16] | #18:
37 | [NAME] | Seto Danu Kusuma |  |  | #53:
38 | D.I Yogyakarta | [NAME] | #19:
39 | [NAME] | Bayu Angga Buana |  | #42:
40 | DKI Jakarta | [NAME] [5/8] | #20:
41 | DKI Jakarta | Hermansyah |  |  |  | #59:
42 | [NAME] | [NAME] | #21:
43 | [NAME] | Fadly |  | #43:
44 | Banten | Adriansyah [9/16] | #22:
45 | Aceh | [NAME] |  |  | #54:
46 | [NAME] | Siswanto | #23:
47 |  | Bye 4 |  | #44:
 |  |  | [NAME] [3/4]
48 | [NAME] | [NAME] [3/4] | #24:
49 | Kalimantan Selatan | [NAME] |  |  |  |  | #62:
50 | [NAME] | [NAME] | #25:
51 | Riau | Judi |  | #45:
52 | DKI Jakarta | [NAME] [9/16] | #26:
53 | Banten | [NAME] |  |  | #55:
54 | Bali | [NAME] | #27:
55 |  | Bye 6 |  | #46:
 |  |  | [NAME] [5/8]
56 | [NAME] | [NAME] [5/8] | #28:
57 | [NAME] | [NAME] |  |  |  | #60:
58 | [NAME] | [NAME] | #29:
59 | Papua | Iwan Gautama |  | #47:
60 | DKI Jakarta | [NAME] [9/16] | #30:
61 | DKI Jakarta | Ary Trisnanto |  |  | #56:
62 | Sulawesi Selatan | Rahmat | #31:
63 |  | Bye 2 |  | #48:
 |  |  | Sony Dwi Kuncoro [2]
64 | [NAME] | Sony Dwi Kuncoro [2] | #32:
Spreadsheet: 145544d1331645858-how-to-find-minimum-can-produce-productaaa
Sheet: How Much Can Do

 | Product AAA
Requirement | 10000
 | How Many Per | Item Requirement |  | Current Inventory
Item 1 | 1 |  |  | 11000
Item 2 | 5 |  |  | 45000
Item 3 | 6 |  |  | 57000
Item 4 | 9 |  |  | 72000
Item 5 | 10 |  |  | 150000
Item 6 | 11 |  |  | 90000
Item 7 | 7 |  |  | 65000
Item 8 | 0 |  |  | 28000
Item 9 | 1 |  |  | 99000
Item 10 | 2 |  |  | 17100
 |  | Bare Minimum Qty Can do