tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686123d1594375412-timesheet-have-few-problem-ldc-tms-1-
Sheet: new

DATE | DAY | SHIFT | TIME |  | BREAKS | SHIFT DETAILS |  |  |  | OVER TIME |  | ALLOWANCE |  | REASON |  | DATE | DAY | SHIFT | TIME |  | BREAKS | SHIFT DETAILS |  |  |  | OVER TIME |  | ALLOWANCE |  | REASON
 |  |  | IN | OUT |  | NORMAL | LATE | EARLY OUT | ACTUAL | OT 1.5 | OT 2.0 | INCENTIVE | MEAL |  |  |  |  |  | IN | OUT |  | NORMAL | LATE | EARLY OUT | ACTUAL | OT 1.5 | OT 2.0 | INCENTIVE | MEAL
3076 | B72 |  |  |  | NAME : |  |  |  |  |  | PERIOD : 01-03-2020 TO 30-03-2020 |  |  |  |  | 3076 | B72 |  |  |  | NAME : |  |  |  |  |  | PERIOD : 01-03-2020 TO 30-03-2020
2020-03-01 00:00:00 | SUNDAY | MOR | 06:32:00 | 17:02:00 | 1 |  |  |  |  |  |  | - | - |  |  | 2020-03-01 00:00:00 | SUNDAY | MOR | 06:32:00 | 17:02:00 | 1 | - | - | - | 8 | - |  | - | -
2020-03-02 00:00:00 | MONDAY | MOR | 08:50:00 | 13:00:00 | 1 |  | 0.5 | 4 |  |  | - | - | - |  |  | 2020-03-02 00:00:00 | MONDAY | MOR | 08:50:00 | 13:00:00 | 1 | 4 | 0.5 | 4 |  | - | - | - | -
2020-03-03 00:00:00 | TUESDAY | MOR | 07:23:00 | 22:00:00 | 1 |  |  |  |  |  | - | - | 3 |  |  | 2020-03-03 00:00:00 | TUESDAY | MOR | 07:23:00 | 22:00:00 | 1 |  | - | - | 13 | 5 | - | - | 3
2020-03-04 00:00:00 | WEDNESDAY | MOR | 08:00:00 | 17:00:00 | 1 |  |  |  |  |  | - | - |  |  |  | 2020-03-04 00:00:00 | WEDNESDAY | MOR | 08:00:00 | 17:00:00 | 1 |  | - | - | 8 | - | - | - | ...
2020-03-05 00:00:00 | THURSDAY | MOR | 07:50:00 | 17:15:00 | 1 |  |  |  |  |  | - | - | - |  |  | 2020-03-05 00:00:00 | THURSDAY | MOR | 07:50:00 | 17:15:00 | 1 |  | - | - | 8 | - | - | - | -
2020-03-06 00:00:00 | FRIDAY | NIG | 19:15:00 | 05:16:00 | 1 |  | 0.15 |  |  |  | - | - | - |  |  | 2020-03-06 00:00:00 | FRIDAY | NIG | 19:15:00 | 05:16:00 | 1 | 8 | 0.15 | - | 8 | - | - | - | -
2020-03-07 00:00:00 | SATURDAY | NIG | 21:00:00 | 07:00:00 | 1 |  |  |  |  |  | - | - | - |  |  | 2020-03-07 00:00:00 | SATURDAY | NIG | 21:00:00 | 07:00:00 | 1 | 8 | - | - | 8 | 1 | - | - | -
2020-03-08 00:00:00 | SUNDAY | MOR |  |  |  |  |  |  |  |  | - | - | - | REST |  | 2020-03-08 00:00:00 | SUNDAY | MOR |  |  |  | - | - | - | - | - | - | - | - | REST
2020-03-09 00:00:00 | MONDAY | NIG | 20:55:00 | 04:49:00 | 1 |  |  | 0.11 |  |  | - | - | - |  |  | 2020-03-09 00:00:00 | MONDAY | NIG | 20:55:00 | 04:49:00 | 1 | 8 | - | 0.11 | 8 | - | - | - | -
 |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | a) Punch in earlier than 8:00 / 21:00 doesn't count as overtime.
 | b) Actual time have to deduct 1 hour for the lunch break.
 | c) Night shift normal hour formula have problem.
 | d) Overtime worker more than 6 hour will entitle for $3.00 meal allowance.
