tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 38224d1236333670-multiple-criteria-sumif-or-productif-multiple-criteria
Sheet: Sheet1

 | project | status | charge type | Profit/Loss | F | G | H | I
 | 1 | F | F | 10
 | 2 | F | T | -10
 | 3 | F | P | 10
 | 4 | F | F | -10
 | 5 | L | F | 10
 | 6 | L | F | -10
 | 7 | L | T | 10
 | 8 | L | P | -10
 | 9 | C | F | 10
 | 10 | C | T | -10
 | 11 | C | P | 10
 | 12 | C | F | -10
I NEED:
Colum F | CELL = value of profit/loss colum (same row) if it is a positive number and the status is F or C and the charge type is F or T
Colum G | CELL = Value of profit/loss colum (same row) if it is a negative number and the status is F or C and the charge type is F or T
Colum H | CELL = value of profit/loss colum (same row) if it is a positive number and the status is L and the charge type is F or T
Colum I | CELL = value of profit/loss colum (same) if it is a negative number and the status is L and the charge type is F or T
thank you very much for looking !!
Spreadsheet: 725902d1616952158-search-multiple-text-in-cell-and-return-found-text-via-formula-in-another-suffix
Sheet: Sheet1

 |  | Wanted Result
 | [NAME]
 | [NAME]
 | aa I
 | aa II
 | aa III
 | aa IV
 | aa V
 | aa VI
 | aa VII
 | aa VIII
 | aa IX
 | [NAME]
 | [NAME]
 | [NAME]
 | Six
Spreadsheet: 019da1ba-54de-4bee-8dc1-a8f8ccfd6ab1
Sheet: Individual School Sites

Participating in CEP by School Site:  Use the Individual School Sites form to list each site in the district that will be participating in CEP.  When participating by site, each site will have its own claiming percentages.  There is also the option of having some schools claimed as individual sites as well as having some schools claimed as a group in order to increase their claiming percentages.  If you have both individual sites and groups, both the Individual School Sites form and the Group Sites form will need to be completed.
Name of Individual School Site | Site ID Number from Claim System | Identified Students as of April 1, 2014 | Enrolled Students as of April 1, 2014 | Identified Student Percentage
Spreadsheet: 764569d1642789777-multiple-level-combining-into-one-column-ad
Sheet: Sheet1

Result | Colours | Fruit | Animals | Numbers
blue,apple,dog,6 | blue | apple | dog | 6
blue,apple,dog,7 | red | peach | cat | 7
blue,apple,dog,8 | yellow | grape | cow | 8
blue,apple,dog,9 | green |  |  | 9
blue,apple,cat,6
blue,apple,cat,7
blue,apple,cat,8
blue,apple,cat,9
blue,apple,cow,6
blue,apple,cow,7
blue,apple,cow,8
blue,apple,cow,9
blue,peach,dog,6
blue,peach,dog,7
blue,peach,dog,8
blue,peach,dog,9
blue,peach,cat,6
Spreadsheet: 790535d1659774862-using-lookup-to-find-the-1st-2nd-3rd-and-4th-value-test-how-to-return-nth-value-in-lookup
Sheet: Sheet2

School name | Subject name | Price
St Marys School | Maths | 75
St Peters School | Maths | 50
London Free School | English | 15
St Pauls Academy | Science | 25
St Marys School | Science | 25
St Marys School | English | 75
St Pauls Academy | Maths | 100
St Pauls Academy | Science | 15
St Pauls Academy | English | 25
St Pauls Academy | History | 125
Spreadsheet: daren_farmer__5545__HPLN1027
Sheet: Sheet1

HPLN1027.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - October 27, 2000
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-10-27 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | HPL | 10 | 20
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 288847d1389318133-consolidate-multiple-worksheets-into-one-reference-cover-sheet-excel-forum
Sheet: 20076

