tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713715d1610893483-extracting-data-from-multiple-worksheets-sample-new-ufc
Sheet: Lightweight_edit_

Rank | Fighter | Record | M | Last fight | Next fight
C | Khabib Nurmagomedov | 29–0 | Steady | [NAME] | TBD
1 | [NAME] | 22–3 | Steady | Lost to Khabib Nurmagomedov | TBD
2 | [NAME] | 26–6 | Steady | [NAME] | vs. [NAME] (UFC 257)
3 | [NAME] | 30–8 (1 NC) | Steady | [NAME] | TBD
4 | Conor [NAME] | 22–4 | 1 | [NAME] | vs. [NAME] (UFC 257)
5 | [NAME] | 25–5 | 1 | Lost to [NAME] | TBD
6 | [NAME] | 20–9 | Steady | Lost to [NAME] | vs. [NAME] (UFC 257)
7 | [NAME] dos [NAME] | 30–13 | Steady | [NAME] | TBD
8 | [NAME] | 17–6 | Steady | Lost to Rafael dos [NAME] | TBD
9 | [NAME] | 17–2 | Steady | [NAME] | vs. [NAME] (UFC Fight Night 184)
10 | [NAME] | 14–6–1 | Steady | Lost to [NAME] | TBD
11 | [NAME] | 18–6 | Steady | Lost to [NAME] | TBD
12 | [NAME] | 18–4–1 | Steady | [NAME] | vs. [NAME] (UFC Fight Night 184)
13 | [NAME] | 18–1 | Steady | [NAME] | vs. [NAME] (UFC 259)
14 | [NAME] | 13–1 | Steady | Lost to [NAME] | TBD
15 | [NAME] | 23–9 (1 NC) | Steady | [NAME] | vs. [NAME] (UFC 259)
Spreadsheet: 727964d1618233349-find-address-and-use-that-to-look-at-another-cells-data-temp
Sheet: Sheet2

 |  |  |  | Upstairs |  | Downstairs |  | Network |  | Stove |  | Smokes |  | Garage
 | Date | Time | House | Power | % | Power | % | Power | % | Power | % | Power | % | Power | %
Spreadsheet: 112068d1308238019-format-for-logical-formula-based-on-certain-conditions-trip-budget
Sheet: Sheet2

IFA Trip Budget |  |  |  |  |  |  | Trip Budget
 |  |  |  |  |  |  | Budget: | (Enter Allocated Budget)
 |  |  |  |  |  |  | Expected Spending:
 |  |  |  |  |  |  | Actual Spending:
 |  |  |  |  |  |  | Amount being Credited:
Start Date | End Date | Days of Trip |  |  |  |  | Budget Remaining:
(Enter Start Date) |  | (Enter Days of Trip)
Day 1:
Staff Member | Client | Expense Type | Expected Cost | Actual Cost | Difference | Credits
Day 2:
Staff Member | Client | Expense Type | Expected Cost | Actual Cost | Difference
Day 3:
Staff Member | Client | Expense Type | Expected Cost | Actual Cost | Difference
Day 4:
Staff Member | Client | Expense Type | Expected Cost | Actual Cost | Difference
Day 5:
Staff Member | Client | Expense Type | Expected Cost | Actual Cost | Difference
Day 6:
Staff Member | Client | Expense Type | Expected Cost | Actual Cost | Difference
Spreadsheet: 694162d1599400282-excel-to-match-pay-slip-figures-with-payroll-figures-according-to-period-producing-payslip-from-payroll
Sheet: PAYROLL

 | PAYROLL
 | Date | Period | Employee Code Number | Employee I.D | Position | Basic Pay | Overtime | House & Transport Allowance | Total Earnings
 | 2020-01-20 00:00:00 | 1 | CA1 | Olivia | [NAME] | 10000 | 500 | 2000
 | 2020-01-20 00:00:00 | 1 | CA2 | [NAME] | [NAME] | 10200 | 600 | 2000
 | 2020-01-20 00:00:00 | 1 | CA3 | Jain | [NAME] | 10100 | 500 | 2000
 | 2020-02-20 00:00:00 | 2 | CA1 | Olivia | [NAME] | 10100 |  | 2100
 | 2020-02-20 00:00:00 | 2 | CA2 | [NAME] | [NAME] | 10300 |  | 2100
 | 2020-02-20 00:00:00 | 2 | CA3 | Jain | [NAME] | 10200 |  | 2100
