tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 722c6e87-3919-4688-9b33-197f83e3eca0
Sheet: Sheet1

ISOLINE  ARCO | 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
 | Odběratel: |  |  |  |  |  |  |  | List č. ..... [NAME] |  |  |  | m²:
 |  |  |  |  |  |  |  |  | (příklad: List č. 1   z.  5)
 |  |  |  |  |  |  |  |  | Dat. objednání:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zbrojovka obj. 13
 |  |  |  |  |  |  |  |  | Dat. rozvozu: |  |  |  |  |  | 755 01  Vsetín
 |  |  |  |  |  |  |  |  |  |  |  |  | ks: |  | fax: 571 432 723
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tel.: 571 405 580
 |  |  |  |  |  |  |  |  | Číslo zakázky: |  |  |  |  |  | e-mail: [EMAIL]
 | Pozice |  | [NAME] | Profil |  | [NAME] ([NAME]) |  |  |  | ks | Barva |  | Rám okna | Dist. podl. (počet) |  | Poznámka
 |  |  |  |  |  | Šířka | Výška |  |  |  | Lamely | [NAME]
 | [NAME] ovládání: |  |  | Profil: |  |  |  | Barva lamely: |  |  | Barva profilu: |  | Rám okna: |  |  | Poznámka:
 |  |  |  |  |  |  |  | dle vzorníku |  |  |  |  | PVC – plast |  |  | v poznámce [NAME] nestandardní
 | ŘP – pravé |  |  | Al – hliníkový |  |  |  |  |  |  | B – bílý (Fe, Al) |  | D – dřevo |  |  | požadavky a úpravy.
 | ŘL – levé |  |  | Fe - pozink |  |  |  |  |  |  | H – hnědý (Fe, Al)
 |  |  |  |  |  |  |  |  |  |  | S – stříbrný (Fe) |  | Dist. podložky:
 |  |  |  |  |  |  |  |  |  |  |  |  | píšeme počet podložek
Spreadsheet: 472999d1469955085-calculating-the-number-of-days-by-activity-code-book1
Sheet: Sheet1

Entity ID | Code | Date | Total Number of Days
80000542 | INSERT_TO_CL | 12-NOV-12
80000542 | CUSTOMER_COMMUNICATION | 13-NOV-12
80000542 | STOP_CL | 13-NOV-12 | 1
80001802 | CUSTOMER_COMMUNICATION | 03-AUG-11
80001802 | INSERT_TO_CL | 03-AUG-11
80001802 | STOP_CL | 23-AUG-11 | 20
Spreadsheet: 27673d1221118682-automatically-add-the-payments-into-a-summary-worksheet-sample
Sheet: Summary

Summary of Borrower's total interest and payments |  |  |  |  | Summary of Borrower's total interest and payments
Date | Interest | Payment Due | Payment Made |  | Date | Interest | Payment Due | Payment Made
2008-08-15 00:00:00 |  |  |  |  | 2008-08-15 00:00:00 | 800 | 3300 | 3300
2008-08-30 00:00:00 |  |  |  |  | 2008-08-30 00:00:00 | 800 | 3300 | 3300
2008-09-15 00:00:00 |  |  |  |  | 2008-09-15 00:00:00 | 1333.333333333333 | 5500 | 5500
2008-09-30 00:00:00 |  |  |  |  | 2008-09-30 00:00:00 | 1333.333333333333 | 5500 | 0
2008-10-15 00:00:00 |  |  |  |  | 2008-10-15 00:00:00 | 1333.333333333333 | 5500 | 0
2008-10-30 00:00:00 |  |  |  |  | 2008-10-30 00:00:00 | 1333.333333333333 | 5500 | 0
2008-11-15 00:00:00 |  |  |  |  | 2008-11-15 00:00:00 | 533.3333333333334 | 2200 | 0
2008-11-30 00:00:00 |  |  |  |  | 2008-11-30 00:00:00 | 533.3333333333334 | 2200 | 0
2008-12-15 00:00:00 |  |  |  |  | 2008-12-15 00:00:00
2008-12-30 00:00:00 |  |  |  |  | 2008-12-30 00:00:00
Spreadsheet: 0453a7b1-70f2-41f6-bb59-e78a58270c3e
Sheet: Forward Reserve

