tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dan_hyvl__4723__Arizona Public Service Master Physical 03272001
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-03-27 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Arizona Public Service Company | CONTACT: | Mr. [NAME]
ADDRESS: | 400 N. 5th Street | TITLE:
 | Phoenix, AZ 85004-2167 | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING: | BBB+
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | 5000000 | 25000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp. (BBB+)
LIMIT in $[NAME] |  | 30000000
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = | BBB- | BBB- | Standard & Poor's
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-EBITDA/Interest
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 5000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES:    X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: 829865d1684504041-converting-a-date-formatted-cell-into-text-so-it-can-be-encoded-into-barcode-excelhelpforum-barcode-label-copy
Sheet: GTIN-14 Reference

[NAME] GTIN-14 | Product Description
90860001575005 | BRANZINI 400-600 GREECE 10KG
90860001575012 | BRANZINI 400-600 GREECE 10KG
90860001575029 | BRANZINI 400-600 TURKEY 10KG
90860001575036 | BRANZINI 600-800 GREECE 10KG
90860001575043 | BRANZINI 600-800 GREECE 10KG
90860001575050 | BRANZINI 600-800 TURKEY 10KG
90860001575067 | BRANZINI 800-1000 GREECE 10KG
90860001575074 | BRANZINI 800-1000 GREECE 10KG
90860001575081 | BRANZINI 800-1000 TURKEY 10KG
90860001575098 | BRANZINI 1000+ GREECE 10KG
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0107

 | Date: | 2013-01-07 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 11 | 54.99
 | 11:00:00 | 58 | 322.17
 | 12:00:00 | 95 | 525.25
 | 13:00:00 | 59 | 347.23
 | 14:00:00 | 42 | 240.62
 | 15:00:00 | 39 | 251.28
 | 16:00:00 | 35 | 193.31
 | 17:00:00 | 70 | 519.9
 | 18:00:00 | 60 | 487.79
 | 19:00:00 | 40 | 340.6
 | 20:00:00 | 26 | 213.48
 | 21:00:00 | 23 | 135.61
 | 22:00:00 | 26 | 130.24
 | 23:00:00 | 14 | 81.48
 | 1900-01-01 00:00:00 | 7 | 45.42
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 111697d1308036411-correction-in-formula-required-2007-2012-4th-prof
Sheet: 2 display

Roll# | Name | marks | Result
703 | [NAME] | 34 | Pass
704 | [NAME] | A | Pass
705 | [NAME] | 23 | Fail
708 | [NAME] | 36 | Pass
709 | Naval [NAME] | 0 | Fail
710 | Sadia Afzaal | 0 | Fail
711 | Uroog [NAME] | 0 | Fail
712 | Maryam Najam | 39 | Pass
713 | [NAME] | 32 | Pass
716 | [NAME] | 30 | Pass
718 | Sohaib Murtaza | 0 | Fail
720 | Tahseen Iqbal | 21 | Fail
723 | [NAME] | 0 | Fail
727 | [NAME] | 0 | Fail
I use a formula to mark "pass" or "fail", which is =IF(C2>=25, "Pass", "Fail")
now the question is, when I "A" (absent) in cell the result is "Pass", please tell me how I can write formula to get the "Fail" in result column after writing "A" in Marks column
Spreadsheet: 31788d1227730776-transferring-data-from-one-column-to-another-based-upon-a-variable-contract-example
Sheet: Sheet2

