tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 00637958-bcd4-4f60-868d-28f3a02907fd
Sheet: Categories by Region

VOC Categories by Region
Category | EPA | OTC | CARB 2003 | SCAQMD | Canada | Maricopa County, AZ | CARB 2007* | LADCO*
Flat | 250 | 50 | 100 | 50 | 100 | 250 | 50 | 100
Nonflat | 380 | 100 | 150 | 50 | 150 | 380 | 100 | 150
High Gl.Nonflat | 380 | 150 | 250 | 50 | 250 | 380 | 150 | 250
Industrial Maint. | 450 | 250 | 250 | 100 | 340 | 420 | 250 | 340
Rust Preventative | 400 | 250 | 400 | 100 | 400 | 400 | 250 | 400
Traffic Marking | 150 | 100 | 150 | 100 | 450 | 150 | 100 | 150**
[NAME] | 400 | 100 | 250 | 50 | 250 | 400 | 100 | 250
High Temp | 650 | 420 | 420 | 420 | 420 | 650 | 420 | 420
Metallic | 500 | 500 | 500 | 150 | 500 | 500 | 500 | 500
Exterior Stains | 550 | 250 | 250 | 100 | 250 | 550 | 250 | 250
Primer | 350 | 100 | 200 | 100 | 200 | 350 | 100 | 200
Primer, [NAME] | 350 | 100 | 200 | 100 | 350 | 350 | 100 | 200
[NAME] | 350 | 100 | 350 | 100 | 350 | 350 | 100 | 350
[NAME] | 450 | 100 | 200 | 100 | 350 | 350 | 100 | 200
[NAME] | 150 | 50 | 150 | 50 | 150 | 150 | 50 | 150
Consumer Solvent | Exempt | 0.03 | 0.03 | 25 | Exempt | Exempt | 0.03 | Exempt
Con. Paint Thinner | Exempt | 0.03 | 0.03 | 25 | Exempt | Exempt | 0.03 | Exempt
WB colorant | Exempt | Exempt | Exempt | 50 | Exempt | Exempt | Exempt | Exempt
[NAME] | 600 | 340 | 340 | 340 | 340 | 600 | 340 | 340
* See regional list for participating areas |  |  |  |  |  |  |  | updated 5.13.14
** In Indiana only - Non-Ozone season - 150 but in Ozone season (May 1- September 30) the limit is 105
Spreadsheet: 876767d1723496537-help-schedule-problem-pulling-task-and-revert-back-to-am-or-pm-weekly_employee_schedule_template
Sheet: Cashiers Solo

 | SCHEDULE
 | NAME:
 |  | Start | Breaks | End | Hours
 | Sunday
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | TOTAL HOURS
Spreadsheet: 593708d1539283464-sumifs-formula-variation-help-vat-1-
Sheet: VAT summary

 |  |  | Month | Quarter | Year
 |  |  | November 2018 | Q32018 | 2018
 |  | [NAME]
 |  | Sales |  |  | Net | VAT | Gross
 |  |  |  |  | € | € | €
 |  | VATable | BURC | 2018-10-01 00:00:00 |  |  | 0
 |  | NonVATable | 0-VAT | 2018-10-01 00:00:00 |  |  | 0
 |  | Purchases |  |  | Net | VAT | Gross
 |  |  |  |  | € | € | €
 |  | VATable | Standard rated | 2018-10-01 00:00:00 | 0 | 0 | 0
 |  | Reverse Charge |  | 2018-10-01 00:00:00 | 0 | 0 | 0
Spreadsheet: 700024d1602906870-formula-to-extract-data-based-on-month-and-year-extract-profits
Sheet: Source Data

 | Oct 2019 | Nov 2019 | Dec 2019 | Jan 2020 | Feb 2020 | Mar 2020 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00
