tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862396d1710151889-how-do-i-create-polynomial-coefficients-for-a-table-with-2-variable-inputs-polynomials-aligw
Sheet: Sheet1

 |  |  | Fan Speed
 |  |  | 1 | 0.8 | 0.6 | 0.4 | 0.2
 | Density Ratio | 0.2 | 0.5602681786444155 | 0.5242592146626477 | 0.4862250698137789 | 0.4459899534174349 | 0.4033571231574961
 |  | 0.4 | 0.7690471505528507 | 0.7462019507305976 | 0.7220719135659387 | 0.6965455120173826 | 0.6694979266780862
 |  | 0.6 | 0.8813066990653233 | 0.8688018306703822 | 0.8555936757206858 | 0.8416211872134858 | 0.8268160422508499
 |  | 0.8 | 0.9516895842186365 | 0.9464433274230571 | 0.9409020157935861 | 0.9350400378449242 | 0.9288287295834818
 |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | 1.2 | 1.035229615944395 | 1.039166939513177 | 1.043325702175934 | 1.047725125390672 | 1.052386721527437
 |  | 1.4 | 1.062063465303166 | 1.069054263945055 | 1.076438232233882 | 1.084249498262037 | 1.092526257683161
 |  | 1.6 | 1.083185696627049 | 1.092609524244377 | 1.102563357540156 | 1.113093202310873 | 1.124250547560015
 |  |  |  | Fan Speed = | 0.6
 |  |  |  | Density Ratio = | 0.8
 |  |  |  | Result = | 0.9409
Spreadsheet: 744802d1629458897-formula-need-to-find-matching-assets-in-another-table-and-sum-total-excel-please-help
Sheet: Sheet1

 | TABLE 1 |  |  |  |  |  | TABLE 2
 | Asset | Amount | Date |  |  |  | ASSET | HOLDINGS
 | XRP | 1000 | 2020-01-05 00:00:00 |  |  |  | XRP
 | ETH | 1.5 | 2020-03-05 00:00:00 |  |  |  | ETH
 | ETH | 2 | 2020-04-13 00:00:00 |  |  |  | IOTA
 | IOTA | 1200 | 2020-06-18 00:00:00 |  |  |  | ADA
 | ADA | 3000 | 2020-06-18 00:00:00 |  |  |  | BTC
 | ADA | 3500 | 2020-06-20 00:00:00
 | XLM | 2500 | 2020-09-29 00:00:00
 | XRP | 2600 | 2020-09-29 00:00:00 |  |  | Hi everyone, please help :)
 | BTC | 0.5 | 2020-09-29 00:00:00 |  |  | I need a forumula to place in column I , that will look at the asset under column H and sum up all the matching amounts from table 1
 | BTC | 0.3 | 2020-11-08 00:00:00 |  |  | So for example: Table 2 (I4) coloured in orange, should scan table 1 and sum all the amounts for XRP. This should total 10600
 | XRP | 7000 | 2021-04-06 00:00:00 |  |  | I think this will involve vlookup, match or Index somehow.
 |  |  |  |  |  | I need this formula, because the tables in my real excel document is huge. It would take a while to sum everything up individually.
 |  |  |  |  |  | Thanks
Spreadsheet: 0208db61-e963-43b7-98f3-67ad452ae351
Sheet: CALCULADORA

Tipos de Celda de las tablas "SITUACIÓN ACTUAL", "SITUACIÓN PREVISTA" y "CÁLCULO DEL AHORRO ENERGÉTICO PREVISTO" |  |  |  | Celdas en blanco | Para introducir los datos necesarios
 |  |  |  | Celdas calculadas | Se calculan automáticamente al introducir los datos en las celdas en blanco (no se pueden editar)