Selling Price |  |  |  |  | 3350 |  |  | Misc. Charges
Down Payment |  |  |  |  | 800 |  |  | Life Premiums
Trade allowance |  |  |  |  | 0 |  |  | A&H Premiums
Unit ACV |  |  |  |  | 1200 |  |  | Other Premiums
Trade ACV |  |  |  |  |  |  |  | Trade Tax (Y/N)
Overhead Per Unit |  |  |  |  | 700 |  |  | Insurance Profit
ACV of Repossession |  |  |  |  | 100 |  |  | Inflation Factor
Term in Months |  |  |  |  | 15 |  |  | Growth Overhead
Units per Month |  |  |  |  | 10 |  |  | Marginal Tax Rate
APR |  |  |  |  | 0.29 |  |  | Legal Collection Rate
Repossession Rate |  |  |  |  | 15
Growth in Units/Year (%) |  |  |  |  | 10
Maximum # of Units per Month
MO | CC | #New | New-Repo | CO | PO | Out Bal | Prin | Int | Legal | Income | Expense | Net Cash | Not CO | Gross | Net Prft | Aft tax
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Spreadsheet: 81684d1281809980-lookup-from-different-rows-revenue-1-
Sheet: Sheet3

Revenue Type | service revenue | rental | business | total
Revenue A
 | 100 | 200 | 300 | 600
 | 150 | 200 | 100 | 450
Totals: | 250 | 300 | 400 | 1050
Revenue B
 | 100 | 200 | 300 | 600
 | 200 | 100 | 200 | 500
Totals: | 300 | 300 | 500 | 1100
 |  |  |  |  |  |  | Revenue Type | service revenue | rental | business | total
 |  |  |  |  |  |  | Revenue A
Revenue C |  |  |  |  |  |  | Revenue B
 | 100 | 100 | 100 |  |  |  | Revenue C
 | 150 | 150 | 150 |  |  |  | Revenue D
 | 100 | 100 | 100
 | 200 | 200 | 200
 | 50 | 50 | 50
 | 100 | 100 | 100
 | 150 | 150 | 150
 | 50 | 50 | 50
 | 100 | 100 | 100
 | 100 | 100 | 100
Totals:
Revenue D
 | 143.05 | 143.05 | 143.05
 | 100 | 100 | 100
totals
Spreadsheet: 693391d1598954934-select-and-sum-parts-of-cells-foglio-ore-prova
Sheet: Test

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Σ | Fs | Fe | Ma | Tr | Ci | 0.25 | 0.5 | TOT | Note
Goofy | Fe4+4 | Fe8 | 5 | 12 | 5 | 0 | 0 | 5 | 5 | Ci8 | Ci8 | 0 | 0 | 5 | Fs7 | 5 | Ci8 | Ci8 | 0 | Fe2 | Ma5 | 5 | 5 | Tr5 | 5 | 0 | 0 | 5 | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data | 8 | 2020
Spreadsheet: 473769d1470389834-edit-script-button-in-excel-online-orders
Sheet: ordersheet

ORDER SHHET |  |  |  |  |  |  |  |  |  |  |  |  |  | Νο | ORDER1
brandname |  |  |  | alfasym
name |  |  |  | [NAME] |  |  |  |  | [NAME]
adress |  |  |  | OMONOIA STR 48 |  |  |  | VAT | 999111333 |  |  |  |  |  |  |  | Hello everyone,
CITY |  |  |  | ATHENS |  |  |  | MOBILE | 6944 555 333 |  | ΤΗΛ.: | [PHONE] |  |  |  |  | I have this order sheet
 |  |  |  |  |  |  |  |  |  |  | ΤΗΛ.2: |  |  |  |  |  | I need a button,"save order"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | when I hit the button, I want to copy the data from B14 to as line have data (to Q16 in our case) and paste(values) to sheet "INPUT" in the next row I have data
 |  |  |  |  |  |  |  | DATE |  |  | Υπογραφή:
[NAME]
ΔΗΜΙΟΥΡΓΙΑ ΜΑΚΕΤΑΣ
ΕΠΕΞΕΡ. ΑΡΧΕΙΩΝ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I would like this to work in excelonline
Α/Α | no | bn | CODE | ΠΕΡΙΓΡΑΦΗ | HEIGHT | WIDTH | PCS | details |  |  |  | Ποσ. |  | TIMH MON |  | ΣΥΝΟΛΟ
1 |  |  | 99-48 |  | 0.3 | 0.5 | 8 |  |  |  |  |  |  | 5
2 |  |  | 99-33 |  | 2 | 2 | 3 |  |  |  |  |  |  | 8
3 |  |  | 99-39 |  | 1 | 1.1 | 4 |  |  |  |  |  |  | 14
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
ΣΧΟΛΙΑ: |  |  |  |  |  |  |  |  |  |  |  | Συνολ. Ποσότητα
ΤΜΗΜΑ ΜΟΥΣΑΜΑ |  |  |  |  |  |  |  |  |  |  |  | Καθ.αξία
ΜΠΟΥΝΤΟΥΖΙΑ |  |  |  |  |  |  |  |  |  |  |  | Μεταφορικά |  | 0
ΦΑΚΕΛΛΟΣ |  |  |  |  |  |  |  |  |  |  |  | Σύνολο
ΒΕΡΝΙΚΙ |  |  |  |  |  |  |  |  |  |  |  | ΦΠΑ |  | 0.24
ΆΛΛΟ |  |  |  |  | ΞΥΛΟ | ΣΩΛΗΝ. ΓΑΛΒ |  | ΣΧΟΙΝΙ |  | ΛΑΣΤΙΧΟ |  | ΓΕΝ.ΣΥΝΟΛΟ
ΔΙΑΣΤΑΣΕΙΣ
ΒΑΡΟΣ ΠΑΡΑΓΓΕΛΙΑΣ
[NAME]
ΗΜ/ΝIA ΠΑΡΑΔΟΣΗΣ |  |  |  |  |  |  |  | ΤΡΟΠΟΣ ΠΑΡΑΔΟΣΗΣ
ΤΡΟΠΟΣ ΠΛΗΡΩΜΗΣ |  |  |  |  |  |  |  | VOUCHER
ΜΗΝΥΜΑ ΤΙΜΟΛΟΓΗΣΗΣ
Spreadsheet: 810753d1672037098-how-to-get-the-maximum-value-of-the-sum-of-which-day-from-a-certain-row-tr
Sheet: Sheet1

 |  | 1656
Day | platform | Total number of fans
1 | AA | 22
 | BB | 55
 | CC | 66
 | DD | 44
 | EE | 560
 | FF | 480
2 | AA | 22
 | BB | 550
 | DD | 44
 | EE | 560
 | FF | 480
3 | AA | 22
 | BB | 55
 | CC | 66
 | DD | 44
 | EE | 560
 | FF | 480
4 | AA | 23
 | DD | 46
 | EE | 566
 | FF | 480
Spreadsheet: 49637d1248980331-listing-transactions-by-purchase-date-693744_phillija
Sheet: Sheet1

Date | Type | Model | Make | Colour | Value
2009-01-01 00:00:00 | Purchase | 2008 | Ford | White | -5000
2009-02-12 00:00:00 | Purchase | 2008 | Ford | Blue | -10000
2009-02-15 00:00:00 | Purchase | 2008 | Ford | Blue | -12000
2009-03-04 00:00:00 | Purchase | 2008 | Ford | Green | -11000
2009-04-24 00:00:00 | Purchase | 2008 | Ford | Green | -4000
2009-06-03 00:00:00 | Purchase | 2008 | Ford | Green | -7000
2009-04-30 00:00:00 | Sale | 2008 | Ford | Green | -15000
2009-04-30 00:00:00 | Sale | 2008 | Ford | Blue | -12000
2009-04-30 00:00:00 | Sale | 2008 | Ford | White | -11000
2009-01-01 00:00:00 | Purchase | 2008 | Ford | White | -10000
2009-05-13 00:00:00 | Purchase | 2008 | Ford | White | -5000
2009-05-13 00:00:00 | Purchase | 2008 | Ford | White | -6000
2009-05-13 00:00:00 | Purchase | 2008 | Ford | White | -3000
2009-05-13 00:00:00 | Purchase | 2008 | Ford | White | -8000
2009-03-13 00:00:00 | Purchase | 2009 | Dodge | Red | -2
2009-05-23 00:00:00 | Purchase | 2009 | Chrysler | White | -1
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -2410 | -3699 | -2210 | -2000
2 | -2402 | -3699 | -18 | -2000
3 | -877 | -3699 | -674 | -2000
4 | -2234 | -3699 | -2562 | -2000
5 | -2473 | -3699 | -2615 | -2000
6 | -2204 | -1736 | -2601 | -2000
7 | -2381 | -1736 | -2459 | -2000
8 | -2271 | -1736 | -1917 | -2000
9 | -2359 | -1736 | -95 | -2000
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-01-31 00:00:00 |  |  |  |  |  |  | 713.49
2002-02-09 00:00:00
CBS Volume |  |  |  |  |  |  | 2808
Spreadsheet: 886777d1736882551-a-column-with-values-not-included-in-other-columns-a-column-with-values-not-included-in-other-columns
Sheet: Sheet1