Reserve Asset Detail Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reserve Asset Detail Report
SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  |  | Asset |  |  |  | Ten-Minute Non-Spin Reserve |  |  |  |  |  |  |  | Thirty-Minute Non-Spin Reserve
Trading Interval | Reserve Zone ID | Reserve Zone Name | Asset ID | Asset Name | Asset Type | Ownership Share | Forward Reserve TMNSR Available MWs | Forward Reserve TMNSR Assigned MWs | Asset Forward Reserve TMNSR Delivered MWs | Forward Reserve TMNSR Energy Obligation Credit MWs | Asset TMNSR Failure-to-Reserve Penalty Exempt MWs | Participant Share Asset Forward Reserve TMNSR Delivered MWs | Participant Share of Forward Reserve TMNSR Energy Obligation Credit MWs | Participant Share Asset TMNSR Failure-to-Reserve Penalty Exempt MWs | Forward Reserve TMOR Available MWs | Forward Reserve TMOR Assigned MWs | Asset Forward Reserve TMOR Delivered MWs | Forward Reserve TMOR Energy Obligation Credit MWs | Asset TMOR Failure-to-Reserve Penalty Exempt MWs | Participant Share Asset Forward Reserve TMOR Delivered MWs | Participant Share of Forward Reserve TMOR Energy Obligation Credit MWs | Participant Share Asset TMOR Failure-to-Reserve Penalty Exempt MWs | Forward TMNSR Obligation Charge Limit MWs | Forward TMOR Obligation Charge Limit MWs | Forward TMNSR Obligation Charge MWs | Forward TMOR Obligation Charge MWs | Participant Share Forward TMNSR Obligation Charge MWs | Participant Share Forward TMOR Obligation Charge MWs
Hour End | Number | String | Number | String | String | % | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh
Spreadsheet: 1e7cbe1c-7f8d-4b0e-8fca-fab352f83fd9
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 26. Output of the Public administration and safety industries, group and class index numbers
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 Numbers ;  7712  Investigation and security services ; |  |  | Original | A2314256X | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 267241d1380025415-formula-to-colour-in-cells-depending-upon-the-relationship-of-2-other-cells-test-colour-formula
Sheet: Sheet1

Aim | Result | Target | [NAME] | [NAME] and individual cf for demo purposes |  |  | Should Be | Correct or not | Notes
Lower is better | 85 | 100 |  |  |  |  | Green |  | Original Formula
Lower is better | 102 | 100 |  |  |  |  | Amber |  | Original Formula
Lower is better | 111 | 100 |  |  |  |  | Red |  | Original Formula
Lower is better | 0.85 | 1 |  |  |  |  | Green |  | Original Formula
Lower is better | 1.02 | 1 |  |  |  |  | Amber |  | Original Formula
Lower is better | 1.12 | 1 |  |  |  |  | Red |  | Original Formula
Higher is Better | 85 | 100 |  |  |  |  | Red |  | I have reversed the formula as the aim is different
Higher is Better | 92 | 100 |  |  |  |  | Amber |  | I have reversed the formula as the aim is different
Higher is Better | 102 | 100 |  |  |  |  | Green |  | I have reversed the formula as the aim is different
Higher is Better | 0.85 | 1 |  |  |  |  | Red |  | I have reversed the formula as the aim is different
Higher is Better | 0.92 | 1 |  |  |  |  | Amber |  | I have reversed the formula as the aim is different
Higher is Better | 1.02 | 1 |  |  |  |  | Green |  | I have reversed the formula as the aim is different
 | ^
 | cf applied to values
