tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79066d1279293831-conditional-formating-referencing-a-formula-condformathelp
Sheet: Test

Code | Nbr | Blding | Nbr2 | Name | Place | St | Nbr3 | Nbr4 | RDATE | PDATE | SDATE | WorkDays_Diff | Window | On Time | On Time | Actually Late? | Description/Notes
 |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | 1 | 2 | ONTIME | 1 |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | 1 | 2 | ONTIME | 1 |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | 1 | 2 | ONTIME | 1
 |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | 1 | 2 | ONTIME | 1
 |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | 1 | 2 | ONTIME | 1
 |  |  |  |  |  |  |  |  | 2010-07-12 00:00:00 | 2010-07-07 00:00:00 | 2010-07-15 00:00:00 | -3 | 2 | LATE | 0 | Yes
 |  |  |  |  |  |  |  |  | 2010-01-14 00:00:00 | 2010-01-14 00:00:00 | 2010-07-15 00:00:00 | -130 | 2 | LATE | 1 | No
 |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | -1 | 2 | LATE | 1
 |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | -1 | 2 | LATE | 1
 |  |  |  |  |  |  |  |  | 2010-08-04 00:00:00 | 2010-07-30 00:00:00 | 2010-07-15 00:00:00 | 14 | 2 | LATE | 1
 |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | -1 | 2 | LATE | 1
 |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | 1 | 2 | ONTIME | 1
 |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 | 2010-07-09 00:00:00 | 2010-07-15 00:00:00 | 1 | 2 | ONTIME | 1
Spreadsheet: 43638d1242286246-how-to-key-a-formula-to-compute-the-due-date-jn8-19
Sheet: PastDue

[NAME], Inc.
Past Due Accounts
Invoice No. | Amount Due | Invoice Date | Due Date | Days Late | 2nd Notice
KK101 | 1000 | 2009-01-01 00:00:00 | 2009-05-12 00:00:00
KK120 | 2000 | 2009-02-01 00:00:00
[NAME] | 23500 | 2009-03-01 00:00:00
KK154 | 4500 | 2009-04-01 00:00:00
KK201 | 20000 | 2009-05-01 00:00:00
[NAME] | 45000 | 2009-06-01 00:00:00
KK307 | 39000 | 2009-07-01 00:00:00
KK338 | 535 | 2009-08-01 00:00:00
[NAME] | 7745 | 2009-09-01 00:00:00
[NAME] | 2545 | 2009-10-01 00:00:00
[NAME] | 8450 | 2009-11-01 00:00:00
KK490 | 15575 | 2009-12-01 00:00:00
Spreadsheet: 37334d1235322161-average-if-statement-based-on-matching-condition-and-date-ranges-copy-of-testtest
Sheet: Summary Sheet

 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | Acc Total
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  | #N/A
Alistair Stevenson | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | 0.8680555555555556 |  |  |  |  |  |  |  |  |  |  |  | 0.8680555555555556
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
Eleanor Ellington | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
Test | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
Test2 | 0.6666666666666666 |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 214994d1361220046-sumif-using-2-variable-references-date-and-acct-number-search
Sheet: Log

Number | Catagorie | Date |  |  |  |  |  | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  | Refference
 | Food | 2011-12-30 00:00:00 |  |  |  |  |  | 140
 | Groceries | 2011-12-31 00:00:00 |  |  |  |  |  | 440
 | Heat | 2012-01-01 00:00:00 |  |  |  |  |  | 45
 | Electric | 2012-01-02 00:00:00 |  |  |  |  |  | 39
 | Food | 2012-01-03 00:00:00 |  |  |  |  |  | 125.3
 | Groceries | 2012-01-04 00:00:00 |  |  |  |  |  | 458.6
 | Misc food | 2012-01-06 00:00:00 |  |  |  |  |  | 25
 | Electric | 2012-01-10 00:00:00 |  |  |  |  |  | 45
 | Wow | 2012-01-10 00:00:00 |  |  |  |  |  | 95
 | Water | 2012-01-13 00:00:00 |  |  |  |  |  | 32
 | Home Ins | 2012-01-15 00:00:00 |  |  |  |  |  | 105
 | Heat | 2012-01-16 00:00:00 |  |  |  |  |  | 75
 | Food | 2013-01-02 00:00:00 |  |  |  |  |  | 115
 | Groceries | 2013-01-06 00:00:00 |  |  |  |  |  | 500
 | Electric | 2013-01-07 00:00:00 |  |  |  |  |  | 42
 | Water | 2013-01-08 00:00:00 |  |  |  |  |  | 28
 | Home Ins | 2013-01-09 00:00:00 |  |  |  |  |  | 105
 | Heat | 2013-01-10 00:00:00 |  |  |  |  |  | 55
