tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 455488d1460373937-applying-an-if-formula-in-regards-to-multiple-columns-for-excel-forum
Sheet: Overview Sheet 2016

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Visits
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 Visits
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Visit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 Visits
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 Visits
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 Visits
 |  | Ship Visit Monitoring Sheet - 2016 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compliant
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SMS Compliant
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supt Visits |  |  |  | Tracker does not include visits from FSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compliance |  |  | Ship Manager Visits |  |  |  | Tracker does not include IA02'
 | FG | Ship | In Management from Year Start | Senior Management | Marine Super Visit | No. of Visits | NMM Comp | SMS Comp | Sailing Visit |  |  | Ship Manager Visit |  | NMM Comp |  | SMS |  | Sailing Visits
 | 1 |  | Y |  | N
 | 1 |  | Y |  | N
 | 1 |  | Y |  | N
 | 1 |  | Y |  | N
 | 2 |  | Y |  | N
 | 2 |  | Y |  | N
 | 2 |  | Y |  | N
 | 2 |  | Y |  | N
 | 2 |  | Y |  | N
 | 2 |  | Y |  | N
 | 3 |  | Y |  | N
 | 3 |  | Y |  | N
 | 3 |  | Y |  | N
 | 3 |  | Y |  | N
 | 3 |  | Y |  | N
 | 3 |  | Y |  | N
 | 3 | Sample End Result based on conditions in Sheet 2 | Y |  | N
 | 3 |  | Y |  | N
 | 3 |  | Y |  | N
 | 3 |  | Y |  | N
 | 4 |  | Y |  | N
 | 4 |  | Y |  | N
 | 4 |  | Y |  | N
 | 4 |  | Y |  | N
 | 4 |  | Y |  | N
 | 4 |  | Y |  | N
 | 4 |  | Y |  | N
 | 4 |  | Y |  | N
 | 5 |  | Y |  | N
 | 5 |  | Y |  | N
 | 5 |  | Y |  | N
 | 5 |  | Y |  | N
 | 6 |  | Y |  | N
 | 6 |  | Y |  | N
 | 6 |  | Y |  | N
 | 6 |  | Y |  | N
 | 6 |  | Y |  | N
 | 6 |  | Y |  | N
 | 6 |  | Y |  | N
 | 7 |  | Y |  | N
 | 7 |  | Y |  | N
 | 7 |  | Y |  | N
 | 7 |  | Y |  | N
 | 7 |  | Y |  | N
 | 7 |  | Y |  | N
 | 7 |  | Y |  | N
 | 8 |  | Y |  | N
 | 8 |  | Y |  | N
 | 8 |  | Y |  | N
 | 8 |  | Y |  | N
 | 8 |  | Y |  | N
 | 8 |  | Y |  | N
 | 8 |  | Y |  | N
 | 9 |  | Y |  | N
 | 9 |  | Y |  | N
 | 9 |  | Y |  | N
 | 9 |  | Y |  | N
 | 9 |  | Y |  | N
 | 9 |  | Y |  | N
 | 9 |  | Y |  | N
 | 9 |  | Y |  | N
 | 10 |  | Y |  | N
 | 10 |  | Y |  | N
 | 10 |  | Y |  | N
 | 10 |  | Y |  | N
 | 10 |  | Y |  | N
 | 11 |  | N |  | N
 | 11 |  | N |  | N
 | 11 |  | Y |  | N
 | 11 |  | Y |  | N
 | 11 |  | Y |  | N
 | 12 |  | Y |  | N
 | 12 |  | y |  | Y
 | 12 |  | N |  | N
 | 12 |  | N |  | N
 | 12 |  | N |  | N
 | 12 |  | N |  | N
 | 12 |  | N |  | N
 | 12 |  | N |  | N
 | 12 |  | N |  | N
 | 12 |  | N |  | N
 | H |  | Y |  | N
 | H |  | Y |  | N
 | H |  | Y |  | N
 | S |  | Y |  | N
 | S |  | Y |  | Y
 | S |  | Y |  | N
 | S |  | Y |  | N
 | S |  | Y |  | N
 |  | Total in Management from Year Start
Spreadsheet: 703106d1604757020-calculate-cumulative-sums-and-obtain-highest-value-based-on-it-example1935-updated
Sheet: Output

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Selected year:
 | Cumulative highest volumes processed (All-Time) - By Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020
 |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Highest
 | Data1 |  |  |  |  |  |  | (a) |  |  |  |  |  |  |  |  |  |  | (c)
 | Agent: |  |  |  |  |  |  | (b) |  |  |  |  |  |  |  |  |  |  | (d)
 | Data2
 | Agent:
 | Cumulative highest volumes processed (selected year)
 |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Data1 |  |  |  |  | (e) |  |  |  | (g)
 | Agent: |  |  |  |  | (f) |  |  |  | (h)
 | Data2
 | Agent:
 | I have a total of 7 data fields.
 | For this example I will only display 2, and replicate for others myself
 | Examples on what the cells should show (from the source table, the row that has "TOTAL" is always ignored):
 | (a) the highest Data1 value, after calculating the sum of all Data1 values for each Agent, when the [Month] column has the phrase in I5 ("[NAME]")
 | (b) the name of the agent that achieved (a)
 | (c) the highest Data1 value, after calculating the sum of all Data1 values for each Agent
 | (d) the name of the agent that achieved (c)
 | (e) the highest Data1 value, when [Month] matches [[NAME]," ",G17)]
 | (f) the name of the agent that achieved (e)
 | (g) the highest Data1 value when the Jan+Feb+Mar+Apr+May values are added, for the selected year (W3)
 | (h) the name of the agent that achieved (g)
Spreadsheet: 41191d1239713074-working-with-lookups-lookup-macro
Sheet: register

BENEFIT REF ENTER FIRST 8  DIGITS | MEM NO | NAME | DAY DUE | MONTHLY  LOAN AMOUNT | MONTHLY SAVINGS AMOUNT | AMOUNT | KEEP | RELEASE
TW000927 | 97991 | [NAME] | TUES | 60 | 26 | 371 | 86 | 285
PA00005 | 97935 | C BENSON | TUES | 106 | 5 | 28.7 | 27.75 | 0
JS000014 | 98698 | L FUTURE | TUES | 95 | 5 | 66.69 | 25 | 41
N0000031 | 98752 | W BENSON | TUES | 55 | 5 | 82.48 | 15 | 67
Y1111118 | 98760 | J   ROWE | TUES | 71 | 5 | 124.9 | 38 | 86
Y1111119 | 8775 | T REAY | TUES | 63 | 5 | 32.69 | 17.69 | 15
TW000927 | 97991 | [NAME] | TUES | 0 | 0 | 96.8 | 0 | 96
Spreadsheet: 13e3a453-2456-4078-9942-9801dca46a4f
Sheet: Sheet1

Unnamed: 0 | BALLOTS CAST/SUMMARY BY COUNTIES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
2004-01-27 00:00:00 | Republican |  |  |  | Democratic
 | Regular | Absentee | Total |  | Regular | Absentee | Total
Belknap | 3689 | 260 | 3949 |  | 8577 | 542 | 9119
Carroll | 2937 | 236 | 3173 |  | 7484 | 483 | 7967
Cheshire | 3715 | 137 | 3852 |  | 14381 | 703 | 15084
Coos | 1747 | 90 | 1837 |  | 5451 | 256 | 5707
[NAME] | 4384 | 305 | 4689 |  | 14958 | 1080 | 16038
Hillsborough | 19278 | 798 | 20076 |  | 60579 | 2924 | 63503
Merrimack | 9110 | 371 | 9481 |  | 26054 | 1488 | 27542
Rockingham | 14352 | 781 | 15133 |  | 45836 | 2248 | 48084
[NAME] | 4687 | 213 | 4900 |  | 19665 | 906 | 20571
[NAME] | 2231 | 93 | 2324 |  | 7277 | 417 | 7694
TOTALS | 66130 | 3284 | 69414 |  | 210262 | 11047 | 221309
*corrected 1/10/05--Exeter, Milford
Spreadsheet: 674781d1588012060-determine-if-a-geo-location-is-within-geographic-area-lat_long_example
Sheet: Areas

 |  | Boundaries
 | Area | Lat | Long | Lat | Long | Lat | Long | Lat | Long | Lat | Long
 | 1 | 38.865459 | -77.058492 | 38.864902 | -77.054409 | 38.859975 | -77.053592 | 38.86063 | -77.059627 | -77.058492 | 38.864902
 |  | ,
