tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 472442d1469601777-how-to-search-filter-data-by-various-basis-from-other-sheets-syllabus-book-with-sample-result-
Sheet: ME DEPT

FILTER TITLE | FILTER VALUE | COURSE CONTENTS
Department | ME | NNN
Level | 1
Term | 1
Subject | Physics
Subject Code | Phy 131
[NAME] | Structure of Matter
Credit Hour | 3
Contact Hour | 3
Department | ME | PPP
Level | 1
Term | 1
Subject | Chemistry
Subject Code | Chem 133
[NAME] | Inorganic Quantitative Analysis
Credit Hour | 2
Contact Hour | 2 |  |  |  | Waves and oscillations: differential equation of a simple harmonic oscillator, total energy and average energy, combination of simple harmonic oscillations, Lissajous figures, spring-mass system, calculation of time period of torsional pendulum, damped oscillation, determination of damping co-efficient; forced oscillation, resonance, two-body oscillations, reduced mass, differential equation of a progressive wave, power and intensity of wave motion, stationary wave, group velocity and phase velocity, architectural acoustics, reverberation and Sabine's formula.
Department | ME | RRR
Level | 1
Term | 2
Subject | Accounting
Subject Code | Acc 135
[NAME] | Principles of Accounting
Credit Hour | 3
Contact Hour | 3
Department | ME | TTT
Level | 1
Term | 2
Subject | Economics
Subject Code | Eco 137
[NAME] | Engineering Economics
Credit Hour | 2
Contact Hour | 2
Spreadsheet: 685761d1594186016-matching-cells-to-return-a-division-of-a-value-based-on-the-number-of-cell-matched-order-list
Sheet: Sheet1

Order Number | Item | Shipment Type | Shipping Fee |  |  | I'm trying to find a formula to identify the shipment type and allocate the correct shipping fee.
1000000000001 | Apple | [NAME] | 2
2000000000002 | Apple | Company A: Postage with Tracking | 3.33 |  |  | On top of that, i need to identify those with the same order number as the shipping fees are split among them.
2000000000002 | Orange | Company A: Postage with Tracking | 3.33 |  |  | Standard postage = $2
2000000000002 | Pear | Company A: Postage with Tracking | 3.33 |  |  | Company A Postage = $10
3000000000003 | Mango | Company A: Postage with Tracking | 10 |  |  | Company B Postage = $10
4000000000004 | Peach | Company A: Postage with Tracking | 10
5000000000005 | Apple | Company B: Postage with Tracking | 5 |  |  | If there are 2 items in 1 order number, fee is split at $5 each.
5000000000005 | Mango | Company B: Postage with Tracking | 5 |  |  | If there are 3 items in 1 order number, fee is split at $3.33 each.
Total
Alternatively
[NAME] Id | Item | Shipment Type | Shipping Fee
1000000000001 | Apple | [NAME] | 2
2000000000002 | Apple | Company A: Postage with Tracking | 10
2000000000002 | Orange | Company A: Postage with Tracking | [Blank]
2000000000002 | Pear | Company A: Postage with Tracking | [Blank]
3000000000003 | Mango | Company A: Postage with Tracking | 10
4000000000004 | Peach | Company A: Postage with Tracking | 10
5000000000005 | Apple | Company B: Postage with Tracking | 10
5000000000005 | Mango | Company B: Postage with Tracking | [Blank]
Total
Spreadsheet: 782363d1654003380-return-first-column-and-first-row-based-on-2-criteria-sample052
Sheet: MAY

 | [NAME] | [NAME] | [NAME] | [NAME] | Mark | Molly | [NAME]