Spreadsheet: joe_parks__15018__bridgeline 6-4
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
S | NGV2 | 3408 | 3 | 08:59:58 | 905 | 97563 | 4C | 3793 | [NAME] | EO-3793 | 1790 | AT | N
S | NGV2 | 3408 | 2 | 08:59:58 | 905 | 97563 | 4C | 3793 | [NAME] | EO-3793 | 1793 | AT | N
S | NGN2 | 3321 | 5 | 08:21:33 | 905 | 97563 | 4C | 3570 | amk | EO-3570 | 1637 | AT | N
S | NGN2 | 3325 | 4 | 08:21:22 | 905 | 97563 | 4C | 3568 | amk | EO-3568 | 1636 | AT | N
S | NGN2 | 3310 | 8 | 08:39:21 | 905 | 97563 | 4C | 3660 | amk | EO-3660 | 1686 | 0 | N
S | NGN2 | 3310 | 9 | 08:39:21 | 905 | 97563 | 4C | 3660 | amk | EO-3660 | 1687 | 0 | N
S | NGN2 | 3315 | 7 | 08:22:16 | 905 | 97563 | 4C | 3577 | amk | EO-3577 | 1640 | 0 | N
S | NGN2 | 3325 | 4 | 08:59:54 | 905 | 97563 | 4C | 3765 | [NAME] | EO-3765 | 1788 | 0 | N
S | NGN2 | 3330 | 1 | 08:58:02 | 905 | 97563 | 4C | 3765 | [NAME] | EO-3765 | 1775 | 0 | N
Spreadsheet: 149920d1334188430-if-then-formula-with-vlookup-sample-file-for-value-import-1-
Sheet: Lab Values

Values | MRN# | Helper1 | Reported Date | Year | Month | Values
0.055 | 12345 | [PHONE] | 2012-03-02 00:00:00 | 2012 | 3 | 0.055
0.075 | 98765 | [PHONE] | 2012-04-01 00:00:00 | 2012 | 4 | 0.075
0.1 | 12345 | [PHONE] | 2012-10-10 00:00:00 | 2012 | 10 | 0.1
Spreadsheet: 831400d1685613519-multiple-if-calculating-two-cells-and-totalling-excel-forum-example
Sheet: Sheet1

 | Row Labels | Count of Servers | Average of Number of links | Complexity Rating
 | Application 1 | 2 | 4
 | Application 2 | 7 | 8
 | Application 3 | 13 | 24
 | Application 4 | 20 | 1.6
 | Application 5 | 4 | 21
 | Application 6 | 3 | 5
 | Application 7 | 10 | 1
 | Application 8 | 95 | 6.242105263157895
 | Application 9 | 6 | 5.333333333333333
 | Application 10 | 14 | 18.71428571428572
 | Application 11 | 7 | 23.85714285714286
 | Application 12 | 10 | 11.2
 | Application 13 | 1 | 1
 | Application 14 | 2 | 1
 | Application 15 | 11 | 15.63636363636364
 | Application 16 | 4 | 21
 | Application 17 | 8 | 2
Spreadsheet: 799189d1664978280-performance-growth-calculation-sample_table
Sheet: Sheet1