SITUACIÓN ACTUAL
MEJORA | ELEGIR COMBUSTIBLE/ELECTRICIDAD EMPLEADO | INDICAR CONSUMO DE COMBUSTIBLE/ELECTRICIDAD ANUAL PARA LA MEJORA PROPUESTA |  |  | CÁLCULO DE LA ENERGÍA FINAL TÉRMICA  ANUAL | CÁLCULO DE LA ENERGÍA FINAL ELÉCTRICA ANUAL | CÁLCULO DE LAS EMISIONES DE CO2 ASOCIADAS AL CONSUMO DE ENERGÍA FINAL |  | CÁLCULO DE LAS TONELADAS EQUIVALENTES DE PETRÓLEO
Nº | Combustible/ Electricidad | Unidad | [NAME] anual [[NAME]/año] | [NAME] anual [kg/año] | Consumo térmico anual [kWh/año] | Consumo eléctrico anual [kWh/año] | Emisiones [gCO2/año] | Emisiones [tCO2/año] | teps de consumo final de energía [tep/año]
A | [NAME] Nº1 | [NAME] | 1000
B | Electricidad | kWh | 1000
C
D
E
F
G
H
I
J
K
L
M
N
O
 | TOTAL
SITUACIÓN PREVISTA
MEJORA | ELEGIR COMBUSTIBLE/ELECTRICIDAD EMPLEADO | INDICAR CONSUMO DE COMBUSTIBLE/ELECTRICIDAD ANUAL PARA LA MEJORA PROPUESTA |  |  | CÁLCULO DE LA ENERGÍA FINAL TÉRMICA  ANUAL | CÁLCULO DE LA ENERGÍA FINAL ELÉCTRICA ANUAL | CÁLCULO DE LAS EMISIONES DE CO2 ASOCIADAS AL CONSUMO DE ENERGÍA FINAL |  | CÁLCULO DE LAS TONELADAS EQUIVALENTES DE PETRÓLEO
Nº | Combustible/Electricidad | Unidad | [NAME] anual [[NAME]/año] | [NAME] anual [kg/año] | Consumo térmico anual [kWh/año] | Consumo eléctrico anual [kWh/año] | Emisiones [gCO2/año] | Emisiones [tCO2/año] | teps de consumo final de energía [tep/año]
A | [NAME] Nº1 | [NAME] | 500
B | Electricidad | kWh | 500
C
D
E
F
G
H
I
J
K
L
M
N
O
 | TOTAL
CÁLCULO DEL AHORRO ENERGÉTICO PREVISTO
MEJORA | AHORRO ANUAL DE ENERGÍA FINAL TÉRMICA |  | AHORRO ANUAL DE ENERGÍA FINAL ELÉCTRICA |  | AHORRO TOTAL ANUAL DE ENERGÍA FINAL |  | EMISIONES DE CO2 EVITADAS ANUALMENTE | CONSUMO ACTUAL ASOCIADO A LAS MEJORAS CON AHORRO
Nº | Ahorro energía térmica anual [kWh/año] | Ahorro energía térmica anual [tep/año] | Ahorro energía eléctrica anual [kWh/año] | Ahorro energía eléctrica anual [tep/año] | Ahorro energía total anual* [kWh/año] | Ahorro energía total anual* [tep/año] | Emisiones evitadas [tCO2/año] | Consumo energía actual [kWh/año]
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
TOTAL
* Revise nº de mejora: revise [NAME] o el combustible/[NAME], porque si se numeran dos filas con la misma letra [NAME] SITUACIÓN ACTUAL, ambas tienen que ser para ELECTRICIDAD o ambas tienen que ser [NAME]
Spreadsheet: 774653d1648586251-trying-to-get-a-listed-output-based-on-certain-criteria-excel-help
Sheet: SPD Orders