Spreadsheet: 47000d1245922582-month-between-two-months-libro2
Sheet: Hoja1

 | First Month In Period |  |  |  |  |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | 6 | 12 | [NAME]
 | Last Month In Period |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 11 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | LastMonthInPeriodA
 | Month to be evaluated |  |  |  |  |  | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | LastMonthInPeriodInflationRevenuesA
Spreadsheet: 831614d1685772970-getting-minimum-value-from-b-column-each-at-column-c-minimum-value
Sheet: Sheet1

 |  | Expected
 | Data | Minimum Value
 | B-14 | 14
 | Bh-66/67/90 | 66
 | S-33 /34 | 33
 | A-91 /92/109 | 91
 | A-105 /106/107 | 105
 | [NAME] /123/186 | 122
 | M-192 /189 | 189
 | M-44 | 44
 | P-63 /64 | 63
 | Ma-143 /144/152/153 | 143
 | F-143 /137/140 | 137
 | Ch-160 /145 | 145
 | M-97 | 97
Spreadsheet: 213738d1360625557-count-if-the-data-mathces-advise-1-
Sheet: template

Building 1.1.2
 |  |  |  | Black | [NAME] | Magenta | Yellow | Printer Model
 |  |  |  |  |  |  | yes | [NAME]
 |  |  |  |  |  | yes |  | x543
 |  |  |  |  |  | yes | yes | x940
 |  |  |  |  |  | yes | yes | x543
 |  |  |  | 1 |  |  | yes | c5045
 |  |  |  |  |  |  |  | Total
 | Total Send to female IT
 | Total Received from female IT
 |  | DAY SUMMARY
 |  | TOTAL TONERS BEING SENT
 |  | MF8330 |  | X543 |  | c5045 |  | x940
 | Black
 | [NAME]
 | Magenta
 | Yellow
 |  |  | formulas above(yellow color)..
Spreadsheet: 159671d1338813259-designing-a-slot-machine-video-game-working-on-the-reels-probability-book2
Sheet: Sheet1

 | Tile ID | Tile Type | Number of tiles | Lookup Table
 | 1 |  | 10 | 1-10
 | 2 |  | 1 | 11-11
 | 3 |  | 5 | 12-16
 | 4 |  | 1 | 17-17
 | 5 |  | 10 | 18-27
 | 6 |  | 1 | 28-28
 | 7 |  | 1 | 29-29
 | 8 |  | 1 | 30-30
 | 9 |  | 1 | 31-31
 | 10 |  | 1 | 32-32
 | 11 |  | 1 | 33-33
 | 12 |  | 1 | 34-34
 | 13 |  | 1 | 35-35
 | 14 |  | 1 | 36-36
 | 15 |  | 1 | 37-37
 | TOTAL |  | 37
Spreadsheet: 737618d1624521607-required-only-filtered-data-which-are-out-but-not-recd-back-summary
Sheet: Result Sheet

 | product code | detail 1 | detail 2 | detail 3 | detial 4
5 |  | sent |  | kk547 | [NAME]
6 |  | sent |  | kk547 | flip
9 |  | Sent |  | kk547 | mark
11 |  | Sent |  | kk548 | mark
Spreadsheet: 771670d1646784539-want-to-get-the-results-of-mavb-for-invoices-and-counts-and-sorted-smallest-to-largest-export-detail-ms-test-kisiji-
Sheet: ITEMS