Spreadsheet: 878252d1725307126-cell-referencing-and-colloborating-data-sept-9-3
Sheet: Daily Summary

WorkCenter | Bag Type (choose one) | Product Type (choose one) | Length | [NAME] | Target BPM | Actual BPM | Scrap (LBS) | ZAHN INK (seconds) | Hourly Total Uptime | [NAME] | Downtime/HR (mins) | Reason for Unplanned downtime/Scrap
Spreadsheet: 940da98f-2465-4f15-b7d7-2bac0d6851b7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TAB | Test | TAB | Thyroid Autoantibodies Profile, Serum | Thyroid Autoantibodies Profile, S | TPO/81765: Immunoenzymatic Assay TGAB/84382: Electrochemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1.5 mL Additional Information: If thyroglobulin tumor marker testing is desired, order HTG1/83069 [NAME], Tumor Marker, Serum. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | THYROPEROXIDASE ANTIBODIES <9.0 IU/mL Reference values apply to all ages.  THYROGLOBULIN ANTIBODY <116 IU/mL Reference values apply to all ages. | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | 1 day | 3 days |  | Profile |  |  |  |  | Rochester
TAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TAB | Component | TPO | Thyroperoxidase (TPO) Antibodies, Serum | [NAME], S | Immunoenzymatic Assay | Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube: Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | <9.0 IU/mL Reference values apply to all ages. | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | 1 day | 3 days | 1 | 86376 |  |  | Yes | Yes
TPO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TPO | Result | TPO | [NAME], S | [NAME], S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 8099-4
TAB | Component | TGAB | [NAME], Serum | [NAME], S | Electrochemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Additional Information: If thyroglobulin tumor marker testing is desired, do not order this test. Instead, order HTG1/83069 [NAME], Tumor Marker, Serum, which includes both thyroglobulin and [NAME]. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | <116 IU/mL Reference values apply to all ages. | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 86800 |  |  | Yes | Yes
TGAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TGAB | Result | TGAB | [NAME], S | [NAME], S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 8098-6
Spreadsheet: 697929d1601623137-ranking-based-on-criteria-test
Sheet: Test

 |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-04 00:00:00
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  | * Ranking is needed for only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.44 | Urgent | 2020-05-11 00:00:00
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 |  | 1
CTR_06 | 3.4 | Urgent | 2020-04-09 00:00:00
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  | 2
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 3
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 3
Spreadsheet: 178495d1346811982-shipment-plan-and-delivery-order-dummy
Sheet: SHIPMENT PLAN

NO | CUSTOMER | [NAME] | QUANTITY
1 | A |  |  |  | Today customer A might purchase more than 1 items (maybe 10 or more) and each items also have its own quantity for instance A want to buy 12 chickens, 4 samsung galaxy s3, 8 iPhone 5 and 3 mercedes benz. The problems is, there is only one cell to fill it up and after that, all the A's purchasing must be in the Delivery order automatically. [NAME] that, i must be able to edit the purchasing if there is any mistakes in A's order and A might come back to buy more. is there any way to do that? maybe a referrence sheet.
2 | B
3 | C
4 | D
5 | E
6 | F
7 | G
8 | H
9 | I
10 | J
11 | K
12 | L
13 | M
14 | N
15 | O
16 | P
17 | Q
Spreadsheet: 235562d1368540608-filtering-based-on-criteria-example
Sheet: Sheet2

