tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 015f6bf2-01c2-497e-96e9-c21c09d97704
Sheet: SALES REGISTER INSTRUCTIONS

 |  |  |  |  |  |  | The STR number must appear below EVERY |  |  |  |  | You are not permitted to reference RERA on your website.
 |  |  |  |  |  |  | advertised (weblisting) property. |  |  |  |  | ONLY your apporved Broker ID number.
 |  | SALES REGISTER |  |  |  |  | Sample: | STR: 1815/7055/09/11/0001
Ü | All agreements are to be registered. These include Authorisation from the [NAME] (FORM A), Buyers Agent service agreements (FORM B)
 | Agent to Agent Agreements (FORM I), Form (U) Termination, and [NAME] (FORM F) or the MOU from your office until the forms are formally released)
 | ALL FIELDS ARE TO BE COMPLETED IN THE REGISTER
Ü | The date and time must be inserted.
Ü | The Administrator's [NAME] is for their initial to be inserted. E.g ALWAYS READY would look like |  |  |  |  |  |  |  |  | AR | STR: 1815/7055/09/11/0001
Ü | THE STR number commences as 0001, the next 0002, the next 0003 and so forth. This can go up to 9999.
Ü | On the 1st day of each month restart the number again at 0001.
Ü | The STR number on each agreement [NAME], [NAME], Agent to Agent, Contract must be inserted in the following sequence
Ü | Office Registration Number, Broker ID, Year, Month, STR from your office |  |  |  |  |  |  |  | Sample: | STR: 276/5526/09/11/0001
Ü | DO NOT LEAVE ANY FIELD BLANK. The last cell of each row is completed when either 'expired' or SOLD, or withdrawn.
 | Insert "SOLD" only when sold by your office.
Ü | ALL listings in your office must have the STR allocated. This means every property listed must be reviewed.
Ü | Only properties actually for sale can be on your website or advertised AFTER the Owner has approved and signed an agreement with your office
Spreadsheet: 875765d1722366763-count-and-grouing-the-frequency-occurs-each-month-sample-luna_circle23-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | here's the grouping of how often each member rent the car each month
Card No | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | every | 1month | 2 months | 3months | 4months | 5months | 6months | 7months | 8months | 9months | 10months | 11months
30191096 | 1 |  | 1 | 1 | 1 |  | 1 |  | 1 | 1 |  | 1
30231923 | 1 | 1 | 1 |  |  |  | 1 | 1 |  | 1 | 1 | 1
30200159 | 1 | 1 | 1 | 1 |  |  |  | 1 |  | 1
30262978 |  |  | 1 |  | 1 | 1 | 1 | 1 | 1
30216273 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 |  | 1
34754977 | 1 | 1 |  |  |  | 1 | 1 |  |  | 1
30174087 | 1 |  |  |  | 1 | 1 | 1 |  |  | 1
30222860 | 1 | 1 | 1 |  | 1 |  |  |  | 1
30247573 | 1 | 1 | 1 |  | 1 |  |  |  | 1
30257573 |  |  | 1 |  |  |  |  | 1
30516273 | 1 |  |  |  |  |  |  |  |  |  |  | 1
30216573 | 1 | 1 |  |  |  |  |  |  | 1
30191096 |  |  |  |  |  |  |  |  |  |  |  |  |  | Is there any work arround to fill this with formula? (the calcullation in grouping part)
30231923 |  |  |  |  |  |  |  |  |  |  |  |  |  | first "1" every month without color indicates first time member rent the car
30200159 |  |  |  |  |  |  |  |  |  |  |  |  |  | the color indicates the interval, how often member rent the car, eg, every 1 month this color
30262978
30216273
34754977
30174087
30222860
30247573
30257573
30516273
30216573
Spreadsheet: 014b3af6-c3da-4a2b-a2a5-c2b436e03bfc
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
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 7. GOODS CREDITS, Trend estimates, Current prices
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
Total goods credits ; |  |  | Trend | A2718657A | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
General merchandise ; |  |  | Trend | A2718658C | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Rural goods ; |  |  | Trend | A2718660R | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Meat and meat preparations ; |  |  | Trend | A2718661T | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Cereal grains and cereal preparations ; |  |  | Trend | A2718663W | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Wool and sheepskins ; |  |  | Trend | A2718664X | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Other rural ; |  |  | Trend | A2718666C | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Non-rural goods ; |  |  | Trend | A2718667F | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Metal ores and minerals ; |  |  | Trend | A2718668J | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Coal, coke and briquettes ; |  |  | Trend | A2718669K | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Other mineral fuels ; |  |  | Trend | A2718670V | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Metals (excl. non-monetary gold) ; |  |  | Trend | A2718671W | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Machinery ; |  |  | Trend | A2718672X | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Transport equipment ; |  |  | Trend | A2718673A | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Other manufactures ; |  |  | Trend | A2718675F | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Other non-rural (incl. sugar and beverages) ; |  |  | Trend | A2718676J | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Goods procured in ports by carriers ; |  |  | Trend | A2718678L | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Net exports of goods under merchanting ; |  |  | Trend | A2718679R | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
Non-monetary gold ; |  |  | Trend | A2718682C | 1971-07-01 00:00:00 | 2012-03-01 00:00:00 | 489 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: f1fd4587-49d8-418e-a43d-e52f5078bf75
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688873820 | For King & Country | Middle Of Your Heart | 2013-06-09 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Fervent Records | 80688877323 | For King & Country | Hope Is What We Crave : Live | 2013-08-27 | Compact Disc With DVD | Ac | 13.99 | Y | Available
Fervent Records | 80688872922 | For King & Country | Into The Silent Night: The Ep | 2013-10-22 | Compact Disc | Ac | 4.99 | Y | Available
Fervent Records | 80688879525 | For King & Country | Crave (Re-Release) | 2013-08-27 | Compact Disc | Ac | 13.99 | Y | Available
Fervent Records | 80688885229 | For King & Country | Little [NAME] | 2013-12-03 | Studio Series 3-Key CD Trax | Christmas | 9.99 | Y | Available
Word Records | 80688857325 | For King & Country | Proof Of Your Love | 2012-09-04 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688857424 | For King & Country | [NAME] (Hold On To Me) | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Spreadsheet: kate_symes__18593__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 699280d1602518086-countif-unless-value-of-cell-is-to-text-test-countif
Sheet: Test

 |  |  | Ω 1kft | Ω 1ft
