tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 33295 | 17825 |  | 14579
2 | 35755 | -187 |  | 35000
3 | 4589 | -187
4 | 42970 | -187 |  | 43232
5 | 419 | -187 |  | 61
6 |  | 14623 |  | -5000
7 | 36032 | 18481 |  | 16742
8 | 29195 | 20939 |  | 8000
9 | 435 | -187
10 |  | -187
11 |  | -187 | 5
12 | 21615 | 20588
13 | 49616 | 28812 |  | 20221
14 | 11991 | 49 |  | 10041
15 | 17918 | 18438
16 | 54633 | 53350
17 | 49627 | 48693
18 | 31687 | 41662 | 9093
19 | 30086 | 26453 |  | 5000
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2000-11-30 00:00:00 |  |  | 24376.68
 |  |  |  | 2000-12-19 00:00:00
Spreadsheet: rick_buy__32772__DOUG
Sheet: 1100

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF NOVEMBER 30, 2000
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 11384500.93 |  | 2769542.66 |  | 37325.9 |  | 765643.41 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0
PUERTO QUETZAL | A/R |  | 2699455.47 |  | 32407.23 |  | 3259924.7 |  | 24488.81 |  | 444405.91 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
 | PER CENT
DABHOL POWER CO | A/R |  | 222492.95 |  | 0 |  | 0 |  | 444985.9 |  | 4011.82 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 222492.95
EMPRESA ENERGETICA | A/R |  | 0 |  | 1726803.12 |  | 28085.13 |  | 1431473.08 |  | -55110.21 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
EGEMINSA | A/R |  | 1279934.64 |  | -1801887.66 |  | 594519.24 |  | 975141.39 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 4700000
TOTALS | A/R
 | PER CENT
Spreadsheet: 765199d1643208489-time-card-formula-help-bi-weekly-timesheet
Sheet: JENNIFER

Bi-Weekly Time Record
Employee:
Pay ending: | 2022-02-04 00:00:00
Day | Date | Total hours | Sick | Vacation | Holiday | MISC | Regular Hours | Overtime Hours | Notation |  |  | HOURS | GROSS
Saturday |  |  |  |  |  |  |  |  |  |  | REGULAR
Sunday |  | 8 |  |  |  |  |  |  | ON CALL |  | OVER TIME
Monday |  | 8 |  |  |  |  |  |  |  |  | ON CALL PER DAY
Tuesday |  |  |  | 8 |  |  |  |  |  |  | VACATION
Wednesday |  | 12 |  |  |  |  |  |  |  |  | SICK DAY
Thursday |  | 8 |  |  |  |  |  |  |  |  | HOLIDAY
Friday |  | 9.5 |  |  |  |  |  |  |  |  | MISC
 | Total hours |  |  |  |  |  |  |  |  |  | BONUS | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | GROSS
Day | Date | Total Hours | Sick | Vacation | Holiday | MISC | Regular Hours | Overtime Hours | Notation |  | MEDICAL | 59.79
Saturday |  |  |  |  |  |  |  |  |  |  | TOTALS
Sunday |  | 3
Monday |  | 8
Tuesday |  | 8
Wednesday |  | 8
Thursday |  | 3
Friday |  | 8
 | Total hours
Spreadsheet: vkaminski__40701__Research
Sheet: EXPORT_TBIEN

SUPV | EMPLOYEE_NAME | JOBGROUP | [NAME] | HIRE_DATE | RANKING
KAMINSKI
 | GIBNER, PEYTON S | VP-C | VP | 1992-09-21 00:00:00
 | MASSON, GRANT S | VP-CS | VP COMM SUPT | 1994-04-16 00:00:00
 | [NAME], [NAME] A | VP-C | VP | 1975-09-08 00:00:00
 | SHANBHOGUE, VASANT | VP-CS | VP COMM SUPT | 1995-05-01 00:00:00
 | CRENSHAW, SHIRLEY J | ASSTEX-CS | COORD ADMIN | 1998-03-23 00:00:00
 | KRISHNARAO, PINNAMANENI V | DIR-ST | DIR RESEARCH | 1993-11-15 00:00:00
 | RAYMOND, MAUREEN J | DIR-ST | DIR RESEARCH | 1998-12-31 00:00:00
