tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 18

Product* | November 29 | December 6 | December 13 | December 20 | December 27
Total** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Non-Deliverable Forwards | N/A | N/A | N/A | N/A | N/A
Options | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaps | N/A | N/A | N/A | N/A | N/A
OTHER | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, December 27 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: e135d089-81eb-4b96-a7ac-69610657ec17
Sheet: Sheet1

Digikey | Quantity | RefDes | Number of [NAME] | Pattern | Manufacturer | Digikey description | Unnamed: 7
102-1155-ND | 1 | SPKR | 2 | SPKR KC-1206 | CUI CEM-1206S | BUZZER 2.4KHZ 12MM PC MOUNT
160-1426-1-ND | 2 | L1, PWR | 2 | CD0805 | Lite-on | LED GREEN CLEAR THIN 0805 SMD
160-1427-1-ND | 1 | L3 | 2 | CD0805 | Lite-on | LED SUPER RED CLR THIN 0805 SMD
160-1428-1-ND | 5 | L, L2, RSSI, RX, TX | 2 | CD0805 | Lite-on | LED YELLOW CLEAR THIN 0805 SMD
24LC512-I/SN-ND | 1 | U4 | 8 | SO08 | Microchip | IC EEPROM 512KBIT 400KHZ 8SOIC | Optional - could use larger/faster? r 24FC1025-I/SM-ND
277-1860-ND | 1 | J2 | 4 | 277-1860-ND | Phoenix Contact | CONN TERM BLOCK T/H 4POS 3.5MM
399-1168-1-ND | 16 | C1, C2, [NAME], C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C18 | 2 | CAP_0805 | Kemit | [NAME] .10UF 25V CERAMIC X7R 0805
495-2236-1-ND | 1 | C23 | 2 | CAP_1206 | Kemit | CAP TANT 10UF 16V 10% 1206
BAV16W-FDICT-ND | 1 | D1 | 2 | SOD-123 | Diodes | DIODE SWITCH 75V 400MW SOD-123
BSS138CT-ND | 1 | U3 | 3 | SOT23-3 | [NAME] | MOSFET N-CH 50V 220MA SOT-23 | MOSFET-NCHANNELSMD
EG2510-ND | 4 | A, B, C, RESET1 | 2 | MOU506-FSCM | E-Switch | SWITCH TACT 6X3.5MM H=4.3MM 130G
MCP1700T3302ETTCT-ND | 1 | U2 | 3 | SOT23 | Microchip | IC REG LDO 3.3V 250MA SOT23-3 | MCP1700_TT
MMBT6428TR-ND | 1 | Q1 | 3 | SOT-23 | [NAME] | TRANSISTOR GP NPN AMP SOT-23
RR12P1.0KDCT-ND | 6 | R5, R6, R7, R13, R14, R16 | 2 | RES_0805 | [NAME] | RES 1.0K OHM 1/10W .5% 0805 SMD
RR12P10.0KDCT-ND | 6 | R3, R4,  R17, R18, R19, R20 | 2 | RES_0805 | [NAME] | RES 10.0K OHM 1/10W .5% 0805 SMD
RR12P30.0KDCT-ND | 2 | R1, R2 | 2 | RES_0805 | [NAME] | RES 30.0K OHM 1/10W .5% 0805 SMD
RR12P390DCT-ND | 3 | R9, R10, R11, R15 | 2 | RES_0805 | [NAME] | RES 390 OHM 1/10W .5% 0805 SMD
RR12P4.7KDCT-ND | 3 | R8, R21, R22 | 2 | RES_0805 | [NAME] | RES 4.7K OHM 1/10W .5% 0805 SMD
RR12Q49.9DCT-ND | 1 | R12 | 2 | RES_0805 | [NAME] | RES 49.9 OHM 1/10W .5% 0805 SMD
Sparkfun: PRT-09279 | 10 | JA0-15, JA0-7, JD0-7, [NAME], JSER, [NAME], JD23-53O=2 | 8 |  |  | Stackable header 8 pin | 1 to cut up into smaller
Sparkfun: PRT-09280 | 1 | JPWR | 6 |  |  | Stackable header 6 pin
????? | 1 | ISP |  |  |  | Stackable ISP header >>> | Don't use with XBEE…
Sparkfun: PRT-08272 | 2 | [NAME] | 10 |  |  | 2mm 10pin XBee Socket
A26508-02-ND | 5 | J5V, JGND, JPANEL, VS=VL, VS1=VS2 | 2 | HDR-1X2 |  | CONN HEADR BRKWAY .100 02POS STR
A26508-03-ND | 12 | [NAME], [NAME], JCN11, JCN12, [NAME], JCN3, JCN4, JCN5, JCN6, JCN7, [NAME], JCN9 | 3 | HDR-1X3 | TE Connectivity | CONN HEADR BRKWAY .100 03POS STR
A26508-04-ND | 13 | CN1S, CN1S1, CN2S, CN2S1, CN3S, CN4S, CN5S, CN6S, CN7S, CN8S, CN9S, CNPS2S, CNSerGnd | 4 | HDR-1X4 | TE Connectivity | CONN HEADR BRKWAY .100 04POS STR
A34268-02-ND | 1 | (JXBEE_INOUT/USART) | 4 | HDR-2X2 | TE Connectivity | CONN HEADR BRKWAY .100 04POS STR
A34268-04-ND | 13 | CN1GP, CN1GP1, CN2GP, CN2GP1, CN3GP, CN4GP, CN5GP, CN6GP, CN7GP, CN8GP, CN9GP, CNSerRT, PS2P | 8 | HDR-2x4 | TE Connectivity | CONN HEADR BRKWAY .100 08POS STR
S9001-ND | 16 | shunts to choose power… |  |  |  | CONN JUMPER SHORTING GOLD FLASH
Spreadsheet: 50184d1249567379-lists-and-drop-down-menus-resident-options-worksheet
Sheet: FHCH - Facility Price List

 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-04 00:00:00