Target Language
Albanian
Bangla
Greek
Korean
Slovak
Czech
Asante
[NAME]
Turkish
Burmese
Mandarin
Bengali
Finnish
Nepalese
Tigre
Japanese
Spanish
Lithuanian
Farsi
Gujerati
Vietnamese
Somali
Dari
French
Kurdish (Sorani)
Tigrinya
Kurdish
Hungarian
Italian
Creole
Portuguese
Polish
Afghani (Dari)
Chinese
Tagalog
Gujarati
Cypriot-Greek
Cantonese
Thai
Lugandan
Mongolian
Kurdish (Kurmanji)
Armenian
Amharic
Kinyarwanda
Romanian
Nepali
[NAME]
Pangasinan
Arabic
Russian
Telugu
Urdu
Portuguese (Brazil)
Mirpuri
Punjabi
Sylheti
Latvian
Bulgarian
Pashto
Kurdish(Bahdini)
Swahili
PortugueseCreole
German
Farsi (Persian)
Gorani
Arabic (Libanese)
Indonesian
Kibajuni
Persian
Farsi (Afghan)
Arabic (Syrian)
Zulu
Khmer
Fulani
Spreadsheet: 163648d1340386110-sorting-numbers-combined-with-text-genericprojectlist
Sheet: Sheet1

CEA# | Production? | New/Used | Description
1301 | 1 | U | Test1
1302 | 1 | U | Test2
1303 | 1 | U | Test6
1304 | 1 | U | Test6
1305 | 1 | U | [NAME]
1306 | 1 | U | Test8
1303a | 1 | U | Test3
1303b | 1 | U | Test4
1303c | 1 | U | Test5
Spreadsheet: phillip_platter__31369__scids10012001
Sheet: Sheet1

ALLEC | APX5
ALLEG | APX5
ALLEGHENEN | APX5
ALLEGHENPO | APX5
ALPOW | APX5
ALPS | APX5
AMERELECPO | AEPS
ANAHEIM | ANHM
APS | APS1
AQUILACORP | AQPC
ATLANTICRI | EPMI
AUTOMATEPO | APX1
AVISTAENE | AEI1
AVISTAWWPS | EPMI
AXIAENELP | [NAME]
AZUSA | AZUA
BPENERGYCO | APX1
BURB | RVSD
CALIFORNIM | EPMI
CALIFORNPX | PXC5
CALPINE | [NAME]
CALPINEENE | [NAME]
CALPX | PXC5
CALPXSC | PXC5
CALSUP | EPMI
CARGILLALL | CAL1
CCT | EMMT
CDWR | CDWR
CERS | CERS
CINERGY | APX1
CITPOW | EMMT
CITYBAN | BAN1
CITYRIVERS | RVSD
CITYROS | NCPA
CITYSHALAK | WAMP
CONSTELLPO | CPSC
CORAL | CRLP
CRC | EPMI
DAVISWIRCO | EPMI
DELANOENEC | EPMI
DELANOSUP | EPMI
DUKEENETRA | DETM
DYNEGYMARA | ECH1
[NAME] | ECH1
EASTBAYMUN | APX1
EDISONMISM | EMMT
EESI | EES1
ENRONENEMA | EPMI
EPE | EPME
EPME | EPME
EPMI | EPMI
EPMICALPOO | EPMI
EPMI-LT-CA | EPMI
EPMI-LT-NW | EPMI
EPMI-LT-SW | EPMI
EPMI-LT-WE | EPMI
EPMI-LT-WT | EPMI
EPMI-ST-CA | EPMI
EPMI-ST-NW | EPMI
EPMI-ST-PL | EPMI
EPMI-ST-SW | EPMI
EPMI-ST-WB | EPMI
EPMI-ST-WH | EPMI
EPPS | EPME
EXELONGENC | PECO
FIRSTPOICA | EPMI
FP&L | APX1
FPLENEPOW | APX1
GASRECSYS | APX1
GLEN | GLEN
HAFSLUNDEN | HFET
HARBORCOG | EPMI
HARBORSUP | EPMI
HETCH | CDWR
IDACORP | IDAC
IDACORPENE | IDAC
IPC | IDAC
[NAME] | [NAME]
LOSANGELWATPOW | LDWP
LOUISIANAP | EPMI
MERCHANTEN | APX4
MERRILL | APX1
METROPOLWA | EPMI
MID | MID1
MIECO | MIEC
MONTANA | EPMI
MSCAPGP | APX4
NCPA | NCPA
NEVP | SPPC
NEWENERGY | NEI1
NEWPOWER | APX1
NORTHERNCA | NCPA
NRGPOWMAR | APX1
OAKLANDMUN | NCPA
PACE | PAC1
PACIFICOPO | PCPM
PALOALTOCI | NCPA
PECO | PECO
PG&E | PCG1
PG&EENESER | ENRONENEMA
PGET | PETP
PILOTPOWGR | EPMI
PINNACLEWE | APS1
PNM | [NAME]
PSC | PSCO
PSPL | PSE1
PWX | PWRX
REDDING | WRDG
RESI | NES1
SCEM | SCEM
SDG&E | SDG3
SEMP | SETC
SIERRAPACHOL | APX1
SIERRAPOWC | EPMI
SMUD | APX3
SNCL | SNCL
SOCALED | SCE1
SPP | EPMI
SRP | SRP1
STAT | CPSC
STRATEGENE | SEL1
TEMI | APX1
TID | EPMI
TOSCORFNGC | EPMI
TOSCOSUP | EPMI
TRANSALT | APX1
VALLEY | EPMI
VERNON | VERN
WAMP | SEL1
WAPADESERT | SCE1
WAUM | PGAE
WESCO | WESC
WHEELABRMA | EPMI
WHEELABRSH | EPMI
Spreadsheet: 799054d1664895614-excel-dependent-list-cutter-length1
Sheet: list sheet