2022-05-01 00:00:00 | V | V | V | O | O | R | R
2022-05-02 00:00:00 | T | O | T | T | D | W | O
2022-05-03 00:00:00 | S | W | X | X | O | X | X
2022-05-04 00:00:00 | A | A | A | T | Y | X | X
2022-05-05 00:00:00 | S | A | X | O | R | R | R
2022-05-06 00:00:00 | M | M | T | M | X | G | C
2022-05-07 00:00:00 | A | Q | Q | X | V | B | X
2022-05-08 00:00:00 | R | R | R | V | X | X | O
2022-05-09 00:00:00 | E | E | O | R | T | R | K
2022-05-01 00:00:00 | [NAME]
2022-05-01 00:00:00 | Mark
2022-05-02 00:00:00 | [NAME]
2022-05-02 00:00:00 | [NAME]
2022-05-03 00:00:00 | Mark
2022-05-05 00:00:00 | [NAME]
2022-05-08 00:00:00 | [NAME]
Spreadsheet: c606796f-1f26-465f-9be0-526cf182916f
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688874124 | Everfound | Never Beyond Repair | 2013-05-07 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688856021 | Everfound | Everfound | 2013-07-16 | Compact Disc | Rock | 11.99 | Y | Available
Word Records | 80688877422 | Love & The Outcome Everfound | New & Next | 2013-07-16 | Compact Disc | Ac | 0.75 | Y | Available
Word Records | 80688893125 | Everfound | Resolution: Christmas Ep | 2014-11-11 | Compact Disc | Christmas | 4.99 | N | NYP
Spreadsheet: 52702d1252529689-excel-table-search-look-up-help-using-if-sample-book-iii
Sheet: Sheet1

 |  |  |  |  |  |  |  | ENTERED
ID NO | Name | Cat | Entry Stat
2206 | [NAME] | IM | Entered | 1 |  |  | ID NO | CAT
 |  |  |  | 0 |  |  | 2206 | IM
 |  |  |  | 0 |  |  | 0 | MM
 |  |  |  | 0 |  |  | 3456 | IM
 |  |  |  | 0 |  |  | 6789 | MM
 |  |  |  | 0
 |  |  |  | 0
 | [NAME] | MM | Entered | 2
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
2267 | [NAME] | IM | Not Registered | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
3456 | [NAME] | IM | Entered | 3
 |  |  |  | 0
 |  |  |  | 0
6789 | [NAME] | MM | Entered | 4
 |  |  |  | 0
 |  |  |  | 0
 | [NAME] | IM | NR | 0
Before |  |  |  |  |  | After [NAME]
Spreadsheet: 746812d1631040587-add-values-across-different-sheets-excelforum-sample
Sheet: Week 1

5886 | Labour | 654 |  | Apollo French Polony 125g
6007 | CHICKEN FILLETS | 683 |  | Apollo French Polony 1kg
6007 | CHICKEN FILLETS | 712 |  | Apollo French Polony 2.5kg
6007 | CHICKEN FILLETS | 741 |  | Apollo French Polony 250g
6451 | Apples | 770 |  | Apollo French Polony 2kg
6451 | Apples | 799 |  | Apollo French Polony 500g
6451 | Apples | 828 |  | Apollo French Polony 750g
6451 | Apples | 857 |  | Apollo French Polony Long 2.5kg
8001 | Apollo French Polony 125g | 886 |  | Apollo French Polony Long 3Kg
8001 | Apollo French Polony 125g | 915 |  | Apollo Polony New 125g
8001 | Apollo French Polony 125g | 944 |  | Apollo Polony New 1kg
8001 | Apollo French Polony 125g | 973 |  | Apollo Polony New 2.5kg
8001 | Apollo French Polony 125g | 1002 |  | Apollo Polony New 250g
8001 | Apollo French Polony 125g | 1031 |  | Apollo Polony New 2kg
8001 | Apollo French Polony 125g | 1060 |  | Apollo Polony New 500g
8001 | Apollo French Polony 125g | 1089 |  | Apollo Polony New 750g
8001 | Apollo French Polony 125g | 1118 |  | [NAME]
8001 | Apollo French Polony 125g | 1147 |  | Bacon & Cheese Griller 400g
8001 | Apollo French Polony 125g | 1176 |  | Bacon Catering 1kg
8001 | Apollo French Polony 125g | 1205 |  | Bacon Catering 200g
8001 | Apollo French Polony 125g | 1234 |  | Bacon Cheese Griller 800 G
8001 | Apollo French Polony 125g | 1263 |  | Bacon Chips 1kg
8001 | Apollo French Polony 125g | 1292 |  | Bacon Chips 200g
8001 | Apollo French Polony 125g | 1321 |  | Bacon Prime Cut 1kg
8001 | Apollo French Polony 125g | 1350 |  | Bacon Prime Cut 200g
8002 | Apollo French Polony 250g | 1379 |  | Bacon Rindless Back 1kg
8002 | Apollo French Polony 250g | 1408 |  | Bacon Rindless Back 200g
8002 | Apollo French Polony 250g | 1437 |  | Bacon Sasuage 800g
8002 | Apollo French Polony 250g | 1466 |  | Bacon Streaky 1kg
8002 | Apollo French Polony 250g | 1495 |  | Bacon Streaky 200g
Spreadsheet: 707470d1607309785-if-then-statements-with-max-values-entered-from-another-sheet-jakes-sheet
Sheet: ROP Increase