Recipient Created Tax Invoice
TO: | worker |  |  |  |  |  | FROM: | Work
 | worker |  |  |  |  |  |  | 123 Work
 | address |  |  |  |  |  |  | Work
 | WA | 6055 |  |  |  |  |  | WA | 6666
 | ABN: | abn |  |  |  |  |  | ABN: | 55 555 555 555
 | Vendor # | 20076
 | APPRENTICE DETAILS |  |  |  |  |  |  | Date: | 2014-01-10 00:00:00
 | Name: |  | Ned |  |  |  |  | Invoice #
 | Employee Number: |  | 12609 |  |  |  |  | FN Start
 | Apprenticeship: |  | [NAME] (3YR)
 | G/L Code: |  | 2118
 | 12609#20076
 | Date | Ordinary Hours | Ordinary $ Total | Travel $ Total | OT15 Hours | OT15 $ | OT20 Hours | OT20 $ | Meal | TOTAL
 | 2013-12-11 00:00:00 | 8 | 172.4 | 13.12 |  |  |  |  |  | 185.52
 | 2013-12-12 00:00:00 | 8 | 172.4 | 13.12 |  |  |  |  |  | 185.52
 | 2013-12-13 00:00:00 | 8 | 172.4 | 13.12 |  |  |  |  |  | 185.52
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 | Less Daily Subsidy | CTF |  |  |  |  |  |  |  | 4.3269
 |  | ABBTF |  |  |  |  |  |  |  | 1.45383
 |  | ABN DISCOUNTS |  |  |  |  |  |  |  | 0
 | Net Invoice |  |  |  |  |  |  |  |  | 550.7792700000001
 | GST |  |  |  |  |  |  |  |  | 55.07792700000002
 | Total payable inclusive of GST |  |  |  |  |  |  |  |  | 562.3407300000001
Spreadsheet: 50030d1249455295-count-numbers-in-columns-footballbetting
Sheet: Sheet2

 |  | Stage 1 | Stage 2 | Stage 3 | Stage 4 |  | Max Total Games |  | Units |  | Risk Amount
1 |  | 3 | 0 | 0 | 0 |  | 3 |  | 3 |  | 375
2 |  | 2 | 1 | 0 | 0 |  | 3 |  | 4 |  | 656.25
3 |  | 1 | 1 | 1 | 0 |  | 3 |  | 6 |  | 1570.3125
4 |  | 0 | 1 | 3 | 1 |  | 5 |  | 15 |  | 5861.328125
5 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
6 |  | 0 | 0 | 1 | 0 |  | 1 |  | 3 |  | 1039.0625
7 |  | 0 | 0 | 0 | 1 |  | 1 |  | 4 |  | 2337.890625
8 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
9 |  | 0 | 0 | 1 | 0 |  | 1 |  | 3 |  | 1039.0625
10 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
11 |  | 0 | 0 | 0 | 1 |  | 1 |  | 4 |  | 2337.890625
12 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
13 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
14 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
15 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
16 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
Total Bets | 6
[NAME] | 2
[NAME] | 1200
 |  |  | Bet Unit | 100
 |  |  | [NAME] | -125
 |  | Gm 1 | Gm 2 | Gm 3 | [NAME] 4 | Total | Avg Unit
 |  | 125 | 406.25 | 1039.0625 | 2337.890625 | 3908.203125 | 40 | 39.08203125
Spreadsheet: 885697d1735518571-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-r2
Sheet: Import

 |  | SN | Number | Surname | Name | Position | IsNew
 | Import here ->: | 1 | 80110908 | [NAME] | [NAME] | E-Team
 |  | 2 | 80110917 | [NAME] | Hans | A-Team
 |  | 3 | 80110907 | [NAME] | Johnson Onuche | M-Team
 |  | 4 | 80110911 | Moses | Mark | M-Team
 |  | 5 | 80110909 | Bond | [NAME] | A-Team
 |  | 6 | 80110733 | Potter | [NAME] | A-Team
 |  | 7 | 80111125 | [NAME] | [NAME] | A-Team
 |  | 8 | 80111005 | [NAME] | [NAME] | M-Team
 |  | 9 | 80078168 | [NAME] | [NAME] | E-Team
 |  | 10 | 80111210 | Edison | Wayne | M-Team
 |  | 11 | 80078167 | Adams | [NAME] | E-Team
 |  | 12 | 80077694 | [NAME] | Kenny | E-Team
 |  | 13 | 80111179 | Jordan | Mick | M-Team
 |  | 14 | 80110912 | [NAME] | Micky | A-Team
 |  |  |  | C | D | A-Team
 |  |  |  | D | E | E-Team
 |  |  |  | F | G | M-Team