Spreadsheet: 77741d1278183223-excel-2007-mileages-ukandy_vlookup
Sheet: DISTANCES

Start | Destination | Helper column | [NAME]
London | Paris |  | 10
London | St. Andrews |  | 20
London | Leeds |  | 30
London | Coventry |  | 40
London | Dublin |  | 50
Paris | London |  | 10
Paris | St. Andrews |  | 11
Paris | Leeds |  | 21
Paris | Coventry |  | 31
Paris | Dublin |  | 41
St. Andrews | London |  | 20
St. Andrews | Paris |  | 11
St. Andrews | Leeds |  | 12
St. Andrews | Coventry |  | 22
St. Andrews | Dublin |  | 32
Leeds | London |  | 30
Leeds | Paris |  | 21
Leeds | St. Andrews |  | 12
Leeds | Coventry |  | 13
Leeds | Dublin |  | 23
Coventry | London |  | 40
Coventry | Paris |  | 31
Coventry | St. Andrews |  | 22
Coventry | Leeds |  | 13
Coventry | Dublin |  | 14
Dublin | London |  | 50
Dublin | Paris |  | 41
Dublin | St. Andrews |  | 32
Dublin | Leeds |  | 23
Dublin | Coventry |  | 14
Spreadsheet: 872841d1719290063-put-together-uneven-data-from-various-sheet-tabs-book9
Sheet: MAR

 | Year & Month | Total Number of Available Rooms* | Total Number of Sold Rooms** | Total Room Revenue | Currency | Total Revenue
 | 2022-03-01 00:00:00 | 128 | 69 | 106379.39 | Usd | 137287.89
 | 2022-03-02 00:00:00 | 128 | 45 | 71860.27 | Usd | 86932.93000000001
 | 2022-03-03 00:00:00 | 128 | 52 | 83295.65 | Usd | 115281.77
 | 2022-03-04 00:00:00 | 128 | 66 | 112571.69 | Usd | 152615.46
 | 2022-03-05 00:00:00 | 128 | 66 | 117264.93 | Usd | 160886.76
 | 2022-03-06 00:00:00 | 128 | 71 | 110788.42 | Usd | 154764.89
Spreadsheet: 56420d1256629264-how-to-merge-repeated-data-cell-in-excel-sample-6c
Sheet: Sheet2

Plot No | Area |  |  |  | Name of Owner | Address
43 | 0 | 8 | 0 | 0 | A | Kathmandu
43 | 0 | 8 | 0 | 0 | B | Kathmandu
43 | 0 | 8 | 0 | 0 | C | Kathmandu
44 | 0 | 5 | 0 | 0 | A | Pokhara
275 | 0 | 2 | 2 | 2 | A | Kathmandu
275 | 0 | 2 | 2 | 2 | B | Pokhara
275 | 0 | 2 | 2 | 2 | C | Biratnagar
275 | 0 | 2 | 2 | 2 | D | Dhankuta
278 | 3 | 3 | 1 | 1 | A | Kathmandu
278 | 1 | 2 | 1 | 1 | B | Kathmandu |  | Plot No. 278 is differ so I wan to leave all plot no. as is it.
278 | 1 | 2 | 1 | 1 | C | Kathmandu
278 | 1 | 2 | 1 | 1 | D | Kathmandu
 |  |  |  |  |  |  |  | If same address then I want to keep only one address, if differ each other then merge all address of same plot no.
Plot No | Area |  |  |  | Name of Owner | Address
43 | 0 | 8 | 0 | 0 | A, B, C | Kathmandu
44 | 0 | 5 | 0 | 0 | A | Pokhara
275 | 0 | 2 | 2 | 2 | A, B, C, D | Kathmandu, Pokhara, Biratnagar, Dhankuta
278 | 3 | 3 | 1 | 1 | A | Kathmandu
278 | 1 | 2 | 1 | 1 | B | Kathmandu
278 | 1 | 2 | 1 | 1 | C | Kathmandu
278 | 1 | 2 | 1 | 1 | D | Kathmandu
Spreadsheet: dutch_quigley__9239__011203 GIS
Sheet: Deal Sheet for Printing

 |  |  |  |  |  |  |  |  |  |  |  |  |  | PURCHASE BEHIND  PLANT |  |  |  |  |  | DEDICATED RESERVES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME PLANT:________________ |  |  |  |  |  | FIRST PURCHASER