SKU | QTY | Size | Customer | Process Order | Ship Date | Grade
20015425 | 19 | 2205 | [NAME] | 10677781 | 2022-04-01 00:00:00 | 5
20503083 | 57 | 2150 | Moe | 10677864 | 2022-04-02 00:00:00 | 1
20506191 | 19 | 2200 | Curly | 10677865 | 2022-04-03 00:00:00 | 2.5
20506191 | 19 | 2200 | Moe | 10677866 | 2022-04-01 00:00:00 | 2.5
20506191 | 19 | 2200 | [NAME] | 10677867 | 2022-04-01 00:00:00 | 2.5
20015676 | 69 | 2000 | [NAME] |  | 2022-04-02 00:00:00 | DA
20015400 | 19 | 2250 | Moe | 10677777 | 2022-04-01 00:00:00 | 1
20019276 | 825 | 50 | Moe | 10677521 | 2022-04-03 00:00:00 | 1
20015424 | 825 | 50 | [NAME] | 10677924 | 2022-04-04 00:00:00 | 5
20015424 | 825 | 50 | Curly | 10677925 | 2022-04-01 00:00:00 | 5
20506191 | 19 | 2200 | [NAME] | 10677942 | 2022-04-01 00:00:00 | 2.5
20506191 | 19 | 2200 | [NAME] | 10677943 | 2022-04-02 00:00:00 | 2.5
20506191 | 19 | 2200 | [NAME] | 10677944 | 2022-04-02 00:00:00 | 2.5
20015447 | 825 | 50 | Curly | 10677958 | 2022-04-03 00:00:00 | 5
20015447 | 825 | 50 | Moe | 10677959 | 2022-04-02 00:00:00 | 5
Grade 1
[NAME] to list the Process order of only Grade 1, with the earliest ship date first, then customer.
Grade 2.5
Grade 5
Spreadsheet: 798351d1664439128-return-entire-row-excel-file
Sheet: Sheet 1

Product ID |  |  | Brand | Product name
5005991 |  |  |  | TR DIALPRIM 001 5 L
5008489 |  |  | Trimental | TR STELOXINE PRIMER NON FERRO WIT 500 ML
5008490 |  |  | Sikkens | TR STELOXINE PRIMER NON FERRO WIT 2,5 L
5008492 |  |  | Trimental | TR STELOXINE PRIMER NON FERRO GREY 500ML
5008493 |  |  | Trimental | TR STELOXINE PRIMER NON FERRO GREY 2,5 L
5008623 |  |  | Trimental | TR STELOXINE DECOR SATIN RAL 9010 500 ML
5008624 |  |  | Sikkens | TR STELOXINE DECOR SATIN RAL 9005 500 ML
5008637 |  |  | Sikkens | TR STELOXINE DECOR SATIN RAL 9010 2,5 L
5008638 |  |  | Trimental | TR STELOXINE DECOR SATIN RAL 9005 2,5 L
5016372 |  |  | Trimental | TR STELFLOOR TRAFFIC PAINT WIT 5 L
5016373 |  |  | Trimental | TR STELFLOOR TRAFFIC PAINT GEEL 5 L
5016378 |  |  | Sikkens | TR STELFLOOR ERGESOL WIT/001 5 L
5016380 |  |  | Sikkens | TR STELFLOOR ERGESOL 201 5 L
5016382 |  |  | Trimental | TR STELFLOOR ERGESOL 906 5 L
5016383 |  |  | Sikkens | TR STELFLOOR ERGESOL 910 5 L
5034809 |  |  | Trimental | TR SILVANOL LM 720 1 L
5034810 |  |  | Sikkens | TR SILVANOL LM 721 1 L
5034811 |  |  | Sikkens | TR SILVANOL LM 724 1 L
5034812 |  |  | Trimental | TR SILVANOL LM 726 1 L
Spreadsheet: 0592168d-ac0c-41ea-bfd5-0e79d61748ed
Sheet: Policy decisions

Basis and assumption within model
Rate of staff delivering is it cost of backfill or actual cost of staff involved |  |  |  |  |  |  | -
Currency risk is ignored within the model
Definition of Years | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
 | 2012-13 | 2013-14 | 2014-15 | 2015-16 | 2016-17 | 2017-18
Inflation rate defined
 | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Inflation Pay | 0 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02
Other costs | 0 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02
Income | 0 | 0 | 0.02 | 0.02 | 0.02 | 0.02
Compounded Interest
 | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Inflation Pay
Other costs
Income
Scholarship / bursary rate
% of income | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
Overhead Rate
% of Total Staff Costs | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4
1st year withdrawal rate |  | 0.08
2-4th year Withdrawal / non completion rate |  | 0.05
Commission Rate |  | 0.1
Franchise Cost % Fee if relevant |  | 0
PAS Group Feedback
Also could have different rate for placement year? |  |  |  | Assumptions for placement year Yes or no?
Add support costs on staff costs
Spreadsheet: monika_causholli__28132__Viva Chile!
Sheet: Paper

Source: RISI
Last Updated: June 22, 2001
Company | [NAME] | Grade | 2000 | 2001 | 2002 | 2003 | 2004
CMPC | Laja | UFS | 40 | 40 | 40 | 40 | 40
 | Puente Alto | UFS | 67 | 67 | 67 | 67 | 67
 |  | CFS | 12 | 12 | 14 | 14 | 18
 |  | CGW | 1 | 1 | 1 | 1 | 1
 | Nacimiento | News | 200 | 200 | 200 | 200 | 200
 | San Fran. Mostazol | UFS | 10 | 10 | 10 | 10 | 10
 |  | CFS | 5.4 | 5.4 | 5.4 | 7.4 | 7.4
 | Concepcion | NEWS | 120 | 120 | 120 | 120 | 140
 |  | UFS | 25 | 25 | 32 | 46 | 59
Miscellaneous |  | UFS | 25 | 25 | 32 | 46 | 59
 |  | UFS
 |  | CFS
 |  | CGW
 |  | News
Spreadsheet: 85308d1285331579-how-to-extract-names-that-are-flagged-by-red-dots-book2-vlookup-2-
Sheet: Sheet2

Special duty |  |  |  | Aug 30th | Aug 31st | Sept 1st | Sept 2nd | Sept 3rd | Sept 4th | Sept  5th | Sept 7th | Sept 10th | Sept 13th | Sept 17th | Sept 19th | Sept 20th | Sept 21st | Sept 22nd | Sept 23rd | Sept 24th | Sept 25th | Sept 28th | Sept 29th | Sept 30th | Oct 1st | Oct 2nd | Oct 5th | Oct 6th
#` | # | NAME | POSITION
 | 3210 | A
 | 3250 | B
 | 3270 | C
 | 3820 | D
 | 3840 | E
 | 3310 | F
 | 3311 | G
 | 3312 | H
 | 3313 | I
 | 3314 | J
 | 3350 | K
 | 3351 | L
 | 3352 | M
 | 3353 | N
 | 3354 | P
 | 3370 | Q
 | 3371 | R
 | 3372 | S
 | 3373 | T
 | 3374 | U
 | 3921 | V
 | 3922 | W
 | 3830 | X
 | 3931 | Y
 | 3932 | Z
 | 3941 | A
 | 3942 | B
 | 3860 | C
 | 3961 | D
 | 3962 | E
Spreadsheet: 776508d1649767934-detecting-duplicate-and-assigning-unique-id-test-d
Sheet: Expected Result

 | SN | Data | ID
 | 65 | 2022-03-10 00:00:00 | 65
 | 65 | 2022-03-10 00:00:00 | 65
 | 65 | 2022-03-10 00:00:00 | 65
 | 36 | 2022-03-12 00:00:00 | 36
 | 65 | 2022-03-30 00:00:00 | 65-D1
 | 65 | 2022-03-30 00:00:00 | 65-D1
 | 49 | 2022-04-02 00:00:00 | 49
 | 49 | 2022-04-04 00:00:00 | 49-D1
 | 65 | 2022-04-09 00:00:00 | 65-D2
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 3-1-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 |  |  |  |  | 0 | 0
 | Daily Total |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 | 0 |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 | 0 |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
Spreadsheet: 270645d1381565817-formula-for-multiple-matches-to-sum-result-from-another-column-into-another-sheet-sum-multiple-lookup-example
Sheet: JUL 13

 |  | Jul 2013 |  |  |  |  |  |  | YTD
GL Code | Account | Actual | Budget | Actual vs Budget $Difference | Actual vs Budget %Diff | LY | Actual vs LY $Difference | Actual vs LY %Diff | Actual | Budget | Actual vs Budget $Difference | Actual vs Budget %Diff | LY | Actual vs LY $[NAME] | Actual vs LY %Diff
6-2200 |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
6-2400 |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
6-2401 |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
6-2440 |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
6-2441 |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
Spreadsheet: 190196d1351554004-multiple-formulas-needed-in-one-cell-to-create-a-value-in-a-new-cell-media-tracking-sheet
Sheet: Media Summary Sheet

