tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9060b7ec-ce3d-4b4f-a1f1-5aeebb7d37fe
Sheet: Printing

PRINTING
List cost of printing services.
Printing costs are services paid for printing forms, brochures, monitoring forms and newsletters.
Do NOT include cost of  copying (cost of copying should be listed under "Supplies")
[NAME] | Printing Company Name | Quantity | Cost/Unit | Annual Cost | % Allocated to CACFP | Total Annual Cost to CACFP
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | Total PRINTING
Spreadsheet: 739879d1626035878-dynamic-range-for-excel-chart-chart-from-two-tables-that-automatically-updates-when-data-is-added-jeevanuae-
Sheet: Data

Counts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Davg
Months | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | Months | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
2021-02-01 00:00:00 | 26 | 25 | 21 | 18 | 28 | 27 | 27 | 23 | 24 | 21 | 19 | 19 | 19 | 19 | 22 | 18 | 17 | 23 | 27 | 29 | 21 | 19 | 26 | 28 |  | 2021-02-01 00:00:00 | 4.5 | 5.1 | 6.5 | 9 | 5.7 | 7 | 5.9 | 3.9 | 4.5 | 4.9 | 4.5 | 4.8 | 4.5 | 4 | 5.4 | 4.3 | 4.7 | 4.1 | 3.7 | 4.2 | 3.9 | 4 | 4.3 | 4.5
2021-03-01 00:00:00 | 28 | 27 | 20 | 19 | 30 | 27 | 28 | 26 | 27 | 22 | 23 | 19 | 20 | 18 | 22 | 20 | 19 | 25 | 30 | 32 | 21 | 19 | 25 | 30 |  | 2021-03-01 00:00:00 | 4.199999999999999 | 4.199999999999999 | 3.7 | 3 | 4.4 | 4.3 | 4.300000000000001 | 3.9 | 5.199999999999999 | 5 | 5 | 5.1 | 4.800000000000001 | 4.8 | 6.3 | 4.199999999999999 | 4.6 | 4.2 | 4.5 | 4.6 | 3.3 | 3.7 | 3.9 | 4.4
2021-04-01 00:00:00 | 24 | 29 | 22 | 22 | 28 | 27 | 27 | 28 | 24 | 23 | 21 | 19 | 23 | 19 | 19 | 23 | 19 | 27 | 28 | 29 | 22 | 18 | 22 | 30 |  | 2021-04-01 00:00:00 | 3.8 | 4 | 4.1 | 3.7 | 5.199999999999999 | 5.199999999999999 | 3.7 | 3.7 | 4.9 | 4.3 | 4.7 | 4.199999999999999 | 5.5 | 5.199999999999999 | 4.300000000000001 | 5 | 4.8 | 3.8 | 4.3 | 4.1 | 3.4 | 3.3 | 4 | 4.7
2021-05-01 00:00:00 | 22 | 23 | 18 | 20 | 27 | 25 | 24 | 28 | 22 | 19 | 21 | 16 | 19 | 18 | 16 | 23 | 19 | 26 | 26 | 28 | 19 | 15 | 21 | 27 |  | 2021-05-01 00:00:00 | 3.7 | 3.7 | 3.4 | 3.5 | 4.9 | 4.6 | 3.7 | 3.8 | 4.300000000000001 | 4.1 | 4.5 | 4.8 | 4.9 | 4.5 | 4.3 | 5.1 | 5.1 | 3.8 | 3.8 | 4.2 | 3.3 | 3.5 | 3.3 | 4.4
2021-06-01 00:00:00 | 23 | 22 | 19 | 20 | 28 | 24 | 26 | 29 | 25 | 20 | 22 | 19 | 20 | 19 | 16 | 23 | 21 | 27 | 27 | 30 | 20 | 15 | 23 | 25 |  | 2021-06-01 00:00:00 | 4.8 | 3.8 | 4.3 | 3.8 | 5.6 | 4.9 | 4.5 | 4.1 | 5.4 | 4.7 | 4.8 | 5.1 | 5.1 | 5 | 4.9 | 5 | 4.5 | 4.9 | 4.5 | 4 | 4.1 | 3.4 | 3.9 | 4.5
Spreadsheet: 835173d1688383087-linking-two-excel-tabs-using-common-columns-01-expensestravel-index-test
Sheet: visits 