Master [NAME] list | Session1 | Session2 | Session3 |  | not in any session (Column I need)
Req 1 | Req 4 | Req 7 | Req 5
Req 2 | Req 5 | Req 11 | Req 6
Req 3 | Req 6 | Req 12 | Req 15
Req 4 | Req 7 | Req 13 | Req 16
Req 5 | Req 8 | Req 14 | Req 17
Req 6 |  | Req 16 | Req 18
Req 7 |  |  | Req 19
Req 8
Req 9
Req 10
Req 11
Req 12
Req 13
Req 14
Req 15
Req 16
Req 17
Req 18
Req 19
Req 20
Spreadsheet: 758903d1639152329-if-formula-to-calculate-values-between-a-range-of-dates-book1
Sheet: Sheet1

2012-06-01 00:00:00
2013-06-01 00:00:00
2014-06-01 00:00:00
2015-06-01 00:00:00
2016-06-01 00:00:00
2017-06-01 00:00:00
2018-06-01 00:00:00
2019-06-01 00:00:00
2020-06-01 00:00:00
2021-06-01 00:00:00
Spreadsheet: 704221d1605451992-correspondence-between-2-variables-apoio-trabalho-1db1
Sheet: Lumiere

Seleção Lumière
ID [NAME] | Nome | Gênero | Língua | [NAME] | Duração | Ano | IMDB | Receita | Orçamento | Taxa de Exibição | Taxa de Tradução | Custo de Exibição | Custo de Tradução | Custo Total | Foi Flop? | Europeu? | Continente
4679 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resumo da Seleção de Filmes
4243 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Média de Classificações
4498 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duração Total
3183 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Média de Custos Totais
3910 |  |  | Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] europeus
5432 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] com maior custo
5400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] mais antigo
5071 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Gastos (M)
1295
1572
1661 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gênero | Nº Filmes
1935 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Action
2757 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comedy
2903 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Horror
5011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crime
3579
1457 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gênero | Total gasto (M)
1532 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Action
1618 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comedy
1730 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crime
1835 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drama
2761
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PESQUISA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Continente
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] desse [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] com maior orçamento
Spreadsheet: 827852d1683071638-leap-year-vacation-record
Sheet: Dawn