KRISHNARAO
 | CHAHAL, MANDEEP S | MGR-ST | MGR RESEARCH | 1996-09-30 00:00:00
 | SEZGEN, OSMAN | MGR-ST | MGR RESEARCH | 1998-11-09 00:00:00
SHANBHOGUE
 | DHAR, [NAME] | MGR-ST | MGR RESEARCH | 1998-03-30 00:00:00
 | VERNON, CLAYTON J | MGR-ST | MGR RESEARCH | 1999-12-13 00:00:00
 | THURAISINGHAM, RAVI | MGR-ST | MGR RESEARCH | 1998-10-12 00:00:00
CRENSHAW
 | SMITH, WILLIAM S | ASST-CS | SECRETARY | 2000-01-17 00:00:00
[NAME]
 | TLAPEK, PATRICIA | MGR-ST | MGR RESEARCH | 1997-06-16 00:00:00
 | MARQUEZ, [NAME] | MGR-ST | MGR RESEARCH | 2000-02-14 00:00:00
 | MOORE, KEVIN G | ASSTSR-CS | ASST ADMIN SR | 1997-01-20 00:00:00
GIBNER
 | LU, ZIMIN | DIR-ST | DIR RESEARCH | 1996-09-09 00:00:00
 | [NAME], SAMER | DIR-ST | DIR RESEARCH | 1999-05-10 00:00:00
 | ISSLER, PAULO F | MGR-ST | MGR RESEARCH | 1998-08-03 00:00:00
 | HRGOVCIC, HRVOJE J | MGR-ST | MGR RESEARCH | 1994-05-23 00:00:00
 | SUPATGIAT, CHONAWEE | MGR-ST | MGR RESEARCH | 1999-08-16 00:00:00
 | [NAME], ROBERT R | MGR-ST | MGR RESEARCH | 2000-06-05 00:00:00
MASSON
 | HALLIBURTON, THOMAS S | MGR-ST | MGR RESEARCH | 2000-04-10 00:00:00
 | HUANG, [NAME] | MGR-ST | MGR RESEARCH | 1999-11-01 00:00:00
 | KINDALL, KEVIN | MGR-ST | MGR RESEARCH | 1999-11-22 00:00:00
 | TAMARCHENKO, TANYA V | MGR-ST | MGR RESEARCH | 1996-11-18 00:00:00
 | TANG, XINYU V | MGR-ST | MGR RESEARCH | 1998-08-17 00:00:00
RAYMOND
 | KRISTAL, YANA | SPECJR-CS | ANALYST RESEARCH | 2000-01-17 00:00:00
Spreadsheet: 856649d1705854706-concatenate-with-indirect-function-21012024-sample-file-for-xlforum
Sheet: Docs15

BrCd | PrdCd | AcctId
12 | 503 | 324
6 | 755 | 582
21 | 600 | 612
6 | 501 | 153
24 | 755 | 285
45 | 758 | 300
69 | 180 | 312
72 | 400 | 321
66 | 316 | 324
27 | 501 | 327
12 | 507 | 330
27 | 386 | 830
48 | 302 | 371
72 | 487 | 503
75 | 493 | 518
69 | 372 | 530
30 | 288 | 539
15 | 473 | 542
30 | 479 | 545
Spreadsheet: 59757d1260318114-league-spreadsheet-vs2_league_spreadsheet_test
Sheet: Setup

Setting up some parameters |  |  | data entry fields
Team List
1 | Blue |  | For each team name in this list, create a three line
2 | red_team |  | entry on the Teams Sheet
3 | yellow |  | When setting up team names, use _ instead of spaces.
4 | green |  | Team names will end up as range names and can not have blanks.
5 | purple
6 | orange
7 | pink
8 | chartreuse
9 | amber
10 | mauve
create new teams above this row. This will adjust the team list range name automatically.
check the correct range names. Hit F5 and select TeamList, then hit F5 and select Teams
Both names should light up the yellow rows and one below.
total number of teams |  | 10
total number of pairings per week |  | 5
Spot/handicap is |  | 0.8 | of the difference between two players' average score to date
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: EOPs

 | Energy Operations
 | 2002 Plan
 |  |  |  |  |  |  |  | Energy Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  | 0 | Compensation | 0
 | Analyst & Assoicate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  |  | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  |  | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  |  | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  | 0 | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 151 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  |  | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 32864d1229029770-name-error-copy-of-parrs-calculator
Sheet: Calculator

 |  |  | current date
Data Entry |  |  | 2008-12-11 00:00:00 |  |  |  | days |  | Vacation days
 |  |  |  |  |  | Current Date | 2008-12-11 00:00:00 |  | 2008-12-25 00:00:00
Tenure | 12 | 12 = 12 MONTHS + | 6 = 6 - 12 MONTHS | 0 = 0 - 6 MONTHS |  | Due Date | 2008-12-29 00:00:00 |  | 2008-12-26 00:00:00
Status | o | O = OPEN | S = SUSPENDED | C = Cancelled |  |  | 5 |  | 2009-01-01 00:00:00
Reliability | h | H = HIGH | M = MEDIUM | L = LOW |  |  | 10 |  | 2009-01-02 00:00:00
Credit Class | b | B,D,C,E,V,X,R |  |  |  |  | 15 |  | 2009-04-10 00:00:00
Aging | 1 | 1 = 1-30 | 31 = 31-60 | 61 = 61-90 | 91 = 91+ |  | 20 |  | 2009-04-13 00:00:00
current | 100 |  |  |  |  |  | 35 |  | 2009-05-18 00:00:00
past due | 150 |  |  |  |  |  | 40 |  | 2009-06-24 00:00:00
Due Date | 2008-12-29 00:00:00 |  |  |  |  |  | 45 |  | 2008-07-01 00:00:00
 | single |  | 1st payment | 2nd payment |  | multiple 3 | multiple 3 | multiple 3
amount | 250 | amount | 150 | 100 | amount
date | 2009-01-14 00:00:00 | date | 2008-12-29 00:00:00 | 2009-01-14 00:00:00 | date
Arrangement | PTP | arrangement | PTP |  | arrangements
tenure | status | reliliability | credit class | aging | single | Arrangement | Date | 1st pymt | Arrangements | date | 2nd pymt | date | Arrangements | 1st pymt | Arrangements | date | 2nd pymt | date | Arrangements | 3rd pymt | date | Arrangements
12 | o | h | b | 1 | 250 | PTP | 2009-01-14 00:00:00 | 150 | PTP | 2008-12-29 00:00:00 | 100 | 2009-01-14 00:00:00 | PTP | 75 | PTP |  | 75 |  | PTP | 100
12 | o | m | b | 1 | 250 | PTP | 2009-01-14 00:00:00
12 | o | l | b | 1 | 250 | PTP | 2009-01-07 00:00:00
12 | o | r | b | 1 | 250 | PTP | 2008-12-29 00:00:00
12 | o | 1 | 1 | 1 | 1
12 | o | 1 | 1 | 1 | 1
12 | o | 1 | 1 | 1 | 1
12 | o | 1 | 1 | 1 | 1
12 | o | 1 | 1 | 1 | 1
Spreadsheet: 832629d1686497384-if-any-cell-in-column-b-includes-any-of-these-words-in-range-j1-j4-then-highlight-row-daliye-post-4-book1
Sheet: Sheet1

No. | Item | 2016 | 2017 | 2018 | 2019 |  |  |  | ItemsNames |  | If any cell in column B includes any of these words in range Table5, then highlight entire row with read
1 | Fixed assets |  |  |  |  |  |  |  | Fixed
2 | Total non-current assets |  |  |  |  |  |  |  | Loans
3 | Cash and the like |  |  |  |  |  |  |  | Sales
4 | Total current assets |  |  |  |  |  |  |  | Long
 |  |  |  |  |  |  |  |  | Asset
No. | Item | 2016 | 2017 | 2018 | 2019 |  |  |  | Cash |  | If I added any new item to Table 5 (like items in the range J7:J9, how to let it update itself and highlight the entire row?
1 | Total current liabilities |  |  |  |  |  |  |  | Goods
2 | long term loans
3 | Total non-current liabilities
4 | total liabilities
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Sales
2 | Cost of Goods Sold
3 | Inventory
4 | Loan
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Fixed Assets
2 | Cash Papers
3 | Inventory
4 | Long Loan
Spreadsheet: 887478d1737710189-spill-formula-to-split-data-to-3-tabs-based-on-several-criteria-aging-dec-24-1-
Sheet: Table Summary

 |  | Shawn
 |  | Shawn | A Consumer Services
 |  | [NAME] | A HBH
 |  | [NAME] | A SaaS
 |  | Shawn | A Other
 |  | [NAME] | A LG Funnel
 |  | [NAME] | A Insurance
 |  | [NAME] | C Consumer Services
 |  | [NAME] | C Insurance
 |  | [NAME] | C Accelerator
 |  | Shawn | C SaaS
 |  | [NAME] | C Lending & Banking
 |  | Shawn | A Accelerator
 |  | Shawn | C HBH
 |  | Shawn | B Insurance
Spreadsheet: 161156d1339431645-expiry-date-flagging-can-you-help-training-database-template
Sheet: CPCS cards

 |  |  |  |  | Current CPCS certifications
 |  | CPCS | CPCS | CPCS | CPCS | CPCS | CPCS | CPCS | CPCS | CPCS | CPCS | Crane | CPCS | CPCS | CPCS | CPCS
 | Registration | excavator 360 | excavator 360 | excavator 180 | excavator 180 | forward tipping | counter/bal | telescopic | skid steer | [NAME] |  | appointed | Dump Truck | Ride on | excavator 360 | excavator 360
 | Number | below 10T | above 10T | below 5T | above 5T | dumper | forklift | handler | loader | loader |  | person | Articulated Chasis | Road | below 5T | Above 5T
operatives |  |  |  |  |  |  |  |  |  |  |  |  |  | Roller
Darren Couch | 01148386/1 | expires 20/10/2007 | expires 20/10/2007 |  |  | expires 28/02/2007
[NAME] | 00609141/1 |  |  |  |  | expires 07/09/2008
[NAME] |  |  | copy of card required?
Gzim Berisha | 01188471/1 | expires 27/01/2008 | expires 27/01/2008 | expires 27/01/2008 | expires 27/01/2008
[NAME] | 02334358/1 | expires 11/09/2009 | expires 11/09/2009 |  |  |  |  |  |  |  |  |  | expires 11/09/2009
A. Auza | 01979679/1 |  |  |  |  | expires 31/09/2009
[NAME] |  | copy of card required | copy of card required
Cosma Toma | 02397199/1 |  |  |  |  | copy of card required |  |  |  |  |  |  |  | copy of card required
M. Dauti | 01375317/1 | expires 20/10/2007 | expires 20/10/2007
[NAME] | 01346281/1 |  |  |  |  | expires sept 2008
[NAME] | 01110951/1 |  |  |  |  |  |  |  |  |  |  |  |  |  | expires 28/022007 | expires 28/02/2007
[NAME] | 01255672/1 | expires 05/11/2009 | expires 05/11/2009 |  |  | expires 07/02/2009
[NAME] | 00278931/1 |  |  |  |  | expires 28/02/2007 |  | expires 28/02/2007 |  | expires 26/07/2009 |  |  |  |  | expires february 2008 | expires february 2008
[NAME] | 0176508/1 |  |  |  |  | expires 29/06/2007 |  |  |  |  |  |  |  | expires 29/06/2007
[NAME] |  | expires march 2011 | expires march 2011
Besim Mehmetan |  |  |  |  |  | expires may 2010
[NAME] | 01737742/1 | expires 15/11/2009 | expires 15/11/2009 |  |  | expires 15/11/2009
[NAME] | 00944959/1
[NAME] | 01892787/1 |  |  |  |  |  |  |  |  |  |  |  |  | expires 05/01/2009
[NAME] | 00716218/1 |  |  |  |  | expires sept 2008
[NAME] | 01148381/1 |  |  |  |  | expires 12/09/2007
Toma Poptile | 02271178/1 |  |  |  |  | [NAME] ?
[NAME] | 01099481/1 | expires 01/09/2008 | expires 01/09/2008
[NAME] | 01451855/1 |  |  |  |  |  |  |  |  |  |  |  |  |  | expires 28/02/2007 | expires 28/02/2007
[NAME] | 230208 |  |  |  |  | expires Nov 2010
[NAME] | 01737524/1 |  |  |  |  | expires 10/08/2007
[NAME] | 00752965/1 | expires July 2010 | expires July 2010 | expires July 2010 | expires July 2010 |  |  |  |  |  |  |  |  |  | expires July 2010 | expires July 2010
I. Toma | 02131467/1
RED | RED CPCS card which expires after 3 years - need to achieve an NVQ to renew and 300 hours
BLUE | BLUE CPCS card which expires after 5 years - 300 hours needs to be achieved (plant has NVQ linked to it)
GREEN | GREEN CPCS card which expires after 5 years - 300 hours needs to be achieved (plant has no NVQ linked to it)
Spreadsheet: 142277d1329762568-summarise-data-from-multiple-sheets-based-on-dates-test-data
Sheet: Area 1

Date | reference | problem |  |  | problem a
2012-02-18 00:00:00 |  |  |  |  | problem b
2012-02-01 00:00:00 | abc123 | problem a |  |  | problem c
2012-02-02 00:00:00 | abc124 | [NAME] |  |  | [NAME]
2012-02-03 00:00:00 | abc125 | [NAME]
2012-02-04 00:00:00 | abc126 | [NAME]
2012-02-19 00:00:00 | abc127 | problem c
2012-02-19 00:00:00 | abc129 | problem b
2012-02-19 00:00:00 | abc130 | problem b
2012-02-19 00:00:00 | [NAME] | problem c
Spreadsheet: 158712d1338367715-required-the-output-which-is-mentioned-in-the-attached-file-report
Sheet: sheet1

[NAME] | Input Column |  | Output Column | Output Column |  | Output Column | Output Column |  | Output Column | Output Column
1 | aa |  | 1 | aa |  | 2 | ab |  | 3 | aab
1 | bb |  | 1 | bb |  | 2 | ac |  | 3 | aac
1 | cc |  | 1 | cc |  | 2 | ad |  | 3 | aad
1 | dd |  | 1 | dd |  |  |  |  | 3 | aae
1 | ee |  | 1 | ee |  |  |  |  | 3 | aae
2 | ab
2 | ac
2 | ad
3 | aab
3 | aac
3 | aad
3 | aae
3 | aae
Spreadsheet: 780076d1652281951-grouping-dates-by-month-of-year-to-calculate-maximum-average-and-minimum-without-pivot-book2
Sheet: Sheet1

Date | Criteria | Amount |  |  | Column1 | Month [NAME] | Month Average | Month Minimum
2022-01-01 00:00:00 | A | 100 |  |  | A | 200 | 150 | 100
2022-01-10 00:00:00 | B | 50 |  |  | B | 1000 | 517 | 50
2022-02-25 00:00:00 | A | 200
2022-02-10 00:00:00 | B | 1000
2022-02-18 00:00:00 | B | 500
 | C
2021-01-01 00:00:00 | D
 | C |  |  |  |  |  | Required answer
2020-05-01 00:00:00 | E |  |  |  | Criteria | [NAME] | Average | Minimum
 | C |  |  |  | A | 200 | 150 | 100
 | D |  |  |  | B | 1000 | 516.6666666666667 | 50
Spreadsheet: 678048d1589689791-index-match-for-auto-costings-calculations-bizcostings-sample
Sheet: FUNCTIONS

list | day | week | month | qtr | bi-annual | year |  | cost category
daily |  |  |  |  |  |  |  | business cost
weekly |  |  |  |  |  |  |  | businss loan
monthly |  |  |  |  |  |  |  | charity
quarterly |  |  |  |  |  |  |  | subscriptions
6 months |  |  |  |  |  |  |  | personal loan
yearly |  |  |  |  |  |  |  | other costs
2 years
3 years
4 years
5 years
paused | Paused | Paused | Paused | Paused | Paused | Paused
Spreadsheet: 739702d1625862253-looking-to-build-a-schedule-table-for-football-team-using-both-visitor-and-home-columns-practice-coding-2021-prep-fb-master-schedule
Sheet: Sheet2

Date | Opponent | at | Home | at | Off-campus site | , | Time | 1=Conf | Conference | Date | Opponent | at | Home | at | Off-campus site | Time | 1=Conf | Conference |  | 2007 [NAME] |  |  | [NAME]
2021-08-20 00:00:00 | Baraboo | at | Onalaska |  |  | , | 7 p.m. | 0 | X-Non-conference | 2021-08-19 00:00:00 | [NAME] | at | Bay Port | 0 | 0 | 7 p.m. | 0 | X-Non-conference |  | 2021-08-19 00:00:00 | [NAME]
2021-08-27 00:00:00 | Madison East | at | Baraboo |  |  | , | 7 p.m. | 0 | X-Non-conference | 2021-08-27 00:00:00 | [NAME] | at | [NAME] | 0 | 0 | 7 p.m. | 0 | X-Non-conference |  | 2021-08-27 00:00:00 | [NAME]
2021-09-03 00:00:00 | Monona Grove | at | Baraboo |  |  | , | 7 p.m. | 1 | [NAME] | 2021-09-03 00:00:00 | [NAME] | at | Beloit Memorial | at | Jacobson Field, Beloit | 7 p.m. | 1 | Big Eight |  | 2021-09-03 00:00:00 | [NAME]
2021-09-10 00:00:00 | Baraboo | at | Stoughton |  |  | , | 7 p.m. | 1 | [NAME] | 2021-09-10 00:00:00 | [NAME] | at | [NAME] | 0 | 0 | 7 p.m. | 1 | Big Eight |  | 2021-09-10 00:00:00 | [NAME]
2021-09-17 00:00:00 | Mount Horeb/Barneveld | at | Baraboo |  |  | , | 7 p.m. | 1 | [NAME] | 2021-09-17 00:00:00 | Madison West | at | [NAME] | 0 | 0 | 7 p.m. | 1 | Big Eight |  | 2021-09-17 00:00:00 | Madison West
2021-09-24 00:00:00 | Baraboo | at | Fort Atkinson |  |  | , | 7 p.m. | 1 | [NAME] | 2021-09-24 00:00:00 | [NAME] | at | [NAME] | 0 | 0 | 7 p.m. | 1 | Big Eight |  | 2021-09-24 00:00:00 | [NAME]
2021-10-01 00:00:00 | Reedsburg | at | Baraboo |  |  | , | 7 p.m. | 1 | [NAME] | 2021-10-01 00:00:00 | [NAME] | at | [NAME] | 0 | 0 | 7 p.m. | 1 | Big Eight |  | 2021-10-01 00:00:00 | [NAME]
2021-10-08 00:00:00 | Baraboo | at | Sauk Prairie |  |  | , | 7 p.m. | 1 | [NAME] | 2021-10-08 00:00:00 | Sun Prairie | at | [NAME] | 0 | 0 | 7 p.m. | 1 | Big Eight |  | 2021-10-08 00:00:00 | Sun Prairie
2021-10-15 00:00:00 | Portage | at | Baraboo |  |  | , | 7 p.m. | 1 | [NAME] | 2021-10-15 00:00:00 | [NAME] | at | Madison East | at | Breese Stevens Field | 7 p.m. | 1 | Big Eight |  | 2021-10-15 00:00:00 | [NAME]
Spreadsheet: 741471d1627051422-formula-not-working-correctly-when-a-cell-is-being-populated-by-another-formula-demo
Sheet: Points

Week 1 | Actual Results
 | H | A |  | Users
 |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "=if(and(b3=e3,d3=f3),3,if(or(e3-f3=b3-d3,and(e3>f3,b3>d3),and(f3>e3,d3>b3)),1,0))" |  |  |  |  |  |  |  |  |  |  |  |  | "=IF(AND(A3=B3,A3=C3,A3=D3),4,IF(A3&B3=C3&D3,3,IF(AND(A3=B3,C3=D3),1,IF(AND(A3>B3,C3>D3),1,IF(AND(A3<B3,C3<D3),1,0)))))"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "=IF(AND(A3=B3,A3=C3,A3=D3),4,IF(A3&B3=C3&D3,3,IF(AND(A3=B3,C3=D3),1,IF(AND(A3>B3,C3>D3),1,IF(AND(A3<B3,C3<D3),1,IF(OR(A3=C3,B3=D3),10,0)))))"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "=IF(AND(A3=B3,A3=C3,A3=D3),4,IF(A3&B3=C3&D3,3,IF(AND(A3=B3,C3=D3),1,IF(AND(A3>B3,C3>D3),1,IF(AND(A3<B3,C3<D3),1,IF(OR(A3=C3,B3=D3),10,0)))))"
Spreadsheet: 754234d1636037893-sheet2-b-get-number-reference-from-another-cell-example-sheet
Sheet: Sheet2

1 | this
2 | is
3 | an
4 | example
5 | sheet
6 | which contains
7 | many different words
8 | and lengths
9 | to be used as an example
10 | please help
11 | on my
12 | original sheet I have
13 | a list of over 2500
14 | words which
15 | I need to reference
16 | and I don't want to have to
17 | type it
18 | all
19 | manually
20 | forever
Spreadsheet: 858784d1707335852-conditional-format-all-columns-if-a-cell-value-excel-forum-week-cf
Sheet: Sheet1

 | WEEK NUMBER
 | 1
[NAME]
Barnsley Chop |  |  |  |  |  |  |  |  |  |  |  | Current  Week
Beverley S |  |  |  |  |  |  |  |  |  |  |  | 6
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Fran
[NAME]
[NAME]
Jake
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 103925d1301578123-colour-cells-based-upon-value-of-another-using-formula-activity-and-wip_2011_v03
Sheet: Marketing_Plan

To Do List
 |  |  |  |  |  |  |  |  |  |  | Development Schedule
 |  |  |  |  |  |  |  |  |  |  | P1 |  |  |  | P2 |  |  |  | P3 |  |  |  | P4 |  |  |  | P5 |  |  |  | P6 |  |  |  | P7 |  |  |  | P8 |  |  |  | P9 |  |  |  | P10 |  |  |  | P11 |  |  |  | P12 |  |  |  | P13
 |  |  |  |  | Commence |  | Complete |  |  |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  | April |  |  |  | May |  |  |  | May/June |  |  |  | June/July |  |  |  | July/Aug |  |  |  | Aug/Sept |  |  |  | Sept/Oct |  |  |  | Oct/Nov |  |  |  | Nov/Dec |  |  |  | Dec/Jan |  |  |  | Jan/Feb |  |  |  | Feb/Mar |  |  |  | Mar
Division | Urgency | Title | Section of The Marketing Plan | Description | PRD | WK | PRD | WK | Status | Notes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qty / Distributed | Design Cost | Print Cost | Packing Cost | Postage Cost | Email Distribution Cost | Total Cost | Qty Leads Submitted | Qty Converted | Total Sale Value
Waste | 1 | WM - Literature | Literature | Product Insert | P1 | 1 | P2 | 4 |  | Have ready for initial print run
Waste | 1 | WM - Literature | Exhibitions | Leglislation Insert | P2 | 1 | P2 | 4
Waste | 1 | WM - Literature | Channel Support | Print of Newly Developed Literature | P1 | 1 | P2 | 4
Waste | 1 | Website Merger | On-Line Activity | HC & Chemical Website Merger | P1 | 1 | P2 | 4
Future Activities
Division |  | Section of The Marketing Plan
Chemical |  | Channel Support
Compliance |  | On-Line Activity
De-Pak |  | Exhibitions
Dynamics |  | Drivers Handbook
Fyr Fyter |  | New Product Development
Healthcare |  | Awards
Internal |  | Literature
Jpen |  | Campaigns
Recyclite |  | Other
Waste
Urgency
1
2
3
4
5
6
Type
Design
Information
Letter
Report
Print
PR
Directory
Advert
Exhibition
Seminar
Spreadsheet
Product Update
[NAME]
[NAME]
Web Page Link
Web Page Update
Web Product Update
[NAME])
ALL
P1
P2
P3
P4
P5
P6
P7
P8
P9
P10
P11
P12
P13
Period(2)
1
2
3
4
Status
Agency Design
[NAME]
Approved
Cancelled
Complete
Delayed
On Hold
On Proof
With Printers
Waiting
WIP
YTC
Spreadsheet: 44223d1242855442-lookup-in-2-columns-sample1
Sheet: Sheet1

PO Number | Line Number | Amount | REQUIRED RESULT
111001 | 1 | 50 | THE ACCOUNT CODE CORESPONDING TO THE PO NUMBERAND THE LINE NUMBER IN SHEET 2 (AA.00.000.725001)
111001 | 2 | 45 | THE ACCOUNT CODE CORESPONDING TO THE PO NUMBERAND THE LINE NUMBER IN SHEET 2 (BB.00.000.733001)
111001 | 3 | 25
111001 | 4 | 30
111001 | 5 | 60