tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77431d1277907875-copying-data-from-one-sheet-to-another-help
Sheet: S Form

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Form S - registration, results and dated entry submission
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please use each cell where available
 | Centre number |  |  |  |  |  |  | Sub |  | Centre name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Phone number |  |  |  |  |  |  |  |  |  | Centre contact name
 | Award number |  |  |  |  |  |  | Award title |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Syllabus code |  |  |  |  |  | Purchase order reference number
 | [NAME] one of these boxes |  |  |  |  | Named registration |  |  |  |  |  |  | Results |  |  |  |  |  | Dated examination |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blocked registration |  |  |  |  |  |  |  |  |  | Number of registrations needed
 | Enrolment number if known |  |  |  |  |  |  |  |  | The candidate name is not necessary if enrolment number given |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sex |  | Date of birth |  |  |  |  |  |  | Ethnic code |  |  |  |  | Requirement |  |  |  |  | Funding code |  |  |  |  | Duplicate
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m |  | 12 |  | 23 |  | 34
 |  |  |  |  |  |  |  |  |  | Candidate name
 |  |  |  |  |  |  |  |  |  | Candidate name
 |  |  |  |  |  |  |  |  |  | Candidate name
 |  |  |  |  |  |  |  |  |  | Candidate name
 |  |  |  |  |  |  |  |  |  | Candidate name
 |  |  |  |  |  |  |  |  |  | Candidate name
 |  |  |  |  |  |  |  |  |  | Candidate name
 |  |  |  |  |  |  |  |  |  | Candidate name
 | Your signature: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page |  |  |  | of |  |  | Date |  |  |  |  |  |  |  |  |  | Counter signature (if needed)
Spreadsheet: 951efca0-d657-4866-89a7-51006b864b6c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6374 | 23650 | [NAME] | Dasse | FRA | 35 | 00:22:49 | 00:00:46 | 00:41:52 | [NAME] | 00:10:18 | 1 | 01:16:19
Spreadsheet: mark_haedicke__24593__2001BUDGET-102049 ns
Sheet: Allocations

Distribution of Service Costs to Business Units
 |  | 2000 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 2001 | 2001 | 2002
 |  | PLAN | ESTIMATE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL | TOTAL | TOTAL
Total O&M Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Co | Cost
Distribution : |  | Enter negatives for distributions - Enter amounts in the 2001 Plan column - monthly amounts will calculate automatically |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | Center
 | Transwestern | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 60 | 111077
 | Florida Gas Transmission | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 62 | 111182
 | Enron Engineering & Construction | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 82 | 102276
 | Citrus Corp | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 85 | 111260
 | EOTT Energy | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 105 | 100256
 | Northern Plains | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 172 | 112128
 | Northern Natural Gas | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 179 | 111456
 | GPG Executive | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 366 | 111723
 | Enron North America | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 413 | 105717
 | Enron Financial Initiatives (old [NAME]) | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 419 | 106041
 | Clean Fuels | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 436 | 111824
 | Enron Global Products | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 460 | 104515
 | Enron Europe | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 912 | 100672
 | Enron Global Finance (old ECM) | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 969 | 106196
 | Enron Energy Services | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 985 | 105285
 | Enron Broadband Services | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 017H | 104151
 | Enron Renewable Energy | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 01F8 | 107575
 | AZURIX | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 040Y | 100290
 | APACHE | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 061M | 102055
 | South America | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 061N | 102564
 | India | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 061P | 102247
 | Global E&P | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 063Q | 102352
 | CALME | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 067S | 102183
 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Total Distributions
NET EXPENSES (will remain at cost center)
[NAME]:
 | Enter Here For Example :  Based on Historical Usage, Headcount,  Level of Historical Projects, Transaction Count, Gross Margin, Gross Revenue
Spreadsheet: 08a1e1b3-e827-4ed5-900f-f7de6cee2203
Sheet: Sheet1

