tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 33719d1230378807-count-annual-issued-items-sample-1-
Sheet: AFTER

Item # | From Bin | Item Description | Qty Issued | Unit Cost
[PHONE] | AFUAA1AA | PREPRINTED FORM, WAREHOUSE REQUISITION | 97 | 25
[PHONE] | AKGBA1AA | WARNING DEVICE KIT, HIGHWAY | 16 | 11.89
[PHONE] | AFJBA1AA | DISK, FLEXIBLE | 82 | 5.05
[PHONE] | C1 | BOX,SHIPPING | 933 | 23.74
[PHONE] | ABSDA1AA | PENCIL, MECHANICAL, 6EA/BX | 26 | 17.53
Item # | From Bin | Item Description | Qty Issued | Unit Cost
[PHONE] | AFUAA1AA | PREPRINTED FORM, WAREHOUSE REQUISITION | 7 | 25
[PHONE] | AKGBA1AA | WARNING DEVICE KIT, HIGHWAY | 9 | 11.89
[PHONE] | AFJBA1AA | DISK, FLEXIBLE | 5 | 5.05
[PHONE] | C1 | BOX,SHIPPING | 15 | 23.74
[PHONE] | ABSDA1AA | PENCIL, MECHANICAL, 6EA/BX | 14 | 17.53
Spreadsheet: cara_semperger__1458__ENA_PGE_DEC22_2001
Sheet: JD-MAL TRANS

From: | EPMI
To: | PGE System Transactions
Date:
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  | Total In To PGE Trans
0100 |  | 24 | 25
0200 |  | 24 | 25
0300 |  | 24 | 25
0400 |  | 24 | 25
0500 |  | 24 | 25
0600 |  | 24 | 25
0700 | 25
0800 | 25
0900 | 25
1000 | 25
1100 | 25
1200 | 25
1300 | 25
1400 | 25
1500 | 25
1600 | 25
1700 | 25
1800 | 25
1900 | 25
2000 | 25
2100 | 25
2200 | 25
2300 |  | 24 | 25
2400 |  | 24 | 25
 | BPA(G) FS | BPA(G) C#23617 & 23622 | BPA(G) [NAME]
 | EPMI(PSE) | EPMI (PSE) | EPMI (PSE)
 | SNPD(PSE) | SNPD(PSE) | SNPD(PSE)
 | BPA(T)BPAP/JD | BPA(T)BPAP/JD | BPA(T)BPAP/JD
 | SNPD(PSE) | SNPD(PSE) | SNPD(PSE)
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | SPP(PSE) | CISO(T)MAL5/NP15 | BPA(PSE)
 | PPW(T) MAL5/MAL 2 | EPMI(PSE) | AEP(PSE)
 | BPA(T)MAL2/HILLTOP | EPMI (L, FS) CISO(CA) | SMUD (PSE)
 | SPP(L, FS) CISO (CA) |  | SMUD(T) MAL5/NP15
 |  |  | SMUD (L, FS) CISO (CA)
Spreadsheet: 802538d1666899918-need-a-specific-formula-to-find-two-different-words-in-a-column-homework
Sheet: Definitions & Functions

Excel Functions
Function | Syntax | Example Input | [NAME] | Example Output | Comments
LEFT | LEFT(text,num_chars) | [NAME] can be useful | LEFT(C3,8)
RIGHT | RIGHT(text,num_chars) | [NAME] can be useful | RIGHT(C4,6)
MID | MID(text,start_num,num_chars) | [NAME] can be useful | MID(C5,10,6)
LEN | LEN(text) | [NAME] can be useful | LEN(C6)
FIND | FIND(find_text,within_text,start_num) | [NAME] can be useful | FIND("u",C7,1) |  | - start_num indicates the digit from where the search should start Note, this formula is case sensitive
 |  | [NAME] can be useful | FIND("u",C8,6)
TRIM | TRIM(text) | formulas can be useful | TRIM(C9) |  | Removes any leading or trailing spaces
Useful Definitions
Part Number | A part number is used to identify all vehicle parts. It consists of 3 elements: Prefix, Base & Suffix. The format of the part number is always: "Prefix-Base-Suffix" The [NAME] is always 4 digits The Base is always 7 digits The Suffix is always 3 or 4 digits
LHS | Left Hand Side
RHS | Right Hand Side
DRIVE | The code "DRIVE" indicates whether the part number is used on LHD or RHD vehicles. DRIVE code "Q" = LHD DRIVE code "P" = RHD
LHD | Left Hand Drive
RHD | Right Hand Drive
BS | Body Style eg. 3 door, 4 door or 5 door
VS | Vehicle Series (low spec, medium spec, high spec)
DRV | Driver
PASS | Passenger
Minor Feature Code | A minor feature code is a 5 digit code. This code defines a specific feature on a vehicle. Multiple minor feature codes can be combined into a string to form a specific vehicle usage for the relevant part
CZQBD | Minor Feature Code defining an 6 Way Driver Seat
CZQBE | Minor Feature Code defining a 4 Way Driver Seat
CZQBH | Minor Feature Code defining an 2 Way Driver Seat
CZQBM | Minor Feature Code defining an 8 Way Driver Seat
CZQBU | Minor Feature Code defining an 10 Way Driver Seat
CZRBC | Minor Feature Code defining a 2 Way Passenger Seat
CZRBE | Minor Feature Code defining a 4 Way Passenger Seat
CZRBL | Minor Feature Code defining a 2 Way Sports Passenger Seat
CZRBT | Minor Feature Code defining an 8 Way Passenger Seat
CZRBV | Minor Feature Code defining a 6 Way Passenger Seat
Spreadsheet: 292b0368-bc9a-4d87-8c40-8a22c989e33e
Sheet: Sheet1

Indicator [NAME] | Smoking in pregnancy
Definition | Percentage smoking in pregnancy
Period | 2008/09
Area | PCT level converted to LA/UA, regional, SHA and national level
Area Boundary Year | 2010
Gender | Female
Population | Women giving birth in 2008/09 with smoking in pregnancy status recorded
Methodology
Measurement Unit | Percentage
Confidence Interval | 0.95
Significance marker | Red = significantly worse than national average, Yellow = not significantly different from national average, green = significantly better than national average
Numerator | Local number per year
Spreadsheet: joe_parks__14713__POSTION05_02
Sheet: X-H_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 151
 |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  | 7.5
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 199541d1355246314-right-most-cell-with-a-value-and-return-column-header-book4
Sheet: Sheet1

Deal | January | February | March | April | May | June | July | August | September | October | November | December | Current month (this is dynamic - can change) | Expected answers | Notes
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
A | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1
B | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 4 | 1
C | 122 | 0 | 0 | 122 | 0 | 0 | 122 | 0 | 0 | 122 | 0 | 0 | 4 | 4
D | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 4 | 4
E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 222 | 0 | 0 | 4 | 10
Spreadsheet: 728829d1618679818-improve-sorting-formula-sort-fix
Sheet: Sheet1

 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 1 | 3 | 5 | 9 | 12 | 13 | 15 | 17 | 18 | 21 | 22 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Before
 | 2 | 1 | 4 | 7 | 11 | 15 | 16 | 19 | 20 | 22 | 24 | 25
 | 2 | 3 | 4 | 7 | 10 | 13 | 16 | 16 | 20 | 20 | 25 | 25
 | 2 | 0 | -3 | 0 | 1 | 7 | 3 | 7 | 17 | 19 | 16 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 5 | 9 | 12 | 13 | 15 | 17 | 18 | 21 | 22 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 4 | 7 | 11 | 15 | 16 | 19 | 20 | 22 | 24 |  |  | After
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 7 | 10 | 13 | 16 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 7 | 16 | 17 | 18 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | The formula in O3 Works but I'm trying to stop at 25 and leave the everything after 24 blank not 0,1,2,3
Spreadsheet: 776599d1649817238-power-query-list-sheet-names-of-original-data-pq-from-sheets-keeping-names
Sheet: Summary

Code | Description | SheetName
018 | Test | Sheet3
 |  | Sheet3
 |  | Sheet3
 |  | Sheet3
 |  | Sheet3
 |  | Sheet3