Spreadsheet: benjamin_rogers__1044__Peaker Valuation 060500
Sheet: 99 Acct Sumry

GENCO '99 Peakers LLC
Expense Analysis Summary
Summary
2000-03-31 00:00:00
 |  | '99 [NAME]
 |  | Brownsville | Caledonia | New Albany
Mobilization
Operations & Maintenance: | Classification
O&M Expenses
Fuel Handling Sstem (Gas) | Fixed
Feedwater System | Variable
Air Pollution Control System | Fixed
Combustion Air System | Fixed
Fire Protection System | Fixed
Demineralized Water System | Variable
Wastewater System | Fixed
Recirculating Water System | Fixed
Building Utilities & HVAC System | Fixed
Electrical Distribution System | Fixed
Steam Distribution System | Fixed
Distributed Control System | Fixed
Plant Consumable Supplies | Fixed
Plant [NAME] | Fixed
Reimbursable Labor | Fixed
Tools & Equipment | Fixed
Utilities | Fixed
Instrument/Service Air | Fixed
Gas T/G System | Variable
HRSG System | Variable
Other - Non-Scope Costs | Fixed
Subtotal Other O&M
O&M Management Fee
Major [NAME]
Subtotal - Oper & Maint Expense
Owner's Expense:
Insurance | Owners
Property Taxes
Utilities | Owners | 0 | 0 | 0
Interconnection Fees | Owners
Gas Pipeline Metering Cost | Owners
Misc | Owners
Franchise Taxes | Owners
 |  |  |  | 0
Subtotal - Owner's Expense
Total O&M excluding Capital Costs
Other Expense
Interest Expense
Capital Charge, net of credit
Depreciation Expense
Subtotal - Other Expense
Total O&M
 | Check
 | Difference
Spreadsheet: 701706d1603894130-summing-values-in-one-column-using-vlookup-dummy-dataset-updated
Sheet: shcedule

Vendor number | Paid (USD)
4030
6231
6336
4778
4467
4136
4140
5823
6314
4817
4858
4141
6275
4997
6417
6368
4546
5902
This vendor number has paid twice
Spreadsheet: 546345d1509994750-top-categories-sort-out-search
Sheet: Sheet1

Group | Food | Number |  | Row Labels | Sum of Number
Fruits | Apples | 1 |  | Meat | 13
Fruits | Bananas | 2 |  | Chicken | 7
Vegetables | Lettuce | 4 |  | Cow | 6
Vegetables | Tomatoes | 5 |  | Vegetables | 9
Meat | Cow | 6 |  | Lettuce | 4
Meat | Chicken | 7 |  | Tomatoes | 5
 |  |  |  | Fruits | 3
 |  |  |  | Apples | 1
 |  |  |  | Bananas | 2
 |  |  |  | Grand Total | 25
Spreadsheet: 225813d1365111744-format-cell-to-always-insert-specific-thing-when-a-specific-name-is-typed-example
Sheet: Sheet1

Name (entered) | Name (with formula)
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Eunice
[NAME]
Pablo
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 147937d1333040979-2-formulas-to-move-based-on-one-cell-book6
Sheet: Data

 | 2011 REAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 REAL
 | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER |  |  | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER
Sales | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  |  | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41
Spreadsheet: dc5006db-fc11-4b28-8347-fa5045b0a27c
Sheet: 4.6-05

Cuadro 4.6-05
REPUBLICA DOMINICANA: Suicidios ocurridos y registrados por año y sexo, según lugar del hecho, 2007-2011
[NAME] | 2007 |  |  | 2008 |  |  | 2009 |  |  | 2010 |  |  | 2011p
 | Total | Sexo |  | Total | Sexo |  | Total | Sexo |  | Total | Sexo |  | Total | Sexo
 |  | Masculino | Femenino |  | Masculino | Femenino |  | Masculino | Femenino |  | Masculino | Femenino |  | Masculino | Femenino