temple | City or town | Place | location | trip 1 | trip2 | trip 3 | trip 4 | trip 5 | trip 6 | trip 7 | trip 8 | trip 9 | trip 10 | trip 11 | trip 12 | trip 13 | trip 14 | trip 15 | trip 16 | trip 17 | trip 18 | trip 19 | trip 20 | trip 21 | trip 22 | trip 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1992 to 2005 | 2005_to-2013 | 2015 onwards
abhirami | THIRUKKADAIYIUR |  |  | 19 Jul 2012
Adimoolavaradperumal | chennai | vadapalani | vadapalani | 2019-04-14 00:00:00 | 2019-08-21 00:00:00 | 2021-03-14 00:00:00 | 2022-02-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tamil new year
[NAME] | chennai | T Nagar |  | 2021-02-28 00:00:00 | 2021-09-14 00:00:00 | 2021-12-09 00:00:00 | 2021-12-21 00:00:00 | 2022-03-24 00:00:00
[NAME] , saneeswar | pozhichalur |  |  | 07_11_2020
Anjaneyar | chennai | ashok nagar |  | 2018-09-29 00:00:00 | 2019-01-07 00:00:00 | 2019-07-27 00:00:00 | 2021-07-24 00:00:00 | 2021-07-25 00:00:00 | 2021-08-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tamil new year
Spreadsheet: 778853d1651399116-formula-to-calculate-change-percentage-change-aligw
Sheet: Sheet1

Line item | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | % Change
8400/000 STD BANK 270466274 | 0 | 0
8410/000 Petty Cash | 0 | 0
TOTAL OPENING BANK BALANCE | 0 | 381750.5
Receipts from Customers | 1262299.59 | 1493487.59
Rebates Received | 19841.16 | 5762.17
Rental Office Equipment | 10043.75 | 7975.25
Standard Bank COVID 19 Loan | 0 | 51680.02
STANDARD BANK LOAN ACCOUNT | 0 | 0
Sundry Customers | 0 | 0
Sundry Income | 0 | 0
STD BANK 270466274 | 0 | 100000
Petty Cash | 0 | 200000
Standard Bank - Savings Acc -  374575568 | 0 | 200000
Deferred - Standard Bank - Tata | 0 | 0
Sars - Income Tax | 0 | 1499249.76
TOTAL RECEIPTS | 2153096.14 | 1499249.76
Payments to Suppliers | 868684.2 | 1305769.94
Accounting Fees | 10250 | 11850
Bank Charges | 1992.49 | 2013.41
Cleaning | 801 | 840
Computer Expenses | 4957.5 | 0
Consulting Fees | 0 | 1650
Courier & Postage | 0 | 0
CELL PHONE EXPENSES | 0 | 0
Donations | 17000 | 0
Directors Fees / Members Remuneration | 17000 | 0
Entertainment Expenses | 0 | 0
General Expenses | 6000 | 6000
General Expenses      - Gifts | 0 | 6000
General Expenses - Fines | 0 | 0
Interest Paid - Bank | 10370.69 | 0
Insurance | 10370.69 | 9639.2
Leasing Charges | 892.4 | 972.72
Motor Vehicle Expenses | 800 | 0
Motor Vehicle Expenses  - Parking | 0 | 0
Motor Vehicle - Petrol & Oil | 0 | 600
Motor Vehicle - Repairs & Maint. | 1377.7 | 487
Printing & Stationery | 1377.7 | 1378.46
Repairs & Maintenance | 1154.7 | 142
Repairs and Maintenance - Office | 0 | 142
Salaries & Wages | 0 | 1747.72
Salaries & Wages - Casual Wages | 458.99 | 1747.72
Security Costs | 458.99 | 504.89
Staff [NAME] | 0 | 5184.88
Staff Training | 0 | 2629
Staff Welfare | 87.94 | 2629
Subscriptions | 161 | 2195.61
Staff Loans | 2584.52 | 0
Telephone & Fax | 2584.52 | 4691.48
Standard Bank - Mini Countryman | 0 | 6615.05
STANDARD BANK- KIA2020-CAA127242 | 0 | 3929.94
STANDARD BANK-KIA 2020-CAA127248 | 0 | 3929.94
STANDARD BANK-FORD RANGER-CAA82115 | 0 | 5849.89
Computer Software | 0 | 0
Loan Account - I Wilcox | 0 | 0
Standard Bank Credit Card Acc | 40460.96 | 96597.05
Standard Bank - Salaries account | 200000 | 150000
Salary & Wages Control | 31379.93 | 0
Sundry Creditors | 0 | 0
Vat / Tax Control Account | 0 | 0
TOTAL PAYMENTS | 1209457.77 | 2039265.09
NET CASH MOVEMENT | 943638.37 | -540015.33
JOURNAL ENTRIES PROCESSED | 789964.95 | 100000
TOTAL CLOSING BANK BALANCE | 0 | -58264.83
Spreadsheet: 51005d1250605862-extracting-values-in-a-specific-text-book1
Sheet: Sheet1

 | ins | fire | flood | wind | fire/flood | fire/flood/wind