Spreadsheet: 36694d1234549165-eliminate-duplicate-data-entries-remove-duplicates
Sheet: Sheet1

[NAME]
[EMAIL] |  |  | Row Labels
[EMAIL] |  |  | [EMAIL]
[EMAIL] |  |  | [EMAIL]
[EMAIL] |  |  | [EMAIL]
[EMAIL] |  |  | Grand Total
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: phillip_m_love__30645__finliq07
Sheet: PE_FIN

PE FINANCIAL
RPT_ID | I/C | DEAL_NUM_STR | DEL_POINT_CD | COMM_CD | REF_IDX_CD | DEL_IDX_CD | BUY_SELL_CD | CTRPTY_LEGAL_NM | SWP_VOL_AMT | OPT_VOL_AMT | TOT_PL_AMT | DEAL_DT | ENTITY_CD | NATR_CD | PMT_CD | PRC_FIX_AMT | PRC_FLOAT_AMT | PRC_PL_AMT | [NAME] | PRC_BOOK_CD | PRC_ORG_CD | BAS_FIX_AMT | [NAME] | BAS_PL_AMT | BAS_PORT_CD | BAS_BOOK_CD | BAS_ORG_CD | PRM_FIX_AMT | [NAME] | PRM_PORT_CD | [NAME] | PRM_ORG_CD | ANN_FIX_AMT | [NAME] | ANN_PORT_CD | ANN_BOOK_CD | ANN_ORG_CD | CTRCT_PRC_AMT | ORIG_CD | TYPE_CD | CALL_PUT_CD | TRAN_START_DT | TRAN_STOP_DT | [NAME] | STATE_OF_INCORPORATION | CURRENCY_CD | UOM_CD | PRC_UOM_CD | ACCT_ENTITY_CD | BookCode | [NAME] | CODED | CoNum | CTRPTY_CD
13841 | 12TF | E90253.C | N/A | NG | ANNUITY |  | S | Enron Oil & Gas Company | -1416080 | 0 | 1416080 | 1998-03-04 00:00:00 | ECT | F | 5BDAP | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 1 | 1416080 | P | E | DESK | 0 | N/A | ANNUITY | C | 1999-01-01 00:00:00 | 1999-12-31 00:00:00 | C | DE | USD | MMBTU | MMBTU | 119 | PE | 1999-07-01 00:00:00 | Deal Coded | 16 | EOG
 | 12TF Total
Spreadsheet: 159688d1338817683-sum-if-based-on-multiple-criteria-sample
Sheet: Summary

Account Manager | Sector | Client ID | [NAME] | QTD Signings |  |  | TOTAL Signings | Week 1 Signings |  |  | Week 2 Signings |  |  | Week 3 Signings |  |  | Week 4 Signings
 |  |  |  | <$1M | $1M-$10M | >$10M |  | <$1M | $1M-$10M | >$10M | <$1M | $1M-$10M | >$10M | <$1M | $1M-$10M | >$10M | <$1M | $1M-$10M | >$10M
