tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lynn_blair__24455__webstoragepts
Sheet: Sheet1

STORAGE POINTS
POI # | DRN # | Name
98 | 109721 | OGDEN DEF. DELIVERY
60076 | 112686 | MID-CONTINENT DEF. DELIVERY
61120 | 132724 | PERMIAN DEF. DELIVERY
62389 | 179796 | [NAME]. - DELIVERY
62996 | 218124 | POWERTEX DEF. DELIVERY
62997 | 218125 | WESTAR CARSON DEF. DELIVERY
62998 | 218126 | PINNACLE [NAME]. DELIVERY
62999 | 218127 | WTU/RIO PECOS DEF. DELIVERY
63000 | 218128 | WESTAR HALE DEF. DELIVERY
63001 | 218123 | TW HALLEY DEF. DELIVERY
63002 | 218129 | LINAM RANCH DEF. DELIVERY
63003 | 218130 | WTU/SAN ANGELO DEF. DELIVERY
71318 | 251359 | MID 1 STORAGE POOLING POINT
71319 | 251361 | MID 2 STORAGE POOLING POINT
71320 | 251363 | MID 3 STORAGE POOLING POINT
71321 | 251365 | MID 4 STORAGE POOLING POINT
71322 | 251367 | MID 5 STORAGE POOLING POINT
71323 | 251369 | MID 6 STORAGE POOLING POINT
71324 | 251371 | MID 7 STORAGE POOLING POINT
71325 | 251373 | MID 8 STORAGE POOLING POINT
71326 | 251375 | MID 9 STORAGE POOLING POINT
71327 | 251377 | MID 10 STORAGE POOLING POINT
71328 | 251379 | MID 11 STORAGE POOLING POINT
71329 | 251381 | MID 12 STORAGE POOLING POINT
71330 | 251384 | MID 13 STORAGE POOLING POINT
71331 | 251386 | MID 14 STORAGE POOLING POINT
71332 | 251388 | MID 15 STORAGE POOLING POINT
71333 | 251390 | MID 16A STORAGE POOLING POINT
71451 | 255524 | MID 16A STORAGE POOLING POINT - 1707
71454 | 255548 | WESTAR [NAME]. DELIVERY
71455 | 255549 | GOLDEN SPREAD DEF. DELIVERY
71456 | 255550 | EL PASO PLAINS DEF. DELIVERY
71459 | 255613 | MID 17 STORAGE POOLING POINT
71460 | 255614 | VENTURA DEF. DELIVERY
78122 | 289647 | OASIS WAHA DEF. DELIVERY
78123 | 289648 | ARKLA REDMOON DEF. DELIVERY
78124 | 289649 | [NAME]. DELIVERY
78125 | 289650 | CIG DUMAS DEF. DELIVERY
78126 | 289651 | PLEASANT VALLEY DEF. DELIVERY
78127 | 289652 | PEPL MULLINVILLE DEF. DELIVERY
78284 | N/A | TW/NNG GRAY DEF DELIVERY
78286 | N/A | TRANSOK ARAPAHOE DEF DELIVERY
78287 | N/A | ANR GREENSBURG DEF DELIVERY
78288 | N/A | ENOGEX CUSTER DEF DELIVERY
78289 | N/A | WESTAR SEAGRAVES DEF DELIVERY
78290 | N/A | VALERO/NNG SPRAYBERRY DEF DELIVERY
78291 | N/A | EL PASO/NNG KEYSTONE DEF DELIVERY
78292 | N/A | NNG/KN TESCOTT PONY EXPRESS DEF DEL
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 12c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending December 21, by product type and major currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***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: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B1

Local 1
Nom: | [NAME] | Mécanique Mobile
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-14 00:00:00
[NAME]: | 87
Réservé:
Prix: | 100
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 482898d1475318615-need-assistance-creating-formula-to-convert-column-of-consecutive-times-into-blocks-sample-spreadsheett
Sheet: Sheet1

 | COURSE 1 | COURSE 2 | COURSE 3 |  | need to create a formula which will convert times in Course 1 to the following:
Racer 1 | 10:30:00 | 11:30:00 | 12:30:00 |  | 10:30:00
[NAME] |  |  |  |  | 10:30:00
Racer 3 |  |  |  |  | 10:30:00
[NAME] |  |  |  |  | 10:31:00
Racer 5 |  |  |  |  | 10:31:00
Racer 6 |  |  |  |  | 10:31:00
Racer 7 |  |  |  |  | 10:32:00
Racer 8 |  |  |  |  | 10:32:00
Racer 9 |  |  |  |  | 10:32:00
Racer 10
[NAME] |  |  |  |  | …..
Racer 12
Racer 13
Racer 14
Racer 15
Racer 16
Racer 17
Racer 18
Racer 19
Racer 20
Racer 21
Spreadsheet: 551680d1513090142-modify-search-results-based-on-text-in-another-cell-eod-v2
Sheet: Sheet9

 | AREA | JOB |  | SPV | TYPE |  | NEED
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER PART TIME |  |  | EOD |  |  |  | WANT EOD IN COL F ONLY IF SPV IN COL E
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER PART TIME |  |  | EOD
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER PART TIME |  |  | EOD
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER PART TIME |  |  | EOD
 | OTTAWA HAMILTON EOD SPV | SPV LETTER CARRIER |  | SPV | EOD |  | SPV | EOD
 | OTTAWA HAMILTON SPV | LETTER CARRIER |  | SPV |  |  |  |  |  |  |  | WRONG
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER |  | SPV | EOD
 | OTTAWA HAMILTON SPV | LETTER CARRIER |  | SPV |  |  |  |  |  |  |  | WRONG
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER |  | SPV | EOD
 | OPS LCD 1 HAMILTON EOD SPV | LETTER CARRIER PART TIME
 | OPS LCD 1 HAMILTON EOD SPV | SPV LETTER CARRIER |  | SPV
Spreadsheet: 198784d1354895136-dependent-data-validation-using-unsorted-list-accrual
Sheet: Sheet1

List Sample |  |  |  | Data Validation
Accrual ID | Budget Code | Accrual Value |  | Payment | Budget Code | Accrual ID
697.001 | 697 | 1500 |  | 300 | 697 | ???
697.002 | 697 | 900
700.001 | 700 | 1600
700.002 | 700 | 2500
700.003 | 700 | 3000
697.001 | 697 | 8000
Spreadsheet: joe_parks__14713__POSTION05_02
Sheet: MAY_SWAP (2)

 | SELL |  |  |  | BUY
BEGINNING | 30.75 | 3.596 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 31 | 3.15
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.115
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 738712d1625206382-formula-to-calculate-total-amount-of-previous-invoice-book1
Sheet: Numbering (2)

Project Name | Sequence |  | ddd | IFA |  | Project | ddd | IFA | Invoice Total Amount |  |  |  |  | Current IAF | PO No. | Total amount of Previous Invoice | Total amount of Previous Invoice
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  | correct value according to O2
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123457 |  |  |  |  |  |  |  |  | 1000
Lab-45123458 |  |  |  |  |  |  |  |  | 1000
Lab-45123459 |  |  |  |  |  |  |  |  | 1000
Spreadsheet: 824293d1680467225-data-flow-from-main-sheet-to-another-tab-data-flow-from-main-sheet-to-other-tab-according-to-the-name-of-the-tab-1-
Sheet: Main Sheet

SR NO | ORDER DATE | AGEING | ORDER STATUS | CLIENT NAME | COUNTRY | CATEGORY | QTY | TOTAL order received | BALANCE order TO SOURCE | DELHI | CHD | CHENNAI | DLC | MUM CNF | PSK | TOTAL order received | BALANCE order TO SOURCE
1 | 2023-03-01 00:00:00 |  | Active | ABC Corporation | India | Bulb | 50 | 1 |  |  | 1
4 | 2023-03-04 00:00:00 |  | Closed | JKL Corporation | India | Geyser | 20 | 4 |  |  | 1 |  | 1 | 1 | 1
2 | 2023-03-02 00:00:00 |  | Inactive | DEF Corporation | India | Tubelights | 25 | 2 |  |  |  | 1 | 1
3 | 2023-03-03 00:00:00 |  | Hold | GHI Corporation | India | Fan | 35 | 3 |  |  |  |  |  | 3
1 | 2023-03-01 00:00:00 |  | Active | ABC Corporation | India | Bulb | 50 | 1 |  |  | 1
4 | 2023-03-04 00:00:00 |  | Closed | JKL Corporation | India | Geyser | 20 | 4 |  |  | 1 |  | 1 | 1 | 1
2 | 2023-03-02 00:00:00 |  | Inactive | DEF Corporation | India | Tubelights | 25 | 2 |  |  |  | 1 | 1
3 | 2023-03-03 00:00:00 |  | Hold | GHI Corporation | India | Fan | 35 | 3 |  |  |  |  |  | 3
Spreadsheet: 219bb193-7118-459e-9ca4-a494a82a3510
Sheet: Talents

 | Talent | Points | Effect
 | Feral
 | Ferocity | 5 |  | energy for claw, rake, mangle
 | Sharpened Claws | 3 |  | crit chance
 | Shredding Attacks | 2 |  | energy for shred
 | [NAME] | 3 |  | attack power
 | Primal Fury | 2 |  | chance for extra combo point on crit
 | Savage Fury | 2 |  | damage multiplier on claw rake and mangle
 | Faerie Fire Feral | 1 |  | armor to target
 | Heart of the Wild | 5 |  | multiplier to INT and STR
 | Leader of the Pack | 1 |  | crit chance
 | Predatory Instincts | 5 |  | damage multiplier on crits
 | Survival of the Fittest | 3 |  | multiplier to STR, AGI, STA, INT, SPI
 | Mangle | 1 |  | can use Mangle (Cat)
 | Restoration
 | Naturalist | 5 |  | damage multiplier
 | Omen of clarity | 1 |  | chance of a clearcast per attack (modeled as global energy reduction)
Spreadsheet: 167026d1341870039-searching-a-column-for-certain-text-and-then-referencing-a-neighboring-cell-priority
Sheet: Sheet1

Jobh # | Incompatible Job #s |  |  |  | Known Priority List 1 | Shift 1 Calculated Priority List | Known Priority List 2 | Shift 2 Calculated Priority List
1 | 1 | 4 |  |  | 1 | 1 | 2
2 | 2 | 1 |  |  | 3 |  | 3
3 | 3 | 5 |  |  |  |  | 4
4 | 4 | 1
5 | 5 | 2
Shift 1 | % Complete at Break 1 | Shift 2
 | 1
 | 0.25
 | 0.25
 | 0.25
 | 0.25
Spreadsheet: 810319d1671686222-week-number-week-
Sheet: Sheet1

Date | Week#
2022-11-26 00:00:00
2022-11-27 00:00:00
2022-11-28 00:00:00
2022-11-29 00:00:00
2022-11-30 00:00:00
2022-12-01 00:00:00
2022-12-02 00:00:00
2022-12-03 00:00:00
2022-12-04 00:00:00
2022-12-05 00:00:00
2022-12-06 00:00:00
2022-12-07 00:00:00
2022-12-08 00:00:00
2022-12-09 00:00:00
2022-12-10 00:00:00
2022-12-11 00:00:00
Spreadsheet: chris_germany__1848__RetailSalesAgreementSchedules
Sheet: Assignable Storage

SCHEDULE I  PART II   ASSIGNABLE STORAGE
 | Choice | C & I | C & I | Contract |  |  |  | Rate | Start | End | Capacity |  | [NAME] |  | Delivery Point |  |  |  |  | Demand | Commodity
Pipeline | Program | LDC | Customer | Number |  | Shipper | Agent | Type | Date | Date | Type | [NAME] | [NAME] | Delivery Point | [NAME] | MDQ | MSQ | MDIQ | MDWQ | Rate | Rate
CNG | Atlanta |  |  | 530529 | (1) | CESWHSLE | CESWHSLE | GSS-TE | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | Storage |  |  |  |  |  | 14046 |  | 230 | [NAME] | [NAME]
CNG |  | Boston Gas |  | 560042 |  | CESWHSLE | CESWHSLE | GSS-TE | 1999-03-01 00:00:00 | 2006-03-31 00:00:00 | Storage |  |  |  |  |  | 5722 | 76 | 147 | [NAME] | [NAME]
SONAT | Atlanta |  |  | SSNG10 | (1) | CESWHSLE | CESWHSLE | CSS | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | Storage |  |  |  |  |  |  |  |  | [NAME] | [NAME]
TCO | COH |  |  | 51407 |  | CESWHSLE | CESWHSLE | FSS  Master | 1996-08-01 00:00:00 | 2099-08-01 00:00:00 | Storage |  |  |  |  |  |  |  |  | [NAME]
TCO | COH |  |  | 63304 |  | CESWHSLE | CESWHSLE | FSS | 1999-04-01 00:00:00 | 2000-03-31 00:00:00 | Storage |  |  |  |  |  | 7503838 |  | 134743 |  | [NAME]
TENN | Atlanta |  |  | 31963 | (1) | CESWHSLE | CESWHSLE | FS-MA | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | Storage |  |  |  |  |  | 78768 | 521 | 583 | [NAME] | [NAME]
TENN | Atlanta |  |  | 31975 | (1) | CESWHSLE | CESWHSLE | FS-PA | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | Storage |  |  |  |  |  | 219482 | 1464 | 1468 | [NAME] | [NAME]
TETCO |  | Boston Gas |  | 892102 |  | CESWHSLE | CESWHSLE | [NAME] | 1999-11-01 00:00:00 | 2013-04-30 00:00:00 | Storage |  |  |  |  |  | 12207 | 63 | 170 | [NAME] | [NAME]
TRANSCO | Atlanta |  |  | 2.7479 | (1) | CESWHSLE | CESWHSLE | 284-WSS | 1998-12-01 00:00:00 | 2098-12-31 00:00:00 | WSS Master |  |  |  |  |  |  |  |  |  | [NAME]
TRANSCO | Atlanta |  |  | 2.7502 | (1) | CESWHSLE | CESWHSLE | 284-ESS | 1998-12-01 00:00:00 | 2098-12-31 00:00:00 | ESS Master |  |  |  |  |  |  |  |  |  | [NAME]
TRANSCO | Atlanta |  |  | 3.3115 | (1) | CESWHSLE | CESWHSLE | 284-WSS | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | Storage |  |  |  |  |  | 397258 | 2280 | 4674 | [NAME] | [NAME]
TRANSCO | Atlanta |  |  | 3.3114 | (1) | CESWHSLE | CESWHSLE | 284-ESS | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | Storage |  |  |  |  |  | 7503 | 50 | 746 | [NAME] | [NAME]
Spreadsheet: 115742d1311261461-how-to-use-relative-reference-with-a-function-samplesheet
Sheet: Sheet1

 |  |  | a0 | this would have a formula similar to (E3)
 |  |  | a1 | this would have a formula similar to (E3)
 | *The question is: How can I make the code in the table $[NAME] use the relative position from whence the request  came?  In the first example from (B8), I need the (E3) calculation to *know* it came from ROW(8). |  | a2 | =((indirect("$C"&{the row this was sent from, row 8 in the first example}))/2)+(indirect("$B"&{the row above the row this was sent from}))
 |  |  | b0 | this would have a formula similar to (E3)
 |  |  | b1 | this would have a formula similar to (E3)
 |  |  | b2 | this would have a formula similar to (E3)
 | 2
a | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 4 |  | *The result in (B8) should be 1. (C8/B7-1) or (4/2-1)
a | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 6
a | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 3
b | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 2
a | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 2
b | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 1
b | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 3
b | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 4
a | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 5
b | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 2
a | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 1
a | =VLOOKUP(INDIRECT("$A"&ROW())&ROW()-1,$D$1:$E$6,2) | 2
a
Spreadsheet: 7f9bb271-b8d8-425a-9461-d6bb9780497b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8523 | 63827 | Cesar | Valera | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:55:27
8523 | 63832 | Delfin | Malaver | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 00:59:05
8523 | 63833 | Julian | Velasquez | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:03:36
8523 | 62111 | [NAME] | Becerra | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:06:31
8523 | 63831 | [NAME] | Martinez | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:08:55
8523 | 63829 | Mario | Farnetano | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 01:09:04
8523 | 63828 | [NAME] | Biagginni | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | 01:13:08
8523 | 63830 | Ricardo | Sanchez | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 8 | 01:14:33
Spreadsheet: 772139d1647018097-how-to-match-and-sum-a-range-where-last-two-digits-end-with-endswith
Sheet: Sheet1

 | 3 seg value |  |  | Balance
 | 6970-52-73 |  |  | 1150
 | 8840-81-71 |  |  | 201.2
 | 8993-26-71 |  |  | 0
 | 8993-26-72 |  |  | 347.22
 | 3970-96-79 |  |  | 250
 | 6970-06-72 |  |  | 100
 | sumtotals |  | Result
 | 71
 | 72
 | 73
 | 79
Spreadsheet: 83178d1283221801-how-to-copy-multiple-cell-rows-with-increasing-fixed-number-every-10-rows-book1
Sheet: Sheet1

type | code | number | fix
A1 | 3 | 1 | 1
A1 | 3 | 1 | 2
A1 | 3 | 1 | 3
A1 | 3 | 1 | 4
A1 | 3 | 1 | 5
A1 | 3 | 1 | 6
A1 | 3 | 1 | 7
A1 | 3 | 1 | 8
A1 | 3 | 1 | 9
A1 | 3 | 1 | 10
A1 | 3 | 2 | 1
A1 | 3 | 2 | 2
A1 | 3 | 2 | 3
A1 | 3 | 2 | 4
A1 | 3 | 2 | 5
A1 | 3 | 2 | 6
A1 | 3 | 2 | 7
A1 | 3 | 2 | 8
A1 | 3 | 2 | 9
A1 | 3 | 2 | 10
A1 | 3 | 3 | 1
A1 | 3 | 3 | 2
A1 | 3 | 3 | 3
A1 | 3 | 3 | 4
A1 | 3 | 3 | 5
A1 | 3 | 3 | 6
A1 | 3 | 3 | 7
A1 | 3 | 3 | 8
A1 | 3 | 3 | 9
A1 | 3 | 3 | 10
…
* let say need to copy up to number 100
Spreadsheet: 161850d1339657346-look-up-with-multiple-criterias-sample
Sheet: Sheet1

Cost Matrix |  |  |  |  |  | Employee Listing
COST TYPE | JOB GRADE | DEPT | COST |  |  | EMPLOYEE NAME | JOB GRADE | DEPT | Housing Cost | Car Cost
Housing Cost | 40 | Finance | 1000 |  |  | Mr Carrot | 38 | FINANCE
Housing Cost | 39 | Finance | 900
Housing Cost | 38 | Finance | 675
Housing Cost | 40 | HR | 506.25
Housing Cost | 39 | HR | 379.6875
Housing Cost | 38 | HR | 284.765625
Car Cost | 40 | Marketing | 25
Car Cost | 39 |  | 30
Car Cost | 38 |  | 30
Spreadsheet: 166066d1341450471-copy-paste-cell-value-into-next-available-empty-cell-in-same-row-every-5-minute-timegrid
Sheet: TimeGrid

1.2334 | 1.239
100.25 | 101.2
4.134 | 4.1341
9.2342 | 9.2333
1.2334
87.82 | 87.91
4.134 | 4.135
9.2342 | 9.23
Spreadsheet: 821116d1678458637-countifs-for-variable-range-esukei-test-countifs
Sheet: TEST

AA |  |  |  |  | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6StringJazzer [NAME]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
11024726 |  |  |  |  | [PHONE]
Spreadsheet: 130179d1322113439-how-to-use-if-formula-for-change-price-december
Sheet: 11

 |  |  |  | 2011-12-11 00:00:00
Newspaper | Price | Quantity | Total
Value | 1.1 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.63 |  | 0
Value3 | 1.63 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.2 |  | 0
Value10 | 1.2 |  | 0
Value11 | 1.2 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 675083d1588154546-holidays-over-midnight-holidays_3-keebellah-
Sheet: Sheet1

 |  | Total hours:
 |  |  | weekdays |  |  |  | weekend hours | Totaled Hours |  |  | Holidays hours
 |  |  | 22:00:00 | 17:00:00 | 06:00:00 |  | Tot hours Saturday + Tot hours Sunday | Tot hours Holiday |  |  |  | 2020-01-01 00:00:00
 |  |  | 06:00:00 | 22:00:00 | 08:30:00 |  |  |  |  |  |  | 2020-01-06 00:00:00
 | start date&time | end date&time |  |  |  | time worked start | time worked to end | totaled start/end | actual working days |  |  | 2020-04-10 00:00:00
 | 2020-01-01 22:00:00 | 2020-01-02 16:00:00 |  |  |  |  |  |  |  |  |  | 2020-04-13 00:00:00
 | 2020-01-02 22:00:00 | 2020-01-03 04:00:00 |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00
 | 2020-01-03 20:00:00 | 2020-01-03 21:00:00 |  |  |  |  |  |  |  |  |  | 2020-06-21 00:00:00
 | 2020-01-06 09:00:00 | 2020-01-07 18:00:00 |  |  |  |  |  |  |  |  |  | 2020-06-06 00:00:00
 | 2020-01-02 10:00:00 | 2020-01-02 17:00:00 |  |  |  |  |  |  |  |  |  | 2020-06-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2020-10-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2020-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2020-12-26 00:00:00
Spreadsheet: 268195d1380492333-conditional-formatting-example
Sheet: Sheet1

Date of Arrival | Reviewer | Completion Date | By When | [NAME]
2013-07-31 00:00:00 | [NAME] | 2013-08-06 00:00:00 | 2013-08-14 00:00:00 | 2013-08-08 00:00:00
2013-07-31 00:00:00 | [NAME] | 2013-08-06 00:00:00 | 2013-08-13 00:00:00 | 2013-08-06 00:00:00
2013-07-30 00:00:00 | [NAME] | 2013-08-07 00:00:00 | 2013-08-14 00:00:00 | 2013-08-08 00:00:00
2013-08-02 00:00:00 | [NAME], Safety, Maint | 2013-08-26 00:00:00 | 2013-08-16 00:00:00 | 2013-08-26 00:00:00
2013-07-31 00:00:00 | [NAME] | 2013-08-10 00:00:00 | 2013-08-14 00:00:00 | 2013-08-14 00:00:00
2013-08-19 00:00:00 | [NAME] | 2013-08-31 00:00:00 | 2013-09-02 00:00:00 | 2013-08-31 00:00:00
2013-08-19 00:00:00 | [NAME] | 2013-08-31 00:00:00 | 2013-09-02 00:00:00 | 2013-08-31 00:00:00
2013-08-19 00:00:00 | Shane Dunn | 2013-08-29 00:00:00 | 2013-09-02 00:00:00 | 2013-08-29 00:00:00
2013-08-21 00:00:00 | [NAME] | 2013-09-06 00:00:00 | 2013-09-04 00:00:00 | 2013-09-06 00:00:00
2013-08-20 00:00:00 | [NAME] | 2013-09-02 00:00:00 | 2013-09-02 00:00:00 | 2013-09-02 00:00:00
2013-09-02 00:00:00 | [NAME] | 2013-09-16 00:00:00 | 2013-09-17 00:00:00 | 2013-09-16 00:00:00
2013-09-16 00:00:00 | [NAME] |  | 2013-10-10 00:00:00
Spreadsheet: 124320d1318336082-data-extraction-for-insurance-policy-data-extraction-and-auto-insurance-formulas
Sheet: Original.xlsx

Calculate automobile liability.
Name of Insured | Policy Formula | Injured #1 Medical Expenses | Amount Paid Ins. Co. for #1 | Injured #2 Medical Expenses | Amount Paid Ins. Co. for #2 | Amount of Property Damage | Property Damage Ins. Co. Pays | Property Damage Insured Pays | Medical Expense Insured Pays | Total Insured Pays | Insurance Company Pays
Hendrix, [NAME] | 40/50/25 | 20000 |  | 23000 |  | 22000
Ivy, Denia | 30/30/30 | 50500 |  | 56000 |  | 28000
Jeans, [NAME] | 50/75/50 | 29000 |  | 42000 |  | 15000
Martinez, [NAME] | 20/25/10 | 35000 |  | 12000 |  | 18000
[NAME], [NAME] | 75/100/50 | 30000 |  | 19000 |  | 65000
Directions:
[NAME] the Policy Formula’s amount for one person's injury to Injured #1’s Medical Expenses and key in Column D the Amount Paid by the Insurance       Company for Injured #1. (The first amount in Policy Formula is the maximum paid for any one person injured.)
[NAME] the maximum amount for one person's injuries to Injured #2’s expenses and key in Column F the Amount Paid by the Insurance Company for         Injured #2.(Be sure to consider what has been paid for #1 and the maximum allowable, which is the second figure in the Policy Formula.) Normally an equal        amount would be paid to the Injured, but for this exercise, pay the second Injured the difference.
c.  Compare the Policy Formula’s maximum for property damage and key in Column H the amount the insurance company will pay. In column I, calculate          the amount the insured pays. (Subtract Column H from Column G.)
d.  Enter multimath formulas in Column J to calculate the Amount Insured Pays. (Add Injured #1’s and #2’s expenses and then subtract the Amount Paid by        Insurance Company for each.) The difference is what the Insured must pay of the medical expenses.
e.  Enter formulas in Column K to calculate Total Insured Pays of property damages and medical expenses.
f.  Enter formulas to calculate the total amount the Insurance Company Pays.