INDEPENDENT LIVING UNITS AND FEES
PRICES EFFECTIVE 7/1/09
 |  |  |  |  |  |  |  |  |  |  | 80% Refund | 50% Refund | No Refund
 |  |  |  |  |  |  |  |  | Monthly |  | Option | Option | Option
 |  | Housing | Unit | Pathlinks | Detailed | Square | Entrance |  | Rental |  | Monthly | Monthly | Monthly
Campus ID | Campus | Type | Number | Description | Description | Footage | Fee |  | Rate |  | Service Fee | Service Fee | Service Fee
GARDEN HOMES
4 | FHCH | GH | 1210 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1212 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1230 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1232 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1250 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1252 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1270 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1272 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1290 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
4 | FHCH | GH | 1292 | Apartments | 2 bedroom deluxe | 1258 | 95500 |  | 1165 |  | 976 | 706 | 258
Spreadsheet: 494713d1482630615-how-i-get-spare-and-active-excel-help_1167377
Sheet: Sheet2

Status | Driver Name
Active | Alonzo
 | Blaze
 | [NAME]
 | Case
 | [NAME]
 | Gunnar
 | Hugh
 | [NAME]
 | Pablo
 | Romeo
 | Tristin
 | Tyshawn
 | Westom
Spare | [NAME]
 | Dashawn
 | Esteban
 | [NAME]
 | [NAME]
 | Landym
 | Leonel
Spreadsheet: 119321d1314312071-conditional-sort-or-filter-help
Sheet: Sheet1

Sort: Actual Provider | Patient First Name | Patient Last Name | Patient DOB | Procedure Code | Diag Code 1 | Vch Service Date | Row #
 | =[NAME] |  |  |  |  | 2010-11-10 00:00:00
 | =[NAME] |  |  |  |  | 2010-11-10 00:00:00 |  | This is my sort
 | =[NAME] |  |  |  |  | 2010-12-20 00:00:00
 | =[NAME] |  |  |  |  | 2011-02-14 00:00:00
 | =[NAME] |  |  |  |  | 2011-01-12 00:00:00
 | =[NAME] |  |  |  |  | 2010-12-20 00:00:00
 | =Amanda |  |  |  |  | 2010-12-08 00:00:00
Sort: Actual Provider | Patient First Name | Patient Last Name | Patient DOB | Procedure Code | Diag Code 1 | Vch Service Date | Row #
 | Alicia |  |  |  |  | 2010-12-08 00:00:00 | 235
 | Alicia |  |  |  |  | 2011-02-16 00:00:00 | 251 | These are my results, notice that the Vch Service Dates don't match my search
 | Alicia |  |  |  |  | 2010-12-02 00:00:00 | 335
 | Alicia |  |  |  |  | 2010-12-02 00:00:00 | 336
 | [NAME] |  |  |  |  | 2011-02-02 00:00:00 | 354
 | [NAME] |  |  |  |  | 2011-02-08 00:00:00 | 355
 | Amanda |  |  |  |  | 2011-02-17 00:00:00 | 358
Spreadsheet: 96993d1296214865-sorting-puting-items-in-a-table-based-on-the-values-from-another-table-boo
Sheet: Sheet1

[PHONE]-AB | 0 | 0 | 0 | 0 | 0
305548520D52-AB | 250 | 250 | 250 | 250 | 250
305566520GNR-AA | 0 | 0 | 0 | 0 | 0
305566520GNR-AB | 70 | 70 | 70 | 70 | 70 |  |  |  |  |  | high runners | >500/week
305566520GNR-AC | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
305583720T18-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
305657920F82-AA | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | Low runners | <501/week
305659520F82-AA | 0 | 0 | 0 | 0 | 0
305665820E82-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0
[PHONE]-AC | 990 | 490 | 490 | 490 | 490
Spreadsheet: 455962d1460575297-assign-points-based-on-place-finished-in-race-grantalias-bsb-
Sheet: Sheet1

Position | Points
1 |  |  |  |  |  |  |  | < Col F uses a formula to show only
2 |  | < [NAME] col B |  |  |  |  |  | numbers up to the [NAME] participants
3 |  | looks up the points in col G |  |  |  |  |  | listed in col A
4 |  | based on the position in Col F
5 |  |  |  |  |  |  |  | << Col G uses a formula to reverse the
6 |  |  |  |  |  |  |  | numbers in col [NAME]
7
8
9 |  |  |  |  |  |  |  | All formulas are copied down to the end
10 |  |  |  |  |  |  |  | of the highlighted sections but can
11 |  |  |  |  |  |  |  | easily be dragged down further if need be.
12
13
Spreadsheet: 376723d1423688189-search-for-text-in-a-text-string-search-for-text-in-a-text-string-excel-forum-2-11-15
Sheet: Sheet1

Available Brands | Customer Requests | What Brand is Available for a Customer?
Brand1 | B9 Blue
Brand2 | Brand1 Blue
Brand3 | Brand1 [NAME]
Brand4 is another one | Brand1 Grey
Brand5 | Brand1 Red
Brand678910111213 | Brand1 White
Brand7 | Brand10 Black
Brand8 | Brand10 Brown
B9 | Brand11 Black
Brand10 | Brand11 Blue
 | [NAME]
 | Brand14 Green
 | [NAME]
 | Brand16 Black
 | Brand16 Purple
 | Brand17 Red
 | Brand18 Purple
 | Brand19 White
 | Brand2 Black
 | Brand2 Blue
 | Brand2 [NAME]
 | Brand2 Red
 | [NAME]
 | Brand3 Green
 | Brand3 [NAME]
 | Brand3 Purple
 | Brand4 [NAME]
 | Brand4 Green
 | Brand4 is another one Aqua
 | Brand4 is another one [NAME]
 | Brand5 Blue
 | Brand5 Pink
 | Brand6 Green
 | Brand678910111213 White
 | Brand7 Green
 | Brand8 Grey
 | Brand8 Purple
 | Brand9 [NAME]
Spreadsheet: 192408d1352398006-dimension-volume-conversion-from-mm-to-in-book1
Sheet: Sheet1

Dimensions (mm) | Dim1 | Dim2 | Dim3 | Dimensions (in³) | Direct > | Dimensions (in³) | [NAME] > | Dimensions (in³)
56.4 X 387.2 X 545.3mm | 56.4 | 387.2 | 545.3 | 726.6893583865908 |  | 726.6893583865908 |  | 726.6893583865908
51.5x292.x475.1mm | 51.5 | 292 | 475.1 | 435.9874227622472 |  | 435.9874227622472 |  | 435.9874227622472
51.5x312.5x508mm | 51.5 | 312.5 | 508 | 498.9072478144957 |  | 498.9072478144957 |  | 498.9072478144957
37.50mm*339.20mm*547.80[NAME] | 37.5 | 339.2 | 547.8 | 425.2144252320001 |  | 425.2144252320001 |  | 425.2144252320001
53 X 318.3 X370mm | 53 | 318.3 | 370 | 380.901850386378 |  | 380.901850386378 |  | 380.901850386378
Spreadsheet: fletcher_sturm__10949__shag
Sheet: Sheet1

 | 0 | 55.25
 | 0 | 223
 | 0 | 43.5625
 | 0 | 225.875
 | 0 | 24.1875
 | 0 | 3.25
 | 0 | 47.4375
 | 0 | 49.4375
 | 0 | 24.25
 | 0 | 16.1875
 | 0 | 142.8125
 | 0 | 118.75
 | 0 | 13.125
 | 0 | 13.125
 | 0 | 13.125
 |  |  | -53452 | 0
 |  |  |  |  |  |  |  |  | Top Holdings
Long
AIG | 500 | 83.75 |  |  | -0.6875 |  |  |  | JDSU | 500 | 235.5
BRKA | 1 | 48550 |  |  | -3100 |  |  |  | EGHT | 5000 | 20
GLW | 250 | 188.875 |  |  | 0.125 |  |  |  | CEI | 5000 | 16.3125
CEI | 5000 | 16.625 |  |  | 0.1875 |  |  |  | QCOM | 500 | 146.875
EGHT | 5000 | 20 |  |  | 0 |  |  |  | BRKA | 1 | 49100
ENMD | 100 | 72.5 |  |  | 1.8125 |  |  |  | GLW | 250 | 188.25
GBLX | 500 | 47.375 |  |  | 0.5 |  |  |  | AIG | 500 | 85.5
GLBL | 2000 | 9.875 |  |  | 0.15625 |  |  |  | SFE | 250 | 156.8125
JDSU | 500 | 245 |  |  | 14.375 |  |  |  | NXLK | 250 | 117.25
LSI | 500 | 57 |  |  | -1.0625 |  |  |  | LSI | 500 | 58.0625
MER | 200 | 94.5 |  |  | 3.4375 |  |  |  | GBLX | 500 | 48.3125
NXLK | 250 | 111 |  |  | -5.875 |  |  |  | GLBL | 2000 | 9.84375
QCOM | 500 | 135.75 |  |  | -10.25 |  |  |  | MER | 200 | 93.5
SFE | 250 | 150.375 |  |  | -3.1875 |  |  |  | ENMD | 100 | 72.375
cash |  | 1
 |  | 625538.625
Short
WCG | -2000 | 41.625 |  |  | -1.3125
Spreadsheet: c267ba12-dc47-4812-b81d-e570e84c0be3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Roster Directions: | 1. Coach should fill out all cells that are highlighted in yellow. Add or delete lines as needed.
 | 2. It is [NAME] MANDATORY for all players and coaches to be current US Lacrosse Members.
Due April 23rd, 2010! | 3. Providing the First & Last Name, USL Member #, DOB and ZIP (zip code where USL membership resides)is the PERTINENTinfo that is needed for EASY and FAST verification.
 | 4. All other info is needed for the official event program. The more complete information provided, the more accurate your team profile page will be in the program.
 | 5. Once complete, save to your computer, and upload on the team registration & payment online registration form. (or email to [EMAIL] )
 | 6. Thank you for your cooperation in filling out this roster as accurately and as complete as possible!
Your Team Name (Univ. of ABC) | First Name | Last Name | USL Member # | DOB | ZIP | Jersey # | Position | Year | Hometown | High School
COACH
COACH
COACH
COACH
Example: PLAYER | [NAME] | Smith | 123456 | 1991-03-22 00:00:00 | 21210 | 7 | Attack | Junior | Baltimore, MD | Arundel
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
PLAYER
Spreadsheet: 43424d1242092403-counting-multple-criteria-in-multiple-cells-green
Sheet: Sheet1

 | RED |  |  | BLUE |  |  | GREEN |  |  | RED | ▲ |  |  |  | RED |  |  | BLUE |  |  | GREEN
 |  |  |  |  |  |  |  |  |  |  | △
MrA | ◎ | ☆ | ◇ | ◎ | ☆ | ● | ◎ | ☆ |  |  | ◎ |  |  | MrA
MrB |  |  |  |  |  | ● | ◎ | ■ |  |  | □ |  |  | MrB
MrC | ▲ | ■ | ◇ | ○ | ■ | ● | ○ | ■ |  |  | ■ |  |  | MrC
MrD | ▲ | □ | ◆ | ◎ | □ | ● | ◎ | □ |  |  | ★ |  |  | MrD
MrE | ▲ | ■ | ※ | ◎ | ■ | ● | ◎ | ■ |  |  | ☆ |  |  | MrE
MrF | ▲ | □ | ◆ | ○ | □ | ● | ○ | □ |  |  | → |  |  | MrF
MrG |  |  |  | ○ | □ | ● | ○ | □ |  |  | ◆ |  |  | MrG
MrH | ▲ | □ | ◆ | ◎ | □ | ● | ◎ | □ |  |  | ◇ |  |  | MrH
MrI | ▲ | □ | ◆ | ○ | □ | ● | ○ | □ |  |  | ※ |  |  | MrI
MrJ | ▲ | ■ | ◆ | ◎ | ■ | ● | ◎ | ■ |  | BLUE | [NAME] |  |  | MrJ
MrK | ▲ | □ | ◆ | ◎ | □ | ● | ◎ | □ |  |  | ○ |  |  | MrK
MrL | △ | □ | ◆ | ○ | □ | ● | ○ | □ |  |  | ◎ |  |  | MrL
MrM | ▲ | □ | ◇ | ◎ | □ | ● | ◎ | □ |  |  | □ |  |  | MrM
MrN | ▲ | □ | ◆ | ○ | □ | ● | ○ | □ |  |  | ■ |  |  | MrN
MrO | ▲ | □ | ◆ | ○ | □ | ● | ○ | □ |  |  | ★ |  |  | MrO
MrP | ▲ | □ | ◆ | ○ | □ | ● | ○ | □ |  |  | ☆ |  |  | MrP
MrQ |  |  |  | ○ | □ | ● | ○ | □ |  |  | → |  |  | MrQ
MrR | ▲ | ■ | ◆ | ◎ | ■ | ● | ◎ | ■ |  |  | ● |  |  | MrR
MrS | ▲ | □ | ※ | ○ | □ | ● | ○ | □ |  | GREEN | ↓ |  |  | MrS
MrT | ▲ | ＆ | ※ | ○ | ＆ | ● | ○ | ＆ |  |  | [NAME] |  |  | MrT
MrU | ▲ | □ | ◆ | ○ | □ | ● | ○ | □ |  |  | ○ |  |  | MrU
MrV | ▲ | ■ | ◆ | ◎ | ■ | ● | ◎ | ■ |  |  | ◎ |  |  | MrV
[NAME] | ◎ | ★ | ◆ | ◎ | ★ | ● | ◎ | ★ |  |  | □ |  |  | [NAME]
MrX | ▲ | □ | ◇ | ○ | □ | ● | ○ | □ |  |  | ■ |  |  | MrX
MrY | ▲ | □ | ◆ | [NAME] | □ | ● | [NAME] | □ |  |  | ★ |  |  | MrY
MrZ | ▲ | ★ | ※ | ◎ | ★ | ● | ◎ | ★ |  |  | ☆ |  |  | MrZ
MrAA | ▲ | □ | ◆ | ◎ | □ | ● | ◎ | □ |  |  | → |  |  | MrAA
MrAB | ▲ | ℃ | ◆ | ○ | ℃ | ● | ○ | ℃ |  |  |  |  |  | MrAB
Spreadsheet: 268316d1380562074-convert-text-to-time-example
Sheet: Sheet1

% Busy Time | % Ready Time | % Not Ready Time | % Wrap Time | % Unknown State Time | Busy Time | Ready Time | Not Ready Time | Wrap Time | Unknown State Time
0.5114539125619963 | 0.3249298585015548 | 0.02537586052054952 | 0.1382386802931931 | 1.688122706263273e-06 | 84:09:32 | 53:28:00 | 03:34:34 | 22:44:49 | 00:00:01
0.4682971206126896 | 0.3930049858604664 | 0.01812575369708253 | 0.1205721398297614 | 0 | 73:47:00 | 61:55:14 | 02:51:21 | 18:59:49 | 00:00:00
0.4761638455463297 | 0.3490853593459839 | 0.02957160238212128 | 0.1451791927255651 | 0 | 61:57:58 | 45:25:43 | [NAME] | 18:53:35 | 00:00:00
0.5007320727737382 | 0.3415775502753354 | 0.02168646749216587 | 0.1360039094587605 | 0 | 73:08:57 | [NAME] | 03:10:05 | 19:52:05 | 00:00:00
0.4981588929695064 | 0.35820336928623 | 0.02066144637368316 | 0.1229762913705804 | 0 | 57:18:34 | 41:12:31 | 02:22:37 | 14:08:51 | 00:00:00
0.3456109579888081 | 0.5443763619659385 | 0.009035481348184932 | 0.1009771986970684 | 0 | 25:17:16 | 39:49:52 | 00:39:40 | 07:23:18 | 00:00:00
 |  |  |  |  | Busy Time | Ready Time | Not Ready Time | Wrap Time | Unknown State Time
Spreadsheet: 599800d1543318380-columns-with-duplicates-to-one-column-and-rows-help-book1-1-
Sheet: Sheet1

A | 1
A | 2
A | 3
A | 4
A | 5
A | 6
B | 7
B | 8
C | 9
C | 10
C | 11
C | 12
C | 13
C | 14
Spreadsheet: 216083d1361576037-convert-fraction-to-a-decimal-convert-fraction-to-a-decimal
Sheet: Sheet1

Ad Size | Decimal Number
 |  |  | We sell ads in a monthly magazine.
1/8 |  |  | We sell ad sizes that are either:
1/2
full |  |  | Full or full | = | 1
1/2 |  |  | 1/2 | = | 0.5
1/2 |  |  | 1/4 | = | 0.25
1/4 |  |  | 1/8 | = | 0.125
1/2 |  |  | Out or out | = | 0
Full
1/2
1/4
1/2 |  |  | What I would like to know is how
out |  |  | to convert the fraction to a
1/2 |  |  | decimal in a separate column
1/4 |  |  | and then I can sum the decimals column at the end.
1/4
1/8
1/8
1/8
Out
1/4
1/2
1/2
1/4
Total | 0
Pages
Spreadsheet: 21168d1208349736-excel-reference-conslidate-report-help-example
Sheet: RAW_DATA

PART | KEY | [NAME] | RATE | LOCATION_ID | STATUS | DATE
1234 | LK92 | KROK1 | 12 | KROK127 | ACTIVE | 2008-03-03 00:00:00
1234 | LK92 | KROK1 | 12 | KROK622 | ACTIVE | 2008-03-03 00:00:00
1234 | LK92 | SERVER1 | 12 | SERVER1 | ACTIVE | 2008-03-03 00:00:00
12309 | LK92 | KROK1 | 12 | KROK123 | ACTIVE | 2008-04-02 00:00:00
12309 | LK92 | KROK1 | 12 | KROK629 | ACTIVE | 2008-04-02 00:00:00
12309 | LK92 | KROK_OFFSITE | 12 | KROK123 | MISSING | 2008-04-02 00:00:00
12309 | LK92 | [NAME] | 12 | [NAME] | ACTIVE | 2008-04-02 00:00:00
13678 | LK92 | KROK1 | 12 | KROK123 | ACTIVE | 2008-04-09 00:00:00
13678 | LK92 | KROK1 | 12 | KROK626 | ACTIVE | 2008-04-09 00:00:00
13678 | LK92 | KROK_OFFSITE | 12 | KROK143 | ACTIVE | 2008-04-09 00:00:00
13678 | LK92 | [NAME] | 12 | [NAME] | ACTIVE | 2008-04-09 00:00:00
13678 | LK92 | DISK | 12 | CACHE | ACTIVE | 2008-04-09 00:00:00
200203 | LK92 | KROK1 | 12 | KROK123 | ACTIVE | 2008-04-02 00:00:00
Spreadsheet: 710234d1608796687-sum-a-column-based-on-the-adjacent-column-dynamic-sum
Sheet: Sheet1

 |  |  | Examples:
100 | 740 |  | 100 |  |  | 100 | 125 |  | 100 | 125 |  | 100 | 125 |  | 100 | 125 |  | 100 | 125
200 | 1607 |  | 200 |  |  | 200 | 0 |  | 200 | 246 |  | 200 | 246 |  | 200 | 246 |  | 200 | 246
300 | 200 |  | 300 |  |  | 300 | 0 |  | 300 | 0 |  | 300 | 285 |  | 300 | 285 |  | 300 | 285
400 | 0 |  | 400 |  |  | 400 | 0 |  | 400 | 0 |  | 400 | 0 |  | 400 | 124 |  | 400 | 124
500 | 0 |  | 500 |  |  | 500 | 0 |  | 500 | 0 |  | 500 | 0 |  | 500 | 0 |  | 500 | 256
Need formula in A7. If B3=0 or >0, it should sum A2:A6. If B3 value is >0, it should be B2+sum(A3:A6). If B4 value is >0, it should be B2:B3+sum(A4:A6). If B5 value is >0, it should be B2:B4+sum(A5:A6). If [NAME] value is >0, it should be B2:B5+sum(A6:A6).
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: wc

Weed. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 457260d1461272272-convert-listing-into-calendar-and-fills-specified-colours-calendar-apr-20
Sheet: Data Source

Date | Description | Category to show in | Fill colour to show on [NAME] |  |  | Type | Number
2010-04-17 00:00:00 | EB - E D O Banked | EDO |  |  |  | SDR | 1
2009-08-10 00:00:00 | SDR - Scheduled Day of Rest | SDR |  |  |  | Edo | 2
2009-01-17 00:00:00 | VLU - Vacation Leave Unpaid | Vacation |  |  |  | Vacation | 3
2009-07-20 00:00:00 | SDR - Scheduled Day of Rest | SDR |  |  |  | Holidy | 4
2010-07-26 00:00:00 | SDR - Scheduled Day of Rest | SDR |  |  |  | [NAME] | 5
2009-08-10 00:00:00 | SDR - Scheduled Day of Rest | SDR
2009-11-02 00:00:00 | SDR - Scheduled Day of Rest | SDR
2010-09-27 00:00:00 | SDR - Scheduled Day of Rest | SDR
2009-11-16 00:00:00 | SDR - Scheduled Day of Rest | SDR
2009-01-10 00:00:00 | SDR - Scheduled Day of Rest | SDR
2009-03-15 00:00:00 | SDR - Scheduled Day of Rest | SDR
2009-01-01 00:00:00 | New Year's Day | Holiday
2009-01-19 00:00:00 | [NAME] | Holiday
2009-02-16 00:00:00 | Presidents' Day | Holiday
2009-05-25 00:00:00 | Memorial Day | Holiday
2009-07-03 00:00:00 | 'Independence Day' observed | Holiday
2009-04-16 00:00:00 | SSL - Sick | [NAME]
2009-08-11 00:00:00 | SSL - Sick | [NAME]
2010-01-18 00:00:00 | SSL - Sick | [NAME]
2009-07-21 00:00:00 | SSL - Sick | [NAME]
2009-07-25 00:00:00 | SSL - Sick | [NAME]
2010-08-11 00:00:00 | SSL - Sick | [NAME]
2009-11-03 00:00:00 | SSL - Sick | [NAME]
2009-09-26 00:00:00 | SSL - Sick | [NAME]
2009-11-17 00:00:00 | SSL - Sick | [NAME]
2009-01-15 00:00:00 | SSL - Sick | [NAME]
Spreadsheet: joe_parks__14555__quotesheet
Sheet: 1-07

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
2002-01-07 08:34:59.420000 | Jan '02 | Natsource | Permian | Feb '02 | 10,000/d
2002-01-07 08:34:59.420000 | Jan '02 | Natsource | Permian | Feb '02 - Mar '02 | 10,000/d | [NAME]
2002-01-07 08:34:59.420000 | Jan '02 | Natsource | Permian | Ap - Oct '02 | 10,000/d | -17 @ -.16
2002-01-07 08:34:59.420000 | Jan '02 | Natsource | HSC | Feb '02 | 10,000/d
2002-01-07 08:34:59.420000 | Jan '02 | Natsource | HSC | Ap - Oct '02 | 10,000/d | .03 @ .0325
2002-01-07 08:34:59.420000 | Jan '02 | Natsource | HSC | Nov '02 - Mar '03 | 10,000/d | -.0375 @ -.0325
2002-01-07 08:34:59.420000 | Jan '02 | Natsource | Waha | Feb '02 - Mar '02 | 10,000/d | -.125 @ -.1175
2002-01-07 08:34:59.420000 | Jan '02 | Natsource | Waha | Ap - Oct '02 | 10,000/d | -.12 @ -.1125
2002-01-07 08:34:59.420000 | Jan '02 | APB | Waha | Feb '02 | 10,000/d | [NAME]
2002-01-07 08:34:59.420000 | Jan '02 | APB | Waha | Mar '02 | 10,000/d | [NAME]
2002-01-07 08:34:59.420000 | Jan '02 | APB | Waha | Feb - Mar '02 | 10,000/d | [NAME]
2002-01-07 08:34:59.420000 | Jan '02 | APB | Waha | Ap - Oct '02 | 10,000/d | -.12 @ -.11
2002-01-07 08:34:59.420000 | Jan '02 | APB | Waha | Nov '02 - Mar '03 | 10,000/d | -.135 @ -.125
2002-01-07 08:34:59.420000 | Jan '02 | APB | HSC | Feb '02 | 10,000/d | -.005 @ 0
2002-01-07 08:34:59.420000 | Jan '02 | APB | HSC | Mar '02 | 10,000/d | -.005 @ 0
2002-01-07 08:34:59.420000 | Jan '02 | APB | HSC | Apr - Jun '02 | 10,000/d
2002-01-07 08:34:59.420000 | Jan '02 | APB | HSC | Ap - Oct '02 | 10,000/d | .0275 @ .0325
2002-01-07 08:34:59.420000 | Jan '02 | APB | HSC | Nov '02 - Mar '03 | 10,000/d | -.035 @ -.0325
2002-01-07 08:34:59.410000 | Jan '02 | APB | Permian | Feb '02 | 10,000/d | -.165 @ -.1575
2002-01-07 08:34:59.410000 | Jan '02 | APB | Permian | Mar '02 | 10,000/d | -.165 @ -.1575
2002-01-07 08:34:59.410000 | Jan '02 | APB | Permian | Feb - Mar '02 | 10,000/d | -.165 @ -.1575
2002-01-07 08:34:59.410000 | Jan '02 | APB | Permian | Ap - Oct '02 | 10,000/d | -.17 @ -.16
2002-01-07 08:34:59.410000 | Jan '02 | APB | Permian | Nov '02 - Mar '03 | 10,000/d | -.165 @ -.16
2002-01-07 08:34:59.410000 | Jan '02 | Prebon | Permian | Feb '02 | 10,000/d
2002-01-07 08:34:59.410000 | Jan '02 | Prebon | Permian | Feb - Mar '02 | 10,000/d | -.16 @ -.155
2002-01-07 08:34:59.410000 | Jan '02 | Prebon | Permian | Ap - Oct '02 | 10,000/d | -.165 @ -.16
2002-01-07 08:34:59.410000 | Jan '02 | Prebon | Permian | Nov '02 - Mar '03 | 10,000/d | -.17 @ -.16
2002-01-07 08:34:59.410000 | Jan '02 | Prebon | Waha | Feb '02 | 10,000/d
2002-01-07 08:34:59.410000 | Jan '02 | Prebon | Waha | Feb - Mar '02 | 10,000/d | -.125 @ -.12
2002-01-07 08:34:59.410000 | Jan '02 | Prebon | Waha | Ap - Oct '02 | 10,000/d | -.115 @ -.11
2002-01-07 08:34:59.410000 | Jan '02 | Prebon | Waha | Nov '02 - Mar '03 | 10,000/d | -.135 @ -.13