Employee Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Employee Name | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total Growth
Agent 1 |  |  |  |  | 88 | 67.8 | 63.9 | 63.5 | 79.1 |  |  |  |  | Agent 1
Agent 2 |  |  |  |  |  |  |  | 80.4 | 68.8 |  |  |  |  | Agent 2
Agent 3 | 79.1 | 64.1 | 74.5 | 69.2 | 83 | 69.9 | 77.6 | 71.5 | 63.8 |  |  |  |  | Agent 3
Agent 4 |  | 67.6 | 78.2 | 86.2 | 80.9 | 90.6 |  |  |  |  |  |  |  | Agent 4
Agent 5 |  |  |  |  | 83.6 |  |  |  |  |  |  |  |  | Agent 5
Agent 6 | 67.4 | 65.5 | 69.2 | 75.1 | 88.2 | 82.4 | 67.8 | 62.2 | 72.1 |  |  |  |  | Agent 6
Agent 7 | 87.8 | 97.5 | 90.6 | 88 | 86.9 | 86 | 92.3 | 94.6 | 88.2 |  |  |  |  | Agent 7
Agent 8 | 0 | 71.8 | 68.8 | 64.8 |  |  | 66.7 | 71.3 | 70 |  |  |  |  | Agent 8
Agent 9 | 95 | 52.2 | 68.4 |  |  |  |  |  |  |  |  |  |  | Agent 9
Agent 10 | 0 | 100 | 93.8 | 78 | 56.8 |  |  |  |  |  |  |  |  | Agent 10
Agent 11 |  |  |  | 70 | 74.5 | 83.6 | 77.3 | 81.7 | 68.4 |  |  |  |  | Agent 11
Agent 12 |  |  |  |  | 61 | 71.3 | 79.6 | 68 | 65.2 |  |  |  |  | Agent 12
Agent 13 | 93.8 | 79.8 | 82.7 | 84.7 | 77.8 | 70.3 | 84.5 | 83 | 85.2 |  |  |  |  | Agent 13
Agent 14 |  |  |  | 88.2 | 70.7 | 77.1 | 80.7 | 67.6 | 85.9 |  |  |  |  | Agent 14
Agent 15 |  | 81.4 | 84.4 | 73.3 | 69.8 | 76.8 | 84.5 | 83 | 62.6 |  |  |  |  | Agent 15
Agent 16 |  |  | 68.4 | 65.9 | 65.7 | 68.6 | 76.1 | 71 | 83.6 |  |  |  |  | Agent 16
Agent 17 | 81.8 | 86.4 | 84.4 | 81 | 86 | 69.7 | 87.3 | 81.4 | 88.2 |  |  |  |  | Agent 17
Agent 18 | 83.3 | 88.2 | 67.7 | 67.3 | 78.8 | 68.3 | 67.9 | 71.3 | 86.7 |  |  |  |  | Agent 18
Agent 19 | 0 | 0 | 0 | 79.1 | 73.5 | 76 | 76.4 | 69.8 | 77.6 |  |  |  |  | Agent 19
Agent 20 | 67.4 | 79.8 | 76.2 | 77.1 | 79.8 | 83.5 | 80 | 83 | 86.7 |  |  |  |  | Agent 20
Agent 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | Agent 21
Agent 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | Agent 22
Agent 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | Agent 23
Spreadsheet: 33859d1230707723-conditional-copy-of-row-from-one-sheet-to-another-sheet-project1
Sheet: Sales

 |  | Amount