[NAME] | Multicutter 3 Blade | MC3000 [NAME] | MC3000 6 Blade | MC5000 2 Blade | MC5000 6 Blade
950 | 950 | 900 | 900 | 900 | 900
1400 | 1400 | 1450 | 1450 | 1450 | 1450
1725 | 1725 | 1750 | 1750 | 1750 | 1750
2900 | 2900 | 2900 | 2900 | 2900 | 2900
[NAME] | Multicutter 3 Blade | MC3000 [NAME] | MC3000 6 Blade | MC5000 2 Blade | MC5000 6 Blade
2 | 3 | 2 | 6 | 2 | 6
Trim length before cut
trim length after cut | = sum  of [list sheet (B12)] / number of blades [list sheet(B10:E10)] x RPM [Cutter sheet (H20)]
Spreadsheet: 214989d1361218342-how-to-create-a-packing-list-from-a-distribution-list-blist
Sheet: Template

Books List
College ID:
College:
Address:
Books | Quantity
A guide to walking
Running in the Park
Night and Day
[NAME]
School Days
Final Warning
Culture and Society
Spreadsheet: 672218d1586795905-ranking-without-duplicates-without-skipping-numbers-sample_new_1stmarch
Sheet: Runners

Date | Meeting | Time | H/Cap | Class | Age | Code | Dist | Run | Type1 | Type2 | [NAME] | No | Horse | Form | Grade | Distance | Going | Speed | Rating | RTD | Won | Odds | Returns | Draw | Trainer | [NAME] | Distance |  | Going | Top5 | Speed | Top5 | CD | Prize | BHA | WT | DSLR | Age | Cr | Cl | Lm | To | Draw% | RS | [NAME] | Rank | LTO | Rank | Days | Ave | MA | Rank | Diff | Cse | Dist | Abiliy | Form | F/C | HForm | Prize | BHA | [NAME] 3 | Trainer 4/5 | [NAME] | Jocks 4/5 | T14 | J14
Spreadsheet: 685573d1594087790-vlookup-or-if-schedule-trial
Sheet: Sheet1