FACP 1-1 | [NAME] | 12
Device ID | SRL15 | SRL15 | P2RL15 | SRL15 | P2RL15 | P2RL110 | SRL110 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | FACP 1-1 Counts
Wire Length | 35 | 20 | 35 | 42 | 30 | 10 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SRL15 | P2RL15 | P2RL110 | SRL110 | N/A | N/A
Device Amps
Resistance Ω
Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | WIRE   LENGTH | Amps | Volts  Drop | Ohms Ω |  |  |  |  |  |  |  |  |  | Starting Volts |  | 20.4 | EOL VOLTS
Spreadsheet: 51591d1251235426-auto-increment-from-linked-formula-problem-sample
Sheet: Sheet2

Name | Date | Increase By | 3
A | Good Data 1 | 0
B | Good Data 2 | 3
C | Good Data 3 | 6
E | Good Data 4 | 9
F | Good Data 5 | 12
G | Good Data 6 | 15
Spreadsheet: 767041d1644253252-what-would-cause-excel-to-pause-its-calcs-when-it-is-set-to-automatic-livecards
Sheet: Dodgers

Hitters |  |  | Pitchers
UIG | NAME |  | UIG | NAME
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 12b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending May 24, by product type and supermajor currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 840887d1693120216-return-split-values-in-a-dynamic-range-and-include-blanks-split-text-example
Sheet: Sheet1

Name |  | Current Result
[NAME] |  |  | [NAME] |  |  |  |  |  | [NAME]
Hortensia Gaius Aurelia Valentina Maximilla |  | Hortensia | Gaius | Aurelia | Valentina | [NAME] |  | Hortensia | Gaius | Aurelia | Valentina | [NAME]
 |  |  |  |  |  |  |  | Olivia | [NAME]
[NAME] |  | Olivia | [NAME] |  |  |  |  | [NAME] | de | la | Cruz
[NAME] |  | [NAME] | de | la | Cruz |  |  | Juan | Martin | Hernandez
 |  |  |  |  |  |  |  | Ava | [NAME]
[NAME] |  | Juan | Martin | Hernandez |  |  |  | [NAME] | White
[NAME] |  | Ava | [NAME] |  |  |  |  | Charlotte | [NAME]
[NAME] |  | [NAME] | White
[NAME] |  | Charlotte | [NAME]
Spreadsheet: 881944d1730194339-full-workbook-lookup-form-test-wip
Sheet: Company 2

