tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 850556d1700920634-formular-to-shift-data-in-another-sheet-2mony
Sheet: SUMMARY

TAARIFA ZA AWALI |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | CODE | JAN | KIASI | FEB | KIASI | MAR | KIASI |  |  | APRIL | KIASI | MAY | KIASI | JUNI | KIASI |  |  | JULAI | KIASI | AGA | KIASI | SEPT | KIASI |  |  | OKT | KIASI | NOV | KIASI | DECE | KIASI
NO | ADA | PUNGUZO | ADA HALISI | DARASA | JINA LA MWANAFUNZI |  | DATE | 1 | DATE | 1 | DATE | 1 | BAKI | ROBO 1 | DATE | 1 | DATE | 1 | DATE | 1 | BAKI | ROBO 2 | DATE | 1 | DATE | 1 | DATE | 1 | BAKI | ROBO 3 | DATE | 1 | DATE | 1 | DATE | 1 | BAKI | ROBO 4 | JUMLA | MAONI
1
2
3
4
Spreadsheet: 866333d1713281976-of-vacant-units-using-2-pivot-tables-dynamic-sample-pivot
Sheet: Parking & Lockers - Data

Region | (All) |  |  |  | Region | (All)
Director | (All) |  |  |  | Director | (All)
OM | (All) |  |  |  | OM | (All)
Unit sub t | PARKING |  |  |  | Unit sub t | PARKING
Vacant | (All) |  |  |  | Vacant | X
Count of ID | Column Labels |  |  |  | Count of ID | Column Labels
Row Labels | Jan | Feb | Mar |  | Row Labels | Jan | Feb | Mar |  | Jan | Feb | Mar
A | 48 | 48 | 48 |  | D | 9 | 9 | 9
B | 40 | 40 | 40 |  | E | 151 | 130 | 36
C | 86 | 86 | 86 |  | F | 8 | 9 | 9
D | 68 | 68 | 68 |  | G | 103 | 87 | 83
E | 155 | 246 | 155 |  | Grand Total | 271 | 235 | 137
F | 63 | 63 | 63
G | 302 | 295 | 295
Grand Total | 762 | 846 | 755
Spreadsheet: benjamin_rogers__1160__Model5
Sheet: Wheatland