Date | particular | Opening | Debit | Credit | Closing
 |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 1e625d40-b0d9-4c34-9b31-2d5e432df1a3
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
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 11. Input to the [NAME] mining industry, index numbers and percentage changes
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Number ;  Open cut mining ; |  |  | Original | A2314310A | 1987-09-01 00:00:00 | 2012-09-01 00:00:00 | 101 | Index Numbers | INDEX | Quarter | 3
Percentage change from pervious quarter ;  Open cut mining ; |  |  | Original | A2314311C | 1987-12-01 00:00:00 | 2012-09-01 00:00:00 | 100 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Open cut mining ; |  |  | Original | A2314312F | 1988-09-01 00:00:00 | 2012-09-01 00:00:00 | 97 | Percent | PERCENT | Quarter | 3
Index Number ;  Underground mining ; |  |  | Original | A2314376T | 1987-09-01 00:00:00 | 2012-09-01 00:00:00 | 101 | Index Numbers | INDEX | Quarter | 3
Percentage change from pervious quarter ;  Underground mining ; |  |  | Original | A2314377V | 1987-12-01 00:00:00 | 2012-09-01 00:00:00 | 100 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Underground mining ; |  |  | Original | A2314378W | 1988-09-01 00:00:00 | 2012-09-01 00:00:00 | 97 | Percent | PERCENT | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 200859d1355782328-matching-multiple-cells-to-different-tabs-on-a-worksheet-index-of-employees-solution
Sheet: South

 | 2 | 3 | 4 | 5
 | SOUTH
 | Division | Last Name | First Name | Employee ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Fundies-All

 | Fundamentals
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 24109311.02937501
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 | 1
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 6
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 4
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 4
 |  |  |  |  |  |  |  | Director | 143000 | 1
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  |  | 1
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: ae5e3e11-6271-4dc1-b0ef-f5cc6a1afdfe
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40168018 | 2014-02-21 22:22:10 | AXIS | 1 | 10 | 6 | 676105 | Didji | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40169090 | 2014-02-21 23:23:47 | ALLIES | 0 | 6 | 10 | 676105 | Didji | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40341605 | 2014-03-03 23:16:45 | AXIS | 0 | 6 | 7 | 575415 | EMI44 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40342222 | 2014-03-03 23:39:09 | ALLIES | 0 | 2 | 7 | 575415 | EMI44 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40403793 | 2014-03-07 22:25:02 | ALLIES | 0 | 3 | 6 | 1490339 | nogginmouse | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
40404060 | 2014-03-07 22:41:50 | AXIS | 1 | 6 | 5 | 1490339 | nogginmouse | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
40404330 | 2014-03-07 22:54:49 | ALLIES | 1 | 5 | 1 | 1490339 | nogginmouse | 9597 | western | 1944-06-06 | 1944-06-06 | Utah Beach | Utah Beach
40404721 | 2014-03-07 23:34:29 | AXIS | 0 | 4 | 6 | 553649 | [NAME] | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
40405106 | 2014-03-07 23:50:13 | ALLIES | 1 | 6 | 4 | 553649 | [NAME] | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
Spreadsheet: 682842d1592357715-expanding-a-list-to-repeat-values-based-on-another-column-excel-forum-suburb-list_chris
Sheet: Sheet1

Property Suburb | Property Number | Contact |  |  | Number | Property Suburb
 | 1 | 3 Trent Place |  |  | 1 | Fenton Park
 | 1 | [NAME] |  |  | 2 | Fenton Park
 | 1 | [NAME] |  |  | 3 | Fenton Park
 | 2 | 14 McKee Avenue |  |  | 4 | Fenton Park
 | 2 | Dinesh SOFAT |  |  | 5 | Fenton Park
 | 2 | [NAME] |  |  | 6 | Fenton Park
 | 3 | 25A Deere Avenue |  |  | 7 | Fenton Park
 | 3 | [NAME] (Three Sons) |  |  | 8 | Fenton Park
 | 3 | [NAME], |  |  | 9 | Fenton Park
 | 4 | 4abc Deere Avenue |  |  | 10 | Fenton Park
 | 4 | [NAME] MUDGE |  |  | 11 | Fenton Park
 | 4 | [NAME] |  |  | 12 | Fenton Park
 | 5 | 12A McKee Avenue |  |  | 13 | Fenton Park
 | 5 | [NAME] |  |  | 14 | Fenton Park
 | 5 | [NAME] |  |  | 15 | Fenton Park
 | 6 | 5 Trent Place |  |  | 16 | Fenton Park
 | 6 | [NAME] |  |  | 17 | Fenton Park
 | 7 | 31 abcd Ward Avenue |  |  | 18 | Fenton Park
 | 7 | [NAME] |  |  | 19 | Fenton Park
 | 7 | Conor [NAME] |  |  | 20 | Fenton Park
 | 8 | 4/22 Deere Avenue |  |  | 21 | Fenton Park
 | 8 | [NAME] |  |  | 22 | Glenholme
 | 8 | [NAME] |  |  | 23 | Glenholme
 | 9 | 18A Gibson Street |  |  | 24 | Glenholme
 | 9 | [NAME] |  |  | 25 | Glenholme
 | 9 | Anne Mead |  |  | 26 | Glenholme
 | 10 | 6 Trent Place |  |  | 27 | Glenholme
 | 10 | [NAME] |  |  | 28 | Glenholme
 | 11 | 5/12 Trent Place |  |  | 29 | Glenholme
 | 11 | Sheree Smail |  |  | 30 | Glenholme
 | 11 | Marnie Elsie McGuire |  |  | 31 | Glenholme
 | 12 | 5/16 Maida Vale Street |  |  | 32 | Glenholme
 | 12 | [NAME] |  |  | 33 | Glenholme
 | 13 | 2/21 Hilda Street |  |  | 34 | Glenholme
 | 13 | [NAME] |  |  | 35 | Hillcrest
 | 13 | Grant [NAME] |  |  | 36 | Hillcrest
 | 14 | 4/15 Hilda Street |  |  | 37 | Hillcrest
 | 14 | [NAME] |  |  | 38 | Lynmore
 | 15 | 22 Trigg Avenue |  |  | 39 | Lynmore
 | 15 | [NAME] |  |  | 40 | Mangakakahi