001 | Bone | Sheet1
002 | dumb dumb | Sheet1
003 | butterfly | Sheet1
004 | leaf | Sheet1
005 | trash | Sheet1
006 | Apple | Sheet2
007 | Orange | Sheet2
008 | Lemon | Sheet2
009 | Lime | Sheet2
010 | [NAME] | Sheet2
011 | Chive | Sheet2
012 | Honey | Sheet3
013 | Onion | Sheet3
014 | Glucose | Sheet3
015 | Fructose | Sheet3
016 | lactose | Sheet3
017 | galactose | Sheet3
Spreadsheet: 870051d1716558892-required-multilevel-sequence-serial-numbers-book11-new-1-
Sheet: Sheet1

 | C Index | C-Title | M-Index | M-Title | CM Index | CM Title |  |  |  | B | D | F
 |  | Area-1 |  | Topic-1 |  | Statement-1
 |  |  |  |  |  | Statement-2 |  |  |  | 1 | 1
 |  |  |  |  |  | Statement-3 |  |  |  | 1 | 1
 |  |  | M - 1.2 | Topic-2 |  | Statement-4 |  |  |  | 1 | 2
 |  |  |  |  |  | Statement-5 |  |  |  | 1 | 2
 |  |  |  |  |  | Statement-6 |  |  |  | 1 | 2
 |  |  |  |  |  | Statement-7 |  |  |  | 1 | 2
 |  |  | M - 1.3 | Topic-3 |  | [NAME] |  |  |  | 1 | 3
 |  |  |  |  |  | Statement-9 |  |  |  | 1 | 3
 | C - 2 | Area-2 | M - 2.1 | Topic-A |  | Statement-10 |  |  |  | 2 | 1
 |  |  |  |  |  | Statement-11 |  |  |  | 2 | 1
 |  |  |  |  |  | Statement-12 |  |  |  | 2 | 1
 |  |  |  |  |  | Statement-13 |  |  |  | 2 | 1
 |  |  | M - 2.2 | Topic-B |  | Statement-14 |  |  |  | 2 | 2
 |  |  |  |  |  | Statement-15 |  |  |  | 2 | 2
 |  |  |  |  |  | [NAME] |  |  |  | 2 | 2
 |  |  |  |  |  | Statement-17 |  |  |  | 2 | 2
 |  |  |  |  |  | Statement-18 |  |  |  | 2 | 2
 |  |  |  |  |  | [NAME] |  |  |  | 2 | 2
 |  |  | M - 2.3 | Topic-C |  | Statement-20 |  |  |  | 2 | 3
 |  |  |  |  |  | Statement-21 |  |  |  | 2 | 3
 |  |  |  |  |  | Statement-22 |  |  |  | 2 | 3
 | C - 3 | Area-3 | M - 3.1 | Topic-X1 |  | Statement-23 |  |  |  | 3 | 1
 |  |  |  |  |  | Statement-24 |  |  |  | 3 | 1
 |  |  |  |  |  | Statement-25 |  |  |  | 3 | 1
 |  |  |  |  |  | Statement-26 |  |  |  | 3 | 1
 |  |  |  |  |  | Statement-27 |  |  |  | 3 | 1
 |  |  | M - 3.2 | Topic-X2 |  | Statement-28 |  |  |  | 3 | 2
 |  |  |  |  |  | Statement-29 |  |  |  | 3 | 2
 |  |  |  |  |  | Statement-30 |  |  |  | 3 | 2
 |  |  |  |  |  | Statement-31 |  |  |  | 3 | 2
 |  |  | M - 3.3 | Topic-X3 |  | Statement-32 |  |  |  | 3 | 3
 |  |  |  |  |  | [NAME] |  |  |  | 3 | 3
 |  |  |  |  |  | Statement-34 |  |  |  | 3 | 3
 |  |  |  |  |  | Statement-35 |  |  |  | 3 | 3
 |  |  |  |  |  | Statement-36 |  |  |  | 3 | 3
 |  |  |  |  |  | Statement-37 |  |  |  | 3 | 3
 |  |  | M - 3.4 | Topic-X4 |  | Statement-38 |  |  |  | 3 | 4
 |  |  |  |  |  | Statement-39 |  |  |  | 3 | 4
 |  |  |  |  |  | Statement-40 |  |  |  | 3 | 4
 |  |  |  |  |  | Statement-41 |  |  |  | 3 | 4
 |  |  |  |  |  | Statement-42 |  |  |  | 3 | 4
 |  |  |  |  |  | Statement-43 |  |  |  | 3 | 4
 | C - 4 | Area-4 | M - 4.1 | Topic-A-1 |  | Statement-44 |  |  |  | 4 | 1
Spreadsheet: 152623d1335455325-find-row-number-which-contains-sample
Sheet: 2011

 |  |  |  |  |  |  |  | Contractual Deliveries April 2012