Dept1 | 1372 | 24256 | -2214 | 16883 | 5766 | 72022 | 85015 | 60125 | -22145 | 45125 | 30185 | 90358
Dept2 | 20762.74933333333 | 25353.09333333333 | 29764.506 | 16542.99333333334 | 20720.564 | 1593.458 | 6826.338266666667 | 3313.036628571427 | -200.2650095238427 | -3713.56664761904 | -7226.868285714333 | -10740.16992380953
Dept3 | 15442.94033333333 | 17228.84733333333 | 16793.18266666667 | 21141.468 | 16698.47933333333 | 16818.52233333333 | 18317.4158 | 18592.70412380953 | 18867.99244761907 | 19143.2807714286 | 19418.56909523806 | 19693.8574190476
Dept4 | 24686.335 | 27093.99566666667 | 22422.78966666667 | 18538.71766666667 | 15402.05133333333 | 24938.53266666667 | 18410.512 | 17333.40009523813 | 16256.2881904762 | 15179.17628571433 | 14102.0643809524 | 13024.95247619053
Spreadsheet: 853422d1703271014-auto-populating-formulas-and-data-validation-based-on-1-cells-data-validation-result-sample-1
Sheet: Calculations

HS | Boards | SQFT | [NAME] = sign when pasting
No Smoothing | 90 | 2880 | (((F4*G4)/144)*E4)/(IF(J4=Calculations!$A2,Calculations!$C$2,IF(J4=Calculations!$A$3,Calculations!$C$3,IF(J4=Calculations!$A$4,Calculations!$C$4,IF(J4=Calculations!$A$5,Calculations!$C$5,IF(J4=Calculations!$A$6,Calculations!$C$6,IF(J4=Calculations!$A$7,Calculations!$C$7)))))))*I4+0.2
Light Smoothing | 60 | 1920
Heavy Smoothing | 40 | 1280
[NAME] | 30 | 960
[NAME] | 20 | 640
[NAME] | 15 | 480
[NAME] |  |  | [NAME] = sign when pasting
2 Pass |  | 2880 | (((F7*G7)/144)*E7)/(IF(J7=Calculations!$A$11,Calculations!$C$11,IF(J7=Calculations!$A$12,Calculations!$C$12,IF(J7=Calculations!$A$13,Calculations!$C$13,IF(J7=Calculations!$A$14,Calculations!$C$14,IF(J7=Calculations!$A$15,Calculations!$C$15,IF(J7=Calculations!$A$16,Calculations!$C$16,IF(J7=Calculations!$A$17,Calculations!$C$17,IF(J7=Calculations!$A$18,Calculations!$C$18,IF(J7=Calculations!$A$19,Calculations!$C$19,IF(J7=Calculations!$A$20,Calculations!$C$20,IF(J7=Calculations!$A$21,Calculations!$C$21)))))))))))))*I4+0.2
3 Pass |  | 1920
4 Pass |  | 1280
Backlit |  | 960
DS |  | 960
FU or [NAME] |  | 640
DS White |  | 480
8 Pass |  | 180
8 Pass + White |  | 120
5 Layer |  | 240
 |  | 640
3Rs | SQFT |  | [NAME] = sign when pasting
2 Pass | 1784 |  | (((F4*G4)/144)*E4)/(IF(J4=Calculations!$A$24,Calculations!$B$24,IF(J4=Calculations!$A$25,Calculations!$B$25,IF(J4=Calculations!$A$26,Calculations!$B$26,IF(J4=Calculations!$A$27,Calculations!$B$27,IF(J4=Calculations!$A$28,Calculations!$B$28))))))*I4+0.2
3 Pass | 1254
5-Pass | 704
Backlit | 241
2-Sided | 330
GS | Boards | SQFT | [NAME] = sign when pasting
Light Smoothing | 25 | 800 | (((F5*G5)/144)*E5)/(IF(J5=Calculations!$A$11,Calculations!$C$11,IF(J5=Calculations!$A$12,Calculations!$C$12,IF(J5=Calculations!$A$13,Calculations!$C$13,IF(J5=Calculations!$A$14,Calculations!$C$14,IF(J5=Calculations!$A$15,Calculations!$C$15,IF(J5=Calculations!$A$16,Calculations!$C$16,IF(J5=Calculations!$A$17,Calculations!$C$17))))))))*I5+0.2
Heavy Smoothing | 15 | 480
[NAME] | 10 | 320
[NAME] | 10 | 320
[NAME] | 6 | 192
#REF! | gs
#REF! | hs
#REF! | 3r
#REF! | tauro
Spreadsheet: 874150d1720714774-need-to-unmerge-cell-to-single-cell-data
Sheet: Sheet1

Region | State |  |  | OUTPUT
Central | Illinois |  |  | Central | Illinois Indiana Iowa Kansas Michigan Minnesota Missouri
 | Indiana
 | Iowa
 | Kansas
 | Michigan
 | Minnesota
 | Missouri |  |  | Central | Connecticut Delaware District of Columbia Manie Maryland