CATERGORY : BREAD
Item | Weight/Quantity | SUPPLIER CODE | RJL CODE | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00
BLUE BAG WHITE DTIN 17+2 (SINGLE) | 800G | 23015 | BRS29 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1 | 1 | 1
CTR WHITE | 800G |  |  |  |  |  | 1.12 | 1.12
FSR LONG LOAF WHITE 19+2 | 800G | 20110 |  |  |  |  |  |  |  |  |  |  | 0.95
FSR LONG LOAF MALTED 19+2 | 800G | 20140 |  |  |  |  |  |  |  |  |  |  | 0.99
FSR LONG LOAF WHOLEMEAL 19+2 | 800G | 20170 |  |  |  |  |  |  |  |  |  |  | 0.95
Spreadsheet: 0b0e7a2c-31bd-42ef-b7cc-17a629e7462a
Sheet: import success seats

Row Labels | FA11 | SP12 | Grand Total | 0 | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 010 | 011 | 012 | 013 | 014 | 015 | 016 | 017 | 018 | 019 | 020 | 021
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
Sum of Count
Row Labels
ART | 16 | 11 | 27
ASL | 20 | 20 | 40
BIOL |  | 26 | 26
ENGL | 135 | 107 | 242
ENVS | 28 |  | 28
HIST | 25 | 24 | 49
MATH | 186 | 167 | 353
MUL | 38 |  | 38
PSYC | 36 | 14 | 50
SPAN | 93 | 90 | 183
Grand Total | 577 | 459 | 1036
Spreadsheet: hunter_shively__12668__Nov_01 Volume Changes
Sheet: Nov 6

Pipeline | Producer | Zone | Current Volume | New Volume | Change | Index | GDA
TENN | Torch | Zone 100 | 0 | 50 |  |  | 50
TENN | [NAME] | Zone 800 | 550 | 625 |  |  | 75
TETCO | W&T | WLA | 2382 | 2600 |  | 218
TRNKL | Forest | ELA | 6700 | 6400 |  |  | -300
TRNKL | Stone | ELA | 625 | 730 |  | 105
TRNKL | Forest | ELA | 16750 | 22250 |  |  | 5500
 |  |  |  |  | Daily Total
 |  |  |  |  | MTD Total | -15061 | 5873
Spreadsheet: 135692d1326189319-connections-or-import-local
Sheet: Sheet2

 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 685813d1594211544-how-to-show-the-values-on-pivot-table-context-answer
Sheet: Sheet3

Col.1 | Col.2 |  | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 |  |  |  |  | Col.1 | Col.2
1-2 | 1-2 |  |  |  |  |  |  |  |  |  |  |  |  | 1-2 | 1-2
1-2 | 1-b2 |  |  |  |  |  |  |  |  |  |  |  |  | 2-3 | 1-b2
1-2 | 1-#2 |  |  |  |  |  |  |  |  |  |  |  |  | 3-4 | 1-#2
2-3 | 2-b3 |  |  |  |  |  |  |  |  |  |  |  |  | 4-5 | 2-b3
2-3 | 2-3 |  |  |  |  |  |  |  |  |  |  |  |  | 5-6 | 2-3
2-3 | 2-#3 |  |  |  |  |  |  |  |  |  |  |  |  | 6-7 | 2-#3
2-3 | b2-b3 |  |  |  |  |  |  |  |  |  |  |  |  | 7-8 | b2-b3
2-3 | b2-3 |  |  |  |  |  |  |  |  |  |  |  |  |  | b2-3
2-3 | b2-#3 |  |  |  |  |  |  |  |  |  |  |  |  |  | b2-#3
2-3 | #2-b3 |  |  |  |  |  |  |  |  |  |  |  |  |  | #2-b3
2-3 | #2-3 |  |  |  |  |  |  |  |  |  |  |  |  |  | #2-3
2-3 | #2-#3 |  |  |  |  |  |  |  |  |  |  |  |  |  | #2-#3
3-4 | 3-b4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3-b4
3-4 | 3-4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3-4
3-4 | 3-#4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3-#4
3-4 | b3-b4 |  |  |  |  |  |  |  |  |  |  |  |  |  | b3-b4
3-4 | b3-4 |  |  |  |  |  |  |  |  |  |  |  |  |  | b3-4
3-4 | b3-#4 |  |  |  |  |  |  |  |  |  |  |  |  |  | b3-#4
3-4 | #3-b4 |  |  |  |  |  |  |  |  |  |  |  |  |  | #3-b4
3-4 | #3-4 |  |  |  |  |  |  |  |  |  |  |  |  |  | #3-4
3-4 | #3-#4 |  |  |  |  |  |  |  |  |  |  |  |  |  | #3-#4
4-5 | 4-b5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4-b5
4-5 | 4-5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4-5
4-5 | 4-#5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4-#5
4-5 | b4-b5 |  |  |  |  |  |  |  |  |  |  |  |  |  | b4-b5
4-5 | b4-5 |  |  |  |  |  |  |  |  |  |  |  |  |  | b4-5
4-5 | b4-#5 |  |  |  |  |  |  |  |  |  |  |  |  |  | b4-#5
4-5 | #4-b5 |  |  |  |  |  |  |  |  |  |  |  |  |  | #4-b5
4-5 | #4-5 |  |  |  |  |  |  |  |  |  |  |  |  |  | #4-5
4-5 | #4-#5 |  |  |  |  |  |  |  |  |  |  |  |  |  | #4-#5
5-6 | 5-b6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5-b6
5-6 | 5-6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5-6
5-6 | 5-#6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5-#6
5-6 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
5-6 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
5-6 | b5-#6 |  |  |  |  |  |  |  |  |  |  |  |  |  | b5-#6
5-6 | #5-b6 |  |  |  |  |  |  |  |  |  |  |  |  |  | #5-b6
5-6 | #5-6 |  |  |  |  |  |  |  |  |  |  |  |  |  | #5-6
5-6 | #5-#6 |  |  |  |  |  |  |  |  |  |  |  |  |  | #5-#6
6-7 | 6-b7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-b7
6-7 | 6-7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-7
6-7 | 6-#7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-#7
6-7 | b6-b7 |  |  |  |  |  |  |  |  |  |  |  |  |  | b6-b7
6-7 | b6-7 |  |  |  |  |  |  |  |  |  |  |  |  |  | b6-7
6-7 | b6-#7 |  |  |  |  |  |  |  |  |  |  |  |  |  | b6-#7
6-7 | #6-b7 |  |  |  |  |  |  |  |  |  |  |  |  |  | #6-b7
6-7 | #6-7 |  |  |  |  |  |  |  |  |  |  |  |  |  | #6-7
6-7 | #6-#7 |  |  |  |  |  |  |  |  |  |  |  |  |  | #6-#7
7-8 | 7-8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7-8
7-8 | b7-8 |  |  |  |  |  |  |  |  |  |  |  |  |  | b7-8
7-8 | #7-8 |  |  |  |  |  |  |  |  |  |  |  |  |  | #7-8
Spreadsheet: 123751d1317836378-report-of-columns-based-on-a-list-of-data-contractid
Sheet: Sheet1