Start Date |  | 2023-01-01 00:00:00
 | Vacation Record
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FH
Spreadsheet: 4eb7853f-94a5-4302-9aef-f41edee61195
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
2013 MODEL RENTAL REPURCHASE AND RISK PROGRAM
Account Name: |  |  |  |  |  | Customer FIN Code:
Date: |  |  |  |  |  | Contact Name:
This Delivery Request does not constitute a delivery guarantee; however, we will make every effort to fulfill this request.
Requested "Production" Month
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG
FORD
C-MAX HYBRID (HEV & PHEV) |  |  |  |  |  |  |  |  |  |  |  |  | 0
EDGE |  |  |  |  |  |  |  |  |  |  |  |  | 0
ESCAPE |  |  |  |  |  |  |  |  |  |  |  |  | 0
E-SERIES VAN |  |  |  |  |  |  |  |  |  |  |  |  | 0
E-SERIES WAGON |  |  |  |  |  |  |  |  |  |  |  |  | 0
EXPEDITION |  |  |  |  |  |  |  |  |  |  |  |  | 0
EXPLORER |  |  |  |  |  |  |  |  |  |  |  |  | 0
F150 (REG./SUPER CAB) |  |  |  |  |  |  |  |  |  |  |  |  | 0
F-SERIES SUPER CREW |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIESTA |  |  |  |  |  |  |  |  |  |  |  |  | 0
FLEX |  |  |  |  |  |  |  |  |  |  |  |  | 0
FOCUS |  |  |  |  |  |  |  |  |  |  |  |  | 0
FUSION |  |  |  |  |  |  |  |  |  |  |  |  | 0
FUSION HYBRID (HEV & PHEV) |  |  |  |  |  |  |  |  |  |  |  |  | 0
MUSTANG COUPE |  |  |  |  |  |  |  |  |  |  |  |  | 0
MUSTANG CONV |  |  |  |  |  |  |  |  |  |  |  |  | 0
SUPER DUTY (Risk Only) |  |  |  |  |  |  |  |  |  |  |  |  | 0
TAURUS |  |  |  |  |  |  |  |  |  |  |  |  | 0
TRANSIT CONNECT |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LINCOLN
MKS |  |  |  |  |  |  |  |  |  |  |  |  | 0
MKT |  |  |  |  |  |  |  |  |  |  |  |  | 0
MKX |  |  |  |  |  |  |  |  |  |  |  |  | 0
MKZ |  |  |  |  |  |  |  |  |  |  |  |  | 0
NAVIGATOR |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Shaded cells indicate 2014 Model Year production 1
Shaded cells indicate 2012 Model Year production
For those accounts ordering E-Series Pass Wagons (E1B and S3B), recognize that although every effort is made to accommodate your requested scheduling dates, demand consistently exceeds supply during the months of April and May.  Ford reserves the right to schedule E-Series Passenger Wagons up to 3 weeks prior to OR 3 weeks later than the requested production dates.
1  Dates are subject to change.  Latest updates to this plan will be posted on www.fleet.ford.com, under the Ordering Center tab:                                                                               Final Build Date/First Build Date by Model Year.
Spreadsheet: 750414d1633443988-automating-color-coding-and-trend-help-needed-jlausier-data-color-coding-request
Sheet: Sept 2021

 | Data accuracy |  |  | 98-100% Accuracy |  | 95-97% Acccuracy |  | >95 Accuracy
 | On order no activity
 |  | United States | Trend | EMEA | Trend | WEC | Trend | LATAM | Trend | [NAME] | Trend
 | Total Records | 52629 |  | 4114 |  | 21174 |  | 2274 |  | 8247
 | Erroneous Records | 574 |  | 103 |  | 155 |  | 0 |  | 212
 | % of Erroneous Data
 | In Stock but network activity
 |  | United States | Trend | EMEA | Trend | WEC | Trend | LATAM | Trend | [NAME] | Trend
 | Total Records | 52629 |  | 4114 |  | 21174 |  | 2274 |  | 8247
 | Erroneous Records | 103 |  | 2 |  | 13 |  | 6 |  | 2
 | % of Erroneous Data
 | In Use but no network activity
 |  | United States | Trend | EMEA | Trend | WEC | Trend | LATAM | Trend | [NAME] | Trend
 | Total Records | 52629 |  | 4114 |  | 21174 |  | 2274 |  | 8247
 | Erroneous Records | 155 |  | 17 |  | 40 |  | 19 |  | 38
 | % of Erroneous Data
