tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 268043d1380381893-dropdown-list-within-dropdown-list-cascading-dropdown-lookups-database-1-
Sheet: Database

Industry: | Firm Name: | Notes | Industry |  | Street | City | Postal Code
InteriorDesign | THE ANGEL GROUP |  | InteriorDesign |  | abc
 |  |  | Architecture |  | 29 Floral Parkway | Toronto
 |  |  |  |  | 4116 Bathurst St. | Toronto
 |  |  |  |  | 30 [NAME] | Vaughn
 |  |  |  |  | 468 Queen St. BOX 12 Suite 212 | Toronto | M5A 1T7
 |  |  |  |  | 20 Queen St. W. 5th Floor | Toronto | M5H 3R4
 |  |  |  |  | 250 Davisville Ave. Suite 401 | Toronto | M4S 1H2
 |  |  |  |  | 717 Bay St. | Toronto
 |  |  |  |  | 45 St. Clair W. Unit 1202 | Toronto
 |  |  |  |  | 208 Adelaide St. W. Unit 300 | Toronto
 |  |  |  |  | abc
 |  |  |  |  | 56 Esplanade Suite 301 | Toronto
 |  |  |  |  | 55 University Avenue, Suite 1601, PO Box 66 | Toronto
 |  |  |  |  | abc
 |  |  |  |  | 229 Yonge St. Suite 500 | Toronto
Spreadsheet: 34579d1231887361-grouping-patients-by-age-in-a-pivot-table-the-way-i-want-age-grouping
Sheet: Sheet1

age | ageGroup
14 | ped
22 | adult
80 | ger
60 | adult |  |  | Count of Age
50 | adult |  |  | ageGroup | Total
33 | adult |  |  | adult | 7
21 | adult |  |  | ger | 5
8 | ped |  |  | ped | 4
12 | ped |  |  | Grand Total | 16
9 | ped
52 | adult
53 | adult
66 | ger
75 | ger
72 | ger
70 | ger
Spreadsheet: 072799b0-6577-4f00-bb02-d40825262259
Sheet: CAT-Home

[NAME] | CAT-Home
Catastrophe Model Information
Catastrophe model(s) and version number(s) used
Model approval date set by the Florida Commission on Hurricane Loss Projection Methodology
Model expiration date set by the Florida Commission on Hurricane Loss Projection Methodology
Confirm long term model version used
Confirm storm surge was not included
Confirm warm water version was not used
Provide impact of demand surge on modeled results
Indicate/Explain any adjustments made to the model output
Current catastrophe load %
Previous catastrophe load %
Provide basis for calculation
Explain difference in % amounts
Name, title, and contact information of individual who was relied upon and is responsible for the catastrophe model(s) used
Insurer Notes:
Notes:
1.  Short term hurricane model not allowed
2.  Storm surge not allowed to be included unless flood coverage is provided
3.  Warm water models are not accepted
4.  Demand surge = loss amplification
5.  Model version used must be one of the two versions most recently approved for use by the Florida Commission on Hurricane Loss Projection Methodology
6.  If multiple models used, then their respective results must be equally weighted
Spreadsheet: 85170d1285225318-idenitfying-and-copying-rows-from-one-sheet-to-another-template-example
Sheet: DATA - Input

Student | Target | Grade | Class | Gender | SEN
[NAME] | A | B | 7a/En1 | M | N
[NAME] | D | C | 7a/En2 | M | S
[NAME] | F | D | 7a/En2 | M | S
[NAME] | E | A | 7a/En1 | F | P
Lance | C | E | 7a/En1 | M | N
[NAME] | D | A | 7a/En2 | M | S
Spreadsheet: 718932d1613415775-inserting-additional-criteria-to-an-if-statement-worktimecalcefupdated-1-
Sheet: Criteria 3

STRT | END | WRK | RT | ST | OT |  | Overall Day
 |  |  |  |  |  |  | Report | 05:40:00
 |  |  |  |  |  | Incorrect | Start Shift
 |  |  |  | 7.25 |  | Correct | End Shift | 10:07:00
 |  |  |  |  |  |  | 1st Half Pay
 |  |  |  |  |  |  |  | Break
 |  |  |  |  |  |  | Report | 14:20:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | 11th Hour
 |  |  |  |  |  |  | End Shift | 18:50:00
 |  |  |  |  |  |  | Straight Time
 |  |  |  |  |  |  | Overtime