ITM Code # | ITEM DISCRIPTIONS | UOM
SS | SPORTS SHIRTS | PCS
SW | SPORTSWEAR SHIRTS AND [NAME] | PCS
SM | SPORTS MASKS | PCS
HTK | HALF TANG KNIFE | PCS
HS | HOCKEY SHIRTS | PCS
HSO | HOCKEY SOCKS | PCS
SSO | SPORTS SOCKS | PCS
SHW | SPORTS HAND WRAPS | PCS
HH | HOODIES | PCS
SG | SPORTS GLOVES | PCS
Spreadsheet: 846032d1697326411-count-distinct-filtered-data-by-month-filtered-data-count-by-month-sample
Sheet: Sheet1

 | DATA |  |  |  |  |  |  |  |  | Total distinct Invoice numbers |  | <-- I'm able to calculate this number, but I can't calculate it by month.
 | Date | Type | Invoice # | Memo/Description | Qty | Price | Amount | Charge
 | 2021-01-07 00:00:00 | Invoice | 2109 | Test 1 | 1 | 100 |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | 2021-01-13 00:00:00 | Invoice | 2111 | Test 2 | 1 | 200 |  |  |  | Monthly distinct invoice numbers | 3 | 2
 | 2021-01-14 00:00:00 | Invoice | 2113 | Test 3 | 1 | 300 | -100
 | 2021-01-14 00:00:00 | Invoice | 2112 | Test 4 | 1 | 400
 | 2021-01-19 00:00:00 | Invoice | 2117 | Sample 1 | 1 | 500
 | 2021-01-26 00:00:00 | Invoice | 2117 | Sample 2 | 1 | 600
 | 2021-01-26 00:00:00 | Invoice | 2118 | Test 5 | 1 | 700
 | 2021-02-19 00:00:00 | Invoice | 2119 | Sample 1 | 1 | 500
 | 2021-02-26 00:00:00 | Invoice | 2120 | Sample 2 | 1 | 600
 | 2021-02-26 00:00:00 | Invoice | 2121 | Test 5 | 1 | 700
Spreadsheet: 45851d1244639793-ranking-formula-rank2
Sheet: Sheet1

Area | Div | Index | National Rank | Area Rank | Division Rank | correct Div Rank
1000000 | 1105100 | 0.8292682926829269 | 121 | 21 | 1 | 1
1000000 | 1105100 | 0.8292682926829269 | 121 | 21 | 1 | 1
1000000 | 1105100 | 0.6756756756756757 | 173 | 29 | 3 | 3
1000000 | 1105100 | 0.4146341463414634 | 186 | 35 | 4 | 4
1000000 | 1105100 | 0.3779527559055118 | 205 | 44 | 5 | 5
1000000 | 1105100 | 0 | 222 | 45 | 6 | 6
1000000 | 1105100 | 0 | 222 | 45 | 6 | 6
1000000 | 1105100 | 0 | 222 | 45 | 6 | 6
1000000 | 1105100 | 0 | 222 | 45 | 6 | 6
1000000 | 1205100 | 3.317073170731708 | 1 | n/a | n/a | n/a
1000000 | 1205100 | 2.48780487804878 | 4 | 1 | n/a | n/a
1000000 | 1205100 | 2.073170731707317 | 13 | 2 | 3 | 1
1000000 | 1205100 | 1.351351351351351 | 69 | 11 | 4 | 2
1000000 | 1205100 | 1.133858267716535 | 96 | 20 | 5 | 3
1000000 | 1205100 | 0.8292682926829269 | 121 | 21 | 6 | 4
1000000 | 1205100 | 0.8292682926829269 | 121 | 21 | 6 | 4
1000000 | 1205100 | 0.4146341463414634 | 186 | 35 | 8 | 6
1000000 | 1205100 | 0.4146341463414634 | 186 | 35 | 8 | 6
1000000 | 1205100 | 0.4032258064516129 | 199 | 41 | 10 | 8
Spreadsheet: 129073d1321438786-change-color-of-line-in-line-graph-801582
Sheet: Sheet1

 | X Dash | Y Dash | Z Dash | X Solid | Y Solid | Z Solid
A | 1 | 4 | 2 |  | 4
B | 2 | 5 | 3 | 2 | 5 | 3 |  |  | I want to make a line graph in Excel 2003. I have three categories on the x-axis (say A,B,C). Y-axis has the values 1, 2, 3 for line [NAME], 5, 6 for line Y and 2, 3, 4 for line Z.
C | 3 | 6 | 4 | 3 |  | 4
 |  |  |  |  |  |  |  |  | Now I want the line X to change color or become dashed (or similar) between B and C.
 |  |  |  |  |  |  |  |  | Y to change color/dashed between A and B.
 |  |  |  |  |  |  |  |  | Z to change color/dashed between B and C.