AAA | Com | 1581008 | 111
AAA | Com | 1727159 | 222
AAA | Com | 1222880 | 333
BBB | Com | 1293811 | 444
CCC | Com | 1478314 | 555
BBB | Com | 1484060 | 333
CCC | Com | 1496686 | 555
AAA | Com | 1551211 | 222
ZZZ | Com | 1103623 | 111
[NAME] | Com | 1464644 | 111
YYY | Com | 1511914 | 222
MMM | Dis | 1533574 | 333
SSS | Dis | 1168242 | 444
CCC | Dis | 1333836 | 555
[NAME] | Dis | 1623591 | 333
AAA | Dis | 1100271 | 555
ZZZ | Dis | P0050AB | 222
[NAME] | Dis | 1438230 | 111
YYY | Dis | 1045970 | 111
MMM | Dis | 1473461 | 222
SSS | Dis | 1186570 | 333
CCC | Dis | 1393442 | 444
[NAME] | Dis | 1347070 | 555
AAA | Dis | 1257066 | 333
ZZZ | Dis | 1178898 | 555
[NAME] | Dis | 1704531 | 222
YYY | Dis | 1244756 | 111
MMM | Fin | 1060302 | 111
SSS | Fin | 1063739 | 222
CCC | Fin | 1490011 | 333
[NAME] | Fin | 1265133 | 444
AAA | Fin | 1156715 | 555
ZZZ | Fin | 1438293 | 333
[NAME] | Fin | 1461101 | 555
YYY | Fin | 1547965 | 222
MMM | Fin | 1637631 | 111
SSS | Fin | 1648886 | 111
CCC | Ind | 1060110 | 222
[NAME] | Ind | 1612357 | 333
AAA | Ind | 1487380 | 444
ZZZ | Ind | 1074984 | 555
[NAME] | Ind | 1269962 | 333
YYY | Ind | 1201330 | 555
MMM | Ind | 1434580 | 222
SSS | Ind | 1478215 | 111
CCC | Ind | 1698949 | 111
[NAME] | Ind | 1366466 | 222
AAA | Ind | 1336534 | 333
ZZZ | Pub | 1444687 | 444
[NAME] | Pub | 1607713 | 555
YYY | Pub | P007V2B | 333
MMM | Pub | 1268612 | 555
SSS | Pub | 1738365 | 222
CCC | Pub | 1406463 | 111
[NAME] | Pub | 1053077 | 111
AAA | Pub | 1114267 | 222
ZZZ | Pub | 1422308 | 333
[NAME] | Pub | 1453275 | 444
YYY | Pub | 1487780 | 555
MMM | Pub | 1432912 | 333
SSS | Pub | 1250898 | 555
CCC | Pub | 1328252 | 222
[NAME] | Pub | 1626891 | 111
AAA | Pub | 3169527 | 111
ZZZ | Pub | 3169400 | 222
[NAME] | Pub | 3169455 | 333
YYY | Pub | 3169438 | 444
MMM | Pub | 3169405 | 555
SSS | Pub | 3169411 | 333
CCC | Pub | P003LRC | 555
[NAME] | Pub | P003LRE | 222
AAA | Pub | [NAME] | 111
ZZZ | Pub | P003LSF | 111
[NAME] | Pub | 1650608 | 222
YYY | Pub | 1540012 | 333
MMM | Pub | 3169423 | 444
SSS | Pub | 1740324 | 555
CCC | Pub | 1707790 | 333
[NAME] | Pub | 1461624 | 555
Spreadsheet: 774533d1648536196-using-an-approriate-function-aaa
Sheet: Sheet 3

[NAME]
Final Mark | Grade
0 | F
50 | D-
60 | D
64 | [NAME]
67 | C-
70 | C
74 | C+
77 | B-
80 | B
84 | [NAME]
87 | A-
90 | A
Spreadsheet: andy_zipper__169__DYNEGY-ICE VOL Apr13
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
(blank) | #N/A | 1 | 0 |  | (blank) | #N/A | 1 | 0 |  | (blank) | No Activity | 1 | 0
(blank) Total |  | #N/A | 0 |  | (blank) Total |  | #N/A | 0 |  | (blank) Total |  | 1 | 0
Grand Total |  | #N/A | 0 |  | Grand Total |  | #N/A | 0 |  | Grand Total |  | 1 | 0
Spreadsheet: 763328d1642103698-build-a-continuous-column-val-sku-store-lists
Sheet: SKU

SKU
165596
271342
384693
188705
348968
188669
271351
887622
633677
310803
271345
722757
650825
485048
188615
315659
311468
289644
311187
298329
418904
310840
721195
624321
271684
819562
466666
289956
187817
325103
630941
619895
188847
104365
620744
730489
886992
521024
Spreadsheet: 686233d1594444210-how-to-return-first-date-value-in-a-list-that-equals-the-current-month-sample
Sheet: Summary

Table 1 |  |  |  | Table 2 |  |  |  | Table 3
Pay Date |  | Amount |  | Pay Date |  | Amount |  | Pay Date |  | Amount
 |  |  |  | 2020-07-09 00:00:00 |  |  |  | 2020-07-09 00:00:00
 | 1. Amount columns work as designed
 | 2. End result should look like Table 3 (removed formula for visual)
 | 3. Trying to get first cell under Pay Date to return the first value that = the current month on the worksheet with the current year (INDIRECT(YEAR(TODAY())
 | 3. Trying to only display dates for the current month. This formula does not seem to want to work… IF(A3+14<>MONTH(TODAY()),"",A3+14)
Spreadsheet: eric_saibi__9706__010402
Sheet: San Juan 01

Owner Name | Public Service Company of New Mexico
Station Name | San Juan Generating Station
Unit Name | San Juan 01
NERC Region | WSCC
State | NM
Fuel Type | Coal
Capacity | 361 MW
Start Date | 2001-12-31 00:00:00
End Date | 2002-01-05 00:00:00
Comments | Tube Leak
SIC | 4911
Plant ID | 1016385
Unit ID | 1007769
Outage ID | 19358
Spreadsheet: 801316d1666171685-merging-3-sheets-to-one-then-using-filter-function-example-attached-excel-help-3
Sheet: Sheet1

Name | Position | State | Type | Done
AA | RN | SA | Var | Yes
AB | EN | SA | New | No
AC | MR | SA | Var | Yes
AD | RN | SA | New | Yes
AE | EN | SA | New | Yes
AF | MR | WA | Var | Yes
AG | EN | WA | Var | No
AH | MR | WA | New | No
AI | RN | WA | New | No
AJ | EN | WA | New | Yes
AK | EN | WA | Var | Yes
AL | RN | NT | New | No
AM | EN | NT | New | Yes
AN | MR | NT | New | Yes
AO | EN | NT | New | No
AP | RN | NT | Var | Yes
AQ | MR | QLD | Var | No
AR | EN | QLD | New | No
AS | MR | QLD | New | No
AT | MR | QLD | New | No
Spreadsheet: 736292d1623476795-sumif-based-on-date-range-giving-error-euro-pool-2020-master-sheet
Sheet: Score Sheet_Manreet

 |  |  |  |  |  | Name: | Manreet
Group Stage
Game | Group | [NAME] (GMT) |  | (Home) | Result | Confidence Score | (Away)
1 | A | 2021-06-11 21:00:00 | 2021-06-11 21:00:00 | Turkey | D | 1 | Italy
2 | A | 2021-06-12 15:00:00 | 2021-06-12 15:00:00 | Wales | HW | 11 | Switzerland
3 | B | 2021-06-12 18:00:00 | 2021-06-12 18:00:00 | Denmark | HW | 18 | Finland
4 | B | 2021-06-12 21:00:00 | 2021-06-12 21:00:00 | Belgium | HW | 31 | Russia
5 | D | 2021-06-13 15:00:00 | 2021-06-13 15:00:00 | England | AW | 4 | Croatia
6 | C | 2021-06-13 18:00:00 | 2021-06-13 18:00:00 | Austria | AW | 10 | North Macedonia
7 | C | 2021-06-13 21:00:00 | 2021-06-13 21:00:00 | Netherlands | HW | 19 | Ukraine
8 | D | 2021-06-14 15:00:00 | 2021-06-14 15:00:00 | Scotland | AW | 13 | Czech Republic
9 | E | 2021-06-14 18:00:00 | 2021-06-14 18:00:00 | Poland | D | 6 | Slovakia
10 | E | 2021-06-14 21:00:00 | 2021-06-14 21:00:00 | Spain | HW | 26 | Sweden
11 | F | 2021-06-15 18:00:00 | 2021-06-15 18:00:00 | Hungary | AW | 27 | Portugal
12 | F | 2021-06-15 21:00:00 | 2021-06-15 21:00:00 | France | HW | 3 | Germany
13 | B | 2021-06-16 15:00:00 | 2021-06-16 15:00:00 | Finland | D | 5 | Russia
14 | A | 2021-06-16 18:00:00 | 2021-06-16 18:00:00 | Turkey | HW | 12 | Wales
15 | A | 2021-06-16 21:00:00 | 2021-06-16 21:00:00 | Italy | HW | 35 | Switzerland
16 | C | 2021-06-17 15:00:00 | 2021-06-17 15:00:00 | Ukraine | AW | 9 | North Macedonia
17 | B | 2021-06-17 18:00:00 | 2021-06-17 18:00:00 | Denmark | AW | 16 | Belgium
18 | C | 2021-06-17 21:00:00 | 2021-06-17 21:00:00 | Netherlands | HW | 22 | Austria
19 | E | 2021-06-18 15:00:00 | 2021-06-18 15:00:00 | Sweden | D | 8 | Slovakia
20 | D | 2021-06-18 18:00:00 | 2021-06-18 18:00:00 | Croatia | HW | 23 | Czech Republic
21 | D | 2021-06-18 21:00:00 | 2021-06-18 21:00:00 | England | HW | 34 | Scotland
22 | F | 2021-06-19 15:00:00 | 2021-06-19 15:00:00 | Hungary | AW | 36 | France
23 | F | 2021-06-19 18:00:00 | 2021-06-19 18:00:00 | Portugal | HW | 17 | Germany
24 | E | 2021-06-19 21:00:00 | 2021-06-19 21:00:00 | Spain | D | 14 | Poland
25 | A | 2021-06-20 18:00:00 | 2021-06-20 18:00:00 | Switzerland | D | 15 | Turkey
26 | A | 2021-06-20 18:00:00 | 2021-06-20 18:00:00 | Italy | HW | 29 | Wales
27 | C | 2021-06-21 18:00:00 | 2021-06-21 18:00:00 | North Macedonia | AW | 7 | Netherlands
28 | C | 2021-06-21 18:00:00 | 2021-06-21 18:00:00 | Ukraine | HW | 21 | Austria
29 | B | 2021-06-21 21:00:00 | 2021-06-21 21:00:00 | Russia | AW | 20 | Denmark
30 | B | 2021-06-21 21:00:00 | 2021-06-21 21:00:00 | Finland | AW | 30 | Belgium
31 | D | 2021-06-22 21:00:00 | 2021-06-22 21:00:00 | Croatia | HW | 28 | Scotland
32 | D | 2021-06-22 21:00:00 | 2021-06-22 21:00:00 | Czech Republic | AW | 32 | England
33 | E | 2021-06-23 18:00:00 | 2021-06-23 18:00:00 | Sweden | AW | 24 | Poland
34 | E | 2021-06-23 18:00:00 | 2021-06-23 18:00:00 | Slovakia | AW | 25 | Spain
35 | F | 2021-06-23 21:00:00 | 2021-06-23 21:00:00 | Portugal | HW | 2 | France
36 | F | 2021-06-23 21:00:00 | 2021-06-23 21:00:00 | Germany | HW | 33 | Hungary
Spreadsheet: 032250e7-6390-4bf1-91cb-d16ef07ca5d2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Student Success Matix | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Year | 2005 |  |  | 2006 |  |  | 2007 |  |  | 2008
Item | CMA | Comparison Group | CSU Average | CMA | Comparison Group | [NAME] | CMA | Comparison Group | CSU Average | CMA | Comparison Group
Total FTE | 868 | 2616 | 13537 | 871 | 972 | 14536 | 953 | 1221 | 1521 | 988 | 1242
% of all students by Race and Gender
White | 0.54 | 0.76 | 0.374 | 0.54 | 0.85 | 0.373 | 0.59 | 0.82 | 0.39 | 0.62 | 0.82
Black | 0.03 | 0.04 | 0.057 | 0.02 | 0.04 | 0.059 | 0.03 | 0.03 | 0.05 | 0.03 | 0.04
Hispanic | 0.08 | 0.01 | 0.212 | 0.07 | 0.02 | 0.218 | 0.09 | 0.01 | 0.2 | 0.1 | 0.01
Asian | 0.12 | 0.01 | 0.176 | 0.11 | 0.02 | 0.176 | 0.13 | 0.01 | 0.14 | 0.11 | 0.01
Native American | 0.01 | 0 | 0.007 | 0.02 | 0 | 0.007 | 0.02 | 0.01 | 0.01 | 0.02 | 0.01
Unknown | 0.2 | 0.04 | 0.135 | 0.22 | 0 | 0.127 | 0.13 | 0.01 | 0.21 | 0.11 | 0.01
Women | 0.19 | 0.53 | 0.63 | 0.21 | 0.52 | 0.61 | 0.18 | 0.52 | 0.63 | 0.17 | 0.52
Graduation Rate | 1998 cohort First-time |  |  | 1999 cohort First-time |  |  | 2000 cohort First-time |  |  | 2001 cohort First-time
Total | 0.53 | 0.38 | 0.39 | 0.5 | 0.44 | 0.39 | 0.54 | 0.37 | 0.37 | 0.62 | 0.36
White | 0.62 | 0.42 |  | 0.59 | 0.46 |  | 0.53 | 0.4 |  | 0.66 | 0.43
Black | 0.17 | 0.33 |  | 0 | 0.33 |  | 0.4 | 0.2 |  | 0.25 | 0.19
Hispanic | 0.14 | 0.33 |  | 0.6 | 0.46 |  | 0.6 | 0.17 |  | 0.33 | 0.27
Asian | 0.6 | 0.42 |  | 0.57 | 0.4 |  | 0.75 | 0.33 |  | 0.7 | 0.43
Native American | 1 | 0.13 |  | 0 | 0 |  | 0.33 | 0 |  | 0 | 0.14
Unknown | 0.44 | 0.33 |  | 0.34 | 0.3 |  | 0.25 | 0.4 |  | 0.69 | 0.2
Transfer-out Rate | 0.24 | 0.31 |  | 0.26 | 0.16 |  | 0.22 | 0.32 |  | 0.25 | 0.33
Number of degrees awarded | 118 | 544 | 2858 | 114 | 93 | 3015 | 123 | 177 | 31020 | 148 | 184
First-time as % of entering class | 0.63 | 0.64 | 0.56 | 0.63 | 0.68 |  | 0.61 | 0.71 |  | 0.59 | 0.69
First-time retention rate | 0.83 | 0.68 | 0.8 | 0.84 | 0.77 |  | 0.79 | 0.62 |  | 0.74 | 0.63
Spreadsheet: 68532d1269043520-formula-disappears-generic-version
Sheet: Rpt Marketing

 | test
 | SUMMARY
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 | TOTAL MARKETING BUDGET | 0
 |  | Annual Cost
 | 0 | 0
 | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | Annual Cost
 |  | Annual Cost
 | 0 | Annual Cost
 | 0 | Annual Cost
 | 0 | Annual Cost
 | 0 | Annual Cost
 | 0 | Annual Cost
Spreadsheet: 716143d1612057777-adjusting-charges-base-on-deficit-weights-sum-and-product-with-match-type-omitted-dsuarez83-
Sheet: Sheet1

Minimum Charge | 67.32 |  | Weight | 1800 | Charge
0lbs x 7.75 = 0 | 0 | 0 | 0
500lbs x 7.14 / 7.75 = 461 | 500 | 461 | 7.14
1000lbs x 5.34 / 7.14 = 748 | 1000 | 748 | 5.34
2000lbs x 4.10 / 5.34 = 1536 | 2000 | 1536 | 4.1
5000lbs x 3.25 / 4.10 = 3963 | 5000 | 3963 | 3.25
10000lbs x 2.78 / 3.25 = 8554 | 10000 | 8554 | 2.78
Spreadsheet: 539556d1506239877-defined-names-formula-from-sheet-1-to-sheet2-testdefinenames
Sheet: SummaryNODEFINE NAMES 

Tariff No | Description | Origin | Qty_1 | Litres | Sugar | Amount
20087000 | PEACHES IN SYRUP | ZA
20089700 | MIXED FRUITS | ZA
20092900 | RUBY/GRAPE JUICE | ZA
20096990 | JUICES | ZA
20098900 | FRUIT JUICE | ZA
20099000 | FRUIT JUICE MIXTURES | ZA
21041000 | SOUPS PREPARATIONS | ZA
21069070 | JUICE  CONCENTRATE | ZA
21069070 | NECTAR | ZA
17041090 | SUGAR FREE GUMS | ZA
21069090 | JELLY PREPARATIONS | ZA
21069090 | SWEETENERS | ZA
22021010 | AERATED WATER | ZA
22021010 | AERRATED DRINKS | ZA
22021010 | ALOE VERA JUICES | TW
22021010 | ENERGY DRINKS | ZA
22042190 | WINES | ZA
22021020 | CANNED  DRINKS | ZA
22021020 | [NAME] | ZA
22029910 | SOYA MILK | ZA
22029930 | FRUITS DRINKS | ZA
22029970 | MILK BEVERAGES | ZA
22042190 | WINES | PT
22042190 | WINES | ZA
22090010 | VINEGAR | ZA
25010011 | SALT PREPARATION | ZA
30051000 | ADHESIVE PLASTER | ZA
33079010 | BABY WIPES SCENTED | ZA
Spreadsheet: 838145d1690784838-calculating-dates-book1
Sheet: Sheet1

Date | HD | [NAME]
2023-07-31 00:00:00
2023-08-01 00:00:00
2023-08-02 00:00:00
2023-08-03 00:00:00
2023-08-04 00:00:00
2023-08-05 00:00:00
2023-08-06 00:00:00
2023-08-07 00:00:00
2023-08-08 00:00:00
2023-08-09 00:00:00
2023-08-10 00:00:00
2023-08-11 00:00:00
2023-08-12 00:00:00
Spreadsheet: 114845d1310553018-count-totals-by-week-and-month-from-separate-worksheet-big-pnl-sample
Sheet: Weekly sales

 | CASH | CARDS | UNSETTLED | VVIP | VVIP OCUS | CLOAKROOM | TICKETS | ENTs | WASTE | TOTAL WEEK | NET WEEK
W.C. 27.12 |  |  |  |  |  |  |  |  |  |  |  | only since 01.01.2011
W.C. 03.01
W.C. 10.01
W.C. 17.01
W.C. 24.01
W.C. 31.01
W.C. 07.02
W.C. 14.02
W.C. 21.02
W.C. 28.02
W.C. 07.03
W.C. 14.03
W.C. 21.03
W.C. 28.03
W.C. 04.04
W.C. 11.04
W.C. 18.04
W.C. 25.04
W.C. 02.05
W.C. 09.05
W.C. 16.05
W.C. 23.05
W.C. 30.05
W.C. 06.06
W.C. 13.06
W.C. 20.06
W.C. 27.06
W.C. 04.07
W.C. 11.07
W.C. 18.07
W.C. 25.07
W.C. 01.08
W.C. 08.08
W.C. 15.08
W.C. 22.08
W.C. 30.08
W.C. 05.09
W.C. 12.09
W.C. 19.09
W.C. 26.09
W.C. 03.10
W.C. 10.10
W.C. 17.10
W.C. 24.10
W.C. 31.10
W.C. 07.11
W.C. 14.11
W.C. 21.11
W.C. 28.11
W.C. 05.12
W.C. 12.12
W.C. 19.12
W.C. 26.12
W.C. 02.01
W.C. 09.01
W.C. 16.01
W.C. 23.01
W.C. 30.01
TOTALS TYPE
 | CASH | CARDS | UNSETTLED | VVIP | VVIP OCUS | CLOAKROOM | TICKETS | ENTs | WASTE | TOTAL | TOTAL
Spreadsheet: 118813d1314025709-use-value-in-one-cell-to-paste-a-corresponding-row-estimate-details
Sheet: WRF

[NAME] | Dsg | Mass | Ds_i | Dn_i | Wt_i
WRF: Welded Reduced-Flange Shapes |  | kg/m |  | in | lb/ft
* | WRF1800x543 | 543 | WRF71x365 | 71 | 365
 | WRF1800x480 | 480 | WRF71x323 | 71 | 323
 | WRF1800x416 | 416 | WRF71x280 | 71 | 280
* | WRF1600x491 | 491 | WRF63x330 | 63 | 330
 | WRF1600x427 | 427 | WRF63x287 | 63 | 287
 | WRF1600x362 | 362 | WRF63x243 | 63 | 243
* | WRF1400x413 | 413 | WRF55x278 | 55 | 278
 | WRF1400x348 | 348 | [NAME] | 55 | 234
 | WRF1400x284 | 284 | WRF55x191 | 55 | 191
* | [NAME] | 373 | WRF47x251 | 47 | 251
 | WRF1200x309 | 309 | WRF47x208 | 47 | 208
 | WRF1200x244 | 244 | WRF47x164 | 47 | 164
* | WRF1000x340 | 340 | WRF39x228 | 39 | 228
 | WRF1000x275 | 275 | WRF39x185 | 39 | 185
 | WRF1000x210 | 210 | WRF39x141 | 39 | 141
Spreadsheet: 880599d1728408511-appending-total-at-last-with-sum-from-i-to-p-with-lookup-demo
Sheet: Sheet1

 |  |  | Month | DO |  | Date | ID No | Pest No | Entities | Mobile No |  | My Work | Quad | [NAME] |  |  |  |  |  |  |  | Col W | Col X | Col Y | Col Z | Col AA | Col AB | Col AC |  |  |  |  | Col AH | Col AI | Col AJ | Col AK | Col AL | Col AM | Col AN
 |  |  | Jan | 5 |  | 2024.9.26 | 6256 | 11 | Amazon Inc | 63563 |  | Pepsi Cola | 500 | ab |  |  |  |  |  |  |  | 5000 | 200 |  |  |  |  | 97
 |  |  | Jan | 4 |  | 2081.04.01 |  |  | Google Chrome | 6 |  |  | 526 | ms |  |  |  |  |  |  |  | 1259.3 | 4000 | 820 | 300
 |  |  | Jan | 3 |  | 2081.04.01 |  |  | American International | 44563 |  | abc |  |  |  |  |  |  |  |  |  | 3755 | 488.15 |  |  | 63 | 44
 |  |  | Jan | 2 |  | 2081.04.03 |  |  | Los Angle Corp | 516 |  | Mass |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | Jan | 5.5 |  | 2081.04.06 |  |  | Tesla |  |  |  |  |  |  |  |  |  |  |  |  | 24200 | 3146 |  |  |  |  | 20 |  |  | 0 | 0
 |  |  | Jan | K12 |  | 2081.04.03 |  |  | Gluco India | 56 |  |  |  |  |  |  |  |  |  |  |  | 46250 | 6012.5 |  |  |  |  |  |  |  | 0 | 0
 |  |  | Feb | M7 |  | 2081.04.04 |  |  | [NAME] | 95 |  | Easter |  |  |  |  |  |  |  |  |  | 2333.96 | 303.41
 |  |  | Feb | K85 |  | 2081.04.04 |  |  | Luconbond | 949 |  | Puppy,mest. | 2 | KL |  |  |  |  |  |  |  | 2600 | 338
 |  |  | Feb | N24 |  | 2081.04.04 |  |  | Parrator | 416 |  | Johney |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 |  |  |  |  |  |  | 3314469 | 430881 |  |  |  |  | 1500
 |  |  | Feb | S34 |  | 2081.04.04 |  |  | test2 |  |  |  |  |  |  |  |  |  |  |  |  | 526 | 6 |  |  |  |  |  |  |  |  |  | 5338109 | 693955 |  |  |  |  | 1500
 |  |  | Feb | G-54 |  | 2081.04.04 |  |  | Test5 | 666 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2100 | 273
 |  |  | Jan | S-2 |  | 2081.04.04 | 17268 |  | Ntel | 526 |  | Telephone Expenses |  |  |  |  |  |  |  |  |  | 1924.91 | 250.24 |  |  |  |  | 20