[NAME] |  | Minutes of Meeting |  | Form No: FM-004, Rev 01
Meeting Description: |  |  | Date of Meeting:                  Start Time:                End Time:
Attendees:
Apologies: |  |  | Absent:
Product/Assembly Description: |  |  | Customer: | RFQ #:
# | Item/Subject/Issue |  | Action | Who | When | Closed
Minutes compiled/Issued by: |  |  | Issue Date: | Page 1 of
Spreadsheet: david_delainey__8081__MP082800-DD
Sheet: Heartland

 | Heartland Write Down Allocation
 | Write Down Amount = | -7000000
 |  |  |  |  |  |  |  |  |  | MEMO
 |  |  | Source |  | 8/3/00 | Diluted | Allocation | Write Down | [NAME] | 8/3/00
 | Leg | Facility | Model | Asset Class | [NAME] | Shares | % | Allocation | Condor | Adjusted CV
 | Heartland Steel Common | Condor | MEMO-DET | Equity - Private | 14753533.27 | 52692 |  |  | -1910120
 | Heartland Steel Common | Balance Sheet | MEMO-DET | Equity - Private |  | 105339
 | Heartland Steel EAS | Balance Sheet | MEMO-DET | Equity - Other | 525200 | 2591
 | Heartland Steel Seed Cap. | Balance Sheet | MEMO-DET | Equity - Private | 2839716 | 14000
 | Heartland Steel Warrants | Balance Sheet | MEMO-DET | Equity - Private | 4217177 | 20344
 | Total
 |  |  |  |  |  |  |  |  |  |  | Heartland Common
 |  |  |  |  |  |  |  |  |  |  | Heartland Warrants
 |  |  |  |  | MEMO |  | RAPTOR
 |  |  | Source |  | 8/3/00 | Reverse | 8/3/00
 | Leg | Facility | Model | Asset Class | Adjusted CV | Condor FV | Notional
 | Heartland Steel Common | Condor | MEMO-DET | Equity - Private
 | Heartland Steel Common | Balance Sheet | MEMO-DET | Equity - Private |  | 0
 | Heartland Steel EAS | Balance Sheet | MEMO-DET | Equity - Other |  | 0
 | Heartland Steel Seed Cap. | Balance Sheet | MEMO-DET | Equity - Private |  | 0
 | Heartland Steel Warrants | Balance Sheet | MEMO-DET | Equity - Private |  | 0
 | Total
 | 3Q P&L Break Out
 | ENA
 | Condor
 | Total FV Write Down
Spreadsheet: 731676d1620500894-formula-that-returns-blank-0-1-1-and-compared-to-a-row-of-numbers-stock-short-term-comparison
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | result
13 | 18 | 22 | 31 | 34 | 36 | 41 | 45 | 48 |  |  |  |  | patt analysis
1 ext..most below occur with bal(1ci/1cd same pattern)
12 | 15 | 19 | 22 | 25 | 29 | 31 | 33 | 41
13 | 19 | 20 | 24 | 28 | 35 | 40
13 | 17 | 20 | 23 | 26 | 30 | 33 | 37
12 | 17 | 21 | 30 | 43 | 49
 |  |  |  |  |  |  |  |  |  |  |  | 1
12 | 17 | 21 | 43 | 42 | 46
 |  |  |  |  |  |  |  |  |  |  |  | 2
12 | 17 | 23 | 27 | 42 | 46
 |  |  |  |  |  |  |  |  |  |  |  | 3
12 | 17 | 21 | 25 | 26 | 32 | 39 | 43
 |  |  |  |  |  |  |  |  |  |  |  | 4
12 | 17 | 23 | 25 | 26 | 32 | 39 | 43
 |  |  |  |  |  |  |  |  |  |  |  | 5
12 | 19 | 21 | 25 | 26 | 32 | 39 | 43
Spreadsheet: 134566d1325469721-i-for-got-how-to-search-an-array-for-a-row-and-use-values-from-that-row-emperon_spreadsheet_stefan-bvj-
Sheet: Member Purchases