CO# | Customer Name | Customer PO | Contact | Ln# | [NAME] | [NAME] | ES | Part ID | Description | Part Rev | Project# | Rev | required Ship Date |  | Notes: | Actual Ship Date
123 | pete | 1223485 | [NAME] |  | 3 |  |  | 12345689 | [NAME] |  |  | B | 2012-04-11 00:00:00
124 | [NAME] | 1223445 | [NAME] |  | 3 |  |  | 12347896 | Shoe |  |  | B | 2012-04-11 00:00:00
125 | [NAME] | 1223445 | [NAME] |  | 3 |  |  | 12347896 | Hoe |  |  | B | 2012-04-11 00:00:00 |  |  | 2012-04-09 00:00:00
 | Total Apr 2012 Deliveries
Spreadsheet: 2c010bae-9fbe-46af-b1cc-8800c32a0d75
Sheet: Sheet1

Unnamed: 0 | Netto-Finanzverbindlichkeiten.* | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | in Mio. €, jeweils zum 31.12. | 2008 | 2007 | 2006
 | [NAME] | 34 302 | 32 294 | 36 288
 | Verbindlichkeiten [NAME] | 4 222 | 4 260 | 2 348
 | Verbindlichkeiten gegenüber Nicht-Kreditinstituten  [NAME] | 887 | 690 | 680
 | Derivative finanzielle Verbindlichkeiten | 1 053 | 977 | 562
 | Verbindlichkeiten [NAME] | 2 009 | 2 139 | 2 293
 | Verbindlichkeiten aus ABS-Transaktionen | 0 | 0 | 1 139
 | Andere finanzielle Verbindlichkeiten | 974 | 502 | 377
 | Brutto-Finanzverbindlichkeiten | 43 447 | 40 862 | 43 687
 | Zahlungsmittel und [NAME] | 3 026 | 2 200 | 2 765
 | [NAME]
 | Available-for-Sale/Held for Trading | 101 | 75 | 122
 | Derivative finanzielle Vermögenswerte | 1 598 | 433 | 359
 | Andere finanzielle Vermögenswerte | 564 | 918 | 886
 | Netto-Finanzverbindlichkeiten | 38 158 | 37 236 | 39 555
* | Die Kennzahl „Netto-Finanzverbindlichkeiten“ wird [NAME] [NAME] als eine wichtige
 | Kenngröße [NAME], Analysten und [NAME] verwendet. Sie ist im
 | Wettbewerbsumfeld der [NAME] üblich. Die Definition der [NAME] jedoch
 | bei anderen Unternehmen abweichend sein.
Spreadsheet: 93366d1292957086-excel-2007-track-annual-training-training-20stats-20-testing-20purposes-1-
Sheet: S4

 |  |  |  |  | RIFLE RANGE |  | PHYSICAL FITNESS TEST |  | COMBAT FITNESS TEST |  | GAS CHAMBER | [NAME] | MCMAP TRAINING |  | SWIM QUAL