Spreadsheet: 808324d1670416642-the-average-of-a-second-row-gemiddelde-waarden-rl-nederlandse-zomer
Sheet: Aug 22

Augustus | 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
[NAME]  °C | 24.9 | 25 | 28.1 | 25.7 | 22.3 | 21.8 | 22.7 | 23.8 | 24.5 | 29.2 | 30.7 | 31.1 | 32.2 | 30.8 | 28.8 | 27.6 | 21.1 | 26 | 23 | 21.8 | 22.9 | 26.4 | 25 | 29.1 | 27.8 | 22.2 | 22.9 | 22.6 | 22.1 | 23.8 | 23.7
Laagste RL [%] | 44 | 55 | 49 | 49 | 25.1 | 38 | 40 | 46 | 48 | 35 | 27 | 26 | 19 | 24 | 46 | 43 | 80 | 53 | 73 | 93 | 52 | 47 | 58 | 49 | 50 | 55 | 46 | 48 | 45 | 44 | 45
[NAME] RL[% ]
Aantal nuttige dagen | 12
Spreadsheet: 11f843cf-ba4f-461b-b575-2b1d2926e468
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
 | 5625.0 Private New Capital Expenditure and Expected Expenditure, Australia
 | TABLE 6A. Actual and Expected Capital Expenditure by Asset - New South Wales:Current Prices $m
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Actual Expenditure ;  New South Wales ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3517402F | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  New South Wales ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3517444C | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  New South Wales ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3517486A | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  New South Wales ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3517404K | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  New South Wales ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3517446J | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  New South Wales ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3517488F | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  New South Wales ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3517403J | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  New South Wales ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | [NAME] | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  New South Wales ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3517487C | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: a3d5dbcd-f54f-45bc-b31e-b030e97ebae9
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
TROMSØ TRANSPORT DA |  | 9020 | Tromsdalen
RIMELIG TRANSPORT |  | 8520 | Ankenes
CARLSSONS TRANSPORT LJUNGAVERK AB |  | 8514 | Narvik
DYDAK TRANSPORT KAZIMLERZ DYDAK |  | 8514 | Narvik
[NAME] TRANSPORT |  | 8516 | Narvik
LM [NAME] |  | 8150 | Ørnes
TT TRANSPORT OG TJENESTER UNGDOMSBEDRIFT |  | 9300 | Finnsnes
T. PAULSEN TRANSPORT AS |  | 9515 | Alta
T-COM Trond Sæthre |  | 8076 | Bodø
ANDTRADE LTD |  | 9105 | Kvaløya
BERG-HANSEN TRANSPORT |  | 9140 | Rebbenes
NORTH TRANSPORT [NAME] |  | 9103 | Kvaløya
RINGVASSØY TRANSPORT ANS |  | 9130 | Hansnes
ALTA BUD OG TRANSPORT DA |  | 9513 | Alta
STÅLE HOLDAHL MASKIN & TRANSPORT DA |  | 8372 | Gravdal
BÅRD ENGAN TRANSPORT |  | 8250 | [NAME]
SNØGG TRANSPORT |  | 8006 | Bodø
BMS TRANSPORT |  | 8010 | Bodø
EH TRANSPORT LTD KONKURSBO |  | 8656 | Mosjøen
ELVENES TRANSPORT & MASKIN AS |  | 8540 | Ballangen
KURT SOLSTAD TRANSPORT |  | 9040 | Nordkjosbotn
NORDTØMME TRANSPORT AS |  | 9610 | Rypefjord
N/M TRANSPORT OG MASKIN BA |  | 7980 | Terråk
ARNSTEIN JESSEN TRANSPORT |  | 9845 | Tana
[NAME] |  | 9020 | Tromsdalen
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 18

Product* | February 14 | February 21 | February 28 | March 7 | March 14
Total**
Non-Deliverable Forwards | N/A | N/A | N/A | N/A | N/A
Options | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaps | N/A | N/A | N/A | N/A | N/A
OTHER | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, March 14 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***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: 680566d1591091949-sumifs-2-criteria-in-different-sheets-to-be-calculated
Sheet: Sheet3

 |  | Week no. | Start of week date | End of week date | No. of shop drawings |  | [NAME] |  | STRUC |  | CIV |  | MEP
 |  | Week 1 | 2020-04-18 00:00:00 | 2020-04-24 00:00:00 | 4
 |  | Week 2 | 2020-04-25 00:00:00 | 2020-05-01 00:00:00 | 8
 |  | Week 3 | 2020-05-02 00:00:00 | 2020-05-08 00:00:00 | 21
 |  | Week 4 | 2020-05-09 00:00:00 | 2020-05-15 00:00:00 | 88
 |  | Week 5 | 2020-05-16 00:00:00 | 2020-05-22 00:00:00 | 229
 |  | Week 6 | 2020-05-23 00:00:00 | 2020-05-29 00:00:00 | 172
 |  | Week 7 | 2020-05-30 00:00:00 | 2020-06-05 00:00:00 | 216
 |  | Week 8 | 2020-06-06 00:00:00 | 2020-06-12 00:00:00 | 322
 |  | Week 9 | 2020-06-13 00:00:00 | 2020-06-19 00:00:00 | 166
 |  | Week 10 | 2020-06-20 00:00:00 | 2020-06-26 00:00:00 | 167
 |  | Week 11 | 2020-06-27 00:00:00 | 2020-07-03 00:00:00 | 304
 |  | Week 12 | 2020-07-04 00:00:00 | 2020-07-10 00:00:00 | 112
 |  | Week 13 | 2020-07-11 00:00:00 | 2020-07-17 00:00:00 | 129
 |  | Week 14 | 2020-07-18 00:00:00 | 2020-07-24 00:00:00 | 44
 |  | Week 15 | 2020-07-25 00:00:00 | 2020-07-31 00:00:00 | 48
 |  | Week 16 | 2020-08-01 00:00:00 | 2020-08-07 00:00:00 | 49
 |  | Week 17 | 2020-08-08 00:00:00 | 2020-08-14 00:00:00 | 80
 |  | Week 18 | 2020-08-15 00:00:00 | 2020-08-21 00:00:00 | 74
 |  | Week 19 | 2020-08-22 00:00:00 | 2020-08-28 00:00:00 | 51
 |  | Week 20 | 2020-08-29 00:00:00 | 2020-09-04 00:00:00 | 9
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Emergency Benefits

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Intake
Activity Name | Emergency Benefits
Activity Description / Purpose | If the interview indicates that benefits must be issued immediately to mitigate the situation there are expedited procedures and simplified eligibility requirements for emergency benefits.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Case Closure |  |  | Accounting
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Screen for expedited criteria
Route application to accounting unit for clearance/app registration (expedited)
Call customer on telephone if mailed application and expedited
Interview customer in person if walk in application
Determine benefit should be issued immediately based on eligibility
Make a recommendation based on knowledge of program requirements without entering the information into WMS
Enter the data into WMS after the emergency is mitigated
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: dutch_quigley__9412__NymexPos
Sheet: Heat Futures