Member ID | First Name | Last Name | Membership Type | Total Purchases of Basic Items | Basic Items Discount | Total Purchases of Regular Items | Regular Items Discount | Total Purchases of Luxury Items | [NAME] | Total Purchases of Special Items | Special items Discount | Overall Total Purchases | Total Discount
ABC123 | Aldrich | Shakir | Regular | 8000 |  | 6000 |  | 3000 |  | 4000
ABC124 | Aldridge | [NAME] | Senior | 9000 |  | 7000 |  | 1500 |  | 5000
ABC125 | [NAME] | Shalin | Regular
ABC126 | Aldwyn | itcham | Regular
ABC127 | Denzel | [NAME] | Senior
ABC128 | Denzil | Mitchell | Senior
ABC129 | Deo | Mitesh | Regular
ABC130 | Derain | Mladen | Regular
ABC131 | Derby | [NAME] | Regular
ABC132 | Gerik | Mog | VIP | 3000 |  | 7000 |  | 12000 |  | 7000
ABC133 | Germain | Macmorris | VIP
ABC134 | Gerome | [NAME] | Regular
ABC135 | [NAME] | Kenelm | Regular
ABC136 | [NAME] | Kenley | Regular
ABC137 | Gershom | Kenn | Regular
[NAME] | [NAME] | Kennard | Senior
ABC139 | Than | [NAME] | Senior
ABC140 | Thane | [NAME] | VIP
ABC141 | Thanos | Kenny | Regular
ABC142 | [NAME] | [NAME] | VIP
ABC143 | Callia | Halfrida | VIP
ABC144 | Callidora | [NAME] | Regular
ABC145 | Calliope | Halia | VIP
ABC146 | Callista | Haliey | Regular
ABC147 | [NAME] | Halima | Regular
ABC148 | Petunia | [NAME] | VIP
ABC149 | Phaedra | Odetta | Senior
ABC150 | Phebe | [NAME] | Senior
ABC151 | Phedra | Odile | Regular
ABC152 | Kenya | Ofelia | VIP
ABC153 | [NAME] | Ofilia | VIP
ABC154 | Kenyatta | [NAME] | Regular
[NAME] | Kepa | Beckie | VIP
ABC156 | [NAME] | Becky | Senior
ABC157 | Keren | Beda | Senior
Spreadsheet: 69988d1270651782-how-to-compare-2-spreadsheets-dummyworkbook
Sheet: Old Data

Campaign | Ad Group | Keyword | [NAME] | [NAME] | First Page CPC | Quality Score | Destination URL | Campaign Status | AdGroup Status | [NAME] | Suggested Changes | Comment | Impressions | Clicks | CTR | [NAME] | Avg CPM | Cost | Avg Position | Conversions (1-per-click) | Conversion Rate (1-per-click) | Cost/Conversion (1-per-click) | Conversions (many-per-click) | Conversion Rate (many-per-click) | Cost/Conversion (many-per-click)
pmp training nigeria OLD | Ad Group #1 | a guide to the project management body of knowledge | Exact |  | 0.05 | 7 |  | Paused | Paused | Active |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
pmp training nigeria OLD | Ad Group #1 | [NAME] | Exact |  | 0.05 | 7 |  | Paused | Paused | Active |  |  | 129 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
pmp training nigeria OLD | Ad Group #1 | abr | Exact |  | 0.2 | 6 |  | Paused | Paused | Active |  |  | 6 | 1 | 0.1667 | 0.2 | 33.33 | 0.2 | 1 | 0 | 0 | 0 | 0 | 0 | 0
pmp training nigeria OLD | Ad Group #1 | Abuja | Exact |  | 0.3 | 5 |  | Paused | Paused | Active |  |  | 1199 | 7 | 0.0058 | 0.14 | 0.84 | 1.01 | 1.1 | 0 | 0 | 0 | 0 | 0 | 0
pmp training nigeria OLD | Ad Group #1 | [NAME] | Broad |  | 0.05 | 7 |  | Paused | Paused | Active |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
pmp training nigeria OLD | Ad Group #1 | [NAME] | Phrase |  | 0.05 | 7 |  | Paused | Paused | Active |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
pmp training nigeria OLD | Ad Group #1 | [NAME] | Exact |  | 0.05 | 7 |  | Paused | Paused | Active |  |  | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
pmp training nigeria OLD | Ad Group #1 | boot camp nig | Broad |  | 0.05 | 7 |  | Paused | Paused | Paused |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
pmp training nigeria OLD | Ad Group #1 | boot camp project management | Broad |  | 0.05 | 7 |  | Paused | Paused | Paused |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 59057d1259461253-dynamic-pivot-chart-based-on-pivot-table-pivot-table-_chart
Sheet: Sheet1

 |  |  |  |  | Chart 1
Description | Data | Total |  |  | Count of  Item: By Cash
By Cash | Sum of Dr.Amt |  |  |  | Count of Item: To Electricity Expenses
 | Sum of Cr.Amt | 3200 |  |  | Count of Item: To Water Expenses
By Other income | Sum of Dr.Amt |  |  |  | Count of Item: To Printing Expenses
 | Sum of Cr.Amt | 2000
To Electricity Expenses | Sum of Dr.Amt | 300
 | Sum of Cr.Amt |  |  |  | Chart 2
To Printing Expenses | Sum of Dr.Amt | 600 |  |  | Sum of  Item: By Cash
 | Sum of Cr.Amt |  |  |  | Sum of Item: To Electricity Expenses