[NAME]
Site A |  | Week 1 | Week 2 | Week 3
Spot 1 |  | Smith | [NAME] | Smith
Spot 2 |  | [NAME] | [NAME] | [NAME]
Site B
Spot 1 |  | Doe | Smith | Doe
Spot 2 |  | [NAME] | [NAME]
Site C
Spot 1 |  | [NAME] | Doe
Spot 2
Person |  | Week 1 | Week 2 | Week 3
Smith |  | Site A | Site B
[NAME] |  | Site B | Site A
[NAME] |  | Site A | Site A
Doe |  | Site B | Site C
[NAME] |  | Site C | Site B
Lead
Tech
Spreadsheet: thomas_martin__39861__Natural Gas Netco Budget1
Sheet: Natural Gas Orig

 | Natural Gas Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 11
 |  |  |  |  |  |  |  | Director | 143000 | 14
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 6
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 1cc96c5d-e97a-4d4e-9174-7ff84ff362fe
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44302348 | 2014-12-04 18:06:01 | AXIS | 0 | 5 | 6 | 1087185 | [NAME] | 12503 | eastern | 1941-07-22 | 1941-07-22 | Lipovec | Lipovec
44316995 | 2014-12-05 19:40:20 | ALLIES | 0 | 0 | 5 | 1087185 | [NAME] | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
44317237 | 2014-12-05 19:53:14 | AXIS | 1 | 5 | 2 | 1087185 | [NAME] | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
44317495 | 2014-12-05 20:35:45 | ALLIES | 0 | 5 | 6 | 1087185 | [NAME] | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
44317860 | 2014-12-05 21:00:33 | AXIS | 1 | 6 | 4 | 1087185 | [NAME] | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
44318205 | 2014-12-05 21:32:59 | AXIS | 0 | 3 | 6 | 1087185 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44318566 | 2014-12-05 21:50:16 | ALLIES | 0 | 4 | 6 | 1087185 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44335838 | 2014-12-07 01:47:38 | ALLIES | 0 | 4 | 6 | 1077170 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44336079 | 2014-12-07 02:09:41 | AXIS | 1 | 6 | 4 | 1077170 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44414106 | 2014-12-12 19:53:15 | ALLIES | 0 | 1 | 6 | 1087185 | [NAME] | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
44414336 | 2014-12-12 20:07:58 | AXIS | 1 | 6 | 0 | 1087185 | [NAME] | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
44414671 | 2014-12-12 20:40:55 | AXIS | 0 | 4 | 6 | 1087185 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
44414894 | 2014-12-12 21:04:04 | ALLIES | 1 | 6 | 2 | 1087185 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: 59479d1259964634-vlookups-linking-together-newer-copy
Sheet: contacts

 | Contact 1 | Contact 2 | Contact 3 | Contact 4 | Contact 5 | Contact 6 | Contact 7 | Contact 8
Client 1 | Caroline Devereux
Client 2 | [NAME]
Client 3 | Geoff Eade | Stuart Eade
Client 4 | [NAME]
Client 5 | [NAME]
Client 6 | [NAME]
Client 7
Client 8 | [NAME] | [NAME]
Client 9
Client 10 | [NAME]
Client 11 | [NAME] | [NAME]
Client 12 | [NAME] | [NAME]
Client 13 | [NAME]
Client 14 | [NAME]
Client 15
Client 16 | [NAME] | [NAME]
Client 17 | [NAME] | [NAME]
Client 18 | [NAME]
Client 19
Client 20
Client 21
Client 22 | [NAME]
Client 23
Client 24 | [NAME]
Client 25 | [NAME] | [NAME]
Client 26 | [NAME] | [NAME]
Client 27
Client 28
Client 29
Client 30
Client 31
Client 32
Client 33
Client 34
Client 35
Client 36
Client 37
Client 38
Client 39
Client 40
Client 41
Client 42
Client 43
Client 44
Client 45
Client 46
Client 47
Client 48
Client 49
Client 50
Client 51
Client 52
Client 53
Client 54
Client 55
Client 56
Client 57
Client 58
Client 59
Client 60
Spreadsheet: 151591d1334997075-excel-2007-vlookup-with-option-to-pull-additional-value-if-blank-wip2
Sheet: Customer Location

