tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 706304d1606605581-need-help-please-in-distributing-a-number-across-a-date-in-multiple-cells-match-value-by-date-therese0711-
Sheet: Sheet1

DATE
2020-09-01 | 587 |  |  |  | Qty
2020-09-01 |  |  |  | 2020-09-01 | 587
2020-09-01 |  |  |  | 2020-09-02 | 869
2020-09-01 |  |  |  | 2020-09-03 | 741
2020-09-01 |  |  |  | 2020-09-04 | 536
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-02 | 869
2020-09-02
2020-09-02
2020-09-02
2020-09-02
2020-09-02
2020-09-02
2020-09-02
2020-09-02
2020-09-03 | 741
2020-09-03
2020-09-03
2020-09-03
2020-09-03
2020-09-03
2020-09-04 | 536
2020-09-04
2020-09-04
2020-09-04
2020-09-04
2020-09-04
Spreadsheet: 764759d1642962517-how-to-auto-select-2-names-based-on-multiple-criteria-sample-2
Sheet: Pegaxy

 | P. | Gender | B. # |  |  | P. | B. # | Cost
 | [NAME] | F | 0
 | MJ | M | 2
 | Loki | M | 1 |  |  |  | Total VIS Cost
 | sdf sdf | M | 1
 | fa | M | 2 |  |  | 0 | 2000
 | sdfsd f | F | 2 |  |  | 1 | 4000
 | sdfsdf | F | 2 |  |  | 2 | 6000
 | fef | F | 3 |  |  | 3 | 10000
 | edfdasf | M | 3 |  |  | 4 | 16000
 | ads | M | 4 |  |  | 5 | 26000
 | gjh | F | 5 |  |  | 6 | 42000
 | [NAME] | F | 6 |  |  | 7
 | rew | M | 2
 | west | F | 0
Spreadsheet: 142295d1329767264-sumif-begins-with-help-copy-of-sumif-test
Sheet: Sheet1

 |  | 5090-00 | Absorbed Labor | -253284.8
 |  | 5090-10 | Absorbed Labor: Shop | 0
 |  | 5090-20 | Absorbed Labor: D&E | -18253
 |  | 5090-94 | Absorbed Labor - Unbillable | -62500
 |  | 5090-95 | Absorbed Labor: Subcontract | 0
 |  | 5100-10 | Holiday wages: Shop | 0
 |  | 5100-20 | Holiday wages: D&E | 0
Spreadsheet: 146613d1332270612-using-sum-with-un-adjacent-cells-and-then-filling-a-table-survey
Sheet: Sheet2

 | Main Library | Agat | Barrigada | Dededo | Merizo | Yuna | Bookmobile
Collection (Books, Magazines, Audios, DVDs, CDs, etc.)
Customer Service
Hours of Operation
Computer Workstation
On-line catalog (Horizon)
[NAME] (On-island)
National Library Service for the [NAME], etc. (NHL)
Young Adults
Saturday Story Hour
[NAME]
Computer Workshop (Elderly/Student)
[NAME]
4.  When you visit the library what did you think of the change in appearance with new furniture?
5.  How would you rate our existing facilities (buildings)?
6.  How satisfied are you with the time in retrieving a Reference request.
Spreadsheet: 377096d1423789830-find-value-that-doesnt-match-and-bring-back-column-heading-150213-data-file
Sheet: Sheet1

Year 1 values |  | Year 2 Values |  | Values in Year 2 Not in Year 1 | Compacted List
Spreadsheet: 862477d1710195762-exclude-holidays-in-total-holiday-sample
Sheet: Mar

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 2024-03-01 00:00:00 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 209088d1359017231-filter-data-by-key-in-criteria-keyinfilterdata-1-
Sheet: Sheet2

 | Sales group | Sales district | Sales office |  | Customer A | [NAME]
 | ZAC | ZAD | ZAA |  | 100989 | 1994-08-04 00:00:00
 |  |  |  |  | 104347 | 2007-10-02 00:00:00