Spreadsheet: 800205d1665540969-trying-to-find-the-correct-formula-book1-mattd39-
Sheet: Pivot Table

Renewal Date | Sum of 2021 Premium | Sum of 2022 Premium | Sum of % Change
2022-09-08 00:00:00 |  | 44000 | 0
2022-09-15 00:00:00 | 14500 | 14500 | 0
2022-09-28 00:00:00 | 2870 | 2870 | 0
2022-09-29 00:00:00 | 325000 | 170588 | -0.4751138461538461
2022-09-30 00:00:00 | 70500 | 87500 | 0.2411347517730495
2022-10-01 00:00:00 | 950000 | 650000 | -0.3157894736842105
2022-10-03 00:00:00 | 30000 | 33500 | 0.1166666666666667
2022-11-23 00:00:00 | 1058000 |  | 0
2022-12-05 00:00:00 | 30000 |  | 0
Grand Total | 2480870 | 1002958 | -0.4331019013983404
Spreadsheet: 852801d1702747868-data-relocation-from-worksheet-to-worksheet-example
Sheet: Household

 | Household
Date | Payee | Description | Amount
2023-01-10 00:00:00 | Jan's Cell Addition | dates covering 12/12/22 - 1/10/23 | 80
2023-01-11 00:00:00 | Bertolotti Disposal | Acct. # 11-35740 0    Garbage Service for Dec/Jan. | 58.62
2023-01-11 00:00:00 | JS West Propane Gas | Account 122, Grayson Propane Service  November Budget Amount | 1218
2023-01-13 00:00:00 | All Clean Pool Service | Dec. Monthly Service Charge | 150
2023-01-16 00:00:00 | Verizon | Cell Phone covering   11/26/22 - 12/25/22  Inv. [PHONE] | 185.3
2023-01-31 00:00:00 | AT&T (TV) | DirecTV, acct: 264804173 (1/19/23 - 2/18/23) | 88.67
2023-02-05 00:00:00 | Walmart | oil & filter for truck, misc groceries | 85.55
2023-02-13 00:00:00 | JS West Propane Gas | Account 101022, Grayson Propane Service  Feb. Budget Amount | 404
 |  | Total
Spreadsheet: 4445fe5f-61c7-494c-9168-08899020cdd9
Sheet: Results Matter School Readiness

Grant: |  | Results Matter School Readiness Assessment Pilot
CFDA # |  | 93.708
GRANT NUMBER: |  | 5708
FISCAL YEAR: |  | 2011-12
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6905 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - September 15, 2012
Code | District Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JANUARY 2012 | FEBRUARY 2012 | MARCH 2012 | APRIL 2012 | MAY 2012 | JUNE 2012 | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012
0880 | Denver Public Schools | 17599 |  |  |  |  |  |  |  |  |  | 17599
1420 | Jefferson County R-1 | 17598 |  |  |  |  |  |  | 2324 |  | 518
Spreadsheet: stacey_white__38768__DPR 0709
Sheet: Summary