2,232.62 flood 08 |  |  | 2232.62
1,398.00 ins 09-10 fire, flood |  |  |  |  | 1398 |  |  | <<<<------ the data from a2:a5 is only copied and paste from some website, so it can be interchange, and that's how my format goes
25.00 ins | 25
1,500.00 ins 09-10 fire, flood,wind |  |  |  |  |  | 1500
total | 25 |  | 2232.62 |  | 1398 | 1500
Spreadsheet: 694250d1599476539-formula-required-for-return-the-product-item-code-from-another-sheet-product-code
Sheet: Sheet2

Product | Item Code
.DGO 10ppm WJDG45 GEN [DCC-MT03/OLS00099] | AD1
.DGO 10ppm 43839 P/UP [DCC-MT03/OLS00099] | AB2
.DGO 10ppm TMG34 GEN [DCC-MT03/OLS00099] | AD1
.DGO 10ppm WJDP64 DWP [DCC-MT03/OLS00099] | AB2
.DGO 10ppm WJDP DWP [DCC-MT03/OLS00099] | AD15
.DGO 10ppm SG432 GEN [DCC-MT03/OLS00099] | AB2
.DGO 10ppm EXC49 [DCC-MT03/OLS00099] | AD11
.DGO 10ppm WJDG90 GEN [DCC-MT03/OLS00099] | AB2
.DGO 10ppm 28465 CRANE [DCC-MT03/OLS00099] | AD1
.DGO 10ppm TG339 GEN [DCC-MT03/OLS00099] | AB2
.DGO 10ppm WJDG72 GEN [DCC-MT03/OLS00099] | AD12
.DGO 10ppm GE200A006 GEN [DCC-MT03/OLS00099] | AB2
.DGO 10ppm TG300 GEN [DCC-MT03/OLS00099] | AD1
.DGO 10ppm CRP104 [DCC-MT03/OLS00099] | AB2
.DGO 10ppm [NAME] [DCC-MT03/OLS00099] | AD1
Spreadsheet: 2df5863f-2c6a-4bb8-b59b-b0cf166474bd
Sheet: Sheet1

Country Statistical Tables for North Africa
This Contents sheet provides an explanation of each worksheet in the file.
Users are encouraged to read Food Security Assessment (FSA), which discusses global food
security issues and estimates food gaps for 70 lower income countries. The report was published in
May 2005 and is available at http://www.ers.usda.gov/Publications/GFA16/ .
The report estimates the number of hungry people to evaluate the progress made toward the
World Food Summit goal of reducing the number of hungry people by half by 2015.
Factors affecting food security, such as food production, imports and food aid are discussed.
The tables and charts provided in this file are not found in the report.
This file contains:
- 4 country statistical sheets
Each country is identified by its 2-digit country code (the country code key is listed below).
Each country sheet contains two tables and one chart with data relevant to food security.
Table "Food availability and food gaps" contains 9 years of historical data and estimates/projections
for 2004, 2009, and 2014. Grain production data are extracted from the Production, Supply and
Demand database of USDA as of October 2004. The 2004 figure of grain production is actual data.
Root production data are from FAOSTAT, available through 2003, then converted into grain equivalent.
Commercial grain imports are from FAO and Food aid data from WFP. Total food availability is a
calculated amount of all food available, converted into grain equivalent. For information on the
definitions and method of calculation of food gaps please see "Appendix 1: Methodology" in the FSA
report. The chart "Cereal and Non-cereal Imports" plots 10 years of FAO data. The table
"Import share of domestic supply" contrasts average 1992-93 commodity import shares with 2001-02
shares, all of which are presented in separate sheets as described below for all 70 countries included
in the study.
- North Africa sheet
This sheet contains "Food availability and food gaps" data aggregated for all North African countries, a
chart on food aid effectiveness, a chart and a table on food import dependency in the region, and a
text box, summarizing the trend of food security in the region.
Country code key:
DZ = Algeria
EG = Egypt
MA = Morcocco
TN = Tunisia
Spreadsheet: 190196d1351554004-multiple-formulas-needed-in-one-cell-to-create-a-value-in-a-new-cell-media-tracking-sheet
Sheet: Tables - Avg Daily Sales