East | Connecticut
 | Delaware
 | District of Columbia
 | Maine
 | Maryland
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 3-3 Night

 | CR1 | Priority | Headcount | Priority
1 | Alinity RV | High | 0.25 | x
2 | Alinity RV | High | 0.25 | x
3 | Alinity RV | High | 0.25 | x
4 | Alinity RV | High | 0.25 | x
5 | Alinity RV | High | 0.25 | x
12 | Baxter neck | Low
13 | [NAME] | High | 0.25 | x
9 | Architect RV | High | 0.25 | x
15 | [NAME] | High | 0.5 | x
16 | Architect RV | High | 0.25 | x
17 | Alinity RV | High | 0.25 | x
50 | Baxter SIV Assy
31 | Architect RV | High | 0.25 | x
8 | Alinity RV | High | 0.25 | x
10 | Architect RV | High | 0.25 | x
11 | [NAME] | Low | 0.25
18 | Architect RV | High | 0.25 | x
19 | Architect RV | High | 0.25 | x
20 | Base sleeve | Med/High | 2 | x
21 | Architect RV
22 | Architect RV | High | 0.25 | x
23 | Architect RV | High | 0.25 | x
30 | Architect RV | High | 0.25 | x
7 | Architect SC | Low
Total
 | CR2 | Priority
71 | PP4 | High | 0.25 | x
72 | 8ul | High | 0.25 | x
73 | PP1 | High | 0.25 | x
74 | 6ul | High | 0.25 | x
76 | PP3 ES
77 | Base Cassette | High | 1 | x
78 | Side Cassette B | High | 0.25 | x
79 | [NAME] | High | 0.25 | x
87 | Top Frame A | High | 0.25 | x
52 | Architect RV | High | 0.25 | x
53 | Architect RV | High | 0.25 | x
54 | Siemens KS860 | High | 0.5 | x
59 | Architect RV | High | 0.25 | x
61 | [NAME] trays | High | 0.5 | x
66 | [NAME] | High | 0.5 | x
83 | Ceph OM#1
84 | Ceph MB#1
86 | [NAME] | Med/High
62 | NP227 | Low
63 | NP Birdcage
64 | Siemens 1ML
67 | [NAME] | High | 0.25 | x
69
88 | Side Pump | High | 0.25 | x
89 | Top Frame B | High | 0.25 | x
95 | Beckman Unicel E | Low
96 | Beckman Unicel F | Low
106
107 | Snap Ring
108 |  |  | 0.25 | x
109 | [NAME]
Total
 | [NAME] |  | 1.25
 | [NAME] |  | 1
Spreadsheet: 271846d1382084769-how-to-extract-data-from-a-list-0a1sample-sheet
Sheet: RESULT

[NAME] | qty | sell | who | date | week | Period | Value
B4W2MP | 90 | 1.65 | TOOLSTA | 2013-01-03 00:00:00 | 1 | P1 | 148.5 |  |  | B4W2MP |  |  |  |  |  |  |  | C41010
B4W2MP | 450 | 1.65 | TOOLSTA | 2013-01-03 00:00:00 | 1 | P1 | 742.5 |  |  |  |  |  |  |  |  |  |  | CR5013
B4W2MP | 30 | 1.55 | BANNH02 | 2013-01-03 00:00:00 | 1 | P1 | 46.5 |  |  |  |  |  |  |  |  |  |  | RCDAWC
B4W2MP | 30 | 1.69 | BRACKENH | 2013-01-07 00:00:00 | 2 | P1 | 50.7 |  |  |  |  |  |  |  |  |  |  | MPIT1C-DX
B4W2MP | 420 | 1.75 | TOOLSTA | 2013-01-08 00:00:00 | 2 | P1 | 735 |  |  |  |  |  |  |  |  |  |  | E61G2B
B4W2MP | 60 | 1.87 | HOMEHARD | 2013-01-08 00:00:00 | 2 | P1 | 112.2 |  |  |  |  |  |  |  |  |  |  | MPIT3C-DX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SW3FAD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DT4B1C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E41513-X
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAUSBC-AP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B4W2MP
Spreadsheet: 876179d1722860781-quote-template-help-quote-template-05_08_24
Sheet: Pack01

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  | (COMPLEXITY LEVEL →) |  | LEVEL 1 | LEVEL 2 | LEVEL 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO |  | (BAND DESCRIPTION) | BAND | HOURS | HOURS | HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 TO 6 HOLES | A | 2.75 | 3 | 3.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 TO 12 HOLES | B | 2.25 | 2.5 | 2.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 TO 20 HOLES | C | 1.75 | 2 | 2.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 TO 30 HOLES | D | 1.25 | 1.5 | 1.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 TO 50 HOLES | E | 1 | 1.25 | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 TO 100 HOLES | F | 0.75 | 1 | 1.25
 |  | CENTRE FUSE DRILL TOOL QUOTE PACK 01
