tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859374d1707775547-excel-xlookup-for-multiple-criteria-xlookup_example_2-12
Sheet: Plan

Year | Category | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2022 | Category 1 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
2022 | Category 2 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
2022 | Category 3 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
2022 | Category 4 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
2022 | Category 5 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
2022 | Category 6 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
2022 | Category 7 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
2022 | Category 8 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
2023 | Category 1 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
2023 | Category 2 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
2023 | Category 3 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
2023 | Category 4 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
2023 | Category 5 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
2023 | Category 6 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
2023 | Category 7 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
2023 | Category 8 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
2024 | Category 1 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
2024 | Category 2 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
2024 | Category 3 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
2024 | Category 4 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
2024 | Category 5 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
2024 | Category 6 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
2024 | Category 7 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
2024 | Category 8 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
 |  | `
Spreadsheet: 217820d1362209883-match-and-sum-with-date-range-neagtive-values-find-20and-20sum-20shafiqe-20-oeldere3-1-
Sheet: 1

 |  |  | Date Range |  | Source |  | Date Date | A | B | C |  | Kgs
 |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 | A |  | 2013-02-02 00:00:00 | 0.03 | 0.04 |  |  | 100
 |  |  | 2013-03-01 00:00:00 | 2013-04-15 00:00:00 | B |  | 2013-02-03 00:00:00 | 0.03 | 0.02 |  |  | 100
 |  |  | 2013-04-15 00:00:00 | 2013-04-25 00:00:00 | C |  | 2013-02-03 00:00:00 | 0.03 | 0.04 |  |  | 100
 |  |  | 2013-01-01 00:00:00 | 2013-01-12 00:00:00 | A |  | 2013-01-01 00:00:00 | 0.03 | 0.04 |  |  | 100
Description |  |  | Data Date |  | Source |  |  |  |  |  |  | Kg
Sumif for this date range if negative % column K and source is A |  |  | 2013-02-12 00:00:00 |  | A |  |  |  |  |  |  |  | Result
Sumif for this date range if negative % column K and source is B |  |  | 2013-04-13 00:00:00 |  | B |  |  |  |  |  |  | 0 | Result
Sumif for this date range if negative % column K and source is C |  |  | 2013-04-23 00:00:00 |  | C |  |  |  |  |  |  |  | Result
Sumif for this date range if negative % column K and source is A |  |  | 2013-01-05 00:00:00 |  | A |  |  |  |  |  |  |  | Result
Spreadsheet: 95297d1294919588-how-to-create-simple-graphic-chartexample
Sheet: Sheet1

 | Date | Profit/Loss | Target
 | 2011-01-13 00:00:00 | 2500 | 1000
 | 2011-01-20 00:00:00 | -50 | 1000
 | 2011-01-27 00:00:00 | 2200 | 1000
 | 2011-02-03 00:00:00 | -100 | 1000
 | 2011-02-10 00:00:00 | 1400 | 1000
 | 2011-02-17 00:00:00 | -150 | 1000
 | 2011-02-24 00:00:00 | 500 | 1000
 | 2011-03-03 00:00:00 | -150 | 1000
 | 2011-03-10 00:00:00 | 500 | 1000
 | 2011-03-17 00:00:00 | 0 | 1000
 | 2011-03-24 00:00:00 | 100 | 1000
 | 2011-03-31 00:00:00 | 700 | 1000
Spreadsheet: 139775d1328461858-copying-data-from-one-source-to-a-blank-page-ina-given-period-ssp-mst-maintenance-mahju
Sheet: MST-Amend

NSD | Equipment | Task No | Comp Code | Mod Code | Job Desc Code | MST Desc 1 | MST Desc 2 | [NAME] | Unit Required | Unit of Work | MST Type | Sched Ind | Work Group | Std Job No | LPD | LSD | NSD | Segment From | Segment To | Segment UOM | Assign To
1 | [NAME] | 0 | 0 | 0 | 0 | LOW VOLTAGE AC INSTALLATION F EXAM | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 10133 | 0 | 40414 | 40778 | 0 | 0 | 0 | 0
2 | MNT00002 | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 40385 | 40749 | 0 | 0 | 0 | 0
3 | [NAME] | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 40385 | 40749 | 0 | 0 | 0 | 0
4 | MNT00004 | 0 | 0 | 0 | 0 | LV TRANSFORMER E EXAM | 0 | 182 | 1 | EA | 1 | 1 | DFPPREA | 10194 | 0 | 0 | 40778 | 0 | 0 | 0 | 0
5 | MNT00004 | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 0 | 40778 | 0 | 0 | 0 | 0
6 | MNT00007 | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 0 | 40775 | 0 | 0 | 0 | 0
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Spreadsheet: 110634d1307255897-excel-2007-click-one-cell-will-generate-result-name-problem-test
Sheet: JUNE' 11

 | LYCAN | VESSEL | A1 | A1 | A1 | A1 | A1 | A1 | AGENT | REMARK | CONTRACT |  | SOLD TO | PRODUCT | [NAME] | PRICE
 | 01-07 | CRUISE 1 |  |  |  |  |  |  | LILY |  | CLICK TO VIEW
 | 01-07 | CRUISE 2 |  |  |  |  |  |  | [NAME] |  | CLICK TO VIEW
 | 04-10 | CRUISE 1 |  |  |  |  |  |  | [NAME] |  | CLICK TO VIEW
 | 04-10 | CRUISE 4 |  |  |  |  |  |  | [NAME] |  | CLICK TO VIEW
 | 04-10 | CRUISE 9 |  |  |  |  |  |  | [NAME] |  | CLICK TO VIEW
 | 05-11 | CRUISE 2 |  |  |  |  |  |  | [NAME] |  | CLICK TO VIEW
 | 08-15 | CRUISE 1 |  |  |  |  |  |  | [NAME] |  | CLICK TO VIEW
 | 08-15 | CRUISE 8 |  |  |  |  |  |  | LILY |  | CLICK TO VIEW
 | 10-16 | CRUISE 7 |  |  |  |  |  |  | SMITH |  | CLICK TO VIEW
 | 13-19 | CRUISE 5 |  |  |  |  |  |  | KOEI |  | CLICK TO VIEW
Spreadsheet: 845895d1697205080-pulling-specific-customer-data-froma-lookup-sheet-into-another-sheet-how-to-excel-book-1-
Sheet: RESULT SHEET

 | HOW TO LOOK UP DATA IN BELOW COLUMNS FROM DATA SHEET
 |  | A/C TITLE | A/C NUMBER | AMOUNT USD |  |  | SECURITY CODE | MATURITY DATE | ISSUE DATE
 | DEBIT | SETTLE A/C USD CERTIFICATES | [PHONE]
 |  | CUSTOMER NAME | CUSTOMER A/C # | AMOUNT TO BE CREDITED
1 | CREDIT |  |  |  |  |  | 371200-865
 | CREDIT |  |  |  |  |  | 371200-857
 | CREDIT |  |  |  |  |  | 371200-857
 | CREDIT |  |  |  |  |  | 372200-767
 | CREDIT |  |  |  |  |  | 373100-582
 |  | I need [NAME] or atleast some alternate to lookup Customer Name, Customer A/c # and Amount of Profit to be paid them. I have used INDEX function in this function I have to change row reference for each record instead of auto pulling record.
Spreadsheet: 770833d1646297090-excel-2016-textjoin-emails-from-different-rows-into-one-cell-depending-on-their-group-lookup_issue_forum
Sheet: A

ID | First Name | Last Name | Org | Group Name | email | helper
Ab45 | Sue | Langdon | 12300 | Apple | [EMAIL]
Ab46 | Cameron | [NAME] | 12300 | Apple | [EMAIL]
Ab47 | [NAME] | [NAME] | 12300 | Apple | [EMAIL]
Ab48 | [NAME] | Young | 12300 | Apple | [EMAIL]
Ab49 | [NAME] | [NAME] | 12300 | Apple | [EMAIL]
Ab50 | Lauren | Hill | 12300 | Apple | [EMAIL]
Ab51 | Faith | Hudson | 12300 | Apple | [EMAIL]
Ab52 | [NAME] | [NAME] | 15000 | Orange | [EMAIL]
Ab53 | [NAME] | Morgan | 15000 | Orange | [EMAIL]
Ab54 | [NAME] | Hodges | 15000 | Orange | [EMAIL]
Ab55 | Jan | [NAME] | 15000 | Orange | [EMAIL]
Ab56 | [NAME] | Nash | 15000 | Orange | [EMAIL]
Ab57 | Kimberly | Black | 15000 | Orange | [EMAIL]
Ab58 | Virginia | King | 15000 | Orange | [EMAIL]
Ab59 | [NAME] | [NAME] | 15000 | Orange | [EMAIL]
Ab60 | [NAME] | [NAME] | 15000 | Orange | [EMAIL]
Ab61 | [NAME] | Short | 15000 | Orange | [EMAIL]
Ab62 | Jessica | Morrison | 15000 | Orange | [EMAIL]
Ab63 | Dominic | Mackenzie | 7600 | Pear | [EMAIL]
Ab64 | [NAME] | Hodges | 7600 | Pear | [EMAIL]
Ab65 | Emma | [NAME] | 7600 | Pear | [EMAIL]
Ab66 | Molly | [NAME] | 7600 | Pear | [EMAIL]
Ab67 | Jessica | [NAME] | 7600 | Pear | [EMAIL]
Ab68 | [NAME] | May | 7600 | Pear | [EMAIL]
Ab69 | [NAME] | Pullman | 7600 | Pear | [EMAIL]
Spreadsheet: 826375d1681976946-unique-id-based-on-dropdown-menue-testworkbook-uniqueid
Sheet: Issue

Issue ID | Category |  | Ideal result
 | Manufacture |  | Man001
 | PM |  | PM001
 | PM |  | PM002
 | Client |  | Cli001
 | Client |  | Cli002
 | Client |  | Cli003
 | Manufacture |  | Man002
 | PM |  | PM003
 | PM |  | PM004
 | Client |  | Cli004
 | Client |  | Cli005
 | Client |  | Cli006
 | Manufacture |  | Man003
 | PM |  | [NAME]
 | PM |  | PM006
 | Client |  | Cli007
 | Client |  | Cli008
 | Client |  | Cli009
 | Manufacture |  | Man004
 | PM |  | PM007
 | PM |  | PM008
 | Client |  | Cli010
 | Client |  | Cli011
 | Client |  | Cli012
 | Manufacture |  | Man005
 | PM |  | PM009
 | PM |  | PM010
 | Client |  | Cli013
 | Client |  | Cli014
Spreadsheet: 683718d1592912546-hide-unhide-columns-based-on-a-dropdown-list-or-tick-list-if-its-possible-ratings-and-privileges-test
Sheet: Full & PT time FI(A) 1

Teams | General requirements aviation personnel | Profile picture | Emergency contact information | ID card | Copy of passport | Certificate: FE(A) | Certificate: FI(A) | Certificate: FI(A) Unrestricted | Certificate: FI(A)FI | Certificate: FI(A)IR | Certificate: FI(A)ME | Certificate: FIE(A) | Certificate: IRE(A) | Certificate: MCCI(A) | Certificate: Medical class 1 | Examiner: Language proficiency assessor | Examiner: Senior examiner | Licence endorsement: FI(A) night proficiency | Licence endorsement: MEP(land) DA42 NG | Licence endorsement: PBN | Licence endorsement: SEP(land) EFIS | Licence endorsement: SEP(land) [NAME] | Licence: CPL(A) or ATPL(A) | PFA aircraft - DA40NG DI approval | PFA aircraft - DA40NG PIC approval | PFA aircraft - DA42NG DI approval | PFA aircraft - DA42NG PIC approval | PFA CCF - aircraft | PFA CCF - simulator | PFA endorsement - icing | PFA endorsement - IFR SPIC | PFA endorsement - VFR night | PFA initial training program - flight examiner | PFA initial training program - flight instructor | PFA progress check 1-7 approval | PFA progress check 2-7 approval | PFA progress check 3-6 approval | PFA progress check 4-11 approval | PFA progress check 4-23 approval | PFA progress check 4-29 approval | PFA progress check 4-44 approval | PFA simulator - B737 approval | PFA simulator - DA42 approval | PFA standardisation meeting - FI | PFA standardisation meeting - MCCI | PFA supervision - FI | PFA supervision - MCCI | Rating                  (language proficiency):           English min. level 4 | Rating (class/type):  B737 300-900 | Rating (class/type): MEP(land) | Rating (class/type): SEP(land) | Rating (instrument): IR(A)ME | Rating (instrument): IR(A)SE
1A
1A
1A
1A
1A
1A
1A
1A
1A
1A
1A
1B
1B
1B
1B
1B
1B
1B
1B
1B
1B
1B
2A
2A
2A
2A
2A
2A
2A
2A
2A
2B
2B
2B
2B
2B
2B
2B
2B
2B
Other
Other
Other
Other
Other
Other
Other
Other
Other
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
PT
TI
TI
TI
TI
TN
Spreadsheet: 771125d1646422943-highest-mortgage-i-can-afford-mortgage-example
Sheet: Adjustable - From Overview

Gross Income Information | Monthly | Yearly |  | [NAME] | TDS Ratio | TPCU Max (35%) |  | [NAME] | TDS Ratio | TPCU Max (35%)
Income |  | 80000
Income |  | 80000
Income 2 |  | 0 |  | Pre Approval Information | Monthly | Yearly |  | Mortgage Information | Monthly | Yearly
Income 2 |  | 0 |  | Purchase Price | 892000 |  |  | Purchase Price
Parent Income |  | 0 |  | Down Payment | 250000 |  |  | Down Payment
Parent Income |  | 0 |  | Principal |  |  |  | Principal
Unit #1 Rental Income | 0 |  |  | Amortization | 30 |  |  | Amortization | 30
Unit #2 Rental Income | 0 |  |  | Total Payments |  |  |  | Total Payments
Total
 |  |  |  | Stress Test Rate | 0.0525 |  |  | Stress Test Rate | 0.0265
Expense Information | Monthly | Yearly |  | Total Costs |  |  |  | Total Costs
Property Taxes | 292
Heating | 125
[NAME] | 250 |  |  | [NAME]
Total Taxes and Fees
[NAME] | 1000
Angelique Expenses
Total Expenses
Total Expenses Taxes and Fees
Spreadsheet: 171455d1343738470-vba-vlookup-compare-three-columns-book3
Sheet: Sheet1

100000313 | NORDIC CHARGE | Service Charge IS Management
100000313 | NORDIC CHARGE | Nordic Service Charges NO31
100000627 | NORDIC CHARGE | Service Charge IS Management
100000627 | NORDIC CHARGE | Nordic Service Charges NO31
100001227 | NORDIC CHARGE | Service Charge IS Management
100001227 | NORDIC CHARGE | Nordic Service Charges NO31
100001988 | NORDIC CHARGE | Service Charge IS Management
100001988 | NORDIC CHARGE | Nordic Service Charges NO31
100002607 | NORDIC CHARGE | Service Charge IS Management
100002607 | NORDIC CHARGE | Nordic Service Charges NO31
Spreadsheet: richard_sanders__31749__Ecogas Legal Bills 8-17-00
Sheet: Aged AP - Legal

Aged [NAME]
 |  | Days Past Due
Ecogas Corporation
[NAME] | Current | 1 To 30 | 31 To 60 | 61 To 90 | Over 90 | Balance
Andrews & Kurth LLP | 0 | 0 | 0 | 0 | 2227.5
Bracewell & Patterson |  | 150287.73 | 0 | 192550.85 | 78663.81
Conley Rose & Tayon | 0 | 1686.58 | 0 | 772.08 | 2002.28
[NAME] Tremaine LLP | 0 | 0 | 0 | 0 | 1482.5
Fulbright & Jaworski LLP | 0 | 31073.37 | 15555.97 | 16540.03 | 0
Locke Liddell & Sapp LLP | 40600.64 | 4556.35 | 87819.74 | 26522.98 | 185712.14 | 345211.85
[NAME], Sullivan, Ryan & Miller | 0 | 0 | 0 | 0 | 1408.1
Micheal Best & Friedrich LLP | 0 | 0 | 0 | 1290 | 0
Scott, Douglass & McConnico | 0 | 0 | 7115.22 | 0 | 0
[NAME] & Priest LLP | 0 | 0 | 97.09 | 7581.54 | 0
Vinson & Elkins | 0 | 36534.32 | 0 | 0 | 0
Ecogas Corp. Total
Spreadsheet: 118813d1314025709-use-value-in-one-cell-to-paste-a-corresponding-row-estimate-details
Sheet: C

[NAME] | Dsg | Mass | Ds_i | Dn_i | Wt_i
C: Channels |  | kg/m |  | in | lb/ft
* | C380x74 | 74 | C15x50 | 15 | 50
 | C380x60 | 60 | C15x40 | 15 | 40
 | C380x50 | 50 | C15x33.9 | 15 | 33.9
* | C310x45 | 45 | C12x30 | 12 | 30
 | C310x37 | 37 | C12x25 | 12 | 25
 | C310x31 | 31 | C12x20.7 | 12 | 20.7
* | C250x45 | 45 | C10x30 | 10 | 30
 | C250x37 | 37 | [NAME] | 10 | 25
 | C250x30 | 30 | C10x20 | 10 | 20
 | C250x23 | 23 | C10x15.3 | 10 | 15.3
* | C230x30 | 30 | C9x20 | 9 | 20
 | C230x22 | 22 | C9x15 | 9 | 15
 | C230x20 | 20 | C9x13.4 | 9 | 13.4
* | C200x28 | 28 | C8x18.75 | 8 | 18.75
 | C200x21 | 21 | C8x13.75 | 8 | 13.75
 | C200x17 | 17 | C8x11.5 | 8 | 11.5
* | C180x22 | 22 | C7x14.75 | 7 | 14.75
 | C180x18 | 18 | C7x12.25 | 7 | 12.25
 | C180x15 | 15 | C7x9.8 | 7 | 9.8
* | C150x19 | 19 | C6x13 | 6 | 13
 | C150x16 | 16 | C6x10.5 | 6 | 10.5
 | C150x12 | 12 | C6x8.2 | 6 | 8.2
* | [NAME] | 13 | C5x9 | 5 | 9
 | C130x10 | 10 | C5x6.7 | 5 | 6.7
* | C100x11 | 11 | C4x7.25 | 4 | 7.25
 | C100x9 | 9 | C4x6.25 | 4 | 6.25
 | C100x8 | 8 | C4x5.4 | 4 | 5.4
 | [NAME] | 7 | C4x4.5 | 4 | 4.5
* | C75x9 | 9 | C3x6 | 3 | 6
 | C75x7 | 7 | C3x5 | 3 | 5
 | [NAME] | 6 | C3x4.1 | 3 | 4.1
 | C75x5 | 5 | C3x3.5 | 3 | 3.5
Spreadsheet: 873661d1720174542-if-function-with-sumifs-if-statement-and-sumif
Sheet: Result

 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
Financial Year |  |  |  |  |  |  |  |  |  |  |  |  | Total
Cost 1
Cost 2
Cost 3
Cost 4
Cost 5
Cost 6
Cost 7
Cost 8
Cost 9
Total
Exepected Results
 | ACTUAL | ACTUAL | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | Total
Cost 1 | 10000 |  | 0 |  | 18000 |  | 25000 |  | 25000
Cost 2
Cost 3
Cost 4
Cost 5 |  | 28000 |  |  | 12000 |  |  | 63000
Cost 6
Cost 7
Cost 8
Cost 9
Total
HI team
Could someone please assist to help me pull through the actual or forecast for specific  month on my expected result-so at any time when the actual or forecast changes by moving the cell from the source data my result tab will update
On the if statement formular my value if criteria should only pick the sum of forecast for specific month if it is not actual.
Spreadsheet: 16e83a38-3ba3-43e3-9b8a-0eaeb2865beb
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0002052 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Golden Valley Plant | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Rutherford | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 12.25 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 57.2 |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 726585d1617303768-sumifs-issue-template-etaf
Sheet: TOTAL SUMMARY

Expense Category
Auto Gas
Groceries
Meals/Entertainment
[NAME]
Ofc Expense
Personal
Product/Supplies/Sales Tax
Spreadsheet: 771183d1646487230-count-unique-vehicle-registrations-that-visit-a-site-sample-data
Sheet: Sheet1

Employee | Resource clocked | Account | Type code | Allowed | Time taken | Rate ph | Ext price | Inv No | WIP No | Actual Date costed | RTS code | Serv code | Sale type | Fran | Job card No | Site | Reg No | Last Sales date | Reg Date | Description | Model code | SL Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GU21JXL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GU21JXL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GU21JXL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GX17MFK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GX17MFK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GX17MFK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | GX17MFK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GX17LYD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GX17LYD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GX17LYD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GX17LYD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GX17LYD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | GX17LYD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GU21JYR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | GU21JYR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GX17LXY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GX17LXY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GX17LXY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BN14JPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BN14JPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BN14JPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BN14JPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BN14JPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BN14JPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BN14JPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GV14AEK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GV14AEK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GV14AEK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GV14AEK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GV14AEK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | GV14AEK
Spreadsheet: 677341d1589310505-formula-to-duplicate-row-references-test
Sheet: Sheet4

Column1 | Column2 |  | 170040
Cat | 10 |  | 544110
Dog | 15 |  | 170040
Cow | 12 |  | 544110
 |  |  | 170040
 |  |  | 544110
Spreadsheet: 553242d1514061028-multiple-columns-info-transposed-in-multiple-rows-alexxl-sales-2
Sheet: Data to be transformed

[NAME] | Data borderou | Cod furnizor(ZW) | [NAME]) | Nr Comanda | Nume Client/pers fizica/firma | Localitate | [NAME] | Adresa | Telefon | Data Livrarii | [NAME] | Observatii | Nr bucati produs | Pret total | Valoare transport | TOTAL ramburs | Telefon statie
 |  |  | In this row I show you the collumns  origins of the data from sheet DATA |  | F | AQ | AP | AO | G | AR |  |  | I | vlokup on costs | BL | BM | BP
1206 | 23/12/2017 | 4011002724
1206 | 23/12/2017 | 4011002724
1206 | 23/12/2017 | 4011002724
1206 | 23/12/2017 | 4011002724
1206 | 23/12/2017 | 4011002724
 |  |  |  | KEY COLUMN | Calculated | Calculated | Calculated | Calculated | Calculated | Calculated | Calculated |  | Calculated | Calculated | Calculated | Calculated | Calculated
Spreadsheet: 98527d1297380762-group-function-sample-group
Sheet: Sheet1

 | 2010 |  |  |  |  |  |  |  |  |  |  |  | 2011
 | JAN | FEB | MAR | APR | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL | JAN | FEB | MAR | APR | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
Test1
Test2
Spreadsheet: 25374c05-7540-4714-ac4c-33f32908ece9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | City of Tempe
 |  |  |  |  |  |  | P.O. Box 5002
 |  |  |  |  |  |  | 31 East Fifth Street
 |  |  |  |  |  |  | Tempe, AZ  85280
 |  |  |  |  |  |  | Public Works/Engineering Division
 |  |  |  |  |  |  | [PHONE] (phone)
 |  |  |  |  |  |  | [PHONE] (fax)
Pay Period Beginning: |  |  |  | Ending: |  |  | Payment No:
Project Name: |  |  |  |  |  |  | Project No:
[NAME]: |  |  |  |  |  |  | Phone:
Address:
% Completed to Date: |  |  | % Total Time Elapsed: |  |  | Completion Date:
Original Contract Amount: |  |  |  |  |  | Encumbrance No:
Change Orders to Date:
Current Contract Amount: |  |  | 0
Work Completed to Date:
Materials Stored:
[NAME] Held: |  |  |  |  | [NAME] Held:
Total Earned, Less Retention: |  |  | 0 |  |  | Securities in Lieu of Retention:
Previous Payments: |  |  |  |  |  | Amount on Deposit:
TOTAL DUE THIS PAY PERIOD: |  |  | 0
Prepared by: |  |  |  |  |  |  | Date:
 |  | Construction Manager (Agent for City)
Reviewed by: |  |  |  |  |  |  | Date:
 |  | Engineering Construction Manager/P.M.
Reviewed by: |  |  |  |  |  |  | Date:
 |  | C.I.P. Design and Construction Manager
Accepted by: |  |  |  |  |  |  | Date:
 |  | Contractor
Approved by: |  |  |  |  |  |  | Date:
 |  | Deputy Public Works Director/City Engineer
Revised: 8/15/12
Spreadsheet: 576414d1528098843-min-and-max-max-and-min-2-ans
Sheet: Sheet1

Before :- |  |  |  |  |  |  |  | After :-
Country | Ref |  |  |  |  |  |  | Country | Start | End
India | A1
Israel | B1
Hong Kong | C1
India | A2
Israel | B2
Hong Kong | C2
India | A3
Israel | B3
Hong Kong | [NAME]
India | A4
Israel | B4
Hong Kong | C4
India | A5
Israel | B5
Hong Kong | C5