Total |  | 443 | 71 |  | 454 | 79 |  | 457 | 68 |  | 483 | 66
Domicilio |  | 346 | 58 |  | 366 | 64 |  | 386 | 69 |  | 378 | 58 |  | 380 | 88
Trabajo |  | 9 | 0 |  | 13 | 0 |  | 9 | 3 |  | 14 | 1 |  | 19 | 0
Finca/parcela |  | 11 | 1 |  | 23 | 2 |  | 16 | 0 |  | 15 | 0 |  | 30 | 1
Hotel/cabaña |  | 14 | 2 |  | 9 | 3 |  | 11 | 3 |  | 7 | 0 |  | 8 | 1
Vía pública |  | 5 | 0 |  | 3 | 1 |  | 3 | 1 |  | 5 | 0 |  | 40 | 4
Cárcel |  | 8 | 0 |  | 5 | 0 |  | 9 | 0 |  | 3 | 0 |  | 4 | 0
Centro de salud |  | 2 | 1 |  | 0 | 0 |  | 2 | 0 |  | 1 | 0 |  | 0 | 1
Mar/playa |  | 3 | 2 |  | 2 | 2 |  | 2 | 0 |  | 0 | 1 |  | 4 | 2
Puente |  | 8 | 1 |  | 8 | 1 |  | 10 | 0 |  | 10 | 2 |  | 5 | 2
Parque |  | 11 | 1 |  | 1 | 0 |  | 1 | 0 |  | 1 | 0 |  | 0 | 1
Centro diversión |  | 6 | 0 |  | 2 | 1 |  | 2 | 0 |  | 0 | 1 |  | 0 | 0
Centro de enseñanza |  | 0 | 0 |  | 1 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Río/cañada |  | 2 | 1 |  | 1 | 1 |  | 5 | 0 |  | 1 | 0 |  | 4 | 1
[NAME]/solar |  | 5 | 1 |  | 5 | 1 |  | 7 | 0 |  | 13 | 2 |  | 7 | 0
Establecimiento de bebida/comida |  | 1 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 5 | 0
[NAME] |  | 3 | 0 |  | 1 | 0 |  | 3 | 0 |  | 7 | 0 |  | 1 | 0
[NAME] |  | 1 | 0 |  | 4 | 1 |  | 5 | 0 |  | 5 | 0 |  | 4 | 0
Fortaleza/cuartel |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 1 | 0 |  | 0 | 0
Canal |  | 0 | 0 |  | 2 | 0 |  | 1 | 0 |  | 0 | 0 |  | 0 | 0
Vehículo |  | 3 | 0 |  | 2 | 1 |  | 5 | 0 |  | 4 | 0 |  | 4 | 0
Cementerio |  | 1 | 0 |  | 0 | 0 |  | 3 | 0 |  | 2 | 0 |  | 1 | 0
Edificio/casa/apartamento |  | 1 | 0 |  | 3 | 0 |  | 1 | 0 |  | 3 | 0 |  | 1 | 2
Matorrales |  | 2 | 0 |  | 0 | 0 |  | 2 | 0 |  | 3 | 0 |  | 6 | 1
Establecimiento de apuesta |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 1 | 0 |  | 0 | 0
Centro recreativo |  | 0 | 0 |  | 0 | 0 |  | 1 | 0 |  | 0 | 0 |  | 1 | 0
Comercio |  | 1 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 8 | 0
Campo de caña |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 1 | 0
Vertedero |  | 1 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Iglesia |  | 0 | 0 |  | 0 | 0 |  | 1 | 0 |  | 0 | 0 |  | 0 | 0
No especificado |  | 0 | 0 |  | 0 | 0 |  | 2 | 0 |  | 2 | 0 |  | 0 | 0
p: Cifras preliminares
Fuente: Registros administrativos de la Oficina de Estadísticas y Cartografía de la Policía Nacional
Spreadsheet: 120582d1315394043-populate-cell-with-week-commencing-dates-wctest
Sheet: Sheet1