QUOTE PACK | TOOL NUMBER | TOOL [NAME] | NO# DRILL BARS LH | NO# DRILL BARS RH | LH/RH | ITEM NUMBER | NUMBER HOLES | COMPLEXITY | PINS | BARREL NUTS | STORAGE CASE | BAE COMMENTS |  | Hours | Hrs Cost | Material | Total Cost | Sub Con Comment
1 | ZRDXXXXXX | XXXXXXXXXXXX |  |  |  |  |  | LEVEL 1 TO 3 | TOTAL NUMBER | TOTAL NUMBER | YES
 |  |  | 1 |  | LH | 1 | 35 | LEVEL 1 |  |  |  |  |  |  |  | 150
 |  |  |  | 1 | RH | 1 | 35 | LEVEL 1 |  |  |  |  |  | 35 |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  | PINS/ BUSHES & STORAGE CASE TOTALS
Spreadsheet: 882450d1730834035-combo-box-form-control-bounce1
Sheet: Sheet1

 |  | Standard |  | Standard
 |  | Flat |  | Flat |  |  |  |  |  | 8
 |  | Full |  | Full
 |  | Scope |  | Scope
 |  | Standard |  | Ultra
 |  | Flat |  | Wide
 |  | Full |  | Ultra Wide
 |  | Scope
 |  | Standard
 |  | Flat
 |  | Full
 |  | Scope
 |  | Standard
 |  | Flat
 |  | Full
 |  | Scope
 |  | Ultra
 |  | Ultra
 |  | Wide
 |  | Ultra Wide
 |  | Flat
 |  | Full
 |  | Scope
Spreadsheet: 835988d1689012916-how-many-employees-were-there-in-that-month-last-year-book3-15-
Sheet: Sheet1

 |  | START DATE | LEAVING DATE |  |  |  | Number of people employed at the end of this month | [NAME] | [NAME] | [NAME] | Adapted Sol A
 |  | 2020-12-01 00:00:00 |  |  |  | 2021-01-01 00:00:00 | 3
 |  | 2020-12-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 | 5
 |  | 2021-01-10 00:00:00 | 2021-06-07 00:00:00 |  |  | 2021-03-01 00:00:00 | 6
 |  | 2021-02-10 00:00:00 | 2021-10-01 00:00:00 |  |  | 2021-04-01 00:00:00 | 6
 |  | 2021-02-22 00:00:00 |  |  |  | 2021-05-01 00:00:00 | 5
 |  | 2021-03-14 00:00:00 | 2021-05-02 00:00:00 |  |  | 2021-06-01 00:00:00 | 6
 |  | 2021-06-03 00:00:00 |  |  |  | 2021-07-01 00:00:00 | 7
 |  | 2021-06-05 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 7
 |  | 2021-07-04 00:00:00 |  |  |  | 2021-09-01 00:00:00 | 7
 |  |  |  |  |  | 2021-10-01 00:00:00 | 6
 |  |  |  |  |  | 2021-11-01 00:00:00
 |  |  |  |  |  | 2021-12-01 00:00:00
 |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  |  | 2022-03-01 00:00:00
 |  |  |  |  |  | 2022-04-01 00:00:00
 |  |  |  |  |  | 2022-05-01 00:00:00
 |  |  |  |  |  | 2022-06-01 00:00:00
 |  |  |  |  |  | 2022-07-01 00:00:00
 |  |  |  |  |  | 2022-08-01 00:00:00
 |  |  |  |  |  | 2022-09-01 00:00:00
 |  |  |  |  |  | 2022-10-01 00:00:00
 |  |  |  |  |  | 2022-11-01 00:00:00
 |  |  |  |  |  | 2022-12-01 00:00:00
 |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  | 2023-06-01 00:00:00
Spreadsheet: barry_tycholiz__825__Financial Products
Sheet: Sheet1

Financial Products
AECO (Cowan)
 | Fixed vs Daily ROM
 | Fixed vs Daily Prompt
 | Financial Daily Basis Prompt
 | Financial Daily Basis Prompt + 1 month
AECO Basis ([NAME])
 | 2002-01-01 00:00:00
 | Jan-02 - Mar-02
 | Jan-02 - Dec-02
 | Apr-02 - Oct-02
 | Nov-02 - Mar-03
 | Apr-03 - Oct-03
AECO Options (Disturnal)
AECO Straddles
 | Prompt
 | Prompt +1
 | Prompt +2
 | Apr-02 - Oct-02
 | Nov-02 - Mar-03
 | Apr-03 - Oct-03
Sumas Basis (Dorland)
 | Q1 02
 | Apr-02 - Oct-02
 | Nov-02 - Mar-03
 | Apr-03 - Oct-03
Sumas ([NAME])
 | Dec Sumas Fixed Price Swing Swap
 | Jan-02 Sumas Basis
 | [NAME] for MI
Spreadsheet: 47805d1246981359-help-with-when-the-end-result-is-value-food-intake-journal
Sheet: Monday

 | POINTS CALCULATOR
 | Bonus Points ==>
 | Daily Points Allowance ==> | 20 | Points Used Today ==> |  | 0 | Points Remaining ==> |  | 20
FIRST LETTER OF FOOD | Breakfast ==> | 0 | Lunch ==> | 0 | Dinner==> | 0 | Snacks ==> | 0
 |  | SERVING SIZE | QTY | CALORIES | FAT [NAME] | [NAME] | CALCULATED POINTS | ACTUAL POINTS | ADDITIONAL NOTES:
 | Breakfast
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 | Snacks
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 | Lunch
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 | Snacks
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 | Dinner
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 | Snacks
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
Spreadsheet: 274496d1383135066-return-values-from-other-columns-in-same-row-as-found-value-tate21420
Sheet: Sheet1

10647 | 1935-09-19 00:00:00 | 0 | 0.14 | 3.68 | 1104.06 | 1107.74 | 278891.34
10648 | 1935-09-20 00:00:00 | 0 | 0.14 | 3.81 | 1104.06 | 1107.87 | 278891.47
10649 | 1935-09-21 00:00:00 | 0 | 0.14 | 3.95 | 1104.06 | 1108.01 | 278891.61
10650 | 1935-09-22 00:00:00 | 1773.4 | 0.14 | 0 | -665.26 | -665.26 | 278891.74
10651 | 1935-09-23 00:00:00 | 0 | -0.08 | 0 | -665.34 | -665.34 | 278891.66
10652 | 1935-09-24 00:00:00 | 0 | -0.08 | 0 | -665.42 | -665.42 | 278891.58
10653 | 1935-09-25 00:00:00 | 0 | -0.08 | 0 | -665.5 | -665.5 | 278891.5
Spreadsheet: 732189d1620819309-xlookup-multiple-columns-xlookup
Sheet: Sheet2

I'm kindly asking for help on XLOOKUP (Multiple columns) formula for range H8: M12, matching data from O8:T12. I used this formula on H8 but failed to achieve good results:
IF(C2="","",XLOOKUP(C2,$Q8:$Q$14,$A$2:$A14,"Error"))
 |  |  |  |  |  |  | Desired Outcome
Date | Description | Reference | Revenue | Expense | Balance |  | Date | Description | Reference | Debit | Credit | Balance |  | Date | Description | Reference | Debit | Credit | Balance
2021-04-01 00:00:00 | 0 | 0 | 0 | 0 | 460 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-04-06 00:00:00 | CRAIG MAPHOSA | 14267 | 10000 | 0 | 10460 |  | 2021-04-06 00:00:00 | 11345728 | 14267 |  | 10000 | -10000 |  | 2021-04-09 00:00:00 | [NAME] | 7a | 1000 | 0 | -61745
2021-04-07 00:00:00 | Suspense Account | 14268 | 14650 | 0 | 25110 |  | 07/04/2021 | ZIPIT 844923 012FBTC21096A8WH | 14268 |  | 14650 | -24650 |  | 2021-04-08 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 14270 |  | 7375 | -7375
2021-04-07 00:00:00 | Suspense Account | 14269 | 8500 | 0 | 33610 |  | 07/04/2021 | 11353259 | 14269 |  | 8500 | -33150 |  | 07/04/2021 | ZIPIT 844923 012FBTC21096A8WH | 14268 |  | 14650 | -22025
2021-04-08 00:00:00 | THANDOLWENKOSI SAYI | 14270 | 0 | 0 | 33610 |  | 2021-04-08 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 14270 |  | 7375 | -40525 |  | 2021-04-06 00:00:00 | 11345728 | 14267 |  | 10000 | -32025
2021-04-09 00:00:00 | [NAME] | 7a | 1000 | 0 | 34610 |  | 2021-04-09 00:00:00 | [NAME] | 7a | 1000 | 0 | -39525 |  | 2021-04-13 00:00:00 | 12267998 | 14271 | 23375 | 0 | -31025
2021-04-12 00:00:00 | [NAME] | 8a | 450 | 0 | 35060 |  |  |  |  |  |  |  |  | 07/04/2021 | 11353259 | 14269 |  | 8500 | -39525
2021-04-13 00:00:00 | Suspense Account | 14271 | 23375 | 0 | 58435 |  | 2021-04-13 00:00:00 | 12267998 | 14271 | 23375 | 0 | -10200
Spreadsheet: 870703d1717167961-struggling-to-maintain-formatting-when-using-textjoin-sample-4-
Sheet: Sheet1

→ | → | ↓ |  |  |  |  |  |  | My attempts
 | INVOICE
 |  |  |  |  |  | Trying to get all 3 cols for all rows
 |  |  |  |  |  | Trying to get all 3 cols for all rows
 |  |  |  |  |  |  |  |  | Check both formulas below. Probably one returns error because of differences in system separators, but the other shall be fine
 | DATE | [NAME] |  |  |  |  | TOTAL
 | 2024-05-01 00:00:00 | Page 1 - Line 1 |  |  |  |  | 1
 | 2024-05-02 00:00:00 | Page 1 - Line 2 |  |  |  |  | 2
 | 2024-05-05 00:00:00 | Page 1 - Line 4 |  |  |  |  | 5
Spreadsheet: 050a559b-49d4-4796-9094-73c08b700901
Sheet: Sheet1

Unnamed: 0 | ELEMENTARY SCHOOL COUNSELOR TIME FORM | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Delivery System Component |  |  | Recommended Percentage |  |  | Current % of Time* |  | Year One Goal* |  | Year Two Goal*
 | [NAME] |  |  | (35-45%) | 35 |  | 0 |  | 100 |  | 0
 | Individual Student Planning |  |  | (5 - 10%) | 10 |  | 0 |  | 0 |  | 0
 | Responsive Services |  |  | (30-40%) | 40 |  | 0 |  | 0 |  | 100
 | System Support |  |  | (10-15%) | 15 |  | 100 |  | 0 |  | 0
 |  |  |  |  | 100 |  | 100 |  | 100 |  | 100
 |  |  |  |  |  |  | *These numbers are used for example only.
Spreadsheet: 290413d1389874192-reset-all-sorting-testing
Sheet: Front End

Want to rewrite formula in this column
[NAME] | [NAME] | [NAME]
Spreadsheet: 777278d1650293785-calculation-to-work-out-ticket-purchases-ticket-calculator
Sheet: TICKETS

 |  | TICKET A | TICKET B | TICKET C | TICKET D | TICKET E | TICKET F | TICKET G | TICKET H | TICKET I
 |  | 55 | 65 | 59 | 49.5 | 69 | 37.5 | 45 | 69 | 45
TICKET A | 55
TICKET B | 65
TICKET C | 59
TICKET D | 49.5
TICKET E | 69
TICKET F | 37.5
TICKET G | 45
TICKET H | 69
TICKET I | 45
Spreadsheet: 721966d1614967030-google-sheets-need-to-find-the-match-number-then-enter-the-text-find-the-match-number
Sheet: Sheet1

MATCHING NUMBER |  |  |  |  |  |  |  |  |  | [NAME] in this Column K:K to enter text "FOUND" if
1
2
3
4 |  |  |  |  |  |  |  |  |  | FOUND
5
6 |  |  |  |  |  |  |  |  |  | FOUND
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Spreadsheet: 28061d1221865359-vlookup-issue-example
Sheet: Sheet1

NAME | TRADE | $ |  |  |  |  | PLUMBING |  |  | ROOFING |  |  | ELECTRIC
 |  |  |  |  |  |  | Name | Bid |  | Name | Bid |  | Name | Bid
Able | Plumbing | 2500 |  |  | Over here --------->
Jornada | Roofing | 3700 |  |  | I would like to list
B&R | Plumbing | 2500 |  |  | all of my plumbers,
[NAME] | Electric | 2900 |  |  | i.e. cell H3 should
Legends | Roofing | 3900 |  |  | have "Able", cell
Provident | Electric | 2400 |  |  | H4 shoul have
[NAME]'s | Plumbing | 2700 |  |  | "B&R", cell H5
 |  |  |  |  | should have "[NAME]'s"
 |  |  |  |  | If it's not too much
 |  |  |  |  | trouble, I'd also like
 |  |  |  |  | to list their bids
 |  |  |  |  | using the same
 |  |  |  |  | method in the bid
 |  |  |  |  | column.
 |  |  |  |  | Thanks in advance!
Spreadsheet: 148071d1333127097-linking-tabs-on-a-spreadsheet-anticipating-adding-lines-and-adding-missing-data-sample-linked-worksheet
Sheet: Foundation

Foundation | Amount | Current Cycle | Next Cycle | Interim Report | Final Report | Proposal | Estimated Date of Decision | Internal Questions/Notes
Arkansas Program
Maple
Maple - carry over | 100000 | June 2011 - June 2013 | June 1, 2012 - June 1, 2013 |  | 2013-09-01 00:00:00
Windy Foundation | 60000 | Jan 1, 2012 - Dec 31, 2012 | Jan 1, 2013 - Dec 31, 2013 | 2012-09-01 00:00:00 |  | Sept 2012 - ish | 2012-12-01 00:00:00
Brothers Foundation | 40000 | Feb 2011 - Feb 2012 |  |  |  | 2012-03-01 00:00:00 | 2012-03-15 00:00:00
Spreadsheet: 263531d1378506459-trying-to-create-a-spreadsheet-with-3-variables-dummy-worksheet-letter-names
Sheet: Sheet4

Date | Name | Sum of Letters Learned
2013-09-02 00:00:00 | [NAME] | 1
 | [NAME] | 2
 | [NAME] | 2
 | [NAME] | 2
2013-09-09 00:00:00 | [NAME] | 2
 | [NAME] | 4
 | [NAME] | 4
 | [NAME] | 4
Spreadsheet: 720029d1613986890-shift-diff-timecard-untitled-spreadsheet
Sheet: HELP

 |  |  |  | H_DAYS: E3 to K9 |  | Start of Week
WEEKDAY | [NAME] | [NAME] |  | SUN | MON | TUE | WED | THU | FRI | SAT |  | 7th Day |  | END OF WEEK
SUN | True |  |  | 0 | 6 | 5 | 4 | 3 | 2 | 1 |  | SAT
MON | False |  |  | 1 | 0 | 6 | 5 | 4 | 3 | 2 |  | SUN |  | C_WK_END
TUE |  |  |  | 2 | 1 | 0 | 6 | 5 | 4 | 3 |  | MON
WED |  |  |  | 3 | 2 | 1 | 0 | 6 | 5 | 4 |  | TUE
THU |  |  |  | 4 | 3 | 2 | 1 | 0 | 6 | 5 |  | WED
FRI |  |  |  | 5 | 4 | 3 | 2 | 1 | 0 | 6 |  | THU
SAT | False |  |  | 6 | 5 | 4 | 3 | 2 | 1 | 0 |  | FRI
 |  |  |  | The table above gives number of days to go back to start of week (represented in E2 to K2), from current day (represented in A3 to A9)
L_WKDAYS
named range also used also to find the column (E2 to K2)
Spreadsheet: 885669d1735479600-column-of-referring-row-numbers-of-found-celvalue-question_rownumbers
Sheet: Blad2

 |  | Tbl_ 1 |  | KOP
 |  |  |  | HCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | HCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | HCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | TOTAAL
 |  | Tbl_2 |  | KOP
 |  |  |  | HCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | HCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | TOTAAL
 |  | Tbl_3 |  | KOP
 |  |  |  | HCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | HCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | SCAT
 |  |  |  | TOTAAL