INCOME STATEMENT - WHEATLAND
('000 $) |  | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00
Capacity Prices ($/kW-mo)
Capacity Revenue from Desk (Real $)
Capacity Revenue from Desk (Nominal $)
Expense
Fuel |  | 0 | 0 | 0
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
Insurance
SG&A
Utility Start Up Power
Property, Other Taxes |  | 333.91852828968 | 303.4123888608 | 391.7823465846759
Mobilization |  | 921.914 | 0 | 0
Marketing Fee |  | 0 |  | 0
Administrative Fee
O&M Fees
Total Expense
EBITDA
Salvage Value |  | 0 | 0
Without Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
With Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | 2000-01-31 00:00:00 | 2000-02-22 00:00:00 | 2000-02-29 00:00:00 | 2000-03-31 00:00:00 | 2000-04-30 00:00:00 | 2000-05-31 00:00:00 | 2000-06-30 00:00:00 | 2000-07-31 00:00:00 | 2000-08-31 00:00:00 | 2000-09-30 00:00:00 | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00
Revenue (Real) | 0 | 0 | 0 | 0 | 0 | 0 | 6132.998 | 17649.772 | 19559.317 | 991.806 | 55.247 | 40.742 | 16.951 | 129.988 | 138.18 | 24.158 | 69.35 | 402.96 | 4645.94 | 12482.421 | 13268.746 | 816.816 | 86.536 | 56.981 | 27.589 | 167.381 | 168.763 | 38.141 | 99.721 | 415.869 | 3200.228 | 9057.747 | 9007.898 | 844.618 | 76.946 | 43.375 | 26.711
USD Libor |  |  | 0.0605681254028103 | 0.0605681254028103 | 0.0605681254028103 | 0.0614528938500749 | 0.062272420332016 | 0.0631418102820942 | 0.063791031540835 | 0.0644402529393635 | 0.0650281821846135 | 0.0655609806482027 | 0.0660765921541437 | 0.0665800294961341 | 0.0670369781793325 | 0.0674497060816499 | 0.0678640776304542 | 0.0681889253242094 | 0.0685246013111129 | 0.0688295340127438 | 0.0691069719563195 | 0.0693844099253584 | 0.0696329433757978 | 0.069856963974845 | 0.0700737581187561 | 0.07028720190671 | 0.0704860008481814 | 0.0706655611936435 | 0.0708378099668314 | 0.070965582403328 | 0.0710976139267086 | 0.0712170959618539 | 0.0713268914821796 | 0.0714366870064884 | 0.0715344306947476 | 0.0716232034710216 | 0.0717091126118303
Revenue (Nominal)
MW
Prices
 | Nominal Revenue | Capacity $
2000
2001
2002
Spreadsheet: 865139d1712202210-formula-that-will-pick-up-a-change-only-for-that-row-test3
Sheet: Expecting

 | Manual Entry |  | uses lookups |  | Assigns the Zone value in column D to each room that belongs to the same zone | Concats with columns H and J to form column I. Needed this to be able to create a unique instance in case I had rooms with identical names |  | Concatenated result. | uses lookups
 |  | Contains formulas | Contains formulas |  | Contains formulas | Contains formulas | Contains formulas | Contains formulas | Contains formulas
 | Number | Autofill | Layout |  | Helper Column | Helper Column | Helper Column | Helper Column | Rooms
 | ABC-DD- | Tag | Zone |  | 1 | 2 | 3 | 4
Group | 1 |  | A1 |  |  |  |  |  | Restroom 1
Group | 2 |  | A3 |  |  |  |  |  | Bed 1
Group but interupted.  if I insert a number here, cell H38 should update but without impacting the cell below, H39, which should still read ABC-DD-03 | 3 |  | A9 |  |  |  |  |  | Bed 1
 |  |  |  |  |  |  |  |  | Bed 2
 | 10 |  |  |  |  |  | ABC-DD-10 |  | Bed 3
 |  |  |  |  |  |  | ABC-DD-03 |  | Bed 3
Group | 8 |  | A6 |  |  |  |  |  | Kitchen
 |  |  |  |  |  |  |  |  | Dining
Group | 5 |  | A4 |  |  |  |  |  | Living 1
Group | 6 |  | A2 |  |  |  |  |  | Study
 |  |  |  |  |  |  |  |  | Lounge
 |  |  |  |  |  |  |  |  | Powder
 |  |  |  |  |  |  |  |  | Study 2
 |  |  |  |  |  |  | Final result
Spreadsheet: 883092d1731579145-linking-two-sheets-with-data-specific-information-job-book-test-1
Sheet: Job Book 

Job  Number | Client | Order Number | Job Details | Sample No | Prep | CL | HAC | A/C | MIX | A/S SO3 | W/S SO4 | tS | S2- | MCHW Sulphate Suite | [NAME] | Alkalis | Volhard | Paint | Water | C/S | Other | Date recieved | Due | Reported | Invoiced | Invoice No | Job Turnaround Time | Total Job Cost
22499 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-11-14 00:00:00
22500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-11-13 00:00:00
22501 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-05 00:00:00
22502 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-05 00:00:00
22503 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-03 00:00:00
22504 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-03 00:00:00
22505 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-04 00:00:00
22506 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-04 00:00:00
22507 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-09 00:00:00
22508 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-04 00:00:00
22509 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-10 00:00:00
22510 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-10 00:00:00
22511 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-10 00:00:00
 |  | Notes:
Spreadsheet: 169043d1342689910-creating-a-order-form-for-a-machine-hire-system-charge-calcs
Sheet: Sheet1

7 Day Charge Calcs
Weekend Usage box |  |  | √ | Means the system will charge for weekend use.
 |  |  | x | The system will not charge for weekend use.
 |  |  |  |  |  |  |  |  |  |  |  | There after £24.00 per day
 |  |  | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Days |  |  | 8 | 9 | 10
 |  |  | Charge | 35 | 60 | 85 | 100 | 120 | 144 | 168 |  | Charge |  |  | 192 | 216 | 240
 |  |  |  |  |  |  | Examples
Weekend Usage box |  |  |  | x |  |  |  | √ |  |  |  | x |  |  |  | √
Days Required |  |  | Friday | → | Monday |  | Friday | → | Monday |  | Wednesday | → | Monday |  | Wednesday | → | Monday
Number of days |  |  |  | 2 Day |  |  |  | 4 Day |  |  |  | 4 Day |  |  |  | 6 Day
Daily Charge |  |  |  | 60 |  |  |  | 100 |  |  |  | 100 |  |  |  | 144
Charge over 7 days |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Weekend Charge 20% of £168.00 |  |  |  | 0 |  |  |  | 33.6 |  |  |  | 0 |  |  |  | 33.6
Total |  |  |  | 60 |  |  |  | 133.6 |  |  |  | 100 |  |  |  | 177.6
Weekend Usage box |  |  |  | x |  |  |  | √ |  |  |  | x |  |  |  | √
Days Required |  |  | Monday | → | Wk on [NAME] |  | Monday | → | Wk on [NAME] |  | Monday | → | Wk on Wed |  | Monday | → | Wk on Wed
Number of days |  |  |  | 7 Day |  |  |  | 9 Day |  |  |  | 8 Day |  |  |  | 10 Day
Daily Charge |  |  |  | 168 |  |  |  | 168 |  |  |  | 168 |  |  |  | 168
Charge over 7 days |  |  |  | 0 |  |  |  | 48 |  |  |  | 24 |  |  |  | 72
Weekend Charge 20% of £168.00 |  |  |  | 0 |  |  |  | 33.6 |  |  |  | 0 |  |  |  | 33.6
Total |  |  |  | 168 |  |  |  | 249.6 |  |  |  | 192 |  |  |  | 273.6
 |  |  |  |  | x
 |  |  |  |  | →
 |  |  |  |  | 9 Day
 |  |  |  |  | 168
 |  |  |  |  | 48
 |  |  |  |  | 0 |  |  | TEST AREA
 |  |  |  |  | 216
 |  |  |  |  | 9 Day
 |  |  |  |  | #N/A
Spreadsheet: 476aa351-563c-4e40-a21a-0f51d2d19412
Sheet: Sheet1

Hoja de Formulación del Producto (Formulario PFS-02):  Utilice este formulario para cada producto que usted procesa o empaca  o para producto que le procesa a usted otro co-empacador. Se debe a alistar cada producto orgánico que se solicita para certificación. Sírvase llenar una [NAME] producto. Las comercializadores de productos que contengan productos con múltiples ingredientes orgánicos deben llenar este formulario solamente si les pertenecen las formulaciones para los productos [NAME] a comercializar.  El espacio en gris indica dónde se deben escribir los datos. No escriba cifras en los espacios en rojo- éstas [NAME]. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Nombre del producto (como debe aparecer en el certificado):
Tipo de proceso: | Manufactura |  | Reempaque |  | Sólo venta
Este producto se etiqueta | 100% Orgánico |  | Orgánico |  | Elaborado con  (70%+) |  | Sólo listado de ingredientes (<70%)
Este producto se empaca y se vende: | [NAME] |  | [NAME]
 | Nombres de la marca en la etiqueta |  |  |  |  |  | Ref. del Certificador en la etiqueta
Ingrediente | % de contenido [NAME] el ingrediente | % en la formulación |  |  | % orgánico real de ese ingrediente/producto
 |  |  |  |  | 0
 |  |  |  |  | 0 |  | Uso oficina de OTCO
 |  |  |  |  | 0
 |  |  |  |  | 0 |  | [NAME]:
 |  |  |  |  | 0 |  | [NAME]:
 |  |  |  |  | 0 |  | Aprobado por:
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0 |  | Cert. Internacional Solicitado
 |  |  |  |  | 0 |  | Marque con una X si se solicita
 |  |  |  |  | 0 |  | UE
 |  |  |  |  | 0 |  | Canadá (COR)
 |  |  |  |  | 0 |  | Equival. de Canadá
Sub-total del contenido exceptuando sal y agua
 |  |  | 0 |  | 0
 | Sal
Agua
 | Lista de ayudas de proceso utilizadas
Totales |  |  | 0
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Dr. Ahmed Al Shadwi

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation | 0.5
 |  | Procedure in the Clinics (After deducting direct and indirect expenses + OHE 5%) | 0.4
 |  | OR in the Clinics (After deducting direct and indirect expenses +OR Cost+OHE 5%) | 0.35
 |  | Marketing Cost | 0.5
Doctor Calculation
 |  | Gross Revenue
 |  | Doctor Consultation Revenue | 0
 |  | OHE (5%)
 |  | Net Consultation Revenue
 |  | Amount to be paid
 |  | Procedure Revenue | 0
 |  | Lab Fee | 0
 |  | Consumables (Implant 900) | 0
 |  | OHE (5%)
 |  | Net Procedure Revenue
 |  | Amount to be paid
 |  | OR in the Clinic Revenue | 0
 |  | OR Fees | 0
 |  | Consumables (Implant 900) | 0
 |  | OHE (5%)
 |  | Net OR in the Clinic Revenue
 |  | Amount to be paid
 |  | Total Amount to be Paid
 |  | Less Marketing Cost | 0
 |  | Net Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 354a534a-fefe-4f0d-826a-c93be2bb53ea
Sheet: Sheet1

Library Web Site Statistics  <http://www.uri.edu/library/> | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
2006-2007
Successful requests for pages (visits)
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | ANNUAL TOTAL
/library/ successful requests for pages (visits) | 300403 | 112209 | 101430 | 150438 | 147274 | 113131 | 83389 | 148475 | 138280 | 137237 | 130052 | 158002 | 1720320
uri.edu successful requests for pages (visits) | 5356762 | 2640023 | 2339367 | 2569848 | 2604337 | 2508292 | 2163419 | 2632943 | 2713023 | 2712129 | 2724419 | 3217860 | 34182422
/library/ visits as % of uri.edu visits | 0.05607921352488687 | 0.04250303879928319 | 0.043357882709297 | 0.05853964903760845 | 0.05654951720917838 | 0.04510280302293353 | 0.03854500676937755 | 0.05639127014903095 | 0.05096897446132967 | 0.05060120665351833 | 0.0477356823601656 | 0.0491015768243491 | 0.0503276216062162
/library/ distinct hosts served | 28180 | 13690 | 12359 | 15276 | 16685 | 13269 | 12931 | 16453 | 16137 | 15733 | 15037 | 17562 | 193312
uri.edu distinct hosts served | 517224 | 295530 | 233595 | 258200 | 268267 | 241861 | 265025 | 239800 | 263036 | 245048 | 280516 | 327693 | 3435795
/library/ distinct hosts served as % of uri | 0.05448316396764265 | 0.04632355429228843 | 0.05290781052676641 | 0.05916343919442293 | 0.06219549926006553 | 0.05486209020883896 | 0.04879162343175172 | 0.06861134278565471 | 0.06134901686461169 | 0.06420374783715843 | 0.05360478546678264 | 0.05359284452215946 | 0.05626412518791139
Spreadsheet: 860362d1708490345-looking-for-the-exact-value-of-sales-handling-customers-simulation-3-2021
Sheet: Sheet9

customer name | sales name | sales name 1st try |  |  | Sales Data
A |  |  |  |  | Number | Sales name | portion customers
B |  |  |  |  | 1 | aa | 1
C |  |  |  |  | 2 | ab | 3
D |  |  |  |  | 3 | ac | 10
E
F |  |  |  |  | CHECK
G |  |  |  |  | Sales name | portion customers
H |  |  |  |  | aa
I |  |  |  |  | ab
J |  |  |  |  | ac
K
L
M
N
*fill sales name based handling portion
*sales are free to handle any customer
Spreadsheet: phillip_m_love__30147__9910_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 9910
Regions | Consolidated Flash | DPR vs. Consol. [NAME] | DPR | Adj. To NGPL | Revised NGPL | Actuals | [NAME]
Central
Aruba
Northeast | 0 |  | 0 |  | 0 | 0
East- EGM
East-LRC
FT-East
Texas-EGM
Texas-HPLR
Texas-HPLC
FT-SouthTexas
West
Storage
Ontario
FT-Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Tab
 |  |  |  |  |  |  | 0
 |  |  |  |  |  | 3956539
Spreadsheet: 684214d1593193672-arranging-the-data-rearranging
Sheet: Expected Result

Particulars |  |  | a | b | c | d
25 |  |  | USA 2 | USA,2
45 |  |  | UK | UK Ltd | UK,Ltd | UK,West
21 |  |  | RAM
37 |  |  | [NAME] | [NAME]
12 |  |  | [NAME] | [NAME] |  | [NAME]
7 |  |  |  |  | Kapil
Spreadsheet: 487310d1478016839-simple-nested-lookup-book2
Sheet: Sheet1

[NAME] | Apples | Green |  |  |  | Orchard | Apples | Pears | Berries
[NAME] | Pears | Blue
[NAME] | Berries | Black
[NAME] | Apples | Red
[NAME] | Pears | Purple
[NAME] | Berries | Orange
Spreadsheet: 234378d1368084673-arrange-in-sequence-order-order-whith-selected-filter-book1
Sheet: Sheet1

name | selected filter 2
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
a001 | 2
a002 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
Spreadsheet: louise_kitchen__23838__2QYTD Orig
Sheet: East Gas

East Gas
Mid Year 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
DePaolis |  | Gas |  | East
[NAME] |  | Gas |  | East
Kaiser |  | Gas |  | East |  | 1459732
Muhl |  | Gas |  | East |  | 756363
Ferries |  | Gas |  | East
Concannon |  | Gas |  | East |  | 550919
Smith,[NAME] |  | Gas |  | East
Barbe |  | Gas |  | East |  | 447936.42
DeMoes |  | Gas |  | East |  | 150517
Hodge |  | Gas |  | East |  | 100279.16
Pereira |  | Gas |  | East |  | 96037
Singer |  | Gas |  | East
Goodell |  | Gas |  | East |  | 30600
Otto |  | Gas |  | East |  | 12940
[NAME] |  | Gas |  | East
[NAME] |  | Gas |  | East |  | 9800
Hendrickson |  | Gas |  | East |  | 7491
Jenkins |  | Gas |  | East |  | 6835
Boyle |  | Gas |  | East |  | 5979
Junek |  | Gas |  | East |  | 5609
[NAME] |  | Gas |  | East |  | 1500
[NAME] |  | Gas |  | East |  | 577
Feitler |  | Gas |  | East |  | 465
Black |  | Gas |  | East |  | 310
[NAME] |  | Gas |  | East |  | 261
Total
Spreadsheet: 760532d1640272607-error-with-min-if-formula-book1-1-
Sheet: Sheet1

 |  |  |  |  | Lowest | 2nd | 3rd
[NAME] | C | 12.07 |  | [NAME]
[NAME] | A | 9.49
GR-08 | C | 4.17
GR-08 | C | 2.45
GR-08 | C | 2.73
GR-09 | C | 49.56
GR-09 | C | 21.63
GR-01 | A | 154.84
GR-02 | A | 63
GR-03 | B | 174.57
GR-04 | C | 5.54
[NAME] | B | 26.26
GR-06 | B | 0.88
GR-07 | B | 13.89
GR-10 | A | 0.15
GR-11 | A | 0.1
GR-12 | C | 57.53
Spreadsheet: 55990d1256137135-solver-with-sumif-example-for-help
Sheet: Sheet1

 | 40000 | 95000
Project Name | Cost | NPV | Sumif
P1 | 10000 | 88000 | 0
P2 | 20000 | 50000 | 1
P3 | 20000 | 45000 | 1
P4 | 20000 | 95000 | 0
Spreadsheet: 68813d1269359068-vlookup-not-working-africa
Sheet: Sheet1

 |  | Cameroon | 1035 |  | FIFA World Cup qualification (CAF)
 |  | Cote d'Ivoire | 934 |  | First Round
 |  | Nigeria | 848 |  | [NAME] | - | Eritrea
 |  | Egypt | 832 |  | [NAME] | - | Guinea-Bissau
 |  | Algeria | 823 |  | Central African Republic | - | Seycelles
 |  | Ghana | 747 |  | Comoros | - | Comoros
 |  | [NAME] | 662 |  | Seycelles | - | Central African Republic
 |  | Gabon | 660
 |  | Burkino Faso | 650
 |  | Tunisia | 614 |  | Second Round
 |  | Benin | 532
 |  | Morocco | 477
 |  | Togo | 467 |  |  | Pot A | Pot B | Pot C | Pot D
 |  | Mozambique | 462 |  |  | Cameroon | Togo | Tanzania | Swaziland
 |  | Guinea | 458 |  |  | Cote d'Ivoire | Mozambique | Zimbabwe | Sierra Leone
 |  | Uganda | 455 |  |  | Nigeria | Guinea | Congo DR | Chad
 |  | Zambia | 380 |  |  | Algeria | Uganda | Rwanda | [NAME]
 |  | South Africa | 377 |  |  | Egypt | South Africa | Sudan | Central African
 |  | Senegal | 361 |  |  | Ghana | Senegal | Namibia | Djibouti
 |  | Angola | 337 |  |  | [NAME] | Zambia | Libya | Guinea
 |  | Cape Verde Islands | 331 |  |  | Gabon | Angola | Botswana | Seyche
 |  | Kenya | 327 |  |  | Burkino Faso | [NAME] | Gambia
 |  | [NAME] | 326 |  |  | Tunisia | Congo | Burundi
 |  | Congo | 320 |  |  | Benin | Cape Verde Islands | Ethiopia
 |  | Rwanda | 308 |  |  | Morocco | Kenya | Equatorial Guinea
 |  | Tanzania | 290
 |  | Congo DR | 271
 |  | Sudan | 268 |  | Group 1
 |  | Zimbabwe | 265
 |  | Namibia | 246
 |  | Libya | 232
 |  | Gambia | 223
 |  | Botswana | 219
 |  | Ethiopia | 204
 |  | Burundi | 195
 |  | Swaziland | 152
 |  | Equatorial Guinea | 152
 |  | Sierra Leone | 145
 |  | Chad | 130
 |  | [NAME] | 120
 |  | Madagascar | 105
 |  | Liberia | 92
0.2523787487635714 | 9 | Eritrea | 92 | 1
0.8959940558751456 | 3 | [NAME] | 92 | 2
0.9582208001202659 | 2 | Mauritania | 70 | 3
0.06712237513355745 | 10 | Somalia | 64 | 4
0.4683253888862078 | 6 | Comoros | 46 | 5
0.321178665936281 | 7 | Seycelles | 44 | 6
0.8100112166086582 | 4 | [NAME] | 40 | 7
0.9775088735007629 | 1 | Djibouti | 27 | 8
0.2708611501932086 | 8 | Guinea-Bissau | 19 | 9
0.5254480279889506 | 5 | Central African Republic | 4 | 10
Spreadsheet: 77117d1277574718-formula-calculation-based-on-yes-no-list-quote_analyser-1-
Sheet: Proof of INDIRECT sheet name

[NAME] for date progression begins in A4 | Sheet Name built using TEXT function | Get value in B2 in each sheet using INDIRECT | The INDIRECT reference for B2 in each sheet
 | Overview |  |  |  |  | These cells have different formulae from the rest of their column, or no formula
2010-06-28 00:00:00
 |  |  |  |  |  | If workbook is not yet created a #REF! error is returned
 |  |  |  |  |  | Displayed date format doesn't affect other functions
Spreadsheet: 181170d1347953190-help-with-personal-finance-template-fianance-spreadsheet
Sheet: nov12

November 2012
 | Commbank Credit Card |  | Bal: |  |  |  |  | This Months Budget
 | Date | Description | In/Out | Balance | Type | More Info |  | Item | Actual | Allocated
 |  |  |  |  |  |  |  | Clothing |  | 0
 |  |  |  |  |  |  |  | Electronics |  | 0
 |  |  |  |  |  |  |  | Entertainment |  | 0
 |  |  |  |  |  |  |  | Food |  | 0
 |  |  |  |  |  |  |  | Games |  | 0
 |  |  |  |  |  |  |  | Misc |  | 0
 |  |  |  |  |  |  |  | One-off |  | 0
 |  |  |  |  |  |  |  | Other |  | 0
 |  |  |  |  |  |  |  | Petrol |  | 0
 |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  | Salary
 |  |  |  |  |  |  |  | Savings
 |  |  |  |  |  |  |  | Expenditure
 | Date | Description | Cash Out | Balance | Type | More Info
 | Totals
Spreadsheet: 288882d1389332259-merging-rows-based-on-column-contents-orders-demo
Sheet: Sheet1

Order Number | Item Ordered
1889 | Ruler
2001 | Stapler
2001 | Pencil
2001 | Eraser
2456 | Flashlight
2555 | Ruler
3890 | Stapler
3890 | Staple Remover
4455 | Pencil
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: 5. Office Trend by Agency

FY 2013 Federal Real Property Charts
Office Square Feet by Agency†*
 | Square Feet
Agency | FY 2012 | FY 2013 | % Change
Agriculture | 21191199 | 20791426
Air Force** | 63581918 | 62739597
Army** | 138807655.255 | 140745176.075
Commerce | 2075752 | 2075358
Corps of Engineers** | 3852344 | 5236040.68
Defense/WHS** | 7230138 | 6515337
Energy | 20241213 | 20400214
Environmental Protection Agency | 261334 | 269197
General Services Administration | 383073177.93 | 388580391.69
Health and Human Services | 5264404.4 | 5597865.4
Homeland Security | 9243028.76 | 6761705.37
Interior | 15340171.985 | 15374855.34
Justice | 1554096 | 1434851
Labor | 1212477 | 1223993
National Aeronautics And Space Administration | 11576162 | 10247687
National Science Foundation | 596834 | 601044
Navy** | 61650360.48 | 61362324.29
Office of Personnel Management | 32717 | 26265
State | 24983288 | 25400236
State (USAID) | 1518984 | 1345117
Transportation | 4980940.3 | 5163810.3
Treasury | 3607798 | 3212919
Veterans Affairs | 16041124 | 16273865
Total
† All real property data from the CFO Act agencies required to submit data to the FRPP
*includes federal government owned, foreign government owned, museum trust, state government owned, and leased
** Department of Defense
Spreadsheet: 862843d1710423701-is-there-a-formula-to-change-this-date-i-imported-to-not-include-an-abbrev-of-the-month-sample-workbook
Sheet: Sheet1

Release Date | Time | Actual | Forecast | Previous
[NAME]) | 08:30:00 | 0.006 | 0.008 | -0.011
Feb 15, 2024 (Jan) | 09:30:00 | -0.008 | -0.002 | 0.004
Jan 17, 2024 (Dec) | 09:30:00 | 0.006 | 0.004 | 0.003
Dec 14, 2023 (Nov) | 09:30:00 | 0.003 | -0.001 | -0.002
Nov 15, 2023 (Oct) | 09:30:00 | -0.001 | -0.003 | 0.009
Oct 17, 2023 (Sep) | 08:30:00 | 0.007 | 0.003 | 0.008
Sep 14, 2023 (Aug) | 08:30:00 | 0.006 | 0.002 | 0.005