Enron Captial & Trade Resources Corp.
 |  |  |  |  |  |  |  | Executed Deal Ticket |  |  |  |  |  | DEAL NUMBER |  |  |  |  | Deal | #________________
COUNTERPARTY/CUSTOMER |  |  | CONTACT |  |  |  |  | ORIGINATOR |  |  | DEAL DATE |  |  | TRANSACTION TYPE(SWAP, CAP, INDEX, ETC.)
Grupo Industrial Saltillo |  |  | [NAME] |  |  |  |  | [NAME] |  |  | 2001-12-03 00:00:00 |  |  | Swap
ECTR COUNTERPARTY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHYSICAL DELIVERY POINT/PIPELINE |  |  |  |  | COMMODITY
ENA |  |  |  |  |  |  |  |  |  |  | HPL/SHPCHAN |  |  |  | --- |  |  |  |  | NG
UNIT OF MEASURE |  |  | MW |  |  |  | CURRENCY |  | BROKER |  | FEE |  |  | DEAL STATUS |  |  |  | SETTLEMENT
 |  |  |  | --- |  |  |  |  | --- |  | ---
 |  |  | RISK MANAGER INITIALS:
PHYSICAL  NOTIONAL DEL  START DATE | PHYSICAL  NOTIONAL DEL  END DATE | REFERENCE  CODE (e.g. NX3) | FINANCIAL  REFERENCE  START DATE |  | FINANCIAL REFERENCE END  DATE |  | FIRM  QUANTITY  (A) | OPTION/OMICRON  QUANTITY (B) |  | TOTAL MAXIMUM  QUANTITY (A+B) | FIXED  PRICE | BASIS | C PHYSICAL  PREMIUM | C ADMIN/ OTHER | C TRANSPORT  PRICE |  | C OMICRON  PRICE | CONTRACT  PRICE/ STRIKE | C OPTION  PREMIUM |  | ORIGINATION
 |  |  |  |  |  |  |  |  |  |  |  | EFP
 |  | NX1 | 2003-01-01 00:00:00 |  | 2003-12-01 00:00:00 |  | 440000 |  |  |  | 3.265 | 0.005 |  |  |  |  |  | 3.27 |  |  | 0.01
[NAME]:
Spreadsheet: 464014d1464847122-drop-down-list-sum-function-fuel
Sheet: Sheet1

Vehicle | Fuel | [NAME] | Hours
E1 | 12 | 123 | 5
c4 | 6 | 23 | 2
D3 | 43 | 56 | 90
E1 | 3 | 5 | 2
E1 | 12 | 123 | 5
c4 | 6 | 23 | 2
D3 | 43 | 56 | 90
E1 | 3 | 5 | 2
E1 | 12 | 123 | 5
c4 | 6 | 23 | 2
D3 | 43 | 56 | 90
E1 | 3 | 5 | 2
E1 | 12 | 123 | 5
c4 | 6 | 23 | 2
D3 | 43 | 56 | 90
E1 | 3 | 5 | 2
E1 | 12 | 123 | 5
c4 | 6 | 23 | 2
D3 | 43 | 56 | 90
E1 | 3 | 5 | 2
Spreadsheet: 215376d1361363986-determining-unique-data-from-multiple-same-strings-based-on-counter-sample1
Sheet: HIDDEN_rangenames

Length of Session | Length of Session Values | Package Sizes | EFT or PIF | Lead Type
30 min | 0.5 | 1 | EFT | Personal
45 min | 0.75 | 4 | PIF | STAT
60 min | 1 | 8
 |  | 12
 |  | 24
 |  | 36
