tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c828b203-5b61-405c-a3e3-fa0286496694
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
40204458 | 2014-02-23 21:48:08 | ALLIES | 1 | 10 | 5 | 901544 | manu76 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40205174 | 2014-02-23 22:24:46 | AXIS | 1 | 10 | 7 | 901544 | manu76 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40340160 | 2014-03-03 21:52:25 | ALLIES | 0 | 4 | 7 | 249959 | NAPOLEON71 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40340779 | 2014-03-03 22:22:15 | AXIS | 1 | 7 | 4 | 249959 | NAPOLEON71 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40356669 | 2014-03-04 21:47:51 | AXIS | 0 | 4 | 5 | 366106 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40357072 | 2014-03-04 22:00:20 | ALLIES | 0 | 2 | 5 | 366106 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40372491 | 2014-03-05 21:32:40 | AXIS | 1 | 5 | 3 | 676026 | JJ HOOVER | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
40372682 | 2014-03-05 21:51:17 | ALLIES | 1 | 5 | 4 | 676026 | JJ HOOVER | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 115482d1311086852-multiple-sumif-criteria-within-same-column-multiple-sumif
Sheet: Sheet1

Criteria | MAY-11 | JUN-11 | JUL-11 | AUG-11 | SEP-11
Apple | 0 | 0 | -5.82076609134674e-14 | -4.94765117764473e-13 | -52.1519600000001
[NAME] | 3 | 5 | 2 | 0 | -2.0456215316775
[NAME] | 34 | 2 | 23 | 21 | 0
Ford |  |  | 0 | 0 | 0 |  | 0
Porsche |  |  | 63.8032666285716 | 74.4371445 | 74.4371445 |  | SUMIF(A2:A13,OR("Apple","Banana","Cherry"),(F2:F13))
Mango |  | 0 | 10.6285714285696 | -242.27118 | -472
[NAME] |  |  | 107.142857142857 | 960 | 200
Toyota |  | 0 | 0 | 0
Nissan |  |  | 23.6785723285773 | -3.25000010000001 | -3.2500001
Honda |  |  | 366.642870557143 | -914.50003659999 | -15.5000013000008
Carrot |  |  | 0
Bean |  |  | -351.517859221429 | 1047.7500062 | -1.00000079328311e-07
 | Desired End Result
Criteria | MAY-11 | JUN-11 | JUL-11 | AUG-11 | SEP-11
Apple | 37 | 7 | 24.99999999999994 | 20.99999999999951 | -54.1975815316776
Ford |  |  | 0 | 0 | 0
Porsche |  |  | 63.8032666285716 | 74.4371445 | 74.4371445
Mango | 0 | 0 | 117.7714285714266 | 717.72882 | -272
Toyota |  | 0 | 0 | 0
Nissan |  |  | 23.6785723285773 | -3.25000010000001 | -3.2500001
Honda |  |  | 366.642870557143 | -914.50003659999 | -15.5000013000008
Carrot | 0 | 0 | -351.517859221429 | 1047.7500062 | -1.00000079328311e-07
Spreadsheet: 275645d1383597185-amortization-table-related-to-if-statement-and-some-my-dream-home-amort
Sheet: Sheet1

My Dream Home's Amort Table
 | [NAME]
 |  | Home Price |  | 420000 |  |  | Interest Rate |  | 0.0391
 |  | Downpayment |  |  |  |  | Monthly Rate
 |  | Loan Amount |  |  |  |  | Payments Per Year |  | 12
 |  | Monthly Payment |  |  |  |  | Years |  | 5
 |  |  |  |  |  |  | Number of Payments
 | Payment Number | Beginning Balance | Monthly Payment | Interest | Principle | Additional Payments | Remaining Balance
 | 1 |  |  |  |  | 890
 | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
Spreadsheet: 762847d1641857578-formula-returns-value-instead-of-0-returns-value-instead-of-0
Sheet: 1

Interview Scores ([NAME] 200) | Candidate Name:
Instructions for each Panel Member:   Use this form to track your individual evlaluation and notes. After the interview, the Panel Members will need to discuss thier evaluations of each question and come to an agreement on the "Final Consensus Score".  The Panel Chair should take notes on the consensus discussion in the space provided.  Individual Evaluation Scores can be either rated quantitatively or non-quantitatively. |  |  | Question 1 | (Identify Compentency) |  |  |  | Number of Panel Members:
It is recommended they are rated as either "Minimal", which means the applicant's answer was not reflective of the question asked, "Average", which means the answer was satisfactory but had little depth, or "Exceptional", which means the applicant provided a well thought out answer supported with example(s) . |  |  | Mbr 1 | Mbr 2 | Mbr 3 | Mbr 4 | Score
The Final Consensus Score should be no more than 200 total points: Minimium <125                                                                             Average 125-174                                                                              Exceptional 175-200
All three (or four) members should sign the Chairman's form in the designated space once completed. |  |  | Question 2 | (Identify Compentency)
 |  |  | Mbr 1 | Mbr 2 | Mbr 3 | Mbr 4 | Score
 |  |  | Question 3 | (Identify Compentency) |  |  |  |  |  |  |  | Applicant Scoring:
Spreadsheet: 4b5e2658-d106-46a3-88c7-80fa6cc09697
Sheet: Sheet1

Table 1--Soybeans:  Annual U.S. supply and disappearance | 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
 | Area |  | Yield | Supply |  |  |  |  | Use
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed, feed |  |  | Ending
September 1 |  |  |  | stocks | Production | Imports | Total |  |  | & residual | Exports | Total | stocks
 | Million acres |  | Bu./acre |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2011/12 | 75.046 | 73.776 | 41.93130557362828 | 215.013 | 3093.524 | 16.1356425643245 | 3324.672642564324 |  | 1703 | 87.28499983897359 | 1365.017642725351 | 3155.302642564324 | 169.37
2012/131 | 77.198 | 76.164 | 39.82959140801429 | 169.37 | 3033.581 | 36.1366418632023 | 3239.087641863202 |  | 1689 | 89.96486634648022 | 1319.565775516722 | 3098.530641863203 | 140.557
2013/142 | 76.533 | 75.869 | 43.34883812888005 | 140.557 | 3288.833 | 35 | 3464.39 |  | 1690 | 99.38999999999987 | 1530 | 3319.39 | 145
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  | Supply |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
 |  |  |  |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2012/13
September-November |  |  |  | 169.37 | 3033.581 | 4.2863493307698 | 3207.23734933077 |  | 622.6353144323552 |  | 618.4410348984147 | 1241.07634933077 | 1966.161
December-February |  |  |  | 1966.161 | --- | 4.7181036423045 | 1970.879103642304 |  | 447.2727627133432 |  | 525.5863409289612 | 972.8591036423045 | 998.02
March-May |  |  |  | 998.02 | --- | 7.8351491690241 | 1005.855149169024 |  | 446.1362887515575 |  | 125.0548604174667 | 571.1911491690241 | 434.664
June-August |  |  |  | 434.664 | --- | 19.2970397211039 | 453.9610397211039 |  | 262.9205004492242 |  | 50.48353927187971 | 313.4040397211039 | 140.557
Total |  |  |  |  | 3033.581 | 36.1366418632023 | 3239.087641863202 |  | 1778.96486634648 |  | 1319.565775516722 | 3098.530641863203
2013/14
September-November |  |  |  | 140.557 | 3288.833 | 11.8156584914991 | 3441.205658491499 |  | 632.482992166453 |  | 661.164666325046 | 1293.647658491499 | 2147.558
1 Estimated. 2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2014-03-11 21:11:10.430000
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2014-03-11 21:11:10.430000
Spreadsheet: 112931d1308889697-populating-cells-based-on-drop-box-newpc
Sheet: Prices

Project: New PC
Budget: US$1100-1800
 | Choice 1 | Price 1 | Choice 2 | Price 2 | Choice 3 | Price 3
CPU | Intel Core i7 2600K | 315 | Intel Core i7 2500K | 220
Motherboard | [NAME] Rev 3.0 | 350 | Asus P8P67 Deluxe Rev 3.0 | 225
PSU | Corsair Enthusiast TX750 V2 750W ATX12V/EPS12V v2.92 | 110 | Thermaltake TPX-775M | 120
GPU | ATI Radeon HD 5850 (HIS) | 165 | ATI Radeon HD 5770 (MSI) | 140
RAM | Corsair Vengeance [NAME] 2133 | 100 | Corsair Vengeance [NAME] 1600 | 87 | G.Skill Ripjaws Series 16GB | 150
HDD | Western Digital RE4 500GB 7200RPM 64MB Cache | 80 | WD Caviar Black 7200 RPM 32MB Cache | 85
Sound | [NAME] |  | [NAME]
Cooling/Case | Antec Twelve Hundred V3 Case | 160 | [NAME] PC-K63 | 100
ODD
OS
Total
Spreadsheet: 842801d1694778186-redistributing-numbers-evenly-across-unique-ids-and-matching-conditions-excel-forum-15-september-2-
Sheet: Sheet1 (2)

 | First Given Barcodes | Second Given Barcodes | [NAME] downwards | I accept the format solution as below
Box 1 | 96122 | 96433 | 96122 | 96122
Box 1 | 96122 | 96433 |  | 96200
Box 1 | 96122 | 96122
Box 1 | 96122 | 96200
Box 1 | 96122 | 96200
Box 1 | 96122
Box 1 | 96122
Box 1 | 96200 |  | 96200
Box 1 | 96200
Box 1 | 96200
[NAME] | 96200 |  | 96200 | 96200
[NAME] | 96200 |  |  | 96433
[NAME] | 96200 |  |  | 96433
[NAME] | 96200
[NAME] | 96433 |  | 96433
[NAME] | 96433
[NAME] | 96433
[NAME] | 96433 |  | 96433
[NAME] | 96433
[NAME] | 96433
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: TETCO ELA

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       TETCO ELA               Jun01           USD/MM | 05/30/2001 01:22 pm | 5000 | 3.69
US Gas Phy       TETCO ELA               Jun01           USD/MM | 05/30/2001 02:15 pm | 3424 | 3.81
US Gas Phy       TETCO ELA               Jun01           USD/MM | 05/30/2001 08:49 am | 5000 | 3.57
US Gas Phy       TETCO ELA               Jun01           USD/MM | 05/30/2001 09:34 am | 182 | 3.6
US Gas Phy       TETCO ELA               Jun01           USD/MM | 05/31/2001 08:09 am | 5000 | 3.695
US Gas Phy       TETCO ELA               Jun01           USD/MM | 05/31/2001 08:39 am | 3657 | 3.755
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 53722d1253639093-lookup-with-multiple-rows-template-meeting-planner-2010
Sheet: Sheet1

Location | Purpose | Level 3/4 Resource |  |  |  |  |  | 2009 |  |  | 2010
 |  |  |  |  |  |  |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
US | x | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  | X
US | y | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | X
UK or U.S. | x | [NAME] |  |  |  |  |  | X
US | d |  | [NAME] |  |  | [NAME] | [NAME]
UK or U.S. | x |  | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  | X
UK | y | [NAME] |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | X
Germany | x | [NAME] |  |  |  | [NAME] |  | X
US | d | [NAME] |  |  |  | [NAME]
US | x | [NAME] |  |  |  | [NAME]
UK or U.S. | y | [NAME] |  |  |  | [NAME]
US | x |  | [NAME] | Paul N |  | [NAME] |  |  |  | X
UK or U.S. | e |  | [NAME] | Paul N |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
UK | x |  |  |  |  |  | [NAME] | X
US | y |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | X
US | x |  | [NAME] | Paul N | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  | X
US | f |  |  |  |  |  | [NAME] |  |  |  |  |  |  | X
US | x |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
US | y |  |  | Paul N |  | [NAME]
UK or U.S. | x |  |  | Paul N |  |  |  | X
US | g |  | [NAME] |  |  | [NAME] |  |  |  |  |  |  | X
UK or U.S. | x | [NAME] |  |  |  | [NAME]
UK | y | [NAME] |  |  |  | [NAME]
Germany | x |  | [NAME] | Paul N | [NAME] | [NAME] | [NAME]
 | Unscheduled |  |  |  |  |  |  | 2009 |  |  | 2010
 |  |  |  |  |  |  |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Scheduled
 |  | Paul N |  |  |  |  | Paul N | X |  | X |  |  |  |  |  | X |  |  |  |  |  | X
 |  | [NAME] |  |  |  |  | [NAME] | X |  |  |  |  | X |  |  |  |  |  | X
 |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME] | X |  |  |  | X |  | X |  |  |  |  |  | X
 |  | [NAME] |  |  |  |  | [NAME] | X |  | X |  | X | X |  |  | X |  |  | X |  |  | X
 |  | [NAME] |  |  |  |  | [NAME] |  |  | X |  | X | X |  |  | X |  |  |  |  |  | X
Spreadsheet: 40be2a76-1258-4aa0-8064-16349eb3b177
Sheet: Sheet2

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF DECEMBER 20TH TO 26TH,  2010
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, December 20th, 2010
09:00:00 | CA# 5767-MG | MASTER [NAME] | ORAL ARGUMENT | TEKMEN     V. TEKMEN | Georgetown
12:30:00 | CA# 5963-VCS | V C STRINE | HEARING | ESTATE OF WAYNE PUCKHAM | [NAME]
Tuesday, December th, 2010
09:30:00 | CA# 4516-VCP | V C PARSONS | TRIAL | [NAME]   [NAME] | [NAME]
10:00:00 | CA# 5762-VCL | V C LASTER | HEARING | UNIVERSITY OF DELAWARE  V.  JOHN DOE ,et [NAME] | [NAME]
10:00:00 | CA# 5042-VCS | V C STRINE | ORAL ARGUMENT | BARRON FLETCHER, III & EVAN KARP  V.  HOME ORGANIZERS | [NAME]
Wednesday, December 8th, 2010
09:30:00 | CA# 4516-VCP | V C PARSONS | TRIAL | [NAME]   [NAME] | [NAME]
Thursday, December 9th, 2010
09:30:00 | CA# 4516-VCP | V C PARSONS | TRIAL | [NAME]   [NAME] | [NAME]
10:00:00 | CA# 5807-MA | MASTER AYVAZIAN | HEARING | IMO PORTIONS OF LANDS OF CHRISTIANA RIVER IMP. CO. | [NAME]
11:30:00 |  | MASTER AYVAZIAN | PETITION | NEW CASTLE COUNTY ROUTINE PETITIONS | [NAME]
12:00:00 | CA# 5700-CC | MASTER AYVAZIAN | HEARING | IMO TRUST AGREE,B/T ANN V. CARVEL, AND WILM TRUST | [NAME]
01:30:00 | CA# 5757-MA | MASTER AYVAZIAN | HEARING | IMO ESTATE OF HARRY MEYER,JR. | [NAME]
02:00:00 | CA# 5961-VCN | V C NOBLE | HEARING | STATE OF DE,et [NAME] LONGSHORE | Dover
Friday, December 10th, 2010
09:30:00 | CA# 4516-VCP | V C PARSONS | TRIAL | [NAME]   [NAME] | [NAME]
09:30:00 |  | MASTER [NAME] | PETITIONS | SUSSEX COUNTY ROUTINE PETITIONS | Georgetown
09:30:00 | CA# 3432-VCN | V C NOBLE | TRIAL | [NAME] | Dover
11:00:00 | CA# 5834-MG | MASTER [NAME] | HEARING | [NAME] et [NAME] CANFIELD | Georgetown
Spreadsheet: 678115d1589723109-and-or-functions-to-auto-fill-rates-depending-the-date-given-rates
Sheet: Rates

Check in | 2020-05-12 00:00:00 |  | Check Out | 2020-06-02 00:00:00 |  | Nights |  |  | HAPPY ROOM |  | CONTRACT RATE
 |  |  |  |  |  |  |  |  |  |  | ROOM TYPE | LOW SEASON |  | MIDDLE SEASON |  | HIGH SEASON |  | PEAK SEASON
 |  |  |  |  |  |  |  |  |  |  |  | 2020-05-11 00:00:00 | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-08-25 00:00:00
2020-05-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2020-09-28 00:00:00 | 2020-10-11 00:00:00 | 2020-09-14 00:00:00 | 2020-09-27 00:00:00 | 2020-08-26 00:00:00 | 2020-09-13 00:00:00
2020-05-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | HAPPY ROOM | 95 |  | 130 |  | 165 |  | 240
2020-05-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | STANDARD DBL | 105 |  | 145 |  | 185 |  | 285
2020-05-15 00:00:00 |  |  |  |  |  |  |  |  |  |  | SUPERIOR | 115 |  | 160 |  | 200 |  | 340
2020-05-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | JUNIOR SUITE | 135 |  | 190 |  | 230 |  | 410
2020-05-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | DELUXE | 150 |  | 220 |  | 260 |  | 475
2020-05-18 00:00:00 |  |  |  |  |  |  |  |  |  |  | FAMILY | 170 |  | 240 |  | 310 |  | 520
2020-05-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | SUPERIOR SUITE | 250 |  | 340 |  | 410 |  | 690
2020-05-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | MASTER SUITE | 280 |  | 410 |  | 500 |  | 790
2020-05-21 00:00:00
2020-05-22 00:00:00
2020-05-23 00:00:00
2020-05-24 00:00:00
2020-05-25 00:00:00
2020-05-26 00:00:00
2020-05-27 00:00:00
2020-05-28 00:00:00
2020-05-29 00:00:00
2020-05-30 00:00:00
2020-05-31 00:00:00
2020-06-01 00:00:00
2020-06-02 00:00:00
Spreadsheet: b827df5f-3484-41b3-ab31-43e4523d42a3
Sheet: Sheet1

Section 10 EXTRA Program Coach Badge |  |  |  | Section 10 EXTRA Program Coach Badge
Coach Name |  | Photo Here |  | Coach Name |  | Photo Here
Team Name |  |  |  | Team Name
Age Division |  |  |  | Age Division
Region Number/Name |  |  |  | Region Number/Name
 | AYSO ID# |  |  |  | AYSO ID#
 | RC Signature |  |  |  | RC Signature
Section 10 EXTRA Program Coach Badge |  |  |  | Section 10 EXTRA Program Coach Badge
Coach Name |  | Photo Here |  | Coach Name |  | Photo Here
Team Name |  |  |  | Team Name
Age Division |  |  |  | Age Division
Region Number/Name |  |  |  | Region Number/Name
 | AYSO ID# |  |  |  | AYSO ID#
 | RC Signature |  |  |  | RC Signature
Section 10 EXTRA Program Coach Badge |  |  |  | Section 10 EXTRA Program Coach Badge
Coach Name |  | Photo Here |  | Coach Name |  | Photo Here
Team Name |  |  |  | Team Name
Age Division |  |  |  | Age Division
Region Number/Name |  |  |  | Region Number/Name
 | AYSO ID# |  |  |  | AYSO ID#
 | RC Signature |  |  |  | RC Signature
Spreadsheet: 110431d1307094865-excel-2007-reference-list-of-dates-and-count-back-1-2-or-3-cells-example2
Sheet: Sheet2

 |  |  |  | Australia |  | Malaysia |  | China |  | Turkey |  | Spain |  | Monaco |  | Canada |  | Europe |  | Great-Britain |  | Germany |  | Hungary |  | Belgium |  | Italy |  | Singapore |  | Japan |  | South Korea |  | India |  | UAE |  | Brazil
 | Driver | Team | Engine | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race | Qualifying | Race
 | Sebastien Vettel - (Red Bull) | Red Bull | Renault | Pole | 1st |  | 1st |  | 2nd
 | [NAME]Red Bull) | Red Bull | Renault | 3rd | 5th |  | 4th |  | 3rd
 | [NAME] ([NAME]) | [NAME] | Mercedes | 2nd | 2nd |  | 8th |  | 1st
 | [NAME] - ([NAME]) | [NAME] | Mercedes | 4th | 6th |  | 2nd |  | 4th
 | [NAME] - (Ferrari) | Ferrari | Ferrari | 5th | 4th |  | 6th |  | 7th
 | [NAME]) | [NAME] | Ferrari | 9th | DSQ |  | 7th |  | 10th
 | [NAME] (Renault) | Renault | Renault | 18th | 12th |  | 3rd |  | 12th
 | [NAME]Mercedes) | Mercedes | Mercedes | 7th | DNF |  | 12th |  | 5th
 | [NAME]Renault) | Renault | Renault | 6th | 3rd |  | DNF |  | 9th
 | [NAME]Ferrari) | Ferrari | Ferrari | 8th | 7th |  | 5th |  | 6th
 | [NAME]Toro Rosso) | Toro Rosso | Ferrari | 10th | 8th |  | 13th |  | 14th
 | [NAME] (Mercedes) | Mercedes | Mercedes | 11th | DNF |  | 9th |  | 8th
 | [NAME]) | Force India | Mercedes | 16th | 9th |  | 11th |  | 15th
 | [NAME] - (Force India) | Force India | Mercedes | 14th | 10th |  | 10th |  | 11th
 | [NAME]) | [NAME] | Ferrari | 13th | DSQ |  | DNF |  | 17th
 | [NAME] ([NAME]) | [NAME] | [NAME] | 17th | DNF |  | DNF |  | 13th
 | [NAME]Toro Rosso) | Toro Rosso | Ferrari | 12th | 11th |  | 14th |  | DNF
 | [NAME] (Team Lotus) | Team Lotus | Renault | 20th | 13th |  | DNF |  | 19th
 | [NAME] (Team Lotus) | Team Lotus | Renault | 19th | DNF |  | 15th |  | 16th
 | Pastor Maldonado - ([NAME]) | [NAME] | [NAME] | 15th | DNF |  | DNF |  | 18th
 | [NAME]Virgin) | Virgin | [NAME] | 22nd | 14th |  | DNF |  | 20th
 | [NAME]) | Virgin | [NAME] | 21st | DNF |  | 16th |  | 21st
 | [NAME] - (HRT) | HRT | [NAME] | DNS | DNS |  | DNF |  | 22nd
 | Narain Karthikeyan - (HRT) | HRT | [NAME] | DNS | DNS |  | DNF |  | 23rd
Spreadsheet: 733914d1621883405-copy-and-transpose-formula-auto
Sheet: Payables

I kindly asking for a formula which can automatically transpose data from Auto sheet to Payables  sheet as shown in the desired outcome.
DESIRED OUTCOME
 | ST 002 | Net Salaries
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 7 | 2 |  |  | 0
2021-01-25 00:00:00 | 0 | January |  | 185503.5 | -185503.5
2021-01-26 00:00:00 | 16 | 5 | 6581 |  | -178922.5
2021-01-26 00:00:00 | 17 | 5 | 5793 |  | -173129.5
2021-01-26 00:00:00 | 18 | 5 | 4461 |  | -168668.5
2021-01-26 00:00:00 | 19 | 5 | 7913 |  | -160755.5
2021-01-26 00:00:00 | 20 | 5 | 4953 |  | -155802.5
2021-01-26 00:00:00 | 21 | 5 | 4043 |  | -151759.5
2021-01-26 00:00:00 | 22 | 5 | 4584 |  | -147175.5
2021-01-26 00:00:00 | 23 | 5 | 11043 |  | -136132.5
2021-01-26 00:00:00 | 24 | 5 | 3399 |  | -132733.5
2021-01-26 00:00:00 | 25 | 5 | 4580 |  | -128153.5
2021-01-26 00:00:00 | 26 | 5 | 11134 |  | -117019.5
2021-01-26 00:00:00 | 27 | 5 | 4107 |  | -112912.5
2021-01-26 00:00:00 | 28 | 5 | 4359 |  | -108553.5
2021-01-26 00:00:00 | 29 | 5 | 7929 |  | -100624.5
2021-01-26 00:00:00 | 30 | 5 | 10480 |  | -90144.5
2021-01-26 00:00:00 | 31 | 5 | 9370 |  | -80774.5
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
Spreadsheet: 45070d1243863560-using-boolean-to-compile-knowledge-flags
Sheet: LAMCAR

Country | Sent | Received | Location | Contact | Notes
Argentina
Belize
Bolivia
Brazil
Chili
Colombia
Costa Rica
Cuba
Dominican Republic
Ecuador
El Salvador
Guatemala
Guyana
Haiti
Honduras
Jamaca
Mexico
Nicaragua
Panama
Paraguay
Peru
Puerto Rico
Trinidad
Uruguay
Venezuela
Spreadsheet: 835760d1688799671-rolling-balance-based-on-population-of-cell-book1
Sheet: TEST Sheet

Date | Income Details | £   - P |  | Expenditure Details |  |  | £   - P |  | Balance | Sign
 | [NAME]. | Fwd |  |  |  |  |  |  | 20
2023-07-07 00:00:00 | Payment | 20
2023-07-07 00:00:00 |  |  |  | Withdrawl |  |  | 20
2023-07-14 00:00:00 |  |  |  | Withdrawl |  |  | 2.5
Spreadsheet: 808412d1670444089-produce-duplicate-rows-with-partial-data-from-existing-rows-sample_spreadsheet
Sheet: Sheet1

Item Category | Item Number | Description | On Hand | [NAME] | col F replaces open paren, close paren and comma with | col G replaces duplicate || with | col H on splits text on
FG-M | 1 | Part A | 0
FG-M | 2 | Part B | 1512 | 4-S-2(1504),PRODUCTION(8) |  |  |  | 1504 | PRODUCTION | 8
FG-M | 3 | Part C | 0
FG-M | 4 | Part D | 29112 | 3-R-2(2352),2-R-2(7992),2-S-2(2472),3-R-3(6888),3-S-2(8808),4-R-3(600) |  |  |  | 2352 | 2-R-2 | 7992 | 2-S-2 | 2472 | 3-R-3 | 6888 | 3-S-2 | 8808 | 4-R-3 | 600
FG-M | 5 | Part F | 5282 | 3-R-3(2376),2-R-2(8),2-S-2(360),4-S-3(1200),PACK 1(18),PRODUCTION(1320) |  |  |  | 2376 | 2-R-2 | 8 | 2-S-2 | 360 | 4-S-3 | 1200 | PACK 1 | 18 | PRODUCTION | 1320
FG-M | 6 | Part G | 2904 | 4-S-2(2472),3-R-2(192),PRODUCTION(240) |  |  |  | 2472 | 3-R-2 | 192 | PRODUCTION | 240
FG-M | 7 | Part H | 8839 | 4-S-2(7560),2-R-2(234),2-S-2(1),3-R-3(576),PACK 1(17),PRODUCTION(19),Picked-208-41035(432) |  |  |  | 7560 | 2-R-2 | 234 | 2-S-2 | 1 | 3-R-3 | 576 | PACK 1 | 17 | PRODUCTION | 19 | Picked-208-41035 | 432
FG-M | 8 | Part I | 3236 | 4-S-3(3210),PACK 1(26) |  |  |  | 3210 | PACK 1 | 26
FG-M | 9 | Part J | 1368 | 3-R-2(1224),3-R-3(126),RE-WORK(18) |  |  |  | 1224 | 3-R-3 | 126 | RE-WORK | 18
Spreadsheet: 94997d1294722087-looking-for-formula-or-function-to-reduce-work-time-help-please
Sheet: Notice 3

General Notice Forms
 |  |  |  |  |  | This is what I do
Name: | DATA!B13 |  | Unit: | DATA!A13
Age: | DATA!C13 |  | Rent: | DATA!D13
 |  | Without removing the "=" I insert the next number in the series
 |  | corresponding to the data sheet, in this case change all the 13's to 14
 |  | I do these step for 250+ notices.
 |  | is is possible to speed up my process ?
 |  | lets say the row I want from the DATA tab is "14"
 |  | lets say  the row I want is value "^"
 | Name: | DATA!B^ |  | Unit: | DATA!A^ |  | is it possible to set a cell, then have all my values point to that cell ?
 | Age: | DATA!C^ |  | Rent: | DATA!D^
 |  |  |  | ^=14