List of ContractID's and Action
Action | ContractID
Amend and Extend | CntrctID1
Amend wout Extend | CntrctID2
Supersede | CntrctID3
Supersede | CntrctID4
Amend and Extend | CntrctID5
Leave Intact | CntrctID6
Supersede | CntrctID7
From the List above, can I create a report that looks like this? |  |  |  |  | I prefer not to do it this way
ContractID
Supersede | Amend and Extend | Amend wout Extend | Leave Intact |  | Row Labels
CntrctID3 | CntrctID1 | CntrctID2 | CntrctID6 |  | Amend and Extend
CntrctID4 | CntrctID5 |  |  |  | CntrctID1
CntrctID7 |  |  |  |  | CntrctID5
 |  |  |  |  | Amend wout Extend
 |  |  |  |  | CntrctID2
 |  |  |  |  | Leave Intact
 |  |  |  |  | CntrctID6
 |  |  |  |  | Supersede
 |  |  |  |  | CntrctID3
 |  |  |  |  | CntrctID4
 |  |  |  |  | CntrctID7
 |  |  |  |  | Grand Total
Spreadsheet: 143584d1330467424-look-up-a-value-with-multiple-criteria-theoretically-should-be-a-simple-index-match-excel-forum-example2-modified-by-tigeravatar-
Sheet: BF Schedule

 |  | 08:00:00 | 08:30:00 | [NAME] | BECKY | [NAME] | COLTON | JULIE | MIKE R | LESLIE | SHERRI | SAMIA | OTHER
Saturday | 2012-02-18 00:00:00
Sunday | 2012-02-19 00:00:00
Monday | 2012-02-20 00:00:00
Tuesday | 2012-02-21 00:00:00
Wednesday | 2012-02-22 00:00:00
Thursday | 2012-02-23 00:00:00
Friday | 2012-02-24 00:00:00
Saturday | 2012-02-25 00:00:00
Sunday | 2012-02-26 00:00:00
Monday | 2012-02-27 00:00:00
Tuesday | 2012-02-28 00:00:00
Wednesday | 2012-02-29 00:00:00
Thursday | 2012-03-01 00:00:00
Friday | 2012-03-02 00:00:00
Saturday | 2012-03-03 00:00:00
Sunday | 2012-03-04 00:00:00
Monday | 2012-03-05 00:00:00
Tuesday | 2012-03-06 00:00:00
Wednesday | 2012-03-07 00:00:00
Thursday | 2012-03-08 00:00:00
Friday | 2012-03-09 00:00:00
Saturday | 2012-03-10 00:00:00
Sunday | 2012-03-11 00:00:00
Monday | 2012-03-12 00:00:00
Tuesday | 2012-03-13 00:00:00
Wednesday | 2012-03-14 00:00:00
Thursday | 2012-03-15 00:00:00
Friday | 2012-03-16 00:00:00
Spreadsheet: 774986d1648748977-look-up-and-retrieve-pivot-example
Sheet: Data

ID # | Team A Maintenance Hours | Team B Maintenance Hours | Month
[NAME] | 12.1 | 0 | 2022-01-01 00:00:00
L2541 | 24.5 | 12 | 2022-01-01 00:00:00
[NAME] | 78.9 | 100.2 | 2022-01-01 00:00:00
FE775 | 154.5 | 40.2 | 2022-01-01 00:00:00
AS787 | 0 | 24.1 | 2022-01-01 00:00:00
OP741 | 1 | 0 | 2022-01-01 00:00:00
LR456 | 0 | 1 | 2022-01-01 00:00:00
FG421 | 47.3 | 11 | 2022-01-01 00:00:00
[NAME] | 55 | 76.1 | 2022-01-01 00:00:00
DF456 | 32.4 | 22.8 | 2022-01-01 00:00:00
[NAME] | 95.5 | 0 | 2022-01-01 00:00:00
[NAME] | 32 | 0 | 2022-02-01 00:00:00
FE775 | 44 | 44 | 2022-02-01 00:00:00
AS787 | 55 | 64 | 2022-02-01 00:00:00
OP741 | 63 | 4 | 2022-02-01 00:00:00
FD988 | 365 | 3 | 2022-02-01 00:00:00
GG987 | 44.5 | 21 | 2022-02-01 00:00:00
GG984 | 87.5 | 33 | 2022-02-01 00:00:00
GG447 | 45.7 | 0 | 2022-02-01 00:00:00
OP456 | 87 | 57 | 2022-02-01 00:00:00
GG984 | 23.2 | 45 | 2022-03-01 00:00:00
GG447 | 45.5 | 77 | 2022-03-01 00:00:00
OP456 | 78.8 | 105.2 | 2022-03-01 00:00:00
HT444 | 4.4 | 78.4 | 2022-03-01 00:00:00
[NAME] | 3 | 14 | 2022-03-01 00:00:00
WE123 | 0 | 12 | 2022-03-01 00:00:00
WR144 | 0 | 54 | 2022-03-01 00:00:00
Spreadsheet: 0b4656b9-c1bb-47eb-94c4-648c828f7769
Sheet: Year

Month | Program Features |  |  | Troop Outdoor/ Camping Activity | District/ Council Activity | Chartered Organization Dates Charter Renewal Charter Presentation Service Project | Special Events/ Holidays | (For Troop Use) | Board of Review | Leaders' Meeting
 | New Scout  Patrol | Experienced Scouts | Venture Patrol |  |  |  |  |  | Court of Honor | Patrol Leaders' Council | Troop Committee | District/Council Roundtable/ Training
Sep
[NAME]
Nov
[NAME]
Jan.
Feb
[NAME]
Apr
May
[NAME]
[NAME]
Aug
Spreadsheet: 863695d1711099736-manual-data-to-be-able-to-auto-tag-base-on-table-report-6-aligw
Sheet: Report

Customer | Invoice | Amount | Comment |  |  |  | Customer | Invoice | Amount | Comment
 | #1 | 1 | Payment OTW |  | * the comment (Column D) is manually type in by ops |  |  | #1 | 1 | Payment OTW
ABC | #2 | 2 | To issue Credit note |  | However if I update the table, the Comment wont sync since it’s manual. |  | ABC | #2 | 2 |  | <---This should not have Comment
ABC | #3 | 3 |  |  |  |  | ABC | #3 | 3
BDC | #4 | 4 |  |  | Is there a way to solve this??? |  | BDC | #4 | 4 | Customer to double Confirm amount | <---Comment Should be D6
ZZZ | #5 | 5 | Customer to double Confirm amount |  |  |  | ZZZ | #5 | 5 | Payment OTW | <---Comment Should be D8
YYY | #6 | 6 |  |  |  |  | YYY | #6 | 6
YYY | #7 | 7 | Payment OTW |  |  |  | YYY | #7 | 7 |  | <---This should not have Comment