Avg Daily Sales (Avg)
Medium
 | TV | Radio
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
TV Station
 | Seven Network | Nine Network | Network Ten | Prime7 | NBN | SCA | WIN
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Radio Station
 | ATN | 97.3 | Triple M | Beat 105 | Nova | Sea FM | Gold FM | Hot Tomato | 2DAY | Mix | WSFM | FOX FM | 92.9 | 96FM | NXFM | KOFM | SAFM | 104.7
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
TV Reach % |  |  |  |  |  |  | TV Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Radio Reach % |  |  |  |  |  |  | Radio Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Spreadsheet: 679587d1590510576-worksheet-formula-to-count-repeating-sequence-pattern-in-cells-of-column-list-testing-counting-patterns-in-a-column
Sheet: Testing Number Formulas

 | Number Set 3 Overlapping | Correct Answer = |  |  |  |  |  |  | 4 | 3 | 5 | 4 | 3 | 5
1 | Data List |  |  | Number Sequence 1 | Text Sequence 1 | Number Sequence 2 Repeting numbers | Text Sequence 2 Repeating text |  | Number Set 1 | Number Set 2 | Number Set 3 Overlapping | Text Set 1 | Text Set 2 | Text Set 3 Overlapping
2 |  |  |  | 3 | Z | 4 | T |  | 3 | 4 | 4 | Z | 4 | T |  | 3 | Z | 4 | T
3 |  |  |  | 5 | A | 9 | G |  | 5 | 3 | 9 | A | Z | G |  | 5 | A | 9 | G
4 |  |  |  | 2 | C | 2 | L |  | 2 | 5 | 2 | C | A | L |  | 2 | C | 2 | L
5 |  |  |  | 6 | B | 6 | M |  | 6 | 2 | 6 | B | C | M |  | 6 | B | 6 | M
6 |  |  |  | 9 | E | 3 | S |  | 9 | 6 | 3 | E | B | S |  | 9 | E | 3 | S
7 |  |  |  | 8 | F | 4 | T |  | 8 | 9 | 4 | F | E | T |  | 8 | F | 4 | T
8 |  |  |  | 5 | G | 9 | G |  | 5 | 8 | 9 | G | F | G |  | 5 | G | 9 | G
9 |  |  |  |  |  |  |  |  | 3 | 5 | 2 | Z | G | L
10 |  |  |  |  |  |  |  |  | 5 | 2 | 6 | A | C | M |  |  |  | 1 | K
11 |  |  |  |  |  |  |  |  | 2 | 3 | 3 | C | Z | S |  |  |  | 5 | Z
12 |  | The following 4 formulas only work with numbers: |  |  |  |  |  |  | 6 | 5 | 4 | B | A | T
13 |  |  |  |  |  |  |  |  | 9 | 2 | 9 | E | C | G
14 |  |  |  |  |  |  |  |  | 8 | 6 | 1 | F | B | K
15 |  |  |  |  |  |  |  |  | 5 | 9 | 4 | G | E | T
16 |  |  |  |  |  |  |  |  | 5 | 8 | 9 | 5 | F | G
17 |  |  |  |  |  |  |  |  | 4 | 5 | 2 | 4 | G | L
18 |  |  |  |  |  |  |  |  | 3 | 9 | 6 | Z | E | M
19 |  |  |  |  |  |  |  |  | 5 | 9 | 3 | A | E | S
20 |  |  |  |  |  |  |  |  | 2 | 1 | 4 | C | L | T
21 |  |  |  |  |  |  |  |  | 6 | 6 | 9 | B | B | G
22 |  |  |  |  |  |  |  |  | 9 | 9 | 5 | E | E | Z
23 |  |  | This formula might be modified incorrectly and does not give the correct answer for all 3 sets of data: |  |  |  |  |  | 8 | 7 | 4 | F | 7 | T
24 |  |  |  |  |  |  |  |  | 5 | 5 | 9 | G | 5 | G
25 |  |  |  |  |  |  |  |  | 9 | 4 | 2 | 9 | 4 | L
26 |  | The following formulas work with both numbers and text: |  |  |  |  |  |  | 1 | 6 | 6 | 1 | 6 | M
27 |  |  |  |  |  |  |  |  | 6 | 7 | 3 | 6 | 7 | S
28 |  |  |  |  |  |  |  |  | 9 | 3 | 4 | 9 | Z | T
29 |  |  |  |  |  |  |  |  | 7 | 5 | 9 | 7 | A | G
30 |  |  |  |  |  |  |  |  | 2 | 2 | 3 | 2 | C | S
31 |  |  |  |  |  |  |  |  | 3 | 6 | 4 | Z | B | T
32 |  |  |  |  |  |  |  |  | 5 | 9 | 9 | A | E | G
33 |  |  |  |  |  |  |  |  | 2 | 8 | 2 | C | F | L
34 |  |  |  |  |  |  |  |  | 6 | 5 | 6 | B | G | M
35 |  |  |  |  |  |  |  |  | 9 | 6 | 3 | E | B | S
36 |  |  |  |  |  |  |  |  | 8 | 9 | 4 | F | E | T
37 |  |  |  |  |  |  |  |  | 5 | 7 | 9 | G | Z | G
 |  | Not available in Excel 2016:
 |  | =(LEN(TEXTJOIN("",,B3:B59))-LEN(SUBSTITUTE(TEXTJOIN("",,B3:B59),TEXTJOIN("",,C3:INDEX(C:C,MATCH(REPT("Z",255),C:C))),"")))/COUNTA(C3:C24)
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.09.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-09 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 7 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 20 | 0 | 4 | 0 | 2 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 4 | 0 | 3 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 22 | 0 | 5 | 0 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 9 | 0 | 4 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 2 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-09 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 25 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 19 | 0 | 5 | 1 | 2 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 2 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
Spreadsheet: 63944d1264792991-excel-2007-subtotal-comp-sci-edit
Sheet: Sheet1

CS 1TA3 |  | 3 units
What | My grade | Scheme 1 | Scheme 2 | Earned
Final Exam |  | 40 | 40 | 0
Assignment 1 | 0.55 | 10 | 15 | 8.25
Assignment 2 | 0.85 | 10 | 15 | 12.75
Assignment 3 |  | 10 | 15 | 0
Quiz 1 | 0.8 | 3 | 1.5 | 1.2
Quiz 2 | 0.83 | 3 | 1.5 | 1.245
Quiz 3 | 0 | 3 | 1.5 | 0
Quiz 4 | 1 | 3 | 1.5 | 1.5
Quiz 5 |  | 3 | 1.5 | 0
Quiz 6 |  | 3 | 1.5 | 0
Quiz 7 |  | 3 | 1.5 | 0
Quiz 8 |  | 3 | 1.5 | 0
Quiz 9 |  | 3 | 1.5 | 0
Quiz 10 |  | 3 | 1.5 | 0
Quiz 11 |  | 3 | 1.5 | 0
 | Subtotal | 18.89 | 23.445
Assignments | 21 | out of
Quizes | 3.945 | out of | #N/A
Exam | 0 | out of | 40
 | #N/A |  | 23
Spreadsheet: f4d64b19-aa3c-486e-aa72-e8bb61dd440a
Sheet: Sheet1

Index Investment Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
In U.S. Dollars and Futures Equivalent Contracts
 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
U.S. Futures Market1 | Notional Value (Billions US$) |  |  | Futures Equivalent Contracts3 (Thousands)
(Notional Value > 0.5 billion US$)2 | Long | Short | Net L (S) | Long | Short | Net L (S)
Cocoa | 1.1 | -0.3 | 0.7 | 45 | -15 | 31
Coffee | 4.5 | -1.9 | 2.6 | 68 | -28 | 40
Copper | 9.4 | -2.8 | 6.6 | 110 | -33 | 77
Corn | 21.6 | -6.8 | 14.8 | 540 | -169 | 371
Cotton | 3.8 | -1.3 | 2.5 | 105 | -36 | 69
[NAME] | 0.7 | -0.2 | 0.5 | 10 | -3 | 7
Gold | 22.9 | -5.2 | 17.7 | 142 | -32 | 110
Heating Oil | 9.7 | -2.9 | 6.9 | 81 | -24 | 57
[NAME] | 4.6 | -1.4 | 3.2 | 140 | -43 | 97
Live Cattle | 8.5 | -2.6 | 5.9 | 169 | -52 | 117
Natural Gas | 18.1 | -5 | 13.2 | 544 | -154 | 390
Platinum | 0.8 | -0.2 | 0.6 | 11 | -3 | 8
RBOB Unleaded Gas | 10.1 | -1.8 | 8.3 | 90 | -16 | 75
Silver | 5.6 | -1.3 | 4.3 | 40 | -9 | 31
Soybean Meal | 1 | 0 | 0.9 | 20 | -1 | 19
Soybean Oil | 4.8 | -1.2 | 3.5 | 149 | -38 | 111
Soybeans | 21.2 | -6 | 15.2 | 261 | -73 | 187
Sugar | 9.7 | -2.9 | 6.7 | 380 | -115 | 265
Wheat (CBOT) | 15.6 | -6.7 | 8.9 | 352 | -151 | 200
Wheat (KCBT) | 2.5 | -0.6 | 1.9 | 56 | -14 | 42
WTI Crude Oil | 46.4 | -13.9 | 32.5 | 523 | -157 | 366
Subtotal (>0.5 billion US$) | 222.5 | -65 | 157.5
Subtotal (<0.5 billion US$) | 0.8 | -0.2 | 0.6
Total Notional US Mkts | 223.3 | -65.2 | 158.1
Total Not'l Non-US Mkts | 57.7 | -15.6 | 42.1
Total All Markets | 281 | -80.8 | 200.2
1 Each listed U.S. futures market includes index investment for all futures and OTC markets related to or referenced to that U.S. futures market.  For example, the U.S. market listed as “WTI Crude Oil” includes (with the NYMEX’s Light “Sweet” crude oil futures market) investments held in the NYMEX “Crude Oil Financial” market and the ICE Futures-Europe WTI Light Sweet crude oil market, because both of those contracts’ settlement prices are determined by reference to the NYMEX Light “Sweet” crude oil futures contract.
2 US Futures Markets with 0.5 billion US dollars or more in reported net index investment notional value on the report date.
3Futures Equivalent Contracts: Futures plus delta-adjusted options, estimating what [NAME] would have been established absent offsets.
(See the Explanatory Notes for more details about this data)
Spreadsheet: 454373d1459815003-weighted-average-of-non-empty-grades-gradecalc
Sheet: Sheet1

[NAME] | 25 | 15 | 20 | 35
 | Exam 1 | Exam 2 | Exam 3 | Exam 4 | Final Grade
Student 1 | 23 | 15 | 20 | 33
Student 2 |  | 15 | 18
Student 3 | 25 | 12 | 20
Student 4 |  | 15 | 20
Spreadsheet: 266458d1379617782-formula-for-each-month-and-number-count-for-exceptions-setup-exception-tracking-by-ae-example
Sheet: Abdul

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception %
2013-03-31 00:00:00 |  |  |  |  |  |  | 0 | 22
2013-04-30 00:00:00 |  |  |  |  |  |  | 0 | 41
2013-05-10 00:00:00 | Nakoma Realty | [NAME] | [NAME] | McGanty | 39334 | paystub & credit report >60 | 1 | 34
2013-06-05 00:00:00 | Better Home Financial | [NAME] | [NAME] | Thorpe | 39154 | paystubs >30 & missing bank stmt
2013-06-05 00:00:00 | Better Home Financial | [NAME] | [NAME] | Thorpe | 39157 | paystubs >30 & missing bank stmt
2013-06-24 00:00:00 | Better Home Financial | [NAME] | [NAME] | Brainard | 39567 | asset stmt missing 2 pgs | 3 | 30
2013-07-03 00:00:00 | Apex Financial Group | [NAME] | [NAME] | Ocampo | 40022 | asset >45
2013-07-09 00:00:00 | Sierra Mortgage | [NAME] | [NAME] | Buda | 40113 | missing prelim
2013-07-23 00:00:00 | Sierra Mortgage | [NAME] | [NAME] | Jucha | 40343 | missing 2012 W2s from both jobs
2013-07-24 00:00:00 | Empyrean Funding & Mgmt | Peyman [NAME] | [NAME] | Rapoport | 40365 | Prelim >45 | 4 | 23
2013-08-07 00:00:00 | C and H Financial | [NAME] | [NAME] | [NAME] | 40692 | Assets >45
2013-08-09 00:00:00 | Northstar Financial | [NAME] | [NAME] | [NAME] | 40709 | pay stub >30 & assets >45 | 2 | 22
2013-09-13 00:00:00 | Apex Financial Group | [NAME] | [NAME] | Berdnik | 41291 | missing prelim
Spreadsheet: 822680d1679485881-need-help-what-formula-use-in-ms-2019-for-filter-sample-49-ans
Sheet: Sheet1