Customer Account | Name | State
C10000 | MEH | FILL ME IN
C10001 | MEHH | FILL ME IN
C10002 | MEHHH | [NAME]
C10003 | MEHHHH | Q
C10004 | JEH | W
C10005 | JEHH | Q
C10006 | [NAME] | V
C10007 | JEHHHH | V
C10008 | NEH | N
C10009 | NEHH | N
C10010 | NEHHH | V
C10011 | NEHHHH | Q
Spreadsheet: 151361d1334871071-formula-for-comparing-rows-samplefile
Sheet: Ark1

5 | 10 | 11 | 16 | 24 | 26 | 27 | 1 | 18 | 23
2 | 7 | 8 | 17 | 20 | 21 | 24 | 13 | 25 | 26
1 | 18 | 22 | 23 | 24 | 26 | 32 | 5 | 25 | 28
2 | 9 | 11 | 13 | 18 | 21 | 27 | 15 | 26 | 34
1 | 7 | 17 | 20 | 24 | 33 | 34 | 11 | 21 | 26
6 | 10 | 12 | 21 | 23 | 25 | 33 | 2 | 7 | 19
13 | 19 | 20 | 21 | 28 | 29 | 31 | 7 | 14 | 23
4 | 6 | 11 | 23 | 25 | 26 | 32 | 2 | 22 | 34
4 | 9 | 15 | 25 | 27 | 29 | 30 | 5 | 23 | 26
2 | 20 | 21 | 27 | 28 | 31 | 34 | 6 | 12 | 13
2 | 13 | 15 | 21 | 24 | 27 | 34 | 1 | 7 | 12
2 | 6 | 14 | 18 | 24 | 28 | 34 | 3 | 10 | 12
4 | 6 | 10 | 11 | 12 | 24 | 34 | 14 | 19 | 26
2 | 6 | 10 | 18 | 25 | 28 | 30 | 4 | 9 | 21
5 | 21 | 23 | 24 | 25 | 27 | 33 | 7 | 13 | 26
6 | 10 | 13 | 15 | 19 | 21 | 24 | 16 | 26 | 34
8 | 9 | 10 | 12 | 26 | 28 | 29 | 14 | 25 | 31
6 | 8 | 12 | 19 | 21 | 29 | 33 | 2 | 14 | 26
3 | 4 | 6 | 18 | 19 | 23 | 32 | 8 | 9 | 24
6 | 13 | 17 | 19 | 23 | 27 | 33 | 9 | 18 | 25
2 | 8 | 11 | 16 | 25 | 27 | 31 | 18 | 23 | 24
8 | 16 | 17 | 30 | 32 | 33 | 34 | 5 | 7 | 31
1 | 4 | 5 | 6 | 22 | 25 | 33 | 19 | 24 | 26
4 | 6 | 8 | 18 | 23 | 28 | 31 | 10 | 11 | 32
5 | 9 | 12 | 20 | 30 | 32 | 33 | 7 | 11 | 19
8 | 10 | 15 | 18 | 21 | 24 | 25 | 17 | 19 | 29
3 | 7 | 11 | 15 | 26 | 30 | 32 | 25 | 27 | 33
4 | 14 | 18 | 20 | 23 | 33 | 34 | 2 | 17 | 19
1 | 4 | 7 | 9 | 14 | 20 | 34 | 15 | 27 | 28
2 | 14 | 17 | 19 | 21 | 22 | 28 | 10 | 13 | 26
Spreadsheet: 750095d1633252838-time-to-replenish-stock-replenish-ans
Sheet: Sheet1

 | Starting Time
 | Time Interval
 |  | Product A
 | Starting Capacity | 80
 | Price | 1
 | No. of Units Sold
 | Time taken to be sold out
 | Sales Revenue
 |  |  |  |  |  | Probability | No. of Product A | Cumulative Probability
 |  |  |  |  |  | 0.15 | 0 | 0
 | Time | No. of Product A Purchased | No. of Product A Left |  |  | 0.25 | 1 | 0.15
 | 09:45:00 | 0 |  |  |  | 0.35 | 2 | 0.4
 |  |  |  |  |  | 0.25 | 3 | 0.75