Spreadsheet: 65554d1266280831-need-function-to-display-details-of-id-number-name-price-etc-task1
Sheet: Task1 (P1)

 | Code | [NAME] | Price | Jan | Feb | Mar | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 | 105 | [NAME] | 240 | 2 | 0 | 10 | 10 | 1 | 3 | 10 | 0 | 8 | 9 | 5 | 7
 | 109 | [NAME] | 400 | 4 | 10 | 11 | 0 | 3 | 6 | 0 | 10 | 2 | 9 | 3 | 3
 | 110 | Henlow Marble | 174 | 8 | 1 | 9 | 14 | 0 | 5 | 4 | 0 | 11 | 1 | 0 | 8
 | 121 | Sandford Marble | 250 | 11 | 0 | 0 | 0 | 6 | 7 | 6 | 0 | 8 | 11 | 0 | 9
 | 223 | [NAME] | 275 | 7 | 3 | 0 | 8 | 2 | 0 | 7 | 5 | 0 | 0 | 8 | 0
 | 321 | [NAME] | 340 | 0 | 4 | 0 | 0 | 8 | 0 | 7 | 1 | 6 | 7 | 11 | 9
 | 210 | [NAME] | 211 | 8 | 9 | 6 | 7 | 0 | 6 | 3 | 4 | 10 | 0 | 9 | 12
 | 234 | Malfra Marble | 275 | 0 | 0 | 8 | 2 | 7 | 8 | 2 | 0 | 7 | 8 | 3 | 5
 | 320 | [NAME] | 230 | 4 | 6 | 4 | 17 | 0 | 9 | 3 | 0 | 0 | 10 | 0 | 0
 | 344 | Oslo Marble | 295 | 9 | 0 | 6 | 5 | 1 | 7 | 0 | 10 | 0 | 9 | 3 | 4
 | 451 | Trinty Monza Marble | 245 | 5 | 5 | 5 | 0 | 9 | 4 | 6 | 4 | 9 | 1 | 0 | 0
 | 721 | Victorian [NAME] | 199 | 8 | 4 | 8 | 4 | 6 | 0 | 6 | 9 | 0 | 10 | 7 | 2
 | 101 | [NAME] | 320 | 10 | 8 | 6 | 8 | 1 | 0 | 7 | 8 | 10 | 6 | 0 | 6
 | 103 | Cantor Yorkstone | 225 | 6 | 3 | 7 | 0 | 7 | 9 | 1 | 3 | 7 | 0 | 10 | 1
 | 107 | [NAME] | 180 | 0 | 9 | 0 | 0 | 8 | 0 | 5 | 7 | 4 | 4 | 6 | 7
 | 111 | Colonial Limestone | 260 | 0 | 8 | 7 | 2 | 4 | 1 | 0 | 8 | 0 | 2 | 7 | 0
 | 222 | [NAME] | 174 | 6 | 6 | 10 | 1 | 5 | 3 | 0 | 1 | 2 | 7 | 0 | 3
 | 254 | Milano Limestone | 274 | 8 | 8 | 6 | 5 | 2 | 0 | 8 | 9 | 8 | 0 | 6 | 8
 | 713 | [NAME] | 274 | 1 | 10 | 0 | 6 | 0 | 3 | 0 | 7 | 5 | 8 | 5 | 8
 | 912 | Regency Marble | 250 | 1 | 8 | 9 | 1 | 4 | 7 | 2 | 7 | 5 | 5 | 2 | 6
 |  | Calculations Per Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | [NAME]
 |  | Total Sales Per Month |  |  |  |  |  |  |  |  |  |  |  |  |  | SSW
 |  | Total Wholesale |  |  |  |  |  |  |  |  |  |  |  |  |  | Marble Direct
 |  | Income from sales  Per Fireplace Code Each Month
 | Code | Code | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | Total of Sales Per Month
 |  | Calculations Per Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | Average sales
 |  | Average Sales (£)
 |  | Maximum Sales
 |  | Maximum Sale s(£)
 |  | Mininum Sales
 |  | Mininum Sales (£)
 |  | Total Profit From Sales
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-086,890

 |  |  |  |  |  |  |  | 9-086   9-890
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 72297d1272991498-timesheet-calculate-hours-between-times-union-non-exempt-sample3
Sheet: Time card

