tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f720c2c4-8630-4784-9896-edbf42b42440
Sheet: Sheet1

LEA DATA (Enter only once) | Unnamed: 1 | CAMPUS SELECTION - TITLE I, PART A | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
 |  |  |  |  | Number of Students Residing in Each Attendance Area |  |  | Charter Schools / Alternate Measure for determining Schoolwide Program eligibility of Title I, Part A campuses / Optional Method |  |  |  |  |  |  |  |  | Alternate Poverty Measures for Determining Schoolwide Program Eligibility
County District Number | Source of Low Income Data - (Select option from drop-down box) | List All Campuses Operated by the LEA in [NAME] of Percentage of Students Meeting Low-Income Criteria (per Column H and Column K). | Campus Number | [NAME] | Total Number Residing | Number Residing that Meet Low-Income Criteria | Low-Income Residing Percentage | Total Number of Students ENROLLED at Campus | Total Number of  LOW INCOME Students ENROLLED at Campus | Low-Income Enrollment Percentage | Purpose of Low-Income Enrollment Percentage | [NAME] | One-Year Transition | [NAME] | Title I, Part A Campus Status: SW or TA or NS (Select option from drop-down box) | # Students served on [NAME] | SW Program Cont'd from Previous Year and Title I Eligible | SW Eligibility Year | Low Income in Eligibility Year (%) | Source of Low Income Data - Other (Specify)
 |  | (Do not enter [NAME] campuses.) |  |  |  |  | (Col G ÷ F) |  |  | (Col J ÷ I)
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U
 |  |  | TOTAL |  | 0 | 0 |  | 0 | 0
 |  | Enter campus information below | LEA’s Low-income %age: Total Col. G ÷Total Col. F or Total Col. J ÷ Col. I |  |  |  | 0 |  |  | 0
Spreadsheet: 877832d1724774794-add-remove-substring-from-a-string-sample-file_082724
Sheet: Sheet1