CompletionDate | Completion W/C |  |  | w/c
2011-08-28 00:00:00 | 2011-08-25 00:00:00 | <--- Auto populate W/C column with dates from the right based on Completion date----> |  | 2011-08-25 00:00:00 | Our week commences from Thursday and ends Wednesday
2011-09-02 00:00:00 | 2011-09-01 00:00:00 |  |  | 2011-09-01 00:00:00
2011-08-28 00:00:00 |  |  |  | 2011-09-08 00:00:00
2011-09-02 00:00:00 |  |  |  | 2011-09-15 00:00:00
2011-08-28 00:00:00 |  |  |  | 2011-09-22 00:00:00
 |  |  |  | 2011-09-29 00:00:00
2011-08-28 00:00:00 |  |  |  | 2011-10-06 00:00:00
2011-09-02 00:00:00 |  |  |  | 2011-10-13 00:00:00
2011-08-28 00:00:00 |  |  |  | 2011-10-20 00:00:00
 |  |  |  | 2011-10-27 00:00:00
 |  |  |  | 2011-11-03 00:00:00
2011-08-29 00:00:00 |  |  |  | 2011-11-10 00:00:00
2011-08-29 00:00:00 |  |  |  | 2011-11-17 00:00:00
2011-08-29 00:00:00 |  |  |  | 2011-11-24 00:00:00
2011-08-29 00:00:00 |  |  |  | 2011-12-01 00:00:00
 |  |  |  | 2011-12-08 00:00:00
 |  |  |  | 2011-12-15 00:00:00
 |  |  |  | 2011-12-22 00:00:00
 |  |  |  | 2011-12-29 00:00:00
 |  |  |  | 2012-01-05 00:00:00
 |  |  |  | 2012-01-12 00:00:00
 |  |  |  | 2012-01-19 00:00:00
 |  |  |  | 2012-01-26 00:00:00
 |  |  |  | 2012-02-02 00:00:00
 |  |  |  | 2012-02-09 00:00:00
 |  |  |  | 2012-02-16 00:00:00
 |  |  |  | 2012-02-23 00:00:00
 |  |  |  | 2012-03-01 00:00:00
 |  |  |  | 2012-03-08 00:00:00
 |  |  |  | 2012-03-15 00:00:00
 |  |  |  | 2012-03-22 00:00:00
 |  |  |  | 2012-03-29 00:00:00
Spreadsheet: 859681d1707986581-inserting-subtotal-n-total-to-array-formula-subtotal-n-totel-4-
Sheet: Data

Account Code | Description | Period | Nett Change | Type | Subtype |  |  |  | Account Code | Description | Type | Subtype
#1 | Sales-Toy | 2023-04-30 00:00:00 | 5150 |  |  |  |  |  | #1 | Sales-Toy | Revenue | Sales
#2 | Sales-Furniture | 2023-04-30 00:00:00 | 15800 |  |  |  |  |  | #2 | Sales-Furniture | Revenue | Sales
#3 | Sales-Hardware | 2023-04-30 00:00:00 | 39000 |  |  |  | <-- This is what I extract from System. Column E:F is base on Column L:O |  | #3 | Sales-Hardware | Revenue | Sales
#4 | Sales-F&B | 2023-04-30 00:00:00 | 6905 |  |  |  |  |  | #4 | Sales-F&B | Revenue | F&B
#5 | COGS-Hardware | 2023-04-30 00:00:00 | -26800 |  |  |  |  |  | #5 | COGS-Hardware | Expenses | [NAME]
#6 | COGS-Furniture | 2023-04-30 00:00:00 | -8700 |  |  |  |  |  | #6 | COGS-Furniture | Expenses | [NAME]
#7 | COGS-F&B | 2023-04-30 00:00:00 | -1500 |  |  |  |  |  | #7 | COGS-F&B | Expenses | [NAME]
#8 | Salary | 2023-04-30 00:00:00 | -3150 |  |  |  |  |  | #8 | Salary | Expenses | Staff Cost
#9 | Allowance | 2023-04-30 00:00:00 | -900 |  |  |  |  |  | #9 | Allowance | Expenses | Staff Cost
#10 | Medical Fee | 2023-04-30 00:00:00 | -150 |  |  |  |  |  | #10 | Medical Fee | Expenses | Staff Cost
#11 | Depreciation | 2023-04-30 00:00:00 | -480 |  |  |  |  |  | #11 | Depreciation | Expenses | Misc
#12 | Utilities | 2023-04-30 00:00:00 | -1100 |  |  |  |  |  | #12 | Utilities | Expenses | Misc
#13 | Site Maintenance | 2023-04-30 00:00:00 | -2100 |  |  |  |  |  | #13 | Site Maintenance | Expenses | Misc
#1 | Sales-Toy | 2023-05-31 00:00:00 | 4800
#2 | Sales-Furniture | 2023-05-31 00:00:00 | 15000
#3 | Sales-Hardware | 2023-05-31 00:00:00 | 32100
#4 | Sales-F&B | 2023-05-31 00:00:00 | 8500
#5 | COGS-Hardware | 2023-05-31 00:00:00 | -30000
#6 | COGS-Furniture | 2023-05-31 00:00:00 | -9000
#7 | COGS-F&B | 2023-05-31 00:00:00 | -1500
#8 | Salary | 2023-05-31 00:00:00 | -3150
#9 | Allowance | 2023-05-31 00:00:00 | -650
#10 | Medical Fee | 2023-05-31 00:00:00 | -150
#11 | Depreciation | 2023-05-31 00:00:00 | -480
#12 | Utilities | 2023-05-31 00:00:00 | -1300
#13 | Site Maintenance | 2023-05-31 00:00:00 | -2100
#1 | Sales-Toy | 2023-06-30 00:00:00 | 4800
#2 | Sales-Furniture | 2023-06-30 00:00:00 | 15500
#3 | Sales-Hardware | 2023-06-30 00:00:00 | 7000
#4 | Sales-F&B | 2023-06-30 00:00:00 | 6500
#5 | COGS-Hardware | 2023-06-30 00:00:00 | -30000
#6 | COGS-Furniture | 2023-06-30 00:00:00 | -7900
#7 | COGS-F&B | 2023-06-30 00:00:00 | -1500
#8 | Salary | 2023-06-30 00:00:00 | -4800
#9 | Allowance | 2023-06-30 00:00:00 | -1500
#10 | Medical Fee | 2023-06-30 00:00:00 | -150
#11 | Depreciation | 2023-06-30 00:00:00 | -480
#12 | Utilities | 2023-06-30 00:00:00 | -1000
#13 | Site Maintenance | 2023-06-30 00:00:00 | -3200
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Marshall

[NAME] | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 768086d1644836944-formula-to-pick-up-last-6-months-data-test-2
Sheet: Raw

[NAME] as at 31 January 2022
Summary Data
Revenue 2020 | Actual | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 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
 |  | 5 | 6 | 6 | 7 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6
Revenue 2021 | Actual | 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
 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
Spreadsheet: eric_saibi__9780__013102R
Sheet: Waukegan 07

Owner Name |  | Midwest Generation LLC
Station Name |  | [NAME]
Unit Name |  | [NAME] 07
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Coal
Capacity |  | 326
Start Date |  | 2002-01-11 00:00:00
End Date |  | 2002-04-12 00:00:00
Prv. Start Date |  | 2002-01-11 00:00:00
Prv. End Date |  | 2002-02-21 00:00:00
Comments |  | Precipitator work along with turbine work.
SIC |  | 4931
Plant ID |  | 1013831
Unit ID |  | 1005812
Outage ID |  | 12850
Spreadsheet: 170494d1343300831-return-value-for-duplicate-items-row-return-value-for-duplicate-items
Sheet: NAME

70068 | Thekkethil, [NAME]
70414 | [NAME], [NAME]
70452 | Singh, Bahadur
70452 | Singh, Bahadur
70455 | Ram, [NAME]
70481 | Boudiab, [NAME]
70482 | Zahr, [NAME]
70483 | Mangwenge, Kangiso Trust
70582 | [NAME], [NAME]
70582 | [NAME], [NAME]
70597 | Mol, [NAME]
70625 | [NAME], Sameer [NAME]
70625 | [NAME], Sameer [NAME]
70670 | Mishra, Ashok
Spreadsheet: 744990d1629639582-formula-repeating-same-results-when-applied-to-all-rows-client-hours
Sheet: Sheet1

 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Total | Available Hours | Hours Left
LCC | 8 | 9 |  |  |  |  | 26
WP | 7 | 7 |  |  |  |  | 15
AAP | 4.5 | 4.5 |  |  |  |  | 29
Fish | 5.5 | 8 |  |  |  |  | 20
[NAME] | 7 | 5.5 |  |  |  |  | 56
ASQ |  |  |  |  |  |  | 25
Spreadsheet: 166342d1341559305-help-with-multiple-answers-in-model-oil-and-gasexcelsample
Sheet: Oil production Value Calc

 |  |  |  |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Year 12 | Year 13 | Year 14 | Year 15
 |  |  |  |  | Boe/d
 | 2010 |  |  |  | Price
 | 2011 |  |  |  | Revenue
 |  |  |  |  | Royalty
 |  |  |  |  | variable cost
 |  |  |  |  | operational cost
 |  |  |  |  | Income before tax
 |  |  |  |  | Tax rate
 |  |  |  |  | @
 |  |  |  |  | Net Income
 |  | NPV
 |  | @
 |  | 0.1
 |  | 0.15
 |  | 0.2
Spreadsheet: 2977a16c-cf52-472f-bb7e-54d2f523c3bc
Sheet: 4.3 Dwelling approvals

4.3 Dwelling approvals
Month | 2010–11 | 2011–12 | 2012–13 | 2013-14 | 2014-15
Number (a)
\
July | 14492 | 12973 | 13256 | 14830 | 16199
August | 14243 | 12691 | 13290 | 15252 | 16317
September | 14152 | 12357 | 13269 | 15728 | 16426
October | 14141 | 12031 | 13208 | 16212 | 16518
November | 14124 | 11679 | 13169 | 16578
December | 14087 | 11401 | 13193 | 16728
January | 13993 | 11411 | 13211 | 16699
February | 13772 | 11716 | 13286 | 16538
March | 13505 | 12151 | 13462 | 16344
April | 13331 | 12543 | 13730 | 16174
May | 13244 | 12878 | 14059 | 16060
June | 13145 | 13127 | 14438 | 16083
Annual (b) | 168103 | 149960 | 160241 | 194541
This month compared to same month in previous year - per cent change (a)
July | 15.61228560031911 | -10.48164504554237 | 2.18145378863794 | 11.87386843693422 | 9.23128792987188
August | 9.25897514575023 | -10.8965807765218 | 4.719880230084312 | 14.76297968397291 | 6.982690794649882
September | 4.396577161404544 | -12.68371961560204 | 7.380432143724206 | 18.5319164970985 | 4.43794506612411
October | 0.3975860844870429 | -14.92115126228697 | 9.783060427229657 | 22.74379164142944 | 1.887490747594375
November | -3.498223558349276 | -17.31096006796941 | 12.75794160458944 | 25.88655175032273
December | -7.181920010542268 | -19.0672251011571 | 15.7179194807473 | 26.79451224134011
January | -10.55356686269496 | -18.45208318444937 | 15.77425291385505 | 26.4022405571115
February | -13.55219383591739 | -14.92884112692419 | 13.40047797883236 | 24.47689297004365
March | -15.51454488583047 | -10.02591632728619 | 10.78923545387211 | 21.40840885455356
April | -15.5464048146975 | -5.911034431025429 | 9.463445746631589 | 17.80043699927167
May | -13.9385275196569 | -2.763515554213229 | 9.17067867681317 | 14.23287573796145
June | -11.86724773717734 | -0.1369341955116014 | 9.987049592443057 | 11.39354481230087
Annual (b) | -4.84915378955114 | -10.79278775512632 | 6.855828220858896 | 21.40525832964098
(a) Monthly figures (including the graph) are calculated on the trend series. Annual figures are calculated on the original series.
(b) 12 months ended June.
 |  |  |  |  |  |  | Update
Source: ABS, Building Approvals, Australia, Cat. no. 8731.0 |  |  |  |  |  |  | 2015-01-08 00:00:00