UNION NON-EXEMPT EMPLOYEE WEEKLY TIME SHEET
INPUT ONLY IN THE AREAS SHADED IN BLUE
EMPLOYEE NAME |  |  |  |  | [NAME] |  |  | DEPARTMENT/POSITION |  |  |  |  |  |  | WEEK ENDING  (MUST be a Saturday)
Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  | NON-CLOCK HOURS
 |  |  |  |  |  | HOL | VAC | PER | SCK
 | DATE | TIME IN | MEALS | TIME OUT | TOTAL HOURS  WORKED | HOLIDAY    HOURS | VACATION      HOURS | PERSONAL     HOURS | SICK                  HOURS | OTHER          HOURS | DIFF  PAY | OTHER          CODES | HOURS OVER 8 IN A DAY | TOTAL HOURS PAID | EXPLANTION OF OVERTIME, FEES, SHIFT DIFF PAY
SUNDAY | 2010-04-25 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | s/b 0 | 0 | 0 | 0 | 0 |  |  |  | 0
MONDAY | 2010-04-26 00:00:00 | 09:00:00 | 0 | 17:30:00 | 8.5 | 0 | 0 | 0 | 0 | s/b 0 | 8.145833333333334 | 0 | 0.5 | 8.5 |  |  |  | 8
TUESDAY | 2010-04-27 00:00:00 | 10:30:00 | 0 | 00:45:00 | 14.25 | 0 | 0 | 0 | 0 | s/b 1.75 | 13.72916666666667 | 0 | 6.25 | 14.25 |  |  |  | 8
WEDNESDAY | 2010-04-28 00:00:00 | 22:45:00 | 0 | 05:00:00 | 6.249999999999999 | 0 | 0 | 0 | 0 | s/b 6 | 6.239583333333332 | 0 | 0 | 6.249999999999999 |  |  |  | 6.249999999999999
THURSDAY | 2010-04-29 00:00:00 | 22:45:00 | 0 | 06:30:00 | 7.749999999999999 | 0 | 0 | 0 | 0 | s/b 7 | 7.718749999999999 | 0 | 0 | 7.749999999999999 |  |  |  | 7.749999999999999
FRIDAY | 2010-04-30 00:00:00 | 01:00:00 | 0 | 10:00:00 | 9 | 0 | 0 | 0 | 0 | s/b 5 | 8.833333333333334 | 0 | 1 | 9 |  |  |  | 8
SATURDAY | 2010-05-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | s/b 0 | 0 | 0 | 0 | 0 |  |  |  | 0
TOTAL HOURS |  |  |  |  | 45.75 | 0 | 0 | 0 | 0 | 0 | 44.66666666666666 | 0 | 7.75 | 45.75 |  |  |  | 38
The following codes are to be used to indicate the 'nature' of all absences. |  |  |  |  |  |  |  |  | PAID HOURS DETAIL-
The codes below are to appear in the 'OTHER CODES' column of the day (s) applicable. |  |  |  |  |  |  |  |  | 45.75 | TOTAL HOURS WORKED
 | OTHER | [NAME] |  | OTHER | [NAME] |  |  |  | 38 | TOTAL REGULAR STRAIGHT TIME HOURS
 | CODES |  |  | CODES
 | BRV | DEATH IN FAMILY |  | DISB | SHORT TERM DISABILITY |  |  |  | 0 | TOTAL NON-CLOCK HOURS
 | SCK | SICK DAY |  | F75 | UNION SHIFT DIFF.
 | [NAME] | JURY DUTY |  | DNP | DO NOT PAY |  |  |  | 7.75 | TOTAL OT HOURS @ TIME & A HALF |  |  |  |  | 45.75 | TOTAL PAID HOURS
EMPLOYEE'S SIGNATURE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-04 00:00:00
SUPERVISOR'S APPROVAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE