tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861367d1709237442-2d-grid-matrix-exported-as-csv-in-column-vs-plotting-exported-data
Sheet: Sheet1

ID | R3
A01 | 0.747
B01 | 0.747
C01 | 0.747
D01 | 0.748
E01 | 0.748
F01 | 0.748
G01 | 0.747
H01 | 0.748
I01 | 0.747
J01 | 0.747
K01 | 0.747
L01 | 0.747
A02 | 0.747
B02 | 0.747
C02 | 0.747
D02 | 0.747
E02 | 0.747
F02 | 0.747
G02 | 0.747
H02 | 0.748
I02 | 0.748
[NAME] | 0.748
K02 | 0.749
[NAME] | 0.749
A03 | 0.749
B03 | 0.749
C03 | 0.75
D03 | 0.751
E03 | 0.752
F03 | 0.754
G03 | 0.749
H03 | 0.749
I03 | 0.749
J03 | 0.747
K03 | 0.746
[NAME] | 0.734
A04 | 0.734
B04 | 0.733
C04 | 0.734
D04 | 0.733
E04 | 0.733
F04 | 0.732
G04 | 0.732
H04 | 0.733
I04 | 0.733
J04 | 0.732
[NAME] | 0.733
[NAME] | 0.732
A05 | 0.732
B05 | 0.732
C05
D05
E05
F05
G05
H05
I05
[NAME]
K05
[NAME]
A06
B06
C06
D06
E06
F06
[NAME]
H06
I06
J06
K06
L06
A07
B07
C07
D07
[NAME]
F07
G07
H07
I07
J07
K07
L07
A08
B08
C08
D08
E08
F08
G08
H08
I08
J08
K08
L08
A09
B09
C09
D09
E09
F09
[NAME]
H09
I09
J09
K09
L09
A10
B10
C10
D10
E10
[NAME]
G10
H10
I10
J10
K10
L10
A11
B11
C11
D11
E11
F11
G11
H11
I11
J11
K11
L11
A12
B12
C12
D12
E12
F12
G12
H12
I12
J12
K12
L12
Spreadsheet: 835181d1688389369-count-colored-cells-in-a-row-book1
Sheet: Sheet1

 |  |  |  |  | Count |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  | 4 | 9 | 2 | 89 | 106 | 47 | 22 | 99 | 1025 | 777
Spreadsheet: chris_germany__2912__Plant Fuel 02 2000
Sheet: Dec 99

Date | lbs 1CT oil | lbs 1 DB oil | lbs 2 CT oil | lbs 2 DB oil | lbs Aux. Blr oil | daily oil mmbtu | daily oil gallons | Fuel Tank Level | Oil Deliv. Gallons | Trucks | lbs 1 CT gas | lbs 1 DB gas | lbs 2 CT gas | lbs 2 DB gas | lbs Aux. Blr gas | Daily gas mmbtu
1999-12-01 00:00:00
1999-12-02 00:00:00
1999-12-03 00:00:00
1999-12-04 00:00:00
1999-12-05 00:00:00
1999-12-06 00:00:00
1999-12-07 00:00:00
1999-12-08 00:00:00
1999-12-09 00:00:00
1999-12-10 00:00:00
1999-12-11 00:00:00
1999-12-12 00:00:00
1999-12-13 00:00:00
1999-12-14 00:00:00
1999-12-15 00:00:00
1999-12-16 00:00:00
1999-12-17 00:00:00
1999-12-18 00:00:00
1999-12-19 00:00:00
1999-12-20 00:00:00
1999-12-21 00:00:00
1999-12-22 00:00:00
1999-12-23 00:00:00
1999-12-24 00:00:00
1999-12-25 00:00:00
1999-12-26 00:00:00
1999-12-27 00:00:00
1999-12-28 00:00:00
1999-12-29 00:00:00
1999-12-30 00:00:00
1999-12-31 00:00:00
mmbtu
gallons
Spreadsheet: 115844d1311333339-excel-2007-find-cell-reference-and-copy-to-new-sheet-excel_1-1-
Sheet: Sheet1

Job Reference | Customer Name | Package | Date Started | Date Completed | Open Time | Assigned To | Something | Something | Something | Something | Completed by | Status | RATE
500123 | Data | Package 1 | 2011-07-11 00:00:00 | 2011-07-12 00:00:00 | 00:00:00 | NAME | data | data | data | data | NAME 1 | Open | 1
500145 | Data | Package 1 | 2011-07-12 00:00:00 | 2011-07-13 00:00:00 | 00:00:00 | NAME | data | data | data | data | NAME 1 | Closed | 3
500984 | Data | Package 1 | 2011-07-11 00:00:00 | 2011-07-12 00:00:00 | 00:00:00 | NAME | data | data | data | data | [NAME] 2 | Closed | 2
501452 | Data | Package 1 | 2011-07-16 00:00:00 | 2011-07-18 00:00:00 | 00:00:00 | NAME | data | data | data | data | NAME 4 | Open | 3
551634 | Data | Package 1 | 2011-07-12 00:00:00 | 2011-07-13 00:00:00 | 00:00:00 | NAME | data | data | data | data | NAME 3 | Open | 5
500001 | Data | Package 1 | 2011-07-16 00:00:00 | 2011-07-16 00:00:00 | 00:00:00 | NAME | data | data | data | data | NAME 1 | Closed | 4
500023 | Data | Package 1 | 2011-07-13 00:00:00 | 2011-07-13 00:00:00 | 00:00:00 | NAME | data | data | data | data | NAME 6 | Open | 5
Spreadsheet: 675163d1588179745-using-pivot-tables-and-extracting-proper-columns-when-double-clicking-2020-04-29-oeldere-althepal78-675097d1588163486-using-pivot-tables-and-extracting-proper-col
Sheet: Pivot

Rifle Needs | Need |  |  |  |  |  |  |  |  | Rijlabels | Count of SWIM DATE
 |  |  |  |  |  |  |  |  |  | don't need | 11
Aantal van RANK |  |  |  |  |  |  |  |  |  | Need | 6
Position | RANK | Totaal |  |  |  |  |  |  |  | Eindtotaal | 17
1 | CAP | 1
2 | 1LT | 1
3 | 2LT | 1
6 | SSGT | 1
7 | SGT | 2
8 | CPL | 2
9 | [NAME] | 2
10 | PFC | 2
11 | PVT | 3
Eindtotaal |  | 15
Spreadsheet: 52911d1252768413-graphfic-type-on-excel-scratch
Sheet: Sheet1

 | data | 0.25 | -0.25
m | 0.9704685083895946 | 1.213085635486993 | 0.727851381292196
b | 0.1135378143418535 | 0.1135378143418535 | 0.1135378143418535
 | x | y | y
 | 1 | 1.326623449828847 | 0.8413891956340495
 | 100 | 121.4221013630412 | 72.89867594356144
x | data
1 | 0.9900858114023539
2 | 1.844903468719031
3 | 3.638597829140536
4 | 3.266626459901865
5 | 5.856691108164378
6 | 6.816324864206289
7 | 6.62516552200657
8 | 8.272759889583773
9 | 9.614686149576283
10 | 10.73399894584042
11 | 9.530258482284957
12 | 13.70078423122962
13 | 14.84827660618645
14 | 12.76941564340692
15 | 16.11149648976416
16 | 19.87126637917089
17 | 18.30705464178467
18 | 19.48895093764962
19 | 14.47990785820745
20 | 19.12256900416324
21 | 16.41616138134195
22 | 19.42921091858242
23 | 21.09141510654676
24 | 23.94210838128457
25 | 28.07434049232133
26 | 24.46153094656722
27 | 26.45235986300844
28 | 25.37585946042419
29 | 31.30905549864053
30 | 29.03968556782701
31 | 35.30730282183905
32 | 26.03856120463054
33 | 29.59637985177854
34 | 34.25408349038467
35 | 29.72601460192382
36 | 37.18703212721018
37 | 44.82936025013908
38 | 43.81737610666478
39 | 39.0796077346004
40 | 31.55092944639915
41 | 47.5058432997328
42 | 32.72079578758618
43 | 42.71834313945092
44 | 34.3138336503563
45 | 51.24617879925947
46 | 38.16029381878356
47 | 39.59755717221986
48 | 40.70620673753032
49 | 53.79341692208171
50 | 43.67058725327122
51 | 47.07391625969538
52 | 56.9829211276723
53 | 50.43503709835657
54 | 67.06791889668477
55 | 58.03953904262306
56 | 45.64311698378946
57 | 69.65415813646288
58 | 44.72859065093074
59 | 59.92544033154351
60 | 65.19866091808103
61 | 47.52721667749573
62 | 59.05244103596316
63 | 60.92778517525656
64 | 79.74976931848494
65 | 62.62009792818204
66 | 54.79521699113771
67 | 58.32876166619054
68 | 69.87306203290332
69 | 70.6562920825146
70 | 57.19062360705301
71 | 67.59184169912241
72 | 70.67145162603353
73 | 57.98863970782631
74 | 73.92036918069239
75 | 82.80088124103149
76 | 61.95008437653146
77 | 74.14391161614519
78 | 91.07174662580483
79 | 59.68986594184691
80 | 69.03982919035926
81 | 64.34231885070916
82 | 77.0341671196272
83 | 65.58542978626451
84 | 82.56076702150617
85 | 83.37520481867533
86 | 77.70397134718064
87 | 96.80681685640792
88 | 105.4753107182712
89 | 109.791474007536
90 | 97.0219311434248
91 | 80.60694420458807
92 | 99.99844199900073
93 | 71.04093268407141
94 | 82.07105392043773
95 | 74.95154080722564
96 | 115.024726641698
97 | 112.1467320105135
98 | 86.14489712233748
99 | 110.7790903770166
100 | 88.11755804395303
Spreadsheet: 851718d1701878307-work-out-age-from-specific-date-excel-example
Sheet: Sheet1

DOB | Age | Registered
1961-11-27 00:00:00 |  | 2023-07-14 00:00:00
2009-11-04 00:00:00 |  | 2023-06-07 00:00:00
2008-10-31 00:00:00 |  | 2023-05-25 00:00:00
1944-02-06 00:00:00 |  | 2023-01-25 00:00:00
1985-07-09 00:00:00 |  | 2023-08-04 00:00:00
2008-08-26 00:00:00 |  | 2023-10-26 00:00:00
1983-09-28 00:00:00 |  | 2023-03-21 00:00:00
2011-11-27 00:00:00 |  | 2023-11-09 00:00:00
Spreadsheet: 854802d1704561741-error-on-inventory-sheet-formula-stock-allocation
Sheet: Sheet1

 |  |  | Stock Allocated
Item Name | Opening Stock (Storage) | Stock Received (Storage) | Location A | Location B | Current Stock (Storage)
Pen | 30 | 10 | 13 | 12
Pen |  | 15 | 10 | 15
Pen |  | 20 | 8 | 10
Pen |  | 5 | 4
Pen |  |  |  | 5
Spreadsheet: 878631d1725816611-hours-without-overlapping-formula-test-time-ayazgreat-
Sheet: Sheet2