Spreadsheet: 01d39b4c-7dc6-463a-bea9-843fc963d6d6
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 44. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (QLD), 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 | A2413781A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413782C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413783F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413784J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413785K | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413786L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413787R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413788T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413789V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413790C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413791F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 886310d1736342558-formula-to-extract-data-from-range-filter
Sheet: Data

ONE | TWO | HAPPY | THREE | FOUR | FIVE | CHRISTMAS | SIX | AND | NEW | YEAR | SEVEN | EIGHT | NINE
Plumb | Vortex | Galaxy | [NAME] | Crumble | Drift | Zenith | Sprint | Echo | Lantern | Quiver | Stone | NO | Crumble
Tangle | Bloom | Ripple | Spark | Tumble | Glimpse | Haze | Starlight | Burst | Whisper | [NAME] | Flicker | YES | Tumble
Feather | Mirage | Quill | Pulse | Blaze | Thistle | Driftwood | Emberfall | [NAME] | Halo | Grit | Flare | YES | Blaze
Sway | Vortex | Blush | Linger | Prism | Forge | Bloom | Fable | Dash | [NAME] | Flinch | Mirage | YES | Prism
[NAME] | Shard | Rush | Lumen | Twilight | Prism | Snap | Trickle | [NAME] | Flock | Tumble | Wander | NO | Twilight
[NAME] | Tangle | [NAME] | Echo | Whirl | Driftwood | Flicker | Fathom | Shade | Glint | Swirl | Trance | NO | Whirl
Fable | Drift | Spark | Flash | Mirage | Gloom | Phantom | Dune | Clasp | Shift | [NAME] | Dash | YES | Mirage
Trickle | Lantern | Haze | Plume | Blaze | Quiver | Flicker | Glimmer | Whisper | Halo | Driftwood | Spiral | NO | Blaze
[NAME] | Prism | Blink | Blaze | [NAME] | [NAME] | Fable | Shimmer | Rush | Vortex | Tumble | Spark | NO | [NAME]
Dune | [NAME] | Flicker | Spark | Radiant | Whisper | Fable | Quiver | Drift | Shadow | Glimmer | Tangle | YES | Radiant
Linger | Prism | Sway | Blink | Echo | Pulse | Blaze | Whisper | Flutter | [NAME] | Vortex | Halo | NO | Echo
[NAME] | Haze | Shard | [NAME] | Flock | Tumble | Drift | Quiver | Phantom | Flash | Whisper | Shimmer | YES | Flock
Blink | Linger | Blaze | Fable | [NAME] | Trickle | Vortex | Emberfall | Dash | Quiver | Phantom | Echo | YES | [NAME]
Glimmer | Plume | Rush | Fable | Halo | Sway | Flicker | Tumble | Drift | Shimmer | Prism | Shade | YES | Halo
Mirage | Echo | Glimpse | Shadow | Fathom | Shard | Blaze | Tangle | Prism | Dash | [NAME] | Flicker | NO | Fathom
Sway | Flock | Fable | Haze | Tumble | [NAME] | Phantom | Glimmer | Ripple | Halo | Swirl | Blink | NO | Tumble
Spreadsheet: 267986d1380332780-dropdown-list-within-dropdown-list-database
Sheet: Sheet1

Industry: |  |  | Industry | Company - Interior Design | Company - Architecture | website | Address
Architecture |  |  | InteriorDesign | THE ANGEL GROUP | CAMROST FELCORP. | www.angel-developments.com
Firm Name: |  |  | Architecture | ASPEN RIDGE HOMES | CANDEREL STONERIDGE EQUITY GROUP | www.aspenridgehomes.com | 29 Floral Parkway, Toronto, ON
THE ANGEL GROUP |  |  |  | ALIT DEVELOPMENTS | CD CAPITAL DEVELOPMENT | www.alit.ca | 4116 Bathurst St. | Toronto
 |  |  |  | BAZIS INC DEVELOPMENTS | CENTRECOURT DEVELOPMENTS | www.bazis.ca | 30 [NAME] | Vaughn
 |  |  |  | BLUESCAPE CONSTRUCTION MANAGEMENT INC. | CITYSCAPE DEVELOPMENT CORP. | http://www.bluescape.ca/ | 468 Queen St. BOX 12 Suite 212 | Toronto | M5A 1T7
 |  |  |  | CADILLAC FAIRVIEW CORP. LTD | CITYZEN DEVELOPMENT GROUP | www.cadillacfairview.com | 20 Queen St. W. 5th Floor | Toronto | M5H 3R4
 |  |  |  |  | CONCERT PROPERTIES | http://camrost.com/ | 250 Davisville Ave. Suite 401 | Toronto | M4S 1H2
 |  |  |  |  | CONCORD | http://canderelresidential.com/ | 717 Bay St. | Toronto
 |  |  |  |  | CONTEXT | www.cdcp.com | 45 St. Clair W. Unit 1202 | Toronto
 |  |  |  |  |  | http://www.centrecourtdevelopments.com/ | 208 Adelaide St. W. Unit 300 | Toronto
 |  |  |  |  |  | http://cityzen.typepad.com/ | 56 Esplanade Suite 301 | Toronto
 |  |  |  |  |  | www.concertproperties.com | 55 University Avenue, Suite 1601, PO Box 66 | Toronto
 |  |  |  |  |  | www.context.ca | 229 Yonge St. Suite 500 | Toronto
Spreadsheet: 851367d1701590566-filter-function-with-dynamically-changing-data-column-based-on-value-in-another-field-filter-calling-dynamic-data-column-aligw
Sheet: Access Lists

Name | Nationality | DOB | Event
 | Costa Rica | 1967-06-03 00:00:00 | 1 |  |  | [NAME] FILTER
[NAME] | India | 1988-07-21 00:00:00 | 1 |  |  | Nationality | All
[NAME] | Mexico | 1957-01-19 00:00:00 | 1 |  |  | Event | Event 1
[NAME] | New Zealand | 1959-08-10 00:00:00 | 1 |  |  | Count
[NAME] | Germany | 1987-12-22 00:00:00 | 1
[NAME] | Philippines | 1998-08-10 00:00:00 | 1
Ira Case | Russian Federation | 1949-12-18 00:00:00 | 1
Remedios Adkins | India | 1933-01-07 00:00:00 | 1
Gregory Daniel | China | 1972-09-03 00:00:00 | 1
[NAME] | France | 2012-03-17 00:00:00 | 1
[NAME] | Nigeria | 1952-05-08 00:00:00 | 1
Cooper Long | Netherlands | 1966-05-13 00:00:00 | 1
[NAME] | Austria | 2015-06-14 00:00:00 | 1
[NAME] | Russian Federation | 2014-09-15 00:00:00 | 1
[NAME] | Indonesia | 1933-03-17 00:00:00 | 1
[NAME] | Vietnam | 1949-06-01 00:00:00 | 1
[NAME] | South Africa | 1979-04-06 00:00:00 | 1
[NAME] | Turkey | 1957-12-23 00:00:00 | 1
[NAME] | Mexico | 1960-01-06 00:00:00 | 1
Josiah Estes | Colombia | 1968-03-19 00:00:00 | 1
[NAME] | Philippines | 1976-02-07 00:00:00 | 1
[NAME] | India | 2005-09-16 00:00:00 | 1
[NAME] | Austria | 1996-03-17 00:00:00 | 1
[NAME] | Netherlands | 2001-02-21 00:00:00 | 1
Azalia [NAME] | Australia | 1942-05-23 00:00:00 | 1
Maya Lester | South Korea | 1977-11-03 00:00:00 | 1
[NAME] | Pakistan | 1927-12-12 00:00:00 | 1
Cyrus Roth | Austria | 1977-02-21 00:00:00 | 1
[NAME] | United States | 1950-07-14 00:00:00 | 1
[NAME] | Mexico | 1960-08-08 00:00:00 | 1
[NAME] | United Kingdom | 1982-02-08 00:00:00 | 1
Spreadsheet: 287561d1388862499-retrieving-list-of-data-from-a-table-test-table_alkey
Sheet: Calculator

ITEM Entries | Multiply by(Entry) | Ingrd 1 | [NAME] | Ingrd 3 | [NAME] | Ingrd 5 | Ingrd 6 | Ingrd 7
 | ex; 2x,4x, 5x
ITEM 1 | 2
ITEM 2
ITEM 10
Sum
Spreadsheet: darrell_schoolcraft__7810__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 1st = 65000
 |  |  | SoCal Gas Price |  | 2.885
 |  |  | San Juan Gas Price |  | 2.315
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 378 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 378 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 378 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 378 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 378 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 378 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 378 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 378 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 378 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 378 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 378 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 378 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 378 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 378 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 378 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 378 | 7
he22 | 00:00:00 |  | 0 | 0 | 0 | 378 | 7
he23 | 01:00:00 |  | 0 | 0 | 0 | 378 | 7
he24 | 02:00:00 |  | 0 | 0 | 0 | 470 | 7
he1 | 03:00:00 |  | 0 | 0 | 0 | 470 | 7
he2 | 04:00:00 |  | 0 | 0 | 0 | 470 | 7
he3 | 05:00:00 |  | 0 | 0 | 0 | 470 | 7
he4 | 06:00:00 |  | 0 | 0 | 0 | 470 | 7
[NAME] | 07:00:00 |  | 0 | 0 | 0 | 470 | 7
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 13a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 956320 | 956320
Europe | - | 453361 | 453361
North America/Asia | - | 502959 | 502959
Other | - | - | -
Index | 2004390 | 5254051 | 7258441
Asia | - | 106539 | 106539
Europe | 880080 | 2371189 | 3251269
North America | 1113110 | 2543809 | 3656919
Other | 11200 | 232514 | 243714
Other | - | 485512 | 485512
Exotic | - | 47540 | 47540
Swaptions | - | 437890 | 437890
Total Return Swap | - | 82 | 82
TOTAL | 2004390 | 6695883 | 8700273
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 700566 | 724155
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 629577 | 502309 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 774016 | 824278
500293 | 317511 | 428963
500302 |  | 8361
500303 | 146291 | 230232
500305 | 663601 | 946683
500307 | 96756 | 111616
500313 | 2540 | 2191
500314
500655 | 489140
500657 | 114292 | 126000
INDEX
2001-06-30 00:00:00 |  |  | 26156.73
2001-07-21 00:00:00
Spreadsheet: 846515d1697692539-vertical-multiple-dependent-drop-down-list-2nd-layer-inquiry-event-itinerary-master_sample
Sheet: MASTER Template

 |  | START Time : | 17:00:00 |  | Production 制作 |  |  |  |  | Operation オペレーション
 |  | END Time : | 19:00:00
[CLIENT NAME] [EVENT NAME] |  | OVERALL Event Schedule | [Client] |  | Construction 施工 | Sound 音響 | Lighting 照明 | Moving Company 引越し/運搬 | Audio Visual (AV) 映像 | Staffing 運営 | Catering ケータリング | Model モデル | DJ | Performance パフォーマンス
Event Itinerary |  |  |  |  | Con. Vendor A | Sound Vendor B | Light 01 | moving 01 | AV 01 | Staffing Vendor A | Catering Vendor A | Model Vendor 1 | DJ A | perf 01
 | 08:00:00
Spreadsheet: 751521d1634150371-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test
Sheet: TA 

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Notes | PRODUCT | ABPAC | BAKO | Catering 24 | Cheapest | From | Saving | x50 bought
10" Greaseproof bag | ABPAC | 16.82 | 1000 |  |  |  |  | 10" Greaseproof bag |  |  |  |  |  |  |  |  |  | 12oz compostable d/w cup |  |  |  |  | BAKO
10" Greaseproof bag | BAKO | 8.12 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12oz compostable lid |  |  |  |  | Bonds Packaging
10" Greaseproof bag | Catering 24 | 19.02 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7" Greaseproof bag |  |  |  |  | Catering 24
12oz compostable d/w cup | Catering 24 | 45.54 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8oz compostable d/w cup |  |  |  |  | Enviropack
12oz compostable d/w cup | Next Day Coffee | 43.19 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8oz compostable lid |  |  |  |  | Enviropack 4+
12oz compostable d/w cup | [NAME] | 53.1 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nesting Tray |  |  |  |  | Enviropack 5+
12oz compostable lid | Catering 24 | 53.99 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. 1 [NAME] |  |  |  |  | Next Day Coffee
12oz compostable lid | Next Day Coffee | 29.75 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. 3 [NAME] |  |  |  |  | [NAME]
12oz compostable lid | [NAME] | 54.84 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perforated Film Front [NAME] bag
7" Greaseproof bag | ABPAC | 10.28 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOS Carrier Bag
7" Greaseproof bag | BAKO | 6.88 | 1000
7" Greaseproof bag | Catering 24 | 9.77 | 1000
8oz compostable d/w cup | Catering 24 | 38.34 | 500
8oz compostable d/w cup | Next Day Coffee | 38.39 | 500
8oz compostable d/w cup | [NAME] | 43.56 | 500
8oz compostable lid | Catering 24 | 59.34 | 1000
8oz compostable lid | Next Day Coffee | 25.19 | 500
8oz compostable lid | [NAME] | 45.35 | 1000
Nesting Tray | ABPAC | 32.74 | 500
Nesting Tray | Bonds Packaging | 21.12 | 220
No. 1 [NAME] | Catering 24 | 56.99 | 450
No. 1 [NAME] | Enviropack | 59.94 | 450
No. 1 [NAME] | Enviropack 4+ | 56.39 | 450
No. 3 [NAME] | Catering 24 | 42.24 | 180
No. 3 [NAME] | Enviropack | 44.34 | 180
No. 3 [NAME] | Enviropack 4+ | 41.99 | 180
Perforated Film Front [NAME] bag | Enviropack | 36.54 | 1000
Perforated Film Front [NAME] bag | Enviropack 5+ | 33.59 | 1000
Perforated Film Front [NAME] bag | Next Day Coffee | 39.59 | 1000
SOS Carrier Bag | Catering 24 | 21.59 | 250
SOS Carrier Bag | Enviropack | 21.59 | 250
SOS Carrier Bag | Enviropack 5+ | 19.79 | 250
10" Greaseproof bag | ABPAC | 15
Spreadsheet: 771875d1646904420-help-with-formula-on-calculating-months-remaining-book1
Sheet: Prepayments

Prepayments 1103
Prepayment |  | Nom Code |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 |  |  | Inv No | Inv Total | Prepaid Months | Start Mnth | End Mnth | TO POST
Deposit-107 Heritage Court | Dep | 1103 |  | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Deposit-Faraday Wharf, Offices | Dep | 1103 |  | 9505 | 9505 | 9505 | 9505 | 9505 | 9505 | 9505 | 9505 | 9505 | 9505 | 9505 | 9505 | 9505
[NAME], (invoiced 1 month in advance) |  | 7100 |  | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7 | 7962.7
[NAME] | rent | 7105 |  |  |  |  |  |  |  |  |  |  | 4033.33 | 2016.67
[NAME] | rent | 7105 |  |  |  |  |  |  |  |  |  |  |  | 6050 | 6050 | 4033 |  |  |  |  |  |  |  |  |  |  |  |  |  | INV-0214 | 6050 |  | 2022-01-01 00:00:00 | 2022-03-31 00:00:00
[NAME] |  | 7104 |  |  |  |  |  |  |  |  |  |  |  | 579.8 | 579.8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | INV-0210 | 579.8 |  | 2022-01-01 00:00:00 | 2022-06-30 00:00:00
Mill St Service Charge |  | 7106 |  |  |  |  |  |  |  |  |  |  |  | 516 | 516 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | INV-0221 | 516 |  | 2022-01-01 00:00:00 | 2022-06-30 00:00:00
Software | soft | 7606
[NAME] monitoring | pro fees | 7608 |  |  |  |  |  |  |  | 6666.666666666667 | 3333.333333333333 | 0 | 6666.67 | 3333.34 | 10000 | 6666 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 |  | 2022-01-01 00:00:00 | 2022-03-31 00:00:00
Rent - 107 Heritage Court (inv 1 mths in advance) | Rent | 7652 |  | 1200 | 1200 | 1200 | 1200 | 1200 | 0
Mathworks Ltd Feb19-Jan 20 | soft | 7776
Solidworks | soft | 7776
Food & Drug Administration | Memb | 7752 |  | 0 | 0
Spreadsheet: 686928d1594877117-multiple-functions-in-one-cell-markbook-practice-ii-autosaved-
Sheet: 9A

 |  |  | Learning Outcomes Summary |  |  |  | Reading & Viewing |  |  |  |  |  |  |  |  |  | Writing |  |  |  |  |  |  |  |  |  | Speaking & Listeniing |  |  |  |  |  |  |  |  |  | Course Work
Name | Surname | Overall | Reading & Viewing | Writing | Speaking & Listening | Course Work
[NAME] | [NAME] |  |  |  |  |  | 4 | 8 | 7 | 1 | 4 | 6 | 5.5 | 9 | 3 | 2 | n
[NAME] | BOWEN
[NAME] | CHOU
[NAME] | CLYDE
[NAME] | EL HABTI
[NAME] | GANINO
Alicia | GEROGE - PHELAN
Ebony | GRECH
[NAME] | HAM
Muhaimin | KABIR
Yoshini | [NAME]
Imran | [NAME]
[NAME] | MAKAROW
[NAME] | MADDEN
Giselle | [NAME]
[NAME] | [NAME]
Dario | MUNOZ JOFRE
Bailey | POTTS
Zakary | RANTINO
[NAME] | RIGATO
Taia | SEAR
Kaylin | STANTON
Kalam | SUPRIATNA
Halle | TOWERZY
Kelly | TOWERZY
A | WebEx
N | Non Submit
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: Amoco Abo

 | [NAME]
Day | Measured | Scheduled | Imbal
1 | 17119 | 21220
2 | 16670 | 18277
3 | 16648 | 16986
4 | 16896 | 21488
5 | 17028 | 16345
6 | 16385 | 16988
7 | 16743 | 16988
8 | 16645 | 16988
9 | 16869 | 13954
10 | 17177 | 16887
11 | 15991 | 16854
12 | 14061 | 16789
13 | 15546 | 16211
14 | 16512 | 16988
15 | 16723 | 16365
16 | 16042 | 16835
17 | 16517 | 16758
18 | 15605 | 16758
19 | 16163 | 16628
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | -65848.31
2000-12-19 00:00:00
Spreadsheet: 816171d1675416944-invoices-issued-or-planned-to-be-issued-vs-collection-variable-days-per-client-example-sheet
Sheet: Sheet1

 | ACCRUED REVENUE - INVOICES ISSUED
 | DATE | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 |  | DAYS TO COLLECTION | EACH CLIENT CONFIGURABLE DAYS
 | CLIENT 1 | x |  |  |  |  | 45
 | CLIENT 2 | x |  |  |  |  | 30
 | CLIENT 3 | x |  |  |  |  | 60
 | CLIENT 4 | x |  |  |  |  | 90
 | CLIENT 5 | x |  |  |  |  | 37
 | CLIENT 6 | x |  |  |  |  | 58
 | AMOUNTS RECEIVED - EXPECTED DATE
 | DATE | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00
 | CLIENT 1
 | CLIENT 2
 | CLIENT 3
 | CLIENT 4
 | CLIENT 5
 | CLIENT 6
Spreadsheet: 849634d1700060174-concat-dynamic-arrays-via-ids-concat-dynamic-arrays
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULT
 |  |  |  |  |  | id | name |  | id | suffix |  | id | concatenation
B | banana1 |  | B | yellow |  |  | banana1 |  |  | yellow |  | B | banana1 yellow
B | [NAME] |  | B | red |  | B | [NAME] |  | B | red |  | B | banana1 red
O | orange |  | B | blue |  | O | orange |  | B | blue |  | B | banana1 blue
 |  |  | O | blue |  |  |  |  | O | blue |  | B | banana1 black
 |  |  | O | red |  |  |  |  | O | red |  | B | banana2 yellow
 |  |  | B | black |  |  |  |  | B | black |  | B | [NAME] red
 |  |  |  |  |  |  |  |  |  |  |  | B | banana2 blue
 |  |  |  |  |  |  |  |  |  |  |  | B | [NAME] black
 |  |  |  |  |  |  |  |  |  |  |  | O | orange blue
 |  |  |  |  |  |  |  |  |  |  |  | O | orange red
Spreadsheet: 743668d1628669629-conditional-function-with-arrays-issue-to-solve-a-problem-conditional-function-problem-example
Sheet: example

 |  |  | Table 1 : Main data |  |  |  |  |  | Table 2 : Sequence of the work
 |  |  | Code Activity | Activity | Code  Worker | Worker | Number of Worker |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00
 |  |  | A1 | Lunch room | W4 | Painter | 2 |  | A1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0
 |  |  | A1 |  | W1 | Labourer | 3 |  | A2 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
 |  |  | A1 |  | W3 | Electrician | 2 |  | A3 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0
 |  |  | A2 | Bathroom | [NAME] | Plumber | 2 |  | A4 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0
 |  |  | A2 |  | W1 | Labourer | 1 |  | A5 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  | A2 |  | [NAME] | Builder | 3
 |  |  | A3 | Lockers | W1 | Labourer | 3 |  | Table 3 : Total number of worker per month
 |  |  | A3 |  | [NAME] | Builder | 4
 |  |  | A4 | Kitchen | W3 | Electrician | 1 |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00
 |  |  | A4 |  | W4 | Painter | 1 |  | W1
 |  |  | A5 | Main room | W3 | Electrician | 1 |  | [NAME]
 |  |  | A5 |  | W1 | Labourer | 2 |  | W3
 |  |  | A5 |  | W4 | Painter | 1 |  | W4
 |  |  | A5 |  | [NAME] | Builder | 5 |  | W5
Spreadsheet: mary_fischer__25434__SS May Monthly Logs
Sheet: ETS - Grid Downtime

GE Wind Maintenance Corp.
Site:     Sommerset
DATE:  6/01/02
ETS - GRID DOWNTIME LOG MAY 2002
Pad | Feeder |  | Date | Date | Time | Time | Elapsed
Location | Location | Description - Fault Indication/Activity | Off | On | Off | On | Hours
1 thru 6 |  | Grid Failure | 2002-05-02 00:00:00 | 2002-05-02 00:00:00 | 14:10:00 | 15:15:00
1 thru 6 |  | Grid Failure | 2002-05-14 00:00:00 | 2002-05-14 00:00:00 | 18:27:00 | 20:16:00
1 thru 6 |  | Grid Failure | 2002-05-29 00:00:00 | 2002-05-29 00:00:00 | 14:49:00 | 17:06:00
1 thru 6 |  | Grid Failure | 2002-05-31 00:00:00 | 2002-05-31 00:00:00 | 20:05:00 | 22:40:00
Note - some facilities do not have feeders, in those cases identify the turbines effected.