Show
y
y
y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
y
y
y
y | 2001-07-09 00:00:00
y |  |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
y | Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD
y
y | ENRON SOUTH AMERICA
y
y | MODESTO MARANZANA PLANT
y
y
y
y
y
y | SOUTH AMERICA TRADING
y
y | SA GAS TRADING |  |  | 35.0 Bcf |  |  | 20.0 Bcf |  |  |  | 2000
y | SA POWER TRADING |  |  | 3.5 Mil MWH |  |  | 2.0 Mil MWH |  |  |  | 5000
y | CUIABA HISTORICAL
y
y | SA GAS TRADING
y
y | ARGENTINA
y | GAS TRADING
n | Intramonth
n | Firm
y | TRANSPORT
y
y | CREDIT |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
n |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
n |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
y
y | SA POWER TRADING
y
y | ARGENTINA
y | POWER TRADING
n | Ezezia Power Trading
n | Rio Cuarto Power Trading
y | MODESTO MARANZANA POWER
y
y | BRAZIL/BOLIVIA
y | POWER TRADING
y
y | [NAME]
y | CRUDE
y | GAS
n | GNS |  | 0
n | SC |  | 0
n | TBS |  | 0
n | TBS Crude |  | 0
Spreadsheet: 715323d1611666912-allocate-from-a-shared-pool-sharedpoolallocationtest
Sheet: Sheet1

Spend Type | Can Draw From | Total Possible Spend | Remaining | Spend (manual input) |  | Cash Pool | £
1 | A, C, D, E, F |  |  |  |  | A | 10
2 | A |  |  |  |  | B | 15
3 | A, B, C |  |  |  |  | C | 5
4 | B, C, F |  |  |  |  | D | 0
5 | B, E |  |  |  |  | E | 18
6 | A, E |  |  |  |  | F | 3
Spreadsheet: 50978d1250588907-setting-up-default-format-settings-w-pivot-tables-so-graphical-format-doesnt-change-00003417-0-pm-stats
Sheet: Pivot Table

Month | Jun
 |  | Status
Week Commencing | Data | Green | Amber | Red
2009-06-01 00:00:00 | [NAME] | 69.56521739130434 | 21.73913043478261 | 8.695652173913043
 | Petra % | 25 | 25 | 50
 | [NAME] | 70 | 20 | 10
 | Guy % | #N/A | #N/A | #N/A
 | [NAME] | 50 | 25 | 25
 | Total % | 60.97560975609756 | 21.95121951219512 | 17.07317073170732
2009-06-08 00:00:00 | [NAME] | 68.18181818181819 | 27.27272727272727 | 4.545454545454546
 | Petra % | 37.5 | 12.5 | 50
 | [NAME] | 68.18181818181819 | 27.27272727272727 | 4.545454545454546
 | Guy % | #N/A | #N/A | #N/A
 | [NAME] | 10 | 50 | 40
 | Total % | 56.36363636363636 | 25.45454545454545 | 18.18181818181818
2009-06-15 00:00:00 | [NAME] | 76.19047619047619 | 14.28571428571428 | 9.523809523809524
 | Petra % | 33.33333333333333 | 22.22222222222222 | 44.44444444444444
 | [NAME] | 92.85714285714286 | 7.142857142857143 | 0
 | Guy % | 25 | 75 | 0
 | [NAME] | 27.27272727272727 | 36.36363636363637 | 36.36363636363637
 | Total % | 68.75 | 18.75 | 12.5
2009-06-22 00:00:00 | [NAME] | 73.6842105263158 | 15.78947368421053 | 10.52631578947368
 | Petra % | 66.66666666666667 | 8.333333333333334 | 25
 | [NAME] | 78.57142857142857 | 21.42857142857143 | 0
 | Guy % | 50 | 30 | 20
 | [NAME] | 14.28571428571429 | 57.14285714285715 | 28.57142857142857
 | Total % | 69.0909090909091 | 18.18181818181818 | 12.72727272727273
2009-06-29 00:00:00 | [NAME] | 84.21052631578948 | 10.52631578947368 | 5.263157894736842
 | Petra % | 40 | 20 | 40
 | [NAME] | 52.94117647058824 | 41.1764705882353 | 5.882352941176471
 | Guy % | 54.54545454545455 | 18.18181818181818 | 27.27272727272727
 | [NAME] | 0 | 66.66666666666667 | 33.33333333333334
 | Total % | 61.40350877192982 | 22.80701754385965 | 15.78947368421053
Total Darren % |  | 74.3664497211408 | 17.92267229338168 | 7.710877985477528
Total Petra % |  | 40.5 | 17.61111111111111 | 41.88888888888889
Total [NAME] |  | 72.51031321619557 | 23.40412528647823 | 4.085561497326204
Total Guy % |  | #N/A | #N/A | #N/A
Total [NAME] |  | 20.31168831168831 | 47.03463203463203 | 32.65367965367966
Total Total % |  | 63.31673279651456 | 21.42892013848368 | 15.25434706500175
Spreadsheet: 754603d1636372800-count-duplicates-without-any-condition-test01
Sheet: Sheet1

Part# |  | Result: | 7
A1572000201
A2305410001
A1770940100
A6277640038
A2128300318
A2782001201
A0039937296
A2123201189
A2305410001
A1663300143
A2701800109
A1663300143
[NAME]
A0009829608
A1663300143
[NAME]
A1770783000
A2782001201
Spreadsheet: 138722d1327855325-rotating-multiple-rows-to-a-single-column-explanation
Sheet: Sheet1

5 | 7 | 8 | 9
10 | 11 | 12 | 13
14 | 15 | 16 | 17
As we know, OFFSET(A1,row#,col#) will let current cell at A1 move down row# rows, then move right col # columns. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINAL FORMULA
We will start by getting the expect result as below row# and col#:
 | Expected |  |  |  | How to get row# ? | => | Make autonumbers |  | How to get col# ? | => | Make autonumbers | => | 1st testing | => | Replace 0 by "blank"
Result | row# | col#
5 | 0 | 0 | => OFFSET(A1,0,0) = A1
7 | 0 | 1 | => OFFSET(A1,0,1) = B1
8 | 0 | 2 | …
9 | 0 | 3 | …
 | 0 | 4 | => return blank
10 | 1 | 0 | => OFFSET(A1,1,0) = A2
11 | 1 | 1
12 | 1 | 2
13 | 1 | 3
 | 1 | 4 | => return blank
14 | 2 | 0
15 | 2 | 1
16 | 2 | 2
17 | 2 | 3
 | 2 | 4 | => return blank
Spreadsheet: 68ea738d-b795-4743-8739-336da0bdc775
Sheet: New Table 9

Weekly Barge Rates for Major Grain Shipping Points on the Mississippi, Ohio, and Arkansas Rivers
Table 9
Weekly Barge Freight Rates:  Southbound Only
 |  | Twin         Cities | Mid-Mississippi | Lower Illinois         River | St. Louis | Cincinnati | Lower         Ohio | Cairo-Memphis
Rate1 | 2013-05-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  | -
$[NAME]
 |  |  |  | n/a
Current week % change from the same week:
 | Last year
 | 3-year avg. 2
Rate1 | June
 | August
1Rate = percent of 1976 tariff benchmark index (1976 = 100 percent); 24-week moving average; ton = 2,000 pounds
Source:  Transportation & Marketing Programs/AMS/USDA
 |  | TWC | MM | ILL | ST LOUIS |  | LOH | CAR-MEM
[NAME] |  | 6.19 | 5.32 | 4.64 | 3.99 | 4.69 | 4.04 | 3.14