Date: 03SEPT
Job ID | Time Start | Time End | Total Hours wo/overlaping
28859 | 11:01:00 | 11:38:00
10703 | 11:01:00 | 11:31:00
44155 | 11:36:00 | 12:21:00
22818 | 11:53:00 | 12:12:00
77123 | 12:11:00 | 12:43:00
70619 | 12:27:00 | 13:22:00
74581 | 14:38:00 | 15:03:00
Date: 04SEPT
Job ID | Time Start | Time End | Total Hours wo/overlaping
38868 | 11:09:00 | 12:02:00
69746 | 11:09:00 | 12:08:00
34338 | 12:07:00 | 12:23:00
36149 | 12:33:00 | 13:26:00
12347 | 12:33:00 | 13:19:00
72441 | 13:40:00 | 14:01:00
81011 | 14:14:00 | 14:39:00
79832 | 14:55:00 | 15:24:00
10273 | 14:55:00 | 15:32:00
Date: 05SEPT
Job ID | Time Start | Time End | Total Hours wo/overlaping
91734 | 11:19:00 | 11:55:00
75432 | 11:19:00 | 11:47:00
80465 | 12:00:00 | 12:43:00
78019 | 12:00:00 | 12:45:00
87789 | 12:44:00 | 13:19:00
96836 | 12:55:00 | 13:28:00
93043 | 13:41:00 | 14:01:00
71934 | 13:45:00 | 14:13:00
81323 | 14:20:00 | 15:05:00
82305 | 14:22:00 | 15:05:00
Date: 05SEPT
Job ID | Time Start | Time End | Total Hours wo/overlaping
34444 | 11:00:00 | 11:23:00
42311 | 11:00:00 | 11:32:00
82507 | 11:37:00 | 12:15:00
88460 | 11:37:00 | 12:03:00
95221 | 12:16:00 | 12:35:00
64224 | 12:31:00 | 13:04:00
51764 | 12:30:00 | 12:52:00
93986 | 13:17:00 | 13:31:00
24336 | 13:38:00 | 14:14:00
59301 | 13:35:00 | 14:08:00
26702 | 14:24:00 | 14:48:00
47637 | 14:25:00 | 14:59:00
14787 | 15:09:00 | 15:32:00
45888 | 15:10:00 | 15:54:00
28572 | 15:55:00 | 16:52:00
11106 | 15:55:00 | 16:56:00
60323 | 16:30:00 | 16:44:00
Spreadsheet: 125111d1318880634-excel-2007-non-linear-regression-matrix700
Sheet: Sheet1

 |  | Y axis |  | X axis
 |  | A |  | C | H | CO | W | M | O |  | Equation:
 |  | 2.529761904761905 |  | 3.75 | 0 | 0 | 0 | 5 | 1.25 |  | A=(k1*k2*k3*k4*k5*M*C)/((k6*k7*k8*H*M)+(k9*k10*CO)+(k11*O)
 |  | 1.555580357142857 |  | 3.75 | 1 | 0 | 0 | 5 | 1.25
 |  | 1.550099206349206 |  | 3.75 | 2 | 0 | 0 | 5 | 1.25
 |  | 1.488095238095238 |  | 3.75 | 5 | 0 | 0 | 5 | 1.25
 |  | 1.445337301587302 |  | 3.75 | 7.5 | 0 | 0 | 5 | 1.25
 |  | 1.376488095238095 |  | 3.75 | 10 | 0 | 0 | 5 | 1.25
 |  | 1.066468253968254 |  | 3.75 | 20 | 0 | 0 | 5 | 1.25
 |  | 0.9672619047619048 |  | 3.75 | 30 | 0 | 0 | 5 | 1.25
 |  | 2.529761904761905 |  | 3.75 | 0 | 0.5 | 0 | 5 | 1.25
 |  | 1.484375 |  | 3.75 | 0 | 1 | 0 | 5 | 1.25
 |  | 0.8792410714285714 |  | 3.75 | 0 | 2 | 0 | 5 | 1.25
 |  | -4.464285714285714 |  | 3.75 | 0 | 3 | 0 | 5 | 1.25
 |  | 2.338045634920635 |  | 3 | 0 | 0 | 0 | 10 | 1
 |  | 2.673611111111111 |  | 3.75 | 0 | 0 | 0 | 10 | 1.25
 |  | 3.816964285714286 |  | 7.5 | 0 | 0 | 0 | 10 | 2.5
 |  | 3.401785714285714 |  | 9.975000000000001 | 0 | 0 | 0 | 10 | 3.325
 |  | 1.607142857142857 |  | 11.25 | 0 | 0 | 0 | 10 | 3.75
 |  | 0.637797619047619 |  | 18.75 | 0 | 0 | 0 | 10 | 6.25
 |  | -0.2232142857142857 |  | 22.5 | 0 | 0 | 0 | 10 | 7.5
 |  | 1.30952380952381 |  | 7.5 | 0 | 0 | 0 | 2.5 | 2.5
 |  | 3.472222222222222 |  | 7.5 | 0 | 0 | 0 | 5 | 2.5
 |  | 3.402777777777777 |  | 7.5 | 0 | 0 | 0 | 7.5 | 2.5
 |  | 3.816964285714286 |  | 7.5 | 0 | 0 | 0 | 10 | 2.5
 |  | 2.673611111111111 |  | 7.5 | 0 | 0 | 0 | 20 | 2.5
Spreadsheet: 830671d1685026942-trying-to-fill-dates-with-formula-andre-test-2
Sheet: Sheet2

Name | Manager | shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
[NAME] | [NAME] | 8am - 5pm |  | x | x | x | x | x
[NAME] | [NAME] | 8am - 5pm |  | x | x | x | x | x
[NAME] | [NAME] | 8am - 5pm | x | x | x | x | x
Xavier | Rose | 8am - 5pm | x | x |  | x | x |  | x
Ziad | [NAME] | 9am - 6pm | x | x | x | x |  |  | x
Spreadsheet: 733915d1621884596-copy-and-transpose-formula-auto-1-
Sheet: Auto

 | ST 002 | Net Salaries |  | 0 |  |  |  | ST 003
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance |  | Date | Receipt | Invoice | Debit | Credit | Cumulative Balance |  | Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
 | 7 | 2 | 0 | 0 | 0 |  |  | 2 | 2 | 0 | 0 | -1983.41 |  |  | 1 | 1 | 0 | 0 | -4054.46
2021-01-25 00:00:00 | 0 | January |  | 185503.5 | -185503.5 |  |  | 0 | January |  |  |  |  |  | 0 | January
2021-01-26 00:00:00 | 16 | 5 | 6581 |  | -178922.5 |  | 2021-02-25 00:00:00 | 0 | february |  |  | -178922.5 |  | 2021-02-25 00:00:00 | 0 | february |  |  | -178922.5
2021-01-26 00:00:00 | 17 | 5 | 5793 |  | -173129.5 |  | 2021-03-25 00:00:00 | 0 | march |  |  | -178922.5 |  | 2021-03-25 00:00:00 | 0 | March |  |  | -178922.5
2021-01-26 00:00:00 | 18 | 5 | 4461 |  | -168668.5 |  | 2021-03-31 00:00:00 | 136 | 136 |  |  | -178922.5 |  | 2021-03-31 00:00:00 | 140 | 140 |  |  | -178922.5
2021-01-26 00:00:00 | 19 | 5 | 7913 |  | -160755.5 |  | 2021-04-25 00:00:00 | 0 | April |  |  | -178922.5 |  | 2021-04-25 00:00:00 | 0 | April |  |  | -178922.5
2021-01-26 00:00:00 | 20 | 5 | 4953 |  | -155802.5
2021-01-26 00:00:00 | 21 | 5 | 4043 |  | -151759.5
2021-01-26 00:00:00 | 22 | 5 | 4584 |  | -147175.5
2021-01-26 00:00:00 | 23 | 5 | 11043 |  | -136132.5
2021-01-26 00:00:00 | 24 | 5 | 3399 |  | -132733.5
2021-01-26 00:00:00 | 25 | 5 | 4580 |  | -128153.5
2021-01-26 00:00:00 | 26 | 5 | 11134 |  | -117019.5
2021-01-26 00:00:00 | 27 | 5 | 4107 |  | -112912.5
2021-01-26 00:00:00 | 28 | 5 | 4359 |  | -108553.5
2021-01-26 00:00:00 | 29 | 5 | 7929 |  | -100624.5
2021-01-26 00:00:00 | 30 | 5 | 10480 |  | -90144.5
2021-01-26 00:00:00 | 31 | 5 | 9370 |  | -80774.5
Spreadsheet: barry_tycholiz__849__West Total Orig Income Stmt
Sheet: Income Statement

Income Statement - ($000s)
West Gas Origination
 |  |  | 2001 Forecast |  | 2002 Plan |  | [NAME]
Originations |  | $ |  | $ |  | $
Trading
FV-Investments
Accrual
Operating Expenses
Other
Total Margin |  | $ |  | $ |  | $
Capital Charge
Total Margin Net of Capital Charge |  | $ |  | $ |  | $
Compensation/Taxes and Benefits
Employee Expense
Travel/Entertainment
Consulting |  |  | 26
Office
Controllable Infrastructure
System Development |  |  | 0
Insurance |  |  | 0
Analyst Associates (includes Comp, Taxes & Benefits and Allocation)
Other Expense
Outside Legal |  |  | 0
Outside Tax |  |  | 0
Depreciation & Amortization |  |  | 15
Total Direct Expenses |  | $ |  | $ |  | $
Pre-Tax Income |  | $ |  | $ |  | $
Headcount
Executive
Director
Manager
Analyst and Associates
Support Departments
Total Headcount
2002 Plan (in thousands) |  |  | Team |  | ENA Total
Direct Expense Ratio |  | $ |  | $
Productivity [NAME] |  | $ |  | $
ROCE
Spreadsheet: 0641100a-7884-45b4-98d2-2fffc2e4528b
Sheet: Sheet1

Use this gradebook to calculate grades where each assignment is worth a % of the final grade. | 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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31
 |  | GRADE & GPA TABLE
 | Score | 0 | 0.6 | 0.63 | 0.67 | 0.7 | 0.73 | 0.77 | 0.8 | 0.83 | 0.87 | 0.9 | 0.93 | 0.97
 | [NAME] | F | D- | D | [NAME] | C- | C | C+ | B- | B | [NAME] | A- | A | A+
 | GPA | 0 | 0.67 | 1 | 1.33 | 1.67 | 2 | 2.33 | 2.67 | 3 | 3.33 | 3.67 | 4 | 4
Your School Name
Teacher Name
Class/Project |  |  |  | Assignment or Test Name | Page 10 | Wksheet 5 | Project | Quiz | Test
Year/Semester/Quarter |  |  |  | Percentage (100% total) | 0.1 | 0.2 | 0.3 | 0.1 | 0.3
STUDENT NAME | STUDENT ID | Score | [NAME] | GPA | Page 10 | Wksheet 5 | Project | Quiz | Test
Doe, [NAME] |  | 87.8 | [NAME] | 3.33 | 75 | 82 | 95 | 84 | 90
CLASS SUMMARY |  | Score | [NAME] | GPA | Page 10 | Wksheet 5 | Project | Quiz | Test
Average |  | 87.8 | [NAME] | 3.33 | 75 | 82 | 95 | 84 | 90
Highest Score |  | 87.8 | [NAME] | 3.33 | 75 | 82 | 95 | 84 | 90
Lowest Score |  | 87.8 | [NAME] | 3.33 | 75 | 82 | 95 | 84 | 90
Spreadsheet: 2ff128e5-74a6-4918-bb1e-f755e0726bbf
Sheet: WW Gross Sales Trends

MATTEL, INC. AND SUBSIDIARIES
[NAME] REVENUE GROWTH TRENDS  (USING 2011 AND PRIOR SEGMENT CLASSIFICATIONS)
 |  |  |  |  | 2009 |  |  |  |  |  |  |  | 2010 |  |  |  |  |  |  |  | 2011
 |  |  |  |  | 1 Qtr |  | 2 Qtr |  | 3 Qtr |  | 4 Qtr |  | 1 Qtr |  | 2 Qtr |  | 3 Qtr |  | 4 Qtr |  | 1 Qtr |  | 2 Qtr |  | 3 Qtr |  | 4 Qtr
[NAME] Sales:
Mattel, Inc. - Worldwide
 | % Change |  |  |  | -0.15 |  | -0.2 |  | -0.08 |  | 0 |  | 0.12 |  | 0.13 |  | 0.02 |  | 0.08 |  | 0.08 |  | 0.15 |  | 0.09 |  | 0.01
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | -7 |  | -6 |  | -3 |  | 3 |  | 3 |  | -3 |  | -3 |  | -3 |  | 0 |  | 5 |  | 2 |  | -1
Mattel, Inc. - Domestic
 | % Change |  |  |  | -0.06 |  | -0.12 |  | -0.02 |  | -0.02 |  | 0.12 |  | 0.17 |  | 0.03 |  | 0.11 |  | 0.07 |  | 0.07 |  | 0.06 |  | -0.02
Mattel, Inc. - International
 | % Change |  |  |  | -0.23 |  | -0.26 |  | -0.14 |  | 0.03 |  | 0.12 |  | 0.09 |  | 0.02 |  | 0.06 |  | 0.1 |  | 0.23 |  | 0.13 |  | 0.05
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | -13 |  | -10 |  | -5 |  | 8 |  | 7 |  | -5 |  | -7 |  | -5 |  | 2 |  | 11 |  | 5 |  | -3
Mattel, Inc. - International:
Mattel, Inc. - Europe
 | % Change |  |  |  | -0.26 |  | -0.29 |  | -0.16 |  | 0.04 |  | 0.09 |  | 0.07 |  | 0.03 |  | 0.03 |  | 0.02 |  | 0.27 |  | 0.12 |  | 0.04
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | -12 |  | -9 |  | -4 |  | 9 |  | 5 |  | -7 |  | -8 |  | -5 |  | -1 |  | 12 |  | 6 |  | -2
Mattel, Inc. - Latin America
 | % Change |  |  |  | -0.21 |  | -0.23 |  | -0.13 |  | 0 |  | 0.1 |  | 0.01 |  | -0.06 |  | 0.05 |  | 0.28 |  | 0.2 |  | 0.16 |  | 0.05
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | -17 |  | -13 |  | -8 |  | 7 |  | 2 |  | -10 |  | -11 |  | -8 |  | 7 |  | 9 |  | 4 |  | -7
Mattel, Inc. - Asia Pacific
 | % Change |  |  |  | -0.15 |  | -0.2 |  | 0.03 |  | 0.08 |  | 0.32 |  | 0.28 |  | 0.13 |  | 0.21 |  | 0.19 |  | 0.2 |  | 0.14 |  | 0.1
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | -13 |  | -9 |  | -2 |  | 16 |  | 16 |  | 6 |  | 3 |  | 4 |  | 4 |  | 9 |  | 7 |  | 1
[NAME]:
American Girl - Worldwide
 | % Change |  |  |  | -0.04 |  | 0 |  | 0.04 |  | 0 |  | 0.06 |  | -0.04 |  | 0.02 |  | 0.08 |  | 0.04 |  | 0.13 |  | 0.04 |  | 0.04
The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 125359d1318978811-percentage-of-completion-self-calculating-worksheet-ofcompletionmethod
Sheet: Sheet2

Original data | 2003 | 2004 | 2005 | 2006 | 2007 | Rusting Construction Company                                                                                                                                                                                                                                                                                                                                                                  Journal entries to recognize revenue, and gross profit for long-term project (percentage-of-completion method) Year 2003-2007
Actual cost incurred | 6000000 | 9080000 | 7420000 | 5000000 | 0
Est.cost to complete | 19000000 | 13920000 | 10277778 | 0 | 0
Collections on contract | 6000000 | 6750000 | 7500000 | 7500000 | 2250000 |  | 2003 |  | 2004 |  | 2005 |  | 2006 |  | 2007
Billings on contract | 6500000 | 7750000 | 8500000 | 7250000 |  | Construction in Progress
Contract price | 30000000 |  |  |  |  | Materials, Cash payables, etc.
Revenue, cost, and gross profit Work sheet (percentage-of-completion method)  for yrs. 2003-2007 |  |  |  |  |  | Accounts Recievable
 | 2003 | 2004 | 2005 | 2006 | 2007 | Billings to Const. in Progress
Costs incurred to date |  |  |  |  |  | Cash
Most recent Est. of total costs |  |  |  |  |  | Billings to Const. in Progress
Est. total Costs |  |  |  |  |  | Construction Expense
Est. total [NAME] |  |  |  |  |  | Construction in Progress
Percentage Complete |  |  |  |  |  | Rev. from Long-Term Contract
Rev. to be recognized to date |  |  |  |  |  | Billings to Const. in Progress
Rev. recognized in prior periods | 0 |  |  |  |  | Construction in Progress
Current period revenue
Current period costs
Gross Profit
2003 Current period costs
2004 Current period costs
2005 Current period costs
2006 Current period costs
2007 Current period costs
Spreadsheet: 713335d1610649830-tracking-sales-growth-related-to-marketing-start-dates-vary-by-location-marketing-initiatives-sales-growth-example
Sheet: Example

 | Date | Location | This Year Sales | Last Year Sales | SSS? | Initiative1 | Initiative2
 | 2020-11-29 00:00:00 | Location 1 | 10.37172 | 9.098 |  |  |  |  |  |  |  |  |  | Initiative1 |  | Initiative2
 |  | Location 1 | 6.9703 | 8.105 |  |  |  |  |  |  |  |  |  | Location | Started | Location | Started
 |  | Location 1 | 0 | 7.922 |  |  |  |  |  |  |  |  |  | Location 1 | 2021-01-03 00:00:00 | Location 2 | 2020-12-27 00:00:00
 |  | Location 1 | 9.47086 | 7.763 |  |  |  |  |  |  |  |  |  | Location 2 | 2021-01-24 00:00:00 | Location 3 | 2021-01-17 00:00:00
 |  | Location 1 | 9.5 | 7.613 |  |  |  |  |  |  |  |  |  | Location 3 | 2021-01-10 00:00:00 | Location 4 | 2021-01-24 00:00:00
 |  | Location 1 | 10 | 8.927 |  |  |  |  |  |  |  |  |  | Location 4 | 2021-01-03 00:00:00
 |  | Location 1 | 11 | 9.89
 |  | Location 1 | 10.75 | 10.442
 |  | Location 1 | 9 | 7.656
 |  | Location 2 | 8.73496 | 8.399
 |  | Location 2 | 8.817 | 8.817 |  |  |  |  |  |  |  | 2020-12-13 00:00:00 | 2020-12-20 00:00:00 | 2020-12-27 00:00:00 | 2021-01-03 00:00:00 | 2021-01-10 00:00:00 | 2021-01-17 00:00:00
 |  | Location 2 | 9.792 | 10.2 |  |  |  |  |  |  | Year over Year % Growth
 |  | Location 2 | 10.72926 | 9.666 |  |  |  |  |  |  | Initiative1
 |  | Location 2 | 9.85558 | 9.758 |  |  |  |  |  |  | Initiative2
 |  | Location 2 | 9.75 | 7.288
 |  | Location 2 | 9.25 | 6.762
 |  | Location 2 | 11 | 8.018 |  |  |  |  |  |  | % Growth Since Initiative Start |  |  |  | More or less the data I'm trying to make a formula to caputure
 |  | Location 2 | 12 | 7.73 |  |  |  |  |  |  | Initiative1
 |  | Location 3 | 8.2151 | 7.27 |  |  |  |  |  |  | Sales - Active Period
 |  | Location 3 | 6.688149999999999 | 6.895 |  |  |  |  |  |  | Sales - Pre Initiative |  |  |  | 2 possible ways to look at the pre-initiative period
 |  | Location 3 | 6.528340000000001 | 7.174 |  |  |  |  |  |  | Initiative2
 |  | Location 3 | 6.01065 | 6.327 |  |  |  |  |  |  | Sales - Active Period
 |  | Location 3 | 8.08896 | 8.426 |  |  |  |  |  |  | Sales - Pre Initiative |  |  |  | 2 possible ways to look at the pre-initiative period
 |  | Location 3 | 7 | 5.175
 |  | Location 3 | 7.25 | 2.591 |  |  |  |  |  |  | For locations that weren't active the whole period, only use the weeks they were (e.g. if Location 3 started on 1/17/21, compare to either the 2 weeks before any location started (12/13-12/20) or the 2 weeks before this location started (1/3-1/10))
 |  | Location 3 | 6.57087 | 7.383
 |  | Location 3 | 8.975520000000001 | 9.756
 |  | Location 4 | 7 | 10.634
 |  | Location 4 | 5.16734 | 5.806
 |  | Location 4 | 6.86289 | 6.663
 |  | Location 4 | 7.46468 | 6.326
 |  | Location 4 | 6.444800000000001 | 6.08
 |  | Location 4 | 7.71375 | 6.171
 |  | Location 4 | 7.502 | 6.05
 |  | Location 4 | 8 | 6.93
 |  | Location 4 | 8.25 | 6.135