Order# | PO# |  | Abc | Date | Line1 | Line2 | [NAME] | Balance
123 | 111 |  |  |  |  |  |  | 500
124 | 222 |  |  |  |  |  |  | 500
520 | 333 |  |  |  |  |  |  | 0
200 | 1A |  |  |  |  |  |  | 150
ABC | A |  |  |  |  |  |  | 111
Expected Results |  |  |  |  |  | Expected Results
 | PO# | Balance |  |  |  | Order# | PO# | Balance
123 | 111 | 500
124 | 222 | 500
200 | 1A | 150
ABC | A | 111
Spreadsheet: 733577d1621628604-not-sure-how-to-tackle-this-sample
Sheet: Sheet2

EMPLID | NAME | ACTION | EFFDT
10001 | DUCK,[NAME] | H | 2016-08-15 00:00:00
10001 | DUCK,[NAME] | T | 2016-09-06 00:00:00
10001 | DUCK,[NAME] | H | 2016-09-17 00:00:00
10001 | DUCK,[NAME] | T | 2016-10-02 00:00:00
10002 | [NAME],MICKEY | H | 2019-06-04 00:00:00
10002 | [NAME],MICKEY | T | 2019-08-11 00:00:00
10002 | [NAME],MICKEY | H | 2019-08-12 00:00:00
10002 | [NAME],MICKEY | T | 2019-09-23 00:00:00
10003 | [NAME],MINNIE | H | 2020-02-27 00:00:00
10003 | [NAME],MINNIE | T | 2021-03-19 00:00:00
Spreadsheet: 167794d1342105043-excel-2007-vlookup-help-2012-bud-help
Sheet: Mar

Monthly [NAME]
 | [NAME] |  |  | Date Due | Date Paid | Amount Due | Amount Paid | Status | Comment
 | Mortgage |  |  | 2012-03-01 00:00:00 | 2012-02-26 00:00:00 | 875.48 | 875.48
 | Tundra |  |  | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 | 343.92 | 343.92
 | Sorento
 | Verizon Wireless |  |  | 2012-03-23 00:00:00 | 2012-03-25 00:00:00 | 167.54 | 167.54
 | RZMC |  |  | 2012-03-18 00:00:00 | 2012-03-17 00:00:00 | 47 | 47
 | Capital One |  |  | 2012-03-18 00:00:00 | 2012-03-15 00:00:00 | 25 | 25
 | Household Bank
 | Insurance |  |  | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 | 79.8 | 79.8
 | RG&E |  |  | 2012-03-12 00:00:00 | 2012-03-17 00:00:00 | 153.48 | 153.48
 | Time Warner |  |  | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | 119.08 | 119.08
 | ACS |  |  | 2012-04-04 00:00:00 | 2012-03-24 00:00:00 | 157 | 157
 | AES |  |  | 2012-04-04 00:00:00 | 2012-03-24 00:00:00 | 113 | 113
 | Sallie Mae |  |  | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 213.47 | 213.47
 | 1st Financial |  |  | 2012-04-04 00:00:00 | 2012-03-24 00:00:00 | 35 | 35
 | Waste Management
 | Water Authority
 | Wells Fargo - Furniture |  |  | 2012-03-11 00:00:00 | 2012-03-12 00:00:00 | 30.14 | 40
 | Doe |  |  |  |  |  | 300
 | [NAME] |  |  |  | 2012-03-12 00:00:00 |  | 350
 |  |  |  |  | 2012-03-21 00:00:00 |  | 175
 | [NAME]
 | Paychecks |  |  | Pay Date | Amount
 |  |  |  | 2012-03-07 00:00:00 | 1363.86
 |  |  |  | 2012-03-21 00:00:00 | 1583.44