To Water Expenses | Sum of Dr.Amt | 1000 |  |  | Sum of Item: To Water Expenses
 | Sum of Cr.Amt |  |  |  | Sum of Item: To Printing Expenses
Total Sum of Dr.Amt |  | 1900
Total Sum of Cr.Amt |  | 5200
Spreadsheet: 864571d1711694030-extract-duplicate-values-in-range-with-criteria-locker-lotto-test-aligw
Sheet: Sheet1

 |  |  | Mon | Tue | Wed | Thu | Fri |  | North Division
 |  | Week 1 | 277 | 196 | 98 | 139 | 14 |  | Lockers |  | 1 | to | 150
 |  | Week 2 | 249 | 189 | 115 | 111 | 160 |  |  | 84 | 127
 |  | Week 3 | 123 | 71 | 84 | 145 | 237
 |  | Week 4 | 63 | 218 | 264 | 239 | 228
 |  | Week 5 | 14 | 11 | 234 | 164 | 194 |  | South Division
 |  | Week 6 | 84 | 174 | 240 | 74 | 242 |  | Lockers |  | 151 | to | 300
 |  | Week 7 | 240 | 14 | 68 | 86 | 33 |  |  | 240 | 277
 |  | Week 8 | 221 | 69 | 263 | 127 | 254
 |  | Week 9 | 127 | 277 | 250 | 117 | 144
 |  | Week 10 | 136 | 196 | 278 | 180 | 18
Spreadsheet: 63716d1264595917-conditional-formatting-more-than-3-695137-colour-code
Sheet: MY REQUIREMENTS

 |  |  |  |  |  |  | RANGE
 | my requirements |  |  |  |  |  | 1 | January
 | 1 | January |  |  |  |  | 2 | February
 | 2 | February |  |  |  |  | 3 | March
 | 3 | March |  |  |  |  | 4 | April
 | 4 | April |  |  |  |  | 5 | May
 | 5 | May |  |  |  |  | 6 | June
 | 6 | June |  |  |  |  | 7 | July
 |  | #N/A |  |  |  |  | 8 | August
 |  | #N/A |  |  |  |  | 9 | September
 |  | #N/A |  |  |  |  | 10 | October
 |  | #N/A |  |  |  |  | 11 | November
 |  | #N/A |  |  |  |  | 12 | December
 |  | #N/A
 |  | #N/A
Spreadsheet: 752107d1634583293-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test
Sheet: TA 

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Notes | PRODUCT | ABPAC | BAKO | Catering 24 | Cheapest | From | Saving | x50 bought
10" Greaseproof bag | ABPAC | 16.82 | 1000 |  |  |  |  | 10" Greaseproof bag |  |  |  |  |  |  |  |  |  | 12oz compostable d/w cup |  |  |  |  | BAKO
10" Greaseproof bag | BAKO | 8.12 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12oz compostable lid |  |  |  |  | Bonds Packaging
10" Greaseproof bag | Catering 24 | 19.02 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7" Greaseproof bag |  |  |  |  | Catering 24
12oz compostable d/w cup | Catering 24 | 45.54 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8oz compostable d/w cup |  |  |  |  | Enviropack
12oz compostable d/w cup | Next Day Coffee | 43.19 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8oz compostable lid |  |  |  |  | Enviropack 4+
12oz compostable d/w cup | [NAME] | 53.1 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nesting Tray |  |  |  |  | Enviropack 5+
12oz compostable lid | Catering 24 | 53.99 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. 1 [NAME] |  |  |  |  | Next Day Coffee
12oz compostable lid | Next Day Coffee | 29.75 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. 3 [NAME] |  |  |  |  | [NAME]
12oz compostable lid | [NAME] | 54.84 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perforated Film Front [NAME] bag
7" Greaseproof bag | ABPAC | 10.28 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOS Carrier Bag
7" Greaseproof bag | BAKO | 6.88 | 1000
7" Greaseproof bag | Catering 24 | 9.77 | 1000
8oz compostable d/w cup | Catering 24 | 38.34 | 500
8oz compostable d/w cup | Next Day Coffee | 38.39 | 500
8oz compostable d/w cup | [NAME] | 43.56 | 500
8oz compostable lid | Catering 24 | 59.34 | 1000
8oz compostable lid | Next Day Coffee | 25.19 | 500
8oz compostable lid | [NAME] | 45.35 | 1000
Nesting Tray | ABPAC | 32.74 | 500
Nesting Tray | Bonds Packaging | 21.12 | 220
No. 1 [NAME] | Catering 24 | 56.99 | 450
No. 1 [NAME] | Enviropack | 59.94 | 450
No. 1 [NAME] | Enviropack 4+ | 56.39 | 450
No. 3 [NAME] | Catering 24 | 42.24 | 180
No. 3 [NAME] | Enviropack | 44.34 | 180
No. 3 [NAME] | Enviropack 4+ | 41.99 | 180
Perforated Film Front [NAME] bag | Enviropack | 36.54 | 1000
Perforated Film Front [NAME] bag | Enviropack 5+ | 33.59 | 1000
Perforated Film Front [NAME] bag | Next Day Coffee | 39.59 | 1000
SOS Carrier Bag | Catering 24 | 21.59 | 250
SOS Carrier Bag | Enviropack | 21.59 | 250
SOS Carrier Bag | Enviropack 5+ | 19.79 | 250
10" Greaseproof bag | ABPAC | 15
Spreadsheet: 684224d1593197563-abc-on-unsorted-data-abc_unsorted
Sheet: Summery

Product | Category | Sales Value ($) | % Sales | rank | cum % | Grade
A-1 | A | 69
A-2 | A | 149
A-20 | A | 398
A-126 | A | 209
A-141 | A | 249
A-364 | A | 447
A-365 | A | 298
A-375 | A | 398
A-527 | A | 349
B-696 | B | 369
B-702 | B | 379
B-729 | B | 69
B-744 | B | 398
B-775 | B | 399
B-865 | B | 418
B-869 | B | 439
[NAME] | B | 69
B-873 | B | 448
Spreadsheet: 58792d1259059734-row-to-column-row_to_column-1-
Sheet: Sheet3

First | Data
A | raj | A1
A | raj | A2
A | ram | A3
B | kam | B1
B | ran | B2
B | asdf | B3
B | asdf | B4
B | [NAME] | B5
B | twer | B6
C | [NAME] | C1
C | iqwoeur | C2
C | qoweir | [NAME]
C | qwe | C4
Need the data like this
A | raj | raj | ram |  |  |  |  | A | raj | raj | ram | #N/A | #N/A | #N/A | #N/A
B | kam | ran | asdf | asdf | [NAME] | twer |  | B | kam | ran | asdf | asdf | [NAME] | twer | #N/A
C | [NAME] | iqwoeur | qoweir | qwe |  |  |  | C | [NAME] | iqwoeur | qoweir | qwe | #N/A | #N/A | #N/A
Spreadsheet: 07e3e3f8-9579-433c-9637-583392c8be93
Sheet: Sheet1

Title | ISSN | Individual Subscription Price (in Country of Publication) | Frequency | Cost/Issue (US$) | Year of Origin | Age (Years) | Theological Journal?
Asbury Theological Journal | 1090-5642 | 5 | 2 | 2.5 | 1946 | 61 | Yes
Bibliotheca Sacra | 0006-1921 | 24 | 4 | 6 | 1843 | 164 | Yes
Calvin Theological Journal | 0008-1795 | 23 | 2 | 12.005 | 1966 | 23 | Yes
Christian Apologetics Journal | None found | 25 | 2 | 12.5 | 1998 | 9 | Yes
Christian Education Journal | 0739-8913 | 28 | 2 | 14 | 1980 | 27 | No
Christian Higher Education | 1536-3759 | 138 | 4 | 34.5 | 2002 | 5 | No
[NAME] | 0017-2251 | 24 | 4 | 29.22 | 1970 | 15 | No
Churchman: A Journal of Anglican Theology | 0009-661X | 44.03 | 2 | 15 | 1879 | 25 | Yes
Concordia Journal | 0145-7233 |  | 4 |  | 1975 | 32 | Yes
Conspectus: The Journal of the South African Theological Seminary | None found |  | 2 |  | 2006 | 1 | Yes
Creation Research Society Quarterly | 0092-9166 | 38 | 4 | 9.5 | 1964 | 43 | No
Cultural Encounters: A Journal for the Theology of Culture | 1550-4891 | 20 | 2 | 10 | 2004 | 3 | No
European Journal of Theology | 0960-2720 | 58.44 | 2 | 29.22 | 1992 | 15 | Yes
Evangelical Quarterly | 0014-3367 | 63.23 | 4 | 15 | 1929 | 39 | Yes
Evangelical Review of Theology | 0144-8153 | 63.23 | 4 | 15.8075 | 1977 | 30 | Yes
Fides et [NAME] | 0884-5379 | 30 | 2 | 15 | 1968 | 39 | No
Foundations | 0144-378X | 15 | 2 | 7.5 | 1978 | 29 | Yes
Journal of Christian Education | 0021-9657 | 41.77 | 3 | 35 | 1958 | 15 | No
Journal of Creation | 1833-6213 | 37 | 3 | 12.33333333333333 | 1984 | 23 | No
Journal of Pentecostal Theology | 0966-7369 | 54 | 2 | 27 | 1992 | 15 | Yes
Journal of Psychology & Christianity | 0733-4273 | 60 | 4 | 15 | 1982 | 25 | No
Journal of Psychology and Theology | 0091-6471 | 42 | 4 | 10.5 | 1973 | 34 | No
Journal of Research on Christian Education | 1065-6219 | 70 | 2 | 35 | 1992 | 15 | No
Journal of the American Society for Church Growth | 1091-2711 | 24 | 3 | 8 | 1991 | 16 | Yes
Journal of the Evangelical Theological Society | 0360-8808 | 30 | 4 | 7.5 | 1958 | 49 | Yes
Mennonite Quarterly Review | 0025-9373 | 35 | 4 | 10 | 1927 | 3 | No
Perspectives on Science and [NAME] | 0892-2675 | 35 | 4 | 8.75 | 1949 | 58 | No
Philosophia Christi | 1529-1634 | 30 | 2 | 15 | 1999 | 8 | No
Social Work and Christianity | 0737-5778 | 80 | 4 | 20 | 1974 | 33 | No
Southwestern Journal of Theology | 0038-4828 | 31 | 3 | 10.33333333333333 | 1958 | 49 | Yes
Stone-Campbell Journal | 1097-6566 | 20 | 2 | 10 | 1998 | 9 | Yes
The Journal of Youth Ministry: The Academic Journal of Youth Ministry Educators | 1541-0412 | 25 | 2 | 12.5 | 2000 | 7 | Yes
Transformation | 0265-3788 | 48.02 | 4 | 12.005 | 1984 | 23 | No
Trinity Journal | 0360-3032 | 18 | 2 | 9 | 1971 | 36 | Yes
Westminster Theological Journal | 0043-4388 | 20 | 2 | 10 | 1938 | 69 | Yes
Spreadsheet: 143096d1330195812-subtotal-sample-file2
Sheet: Stage 2

CustomerID | OrderDate | ContactFirstName | ContactLastName | BillingAddress | OrderID | Total
13230 | 2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 2295
13230 | 2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 500
13230 | 2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 500
13230 | 2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 3295
13234 | 2010-01-04 00:00:00 | RICHARD | [NAME] | 248 QUEEN ALEXANDRA ROAD SE | 30791 | 500
13234 | 2010-01-04 00:00:00 | RICHARD | [NAME] | 248 QUEEN ALEXANDRA ROAD SE | 30791 | 500
13234 | 2010-01-04 00:00:00 | RICHARD | [NAME] | 248 QUEEN ALEXANDRA ROAD SE | 30791 | 2295
13234 | 2010-01-04 00:00:00 | RICHARD | [NAME] | 248 QUEEN ALEXANDRA ROAD SE | 30791 | 3295
13235 | 2010-01-04 00:00:00 | CHRIS | MCCOLEMAN | 3218 3RD STREET SW | 30792 | 500
13235 | 2010-01-04 00:00:00 | CHRIS | MCCOLEMAN | 3218 3RD STREET SW | 30792 | 500
13235 | 2010-01-04 00:00:00 | CHRIS | MCCOLEMAN | 3218 3RD STREET SW | 30792 | 2295
Spreadsheet: 86037d1286005804-using-a-date-format-in-a-cell-instead-of-a-text-format-to-support-a-formula-cash-deposits-and-orders-sample-3-
Sheet: 09-03-10

CASH ORDER
Denomination |  | 2010-09-03 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 3627600 |  | 2084600
20 |  | 2712640 |  | 1147000
10 |  | 147750 | 25070 | 0
5 |  | 435615 |  | 286100
1 |  | 154973 |  | 52000
0.25 |  | 18905 | 14143 | 0
0.05 |  | 7009 | 1432 | 0 |  | 2000
0.01 |  | 794 | 484 | 0 |  | 1000
Total