Spreadsheet: larry_may__21613__EES NN-Demarc
Sheet: Sheet1

 | Northern Natural @ Demarc |  |  | Enron Energy Services
 | 2001-11-01 00:00:00 | 1500
 | 2001-12-01 00:00:00 | 1850
 | 2002-01-01 00:00:00 | 2250 |  | [NAME], per our conversation these are
 | 2002-02-01 00:00:00 | 1975 |  | the daily volumes by month.
 | 2002-03-01 00:00:00 | 1525
 | 2002-04-01 00:00:00 | 1275 |  | ENA Sells [NAME] (Offered + $.05)
 | 2002-05-01 00:00:00 | 875 |  | ENA Sells 20% daily FOM Index Call
 | 2002-06-01 00:00:00 | 800 |  | ENA Sells 20% daily FOM Index Put
 | 2002-07-01 00:00:00 | 650
 | 2002-08-01 00:00:00 | 575 |  | Thanks,
 | 2002-09-01 00:00:00 | 600 |  | [NAME] x 31505
 | 2002-10-01 00:00:00 | 675
 | 2002-11-01 00:00:00 | 800
 | 2002-12-01 00:00:00 | 900
 | 2003-01-01 00:00:00 | 1050
 | 2003-02-01 00:00:00 | 975
 | 2003-03-01 00:00:00 | 775
 | 2003-04-01 00:00:00 | 775
 | 2003-05-01 00:00:00 | 625
 | 2003-06-01 00:00:00 | 600
 | 2003-07-01 00:00:00 | 600
 | 2003-08-01 00:00:00 | 550
 | 2003-09-01 00:00:00 | 550
 | 2003-10-01 00:00:00 | 600
 | 2003-11-01 00:00:00 | 750
 | 2003-12-01 00:00:00 | 850
 | 2004-01-01 00:00:00 | 950
 | 2004-02-01 00:00:00 | 950
 | 2004-03-01 00:00:00 | 725
Spreadsheet: 750869d1633702082-transposing-a-vertical-list-automatically-after-pasting-it-in-a-column-aggregate-test-again
Sheet: boosterSort

THIS IA BUNCH OF HEADER TEXT PULLED FROM AN IMAGE THAT SHOULD BE IGNORED |  | LAST NAME: | FIRST NAME: | MIDDLE INITIAL: | EMAIL: | CONTACT NUMBER: | BASE: | DATE OF HIRE (mm/dd/yyyy): | Indicate [NAME]Äúmedical‚Äù or [NAME]Äúreligious‚Äù concern:
LAST NAME: | solo
FIRST NAME: | han
MIDDLE INITIAL:
EMAIL: | [EMAIL]
CONTACT NUMBER: | [PHONE]
BASE: | COR
DATE OF HIRE (mm/dd/yyyy): | 2005-01-01 00:00:00
MEDICAL or RELIGIOUS or BOTH: | Both
THIS IA BUNCH OF HEADER TEXT PULLED FROM AN IMAGE THAT SHOULD BE IGNORED
LAST NAME: | solo
FIRST NAME: | han
MIDDLE INITIAL:
EMAIL: | [EMAIL]
CONTACT NUMBER: | [PHONE]
BASE: | COR
DATE OF HIRE (mm/dd/yyyy): | 2005-01-01 00:00:00
MEDICAL or RELIGIOUS or BOTH: | Both
THIS IA BUNCH OF HEADER TEXT PULLED FROM AN IMAGE THAT SHOULD BE IGNORED
LAST NAME: | solo
FIRST NAME: | han
MIDDLE INITIAL:
EMAIL: | [EMAIL]
CONTACT NUMBER: | [PHONE]
BASE: | COR
DATE OF HIRE (mm/dd/yyyy): | 38353
MEDICAL or RELIGIOUS or BOTH: | Both
THIS IA BUNCH OF HEADER TEXT PULLED FROM AN IMAGE THAT SHOULD BE IGNORED
LAST NAME: | solo
FIRST NAME: | han
MIDDLE INITIAL:
EMAIL: | [EMAIL]
CONTACT NUMBER: | [PHONE]
BASE: | COR
DATE OF HIRE (mm/dd/yyyy): | 38353
MEDICAL or RELIGIOUS or BOTH: | Both
Spreadsheet: 0300ca26-081e-465a-845f-d500df3799d0
Sheet: Sheet1