Before |  |  |  |  |  |  |  | After
COSTCENTER ID | COSTCENTER DESCRIPTION | PARENT NODE | Column1 | Column2 | READ | WRITE |  | COSTCENTER ID | COSTCENTER DESCRIPTION | PARENT NODE | Column1 | Column2 | READ | WRITE
100100 | Department 1 | ACCTG |  |  | ACTJB14 | ACTJB14
100105 | Department 2 | ACCTG |  |  | [NAME] | [NAME]
100200 | Department 3 | ACTUARY |  |  | [NAME] | [NAME]
100210 | Department 4 | ACTUARY |  |  | [NAME] | [NAME]
100270 | Department 5 | MEDICAL |  |  | RKNEE;ATRXF21 | RKNEE;ATRXF21
100300 | Department 6 | IT_OTH |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100345 | Department 7 | EIS |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100350 | Department 8 | DIG_TRANSF |  |  | RTULENF | RTULENF
100410 | Department 9 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100420 | Department 10 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100425 | Department 11 | EB_IM |  |  | CHUESMA;KWIENER;KSTARBA;JFITTZ | CHUESMA;KWIENER;KSTARBA;JFITTZ
100500 | Department 12 | DA_COE |  |  | RELOMAA;FMEMMO | RELOMAA;FMEMMO
Changes
COSTCENTER ID | READ | WRITE
100100 | CHUESMA | ADD
100425 | KWIENER | REMOVE
100500 | FMEMMO | REMOVE
Based on the action in column C, add or remove the string from the "After" table
Spreadsheet: 761546d1641025264-sumproduct-with-conditions-test
Sheet: RESULTS

 | BREAKOUT STRATEGY NOTES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRADES | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Trading Days | 252 | Annual calendar trading days |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | No Trade Days | 15 | Days w/ no trades available
 | Days Off | 10 | Vacation or other days off |  |  |  |  |  |  |  |  |  |  |  |  | ENTRY (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Traded % |  | Used in Annualized Net Gain calculations |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | ANNUALIZED NET GAIN CALCULATOR -1% |  |  |  |  |  |  |  | WEEKLY |  |  |  |  |  |  | 1B <
 | Price | Shares | Risk | Count | ROI | Net Profit | ATI |  | WEEK | TRADES | POINTS | WIN % | PF | ENTRY %
 | 10 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  | WIN % (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | < > | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | 30 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Setup multiplier: | PM Consolidation |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | GAIN/LOSS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POINTS (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 |  | All-time | Prev 3 Wk | > 1 pt | > 2 pt | > 3 pt | > 4 pt |  |  |  |  |  |  |  |  | < 100M
 | Win % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Trades |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Trades % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Profit Factor
 | Days (Traded) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PTS (10) | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Points (Net) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Points % (Net) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Points (Wk Ave) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Points (Annualized) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Entry Success %
 | [NAME] |  |  | Greatest sequence of negative trades |  |  |  |  |  |  |  |  |  |  |  | MEAN G/L -10% | >= 4 | >= 5 | >= 6 | >= 7 | >= 8 | >= 9 | >= 10
 | Ave [NAME] |  |  | Average sequence of negative trades |  |  |  |  |  |  |  |  |  |  |  | All-TIME (5)
 | PM Trades |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 10 Wk
 | PM Trades % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 5 Wk
 | PM Points (Net)
 | PM Win %
 | SETUPS
 | Setup | Trades | Trades % | Win % | Prev 3 Wk | Points | Entry %
 | PM Consolidation
 | PMH
 | HOD
 | R2G
 | Pivot
 | Daily
 | Consolidation
 | MAX
 |  | Mean 20% |  | > 5 pt | > 10 pt | > 20 pt | > 30 pt
 | Entry-High
 | High-Exit
 | ENTRY TIMES
 |  | Trades | Trades % | Ave
 | 8:30-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-15:59
Spreadsheet: 269700d1381250633-index-match-or-maybe-a-differnt-formula-to-look-up-multiple-criteria-trailing-spaces
Sheet: Sheet1

[NAME] | Date | Code | Qty | RateBand | Price
AUR | 20131001 | DS2 | 15 | 5
AUR | 20131001 | DM1B | 1 |  |  |  | I want to be able to fill in the price (for one, so quanity doesn't matter).
AUR | 20131001 | DM4B | 1 |  |  |  | So it would need to say, if the code is DS2 (Col C) and Rate band 5 (Col E), then the price would be ??
AUR | 20131001 | DS1B | 12 |  |  |  | The pricing guide is on Sheet 2
AUR | 20131001 | DS1FIRE | 1
HUT | 20131001 | IADS4M | 4
HUT | 20131001 | IADSL12 | 54
HUT | 20131001 | IADSL99 | 120
HUT | 20131001 | IDU | 69
HUT | 20131001 | IDUC | 78
HUT | 20131001 | IDUPP | 4
HUT | 20131001 | IVD101 | 10
HUT | 20131001 | IVDS103 | 13
HUT | 20131001 | IVDS10V | 1
HUT | 20131001 | IVDS20 | 4
HUT | 20131001 | IVDS2M | 103
HUT | 20131001 | IVDS4M | 31
HUT | 20131001 | IVDS5 | 46
HUT | 20131001 | IVDSL12 | 17
HUT | 20131001 | IVDSL99 | 111
HUT | 20131001 | IWE | 21
HUT | 20131001 | IWE3 | 2
HUT | 20131001 | [NAME] | 1
HUT | 20131001 | IWE6E | 1
HUT | 20131001 | TVDS2M | 39
HUT | 20131001 | TVDS4M | 2
HUT | 20131001 | TVDSL12 | 19
HUT | 20131001 | [NAME] | 8
Spreadsheet: daren_farmer__5665__HPLN0109
Sheet: Sheet1

HPLN0109.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - Januar 9, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-09 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | 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: 122558d1316963995-dsum-help-dsum-example
Sheet: Sheet1

 | Date | Premium | Full Economy | Discount Economy | Award |  |  | Premium | F.E. | Discount | Award
 | 2009-09-10 00:00:00 |  |  |  |  |  |  | A | F | K | P
 | 2009-10-10 00:00:00 |  |  |  |  |  |  | B | G | L | Q
 | 2009-11-09 00:00:00 |  |  |  |  |  |  | C | H | M | R
 | 2009-12-09 00:00:00 |  |  |  |  |  |  | D | I | N
 | 2010-01-08 00:00:00 |  |  |  |  |  |  | E | J | O
 | 2010-02-07 00:00:00
 |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R
 | 2009-09-10 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 2009-10-10 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 2009-11-09 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 2009-12-09 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 2010-01-08 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 2010-02-07 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 272680d1382461615-vlookup-sum-average-etc-of-all-matches-averageif-offset-for-hansaa
Sheet: Sheet1

Name | Set 1 | Set 2 | Set 3 | Set 4 |  | Name | Dortmund
Dortmund | 19 | 10 | 6 | 3 |  | Set | Set 2
Augsburg | 16 | 9 | 4 | 4 |  | Average:
Dortmund | 20 | 19 | 4 | 10
Freiburg | 8 | 8 | 4 | 3
[NAME] | 6 | 19 | 2 | 9
Spreadsheet: 2d43b034-efc6-4ba7-8446-c34481351451
Sheet: Sheet1

Triad Elite Team Name
2011 - 2012 Season
Player Information Sheet
Players [NAME] Name:
Name player likes to be called:
Players [NAME] (mm/dd/yy):
Home Address:
Home Phone #
Main [NAME] (If only one used):
[NAME]:
Mothers Cell #  (Texting Plan Y / N)
Mother's [NAME]:
Fathers Name:
Fathers Cell # (Texting Plan Y / N)
Father's [NAME]:
Players Cell #
Are text messages allowed?
Players [NAME]:
Grad Year:
High School Name (If in High School):
College Commitment (If committed):
Previous Team played for:
Number of years with team:
Primary position played:
ODP Player? What level State, Regional?
Jersey Number Request
Jersey Number Request
(List top 5)                             First Choice
Second Choice
Third Choice
Fourth Choice
Fifth Choice
Returning Triad Elite players have priority by paid seniority
Hotel Information
Room Preference (King or Double)
Smoking or Non-Smoking?
[NAME]?
Any additional information we might need?
Spreadsheet: kevin_presto__20238__EIA411 Reporting Forms Revised 01 30 02
Sheet: Master LR Annual

2002 | SERC |  | U |  | DS
 |  |  |  |  | DW
 |  |  |  |  | NL
 |  |  |  |  | DCSIN
 |  |  |  |  | DCSST
 |  |  |  |  | DCSTI
 |  |  |  |  | DCSLM
 |  |  |  |  | DCSIT
 |  |  |  |  | DCSNI
 |  |  |  |  | DCSTA
 |  |  |  |  | DCSDGG
 |  |  |  |  | DCSOTG
 |  |  |  |  | DCSDGL
 |  |  |  |  | DCSOTL
 |  |  |  |  | DCSTB
 |  |  |  |  | DCST
 |  |  |  |  | DCSIC
 |  |  |  |  | DCSNO
 |  |  |  |  | DCSPU1
 |  |  |  |  | DCSPU2
 |  |  |  |  | DCSPU3
 |  |  |  |  | DCSPU4
 |  |  |  |  | DCSFP
 |  |  |  |  | DCSSA1
 |  |  |  |  | DCSSA2
 |  |  |  |  | DCSSA3
 |  |  |  |  | DCSSA4
 |  |  |  |  | DCSFS
 |  |  |  |  | DCSAJ
 |  |  |  |  | DCSNC
 |  |  |  |  | DCWIN
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | DCWLM
 |  |  |  |  | DCWIT
 |  |  |  |  | DCWNI
 |  |  |  |  | DCWTA
 |  |  |  |  | DCWDGG
 |  |  |  |  | DCWOTG
 |  |  |  |  | DCWDGL
 |  |  |  |  | DCWOTL
 |  |  |  |  | DCWTB
 |  |  |  |  | DCWT
 |  |  |  |  | DCWIC
 |  |  |  |  | DCWNO
 |  |  |  |  | DCWPU1
 |  |  |  |  | DCWPU2
 |  |  |  |  | [NAME]
 |  |  |  |  | DCWPU4
 |  |  |  |  | DCWFP
 |  |  |  |  | DCWSA1
 |  |  |  |  | DCWSA2
 |  |  |  |  | [NAME]
 |  |  |  |  | DCWSA4
 |  |  |  |  | DCWFS
 |  |  |  |  | DCWAJ
 |  |  |  |  | DCWNC
 |  |  |  |  | CSNU
 |  |  |  |  | CSHY
 |  |  |  |  | [NAME]
 |  |  |  |  | CSGE
 |  |  |  |  | CSSTC
 |  |  |  |  | CSSTO
 |  |  |  |  | CSSTG
 |  |  |  |  | CSSTDF
 |  |  |  |  | CSCTO
 |  |  |  |  | CSCTG
 |  |  |  |  | CSCTDF
 |  |  |  |  | CSCCO
 |  |  |  |  | CSCCG
 |  |  |  |  | CSCCDF
 |  |  |  |  | CSOT
 |  |  |  |  | CWNU
 |  |  |  |  | CWHY
 |  |  |  |  | CWPS
 |  |  |  |  | CWGE
 |  |  |  |  | CWSTC
 |  |  |  |  | CWSTO
 |  |  |  |  | CWSTG
 |  |  |  |  | CWSTDF
 |  |  |  |  | CWCTO
 |  |  |  |  | CWCTG
 |  |  |  |  | CWCTDF
 |  |  |  |  | CWCCO
 |  |  |  |  | CWCCG
 |  |  |  |  | CWCCDF
 |  |  |  |  | CWOT
 |  |  |  |  | TLE
 |  |  |  |  | [NAME]
 |  |  |  |  | TLS
 |  |  |  |  | TLT
Spreadsheet: 800970d1666016298-lookup-multiple-criteria-multiple-values
Sheet: Blad1

 | DATASET
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  | 1 | 3 | 5
 | 1 | 100 |  |  |  |  |  |  |  |  | 2 | 101
 | 2 |  |  |  |  |  |  |  |  |  | 4 | 103
 | 3 |  |  |  |  |  |  |  |  |  | 5 | etc
 | 4 |  |  |  |  |  |  |  |  |  | 6 | etc
 | 5
 | 6
 | 7 |  |  |  |  |  |  |  |  |  |  | i want ONLY to lookup the cells in yellow in the dataset and get the result back
 | 8
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 8699 | 5940 | 15164 | 3020
OTHER* | 4248 | 5968 | 244 | 2048
TOTAL | 12947 | 11908 | 15408 | 5068
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: 265992d1379457945-writing-formulas-to-move-data-from-one-worksheet-to-another-jobfile2
Sheet: MES

 | DATE |  |  | [NAME] |  |  | X |  | 2
Spreadsheet: 2ae3a81a-5711-4e3a-854f-058dbe6aa739
Sheet: Summer 2010

Course | Prof |  | Title | Author | 0 | Price | ISBN | Publisher | Quantity
3.530  A Thinkg that Cannot & Can be Changed | Hummel |  | Counseling People With Cancer | Aldredge-Clanton | Required | 22.5 | [PHONE] | Presby
3.530  A Thinkg that Cannot & Can be Changed | Hummel |  | Cancer: A Medical & Spiritual Guide | [NAME] | Required | 13.6 | [PHONE] | Baker Books
6.204 The True Self | Largen |  | New Seeds of Contemplation | Merton | Required | 15.95 | [PHONE] | Norton
6.204 The True Self | Largen |  | Life Together | [NAME] | Required | 11.75 | [PHONE] | Harper
6.204 The True Self | Largen |  | God For Us | LaCugna | Required | 19.95 | [PHONE] | Harper
6.204 The True Self | Largen |  | A Broad Place | [NAME] | Required | 22.95 | [PHONE] | A/F
6.204 The True Self | Largen | Pick 1 of 2 | [NAME]   OR | Thompson | Required | 14.4 | [PHONE] | Preby
6.204 The True Self | Largen | Pick 1 of 2 | Celebration of Discipline | [NAME] | Required | 20.25 | [PHONE] | Harper
6.300  Preaching in the Abrahamic Faith Families | Hedahl |  | The Meaning of the Holy Qur-an | Adbullah | Required | 19.95 | [PHONE] | Amana
6.300  Preaching in the Abrahamic Faith Families | Hedahl |  | [NAME]: Journey to the Heart | Feiler | Required | 11 | [PHONE] | Harper
[NAME] | [NAME] |  | Church on Earth | Wild/Bakken | Required | 9.3 | [PHONE] | A/F
[NAME] | [NAME] |  | Fortress Intro to Lutheranism | Gritsch | Required | 13.6 | [PHONE] | A/F
CTSP  Biblical Proclamation for Preaching & Teaching | Carlson/Stevens |  | Covenant Economics | Horsley | Required | 19.95 | [PHONE] | Presby
CTSP Biblical Proclamation for Preaching & Teaching | Carlson/Stevens |  | Biblical Perspective on Evangelism | Brueggemann | Required | 15.3 | [PHONE] | Abingdon
CTSP  [NAME] for Mission | Cooper-White |  | ELCA Constitution | ELCA | Required | 12.3 | [PHONE] | A/F
CTSP  [NAME] for Mission | Cooper-White |  | One Great Cloud of Witnesses | Almen | Required | 7.95 | [PHONE] | A/F
CTSP  [NAME] for Mission | Cooper-White |  | Church Administration | Cooper-White | Required | 19.95 | [PHONE] | A/F
CTSP  [NAME] for Mission | Cooper-White |  | The Comeback God | Cooper-White | Required | 11.65 | [PHONE] | A/F
Spreadsheet: 84189d1284164524-multi-sheet-multi-table-vlookup-possible-haypi
Sheet: Infantry

# | Wood | Stone | iron | crop
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
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
Spreadsheet: sally_beck__35445__egm_key_employees
Sheet: Sheet1

EGM KEY EMPLOYEES
[NAME] |  |  | Sr. Director |  |  | Operations Mgmt.
[NAME] |  |  | Sr. Director |  |  | Risk Mgmt./Structuring
[NAME] |  |  | Director |  |  | Operations Mgmt.
[NAME] |  |  | Director |  |  | Risk Mgmt./Structuring
[NAME] |  |  | Manager |  |  | Settlements/Trade Accounting
[NAME] |  |  | Manager |  |  | Risk Mgmt.
[NAME] |  |  | Manager |  |  | Risk Mgmt.
[NAME] |  |  | Manager |  |  | Risk Mgmt.
[NAME] |  |  | Manager (UK) |  |  | Risk Mgmt.
[NAME] |  |  | Manager |  |  | Risk Mgmt./Operations
[NAME] |  |  | Manager |  |  | Coordination/Logistics
[NAME] |  |  | Manager (UK) |  |  | Confirmations
[NAME] |  |  | Manager (UK) |  |  | Settlements/Trade Accounting
[NAME] |  |  | Sr. Specialist |  |  | Risk Mgmt.
[NAME] |  |  | Sr. Specialist |  |  | Confirmations
Reno [NAME] |  |  | Specialist |  |  | Risk Mgmt.
[NAME] |  |  | Specialist |  |  | Coordination/Logistics
Ana Rizvi |  |  | Specialist |  |  | Confirmations/Settlements
[NAME] |  |  | Staff |  |  | Settlements
[NAME] |  |  | Staff |  |  | Confirmations/Settlements
Guy Freshwater |  |  | Staff |  |  | Risk Mgmt.
Chantelle Villanueva |  |  | Coord. [NAME].
Sue Foust |  |  | Sr. Admin.
Spreadsheet: 866773d1713695095-debtor-ageing-with-adjustment-of-credit-balance-on-fifo-basis-debtor-ageing-template-1-
Sheet: Debtor ageing template

 | OLD DEBTOR AGEING |  |  |  |  |  |  | DESIRED DEBTOR AGEING
 | Total | 0-30 | 31-60 | 61-90 | 91-120 | >180 |  | New Bal | 0-30 | 31-60 | 61-90 | 91-120 | >180
Case1 |  | 100 | 700 | 400 | -2500 | 1800 |  |  | 100 | 400 | 0 | 0 | 0
Case2 |  | 100 | -200 | -300 | 400 | 1800 |  |  | 100 | 0 | 0 | 400 | 1300
Case3 |  | 100 | -200 | -300 | -1900 | 1800 |  |  | 0 | -200 | -300 | 0 | 0
Case 1
2500 negative balance is adjusted till 31-60 bucket and balance of 400 placed in 31-60 bucket and 0-30 bucket kept as it is since negative 2500 is exhausted in bucket 31-60
Case 2
Positive balance of 1800 in bucket >180 adjusted against 61-90 & 31-60 and balance 1300 kept as it is same bucket. Rest bucket same as it since there is no negative balance to adjust.
Case 3
Balance 1800 in bucket is adjusted in bucket >180 and bucket 0-30. Being balance in 91-120 exhausted, rest bucket kept as it.
Spreadsheet: 144725d1331118270-populate-various-worksheets-from-master-worksheet-testing
Sheet: Master Sheet

Date | Salesperson | Item | Amount
2012-01-02 00:00:00 | [NAME] | 1 Kitchen | 6000
2012-01-02 00:00:00 | [NAME] | 10 Doors | 2500
2012-01-03 00:00:00 | [NAME] | 1 Dining Room | 2500
2012-01-03 00:00:00 | [NAME] | 1 Kitchen | 6550
2012-01-03 00:00:00 | [NAME] | 2 bedrooms | 4300
2012-01-03 00:00:00 | [NAME] | 8 Doors | 2000
2012-01-03 00:00:00 | [NAME] | 2 kitchens | 12050
2012-01-04 00:00:00 | [NAME] | 2 doors | 500
2012-01-04 00:00:00 | [NAME] | 20 doors | 3500
2012-01-04 00:00:00 | [NAME] | 2 dinning rooms | 6100
2012-01-04 00:00:00 | [NAME] | 50 doors | 13000
2012-01-04 00:00:00 | [NAME] | 5 appliances | 3500
2012-01-05 00:00:00 | [NAME] | 3 A'cs | 4200
2012-01-06 00:00:00 | [NAME] | 15 doors | 4250
2012-01-07 00:00:00 | [NAME] | 2 doors | 550
TOTALS |  |  | 71500
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 9 - Table 2

CSD&Nanc Brazil results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 20513.19647466149 | 0 | 0 | 172.8791926305457 | 20686.07566729204 | 0.008427706176562522 | 0.008427706176562548
Net revenue | 2002.805 | 0 | 0 | 54.44300000000021 | 2057.248 | 0.02718337531611925 | 0.02718337531611925
Net revenue/hl | 97.63495428291364 | 0 | 0 | 1.81590498532519 | 99.45085926823883 | 0.01859892288230403 | 0.01859892288230403
[NAME] | -895.807 | -15.179 | 0 | -14.41199999999989 | -925.3979999999999 | 0.0330327849637253 | 0.01608828687429312
[NAME]/hl | -43.6697908639703 | -0.7399626878604479 | 0 | -0.3255560778831637 | -44.73530962971391 | 0.02439944741349143 | 0.007454949324059238
Gross profit | 1106.998 | -15.179 | 0 | 40.03100000000032 | 1131.85 | 0.02244990505854605 | 0.03616176361655606
Gross margin | 0.5527238048636787 | 0 | 0 | 0 | 0.5501767409665729 | -30 | 50
SG&A excl. deprec.&amort. | -368.768 | 0 | 0 | -12.12499999999994 | -380.893 | 0.03287975095452955 | 0.03287975095452952
SG&A deprec.&amort. | -73.27000000000001 | -5.734 | 0 | 5.979000000000005 | -73.025 | -0.003343796915518005 | -0.08160229288931355
SG&A total | -442.038 | -5.734 | 0 | -6.145999999999995 | -453.918 | 0.02687551748944661 | 0.01390378202778945
Other operating income | 76.263 | 0 | 0 | 25.417 | 101.68 | 0.3332808832592475 | 0.3332808832592476
Normalized EBIT | 741.2229999999998 | -20.913 | 0 | 59.30200000000033 | 779.6120000000001 | 0.05179143118872487 | 0.08000561234608256
Normalized EBIT margin | 0.370092445345403 | 0 | 0 | 0 | 0.3789586865560205 | 90 | 190
Normalized EBITDA | 886.751 | 0 | 0 | 50.048 | 936.799 | 0.05643974464082935 | 0.05643974464082928
Normalized EBITDA margin | 0.4427545367621911 | 0 | 0 | 0 | 0.4553651285600958 | 130 | 130
Spreadsheet: 750441d1633452880-how-can-we-skip-value-error-while-calculating-numbers-in-formula-testing
Sheet: Main

USA
2 |  | Xyz |  | Abc |  | 3 |  | 33
3 |  | 2 |  | 1 |  | 1 |  | 21
1 |  | 34 |  | 34 |  | 12 |  | 21
1 |  | 21 |  | 21 |  | 13 |  | 23
12 |  | 56 |  | 12 |  | 34 |  | 43
56 |  | 21 |  | 21 |  | 21 |  | 54
Spreadsheet: 34730d1232045770-add-totals-via-drop-down-menu-tuck-shop
Sheet: Sheet1

 | item 1 | qty | item 2 | qty | item 3 | qty | item 4 | qty | total
mark | chocolate | 3 | sweet | 1 |  |  |  |  |  |  | chocolate | 0.5
dawn |  |  |  |  |  |  |  |  |  |  | crisp | 0.4
debbie |  |  |  |  |  |  |  |  |  |  | sweet | 0.3
jason |  |  |  |  |  |  |  |  |  |  | drink | 0.6
 |  |  |  |  |  |  |  |  |  |  | cookie | 0.7
Spreadsheet: 212579d1360169620-need-help-auto-generate-columns-stafprofile
Sheet: bmi

Name | BMI
 | 4
 | 5
 | 6
Spreadsheet: 676021d1588609683-countif-between-hrs-and-day-us-details-copy
Sheet: Analysis

DAY | SERVICE HRS. |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | 09:00 - 10:00 | 10:00 - 11:00 | 11:00 - 12:00 | 12:00 - 13:00 | 13:00 - 14:00 | 14:00 - 15:00 | 15:00 - 16:00 | 16:00 - 17:00 | 17:00 - 18:00 | 18:00 - 19:00 | 19:00 - 20:00 | 20:00 - 21:00 | 21:00 - 22:00
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL