tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: randall_gay__31447__gda
Sheet: Sheet1

07:00:00
January |  |  |  | Financial GDA
 | Physical | Physical GDA | IntraWest | Southwest | Northwest | Position
Blanco | 110086 |  | -9000 | 10000 | 0
Permian | 14773 | 0 | -14000 | 20000 | 0
Rockies
Northwest | -7802 | -5000 | 55000 | 0 | 0
CIG | 0 | 0 | 13000 | 0 | 0
Questar | 0 | 0 | 0 | 0 | 0
WIC | 0 | 0 | 0 | 0 | 0
Trailblazer | 0 | 0 | 0 | 0 | 0
Malin | -35781 | 0 | 100000 | 0 | 0
Stanfield | -20157 | 0 | 0 | 0 | 0
AECO | 0 | 0 | 0 | 0 | 0
Waha | 0 | 0 | 0 | 0 | 0
Socal* | 0 | 0 | -80000 | 0 | 0
PG&E Topock | 0 | 0 | 0 | 0 | 0
PG&E Citygate** | 14743 | 0 | 0 | 0 | 0
Sumas | 30000 | 0 | 10000 | 0 | 0
NGPL/OK | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | -40000 | -30000 | 0
PEPL | 0 | 0 | 0 | 0 | 0
Totals:
Total Position:
* Assumes 174.000 of New capacity
** Assumes no Baja Path transport
Spreadsheet: 790532d1659771034-search-table-given-dates-and-numbers-as-criteria-help_please
Sheet: Sheet1

VOLUME DISCOUNT PER ITEM TABLE BASED ON INVOICE DATE
VOLUME PER ITEM: |  | 30000 | <<-- GIVEN | CHANNEL: |  | EU | <<-- GIVEN
INVOICE DATE: |  | 2022-01-15 00:00:00 | <<-- GIVEN | VOLUME DISCOUNT: |  |  | <<<--- HELP W/ THIS FORMULA
 |  |  |  | EXCEL 365 FORMULA: |  |  | <<<--- OK
The above EXCEL 365 [NAME] works fine. However, I need a working formula for those not running Excel 365. I need help @ G3 - To search a table with date ranges and number ranges using INDEX MATCH or other ways.
SORT DATE THEN VOL ASCENDING
VOL | FR_DATE | TO_DATE | EU | DL | DR | TB | PL | RM
0 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.03 | 0 | 0 | 0 | 0 | 0
5000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.06 | 0 | 0 | 0 | 0 | 0
10000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.09 | 0 | 0 | 0.03 | 0.03 | 0
15000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.12 | 0 | 0 | 0.06 | 0.06 | 0
20000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.09 | 0.09 | 0
25000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.12 | 0.12 | 0
30000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.15 | 0.15 | 0
999999999 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.15 | 0.15 | 0
0 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.02 | 0 | 0 | 0 | 0 | 0
5000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.04 | 0 | 0 | 0 | 0 | 0
10000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.06 | 0 | 0 | 0.02 | 0.02 | 0
15000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.08 | 0 | 0 | 0.04 | 0.04 | 0
20000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.06 | 0.06 | 0
25000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.08 | 0.08 | 0
30000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
999999999 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
Spreadsheet: 220994d1363345685-need-help-with-ranking-sample
Sheet: Sheet2

A | B
a1 | 13
a2 | 2
a3 | 4
a4 | 1
a5 | 4
a6 | 6
 |  |  | Top A | B
 |  |  | a1 | 13
 |  |  | a6 | 6
 |  |  | a3 | 4
 |  |  | a5 | 4
Spreadsheet: 678524d1589938669-years-minus-year-months-days-helpdata
Sheet: Sheet1

Service years | Breaks in Service in days | Breaks YMD | Actual Years
25 | 869
20 | 602
40 | 150
20 | 547
25 | 386
20 | 578
30 | 345
20 | 278
30 | 239
25 | 356
35 | 301
45 | 725
25 | 487
35 | 318
35 | 323
20 | 210
20 | 190
30 | 30
40 | 20
30 | 389
20 | 807
Spreadsheet: 371141d1421564942-separate-data-from-master-list-to-different-work-sheet-process-document
Sheet: 10

SL NO | SHEET NO. | DRAWING ZONE | Part Name |  |  |  | Date : |  | INSPECTED BY |  | RESULT
 |  |  | Part Number |  |  |  | M/C No : |  | I : |  | Acc. | R/W | Rej.
 |  |  | Dwg. Rev.No. |  |  |  |  |  | II : |  | Acc. | R/W | Rej.
 |  |  | Inspection Type | Set up / Regular |  |  |  |  | III : |  | Acc. | R/W | Rej.
 |  |  | Opn. No.: | Description: M/cing |  |  |  | "I" Shift |  | "II" Shift |  | "III" Shift
 |  |  | Parameter | Units | Lower | Upper | Method of  Insp | Reading |  | Reading |  | Reading
 |  |  |  |  | Spec Limit | Spec Limit |  | # |  | # |  | #
1 | - | - | Visual  Orientation | - | - | - | Visual
2 | 1 | D4 | Ø4.0H7(+0.012) | [NAME] | 4 | 4.012 | PPG
3 | 1 | D4 | 25° | deg | 24°30' | 25°30' | 3D MH
4 | 1 | C1 | 9.5 | [NAME] | 9.3 | 9.7 | MH
5 | 1 | [NAME] | 137 | [NAME] | 136.8 | 137.2 | MH
6 | 1 | D1 | 25° | deg | 24°30' | 25°30' | 3D MH
7 | 1 | C1 | M5 | - | - | - | TPG
Spreadsheet: 695882d1600441081-auto-update-funtions-in-excel-jewels-sales-estimat
Sheet: EST001

STAR JEWELLERY
10, GOLD SOUQ COMPLEX, NAGAPATTINAM
TEL: 04365 247830
CUSTOMER DETAILS: |  |  |  |  |  |  |  | Date :
Mr/Mrs. [NAME] |  |  |  |  |  |  |  | Est No:
 |  |  |  |  |  |  |  | Gold Per Grm : | 4920 | Gold rate will change day by day as per jelwes association
 |  |  |  |  |  |  |  | Silver Per Grm : | 70 | Silver rate will change day by day as per jewels association
ESTIMATE
S.No. | PRODUCT | PCS | PURITY | WT | Metal | WASTAGE | RATE | ADDITION | AMOUNT
1 | Chain | 1 |  | 2 |  |  |  | 500 |  | This is METAL format value
2 | Ring | 1 | 916 | 2 |  | 10 |  | 500 |  | This is WASTAGE format valve but both are same value result
3 | Nanal | 1 | NK | 2 |  |  |  | 500 |  | This is NK purity value
4 | Thali | 1 | NK | 2 |  |  |  | 500 |  | This is NK purity value but bott or same value result
5 | ACPL Chain | 1 | 92.5 | 10 |  |  | 250 | 500 |  | This is ACPL product value
6 | Silver Chain | 1 |  | 10 |  | 10 |  | 500 |  | This is WASTAGE format valve
 |  |  |  |  |  |  |  | Total |  | The amount cell value will change automatically by METAL or WASTAGE or PRODUCT NAME  all in one value
 |  |  | Auto update purity |  |  |  | Auto update rate
 |  |  | If [NAME] the purity is "92.5" |  |  |  | If purity 916 or NK the rate is "4920"
 |  |  | If SILVER the purity is "72" |  |  |  | IF SILVER the rate is "70"
 |  |  | If NANAL, THALI the purity is "NK" |  |  |  | If [NAME] the rate is "250" |  | ACPL product rate is fixed by ourselves
 |  |  | If other product the purity is "916"
Spreadsheet: 33679d1230250366-problem-with-showing-rows-and-columns-in-a-pivot-table-pivot-20table-20example-1-1
Sheet: Piviot Table

Sum of Exp 1 |  | Sum of Exp 2 |  | Sum of Exp 3 |  | Sum of Exp 4 |  | Sum of Exp 5
Article ID | Total | Article ID | Total | Article ID | Total | Article ID | Total | Article ID | Total
1 | 0.02 | 6 | 1.051 | 1 | 0.25 | 1 | 0.35 | 1 | 0.65
2 | 1.02 | Grand Total | 1.051 | 2 | 0.65 | 2 | 0.15 | 2 | 0.95
3 | 0.52 |  |  | 3 | 0.28 | 3 | 0.3 | 3 | 0.62
4 | 0.2 |  |  | 4 | 0.18 | 4 | 0.45 | 4 | 0.85
5 | 1.36 |  |  | 5 | 1.8 | 5 | 2.02 | 5 | 2.24
6 | 1.52 |  |  | 6 | 0.582 | 6 | 0.113 | 6 | -0.356
7 | 0.52 |  |  | 7 | 1.812 | 7 | 2.458 | 7 | 3.104
8 | 0.48 |  |  | 8 | 2.082 | 8 | 2.883 | 8 | 3.684
9 | 0.09 |  |  | 9 | 2.702 | 9 | 4.008 | 9 | 5.314
10 | 1.62 |  |  | 10 | 1.402 | 10 | 1.293 | 10 | 1.184
11 | 18 |  |  | 11 | -14.748 | 11 | -31.122 | 11 | -47.496
12 | 0.98 |  |  | 12 | 2.502 | 12 | 3.263 | 12 | 4.024
13 | 1.01 |  |  | 13 | 2.702 | 13 | 3.548 | 13 | 4.394
Grand Total | 27.34 |  |  | Grand Total | 2.196000000000001 | Grand Total | -10.286 | Grand Total | -20.838
Spreadsheet: 102676d1300657570-inventory-help-iventorymain
Sheet: beer

Item # | Beersoda | Unit Price | Qty in |  |  |  |  | qty sold | Actual | Date
200 | Tecate Red Can/store | 20 | 48
201 | Tecate Light Can/store | 20
202 | [NAME]/store | 25
203 | Bohemia Bottle/store | 30
204 | Bohemia Obscuro/store | 30
205 | [NAME]/store | 25
206 | XX Amber/store | 25
206 | Coco cola can/store | 10
207 | Coca Light Can/store | 10
208 | Sprite Can/store | 10
209 | Fresca Can/store | 10
210 | Naranja Can/store | 10
211 | Aqua Mineral 355ml | 10
212 | Coca Cola 2L/store | 22
213 | Coca Light 2L/store | 22
214 | Sprite 2L/store | 22
215 | Fresca 2L/store | 22
216 | Naranja 2L/store | 22
217 | Aqua Mineral 2L/store | 22
Spreadsheet: 863579d1711015922-drop-down-list-with-number-and-letters-causing-valu-result-in-total-sample-wb
Sheet: Jan

 | 2024-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Weekdays | Weekend | Holiday | C-SL | U-SL | ML | PL | OL
 |  | Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C-SL | U-SL | OL | PL | ML |  |  | 1 |  | 1 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Answer should be>> |  |  |  |  | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 888654d1739222071-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 32

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 30 Dec Glucose mmol/L
Sun 31 Dec Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 1 Jan Glucose mmol/L
 |  |  |  |  |  | 5.7
Tue 2 Jan Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  |  |  | 6.6
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 3 Jan Glucose mmol/L
Thu 4 Jan Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 5 Jan Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Sat 6 Jan Glucose mmol/L
Spreadsheet: 167022d1341869760-matching-columns-examplewriteoff
Sheet: Sheet1

Customer A | Customer Payment Balance | Customers with Credit balance | Credit Balance | Credits? | More Credits than Payment Balance?
100 | 100 | 100 | 150
200 | 300 | 200 | 50
300 | 200 | 300 | 300
400 | 500 | 600 | 200
500 | 150 | 700 | 125
600 | 200
700 | 300
800 | 150
900 | 250
1000 | 400
 | Does customer have credits?
 | Do the credits outweigh payment balance?
Spreadsheet: 63629d1264523414-formatting-words-to-change-colours-book1-1
Sheet: Sheet1

 | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
A | [NAME] | 0.85 | 0.75 | 0.94 | 0.94 | 0.83 | 0.99 | 0.96 | 0.97 | 0.89 | 0.91 | 0.79 | 0.85 |  | Target: | 0.9
 | Rich | 0.99 | 0.94 | 0.83 | 0.89 | 0.94 | 0.89 | 0.96 | 0.99 | 0.94 | 0.96 | 0.99 | 0.83
 | [NAME] | 0.83 | 0.79 | 0.94 | 0.94 | 0.99 | 0.83 | 0.79 | 0.89 | 0.99 | 0.94 | 0.83 | 0.89
 | [NAME] | 0.83 | 0.79 | 0.89 | 0.99 | 0.83 | 0.99 | 0.94 | 0.83 | 0.89 | 0.96 | 0.99 | 0.94
 | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
B | [NAME] | 0.85 | 0.75 | 0.94 | 0.94 | 0.83 | 0.99 | 0.96 | 0.97 | 0.89 | 0.91 | 0.79 | 0.85 |  | Target: | 0.9
 | Rich | 0.99 | 0.94 | 0.83 | 0.89 | 0.94 | 0.89 | 0.96 | 0.99 | 0.94 | 0.96 | 0.99 | 0.83
 | [NAME] | 0.83 | 0.79 | 0.94 | 0.94 | 0.99 | 0.83 | 0.79 | 0.89 | 0.99 | 0.94 | 0.83 | 0.89
 | [NAME] | 0.83 | 0.79 | 0.89 | 0.99 | 0.83 | 0.99 | 0.94 | 0.83 | 0.89 | 0.96 | 0.99 | 0.94
 | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
C | [NAME] | 0.85 | 0.75 | 0.94 | 0.94 | 0.83 | 0.99 | 0.96 | 0.97 | 0.89 | 0.91 | 0.79 | 0.85 |  | Target: | 0.9
 | Rich | 0.99 | 0.94 | 0.83 | 0.89 | 0.94 | 0.89 | 0.96 | 0.99 | 0.94 | 0.96 | 0.99 | 0.83
 | [NAME] | 0.83 | 0.79 | 0.94 | 0.94 | 0.99 | 0.83 | 0.79 | 0.89 | 0.99 | 0.94 | 0.83 | 0.89
 | [NAME] | 0.83 | 0.79 | 0.89 | 0.99 | 0.83 | 0.99 | 0.94 | 0.83 | 0.89 | 0.96 | 0.99 | 0.94
Spreadsheet: 790282d1659624305-vlookup-with-ifs-inside-tables-in-multiple-workbooks-pto-tracking-test
Sheet: Davis, Tiffany

[NAME], Tiffany |  | 40.87
 | Start Date: | 2019-03-01 00:00:00
 | Accrual | 144
 | Update Accrual: | 2024-03-01 00:00:00
 |  | ACC RATE |  | EARNED |  | USED |  | BALANCE |  | Value
 | Pay Period - Week Ending | PTO Days |  | PTO |  | PTO |  | PTO
 | Beginning Balance |  |  |  |  |  |  | 122.82
17 | 2022-08-12 00:00:00 |  |  |  |  | 0
18 |  |  |  |  |  | 0
19 |  |  |  |  |  | 0
20 |  |  |  |  |  | 0
21 |  |  |  |  |  | 0
22 |  |  |  |  |  | 0
23 |  |  |  |  |  | 0
24 |  |  |  |  |  | 0
25 |  |  |  |  |  | 0
26 |  |  |  |  |  | 0
Spreadsheet: drew_fossum__8873__pnmdrew
Sheet: Sheet1

Albuquerque Project
Route 1:  Shortest route, no river crossing, ROW status uncertain
Route 2:  Railroad corridor option, river crossing, ROW secured
Route 3:  Westernmost route, river crossing, ROW secured
(routes 2 and 3 are the original routes proposed by Langley/Tino)
Potential Project Rates: |  |  |  | Project Cost Estimates +/- 30%
Route 1: | 100,000/d | 150,000/d |  | 19979601
5 yr. K | 0.235 | 0.16
10 yr. K | 0.1615 | 0.11
Route 2: | 100,000/d | 150,000/d |  | 24164524
5 yr. K | 0.285 | 0.19
10 yr. K | 0.195 | 0.13
Route 3: | 100,000/d | 150,000/d |  | 25859121
5 yr. K | 0.305 | 0.205
10 yr. K | 0.21 | 0.14
Current PNM rates:
Large volume customers:
0.0336 | per therm transmission |  |  |  | per MMBtu = tariff rate to beat
0.0312 | per therm distribution   >>>> |  |  | assume load would remain on PNM's distribution
0.0648 | total rate per therm
$800. Per month access fee
Notes:
To what extent does PNM discount rates?  Anything above variable cost, margins c/b slim, they'll
discount (sometimes deeply) to keep customer from leaving the system.
[NAME] is checking into how to get copies of discounts to me.  [NAME].
Facility Planning spoke with Tino Menaldo 1/10 about the shortest route (Option 1) and the high cost of
a river crossing.  [NAME], et.al, was unaware of the high costs of a river crossing and of a shorter route.
He will survey the area soon and check to see if their rights with the [NAME] cover this route 1.
Spreadsheet: 736017d1623320368-formula-to-keep-track-of-id-cards-expiration-dates-expiration-dates
Sheet: Sheet2

Customer_id | doc_name | Document Type | status | expiration_date
30450113 | POIF_RC | PROOF_OF_ID_FRONT | approved | 2021-05-30 03:00:00
30450113 | POIF_RC | PROOF_OF_ID_FRONT | approved | 2030-06-01 03:00:00
30448201 | POIF_ID | PROOF_OF_ID_FRONT | approved | 2022-11-14 02:00:00
30448201 | POI_PPT | PROOF_OF_ID | approved | 2025-01-22 02:00:00
30446441 | POIF_ID | PROOF_OF_ID_FRONT | approved | 2030-03-15 02:00:00
30445937 | POI_ID | PROOF_OF_ID | approved | 2028-03-25 02:00:00
Spreadsheet: 805416d1668674654-a-woodworker-in-need-of-help-with-if-function-with-sum-as-a-condition-new-template-2022-v2-etaf-v3
Sheet: Test Template

Material Cost
 |  | Price per unit |  |  |  |  |  |  | Primary Wood | [NAME] |  |  |  |  |  | K2 = Wood type
 |  |  |  |  |  |  |  |  | Secondary Wood | [NAME] |  |  |  |  |  | K22 = wood thickness |  | 0.076 |  |  | When I start an estimate I first choose the material the customer wants. This is selected in L2. If there are two matierals the secondary material is chosen is field L3. Then as I consider the elements of the furniture piece I specify (starting in I9) which material each element is made from. What I would like to acheive is that fields in column P, from P22 down are populated based on the List of lumber prices I have in the worksheet called "Wood Prices". The formula needs to take the name of the material from L2 and the thickness of the material from column k, starting at K22 and then populate P22 with the corresponding price from the "Wood Prices" worksheet. However, somehow I need to reference the column I9-16 so that if there are two materials in the piece it prices both differently. God i hope thats clear, Im just fried my brain writing it.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.038
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.027
 |  |  |  |  |  |  |  | Final Dimensions
Drawer runners | 3 | 18
Tooling | 1 | 35 |  |  |  |  |  | Wood | Element | Quantity | Length |  | [NAME] | Thickness | m2
 |  | Total |  |  |  |  |  | 1st | Top/Bottom | 1 | 1 |  | 1.4 | 0.045
Labor Cost |  |  |  |  |  |  |  | 1st | Walls | 2 | 0.8 |  | 0.8 | 0.03
Time |  | Price per minute |  |  |  |  |  | 1st | Back | 1 | 3 |  | 0.8 | 0.01
Processing |  | 5 |  |  |  |  |  | 1st | Legs | 4 | 0.5 |  | 0.05 | 0.05
Cutting All pieces | 3 | 40 |  |  |  |  |  | 2nd | Sttrecther | 2 | 2.8 |  | 0.1 | 0.05
Drawers | 6 | 40 |  |  |  |  |  | 1st | Rails | 2 | 0.8 |  | 0.05 | 0.05
Glue up | 6 | 30 |  |  |  |  |  | 1st | Seperations | 2 | 0.8 |  | 0.8 | 0.02
Sanding | 5 | 30 |  |  |  |  |  | 1st | Doors | 3 | 1 |  | 0.8 | 0.02
Finish | 10 | 20
Assemply and cutting joints | 4 | 40
Delivery | 0 | 350 |  |  | RAW LUMBER
Stacking | 0 | 100
 |  | Total |  |  |  |  |  |  | length | thickness | width | [NAME] | quantity | m2 | m3 | Price/m3 | Price | [NAME]
Shop Costs |  | 14 |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
 |  | Construction Total |  |  |  |  |  |  | 3.6 |  | 0.18
 |  | Profit |  |  |  |  |  |  | 3.6 |  | 0.18
 |  | Total |  |  |  |  |  |  | 3.6 | 0.015 | 0.18
 |  | IVA |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 | 1 | 0.18
 |  |  |  |  |  |  |  |  | ETAF - CALC
 |  |  |  |  |  |  |  |  | Widths needed
Spreadsheet: 866558d1713469325-vat-calculation-product-list
Sheet: TXNS

I'm kindly requesting a formula to calculate VAT using the information on the product list worksheet.
Description |  |  |  | Qty | Price | VAT | Total (exc VAT)
Bottled Water |  |  |  | 2 |  | 0.15
Coke |  |  |  | 3 |  | 0.54
Fertiliser |  |  |  | 6 |  | 0
Heater |  |  |  | 3 |  | 6.75
Screwdrive |  |  |  | 2 |  | 0
Spreadsheet: 7f130bf4-4bb5-4e56-98c5-56d40e234503
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
35948170 | 2013-05-15 03:40:54 | AXIS | 1 | 6 | 1 | 677297 | [NAME] schwarzenegger | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
35948338 | 2013-05-15 03:53:58 | ALLIES | 1 | 6 | 1 | 677297 | [NAME] schwarzenegger | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: f915f5b0-fdeb-438e-9e76-2b364fece5f8
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
44430352 | 2014-12-13 22:56:59 | ALLIES | 1 | 10 | 7 | 635250 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44430890 | 2014-12-13 23:37:45 | AXIS | 1 | 10 | 6 | 635250 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44459757 | 2014-12-15 22:25:02 | ALLIES | 0 | 6 | 10 | 754357 | Maréchal Davout | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44460540 | 2014-12-15 23:13:24 | AXIS | 1 | 10 | 7 | 754357 | Maréchal Davout | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 03162683-c702-443e-9c61-3923e120b623
Sheet: Sheet1

Angebotskalkulation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Nr.:
Grunddaten |  |  |  | Bearbeiter:
Besteller: |  |  |  | Telefon:
 |  |  |  | Fax:
 |  |  |  | Anfrage vom:
Objekt: |  |  |  | [NAME] am:
 |  |  |  | Liefertermin:
Auflage:
Umfang:
Endformat: |  |  |  | offen:
Papier:
[NAME]:
Vorlagen - analog:
Vorlagen - digital:
[NAME]:
Technische Daten
[NAME]:
Ausschießschema:
[NAME]:
[NAME]:
Druckform (CtP/CtF):
Druck:
[NAME]:
[NAME]:
Fremdleistungen:
Sonstiges:
Lieferung:
Spreadsheet: phillip_allen__28799__granhous1
Sheet: riddle

 | Assumptions
 | Purchase price |  | 2800000
 | Interest |  | 0.08
 | Years |  | 30
 | Downpayment |  |  |  |  |  | Annual Rent
 | Closing Cost |  |  |  |  |  | Operating Exp
 | Downpayment % |  | 0.2
 |  |  |  |  |  |  | NOI
 |  |  | Monthly | Annual
 | Payment
 | Taxes |  |  |  | x |  | Purchase Price
0.05 | Management |  |  |  | x
 | Utilities |  | -1000 |  | x |  | [NAME]
 | Insurance |  | -1000 |  | x
 | Maintenance |  | -1200 |  | x
 | Operating Expenses
 | Rent
 | Monthly Net
 | Annual Net
 | Annual Return
 |  |  | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
 |  | Rent
 |  | Mortgage
 |  | Taxes
 |  | Management
 |  | Utilities
 |  | Insurance
 |  | Maintenance
 |  | rent-exp
 |  | cash outlay |  |  |  |  | -50000 |  |  |  |  | -50000 |  |  |  |  | -50000
 |  | net cash
 |  | 15 year irr |  | 410000
 |  |  |  | 0.12
msft |  |  | -410000
 |  | Interest Exp.
 |  | Payments
 |  | Principal
 |  | Prin. Bal
 |  | NOI
 |  | interest
 |  | deprec
 |  | taxable
Spreadsheet: d1dc4f14-b309-4b3b-bd01-08746a418323
Sheet: Vendor 8

C R I T E R I A | Total Possible Score |  |  |  |  |  |  |  |  |  |  | Average
Qualification Requirements
Understanding the Problem |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Professional Personnel |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Soundness of Approach |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Terms and Conditions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Available Facilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Value Added Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Evaluation of Costs
Cost Rating
Total Qualification Requirements
Oral Presentation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Score
Spreadsheet: 824608d1680707631-how-to-populate-a-list-without-gaps-based-on-criteria-sheet_alvpin_2
Sheet: BASE

ID | Employee | Team | other info
212456 | [NAME] | 1
221636 | Sophie | 1
447952 | [NAME] | 2
454555 | [NAME] | 3
560725 | [NAME] | 1
609511 | [NAME] | 1
652188 | Serge | 1
652368 | [NAME] | 2
656874 | Georges | 1
658519 | Lili | 2
707757 | [NAME] | 2
732990 | [NAME] | 3
785889 | [NAME] | 1
824227 | [NAME] | 1
945636 | [NAME] | 3
Spreadsheet: 852825d1702797347-combine-saveral-column-into-1-column-sample-excel-1
Sheet: Sheet1

Component number | Qty | Where use |  | Combine to | Component number | Where use
3967 | 1 | 30010 |  |  | 3967 | 30010, 20300
1222 | 1 | 20030 |  |  | 3970 | 20300
3970 | 1 | 20300 |  |  | 1222 | 20010, 20020, 20030, 20040
1222 | 1 | 20010
1222 | 1 | 20020
1222 | 1 | 20010
1222 | 1 | 20010
3967 | 1 | 20300
1222 | 1 | 20020
3967 | 1 | 30010
1222 | 1 | 20040
3967 | 1 | 20300
1222 | 1 | 20020