SECTION | RANK | LNAME | FNAME | MI | DATE | SCORE | DATE | SCORE | DATE | SCORE | DATE | DATE | DATE | BELT | DATE | CLASS
MT | 2ndlt | JONES | [NAME] | T | 2010-06-04 00:00:00 | 301 | 2010-02-26 00:00:00 | 260 | 2009-10-30 00:00:00 | 266 | 2010-01-29 00:00:00 |  | 2009-05-20 00:00:00 | TAN
MT | cpl | SMITH | TOM | T | 2010-01-22 00:00:00 | 297 | 2010-02-26 00:00:00 | 205 | 2010-10-22 00:00:00 | 266 | 2010-02-11 00:00:00 |  | 2009-04-02 00:00:00 | TAN
MT | cpl | EVANS | [NAME] | T | 2010-08-27 00:00:00 | 266 | 2010-02-26 00:00:00 | 284 | 2010-11-10 00:00:00 | 291 | 2010-10-29 00:00:00 |  | 2009-06-10 00:00:00 | black
MT | sgt | RODRIGUEZ | TOM | T | 1999-11-01 00:00:00 | 343 | 2010-04-29 00:00:00 | 255 | 2010-10-06 00:00:00 | 288 | 2009-12-17 00:00:00 |  | 2002-09-17 00:00:00 | TAN
MT | maj | STEVENS | [NAME] | T | 1999-11-02 00:00:00 | 289 | 2010-04-30 00:00:00 | 255 | 2010-10-07 00:00:00 | 288 | 2009-12-18 00:00:00 |  | 2010-11-17 00:00:00 | TAN
MT | [NAME] | GOMEZ | TOM | T | 2010-08-27 00:00:00 | 289 | 2010-06-25 00:00:00 | 184 | 2009-09-28 00:00:00 | W | 2010-03-19 00:00:00 |  | 2009-06-19 00:00:00 | GRAY
MT | ssgt | WERTH | [NAME] | T | 2010-01-22 00:00:00 | 313 | 2010-02-26 00:00:00 | 241 | 2010-11-10 00:00:00 | 249 | 2010-02-11 00:00:00 |  | 2009-09-16 00:00:00 | BROWN
MT | [NAME] | HATMAKER | TOM | T | 2010-08-27 00:00:00 | 272 | 2010-04-07 00:00:00 | 216 | 2010-10-06 00:00:00 | 253 | 2010-10-29 00:00:00 |  | 2008-03-19 00:00:00 | GRAY
MT | [NAME] | ORAGAMI | [NAME] | T | 2010-08-27 00:00:00 | 322 | 2010-02-26 00:00:00 | 265 | 2010-10-06 00:00:00 | 298 | 2010-01-29 00:00:00 |  | 2009-04-15 00:00:00 | TAN
MT | gysgt | KTM | TOM | T | 2010-08-28 00:00:00 | 322 |  |  | 2010-10-07 00:00:00 |  | 2010-01-30 00:00:00 |  | 2009-04-16 00:00:00 | TAN
MT | [NAME] | SUZUKI | [NAME] | T | 2009-08-28 00:00:00 | 315 | 2009-06-29 00:00:00 | 0 | 2010-10-22 00:00:00 | 279 | 2010-10-29 00:00:00 |  | 2008-12-23 00:00:00 | GREEN
MT | [NAME] | HONDA | TOM | T | 2000-11-01 00:00:00 | S30 | 2010-06-29 00:00:00 | 164 | 2009-12-16 00:00:00 | 232 | 2009-11-02 00:00:00 |  | 2003-12-04 00:00:00 | GREEN
MT | [NAME] | YAMAHA | [NAME] | T | 2010-09-03 00:00:00 | 312 | 2010-02-26 00:00:00 | 230 | 2010-10-22 00:00:00 | 288 | 2010-03-19 00:00:00 |  | 2004-07-30 00:00:00 | TAN
 |  |  | Completed
 |  |  | Needed
Officers |  |  |  |  |  |  | [NAME] DOWN |  |  |  |  |  |  | TOTAL
SNCO |  |  |  |  |  |  | RANK | TAN | GRAY | GREEN | BROWN | BLACK | N/A | MARINES
NCO'S |  |  |  |  |  |  | OFFICERS
[NAME] AND BELOW |  |  |  |  |  |  | SNCO's
TOTAL |  |  |  |  |  |  | NCO's
 |  |  |  |  |  |  | NON-NCO's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: SITHE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 4268294 | 12915061
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 4732675 | 16345043
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 9000969 | 29260104
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -2295790 | -8157428 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -7049837 | -22493953
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 23229 | 71329
 | Total Purchases: |  | -9322398 | -30580052
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 340865 | 1277954
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 340865 | 1277954
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -19436 | -58735.592
 |  |  | 0 | 0
23 | Fuel: |  | -23229 | -71329
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -16785
25 |  | Demand | 0 | -7370
 | Total Transport Expense: |  | 0 | -24155
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 1740930.2027
31 |  | Prior Month Book Balance | 0 | 102642
 |  | Total MTM Income | 0 | 1843572.2027
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -1429259
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 100000
 |  | TOTAL INTRA-MTH
Spreadsheet: 777254d1650285947-timesheets-help-timesheets-help-example
Sheet: TechHrs

 | PAYROLL PERIOD: | 2022-03-14 00:00:00 |  |  | THRU