HEATING OIL FUTURES
2001-12-01 00:00:00 | -935
2002-01-01 00:00:00 | -1279
2002-02-01 00:00:00 | 360
2002-03-01 00:00:00 | 603
2002-04-01 00:00:00 | 549
2002-05-01 00:00:00 | -83
2002-06-01 00:00:00 | -117
2002-07-01 00:00:00 | -72
2002-08-01 00:00:00 | 106
2002-09-01 00:00:00 | 103
2002-10-01 00:00:00 | 273
2002-11-01 00:00:00 | -22
2002-12-01 00:00:00 | -40
2003-01-01 00:00:00 | -182
2003-02-01 00:00:00 | 50
Spreadsheet: 755771d1637083241-report-based-on-same-fico-number-multiple-times-excel-demo
Sheet: Sheet1

 | Quote ID | Lender Type | LTV | Coverage | FICO | Borrowers | DTI | Loan Purpose | Loan Type | Term (years) | Property Type | Occupancy | Loan Amount
 | AZ_0001 | MB | 97 | 35 | 800 | 1 | 36 | Purchase | Fixed | 30 | SFD | Primary | 250000
 | AZ_0002 | MB | 97 | 35 | 720 | 1 | 36 | Purchase | Fixed | 30 | SFD | Primary | 250000
 | AZ_0003 | MB | 95 | 30 | 800 | 1 | 36 | Purchase | Fixed | 30 | SFD | Primary | 250000
 | AZ_0004 | MB | 95 | 30 | 760 | 1 | 36 | Purchase | Fixed | 30 | SFD | Primary | 250000
 | AZ_0005 | MB | 95 | 30 | 700 | 1 | 36 | Purchase | Fixed | 30 | SFD | Primary | 250000
 | Quote ID | Lender Type | LTV | Coverage | FICO | Borrowers | DTI | Loan Purpose | Loan Type | Term (years) | Property Type | Occupancy | Loan Amount
 |  | MB | 97 | 35 | 800 | 1 | 36 | Purchase | Fixed | 30 | SFD | Primary | 250000
 | AZ_0003 | MB | 95 | 30 | 800 | 1 | 36 | Purchase | Fixed | 30 | SFD | Primary | 250000
Spreadsheet: 61858d1262774383-water-tank-level-formula-last-5-days-water-tank-level-5-
Sheet: Graph

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Upper Water Level | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 52.08333333333334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 41.66666666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 62.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 57.29166666666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Lower Water Level | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 83.33333333333334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 77.08333333333334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 73.95833333333334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 70.83333333333334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 97.91666666666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Capacity | 192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 67.70833333333334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 59.375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 68.22916666666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 64.0625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | 73.95833333333334
Spreadsheet: 823405d1679946552-iterating-through-a-column-and-counting-criteria-that-is-met-if-that-row-meets-a-condition-test
Sheet: Sheet1

 |  |  |  | Month | Apples | Bananas | Pears | Grapes
 |  |  | [NAME] | February | Bag | Box | Box | Cart |  |  |  |  |  |  |  | January | Bag
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | February | Cart
 |  |  | [NAME] | January | Cart | Cart | Tray | Box |  |  |  |  |  |  |  | March | Box
 |  |  | [NAME] | January | Bag | Box | Bag | Bag |  |  |  |  |  |  |  | April | Tray
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  | [NAME] | May | Tray | Bag | Cart | Box
 |  |  | Month | January | February | March | April | May
 |  |  | Bag | 3 | 1 | 0 | 0 | 1
 |  |  | Cart | 2 | 1 | 0 | 0 | 1
 |  |  | Box | 2 | 2 | 0 | 0 | 1
 |  |  | Tray | 1 | 0 | 0 | 0 | 1
 |  |  |  | Equations to be put in F26:F29
Spreadsheet: 474627d1470837898-update-quantity-in-a-cell-after-recording-a-sale-sales
Sheet: Stock

 |  |  |  |  |  | 542.2
No | Supplier | Item No | Desc | Pprice | Qty | Total Price | Purchased Date
1 | Supplier 2 | DNO 3 | Long Rani Haar | 10.25 | 2 | 20.5 | 2016-08-05 00:00:00
2 | Supplier 2 | N3 | Earring Tikka | 3.25 | 3 | 9.75 | 2016-08-05 00:00:00
3 | Supplier 2 | 212 LCT | Necklace set | 5.5 | 4 | 22
4 | Supplier 2 | 212 WHT | Necklace set | 5.5 | 4 | 22
5 | Supplier 2 | 214 WHT | Necklace set | 5.5 | 1 | 5.5
6 | Supplier 2 | 214 LCT | Necklace set | 5.5 | 3 | 16.5
7 | Supplier 2 | 215 LCT | Necklace set | 5.25 | 1 | 5.25
8 | Supplier 2 | 216 | Necklace set | 5.75 | 3 | 17.25
9 | Supplier 2 | 1187 | Necklace set | 3.25 | 3 | 9.75
10 | Supplier 2 | N25 | Earring Tikka | 2.9 | 3 | 8.7
11 | Supplier 2 | Tulip WHT | Toursers | 9 | 15 | 135
12 | Supplier 2 | Tulip BLK | Toursers | 9 | 5 | 45
13 | Supplier 2 | Tulip BLU | Toursers | 9 | 10 | 90
14 | Supplier 2 | Tulip CRM | Toursers | 9 | 15 | 135
15 |  |  |  |  |  | 0
16 |  |  |  |  |  | 0
17 |  |  |  |  |  | 0
18 |  |  |  |  |  | 0
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
Spreadsheet: a672416f-c6db-42a9-930b-38b91476a04c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
DAFTAR PESERTA PLPG RAYON 112 UNIVERSITAS NEGERI SEMARANG
TAHAP VII  GUGUS BADAN DIKLAT PROV. [NAME]. SUMBING
[NAME] Tanggal 14 - 23  Agustus  2011
Kelas : | Kelautan
No | No Peserta | Nama | Sekolah | Kab./Kota
1 | 11036551130028 | SUHARYANTO | [NAME] | KOTA TEGAL
2 | 11036551130040 | ACHMAD CHUDORI | SMK SUPM [NAME] Tegal | KOTA TEGAL
3 | 11036551130047 | MASKURI | SMK SUPM [NAME] Tegal | KOTA TEGAL
4 | 11131251130054 | AYAT TUNGGAL | SUPM NEGERI PONTIANAK | KAB. KUBU RAYA
5 | 11131251130056 | JUNAIDI | SUPM NEGERI PONTIANAK | KAB. KUBU RAYA
6 | 11036551230045 | HENRY ISKANDAR MADYANTORO | SMK SUPM [NAME] Tegal | KOTA TEGAL
7 | 11131251230051 | IMANSYAH | SUPM NEGERI PONTIANAK | KAB. KUBU RAYA
8 | 11131251230057 | DWI BAMBANG HARIANTO | SUPM NEGERI PONTIANAK | KAB. KUBU RAYA
9 | 11131251230066 | SUMARDI | SUPM NEGERI PONTIANAK | KAB. KUBU RAYA
10 | 11131251230067 | RUSLAN | SUPM NEGERI PONTIANAK | KAB. KUBU RAYA
11 | 11131251230068 | M.AMIN | SUPM NEGERI PONTIANAK | KAB. KUBU RAYA
12 | 11030250911745 | [NAME] | SMK Nasional Purwokerto | Kab. Banyumas
13 | 11030151111340 | [NAME] | SMK (STM) N 2 CILACAP | Kab. Cilacap
Spreadsheet: 24987024-25b8-4742-b2ea-ba128528567c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4341 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00 | Elite Men
4340 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00 | Elite Women
Spreadsheet: 708351d1607750033-clustered-if-else-combination-sample
Sheet: Sheet1

A | B | C
19 | 19 | 1
20 | 20 | 1
21 | 19 | 2
22 | 18 | 2
23 | 17 | 2
24 | 16 | 2
25 | 15 | 2
19 | 21 | 2
18 | 22 | 2
17 | 23 | 2
16 | 24 | 2
15 | 25 | 2
31 | 19 | 3
32 | 18 | 3
33 | 17 | 3
34 | 16 | 3
35 | 15 | 3
19 | 31 | 3
18 | 32 | 3
17 | 33 | 3
16 | 34 | 3
15 | 35 | 3
26 | 21 | 4
27 | 22 | 4
28 | 23 | 4
29 | 24 | 4
30 | 25 | 4
21 | 26 | 4
22 | 27 | 4
23 | 28 | 4
24 | 29 | 4
25 | 30 | 4
26 | 26 | 5
27 | 27 | 5
28 | 28 | 5
29 | 29 | 5
30 | 30 | 5
31 | 26 | 6
32 | 27 | 6
33 | 28 | 6
34 | 29 | 6
35 | 30 | 6
26 | 31 | 6
27 | 32 | 6
28 | 33 | 6
29 | 34 | 6
30 | 35 | 6
31 | 31 | 7
32 | 32 | 7
33 | 33 | 7
34 | 34 | 7
35 | 35 | 7