Spreadsheet: 699910d1602823126-check-if-expenses-are-on-the-given-quarter-book1
Sheet: asdf

 | Project Name: | Carrington Road / Showground Road Intersection Upgrade - AFC Design
 | Project No: | 18020
 |  |  |  |  |  |  |  |  |  |  |  |  | Property Escalation Rate
 |  |  |  |  |  | Manually input first month; months must correspond to table below - e.g. Dec/Mar/Jun/Sep for quarterly
 | Expenditure Profile Base Amount: |  |  |  |  | 2016-11-30 00:00:00 | 2017-02-28 00:00:00 | 2017-05-31 00:00:00 | 2017-08-31 00:00:00 | 2017-11-30 00:00:00 | 2018-02-28 00:00:00 | 2018-05-31 00:00:00 | 2018-08-31 00:00:00
 |  |  |  |  | Current Expenditure | period 0* | period 1* | period 2 | period 3 | period 4 | period 5 | period 6 | period 7 | Total
 | Item | Total | Start Date | Complete Date | 0 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Initiation | 0 | 2013-01-31 00:00:00 | 2013-01-31 00:00:00 | 0 |  |  |  |  |  |  |  |  | 0 | True
 | Strategic Assessment | 50000 | 2013-01-31 00:00:00 | 2013-03-31 00:00:00 | 50000 |  |  |  |  |  |  |  |  | 50000 | True
 | Concept | 800000 | 2013-03-31 00:00:00 | 2013-05-31 00:00:00 | 800000 |  |  |  |  |  |  |  |  | 800000 | True
 | Delivery Readiness |  | 2013-06-30 00:00:00 | 2016-11-30 00:00:00
 | Investigation, Detail Design & Documentation | 1289453 | 2013-06-30 00:00:00 | 2014-07-31 00:00:00 | 1289453 |  |  |  |  |  |  |  |  | 1289453 | True
 |  |  | 2016-11-30 00:00:00 | 2016-11-30 00:00:00 |  |  |  |  |  |  |  |  |  | 0
 | Property Acquisitions | 10001 | 2015-05-31 00:00:00 | 2015-09-30 00:00:00 | 10001 |  |  |  |  |  |  |  |  | 10001 | True
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Project Management | 128646.1 | 2013-06-30 00:00:00 | 2016-07-31 00:00:00 | 128646.1 |  |  |  |  |  |  |  |  | 128646.1 | True
 | Delivery | 18992433.58381266 | 2016-10-31 00:00:00 | 2018-02-28 00:00:00 |  | 1329470.350866886 | 2689283.491215554 | 2913390.44881685 | 4258032.194424627 |  |  |  |  | 18992433.58381266 | True | False
 | Finalisation | 188949.4 | 2018-02-28 00:00:00 | 2018-03-31 00:00:00 |  |  |  |  |  |  | 47237.35 | 141712.05 |  | 188949.4 | True
 | Total estimate Base Amount | 21459483.08381266 |  |  |  |  |  |  |  |  |  |  |  | 21459483.08381266 | True
 | Cash flow Base (Current $): |  |  |  | 1872116.885 | 1735453.565866886 | 2689283.491215554 | 2913390.44881685 | 4258032.194424627 | 4930353.067228516 | 2919141.38126023 | 141712.05 | 0 | 21459483.08381267 | True
 |  | True
Spreadsheet: af44c83c-c932-4437-8730-c4ad625f0539
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | Unnamed: 1 | Unnamed: 2 | 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
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2013/14 |  |  |  | 2012/13 |  |  |  | 2013/14 |  |  |  | 2012/13
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 15.2 |  | 6662 |  | 14.1 |  | 8176 |  | 17.4 |  | 2286 |  | 16.7 |  | 2680
September | 15.3 |  | 10015 |  | 13.9 |  | 9172 |  | 17.9 |  | 1331 |  | 17.9 |  | 1458
October | 15.4 |  | 10859 |  | 14 |  | 11843 |  | 15.6 |  | 655 |  | 17.6 |  | 2126
November | 15.3 |  | 6786 |  | 14.2 |  | 12815 |  | 15.3 |  | 457 |  | 18.1 |  | 3698
December | 15.5 |  | 8147 |  | 14.2 |  | 11326 |  | 15.7 |  | 3405 |  | 17.3 |  | 3934
January | 15.5 |  | 12226 |  | 14.5 |  | 13967 |  | 17.4 |  | 5119 |  | 17.7 |  | 4990
February | 15.8 | 1/ |  |  | 14.7 |  | 12939 |  | 20.2 | 1/ |  |  | 16.9 |  | 2471
March |  |  |  |  | 14.7 |  | 11117 |  |  |  |  |  | 17 |  | 3107
April |  |  |  |  | 14.8 |  | 9540 |  |  |  |  |  | 17.4 |  | 3981
May |  |  |  |  | 14.9 |  | 9097 |  |  |  |  |  | 18 |  | 2116
June |  |  |  |  | 15 |  | 7545 |  |  |  |  |  | 17.3 |  | 2284
July |  |  |  |  | 15 |  | 6508 |  |  |  |  |  | 17.2 |  | 2332
Average to date 2/ | 15.42857142857143 |  |  |  |  |  |  |  | 17.07142857142857
Season-average farm price | 15.30-15.90 | 3/ |  |  | 14.5 |  |  |  | 18.70-19.30 | 3/ 4/ |  |  | 17.4
Average marketings |  |  | 9115.833333333334 |  |  |  | 10337.08333333333 |  |  |  | 2208.833333333333 |  |  |  | 2931.416666666667
Total volume marketed |  |  | 54695 |  |  |  | 124045 |  |  |  | 13253 |  |  |  | 35177
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
4/ The medium/short-grain season-average- farm price ([NAME]) largely reflects rice that is marketed through
price pools in California. The pool price is not final until all the rice in the pool is marketed for the crop year.
Therefore, [NAME] forecasts based on the average of NASS monthly prices and the final price may differ.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated March 10, 2014.
Spreadsheet: e5a6f089-56e8-497e-acc8-b78ceb4f3f46
Sheet: Sheet1

DEBRECENI EGYETEM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TESTNEVELÉSI ÉS SPORTKÖZPONT
 | IGAZOLÁS
 | Hivatalosan igazolom, hogy a Debreceni Egyetem alábbi hallgatói a …………………………
 | …………………………………………………… sportegyesület [NAME], az egyesület
 | [NAME] rendszeresen versenyeznek és heti …… óra edzésen vesznek részt.
 |  | hallgató neve | kar | Neptun kód | [NAME]
 | 1.
 | 2.
 | 3.
 | 4.
 | 5.
 | 6.
 | 7.
 | 8.
 | 9.
 | 10.
 | Kelt: ……………………, 200… ………………hó …[NAME]
 | …………………………………………………..
 | [NAME] |  |  |  | P.H.
 | Telefonszám:
 | A versenysport kurzust a NEPTUN-ban fel [NAME]!                                                  Az igazolást a Debreceni [NAME] és [NAME] kell leadni a testnevelés elektronikus felvételének idejében.                                                     Egyetemi sportklubok esetén kérjük a technikai vezetőket, hogy e nyomtatványon összegyűjtve adják le a testnevelési felmentést kért hallgatók névsorát a tantárgyfelvételi időszakban. Nem egyetemi sportklubokban sportolóknak: i.) csatolni kell a verseny- vagy [NAME] (ha ilyen nincs, akkor érvényes sportorvosi igazolás vagy egyéb, a versenyzést igazoló dokumentum másolatát), ii.) [NAME] egy egyetemi sportrendezvényen igazoltan részt [NAME] ÉS megadott szinten [NAME] a testnevelő tanároknál a HUNGAROFIT próbát.
Spreadsheet: 717211d1612531664-how-to-count-just-numbers-in-the-second-column-which-are-not-the-same-mysheet
Sheet: Hárok1

 | Val
 | Dátum | nákladové | Prod. | [NAME] |  | 1.12.
 | 1.12. | 5034 | 2.5 | x
 | 2.12. | 5019 | 2 | x
 | 3.12. | 5021 | 2 | x
 | 2020-12-07 00:00:00 | 5034 | 2 | x
 | 2020-12-08 00:00:00 | 4338 | 4 | x
 | 2020-12-11 00:00:00 | 5028 | 1 | x
 | 2020-12-11 00:00:00 | 4317 | 1 | x
 | 2020-12-14 00:00:00 | 5029 | 3 | x
 | 2020-12-14 00:00:00 | 5090 | 1 | x
 | 2020-12-14 00:00:00 | 4339 | 2 | x
 | 2020-12-14 00:00:00 | 5034 | 1.5 | x
 | 2020-12-16 00:00:00 | 4329 | 3 | x
 | 2020-12-21 00:00:00 | 4332 | 2.5 | x
 | 2020-12-21 00:00:00 | 5101 | 1 | x
 | 2020-12-22 00:00:00 | 4346 | 1.5 | x
 | 2020-12-22 00:00:00 | 5090 | 1 | x
 | 2020-12-22 00:00:00 | 4319 | 1 | x
 | 2020-12-23 00:00:00 | 5020 | 4 | x
 | 2020-12-28 00:00:00 | 4326 | 7.5 | x
 | 2020-12-29 00:00:00 | 5301 | 1.5 | x
 | 2020-12-29 00:00:00 | 5102 | 2 | x
 | 2020-12-29 00:00:00 | 4326 | 3 | x
 | 2020-12-30 00:00:00 | 5019 | 1 | x
 | 1.12. | 5020 | 2 | x
 | 1.12. | 4011 | 3.5 | x
 | 3.12. | 4340 | 0.5 | x
 | 4.12. | 5019 | 2 | x
 | 4.12. | 4314 | 1 | x
 | 30.12. | 4106 | 1 | x
 | 30.12. | 4346 | 1.5 | x
 | 1.12. | 5029 | 1.5 | x
 | 2.12. | 5090 | 1 | x
 | 2.12. | 4103 | 0.5 | x
 | 2020-12-04 00:00:00 | 40 | 1 | x
 | 2020-12-07 00:00:00 | 4338 | 2 | x
 | 2020-12-09 00:00:00 | 5009 | 1 | x
 | 2020-12-10 00:00:00 | 4345 | 1 | x
 | 2020-12-10 00:00:00 | 4339 | 4 | x
 | 2020-12-10 00:00:00 | 5009 | 2 | x
 | 2020-12-11 00:00:00 | 4339 | 1 | x
 | 2020-12-16 00:00:00 | 4315 | 2 | x
 | 2020-12-16 00:00:00 | 4314 | 0.5 | x
 | 2020-12-16 00:00:00 | 4329 | 1 | x
 | 2020-12-18 00:00:00 | 4315 | 1 | x
 | 2020-12-18 00:00:00 | 40 | 0.5 | x
 | 2020-12-21 00:00:00 | 4339 | 5 | x
 | 2020-12-22 00:00:00 | 4339 | 4 | x
 | 2020-12-22 00:00:00 | 5020 | 1 | x
Spreadsheet: 697173d1601229876-index-match-formula-from-sales-data-worksheet-to-receivable-worksheet-excel-match
Sheet: SALES DATA

 | Date | Order Number | Customer Number | Name | VAT Number | Invoice | Product Number | Description | Unit Price | Quantity | Sub-total | Discount % | Discount | Amount | VAT % | VAT | Amount incl [NAME] | Payment Terms | Financial Category
 | 2020-01-01 00:00:00 | 1 | C006 | PANASHE | 100023012 | 6000 | 1001 | pine gel | 10000 | 1 | 10000 | 0.02 | 200 | 9800 | 0.15 | 1470 | 11270 | 5 | Sales
 | 2020-01-02 00:00:00 | 2 | C002 | TOMY | 0 | 6001 | 1002 | pine sanitiser | 10500 | 1 | 10500 | 0.02 | 210 | 10290 | 0.15 | 1543.5 | 11833.5 | 5 | Sales
 | 2020-01-03 00:00:00 | 3 | C003 | CRAIG | 0 | 6002 | 1003 | floor polish | 10000 | 1 | 10000 | 0.02 | 200 | 9800 | 0.15 | 1470 | 11270 | 5 | Machinery & Equipment
 | 2020-01-04 00:00:00 | 4 | C004 | YOLANDA | 100023015 | 6003 | 1004 | toilet cleaner | 10200 | 1 | 10200 | 0.02 | 204 | 9996 | 0.15 | 1499.4 | 11495.4 | 5 | Sales
 | 2020-02-05 00:00:00 | 5 | C005 | KIMBERLY | 100023016 | 6004 | 1004 | toilet cleaner | 10100 | 1 | 10100 | 0.02 | 202 | 9898 | 0.15 | 1484.7 | 11382.7 | 4 | Sales
 | 2020-02-06 00:00:00 | 6 | C001 | Jonea | 100023012 | 6005 | 1001 | pine gel | 10000 | 1 | 10000 |  | 0 | 10000 | 0.15 | 1500 | 11500 | 10 | Motor Vehicles
 | 2020-02-07 00:00:00 | 7 | C010 | THEMBA | 100023021 | 6006 | 1005 | tile cleaner | 20000 | 1 | 20000 | 0.1 | 2000 | 18000 | 0.15 | 2700 | 20700 |  | Office Appliances
 | 2020-02-08 00:00:00 | 8 | C001 | Jonea | 100023012 | 6007 | 1002 | pine sanitiser | 5000 | 2 | 10000 |  | 0 | 10000 | 0.15 | 1500 | 11500 |  | Sales
 | 2020-03-09 00:00:00 | 9 | C006 | PANASHE | 0 | 6008 | 1003 | floor polish | 3000 | 5 | 15000 | 0.02 | 300 | 14700 | 0.15 | 2205 | 16905 | 10 | Office Appliances
 | 2020-03-10 00:00:00 | 9 | C006 | PANASHE | 0 | 6008 | 1004 | toilet cleaner | 4000 | 6 | 24000 | 0.1 | 2400 | 21600 | 0.15 | 3240 | 24840 | 10 | Sales
Spreadsheet: 487261d1478003097-look-up-the-corresponding-number-for-the-min-smallest-value-book3
Sheet: lookup sheet

Part number | Strategic adjustment [in %]
1980009 | 0.03974999999999999
1980010 | 0.036
1980011 | 0.0585
1980019 | 0.054
1980023 | 0.0585
1980024 | 0.054
1980025 | 0.0465
1980026 | 0.0465
1980028 | 0.049875
1980029 | 0.03075
1980031 | 0.03075
1993700 | 0.02925
1993701 | 0.03525
1993702 | 0.036375
1993703 | 0.036375
1993704 | 0.0345
etc. | 0.036375
Spreadsheet: b1e7023a-5763-4452-9c39-c03b06713cf5
Sheet: Sheet1

Unnamed: 0 | Please fill in ONLY the yellow fields.  White fields are auto filled from previous sheet. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | FEDERAL EMERGENCY MANAGEMENT AGENCY |  |  |  | Page ____ | OF ______ | O.M.B. No. 3067-0151
 | MATERIAL SUMMARY SHEET |  |  |  |  |  | Expires October 31, 2008
 | APPLICANT | PA ID NO. |  | PROJECT NO. |  |  | DISASTER
 | LOCATION/SITE |  |  | CATEGORY |  |  | PERIOD COVERING
 |  |  |  |  |  |  |  | TO
 | DESCRIPTION OF WORK PERFORMED
 | VENDOR | [NAME] | QUAN. | UNIT PRICE | TOTAL PRICE | DATE PURCHASED | DATE USED | INFO FROM            (CHECK ONE)
 |  |  |  |  |  |  |  | INVOICE | STOCK
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  | GRAND TOTAL |  |  | 0
 | I CERTIFY THAT THE ABOVE INFORMATION WAS OBTAINED FROM PAYROLL RECORDS, INVOICES, OR OTHER DOCUMENTS THAT ARE AVAILABLE FOR AUDIT.
 | CERTIFIED |  | TITLE |  |  |  | DATE
 | FEMA Form 90-124, OCT 02
 | PAPERWORK BURDEN DISCLOSURE NOTICE
 | Public reporting burden for this form is estimated to 15 minutes per response.  The burden includes the time for reviewing instruction, searching existing data sources, gathering and maintaining the needed data, and completing, reviewing, and submitting the form.  You are not required to respond to this collection of information unless a valid OMB control number appears in the upper right corner of this form.  Send comments regarding the accuracy of the burden estimate and any suggestions for reducing this burden to: Information Collections Management, Federal Emergency Management Agency, 500 C Street, SW, Washington, DC 20472, Paperwork Reduction Project (3067-0151).  Submission of the form is required to obtain or retain benefits under the Public Assistance Program.  Please do not send your completed form to the above address.
Spreadsheet: chris_germany__2334__CGULF_newalb_confirms_Mar_2001
Sheet: to CGULF Pipeline

ENRON POWER MARKETING INC.
PROJECTED BURN RATES
NEW ALBANY
GAS NOMINATIONS
 |  | GAS | GAS
 | DATE | NOMINATED | REQUIREMENT
 |  | Navigator | ESTIMATE | LONG / SHORT | BALANCE
 |  |  |  |  | 14000
 |  | 0 | 0
 |  | 4000 | 2838
 |  | 0 | 0
 |  | 0 | 0
GAS FLOW ESTIMATES
 |  |  | ESTIMATED | ESTIMATED
 |  | TOTAL EST | TOTAL FLOW | HRLY RATE | ESTIMATED
 | DATE | FLOW HRS | QUANTITY | MMMBTU/HOUR | FLOW HRS
 |  | 0 |  | 0 | 10:00am - 2:00pm
 |  | 0 |  | 0 | 9:00am - 10:00pm
 |  | 0 |  | 0 | 7:00pm - 10:00pm
 |  | 4 |  | 709.5 | 10:00am - 2:00pm
 |  | 0 |  | 0 | 12:00pm - 2:00pm
 |  | 0 |  | 0 | 12:00pm - :00pm
 |  | 0 |  | 0 | 9:00am - 11:00am
 |  | 0 |  | 0 | 12:00pm - 2:00pm
 |  | 0 |  | 0 | 6:00am - 9:00am
CONTACT:    [NAME] |  |  | [PHONE]  office |  | DATE / TIME
 |  |  | [PHONE]  pager
[NAME] |  |  | [PHONE]  office |  | Power Control Room (24 hr)
 |  |  | [PHONE]  pager |  |  | [PHONE]
Spreadsheet: 772275d1647164505-find-and-count-exact-match-rotation_point_system
Sheet: Rotation

 | Name | Numbers 1 -2 | Numbers 3 - 4 | Numbers 5 - 6 | Numbers 6 - 8 | Numbers 9 - 11
 | [NAME]
 | [NAME]
 |  | Cell C4 should equal 3 minus 1 (due to MWJCA_Scoresheets!C2 being empty). Therefore, in the end equals to 2 |  | Cell E5 should equal 1 minus 1 (due to MWJCA_Scoresheets!C14 being empty. Therefore, in the end equals to 0 which I want that to be an empty cell | Cell F5 should equal 1 minus 1 (due to MWJCA_Scoresheets!C34 being empty. Therefore, in the end equals to 0 which I want that to be an empty cell
Spreadsheet: 722820d1615419962-highlighting-multiple-duplicates-based-on-two-columns-highlighting-duplicates
Sheet: Sheet

Lookup | List
[NAME] | [NAME]
Fred | [NAME]
[NAME] | [NAME] |  |  | Anything in 'List' (Col B) that matches any of the lookups (Col A) highlight it
Mark | [NAME] |  |  | If there is no match, leave the cell as is
 | [NAME]
 | Fred
 | Fred
 | Fred
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Mark
 | Mark
 | Mark
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 702861d1604578113-finding-second-different-value-in-column-test
Sheet: Sheet1

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
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 18 - table 1

Reconciliation - Profit to EBITDA | 3Q10 | 3Q11 | YTD 10 | YTD 11
Profit - Ambev holders | 1815.162 | 1687.263000000001 | 4975.598999999998 | 5608.504000000002
Non-controlling interest | 12.51 | 16.575 | 30.858 | 47.06999999999999
Income tax expense | 515.876 | 620.7969999999999 | 1513.984 | 1581.003
Profit before taxes | 2343.548000000001 | 2324.635000000001 | 6520.440999999999 | 7236.577000000001
Share of results of associates | -0.074 | -0.119 | -0.027 | -0.228
Net finance results | -48.111 | 306.342 | 244.013 | 377.1849999999999
Special items | 2.654 | -41.888 | 84.297 | -36.596
Normalized EBIT | 2298.017000000001 | 2588.970000000001 | 6848.723999999998 | 7576.938000000002
Depreciation & amortization - total | 357.386 | 363.836 | 1070.632 | 1058.003
(-) Depreciation & amortization - special items | 0.237 | 0 | -34.327 | 0
Normalized EBITDA | 2655.640000000001 | 2952.806 | 7885.028999999998 | 8634.941000000003