Tech # | Employee Name | MON | TUE | WED | THR | FRI | SAT | SUN | Total Hours
1 | Employee 1 | 9.1 | 10.48333333333333 | 0.4166666666666667 | EAB | 9.549999999999999
2 | Employee 2 | 8 | 7.616666666666666 | 8.266666666666666 | 9.366666666666667 | 6.200000000000001
3 | Employee 3 | 7.9 | 8.683333333333334 | 7.616666666666666 | 9.116666666666667 | 6.600000000000001 | 2
4 | Employee 4 | 10.71666666666667 | 10 | 9.933333333333334 | 10.38333333333333
6 | Employee 5 | USD | 8.100000000000001 | 9.783333333333333 | 9.200000000000001 | 8.2 | 7.1
23
24
25
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Viasat (Sweden)

Viasat (Sweden)
Date | Channel | Start (CET) | End (CET) | Notes
2010-11-21 00:00:00 | [NAME] | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-21 00:00:00 | TV10 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | [NAME] | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | TV10 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | TV10 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | TBC | 21:00 (TBC) | 23:00 (TBC) | Round [NAME] (Singles)*
2010-11-24 00:00:00 | TV10 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | TBC | 21:00 (TBC) | 23:00 (TBC) | Round [NAME] (Singles)*
2010-11-25 00:00:00 | [NAME] | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | TV10 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | [NAME] | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | TV10 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | TV10 | 18:25:00 | 21:00:00 | Semi-Final 1 - Live (Singles)
2010-11-27 00:00:00 | TV10 | 21:00:00 | 23:30:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | TV10 | 18:30:00 | 21:30:00 | Singles Final - Live
*Depends on Champions League scheduling
Spreadsheet: 39350d1237498036-hiding-rows-using-if-statements-example
Sheet: client sheet

Client Name | Industry | Opportunity Description | Comments | Chance
Name 1 | Industry 1 | xxx | xxx | 1
Name 2 | Industry 2 | xxx | xxx | 1
Name 3 | Industry 3 | xxx | xxx | 1
Name 4 | Industry 4 | xxx | xxx | 1
Name 5 | Industry 5 | xxx | xxx | 2
Name 6 | Industry 6 | xxx | xxx | 2
Name 7 | Industry 7 | xxx | xxx | 3
Name 8 | Industry 8 | xxx | xxx | 3
Name 9 | Industry 9 | xxx | xxx | 3
 |  |  |  |  |  | if column E's value is greater than 3 or less than 2 I don't want it to show up on the next page
Spreadsheet: 91929d1291631331-apply-the-best-formula-from-all-group-sheets-bom-nov2010
Sheet: MAT COST-HHD

Summary of material cost
Model | CNDKDRKCC | CNDKDRKSC | CNDKDRSCC | CNDKDRSSC | Avg/Veh. | Total Amount
Prod.Qty | 18412 | 15060 | 15627 | 5563
CKD
Local
E.Oil
Paint Cost
Steel
TOTAL MATERIAL COST
Spreadsheet: 84733d1284732208-excel-2007-automatically-counting-items-in-a-list-pt1
Sheet: Sheet1

Part # | Qty
AB-100 | 5
AB-101 | 6
AB-102 | 7
AB-103 | 8
AB-104 | 9
AB-105 | 10
AB-106 | 11
AB-107 | 12
AB-100 | 5
AB-101 | 6
AB-102 | 7
AB-103 | 8
AB-104 | 9
AB-105 | 10
AB-106 | 11
AB-107 | 12
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: SFR Conv & FHA

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
Submit to Underwriting |  | True | False | Team Rosa | Submit to Underwriting
Conditional Approval |  | True | False | Team Rosa | Conditional Approval
[NAME] |  | True | False | Team Rosa | [NAME] | _x000D_
Submit Conditions |  | True | False | Team Rosa | Submit Conditions
CD |  | True | False | Team Rosa | CD
Final Approval |  | True | False | Team Rosa | Final Approval
[NAME] CD |  | True | False | Team Rosa | [NAME] CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
KOT Initial |  | True | False | Team Rosa | KOT Initial
KOT Resubmit |  | True | False | Team Rosa | KOT Resubmit
Spreadsheet: bab88424-ca21-49b7-b103-0bad9e0ada4f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2873 | 6956 | Adelaide | Cappellini | ITA | 128 | 00:13:18 | 00:00:44 | 00:40:28 | 00:01:22 | 00:30:06 | 1 | 01:25:58
2873 | 15578 | [NAME] | Kerr | USA | 129 | 00:15:07 | 00:01:04 | 00:41:40 | 00:02:09 | 00:32:50 | 2 | 01:32:50