PAY RECORD | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
ME FORM II
Name |  |  |  | Training Station |  |  |  | Semester
I get paid: |  | Monthly |  | Bi/Monthly |  | Weekly |  | Biweekly |  | Daily
PAY PERIOD |  | HOURLY | HOURS | TOTAL HRS | GROSS | GROSS PAY | DEDUCTIONS |  |  | NET PAY | TOTAL NET
FROM | TO | RATE | WORKED | WORKED | PAY | TO DATE |  |  |  | (TAKE HOME) | TO DATE
Spreadsheet: 123416d1317654237-format-a-column-with-two-different-formats-based-on-value-in-another-col-format_column_with_two_formats
Sheet: Sheet1

Study Number | Calc1 | [NAME] | Calc3 | Calc4
1 |  |  | 0
2 | 0 | 0 | 64
3 | 0.4 | 115.2 | 0
4 |  |  | 0
5 |  |  | 65 |  | for example:  if Calc1 is empty I want E6 to show 65 Qry
6 |  |  | 0
7 |  |  | 17
8 |  |  | 54
9 |  |  | 8
10 |  |  | 4
11 | 0 | 0 | 22
12 | 0.1 | 28.8 | 3 |  | If Calc1 has a value then I want to show the value as a % as is shown here.
13 |  |  | 7
14 |  |  | 16
15 | 0 | 0 | 42
16 | 0.75 | 216 | 2
17 |  |  | 81
18 |  |  | 16
19 |  |  | 2
20 |  |  | 1821
21 |  |  | 2
22 |  |  | 23
23 |  |  | 19
24 |  |  | 0
25 |  |  | 134
26 |  |  | 160
27 |  |  | 74
28 |  |  | 268
29 |  |  | 16
30 |  |  | 20
31 | 0.46 | 132.48 | 16
32 | 0.9 | 259.2 | 0
33 |  |  | 211
34 |  |  | 472
35 | 0.6 | 172.8 | 5
36 |  |  | 47
37 |  |  | 1141
38 | 0.46 | 132.48 | 42
39 |  |  | 10
40 |  |  | 1
41 | 0 | 0 | 16
42 | 0 | 0 | 2
43 |  |  | 5
44 |  |  | 0
45 | 0.46 | 132.48 | 11
46 |  |  | 2
47 |  |  | 442
48 |  |  | 4
49 |  |  | 6
50 | 0 | 0 | 74
51 |  |  | 54
52 | 0.2 | 57.6 | 8
53 |  |  | 76
54 | 0.68 | 195.84 | 255
55 | 0.5 | 144 | 0
56 | 1.05 | 302.4 | 280
57 |  |  | 27
58 | 1.8 | 518.4 | 740
59 |  |  | 348
60 |  |  | 0
61 |  |  | 19809
62 | 0.3 | 86.39999999999999 | 101
63 |  |  | 0
64 |  |  | 0
65 |  |  | 0
66 |  |  | 130
67 |  |  | 113
68 |  |  | 47
69 |  |  | 96
70 |  |  | 418
71 |  |  | 89
72 |  |  | 2123
73 |  |  | 0
74 |  |  | 20
75 |  |  | 2
76 |  |  | 118
77 |  |  | 117
78 |  |  | 81
79 |  |  | 0
80 |  |  | 250
81 |  |  | 102
82 |  |  | 7
83 |  |  | 70
84 |  |  | 725
85 | 0.55 | 158.4 | 53
86 |  |  | 7
87 |  |  | 12
88 |  |  | 14
89 |  |  | 237
90 |  |  | 39
91 |  |  | 28
92 |  |  | 40
93 |  |  | 35
94 |  |  | 6
95 |  |  | 305
96 |  |  | 27
97 | 0.5 | 144 | 239
98 |  |  | 52
99 |  |  | 7
100 |  |  | 5
101 |  |  | 3
Spreadsheet: 226001d1365198147-how-to-use-the-name-of-a-cell-to-reference-a-sheet-with-the-same-name-price-metrics_etaf
Sheet: AGNC