[NAME] | Customer Description
47 | General [NAME]
45 | [NAME]
44 | [NAME]
43 | Class A Lineman
43 | Class A Lineman
36 | Class B Lineman
27.48 | Equipment Operator
25 | Class C Lineman
21.21 | Line Truck Operator
19.57 | [NAME]
18.86 | [NAME]
Spreadsheet: 730816d1619966200-expand-a-formula-to-other-cells-given-the-complexity-of-the-formula-a-bit-tricky-example-14-
Sheet: INPUT

 | Categories |  |  | Expert |  | Competent |  | Medium |  | Beginner |  | Novice
 |  |  |  | 90% - 100% |  | 80% - 89% |  | 70% - 79% |  | 60% - 69% |  | 0% - 59%
 | Ability |  |  | 93
 | Velocity |  |  | 90
 | Push |  |  | 96
 | Pull |  |  | 94
 | Balance |  |  | 90
 |  |  |  | 95
Spreadsheet: 707705d1607427818-separating-data-and-counting-the-data-on-a-different-spreadsheet-lesia-test-
Sheet: Agents

Operator | Total Valid Between 1/1/20 and 6/30/20 | Total Valid Between 7/1/20 and 12/1/20 | Net Total | Bonus Total
 |  | 1 |  |  |  |  | 1
Beverly Michaux | 1 | 1 | 1.25 | 2 |  | 0 | 1
[NAME] Beverly Michaux | 1 | 0 | 1 | 1 |  | 1 | 0
Chasity [NAME] | 0 | 1 | 0.25 | 1 |  | 0 | 1
[NAME] | 1 | 1 | 1.25 | 2 |  | 0 | 1
[NAME] | 1 | 0 | 1 | 1 |  | 1 | 0
[NAME] | 6 | 0 | 6 | 6 |  | 3 | 0
Spreadsheet: 155511d1336908717-calculating-3-from-5-cells-testing-results
Sheet: Sheet1

Name | race 1 | race 2 | race 3 | race 4 | race 5 | best 3 from 5
[NAME] | 2 | 1 | 4 | 2 | 3
[NAME] | 1 | 7 | 2 | 4 | 1
Fred | 4 | 2 | 1 | 5 | 5
Spreadsheet: 769941d1645726814-i-need-more-than-64-levels-of-nesting-4-28-to-5-24-db2
Sheet: Sheet1

POS PIN MCDONALD | Eating Out |  |  | POS PIN MCDONALD S F3793  BR PITTSBURGH PA
POS MC Armando | Eating Out |  |  | POS MC Armando s Pizza  BR Charleroi PA
POS MC OPC | Taxes |  |  | POS MC OPC TAX SERVICE  BR [PHONE] NE
POS PIN WAL | Wal-Mart |  |  | POS PIN WAL WAL MART  24  BR BELLE VERNON PA
POS MC OPC | Taxes |  |  | POS MC OPC BERKHEIMER I  BR [PHONE] PA
POS MC Subway | Eating Out |  |  | POS MC Subway 13857  BR Pittsburgh PA
POS PIN MCDONALD | Eating Out |  |  | POS PIN MCDONALD S F2730  BR N BELLE VERNO PA
ECK T MOBILE.COM | Phones |  |  | ECK T MOBILE.COM [PHONE]  BR PCS SVC
ECK STATE FARM | Auto & Homeowners |  |  | ECK STATE FARM RO [PHONE]  BR CPC CLIENT
POS MC AMOCO | Gas |  |  | POS MC AMOCO 1014800ROS  BR ROSTRAVER PA
POS PIN MCDONALD | Eating Out |  |  | POS PIN MCDONALD S F2730  BR N BELLE VERNO PA
POS MC CRAFTBEERCLUB.CO |  |  |  | POS MC CRAFTBEERCLUB.CO  BR SANTA BARBARA CA
CHK 1308 SEQ | Physical Checks |  |  | CHK 1308 SEQ  18012386
DIR FIRSTENERGY OPCO | Electric |  |  | DIR FIRSTENERGY OPCO [PHONE]  BR FE ECHECK
ECK HABRKHMRTAXPA 9001211MFT | Taxes |  |  | ECK HABRKHMRTAXPA 9001211MFT  BR WEB PMTS
ECK HABRKHMRTAXPA 9001211MFT | Taxes |  |  | ECK HABRKHMRTAXPA 9001211MFT  BR WEB PMTS
POS PIN WAL | Wal-Mart |  |  | POS PIN WAL WAL MART  24  BR BELLE VERNON PA
POS PIN MCDONALD | Eating Out |  |  | POS PIN MCDONALD S F2730  BR N BELLE VERNO PA
POS MC ALDI | Groceries |  |  | POS MC [NAME] 69009  BR BELLE VERNON PA
POS MC PANDA | Eating Out |  |  | POS MC PANDA EXPRESS 25  BR PITTSBURGH PA
POS PIN NETFLIX | Netflix |  |  | POS PIN NETFLIX COM  BR LOS GATOS CA
Spreadsheet: 00603cd8-c384-414a-afc2-b22708098a73
Sheet: Sheet1

York Basin (8-) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 1401aeea-7eb2-466b-a60e-509047bfca3f
Sheet: Sheet1

Release: Quarterly Retail E-Commerce Sales | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=179
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-05-24 10:12 AM CDT
 | Real-Time | Period
Name: | Start | End
Quarterly Retail E-Commerce Sales | 2009-02-17 00:00:00 | Current
Link:
http://www.census.gov/mrts/www/ecomm.html | 2009-02-17 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2009-02-17 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2009-02-17 00:00:00
2009-05-15 00:00:00
2009-08-17 00:00:00
2009-11-18 00:00:00
2010-02-16 00:00:00
2010-05-18 00:00:00
2010-08-17 00:00:00
2010-11-17 00:00:00
2011-02-17 00:00:00
2011-05-16 00:00:00
2011-08-16 00:00:00
2011-11-17 00:00:00
2012-02-16 00:00:00
2012-05-17 00:00:00
2012-08-16 00:00:00
2012-11-16 00:00:00
2013-02-15 00:00:00
2013-05-15 00:00:00
Spreadsheet: e0665770-86e7-47ca-8494-56241741d388
Sheet: Sheet1

Pos | name | total | country | shooting-PosShooting | shooting-PerfShooting | shooting-Shooting | fencing-pos | fencing-victories | fencing-defeats | fencing-points | fencing-status | swimming-pos | swimming-time | swimming-points | swimming-status | riding-pos | riding-points | riding-time | riding-status | riding-coursepen | riding-timepen | running-pos | running-time
1 | GBR | 5172 | GBR | 2 | 273 | 1180 | 4 | 38 |  | 808 |  | 2 | 3:07.76 | 1268 |  | 4 | 1056 |  |  |  |  | 4 | 16:05.41
2 | GBR  /  RUS | 5136 | RUS | 3 | 272 | 1168 | 1 | 45 |  | 920 |  | 3 | 3:08.23 | 1264 |  | 5 | 1036 |  |  |  |  | 6 | 16:33.04
3 | GBR  /  RUS  /  HUN | 5128 | HUN | 5 | 266 | 1096 | 6 | 34 |  | 744 |  | 1 | 3:03.58 | 1320 |  | 2 | 1072 |  |  |  |  | 3 | 15:56.54
4 | GBR  /  RUS  /  HUN  /  BLR | 4972 | BLR | 1 | 273 | 1180 | 7 | 31 |  | 696 |  | 6 | 3:14.86 | 1184 |  | 7 | 940 |  |  |  |  | 1 | 15:37.85
5 | GBR  /  RUS  /  HUN  /  BLR  /  POL | 4920 | POL | 9 | 251 | 916 | 2 | 40 |  | 840 |  | 7 | 3:15.66 | 1172 |  | 6 | 1024 |  |  |  |  | 2 | 15:38.08
6 | GBR  /  RUS  /  HUN  /  BLR  /  POL  /  CZE | 4874 | CZE | 4 | 271 | 1156 | 3 | 39 |  | 824 |  | 8 | 3:18.06 | 1144 |  | 3 | 1070 |  |  |  |  | 7 | 16:50.01
7 | GBR  /  RUS  /  HUN  /  BLR  /  POL  /  CZE  /  GER | 4840 | GER | 7 | 254 | 952 | 8 | 30 |  | 680 |  | 5 | 3:11.00 | 1228 |  | 1 | 1120 |  |  |  |  | 5 | 16:05.93
8 | GBR  /  RUS  /  HUN  /  BLR  /  POL  /  CZE  /  GER  /  LTU | 3668 | LTU | 6 | 260 | 1024 | 5 | 35 |  | 760 |  | 4 | 3:10.67 | 1232 |  | 9 | 0 |  |  |  |  | 9 | 16:57.85
9 | GBR  /  RUS  /  HUN  /  BLR  /  POL  /  CZE  /  GER  /  LTU  /  GRE | 3344 | GRE | 8 | 252 | 928 | 9 | 29 |  | 664 |  | 9 | 3:23.60 | 1080 |  | 8 | 0 |  |  |  |  | 8 | 16:52.31
Spreadsheet: 82625d1282673249-auto-populating-excel-calendar-training-sheet
Sheet: Calender

 |  | Month: | 8 | Year: | 2010
 | SUN | MON | TUES | WED | THUR | FRI | SAT
 | `
 |  | Days in Month:
 |  | The first is this weekday:
 | 1 | January | 31 | 2008 | 29
 | 2 | February |  | 2009 | 28
 | 3 | March | 31 |  | 28
 | 4 | April | 30 |  | 28
 | 5 | May | 31 |  | 29
 | 6 | June | 30 |  | 28
 | 7 | July | 31 |  | 28
 | 8 | August | 31 |  | 28
 | 9 | September | 30 |  | 29
 | 10 | October | 31 |  | 28
 | 11 | November | 30 |  | 28
 | 12 | December | 31 |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 28
 |  |  |  |  | 29
Spreadsheet: 73815d1274379059-download-tracking-download-tracking-2
Sheet: Sheet1

Download Tracking
Date | Connection Time |  |  |  | Data Transmitted | Data Recived | Time
2010-05-19 00:00:00 | 0 | 21 | 30 | 0 | 0.034668 | 0.473691 | 18 | 12 |  | GB - MB |  | MB - GB
 | 0 | 23 | 33 | 53 | 0.967021484375 | 1.04 | 18 | 57 |  | GB | 1 | GB
 |  |  |  |  |  |  |  |  |  | MB |  | MB | 1
End of Month
Spreadsheet: 706714d1606847371-change-cell-value-based-on-another-cells-value-sample
Sheet: Sheet1

District | Postcode |  | Values
 | NE |  | Postcode | District
 | NH |  | NE | Nov Ec
 | DL |  | NH | Nov Hot
 | DH |  | DL | [NAME]
 | GH |  | DH | Del Hot
 | SE |  | GH | Gol Hot
 | NE |  | SE | [NAME]
 | NH
 | DL
 | DH
 | GH
 | SE
Spreadsheet: 866346d1713286808-cell-content-in-3-columns-to-copy-into-a-new-4th-column-excel-forum-sample
Sheet: Sheet2

 | Existing Data |  |  |  |  | Desired | Finished | Result
 |  | 1 |  |  |  |  | 1 | 1
1 |  |  |  |  | 1 |  |  | 1
1 |  |  |  |  | 1 |  |  | 1
 |  | 1 |  |  |  |  | 1 | 1
 |  | 1 |  |  |  |  | 1 | 1
 | 1 |  |  |  |  | 1 |  | 1
1 |  |  |  |  | 1 |  |  | 1
 | 1 |  |  |  |  | 1 |  | 1
1 |  |  |  |  | 1 |  |  | 1
 | 2 |  |  |  |  | 2 |  | 2
 |  | 1 |  |  |  |  | 1 | 1
 | 1 |  |  |  |  | 1 |  | 1
2 |  |  |  |  | 2 |  |  | 2
 |  | 2 |  |  |  |  | 2 | 2
 | 1 |  |  |  |  | 1 |  | 1
2 |  |  |  |  | 2 |  |  | 2
 |  | 3 |  |  |  |  | 3 | 3
 |  | 1 |  |  |  |  | 1 | 1
 | 2 |  |  |  |  | 2 |  | 2
1 |  |  |  |  | 1 |  |  | 1
1 |  |  |  |  | 1 |  |  | 1
 | 3 |  |  |  |  | 3 |  | 3
Spreadsheet: 889489d1740328843-average-percentage-per-year-average-percent
Sheet: AMG

2024 |  |  | Average of 2024  YTD
2025 |  |  | Average of 2025  YTD
2026
2027
2028
2029
2030
DATE | GROSS | NET | PERCENT | HOURS | TAX | INSURANCE
2024-11-14 00:00:00 | 800 |  |  |  | 175 | 25
 | 800 |  |  |  | 180 | 25
 | 800 |  |  |  | 190 | 25
 | 800 |  |  |  | 160 | 25
 | 800 |  |  |  | 175 | 25
 | 800 |  |  |  | 180 | 25
 | 800 |  |  |  | 190 | 25
 | 800 |  |  |  | 160 | 30
2025-01-09 00:00:00 | 800 |  |  |  | 175 | 30
2025-01-16 00:00:00 | 800 |  |  |  | 180 | 30
Spreadsheet: 82852d1282844424-random-pairs-golfmixedpairsteamselectoin
Sheet: Game Selector

 | Generate selection
Team | Men | Women
1 | [NAME]
2 | [NAME] | Heather
3 | [NAME] | Britt
4 | Nate | Kristen
5 | Rory | Kelly
6 | Mathew | Paige
7 | Mark | Wilma
8 | [NAME]
9 | George | Betty
10 | [NAME] | Anne
Spreadsheet: beac577c-0945-4efc-976c-0aa5e065d8fa
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
43495864 | 2014-10-08 21:13:36 | ALLIES | 1 | 6 | 3 | 243582 | Vercingetorix1302 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43496194 | 2014-10-08 21:31:19 | AXIS | 1 | 6 | 5 | 243582 | Vercingetorix1302 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43502969 | 2014-10-09 08:47:17 | ALLIES | 1 | 6 | 3 | 1581268 | Dain Ironfoot | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43503108 | 2014-10-09 09:13:04 | AXIS | 0 | 3 | 6 | 1581268 | Dain Ironfoot | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43504634 | 2014-10-09 13:15:33 | AXIS | 0 | 4 | 6 | 249959 | NAPOLEON71 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43508161 | 2014-10-09 19:32:28 | ALLIES | 1 | 6 | 2 | 1571206 | pinotcat | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43508421 | 2014-10-09 19:45:44 | AXIS | 0 | 2 | 6 | 1571206 | pinotcat | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43518342 | 2014-10-10 14:03:41 | ALLIES | 0 | 5 | 6 | 1631362 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43518701 | 2014-10-10 14:44:56 | AXIS | 1 | 6 | 4 | 1631362 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43577408 | 2014-10-14 12:51:24 | ALLIES | 0 | 4 | 6 | 1655511 | iceknight111 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43577554 | 2014-10-14 13:12:13 | AXIS | 1 | 6 | 3 | 1655511 | iceknight111 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43604259 | 2014-10-16 13:03:43 | ALLIES | 1 | 6 | 1 | 817439 | Uajit | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43604373 | 2014-10-16 13:34:13 | AXIS | 0 | 4 | 6 | 817439 | Uajit | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43604621 | 2014-10-16 13:54:59 | ALLIES | 0 | 2 | 6 | 1656368 | player1656368 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43604728 | 2014-10-16 14:21:59 | AXIS | 1 | 6 | 5 | 1656368 | player1656368 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43618731 | 2014-10-17 15:16:36 | ALLIES | 1 | 6 | 1 | 1645776 | simono_ | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43618919 | 2014-10-17 15:44:48 | AXIS | 1 | 6 | 4 | 1645776 | simono_ | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43649553 | 2014-10-19 18:34:04 | ALLIES | 1 | 6 | 3 | 1657888 | steve.duvoisin | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43649914 | 2014-10-19 18:50:35 | AXIS | 1 | 6 | 1 | 1657888 | steve.duvoisin | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 775972d1649422691-too-many-cells-have-determining-factors-how-to-use-the-ones-with-products-sheet-shared
Sheet: Formulas

Net random | Gross random | Thickness | [NAME] | Margin | Footage A | Set up | Run Charge | Knife charge | Freight Charge | [NAME] | Footage add
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | Select One:
1.45 | 1 | 1 | 2 | 0.5 | 20 | 20 | 0.25 | 85 | 0.25 | Dado | 20 | Net Strip
1.55 | 1.45 | 1.25 | 3 | 0.6 | 30 | 40 | 0.35 | 100 | 0.3 | Glue | 30 | [NAME]
1.6 | 1.55 | 1.5 | 4 | 0.65 |  | 50 | 0.45 |  | 0.35 | Kerf | 40 | Net Random Width
1.65 | 1.6 | 1.75 | 6 | 0.7 |  | 60 | 0.55 |  | 0.45 | Packaging | " " " | Gross [NAME]
1.7 | 1.65 | 2 | 7 | 0.72 |  | 80 | 0.65 |  | 0.55 | Planing
1.8 | 1.7 | 2.5 | 8 | 0.75 |  | 100 | 1 |  | 0.65 | Resaw
 | 1.8 | 3 | 9 | 0.78 |  | 120 | 1.5 |  | 0.7 | Shaper
cell above left blank |  | 4 | 10 | 0.8 |  | 160 | 2 |  | 0.75
 | cell above left blank | 6 | 11 | 0.85 |  | 200 | Other |  | 0.8
 |  | 8 | 12 | 0.9 |  | 240
 |  | 10 |  |  |  |  | 30
 |  | 12
 |  | " " "