Region/Store | Type of Event | Date(s) | Avg Daily Sales | Medium | TV Supplier | Radio Supplier | Spend | Reach (%) | 3+ Frequency (%) | TARPS | Spots | Result (1-5) | Feedback
Melbourne | Sale |  | 6335 | TV | Nine Network
Newcastle | Sale |  | 3674 | Radio |  | KOFM
Gold Coast | Sale |  | 3765 | TV | Prime7
Brisbane | Campaign |  | 4342 | Radio |  | 97.3
Gold Coast | Campaign |  | 3473 | Radio |  | SeaFM
Perth | Sale |  | 2895 | TV | WIN |  |  |  |  |  |  |  |  |  | Legend | Legend 1 | Legend 2 | Legend 3 | Legend 4 | Legend 5 | Legend 6 |  | Radio
Gold Coast | Sale |  | 5543 | Radio |  | ATN |  |  |  |  |  |  |  |  | ACT | 1 | TV | NBN | 97.3 | 0-50% | 0-40% |  | ACTRadio | AdelaideRadio | BrisbaneRadio | Gold CoastRadio | MelbourneRadio | NewcastleRadio | PerthRadio | SydneyRadio
Sydney | Campaign |  | 6431 | TV | Seven Network |  |  |  |  |  |  |  |  |  | Adelaide | 2 | Radio | Network Ten | 92.9 | 50-60% | 40-50% |  | ATN | ATN | ATN | ATN | ATN | ATN | ATN | ATN
Gold Coast | Sale |  | 4635 | Radio |  | Gold FM |  |  |  |  |  |  |  |  | Brisbane | 3 |  | Nine Network | 104.7 | 60-70% | 50-60% |  | 104.7 | Mix | Triple M | Gold FM | FOX FM | KOFM | 92.9 | 2Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gold Coast | 4 |  | Prime7 | 2Day | 70-80% | 60-70% |  | Mix | Nova | 97.3 | Hot Tomato | Gold FM | NXFM | Mix | Nova
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Melbourne | 5 |  | SCA | 96FM | 80-100% | 70-100% |  |  | SAFM | Beat 105 | SeaFM | Mix |  | Nova | Mix
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Newcastle |  |  | Seven Network | ATN |  |  |  |  |  | Nova |  | Nova |  | 96FM | WSFM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perth |  |  | WIN | Beat 105
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney |  |  |  | Fox FM |  |  |  | TV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gold FM |  |  |  | ACTTV | AdelaideTV | BrisbaneTV | Gold CoastTV | MelbourneTV | NewcastleTV | PerthTV | SydneyTV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hot Tomato |  |  |  | Prime7 | Network Ten | Nine Network | NBN | Network Ten | NBN | Network Ten | Network Ten
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KOFM |  |  |  | SCA | Seven Network | Seven Network | Prime7 | Nine Network | Prime7 | Seven Network | Nine Network
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mix |  |  |  | WIN | WIN | Network Ten | SCA | Seven Network | SCA | WIN | Seven Network
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nova
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NXFM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAFM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sea FM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Triple M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WSFM
Spreadsheet: 143295d1330354698-extraxting-data-from-database-to-a-better-lay-out-example
Sheet: Blad1

Sheet 1: |  | 1 | 2 | 3 | 4 | 5
 | a | a1 | a2 | a3 | a4 | a5
 | b | b1 | b2 | b3 | b4 | [NAME]
 | c | c1 | c2 | c3 | c4 | c5
 | d | d1 | d2 | d3 | d4 | d5
Sheet 2: |  |  |  | Choose Row: |  | d
 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 768387d1644943789-xml-help-is-requested-urgently-xml-format
Sheet: ITEM SEG

Commodity_code | Precision_1 | Precision_2 | Precision_3 | Invoice Description [line 3] | CoO | INVOICE VALUE [FCY] | PREF | Extended_Customs_procedure | CPC3 | SUPP QTY | GROSS MASS [KG] | NET MASS [KG] | Number_of_Packages | Kind_of_Packages_code
85182100 | 1 | 0 | 0 | HEMNES N CHEST/8 DRW WHITE STAIN | PL | 4589.95 |  | 4000 | 000 | 41 | 1862.888 | 1839.947 | 41 | PS
Spreadsheet: 220037d1363038588-formula-to-produce-sequential-number-for-multiple-suppliers-load-number-calculation
Sheet: Sheet1

Collection Date | Saw Mill | Load No | Collection company | Delivery note no. | Delivery date
2013-02-13 00:00:00 | Sage | 1 | ABC | SP23
2013-02-14 00:00:00 | [NAME] | 1 | 123 | SP24
2013-02-15 00:00:00 | Sage | 2 | Petras | SP25
2013-02-15 00:00:00 | [NAME] | 2 | ABC | SP26
2013-02-16 00:00:00 | [NAME] | 1 | ABC | SP27
2013-02-17 00:00:00 | [NAME] | 2 | 123 | SP28
2013-02-18 00:00:00 | Sage | 3 | Petras | SP29
2013-02-21 00:00:00 | [NAME] |  | 123 | SP30
2013-02-21 00:00:00 | [NAME] |  | Petras | SP31
2013-02-23 00:00:00 | Sage |  | ABC | SP32
2013-02-24 00:00:00 | [NAME] |  | Petras | SP33
Spreadsheet: 740930d1626704163-auto-calculate-end-date-sample
Sheet: Sheet2

Job | Allocated Hours | start date | End Date | Date | Day | Working hours
Job A | 40 | 2021-07-19 10:35:00 | ?? | 2021-07-19 00:00:00 |  | 7
Job B | 40 | 19/19/2021  14:00:00 | ?? | 2021-07-20 00:00:00 |  | 7
Job C | 50 | 2021-07-19 09:00:00 | ?? | 2021-07-21 00:00:00 |  | 7
 |  |  |  | 2021-07-22 00:00:00 |  | 7
 |  |  |  | 2021-07-23 00:00:00 |  | 0
 |  |  |  | 2021-07-24 00:00:00 |  | 0
 |  |  |  | 2021-07-25 00:00:00 |  | 0
 |  |  |  | 2021-07-26 00:00:00 |  | 7
 |  |  |  | 2021-07-27 00:00:00 |  | 7
 |  |  |  | 2021-07-28 00:00:00 |  | 7
 |  |  |  | 2021-07-29 00:00:00 |  | 0
 |  |  |  | 2021-07-30 00:00:00 |  | 7
 |  |  |  | 2021-07-31 00:00:00 |  | 7
 |  |  |  | 2021-08-01 00:00:00 |  | 0
 |  |  |  | 2021-08-02 00:00:00 |  | 7
 |  |  |  | 2021-08-03 00:00:00 |  | 7
 |  |  |  | 2021-08-04 00:00:00 |  | 7
 |  |  |  | 2021-08-05 00:00:00 |  | 7
 |  |  |  | 2021-08-06 00:00:00 |  | 0
 |  |  |  | 2021-08-07 00:00:00 |  | 7
 |  |  |  | 2021-08-08 00:00:00 |  | 0
 |  |  |  | 2021-08-09 00:00:00 |  | 7
 |  |  |  | 2021-08-10 00:00:00 |  | 7
 |  |  |  | 2021-08-11 00:00:00 |  | 7
 |  |  |  | 2021-08-12 00:00:00 |  | 7
 |  |  |  | 2021-08-13 00:00:00 |  | 7
 |  |  |  | 2021-08-14 00:00:00 |  | 7
 |  |  |  | 2021-08-15 00:00:00 |  | 7
Spreadsheet: 856633d1705838703-compare-planned-vs-actual-values-monthly-and-generate-a-table-20240121_o365_compare-planned-vs-actuals-excelforum-windknife-2
Sheet: Comparison

 | Activity | Month | Plan | Actual | Cum.Plan | Cum.Actual | Actual > Plan | [NAME] | Cumulative Variance | Actuals to cover Previous Months Backlog |  |  | Plan As of | 2023-03-01 00:00:00
 | Activity 1 | 2023-01-01 00:00:00 | 100 | 150 |  |  | 50 | 50 | 50 | 0 |  |  | Actual As of | 2023-05-30 00:00:00
 | Activity 1 | 2023-02-01 00:00:00 | 200 | 200 |  |  | 0 | 0 | 50 | 0
 | Activity 1 | 2023-03-01 00:00:00 | 300 | 600 |  |  | 300 | 300 | 350 | 0
 | Activity 2 | 2023-01-01 00:00:00 | 0 | 100 |  |  | 100 | 100 | 100 | 0
 | Activity 2 | 2023-02-01 00:00:00 | 200 | 0 |  |  | 0 | -200 | -100 | 0
 | Activity 2 | 2023-03-01 00:00:00 | 0 | 250 |  |  | 250 | 250 | 150 | 100
 | Activity 3 | 2023-03-01 00:00:00 | 200 | 0 |  |  | 0 | -200 | -200 | 0
 | Activity 3 | 2023-04-01 00:00:00 | 0 | 100 |  |  | 100 | 100 | -100 | 100
 | Activity 3 | 2023-05-01 00:00:00 | 0 | 50 |  |  | 50 | 50 | -50 | 50
 |  |  |  |  |  |  |  |  |  |  |  | Activity | Month | Plan | Actual | Actual > Plan | [NAME] | Cumulative Variance | Actuals to cover Previous Months Backlog
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 100 | 150 | 50 | 50 | 50 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Activity 1 | 2023-02-01 00:00:00 | 200 | 200 | 0 | 0 | 50 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Activity 1 | 2023-03-01 00:00:00 | 300 | 600 | 300 | 300 | 350 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Activity 2 | 2023-01-01 00:00:00 | 0 | 100 | 100 | 100 | 100 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Activity 2 | 2023-02-01 00:00:00 | 200 | 0 | 0 | -200 | -100 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Activity 2 | 2023-03-01 00:00:00 | 0 | 250 | 250 | 250 | 150 | 100
 |  |  |  |  |  |  |  |  |  |  |  | Activity 3 | 2023-03-01 00:00:00 | 200 | 0 | 0 | -200 | -200 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Activity 3 | 2023-04-01 00:00:00 | 0 | 100 | 100 | 100 | -100 | 100
 |  |  |  |  |  |  |  |  |  |  |  | Activity 3 | 2023-05-01 00:00:00 | 0 | 50 | 50 | 50 | -50 | 50
Spreadsheet: 114107d1309959273-mass-copy-1-template-to-another-old-version-example
Sheet: Operation 050

 | Part # | JI-84401397 |  | Work Center | SPOT WELD
 | Revision | A |  | Operation | 050
 |  |  |  |  | Sheet 1 of 1
 | Dimension | Weld Nut Alignment
 | Tolerance | Go/NoGo |  |  |  |  | Job Number
 | Measurment [NAME] | Verify that a bolt or thread gauge will properly thread into and pass through the weld nuts and respective holes
 |  |  |  |  |  |  | Initials | Date
 | 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
 | 1. Inspection frequency to follow [NAME] WI-0035
 | 2. When form is complete, place in tray outside of QA door.
 | 3.
 | 4.
 | 5.
 | 6.
 | 7.
 | 8.
 | 9.
 | 10.
Spreadsheet: 767431d1644477531-converting-source-data-to-simplified-data-pq-transform-investment-aligw
Sheet: Source

Items | Purpose Code | Institutional Sector | Country | Currency Code
Direct Investment (Exposure with Related Counterparty)
a. Equity Capital
 | - | - | - | -
[NAME]
 | - | - | - | -
[NAME] and Notes
 | - | - | - | -
d. Money Market Instruments
 | - | - | - | -
e. Non-Participating RPS
 | - | - | - | -
f. Others
 | 39900 | FA | JP | USD
 | 39900 | NF | AU | USD
 | 39900 | NF | HK | USD
 | 39900 | NF | KY | USD
 | 39900 | NF | KY | USD
Portfolio Investment
a. Equity Securities
 | - | - | - | -
[NAME] and Notes
 | - | - | - | -
c. Money Market Instruments
 | - | - | - | -
Other Investment (Exposure with Non-related Counterparty)
a. Currency
 | - | - | - | -
[NAME]
 | - | - | - | -
c. Suppliers Credit
 | 31220 | IC | AE | AED
 | 31220 | IC | AE | EUR
 | 31220 | IC | AE | SAR
d. Others
 | - | - | - | -