Ticker | agnc us equity
Company
Start Date | 20061231
End Date | 20141231
Periodicity | A
Currency | USD
Filing Status Mnemonic | MR
Filing | Most Recent
Units | MLN
 |  | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | FY 2012
For the period ending |  | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00
Price to Book Ratio | PX_TO_BOOK_RATIO | #N/A N/A | #N/A N/A | #N/A N/A | 1.1805 | 1.1857 | 1.0133 | 0.913
Price [NAME] (P/E) | PE_RATIO | #N/A N/A | #N/A N/A | 9.0508 | 3.9145 | 3.6426 | 5.5936 | 6.9305
Price to Sales Ratio | PX_TO_SALES_RATIO | #N/A N/A | #N/A N/A | 5.812 | 2.676 | 2.7357 | 3.793 | 4.4993
Price/Cashflow | PX_TO_CASH_FLOW | #N/A N/A | #N/A N/A | #N/A N/A | 4.9838 | 4.5056 | 4.238 | 4.3
Price/EBITDA | PX_TO_EBITDA | #N/A N/A | #N/A N/A | #N/A N/A | 2.8596 | 2.8768 | 4.0573 | #N/A N/A
Total Liabilities | [NAME] | #N/A N/A | #N/A N/A | #N/A N/A | 4078.862 | 12903.765 | 51760.494 | 89558
Last Price | PX_LAST | #N/A N/A | #N/A N/A | 21.36 | 26.54 | 28.74 | 28.08 | 28.9
Debt/Price |  | #[NAME]! | #[NAME]! | #[NAME]! | 153.6873398643557 | 448.9827766179541 | 1843.322435897436 | 3098.892733564014
Assets | BS_TOT_ASSET | #N/A N/A | #N/A N/A | #N/A N/A | 4625.684 | 14475.829 | 57972.297 | 100453
Assets/Price |  | #[NAME]! | #[NAME]! | #[NAME]! | 174.2910324039186 | 503.6822894919972 | 2064.540491452991 | 3475.882352941177
Cur EV/T12EBITDA | CURRENT_EV_TO_T12M_EBITDA | #N/A N/A | #N/A N/A | #N/A N/A | 26.3687 | 37.5061 | 50.4694 | 53.8731
EV To Trailing 12M Sales | CURRENT_EV_TO_12M_SALES | #N/A N/A | #N/A N/A | #N/A N/A | 24.6762 | 35.6664 | 47.1814 | 42.5329
Spreadsheet: 486651d1477592683-create-tabs-from-list-add-data-to-worksheet-sample-evals
Sheet: Employee 2

Quarterly Evaluation
Category | Description | Weight | Employee 2
1 | Details 1 Details 2 | 0.25 | 5
2 | Details 3 Details 4 | 0.3 | 5
3 | More info here Random Thought | 0.3 | 5
4 | [NAME] again Different thought | 0.15 | 5
Weighted Average
Bonus Amt
Bonus Ranges
Min | [NAME] | $
0 | 2.9 | 0
3 | 3.2 | 80
3.3 | 3.5 | 100
3.6 | 3.8 | 120
3.9 | 4.1 | 140
4.2 | 4.4 | 160
4.5 | 4.7 | 180
4.8 | 5 | 200